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 (
    61684, 61683, 61682, 61681, 61680, 61679, 
    61678, 60692, 60691, 60690, 60689, 
    60688, 60687, 60686, 60685, 60684, 
    60683, 60682, 60681, 60680
  ) 
  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
60680 LWHDA05,LW Recordings,S3RL,Harri Rush
60681 LWHDA05,LW Recordings,Syrin
60682 LWHDA05,LW Recordings,Audio Hedz,Tamerax,Kina Forney
60683 LWHDA05,LW Recordings,Snatt & Vix,Alex Staltari,Jason Bouse
60684 LWHDA05,LW Recordings,AJ Battuta
60685 LWHDA05,LW Recordings,Systemic Noise,Olie S
60686 LWHDA05,LW Recordings,Scott Attrill
60687 LWHDA05,LW Recordings,Starman,Energy Syndicate
60688 LWHDA05,LW Recordings,Aaron Morgan
60689 LWHDA05,LW Recordings,Robbie Teeze
60690 LWHDA05,LW Recordings,Chris Dynasty,Splinta
60691 LWHDA05,LW Recordings,Krtek Elektronika
60692 Various Artists, Hard Dance Anthems, Vol. 05, LW Recordings, Featured Compilations, Hard Dance, Compilations, Toolbox Digital Download Hard Dance Anthems, Vol. 05 by LW Recordings from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. LWHDA05,LW Recordings
61678 LWEGHH12,LW Recordings,Juan Ruiz
61679 The Sticky Bandits, Fire Power, LW Recordings, Original Mix, Featured Hard House New, Hard House, Toolbox Digital Download Fire Power (Original Mix) by LW Recordings from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. LWEGHH12,LW Recordings,The Sticky Bandits
61680 LWEGHH12,LW Recordings,Matt Wade,D:Fi
61681 Andy Farley, Dutty Diana, LW Recordings, Original Mix, Featured Hard House New, Hard House, Toolbox Digital Download Dutty Diana (Original Mix) by LW Recordings from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. LWEGHH12,LW Recordings,Andy Farley
61682 LWEGHH12,LW Recordings,Tara Banks
61683 LWEGHH12,LW Recordings,Vandalize
61684 LWEGHH12,LW Recordings,MHX