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 (
    59482, 59481, 59480, 59479, 59478, 59477, 
    59476, 59475, 59474, 59473, 59472, 
    59471, 59470, 59469, 59468, 59467, 
    59466, 59465, 59464, 59463, 59462, 
    59461, 59460, 59459, 59458
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00040

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
59458 LWHDA04,LW Recordings,BloodDropz!
59459 LWHDA04,LW Recordings,Riffresh,Poomstyles
59460 LWHDA04,LW Recordings,Artificial Intelligence
59461 LWHDA04,LW Recordings,Faze2
59462 LWHDA04,LW Recordings,Milano The Don,Lunatix
59463 LWHDA04,LW Recordings,Critical Error
59464 LWHDA04,LW Recordings,Miss Fenetic
59465 LWHDA04,LW Recordings,Andy Whitby,Audox,Energy Syndicate
59466 Krystal, M-Project, Scott Brown, The Spark, LW Recordings, Original Mix, Hard Dance, Toolbox Digital Download The Spark (Original Mix) by LW Recordings from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. LWHDA04,LW Recordings,Scott Brown,M-Project,Krystal
59467 LWHDA04,LW Recordings,Bassmasters
59468 Cookie, Cookie 005, LW Recordings, Original Mix, Hard Dance, Toolbox Digital Download Cookie 005 (Original Mix) by LW Recordings from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. LWHDA04,LW Recordings,Cookie
59469 LWHDA04,LW Recordings,Mavrik
59470 LWHDA04,LW Recordings,Baz Coleman
59471 LWHDA04,LW Recordings,Noise Providers
59472 LWHDA04,LW Recordings,Dj Jesu
59473 LWHDA04,LW Recordings,Antix,Paranoiz
59474 LWHDA04,LW Recordings,Arkett Spyndl
59475 Matt Draper, NG Rezonance, Spearhead, LW Recordings, Original Mix, Featured Hard Trance New, Hard Trance, Toolbox Digital Download Spearhead (Original Mix) by LW Recordings from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. LWHDA04,LW Recordings,NG Rezonance,Matt Draper
59476 LWHDA04,LW Recordings,Side E-Fect,Busho
59477 LWHDA04,LW Recordings,Adam Dixon
59478 LWHDA04,LW Recordings,MEKK.1
59479 LWHDA04,LW Recordings,JBL Rockers
59480 LWHDA04,LW Recordings,Arkett Spyndl
59481 LWHDA04,LW Recordings,V-Tonez,Potential Energy
59482 LWHDA04,LW Recordings,Matt Draper