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 (
    47488, 47234, 47232, 51280, 47452, 47248, 
    47058, 51278, 47051, 47046, 47045, 
    47044, 47043, 47042, 47041, 47040, 
    47039, 47038, 47037, 47036, 47035, 
    47034, 47235, 47115, 47113, 47112, 
    47111, 47110, 47109, 47108, 47107, 
    47106, 47105, 47104, 47103, 47102, 
    47101, 46931, 46946, 46945, 46944, 
    47214, 47213, 47212, 47211, 47210, 
    47209, 47208, 47207, 47206, 47205, 
    47204, 47203, 47202, 47201, 47200, 
    47199, 47196, 46936, 46876, 46875, 
    46918, 46785, 46746, 46943, 46942, 
    46941, 46940, 46910, 46703, 47010, 
    47009, 47008, 46935, 46929, 46928, 
    46927, 46926, 46688, 46925
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00205

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
46688 DR050,Desk Records,Javi Tracker,Alex
46703 STI061,Stomp-Inc UK,New Core Order Collective,Duwkins
46746 WNH122,White Noize Hardcore,Redmoon,Meron Ryan,Darren G,Bridson
46785 TA018,Totally Ardcore Records,J@m!e
46875 UD009,Ufology Digital,Jason UFO
46876 UD009,Ufology Digital,Jason UFO
46910 Andy Wilson, Give Me Forever, Scarred Digital, Original Mix, Hardcore, Toolbox Digital Download Give Me Forever (Original Mix) by Scarred Digital from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. SD085,Scarred Digital,Andy Wilson
46918 WNH121,White Noize Hardcore,Overdrive,BooBoo
46925 Ev16,Evolution Records,Scott Brown
46926 Ev17,Evolution Records,Sub-Source
46927 Sub-Source, Cyber Source, Evolution Records, Original Mix, Hardcore, Toolbox Digital Download Cyber Source (Original Mix) by Evolution Records from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. Ev17,Evolution Records,Sub-Source
46928 Ev17,Evolution Records,Sub-Source,Scott Brown
46929 Ev17,Evolution Records,Sub-Source,Scott Brown
46931 Doug Horizon, Ultravibes, People's Party, Justice Hardcore, Original Mix, Hardcore, Toolbox Digital Download People's Party (Original Mix) by Justice Hardcore from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. JH160,Justice Hardcore,Doug Horizon,Ultravibes
46935 Hitman, Marzi, World Of Presets, Universal Hardcore Digital, Original Mix, Hardcore, Toolbox Digital Download World Of Presets (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. UHD087,Universal Hardcore Digital,Marzi,Hitman
46936 Hyperforce, Mob, Nobody, Starkiss, Going Under, Justice Hardcore, Mob & Starkiss Remix, Hardcore, Toolbox Digital Download Going Under (Mob & Starkiss Remix) by Justice Hardcore from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. JH159,Justice Hardcore,Nobody,Hyperforce,Mob,Starkiss
46940 Ev18,Evolution Records,Scott Brown
46941 Paul Elstak, Scott Brown, Do What Ya Like!, Evolution Records, Paul Elstak Remix, Hardcore, Toolbox Digital Download Do What Ya Like! (Paul Elstak Remix) by Evolution Records from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. Ev18,Evolution Records,Scott Brown,Paul Elstak
46942 Ev18,Evolution Records,Scott Brown,Ramos,Sunset Regime
46943 Ev18,Evolution Records,Scott Brown,Gordon Tennant
46944 FFR006,Flight Force Records,Deivid Sound
46945 FFR006,Flight Force Records,Gisbo Leon Hayward,Xocoa,Deivid Sound
46946 FFR006,Flight Force Records,Deivid Sound
47008 MRV204,Megarave Records,Chrono
47009 MRV204,Megarave Records,Chrono,Convict,Rawmachine
47010 MRV204,Megarave Records,Chrono,Maloonatic
47034 SPECIAL002,Rebirth Society,Mental Crush
47035 SPECIAL002,Rebirth Society,Mental Crush
47036 JH161,Justice Hardcore,Kman
47037 STMLP006,Stamina Records,Douglas,Dionne,A.B
47038 STMLP006,Stamina Records,A.B,K-Wire
47039 STMLP006,Stamina Records,Douglas
47040 STMLP006,Stamina Records,Kounta Kulture,Zealous
47041 STMLP006,Stamina Records,Douglas
47042 STMLP006,Stamina Records,A.B,Sarah
47043 STMLP006,Stamina Records,Douglas
47044 STMLP006,Stamina Records,A.B
47045 STMLP006,Stamina Records,A.B
47046 STMLP006,Stamina Records,A.B,K-Wire
47051 SD087,Scarred Digital,Instigate
47058 WNH119,White Noize Hardcore,Nu-Vizion
47101 DR051,Desk Records,Pastis,Alfredo,Tracker
47102 DR051,Desk Records,Javi Tracker
47103 DR051,Desk Records,DJ Sinyo
47104 DR051,Desk Records,Dj Chemi
47105 DR051,Desk Records,Javi Tracker
47106 DR051,Desk Records,DJ Sinyo
47107 DR051,Desk Records,Paris Makina Team
47108 DR051,Desk Records,Javi Tracker
47109 DR051,Desk Records,Core-Key
47110 DR051,Desk Records,Javi Tracker
47111 DR051,Desk Records,Javiolo
47112 DR051,Desk Records,Javi Tracker
47113 DR051,Desk Records,Sesi
47115 DR051,Desk Records,DJ Sinyo
47196 Scott Brown, Pump Your Fist, Evolution Records, Original Mix, Hardcore, Toolbox Digital Download Pump Your Fist (Original Mix) by Evolution Records from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. Ev131,Evolution Records,Scott Brown
47199 TFOH97,The Future Of Hardcore,A.B
47200 TFOH97,The Future Of Hardcore,Bassline Animals
47201 TFOH97,The Future Of Hardcore,Clowny
47202 TFOH97,The Future Of Hardcore,Cruze
47203 TFOH97,The Future Of Hardcore,D-Core
47204 TFOH97,The Future Of Hardcore,DJ Wicked
47205 TFOH97,The Future Of Hardcore,Ganah
47206 TFOH97,The Future Of Hardcore,IYF
47207 TFOH97,The Future Of Hardcore,Jakka-B,Infexious
47208 TFOH97,The Future Of Hardcore,Joey Riot,Burnout
47209 TFOH97,The Future Of Hardcore,Kurt,Mike Ahmet
47210 TFOH97,The Future Of Hardcore,Mizel,Wilson
47211 TFOH97,The Future Of Hardcore,Rescue,Gregor Le Dahl
47212 TFOH97,The Future Of Hardcore,S3RL,Mixie Moon,Mc Offside
47213 TFOH97,The Future Of Hardcore,Scoot
47214 TFOH97,The Future Of Hardcore,Technical Difficulties
47232 DMB, Analogic, Universal Hardcore Digital, Original Mix, Hardcore, Toolbox Digital Download Analogic (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. UHD089,Universal Hardcore Digital,DMB
47234 Core-Key, Fire, Desk Records, Original Mix, Hardcore, Toolbox Digital Download Fire (Original Mix) by Desk Records from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. DR052,Desk Records,Core-Key
47235 Hitman, Marzi, Psyhco Ex, Universal Hardcore Digital, Original Mix, Hardcore, Toolbox Digital Download Psyhco Ex (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. UHD088,Universal Hardcore Digital,Marzi,Hitman
47248 Chris Fear, D.T.S.I.T.I.L.U, Core Fever, Original Mix, Hard Dance, Toolbox Digital Download D.T.S.I.T.I.L.U (Original Mix) by Core Fever from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. CF021,Core Fever,Chris Fear
47452 Eufeion, Frozen, Hardcore Rapture Digital, Heart Of Ice) (Original Mix, Hardcore, Toolbox Digital Download Frozen (Heart Of Ice) (Original Mix) by Hardcore Rapture Digital from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. HRD0026,Hardcore Rapture Digital,Eufeion
47488 Kyle WytchWood, Tom Revolution, Don't Stop Move Closer, Hardcore Rapture Digital, Original Mix, Hardcore, Toolbox Digital Download Don't Stop Move Closer (Original Mix) by Hardcore Rapture Digital from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. HRD0027,Hardcore Rapture Digital,Kyle WytchWood,Tom Revolution
51278 JH162,Justice Hardcore,Hyperforce,Nobody,Ciccone
51280 JH163,Justice Hardcore,DJ Kurt,MC Elite