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 (
    105228, 105227, 105226, 105225, 105224, 
    105223, 105222, 105221, 105220, 105219
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00026

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

Result

product_id meta_keywords meta_description search_words promo_text
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