一个邻接矩阵表示的图型结构,可帮助了解图的数组表示法,理清很多基本概念。可以用VC直接编译运行。-An adjacency matrix representation of the map structure, can help to understand the array graph representation, clarifying many of the basic concepts. VC can be directly translated to run.
SHOW FULL COLUMNS FROM `jrk_downrecords` [ RunTime:0.002060s ]
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.086137s ]
SHOW FULL COLUMNS FROM `jrk_tagrecords` [ RunTime:0.002279s ]
SELECT * FROM `jrk_tagrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 20 [ RunTime:0.001934s ]
SHOW FULL COLUMNS FROM `jrk_member` [ RunTime:0.002128s ]
SELECT `id`,`username`,`userhead`,`usertime` FROM `jrk_member` WHERE `status` = 1 ORDER BY `usertime` DESC LIMIT 10 [ RunTime:0.003623s ]
SHOW FULL COLUMNS FROM `jrk_searchrecords` [ RunTime:0.002205s ]
SELECT * FROM `jrk_searchrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 5 [ RunTime:0.003199s ]
SELECT aid,title,count(aid) as c FROM `jrk_downrecords` GROUP BY `aid` ORDER BY `c` DESC LIMIT 10 [ RunTime:0.015987s ]
SHOW FULL COLUMNS FROM `jrk_articles` [ RunTime:0.002508s ]
UPDATE `jrk_articles` SET `hits` = 1 WHERE `id` = 280814 [ RunTime:0.001244s ]