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 (
    98763, 98762, 98761, 98760, 98759, 98758, 
    98757, 98756, 98755, 98754, 98753, 
    98752, 98751, 98750, 98749
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00031

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

Result

product_id meta_keywords meta_description search_words promo_text
98749 BOX004,Hot Box Digital,Team Sly
98750 BOX004,Hot Box Digital,Kirk P,Team Sly
98751 BOX004,Hot Box Digital,Team Sly
98752 BOX004,Hot Box Digital,The Hoover Jocks
98753 BOX004,Hot Box Digital,Paul Hunter
98754 BOX004,Hot Box Digital,Team Sly
98755 BOX004,Hot Box Digital,Kirk P
98756 BOX004,Hot Box Digital,Matt Wade,Pez,Marc Coyne
98757 BOX004,Hot Box Digital,Team Sly,Bizarre Q
98758 BOX004,Hot Box Digital,Pez,Vandalize
98759 BOX004,Hot Box Digital,The Hoover Jocks
98760 BOX004,Hot Box Digital,Kev & Si
98761 BOX004,Hot Box Digital,Team Sly
98762 BOX004,Hot Box Digital,Pat Glenny
98763 BOX004,Hot Box Digital,Adam Kempton