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 (
    43593, 43592, 43591, 43590, 43589, 43588, 
    43587, 43586, 43585, 43584, 43583, 
    43582, 43581, 43580, 43579, 43578, 
    43577, 43576, 43575, 43574
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00032

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
43574 LWEGHD13,LW Recordings,Charm Offensive
43575 Jody 6, You Got Me Turning, LW Recordings, Original Mix, Hard Dance, Toolbox Digital Download You Got Me Turning (Original Mix) by LW Recordings from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. LWEGHD13,LW Recordings,Jody 6
43576 Andy Whitby, Haterz, LW Recordings, Original Mix, Hard Dance, Toolbox Digital Download Haterz (Original Mix) by LW Recordings from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. LWEGHD13,LW Recordings,Andy Whitby
43577 SystemShock, Solaris, LW Recordings, Original Mix, Hard Dance, Toolbox Digital Download Solaris (Original Mix) by LW Recordings from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. LWEGHD13,LW Recordings,SystemShock
43578 LWEGHD13,LW Recordings,Gerry B
43579 Ben Stevens, Dr Device, Send Them To The Cemetery, LW Recordings, Original Mix, Hard Dance, Toolbox Digital Download Send Them To The Cemetery (Original Mix) by LW Recordings from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. LWEGHD13,LW Recordings,Dr Device,Ben Stevens
43580 LWEGHD13,LW Recordings,Mike Steventon,Side E-Fect
43581 LWEGHD13,LW Recordings,Y.L.G
43582 Air Cralz, Dejotalberto, Saying, LW Recordings, Air Cralz Remix, Hard Dance, Toolbox Digital Download Saying (Air Cralz Remix) by LW Recordings from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. LWEGHD13,LW Recordings,Air Cralz,Dejotalberto
43583 BK, Steve Hill, The Knuckleheadz, Trap Two, Fire Burning, LW Recordings, Trap Two's Harbaceous Remix, Hard Dance, Toolbox Digital Download Fire Burning (Trap Two's Harbaceous Remix) by LW Recordings from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. LWEGHD13,LW Recordings,BK,Steve Hill,The Knuckleheadz,Trap Two
43584 Lee Walls, Pure Thrust, LW Recordings, Original Mix, Hard Dance, Toolbox Digital Download Pure Thrust (Original Mix) by LW Recordings from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. LWEGHD13,LW Recordings,Lee Walls
43585 LWEGHD13,LW Recordings,Audio Hedz,Bret E Boy
43586 Blair Hilton, VTheKid, PowerGlider, LW Recordings, Original Mix, Hard Dance, Toolbox Digital Download PowerGlider (Original Mix) by LW Recordings from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. LWEGHD13,LW Recordings,Vthekid,Blair Hilton
43587 Kumite., Misconceptions, LW Recordings, Original Mix, Hard Dance, Toolbox Digital Download Misconceptions (Original Mix) by LW Recordings from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. LWEGHD13,LW Recordings,Kumite.
43588 LWEGHD13,LW Recordings,Datraxx
43589 LWEGHD13,LW Recordings,Alex Tr
43590 Adam M, Tenchy, Jawklencher, LW Recordings, Original Mix, Hard Dance, Toolbox Digital Download Jawklencher (Original Mix) by LW Recordings from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. LWEGHD13,LW Recordings,Adam M,Tenchy
43591 LWEGHD13,LW Recordings,Noizy Boy
43592 LWEGHD13,LW Recordings,DJ Marininsk
43593 LWEGHD13,LW Recordings,Matt Alliss