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 (
    92732, 92731, 92730, 92729, 92728, 92726, 
    92725, 92723, 92721, 92720, 92719, 
    92718, 92717, 92716, 92715, 92713, 
    92712, 92711, 92710, 92709
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00048

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
92709 LWSHD04,LW Recordings,BabzookaZ
92710 LWSHD04,LW Recordings,DJ Oskar,Sergio Caubal,Handyman
92711 LWSHD04,LW Recordings,Dawson,Jon BW,Rich Resonate
92712 LWSHD04,LW Recordings,Shinobi
92713 LWSHD04,LW Recordings,A.M.G.
92715 LWSHD04,LW Recordings,Eugenio Ferrara,Maurizio Lessi
92716 LWSHD04,LW Recordings,Kid Dynamo
92717 LWSHD04,LW Recordings,Jonni Bryant,Daisy Dares You
92718 LWSHD04,LW Recordings,Agent Spank,NuroGL
92719 LWSHD04,LW Recordings,Rick James
92720 LWSHD04,LW Recordings,DJ Polo
92721 LWSHD04,LW Recordings,Lunatic Response Unit
92723 LWSHD04,LW Recordings,Ryan Walker (DJ),Digital Mafia
92725 LWSHD04,LW Recordings,James Dub
92726 LWSHD04,LW Recordings,Nik Denton,Anto
92728 LWSHD04,LW Recordings,Niztrip
92729 LWSHD04,LW Recordings,Dawn Lee
92730 LWSHD04,LW Recordings,Matt Wade
92731 LWSHD04,LW Recordings,Dean Richardson
92732 LWSHD04,LW Recordings,Miami House Party