very delicious use of time, combined with the overpowering need to do something to make it better. the collaboration of efforts put into this work will make it....interesting.
SHOW FULL COLUMNS FROM `jrk_downrecords` [ RunTime:0.000982s ]
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.076794s ]
SHOW FULL COLUMNS FROM `jrk_tagrecords` [ RunTime:0.000881s ]
SELECT * FROM `jrk_tagrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 20 [ RunTime:0.001173s ]
SHOW FULL COLUMNS FROM `jrk_member` [ RunTime:0.000957s ]
SELECT `id`,`username`,`userhead`,`usertime` FROM `jrk_member` WHERE `status` = 1 ORDER BY `usertime` DESC LIMIT 10 [ RunTime:0.003186s ]
SHOW FULL COLUMNS FROM `jrk_searchrecords` [ RunTime:0.000841s ]
SELECT * FROM `jrk_searchrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 5 [ RunTime:0.003662s ]
SELECT aid,title,count(aid) as c FROM `jrk_downrecords` GROUP BY `aid` ORDER BY `c` DESC LIMIT 10 [ RunTime:0.014386s ]
SHOW FULL COLUMNS FROM `jrk_articles` [ RunTime:0.001044s ]
UPDATE `jrk_articles` SET `hits` = 2 WHERE `id` = 255992 [ RunTime:0.028403s ]