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 = '33752-papier-de-couleur-orange-clairefontaine-1878pc' 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 = '33752-papier-de-couleur-orange-clairefontaine-1878pc' 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 = '33752-papier-de-couleur-orange-clairefontaine-1878pc';

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 = 5073 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 (44, 210, 211, 212, 213, 214, 215, 213) AND p0_.is_active = 1 AND p0_.id <> 5073 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 = 5073 AND c0_.created_at >= '2025-02-12 10:26:57';

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, 6338772, 6338934, 6339522, 6339563, 6341341, 6343232, 6343763, 6344255, 6344347, 6344475, 6344605, 6345096, 6345315, 6345919, 6347081, 6347320, 6347412, 6347995, 6348020, 6348609, 6349457, 6349608, 6349880, 6353942, 6354586, 6355706, 6356174, 6356818, 6335774, 6334389, 6362392, 6362415, 6365698, 6366129, 6367792, 6368959, 6369603, 6369929, 6370824, 6371166, 6372542, 6372788, 6374325, 6374761, 6376855, 6378447, 6378114, 6384000, 6384387, 6383449, 6385417, 6385683, 6387182, 6387498, 6389005, 6391039, 6391066, 6391981, 6393337, 6395041, 6395423, 6395877, 6395948, 6397189, 6398691, 6399500, 6400142, 6400297, 6401413, 6402094, 6402247, 6402322, 6404672, 6404684, 6404998, 6405563, 6405606, 6405674, 6405743, 6408926, 6409340, 6411703, 6412830, 6412845, 6413550, 6413559, 6413745, 6414360, 6414761, 6415078, 6415669, 6416415, 6416970, 6417426, 6417502, 6418018, 6418406, 6418489, 6418697, 6419545, 6419551, 6419581, 6419583, 6420331, 6420672, 6421085, 6422774, 6423805, 6423832, 6426812, 6427235, 6427408, 6427430, 6428699, 6431228, 6432074, 6432261, 6435935, 6439203, 6439225, 6439667, 6441430, 6441817, 6442226, 6443123, 6443565, 6443567, 6443905, 6444306, 6444312, 6447388, 6447718, 6448223, 6448585, 6449426, 6449505, 6449564, 6449691, 6450180, 6450791, 6452407, 6453140, 6453141, 6453468, 6453481, 6453844, 6454777, 6454841, 6454917, 6455165, 6455427, 6455436, 6456094, 6456467, 6456499, 6456626, 6457040, 6460268, 6460329, 6460399, 6460439, 6461863, 6465606, 6465652, 1000001162, 1000002430, 6314803, 6390301, 1000004496, 6394772, 1000005848, 1000005966, 1000005213, 1000008558, 1000010031, 1000009436, 1000001726, 1000010517, 6394610, 1000010568, 1000011029, 1000011814, 1000012537, 1000013746, 1000014494, 1000015507, 1000015509, 1000015859, 1000016366, 1000016452, 1000015121, 1000019815, 1000019817, 1000019818, 1000019819, 1000019820, 1000018336, 1000020875, 6382671, 1000022070, 1000022073, 1000022074, 1000022075, 1000022076, 1000022077, 1000023234, 1000023775, 1000023776, 1000023777, 1000023778, 1000023779, 1000023780, 1000023781, 1000023782, 1000023783, 1000023784, 1000023860, 1000024818, 1000024819, 1000024820, 1000024821, 1000024822, 1000024823, 1000024824, 1000024825, 1000024826, 1000024827, 1000024828, 1000024829, 1000024830, 1000024831, 1000024832, 1000024833, 1000024834, 1000024835, 1000024836, 1000024838, 1000024839, 1000024840, 1000028959, 1000029367, 1000029366, 1000029869, 1000031762, 1000031763, 1000031764, 1000031771, 1000022069, 1000023235, 1000016487, 1000034491, 1000034609, 1000034610, 1000034611, 1000034612, 1000034613, 1000034614, 1000034615, 1000034617, 1000034619, 1000034627, 1000034628, 1000034630, 1000034632, 1000034993, 1000035001, 1000035004, 1000035728, 1000035973, 1000021115, 1000036450, 1000036472, 1000036475, 1000013063, 1000037433, 1000015922, 1000040246, 1000041443, 1000019265, 1000044465, 1000044479, 1000044560, 1000044563, 1000044566, 1000044570, 1000045951, 1000047507, 1000047812, 1000045693, 1000048672, 1000048770, 1000049242, 1000050002, 1000050814, 1000047971, 1000050883, 1000044834, 1000051491, 1000051494, 1000050470, 1000051576, 1000045884, 1000051979, 1000052088, 1000050290, 1000052583, 1000051677, 1000052703, 1000052291, 1000053375, 1000053376, 1000053377, 1000053383, 1000053412) AND p0_.id <> 5073 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;