创建修改通讯录,按照姓名排序并可按照姓名进行查询,可插入删除指定的通讯录!-Modified to create contacts, and in accordance with the order in accordance with the names of query name can be inserted to remove the specified address book!
SHOW FULL COLUMNS FROM `jrk_downrecords` [ RunTime:0.001548s ]
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.110559s ]
SHOW FULL COLUMNS FROM `jrk_tagrecords` [ RunTime:0.001523s ]
SELECT * FROM `jrk_tagrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 20 [ RunTime:0.001869s ]
SHOW FULL COLUMNS FROM `jrk_member` [ RunTime:0.001407s ]
SELECT `id`,`username`,`userhead`,`usertime` FROM `jrk_member` WHERE `status` = 1 ORDER BY `usertime` DESC LIMIT 10 [ RunTime:0.003432s ]
SHOW FULL COLUMNS FROM `jrk_searchrecords` [ RunTime:0.000845s ]
SELECT * FROM `jrk_searchrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 5 [ RunTime:0.003668s ]
SELECT aid,title,count(aid) as c FROM `jrk_downrecords` GROUP BY `aid` ORDER BY `c` DESC LIMIT 10 [ RunTime:0.022098s ]
SHOW FULL COLUMNS FROM `jrk_articles` [ RunTime:0.001698s ]
UPDATE `jrk_articles` SET `hits` = 2 WHERE `id` = 130148 [ RunTime:0.013630s ]