0.20 ms (3.69%)
|
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','materialgruppierung_23844','family_62','coolbox_filter_0','freezebox_filter_3','groesse_3393','groesse_3394','family_693','beschriftungssprache_25379','family_376','inschrift_23460','vendor_1258','art_der_suessigkeiten_34384','muster_473','family_61','materialgruppierung_1535','hoehe_3085','materialgruppierung_1534','family_27','family_370','form_2154','inschrift_22405','materialgruppierung_1527','materialgruppierung_2386','serie_16812','vendor_196','family_594','inschrift_23487','vendor_1292','art_der_suessigkeiten_34102','art_der_suessigkeiten_35208','family_148','family_180','family_184','family_207','form_2151','inschrift_22385','inschrift_47123','materialgruppierung_33495','serie_33808','vendor_1240','vendor_267','art_der_suessigkeiten_39991','art_der_suessigkeiten_40018','family_183','family_418','family_760','form_2152','grossen_38329','grossen_4268','grossen_5287','grossen_54132','grossen_5922','inschrift_22366','inschrift_22407','inschrift_32534','materialgruppierung_17837','materialgruppierung_2325','modelname_26175','modelname_26466','serie_37737','sparset_filter_1','stil_4873','vendor_1440','vendor_158','vendor_162','vendor_179','vendor_230','vendor_42','volumen_der_tasse_5448','durchmesser_2076','durchmesser_3073','durchmesser_3078','durchmesser_3100','durchmesser_3978','durchmesser_4069','family_324','family_325','family_65','family_716','family_98','form_2157','groesse_1013','groesse_4188','groesse_8761','grossen_17912','grossen_17913','grossen_47194','grossen_53509','grossen_6240','grossen_7604','grossen_7616','grossen_7626','inschrift_22408','inschrift_22414','inschrift_26753','inschrift_32535','koerpermaterial_5409','koerpermaterial_5410','leistung_663','materialgruppierung_1521','modelname_22799','modelname_22803','modelname_24744','modelname_25333','modelname_25364','modelname_25372','modelname_25373','modelname_25633','modelname_26156','modelname_26171','modelname_27876','modelname_27885','modelname_30332','modelname_30390','modelname_32500','modelname_32505','modelname_32506','modelname_32507','modelname_32508','modelname_32509','modelname_32510','modelname_32511','modelname_32512','modelname_32514','modelname_32515','modelname_32516','modelname_32517','modelname_32518','modelname_32519','modelname_32520','modelname_32521','modelname_32522','modelname_32523','modelname_32524','modelname_32525','modelname_32526','modelname_32529','modelname_32530','modelname_32531','modelname_32533','modelname_36719','modelname_36775','modelname_37745','modelname_37747','modelname_38189','modelname_38194','modelname_38195','modelname_41231','modelname_41234','modelname_41235','modelname_53056','modelname_54587','modelname_54588','modelname_54589','modelname_56049','muster_13186','muster_4576','muster_4585','muster_474','muster_5149','muster_7594','muster_9060','serie_16817','serie_24484','serie_24544','serie_36315','serie_51454','serie_51455','serie_51456','serie_9910','steuerungsart_5031','stil_7836','vendor_1232','vendor_134','vendor_1354','vendor_1433','vendor_1441','vendor_152','vendor_156','vendor_216','vendor_316','vendor_441','vendor_529','vendor_685','vendor_695') 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',
'materialgruppierung_23844',
'family_62',
'coolbox_filter_0',
'freezebox_filter_3',
'groesse_3393',
'groesse_3394',
'family_693',
'beschriftungssprache_25379',
'family_376',
'inschrift_23460',
'vendor_1258',
'art_der_suessigkeiten_34384',
'muster_473',
'family_61',
'materialgruppierung_1535',
'hoehe_3085',
'materialgruppierung_1534',
'family_27',
'family_370',
'form_2154',
'inschrift_22405',
'materialgruppierung_1527',
'materialgruppierung_2386',
'serie_16812',
'vendor_196',
'family_594',
'inschrift_23487',
'vendor_1292',
'art_der_suessigkeiten_34102',
'art_der_suessigkeiten_35208',
'family_148',
'family_180',
'family_184',
'family_207',
'form_2151',
'inschrift_22385',
'inschrift_47123',
'materialgruppierung_33495',
'serie_33808',
'vendor_1240',
'vendor_267',
'art_der_suessigkeiten_39991',
'art_der_suessigkeiten_40018',
'family_183',
'family_418',
'family_760',
'form_2152',
'grossen_38329',
'grossen_4268',
'grossen_5287',
'grossen_54132',
'grossen_5922',
'inschrift_22366',
'inschrift_22407',
'inschrift_32534',
'materialgruppierung_17837',
'materialgruppierung_2325',
'modelname_26175',
'modelname_26466',
'serie_37737',
'sparset_filter_1',
'stil_4873',
'vendor_1440',
'vendor_158',
'vendor_162',
'vendor_179',
'vendor_230',
'vendor_42',
'volumen_der_tasse_5448',
'durchmesser_2076',
'durchmesser_3073',
'durchmesser_3078',
'durchmesser_3100',
'durchmesser_3978',
'durchmesser_4069',
'family_324',
'family_325',
'family_65',
'family_716',
'family_98',
'form_2157',
'groesse_1013',
'groesse_4188',
'groesse_8761',
'grossen_17912',
'grossen_17913',
'grossen_47194',
'grossen_53509',
'grossen_6240',
'grossen_7604',
'grossen_7616',
'grossen_7626',
'inschrift_22408',
'inschrift_22414',
'inschrift_26753',
'inschrift_32535',
'koerpermaterial_5409',
'koerpermaterial_5410',
'leistung_663',
'materialgruppierung_1521',
'modelname_22799',
'modelname_22803',
'modelname_24744',
'modelname_25333',
'modelname_25364',
'modelname_25372',
'modelname_25373',
'modelname_25633',
'modelname_26156',
'modelname_26171',
'modelname_27876',
'modelname_27885',
'modelname_30332',
'modelname_30390',
'modelname_32500',
'modelname_32505',
'modelname_32506',
'modelname_32507',
'modelname_32508',
'modelname_32509',
'modelname_32510',
'modelname_32511',
'modelname_32512',
'modelname_32514',
'modelname_32515',
'modelname_32516',
'modelname_32517',
'modelname_32518',
'modelname_32519',
'modelname_32520',
'modelname_32521',
'modelname_32522',
'modelname_32523',
'modelname_32524',
'modelname_32525',
'modelname_32526',
'modelname_32529',
'modelname_32530',
'modelname_32531',
'modelname_32533',
'modelname_36719',
'modelname_36775',
'modelname_37745',
'modelname_37747',
'modelname_38189',
'modelname_38194',
'modelname_38195',
'modelname_41231',
'modelname_41234',
'modelname_41235',
'modelname_53056',
'modelname_54587',
'modelname_54588',
'modelname_54589',
'modelname_56049',
'muster_13186',
'muster_4576',
'muster_4585',
'muster_474',
'muster_5149',
'muster_7594',
'muster_9060',
'serie_16817',
'serie_24484',
'serie_24544',
'serie_36315',
'serie_51454',
'serie_51455',
'serie_51456',
'serie_9910',
'steuerungsart_5031',
'stil_7836',
'vendor_1232',
'vendor_134',
'vendor_1354',
'vendor_1433',
'vendor_1441',
'vendor_152',
'vendor_156',
'vendor_216',
'vendor_316',
'vendor_441',
'vendor_529',
'vendor_685',
'vendor_695'
)
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','materialgruppierung_23844','family_62','coolbox_filter_0','freezebox_filter_3','groesse_3393','groesse_3394','family_693','beschriftungssprache_25379','family_376','inschrift_23460','vendor_1258','art_der_suessigkeiten_34384','muster_473','family_61','materialgruppierung_1535','hoehe_3085','materialgruppierung_1534','family_27','family_370','form_2154','inschrift_22405','materialgruppierung_1527','materialgruppierung_2386','serie_16812','vendor_196','family_594','inschrift_23487','vendor_1292','art_der_suessigkeiten_34102','art_der_suessigkeiten_35208','family_148','family_180','family_184','family_207','form_2151','inschrift_22385','inschrift_47123','materialgruppierung_33495','serie_33808','vendor_1240','vendor_267','art_der_suessigkeiten_39991','art_der_suessigkeiten_40018','family_183','family_418','family_760','form_2152','grossen_38329','grossen_4268','grossen_5287','grossen_54132','grossen_5922','inschrift_22366','inschrift_22407','inschrift_32534','materialgruppierung_17837','materialgruppierung_2325','modelname_26175','modelname_26466','serie_37737','sparset_filter_1','stil_4873','vendor_1440','vendor_158','vendor_162','vendor_179','vendor_230','vendor_42','volumen_der_tasse_5448','durchmesser_2076','durchmesser_3073','durchmesser_3078','durchmesser_3100','durchmesser_3978','durchmesser_4069','family_324','family_325','family_65','family_716','family_98','form_2157','groesse_1013','groesse_4188','groesse_8761','grossen_17912','grossen_17913','grossen_47194','grossen_53509','grossen_6240','grossen_7604','grossen_7616','grossen_7626','inschrift_22408','inschrift_22414','inschrift_26753','inschrift_32535','koerpermaterial_5409','koerpermaterial_5410','leistung_663','materialgruppierung_1521','modelname_22799','modelname_22803','modelname_24744','modelname_25333','modelname_25364','modelname_25372','modelname_25373','modelname_25633','modelname_26156','modelname_26171','modelname_27876','modelname_27885','modelname_30332','modelname_30390','modelname_32500','modelname_32505','modelname_32506','modelname_32507','modelname_32508','modelname_32509','modelname_32510','modelname_32511','modelname_32512','modelname_32514','modelname_32515','modelname_32516','modelname_32517','modelname_32518','modelname_32519','modelname_32520','modelname_32521','modelname_32522','modelname_32523','modelname_32524','modelname_32525','modelname_32526','modelname_32529','modelname_32530','modelname_32531','modelname_32533','modelname_36719','modelname_36775','modelname_37745','modelname_37747','modelname_38189','modelname_38194','modelname_38195','modelname_41231','modelname_41234','modelname_41235','modelname_53056','modelname_54587','modelname_54588','modelname_54589','modelname_56049','muster_13186','muster_4576','muster_4585','muster_474','muster_5149','muster_7594','muster_9060','serie_16817','serie_24484','serie_24544','serie_36315','serie_51454','serie_51455','serie_51456','serie_9910','steuerungsart_5031','stil_7836','vendor_1232','vendor_134','vendor_1354','vendor_1433','vendor_1441','vendor_152','vendor_156','vendor_216','vendor_316','vendor_441','vendor_529','vendor_685','vendor_695') AND a.is_filterable = true;
|