GET https://staging.pgdis.com/produit/10112-agrafes-couleur-esselte-24861800

Query Metrics

49 Database Queries
12 Different statements
4410.95 ms Query time
0 Invalid entities
2727 Managed entities

Queries

Group similar statements

# Time Info
1 190.02 ms
SELECT p0_.id AS id_0, p0_.reference AS reference_1, p0_.manufacturer AS manufacturer_2, p0_.short_label AS short_label_3, p0_.long_label AS long_label_4, p0_.weight AS weight_5, p0_.sold_by AS sold_by_6, p0_.ppht AS ppht_7, p0_.ppttc AS ppttc_8, p0_.paht AS paht_9, p0_.pattc AS pattc_10, p0_.legal_discount_library AS legal_discount_library_11, p0_.fidelity_bonus AS fidelity_bonus_12, p0_.brand AS brand_13, p0_.time_limit AS time_limit_14, p0_.coef AS coef_15, p0_.is_discountable AS is_discountable_16, p0_.is_btob AS is_btob_17, p0_.is_btoc AS is_btoc_18, p0_.is_customizable AS is_customizable_19, p0_.is_library AS is_library_20, p0_.is_nathan AS is_nathan_21, p0_.is_green AS is_green_22, p0_.is_orapi_grand_frais AS is_orapi_grand_frais_23, p0_.is_active AS is_active_24, p0_.slug AS slug_25, p1_.id AS id_26, p1_.price_ht AS price_ht_27, p1_.price_ttc AS price_ttc_28, p2_.id AS id_29, c3_.id AS id_30, c3_.name AS name_31, c3_.displayed_order AS displayed_order_32, c3_.is_in_footer AS is_in_footer_33, c3_.slug AS slug_34, p4_.id AS id_35, p4_.price_ht AS price_ht_36, p4_.price_ttc AS price_ttc_37, p4_.discount AS discount_38, p5_.id AS id_39, p5_.min AS min_40, p5_.max AS max_41, p5_.codelot AS codelot_42, c6_.id AS id_43, c6_.name AS name_44, c6_.name_display AS name_display_45, c6_.is_visible_btob AS is_visible_btob_46, c6_.is_referencement AS is_referencement_47, p1_.price_id AS price_id_48, p1_.product_id AS product_id_49, c3_.category_parent_id AS category_parent_id_50, p4_.product_id AS product_id_51, p5_.customer_catalog_id AS customer_catalog_id_52, p5_.product_id AS product_id_53 FROM product p0_ LEFT JOIN product_price p1_ ON p0_.id = p1_.product_id LEFT JOIN price p2_ ON p1_.price_id = p2_.id LEFT JOIN product_category p7_ ON p0_.id = p7_.product_id LEFT JOIN category c3_ ON c3_.id = p7_.category_id LEFT JOIN promotion p4_ ON p0_.id = p4_.product_id LEFT JOIN product_catalog p5_ ON p0_.id = p5_.product_id LEFT JOIN customer_catalog c6_ ON p5_.customer_catalog_id = c6_.id WHERE p0_.slug = ? AND p0_.is_active = 1
Parameters:
[
  "10112-agrafes-couleur-esselte-24861800"
]
2 0.47 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:
[
  498
]
3 0.84 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:
[
  "10112-agrafes-couleur-esselte-24861800"
]
4 0.84 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:
[
  "10112-agrafes-couleur-esselte-24861800"
]
5 0.97 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:
[
  498
  1
]
6 1.89 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
  253
  498
]
7 0.67 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.55 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.90 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.57 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.54 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.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:
[
  487
]
13 0.42 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.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:
[
  490
]
15 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:
[
  491
]
16 0.23 ms
SELECT t0.id AS id_1, t0.min_qty AS min_qty_2, t0.max_qty AS max_qty_3, t0.step_qty AS step_qty_4, t0.product_id AS product_id_5 FROM product_rule t0 WHERE t0.product_id = ?
Parameters:
[
  492
]
17 1.02 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 3566.61 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:
[
  498
  "2025-04-11 13:52:09"
]
19 635.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_ 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:
[
  6383653
  6384386
  6384443
  6384732
  6384734
  6384745
  6384863
  6384973
  6385058
  6385079
  6385104
  6385135
  6385148
  6385659
  6382350
  6386007
  6386020
  6386219
  6386490
  6386534
  6386705
  6385013
  6386715
  6387345
  6386018
  6386509
  6387232
  6385530
  6387747
  6387783
  6387838
  6388034
  6388145
  6388148
  6388689
  6388995
  6389044
  6389102
  6389116
  6389514
  6389719
  6385841
  6389956
  6390006
  6390130
  6390320
  6390368
  6390499
  6390774
  6390775
  6390782
  6391013
  6391113
  6391128
  6391367
  6391368
  6391898
  6392081
  6392709
  6392860
  6392977
  6393433
  6366128
  6365392
  6394861
  6395095
  6395135
  6395281
  6395326
  6395924
  6395963
  6395976
  6396154
  6396161
  6396173
  6396220
  6396262
  6396270
  6396281
  6396342
  6396678
  6396680
  6396683
  6396755
  6396756
  6396838
  6396846
  6397009
  6397011
  6397059
  6397072
  6397149
  6397194
  6397307
  6397353
  6397597
  6397695
  6397746
  6397957
  6398018
  6398029
  6398264
  6398743
  6398746
  6399142
  6399411
  6399418
  6399458
  6399461
  6399524
  6399591
  6399676
  6399689
  6399745
  6399770
  6399796
  6399817
  6399823
  6399828
  6399884
  6399943
  6399952
  6400116
  6400207
  6400287
  6400340
  6400425
  6400535
  6400585
  6402139
  6402140
  6402322
  6402535
  6402807
  6402831
  6402978
  6403323
  6403652
  6404008
  6404022
  6404141
  6405049
  6405112
  6405420
  6405572
  6405601
  6405983
  6406216
  6406285
  6406298
  6406583
  6406601
  6407011
  6407372
  6407482
  6407562
  6407566
  6407582
  6407971
  6405362
  6408387
  6409060
  6409392
  6409395
  6409478
  6409570
  6410140
  6410242
  6410369
  6410570
  6410657
  6410711
  6410875
  6411295
  6406394
  6411338
  6411736
  6409174
  6411795
  6411873
  6411918
  6411994
  6412078
  6412695
  6412840
  6413027
  6413075
  6413086
  6413109
  6413320
  6413366
  6413479
  6413689
  6413823
  6414159
  6414363
  6414469
  6414685
  6415579
  6415589
  6415658
  6415768
  6415797
  6415843
  6415951
  6416318
  6416374
  6416416
  6416444
  6416594
  6416713
  6417092
  6417156
  6417163
  6417376
  6417382
  6417385
  6417392
  6417410
  6417431
  6417455
  6417491
  6417534
  6417612
  6417695
  6417742
  6417795
  6417876
  6417890
  6417893
  6417927
  6418030
  6418043
  6418062
  6418064
  6418077
  6418078
  6418185
  6418283
  6418304
  6418372
  6418430
  6418449
  6418466
  6418522
  6418698
  6419089
  6419688
  6419696
  6419849
  6419880
  6420168
  6420174
  6420264
  6420331
  6420423
  6420593
  6420770
  6420990
  6421257
  6421277
  6421495
  6422100
  6422380
  6422507
  6422697
  6422900
  6423120
  6423135
  6423457
  6423728
  6424014
  6424193
  6424218
  6424253
  6424398
  6424435
  6424672
  6425855
  6425131
  6426217
  6426473
  6426487
  6426559
  6426628
  6426638
  6426698
  6426793
  6426811
  6426849
  6427083
  6427365
  6427374
  6427746
  6427991
  6427996
  6428241
  6428313
  6428532
  6428688
  6428827
  6428959
  6429343
  6430575
  6430587
  6430810
  6430873
  6431733
  6431816
  6431985
  6432073
  6433354
  6433662
  6434072
  6434219
  6434240
  6434393
  6434467
  6435007
  6435597
  6436080
  6436755
  6436820
  6437722
  6438121
  6438150
  6438652
  6438985
  6439192
  6439448
  6440150
  6440794
  6440834
  6440847
  6441314
  6441705
  6441964
  6442143
  6443493
  6443580
  6443705
  6443724
  6444277
  6444382
  6444606
  6444888
  6445003
  6445019
  6445255
  6445288
  6445648
  6445819
  6446105
  6446119
  6446442
  6446910
  6447682
  6448239
  6448273
  6448845
  6448936
  6449713
  6449786
  6449796
  6449804
  6450195
  6450217
  6450330
  6450402
  6450442
  6450528
  6450635
  6450726
  6450855
  6450896
  6451221
  6451287
  6451311
  6451496
  6451631
  6451787
  6451998
  6452102
  6452106
  6452120
  6452139
  6452142
  6452146
  6452239
  6452272
  6452274
  6452291
  6452507
  6452617
  6452723
  6452760
  6452761
  6452762
  6452803
  6452810
  6452894
  6452967
  6452998
  6453054
  6453083
  6453206
  6453215
  6453267
  6453420
  6453431
  6453450
  6453532
  6453572
  6453652
  6453657
  6453663
  6453847
  6454061
  6454095
  6454165
  6454286
  6454343
  6454586
  6454748
  6454761
  6454844
  6454976
  6455004
  6455110
  6455260
  6455264
  6455915
  6456135
  6456212
  6456422
  6456523
  6456835
  6456860
  6456897
  6456913
  6456928
  6456982
  6456986
  6457092
  6457188
  6457443
  6458297
  6458412
  6460058
  6460095
  6460112
  6460450
  6461029
  6461476
  6461598
  6461630
  6461825
  6459152
  6462209
  6462244
  6463402
  6463783
  6462505
  6464470
  6464689
  6464695
  6465193
  6465276
  6465619
  6465652
  1000051495
  6465891
  6465910
  6465933
  6465935
  6466049
  6466460
  6467214
  6468181
  6469143
  6469314
  6469441
  6471235
  6472169
  6472441
  6472664
  6473593
  6474536
  6474679
  6474770
  6474785
  6475766
  6475769
  6475783
  6475800
  1000055708
  6476943
  6477412
  6477582
  6480609
  6480786
  6480884
  6480911
  6482487
  6482720
  6482783
  1000056413
  6483805
  6483961
  6484122
  6484841
  6485544
  6485925
  6486727
  6486788
  6488838
  6490898
  6491253
  6491347
  6492063
  6492177
  6492270
  6493135
  6494292
  6494787
  6494872
  6494902
  6495424
  6496140
  6496402
  6497044
  6497049
  6497308
  6497379
  6497386
  6497570
  6497871
  6498003
  6498031
  6498374
  6498516
  6498527
  6498555
  6498596
  6499041
  6499056
  6499080
  6499082
  6499125
  6499146
  6499207
  6499308
  6499595
  6499715
  6499806
  6499896
  6500137
  6500182
  6500222
  6500224
  6500289
  6500370
  6500422
  6500447
  6500881
  6500991
  6501247
  6501307
  6501633
  6501728
  6501827
  6501888
  6501978
  6501990
  6502006
  6502146
  6502722
  6502838
  6503145
  6503295
  6503314
  6503509
  6503628
  6503633
  6503642
  6503660
  6503661
  6503871
  6503908
  6503917
  6503957
  6505454
  6507174
  6507203
  6507294
  6507993
  6508631
  6510176
  6510348
  6510748
  6510987
  6512565
  6512818
  6513235
  6513346
  6514627
  6515074
  6515473
  6515784
  6515855
  6515994
  6516043
  6517120
  6517575
  6521738
  6522098
  6522644
  6522750
  6523659
  6523914
  6524366
  6525171
  6525276
  6525872
  6526120
  6526127
  6526186
  6526743
  6526745
  6526746
  6526995
  6527174
  6527260
  6527278
  6527649
  6527719
  6528119
  6528303
  6528900
  6529113
  6529278
  6529944
  6530418
  6530726
  6530939
  6531316
  6532753
  6532910
  6533262
  6533650
  6533782
  6534602
  6535478
  6535581
  6535892
  6535979
  6536702
  6536716
  6536765
  6537395
  6537458
  6537609
  6538021
  6538335
  6538553
  6538575
  6538950
  6539297
  6539527
  6539529
  6539618
  6539820
  6539905
  6539947
  6539972
  6540460
  6541384
  6541467
  6541762
  6542065
  6542179
  1000000741
  1000000723
  1000001162
  1000001269
  1000001426
  1000001558
  6388954
  1000002326
  1000002589
  1000002593
  1000003186
  1000003919
  1000003541
  1000004168
  1000004226
  1000004233
  1000004214
  1000004328
  1000004599
  1000004617
  1000004645
  1000004714
  1000004769
  1000005105
  1000005108
  1000005148
  1000005182
  1000005201
  1000005214
  1000004329
  6340647
  6382649
  1000006376
  1000007260
  1000007361
  1000007606
  1000005008
  1000004395
  1000007839
  1000007961
  1000005128
  1000008045
  1000008186
  1000008191
  1000008205
  1000008195
  1000008986
  1000009088
  1000004826
  1000009324
  1000009451
  1000009452
  1000009481
  1000009533
  1000010005
  1000009516
  1000008314
  1000007460
  1000010644
  1000010657
  1000010673
  1000010691
  1000010736
  1000010400
  1000010524
  1000011874
  1000012129
  1000012213
  1000012334
  1000012486
  1000012527
  1000012588
  1000012789
  1000013012
  1000013024
  1000013118
  1000013232
  1000013135
  1000013643
  1000013744
  1000012385
  1000010199
  1000010355
  1000014073
  1000014135
  1000014136
  1000014137
  1000014168
  1000014418
  1000001025
  1000015049
  1000015082
  1000010243
  1000015349
  1000014419
  1000005239
  1000015865
  1000015743
  1000014224
  1000015984
  1000016166
  1000016168
  1000016169
  1000012570
  1000014594
  1000009659
  1000017683
  1000017684
  1000017698
  1000017944
  1000017948
  1000017950
  1000018268
  1000018370
  1000018598
  1000018686
  1000018708
  1000018840
  1000004387
  1000019413
  1000019555
  1000019556
  1000019558
  1000020000
  1000020027
  1000020032
  1000020033
  1000020034
  1000020035
  1000020038
  1000020039
  1000020044
  1000020045
  1000020062
  1000008970
  1000015117
  1000021244
  1000021247
  1000021250
  1000021745
  1000021818
  1000021825
  1000021828
  1000021864
  1000021886
  1000021891
  1000021904
  1000022053
  1000022057
  1000014766
  1000022517
  1000022587
  1000022588
  1000022589
  1000022593
  1000021928
  1000017945
  1000017951
  1000027361
  1000028749
  1000028954
  1000028956
  1000029195
  1000029353
  1000028090
  1000029914
  1000029206
  1000031094
  1000031095
  1000031096
  1000031273
  1000015927
  1000032078
  1000032183
  1000032222
  1000032240
  1000032243
  1000032304
  1000032351
  1000033827
  1000033899
  1000034176
  1000034250
  1000034642
  1000034754
  1000035370
  1000035371
  1000002590
  1000015039
  1000035782
  1000036325
  1000036667
  1000036671
  1000037500
  1000037810
  1000037823
  1000037824
  1000037840
  1000037864
  1000037915
  1000037921
  1000037932
  1000038006
  1000038008
  1000038858
  1000038868
  1000038871
  1000040264
  1000021503
  1000040271
  1000040274
  1000040276
  1000040301
  1000040302
  1000040303
  1000040305
  1000040737
  1000022526
  1000041288
  1000041311
  1000041319
  1000041348
  1000041401
  1000041403
  1000041408
  1000042024
  1000042382
  1000042647
  1000029888
  1000042651
  1000042657
  1000042658
  1000042659
  1000042660
  1000042667
  1000042668
  1000042669
  1000042671
  1000042672
  1000042694
  1000042696
  1000042701
  1000042702
  1000042703
  1000042704
  1000043124
  1000043125
  1000043470
  1000043471
  1000043472
  1000043473
  1000043491
  1000043544
  1000043545
  1000043548
  1000043549
  1000005141
  1000044120
  1000044122
  1000044123
  1000044487
  1000045963
  1000045981
  1000046068
  1000046132
  1000047876
  1000048560
  1000037931
  1000049352
  1000048341
  1000020532
  1000050425
  6337781
  1000040542
  1000051054
  1000052069
  1000052088
  1000052146
  1000052149
  1000030625
  1000052371
  1000053006
  1000053130
  1000053271
  1000053281
  1000053847
  1000048210
  1000049709
  1000054220
  1000053863
  1000054485
  1000054539
  1000054698
  1000056010
  1000055699
  1000056170
  1000056936
  1000056997
  1000057045
  1000057101
  1000057686
  1000057704
  1000057782
  1000057835
  1000056360
  1000058340
  1000058616
  1000058855
  1000058971
  1000059009
  1000059733
  1000059735
  1000059812
  1000059857
  1000058321
  1000054541
  1000060487
  1000060849
  1000060908
  1000060957
  1000060983
  1000060984
  1000061324
  1000061671
  1000061804
  1000062028
  1000062054
  1000062518
  1000063208
  1000063947
  1000064070
  1000064125
  1000059956
  1000064459
  1000064814
  1000064885
  1000064886
  1000064978
  1000064990
  1000064999
  1000065087
  1000065375
  1000065682
  1000065681
  1000061250
  1000066020
  1000066021
  1000066086
  1000066180
  1000065465
  498
]
20 0.47 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
]
21 0.34 ms
SELECT t0.id AS id_1, t0.min_qty AS min_qty_2, t0.max_qty AS max_qty_3, t0.step_qty AS step_qty_4, t0.product_id AS product_id_5 FROM product_rule t0 WHERE t0.product_id = ?
Parameters:
[
  65561
]
22 0.23 ms
SELECT t0.id AS id_1, t0.min_qty AS min_qty_2, t0.max_qty AS max_qty_3, t0.step_qty AS step_qty_4, t0.product_id AS product_id_5 FROM product_rule t0 WHERE t0.product_id = ?
Parameters:
[
  10481
]
23 0.18 ms
SELECT t0.id AS id_1, t0.min_qty AS min_qty_2, t0.max_qty AS max_qty_3, t0.step_qty AS step_qty_4, t0.product_id AS product_id_5 FROM product_rule t0 WHERE t0.product_id = ?
Parameters:
[
  9651
]
24 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:
[
  26728
]
25 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:
[
  11358
]
26 0.46 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:
[
  80486
]
27 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:
[
  65676
]
28 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
]
29 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:
[
  21052
]
30 0.59 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.39 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.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:
[
  16
]
33 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:
[
  17
]
34 0.23 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.displayed_order AS displayed_order_3, t0.is_in_footer AS is_in_footer_4, t0.slug AS slug_5, t0.category_parent_id AS category_parent_id_6 FROM category t0 WHERE t0.category_parent_id = ?
Parameters:
[
  18
]
35 0.32 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.36 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.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:
[
  22
]
39 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:
[
  23
]
40 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:
[
  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.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.16 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.displayed_order AS displayed_order_3, t0.is_in_footer AS is_in_footer_4, t0.slug AS slug_5, t0.category_parent_id AS category_parent_id_6 FROM category t0 WHERE t0.category_parent_id = ?
Parameters:
[
  27
]
44 0.25 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.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:
[
  29
]
46 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:
[
  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.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:
[
  32
]
49 0.45 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:
[
  498
]

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 1031
App\Entity\Customer\Customer 320
App\Entity\Delivery\Delivery 298
App\Entity\Catalog\ProductCatalog 231
App\Entity\Catalog\CustomerCatalog 231
App\Entity\User\User 222
App\Entity\Product\Market 156
App\Entity\Internal\Commercial 69
App\Entity\Pricing\Price 48
App\Entity\Product\ProductPrice 47
App\Entity\Product\Product 21
App\Entity\Product\Category 21
App\Entity\Product\Characteristic 10
App\Entity\Product\CharacteristicLabel 10
App\Entity\Delivery\DeliveryCost 6
App\Entity\Internal\Society 4
App\Entity\Internal\Parameter 1
App\Infrastructure\Doctrine\Entity\ProductRule 1