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 (
    91821, 92682, 89223, 92807, 92769, 92768, 
    92767, 92760, 92759, 92757, 92256, 
    92572, 92523, 92280, 92259, 92237, 
    92674, 92571, 92524, 92460
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00053

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
89223
91821 Inner City Sumo, Frantic Digital, Hard House, Look Back Inner City Sumo, Frantic Digital, Hard House, Look Back
92237 GHH001,Global Hard House,Dean Richardson
92256 BMR210,Beast Mode Recordings,Renshi
92259 HOT079,Hot Box Digital,Team Sly,Bizarre Q
92280
92460 Jay Lyth, Cupra, Belt Up, slingshot, Jay Lyth, Cupra, Belt Up, slingshot,
92523 Hard trance, hard house, gwr, g.w.r, g.w.r., hard dance, sugar skull, carl pearce, cheryl pearce, Sugar Skull Digital is premuim hard house and hard trance label, releasing the best tracks in hard dance today. Hard trance, hard house, gwr, g.w.r, g.w.r., hard dance, sugar skull, carl pearce, cheryl pearce,
92524
92571 Base Graffiti, Band Saw Suzy, Kaktai Records, Exclusive, Toolbox Digital Download Band Saw Suzy by Kaktai Records from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more.
92572
92674 Hard House, NRG, American Hard House, Charged This is a cover of a track from a band I have admired for many years. One with an all-true, tragic ending. Linkin Speaks. Visceral, Visceral Records, NUROGL, Ross Farley, Charged, High Energy
92682 DirtyBoy Productions,Puddle of Pumping,Hard House DirtyBoy Productions,Puddle of Pumping,Hard House
92757 Tomcat, State Of Motion, Kaktai Records, Pat Glenny Remix, Exclusive, Toolbox Digital Download State Of Motion (Pat Glenny Remix) by Kaktai Records from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more.
92759
92760 Tekneak, Burning Blade, Lo Pan Tekneak, Burning Blade, Lo Pan
92767
92768
92769
92807