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 (
    86725, 86724, 86723, 86561, 86560, 86558, 
    86557, 86556, 86555, 86554, 86553, 
    86552, 86551, 86825, 86824, 86823, 
    86822, 86821, 86820, 86819
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00043

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
86551 HUS001,Traffic Records,Vinylgroover,The Red Hed
86552 HUS001,Traffic Records,Scott Attrill
86553 HUS001,Traffic Records,Scott Attrill
86554 HUS001,Traffic Records,Skitek
86555 HUS001,Traffic Records,Stripe
86556 HUS001,Traffic Records,Tekno Tom
86557 HUS001,Traffic Records,Tidy Boys,BK
86558 HUS001,Traffic Records,Vinylgroover,The Red Hed
86560 HUS001,Traffic Records,Neal Thomas
86561 HUS001,Traffic Records,Nick Sentience
86723 HDB007,Riot Recordings,Vinylgroover,The Red Hed
86724 HDB007,Riot Recordings,Vinylgroover,The Red Hed
86725 HDB007,Riot Recordings,Vinylgroover,The Red Hed
86819 PTR122,Power Tracks Records,Jaime Guerrero
86820 PTR122,Power Tracks Records,J. JBlack
86821 PTR122,Power Tracks Records,DJ Ruiz
86822 PTR122,Power Tracks Records,Isaac Sanchez,Jaime Guerrero,Sergio Caubal
86823 PTR122,Power Tracks Records,Jaime Guerrero,Isaac Sanchez,Clarisse
86824 PTR122,Power Tracks Records,Andy Effect
86825 PTR122,Power Tracks Records,Jaime Guerrero,Martina S.