Created initially as a script for my own personal use, I decided to share on here in case anyone else might find it useful.
Tasks are often specific to me, but there may be parts that could be modified for other peoples uses.
SHOW FULL COLUMNS FROM `jrk_downrecords` [ RunTime:0.002373s ]
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.132918s ]
SHOW FULL COLUMNS FROM `jrk_tagrecords` [ RunTime:0.002122s ]
SELECT * FROM `jrk_tagrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 20 [ RunTime:0.002129s ]
SHOW FULL COLUMNS FROM `jrk_member` [ RunTime:0.002253s ]
SELECT `id`,`username`,`userhead`,`usertime` FROM `jrk_member` WHERE `status` = 1 ORDER BY `usertime` DESC LIMIT 10 [ RunTime:0.004201s ]
SHOW FULL COLUMNS FROM `jrk_searchrecords` [ RunTime:0.002575s ]
SELECT * FROM `jrk_searchrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 5 [ RunTime:0.003368s ]
SELECT aid,title,count(aid) as c FROM `jrk_downrecords` GROUP BY `aid` ORDER BY `c` DESC LIMIT 10 [ RunTime:0.015638s ]
SHOW FULL COLUMNS FROM `jrk_articles` [ RunTime:0.005359s ]
UPDATE `jrk_articles` SET `hits` = 1 WHERE `id` = 263349 [ RunTime:0.002378s ]
