通过客户端IP转向指定的城市页面
数据库含23万条数据，删除了所有国外的IP地址，查询不到的IP都被转到“北京” -Client IP through the city towards the designated page database containing 230,000 data, delete all foreign IP addresses, inquiries have been less than the IP to the
SHOW FULL COLUMNS FROM `jrk_downrecords` [ RunTime:0.001349s ]
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.093002s ]
SHOW FULL COLUMNS FROM `jrk_tagrecords` [ RunTime:0.001246s ]
SELECT * FROM `jrk_tagrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 20 [ RunTime:0.001890s ]
SHOW FULL COLUMNS FROM `jrk_member` [ RunTime:0.001396s ]
SELECT `id`,`username`,`userhead`,`usertime` FROM `jrk_member` WHERE `status` = 1 ORDER BY `usertime` DESC LIMIT 10 [ RunTime:0.003740s ]
SHOW FULL COLUMNS FROM `jrk_searchrecords` [ RunTime:0.001151s ]
SELECT * FROM `jrk_searchrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 5 [ RunTime:0.004478s ]
SELECT aid,title,count(aid) as c FROM `jrk_downrecords` GROUP BY `aid` ORDER BY `c` DESC LIMIT 10 [ RunTime:0.015638s ]
SHOW FULL COLUMNS FROM `jrk_articles` [ RunTime:0.001462s ]
UPDATE `jrk_articles` SET `hits` = 1 WHERE `id` = 315044 [ RunTime:0.001389s ]
