后台定时抓需要的链接存入数据库,用于各种网络信息的定时抓取。-background regularly grasping the need to link into databases, for a variety of network information regularly crawls.
文 件 列 表
网络蜘蛛代码 java参考 中文搜索引擎技术揭密:网络蜘蛛 --IT写作社区--_files 先声博客-靳松波 博客 In my mind,there is a Dream______files 先声博客-靳松波 博客 In my mind,there is a Dream_____.htm 中文搜索引擎技术揭密:网络蜘蛛 --IT写作社区--.htm 新建 文本文档.txt
SHOW FULL COLUMNS FROM `jrk_downrecords` [ RunTime:0.002406s ]
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.087592s ]
SHOW FULL COLUMNS FROM `jrk_tagrecords` [ RunTime:0.002742s ]
SELECT * FROM `jrk_tagrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 20 [ RunTime:0.002003s ]
SHOW FULL COLUMNS FROM `jrk_member` [ RunTime:0.002309s ]
SELECT `id`,`username`,`userhead`,`usertime` FROM `jrk_member` WHERE `status` = 1 ORDER BY `usertime` DESC LIMIT 10 [ RunTime:0.003637s ]
SHOW FULL COLUMNS FROM `jrk_searchrecords` [ RunTime:0.001996s ]
SELECT * FROM `jrk_searchrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 5 [ RunTime:0.003328s ]
SELECT aid,title,count(aid) as c FROM `jrk_downrecords` GROUP BY `aid` ORDER BY `c` DESC LIMIT 10 [ RunTime:0.014466s ]
SHOW FULL COLUMNS FROM `jrk_articles` [ RunTime:0.002364s ]
UPDATE `jrk_articles` SET `hits` = 1 WHERE `id` = 75864 [ RunTime:0.001331s ]