56,675
社区成员
发帖
与我相关
我的任务
分享
+----+--------------+--------------+-------------+------------------------------
------------+----------------------------------+---------+---------------+------
+-----------------------------------------------------------------------------+
| id | select_type | table | type | possible_keys
| key | key_len | ref | rows
| Extra |
+----+--------------+--------------+-------------+------------------------------
------------+----------------------------------+---------+---------------+------
+-----------------------------------------------------------------------------+
| 1 | PRIMARY | b | index_merge | PRIMARY,auditing_state,flag,f
reeze_state | flag,auditing_state,freeze_state | 5,5,5 | NULL | 548
| Using intersect(flag,auditing_state,freeze_state); Using where; Using index |
| 1 | PRIMARY | a | ref | Idx_purvey_product,auditing_s
tate | Idx_purvey_product | 9 | chemmade.b.id | 30
| Using where |
| 2 | UNION | b | index_merge | PRIMARY,auditing_state,flag,f
reeze_state | flag,auditing_state,freeze_state | 5,5,5 | NULL | 548
| Using intersect(flag,auditing_state,freeze_state); Using where; Using index |
| 2 | UNION | a | ref | user_id
| user_id | 5 | chemmade.b.id | 4
| Using where |
| 3 | UNION | b | index_merge | PRIMARY,auditing_state,flag,f
reeze_state | flag,auditing_state,freeze_state | 5,5,5 | NULL | 548
| Using intersect(flag,auditing_state,freeze_state); Using where; Using index |
| 3 | UNION | a | ref | user_id
| user_id | 9 | chemmade.b.id | 2
| Using where |
| NULL | UNION RESULT | <union1,2,3> | ALL | NULL
| NULL | NULL | NULL | NUL
L | Using filesort
|
+----+--------------+--------------+-------------+------------------------------
------------+----------------------------------+---------+---------------+------
+-----------------------------------------------------------------------------+
7 rows in set (0.06 sec)