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 | ||
1 | SIMPLE | sch | eq_ref | PRIMARY, catalog_id | catalog_id | 202 | mysql.cat.id, const | 1 | 100 | ||
1 | SIMPLE | tbl | eq_ref | schema_id, collation_id, type, type_2 | schema_id | 202 | mysql.sch.id, const | 1 | 50.13 | Using where | |
1 | SIMPLE | col | eq_ref | PRIMARY, name | PRIMARY | 8 | mysql.tbl.collation_id | 1 | 100 | Using where | |
1 | SIMPLE | ts | eq_ref | PRIMARY | PRIMARY | 8 | mysql.tbl.tablespace_id | 1 | 100 | ||
1 | SIMPLE | stat | const | PRIMARY | PRIMARY | 388 | const, const | 1 | 100 | ||
1 | SIMPLE | col | eq_ref | name, character_set_id | name | 194 | mysql.col.name | 1 | 100 | ||
1 | SIMPLE | cs | eq_ref | PRIMARY | PRIMARY | 8 | mysql.col.character_set_id | 1 | 100 |