https://blog.youkuaiyun.com/thqtzqzh-cnhttps://blog.youkuaiyun.com/https://blog.youkuaiyun.com/thqtzq/article/details/162429672https://blog.youkuaiyun.com/thqtzq/article/details/162429672thqtzqMon, 29 Jun 2026 20:47:55 +0800https://blog.youkuaiyun.com/thqtzq/article/details/162175161https://blog.youkuaiyun.com/thqtzq/article/details/162175161thqtzqSun, 21 Jun 2026 17:34:25 +0800https://blog.youkuaiyun.com/thqtzq/article/details/162173871https://blog.youkuaiyun.com/thqtzq/article/details/162173871thqtzqSun, 21 Jun 2026 15:38:22 +0800https://blog.youkuaiyun.com/thqtzq/article/details/161663458https://blog.youkuaiyun.com/thqtzq/article/details/161663458thqtzqWed, 03 Jun 2026 19:47:56 +0800https://blog.youkuaiyun.com/thqtzq/article/details/161631596https://blog.youkuaiyun.com/thqtzq/article/details/161631596thqtzqTue, 02 Jun 2026 18:58:55 +0800https://blog.youkuaiyun.com/thqtzq/article/details/161601469https://blog.youkuaiyun.com/thqtzq/article/details/161601469thqtzqMon, 01 Jun 2026 21:28:13 +0800https://blog.youkuaiyun.com/thqtzq/article/details/161573188https://blog.youkuaiyun.com/thqtzq/article/details/161573188thqtzqSun, 31 May 2026 23:08:53 +0800https://blog.youkuaiyun.com/thqtzq/article/details/161572880https://blog.youkuaiyun.com/thqtzq/article/details/161572880thqtzqSun, 31 May 2026 22:41:33 +0800https://blog.youkuaiyun.com/thqtzq/article/details/161572627https://blog.youkuaiyun.com/thqtzq/article/details/161572627thqtzqSun, 31 May 2026 22:22:15 +0800https://blog.youkuaiyun.com/thqtzq/article/details/161572505https://blog.youkuaiyun.com/thqtzq/article/details/161572505thqtzqSun, 31 May 2026 22:11:18 +0800https://blog.youkuaiyun.com/thqtzq/article/details/161572271https://blog.youkuaiyun.com/thqtzq/article/details/161572271thqtzqSun, 31 May 2026 21:54:54 +0800 → 后面乱序 → 索引失效范围字段本身可以使用索引，但范围字段之后的所有字段，索引全部中断；中断和后面是in无关，只要前面出现范围，后面字段都无法走索引检索（仅能靠索引下推做数据过滤）。]]>https://blog.youkuaiyun.com/thqtzq/article/details/161572093https://blog.youkuaiyun.com/thqtzq/article/details/161572093thqtzqSun, 31 May 2026 21:36:37 +08002 and c=3 （使用c索引）where a > 1 and b=2 and c=3 （使用c索引）where a > 1 and b=2 and c>3 （不使用索引）where a=1 and b=2 and c=3 （使用联合索引）where b = 1 and a = 2 （使用联合索引）where c = 1 order by b （使用c索引）]]>https://blog.youkuaiyun.com/thqtzq/article/details/161571391https://blog.youkuaiyun.com/thqtzq/article/details/161571391thqtzqSun, 31 May 2026 20:30:57 +0800https://blog.youkuaiyun.com/thqtzq/article/details/161571358https://blog.youkuaiyun.com/thqtzq/article/details/161571358thqtzqSun, 31 May 2026 20:27:33 +0800https://blog.youkuaiyun.com/thqtzq/article/details/161549215https://blog.youkuaiyun.com/thqtzq/article/details/161549215thqtzqSat, 30 May 2026 23:45:06 +0800https://blog.youkuaiyun.com/thqtzq/article/details/161549198https://blog.youkuaiyun.com/thqtzq/article/details/161549198thqtzqSat, 30 May 2026 23:43:17 +0800https://blog.youkuaiyun.com/thqtzq/article/details/161549175https://blog.youkuaiyun.com/thqtzq/article/details/161549175thqtzqSat, 30 May 2026 23:40:07 +0800https://blog.youkuaiyun.com/thqtzq/article/details/161548820https://blog.youkuaiyun.com/thqtzq/article/details/161548820thqtzqSat, 30 May 2026 22:53:05 +0800https://blog.youkuaiyun.com/thqtzq/article/details/161548776https://blog.youkuaiyun.com/thqtzq/article/details/161548776thqtzqSat, 30 May 2026 22:47:13 +0800https://blog.youkuaiyun.com/thqtzq/article/details/161522317https://blog.youkuaiyun.com/thqtzq/article/details/161522317thqtzqFri, 29 May 2026 18:41:49 +0800