本文件中包括论坛系统、会员系统等一些系统开发实例源程序,这些源程序都是用asp.net开发的,各位需要对自己的开发环境进行适当配置,才能运行源码。-This document is included in the Forum system, Members System system development and other examples of source code, which source is developed using asp.net, you need to carry out their own development environment properly configured to run the source code.
SHOW FULL COLUMNS FROM `jrk_downrecords` [ RunTime:0.000968s ]
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.109573s ]
SHOW FULL COLUMNS FROM `jrk_tagrecords` [ RunTime:0.000857s ]
SELECT * FROM `jrk_tagrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 20 [ RunTime:0.001158s ]
SHOW FULL COLUMNS FROM `jrk_member` [ RunTime:0.000957s ]
SELECT `id`,`username`,`userhead`,`usertime` FROM `jrk_member` WHERE `status` = 1 ORDER BY `usertime` DESC LIMIT 10 [ RunTime:0.003170s ]
SHOW FULL COLUMNS FROM `jrk_searchrecords` [ RunTime:0.000833s ]
SELECT * FROM `jrk_searchrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 5 [ RunTime:0.008104s ]
SELECT aid,title,count(aid) as c FROM `jrk_downrecords` GROUP BY `aid` ORDER BY `c` DESC LIMIT 10 [ RunTime:0.016353s ]
SHOW FULL COLUMNS FROM `jrk_articles` [ RunTime:0.001212s ]
UPDATE `jrk_articles` SET `hits` = 2 WHERE `id` = 76104 [ RunTime:0.015836s ]