天使天空的许愿墙程序,本程序使用ASP开发。不同于网上许愿墙程序,本程序每个许愿帖都整齐按行排列。-Sky Angel Wishing Wall program, this program uses ASP Development. Wishing the wall is different from the online program, this program every Wishing posts are neatly arranged by row.
SHOW FULL COLUMNS FROM `jrk_downrecords` [ RunTime:0.002091s ]
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.086221s ]
SHOW FULL COLUMNS FROM `jrk_tagrecords` [ RunTime:0.001972s ]
SELECT * FROM `jrk_tagrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 20 [ RunTime:0.002209s ]
SHOW FULL COLUMNS FROM `jrk_member` [ RunTime:0.002194s ]
SELECT `id`,`username`,`userhead`,`usertime` FROM `jrk_member` WHERE `status` = 1 ORDER BY `usertime` DESC LIMIT 10 [ RunTime:0.003623s ]
SHOW FULL COLUMNS FROM `jrk_searchrecords` [ RunTime:0.002007s ]
SELECT * FROM `jrk_searchrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 5 [ RunTime:0.003190s ]
SELECT aid,title,count(aid) as c FROM `jrk_downrecords` GROUP BY `aid` ORDER BY `c` DESC LIMIT 10 [ RunTime:0.014753s ]
SHOW FULL COLUMNS FROM `jrk_articles` [ RunTime:0.002426s ]
UPDATE `jrk_articles` SET `hits` = 1 WHERE `id` = 102838 [ RunTime:0.001241s ]