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 (8364, 8371, 9818) 
  AND cscart_product_descriptions.lang_code = 'se'

Query time 0.00035

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
8364
8371				<p style="background: #ddd; text-align: justify;"><strong>CONSUMPTION</strong> of the impregnating agent depends on the absorbability of the treated material, as well as application method and amounts <strong>up to 10 m² per 1 litre</strong> of the emulsion (with a one impregnation).</p>
9818				<p style="text-align: center; color:#F0FFFF; background: #00cc99"><strong>7 bitar per kartong</strong></p><p style="text-align: center; color:#6699cc; background: #ffcc00"><strong>0.43 m<sup>2</sup> per kartong</strong></p>