Symfony Profiler

SELECT
  p0_.id AS id_0,
  p0_.reference AS reference_1,
  p0_.manufacturer AS manufacturer_2,
  p0_.short_label AS short_label_3,
  p0_.long_label AS long_label_4,
  p0_.weight AS weight_5,
  p0_.sold_by AS sold_by_6,
  p0_.ppht AS ppht_7,
  p0_.ppttc AS ppttc_8,
  p0_.paht AS paht_9,
  p0_.pattc AS pattc_10,
  p0_.legal_discount_library AS legal_discount_library_11,
  p0_.fidelity_bonus AS fidelity_bonus_12,
  p0_.brand AS brand_13,
  p0_.time_limit AS time_limit_14,
  p0_.coef AS coef_15,
  p0_.is_discountable AS is_discountable_16,
  p0_.is_btob AS is_btob_17,
  p0_.is_btoc AS is_btoc_18,
  p0_.is_customizable AS is_customizable_19,
  p0_.is_library AS is_library_20,
  p0_.is_nathan AS is_nathan_21,
  p0_.is_green AS is_green_22,
  p0_.is_orapi_grand_frais AS is_orapi_grand_frais_23,
  p0_.is_active AS is_active_24,
  p0_.slug AS slug_25,
  p1_.id AS id_26,
  p1_.price_ht AS price_ht_27,
  p1_.price_ttc AS price_ttc_28,
  p2_.id AS id_29,
  c3_.id AS id_30,
  c3_.name AS name_31,
  c3_.displayed_order AS displayed_order_32,
  c3_.is_in_footer AS is_in_footer_33,
  c3_.slug AS slug_34,
  p4_.id AS id_35,
  p4_.price_ht AS price_ht_36,
  p4_.price_ttc AS price_ttc_37,
  p4_.discount AS discount_38,
  p5_.id AS id_39,
  p5_.min AS min_40,
  p5_.max AS max_41,
  p5_.codelot AS codelot_42,
  c6_.id AS id_43,
  c6_.name AS name_44,
  c6_.name_display AS name_display_45,
  c6_.is_visible_btob AS is_visible_btob_46,
  c6_.is_referencement AS is_referencement_47,
  p1_.price_id AS price_id_48,
  p1_.product_id AS product_id_49,
  c3_.category_parent_id AS category_parent_id_50,
  p4_.product_id AS product_id_51,
  p5_.customer_catalog_id AS customer_catalog_id_52,
  p5_.product_id AS product_id_53
FROM
  product p0_
  LEFT JOIN product_price p1_ ON p0_.id = p1_.product_id
  LEFT JOIN price p2_ ON p1_.price_id = p2_.id
  LEFT JOIN product_category p7_ ON p0_.id = p7_.product_id
  LEFT JOIN category c3_ ON c3_.id = p7_.category_id
  LEFT JOIN promotion p4_ ON p0_.id = p4_.product_id
  LEFT JOIN product_catalog p5_ ON p0_.id = p5_.product_id
  LEFT JOIN customer_catalog c6_ ON p5_.customer_catalog_id = c6_.id
WHERE
  p0_.slug = ?
  AND p0_.is_active = 1

