SELECT 
  cscart_product_descriptions.product_id, 
  cscart_product_descriptions.short_description, 
  IF(
    cscart_product_descriptions.short_description = '' 
    OR cscart_product_descriptions.short_description IS NULL, 
    cscart_product_descriptions.full_description, 
    ''
  ) AS full_description, 
  cscart_product_descriptions.meta_keywords, 
  cscart_product_descriptions.meta_description, 
  cscart_product_descriptions.search_words, 
  cscart_product_descriptions.promo_text 
FROM 
  cscart_product_descriptions 
WHERE 
  cscart_product_descriptions.product_id IN (
    91827, 91796, 91825, 91824, 91823, 91808, 
    91807, 91806, 91805, 91804, 91803, 
    91639, 91600, 91537, 91535, 91425, 
    91025, 90894, 90888, 90881
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00034

Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE cscart_product_descriptions range PRIMARY,product_id PRIMARY 9 20 Using where

Result

product_id short_description full_description meta_keywords meta_description search_words promo_text
90881 ED006,Epidemic Digital,Matt Wade,Matty Tweed
90888 PMD035,Pumped,Dave H,Joe Longbottom
90894 HOT078,Hot Box Digital,Paul Reeves
91025 UTHHD043,Ultratech,Boski
91425 DBD52,Drop Bear Digital ,Narc,TripleXXX
91535
91537 Kaki Raphael, Bangkok, Chickboys, Kaki Trax Kaki Raphael, Bangkok, Chickboys, Kaki Trax
91600 RPR192, Grady, G, Pharmakia, Raw Power, hard house, filth, hoovers, NRG, King of filth Raw Power is pleased to present 'Pharmakia' by The King of filth, Grady G as he makes his debut on the label, as part of the run up to the 200th release next year! Grady certainly delivers, and this time is no exception! A monster end of the night NRG tra RPR192, Grady, G, Pharmakia, Raw Power, hard house, filth, hoovers, NRG, King of filth
91639
91796 Batten,Daddy Old Skool,Let's Have It,Tuff Groove Tune alert!! Daddy Old Skool lends his dulcet tones to a monster track - ripping up dance-floors / live-streams alike! Batten,Daddy Old Skool,Let's Have It,Tuff Groove
91803
91804
91805 Dynamic intervention,Time,Dip Dynamic intervention-Time,Dip Recordings Dynamic intervention,Time,Dip
91806 Burning Blade, Tara N, Burning Blade, Tara N,
91807 Burning Blade, Tara N, Burning Blade, Tara N,
91808 Burning Blade, Tara N, Tekneak Burning Blade, Tara N, Tekneak
91823 terrbang,hard,house,toolboxdigital,Ross,homson,the,commander terrbang,hard,house,toolboxdigital,Ross,homson,the,commander
91824 terrbang,hard,house,toolboxdigital,ross,homson,got,the,flow terrbang,hard,house,toolboxdigital,ross,homson,got,the,flow
91825 terrbang,hard,house,toolboxdigital,ross,homson,run,for,cover terrbang,hard,house,toolboxdigital,ross,homson,run,for,cover
91827