一个嵌套小程序,但是不要小看他的作用了 虽然这个程序很小,对于大多数人来说这个可能早就看过了 可是这个程序的思想很重要的-a small nested procedures, but do not underestimate the role of this procedure although small, the majority of people may have seen this process but the idea is very important
SHOW FULL COLUMNS FROM `jrk_downrecords` [ RunTime:0.002780s ]
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.120200s ]
SHOW FULL COLUMNS FROM `jrk_tagrecords` [ RunTime:0.001941s ]
SELECT * FROM `jrk_tagrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 20 [ RunTime:0.002126s ]
SHOW FULL COLUMNS FROM `jrk_member` [ RunTime:0.002064s ]
SELECT `id`,`username`,`userhead`,`usertime` FROM `jrk_member` WHERE `status` = 1 ORDER BY `usertime` DESC LIMIT 10 [ RunTime:0.003793s ]
SHOW FULL COLUMNS FROM `jrk_searchrecords` [ RunTime:0.002268s ]
SELECT * FROM `jrk_searchrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 5 [ RunTime:0.003545s ]
SELECT aid,title,count(aid) as c FROM `jrk_downrecords` GROUP BY `aid` ORDER BY `c` DESC LIMIT 10 [ RunTime:0.014960s ]
SHOW FULL COLUMNS FROM `jrk_articles` [ RunTime:0.002342s ]
UPDATE `jrk_articles` SET `hits` = 1 WHERE `id` = 290172 [ RunTime:0.001119s ]