运动会成绩统计系统。运动员的添加,删除,修改,运动队伍的相关查询,个人和集体成绩,金牌总数的查询。功能很全面,界面也很简洁。推荐给大家!-Games results statistical system. Athletes add, delete, modify, sporting teams related inquiries, individual and collective achievements, the total number of gold medals inquiries. Function very comprehensive, very simple interface. Recommend it to everyone!
SHOW FULL COLUMNS FROM `jrk_downrecords` [ RunTime:0.001119s ]
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.097636s ]
SHOW FULL COLUMNS FROM `jrk_tagrecords` [ RunTime:0.001231s ]
SELECT * FROM `jrk_tagrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 20 [ RunTime:0.001678s ]
SHOW FULL COLUMNS FROM `jrk_member` [ RunTime:0.001148s ]
SELECT `id`,`username`,`userhead`,`usertime` FROM `jrk_member` WHERE `status` = 1 ORDER BY `usertime` DESC LIMIT 10 [ RunTime:0.003484s ]
SHOW FULL COLUMNS FROM `jrk_searchrecords` [ RunTime:0.001100s ]
SELECT * FROM `jrk_searchrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 5 [ RunTime:0.004761s ]
SELECT aid,title,count(aid) as c FROM `jrk_downrecords` GROUP BY `aid` ORDER BY `c` DESC LIMIT 10 [ RunTime:0.017400s ]
SHOW FULL COLUMNS FROM `jrk_articles` [ RunTime:0.001256s ]
UPDATE `jrk_articles` SET `hits` = 3 WHERE `id` = 153467 [ RunTime:0.012162s ]