56,687
社区成员
发帖
与我相关
我的任务
分享
mysql> select sid,order_no,order_status from oms_order limit 10;
+-----+----------------+--------------+
| sid | order_no | order_status |
+-----+----------------+--------------+
| 20 | 20100319000003 | 0 |
| 21 | 20100319000004 | 0 |
| 63 | 20100319000046 | -1 |
| 69 | 20100320000006 | 0 |
| 76 | 20100323000001 | 0 |
| 77 | 20100323000002 | 0 |
| 78 | 20100323000003 | 0 |
| 79 | 20100323000004 | 8 |
| 86 | 20100324000007 | -1 |
| 93 | 20100324000014 | -1 |
+-----+----------------+--------------+
10 rows in set (0.00 sec)
mysql> select sid,order_status from oms_order limit 10;
+-----+--------------+
| sid | order_status |
+-----+--------------+
| 240 | -1 |
| 261 | -1 |
| 263 | -1 |
| 285 | -1 |
| 286 | -1 |
| 288 | -1 |
| 339 | -1 |
| 383 | -1 |
| 387 | -1 |
| 452 | -1 |
+-----+--------------+
10 rows in set (0.00 sec)
mysql> select sid from oms_order limit 10;
+---------+
| sid |
+---------+
| 1171641 |
| 1171651 |
| 1171661 |
| 1171671 |
| 1171681 |
| 1171691 |
| 1171701 |
| 20 |
| 21 |
| 63 |
+---------+
10 rows in set (0.00 sec)
mysql> explain select sid,order_status from oms_order limit 10;
+----+-------------+-----------+-------+---------------+----------------------+---------+------+---------+-------------+
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
+----+-------------+-----------+-------+---------------+----------------------+---------+------+---------+-------------+
| 1 | SIMPLE | oms_order | index | NULL | IND_order_mem_status | 13 | NULL | 1139498 | Using index |
+----+-------------+-----------+-------+---------------+----------------------+---------+------+---------+-------------+
1 row in set (0.00 sec)
mysql>
mysql>
mysql> explain select sid,order_no,order_status from oms_order limit 10;
+----+-------------+-----------+------+---------------+------+---------+------+---------+-------+
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
+----+-------------+-----------+------+---------------+------+---------+------+---------+-------+
| 1 | SIMPLE | oms_order | ALL | NULL | NULL | NULL | NULL | 1139498 | |
+----+-------------+-----------+------+---------------+------+---------+------+---------+-------+
1 row in set (0.00 sec)
mysql> explain select sid from oms_order limit 10;
+----+-------------+-----------+-------+---------------+--------------------+---------+------+---------+-------------+
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
+----+-------------+-----------+-------+---------------+--------------------+---------+------+---------+-------------+
| 1 | SIMPLE | oms_order | index | NULL | IND_ORDER_DELIVERY | 9 | NULL | 1139498 | Using index |
+----+-------------+-----------+-------+---------------+--------------------+---------+------+---------+-------------+
1 row in set (0.00 sec)