SELECT p0_.id AS id_0, p0_.reference AS reference_1, p0_.manufacturer AS manufacturer_2, p0_.short_label AS short_label_3, p0_.long_label AS long_label_4, p0_.weight AS weight_5, p0_.sold_by AS sold_by_6, p0_.ppht AS ppht_7, p0_.ppttc AS ppttc_8, p0_.paht AS paht_9, p0_.pattc AS pattc_10, p0_.legal_discount_library AS legal_discount_library_11, p0_.fidelity_bonus AS fidelity_bonus_12, p0_.brand AS brand_13, p0_.time_limit AS time_limit_14, p0_.coef AS coef_15, p0_.is_discountable AS is_discountable_16, p0_.is_btob AS is_btob_17, p0_.is_btoc AS is_btoc_18, p0_.is_customizable AS is_customizable_19, p0_.is_library AS is_library_20, p0_.is_nathan AS is_nathan_21, p0_.is_green AS is_green_22, p0_.is_orapi_grand_frais AS is_orapi_grand_frais_23, p0_.is_active AS is_active_24, p0_.slug AS slug_25, p1_.id AS id_26, p1_.price_ht AS price_ht_27, p1_.price_ttc AS price_ttc_28, p2_.id AS id_29, c3_.id AS id_30, c3_.name AS name_31, c3_.displayed_order AS displayed_order_32, c3_.is_in_footer AS is_in_footer_33, c3_.slug AS slug_34, p4_.id AS id_35, p4_.price_ht AS price_ht_36, p4_.price_ttc AS price_ttc_37, p4_.discount AS discount_38, p5_.id AS id_39, p5_.min AS min_40, p5_.max AS max_41, p5_.codelot AS codelot_42, c6_.id AS id_43, c6_.name AS name_44, c6_.name_display AS name_display_45, c6_.is_visible_btob AS is_visible_btob_46, c6_.is_referencement AS is_referencement_47, p1_.price_id AS price_id_48, p1_.product_id AS product_id_49, c3_.category_parent_id AS category_parent_id_50, p4_.product_id AS product_id_51, p5_.customer_catalog_id AS customer_catalog_id_52, p5_.product_id AS product_id_53 FROM product p0_ LEFT JOIN product_price p1_ ON p0_.id = p1_.product_id LEFT JOIN price p2_ ON p1_.price_id = p2_.id LEFT JOIN product_category p7_ ON p0_.id = p7_.product_id LEFT JOIN category c3_ ON c3_.id = p7_.category_id LEFT JOIN promotion p4_ ON p0_.id = p4_.product_id LEFT JOIN product_catalog p5_ ON p0_.id = p5_.product_id LEFT JOIN customer_catalog c6_ ON p5_.customer_catalog_id = c6_.id WHERE p0_.slug = '51947-attaches-et-piques-notes-couleur-n-c-ftb300073' AND p0_.is_active = 1;

SELECT
  t0.id AS id_1,
  t0.reference AS reference_2,
  t0.manufacturer AS manufacturer_3,
  t0.short_label AS short_label_4,
  t0.long_label AS long_label_5,
  t0.weight AS weight_6,
  t0.sold_by AS sold_by_7,
  t0.ppht AS ppht_8,
  t0.ppttc AS ppttc_9,
  t0.paht AS paht_10,
  t0.pattc AS pattc_11,
  t0.legal_discount_library AS legal_discount_library_12,
  t0.fidelity_bonus AS fidelity_bonus_13,
  t0.brand AS brand_14,
  t0.time_limit AS time_limit_15,
  t0.coef AS coef_16,
  t0.is_discountable AS is_discountable_17,
  t0.is_btob AS is_btob_18,
  t0.is_btoc AS is_btoc_19,
  t0.is_customizable AS is_customizable_20,
  t0.is_library AS is_library_21,
  t0.is_nathan AS is_nathan_22,
  t0.is_green AS is_green_23,
  t0.is_orapi_grand_frais AS is_orapi_grand_frais_24,
  t0.is_active AS is_active_25,
  t0.slug AS slug_26
FROM
  product t0
WHERE
  t0.id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.reference AS reference_2, t0.manufacturer AS manufacturer_3, t0.short_label AS short_label_4, t0.long_label AS long_label_5, t0.weight AS weight_6, t0.sold_by AS sold_by_7, t0.ppht AS ppht_8, t0.ppttc AS ppttc_9, t0.paht AS paht_10, t0.pattc AS pattc_11, t0.legal_discount_library AS legal_discount_library_12, t0.fidelity_bonus AS fidelity_bonus_13, t0.brand AS brand_14, t0.time_limit AS time_limit_15, t0.coef AS coef_16, t0.is_discountable AS is_discountable_17, t0.is_btob AS is_btob_18, t0.is_btoc AS is_btoc_19, t0.is_customizable AS is_customizable_20, t0.is_library AS is_library_21, t0.is_nathan AS is_nathan_22, t0.is_green AS is_green_23, t0.is_orapi_grand_frais AS is_orapi_grand_frais_24, t0.is_active AS is_active_25, t0.slug AS slug_26 FROM product t0 WHERE t0.id = '51947-attaches-et-piques-notes-couleur-n-c-ftb300073' LIMIT 1;

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.displayed_order AS displayed_order_2,
  c0_.is_in_footer AS is_in_footer_3,
  c0_.slug AS slug_4,
  c1_.id AS id_5,
  c1_.name AS name_6,
  c1_.displayed_order AS displayed_order_7,
  c1_.is_in_footer AS is_in_footer_8,
  c1_.slug AS slug_9,
  c2_.id AS id_10,
  c2_.name AS name_11,
  c2_.displayed_order AS displayed_order_12,
  c2_.is_in_footer AS is_in_footer_13,
  c2_.slug AS slug_14,
  c0_.category_parent_id AS category_parent_id_15,
  c1_.category_parent_id AS category_parent_id_16,
  c2_.category_parent_id AS category_parent_id_17
