1
3.56 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 . login_required AS login_required_23 , t0 . default_locale_id AS default_locale_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 . base_currency_id AS base_currency_id_30 , t31 . code AS code_32 , t31 . created_at AS created_at_33 , t31 . updated_at AS updated_at_34 , t31 . id AS id_35 , t0 . default_tax_zone_id AS default_tax_zone_id_36 , t0 . menu_taxon_id AS menu_taxon_id_37 , t0 . business_unit_id AS business_unit_id_38 , t0 . customer_pool_id AS customer_pool_id_39 , t0 . shop_billing_data_id AS shop_billing_data_id_40 , t0 . channel_price_history_config_id AS channel_price_history_config_id_41 FROM sylius_channel t0 INNER JOIN sylius_locale t25 ON t0 . default_locale_id = t25 . id INNER JOIN sylius_currency t31 ON t0 . base_currency_id = t31 . 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 . login_required AS login_required_23 , t0 . default_locale_id AS default_locale_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 . base_currency_id AS base_currency_id_30 , t31 . code AS code_32 , t31 . created_at AS created_at_33 , t31 . updated_at AS updated_at_34 , t31 . id AS id_35 , t0 . default_tax_zone_id AS default_tax_zone_id_36 , t0 . menu_taxon_id AS menu_taxon_id_37 , t0 . business_unit_id AS business_unit_id_38 , t0 . customer_pool_id AS customer_pool_id_39 , t0 . shop_billing_data_id AS shop_billing_data_id_40 , t0 . channel_price_history_config_id AS channel_price_history_config_id_41 FROM sylius_channel t0 INNER JOIN sylius_locale t25 ON t0 . default_locale_id = t25 . id INNER JOIN sylius_currency t31 ON t0 . base_currency_id = t31 . id WHERE t0 . hostname = 'boutique.salsa.demo.loyaltyweb.solutions' AND t0 . enabled = 1 ORDER BY t0 . id ASC LIMIT 1 ;
Copy
2
3.22 ms
SELECT t0 . code AS code_1 , t0 . created_at AS created_at_2 , t0 . updated_at AS updated_at_3 , t0 . id AS id_4 FROM sylius_locale t0 INNER JOIN sylius_channel_locales ON t0 . id = sylius_channel_locales . locale_id WHERE sylius_channel_locales . channel_id = ?
SELECT t0 . code AS code_1 , t0 . created_at AS created_at_2 , t0 . updated_at AS updated_at_3 , t0 . id AS id_4 FROM sylius_locale t0 INNER JOIN sylius_channel_locales ON t0 . id = sylius_channel_locales . locale_id WHERE sylius_channel_locales . channel_id = 7 ;
Copy
3
3.75 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
4
3.13 ms
SELECT s0_ . code AS code_0 , s0_ . position AS position_1 , s0_ . created_at AS created_at_2 , s0_ . updated_at AS updated_at_3 , s0_ . id AS id_4 FROM sylius_product_option s0_ ORDER BY s0_ . id ASC
SELECT s0_ . code AS code_0 , s0_ . position AS position_1 , s0_ . created_at AS created_at_2 , s0_ . updated_at AS updated_at_3 , s0_ . id AS id_4 FROM sylius_product_option s0_ ORDER BY s0_ . id ASC ;
Copy
5
3.45 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
"cev-type-virtual "
"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 = 'cev-type-virtual' AND s1_ . locale = 'fr_FR' ORDER BY s0_ . id ASC ;
Copy
6
3.38 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 FROM sylius_product_attribute s0_ WHERE s0_ . id IN (? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ) ORDER BY s0_ . id ASC
Parameters :
[
"45 "
"46 "
"47 "
"48 "
"49 "
"50 "
"51 "
"52 "
"53 "
"54 "
"55 "
]
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 FROM sylius_product_attribute s0_ WHERE s0_ . id IN ('45' , '46' , '47' , '48' , '49' , '50' , '51' , '52' , '53' , '54' , '55' ) ORDER BY s0_ . id ASC ;
Copy
7
3.06 ms
SELECT t0 . name AS name_1 , t0 . id AS id_2 , t0 . locale AS locale_3 , t0 . translatable_id AS translatable_id_4 FROM sylius_product_option_translation t0 WHERE t0 . translatable_id = ? AND t0 . locale = ? LIMIT 1
Parameters :
[
15
"fr_FR "
]
SELECT t0 . name AS name_1 , t0 . id AS id_2 , t0 . locale AS locale_3 , t0 . translatable_id AS translatable_id_4 FROM sylius_product_option_translation t0 WHERE t0 . translatable_id = 15 AND t0 . locale = 'fr_FR' LIMIT 1 ;
Copy
8
3.32 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
"cev-type-virtual "
"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 = 'cev-type-virtual' AND s1_ . locale = 'fr_FR' ORDER BY s0_ . id ASC ;
Copy
9
3.10 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 FROM sylius_product_attribute s0_ WHERE s0_ . id IN (? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ) ORDER BY s0_ . id ASC
Parameters :
[
"45 "
"46 "
"47 "
"48 "
"49 "
"50 "
"51 "
"52 "
"53 "
"54 "
"55 "
]
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 FROM sylius_product_attribute s0_ WHERE s0_ . id IN ('45' , '46' , '47' , '48' , '49' , '50' , '51' , '52' , '53' , '54' , '55' ) ORDER BY s0_ . id ASC ;
Copy
10
3.16 ms
SELECT s0_ . name AS name_0 , s0_ . token AS token_1 , s0_ . created_at AS created_at_2 , s0_ . updated_at AS updated_at_3 , s0_ . id AS id_4 , s0_ . shop_user_id AS shop_user_id_5 , s0_ . channel_id AS channel_id_6 FROM sylius_wishlist s0_ WHERE s0_ . channel_id = ? AND s0_ . shop_user_id IS NULL AND s0_ . token = ? ORDER BY s0_ . id ASC
Parameters :
[
7
"1d46057f-c1bd-4250-aece-aceeac31d7b1 "
]
SELECT s0_ . name AS name_0 , s0_ . token AS token_1 , s0_ . created_at AS created_at_2 , s0_ . updated_at AS updated_at_3 , s0_ . id AS id_4 , s0_ . shop_user_id AS shop_user_id_5 , s0_ . channel_id AS channel_id_6 FROM sylius_wishlist s0_ WHERE s0_ . channel_id = 7 AND s0_ . shop_user_id IS NULL AND s0_ . token = '1d46057f-c1bd-4250-aece-aceeac31d7b1' ORDER BY s0_ . id ASC ;
Copy
11
4.25 ms
SELECT s0_ . code AS code_0 , s0_ . name AS name_1 , s0_ . hostname AS hostname_2 FROM sylius_channel s0_ ORDER BY s0_ . id ASC
SELECT s0_ . code AS code_0 , s0_ . name AS name_1 , s0_ . hostname AS hostname_2 FROM sylius_channel s0_ ORDER BY s0_ . id ASC ;
Copy
12
6.84 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 , s0_ . code AS code_9 , s0_ . tree_left AS tree_left_10 , s0_ . tree_right AS tree_right_11 , s0_ . tree_level AS tree_level_12 , s0_ . position AS position_13 , s0_ . enabled AS enabled_14 , s0_ . id AS id_15 , s0_ . created_at AS created_at_16 , s0_ . updated_at AS updated_at_17 , s1_ . name AS name_18 , s1_ . slug AS slug_19 , s1_ . description AS description_20 , s1_ . id AS id_21 , s1_ . locale AS locale_22 , s2_ . code AS code_23 , s2_ . tree_left AS tree_left_24 , s2_ . tree_right AS tree_right_25 , s2_ . tree_level AS tree_level_26 , s2_ . position AS position_27 , s2_ . enabled AS enabled_28 , s2_ . id AS id_29 , s2_ . created_at AS created_at_30 , s2_ . updated_at AS updated_at_31 , s0_ . tree_root AS tree_root_32 , s0_ . parent_id AS parent_id_33 , s1_ . translatable_id AS translatable_id_34 , s2_ . tree_root AS tree_root_35 , s2_ . parent_id AS parent_id_36 FROM sylius_taxon s0_ LEFT JOIN sylius_taxon_translation s1_ ON s0_ . id = s1_ . translatable_id LEFT JOIN sylius_taxon s2_ ON s0_ . id = s2_ . parent_id WHERE s1_ . locale = ? ORDER BY s0_ . id ASC , s2_ . position ASC , s2_ . id ASC
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 , s0_ . code AS code_9 , s0_ . tree_left AS tree_left_10 , s0_ . tree_right AS tree_right_11 , s0_ . tree_level AS tree_level_12 , s0_ . position AS position_13 , s0_ . enabled AS enabled_14 , s0_ . id AS id_15 , s0_ . created_at AS created_at_16 , s0_ . updated_at AS updated_at_17 , s1_ . name AS name_18 , s1_ . slug AS slug_19 , s1_ . description AS description_20 , s1_ . id AS id_21 , s1_ . locale AS locale_22 , s2_ . code AS code_23 , s2_ . tree_left AS tree_left_24 , s2_ . tree_right AS tree_right_25 , s2_ . tree_level AS tree_level_26 , s2_ . position AS position_27 , s2_ . enabled AS enabled_28 , s2_ . id AS id_29 , s2_ . created_at AS created_at_30 , s2_ . updated_at AS updated_at_31 , s0_ . tree_root AS tree_root_32 , s0_ . parent_id AS parent_id_33 , s1_ . translatable_id AS translatable_id_34 , s2_ . tree_root AS tree_root_35 , s2_ . parent_id AS parent_id_36 FROM sylius_taxon s0_ LEFT JOIN sylius_taxon_translation s1_ ON s0_ . id = s1_ . translatable_id LEFT JOIN sylius_taxon s2_ ON s0_ . id = s2_ . parent_id WHERE s1_ . locale = 'fr_FR' ORDER BY s0_ . id ASC , s2_ . position ASC , s2_ . id ASC ;
Copy
13
3.88 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 , s2_ . code AS code_14 , s2_ . tree_left AS tree_left_15 , s2_ . tree_right AS tree_right_16 , s2_ . tree_level AS tree_level_17 , s2_ . position AS position_18 , s2_ . enabled AS enabled_19 , s2_ . id AS id_20 , s2_ . created_at AS created_at_21 , s2_ . updated_at AS updated_at_22 , s0_ . tree_root AS tree_root_23 , s0_ . parent_id AS parent_id_24 , s1_ . translatable_id AS translatable_id_25 , s2_ . tree_root AS tree_root_26 , s2_ . parent_id AS parent_id_27 FROM sylius_taxon s0_ LEFT JOIN sylius_taxon_translation s1_ ON s0_ . id = s1_ . translatable_id INNER JOIN sylius_taxon s3_ ON s0_ . parent_id = s3_ . id LEFT JOIN sylius_taxon s2_ ON s0_ . id = s2_ . parent_id WHERE s1_ . locale = ? AND s0_ . enabled = ? AND s3_ . code = ? ORDER BY s0_ . position ASC , s0_ . id ASC , s2_ . position ASC , s2_ . id ASC
Parameters :
[
"fr_FR "
1
"category "
]
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 , s2_ . code AS code_14 , s2_ . tree_left AS tree_left_15 , s2_ . tree_right AS tree_right_16 , s2_ . tree_level AS tree_level_17 , s2_ . position AS position_18 , s2_ . enabled AS enabled_19 , s2_ . id AS id_20 , s2_ . created_at AS created_at_21 , s2_ . updated_at AS updated_at_22 , s0_ . tree_root AS tree_root_23 , s0_ . parent_id AS parent_id_24 , s1_ . translatable_id AS translatable_id_25 , s2_ . tree_root AS tree_root_26 , s2_ . parent_id AS parent_id_27 FROM sylius_taxon s0_ LEFT JOIN sylius_taxon_translation s1_ ON s0_ . id = s1_ . translatable_id INNER JOIN sylius_taxon s3_ ON s0_ . parent_id = s3_ . id LEFT JOIN sylius_taxon s2_ ON s0_ . id = s2_ . parent_id WHERE s1_ . locale = 'fr_FR' AND s0_ . enabled = 1 AND s3_ . code = 'category' ORDER BY s0_ . position ASC , s0_ . id ASC , s2_ . position ASC , s2_ . id ASC ;
Copy
14
3.40 ms
SELECT s0_ . code AS code_0 , s0_ . created_at AS created_at_1 , s0_ . updated_at AS updated_at_2 , s0_ . enabled AS enabled_3 , s0_ . id AS id_4 , s0_ . variant_selection_method AS variant_selection_method_5 , s0_ . average_rating AS average_rating_6 , s0_ . internalReference AS internalReference_7 , s0_ . expired AS expired_8 , s0_ . expirationDate AS expirationDate_9 , s0_ . toExpire AS toExpire_10 , s0_ . bufferStock AS bufferStock_11 , s0_ . internalName AS internalName_12 , s0_ . isParent AS isParent_13 , s0_ . main_taxon_id AS main_taxon_id_14 , s0_ . product_type_id AS product_type_id_15 FROM sylius_product s0_ LEFT JOIN sylius_product_customer_groups s2_ ON s0_ . id = s2_ . product_id LEFT JOIN sylius_customer_group s1_ ON s1_ . id = s2_ . customer_group_id LEFT JOIN sylius_product_organizations s4_ ON s0_ . id = s4_ . product_id LEFT JOIN sylius_organization s3_ ON s3_ . id = s4_ . organization_id WHERE (s1_ . id IS NULL AND s3_ . id IS NULL ) AND s0_ . id IN (? ) ORDER BY s0_ . id ASC
SELECT s0_ . code AS code_0 , s0_ . created_at AS created_at_1 , s0_ . updated_at AS updated_at_2 , s0_ . enabled AS enabled_3 , s0_ . id AS id_4 , s0_ . variant_selection_method AS variant_selection_method_5 , s0_ . average_rating AS average_rating_6 , s0_ . internalReference AS internalReference_7 , s0_ . expired AS expired_8 , s0_ . expirationDate AS expirationDate_9 , s0_ . toExpire AS toExpire_10 , s0_ . bufferStock AS bufferStock_11 , s0_ . internalName AS internalName_12 , s0_ . isParent AS isParent_13 , s0_ . main_taxon_id AS main_taxon_id_14 , s0_ . product_type_id AS product_type_id_15 FROM sylius_product s0_ LEFT JOIN sylius_product_customer_groups s2_ ON s0_ . id = s2_ . product_id LEFT JOIN sylius_customer_group s1_ ON s1_ . id = s2_ . customer_group_id LEFT JOIN sylius_product_organizations s4_ ON s0_ . id = s4_ . product_id LEFT JOIN sylius_organization s3_ ON s3_ . id = s4_ . organization_id WHERE (s1_ . id IS NULL AND s3_ . id IS NULL ) AND s0_ . id IN ('78' ) ORDER BY s0_ . id ASC ;
Copy
15
3.31 ms
SELECT t0 . code AS code_1 , t0 . created_at AS created_at_2 , t0 . updated_at AS updated_at_3 , t0 . position AS position_4 , t0 . enabled AS enabled_5 , t0 . id AS id_6 , t0 . version AS version_7 , t0 . on_hold AS on_hold_8 , t0 . on_hand AS on_hand_9 , t0 . tracked AS tracked_10 , t0 . width AS width_11 , t0 . height AS height_12 , t0 . depth AS depth_13 , t0 . weight AS weight_14 , t0 . shipping_required AS shipping_required_15 , t0 . operator AS operator_16 , t0 . operator_reference AS operator_reference_17 , t0 . brandReference AS brandReference_18 , t0 . ean AS ean_19 , t0 . internalName AS internalName_20 , t0 . expired AS expired_21 , t0 . expirationDate AS expirationDate_22 , t0 . toExpire AS toExpire_23 , t0 . internalReference AS internalReference_24 , t0 . brand_name AS brand_name_25 , t0 . amount_fixed_flag AS amount_fixed_flag_26 , t0 . amount_dropdown_list AS amount_dropdown_list_27 , t0 . amount_max AS amount_max_28 , t0 . recurring AS recurring_29 , t0 . recurring_times AS recurring_times_30 , t0 . recurring_interval AS recurring_interval_31 , t0 . product_id AS product_id_32 , t0 . tax_category_id AS tax_category_id_33 , t0 . shipping_category_id AS shipping_category_id_34 FROM sylius_product_variant t0 WHERE t0 . product_id = ? AND t0 . enabled = ? ORDER BY t0 . position ASC , t0 . id ASC LIMIT 1
SELECT t0 . code AS code_1 , t0 . created_at AS created_at_2 , t0 . updated_at AS updated_at_3 , t0 . position AS position_4 , t0 . enabled AS enabled_5 , t0 . id AS id_6 , t0 . version AS version_7 , t0 . on_hold AS on_hold_8 , t0 . on_hand AS on_hand_9 , t0 . tracked AS tracked_10 , t0 . width AS width_11 , t0 . height AS height_12 , t0 . depth AS depth_13 , t0 . weight AS weight_14 , t0 . shipping_required AS shipping_required_15 , t0 . operator AS operator_16 , t0 . operator_reference AS operator_reference_17 , t0 . brandReference AS brandReference_18 , t0 . ean AS ean_19 , t0 . internalName AS internalName_20 , t0 . expired AS expired_21 , t0 . expirationDate AS expirationDate_22 , t0 . toExpire AS toExpire_23 , t0 . internalReference AS internalReference_24 , t0 . brand_name AS brand_name_25 , t0 . amount_fixed_flag AS amount_fixed_flag_26 , t0 . amount_dropdown_list AS amount_dropdown_list_27 , t0 . amount_max AS amount_max_28 , t0 . recurring AS recurring_29 , t0 . recurring_times AS recurring_times_30 , t0 . recurring_interval AS recurring_interval_31 , t0 . product_id AS product_id_32 , t0 . tax_category_id AS tax_category_id_33 , t0 . shipping_category_id AS shipping_category_id_34 FROM sylius_product_variant t0 WHERE t0 . product_id = 78 AND t0 . enabled = 1 ORDER BY t0 . position ASC , t0 . id ASC LIMIT 1 ;
Copy
16
3.01 ms
SELECT t0 . price AS price_1 , t0 . original_price AS original_price_2 , t0 . minimum_price AS minimum_price_3 , t0 . lowest_price_before_discount AS lowest_price_before_discount_4 , t0 . channel_code AS channel_code_5 , t0 . id AS id_6 , t0 . product_variant_id AS product_variant_id_7 FROM sylius_channel_pricing t0 WHERE t0 . product_variant_id = ? ORDER BY t0 . id ASC
SELECT t0 . price AS price_1 , t0 . original_price AS original_price_2 , t0 . minimum_price AS minimum_price_3 , t0 . lowest_price_before_discount AS lowest_price_before_discount_4 , t0 . channel_code AS channel_code_5 , t0 . id AS id_6 , t0 . product_variant_id AS product_variant_id_7 FROM sylius_channel_pricing t0 WHERE t0 . product_variant_id = 362 ORDER BY t0 . id ASC ;
Copy
17
3.08 ms
SELECT t0 . name AS name_1 , t0 . slug AS slug_2 , t0 . description AS description_3 , t0 . meta_keywords AS meta_keywords_4 , t0 . meta_description AS meta_description_5 , t0 . id AS id_6 , t0 . short_description AS short_description_7 , t0 . locale AS locale_8 , t0 . translatable_id AS translatable_id_9 FROM sylius_product_translation t0 WHERE t0 . translatable_id = ? AND t0 . locale = ? LIMIT 1
Parameters :
[
78
"fr_FR "
]
SELECT t0 . name AS name_1 , t0 . slug AS slug_2 , t0 . description AS description_3 , t0 . meta_keywords AS meta_keywords_4 , t0 . meta_description AS meta_description_5 , t0 . id AS id_6 , t0 . short_description AS short_description_7 , t0 . locale AS locale_8 , t0 . translatable_id AS translatable_id_9 FROM sylius_product_translation t0 WHERE t0 . translatable_id = 78 AND t0 . locale = 'fr_FR' LIMIT 1 ;
Copy
18
3.03 ms
SELECT t0 . type AS type_1 , t0 . path AS path_2 , t0 . id AS id_3 , t0 . position AS position_4 , t0 . owner_id AS owner_id_5 FROM sylius_product_image t0 WHERE t0 . owner_id = ? ORDER BY t0 . position ASC , t0 . id ASC
SELECT t0 . type AS type_1 , t0 . path AS path_2 , t0 . id AS id_3 , t0 . position AS position_4 , t0 . owner_id AS owner_id_5 FROM sylius_product_image t0 WHERE t0 . owner_id = 78 ORDER BY t0 . position ASC , t0 . id ASC ;
Copy
19
3.03 ms
SELECT s0_ . name AS name_0 , s0_ . token AS token_1 , s0_ . created_at AS created_at_2 , s0_ . updated_at AS updated_at_3 , s0_ . id AS id_4 , s0_ . shop_user_id AS shop_user_id_5 , s0_ . channel_id AS channel_id_6 FROM sylius_wishlist s0_ WHERE s0_ . channel_id = ? AND s0_ . shop_user_id IS NULL AND s0_ . token = ? ORDER BY s0_ . id ASC
Parameters :
[
7
"ac885646-3c85-4ccc-b507-9efbda74a4b8 "
]
SELECT s0_ . name AS name_0 , s0_ . token AS token_1 , s0_ . created_at AS created_at_2 , s0_ . updated_at AS updated_at_3 , s0_ . id AS id_4 , s0_ . shop_user_id AS shop_user_id_5 , s0_ . channel_id AS channel_id_6 FROM sylius_wishlist s0_ WHERE s0_ . channel_id = 7 AND s0_ . shop_user_id IS NULL AND s0_ . token = 'ac885646-3c85-4ccc-b507-9efbda74a4b8' ORDER BY s0_ . id ASC ;
Copy
20
3.22 ms
SELECT t0 . code AS code_1 , t0 . created_at AS created_at_2 , t0 . updated_at AS updated_at_3 , t0 . position AS position_4 , t0 . enabled AS enabled_5 , t0 . id AS id_6 , t0 . version AS version_7 , t0 . on_hold AS on_hold_8 , t0 . on_hand AS on_hand_9 , t0 . tracked AS tracked_10 , t0 . width AS width_11 , t0 . height AS height_12 , t0 . depth AS depth_13 , t0 . weight AS weight_14 , t0 . shipping_required AS shipping_required_15 , t0 . operator AS operator_16 , t0 . operator_reference AS operator_reference_17 , t0 . brandReference AS brandReference_18 , t0 . ean AS ean_19 , t0 . internalName AS internalName_20 , t0 . expired AS expired_21 , t0 . expirationDate AS expirationDate_22 , t0 . toExpire AS toExpire_23 , t0 . internalReference AS internalReference_24 , t0 . brand_name AS brand_name_25 , t0 . amount_fixed_flag AS amount_fixed_flag_26 , t0 . amount_dropdown_list AS amount_dropdown_list_27 , t0 . amount_max AS amount_max_28 , t0 . recurring AS recurring_29 , t0 . recurring_times AS recurring_times_30 , t0 . recurring_interval AS recurring_interval_31 , t0 . product_id AS product_id_32 , t0 . tax_category_id AS tax_category_id_33 , t0 . shipping_category_id AS shipping_category_id_34 FROM sylius_product_variant t0 WHERE t0 . product_id = ? ORDER BY t0 . position ASC , t0 . id ASC
SELECT t0 . code AS code_1 , t0 . created_at AS created_at_2 , t0 . updated_at AS updated_at_3 , t0 . position AS position_4 , t0 . enabled AS enabled_5 , t0 . id AS id_6 , t0 . version AS version_7 , t0 . on_hold AS on_hold_8 , t0 . on_hand AS on_hand_9 , t0 . tracked AS tracked_10 , t0 . width AS width_11 , t0 . height AS height_12 , t0 . depth AS depth_13 , t0 . weight AS weight_14 , t0 . shipping_required AS shipping_required_15 , t0 . operator AS operator_16 , t0 . operator_reference AS operator_reference_17 , t0 . brandReference AS brandReference_18 , t0 . ean AS ean_19 , t0 . internalName AS internalName_20 , t0 . expired AS expired_21 , t0 . expirationDate AS expirationDate_22 , t0 . toExpire AS toExpire_23 , t0 . internalReference AS internalReference_24 , t0 . brand_name AS brand_name_25 , t0 . amount_fixed_flag AS amount_fixed_flag_26 , t0 . amount_dropdown_list AS amount_dropdown_list_27 , t0 . amount_max AS amount_max_28 , t0 . recurring AS recurring_29 , t0 . recurring_times AS recurring_times_30 , t0 . recurring_interval AS recurring_interval_31 , t0 . product_id AS product_id_32 , t0 . tax_category_id AS tax_category_id_33 , t0 . shipping_category_id AS shipping_category_id_34 FROM sylius_product_variant t0 WHERE t0 . product_id = 78 ORDER BY t0 . position ASC , t0 . id ASC ;
Copy
21
3.10 ms
SELECT t0 . code AS code_1 , t0 . id AS id_2 , t0 . option_id AS option_id_3 FROM sylius_product_option_value t0 INNER JOIN sylius_product_variant_option_value ON t0 . id = sylius_product_variant_option_value . option_value_id WHERE sylius_product_variant_option_value . variant_id = ? ORDER BY t0 . id ASC
SELECT t0 . code AS code_1 , t0 . id AS id_2 , t0 . option_id AS option_id_3 FROM sylius_product_option_value t0 INNER JOIN sylius_product_variant_option_value ON t0 . id = sylius_product_variant_option_value . option_value_id WHERE sylius_product_variant_option_value . variant_id = 362 ORDER BY t0 . id ASC ;
Copy
22
3.00 ms
SELECT t0 . value AS value_1 , t0 . id AS id_2 , t0 . locale AS locale_3 , t0 . translatable_id AS translatable_id_4 FROM sylius_product_option_value_translation t0 WHERE t0 . translatable_id = ? AND t0 . locale = ? LIMIT 1
Parameters :
[
55
"fr_FR "
]
SELECT t0 . value AS value_1 , t0 . id AS id_2 , t0 . locale AS locale_3 , t0 . translatable_id AS translatable_id_4 FROM sylius_product_option_value_translation t0 WHERE t0 . translatable_id = 55 AND t0 . locale = 'fr_FR' LIMIT 1 ;
Copy
23
3.04 ms
SELECT t0 . code AS code_1 , t0 . name AS name_2 , t0 . start_date AS start_date_3 , t0 . end_date AS end_date_4 , t0 . enabled AS enabled_5 , t0 . priority AS priority_6 , t0 . exclusive AS exclusive_7 , t0 . state AS state_8 , t0 . id AS id_9 FROM sylius_catalog_promotion t0 INNER JOIN sylius_channel_pricing_catalog_promotions ON t0 . id = sylius_channel_pricing_catalog_promotions . catalog_promotion_id WHERE sylius_channel_pricing_catalog_promotions . channel_pricing_id = ? ORDER BY t0 . id ASC
SELECT t0 . code AS code_1 , t0 . name AS name_2 , t0 . start_date AS start_date_3 , t0 . end_date AS end_date_4 , t0 . enabled AS enabled_5 , t0 . priority AS priority_6 , t0 . exclusive AS exclusive_7 , t0 . state AS state_8 , t0 . id AS id_9 FROM sylius_catalog_promotion t0 INNER JOIN sylius_channel_pricing_catalog_promotions ON t0 . id = sylius_channel_pricing_catalog_promotions . catalog_promotion_id WHERE sylius_channel_pricing_catalog_promotions . channel_pricing_id = 785 ORDER BY t0 . id ASC ;
Copy