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 (
    87011, 86980, 86979, 86977, 86976, 86975, 
    86974, 86973, 86972, 86971, 86970, 
    86969, 87436, 87396, 87395, 87394, 
    87393, 87392, 87391, 87390
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00032

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
86969 HDB010,Riot Recordings,Vinylgroover,The Red Hed
86970 HDB010,Riot Recordings,Vinylgroover,The Red Hed
86971 HDB010,Riot Recordings,Vinylgroover,The Red Hed
86972 HDB010,Riot Recordings,Vinylgroover,The Organ Donors
86973 HDB010,Riot Recordings,Scott Attrill,Luca Antolini
86974 HDB010,Riot Recordings,Scott Attrill
86975 HDB010,Riot Recordings,Nick Sentience,Ali Wilson
86976 HDB010,Riot Recordings,Norgzki
86977 HDB010,Riot Recordings,Razor Babes,Andy Farley
86979 HDB010,Riot Recordings,Joe-E
86980 HDB010,Riot Recordings,Leon B
87011 PTR123,Power Tracks Records,J. JBlack
87390 HDB009,Riot Recordings,Scott Attrill
87391 HDB009,Riot Recordings,Scott Attrill
87392 HDB009,Riot Recordings,Vinylgroover,BK
87393 HDB009,Riot Recordings,BK,Lisa Lashes
87394 HDB009,Riot Recordings,BK
87395 HDB009,Riot Recordings,BK,Nick Sentience,MC Hyper A
87396 HDB009,Riot Recordings,BK,Judge Jules
87436 DNZF812,DNZ Records,Zero Range