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 (
    94130, 94129, 92909, 94092, 94091, 94090, 
    94089, 94048, 93759, 93510, 93264, 
    93263, 93262, 93261, 93260, 93259, 
    93258, 89226, 93946, 93940
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00038

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
89226
92909 Jody 6, Dance M.Fs, Vicious Circle, Exclusive, Toolbox Digital Download Dance M.Fs by Vicious Circle from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more.
93258 Cheek515,Cheeky Tracks,Danny Gibson
93259 Cheek515,Cheeky Tracks,Danny Gibson
93260 Cheek515,Cheeky Tracks,Danny Gibson
93261 Cheek515,Cheeky Tracks,Danny Gibson
93262 Cheek515,Cheeky Tracks,Danny Gibson
93263 Cheek515,Cheeky Tracks,Danny Gibson
93264 HOT082,Hot Box Digital,StuartM
93510 Mobi D, Frantic Digital, Hard House, The Outer Limits Mobi D, Frantic Digital, Hard House, The Outer Limits
93759 The Prophet,Get a Grip,Tuff Groove,Hard House The Prophet - Get A Grip - Tuff Groove Recordings #075 The Prophet,Get a Grip,Tuff Groove,Hard House
93940 global,awakening,homzy
93946
94048 Ross, Farley, Visceral, Visceral Records, Hard House, Hard, Trance, Hard Trance, Hoover An absolute MELTER of a tune from VR founder Ross Farley...biiigg sweeping trance vibes followed by down n' dirty hoovers. Just an absolute must have Ross, Farley, Visceral, Visceral Records, Hard House, Hard, Trance, Hard Trance, Hoover
94089 Random but Raw, Orrible Noize, Hard House, NRG
94090
94091 Boski,screaming,Jim,hard,nrg,house, Boski,screaming,Jim,hard,nrg,house,
94092 Be With You DJ Serenty Energy Source Productions Hard House Be With You DJ Serenty Energy Source Productions Hard House Be With You DJ Serenty Energy Source Productions Hard House
94129 pat,glenny,ben,vennard,rupture,pitch,drift,recordings pat,glenny,ben,vennard,rupture,pitch,drift,recordings pat,glenny,ben,vennard,rupture,pitch,drift,recordings
94130 Ben Vennard, Pat Glenny, Team Sly, Rupture, Pitch Drift Records, Exclusive, Toolbox Digital Download Rupture by Pitch Drift Records from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. pat,glenny,ben,vennard,rupture,pitch,drift,recordings,teamsly