using连接数据库，执行SQL命令，使用适配器返回数据集。我们不需要去关心它的conn的资源是否关闭。当我们不用到它时。系统自动帮我们安全关闭-using to connect the database, the implementation of SQL commands, use the adapter to return data sets. We do not need to care about it whether the resources conn closed. When we do not have to it. Automatic safety system shut down to help us
SHOW FULL COLUMNS FROM `jrk_downrecords` [ RunTime:0.002063s ]
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.085811s ]
SHOW FULL COLUMNS FROM `jrk_tagrecords` [ RunTime:0.002337s ]
SELECT * FROM `jrk_tagrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 20 [ RunTime:0.001926s ]
SHOW FULL COLUMNS FROM `jrk_member` [ RunTime:0.002131s ]
SELECT `id`,`username`,`userhead`,`usertime` FROM `jrk_member` WHERE `status` = 1 ORDER BY `usertime` DESC LIMIT 10 [ RunTime:0.003699s ]
SHOW FULL COLUMNS FROM `jrk_searchrecords` [ RunTime:0.002240s ]
SELECT * FROM `jrk_searchrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 5 [ RunTime:0.005068s ]
SELECT aid,title,count(aid) as c FROM `jrk_downrecords` GROUP BY `aid` ORDER BY `c` DESC LIMIT 10 [ RunTime:0.016865s ]
SHOW FULL COLUMNS FROM `jrk_articles` [ RunTime:0.002384s ]
UPDATE `jrk_articles` SET `hits` = 1 WHERE `id` = 141498 [ RunTime:0.001180s ]
