GET https://staging.pgdis.com/produit/22626-accessoires-dessin-couleur-n-c-210-6

Query Metrics

49 Database Queries
12 Different statements
1642.83 ms Query time
0 Invalid entities
2507 Managed entities

Queries

Group similar statements

# Time Info
1 35.06 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:
[
  "22626-accessoires-dessin-couleur-n-c-210-6"
]
2 0.41 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:
[
  169383
]
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:
[
  "22626-accessoires-dessin-couleur-n-c-210-6"
]
4 0.37 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:
[
  "22626-accessoires-dessin-couleur-n-c-210-6"
]
5 1.27 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:
[
  169383
  1
]
6 1.42 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
  388
  169383
]
7 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:
[
  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.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:
[
  1266
]
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:
[
  1267
]
11 0.14 ms
SELECT t0.id AS id_1, t0.min_qty AS min_qty_2, t0.max_qty AS max_qty_3, t0.step_qty AS step_qty_4, t0.product_id AS product_id_5 FROM product_rule t0 WHERE t0.product_id = ?
Parameters:
[
  1270
]
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:
[
  1271
]
13 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:
[
  1279
]
14 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:
[
  1395
]
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:
[
  1420
]
16 0.14 ms
SELECT t0.id AS id_1, t0.min_qty AS min_qty_2, t0.max_qty AS max_qty_3, t0.step_qty AS step_qty_4, t0.product_id AS product_id_5 FROM product_rule t0 WHERE t0.product_id = ?
Parameters:
[
  1532
]
17 0.24 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 556.17 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:
[
  169383
  "2025-04-11 17:59:13"
]
19 1039.05 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:
[
  6385426
  6387832
  6388441
  6388696
  6390295
  6390707
  6391407
  6377102
  6392472
  6392829
  6379682
  6357070
  6384725
  6393909
  6393929
  6394615
  6394673
  6394959
  6395619
  6396226
  6398274
  6398681
  6398980
  6399734
  6400500
  6402615
  6403450
  6406614
  6407039
  6408633
  6408926
  6410416
  6410717
  6411695
  6411701
  6411810
  6411917
  6412823
  6413505
  6413798
  6413816
  6414269
  6414725
  6415108
  6415150
  6415513
  6415673
  6416122
  6416342
  6416343
  6416817
  6416950
  6418956
  6419061
  6419306
  6419374
  6419430
  6419530
  6419545
  6419561
  6419839
  6419888
  6419895
  6420213
  6420668
  6420772
  6421723
  6421896
  6422043
  6422386
  6422813
  6424020
  6424208
  6425035
  6425056
  6425270
  6425308
  6426611
  6426978
  6427262
  6427269
  6427334
  6427923
  6428034
  6428232
  6428619
  6428781
  6428917
  6428927
  6428971
  6429139
  6429255
  6429269
  6429572
  6429620
  6429879
  6429913
  6429979
  6430625
  6430633
  6430682
  6430798
  6430835
  6430854
  6430873
  6431118
  6431211
  6431294
  6431589
  6431909
  6432088
  6432254
  6432304
  6432345
  6433455
  6434600
  6434662
  6434668
  6434757
  6434852
  6434920
  6435303
  6435395
  6436792
  6437037
  6437148
  6438095
  6438517
  6438586
  6438815
  6438935
  6439611
  6439656
  6439715
  6439721
  6440218
  6440231
  6440716
  6441265
  6443264
  6443354
  6443367
  6443843
  6444044
  6444102
  6444125
  6444233
  6444356
  6444750
  6444789
  6445271
  6445653
  6446092
  6446209
  6447063
  6447224
  6447268
  6447288
  6447379
  6447402
  6447662
  6448853
  6449506
  6449725
  6449746
  6450195
  6450196
  6450289
  6450407
  6450443
  6450662
  6450814
  6450890
  6450987
  6451137
  6451169
  6451289
  6451319
  6451346
  6451351
  6451356
  6451376
  6451377
  6451379
  6451429
  6451564
  6451648
  6451651
  6451802
  6452004
  6452007
  6452008
  6452022
  6452031
  6452047
  6452050
  6452099
  6452532
  6452537
  6452555
  6452570
  6452611
  6452830
  6453130
  6453144
  6453276
  6453499
  6453559
  6453571
  6454177
  6454367
  6454527
  6454626
  6454650
  6454657
  6454728
  6454829
  6454917
  6454979
  6455119
  6455231
  6455315
  6455412
  6455469
  6455617
  6455638
  6455705
  6455963
  6456092
  6456787
  6456791
  6456978
  6457009
  6457224
  6457272
  6457418
  6457440
  6457442
  6459211
  6459374
  6459468
  6459953
  6460126
  6460277
  6460381
  6460462
  6460915
  6460997
  6461262
  6461416
  6461463
  6461738
  6461886
  6461910
  6462650
  6462715
  6462893
  6462964
  6462996
  6463077
  6463419
  6463545
  6464275
  6464306
  6464428
  6464438
  6467007
  6469284
  6469420
  6470292
  6470501
  6470947
  6471002
  6471063
  6471091
  6471098
  6472959
  6472986
  6472990
  6474648
  6475472
  6475476
  6476408
  6476533
  6476631
  6476857
  6476879
  6476911
  6476985
  6477181
  6477601
  6477605
  6477833
  6477869
  6477909
  6477910
  6480781
  6480806
  6480831
  6481080
  6481143
  6481204
  6481223
  6481249
  6481552
  6481693
  6481980
  6482022
  6482445
  6482785
  6483218
  6483440
  6483740
  6484007
  6484018
  6484074
  6484472
  6484520
  6484876
  6484891
  6485434
  6485458
  6485581
  6486147
  6486736
  6486759
  6486931
  6487914
  6488375
  6488386
  6488638
  6488667
  6489010
  6491015
  6491104
  6491408
  6492043
  6492073
  6492199
  6493109
  6493192
  6493224
  6493225
  6493971
  6494310
  6494359
  6494703
  6495692
  6496243
  6496519
  6497063
  6497126
  6497143
  6497151
  6497166
  6497281
  6497318
  6497423
  6497434
  6497909
  6497935
  6498085
  6498270
  6498286
  6498313
  6498410
  6498573
  6498612
  6498619
  6498636
  6498795
  6498813
  6498930
  6498935
  6498936
  6498938
  6498947
  6498951
  6498963
  6498978
  6498980
  6498983
  6498986
  6499025
  6499285
  6499300
  6499500
  6499502
  6499622
  6500085
  6500349
  6500502
  6500682
  6500974
  6501435
  6501731
  6501837
  6501848
  6501851
  6501860
  6501861
  6501973
  6502006
  6502053
  6502594
  6502606
  6503485
  6503999
  6504006
  6504038
  6504079
  6504249
  6504252
  6505533
  6506404
  6507056
  6507258
  6507849
  6507891
  6507931
  6507936
  6507975
  6508383
  6508581
  6508976
  6509713
  6510176
  6510177
  6510547
  6510602
  6511046
  6511047
  6511107
  6511151
  6512853
  6514999
  6515170
  6515516
  6515838
  6515910
  6516337
  6517543
  6518843
  6520989
  6521024
  6521708
  6521732
  6521892
  6524011
  6524199
  6524214
  6524258
  6524269
  6524300
  6524364
  6524425
  6524429
  6524533
  6524579
  6524586
  6524776
  6524777
  6524778
  6525310
  6525510
  6525513
  6526055
  6526063
  6526332
  6526354
  6526368
  6527116
  6527170
  6527195
  6528015
  6528115
  6528119
  6528133
  6528151
  6528164
  6528199
  6528263
  6528314
  6528524
  6528684
  6528739
  6528747
  6528770
  6528791
  6528942
  6528965
  6529276
  6529308
  6529378
  6529884
  6530027
  6530038
  6530052
  6530073
  6530109
  6530175
  6530226
  6530228
  6530288
  6530356
  6530462
  6530470
  6530998
  6531335
  6531569
  6532818
  6533177
  6533204
  6533404
  6533445
  6533689
  6535741
  6536067
  6536605
  6536879
  6537141
  6537968
  6539340
  6539947
  6539966
  6539972
  6540002
  6540069
  6540075
  6540684
  6540835
  6541896
  1000066041
  6542621
  6388477
  1000001006
  1000004557
  6384876
  6394772
  1000005942
  1000000869
  6392532
  1000006587
  1000006989
  1000007252
  1000008203
  1000008316
  1000008317
  1000008318
  1000001404
  1000004786
  1000004822
  1000009243
  1000002265
  1000009581
  1000009609
  1000009647
  1000009824
  1000009829
  1000009830
  1000009831
  1000007909
  1000009498
  1000005503
  1000008985
  1000006800
  1000009715
  6391665
  1000007860
  1000010961
  1000012434
  1000012678
  1000012426
  6386940
  1000012171
  1000013693
  1000002435
  1000012456
  1000013742
  1000014163
  1000014689
  1000014773
  1000014774
  1000014797
  1000014914
  1000012769
  1000012611
  1000015184
  1000012734
  1000012648
  1000015655
  1000008860
  1000016159
  1000013469
  1000016254
  1000016322
  1000016323
  1000016324
  1000016325
  1000016327
  1000016328
  1000016329
  1000016330
  1000016338
  1000016339
  1000016341
  1000016342
  1000016345
  1000016347
  1000016348
  1000016349
  1000016350
  1000016351
  1000016352
  1000016477
  1000016509
  1000016106
  1000016562
  1000014747
  1000016909
  1000016933
  1000017037
  1000013471
  1000001336
  1000011086
  1000008568
  1000016943
  1000018067
  1000018069
  1000018070
  1000018084
  1000015332
  1000018156
  1000018157
  1000018158
  1000018159
  1000018160
  1000018271
  1000018317
  1000018332
  1000018333
  1000018341
  1000018360
  1000013952
  1000014075
  1000019041
  1000019042
  1000019099
  1000019500
  1000019529
  1000019531
  1000019536
  1000019549
  1000019551
  1000019559
  1000019576
  1000019580
  1000019591
  1000019593
  1000019735
  1000016160
  1000020028
  1000020041
  1000020051
  1000020056
  1000020060
  1000020063
  1000020065
  1000020066
  1000020071
  1000020074
  1000020076
  1000020078
  1000020088
  1000020092
  1000020094
  1000020101
  1000004663
  1000020471
  1000020873
  1000020960
  1000020964
  1000020967
  1000020968
  1000020969
  1000021347
  1000021356
  1000021357
  1000021360
  1000021366
  1000021217
  1000021652
  1000021654
  1000021721
  1000021722
  1000021772
  1000021774
  1000021775
  1000021777
  1000021779
  1000021781
  1000021782
  1000021783
  1000021790
  1000021791
  1000021792
  1000021796
  1000021797
  1000021798
  1000021799
  1000021802
  1000021818
  1000021825
  1000021828
  1000021834
  1000021835
  1000021841
  1000021864
  1000021886
  1000021788
  1000021891
  1000021904
  1000003873
  1000022123
  1000022127
  1000022129
  1000022139
  1000022162
  1000022191
  1000022247
  1000016362
  1000018161
  1000022363
  1000022366
  1000022367
  1000022383
  1000022384
  1000021508
  1000021928
  1000022722
  1000022858
  1000022859
  1000018126
  1000023901
  1000024313
  1000024315
  1000024344
  1000024347
  1000024355
  1000024358
  1000024367
  1000024386
  1000024396
  1000024397
  1000019440
  1000024665
  1000024667
  1000024668
  1000024669
  1000024670
  1000024671
  1000024672
  1000024673
  1000024674
  1000024675
  1000024676
  1000024924
  1000025647
  1000016910
  1000026218
  1000026330
  1000026357
  1000026361
  1000024678
  1000024403
  1000026401
  1000026571
  1000026610
  1000026611
  1000026678
  1000023752
  1000022192
  1000027100
  1000028680
  1000028681
  1000028682
  1000028683
  1000028686
  6382786
  1000029986
  1000021849
  1000030069
  1000030202
  1000030802
  1000030824
  1000030825
  1000030826
  1000030827
  1000030828
  1000030838
  1000031729
  1000031730
  1000031731
  1000031732
  1000031734
  1000031737
  1000031738
  1000031740
  1000031741
  1000031742
  1000031743
  1000031744
  1000031745
  1000031747
  1000031749
  1000031751
  1000031752
  1000031757
  1000031758
  1000031760
  1000031766
  1000031767
  1000031768
  1000031770
  1000031772
  1000031773
  1000031775
  1000031777
  1000031778
  1000031779
  1000031811
  1000031812
  1000031814
  1000031815
  1000031816
  1000031818
  1000031819
  1000031821
  1000031822
  1000031823
  1000031824
  1000031825
  1000031826
  1000031827
  1000031828
  1000031829
  1000031832
  1000031833
  1000031834
  1000031835
  1000031837
  1000031838
  1000031839
  1000031871
  1000031872
  1000031875
  1000031878
  1000031881
  1000031888
  1000011940
  1000032092
  1000032095
  1000032191
  1000032195
  1000032199
  1000032201
  1000032205
  1000032208
  1000032287
  1000032301
  1000032303
  1000032320
  1000032321
  1000032330
  1000032331
  1000032338
  1000032339
  1000032346
  1000032347
  1000032349
  1000033052
  1000033065
  1000033066
  1000033067
  1000033069
  1000033071
  1000033072
  1000033081
  1000033082
  1000033083
  1000033084
  1000033085
  1000033087
  1000033088
  1000033090
  1000033092
  1000033093
  1000033111
  1000033117
  1000033125
  1000028688
  1000034256
  1000032348
  1000034809
  1000034816
  1000034818
  1000034842
  1000034852
  1000034853
  1000035394
  1000035409
  1000035411
  1000035421
  1000035430
  1000015443
  1000035669
  1000035670
  1000036299
  1000036822
  1000036823
  1000034258
  1000036932
  1000036934
  1000037471
  1000037472
  1000037489
  1000037497
  1000037519
  1000026362
  1000038091
  1000038092
  1000038093
  1000038094
  1000038095
  1000038096
  1000038097
  1000038098
  1000037743
  1000038191
  1000038198
  1000016485
  1000039081
  1000031037
  1000040045
  1000040047
  1000040048
  1000040052
  1000040203
  1000040204
  1000040208
  1000040210
  1000040211
  1000040212
  1000040396
  1000040769
  1000040770
  1000040771
  1000040772
  1000040773
  1000040774
  1000040775
  1000040776
  1000040777
  1000040778
  1000041034
  1000037531
  1000041764
  1000041788
  1000041820
  1000041822
  1000041824
  1000041873
  1000041874
  1000041941
  1000041945
  1000042192
  1000042194
  1000042200
  1000042207
  1000042210
  1000042211
  1000042165
  1000043281
  1000043386
  1000043387
  1000043388
  1000043397
  1000043398
  1000043406
  1000043410
  1000043413
  1000043414
  1000037304
  1000041442
  1000043667
  1000043668
  1000043826
  1000043827
  1000043828
  1000043867
  1000043868
  1000043876
  1000044072
  1000044073
  1000044077
  1000044086
  1000044089
  1000044093
  1000044094
  1000044095
  1000044096
  1000044104
  1000044107
  1000044218
  1000044225
  1000044524
  1000044525
  1000044533
  1000044540
  1000044552
  1000044555
  1000044556
  1000044558
  1000044559
  1000044579
  1000044717
  1000044719
  1000044723
  1000044724
  1000039739
  1000045198
  1000045202
  1000045209
  1000045214
  1000045224
  1000045227
  1000045412
  1000035440
  1000046131
  1000011947
  1000046284
  1000043907
  1000047168
  1000047171
  1000047172
  1000047174
  1000047175
  1000047176
  1000047191
  1000047194
  1000047330
  1000047335
  1000047336
  1000047338
  1000047346
  1000047416
  1000036563
  1000047917
  1000044583
  1000047941
  1000020270
  1000048097
  1000048304
  1000026297
  1000048315
  1000048316
  1000047196
  1000048566
  1000048773
  1000048774
  1000048803
  1000048895
  1000043415
  1000048931
  1000049254
  1000049256
  1000016255
  1000049546
  1000049320
  1000049651
  1000049121
  1000049979
  1000049635
  1000048299
  1000050033
  1000050039
  1000020175
  1000050183
  1000050209
  1000048319
  1000050311
  1000050313
  1000050314
  1000050315
  1000050317
  1000050336
  1000041807
  1000008587
  1000049791
  1000050872
  1000050235
  1000050887
  1000050911
  1000051002
  1000051034
  1000048177
  1000051244
  1000042567
  1000051366
  1000051473
  1000051571
  1000051696
  1000051711
  1000051715
  1000051728
  1000051790
  1000048163
  1000051875
  1000051065
  1000051994
  1000052082
  1000052205
  1000048894
  1000034883
  1000050874
  1000045419
  1000049637
  1000052576
  1000052577
  1000052579
  1000049690
  1000052740
  1000052581
  1000050061
  1000053162
  1000048580
  1000053333
  1000052715
  1000050902
  1000053321
  1000053486
  1000052291
  1000051691
  1000050997
  1000052263
  1000053733
  1000048984
  1000050270
  1000052811
  1000053920
  1000053487
  1000022813
  1000054058
  1000019932
  1000054224
  1000048856
  1000049192
  1000054489
  1000054516
  1000053871
  1000054649
  1000054650
  1000054651
  1000054729
  1000054887
  1000054890
  1000055187
  1000054768
  1000054315
  1000052047
  1000055508
  1000055743
  1000055859
  1000055860
  1000055861
  1000033051
  1000037525
  1000056106
  1000056109
  1000054743
  1000055502
  1000055318
  1000056704
  1000056706
  1000056731
  1000056785
  1000056170
  1000046248
  1000056612
  1000056866
  1000055273
  1000057887
  1000058166
  1000058467
  1000058765
  1000058848
  1000058887
  1000058890
  1000058958
  1000059225
  1000059226
  1000059227
  1000059608
  1000059614
  1000059690
  1000056442
  1000060421
  1000051447
  1000061823
  1000061826
  1000061847
  1000061897
  1000061037
  1000059327
  1000062391
  1000062500
  1000062479
  1000049231
  1000061440
  1000063048
  1000063114
  1000063116
  1000063352
  1000056783
  1000063690
  1000054059
  1000064177
  1000064096
  1000064403
  1000064410
  1000064155
  1000064729
  1000064923
  1000065068
  1000065094
  1000065095
  1000063425
  1000065260
  1000065321
  1000061496
  1000063645
  1000064406
  1000066065
  1000066066
  1000065667
  1000063408
  1000066215
  1000064015
  1000066389
  1000066418
  1000066462
  169383
]
20 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:
[
  56130
]
21 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:
[
  96803
]
22 0.22 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
]
23 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:
[
  96784
]
24 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:
[
  10481
]
25 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
]
26 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:
[
  204150
]
27 0.16 ms
SELECT t0.id AS id_1, t0.min_qty AS min_qty_2, t0.max_qty AS max_qty_3, t0.step_qty AS step_qty_4, t0.product_id AS product_id_5 FROM product_rule t0 WHERE t0.product_id = ?
Parameters:
[
  708
]
28 0.35 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
]
29 1.01 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
]
30 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.id = ? LIMIT 1
Parameters:
[
  1
]
31 0.27 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.displayed_order AS displayed_order_3, t0.is_in_footer AS is_in_footer_4, t0.slug AS slug_5, t0.category_parent_id AS category_parent_id_6 FROM category t0 WHERE t0.category_parent_id = ?
Parameters:
[
  1
]
32 0.21 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.displayed_order AS displayed_order_3, t0.is_in_footer AS is_in_footer_4, t0.slug AS slug_5, t0.category_parent_id AS category_parent_id_6 FROM category t0 WHERE t0.category_parent_id = ?
Parameters:
[
  16
]
33 0.20 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.displayed_order AS displayed_order_3, t0.is_in_footer AS is_in_footer_4, t0.slug AS slug_5, t0.category_parent_id AS category_parent_id_6 FROM category t0 WHERE t0.category_parent_id = ?
Parameters:
[
  17
]
34 0.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:
[
  18
]
35 0.20 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.displayed_order AS displayed_order_3, t0.is_in_footer AS is_in_footer_4, t0.slug AS slug_5, t0.category_parent_id AS category_parent_id_6 FROM category t0 WHERE t0.category_parent_id = ?
Parameters:
[
  19
]
36 0.19 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.displayed_order AS displayed_order_3, t0.is_in_footer AS is_in_footer_4, t0.slug AS slug_5, t0.category_parent_id AS category_parent_id_6 FROM category t0 WHERE t0.category_parent_id = ?
Parameters:
[
  20
]
37 0.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:
[
  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.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:
[
  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.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:
[
  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.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:
[
  27
]
44 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:
[
  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.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:
[
  32
]
49 0.29 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:
[
  169383
]

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 1251
App\Entity\Customer\Customer 340
App\Entity\User\User 269
App\Entity\Delivery\Delivery 249
App\Entity\Catalog\ProductCatalog 97
App\Entity\Catalog\CustomerCatalog 97
App\Entity\Product\Market 54
App\Entity\Pricing\Price 26
App\Entity\Internal\Commercial 25
App\Entity\Product\ProductPrice 24
App\Entity\Product\Product 21
App\Entity\Product\Category 21
App\Entity\Product\Characteristic 12
App\Entity\Product\CharacteristicLabel 11
App\Entity\Delivery\DeliveryCost 5
App\Entity\Internal\Society 4
App\Entity\Internal\Parameter 1