Symfony Profiler

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

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 = 'forges-preprod.kwantic.dev' AND t0.enabled = 1 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.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.code = ?
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.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.code = 'WEB-EU' LIMIT 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 = 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_.metaTitle AS metaTitle_13,
  s1_.metaRobots AS metaRobots_14,
  s1_.ogTitle AS ogTitle_15,
  s1_.ogDescription AS ogDescription_16,
  s1_.ogImage AS ogImage_17,
  s1_.twitterTitle AS twitterTitle_18,
  s1_.twitterDescription AS twitterDescription_19,
  s1_.metaDescription AS metaDescription_20,
  s1_.locale AS locale_21,
  s0_.tree_root AS tree_root_22,
  s0_.parent_id AS parent_id_23,
  s1_.translatable_id AS translatable_id_24
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

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_.metaTitle AS metaTitle_13, s1_.metaRobots AS metaRobots_14, s1_.ogTitle AS ogTitle_15, s1_.ogDescription AS ogDescription_16, s1_.ogImage AS ogImage_17, s1_.twitterTitle AS twitterTitle_18, s1_.twitterDescription AS twitterDescription_19, s1_.metaDescription AS metaDescription_20, s1_.locale AS locale_21, s0_.tree_root AS tree_root_22, s0_.parent_id AS parent_id_23, s1_.translatable_id AS translatable_id_24 FROM sylius_taxon s0_ INNER JOIN sylius_taxon_translation s1_ ON s0_.id = s1_.translatable_id WHERE s0_.enabled = 1 AND s1_.slug = 'tradition/art-de-la-table' AND s1_.locale = 'en_US' ORDER BY s0_.id ASC;

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 = 8;

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.code = ?
LIMIT
  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.code = 'tradition_art_de_la_table' LIMIT 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.code = ?
LIMIT
  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.code = 'tradition' LIMIT 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.code = ?
LIMIT
  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.code = 'tradition_art_de_la_table' LIMIT 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.parent_id = ?
ORDER BY
  t0.position ASC,
  t0.id ASC

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.parent_id = 10 ORDER BY t0.position ASC, t0.id ASC;

SELECT
  s0_.id AS id_0,
  MIN(s1_.position) AS sclr_1
FROM
  sylius_product s0_
  INNER JOIN sylius_product_channels s3_ ON s0_.id = s3_.product_id
  INNER JOIN sylius_channel s2_ ON s2_.id = s3_.channel_id
  INNER JOIN sylius_product_taxon s4_ ON s0_.id = s4_.product_id
  INNER JOIN sylius_taxon s5_ ON s4_.taxon_id = s5_.id
  INNER JOIN sylius_product_taxon s1_ ON s0_.id = s1_.product_id
  INNER JOIN sylius_taxon s6_ ON s1_.taxon_id = s6_.id
WHERE
  s0_.enabled = 1
  AND s2_.code = ?
  AND s5_.code IN (?)
  AND s6_.code = ?
GROUP BY
  s0_.id
ORDER BY
  sclr_1 ASC

