0.19 ms (10.28%)
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' , 'family_688' , 'freezebox_filter_3' , 'verpackung_2870' , 'netto_gewicht_filter_3' , 'netto_gewicht_filter_4' , 'verpackung_2954' , 'art_29787' , 'art_29786' , 'geschmack_23761' , 'vendor_424' , 'art_29791' , 'art_55436' , 'fuellung_36365' , 'geschmack_26932' , 'netto_gewicht_filter_2' , 'art_29796' , 'art_36372' , 'geschmack_23765' , 'vendor_156' , 'fuellung_39590' , 'geschmack_23757' , 'vendor_579' , 'geschmack_26601' , 'geschmack_36384' , 'vendor_149' , 'vendor_216' , 'vendor_458' , 'verpackung_4003' , 'art_39627' , 'vendor_1459' , 'verpackung_3121' , 'verpackung_9455' , 'vendor_1207' , 'vendor_1409' , 'vendor_179' , 'vendor_834' , 'verpackung_3948' , 'art_29792' , 'geschmack_36155' , 'netto_gewicht_filter_5' , 'vendor_1435' , 'vendor_582' , 'vendor_759' , 'art_29788' , 'art_55667' , 'fuellung_36364' , 'fuellung_39647' , 'fuellung_51760' , 'geschmack_23781' , 'geschmack_52741' , 'netto_gewicht_filter_1' , 'serie_51965' , 'serie_55666' , 'vendor_1106' , 'vendor_1214' , 'vendor_1241' , 'vendor_196' , 'vendor_224' , 'vendor_577' , 'vendor_897' , 'verpackung_14402' , 'art_29789' , 'fuellung_36847' , 'fuellung_39485' , 'fuellung_39651' , 'fuellung_51734' , 'fuellung_54104' , 'fuellung_55786' , 'geschmack_23747' , 'geschmack_23753' , 'geschmack_25688' , 'geschmack_29765' , 'geschmack_36009' , 'geschmack_36380' , 'geschmack_36381' , 'geschmack_42730' , 'vendor_166' , 'vendor_200' , 'vendor_531' , 'vendor_573' , 'art_29790' , 'art_54636' , 'fuellung_29777' , 'fuellung_39488' , 'fuellung_39832' , 'fuellung_51969' , 'fuellung_52241' , 'fuellung_53397' , 'fuellung_54431' , 'fuellung_54798' , 'fuellung_55123' , 'geschmack_23754' , 'geschmack_23756' , 'geschmack_23758' , 'geschmack_23759' , 'geschmack_23762' , 'geschmack_23766' , 'geschmack_23774' , 'geschmack_23776' , 'geschmack_26600' , 'geschmack_26602' , 'geschmack_29768' , 'geschmack_31753' , 'geschmack_32270' , 'geschmack_35745' , 'geschmack_39953' , 'geschmack_45116' , 'serie_54773' , 'vendor_1077' , 'vendor_114' , 'vendor_1327' , 'vendor_1382' , 'vendor_158' , 'vendor_171' , 'vendor_261' , 'vendor_271' , 'vendor_305' , 'vendor_336' , 'vendor_381' , 'vendor_408' , 'vendor_437' , 'vendor_566' , 'vendor_580' , 'vendor_581' , 'vendor_923' , 'vendor_954' ) 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' ,
'family_688' ,
'freezebox_filter_3' ,
'verpackung_2870' ,
'netto_gewicht_filter_3' ,
'netto_gewicht_filter_4' ,
'verpackung_2954' ,
'art_29787' ,
'art_29786' ,
'geschmack_23761' ,
'vendor_424' ,
'art_29791' ,
'art_55436' ,
'fuellung_36365' ,
'geschmack_26932' ,
'netto_gewicht_filter_2' ,
'art_29796' ,
'art_36372' ,
'geschmack_23765' ,
'vendor_156' ,
'fuellung_39590' ,
'geschmack_23757' ,
'vendor_579' ,
'geschmack_26601' ,
'geschmack_36384' ,
'vendor_149' ,
'vendor_216' ,
'vendor_458' ,
'verpackung_4003' ,
'art_39627' ,
'vendor_1459' ,
'verpackung_3121' ,
'verpackung_9455' ,
'vendor_1207' ,
'vendor_1409' ,
'vendor_179' ,
'vendor_834' ,
'verpackung_3948' ,
'art_29792' ,
'geschmack_36155' ,
'netto_gewicht_filter_5' ,
'vendor_1435' ,
'vendor_582' ,
'vendor_759' ,
'art_29788' ,
'art_55667' ,
'fuellung_36364' ,
'fuellung_39647' ,
'fuellung_51760' ,
'geschmack_23781' ,
'geschmack_52741' ,
'netto_gewicht_filter_1' ,
'serie_51965' ,
'serie_55666' ,
'vendor_1106' ,
'vendor_1214' ,
'vendor_1241' ,
'vendor_196' ,
'vendor_224' ,
'vendor_577' ,
'vendor_897' ,
'verpackung_14402' ,
'art_29789' ,
'fuellung_36847' ,
'fuellung_39485' ,
'fuellung_39651' ,
'fuellung_51734' ,
'fuellung_54104' ,
'fuellung_55786' ,
'geschmack_23747' ,
'geschmack_23753' ,
'geschmack_25688' ,
'geschmack_29765' ,
'geschmack_36009' ,
'geschmack_36380' ,
'geschmack_36381' ,
'geschmack_42730' ,
'vendor_166' ,
'vendor_200' ,
'vendor_531' ,
'vendor_573' ,
'art_29790' ,
'art_54636' ,
'fuellung_29777' ,
'fuellung_39488' ,
'fuellung_39832' ,
'fuellung_51969' ,
'fuellung_52241' ,
'fuellung_53397' ,
'fuellung_54431' ,
'fuellung_54798' ,
'fuellung_55123' ,
'geschmack_23754' ,
'geschmack_23756' ,
'geschmack_23758' ,
'geschmack_23759' ,
'geschmack_23762' ,
'geschmack_23766' ,
'geschmack_23774' ,
'geschmack_23776' ,
'geschmack_26600' ,
'geschmack_26602' ,
'geschmack_29768' ,
'geschmack_31753' ,
'geschmack_32270' ,
'geschmack_35745' ,
'geschmack_39953' ,
'geschmack_45116' ,
'serie_54773' ,
'vendor_1077' ,
'vendor_114' ,
'vendor_1327' ,
'vendor_1382' ,
'vendor_158' ,
'vendor_171' ,
'vendor_261' ,
'vendor_271' ,
'vendor_305' ,
'vendor_336' ,
'vendor_381' ,
'vendor_408' ,
'vendor_437' ,
'vendor_566' ,
'vendor_580' ,
'vendor_581' ,
'vendor_923' ,
'vendor_954'
)
AND a . is_filterable = true
Copy
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' , 'family_688' , 'freezebox_filter_3' , 'verpackung_2870' , 'netto_gewicht_filter_3' , 'netto_gewicht_filter_4' , 'verpackung_2954' , 'art_29787' , 'art_29786' , 'geschmack_23761' , 'vendor_424' , 'art_29791' , 'art_55436' , 'fuellung_36365' , 'geschmack_26932' , 'netto_gewicht_filter_2' , 'art_29796' , 'art_36372' , 'geschmack_23765' , 'vendor_156' , 'fuellung_39590' , 'geschmack_23757' , 'vendor_579' , 'geschmack_26601' , 'geschmack_36384' , 'vendor_149' , 'vendor_216' , 'vendor_458' , 'verpackung_4003' , 'art_39627' , 'vendor_1459' , 'verpackung_3121' , 'verpackung_9455' , 'vendor_1207' , 'vendor_1409' , 'vendor_179' , 'vendor_834' , 'verpackung_3948' , 'art_29792' , 'geschmack_36155' , 'netto_gewicht_filter_5' , 'vendor_1435' , 'vendor_582' , 'vendor_759' , 'art_29788' , 'art_55667' , 'fuellung_36364' , 'fuellung_39647' , 'fuellung_51760' , 'geschmack_23781' , 'geschmack_52741' , 'netto_gewicht_filter_1' , 'serie_51965' , 'serie_55666' , 'vendor_1106' , 'vendor_1214' , 'vendor_1241' , 'vendor_196' , 'vendor_224' , 'vendor_577' , 'vendor_897' , 'verpackung_14402' , 'art_29789' , 'fuellung_36847' , 'fuellung_39485' , 'fuellung_39651' , 'fuellung_51734' , 'fuellung_54104' , 'fuellung_55786' , 'geschmack_23747' , 'geschmack_23753' , 'geschmack_25688' , 'geschmack_29765' , 'geschmack_36009' , 'geschmack_36380' , 'geschmack_36381' , 'geschmack_42730' , 'vendor_166' , 'vendor_200' , 'vendor_531' , 'vendor_573' , 'art_29790' , 'art_54636' , 'fuellung_29777' , 'fuellung_39488' , 'fuellung_39832' , 'fuellung_51969' , 'fuellung_52241' , 'fuellung_53397' , 'fuellung_54431' , 'fuellung_54798' , 'fuellung_55123' , 'geschmack_23754' , 'geschmack_23756' , 'geschmack_23758' , 'geschmack_23759' , 'geschmack_23762' , 'geschmack_23766' , 'geschmack_23774' , 'geschmack_23776' , 'geschmack_26600' , 'geschmack_26602' , 'geschmack_29768' , 'geschmack_31753' , 'geschmack_32270' , 'geschmack_35745' , 'geschmack_39953' , 'geschmack_45116' , 'serie_54773' , 'vendor_1077' , 'vendor_114' , 'vendor_1327' , 'vendor_1382' , 'vendor_158' , 'vendor_171' , 'vendor_261' , 'vendor_271' , 'vendor_305' , 'vendor_336' , 'vendor_381' , 'vendor_408' , 'vendor_437' , 'vendor_566' , 'vendor_580' , 'vendor_581' , 'vendor_923' , 'vendor_954' ) AND a . is_filterable = true ;
Copy