FROM
  category c0_
  LEFT JOIN category c1_ ON c0_.id = c1_.category_parent_id
  LEFT JOIN category c2_ ON c1_.id = c2_.category_parent_id
WHERE
  c0_.slug = ?

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.displayed_order AS displayed_order_2, c0_.is_in_footer AS is_in_footer_3, c0_.slug AS slug_4, c1_.id AS id_5, c1_.name AS name_6, c1_.displayed_order AS displayed_order_7, c1_.is_in_footer AS is_in_footer_8, c1_.slug AS slug_9, c2_.id AS id_10, c2_.name AS name_11, c2_.displayed_order AS displayed_order_12, c2_.is_in_footer AS is_in_footer_13, c2_.slug AS slug_14, c0_.category_parent_id AS category_parent_id_15, c1_.category_parent_id AS category_parent_id_16, c2_.category_parent_id AS category_parent_id_17 FROM category c0_ LEFT JOIN category c1_ ON c0_.id = c1_.category_parent_id LEFT JOIN category c2_ ON c1_.id = c2_.category_parent_id WHERE c0_.slug = '51947-attaches-et-piques-notes-couleur-n-c-ftb300073';

SELECT
  c0_.id AS id_0,
  c0_.value AS value_1,
  c1_.id AS id_2,
  c1_.list_order AS list_order_3,
  c1_.is_display_site AS is_display_site_4,
  c1_.is_search_site AS is_search_site_5,
  c1_.label AS label_6,
  c0_.product_id AS product_id_7,
  c0_.characteristic_label_id AS characteristic_label_id_8
FROM
  characteristic c0_
  INNER JOIN characteristic_label c1_ ON c0_.characteristic_label_id = c1_.id
WHERE
  c0_.product_id = ?
  AND c1_.is_display_site = ?

SELECT c0_.id AS id_0, c0_.value AS value_1, c1_.id AS id_2, c1_.list_order AS list_order_3, c1_.is_display_site AS is_display_site_4, c1_.is_search_site AS is_search_site_5, c1_.label AS label_6, c0_.product_id AS product_id_7, c0_.characteristic_label_id AS characteristic_label_id_8 FROM characteristic c0_ INNER JOIN characteristic_label c1_ ON c0_.characteristic_label_id = c1_.id WHERE c0_.product_id = 33088 AND c1_.is_display_site = 1;

SELECT
  p0_.id AS id_0,
  p0_.reference AS reference_1,
  p0_.manufacturer AS manufacturer_2,
  p0_.short_label AS short_label_3,
  p0_.long_label AS long_label_4,
  p0_.weight AS weight_5,
  p0_.sold_by AS sold_by_6,
  p0_.ppht AS ppht_7,
  p0_.ppttc AS ppttc_8,
  p0_.paht AS paht_9,
  p0_.pattc AS pattc_10,
  p0_.legal_discount_library AS legal_discount_library_11,
  p0_.fidelity_bonus AS fidelity_bonus_12,
  p0_.brand AS brand_13,
  p0_.time_limit AS time_limit_14,
  p0_.coef AS coef_15,
  p0_.is_discountable AS is_discountable_16,
  p0_.is_btob AS is_btob_17,
  p0_.is_btoc AS is_btoc_18,
  p0_.is_customizable AS is_customizable_19,
  p0_.is_library AS is_library_20,
  p0_.is_nathan AS is_nathan_21,
  p0_.is_green AS is_green_22,
  p0_.is_orapi_grand_frais AS is_orapi_grand_frais_23,
  p0_.is_active AS is_active_24,
  p0_.slug AS slug_25
FROM
  product p0_
  LEFT JOIN product_category p2_ ON p0_.id = p2_.product_id
  LEFT JOIN category c1_ ON c1_.id = p2_.category_id
WHERE
  c1_.id IN (?, ?, ?, ?, ?, ?, ?, ?)
  AND p0_.is_active = 1
  AND p0_.id <> ?
  AND p0_.is_btoc = 1
  AND p0_.is_orapi_grand_frais <> 1
LIMIT
  10

