GET https://staging.pgdis.com/produit/82999-objets-a-decorer-couleur-n-c-l515000-po023

Query Metrics

49 Database Queries
12 Different statements
1808.89 ms Query time
0 Invalid entities
2112 Managed entities

Queries

Group similar statements

# Time Info
1 41.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:
[
  "82999-objets-a-decorer-couleur-n-c-l515000-po023"
]
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:
[
  131263
]
3 0.40 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:
[
  "82999-objets-a-decorer-couleur-n-c-l515000-po023"
]
4 0.32 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:
[
  "82999-objets-a-decorer-couleur-n-c-l515000-po023"
]
5 0.34 ms
SELECT c0_.id AS id_0, c0_.value AS value_1, c1_.id AS id_2, c1_.list_order AS list_order_3, c1_.is_display_site AS is_display_site_4, c1_.is_search_site AS is_search_site_5, c1_.label AS label_6, c0_.product_id AS product_id_7, c0_.characteristic_label_id AS characteristic_label_id_8 FROM characteristic c0_ INNER JOIN characteristic_label c1_ ON c0_.characteristic_label_id = c1_.id WHERE c0_.product_id = ? AND c1_.is_display_site = ?
Parameters:
[
  131263
  1
]
6 0.74 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:
[
  84
  396
  397
  398
  399
  400
  401
  402
  398
  131263
]
7 0.20 ms
SELECT t0.id AS id_1, t0.min_qty AS min_qty_2, t0.max_qty AS max_qty_3, t0.step_qty AS step_qty_4, t0.product_id AS product_id_5 FROM product_rule t0 WHERE t0.product_id = ?
Parameters:
[
  632
]
8 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:
[
  633
]
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:
[
  634
]
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:
[
  635
]
11 0.18 ms
SELECT t0.id AS id_1, t0.min_qty AS min_qty_2, t0.max_qty AS max_qty_3, t0.step_qty AS step_qty_4, t0.product_id AS product_id_5 FROM product_rule t0 WHERE t0.product_id = ?
Parameters:
[
  636
]
12 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:
[
  637
]
13 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:
[
  646
]
14 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:
[
  684
]
15 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:
[
  689
]
16 0.28 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:
[
  690
]
17 0.35 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 908.51 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:
[
  131263
  "2025-04-13 07:27:21"
]
19 848.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 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:
[
  6384176
  6385654
  6386748
  6387254
  6387401
  6382839
  6388963
  6390309
  6390585
  6392549
  6392920
  6390520
  6395682
  6396369
  6397424
  6398468
  6398892
  6400469
  6401054
  6401509
  1000001330
  6405137
  6405657
  6405686
  6405694
  6405885
  6407645
  6407718
  6409369
  6409565
  6410108
  6410864
  6410895
  6411188
  6411435
  6411710
  6411720
  6411740
  6411870
  6412239
  6412385
  6413512
  6413688
  6413727
  6413830
  6414292
  6414304
  6414598
  6414940
  6415024
  6415036
  6415077
  6415891
  6416268
  6416778
  6416856
  6416923
  6416945
  6417238
  6417532
  6417536
  6418041
  6418849
  6418991
  6419208
  6419252
  6419333
  6419394
  6419438
  6419510
  6419729
  6420398
  6420725
  6420835
  6421664
  6422661
  6423815
  6424765
  6424924
  6424773
  6426169
  6426173
  6426197
  6426492
  6427334
  6427680
  6428034
  6428619
  6428781
  6428900
  6428904
  6428986
  6429091
  6429255
  6429841
  6429879
  6429979
  6430030
  6430035
  6430624
  6430908
  6431244
  6431294
  6431497
  6431537
  6431541
  6432088
  6432244
  6432292
  6432322
  6433455
  6433494
  6433555
  6433594
  6433815
  6433971
  6434652
  6434763
  6434805
  6434849
  6434852
  6435181
  6435996
  6436283
  6437041
  6437148
  6437986
  6438259
  6438577
  6438939
  6439137
  6439451
  6439659
  6439669
  6440005
  6440716
  6441605
  6443264
  6443367
  6443439
  6444025
  6444102
  6444278
  6444582
  6444750
  6445074
  6445264
  6445521
  6445741
  6446118
  6446283
  6446667
  6446812
  6446855
  6447013
  6447025
  6447413
  6447473
  6447662
  6447770
  6447788
  6448291
  6448568
  6449915
  6449926
  6449948
  6450182
  6450191
  6450598
  6450873
  6450890
  6451077
  6451101
  6451161
  6451174
  6451186
  6451271
  6451319
  6451322
  6451351
  6451374
  6451377
  6451436
  6451558
  6451617
  6451648
  6451650
  6452004
  6452007
  6452022
  6452037
  6452039
  6452048
  6452053
  6452356
  6452370
  6452378
  6452550
  6452614
  6453317
  6453458
  6453499
  6454715
  6454769
  6454841
  6454970
  6454976
  6454998
  6455005
  6455203
  6455230
  6455232
  6455359
  6455417
  6455465
  6455470
  6455487
  6455528
  6455636
  6455802
  6456559
  6456586
  6456978
  6457003
  6457205
  6457272
  6457646
  6457660
  6457777
  6457797
  6459110
  6459228
  6459234
  6460043
  6460155
  6460277
  6460294
  6460370
  6461051
  6461305
  6461340
  6462586
  6462931
  6463077
  6463149
  6463242
  6464026
  6464307
  6465297
  6468197
  6470124
  1000048798
  6470947
  6471002
  6471038
  6471397
  6472595
  6472733
  6472887
  6473050
  6474447
  6474694
  6475330
  6475339
  6475466
  6475472
  6476478
  6476525
  6476533
  6476591
  6476752
  6476857
  6476879
  6476884
  6477607
  6477800
  6477833
  6477838
  6477851
  6477858
  6477910
  6480481
  6480509
  6480598
  6480816
  6481094
  6481409
  6481415
  6481779
  6481821
  6481980
  6482022
  6482780
  6482785
  6482832
  6483208
  6483457
  6483492
  6483757
  6483859
  6483947
  6484007
  6484043
  6484074
  6485323
  6485360
  6485372
  6485418
  6485498
  6485745
  6486431
  6486633
  6488425
  6488746
  6489189
  6489232
  6490735
  6490832
  6491095
  6492256
  6493127
  6493192
  6493193
  6493225
  6493408
  6493931
  6494186
  6494318
  6494320
  6494327
  6494952
  6494985
  6495270
  6495651
  6495838
  6495975
  6496225
  6496299
  6496667
  6496942
  6496977
  6497155
  6497224
  6497361
  6497556
  6497587
  6497632
  6497951
  6498092
  6498094
  6498152
  6498158
  6498162
  6498252
  6498254
  6498255
  6498302
  6498513
  6498795
  6498856
  6498867
  6498912
  6498924
  6498930
  6498941
  6498945
  6498947
  6498951
  6498955
  6498968
  6498971
  6498978
  6498980
  6498981
  6498983
  6498986
  6499263
  6499283
  6499300
  6499450
  6501404
  6501408
  6501590
  6501616
  6501730
  6502029
  6502131
  6502187
  6502354
  6502498
  6502591
  6502666
  6502773
  6502774
  6502817
  6504257
  6505500
  6505634
  6507103
  6507400
  6507494
  6507931
  6508545
  6508581
  6508606
  6509315
  6509322
  6510668
  6510891
  6511011
  6511251
  6511646
  6512329
  6512633
  6512911
  6515456
  6515783
  6515812
  6515910
  6516050
  6516204
  6516337
  6516555
  6516654
  6517488
  6518651
  6519364
  6520153
  6520211
  6520251
  6520347
  6520597
  6520682
  6520884
  6521340
  6521411
  6521524
  6521758
  6521820
  6522224
  6523030
  6523972
  6524007
  6524232
  6524252
  6524277
  6524326
  6524364
  6524418
  6524420
  6524439
  6524444
  6524451
  6524465
  6524593
  6524829
  6524952
  6525177
  6525228
  6525233
  6525242
  6525250
  6525377
  6525409
  6525411
  6525443
  6525445
  6525447
  6525519
  6525537
  6525540
  6525630
  6525780
  6525850
  6525856
  6526000
  6526027
  6526055
  6526063
  6526064
  6526130
  6526371
  6526377
  6526378
  6527152
  6527637
  6528024
  6528025
  6528331
  6528373
  6528413
  6528415
  6528417
  6528616
  6528640
  6528733
  6528754
  6528764
  6528767
  6528791
  6528809
  6529038
  6529329
  6529745
  6529860
  6530235
  6530263
  6530787
  6530868
  6531569
  6532730
  6532815
  6532850
  6533194
  6533199
  6533211
  6533586
  6534535
  6534945
  6535171
  6535686
  6535979
  6536080
  6536384
  6536824
  6536867
  6536871
  6537363
  6537922
  6537929
  6538099
  6538728
  6538730
  6538731
  6538762
  6538776
  6538941
  6538943
  6539276
  6539761
  6540460
  6540928
  6541152
  6541441
  6542173
  6542294
  6365727
  1000001768
  1000002651
  1000002764
  1000000904
  1000001494
  1000003077
  1000003852
  1000004557
  1000005110
  6388353
  1000005534
  1000007252
  1000005299
  6389016
  1000007903
  1000007904
  1000008073
  1000002916
  1000007403
  1000008393
  1000008277
  6387013
  1000002592
  1000008859
  1000007991
  1000007034
  6389068
  1000009762
  1000009940
  1000009980
  1000009915
  1000004637
  1000010443
  1000008492
  1000009449
  1000004124
  1000010537
  1000010920
  1000011009
  1000011028
  6383658
  1000012294
  1000009356
  1000012678
  1000001325
  1000010987
  1000012662
  1000013735
  1000012923
  1000014163
  1000014455
  6393089
  1000008860
  1000016939
  1000017157
  1000017193
  1000016656
  1000011086
  1000018840
  1000018936
  1000019099
  1000016580
  1000019559
  1000019576
  1000019580
  1000019591
  1000020177
  1000020178
  1000020179
  1000020191
  1000020202
  1000020205
  1000020206
  1000020207
  1000020214
  1000020215
  1000020252
  1000020262
  1000020277
  1000020280
  1000018761
  1000016320
  1000020873
  1000020922
  1000020960
  1000020964
  1000020967
  1000020968
  1000020969
  1000021187
  1000021193
  1000020924
  1000021217
  1000022037
  1000003926
  1000001497
  1000013868
  1000024214
  1000025576
  1000025619
  1000025624
  1000025759
  1000026330
  1000026357
  1000026361
  1000026680
  1000022038
  1000027019
  1000027059
  1000027369
  1000027375
  1000027377
  1000027382
  1000027384
  1000028704
  1000028705
  1000029600
  1000029601
  1000029620
  1000029621
  1000029623
  1000029624
  1000029625
  1000029626
  1000030069
  1000030659
  1000030664
  1000030669
  1000030671
  1000030674
  1000030677
  1000030678
  1000030679
  1000030689
  1000030701
  1000030752
  1000031239
  1000031265
  1000031266
  1000031277
  1000031282
  1000004799
  1000031964
  1000032052
  1000012943
  1000032085
  1000032359
  1000015605
  1000032452
  1000032466
  1000032467
  1000032468
  1000032481
  1000032495
  1000032506
  1000032507
  1000032513
  1000013644
  1000027768
  1000029636
  1000012842
  1000018119
  1000035139
  1000035370
  1000035371
  1000015637
  1000016099
  1000036587
  1000036588
  1000036590
  1000036591
  1000036593
  1000036594
  1000036596
  1000036597
  1000036599
  1000036600
  1000036613
  1000036616
  1000036618
  1000036624
  1000036625
  1000036642
  1000036645
  1000036652
  1000036771
  1000022806
  1000037471
  1000037472
  1000037489
  1000037497
  1000037519
  1000026362
  1000038110
  1000038121
  1000038122
  1000038123
  1000038129
  1000038139
  1000038143
  1000038325
  1000038326
  1000038405
  1000038410
  1000038427
  1000038429
  1000038438
  1000038528
  1000038530
  1000038548
  1000038656
  1000038657
  1000038658
  1000038659
  1000038660
  1000038663
  1000038665
  1000038671
  1000038672
  1000038673
  1000038674
  1000038679
  1000038683
  1000038684
  1000038685
  1000038686
  1000038687
  1000038688
  1000038690
  1000038691
  1000038692
  1000038694
  1000038696
  1000038697
  1000038698
  1000038699
  1000038700
  1000038702
  1000038777
  1000038795
  1000039855
  1000035533
  1000037531
  1000036261
  1000041779
  1000042381
  1000042490
  1000043009
  1000041916
  1000043021
  1000043470
  1000043471
  1000043472
  1000043473
  1000043491
  1000043544
  1000043545
  1000043548
  1000043549
  1000043760
  1000043816
  1000043855
  1000038796
  1000025621
  1000044443
  1000045345
  1000045346
  1000032327
  1000029513
  1000045655
  1000045665
  1000045666
  1000045668
  1000011082
  1000045683
  1000045684
  1000046054
  1000044462
  1000046257
  1000046351
  1000046724
  1000046725
  1000046729
  1000046732
  1000046733
  1000046735
  1000046738
  1000046739
  1000046742
  1000043805
  1000047064
  1000047533
  1000047534
  1000047535
  1000047536
  1000047537
  1000047538
  1000047540
  1000047541
  1000047542
  1000035135
  1000047777
  1000047798
  1000034812
  1000045364
  1000048148
  1000048200
  1000048227
  1000048228
  1000048366
  1000039513
  1000048405
  1000048465
  1000048524
  1000048527
  1000048529
  1000048530
  1000048594
  1000048699
  1000047773
  1000048840
  1000048907
  1000048975
  1000038556
  1000048211
  1000049423
  1000049425
  1000049426
  1000049348
  1000049550
  1000049555
  1000049822
  1000049871
  1000046748
  1000050562
  1000050048
  1000050929
  1000050991
  1000051009
  1000047543
  1000051377
  1000051381
  1000051628
  1000051890
  1000052073
  1000051872
  1000050594
  1000052287
  1000052289
  1000052397
  1000052697
  1000052044
  1000052864
  1000052914
  1000053034
  1000053214
  1000053306
  1000050902
  1000053428
  1000052814
  1000052291
  1000036772
  1000053701
  1000050060
  1000054014
  1000054075
  1000054087
  1000054503
  1000053871
  1000051830
  1000051851
  1000054729
  1000054850
  1000054791
  1000048597
  1000053955
  1000055201
  1000055228
  1000055242
  1000055282
  1000051828
  1000055679
  1000056000
  1000056149
  1000056343
  1000056453
  1000056435
  1000056002
  1000056624
  1000055024
  1000056764
  1000056834
  1000056952
  1000036656
  1000024451
  1000050104
  1000057042
  1000057043
  1000055174
  1000057236
  1000057423
  1000056598
  1000057955
  1000058161
  1000059033
  1000057985
  1000059305
  1000059613
  1000056841
  1000059843
  1000060586
  1000057561
  1000060992
  1000060993
  1000046978
  1000056687
  1000061400
  1000061466
  1000061554
  1000057095
  1000061616
  1000061660
  1000061661
  1000061704
  1000061843
  1000061888
  1000061889
  1000061954
  1000062375
  1000062378
  1000062242
  1000062596
  1000062599
  1000062633
  1000062634
  1000062869
  1000062889
  1000063000
  1000063304
  1000063305
  1000063331
  1000063402
  1000063419
  1000008544
  1000061971
  1000062291
  1000062625
  1000063204
  1000064027
  1000064277
  1000064281
  1000064528
  1000064530
  1000014181
  1000062398
  1000050787
  1000063552
  1000065112
  1000065260
  1000065321
  1000065506
  1000065549
  1000066247
  1000066270
  1000066385
  1000066386
  131263
]
20 0.40 ms
SELECT t0.id AS id_1, t0.min_qty AS min_qty_2, t0.max_qty AS max_qty_3, t0.step_qty AS step_qty_4, t0.product_id AS product_id_5 FROM product_rule t0 WHERE t0.product_id = ?
Parameters:
[
  96784
]
21 0.20 ms
SELECT t0.id AS id_1, t0.min_qty AS min_qty_2, t0.max_qty AS max_qty_3, t0.step_qty AS step_qty_4, t0.product_id AS product_id_5 FROM product_rule t0 WHERE t0.product_id = ?
Parameters:
[
  56130
]
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:
[
  9651
]
23 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:
[
  26728
]
24 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:
[
  65981
]
25 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
]
26 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:
[
  1157
]
27 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:
[
  5992
]
28 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:
[
  96968
]
29 0.19 ms
SELECT t0.id AS id_1, t0.min_qty AS min_qty_2, t0.max_qty AS max_qty_3, t0.step_qty AS step_qty_4, t0.product_id AS product_id_5 FROM product_rule t0 WHERE t0.product_id = ?
Parameters:
[
  9032
]
30 0.22 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.displayed_order AS displayed_order_3, t0.is_in_footer AS is_in_footer_4, t0.slug AS slug_5, t0.category_parent_id AS category_parent_id_6 FROM category t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
  1
]
31 0.33 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.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:
[
  16
]
33 0.26 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.displayed_order AS displayed_order_3, t0.is_in_footer AS is_in_footer_4, t0.slug AS slug_5, t0.category_parent_id AS category_parent_id_6 FROM category t0 WHERE t0.category_parent_id = ?
Parameters:
[
  17
]
34 0.31 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.displayed_order AS displayed_order_3, t0.is_in_footer AS is_in_footer_4, t0.slug AS slug_5, t0.category_parent_id AS category_parent_id_6 FROM category t0 WHERE t0.category_parent_id = ?
Parameters:
[
  18
]
35 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:
[
  19
]
36 0.29 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.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:
[
  21
]
38 0.33 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.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:
[
  23
]
40 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:
[
  24
]
41 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:
[
  25
]
42 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:
[
  26
]
43 0.15 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.displayed_order AS displayed_order_3, t0.is_in_footer AS is_in_footer_4, t0.slug AS slug_5, t0.category_parent_id AS category_parent_id_6 FROM category t0 WHERE t0.category_parent_id = ?
Parameters:
[
  27
]
44 0.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:
[
  28
]
45 0.66 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.14 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.displayed_order AS displayed_order_3, t0.is_in_footer AS is_in_footer_4, t0.slug AS slug_5, t0.category_parent_id AS category_parent_id_6 FROM category t0 WHERE t0.category_parent_id = ?
Parameters:
[
  31
]
48 0.14 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.displayed_order AS displayed_order_3, t0.is_in_footer AS is_in_footer_4, t0.slug AS slug_5, t0.category_parent_id AS category_parent_id_6 FROM category t0 WHERE t0.category_parent_id = ?
Parameters:
[
  32
]
49 0.31 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:
[
  131263
]

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 1013
App\Entity\Customer\Customer 294
App\Entity\User\User 236
App\Entity\Delivery\Delivery 198
App\Entity\Catalog\ProductCatalog 90
App\Entity\Catalog\CustomerCatalog 90
App\Entity\Product\Market 48
App\Entity\Pricing\Price 25
App\Entity\Product\ProductPrice 24
App\Entity\Internal\Commercial 23
App\Entity\Product\Product 21
App\Entity\Product\Category 21
App\Entity\Product\Characteristic 10
App\Entity\Product\CharacteristicLabel 10
App\Entity\Internal\Society 4
App\Entity\Delivery\DeliveryCost 4
App\Entity\Internal\Parameter 1