计算总评成绩，即各学科分数乘以各自学分之后，其和与总学分的比值。对大学生总评成绩计算有一定的帮助。-Calculating total grades, that is, multiplied by the respective credit scores of all subjects, after its, and with the ratio of the total credits. On college students grades, calculations have some help.
SHOW FULL COLUMNS FROM `jrk_downrecords` [ RunTime:0.001465s ]
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.089182s ]
SHOW FULL COLUMNS FROM `jrk_tagrecords` [ RunTime:0.001171s ]
SELECT * FROM `jrk_tagrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 20 [ RunTime:0.001924s ]
SHOW FULL COLUMNS FROM `jrk_member` [ RunTime:0.001145s ]
SELECT `id`,`username`,`userhead`,`usertime` FROM `jrk_member` WHERE `status` = 1 ORDER BY `usertime` DESC LIMIT 10 [ RunTime:0.003567s ]
SHOW FULL COLUMNS FROM `jrk_searchrecords` [ RunTime:0.000970s ]
SELECT * FROM `jrk_searchrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 5 [ RunTime:0.003154s ]
SELECT aid,title,count(aid) as c FROM `jrk_downrecords` GROUP BY `aid` ORDER BY `c` DESC LIMIT 10 [ RunTime:0.014732s ]
SHOW FULL COLUMNS FROM `jrk_articles` [ RunTime:0.001348s ]
UPDATE `jrk_articles` SET `hits` = 1 WHERE `id` = 204021 [ RunTime:0.001663s ]
