A simple MATLAB code demo for our ISVC10 paper.
Bo Li, Kun Peng, Xianghua Ying, Hongbin Zha, Simultaneous Vanishing Point Detection and Camera Calibration from Single Images, Proc. International Symposium on Visual Computing 2010, Part II, LNCS 6454, pp. 151--160.
SHOW FULL COLUMNS FROM `jrk_downrecords` [ RunTime:0.001790s ]
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.112103s ]
SHOW FULL COLUMNS FROM `jrk_tagrecords` [ RunTime:0.001752s ]
SELECT * FROM `jrk_tagrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 20 [ RunTime:0.001371s ]
SHOW FULL COLUMNS FROM `jrk_member` [ RunTime:0.000982s ]
SELECT `id`,`username`,`userhead`,`usertime` FROM `jrk_member` WHERE `status` = 1 ORDER BY `usertime` DESC LIMIT 10 [ RunTime:0.003136s ]
SHOW FULL COLUMNS FROM `jrk_searchrecords` [ RunTime:0.000995s ]
SELECT * FROM `jrk_searchrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 5 [ RunTime:0.006733s ]
SELECT aid,title,count(aid) as c FROM `jrk_downrecords` GROUP BY `aid` ORDER BY `c` DESC LIMIT 10 [ RunTime:0.022527s ]
SHOW FULL COLUMNS FROM `jrk_articles` [ RunTime:0.001579s ]
UPDATE `jrk_articles` SET `hits` = 2 WHERE `id` = 85992 [ RunTime:0.015168s ]