SELECT * FROM `www.ipplus360.com`.`aiwen_free_district_v2.0.1` WHERE
INET_ATON('222.85.85.85') BETWEEN minip AND maxip LIMIT 1;
查询速度比较快:
SELECT * FROM `www.ipplus360.com`.`aiwen_free_district_v2.0.1` WHERE
minip <= INET_ATON('222.85.85.85') ORDER BY minip DESC LIMIT 1;
mysql数据库查询优化
最新推荐文章于 2023-06-02 18:31:02 发布