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 (
    96593, 96592, 96591, 96590, 96589, 97405, 
    96929, 96736, 96616, 94871, 97239, 
    97237, 96984, 96622, 97235, 97234, 
    97213, 97177, 97176, 97175
  ) 
  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
94871 hardhouse,filth,harddance,dance,dancemusic hardhouse,filth,harddance,dance,dancemusic hardhouse,filth,harddance,dance,dancemusic
96589 Cheek532,Cheeky Tracks,Rick James
96590 Cheek532,Cheeky Tracks,Rick James
96591 Cheek532,Cheeky Tracks,TMI,Rick James
96592 Cheek532,Cheeky Tracks,TMI,Rick James
96593 Cheek532,Cheeky Tracks,Rick James
96616
96622 BTN013,Bring The Noise Recordings,Boris The Noss
96736 James Nardi, Hard House James Nardi, Hard House James Nardi, Hard House
96929 BMRS01,Beast Mode Recordings,Kidbull,NuroGL
96984 NFR009,Fevah Records,Steve Blake,Riksta,James Nardi
97175 Tekneak,War,Hard,House,Hoover,Acid,Savage,Nrg,Barbarian Tekneak,War,Hard,House,Hoover,Acid,Savage,Nrg,Barbarian
97176
97177
97213 Visceral, charged, Visceral Charged, Lok_E, Hard House, Hard Trance, Hard, House, Trance Coming hot in with VR Charged's latest tune is The Unseen...this is a master blaster of epic proportions. Buckle up buttercup, its about to get real! Visceral, charged, Visceral Charged, Lok_E, Hard House, Hard Trance, Hard, House, Trance
97234 https://www.facebook.com/search/top?q=global%20awakening%20records Kieran B, Much Better
97235 https://www.facebook.com/search/top?q=global%20awakening%20records Dean Richardson,Much Better, Global Awakening Records
97237 Kaki Raphael, so, sooo, dirty, Kaki trax Kaki Raphael, so, sooo, dirty, Kaki trax
97239
97405 The Medicine,DeXiTroN,Zealous,HardHouse, The Medicine,DeXiTroN,Zealous,HardHouse