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 (523, 10967, 3325) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00054

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		3	Using index condition

Result

product_id	meta_keywords	meta_description	search_words	promo_text
523		✓wooden roof window ✓rooflite ✓double glazing ✓pivot ✓for bedrooms, children's rooms, living rooms ✓clearcoat✓ventilation ✓U-value 1.3 ✓check it out!
3325		☀ Blackout blinds for roof windows ✓ DAKEA ✓ DAKSTRA ✓ LuXtra ✓ Solstro ✓ Balio ✓ RoofLITE+ Problems with sleeping, because it's still light outside ⁇ Choose blackout blinds in our online store!
10967