SELECT p0_.id AS id_0, p0_.reference AS reference_1, p0_.manufacturer AS manufacturer_2, p0_.short_label AS short_label_3, p0_.long_label AS long_label_4, p0_.weight AS weight_5, p0_.sold_by AS sold_by_6, p0_.ppht AS ppht_7, p0_.ppttc AS ppttc_8, p0_.paht AS paht_9, p0_.pattc AS pattc_10, p0_.legal_discount_library AS legal_discount_library_11, p0_.fidelity_bonus AS fidelity_bonus_12, p0_.brand AS brand_13, p0_.time_limit AS time_limit_14, p0_.coef AS coef_15, p0_.is_discountable AS is_discountable_16, p0_.is_btob AS is_btob_17, p0_.is_btoc AS is_btoc_18, p0_.is_customizable AS is_customizable_19, p0_.is_library AS is_library_20, p0_.is_nathan AS is_nathan_21, p0_.is_green AS is_green_22, p0_.is_orapi_grand_frais AS is_orapi_grand_frais_23, p0_.is_active AS is_active_24, p0_.slug AS slug_25 FROM product p0_ LEFT JOIN product_category p2_ ON p0_.id = p2_.product_id LEFT JOIN category c1_ ON c1_.id = p2_.category_id WHERE c1_.id IN (54, 253, 254, 255, 256, 257, 258, 255) AND p0_.is_active = 1 AND p0_.id <> 33088 AND p0_.is_btoc = 1 AND p0_.is_orapi_grand_frais <> 1 LIMIT 10;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.value1 AS value1_3,
  t0.value2 AS value2_4,
  t0.value3 AS value3_5
FROM
  parameter t0
WHERE
  t0.name = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.value1 AS value1_3, t0.value2 AS value2_4, t0.value3 AS value3_5 FROM parameter t0 WHERE t0.name = 'ourClientsAlsoBoughtMonths' LIMIT 1;

SELECT
  c0_.id AS id_0,
  c0_.temporary_cart_number AS temporary_cart_number_1,
  c0_.type AS type_2,
  c0_.number AS number_3,
  c0_.slip AS slip_4,
  c0_.status AS status_5,
  c0_.order_picker AS order_picker_6,
  c0_.created_at AS created_at_7,
  c0_.delivery_date AS delivery_date_8,
  c0_.login AS login_9,
  c0_.user_reference AS user_reference_10,
  c0_.tracking_number AS tracking_number_11,
  c0_.deposit AS deposit_12,
  c0_.sector AS sector_13,
  c0_.sub_sector AS sub_sector_14,
  c0_.customer_name AS customer_name_15,
  c0_.address1 AS address1_16,
  c0_.address2 AS address2_17,
  c0_.address3 AS address3_18,
  c0_.zip_code AS zip_code_19,
  c0_.city AS city_20,
  c0_.country AS country_21,
  c0_.phone AS phone_22,
  c0_.fax AS fax_23,
  c0_.email AS email_24,
  c0_.customer_name_delivery AS customer_name_delivery_25,
  c0_.address1_delivery AS address1_delivery_26,
  c0_.address2_delivery AS address2_delivery_27,
  c0_.address3_delivery AS address3_delivery_28,
  c0_.zip_code_delivery AS zip_code_delivery_29,
  c0_.delivery_city AS delivery_city_30,
  c0_.country_delivery AS country_delivery_31,
  c0_.delivery_phone AS delivery_phone_32,
  c0_.fax_delivery AS fax_delivery_33,
  c0_.email_delivery AS email_delivery_34,
  c0_.reglement AS reglement_35,
  c0_.updated_at AS updated_at_36,
  c0_.price_ht AS price_ht_37,
  c0_.price_tva AS price_tva_38,
  c0_.price_ttc AS price_ttc_39,
  c0_.price_cost_ht AS price_cost_ht_40,
  c0_.display_ttc AS display_ttc_41,
  c0_.package_number AS package_number_42,
  c0_.weight AS weight_43,
  c0_.volume AS volume_44,
  c0_.discount AS discount_45,
  c0_.feedback AS feedback_46,
  c0_.global_discount AS global_discount_47,
  c0_.commitment_number AS commitment_number_48,
  c0_.promotional_code AS promotional_code_49,
  c0_.multiplier_coefficient AS multiplier_coefficient_50,
  c0_.is_out_of_budget AS is_out_of_budget_51,
  c0_.lead_word AS lead_word_52,
  c0_.facturation AS facturation_53,
  c0_.complete_delivery AS complete_delivery_54,
  c0_.urgent_delivery AS urgent_delivery_55,
  c0_.complete_facturation AS complete_facturation_56,
  c0_.paypal AS paypal_57,
  c0_.regroupement AS regroupement_58,
  c0_.transaction AS transaction_59,
  c0_.plate_number AS plate_number_60,
  c0_.is_hidden AS is_hidden_61,
  c0_.budget_id AS budget_id_62,
  c0_.customer_id AS customer_id_63,
  c0_.billing_customer_id AS billing_customer_id_64,
  c0_.user_id AS user_id_65,
  c0_.delivery_id AS delivery_id_66,
  c0_.market_id AS market_id_67,
  c0_.price_id AS price_id_68,
  c0_.society_id AS society_id_69,
  c0_.commercial_id AS commercial_id_70,
  c0_.delivery_cost_id AS delivery_cost_id_71
