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 (
    95939, 95938, 95937, 95936, 95935, 95934, 
    95933, 95932, 95931, 95930
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00027

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
95930 UTHCMP001HD,Ultratech,Sam Alame,VaderMonkey
95931 UTHCMP001HD,Ultratech,VaderMonkey,Helz Bellz
95932 UTHCMP001HD,Ultratech,Drake Liddell
95933 UTHCMP001HD,Ultratech,VaderMonkey
95934 UTHCMP001HD,Ultratech,Vadermonkey,Ben Stevens
95935 UTHCMP001HD,Ultratech,VaderMonkey,Dave Owens
95936 UTHCMP001HD,Ultratech,VaderMonkey,Stompalott
95937 UTHCMP001HD,Ultratech,VaderMonkey,LOK-E
95938 UTHCMP001HD,Ultratech,Sam E
95939 UTHCMP001HD,Ultratech,LOK-E & Risa