Symfony Profiler

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 = 5714 AND c0_.created_at >= '2025-02-12 07:32:40';

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 = '36128-reliure-noir-n-c-dia-6mm-noir' 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
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 (6340295, 6340773, 6341215, 6341658, 6346132, 6346945, 6348011, 6349090, 6350588, 6350975, 6355453, 6355158, 6356608, 6357288, 6357303, 6357329, 6357332, 6359135, 6359867, 6360779, 6360865, 6361186, 6361480, 6362164, 6362421, 6362797, 6364043, 6367965, 6369032, 6369718, 6370295, 6370634, 6370791, 6371191, 6371575, 6371661, 6372370, 6372891, 6373378, 6373975, 6374212, 6376625, 6376805, 6377399, 6377614, 6378651, 6382156, 6383653, 6383916, 6384947, 6385419, 6385659, 6386185, 6387288, 6387544, 6387839, 6388471, 6389089, 6389110, 6393097, 6395378, 6395905, 6397165, 6397353, 6397563, 6398632, 6399197, 6399758, 6400009, 6404892, 6405556, 6406265, 6407572, 6408172, 6410416, 6411282, 6411319, 6412150, 6412212, 6414540, 6414599, 6415213, 6416122, 6417452, 6417644, 6417871, 6418309, 6418852, 6419444, 6419809, 6422751, 6424672, 6424852, 6431753, 6435879, 6436025, 6437746, 6441589, 6444125, 6444285, 6445282, 6445373, 6447064, 6449740, 6449927, 6450987, 6451096, 6451461, 6453456, 6453659, 6454095, 6454567, 6454898, 6454989, 6455185, 6455830, 6456521, 6459930, 6461508, 6465676, 6466502, 6466852, 1000002698, 1000003192, 1000004818, 1000004984, 1000003798, 1000005942, 1000007518, 1000001473, 1000008176, 1000008495, 1000008522, 1000008523, 1000009868, 1000010601, 1000004985, 1000012937, 1000012822, 1000015082, 1000016586, 1000015249, 1000023901, 1000024603, 1000024604, 1000026498, 1000018257, 1000028307, 1000028308, 1000028309, 1000028315, 1000028318, 1000028355, 1000028357, 1000028358, 1000023428, 1000028998, 1000018477, 1000035991, 1000035992, 1000036052, 1000036097, 1000036098, 1000036100, 1000036101, 1000036105, 1000036107, 1000036586, 1000036982, 1000036988, 1000036991, 1000036994, 1000036995, 1000036996, 1000036997, 1000036998, 1000036999, 1000037000, 1000037001, 1000037002, 1000037003, 1000037004, 1000037005, 1000040344, 1000040497, 1000034763, 1000041412, 1000047767, 1000029437, 1000039503, 1000050974, 1000051320, 1000052243) AND p0_.id <> 5714 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.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
  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 (52, 245, 246, 247, 248, 248) AND p0_.is_active = 1 AND p0_.id <> 5714 AND p0_.is_btoc = 1 AND p0_.is_orapi_grand_frais <> 1 LIMIT 10;

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 = '36128-reliure-noir-n-c-dia-6mm-noir' 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 = ?
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
  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 = 5714 AND c1_.is_display_site = 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 = '36128-reliure-noir-n-c-dia-6mm-noir';

SELECT
  t0.id AS id_1,
  t0.value AS value_2,
  t0.product_id AS product_id_3,
  t0.characteristic_label_id AS characteristic_label_id_4
FROM
  characteristic t0
WHERE
  t0.product_id = ?

SELECT t0.id AS id_1, t0.value AS value_2, t0.product_id AS product_id_3, t0.characteristic_label_id AS characteristic_label_id_4 FROM characteristic t0 WHERE t0.product_id = 5714;

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;