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 (
    84384, 84362, 84686, 84650, 84666, 84450, 
    84224, 84570, 84398, 84462, 84460, 
    84459, 84486, 84427, 84426, 84425, 
    84424, 84423, 84422, 84421
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00031

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
84224 FE278,Fatal Energy Records,Trance Atlantic
84362 CheekUDC5,Cheeky Tracks,Harry Hard,Marc C
84384 FE281,Fatal Energy Records,Attat
84398 WAOD051,We Are One Digital,Ganar
84421 LWHDB10,LW Recordings,Faze2
84422 LWHDB10,LW Recordings,Brent Sadowick
84423 LWHDB10,LW Recordings,Wragg
84424 LWHDB10,LW Recordings,Nick Sentience
84425 LWHDB10,LW Recordings,Energy Syndicate,Cooki
84426 LWHDB10,LW Recordings,Tom Parr
84427 LWHDB10,LW Recordings,Hackney Council
84450 PTR108,Power Tracks Records,J. JBlack,Jaime Guerrero
84459 DNZF749,DNZ Records,Nova Scotia,DJ Pulse,Donna-Marie,Kritikal Mass
84460 DNZF749,DNZ Records,Nova Scotia,DJ Pulse,Donna-Marie,Kritikal Mass
84462 DNZF749,DNZ Records,Nova Scotia,DJ Pulse,Donna-Marie,Garbie Project
84486 DNZ396,DNZ Records,DJ Delirious,Caz,V-Star
84570 DNZF751,DNZ Records,Clarky
84650 DNZ398,DNZ Records,Paul Norval
84666 DNZ399,DNZ Records,Dj Oskar,Jamie B
84686 DNZF752,DNZ Records,DJ Chris Davies