Query Metrics
12
Database Queries
8
Different statements
2.36 ms
Query time
0
Invalid entities
33
Managed entities
0
Cache hits
0
Cache misses
0
Cache puts
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 0.07 ms |
SELECT t0.id AS id_1, t0.country AS country_2, t0.updated_at AS updated_at_3, t0.created_at AS created_at_4, t0.customer_id AS customer_id_5, t0.last_order_id AS last_order_id_6 FROM carts t0 WHERE t0.id = ?
Parameters:
[
"019d24fa-34e6-76d9-a768-2be149c58815"
]
|
||||||||||||||||||||||||||||||||
| 2 | 0.08 ms |
SELECT t0.id AS id_1, t0.updated_at AS updated_at_2, t0.created_at AS created_at_3, t0.customer_id AS customer_id_4 FROM wishlists t0 WHERE t0.id = ?
Parameters:
[
"019d24fa-34ef-7387-8abc-124ece3ad665"
]
|
||||||||||||||||||||||||||||||||
| 3 | 0.31 ms |
SELECT a.id as group_id, a.code, a.name_ru, a.name_de, a.sort, a.is_metric, a.is_deeplink, a.is_filterable, a.use_deeplink_code, a.group_sort, a.group_name_ru, a.group_name_de, av.uid as value_id, av.name_ru as value_ru, av.name_de as value_de FROM attribute_value AS av JOIN attribute AS a on a.code = av.code WHERE av.uid IN('feiertage_820','beschriftungssprache_25380','materialgruppierung_1524','netto_gewicht_filter_1','art_2163','netto_gewicht_filter_3','verpackung_2870','netto_gewicht_filter_2','materialgruppierung_2386','verpackung_2954','freezebox_filter_3','farbgruppierung_576','netto_gewicht_filter_4','verpackung_3948','farbgruppierung_578','family_370','farbgruppierung_587','farbgruppierung_579','coolbox_filter_1','geschlecht_65','verpackung_3121','family_1072','verpackung_4205','materialgruppierung_1520','materialgruppierung_1522','form_2157','muster_474','netto_gewicht_filter_5','art_56006','farbgruppierung_7452','form_2154','materialgruppierung_1527','farbgruppierung_2835','materialgruppierung_33495','family_388','family_408','inschrift_51648','materialgruppierung_17837','vendor_357','form_2151','coolbox_filter_0','farbgruppierung_585','materialgruppierung_1521','altergruppierung_54019','art_5193','farbgruppierung_590','netto_gewicht_filter_6','feiertage_819','feiertage_826','fischart_29660','family_27','anzahl_der_artikel_2683','farbgruppierung_583','feiertage_822','vendor_42','farbgruppierung_586','hoehe_3085','materialgruppierung_1535','family_61','volumen_2164','durchmesser_4075','farbgruppierung_588','geschlecht_68','geschlecht_69','muster_30451','muster_473','anzahl_der_artikel_2681','fischart_37803','jahressymbol_56286','materialgruppierung_1523','anzahl_der_artikel_2680','family_148','family_418','grossen_17912','farbgruppierung_2960','form_4043','verwendungszweck_2241','family_184','farbgruppierung_580','materialgruppierung_2325','verpackung_3154','family_144','muster_31828','muster_8100','verwendungszweck_19209','durchmesser_11382','family_185','family_379','family_606','grossen_32765','materialgruppierung_2155','netto_gewicht_filter_7','serie_53508','thematik_29826','art_54906','einband_4619','family_337','geschlecht_66','grossen_42551','grossen_43872','hoehe_3066','inschrift_53524','materialgruppierung_1525','materialgruppierung_23844','materialgruppierung_25881','family_344','family_944','farbgruppierung_16945','hoehe_3107','verwendungszweck_2243','anwendungsgebiet_30910','anzahl_der_artikel_2679','anzahl_der_artikel_2823','anzahl_der_artikel_3789','art_36371','beschriftungssprache_25548','durchmesser_3985','family_207','family_307','family_423','family_523','family_65','family_823','fischart_37804','groesse_1010','groesse_1011','groesse_1012','groesse_1013','groesse_13435','groesse_13436','groesse_35132','groesse_35133','groesse_4188','groesse_7477','grossen_14559','hoehe_2914','hoehe_3115','muster_30481','muster_30503','muster_30613','netto_gewicht_filter_8','seitenzahl_3766','verwendungszweck_42011','verwendungszweck_6042','volumen_2635','warm_kalt_halten_43933','anwendungszeit_2288','anzahl_der_artikel_2682','art_33909','art_56007','display_559','durchmesser_2082','durchmesser_4103','family_1061','family_1082','family_1260','family_150','family_424','family_526','family_569','family_570','family_6','family_628','farbgruppierung_577','farbgruppierung_581','feiertage_825','fleischart_15470','grossen_4061','grossen_43898','grossen_51261','grossen_51295','grossen_54840','hoehe_2913','hoehe_3051','hoehe_3109','hoehe_3992','hoehe_4025','hoehe_4816','inschrift_50670','laenge_2557','material_des_griffs_3072','materialgruppierung_29600','materialgruppierung_5250','muster_13636','netto_gewicht_filter_10','topfvolumen_6066','typ_23655','typ_23691','vendor_10','verpackung_5933','verwendungszweck_4569','verwendungszweck_4570','verwendungszweck_5310','volumen_1462','volumen_5155','altergruppierung_27557','anzahl_der_artikel_14208','anzahl_der_artikel_2684','anzahl_der_artikel_2686','durchmesser_2070','durchmesser_3978','durchmesser_4074','durchmesser_4201','family_1255','family_142','family_152','family_183','family_200','family_378','family_412','family_589','family_829','family_950','fischart_38548','fleischart_15474','form_23503','grossen_35912','grossen_38343','grossen_45138','grossen_47194','grossen_51982','grossen_5287','grossen_53510','grossen_53546','grossen_55208','grossen_55209','grossen_7604','handelsform_5910','herdarten_2765','herdarten_2766','herdarten_2767','herdarten_2768','herdarten_2975','koerpermaterial_5214','leistung_651','materialgruppierung_2406','materialgruppierung_43412','materialgruppierung_9190','modelname_32769','muster_30449','muster_31225','muster_3730','muster_5122','muster_6570','muster_7594','netto_fuellmenge_filter_1','netto_gewicht_filter_9','stecker_typ_29449','steuerungsart_8034','steuerungssprache_1505','verpackung_36357','verpackung_3971','verpackung_41994','verwendungszweck_1137','verwendungszweck_2240','verwendungszweck_2754','verwendungszweck_2771','verwendungszweck_2772','verwendungszweck_2859','verwendungszweck_4532','verwendungszweck_52827','volumen_2365','volumen_2424','altergruppierung_6272','anwendungsgebiet_30918','anzahl_der_artikel_34486','anzahl_der_artikel_5713','anzahl_der_programme_28023','art_39784','art_56047','art_56801','durchmesser_2074','durchmesser_2075','durchmesser_2081','durchmesser_6176','family_102','family_1078','family_1236','family_157','family_190','family_238','family_315','family_316','family_324','family_338','family_55','family_663','family_792','family_794','family_851','family_922','family_971','farbgruppierung_584','feiertage_823','feiertage_960','fischart_29999','form_2153','form_24932','form_5736','geschlecht_70','geschmack_24694','getreideart_15473','grossen_16992','grossen_38494','grossen_4271','grossen_43911','grossen_47192','grossen_51980','grossen_53231','grossen_53474','grossen_53481','grossen_53545','grossen_53731','grossen_53787','grossen_54132','grossen_56432','hauttyp_351','hoehe_11290','hoehe_3079','hoehe_3099','hoehe_33347','hoehe_3905','inschrift_22370','inschrift_46979','inschrift_50672','laenge_3130','laenge_6032','materialgruppierung_1536','materialgruppierung_16290','modelname_25644','modelname_29023','modelname_53585','modelname_53690','muster_13186','muster_1699','muster_33280','muster_476','muster_9357','serie_29022','serie_36319','serie_53324','serie_53689','thematik_29839','topfbeschichtung_6059','typ_4887','vendor_1028','vendor_11','vendor_1311','vendor_1363','vendor_1411','vendor_49','verpackung_24689','verpackung_3609','verpackung_37215','verwendungszweck_2249','verwendungszweck_2251','verwendungszweck_2255','verwendungszweck_2257','verwendungszweck_4741','verwendungszweck_5001','verwendungszweck_5730','volumen_1464','volumen_2487','volumen_2502','volumen_3977','warm_kalt_halten_43927','altergruppierung_54021','anwendungsgebiet_30890','anwendungsgebiet_30906','anwendungsgebiet_30908','anwendungsgebiet_30909','anzahl_der_artikel_11430','anzahl_der_artikel_14083','anzahl_der_artikel_16338','anzahl_der_artikel_2685','anzahl_der_portionen_35938','anzahl_der_programme_701','anzahl_der_programme_703','art_29791','art_30396','art_30399','art_33911','art_35238','art_43943','art_54193','art_56039','art_56040','art_56799','art_56800','art_56802','art_56838','beschriftungssprache_25379','display_560','durchmesser_2073','durchmesser_2076','durchmesser_22801','durchmesser_2865','durchmesser_2953','durchmesser_3625','durchmesser_4024','durchmesser_4140','durchmesser_4168','durchmesser_4197','durchmesser_4210','durchmesser_4241','durchmesser_4345','durchmesser_4385','durchmesser_4392','durchmesser_43975','durchmesser_5092','durchmesser_51301','durchmesser_53579','durchmesser_53728','durchmesser_53729','durchmesser_53730','durchmesser_7344','durchmesser_7353','durchmesser_des_feuerofens_54109','einband_4375','family_1015','family_1031','family_1056','family_1101','family_1169','family_1245','family_1246','family_1247','family_1275','family_1285','family_138','family_139','family_143','family_165','family_168','family_177','family_179','family_191','family_201','family_222','family_250','family_312','family_314','family_439','family_450','family_462','family_594','family_619','family_62','family_657','family_666','family_679','family_681','family_685','family_688','family_691','family_693','family_769','family_787','family_789','family_858','family_888','family_921','family_936','farbgruppierung_582','feiertage_824','fischart_36125','fischart_39433','fleischart_47539','form_2152','genre_4374','gesamthoehe_41951','geschmack_23765','geschmack_23778','geschmack_26932','geschmack_39591','geschmack_52741','getreideart_23671','groesse_14698','groesse_3393','groesse_3394','groesse_8758','groesse_8761','grossen_11289','grossen_13437','grossen_13690','grossen_16355','grossen_17913','grossen_24246','grossen_24933','grossen_31179','grossen_31180','grossen_31219','grossen_32223','grossen_3723','grossen_37364','grossen_37416','grossen_37797','grossen_38050','grossen_38493','grossen_42522','grossen_42552','grossen_43443','grossen_43840','grossen_43916','grossen_43917','grossen_43920','grossen_43925','grossen_44608','grossen_44885','grossen_45400','grossen_46691','grossen_47945','grossen_48703','grossen_51285','grossen_51300','grossen_51302','grossen_51322','grossen_51520','grossen_51983','grossen_51993','grossen_5202','grossen_52836','grossen_52837','grossen_52838','grossen_52839','grossen_53190','grossen_53191','grossen_53206','grossen_53211','grossen_53229','grossen_53237','grossen_53298','grossen_5331','grossen_53477','grossen_53479','grossen_53480','grossen_53497','grossen_53526','grossen_53531','grossen_53536','grossen_53537','grossen_53539','grossen_53540','grossen_53784','grossen_53786','grossen_53807','grossen_53808','grossen_53942','grossen_54136','grossen_54721','grossen_55430','grossen_55431','grossen_56318','grossen_56429','grossen_5921','grossen_5922','grossen_7626','grossen_7693','grossen_7851','grossen_7918','grossen_9409','grossen_9456','haar_typ_1819','handelsform_5911','handelsform_6235','herdarten_7987','hoehe_13180','hoehe_19441','hoehe_3040','hoehe_3050','hoehe_3068','hoehe_3081','hoehe_3089','hoehe_3098','hoehe_3101','hoehe_3103','hoehe_3104','hoehe_3613','hoehe_41003','hoehe_4150','hoehe_5102','hoehe_51299','hoehe_5241','hoehe_5360','hoehe_9381','inschrift_23304','inschrift_39166','inschrift_46977','inschrift_51672','inschrift_53316','jahressymbol_50796','jahressymbol_55294','kategorie_13351','koerpermaterial_28507','laenderkueche_36352','laenderkueche_36353','laenderkueche_36354','laenderkueche_36355','laenge_13885','laenge_22736','laenge_24326','laenge_2551','laenge_2559','laenge_2588','laenge_3046','laenge_3116','laenge_3122','laenge_3231','laenge_7483','lampen_anzahl_739','leistung_53469','leistung_652','material_des_griffs_2739','material_des_griffs_2741','materialgruppierung_11288','materialgruppierung_14518','materialgruppierung_1638','materialgruppierung_2062','materialgruppierung_2321','materialgruppierung_23843','materialgruppierung_38523','materialgruppierung_3917','materialgruppierung_3960','materialgruppierung_53202','materialgruppierung_53538','materialgruppierung_5629','modelname_17061','modelname_24744','modelname_24881','modelname_25364','modelname_25636','modelname_25888','modelname_25936','modelname_26101','modelname_30320','modelname_31306','modelname_34046','modelname_34048','modelname_34517','modelname_34673','modelname_34724','modelname_35065','modelname_35921','modelname_37701','modelname_38052','modelname_38193','modelname_38194','modelname_38981','modelname_44174','modelname_47854','modelname_50806','modelname_51388','modelname_51394','modelname_51396','modelname_51404','modelname_51686','modelname_56382','muster_11297','muster_21352','muster_24918','muster_30454','muster_30609','muster_31064','muster_34529','muster_34954','muster_3659','muster_46694','muster_475','muster_55402','muster_9060','netto_fuellmenge_filter_2','netto_fuellmenge_filter_3','netto_gewicht_filter_12','plattengroesse_51979','seitenzahl_13903','seitenzahl_8900','serie_34516','serie_34820','serie_35078','serie_36315','serie_36316','serie_51454','serie_51457','serie_51458','serie_53220','serie_53940','serie_53972','serie_54214','serie_55432','serie_9863','stahldicke_3047','steuerungsart_26671','steuerungsart_5032','steuerungssprache_1506','stil_25835','topfbeschichtung_24381','topfbeschichtung_6074','typ_16198','typ_23563','typ_23692','typ_33896','typ_36411','vendor_1042','vendor_1052','vendor_1055','vendor_1061','vendor_1091','vendor_1098','vendor_1112','vendor_1162','vendor_1179','vendor_1183','vendor_1206','vendor_1266','vendor_1319','vendor_1366','vendor_149','vendor_162','vendor_295','vendor_297','vendor_385','vendor_43','vendor_484','vendor_519','vendor_552','vendor_573','vendor_606','vendor_784','vendor_860','verpackung_11349','verpackung_25768','verpackung_31703','verpackung_3653','verpackung_3840','verpackung_4003','verpackung_6379','verpackung_9455','verwendungszweck_141','verwendungszweck_17634','verwendungszweck_17979','verwendungszweck_2246','verwendungszweck_2254','verwendungszweck_2258','verwendungszweck_2316','verwendungszweck_2396','verwendungszweck_2528','verwendungszweck_25912','verwendungszweck_2721','verwendungszweck_2723','verwendungszweck_4040','verwendungszweck_4215','verwendungszweck_4463','verwendungszweck_4751','verwendungszweck_4848','verwendungszweck_4916','verwendungszweck_4953','verwendungszweck_50781','verwendungszweck_5937','verwendungszweck_6477','verwendungszweck_6537','verwendungszweck_6814','verwendungszweck_9603','verwendungszweck_9715','volumen_1467','volumen_1470','volumen_2083','volumen_2363','volumen_2381','volumen_27014','volumen_2941','volumen_4942','volumen_5968','volumen_6223','volumen_6416','volumen_682','volumen_der_tasse_5448','warm_kalt_halten_43928','warm_kalt_halten_53142') AND a.is_filterable = true
Parameters:
[]
|
||||||||||||||||||||||||||||||||
| 4 | 0.12 ms |
SELECT t0.id AS id_1, t0.price AS price_2, t0.sku AS sku_3, t0.updated_at AS updated_at_4, t0.created_at AS created_at_5, t0.wishlist_id AS wishlist_id_6 FROM wishlist_items t0 WHERE t0.wishlist_id = ? ORDER BY t0.created_at DESC
Parameters:
[
"019d24fa-34ef-7387-8abc-124ece3ad665"
]
|
||||||||||||||||||||||||||||||||
| 5 | 0.17 ms |
SELECT b0_.id AS id_0, b0_.title AS title_1, b0_.banner_type AS banner_type_2, b0_.banner_order AS banner_order_3, b0_.image_path AS image_path_4, b0_.destination AS destination_5, b0_.category_include AS category_include_6, b0_.category_exclude AS category_exclude_7, b0_.date_start AS date_start_8, b0_.date_end AS date_end_9, b0_.options AS options_10 FROM banners b0_ WHERE b0_.banner_type = ? AND b0_.date_start < ? AND (b0_.date_end > ? OR b0_.date_end IS NULL)
Parameters:
[ "top_full_width" "2026-03-25 13:31:11" "2026-03-25 13:31:11" ] |
||||||||||||||||||||||||||||||||
| 6 | 0.15 ms |
SELECT t0.id AS id_1, t0.price AS price_2, t0.quantity AS quantity_3, t0.sku AS sku_4, t0.hash AS hash_5, t0.updated_at AS updated_at_6, t0.created_at AS created_at_7, t0.options AS options_8, t0.cart_id AS cart_id_9 FROM cart_items t0 WHERE t0.cart_id = ? ORDER BY t0.created_at DESC
Parameters:
[
"019d24fa-34e6-76d9-a768-2be149c58815"
]
|
||||||||||||||||||||||||||||||||
| 7 | 0.13 ms |
SELECT t0.id AS id_1, t0.type AS type_2, t0.category_order AS category_order_3, t0.title_ru AS title_ru_4, t0.title_de AS title_de_5, t0.url_ru AS url_ru_6, t0.url_de AS url_de_7, t0.date_start AS date_start_8, t0.date_end AS date_end_9, t0.options AS options_10 FROM category_menu t0 WHERE t0.type IN (?, ?, ?, ?)
Parameters:
[ "menu_main" "top_amount" "top_sold" "sale" ] |
||||||||||||||||||||||||||||||||
| 8 | 0.21 ms |
SELECT b0_.id AS id_0, b0_.title AS title_1, b0_.banner_type AS banner_type_2, b0_.banner_order AS banner_order_3, b0_.image_path AS image_path_4, b0_.destination AS destination_5, b0_.category_include AS category_include_6, b0_.category_exclude AS category_exclude_7, b0_.date_start AS date_start_8, b0_.date_end AS date_end_9, b0_.options AS options_10 FROM banners b0_ WHERE b0_.banner_type = ? AND b0_.date_start < ? AND (b0_.date_end > ? OR b0_.date_end IS NULL)
Parameters:
[ "top_promo" "2026-03-25 13:31:11" "2026-03-25 13:31:11" ] |
||||||||||||||||||||||||||||||||
| 9 | 0.11 ms |
SELECT b0_.id AS id_0, b0_.title AS title_1, b0_.banner_type AS banner_type_2, b0_.banner_order AS banner_order_3, b0_.image_path AS image_path_4, b0_.destination AS destination_5, b0_.category_include AS category_include_6, b0_.category_exclude AS category_exclude_7, b0_.date_start AS date_start_8, b0_.date_end AS date_end_9, b0_.options AS options_10 FROM banners b0_ WHERE b0_.banner_type = ? AND b0_.date_start < ? AND (b0_.date_end > ? OR b0_.date_end IS NULL)
Parameters:
[ "category" "2026-03-25 13:31:11" "2026-03-25 13:31:11" ] |
||||||||||||||||||||||||||||||||
| 10 | 0.53 ms |
SELECT b0_.id AS id_0, b0_.title AS title_1, b0_.banner_type AS banner_type_2, b0_.banner_order AS banner_order_3, b0_.image_path AS image_path_4, b0_.destination AS destination_5, b0_.category_include AS category_include_6, b0_.category_exclude AS category_exclude_7, b0_.date_start AS date_start_8, b0_.date_end AS date_end_9, b0_.options AS options_10 FROM banners b0_ WHERE b0_.banner_type = ? AND b0_.date_start < ? AND (b0_.date_end > ? OR b0_.date_end IS NULL)
Parameters:
[ "menu" "2026-03-25 13:31:12" "2026-03-25 13:31:12" ] |
||||||||||||||||||||||||||||||||
| 11 | 0.39 ms |
SELECT b0_.id AS id_0, b0_.title AS title_1, b0_.banner_type AS banner_type_2, b0_.banner_order AS banner_order_3, b0_.image_path AS image_path_4, b0_.destination AS destination_5, b0_.category_include AS category_include_6, b0_.category_exclude AS category_exclude_7, b0_.date_start AS date_start_8, b0_.date_end AS date_end_9, b0_.options AS options_10 FROM banners b0_ WHERE b0_.banner_type = ? AND b0_.date_start < ? AND (b0_.date_end > ? OR b0_.date_end IS NULL)
Parameters:
[ "menu_top" "2026-03-25 13:31:12" "2026-03-25 13:31:12" ] |
||||||||||||||||||||||||||||||||
| 12 | 0.07 ms |
SELECT t0.id AS id_1, t0.type AS type_2, t0.category_order AS category_order_3, t0.title_ru AS title_ru_4, t0.title_de AS title_de_5, t0.url_ru AS url_ru_6, t0.url_de AS url_de_7, t0.date_start AS date_start_8, t0.date_end AS date_end_9, t0.options AS options_10 FROM category_menu t0 WHERE t0.type = ?
Parameters:
[
"menu_mobile"
]
|
Database Connections
| Name | Service |
|---|---|
| default | doctrine.dbal.default_connection |
Entity Managers
| Name | Service |
|---|---|
| default | doctrine.orm.default_entity_manager |
Second Level Cache
0
Hits
0
Misses
0
Puts
Managed Entities
default entity manager
| Class | Amount of managed objects |
|---|---|
| App\Entity\Banner | 20 |
| App\Entity\CategoryMenu | 11 |
| App\Entity\Cart | 1 |
| App\Entity\Wishlist | 1 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\Cart | No errors. |
| App\Entity\Customer | No errors. |
| App\Entity\Order | No errors. |
| App\Entity\CartItem | No errors. |
| App\Entity\Wishlist | No errors. |
| App\Entity\WishlistItem | No errors. |
| App\Entity\Attribute | No errors. |
| App\Entity\CategoryMenu | No errors. |
| App\Entity\Banner | No errors. |