这本书的名子叫程序员开发宝典,书如其名,有兴趣的朋友,不如下载下来学习学习.-this book called The name of development programmers, the book book lives up to its name, the friends are interested in, it is better to download learn from.
SHOW FULL COLUMNS FROM `jrk_downrecords` [ RunTime:0.001284s ]
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.089967s ]
SHOW FULL COLUMNS FROM `jrk_tagrecords` [ RunTime:0.001290s ]
SELECT * FROM `jrk_tagrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 20 [ RunTime:0.001939s ]
SHOW FULL COLUMNS FROM `jrk_member` [ RunTime:0.001284s ]
SELECT `id`,`username`,`userhead`,`usertime` FROM `jrk_member` WHERE `status` = 1 ORDER BY `usertime` DESC LIMIT 10 [ RunTime:0.003605s ]
SHOW FULL COLUMNS FROM `jrk_searchrecords` [ RunTime:0.001049s ]
SELECT * FROM `jrk_searchrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 5 [ RunTime:0.003255s ]
SELECT aid,title,count(aid) as c FROM `jrk_downrecords` GROUP BY `aid` ORDER BY `c` DESC LIMIT 10 [ RunTime:0.016723s ]
SHOW FULL COLUMNS FROM `jrk_articles` [ RunTime:0.001877s ]
UPDATE `jrk_articles` SET `hits` = 1 WHERE `id` = 301235 [ RunTime:0.001242s ]