该程序透过服务器sock5代理访问防火墙外的程序,这里通过运行server程序来模拟远端。不过该实例的运行需要有防火墙支持!--Program which visit program outsides of firewall by sock5 proxy in server.IT emulates remote node by running server program. and firewall is needed when running the instance
SHOW FULL COLUMNS FROM `jrk_downrecords` [ RunTime:0.012015s ]
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.157563s ]
SHOW FULL COLUMNS FROM `jrk_tagrecords` [ RunTime:0.001710s ]
SELECT * FROM `jrk_tagrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 20 [ RunTime:0.002966s ]
SHOW FULL COLUMNS FROM `jrk_member` [ RunTime:0.001660s ]
SELECT `id`,`username`,`userhead`,`usertime` FROM `jrk_member` WHERE `status` = 1 ORDER BY `usertime` DESC LIMIT 10 [ RunTime:0.005744s ]
SHOW FULL COLUMNS FROM `jrk_searchrecords` [ RunTime:0.001182s ]
SELECT * FROM `jrk_searchrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 5 [ RunTime:0.006523s ]
SELECT aid,title,count(aid) as c FROM `jrk_downrecords` GROUP BY `aid` ORDER BY `c` DESC LIMIT 10 [ RunTime:0.036524s ]
SHOW FULL COLUMNS FROM `jrk_articles` [ RunTime:0.001212s ]
UPDATE `jrk_articles` SET `hits` = 2 WHERE `id` = 105670 [ RunTime:0.018822s ]