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 (
    105252, 105251, 105229, 105228, 105227, 
    105226, 105225, 105224, 105223, 105222, 
    105221, 105220, 105219, 103726, 103725, 
    103724, 103723, 103722, 103721, 103720
  ) 
  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
103720 TIDYTBB01BD,Tidy,Lisa Lashes,Mofo Disco
103721 TIDYTBB01BD,Tidy,Question Mark,Audio Hedz,Wain Johnstone
103722 TIDYTBB01BD,Tidy,Dark Society,Steve O'Brady
103723 TIDYTBB01BD,Tidy,Eskimo
103724 TIDYTBB01BD,Tidy,Lee Haslam,Amber D
103725 TIDYTBB01BD,Tidy,E-Wok,Matt Pickup,Riggsy
103726 TIDYTBB01BD,Tidy,Carl Nicholson,Iridium
105219 TW12CD3D,Tidy,Richard Toomz
105220 TW12CD3D,Tidy,Nik Denton
105221 TW12CD3D,Tidy,Trauma,P.A.S.
105222 TW12CD3D,Tidy,Omega 3
105223 TW12CD3D,Tidy,Justin Bourne,Dynamic Intervention
105224 TW12CD3D,Tidy,Nik Denton,Justin Bourne,Dynamic Intervention
105225 TW12CD3D,Tidy,Nik Denton,Tim Stokes
105226 TW12CD3D,Tidy,Kauz,Defective Audio
105227 TW12CD3D,Tidy,Batten & Brow
105228 TW12CD3D,Tidy,Dave Curtis
105229 TW12CD3D,Tidy
105251 TW12CD1D,Tidy,Nick Rafferty,Nick Rowland
105252 TW12CD1D,Tidy,The Tidy Boys