Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.product_variant_id AS product_variant_id_2,
  t3.code AS code_4,
  t3.created_at AS created_at_5,
  t3.updated_at AS updated_at_6,
  t3.position AS position_7,
  t3.enabled AS enabled_8,
  t3.id AS id_9,
  t3.version AS version_10,
  t3.on_hold AS on_hold_11,
  t3.on_hand AS on_hand_12,
  t3.tracked AS tracked_13,
  t3.width AS width_14,
  t3.height AS height_15,
  t3.depth AS depth_16,
  t3.weight AS weight_17,
  t3.shipping_required AS shipping_required_18,
  t3.incoming_stock AS incoming_stock_19,
  t3.date_incoming_stock AS date_incoming_stock_20,
  t3.main_material AS main_material_21,
  t3.gift_for AS gift_for_22,
  t3.coating_type AS coating_type_23,
  t3.coating_vegetal AS coating_vegetal_24,
  t3.badge AS badge_25,
  t3.tags AS tags_26,
  t3.price_per_two AS price_per_two_27,
  t3.old_url AS old_url_28,
  t3.is_blocked AS is_blocked_29,
  t3.product_id AS product_id_30,
  t3.tax_category_id AS tax_category_id_31,
  t3.shipping_category_id AS shipping_category_id_32,
  t0.taxon_id AS taxon_id_33,
  t34.code AS code_35,
  t34.tree_left AS tree_left_36,
  t34.tree_right AS tree_right_37,
  t34.tree_level AS tree_level_38,
  t34.position AS position_39,
  t34.enabled AS enabled_40,
  t34.id AS id_41,
  t34.created_at AS created_at_42,
  t34.updated_at AS updated_at_43,
  t34.category_type AS category_type_44,
  t34.referencement AS referencement_45,
  t34.referencementen AS referencementen_46,
  t34.seo_links AS seo_links_47,
  t34.single_article_category_title AS single_article_category_title_48,
  t34.single_article_category_title_en AS single_article_category_title_en_49,
  t34.ctas AS ctas_50,
  t34.ctasen AS ctasen_51,
  t34.filters AS filters_52,
  t34.automatic AS automatic_53,
  t34.tree_root AS tree_root_54,
  t34.parent_id AS parent_id_55,
  t34.article_id AS article_id_56,
  t34.article_category_id AS article_category_id_57
FROM
  sylius_product_variant_taxon t0
  LEFT JOIN sylius_product_variant t3 ON t0.product_variant_id = t3.id
  LEFT JOIN sylius_taxon t34 ON t0.taxon_id = t34.id
WHERE
  t0.product_variant_id = ?

SELECT t0.id AS id_1, t0.product_variant_id AS product_variant_id_2, t3.code AS code_4, t3.created_at AS created_at_5, t3.updated_at AS updated_at_6, t3.position AS position_7, t3.enabled AS enabled_8, t3.id AS id_9, t3.version AS version_10, t3.on_hold AS on_hold_11, t3.on_hand AS on_hand_12, t3.tracked AS tracked_13, t3.width AS width_14, t3.height AS height_15, t3.depth AS depth_16, t3.weight AS weight_17, t3.shipping_required AS shipping_required_18, t3.incoming_stock AS incoming_stock_19, t3.date_incoming_stock AS date_incoming_stock_20, t3.main_material AS main_material_21, t3.gift_for AS gift_for_22, t3.coating_type AS coating_type_23, t3.coating_vegetal AS coating_vegetal_24, t3.badge AS badge_25, t3.tags AS tags_26, t3.price_per_two AS price_per_two_27, t3.old_url AS old_url_28, t3.is_blocked AS is_blocked_29, t3.product_id AS product_id_30, t3.tax_category_id AS tax_category_id_31, t3.shipping_category_id AS shipping_category_id_32, t0.taxon_id AS taxon_id_33, t34.code AS code_35, t34.tree_left AS tree_left_36, t34.tree_right AS tree_right_37, t34.tree_level AS tree_level_38, t34.position AS position_39, t34.enabled AS enabled_40, t34.id AS id_41, t34.created_at AS created_at_42, t34.updated_at AS updated_at_43, t34.category_type AS category_type_44, t34.referencement AS referencement_45, t34.referencementen AS referencementen_46, t34.seo_links AS seo_links_47, t34.single_article_category_title AS single_article_category_title_48, t34.single_article_category_title_en AS single_article_category_title_en_49, t34.ctas AS ctas_50, t34.ctasen AS ctasen_51, t34.filters AS filters_52, t34.automatic AS automatic_53, t34.tree_root AS tree_root_54, t34.parent_id AS parent_id_55, t34.article_id AS article_id_56, t34.article_category_id AS article_category_id_57 FROM sylius_product_variant_taxon t0 LEFT JOIN sylius_product_variant t3 ON t0.product_variant_id = t3.id LEFT JOIN sylius_taxon t34 ON t0.taxon_id = t34.id WHERE t0.product_variant_id = 41832;

