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 (
    105207, 105206, 105205, 105204, 105203, 
    105202, 105201, 105200, 105199, 105198, 
    105197
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00033

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
105197 TW10CD2D,Tidy,Andy Farley,Olive Grooves
105198 TW10CD2D,Tidy,Andy Farley,Colin Barratt
105199 TW10CD2D,Tidy,Trauma
105200 TW10CD2D,Tidy,Andy Farley
105201 TW10CD2D,Tidy,Nik Denton
105202 TW10CD2D,Tidy,Andy Farley
105203 TW10CD2D,Tidy,Marc Johnson,Nik Denton
105204 TW10CD2D,Tidy,Trauma,Ian M
105205 TW10CD2D,Tidy,Defective Audio
105206 TW10CD2D,Tidy,Tony De Vit
105207 TW10CD2D,Tidy,Riggsy,Steve-NRG