程序结构参考
在你的程序中应该由这样的几个部分
各个子函数定义部分(如果这部分已经在头函数中可以不写）-Program structure reference in your procedure should be such as the definition of several parts of the various parts of Function (If this is already in the first function can not write)
SHOW FULL COLUMNS FROM `jrk_downrecords` [ RunTime:0.002564s ]
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.131796s ]
SHOW FULL COLUMNS FROM `jrk_tagrecords` [ RunTime:0.002674s ]
SELECT * FROM `jrk_tagrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 20 [ RunTime:0.002204s ]
SHOW FULL COLUMNS FROM `jrk_member` [ RunTime:0.002343s ]
SELECT `id`,`username`,`userhead`,`usertime` FROM `jrk_member` WHERE `status` = 1 ORDER BY `usertime` DESC LIMIT 10 [ RunTime:0.003879s ]
SHOW FULL COLUMNS FROM `jrk_searchrecords` [ RunTime:0.002124s ]
SELECT * FROM `jrk_searchrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 5 [ RunTime:0.003672s ]
SELECT aid,title,count(aid) as c FROM `jrk_downrecords` GROUP BY `aid` ORDER BY `c` DESC LIMIT 10 [ RunTime:0.015731s ]
SHOW FULL COLUMNS FROM `jrk_articles` [ RunTime:0.002810s ]
UPDATE `jrk_articles` SET `hits` = 1 WHERE `id` = 218453 [ RunTime:0.001391s ]
