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 (
    125591, 125590, 125589, 125588, 125587, 
    125586, 125585, 125584, 125583, 125582, 
    125581, 125580, 125579, 125578, 125577, 
    125576, 125575, 125574, 125573, 125572
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00039

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

Result

product_id meta_keywords meta_description search_words promo_text
125572 TIDYHF001D,Tidy,The Freak Brothers
125573 TIDYHF001D,Tidy,Tony De Vit,Ben Stevens
125574 TIDYHF001D,Tidy,Big Tool 4 U
125575 TIDYHF001D,Tidy,Allnighters,Ian M
125576 TIDYHF001D,Tidy,NRG,Baby Doc
125577 TIDYHF001D,Tidy,Andy Farley,Paul Glazby,Ground Zero
125578 TIDYHF001D,Tidy,Jon Doe,Karim
125579 TIDYHF001D,Tidy,Paul Glazby
125580 TIDYHF001D,Tidy,Paul Glazby
125581 TIDYHF001D,Tidy,Trauma
125582 TIDYHF001D,Tidy,Beatniqz,BK
125583 TIDYHF001D,Tidy,Captain Tinrib,Sol Ray
125584 TIDYHF001D,Tidy,E-Trax,Pants,Corset
125585 TIDYHF001D,Tidy,Trauma,Paul Glazby
125586 TIDYHF001D,Tidy,Paul Glazby
125587 TIDYHF001D,Tidy,Paul Maddox,Karim
125588 TIDYHF001D,Tidy,Paul Glazby,Karim
125589 TIDYHF001D,Tidy,Defective Audio
125590 TIDYHF001D,Tidy,Tony De Vit
125591 Various Artists, Harder Faster, Vol 1, Tidy, Hard House, Compilations, Toolbox Digital Download Harder Faster, Vol 1 by Tidy from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. TIDYHF001D,Tidy