虽然本书篇幅不大,只有200多页,不适合初学者,但是在开发过过程中放在桌边作为速查手册还是不错的。-Although the book devoted not only more than 200 pages, is not for beginners. But in the development process than on the table as Check the manual is pretty good.
SHOW FULL COLUMNS FROM `jrk_downrecords` [ RunTime:0.001968s ]
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.087075s ]
SHOW FULL COLUMNS FROM `jrk_tagrecords` [ RunTime:0.002255s ]
SELECT * FROM `jrk_tagrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 20 [ RunTime:0.002067s ]
SHOW FULL COLUMNS FROM `jrk_member` [ RunTime:0.002302s ]
SELECT `id`,`username`,`userhead`,`usertime` FROM `jrk_member` WHERE `status` = 1 ORDER BY `usertime` DESC LIMIT 10 [ RunTime:0.003636s ]
SHOW FULL COLUMNS FROM `jrk_searchrecords` [ RunTime:0.001853s ]
SELECT * FROM `jrk_searchrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 5 [ RunTime:0.003218s ]
SELECT aid,title,count(aid) as c FROM `jrk_downrecords` GROUP BY `aid` ORDER BY `c` DESC LIMIT 10 [ RunTime:0.014704s ]
SHOW FULL COLUMNS FROM `jrk_articles` [ RunTime:0.002171s ]
UPDATE `jrk_articles` SET `hits` = 1 WHERE `id` = 256510 [ RunTime:0.001108s ]