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 = '81483-piles-et-chargeurs-couleur-energizer-248357' 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 = '81483-piles-et-chargeurs-couleur-energizer-248357' 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 = '81483-piles-et-chargeurs-couleur-energizer-248357';

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 = 127304 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 (33, 143, 144, 145, 146, 147, 148, 149, 148) AND p0_.is_active = 1 AND p0_.id <> 127304 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 = 127304 AND c0_.created_at >= '2025-02-12 10:26:11';

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 (6337725, 6337920, 6315843, 6322943, 6339093, 6339688, 6339739, 6340294, 6340303, 6340629, 6342272, 6343374, 6337251, 6345060, 6344952, 6345561, 6345660, 6345735, 6345903, 6346090, 6346092, 6347152, 6347181, 6347431, 6347486, 6348180, 6348375, 6348386, 6348470, 6349175, 6349228, 6349421, 6349606, 6350104, 6350290, 6350504, 6352830, 6352631, 6353437, 6354269, 6354284, 6354357, 6354633, 6355506, 6355025, 6356543, 6356677, 6357302, 6357360, 6358377, 6358928, 6359309, 6359641, 6356197, 6360462, 6361572, 6362038, 6362437, 6362847, 6362934, 6363153, 6363814, 6364073, 6364398, 6365156, 6365474, 6360005, 6363588, 6366384, 6366556, 6366745, 6367127, 6367403, 6363936, 6368841, 6369032, 6369253, 6369285, 6370021, 6370079, 6370280, 6370284, 6370412, 6370435, 6370782, 6370822, 6371127, 6371285, 6371314, 6371874, 6372871, 6372872, 6372873, 6373129, 6373468, 6373663, 6373696, 6374040, 6374647, 6377380, 6378225, 6378687, 6378784, 6378828, 6379477, 6379569, 6380447, 6376808, 6381731, 6382279, 6382714, 6383035, 6383291, 6383411, 6385570, 6385696, 6385877, 6386127, 6386368, 6386484, 6386635, 6387721, 6388644, 6389846, 6390653, 6391659, 6391905, 6392068, 6392072, 6393457, 6394359, 6395910, 6395996, 6396082, 6396164, 6396649, 6396691, 6396808, 6397113, 6397577, 6397814, 6398037, 6398221, 6398269, 6398868, 6399502, 6399505, 6399805, 6401186, 6403453, 6403812, 6406830, 6407042, 6408599, 6408774, 6409548, 6410743, 6411452, 6411501, 6416734, 6416763, 6416764, 6417421, 6417975, 6418036, 6419804, 6419954, 6420291, 6420375, 6420479, 6422957, 6425904, 6429280, 6430002, 6431320, 6431833, 6438442, 6435360, 6442842, 6444415, 6446531, 6446649, 6448751, 6448862, 6449390, 6451309, 6451745, 6453198, 6453490, 6453655, 6453664, 6453733, 6457217, 6459209, 6464347, 6466542, 6466926, 6469074, 1000001085, 1000001784, 1000001872, 1000001955, 1000001989, 1000008151, 1000001573, 1000009031, 1000010594, 1000014096, 1000018801, 1000018842, 1000019554, 1000027252, 1000027287, 1000027288, 1000027292, 1000027426, 1000032487, 1000032494, 1000032496, 1000032498, 1000032499, 1000032502, 1000032503, 1000032504, 1000032528, 1000041058, 1000041029, 1000044210, 1000046104, 1000046108, 1000047636, 1000048532, 1000048870, 1000051395, 1000051397, 1000051465) AND p0_.id <> 127304 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
  t0.id AS id_1,
  t0.name AS name_2,
  t0.displayed_order AS displayed_order_3,
  t0.is_in_footer AS is_in_footer_4,
  t0.slug AS slug_5,
  t0.category_parent_id AS category_parent_id_6
FROM
  category t0
WHERE
  t0.id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.displayed_order AS displayed_order_3, t0.is_in_footer AS is_in_footer_4, t0.slug AS slug_5, t0.category_parent_id AS category_parent_id_6 FROM category t0 WHERE t0.id = 1 LIMIT 1;