| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | cat | index | PRIMARY | name | 194 | 1 | 100 | Using index; Using temporary; Using filesort | ||
| 1 | SIMPLE | sch | eq_ref | PRIMARY, catalog_id | catalog_id | 202 | mysql.cat.id, const | 1 | 100 | Using index | |
| 1 | SIMPLE | tbl | ref | schema_id, type, type_2 | schema_id | 8 | mysql.sch.id | 501 | 79.5 | Using where | |
| 1 | SIMPLE | col | eq_ref | PRIMARY | PRIMARY | 8 | mysql.tbl.collation_id | 1 | 100 | Using index | |
| 1 | SIMPLE | ts | eq_ref | PRIMARY | PRIMARY | 8 | mysql.tbl.tablespace_id | 1 | 100 | Using index | |
| 1 | SIMPLE | stat | eq_ref | PRIMARY | PRIMARY | 388 | const, mysql.tbl.name | 1 | 100 | Using index |