Sandbox

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 (
    86394, 86283, 86282, 86281, 86280, 86279, 
    86278, 86277, 86276, 86275, 85925, 
    85922, 85921, 85920, 85919, 85918, 
    85917, 85916, 85915, 85914
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00039

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
85914					HDB006,Riot Recordings,Cut-Up
85915					HDB006,Riot Recordings,Dark By Design
85916					HDB006,Riot Recordings,Jordan Duke
85917					HDB006,Riot Recordings,Lee Mac
85918					HDB006,Riot Recordings,Leon B
85919					HDB006,Riot Recordings,Leon B
85920					HDB006,Riot Recordings,Leon Clarke
85921					HDB006,Riot Recordings,Loop
85922					HDB006,Riot Recordings,Mike Avery
85925					EF015,Energy Field,Cyrax
86275					WAODAA001,We Are One Digital,Ganar
86276					WAODAA001,We Are One Digital,Ganar
86277					WAODAA001,We Are One Digital,Ganar
86278					WAODAA001,We Are One Digital,Ganar
86279					WAODAA001,We Are One Digital,Ganar,SethroW
86280					WAODAA001,We Are One Digital,Ganar
86281					WAODAA001,We Are One Digital,Ganar
86282					WAODAA001,We Are One Digital,Ganar
86283					WAODAA001,We Are One Digital,Ganar
86394					DNZF793,DNZ Records,Zero Range