The collective wisdom of the programming source code Chapter III
《集体智慧编程》由美国计算机专家西格兰编著,以机器学习与计算统计为主题背景,专门讲述如何挖掘和分析Web上的数据和资源,如何分析用户体验、市场营销、个人品味等诸多信息,并得出有用的结论,通过复杂的算法来从Web网站获取、收集并分析用户的数据和反馈信息,以便创造新的用户价值和商业价值。
SHOW FULL COLUMNS FROM `jrk_downrecords` [ RunTime:0.001313s ]
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.088530s ]
SHOW FULL COLUMNS FROM `jrk_tagrecords` [ RunTime:0.001230s ]
SELECT * FROM `jrk_tagrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 20 [ RunTime:0.001963s ]
SHOW FULL COLUMNS FROM `jrk_member` [ RunTime:0.001248s ]
SELECT `id`,`username`,`userhead`,`usertime` FROM `jrk_member` WHERE `status` = 1 ORDER BY `usertime` DESC LIMIT 10 [ RunTime:0.004584s ]
SHOW FULL COLUMNS FROM `jrk_searchrecords` [ RunTime:0.001369s ]
SELECT * FROM `jrk_searchrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 5 [ RunTime:0.003411s ]
SELECT aid,title,count(aid) as c FROM `jrk_downrecords` GROUP BY `aid` ORDER BY `c` DESC LIMIT 10 [ RunTime:0.015068s ]
SHOW FULL COLUMNS FROM `jrk_articles` [ RunTime:0.001348s ]
UPDATE `jrk_articles` SET `hits` = 1 WHERE `id` = 297707 [ RunTime:0.001399s ]