Query Metrics
69
Database Queries
23
Different statements
4322.30 ms
Query time
0
Invalid entities
3972
Managed entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 156.43 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:
[
"74373-affichages-et-presentoirs-assorties-n-c-ffi000293"
]
|
2 | 0.42 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:
[
92310
]
|
3 | 3.98 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:
[
"74373-affichages-et-presentoirs-assorties-n-c-ffi000293"
]
|
4 | 0.47 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:
[
"74373-affichages-et-presentoirs-assorties-n-c-ffi000293"
]
|
5 | 1.02 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:
[ 92310 1 ] |
6 | 0.74 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:
[ 62 302 303 304 302 92310 ] |
7 | 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:
[
356
]
|
8 | 0.16 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:
[
365
]
|
9 | 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:
[
366
]
|
10 | 0.14 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:
[
367
]
|
11 | 0.14 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:
[
368
]
|
12 | 0.14 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:
[
369
]
|
13 | 0.14 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:
[
370
]
|
14 | 0.14 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:
[
371
]
|
15 | 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:
[
374
]
|
16 | 0.14 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:
[
375
]
|
17 | 0.22 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 | 2392.39 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:
[ 92310 "2025-04-12 17:21:31" ] |
19 | 1751.01 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:
[ 6384080 6384631 6374810 6385354 6385672 6385950 6386179 6386700 6376490 6387148 6387213 6387534 6385649 6385852 6388422 6386196 6389228 6389818 6389826 6390204 6389983 6390269 6390353 6390579 6390684 6390948 6390101 6391096 6391372 6392189 6392341 6392283 6392510 6388966 6392829 6392976 6386793 6393132 6390886 6393405 6394067 6394083 6394331 6394344 6380979 6394558 6394603 6394778 6394869 6394872 6392982 6395043 6395071 6395087 6395916 6396406 6396473 6396709 6396721 6396751 6396815 6396860 6396878 6396887 6396889 6396937 6397056 6397134 6397139 6397267 6397373 6397404 6397409 6397487 6397519 6397545 6397577 6397606 6397800 6397805 6397811 6397822 6398074 6398397 6398538 6398630 6398661 6398778 6398879 6398891 6398997 6399108 6399421 6399447 6399543 6399699 6400013 6400498 6400751 6401487 6401526 6401548 6401570 6401671 6401699 6401703 6402298 6403189 6403273 6403473 6403661 6403724 1000001330 6404380 6404316 6405128 6405426 6405449 6405485 6405694 6405931 6405983 6405988 6405990 6406274 6406360 6406653 1000002769 6407453 6407562 6407648 6408050 6408263 6408361 6408654 6408749 6409042 6409061 6409215 6409575 6409628 6409639 6410095 6410228 6410426 6410430 6411045 6411122 6411359 6411512 6411721 6411836 6412115 6412189 6412201 6412218 6412669 6413020 6413583 6413610 6413680 6413898 6413925 6413992 6414290 6414544 6414612 6415013 6415120 6415507 6415610 6415633 6416018 6416320 6416390 6416421 6416423 6416476 6416538 6416805 6416829 6416832 6416873 6416902 6416970 6417117 6417238 6417265 6417340 6417431 6417538 6417539 6417551 6417553 6417704 6417779 6418123 6418265 6418416 6418419 6418559 6418596 6418612 6418984 6418990 6418995 6419024 6419033 6419086 6419112 6419125 6419151 6419250 6419291 6419372 6419385 6419393 6419504 6419535 6419566 6419575 6419870 6419916 6420099 6420212 6420228 6420413 6420441 6420459 6420715 6421666 6421692 6421701 6421762 6421919 6421950 6421976 6421984 6422395 6422780 6422876 6423089 6423407 6423568 6423705 6424033 6424114 6424169 6424687 6425552 6425931 6426219 6426232 6426319 6426566 6426808 6427139 6427270 6427304 6427142 6427390 6427483 6427517 6427682 6427694 6427733 6427757 6427803 6427828 6427875 6427890 6428382 6428395 6428480 6428626 6428909 6428984 6429019 6429139 6429440 6429618 6429670 6429803 6429814 6429830 6429972 6430012 6430050 6430106 6430119 6430278 6430410 6430843 6430870 6431162 6431217 6431281 6431293 6431390 6431476 6432176 6432177 6432238 6432239 6432315 6432352 6433310 6433585 6433656 6433915 6433929 6434100 6434202 6434389 6434644 6434981 6435057 6435352 6435362 6435426 6435867 6435972 6436020 6436252 6436537 6437019 6437714 6437739 6437971 6438106 6439448 6439471 6439607 6439691 6440056 6440835 6440890 6441115 6441612 6442244 6442347 6442491 6442768 6443210 6443258 6443320 6443347 6443373 6443493 6443680 6443886 6444592 6444643 6444672 6445231 6445463 6445605 6445630 6445649 6446108 6446111 6446211 6446242 6446898 6446903 6447030 6447259 6447279 6448242 6448801 6448929 6449143 6449374 6449617 6449642 6449686 6449929 6450195 6450198 6450217 6450265 6450538 6450596 6450856 6451107 6451172 6451204 6451303 6451311 6451324 6451480 6451507 6451616 6451665 6451703 6452058 6452086 6452091 6452122 6452219 6452221 6452246 6452352 6452372 6452373 6452409 6452411 6452473 6452486 6452610 6452617 6452814 6452830 6452835 6452994 6453028 6453029 6453030 6453042 6453045 6453057 6453069 6453085 6453257 6453447 6453661 6453737 6453963 6453985 6454081 6454162 6454264 6454290 6454368 6454486 6454490 6454496 6454546 6454582 6454646 6454732 6454761 6454860 6454877 6454949 6455047 6455053 6455099 6455110 6455122 6455213 6455240 6455295 6455389 6455428 6455438 6455594 6455616 6455652 6455682 6455713 6455773 6455779 6455913 6455925 6456090 6456100 6456103 6456110 6456139 6456215 6456232 6456286 6456302 6456390 6456450 6456592 6456700 6456746 6456783 6456790 6456815 6456816 6456998 6457009 6457095 6457224 6457229 6457244 6457280 6457421 6457441 6457517 6457539 6457541 6457651 6457684 6457825 6459225 6459449 6459481 6460126 6460362 6461262 6461318 6461738 6461834 6461838 6462967 6462996 6463032 6463389 6463419 6463527 6463651 6463654 6463682 6463980 6464095 6464245 6464291 6464330 6465294 6465606 6465706 6465906 6466429 6466606 6468042 6468239 6468618 6468713 6468951 6469207 6469208 6469361 6469568 6469924 6469960 6470024 6470228 6470261 6470280 6470285 6470547 6470931 6471280 6471286 6471335 6471384 6471446 6472234 6472331 6472775 6473063 6474825 6475171 6475563 6475571 6475698 6476398 6476501 6476538 6476884 6477239 6477531 6477566 6477851 6478129 6478186 6478434 6480467 6480490 6480504 6480882 6481010 6481140 6481198 6481204 6481404 6481698 6481733 6483034 6483260 6483401 6483521 6465889 6483749 6483755 6483778 6483805 6483983 6484008 6484035 6484036 6484779 6485521 6485784 6485796 6485951 6486110 6486195 6486496 6486583 6486783 6486845 6487276 6488373 6488900 6489146 6490014 6490080 6490783 6491478 6491517 6491846 6491865 6492008 6492307 6492319 6492306 6492410 6493186 6494310 6494340 6495267 6495975 6496239 6496260 6496365 6496561 6496636 6496827 6497099 6497109 6497110 6497236 6497254 6497375 6497409 6497487 6497607 6497732 6497756 6497903 6498081 6498103 6498128 6498173 6498242 6498347 6498406 6498563 6498579 6498581 6498596 6498836 6498915 6498936 6498954 6498981 6499119 6499464 6499492 6499501 6499511 6499552 6499714 6499791 6499859 6500119 6500210 6500212 6500309 6500367 6500515 6500653 6500691 6500714 6500862 6500901 6500998 6501108 6501109 6501158 6501450 6501554 6501769 6501935 6501978 6501985 6501990 6502019 6502098 6502138 6502197 6502282 6502455 6502531 6502594 6502711 6502766 6502836 6502853 6503183 6503203 6503320 6503378 6503398 6503486 6503526 6503556 6503593 6504074 6504076 6504079 6504248 6504415 6504517 6504522 6504664 6505421 6505445 6505464 6505674 6505926 6506004 6506030 6506048 6506121 6506330 6506481 6506944 6507130 6507447 6507529 6507834 6508548 6508892 6509005 6509077 6509180 6509206 6509296 6509321 6509366 6509733 6510155 6510411 6510512 6510436 6510729 6510819 6510889 6511015 6511031 6512121 6512149 6512468 6512556 6512820 1000060879 6513049 6513055 6515601 6516343 6517283 6517436 6518075 6518174 6518406 6519014 6519404 6519943 6519953 6520148 6520215 6520781 6520964 6521024 6522092 6522106 6523306 6523742 6523971 6523977 6524337 6524350 6524378 6524544 6524594 6524726 6524794 6524864 6525043 6525106 6525224 6525251 6525355 6525411 6525433 6525504 6525511 6525611 6525686 6525696 6525733 6525847 6525918 6526347 6526510 6526518 6526528 6526600 6526778 6526809 6526924 6526981 6527070 6527101 6527248 6527380 6527567 6527765 6527812 6527813 6527825 6527843 6527858 6528049 6528109 6528113 6528237 6528288 6528487 6528596 6528742 6528750 6528753 6528770 6528799 6528811 6528928 6529110 6529113 6529274 6529321 6529416 6529732 6529753 6529908 6529935 6529948 6529964 6529982 6530027 6530051 6530064 6530094 6530104 6530165 6530169 6530250 6530289 6530340 6530357 6530369 6530470 6530525 6530912 6530970 6531120 6531211 6531216 6531258 6532774 6532863 6532964 6533015 6533017 6533023 6533025 6533133 6533137 6533208 6533785 6533916 6534189 6534449 6534590 6534852 6534959 6535104 6535601 6535740 6536077 6536333 6536446 6537164 6537986 6538336 6538633 6539444 6539799 6539947 6539949 6539995 6540065 6540110 6540113 6540401 6540443 6540655 6540761 6542112 6542305 6542654 1000000890 1000000896 1000000905 1000001207 1000001313 1000001322 6391216 1000001430 1000001645 1000001720 1000001759 1000002039 1000002045 1000002138 1000002139 1000002140 1000002141 1000002142 6388408 1000002319 1000002496 1000002543 1000002603 1000002630 1000002634 1000002731 1000002593 1000002780 1000002786 1000002570 1000003856 1000000968 1000004183 1000004261 1000004338 1000004396 1000004410 1000004411 1000004414 1000004490 1000001454 1000004611 1000000918 6386082 1000005035 1000005041 1000001832 1000005214 1000005324 1000004991 1000005801 1000005877 1000005989 1000006027 1000006346 6388255 1000005391 1000006999 1000007011 1000007010 1000007263 1000005019 1000003850 1000001675 1000006029 1000007870 1000008617 1000002144 1000005024 1000004270 1000009284 1000009539 1000009583 1000009735 1000000984 1000004245 1000001940 1000008107 1000004422 1000010648 1000005932 1000009248 1000002287 1000010605 1000011815 1000011830 1000011927 1000012152 1000012230 1000012279 1000012523 1000012720 1000006069 1000009875 1000012621 1000012141 1000013081 1000011085 1000012615 1000005320 1000012685 1000013591 1000013333 1000013650 1000010502 1000013774 1000013838 1000012712 1000012382 1000014006 1000014105 1000014106 1000014345 1000014689 1000014880 1000014985 1000014680 1000010365 1000014223 1000002199 1000015604 1000011898 1000016092 1000016174 1000014055 1000016374 1000016375 1000016481 1000016586 1000016793 1000016808 1000016986 1000016987 1000016995 1000017037 1000017040 1000017060 1000017268 1000017145 1000017280 1000017283 1000006031 1000013396 1000016065 1000017330 1000017459 1000017474 1000017352 1000017338 1000016943 1000009659 1000017605 1000017707 1000017709 1000017710 1000017712 1000017733 1000017739 1000017746 1000017615 1000018345 1000018402 1000014881 1000018461 1000016929 1000018907 1000019248 1000019344 1000019371 1000019482 1000012927 1000019032 1000019826 1000019829 1000019840 1000019841 1000019843 1000019845 1000019865 1000019866 1000019885 1000019913 1000019915 1000019931 1000012635 1000019949 1000019950 1000019983 1000019993 1000012837 1000013289 1000013979 1000020479 1000019036 1000016304 1000020795 1000020846 1000020971 1000021020 1000019489 1000015690 1000012947 1000017049 1000021306 1000016527 1000021634 1000021761 1000021762 1000021763 1000021764 1000021766 1000021767 1000021770 1000001724 1000022070 1000022073 1000022074 1000022075 1000022076 1000022077 1000022078 1000022083 1000022084 1000022085 1000018888 1000017457 1000022325 1000022344 1000022394 1000012492 1000022485 1000022584 1000021400 1000022595 1000022602 1000022611 1000017299 1000018922 1000016453 1000023666 1000022216 1000017267 1000023724 1000023729 1000023730 1000023731 1000023732 1000023733 1000023757 1000023786 1000023787 1000023902 1000021489 1000025315 1000025746 1000025813 1000025814 1000012484 1000026084 1000026107 1000026314 1000026399 1000026400 1000021530 1000026462 1000026401 1000026905 1000026916 1000026917 1000026918 1000026920 1000026922 1000027004 1000022238 1000017580 1000027428 1000017581 1000027551 1000027586 1000024402 1000027600 1000027601 1000013229 1000027643 1000027647 1000027877 1000027878 1000027879 1000027880 1000028365 1000028613 1000028614 1000028628 1000028626 1000028646 1000028647 1000028648 1000028649 1000028650 1000028658 1000028621 1000016744 1000028996 1000028997 1000029094 1000029353 1000028977 1000013224 1000029456 1000029457 1000029458 1000029459 1000029502 1000029543 1000029544 1000022906 1000029810 6382786 1000029921 1000029954 1000030021 1000030023 1000030123 1000030124 1000013580 1000030376 1000030863 1000030905 1000030914 1000030921 1000030928 1000010418 1000029840 1000017748 1000008843 1000032097 1000032099 1000032102 1000032103 1000032104 1000032131 1000032181 1000032187 1000032189 1000032192 1000032196 1000032197 1000032198 1000032204 1000032210 1000032230 1000032237 1000032239 1000032248 1000032249 1000032250 1000032285 1000032302 1000032311 1000032434 1000022069 1000015682 1000032606 1000032457 1000033006 1000033007 1000033009 1000033012 1000033017 1000033019 1000033021 1000033022 1000033025 1000033026 1000033265 1000033266 1000033267 1000033567 1000033568 1000033625 1000033667 1000033668 1000033669 1000033670 1000033671 1000033672 1000033673 1000033674 1000033675 1000033676 1000033677 1000033678 1000033679 1000033680 1000033681 1000033682 1000033683 1000033684 1000033685 1000033686 1000033687 1000033688 1000033689 1000033690 1000033691 1000033692 1000033693 1000033694 1000033695 1000033696 1000033697 1000033699 1000033700 1000033701 1000033702 1000033703 1000033704 1000033705 1000033706 1000033707 1000033708 1000033709 1000033711 1000033712 1000033713 1000033714 1000002096 1000033975 1000009067 1000029293 1000034037 1000034084 1000034087 1000032441 1000023904 1000026799 1000031373 1000033569 1000032297 1000021275 1000036391 1000036392 1000031847 1000036420 1000036421 1000036422 1000012930 1000036409 1000036464 1000036604 1000037822 1000037954 1000037996 1000038001 1000038044 1000039212 1000027876 1000030901 1000040462 1000040463 1000040464 1000040470 1000040896 1000040953 1000036471 1000039198 1000032533 1000042835 1000042836 1000043627 1000043632 1000039108 1000044230 1000044795 1000044829 1000044850 1000044851 1000044855 1000044860 1000044862 1000044867 1000044868 1000044873 1000044883 1000044888 6385285 1000031927 1000045637 1000045638 1000021815 1000045849 1000045863 1000046064 1000046138 1000046139 1000044508 1000025176 1000047582 1000022585 1000048191 1000038179 1000048237 1000048238 1000035758 1000038641 1000045823 1000048561 1000048624 1000048770 1000048787 1000048788 1000048508 1000048947 1000049265 1000049321 1000049327 1000042895 1000048802 1000049071 1000040518 1000048299 1000050030 1000050031 1000050108 1000050175 1000050218 1000044906 1000050327 1000050339 1000050365 1000050249 1000050423 1000032442 1000050654 1000050661 1000050663 1000050750 1000050751 1000050752 1000050753 1000050755 1000050756 1000050762 1000050763 1000050781 1000050783 1000050757 1000050967 1000050968 1000050990 1000051039 1000051010 1000030108 1000051316 1000051318 1000051342 1000051345 1000051346 1000051387 1000040542 1000051696 1000051012 1000031796 1000048804 1000051713 1000021337 1000052349 1000052354 1000052393 1000052225 1000016634 1000052714 1000052873 1000051097 1000053042 1000052913 1000053184 1000052996 1000050370 1000053701 1000053748 1000052131 1000022917 1000052460 1000053827 1000053832 1000053837 1000053819 1000053932 1000054134 1000054136 1000054128 1000054282 1000053603 1000053463 1000051299 1000054797 1000054813 1000054796 1000054818 1000054794 1000054863 1000054871 1000054880 1000054954 1000054957 1000054965 1000053834 1000050540 1000055028 1000055031 1000026153 1000053500 1000055440 1000050252 1000055581 1000052521 1000055682 1000054801 1000055713 1000054616 1000055806 1000055807 1000055855 1000055856 1000055566 1000055909 1000000862 1000056142 1000055801 1000053019 1000056197 1000056282 1000056283 1000020881 1000056766 1000056870 1000056947 1000045710 1000052817 1000057547 1000043790 1000057990 1000058208 1000058228 1000058231 1000058237 1000058243 1000058250 1000058297 1000058302 1000057975 1000058322 1000058327 1000058357 1000058372 1000058389 1000058399 1000058405 1000058409 1000058424 1000058332 1000058431 1000058317 1000058450 1000056689 1000058552 1000058564 1000058581 1000058644 1000058663 1000058234 1000058687 1000058748 1000058761 1000056712 1000058723 1000058887 1000058890 1000058922 1000050326 1000059028 1000058294 1000059104 1000059117 1000058590 1000059126 1000059205 1000059230 1000059316 1000058077 1000059433 1000057791 1000059513 1000059588 1000058384 1000059859 1000059934 1000059967 1000051254 1000048949 1000060138 1000060220 1000060257 1000060258 1000060259 1000060260 1000060423 1000060425 1000059834 1000059795 1000060964 1000061125 1000053194 1000061591 1000061592 1000061662 1000061666 1000062417 1000062442 1000055717 1000061127 1000062491 1000061410 1000063257 1000063216 1000063621 1000063638 1000063639 1000063691 1000063743 1000053723 1000064557 1000065075 1000065131 1000065133 1000065497 1000065553 1000065838 1000065966 1000064746 1000066310 1000066316 1000066362 1000066366 1000065701 1000066462 92310 ] |
20 | 0.44 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:
[
529372
]
|
21 | 0.29 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:
[
9651
]
|
22 | 0.26 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:
[
145260
]
|
23 | 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:
[
80097
]
|
24 | 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:
[
64683
]
|
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:
[
146207
]
|
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:
[
26728
]
|
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:
[
11358
]
|
28 | 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:
[
64682
]
|
29 | 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:
[
87307
]
|
30 | 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.id = ? LIMIT 1
Parameters:
[
1
]
|
31 | 0.29 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.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:
[
16
]
|
33 | 0.38 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.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:
[
18
]
|
35 | 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:
[
19
]
|
36 | 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:
[
20
]
|
37 | 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:
[
21
]
|
38 | 0.31 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.16 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.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:
[
24
]
|
41 | 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:
[
25
]
|
42 | 0.37 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.29 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.71 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.15 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.15 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.14 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.56 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:
[
92310
]
|
50 | 0.26 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"
]
|
51 | 0.24 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"
]
|
52 | 0.22 ms |
SELECT t0.id AS id_1 FROM price t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
"C"
]
|
53 | 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:
[
"TarifDefaut"
]
|
54 | 0.18 ms |
SELECT t0.id AS id_1 FROM price t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
"CAISSE2011"
]
|
55 | 0.87 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" 87307 ] |
56 | 0.35 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:
[ 87307 0 ] |
57 | 0.42 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" 87307 ] |
58 | 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:
[
87307
]
|
59 | 0.27 ms |
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:
[
204380
]
|
60 | 0.22 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.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.product_id = ? AND t0.price_id = ? LIMIT 1
Parameters:
[ 87307 "C" ] |
62 | 0.36 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:
[ 87307 9963507 ] |
63 | 0.23 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"
]
|
64 | 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"
]
|
65 | 0.18 ms |
SELECT t0.id AS id_1 FROM price t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
"C"
]
|
66 | 0.18 ms |
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:
[
204380
]
|
67 | 0.30 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:
[
87307
]
|
68 | 0.29 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 17:21:36" "%2%" 87307 ] |
69 | 0.80 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:
[ 87307 7 ] |
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 | 1664 |
App\Entity\Customer\Customer | 596 |
App\Entity\Delivery\Delivery | 483 |
App\Entity\User\User | 427 |
App\Entity\Catalog\ProductCatalog | 225 |
App\Entity\Catalog\CustomerCatalog | 225 |
App\Entity\Product\Market | 106 |
App\Entity\Internal\Commercial | 62 |
App\Entity\Product\ProductPrice | 50 |
App\Entity\Pricing\Price | 48 |
App\Entity\Product\Product | 21 |
App\Entity\Product\Category | 21 |
App\Entity\Product\Characteristic | 14 |
App\Entity\Product\CharacteristicLabel | 14 |
App\Entity\Internal\Society | 5 |
App\Entity\Delivery\DeliveryCost | 5 |
App\Entity\Internal\Parameter | 3 |
App\Infrastructure\Doctrine\Entity\ProductRule | 1 |
App\Entity\Pricing\Promotion | 1 |
App\Entity\Pricing\SocietyPromotion | 1 |