一个很好的网站调查系统互相学习,初来，非得要上传，没有办法，喜欢里面的程序，只能支持。呵呵！-A good site survey systems learn from each other, the early years, have to want to upload, there is no way, like the inside of the procedure, can only support. Ha ha!
SHOW FULL COLUMNS FROM `jrk_downrecords` [ RunTime:0.001222s ]
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.086996s ]
SHOW FULL COLUMNS FROM `jrk_tagrecords` [ RunTime:0.001167s ]
SELECT * FROM `jrk_tagrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 20 [ RunTime:0.001922s ]
SHOW FULL COLUMNS FROM `jrk_member` [ RunTime:0.001167s ]
SELECT `id`,`username`,`userhead`,`usertime` FROM `jrk_member` WHERE `status` = 1 ORDER BY `usertime` DESC LIMIT 10 [ RunTime:0.003606s ]
SHOW FULL COLUMNS FROM `jrk_searchrecords` [ RunTime:0.001400s ]
SELECT * FROM `jrk_searchrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 5 [ RunTime:0.004062s ]
SELECT aid,title,count(aid) as c FROM `jrk_downrecords` GROUP BY `aid` ORDER BY `c` DESC LIMIT 10 [ RunTime:0.014938s ]
SHOW FULL COLUMNS FROM `jrk_articles` [ RunTime:0.001294s ]
UPDATE `jrk_articles` SET `hits` = 1 WHERE `id` = 258194 [ RunTime:0.001452s ]