SELECT
  t0.locale_code AS locale_code_1,
  t0.text_value AS text_value_2,
  t0.boolean_value AS boolean_value_3,
  t0.integer_value AS integer_value_4,
  t0.float_value AS float_value_5,
  t0.datetime_value AS datetime_value_6,
  t0.date_value AS date_value_7,
  t0.json_value AS json_value_8,
  t0.id AS id_9,
  t0.variant_id AS variant_id_10,
  t0.attribute_id AS attribute_id_11
FROM
  sylius_product_variant_attribute_value t0
WHERE
  t0.variant_id = ?

SELECT t0.locale_code AS locale_code_1, t0.text_value AS text_value_2, t0.boolean_value AS boolean_value_3, t0.integer_value AS integer_value_4, t0.float_value AS float_value_5, t0.datetime_value AS datetime_value_6, t0.date_value AS date_value_7, t0.json_value AS json_value_8, t0.id AS id_9, t0.variant_id AS variant_id_10, t0.attribute_id AS attribute_id_11 FROM sylius_product_variant_attribute_value t0 WHERE t0.variant_id = 41832;

SELECT
  s0_.code AS code_0,
  s0_.created_at AS created_at_1,
  s0_.updated_at AS updated_at_2,
  s0_.position AS position_3,
  s0_.enabled AS enabled_4,
  s0_.id AS id_5,
  s0_.version AS version_6,
  s0_.on_hold AS on_hold_7,
  s0_.on_hand AS on_hand_8,
  s0_.tracked AS tracked_9,
  s0_.width AS width_10,
  s0_.height AS height_11,
  s0_.depth AS depth_12,
  s0_.weight AS weight_13,
  s0_.shipping_required AS shipping_required_14,
  s0_.incoming_stock AS incoming_stock_15,
  s0_.date_incoming_stock AS date_incoming_stock_16,
  s0_.main_material AS main_material_17,
  s0_.gift_for AS gift_for_18,
  s0_.coating_type AS coating_type_19,
  s0_.coating_vegetal AS coating_vegetal_20,
  s0_.badge AS badge_21,
  s0_.tags AS tags_22,
  s0_.price_per_two AS price_per_two_23,
  s0_.old_url AS old_url_24,
  s0_.is_blocked AS is_blocked_25,
  s0_.product_id AS product_id_26,
  s0_.tax_category_id AS tax_category_id_27,
  s0_.shipping_category_id AS shipping_category_id_28
FROM
  sylius_product_variant s0_
  INNER JOIN sylius_product_variant_translation s1_ ON s0_.id = s1_.translatable_id
  AND (s1_.locale = ?)
  LEFT JOIN sylius_product s2_ ON s0_.product_id = s2_.id
  LEFT JOIN sylius_product_taxon s3_ ON s2_.id = s3_.product_id
  LEFT JOIN sylius_product_attribute_value s4_ ON s2_.id = s4_.product_id
WHERE
  s0_.enabled = 1
  AND (
    s3_.taxon_id IN (?)
    OR s2_.main_taxon_id IN (?)
  )
  AND s0_.badge = ?

