| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | PRIMARY | <derived2> | ALL | 3 | 100 | Using temporary | |||||
| 2 | DERIVED | a0_ | ALL | 3 | 100 | Using temporary; Using filesort |
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | PRIMARY | <derived2> | ALL | 3 | 100 | Using temporary | |||||
| 2 | DERIVED | a0_ | ALL | 3 | 100 | Using temporary; Using filesort |