id1创建索引执行确实是id2谓词条件比较快:mysql> select * from index_test where id1=11111;2097152 rows in set (3.00 sec)mysql> select * from index_test where id2=11111;2097152 rows in set (2.32 sec)id1的profile是这样的:+----------------------+----------+ | Status | Duration | +--------------...