20.93 ms (20.79%)
6
SELECT s0_ . code AS code_0 , s0_ . enabled AS enabled_1 , s0_ . name AS name_2 , s0_ . template AS template_3 , s0_ . created_at AS created_at_4 , s0_ . updated_at AS updated_at_5 , s0_ . publish_at AS publish_at_6 , s0_ . id AS id_7 FROM sylius_cms_page s0_ WHERE s0_ . code = ? AND s0_ . enabled = 1 ORDER BY s0_ . id ASC
SELECT s0_ . code AS code_0 , s0_ . enabled AS enabled_1 , s0_ . name AS name_2 , s0_ . template AS template_3 , s0_ . created_at AS created_at_4 , s0_ . updated_at AS updated_at_5 , s0_ . publish_at AS publish_at_6 , s0_ . id AS id_7 FROM sylius_cms_page s0_ WHERE s0_ . code = 'odr' AND s0_ . enabled = 1 ORDER BY s0_ . id ASC ;
Copy
18.14 ms (18.02%)
1
SELECT s0_ . code AS code_0 , s0_ . enabled AS enabled_1 , s0_ . name AS name_2 , s0_ . template AS template_3 , s0_ . created_at AS created_at_4 , s0_ . updated_at AS updated_at_5 , s0_ . publish_at AS publish_at_6 , s0_ . id AS id_7 FROM sylius_cms_page s0_ LEFT JOIN sylius_cms_page_translation s1_ ON s0_ . id = s1_ . translatable_id INNER JOIN sylius_cms_page_channels s3_ ON s0_ . id = s3_ . page_id INNER JOIN sylius_channel s2_ ON s2_ . id = s3_ . channel_id WHERE s1_ . locale = ? AND s1_ . slug = ? AND s2_ . code = ? AND s0_ . enabled = 1 ORDER BY s0_ . id ASC
Parameters :
[
"en_US "
"agb "
"FASHION_WEB "
]
SELECT s0_ . code AS code_0 , s0_ . enabled AS enabled_1 , s0_ . name AS name_2 , s0_ . template AS template_3 , s0_ . created_at AS created_at_4 , s0_ . updated_at AS updated_at_5 , s0_ . publish_at AS publish_at_6 , s0_ . id AS id_7 FROM sylius_cms_page s0_ LEFT JOIN sylius_cms_page_translation s1_ ON s0_ . id = s1_ . translatable_id INNER JOIN sylius_cms_page_channels s3_ ON s0_ . id = s3_ . page_id INNER JOIN sylius_channel s2_ ON s2_ . id = s3_ . channel_id WHERE s1_ . locale = 'en_US' AND s1_ . slug = 'agb' AND s2_ . code = 'FASHION_WEB' AND s0_ . enabled = 1 ORDER BY s0_ . id ASC ;
Copy
13.82 ms (13.72%)
1
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 = 3 ;
Copy
12.97 ms (12.88%)
1
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 :
[
"en_US "
1
"MENU_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 = 'en_US' AND s0_ . enabled = 1 AND s3_ . code = 'MENU_CATEGORY' ORDER BY s0_ . position ASC , s0_ . id ASC , s2_ . position ASC , s2_ . id ASC ;
Copy
12.61 ms (12.52%)
1
SELECT t0 . type AS type_1 , t0 . configuration AS configuration_2 , t0 . locale AS locale_3 , t0 . id AS id_4 , t0 . block_id AS block_id_5 , t0 . page_id AS page_id_6 FROM sylius_cms_content_configuration t0 WHERE t0 . page_id = ? ORDER BY t0 . id ASC
SELECT t0 . type AS type_1 , t0 . configuration AS configuration_2 , t0 . locale AS locale_3 , t0 . id AS id_4 , t0 . block_id AS block_id_5 , t0 . page_id AS page_id_6 FROM sylius_cms_content_configuration t0 WHERE t0 . page_id = 5 ORDER BY t0 . id ASC ;
Copy
10.02 ms (9.96%)
6
SELECT t0 . slug AS slug_1 , t0 . meta_keywords AS meta_keywords_2 , t0 . meta_description AS meta_description_3 , t0 . title AS title_4 , t0 . teaser_title AS teaser_title_5 , t0 . teaser_content AS teaser_content_6 , t0 . id AS id_7 , t0 . locale AS locale_8 , t0 . translatable_id AS translatable_id_9 , t0 . teaser_image_id AS teaser_image_id_10 FROM sylius_cms_page_translation t0 WHERE t0 . translatable_id = ? AND t0 . locale = ? LIMIT 1
Parameters :
[
5
"en_US "
]
SELECT t0 . slug AS slug_1 , t0 . meta_keywords AS meta_keywords_2 , t0 . meta_description AS meta_description_3 , t0 . title AS title_4 , t0 . teaser_title AS teaser_title_5 , t0 . teaser_content AS teaser_content_6 , t0 . id AS id_7 , t0 . locale AS locale_8 , t0 . translatable_id AS translatable_id_9 , t0 . teaser_image_id AS teaser_image_id_10 FROM sylius_cms_page_translation t0 WHERE t0 . translatable_id = 5 AND t0 . locale = 'en_US' LIMIT 1 ;
Copy
6.74 ms (6.70%)
1
SELECT s0_ . ratio AS ratio_0 , s0_ . created_at AS created_at_1 , s0_ . updated_at AS updated_at_2 , s0_ . id AS id_3 , s1_ . code AS code_4 , s1_ . created_at AS created_at_5 , s1_ . updated_at AS updated_at_6 , s1_ . id AS id_7 , s2_ . code AS code_8 , s2_ . created_at AS created_at_9 , s2_ . updated_at AS updated_at_10 , s2_ . id AS id_11 , s0_ . source_currency AS source_currency_12 , s0_ . target_currency AS target_currency_13 FROM sylius_exchange_rate s0_ INNER JOIN sylius_currency s1_ ON s0_ . source_currency = s1_ . id INNER JOIN sylius_currency s2_ ON s0_ . target_currency = s2_ . id WHERE (s1_ . code = ? AND s2_ . code = ? ) OR (s2_ . code = ? AND s1_ . code = ? ) ORDER BY s0_ . id ASC
Parameters :
[
"USD "
"EUR "
"USD "
"EUR "
]
SELECT s0_ . ratio AS ratio_0 , s0_ . created_at AS created_at_1 , s0_ . updated_at AS updated_at_2 , s0_ . id AS id_3 , s1_ . code AS code_4 , s1_ . created_at AS created_at_5 , s1_ . updated_at AS updated_at_6 , s1_ . id AS id_7 , s2_ . code AS code_8 , s2_ . created_at AS created_at_9 , s2_ . updated_at AS updated_at_10 , s2_ . id AS id_11 , s0_ . source_currency AS source_currency_12 , s0_ . target_currency AS target_currency_13 FROM sylius_exchange_rate s0_ INNER JOIN sylius_currency s1_ ON s0_ . source_currency = s1_ . id INNER JOIN sylius_currency s2_ ON s0_ . target_currency = s2_ . id WHERE (s1_ . code = 'USD' AND s2_ . code = 'EUR' ) OR (s2_ . code = 'USD' AND s1_ . code = 'EUR' ) ORDER BY s0_ . id ASC ;
Copy
3.24 ms (3.22%)
1
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 = ? AND s0_ . tree_root = ? ORDER BY s0_ . id ASC , s2_ . position ASC , s2_ . id ASC
Parameters :
[
"en_US "
12
]
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 = 'en_US' AND s0_ . tree_root = 12 ORDER BY s0_ . id ASC , s2_ . position ASC , s2_ . id ASC ;
Copy
0.98 ms (0.97%)
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 = ? AND t0 . enabled = ? ORDER BY t0 . id ASC LIMIT 1
Parameters :
[
"sundarbans-leder.bdsheba.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 = 'sundarbans-leder.bdsheba.com' AND t0 . enabled = 1 ORDER BY t0 . id ASC LIMIT 1 ;
Copy
0.62 ms (0.61%)
1
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_currency t0 INNER JOIN sylius_channel_currencies ON t0 . id = sylius_channel_currencies . currency_id WHERE sylius_channel_currencies . channel_id = ? ORDER BY t0 . id ASC
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_currency t0 INNER JOIN sylius_channel_currencies ON t0 . id = sylius_channel_currencies . currency_id WHERE sylius_channel_currencies . channel_id = 3 ORDER BY t0 . id ASC ;
Copy
0.61 ms (0.60%)
1
SELECT t0 . code AS code_1 , t0 . name AS name_2 , t0 . type AS type_3 , t0 . id AS id_4 FROM sylius_cms_section t0 INNER JOIN sylius_cms_section_pages ON t0 . id = sylius_cms_section_pages . section_id WHERE sylius_cms_section_pages . page_id = ?
SELECT t0 . code AS code_1 , t0 . name AS name_2 , t0 . type AS type_3 , t0 . id AS id_4 FROM sylius_cms_section t0 INNER JOIN sylius_cms_section_pages ON t0 . id = sylius_cms_section_pages . section_id WHERE sylius_cms_section_pages . page_id = 5 ;
Copy