Sandbox

SELECT 
  cscart_product_descriptions.product_id, 
  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 (
    118790, 118789, 118788, 118787, 118786, 
    118785, 118784, 118783, 118782, 118781, 
    118780, 118779, 118778, 118777, 118776, 
    118775, 118774, 118773, 118772, 118771, 
    118770, 118769, 118768
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00036

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		23	Using where

Result

product_id	meta_keywords	meta_description	search_words	promo_text
118768			TTLP006,Tuff Trax,Psydef
118769			TTLP006,Tuff Trax,Sean Inside Out,Marky P
118770			TTLP006,Tuff Trax,Matt Wade
118771			TTLP006,Tuff Trax,Marc Lewis
118772			TTLP006,Tuff Trax,Paul PSR Ryder
118773			TTLP006,Tuff Trax,Jade Paley,Sam Alame,Damaged Gudz
118774			TTLP006,Tuff Trax,Sean Inside Out
118775			TTLP006,Tuff Trax,Dan Dyson
118776			TTLP006,Tuff Trax,Matt Wade,Pez & Miric
118777			TTLP006,Tuff Trax,Boris The Noss
118778			TTLP006,Tuff Trax,Matt Wade
118779			TTLP006,Tuff Trax,Psydef
118780			TTLP006,Tuff Trax,Boris The Noss
118781			TTLP006,Tuff Trax,Sean Inside Out
118782			TTLP006,Tuff Trax,Marc Lewis
118783			TTLP006,Tuff Trax,Boris The Noss
118784			TTLP006,Tuff Trax,Mark Hard,Sean Inside Out
118785			TTLP006,Tuff Trax,Hadyn Jay
118786			TTLP006,Tuff Trax,Remy LeBeau,The Goat Snatcher's
118787			TTLP006,Tuff Trax,Reactor 4
118788			TTLP006,Tuff Trax,Psydef
118789			TTLP006,Tuff Trax,Insidious
118790			TTLP006,Tuff Trax,Mark Hard,Dan Dyson