SELECT s0_.code AS code_0, s0_.created_at AS created_at_1, s0_.updated_at AS updated_at_2, s0_.position AS position_3, s0_.enabled AS enabled_4, s0_.id AS id_5, s0_.version AS version_6, s0_.on_hold AS on_hold_7, s0_.on_hand AS on_hand_8, s0_.tracked AS tracked_9, s0_.width AS width_10, s0_.height AS height_11, s0_.depth AS depth_12, s0_.weight AS weight_13, s0_.shipping_required AS shipping_required_14, s0_.incoming_stock AS incoming_stock_15, s0_.date_incoming_stock AS date_incoming_stock_16, s0_.main_material AS main_material_17, s0_.gift_for AS gift_for_18, s0_.coating_type AS coating_type_19, s0_.coating_vegetal AS coating_vegetal_20, s0_.badge AS badge_21, s0_.tags AS tags_22, s0_.price_per_two AS price_per_two_23, s0_.old_url AS old_url_24, s0_.is_blocked AS is_blocked_25, s0_.product_id AS product_id_26, s0_.tax_category_id AS tax_category_id_27, s0_.shipping_category_id AS shipping_category_id_28 FROM sylius_product_variant s0_ INNER JOIN sylius_product_variant_translation s1_ ON s0_.id = s1_.translatable_id AND (s1_.locale = 'fr_FR') LEFT JOIN sylius_product s2_ ON s0_.product_id = s2_.id LEFT JOIN sylius_product_taxon s3_ ON s2_.id = s3_.product_id LEFT JOIN sylius_product_attribute_value s4_ ON s2_.id = s4_.product_id WHERE s0_.enabled = 1 AND (s3_.taxon_id IN (194, 195, 196, 197, 198, 199, 200, 201) OR s2_.main_taxon_id IN (194, 195, 196, 197, 198, 199, 200, 201)) AND s0_.badge = 'newest';

SELECT
  t0.name AS name_1,
  t0.description AS description_2,
  t0.meta_keywords AS meta_keywords_3,
  t0.meta_description AS meta_description_4,
  t0.id AS id_5,
  t0.short_description AS short_description_6,
  t0.advantages AS advantages_7,
  t0.maintenance AS maintenance_8,
  t0.small_add_text AS small_add_text_9,
  t0.slug AS slug_10,
  t0.locale AS locale_11,
  t0.translatable_id AS translatable_id_12
FROM
  sylius_product_translation t0
WHERE
  t0.translatable_id = ?
  AND t0.locale = ?
LIMIT
  1

SELECT t0.name AS name_1, t0.description AS description_2, t0.meta_keywords AS meta_keywords_3, t0.meta_description AS meta_description_4, t0.id AS id_5, t0.short_description AS short_description_6, t0.advantages AS advantages_7, t0.maintenance AS maintenance_8, t0.small_add_text AS small_add_text_9, t0.slug AS slug_10, t0.locale AS locale_11, t0.translatable_id AS translatable_id_12 FROM sylius_product_translation t0 WHERE t0.translatable_id = 2241 AND t0.locale = 'fr_FR' LIMIT 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_.category_type AS category_type_9,
  s0_.referencement AS referencement_10,
  s0_.referencementen AS referencementen_11,
  s0_.seo_links AS seo_links_12,
  s0_.single_article_category_title AS single_article_category_title_13,
  s0_.single_article_category_title_en AS single_article_category_title_en_14,
  s0_.ctas AS ctas_15,
  s0_.ctasen AS ctasen_16,
  s0_.filters AS filters_17,
  s0_.automatic AS automatic_18,
  s1_.name AS name_19,
  s1_.description AS description_20,
  s1_.id AS id_21,
  s1_.seo_title AS seo_title_22,
  s1_.seo_meta_description AS seo_meta_description_23,
  s1_.rectangle_orange_text AS rectangle_orange_text_24,
  s1_.rectangle_orange_text_button AS rectangle_orange_text_button_25,
  s1_.rectangle_orange_text_url AS rectangle_orange_text_url_26,
  s1_.link_image_lastlevel1 AS link_image_lastlevel1_27,
  s1_.link_image_lastlevel2 AS link_image_lastlevel2_28,
  s1_.slug AS slug_29,
  s1_.locale AS locale_30,
  s2_.code AS code_31,
  s2_.tree_left AS tree_left_32,
  s2_.tree_right AS tree_right_33,
  s2_.tree_level AS tree_level_34,
  s2_.position AS position_35,
  s2_.enabled AS enabled_36,
  s2_.id AS id_37,
  s2_.created_at AS created_at_38,
  s2_.updated_at AS updated_at_39,
  s2_.category_type AS category_type_40,
  s2_.referencement AS referencement_41,
  s2_.referencementen AS referencementen_42,
  s2_.seo_links AS seo_links_43,
  s2_.single_article_category_title AS single_article_category_title_44,
  s2_.single_article_category_title_en AS single_article_category_title_en_45,
  s2_.ctas AS ctas_46,
  s2_.ctasen AS ctasen_47,
  s2_.filters AS filters_48,
  s2_.automatic AS automatic_49,
  s0_.tree_root AS tree_root_50,
  s0_.parent_id AS parent_id_51,
  s0_.article_id AS article_id_52,
  s0_.article_category_id AS article_category_id_53,
  s1_.translatable_id AS translatable_id_54,
  s2_.tree_root AS tree_root_55,
  s2_.parent_id AS parent_id_56,
  s2_.article_id AS article_id_57,
  s2_.article_category_id AS article_category_id_58
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_.tree_left > ?
  AND s0_.tree_right < ?
  AND s0_.tree_level > ?
  AND s0_.tree_root = ?