SELECT s0_.id AS id_0, MIN(s1_.position) AS sclr_1 FROM sylius_product s0_ INNER JOIN sylius_product_channels s3_ ON s0_.id = s3_.product_id INNER JOIN sylius_channel s2_ ON s2_.id = s3_.channel_id INNER JOIN sylius_product_taxon s4_ ON s0_.id = s4_.product_id INNER JOIN sylius_taxon s5_ ON s4_.taxon_id = s5_.id INNER JOIN sylius_product_taxon s1_ ON s0_.id = s1_.product_id INNER JOIN sylius_taxon s6_ ON s1_.taxon_id = s6_.id WHERE s0_.enabled = 1 AND s2_.code = 'WEB-EU' AND s5_.code IN ('tradition_art_de_la_table') AND s6_.code = 'tradition_art_de_la_table' GROUP BY s0_.id ORDER BY sclr_1 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_.is_new AS is_new_7,
  s0_.is_iconic AS is_iconic_8,
  s0_.is_featured AS is_featured_9,
  s0_.is_engravable AS is_engravable_10,
  s0_.code_douane AS code_douane_11,
  s1_.name AS name_12,
  s1_.slug AS slug_13,
  s1_.description AS description_14,
  s1_.meta_keywords AS meta_keywords_15,
  s1_.meta_description AS meta_description_16,
  s1_.id AS id_17,
  s1_.short_description AS short_description_18,
  s1_.metaTitle AS metaTitle_19,
  s1_.metaRobots AS metaRobots_20,
  s1_.ogTitle AS ogTitle_21,
  s1_.ogDescription AS ogDescription_22,
  s1_.ogImage AS ogImage_23,
  s1_.twitterTitle AS twitterTitle_24,
  s1_.twitterDescription AS twitterDescription_25,
  s1_.locale AS locale_26,
  s2_.type AS type_27,
  s2_.path AS path_28,
  s2_.id AS id_29,
  s2_.position AS position_30,
  s3_.position AS position_31,
  s3_.id AS id_32,
  s4_.code AS code_33,
  s4_.created_at AS created_at_34,
  s4_.updated_at AS updated_at_35,
  s4_.position AS position_36,
  s4_.enabled AS enabled_37,
  s4_.id AS id_38,
  s4_.version AS version_39,
  s4_.on_hold AS on_hold_40,
  s4_.on_hand AS on_hand_41,
  s4_.tracked AS tracked_42,
  s4_.width AS width_43,
  s4_.height AS height_44,
  s4_.depth AS depth_45,
  s4_.weight AS weight_46,
  s4_.shipping_required AS shipping_required_47,
  s4_.recurring AS recurring_48,
  s4_.recurring_times AS recurring_times_49,
  s4_.recurring_interval AS recurring_interval_50,
  s5_.price AS price_51,
  s5_.original_price AS original_price_52,
  s5_.minimum_price AS minimum_price_53,
  s5_.lowest_price_before_discount AS lowest_price_before_discount_54,
  s5_.channel_code AS channel_code_55,
  s5_.id AS id_56,
  s6_.code AS code_57,
  s6_.id AS id_58,
  s6_.color AS color_59,
  s6_.iconName AS iconName_60,
  s6_.updatedAt AS updatedAt_61,
  s0_.main_taxon_id AS main_taxon_id_62,
  s0_.product_type_id AS product_type_id_63,
  s1_.translatable_id AS translatable_id_64,
  s2_.owner_id AS owner_id_65,
  s3_.product_id AS product_id_66,
  s3_.taxon_id AS taxon_id_67,
  s4_.product_id AS product_id_68,
  s4_.tax_category_id AS tax_category_id_69,
  s4_.shipping_category_id AS shipping_category_id_70,
  s5_.product_variant_id AS product_variant_id_71,
  s6_.option_id AS option_id_72
FROM
  sylius_product s0_
  LEFT JOIN sylius_product_translation s1_ ON s0_.id = s1_.translatable_id
  LEFT JOIN sylius_product_image s2_ ON s0_.id = s2_.owner_id
  LEFT JOIN sylius_product_taxon s3_ ON s0_.id = s3_.product_id
  LEFT JOIN sylius_product_variant s4_ ON s0_.id = s4_.product_id
  LEFT JOIN sylius_channel_pricing s5_ ON s4_.id = s5_.product_variant_id
  LEFT JOIN sylius_product_variant_option_value s7_ ON s4_.id = s7_.variant_id
  LEFT JOIN sylius_product_option_value s6_ ON s6_.id = s7_.option_value_id
WHERE
  s0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?)
