This is a module designed to be used with the inresonance SIS (school information system). This module was born at the the Tokyo IR Dev Camp 2011. The module is an extreme Beta! and should be further customized for your environment.
SHOW FULL COLUMNS FROM `jrk_downrecords` [ RunTime:0.001105s ]
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.086551s ]
SHOW FULL COLUMNS FROM `jrk_tagrecords` [ RunTime:0.027545s ]
SELECT * FROM `jrk_tagrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 20 [ RunTime:0.013980s ]
SHOW FULL COLUMNS FROM `jrk_member` [ RunTime:0.003457s ]
SELECT `id`,`username`,`userhead`,`usertime` FROM `jrk_member` WHERE `status` = 1 ORDER BY `usertime` DESC LIMIT 10 [ RunTime:0.004322s ]
SHOW FULL COLUMNS FROM `jrk_searchrecords` [ RunTime:0.001914s ]
SELECT * FROM `jrk_searchrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 5 [ RunTime:0.005148s ]
SELECT aid,title,count(aid) as c FROM `jrk_downrecords` GROUP BY `aid` ORDER BY `c` DESC LIMIT 10 [ RunTime:0.015724s ]
SHOW FULL COLUMNS FROM `jrk_articles` [ RunTime:0.001273s ]
UPDATE `jrk_articles` SET `hits` = 2 WHERE `id` = 307089 [ RunTime:0.048468s ]