The CU Data Visualisation Suite was initially created by four 4th year students and Cardiff University in Great Britain as part of their Masters degrees in Engineering. It has now been open sourced to attempt to continue its development.
SHOW FULL COLUMNS FROM `jrk_downrecords` [ RunTime:0.002134s ]
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.092354s ]
SHOW FULL COLUMNS FROM `jrk_tagrecords` [ RunTime:0.001999s ]
SELECT * FROM `jrk_tagrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 20 [ RunTime:0.002031s ]
SHOW FULL COLUMNS FROM `jrk_member` [ RunTime:0.006747s ]
SELECT `id`,`username`,`userhead`,`usertime` FROM `jrk_member` WHERE `status` = 1 ORDER BY `usertime` DESC LIMIT 10 [ RunTime:0.003751s ]
SHOW FULL COLUMNS FROM `jrk_searchrecords` [ RunTime:0.002110s ]
SELECT * FROM `jrk_searchrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 5 [ RunTime:0.003477s ]
SELECT aid,title,count(aid) as c FROM `jrk_downrecords` GROUP BY `aid` ORDER BY `c` DESC LIMIT 10 [ RunTime:0.016636s ]
SHOW FULL COLUMNS FROM `jrk_articles` [ RunTime:0.002587s ]
UPDATE `jrk_articles` SET `hits` = 1 WHERE `id` = 262844 [ RunTime:0.001354s ]
