学生课绩管理系统
高校开发一学生课绩管理系统,该系统由登陆模块,学生模块,教师模块,管理员模块,四部分组成。其功能文件包有详细说明-Students in class performance management system for college students to develop a class performance management system, which by the landing module, student module, teacher module, the administrator module, composed of four parts. Its functions have detailed description of package
SHOW FULL COLUMNS FROM `jrk_downrecords` [ RunTime:0.001229s ]
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.085706s ]
SHOW FULL COLUMNS FROM `jrk_tagrecords` [ RunTime:0.001149s ]
SELECT * FROM `jrk_tagrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 20 [ RunTime:0.002064s ]
SHOW FULL COLUMNS FROM `jrk_member` [ RunTime:0.001146s ]
SELECT `id`,`username`,`userhead`,`usertime` FROM `jrk_member` WHERE `status` = 1 ORDER BY `usertime` DESC LIMIT 10 [ RunTime:0.003600s ]
SHOW FULL COLUMNS FROM `jrk_searchrecords` [ RunTime:0.001006s ]
SELECT * FROM `jrk_searchrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 5 [ RunTime:0.003207s ]
SELECT aid,title,count(aid) as c FROM `jrk_downrecords` GROUP BY `aid` ORDER BY `c` DESC LIMIT 10 [ RunTime:0.014216s ]
SHOW FULL COLUMNS FROM `jrk_articles` [ RunTime:0.001217s ]
UPDATE `jrk_articles` SET `hits` = 1 WHERE `id` = 110833 [ RunTime:0.001193s ]