0.15 ms (10.33%)
|
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','family_1101','art_54139','verpackung_42548','netto_gewicht_filter_3','netto_gewicht_filter_2','art_2163','fettanteil_54147','netto_gewicht_filter_4','verpackung_37215','art_39784','vendor_1316','netto_gewicht_filter_5','fettanteil_53700','verpackung_3609','vendor_1455','vendor_621','verpackung_2870','art_54141','fettanteil_52040','vendor_531','vendor_642','verpackung_3121','vendor_1494','vendor_1505','verpackung_5933','art_54140','fettanteil_54814','geschmack_23778','geschmack_36384','typ_40821','vendor_1449','vendor_1552','vendor_386','vendor_519','vendor_641','vendor_665','art_36991','art_56004','art_6091','coolbox_filter_0','family_1291','fettanteil_54437','geschmack_23769','geschmack_23779','geschmack_36155','geschmack_56650','vendor_1372','vendor_1506','vendor_1592','vendor_666','vendor_972','verpackung_24689','verpackung_3948') 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',
'family_1101', 'art_54139', 'verpackung_42548',
'netto_gewicht_filter_3', 'netto_gewicht_filter_2',
'art_2163', 'fettanteil_54147',
'netto_gewicht_filter_4', 'verpackung_37215',
'art_39784', 'vendor_1316', 'netto_gewicht_filter_5',
'fettanteil_53700', 'verpackung_3609',
'vendor_1455', 'vendor_621', 'verpackung_2870',
'art_54141', 'fettanteil_52040',
'vendor_531', 'vendor_642', 'verpackung_3121',
'vendor_1494', 'vendor_1505', 'verpackung_5933',
'art_54140', 'fettanteil_54814',
'geschmack_23778', 'geschmack_36384',
'typ_40821', 'vendor_1449', 'vendor_1552',
'vendor_386', 'vendor_519', 'vendor_641',
'vendor_665', 'art_36991', 'art_56004',
'art_6091', 'coolbox_filter_0',
'family_1291', 'fettanteil_54437',
'geschmack_23769', 'geschmack_23779',
'geschmack_36155', 'geschmack_56650',
'vendor_1372', 'vendor_1506', 'vendor_1592',
'vendor_666', 'vendor_972', 'verpackung_24689',
'verpackung_3948'
)
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','family_1101','art_54139','verpackung_42548','netto_gewicht_filter_3','netto_gewicht_filter_2','art_2163','fettanteil_54147','netto_gewicht_filter_4','verpackung_37215','art_39784','vendor_1316','netto_gewicht_filter_5','fettanteil_53700','verpackung_3609','vendor_1455','vendor_621','verpackung_2870','art_54141','fettanteil_52040','vendor_531','vendor_642','verpackung_3121','vendor_1494','vendor_1505','verpackung_5933','art_54140','fettanteil_54814','geschmack_23778','geschmack_36384','typ_40821','vendor_1449','vendor_1552','vendor_386','vendor_519','vendor_641','vendor_665','art_36991','art_56004','art_6091','coolbox_filter_0','family_1291','fettanteil_54437','geschmack_23769','geschmack_23779','geschmack_36155','geschmack_56650','vendor_1372','vendor_1506','vendor_1592','vendor_666','vendor_972','verpackung_24689','verpackung_3948') AND a.is_filterable = true;
|