一个类似于记事本的.net程序,实现了经典的文档视图模式即MVC模式,有很好的扩展性,可以作为学习.net的实例。-similar to the one in the notebook. Net program, realized the classic document view mode that MVC model, good scalability, can be used as learning. net examples.
SHOW FULL COLUMNS FROM `jrk_downrecords` [ RunTime:0.001088s ]
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.064627s ]
SHOW FULL COLUMNS FROM `jrk_tagrecords` [ RunTime:0.001029s ]
SELECT * FROM `jrk_tagrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 20 [ RunTime:0.001230s ]
SHOW FULL COLUMNS FROM `jrk_member` [ RunTime:0.001044s ]
SELECT `id`,`username`,`userhead`,`usertime` FROM `jrk_member` WHERE `status` = 1 ORDER BY `usertime` DESC LIMIT 10 [ RunTime:0.003341s ]
SHOW FULL COLUMNS FROM `jrk_searchrecords` [ RunTime:0.000876s ]
SELECT * FROM `jrk_searchrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 5 [ RunTime:0.003946s ]
SELECT aid,title,count(aid) as c FROM `jrk_downrecords` GROUP BY `aid` ORDER BY `c` DESC LIMIT 10 [ RunTime:0.018516s ]
SHOW FULL COLUMNS FROM `jrk_articles` [ RunTime:0.001230s ]
UPDATE `jrk_articles` SET `hits` = 2 WHERE `id` = 172001 [ RunTime:0.012019s ]