| table | index usage | rows | additional | |||||
|---|---|---|---|---|---|---|---|---|
| Main Query | ||||||||
| film | no matching indexes |
1,000 / 1,000
100% of loaded rows used
|
full table scan
|
|||||
| Dependent Subquery | ||||||||
| film_category |
film_category_category_id
film_category_film_id film_category_pk |
1,000 / 1,000
100% of loaded rows used
|
index-only
|
|||||
| category |
PRIMARY
|
1,000 / 1,000
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.