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 (
    60679, 60678, 60677, 60676, 60675, 60674, 
    60673, 60672, 60671, 60670, 60669, 
    60668, 60667, 60312, 60311, 60310, 
    60309, 60308, 60307, 60306
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00072

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
60306 LWEGHH11,LW Recordings,Mick Doyle,Jim Morris
60307 LWEGHH11,LW Recordings,Delusion
60308 LWEGHH11,LW Recordings,Dave Owens
60309 LWEGHH11,LW Recordings,Rowdie
60310 Dark Element, Ian M, Exquiste, LW Recordings, Original Mix, Featured Hard House New, Hard House, Toolbox Digital Download Exquiste (Original Mix) by LW Recordings from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. LWEGHH11,LW Recordings,Ian M,Dark Element
60311 LWEGHH11,LW Recordings,Sound Forces,Alphatech_5
60312 Various Artists, Essential Guide: Hard House, Vol. 11, LW Recordings, Featured Compilations, Hard House, Compilations, Toolbox Digital Download Essential Guide: Hard House, Vol. 11 by LW Recordings from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. LWEGHH11,LW Recordings
60667 LWHDA05,LW Recordings,Groove Complex
60668 Andy Whitby, Audox, To The Weekend, LW Recordings, 2017 Remix, Featured Hard Dance New, Hard Dance, Toolbox Digital Download To The Weekend (2017 Remix) 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,Andy Whitby,Audox
60669 LWHDA05,LW Recordings,Just Jack,Kane,Ganar
60670 LWHDA05,LW Recordings,BloodDropz!
60671 LWHDA05,LW Recordings,Fantoman,CJ Alexis
60672 LWHDA05,LW Recordings,Arkett Spyndl
60673 LWHDA05,LW Recordings,Danny Fierce
60674 LWHDA05,LW Recordings,Haaradak
60675 LWHDA05,LW Recordings,IP
60676 LWHDA05,LW Recordings,Splinta,Vthekid
60677 RR Reject, Hood Anthem, LW Recordings, Original Mix, Featured Hard Dance New, Hard Dance, Toolbox Digital Download Hood Anthem (Original Mix) 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,RR Reject
60678 LWHDA05,LW Recordings,Project D
60679 LWHDA05,LW Recordings,Scott Brown,A.B