Symfony Profiler

Query Metrics

12 Database Queries

8 Different statements

12.35 ms Query time

0 Invalid entities

33 Managed entities

0 Cache hits

0 Cache misses

0 Cache puts

Grouped Statements

Show all queries

Time▼

Count

Info

11.23 ms
(90.93%)

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('coolbox_filter_0','freezebox_filter_3','netto_gewicht_filter_3','verpackung_2870','netto_gewicht_filter_4','netto_gewicht_filter_5','art_2163','freezebox_filter_2','family_693','verpackung_2954','netto_gewicht_filter_2','verpackung_4205','netto_gewicht_filter_1','coolbox_filter_1','verpackung_3121','netto_gewicht_filter_6','verpackung_3948','art_der_suessigkeiten_34384','verpackung_35918','fleischart_15470','family_376','vendor_531','family_688','verpackung_4003','verpackung_37215','handelsform_3535','verpackung_36357','geschmack_26932','vendor_458','laenderkueche_36352','family_1072','family_932','verpackung_24689','laenderkueche_36350','family_1275','art_25334','handelsform_3534','sorte_3536','geschmack_23761','family_1152','vendor_386','fleischart_15474','fuellung_36388','family_981','family_1078','vendor_196','vendor_357','geschmack_23757','family_692','geschmack_29765','sorte_26188','art_der_suessigkeiten_42806','family_921','geschmack_23765','getreideart_15473','netto_fuellmenge_filter_5','verpackung_3840','family_716','geschmack_36384','family_1073','family_999','family_922','family_971','art_15477','art_39784','fleischart_47539','vendor_1232','verpackung_5933','family_684','fuellung_36365','verpackung_27725','art_der_suessigkeiten_34102','family_1002','typ_36792','verpackung_14402','getreideart_25277','laenderkueche_43012','family_850','vendor_1298','art_56006','geschmack_29768','vendor_529','family_724','geschmack_23753','geschmack_23781','family_760','art_56994','art_der_suessigkeiten_39611','family_1101','family_1220','geschmack_23759','laenderkueche_36354','family_980','sorte_15484','family_1211','family_589','family_687','geschmack_26601','handelsform_5934','art_der_suessigkeiten_40017','family_683','teigwarenart_25243','vendor_42','handelsform_35601','feiertage_819','laenderkueche_36349','family_1035','vendor_380','family_865','vendor_114','family_685','fischart_29659','geschmack_25688','vendor_159','verpackung_9455','handelsform_5911','vendor_231','family_1213','feiertage_960','geschmack_36009','art_54870','vendor_1258','art_30399','art_der_suessigkeiten_46435','family_1228','family_577','geschmack_23762','netto_fuellmenge_filter_4','vendor_1409','vendor_156','vendor_158','verwendungszweck_4215','family_1232','family_880','family_920','getreideart_23707','verwendungszweck_46428','art_der_suessigkeiten_35208','art_der_suessigkeiten_40018','family_1026','family_711','geschmack_23756','geschmack_23774','family_594','geschmack_24694','fuellung_51141','getreideart_23671','vendor_1152','vendor_150','vendor_224','family_689','fuellung_39590','art_29786','art_56995','art_der_suessigkeiten_36995','feiertage_820','geschmack_42730','vendor_216','fischart_29660','vendor_482','vendor_716','art_51799','geschmack_23778','getreideart_15476','vendor_135','vendor_198','art_29787','family_1212','family_1241','feiertage_1130','typ_26962','vendor_1395','art_55439','art_56940','family_1286','family_418','geschmack_23770','vendor_1135','vendor_752','family_1044','fleischart_47119','fuellung_46951','fuellung_51117','netto_gewicht_filter_7','vendor_1313','vendor_404','vendor_923','verpackung_3653','art_der_suessigkeiten_39960','family_1168','family_462','fischart_29740','geschmack_35867','vendor_1016','anzahl_der_portionen_35937','getreideart_23711','vendor_895','verpackung_26798','art_54139','art_der_suessigkeiten_56942','family_1231','family_771','fischart_29998','geschmack_52741','handelsform_27113','netto_fuellmenge_filter_3','vendor_881','verpackung_38799','verpackung_42548','art_56007','fettanteil_52859','geschmack_23755','modelname_40223','vendor_1179','vendor_179','vendor_221','vendor_489','art_54631','family_1049','family_1065','family_1080','family_1234','family_691','family_867','laenderkueche_50808','vendor_134','vendor_1377','vendor_860','vendor_938','art_27151','family_1027','family_1114','family_1210','family_1233','family_629','family_682','family_973','family_986','fischart_37803','fischart_54823','geschmack_23747','geschmack_26600','geschmack_39591','geschmack_43102','serie_44880','serie_51387','typ_23685','vendor_1521','vendor_165','vendor_922','art_57036','art_der_suessigkeiten_40113','family_778','geschmack_23764','vendor_1027','vendor_1292','vendor_1348','vendor_1373','vendor_186','vendor_381','vendor_424','vendor_725','vendor_762','art_29791','art_54697','family_1054','family_1118','family_789','family_854','family_975','family_978','fischart_29999','fischart_36125','fuellung_51115','geschmack_23776','geschmack_26612','geschmack_32270','manufacturer_53914','vendor_679','vendor_897','vendor_944','verpackung_3154','verwendungszweck_2755','volumen_2424','art_23066','art_54632','art_55436','family_1028','family_441','family_935','geschmack_23763','geschmack_36938','getreideart_15480','getreideart_15481','handelsform_6235','teigwarenart_38803','vendor_1028','vendor_1191','vendor_1330','vendor_1412','vendor_1593','vendor_751','verpackung_4977','verwendungszweck_5081','verwendungszweck_7957','anwendungszeit_2288','art_51800','art_56939','family_1077','family_699','family_886','family_977','fischart_35526','fischart_38548','fuellung_52550','fuellung_53397','sorte_51687','typ_27609','typ_35555','vendor_1214','vendor_1216','vendor_1228','vendor_1317','vendor_1374','vendor_162','vendor_171','vendor_402','vendor_499','vendor_834','aroma_3539','art_29796','art_37185','family_1129','family_1260','family_1280','family_754','fischart_43299','fuellung_36847','fuellung_54431','geschmack_23775','geschmack_24687','geschmack_36380','sorte_7952','vendor_1462','vendor_149','vendor_486','vendor_759','vendor_962','verpackung_3609','weinart_53885','aroma_7551','art_36372','art_39785','family_1000','family_690','fettanteil_54147','fischart_37812','fuellung_51760','geschmack_23749','geschmack_23766','geschmack_31753','geschmack_35745','laenderkueche_36355','netto_fuellmenge_filter_2','pastete_sorten_29724','pastete_sorten_29725','serie_39543','vendor_1031','vendor_1226','vendor_1255','vendor_1476','vendor_413','vendor_477','vendor_511','vendor_553','vendor_721','vendor_724','vendor_728','art_39778','art_53069','art_54199','family_1102','family_1106','family_1167','family_1215','family_1219','family_752','feiertage_825','fuellung_39832','geschmack_23779','geschmack_26602','geschmack_26929','geschmack_36155','geschmack_53621','getreideart_23709','laenderkueche_43013','serie_39534','typ_34174','vendor_1113','vendor_1383','vendor_177','vendor_192','vendor_309','vendor_579','vendor_637','vendor_914','vendor_960','verpackung_6308','anzahl_der_portionen_35938','aroma_3546','art_23067','art_7540','family_1169','family_976','fleischart_30153','fuellung_39485','fuellung_39488','geschmack_23783','geschmack_45116','geschmack_51195','serie_55241','sorte_39243','vendor_111','vendor_1125','vendor_1173','vendor_1296','vendor_1316','vendor_140','vendor_1507','vendor_227','vendor_743','vendor_954','vendor_989','verwendungszweck_2752','verwendungszweck_35606','volumen_1460','altergruppierung_54019','altergruppierung_6272','anzahl_der_artikel_2679','art_23723','art_37143','art_56221','art_der_beeren_53100','family_1226','family_686','family_756','family_769','family_770','feiertage_821','feiertage_826','fettanteil_53700','fischart_43325','fuellung_39647','fuellung_39651','fuellung_51842','fuellung_52241','geschmack_23754','geschmack_26611','geschmack_26964','geschmack_36921','geschmack_38999','geschmack_39836','geschmack_39953','pastete_sorten_29718','serie_53575','vendor_1015','vendor_1070','vendor_1133','vendor_1153','vendor_1158','vendor_1218','vendor_1318','vendor_1422','vendor_1466','vendor_1472','vendor_1508','vendor_1540','vendor_1598','vendor_414','vendor_430','vendor_441','vendor_449','vendor_457','vendor_552','vendor_639','vendor_641','vendor_681','vendor_755','vendor_862','vendor_991','verwendungszweck_6088','art_33908','art_35238','art_37170','art_54194','family_1009','family_1031','family_1074','family_1214','family_757','family_974','feiertage_823','fettanteil_51891','fuellung_29777','fuellung_36364','fuellung_52846','geschmack_23758','geschmack_23782','geschmack_36940','geschmack_54329','getreideart_15482','sorte_45806','teigwarenart_25246','vendor_1104','vendor_1106','vendor_116','vendor_1240','vendor_1328','vendor_1372','vendor_1394','vendor_1406','vendor_1433','vendor_1459','vendor_1464','vendor_1496','vendor_1529','vendor_1545','vendor_178','vendor_267','vendor_431','vendor_533','vendor_772','verpackung_31703','verwendungszweck_135','anzahl_der_portionen_50815','aroma_55191','art_14443','art_35236','art_39627','art_52277','art_53592','art_54630','art_54638','art_56253','art_der_beeren_53103','family_1032','family_1033','family_697','family_773','family_972','fischart_29664','fischart_54769','fuellung_42734','fuellung_51125','fuellung_51170','fuellung_51734','fuellung_55934','geschlecht_65','geschmack_23760','geschmack_26605','geschmack_39002','geschmack_39945','grossen_38388','materialgruppierung_33495','netto_gewicht_filter_9','serie_34905','serie_54773','typ_55466','vendor_1025','vendor_1165','vendor_1187','vendor_1205','vendor_1289','vendor_1297','vendor_1337','vendor_1376','vendor_1483','vendor_1495','vendor_153','vendor_1549','vendor_1582','vendor_1595','vendor_274','vendor_277','vendor_537','vendor_554','vendor_608','vendor_685','vendor_785','vendor_852','vendor_861','vendor_869','vendor_924','vendor_980','verpackung_45261','verpackung_46731','verwendungszweck_17979','verwendungszweck_2256','verwendungszweck_29892','verwendungszweck_41370','aroma_26886','aroma_4227','aroma_4975','aroma_4976','art_36368','art_37171','art_37854','art_54635','art_54694','art_54695','art_55179','art_56419','art_der_beeren_53566','art_der_beeren_54072','art_der_beeren_54397','extract_53040','family_1120','family_1131','family_1229','family_1249','family_755','fettanteil_43969','fettanteil_52040','fischart_43320','fischart_43337','fischart_52914','fuellung_52898','geschlecht_66','geschmack_36935','geschmack_44672','geschmack_51196','geschmack_54650','laenderkueche_51124','manufacturer_53916','manufacturer_57302','serie_36417','serie_44736','teigwarenart_25230','typ_48885','vendor_1018','vendor_1160','vendor_1207','vendor_1342','vendor_1350','vendor_1410','vendor_1435','vendor_1455','vendor_1456','vendor_1555','vendor_1588','vendor_1597','vendor_1606','vendor_166','vendor_170','vendor_316','vendor_405','vendor_432','vendor_438','vendor_519','vendor_528','vendor_621','vendor_984','verwendungszweck_6536','verwendungszweck_9603','volumen_2365','weinart_53876','aroma_13964','aroma_17796','aroma_23887','aroma_23893','art_22870','art_22876','art_29788','art_29790','art_29792','art_41586','art_51126','art_54141','art_54633','art_54637','art_54715','art_der_beeren_53106','art_der_beeren_56092','extract_53033','family_1021','family_1030','family_1036','family_1046','family_1100','family_1128','family_1176','family_1209','family_1227','family_1238','family_1240','family_1254','family_1269','family_1270','family_1273','family_526','family_926','farbgruppierung_579','fettanteil_52035','fettanteil_52299','fischart_29661','fischart_37804','fleischart_15475','fleischart_54883','fleischart_54889','fuellung_51114','fuellung_55175','geschmack_23771','geschmack_23777','geschmack_26604','geschmack_36669','geschmack_36851','geschmack_46434','geschmack_53803','getreideart_23708','laenderkueche_47654','laenderkueche_48797','manufacturer_55474','netto_fuellmenge_filter_6','netto_gewicht_filter_8','serie_33808','serie_37454','serie_41382','serie_51965','serie_55386','teigwarenart_25229','teigwarenart_56421','typ_55388','vendor_1054','vendor_1119','vendor_1146','vendor_1157','vendor_1206','vendor_1261','vendor_1277','vendor_1300','vendor_1311','vendor_1355','vendor_1357','vendor_1380','vendor_1385','vendor_1450','vendor_1457','vendor_1481','vendor_152','vendor_1534','vendor_154','vendor_1542','vendor_1563','vendor_1567','vendor_1568','vendor_1621','vendor_164','vendor_181','vendor_265','vendor_444','vendor_500','vendor_535','vendor_538','vendor_547','vendor_582','vendor_642','vendor_644','vendor_738','vendor_767','vendor_770','vendor_851','vendor_855','vendor_873','vendor_896','vendor_909','vendor_910','vendor_928','vendor_967','vendor_972','vendor_979','verwendungszweck_2248','verwendungszweck_6827','volumen_37380','weinart_53872','anwendungszeit_9771','aroma_13957','aroma_24235','art_22724','art_22832','art_22836','art_30396','art_30632','art_30649','art_30666','art_33919','art_54198','art_54636','art_54739','art_55667','art_56215','art_56255','art_56257','art_57225','art_der_beeren_54286','art_der_beeren_54717','art_der_suessigkeiten_39991','extract_53002','family_1024','family_1045','family_1075','family_1225','family_1253','family_1262','family_1266','family_1279','family_695','family_759','family_868','feiertage_822','fuellung_51140','fuellung_51969','fuellung_52598','fuellung_54104','fuellung_54798','fuellung_55875','geschmack_26599','geschmack_26607','geschmack_36932','geschmack_37738','geschmack_42691','geschmack_53895','geschmack_54213','geschmack_56818','getreideart_25279','getreideart_38595','handelsform_5910','manufacturer_57065','netto_gewicht_filter_11','netto_gewicht_filter_13','serie_39536','serie_39538','serie_55666','sorte_19469','typ_16198','vendor_1007','vendor_1020','vendor_1033','vendor_1037','vendor_1055','vendor_1107','vendor_1195','vendor_1241','vendor_1247','vendor_1254','vendor_1260','vendor_1302','vendor_1307','vendor_1309','vendor_1312','vendor_1319','vendor_1371','vendor_1375','vendor_1378','vendor_138','vendor_1386','vendor_1423','vendor_143','vendor_1458','vendor_1477','vendor_1482','vendor_1486','vendor_1487','vendor_1492','vendor_1494','vendor_1505','vendor_151','vendor_1520','vendor_1527','vendor_1528','vendor_1535','vendor_1543','vendor_1554','vendor_157','vendor_1578','vendor_1580','vendor_1581','vendor_1587','vendor_1605','vendor_1624','vendor_223','vendor_225','vendor_251','vendor_295','vendor_296','vendor_346','vendor_403','vendor_406','vendor_459','vendor_490','vendor_527','vendor_573','vendor_577','vendor_609','vendor_630','vendor_744','vendor_814','vendor_883','vendor_946','vendor_992','verwendungszweck_16237','verwendungszweck_2240','verwendungszweck_34164','verwendungszweck_35571','verwendungszweck_6814','volumen_32280','volumen_41001','volumen_41002','volumen_5235','weinart_57300','anzahl_der_artikel_2680','anzahl_der_portionen_35920','anzahl_der_portionen_35933','aroma_11395','aroma_17795','aroma_22670','aroma_39184','aroma_39201','aroma_4224','aroma_4974','aroma_6917','art_15478','art_22663','art_22806','art_22810','art_22844','art_22868','art_29789','art_30630','art_30684','art_36390','art_40602','art_51286','art_54105','art_54140','art_54455','art_54738','art_55008','art_56993','art_57203','art_der_beeren_54004','art_der_beeren_56099','art_der_suessigkeiten_52757','extract_53001','extract_53015','family_1011','family_1016','family_1023','family_1115','family_1259','family_723','family_758','family_858','family_936','farbgruppierung_578','fettanteil_53325','fettanteil_54814','fettanteil_55626','fettanteil_55845','fettanteil_56075','fischart_29665','fischart_43293','fischart_45346','fischart_52492','fischart_52858','fischart_55177','fischart_57425','fuellung_36367','fuellung_39661','fuellung_55123','fuellung_55170','fuellung_55284','fuellung_55786','geschmack_23748','geschmack_23769','geschmack_26329','geschmack_29525','geschmack_36381','geschmack_39167','geschmack_42774','geschmack_45977','geschmack_51197','geschmack_54330','geschmack_54443','geschmack_54962','getreideart_25278','handelsform_27518','handelsform_35599','laenderkueche_36351','laenderkueche_36353','laenderkueche_43127','manufacturer_53918','manufacturer_55475','manufacturer_56718','manufacturer_56721','manufacturer_56723','manufacturer_57094','pastete_sorten_29726','serie_32988','serie_53680','sorte_27412','sorte_39254','typ_33892','typ_40821','vendor_1035','vendor_1048','vendor_1051','vendor_1064','vendor_1077','vendor_1085','vendor_1088','vendor_1112','vendor_1114','vendor_112','vendor_1121','vendor_1145','vendor_1147','vendor_1181','vendor_1197','vendor_1215','vendor_125','vendor_1276','vendor_1281','vendor_1293','vendor_1315','vendor_1327','vendor_1333','vendor_1346','vendor_1347','vendor_1379','vendor_1381','vendor_1388','vendor_1390','vendor_1414','vendor_1432','vendor_144','vendor_1440','vendor_1449','vendor_1463','vendor_1465','vendor_1470','vendor_1478','vendor_1479','vendor_1484','vendor_1512','vendor_1522','vendor_1533','vendor_1536','vendor_1546','vendor_1547','vendor_1552','vendor_1558','vendor_1575','vendor_1577','vendor_1591','vendor_1610','vendor_1612','vendor_1618','vendor_1629','vendor_1631','vendor_1634','vendor_200','vendor_207','vendor_248','vendor_259','vendor_347','vendor_412','vendor_467','vendor_514','vendor_534','vendor_551','vendor_636','vendor_664','vendor_665','vendor_666','vendor_678','vendor_689','vendor_700','vendor_745','vendor_821','vendor_836','vendor_850','vendor_907','vendor_956','vendor_958','vendor_961','verpackung_39173','verwendungszweck_36655','verwendungszweck_52782','verwendungszweck_52792','volumen_1461','volumen_1462','volumen_2366','volumen_43345','volumen_7546','volumen_der_tasse_40912','aroma_13960','aroma_17731','aroma_30995','aroma_4380','aroma_4973','aroma_53980','art_14447','art_22813','art_22815','art_22848','art_22921','art_23546','art_23722','art_30395','art_30648','art_30689','art_30692','art_33928','art_36991','art_37210','art_37849','art_37853','art_38567','art_38894','art_38895','art_40589','art_41081','art_53588','art_53590','art_53591','art_53766','art_54195','art_54284','art_54693','art_54698','art_55980','art_56004','art_56010','art_56254','art_56675','art_6091','art_der_beeren_56094','art_der_beeren_56097','art_der_beeren_56100','duft_31347','duft_36386','extract_53029','extract_53035','family_1015','family_1018','family_1019','family_1020','family_1022','family_1034','family_1043','family_1055','family_1066','family_1067','family_1099','family_1142','family_1144','family_1172','family_1223','family_1239','family_1246','family_1250','family_1251','family_1264','family_1265','family_1267','family_1271','family_1274','family_1287','family_1291','family_1292','family_255','family_866','farbgruppierung_586','fettanteil_52046','fettanteil_52300','fettanteil_52303','fettanteil_54188','fettanteil_54437','fettanteil_56070','fettanteil_56074','fettanteil_56076','fettanteil_56744','fischart_29658','fischart_29663','fischart_43277','fischart_52356','fischart_52490','fischart_53820','fischart_54516','fischart_56343','fischart_57014','fischart_57452','fuellung_39210','fuellung_39649','fuellung_51108','fuellung_51109','fuellung_52410','fuellung_52596','fuellung_52816','fuellung_54361','fuellung_54834','fuellung_55407','fuellung_56012','fuellung_56653','fuellung_56743','fuellung_57524','geschmack_24711','geschmack_36387','geschmack_39555','geschmack_42722','geschmack_45473','geschmack_46433','geschmack_47953','geschmack_51194','geschmack_54341','geschmack_54640','geschmack_54643','geschmack_54709','geschmack_54744','geschmack_54799','geschmack_56404','geschmack_56650','geschmack_56714','geschmack_57342','geschmack_57392','geschmack_57615','geschmack_57616','getreideart_38553','laenderkueche_36360','laenderkueche_36361','laenderkueche_43129','laenderkueche_43210','manufacturer_53919','manufacturer_55471','manufacturer_56717','manufacturer_56720','manufacturer_57095','modelname_52509','netto_fuellmenge_filter_7','netto_fuellmenge_filter_8','netto_gewicht_filter_10','pastete_sorten_50587','serie_39537','serie_39539','serie_39540','serie_45257','serie_52845','serie_54749','serie_55669','typ_33917','typ_37811','typ_54760','typ_7530','vendor_1000','vendor_1022','vendor_1032','vendor_1049','vendor_1063','vendor_1065','vendor_1072','vendor_1087','vendor_1091','vendor_1103','vendor_1124','vendor_1138','vendor_1140','vendor_1149','vendor_1162','vendor_118','vendor_1182','vendor_1186','vendor_1190','vendor_1208','vendor_1213','vendor_1224','vendor_1229','vendor_1234','vendor_1252','vendor_1283','vendor_1291','vendor_1299','vendor_1310','vendor_1322','vendor_1325','vendor_1326','vendor_1331','vendor_1340','vendor_1352','vendor_1354','vendor_1382','vendor_1387','vendor_139','vendor_141','vendor_1416','vendor_1417','vendor_1436','vendor_1441','vendor_1451','vendor_146','vendor_1460','vendor_1461','vendor_1474','vendor_1488','vendor_1491','vendor_1497','vendor_1506','vendor_1509','vendor_1514','vendor_1515','vendor_1524','vendor_1526','vendor_1530','vendor_1531','vendor_1532','vendor_1537','vendor_1541','vendor_1544','vendor_1548','vendor_1556','vendor_1557','vendor_1561','vendor_1562','vendor_1572','vendor_1579','vendor_1585','vendor_1586','vendor_1590','vendor_1592','vendor_1596','vendor_1617','vendor_1619','vendor_1620','vendor_1623','vendor_1633','vendor_187','vendor_203','vendor_204','vendor_230','vendor_232','vendor_235','vendor_236','vendor_240','vendor_256','vendor_261','vendor_271','vendor_280','vendor_282','vendor_291','vendor_305','vendor_313','vendor_336','vendor_348','vendor_353','vendor_383','vendor_408','vendor_409','vendor_437','vendor_442','vendor_446','vendor_448','vendor_473','vendor_481','vendor_484','vendor_508','vendor_513','vendor_518','vendor_521','vendor_558','vendor_565','vendor_566','vendor_570','vendor_580','vendor_581','vendor_617','vendor_635','vendor_649','vendor_677','vendor_695','vendor_699','vendor_715','vendor_717','vendor_750','vendor_757','vendor_758','vendor_779','vendor_786','vendor_832','vendor_835','vendor_845','vendor_872','vendor_880','vendor_884','vendor_886','vendor_893','vendor_901','vendor_902','vendor_904','vendor_906','vendor_908','vendor_915','vendor_919','vendor_929','vendor_937','vendor_964','vendor_968','vendor_981','vendor_983','vendor_987','verwendungszweck_2316','verwendungszweck_2721','verwendungszweck_32164','verwendungszweck_34356','verwendungszweck_4742','verwendungszweck_48981','verwendungszweck_5001','verwendungszweck_5053','verwendungszweck_53177','verwendungszweck_6042','verwendungszweck_6231','verwendungszweck_6232','verwendungszweck_7976','volumen_2368','volumen_2411','volumen_2463','volumen_3001','volumen_3283','volumen_3732','volumen_41815','volumen_4942','volumen_51890','volumen_56310','volumen_9140','volumen_9651','volumen_9913','weinart_53910') AND  a.is_filterable = true

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

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(
    'coolbox_filter_0',
    'freezebox_filter_3',
    'netto_gewicht_filter_3',
    'verpackung_2870',
    'netto_gewicht_filter_4',
    'netto_gewicht_filter_5',
    'art_2163',
    'freezebox_filter_2',
    'family_693',
    'verpackung_2954',
    'netto_gewicht_filter_2',
    'verpackung_4205',
    'netto_gewicht_filter_1',
    'coolbox_filter_1',
    'verpackung_3121',
    'netto_gewicht_filter_6',
    'verpackung_3948',
    'art_der_suessigkeiten_34384',
    'verpackung_35918',
    'fleischart_15470',
    'family_376',
    'vendor_531',
    'family_688',
    'verpackung_4003',
    'verpackung_37215',
    'handelsform_3535',
    'verpackung_36357',
    'geschmack_26932',
    'vendor_458',
    'laenderkueche_36352',
    'family_1072',
    'family_932',
    'verpackung_24689',
    'laenderkueche_36350',
    'family_1275',
    'art_25334',
    'handelsform_3534',
    'sorte_3536',
    'geschmack_23761',
    'family_1152',
    'vendor_386',
    'fleischart_15474',
    'fuellung_36388',
    'family_981',
    'family_1078',
    'vendor_196',
    'vendor_357',
    'geschmack_23757',
    'family_692',
    'geschmack_29765',
    'sorte_26188',
    'art_der_suessigkeiten_42806',
    'family_921',
    'geschmack_23765',
    'getreideart_15473',
    'netto_fuellmenge_filter_5',
    'verpackung_3840',
    'family_716',
    'geschmack_36384',
    'family_1073',
    'family_999',
    'family_922',
    'family_971',
    'art_15477',
    'art_39784',
    'fleischart_47539',
    'vendor_1232',
    'verpackung_5933',
    'family_684',
    'fuellung_36365',
    'verpackung_27725',
    'art_der_suessigkeiten_34102',
    'family_1002',
    'typ_36792',
    'verpackung_14402',
    'getreideart_25277',
    'laenderkueche_43012',
    'family_850',
    'vendor_1298',
    'art_56006',
    'geschmack_29768',
    'vendor_529',
    'family_724',
    'geschmack_23753',
    'geschmack_23781',
    'family_760',
    'art_56994',
    'art_der_suessigkeiten_39611',
    'family_1101',
    'family_1220',
    'geschmack_23759',
    'laenderkueche_36354',
    'family_980',
    'sorte_15484',
    'family_1211',
    'family_589',
    'family_687',
    'geschmack_26601',
    'handelsform_5934',
    'art_der_suessigkeiten_40017',
    'family_683',
    'teigwarenart_25243',
    'vendor_42',
    'handelsform_35601',
    'feiertage_819',
    'laenderkueche_36349',
    'family_1035',
    'vendor_380',
    'family_865',
    'vendor_114',
    'family_685',
    'fischart_29659',
    'geschmack_25688',
    'vendor_159',
    'verpackung_9455',
    'handelsform_5911',
    'vendor_231',
    'family_1213',
    'feiertage_960',
    'geschmack_36009',
    'art_54870',
    'vendor_1258',
    'art_30399',
    'art_der_suessigkeiten_46435',
    'family_1228',
    'family_577',
    'geschmack_23762',
    'netto_fuellmenge_filter_4',
    'vendor_1409',
    'vendor_156',
    'vendor_158',
    'verwendungszweck_4215',
    'family_1232',
    'family_880',
    'family_920',
    'getreideart_23707',
    'verwendungszweck_46428',
    'art_der_suessigkeiten_35208',
    'art_der_suessigkeiten_40018',
    'family_1026',
    'family_711',
    'geschmack_23756',
    'geschmack_23774',
    'family_594',
    'geschmack_24694',
    'fuellung_51141',
    'getreideart_23671',
    'vendor_1152',
    'vendor_150',
    'vendor_224',
    'family_689',
    'fuellung_39590',
    'art_29786',
    'art_56995',
    'art_der_suessigkeiten_36995',
    'feiertage_820',
    'geschmack_42730',
    'vendor_216',
    'fischart_29660',
    'vendor_482',
    'vendor_716',
    'art_51799',
    'geschmack_23778',
    'getreideart_15476',
    'vendor_135',
    'vendor_198',
    'art_29787',
    'family_1212',
    'family_1241',
    'feiertage_1130',
    'typ_26962',
    'vendor_1395',
    'art_55439',
    'art_56940',
    'family_1286',
    'family_418',
    'geschmack_23770',
    'vendor_1135',
    'vendor_752',
    'family_1044',
    'fleischart_47119',
    'fuellung_46951',
    'fuellung_51117',
    'netto_gewicht_filter_7',
    'vendor_1313',
    'vendor_404',
    'vendor_923',
    'verpackung_3653',
    'art_der_suessigkeiten_39960',
    'family_1168',
    'family_462',
    'fischart_29740',
    'geschmack_35867',
    'vendor_1016',
    'anzahl_der_portionen_35937',
    'getreideart_23711',
    'vendor_895',
    'verpackung_26798',
    'art_54139',
    'art_der_suessigkeiten_56942',
    'family_1231',
    'family_771',
    'fischart_29998',
    'geschmack_52741',
    'handelsform_27113',
    'netto_fuellmenge_filter_3',
    'vendor_881',
    'verpackung_38799',
    'verpackung_42548',
    'art_56007',
    'fettanteil_52859',
    'geschmack_23755',
    'modelname_40223',
    'vendor_1179',
    'vendor_179',
    'vendor_221',
    'vendor_489',
    'art_54631',
    'family_1049',
    'family_1065',
    'family_1080',
    'family_1234',
    'family_691',
    'family_867',
    'laenderkueche_50808',
    'vendor_134',
    'vendor_1377',
    'vendor_860',
    'vendor_938',
    'art_27151',
    'family_1027',
    'family_1114',
    'family_1210',
    'family_1233',
    'family_629',
    'family_682',
    'family_973',
    'family_986',
    'fischart_37803',
    'fischart_54823',
    'geschmack_23747',
    'geschmack_26600',
    'geschmack_39591',
    'geschmack_43102',
    'serie_44880',
    'serie_51387',
    'typ_23685',
    'vendor_1521',
    'vendor_165',
    'vendor_922',
    'art_57036',
    'art_der_suessigkeiten_40113',
    'family_778',
    'geschmack_23764',
    'vendor_1027',
    'vendor_1292',
    'vendor_1348',
    'vendor_1373',
    'vendor_186',
    'vendor_381',
    'vendor_424',
    'vendor_725',
    'vendor_762',
    'art_29791',
    'art_54697',
    'family_1054',
    'family_1118',
    'family_789',
    'family_854',
    'family_975',
    'family_978',
    'fischart_29999',
    'fischart_36125',
    'fuellung_51115',
    'geschmack_23776',
    'geschmack_26612',
    'geschmack_32270',
    'manufacturer_53914',
    'vendor_679',
    'vendor_897',
    'vendor_944',
    'verpackung_3154',
    'verwendungszweck_2755',
    'volumen_2424',
    'art_23066',
    'art_54632',
    'art_55436',
    'family_1028',
    'family_441',
    'family_935',
    'geschmack_23763',
    'geschmack_36938',
    'getreideart_15480',
    'getreideart_15481',
    'handelsform_6235',
    'teigwarenart_38803',
    'vendor_1028',
    'vendor_1191',
    'vendor_1330',
    'vendor_1412',
    'vendor_1593',
    'vendor_751',
    'verpackung_4977',
    'verwendungszweck_5081',
    'verwendungszweck_7957',
    'anwendungszeit_2288',
    'art_51800',
    'art_56939',
    'family_1077',
    'family_699',
    'family_886',
    'family_977',
    'fischart_35526',
    'fischart_38548',
    'fuellung_52550',
    'fuellung_53397',
    'sorte_51687',
    'typ_27609',
    'typ_35555',
    'vendor_1214',
    'vendor_1216',
    'vendor_1228',
    'vendor_1317',
    'vendor_1374',
    'vendor_162',
    'vendor_171',
    'vendor_402',
    'vendor_499',
    'vendor_834',
    'aroma_3539',
    'art_29796',
    'art_37185',
    'family_1129',
    'family_1260',
    'family_1280',
    'family_754',
    'fischart_43299',
    'fuellung_36847',
    'fuellung_54431',
    'geschmack_23775',
    'geschmack_24687',
    'geschmack_36380',
    'sorte_7952',
    'vendor_1462',
    'vendor_149',
    'vendor_486',
    'vendor_759',
    'vendor_962',
    'verpackung_3609',
    'weinart_53885',
    'aroma_7551',
    'art_36372',
    'art_39785',
    'family_1000',
    'family_690',
    'fettanteil_54147',
    'fischart_37812',
    'fuellung_51760',
    'geschmack_23749',
    'geschmack_23766',
    'geschmack_31753',
    'geschmack_35745',
    'laenderkueche_36355',
    'netto_fuellmenge_filter_2',
    'pastete_sorten_29724',
    'pastete_sorten_29725',
    'serie_39543',
    'vendor_1031',
    'vendor_1226',
    'vendor_1255',
    'vendor_1476',
    'vendor_413',
    'vendor_477',
    'vendor_511',
    'vendor_553',
    'vendor_721',
    'vendor_724',
    'vendor_728',
    'art_39778',
    'art_53069',
    'art_54199',
    'family_1102',
    'family_1106',
    'family_1167',
    'family_1215',
    'family_1219',
    'family_752',
    'feiertage_825',
    'fuellung_39832',
    'geschmack_23779',
    'geschmack_26602',
    'geschmack_26929',
    'geschmack_36155',
    'geschmack_53621',
    'getreideart_23709',
    'laenderkueche_43013',
    'serie_39534',
    'typ_34174',
    'vendor_1113',
    'vendor_1383',
    'vendor_177',
    'vendor_192',
    'vendor_309',
    'vendor_579',
    'vendor_637',
    'vendor_914',
    'vendor_960',
    'verpackung_6308',
    'anzahl_der_portionen_35938',
    'aroma_3546',
    'art_23067',
    'art_7540',
    'family_1169',
    'family_976',
    'fleischart_30153',
    'fuellung_39485',
    'fuellung_39488',
    'geschmack_23783',
    'geschmack_45116',
    'geschmack_51195',
    'serie_55241',
    'sorte_39243',
    'vendor_111',
    'vendor_1125',
    'vendor_1173',
    'vendor_1296',
    'vendor_1316',
    'vendor_140',
    'vendor_1507',
    'vendor_227',
    'vendor_743',
    'vendor_954',
    'vendor_989',
    'verwendungszweck_2752',
    'verwendungszweck_35606',
    'volumen_1460',
    'altergruppierung_54019',
    'altergruppierung_6272',
    'anzahl_der_artikel_2679',
    'art_23723',
    'art_37143',
    'art_56221',
    'art_der_beeren_53100',
    'family_1226',
    'family_686',
    'family_756',
    'family_769',
    'family_770',
    'feiertage_821',
    'feiertage_826',
    'fettanteil_53700',
    'fischart_43325',
    'fuellung_39647',
    'fuellung_39651',
    'fuellung_51842',
    'fuellung_52241',
    'geschmack_23754',
    'geschmack_26611',
    'geschmack_26964',
    'geschmack_36921',
    'geschmack_38999',
    'geschmack_39836',
    'geschmack_39953',
    'pastete_sorten_29718',
    'serie_53575',
    'vendor_1015',
    'vendor_1070',
    'vendor_1133',
    'vendor_1153',
    'vendor_1158',
    'vendor_1218',
    'vendor_1318',
    'vendor_1422',
    'vendor_1466',
    'vendor_1472',
    'vendor_1508',
    'vendor_1540',
    'vendor_1598',
    'vendor_414',
    'vendor_430',
    'vendor_441',
    'vendor_449',
    'vendor_457',
    'vendor_552',
    'vendor_639',
    'vendor_641',
    'vendor_681',
    'vendor_755',
    'vendor_862',
    'vendor_991',
    'verwendungszweck_6088',
    'art_33908',
    'art_35238',
    'art_37170',
    'art_54194',
    'family_1009',
    'family_1031',
    'family_1074',
    'family_1214',
    'family_757',
    'family_974',
    'feiertage_823',
    'fettanteil_51891',
    'fuellung_29777',
    'fuellung_36364',
    'fuellung_52846',
    'geschmack_23758',
    'geschmack_23782',
    'geschmack_36940',
    'geschmack_54329',
    'getreideart_15482',
    'sorte_45806',
    'teigwarenart_25246',
    'vendor_1104',
    'vendor_1106',
    'vendor_116',
    'vendor_1240',
    'vendor_1328',
    'vendor_1372',
    'vendor_1394',
    'vendor_1406',
    'vendor_1433',
    'vendor_1459',
    'vendor_1464',
    'vendor_1496',
    'vendor_1529',
    'vendor_1545',
    'vendor_178',
    'vendor_267',
    'vendor_431',
    'vendor_533',
    'vendor_772',
    'verpackung_31703',
    'verwendungszweck_135',
    'anzahl_der_portionen_50815',
    'aroma_55191',
    'art_14443',
    'art_35236',
    'art_39627',
    'art_52277',
    'art_53592',
    'art_54630',
    'art_54638',
    'art_56253',
    'art_der_beeren_53103',
    'family_1032',
    'family_1033',
    'family_697',
    'family_773',
    'family_972',
    'fischart_29664',
    'fischart_54769',
    'fuellung_42734',
    'fuellung_51125',
    'fuellung_51170',
    'fuellung_51734',
    'fuellung_55934',
    'geschlecht_65',
    'geschmack_23760',
    'geschmack_26605',
    'geschmack_39002',
    'geschmack_39945',
    'grossen_38388',
    'materialgruppierung_33495',
    'netto_gewicht_filter_9',
    'serie_34905',
    'serie_54773',
    'typ_55466',
    'vendor_1025',
    'vendor_1165',
    'vendor_1187',
    'vendor_1205',
    'vendor_1289',
    'vendor_1297',
    'vendor_1337',
    'vendor_1376',
    'vendor_1483',
    'vendor_1495',
    'vendor_153',
    'vendor_1549',
    'vendor_1582',
    'vendor_1595',
    'vendor_274',
    'vendor_277',
    'vendor_537',
    'vendor_554',
    'vendor_608',
    'vendor_685',
    'vendor_785',
    'vendor_852',
    'vendor_861',
    'vendor_869',
    'vendor_924',
    'vendor_980',
    'verpackung_45261',
    'verpackung_46731',
    'verwendungszweck_17979',
    'verwendungszweck_2256',
    'verwendungszweck_29892',
    'verwendungszweck_41370',
    'aroma_26886',
    'aroma_4227',
    'aroma_4975',
    'aroma_4976',
    'art_36368',
    'art_37171',
    'art_37854',
    'art_54635',
    'art_54694',
    'art_54695',
    'art_55179',
    'art_56419',
    'art_der_beeren_53566',
    'art_der_beeren_54072',
    'art_der_beeren_54397',
    'extract_53040',
    'family_1120',
    'family_1131',
    'family_1229',
    'family_1249',
    'family_755',
    'fettanteil_43969',
    'fettanteil_52040',
    'fischart_43320',
    'fischart_43337',
    'fischart_52914',
    'fuellung_52898',
    'geschlecht_66',
    'geschmack_36935',
    'geschmack_44672',
    'geschmack_51196',
    'geschmack_54650',
    'laenderkueche_51124',
    'manufacturer_53916',
    'manufacturer_57302',
    'serie_36417',
    'serie_44736',
    'teigwarenart_25230',
    'typ_48885',
    'vendor_1018',
    'vendor_1160',
    'vendor_1207',
    'vendor_1342',
    'vendor_1350',
    'vendor_1410',
    'vendor_1435',
    'vendor_1455',
    'vendor_1456',
    'vendor_1555',
    'vendor_1588',
    'vendor_1597',
    'vendor_1606',
    'vendor_166',
    'vendor_170',
    'vendor_316',
    'vendor_405',
    'vendor_432',
    'vendor_438',
    'vendor_519',
    'vendor_528',
    'vendor_621',
    'vendor_984',
    'verwendungszweck_6536',
    'verwendungszweck_9603',
    'volumen_2365',
    'weinart_53876',
    'aroma_13964',
    'aroma_17796',
    'aroma_23887',
    'aroma_23893',
    'art_22870',
    'art_22876',
    'art_29788',
    'art_29790',
    'art_29792',
    'art_41586',
    'art_51126',
    'art_54141',
    'art_54633',
    'art_54637',
    'art_54715',
    'art_der_beeren_53106',
    'art_der_beeren_56092',
    'extract_53033',
    'family_1021',
    'family_1030',
    'family_1036',
    'family_1046',
    'family_1100',
    'family_1128',
    'family_1176',
    'family_1209',
    'family_1227',
    'family_1238',
    'family_1240',
    'family_1254',
    'family_1269',
    'family_1270',
    'family_1273',
    'family_526',
    'family_926',
    'farbgruppierung_579',
    'fettanteil_52035',
    'fettanteil_52299',
    'fischart_29661',
    'fischart_37804',
    'fleischart_15475',
    'fleischart_54883',
    'fleischart_54889',
    'fuellung_51114',
    'fuellung_55175',
    'geschmack_23771',
    'geschmack_23777',
    'geschmack_26604',
    'geschmack_36669',
    'geschmack_36851',
    'geschmack_46434',
    'geschmack_53803',
    'getreideart_23708',
    'laenderkueche_47654',
    'laenderkueche_48797',
    'manufacturer_55474',
    'netto_fuellmenge_filter_6',
    'netto_gewicht_filter_8',
    'serie_33808',
    'serie_37454',
    'serie_41382',
    'serie_51965',
    'serie_55386',
    'teigwarenart_25229',
    'teigwarenart_56421',
    'typ_55388',
    'vendor_1054',
    'vendor_1119',
    'vendor_1146',
    'vendor_1157',
    'vendor_1206',
    'vendor_1261',
    'vendor_1277',
    'vendor_1300',
    'vendor_1311',
    'vendor_1355',
    'vendor_1357',
    'vendor_1380',
    'vendor_1385',
    'vendor_1450',
    'vendor_1457',
    'vendor_1481',
    'vendor_152',
    'vendor_1534',
    'vendor_154',
    'vendor_1542',
    'vendor_1563',
    'vendor_1567',
    'vendor_1568',
    'vendor_1621',
    'vendor_164',
    'vendor_181',
    'vendor_265',
    'vendor_444',
    'vendor_500',
    'vendor_535',
    'vendor_538',
    'vendor_547',
    'vendor_582',
    'vendor_642',
    'vendor_644',
    'vendor_738',
    'vendor_767',
    'vendor_770',
    'vendor_851',
    'vendor_855',
    'vendor_873',
    'vendor_896',
    'vendor_909',
    'vendor_910',
    'vendor_928',
    'vendor_967',
    'vendor_972',
    'vendor_979',
    'verwendungszweck_2248',
    'verwendungszweck_6827',
    'volumen_37380',
    'weinart_53872',
    'anwendungszeit_9771',
    'aroma_13957',
    'aroma_24235',
    'art_22724',
    'art_22832',
    'art_22836',
    'art_30396',
    'art_30632',
    'art_30649',
    'art_30666',
    'art_33919',
    'art_54198',
    'art_54636',
    'art_54739',
    'art_55667',
    'art_56215',
    'art_56255',
    'art_56257',
    'art_57225',
    'art_der_beeren_54286',
    'art_der_beeren_54717',
    'art_der_suessigkeiten_39991',
    'extract_53002',
    'family_1024',
    'family_1045',
    'family_1075',
    'family_1225',
    'family_1253',
    'family_1262',
    'family_1266',
    'family_1279',
    'family_695',
    'family_759',
    'family_868',
    'feiertage_822',
    'fuellung_51140',
    'fuellung_51969',
    'fuellung_52598',
    'fuellung_54104',
    'fuellung_54798',
    'fuellung_55875',
    'geschmack_26599',
    'geschmack_26607',
    'geschmack_36932',
    'geschmack_37738',
    'geschmack_42691',
    'geschmack_53895',
    'geschmack_54213',
    'geschmack_56818',
    'getreideart_25279',
    'getreideart_38595',
    'handelsform_5910',
    'manufacturer_57065',
    'netto_gewicht_filter_11',
    'netto_gewicht_filter_13',
    'serie_39536',
    'serie_39538',
    'serie_55666',
    'sorte_19469',
    'typ_16198',
    'vendor_1007',
    'vendor_1020',
    'vendor_1033',
    'vendor_1037',
    'vendor_1055',
    'vendor_1107',
    'vendor_1195',
    'vendor_1241',
    'vendor_1247',
    'vendor_1254',
    'vendor_1260',
    'vendor_1302',
    'vendor_1307',
    'vendor_1309',
    'vendor_1312',
    'vendor_1319',
    'vendor_1371',
    'vendor_1375',
    'vendor_1378',
    'vendor_138',
    'vendor_1386',
    'vendor_1423',
    'vendor_143',
    'vendor_1458',
    'vendor_1477',
    'vendor_1482',
    'vendor_1486',
    'vendor_1487',
    'vendor_1492',
    'vendor_1494',
    'vendor_1505',
    'vendor_151',
    'vendor_1520',
    'vendor_1527',
    'vendor_1528',
    'vendor_1535',
    'vendor_1543',
    'vendor_1554',
    'vendor_157',
    'vendor_1578',
    'vendor_1580',
    'vendor_1581',
    'vendor_1587',
    'vendor_1605',
    'vendor_1624',
    'vendor_223',
    'vendor_225',
    'vendor_251',
    'vendor_295',
    'vendor_296',
    'vendor_346',
    'vendor_403',
    'vendor_406',
    'vendor_459',
    'vendor_490',
    'vendor_527',
    'vendor_573',
    'vendor_577',
    'vendor_609',
    'vendor_630',
    'vendor_744',
    'vendor_814',
    'vendor_883',
    'vendor_946',
    'vendor_992',
    'verwendungszweck_16237',
    'verwendungszweck_2240',
    'verwendungszweck_34164',
    'verwendungszweck_35571',
    'verwendungszweck_6814',
    'volumen_32280',
    'volumen_41001',
    'volumen_41002',
    'volumen_5235',
    'weinart_57300',
    'anzahl_der_artikel_2680',
    'anzahl_der_portionen_35920',
    'anzahl_der_portionen_35933',
    'aroma_11395',
    'aroma_17795',
    'aroma_22670',
    'aroma_39184',
    'aroma_39201',
    'aroma_4224',
    'aroma_4974',
    'aroma_6917',
    'art_15478',
    'art_22663',
    'art_22806',
    'art_22810',
    'art_22844',
    'art_22868',
    'art_29789',
    'art_30630',
    'art_30684',
    'art_36390',
    'art_40602',
    'art_51286',
    'art_54105',
    'art_54140',
    'art_54455',
    'art_54738',
    'art_55008',
    'art_56993',
    'art_57203',
    'art_der_beeren_54004',
    'art_der_beeren_56099',
    'art_der_suessigkeiten_52757',
    'extract_53001',
    'extract_53015',
    'family_1011',
    'family_1016',
    'family_1023',
    'family_1115',
    'family_1259',
    'family_723',
    'family_758',
    'family_858',
    'family_936',
    'farbgruppierung_578',
    'fettanteil_53325',
    'fettanteil_54814',
    'fettanteil_55626',
    'fettanteil_55845',
    'fettanteil_56075',
    'fischart_29665',
    'fischart_43293',
    'fischart_45346',
    'fischart_52492',
    'fischart_52858',
    'fischart_55177',
    'fischart_57425',
    'fuellung_36367',
    'fuellung_39661',
    'fuellung_55123',
    'fuellung_55170',
    'fuellung_55284',
    'fuellung_55786',
    'geschmack_23748',
    'geschmack_23769',
    'geschmack_26329',
    'geschmack_29525',
    'geschmack_36381',
    'geschmack_39167',
    'geschmack_42774',
    'geschmack_45977',
    'geschmack_51197',
    'geschmack_54330',
    'geschmack_54443',
    'geschmack_54962',
    'getreideart_25278',
    'handelsform_27518',
    'handelsform_35599',
    'laenderkueche_36351',
    'laenderkueche_36353',
    'laenderkueche_43127',
    'manufacturer_53918',
    'manufacturer_55475',
    'manufacturer_56718',
    'manufacturer_56721',
    'manufacturer_56723',
    'manufacturer_57094',
    'pastete_sorten_29726',
    'serie_32988',
    'serie_53680',
    'sorte_27412',
    'sorte_39254',
    'typ_33892',
    'typ_40821',
    'vendor_1035',
    'vendor_1048',
    'vendor_1051',
    'vendor_1064',
    'vendor_1077',
    'vendor_1085',
    'vendor_1088',
    'vendor_1112',
    'vendor_1114',
    'vendor_112',
    'vendor_1121',
    'vendor_1145',
    'vendor_1147',
    'vendor_1181',
    'vendor_1197',
    'vendor_1215',
    'vendor_125',
    'vendor_1276',
    'vendor_1281',
    'vendor_1293',
    'vendor_1315',
    'vendor_1327',
    'vendor_1333',
    'vendor_1346',
    'vendor_1347',
    'vendor_1379',
    'vendor_1381',
    'vendor_1388',
    'vendor_1390',
    'vendor_1414',
    'vendor_1432',
    'vendor_144',
    'vendor_1440',
    'vendor_1449',
    'vendor_1463',
    'vendor_1465',
    'vendor_1470',
    'vendor_1478',
    'vendor_1479',
    'vendor_1484',
    'vendor_1512',
    'vendor_1522',
    'vendor_1533',
    'vendor_1536',
    'vendor_1546',
    'vendor_1547',
    'vendor_1552',
    'vendor_1558',
    'vendor_1575',
    'vendor_1577',
    'vendor_1591',
    'vendor_1610',
    'vendor_1612',
    'vendor_1618',
    'vendor_1629',
    'vendor_1631',
    'vendor_1634',
    'vendor_200',
    'vendor_207',
    'vendor_248',
    'vendor_259',
    'vendor_347',
    'vendor_412',
    'vendor_467',
    'vendor_514',
    'vendor_534',
    'vendor_551',
    'vendor_636',
    'vendor_664',
    'vendor_665',
    'vendor_666',
    'vendor_678',
    'vendor_689',
    'vendor_700',
    'vendor_745',
    'vendor_821',
    'vendor_836',
    'vendor_850',
    'vendor_907',
    'vendor_956',
    'vendor_958',
    'vendor_961',
    'verpackung_39173',
    'verwendungszweck_36655',
    'verwendungszweck_52782',
    'verwendungszweck_52792',
    'volumen_1461',
    'volumen_1462',
    'volumen_2366',
    'volumen_43345',
    'volumen_7546',
    'volumen_der_tasse_40912',
    'aroma_13960',
    'aroma_17731',
    'aroma_30995',
    'aroma_4380',
    'aroma_4973',
    'aroma_53980',
    'art_14447',
    'art_22813',
    'art_22815',
    'art_22848',
    'art_22921',
    'art_23546',
    'art_23722',
    'art_30395',
    'art_30648',
    'art_30689',
    'art_30692',
    'art_33928',
    'art_36991',
    'art_37210',
    'art_37849',
    'art_37853',
    'art_38567',
    'art_38894',
    'art_38895',
    'art_40589',
    'art_41081',
    'art_53588',
    'art_53590',
    'art_53591',
    'art_53766',
    'art_54195',
    'art_54284',
    'art_54693',
    'art_54698',
    'art_55980',
    'art_56004',
    'art_56010',
    'art_56254',
    'art_56675',
    'art_6091',
    'art_der_beeren_56094',
    'art_der_beeren_56097',
    'art_der_beeren_56100',
    'duft_31347',
    'duft_36386',
    'extract_53029',
    'extract_53035',
    'family_1015',
    'family_1018',
    'family_1019',
    'family_1020',
    'family_1022',
    'family_1034',
    'family_1043',
    'family_1055',
    'family_1066',
    'family_1067',
    'family_1099',
    'family_1142',
    'family_1144',
    'family_1172',
    'family_1223',
    'family_1239',
    'family_1246',
    'family_1250',
    'family_1251',
    'family_1264',
    'family_1265',
    'family_1267',
    'family_1271',
    'family_1274',
    'family_1287',
    'family_1291',
    'family_1292',
    'family_255',
    'family_866',
    'farbgruppierung_586',
    'fettanteil_52046',
    'fettanteil_52300',
    'fettanteil_52303',
    'fettanteil_54188',
    'fettanteil_54437',
    'fettanteil_56070',
    'fettanteil_56074',
    'fettanteil_56076',
    'fettanteil_56744',
    'fischart_29658',
    'fischart_29663',
    'fischart_43277',
    'fischart_52356',
    'fischart_52490',
    'fischart_53820',
    'fischart_54516',
    'fischart_56343',
    'fischart_57014',
    'fischart_57452',
    'fuellung_39210',
    'fuellung_39649',
    'fuellung_51108',
    'fuellung_51109',
    'fuellung_52410',
    'fuellung_52596',
    'fuellung_52816',
    'fuellung_54361',
    'fuellung_54834',
    'fuellung_55407',
    'fuellung_56012',
    'fuellung_56653',
    'fuellung_56743',
    'fuellung_57524',
    'geschmack_24711',
    'geschmack_36387',
    'geschmack_39555',
    'geschmack_42722',
    'geschmack_45473',
    'geschmack_46433',
    'geschmack_47953',
    'geschmack_51194',
    'geschmack_54341',
    'geschmack_54640',
    'geschmack_54643',
    'geschmack_54709',
    'geschmack_54744',
    'geschmack_54799',
    'geschmack_56404',
    'geschmack_56650',
    'geschmack_56714',
    'geschmack_57342',
    'geschmack_57392',
    'geschmack_57615',
    'geschmack_57616',
    'getreideart_38553',
    'laenderkueche_36360',
    'laenderkueche_36361',
    'laenderkueche_43129',
    'laenderkueche_43210',
    'manufacturer_53919',
    'manufacturer_55471',
    'manufacturer_56717',
    'manufacturer_56720',
    'manufacturer_57095',
    'modelname_52509',
    'netto_fuellmenge_filter_7',
    'netto_fuellmenge_filter_8',
    'netto_gewicht_filter_10',
    'pastete_sorten_50587',
    'serie_39537',
    'serie_39539',
    'serie_39540',
    'serie_45257',
    'serie_52845',
    'serie_54749',
    'serie_55669',
    'typ_33917',
    'typ_37811',
    'typ_54760',
    'typ_7530',
    'vendor_1000',
    'vendor_1022',
    'vendor_1032',
    'vendor_1049',
    'vendor_1063',
    'vendor_1065',
    'vendor_1072',
    'vendor_1087',
    'vendor_1091',
    'vendor_1103',
    'vendor_1124',
    'vendor_1138',
    'vendor_1140',
    'vendor_1149',
    'vendor_1162',
    'vendor_118',
    'vendor_1182',
    'vendor_1186',
    'vendor_1190',
    'vendor_1208',
    'vendor_1213',
    'vendor_1224',
    'vendor_1229',
    'vendor_1234',
    'vendor_1252',
    'vendor_1283',
    'vendor_1291',
    'vendor_1299',
    'vendor_1310',
    'vendor_1322',
    'vendor_1325',
    'vendor_1326',
    'vendor_1331',
    'vendor_1340',
    'vendor_1352',
    'vendor_1354',
    'vendor_1382',
    'vendor_1387',
    'vendor_139',
    'vendor_141',
    'vendor_1416',
    'vendor_1417',
    'vendor_1436',
    'vendor_1441',
    'vendor_1451',
    'vendor_146',
    'vendor_1460',
    'vendor_1461',
    'vendor_1474',
    'vendor_1488',
    'vendor_1491',
    'vendor_1497',
    'vendor_1506',
    'vendor_1509',
    'vendor_1514',
    'vendor_1515',
    'vendor_1524',
    'vendor_1526',
    'vendor_1530',
    'vendor_1531',
    'vendor_1532',
    'vendor_1537',
    'vendor_1541',
    'vendor_1544',
    'vendor_1548',
    'vendor_1556',
    'vendor_1557',
    'vendor_1561',
    'vendor_1562',
    'vendor_1572',
    'vendor_1579',
    'vendor_1585',
    'vendor_1586',
    'vendor_1590',
    'vendor_1592',
    'vendor_1596',
    'vendor_1617',
    'vendor_1619',
    'vendor_1620',
    'vendor_1623',
    'vendor_1633',
    'vendor_187',
    'vendor_203',
    'vendor_204',
    'vendor_230',
    'vendor_232',
    'vendor_235',
    'vendor_236',
    'vendor_240',
    'vendor_256',
    'vendor_261',
    'vendor_271',
    'vendor_280',
    'vendor_282',
    'vendor_291',
    'vendor_305',
    'vendor_313',
    'vendor_336',
    'vendor_348',
    'vendor_353',
    'vendor_383',
    'vendor_408',
    'vendor_409',
    'vendor_437',
    'vendor_442',
    'vendor_446',
    'vendor_448',
    'vendor_473',
    'vendor_481',
    'vendor_484',
    'vendor_508',
    'vendor_513',
    'vendor_518',
    'vendor_521',
    'vendor_558',
    'vendor_565',
    'vendor_566',
    'vendor_570',
    'vendor_580',
    'vendor_581',
    'vendor_617',
    'vendor_635',
    'vendor_649',
    'vendor_677',
    'vendor_695',
    'vendor_699',
    'vendor_715',
    'vendor_717',
    'vendor_750',
    'vendor_757',
    'vendor_758',
    'vendor_779',
    'vendor_786',
    'vendor_832',
    'vendor_835',
    'vendor_845',
    'vendor_872',
    'vendor_880',
    'vendor_884',
    'vendor_886',
    'vendor_893',
    'vendor_901',
    'vendor_902',
    'vendor_904',
    'vendor_906',
    'vendor_908',
    'vendor_915',
    'vendor_919',
    'vendor_929',
    'vendor_937',
    'vendor_964',
    'vendor_968',
    'vendor_981',
    'vendor_983',
    'vendor_987',
    'verwendungszweck_2316',
    'verwendungszweck_2721',
    'verwendungszweck_32164',
    'verwendungszweck_34356',
    'verwendungszweck_4742',
    'verwendungszweck_48981',
    'verwendungszweck_5001',
    'verwendungszweck_5053',
    'verwendungszweck_53177',
    'verwendungszweck_6042',
    'verwendungszweck_6231',
    'verwendungszweck_6232',
    'verwendungszweck_7976',
    'volumen_2368',
    'volumen_2411',
    'volumen_2463',
    'volumen_3001',
    'volumen_3283',
    'volumen_3732',
    'volumen_41815',
    'volumen_4942',
    'volumen_51890',
    'volumen_56310',
    'volumen_9140',
    'volumen_9651',
    'volumen_9913',
    'weinart_53910'
  )
  AND a.is_filterable = true

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('coolbox_filter_0','freezebox_filter_3','netto_gewicht_filter_3','verpackung_2870','netto_gewicht_filter_4','netto_gewicht_filter_5','art_2163','freezebox_filter_2','family_693','verpackung_2954','netto_gewicht_filter_2','verpackung_4205','netto_gewicht_filter_1','coolbox_filter_1','verpackung_3121','netto_gewicht_filter_6','verpackung_3948','art_der_suessigkeiten_34384','verpackung_35918','fleischart_15470','family_376','vendor_531','family_688','verpackung_4003','verpackung_37215','handelsform_3535','verpackung_36357','geschmack_26932','vendor_458','laenderkueche_36352','family_1072','family_932','verpackung_24689','laenderkueche_36350','family_1275','art_25334','handelsform_3534','sorte_3536','geschmack_23761','family_1152','vendor_386','fleischart_15474','fuellung_36388','family_981','family_1078','vendor_196','vendor_357','geschmack_23757','family_692','geschmack_29765','sorte_26188','art_der_suessigkeiten_42806','family_921','geschmack_23765','getreideart_15473','netto_fuellmenge_filter_5','verpackung_3840','family_716','geschmack_36384','family_1073','family_999','family_922','family_971','art_15477','art_39784','fleischart_47539','vendor_1232','verpackung_5933','family_684','fuellung_36365','verpackung_27725','art_der_suessigkeiten_34102','family_1002','typ_36792','verpackung_14402','getreideart_25277','laenderkueche_43012','family_850','vendor_1298','art_56006','geschmack_29768','vendor_529','family_724','geschmack_23753','geschmack_23781','family_760','art_56994','art_der_suessigkeiten_39611','family_1101','family_1220','geschmack_23759','laenderkueche_36354','family_980','sorte_15484','family_1211','family_589','family_687','geschmack_26601','handelsform_5934','art_der_suessigkeiten_40017','family_683','teigwarenart_25243','vendor_42','handelsform_35601','feiertage_819','laenderkueche_36349','family_1035','vendor_380','family_865','vendor_114','family_685','fischart_29659','geschmack_25688','vendor_159','verpackung_9455','handelsform_5911','vendor_231','family_1213','feiertage_960','geschmack_36009','art_54870','vendor_1258','art_30399','art_der_suessigkeiten_46435','family_1228','family_577','geschmack_23762','netto_fuellmenge_filter_4','vendor_1409','vendor_156','vendor_158','verwendungszweck_4215','family_1232','family_880','family_920','getreideart_23707','verwendungszweck_46428','art_der_suessigkeiten_35208','art_der_suessigkeiten_40018','family_1026','family_711','geschmack_23756','geschmack_23774','family_594','geschmack_24694','fuellung_51141','getreideart_23671','vendor_1152','vendor_150','vendor_224','family_689','fuellung_39590','art_29786','art_56995','art_der_suessigkeiten_36995','feiertage_820','geschmack_42730','vendor_216','fischart_29660','vendor_482','vendor_716','art_51799','geschmack_23778','getreideart_15476','vendor_135','vendor_198','art_29787','family_1212','family_1241','feiertage_1130','typ_26962','vendor_1395','art_55439','art_56940','family_1286','family_418','geschmack_23770','vendor_1135','vendor_752','family_1044','fleischart_47119','fuellung_46951','fuellung_51117','netto_gewicht_filter_7','vendor_1313','vendor_404','vendor_923','verpackung_3653','art_der_suessigkeiten_39960','family_1168','family_462','fischart_29740','geschmack_35867','vendor_1016','anzahl_der_portionen_35937','getreideart_23711','vendor_895','verpackung_26798','art_54139','art_der_suessigkeiten_56942','family_1231','family_771','fischart_29998','geschmack_52741','handelsform_27113','netto_fuellmenge_filter_3','vendor_881','verpackung_38799','verpackung_42548','art_56007','fettanteil_52859','geschmack_23755','modelname_40223','vendor_1179','vendor_179','vendor_221','vendor_489','art_54631','family_1049','family_1065','family_1080','family_1234','family_691','family_867','laenderkueche_50808','vendor_134','vendor_1377','vendor_860','vendor_938','art_27151','family_1027','family_1114','family_1210','family_1233','family_629','family_682','family_973','family_986','fischart_37803','fischart_54823','geschmack_23747','geschmack_26600','geschmack_39591','geschmack_43102','serie_44880','serie_51387','typ_23685','vendor_1521','vendor_165','vendor_922','art_57036','art_der_suessigkeiten_40113','family_778','geschmack_23764','vendor_1027','vendor_1292','vendor_1348','vendor_1373','vendor_186','vendor_381','vendor_424','vendor_725','vendor_762','art_29791','art_54697','family_1054','family_1118','family_789','family_854','family_975','family_978','fischart_29999','fischart_36125','fuellung_51115','geschmack_23776','geschmack_26612','geschmack_32270','manufacturer_53914','vendor_679','vendor_897','vendor_944','verpackung_3154','verwendungszweck_2755','volumen_2424','art_23066','art_54632','art_55436','family_1028','family_441','family_935','geschmack_23763','geschmack_36938','getreideart_15480','getreideart_15481','handelsform_6235','teigwarenart_38803','vendor_1028','vendor_1191','vendor_1330','vendor_1412','vendor_1593','vendor_751','verpackung_4977','verwendungszweck_5081','verwendungszweck_7957','anwendungszeit_2288','art_51800','art_56939','family_1077','family_699','family_886','family_977','fischart_35526','fischart_38548','fuellung_52550','fuellung_53397','sorte_51687','typ_27609','typ_35555','vendor_1214','vendor_1216','vendor_1228','vendor_1317','vendor_1374','vendor_162','vendor_171','vendor_402','vendor_499','vendor_834','aroma_3539','art_29796','art_37185','family_1129','family_1260','family_1280','family_754','fischart_43299','fuellung_36847','fuellung_54431','geschmack_23775','geschmack_24687','geschmack_36380','sorte_7952','vendor_1462','vendor_149','vendor_486','vendor_759','vendor_962','verpackung_3609','weinart_53885','aroma_7551','art_36372','art_39785','family_1000','family_690','fettanteil_54147','fischart_37812','fuellung_51760','geschmack_23749','geschmack_23766','geschmack_31753','geschmack_35745','laenderkueche_36355','netto_fuellmenge_filter_2','pastete_sorten_29724','pastete_sorten_29725','serie_39543','vendor_1031','vendor_1226','vendor_1255','vendor_1476','vendor_413','vendor_477','vendor_511','vendor_553','vendor_721','vendor_724','vendor_728','art_39778','art_53069','art_54199','family_1102','family_1106','family_1167','family_1215','family_1219','family_752','feiertage_825','fuellung_39832','geschmack_23779','geschmack_26602','geschmack_26929','geschmack_36155','geschmack_53621','getreideart_23709','laenderkueche_43013','serie_39534','typ_34174','vendor_1113','vendor_1383','vendor_177','vendor_192','vendor_309','vendor_579','vendor_637','vendor_914','vendor_960','verpackung_6308','anzahl_der_portionen_35938','aroma_3546','art_23067','art_7540','family_1169','family_976','fleischart_30153','fuellung_39485','fuellung_39488','geschmack_23783','geschmack_45116','geschmack_51195','serie_55241','sorte_39243','vendor_111','vendor_1125','vendor_1173','vendor_1296','vendor_1316','vendor_140','vendor_1507','vendor_227','vendor_743','vendor_954','vendor_989','verwendungszweck_2752','verwendungszweck_35606','volumen_1460','altergruppierung_54019','altergruppierung_6272','anzahl_der_artikel_2679','art_23723','art_37143','art_56221','art_der_beeren_53100','family_1226','family_686','family_756','family_769','family_770','feiertage_821','feiertage_826','fettanteil_53700','fischart_43325','fuellung_39647','fuellung_39651','fuellung_51842','fuellung_52241','geschmack_23754','geschmack_26611','geschmack_26964','geschmack_36921','geschmack_38999','geschmack_39836','geschmack_39953','pastete_sorten_29718','serie_53575','vendor_1015','vendor_1070','vendor_1133','vendor_1153','vendor_1158','vendor_1218','vendor_1318','vendor_1422','vendor_1466','vendor_1472','vendor_1508','vendor_1540','vendor_1598','vendor_414','vendor_430','vendor_441','vendor_449','vendor_457','vendor_552','vendor_639','vendor_641','vendor_681','vendor_755','vendor_862','vendor_991','verwendungszweck_6088','art_33908','art_35238','art_37170','art_54194','family_1009','family_1031','family_1074','family_1214','family_757','family_974','feiertage_823','fettanteil_51891','fuellung_29777','fuellung_36364','fuellung_52846','geschmack_23758','geschmack_23782','geschmack_36940','geschmack_54329','getreideart_15482','sorte_45806','teigwarenart_25246','vendor_1104','vendor_1106','vendor_116','vendor_1240','vendor_1328','vendor_1372','vendor_1394','vendor_1406','vendor_1433','vendor_1459','vendor_1464','vendor_1496','vendor_1529','vendor_1545','vendor_178','vendor_267','vendor_431','vendor_533','vendor_772','verpackung_31703','verwendungszweck_135','anzahl_der_portionen_50815','aroma_55191','art_14443','art_35236','art_39627','art_52277','art_53592','art_54630','art_54638','art_56253','art_der_beeren_53103','family_1032','family_1033','family_697','family_773','family_972','fischart_29664','fischart_54769','fuellung_42734','fuellung_51125','fuellung_51170','fuellung_51734','fuellung_55934','geschlecht_65','geschmack_23760','geschmack_26605','geschmack_39002','geschmack_39945','grossen_38388','materialgruppierung_33495','netto_gewicht_filter_9','serie_34905','serie_54773','typ_55466','vendor_1025','vendor_1165','vendor_1187','vendor_1205','vendor_1289','vendor_1297','vendor_1337','vendor_1376','vendor_1483','vendor_1495','vendor_153','vendor_1549','vendor_1582','vendor_1595','vendor_274','vendor_277','vendor_537','vendor_554','vendor_608','vendor_685','vendor_785','vendor_852','vendor_861','vendor_869','vendor_924','vendor_980','verpackung_45261','verpackung_46731','verwendungszweck_17979','verwendungszweck_2256','verwendungszweck_29892','verwendungszweck_41370','aroma_26886','aroma_4227','aroma_4975','aroma_4976','art_36368','art_37171','art_37854','art_54635','art_54694','art_54695','art_55179','art_56419','art_der_beeren_53566','art_der_beeren_54072','art_der_beeren_54397','extract_53040','family_1120','family_1131','family_1229','family_1249','family_755','fettanteil_43969','fettanteil_52040','fischart_43320','fischart_43337','fischart_52914','fuellung_52898','geschlecht_66','geschmack_36935','geschmack_44672','geschmack_51196','geschmack_54650','laenderkueche_51124','manufacturer_53916','manufacturer_57302','serie_36417','serie_44736','teigwarenart_25230','typ_48885','vendor_1018','vendor_1160','vendor_1207','vendor_1342','vendor_1350','vendor_1410','vendor_1435','vendor_1455','vendor_1456','vendor_1555','vendor_1588','vendor_1597','vendor_1606','vendor_166','vendor_170','vendor_316','vendor_405','vendor_432','vendor_438','vendor_519','vendor_528','vendor_621','vendor_984','verwendungszweck_6536','verwendungszweck_9603','volumen_2365','weinart_53876','aroma_13964','aroma_17796','aroma_23887','aroma_23893','art_22870','art_22876','art_29788','art_29790','art_29792','art_41586','art_51126','art_54141','art_54633','art_54637','art_54715','art_der_beeren_53106','art_der_beeren_56092','extract_53033','family_1021','family_1030','family_1036','family_1046','family_1100','family_1128','family_1176','family_1209','family_1227','family_1238','family_1240','family_1254','family_1269','family_1270','family_1273','family_526','family_926','farbgruppierung_579','fettanteil_52035','fettanteil_52299','fischart_29661','fischart_37804','fleischart_15475','fleischart_54883','fleischart_54889','fuellung_51114','fuellung_55175','geschmack_23771','geschmack_23777','geschmack_26604','geschmack_36669','geschmack_36851','geschmack_46434','geschmack_53803','getreideart_23708','laenderkueche_47654','laenderkueche_48797','manufacturer_55474','netto_fuellmenge_filter_6','netto_gewicht_filter_8','serie_33808','serie_37454','serie_41382','serie_51965','serie_55386','teigwarenart_25229','teigwarenart_56421','typ_55388','vendor_1054','vendor_1119','vendor_1146','vendor_1157','vendor_1206','vendor_1261','vendor_1277','vendor_1300','vendor_1311','vendor_1355','vendor_1357','vendor_1380','vendor_1385','vendor_1450','vendor_1457','vendor_1481','vendor_152','vendor_1534','vendor_154','vendor_1542','vendor_1563','vendor_1567','vendor_1568','vendor_1621','vendor_164','vendor_181','vendor_265','vendor_444','vendor_500','vendor_535','vendor_538','vendor_547','vendor_582','vendor_642','vendor_644','vendor_738','vendor_767','vendor_770','vendor_851','vendor_855','vendor_873','vendor_896','vendor_909','vendor_910','vendor_928','vendor_967','vendor_972','vendor_979','verwendungszweck_2248','verwendungszweck_6827','volumen_37380','weinart_53872','anwendungszeit_9771','aroma_13957','aroma_24235','art_22724','art_22832','art_22836','art_30396','art_30632','art_30649','art_30666','art_33919','art_54198','art_54636','art_54739','art_55667','art_56215','art_56255','art_56257','art_57225','art_der_beeren_54286','art_der_beeren_54717','art_der_suessigkeiten_39991','extract_53002','family_1024','family_1045','family_1075','family_1225','family_1253','family_1262','family_1266','family_1279','family_695','family_759','family_868','feiertage_822','fuellung_51140','fuellung_51969','fuellung_52598','fuellung_54104','fuellung_54798','fuellung_55875','geschmack_26599','geschmack_26607','geschmack_36932','geschmack_37738','geschmack_42691','geschmack_53895','geschmack_54213','geschmack_56818','getreideart_25279','getreideart_38595','handelsform_5910','manufacturer_57065','netto_gewicht_filter_11','netto_gewicht_filter_13','serie_39536','serie_39538','serie_55666','sorte_19469','typ_16198','vendor_1007','vendor_1020','vendor_1033','vendor_1037','vendor_1055','vendor_1107','vendor_1195','vendor_1241','vendor_1247','vendor_1254','vendor_1260','vendor_1302','vendor_1307','vendor_1309','vendor_1312','vendor_1319','vendor_1371','vendor_1375','vendor_1378','vendor_138','vendor_1386','vendor_1423','vendor_143','vendor_1458','vendor_1477','vendor_1482','vendor_1486','vendor_1487','vendor_1492','vendor_1494','vendor_1505','vendor_151','vendor_1520','vendor_1527','vendor_1528','vendor_1535','vendor_1543','vendor_1554','vendor_157','vendor_1578','vendor_1580','vendor_1581','vendor_1587','vendor_1605','vendor_1624','vendor_223','vendor_225','vendor_251','vendor_295','vendor_296','vendor_346','vendor_403','vendor_406','vendor_459','vendor_490','vendor_527','vendor_573','vendor_577','vendor_609','vendor_630','vendor_744','vendor_814','vendor_883','vendor_946','vendor_992','verwendungszweck_16237','verwendungszweck_2240','verwendungszweck_34164','verwendungszweck_35571','verwendungszweck_6814','volumen_32280','volumen_41001','volumen_41002','volumen_5235','weinart_57300','anzahl_der_artikel_2680','anzahl_der_portionen_35920','anzahl_der_portionen_35933','aroma_11395','aroma_17795','aroma_22670','aroma_39184','aroma_39201','aroma_4224','aroma_4974','aroma_6917','art_15478','art_22663','art_22806','art_22810','art_22844','art_22868','art_29789','art_30630','art_30684','art_36390','art_40602','art_51286','art_54105','art_54140','art_54455','art_54738','art_55008','art_56993','art_57203','art_der_beeren_54004','art_der_beeren_56099','art_der_suessigkeiten_52757','extract_53001','extract_53015','family_1011','family_1016','family_1023','family_1115','family_1259','family_723','family_758','family_858','family_936','farbgruppierung_578','fettanteil_53325','fettanteil_54814','fettanteil_55626','fettanteil_55845','fettanteil_56075','fischart_29665','fischart_43293','fischart_45346','fischart_52492','fischart_52858','fischart_55177','fischart_57425','fuellung_36367','fuellung_39661','fuellung_55123','fuellung_55170','fuellung_55284','fuellung_55786','geschmack_23748','geschmack_23769','geschmack_26329','geschmack_29525','geschmack_36381','geschmack_39167','geschmack_42774','geschmack_45977','geschmack_51197','geschmack_54330','geschmack_54443','geschmack_54962','getreideart_25278','handelsform_27518','handelsform_35599','laenderkueche_36351','laenderkueche_36353','laenderkueche_43127','manufacturer_53918','manufacturer_55475','manufacturer_56718','manufacturer_56721','manufacturer_56723','manufacturer_57094','pastete_sorten_29726','serie_32988','serie_53680','sorte_27412','sorte_39254','typ_33892','typ_40821','vendor_1035','vendor_1048','vendor_1051','vendor_1064','vendor_1077','vendor_1085','vendor_1088','vendor_1112','vendor_1114','vendor_112','vendor_1121','vendor_1145','vendor_1147','vendor_1181','vendor_1197','vendor_1215','vendor_125','vendor_1276','vendor_1281','vendor_1293','vendor_1315','vendor_1327','vendor_1333','vendor_1346','vendor_1347','vendor_1379','vendor_1381','vendor_1388','vendor_1390','vendor_1414','vendor_1432','vendor_144','vendor_1440','vendor_1449','vendor_1463','vendor_1465','vendor_1470','vendor_1478','vendor_1479','vendor_1484','vendor_1512','vendor_1522','vendor_1533','vendor_1536','vendor_1546','vendor_1547','vendor_1552','vendor_1558','vendor_1575','vendor_1577','vendor_1591','vendor_1610','vendor_1612','vendor_1618','vendor_1629','vendor_1631','vendor_1634','vendor_200','vendor_207','vendor_248','vendor_259','vendor_347','vendor_412','vendor_467','vendor_514','vendor_534','vendor_551','vendor_636','vendor_664','vendor_665','vendor_666','vendor_678','vendor_689','vendor_700','vendor_745','vendor_821','vendor_836','vendor_850','vendor_907','vendor_956','vendor_958','vendor_961','verpackung_39173','verwendungszweck_36655','verwendungszweck_52782','verwendungszweck_52792','volumen_1461','volumen_1462','volumen_2366','volumen_43345','volumen_7546','volumen_der_tasse_40912','aroma_13960','aroma_17731','aroma_30995','aroma_4380','aroma_4973','aroma_53980','art_14447','art_22813','art_22815','art_22848','art_22921','art_23546','art_23722','art_30395','art_30648','art_30689','art_30692','art_33928','art_36991','art_37210','art_37849','art_37853','art_38567','art_38894','art_38895','art_40589','art_41081','art_53588','art_53590','art_53591','art_53766','art_54195','art_54284','art_54693','art_54698','art_55980','art_56004','art_56010','art_56254','art_56675','art_6091','art_der_beeren_56094','art_der_beeren_56097','art_der_beeren_56100','duft_31347','duft_36386','extract_53029','extract_53035','family_1015','family_1018','family_1019','family_1020','family_1022','family_1034','family_1043','family_1055','family_1066','family_1067','family_1099','family_1142','family_1144','family_1172','family_1223','family_1239','family_1246','family_1250','family_1251','family_1264','family_1265','family_1267','family_1271','family_1274','family_1287','family_1291','family_1292','family_255','family_866','farbgruppierung_586','fettanteil_52046','fettanteil_52300','fettanteil_52303','fettanteil_54188','fettanteil_54437','fettanteil_56070','fettanteil_56074','fettanteil_56076','fettanteil_56744','fischart_29658','fischart_29663','fischart_43277','fischart_52356','fischart_52490','fischart_53820','fischart_54516','fischart_56343','fischart_57014','fischart_57452','fuellung_39210','fuellung_39649','fuellung_51108','fuellung_51109','fuellung_52410','fuellung_52596','fuellung_52816','fuellung_54361','fuellung_54834','fuellung_55407','fuellung_56012','fuellung_56653','fuellung_56743','fuellung_57524','geschmack_24711','geschmack_36387','geschmack_39555','geschmack_42722','geschmack_45473','geschmack_46433','geschmack_47953','geschmack_51194','geschmack_54341','geschmack_54640','geschmack_54643','geschmack_54709','geschmack_54744','geschmack_54799','geschmack_56404','geschmack_56650','geschmack_56714','geschmack_57342','geschmack_57392','geschmack_57615','geschmack_57616','getreideart_38553','laenderkueche_36360','laenderkueche_36361','laenderkueche_43129','laenderkueche_43210','manufacturer_53919','manufacturer_55471','manufacturer_56717','manufacturer_56720','manufacturer_57095','modelname_52509','netto_fuellmenge_filter_7','netto_fuellmenge_filter_8','netto_gewicht_filter_10','pastete_sorten_50587','serie_39537','serie_39539','serie_39540','serie_45257','serie_52845','serie_54749','serie_55669','typ_33917','typ_37811','typ_54760','typ_7530','vendor_1000','vendor_1022','vendor_1032','vendor_1049','vendor_1063','vendor_1065','vendor_1072','vendor_1087','vendor_1091','vendor_1103','vendor_1124','vendor_1138','vendor_1140','vendor_1149','vendor_1162','vendor_118','vendor_1182','vendor_1186','vendor_1190','vendor_1208','vendor_1213','vendor_1224','vendor_1229','vendor_1234','vendor_1252','vendor_1283','vendor_1291','vendor_1299','vendor_1310','vendor_1322','vendor_1325','vendor_1326','vendor_1331','vendor_1340','vendor_1352','vendor_1354','vendor_1382','vendor_1387','vendor_139','vendor_141','vendor_1416','vendor_1417','vendor_1436','vendor_1441','vendor_1451','vendor_146','vendor_1460','vendor_1461','vendor_1474','vendor_1488','vendor_1491','vendor_1497','vendor_1506','vendor_1509','vendor_1514','vendor_1515','vendor_1524','vendor_1526','vendor_1530','vendor_1531','vendor_1532','vendor_1537','vendor_1541','vendor_1544','vendor_1548','vendor_1556','vendor_1557','vendor_1561','vendor_1562','vendor_1572','vendor_1579','vendor_1585','vendor_1586','vendor_1590','vendor_1592','vendor_1596','vendor_1617','vendor_1619','vendor_1620','vendor_1623','vendor_1633','vendor_187','vendor_203','vendor_204','vendor_230','vendor_232','vendor_235','vendor_236','vendor_240','vendor_256','vendor_261','vendor_271','vendor_280','vendor_282','vendor_291','vendor_305','vendor_313','vendor_336','vendor_348','vendor_353','vendor_383','vendor_408','vendor_409','vendor_437','vendor_442','vendor_446','vendor_448','vendor_473','vendor_481','vendor_484','vendor_508','vendor_513','vendor_518','vendor_521','vendor_558','vendor_565','vendor_566','vendor_570','vendor_580','vendor_581','vendor_617','vendor_635','vendor_649','vendor_677','vendor_695','vendor_699','vendor_715','vendor_717','vendor_750','vendor_757','vendor_758','vendor_779','vendor_786','vendor_832','vendor_835','vendor_845','vendor_872','vendor_880','vendor_884','vendor_886','vendor_893','vendor_901','vendor_902','vendor_904','vendor_906','vendor_908','vendor_915','vendor_919','vendor_929','vendor_937','vendor_964','vendor_968','vendor_981','vendor_983','vendor_987','verwendungszweck_2316','verwendungszweck_2721','verwendungszweck_32164','verwendungszweck_34356','verwendungszweck_4742','verwendungszweck_48981','verwendungszweck_5001','verwendungszweck_5053','verwendungszweck_53177','verwendungszweck_6042','verwendungszweck_6231','verwendungszweck_6232','verwendungszweck_7976','volumen_2368','volumen_2411','volumen_2463','volumen_3001','volumen_3283','volumen_3732','volumen_41815','volumen_4942','volumen_51890','volumen_56310','volumen_9140','volumen_9651','volumen_9913','weinart_53910') AND  a.is_filterable = true;

