0.73 ms (34.21%)
|
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('family_1152','netto_gewicht_filter_1','verpackung_3948','geschmack_23748','vendor_1507','coolbox_filter_0','freezebox_filter_2','geschmack_23765','geschmack_23757','geschmack_42730','geschmack_39953','geschmack_32270','netto_gewicht_filter_4','art_2163','geschmack_23761','vendor_1317','serie_51387','geschmack_26601','vendor_531','verpackung_2870','geschmack_43102','serie_54773','geschmack_26932','geschmack_38999','vendor_1372','vendor_862','vendor_1330','netto_gewicht_filter_5','geschmack_36009','geschmack_25688','geschmack_23755','netto_gewicht_filter_2','geschmack_23756','geschmack_29768','verpackung_4003','geschmack_23753','vendor_1030','geschmack_39945','geschmack_51503','vendor_630','geschmack_39836','geschmack_31753','serie_36417','geschmack_24694') 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_1152', 'netto_gewicht_filter_1',
'verpackung_3948', 'geschmack_23748',
'vendor_1507', 'coolbox_filter_0',
'freezebox_filter_2', 'geschmack_23765',
'geschmack_23757', 'geschmack_42730',
'geschmack_39953', 'geschmack_32270',
'netto_gewicht_filter_4', 'art_2163',
'geschmack_23761', 'vendor_1317',
'serie_51387', 'geschmack_26601',
'vendor_531', 'verpackung_2870',
'geschmack_43102', 'serie_54773',
'geschmack_26932', 'geschmack_38999',
'vendor_1372', 'vendor_862', 'vendor_1330',
'netto_gewicht_filter_5', 'geschmack_36009',
'geschmack_25688', 'geschmack_23755',
'netto_gewicht_filter_2', 'geschmack_23756',
'geschmack_29768', 'verpackung_4003',
'geschmack_23753', 'vendor_1030',
'geschmack_39945', 'geschmack_51503',
'vendor_630', 'geschmack_39836',
'geschmack_31753', 'serie_36417',
'geschmack_24694'
)
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_1152','netto_gewicht_filter_1','verpackung_3948','geschmack_23748','vendor_1507','coolbox_filter_0','freezebox_filter_2','geschmack_23765','geschmack_23757','geschmack_42730','geschmack_39953','geschmack_32270','netto_gewicht_filter_4','art_2163','geschmack_23761','vendor_1317','serie_51387','geschmack_26601','vendor_531','verpackung_2870','geschmack_43102','serie_54773','geschmack_26932','geschmack_38999','vendor_1372','vendor_862','vendor_1330','netto_gewicht_filter_5','geschmack_36009','geschmack_25688','geschmack_23755','netto_gewicht_filter_2','geschmack_23756','geschmack_29768','verpackung_4003','geschmack_23753','vendor_1030','geschmack_39945','geschmack_51503','vendor_630','geschmack_39836','geschmack_31753','serie_36417','geschmack_24694') AND a.is_filterable = true;
|