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 (
    125768, 125767, 125766, 125765, 125764, 
    125763, 125762, 125761, 125760, 125759, 
    125758, 125757, 125756, 125755, 125754, 
    125753, 125752, 125751, 125750, 125749, 
    125748, 125747, 125746, 125745, 125744
  ) 
  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 25 Using where

Result

product_id meta_keywords meta_description search_words promo_text
125744 LWHTS23,LW Recordings,Erykk Mtk
125745 LWHTS23,LW Recordings,RiVid,Tapage Noir
125746 LWHTS23,LW Recordings,Air Of Wave
125747 LWHTS23,LW Recordings,Tc Dj
125748 LWHTS23,LW Recordings,Verys,OKKOTO
125749 LWHTS23,LW Recordings,B-Ya!,Black Ahead
125750 LWHTS23,LW Recordings,Agent Zero
125751 LWHTS23,LW Recordings,DS3
125752 LWHTS23,LW Recordings,Dynamo City,Regal
125753 LWHTS23,LW Recordings,Franck Antenucci
125754 LWHTS23,LW Recordings,Datcher,LEVRE
125755 LWHTS23,LW Recordings,Andy BSK
125756 LWHTS23,LW Recordings,Sergio Pardo,Jordi Lazaro
125757 LWHTS23,LW Recordings,SU 47
125758 LWHTS23,LW Recordings,MiSiNKi,HANNIBAL K
125759 LWHTS23,LW Recordings,Fuma Funaky
125760 LWHTS23,LW Recordings,Pumio,Jared Pastore
125761 LWHTS23,LW Recordings,Rik Arkitech,Endemic
125762 LWHTS23,LW Recordings,Ayako Mori,Wrong Format
125763 LWHTS23,LW Recordings,Mandidextrous,Matt Scratch
125764 LWHTS23,LW Recordings,Mark Rey
125765 LWHTS23,LW Recordings,Moshe Galactik,Davide Di Blasi
125766 LWHTS23,LW Recordings,Chris Lo
125767 LWHTS23,LW Recordings,Chris Cue
125768 LWHTS23,LW Recordings,Jonathan De Maio