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 |
37.52 |
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 |
|