1.一个简单的程序可以直接查询自己主机的IP地址和www服务器的IP地址
2.使用输入框填写行列值,输出矩阵表
-1. A simple procedure can direct their inquiries to the host IP address and the www server IP addresses 2. use input box to fill in the ranks of value, the output matrix
SHOW FULL COLUMNS FROM `jrk_downrecords` [ RunTime:0.000985s ]
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.073187s ]
SHOW FULL COLUMNS FROM `jrk_tagrecords` [ RunTime:0.001003s ]
SELECT * FROM `jrk_tagrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 20 [ RunTime:0.001281s ]
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.003148s ]
SHOW FULL COLUMNS FROM `jrk_searchrecords` [ RunTime:0.000962s ]
SELECT * FROM `jrk_searchrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 5 [ RunTime:0.003952s ]
SELECT aid,title,count(aid) as c FROM `jrk_downrecords` GROUP BY `aid` ORDER BY `c` DESC LIMIT 10 [ RunTime:0.015406s ]
SHOW FULL COLUMNS FROM `jrk_articles` [ RunTime:0.001157s ]
UPDATE `jrk_articles` SET `hits` = 2 WHERE `id` = 158472 [ RunTime:0.015889s ]