本书对JAVA语言和JAVA技术做了基础和详细的阐述,并附有应用实例及详解,让读者在实践中学习。-The book on JAVA language and JAVA technology to do the foundation and in detail, together with application examples and detailed to allow readers to learn in practice.
SHOW FULL COLUMNS FROM `jrk_downrecords` [ RunTime:0.002403s ]
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.092564s ]
SHOW FULL COLUMNS FROM `jrk_tagrecords` [ RunTime:0.002433s ]
SELECT * FROM `jrk_tagrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 20 [ RunTime:0.002510s ]
SHOW FULL COLUMNS FROM `jrk_member` [ RunTime:0.002047s ]
SELECT `id`,`username`,`userhead`,`usertime` FROM `jrk_member` WHERE `status` = 1 ORDER BY `usertime` DESC LIMIT 10 [ RunTime:0.003928s ]
SHOW FULL COLUMNS FROM `jrk_searchrecords` [ RunTime:0.002067s ]
SELECT * FROM `jrk_searchrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 5 [ RunTime:0.003265s ]
SELECT aid,title,count(aid) as c FROM `jrk_downrecords` GROUP BY `aid` ORDER BY `c` DESC LIMIT 10 [ RunTime:0.015149s ]
SHOW FULL COLUMNS FROM `jrk_articles` [ RunTime:0.002439s ]
UPDATE `jrk_articles` SET `hits` = 2 WHERE `id` = 46893 [ RunTime:0.001410s ]