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 (
    93322, 93321, 93320, 93319, 93318, 93307, 
    93306, 93304, 93223, 93189, 93095, 
    93009, 92836, 92462, 92450, 92448, 
    92447, 92434, 92433, 91822
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00037

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
91822	Hayz, Frantic Digital, Hard House, Change (The World)		Hayz, Frantic Digital, Hard House, Change (The World)
92433			Cheek510,Cheeky Tracks,Homzy,Random But Raw
92434			Cheek510,Cheeky Tracks,Homzy,Random But Raw
92447			DLI040,D'Licious,Amber D,Adam Taylor,Charlie Goddard
92448			DLI039,D'Licious,Kid Dynamo
92450			ED008,Epidemic Digital,The Unseen
92462			INR062,Immortal Noise Recordings,Spyndl
92836	TMP170,G Mix,Dance With G,Tempo Trax,Hard House	Hard House	TMP170,G Mix,Dance With G,Tempo Trax,Hard House
93009	Ross, Farley, Visceral, Visceral Records, Ross Farley, Matt Clarkson, Back to Life, Hard House	Ross Farley's 2nd solo release on VR's main label. This one is near and dear to the heart...a voyage of self-exploration and awareness. The 1st track Ross wrote for the IN:VISION album.	Ross, Farley, Visceral, Visceral Records, Ross Farley, Matt Clarkson, Back to Life, Hard House
93095
93189	Kirk P,Move,TorqueDigital	New Uplifting Hard house Hard Trancer by Kirk p	Torquedigitalrecords,Harddance,KirkP,Move
93223	superfly,hardhouse,release,digital,toolbox,hardance
93304	G.W.R., NUROGL, Juicy, Hard House, Hard Dance, Visceral Records, Visceral		G.W.R., NUROGL, Juicy, Hard House, Hard Dance, Visceral Records, Visceral
93306
93307
93318	Burning Blade, Tekneak, Shoguns		Burning Blade, Tekneak, Shoguns
93319	Burning Blade, Tekneak, Shoguns		Burning Blade, Tekneak, Shoguns
93320	whoredrey,roberts,terrbang,hard,house,good,lines		whoredrey,roberts,terrbang,hard,house,good,lines
93321	whoredrey,roberts,terrbang,hard,house,man,love		whoredrey,roberts,terrbang,hard,house,man,love
93322	whoredrey,roberts,terrbang,hard,house,just,pay,hoes		whoredrey,roberts,terrbang,hard,house,just,pay,hoes