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 (
    54127, 54126, 54125, 54124, 54123, 54122, 
    54121, 54120, 54119, 54118, 54117, 
    54116, 54115, 54114, 54113
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00059

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 15 Using where

Result

product_id meta_keywords meta_description search_words promo_text
54113 Fruit Machine, Robbie Muir, The Change, Toolbox Recordings, Fruit Machine Remix, Hard House, Exclusive, Toolbox Digital Download The Change (Fruit Machine Remix) by Toolbox Recordings from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more.
54114 Fruit Machine, 2p A Go, Toolbox Recordings, Original MIx, Hard House, Exclusive, Toolbox Digital Download 2p A Go (Original MIx) by Toolbox Recordings from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more.
54115 Fruit Machine, 7th Heaven, Toolbox Recordings, Original Mix, Hard House, Exclusive, Toolbox Digital Download 7th Heaven (Original Mix) by Toolbox Recordings from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more.
54116 Fruit Machine, Ross Homson, Tatty Bojangles, Toolbox Recordings, Fruit Machine Remix, Hard House, Exclusive, Toolbox Digital Download Tatty Bojangles (Fruit Machine Remix) by Toolbox Recordings from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more.
54117 Fruit Machine, Jackpot, Toolbox Recordings, Original Mix, Hard House, Exclusive, Toolbox Digital Download Jackpot (Original Mix) by Toolbox Recordings from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more.
54118 Fruit Machine, What Happens In Vegas, Toolbox Recordings, Original Mix, Featured Hard House New, Hard House, Toolbox Digital Download What Happens In Vegas (Original Mix) by Toolbox Recordings from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more.
54119 Fruit Machine, Hells Bells, Toolbox Recordings, Original Mix, Featured Hard House New, Hard House, Toolbox Digital Download Hells Bells (Original Mix) by Toolbox Recordings from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more.
54120 Fruit Machine, Game Over, Toolbox Recordings, Original Mix, Hard House, Exclusive, Toolbox Digital Download Game Over (Original Mix) by Toolbox Recordings from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more.
54121 Fruit Machine, One Arm Bandit, Toolbox Recordings, Original Mix, Hard House, Exclusive, Toolbox Digital Download One Arm Bandit (Original Mix) by Toolbox Recordings from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more.
54122 Fruit Machine, Pulse Fiction, Electric Disco, Toolbox Recordings, Fruit Machine Remix, Hard House, Exclusive, Toolbox Digital Download Electric Disco (Fruit Machine Remix) by Toolbox Recordings from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more.
54123 Fruit Machine, You're Fired, Toolbox Recordings, Original Mix, Hard House, Exclusive, Toolbox Digital Download You're Fired (Original Mix) by Toolbox Recordings from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more.
54124 Fruit Machine, Top Of The Cherry, Toolbox Recordings, Original Mix, Featured Hard House New, Hard House, Toolbox Digital Download Top Of The Cherry (Original Mix) by Toolbox Recordings from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more.
54125 Fruit Machine, 99 Nudges, Toolbox Recordings, Original Mix, Hard House, Exclusive, Toolbox Digital Download 99 Nudges (Original Mix) by Toolbox Recordings from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more.
54126 Fruit Machine, Bars All The Way, Toolbox Recordings, Original Mix, Hard House, Exclusive, Toolbox Digital Download Bars All The Way (Original Mix) by Toolbox Recordings from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more.
54127 Fruit Machine, Nik Denton, Paul King, Spacehopper, Toolbox Recordings, Fruit Machine Remix, Hard House, Exclusive, Toolbox Digital Download Spacehopper (Fruit Machine Remix) by Toolbox Recordings from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more.