Symfony Profiler

Query Metrics

125 Database Queries

23 Different statements

4096.24 ms Query time

0 Invalid entities

Grouped Statements

Time▼	Count	Info
2105.94 ms (51.41%)	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: [`9450 "2025-02-12 09:42:59"`] 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 = 9450 AND c0_.created_at >= '2025-02-12 09:42:59';
1627.86 ms (39.74%)	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: [6337068 6337721 6337961 6337988 6338011 6338415 6338529 6338609 6338772 6338814 6338934 6314723 6339040 6339093 6339126 6339182 6339625 6339630 6339739 6340364 6340393 6338714 6340459 6340700 6340720 6319924 6320819 6322449 6340813 6340827 6340978 6341047 6341068 6341385 6316483 6316833 6316881 6341758 6341760 6341932 6341996 6342011 6342840 6344252 6343823 6344273 6344343 6344369 6344559 6344811 6344872 6345859 6346074 6342221 6346440 6346491 6346496 6346631 6346635 6346819 6346975 6347176 6347412 6347461 6347860 6347914 6347939 6348160 6348200 6348201 6348222 6348231 6348236 6348250 6348262 6348265 6348267 6348297 6348307 6348352 6348393 6348404 6348451 6348453 6348504 6348515 6348519 6348706 6348739 6348740 6348745 6348749 6348751 6348831 6348840 6348870 6348895 6348896 6349025 6349027 6349029 6349075 6349126 6349132 6349138 6349175 6349190 6349191 6349216 6349238 6349239 6349242 6349263 6349280 6349291 6349295 6349316 6349511 6349538 6349689 6349748 6349822 6349840 6349961 6349962 6349971 6349991 6350031 6350036 6350074 6350076 6350077 6350207 6350211 6350221 6350243 6350248 6350322 6350326 6350341 6350346 6350347 6350348 6350367 6350398 6350426 6350442 6350444 6350473 6350547 6350558 6350751 6344576 6350986 6350994 6351056 6351163 6351657 6351789 6351849 6351882 6352068 6352387 6352662 6352819 6351112 6352911 6352923 6353019 6353228 6353302 6353388 6353707 6353801 6353819 6353927 6354008 6354628 6354739 6355380 6355502 6355618 6356010 6340660 6356842 6357422 6357440 6357453 6357663 6357879 6358230 6358498 6358599 6359462 6360101 6358744 6362095 6362822 6364027 6364691 6365066 6365182 6365209 6365502 6365718 6365687 6366788 6367438 6367473 6367474 6367476 6367479 6367548 6367822 6368369 6368267 6368344 6368252 6368562 6368296 6368394 6368523 6368686 6368246 6368455 6368534 6369153 6369226 6369917 6370007 6370264 6370284 6370423 6370530 6370860 6370862 6370913 6371156 6371311 6371789 6371795 6371892 6371896 6371916 6372081 6372090 6372264 6372694 6372815 6372880 6373070 6373085 6373188 6373248 6373249 6373324 6373353 6373548 6373843 6373963 6368302 6368341 6368367 6368482 6368697 6368729 6368838 6368852 6368915 6368386 6368851 6373990 6374084 6374138 6374154 6374158 6374173 6374204 6374219 6374221 6374231 6374278 6374283 6374318 6374324 6374326 6368726 6374356 6374401 6368974 6374487 6374530 6368575 6374290 6374695 6374854 6374878 6374882 6374953 6368397 6368698 6374181 6374277 6374630 6368472 6374721 6375050 6375346 6375350 6374653 6375404 6375494 6375246 6375544 6374706 6368768 6375893 6376089 6376108 6376188 6376236 6376326 6376327 6368843 6376390 6374433 6374466 6374622 6375229 6375488 6376244 6376419 6376491 6376505 6376591 6376612 6376691 6376712 6376772 6376558 6376825 6376882 6376646 6377226 6377256 6377281 6377312 6377330 6377332 6377349 6377388 6377394 6377399 6377402 6377511 6377530 6376284 6377659 6375687 6377995 6377997 6378340 6378297 6378560 6378633 6378654 6378744 6378775 6364293 6378813 6378864 6378944 6378957 6378992 6379108 6379149 6379194 6379199 6379496 6379594 6379709 6379723 6379724 6379779 6379792 6379838 6379544 6379915 6379996 6380119 6380246 6380275 6380341 6380423 6380482 6380816 6381258 6381506 6381637 6381664 6381687 6377147 6382201 6382307 6382360 6382489 6382596 6382601 6382651 6382655 6382656 6382689 6382726 6381411 6382826 6382877 6383101 6383109 6383110 6383181 6382869 6383591 6383882 6383977 6384126 6384128 6384375 6384501 6384702 6385159 6385166 6377912 6385475 6380834 6385458 6386460 6386582 6386700 6386872 6386933 6386964 6386981 6386988 6387009 6387105 6386776 6387536 6387693 6386584 6387723 6388134 6365625 6388161 6388187 6388262 6388303 6388330 6388338 6387721 6388449 6388581 6388644 6388751 6389069 6389120 6389121 6389174 6389181 6376087 6389429 6389440 6389445 6389655 6389826 6386995 6385287 6390053 6390056 6390074 6388696 6390336 6390511 6390556 6390707 6390963 6385922 6391146 6391138 6391168 6391192 6391196 6391498 6389078 6391818 6365356 6391931 6391981 6391983 6392021 6392040 6392049 6392106 6392282 6392207 6392489 6392708 6393058 6393151 6393241 6393273 6393285 6393339 6393408 6393511 6381461 6393024 6388629 6393608 6393635 6393826 6393874 6394046 6394065 6393601 6394452 6394496 6394544 6394675 6394683 6394820 6395219 6395302 6395406 6395466 6395861 6395871 6396240 6396242 6396427 6396473 6396493 6396667 6396728 6396762 6396772 6396779 6396821 6396826 6396827 6396841 6396860 6396861 6396866 6396887 6396896 6396912 6396922 6396924 6396926 6396930 6396939 6396955 6396998 6397021 6397118 6397131 6397134 6397135 6397151 6397275 6397293 6397314 6397363 6397364 6397373 6397408 6397467 6397543 6397607 6397658 6397677 6397678 6397682 6397735 6397796 6397808 6397814 6397856 6397859 6397865 6397919 6398010 6398016 6398041 6398057 6398075 6398309 6398534 6398693 6398741 6398861 6398877 6398879 6398975 6398982 6399008 6399037 6399053 6399072 6399075 6399093 6399125 6399131 6399137 6399147 6399159 6399205 6399354 6399355 6399359 6399368 6399399 6399400 6399431 6399444 6399511 6399512 6399544 6399573 6400152 6400223 6400236 6400297 6400516 6400731 6400838 6401313 6401526 6401617 6401652 6401671 6401749 6401976 6402073 6394148 6402393 6402421 6402509 6402790 6402823 6403117 6403711 6403850 6404014 6404207 6404266 6404535 6405108 6405154 6405328 6405661 6405926 6406253 6405935 6406376 6406829 6407083 6407107 6407146 6407157 6407421 6407521 6407533 6407658 6407657 6407777 6408003 6408050 6408058 6408350 6408543 6408770 6408826 6409061 6409304 6409344 6409704 6410095 6410196 6410281 6410884 6410939 6410954 6411258 6411858 6411859 6412026 6412087 6412840 6412991 6413045 6413547 6413562 6413566 6413585 6414395 6414872 6414873 6414874 6414875 6414876 6414877 6414878 6414879 6414880 6414881 6414882 6414883 6414884 6414885 6414886 6414887 6414888 6414889 6414890 6414891 6414892 6414893 6414894 6414998 6415040 6415205 6415248 6415249 6415250 6415251 6415252 6415253 6415254 6415255 6415256 6415257 6415258 6415259 6415261 6415262 6415263 6415265 6415266 6415267 6415268 6415269 6415270 6415271 6415272 6415273 6415482 6415675 6415704 6415753 6415818 6415830 6415831 6415886 6416038 6416093 6416257 6416342 6416599 6416635 6416980 6417062 6417315 6417345 6417391 6417515 6417541 6417587 6417694 6417701 6417704 6417776 6417876 6417942 6418115 6418176 6418265 6418403 6418406 6418452 6418590 6418596 6418605 6418609 6418641 6418649 6418661 6418666 6418726 6418736 6418750 6418893 6418935 6418981 6419188 6419239 6419322 6419379 6419391 6419392 6419421 6419437 6419570 6419571 6419576 6419599 6419674 6419769 6419825 6419857 6419884 6419902 6419907 6419948 6420000 6420099 6420153 6420441 6420459 6420460 6420541 6420607 6420695 6421392 6421536 6421743 6421798 6421836 6421837 6421870 6421916 6421976 6422032 6422386 6422340 6422399 6422401 6422405 6422412 6422500 6422649 6422720 6422876 6422967 6423077 6423251 6423654 6423945 6423996 6424098 6424135 6424274 6424318 6424340 6424495 6424727 6424901 6424909 6425270 6425256 6425291 6425332 6425344 6425353 6425393 6425598 6425756 6426172 6426183 6426211 6426373 6426425 6426427 6426429 6426441 6426515 6426601 6426793 6426828 6426941 6427073 6427233 6427266 6427270 6427315 6427327 6427351 6427390 6427631 6427894 6428422 6428440 6428557 6428638 6428663 6428711 6428793 6428909 6429272 6429373 6429449 6429473 6429587 6429653 6429680 6429694 6429695 6429793 6429872 6430112 6430285 6430363 6430462 6430629 6430664 6430843 6430872 6430974 6431111 6431334 6431527 6431537 6431672 6431695 6432046 6432130 6432176 6432201 6432205 6432212 6432225 6432248 6432342 6432401 6433544 6433614 6433679 6433750 6433779 6433821 6433838 6433840 6434035 6434062 6434215 6434284 6434361 6434380 6434600 6434655 6434696 6434698 6434911 6434940 6434942 6434953 6434955 6434967 6434982 6434984 6434997 6434999 6435020 6435021 6435207 6435219 6435220 6435272 6435298 6435313 6435636 6435668 6435829 6435874 6435913 6435963 6436002 6436077 6436250 6436274 6436442 6436491 6436793 6436988 6436996 6437163 6437169 6437257 6437258 6437455 6437701 6437706 6437726 6437884 6437945 6438026 6438044 6438077 6438096 6438113 6438784 6439253 6439594 6439603 6439615 6439620 6439635 6439636 6439743 6439772 6440149 6440291 6440359 6440511 6440985 6440993 6441140 6441367 6441371 6441390 6442107 6442178 6442195 6442202 6442244 6442346 6442459 6442736 6442769 6443713 6443723 6443724 6443740 6443742 6443885 6444055 6444057 6444102 6444284 6444304 6444364 6444372 6444619 6444633 6444750 6444965 6445327 6445335 6445637 6445713 6445793 6445811 6445968 6446438 6446480 6446740 6446743 6446835 6446955 6447122 6447130 6447399 6447454 6447464 6447642 6448260 6448265 6448504 6448606 6448653 6449112 6449321 6449371 6449379 6449513 6449704 6449769 6449781 6449819 6449885 6450106 6450168 6450199 6450253 6450281 6450416 6450604 6450631 6450654 6450757 6450760 6450766 6450767 6450768 6450932 6450957 6450989 6450992 6450996 6451035 6451090 6451112 6451221 6451248 6451303 6451314 6451349 6451370 6451371 6451389 6451404 6451422 6451435 6451439 6451616 6451707 6451771 6452007 6452041 6452169 6452214 6452242 6452272 6452352 6452404 6452537 6452570 6452659 6452776 6452781 6452813 6452902 6452913 6452918 6453010 6453018 6453035 6453038 6453039 6453044 6453055 6453058 6453085 6453096 6453101 6453151 6453211 6453213 6453263 6453327 6453378 6453395 6453471 6453481 6453646 6453705 6453726 6453871 6453872 6453896 6454025 6454081 6454140 6454162 6454176 6454181 6454247 6454255 6454258 6454346 6454396 6454401 6454431 6454472 6454475 6454477 6454531 6454535 6454536 6454545 6454560 6454563 6454719 6454786 6454852 6454864 6454865 6454867 6454985 6455040 6455119 6455257 6455292 6455345 6455375 6455388 6455451 6455465 6455477 6455533 6455579 6455583 6455606 6455648 6455702 6455742 6455781 6455831 6455842 6455852 6455884 6455897 6455933 6455955 6455985 6456017 6456120 6456135 6456232 6456301 6456304 6456344 6456365 6456389 6456431 6456544 6456581 6456595 6456619 6456665 6456694 6456700 6456780 6456815 6456816 6457034 6457046 6457071 6457246 6457300 6457513 6457516 6457520 6457669 6457885 6458145 6458386 6458430 6458501 6458518 6458523 6458826 6458876 6458942 6459444 6459524 6459953 6459976 6459989 6460086 6460099 6460101 6460173 6460244 6460417 6460542 6460632 6460633 6460635 6460636 6460637 6460638 6460639 6460640 6460641 6460642 6460643 6460644 6460645 6460646 6460647 6460648 6460649 6460650 6460651 6460652 6460653 6460654 6460655 6460656 6460657 6460658 6460659 6460660 6460661 6460662 6460663 6460664 6460665 6460666 6460667 6460668 6460669 6460670 6460671 6460672 6460674 6460675 6460676 6460677 6460678 6460680 6460681 6460682 6460683 6460684 6460686 6460687 6460688 6460689 6460690 6460691 6460692 6460693 6460694 6460695 6460696 6460697 6460698 6460699 6460700 6460701 6460702 6460703 6460704 6460705 6460706 6460707 6460708 6460709 6460710 6460711 6460712 6460713 6460714 6460715 6460716 6460717 6460718 6460719 6460726 6460727 6460728 6460729 6460730 6460731 6460732 6460733 6460734 6460735 6460736 6460737 6460738 6460739 6460740 6460741 6460742 6460743 6460744 6460745 6460746 6460747 6460748 6460749 6460750 6460751 6460752 6460753 6460754 6460755 6460756 6460757 6460758 6460759 6460760 6460761 6460762 6460763 6460765 6460767 6460768 6460769 6460770 6460771 6460772 6460773 6460774 6460775 6460776 6460777 6460778 6460779 6460780 6460781 6460782 6460783 6460784 6460785 6460786 6460787 6460788 6460789 6460790 6460791 6460793 6460794 6460795 6460796 6460797 6460798 6460799 6460800 6460927 6461020 6461300 6461304 6461335 6461357 6461395 6461416 6461655 6461668 6461914 6462256 6462351 6462540 6462857 6462967 6463032 6463173 6463212 6463607 6463681 6463729 6464264 6464291 6464535 6464644 6464754 6464880 6465254 6465286 6465287 6465291 6465783 6465809 6466397 6466622 6467091 6467455 6467464 6468056 6468060 6468545 6468618 6468669 6468676 6394945 6392474 6390888 1000002184 1000002494 1000002646 1000002669 1000002906 1000002930 1000002465 1000004031 6391971 1000004129 1000004367 1000004368 1000004492 1000004681 1000004683 1000004707 1000004711 1000004740 1000002528 6390715 6390633 1000001832 1000001476 1000005189 1000005267 1000005295 1000005409 1000005411 1000005524 1000004780 1000002318 1000005877 1000006974 1000006985 1000006987 1000007368 1000007838 1000008023 1000008034 1000008365 1000008481 1000008489 1000008827 1000008866 1000008877 1000008986 1000009130 1000009546 1000009547 1000009548 1000009553 1000009554 1000009556 1000009557 1000009558 1000009684 1000009918 1000009989 1000009992 1000010337 1000010358 1000010410 1000010411 1000010412 1000010413 1000010414 1000010415 1000010416 1000010419 1000010420 1000010437 1000010556 1000005996 1000010662 1000010694 1000010764 1000010741 1000010803 1000006779 1000011064 1000011844 1000011884 1000011970 1000012025 1000012026 1000012152 1000012228 6381331 1000012495 1000012598 1000012676 1000012741 1000012779 1000012782 1000012958 1000009545 1000011869 1000013407 1000003879 1000005320 1000013413 1000000852 6394126 1000012768 1000012385 1000008795 1000013803 1000013806 1000013888 1000012456 1000013967 1000005938 1000009448 1000012850 1000013909 1000014363 1000012721 1000014400 1000014524 1000014574 1000014658 6384068 1000014685 1000014773 1000014774 1000014797 1000014802 1000005543 1000014985 1000013586 1000014039 1000009611 1000015277 1000010474 1000014450 1000015548 1000009154 1000015654 1000015411 1000003030 1000015780 1000015745 1000015791 1000015851 1000014003 1000016204 1000016205 1000016207 1000016410 1000002598 1000013981 1000016780 1000016793 1000016942 1000016871 1000017062 1000017064 1000017067 1000017068 1000017069 1000017070 1000017219 1000017236 1000017268 1000017280 1000017283 1000012821 1000012275 1000017330 1000017300 1000017338 1000017579 1000017587 1000017719 1000017752 1000015332 1000017754 1000018749 1000018784 1000018605 1000018662 1000018558 1000019055 1000019065 1000019083 1000019100 1000019104 1000019115 1000019136 1000019212 1000019248 1000016960 1000018597 1000016738 1000010744 1000019565 1000019753 1000018964 1000017387 1000016411 1000019946 1000004135 1000016983 1000018376 1000017310 1000019018 1000017342 1000017257 1000019121 1000016687 1000012396 1000018731 1000020929 1000020930 1000006972 1000020971 1000016353 1000020877 1000020896 1000017335 1000020106 1000002102 1000001497 1000000919 1000022114 1000022115 1000019611 1000017434 1000018448 1000022325 1000022344 6393101 1000022394 1000022485 1000017425 1000021400 1000022611 1000018922 1000020883 1000022571 1000009774 1000009773 1000016998 1000020453 1000012677 1000009690 1000023013 1000023014 1000023015 1000023016 1000023017 1000023019 1000023020 1000023021 1000023038 1000023039 1000023040 1000023041 1000023042 1000023043 1000023044 1000023046 1000023047 1000023048 1000023049 1000023050 1000023051 1000023052 1000023053 1000023054 1000023056 1000023057 1000023058 1000023059 1000023060 1000023061 1000023062 1000023063 1000023065 1000023066 1000023067 1000023068 1000023069 1000023070 1000023071 1000023072 1000023073 1000023074 1000023075 1000023076 1000023432 1000023433 1000023434 1000017356 1000023637 1000023671 1000021543 1000023999 1000024029 1000024172 1000024182 1000024185 1000024186 1000024187 1000024188 1000024189 1000024190 1000024191 1000024192 1000024209 1000024211 1000024212 1000024213 1000024215 1000024216 1000024217 1000024218 1000024221 1000024222 1000024223 1000024224 1000024225 1000024321 1000024329 1000024332 1000024353 1000024495 1000024767 1000024771 1000024794 1000024795 1000024796 1000024799 1000024804 1000012892 1000025157 1000025159 1000025201 1000025203 1000025204 1000025205 1000025206 1000025208 1000025210 1000025211 1000025496 1000025578 1000025646 1000022794 1000026417 1000026421 1000026422 1000026423 1000026424 1000026425 1000026426 1000026427 1000026428 1000026187 1000026471 1000022574 1000006166 1000008043 1000012798 1000026722 1000026726 1000026728 1000026732 1000026735 1000026737 1000026739 1000026765 1000026880 1000026915 1000026928 1000026929 1000026934 1000027004 1000027132 1000027298 1000027300 1000027301 1000027302 1000027304 1000027306 1000002882 1000027309 1000027310 1000027312 1000027315 1000027316 1000027317 1000027319 1000027320 1000027321 1000027322 1000027323 1000027324 1000027325 1000027326 1000027328 1000027330 1000027331 1000027333 1000027334 1000027335 1000027336 1000027338 1000027339 1000027341 1000027342 1000027343 1000027344 1000027362 1000027388 1000027391 1000027393 1000027396 1000017580 1000027428 1000027452 1000027454 1000027457 1000027458 1000027463 1000027468 1000022187 1000027551 1000027804 1000027805 1000027806 1000019834 1000028454 1000028456 1000028458 1000028460 1000028461 1000028462 1000028463 1000028464 1000028465 1000028466 1000028467 1000028468 1000028469 1000028470 1000028471 1000028472 1000028473 1000028474 1000028475 1000028477 1000028479 1000028480 1000028481 1000028482 1000028484 1000028485 1000028486 1000028494 1000028495 1000028496 1000028497 1000028498 1000028499 1000028500 1000028501 1000028502 1000028503 1000028504 1000028505 1000028506 1000028507 1000028508 1000028509 1000028510 1000028511 1000028512 1000028513 1000028514 1000028515 1000028516 1000028517 1000028518 1000028519 1000028520 1000028521 1000028643 1000028644 1000028684 1000028872 1000012149 1000014104 1000010363 1000028997 1000015633 1000029107 1000019378 1000020577 1000025609 1000029528 1000029365 1000029921 1000029954 1000015067 1000030207 1000030218 1000031389 1000031391 1000031400 1000031409 1000031411 1000031414 1000031415 1000031417 1000031419 1000031420 1000031421 1000031422 1000031423 1000031425 1000031429 1000031431 1000031434 1000031435 1000031437 1000031440 1000031444 1000031445 1000031449 1000031450 1000031452 1000031453 1000031454 1000031456 1000031458 1000031459 1000031460 1000031461 1000031462 1000031463 1000031464 1000031465 1000031466 1000028651 1000031569 1000031666 1000031667 1000031917 1000031923 1000031936 1000031952 1000031955 1000031966 1000031967 1000031970 1000031971 1000031972 1000031973 1000031974 1000031975 1000031976 1000031977 1000031978 1000013398 1000032097 1000032099 1000032102 1000032103 1000032104 1000023685 1000032030 1000028620 1000032763 1000016821 1000005600 1000033318 1000033319 1000018253 1000033667 1000033668 1000033669 1000033670 1000033671 1000033672 1000033673 1000033674 1000033675 1000033676 1000027138 1000021214 1000016932 1000033626 1000034046 1000034048 1000034056 1000034057 1000034063 1000019123 1000012650 1000032524 1000034464 1000034466 1000014806 1000034478 1000034480 1000034496 1000034497 1000034498 1000034592 1000034636 1000006407 1000034690 1000034746 1000034750 1000035381 1000035383 1000035388 1000035415 1000035416 1000016774 1000028700 1000035634 1000035404 1000035870 1000035894 1000035898 1000035912 1000035971 1000035974 1000035980 1000035984 1000035988 1000035990 1000036009 1000036015 1000025365 1000036185 1000025990 1000036390 1000036494 1000036514 1000036540 1000036690 1000037006 1000037007 1000037008 1000022806 1000037528 1000037829 1000037832 1000037834 1000037835 1000037836 1000037838 1000037839 1000037841 1000037842 1000037843 1000037844 1000037845 1000037846 1000037847 1000037848 1000037849 1000037858 1000037861 1000037863 1000037873 1000037874 1000037875 1000037876 1000037877 1000037878 1000037879 1000037880 1000037881 1000037897 1000037898 1000037920 1000037925 1000037935 1000037936 1000037937 1000037938 1000037939 1000037940 1000037941 1000037942 1000037943 1000037999 1000038002 1000038003 1000038004 1000038005 1000038009 1000038041 1000038043 1000038045 1000038047 1000038048 1000038049 1000038050 1000038051 1000038052 1000038055 1000038057 1000038058 1000038059 1000038060 1000038063 1000038064 1000038065 1000038067 1000038068 1000038069 1000038071 1000038072 1000038077 1000038078 1000038084 1000038311 1000038314 1000038339 1000038343 1000038534 1000038536 1000038537 1000038538 1000038539 1000038554 1000038557 1000038567 1000038568 1000038573 1000038845 1000039025 1000039718 1000040086 1000040111 1000040113 1000040118 1000040190 1000040192 1000040216 1000040339 1000040340 1000040479 1000040480 1000040517 1000040884 1000040888 1000040904 1000040905 1000040911 1000040977 1000041013 1000041033 1000041074 1000041075 1000041118 1000041119 1000041246 1000016436 1000039206 1000041462 1000041474 1000041168 1000041535 1000025165 1000041763 1000041765 1000039265 1000042079 1000042081 1000042082 1000042083 1000042085 1000042092 1000042093 1000042094 1000042095 1000042096 1000042097 1000042098 1000042099 1000042100 1000041940 1000041341 1000042382 1000042385 1000042457 1000042458 1000042459 1000042460 1000042573 1000024391 1000042865 1000042868 1000042962 1000041849 1000042978 1000014960 1000043394 1000043395 1000043396 1000043416 1000043417 1000043418 1000043419 1000043420 1000043424 1000043432 1000043434 1000043440 1000043441 1000043680 1000043858 1000044430 1000044976 1000039739 1000044984 1000045414 1000045541 1000045629 1000045630 1000045800 1000039476 1000046179 1000046205 1000046382 1000046575 1000046577 1000046578 1000046579 1000046580 1000046581 1000046583 1000046584 1000046586 1000046587 1000046588 1000046664 1000046665 1000046666 1000046667 1000046668 1000046669 1000046671 1000046672 1000046673 1000046675 1000046677 1000046678 1000046679 1000046680 1000046681 1000046682 1000046683 1000046684 1000046685 1000046686 1000046687 1000046688 1000046689 1000046691 1000046692 1000046693 1000046694 1000046695 1000046862 1000046919 1000046920 1000046934 1000040065 1000047246 1000047253 1000047262 1000046206 1000046444 1000047646 1000047727 1000047776 1000047778 1000047825 1000047840 1000042462 1000047872 1000047975 1000025959 1000048226 1000048252 1000032497 1000048242 1000038606 1000048561 1000048565 1000048290 1000048591 1000048592 1000048596 1000048619 1000048629 1000048787 1000048788 1000048919 1000048947 1000025427 1000049105 1000049485 1000049495 1000026983 1000048900 1000049588 1000049602 1000049603 1000049633 1000049652 1000049703 1000049834 1000049717 1000049904 1000046277 1000049953 1000049954 1000049971 1000049973 1000050028 1000050032 1000050076 1000050218 1000042525 1000042943 1000050305 1000050309 1000050310 1000029115 1000050249 1000048192 1000050478 1000029598 1000050419 1000050823 1000050565 1000050887 1000038879 1000049106 1000051300 1000051317 1000050982 1000051405 1000022825 1000051513 1000051525 1000051532 1000051534 1000051593 1000037010 1000051692 1000051694 1000051695 1000051732 1000051755 1000051770 1000051843 1000049870 1000051504 1000051928 1000051962 1000048804 1000051713 1000051280 1000052100 1000050857 1000051896 1000052226 1000052244 1000052173 1000052279 1000048990 1000052355 1000051572 1000051886 1000052015 1000052570 1000052630 1000052647 1000052757 1000052044 1000052873 1000052887 1000052965 1000052977 1000053030 1000053035 1000053087 1000048053 1000051749 1000053184 1000050979 1000053298 1000050207 1000048580 1000053333 1000053362 1000053367 1000053368 1000052715 1000053466 9450] 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 (6337068, 6337721, 6337961, 6337988, 6338011, 6338415, 6338529, 6338609, 6338772, 6338814, 6338934, 6314723, 6339040, 6339093, 6339126, 6339182, 6339625, 6339630, 6339739, 6340364, 6340393, 6338714, 6340459, 6340700, 6340720, 6319924, 6320819, 6322449, 6340813, 6340827, 6340978, 6341047, 6341068, 6341385, 6316483, 6316833, 6316881, 6341758, 6341760, 6341932, 6341996, 6342011, 6342840, 6344252, 6343823, 6344273, 6344343, 6344369, 6344559, 6344811, 6344872, 6345859, 6346074, 6342221, 6346440, 6346491, 6346496, 6346631, 6346635, 6346819, 6346975, 6347176, 6347412, 6347461, 6347860, 6347914, 6347939, 6348160, 6348200, 6348201, 6348222, 6348231, 6348236, 6348250, 6348262, 6348265, 6348267, 6348297, 6348307, 6348352, 6348393, 6348404, 6348451, 6348453, 6348504, 6348515, 6348519, 6348706, 6348739, 6348740, 6348745, 6348749, 6348751, 6348831, 6348840, 6348870, 6348895, 6348896, 6349025, 6349027, 6349029, 6349075, 6349126, 6349132, 6349138, 6349175, 6349190, 6349191, 6349216, 6349238, 6349239, 6349242, 6349263, 6349280, 6349291, 6349295, 6349316, 6349511, 6349538, 6349689, 6349748, 6349822, 6349840, 6349961, 6349962, 6349971, 6349991, 6350031, 6350036, 6350074, 6350076, 6350077, 6350207, 6350211, 6350221, 6350243, 6350248, 6350322, 6350326, 6350341, 6350346, 6350347, 6350348, 6350367, 6350398, 6350426, 6350442, 6350444, 6350473, 6350547, 6350558, 6350751, 6344576, 6350986, 6350994, 6351056, 6351163, 6351657, 6351789, 6351849, 6351882, 6352068, 6352387, 6352662, 6352819, 6351112, 6352911, 6352923, 6353019, 6353228, 6353302, 6353388, 6353707, 6353801, 6353819, 6353927, 6354008, 6354628, 6354739, 6355380, 6355502, 6355618, 6356010, 6340660, 6356842, 6357422, 6357440, 6357453, 6357663, 6357879, 6358230, 6358498, 6358599, 6359462, 6360101, 6358744, 6362095, 6362822, 6364027, 6364691, 6365066, 6365182, 6365209, 6365502, 6365718, 6365687, 6366788, 6367438, 6367473, 6367474, 6367476, 6367479, 6367548, 6367822, 6368369, 6368267, 6368344, 6368252, 6368562, 6368296, 6368394, 6368523, 6368686, 6368246, 6368455, 6368534, 6369153, 6369226, 6369917, 6370007, 6370264, 6370284, 6370423, 6370530, 6370860, 6370862, 6370913, 6371156, 6371311, 6371789, 6371795, 6371892, 6371896, 6371916, 6372081, 6372090, 6372264, 6372694, 6372815, 6372880, 6373070, 6373085, 6373188, 6373248, 6373249, 6373324, 6373353, 6373548, 6373843, 6373963, 6368302, 6368341, 6368367, 6368482, 6368697, 6368729, 6368838, 6368852, 6368915, 6368386, 6368851, 6373990, 6374084, 6374138, 6374154, 6374158, 6374173, 6374204, 6374219, 6374221, 6374231, 6374278, 6374283, 6374318, 6374324, 6374326, 6368726, 6374356, 6374401, 6368974, 6374487, 6374530, 6368575, 6374290, 6374695, 6374854, 6374878, 6374882, 6374953, 6368397, 6368698, 6374181, 6374277, 6374630, 6368472, 6374721, 6375050, 6375346, 6375350, 6374653, 6375404, 6375494, 6375246, 6375544, 6374706, 6368768, 6375893, 6376089, 6376108, 6376188, 6376236, 6376326, 6376327, 6368843, 6376390, 6374433, 6374466, 6374622, 6375229, 6375488, 6376244, 6376419, 6376491, 6376505, 6376591, 6376612, 6376691, 6376712, 6376772, 6376558, 6376825, 6376882, 6376646, 6377226, 6377256, 6377281, 6377312, 6377330, 6377332, 6377349, 6377388, 6377394, 6377399, 6377402, 6377511, 6377530, 6376284, 6377659, 6375687, 6377995, 6377997, 6378340, 6378297, 6378560, 6378633, 6378654, 6378744, 6378775, 6364293, 6378813, 6378864, 6378944, 6378957, 6378992, 6379108, 6379149, 6379194, 6379199, 6379496, 6379594, 6379709, 6379723, 6379724, 6379779, 6379792, 6379838, 6379544, 6379915, 6379996, 6380119, 6380246, 6380275, 6380341, 6380423, 6380482, 6380816, 6381258, 6381506, 6381637, 6381664, 6381687, 6377147, 6382201, 6382307, 6382360, 6382489, 6382596, 6382601, 6382651, 6382655, 6382656, 6382689, 6382726, 6381411, 6382826, 6382877, 6383101, 6383109, 6383110, 6383181, 6382869, 6383591, 6383882, 6383977, 6384126, 6384128, 6384375, 6384501, 6384702, 6385159, 6385166, 6377912, 6385475, 6380834, 6385458, 6386460, 6386582, 6386700, 6386872, 6386933, 6386964, 6386981, 6386988, 6387009, 6387105, 6386776, 6387536, 6387693, 6386584, 6387723, 6388134, 6365625, 6388161, 6388187, 6388262, 6388303, 6388330, 6388338, 6387721, 6388449, 6388581, 6388644, 6388751, 6389069, 6389120, 6389121, 6389174, 6389181, 6376087, 6389429, 6389440, 6389445, 6389655, 6389826, 6386995, 6385287, 6390053, 6390056, 6390074, 6388696, 6390336, 6390511, 6390556, 6390707, 6390963, 6385922, 6391146, 6391138, 6391168, 6391192, 6391196, 6391498, 6389078, 6391818, 6365356, 6391931, 6391981, 6391983, 6392021, 6392040, 6392049, 6392106, 6392282, 6392207, 6392489, 6392708, 6393058, 6393151, 6393241, 6393273, 6393285, 6393339, 6393408, 6393511, 6381461, 6393024, 6388629, 6393608, 6393635, 6393826, 6393874, 6394046, 6394065, 6393601, 6394452, 6394496, 6394544, 6394675, 6394683, 6394820, 6395219, 6395302, 6395406, 6395466, 6395861, 6395871, 6396240, 6396242, 6396427, 6396473, 6396493, 6396667, 6396728, 6396762, 6396772, 6396779, 6396821, 6396826, 6396827, 6396841, 6396860, 6396861, 6396866, 6396887, 6396896, 6396912, 6396922, 6396924, 6396926, 6396930, 6396939, 6396955, 6396998, 6397021, 6397118, 6397131, 6397134, 6397135, 6397151, 6397275, 6397293, 6397314, 6397363, 6397364, 6397373, 6397408, 6397467, 6397543, 6397607, 6397658, 6397677, 6397678, 6397682, 6397735, 6397796, 6397808, 6397814, 6397856, 6397859, 6397865, 6397919, 6398010, 6398016, 6398041, 6398057, 6398075, 6398309, 6398534, 6398693, 6398741, 6398861, 6398877, 6398879, 6398975, 6398982, 6399008, 6399037, 6399053, 6399072, 6399075, 6399093, 6399125, 6399131, 6399137, 6399147, 6399159, 6399205, 6399354, 6399355, 6399359, 6399368, 6399399, 6399400, 6399431, 6399444, 6399511, 6399512, 6399544, 6399573, 6400152, 6400223, 6400236, 6400297, 6400516, 6400731, 6400838, 6401313, 6401526, 6401617, 6401652, 6401671, 6401749, 6401976, 6402073, 6394148, 6402393, 6402421, 6402509, 6402790, 6402823, 6403117, 6403711, 6403850, 6404014, 6404207, 6404266, 6404535, 6405108, 6405154, 6405328, 6405661, 6405926, 6406253, 6405935, 6406376, 6406829, 6407083, 6407107, 6407146, 6407157, 6407421, 6407521, 6407533, 6407658, 6407657, 6407777, 6408003, 6408050, 6408058, 6408350, 6408543, 6408770, 6408826, 6409061, 6409304, 6409344, 6409704, 6410095, 6410196, 6410281, 6410884, 6410939, 6410954, 6411258, 6411858, 6411859, 6412026, 6412087, 6412840, 6412991, 6413045, 6413547, 6413562, 6413566, 6413585, 6414395, 6414872, 6414873, 6414874, 6414875, 6414876, 6414877, 6414878, 6414879, 6414880, 6414881, 6414882, 6414883, 6414884, 6414885, 6414886, 6414887, 6414888, 6414889, 6414890, 6414891, 6414892, 6414893, 6414894, 6414998, 6415040, 6415205, 6415248, 6415249, 6415250, 6415251, 6415252, 6415253, 6415254, 6415255, 6415256, 6415257, 6415258, 6415259, 6415261, 6415262, 6415263, 6415265, 6415266, 6415267, 6415268, 6415269, 6415270, 6415271, 6415272, 6415273, 6415482, 6415675, 6415704, 6415753, 6415818, 6415830, 6415831, 6415886, 6416038, 6416093, 6416257, 6416342, 6416599, 6416635, 6416980, 6417062, 6417315, 6417345, 6417391, 6417515, 6417541, 6417587, 6417694, 6417701, 6417704, 6417776, 6417876, 6417942, 6418115, 6418176, 6418265, 6418403, 6418406, 6418452, 6418590, 6418596, 6418605, 6418609, 6418641, 6418649, 6418661, 6418666, 6418726, 6418736, 6418750, 6418893, 6418935, 6418981, 6419188, 6419239, 6419322, 6419379, 6419391, 6419392, 6419421, 6419437, 6419570, 6419571, 6419576, 6419599, 6419674, 6419769, 6419825, 6419857, 6419884, 6419902, 6419907, 6419948, 6420000, 6420099, 6420153, 6420441, 6420459, 6420460, 6420541, 6420607, 6420695, 6421392, 6421536, 6421743, 6421798, 6421836, 6421837, 6421870, 6421916, 6421976, 6422032, 6422386, 6422340, 6422399, 6422401, 6422405, 6422412, 6422500, 6422649, 6422720, 6422876, 6422967, 6423077, 6423251, 6423654, 6423945, 6423996, 6424098, 6424135, 6424274, 6424318, 6424340, 6424495, 6424727, 6424901, 6424909, 6425270, 6425256, 6425291, 6425332, 6425344, 6425353, 6425393, 6425598, 6425756, 6426172, 6426183, 6426211, 6426373, 6426425, 6426427, 6426429, 6426441, 6426515, 6426601, 6426793, 6426828, 6426941, 6427073, 6427233, 6427266, 6427270, 6427315, 6427327, 6427351, 6427390, 6427631, 6427894, 6428422, 6428440, 6428557, 6428638, 6428663, 6428711, 6428793, 6428909, 6429272, 6429373, 6429449, 6429473, 6429587, 6429653, 6429680, 6429694, 6429695, 6429793, 6429872, 6430112, 6430285, 6430363, 6430462, 6430629, 6430664, 6430843, 6430872, 6430974, 6431111, 6431334, 6431527, 6431537, 6431672, 6431695, 6432046, 6432130, 6432176, 6432201, 6432205, 6432212, 6432225, 6432248, 6432342, 6432401, 6433544, 6433614, 6433679, 6433750, 6433779, 6433821, 6433838, 6433840, 6434035, 6434062, 6434215, 6434284, 6434361, 6434380, 6434600, 6434655, 6434696, 6434698, 6434911, 6434940, 6434942, 6434953, 6434955, 6434967, 6434982, 6434984, 6434997, 6434999, 6435020, 6435021, 6435207, 6435219, 6435220, 6435272, 6435298, 6435313, 6435636, 6435668, 6435829, 6435874, 6435913, 6435963, 6436002, 6436077, 6436250, 6436274, 6436442, 6436491, 6436793, 6436988, 6436996, 6437163, 6437169, 6437257, 6437258, 6437455, 6437701, 6437706, 6437726, 6437884, 6437945, 6438026, 6438044, 6438077, 6438096, 6438113, 6438784, 6439253, 6439594, 6439603, 6439615, 6439620, 6439635, 6439636, 6439743, 6439772, 6440149, 6440291, 6440359, 6440511, 6440985, 6440993, 6441140, 6441367, 6441371, 6441390, 6442107, 6442178, 6442195, 6442202, 6442244, 6442346, 6442459, 6442736, 6442769, 6443713, 6443723, 6443724, 6443740, 6443742, 6443885, 6444055, 6444057, 6444102, 6444284, 6444304, 6444364, 6444372, 6444619, 6444633, 6444750, 6444965, 6445327, 6445335, 6445637, 6445713, 6445793, 6445811, 6445968, 6446438, 6446480, 6446740, 6446743, 6446835, 6446955, 6447122, 6447130, 6447399, 6447454, 6447464, 6447642, 6448260, 6448265, 6448504, 6448606, 6448653, 6449112, 6449321, 6449371, 6449379, 6449513, 6449704, 6449769, 6449781, 6449819, 6449885, 6450106, 6450168, 6450199, 6450253, 6450281, 6450416, 6450604, 6450631, 6450654, 6450757, 6450760, 6450766, 6450767, 6450768, 6450932, 6450957, 6450989, 6450992, 6450996, 6451035, 6451090, 6451112, 6451221, 6451248, 6451303, 6451314, 6451349, 6451370, 6451371, 6451389, 6451404, 6451422, 6451435, 6451439, 6451616, 6451707, 6451771, 6452007, 6452041, 6452169, 6452214, 6452242, 6452272, 6452352, 6452404, 6452537, 6452570, 6452659, 6452776, 6452781, 6452813, 6452902, 6452913, 6452918, 6453010, 6453018, 6453035, 6453038, 6453039, 6453044, 6453055, 6453058, 6453085, 6453096, 6453101, 6453151, 6453211, 6453213, 6453263, 6453327, 6453378, 6453395, 6453471, 6453481, 6453646, 6453705, 6453726, 6453871, 6453872, 6453896, 6454025, 6454081, 6454140, 6454162, 6454176, 6454181, 6454247, 6454255, 6454258, 6454346, 6454396, 6454401, 6454431, 6454472, 6454475, 6454477, 6454531, 6454535, 6454536, 6454545, 6454560, 6454563, 6454719, 6454786, 6454852, 6454864, 6454865, 6454867, 6454985, 6455040, 6455119, 6455257, 6455292, 6455345, 6455375, 6455388, 6455451, 6455465, 6455477, 6455533, 6455579, 6455583, 6455606, 6455648, 6455702, 6455742, 6455781, 6455831, 6455842, 6455852, 6455884, 6455897, 6455933, 6455955, 6455985, 6456017, 6456120, 6456135, 6456232, 6456301, 6456304, 6456344, 6456365, 6456389, 6456431, 6456544, 6456581, 6456595, 6456619, 6456665, 6456694, 6456700, 6456780, 6456815, 6456816, 6457034, 6457046, 6457071, 6457246, 6457300, 6457513, 6457516, 6457520, 6457669, 6457885, 6458145, 6458386, 6458430, 6458501, 6458518, 6458523, 6458826, 6458876, 6458942, 6459444, 6459524, 6459953, 6459976, 6459989, 6460086, 6460099, 6460101, 6460173, 6460244, 6460417, 6460542, 6460632, 6460633, 6460635, 6460636, 6460637, 6460638, 6460639, 6460640, 6460641, 6460642, 6460643, 6460644, 6460645, 6460646, 6460647, 6460648, 6460649, 6460650, 6460651, 6460652, 6460653, 6460654, 6460655, 6460656, 6460657, 6460658, 6460659, 6460660, 6460661, 6460662, 6460663, 6460664, 6460665, 6460666, 6460667, 6460668, 6460669, 6460670, 6460671, 6460672, 6460674, 6460675, 6460676, 6460677, 6460678, 6460680, 6460681, 6460682, 6460683, 6460684, 6460686, 6460687, 6460688, 6460689, 6460690, 6460691, 6460692, 6460693, 6460694, 6460695, 6460696, 6460697, 6460698, 6460699, 6460700, 6460701, 6460702, 6460703, 6460704, 6460705, 6460706, 6460707, 6460708, 6460709, 6460710, 6460711, 6460712, 6460713, 6460714, 6460715, 6460716, 6460717, 6460718, 6460719, 6460726, 6460727, 6460728, 6460729, 6460730, 6460731, 6460732, 6460733, 6460734, 6460735, 6460736, 6460737, 6460738, 6460739, 6460740, 6460741, 6460742, 6460743, 6460744, 6460745, 6460746, 6460747, 6460748, 6460749, 6460750, 6460751, 6460752, 6460753, 6460754, 6460755, 6460756, 6460757, 6460758, 6460759, 6460760, 6460761, 6460762, 6460763, 6460765, 6460767, 6460768, 6460769, 6460770, 6460771, 6460772, 6460773, 6460774, 6460775, 6460776, 6460777, 6460778, 6460779, 6460780, 6460781, 6460782, 6460783, 6460784, 6460785, 6460786, 6460787, 6460788, 6460789, 6460790, 6460791, 6460793, 6460794, 6460795, 6460796, 6460797, 6460798, 6460799, 6460800, 6460927, 6461020, 6461300, 6461304, 6461335, 6461357, 6461395, 6461416, 6461655, 6461668, 6461914, 6462256, 6462351, 6462540, 6462857, 6462967, 6463032, 6463173, 6463212, 6463607, 6463681, 6463729, 6464264, 6464291, 6464535, 6464644, 6464754, 6464880, 6465254, 6465286, 6465287, 6465291, 6465783, 6465809, 6466397, 6466622, 6467091, 6467455, 6467464, 6468056, 6468060, 6468545, 6468618, 6468669, 6468676, 6394945, 6392474, 6390888, 1000002184, 1000002494, 1000002646, 1000002669, 1000002906, 1000002930, 1000002465, 1000004031, 6391971, 1000004129, 1000004367, 1000004368, 1000004492, 1000004681, 1000004683, 1000004707, 1000004711, 1000004740, 1000002528, 6390715, 6390633, 1000001832, 1000001476, 1000005189, 1000005267, 1000005295, 1000005409, 1000005411, 1000005524, 1000004780, 1000002318, 1000005877, 1000006974, 1000006985, 1000006987, 1000007368, 1000007838, 1000008023, 1000008034, 1000008365, 1000008481, 1000008489, 1000008827, 1000008866, 1000008877, 1000008986, 1000009130, 1000009546, 1000009547, 1000009548, 1000009553, 1000009554, 1000009556, 1000009557, 1000009558, 1000009684, 1000009918, 1000009989, 1000009992, 1000010337, 1000010358, 1000010410, 1000010411, 1000010412, 1000010413, 1000010414, 1000010415, 1000010416, 1000010419, 1000010420, 1000010437, 1000010556, 1000005996, 1000010662, 1000010694, 1000010764, 1000010741, 1000010803, 1000006779, 1000011064, 1000011844, 1000011884, 1000011970, 1000012025, 1000012026, 1000012152, 1000012228, 6381331, 1000012495, 1000012598, 1000012676, 1000012741, 1000012779, 1000012782, 1000012958, 1000009545, 1000011869, 1000013407, 1000003879, 1000005320, 1000013413, 1000000852, 6394126, 1000012768, 1000012385, 1000008795, 1000013803, 1000013806, 1000013888, 1000012456, 1000013967, 1000005938, 1000009448, 1000012850, 1000013909, 1000014363, 1000012721, 1000014400, 1000014524, 1000014574, 1000014658, 6384068, 1000014685, 1000014773, 1000014774, 1000014797, 1000014802, 1000005543, 1000014985, 1000013586, 1000014039, 1000009611, 1000015277, 1000010474, 1000014450, 1000015548, 1000009154, 1000015654, 1000015411, 1000003030, 1000015780, 1000015745, 1000015791, 1000015851, 1000014003, 1000016204, 1000016205, 1000016207, 1000016410, 1000002598, 1000013981, 1000016780, 1000016793, 1000016942, 1000016871, 1000017062, 1000017064, 1000017067, 1000017068, 1000017069, 1000017070, 1000017219, 1000017236, 1000017268, 1000017280, 1000017283, 1000012821, 1000012275, 1000017330, 1000017300, 1000017338, 1000017579, 1000017587, 1000017719, 1000017752, 1000015332, 1000017754, 1000018749, 1000018784, 1000018605, 1000018662, 1000018558, 1000019055, 1000019065, 1000019083, 1000019100, 1000019104, 1000019115, 1000019136, 1000019212, 1000019248, 1000016960, 1000018597, 1000016738, 1000010744, 1000019565, 1000019753, 1000018964, 1000017387, 1000016411, 1000019946, 1000004135, 1000016983, 1000018376, 1000017310, 1000019018, 1000017342, 1000017257, 1000019121, 1000016687, 1000012396, 1000018731, 1000020929, 1000020930, 1000006972, 1000020971, 1000016353, 1000020877, 1000020896, 1000017335, 1000020106, 1000002102, 1000001497, 1000000919, 1000022114, 1000022115, 1000019611, 1000017434, 1000018448, 1000022325, 1000022344, 6393101, 1000022394, 1000022485, 1000017425, 1000021400, 1000022611, 1000018922, 1000020883, 1000022571, 1000009774, 1000009773, 1000016998, 1000020453, 1000012677, 1000009690, 1000023013, 1000023014, 1000023015, 1000023016, 1000023017, 1000023019, 1000023020, 1000023021, 1000023038, 1000023039, 1000023040, 1000023041, 1000023042, 1000023043, 1000023044, 1000023046, 1000023047, 1000023048, 1000023049, 1000023050, 1000023051, 1000023052, 1000023053, 1000023054, 1000023056, 1000023057, 1000023058, 1000023059, 1000023060, 1000023061, 1000023062, 1000023063, 1000023065, 1000023066, 1000023067, 1000023068, 1000023069, 1000023070, 1000023071, 1000023072, 1000023073, 1000023074, 1000023075, 1000023076, 1000023432, 1000023433, 1000023434, 1000017356, 1000023637, 1000023671, 1000021543, 1000023999, 1000024029, 1000024172, 1000024182, 1000024185, 1000024186, 1000024187, 1000024188, 1000024189, 1000024190, 1000024191, 1000024192, 1000024209, 1000024211, 1000024212, 1000024213, 1000024215, 1000024216, 1000024217, 1000024218, 1000024221, 1000024222, 1000024223, 1000024224, 1000024225, 1000024321, 1000024329, 1000024332, 1000024353, 1000024495, 1000024767, 1000024771, 1000024794, 1000024795, 1000024796, 1000024799, 1000024804, 1000012892, 1000025157, 1000025159, 1000025201, 1000025203, 1000025204, 1000025205, 1000025206, 1000025208, 1000025210, 1000025211, 1000025496, 1000025578, 1000025646, 1000022794, 1000026417, 1000026421, 1000026422, 1000026423, 1000026424, 1000026425, 1000026426, 1000026427, 1000026428, 1000026187, 1000026471, 1000022574, 1000006166, 1000008043, 1000012798, 1000026722, 1000026726, 1000026728, 1000026732, 1000026735, 1000026737, 1000026739, 1000026765, 1000026880, 1000026915, 1000026928, 1000026929, 1000026934, 1000027004, 1000027132, 1000027298, 1000027300, 1000027301, 1000027302, 1000027304, 1000027306, 1000002882, 1000027309, 1000027310, 1000027312, 1000027315, 1000027316, 1000027317, 1000027319, 1000027320, 1000027321, 1000027322, 1000027323, 1000027324, 1000027325, 1000027326, 1000027328, 1000027330, 1000027331, 1000027333, 1000027334, 1000027335, 1000027336, 1000027338, 1000027339, 1000027341, 1000027342, 1000027343, 1000027344, 1000027362, 1000027388, 1000027391, 1000027393, 1000027396, 1000017580, 1000027428, 1000027452, 1000027454, 1000027457, 1000027458, 1000027463, 1000027468, 1000022187, 1000027551, 1000027804, 1000027805, 1000027806, 1000019834, 1000028454, 1000028456, 1000028458, 1000028460, 1000028461, 1000028462, 1000028463, 1000028464, 1000028465, 1000028466, 1000028467, 1000028468, 1000028469, 1000028470, 1000028471, 1000028472, 1000028473, 1000028474, 1000028475, 1000028477, 1000028479, 1000028480, 1000028481, 1000028482, 1000028484, 1000028485, 1000028486, 1000028494, 1000028495, 1000028496, 1000028497, 1000028498, 1000028499, 1000028500, 1000028501, 1000028502, 1000028503, 1000028504, 1000028505, 1000028506, 1000028507, 1000028508, 1000028509, 1000028510, 1000028511, 1000028512, 1000028513, 1000028514, 1000028515, 1000028516, 1000028517, 1000028518, 1000028519, 1000028520, 1000028521, 1000028643, 1000028644, 1000028684, 1000028872, 1000012149, 1000014104, 1000010363, 1000028997, 1000015633, 1000029107, 1000019378, 1000020577, 1000025609, 1000029528, 1000029365, 1000029921, 1000029954, 1000015067, 1000030207, 1000030218, 1000031389, 1000031391, 1000031400, 1000031409, 1000031411, 1000031414, 1000031415, 1000031417, 1000031419, 1000031420, 1000031421, 1000031422, 1000031423, 1000031425, 1000031429, 1000031431, 1000031434, 1000031435, 1000031437, 1000031440, 1000031444, 1000031445, 1000031449, 1000031450, 1000031452, 1000031453, 1000031454, 1000031456, 1000031458, 1000031459, 1000031460, 1000031461, 1000031462, 1000031463, 1000031464, 1000031465, 1000031466, 1000028651, 1000031569, 1000031666, 1000031667, 1000031917, 1000031923, 1000031936, 1000031952, 1000031955, 1000031966, 1000031967, 1000031970, 1000031971, 1000031972, 1000031973, 1000031974, 1000031975, 1000031976, 1000031977, 1000031978, 1000013398, 1000032097, 1000032099, 1000032102, 1000032103, 1000032104, 1000023685, 1000032030, 1000028620, 1000032763, 1000016821, 1000005600, 1000033318, 1000033319, 1000018253, 1000033667, 1000033668, 1000033669, 1000033670, 1000033671, 1000033672, 1000033673, 1000033674, 1000033675, 1000033676, 1000027138, 1000021214, 1000016932, 1000033626, 1000034046, 1000034048, 1000034056, 1000034057, 1000034063, 1000019123, 1000012650, 1000032524, 1000034464, 1000034466, 1000014806, 1000034478, 1000034480, 1000034496, 1000034497, 1000034498, 1000034592, 1000034636, 1000006407, 1000034690, 1000034746, 1000034750, 1000035381, 1000035383, 1000035388, 1000035415, 1000035416, 1000016774, 1000028700, 1000035634, 1000035404, 1000035870, 1000035894, 1000035898, 1000035912, 1000035971, 1000035974, 1000035980, 1000035984, 1000035988, 1000035990, 1000036009, 1000036015, 1000025365, 1000036185, 1000025990, 1000036390, 1000036494, 1000036514, 1000036540, 1000036690, 1000037006, 1000037007, 1000037008, 1000022806, 1000037528, 1000037829, 1000037832, 1000037834, 1000037835, 1000037836, 1000037838, 1000037839, 1000037841, 1000037842, 1000037843, 1000037844, 1000037845, 1000037846, 1000037847, 1000037848, 1000037849, 1000037858, 1000037861, 1000037863, 1000037873, 1000037874, 1000037875, 1000037876, 1000037877, 1000037878, 1000037879, 1000037880, 1000037881, 1000037897, 1000037898, 1000037920, 1000037925, 1000037935, 1000037936, 1000037937, 1000037938, 1000037939, 1000037940, 1000037941, 1000037942, 1000037943, 1000037999, 1000038002, 1000038003, 1000038004, 1000038005, 1000038009, 1000038041, 1000038043, 1000038045, 1000038047, 1000038048, 1000038049, 1000038050, 1000038051, 1000038052, 1000038055, 1000038057, 1000038058, 1000038059, 1000038060, 1000038063, 1000038064, 1000038065, 1000038067, 1000038068, 1000038069, 1000038071, 1000038072, 1000038077, 1000038078, 1000038084, 1000038311, 1000038314, 1000038339, 1000038343, 1000038534, 1000038536, 1000038537, 1000038538, 1000038539, 1000038554, 1000038557, 1000038567, 1000038568, 1000038573, 1000038845, 1000039025, 1000039718, 1000040086, 1000040111, 1000040113, 1000040118, 1000040190, 1000040192, 1000040216, 1000040339, 1000040340, 1000040479, 1000040480, 1000040517, 1000040884, 1000040888, 1000040904, 1000040905, 1000040911, 1000040977, 1000041013, 1000041033, 1000041074, 1000041075, 1000041118, 1000041119, 1000041246, 1000016436, 1000039206, 1000041462, 1000041474, 1000041168, 1000041535, 1000025165, 1000041763, 1000041765, 1000039265, 1000042079, 1000042081, 1000042082, 1000042083, 1000042085, 1000042092, 1000042093, 1000042094, 1000042095, 1000042096, 1000042097, 1000042098, 1000042099, 1000042100, 1000041940, 1000041341, 1000042382, 1000042385, 1000042457, 1000042458, 1000042459, 1000042460, 1000042573, 1000024391, 1000042865, 1000042868, 1000042962, 1000041849, 1000042978, 1000014960, 1000043394, 1000043395, 1000043396, 1000043416, 1000043417, 1000043418, 1000043419, 1000043420, 1000043424, 1000043432, 1000043434, 1000043440, 1000043441, 1000043680, 1000043858, 1000044430, 1000044976, 1000039739, 1000044984, 1000045414, 1000045541, 1000045629, 1000045630, 1000045800, 1000039476, 1000046179, 1000046205, 1000046382, 1000046575, 1000046577, 1000046578, 1000046579, 1000046580, 1000046581, 1000046583, 1000046584, 1000046586, 1000046587, 1000046588, 1000046664, 1000046665, 1000046666, 1000046667, 1000046668, 1000046669, 1000046671, 1000046672, 1000046673, 1000046675, 1000046677, 1000046678, 1000046679, 1000046680, 1000046681, 1000046682, 1000046683, 1000046684, 1000046685, 1000046686, 1000046687, 1000046688, 1000046689, 1000046691, 1000046692, 1000046693, 1000046694, 1000046695, 1000046862, 1000046919, 1000046920, 1000046934, 1000040065, 1000047246, 1000047253, 1000047262, 1000046206, 1000046444, 1000047646, 1000047727, 1000047776, 1000047778, 1000047825, 1000047840, 1000042462, 1000047872, 1000047975, 1000025959, 1000048226, 1000048252, 1000032497, 1000048242, 1000038606, 1000048561, 1000048565, 1000048290, 1000048591, 1000048592, 1000048596, 1000048619, 1000048629, 1000048787, 1000048788, 1000048919, 1000048947, 1000025427, 1000049105, 1000049485, 1000049495, 1000026983, 1000048900, 1000049588, 1000049602, 1000049603, 1000049633, 1000049652, 1000049703, 1000049834, 1000049717, 1000049904, 1000046277, 1000049953, 1000049954, 1000049971, 1000049973, 1000050028, 1000050032, 1000050076, 1000050218, 1000042525, 1000042943, 1000050305, 1000050309, 1000050310, 1000029115, 1000050249, 1000048192, 1000050478, 1000029598, 1000050419, 1000050823, 1000050565, 1000050887, 1000038879, 1000049106, 1000051300, 1000051317, 1000050982, 1000051405, 1000022825, 1000051513, 1000051525, 1000051532, 1000051534, 1000051593, 1000037010, 1000051692, 1000051694, 1000051695, 1000051732, 1000051755, 1000051770, 1000051843, 1000049870, 1000051504, 1000051928, 1000051962, 1000048804, 1000051713, 1000051280, 1000052100, 1000050857, 1000051896, 1000052226, 1000052244, 1000052173, 1000052279, 1000048990, 1000052355, 1000051572, 1000051886, 1000052015, 1000052570, 1000052630, 1000052647, 1000052757, 1000052044, 1000052873, 1000052887, 1000052965, 1000052977, 1000053030, 1000053035, 1000053087, 1000048053, 1000051749, 1000053184, 1000050979, 1000053298, 1000050207, 1000048580, 1000053333, 1000053362, 1000053367, 1000053368, 1000052715, 1000053466) AND p0_.id <> 9450 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;
322.74 ms (7.88%)	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: [`"42374-intercalaires-assorties-exacompta-1612e"`] 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 = '42374-intercalaires-assorties-exacompta-1612e' AND p0_.is_active = 1;
6.67 ms (0.16%)	6	SELECT d0_.id AS id_0, d0_.quantity AS quantity_1, d0_.price_ht AS price_ht_2, d0_.price_ttc AS price_ttc_3, d0_.product_id AS product_id_4, d0_.product_price_id AS product_price_id_5, d0_.promotion_id AS promotion_id_6, d0_.market_id AS market_id_7 FROM decreasing_price d0_ WHERE d0_.product_id = ? AND d0_.quantity <= ? AND d0_.market_id IS NULL AND d0_.product_price_id IS NULL AND d0_.promotion_id IS NULL ORDER BY d0_.quantity DESC LIMIT 1 Parameters: [`80097 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 = 80097 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;
5.81 ms (0.14%)	12	SELECT t0.id AS id_1, t0.price_ht AS price_ht_2, t0.price_ttc AS price_ttc_3, t0.price_id AS price_id_4, t0.product_id AS product_id_5 FROM product_price t0 WHERE t0.price_id = ? AND t0.product_id = ? LIMIT 1 Parameters: [`"CAISSE2011" 80097`] 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 = 80097 LIMIT 1;
4.93 ms (0.12%)	6	SELECT d0_.quantity AS quantity_0, d0_.price_ht AS price_ht_1, d0_.price_ttc AS price_ttc_2 FROM decreasing_price d0_ WHERE d0_.product_id = ? AND d0_.market_id IS NULL AND d0_.product_price_id IS NULL AND d0_.promotion_id IS NULL ORDER BY d0_.quantity DESC Parameters: [`80097`] 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 = 80097 AND d0_.market_id IS NULL AND d0_.product_price_id IS NULL AND d0_.promotion_id IS NULL ORDER BY d0_.quantity DESC;
3.70 ms (0.09%)	20	SELECT t0.id AS id_1, t0.name AS name_2, t0.value1 AS value1_3, t0.value2 AS value2_4, t0.value3 AS value3_5 FROM parameter t0 WHERE t0.name = ? LIMIT 1 Parameters: [`"ourClientsAlsoBoughtMonths"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.value1 AS value1_3, t0.value2 AS value2_4, t0.value3 AS value3_5 FROM parameter t0 WHERE t0.name = ? LIMIT 1 SELECT t0.id AS id_1, t0.name AS name_2, t0.value1 AS value1_3, t0.value2 AS value2_4, t0.value3 AS value3_5 FROM parameter t0 WHERE t0.name = 'ourClientsAlsoBoughtMonths' LIMIT 1;
2.72 ms (0.07%)	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.61 ms (0.06%)	3	SELECT t0.id AS id_1, t0.value AS value_2, t0.product_id AS product_id_3, t0.characteristic_label_id AS characteristic_label_id_4 FROM characteristic t0 WHERE t0.product_id = ? AND t0.characteristic_label_id = ? LIMIT 1 Parameters: [`563860 7`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.value AS value_2, t0.product_id AS product_id_3, t0.characteristic_label_id AS characteristic_label_id_4 FROM characteristic t0 WHERE t0.product_id = ? AND t0.characteristic_label_id = ? LIMIT 1 SELECT t0.id AS id_1, t0.value AS value_2, t0.product_id AS product_id_3, t0.characteristic_label_id AS characteristic_label_id_4 FROM characteristic t0 WHERE t0.product_id = 563860 AND t0.characteristic_label_id = 7 LIMIT 1;
2.42 ms (0.06%)	12	SELECT t0.id AS id_1, t0.name AS name_2, t0.affiliated_society AS affiliated_society_3, t0.address1 AS address1_4, t0.address2 AS address2_5, t0.address3 AS address3_6, t0.zip_code AS zip_code_7, t0.city AS city_8, t0.email AS email_9, t0.phone_number AS phone_number_10, t0.fax AS fax_11, t0.id_deposit AS id_deposit_12, t0.gen_code AS gen_code_13, t0.newspaper AS newspaper_14, t0.siren AS siren_15, t0.ape AS ape_16, t0.trading_registry AS trading_registry_17, t0.internal_tva AS internal_tva_18, t0.rib AS rib_19, t0.general_account AS general_account_20, t0.capital AS capital_21 FROM society t0 WHERE t0.id = ? LIMIT 1 Parameters: [`"MOZ"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.affiliated_society AS affiliated_society_3, t0.address1 AS address1_4, t0.address2 AS address2_5, t0.address3 AS address3_6, t0.zip_code AS zip_code_7, t0.city AS city_8, t0.email AS email_9, t0.phone_number AS phone_number_10, t0.fax AS fax_11, t0.id_deposit AS id_deposit_12, t0.gen_code AS gen_code_13, t0.newspaper AS newspaper_14, t0.siren AS siren_15, t0.ape AS ape_16, t0.trading_registry AS trading_registry_17, t0.internal_tva AS internal_tva_18, t0.rib AS rib_19, t0.general_account AS general_account_20, t0.capital AS capital_21 FROM society t0 WHERE t0.id = ? LIMIT 1 SELECT t0.id AS id_1, t0.name AS name_2, t0.affiliated_society AS affiliated_society_3, t0.address1 AS address1_4, t0.address2 AS address2_5, t0.address3 AS address3_6, t0.zip_code AS zip_code_7, t0.city AS city_8, t0.email AS email_9, t0.phone_number AS phone_number_10, t0.fax AS fax_11, t0.id_deposit AS id_deposit_12, t0.gen_code AS gen_code_13, t0.newspaper AS newspaper_14, t0.siren AS siren_15, t0.ape AS ape_16, t0.trading_registry AS trading_registry_17, t0.internal_tva AS internal_tva_18, t0.rib AS rib_19, t0.general_account AS general_account_20, t0.capital AS capital_21 FROM society t0 WHERE t0.id = 'MOZ' LIMIT 1;
1.84 ms (0.04%)	13	SELECT t0.id AS id_1 FROM price t0 WHERE t0.id = ? LIMIT 1 Parameters: [`"C"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1 FROM price t0 WHERE t0.id = ? LIMIT 1 SELECT t0.id AS id_1 FROM price t0 WHERE t0.id = 'C' LIMIT 1;
1.77 ms (0.04%)	6	SELECT t0.id AS id_1, t0.price_ht AS price_ht_2, t0.price_ttc AS price_ttc_3, t0.price_id AS price_id_4, t0.product_id AS product_id_5 FROM product_price t0 WHERE t0.product_id = ? AND t0.price_id = ? LIMIT 1 Parameters: [`80097 "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 = 80097 AND t0.price_id = 'C' LIMIT 1;
1.49 ms (0.04%)	5	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: [`80097 9963330`] 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 = 80097 AND p2_.id = 9963330 GROUP BY d0_.quantity ORDER BY d0_.quantity ASC;
1.42 ms (0.03%)	6	SELECT p0_.id AS id_0, p0_.label_reduction AS label_reduction_1, p0_.description_reduction AS description_reduction_2, p0_.product_id AS product_id_3, p0_.operation_id AS operation_id_4 FROM product_reduction_label p0_ INNER JOIN operation o1_ ON p0_.operation_id = o1_.id WHERE o1_.is_active = 1 AND o1_.end_date >= ? AND o1_.is_active = 1 AND o1_.view_by LIKE ? AND p0_.product_id = ? Parameters: [`"2025-07-12 09:43:03" "%2%" 80097`] 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 09:43:03' AND o1_.is_active = 1 AND o1_.view_by LIKE '%2%' AND p0_.product_id = 80097;
1.05 ms (0.03%)	6	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: [`80097`] 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 = 80097;
0.64 ms (0.02%)	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: [`50 238 239 240 241 238 240 9450`] 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 (50, 238, 239, 240, 241, 238, 240) AND p0_.is_active = 1 AND p0_.id <> 9450 AND p0_.is_btoc = 1 AND p0_.is_orapi_grand_frais <> 1 LIMIT 10;
0.56 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: [`"42374-intercalaires-assorties-exacompta-1612e"`] 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 = '42374-intercalaires-assorties-exacompta-1612e' LIMIT 1;
0.42 ms (0.01%)	1	SELECT c0_.id AS id_0, c0_.value AS value_1, c1_.id AS id_2, c1_.list_order AS list_order_3, c1_.is_display_site AS is_display_site_4, c1_.is_search_site AS is_search_site_5, c1_.label AS label_6, c0_.product_id AS product_id_7, c0_.characteristic_label_id AS characteristic_label_id_8 FROM characteristic c0_ INNER JOIN characteristic_label c1_ ON c0_.characteristic_label_id = c1_.id WHERE c0_.product_id = ? AND c1_.is_display_site = ? Parameters: [`9450 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 = 9450 AND c1_.is_display_site = 1;
0.41 ms (0.01%)	1	SELECT t0.id AS id_1, t0.name AS name_2, t0.displayed_order AS displayed_order_3, t0.is_in_footer AS is_in_footer_4, t0.slug AS slug_5, t0.category_parent_id AS category_parent_id_6 FROM category t0 WHERE t0.id = ? LIMIT 1 Parameters: [`1`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.displayed_order AS displayed_order_3, t0.is_in_footer AS is_in_footer_4, t0.slug AS slug_5, t0.category_parent_id AS category_parent_id_6 FROM category t0 WHERE t0.id = ? LIMIT 1 SELECT t0.id AS id_1, t0.name AS name_2, t0.displayed_order AS displayed_order_3, t0.is_in_footer AS is_in_footer_4, t0.slug AS slug_5, t0.category_parent_id AS category_parent_id_6 FROM category t0 WHERE t0.id = 1 LIMIT 1;
0.36 ms (0.01%)	2	SELECT t0.id AS id_1, t0.promotion_id AS promotion_id_2, t0.society_id AS society_id_3 FROM society_promotion t0 WHERE t0.promotion_id = ? Parameters: [`199456`] 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 = 199456;
0.34 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: [`"42374-intercalaires-assorties-exacompta-1612e"`] 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 = '42374-intercalaires-assorties-exacompta-1612e';
0.29 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: [`9450`] 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 = 9450;
0.25 ms (0.01%)	1	SELECT d0_.quantity AS quantity_0, MIN(d0_.price_ht) AS sclr_1, MIN(d0_.price_ttc) AS sclr_2 FROM decreasing_price d0_ LEFT JOIN product p1_ ON d0_.product_id = p1_.id LEFT JOIN product_price p2_ ON d0_.product_price_id = p2_.id WHERE p1_.id = ? GROUP BY d0_.quantity ORDER BY d0_.quantity ASC Parameters: [`563860`] View formatted query View runnable query Explain query SELECT d0_.quantity AS quantity_0, MIN(d0_.price_ht) AS sclr_1, MIN(d0_.price_ttc) AS sclr_2 FROM decreasing_price d0_ LEFT JOIN product p1_ ON d0_.product_id = p1_.id LEFT JOIN product_price p2_ ON d0_.product_price_id = p2_.id WHERE p1_.id = ? GROUP BY d0_.quantity ORDER BY d0_.quantity ASC SELECT d0_.quantity AS quantity_0, MIN(d0_.price_ht) AS sclr_1, MIN(d0_.price_ttc) AS sclr_2 FROM decreasing_price d0_ LEFT JOIN product p1_ ON d0_.product_id = p1_.id LEFT JOIN product_price p2_ ON d0_.product_price_id = p2_.id WHERE p1_.id = 563860 GROUP BY d0_.quantity ORDER BY d0_.quantity ASC;

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

Symfony Profiler

GET https://staging.pgdis.com/produit/42374-intercalaires-assorties-exacompta-1612e

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping