| 3 |
0.19 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('freezebox_filter_3','family_1035','coolbox_filter_0','netto_gewicht_filter_1','verpackung_2870','art_54697','netto_gewicht_filter_3','vendor_679','fischart_43299','art_2163','verpackung_37215','art_54698','coolbox_filter_1','fischart_29740','vendor_678','family_1220','fischart_43325','vendor_1032','vendor_1371','vendor_1406','verpackung_35918','verpackung_5933','art_54694','fischart_29660','fischart_29998','fischart_43293','verpackung_3121','art_39784','fischart_29659','fischart_36125','fischart_43320','fischart_54769','netto_gewicht_filter_4','vendor_1312','vendor_357','vendor_757','verpackung_3948','art_54695','fischart_29663','fischart_29999','fischart_37803','fischart_43337','fischart_52492','fischart_52914','fischart_53083','fischart_56343','freezebox_filter_2','netto_gewicht_filter_2','typ_37811','typ_37822','vendor_1179','vendor_1255','vendor_910','vendor_944','verpackung_14402') 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', 'family_1035',
'coolbox_filter_0', 'netto_gewicht_filter_1',
'verpackung_2870', 'art_54697',
'netto_gewicht_filter_3', 'vendor_679',
'fischart_43299', 'art_2163', 'verpackung_37215',
'art_54698', 'coolbox_filter_1',
'fischart_29740', 'vendor_678',
'family_1220', 'fischart_43325',
'vendor_1032', 'vendor_1371', 'vendor_1406',
'verpackung_35918', 'verpackung_5933',
'art_54694', 'fischart_29660', 'fischart_29998',
'fischart_43293', 'verpackung_3121',
'art_39784', 'fischart_29659', 'fischart_36125',
'fischart_43320', 'fischart_54769',
'netto_gewicht_filter_4', 'vendor_1312',
'vendor_357', 'vendor_757', 'verpackung_3948',
'art_54695', 'fischart_29663', 'fischart_29999',
'fischart_37803', 'fischart_43337',
'fischart_52492', 'fischart_52914',
'fischart_53083', 'fischart_56343',
'freezebox_filter_2', 'netto_gewicht_filter_2',
'typ_37811', 'typ_37822', 'vendor_1179',
'vendor_1255', 'vendor_910', 'vendor_944',
'verpackung_14402'
)
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','family_1035','coolbox_filter_0','netto_gewicht_filter_1','verpackung_2870','art_54697','netto_gewicht_filter_3','vendor_679','fischart_43299','art_2163','verpackung_37215','art_54698','coolbox_filter_1','fischart_29740','vendor_678','family_1220','fischart_43325','vendor_1032','vendor_1371','vendor_1406','verpackung_35918','verpackung_5933','art_54694','fischart_29660','fischart_29998','fischart_43293','verpackung_3121','art_39784','fischart_29659','fischart_36125','fischart_43320','fischart_54769','netto_gewicht_filter_4','vendor_1312','vendor_357','vendor_757','verpackung_3948','art_54695','fischart_29663','fischart_29999','fischart_37803','fischart_43337','fischart_52492','fischart_52914','fischart_53083','fischart_56343','freezebox_filter_2','netto_gewicht_filter_2','typ_37811','typ_37822','vendor_1179','vendor_1255','vendor_910','vendor_944','verpackung_14402') AND a.is_filterable = true;
|