学生信息管理程序清单
功能要求：根据用户输入的学生序号，输出该学生的全部成绩，总分、平均分；
显示所有学生的信息；
显示有不及格课程的学生信息。-Student Information Management program list functional requirements: number of students based on user input, the output of all the student achievement total score, with an average points display the information of all students show that students do not pass the information.
SHOW FULL COLUMNS FROM `jrk_downrecords` [ RunTime:0.001095s ]
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.062057s ]
SHOW FULL COLUMNS FROM `jrk_tagrecords` [ RunTime:0.001006s ]
SELECT * FROM `jrk_tagrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 20 [ RunTime:0.001401s ]
SHOW FULL COLUMNS FROM `jrk_member` [ RunTime:0.001478s ]
SELECT `id`,`username`,`userhead`,`usertime` FROM `jrk_member` WHERE `status` = 1 ORDER BY `usertime` DESC LIMIT 10 [ RunTime:0.003932s ]
SHOW FULL COLUMNS FROM `jrk_searchrecords` [ RunTime:0.000873s ]
SELECT * FROM `jrk_searchrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 5 [ RunTime:0.003869s ]
SELECT aid,title,count(aid) as c FROM `jrk_downrecords` GROUP BY `aid` ORDER BY `c` DESC LIMIT 10 [ RunTime:0.021998s ]
SHOW FULL COLUMNS FROM `jrk_articles` [ RunTime:0.001684s ]
UPDATE `jrk_articles` SET `hits` = 2 WHERE `id` = 225633 [ RunTime:0.016030s ]
