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 (
    105261, 105260, 105259, 105258, 105257, 
    105256, 105255, 105254, 105253, 105252, 
    105251
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00031

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

Result

product_id	meta_keywords	meta_description	search_words	promo_text
105251			TW12CD1D,Tidy,Nick Rafferty,Nick Rowland
105252			TW12CD1D,Tidy,The Tidy Boys
105253			TW12CD1D,Tidy,Organ Donors,Vinylgroover
105254			TW12CD1D,Tidy,Terrence,Phillip
105255			TW12CD1D,Tidy,Lee Pasch
105256			TW12CD1D,Tidy,Trauma
105257			TW12CD1D,Tidy,Base Graffiti
105258			TW12CD1D,Tidy,BK
105259			TW12CD1D,Tidy,Stimulator
105260			TW12CD1D,Tidy,K-Series
105261			TW12CD1D,Tidy,Sebanelli,Oddbod