0.19 ms (10.59%)
|
1 |
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('freezebox_filter_3','coolbox_filter_1','coolbox_filter_0','netto_gewicht_filter_3','family_1072','verpackung_4205','art_56006','family_684','art_2163','family_1220','verpackung_2870','netto_gewicht_filter_5','verpackung_36357','freezebox_filter_2','family_1035','vendor_357','fischart_29659','netto_gewicht_filter_2','netto_gewicht_filter_1','vendor_42','fischart_29660','laenderkueche_36352','netto_gewicht_filter_4','art_55439','fischart_29998','verpackung_3840','art_56007','vendor_1179','fischart_29740','fischart_54823','vendor_1027','verpackung_3948','fischart_29999','fischart_36125','fischart_37803','art_54697','fischart_38548','vendor_944','vendor_1462','vendor_679','fischart_37812','vendor_728','verpackung_3121','vendor_477','vendor_458','verpackung_5933','fischart_35526','fischart_43299','vendor_914','family_920','pastete_sorten_29725','vendor_1255','vendor_227','fischart_29664','fischart_43325','fischart_54769','netto_gewicht_filter_6','art_54694','art_54695','fischart_43337','vendor_1406','family_1227','fischart_29661','fischart_37804','serie_55386','vendor_114','vendor_1311','vendor_1355','vendor_909','verpackung_24689','fischart_43320','fischart_52914','laenderkueche_36350','vendor_1107','vendor_1312','vendor_1371','vendor_869','vendor_910','verpackung_35918','art_39784','fischart_45346','fischart_52492','fischart_52858','fischart_55177','fischart_57425','serie_55241','vendor_1181','vendor_1386','vendor_1465','vendor_151','vendor_1546','vendor_224','vendor_531','vendor_907','verpackung_37215','art_54698','fischart_29658','fischart_29663','fischart_29665','fischart_43277','fischart_43293','fischart_52356','fischart_52490','fischart_53820','fischart_54516','fischart_56343','fischart_57014','fischart_57452','laenderkueche_43127','netto_gewicht_filter_7','typ_37811','vendor_1032','vendor_1064','vendor_1182','vendor_1526','vendor_1557','vendor_204','vendor_402','vendor_635','vendor_637','vendor_677','vendor_678','vendor_757','vendor_862','vendor_884','vendor_906','vendor_908','vendor_981','vendor_983','verpackung_14402','verpackung_39173') 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(
'freezebox_filter_3',
'coolbox_filter_1',
'coolbox_filter_0',
'netto_gewicht_filter_3',
'family_1072',
'verpackung_4205',
'art_56006',
'family_684',
'art_2163',
'family_1220',
'verpackung_2870',
'netto_gewicht_filter_5',
'verpackung_36357',
'freezebox_filter_2',
'family_1035',
'vendor_357',
'fischart_29659',
'netto_gewicht_filter_2',
'netto_gewicht_filter_1',
'vendor_42',
'fischart_29660',
'laenderkueche_36352',
'netto_gewicht_filter_4',
'art_55439',
'fischart_29998',
'verpackung_3840',
'art_56007',
'vendor_1179',
'fischart_29740',
'fischart_54823',
'vendor_1027',
'verpackung_3948',
'fischart_29999',
'fischart_36125',
'fischart_37803',
'art_54697',
'fischart_38548',
'vendor_944',
'vendor_1462',
'vendor_679',
'fischart_37812',
'vendor_728',
'verpackung_3121',
'vendor_477',
'vendor_458',
'verpackung_5933',
'fischart_35526',
'fischart_43299',
'vendor_914',
'family_920',
'pastete_sorten_29725',
'vendor_1255',
'vendor_227',
'fischart_29664',
'fischart_43325',
'fischart_54769',
'netto_gewicht_filter_6',
'art_54694',
'art_54695',
'fischart_43337',
'vendor_1406',
'family_1227',
'fischart_29661',
'fischart_37804',
'serie_55386',
'vendor_114',
'vendor_1311',
'vendor_1355',
'vendor_909',
'verpackung_24689',
'fischart_43320',
'fischart_52914',
'laenderkueche_36350',
'vendor_1107',
'vendor_1312',
'vendor_1371',
'vendor_869',
'vendor_910',
'verpackung_35918',
'art_39784',
'fischart_45346',
'fischart_52492',
'fischart_52858',
'fischart_55177',
'fischart_57425',
'serie_55241',
'vendor_1181',
'vendor_1386',
'vendor_1465',
'vendor_151',
'vendor_1546',
'vendor_224',
'vendor_531',
'vendor_907',
'verpackung_37215',
'art_54698',
'fischart_29658',
'fischart_29663',
'fischart_29665',
'fischart_43277',
'fischart_43293',
'fischart_52356',
'fischart_52490',
'fischart_53820',
'fischart_54516',
'fischart_56343',
'fischart_57014',
'fischart_57452',
'laenderkueche_43127',
'netto_gewicht_filter_7',
'typ_37811',
'vendor_1032',
'vendor_1064',
'vendor_1182',
'vendor_1526',
'vendor_1557',
'vendor_204',
'vendor_402',
'vendor_635',
'vendor_637',
'vendor_677',
'vendor_678',
'vendor_757',
'vendor_862',
'vendor_884',
'vendor_906',
'vendor_908',
'vendor_981',
'vendor_983',
'verpackung_14402',
'verpackung_39173'
)
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('freezebox_filter_3','coolbox_filter_1','coolbox_filter_0','netto_gewicht_filter_3','family_1072','verpackung_4205','art_56006','family_684','art_2163','family_1220','verpackung_2870','netto_gewicht_filter_5','verpackung_36357','freezebox_filter_2','family_1035','vendor_357','fischart_29659','netto_gewicht_filter_2','netto_gewicht_filter_1','vendor_42','fischart_29660','laenderkueche_36352','netto_gewicht_filter_4','art_55439','fischart_29998','verpackung_3840','art_56007','vendor_1179','fischart_29740','fischart_54823','vendor_1027','verpackung_3948','fischart_29999','fischart_36125','fischart_37803','art_54697','fischart_38548','vendor_944','vendor_1462','vendor_679','fischart_37812','vendor_728','verpackung_3121','vendor_477','vendor_458','verpackung_5933','fischart_35526','fischart_43299','vendor_914','family_920','pastete_sorten_29725','vendor_1255','vendor_227','fischart_29664','fischart_43325','fischart_54769','netto_gewicht_filter_6','art_54694','art_54695','fischart_43337','vendor_1406','family_1227','fischart_29661','fischart_37804','serie_55386','vendor_114','vendor_1311','vendor_1355','vendor_909','verpackung_24689','fischart_43320','fischart_52914','laenderkueche_36350','vendor_1107','vendor_1312','vendor_1371','vendor_869','vendor_910','verpackung_35918','art_39784','fischart_45346','fischart_52492','fischart_52858','fischart_55177','fischart_57425','serie_55241','vendor_1181','vendor_1386','vendor_1465','vendor_151','vendor_1546','vendor_224','vendor_531','vendor_907','verpackung_37215','art_54698','fischart_29658','fischart_29663','fischart_29665','fischart_43277','fischart_43293','fischart_52356','fischart_52490','fischart_53820','fischart_54516','fischart_56343','fischart_57014','fischart_57452','laenderkueche_43127','netto_gewicht_filter_7','typ_37811','vendor_1032','vendor_1064','vendor_1182','vendor_1526','vendor_1557','vendor_204','vendor_402','vendor_635','vendor_637','vendor_677','vendor_678','vendor_757','vendor_862','vendor_884','vendor_906','vendor_908','vendor_981','vendor_983','verpackung_14402','verpackung_39173') AND a.is_filterable = true;
|