易语言制作的百度歌曲采集器 目前只完成了歌名和专辑的采集 主要采用文本分割的方法实现 我的习作-Yi language song collector of Baidu achieve only the title and album of the collection division of the main text of the methods used to achieve my exercises
SHOW FULL COLUMNS FROM `jrk_downrecords` [ RunTime:0.001325s ]
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.094587s ]
SHOW FULL COLUMNS FROM `jrk_tagrecords` [ RunTime:0.001292s ]
SELECT * FROM `jrk_tagrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 20 [ RunTime:0.001885s ]
SHOW FULL COLUMNS FROM `jrk_member` [ RunTime:0.001252s ]
SELECT `id`,`username`,`userhead`,`usertime` FROM `jrk_member` WHERE `status` = 1 ORDER BY `usertime` DESC LIMIT 10 [ RunTime:0.003671s ]
SHOW FULL COLUMNS FROM `jrk_searchrecords` [ RunTime:0.001114s ]
SELECT * FROM `jrk_searchrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 5 [ RunTime:0.003205s ]
SELECT aid,title,count(aid) as c FROM `jrk_downrecords` GROUP BY `aid` ORDER BY `c` DESC LIMIT 10 [ RunTime:0.014955s ]
SHOW FULL COLUMNS FROM `jrk_articles` [ RunTime:0.001456s ]
UPDATE `jrk_articles` SET `hits` = 1 WHERE `id` = 132992 [ RunTime:0.001280s ]