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 (
    103750, 103749, 103748, 103747, 105270, 
    105269, 105268, 105267, 105266, 105265, 
    105264, 105263, 105218, 105217, 105216, 
    105215, 105214, 105213, 105212, 105211
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00032

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

Result

product_id meta_keywords meta_description search_words promo_text
103747 TIDYHHDL01DB,Tidy,Judge Jules,BK
103748 TIDYHHDL01DB,Tidy,BK
103749 TIDYHHDL01DB,Tidy,BK,Vinylgroover
103750 TIDYHHDL01DB,Tidy,Deadbeat
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
105218 TIDYW11LAD,Tidy
105263 TIDYW11LBD,Tidy,Ben Stevens,Paul Maddox
105264 TIDYW11LBD,Tidy,Paul Glazby
105265 TIDYW11LBD,Tidy,Stimulant DJ's
105266 TIDYW11LBD,Tidy,Carl Nicholson,Ben Kaye
105267 TIDYW11LBD,Tidy,Amber D
105268 TIDYW11LBD,Tidy,BK
105269 TIDYW11LBD,Tidy,12 Inch Thumpers,Amber D
105270 TIDYW11LBD,Tidy