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 (
    63613, 63611, 63610, 63609, 63608, 63607, 
    63606, 63605, 63604, 63046, 63045, 
    63044, 63043, 63042, 63041, 63040, 
    63039, 63038, 63037, 63036
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00037

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
63036 LWHTA07,LW Recordings,Kamil Van Derson
63037 LWHTA07,LW Recordings,Roman Faero
63038 LWHTA07,LW Recordings,Tito K.
63039 LWHTA07,LW Recordings,Tonikattitude,ReneHell
63040 LWHTA07,LW Recordings,Aniss Hypnoise,Fabian Jakopetz,Phutek
63041 LWHTA07,LW Recordings,George Makrakis,Mtech
63042 LWHTA07,LW Recordings,Tom Iron,Tonikattitude
63043 LWHTA07,LW Recordings,DIRCRONE,Ampless
63044 LWHTA07,LW Recordings,Champas,Dennis Wehling
63045 LWHTA07,LW Recordings,Almir Ljusa,Dj Brutec
63046 LWHTA07,LW Recordings
63604 LWEGHH13,LW Recordings,#Rolling Out
63605 LWEGHH13,LW Recordings,$hano
63606 LWEGHH13,LW Recordings,$hano
63607 LWEGHH13,LW Recordings,12 Inch Thumpers,Knuckleheadz
63608 LWEGHH13,LW Recordings,2 Bald Men,Rick James
63609 LWEGHH13,LW Recordings,2 Twisted Twunts
63610 LWEGHH13,LW Recordings,5D Psychic Systems
63611 LWEGHH13,LW Recordings,A Mega Noise
63613 LWEGHH13,LW Recordings,Aaron James