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 (
    46924, 46923, 46922, 46873, 46872, 46871, 
    46870, 46869, 46868, 46867, 46866, 
    46865, 46864, 46863, 46862, 46861, 
    46860, 46859, 46858, 46857, 46624, 
    46568, 46567, 46565, 46822, 46821, 
    46820, 46819, 46901, 46900, 46899, 
    46898, 46897, 46896, 46895, 46894, 
    46893, 46892, 46891, 46890, 46889, 
    46888, 46887, 46886, 46885, 46884, 
    46883, 46882, 46881, 46880, 46879, 
    46878, 46877, 46621, 46620, 46619, 
    46618, 46617, 46616, 46615, 46614, 
    46613, 46535, 46534, 46533, 46532, 
    46519, 46477, 46472, 46471, 46437, 
    46702, 46701, 46700, 46699, 46348, 
    46329, 46580, 46579, 46358
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00084

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
46329 Billy M, Richie, All The Time In The World, Ballistik Hardcore, Original Mix, Hardcore, Toolbox Digital Download All The Time In The World (Original Mix) by Ballistik Hardcore from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. BH032,Ballistik Hardcore,Richie,Billy M
46348 Infexious, Out My Mind, Contagious Records, Original Mix, Hardcore, Toolbox Digital Download Out My Mind (Original Mix) by Contagious Records from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. CR0105,Contagious Records,Infexious
46358 EMF067,Emfa Music,S3RL
46437 Jaw D, Destroyer, Universal Hardcore Digital, Original Mix, Hardcore, Toolbox Digital Download Destroyer (Original Mix) by Universal Hardcore Digital from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. UHD084,Universal Hardcore Digital,Jaw D
46471 Danox, Tolo, Musi-K, Desk Records, Original Mix, Hardcore, Toolbox Digital Download Musi-K (Original Mix) by Desk Records from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. DR049,Desk Records,Danox,Tolo
46472 DR049,Desk Records,Danox,Tolo
46477 Future Shock, Vicky Fee, Weaver, Fading Away, Executive Records, Future Shock Remix, Hardcore, Toolbox Digital Download Fading Away (Future Shock Remix) by Executive Records from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. EXE061,Executive Records,Weaver,Vicky Fee,Future Shock
46519 Darren Styles, Gavin Beach, Before The Sun, Together We Rise, Original Mix, Hardcore, Toolbox Digital Download Before The Sun (Original Mix) by Together We Rise from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. TWR18,Together We Rise,Darren Styles,Gavin Beach
46532 FFR005,Flight Force Records,Mr. Tommy
46533 FFR005,Flight Force Records,Mr. Tommy
46534 FFR005,Flight Force Records,Mr. Tommy
46535 FFR005,Flight Force Records,Mr. Tommy
46565 Ektomorph, Like An Animal, Ballistik Hardcore, Original Mix, Hardcore, Toolbox Digital Download Like An Animal (Original Mix) by Ballistik Hardcore from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. BH033,Ballistik Hardcore,Ektomorph
46567 Skinny, Cut It Up, Notorious Vinyl, Original Mix, Hardcore, Toolbox Digital Download Cut It Up (Original Mix) by Notorious Vinyl from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. NOTV026,Notorious Vinyl,Skinny
46568 Black Ace, Heinz Fourie, Grim Reaper, Contagious Records, Original Mix, Hardcore, Toolbox Digital Download Grim Reaper (Original Mix) by Contagious Records from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. CR0106,Contagious Records,Black Ace,Heinz Fourie
46579 PCR028,Peacock Records,Brutal Jesters,Dr. Peacock,Mystika
46580 PCR028,Peacock Records,Brutal Jesters
46613 HUAACD006,Hardcore Underground,Fracus & Darwin,Bass Selective
46614 HUAACD006,Hardcore Underground,Fracus & Darwin,Jenna
46615 Darwin, Fracus, Break These Records, Hardcore Underground, Original Mix, Hardcore, Toolbox Digital Download Break These Records (Original Mix) by Hardcore Underground from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. HUAACD006,Hardcore Underground,Fracus,Darwin
46616 HUAACD006,Hardcore Underground,Fracus & Darwin,Poison Rain
46617 HUAACD006,Hardcore Underground,Fracus,Darwin
46618 HUAACD006,Hardcore Underground,Fracus,Darwin
46619 HUAACD006,Hardcore Underground,Fracus,Darwin
46620 HUAACD006,Hardcore Underground,Fracus,Darwin
46621 HUAACD006,Hardcore Underground,Fracus & Darwin,Pearl Blue
46624 Scott Brown, Waves, Evolution Records, Original Mix, Hardcore, Toolbox Digital Download Waves (Original Mix) by Evolution Records from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. Ev130,Evolution Records,Scott Brown
46699 EvLeg9,Evolution Records,Bass-X
46700 EvLeg9,Evolution Records,Bass-X
46701 EvLeg9,Evolution Records,Bass-X
46702 EvLeg9,Evolution Records,Bass-X,Scott Brown
46819 Ev14,Evolution Records,Q-Tex
46820 Ev14,Evolution Records,Q-Tex
46821 Q-Tex, Get On The Floor, Evolution Records, Original Mix, Hardcore, Toolbox Digital Download Get On The Floor (Original Mix) by Evolution Records from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. Ev14,Evolution Records,Q-Tex
46822 Ev14,Evolution Records,Q-Tex
46857 Evmix005,Evolution Records,The Scotchman
46858 Evmix005,Evolution Records,Mr Brown
46859 Evmix005,Evolution Records,Scott Brown
46860 Evmix005,Evolution Records,Genaside
46861 Evmix005,Evolution Records,Mr Brown
46862 Evmix005,Evolution Records,Genaside
46863 Evmix005,Evolution Records,Firestarter
46864 Evmix005,Evolution Records,Sub-Source
46865 Evmix005,Evolution Records,Scott Brown
46866 Evmix005,Evolution Records,Renegade,Static,Scott Brown
46867 Evmix005,Evolution Records,Scott Brown
46868 Evmix005,Evolution Records,The Scotchman
46869 Evmix005,Evolution Records,Kinetic Pleasure,Scott Brown
46870 Evmix005,Evolution Records,Scott Brown,Davie Forbes
46871 Evmix005,Evolution Records,Genaside
46872 Evmix005,Evolution Records,Scott Brown,Omar Santana
46873 Evmix005,Evolution Records,Genaside,Bass-x
46877 LWWHAHC10,LW Recordings,Clowny
46878 LWWHAHC10,LW Recordings,Bass Reaction
46879 LWWHAHC10,LW Recordings,Dowster and Vagabond
46880 LWWHAHC10,LW Recordings,Paul EP,Smithy,Mob
46881 LWWHAHC10,LW Recordings,Anon,X-FIR3,Sensation
46882 LWWHAHC10,LW Recordings,IYF,Burtside
46883 Eufeion, Gemma MacLeod, Patch, Flying, LW Recordings, Wings Of Love) (Eufeion 2015 Remix, Hardcore, Toolbox Digital Download Flying (Wings Of Love) (Eufeion 2015 Remix) by LW Recordings from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. LWWHAHC10,LW Recordings,Eufeion,Patch,Gemma MacLeod
46884 LWWHAHC10,LW Recordings,Ganar
46885 LWWHAHC10,LW Recordings,Hyperact
46886 LWWHAHC10,LW Recordings,Overdrive
46887 LWWHAHC10,LW Recordings,Riko,Jaxx
46888 LWWHAHC10,LW Recordings,Scott Brown
46889 LWWHAHC10,LW Recordings,Ganar
46890 LWWHAHC10,LW Recordings,NeuroTek,Jonny El,Fastraxx
46891 LWWHAHC10,LW Recordings,Paul EP,Smithy
46892 LWWHAHC10,LW Recordings,Zeku Pointee
46893 LWWHAHC10,LW Recordings,MJ,Subliminal,Stu Infinity
46894 LWWHAHC10,LW Recordings,Dimension
46895 LWWHAHC10,LW Recordings,A.B,Sarah
46896 LWWHAHC10,LW Recordings,Srav3R
46897 LWWHAHC10,LW Recordings,Kurt,Dangerez
46898 LWWHAHC10,LW Recordings,Darren Pearce
46899 Chris Fear, Dougal, Mickey Skeedale, Got To Go, LW Recordings, Chris Fear & Jenny J 2014 Remix, Hardcore, Toolbox Digital Download Got To Go (Chris Fear & Jenny J 2014 Remix) by LW Recordings from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. LWWHAHC10,LW Recordings,Dougal,Mickey Skeedale,Chris Fear
46900 LWWHAHC10,LW Recordings,Kanadhia
46901 LWWHAHC10,LW Recordings,JTS,Haze
46922 Scott Brown, Gazometer, Evolution Records, Original Mix, Hardcore, Toolbox Digital Download Gazometer (Original Mix) by Evolution Records from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. Ev16,Evolution Records,Scott Brown
46923 Ev16,Evolution Records,Scott Brown
46924 Ev16,Evolution Records,Scott Brown