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 (
    94159, 94158, 94157, 94156, 94155, 94154, 
    94153, 94152, 94151, 94150, 94149, 
    94148, 94147, 94145, 94144, 94143, 
    94142, 94808, 94590, 94588
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00074

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
94142 HDP003,Traffic Records,BK,KY Jelly Babies
94143 HDP003,Traffic Records,BK
94144 HDP003,Traffic Records,BK
94145 HDP003,Traffic Records,BK,Ali Wilson
94147 HDP003,Traffic Records,BK,Scott Attrill
94148 HDP003,Traffic Records,Cally Gage,Energy Syndicate
94149 HDP003,Traffic Records,Carl Nicholson,Technikal
94150 HDP003,Traffic Records,Cut-Up
94151 HDP003,Traffic Records,Dan Kelly
94152 HDP003,Traffic Records,Dark By Design
94153 HDP003,Traffic Records,Dave Curtis
94154 HDP003,Traffic Records,Diablik,Oyaebu
94155 HDP003,Traffic Records,Diving Faces,Helen G
94156 HDP003,Traffic Records,DJ Generator
94157 HDP003,Traffic Records,DJ Generator
94158 HDP003,Traffic Records,Jamie Taylor
94159 HDP003,Traffic Records,Jason Cortez
94588 PTR158,Power Tracks Records,Dj Bocha
94590 DNZF980,DNZ Records,Dj Nelly
94808 DNZF982,DNZ Records,Kritikal Mass,DJ Chris Davies