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 (
    101801, 101800, 101799, 101798, 101797, 
    101796, 101795, 101794, 101793, 101792, 
    101791, 101790, 101789, 101788, 101787, 
    101786, 101785, 101784, 101783, 101782
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00091

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
101782 HDCHA005,Hard Dance Coalition,JP,Jukesy
101783 HDCHA005,Hard Dance Coalition,Phlash!,BK
101784 HDCHA005,Hard Dance Coalition,Wizard
101785 HDCHA005,Hard Dance Coalition,Karim
101786 HDCHA005,Hard Dance Coalition,Defective Audio,Paul Glazby
101787 HDCHA005,Hard Dance Coalition,Base Graffiti
101788 HDCHA005,Hard Dance Coalition,Masmada,Paul Glazby
101789 HDCHA005,Hard Dance Coalition,Daley,Adz,Alex Calver
101790 HDCHA005,Hard Dance Coalition,Gary Cooke,Frank Farrell
101791 HDCHA005,Hard Dance Coalition,Paul Glazby
101792 HDCHA005,Hard Dance Coalition,Leon Allen
101793 HDCHA005,Hard Dance Coalition,JoJo,Gary O'Connor
101794 HDCHA005,Hard Dance Coalition,12 Inch Thumpers,Paul Glazby
101795 HDCHA005,Hard Dance Coalition,Boca Byrne
101796 HDCHA005,Hard Dance Coalition,Henry Trotton
101797 HDCHA005,Hard Dance Coalition,Aaron James
101798 HDCHA005,Hard Dance Coalition,Gary Byrne
101799 HDCHA005,Hard Dance Coalition,Leon Allen
101800 HDCHA005,Hard Dance Coalition,Base Graffiti
101801 HDCHA005,Hard Dance Coalition,Karim