FROM
  customer_order c0_
  INNER JOIN customer_order_lines c1_ ON c0_.id = c1_.customer_order_id
  INNER JOIN product p2_ ON c1_.product_id = p2_.id
WHERE
  p2_.id = ?
  AND c0_.created_at >= ?

SELECT c0_.id AS id_0, c0_.temporary_cart_number AS temporary_cart_number_1, c0_.type AS type_2, c0_.number AS number_3, c0_.slip AS slip_4, c0_.status AS status_5, c0_.order_picker AS order_picker_6, c0_.created_at AS created_at_7, c0_.delivery_date AS delivery_date_8, c0_.login AS login_9, c0_.user_reference AS user_reference_10, c0_.tracking_number AS tracking_number_11, c0_.deposit AS deposit_12, c0_.sector AS sector_13, c0_.sub_sector AS sub_sector_14, c0_.customer_name AS customer_name_15, c0_.address1 AS address1_16, c0_.address2 AS address2_17, c0_.address3 AS address3_18, c0_.zip_code AS zip_code_19, c0_.city AS city_20, c0_.country AS country_21, c0_.phone AS phone_22, c0_.fax AS fax_23, c0_.email AS email_24, c0_.customer_name_delivery AS customer_name_delivery_25, c0_.address1_delivery AS address1_delivery_26, c0_.address2_delivery AS address2_delivery_27, c0_.address3_delivery AS address3_delivery_28, c0_.zip_code_delivery AS zip_code_delivery_29, c0_.delivery_city AS delivery_city_30, c0_.country_delivery AS country_delivery_31, c0_.delivery_phone AS delivery_phone_32, c0_.fax_delivery AS fax_delivery_33, c0_.email_delivery AS email_delivery_34, c0_.reglement AS reglement_35, c0_.updated_at AS updated_at_36, c0_.price_ht AS price_ht_37, c0_.price_tva AS price_tva_38, c0_.price_ttc AS price_ttc_39, c0_.price_cost_ht AS price_cost_ht_40, c0_.display_ttc AS display_ttc_41, c0_.package_number AS package_number_42, c0_.weight AS weight_43, c0_.volume AS volume_44, c0_.discount AS discount_45, c0_.feedback AS feedback_46, c0_.global_discount AS global_discount_47, c0_.commitment_number AS commitment_number_48, c0_.promotional_code AS promotional_code_49, c0_.multiplier_coefficient AS multiplier_coefficient_50, c0_.is_out_of_budget AS is_out_of_budget_51, c0_.lead_word AS lead_word_52, c0_.facturation AS facturation_53, c0_.complete_delivery AS complete_delivery_54, c0_.urgent_delivery AS urgent_delivery_55, c0_.complete_facturation AS complete_facturation_56, c0_.paypal AS paypal_57, c0_.regroupement AS regroupement_58, c0_.transaction AS transaction_59, c0_.plate_number AS plate_number_60, c0_.is_hidden AS is_hidden_61, c0_.budget_id AS budget_id_62, c0_.customer_id AS customer_id_63, c0_.billing_customer_id AS billing_customer_id_64, c0_.user_id AS user_id_65, c0_.delivery_id AS delivery_id_66, c0_.market_id AS market_id_67, c0_.price_id AS price_id_68, c0_.society_id AS society_id_69, c0_.commercial_id AS commercial_id_70, c0_.delivery_cost_id AS delivery_cost_id_71 FROM customer_order c0_ INNER JOIN customer_order_lines c1_ ON c0_.id = c1_.customer_order_id INNER JOIN product p2_ ON c1_.product_id = p2_.id WHERE p2_.id = 33088 AND c0_.created_at >= '2025-02-12 09:20:02';

