1 |
PRIMARY |
cat |
|
index |
PRIMARY |
name |
194 |
|
1 |
100.00 |
Using index; Using temporary; Using filesort |
1 |
PRIMARY |
cat |
|
index |
PRIMARY |
name |
194 |
|
1 |
100.00 |
Using index; Using join buffer (hash join) |
1 |
PRIMARY |
sch |
|
eq_ref |
PRIMARY, catalog_id |
catalog_id |
202 |
mysql.cat.id, const |
1 |
100.00 |
Using index |
1 |
PRIMARY |
sch |
|
eq_ref |
PRIMARY, catalog_id |
catalog_id |
202 |
mysql.cat.id, const |
1 |
100.00 |
Using index |
1 |
PRIMARY |
tbl |
|
eq_ref |
schema_id |
schema_id |
202 |
mysql.sch.id, const |
1 |
100.00 |
Rematerialize (<derived3>) |
1 |
PRIMARY |
fk |
|
ALL |
schema_id, table_id |
|
|
|
51 |
100.00 |
Using where |
1 |
PRIMARY |
tbl |
|
eq_ref |
PRIMARY |
PRIMARY |
8 |
mysql.fk.table_id |
1 |
10.00 |
Using where |
1 |
PRIMARY |
<derived3> |
|
ref |
<auto_key0> |
<auto_key0> |
195 |
func |
2 |
100.00 |
Using where |
1 |
PRIMARY |
col |
|
eq_ref |
PRIMARY |
PRIMARY |
8 |
constraints.column_id |
1 |
100.00 |
Using where |
3 |
DEPENDENT DERIVED |
|
|
|
|
|
|
|
|
|
Impossible WHERE |
4 |
DEPENDENT UNION |
fk |
|
ref |
PRIMARY, table_id |
table_id |
8 |
mysql.tbl.id |
2 |
100.00 |
|
4 |
DEPENDENT UNION |
fkcu |
|
ref |
PRIMARY, foreign_key_id |
PRIMARY |
8 |
mysql.fk.id |
1 |
100.00 |
|