1
0.34 ms
SELECT t0 . username AS username_1 , t0 . username_canonical AS username_canonical_2 , t0 . enabled AS enabled_3 , t0 . password AS password_4 , t0 . last_login AS last_login_5 , t0 . password_reset_token AS password_reset_token_6 , t0 . password_requested_at AS password_requested_at_7 , t0 . email_verification_token AS email_verification_token_8 , t0 . verified_at AS verified_at_9 , t0 . roles AS roles_10 , t0 . email AS email_11 , t0 . email_canonical AS email_canonical_12 , t0 . created_at AS created_at_13 , t0 . updated_at AS updated_at_14 , t0 . id AS id_15 , t0 . first_name AS first_name_16 , t0 . last_name AS last_name_17 , t0 . locale_code AS locale_code_18 , t0 . mollie_onboarding_completed AS mollie_onboarding_completed_19 , t20 . type AS type_21 , t20 . path AS path_22 , t20 . id AS id_23 , t20 . owner_id AS owner_id_24 FROM sylius_admin_user t0 LEFT JOIN sylius_avatar_image t20 ON t20 . owner_id = t0 . id WHERE t0 . id = ?
SELECT t0 . username AS username_1 , t0 . username_canonical AS username_canonical_2 , t0 . enabled AS enabled_3 , t0 . password AS password_4 , t0 . last_login AS last_login_5 , t0 . password_reset_token AS password_reset_token_6 , t0 . password_requested_at AS password_requested_at_7 , t0 . email_verification_token AS email_verification_token_8 , t0 . verified_at AS verified_at_9 , t0 . roles AS roles_10 , t0 . email AS email_11 , t0 . email_canonical AS email_canonical_12 , t0 . created_at AS created_at_13 , t0 . updated_at AS updated_at_14 , t0 . id AS id_15 , t0 . first_name AS first_name_16 , t0 . last_name AS last_name_17 , t0 . locale_code AS locale_code_18 , t0 . mollie_onboarding_completed AS mollie_onboarding_completed_19 , t20 . type AS type_21 , t20 . path AS path_22 , t20 . id AS id_23 , t20 . owner_id AS owner_id_24 FROM sylius_admin_user t0 LEFT JOIN sylius_avatar_image t20 ON t20 . owner_id = t0 . id WHERE t0 . id = 3 ;
Copy
2
0.41 ms
SELECT t0 . code AS code_1 , t0 . name AS name_2 , t0 . color AS color_3 , t0 . description AS description_4 , t0 . enabled AS enabled_5 , t0 . hostname AS hostname_6 , t0 . created_at AS created_at_7 , t0 . updated_at AS updated_at_8 , t0 . id AS id_9 , t0 . theme_name AS theme_name_10 , t0 . tax_calculation_strategy AS tax_calculation_strategy_11 , t0 . contact_email AS contact_email_12 , t0 . contact_phone_number AS contact_phone_number_13 , t0 . skipping_shipping_step_allowed AS skipping_shipping_step_allowed_14 , t0 . skipping_payment_step_allowed AS skipping_payment_step_allowed_15 , t0 . account_verification_required AS account_verification_required_16 , t0 . shipping_address_in_checkout_required AS shipping_address_in_checkout_required_17 , t0 . default_locale_id AS default_locale_id_18 , t19 . code AS code_20 , t19 . created_at AS created_at_21 , t19 . updated_at AS updated_at_22 , t19 . id AS id_23 , t0 . base_currency_id AS base_currency_id_24 , t25 . code AS code_26 , t25 . created_at AS created_at_27 , t25 . updated_at AS updated_at_28 , t25 . id AS id_29 , t0 . default_tax_zone_id AS default_tax_zone_id_30 , t0 . menu_taxon_id AS menu_taxon_id_31 , t0 . shop_billing_data_id AS shop_billing_data_id_32 , t0 . channel_price_history_config_id AS channel_price_history_config_id_33 FROM sylius_channel t0 INNER JOIN sylius_locale t19 ON t0 . default_locale_id = t19 . id INNER JOIN sylius_currency t25 ON t0 . base_currency_id = t25 . id WHERE t0 . hostname = ? AND t0 . enabled = ? ORDER BY t0 . id ASC LIMIT 1
Parameters :
[
"webshop.scherstra.com "
1
]
SELECT t0 . code AS code_1 , t0 . name AS name_2 , t0 . color AS color_3 , t0 . description AS description_4 , t0 . enabled AS enabled_5 , t0 . hostname AS hostname_6 , t0 . created_at AS created_at_7 , t0 . updated_at AS updated_at_8 , t0 . id AS id_9 , t0 . theme_name AS theme_name_10 , t0 . tax_calculation_strategy AS tax_calculation_strategy_11 , t0 . contact_email AS contact_email_12 , t0 . contact_phone_number AS contact_phone_number_13 , t0 . skipping_shipping_step_allowed AS skipping_shipping_step_allowed_14 , t0 . skipping_payment_step_allowed AS skipping_payment_step_allowed_15 , t0 . account_verification_required AS account_verification_required_16 , t0 . shipping_address_in_checkout_required AS shipping_address_in_checkout_required_17 , t0 . default_locale_id AS default_locale_id_18 , t19 . code AS code_20 , t19 . created_at AS created_at_21 , t19 . updated_at AS updated_at_22 , t19 . id AS id_23 , t0 . base_currency_id AS base_currency_id_24 , t25 . code AS code_26 , t25 . created_at AS created_at_27 , t25 . updated_at AS updated_at_28 , t25 . id AS id_29 , t0 . default_tax_zone_id AS default_tax_zone_id_30 , t0 . menu_taxon_id AS menu_taxon_id_31 , t0 . shop_billing_data_id AS shop_billing_data_id_32 , t0 . channel_price_history_config_id AS channel_price_history_config_id_33 FROM sylius_channel t0 INNER JOIN sylius_locale t19 ON t0 . default_locale_id = t19 . id INNER JOIN sylius_currency t25 ON t0 . base_currency_id = t25 . id WHERE t0 . hostname = 'webshop.scherstra.com' AND t0 . enabled = 1 ORDER BY t0 . id ASC LIMIT 1 ;
Copy
3
0.19 ms
SELECT COUNT (* ) FROM sylius_channel t0
SELECT COUNT (* ) FROM sylius_channel t0 ;
Copy
4
0.46 ms
SELECT t0 . code AS code_1 , t0 . name AS name_2 , t0 . color AS color_3 , t0 . description AS description_4 , t0 . enabled AS enabled_5 , t0 . hostname AS hostname_6 , t0 . created_at AS created_at_7 , t0 . updated_at AS updated_at_8 , t0 . id AS id_9 , t0 . theme_name AS theme_name_10 , t0 . tax_calculation_strategy AS tax_calculation_strategy_11 , t0 . contact_email AS contact_email_12 , t0 . contact_phone_number AS contact_phone_number_13 , t0 . skipping_shipping_step_allowed AS skipping_shipping_step_allowed_14 , t0 . skipping_payment_step_allowed AS skipping_payment_step_allowed_15 , t0 . account_verification_required AS account_verification_required_16 , t0 . shipping_address_in_checkout_required AS shipping_address_in_checkout_required_17 , t0 . default_locale_id AS default_locale_id_18 , t19 . code AS code_20 , t19 . created_at AS created_at_21 , t19 . updated_at AS updated_at_22 , t19 . id AS id_23 , t0 . base_currency_id AS base_currency_id_24 , t25 . code AS code_26 , t25 . created_at AS created_at_27 , t25 . updated_at AS updated_at_28 , t25 . id AS id_29 , t0 . default_tax_zone_id AS default_tax_zone_id_30 , t0 . menu_taxon_id AS menu_taxon_id_31 , t0 . shop_billing_data_id AS shop_billing_data_id_32 , t0 . channel_price_history_config_id AS channel_price_history_config_id_33 FROM sylius_channel t0 INNER JOIN sylius_locale t19 ON t0 . default_locale_id = t19 . id INNER JOIN sylius_currency t25 ON t0 . base_currency_id = t25 . id WHERE t0 . enabled = ?
SELECT t0 . code AS code_1 , t0 . name AS name_2 , t0 . color AS color_3 , t0 . description AS description_4 , t0 . enabled AS enabled_5 , t0 . hostname AS hostname_6 , t0 . created_at AS created_at_7 , t0 . updated_at AS updated_at_8 , t0 . id AS id_9 , t0 . theme_name AS theme_name_10 , t0 . tax_calculation_strategy AS tax_calculation_strategy_11 , t0 . contact_email AS contact_email_12 , t0 . contact_phone_number AS contact_phone_number_13 , t0 . skipping_shipping_step_allowed AS skipping_shipping_step_allowed_14 , t0 . skipping_payment_step_allowed AS skipping_payment_step_allowed_15 , t0 . account_verification_required AS account_verification_required_16 , t0 . shipping_address_in_checkout_required AS shipping_address_in_checkout_required_17 , t0 . default_locale_id AS default_locale_id_18 , t19 . code AS code_20 , t19 . created_at AS created_at_21 , t19 . updated_at AS updated_at_22 , t19 . id AS id_23 , t0 . base_currency_id AS base_currency_id_24 , t25 . code AS code_26 , t25 . created_at AS created_at_27 , t25 . updated_at AS updated_at_28 , t25 . id AS id_29 , t0 . default_tax_zone_id AS default_tax_zone_id_30 , t0 . menu_taxon_id AS menu_taxon_id_31 , t0 . shop_billing_data_id AS shop_billing_data_id_32 , t0 . channel_price_history_config_id AS channel_price_history_config_id_33 FROM sylius_channel t0 INNER JOIN sylius_locale t19 ON t0 . default_locale_id = t19 . id INNER JOIN sylius_currency t25 ON t0 . base_currency_id = t25 . id WHERE t0 . enabled = 1 ;
Copy
5
0.22 ms
SELECT t0 . code AS code_1 , t0 . environment AS environment_2 , t0 . is_enabled AS is_enabled_3 , t0 . position AS position_4 , t0 . created_at AS created_at_5 , t0 . updated_at AS updated_at_6 , t0 . id AS id_7 , t0 . gateway_config_id AS gateway_config_id_8 FROM sylius_payment_method t0 WHERE t0 . is_enabled = ?
SELECT t0 . code AS code_1 , t0 . environment AS environment_2 , t0 . is_enabled AS is_enabled_3 , t0 . position AS position_4 , t0 . created_at AS created_at_5 , t0 . updated_at AS updated_at_6 , t0 . id AS id_7 , t0 . gateway_config_id AS gateway_config_id_8 FROM sylius_payment_method t0 WHERE t0 . is_enabled = 1 ;
Copy
6
0.21 ms
SELECT t0 . gateway_name AS gateway_name_1 , t0 . factory_name AS factory_name_2 , t0 . config AS config_3 , t0 . id AS id_4 , t0 . use_payum AS use_payum_5 FROM sylius_gateway_config t0 WHERE t0 . id = ?
SELECT t0 . gateway_name AS gateway_name_1 , t0 . factory_name AS factory_name_2 , t0 . config AS config_3 , t0 . id AS id_4 , t0 . use_payum AS use_payum_5 FROM sylius_gateway_config t0 WHERE t0 . id = 2 ;
Copy
7
0.44 ms
SELECT taxon . id as id , taxon . tree_root as tree_root , taxon . parent_id as parent_id , taxon . code as code , taxon . tree_left as tree_left , taxon . tree_right as tree_right , taxon . tree_level as tree_level , taxon . position as position , taxon . enabled as enabled , COALESCE (current_translation . name , fallback_translation . name ) as name FROM sylius_taxon taxon LEFT JOIN sylius_taxon_translation current_translation ON (current_translation . translatable_id = taxon . id ) AND (current_translation . locale = ? ) LEFT JOIN sylius_taxon_translation fallback_translation ON (fallback_translation . translatable_id = taxon . id ) AND (fallback_translation . locale = ? ) ORDER BY taxon . tree_level DESC , taxon . position ASC
Parameters :
[
"nl_NL "
"nl_NL "
]
SELECT taxon . id as id , taxon . tree_root as tree_root , taxon . parent_id as parent_id , taxon . code as code , taxon . tree_left as tree_left , taxon . tree_right as tree_right , taxon . tree_level as tree_level , taxon . position as position , taxon . enabled as enabled , COALESCE (current_translation . name , fallback_translation . name ) as name FROM sylius_taxon taxon LEFT JOIN sylius_taxon_translation current_translation ON (current_translation . translatable_id = taxon . id ) AND (current_translation . locale = 'nl_NL' ) LEFT JOIN sylius_taxon_translation fallback_translation ON (fallback_translation . translatable_id = taxon . id ) AND (fallback_translation . locale = 'nl_NL' ) ORDER BY taxon . tree_level DESC , taxon . position ASC ;
Copy