Originating as a method to view OpenSim log messages for instances that are set to RunAsService, the code can be configured to view just about any project that uses MicrosoftSql to store logs from Log4Net.
文 件 列 表
Log4NetViewer bin Default.aspx Install.sql Web.config bin WebApplication.dll
SHOW FULL COLUMNS FROM `jrk_downrecords` [ RunTime:0.001107s ]
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.080138s ]
SHOW FULL COLUMNS FROM `jrk_tagrecords` [ RunTime:0.001000s ]
SELECT * FROM `jrk_tagrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 20 [ RunTime:0.001154s ]
SHOW FULL COLUMNS FROM `jrk_member` [ RunTime:0.000997s ]
SELECT `id`,`username`,`userhead`,`usertime` FROM `jrk_member` WHERE `status` = 1 ORDER BY `usertime` DESC LIMIT 10 [ RunTime:0.003287s ]
SHOW FULL COLUMNS FROM `jrk_searchrecords` [ RunTime:0.000911s ]
SELECT * FROM `jrk_searchrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 5 [ RunTime:0.003962s ]
SELECT aid,title,count(aid) as c FROM `jrk_downrecords` GROUP BY `aid` ORDER BY `c` DESC LIMIT 10 [ RunTime:0.016215s ]
SHOW FULL COLUMNS FROM `jrk_articles` [ RunTime:0.001186s ]
UPDATE `jrk_articles` SET `hits` = 2 WHERE `id` = 296402 [ RunTime:0.014647s ]
