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 (
    87627, 87626, 87625, 87624, 87623, 87622, 
    87621, 87620, 88579, 88170, 87964, 
    87680, 88790, 88789, 88788, 87400, 
    87316, 87315, 87314, 87313
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00057

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
87313 HUS004,Traffic Records,BK
87314 HUS004,Traffic Records,BK
87315 HUS004,Traffic Records,BK,KY Jelly Babies
87316 HUS004,Traffic Records,BK
87400 WAOD056,We Are One Digital,Ganar,SethroW
87620 LWHDB14,LW Recordings,Nathan Devlin
87621 LWHDB14,LW Recordings,George Kirby
87622 LWHDB14,LW Recordings,BloodDropz!
87623 LWHDB14,LW Recordings,M1dy
87624 LWHDB14,LW Recordings,Mr Free DJ,Norah B,Roberto Bussi
87625 LWHDB14,LW Recordings,Tunecraft Project
87626 LWHDB14,LW Recordings,Sparkos
87627 LWHDB14,LW Recordings,Dj Kano
87680 PTR127,Power Tracks Records,J. JBlack
87964 CheekUDC9,Cheeky Tracks,Sam Crow,Cut-Up
88170 DNZF831,DNZ Records,Kritikal Mass,DJ Chris Davies
88579 PTR128,Power Tracks Records,DJ Ruiz
88788 INFEXHD006,Infexious Harddance,T3kn1que,Josh Abernethie
88789 INFEXHD006,Infexious Harddance,T3kn1que,Josh Abernethie
88790 INFEXHD006,Infexious Harddance,T3kn1que,Josh Abernethie