1.75 ms
(13.70%)
|
4 |
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 = 90 AND t0.enabled = 1 ORDER BY t0.position ASC, t0.id ASC LIMIT 1;
|
1.71 ms
(13.43%)
|
4 |
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 = 90 ORDER BY t0.position ASC, t0.id ASC;
|
1.30 ms
(10.18%)
|
4 |
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 = 810 ORDER BY t0.id ASC;
|
1.28 ms
(10.01%)
|
4 |
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 = 390 ORDER BY t0.id ASC;
|
1.24 ms
(9.76%)
|
4 |
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 = 390 ORDER BY t0.id ASC;
|
1.17 ms
(9.20%)
|
4 |
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 = 90 ORDER BY t0.position ASC, t0.id ASC;
|
0.83 ms
(6.49%)
|
2 |
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
"6d057f9d-d160-446c-8aff-1472196731af"
]
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 = '6d057f9d-d160-446c-8aff-1472196731af' ORDER BY s0_.id ASC;
|
0.68 ms
(5.30%)
|
1 |
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, s1_.name AS name_14, s1_.slug AS slug_15, s1_.description AS description_16, s1_.meta_keywords AS meta_keywords_17, s1_.meta_description AS meta_description_18, s1_.id AS id_19, s1_.short_description AS short_description_20, s1_.locale AS locale_21, s0_.main_taxon_id AS main_taxon_id_22, s0_.product_type_id AS product_type_id_23, s1_.translatable_id AS translatable_id_24 FROM sylius_product s0_ LEFT JOIN sylius_product_customer_groups s3_ ON s0_.id = s3_.product_id LEFT JOIN sylius_customer_group s2_ ON s2_.id = s3_.customer_group_id LEFT JOIN sylius_product_organizations s5_ ON s0_.id = s5_.product_id LEFT JOIN sylius_organization s4_ ON s4_.id = s5_.organization_id INNER JOIN sylius_product_translation s1_ ON s0_.id = s1_.translatable_id AND (s1_.locale = ?) WHERE (s2_.id IS NULL AND s4_.id IS NULL) AND EXISTS (SELECT 1 FROM sylius_product_channels s6_ WHERE s6_.product_id = s0_.id AND s6_.channel_id IN (?)) AND s0_.enabled = ? ORDER BY s0_.created_at DESC, s0_.id ASC LIMIT 4
Parameters: [
"fr_FR"
7
1
]
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, s1_.name AS name_14, s1_.slug AS slug_15, s1_.description AS description_16, s1_.meta_keywords AS meta_keywords_17, s1_.meta_description AS meta_description_18, s1_.id AS id_19, s1_.short_description AS short_description_20, s1_.locale AS locale_21, s0_.main_taxon_id AS main_taxon_id_22, s0_.product_type_id AS product_type_id_23, s1_.translatable_id AS translatable_id_24 FROM sylius_product s0_ LEFT JOIN sylius_product_customer_groups s3_ ON s0_.id = s3_.product_id LEFT JOIN sylius_customer_group s2_ ON s2_.id = s3_.customer_group_id LEFT JOIN sylius_product_organizations s5_ ON s0_.id = s5_.product_id LEFT JOIN sylius_organization s4_ ON s4_.id = s5_.organization_id INNER JOIN sylius_product_translation s1_ ON s0_.id = s1_.translatable_id AND (s1_.locale = 'fr_FR') WHERE (s2_.id IS NULL AND s4_.id IS NULL) AND EXISTS (SELECT 1 FROM sylius_product_channels s6_ WHERE s6_.product_id = s0_.id AND s6_.channel_id IN (7)) AND s0_.enabled = 1 ORDER BY s0_.created_at DESC, s0_.id ASC LIMIT 4;
|
0.54 ms
(4.23%)
|
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
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
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;
|
0.53 ms
(4.15%)
|
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: [
"fr_FR"
34
]
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' AND s0_.tree_root = 34 ORDER BY s0_.id ASC, s2_.position ASC, s2_.id ASC;
|
0.41 ms
(3.23%)
|
2 |
SELECT t0.name AS name_1, t0.slug AS slug_2, t0.description AS description_3, t0.id AS id_4, t0.locale AS locale_5, t0.translatable_id AS translatable_id_6 FROM sylius_taxon_translation t0 WHERE t0.translatable_id = ? AND t0.locale = ? LIMIT 1
Parameters: [
50
"fr_FR"
]
SELECT t0.name AS name_1, t0.slug AS slug_2, t0.description AS description_3, t0.id AS id_4, t0.locale AS locale_5, t0.translatable_id AS translatable_id_6 FROM sylius_taxon_translation t0 WHERE t0.translatable_id = 50 AND t0.locale = 'fr_FR' LIMIT 1;
|
0.38 ms
(3.02%)
|
1 |
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;
|
0.38 ms
(3.00%)
|
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: [
"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;
|
0.35 ms
(2.76%)
|
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 = 7;
|
0.20 ms
(1.55%)
|
1 |
SELECT t0.code AS code_1, t0.tree_left AS tree_left_2, t0.tree_right AS tree_right_3, t0.tree_level AS tree_level_4, t0.position AS position_5, t0.enabled AS enabled_6, t0.id AS id_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.tree_root AS tree_root_10, t0.parent_id AS parent_id_11 FROM sylius_taxon t0 WHERE t0.id = ?
SELECT t0.code AS code_1, t0.tree_left AS tree_left_2, t0.tree_right AS tree_right_3, t0.tree_level AS tree_level_4, t0.position AS position_5, t0.enabled AS enabled_6, t0.id AS id_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.tree_root AS tree_root_10, t0.parent_id AS parent_id_11 FROM sylius_taxon t0 WHERE t0.id = 34;
|