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