https://blog.youkuaiyun.com/llll_llll0xffzh-cnhttps://blog.youkuaiyun.com/https://blog.youkuaiyun.com/llll_llll0xff/article/details/165492333https://blog.youkuaiyun.com/llll_llll0xff/article/details/165492333llll_llll0xffTue, 15 Sep 2026 23:04:27 +0800https://blog.youkuaiyun.com/llll_llll0xff/article/details/165298421https://blog.youkuaiyun.com/llll_llll0xff/article/details/165298421llll_llll0xffMon, 14 Sep 2026 11:28:15 +0800https://blog.youkuaiyun.com/llll_llll0xff/article/details/165298324https://blog.youkuaiyun.com/llll_llll0xff/article/details/165298324llll_llll0xffMon, 14 Sep 2026 11:27:03 +0800https://blog.youkuaiyun.com/llll_llll0xff/article/details/164454763https://blog.youkuaiyun.com/llll_llll0xff/article/details/164454763llll_llll0xffMon, 07 Sep 2026 11:04:11 +0800https://blog.youkuaiyun.com/llll_llll0xff/article/details/164430352https://blog.youkuaiyun.com/llll_llll0xff/article/details/164430352llll_llll0xffSun, 06 Sep 2026 20:20:49 +0800https://blog.youkuaiyun.com/llll_llll0xff/article/details/164430342https://blog.youkuaiyun.com/llll_llll0xff/article/details/164430342llll_llll0xffSun, 06 Sep 2026 20:19:31 +0800NOT IN：在"性别""状态"等低区分度字段上建索引，优化器可能选择不走索引。SELECT *返回过多列，或没有LIMIT的大结果集，尤其大字段多时更慢。需要扫描并丢弃前 100000 条数据，偏移量越大越慢。：关联字段类型不一致、缺少关联条件、子查询嵌套过深、视图套视图等。]]>https://blog.youkuaiyun.com/llll_llll0xff/article/details/163951417https://blog.youkuaiyun.com/llll_llll0xff/article/details/163951417llll_llll0xffFri, 21 Aug 2026 17:29:18 +0800https://blog.youkuaiyun.com/llll_llll0xff/article/details/163951387https://blog.youkuaiyun.com/llll_llll0xff/article/details/163951387llll_llll0xffFri, 21 Aug 2026 17:28:14 +0800https://blog.youkuaiyun.com/llll_llll0xff/article/details/163779436https://blog.youkuaiyun.com/llll_llll0xff/article/details/163779436llll_llll0xffSat, 15 Aug 2026 14:11:40 +0800https://blog.youkuaiyun.com/llll_llll0xff/article/details/163758346https://blog.youkuaiyun.com/llll_llll0xff/article/details/163758346llll_llll0xffFri, 14 Aug 2026 16:32:59 +0800 经纬度：用 geocoding API；IP -> 经纬度：用 ip-api.com用flatMap串联「先定位、再查天气」两步异步操作用UriBuilder拼接 URL，自动处理中文编码。]]>https://blog.youkuaiyun.com/llll_llll0xff/article/details/163745391https://blog.youkuaiyun.com/llll_llll0xff/article/details/163745391llll_llll0xffFri, 14 Aug 2026 11:40:46 +0800https://blog.youkuaiyun.com/llll_llll0xff/article/details/163732880https://blog.youkuaiyun.com/llll_llll0xff/article/details/163732880llll_llll0xffThu, 13 Aug 2026 19:45:08 +0800= 0 的 Servlet，按数值从小到大排序后 依次调用 wrapper.load()。]]>