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 (
    47948, 47947, 47946, 47945, 47944, 47943, 
    47942, 47941, 47940, 47939, 47938, 
    47937, 47936, 47935, 47934, 47933, 
    47932, 47806, 47805, 47804
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00031

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
47804 LWWHAHC11,LW Recordings,Scott Brown
47805 LWWHAHC11,LW Recordings,Demize,Miss Special K
47806 LWWHAHC11,LW Recordings
47932 LWEGHH02,LW Recordings,Phoenix
47933 Dave Owens, Wild Street, LW Recordings, Original Mix, Hard House, Toolbox Digital Download Wild Street (Original Mix) by LW Recordings from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. LWEGHH02,LW Recordings,Dave Owens
47934 LWEGHH02,LW Recordings,Mick Doyle,Kyle Kemp
47935 LWEGHH02,LW Recordings,Bowie666,Eclectic Beatz DJ
47936 LWEGHH02,LW Recordings,Matt Mara,Matt Capitani
47937 LWEGHH02,LW Recordings,Bass Destruction
47938 LWEGHH02,LW Recordings,Dan Joseph
47939 LWEGHH02,LW Recordings,DJ Colas NG
47940 James Nardi, Ice Man, LW Recordings, Original Mix, Hard House, Toolbox Digital Download Ice 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. LWEGHH02,LW Recordings,James Nardi
47941 Mumbles, What We Gonna Do, LW Recordings, Original Mix, Hard House, Toolbox Digital Download What We Gonna Do (Original Mix) by LW Recordings from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. LWEGHH02,LW Recordings,Mumbles
47942 LWEGHH02,LW Recordings,Wayne G
47943 LWEGHH02,LW Recordings,Nando Cp
47944 LWEGHH02,LW Recordings,Irra DJ,DJ Moix
47945 LWEGHH02,LW Recordings,Chucky,Matt Clarkson
47946 LWEGHH02,LW Recordings,Nippy Baines,Psydef
47947 Gaz Frost, Matt Clarkson, Hip House, LW Recordings, Original Mix, Hard House, Toolbox Digital Download Hip House (Original Mix) by LW Recordings from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. LWEGHH02,LW Recordings,Gaz Frost,Matt Clarkson
47948 LWEGHH02,LW Recordings,Miles