SELECT 
  cscart_product_descriptions.product_id, 
  cscart_product_descriptions.short_description, 
  IF(
    cscart_product_descriptions.short_description = '' 
    OR cscart_product_descriptions.short_description IS NULL, 
    cscart_product_descriptions.full_description, 
    ''
  ) AS full_description, 
  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 (
    54608, 54607, 54606, 54605, 54604, 54603, 
    54602, 54601, 54600, 54599, 54598, 
    54597, 54596, 54595, 54594, 54593, 
    54592, 54591, 54590, 54589, 54588, 
    54587, 54586, 54441, 54366, 54365, 
    54263, 54262, 54261, 54204, 54140, 
    54135, 54132, 54208, 54371, 54370, 
    54368, 54110, 54082, 54081, 54080, 
    54079, 54056, 54053, 54052, 54647, 
    54646, 54645, 54644, 54643, 54642, 
    54641, 54640, 54639, 54638, 54324, 
    54278, 54277, 54276, 53951, 53945, 
    53932, 53915, 53914, 53913, 53912, 
    53911, 53910, 53909, 53908, 53901, 
    53897, 53896, 53895, 53887, 54447, 
    54446, 54445, 54444, 53790
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00095

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

Result

product_id short_description full_description meta_keywords meta_description search_words promo_text
53790 M-Project, Scott Brown, Enlightened, Evolution Records, M-Project Remix, Featured Hardcore New, Hardcore, Toolbox Digital Download Enlightened (M-Project Remix) by Evolution Records from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. Ev163,Evolution Records,Scott Brown,M-Project
53887 Eufeion, Gemma MacLeod, Darkness Falls, Ninja Hardcore, 2016 Update, Featured Hardcore New, Hardcore, Toolbox Digital Download Darkness Falls (2016 Update) by Ninja Hardcore from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. NINJAHC004,Ninja Hardcore,Eufeion,Gemma Macleod
53895 ncr011,Neurotoxin Cobra Records,Mirai Rukia
53896 ncr011,Neurotoxin Cobra Records,Mirai Rukia
53897 ncr011,Neurotoxin Cobra Records,Mirai Rukia
53901 Javi Tracker, Soulish Language, Desk Records, Original Mix, Featured Hardcore New, Hardcore, Toolbox Digital Download Soulish Language (Original Mix) by Desk Records from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. DR075,Desk Records,Javi Tracker
53908 UITTR002,Uptempo Is The Tempo Records,Sjammienators,Ysiss
53909 UITTR002,Uptempo Is The Tempo Records,Lunakorpz,Tim shopp
53910 UITTR002,Uptempo Is The Tempo Records,Unproven
53911 UITTR002,Uptempo Is The Tempo Records,MBK
53912 UITTR002,Uptempo Is The Tempo Records,Mindspitter
53913 UITTR002,Uptempo Is The Tempo Records,Psycho Killer,Blaeserbass
53914 UITTR002,Uptempo Is The Tempo Records,Psycho Killer
53915 UITTR002,Uptempo Is The Tempo Records,Sequencer
53932 swg022,SWG Music,RDC
53945 Jakka-B, MC Messiah, Freak On, Totally Ardcore Records, Hardcore Mix, Featured Hardcore New, Hardcore, Toolbox Digital Download Freak On (Hardcore Mix) by Totally Ardcore Records from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. TA027,Totally Ardcore Records,Jakka-B,MC Messiah
53951 JTS, Steve Hill, Technikal, Right Here Right Now, OneSeventy, JTS Remix, Featured Hardcore New, Hardcore, Toolbox Digital Download Right Here Right Now (JTS Remix) by OneSeventy from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. ONESEVENTY11,OneSeventy,Steve Hill,Technikal,JTS
54052 PCR044,Peacock Records,Dr. Peacock & The Whistlers
54053 PCR044,Peacock Records,The Whistlers
54056 Alex Prospect, Bassline Animals, Great Escape, Go Hard Digital, Original Mix, Featured Hardcore New, Hardcore, Toolbox Digital Download Great Escape (Original Mix) by Go Hard Digital from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. GHD002,Go Hard Digital,Bassline Animals,Alex Prospect
54079 ncr012,Neurotoxin Cobra Records,Tito K.
54080 ncr012,Neurotoxin Cobra Records,Tito K.
54081 ncr012,Neurotoxin Cobra Records,Tito K.
54082 ncr012,Neurotoxin Cobra Records,Tito K.
54110 Jason Bouse, Perfect, Broken Records UK, Original Mix, Featured Hardcore New, Hardcore, Toolbox Digital Download Perfect (Original Mix) by Broken Records UK from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. BR0025,Broken Records UK,Jason Bouse
54132 DJ Jedi, Radiosam, Double Impact, Jedi Recordings, Original Mix, Old Skool, Featured Hardcore New, Hardcore, Toolbox Digital Download Double Impact (Original Mix) by Jedi Recordings from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. JEDI15A,Jedi Recordings,DJ Jedi,Radiosam
54135 Big D, Harry Hard, Mr Ripley, Into The Night, Cheeky Tracks, Mr Ripley 'Cheek300' Remix, Featured Hardcore New, Hardcore, Toolbox Digital Download Into The Night (Mr Ripley 'Cheek300' Remix) by Cheeky Tracks from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. Cheek300,Cheeky Tracks,Big D,Harry Hard,Mr Ripley
54140 STI082,Stomp-Inc UK,Area 51
54204 Chris Fear, Knowledge, Core Fever, Original Mix, Featured Hardcore New, Hardcore, Toolbox Digital Download Knowledge (Original Mix) by Core Fever from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. CF052,Core Fever,Chris Fear
54208 Hotchkiss, Reflections, Evolution Records, Original Mix, Featured Hardcore New, Hardcore, Toolbox Digital Download Reflections (Original Mix) by Evolution Records from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. Ev164,Evolution Records,Hotchkiss
54261 ncr013,Neurotoxin Cobra Records,Mark Cowax
54262 ncr013,Neurotoxin Cobra Records,Mark Cowax,Batteriebetrieb
54263 ncr013,Neurotoxin Cobra Records,Mark Cowax,Alex Turner
54276 FFR011,Flight Force Records,Lyon Kise
54277 FFR011,Flight Force Records,Lyon Kise
54278 FFR011,Flight Force Records,Lyon Kise
54324 Drew Derivative, Remane, Reaktion, Executive Records, Original Mix, Featured Hardcore New, Hardcore, Toolbox Digital Download Reaktion (Original Mix) by Executive Records from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. EXE070,Executive Records,Remane,Drew Derivative
54365 STM036,Stamina Records,A.B,Finnbarr
54366 STM036,Stamina Records,A.B,Finnbarr
54368 Joey Riot, Macks Wolf, Reflux, The Other Side, Scarred Digital, Macks Wolf Remix, Featured Hardcore New, Hardcore, Toolbox Digital Download The Other Side (Macks Wolf Remix) by Scarred Digital from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. SD100,Scarred Digital,Joey Riot,Reflux,Macks Wolf
54370 SD100,Scarred Digital,Joey Riot,Reflux,Ganah
54371 BFR1016,Bassface Recordings,Sash Dee,Frankforce One,MC Trax
54441 Buzzman, Lost Witness, Mark Breeze, Summa Jae, Rise Again, Futurecore, Buzzman & Summa Jae Remix, Featured Hardcore New, Hardcore, Toolbox Digital Download Rise Again (Buzzman & Summa Jae Remix) by Futurecore from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. FCORE011,Futurecore,Mark Breeze,Lost Witness,Buzzman,Summa Jae
54444 Digital22,Cenobite Records,Formek
54445 Digital22,Cenobite Records,Formek
54446 Digital22,Cenobite Records,Formek,Danytribe
54447 Digital22,Cenobite Records,Formek
54586 NCR2016,Neurotoxin Cobra Records,Batteriebetrieb,Hellmekanism
54587 NCR2016,Neurotoxin Cobra Records,KrustBro
54588 NCR2016,Neurotoxin Cobra Records,Intoxx,Batteriebetrieb
54589 NCR2016,Neurotoxin Cobra Records,Deepscreen
54590 NCR2016,Neurotoxin Cobra Records,Mot3K
54591 NCR2016,Neurotoxin Cobra Records,Batteriebetrieb,Mark Cowax
54592 NCR2016,Neurotoxin Cobra Records,Intoxx
54593 NCR2016,Neurotoxin Cobra Records,Mark Cowax,Batteriebetrieb
54594 NCR2016,Neurotoxin Cobra Records,Fresh Otis,Batteriebetrieb
54595 NCR2016,Neurotoxin Cobra Records,Fresh Otis
54596 NCR2016,Neurotoxin Cobra Records,Der Prediger
54597 NCR2016,Neurotoxin Cobra Records,Intoxx,Ruud S
54598 NCR2016,Neurotoxin Cobra Records,Mirai Rukia
54599 NCR2016,Neurotoxin Cobra Records,Tito K.
54600 NCR2016,Neurotoxin Cobra Records,Batteriebetrieb,Revolucer Fraktion
54601 NCR2016,Neurotoxin Cobra Records,Tito K.
54602 NCR2016,Neurotoxin Cobra Records,Van Dexter
54603 NCR2016,Neurotoxin Cobra Records,Van Dexter
54604 NCR2016,Neurotoxin Cobra Records,Alex Turner,Human Aether
54605 NCR2016,Neurotoxin Cobra Records,Intoxx
54606 NCR2016,Neurotoxin Cobra Records,E-Toxx
54607 NCR2016,Neurotoxin Cobra Records,Beatus Ben Ray
54608 NCR2016,Neurotoxin Cobra Records,Mark Cowax
54638 VDVV002,Venom Drive,ANCore
54639 VDVV002,Venom Drive,Brenergy
54640 VDVV002,Venom Drive,Brodster
54641 VDVV002,Venom Drive,Estcore
54642 VDVV002,Venom Drive,Lingreent
54643 VDVV002,Venom Drive,litmus*,Pointless
54644 VDVV002,Venom Drive,NDEX
54645 VDVV002,Venom Drive,ViolonC
54646 VDVV002,Venom Drive,X-A7T,Camo & Hazelnut
54647 VDVV002,Venom Drive,zalas