SELECT
  p0_.id AS id_0,
  p0_.reference AS reference_1,
  p0_.manufacturer AS manufacturer_2,
  p0_.short_label AS short_label_3,
  p0_.long_label AS long_label_4,
  p0_.weight AS weight_5,
  p0_.sold_by AS sold_by_6,
  p0_.ppht AS ppht_7,
  p0_.ppttc AS ppttc_8,
  p0_.paht AS paht_9,
  p0_.pattc AS pattc_10,
  p0_.legal_discount_library AS legal_discount_library_11,
  p0_.fidelity_bonus AS fidelity_bonus_12,
  p0_.brand AS brand_13,
  p0_.time_limit AS time_limit_14,
  p0_.coef AS coef_15,
  p0_.is_discountable AS is_discountable_16,
  p0_.is_btob AS is_btob_17,
  p0_.is_btoc AS is_btoc_18,
  p0_.is_customizable AS is_customizable_19,
  p0_.is_library AS is_library_20,
  p0_.is_nathan AS is_nathan_21,
  p0_.is_green AS is_green_22,
  p0_.is_orapi_grand_frais AS is_orapi_grand_frais_23,
  p0_.is_active AS is_active_24,
  p0_.slug AS slug_25
FROM
  product p0_
  INNER JOIN customer_order_lines c1_ ON (c1_.product_id = p0_.id)
  INNER JOIN customer_order c2_ ON c1_.customer_order_id = c2_.id
WHERE
  c2_.id IN (
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?
  )
  AND p0_.id <> ?
  AND p0_.is_btoc = 1
  AND p0_.is_orapi_grand_frais <> 1
GROUP BY
  p0_.id,
  p0_.reference,
  p0_.manufacturer,
  p0_.short_label,
  p0_.long_label,
  p0_.weight,
  p0_.sold_by,
  p0_.ppht,
  p0_.ppttc,
  p0_.paht,
  p0_.pattc,
  p0_.legal_discount_library,
  p0_.fidelity_bonus,
  p0_.brand,
  p0_.time_limit,
  p0_.coef,
  p0_.is_discountable,
  p0_.is_btob,
  p0_.is_btoc,
  p0_.is_customizable,
  p0_.is_library,
  p0_.is_nathan,
  p0_.is_green,
  p0_.is_orapi_grand_frais,
  p0_.is_active,
  p0_.slug
ORDER BY
  COUNT(p0_.id) DESC
LIMIT
  10

