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 (
    81101, 81100, 81099, 81098, 81053, 81494, 
    81072, 81042, 81039, 81038, 81037, 
    81034, 81019, 81493, 81492, 81062, 
    81060, 80976, 80965, 80880
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00029

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
80880 FE243,Fatal Energy Records,Pete Untitled,D-Railed
80965 FE244,Fatal Energy Records,D-Railed
80976 NCR20209,Neurotoxin Cobra Records,Human Aether,Minor Code
81019 FE245,Fatal Energy Records,F.DJ F
81034 STMCD004DIGI,Stamina Records,Substanced
81037 STMCD004DIGI,Stamina Records,Substanced
81038 STMCD004DIGI,Stamina Records,Substanced
81039 STMCD004DIGI,Stamina Records,Substanced
81042 STMCD004DIGI,Stamina Records,Substanced
81053 FE246,Fatal Energy Records,F.DJ F
81060 GCJD60,G-Core,Jon Doe
81062 GCJD61,G-Core,Jon Doe
81072 GCJD63,G-Core,Anthony Atcherley,Jon Doe
81098 STM050,Stamina Records,A.B
81099 STM050,Stamina Records,A.B,Kevin Energy
81100 STM050,Stamina Records,A.B,Douglas
81101 STM050,Stamina Records,A.B,Substanced
81492 DNZF657,DNZ Records,Garbie Project
81493 DNZF657,DNZ Records,Garbie Project
81494 DNZF659,DNZ Records,Que & Rkay