1
0.94 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 . login_required AS login_required_18 , t0 . default_locale_id AS default_locale_id_19 , t20 . code AS code_21 , t20 . created_at AS created_at_22 , t20 . updated_at AS updated_at_23 , t20 . id AS id_24 , t0 . base_currency_id AS base_currency_id_25 , t26 . code AS code_27 , t26 . created_at AS created_at_28 , t26 . updated_at AS updated_at_29 , t26 . id AS id_30 , t0 . default_tax_zone_id AS default_tax_zone_id_31 , t0 . menu_taxon_id AS menu_taxon_id_32 , t0 . business_unit_id AS business_unit_id_33 , t0 . customer_pool_id AS customer_pool_id_34 , t0 . shop_billing_data_id AS shop_billing_data_id_35 , t0 . channel_price_history_config_id AS channel_price_history_config_id_36 FROM sylius_channel t0 INNER JOIN sylius_locale t20 ON t0 . default_locale_id = t20 . id INNER JOIN sylius_currency t26 ON t0 . base_currency_id = t26 . id WHERE t0 . hostname = ? AND t0 . enabled = ? ORDER BY t0 . id ASC LIMIT 1
Parameters :
[
"boutique-tmp-fix-7.up-pulse.dev "
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 . login_required AS login_required_18 , t0 . default_locale_id AS default_locale_id_19 , t20 . code AS code_21 , t20 . created_at AS created_at_22 , t20 . updated_at AS updated_at_23 , t20 . id AS id_24 , t0 . base_currency_id AS base_currency_id_25 , t26 . code AS code_27 , t26 . created_at AS created_at_28 , t26 . updated_at AS updated_at_29 , t26 . id AS id_30 , t0 . default_tax_zone_id AS default_tax_zone_id_31 , t0 . menu_taxon_id AS menu_taxon_id_32 , t0 . business_unit_id AS business_unit_id_33 , t0 . customer_pool_id AS customer_pool_id_34 , t0 . shop_billing_data_id AS shop_billing_data_id_35 , t0 . channel_price_history_config_id AS channel_price_history_config_id_36 FROM sylius_channel t0 INNER JOIN sylius_locale t20 ON t0 . default_locale_id = t20 . id INNER JOIN sylius_currency t26 ON t0 . base_currency_id = t26 . id WHERE t0 . hostname = 'boutique-tmp-fix-7.up-pulse.dev' AND t0 . enabled = 1 ORDER BY t0 . id ASC LIMIT 1 ;
Copy
2
0.69 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 = 1 ;
Copy
3
0.91 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
0.52 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
0.68 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
"fashion-category/jeans "
"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 = 'fashion-category/jeans' AND s1_ . locale = 'fr_FR' ORDER BY s0_ . id ASC ;
Copy
6
0.72 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 :
[
"12 "
"13 "
"14 "
]
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 ('12' , '13' , '14' ) ORDER BY s0_ . id ASC ;
Copy
7
0.55 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 :
[
4
"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 = 4 AND t0 . locale = 'fr_FR' LIMIT 1 ;
Copy
8
0.72 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
"fashion-category/jeans "
"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 = 'fashion-category/jeans' AND s1_ . locale = 'fr_FR' ORDER BY s0_ . id ASC ;
Copy
9
0.60 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 :
[
"12 "
"13 "
"14 "
]
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 ('12' , '13' , '14' ) ORDER BY s0_ . id ASC ;
Copy
10
0.67 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 :
[
1
"e700e0c6-77bc-4fd3-a920-144804ff0aa1 "
]
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 = 1 AND s0_ . shop_user_id IS NULL AND s0_ . token = 'e700e0c6-77bc-4fd3-a920-144804ff0aa1' ORDER BY s0_ . id ASC ;
Copy