0.17 ms (11.75%)
|
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('coolbox_filter_0','freezebox_filter_3','netto_gewicht_filter_3','art_der_suessigkeiten_39960','family_1168','verpackung_2870','verpackung_35918','art_der_suessigkeiten_36995','family_1114','art_57036','art_23723','netto_gewicht_filter_2','netto_gewicht_filter_4','fuellung_36388','vendor_179','verpackung_3948','geschmack_23781','geschmack_29768','verpackung_3121','art_56994','geschmack_35745','geschmack_36384','vendor_1348','vendor_135','vendor_196','vendor_380','aroma_13964','fuellung_39832','fuellung_46951','fuellung_55284','geschmack_23747','geschmack_23753','geschmack_25688','geschmack_26932','geschmack_36155','netto_gewicht_filter_5','vendor_1229','vendor_1409','vendor_1537','vendor_259','vendor_348','vendor_458','vendor_490','vendor_529','vendor_881','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(
'coolbox_filter_0', 'freezebox_filter_3',
'netto_gewicht_filter_3', 'art_der_suessigkeiten_39960',
'family_1168', 'verpackung_2870',
'verpackung_35918', 'art_der_suessigkeiten_36995',
'family_1114', 'art_57036', 'art_23723',
'netto_gewicht_filter_2', 'netto_gewicht_filter_4',
'fuellung_36388', 'vendor_179',
'verpackung_3948', 'geschmack_23781',
'geschmack_29768', 'verpackung_3121',
'art_56994', 'geschmack_35745',
'geschmack_36384', 'vendor_1348',
'vendor_135', 'vendor_196', 'vendor_380',
'aroma_13964', 'fuellung_39832',
'fuellung_46951', 'fuellung_55284',
'geschmack_23747', 'geschmack_23753',
'geschmack_25688', 'geschmack_26932',
'geschmack_36155', 'netto_gewicht_filter_5',
'vendor_1229', 'vendor_1409', 'vendor_1537',
'vendor_259', 'vendor_348', 'vendor_458',
'vendor_490', 'vendor_529', 'vendor_881',
'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('coolbox_filter_0','freezebox_filter_3','netto_gewicht_filter_3','art_der_suessigkeiten_39960','family_1168','verpackung_2870','verpackung_35918','art_der_suessigkeiten_36995','family_1114','art_57036','art_23723','netto_gewicht_filter_2','netto_gewicht_filter_4','fuellung_36388','vendor_179','verpackung_3948','geschmack_23781','geschmack_29768','verpackung_3121','art_56994','geschmack_35745','geschmack_36384','vendor_1348','vendor_135','vendor_196','vendor_380','aroma_13964','fuellung_39832','fuellung_46951','fuellung_55284','geschmack_23747','geschmack_23753','geschmack_25688','geschmack_26932','geschmack_36155','netto_gewicht_filter_5','vendor_1229','vendor_1409','vendor_1537','vendor_259','vendor_348','vendor_458','vendor_490','vendor_529','vendor_881','verpackung_14402') AND a.is_filterable = true;
|