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 (
    97107, 92929, 97862, 98142, 98141, 98140, 
    98083, 98082, 98081, 98080, 98079, 
    98071, 98069, 98028, 98027, 98026, 
    98025, 98024, 98023, 98022
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00032

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	meta_keywords	meta_description	search_words
92929
97107	Pete Mac, Rob Tissera, Frantic Digital, Hard Trance, Set Free		Pete Mac, Rob Tissera, Frantic Digital, Hard Trance, Set Free
97862			BMRMX1,Beast Mode Recordings,NuroGL,Dean Richardson
98022	superfly,hardhouse,release,digital,toolbox,hardance
98023	superfly,hardhouse,release,digital,toolbox,hardance
98024	superfly,hardhouse,release,digital,toolbox,hardance
98025	superfly,hardhouse,release,digital,toolbox,hardance
98026	superfly,hardhouse,release,digital,toolbox,hardance
98027	superfly,hardhouse,release,digital,toolbox,hardance
98028	superfly,hardhouse,release,digital,toolbox,hardance
98069	Visceral, Charged, Hard House, Hard Dance, Hard Trance, Tara N, Lok_E, Dance, Trance	Tara N & Lok_E bringing the heat with Dead by Dawn	Visceral, Charged, Hard House, Hard Dance, Hard Trance, Tara N, Lok_E, Dance, Trance
98071			Alan James, Alan Skipper, Mada, Much Better, Full Cirlce Productions
98079	Tekneak, Burning Blade		Tekneak, Burning Blade
98080	Roosta, X-ite Audio, Hard House, Hard Trance	Breathe	Breathe, Roosta
98081
98082	Tara,N,Fight,Hard,House		Tara,N,Fight,Hard,House
98083	Tara,N,Fight,Hard,House,Boski		Tara,N,Fight,Hard,House,Boski
98140
98141
98142