| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | category | NULL | ALL |
PRIMARY
|
NULL | NULL | NULL | 16 | 10.00 |
Using where
|
| 1 | SIMPLE | film_category | NULL | ALL | NULL | NULL | NULL | NULL | 1000 | 10.00 |
Using where
Using join buffer (hash join) |
| 1 | SIMPLE | film | NULL | eq_ref |
PRIMARY
|
PRIMARY
|
2
|
sakila.film_category.film_id
|
1 | 100.00 |
Using index
|
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.