eXtended Stats Addon for EventScripts.
eXtended Stats aims to become the number one statistics and ranks addon for EventScripts.
Please Note that as Ojii is currently in New Zealand on language studies, the developement of this project is significantly slowed down, but not stopped. Developement is still in progress and improvements are made!
SHOW FULL COLUMNS FROM `jrk_downrecords` [ RunTime:0.002079s ]
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.085927s ]
SHOW FULL COLUMNS FROM `jrk_tagrecords` [ RunTime:0.002313s ]
SELECT * FROM `jrk_tagrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 20 [ RunTime:0.002040s ]
SHOW FULL COLUMNS FROM `jrk_member` [ RunTime:0.002050s ]
SELECT `id`,`username`,`userhead`,`usertime` FROM `jrk_member` WHERE `status` = 1 ORDER BY `usertime` DESC LIMIT 10 [ RunTime:0.003586s ]
SHOW FULL COLUMNS FROM `jrk_searchrecords` [ RunTime:0.001973s ]
SELECT * FROM `jrk_searchrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 5 [ RunTime:0.003324s ]
SELECT aid,title,count(aid) as c FROM `jrk_downrecords` GROUP BY `aid` ORDER BY `c` DESC LIMIT 10 [ RunTime:0.014982s ]
SHOW FULL COLUMNS FROM `jrk_articles` [ RunTime:0.002537s ]
UPDATE `jrk_articles` SET `hits` = 1 WHERE `id` = 271115 [ RunTime:0.001156s ]