Symfony Profiler

Query Metrics

147 Database Queries

25 Different statements

2202.92 ms Query time

0 Invalid entities

3002 Managed entities

Grouped Statements

Time▼	Count	Info
1106.55 ms (50.23%)	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: [`28696 "2025-04-12 17:05:10"`] 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 = 28696 AND c0_.created_at >= '2025-04-12 17:05:10';
893.53 ms (40.56%)	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: [6377112 6382895 6382908 6386715 6387783 6388575 6388957 6368973 6391382 6391458 6391459 6391460 6391673 6392189 6392298 6392616 6384712 6390865 6393405 6393609 6393687 6392714 6394022 6394397 6395896 6396550 6396683 6397478 6398170 6398915 6399160 6400132 6400742 6400802 6402794 6403129 6404002 6404991 6404992 6405408 6408783 6408895 6409981 6409982 6409983 6409984 6409985 6409986 6409987 6409988 6410627 6410961 6411290 6411334 6411339 6411346 6411822 6412087 6412095 6412157 6412162 6412823 6412922 6412931 6412973 6413505 6414266 6414269 6414606 6415009 6415647 6416114 6416116 6416257 6416781 6416860 6417089 6417931 6418318 6418942 6418972 6419151 6419282 6419994 6420228 6420625 6420749 6421050 6421288 6421337 6421673 6421730 6421753 6422187 6422804 6423558 6423559 6423561 6423562 6423563 6423564 6423565 6423566 6423567 6423727 6424052 6424790 6425095 6425115 6425383 6426250 6426279 6426625 6426683 6426704 6426761 6426927 6426961 6426980 6427644 6427994 6428247 6428557 6429135 6429577 6429578 6429631 6430880 6408052 6431782 6431869 6432154 6432334 6433471 6434384 6434404 6434622 6434765 6435318 6435320 6435328 6435329 6435333 6435336 6435337 6435353 6435355 6435401 6435466 6436309 6436315 6436512 6436513 6436516 6436517 6436518 6436519 6436520 6436521 6436522 6436523 6436524 6436525 6436526 6436527 6436529 6436650 6436654 6436655 6436656 6436657 6436658 6436659 6436660 6436661 6436662 6436663 6436664 6436665 6436666 6436667 6436668 6436669 6436670 6436671 6436672 6436673 6436674 6436675 6436676 6436677 6436678 6436679 6436680 6436681 6436682 6436683 6436684 6436685 6436686 6436687 6436688 6436689 6436690 6436691 6436692 6436693 6436694 6436695 6436696 6436697 6436698 6436699 6436700 6436701 6436702 6436703 6436704 6436705 6436706 6436708 6436709 6437502 6437504 6437507 6437509 6437511 6437512 6437513 6437514 6437515 6437516 6437517 6437518 6437519 6437520 6437521 6437522 6437523 6437524 6437525 6437527 6437528 6437529 6437530 6437531 6437532 6437533 6437534 6437535 6437536 6437537 6437538 6437539 6437540 6437541 6437542 6437543 6437544 6437545 6437546 6437547 6437548 6437549 6437550 6437551 6437552 6437553 6437554 6437556 6437557 6437558 6437559 6437560 6437561 6437562 6437563 6437564 6437567 6437568 6437569 6437570 6437571 6437572 6437573 6437574 6437575 6437576 6437577 6437578 6437579 6437580 6437626 6437629 6437649 6437654 6437894 6437988 6438026 6438631 6439266 6439548 6439827 6439838 6439845 6439865 6439946 6439962 6439975 6440089 6440289 6440558 6441024 6441579 6441581 6442136 6442151 6442165 6442255 6442571 6442776 6442808 6442883 6442969 6442985 6443397 6443733 6443924 6443927 6443962 6443965 6444251 6445422 6445620 6445621 6445981 6446535 6446773 6446959 6447705 6448224 6448227 6448237 6448240 6449642 6450383 6450424 6450505 6451011 6451150 6451191 6451195 6451213 6451220 6451239 6451298 6451349 6452101 6452108 6452193 6452418 6452427 6452520 6452584 6453154 6453477 6453551 6453568 6454112 6454586 6454657 6454677 6454690 6454711 6454783 6454865 6454926 6455149 6455257 6455490 6455642 6455850 6456078 6456116 6456371 6456562 6456609 6456873 6457000 6457004 6457324 6457333 6457540 6460679 6460722 6461001 6461135 6461798 6461849 6462669 6462957 6463231 6463281 6463282 6463283 6463284 6463285 6463286 6463287 6463288 6463289 6463290 6463291 6463292 6463293 6463294 6463295 6463296 6463297 6463298 6463299 6463300 6463301 6463447 6463453 6463458 6463580 6464466 6464520 6464761 6464768 6464903 6466515 6466587 6467363 6467930 6467931 6467932 6467933 6467934 6467935 6467936 6467937 6467938 6467939 6467940 6467941 6467942 6467943 6467944 6467945 6467946 6467947 6467948 6467949 6467950 6467951 6468194 6468884 6468987 6469289 6470110 6470894 6471050 6471080 6471323 6471354 6471364 6471371 6471377 6471378 6471386 6471396 6471401 6471434 6471437 6471441 6471445 6471449 6471632 6471633 6471634 6471635 6471636 6471637 6471638 6471639 6471640 6471641 6471642 6471643 6471644 6471645 6471646 6471647 6471648 6471649 6471650 6471651 6471652 6471653 6471654 6471655 6471656 6471657 6471658 6471659 6471660 6471661 6471662 6471663 6471664 6471665 6471666 6471667 6471668 6471669 6471670 6471671 6471672 6471673 6471674 6471675 6471676 6471677 6471678 6471679 6471680 6471681 6471682 6471688 6471689 6471690 6471691 6471692 6471693 6471694 6471695 6471696 6471697 6471698 6471699 6471700 6471701 6471702 6471703 6471704 6471705 6471706 6471707 6471708 6471709 6471710 6471711 6471712 6471713 6471714 6471715 6471716 6471717 6471718 6471724 6471725 6471726 6471727 6471728 6471729 6471730 6471731 6471732 6471733 6471734 6471735 6471737 6471738 6471739 6471740 6471741 6471742 6471744 6471745 6471746 6471747 6471752 6471753 6471754 6471755 6471756 6471757 6471759 6471760 6471761 6471762 6471763 6471764 6471765 6471766 6471767 6471773 6471774 6471777 6471778 6471779 6471780 6471782 6471783 6471784 6471785 6471786 6471787 6471788 6471789 6471790 6471791 6471792 6471848 6471849 6471850 6471852 6471853 6471854 6471855 6471856 6472254 6472370 6472904 6472998 6473184 6473185 6473277 6473310 6475247 6475677 6475679 6475747 6475788 6475863 6475864 6475865 6475866 6475867 6475868 6475869 6475870 6475871 6475872 6477044 6480391 6480820 6480929 6481293 6481891 6482522 6482941 6482984 6483048 6483497 6483786 6483862 6484035 6484365 6484367 6484368 6484369 6484370 6484372 6484373 6484374 6484375 6484388 6484389 6484390 6484391 6484392 6484393 6484394 6484395 6484396 6484397 6484398 6484399 6484400 6485265 6485306 6486444 6486531 6486720 6488433 6488435 6490781 6491016 6491111 6491469 6491549 6492837 6495231 6495234 6495740 6495961 6496180 6496404 6497196 6497280 6497778 6497911 6498149 6498263 6498482 6498563 6498624 6499130 6499131 6499313 6499333 6499354 6499670 6500515 6500583 6501494 6501505 6501837 6501891 6501969 6501978 6501982 6501985 6501990 6502429 6502594 6502690 6503240 6503595 6503742 6503743 6503942 6504006 6504194 6504248 6504254 6504255 6505220 6505429 6505468 6505530 6505637 6505638 6505639 6505640 6505641 6505642 6505646 6505647 6505648 6505649 6505650 6505651 6505865 6506086 6506103 6506134 6506336 6506442 6507154 6509046 6509170 6510162 6510181 6510452 6512340 6517273 6517283 6517661 6517662 6517663 6517664 6517665 6517666 6517667 6517668 6517669 6517670 6517671 6517672 6517673 6517674 6517675 6517676 6517677 6517678 6517679 6517680 6517681 6517682 6517683 6517684 6518116 6518645 6519276 6519517 6519520 6519549 6519550 6519551 6519552 6519553 6519554 6519558 6519559 6519560 6519561 6519562 6519563 6519566 6519567 6519568 6519569 6519570 6519571 6519572 6519573 6519574 6519575 6519576 6519577 6519578 6519579 6519580 6519581 6519582 6519583 6519584 6519586 6519587 6519588 6519589 6519590 6519591 6519592 6519593 6519594 6519595 6519596 6519597 6519598 6519599 6519600 6519601 6519602 6519603 6519604 6519605 6519606 6519607 6519608 6519609 6519610 6519611 6519612 6519613 6519614 6519615 6519616 6519617 6519619 6519620 6519621 6519622 6519623 6519624 6519625 6519626 6519627 6519630 6519631 6519632 6519633 6519634 6519636 6519637 6519638 6519639 6519640 6519641 6519642 6519643 6519644 6519645 6519647 6519648 6519649 6519650 6519651 6519652 6519653 6519654 6519657 6519658 6519659 6519660 6519661 6519662 6519663 6519664 6519665 6519666 6519669 6519670 6519671 6519672 6519673 6519674 6519675 6519676 6519677 6519678 6519679 6519680 6519681 6519682 6519683 6519684 6519685 6519686 6519687 6519688 6519689 6519690 6519691 6519692 6519693 6519694 6519695 6519696 6519697 6519698 6519699 6519700 6519701 6519702 6519703 6519704 6519705 6519706 6519707 6519708 6519709 6519710 6519711 6519712 6519713 6519714 6519715 6519716 6519717 6519718 6519719 6519720 6519721 6519943 6519982 6519984 6520213 6520219 6520234 6520238 6520247 6520250 6520894 6520920 6521306 6521959 6524266 6524322 6524405 6524634 6525106 6525350 6525354 6525369 6525380 6525806 6525840 6525998 6526905 6526906 6526912 6527099 6527104 6527116 6527397 6527569 6527716 6527729 6527734 6527903 6528205 6528364 6528494 6528862 6529056 6529149 6529258 6529842 6530104 6530218 6530279 6530591 6530790 6530792 6530793 6530858 6531050 6531052 6531055 6531057 6531230 6531328 6531397 6531398 6531400 6531401 6531402 6531403 6531404 6531405 6531406 6531407 6531408 6531409 6531410 6531411 6531412 6531413 6531414 6531415 6531416 6531417 6531418 6531419 6531420 6531421 6531422 6531423 6531424 6531425 6531426 6531427 6531428 6531429 6531430 6531431 6531432 6531433 6531434 6531435 6531436 6531437 6531438 6531439 6531440 6531441 6531442 6531443 6531444 6531445 6531446 6531447 6531448 6531449 6531450 6531451 6531452 6531453 6531454 6531455 6531456 6531457 6531458 6531459 6531460 6531461 6531462 6531463 6531464 6531465 6531466 6531467 6531468 6531469 6531470 6531471 6531472 6531473 6531474 6531475 6531476 6531477 6531478 6531479 6531480 6531481 6531482 6531483 6531484 6531485 6531486 6531487 6531488 6531489 6531490 6531491 6531492 6531493 6531494 6531495 6531496 6531497 6531498 6531499 6531500 6531501 6531502 6531503 6531504 6531505 6531506 6531507 6531508 6531509 6531510 6531511 6531512 6531513 6531514 6531515 6531516 6531517 6531518 6531519 6531520 6531521 6531522 6531523 6531524 6531525 6531526 6531527 6531528 6531529 6531530 6531531 6531532 6531533 6531534 6531535 6531536 6531537 6531538 6531539 6531540 6531541 6531542 6531543 6531544 6531545 6531546 6531547 6531548 6531549 6531550 6531551 6531552 6531553 6531554 6531555 6531556 6531557 6531558 6531559 6531560 6533148 6533592 6534828 6535076 6536002 6536125 6537096 6538662 6538667 6538669 6538670 6538675 6538676 6538681 6538682 6538685 6538686 6538687 6538688 6538689 6538691 6538693 6538694 6538696 6538698 6538700 6538701 6538702 6538703 6538704 6538705 6538706 6538708 6539760 6539963 6540132 6540551 1000000950 1000001574 1000001785 1000001787 1000002930 1000002130 1000005542 1000002178 1000006499 1000007591 1000007849 1000008231 1000008497 1000008498 1000008848 1000008866 1000004822 1000008493 1000009243 1000009409 1000009811 1000002705 1000001862 1000010191 1000010207 1000010837 1000010932 1000010896 1000010980 1000010515 1000011901 1000010733 1000010597 1000010193 1000011902 1000013031 1000009398 1000013132 1000013164 1000013426 1000010572 1000005460 1000014417 1000008591 1000014629 1000013648 1000010158 1000004601 1000013193 1000016762 1000016869 1000017051 1000012570 1000017173 1000017219 1000001816 1000017131 1000018055 1000018056 1000018085 1000018086 1000018087 1000018096 1000018107 1000017120 1000018424 1000011989 1000015456 1000019389 1000019391 1000019396 1000012624 1000012578 1000011980 1000017186 1000017136 1000015124 1000016076 1000013979 1000015501 1000014859 1000021652 1000021654 1000016660 1000017611 1000016210 1000006074 1000007217 1000023555 1000023568 1000024048 1000024720 1000024721 1000024722 1000026457 1000026487 1000026488 1000026489 1000026491 1000026492 1000026493 1000026608 1000026613 1000026615 1000026625 1000026679 1000017174 1000026786 1000026833 1000026850 1000026851 1000026852 1000026853 1000026854 1000026855 1000026856 1000026857 1000026858 1000026859 1000026860 1000026861 1000026862 1000026863 1000026864 1000026865 1000026881 1000026884 1000027040 1000027041 1000027052 1000027169 1000027170 1000027172 1000027173 1000027421 1000027760 1000012775 1000028138 1000028568 1000028574 1000028575 1000028577 1000028578 1000028590 1000028591 1000028594 1000028762 1000028939 1000028941 1000027769 1000030395 1000030396 1000030403 1000030404 1000030406 1000030408 1000027057 1000030570 1000030571 1000030572 1000030573 1000030789 1000030790 1000030791 1000030793 1000031260 1000031261 1000031729 1000031730 1000031731 1000031732 1000031734 1000031737 1000031738 1000031740 1000031741 1000031742 1000031743 1000031744 1000031745 1000031747 1000031749 1000031751 1000031752 1000031757 1000031758 1000031760 1000031766 1000031767 1000031768 1000031770 1000031772 1000031773 1000031775 1000031777 1000031778 1000031779 1000031811 1000031874 1000031917 1000031923 1000031952 1000031955 1000031966 1000031967 1000032657 1000032659 1000032661 1000032663 1000032664 1000032670 1000032680 1000032681 1000032682 1000032685 1000032686 1000032689 1000032690 1000032692 1000032694 1000032696 1000032697 1000032699 1000032702 1000032703 1000032704 1000032705 1000032706 1000032708 1000032709 1000032711 1000032714 1000032715 1000032718 1000032723 1000032727 1000032731 1000032733 1000032734 1000032735 1000032736 1000032737 1000032760 1000033071 1000033072 1000033081 1000033092 1000033093 1000033645 1000033646 1000033649 1000032774 1000027077 1000034153 1000034162 1000034164 1000030359 1000035024 1000035099 1000035101 1000035104 1000035105 1000035106 1000035107 1000035108 1000035109 1000035110 1000035111 1000035112 1000035113 1000035114 1000035115 1000035117 1000035118 1000035119 1000035120 1000035121 1000035122 1000035123 1000035124 1000035125 1000035129 1000035405 1000035785 1000025942 1000036602 1000036862 1000036863 1000036864 1000036865 1000036866 1000036867 1000036868 1000037552 1000037553 1000037570 1000037581 1000037584 1000037585 1000037589 1000038191 1000038795 1000039470 1000039471 1000039472 1000039473 1000039477 1000039478 1000039479 1000039480 1000039486 1000039491 1000039496 1000040264 1000040271 1000040274 1000040276 1000040709 1000042380 1000042484 1000041568 1000043132 1000043138 1000043139 1000043162 1000043163 1000043165 1000043166 1000043167 1000043168 1000043169 1000043170 1000043171 1000043172 1000043173 1000043175 1000043176 1000043177 1000043178 1000043179 1000043180 1000043181 1000043182 1000043188 1000038796 1000039108 1000003963 1000046249 1000046250 1000041235 1000046834 1000046839 1000046840 1000014614 1000047168 1000047171 1000047172 1000047174 1000047175 1000047176 1000047191 1000047194 1000047547 1000048294 1000047196 1000022457 1000019114 1000048539 1000019184 1000048947 1000049340 1000050349 1000050542 1000050698 1000050828 1000051053 1000051432 1000051590 1000051701 1000014080 1000051889 1000050350 1000036683 1000028942 1000048930 1000048167 1000052373 1000053048 1000053165 1000052364 1000052791 1000051515 1000049026 1000053970 1000053971 1000050981 1000054524 1000046872 1000055072 1000054596 1000055327 1000055571 1000055639 1000056446 1000056708 1000030125 1000054560 1000054989 1000053346 1000058099 1000058100 1000058101 1000058134 1000058135 1000058603 1000056484 1000059800 1000060245 1000060286 1000060287 1000061546 1000061568 1000062134 1000062517 1000062702 1000062800 1000064465 1000064701 1000064950 1000065770 1000063645 1000061621 28696] 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 (6377112, 6382895, 6382908, 6386715, 6387783, 6388575, 6388957, 6368973, 6391382, 6391458, 6391459, 6391460, 6391673, 6392189, 6392298, 6392616, 6384712, 6390865, 6393405, 6393609, 6393687, 6392714, 6394022, 6394397, 6395896, 6396550, 6396683, 6397478, 6398170, 6398915, 6399160, 6400132, 6400742, 6400802, 6402794, 6403129, 6404002, 6404991, 6404992, 6405408, 6408783, 6408895, 6409981, 6409982, 6409983, 6409984, 6409985, 6409986, 6409987, 6409988, 6410627, 6410961, 6411290, 6411334, 6411339, 6411346, 6411822, 6412087, 6412095, 6412157, 6412162, 6412823, 6412922, 6412931, 6412973, 6413505, 6414266, 6414269, 6414606, 6415009, 6415647, 6416114, 6416116, 6416257, 6416781, 6416860, 6417089, 6417931, 6418318, 6418942, 6418972, 6419151, 6419282, 6419994, 6420228, 6420625, 6420749, 6421050, 6421288, 6421337, 6421673, 6421730, 6421753, 6422187, 6422804, 6423558, 6423559, 6423561, 6423562, 6423563, 6423564, 6423565, 6423566, 6423567, 6423727, 6424052, 6424790, 6425095, 6425115, 6425383, 6426250, 6426279, 6426625, 6426683, 6426704, 6426761, 6426927, 6426961, 6426980, 6427644, 6427994, 6428247, 6428557, 6429135, 6429577, 6429578, 6429631, 6430880, 6408052, 6431782, 6431869, 6432154, 6432334, 6433471, 6434384, 6434404, 6434622, 6434765, 6435318, 6435320, 6435328, 6435329, 6435333, 6435336, 6435337, 6435353, 6435355, 6435401, 6435466, 6436309, 6436315, 6436512, 6436513, 6436516, 6436517, 6436518, 6436519, 6436520, 6436521, 6436522, 6436523, 6436524, 6436525, 6436526, 6436527, 6436529, 6436650, 6436654, 6436655, 6436656, 6436657, 6436658, 6436659, 6436660, 6436661, 6436662, 6436663, 6436664, 6436665, 6436666, 6436667, 6436668, 6436669, 6436670, 6436671, 6436672, 6436673, 6436674, 6436675, 6436676, 6436677, 6436678, 6436679, 6436680, 6436681, 6436682, 6436683, 6436684, 6436685, 6436686, 6436687, 6436688, 6436689, 6436690, 6436691, 6436692, 6436693, 6436694, 6436695, 6436696, 6436697, 6436698, 6436699, 6436700, 6436701, 6436702, 6436703, 6436704, 6436705, 6436706, 6436708, 6436709, 6437502, 6437504, 6437507, 6437509, 6437511, 6437512, 6437513, 6437514, 6437515, 6437516, 6437517, 6437518, 6437519, 6437520, 6437521, 6437522, 6437523, 6437524, 6437525, 6437527, 6437528, 6437529, 6437530, 6437531, 6437532, 6437533, 6437534, 6437535, 6437536, 6437537, 6437538, 6437539, 6437540, 6437541, 6437542, 6437543, 6437544, 6437545, 6437546, 6437547, 6437548, 6437549, 6437550, 6437551, 6437552, 6437553, 6437554, 6437556, 6437557, 6437558, 6437559, 6437560, 6437561, 6437562, 6437563, 6437564, 6437567, 6437568, 6437569, 6437570, 6437571, 6437572, 6437573, 6437574, 6437575, 6437576, 6437577, 6437578, 6437579, 6437580, 6437626, 6437629, 6437649, 6437654, 6437894, 6437988, 6438026, 6438631, 6439266, 6439548, 6439827, 6439838, 6439845, 6439865, 6439946, 6439962, 6439975, 6440089, 6440289, 6440558, 6441024, 6441579, 6441581, 6442136, 6442151, 6442165, 6442255, 6442571, 6442776, 6442808, 6442883, 6442969, 6442985, 6443397, 6443733, 6443924, 6443927, 6443962, 6443965, 6444251, 6445422, 6445620, 6445621, 6445981, 6446535, 6446773, 6446959, 6447705, 6448224, 6448227, 6448237, 6448240, 6449642, 6450383, 6450424, 6450505, 6451011, 6451150, 6451191, 6451195, 6451213, 6451220, 6451239, 6451298, 6451349, 6452101, 6452108, 6452193, 6452418, 6452427, 6452520, 6452584, 6453154, 6453477, 6453551, 6453568, 6454112, 6454586, 6454657, 6454677, 6454690, 6454711, 6454783, 6454865, 6454926, 6455149, 6455257, 6455490, 6455642, 6455850, 6456078, 6456116, 6456371, 6456562, 6456609, 6456873, 6457000, 6457004, 6457324, 6457333, 6457540, 6460679, 6460722, 6461001, 6461135, 6461798, 6461849, 6462669, 6462957, 6463231, 6463281, 6463282, 6463283, 6463284, 6463285, 6463286, 6463287, 6463288, 6463289, 6463290, 6463291, 6463292, 6463293, 6463294, 6463295, 6463296, 6463297, 6463298, 6463299, 6463300, 6463301, 6463447, 6463453, 6463458, 6463580, 6464466, 6464520, 6464761, 6464768, 6464903, 6466515, 6466587, 6467363, 6467930, 6467931, 6467932, 6467933, 6467934, 6467935, 6467936, 6467937, 6467938, 6467939, 6467940, 6467941, 6467942, 6467943, 6467944, 6467945, 6467946, 6467947, 6467948, 6467949, 6467950, 6467951, 6468194, 6468884, 6468987, 6469289, 6470110, 6470894, 6471050, 6471080, 6471323, 6471354, 6471364, 6471371, 6471377, 6471378, 6471386, 6471396, 6471401, 6471434, 6471437, 6471441, 6471445, 6471449, 6471632, 6471633, 6471634, 6471635, 6471636, 6471637, 6471638, 6471639, 6471640, 6471641, 6471642, 6471643, 6471644, 6471645, 6471646, 6471647, 6471648, 6471649, 6471650, 6471651, 6471652, 6471653, 6471654, 6471655, 6471656, 6471657, 6471658, 6471659, 6471660, 6471661, 6471662, 6471663, 6471664, 6471665, 6471666, 6471667, 6471668, 6471669, 6471670, 6471671, 6471672, 6471673, 6471674, 6471675, 6471676, 6471677, 6471678, 6471679, 6471680, 6471681, 6471682, 6471688, 6471689, 6471690, 6471691, 6471692, 6471693, 6471694, 6471695, 6471696, 6471697, 6471698, 6471699, 6471700, 6471701, 6471702, 6471703, 6471704, 6471705, 6471706, 6471707, 6471708, 6471709, 6471710, 6471711, 6471712, 6471713, 6471714, 6471715, 6471716, 6471717, 6471718, 6471724, 6471725, 6471726, 6471727, 6471728, 6471729, 6471730, 6471731, 6471732, 6471733, 6471734, 6471735, 6471737, 6471738, 6471739, 6471740, 6471741, 6471742, 6471744, 6471745, 6471746, 6471747, 6471752, 6471753, 6471754, 6471755, 6471756, 6471757, 6471759, 6471760, 6471761, 6471762, 6471763, 6471764, 6471765, 6471766, 6471767, 6471773, 6471774, 6471777, 6471778, 6471779, 6471780, 6471782, 6471783, 6471784, 6471785, 6471786, 6471787, 6471788, 6471789, 6471790, 6471791, 6471792, 6471848, 6471849, 6471850, 6471852, 6471853, 6471854, 6471855, 6471856, 6472254, 6472370, 6472904, 6472998, 6473184, 6473185, 6473277, 6473310, 6475247, 6475677, 6475679, 6475747, 6475788, 6475863, 6475864, 6475865, 6475866, 6475867, 6475868, 6475869, 6475870, 6475871, 6475872, 6477044, 6480391, 6480820, 6480929, 6481293, 6481891, 6482522, 6482941, 6482984, 6483048, 6483497, 6483786, 6483862, 6484035, 6484365, 6484367, 6484368, 6484369, 6484370, 6484372, 6484373, 6484374, 6484375, 6484388, 6484389, 6484390, 6484391, 6484392, 6484393, 6484394, 6484395, 6484396, 6484397, 6484398, 6484399, 6484400, 6485265, 6485306, 6486444, 6486531, 6486720, 6488433, 6488435, 6490781, 6491016, 6491111, 6491469, 6491549, 6492837, 6495231, 6495234, 6495740, 6495961, 6496180, 6496404, 6497196, 6497280, 6497778, 6497911, 6498149, 6498263, 6498482, 6498563, 6498624, 6499130, 6499131, 6499313, 6499333, 6499354, 6499670, 6500515, 6500583, 6501494, 6501505, 6501837, 6501891, 6501969, 6501978, 6501982, 6501985, 6501990, 6502429, 6502594, 6502690, 6503240, 6503595, 6503742, 6503743, 6503942, 6504006, 6504194, 6504248, 6504254, 6504255, 6505220, 6505429, 6505468, 6505530, 6505637, 6505638, 6505639, 6505640, 6505641, 6505642, 6505646, 6505647, 6505648, 6505649, 6505650, 6505651, 6505865, 6506086, 6506103, 6506134, 6506336, 6506442, 6507154, 6509046, 6509170, 6510162, 6510181, 6510452, 6512340, 6517273, 6517283, 6517661, 6517662, 6517663, 6517664, 6517665, 6517666, 6517667, 6517668, 6517669, 6517670, 6517671, 6517672, 6517673, 6517674, 6517675, 6517676, 6517677, 6517678, 6517679, 6517680, 6517681, 6517682, 6517683, 6517684, 6518116, 6518645, 6519276, 6519517, 6519520, 6519549, 6519550, 6519551, 6519552, 6519553, 6519554, 6519558, 6519559, 6519560, 6519561, 6519562, 6519563, 6519566, 6519567, 6519568, 6519569, 6519570, 6519571, 6519572, 6519573, 6519574, 6519575, 6519576, 6519577, 6519578, 6519579, 6519580, 6519581, 6519582, 6519583, 6519584, 6519586, 6519587, 6519588, 6519589, 6519590, 6519591, 6519592, 6519593, 6519594, 6519595, 6519596, 6519597, 6519598, 6519599, 6519600, 6519601, 6519602, 6519603, 6519604, 6519605, 6519606, 6519607, 6519608, 6519609, 6519610, 6519611, 6519612, 6519613, 6519614, 6519615, 6519616, 6519617, 6519619, 6519620, 6519621, 6519622, 6519623, 6519624, 6519625, 6519626, 6519627, 6519630, 6519631, 6519632, 6519633, 6519634, 6519636, 6519637, 6519638, 6519639, 6519640, 6519641, 6519642, 6519643, 6519644, 6519645, 6519647, 6519648, 6519649, 6519650, 6519651, 6519652, 6519653, 6519654, 6519657, 6519658, 6519659, 6519660, 6519661, 6519662, 6519663, 6519664, 6519665, 6519666, 6519669, 6519670, 6519671, 6519672, 6519673, 6519674, 6519675, 6519676, 6519677, 6519678, 6519679, 6519680, 6519681, 6519682, 6519683, 6519684, 6519685, 6519686, 6519687, 6519688, 6519689, 6519690, 6519691, 6519692, 6519693, 6519694, 6519695, 6519696, 6519697, 6519698, 6519699, 6519700, 6519701, 6519702, 6519703, 6519704, 6519705, 6519706, 6519707, 6519708, 6519709, 6519710, 6519711, 6519712, 6519713, 6519714, 6519715, 6519716, 6519717, 6519718, 6519719, 6519720, 6519721, 6519943, 6519982, 6519984, 6520213, 6520219, 6520234, 6520238, 6520247, 6520250, 6520894, 6520920, 6521306, 6521959, 6524266, 6524322, 6524405, 6524634, 6525106, 6525350, 6525354, 6525369, 6525380, 6525806, 6525840, 6525998, 6526905, 6526906, 6526912, 6527099, 6527104, 6527116, 6527397, 6527569, 6527716, 6527729, 6527734, 6527903, 6528205, 6528364, 6528494, 6528862, 6529056, 6529149, 6529258, 6529842, 6530104, 6530218, 6530279, 6530591, 6530790, 6530792, 6530793, 6530858, 6531050, 6531052, 6531055, 6531057, 6531230, 6531328, 6531397, 6531398, 6531400, 6531401, 6531402, 6531403, 6531404, 6531405, 6531406, 6531407, 6531408, 6531409, 6531410, 6531411, 6531412, 6531413, 6531414, 6531415, 6531416, 6531417, 6531418, 6531419, 6531420, 6531421, 6531422, 6531423, 6531424, 6531425, 6531426, 6531427, 6531428, 6531429, 6531430, 6531431, 6531432, 6531433, 6531434, 6531435, 6531436, 6531437, 6531438, 6531439, 6531440, 6531441, 6531442, 6531443, 6531444, 6531445, 6531446, 6531447, 6531448, 6531449, 6531450, 6531451, 6531452, 6531453, 6531454, 6531455, 6531456, 6531457, 6531458, 6531459, 6531460, 6531461, 6531462, 6531463, 6531464, 6531465, 6531466, 6531467, 6531468, 6531469, 6531470, 6531471, 6531472, 6531473, 6531474, 6531475, 6531476, 6531477, 6531478, 6531479, 6531480, 6531481, 6531482, 6531483, 6531484, 6531485, 6531486, 6531487, 6531488, 6531489, 6531490, 6531491, 6531492, 6531493, 6531494, 6531495, 6531496, 6531497, 6531498, 6531499, 6531500, 6531501, 6531502, 6531503, 6531504, 6531505, 6531506, 6531507, 6531508, 6531509, 6531510, 6531511, 6531512, 6531513, 6531514, 6531515, 6531516, 6531517, 6531518, 6531519, 6531520, 6531521, 6531522, 6531523, 6531524, 6531525, 6531526, 6531527, 6531528, 6531529, 6531530, 6531531, 6531532, 6531533, 6531534, 6531535, 6531536, 6531537, 6531538, 6531539, 6531540, 6531541, 6531542, 6531543, 6531544, 6531545, 6531546, 6531547, 6531548, 6531549, 6531550, 6531551, 6531552, 6531553, 6531554, 6531555, 6531556, 6531557, 6531558, 6531559, 6531560, 6533148, 6533592, 6534828, 6535076, 6536002, 6536125, 6537096, 6538662, 6538667, 6538669, 6538670, 6538675, 6538676, 6538681, 6538682, 6538685, 6538686, 6538687, 6538688, 6538689, 6538691, 6538693, 6538694, 6538696, 6538698, 6538700, 6538701, 6538702, 6538703, 6538704, 6538705, 6538706, 6538708, 6539760, 6539963, 6540132, 6540551, 1000000950, 1000001574, 1000001785, 1000001787, 1000002930, 1000002130, 1000005542, 1000002178, 1000006499, 1000007591, 1000007849, 1000008231, 1000008497, 1000008498, 1000008848, 1000008866, 1000004822, 1000008493, 1000009243, 1000009409, 1000009811, 1000002705, 1000001862, 1000010191, 1000010207, 1000010837, 1000010932, 1000010896, 1000010980, 1000010515, 1000011901, 1000010733, 1000010597, 1000010193, 1000011902, 1000013031, 1000009398, 1000013132, 1000013164, 1000013426, 1000010572, 1000005460, 1000014417, 1000008591, 1000014629, 1000013648, 1000010158, 1000004601, 1000013193, 1000016762, 1000016869, 1000017051, 1000012570, 1000017173, 1000017219, 1000001816, 1000017131, 1000018055, 1000018056, 1000018085, 1000018086, 1000018087, 1000018096, 1000018107, 1000017120, 1000018424, 1000011989, 1000015456, 1000019389, 1000019391, 1000019396, 1000012624, 1000012578, 1000011980, 1000017186, 1000017136, 1000015124, 1000016076, 1000013979, 1000015501, 1000014859, 1000021652, 1000021654, 1000016660, 1000017611, 1000016210, 1000006074, 1000007217, 1000023555, 1000023568, 1000024048, 1000024720, 1000024721, 1000024722, 1000026457, 1000026487, 1000026488, 1000026489, 1000026491, 1000026492, 1000026493, 1000026608, 1000026613, 1000026615, 1000026625, 1000026679, 1000017174, 1000026786, 1000026833, 1000026850, 1000026851, 1000026852, 1000026853, 1000026854, 1000026855, 1000026856, 1000026857, 1000026858, 1000026859, 1000026860, 1000026861, 1000026862, 1000026863, 1000026864, 1000026865, 1000026881, 1000026884, 1000027040, 1000027041, 1000027052, 1000027169, 1000027170, 1000027172, 1000027173, 1000027421, 1000027760, 1000012775, 1000028138, 1000028568, 1000028574, 1000028575, 1000028577, 1000028578, 1000028590, 1000028591, 1000028594, 1000028762, 1000028939, 1000028941, 1000027769, 1000030395, 1000030396, 1000030403, 1000030404, 1000030406, 1000030408, 1000027057, 1000030570, 1000030571, 1000030572, 1000030573, 1000030789, 1000030790, 1000030791, 1000030793, 1000031260, 1000031261, 1000031729, 1000031730, 1000031731, 1000031732, 1000031734, 1000031737, 1000031738, 1000031740, 1000031741, 1000031742, 1000031743, 1000031744, 1000031745, 1000031747, 1000031749, 1000031751, 1000031752, 1000031757, 1000031758, 1000031760, 1000031766, 1000031767, 1000031768, 1000031770, 1000031772, 1000031773, 1000031775, 1000031777, 1000031778, 1000031779, 1000031811, 1000031874, 1000031917, 1000031923, 1000031952, 1000031955, 1000031966, 1000031967, 1000032657, 1000032659, 1000032661, 1000032663, 1000032664, 1000032670, 1000032680, 1000032681, 1000032682, 1000032685, 1000032686, 1000032689, 1000032690, 1000032692, 1000032694, 1000032696, 1000032697, 1000032699, 1000032702, 1000032703, 1000032704, 1000032705, 1000032706, 1000032708, 1000032709, 1000032711, 1000032714, 1000032715, 1000032718, 1000032723, 1000032727, 1000032731, 1000032733, 1000032734, 1000032735, 1000032736, 1000032737, 1000032760, 1000033071, 1000033072, 1000033081, 1000033092, 1000033093, 1000033645, 1000033646, 1000033649, 1000032774, 1000027077, 1000034153, 1000034162, 1000034164, 1000030359, 1000035024, 1000035099, 1000035101, 1000035104, 1000035105, 1000035106, 1000035107, 1000035108, 1000035109, 1000035110, 1000035111, 1000035112, 1000035113, 1000035114, 1000035115, 1000035117, 1000035118, 1000035119, 1000035120, 1000035121, 1000035122, 1000035123, 1000035124, 1000035125, 1000035129, 1000035405, 1000035785, 1000025942, 1000036602, 1000036862, 1000036863, 1000036864, 1000036865, 1000036866, 1000036867, 1000036868, 1000037552, 1000037553, 1000037570, 1000037581, 1000037584, 1000037585, 1000037589, 1000038191, 1000038795, 1000039470, 1000039471, 1000039472, 1000039473, 1000039477, 1000039478, 1000039479, 1000039480, 1000039486, 1000039491, 1000039496, 1000040264, 1000040271, 1000040274, 1000040276, 1000040709, 1000042380, 1000042484, 1000041568, 1000043132, 1000043138, 1000043139, 1000043162, 1000043163, 1000043165, 1000043166, 1000043167, 1000043168, 1000043169, 1000043170, 1000043171, 1000043172, 1000043173, 1000043175, 1000043176, 1000043177, 1000043178, 1000043179, 1000043180, 1000043181, 1000043182, 1000043188, 1000038796, 1000039108, 1000003963, 1000046249, 1000046250, 1000041235, 1000046834, 1000046839, 1000046840, 1000014614, 1000047168, 1000047171, 1000047172, 1000047174, 1000047175, 1000047176, 1000047191, 1000047194, 1000047547, 1000048294, 1000047196, 1000022457, 1000019114, 1000048539, 1000019184, 1000048947, 1000049340, 1000050349, 1000050542, 1000050698, 1000050828, 1000051053, 1000051432, 1000051590, 1000051701, 1000014080, 1000051889, 1000050350, 1000036683, 1000028942, 1000048930, 1000048167, 1000052373, 1000053048, 1000053165, 1000052364, 1000052791, 1000051515, 1000049026, 1000053970, 1000053971, 1000050981, 1000054524, 1000046872, 1000055072, 1000054596, 1000055327, 1000055571, 1000055639, 1000056446, 1000056708, 1000030125, 1000054560, 1000054989, 1000053346, 1000058099, 1000058100, 1000058101, 1000058134, 1000058135, 1000058603, 1000056484, 1000059800, 1000060245, 1000060286, 1000060287, 1000061546, 1000061568, 1000062134, 1000062517, 1000062702, 1000062800, 1000064465, 1000064701, 1000064950, 1000065770, 1000063645, 1000061621) AND p0_.id <> 28696 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;
165.66 ms (7.52%)	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: [`"48658-protege-documents-et-press-book-bleu-n-c-806251"`] 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 = '48658-protege-documents-et-press-book-bleu-n-c-806251' AND p0_.is_active = 1;
4.09 ms (0.19%)	20	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;
3.94 ms (0.18%)	12	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" 28696`] 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 = 28696 LIMIT 1;
3.84 ms (0.17%)	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: [`28696`] 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 = 28696;
3.29 ms (0.15%)	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.28 ms (0.15%)	6	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: [`28696 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 = 28696 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;
2.57 ms (0.12%)	4	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: [`28696 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 = 28696 AND t0.characteristic_label_id = 7 LIMIT 1;
2.56 ms (0.12%)	12	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;
2.17 ms (0.10%)	6	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: [`28696`] 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 = 28696 AND d0_.market_id IS NULL AND d0_.product_price_id IS NULL AND d0_.promotion_id IS NULL ORDER BY d0_.quantity DESC;
1.93 ms (0.09%)	13	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.78 ms (0.08%)	6	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: [`28696 "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 = 28696 AND t0.price_id = 'C' LIMIT 1;
1.44 ms (0.07%)	6	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 17:05:13" "%2%" 28696`] 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 17:05:13' AND o1_.is_active = 1 AND o1_.view_by LIKE '%2%' AND p0_.product_id = 28696;
1.01 ms (0.05%)	3	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: [`28696 9961060`] 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 = 28696 AND p2_.id = 9961060 GROUP BY d0_.quantity ORDER BY d0_.quantity ASC;
0.99 ms (0.05%)	3	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 = ? GROUP BY d0_.quantity ORDER BY d0_.quantity ASC Parameters: [`166931`] 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 = ? 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 = 166931 GROUP BY d0_.quantity ORDER BY d0_.quantity ASC;
0.95 ms (0.04%)	5	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: [`5483`] 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 = 5483;
0.68 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: [`52 245 246 247 248 247 28696`] 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 (52, 245, 246, 247, 248, 247) AND p0_.is_active = 1 AND p0_.id <> 28696 AND p0_.is_btoc = 1 AND p0_.is_orapi_grand_frais <> 1 LIMIT 10;
0.58 ms (0.03%)	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: [`"48658-protege-documents-et-press-book-bleu-n-c-806251"`] 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 = '48658-protege-documents-et-press-book-bleu-n-c-806251' LIMIT 1;
0.44 ms (0.02%)	2	SELECT t0.id AS id_1, t0.promotion_id AS promotion_id_2, t0.society_id AS society_id_3 FROM society_promotion t0 WHERE t0.promotion_id = ? Parameters: [`201175`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.promotion_id AS promotion_id_2, t0.society_id AS society_id_3 FROM society_promotion t0 WHERE t0.promotion_id = ? SELECT t0.id AS id_1, t0.promotion_id AS promotion_id_2, t0.society_id AS society_id_3 FROM society_promotion t0 WHERE t0.promotion_id = 201175;
0.43 ms (0.02%)	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: [`28696 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 = 28696 AND c1_.is_display_site = 1;
0.42 ms (0.02%)	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.02%)	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: [`"48658-protege-documents-et-press-book-bleu-n-c-806251"`] 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 = '48658-protege-documents-et-press-book-bleu-n-c-806251';
0.25 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: [`28696`] 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 = 28696;
0.18 ms (0.01%)	1	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_.promotion_id = ? ORDER BY d0_.quantity DESC Parameters: [`201175`] 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_.promotion_id = ? 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_.promotion_id = 201175 ORDER BY d0_.quantity DESC;

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	1649
App\Entity\Catalog\ProductCatalog	232
App\Entity\Catalog\CustomerCatalog	232
App\Entity\Customer\Customer	218
App\Entity\Delivery\Delivery	172
App\Entity\User\User	168
App\Entity\Product\Market	66
App\Entity\Pricing\Price	55
App\Entity\Product\ProductPrice	54
App\Entity\Internal\Commercial	47
App\Entity\Product\Product	21
App\Entity\Product\Category	21
App\Entity\Product\Characteristic	16
App\Entity\Internal\Society	16
App\Entity\Product\CharacteristicLabel	15
App\Entity\Pricing\SocietyPromotion	11
App\Entity\Delivery\DeliveryCost	5
App\Entity\Internal\Parameter	3
App\Entity\Pricing\Promotion	1

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.
App\Entity\Pricing\SocietyPromotion	No errors.

Symfony Profiler

GET https://staging.pgdis.com/produit/48658-protege-documents-et-press-book-bleu-n-c-806251

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping