Introduction
Oversight is a Jukebox that runs on the NMT platform.
It is aimed at users that
regularly download content to their internal hard drive, and
want to quickly identify and access the most recently downloaded material.
want to rename and organise new material automatically.
dont want to spend time "managing" their collection.
For more info see The Wiki
SHOW FULL COLUMNS FROM `jrk_downrecords` [ RunTime:0.001090s ]
SELECT `a`.`aid`,`a`.`title`,`a`.`create_time`,`m`.`username` FROM `jrk_downrecords` `a` INNER JOIN `jrk_member` `m` ON `a`.`uid`=`m`.`id` WHERE `a`.`status` = 1 GROUP BY `a`.`aid` ORDER BY `a`.`create_time` DESC LIMIT 10 [ RunTime:0.073701s ]
SHOW FULL COLUMNS FROM `jrk_tagrecords` [ RunTime:0.001107s ]
SELECT * FROM `jrk_tagrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 20 [ RunTime:0.001195s ]
SHOW FULL COLUMNS FROM `jrk_member` [ RunTime:0.000975s ]
SELECT `id`,`username`,`userhead`,`usertime` FROM `jrk_member` WHERE `status` = 1 ORDER BY `usertime` DESC LIMIT 10 [ RunTime:0.003661s ]
SHOW FULL COLUMNS FROM `jrk_searchrecords` [ RunTime:0.001163s ]
SELECT * FROM `jrk_searchrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 5 [ RunTime:0.006028s ]
SELECT aid,title,count(aid) as c FROM `jrk_downrecords` GROUP BY `aid` ORDER BY `c` DESC LIMIT 10 [ RunTime:0.018662s ]
SHOW FULL COLUMNS FROM `jrk_articles` [ RunTime:0.001286s ]
UPDATE `jrk_articles` SET `hits` = 2 WHERE `id` = 256237 [ RunTime:0.010837s ]