#	File/Call
1	Doctrine\DBAL\Statement->executeQuery (line 119)
2	App\Repository\AttributeRepository->getRawFilters (line 73)
3	App\Component\CategoryFilter->parseSelectedFilters (line 25)
4	App\Controller\Pages\DocumentController->categoryDetailAction (line 388)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
7	Symfony\Component\HttpKernel\Kernel->handle (line 191)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
9	require_once (line 32)
10	require_once (line 5)

0.60 ms
(4.86%)

SELECT b0_.id AS id_0, b0_.tracking_code AS tracking_code_1, b0_.title AS title_2, b0_.banner_type AS banner_type_3, b0_.banner_order AS banner_order_4, b0_.image_path AS image_path_5, b0_.destination AS destination_6, b0_.category_include AS category_include_7, b0_.category_exclude AS category_exclude_8, b0_.date_start AS date_start_9, b0_.date_end AS date_end_10, b0_.options AS options_11 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-07-25 00:27:07"
  "2026-07-25 00:27:07"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  b0_.id AS id_0,
  b0_.tracking_code AS tracking_code_1,
  b0_.title AS title_2,
  b0_.banner_type AS banner_type_3,
  b0_.banner_order AS banner_order_4,
  b0_.image_path AS image_path_5,
  b0_.destination AS destination_6,
  b0_.category_include AS category_include_7,
  b0_.category_exclude AS category_exclude_8,
  b0_.date_start AS date_start_9,
  b0_.date_end AS date_end_10,
  b0_.options AS options_11
