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 (
    103819, 103818, 103817, 103816, 103815, 
    103814, 103813, 103812, 103811, 103810, 
    103809, 103808, 103807, 103864, 103863, 
    103862, 103861, 103860, 103859, 103858
  ) 
  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 20 Using where

Result

product_id meta_keywords meta_description search_words promo_text
103807 TBBNO001D,Tidy,Amber D
103808 TBBNO001D,Tidy,Judge Jules,BK
103809 TBBNO001D,Tidy,Colin Barratt,Phil York
103810 TBBNO001D,Tidy,Sam Townend,Jon BW
103811 TBBNO001D,Tidy,Colin Barratt,Ali Wilson
103812 TBBNO001D,Tidy,Base Graffiti
103813 TBBNO001D,Tidy,Carl Nicholson
103814 TBBNO001D,Tidy,Jason Cortez
103815 TBBNO001D,Tidy,Colin Barratt
103816 TBBNO001D,Tidy,Anne Savage,Vinylgroover,The Red Hed
103817 TBBNO001D,Tidy,Frank Farrell
103818 TBBNO001D,Tidy,Amber D
103819 TBBNO001D,Tidy,Tony De Vit,Leigh Green,Steve O'Brady
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
103864 UTDU001D,Tidy