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 (
    124642, 124641, 124640, 124639, 124638, 
    124637, 124636, 124635, 124634, 124633, 
    124632, 124631, 124630, 124629, 124628, 
    124627, 124626, 124625, 124624, 124623, 
    124622, 124621, 124620, 124619
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00041

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

Result

product_id meta_keywords meta_description search_words promo_text
124619 LWHTS21b,LW Recordings,Ron Darst
124620 LWHTS21b,LW Recordings,Hamaton3
124621 LWHTS21b,LW Recordings,Sound Hunters
124622 LWHTS21b,LW Recordings,Kardenal
124623 LWHTS21b,LW Recordings,STARX,Haaradak
124624 LWHTS21b,LW Recordings,T3[x]3TH,Noise Loud
124625 LWHTS21b,LW Recordings,Naaegmar
124626 LWHTS21b,LW Recordings,Datcher,Tigerhead
124627 LWHTS21b,LW Recordings,Tommy Disgrace
124628 LWHTS21b,LW Recordings,Rafael de la King
124629 LWHTS21b,LW Recordings,Aklow,Psycho Spectrum
124630 LWHTS21b,LW Recordings,Makaja Gonzales
124631 LWHTS21b,LW Recordings,Futaroashi
124632 LWHTS21b,LW Recordings,Subaru Ito,Gianluca Zeta
124633 LWHTS21b,LW Recordings,High Frequency
124634 LWHTS21b,LW Recordings,Arzadous
124635 LWHTS21b,LW Recordings,Mr.lucky,Tech C
124636 LWHTS21b,LW Recordings,Ash Cook N' DJ Stephan
124637 LWHTS21b,LW Recordings,Maschino Violento,Black Ahead
124638 LWHTS21b,LW Recordings,Carl Shorts
124639 LWHTS21b,LW Recordings,Bubbless
124640 LWHTS21b,LW Recordings,REJECTED AUDIO
124641 LWHTS21b,LW Recordings,Zerberuz,Supreme Enemy
124642 LWHTS21b,LW Recordings,Jeff Robens