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 (
    48374, 48373, 48372, 48371, 48370, 48369, 
    48368, 48367, 48366, 48365, 48364, 
    48363, 48362, 48361, 48360, 48359, 
    48358, 48357, 48356, 48355, 48354, 
    48353, 48352, 48351, 70736, 70735, 
    70734, 70733, 48051, 48033, 48032, 
    48031, 47866, 48025, 47884, 47883, 
    47851, 47885, 48028, 47854, 47850, 
    47849, 47813, 47723, 90955, 90954, 
    90953, 90952, 90951, 90950, 90949, 
    47810, 48013, 47836, 47815, 47814, 
    47808, 47689, 47818, 47778, 47777, 
    47776, 47775, 47763, 47762, 47761, 
    47760, 47639, 47744, 47743, 47742, 
    47746, 47604, 47603, 47602, 47601, 
    47600, 47599, 47598, 47597
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00105

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
47597 PCR026,Peacock Records,Hyrule War,Maissouille,Loki Lonestar
47598 PCR026,Peacock Records,Hyrule War,Dr. Peacock
47599 PCR026,Peacock Records,Hyrule War,Maotai
47600 PCR026,Peacock Records,Hyrule War,Mechonic
47601 PCR026,Peacock Records,Hyrule War,Marcus Decks
47602 PCR026,Peacock Records,Hyrule War,Ohmboy
47603 PCR026,Peacock Records,Hyrule War,Remzcore
47604 PCR026,Peacock Records,Hyrule War,Maotai
47639 DJ Beats, Little Fella, Hear I Go, Totally Ardcore Records, Original Mix, Hardcore, Toolbox Digital Download Hear I Go (Original Mix) by Totally Ardcore Records from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. TA019,Totally Ardcore Records,Little Fella,DJ Beats
47689 Christina Novelli, Darren Styles, Sun Is Rising, Together We Rise, Original Mix, Hardcore, Toolbox Digital Download Sun Is Rising (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. TWR21,Together We Rise,Darren Styles,Christina Novelli
47723 Nick 235, Sc@r, Everything, Scarred Digital, Original Mix, Hardcore, Toolbox Digital Download Everything (Original Mix) by Scarred Digital from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. SD088,Scarred Digital,Sc@r,Nick 235
47742 MOK166,Mokum Records,Formek
47743 MOK166,Mokum Records,Formek
47744 MOK166,Mokum Records,Formek
47746 DJ Sinyo, Bang Base, Desk Records, Original Mix, Hardcore, Toolbox Digital Download Bang Base (Original Mix) by Desk Records from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. DR055,Desk Records,DJ Sinyo
47760 MRV206,Megarave Records,Dione
47761 MRV206,Megarave Records,Dione
47762 MRV206,Megarave Records,Dione
47763 MRV206,Megarave Records,Dione,RTC
47775 PCR030,Peacock Records,Dr. Peacock,Sefa
47776 PCR030,Peacock Records,Dr. Peacock,Sefa,MC Lenny
47777 PCR030,Peacock Records,Sefa
47778 PCR030,Peacock Records,Sefa
47808 Riko, Skoobi, Destroy The Club, Contagious Records, Original Mix, Hardcore, Toolbox Digital Download Destroy The Club (Original Mix) by Contagious Records from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. CR0108,Contagious Records,Riko,Skoobi
47810 Riko, Team Galactic, Get Ya Ass Up, Contagious Records, Original Mix, Hardcore, Toolbox Digital Download Get Ya Ass Up (Original Mix) by Contagious Records from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. CR0109,Contagious Records,Riko,Team Galactic
47813 Riko, Skoobi, Mind Scanner, Contagious Records, Original Mix, Hardcore, Toolbox Digital Download Mind Scanner (Original Mix) by Contagious Records from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. CR0110,Contagious Records,Riko,Skoobi
47814 RS048,Rebirth Society,Double Drums
47815 RS048,Rebirth Society,Double Drums
47818 Jaxx, Riko, Sledgehammer, Contagious Records, Original Mix, Hardcore, Toolbox Digital Download Sledgehammer (Original Mix) by Contagious Records from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. CR0107,Contagious Records,Riko,Jaxx
47836 EXE064,Executive Records,Jamie Dudlee
47849 swg012,SWG Music,Audio Conflict
47850 swg012,SWG Music,Audio Conflict
47851 Jakka-B, Polaris, Futureworld Records, Original Mix, Hard Dance, Toolbox Digital Download Polaris (Original Mix) by Futureworld Records from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. NFWORLD053,Futureworld Records,Jakka-B
47854 CR0111,Contagious Records,Riko,Skoobi
47866 FFR007,Flight Force Records,Lyon Kise
47883 A.B, Anarchy Breed, There & Back Again, Stamina Records, A.B Remix, Hardcore, Toolbox Digital Download There & Back Again (A.B Remix) by Stamina Records from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. STM029,Stamina Records,Anarchy Breed,A.B
47884 Anarchy Breed, At Night, Stamina Records, Original Mix, Hardcore, Toolbox Digital Download At Night (Original Mix) by Stamina Records from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. STM029,Stamina Records,Anarchy Breed
47885 CR0112,Contagious Records,Riko,Skoobi
48013 Jaw D, Heartbeat Song, Universal Hardcore Digital, Original Mix, Hardcore, Toolbox Digital Download Heartbeat Song (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. UHD092,Universal Hardcore Digital,Jaw D
48025 Haze, Jozzi, Hardtronic, Executive Records, Original Mix, Hardcore, Toolbox Digital Download Hardtronic (Original Mix) by Executive Records from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. EXE065,Executive Records,Haze,Jozzi
48028 DR056,Desk Records,Javi Tracker
48031 MRV205,Megarave Records,F. Noize,System Overload
48032 MRV205,Megarave Records,F. Noize,System Overload
48033 MRV205,Megarave Records,F. Noize,System Overload
48051 Chriss-E, Sash Dee, Dont Stop Feel The Beat, Bassface Recordings, Original Mix, Hardcore, Toolbox Digital Download Dont Stop Feel The Beat (Original Mix) by Bassface Recordings from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. BFR0116,Bassface Recordings,Chriss-E,Sash Dee
48351 TFOHBP3,The Future Of Hardcore,A.B
48352 TFOHBP3,The Future Of Hardcore,Clowny
48353 TFOHBP3,The Future Of Hardcore,Clowny & Reflux
48354 TFOHBP3,The Future Of Hardcore,Alex Bassjunkie,Richie
48355 TFOHBP3,The Future Of Hardcore,Bassline Animals
48356 TFOHBP3,The Future Of Hardcore,Clowny
48357 TFOHBP3,The Future Of Hardcore,Clowny,Mc Offside
48358 TFOHBP3,The Future Of Hardcore,Cruze
48359 TFOHBP3,The Future Of Hardcore,D-Core
48360 TFOHBP3,The Future Of Hardcore,Darbo & Snipes
48361 TFOHBP3,The Future Of Hardcore,Danny Eclipse
48362 TFOHBP3,The Future Of Hardcore,Demize,Smilez
48363 TFOHBP3,The Future Of Hardcore,DJ Wicked
48364 TFOHBP3,The Future Of Hardcore,Doug Horizon
48365 TFOHBP3,The Future Of Hardcore,Doug Horizon,Ant_Ith
48366 TFOHBP3,The Future Of Hardcore,Doug Horizon,Chris Ross
48367 TFOHBP3,The Future Of Hardcore,Eufeion,Konekshon
48368 TFOHBP3,The Future Of Hardcore,Gisbo,Mc Offside
48369 TFOHBP3,The Future Of Hardcore,Gisbo,Lee Johnstone
48370 TFOHBP3,The Future Of Hardcore,Gregor Le Dahl
48371 TFOHBP3,The Future Of Hardcore,Gregor Le Dahl
48372 TFOHBP3,The Future Of Hardcore,Gregor Le Dahl
48373 TFOHBP3,The Future Of Hardcore,Gregor Le Dahl
48374 TFOHBP3,The Future Of Hardcore,Gregor Le Dahl,Mansy,Nathalie
70733 EX012,Exode Records,The Fallen
70734 EX012,Exode Records,The Fallen
70735 EX012,Exode Records,The Fallen
70736 EX012,Exode Records,The Fallen
90949 KCRCD012,KyokudoCore Records,Round Wave Crusher
90950 KCRCD012,KyokudoCore Records,Hawawa
90951 KCRCD012,KyokudoCore Records,DJKurara
90952 KCRCD012,KyokudoCore Records,RYUWAVE
90953 KCRCD012,KyokudoCore Records,FRN-G
90954 KCRCD012,KyokudoCore Records,RYUWAVE
90955 KCRCD012,KyokudoCore Records,Gray Foxx