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 (
    87742, 87741, 87656, 87644, 87643, 87642, 
    87641, 87640, 87639, 87638, 87637, 
    87636, 87635, 87634, 87633, 87632, 
    87631, 87630, 87629, 87628
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00035

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
87628 LWHDB14,LW Recordings,RR Reject
87629 LWHDB14,LW Recordings,Massive
87630 LWHDB14,LW Recordings,Dave Owens
87631 LWHDB14,LW Recordings,Los Jefes,WARMCHNE
87632 LWHDB14,LW Recordings,Rave Dust
87633 LWHDB14,LW Recordings,BloodDropz!,DJ Benchuscoro
87634 LWHDB14,LW Recordings,S3RL,Lexi
87635 LWHDB14,LW Recordings,Digital Commandos
87636 LWHDB14,LW Recordings,Allan-E
87637 LWHDB14,LW Recordings,DJ Nillos
87638 LWHDB14,LW Recordings,Cutoff:Sky
87639 LWHDB14,LW Recordings,Kizum
87640 LWHDB14,LW Recordings,Qm Corp
87641 LWHDB14,LW Recordings,Nick Freeze
87642 LWHDB14,LW Recordings,AntiQlimax,Clayfacer
87643 LWHDB14,LW Recordings,Activist
87644 LWHDB14,LW Recordings,Andy Whitby,Audox
87656 WAOD057,We Are One Digital,Ganar,TopKat
87741 HUS005,Traffic Records,BK
87742 HUS005,Traffic Records,BK