GET https://staging.pgdis.com/produit/25082-papier-dessin-noir-n-c-25082

Query Metrics

49 Database Queries
12 Different statements
3925.16 ms Query time
0 Invalid entities
3258 Managed entities

Queries

Group similar statements

# Time Info
1 36.52 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:
[
  "25082-papier-dessin-noir-n-c-25082"
]
2 0.49 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:
[
  185668
]
3 0.59 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:
[
  "25082-papier-dessin-noir-n-c-25082"
]
4 0.42 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:
[
  "25082-papier-dessin-noir-n-c-25082"
]
5 0.45 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:
[
  185668
  1
]
6 1.56 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:
[
  83
  388
  389
  390
  391
  392
  393
  394
  395
  391
  185668
]
7 0.43 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:
[
  924
]
8 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:
[
  925
]
9 0.16 ms
SELECT t0.id AS id_1, t0.min_qty AS min_qty_2, t0.max_qty AS max_qty_3, t0.step_qty AS step_qty_4, t0.product_id AS product_id_5 FROM product_rule t0 WHERE t0.product_id = ?
Parameters:
[
  1266
]
10 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:
[
  1267
]
11 0.17 ms
SELECT t0.id AS id_1, t0.min_qty AS min_qty_2, t0.max_qty AS max_qty_3, t0.step_qty AS step_qty_4, t0.product_id AS product_id_5 FROM product_rule t0 WHERE t0.product_id = ?
Parameters:
[
  1270
]
12 0.17 ms
SELECT t0.id AS id_1, t0.min_qty AS min_qty_2, t0.max_qty AS max_qty_3, t0.step_qty AS step_qty_4, t0.product_id AS product_id_5 FROM product_rule t0 WHERE t0.product_id = ?
Parameters:
[
  1271
]
13 0.39 ms
SELECT t0.id AS id_1, t0.min_qty AS min_qty_2, t0.max_qty AS max_qty_3, t0.step_qty AS step_qty_4, t0.product_id AS product_id_5 FROM product_rule t0 WHERE t0.product_id = ?
Parameters:
[
  1279
]
14 0.17 ms
SELECT t0.id AS id_1, t0.min_qty AS min_qty_2, t0.max_qty AS max_qty_3, t0.step_qty AS step_qty_4, t0.product_id AS product_id_5 FROM product_rule t0 WHERE t0.product_id = ?
Parameters:
[
  1395
]
15 0.15 ms
SELECT t0.id AS id_1, t0.min_qty AS min_qty_2, t0.max_qty AS max_qty_3, t0.step_qty AS step_qty_4, t0.product_id AS product_id_5 FROM product_rule t0 WHERE t0.product_id = ?
Parameters:
[
  1420
]
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:
[
  1532
]
17 0.36 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 2460.32 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:
[
  185668
  "2025-04-12 14:25:37"
]
19 1416.01 ms
SELECT p0_.id AS id_0, p0_.reference AS reference_1, p0_.manufacturer AS manufacturer_2, p0_.short_label AS short_label_3, p0_.long_label AS long_label_4, p0_.weight AS weight_5, p0_.sold_by AS sold_by_6, p0_.ppht AS ppht_7, p0_.ppttc AS ppttc_8, p0_.paht AS paht_9, p0_.pattc AS pattc_10, p0_.legal_discount_library AS legal_discount_library_11, p0_.fidelity_bonus AS fidelity_bonus_12, p0_.brand AS brand_13, p0_.time_limit AS time_limit_14, p0_.coef AS coef_15, p0_.is_discountable AS is_discountable_16, p0_.is_btob AS is_btob_17, p0_.is_btoc AS is_btoc_18, p0_.is_customizable AS is_customizable_19, p0_.is_library AS is_library_20, p0_.is_nathan AS is_nathan_21, p0_.is_green AS is_green_22, p0_.is_orapi_grand_frais AS is_orapi_grand_frais_23, p0_.is_active AS is_active_24, p0_.slug AS slug_25 FROM product p0_ INNER JOIN customer_order_lines c1_ ON (c1_.product_id = p0_.id) INNER JOIN customer_order c2_ ON c1_.customer_order_id = c2_.id WHERE c2_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND p0_.id <> ? AND p0_.is_btoc = 1 AND p0_.is_orapi_grand_frais <> 1 GROUP BY p0_.id, p0_.reference, p0_.manufacturer, p0_.short_label, p0_.long_label, p0_.weight, p0_.sold_by, p0_.ppht, p0_.ppttc, p0_.paht, p0_.pattc, p0_.legal_discount_library, p0_.fidelity_bonus, p0_.brand, p0_.time_limit, p0_.coef, p0_.is_discountable, p0_.is_btob, p0_.is_btoc, p0_.is_customizable, p0_.is_library, p0_.is_nathan, p0_.is_green, p0_.is_orapi_grand_frais, p0_.is_active, p0_.slug ORDER BY COUNT(p0_.id) DESC LIMIT 10
Parameters:
[
  6384278
  6384368
  6384176
  6385367
  6384927
  6386065
  6383123
  6386545
  6385142
  6386912
  6387254
  6387369
  6388128
  6384680
  6388519
  6383065
  6384101
  6389133
  6390418
  6390524
  6390558
  6390564
  6390859
  6391196
  6391348
  6391543
  6391353
  6392179
  6392282
  6392300
  6365569
  6378946
  6380653
  6393603
  6393631
  6393906
  6393942
  6394106
  6392420
  6394731
  6395453
  6395782
  6396233
  6398208
  6398227
  6398276
  6398294
  6398401
  6398672
  6398709
  6398743
  6398837
  6398892
  6400514
  6401689
  6402496
  6402640
  6402820
  6403273
  6403401
  6403679
  6403684
  6404296
  6404608
  6404816
  6405622
  6405661
  6405686
  6407527
  6407971
  6408954
  6409382
  6410003
  6410744
  6411130
  6411836
  6411921
  6412627
  6413068
  6413479
  6413703
  6414275
  6414277
  6414357
  6414942
  6415012
  6415107
  6415450
  6415705
  6415891
  6416028
  6416119
  6416713
  6416927
  6416980
  6417628
  6417648
  6417662
  6418126
  6418147
  6418265
  6418536
  6418879
  6418981
  6419058
  6419125
  6419137
  6419138
  6419216
  6419219
  6419252
  6419273
  6419294
  6419296
  6419342
  6419393
  6419703
  6419894
  6419896
  6420529
  6420573
  6420628
  6420677
  6421002
  6421723
  6421912
  6422093
  6422655
  6422683
  6422696
  6422717
  6422759
  6422808
  6422969
  6423593
  6423986
  6424138
  6424264
  6424339
  6425476
  6426129
  6426135
  6426244
  6426279
  6426436
  6426442
  6426626
  6426704
  6426868
  6426947
  6427033
  6427186
  6427190
  6427215
  6427231
  6427377
  6427388
  6428197
  6428263
  6428427
  6428672
  6428781
  6428917
  6429135
  6429219
  6429221
  6429653
  6429813
  6431185
  6431294
  6431486
  6431494
  6431522
  6431732
  6431906
  6433720
  6433779
  6434215
  6434335
  6434590
  6434652
  6434819
  6434877
  6434852
  6434941
  6435035
  6435208
  6435321
  6435470
  6435935
  6435972
  6436250
  6436760
  6437044
  6437059
  6437148
  6437618
  6437695
  6437791
  6437800
  6438080
  6438119
  6438664
  6438808
  6438816
  6439101
  6439279
  6439452
  6439538
  6439560
  6440154
  6440359
  6440517
  6440846
  6441144
  6441212
  6441527
  6441715
  6442130
  6442186
  6442578
  6443113
  6443373
  6443418
  6443537
  6443572
  6443957
  6443970
  6443978
  6444044
  6444097
  6444575
  6444582
  6444671
  6444753
  6445264
  6445271
  6445530
  6445564
  6446113
  6446114
  6446118
  6446274
  6446366
  6446680
  6446773
  6446812
  6446988
  6447379
  6447400
  6447577
  6447672
  6447673
  6447709
  6448583
  6448828
  6448829
  6448853
  6448957
  6449432
  6449544
  6449616
  6449703
  6449824
  6449907
  6450175
  6450180
  6450188
  6450191
  6450196
  6450251
  6450405
  6450435
  6450448
  6450497
  6450549
  6450560
  6450578
  6450580
  6450582
  6450770
  6450771
  6450791
  6450856
  6450970
  6450989
  6451082
  6451103
  6451129
  6451271
  6451316
  6451357
  6451415
  6451434
  6451439
  6451494
  6451495
  6451641
  6451701
  6451964
  6452004
  6452022
  6452084
  6452101
  6452216
  6452223
  6452247
  6452256
  6452300
  6452350
  6452378
  6452427
  6452487
  6452536
  6452537
  6452544
  6452594
  6453276
  6453465
  6453634
  6453836
  6453913
  6454177
  6454365
  6454530
  6454558
  6454566
  6454586
  6454660
  6454702
  6454771
  6454852
  6454860
  6454864
  6454935
  6454944
  6454977
  6455004
  6455027
  6455153
  6455234
  6455240
  6455307
  6455345
  6455357
  6455451
  6455484
  6455507
  6455528
  6455716
  6455717
  6455889
  6456020
  6456075
  6456085
  6456107
  6456111
  6456116
  6456125
  6456560
  6456808
  6456957
  6457246
  6457442
  6457933
  6457950
  6458990
  6459472
  6459571
  6459748
  6459930
  6460126
  6460237
  6461051
  6461259
  6461276
  6461568
  6462316
  6462917
  6462996
  6463001
  6463173
  6463223
  6463419
  6463651
  6464691
  6465958
  6466050
  6466845
  6466864
  6467030
  6468194
  6468713
  6468787
  6468803
  6469146
  6469162
  6469218
  6470249
  6470285
  6470533
  6470682
  6471280
  6471430
  6471838
  6471857
  6472309
  6472810
  6472926
  6472960
  6473029
  6473208
  6473227
  6473307
  6474518
  6474763
  6474814
  6474831
  6474879
  6474971
  6475318
  6475339
  6475422
  6475567
  6476462
  6476565
  6476689
  6476752
  6476911
  6476970
  6476985
  6477016
  6477056
  6477576
  6477597
  6477800
  6477907
  6478878
  6480361
  6480487
  6480789
  6480816
  6481204
  6481386
  6481428
  6481969
  6482778
  6482853
  6482897
  6483248
  6483452
  6483574
  6483749
  6483805
  6483983
  6484570
  6484864
  6484889
  6485233
  6485578
  6485729
  6486002
  6486041
  6486056
  6486111
  6486441
  6486736
  6486856
  6486926
  6487190
  6488451
  6488475
  6488533
  6488582
  6488917
  6489089
  6489145
  6490052
  6490053
  6490074
  6490832
  6490985
  6491004
  6491061
  6491462
  6492306
  6492410
  6492921
  6493186
  6493193
  6493408
  6493857
  6494186
  6494466
  6494475
  6494678
  6494703
  6494761
  6494953
  6495623
  6495662
  6495916
  6495959
  6496225
  6496266
  6496302
  6496365
  6496388
  6497016
  6497135
  6497179
  6497182
  6497254
  6497344
  6497753
  6497779
  6497899
  6498085
  6498142
  6498158
  6498217
  6498244
  6498251
  6498307
  6498345
  6498346
  6498424
  6498482
  6498489
  6498828
  6498936
  6498971
  6499062
  6499152
  6499153
  6499182
  6499265
  6499622
  6499627
  6500146
  6500242
  6500285
  6500714
  6500911
  6501410
  6501411
  6501445
  6501731
  6501813
  6501837
  6501871
  6501910
  6501972
  6501980
  6501992
  6502030
  6502042
  6502101
  6502141
  6502264
  6502341
  6502353
  6502360
  6502393
  6502435
  6502455
  6502498
  6502527
  6502533
  6502630
  6502698
  6502722
  6502848
  6503087
  6503356
  6503378
  6503631
  6503786
  6503837
  6503996
  6504079
  6504246
  6504251
  6504467
  6504645
  6505500
  6506375
  6506409
  6506437
  6506818
  6506992
  6507196
  6507199
  6507494
  6507817
  6507831
  6507893
  6508383
  6508518
  6508528
  6508774
  6508991
  6509152
  6509375
  6509442
  6509462
  6510153
  6511066
  6511107
  6511229
  6512313
  6512386
  6512545
  6512853
  6515187
  6515983
  6516204
  6517335
  6518448
  6518540
  6520347
  6520505
  6520517
  6521183
  6521892
  6521921
  6522092
  6522196
  6522234
  6523351
  6523388
  6523742
  6523972
  6524000
  6524008
  6524026
  6524269
  6524271
  6524279
  6524290
  6524294
  6524326
  6524353
  6524372
  6524399
  6524429
  6524459
  6524464
  6524541
  6524735
  6524862
  6524929
  6524960
  6525177
  6525308
  6525377
  6525427
  6525444
  6525445
  6525447
  6525502
  6525509
  6525615
  6525780
  6525782
  6525835
  6525885
  6525962
  6526016
  6526198
  6526213
  6526229
  6526528
  6526790
  6527015
  6527116
  6527130
  6527170
  6527637
  6527894
  6528015
  6528106
  6528160
  6528207
  6528325
  6528331
  6528471
  6528512
  6528619
  6528640
  6528651
  6528736
  6528749
  6528754
  6528770
  6528791
  6528803
  6528812
  6528814
  6528859
  6528965
  6528997
  6529030
  6529110
  6529113
  6529132
  6529167
  6529216
  6529274
  6529336
  6529359
  6529702
  6529862
  6529882
  6529942
  6529981
  6529986
  6529987
  6529989
  6530064
  6530101
  6530102
  6530114
  6530128
  6530145
  6530245
  6530269
  6530278
  6530284
  6530295
  6530342
  6530522
  6530539
  6530749
  6530757
  6530773
  6531075
  6531203
  6532765
  6532768
  6532788
  6532818
  6532887
  6533156
  6533198
  6533205
  6533221
  6534495
  6534496
  6535406
  6535583
  6535598
  6535668
  6535929
  6537085
  6537095
  6537101
  6537363
  6537559
  6537572
  6537583
  6537929
  6537982
  6538099
  6538900
  6538902
  6538941
  6538943
  6538949
  6539235
  6539340
  6539377
  6539561
  6539660
  6539723
  6539884
  6539985
  6540069
  6540070
  6540090
  6540096
  6540178
  6540219
  6540617
  6541037
  6541453
  6541813
  6541953
  6390645
  1000000836
  1000000838
  6389467
  6391216
  1000001661
  1000001665
  1000002045
  1000002138
  1000002139
  1000002140
  1000002141
  1000002142
  1000002292
  1000000976
  1000002764
  1000003003
  1000001340
  1000003186
  6391971
  1000004617
  1000004746
  1000005108
  6394677
  6340647
  1000005746
  1000006020
  1000006499
  1000007005
  1000007215
  1000001655
  1000006116
  1000007487
  1000007644
  1000007881
  1000007912
  1000008052
  1000008520
  1000008532
  1000008533
  1000008534
  1000008630
  1000005034
  1000002144
  1000000786
  1000008913
  1000008914
  1000001197
  1000009447
  1000009451
  1000009452
  1000009185
  1000008328
  1000005293
  1000009892
  1000005333
  1000010111
  1000010225
  1000006800
  1000010229
  1000010326
  1000010559
  1000009531
  1000010743
  1000003639
  1000010839
  1000010537
  1000010932
  1000011008
  1000011801
  1000010840
  1000010116
  1000011914
  1000012018
  1000012276
  1000012691
  1000012692
  1000012695
  1000012218
  1000011864
  1000012950
  1000009712
  1000013097
  1000013099
  1000010241
  1000012077
  1000013243
  1000013248
  1000013250
  6384616
  1000012913
  1000009644
  1000010746
  1000012453
  1000011051
  1000012553
  1000014505
  1000014608
  1000014724
  1000015120
  1000015448
  1000012979
  1000015628
  1000015708
  1000015771
  1000015788
  1000015815
  1000015818
  1000014308
  1000015575
  1000015964
  1000015965
  1000015966
  1000015970
  1000015971
  1000007357
  1000016150
  1000016158
  1000016234
  1000016381
  1000016382
  1000016384
  1000016388
  1000016410
  1000016672
  1000016681
  1000014747
  1000014799
  1000017112
  1000017208
  1000017209
  1000017210
  1000017227
  1000017229
  1000017230
  1000007022
  1000001816
  1000017166
  1000015580
  1000008596
  1000010017
  1000017579
  1000017587
  1000017685
  1000017752
  1000017968
  1000018055
  1000018056
  1000018085
  1000018086
  1000018087
  1000018096
  1000018107
  1000017754
  1000018345
  1000018559
  1000018613
  1000018626
  1000018640
  1000018651
  1000018658
  1000018668
  1000018671
  1000018680
  1000018688
  1000018709
  1000018818
  1000016969
  1000018845
  1000018846
  1000018864
  1000018866
  1000018906
  1000018911
  1000018920
  1000018926
  1000018927
  1000018937
  1000014395
  1000019216
  1000019218
  1000019220
  1000019221
  1000019222
  1000019223
  1000019224
  1000019229
  1000019234
  1000019236
  1000019239
  1000019373
  1000012337
  1000020892
  1000017771
  1000021401
  1000021531
  1000021618
  1000021620
  1000021623
  1000021625
  1000014644
  1000021820
  1000021822
  1000021823
  1000021913
  1000021914
  1000002102
  1000019604
  1000012427
  1000022655
  1000022692
  1000021371
  1000023079
  1000023082
  1000023085
  1000023087
  1000017690
  1000024214
  1000024522
  1000024523
  1000024524
  1000024525
  1000024526
  1000024527
  1000024528
  1000024529
  1000024533
  1000024535
  1000024537
  1000024538
  1000012484
  1000014451
  1000019352
  1000022810
  1000016842
  1000026448
  1000026449
  1000026450
  1000021921
  1000023036
  1000006166
  1000026680
  1000026451
  1000026915
  1000026928
  1000026929
  1000026934
  1000026995
  1000027059
  1000021630
  1000027313
  1000027369
  1000027375
  1000027377
  1000027382
  1000027384
  1000015836
  1000011043
  1000013448
  1000027856
  1000027857
  1000027858
  1000027864
  1000027865
  1000027885
  1000027894
  1000027980
  1000028005
  1000028148
  1000028152
  1000016528
  1000016471
  1000029262
  1000029286
  1000029325
  1000029330
  1000029331
  1000029332
  1000029333
  1000029378
  1000029382
  1000029388
  1000029390
  1000029392
  1000029434
  1000029435
  1000029860
  1000029861
  1000029863
  1000006162
  1000029869
  1000030111
  1000030126
  1000030127
  1000030423
  1000007033
  1000031240
  1000031246
  1000025677
  1000031844
  1000031845
  1000031848
  1000031852
  1000017140
  1000017001
  1000032999
  1000033002
  1000033004
  1000033043
  1000033044
  1000033048
  1000033050
  1000033054
  1000033448
  1000033504
  1000033511
  1000021719
  1000034513
  1000034691
  1000034695
  1000034705
  1000017550
  1000012658
  1000034723
  1000034863
  1000033478
  1000035394
  1000035409
  1000035411
  1000035421
  1000035430
  1000033444
  1000010721
  1000036162
  1000016099
  1000036599
  1000036600
  1000036613
  1000036721
  1000037738
  1000038349
  1000038350
  1000038405
  1000038410
  1000038427
  1000038429
  1000038438
  1000038528
  1000038530
  1000038548
  1000038795
  1000038838
  1000016485
  1000027876
  1000028155
  1000039855
  1000040045
  1000040047
  1000040048
  1000040269
  1000040947
  1000041230
  1000041291
  1000041292
  1000041293
  1000041301
  1000041305
  1000041317
  1000041322
  1000041323
  1000041324
  1000041337
  1000041340
  1000039206
  1000041608
  1000041903
  1000042033
  1000039265
  1000042044
  1000042055
  1000042056
  1000042061
  1000042062
  1000042077
  1000042080
  1000022240
  1000040124
  1000042584
  1000037837
  1000041568
  1000027618
  1000019856
  1000030762
  1000042980
  1000015887
  1000043031
  1000043040
  1000043107
  1000043109
  1000043123
  1000014960
  1000018730
  1000043724
  1000038796
  1000044078
  1000044322
  1000044323
  1000044402
  1000044403
  1000044404
  1000044405
  1000044406
  1000044407
  1000044408
  1000044409
  1000044411
  1000044412
  1000044413
  1000044414
  1000044451
  1000044452
  1000044454
  1000044477
  1000044483
  1000044576
  1000044578
  1000044585
  1000044717
  1000044723
  1000044724
  1000044726
  1000044731
  1000044737
  1000044754
  1000044756
  1000044782
  1000044784
  1000044790
  1000044799
  1000044801
  1000044806
  1000044812
  1000044880
  1000044896
  1000044957
  1000044959
  1000044964
  1000044966
  1000044970
  6385285
  1000045039
  1000045041
  1000045042
  1000045051
  1000045053
  1000045055
  1000045057
  1000045062
  1000045065
  1000045066
  1000045068
  1000045074
  1000045082
  1000045100
  1000045103
  1000041693
  1000045285
  1000045314
  1000045315
  1000045354
  1000045355
  1000045356
  1000045318
  1000035440
  1000046471
  1000041412
  1000046658
  1000046876
  1000045172
  1000047331
  1000047333
  1000047334
  1000047339
  1000047340
  1000047342
  1000047343
  1000047344
  1000047345
  1000047347
  1000047348
  1000047349
  1000047359
  1000047360
  1000047365
  1000047366
  1000047367
  1000047372
  1000047373
  1000037109
  1000022585
  1000047420
  1000047714
  1000044630
  1000048148
  1000048199
  1000048200
  1000048217
  1000048218
  1000048219
  1000048227
  1000048228
  1000048272
  1000037807
  1000048524
  1000014996
  1000048865
  1000048893
  1000048895
  1000048928
  1000048991
  1000048827
  1000038556
  1000024541
  1000049188
  1000049310
  1000049261
  1000049433
  1000049439
  1000049126
  1000048971
  1000049489
  1000049491
  1000049492
  1000049588
  1000049697
  1000049706
  1000049747
  1000049754
  1000045108
  1000049830
  1000049811
  1000049868
  1000049884
  1000048913
  1000049990
  1000019463
  1000048299
  1000050129
  1000050131
  1000050132
  1000050209
  1000008587
  1000045633
  1000032442
  1000050179
  1000050568
  1000050376
  1000050318
  1000050664
  1000050727
  1000050898
  1000050945
  1000050987
  1000050988
  1000050989
  1000051213
  1000050724
  1000041958
  1000051403
  1000050195
  1000051411
  1000048909
  1000051511
  1000040542
  1000050713
  1000051628
  1000021544
  1000051834
  1000051891
  1000012696
  1000051911
  1000052073
  1000051889
  1000051215
  1000049720
  1000052381
  1000049637
  1000052510
  1000049690
  1000052625
  1000017969
  1000052636
  1000052750
  1000043594
  1000052065
  1000052562
  1000053000
  1000053037
  1000050372
  1000053122
  1000052202
  1000050181
  1000049091
  1000052748
  1000053398
  1000053427
  1000053559
  1000053630
  1000051700
  1000053716
  1000053715
  1000050556
  1000053885
  1000052238
  1000054058
  1000054115
  1000053301
  1000052478
  1000054279
  1000054371
  1000054529
  1000050486
  1000054860
  1000054887
  1000054890
  1000054837
  1000055054
  1000055131
  1000055187
  1000055201
  1000047929
  1000055257
  1000045295
  1000055479
  1000055480
  1000055492
  1000055781
  1000049980
  1000055566
  1000033051
  1000055168
  1000055725
  1000055909
  1000049322
  1000056213
  1000056254
  1000056380
  1000056458
  1000056624
  1000056662
  1000056764
  1000049068
  1000057029
  1000057042
  1000057043
  1000056659
  1000056699
  1000057358
  1000057366
  1000057359
  1000057371
  1000045710
  1000057434
  1000043790
  1000057213
  1000043191
  1000058161
  1000053948
  1000057493
  1000058876
  1000058877
  1000058878
  1000058879
  1000058891
  1000058893
  1000058911
  1000050622
  1000055655
  1000056710
  1000059608
  1000059614
  1000059655
  1000059998
  1000060064
  1000059750
  1000060099
  1000060491
  1000060492
  1000060493
  1000060494
  1000045046
  1000059326
  1000061370
  1000061543
  1000057095
  1000061674
  1000061693
  1000060451
  1000061745
  1000061339
  1000061908
  1000055376
  1000059327
  1000062253
  1000062258
  1000062259
  1000062261
  1000062264
  1000062417
  1000062368
  1000062511
  1000062727
  1000062888
  1000062890
  1000063145
  1000062880
  1000063419
  1000063383
  1000008544
  1000063710
  1000063712
  1000054059
  1000058809
  1000062813
  1000064266
  1000064363
  1000064396
  1000064451
  1000064087
  1000064199
  1000064797
  1000064903
  1000064904
  1000065183
  1000065252
  1000049873
  1000065340
  1000065001
  1000065520
  1000065688
  1000065879
  1000064362
  1000066046
  1000066085
  1000066154
  1000066190
  1000066196
  1000066206
  1000065164
  1000066300
  1000066319
  1000064856
  1000066378
  1000066380
  1000016445
  1000066450
  185668
]
20 0.36 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.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:
[
  9651
]
22 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:
[
  56130
]
23 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:
[
  5485
]
24 0.18 ms
SELECT t0.id AS id_1, t0.min_qty AS min_qty_2, t0.max_qty AS max_qty_3, t0.step_qty AS step_qty_4, t0.product_id AS product_id_5 FROM product_rule t0 WHERE t0.product_id = ?
Parameters:
[
  2322
]
25 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:
[
  65981
]
26 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:
[
  96784
]
27 0.25 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.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:
[
  96803
]
29 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:
[
  10481
]
30 0.40 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.displayed_order AS displayed_order_3, t0.is_in_footer AS is_in_footer_4, t0.slug AS slug_5, t0.category_parent_id AS category_parent_id_6 FROM category t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
  1
]
31 0.37 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.displayed_order AS displayed_order_3, t0.is_in_footer AS is_in_footer_4, t0.slug AS slug_5, t0.category_parent_id AS category_parent_id_6 FROM category t0 WHERE t0.category_parent_id = ?
Parameters:
[
  1
]
32 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:
[
  16
]
33 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:
[
  17
]
34 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:
[
  18
]
35 0.27 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.displayed_order AS displayed_order_3, t0.is_in_footer AS is_in_footer_4, t0.slug AS slug_5, t0.category_parent_id AS category_parent_id_6 FROM category t0 WHERE t0.category_parent_id = ?
Parameters:
[
  19
]
36 0.19 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.displayed_order AS displayed_order_3, t0.is_in_footer AS is_in_footer_4, t0.slug AS slug_5, t0.category_parent_id AS category_parent_id_6 FROM category t0 WHERE t0.category_parent_id = ?
Parameters:
[
  20
]
37 0.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.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:
[
  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.20 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.displayed_order AS displayed_order_3, t0.is_in_footer AS is_in_footer_4, t0.slug AS slug_5, t0.category_parent_id AS category_parent_id_6 FROM category t0 WHERE t0.category_parent_id = ?
Parameters:
[
  24
]
41 0.24 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.displayed_order AS displayed_order_3, t0.is_in_footer AS is_in_footer_4, t0.slug AS slug_5, t0.category_parent_id AS category_parent_id_6 FROM category t0 WHERE t0.category_parent_id = ?
Parameters:
[
  25
]
42 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:
[
  26
]
43 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:
[
  27
]
44 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:
[
  28
]
45 0.14 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.displayed_order AS displayed_order_3, t0.is_in_footer AS is_in_footer_4, t0.slug AS slug_5, t0.category_parent_id AS category_parent_id_6 FROM category t0 WHERE t0.category_parent_id = ?
Parameters:
[
  29
]
46 0.13 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.displayed_order AS displayed_order_3, t0.is_in_footer AS is_in_footer_4, t0.slug AS slug_5, t0.category_parent_id AS category_parent_id_6 FROM category t0 WHERE t0.category_parent_id = ?
Parameters:
[
  30
]
47 0.14 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.displayed_order AS displayed_order_3, t0.is_in_footer AS is_in_footer_4, t0.slug AS slug_5, t0.category_parent_id AS category_parent_id_6 FROM category t0 WHERE t0.category_parent_id = ?
Parameters:
[
  31
]
48 0.14 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.displayed_order AS displayed_order_3, t0.is_in_footer AS is_in_footer_4, t0.slug AS slug_5, t0.category_parent_id AS category_parent_id_6 FROM category t0 WHERE t0.category_parent_id = ?
Parameters:
[
  32
]
49 0.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:
[
  185668
]

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 1544
App\Entity\Customer\Customer 517
App\Entity\User\User 404
App\Entity\Delivery\Delivery 369
App\Entity\Catalog\ProductCatalog 94
App\Entity\Catalog\CustomerCatalog 94
App\Entity\Product\Market 66
App\Entity\Pricing\Price 32
App\Entity\Internal\Commercial 32
App\Entity\Product\ProductPrice 25
App\Entity\Product\Product 21
App\Entity\Product\Category 21
App\Entity\Product\Characteristic 14
App\Entity\Product\CharacteristicLabel 13
App\Entity\Delivery\DeliveryCost 7
App\Entity\Internal\Society 4
App\Entity\Internal\Parameter 1