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 (
    86768, 86767, 86766, 86765, 86764, 86763, 
    86762, 86761, 86760, 86593, 86576, 
    86573, 86571, 86569, 86567, 86565, 
    86547, 86448, 86416, 86773
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00039

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
86416 DNZF795,DNZ Records,Garbie Project
86448 PTR120,Power Tracks Records,DJ Ruiz
86547 DD039,Disposition Digital,Projekt Phase
86565 PTR113,Power Tracks Records,Qm Corp
86567 PTR113,Power Tracks Records,Qm Corp
86569 PTR113,Power Tracks Records,Qm Corp
86571 PTR113,Power Tracks Records,Qm Corp
86573 PTR113,Power Tracks Records,Qm Corp
86576 PTR113,Power Tracks Records,Qm Corp
86593 ST007,SHED TRAX,Dan Diamond
86760 DNZHD05,DNZ Records,Jumpin Jack,DJ Oskar
86761 DNZHD05,DNZ Records,DJ Muela
86762 DNZHD05,DNZ Records,Bounce Enforcerz,DJ Oskar
86763 DNZHD05,DNZ Records,DJ Bass
86764 DNZHD05,DNZ Records,Miky One,DJ Kino
86765 DNZHD05,DNZ Records,Raul Arribas
86766 DNZHD05,DNZ Records,Dancelord
86767 DNZHD05,DNZ Records,JJ,DJ Oskar
86768 DNZHD05,DNZ Records,Tribute Vocals
86773 PTR119,Power Tracks Records,Jaime Guerrero,Katelyn