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 (
    43825, 43824, 43823, 43822, 43821, 43820, 
    43819, 43818, 43817, 43816, 43815, 
    43814, 43813, 43812, 43811, 43810, 
    43809, 43808, 43807, 43806, 43805, 
    43804, 43803, 43802
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00038

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

Result

product_id meta_keywords meta_description search_words promo_text
43802 T-Factor, Tamerax, Ghost In A Shell, LW Recordings, Original Mix, Hard Dance, Toolbox Digital Download Ghost In A Shell (Original Mix) by LW Recordings from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. LWHDS07,LW Recordings,T-Factor,Tamerax
43803 BK, Ilogik, Real Life, LW Recordings, Original Mix, Hard Dance, Toolbox Digital Download Real Life (Original Mix) by LW Recordings from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. LWHDS07,LW Recordings,BK,Ilogik
43804 Daimon Hellstrom, Chopkicks, LW Recordings, Original Mix, Hard Dance, Toolbox Digital Download Chopkicks (Original Mix) by LW Recordings from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. LWHDS07,LW Recordings,Daimon Hellstrom
43805 Connected, Psychopath, LW Recordings, Original Mix, Hard Dance, Toolbox Digital Download Psychopath (Original Mix) by LW Recordings from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. LWHDS07,LW Recordings,Connected
43806 LWHDS07,LW Recordings,Bangerz & Masherz
43807 LWHDS07,LW Recordings,Nando Cp
43808 LWHDS07,LW Recordings,BloodDropz!
43809 Air Cralz, Dejotalberto, In The Mix, LW Recordings, Dejotalberto Remix, Hard Dance, Toolbox Digital Download In The Mix (Dejotalberto Remix) by LW Recordings from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. LWHDS07,LW Recordings,Air Cralz,Dejotalberto
43810 Hordy, Radiance, LW Recordings, Original Mix, Hard Dance, Toolbox Digital Download Radiance (Original Mix) by LW Recordings from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. LWHDS07,LW Recordings,Hordy
43811 Adam M, Master Blaster, LW Recordings, Original Mix, Hard Dance, Toolbox Digital Download Master Blaster (Original Mix) by LW Recordings from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. LWHDS07,LW Recordings,Adam M
43812 Valex, Waste Disposal, LW Recordings, Original Mix, Hard Dance, Toolbox Digital Download Waste Disposal (Original Mix) by LW Recordings from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. LWHDS07,LW Recordings,Valex
43813 LWHDS07,LW Recordings,Audio Hedz,Bret E Boy
43814 LWHDS07,LW Recordings,Rinski
43815 LWHDS07,LW Recordings,DJ Benchuscoro
43816 Adam Taylor, Kye Shand, Love On My Mind, LW Recordings, Original Mix, Hard Dance, Toolbox Digital Download Love On My Mind (Original Mix) by LW Recordings from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. LWHDS07,LW Recordings,Adam Taylor,Kye Shand
43817 Qm Corp, From NY To LA, LW Recordings, Original Mix, Hard Dance, Toolbox Digital Download From NY To LA (Original Mix) by LW Recordings from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. LWHDS07,LW Recordings,Qm Corp
43818 LWHDS07,LW Recordings,Ultra Violence,Blaine Hilton
43819 LWHDS07,LW Recordings,Dj Sombra,Lucia Da Fonte
43820 LWHDS07,LW Recordings,Mirjami,Rob Dee
43821 Obsidian Project, Party, LW Recordings, Original Mix, Hard Dance, Toolbox Digital Download Party (Original Mix) by LW Recordings from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. LWHDS07,LW Recordings,Obsidian Project
43822 Andy Farley, Grady G, Valex, Dr Dot, LW Recordings, Grady G Remix, Hard Dance, Toolbox Digital Download Dr Dot (Grady G Remix) by LW Recordings from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. LWHDS07,LW Recordings,Valex,Andy Farley,Grady G
43823 BK, Steve Hill, The Knuckleheadz, Fire Burning, LW Recordings, Original Mix, Hard Dance, Toolbox Digital Download Fire Burning (Original Mix) by LW Recordings from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. LWHDS07,LW Recordings,BK,Steve Hill,The Knuckleheadz
43824 LWHDS07,LW Recordings,Allan Berndtz
43825 LWHDS07,LW Recordings,Mike Steventon,Side E-Fect