一个用于分析网页链接并批量获取所有图片的程序,没有时间优化,希望对大家有所借鉴。- Uses in to analyze the homepage link and the batch gain all
pictures procedure, does not have the time to optimize, hoped has the
model to everybody.
SHOW FULL COLUMNS FROM `jrk_downrecords` [ RunTime:0.001302s ]
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.093507s ]
SHOW FULL COLUMNS FROM `jrk_tagrecords` [ RunTime:0.001280s ]
SELECT * FROM `jrk_tagrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 20 [ RunTime:0.001930s ]
SHOW FULL COLUMNS FROM `jrk_member` [ RunTime:0.001283s ]
SELECT `id`,`username`,`userhead`,`usertime` FROM `jrk_member` WHERE `status` = 1 ORDER BY `usertime` DESC LIMIT 10 [ RunTime:0.003675s ]
SHOW FULL COLUMNS FROM `jrk_searchrecords` [ RunTime:0.001078s ]
SELECT * FROM `jrk_searchrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 5 [ RunTime:0.003228s ]
SELECT aid,title,count(aid) as c FROM `jrk_downrecords` GROUP BY `aid` ORDER BY `c` DESC LIMIT 10 [ RunTime:0.015483s ]
SHOW FULL COLUMNS FROM `jrk_articles` [ RunTime:0.001471s ]
UPDATE `jrk_articles` SET `hits` = 1 WHERE `id` = 318025 [ RunTime:0.001313s ]