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 (
    105308, 105307, 105306, 105305, 105304, 
    105303, 105302, 105301, 105300, 105299, 
    105298
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00071

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

Result

product_id meta_keywords meta_description search_words promo_text
105298 TW703D,Tidy,Paul Maddox,DJ GRH
105299 TW703D,Tidy,Paul Maddox,DJ GRH
105300 TW703D,Tidy,Paul Maddox,DJ GRH
105301 TW703D,Tidy,Paul Maddox
105302 TW703D,Tidy,Rob Tissera,Guyver,Paul Maddox
105303 TW703D,Tidy,Travel,Paul Maddox
105304 TW703D,Tidy,Barely Legal
105305 TW703D,Tidy,Paul Maddox
105306 TW703D,Tidy,Rumble,Maddox
105307 TW703D,Tidy,Shaun M,Abandon
105308 TW703D,Tidy,Trauma