集合了java网络编程的一些小问题,有的时候小问题可以导致大问题,所以有必要总结出来一些小问题,供其他人参考-combination of network programming some minor problems, some minor problems can often lead to big problems, it is necessary summed up some minor problems for other reference
SHOW FULL COLUMNS FROM `jrk_downrecords` [ RunTime:0.000916s ]
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.067791s ]
SHOW FULL COLUMNS FROM `jrk_tagrecords` [ RunTime:0.001182s ]
SELECT * FROM `jrk_tagrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 20 [ RunTime:0.001164s ]
SHOW FULL COLUMNS FROM `jrk_member` [ RunTime:0.000985s ]
SELECT `id`,`username`,`userhead`,`usertime` FROM `jrk_member` WHERE `status` = 1 ORDER BY `usertime` DESC LIMIT 10 [ RunTime:0.004375s ]
SHOW FULL COLUMNS FROM `jrk_searchrecords` [ RunTime:0.001433s ]
SELECT * FROM `jrk_searchrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 5 [ RunTime:0.004174s ]
SELECT aid,title,count(aid) as c FROM `jrk_downrecords` GROUP BY `aid` ORDER BY `c` DESC LIMIT 10 [ RunTime:0.014396s ]
SHOW FULL COLUMNS FROM `jrk_articles` [ RunTime:0.001252s ]
UPDATE `jrk_articles` SET `hits` = 2 WHERE `id` = 43359 [ RunTime:0.011590s ]