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 (
    103772, 103771, 103770, 103769, 103768, 
    103767, 103766, 103765, 103764, 103763, 
    103762, 103761
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00040

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

Result

product_id meta_keywords meta_description search_words promo_text
103761 TIDYHHDL01DC,Tidy,Paul Glazby
103762 TIDYHHDL01DC,Tidy,Nik Denton
103763 TIDYHHDL01DC,Tidy,Defective Audio
103764 TIDYHHDL01DC,Tidy,Defective Audio
103765 TIDYHHDL01DC,Tidy,Omega 3
103766 TIDYHHDL01DC,Tidy,Ben Stevens,Paul Maddox
103767 TIDYHHDL01DC,Tidy,Paul Glazby
103768 TIDYHHDL01DC,Tidy,Paul Glazby
103769 TIDYHHDL01DC,Tidy,Paul Glazby
103770 TIDYHHDL01DC,Tidy,Ben Stevens,Paul Glazby
103771 TIDYHHDL01DC,Tidy,Weirdo
103772 TIDYHHDL01DC,Tidy,RR Fierce,K-Live