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, collation_id |
schema_id |
202 |
mysql.sch.id, const |
1 |
100.00 |
Using where |
1 |
SIMPLE |
coll |
|
eq_ref |
PRIMARY |
PRIMARY |
8 |
mysql.tbl.collation_id |
1 |
100.00 |
Using index |
1 |
SIMPLE |
idx |
|
ref |
PRIMARY, table_id |
table_id |
8 |
mysql.tbl.id |
1 |
100.00 |
|
1 |
SIMPLE |
icu |
|
ref |
index_id, index_id_2, column_id |
index_id |
8 |
mysql.idx.id |
4 |
100.00 |
Using where |
1 |
SIMPLE |
col |
|
eq_ref |
PRIMARY |
PRIMARY |
8 |
mysql.icu.column_id |
1 |
100.00 |
|
1 |
SIMPLE |
stat |
|
eq_ref |
schema_name |
schema_name |
776 |
const, const, mysql.idx.name, mysql.col.name |
1 |
100.00 |
Using where; Using index |