对于大学校园内部的各个系部的工作人员的工资和财务处以及人事处之间的交互管理-University campus for the various systems of internal staff of the Department of the Treasury, as well as wages and the interaction between the Personnel Service Management
SHOW FULL COLUMNS FROM `jrk_downrecords` [ RunTime:0.001254s ]
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.093618s ]
SHOW FULL COLUMNS FROM `jrk_tagrecords` [ RunTime:0.001303s ]
SELECT * FROM `jrk_tagrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 20 [ RunTime:0.002009s ]
SHOW FULL COLUMNS FROM `jrk_member` [ RunTime:0.001195s ]
SELECT `id`,`username`,`userhead`,`usertime` FROM `jrk_member` WHERE `status` = 1 ORDER BY `usertime` DESC LIMIT 10 [ RunTime:0.003598s ]
SHOW FULL COLUMNS FROM `jrk_searchrecords` [ RunTime:0.000967s ]
SELECT * FROM `jrk_searchrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 5 [ RunTime:0.003232s ]
SELECT aid,title,count(aid) as c FROM `jrk_downrecords` GROUP BY `aid` ORDER BY `c` DESC LIMIT 10 [ RunTime:0.016783s ]
SHOW FULL COLUMNS FROM `jrk_articles` [ RunTime:0.001410s ]
UPDATE `jrk_articles` SET `hits` = 1 WHERE `id` = 158640 [ RunTime:0.001664s ]