| 3 |
0.17 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_376','netto_gewicht_filter_2','verpackung_3154','verpackung_26798','handelsform_3534','sorte_3536','sorte_15484','aroma_55191','vendor_1258','coolbox_filter_0','freezebox_filter_3','feiertage_819','feiertage_820','feiertage_960','verpackung_2954','handelsform_3535','vendor_1104','netto_gewicht_filter_1','aroma_17796','vendor_1289','aroma_13964','aroma_4975','aroma_3539','aroma_55389','netto_gewicht_filter_3','art_2163','vendor_316','netto_gewicht_filter_4','verpackung_4003','sorte_26188','aroma_3546','vendor_1135','vendor_1213','vendor_743','sorte_45806','aroma_4227','aroma_11395','aroma_53980','handelsform_27113','vendor_192','sorte_19469','aroma_23887','vendor_1441','vendor_1440','aroma_24243','vendor_1137','aroma_4976','aroma_39184','vendor_553','aroma_7551','vendor_1354','family_886','art_52277','vendor_552','sorte_51687','aroma_39201','vendor_247','aroma_17795','verpackung_5933','vendor_1252','vendor_186','aroma_6917','verwendungszweck_6536','vendor_1133','art_52271','art_30648','aroma_13957','aroma_26886','art_30652','art_30691','vendor_414','art_30649','beschriftungssprache_25380','vendor_551','vendor_554','vendor_1174','vendor_187','verpackung_2870','vendor_1016','vendor_256','vendor_114','vendor_212','verpackung_24689','vendor_225','verpackung_9455','netto_gewicht_filter_5','vendor_1358','vendor_274','vendor_1325','vendor_900','vendor_1302','art_50978','aroma_30995','feiertage_825','feiertage_826','aroma_23893') 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_376', 'netto_gewicht_filter_2',
'verpackung_3154', 'verpackung_26798',
'handelsform_3534', 'sorte_3536',
'sorte_15484', 'aroma_55191', 'vendor_1258',
'coolbox_filter_0', 'freezebox_filter_3',
'feiertage_819', 'feiertage_820',
'feiertage_960', 'verpackung_2954',
'handelsform_3535', 'vendor_1104',
'netto_gewicht_filter_1', 'aroma_17796',
'vendor_1289', 'aroma_13964', 'aroma_4975',
'aroma_3539', 'aroma_55389', 'netto_gewicht_filter_3',
'art_2163', 'vendor_316', 'netto_gewicht_filter_4',
'verpackung_4003', 'sorte_26188',
'aroma_3546', 'vendor_1135', 'vendor_1213',
'vendor_743', 'sorte_45806', 'aroma_4227',
'aroma_11395', 'aroma_53980', 'handelsform_27113',
'vendor_192', 'sorte_19469', 'aroma_23887',
'vendor_1441', 'vendor_1440', 'aroma_24243',
'vendor_1137', 'aroma_4976', 'aroma_39184',
'vendor_553', 'aroma_7551', 'vendor_1354',
'family_886', 'art_52277', 'vendor_552',
'sorte_51687', 'aroma_39201', 'vendor_247',
'aroma_17795', 'verpackung_5933',
'vendor_1252', 'vendor_186', 'aroma_6917',
'verwendungszweck_6536', 'vendor_1133',
'art_52271', 'art_30648', 'aroma_13957',
'aroma_26886', 'art_30652', 'art_30691',
'vendor_414', 'art_30649', 'beschriftungssprache_25380',
'vendor_551', 'vendor_554', 'vendor_1174',
'vendor_187', 'verpackung_2870',
'vendor_1016', 'vendor_256', 'vendor_114',
'vendor_212', 'verpackung_24689',
'vendor_225', 'verpackung_9455',
'netto_gewicht_filter_5', 'vendor_1358',
'vendor_274', 'vendor_1325', 'vendor_900',
'vendor_1302', 'art_50978', 'aroma_30995',
'feiertage_825', 'feiertage_826',
'aroma_23893'
)
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_376','netto_gewicht_filter_2','verpackung_3154','verpackung_26798','handelsform_3534','sorte_3536','sorte_15484','aroma_55191','vendor_1258','coolbox_filter_0','freezebox_filter_3','feiertage_819','feiertage_820','feiertage_960','verpackung_2954','handelsform_3535','vendor_1104','netto_gewicht_filter_1','aroma_17796','vendor_1289','aroma_13964','aroma_4975','aroma_3539','aroma_55389','netto_gewicht_filter_3','art_2163','vendor_316','netto_gewicht_filter_4','verpackung_4003','sorte_26188','aroma_3546','vendor_1135','vendor_1213','vendor_743','sorte_45806','aroma_4227','aroma_11395','aroma_53980','handelsform_27113','vendor_192','sorte_19469','aroma_23887','vendor_1441','vendor_1440','aroma_24243','vendor_1137','aroma_4976','aroma_39184','vendor_553','aroma_7551','vendor_1354','family_886','art_52277','vendor_552','sorte_51687','aroma_39201','vendor_247','aroma_17795','verpackung_5933','vendor_1252','vendor_186','aroma_6917','verwendungszweck_6536','vendor_1133','art_52271','art_30648','aroma_13957','aroma_26886','art_30652','art_30691','vendor_414','art_30649','beschriftungssprache_25380','vendor_551','vendor_554','vendor_1174','vendor_187','verpackung_2870','vendor_1016','vendor_256','vendor_114','vendor_212','verpackung_24689','vendor_225','verpackung_9455','netto_gewicht_filter_5','vendor_1358','vendor_274','vendor_1325','vendor_900','vendor_1302','art_50978','aroma_30995','feiertage_825','feiertage_826','aroma_23893') AND a.is_filterable = true;
|