动力环境监控系统,它是一个有十分价值的系统,现拿出来供大家参考,学习。可不能用于他用,后果自负。- The power environment supervisory system, it is has extremely
the value system, presently puts out for everybody reference, the
study. But cannot use in he to use, the consequence is proud.
SHOW FULL COLUMNS FROM `jrk_downrecords` [ RunTime:0.001570s ]
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.151549s ]
SHOW FULL COLUMNS FROM `jrk_tagrecords` [ RunTime:0.010862s ]
SELECT * FROM `jrk_tagrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 20 [ RunTime:0.001128s ]
SHOW FULL COLUMNS FROM `jrk_member` [ RunTime:0.001005s ]
SELECT `id`,`username`,`userhead`,`usertime` FROM `jrk_member` WHERE `status` = 1 ORDER BY `usertime` DESC LIMIT 10 [ RunTime:0.003067s ]
SHOW FULL COLUMNS FROM `jrk_searchrecords` [ RunTime:0.000959s ]
SELECT * FROM `jrk_searchrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 5 [ RunTime:0.003783s ]
SELECT aid,title,count(aid) as c FROM `jrk_downrecords` GROUP BY `aid` ORDER BY `c` DESC LIMIT 10 [ RunTime:0.027561s ]
SHOW FULL COLUMNS FROM `jrk_articles` [ RunTime:0.001174s ]
UPDATE `jrk_articles` SET `hits` = 2 WHERE `id` = 318110 [ RunTime:0.042731s ]