通讯录管理系统,能够实现人员的信息录入、查询、修改、删除、保存、显示等操作。要求利用菜单的形式进行管理。-Address book management system, enables personnel information input, query, modify, delete, save, display and other operations. Require the use of the menu in the form of management.
SHOW FULL COLUMNS FROM `jrk_downrecords` [ RunTime:0.000979s ]
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.090135s ]
SHOW FULL COLUMNS FROM `jrk_tagrecords` [ RunTime:0.001095s ]
SELECT * FROM `jrk_tagrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 20 [ RunTime:0.001358s ]
SHOW FULL COLUMNS FROM `jrk_member` [ RunTime:0.001107s ]
SELECT `id`,`username`,`userhead`,`usertime` FROM `jrk_member` WHERE `status` = 1 ORDER BY `usertime` DESC LIMIT 10 [ RunTime:0.003227s ]
SHOW FULL COLUMNS FROM `jrk_searchrecords` [ RunTime:0.000881s ]
SELECT * FROM `jrk_searchrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 5 [ RunTime:0.003914s ]
SELECT aid,title,count(aid) as c FROM `jrk_downrecords` GROUP BY `aid` ORDER BY `c` DESC LIMIT 10 [ RunTime:0.028965s ]
SHOW FULL COLUMNS FROM `jrk_articles` [ RunTime:0.001321s ]
UPDATE `jrk_articles` SET `hits` = 2 WHERE `id` = 237029 [ RunTime:0.149583s ]