SELECT p0_.id AS id_0, p0_.reference AS reference_1, p0_.manufacturer AS manufacturer_2, p0_.short_label AS short_label_3, p0_.long_label AS long_label_4, p0_.weight AS weight_5, p0_.sold_by AS sold_by_6, p0_.ppht AS ppht_7, p0_.ppttc AS ppttc_8, p0_.paht AS paht_9, p0_.pattc AS pattc_10, p0_.legal_discount_library AS legal_discount_library_11, p0_.fidelity_bonus AS fidelity_bonus_12, p0_.brand AS brand_13, p0_.time_limit AS time_limit_14, p0_.coef AS coef_15, p0_.is_discountable AS is_discountable_16, p0_.is_btob AS is_btob_17, p0_.is_btoc AS is_btoc_18, p0_.is_customizable AS is_customizable_19, p0_.is_library AS is_library_20, p0_.is_nathan AS is_nathan_21, p0_.is_green AS is_green_22, p0_.is_orapi_grand_frais AS is_orapi_grand_frais_23, p0_.is_active AS is_active_24, p0_.slug AS slug_25 FROM product p0_ INNER JOIN customer_order_lines c1_ ON (c1_.product_id = p0_.id) INNER JOIN customer_order c2_ ON c1_.customer_order_id = c2_.id WHERE c2_.id IN (6336142, 6337953, 6339563, 6339141, 6341377, 6340841, 6343806, 6344925, 6340028, 6345231, 6345822, 6346066, 6347081, 6347127, 6347386, 6347631, 6348697, 6348864, 6348970, 6349006, 6349425, 6350000, 6350181, 6345839, 6353906, 6345785, 6351690, 6240511, 6342239, 6354290, 6354307, 6354312, 6354333, 6355148, 6354807, 6355306, 6355623, 6355860, 6355039, 6358154, 6358295, 6357656, 6358569, 6360009, 6361195, 6360907, 6360930, 6362377, 6362844, 6363595, 6363773, 6363859, 6364369, 6368218, 6369145, 6369148, 6369158, 6369869, 6370066, 6370197, 6371038, 6371058, 6371059, 6371198, 6371611, 6371617, 6372249, 6372969, 6373033, 6374017, 6368196, 6377625, 6376960, 6378075, 6378400, 6364799, 6381320, 6364660, 6382695, 6382710, 6383023, 6383028, 6383809, 6382777, 6385042, 6380378, 6359197, 6386592, 6388678, 6390381, 6390692, 6395473, 6395855, 6396651, 6397005, 6397430, 6397667, 6397992, 6398620, 6399278, 6399283, 6399415, 6399475, 6400594, 6401697, 6402634, 6407657, 6408497, 6408826, 6409106, 6409123, 6409995, 6410039, 6410659, 6411721, 6414564, 6415629, 6416046, 6417172, 6417391, 6418045, 6418447, 6419870, 6420371, 6420397, 6422548, 6423940, 6425943, 6427007, 6429299, 6431506, 6432195, 6433738, 6433845, 6433851, 6434421, 6435860, 6437971, 6438596, 6438688, 6440839, 6441132, 6442457, 6443680, 6443724, 6444772, 6445373, 6445593, 6446758, 6447042, 6448228, 6449401, 6449546, 6450460, 6451673, 6452117, 6452122, 6453199, 6453201, 6453681, 6453852, 6453890, 6453983, 6454127, 6454863, 6454929, 6455884, 6456135, 6456513, 6456516, 6456521, 6456591, 6459500, 6463866, 6466615, 6466761, 6467230, 6365099, 1000005715, 1000006503, 1000005767, 1000004270, 1000011920, 1000012144, 1000004488, 1000014379, 1000015549, 1000009475, 1000016448, 1000018039, 1000018803, 1000020472, 1000020852, 1000020861, 1000021295, 1000023322, 1000023859, 1000021979, 1000026687, 1000026697, 1000012145, 1000027360, 1000029353, 1000029502, 1000029543, 1000029544, 1000030863, 1000030905, 1000030914, 1000030921, 1000030928, 1000031332, 1000031361, 1000031365, 1000031366, 1000031377, 1000031378, 1000031379, 1000031381, 1000031382, 1000031383, 1000031385, 1000031392, 1000031428, 1000031467, 1000031468, 1000031472, 1000031475, 1000031476, 1000031477, 1000031478, 1000031480, 1000031502, 1000031504, 1000031506, 1000031509, 1000031526, 1000031531, 1000031532, 1000031533, 1000031546, 1000031553, 1000031558, 1000031566, 1000031567, 1000031583, 1000031585, 1000031591, 1000036422, 1000036464, 1000037494, 1000040301, 1000040302, 1000040303, 1000040305, 1000027770, 1000036471, 1000034487, 1000042024, 1000042266, 1000042382, 1000037837, 1000034763, 1000046112, 1000046741, 1000046795, 1000046914, 1000046935, 1000047618, 1000047619, 1000047621, 1000047622, 1000048425, 1000048426, 1000048744, 1000048953, 1000048955, 1000048993, 1000049830, 1000050285, 1000050286, 1000050977, 1000042987, 1000048153, 1000051941, 1000023934, 1000050197, 1000052413, 1000052539, 1000049690, 1000052724, 1000052726, 1000052813, 1000046797, 1000052580, 1000053218, 1000052414, 1000053231, 1000052007) AND p0_.id <> 33088 AND p0_.is_btoc = 1 AND p0_.is_orapi_grand_frais <> 1 GROUP BY p0_.id, p0_.reference, p0_.manufacturer, p0_.short_label, p0_.long_label, p0_.weight, p0_.sold_by, p0_.ppht, p0_.ppttc, p0_.paht, p0_.pattc, p0_.legal_discount_library, p0_.fidelity_bonus, p0_.brand, p0_.time_limit, p0_.coef, p0_.is_discountable, p0_.is_btob, p0_.is_btoc, p0_.is_customizable, p0_.is_library, p0_.is_nathan, p0_.is_green, p0_.is_orapi_grand_frais, p0_.is_active, p0_.slug ORDER BY COUNT(p0_.id) DESC LIMIT 10;