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 (
    112082, 112081, 112080, 112079, 112078, 
    112077, 112076, 112075, 112074, 112073, 
    112072, 112071, 112070, 112069, 112068, 
    112067, 112066, 112065, 112064, 112063
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00036

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
112063 TWO25CB01,The World Of Obsession Recordings,Vinylgroover
112064 TWO25CB01,The World Of Obsession Recordings,Apple Mac,Fracus & Darwin
112065 TWO25CB01,The World Of Obsession Recordings,Vinylgroover
112066 TWO25CB01,The World Of Obsession Recordings,Rick Chubbs
112067 TWO25CB01,The World Of Obsession Recordings,Rick Chubbs
112068 TWO25CB01,The World Of Obsession Recordings,Rick Chubbs
112069 TWO25CB01,The World Of Obsession Recordings,Vinylgroover
112070 TWO25CB01,The World Of Obsession Recordings,Sound Assassins
112071 TWO25CB01,The World Of Obsession Recordings,Winterlake
112072 TWO25CB01,The World Of Obsession Recordings,Vinylgroover
112073 TWO25CB01,The World Of Obsession Recordings,Winterlake
112074 TWO25CB01,The World Of Obsession Recordings,Midas,Easyvibe,Stompy,Darren Tyler
112075 TWO25CB01,The World Of Obsession Recordings,AoS
112076 TWO25CB01,The World Of Obsession Recordings,AoS
112077 TWO25CB01,The World Of Obsession Recordings,Joe Rogers,Vinylgroover
112078 TWO25CB01,The World Of Obsession Recordings,Winterlake
112079 TWO25CB01,The World Of Obsession Recordings,Vinylgroover
112080 TWO25CB01,The World Of Obsession Recordings,Samba D,Dionne
112081 TWO25CB01,The World Of Obsession Recordings,Artisan (US)
112082 TWO25CB01,The World Of Obsession Recordings,Artisan (US)