ORDER BY
  s0_.tree_level ASC,
  s0_.position ASC,
  s2_.position 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_.category_type AS category_type_9, s0_.referencement AS referencement_10, s0_.referencementen AS referencementen_11, s0_.seo_links AS seo_links_12, s0_.single_article_category_title AS single_article_category_title_13, s0_.single_article_category_title_en AS single_article_category_title_en_14, s0_.ctas AS ctas_15, s0_.ctasen AS ctasen_16, s0_.filters AS filters_17, s0_.automatic AS automatic_18, s1_.name AS name_19, s1_.description AS description_20, s1_.id AS id_21, s1_.seo_title AS seo_title_22, s1_.seo_meta_description AS seo_meta_description_23, s1_.rectangle_orange_text AS rectangle_orange_text_24, s1_.rectangle_orange_text_button AS rectangle_orange_text_button_25, s1_.rectangle_orange_text_url AS rectangle_orange_text_url_26, s1_.link_image_lastlevel1 AS link_image_lastlevel1_27, s1_.link_image_lastlevel2 AS link_image_lastlevel2_28, s1_.slug AS slug_29, s1_.locale AS locale_30, s2_.code AS code_31, s2_.tree_left AS tree_left_32, s2_.tree_right AS tree_right_33, s2_.tree_level AS tree_level_34, s2_.position AS position_35, s2_.enabled AS enabled_36, s2_.id AS id_37, s2_.created_at AS created_at_38, s2_.updated_at AS updated_at_39, s2_.category_type AS category_type_40, s2_.referencement AS referencement_41, s2_.referencementen AS referencementen_42, s2_.seo_links AS seo_links_43, s2_.single_article_category_title AS single_article_category_title_44, s2_.single_article_category_title_en AS single_article_category_title_en_45, s2_.ctas AS ctas_46, s2_.ctasen AS ctasen_47, s2_.filters AS filters_48, s2_.automatic AS automatic_49, s0_.tree_root AS tree_root_50, s0_.parent_id AS parent_id_51, s0_.article_id AS article_id_52, s0_.article_category_id AS article_category_id_53, s1_.translatable_id AS translatable_id_54, s2_.tree_root AS tree_root_55, s2_.parent_id AS parent_id_56, s2_.article_id AS article_id_57, s2_.article_category_id AS article_category_id_58 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_.tree_left > 158 AND s0_.tree_right < 173 AND s0_.tree_level > 1 AND s0_.tree_root = 1 ORDER BY s0_.tree_level ASC, s0_.position ASC, s2_.position 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_.category_type AS category_type_9,
  s0_.referencement AS referencement_10,
  s0_.referencementen AS referencementen_11,
  s0_.seo_links AS seo_links_12,
  s0_.single_article_category_title AS single_article_category_title_13,
  s0_.single_article_category_title_en AS single_article_category_title_en_14,
  s0_.ctas AS ctas_15,
  s0_.ctasen AS ctasen_16,
  s0_.filters AS filters_17,
  s0_.automatic AS automatic_18,
  s1_.name AS name_19,
  s1_.description AS description_20,
  s1_.id AS id_21,
  s1_.seo_title AS seo_title_22,
  s1_.seo_meta_description AS seo_meta_description_23,
  s1_.rectangle_orange_text AS rectangle_orange_text_24,
  s1_.rectangle_orange_text_button AS rectangle_orange_text_button_25,
  s1_.rectangle_orange_text_url AS rectangle_orange_text_url_26,
  s1_.link_image_lastlevel1 AS link_image_lastlevel1_27,
  s1_.link_image_lastlevel2 AS link_image_lastlevel2_28,
  s1_.slug AS slug_29,
  s1_.locale AS locale_30,
  s0_.tree_root AS tree_root_31,
  s0_.parent_id AS parent_id_32,
  s0_.article_id AS article_id_33,
  s0_.article_category_id AS article_category_id_34,
  s1_.translatable_id AS translatable_id_35
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 = ?

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_.category_type AS category_type_9, s0_.referencement AS referencement_10, s0_.referencementen AS referencementen_11, s0_.seo_links AS seo_links_12, s0_.single_article_category_title AS single_article_category_title_13, s0_.single_article_category_title_en AS single_article_category_title_en_14, s0_.ctas AS ctas_15, s0_.ctasen AS ctasen_16, s0_.filters AS filters_17, s0_.automatic AS automatic_18, s1_.name AS name_19, s1_.description AS description_20, s1_.id AS id_21, s1_.seo_title AS seo_title_22, s1_.seo_meta_description AS seo_meta_description_23, s1_.rectangle_orange_text AS rectangle_orange_text_24, s1_.rectangle_orange_text_button AS rectangle_orange_text_button_25, s1_.rectangle_orange_text_url AS rectangle_orange_text_url_26, s1_.link_image_lastlevel1 AS link_image_lastlevel1_27, s1_.link_image_lastlevel2 AS link_image_lastlevel2_28, s1_.slug AS slug_29, s1_.locale AS locale_30, s0_.tree_root AS tree_root_31, s0_.parent_id AS parent_id_32, s0_.article_id AS article_id_33, s0_.article_category_id AS article_category_id_34, s1_.translatable_id AS translatable_id_35 FROM sylius_taxon s0_ INNER JOIN sylius_taxon_translation s1_ ON s0_.id = s1_.translatable_id WHERE s0_.enabled = 1 AND s1_.slug = 'nos-produits/univers-bebe' AND s1_.locale = 'fr_FR';

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.category_type AS category_type_10,
  t0.referencement AS referencement_11,
  t0.referencementen AS referencementen_12,
  t0.seo_links AS seo_links_13,
  t0.single_article_category_title AS single_article_category_title_14,
  t0.single_article_category_title_en AS single_article_category_title_en_15,
  t0.ctas AS ctas_16,
  t0.ctasen AS ctasen_17,
  t0.filters AS filters_18,
  t0.automatic AS automatic_19,
  t0.tree_root AS tree_root_20,
  t0.parent_id AS parent_id_21,
  t0.article_id AS article_id_22,
  t0.article_category_id AS article_category_id_23
