展示一张双重连接的名单的实施的原始代码。节目主循环在主函数,用户被提示选择
选择从菜单为了开始与双链表一起使用。
-Display a list of dual-connectivity of the implementation of the original code. Shows the main cycle in the main function, users are prompted to select from the menu selection in order to start with the dual-use list.
SHOW FULL COLUMNS FROM `jrk_downrecords` [ RunTime:0.001841s ]
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.087361s ]
SHOW FULL COLUMNS FROM `jrk_tagrecords` [ RunTime:0.001855s ]
SELECT * FROM `jrk_tagrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 20 [ RunTime:0.001959s ]
SHOW FULL COLUMNS FROM `jrk_member` [ RunTime:0.002034s ]
SELECT `id`,`username`,`userhead`,`usertime` FROM `jrk_member` WHERE `status` = 1 ORDER BY `usertime` DESC LIMIT 10 [ RunTime:0.003643s ]
SHOW FULL COLUMNS FROM `jrk_searchrecords` [ RunTime:0.001966s ]
SELECT * FROM `jrk_searchrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 5 [ RunTime:0.003301s ]
SELECT aid,title,count(aid) as c FROM `jrk_downrecords` GROUP BY `aid` ORDER BY `c` DESC LIMIT 10 [ RunTime:0.014598s ]
SHOW FULL COLUMNS FROM `jrk_articles` [ RunTime:0.002312s ]
UPDATE `jrk_articles` SET `hits` = 1 WHERE `id` = 132641 [ RunTime:0.001217s ]