0.18 ms (33.85%)
|
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('sparset_filter_0','family_142','materialgruppierung_1534','modelname_39528','muster_476','serie_24566','materialgruppierung_1522','stil_19443','form_2157','form_2151','hoehe_2913','family_1082','form_2153','grossen_51295','muster_474','form_23503','muster_30503','durchmesser_2075','durchmesser_2076','durchmesser_9722','family_681','grossen_53562','grossen_56429','hoehe_11290','hoehe_3107','laenge_13885','laenge_2555','laenge_3467','laenge_5454','muster_473','serie_53563','durchmesser_2073','durchmesser_3054','form_2154','grossen_11204','grossen_13933','grossen_55430','grossen_55776','hoehe_3115','jahressymbol_56286','muster_1699','muster_30451','muster_30613','muster_31225','muster_31828','serie_11171','serie_16812') 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(
'sparset_filter_0', 'family_142',
'materialgruppierung_1534', 'modelname_39528',
'muster_476', 'serie_24566', 'materialgruppierung_1522',
'stil_19443', 'form_2157', 'form_2151',
'hoehe_2913', 'family_1082', 'form_2153',
'grossen_51295', 'muster_474', 'form_23503',
'muster_30503', 'durchmesser_2075',
'durchmesser_2076', 'durchmesser_9722',
'family_681', 'grossen_53562', 'grossen_56429',
'hoehe_11290', 'hoehe_3107', 'laenge_13885',
'laenge_2555', 'laenge_3467', 'laenge_5454',
'muster_473', 'serie_53563', 'durchmesser_2073',
'durchmesser_3054', 'form_2154',
'grossen_11204', 'grossen_13933',
'grossen_55430', 'grossen_55776',
'hoehe_3115', 'jahressymbol_56286',
'muster_1699', 'muster_30451', 'muster_30613',
'muster_31225', 'muster_31828',
'serie_11171', 'serie_16812'
)
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('sparset_filter_0','family_142','materialgruppierung_1534','modelname_39528','muster_476','serie_24566','materialgruppierung_1522','stil_19443','form_2157','form_2151','hoehe_2913','family_1082','form_2153','grossen_51295','muster_474','form_23503','muster_30503','durchmesser_2075','durchmesser_2076','durchmesser_9722','family_681','grossen_53562','grossen_56429','hoehe_11290','hoehe_3107','laenge_13885','laenge_2555','laenge_3467','laenge_5454','muster_473','serie_53563','durchmesser_2073','durchmesser_3054','form_2154','grossen_11204','grossen_13933','grossen_55430','grossen_55776','hoehe_3115','jahressymbol_56286','muster_1699','muster_30451','muster_30613','muster_31225','muster_31828','serie_11171','serie_16812') AND a.is_filterable = true;
|