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 (
    103863, 103862, 103861, 103860, 103859, 
    103858, 103857, 103856, 103855, 103854, 
    103853, 103852, 103851, 103850, 103849, 
    103848, 103847, 103846, 103845, 103844, 
    103843, 103842, 103841, 103840, 103839, 
    103838, 103837, 103836, 103835
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00042

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

Result

product_id meta_keywords meta_description search_words promo_text
103835 UTDU001D,Tidy,Kutski
103836 UTDU001D,Tidy,NR2
103837 UTDU001D,Tidy,Lee Pasch
103838 UTDU001D,Tidy,Flashheadz
103839 UTDU001D,Tidy,Jon Bishop,Colin Barratt
103840 UTDU001D,Tidy,Trauma
103841 UTDU001D,Tidy,Nick Rowland
103842 UTDU001D,Tidy,Hyperlogic,Stimulant DJ's
103843 UTDU001D,Tidy,Ingo
103844 UTDU001D,Tidy,Lee Pasch
103845 UTDU001D,Tidy,Colin Barratt,Phil York
103846 UTDU001D,Tidy,Psyclone,Andy Farley
103847 UTDU001D,Tidy,Lisa Lashes,The Tidy Boys
103848 UTDU001D,Tidy,Stimulator
103849 UTDU001D,Tidy,OD404,Dark by Design
103850 UTDU001D,Tidy,Organ Donors
103851 UTDU001D,Tidy,Dutch Courage
103852 UTDU001D,Tidy,Colin Barratt
103853 UTDU001D,Tidy,Carl Nicholson
103854 UTDU001D,Tidy,Heaven's Cry,Stimulant DJ's
103855 UTDU001D,Tidy,Guyver
103856 UTDU001D,Tidy,Lee Haslam
103857 UTDU001D,Tidy,Guyver
103858 UTDU001D,Tidy,Tony De Vit,Paul Janes
103859 UTDU001D,Tidy,Anne Savage
103860 UTDU001D,Tidy,Paul Maddox
103861 UTDU001D,Tidy,Tony De Vit
103862 UTDU001D,Tidy,Tony De Vit
103863 UTDU001D,Tidy,Guyver