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 (
    60005, 60004, 60003, 59483, 59482, 59481, 
    59480, 59479, 59478, 59477, 59476, 
    59475, 59474, 59473, 59472, 59471, 
    59470, 59469, 59468, 59467
  ) 
  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 20 Using where

Result

product_id meta_keywords meta_description search_words promo_text
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
59483 Various Artists, Hard Dance Anthems, Vol. 04, LW Recordings, Featured Compilations, Hard Trance, Compilations, Toolbox Digital Download Hard Dance Anthems, Vol. 04 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
60003 LWHTA05,LW Recordings,Gene Karz,Lesia Karz
60004 LWHTA05,LW Recordings,Hardom
60005 LWHTA05,LW Recordings,DJ Reversive