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 (
    125590, 125589, 125588, 125587, 125586, 
    125585, 125584, 125583, 125582, 125581, 
    125580, 125579, 125578, 125577, 125576, 
    125575, 125574, 125573, 125572, 125571, 
    125570, 125569, 125568, 125567, 125566, 
    125565, 125564, 125563, 125562, 125561, 
    125560, 125559, 125558, 125557
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00216

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

Result

product_id meta_keywords meta_description search_words promo_text
125557 TIDYHF001D,Tidy,Andy Farley,BK
125558 TIDYHF001D,Tidy,Organ Donors
125559 TIDYHF001D,Tidy,Anne Savage
125560 TIDYHF001D,Tidy,BK,JP,Jukesy
125561 TIDYHF001D,Tidy,Dave Owens
125562 TIDYHF001D,Tidy,Ben Stevens
125563 TIDYHF001D,Tidy,Base Graffiti
125564 TIDYHF001D,Tidy,Stimulant DJ's,Captain Tinrib
125565 TIDYHF001D,Tidy,UK Gold,Ilogik
125566 BK, Lucy Fur, Get Hot, Tidy, Extended Mix, Hard House, Toolbox Digital Download Get Hot (Extended Mix) by Tidy from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. TIDYHF001D,Tidy,BK,Lucy Fur
125567 TIDYHF001D,Tidy,Dyewitness,Ian M
125568 OD404, Tara Reynolds, Mercy, Tidy, OD404 Extended Remix, Hard House, Toolbox Digital Download Mercy (OD404 Extended Remix) by Tidy from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. TIDYHF001D,Tidy,Tara Reynolds,OD404
125569 TIDYHF001D,Tidy,Paul Maddox
125570 TIDYHF001D,Tidy,Sharky & Bones
125571 TIDYHF001D,Tidy,Ilogik,UK Gold
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