1
3.21 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 . points_enabled AS points_enabled_18 , t0 . points_code AS points_code_19 , t0 . billing_mode AS billing_mode_20 , t0 . billing_business_code AS billing_business_code_21 , t0 . billing_article_code AS billing_article_code_22 , t0 . color2 AS color2_23 , t0 . color3 AS color3_24 , t0 . color4 AS color4_25 , t0 . animation_fqdn AS animation_fqdn_26 , t0 . animation_api_key AS animation_api_key_27 , t0 . login_required AS login_required_28 , t0 . default_locale_id AS default_locale_id_29 , t30 . code AS code_31 , t30 . created_at AS created_at_32 , t30 . updated_at AS updated_at_33 , t30 . id AS id_34 , t0 . base_currency_id AS base_currency_id_35 , t36 . code AS code_37 , t36 . created_at AS created_at_38 , t36 . updated_at AS updated_at_39 , t36 . id AS id_40 , t0 . default_tax_zone_id AS default_tax_zone_id_41 , t0 . menu_taxon_id AS menu_taxon_id_42 , t0 . business_unit_id AS business_unit_id_43 , t0 . customer_pool_id AS customer_pool_id_44 , t0 . shop_billing_data_id AS shop_billing_data_id_45 , t0 . channel_price_history_config_id AS channel_price_history_config_id_46 FROM sylius_channel t0 INNER JOIN sylius_locale t30 ON t0 . default_locale_id = t30 . id INNER JOIN sylius_currency t36 ON t0 . base_currency_id = t36 . id WHERE t0 . hostname = ? AND t0 . enabled = ? ORDER BY t0 . id ASC LIMIT 1
Parameters :
[
"boutique.salsa.demo.loyaltyweb.solutions "
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 . points_enabled AS points_enabled_18 ,
t0 . points_code AS points_code_19 ,
t0 . billing_mode AS billing_mode_20 ,
t0 . billing_business_code AS billing_business_code_21 ,
t0 . billing_article_code AS billing_article_code_22 ,
t0 . color2 AS color2_23 ,
t0 . color3 AS color3_24 ,
t0 . color4 AS color4_25 ,
t0 . animation_fqdn AS animation_fqdn_26 ,
t0 . animation_api_key AS animation_api_key_27 ,
t0 . login_required AS login_required_28 ,
t0 . default_locale_id AS default_locale_id_29 ,
t30 . code AS code_31 ,
t30 . created_at AS created_at_32 ,
t30 . updated_at AS updated_at_33 ,
t30 . id AS id_34 ,
t0 . base_currency_id AS base_currency_id_35 ,
t36 . code AS code_37 ,
t36 . created_at AS created_at_38 ,
t36 . updated_at AS updated_at_39 ,
t36 . id AS id_40 ,
t0 . default_tax_zone_id AS default_tax_zone_id_41 ,
t0 . menu_taxon_id AS menu_taxon_id_42 ,
t0 . business_unit_id AS business_unit_id_43 ,
t0 . customer_pool_id AS customer_pool_id_44 ,
t0 . shop_billing_data_id AS shop_billing_data_id_45 ,
t0 . channel_price_history_config_id AS channel_price_history_config_id_46
FROM
sylius_channel t0
INNER JOIN sylius_locale t30 ON t0 . default_locale_id = t30 . id
INNER JOIN sylius_currency t36 ON t0 . base_currency_id = t36 . id
WHERE
t0 . hostname = ?
AND t0 . enabled = ?
ORDER BY
t0 . id ASC
LIMIT
1
Copy
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 . points_enabled AS points_enabled_18 , t0 . points_code AS points_code_19 , t0 . billing_mode AS billing_mode_20 , t0 . billing_business_code AS billing_business_code_21 , t0 . billing_article_code AS billing_article_code_22 , t0 . color2 AS color2_23 , t0 . color3 AS color3_24 , t0 . color4 AS color4_25 , t0 . animation_fqdn AS animation_fqdn_26 , t0 . animation_api_key AS animation_api_key_27 , t0 . login_required AS login_required_28 , t0 . default_locale_id AS default_locale_id_29 , t30 . code AS code_31 , t30 . created_at AS created_at_32 , t30 . updated_at AS updated_at_33 , t30 . id AS id_34 , t0 . base_currency_id AS base_currency_id_35 , t36 . code AS code_37 , t36 . created_at AS created_at_38 , t36 . updated_at AS updated_at_39 , t36 . id AS id_40 , t0 . default_tax_zone_id AS default_tax_zone_id_41 , t0 . menu_taxon_id AS menu_taxon_id_42 , t0 . business_unit_id AS business_unit_id_43 , t0 . customer_pool_id AS customer_pool_id_44 , t0 . shop_billing_data_id AS shop_billing_data_id_45 , t0 . channel_price_history_config_id AS channel_price_history_config_id_46 FROM sylius_channel t0 INNER JOIN sylius_locale t30 ON t0 . default_locale_id = t30 . id INNER JOIN sylius_currency t36 ON t0 . base_currency_id = t36 . id WHERE t0 . hostname = 'boutique.salsa.demo.loyaltyweb.solutions' AND t0 . enabled = 1 ORDER BY t0 . id ASC LIMIT 1 ;
Copy
3
3.37 ms
SELECT s0_ . code AS code_0 , s0_ . type AS type_1 , s0_ . storage_type AS storage_type_2 , s0_ . configuration AS configuration_3 , s0_ . created_at AS created_at_4 , s0_ . updated_at AS updated_at_5 , s0_ . position AS position_6 , s0_ . translatable AS translatable_7 , s0_ . id AS id_8 , s1_ . name AS name_9 , s1_ . id AS id_10 , s1_ . locale AS locale_11 , s1_ . translatable_id AS translatable_id_12 FROM sylius_product_attribute s0_ LEFT JOIN sylius_product_attribute_translation s1_ ON s0_ . id = s1_ . translatable_id WHERE s1_ . locale = ? ORDER BY s0_ . id ASC
SELECT s0_ . code AS code_0 , s0_ . type AS type_1 , s0_ . storage_type AS storage_type_2 , s0_ . configuration AS configuration_3 , s0_ . created_at AS created_at_4 , s0_ . updated_at AS updated_at_5 , s0_ . position AS position_6 , s0_ . translatable AS translatable_7 , s0_ . id AS id_8 , s1_ . name AS name_9 , s1_ . id AS id_10 , s1_ . locale AS locale_11 , s1_ . translatable_id AS translatable_id_12 FROM sylius_product_attribute s0_ LEFT JOIN sylius_product_attribute_translation s1_ ON s0_ . id = s1_ . translatable_id WHERE s1_ . locale = 'fr_FR' ORDER BY s0_ . id ASC ;
Copy
5
3.25 ms
SELECT s0_ . code AS code_0 , s0_ . tree_left AS tree_left_1 , s0_ . tree_right AS tree_right_2 , s0_ . tree_level AS tree_level_3 , s0_ . position AS position_4 , s0_ . enabled AS enabled_5 , s0_ . id AS id_6 , s0_ . created_at AS created_at_7 , s0_ . updated_at AS updated_at_8 , s1_ . name AS name_9 , s1_ . slug AS slug_10 , s1_ . description AS description_11 , s1_ . id AS id_12 , s1_ . locale AS locale_13 , s0_ . tree_root AS tree_root_14 , s0_ . parent_id AS parent_id_15 , s1_ . translatable_id AS translatable_id_16 FROM sylius_taxon s0_ INNER JOIN sylius_taxon_translation s1_ ON s0_ . id = s1_ . translatable_id WHERE s0_ . enabled = ? AND s1_ . slug = ? AND s1_ . locale = ? ORDER BY s0_ . id ASC
Parameters :
[
1
"menu/univers "
"fr_FR "
]
SELECT s0_ . code AS code_0 , s0_ . tree_left AS tree_left_1 , s0_ . tree_right AS tree_right_2 , s0_ . tree_level AS tree_level_3 , s0_ . position AS position_4 , s0_ . enabled AS enabled_5 , s0_ . id AS id_6 , s0_ . created_at AS created_at_7 , s0_ . updated_at AS updated_at_8 , s1_ . name AS name_9 , s1_ . slug AS slug_10 , s1_ . description AS description_11 , s1_ . id AS id_12 , s1_ . locale AS locale_13 , s0_ . tree_root AS tree_root_14 , s0_ . parent_id AS parent_id_15 , s1_ . translatable_id AS translatable_id_16 FROM sylius_taxon s0_ INNER JOIN sylius_taxon_translation s1_ ON s0_ . id = s1_ . translatable_id WHERE s0_ . enabled = 1 AND s1_ . slug = 'menu/univers' AND s1_ . locale = 'fr_FR' ORDER BY s0_ . id ASC ;
Copy
7
6.13 ms
SELECT s0_ . code AS code_0 , s0_ . tree_left AS tree_left_1 , s0_ . tree_right AS tree_right_2 , s0_ . tree_level AS tree_level_3 , s0_ . position AS position_4 , s0_ . enabled AS enabled_5 , s0_ . id AS id_6 , s0_ . created_at AS created_at_7 , s0_ . updated_at AS updated_at_8 , s1_ . name AS name_9 , s1_ . slug AS slug_10 , s1_ . description AS description_11 , s1_ . id AS id_12 , s1_ . locale AS locale_13 , s0_ . tree_root AS tree_root_14 , s0_ . parent_id AS parent_id_15 , s1_ . translatable_id AS translatable_id_16 FROM sylius_taxon s0_ INNER JOIN sylius_taxon_translation s1_ ON s0_ . id = s1_ . translatable_id WHERE s0_ . enabled = ? AND s1_ . slug = ? AND s1_ . locale = ? ORDER BY s0_ . id ASC
Parameters :
[
1
"menu/univers "
"fr_FR "
]
SELECT s0_ . code AS code_0 , s0_ . tree_left AS tree_left_1 , s0_ . tree_right AS tree_right_2 , s0_ . tree_level AS tree_level_3 , s0_ . position AS position_4 , s0_ . enabled AS enabled_5 , s0_ . id AS id_6 , s0_ . created_at AS created_at_7 , s0_ . updated_at AS updated_at_8 , s1_ . name AS name_9 , s1_ . slug AS slug_10 , s1_ . description AS description_11 , s1_ . id AS id_12 , s1_ . locale AS locale_13 , s0_ . tree_root AS tree_root_14 , s0_ . parent_id AS parent_id_15 , s1_ . translatable_id AS translatable_id_16 FROM sylius_taxon s0_ INNER JOIN sylius_taxon_translation s1_ ON s0_ . id = s1_ . translatable_id WHERE s0_ . enabled = 1 AND s1_ . slug = 'menu/univers' AND s1_ . locale = 'fr_FR' ORDER BY s0_ . id ASC ;
Copy