FROM
  banners b0_
WHERE
  b0_.banner_type = ?
  AND b0_.date_start < ?
  AND (
    b0_.date_end > ?
    OR b0_.date_end IS NULL
  )

SELECT b0_.id AS id_0, b0_.tracking_code AS tracking_code_1, b0_.title AS title_2, b0_.banner_type AS banner_type_3, b0_.banner_order AS banner_order_4, b0_.image_path AS image_path_5, b0_.destination AS destination_6, b0_.category_include AS category_include_7, b0_.category_exclude AS category_exclude_8, b0_.date_start AS date_start_9, b0_.date_end AS date_end_10, b0_.options AS options_11 FROM banners b0_ WHERE b0_.banner_type = 'top_full_width' AND b0_.date_start < '2026-07-25 00:27:07' AND (b0_.date_end > '2026-07-25 00:27:07' OR b0_.date_end IS NULL);

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	App\Repository\BannerRepository->getBannersByType (line 212)
6	App\Twig\BannersTwigExtension->get (line 36)
7	Twig\Extension\CoreExtension->getAttribute (line 1919)
8	__TwigTemplate_1300f96f9e61fe6435f2afaa122c5999::doDisplay (line 57)
9	Twig\Template->yield (line 402)
10	__TwigTemplate_73b80eda043aed5472a166e8a1569921->block_body (line 154)
11	Twig\Template->yieldBlock (line 446)
12	__TwigTemplate_73b80eda043aed5472a166e8a1569921->doDisplay (line 112)
13	Twig\Template->yield (line 402)
14	__TwigTemplate_e0147ad1d6fb1d431bff65c8d2d9a56c->doDisplay (line 55)
15	Twig\Template->yield (line 402)
16	__TwigTemplate_c2774f099a993e9e703dcf92696c7d3e->doDisplay (line 64)
17	Twig\Template->yield (line 402)
18	Twig\Template->display (line 358)
19	Twig\Template->render (line 373)
20	Twig\TemplateWrapper->render (line 51)
21	Twig\Environment->render (line 333)
22	App\Controller\AppController->doRenderView (line 133)
23	App\Controller\AppController->doRender (line 93)
24	App\Controller\AppController->render (line 76)
25	App\Controller\Pages\DocumentController->categoryDetailAction (line 507)
26	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
27	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
28	Symfony\Component\HttpKernel\Kernel->handle (line 191)
29	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
30	require_once (line 32)
31	require_once (line 5)

