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 (
    111756, 111755, 111754, 111753, 111752, 
    111751, 111750, 111749, 111748, 111747, 
    111746, 111745, 111744, 111743, 111742, 
    111741, 111740, 111739, 111738, 111737, 
    111736, 111735, 111734, 111733, 111732
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00048

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

Result

product_id meta_keywords meta_description search_words promo_text
111732 LWHTS07,LW Recordings,MarAxe,CC Luna
111733 LWHTS07,LW Recordings,Black Ahead
111734 LWHTS07,LW Recordings,Poison Cult
111735 LWHTS07,LW Recordings,MOT3K
111736 LWHTS07,LW Recordings,Nous Klear
111737 LWHTS07,LW Recordings,kaori
111738 LWHTS07,LW Recordings,Brian M,Kthonos
111739 LWHTS07,LW Recordings,Eloy Palma
111740 LWHTS07,LW Recordings,A.P.
111741 LWHTS07,LW Recordings,F.TEK
111742 LWHTS07,LW Recordings,Asmodeo,DarkMe
111743 LWHTS07,LW Recordings,Roentgen Limiter
111744 LWHTS07,LW Recordings,H! Dude
111745 LWHTS07,LW Recordings,Alex Vigo,Goncalo M
111746 LWHTS07,LW Recordings,H! Dude
111747 LWHTS07,LW Recordings,Vaessar303
111748 LWHTS07,LW Recordings,JGMZ
111749 LWHTS07,LW Recordings,Riotbot
111750 LWHTS07,LW Recordings,SP1TA
111751 LWHTS07,LW Recordings,Nutty T,Bad Panda,Jim E Scavenger
111752 LWHTS07,LW Recordings,Vontech,Aneema
111753 LWHTS07,LW Recordings,Hundzhan
111754 LWHTS07,LW Recordings,Tony Ess
111755 LWHTS07,LW Recordings,Victoria Franches,Marco Ginelli,KHARL
111756 LWHTS07,LW Recordings,Zero Dayz,Chicago Loop