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 (
    98021, 98020, 98019, 98018, 98017, 98016, 
    98015, 98014, 97917, 97758, 97671, 
    97663, 97471, 97470, 97469, 97468, 
    97292, 97291, 97178, 89232
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00044

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
89232
97178
97291			ED011,Epidemic Digital,D-Fi,KP
97292			ED011,Epidemic Digital,D-Fi,KP
97468	Grapey, Groove Control, Laura Mac, Come Into My Dream, Cheeky Tracks, Groove Control Radio Edit, Hard Dance, Toolbox Digital	Download Come Into My Dream (Groove Control Radio Edit) by Cheeky Tracks from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more.	Cheek536B,Cheeky Tracks,Grapey,Laura Mac,Groove Control
97469	Grapey, Laura Mac, Team Sly, Come Into My Dream, Cheeky Tracks, Team Sly Radio Edit, Hard House, Toolbox Digital	Download Come Into My Dream (Team Sly Radio Edit) by Cheeky Tracks from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more.	Cheek536B,Cheeky Tracks,Grapey,Laura Mac,Team Sly
97470	Grapey, Laura Mac, Team Sly, Come Into My Dream, Cheeky Tracks, Team Sly Remix, Featured Hard House New, Hard House, Toolbox Digital	Download Come Into My Dream (Team Sly Remix) by Cheeky Tracks from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more.	Cheek536B,Cheeky Tracks,Grapey,Laura Mac,Team Sly
97471	Grapey, Groove Control, Laura Mac, Come Into My Dream, Cheeky Tracks, Groove Control Remix, Featured Hard Dance New, Hard Dance, Toolbox Digital	Download Come Into My Dream (Groove Control Remix) by Cheeky Tracks from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more.	Cheek536B,Cheeky Tracks,Grapey,Laura Mac,Groove Control
97663	Gary O'Connor, Go With The Flow, Bass Jumper, Digital Snail		Gary O'Connor, Go With The Flow, Bass Jumper, Digital Snail
97671	TMP182,Dean Richardson,Crowbar,Tempo Trax,Hard House	Hard House	TMP182,Dean Richardson,Crowbar,Tempo Trax,Hard House
97758	Riksta		Global,Awakening,Records,
97917	Boris The Noss,Emmanating Records,Call That Nasty,Hard House	Boris The Noss,Emmanating Records,Call That Nasty,Hard House	Boris The Noss,Emmanating Records,Call That Nasty,Hard House
98014	superfly,hardhouse,release,digital,toolbox,hardance
98015	superfly,hardhouse,release,digital,toolbox,hardance
98016	superfly,hardhouse,release,digital,toolbox,hardance
98017	superfly,hardhouse,release,digital,toolbox,hardance
98018	superfly,hardhouse,release,digital,toolbox,hardance
98019	superfly,hardhouse,release,digital,toolbox,hardance
98020	superfly,hardhouse,release,digital,toolbox,hardance
98021	superfly,hardhouse,release,digital,toolbox,hardance