GET https://staging.pgdis.com/produit/63042-chemises-carte-et-polypro-violet-hamelin-400-114-349

Query Metrics

66 Database Queries
21 Different statements
1796.88 ms Query time
0 Invalid entities
3069 Managed entities

Queries

Group similar statements

# Time Info
1 268.57 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:
[
  "63042-chemises-carte-et-polypro-violet-hamelin-400-114-349"
]
2 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:
[
  73073
]
3 0.56 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:
[
  "63042-chemises-carte-et-polypro-violet-hamelin-400-114-349"
]
4 0.46 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:
[
  "63042-chemises-carte-et-polypro-violet-hamelin-400-114-349"
]
5 0.43 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:
[
  73073
  1
]
6 0.77 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:
[
  48
  230
  231
  232
  233
  234
  230
  231
  73073
]
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:
[
  300
]
8 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:
[
  526
]
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:
[
  954
]
10 0.19 ms
SELECT t0.id AS id_1, t0.min_qty AS min_qty_2, t0.max_qty AS max_qty_3, t0.step_qty AS step_qty_4, t0.product_id AS product_id_5 FROM product_rule t0 WHERE t0.product_id = ?
Parameters:
[
  955
]
11 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:
[
  956
]
12 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:
[
  957
]
13 0.19 ms
SELECT t0.id AS id_1, t0.min_qty AS min_qty_2, t0.max_qty AS max_qty_3, t0.step_qty AS step_qty_4, t0.product_id AS product_id_5 FROM product_rule t0 WHERE t0.product_id = ?
Parameters:
[
  963
]
14 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:
[
  972
]
15 0.19 ms
SELECT t0.id AS id_1, t0.min_qty AS min_qty_2, t0.max_qty AS max_qty_3, t0.step_qty AS step_qty_4, t0.product_id AS product_id_5 FROM product_rule t0 WHERE t0.product_id = ?
Parameters:
[
  973
]
16 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:
[
  974
]
17 0.25 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.value1 AS value1_3, t0.value2 AS value2_4, t0.value3 AS value3_5 FROM parameter t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "ourClientsAlsoBoughtMonths"
]
18 607.44 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:
[
  73073
  "2025-04-11 18:01:50"
]
19 904.09 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:
[
  6384785
  6365270
  6385235
  6385318
  6385055
  6386450
  6378695
  6385013
  6387532
  6387609
  6388145
  6389057
  6391908
  6392207
  6394247
  6396377
  6396378
  6396379
  6397328
  6397709
  6398161
  6399568
  6400116
  6400120
  6400236
  6402073
  6403414
  6403661
  6404296
  6405008
  6405328
  6405331
  6405526
  6406132
  6406604
  6408478
  6408480
  6408699
  6410013
  6410379
  6410895
  6410934
  6411224
  6411490
  6411719
  6412054
  6412171
  6412172
  6412194
  6412215
  6413512
  6413560
  6413585
  6413777
  6414109
  6414292
  6415218
  6415429
  6415482
  6415937
  6416051
  6416152
  6416204
  6416238
  6416241
  6416414
  6417072
  6417091
  6417225
  6417282
  6417539
  6420074
  6420277
  6420480
  6420532
  6420659
  6421437
  6421576
  6421577
  6421597
  6421603
  6421626
  6421667
  6421824
  6421840
  6422007
  6414516
  6422285
  6422664
  6422700
  6423142
  6423244
  6425095
  6425118
  6425436
  6425485
  6425718
  6425793
  6426174
  6426242
  6426388
  6426499
  6426611
  6427162
  6427269
  6428037
  6428246
  6428593
  6428901
  6430302
  6430550
  6430627
  6430784
  6431116
  6431570
  6429488
  6432230
  6432237
  6434797
  6434811
  6435149
  6436641
  6437104
  6437674
  6437701
  6438069
  6438688
  6438737
  6439201
  6439652
  6440367
  6440558
  6440944
  6441127
  6441995
  6442738
  6442800
  6442806
  6443015
  6443123
  6443266
  6443771
  6444593
  6445378
  6445741
  6446091
  6446107
  6446119
  6446128
  6446134
  6446136
  6446167
  6446452
  6446797
  6447280
  6447329
  6447401
  6449769
  6449890
  6449894
  6449905
  6450014
  6450066
  6450225
  6450470
  6450772
  6450819
  6451067
  6451125
  6451129
  6451150
  6451239
  6451243
  6451365
  6451397
  6451439
  6451593
  6451595
  6451597
  6451631
  6451738
  6451863
  6451925
  6452086
  6452099
  6452214
  6452588
  6453132
  6453308
  6453612
  6453964
  6454117
  6454537
  6454625
  6455201
  6455203
  6455238
  6455307
  6455308
  6455375
  6455475
  6455479
  6455520
  6455685
  6455696
  6455721
  6455813
  6455884
  6456629
  6457112
  6457126
  6457243
  6457416
  6457445
  6457803
  6458359
  6458488
  6459388
  6460133
  6460469
  6460470
  6461281
  6461508
  6461738
  6462571
  6462970
  6463095
  6463096
  6463126
  6463129
  6463153
  6463156
  6463419
  6463604
  6464223
  6464379
  6465182
  6465283
  6465286
  6465809
  6465933
  6465935
  6466349
  6466609
  6466672
  6466746
  6466960
  6466964
  6467065
  6467075
  6466331
  6467182
  6468021
  6468024
  6468030
  6468033
  6468038
  6468040
  6468047
  6468049
  6468646
  6468647
  6468680
  6468684
  6468789
  6469170
  6469191
  6469374
  6469376
  6469414
  6469419
  6469557
  6469602
  6469603
  6469654
  6469657
  6469708
  6469714
  6469738
  6469740
  6469746
  6469750
  6469854
  6469855
  6469865
  6469868
  6469889
  6469891
  6469926
  6469932
  6470101
  6470331
  6470791
  6470793
  6470965
  6471242
  6471349
  6471865
  6471869
  6472760
  6472778
  6472862
  6473274
  6473280
  6473529
  6474023
  6474024
  6474025
  6474026
  6474027
  6474028
  6474029
  6474030
  6474031
  6474032
  6474033
  6474034
  6474035
  6474036
  6474037
  6474038
  6474039
  6474040
  6474041
  6474043
  6474044
  6474045
  6474046
  6474047
  6474048
  6474049
  6474050
  6474051
  6474052
  6474053
  6474054
  6474055
  6474057
  6474058
  6474059
  6474060
  6474061
  6474062
  6474063
  6474064
  6474065
  6474066
  6474067
  6474068
  6474069
  6474070
  6474071
  6474072
  6474073
  6474074
  6474075
  6474076
  6474077
  6474078
  6474079
  6474080
  6474081
  6474082
  6474083
  6474084
  6474085
  6474086
  6474088
  6474089
  6474090
  6474091
  6474092
  6474093
  6474094
  6474095
  6474096
  6474097
  6474098
  6474100
  6474101
  6474102
  6474103
  6474104
  6474105
  6474106
  6474107
  6474108
  6474109
  6474110
  6474111
  6474112
  6474113
  6474114
  6474115
  6474116
  6474117
  6474118
  6474119
  6474120
  6474121
  6474122
  6474123
  6474124
  6474125
  6474126
  6474127
  6474128
  6474129
  6474130
  6474131
  6474132
  6474133
  6474134
  6474135
  6474136
  6474137
  6474138
  6474139
  6474140
  6474141
  6474142
  6474143
  6474144
  6474145
  6474146
  6474147
  6474148
  6474149
  6474150
  6474151
  6474152
  6474153
  6474154
  6474155
  6474156
  6474157
  6474158
  6474159
  6474160
  6474161
  6474162
  6474163
  6474164
  6474165
  6474166
  6474167
  6474168
  6474169
  6474170
  6474171
  6474172
  6474173
  6474174
  6474175
  6474176
  6474177
  6474178
  6474179
  6474180
  6474181
  6474182
  6474183
  6474184
  6474185
  6474186
  6474187
  6474188
  6474189
  6474190
  6474191
  6474192
  6474193
  6474194
  6474195
  6474196
  6474197
  6474198
  6474199
  6474201
  6474202
  6474203
  6474204
  6474205
  6474206
  6474207
  6474208
  6474209
  6474210
  6474211
  6474212
  6474213
  6474214
  6474434
  6474521
  6475876
  6475877
  6475878
  6475879
  6475880
  6475881
  6475882
  6475894
  6476138
  6476242
  6476515
  6476516
  6476794
  6476957
  6477654
  6479696
  6480593
  6481204
  6482777
  6482802
  6483613
  6483614
  6483636
  6483637
  6483639
  6483700
  6483863
  6483901
  6484132
  6484134
  6484453
  6484455
  6484543
  6484750
  6484975
  6485266
  6485373
  6485650
  6485694
  6485697
  6486888
  6486890
  6486929
  6486930
  6487116
  6487117
  6487118
  6487119
  6487120
  6487121
  6487122
  6487123
  6487124
  6487125
  6487126
  6487127
  6487128
  6487129
  6487130
  6487131
  6487132
  6487133
  6487134
  6487135
  6487136
  6487137
  6487138
  6487139
  6487885
  6488763
  6491333
  6491335
  6491364
  6491365
  6491877
  6491878
  6491890
  6491891
  6492175
  6492203
  6492306
  6493590
  6494202
  6494480
  6494482
  6494760
  6495085
  6495113
  6497481
  6497516
  6497582
  6497761
  6497905
  6497915
  6498059
  6498150
  6498164
  6498347
  6498501
  6498563
  6498578
  6498624
  6498758
  6499276
  6499283
  6499284
  6499291
  6499323
  6499432
  6499532
  6499738
  6500186
  6500344
  6500615
  6501400
  6501883
  6501969
  6501975
  6501978
  6501985
  6501987
  6501990
  6502122
  6502226
  6502594
  6503158
  6503837
  6504079
  6504112
  6504190
  6504207
  6504216
  6504233
  6504665
  6504848
  6504849
  6505016
  6505407
  6505664
  6505665
  6505667
  6505668
  6505669
  6505670
  6505671
  6505672
  6506788
  6506789
  6506790
  6506791
  6506793
  6506794
  6506795
  6506796
  6506797
  6506798
  6506799
  6506800
  6506801
  6506802
  6506803
  6506804
  6506805
  6506806
  6506807
  6506808
  6506809
  6506811
  6506812
  6506813
  6506814
  6507462
  6507672
  6507674
  6507747
  6507751
  6509387
  6509725
  6509726
  6510495
  6510572
  6511452
  6511453
  6511454
  6511455
  6511456
  6511457
  6511458
  6511459
  6511460
  6511461
  6511462
  6511463
  6511464
  6511465
  6511466
  6511467
  6511468
  6511469
  6511470
  6511471
  6511472
  6511473
  6511474
  6511475
  6511477
  6511478
  6511479
  6511480
  6511481
  6511482
  6511483
  6511484
  6511485
  6511486
  6511487
  6511488
  6511489
  6511490
  6511491
  6511492
  6511493
  6511494
  6511495
  6511496
  6511497
  6511498
  6511499
  6511500
  6511501
  6511502
  6511503
  6511504
  6511505
  6511506
  6511507
  6511508
  6511509
  6511510
  6511511
  6511512
  6511513
  6511514
  6511515
  6511516
  6511517
  6511518
  6511519
  6511520
  6511521
  6511522
  6511523
  6511525
  6511526
  6511527
  6511528
  6511529
  6511531
  6511532
  6511533
  6511534
  6511535
  6511536
  6511537
  6511538
  6511539
  6511540
  6511541
  6511542
  6511543
  6511544
  6511545
  6511546
  6511547
  6511548
  6511549
  6511550
  6511551
  6511552
  6511553
  6511554
  6511555
  6511556
  6511557
  6511558
  6511559
  6511560
  6511561
  6511562
  6511563
  6511564
  6511565
  6511566
  6511567
  6511568
  6511569
  6511570
  6511571
  6511572
  6511573
  6511574
  6511575
  6511576
  6511577
  6511578
  6511579
  6511580
  6511581
  6511582
  6511583
  6511584
  6511585
  6511586
  6511587
  6511588
  6511589
  6511590
  6511591
  6511592
  6511593
  6511594
  6511595
  6511596
  6511597
  6511598
  6511599
  6511600
  6511601
  6511602
  6511603
  6511604
  6511605
  6511606
  6511607
  6511608
  6511609
  6511610
  6511611
  6511612
  6511613
  6511614
  6511615
  6511616
  6511617
  6511618
  6511619
  6511620
  6511621
  6511622
  6511623
  6511624
  6511625
  6511626
  6511627
  6511628
  6511629
  6511630
  6511631
  6511632
  6511633
  6511634
  6511635
  6511636
  6511637
  6511638
  6511639
  6511640
  6511641
  6511642
  6512236
  6512238
  6512956
  6512957
  6513030
  6513033
  6513035
  6513040
  6513041
  6515555
  6515606
  6515608
  6515727
  6515754
  6515755
  6515793
  6515795
  6515821
  6515892
  6515893
  6516030
  6516031
  6516898
  6516924
  6516925
  6518179
  6518183
  6518186
  6518187
  6519256
  6519258
  6519525
  6519527
  6522119
  6522307
  6522599
  6523032
  6524025
  6524038
  6524041
  6524249
  6524251
  6525225
  6525236
  6525308
  6526144
  6526182
  6526324
  6526343
  6527241
  6527301
  6527302
  6527797
  6528456
  6528671
  6528686
  6529859
  6530389
  6530410
  6530530
  6530794
  6530861
  6530998
  6532262
  6532263
  6532264
  6532265
  6532266
  6532267
  6532268
  6532269
  6532270
  6532271
  6532272
  6532273
  6532274
  6532275
  6532276
  6532277
  6532278
  6532279
  6532280
  6532281
  6532282
  6532283
  6532284
  6532285
  6532286
  6532287
  6532288
  6532289
  6532290
  6532291
  6532292
  6532293
  6532294
  6532295
  6532296
  6532297
  6532298
  6532299
  6532300
  6532301
  6532302
  6532303
  6532304
  6532305
  6532306
  6532307
  6532308
  6532309
  6532310
  6532311
  6532312
  6532313
  6532314
  6532315
  6532316
  6532317
  6532318
  6532319
  6532320
  6532321
  6532322
  6532323
  6532324
  6532325
  6532326
  6532327
  6532328
  6532329
  6532330
  6532331
  6532332
  6532333
  6532334
  6532335
  6532336
  6532337
  6532338
  6532339
  6532340
  6532341
  6532342
  6532343
  6532344
  6532345
  6532346
  6532347
  6532348
  6532349
  6532350
  6532351
  6532352
  6532353
  6532354
  6532355
  6532356
  6532357
  6532358
  6532359
  6532360
  6532361
  6532362
  6532363
  6532364
  6532365
  6532366
  6532367
  6532368
  6532369
  6532370
  6532371
  6532372
  6532373
  6532374
  6532375
  6532376
  6532377
  6532378
  6532379
  6532380
  6532381
  6532382
  6532383
  6532384
  6532385
  6532386
  6532387
  6532388
  6532389
  6532390
  6532391
  6532392
  6532393
  6532394
  6532395
  6532396
  6532397
  6532398
  6532399
  6532400
  6532401
  6532402
  6532403
  6532404
  6532405
  6532406
  6532407
  6532408
  6532409
  6532410
  6532411
  6532412
  6532413
  6532414
  6532415
  6532416
  6532417
  6532418
  6532419
  6532420
  6532421
  6532422
  6532423
  6532424
  6532425
  6532426
  6532427
  6532428
  6532429
  6532430
  6532431
  6532432
  6532433
  6532434
  6532435
  6532436
  6532437
  6532438
  6532439
  6532440
  6532441
  6532442
  6532443
  6532444
  6532445
  6532446
  6532447
  6532448
  6532449
  6532942
  6534270
  6534271
  6535724
  6536531
  6537219
  6537867
  6538166
  6538834
  6539825
  6539853
  6541541
  6541660
  1000001759
  1000002292
  1000000883
  1000004041
  1000004163
  1000004653
  1000004165
  1000005030
  1000005936
  1000006160
  1000006175
  1000006176
  1000006231
  1000002476
  1000007032
  1000006065
  1000007401
  1000008035
  1000002916
  1000002654
  1000007773
  1000008316
  1000008317
  1000008318
  1000008513
  1000008330
  1000007297
  1000002507
  1000002616
  1000004219
  1000009045
  1000007034
  6379629
  1000009752
  1000009853
  1000009854
  1000009138
  1000010422
  1000010700
  1000010701
  1000011841
  1000011931
  1000010703
  1000010209
  1000012221
  1000012779
  1000012782
  1000012824
  1000012781
  1000012505
  1000013454
  1000009260
  1000014347
  1000012179
  1000013648
  1000012704
  1000013904
  1000015253
  1000009209
  1000015389
  1000010013
  1000015619
  1000015327
  1000002600
  1000016053
  1000016507
  1000014161
  1000012570
  1000016711
  1000017318
  1000012942
  1000010949
  1000018066
  1000018089
  1000018090
  1000012871
  1000019019
  1000019020
  1000019021
  1000019023
  1000019024
  1000019025
  1000012578
  1000011980
  1000019762
  1000019763
  1000019764
  1000019765
  1000019766
  1000019767
  1000019769
  1000019770
  1000019771
  1000019772
  1000019773
  1000019774
  1000019775
  1000019776
  1000019777
  1000019778
  1000019780
  1000019781
  1000019815
  1000019817
  1000019818
  1000019819
  1000019820
  1000020121
  1000020127
  1000013163
  1000019664
  1000018094
  1000016685
  1000016529
  1000015830
  1000019596
  1000002046
  1000000909
  1000022479
  1000016161
  1000023234
  1000025288
  1000026399
  1000026400
  1000026441
  6385936
  1000026401
  1000026577
  1000026578
  1000022523
  1000013439
  1000026842
  1000027905
  1000012775
  1000028030
  1000016054
  1000027977
  1000031332
  1000031361
  1000031365
  1000031366
  1000031377
  1000031378
  1000031379
  1000031381
  1000031382
  1000031383
  1000031385
  1000031392
  1000031428
  1000031467
  1000031468
  1000031472
  1000031475
  1000031476
  1000031477
  1000031478
  1000031480
  1000031502
  1000031504
  1000031506
  1000031509
  1000031526
  1000031531
  1000031532
  1000031533
  1000031546
  1000031553
  1000031558
  1000031566
  1000031567
  1000031583
  1000031585
  1000031591
  1000032111
  1000032492
  1000032505
  1000032509
  1000032516
  1000028620
  1000023235
  1000033191
  1000033193
  1000033198
  1000030059
  1000021444
  1000034135
  1000034293
  1000018119
  1000034693
  1000034694
  1000034697
  1000034826
  1000035652
  1000035653
  1000035654
  1000035655
  1000035656
  1000035657
  1000035658
  1000036396
  1000019046
  1000038408
  1000038434
  1000038442
  1000038446
  1000037713
  1000039179
  1000039210
  1000039421
  1000039423
  1000039469
  1000039482
  1000039492
  1000039494
  1000039495
  1000015361
  1000040368
  1000041426
  1000041456
  1000041427
  1000042078
  1000042088
  1000042090
  1000042091
  1000042557
  1000043245
  1000043246
  1000043259
  1000043262
  1000043264
  1000043265
  1000043334
  1000043336
  1000043349
  1000043350
  1000043351
  1000043352
  1000043355
  1000043356
  1000043358
  1000043359
  1000043363
  1000043365
  1000043366
  1000043367
  1000043373
  1000043374
  1000043375
  1000043376
  1000043390
  1000043394
  1000043395
  1000043396
  1000043400
  1000043408
  1000043416
  1000043417
  1000043418
  1000043419
  1000043420
  1000043424
  1000043426
  1000043427
  1000043428
  1000043429
  1000043432
  1000043434
  1000043436
  1000043437
  1000043438
  1000043440
  1000043441
  1000043443
  1000043444
  1000043474
  1000043475
  1000043476
  1000043477
  1000043478
  1000043479
  1000043480
  1000043481
  1000043482
  1000043483
  1000043484
  1000043485
  1000043486
  1000043487
  1000043488
  1000043489
  1000043490
  1000043492
  1000043493
  1000043494
  1000043495
  1000043496
  1000043497
  1000043498
  1000043499
  1000043500
  1000043501
  1000043502
  1000043503
  1000043504
  1000043505
  1000043506
  1000043507
  1000043508
  1000043509
  1000043510
  1000043511
  1000043512
  1000043513
  1000043514
  1000043515
  1000043516
  1000043517
  1000043518
  1000043519
  1000043520
  1000043521
  1000043522
  1000043529
  1000043530
  1000043531
  1000043532
  1000043533
  1000043534
  1000026590
  1000045731
  1000045732
  1000045733
  1000045734
  1000045735
  1000045736
  1000045737
  1000045738
  1000045739
  1000045740
  1000045741
  1000045742
  1000045743
  1000045744
  1000045745
  1000045746
  1000045748
  1000045749
  1000045750
  1000045751
  1000045752
  1000045753
  1000045754
  1000045755
  1000045756
  1000045757
  1000045758
  1000045759
  1000045760
  1000045761
  1000045762
  1000045763
  1000046049
  1000046304
  1000046331
  1000046356
  1000046367
  1000046368
  1000046384
  1000040964
  1000046660
  1000046674
  1000042387
  1000028015
  1000047856
  1000047785
  1000048006
  1000048022
  1000048038
  1000048047
  1000048050
  1000048051
  1000048052
  1000048343
  1000048358
  1000048512
  1000034711
  1000043637
  1000048829
  1000043346
  1000049023
  1000029437
  6332748
  1000049399
  1000026844
  1000049794
  1000049584
  1000048299
  1000050182
  1000050242
  1000050390
  1000050391
  1000050203
  1000050589
  1000029598
  1000015302
  1000050866
  1000050869
  1000050308
  1000051038
  1000051040
  1000051042
  1000035896
  1000050807
  1000050609
  1000051661
  1000051799
  1000051873
  1000016856
  1000052085
  1000052736
  1000039993
  1000053010
  1000052564
  1000053250
  1000053497
  1000053502
  1000052248
  1000049501
  1000052844
  1000050240
  1000054253
  1000054254
  1000051617
  1000054588
  1000054592
  1000054863
  1000054932
  1000055060
  1000055061
  1000055062
  1000055063
  1000055064
  1000055067
  1000055069
  1000055666
  1000055710
  1000055834
  1000054703
  1000014210
  1000056028
  1000056080
  1000056081
  1000055804
  1000056460
  1000056554
  1000056553
  1000056595
  1000056647
  1000056799
  1000056800
  1000056801
  1000056819
  1000056820
  1000056821
  1000057170
  1000057203
  1000057206
  1000057355
  1000057356
  1000057840
  1000048035
  1000057956
  1000057709
  1000056125
  1000056702
  1000058763
  1000059012
  1000059058
  1000059385
  1000059737
  1000059738
  1000059739
  1000059742
  1000059746
  1000059747
  1000059748
  1000059856
  1000059862
  1000058762
  1000060043
  1000060048
  1000060275
  1000060356
  1000060991
  1000061008
  1000061009
  1000061010
  1000061103
  1000061138
  1000061140
  1000061141
  1000061142
  1000061191
  1000061222
  1000061328
  1000061636
  1000061637
  1000061638
  1000061922
  1000062691
  1000013158
  1000062704
  1000063073
  1000064149
  6378941
  1000052062
  1000065270
  1000064122
  1000065443
  73073
]
20 0.39 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:
[
  152709
]
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:
[
  9864
]
22 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:
[
  991
]
23 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:
[
  4906
]
24 0.15 ms
SELECT t0.id AS id_1, t0.min_qty AS min_qty_2, t0.max_qty AS max_qty_3, t0.step_qty AS step_qty_4, t0.product_id AS product_id_5 FROM product_rule t0 WHERE t0.product_id = ?
Parameters:
[
  348746
]
25 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:
[
  28307
]
26 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:
[
  1905
]
27 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:
[
  9450
]
28 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:
[
  81114
]
29 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:
[
  81113
]
30 0.40 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.27 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.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:
[
  16
]
33 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:
[
  17
]
34 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:
[
  18
]
35 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:
[
  19
]
36 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:
[
  20
]
37 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:
[
  21
]
38 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:
[
  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.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:
[
  24
]
41 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:
[
  25
]
42 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:
[
  26
]
43 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:
[
  27
]
44 0.13 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.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:
[
  29
]
46 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:
[
  30
]
47 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:
[
  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.30 ms
SELECT t0.id AS id_1, t0.value AS value_2, t0.product_id AS product_id_3, t0.characteristic_label_id AS characteristic_label_id_4 FROM characteristic t0 WHERE t0.product_id = ?
Parameters:
[
  73073
]
50 0.30 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.23 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.16 ms
SELECT t0.id AS id_1 FROM price t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
  "C"
]
53 0.17 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.14 ms
SELECT t0.id AS id_1 FROM price t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
  "CAISSE2011"
]
55 1.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:
[
  "CAISSE2011"
  81114
]
56 1.63 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:
[
  81114
  0
]
57 0.46 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"
  81114
]
58 0.22 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:
[
  81114
]
59 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"
]
60 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.product_id = ? AND t0.price_id = ? LIMIT 1
Parameters:
[
  81114
  "C"
]
61 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:
[
  81114
  9963429
]
62 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:
[
  "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.28 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:
[
  81114
]
66 0.28 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-11 18:01:52"
  "%2%"
  81114
]

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 1647
App\Entity\Catalog\ProductCatalog 273
App\Entity\Catalog\CustomerCatalog 273
App\Entity\Customer\Customer 213
App\Entity\User\User 198
App\Entity\Delivery\Delivery 166
App\Entity\Product\Market 67
App\Entity\Pricing\Price 52
App\Entity\Product\ProductPrice 51
App\Entity\Internal\Commercial 42
App\Entity\Product\Product 22
App\Entity\Product\Category 22
App\Entity\Product\Characteristic 15
App\Entity\Product\CharacteristicLabel 14
App\Entity\Delivery\DeliveryCost 6
App\Entity\Internal\Society 5
App\Entity\Internal\Parameter 3