Query Metrics
81
Database Queries
23
Different statements
2325.78 ms
Query time
0
Invalid entities
3090
Managed entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 73.92 ms |
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:
[
"27135-compas-couleur-maped-192600"
]
|
2 | 0.50 ms |
SELECT t0.id AS id_1, t0.min_qty AS min_qty_2, t0.max_qty AS max_qty_3, t0.step_qty AS step_qty_4, t0.product_id AS product_id_5 FROM product_rule t0 WHERE t0.product_id = ?
Parameters:
[
203532
]
|
3 | 0.71 ms |
SELECT t0.id AS id_1, t0.reference AS reference_2, t0.manufacturer AS manufacturer_3, t0.short_label AS short_label_4, t0.long_label AS long_label_5, t0.weight AS weight_6, t0.sold_by AS sold_by_7, t0.ppht AS ppht_8, t0.ppttc AS ppttc_9, t0.paht AS paht_10, t0.pattc AS pattc_11, t0.legal_discount_library AS legal_discount_library_12, t0.fidelity_bonus AS fidelity_bonus_13, t0.brand AS brand_14, t0.time_limit AS time_limit_15, t0.coef AS coef_16, t0.is_discountable AS is_discountable_17, t0.is_btob AS is_btob_18, t0.is_btoc AS is_btoc_19, t0.is_customizable AS is_customizable_20, t0.is_library AS is_library_21, t0.is_nathan AS is_nathan_22, t0.is_green AS is_green_23, t0.is_orapi_grand_frais AS is_orapi_grand_frais_24, t0.is_active AS is_active_25, t0.slug AS slug_26, t27.id AS id_28, t27.min_qty AS min_qty_29, t27.max_qty AS max_qty_30, t27.step_qty AS step_qty_31, t27.product_id AS product_id_32 FROM product t0 LEFT JOIN product_rule t27 ON t27.product_id = t0.id WHERE t0.id = ? LIMIT 1
Parameters:
[
"27135-compas-couleur-maped-192600"
]
|
4 | 0.61 ms |
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:
[
"27135-compas-couleur-maped-192600"
]
|
5 | 0.54 ms |
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:
[ 203532 1 ] |
6 | 1.84 ms |
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:
[ 59 279 280 281 282 283 284 285 286 280 203532 ] |
7 | 0.35 ms |
SELECT t0.id AS id_1, t0.min_qty AS min_qty_2, t0.max_qty AS max_qty_3, t0.step_qty AS step_qty_4, t0.product_id AS product_id_5 FROM product_rule t0 WHERE t0.product_id = ?
Parameters:
[
1168
]
|
8 | 0.25 ms |
SELECT t0.id AS id_1, t0.min_qty AS min_qty_2, t0.max_qty AS max_qty_3, t0.step_qty AS step_qty_4, t0.product_id AS product_id_5 FROM product_rule t0 WHERE t0.product_id = ?
Parameters:
[
2066
]
|
9 | 0.22 ms |
SELECT t0.id AS id_1, t0.min_qty AS min_qty_2, t0.max_qty AS max_qty_3, t0.step_qty AS step_qty_4, t0.product_id AS product_id_5 FROM product_rule t0 WHERE t0.product_id = ?
Parameters:
[
2067
]
|
10 | 0.23 ms |
SELECT t0.id AS id_1, t0.min_qty AS min_qty_2, t0.max_qty AS max_qty_3, t0.step_qty AS step_qty_4, t0.product_id AS product_id_5 FROM product_rule t0 WHERE t0.product_id = ?
Parameters:
[
2068
]
|
11 | 0.22 ms |
SELECT t0.id AS id_1, t0.min_qty AS min_qty_2, t0.max_qty AS max_qty_3, t0.step_qty AS step_qty_4, t0.product_id AS product_id_5 FROM product_rule t0 WHERE t0.product_id = ?
Parameters:
[
2069
]
|
12 | 0.25 ms |
SELECT t0.id AS id_1, t0.min_qty AS min_qty_2, t0.max_qty AS max_qty_3, t0.step_qty AS step_qty_4, t0.product_id AS product_id_5 FROM product_rule t0 WHERE t0.product_id = ?
Parameters:
[
3138
]
|
13 | 0.24 ms |
SELECT t0.id AS id_1, t0.min_qty AS min_qty_2, t0.max_qty AS max_qty_3, t0.step_qty AS step_qty_4, t0.product_id AS product_id_5 FROM product_rule t0 WHERE t0.product_id = ?
Parameters:
[
3192
]
|
14 | 0.23 ms |
SELECT t0.id AS id_1, t0.min_qty AS min_qty_2, t0.max_qty AS max_qty_3, t0.step_qty AS step_qty_4, t0.product_id AS product_id_5 FROM product_rule t0 WHERE t0.product_id = ?
Parameters:
[
3193
]
|
15 | 0.23 ms |
SELECT t0.id AS id_1, t0.min_qty AS min_qty_2, t0.max_qty AS max_qty_3, t0.step_qty AS step_qty_4, t0.product_id AS product_id_5 FROM product_rule t0 WHERE t0.product_id = ?
Parameters:
[
3204
]
|
16 | 0.22 ms |
SELECT t0.id AS id_1, t0.min_qty AS min_qty_2, t0.max_qty AS max_qty_3, t0.step_qty AS step_qty_4, t0.product_id AS product_id_5 FROM product_rule t0 WHERE t0.product_id = ?
Parameters:
[
3205
]
|
17 | 0.37 ms |
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"
]
|
18 | 1189.66 ms |
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:
[ 203532 "2025-04-12 22:56:32" ] |
19 | 1033.66 ms |
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:
[ 6380193 6384047 6387267 6387361 6388575 6385519 6392248 6394260 6400237 6406625 6407416 6411094 6411213 6411403 6412166 6412858 6413505 6414269 6415509 6415819 6416221 6416959 6417580 6418545 6418843 6419024 6419215 6419327 6421874 6421930 6422243 6424765 6424925 6424926 6424951 6424952 6425806 6426173 6426257 6426350 6426388 6427053 6427627 6427678 6427707 6428031 6428177 6428183 6428213 6428494 6428896 6428923 6429049 6429619 6429970 6430047 6430136 6430137 6430138 6430139 6430140 6430141 6430142 6430143 6430144 6430145 6430146 6430147 6430148 6430149 6430150 6430151 6430152 6430153 6430154 6430155 6430156 6430157 6430158 6430159 6430160 6430161 6430162 6430163 6430164 6430165 6430166 6430167 6430168 6430169 6430170 6430171 6430172 6430173 6430174 6430175 6430176 6430177 6430178 6430179 6430180 6430181 6430182 6430183 6430184 6430320 6430486 6430845 6431170 6431416 6431527 6432355 6433762 6434380 6434753 6435149 6435318 6435320 6435328 6435329 6435336 6435337 6435353 6435355 6435404 6435470 6435596 6435648 6435680 6436021 6436274 6436289 6437626 6437629 6437978 6438601 6438719 6440278 6440303 6440304 6440305 6440306 6440307 6440308 6440309 6440310 6440311 6440312 6440313 6440314 6440315 6440316 6440317 6440318 6440319 6440320 6440321 6440322 6440323 6440324 6440325 6440326 6440327 6440328 6440329 6440330 6440331 6440332 6440333 6440334 6440335 6440337 6440338 6440339 6440340 6440341 6440342 6440343 6440344 6440345 6440346 6440347 6440348 6440349 6440350 6440351 6440352 6440353 6440370 6440558 6441071 6441251 6441579 6441581 6443308 6444349 6444501 6444633 6444747 6445005 6445476 6446263 6446451 6446562 6446630 6447017 6447258 6447331 6447550 6447570 6449113 6449728 6450252 6450631 6450632 6450757 6450819 6451002 6451041 6451129 6451225 6451336 6451391 6451398 6451558 6451565 6452313 6452349 6452415 6452587 6454176 6454360 6454365 6454532 6454625 6454741 6454788 6454799 6454826 6454828 6454861 6454889 6454903 6454930 6454935 6454970 6455040 6455081 6455212 6455420 6455468 6455507 6455602 6455610 6455694 6455728 6455732 6457243 6457420 6457645 6457646 6457803 6458430 6458461 6458475 6459486 6459578 6459937 6459946 6461233 6461654 6462717 6463034 6464492 6464732 6465167 6465253 6465627 6466740 6468968 6469289 6470556 6472035 6472353 6472365 6472463 6473273 6473317 6474791 6475606 6477006 6477040 6477043 6477047 6477566 6477835 6477907 6478388 6478391 6478392 6478393 6478394 6478395 6478396 6478397 6478398 6478399 6478400 6478401 6478402 6478403 6478404 6478405 6478406 6478407 6478408 6478409 6478410 6478411 6478412 6478413 6478414 6478415 6478417 6478418 6478419 6478420 6478421 6478422 6478423 6478424 6478425 6478426 6478427 6478428 6478429 6478430 6478518 6478528 6478529 6478530 6478531 6478532 6478533 6478534 6478535 6478536 6478537 6478538 6478539 6478540 6478541 6478542 6478543 6478544 6478545 6478546 6478547 6478548 6478549 6478550 6478551 6478552 6478553 6478554 6478555 6478556 6478557 6478558 6478559 6478560 6478561 6478562 6478563 6478564 6478565 6478566 6478567 6478568 6478569 6478570 6478571 6478572 6478573 6478574 6478575 6478576 6478577 6478578 6478579 6478588 6478591 6478592 6478593 6478594 6478595 6478596 6478597 6478598 6478599 6478600 6478601 6478602 6478603 6478604 6478605 6478606 6478607 6478608 6478609 6478610 6478611 6478612 6478613 6478614 6478615 6478616 6478617 6478618 6478619 6478620 6478621 6478622 6478623 6478624 6478625 6478626 6478627 6478628 6478629 6478630 6478631 6478632 6478633 6478634 6478635 6478636 6478637 6478638 6478639 6478640 6478641 6478642 6478643 6478644 6478645 6478646 6478647 6478648 6478649 6478650 6478651 6478653 6478654 6478656 6478658 6478880 6478888 6478890 6478891 6478892 6478893 6478894 6478895 6478896 6478897 6478898 6478899 6478900 6478901 6478902 6478903 6478904 6478905 6478906 6478907 6478908 6478909 6478910 6478911 6478912 6478913 6478914 6478915 6478916 6478917 6478918 6478919 6478920 6478921 6478922 6478923 6478924 6478925 6478926 6478928 6478929 6478930 6478931 6478932 6478933 6478934 6478935 6478936 6478937 6478938 6478939 6478940 6478941 6478942 6478943 6478944 6478945 6478946 6478947 6478948 6478949 6478950 6478951 6478952 6478953 6478954 6478955 6478956 6478957 6478958 6478959 6478960 6478961 6479094 6479096 6479097 6479098 6479099 6479100 6479101 6479102 6479103 6479104 6479105 6479106 6479107 6479108 6479109 6479110 6479111 6479112 6479113 6479114 6479115 6479116 6479117 6479118 6479119 6479120 6479121 6479122 6479123 6479124 6479125 6479126 6479127 6479128 6479129 6479130 6479131 6479132 6479133 6479134 6479135 6479136 6479137 6479138 6479139 6479140 6479141 6479142 6479143 6479144 6479145 6479146 6479147 6479148 6479149 6479150 6479151 6479153 6479154 6479155 6479156 6479157 6479158 6479159 6479160 6479161 6479162 6479163 6479164 6479165 6479166 6479167 6479168 6479169 6479170 6479171 6479172 6479173 6479174 6479175 6479176 6479177 6479178 6479179 6479180 6479181 6479182 6479183 6479184 6479185 6479186 6479187 6479188 6479189 6479190 6479191 6479192 6479193 6479194 6479195 6479196 6479197 6479198 6479199 6479200 6479201 6479202 6479203 6479204 6479205 6479343 6479344 6479345 6479346 6479347 6479348 6479349 6479350 6479351 6479352 6479353 6479354 6479355 6479356 6479357 6479358 6479359 6479360 6479361 6479362 6479364 6479365 6479366 6479367 6479368 6479369 6479370 6479371 6479372 6479373 6479374 6479375 6479376 6479377 6479378 6479379 6479380 6479381 6479382 6479383 6479384 6479385 6479386 6479387 6479388 6479390 6479391 6479392 6479393 6479394 6479395 6479396 6479397 6479398 6479399 6479400 6479401 6479403 6479404 6479405 6479406 6479407 6479408 6479410 6479507 6479508 6479509 6479510 6479511 6479512 6479513 6479514 6479515 6479516 6479517 6479518 6479519 6479520 6479521 6479522 6479523 6479524 6479525 6479526 6479527 6479528 6479529 6479530 6479531 6479532 6479533 6479534 6479535 6479536 6479537 6479538 6479539 6479540 6479541 6479542 6479543 6479545 6479546 6479547 6479548 6479549 6479550 6479551 6479552 6479553 6479554 6479555 6479556 6479557 6479558 6479559 6479560 6479561 6479562 6479564 6479565 6479567 6479568 6479569 6479570 6479571 6479572 6479573 6479574 6479575 6479576 6479577 6479578 6479579 6479580 6479669 6479670 6479671 6479672 6479673 6479674 6479675 6479676 6479677 6479678 6479679 6479680 6479681 6479682 6479683 6479684 6479685 6479686 6479687 6479688 6479689 6479690 6479691 6479692 6479693 6479694 6479695 6479697 6479698 6479699 6479700 6479701 6479702 6479703 6479704 6479705 6479706 6479707 6479708 6479709 6479710 6479712 6479797 6479798 6479799 6479800 6479801 6479802 6479803 6479804 6479805 6479806 6479807 6479808 6479809 6479810 6479811 6479812 6479813 6479814 6479815 6479816 6479817 6479818 6479819 6479820 6479821 6479822 6479823 6479824 6479825 6479826 6479827 6479828 6479829 6479830 6479831 6479832 6479833 6479834 6479835 6479836 6479837 6479838 6479839 6479840 6479841 6479842 6479843 6479844 6479845 6479848 6479849 6479850 6479851 6479852 6479853 6479854 6479855 6479856 6479857 6479858 6479859 6479860 6479861 6479862 6479863 6479864 6479865 6479866 6479867 6479868 6479869 6479870 6479871 6479872 6479873 6479874 6479875 6479876 6479877 6479878 6479879 6479880 6479881 6479882 6479883 6479995 6479997 6479998 6479999 6480000 6480001 6480002 6480003 6480004 6480005 6480006 6480008 6480009 6480010 6480011 6480013 6480014 6480015 6480016 6480017 6480018 6480019 6480020 6480021 6480022 6480023 6480024 6480025 6480026 6480027 6480028 6480029 6480030 6480031 6480032 6480033 6480034 6480035 6480036 6480037 6480038 6480039 6480040 6480041 6480042 6480043 6480044 6480045 6480046 6480047 6480048 6480049 6480050 6480051 6480151 6480152 6480153 6480154 6480155 6480156 6480157 6480158 6480159 6480160 6480161 6480162 6480163 6480164 6480165 6480166 6480167 6480168 6480169 6480170 6480171 6480172 6480173 6480174 6480175 6480176 6480177 6480178 6480179 6480180 6480181 6480182 6480183 6480184 6480185 6480186 6480187 6480188 6480189 6480190 6480191 6480192 6480193 6480194 6480195 6480196 6480197 6480198 6480199 6480200 6480201 6480202 6480203 6480204 6480205 6480206 6480207 6480208 6480209 6480210 6480211 6480212 6480213 6480214 6480215 6480216 6480217 6480218 6480219 6480220 6480221 6480222 6480223 6480224 6480225 6480226 6480227 6480228 6480229 6480230 6480231 6480232 6480233 6480234 6480235 6480236 6480237 6480238 6480239 6480240 6480241 6480242 6480243 6480244 6480881 6481243 6481435 6482253 6482485 6483361 6483672 6484850 6486005 6486110 6488629 6488630 6488724 6490052 6490065 6494466 6494548 6494793 6494953 6497102 6497177 6497256 6497296 6497580 6497693 6497710 6497735 6498150 6498153 6498156 6498280 6498308 6498409 6498623 6498624 6498907 6499157 6499230 6499501 6499531 6499558 6499600 6500207 6500465 6501234 6501395 6501398 6501867 6502006 6502041 6502263 6502504 6502533 6502841 6503395 6504716 6507061 6507472 6507979 6508593 6509505 6509506 6509507 6509508 6509509 6509510 6509511 6509512 6509513 6509514 6509515 6509516 6509517 6509518 6509519 6509520 6509521 6509522 6509523 6509524 6509525 6509526 6509527 6509528 6509529 6509530 6509531 6509532 6509533 6509534 6509535 6509536 6509537 6509538 6509539 6509540 6509541 6509542 6509543 6509544 6509545 6509546 6509547 6509548 6509549 6509550 6509551 6509552 6509553 6509554 6509555 6509556 6509557 6509558 6509559 6509560 6509561 6509562 6509563 6509564 6509565 6509566 6509567 6509568 6509569 6509570 6509571 6509572 6509573 6509574 6509575 6509576 6509577 6509578 6509579 6509580 6509581 6509582 6509583 6509584 6509585 6509586 6509587 6509588 6509589 6509590 6509627 6510653 6510923 6510924 6510925 6510926 6510927 6510928 6510929 6510930 6510931 6510932 6510933 6510934 6510935 6510936 6510937 6510938 6510939 6510940 6510941 6510942 6510943 6510944 6510945 6510946 6510947 6510948 6510949 6510950 6510951 6510952 6510953 6510954 6510955 6510956 6510957 6510958 6510959 6510960 6510961 6510962 6510963 6510964 6510965 6510966 6510967 6510968 6510969 6510970 6513347 6513348 6513349 6513350 6513351 6513352 6513353 6513354 6513355 6513356 6513357 6513358 6513359 6513360 6513361 6513362 6513363 6513364 6513365 6513366 6513367 6513368 6513369 6513370 6513371 6513655 6513656 6513657 6513658 6513659 6513660 6513661 6513662 6513663 6513664 6513665 6513666 6513667 6513668 6513669 6513670 6513671 6513672 6513673 6513674 6513675 6513676 6513677 6513678 6513679 6513680 6513681 6513682 6513683 6513684 6513685 6513686 6513687 6513688 6513689 6513690 6513691 6513692 6513693 6513694 6513695 6513696 6513697 6513698 6513699 6513700 6513701 6513702 6513703 6513704 6513705 6513706 6513707 6513708 6513709 6513710 6513711 6513712 6513713 6513714 6513715 6513716 6513717 6513718 6513719 6513720 6513721 6513722 6513723 6513724 6513725 6513726 6513727 6513728 6513729 6513730 6513731 6513732 6513733 6513734 6513735 6513736 6513737 6513738 6513739 6513740 6513741 6513742 6513743 6513879 6513880 6513881 6513882 6513883 6513884 6513885 6513886 6513887 6513888 6513889 6513890 6513891 6513892 6513893 6513894 6513895 6513896 6513897 6513898 6513899 6513900 6513901 6513902 6513903 6513904 6513905 6513906 6513907 6513908 6513909 6513910 6513911 6513912 6513913 6513914 6513915 6513916 6513917 6513918 6513919 6513920 6513921 6513922 6513923 6513924 6513925 6513926 6513927 6513928 6513929 6513930 6513931 6513932 6513933 6513934 6513935 6513936 6513937 6513938 6513939 6513940 6513941 6513942 6513943 6513944 6513945 6513946 6513947 6513948 6513949 6513950 6513951 6513952 6513953 6513954 6513955 6513956 6513957 6513958 6513959 6513960 6513961 6513962 6513963 6513964 6513965 6513966 6513967 6513968 6513969 6513970 6513971 6513972 6513973 6514143 6514144 6514145 6514146 6514147 6514148 6514149 6514150 6514151 6514152 6514153 6514154 6514155 6514156 6514157 6514158 6514159 6514160 6514161 6514162 6514163 6514164 6514165 6514166 6514167 6514168 6514169 6514170 6514171 6514172 6514173 6514174 6514175 6514176 6514177 6514178 6514180 6514181 6514182 6514183 6514184 6514185 6514186 6514187 6514188 6514189 6514190 6514191 6514192 6514193 6514194 6514195 6514196 6514197 6514198 6514199 6514200 6514201 6514202 6514203 6514204 6514205 6514206 6514207 6514208 6514209 6514210 6514211 6514212 6514213 6514214 6514215 6514216 6514217 6514218 6514219 6514220 6514221 6514222 6514223 6514224 6514225 6514226 6514227 6514228 6514229 6514230 6514231 6514232 6514233 6514234 6514235 6514236 6514237 6514238 6514239 6514240 6514241 6514242 6514243 6514244 6514245 6514452 6514453 6514454 6514455 6514456 6514457 6514458 6514459 6514460 6514461 6514462 6514463 6514464 6514465 6514466 6514469 6514470 6514471 6514472 6514473 6514474 6514475 6514476 6514477 6514478 6514479 6514480 6514481 6514482 6514483 6514484 6514575 6514576 6514577 6514578 6514579 6514580 6514581 6514582 6514583 6514584 6514585 6514586 6514587 6514588 6514589 6514590 6514591 6514592 6514593 6514594 6514595 6514596 6514597 6514598 6514599 6514601 6514602 6514603 6514604 6514605 6514606 6514607 6514608 6514609 6514610 6514611 6514612 6514613 6514614 6514615 6514616 6514617 6514618 6514619 6514620 6514621 6514622 6514623 6514624 6514625 6514626 6514629 6514630 6514631 6514632 6514633 6514634 6514635 6514636 6514637 6514638 6514639 6514640 6514641 6514642 6514643 6514644 6514645 6514646 6514647 6514648 6514649 6514650 6514651 6514652 6514653 6514654 6514655 6514656 6514657 6514658 6514659 6514660 6514661 6514662 6514663 6514664 6514665 6514735 6514736 6514737 6514738 6514739 6514740 6514741 6514742 6514743 6514744 6514745 6514746 6514747 6514748 6514749 6514750 6514751 6514752 6514753 6514754 6514755 6514756 6514757 6514758 6514759 6514760 6514761 6514762 6514763 6514764 6514765 6514766 6514767 6514768 6514769 6514770 6514771 6514772 6514773 6514774 6514775 6514776 6514777 6514778 6514779 6514780 6514781 6514782 6514783 6514784 6514785 6514786 6514787 6514841 6514842 6514843 6514844 6514845 6514846 6514847 6514848 6514849 6514850 6514851 6514852 6514853 6514854 6514855 6514856 6514857 6514858 6514859 6514860 6514861 6514862 6514863 6514866 6514867 6514868 6514869 6514870 6514871 6514872 6514873 6514874 6514875 6514876 6514877 6514878 6514879 6514880 6514881 6514882 6514883 6514884 6514885 6514886 6514887 6514888 6514889 6514890 6514891 6514892 6514893 6514894 6514895 6514896 6514897 6514898 6514899 6514900 6514901 6514902 6514903 6514905 6514906 6514907 6514908 6514909 6514911 6514912 6514913 6514914 6514915 6514916 6514917 6514918 6514919 6514920 6514921 6514922 6514923 6514924 6514925 6514926 6514927 6514928 6514929 6514930 6514931 6514932 6514933 6514934 6514935 6514936 6514937 6514938 6514939 6514940 6514941 6514942 6514943 6514944 6514945 6514946 6514947 6514948 6514949 6514950 6514951 6514952 6514953 6514954 6514955 6514956 6514957 6514958 6514959 6515131 6515132 6515677 6515876 6515974 6515975 6517833 6517834 6517835 6517836 6517837 6517838 6517839 6517840 6517841 6517842 6517843 6517844 6517845 6517846 6517848 6517849 6517850 6517851 6517852 6517853 6518611 6519219 6519220 6519296 6519859 6520120 6520248 6520567 6523195 6524115 6524406 6524780 6525047 6525224 6525308 6525359 6525428 6526280 6526977 6526999 6527420 6527779 6527894 6528603 6528768 6528770 6528805 6529047 6529149 6529941 6530266 6530295 6530340 6530350 6530487 6532861 6532968 6532969 6532972 6532973 6532975 6532976 6532979 6532980 6532983 6532984 6532986 6532987 6532990 6532991 6532994 6532995 6532998 6532999 6533001 6533003 6533004 6533194 6533195 6533205 6537753 6541798 1000001349 1000002291 1000003845 1000004350 1000008019 1000005271 1000008409 1000007976 1000009243 1000009684 1000010066 1000011034 1000011942 1000008546 1000012487 1000012750 1000009930 1000012958 1000012931 1000012368 1000014481 1000014733 1000015360 1000010013 1000009692 1000016031 1000016116 1000016117 1000016164 1000016198 1000016366 1000017030 1000017031 1000017032 1000016711 1000013568 1000017444 1000015413 1000017531 1000017532 1000018408 1000018410 1000019211 1000019098 1000019389 1000019391 1000019396 1000010744 1000019922 1000019925 1000020763 1000013051 1000012146 1000016376 1000003579 1000015563 1000018750 1000008190 1000009690 1000024606 6378169 1000019629 1000018411 1000016926 1000016842 1000026471 1000012967 1000026503 1000026613 1000026615 1000026625 1000026679 1000014705 1000026786 1000026850 1000026851 1000026852 1000026853 1000026854 1000026855 1000026856 1000026857 1000026858 1000026859 1000026860 1000026861 1000026862 1000026863 1000026881 1000026884 1000026984 1000027169 1000027170 1000027172 1000027173 1000015589 1000027979 1000027984 1000027988 1000012775 1000028089 1000028138 1000028568 1000028574 1000028575 1000028577 1000028578 1000028590 1000028591 1000028594 1000015436 1000027888 1000015077 1000030395 1000030396 1000030403 1000030404 1000030406 1000030408 1000030411 1000030412 1000030447 1000030789 1000030790 1000030791 1000030793 1000028244 1000031260 1000031261 1000018733 1000002285 1000013398 1000030468 1000032657 1000032659 1000032661 1000032663 1000032664 1000032670 1000032680 1000032691 1000032701 1000032702 1000032703 1000032704 1000032705 1000032706 1000032708 1000032752 1000016318 1000035014 1000035707 1000030451 1000026993 1000027611 1000036862 1000036863 1000036864 1000036865 1000036866 1000036867 1000036868 1000036869 1000036870 1000038339 1000016664 1000039113 1000039114 1000039196 1000039197 1000039219 1000039258 1000039266 1000039273 1000039274 1000039280 1000039284 1000039287 1000039309 1000039470 1000039471 1000039472 1000039473 1000039477 1000039478 1000039479 1000039480 1000039486 1000039491 1000039496 1000016436 1000041389 1000038861 1000042188 1000042189 1000043408 1000043865 1000043866 1000043970 1000044352 1000026490 1000046051 1000008548 1000047754 1000047755 1000047757 1000047758 1000048199 1000048217 1000048218 1000048219 1000048240 1000048632 1000048637 1000048539 1000048347 1000048869 1000048077 1000049441 1000048969 1000027416 1000050092 1000047731 1000049951 1000050396 1000050584 1000050586 1000050694 1000050770 1000049466 1000049965 1000050695 1000048088 1000051316 1000051369 1000051527 1000051588 1000051697 1000051698 1000051842 1000051971 1000051972 1000052183 1000051861 1000050971 1000052072 1000052232 1000052680 1000052685 1000052689 1000052187 1000048334 1000051365 1000053400 1000053758 1000054608 1000054296 1000047929 1000035218 1000055682 1000055727 1000055766 1000055725 1000053685 1000039722 1000057393 1000057446 1000057447 1000058154 1000059525 1000059699 1000060133 1000060135 1000060163 1000060796 1000060797 1000061034 1000061565 1000061577 1000061587 1000061594 1000061596 1000062921 1000062895 1000064232 1000065336 1000065664 1000064377 1000066433 203532 ] |
20 | 0.61 ms |
SELECT t0.id AS id_1, t0.min_qty AS min_qty_2, t0.max_qty AS max_qty_3, t0.step_qty AS step_qty_4, t0.product_id AS product_id_5 FROM product_rule t0 WHERE t0.product_id = ?
Parameters:
[
1232
]
|
21 | 0.27 ms |
SELECT t0.id AS id_1, t0.min_qty AS min_qty_2, t0.max_qty AS max_qty_3, t0.step_qty AS step_qty_4, t0.product_id AS product_id_5 FROM product_rule t0 WHERE t0.product_id = ?
Parameters:
[
1231
]
|
22 | 0.24 ms |
SELECT t0.id AS id_1, t0.min_qty AS min_qty_2, t0.max_qty AS max_qty_3, t0.step_qty AS step_qty_4, t0.product_id AS product_id_5 FROM product_rule t0 WHERE t0.product_id = ?
Parameters:
[
11358
]
|
23 | 0.19 ms |
SELECT t0.id AS id_1, t0.min_qty AS min_qty_2, t0.max_qty AS max_qty_3, t0.step_qty AS step_qty_4, t0.product_id AS product_id_5 FROM product_rule t0 WHERE t0.product_id = ?
Parameters:
[
9527
]
|
24 | 0.15 ms |
SELECT t0.id AS id_1, t0.min_qty AS min_qty_2, t0.max_qty AS max_qty_3, t0.step_qty AS step_qty_4, t0.product_id AS product_id_5 FROM product_rule t0 WHERE t0.product_id = ?
Parameters:
[
169147
]
|
25 | 0.18 ms |
SELECT t0.id AS id_1, t0.min_qty AS min_qty_2, t0.max_qty AS max_qty_3, t0.step_qty AS step_qty_4, t0.product_id AS product_id_5 FROM product_rule t0 WHERE t0.product_id = ?
Parameters:
[
9616
]
|
26 | 0.17 ms |
SELECT t0.id AS id_1, t0.min_qty AS min_qty_2, t0.max_qty AS max_qty_3, t0.step_qty AS step_qty_4, t0.product_id AS product_id_5 FROM product_rule t0 WHERE t0.product_id = ?
Parameters:
[
70842
]
|
27 | 0.20 ms |
SELECT t0.id AS id_1, t0.min_qty AS min_qty_2, t0.max_qty AS max_qty_3, t0.step_qty AS step_qty_4, t0.product_id AS product_id_5 FROM product_rule t0 WHERE t0.product_id = ?
Parameters:
[
5496
]
|
28 | 0.25 ms |
SELECT t0.id AS id_1, t0.min_qty AS min_qty_2, t0.max_qty AS max_qty_3, t0.step_qty AS step_qty_4, t0.product_id AS product_id_5 FROM product_rule t0 WHERE t0.product_id = ?
Parameters:
[
240664
]
|
29 | 0.20 ms |
SELECT t0.id AS id_1, t0.min_qty AS min_qty_2, t0.max_qty AS max_qty_3, t0.step_qty AS step_qty_4, t0.product_id AS product_id_5 FROM product_rule t0 WHERE t0.product_id = ?
Parameters:
[
88138
]
|
30 | 0.52 ms |
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
]
|
31 | 0.34 ms |
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
]
|
32 | 0.24 ms |
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:
[
16
]
|
33 | 0.18 ms |
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:
[
17
]
|
34 | 0.30 ms |
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:
[
18
]
|
35 | 0.25 ms |
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:
[
19
]
|
36 | 0.21 ms |
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:
[
20
]
|
37 | 0.20 ms |
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:
[
21
]
|
38 | 0.18 ms |
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:
[
22
]
|
39 | 0.17 ms |
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:
[
23
]
|
40 | 0.17 ms |
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:
[
24
]
|
41 | 0.24 ms |
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:
[
25
]
|
42 | 0.23 ms |
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:
[
26
]
|
43 | 0.19 ms |
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:
[
27
]
|
44 | 0.21 ms |
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:
[
28
]
|
45 | 0.22 ms |
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:
[
29
]
|
46 | 0.22 ms |
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:
[
30
]
|
47 | 0.21 ms |
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:
[
31
]
|
48 | 0.32 ms |
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:
[
32
]
|
49 | 0.29 ms |
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:
[
"TarifDefautBtoB"
]
|
50 | 0.29 ms |
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"
]
|
51 | 0.25 ms |
SELECT t0.id AS id_1 FROM price t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
"C"
]
|
52 | 0.25 ms |
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:
[
"TarifDefaut"
]
|
53 | 0.20 ms |
SELECT t0.id AS id_1 FROM price t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
"CAISSE2011"
]
|
54 | 0.38 ms |
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" 203532 ] |
55 | 0.42 ms |
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:
[ 203532 0 ] |
56 | 0.41 ms |
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:
[ "C" 203532 ] |
57 | 0.28 ms |
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:
[
"TarifDefautBtoB"
]
|
58 | 0.39 ms |
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:
[ 203532 "C" ] |
59 | 0.34 ms |
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:
[
203532
]
|
60 | 0.21 ms |
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:
[
"TarifDefautBtoB"
]
|
61 | 0.28 ms |
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"
]
|
62 | 0.24 ms |
SELECT t0.id AS id_1 FROM price t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
"C"
]
|
63 | 0.29 ms |
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:
[
203532
]
|
64 | 0.30 ms |
SELECT p0_.id AS id_0, p0_.label_reduction AS label_reduction_1, p0_.description_reduction AS description_reduction_2, p0_.product_id AS product_id_3, p0_.operation_id AS operation_id_4 FROM product_reduction_label p0_ INNER JOIN operation o1_ ON p0_.operation_id = o1_.id WHERE o1_.is_active = 1 AND o1_.end_date >= ? AND o1_.is_active = 1 AND o1_.view_by LIKE ? AND p0_.product_id = ?
Parameters:
[ "2025-09-12 22:56:35" "%2%" 203532 ] |
65 | 0.67 ms |
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:
[ 203532 7 ] |
66 | 0.30 ms |
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:
[
203532
]
|
67 | 0.45 ms |
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:
[
"TarifDefautBtoB"
]
|
68 | 0.27 ms |
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"
]
|
69 | 0.19 ms |
SELECT t0.id AS id_1 FROM price t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
"C"
]
|
70 | 1.93 ms |
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" 240664 ] |
71 | 2.04 ms |
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:
[ 240664 0 ] |
72 | 0.58 ms |
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:
[ "C" 240664 ] |
73 | 0.23 ms |
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:
[
240664
]
|
74 | 0.21 ms |
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:
[
"TarifDefautBtoB"
]
|
75 | 0.67 ms |
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:
[ 240664 "C" ] |
76 | 0.42 ms |
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:
[ 240664 9959371 ] |
77 | 0.27 ms |
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:
[
"TarifDefautBtoB"
]
|
78 | 0.33 ms |
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"
]
|
79 | 0.24 ms |
SELECT t0.id AS id_1 FROM price t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
"C"
]
|
80 | 0.41 ms |
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:
[
240664
]
|
81 | 0.38 ms |
SELECT p0_.id AS id_0, p0_.label_reduction AS label_reduction_1, p0_.description_reduction AS description_reduction_2, p0_.product_id AS product_id_3, p0_.operation_id AS operation_id_4 FROM product_reduction_label p0_ INNER JOIN operation o1_ ON p0_.operation_id = o1_.id WHERE o1_.is_active = 1 AND o1_.end_date >= ? AND o1_.is_active = 1 AND o1_.view_by LIKE ? AND p0_.product_id = ?
Parameters:
[ "2025-09-12 22:56:35" "%2%" 240664 ] |
Database Connections
Name | Service |
---|---|
default | doctrine.dbal.default_connection |
Entity Managers
Name | Service |
---|---|
default | doctrine.orm.default_entity_manager |
Second Level Cache
Second Level Cache is not enabled.
Managed Entities
default entity manager
Class | Amount of managed objects |
---|---|
App\Entity\Order\CustomerOrder | 2220 |
App\Entity\Customer\Customer | 194 |
App\Entity\User\User | 149 |
App\Entity\Delivery\Delivery | 142 |
App\Entity\Catalog\ProductCatalog | 90 |
App\Entity\Catalog\CustomerCatalog | 90 |
App\Entity\Product\Market | 51 |
App\Entity\Pricing\Price | 27 |
App\Entity\Product\ProductPrice | 26 |
App\Entity\Internal\Commercial | 24 |
App\Entity\Product\Product | 21 |
App\Entity\Product\Category | 21 |
App\Entity\Product\Characteristic | 10 |
App\Entity\Product\CharacteristicLabel | 10 |
App\Entity\Delivery\DeliveryCost | 6 |
App\Entity\Internal\Society | 5 |
App\Entity\Internal\Parameter | 3 |
App\Infrastructure\Doctrine\Entity\ProductRule | 1 |