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

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

SELECT
  s0_.number AS number_0,
  s0_.notes AS notes_1,
  s0_.state AS state_2,
  s0_.checkout_completed_at AS checkout_completed_at_3,
  s0_.items_total AS items_total_4,
  s0_.adjustments_total AS adjustments_total_5,
  s0_.total AS total_6,
  s0_.created_at AS created_at_7,
  s0_.updated_at AS updated_at_8,
  s0_.id AS id_9,
  s0_.currency_code AS currency_code_10,
  s0_.locale_code AS locale_code_11,
  s0_.checkout_state AS checkout_state_12,
  s0_.payment_state AS payment_state_13,
  s0_.shipping_state AS shipping_state_14,
  s0_.created_by_guest AS created_by_guest_15,
  s0_.token_value AS token_value_16,
  s0_.customer_ip AS customer_ip_17,
  s0_.old_site_id_order AS old_site_id_order_18,
  s0_.order_divalto_invoice_number AS order_divalto_invoice_number_19,
  s0_.order_pickup_so_colissimo AS order_pickup_so_colissimo_20,
  s0_.order_pickup_shop AS order_pickup_shop_21,
  s0_.order_pickup_name AS order_pickup_name_22,
  s0_.order_generix_receipt_number AS order_generix_receipt_number_23,
  s0_.order_generix_marketing_context_id AS order_generix_marketing_context_id_24,
  s0_.order_panda_panier_id AS order_panda_panier_id_25,
  s0_.gift_message AS gift_message_26,
  s0_.gift_wrap_mode AS gift_wrap_mode_27,
  s0_.origin AS origin_28,
  s0_.can_loyalty AS can_loyalty_29,
  s0_.has_loyalty AS has_loyalty_30,
  s0_.total_loyalty AS total_loyalty_31,
  s0_.libelle_loyalty AS libelle_loyalty_32,
  s0_.code_promo AS code_promo_33,
  s0_.code_promo_valid AS code_promo_valid_34,
  s0_.apel AS apel_35,
  s0_.selected_shipping_address_id AS selected_shipping_address_id_36,
  s0_.selected_billing_address_id AS selected_billing_address_id_37,
  s0_.channel_id AS channel_id_38,
  s0_.promotion_coupon_id AS promotion_coupon_id_39,
  s0_.customer_id AS customer_id_40,
  s0_.shipping_address_id AS shipping_address_id_41,
  s0_.billing_address_id AS billing_address_id_42
FROM
  sylius_order s0_
WHERE
  s0_.id = ?
  AND s0_.state = ?
  AND s0_.channel_id = ?

SELECT s0_.number AS number_0, s0_.notes AS notes_1, s0_.state AS state_2, s0_.checkout_completed_at AS checkout_completed_at_3, s0_.items_total AS items_total_4, s0_.adjustments_total AS adjustments_total_5, s0_.total AS total_6, s0_.created_at AS created_at_7, s0_.updated_at AS updated_at_8, s0_.id AS id_9, s0_.currency_code AS currency_code_10, s0_.locale_code AS locale_code_11, s0_.checkout_state AS checkout_state_12, s0_.payment_state AS payment_state_13, s0_.shipping_state AS shipping_state_14, s0_.created_by_guest AS created_by_guest_15, s0_.token_value AS token_value_16, s0_.customer_ip AS customer_ip_17, s0_.old_site_id_order AS old_site_id_order_18, s0_.order_divalto_invoice_number AS order_divalto_invoice_number_19, s0_.order_pickup_so_colissimo AS order_pickup_so_colissimo_20, s0_.order_pickup_shop AS order_pickup_shop_21, s0_.order_pickup_name AS order_pickup_name_22, s0_.order_generix_receipt_number AS order_generix_receipt_number_23, s0_.order_generix_marketing_context_id AS order_generix_marketing_context_id_24, s0_.order_panda_panier_id AS order_panda_panier_id_25, s0_.gift_message AS gift_message_26, s0_.gift_wrap_mode AS gift_wrap_mode_27, s0_.origin AS origin_28, s0_.can_loyalty AS can_loyalty_29, s0_.has_loyalty AS has_loyalty_30, s0_.total_loyalty AS total_loyalty_31, s0_.libelle_loyalty AS libelle_loyalty_32, s0_.code_promo AS code_promo_33, s0_.code_promo_valid AS code_promo_valid_34, s0_.apel AS apel_35, s0_.selected_shipping_address_id AS selected_shipping_address_id_36, s0_.selected_billing_address_id AS selected_billing_address_id_37, s0_.channel_id AS channel_id_38, s0_.promotion_coupon_id AS promotion_coupon_id_39, s0_.customer_id AS customer_id_40, s0_.shipping_address_id AS shipping_address_id_41, s0_.billing_address_id AS billing_address_id_42 FROM sylius_order s0_ WHERE s0_.id = 425 AND s0_.state = 'cart' AND s0_.channel_id = 1;

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/pochettes/pochettes-tissu' AND s0_.enabled = 1 AND s0_.only_404 = 0;

SELECT
  t0.name AS name_1,
  t0.type AS type_2,
  t0.value AS value_3,
  t0.createdAt AS createdAt_4,
  t0.updatedAt AS updatedAt_5,
  t0.id AS id_6
FROM
  sylius_parameters t0
WHERE
  t0.type = ?
  AND t0.name = ?
LIMIT
  1

SELECT t0.name AS name_1, t0.type AS type_2, t0.value AS value_3, t0.createdAt AS createdAt_4, t0.updatedAt AS updatedAt_5, t0.id AS id_6 FROM sylius_parameters t0 WHERE t0.type = 'sales' AND t0.name = 'panier_duree_minute' LIMIT 1;

SELECT
  t0.quantity AS quantity_1,
  t0.unit_price AS unit_price_2,
  t0.original_unit_price AS original_unit_price_3,
  t0.units_total AS units_total_4,
  t0.adjustments_total AS adjustments_total_5,
  t0.total AS total_6,
  t0.is_immutable AS is_immutable_7,
  t0.id AS id_8,
  t0.product_name AS product_name_9,
  t0.variant_name AS variant_name_10,
  t0.version AS version_11,
  t0.conditioning AS conditioning_12,
  t0.conditioning_value AS conditioning_value_13,
  t0.kdo_mail AS kdo_mail_14,
  t0.kdo_lastname AS kdo_lastname_15,
  t0.kdo_firstname AS kdo_firstname_16,
  t0.kdo_message AS kdo_message_17,
  t0.kdo_code AS kdo_code_18,
  t0.kdo_passwd AS kdo_passwd_19,
  t0.order_id AS order_id_20,
  t0.variant_id AS variant_id_21
FROM
  sylius_order_item t0
WHERE
  t0.order_id = ?

