This source file may be used and distributed without restriction provided that this copyright statement is not removed from the file and that any derivative work contains the original copyright notice and the associated disclaimer.
SHOW FULL COLUMNS FROM `jrk_downrecords` [ RunTime:0.002273s ]
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.109036s ]
SHOW FULL COLUMNS FROM `jrk_tagrecords` [ RunTime:0.003780s ]
SELECT * FROM `jrk_tagrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 20 [ RunTime:0.011235s ]
SHOW FULL COLUMNS FROM `jrk_member` [ RunTime:0.016305s ]
SELECT `id`,`username`,`userhead`,`usertime` FROM `jrk_member` WHERE `status` = 1 ORDER BY `usertime` DESC LIMIT 10 [ RunTime:0.007365s ]
SHOW FULL COLUMNS FROM `jrk_searchrecords` [ RunTime:0.000958s ]
SELECT * FROM `jrk_searchrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 5 [ RunTime:0.004090s ]
SELECT aid,title,count(aid) as c FROM `jrk_downrecords` GROUP BY `aid` ORDER BY `c` DESC LIMIT 10 [ RunTime:0.014657s ]
SHOW FULL COLUMNS FROM `jrk_articles` [ RunTime:0.001228s ]
UPDATE `jrk_articles` SET `hits` = 2 WHERE `id` = 452606 [ RunTime:0.019963s ]