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 (
    120592, 120591, 120590, 120589, 120588, 
    120587, 120586, 120585, 120584, 120583, 
    120582, 120581, 120580, 120579, 120578, 
    120577, 120576, 120575, 120574, 120573, 
    120572, 120571
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00036

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

Result

product_id meta_keywords meta_description search_words promo_text
120571 MQDRCP008,+QDance Records,Mori DJ
120572 MQDRCP008,+QDance Records,DJ Miho
120573 MQDRCP008,+QDance Records,Sergio Caubal
120574 MQDRCP008,+QDance Records,masQDance
120575 MQDRCP008,+QDance Records,MasQDance/Duchi DJ
120576 MQDRCP008,+QDance Records,Fran Dejota,DJ Made,Ada Ulises
120577 MQDRCP008,+QDance Records,Frank Cherryman,Sergio Caubal
120578 MQDRCP008,+QDance Records,Alex Cervera, Sergio Caubal
120579 MQDRCP008,+QDance Records,Alfre DJ
120580 MQDRCP008,+QDance Records,Vicious Project,DJ Lara
120581 MQDRCP008,+QDance Records,Leo-M
120582 MQDRCP008,+QDance Records,Mori DJ
120583 MQDRCP008,+QDance Records,Duchi DJ
120584 MQDRCP008,+QDance Records,DJ Lara/Sunrise Beats,DJ Will
120585 MQDRCP008,+QDance Records,Mori DJ
120586 MQDRCP008,+QDance Records,Alfre DJ
120587 MQDRCP008,+QDance Records,Mori DJ
120588 MQDRCP008,+QDance Records,DJ Miho
120589 MQDRCP008,+QDance Records,masQDance
120590 MQDRCP008,+QDance Records,DJ Miho
120591 MQDRCP008,+QDance Records,Schizoofr3nik,DJ Nillos
120592 MQDRCP008,+QDance Records,Juanlu DJ