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 (
    103742, 103741, 103740, 103739, 103738, 
    103737, 103736, 103735, 103734, 103733, 
    103732, 103731, 103730, 103729, 103728, 
    103727, 103717, 103716, 103715, 103714
  ) 
  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 20 Using where

Result

product_id meta_keywords meta_description search_words promo_text
103714 KIT005DC,Tidy,12 Inch Thumpers,Amber D
103715 KIT005DC,Tidy,Dark Society
103716 KIT005DC,Tidy,Sebanelli,Oddbod
103717 KIT005DC,Tidy
103727 KIT005DA,Tidy,Untidy Dubs
103728 KIT005DA,Tidy,Sam Townend,Jon BW
103729 KIT005DA,Tidy,Lee Pasch
103730 KIT005DA,Tidy,12 Inch Thumpers,Olive Grooves
103731 KIT005DA,Tidy,Organ Donors
103732 KIT005DA,Tidy,Andy Farley
103733 KIT005DA,Tidy,Lee Pasch
103734 KIT005DA,Tidy,Base Graffiti
103735 KIT005DA,Tidy,Sam Townend,Jon BW
103736 KIT005DA,Tidy,Benjamin Leung,Tazix,Ilogik
103737 KIT005DA,Tidy,Breather,Euphony
103738 KIT005DA,Tidy,Eskimo
103739 KIT005DA,Tidy,Amber D,Ben Stevens
103740 KIT005DA,Tidy,Omega 3
103741 KIT005DA,Tidy,Colin Barratt
103742 KIT005DA,Tidy,Amber D