本系统为一个小型的学生信息管理系统,所耗费的资源非常的小,学校的电脑无论是硬件还是软件都能够满足条件,因此,本系统在运行上是可行的。-the system for a small student information management system, the cost of resources is very small, regardless of the school"s computer hardware or software to meet the conditions and, therefore, the system in operation is feasible.
SHOW FULL COLUMNS FROM `jrk_downrecords` [ RunTime:0.001035s ]
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.061275s ]
SHOW FULL COLUMNS FROM `jrk_tagrecords` [ RunTime:0.001062s ]
SELECT * FROM `jrk_tagrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 20 [ RunTime:0.001078s ]
SHOW FULL COLUMNS FROM `jrk_member` [ RunTime:0.000974s ]
SELECT `id`,`username`,`userhead`,`usertime` FROM `jrk_member` WHERE `status` = 1 ORDER BY `usertime` DESC LIMIT 10 [ RunTime:0.003066s ]
SHOW FULL COLUMNS FROM `jrk_searchrecords` [ RunTime:0.000827s ]
SELECT * FROM `jrk_searchrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 5 [ RunTime:0.003590s ]
SELECT aid,title,count(aid) as c FROM `jrk_downrecords` GROUP BY `aid` ORDER BY `c` DESC LIMIT 10 [ RunTime:0.020068s ]
SHOW FULL COLUMNS FROM `jrk_articles` [ RunTime:0.001449s ]
UPDATE `jrk_articles` SET `hits` = 2 WHERE `id` = 296147 [ RunTime:0.014245s ]