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 (
    103919, 103918, 103917, 103916, 103915, 
    103914, 103913, 103912, 103911, 103910, 
    103909, 103908, 103907, 103906, 103905
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00037

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

Result

product_id meta_keywords meta_description search_words promo_text
103905 KIT004DC,Tidy,Untidy Dubs,Kronos
103906 KIT004DC,Tidy,Rundell,Maddox
103907 KIT004DC,Tidy,Champion Burns,Paul Maddox
103908 KIT004DC,Tidy,Nick Rafferty,PBS,Jez & Charlie
103909 KIT004DC,Tidy,Abandon
103910 KIT004DC,Tidy,Tara Reynolds
103911 KIT004DC,Tidy,SJ,Baby Doc,Paul Glazby,Paul Maddox
103912 KIT004DC,Tidy,Tony De Vit,BK
103913 KIT004DC,Tidy,Ben K
103914 KIT004DC,Tidy,Stimulator,Flash Harry
103915 KIT004DC,Tidy,Heaven's Cry,Riot Brothers
103916 KIT004DC,Tidy,The Freak
103917 KIT004DC,Tidy,Ben Kaye,Deeprose,Thompson
103918 KIT004DC,Tidy,Guyver
103919 KIT004DC,Tidy,Riot Brothers