0.12 ms
(1.00%)

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:

[
  "019f963d-0c52-71ce-9530-e88862398925"
]

View formatted query View runnable query Explain query View query backtrace

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

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 = '019f963d-0c52-71ce-9530-e88862398925' ORDER BY t0.created_at DESC;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1872)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 1817)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2729)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 315)
7	App\Twig\CatalogTwigExtension->cartCounter (line 109)
8	Twig\Extension\CoreExtension->getAttribute (line 1919)
9	__TwigTemplate_896fe8730b7526bae797407c2701fd5a::doDisplay (line 153)
10	Twig\Template->yield (line 402)
11	__TwigTemplate_7f3c55d2a22e95aeb5739a5eb8db7eae->doDisplay (line 130)
12	Twig\Template->yield (line 402)
13	__TwigTemplate_73b80eda043aed5472a166e8a1569921->block_body (line 160)
14	Twig\Template->yieldBlock (line 446)
15	__TwigTemplate_73b80eda043aed5472a166e8a1569921->doDisplay (line 112)
16	Twig\Template->yield (line 402)
17	__TwigTemplate_e0147ad1d6fb1d431bff65c8d2d9a56c->doDisplay (line 55)
18	Twig\Template->yield (line 402)
19	__TwigTemplate_c2774f099a993e9e703dcf92696c7d3e->doDisplay (line 64)
20	Twig\Template->yield (line 402)
21	Twig\Template->display (line 358)
22	Twig\Template->render (line 373)
23	Twig\TemplateWrapper->render (line 51)
24	Twig\Environment->render (line 333)
25	App\Controller\AppController->doRenderView (line 133)
26	App\Controller\AppController->doRender (line 93)
27	App\Controller\AppController->render (line 76)
28	App\Controller\Pages\DocumentController->categoryDetailAction (line 507)
29	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
30	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
31	Symfony\Component\HttpKernel\Kernel->handle (line 191)
32	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
33	require_once (line 32)
34	require_once (line 5)

0.12 ms
(0.95%)

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:

[
  "019f963d-0c5a-7713-bdbb-13682edda57b"
]

View formatted query View runnable query Explain query View query backtrace

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

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 = '019f963d-0c5a-7713-bdbb-13682edda57b' ORDER BY t0.created_at DESC;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1872)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 1817)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2729)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 315)
7	App\Repository\WishlistRepository->getWishlistProductsSkuList (line 153)
8	App\Helper\CategoryHelper->loadWishlistItems (line 15)
9	App\Controller\Pages\DocumentController->categoryDetailAction (line 464)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
12	Symfony\Component\HttpKernel\Kernel->handle (line 191)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
14	require_once (line 32)
15	require_once (line 5)

0.08 ms
(0.67%)

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"
]

View formatted query View runnable query Explain query View query backtrace

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 (?, ?, ?, ?)

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 ('menu_main', 'top_amount', 'top_sold', 'sale');

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 963)
2	Doctrine\ORM\EntityRepository->findBy (line 110)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepository->findBy (line 78)
4	App\Repository\CategoryMenuRepository->getMenuPromoCategories (line 70)
5	App\Twig\SnippetExtension->getMenuPromoCategories (line 347)
6	__TwigTemplate_f076d978211fe617fc43a8eb60ed9bc3->doDisplay (line 48)
7	Twig\Template->yield (line 402)
8	__TwigTemplate_7f3c55d2a22e95aeb5739a5eb8db7eae->doDisplay (line 155)
9	Twig\Template->yield (line 402)
10	__TwigTemplate_73b80eda043aed5472a166e8a1569921->block_body (line 160)
11	Twig\Template->yieldBlock (line 446)
12	__TwigTemplate_73b80eda043aed5472a166e8a1569921->doDisplay (line 112)
13	Twig\Template->yield (line 402)
14	__TwigTemplate_e0147ad1d6fb1d431bff65c8d2d9a56c->doDisplay (line 55)
15	Twig\Template->yield (line 402)
16	__TwigTemplate_c2774f099a993e9e703dcf92696c7d3e->doDisplay (line 64)
17	Twig\Template->yield (line 402)
18	Twig\Template->display (line 358)
19	Twig\Template->render (line 373)
20	Twig\TemplateWrapper->render (line 51)
21	Twig\Environment->render (line 333)
22	App\Controller\AppController->doRenderView (line 133)
23	App\Controller\AppController->doRender (line 93)
24	App\Controller\AppController->render (line 76)
25	App\Controller\Pages\DocumentController->categoryDetailAction (line 507)
26	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
27	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
28	Symfony\Component\HttpKernel\Kernel->handle (line 191)
29	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
30	require_once (line 32)
31	require_once (line 5)

