1 |
SIMPLE |
cat |
|
index |
PRIMARY |
name |
194 |
|
1 |
100.00 |
Using index; Using temporary; Using filesort |
1 |
SIMPLE |
sch |
|
eq_ref |
PRIMARY, catalog_id |
catalog_id |
202 |
mysql.cat.id, const |
1 |
100.00 |
Using index |
1 |
SIMPLE |
tbl |
|
eq_ref |
PRIMARY, schema_id |
schema_id |
202 |
mysql.sch.id, const |
1 |
100.00 |
Using where |
1 |
SIMPLE |
col |
|
ref |
table_id, table_id_2, collation_id |
table_id |
8 |
mysql.tbl.id |
15 |
100.00 |
Using where |
1 |
SIMPLE |
coll |
|
eq_ref |
PRIMARY, character_set_id |
PRIMARY |
8 |
mysql.col.collation_id |
1 |
100.00 |
|
1 |
SIMPLE |
cs |
|
eq_ref |
PRIMARY |
PRIMARY |
8 |
mysql.coll.character_set_id |
1 |
100.00 |
|