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 (
    99157, 99156, 99155, 99154, 99153, 99152, 
    99151, 99150, 99149, 99148, 99147, 
    99146, 99145, 99144, 99143, 99142, 
    99141, 99140, 99139, 99138
  ) 
  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
99138 JACKEDUP001,Jacked Up Records,Jumpin Jack
99139 JACKEDUP001,Jacked Up Records,Jumpin Jack
99140 JACKEDUP001,Jacked Up Records,Jumpin Jack
99141 JACKEDUP001,Jacked Up Records,Jumpin Jack
99142 JACKEDUP001,Jacked Up Records,A-Side
99143 JACKEDUP001,Jacked Up Records,Jumpin Jack
99144 JACKEDUP001,Jacked Up Records,Gibby Club Thumpers
99145 JACKEDUP001,Jacked Up Records,A-Side
99146 JACKEDUP001,Jacked Up Records,JJ
99147 JACKEDUP001,Jacked Up Records,Jumpin Jack
99148 JACKEDUP001,Jacked Up Records,Jumpin Jack
99149 JACKEDUP001,Jacked Up Records,A-Side
99150 JACKEDUP001,Jacked Up Records,A-Side
99151 JACKEDUP001,Jacked Up Records,JJ,Baz
99152 JACKEDUP001,Jacked Up Records,A-Side
99153 JACKEDUP001,Jacked Up Records,Zero Range
99154 JACKEDUP001,Jacked Up Records,Zero Range
99155 JACKEDUP001,Jacked Up Records,Basic Beatz
99156 JACKEDUP001,Jacked Up Records,Zero Range
99157 JACKEDUP001,Jacked Up Records,Zero Range