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 (
    42450, 42449, 42448, 42447, 42446, 42445, 
    42444, 42443, 42442, 42441, 42440, 
    42439, 42438, 42437, 42436, 42435, 
    42433, 42271, 42270, 42269
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00034

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
42269 LWWAHH15,LW Recordings,Lunatic Response Unit
42270 LWWAHH15,LW Recordings,Kinermanic,Nikkdbubble
42271 LWWAHH15,LW Recordings
42433 LWEGHD12,LW Recordings,Argy,Re-Tech
42435 NG Rezonance, PHD, Believe, LW Recordings, Original Mix, Hard Dance, Toolbox Digital Download Believe (Original Mix) by LW Recordings from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. LWEGHD12,LW Recordings,NG Rezonance,PHD
42436 LWEGHD12,LW Recordings,BloodDropz!
42437 LWEGHD12,LW Recordings,Roger Bonner
42438 Criostasis, T-Factor, Changes, LW Recordings, Criostasis Remix, Hard Dance, Toolbox Digital Download Changes (Criostasis Remix) by LW Recordings from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. LWEGHD12,LW Recordings,T-Factor,Criostasis
42439 LWEGHD12,LW Recordings,Gaz O'H
42440 LWEGHD12,LW Recordings,CJ Alexis
42441 LWEGHD12,LW Recordings,Eyoung
42442 LWEGHD12,LW Recordings,Noizy Boy
42443 LWEGHD12,LW Recordings,DJ Arbrandt
42444 Charlie Goddard, Digital Mafia, Sonik, Am I Crazy, LW Recordings, Charlie Goddard Remix, Hard Dance, Toolbox Digital Download Am I Crazy (Charlie Goddard Remix) by LW Recordings from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. LWEGHD12,LW Recordings,Digital Mafia,Sonik,Charlie Goddard
42445 LWEGHD12,LW Recordings,Vinylgroover,The Red Hed,L.E.D.
42446 LWEGHD12,LW Recordings,Jack dB
42447 Bass Jumper, Energy Syndicate, When It Drops, LW Recordings, Original Mix, Hard Dance, Toolbox Digital Download When It Drops (Original Mix) by LW Recordings from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. LWEGHD12,LW Recordings,Energy Syndicate,Bass Jumper
42448 LWEGHD12,LW Recordings,Axamathic The Senthime
42449 Charlie Goddard, Dawson, Exploration, LW Recordings, Original Mix, Hard Dance, Toolbox Digital Download Exploration (Original Mix) by LW Recordings from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. LWEGHD12,LW Recordings,Charlie Goddard,Dawson
42450 Darren Pearce, Bullshit Man, LW Recordings, Original Mix, Hard Dance, Toolbox Digital Download Bullshit Man (Original Mix) by LW Recordings from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. LWEGHD12,LW Recordings,Darren Pearce