GET https://staging.pgdis.com/produit/74373-affichages-et-presentoirs-assorties-n-c-ffi000293

Query Metrics

69 Database Queries
23 Different statements
4322.30 ms Query time
0 Invalid entities
3972 Managed entities

Queries

Group similar statements

# 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