FROM
  sylius_taxon t0

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.category_type AS category_type_10, t0.referencement AS referencement_11, t0.referencementen AS referencementen_12, t0.seo_links AS seo_links_13, t0.single_article_category_title AS single_article_category_title_14, t0.single_article_category_title_en AS single_article_category_title_en_15, t0.ctas AS ctas_16, t0.ctasen AS ctasen_17, t0.filters AS filters_18, t0.automatic AS automatic_19, t0.tree_root AS tree_root_20, t0.parent_id AS parent_id_21, t0.article_id AS article_id_22, t0.article_category_id AS article_category_id_23 FROM sylius_taxon t0;

SELECT
  t0.name AS name_1,
  t0.new AS new_2,
  t0.enabled AS enabled_3,
  t0.category AS category_4,
  t0.main_color AS main_color_5,
  t0.colors AS colors_6,
  t0.dateRelease AS dateRelease_7,
  t0.createdAt AS createdAt_8,
  t0.updatedAt AS updatedAt_9,
  t0.visible AS visible_10,
  t0.replay AS replay_11,
  t0.id AS id_12,
  t0.article_id AS article_id_13,
  t0.product_option_value_id AS product_option_value_id_14
FROM
  site_collection t0
WHERE
  t0.product_option_value_id IN (?)

