Symfony Profiler

Query Metrics

64 Database Queries

21 Different statements

2666.68 ms Query time

0 Invalid entities

Grouped Statements

Time▼	Count	Info
1370.24 ms (51.38%)	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: [`87248 "2025-02-12 07:37:00"`] 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 = 87248 AND c0_.created_at >= '2025-02-12 07:37:00';
1088.66 ms (40.82%)	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: [6338441 6343834 6349830 6343601 6353970 6356282 6356454 6356733 6356771 6356859 6357324 6357536 6357775 6357795 6357942 6357991 6358042 6358108 6358169 6358165 6358230 6358766 6359441 6357254 6360157 6360160 6360164 6361653 6363926 6364027 6364511 6364728 6365076 6365861 6369317 6369421 6369602 6369948 6370510 6370550 6370575 6371312 6372032 6372178 6372445 6373176 6373330 6373401 6373563 6375785 6376425 6380618 6382566 6383059 6383521 6385235 6366688 6386759 6387230 6388025 6388490 6386579 6388939 6389019 6389049 6389069 6389703 6390280 6390325 6385855 6390472 6390679 6390736 6387472 6391293 6389084 6391500 6391913 6392049 6392109 6392157 6392181 6392365 6392471 6392161 6392534 6392835 6393236 6393640 6393655 6393699 6393804 6393837 6394022 6394225 6393601 6389080 6394465 6394466 6394624 6391516 6395401 6396362 6397417 6400509 6400515 6400516 6400742 6400826 6400934 6401487 6401686 6402565 6402664 6403115 6403135 6403845 6404008 6404305 6404348 6404608 6404703 6405128 6405342 6405700 6406124 6406510 6407146 6407421 6407772 6408247 6408623 6408633 6408830 6408895 6409195 6409305 6409608 6409704 6410080 6410416 6410429 6410672 6410673 6410711 6410718 6410867 6410934 6411233 6411868 6412328 6412714 6412717 6412724 6412746 6412885 6412960 6413281 6413300 6413589 6413852 6413879 6413887 6414081 6414183 6414240 6414251 6414252 6414256 6414257 6414284 6414384 6414683 6414730 6414739 6414761 6414927 6414950 6414965 6415012 6415030 6415046 6415122 6415125 6415154 6415164 6415199 6415390 6415394 6415454 6415462 6415484 6415509 6415969 6416027 6416036 6416116 6416118 6416122 6416292 6416312 6416325 6416436 6416476 6416776 6416804 6416829 6416849 6416979 6417024 6417083 6417110 6417118 6417225 6417280 6417576 6417655 6418002 6418007 6418171 6418380 6418536 6418815 6418893 6418942 6418981 6419024 6419144 6419235 6419239 6419241 6419284 6419307 6419321 6419353 6419362 6419371 6419403 6419442 6419570 6419571 6419880 6419883 6419888 6420428 6420647 6420721 6420781 6420822 6420854 6421234 6421416 6421479 6421666 6421746 6421762 6421782 6421843 6421909 6421938 6421941 6422027 6422049 6422178 6422243 6422351 6422380 6422435 6422729 6422808 6422878 6422922 6423164 6423770 6423983 6424018 6424033 6424114 1000013586 6424661 6424815 6424844 6424983 6425083 6425090 6425344 6425436 6425443 6425565 6425756 6426116 6426172 6426174 6426324 6426338 6426388 6426542 6426551 6426608 6426611 6426685 6426812 6426925 6427094 6427269 6427274 6427285 6427385 6427693 6427951 6428170 6428408 6428430 6428494 6428508 6428875 6428914 6428974 6429041 6429169 6429261 6429486 6429631 6429787 6429797 6429946 6430047 6430270 6430286 6430336 6430538 6430573 6430873 6430902 6430904 6430907 6430950 6430976 6431118 6431176 6431289 6431494 6431572 6431672 6431843 6431859 6431959 6432048 6432087 6432132 6432133 6432165 6432189 6432200 6432239 6432282 6432304 6433057 6433310 6433682 6433960 6434039 6434215 6434330 6434423 6434428 6434662 6434679 6434750 6434752 6434759 6434772 6434835 6434967 6435048 6435144 6435149 6435257 6435287 6435298 6435351 6435496 6435555 6435634 6435667 6435860 6435864 6435874 6435897 6435928 6435956 6435985 6436036 6436289 6436356 6436653 6436996 6437104 6437187 6437218 6437701 6437726 6437751 6437884 6437989 6438044 6438068 6438077 6438103 6438497 6438503 6438539 6438557 6438583 6438828 6438899 6438937 6438957 6438979 6439058 6439059 6439060 6439117 6439171 6439262 6439414 6439639 6439676 6439800 6439937 6440718 6440835 6440934 6441208 6441332 6441356 6441439 6441863 6442296 6442297 6442746 6442761 6442763 6442924 6443132 6443152 6443282 6443849 6443886 6444133 6444245 6444295 6444300 6444427 6444500 6444633 6444872 6445244 6445278 6445371 6445436 6445449 6445520 6445639 6445649 6445652 6445669 6445700 6445728 6445734 6445768 6445777 6446038 6446055 6446061 6446084 6446091 6446158 6446167 6446368 6446417 6446442 6446521 6446548 6446612 6446638 6446680 6446743 6446749 6446812 6446821 6446888 6446908 6446914 6446988 6447056 6447057 6447076 6447257 6447297 6447375 6447391 6447540 6447642 6447645 6447659 6447674 6448278 6448735 6448801 6448849 6448918 6448956 6448960 6448975 6449133 6449338 6449462 6449469 6449556 6449642 6449697 6449703 6449726 6449769 6449771 6449777 6449781 6449821 6449886 6449905 6449913 6450100 6450105 6450106 6450152 6450167 6450172 6450173 6450176 6450180 6450189 6450191 6450195 6450199 6450234 6450253 6450268 6450270 6450274 6450312 6450368 6450435 6450505 6450539 6450609 6450613 6450635 6450668 6450670 6450814 6450833 6450879 6450930 6450991 6451023 6451041 6451090 6451111 6451129 6451171 6451209 6451224 6451228 6451232 6451251 6451317 6451365 6451372 6451383 6451416 6451417 6451420 6451431 6451438 6451439 6451531 6451541 6451562 6451564 6451577 6451581 6451616 6451661 6451707 6451793 6451794 6451826 6451922 6451926 6451944 6452020 6452041 6452051 6452055 6452059 6452086 6452099 6452218 6452223 6452253 6452317 6452352 6452367 6452373 6452394 6452420 6452531 6452558 6452570 6452830 6453481 6453516 6453556 6453557 6453629 6453746 6453772 6453874 6453932 6454015 6454025 6454126 6454181 6454200 6454535 6454536 6454538 6454546 6454562 6454582 6454607 6454608 6454622 6454625 6454649 6454667 6454761 6454773 6454777 6454784 6454786 6454790 6454794 6454812 6454842 6454848 6454862 6454863 6454886 6454889 6454895 6454896 6454926 6454949 6454982 6454984 6454985 6454997 6455040 6455066 6455128 6455141 6455153 6455199 6455201 6455236 6455257 6455345 6455376 6455422 6455447 6455451 6455455 6455461 6455508 6455557 6455616 6455620 6455634 6455690 6455694 6455785 6455847 6455860 6455864 6455956 6456091 6456096 6456097 6456109 6456264 6456274 6456750 6457058 6457205 6457243 6457247 6457252 6457266 6457418 6457437 6457440 6457508 6457521 6457645 6457945 6458242 6458380 6458488 6458977 6458988 6459180 6459265 6459277 6459285 6459287 6459479 6459561 6459992 6460274 6460417 6460915 6460922 6460944 6460990 6461011 6461042 6461454 6461848 6462258 6462307 6462383 6462540 6462637 6462674 6462717 6462973 6463050 6463233 6463395 6464009 6464256 6464264 6464492 6464515 6464555 6464880 6465138 6465286 6465287 6465291 6465366 6465631 6465665 6466049 6466438 6466624 6466672 6466750 6467234 6467826 6468020 6468060 6468071 6468121 6468201 6468208 6468545 6468650 6468774 6468784 6468858 6469059 6392423 1000001009 6394821 1000000950 1000001108 1000000905 1000001712 6392324 1000001938 1000001949 1000001950 1000002001 1000002039 1000001953 1000002113 1000002114 1000002399 1000002408 6387845 1000002614 1000002744 1000000976 1000002980 1000002979 1000001869 1000002674 1000004681 1000004683 1000004707 6390715 6390633 1000004350 1000004554 1000005161 1000004565 1000005538 1000004780 1000005848 1000005849 1000005942 1000006175 1000006176 6392532 6382649 6385755 1000002610 1000006566 1000006615 1000006968 1000007010 1000005820 1000005688 1000007244 1000007260 6389526 1000006199 1000007667 1000007755 1000002561 1000002180 1000008056 1000008012 1000002654 1000002495 1000008211 1000004763 1000008316 1000008317 1000008318 1000008332 1000008419 1000008704 1000001350 1000008870 1000008454 1000009009 6392778 1000009098 1000008556 1000002559 1000009528 6389029 1000009721 1000009747 1000009758 1000009918 1000009989 1000009992 1000006630 1000002059 1000009430 1000004161 1000006056 1000009436 1000010110 1000009858 1000008985 1000005033 1000010149 6385280 1000010143 1000010553 1000008089 1000005970 1000010755 1000010400 1000010743 1000010773 1000010839 1000010521 1000010912 1000011801 1000004768 1000002243 1000011883 1000010840 1000010561 1000012018 1000011880 1000008546 1000012071 1000012114 6391605 1000012154 1000012180 1000012362 1000012401 1000011993 1000012450 1000003872 1000012603 1000012620 1000012627 1000012757 1000006069 1000011946 1000013005 1000010170 1000010178 1000013215 1000010452 1000010147 1000012615 1000013558 1000013135 1000009912 1000013431 1000013208 1000010502 1000013788 1000013856 1000013959 1000012382 1000004333 1000014034 1000009260 1000007405 1000012721 1000014534 1000014505 1000004686 1000014802 1000009230 1000014828 1000014102 1000005543 1000012604 1000012647 1000012222 1000015109 1000005279 1000014283 1000009611 1000009163 1000011070 1000011076 1000015480 1000014831 1000015507 1000015509 1000014870 1000010013 1000015628 1000015788 1000015327 1000012235 1000015921 1000016193 1000016206 1000009646 1000016251 1000016410 1000016448 1000016537 1000016538 1000016539 1000016545 1000016562 1000002598 1000016672 1000014799 1000017017 1000017065 1000017148 1000016711 1000013568 1000006277 1000013221 1000017444 1000016175 1000017121 1000014076 1000017531 1000017532 1000008325 1000017547 1000017728 1000017953 1000017954 1000017955 1000017956 1000018045 1000018052 1000018053 1000018054 1000018065 1000018072 1000018073 1000018074 1000018075 1000018076 1000018077 1000018078 1000018079 1000018080 1000018081 1000018082 1000018083 1000014518 1000018172 1000018173 1000018174 1000018175 1000018205 1000012790 1000018514 1000018515 1000018518 1000018521 1000018522 1000018523 1000018524 1000018525 1000018569 1000014075 1000016412 1000016084 1000018804 1000019019 1000019020 1000019021 1000019023 1000019024 1000019025 1000019066 1000019111 1000019171 1000019174 1000019178 1000019208 1000019344 1000019371 1000017743 1000016967 1000016665 1000019438 1000019451 1000019479 1000019482 1000019665 1000019680 1000019758 1000019759 1000019822 1000019823 1000019893 1000019918 1000019922 1000019938 1000019939 1000019941 1000020061 1000020067 1000020080 1000020087 1000020121 1000020127 1000015124 1000020346 1000020348 1000020349 1000020350 1000020352 1000020353 1000020372 1000019942 1000019925 1000014829 1000017079 1000020592 1000020596 1000020595 1000019228 1000020090 1000013768 1000020779 1000020797 1000014324 1000016460 1000020947 1000019489 1000020084 1000016541 1000015501 1000015117 1000012389 1000012314 1000018772 1000017771 1000017494 1000021427 1000013129 1000021566 1000021579 1000021652 1000021654 1000021657 1000021664 1000021741 1000021761 1000021762 1000021763 1000021764 1000021766 1000021767 1000021772 1000021770 1000021774 1000021775 1000021777 1000021779 1000021781 1000021782 1000021783 1000021790 1000021791 1000021792 1000021796 1000021797 1000021798 1000021799 1000021802 1000021811 1000021818 1000021825 1000021828 1000021831 1000021864 1000021866 1000021869 1000021886 1000021891 1000021892 1000021893 1000021904 1000021909 1000021910 1000021911 1000021912 1000021925 1000017163 1000016660 1000021998 1000021999 1000022000 1000022001 1000022002 1000022003 1000022004 1000022005 1000022006 1000002545 1000002245 1000002102 1000001487 1000020497 1000022123 1000016689 1000022162 1000022185 1000012427 1000022191 1000022205 1000022255 1000022254 1000013342 1000018636 1000022665 1000022676 1000022682 1000022690 1000021928 1000016401 1000022829 1000022837 1000021466 1000023455 1000023555 1000023568 1000023630 1000023631 1000023671 1000023926 1000023940 1000020616 1000018111 1000024515 1000024516 1000024607 1000023665 1000024969 1000024970 1000024997 1000025170 1000025387 1000025450 1000025457 1000025494 1000025496 1000016387 1000025562 1000025578 1000017957 1000022794 1000025947 1000026132 1000026133 1000026135 1000026329 1000026434 1000026435 1000026436 1000026438 1000026440 1000021619 1000026187 1000026501 1000025564 1000017567 1000006969 1000023944 1000026890 1000026891 1000026892 1000026893 1000026894 1000026895 1000026899 1000022192 1000016260 1000021567 1000027883 1000027895 1000027905 1000027995 1000028060 1000028398 1000028524 1000028528 1000028550 1000028552 1000028557 1000028561 1000028593 1000028613 1000028614 1000028626 1000028643 1000028644 1000028621 1000028836 1000028838 1000028840 1000028862 1000017161 1000014104 1000016744 1000021954 1000028982 1000025524 1000029107 1000029239 1000029240 1000029243 1000029303 1000029304 1000029098 1000023431 1000029400 1000025609 1000016648 1000029714 1000029871 1000029881 1000017889 1000026665 1000015067 1000030132 6394469 1000029454 1000030247 1000030365 1000030388 1000030356 1000030467 1000030485 1000030486 1000030487 1000022840 1000030740 1000030741 1000030742 1000030745 1000030746 1000030749 1000030750 1000030753 1000030756 1000030758 1000030912 1000030913 1000030915 1000030916 1000030917 1000030918 1000030919 1000030920 1000030922 1000030924 1000030925 1000030945 1000031094 1000031095 1000031096 1000012404 1000031273 1000027977 1000012010 1000028651 1000031479 1000015990 1000002606 1000031885 1000031887 1000031928 1000031929 1000031932 1000031934 1000031936 1000031940 1000031949 1000031950 1000031951 1000031968 1000031991 1000032032 1000032035 1000032088 1000023685 1000032284 1000032324 1000032328 1000032344 1000032376 1000032492 1000032505 1000032509 1000029896 1000032516 1000028620 1000029174 1000026136 1000026624 1000032072 1000033071 1000033072 1000033081 1000033092 1000033093 1000033191 1000033193 1000033198 1000033212 1000033217 1000033218 1000033220 1000033223 1000033232 1000033239 1000033240 1000033243 1000033245 1000033264 1000033269 1000033272 1000033281 1000033314 1000033316 1000033336 1000033345 1000033353 1000033366 1000033368 1000033369 1000033384 1000033385 1000033446 1000033447 1000033449 1000033468 1000033485 1000033489 1000033491 1000032055 1000033781 1000033299 1000033870 1000033885 1000033973 1000033984 1000029293 1000034040 1000034042 1000034150 1000034201 1000034238 1000034239 1000034240 1000034241 1000034242 1000034052 1000034313 1000034152 1000016975 1000014806 1000019539 1000026332 1000034726 1000034733 1000034734 1000034735 1000035145 1000035272 1000033522 1000014635 1000035373 1000035385 1000035391 1000035524 1000035659 1000035660 1000035700 1000035701 1000035702 1000035705 1000035985 1000035982 1000020217 1000025365 1000033325 1000036252 1000036277 1000036286 1000005828 1000036390 1000019046 1000036690 1000036752 1000036754 1000036940 1000036941 1000037221 1000037233 1000037234 1000037568 1000037655 1000037670 1000037671 1000037674 1000037677 1000037678 1000037679 1000037680 1000037681 1000037682 1000037683 1000037684 1000037685 1000037686 1000037687 1000037688 1000037714 1000037722 1000037758 1000037759 1000037760 1000037761 1000037893 1000037894 1000037895 1000037915 1000037921 1000032550 1000038151 1000038175 1000038191 1000038333 1000038334 1000038335 1000038336 1000038341 1000038715 1000038777 1000038788 1000038795 1000038802 1000038936 1000038967 1000038969 1000038972 1000038973 1000038974 1000038999 1000039013 1000039014 1000039016 1000039029 1000039042 1000039075 1000039124 1000039189 1000039367 1000039368 1000039389 1000039437 1000039637 1000039645 1000039651 1000039652 1000039653 1000039654 1000039655 1000039666 1000039717 1000040079 1000040080 1000040081 1000040082 1000040084 1000040086 1000040088 1000040097 1000040098 1000040100 1000040108 1000040109 1000040111 1000040113 1000040118 1000040129 1000040227 1000040242 1000012594 1000040483 1000040484 1000040485 1000003104 1000040811 1000040812 1000040829 1000039474 1000041033 1000041074 1000041075 1000041118 1000041119 1000041121 1000041246 1000041296 1000041312 1000041328 1000041329 1000041331 1000016436 1000041436 1000041437 1000041168 1000041562 1000041566 1000041567 1000041576 1000041577 1000041584 1000041585 1000041601 1000041607 1000041636 1000041638 1000041640 1000041695 1000041696 1000041704 1000041738 1000041833 1000041864 1000042072 1000042073 1000016581 1000042144 1000042145 1000042152 1000038929 1000041341 1000042383 1000042398 1000042400 1000042410 1000021976 1000042415 1000042416 1000042417 1000042445 1000019182 1000042566 1000042686 1000041463 1000042408 1000027618 1000042835 1000042836 1000043060 1000043061 1000043062 1000043066 1000043070 1000039194 1000043095 1000043106 1000043108 1000043116 1000043118 1000043126 1000043128 1000043130 1000043134 1000040132 1000043592 1000043770 1000043772 1000043774 1000043796 1000043798 1000043806 1000043808 1000043847 1000043848 1000037676 1000038796 1000018447 1000018425 1000044038 1000044072 1000044073 1000044076 1000044077 1000044079 1000044086 1000044089 1000044093 1000044094 1000044095 1000044096 1000024125 1000044104 1000044107 1000044144 1000044145 1000044175 1000044177 1000044192 1000044205 1000044211 1000044215 1000044216 1000044219 1000044221 1000044222 1000044288 1000044296 1000044308 1000044346 1000044347 1000044363 1000044365 1000044367 1000041745 1000036850 1000044719 1000044809 1000044817 1000044954 1000044914 1000045020 1000045025 1000045026 1000045316 1000044535 1000045713 1000029306 1000046100 1000046294 1000046512 1000046824 1000046869 1000046883 1000046915 1000046925 1000046926 1000046927 1000046928 1000046934 1000040065 1000047160 1000047168 1000047171 1000047172 1000047174 1000047175 1000047176 1000047194 1000047384 1000047138 1000040853 1000012920 1000026446 1000014886 1000028015 1000033493 1000047718 1000047721 1000047760 1000047771 1000047819 1000047805 1000033743 1000047825 1000047840 1000047169 1000046954 1000047872 1000046419 1000042922 1000048010 1000048020 1000048100 1000048111 1000048112 1000048113 1000048168 1000048169 1000038179 1000048328 1000048331 1000047211 1000047196 1000048375 1000048376 1000047951 1000019114 1000048440 1000048461 1000048503 1000048509 1000044992 1000045344 1000048591 1000048592 1000048596 1000048652 1000048710 1000048711 1000048712 1000042965 1000025527 1000048347 1000048778 1000048787 1000048788 1000048829 1000048856 1000048881 1000048357 1000025427 1000037931 1000024811 1000049105 1000049113 1000049169 1000049217 1000049270 1000049291 1000049314 1000049326 1000049335 1000047935 1000049373 1000049376 1000009578 1000049434 1000049439 1000042895 1000049480 1000048971 1000049518 1000049187 1000049596 1000049626 1000033873 1000049819 1000049832 1000049838 1000049851 1000048142 1000049717 1000039448 1000049910 1000049925 1000023855 1000048259 1000049971 1000049973 1000050087 1000048235 1000050137 1000025298 1000050263 1000050266 1000050276 1000050335 1000048395 1000050349 1000050351 1000050359 1000029115 1000050379 1000049839 1000050493 1000032442 1000050601 1000050602 1000042820 1000050691 1000050660 1000050708 1000050696 1000050786 1000049579 1000049466 1000050838 1000049192 1000050887 1000049521 1000050907 1000050938 1000048190 1000051015 1000051018 1000051049 1000051118 1000037063 1000049259 1000050835 1000048714 1000051295 1000051316 1000051326 1000051350 1000051375 1000050685 1000051394 1000051402 1000050134 1000051325 1000051458 1000051399 1000049383 1000051569 1000051588 1000051635 1000051463 1000051664 1000051843 1000051849 1000009664 1000051908 1000050287 1000051943 1000051841 1000049911 1000052028 1000049906 1000049785 1000048804 1000051537 1000024035 1000052104 1000049860 1000051883 1000052133 1000052219 1000052220 1000050278 1000050350 1000051894 1000038839 1000052408 1000052427 1000051055 1000051909 1000052541 1000052544 1000052072 1000052589 1000052232 1000052680 1000052682 1000052685 1000052689 1000052707 1000052708 1000052713 1000052716 1000052717 1000052738 1000052759 1000052765 1000052769 1000052770 1000052771 1000050280 1000052833 1000052486 1000052928 1000052423 1000052959 1000052410 1000052985 1000053021 1000052957 1000052115 1000052973 1000053087 1000053117 1000051749 1000049581 1000049668 1000052744 1000053267 1000049647 1000053211 1000053380 1000052975 1000053393 1000008055 1000053423 1000053429 87248] 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 (6338441, 6343834, 6349830, 6343601, 6353970, 6356282, 6356454, 6356733, 6356771, 6356859, 6357324, 6357536, 6357775, 6357795, 6357942, 6357991, 6358042, 6358108, 6358169, 6358165, 6358230, 6358766, 6359441, 6357254, 6360157, 6360160, 6360164, 6361653, 6363926, 6364027, 6364511, 6364728, 6365076, 6365861, 6369317, 6369421, 6369602, 6369948, 6370510, 6370550, 6370575, 6371312, 6372032, 6372178, 6372445, 6373176, 6373330, 6373401, 6373563, 6375785, 6376425, 6380618, 6382566, 6383059, 6383521, 6385235, 6366688, 6386759, 6387230, 6388025, 6388490, 6386579, 6388939, 6389019, 6389049, 6389069, 6389703, 6390280, 6390325, 6385855, 6390472, 6390679, 6390736, 6387472, 6391293, 6389084, 6391500, 6391913, 6392049, 6392109, 6392157, 6392181, 6392365, 6392471, 6392161, 6392534, 6392835, 6393236, 6393640, 6393655, 6393699, 6393804, 6393837, 6394022, 6394225, 6393601, 6389080, 6394465, 6394466, 6394624, 6391516, 6395401, 6396362, 6397417, 6400509, 6400515, 6400516, 6400742, 6400826, 6400934, 6401487, 6401686, 6402565, 6402664, 6403115, 6403135, 6403845, 6404008, 6404305, 6404348, 6404608, 6404703, 6405128, 6405342, 6405700, 6406124, 6406510, 6407146, 6407421, 6407772, 6408247, 6408623, 6408633, 6408830, 6408895, 6409195, 6409305, 6409608, 6409704, 6410080, 6410416, 6410429, 6410672, 6410673, 6410711, 6410718, 6410867, 6410934, 6411233, 6411868, 6412328, 6412714, 6412717, 6412724, 6412746, 6412885, 6412960, 6413281, 6413300, 6413589, 6413852, 6413879, 6413887, 6414081, 6414183, 6414240, 6414251, 6414252, 6414256, 6414257, 6414284, 6414384, 6414683, 6414730, 6414739, 6414761, 6414927, 6414950, 6414965, 6415012, 6415030, 6415046, 6415122, 6415125, 6415154, 6415164, 6415199, 6415390, 6415394, 6415454, 6415462, 6415484, 6415509, 6415969, 6416027, 6416036, 6416116, 6416118, 6416122, 6416292, 6416312, 6416325, 6416436, 6416476, 6416776, 6416804, 6416829, 6416849, 6416979, 6417024, 6417083, 6417110, 6417118, 6417225, 6417280, 6417576, 6417655, 6418002, 6418007, 6418171, 6418380, 6418536, 6418815, 6418893, 6418942, 6418981, 6419024, 6419144, 6419235, 6419239, 6419241, 6419284, 6419307, 6419321, 6419353, 6419362, 6419371, 6419403, 6419442, 6419570, 6419571, 6419880, 6419883, 6419888, 6420428, 6420647, 6420721, 6420781, 6420822, 6420854, 6421234, 6421416, 6421479, 6421666, 6421746, 6421762, 6421782, 6421843, 6421909, 6421938, 6421941, 6422027, 6422049, 6422178, 6422243, 6422351, 6422380, 6422435, 6422729, 6422808, 6422878, 6422922, 6423164, 6423770, 6423983, 6424018, 6424033, 6424114, 1000013586, 6424661, 6424815, 6424844, 6424983, 6425083, 6425090, 6425344, 6425436, 6425443, 6425565, 6425756, 6426116, 6426172, 6426174, 6426324, 6426338, 6426388, 6426542, 6426551, 6426608, 6426611, 6426685, 6426812, 6426925, 6427094, 6427269, 6427274, 6427285, 6427385, 6427693, 6427951, 6428170, 6428408, 6428430, 6428494, 6428508, 6428875, 6428914, 6428974, 6429041, 6429169, 6429261, 6429486, 6429631, 6429787, 6429797, 6429946, 6430047, 6430270, 6430286, 6430336, 6430538, 6430573, 6430873, 6430902, 6430904, 6430907, 6430950, 6430976, 6431118, 6431176, 6431289, 6431494, 6431572, 6431672, 6431843, 6431859, 6431959, 6432048, 6432087, 6432132, 6432133, 6432165, 6432189, 6432200, 6432239, 6432282, 6432304, 6433057, 6433310, 6433682, 6433960, 6434039, 6434215, 6434330, 6434423, 6434428, 6434662, 6434679, 6434750, 6434752, 6434759, 6434772, 6434835, 6434967, 6435048, 6435144, 6435149, 6435257, 6435287, 6435298, 6435351, 6435496, 6435555, 6435634, 6435667, 6435860, 6435864, 6435874, 6435897, 6435928, 6435956, 6435985, 6436036, 6436289, 6436356, 6436653, 6436996, 6437104, 6437187, 6437218, 6437701, 6437726, 6437751, 6437884, 6437989, 6438044, 6438068, 6438077, 6438103, 6438497, 6438503, 6438539, 6438557, 6438583, 6438828, 6438899, 6438937, 6438957, 6438979, 6439058, 6439059, 6439060, 6439117, 6439171, 6439262, 6439414, 6439639, 6439676, 6439800, 6439937, 6440718, 6440835, 6440934, 6441208, 6441332, 6441356, 6441439, 6441863, 6442296, 6442297, 6442746, 6442761, 6442763, 6442924, 6443132, 6443152, 6443282, 6443849, 6443886, 6444133, 6444245, 6444295, 6444300, 6444427, 6444500, 6444633, 6444872, 6445244, 6445278, 6445371, 6445436, 6445449, 6445520, 6445639, 6445649, 6445652, 6445669, 6445700, 6445728, 6445734, 6445768, 6445777, 6446038, 6446055, 6446061, 6446084, 6446091, 6446158, 6446167, 6446368, 6446417, 6446442, 6446521, 6446548, 6446612, 6446638, 6446680, 6446743, 6446749, 6446812, 6446821, 6446888, 6446908, 6446914, 6446988, 6447056, 6447057, 6447076, 6447257, 6447297, 6447375, 6447391, 6447540, 6447642, 6447645, 6447659, 6447674, 6448278, 6448735, 6448801, 6448849, 6448918, 6448956, 6448960, 6448975, 6449133, 6449338, 6449462, 6449469, 6449556, 6449642, 6449697, 6449703, 6449726, 6449769, 6449771, 6449777, 6449781, 6449821, 6449886, 6449905, 6449913, 6450100, 6450105, 6450106, 6450152, 6450167, 6450172, 6450173, 6450176, 6450180, 6450189, 6450191, 6450195, 6450199, 6450234, 6450253, 6450268, 6450270, 6450274, 6450312, 6450368, 6450435, 6450505, 6450539, 6450609, 6450613, 6450635, 6450668, 6450670, 6450814, 6450833, 6450879, 6450930, 6450991, 6451023, 6451041, 6451090, 6451111, 6451129, 6451171, 6451209, 6451224, 6451228, 6451232, 6451251, 6451317, 6451365, 6451372, 6451383, 6451416, 6451417, 6451420, 6451431, 6451438, 6451439, 6451531, 6451541, 6451562, 6451564, 6451577, 6451581, 6451616, 6451661, 6451707, 6451793, 6451794, 6451826, 6451922, 6451926, 6451944, 6452020, 6452041, 6452051, 6452055, 6452059, 6452086, 6452099, 6452218, 6452223, 6452253, 6452317, 6452352, 6452367, 6452373, 6452394, 6452420, 6452531, 6452558, 6452570, 6452830, 6453481, 6453516, 6453556, 6453557, 6453629, 6453746, 6453772, 6453874, 6453932, 6454015, 6454025, 6454126, 6454181, 6454200, 6454535, 6454536, 6454538, 6454546, 6454562, 6454582, 6454607, 6454608, 6454622, 6454625, 6454649, 6454667, 6454761, 6454773, 6454777, 6454784, 6454786, 6454790, 6454794, 6454812, 6454842, 6454848, 6454862, 6454863, 6454886, 6454889, 6454895, 6454896, 6454926, 6454949, 6454982, 6454984, 6454985, 6454997, 6455040, 6455066, 6455128, 6455141, 6455153, 6455199, 6455201, 6455236, 6455257, 6455345, 6455376, 6455422, 6455447, 6455451, 6455455, 6455461, 6455508, 6455557, 6455616, 6455620, 6455634, 6455690, 6455694, 6455785, 6455847, 6455860, 6455864, 6455956, 6456091, 6456096, 6456097, 6456109, 6456264, 6456274, 6456750, 6457058, 6457205, 6457243, 6457247, 6457252, 6457266, 6457418, 6457437, 6457440, 6457508, 6457521, 6457645, 6457945, 6458242, 6458380, 6458488, 6458977, 6458988, 6459180, 6459265, 6459277, 6459285, 6459287, 6459479, 6459561, 6459992, 6460274, 6460417, 6460915, 6460922, 6460944, 6460990, 6461011, 6461042, 6461454, 6461848, 6462258, 6462307, 6462383, 6462540, 6462637, 6462674, 6462717, 6462973, 6463050, 6463233, 6463395, 6464009, 6464256, 6464264, 6464492, 6464515, 6464555, 6464880, 6465138, 6465286, 6465287, 6465291, 6465366, 6465631, 6465665, 6466049, 6466438, 6466624, 6466672, 6466750, 6467234, 6467826, 6468020, 6468060, 6468071, 6468121, 6468201, 6468208, 6468545, 6468650, 6468774, 6468784, 6468858, 6469059, 6392423, 1000001009, 6394821, 1000000950, 1000001108, 1000000905, 1000001712, 6392324, 1000001938, 1000001949, 1000001950, 1000002001, 1000002039, 1000001953, 1000002113, 1000002114, 1000002399, 1000002408, 6387845, 1000002614, 1000002744, 1000000976, 1000002980, 1000002979, 1000001869, 1000002674, 1000004681, 1000004683, 1000004707, 6390715, 6390633, 1000004350, 1000004554, 1000005161, 1000004565, 1000005538, 1000004780, 1000005848, 1000005849, 1000005942, 1000006175, 1000006176, 6392532, 6382649, 6385755, 1000002610, 1000006566, 1000006615, 1000006968, 1000007010, 1000005820, 1000005688, 1000007244, 1000007260, 6389526, 1000006199, 1000007667, 1000007755, 1000002561, 1000002180, 1000008056, 1000008012, 1000002654, 1000002495, 1000008211, 1000004763, 1000008316, 1000008317, 1000008318, 1000008332, 1000008419, 1000008704, 1000001350, 1000008870, 1000008454, 1000009009, 6392778, 1000009098, 1000008556, 1000002559, 1000009528, 6389029, 1000009721, 1000009747, 1000009758, 1000009918, 1000009989, 1000009992, 1000006630, 1000002059, 1000009430, 1000004161, 1000006056, 1000009436, 1000010110, 1000009858, 1000008985, 1000005033, 1000010149, 6385280, 1000010143, 1000010553, 1000008089, 1000005970, 1000010755, 1000010400, 1000010743, 1000010773, 1000010839, 1000010521, 1000010912, 1000011801, 1000004768, 1000002243, 1000011883, 1000010840, 1000010561, 1000012018, 1000011880, 1000008546, 1000012071, 1000012114, 6391605, 1000012154, 1000012180, 1000012362, 1000012401, 1000011993, 1000012450, 1000003872, 1000012603, 1000012620, 1000012627, 1000012757, 1000006069, 1000011946, 1000013005, 1000010170, 1000010178, 1000013215, 1000010452, 1000010147, 1000012615, 1000013558, 1000013135, 1000009912, 1000013431, 1000013208, 1000010502, 1000013788, 1000013856, 1000013959, 1000012382, 1000004333, 1000014034, 1000009260, 1000007405, 1000012721, 1000014534, 1000014505, 1000004686, 1000014802, 1000009230, 1000014828, 1000014102, 1000005543, 1000012604, 1000012647, 1000012222, 1000015109, 1000005279, 1000014283, 1000009611, 1000009163, 1000011070, 1000011076, 1000015480, 1000014831, 1000015507, 1000015509, 1000014870, 1000010013, 1000015628, 1000015788, 1000015327, 1000012235, 1000015921, 1000016193, 1000016206, 1000009646, 1000016251, 1000016410, 1000016448, 1000016537, 1000016538, 1000016539, 1000016545, 1000016562, 1000002598, 1000016672, 1000014799, 1000017017, 1000017065, 1000017148, 1000016711, 1000013568, 1000006277, 1000013221, 1000017444, 1000016175, 1000017121, 1000014076, 1000017531, 1000017532, 1000008325, 1000017547, 1000017728, 1000017953, 1000017954, 1000017955, 1000017956, 1000018045, 1000018052, 1000018053, 1000018054, 1000018065, 1000018072, 1000018073, 1000018074, 1000018075, 1000018076, 1000018077, 1000018078, 1000018079, 1000018080, 1000018081, 1000018082, 1000018083, 1000014518, 1000018172, 1000018173, 1000018174, 1000018175, 1000018205, 1000012790, 1000018514, 1000018515, 1000018518, 1000018521, 1000018522, 1000018523, 1000018524, 1000018525, 1000018569, 1000014075, 1000016412, 1000016084, 1000018804, 1000019019, 1000019020, 1000019021, 1000019023, 1000019024, 1000019025, 1000019066, 1000019111, 1000019171, 1000019174, 1000019178, 1000019208, 1000019344, 1000019371, 1000017743, 1000016967, 1000016665, 1000019438, 1000019451, 1000019479, 1000019482, 1000019665, 1000019680, 1000019758, 1000019759, 1000019822, 1000019823, 1000019893, 1000019918, 1000019922, 1000019938, 1000019939, 1000019941, 1000020061, 1000020067, 1000020080, 1000020087, 1000020121, 1000020127, 1000015124, 1000020346, 1000020348, 1000020349, 1000020350, 1000020352, 1000020353, 1000020372, 1000019942, 1000019925, 1000014829, 1000017079, 1000020592, 1000020596, 1000020595, 1000019228, 1000020090, 1000013768, 1000020779, 1000020797, 1000014324, 1000016460, 1000020947, 1000019489, 1000020084, 1000016541, 1000015501, 1000015117, 1000012389, 1000012314, 1000018772, 1000017771, 1000017494, 1000021427, 1000013129, 1000021566, 1000021579, 1000021652, 1000021654, 1000021657, 1000021664, 1000021741, 1000021761, 1000021762, 1000021763, 1000021764, 1000021766, 1000021767, 1000021772, 1000021770, 1000021774, 1000021775, 1000021777, 1000021779, 1000021781, 1000021782, 1000021783, 1000021790, 1000021791, 1000021792, 1000021796, 1000021797, 1000021798, 1000021799, 1000021802, 1000021811, 1000021818, 1000021825, 1000021828, 1000021831, 1000021864, 1000021866, 1000021869, 1000021886, 1000021891, 1000021892, 1000021893, 1000021904, 1000021909, 1000021910, 1000021911, 1000021912, 1000021925, 1000017163, 1000016660, 1000021998, 1000021999, 1000022000, 1000022001, 1000022002, 1000022003, 1000022004, 1000022005, 1000022006, 1000002545, 1000002245, 1000002102, 1000001487, 1000020497, 1000022123, 1000016689, 1000022162, 1000022185, 1000012427, 1000022191, 1000022205, 1000022255, 1000022254, 1000013342, 1000018636, 1000022665, 1000022676, 1000022682, 1000022690, 1000021928, 1000016401, 1000022829, 1000022837, 1000021466, 1000023455, 1000023555, 1000023568, 1000023630, 1000023631, 1000023671, 1000023926, 1000023940, 1000020616, 1000018111, 1000024515, 1000024516, 1000024607, 1000023665, 1000024969, 1000024970, 1000024997, 1000025170, 1000025387, 1000025450, 1000025457, 1000025494, 1000025496, 1000016387, 1000025562, 1000025578, 1000017957, 1000022794, 1000025947, 1000026132, 1000026133, 1000026135, 1000026329, 1000026434, 1000026435, 1000026436, 1000026438, 1000026440, 1000021619, 1000026187, 1000026501, 1000025564, 1000017567, 1000006969, 1000023944, 1000026890, 1000026891, 1000026892, 1000026893, 1000026894, 1000026895, 1000026899, 1000022192, 1000016260, 1000021567, 1000027883, 1000027895, 1000027905, 1000027995, 1000028060, 1000028398, 1000028524, 1000028528, 1000028550, 1000028552, 1000028557, 1000028561, 1000028593, 1000028613, 1000028614, 1000028626, 1000028643, 1000028644, 1000028621, 1000028836, 1000028838, 1000028840, 1000028862, 1000017161, 1000014104, 1000016744, 1000021954, 1000028982, 1000025524, 1000029107, 1000029239, 1000029240, 1000029243, 1000029303, 1000029304, 1000029098, 1000023431, 1000029400, 1000025609, 1000016648, 1000029714, 1000029871, 1000029881, 1000017889, 1000026665, 1000015067, 1000030132, 6394469, 1000029454, 1000030247, 1000030365, 1000030388, 1000030356, 1000030467, 1000030485, 1000030486, 1000030487, 1000022840, 1000030740, 1000030741, 1000030742, 1000030745, 1000030746, 1000030749, 1000030750, 1000030753, 1000030756, 1000030758, 1000030912, 1000030913, 1000030915, 1000030916, 1000030917, 1000030918, 1000030919, 1000030920, 1000030922, 1000030924, 1000030925, 1000030945, 1000031094, 1000031095, 1000031096, 1000012404, 1000031273, 1000027977, 1000012010, 1000028651, 1000031479, 1000015990, 1000002606, 1000031885, 1000031887, 1000031928, 1000031929, 1000031932, 1000031934, 1000031936, 1000031940, 1000031949, 1000031950, 1000031951, 1000031968, 1000031991, 1000032032, 1000032035, 1000032088, 1000023685, 1000032284, 1000032324, 1000032328, 1000032344, 1000032376, 1000032492, 1000032505, 1000032509, 1000029896, 1000032516, 1000028620, 1000029174, 1000026136, 1000026624, 1000032072, 1000033071, 1000033072, 1000033081, 1000033092, 1000033093, 1000033191, 1000033193, 1000033198, 1000033212, 1000033217, 1000033218, 1000033220, 1000033223, 1000033232, 1000033239, 1000033240, 1000033243, 1000033245, 1000033264, 1000033269, 1000033272, 1000033281, 1000033314, 1000033316, 1000033336, 1000033345, 1000033353, 1000033366, 1000033368, 1000033369, 1000033384, 1000033385, 1000033446, 1000033447, 1000033449, 1000033468, 1000033485, 1000033489, 1000033491, 1000032055, 1000033781, 1000033299, 1000033870, 1000033885, 1000033973, 1000033984, 1000029293, 1000034040, 1000034042, 1000034150, 1000034201, 1000034238, 1000034239, 1000034240, 1000034241, 1000034242, 1000034052, 1000034313, 1000034152, 1000016975, 1000014806, 1000019539, 1000026332, 1000034726, 1000034733, 1000034734, 1000034735, 1000035145, 1000035272, 1000033522, 1000014635, 1000035373, 1000035385, 1000035391, 1000035524, 1000035659, 1000035660, 1000035700, 1000035701, 1000035702, 1000035705, 1000035985, 1000035982, 1000020217, 1000025365, 1000033325, 1000036252, 1000036277, 1000036286, 1000005828, 1000036390, 1000019046, 1000036690, 1000036752, 1000036754, 1000036940, 1000036941, 1000037221, 1000037233, 1000037234, 1000037568, 1000037655, 1000037670, 1000037671, 1000037674, 1000037677, 1000037678, 1000037679, 1000037680, 1000037681, 1000037682, 1000037683, 1000037684, 1000037685, 1000037686, 1000037687, 1000037688, 1000037714, 1000037722, 1000037758, 1000037759, 1000037760, 1000037761, 1000037893, 1000037894, 1000037895, 1000037915, 1000037921, 1000032550, 1000038151, 1000038175, 1000038191, 1000038333, 1000038334, 1000038335, 1000038336, 1000038341, 1000038715, 1000038777, 1000038788, 1000038795, 1000038802, 1000038936, 1000038967, 1000038969, 1000038972, 1000038973, 1000038974, 1000038999, 1000039013, 1000039014, 1000039016, 1000039029, 1000039042, 1000039075, 1000039124, 1000039189, 1000039367, 1000039368, 1000039389, 1000039437, 1000039637, 1000039645, 1000039651, 1000039652, 1000039653, 1000039654, 1000039655, 1000039666, 1000039717, 1000040079, 1000040080, 1000040081, 1000040082, 1000040084, 1000040086, 1000040088, 1000040097, 1000040098, 1000040100, 1000040108, 1000040109, 1000040111, 1000040113, 1000040118, 1000040129, 1000040227, 1000040242, 1000012594, 1000040483, 1000040484, 1000040485, 1000003104, 1000040811, 1000040812, 1000040829, 1000039474, 1000041033, 1000041074, 1000041075, 1000041118, 1000041119, 1000041121, 1000041246, 1000041296, 1000041312, 1000041328, 1000041329, 1000041331, 1000016436, 1000041436, 1000041437, 1000041168, 1000041562, 1000041566, 1000041567, 1000041576, 1000041577, 1000041584, 1000041585, 1000041601, 1000041607, 1000041636, 1000041638, 1000041640, 1000041695, 1000041696, 1000041704, 1000041738, 1000041833, 1000041864, 1000042072, 1000042073, 1000016581, 1000042144, 1000042145, 1000042152, 1000038929, 1000041341, 1000042383, 1000042398, 1000042400, 1000042410, 1000021976, 1000042415, 1000042416, 1000042417, 1000042445, 1000019182, 1000042566, 1000042686, 1000041463, 1000042408, 1000027618, 1000042835, 1000042836, 1000043060, 1000043061, 1000043062, 1000043066, 1000043070, 1000039194, 1000043095, 1000043106, 1000043108, 1000043116, 1000043118, 1000043126, 1000043128, 1000043130, 1000043134, 1000040132, 1000043592, 1000043770, 1000043772, 1000043774, 1000043796, 1000043798, 1000043806, 1000043808, 1000043847, 1000043848, 1000037676, 1000038796, 1000018447, 1000018425, 1000044038, 1000044072, 1000044073, 1000044076, 1000044077, 1000044079, 1000044086, 1000044089, 1000044093, 1000044094, 1000044095, 1000044096, 1000024125, 1000044104, 1000044107, 1000044144, 1000044145, 1000044175, 1000044177, 1000044192, 1000044205, 1000044211, 1000044215, 1000044216, 1000044219, 1000044221, 1000044222, 1000044288, 1000044296, 1000044308, 1000044346, 1000044347, 1000044363, 1000044365, 1000044367, 1000041745, 1000036850, 1000044719, 1000044809, 1000044817, 1000044954, 1000044914, 1000045020, 1000045025, 1000045026, 1000045316, 1000044535, 1000045713, 1000029306, 1000046100, 1000046294, 1000046512, 1000046824, 1000046869, 1000046883, 1000046915, 1000046925, 1000046926, 1000046927, 1000046928, 1000046934, 1000040065, 1000047160, 1000047168, 1000047171, 1000047172, 1000047174, 1000047175, 1000047176, 1000047194, 1000047384, 1000047138, 1000040853, 1000012920, 1000026446, 1000014886, 1000028015, 1000033493, 1000047718, 1000047721, 1000047760, 1000047771, 1000047819, 1000047805, 1000033743, 1000047825, 1000047840, 1000047169, 1000046954, 1000047872, 1000046419, 1000042922, 1000048010, 1000048020, 1000048100, 1000048111, 1000048112, 1000048113, 1000048168, 1000048169, 1000038179, 1000048328, 1000048331, 1000047211, 1000047196, 1000048375, 1000048376, 1000047951, 1000019114, 1000048440, 1000048461, 1000048503, 1000048509, 1000044992, 1000045344, 1000048591, 1000048592, 1000048596, 1000048652, 1000048710, 1000048711, 1000048712, 1000042965, 1000025527, 1000048347, 1000048778, 1000048787, 1000048788, 1000048829, 1000048856, 1000048881, 1000048357, 1000025427, 1000037931, 1000024811, 1000049105, 1000049113, 1000049169, 1000049217, 1000049270, 1000049291, 1000049314, 1000049326, 1000049335, 1000047935, 1000049373, 1000049376, 1000009578, 1000049434, 1000049439, 1000042895, 1000049480, 1000048971, 1000049518, 1000049187, 1000049596, 1000049626, 1000033873, 1000049819, 1000049832, 1000049838, 1000049851, 1000048142, 1000049717, 1000039448, 1000049910, 1000049925, 1000023855, 1000048259, 1000049971, 1000049973, 1000050087, 1000048235, 1000050137, 1000025298, 1000050263, 1000050266, 1000050276, 1000050335, 1000048395, 1000050349, 1000050351, 1000050359, 1000029115, 1000050379, 1000049839, 1000050493, 1000032442, 1000050601, 1000050602, 1000042820, 1000050691, 1000050660, 1000050708, 1000050696, 1000050786, 1000049579, 1000049466, 1000050838, 1000049192, 1000050887, 1000049521, 1000050907, 1000050938, 1000048190, 1000051015, 1000051018, 1000051049, 1000051118, 1000037063, 1000049259, 1000050835, 1000048714, 1000051295, 1000051316, 1000051326, 1000051350, 1000051375, 1000050685, 1000051394, 1000051402, 1000050134, 1000051325, 1000051458, 1000051399, 1000049383, 1000051569, 1000051588, 1000051635, 1000051463, 1000051664, 1000051843, 1000051849, 1000009664, 1000051908, 1000050287, 1000051943, 1000051841, 1000049911, 1000052028, 1000049906, 1000049785, 1000048804, 1000051537, 1000024035, 1000052104, 1000049860, 1000051883, 1000052133, 1000052219, 1000052220, 1000050278, 1000050350, 1000051894, 1000038839, 1000052408, 1000052427, 1000051055, 1000051909, 1000052541, 1000052544, 1000052072, 1000052589, 1000052232, 1000052680, 1000052682, 1000052685, 1000052689, 1000052707, 1000052708, 1000052713, 1000052716, 1000052717, 1000052738, 1000052759, 1000052765, 1000052769, 1000052770, 1000052771, 1000050280, 1000052833, 1000052486, 1000052928, 1000052423, 1000052959, 1000052410, 1000052985, 1000053021, 1000052957, 1000052115, 1000052973, 1000053087, 1000053117, 1000051749, 1000049581, 1000049668, 1000052744, 1000053267, 1000049647, 1000053211, 1000053380, 1000052975, 1000053393, 1000008055, 1000053423, 1000053429) AND p0_.id <> 87248 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;
188.22 ms (7.06%)	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: [`"72198-cahiers-polypro-violet-n-c-72198-maju"`] 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 = '72198-cahiers-polypro-violet-n-c-72198-maju' AND p0_.is_active = 1;
3.08 ms (0.12%)	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;
2.23 ms (0.08%)	2	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: [`87249 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 = 87249 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.19 ms (0.08%)	2	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: [`87249`] 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 = 87249 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.76 ms (0.07%)	8	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;
1.68 ms (0.06%)	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.price_id = ? AND t0.product_id = ? LIMIT 1 Parameters: [`"CAISSE2011" 87249`] 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 = 87249 LIMIT 1;
1.18 ms (0.04%)	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: [`87248 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 = 87248 AND c1_.is_display_site = 1;
1.04 ms (0.04%)	2	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: [`87249 9963597`] 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 = 87249 AND p2_.id = 9963597 GROUP BY d0_.quantity ORDER BY d0_.quantity ASC;
0.90 ms (0.03%)	4	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;
0.82 ms (0.03%)	4	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: [`197560`] 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 = 197560;
0.80 ms (0.03%)	5	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;
0.73 ms (0.03%)	2	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: [`87249 "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 = 87249 AND t0.price_id = 'C' LIMIT 1;
0.67 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: [`41 189 190 191 192 193 194 195 191 87248`] 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 (41, 189, 190, 191, 192, 193, 194, 195, 191) AND p0_.is_active = 1 AND p0_.id <> 87248 AND p0_.is_btoc = 1 AND p0_.is_orapi_grand_frais <> 1 LIMIT 10;
0.62 ms (0.02%)	2	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-07-12 07:37:02" "%2%" 87249`] 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-07-12 07:37:02' AND o1_.is_active = 1 AND o1_.view_by LIKE '%2%' AND p0_.product_id = 87249;
0.44 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.43 ms (0.02%)	2	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: [`87249`] 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 = 87249;
0.36 ms (0.01%)	1	SELECT t0.id AS id_1, t0.reference AS reference_2, t0.manufacturer AS manufacturer_3, t0.short_label AS short_label_4, t0.long_label AS long_label_5, t0.weight AS weight_6, t0.sold_by AS sold_by_7, t0.ppht AS ppht_8, t0.ppttc AS ppttc_9, t0.paht AS paht_10, t0.pattc AS pattc_11, t0.legal_discount_library AS legal_discount_library_12, t0.fidelity_bonus AS fidelity_bonus_13, t0.brand AS brand_14, t0.time_limit AS time_limit_15, t0.coef AS coef_16, t0.is_discountable AS is_discountable_17, t0.is_btob AS is_btob_18, t0.is_btoc AS is_btoc_19, t0.is_customizable AS is_customizable_20, t0.is_library AS is_library_21, t0.is_nathan AS is_nathan_22, t0.is_green AS is_green_23, t0.is_orapi_grand_frais AS is_orapi_grand_frais_24, t0.is_active AS is_active_25, t0.slug AS slug_26 FROM product t0 WHERE t0.id = ? LIMIT 1 Parameters: [`"72198-cahiers-polypro-violet-n-c-72198-maju"`] 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 FROM product t0 WHERE t0.id = ? LIMIT 1 SELECT t0.id AS id_1, t0.reference AS reference_2, t0.manufacturer AS manufacturer_3, t0.short_label AS short_label_4, t0.long_label AS long_label_5, t0.weight AS weight_6, t0.sold_by AS sold_by_7, t0.ppht AS ppht_8, t0.ppttc AS ppttc_9, t0.paht AS paht_10, t0.pattc AS pattc_11, t0.legal_discount_library AS legal_discount_library_12, t0.fidelity_bonus AS fidelity_bonus_13, t0.brand AS brand_14, t0.time_limit AS time_limit_15, t0.coef AS coef_16, t0.is_discountable AS is_discountable_17, t0.is_btob AS is_btob_18, t0.is_btoc AS is_btoc_19, t0.is_customizable AS is_customizable_20, t0.is_library AS is_library_21, t0.is_nathan AS is_nathan_22, t0.is_green AS is_green_23, t0.is_orapi_grand_frais AS is_orapi_grand_frais_24, t0.is_active AS is_active_25, t0.slug AS slug_26 FROM product t0 WHERE t0.id = '72198-cahiers-polypro-violet-n-c-72198-maju' LIMIT 1;
0.33 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: [`87248`] 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 = 87248;
0.30 ms (0.01%)	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: [`"72198-cahiers-polypro-violet-n-c-72198-maju"`] 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 = '72198-cahiers-polypro-violet-n-c-72198-maju';

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.

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\Entity\Customer\Customer	No errors.
App\Entity\Internal\Counter	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\Pricing\SocietyPromotion	No errors.
App\Entity\Product\ProductReductionLabel	No errors.

Symfony Profiler

GET https://staging.pgdis.com/produit/72198-cahiers-polypro-violet-n-c-72198-maju

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping