| 3 |
0.15 ms |
SELECT a.id as group_id, a.code, a.name_ru, a.name_de, a.sort,
a.is_metric, a.is_deeplink, a.is_filterable, a.use_deeplink_code,
a.group_sort, a.group_name_ru, a.group_name_de,
av.uid as value_id, av.name_ru as value_ru, av.name_de as value_de
FROM attribute_value AS av
JOIN attribute AS a on a.code = av.code
WHERE av.uid IN('coolbox_filter_0','freezebox_filter_3','family_922','verpackung_24689','netto_gewicht_filter_3','verpackung_4205','vendor_231','vendor_150','netto_gewicht_filter_5','netto_gewicht_filter_4','laenderkueche_36354','family_1065','family_691','art_2163','laenderkueche_36352','netto_fuellmenge_filter_3','family_752','netto_fuellmenge_filter_4','fettanteil_51891','netto_gewicht_filter_6','verpackung_2870','art_56253','family_1032','vendor_1187','verpackung_2954','laenderkueche_36349','netto_fuellmenge_filter_5','vendor_1218','volumen_2365','volumen_2424','family_1128','vendor_535','volumen_37380','art_56255','art_56257','netto_gewicht_filter_2','vendor_1028','vendor_1055','vendor_1535','vendor_386','verpackung_35918','volumen_1460','volumen_32280','volumen_41001','volumen_41002','volumen_5235','laenderkueche_36350','vendor_1374','vendor_1379','vendor_1536','vendor_159','vendor_430','vendor_534','vendor_538','vendor_608','verpackung_27725','verpackung_38799','volumen_1461','volumen_1462','volumen_2366','volumen_43345','art_56254','fettanteil_52040','fettanteil_52046','fettanteil_53700','laenderkueche_36351','laenderkueche_36360','laenderkueche_43012','laenderkueche_43210','laenderkueche_50808','netto_fuellmenge_filter_2','vendor_114','vendor_1191','vendor_1283','vendor_1313','vendor_144','vendor_1514','vendor_431','vendor_458','vendor_473','vendor_508','vendor_521','vendor_531','vendor_873','vendor_904','verpackung_3121','volumen_2368','volumen_2411','volumen_2463','volumen_3001','volumen_3283','volumen_3732','volumen_41815','volumen_4942','volumen_51890','volumen_56310','volumen_7546','volumen_9140','volumen_9651','volumen_9913') 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',
'family_922', 'verpackung_24689',
'netto_gewicht_filter_3', 'verpackung_4205',
'vendor_231', 'vendor_150', 'netto_gewicht_filter_5',
'netto_gewicht_filter_4', 'laenderkueche_36354',
'family_1065', 'family_691', 'art_2163',
'laenderkueche_36352', 'netto_fuellmenge_filter_3',
'family_752', 'netto_fuellmenge_filter_4',
'fettanteil_51891', 'netto_gewicht_filter_6',
'verpackung_2870', 'art_56253',
'family_1032', 'vendor_1187', 'verpackung_2954',
'laenderkueche_36349', 'netto_fuellmenge_filter_5',
'vendor_1218', 'volumen_2365', 'volumen_2424',
'family_1128', 'vendor_535', 'volumen_37380',
'art_56255', 'art_56257', 'netto_gewicht_filter_2',
'vendor_1028', 'vendor_1055', 'vendor_1535',
'vendor_386', 'verpackung_35918',
'volumen_1460', 'volumen_32280',
'volumen_41001', 'volumen_41002',
'volumen_5235', 'laenderkueche_36350',
'vendor_1374', 'vendor_1379', 'vendor_1536',
'vendor_159', 'vendor_430', 'vendor_534',
'vendor_538', 'vendor_608', 'verpackung_27725',
'verpackung_38799', 'volumen_1461',
'volumen_1462', 'volumen_2366',
'volumen_43345', 'art_56254', 'fettanteil_52040',
'fettanteil_52046', 'fettanteil_53700',
'laenderkueche_36351', 'laenderkueche_36360',
'laenderkueche_43012', 'laenderkueche_43210',
'laenderkueche_50808', 'netto_fuellmenge_filter_2',
'vendor_114', 'vendor_1191', 'vendor_1283',
'vendor_1313', 'vendor_144', 'vendor_1514',
'vendor_431', 'vendor_458', 'vendor_473',
'vendor_508', 'vendor_521', 'vendor_531',
'vendor_873', 'vendor_904', 'verpackung_3121',
'volumen_2368', 'volumen_2411',
'volumen_2463', 'volumen_3001',
'volumen_3283', 'volumen_3732',
'volumen_41815', 'volumen_4942',
'volumen_51890', 'volumen_56310',
'volumen_7546', 'volumen_9140',
'volumen_9651', 'volumen_9913'
)
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','family_922','verpackung_24689','netto_gewicht_filter_3','verpackung_4205','vendor_231','vendor_150','netto_gewicht_filter_5','netto_gewicht_filter_4','laenderkueche_36354','family_1065','family_691','art_2163','laenderkueche_36352','netto_fuellmenge_filter_3','family_752','netto_fuellmenge_filter_4','fettanteil_51891','netto_gewicht_filter_6','verpackung_2870','art_56253','family_1032','vendor_1187','verpackung_2954','laenderkueche_36349','netto_fuellmenge_filter_5','vendor_1218','volumen_2365','volumen_2424','family_1128','vendor_535','volumen_37380','art_56255','art_56257','netto_gewicht_filter_2','vendor_1028','vendor_1055','vendor_1535','vendor_386','verpackung_35918','volumen_1460','volumen_32280','volumen_41001','volumen_41002','volumen_5235','laenderkueche_36350','vendor_1374','vendor_1379','vendor_1536','vendor_159','vendor_430','vendor_534','vendor_538','vendor_608','verpackung_27725','verpackung_38799','volumen_1461','volumen_1462','volumen_2366','volumen_43345','art_56254','fettanteil_52040','fettanteil_52046','fettanteil_53700','laenderkueche_36351','laenderkueche_36360','laenderkueche_43012','laenderkueche_43210','laenderkueche_50808','netto_fuellmenge_filter_2','vendor_114','vendor_1191','vendor_1283','vendor_1313','vendor_144','vendor_1514','vendor_431','vendor_458','vendor_473','vendor_508','vendor_521','vendor_531','vendor_873','vendor_904','verpackung_3121','volumen_2368','volumen_2411','volumen_2463','volumen_3001','volumen_3283','volumen_3732','volumen_41815','volumen_4942','volumen_51890','volumen_56310','volumen_7546','volumen_9140','volumen_9651','volumen_9913') AND a.is_filterable = true;
|