0.07 ms
(0.56%)

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:

[
  "019f963d-0c52-71ce-9530-e88862398925"
]

View formatted query View runnable query Explain query View query backtrace

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 = ?

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 = '019f963d-0c52-71ce-9530-e88862398925';

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
3	Doctrine\ORM\EntityManager->find (line 366)
4	Doctrine\ORM\EntityRepository->find (line 86)
5	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepository->find (line 66)
6	App\Repository\CartRepository->initAnonCart (line 216)
7	App\Repository\CartRepository->init (line 263)
8	App\EventListener\Locale\StickyListener->sessionListener (line 125)
9	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
10	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
11	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
12	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
13	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
14	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
15	Symfony\Component\HttpKernel\Kernel->handle (line 191)
16	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
17	require_once (line 32)
18	require_once (line 5)

0.06 ms
(0.52%)

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:

[
  "019f963d-0c5a-7713-bdbb-13682edda57b"
]

View formatted query View runnable query Explain query View query backtrace

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 = ?

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 = '019f963d-0c5a-7713-bdbb-13682edda57b';

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
3	Doctrine\ORM\EntityManager->find (line 366)
4	Doctrine\ORM\EntityRepository->find (line 86)
5	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepository->find (line 66)
6	App\Repository\WishlistRepository->initAnonWishlist (line 129)
7	App\Repository\WishlistRepository->init (line 166)
8	App\EventListener\Locale\StickyListener->sessionListener (line 126)
9	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
10	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
11	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
12	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
13	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
14	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
15	Symfony\Component\HttpKernel\Kernel->handle (line 191)
16	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
17	require_once (line 32)
18	require_once (line 5)