SELECT t0.name AS name_1, t0.new AS new_2, t0.enabled AS enabled_3, t0.category AS category_4, t0.main_color AS main_color_5, t0.colors AS colors_6, t0.dateRelease AS dateRelease_7, t0.createdAt AS createdAt_8, t0.updatedAt AS updatedAt_9, t0.visible AS visible_10, t0.replay AS replay_11, t0.id AS id_12, t0.article_id AS article_id_13, t0.product_option_value_id AS product_option_value_id_14 FROM site_collection t0 WHERE t0.product_option_value_id IN ('4193', '4248', '4056', '3970', '4059', '4192', '4211', '3672', '4116', '4253', '1', '1000', '3835', '4089', '4133', '4138', '4040', '4043', '4120', '4127', '3318', '3675', '37', '3883', '4085', '4125', '4129', '4132', '4153', '3579', '38', '3998', '4086', '4191', '4220', '48', '4080', '4117', '3957', '3976', '3999', '4055', '4058', '4202', '4212', '4224', '4249', '51', '34', '35', '3905', '4140', '4240', '1721', '33', '3519', '36', '3682', '3695', '3906', '3926', '3954', '4081', '4088', '1678', '1742', '1791', '1794', '1795', '3401', '3402', '3524', '3580', '3641', '3648', '3649', '3650', '3663', '3664', '3680', '3698', '3829', '3830', '3838', '3882', '3894', '3895', '39', '3935', '3956', '3958', '3977', '4025', '4038', '4041', '4071', '4079', '4087', '4090', '4126', '4141', '4203', '4213', '4245', '4250', '4252', '4258', '4262', '53', '790');

SELECT
  s0_.code AS code_0,
  s0_.created_at AS created_at_1,
  s0_.updated_at AS updated_at_2,
  s0_.position AS position_3,
  s0_.enabled AS enabled_4,
  s0_.id AS id_5,
  s0_.version AS version_6,
  s0_.on_hold AS on_hold_7,
  s0_.on_hand AS on_hand_8,
  s0_.tracked AS tracked_9,
  s0_.width AS width_10,
  s0_.height AS height_11,
  s0_.depth AS depth_12,
  s0_.weight AS weight_13,
  s0_.shipping_required AS shipping_required_14,
  s0_.incoming_stock AS incoming_stock_15,
  s0_.date_incoming_stock AS date_incoming_stock_16,
  s0_.main_material AS main_material_17,
  s0_.gift_for AS gift_for_18,
  s0_.coating_type AS coating_type_19,
  s0_.coating_vegetal AS coating_vegetal_20,
  s0_.badge AS badge_21,
  s0_.tags AS tags_22,
  s0_.price_per_two AS price_per_two_23,
  s0_.old_url AS old_url_24,
  s0_.is_blocked AS is_blocked_25,
  s0_.product_id AS product_id_26,
  s0_.tax_category_id AS tax_category_id_27,
  s0_.shipping_category_id AS shipping_category_id_28
FROM
  sylius_product_variant s0_
WHERE
  s0_.id IN (?)
ORDER BY
  FIELD(
    s0_.id, 41832, 41494, 41565, 41499,
    41496, 41826, 41468, 41568, 41828,
    41830, 41831, 41557, 41554, 41497,
    41551, 41558, 41827, 33394, 41421,
    41359, 41428, 41422, 41426, 38197,
    32589, 38422, 38425, 40179, 38423,
    33476, 37257, 38944, 37256, 37474,
    38310, 38477, 37542, 28512, 38968,
    32328
  ) ASC

SELECT s0_.code AS code_0, s0_.created_at AS created_at_1, s0_.updated_at AS updated_at_2, s0_.position AS position_3, s0_.enabled AS enabled_4, s0_.id AS id_5, s0_.version AS version_6, s0_.on_hold AS on_hold_7, s0_.on_hand AS on_hand_8, s0_.tracked AS tracked_9, s0_.width AS width_10, s0_.height AS height_11, s0_.depth AS depth_12, s0_.weight AS weight_13, s0_.shipping_required AS shipping_required_14, s0_.incoming_stock AS incoming_stock_15, s0_.date_incoming_stock AS date_incoming_stock_16, s0_.main_material AS main_material_17, s0_.gift_for AS gift_for_18, s0_.coating_type AS coating_type_19, s0_.coating_vegetal AS coating_vegetal_20, s0_.badge AS badge_21, s0_.tags AS tags_22, s0_.price_per_two AS price_per_two_23, s0_.old_url AS old_url_24, s0_.is_blocked AS is_blocked_25, s0_.product_id AS product_id_26, s0_.tax_category_id AS tax_category_id_27, s0_.shipping_category_id AS shipping_category_id_28 FROM sylius_product_variant s0_ WHERE s0_.id IN ('41832', '41494', '41565', '41499', '41496', '41826', '41468', '41568', '41828', '41830', '41831', '41557', '41554', '41497', '41551', '41558', '41827', '33394', '41421', '41359', '41428', '41422', '41426', '38197', '32589', '38422', '38425', '40179', '38423', '33476', '37257', '38944', '37256', '37474', '38310', '38477', '37542', '28512', '38968', '32328') ORDER BY FIELD(s0_.id, 41832, 41494, 41565, 41499, 41496, 41826, 41468, 41568, 41828, 41830, 41831, 41557, 41554, 41497, 41551, 41558, 41827, 33394, 41421, 41359, 41428, 41422, 41426, 38197, 32589, 38422, 38425, 40179, 38423, 33476, 37257, 38944, 37256, 37474, 38310, 38477, 37542, 28512, 38968, 32328) ASC;

