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 = '34789-tableaux,-ardoises-effacables-couleur-cep-900160' 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 = '34789-tableaux,-ardoises-effacables-couleur-cep-900160' 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 = '34789-tableaux,-ardoises-effacables-couleur-cep-900160';

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 = 240779 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 (70, 331, 332, 333, 334, 335, 336, 334) AND p0_.is_active = 1 AND p0_.id <> 240779 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 = 240779 AND c0_.created_at >= '2025-02-12 13:37:46';

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 (6339030, 6340344, 6339214, 6336815, 6342523, 6337460, 6345069, 6345095, 6345212, 6346089, 6347345, 6347369, 6347429, 6349645, 6369950, 6370515, 6372856, 6393574, 6402683, 6403608, 6405384, 6409678, 6410965, 6411382, 6412116, 6412669, 6412744, 6413313, 6413610, 6417288, 6417316, 6418239, 6419538, 6420228, 6422309, 6422637, 6424173, 6427759, 6428429, 6428529, 6428745, 6428781, 6430965, 6431294, 6432221, 6435680, 6435929, 6436286, 6437720, 6438966, 6440370, 6444510, 6444862, 6445459, 6446146, 6446876, 6447375, 6447761, 6447774, 6449059, 6450174, 6450509, 6451335, 6451426, 6451529, 6451570, 6452022, 6452023, 6452059, 6452614, 6454532, 6455301, 6455307, 6455345, 6455787, 6456232, 6457009, 6457869, 6459122, 6460110, 6461869, 6462931, 6464355, 6466739, 6468671, 1000001011, 1000003856, 1000001012, 1000004490, 1000006118, 1000006119, 6366500, 1000008187, 1000009506, 1000008219, 1000013174, 1000014722, 1000014726, 6364874, 1000012135, 1000016374, 1000016375, 1000013065, 1000016194, 1000017451, 1000015178, 1000012146, 1000021757, 1000021806, 1000021807, 1000015943, 1000022706, 1000022709, 1000023055, 1000023455, 1000028702, 1000015077, 1000014636, 1000015416, 1000024133, 1000035152, 1000035156, 1000035977, 1000035978, 1000035986, 1000036244, 1000036249, 1000011805, 1000038399, 1000038411, 1000022807, 1000038759, 1000038797, 1000038846, 1000038847, 1000038849, 1000041043, 1000041291, 1000041292, 1000041293, 1000041301, 1000041305, 1000041317, 1000041322, 1000041323, 1000041324, 1000041337, 1000041340, 1000012483, 1000042033, 1000042044, 1000042055, 1000042056, 1000042061, 1000042062, 1000042077, 1000042080, 1000019182, 1000029877, 1000043443, 1000043444, 1000043724, 1000039610, 1000038566, 1000045198, 1000045202, 1000045209, 1000045214, 1000045224, 1000045227, 1000046532, 1000048364, 1000048393, 1000046636, 1000049023, 1000049204, 1000048911, 1000049555, 1000049980, 1000048299, 1000050218, 1000050249, 1000050540, 1000047804, 1000051043, 1000050374, 1000048886, 1000050260, 1000023934, 1000049479, 1000016634, 1000053023, 1000048794, 1000053154) AND p0_.id <> 240779 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;

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.category_parent_id = ?

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.category_parent_id = 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.category_parent_id = ?

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.category_parent_id = 16;