GET https://staging.pgdis.com/produit/10181-attaches-et-piques-notes-couleur-pavo-8042562

Query Metrics

49 Database Queries
12 Different statements
2290.82 ms Query time
0 Invalid entities
2726 Managed entities

Queries

Group similar statements

# Time Info
1 157.00 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:
[
  "10181-attaches-et-piques-notes-couleur-pavo-8042562"
]
2 0.40 ms
SELECT t0.id AS id_1, t0.min_qty AS min_qty_2, t0.max_qty AS max_qty_3, t0.step_qty AS step_qty_4, t0.product_id AS product_id_5 FROM product_rule t0 WHERE t0.product_id = ?
Parameters:
[
  551
]
3 0.43 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:
[
  "10181-attaches-et-piques-notes-couleur-pavo-8042562"
]
4 0.36 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:
[
  "10181-attaches-et-piques-notes-couleur-pavo-8042562"
]
5 1.14 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:
[
  551
  1
]
6 0.68 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:
[
  54
  253
  254
  255
  256
  257
  258
  255
  551
]
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:
[
  481
]
8 0.18 ms
SELECT t0.id AS id_1, t0.min_qty AS min_qty_2, t0.max_qty AS max_qty_3, t0.step_qty AS step_qty_4, t0.product_id AS product_id_5 FROM product_rule t0 WHERE t0.product_id = ?
Parameters:
[
  482
]
9 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:
[
  484
]
10 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:
[
  485
]
11 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:
[
  486
]
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:
[
  487
]
13 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:
[
  488
]
14 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:
[
  490
]
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:
[
  491
]
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:
[
  492
]
17 0.23 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 1283.54 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:
[
  551
  "2025-04-11 17:04:39"
]
19 839.62 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:
[
  6381482
  6384749
  6385027
  6385061
  6385411
  6385461
  6385524
  6385789
  6380834
  6386059
  6386133
  6386180
  6386186
  6386515
  6383405
  6386872
  6386893
  6387098
  6387126
  6387151
  6386509
  6388034
  6388187
  6388211
  6388313
  6382523
  6388525
  6388985
  6388915
  6389119
  6389181
  6378581
  6388328
  6389456
  6389707
  6390233
  6390998
  6385519
  6390101
  6390988
  6391235
  6391363
  6391466
  6391502
  6391514
  6391933
  6392248
  6392341
  6390654
  6389510
  6392314
  6393144
  6393200
  6393283
  6394183
  6394311
  6395030
  6395265
  6395408
  6395465
  6395466
  6395715
  6395834
  6395871
  6396214
  6396261
  6396356
  6396372
  6396403
  6396550
  6396649
  6396704
  6396827
  6396829
  6397059
  6397094
  6397098
  6397106
  6398144
  6398223
  6398325
  6398326
  6398673
  6399197
  6399893
  6400013
  6400153
  6400225
  6401686
  6402438
  6402880
  6402871
  6402954
  6403059
  6403134
  6403135
  6403623
  6403661
  6404556
  6404608
  6405417
  6405494
  6405716
  6405990
  6406090
  6406604
  6406902
  6406907
  6407117
  6407592
  6408008
  6408249
  6408645
  6409452
  6410103
  6410271
  6411512
  6411583
  6412054
  6412171
  6412172
  6412194
  6412261
  6412359
  6412784
  6412786
  6413098
  6413117
  6413468
  6413925
  6414284
  6415087
  6415120
  6415362
  6415618
  6415649
  6415726
  6416152
  6416204
  6416207
  6416238
  6416377
  6416599
  6416831
  6416987
  6417047
  6417065
  6417089
  6417539
  6418040
  6418096
  6418272
  6418536
  6418805
  6418843
  6418995
  6419157
  6419236
  6419273
  6419285
  6419393
  6419513
  6419809
  6419916
  6420071
  6420087
  6420223
  6420265
  6420277
  6420428
  6420541
  6420635
  6420990
  6421574
  6421884
  6421943
  6422161
  6422442
  6422870
  6422876
  6423939
  6424037
  6424121
  6424204
  6424014
  6424921
  6425157
  6425383
  6425443
  6425444
  6425906
  6425931
  6426197
  6426237
  6426287
  6426302
  6426628
  6426762
  6426897
  6427029
  6427238
  6427741
  6427815
  6428241
  6429471
  6429602
  6429633
  6429639
  6429802
  6430473
  6430593
  6430906
  6431021
  6431286
  6431497
  6431732
  6432263
  6433750
  6434370
  6434473
  6434623
  6434792
  6434796
  6434805
  6434906
  6434941
  6434980
  6435233
  6435721
  6435930
  6435936
  6436501
  6438100
  6438150
  6438762
  6438825
  6438966
  6439148
  6439452
  6440166
  1000035725
  6441100
  6441190
  6441311
  6441969
  6442186
  6442211
  6442637
  6442842
  6443135
  6443969
  6444004
  6444290
  6444592
  6444753
  6445630
  6445904
  6446114
  6446260
  6446388
  6446954
  6447401
  6448242
  6449010
  6449509
  6449554
  6449727
  6449807
  6449926
  6449951
  6449954
  6450424
  6450475
  6450478
  6451062
  6451163
  6451200
  6451210
  6451244
  6451270
  6451412
  6451439
  6451592
  6451616
  6451631
  6451679
  6452037
  6452045
  6452118
  6452247
  6452258
  6452300
  6452400
  6452403
  6452411
  6452455
  6452496
  6452597
  6452604
  6452830
  6453146
  6453342
  6453540
  6453664
  6454180
  6454188
  6454366
  6454844
  6454991
  6455061
  6455301
  6455320
  6455324
  6455417
  6455663
  6455686
  6455687
  6455842
  6455885
  6455915
  6456204
  6456232
  6456371
  6456379
  6456431
  6456493
  6456780
  6456808
  6456928
  6456970
  6457096
  6457185
  6457239
  6457240
  6457268
  6457417
  6457441
  6457452
  6457523
  6457541
  6457646
  6457939
  6458292
  6458535
  6460141
  6460188
  6460281
  6460290
  6461088
  6461594
  6461872
  6462653
  6463389
  6463832
  6464021
  6465294
  6465871
  6465933
  6465935
  6466447
  6466803
  6469850
  6469881
  6470024
  6470150
  6470268
  6470285
  6470508
  6470790
  6471304
  6471794
  6472013
  6472235
  6472612
  6472744
  6473053
  6474488
  6475548
  6475670
  6475728
  6475787
  6476062
  6476366
  6476922
  6478129
  6478172
  6480672
  6480931
  6481010
  6481387
  6481748
  6481927
  6482884
  6482894
  6483413
  6483456
  6483540
  6483704
  6483920
  6484008
  6484318
  6484937
  6485237
  6485260
  6485374
  6485689
  6486056
  6486455
  6489039
  6489725
  6490686
  6490762
  6491021
  6494335
  6494761
  6496213
  6496413
  6496736
  6497036
  6497089
  6497169
  6497334
  6497346
  6497351
  6497433
  6497607
  6497655
  6497950
  6498059
  6498185
  6498214
  6498273
  6498307
  6498434
  6498523
  6498625
  6498881
  6499327
  6499394
  6499464
  6499541
  6499548
  6500210
  6500499
  6500623
  6500645
  6500677
  6501450
  6501459
  6501813
  6501939
  6501990
  6502326
  6502550
  6502587
  6502636
  6502836
  6502875
  6503096
  6503176
  6503258
  6503346
  6503378
  6503485
  6503592
  6503595
  6503755
  6503786
  6503823
  6503839
  6503971
  6504246
  6504573
  6505997
  6506019
  6506121
  6506500
  6506526
  6507163
  6507174
  6507183
  6507706
  6507831
  6508441
  6508631
  6508656
  6509018
  6509176
  6509177
  6509315
  6509379
  6510326
  6510426
  6510524
  6512155
  6512486
  6512529
  6512836
  6513435
  6515551
  6515723
  6516050
  6516340
  6517344
  6517371
  6517556
  6518689
  6519367
  6519471
  6519517
  6519520
  6520072
  6520209
  6520277
  6520866
  6520971
  6521911
  6522584
  6523905
  6523923
  6524161
  6524243
  6524290
  6524391
  6524412
  6524414
  6524427
  6524447
  6524520
  6524717
  6524936
  6524951
  6525112
  6525144
  6525153
  6525247
  6525696
  6525780
  6525950
  6526016
  6526064
  6526182
  6526305
  6526337
  6526470
  6526561
  6526703
  6527105
  6527611
  6527780
  6527907
  6528109
  6528303
  6528768
  6529200
  6529407
  6529841
  6529968
  6529995
  6530288
  6530342
  6530464
  6530525
  6530558
  6530945
  6530990
  6530998
  6531252
  6531316
  6531378
  6532687
  6532736
  6532894
  6533205
  6533208
  6533404
  6534460
  6534509
  6534680
  6535944
  6536037
  6536519
  6536871
  6537403
  6537422
  6538061
  6538940
  6539456
  6540400
  6540812
  6541156
  6541388
  6542082
  6542531
  6542587
  1000000755
  6394821
  6390911
  1000001377
  6389415
  1000001638
  1000001720
  6385464
  1000001759
  6392324
  1000002156
  1000001981
  1000002496
  1000002582
  1000002583
  1000002712
  1000000976
  6391773
  1000003689
  1000003726
  1000003942
  1000004191
  1000004215
  1000004396
  1000004410
  1000004411
  1000004414
  1000004653
  1000004892
  1000005179
  1000006105
  1000006449
  1000006655
  1000006703
  1000007011
  1000007157
  1000007158
  6383356
  1000008731
  1000003853
  6379629
  1000006281
  1000009380
  1000008812
  6385846
  1000009984
  1000010045
  1000002735
  1000004422
  1000010691
  1000010605
  1000002066
  1000009732
  6386880
  1000011044
  1000012158
  1000012645
  1000012691
  1000012695
  1000012708
  1000012709
  1000012961
  1000010835
  1000009875
  1000010939
  1000005320
  1000012662
  1000012800
  1000010689
  1000012605
  1000014195
  1000006957
  1000013741
  1000014629
  1000014975
  1000014976
  1000013732
  1000013459
  6337933
  1000015212
  1000011070
  1000002199
  1000015323
  1000015957
  1000015960
  1000015964
  1000015965
  1000015966
  1000015970
  1000015971
  1000016374
  1000016375
  1000016481
  1000014594
  1000017328
  1000007537
  1000017643
  1000018059
  1000018060
  1000018061
  1000018101
  1000018108
  1000014189
  1000018700
  1000018706
  1000014395
  1000019353
  1000019540
  1000020344
  1000021053
  1000021128
  1000016734
  1000021256
  1000019574
  1000021606
  1000021608
  1000021611
  1000021612
  1000021626
  1000021627
  1000021632
  1000019604
  1000022480
  1000010324
  1000022584
  1000022734
  1000013474
  6378270
  1000023682
  1000023683
  1000023687
  1000024534
  1000026445
  1000026447
  1000026448
  1000026449
  1000026450
  1000026468
  1000026470
  1000015517
  1000026451
  1000022481
  1000019834
  1000029595
  1000029206
  1000031405
  1000031396
  1000019337
  1000032237
  1000032239
  1000032248
  1000032249
  1000032250
  1000032646
  1000032716
  1000032729
  1000032732
  1000032837
  1000032838
  1000032840
  1000032841
  1000032842
  1000032922
  1000032943
  1000021860
  1000024133
  1000034135
  1000031441
  1000034489
  1000034494
  1000032297
  1000028622
  1000025365
  1000036982
  1000036988
  1000036991
  1000036994
  1000036995
  1000036996
  1000036997
  1000036998
  1000036999
  1000037000
  1000037001
  1000037002
  1000037003
  1000037004
  1000037005
  1000037011
  1000037012
  1000037013
  1000037014
  1000037015
  1000037019
  1000037021
  1000037022
  1000037023
  1000037024
  1000025752
  1000038602
  1000036216
  1000039659
  1000039660
  1000015922
  1000041230
  1000041793
  1000041929
  1000041950
  1000041029
  1000042241
  1000029441
  1000042726
  1000042728
  1000042775
  1000042776
  1000042866
  1000042904
  1000043078
  1000044395
  1000044537
  1000044598
  1000044769
  1000045117
  1000010963
  1000046014
  1000046028
  1000046041
  1000046054
  1000046122
  1000046351
  1000046807
  1000046837
  1000047660
  1000047676
  1000047688
  1000047730
  1000047736
  1000047737
  1000022585
  1000047894
  1000048001
  1000048072
  1000046091
  1000048368
  1000018044
  1000048624
  1000048490
  1000049060
  1000047888
  1000049496
  1000002208
  1000049936
  1000050246
  1000050253
  1000050255
  1000050256
  1000049839
  1000050522
  1000050545
  1000050552
  1000046407
  1000050799
  1000050990
  1000050460
  1000051293
  1000051294
  1000051458
  1000048790
  1000038011
  1000051713
  1000052310
  1000052325
  1000052326
  1000052327
  1000052542
  1000045974
  1000052833
  1000043594
  1000052979
  1000053013
  1000053016
  1000053078
  1000052973
  1000052913
  1000053472
  1000053610
  1000053616
  1000051700
  1000042414
  1000053358
  1000053807
  1000052990
  1000053818
  1000053272
  1000053832
  1000053837
  1000053850
  1000053932
  1000052696
  1000054047
  1000054106
  1000051325
  1000053800
  1000054285
  1000054311
  1000054535
  1000053425
  1000053834
  1000054983
  1000054984
  1000029115
  1000048273
  1000055225
  1000055228
  1000055244
  1000055245
  1000055246
  1000054052
  1000054362
  1000055528
  1000055462
  1000055650
  1000055168
  1000055926
  1000055959
  1000055987
  1000056133
  1000056132
  1000056686
  1000056063
  1000056572
  1000056977
  1000056978
  1000057497
  1000057797
  1000058390
  1000056689
  1000059113
  1000059292
  1000058436
  1000059454
  1000059613
  1000059579
  1000059904
  1000059906
  1000051504
  1000060517
  1000059456
  1000061308
  1000061216
  1000061430
  1000061552
  1000062215
  1000062635
  1000062461
  1000062742
  1000062744
  1000063003
  1000063027
  1000063040
  1000063396
  1000063397
  1000063402
  1000062604
  1000063165
  1000063682
  1000053876
  1000063817
  1000064343
  1000064346
  1000064347
  1000064426
  1000064881
  1000064529
  1000065636
  1000065650
  1000065797
  1000065926
  1000066126
  1000066160
  1000066161
  1000066284
  1000066205
  1000065701
  551
]
20 0.45 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.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:
[
  9651
]
22 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:
[
  56130
]
23 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:
[
  86862
]
24 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:
[
  5496
]
25 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:
[
  96803
]
26 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:
[
  145260
]
27 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:
[
  2886
]
28 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:
[
  10481
]
29 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:
[
  11358
]
30 0.28 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.20 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.displayed_order AS displayed_order_3, t0.is_in_footer AS is_in_footer_4, t0.slug AS slug_5, t0.category_parent_id AS category_parent_id_6 FROM category t0 WHERE t0.category_parent_id = ?
Parameters:
[
  16
]
33 0.28 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.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:
[
  18
]
35 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:
[
  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.16 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.displayed_order AS displayed_order_3, t0.is_in_footer AS is_in_footer_4, t0.slug AS slug_5, t0.category_parent_id AS category_parent_id_6 FROM category t0 WHERE t0.category_parent_id = ?
Parameters:
[
  22
]
39 0.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.15 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.displayed_order AS displayed_order_3, t0.is_in_footer AS is_in_footer_4, t0.slug AS slug_5, t0.category_parent_id AS category_parent_id_6 FROM category t0 WHERE t0.category_parent_id = ?
Parameters:
[
  25
]
42 0.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:
[
  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.15 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.displayed_order AS displayed_order_3, t0.is_in_footer AS is_in_footer_4, t0.slug AS slug_5, t0.category_parent_id AS category_parent_id_6 FROM category t0 WHERE t0.category_parent_id = ?
Parameters:
[
  28
]
45 0.15 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.displayed_order AS displayed_order_3, t0.is_in_footer AS is_in_footer_4, t0.slug AS slug_5, t0.category_parent_id AS category_parent_id_6 FROM category t0 WHERE t0.category_parent_id = ?
Parameters:
[
  29
]
46 0.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:
[
  30
]
47 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:
[
  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.27 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:
[
  551
]

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 979
App\Entity\Customer\Customer 368
App\Entity\Delivery\Delivery 283
App\Entity\User\User 256
App\Entity\Catalog\ProductCatalog 252
App\Entity\Catalog\CustomerCatalog 252
App\Entity\Product\Market 109
App\Entity\Internal\Commercial 55
App\Entity\Pricing\Price 49
App\Entity\Product\ProductPrice 48
App\Entity\Product\Product 21
App\Entity\Product\Category 21
App\Entity\Product\Characteristic 11
App\Entity\Product\CharacteristicLabel 11
App\Entity\Delivery\DeliveryCost 5
App\Entity\Internal\Society 4
App\Entity\Internal\Parameter 1
App\Infrastructure\Doctrine\Entity\ProductRule 1