ORDER BY
  s0_.id ASC,
  s2_.position ASC,
  s2_.id ASC,
  s3_.id ASC,
  s4_.position ASC,
  s4_.id ASC,
  s5_.id ASC,
  s6_.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_.is_new AS is_new_7, s0_.is_iconic AS is_iconic_8, s0_.is_featured AS is_featured_9, s0_.is_engravable AS is_engravable_10, s0_.code_douane AS code_douane_11, s1_.name AS name_12, s1_.slug AS slug_13, s1_.description AS description_14, s1_.meta_keywords AS meta_keywords_15, s1_.meta_description AS meta_description_16, s1_.id AS id_17, s1_.short_description AS short_description_18, s1_.metaTitle AS metaTitle_19, s1_.metaRobots AS metaRobots_20, s1_.ogTitle AS ogTitle_21, s1_.ogDescription AS ogDescription_22, s1_.ogImage AS ogImage_23, s1_.twitterTitle AS twitterTitle_24, s1_.twitterDescription AS twitterDescription_25, s1_.locale AS locale_26, s2_.type AS type_27, s2_.path AS path_28, s2_.id AS id_29, s2_.position AS position_30, s3_.position AS position_31, s3_.id AS id_32, s4_.code AS code_33, s4_.created_at AS created_at_34, s4_.updated_at AS updated_at_35, s4_.position AS position_36, s4_.enabled AS enabled_37, s4_.id AS id_38, s4_.version AS version_39, s4_.on_hold AS on_hold_40, s4_.on_hand AS on_hand_41, s4_.tracked AS tracked_42, s4_.width AS width_43, s4_.height AS height_44, s4_.depth AS depth_45, s4_.weight AS weight_46, s4_.shipping_required AS shipping_required_47, s4_.recurring AS recurring_48, s4_.recurring_times AS recurring_times_49, s4_.recurring_interval AS recurring_interval_50, s5_.price AS price_51, s5_.original_price AS original_price_52, s5_.minimum_price AS minimum_price_53, s5_.lowest_price_before_discount AS lowest_price_before_discount_54, s5_.channel_code AS channel_code_55, s5_.id AS id_56, s6_.code AS code_57, s6_.id AS id_58, s6_.color AS color_59, s6_.iconName AS iconName_60, s6_.updatedAt AS updatedAt_61, s0_.main_taxon_id AS main_taxon_id_62, s0_.product_type_id AS product_type_id_63, s1_.translatable_id AS translatable_id_64, s2_.owner_id AS owner_id_65, s3_.product_id AS product_id_66, s3_.taxon_id AS taxon_id_67, s4_.product_id AS product_id_68, s4_.tax_category_id AS tax_category_id_69, s4_.shipping_category_id AS shipping_category_id_70, s5_.product_variant_id AS product_variant_id_71, s6_.option_id AS option_id_72 FROM sylius_product s0_ LEFT JOIN sylius_product_translation s1_ ON s0_.id = s1_.translatable_id LEFT JOIN sylius_product_image s2_ ON s0_.id = s2_.owner_id LEFT JOIN sylius_product_taxon s3_ ON s0_.id = s3_.product_id LEFT JOIN sylius_product_variant s4_ ON s0_.id = s4_.product_id LEFT JOIN sylius_channel_pricing s5_ ON s4_.id = s5_.product_variant_id LEFT JOIN sylius_product_variant_option_value s7_ ON s4_.id = s7_.variant_id LEFT JOIN sylius_product_option_value s6_ ON s6_.id = s7_.option_value_id WHERE s0_.id IN (627, 628, 632, 640, 633, 641, 634, 642, 635) ORDER BY s0_.id ASC, s2_.position ASC, s2_.id ASC, s3_.id ASC, s4_.position ASC, s4_.id ASC, s5_.id ASC, s6_.id ASC;

SELECT
  s0_.code AS code_0,
  count(DISTINCT s1_.product_id) AS sclr_1
FROM
  sylius_product_taxon s1_
  INNER JOIN sylius_taxon s0_ ON s1_.taxon_id = s0_.id
WHERE
  s1_.product_id IN (
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?
  )
GROUP BY
  s0_.code

SELECT s0_.code AS code_0, count(DISTINCT s1_.product_id) AS sclr_1 FROM sylius_product_taxon s1_ INNER JOIN sylius_taxon s0_ ON s1_.taxon_id = s0_.id WHERE s1_.product_id IN (627, 628, 632, 640, 633, 641, 634, 642, 635, 643, 644, 645, 646, 661, 647, 681, 648, 682, 649, 698, 650, 722, 651, 723, 652, 724, 653, 725, 726, 727, 728, 729, 705, 730, 706, 731, 707, 746, 708, 747, 709, 847, 710, 848, 711, 880, 712, 906, 713, 907, 714, 908, 715, 909, 716, 910, 717, 911, 718, 912, 719, 913, 720, 914, 721, 929, 930, 931, 932, 933, 934, 935, 936, 937, 938, 939, 940, 941, 803, 942, 804, 943, 944, 945, 829, 946, 830, 947, 831, 948, 832, 949, 892, 950, 893, 951, 927, 952, 928, 953, 954, 955, 956, 957, 1030, 958, 1031, 959, 1032, 960, 1033, 961, 1109, 962, 1110, 963, 1111, 973, 1112, 974, 1113, 975, 1114, 976, 1115, 977, 1116, 1011, 1117, 1012, 1013, 1014, 1015, 1016, 1118, 1119, 1120, 1121, 1122, 1123, 1124, 1125, 1126, 1127, 1128, 1133, 1198, 1134, 1135, 1246, 1136, 1137, 1138, 1139, 1140, 1141, 1142, 1143, 1144, 1178, 1179, 1180, 1181, 1182, 1183, 1184, 1185, 1186, 1187, 1188, 1189, 1190, 1191, 1192, 1193, 1194, 1195, 1196, 1197, 1199, 1200, 1201, 1232, 1346) GROUP BY s0_.code;