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 (
    88704, 88703, 88702, 88701, 88700, 88699, 
    88698, 88696, 88695, 88694, 88692, 
    88691, 88690, 88688, 88687, 88686, 
    88685, 88684, 89281, 102419
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00040

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
88684 CheekUDC0,Cheeky Tracks,Venkman
88685 CheekUDC0,Cheeky Tracks,Headrockers
88686 CheekUDC0,Cheeky Tracks,Digital Mafia,General Bounce
88687 CheekUDC0,Cheeky Tracks,Groove Control
88688 CheekUDC0,Cheeky Tracks,Starman,Italo Bounce
88690 CheekUDC0,Cheeky Tracks,Miss Detonate,Jon Doe
88691 CheekUDC0,Cheeky Tracks,Groove Control
88692 CheekUDC0,Cheeky Tracks,BAD
88694 CheekUDC0,Cheeky Tracks,Pitch Invader
88695 CheekUDC0,Cheeky Tracks,Rob Cain,John Neal
88696 CheekUDC0,Cheeky Tracks,Josh Ransome
88698 CheekUDC0,Cheeky Tracks,Vandalize
88699 CheekUDC0,Cheeky Tracks,The 3 Musketeers
88700 CheekUDC0,Cheeky Tracks,Gilly
88701 CheekUDC0,Cheeky Tracks,Elivate,Rownz
88702 CheekUDC0,Cheeky Tracks,Paul Luffman
88703 CheekUDC0,Cheeky Tracks,Digital Mafia,Gaz F
88704 CheekUDC0,Cheeky Tracks,Audox,Jimi Burnz
89281 DNZF873,DNZ Records,Chrissy P,Marie Bridson
102419 WWYLTHA005D,Tidy,Tony De Vit