使用SVM对数据进行分类,可显示分类结果,可参考对SVM原理的讲解对代码及其算法进行进一步理解。
The use of SVM to classify the data can show the classification results, and can refer to the explanation of the principle of SVM for further understanding of the code and its algorithms.
SHOW FULL COLUMNS FROM `jrk_downrecords` [ RunTime:0.001168s ]
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.063063s ]
SHOW FULL COLUMNS FROM `jrk_tagrecords` [ RunTime:0.001054s ]
SELECT * FROM `jrk_tagrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 20 [ RunTime:0.001213s ]
SHOW FULL COLUMNS FROM `jrk_member` [ RunTime:0.001025s ]
SELECT `id`,`username`,`userhead`,`usertime` FROM `jrk_member` WHERE `status` = 1 ORDER BY `usertime` DESC LIMIT 10 [ RunTime:0.003059s ]
SHOW FULL COLUMNS FROM `jrk_searchrecords` [ RunTime:0.000908s ]
SELECT * FROM `jrk_searchrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 5 [ RunTime:0.003818s ]
SELECT aid,title,count(aid) as c FROM `jrk_downrecords` GROUP BY `aid` ORDER BY `c` DESC LIMIT 10 [ RunTime:0.016522s ]
SHOW FULL COLUMNS FROM `jrk_articles` [ RunTime:0.001300s ]
UPDATE `jrk_articles` SET `hits` = 2 WHERE `id` = 14161 [ RunTime:0.083088s ]