Symfony Profiler

Query Metrics

112 Database Queries

23 Different statements

2769.47 ms Query time

0 Invalid entities

3475 Managed entities

Grouped Statements

Time▼	Count	Info
1528.56 ms (55.19%)	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 >= ? Parameters: [`1998 "2025-04-12 14:59:47"`] View formatted query View runnable query Explain query 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 = 1998 AND c0_.created_at >= '2025-04-12 14:59:47';
1093.02 ms (39.47%)	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 Parameters: [6384331 6384745 6385429 6385617 6379703 6386587 6387534 6389034 6385841 6390268 6390269 6390283 6390472 6390570 6389966 6390970 6391937 6391960 6392755 6393181 6394786 6395406 6395590 6395660 6395718 6396359 6396656 6397009 6397230 6397403 6397440 6397577 6397606 6397969 6398267 6398296 6398660 6398749 6398871 6399163 6399570 6399744 6400319 6402129 6402134 6402244 6403157 6404207 6404359 6404378 6405385 6405601 6405975 6405983 6406298 6406403 6406761 6407146 6407518 6407622 6407648 6407677 6407742 6408065 6408793 6408915 6409697 6410678 6410931 6411422 6411702 6411951 6412214 6412328 6412394 6412699 6412796 6413300 6413305 6413371 6413458 6413473 6413979 6414372 6414970 6415009 6415397 6415412 6415463 6415651 6415764 6416288 6416312 6416438 6416487 6417012 6417046 6417105 6417345 6417474 6417636 6417967 6417988 6418008 6418043 6418068 6418171 6418324 6418536 6418915 6419024 6419109 6419539 6419565 6419567 6419571 6419578 6419765 6420075 6420212 6420244 6420646 6420749 6421185 6421692 6421701 6421721 6422208 6422481 6422818 6422836 6422993 6423120 6423150 6423251 6423967 6423996 6424005 6424033 6424043 6424264 6412853 6424339 6424631 6424790 6425506 1000002785 6426112 6426230 6426249 6426642 6426914 6426925 6427098 6427276 6427652 6427678 6427817 6427773 6428042 6428341 6428389 6428419 6428640 6428746 6428774 6428875 6428917 6428984 6428995 6429008 6429333 6429921 6430020 6430124 6430389 6430632 6430816 6430854 6430916 6430918 6431306 6431506 6431785 6431793 6431810 6431890 6431895 6431926 6432339 6433373 6433455 6433569 6433845 6433971 6434103 6434335 6434346 6434497 6434603 6434626 6434669 6434697 6434753 6434757 6435035 6435179 6435331 6435350 6435459 6435944 6435956 6436027 6436274 6436286 6436304 6436356 6436997 6437106 6437246 6437726 6437971 6437986 6438067 6438072 6438100 6438563 6438626 6438765 6439691 6439881 6439959 6440365 6440940 6440949 6442182 6442789 6442865 6442896 6443072 6443124 6443342 6443590 6443907 6443954 6444102 6444111 6444668 6444750 6444801 6445036 6445271 6445306 6445310 6445530 6445698 6446366 6446374 6446451 6446700 6446739 6447020 6447091 6447254 6447258 6447296 6447320 6447355 6447752 6448796 6448853 6448918 6448960 6448970 6449669 6449713 6449717 6449763 6449767 6449838 6449847 6449871 6450111 6450118 6450154 6450166 6450186 6450195 6450252 6450277 6450283 6450429 6450509 6450516 6450547 6450757 6450863 6450912 6451081 6451129 6451135 6451163 6451172 6451204 6451214 6451330 6451346 6451384 6451577 6451707 6451794 6451819 6451837 6451860 6451947 6452007 6452068 6452073 6452123 6452415 6452467 6452617 6452681 6453072 6453145 6453319 6453388 6453441 6453518 6453659 6453750 6453785 6453827 6453838 6453846 6453890 6453981 6454025 6454177 6454350 6454485 6454518 6454541 6454582 6454591 6454649 6454667 6454702 6454733 6454848 6454855 6454882 6454885 6454926 6454942 6454976 6455125 6455149 6455209 6455237 6455256 6455257 6455302 6455345 6455365 6455389 6455417 6455443 6455444 6455470 6455490 6455507 6455528 6455557 6455566 6455576 6455616 6455695 6455732 6455753 6455806 6455866 6455929 6455988 6456013 6456085 6456091 6456271 6456276 6456317 6456584 6456673 6456788 6456789 6456812 6456998 6457209 6457228 6457241 6457242 6457272 6457290 6457513 6457516 6457735 6458333 6459106 6459212 6459225 6459285 6459308 6459329 6459374 6459486 6460171 6460417 6460950 6461080 6461136 6461276 6461331 6461332 6461611 6461852 6462236 6462718 6463173 6463682 6464010 6464029 6464099 6464223 6464303 6464485 6464570 6464579 6464664 6465253 6465464 6465783 6465822 6465906 6466386 6466751 6468085 6468762 6468938 6469186 6469232 6469260 6469851 6470107 6470177 6470501 6470553 6470569 6470792 6470984 6471210 6471435 6471527 6472228 6472288 6472383 6472766 6473019 6473149 6474429 6474649 6474701 6474706 6474881 6474907 6475567 6475782 6475787 6476562 6476876 6476881 6476933 6476999 6477016 6477103 6477819 6477821 6477925 6480427 6480768 6480780 6480781 6480881 6480999 6481094 6481181 6481279 6481316 6481336 6481339 6481353 6481393 6481710 6482087 6482510 6483029 6483723 6483948 6484086 6484318 6484470 6484494 6484520 6484829 6485080 6485276 6485469 6485502 6485518 6485591 6485632 6486045 6486444 6486503 6486725 6486740 6486749 6488373 6488472 6488568 6488700 6488969 6489042 6489146 6490971 6490979 6491517 6491575 6491791 6491887 6492008 6492760 6493408 6494228 6495111 6495317 6495347 6495380 6495404 6495437 6495472 6495651 6495714 6495907 6495916 6496213 6496290 6496425 6496740 6496842 6497089 6497099 6497117 6497157 6497158 6497326 6497513 6497559 6497614 6497616 6497737 6497752 6497850 6497908 6497939 6498132 6498142 6498163 6498166 6498270 6498280 6498345 6498662 6498859 6498865 6498869 6498977 6499284 6499331 6499453 6499587 6499588 6499589 6499619 6499727 6500106 6500367 6500450 6500508 6500555 6500655 6500741 6501488 6501533 6501534 6501641 6501813 6501837 6501860 6501861 6501867 6501880 6501935 6501971 6501982 6501987 6502006 6502013 6502133 6502193 6502320 6502389 6502411 6502522 6502678 6502749 6502834 6502841 6503078 6503100 6503354 6503485 6503657 6503815 6503816 6503833 6504246 6504252 6504475 6505429 6506061 6506385 6506435 6506463 6507566 6508528 6509375 6510306 6510894 6510982 6511046 6511047 6511245 6512074 6512080 6512216 6512413 6512443 6512586 6512856 6512937 6512955 6513093 6513139 6515154 6515401 6515409 6515918 6516677 6517090 6517350 6517543 6517558 6518355 6518981 6519336 6519399 6519880 6520277 6520869 6521039 6521892 6522636 6522933 6523113 6523946 6524000 6524214 6524281 6524370 6524372 6524429 6524450 6524492 6524517 6524533 6524545 6524680 6525144 6525169 6525220 6525351 6525450 6525454 6525554 6525697 6525789 6525897 6526031 6526067 6526171 6526210 6526213 6526224 6526281 6526346 6526370 6526386 6526504 6526510 6526930 6527020 6527103 6527129 6527144 6527266 6527282 6527602 6527613 6528129 6528161 6528207 6528251 6528334 6528345 6528353 6528390 6528477 6528512 6528565 6528568 6528635 6528663 6528767 6528791 6528793 6528799 6528806 6528821 6528859 6528937 6528965 6529013 6529272 6529286 6529306 6529335 6529338 6529376 6529841 6529882 6529908 6529936 6529941 6529948 6529989 6529995 6530104 6530114 6530149 6530167 6530250 6530289 6530323 6530324 6530462 6530464 6530528 6530611 6530913 6531001 6531200 6531262 6531837 6532732 6532772 6532822 6532901 6532935 6533199 6533205 6533241 6533265 6533267 6533487 6533526 6533897 6534358 6535780 6536519 6537395 6538383 6538778 6538787 6539192 6539196 6539774 6539947 6539966 6540864 6541586 6541762 1000000874 1000000907 1000001415 1000002472 1000001768 1000002718 1000002743 1000002593 1000002780 1000002784 1000002786 1000002906 1000003037 1000001017 6390075 1000004214 1000004440 1000004829 1000004838 6390715 6386290 1000004999 1000005432 1000005540 1000005547 1000006700 1000006706 1000006970 1000007168 1000002338 1000008142 1000008173 1000008704 1000001354 1000002647 1000008912 1000008935 1000009128 6392778 1000009132 1000009640 1000004570 1000006630 1000006370 1000008921 1000004245 1000010097 1000009516 1000009631 1000010079 1000008911 1000010975 1000010976 1000010078 1000011059 1000011861 1000010733 1000011978 1000011071 1000012470 1000012887 1000009930 1000012141 1000005952 6390488 1000011085 1000013164 1000006611 1000013434 1000012510 1000010746 1000008795 1000013754 1000010199 1000012453 1000013830 1000013898 1000005460 1000012382 1000009448 1000014139 1000014140 1000014141 1000014142 1000014143 1000014144 1000014145 1000014146 1000014147 1000014149 1000014150 1000013142 1000014557 1000011954 1000005550 1000015095 1000015429 1000012347 1000014870 1000015619 1000014506 1000009862 1000015833 1000015950 1000016043 1000015797 1000016110 1000016144 1000016145 1000016146 1000016174 1000016298 1000016299 1000016322 1000016323 1000016324 1000016325 1000016327 1000016328 1000016329 1000016330 1000016338 1000016339 1000016341 1000016342 1000016345 1000016347 1000016348 1000016349 1000016350 1000016351 1000016352 1000014747 1000016909 1000016561 1000006277 1000017545 1000017546 1000017703 1000017763 1000017853 1000017868 1000017870 1000017886 1000017887 1000017888 1000017996 1000018031 1000018037 1000018041 1000018042 1000018043 1000018047 1000013165 1000018365 1000018866 1000017394 1000019072 1000019373 1000014666 1000013348 1000019538 1000019570 1000017059 1000020186 1000020192 1000020218 1000020244 1000017170 1000012241 1000020872 1000020874 1000015937 1000021299 1000021217 1000021407 1000021618 1000021620 1000021623 1000021625 1000021821 1000021842 1000019095 1000002711 1000002473 1000022049 1000003926 1000010459 1000014715 1000022193 1000022205 1000016362 1000012938 1000022483 1000022484 1000022513 1000021118 1000016064 1000022706 1000022709 1000022732 1000022747 1000022750 1000022753 1000022755 1000022757 1000022761 1000022763 1000015033 1000022789 1000014961 1000023590 1000023671 1000021863 1000024606 1000024791 1000024812 6378169 1000025450 1000025494 1000014211 1000016910 1000019352 1000026280 1000026282 1000021047 1000014527 1000026573 1000026565 1000025564 1000015517 1000023752 1000026902 1000022808 1000026974 1000026975 1000026976 1000026978 1000026998 1000027000 1000027001 1000021630 1000027073 1000027074 1000016216 1000027002 1000027253 1000027254 1000027285 1000013802 1000027370 1000024402 1000028376 1000028377 1000028383 1000016075 1000014185 1000012381 1000029303 1000029304 1000029353 1000029502 1000029543 1000029544 1000014327 1000028718 1000030015 1000030055 1000030066 1000030423 1000030863 1000030905 1000030914 1000030921 1000030928 1000031313 1000031538 1000031539 1000031542 1000031555 1000031556 1000031590 1000031656 1000031661 1000031699 1000031703 1000031723 1000031725 1000031726 1000031727 1000031867 1000031880 1000031960 1000031968 1000013398 1000032032 1000013556 1000023685 1000032669 1000032793 1000032819 1000018130 1000033157 1000024032 1000013644 1000031322 1000002096 1000034000 1000034276 1000034283 1000034294 1000024507 1000034547 1000034548 1000034549 1000034550 1000034551 1000034552 1000034553 1000034554 1000034556 1000034923 1000034924 1000034925 1000034926 1000034927 1000034928 1000034929 1000034930 1000034931 1000034932 1000035146 1000017391 1000035631 1000035633 1000035635 1000035636 1000035637 1000035638 1000035639 1000035644 1000035707 1000035711 1000035716 1000035828 1000035830 1000035835 1000035836 1000035837 1000035839 1000035985 1000036802 1000036804 1000036806 1000036843 1000022806 1000037083 1000037084 1000037089 1000037568 1000037602 1000037652 1000037706 1000037766 1000038180 1000038181 1000038182 1000038183 1000038184 1000038185 1000038186 1000015351 1000038344 1000039076 1000039090 1000039091 1000039111 1000039284 1000039285 1000039287 1000039309 1000039340 1000039342 1000039344 1000039350 1000039359 1000039408 1000039411 1000039515 1000040111 1000040113 1000040118 1000040409 1000040412 1000040526 1000040793 1000040941 1000040966 1000040985 1000040991 1000040992 1000041043 1000041291 1000041292 1000041293 1000041301 1000041305 1000041317 1000041322 1000041323 1000041324 1000041337 1000041340 1000041469 1000033326 1000042010 1000042014 1000042020 1000042033 1000042044 1000042055 1000042056 1000042061 1000042062 1000042077 1000042080 6376593 1000022299 1000042835 1000042836 1000043060 1000043061 1000043062 1000043066 1000043070 1000014960 1000035720 1000043724 1000022214 1000044087 1000044131 1000044137 1000044146 1000044177 1000044211 1000044216 1000044219 1000044221 1000044222 1000044223 1000044227 1000044531 1000044534 1000044943 1000044969 1000039739 1000045051 1000045053 1000045055 1000045057 1000045062 1000045065 1000045066 1000045068 1000045074 1000045082 1000045100 1000045103 1000041429 1000045245 1000045252 1000045253 1000045265 1000045268 1000045283 1000045284 1000045622 1000045834 1000046078 1000046082 1000046101 1000029306 1000046151 1000046512 1000046787 1000046936 1000045172 1000034683 1000047589 1000016703 1000047754 1000047755 1000047757 1000047758 1000047760 1000047771 1000047834 1000047877 1000047920 1000037770 1000047984 1000047997 1000033049 1000044599 1000048038 1000048050 1000048051 1000048052 1000048176 1000048191 1000048202 1000048203 1000048205 1000048207 1000048268 1000048270 1000048271 1000048304 1000048315 1000048316 1000032846 1000048499 1000044992 1000048594 1000047591 1000048710 1000048791 1000048083 1000048946 1000049147 1000049224 1000049296 1000049299 1000049312 1000049349 1000049261 1000042895 1000049529 1000031997 1000049588 1000049591 1000049626 1000049654 1000044542 1000045108 1000049811 1000049947 1000048235 1000048968 1000050175 1000050477 1000050597 1000050613 1000050615 1000047122 1000047146 1000049030 1000050897 1000048190 1000051044 1000051080 1000051212 1000050835 1000050842 1000051387 1000050134 1000022825 1000051458 1000051497 1000051518 1000051369 1000051528 1000051527 1000051555 1000051629 1000051734 1000051737 1000048241 1000051912 1000051958 1000049911 1000052073 1000051560 1000052310 1000052325 1000052326 1000052327 1000052333 1000052434 1000048104 1000052539 1000016443 1000045839 1000052635 1000052769 1000052770 1000052757 1000052823 1000052824 1000052893 1000052852 1000052966 1000052914 1000052204 1000052036 1000053220 1000053223 1000048580 1000053333 1000053339 1000053342 1000053417 1000053438 1000053440 1000053446 1000052804 1000053595 1000053341 1000053715 1000053769 1000051081 1000048837 1000054090 1000053564 1000054146 1000053340 1000051325 1000054330 1000054516 1000054503 1000054641 1000053445 1000054690 1000054838 1000054486 1000048273 1000055204 1000055205 1000055240 1000055231 1000049284 1000055327 1000055736 1000055739 1000055740 1000055741 1000055806 1000055807 1000049980 1000055876 1000054051 1000055959 1000056154 1000056146 1000054604 1000054334 1000056704 1000056706 1000034018 1000057050 1000056858 1000053763 1000057345 1000055229 1000057534 1000057535 1000057537 1000057575 1000056127 1000048035 1000058134 1000058135 1000057976 1000048392 1000058081 1000058298 1000058333 1000057493 1000059654 1000059763 1000059772 1000059799 1000059918 1000060016 1000058116 1000058885 1000060304 1000060343 1000053354 1000060419 1000060460 1000060867 1000060875 1000061099 1000061306 1000061471 1000061480 1000061520 1000061389 1000061691 1000061391 1000061739 1000061845 1000059327 1000062678 1000063396 1000063397 1000064026 1000064297 1000064613 1000064642 1000065260 1000065349 1000051502 1000066005 1000066217 1000066331 1000066393 1000066006 1000066410 1000066437 1998] View formatted query View runnable query Explain query 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 (6384331, 6384745, 6385429, 6385617, 6379703, 6386587, 6387534, 6389034, 6385841, 6390268, 6390269, 6390283, 6390472, 6390570, 6389966, 6390970, 6391937, 6391960, 6392755, 6393181, 6394786, 6395406, 6395590, 6395660, 6395718, 6396359, 6396656, 6397009, 6397230, 6397403, 6397440, 6397577, 6397606, 6397969, 6398267, 6398296, 6398660, 6398749, 6398871, 6399163, 6399570, 6399744, 6400319, 6402129, 6402134, 6402244, 6403157, 6404207, 6404359, 6404378, 6405385, 6405601, 6405975, 6405983, 6406298, 6406403, 6406761, 6407146, 6407518, 6407622, 6407648, 6407677, 6407742, 6408065, 6408793, 6408915, 6409697, 6410678, 6410931, 6411422, 6411702, 6411951, 6412214, 6412328, 6412394, 6412699, 6412796, 6413300, 6413305, 6413371, 6413458, 6413473, 6413979, 6414372, 6414970, 6415009, 6415397, 6415412, 6415463, 6415651, 6415764, 6416288, 6416312, 6416438, 6416487, 6417012, 6417046, 6417105, 6417345, 6417474, 6417636, 6417967, 6417988, 6418008, 6418043, 6418068, 6418171, 6418324, 6418536, 6418915, 6419024, 6419109, 6419539, 6419565, 6419567, 6419571, 6419578, 6419765, 6420075, 6420212, 6420244, 6420646, 6420749, 6421185, 6421692, 6421701, 6421721, 6422208, 6422481, 6422818, 6422836, 6422993, 6423120, 6423150, 6423251, 6423967, 6423996, 6424005, 6424033, 6424043, 6424264, 6412853, 6424339, 6424631, 6424790, 6425506, 1000002785, 6426112, 6426230, 6426249, 6426642, 6426914, 6426925, 6427098, 6427276, 6427652, 6427678, 6427817, 6427773, 6428042, 6428341, 6428389, 6428419, 6428640, 6428746, 6428774, 6428875, 6428917, 6428984, 6428995, 6429008, 6429333, 6429921, 6430020, 6430124, 6430389, 6430632, 6430816, 6430854, 6430916, 6430918, 6431306, 6431506, 6431785, 6431793, 6431810, 6431890, 6431895, 6431926, 6432339, 6433373, 6433455, 6433569, 6433845, 6433971, 6434103, 6434335, 6434346, 6434497, 6434603, 6434626, 6434669, 6434697, 6434753, 6434757, 6435035, 6435179, 6435331, 6435350, 6435459, 6435944, 6435956, 6436027, 6436274, 6436286, 6436304, 6436356, 6436997, 6437106, 6437246, 6437726, 6437971, 6437986, 6438067, 6438072, 6438100, 6438563, 6438626, 6438765, 6439691, 6439881, 6439959, 6440365, 6440940, 6440949, 6442182, 6442789, 6442865, 6442896, 6443072, 6443124, 6443342, 6443590, 6443907, 6443954, 6444102, 6444111, 6444668, 6444750, 6444801, 6445036, 6445271, 6445306, 6445310, 6445530, 6445698, 6446366, 6446374, 6446451, 6446700, 6446739, 6447020, 6447091, 6447254, 6447258, 6447296, 6447320, 6447355, 6447752, 6448796, 6448853, 6448918, 6448960, 6448970, 6449669, 6449713, 6449717, 6449763, 6449767, 6449838, 6449847, 6449871, 6450111, 6450118, 6450154, 6450166, 6450186, 6450195, 6450252, 6450277, 6450283, 6450429, 6450509, 6450516, 6450547, 6450757, 6450863, 6450912, 6451081, 6451129, 6451135, 6451163, 6451172, 6451204, 6451214, 6451330, 6451346, 6451384, 6451577, 6451707, 6451794, 6451819, 6451837, 6451860, 6451947, 6452007, 6452068, 6452073, 6452123, 6452415, 6452467, 6452617, 6452681, 6453072, 6453145, 6453319, 6453388, 6453441, 6453518, 6453659, 6453750, 6453785, 6453827, 6453838, 6453846, 6453890, 6453981, 6454025, 6454177, 6454350, 6454485, 6454518, 6454541, 6454582, 6454591, 6454649, 6454667, 6454702, 6454733, 6454848, 6454855, 6454882, 6454885, 6454926, 6454942, 6454976, 6455125, 6455149, 6455209, 6455237, 6455256, 6455257, 6455302, 6455345, 6455365, 6455389, 6455417, 6455443, 6455444, 6455470, 6455490, 6455507, 6455528, 6455557, 6455566, 6455576, 6455616, 6455695, 6455732, 6455753, 6455806, 6455866, 6455929, 6455988, 6456013, 6456085, 6456091, 6456271, 6456276, 6456317, 6456584, 6456673, 6456788, 6456789, 6456812, 6456998, 6457209, 6457228, 6457241, 6457242, 6457272, 6457290, 6457513, 6457516, 6457735, 6458333, 6459106, 6459212, 6459225, 6459285, 6459308, 6459329, 6459374, 6459486, 6460171, 6460417, 6460950, 6461080, 6461136, 6461276, 6461331, 6461332, 6461611, 6461852, 6462236, 6462718, 6463173, 6463682, 6464010, 6464029, 6464099, 6464223, 6464303, 6464485, 6464570, 6464579, 6464664, 6465253, 6465464, 6465783, 6465822, 6465906, 6466386, 6466751, 6468085, 6468762, 6468938, 6469186, 6469232, 6469260, 6469851, 6470107, 6470177, 6470501, 6470553, 6470569, 6470792, 6470984, 6471210, 6471435, 6471527, 6472228, 6472288, 6472383, 6472766, 6473019, 6473149, 6474429, 6474649, 6474701, 6474706, 6474881, 6474907, 6475567, 6475782, 6475787, 6476562, 6476876, 6476881, 6476933, 6476999, 6477016, 6477103, 6477819, 6477821, 6477925, 6480427, 6480768, 6480780, 6480781, 6480881, 6480999, 6481094, 6481181, 6481279, 6481316, 6481336, 6481339, 6481353, 6481393, 6481710, 6482087, 6482510, 6483029, 6483723, 6483948, 6484086, 6484318, 6484470, 6484494, 6484520, 6484829, 6485080, 6485276, 6485469, 6485502, 6485518, 6485591, 6485632, 6486045, 6486444, 6486503, 6486725, 6486740, 6486749, 6488373, 6488472, 6488568, 6488700, 6488969, 6489042, 6489146, 6490971, 6490979, 6491517, 6491575, 6491791, 6491887, 6492008, 6492760, 6493408, 6494228, 6495111, 6495317, 6495347, 6495380, 6495404, 6495437, 6495472, 6495651, 6495714, 6495907, 6495916, 6496213, 6496290, 6496425, 6496740, 6496842, 6497089, 6497099, 6497117, 6497157, 6497158, 6497326, 6497513, 6497559, 6497614, 6497616, 6497737, 6497752, 6497850, 6497908, 6497939, 6498132, 6498142, 6498163, 6498166, 6498270, 6498280, 6498345, 6498662, 6498859, 6498865, 6498869, 6498977, 6499284, 6499331, 6499453, 6499587, 6499588, 6499589, 6499619, 6499727, 6500106, 6500367, 6500450, 6500508, 6500555, 6500655, 6500741, 6501488, 6501533, 6501534, 6501641, 6501813, 6501837, 6501860, 6501861, 6501867, 6501880, 6501935, 6501971, 6501982, 6501987, 6502006, 6502013, 6502133, 6502193, 6502320, 6502389, 6502411, 6502522, 6502678, 6502749, 6502834, 6502841, 6503078, 6503100, 6503354, 6503485, 6503657, 6503815, 6503816, 6503833, 6504246, 6504252, 6504475, 6505429, 6506061, 6506385, 6506435, 6506463, 6507566, 6508528, 6509375, 6510306, 6510894, 6510982, 6511046, 6511047, 6511245, 6512074, 6512080, 6512216, 6512413, 6512443, 6512586, 6512856, 6512937, 6512955, 6513093, 6513139, 6515154, 6515401, 6515409, 6515918, 6516677, 6517090, 6517350, 6517543, 6517558, 6518355, 6518981, 6519336, 6519399, 6519880, 6520277, 6520869, 6521039, 6521892, 6522636, 6522933, 6523113, 6523946, 6524000, 6524214, 6524281, 6524370, 6524372, 6524429, 6524450, 6524492, 6524517, 6524533, 6524545, 6524680, 6525144, 6525169, 6525220, 6525351, 6525450, 6525454, 6525554, 6525697, 6525789, 6525897, 6526031, 6526067, 6526171, 6526210, 6526213, 6526224, 6526281, 6526346, 6526370, 6526386, 6526504, 6526510, 6526930, 6527020, 6527103, 6527129, 6527144, 6527266, 6527282, 6527602, 6527613, 6528129, 6528161, 6528207, 6528251, 6528334, 6528345, 6528353, 6528390, 6528477, 6528512, 6528565, 6528568, 6528635, 6528663, 6528767, 6528791, 6528793, 6528799, 6528806, 6528821, 6528859, 6528937, 6528965, 6529013, 6529272, 6529286, 6529306, 6529335, 6529338, 6529376, 6529841, 6529882, 6529908, 6529936, 6529941, 6529948, 6529989, 6529995, 6530104, 6530114, 6530149, 6530167, 6530250, 6530289, 6530323, 6530324, 6530462, 6530464, 6530528, 6530611, 6530913, 6531001, 6531200, 6531262, 6531837, 6532732, 6532772, 6532822, 6532901, 6532935, 6533199, 6533205, 6533241, 6533265, 6533267, 6533487, 6533526, 6533897, 6534358, 6535780, 6536519, 6537395, 6538383, 6538778, 6538787, 6539192, 6539196, 6539774, 6539947, 6539966, 6540864, 6541586, 6541762, 1000000874, 1000000907, 1000001415, 1000002472, 1000001768, 1000002718, 1000002743, 1000002593, 1000002780, 1000002784, 1000002786, 1000002906, 1000003037, 1000001017, 6390075, 1000004214, 1000004440, 1000004829, 1000004838, 6390715, 6386290, 1000004999, 1000005432, 1000005540, 1000005547, 1000006700, 1000006706, 1000006970, 1000007168, 1000002338, 1000008142, 1000008173, 1000008704, 1000001354, 1000002647, 1000008912, 1000008935, 1000009128, 6392778, 1000009132, 1000009640, 1000004570, 1000006630, 1000006370, 1000008921, 1000004245, 1000010097, 1000009516, 1000009631, 1000010079, 1000008911, 1000010975, 1000010976, 1000010078, 1000011059, 1000011861, 1000010733, 1000011978, 1000011071, 1000012470, 1000012887, 1000009930, 1000012141, 1000005952, 6390488, 1000011085, 1000013164, 1000006611, 1000013434, 1000012510, 1000010746, 1000008795, 1000013754, 1000010199, 1000012453, 1000013830, 1000013898, 1000005460, 1000012382, 1000009448, 1000014139, 1000014140, 1000014141, 1000014142, 1000014143, 1000014144, 1000014145, 1000014146, 1000014147, 1000014149, 1000014150, 1000013142, 1000014557, 1000011954, 1000005550, 1000015095, 1000015429, 1000012347, 1000014870, 1000015619, 1000014506, 1000009862, 1000015833, 1000015950, 1000016043, 1000015797, 1000016110, 1000016144, 1000016145, 1000016146, 1000016174, 1000016298, 1000016299, 1000016322, 1000016323, 1000016324, 1000016325, 1000016327, 1000016328, 1000016329, 1000016330, 1000016338, 1000016339, 1000016341, 1000016342, 1000016345, 1000016347, 1000016348, 1000016349, 1000016350, 1000016351, 1000016352, 1000014747, 1000016909, 1000016561, 1000006277, 1000017545, 1000017546, 1000017703, 1000017763, 1000017853, 1000017868, 1000017870, 1000017886, 1000017887, 1000017888, 1000017996, 1000018031, 1000018037, 1000018041, 1000018042, 1000018043, 1000018047, 1000013165, 1000018365, 1000018866, 1000017394, 1000019072, 1000019373, 1000014666, 1000013348, 1000019538, 1000019570, 1000017059, 1000020186, 1000020192, 1000020218, 1000020244, 1000017170, 1000012241, 1000020872, 1000020874, 1000015937, 1000021299, 1000021217, 1000021407, 1000021618, 1000021620, 1000021623, 1000021625, 1000021821, 1000021842, 1000019095, 1000002711, 1000002473, 1000022049, 1000003926, 1000010459, 1000014715, 1000022193, 1000022205, 1000016362, 1000012938, 1000022483, 1000022484, 1000022513, 1000021118, 1000016064, 1000022706, 1000022709, 1000022732, 1000022747, 1000022750, 1000022753, 1000022755, 1000022757, 1000022761, 1000022763, 1000015033, 1000022789, 1000014961, 1000023590, 1000023671, 1000021863, 1000024606, 1000024791, 1000024812, 6378169, 1000025450, 1000025494, 1000014211, 1000016910, 1000019352, 1000026280, 1000026282, 1000021047, 1000014527, 1000026573, 1000026565, 1000025564, 1000015517, 1000023752, 1000026902, 1000022808, 1000026974, 1000026975, 1000026976, 1000026978, 1000026998, 1000027000, 1000027001, 1000021630, 1000027073, 1000027074, 1000016216, 1000027002, 1000027253, 1000027254, 1000027285, 1000013802, 1000027370, 1000024402, 1000028376, 1000028377, 1000028383, 1000016075, 1000014185, 1000012381, 1000029303, 1000029304, 1000029353, 1000029502, 1000029543, 1000029544, 1000014327, 1000028718, 1000030015, 1000030055, 1000030066, 1000030423, 1000030863, 1000030905, 1000030914, 1000030921, 1000030928, 1000031313, 1000031538, 1000031539, 1000031542, 1000031555, 1000031556, 1000031590, 1000031656, 1000031661, 1000031699, 1000031703, 1000031723, 1000031725, 1000031726, 1000031727, 1000031867, 1000031880, 1000031960, 1000031968, 1000013398, 1000032032, 1000013556, 1000023685, 1000032669, 1000032793, 1000032819, 1000018130, 1000033157, 1000024032, 1000013644, 1000031322, 1000002096, 1000034000, 1000034276, 1000034283, 1000034294, 1000024507, 1000034547, 1000034548, 1000034549, 1000034550, 1000034551, 1000034552, 1000034553, 1000034554, 1000034556, 1000034923, 1000034924, 1000034925, 1000034926, 1000034927, 1000034928, 1000034929, 1000034930, 1000034931, 1000034932, 1000035146, 1000017391, 1000035631, 1000035633, 1000035635, 1000035636, 1000035637, 1000035638, 1000035639, 1000035644, 1000035707, 1000035711, 1000035716, 1000035828, 1000035830, 1000035835, 1000035836, 1000035837, 1000035839, 1000035985, 1000036802, 1000036804, 1000036806, 1000036843, 1000022806, 1000037083, 1000037084, 1000037089, 1000037568, 1000037602, 1000037652, 1000037706, 1000037766, 1000038180, 1000038181, 1000038182, 1000038183, 1000038184, 1000038185, 1000038186, 1000015351, 1000038344, 1000039076, 1000039090, 1000039091, 1000039111, 1000039284, 1000039285, 1000039287, 1000039309, 1000039340, 1000039342, 1000039344, 1000039350, 1000039359, 1000039408, 1000039411, 1000039515, 1000040111, 1000040113, 1000040118, 1000040409, 1000040412, 1000040526, 1000040793, 1000040941, 1000040966, 1000040985, 1000040991, 1000040992, 1000041043, 1000041291, 1000041292, 1000041293, 1000041301, 1000041305, 1000041317, 1000041322, 1000041323, 1000041324, 1000041337, 1000041340, 1000041469, 1000033326, 1000042010, 1000042014, 1000042020, 1000042033, 1000042044, 1000042055, 1000042056, 1000042061, 1000042062, 1000042077, 1000042080, 6376593, 1000022299, 1000042835, 1000042836, 1000043060, 1000043061, 1000043062, 1000043066, 1000043070, 1000014960, 1000035720, 1000043724, 1000022214, 1000044087, 1000044131, 1000044137, 1000044146, 1000044177, 1000044211, 1000044216, 1000044219, 1000044221, 1000044222, 1000044223, 1000044227, 1000044531, 1000044534, 1000044943, 1000044969, 1000039739, 1000045051, 1000045053, 1000045055, 1000045057, 1000045062, 1000045065, 1000045066, 1000045068, 1000045074, 1000045082, 1000045100, 1000045103, 1000041429, 1000045245, 1000045252, 1000045253, 1000045265, 1000045268, 1000045283, 1000045284, 1000045622, 1000045834, 1000046078, 1000046082, 1000046101, 1000029306, 1000046151, 1000046512, 1000046787, 1000046936, 1000045172, 1000034683, 1000047589, 1000016703, 1000047754, 1000047755, 1000047757, 1000047758, 1000047760, 1000047771, 1000047834, 1000047877, 1000047920, 1000037770, 1000047984, 1000047997, 1000033049, 1000044599, 1000048038, 1000048050, 1000048051, 1000048052, 1000048176, 1000048191, 1000048202, 1000048203, 1000048205, 1000048207, 1000048268, 1000048270, 1000048271, 1000048304, 1000048315, 1000048316, 1000032846, 1000048499, 1000044992, 1000048594, 1000047591, 1000048710, 1000048791, 1000048083, 1000048946, 1000049147, 1000049224, 1000049296, 1000049299, 1000049312, 1000049349, 1000049261, 1000042895, 1000049529, 1000031997, 1000049588, 1000049591, 1000049626, 1000049654, 1000044542, 1000045108, 1000049811, 1000049947, 1000048235, 1000048968, 1000050175, 1000050477, 1000050597, 1000050613, 1000050615, 1000047122, 1000047146, 1000049030, 1000050897, 1000048190, 1000051044, 1000051080, 1000051212, 1000050835, 1000050842, 1000051387, 1000050134, 1000022825, 1000051458, 1000051497, 1000051518, 1000051369, 1000051528, 1000051527, 1000051555, 1000051629, 1000051734, 1000051737, 1000048241, 1000051912, 1000051958, 1000049911, 1000052073, 1000051560, 1000052310, 1000052325, 1000052326, 1000052327, 1000052333, 1000052434, 1000048104, 1000052539, 1000016443, 1000045839, 1000052635, 1000052769, 1000052770, 1000052757, 1000052823, 1000052824, 1000052893, 1000052852, 1000052966, 1000052914, 1000052204, 1000052036, 1000053220, 1000053223, 1000048580, 1000053333, 1000053339, 1000053342, 1000053417, 1000053438, 1000053440, 1000053446, 1000052804, 1000053595, 1000053341, 1000053715, 1000053769, 1000051081, 1000048837, 1000054090, 1000053564, 1000054146, 1000053340, 1000051325, 1000054330, 1000054516, 1000054503, 1000054641, 1000053445, 1000054690, 1000054838, 1000054486, 1000048273, 1000055204, 1000055205, 1000055240, 1000055231, 1000049284, 1000055327, 1000055736, 1000055739, 1000055740, 1000055741, 1000055806, 1000055807, 1000049980, 1000055876, 1000054051, 1000055959, 1000056154, 1000056146, 1000054604, 1000054334, 1000056704, 1000056706, 1000034018, 1000057050, 1000056858, 1000053763, 1000057345, 1000055229, 1000057534, 1000057535, 1000057537, 1000057575, 1000056127, 1000048035, 1000058134, 1000058135, 1000057976, 1000048392, 1000058081, 1000058298, 1000058333, 1000057493, 1000059654, 1000059763, 1000059772, 1000059799, 1000059918, 1000060016, 1000058116, 1000058885, 1000060304, 1000060343, 1000053354, 1000060419, 1000060460, 1000060867, 1000060875, 1000061099, 1000061306, 1000061471, 1000061480, 1000061520, 1000061389, 1000061691, 1000061391, 1000061739, 1000061845, 1000059327, 1000062678, 1000063396, 1000063397, 1000064026, 1000064297, 1000064613, 1000064642, 1000065260, 1000065349, 1000051502, 1000066005, 1000066217, 1000066331, 1000066393, 1000066006, 1000066410, 1000066437) AND p0_.id <> 1998 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;
110.22 ms (3.98%)	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 = ? AND p0_.is_active = 1 Parameters: [`"15004-marqueurs-effacables-assorties-bic-1714"`] View formatted query View runnable query Explain query 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 = '15004-marqueurs-effacables-assorties-bic-1714' AND p0_.is_active = 1;
5.11 ms (0.18%)	4	SELECT d0_.id AS id_0, d0_.quantity AS quantity_1, d0_.price_ht AS price_ht_2, d0_.price_ttc AS price_ttc_3, d0_.product_id AS product_id_4, d0_.product_price_id AS product_price_id_5, d0_.promotion_id AS promotion_id_6, d0_.market_id AS market_id_7 FROM decreasing_price d0_ WHERE d0_.product_id = ? AND d0_.quantity <= ? AND d0_.market_id IS NULL AND d0_.product_price_id IS NULL AND d0_.promotion_id IS NULL ORDER BY d0_.quantity DESC LIMIT 1 Parameters: [`1998 0`] View formatted query View runnable query Explain query SELECT d0_.id AS id_0, d0_.quantity AS quantity_1, d0_.price_ht AS price_ht_2, d0_.price_ttc AS price_ttc_3, d0_.product_id AS product_id_4, d0_.product_price_id AS product_price_id_5, d0_.promotion_id AS promotion_id_6, d0_.market_id AS market_id_7 FROM decreasing_price d0_ WHERE d0_.product_id = ? AND d0_.quantity <= ? AND d0_.market_id IS NULL AND d0_.product_price_id IS NULL AND d0_.promotion_id IS NULL ORDER BY d0_.quantity DESC LIMIT 1 SELECT d0_.id AS id_0, d0_.quantity AS quantity_1, d0_.price_ht AS price_ht_2, d0_.price_ttc AS price_ttc_3, d0_.product_id AS product_id_4, d0_.product_price_id AS product_price_id_5, d0_.promotion_id AS promotion_id_6, d0_.market_id AS market_id_7 FROM decreasing_price d0_ WHERE d0_.product_id = 1998 AND d0_.quantity <= 0 AND d0_.market_id IS NULL AND d0_.product_price_id IS NULL AND d0_.promotion_id IS NULL ORDER BY d0_.quantity DESC LIMIT 1;
4.95 ms (0.18%)	8	SELECT t0.id AS id_1, t0.price_ht AS price_ht_2, t0.price_ttc AS price_ttc_3, t0.price_id AS price_id_4, t0.product_id AS product_id_5 FROM product_price t0 WHERE t0.price_id = ? AND t0.product_id = ? LIMIT 1 Parameters: [`"CAISSE2011" 1998`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.price_ht AS price_ht_2, t0.price_ttc AS price_ttc_3, t0.price_id AS price_id_4, t0.product_id AS product_id_5 FROM product_price t0 WHERE t0.price_id = ? AND t0.product_id = ? LIMIT 1 SELECT t0.id AS id_1, t0.price_ht AS price_ht_2, t0.price_ttc AS price_ttc_3, t0.price_id AS price_id_4, t0.product_id AS product_id_5 FROM product_price t0 WHERE t0.price_id = 'CAISSE2011' AND t0.product_id = 1998 LIMIT 1;
3.85 ms (0.14%)	18	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 = ? Parameters: [`1`] View formatted query View runnable query Explain query 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;
3.68 ms (0.13%)	4	SELECT d0_.quantity AS quantity_0, d0_.price_ht AS price_ht_1, d0_.price_ttc AS price_ttc_2 FROM decreasing_price d0_ WHERE d0_.product_id = ? AND d0_.market_id IS NULL AND d0_.product_price_id IS NULL AND d0_.promotion_id IS NULL ORDER BY d0_.quantity DESC Parameters: [`1998`] View formatted query View runnable query Explain query SELECT d0_.quantity AS quantity_0, d0_.price_ht AS price_ht_1, d0_.price_ttc AS price_ttc_2 FROM decreasing_price d0_ WHERE d0_.product_id = ? AND d0_.market_id IS NULL AND d0_.product_price_id IS NULL AND d0_.promotion_id IS NULL ORDER BY d0_.quantity DESC SELECT d0_.quantity AS quantity_0, d0_.price_ht AS price_ht_1, d0_.price_ttc AS price_ttc_2 FROM decreasing_price d0_ WHERE d0_.product_id = 1998 AND d0_.market_id IS NULL AND d0_.product_price_id IS NULL AND d0_.promotion_id IS NULL ORDER BY d0_.quantity DESC;
3.35 ms (0.12%)	21	SELECT t0.id AS id_1, t0.min_qty AS min_qty_2, t0.max_qty AS max_qty_3, t0.step_qty AS step_qty_4, t0.product_id AS product_id_5 FROM product_rule t0 WHERE t0.product_id = ? Parameters: [`1998`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.min_qty AS min_qty_2, t0.max_qty AS max_qty_3, t0.step_qty AS step_qty_4, t0.product_id AS product_id_5 FROM product_rule t0 WHERE t0.product_id = ? SELECT t0.id AS id_1, t0.min_qty AS min_qty_2, t0.max_qty AS max_qty_3, t0.step_qty AS step_qty_4, t0.product_id AS product_id_5 FROM product_rule t0 WHERE t0.product_id = 1998;
3.06 ms (0.11%)	14	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 Parameters: [`"ourClientsAlsoBoughtMonths"`] View formatted query View runnable query Explain query 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;
2.07 ms (0.07%)	8	SELECT t0.id AS id_1, t0.name AS name_2, t0.affiliated_society AS affiliated_society_3, t0.address1 AS address1_4, t0.address2 AS address2_5, t0.address3 AS address3_6, t0.zip_code AS zip_code_7, t0.city AS city_8, t0.email AS email_9, t0.phone_number AS phone_number_10, t0.fax AS fax_11, t0.id_deposit AS id_deposit_12, t0.gen_code AS gen_code_13, t0.newspaper AS newspaper_14, t0.siren AS siren_15, t0.ape AS ape_16, t0.trading_registry AS trading_registry_17, t0.internal_tva AS internal_tva_18, t0.rib AS rib_19, t0.general_account AS general_account_20, t0.capital AS capital_21 FROM society t0 WHERE t0.id = ? LIMIT 1 Parameters: [`"MOZ"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.affiliated_society AS affiliated_society_3, t0.address1 AS address1_4, t0.address2 AS address2_5, t0.address3 AS address3_6, t0.zip_code AS zip_code_7, t0.city AS city_8, t0.email AS email_9, t0.phone_number AS phone_number_10, t0.fax AS fax_11, t0.id_deposit AS id_deposit_12, t0.gen_code AS gen_code_13, t0.newspaper AS newspaper_14, t0.siren AS siren_15, t0.ape AS ape_16, t0.trading_registry AS trading_registry_17, t0.internal_tva AS internal_tva_18, t0.rib AS rib_19, t0.general_account AS general_account_20, t0.capital AS capital_21 FROM society t0 WHERE t0.id = ? LIMIT 1 SELECT t0.id AS id_1, t0.name AS name_2, t0.affiliated_society AS affiliated_society_3, t0.address1 AS address1_4, t0.address2 AS address2_5, t0.address3 AS address3_6, t0.zip_code AS zip_code_7, t0.city AS city_8, t0.email AS email_9, t0.phone_number AS phone_number_10, t0.fax AS fax_11, t0.id_deposit AS id_deposit_12, t0.gen_code AS gen_code_13, t0.newspaper AS newspaper_14, t0.siren AS siren_15, t0.ape AS ape_16, t0.trading_registry AS trading_registry_17, t0.internal_tva AS internal_tva_18, t0.rib AS rib_19, t0.general_account AS general_account_20, t0.capital AS capital_21 FROM society t0 WHERE t0.id = 'MOZ' LIMIT 1;
1.76 ms (0.06%)	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, t27.id AS id_28, t27.min_qty AS min_qty_29, t27.max_qty AS max_qty_30, t27.step_qty AS step_qty_31, t27.product_id AS product_id_32 FROM product t0 LEFT JOIN product_rule t27 ON t27.product_id = t0.id WHERE t0.reference IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) Parameters: [`"01270" "01271" "01272" "01273" "01280" "01281" "01282" "01283" "15029" "15030" "15031" "15021" "15022" "15023" "15024" "15010" "15011" "15012" "15013" "15019" "15020" "15021" "15022" "15023" "15024" "15029" "15030" "15031"`] View formatted query View runnable query Explain query 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, t27.id AS id_28, t27.min_qty AS min_qty_29, t27.max_qty AS max_qty_30, t27.step_qty AS step_qty_31, t27.product_id AS product_id_32 FROM product t0 LEFT JOIN product_rule t27 ON t27.product_id = t0.id WHERE t0.reference IN ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? ) 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, t27.id AS id_28, t27.min_qty AS min_qty_29, t27.max_qty AS max_qty_30, t27.step_qty AS step_qty_31, t27.product_id AS product_id_32 FROM product t0 LEFT JOIN product_rule t27 ON t27.product_id = t0.id WHERE t0.reference IN ('01270', '01271', '01272', '01273', '01280', '01281', '01282', '01283', '15029', '15030', '15031', '15021', '15022', '15023', '15024', '15010', '15011', '15012', '15013', '15019', '15020', '15021', '15022', '15023', '15024', '15029', '15030', '15031');
1.64 ms (0.06%)	9	SELECT t0.id AS id_1 FROM price t0 WHERE t0.id = ? LIMIT 1 Parameters: [`"C"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1 FROM price t0 WHERE t0.id = ? LIMIT 1 SELECT t0.id AS id_1 FROM price t0 WHERE t0.id = 'C' LIMIT 1;
1.39 ms (0.05%)	4	SELECT d0_.quantity AS quantity_0, MIN(d0_.price_ht) AS sclr_1, MIN(d0_.price_ttc) AS sclr_2 FROM decreasing_price d0_ LEFT JOIN product p1_ ON d0_.product_id = p1_.id LEFT JOIN product_price p2_ ON d0_.product_price_id = p2_.id WHERE p1_.id = ? AND p2_.id = ? GROUP BY d0_.quantity ORDER BY d0_.quantity ASC Parameters: [`1998 9957410`] View formatted query View runnable query Explain query SELECT d0_.quantity AS quantity_0, MIN(d0_.price_ht) AS sclr_1, MIN(d0_.price_ttc) AS sclr_2 FROM decreasing_price d0_ LEFT JOIN product p1_ ON d0_.product_id = p1_.id LEFT JOIN product_price p2_ ON d0_.product_price_id = p2_.id WHERE p1_.id = ? AND p2_.id = ? GROUP BY d0_.quantity ORDER BY d0_.quantity ASC SELECT d0_.quantity AS quantity_0, MIN(d0_.price_ht) AS sclr_1, MIN(d0_.price_ttc) AS sclr_2 FROM decreasing_price d0_ LEFT JOIN product p1_ ON d0_.product_id = p1_.id LEFT JOIN product_price p2_ ON d0_.product_price_id = p2_.id WHERE p1_.id = 1998 AND p2_.id = 9957410 GROUP BY d0_.quantity ORDER BY d0_.quantity ASC;
1.22 ms (0.04%)	4	SELECT t0.id AS id_1, t0.price_ht AS price_ht_2, t0.price_ttc AS price_ttc_3, t0.price_id AS price_id_4, t0.product_id AS product_id_5 FROM product_price t0 WHERE t0.product_id = ? AND t0.price_id = ? LIMIT 1 Parameters: [`1998 "C"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.price_ht AS price_ht_2, t0.price_ttc AS price_ttc_3, t0.price_id AS price_id_4, t0.product_id AS product_id_5 FROM product_price t0 WHERE t0.product_id = ? AND t0.price_id = ? LIMIT 1 SELECT t0.id AS id_1, t0.price_ht AS price_ht_2, t0.price_ttc AS price_ttc_3, t0.price_id AS price_id_4, t0.product_id AS product_id_5 FROM product_price t0 WHERE t0.product_id = 1998 AND t0.price_id = 'C' LIMIT 1;
1.07 ms (0.04%)	4	SELECT p0_.id AS id_0, p0_.label_reduction AS label_reduction_1, p0_.description_reduction AS description_reduction_2, p0_.product_id AS product_id_3, p0_.operation_id AS operation_id_4 FROM product_reduction_label p0_ INNER JOIN operation o1_ ON p0_.operation_id = o1_.id WHERE o1_.is_active = 1 AND o1_.end_date >= ? AND o1_.is_active = 1 AND o1_.view_by LIKE ? AND p0_.product_id = ? Parameters: [`"2025-09-12 14:59:50" "%2%" 1998`] View formatted query View runnable query Explain query SELECT p0_.id AS id_0, p0_.label_reduction AS label_reduction_1, p0_.description_reduction AS description_reduction_2, p0_.product_id AS product_id_3, p0_.operation_id AS operation_id_4 FROM product_reduction_label p0_ INNER JOIN operation o1_ ON p0_.operation_id = o1_.id WHERE o1_.is_active = 1 AND o1_.end_date >= ? AND o1_.is_active = 1 AND o1_.view_by LIKE ? AND p0_.product_id = ? SELECT p0_.id AS id_0, p0_.label_reduction AS label_reduction_1, p0_.description_reduction AS description_reduction_2, p0_.product_id AS product_id_3, p0_.operation_id AS operation_id_4 FROM product_reduction_label p0_ INNER JOIN operation o1_ ON p0_.operation_id = o1_.id WHERE o1_.is_active = 1 AND o1_.end_date >= '2025-09-12 14:59:50' AND o1_.is_active = 1 AND o1_.view_by LIKE '%2%' AND p0_.product_id = 1998;
0.85 ms (0.03%)	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 = ? Parameters: [`"15004-marqueurs-effacables-assorties-bic-1714"`] View formatted query View runnable query Explain query 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 = '15004-marqueurs-effacables-assorties-bic-1714';
0.75 ms (0.03%)	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 Parameters: [`58 275 276 277 278 275 1998`] View formatted query View runnable query Explain query 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 (58, 275, 276, 277, 278, 275) AND p0_.is_active = 1 AND p0_.id <> 1998 AND p0_.is_btoc = 1 AND p0_.is_orapi_grand_frais <> 1 LIMIT 10;
0.69 ms (0.02%)	1	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 = ? AND t0.characteristic_label_id = ? LIMIT 1 Parameters: [`1998 7`] View formatted query View runnable query Explain query 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 = ? AND t0.characteristic_label_id = ? LIMIT 1 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 = 1998 AND t0.characteristic_label_id = 7 LIMIT 1;
0.59 ms (0.02%)	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, t27.id AS id_28, t27.min_qty AS min_qty_29, t27.max_qty AS max_qty_30, t27.step_qty AS step_qty_31, t27.product_id AS product_id_32 FROM product t0 LEFT JOIN product_rule t27 ON t27.product_id = t0.id WHERE t0.id = ? LIMIT 1 Parameters: [`"15004-marqueurs-effacables-assorties-bic-1714"`] View formatted query View runnable query Explain query 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, t27.id AS id_28, t27.min_qty AS min_qty_29, t27.max_qty AS max_qty_30, t27.step_qty AS step_qty_31, t27.product_id AS product_id_32 FROM product t0 LEFT JOIN product_rule t27 ON t27.product_id = t0.id 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, t27.id AS id_28, t27.min_qty AS min_qty_29, t27.max_qty AS max_qty_30, t27.step_qty AS step_qty_31, t27.product_id AS product_id_32 FROM product t0 LEFT JOIN product_rule t27 ON t27.product_id = t0.id WHERE t0.id = '15004-marqueurs-effacables-assorties-bic-1714' LIMIT 1;
0.58 ms (0.02%)	3	SELECT t0.id AS id_1, t0.price_ht AS price_ht_2, t0.price_ttc AS price_ttc_3, t0.discount AS discount_4, t0.product_id AS product_id_5 FROM promotion t0 WHERE t0.product_id = ? Parameters: [`182`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.price_ht AS price_ht_2, t0.price_ttc AS price_ttc_3, t0.discount AS discount_4, t0.product_id AS product_id_5 FROM promotion t0 WHERE t0.product_id = ? SELECT t0.id AS id_1, t0.price_ht AS price_ht_2, t0.price_ttc AS price_ttc_3, t0.discount AS discount_4, t0.product_id AS product_id_5 FROM promotion t0 WHERE t0.product_id = 182;
0.39 ms (0.01%)	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 Parameters: [`1`] View formatted query View runnable query Explain query 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;
0.38 ms (0.01%)	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 = ? Parameters: [`1998 1`] View formatted query View runnable query Explain query 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 = 1998 AND c1_.is_display_site = 1;
0.31 ms (0.01%)	1	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 = ? Parameters: [`1998`] View formatted query View runnable query Explain query 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 = 1998;

Database Connections

Name	Service
default	doctrine.dbal.default_connection

Entity Managers

Name	Service
default	doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

default entity manager

Class	Amount of managed objects
App\Entity\Order\CustomerOrder	1531
App\Entity\Customer\Customer	492
App\Entity\User\User	379
App\Entity\Delivery\Delivery	361
App\Entity\Catalog\ProductCatalog	163
App\Entity\Catalog\CustomerCatalog	163
App\Entity\Product\Market	108
App\Entity\Internal\Commercial	63
App\Entity\Product\ProductPrice	54
App\Entity\Pricing\Price	51
App\Entity\Product\Product	41
App\Entity\Product\Category	21
App\Entity\Product\Characteristic	17
App\Entity\Product\CharacteristicLabel	17
App\Entity\Delivery\DeliveryCost	6
App\Entity\Internal\Society	5
App\Entity\Internal\Parameter	3

Entities Mapping

Class	Mapping errors
App\Entity\Product\Product	No errors.
App\Entity\Product\ProductPrice	No errors.
App\Entity\Pricing\Price	No errors.
App\Entity\Product\Category	No errors.
App\Entity\Pricing\Promotion	No errors.
App\Entity\Catalog\ProductCatalog	No errors.
App\Entity\Catalog\CustomerCatalog	No errors.
App\Entity\PromotionalOperations\Operation	No errors.
App\Entity\Product\ProductMarket	No errors.
App\Entity\Product\Characteristic	No errors.
App\Entity\Personalization\ColorInkModel	No errors.
App\Entity\Personalization\ColorCustom	No errors.
App\Entity\Personalization\PoliceModelCustom	No errors.
App\Entity\Personalization\GlobalPersonnalization	No errors.
App\Entity\Personalization\ModelCustom	No errors.
App\Entity\RubberStamp\RubberStampCustom	No errors.
App\Infrastructure\Doctrine\Entity\ProductRule	No errors.
App\Entity\Customer\Customer	No errors.
App\Entity\Order\CustomerOrder	No errors.
App\Entity\User\User	No errors.
App\Entity\Product\CharacteristicLabel	No errors.
App\Entity\Internal\Parameter	No errors.
App\Entity\Order\CustomerOrderLines	No errors.
App\Entity\Delivery\Delivery	No errors.
App\Entity\Product\Market	No errors.
App\Entity\Internal\Society	No errors.
App\Entity\Internal\Commercial	No errors.
App\Entity\Delivery\DeliveryCost	No errors.
App\Entity\Order\ReclamationOrder	No errors.
App\Entity\Pricing\DecreasingPrice	No errors.
App\Entity\Product\ProductReductionLabel	No errors.

Symfony Profiler

GET https://staging.pgdis.com/produit/15004-marqueurs-effacables-assorties-bic-1714

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping