在本次课程设计中,应该以实际情况为主,在此基础上实现对实际情况的抽象,并设计和建立数据库,完成应用程序界面的人性化地编写。 -During the course design should be based on the actual situation in the main, on the basis of the realization of the abstract of the actual situation and the design and establishment of databases, application programming interfaces to complete the preparation of humanity.
SHOW FULL COLUMNS FROM `jrk_downrecords` [ RunTime:0.001273s ]
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.117064s ]
SHOW FULL COLUMNS FROM `jrk_tagrecords` [ RunTime:0.001198s ]
SELECT * FROM `jrk_tagrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 20 [ RunTime:0.001991s ]
SHOW FULL COLUMNS FROM `jrk_member` [ RunTime:0.001169s ]
SELECT `id`,`username`,`userhead`,`usertime` FROM `jrk_member` WHERE `status` = 1 ORDER BY `usertime` DESC LIMIT 10 [ RunTime:0.003604s ]
SHOW FULL COLUMNS FROM `jrk_searchrecords` [ RunTime:0.000973s ]
SELECT * FROM `jrk_searchrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 5 [ RunTime:0.003388s ]
SELECT aid,title,count(aid) as c FROM `jrk_downrecords` GROUP BY `aid` ORDER BY `c` DESC LIMIT 10 [ RunTime:0.018882s ]
SHOW FULL COLUMNS FROM `jrk_articles` [ RunTime:0.001721s ]
UPDATE `jrk_articles` SET `hits` = 1 WHERE `id` = 205405 [ RunTime:0.001417s ]