Query Metrics
66
Database Queries
21
Different statements
1884.85 ms
Query time
0
Invalid entities
2818
Managed entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 47.76 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:
[
"04495-tableaux,-ardoises-effacables-couleur-maped-et58410000"
]
|
2 | 0.38 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:
[
315533
]
|
3 | 1.61 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:
[
"04495-tableaux,-ardoises-effacables-couleur-maped-et58410000"
]
|
4 | 0.49 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:
[
"04495-tableaux,-ardoises-effacables-couleur-maped-et58410000"
]
|
5 | 1.69 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:
[ 315533 1 ] |
6 | 2.13 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:
[ 70 331 332 333 334 335 336 334 315533 ] |
7 | 0.21 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:
[
540
]
|
8 | 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:
[
1281
]
|
9 | 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:
[
1377
]
|
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:
[
1378
]
|
11 | 0.13 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:
[
1379
]
|
12 | 0.13 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:
[
1380
]
|
13 | 0.21 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:
[
1381
]
|
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:
[
1382
]
|
15 | 0.13 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:
[
1383
]
|
16 | 0.21 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:
[
1384
]
|
17 | 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:
[
"ourClientsAlsoBoughtMonths"
]
|
18 | 964.55 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:
[ 315533 "2025-04-12 22:59:11" ] |
19 | 849.82 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:
[ 6388524 6388532 6388552 6388575 6388121 6385855 6390862 6391913 6392092 6392146 6378240 6393100 6393167 6393401 6393591 6393903 6393944 6394108 6394180 6394259 6394575 6394688 6395931 6397424 6398619 6400466 6400598 6400800 6404354 6404807 6406506 6407620 6409001 6409382 6411953 6413594 6413849 6415977 6416062 6416854 6417110 6418380 6418395 6418893 6418938 6419273 6419325 6419523 6419893 6420646 6423687 6424923 6424925 6424952 6425118 6425782 6425793 6425807 6425806 6425825 6425860 6425882 6425935 6426141 6426179 6426257 6426762 6427095 6427162 6427285 6428677 6428923 6429267 6429581 6429935 6430491 6430895 6431283 6431384 6431537 6433598 6433600 6433713 6433718 6433852 6433854 6433864 6433870 6433887 6433891 6433900 6433905 6433919 6433924 6433963 6433964 6433990 6433995 6434007 6434010 6434018 6434020 6434023 6434029 6434449 6435204 6435205 6435236 6435238 6435248 6435249 6435265 6435267 6435273 6435274 6435279 6435280 6435285 6435286 6435295 6435296 6435302 6435305 6435318 6435320 6435328 6435329 6435353 6435355 6435422 6435423 6435433 6435438 6435447 6435449 6435577 6435580 6435599 6435601 6435633 6435635 6437041 6437287 6437290 6437304 6437306 6437335 6437336 6437441 6437448 6437612 6437615 6437626 6437629 6437825 6438979 6439329 6439331 6439403 6439564 6439565 6439568 6439569 6439589 6439590 6439598 6439599 6439616 6441190 6441213 6441214 6441236 6441240 6441305 6441326 6441328 6441359 6441362 6441406 6441407 6441412 6441413 6441439 6441489 6441490 6441552 6441554 6441565 6441567 6441599 6441609 6441622 6441636 6441701 6441703 6441763 6441919 6441955 6441958 6442903 6443905 6444102 6444180 6444293 6444739 6444750 6445630 6445639 6446208 6447029 6447254 6447516 6448735 6449643 6449716 6450175 6450253 6451049 6451106 6451240 6451436 6451571 6452007 6452029 6452051 6452179 6452419 6452537 6454651 6454761 6454799 6454885 6455307 6455465 6455621 6455723 6455842 6456264 6456741 6457009 6457268 6457271 6457768 6459277 6460126 6460200 6460372 6460515 6460519 6461107 6462996 6463164 6463166 6464302 6466502 6468153 6468155 6469165 6470163 6471038 6471838 6472639 6472934 6472936 6474431 6475466 6475762 6476401 6476879 6477039 6477040 6477119 6477544 6477833 6478166 6478320 6478321 6478322 6478323 6478324 6478325 6478326 6478327 6478328 6478329 6478330 6478331 6478332 6478333 6478334 6478335 6478336 6478337 6478338 6478339 6478340 6478341 6478342 6478343 6478344 6478435 6478436 6478437 6478438 6478439 6478440 6478441 6478442 6478443 6478444 6478445 6478446 6478447 6478448 6478449 6478450 6478451 6478452 6478453 6478454 6478455 6478456 6478457 6478458 6478459 6478460 6478461 6478462 6478463 6478464 6478465 6478466 6478467 6478468 6478469 6478470 6478471 6478472 6478473 6478474 6478475 6478476 6478477 6478478 6478479 6478480 6478481 6478482 6478483 6478484 6478485 6478486 6478487 6478488 6478489 6478490 6478491 6478492 6478493 6478494 6478495 6478496 6478497 6478498 6478499 6478500 6478501 6478502 6478503 6478504 6478505 6478506 6478507 6478508 6478509 6478510 6478511 6478512 6478513 6478514 6478515 6478796 6478802 6478803 6478804 6478805 6478806 6478807 6478808 6478809 6478810 6478811 6478812 6478813 6478814 6478815 6478816 6478817 6478818 6478819 6478820 6478822 6478824 6478825 6478827 6478829 6478831 6478833 6478835 6478837 6478839 6478840 6478842 6478844 6478846 6478848 6478849 6478851 6478853 6478855 6478857 6478859 6478861 6478863 6478864 6478866 6478868 6479033 6479035 6479037 6479038 6479039 6479040 6479041 6479042 6479043 6479044 6479046 6479047 6479048 6479049 6479050 6479051 6479052 6479053 6479054 6479055 6479056 6479057 6479058 6479059 6479060 6479061 6479062 6479063 6479064 6479065 6479066 6479067 6479068 6479069 6479070 6479071 6479072 6479073 6479074 6479075 6479076 6479077 6479078 6479079 6479080 6479081 6479082 6479083 6479084 6479085 6479086 6479087 6479088 6479089 6479090 6479091 6479092 6479093 6479343 6479344 6479345 6479346 6479347 6479348 6479349 6479350 6479351 6479352 6479353 6479354 6479355 6479356 6479357 6479358 6479359 6479360 6479361 6479362 6479464 6479467 6479468 6479469 6479470 6479471 6479472 6479473 6479474 6479475 6479476 6479477 6479478 6479479 6479480 6479481 6479482 6479483 6479484 6479485 6479486 6479487 6479488 6479489 6479490 6479491 6479492 6479493 6479494 6479495 6479496 6479497 6479498 6479499 6479500 6479501 6479502 6479503 6479504 6479505 6479648 6479649 6479650 6479651 6479652 6479653 6479654 6479655 6479656 6479657 6479658 6479659 6479660 6479661 6479662 6479663 6479664 6479665 6479666 6479667 6479757 6479758 6479759 6479760 6479761 6479762 6479763 6479764 6479765 6479766 6479767 6479768 6479769 6479770 6479771 6479772 6479773 6479774 6479775 6479776 6479777 6479778 6479779 6479780 6479781 6479782 6479783 6479784 6479785 6479786 6479787 6479788 6479789 6479790 6479791 6479792 6479793 6479794 6479795 6479796 6479966 6479968 6479969 6479970 6479971 6479972 6479973 6479974 6479975 6479976 6479977 6479978 6479979 6479980 6479981 6479982 6479983 6479984 6479985 6479986 6479987 6479988 6479989 6479990 6479991 6479992 6479993 6480101 6480102 6480103 6480104 6480105 6480106 6480107 6480108 6480109 6480110 6480111 6480112 6480113 6480114 6480115 6480116 6480117 6480118 6480119 6480120 6480121 6480122 6480123 6480124 6480125 6480126 6480127 6480128 6480129 6480130 6480131 6480132 6480133 6480134 6480135 6480136 6480137 6480138 6480139 6480140 6480141 6480142 6480143 6480144 6480145 6480146 6480147 6480148 6480799 6481243 6481404 6481731 6481842 6481849 6483161 6483162 6483948 6484487 6485090 6488465 6488724 6490331 6490334 6491545 6491546 6494765 6494767 6494825 6496377 6496839 6496904 6497279 6497720 6497774 6498645 6498865 6498916 6498936 6498955 6498978 6499128 6499268 6499475 6500235 6501450 6501653 6501837 6502106 6502312 6502522 6502534 6502784 6503183 6503839 6504029 6504382 6505016 6505024 6505407 6505423 6506463 6507931 6508755 6509479 6509480 6509481 6509482 6509483 6509484 6509485 6509486 6509487 6509488 6509489 6509490 6509491 6509492 6509493 6509494 6509495 6509496 6509497 6509498 6509499 6509500 6509501 6509502 6509503 6509504 6511006 6511007 6512384 6513318 6513319 6513320 6513321 6513322 6513323 6513324 6513325 6513326 6513327 6513328 6513329 6513330 6513331 6513332 6513333 6513334 6513336 6513337 6513338 6513339 6513340 6513341 6513342 6513343 6513344 6513345 6513372 6513373 6513374 6513375 6513376 6513377 6513378 6513379 6513380 6513381 6513382 6513383 6513384 6513385 6513386 6513387 6513388 6513389 6513390 6513391 6513392 6513393 6513394 6513395 6513396 6513397 6513398 6513399 6513400 6513401 6513402 6513403 6513404 6513405 6513406 6513407 6513408 6513409 6513410 6513411 6513574 6513575 6513576 6513577 6513578 6513579 6513580 6513581 6513582 6513583 6513584 6513585 6513586 6513587 6513588 6513589 6513590 6513591 6513592 6513593 6513594 6513595 6513596 6513597 6513598 6513599 6513600 6513601 6513602 6513603 6513604 6513605 6513606 6513607 6513608 6513609 6513610 6513611 6513612 6513613 6513614 6513615 6513616 6513617 6513618 6513619 6513620 6513621 6513622 6513623 6513624 6513625 6513626 6513627 6513628 6513629 6513630 6513631 6513632 6513633 6513634 6513635 6513636 6513637 6513638 6513639 6513640 6513641 6513642 6513643 6513644 6513645 6513646 6513647 6513648 6513649 6513650 6513651 6513652 6513653 6513654 6514054 6514055 6514056 6514057 6514058 6514059 6514060 6514061 6514062 6514063 6514064 6514065 6514066 6514067 6514068 6514069 6514070 6514071 6514072 6514073 6514074 6514075 6514076 6514077 6514078 6514079 6514080 6514081 6514082 6514083 6514084 6514085 6514086 6514087 6514088 6514089 6514090 6514091 6514092 6514093 6514094 6514095 6514096 6514097 6514098 6514099 6514100 6514101 6514246 6514247 6514248 6514249 6514250 6514251 6514252 6514253 6514254 6514255 6514256 6514257 6514258 6514259 6514260 6514261 6514262 6514263 6514264 6514265 6514266 6514267 6514268 6514269 6514270 6514271 6514272 6514273 6514274 6514275 6514276 6514277 6514278 6514279 6514280 6514281 6514282 6514283 6514284 6514285 6514286 6514287 6514288 6514289 6514290 6514291 6514292 6514293 6514294 6514295 6514296 6514297 6514298 6514299 6514300 6514301 6514302 6514303 6514304 6514305 6514306 6514307 6514308 6514309 6514310 6514311 6514312 6514313 6514314 6514315 6514316 6514317 6514318 6514319 6514320 6514321 6514322 6514323 6514324 6514325 6514326 6514327 6514328 6514329 6514330 6514331 6514332 6514333 6514334 6514335 6514336 6514337 6514338 6514339 6514340 6514341 6514342 6514343 6514344 6514345 6514346 6514347 6514348 6514349 6514533 6514534 6514535 6514536 6514537 6514538 6514539 6514540 6514541 6514542 6514543 6514544 6514545 6514546 6514547 6514548 6514549 6514550 6514551 6514552 6514553 6514555 6514556 6514557 6514558 6514559 6514560 6514561 6514562 6514563 6514564 6514565 6514566 6514567 6514568 6514569 6514570 6514571 6514572 6514573 6515131 6515132 6515136 6515139 6515143 6515144 6515918 6515974 6515975 6516710 6517813 6517814 6517815 6517816 6517817 6517818 6517819 6517820 6517821 6517822 6517823 6517824 6517825 6517826 6517827 6517828 6517829 6517830 6517831 6517832 6517833 6517834 6517835 6517836 6517837 6517838 6517839 6517840 6517841 6517842 6517843 6517844 6517845 6517846 6517848 6517849 6517850 6517851 6517852 6517853 6519475 6519930 6520954 6521251 6522245 6522870 6524276 6524432 6524861 6525119 6525496 6526063 6526212 6526423 6527124 6527779 6528048 6528124 6528793 6529025 6529272 6529343 6529361 6529845 6530410 6530457 6532756 6532768 6532967 6532971 6532978 6532982 6532985 6532989 6532993 6532997 6533001 6533002 6533199 6537092 6537095 6537100 6539651 6541771 6541945 1000002289 1000006020 1000004176 1000008313 1000008321 1000008641 1000008841 1000006174 1000009596 1000007869 1000000731 1000010106 1000002217 1000002219 1000010422 1000011861 1000009156 1000012853 1000012961 1000012989 1000012704 1000012801 1000012235 1000016041 1000016166 1000016168 1000016169 1000018296 1000018297 1000018300 1000018301 1000018302 1000018309 1000018311 1000018315 1000018318 1000018320 1000018326 1000018329 1000018334 1000018335 1000018387 1000018388 1000018389 1000018390 1000018392 1000018393 1000018395 1000018464 1000018466 1000018471 1000018496 1000018497 1000018499 1000014008 1000018945 1000018968 1000018969 1000018998 1000019122 1000019242 1000019247 1000019253 1000019383 1000019389 1000019391 1000019396 1000019403 1000019407 1000019414 1000019425 1000019530 1000019532 1000019534 1000019545 1000021053 1000001497 1000022153 1000022154 1000022155 1000022156 1000022158 1000022159 1000022160 1000022161 1000022170 1000022171 1000022172 1000022173 1000022177 1000016976 1000019091 1000018950 1000022874 1000022876 1000022881 1000022882 1000022883 1000022884 1000022885 1000022886 1000022887 1000022888 1000022889 1000022890 1000022891 1000022892 1000022893 1000022894 1000022895 1000022904 1000022929 1000023011 1000023092 1000023095 1000023100 1000023154 1000023164 1000023166 1000023168 1000023169 1000023170 1000023171 1000023227 1000023228 1000023240 1000023241 1000023242 1000023243 1000023244 1000023245 1000023246 1000023247 1000023248 1000023263 1000023266 1000023267 1000023268 1000023269 1000023270 1000023271 1000023273 1000023274 1000023286 1000023265 1000023325 1000023333 1000023335 1000023336 1000023337 1000023338 1000023339 1000023340 1000023341 1000023342 1000023343 1000023344 1000023345 1000023346 1000023347 1000023348 1000023349 1000023350 1000023358 1000023361 1000023364 1000023366 1000023367 1000023368 1000023369 1000023370 1000023371 1000023372 1000023373 1000023374 1000023375 1000023377 1000023378 1000023379 1000023383 1000023384 1000023385 1000023386 1000023387 1000023388 1000023403 1000023406 1000023550 1000023640 1000023641 1000023642 1000023643 1000023644 1000023645 1000023646 1000023647 1000023648 1000023649 1000023650 1000023651 1000023663 1000024170 1000024171 1000024173 1000024174 1000024175 1000024531 1000024532 1000025048 1000025141 1000025169 1000025489 1000025753 1000025768 1000025772 1000025774 1000025775 1000025776 1000025777 1000025778 1000025779 1000025780 1000025822 1000026602 1000026613 1000026615 1000026625 1000026679 1000026786 1000026800 1000026802 1000026803 1000026804 1000026805 1000026806 1000026807 1000026808 1000026809 1000026829 1000026830 1000026831 1000026850 1000026851 1000026852 1000026881 1000026884 1000027107 1000027111 1000027112 1000027169 1000027170 1000027172 1000027173 1000027762 1000027763 1000027766 1000027767 1000027782 1000027783 1000027784 1000027801 1000027827 1000027830 1000027832 1000027834 1000027969 1000028136 1000028137 1000028138 1000028139 1000028140 1000028141 1000028142 1000028143 1000028199 1000028207 1000028210 1000028259 1000028260 1000028261 1000028262 1000028263 1000028265 1000028436 1000028437 1000028438 1000028439 1000028440 1000028441 1000028442 1000028444 1000028526 1000028530 1000028532 1000028533 1000028534 1000028535 1000028536 1000028537 1000028551 1000028568 1000028574 1000028600 1000028478 1000028665 1000028666 1000028705 1000028708 1000028814 1000028947 1000029003 1000029110 1000029112 1000029119 1000029130 1000029138 1000029152 1000026081 1000029416 1000029979 1000029983 1000029984 1000029985 1000029987 1000029988 1000029989 1000029990 1000030029 1000030049 1000030050 1000030051 1000030395 1000030396 1000030403 1000030404 1000030406 1000030408 1000030633 1000030634 1000030635 1000030650 1000030789 1000030790 1000030791 1000030793 1000030912 1000030913 1000030915 1000030916 1000030917 1000030918 1000030919 1000030920 1000030922 1000030924 1000030925 1000031239 1000031242 1000031243 1000031244 1000031245 1000031247 1000031260 1000031261 1000031265 1000031266 1000031277 1000031282 1000031292 1000031297 1000031427 1000031746 1000032289 1000032472 1000032474 1000032475 1000032477 1000032478 1000032479 1000032480 1000032657 1000032659 1000032661 1000032663 1000032664 1000032670 1000032716 1000032729 1000032732 1000032738 1000032739 1000032740 1000032741 1000032742 1000032743 1000032744 1000032761 1000032765 1000032769 1000032780 1000032782 1000032784 1000032821 1000032822 1000032837 1000032838 1000033035 1000033036 1000033096 1000033097 1000033098 1000033123 1000033130 1000033217 1000033220 1000033246 1000033247 1000033248 1000033250 1000033251 1000033252 1000033253 1000033255 1000033259 1000033261 1000033262 1000033268 1000033811 1000034142 1000034149 1000034198 1000034199 1000034204 1000034205 1000034252 1000034729 1000034731 1000034732 1000034747 1000034748 1000034761 1000034762 1000034795 1000034881 1000034884 1000034886 1000035133 1000035142 1000035265 1000035503 1000032297 1000035542 1000035543 1000035544 1000035546 1000035583 1000035584 1000028674 1000036054 1000036055 1000036056 1000036057 1000036058 1000036059 1000036060 1000036061 1000036062 1000036063 1000036064 1000036066 1000036067 1000036068 1000036070 1000036071 1000036072 1000036073 1000036074 1000036075 1000036076 1000036077 1000036079 1000028622 1000036550 1000036619 1000013063 1000036847 1000036848 1000036849 1000036851 1000036852 1000036853 1000036854 1000036855 1000036856 1000036857 1000036858 1000036859 1000036860 1000036862 1000036863 1000036864 1000036865 1000036866 1000036867 1000036868 1000036869 1000036870 1000036871 1000036872 1000036873 1000036874 1000036875 1000036876 1000036877 1000036878 1000036879 1000036887 1000036888 1000036889 1000037342 1000037343 1000037344 1000037345 1000037346 1000037347 1000037348 1000037518 1000037520 1000037523 1000037560 1000037561 1000037562 1000037563 1000037564 1000037566 1000037567 1000037580 1000037582 1000037586 1000037587 1000037588 1000037627 1000037629 1000037631 1000037634 1000037635 1000037637 1000037638 1000037639 1000037640 1000037643 1000037644 1000038081 1000038082 1000038083 1000038085 1000038086 1000038087 1000038099 1000038108 1000038109 1000038111 1000038112 1000038113 1000038114 1000038115 1000038116 1000038117 1000038118 1000038119 1000038120 1000038124 1000038125 1000038126 1000038127 1000038128 1000038130 1000038131 1000038132 1000038133 1000038134 1000038135 1000038136 1000038137 1000038138 1000038354 1000038355 1000038356 1000038357 1000038358 1000038359 1000038360 1000038361 1000038362 1000038363 1000038364 1000038365 1000038366 1000038367 1000038376 1000038377 1000038389 1000038390 1000038433 1000038437 1000038439 1000022807 1000039262 1000039288 1000039289 1000039290 1000039291 1000039292 1000039293 1000039294 1000039295 1000039296 1000039297 1000039298 1000039299 1000039300 1000039301 1000039310 1000039410 1000039466 1000039470 1000039471 1000039472 1000039473 1000039483 1000039539 1000039540 1000039550 1000039554 1000039562 1000039612 1000039613 1000039637 1000039641 1000039645 1000039729 1000039861 1000039862 1000039863 1000039864 1000039865 1000039866 1000039867 1000039868 1000039869 1000039870 1000039872 1000039873 1000039875 1000039877 1000040106 1000040137 1000041012 1000041049 1000041065 1000041419 1000033326 1000041818 1000041892 1000033144 1000042875 1000042880 1000042912 1000043347 1000043348 1000043357 1000044908 1000046980 1000046981 1000047525 1000047527 1000047529 1000047744 1000048301 1000048378 1000048379 1000048971 1000050584 1000050586 1000050654 1000050656 1000050974 1000050883 1000051517 1000036959 1000051971 1000051972 1000051981 1000051985 1000051841 1000051742 1000052635 1000052774 1000052796 1000050598 1000052804 1000043688 1000054024 1000054339 1000053871 1000054690 1000054792 1000054609 1000055026 1000055293 1000055309 1000055325 1000055346 1000055347 1000056819 1000056820 1000056821 1000056950 1000057021 1000057024 1000057025 1000057032 1000057033 1000057187 1000057334 1000057393 1000057446 1000057447 1000058154 1000058176 1000058177 1000058396 1000058397 1000058402 1000058406 1000060112 1000060132 1000060133 1000060135 1000060163 1000060577 1000060578 1000060581 1000060717 1000060796 1000060797 1000061723 1000058637 1000061806 1000062379 1000062380 1000053231 1000063920 1000064769 315533 ] |
20 | 0.40 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
]
|
21 | 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:
[
1232
]
|
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:
[
88138
]
|
23 | 0.21 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
]
|
24 | 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:
[
70842
]
|
25 | 0.33 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
]
|
26 | 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:
[
9527
]
|
27 | 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:
[
240664
]
|
28 | 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:
[
9616
]
|
29 | 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:
[
1231
]
|
30 | 4.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.id = ? LIMIT 1
Parameters:
[
1
]
|
31 | 0.35 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.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:
[
16
]
|
33 | 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:
[
17
]
|
34 | 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:
[
18
]
|
35 | 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:
[
19
]
|
36 | 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:
[
20
]
|
37 | 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:
[
21
]
|
38 | 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:
[
22
]
|
39 | 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:
[
23
]
|
40 | 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:
[
24
]
|
41 | 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:
[
25
]
|
42 | 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:
[
26
]
|
43 | 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:
[
27
]
|
44 | 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:
[
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.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:
[
30
]
|
47 | 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:
[
31
]
|
48 | 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:
[
32
]
|
49 | 0.28 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:
[
315533
]
|
50 | 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"
]
|
51 | 0.25 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.49 ms |
SELECT t0.id AS id_1 FROM price t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
"C"
]
|
53 | 0.19 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.15 ms |
SELECT t0.id AS id_1 FROM price t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
"CAISSE2011"
]
|
55 | 0.36 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" 169147 ] |
56 | 0.32 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:
[ 169147 0 ] |
57 | 0.33 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" 169147 ] |
58 | 0.19 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:
[
169147
]
|
59 | 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"
]
|
60 | 0.30 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:
[ 169147 "C" ] |
61 | 0.35 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:
[
169147
]
|
62 | 0.20 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"
]
|
63 | 0.21 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"
]
|
64 | 0.15 ms |
SELECT t0.id AS id_1 FROM price t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
"C"
]
|
65 | 0.27 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:
[
169147
]
|
66 | 0.27 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:59:13" "%2%" 169147 ] |
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 | 1953 |
App\Entity\User\User | 194 |
App\Entity\Customer\Customer | 155 |
App\Entity\Delivery\Delivery | 127 |
App\Entity\Catalog\ProductCatalog | 92 |
App\Entity\Catalog\CustomerCatalog | 92 |
App\Entity\Product\Market | 45 |
App\Entity\Pricing\Price | 29 |
App\Entity\Product\ProductPrice | 27 |
App\Entity\Internal\Commercial | 27 |
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 |