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 (
    103647, 103646, 103645, 103644, 103643, 
    103642, 103641, 103640, 103639, 103638, 
    105262, 105261, 105260, 105259, 105258, 
    105257, 105256, 105255, 105254, 105253
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00032

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
103638 KIT005DD,Tidy,Colin Barratt,Phil York
103639 KIT005DD,Tidy,Organ Donors,Vinylgroover
103640 KIT005DD,Tidy,Ali Wilson,Matt Smallwood
103641 KIT005DD,Tidy,The Tidy Boys,BK
103642 KIT005DD,Tidy,Euphonic Sessions,Kronos
103643 KIT005DD,Tidy,Lox,Dark By Design
103644 KIT005DD,Tidy,Flashheadz
103645 KIT005DD,Tidy,Captain Tinrib,Sol Ray
103646 KIT005DD,Tidy,Jon BW
103647 KIT005DD,Tidy,Shaun M,Abandon
105253 TW12CD1D,Tidy,Organ Donors,Vinylgroover
105254 TW12CD1D,Tidy,Terrence,Phillip
105255 TW12CD1D,Tidy,Lee Pasch
105256 TW12CD1D,Tidy,Trauma
105257 TW12CD1D,Tidy,Base Graffiti
105258 TW12CD1D,Tidy,BK
105259 TW12CD1D,Tidy,Stimulator
105260 TW12CD1D,Tidy,K-Series
105261 TW12CD1D,Tidy,Sebanelli,Oddbod
105262 TW12CD1D,Tidy