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 (
    62561, 62560, 62559, 62558, 62557, 62556, 
    62555, 62554, 62553, 62552, 62551, 
    62550, 62549, 62548, 62547, 62546, 
    62545, 62544, 62543, 62542
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00030

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
62542 LWHDA06,LW Recordings,Bounce Enforcerz,Dj Oskar
62543 LWHDA06,LW Recordings,S3RL,LFZ
62544 LWHDA06,LW Recordings,Clayfacer
62545 LWHDA06,LW Recordings,Andrea Montorsi
62546 LWHDA06,LW Recordings,RR Reject
62547 LWHDA06,LW Recordings,Scott Attrill
62548 LWHDA06,LW Recordings,Charlie Goddard
62549 LWHDA06,LW Recordings,Munkjack
62550 LWHDA06,LW Recordings,Stu Infinity,Ganar
62551 LWHDA06,LW Recordings,John Carr
62552 LWHDA06,LW Recordings,Rob Gasser
62553 LWHDA06,LW Recordings,BloodDropz!
62554 LWHDA06,LW Recordings,NG Rezonance
62555 LWHDA06,LW Recordings,Dj Lote
62556 LWHDA06,LW Recordings,Ginex Assis,Adri RTD
62557 LWHDA06,LW Recordings,IP
62558 LWHDA06,LW Recordings,Chris Fear,Frikshon
62559 LWHDA06,LW Recordings,Haaradak
62560 LWHDA06,LW Recordings,Scott Attrill
62561 LWHDA06,LW Recordings,Dean Reid