DBSCAN是一个基于密度的聚类算法。改算法将具有足够高度的区域划分为簇,并可以在带有“噪声”的空间数据库中发现任意形状的聚类。-DBSCAN is a density-based clustering algorithm. Algorithm change will have enough height to the regional cluster. and to be with the "noise" of the spatial database found clusters of arbitrary shape.
SHOW FULL COLUMNS FROM `jrk_downrecords` [ RunTime:0.001031s ]
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.059058s ]
SHOW FULL COLUMNS FROM `jrk_tagrecords` [ RunTime:0.001060s ]
SELECT * FROM `jrk_tagrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 20 [ RunTime:0.001105s ]
SHOW FULL COLUMNS FROM `jrk_member` [ RunTime:0.000991s ]
SELECT `id`,`username`,`userhead`,`usertime` FROM `jrk_member` WHERE `status` = 1 ORDER BY `usertime` DESC LIMIT 10 [ RunTime:0.002903s ]
SHOW FULL COLUMNS FROM `jrk_searchrecords` [ RunTime:0.000805s ]
SELECT * FROM `jrk_searchrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 5 [ RunTime:0.003332s ]
SELECT aid,title,count(aid) as c FROM `jrk_downrecords` GROUP BY `aid` ORDER BY `c` DESC LIMIT 10 [ RunTime:0.014088s ]
SHOW FULL COLUMNS FROM `jrk_articles` [ RunTime:0.001043s ]
UPDATE `jrk_articles` SET `hits` = 2 WHERE `id` = 549989 [ RunTime:0.016683s ]