GET https://staging.pgdis.com/produit/15168-marqueurs-permanents-noir-uniball-pm-122-n

Query Metrics

50 Database Queries
13 Different statements
3572.44 ms Query time
0 Invalid entities
3455 Managed entities

Queries

Group similar statements

# Time Info
1 130.02 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:
[
  "15168-marqueurs-permanents-noir-uniball-pm-122-n"
]
2 0.44 ms
SELECT t0.id AS id_1, t0.min_qty AS min_qty_2, t0.max_qty AS max_qty_3, t0.step_qty AS step_qty_4, t0.product_id AS product_id_5 FROM product_rule t0 WHERE t0.product_id = ?
Parameters:
[
  2030
]
3 0.71 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:
[
  "15168-marqueurs-permanents-noir-uniball-pm-122-n"
]
4 0.66 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:
[
  "15168-marqueurs-permanents-noir-uniball-pm-122-n"
]
5 2.34 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:
[
  2030
  1
]
6 1.10 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:
[
  58
  275
  276
  277
  278
  276
  2030
]
7 0.34 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:
[
  139
]
8 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:
[
  140
]
9 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:
[
  141
]
10 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:
[
  142
]
11 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:
[
  170
]
12 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:
[
  171
]
13 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:
[
  172
]
14 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:
[
  174
]
15 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:
[
  175
]
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:
[
  176
]
17 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:
[
  "ourClientsAlsoBoughtMonths"
]
18 2107.50 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:
[
  2030
  "2025-04-11 14:11:32"
]
19 1319.69 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:
[
  6384215
  6379959
  6384677
  6386003
  6386654
  6387369
  6382839
  6386196
  6388858
  6389065
  6389133
  6390060
  6390309
  6390531
  6390767
  6384100
  6390967
  6391060
  6391372
  6391836
  6390748
  6391992
  6392609
  6392642
  6384715
  6393029
  6393148
  6393226
  6393264
  6393294
  6393364
  6393345
  6343287
  6393661
  6394074
  6394509
  6394529
  6394698
  6394822
  6392982
  6395075
  6395153
  6395286
  6395378
  6395399
  6395401
  6395764
  6395813
  6395856
  6395871
  6395906
  6396336
  6396383
  6396419
  6396425
  6396610
  6397042
  6397090
  6397098
  6397103
  6397267
  6397955
  6397956
  6398222
  6398240
  6398318
  6398393
  6398397
  6398401
  6398672
  6398914
  6399133
  6399316
  6399995
  6400146
  6400229
  6400232
  6400250
  6400751
  6401032
  6401406
  6401533
  6402541
  6403158
  6403160
  6403699
  6403747
  6403816
  6403918
  6404367
  6404530
  6404618
  6405130
  6405338
  6405518
  6405674
  6406614
  6406877
  6406937
  6407115
  6407123
  6408026
  6408378
  6408390
  6408547
  6408905
  6409029
  6409213
  6409274
  6409317
  6409340
  6409192
  6409499
  6409508
  6409671
  6409694
  6410239
  6410560
  6411046
  6411163
  6411233
  6411241
  6411344
  6411423
  6411440
  6411701
  6411704
  6411817
  6411980
  6412087
  6412106
  6412232
  6412366
  6412615
  6413273
  6413830
  6414261
  6414444
  6414598
  6414685
  6414992
  6415001
  6415067
  6415167
  6415171
  6415177
  6415362
  6415604
  6415669
  6415671
  6415765
  6415817
  6416138
  6416174
  6416257
  6416306
  6416312
  6416439
  6416440
  6416604
  6416622
  6416827
  6416902
  6416921
  6416960
  6416989
  6417089
  6417103
  6417170
  6417280
  6417297
  6417325
  6417450
  6417817
  6417870
  6417886
  6417920
  6417993
  6418081
  6418098
  6418100
  6418113
  6418119
  6418266
  6418268
  6418351
  6418382
  6418435
  6418704
  6418715
  6418829
  6418863
  6418888
  6418956
  6418984
  6419065
  6419072
  6419074
  6419133
  6419249
  6419361
  6419362
  6419503
  6419561
  6419583
  6419704
  6419840
  6419859
  6420006
  6420309
  6420645
  6420650
  6420666
  6420715
  6420718
  6420835
  6422499
  6422696
  6422700
  6422872
  6422968
  6423171
  6423274
  6423372
  6423687
  6423740
  6423965
  6424052
  6424121
  6424341
  6424663
  6424737
  6424777
  6425118
  6425318
  6425476
  6425721
  6426196
  6426408
  6426430
  6426524
  6426608
  6426732
  6426808
  6426849
  6427115
  6427238
  6427665
  6427777
  6428026
  6428411
  6428443
  6428638
  6428654
  6428736
  6428824
  6428836
  6428917
  6429328
  6429329
  6429582
  6429630
  6429813
  6429828
  6430128
  6430284
  6430873
  6430922
  6431080
  6431516
  6431579
  6431753
  6431785
  6431860
  6432152
  6432192
  6432280
  6432322
  6433532
  6433585
  6434067
  6434182
  6434204
  6434209
  6434803
  6434807
  6434849
  6434909
  6435321
  6435644
  6435654
  6435759
  6435879
  6436064
  6436090
  6436460
  6437138
  6438035
  6438155
  6438500
  6438906
  6439005
  6439560
  6439612
  6439646
  6439663
  6439676
  6439980
  6440232
  6440846
  6441144
  6441208
  6441212
  6441237
  6441367
  6441612
  6441921
  6442798
  6442848
  6442862
  6443135
  6443195
  6443294
  6443320
  6443364
  6443373
  6443537
  6443826
  6443923
  6444179
  6444426
  6445175
  6445262
  6445273
  6445295
  6445436
  6445679
  6446134
  6446612
  6447049
  6447057
  6447242
  6447331
  6447383
  6447402
  6447457
  6447687
  6449518
  6449525
  6449588
  6449617
  6449643
  6449676
  6449677
  6449678
  6449807
  6449814
  6449891
  6449915
  6450002
  6450170
  6450180
  6450181
  6450195
  6450228
  6450375
  6450405
  6450413
  6450424
  6450442
  6450497
  6450554
  6450565
  6450597
  6450654
  6450744
  6450754
  6450761
  6450769
  6450856
  6451045
  6451060
  6451088
  6451125
  6451200
  6451240
  6451252
  6451324
  6451435
  6451439
  6451454
  6451461
  6451463
  6451561
  6451594
  6451631
  6451703
  6451922
  6451977
  6452350
  6452356
  6452383
  6452410
  6452496
  6452521
  6452537
  6452577
  6452743
  6452855
  6453263
  6453342
  6453465
  6453498
  6453502
  6453552
  6453571
  6453861
  6453988
  6454177
  6454530
  6454543
  6454663
  6454722
  6454744
  6454766
  6454855
  6454873
  6454875
  6454982
  6454985
  6454989
  6455053
  6455137
  6455231
  6455233
  6455332
  6455365
  6455390
  6455417
  6455660
  6455716
  6455735
  6455802
  6455963
  6456026
  6456109
  6456158
  6456161
  6456167
  6456201
  6456379
  6456424
  6456533
  6456626
  6456628
  6456629
  6456706
  6456750
  6456792
  6457025
  6457227
  6457280
  6457296
  6457423
  6457443
  6457539
  6457561
  6457759
  6457803
  6458178
  6458489
  6459162
  6459228
  6459571
  6460036
  6460039
  6460061
  6460133
  6460312
  6460453
  6461104
  6461281
  6461346
  6461354
  6461357
  6461600
  6461645
  6461751
  6461910
  6462629
  6462653
  6462767
  6463176
  6463512
  6463527
  6463604
  6463659
  6463937
  6464010
  6464485
  6465871
  6465933
  6465935
  6466719
  6466944
  6468042
  6469829
  6469876
  6469881
  6470299
  6470501
  6470533
  6470547
  6471027
  6471204
  6471370
  6471369
  6471454
  6471491
  6471526
  6471801
  6472139
  6472178
  6472706
  6472733
  6472766
  6472906
  6474476
  6474521
  6474688
  6475335
  6475567
  6475842
  6476486
  6476573
  6476977
  6477006
  6477124
  6477210
  6477645
  6477666
  6477845
  6477855
  6480421
  6480471
  6480487
  6480488
  6480517
  6480817
  6480877
  6481010
  6481159
  6481196
  6481658
  6481731
  6481937
  6482776
  6482987
  6483369
  6483533
  6483540
  6483961
  6483967
  6483993
  6483994
  6483997
  6484000
  6484233
  6484872
  6485022
  6485258
  6485431
  6485593
  6485968
  6485996
  6486002
  6486055
  6486295
  6486734
  6486753
  6486870
  6487914
  6488384
  6488533
  6489007
  6489009
  6490084
  6491037
  6491045
  6491486
  6491608
  6491863
  6492245
  6493065
  6493131
  6493193
  6493408
  6493896
  6493931
  6494352
  6494388
  6494743
  6494881
  6495127
  6495253
  6495577
  6495662
  6495827
  6496239
  6496290
  6496519
  6497054
  6497169
  6497189
  6497239
  6497254
  6497256
  6497261
  6497314
  6497424
  6497454
  6497477
  6497481
  6497592
  6497616
  6497708
  6497770
  6497903
  6497915
  6497932
  6498083
  6498150
  6498275
  6498359
  6498463
  6498513
  6498616
  6498632
  6498856
  6499153
  6499236
  6499378
  6499440
  6499452
  6499459
  6499517
  6499535
  6499778
  6499817
  6499989
  6500258
  6500260
  6500318
  6500323
  6500324
  6500325
  6500555
  6500830
  6500835
  6500881
  6500890
  6500926
  6501067
  6501224
  6501383
  6501391
  6501403
  6501443
  6501459
  6501533
  6501612
  6501633
  6501727
  6501762
  6501837
  6501860
  6501990
  6502006
  6502008
  6502019
  6502063
  6502111
  6502114
  6502149
  6502547
  6502587
  6502606
  6502836
  6502837
  6502934
  6502963
  6503088
  6503446
  6503529
  6503566
  6503767
  6503778
  6503973
  6503999
  6504037
  6504208
  6504255
  6504259
  6504268
  6504880
  6505775
  6506345
  6506375
  6506487
  6506666
  6506669
  6507223
  6507283
  6507508
  6507688
  6507817
  6507818
  6507831
  6507868
  6507931
  6507942
  6508573
  6508587
  6508744
  6509081
  6509250
  6509371
  6509392
  6509642
  6509646
  6509717
  6510165
  6510310
  6510409
  6511056
  6511095
  6512456
  6512579
  6512924
  6512929
  6512933
  6515783
  6515822
  6517036
  6517418
  6518042
  6518355
  6518475
  6518520
  6518536
  6518537
  6518689
  6519517
  6519520
  6520056
  6520704
  6521524
  6521697
  6521703
  6521750
  6522006
  6522234
  6522246
  6522253
  6522427
  6522470
  6522471
  6522963
  6523976
  6524009
  6524062
  6524227
  6524285
  6524290
  6524291
  6524294
  6524324
  6524331
  6524402
  6524410
  6524445
  6524460
  6524630
  6524644
  6524673
  6525019
  6525213
  6525282
  6525319
  6525351
  6525445
  6525509
  6525637
  6526063
  6526067
  6526182
  6526296
  6526488
  6526561
  6527196
  6527488
  6528078
  6528111
  6528123
  6528392
  6528394
  6528462
  6528465
  6528598
  6528734
  6528753
  6528782
  6528791
  6528901
  6528912
  6528913
  6528942
  6529073
  6529242
  6529277
  6529319
  6529336
  6529360
  6529882
  6530038
  6530099
  6530101
  6530114
  6530128
  6530220
  6530222
  6530257
  6530277
  6530278
  6530313
  6530332
  6530337
  6530340
  6530413
  6530475
  6530558
  6530641
  6530686
  6530703
  6530931
  6530990
  6532764
  6532782
  6532789
  6532828
  6532874
  6532929
  6532949
  6533171
  6533178
  6533199
  6533204
  6533207
  6533221
  6533487
  6534618
  6534902
  6535107
  6535062
  6535675
  6535728
  6535740
  6535866
  6535870
  6536173
  6536566
  6536867
  6537092
  6537142
  6537559
  6537572
  6537617
  6537624
  6537972
  6538196
  6538230
  6538637
  6539618
  6539947
  6539972
  6540171
  6540225
  6540936
  6541441
  6541722
  6542111
  6542142
  1000000818
  1000001089
  6361152
  1000001998
  1000002360
  1000002363
  1000002440
  6387964
  1000002047
  1000002930
  1000003892
  1000003992
  1000001006
  6390301
  1000004313
  1000004806
  1000004156
  1000005026
  1000004568
  1000005169
  6384060
  1000004565
  1000001803
  1000005776
  1000005936
  1000006372
  1000006802
  1000007084
  1000007401
  6334674
  1000007912
  1000002561
  1000005264
  1000005074
  1000008052
  1000004819
  1000004521
  1000007773
  1000008640
  1000006833
  1000008825
  1000001404
  1000004137
  1000008866
  1000002514
  1000009237
  6359372
  1000009381
  1000009821
  1000009940
  1000009915
  1000002708
  1000004245
  1000007460
  1000005028
  1000010294
  1000010003
  1000009248
  1000009717
  1000010893
  1000010669
  1000002066
  1000011009
  1000011814
  1000011830
  1000009375
  1000010148
  1000009602
  1000010874
  1000012132
  1000010960
  1000012160
  1000011864
  1000010193
  1000010835
  1000012621
  1000013016
  1000006028
  1000013215
  1000013427
  1000012780
  1000013208
  1000013339
  1000010763
  1000012989
  1000014014
  1000014418
  1000009844
  1000013779
  1000014304
  1000014709
  1000014738
  1000014739
  1000014741
  1000011050
  1000014915
  1000013363
  1000012248
  1000010092
  1000012704
  1000013953
  1000014223
  1000015397
  1000014419
  1000015408
  1000015599
  1000015619
  1000006062
  1000015818
  1000016234
  1000013469
  1000016195
  1000016472
  1000016480
  1000014747
  1000017112
  1000017208
  1000017209
  1000017210
  1000017302
  1000015296
  1000017328
  1000017411
  1000017707
  1000017709
  1000017710
  1000017712
  1000017733
  1000017739
  1000017746
  1000017953
  1000017954
  1000017955
  1000017956
  1000018314
  1000016035
  1000018539
  1000018540
  1000018541
  1000014377
  1000018650
  1000018751
  1000006098
  1000016969
  1000018962
  1000019083
  1000019100
  1000019104
  1000019115
  1000019136
  1000019268
  1000019376
  1000017225
  1000019505
  1000019507
  1000019508
  1000019509
  1000019510
  1000012927
  1000019903
  1000020308
  1000020309
  1000020310
  1000020313
  1000020314
  1000020346
  1000020348
  1000020349
  1000020350
  1000020352
  1000020353
  1000016320
  1000020900
  1000020904
  1000020905
  1000020907
  1000020908
  1000020909
  1000020912
  1000020914
  1000020915
  1000020918
  1000020919
  1000020972
  1000020973
  1000020974
  1000020975
  1000020976
  1000014167
  1000021073
  1000021076
  1000021080
  1000021084
  1000021085
  1000021102
  1000020188
  1000010671
  1000015249
  1000021148
  1000016113
  1000021354
  1000021498
  1000021818
  1000021825
  1000021828
  1000021856
  1000021858
  1000021864
  1000021886
  1000021891
  1000021904
  1000013935
  1000021928
  1000022728
  1000014891
  1000023555
  1000023568
  1000024568
  1000024569
  1000024570
  1000024571
  1000024572
  1000024573
  1000024574
  1000024575
  1000016439
  1000024679
  1000024680
  1000024681
  1000024682
  1000024683
  1000024684
  1000024685
  1000024686
  1000024687
  1000024688
  1000024689
  1000024690
  1000024691
  1000024692
  1000024693
  1000024694
  1000024695
  1000024696
  1000024697
  1000024698
  1000024739
  1000024742
  1000024743
  1000024744
  1000024746
  1000024747
  1000024763
  1000017957
  1000025759
  1000026476
  1000017401
  1000026573
  1000023639
  1000026649
  1000026146
  1000027363
  1000027364
  1000027365
  1000027366
  1000023910
  1000027431
  1000028089
  1000018257
  1000028286
  1000028492
  1000028592
  1000028597
  1000028671
  1000028673
  1000015502
  1000028820
  1000016528
  1000026108
  1000029307
  1000015131
  1000019169
  1000030092
  1000022840
  1000028675
  1000030836
  1000030837
  1000030840
  1000030845
  1000030846
  1000030848
  1000030865
  1000030906
  1000028244
  1000017748
  1000028676
  1000026923
  1000012435
  1000016473
  1000016787
  1000029896
  1000026586
  1000032720
  1000020152
  1000033868
  1000018536
  1000019123
  1000034238
  1000034239
  1000034240
  1000034241
  1000034242
  1000034489
  1000034494
  1000027529
  1000034663
  1000012658
  1000035271
  1000035281
  1000010721
  1000035912
  1000035971
  1000035974
  1000035980
  1000035984
  1000035988
  1000035990
  1000006589
  1000036252
  1000036277
  1000036286
  1000022809
  1000036423
  1000036741
  1000036742
  1000037725
  1000037738
  1000022807
  1000036216
  1000039311
  1000039324
  1000039325
  1000039326
  1000039327
  1000039328
  1000027876
  1000039314
  1000015922
  1000033971
  1000040554
  1000035640
  1000041580
  1000041581
  1000041583
  1000024087
  1000030908
  1000042168
  1000029441
  1000042850
  1000043009
  1000043021
  1000042165
  1000022803
  1000043408
  1000043445
  1000043446
  1000043447
  1000043448
  1000043449
  1000043648
  1000043669
  1000043672
  1000043679
  1000043681
  1000043705
  1000043927
  1000043085
  1000026590
  1000044568
  1000044590
  1000044798
  1000044811
  1000044823
  1000044866
  1000044913
  1000044945
  1000039739
  1000045048
  1000045051
  1000045053
  1000045055
  1000045057
  1000045062
  1000045065
  1000045066
  1000045068
  1000045074
  1000045082
  1000045100
  1000045103
  1000045903
  1000045906
  1000045912
  1000046056
  1000046210
  1000046216
  1000046347
  1000046348
  1000046349
  1000046418
  1000009336
  1000046819
  1000046838
  1000046875
  1000044508
  1000046901
  1000047145
  1000009928
  1000043272
  1000047583
  1000047135
  1000028619
  1000047954
  1000048085
  1000048086
  1000025959
  1000048133
  1000048260
  1000048328
  1000048331
  1000032846
  1000048401
  1000036007
  1000048490
  1000048773
  1000048774
  1000032787
  1000048162
  1000049296
  1000049321
  1000048900
  1000049607
  1000049706
  1000049747
  1000049754
  1000045108
  1000049584
  1000049757
  1000049811
  1000049912
  1000050149
  1000025298
  1000033089
  1000008587
  1000050399
  1000050479
  1000050214
  1000049008
  1000050637
  1000050419
  1000047804
  1000051046
  1000051056
  1000051079
  1000051213
  1000051371
  1000051377
  1000050496
  1000049689
  1000050195
  1000049448
  1000051057
  1000051588
  1000051012
  1000052073
  1000052479
  1000052555
  1000052558
  1000052609
  1000052806
  1000052807
  1000052802
  1000052949
  1000050372
  1000052913
  1000053273
  1000010043
  1000053297
  1000045244
  1000048580
  1000053333
  1000032428
  1000052810
  1000052814
  1000050919
  1000051700
  1000051749
  1000052131
  1000008158
  1000053477
  1000053490
  1000050765
  1000054031
  1000054032
  1000054033
  1000053842
  1000053301
  1000006965
  1000019932
  1000053931
  1000054214
  1000054239
  1000054246
  1000054248
  1000054252
  1000054330
  1000054343
  1000054411
  1000054488
  1000053871
  1000017165
  1000054037
  1000054699
  1000054860
  1000052681
  1000054897
  1000049942
  1000055074
  1000055111
  1000055154
  1000055201
  1000055225
  1000053874
  1000055508
  1000055679
  1000052670
  1000055686
  1000055888
  1000056435
  1000056720
  1000056721
  1000056997
  1000051339
  1000057163
  1000053011
  1000054483
  1000057081
  1000057344
  1000057575
  1000057578
  1000055873
  1000057830
  1000057917
  1000057213
  1000058860
  1000058911
  1000058914
  1000059061
  1000057517
  1000059063
  1000059940
  1000060017
  1000060188
  1000060213
  1000060214
  1000060318
  1000059470
  1000060386
  1000060015
  1000061043
  1000061232
  1000061315
  1000061465
  1000061471
  1000061389
  1000061552
  1000061531
  1000061616
  1000061745
  1000054088
  1000062288
  1000062378
  1000059246
  1000062479
  1000055717
  1000061392
  1000053402
  1000062863
  1000062994
  1000063546
  1000063747
  1000063754
  1000063755
  1000063773
  1000063811
  1000063920
  1000064134
  1000055929
  1000064233
  1000064245
  1000064799
  1000064885
  1000064569
  1000064886
  1000063552
  1000064298
  1000064978
  1000063704
  1000065116
  1000065320
  1000065328
  1000057545
  1000066145
  1000066195
  1000066241
  1000066343
  2030
]
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:
[
  26728
]
21 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:
[
  9651
]
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:
[
  10481
]
23 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:
[
  2029
]
24 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:
[
  56130
]
25 0.27 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:
[
  96784
]
26 0.23 ms
SELECT t0.id AS id_1, t0.min_qty AS min_qty_2, t0.max_qty AS max_qty_3, t0.step_qty AS step_qty_4, t0.product_id AS product_id_5 FROM product_rule t0 WHERE t0.product_id = ?
Parameters:
[
  65981
]
27 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:
[
  65676
]
28 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
]
29 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:
[
  2886
]
30 0.46 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.44 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.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:
[
  16
]
33 0.22 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.displayed_order AS displayed_order_3, t0.is_in_footer AS is_in_footer_4, t0.slug AS slug_5, t0.category_parent_id AS category_parent_id_6 FROM category t0 WHERE t0.category_parent_id = ?
Parameters:
[
  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.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:
[
  19
]
36 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:
[
  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.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:
[
  22
]
39 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:
[
  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.31 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.displayed_order AS displayed_order_3, t0.is_in_footer AS is_in_footer_4, t0.slug AS slug_5, t0.category_parent_id AS category_parent_id_6 FROM category t0 WHERE t0.category_parent_id = ?
Parameters:
[
  25
]
42 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:
[
  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.26 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.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:
[
  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.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:
[
  32
]
49 0.55 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:
[
  2030
]
50 0.72 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.reference IN (?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  "15167"
  "15169"
  "15179"
  "15180"
  "15181"
  "15171"
  "15172"
]

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 1508
App\Entity\Customer\Customer 478
App\Entity\Delivery\Delivery 396
App\Entity\User\User 377
App\Entity\Catalog\ProductCatalog 168
App\Entity\Catalog\CustomerCatalog 168
App\Entity\Product\Market 109
App\Entity\Internal\Commercial 53
App\Entity\Pricing\Price 50
App\Entity\Product\ProductPrice 49
App\Entity\Product\Product 27
App\Entity\Product\Category 21
App\Entity\Product\Characteristic 20
App\Entity\Product\CharacteristicLabel 19
App\Entity\Delivery\DeliveryCost 6
App\Entity\Internal\Society 4
App\Entity\Internal\Parameter 1
App\Infrastructure\Doctrine\Entity\ProductRule 1