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 (
    105217, 105216, 105215, 105214, 105213, 
    105212, 105211, 105210, 105209
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00030

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

Result

product_id meta_keywords meta_description search_words promo_text
105209 TIDYW11LAD,Tidy,Andy Farley,Nick Sentience
105210 TIDYW11LAD,Tidy,BK,Nick Sentience
105211 TIDYW11LAD,Tidy,Allnighters
105212 TIDYW11LAD,Tidy,OD404
105213 TIDYW11LAD,Tidy,Steve Thomas
105214 TIDYW11LAD,Tidy,Cortina,BK,dBM
105215 TIDYW11LAD,Tidy,Lisa Lashes
105216 TIDYW11LAD,Tidy,Psyclone,Andy Farley
105217 TIDYW11LAD,Tidy,Incisions,Paul Glazby,Paul Janes