Mine

+----+-------------+------------------+--------+-------------------------+---------+---------+---------------------------------+------+-------------+| id | select_type | table            | type   | possible_keys           | key     | key_len | ref                             | rows | Extra       |+----+-------------+------------------+--------+-------------------------+---------+---------+---------------------------------+------+-------------+|  1 | SIMPLE      | cast_person_role | index  | NULL                    | role_id | 1       | NULL                            |   13 | Using index ||  1 | SIMPLE      | program          | ALL    | NULL                    | NULL    | NULL    | NULL                            |  191 |             ||  1 | SIMPLE      | cast_person      | ALL    | person_id_fk,cast_id_fk | NULL    | NULL    | NULL                            |   10 | Using where ||  1 | SIMPLE      | cast             | eq_ref | PRIMARY                 | PRIMARY | 2       | tvguidedb.program.cast_id       |    1 | Using index ||  1 | SIMPLE      | person           | eq_ref | PRIMARY                 | PRIMARY | 2       | tvguidedb.cast_person.person_id |    1 | Using where |+----+-------------+------------------+--------+-------------------------+---------+---------+---------------------------------+------+-------------+