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 (
    103716, 103715, 103714, 103713, 103712, 
    103711, 103710, 103709, 103708, 103707, 
    103706, 103705, 103704, 103703
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00057

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

Result

product_id meta_keywords meta_description search_words promo_text
103703 KIT005DC,Tidy,Matar,Guyver
103704 KIT005DC,Tidy,Rob Tissera,Vinylgroover,The Red Head
103705 KIT005DC,Tidy,Carl Nicholson
103706 KIT005DC,Tidy,Kym Ayres,Technikal
103707 KIT005DC,Tidy,Nick Rowland
103708 KIT005DC,Tidy,Stimulator
103709 KIT005DC,Tidy,Carl Nicholson
103710 KIT005DC,Tidy,Nick Rafferty,The Coalition
103711 KIT005DC,Tidy,Lee Pasch
103712 KIT005DC,Tidy,Stimulator
103713 KIT005DC,Tidy,Lee Haslam
103714 KIT005DC,Tidy,12 Inch Thumpers,Amber D
103715 KIT005DC,Tidy,Dark Society
103716 KIT005DC,Tidy,Sebanelli,Oddbod