0.06 ms
(0.51%)

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"
]

View formatted query View runnable query Explain query View query backtrace

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 = ?

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 = 'menu_mobile';

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 963)
2	Doctrine\ORM\EntityRepository->findBy (line 110)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepository->findBy (line 78)
4	App\Repository\CategoryMenuRepository->getMenuPromoCategories (line 70)
5	App\Twig\SnippetExtension->getMenuPromoCategories (line 347)
6	__TwigTemplate_fa5fbe301f0a082f2208c5a3a2c39ed5->doDisplay (line 79)
7	Twig\Template->yield (line 402)
8	Twig\Template->display (line 358)
9	Twig\Template->render (line 373)
10	Twig\TemplateWrapper->render (line 51)
11	App\Twig\SnippetExtension->menu (line 89)
12	__TwigTemplate_73b80eda043aed5472a166e8a1569921->block_custom_modals (line 343)
13	Twig\Template->yieldBlock (line 446)
14	Twig\Template->yieldBlock (line 466)
15	Twig\Template->yieldParentBlock (line 491)
16	__TwigTemplate_c2774f099a993e9e703dcf92696c7d3e->block_custom_modals (line 245)
17	Twig\Template->yieldBlock (line 446)
18	__TwigTemplate_73b80eda043aed5472a166e8a1569921->block_body (line 224)
19	Twig\Template->yieldBlock (line 446)
20	__TwigTemplate_73b80eda043aed5472a166e8a1569921->doDisplay (line 112)
21	Twig\Template->yield (line 402)
22	__TwigTemplate_e0147ad1d6fb1d431bff65c8d2d9a56c->doDisplay (line 55)
23	Twig\Template->yield (line 402)
24	__TwigTemplate_c2774f099a993e9e703dcf92696c7d3e->doDisplay (line 64)
25	Twig\Template->yield (line 402)
26	Twig\Template->display (line 358)
27	Twig\Template->render (line 373)
28	Twig\TemplateWrapper->render (line 51)
29	Twig\Environment->render (line 333)
30	App\Controller\AppController->doRenderView (line 133)
31	App\Controller\AppController->doRender (line 93)
32	App\Controller\AppController->render (line 76)
33	App\Controller\Pages\DocumentController->categoryDetailAction (line 507)
34	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
35	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
36	Symfony\Component\HttpKernel\Kernel->handle (line 191)
37	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
38	require_once (line 32)
39	require_once (line 5)

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.

Symfony Profiler

GET https://www.posylka-test.colibo.io/de/lebensmittel-c2012.html

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping