Performance issue on `select ...id between a and b` and `select .. id in (a,b)`

[actiontech-bot]

Raised by: helingyun Steps:

1. Prepare data: 2 nodes, 2 tables on each node, 50000000 rows in each table
2. Sysbench 2048-thread queries: select my_name,my_idcard,my_phone from user_info WHERE id between 1 and 100; select my_name,my_idcard,my_phone from user_info WHERE id in (1,555);