SELECT t0.quantity AS quantity_1, t0.unit_price AS unit_price_2, t0.original_unit_price AS original_unit_price_3, t0.units_total AS units_total_4, t0.adjustments_total AS adjustments_total_5, t0.total AS total_6, t0.is_immutable AS is_immutable_7, t0.id AS id_8, t0.product_name AS product_name_9, t0.variant_name AS variant_name_10, t0.version AS version_11, t0.conditioning AS conditioning_12, t0.conditioning_value AS conditioning_value_13, t0.kdo_mail AS kdo_mail_14, t0.kdo_lastname AS kdo_lastname_15, t0.kdo_firstname AS kdo_firstname_16, t0.kdo_message AS kdo_message_17, t0.kdo_code AS kdo_code_18, t0.kdo_passwd AS kdo_passwd_19, t0.order_id AS order_id_20, t0.variant_id AS variant_id_21 FROM sylius_order_item t0 WHERE t0.order_id = 432;

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.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

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;

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, 41518, 41456, 41887, 41455,
    41886, 41517, 41645, 41371, 41372,
    34638, 34639, 36348, 38458, 38457,
    39309, 38765, 39310, 38280, 38279,
    38766, 37887, 38705, 38850, 38851,
    39300, 37932, 40400, 40974, 40399,
    40973, 40451, 40345, 40450, 41301,
    39406, 38183, 40580, 41302, 37813,
    41229
  ) 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 ('41518', '41456', '41887', '41455', '41886', '41517', '41645', '41371', '41372', '34638', '34639', '36348', '38458', '38457', '39309', '38765', '39310', '38280', '38279', '38766', '37887', '38705', '38850', '38851', '39300', '37932', '40400', '40974', '40399', '40973', '40451', '40345', '40450', '41301', '39406', '38183', '40580', '41302', '37813', '41229') ORDER BY FIELD(s0_.id, 41518, 41456, 41887, 41455, 41886, 41517, 41645, 41371, 41372, 34638, 34639, 36348, 38458, 38457, 39309, 38765, 39310, 38280, 38279, 38766, 37887, 38705, 38850, 38851, 39300, 37932, 40400, 40974, 40399, 40973, 40451, 40345, 40450, 41301, 39406, 38183, 40580, 41302, 37813, 41229) 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/pochettes/pochettes-tissu' AND s1_.locale = 'fr_FR';

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 ('1721', '3596', '3672', '3694', '3696', '3830', '3835', '3845', '3882', '3970', '3976', '3998', '4040', '4056', '4058', '4059', '4088', '4089', '4129', '4132', '4133', '4140', '4141', '4191', '4192', '4193', '4203', '4211', '4212', '4213', '4220', '4224', '4245', '4248', '4250', '4252', '4253', '4258', '3844', '3905', '4042', '4043', '4079', '4087', '4116', '4125', '4126', '4190');

SELECT
  b0_.code AS code_0,
  b0_.enabled AS enabled_1,
  b0_.id AS id_2,
  b0_.typeblock AS typeblock_3
FROM
  bitbag_cms_block b0_
  LEFT JOIN bitbag_cms_block_channels b2_ ON b0_.id = b2_.block_id
  LEFT JOIN sylius_channel s1_ ON s1_.id = b2_.channel_id
WHERE
  b0_.code = ?
  AND b0_.enabled = 1
  AND s1_.code = ?

SELECT b0_.code AS code_0, b0_.enabled AS enabled_1, b0_.id AS id_2, b0_.typeblock AS typeblock_3 FROM bitbag_cms_block b0_ LEFT JOIN bitbag_cms_block_channels b2_ ON b0_.id = b2_.block_id LEFT JOIN sylius_channel s1_ ON s1_.id = b2_.channel_id WHERE b0_.code = 'preheader' AND b0_.enabled = 1 AND s1_.code = 'ppmc';

SELECT
  t0.code AS code_1,
  t0.created_at AS created_at_2,
  t0.updated_at AS updated_at_3,
  t0.enabled AS enabled_4,
  t0.id AS id_5,
  t0.variant_selection_method AS variant_selection_method_6,
  t0.average_rating AS average_rating_7,
  t0.conditioning AS conditioning_8,
  t0.strong_points AS strong_points_9,
  t0.google_product_type_id AS google_product_type_id_10,
  t0.gift_wrap_myself AS gift_wrap_myself_11,
  t0.gift_wrap_by_ppmc AS gift_wrap_by_ppmc_12,
  t0.main_taxon_id AS main_taxon_id_13,
  t0.article_id AS article_id_14
FROM
  sylius_product t0
WHERE
  t0.id IN (?)
  AND t0.enabled = ?
ORDER BY
  t0.code ASC

SELECT t0.code AS code_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.enabled AS enabled_4, t0.id AS id_5, t0.variant_selection_method AS variant_selection_method_6, t0.average_rating AS average_rating_7, t0.conditioning AS conditioning_8, t0.strong_points AS strong_points_9, t0.google_product_type_id AS google_product_type_id_10, t0.gift_wrap_myself AS gift_wrap_myself_11, t0.gift_wrap_by_ppmc AS gift_wrap_by_ppmc_12, t0.main_taxon_id AS main_taxon_id_13, t0.article_id AS article_id_14 FROM sylius_product t0 WHERE t0.id IN (2062, 2063) AND t0.enabled = 1 ORDER BY t0.code ASC;