Modoer 是一款以本地分享,多功能的点评网站管理系统,采用 MySQL+PHP 开发设计,开放全部源代码。网站模板与程序分离,通过模板设计便可实现个性化网站。-Modoer is a local sharing, multi-functional site Comments Management System MySQL+ PHP development and design, open all the source code. Web site templates and procedures for the separation of the template design can be realized through personalized Web site.
SHOW FULL COLUMNS FROM `jrk_downrecords` [ RunTime:0.001764s ]
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.081634s ]
SHOW FULL COLUMNS FROM `jrk_tagrecords` [ RunTime:0.001029s ]
SELECT * FROM `jrk_tagrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 20 [ RunTime:0.001113s ]
SHOW FULL COLUMNS FROM `jrk_member` [ RunTime:0.000970s ]
SELECT `id`,`username`,`userhead`,`usertime` FROM `jrk_member` WHERE `status` = 1 ORDER BY `usertime` DESC LIMIT 10 [ RunTime:0.003189s ]
SHOW FULL COLUMNS FROM `jrk_searchrecords` [ RunTime:0.000932s ]
SELECT * FROM `jrk_searchrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 5 [ RunTime:0.004092s ]
SELECT aid,title,count(aid) as c FROM `jrk_downrecords` GROUP BY `aid` ORDER BY `c` DESC LIMIT 10 [ RunTime:0.015248s ]
SHOW FULL COLUMNS FROM `jrk_articles` [ RunTime:0.001293s ]
UPDATE `jrk_articles` SET `hits` = 2 WHERE `id` = 35755 [ RunTime:0.016511s ]