| 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('family_692','netto_gewicht_filter_3','art_15477','verpackung_14402','vendor_1296','coolbox_filter_0','freezebox_filter_3','netto_gewicht_filter_4','verpackung_2870','verpackung_5933','vendor_1158','netto_gewicht_filter_5','art_2163','family_682','art_23722','vendor_248','vendor_449','vendor_170','family_926','vendor_386','netto_gewicht_filter_6','typ_23685','vendor_140','netto_gewicht_filter_2','vendor_1323','family_771','vendor_1491','art_15478','vendor_282','vendor_1451','verpackung_35918','vendor_462','art_23723','vendor_490','family_758','vendor_1374','vendor_432','vendor_644','art_29690','vendor_413','netto_gewicht_filter_1','vendor_138','art_14447','vendor_355','vendor_139','verpackung_2954','laenderkueche_43012','vendor_159','vendor_457','typ_33892','typ_55388','vendor_1339','vendor_689','vendor_235','art_36687','art_56675','vendor_902','vendor_743','art_41586','vendor_461','vendor_143') 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(
'family_692', 'netto_gewicht_filter_3',
'art_15477', 'verpackung_14402',
'vendor_1296', 'coolbox_filter_0',
'freezebox_filter_3', 'netto_gewicht_filter_4',
'verpackung_2870', 'verpackung_5933',
'vendor_1158', 'netto_gewicht_filter_5',
'art_2163', 'family_682', 'art_23722',
'vendor_248', 'vendor_449', 'vendor_170',
'family_926', 'vendor_386', 'netto_gewicht_filter_6',
'typ_23685', 'vendor_140', 'netto_gewicht_filter_2',
'vendor_1323', 'family_771', 'vendor_1491',
'art_15478', 'vendor_282', 'vendor_1451',
'verpackung_35918', 'vendor_462',
'art_23723', 'vendor_490', 'family_758',
'vendor_1374', 'vendor_432', 'vendor_644',
'art_29690', 'vendor_413', 'netto_gewicht_filter_1',
'vendor_138', 'art_14447', 'vendor_355',
'vendor_139', 'verpackung_2954',
'laenderkueche_43012', 'vendor_159',
'vendor_457', 'typ_33892', 'typ_55388',
'vendor_1339', 'vendor_689', 'vendor_235',
'art_36687', 'art_56675', 'vendor_902',
'vendor_743', 'art_41586', 'vendor_461',
'vendor_143'
)
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('family_692','netto_gewicht_filter_3','art_15477','verpackung_14402','vendor_1296','coolbox_filter_0','freezebox_filter_3','netto_gewicht_filter_4','verpackung_2870','verpackung_5933','vendor_1158','netto_gewicht_filter_5','art_2163','family_682','art_23722','vendor_248','vendor_449','vendor_170','family_926','vendor_386','netto_gewicht_filter_6','typ_23685','vendor_140','netto_gewicht_filter_2','vendor_1323','family_771','vendor_1491','art_15478','vendor_282','vendor_1451','verpackung_35918','vendor_462','art_23723','vendor_490','family_758','vendor_1374','vendor_432','vendor_644','art_29690','vendor_413','netto_gewicht_filter_1','vendor_138','art_14447','vendor_355','vendor_139','verpackung_2954','laenderkueche_43012','vendor_159','vendor_457','typ_33892','typ_55388','vendor_1339','vendor_689','vendor_235','art_36687','art_56675','vendor_902','vendor_743','art_41586','vendor_461','vendor_143') AND a.is_filterable = true;
|