从文件里读入数据,计算各课成绩的平均分,最高分,最低分,学生的加权平均成绩,并生成分析数据。-Reading from the document into the data to calculate the class average performance, the maximum points, minimum points, the weighted average performance of students, and generate analytical data.
SHOW FULL COLUMNS FROM `jrk_downrecords` [ RunTime:0.003053s ]
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.140742s ]
SHOW FULL COLUMNS FROM `jrk_tagrecords` [ RunTime:0.002928s ]
SELECT * FROM `jrk_tagrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 20 [ RunTime:0.002111s ]
SHOW FULL COLUMNS FROM `jrk_member` [ RunTime:0.002568s ]
SELECT `id`,`username`,`userhead`,`usertime` FROM `jrk_member` WHERE `status` = 1 ORDER BY `usertime` DESC LIMIT 10 [ RunTime:0.005851s ]
SHOW FULL COLUMNS FROM `jrk_searchrecords` [ RunTime:0.003623s ]
SELECT * FROM `jrk_searchrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 5 [ RunTime:0.005177s ]
SELECT aid,title,count(aid) as c FROM `jrk_downrecords` GROUP BY `aid` ORDER BY `c` DESC LIMIT 10 [ RunTime:0.024328s ]
SHOW FULL COLUMNS FROM `jrk_articles` [ RunTime:0.003404s ]
UPDATE `jrk_articles` SET `hits` = 1 WHERE `id` = 198643 [ RunTime:0.001516s ]