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 (
    52244, 52243, 52242, 52241, 52240, 52239, 
    52238, 52237, 52236, 52268, 52576, 
    52163, 51992, 51991, 51988, 51990, 
    51989, 51933, 51932, 51931, 51930, 
    59344, 52572, 52571, 51899, 51892, 
    51891, 51888, 59349, 52575, 51879, 
    51878, 51877, 51876, 51875, 51874, 
    51873, 51872, 51871, 51870, 51869, 
    51868, 51867, 51866, 51865, 51864, 
    51863, 51862, 51861, 51860, 51859, 
    51858, 51857, 51856, 51855, 111374, 
    111373, 52569, 52568, 52567, 52566, 
    52565, 52564, 52563, 52562, 52561, 
    52560, 52559, 52558, 52557, 52556, 
    52555, 52554, 52553, 52552, 52551, 
    52550, 52549, 51834, 51831
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00088

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
51831 Bass-x, We Are Bass-X, Screwdriver, Original Mix, Hard Dance, Toolbox Digital Download We Are Bass-X (Original Mix) by Screwdriver from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. Screw4,Screwdriver,Bass-X
51834 Scott Brown, I Only Need You, Evolution Records, Original Mix, Featured Hardcore New, Hardcore, Toolbox Digital Download I Only Need You (Original Mix) by Evolution Records from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. Ev154,Evolution Records,Scott Brown
51855 LWWHAHC15,LW Recordings,Scott Brown
51856 LWWHAHC15,LW Recordings,Stu Infinity,Dimension,Subliminal
51857 LWWHAHC15,LW Recordings,Nizzle,Daz Mott
51858 LWWHAHC15,LW Recordings,Ganar
51859 LWWHAHC15,LW Recordings,Doug Horizon
51860 LWWHAHC15,LW Recordings,Marc Smith,Chris Fear
51861 LWWHAHC15,LW Recordings,Technikore
51862 LWWHAHC15,LW Recordings,Instigate,Joey Riot,Dionne
51863 LWWHAHC15,LW Recordings,DJ Konik
51864 LWWHAHC15,LW Recordings,Riko,Powerbounce
51865 LWWHAHC15,LW Recordings,Nizzle,Kerry Lou
51866 LWWHAHC15,LW Recordings,Technikore,JTS,Al Storm,Weaver
51867 LWWHAHC15,LW Recordings,Jekyll,DJ G
51868 LWWHAHC15,LW Recordings,Lady Dubbz,Jay G
51869 LWWHAHC15,LW Recordings,Mr. Tommy
51870 LWWHAHC15,LW Recordings,Hyperforce,IYF,Anima
51871 LWWHAHC15,LW Recordings,Burnout
51872 LWWHAHC15,LW Recordings,Bridson,Dcn,Beckie,Darren G
51873 LWWHAHC15,LW Recordings,Jakka-B
51874 LWWHAHC15,LW Recordings,J@m!e
51875 LWWHAHC15,LW Recordings,Scott Brown
51876 LWWHAHC15,LW Recordings,Riko,Skinny G
51877 LWWHAHC15,LW Recordings,DJ Wyld
51878 LWWHAHC15,LW Recordings,Psychosis
51879 LWWHAHC15,LW Recordings,A.B
51888 Al Storm, Alex Prospect, Dirtbox, 24/7 Hardcore, Alex Prospect Remix, Featured Hardcore New, Hardcore, Toolbox Digital Download Dirtbox (Alex Prospect Remix) by 24/7 Hardcore from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. 247HC107,24/7 Hardcore,Al Storm,Alex Prospect
51891 IYF, Nobody, The Other Side, 24/7 Hardcore, Original Mix, Featured Hardcore New, Hardcore, Toolbox Digital Download The Other Side (Original Mix) by 24/7 Hardcore from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. 247HC108,24/7 Hardcore,IYF,Nobody
51892 DJ Jedi, Inertia, Jedi Recordings, Original Mix, Featured Hardcore New, Old Skool, Hardcore, Toolbox Digital Download Inertia (Original Mix) by Jedi Recordings from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. JEDI12B,Jedi Recordings,DJ Jedi
51899 DR070,Desk Records,Javi Tracker
51930 Scott Brown, Systematic, Screwdriver, Original Mix, Featured Hardcore New, Hardcore, Toolbox Digital Download Systematic (Original Mix) by Screwdriver from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. Screw6,Screwdriver,Scott Brown
51931 Scott Brown, A New Feeling, Screwdriver, Original Mix, Hard Dance, Toolbox Digital Download A New Feeling (Original Mix) by Screwdriver from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. Screw6,Screwdriver,Scott Brown
51932 Scott Brown, Slipstream, Screwdriver, Original Mix, Hard Dance, Toolbox Digital Download Slipstream (Original Mix) by Screwdriver from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. Screw6,Screwdriver,Scott Brown
51933 Scott Brown, Dreams, Screwdriver, Original Mix, Hard Dance, Toolbox Digital Download Dreams (Original Mix) by Screwdriver from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. Screw6,Screwdriver,Scott Brown
51988 Jonny el, Ritual, Hyper Beatz, Original Mix, Featured Hardcore New, Hardcore, Toolbox Digital Download Ritual (Original Mix) by Hyper Beatz from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. HB021,Hyper Beatz,Jonny El
51989 DJ041,DJs at Work,DJ Xilo
51990 DJ041,DJs at Work,VinylDJs
51991 Hotchkiss, Open Your Eyes, Evolution Records, Original Mix, Featured Hardcore New, Hardcore, Toolbox Digital Download Open Your Eyes (Original Mix) by Evolution Records from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. Ev155,Evolution Records,Hotchkiss
51992 Hotchkiss, Back at Them, Evolution Records, Original Mix, Hard Dance, Toolbox Digital Download Back at Them (Original Mix) by Evolution Records from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. Ev155,Evolution Records,Hotchkiss
52163 Al Storm, Bang!, DJ Shimamura, Nikki Mak, Breakin' Thru, 24/7 Hardcore, DJ Shimamura Remix, Featured Hardcore New, Hardcore, Toolbox Digital Download Breakin' Thru (DJ Shimamura Remix) by 24/7 Hardcore from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. 247HC109,24/7 Hardcore,Bang!,Al Storm,Nikki Mak,DJ Shimamura
52236 MWM020001,Makina World Music,PJ Makina
52237 MWM020001,Makina World Music,PJ Makina
52238 MWM020001,Makina World Music,PJ Makina
52239 MWM020001,Makina World Music,PJ Makina
52240 MWM020001,Makina World Music,PJ Makina
52241 MWM020001,Makina World Music,PJ Makina
52242 MWM020001,Makina World Music,PJ Makina
52243 MWM020001,Makina World Music,PJ Makina
52244 MWM020001,Makina World Music,PJ Makina
52268 Bridson, Darren G, On Top, White Noize Hardcore, Original Mix, Featured Hardcore New, Hardcore, Toolbox Digital Download On Top (Original Mix) by White Noize Hardcore from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. WNH130,White Noize Hardcore,Darren G,Bridson
52549 TFOHSB2,The Future Of Hardcore,D-Core
52550 TFOHSB2,The Future Of Hardcore,Cruze & Ripps
52551 TFOHSB2,The Future Of Hardcore,Darbo & Snipes
52552 TFOHSB2,The Future Of Hardcore,DJ Wicked
52553 TFOHSB2,The Future Of Hardcore,Doug Horizon,Ant_Ith
52554 TFOHSB2,The Future Of Hardcore,Fallon,Nora2r
52555 TFOHSB2,The Future Of Hardcore,Fallon
52556 TFOHSB2,The Future Of Hardcore,Gisbo
52557 TFOHSB2,The Future Of Hardcore,Gregor Le Dahl
52558 TFOHSB2,The Future Of Hardcore,Gregor Le Dahl,Nathalie
52559 TFOHSB2,The Future Of Hardcore,Gregor Le Dahl,Mansy,Nathalie
52560 TFOHSB2,The Future Of Hardcore,Gregor Le Dahl,Allison Gray
52561 TFOHSB2,The Future Of Hardcore,IYF
52562 TFOHSB2,The Future Of Hardcore,Just Jack,Kane
52563 TFOHSB2,The Future Of Hardcore,Mickey Rush
52564 TFOHSB2,The Future Of Hardcore,N-Sane
52565 TFOHSB2,The Future Of Hardcore,N-Sane
52566 TFOHSB2,The Future Of Hardcore,Scotty D
52567 TFOHSB2,The Future Of Hardcore,N-Sane,Scotty D,Bridson
52568 TFOHSB2,The Future Of Hardcore,Offside,Technical Difficulties
52569 TFOHSB2,The Future Of Hardcore,Scoot
52571 Klubfiller, Universe, Klubbed Up, Radio Edit, Hard Dance, Toolbox Digital Download Universe (Radio Edit) by Klubbed Up from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. KU052,Klubbed Up,Klubfiller
52572 Klubfiller, Universe, Klubbed Up, Original Mix, Featured Hardcore New, Hardcore, Toolbox Digital Download Universe (Original Mix) by Klubbed Up from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. KU052,Klubbed Up,Klubfiller
52575 ABJ, Richie, Mind Machine, The Future Of Hardcore, Original Mix, Featured Hardcore New, Hardcore, Toolbox Digital Download Mind Machine (Original Mix) by The Future Of Hardcore from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. TFOH102,The Future Of Hardcore,ABJ,Richie
52576 Bridson, Laurence CC, Number 1, Rave Essentials, Original Mix, Featured Hardcore New, Hardcore, Toolbox Digital Download Number 1 (Original Mix) by Rave Essentials from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. Ravenew3,Rave Essentials,Laurence CC,Bridson
59344 JH178,Justice Hardcore,IYF,Riffresh FT. Blue Eyes
59349 JH177,Justice Hardcore,IYF,Nobody,Steve Heller FT. Jay Faires
111373 LTR049,Lethal Theory,MOB,Callum Higby
111374 LTR049,Lethal Theory,MOB,Callum Higby