lujinke 发表于 2014-6-23 10:49
explain一下,看看,两次的执行计划有什么不同,而且最好把MySQL版本,表结构列一下
执行计划是一样的,但是我怀疑真正执行时,并没有按照执行计划执行。耗时长的应该进行了全表扫描。
mysql> EXPLAIN SELECT * FROM w_bet WHERE
-> is_group_item='F'
-> AND start_time>='2014-06-16 00:00:00'
-> AND start_time<='2014-06-16 23:59:59' AND BET_MONEY>=1000
-> AND is_cash='T'
-> AND vip=9 AND is_group='F'
-> AND type_code='Soccer.Predict'
-> ORDER BY bet_time DESC LIMIT 0,66;
+----+-------------+-------+-------+------------------------------------+------+---------+------+------+-------------+
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
+----+-------------+-------+-------+------------------------------------+------+---------+------+------+-------------+
| 1 | SIMPLE | w_bet | index | START_TIME,s_b,IS_GROUP,IS_GROUP_2 | bs | 9 | NULL | 2607 | Using where |
+----+-------------+-------+-------+------------------------------------+------+---------+------