| table | index usage | rows | additional | |||||
|---|---|---|---|---|---|---|---|---|
| Main Query | ||||||||
|
<subquery2> |
no matching indexes | n/a |
full table scan
|
|||||
| film |
PRIMARY
|
1 / 1,000
0% of loaded rows used
|
full table scan
hash join |
|||||
| Independent Query: Results Stored as <subquery2> | ||||||||
| category |
PRIMARY
|
2 / 16
13% of loaded rows used
|
full table scan
|
|||||
| film_category |
film_category_category_id
film_category_film_id film_category_pk |
124 / 124
100% of loaded rows used
|
nested-loop join
|
|||||
You should use the app on a larger display:
MySQL EXPLAINs include a lot of data that can not be simplified enough for a great experience on small mobile screens.