这是一个图的拓扑排序的程序,是数据结构的图一章中比较重要的内容,程序已经调试通过,可以供大家参考-This is a map of topological sorting procedure, the map data structure is one more important chapter in the content, procedures have been debug through, you can for your reference
SHOW FULL COLUMNS FROM `jrk_downrecords` [ RunTime:0.001410s ]
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.101675s ]
SHOW FULL COLUMNS FROM `jrk_tagrecords` [ RunTime:0.001322s ]
SELECT * FROM `jrk_tagrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 20 [ RunTime:0.001976s ]
SHOW FULL COLUMNS FROM `jrk_member` [ RunTime:0.001352s ]
SELECT `id`,`username`,`userhead`,`usertime` FROM `jrk_member` WHERE `status` = 1 ORDER BY `usertime` DESC LIMIT 10 [ RunTime:0.003727s ]
SHOW FULL COLUMNS FROM `jrk_searchrecords` [ RunTime:0.001127s ]
SELECT * FROM `jrk_searchrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 5 [ RunTime:0.003293s ]
SELECT aid,title,count(aid) as c FROM `jrk_downrecords` GROUP BY `aid` ORDER BY `c` DESC LIMIT 10 [ RunTime:0.016139s ]
SHOW FULL COLUMNS FROM `jrk_articles` [ RunTime:0.001519s ]
UPDATE `jrk_articles` SET `hits` = 1 WHERE `id` = 188270 [ RunTime:0.001448s ]