mean shift algorithm is explored in this vc project. You can unzipped it,and find the source code,then build and debug it ,you ll get the content result.
SHOW FULL COLUMNS FROM `jrk_downrecords` [ RunTime:0.002100s ]
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.094566s ]
SHOW FULL COLUMNS FROM `jrk_tagrecords` [ RunTime:0.001797s ]
SELECT * FROM `jrk_tagrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 20 [ RunTime:0.001871s ]
SHOW FULL COLUMNS FROM `jrk_member` [ RunTime:0.003558s ]
SELECT `id`,`username`,`userhead`,`usertime` FROM `jrk_member` WHERE `status` = 1 ORDER BY `usertime` DESC LIMIT 10 [ RunTime:0.003693s ]
SHOW FULL COLUMNS FROM `jrk_searchrecords` [ RunTime:0.002109s ]
SELECT * FROM `jrk_searchrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 5 [ RunTime:0.003403s ]
SELECT aid,title,count(aid) as c FROM `jrk_downrecords` GROUP BY `aid` ORDER BY `c` DESC LIMIT 10 [ RunTime:0.015560s ]
SHOW FULL COLUMNS FROM `jrk_articles` [ RunTime:0.002491s ]
UPDATE `jrk_articles` SET `hits` = 1 WHERE `id` = 149365 [ RunTime:0.001283s ]