GET https://staging.pgdis.com/produit/04495-tableaux,-ardoises-effacables-couleur-maped-et58410000

Query Metrics

66 Database Queries
21 Different statements
1884.85 ms Query time
0 Invalid entities
2818 Managed entities

Queries

Group similar statements

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

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\Order\CustomerOrder 1953
App\Entity\User\User 194
App\Entity\Customer\Customer 155
App\Entity\Delivery\Delivery 127
App\Entity\Catalog\ProductCatalog 92
App\Entity\Catalog\CustomerCatalog 92
App\Entity\Product\Market 45
App\Entity\Pricing\Price 29
App\Entity\Product\ProductPrice 27
App\Entity\Internal\Commercial 27
App\Entity\Product\Product 21
App\Entity\Product\Category 21
App\Entity\Product\Characteristic 10
App\Entity\Product\CharacteristicLabel 10
App\Entity\Delivery\DeliveryCost 6
App\Entity\Internal\Society 5
App\Entity\Internal\Parameter 3
App\Infrastructure\Doctrine\Entity\ProductRule 1