SELECT
  s0_.source AS source_0,
  s0_.destination AS destination_1,
  s0_.permanent AS permanent_2,
  s0_.count AS count_3,
  s0_.last_accessed AS last_accessed_4,
  s0_.enabled AS enabled_5,
  s0_.only_404 AS only_404_6,
  s0_.created_at AS created_at_7,
  s0_.updated_at AS updated_at_8,
  s0_.id AS id_9,
  s1_.code AS code_10,
  s1_.name AS name_11,
  s1_.color AS color_12,
  s1_.description AS description_13,
  s1_.enabled AS enabled_14,
  s1_.hostname AS hostname_15,
  s1_.created_at AS created_at_16,
  s1_.updated_at AS updated_at_17,
  s1_.id AS id_18,
  s1_.theme_name AS theme_name_19,
  s1_.tax_calculation_strategy AS tax_calculation_strategy_20,
  s1_.contact_email AS contact_email_21,
  s1_.contact_phone_number AS contact_phone_number_22,
  s1_.skipping_shipping_step_allowed AS skipping_shipping_step_allowed_23,
  s1_.skipping_payment_step_allowed AS skipping_payment_step_allowed_24,
  s1_.account_verification_required AS account_verification_required_25,
  s1_.shop_billing_data_id AS shop_billing_data_id_26,
  s1_.default_locale_id AS default_locale_id_27,
  s1_.base_currency_id AS base_currency_id_28,
  s1_.default_tax_zone_id AS default_tax_zone_id_29,
  s1_.menu_taxon_id AS menu_taxon_id_30
FROM
  setono_sylius_redirect__redirect s0_
  LEFT JOIN setono_sylius_redirect__redirect_channels s2_ ON s0_.id = s2_.redirect_id
  LEFT JOIN sylius_channel s1_ ON s1_.id = s2_.channel_id
WHERE
  s0_.source = ?
  AND s0_.enabled = 1
  AND s0_.only_404 = ?

SELECT s0_.source AS source_0, s0_.destination AS destination_1, s0_.permanent AS permanent_2, s0_.count AS count_3, s0_.last_accessed AS last_accessed_4, s0_.enabled AS enabled_5, s0_.only_404 AS only_404_6, s0_.created_at AS created_at_7, s0_.updated_at AS updated_at_8, s0_.id AS id_9, s1_.code AS code_10, s1_.name AS name_11, s1_.color AS color_12, s1_.description AS description_13, s1_.enabled AS enabled_14, s1_.hostname AS hostname_15, s1_.created_at AS created_at_16, s1_.updated_at AS updated_at_17, s1_.id AS id_18, s1_.theme_name AS theme_name_19, s1_.tax_calculation_strategy AS tax_calculation_strategy_20, s1_.contact_email AS contact_email_21, s1_.contact_phone_number AS contact_phone_number_22, s1_.skipping_shipping_step_allowed AS skipping_shipping_step_allowed_23, s1_.skipping_payment_step_allowed AS skipping_payment_step_allowed_24, s1_.account_verification_required AS account_verification_required_25, s1_.shop_billing_data_id AS shop_billing_data_id_26, s1_.default_locale_id AS default_locale_id_27, s1_.base_currency_id AS base_currency_id_28, s1_.default_tax_zone_id AS default_tax_zone_id_29, s1_.menu_taxon_id AS menu_taxon_id_30 FROM setono_sylius_redirect__redirect s0_ LEFT JOIN setono_sylius_redirect__redirect_channels s2_ ON s0_.id = s2_.redirect_id LEFT JOIN sylius_channel s1_ ON s1_.id = s2_.channel_id WHERE s0_.source = '/nos-produits/univers-bebe' AND s0_.enabled = 1 AND s0_.only_404 = 0;

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.shop_billing_data_id AS shop_billing_data_id_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
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