foxreview is a code review tool for tracking the changes of bug, now it can support ClearCase and in the future it will support svn and git.
Foxreview Development
source code is hosted on GitHub(http://github.com/ztianjin/foxreview)
SHOW FULL COLUMNS FROM `jrk_downrecords` [ RunTime:0.001907s ]
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.144278s ]
SHOW FULL COLUMNS FROM `jrk_tagrecords` [ RunTime:0.001261s ]
SELECT * FROM `jrk_tagrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 20 [ RunTime:0.001886s ]
SHOW FULL COLUMNS FROM `jrk_member` [ RunTime:0.001233s ]
SELECT `id`,`username`,`userhead`,`usertime` FROM `jrk_member` WHERE `status` = 1 ORDER BY `usertime` DESC LIMIT 10 [ RunTime:0.003619s ]
SHOW FULL COLUMNS FROM `jrk_searchrecords` [ RunTime:0.001146s ]
SELECT * FROM `jrk_searchrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 5 [ RunTime:0.003234s ]
SELECT aid,title,count(aid) as c FROM `jrk_downrecords` GROUP BY `aid` ORDER BY `c` DESC LIMIT 10 [ RunTime:0.015224s ]
SHOW FULL COLUMNS FROM `jrk_articles` [ RunTime:0.001445s ]
UPDATE `jrk_articles` SET `hits` = 1 WHERE `id` = 302474 [ RunTime:0.001355s ]