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

Query time 0.00043

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
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
103920 KIT004DC,Tidy
103921 KIT004DB,Tidy,Disposable Disco Dubs
103922 KIT004DB,Tidy,Champion Burns
103923 KIT004DB,Tidy,Tomcat
103924 KIT004DB,Tidy,Dave Holmes,Lee Haslam
103925 KIT004DB,Tidy,Incisions,Kronos