query of doom

mysql> DESCRIBE SELECT pp.uri, prn.nid, prn.tag, prn.version, c.directory, c.rid FROM project_release_nodes prn INNER JOIN node nr ON prn.nid = nr.nid INNER JOIN project_projects pp ON prn.pid = pp.nid INNER JOIN node np ON prn.pid = np.nid INNER JOIN project_release_projects prp ON prp.nid = prn.pid INNER JOIN cvs_projects c ON prn.pid = c.nid WHERE np.status = 1 AND prp.releases = 1 AND (prn.rebuild = 1) AND ((prn.file_path = '') OR (nr.status = 1)) ORDER BY pp.uri;
+-------+--------+---------------------------------------------+-----------------------------------+---------+---------+------+-----------------------------------------------------------+
| table | type   | possible_keys                               | key                               | key_len | ref     | rows | Extra                                                     |
+-------+--------+---------------------------------------------+-----------------------------------+---------+---------+------+-----------------------------------------------------------+
| prp   | ref    | PRIMARY,project_release_projects_releases   | project_release_projects_releases |       1 | const   | 1095 | Using where; Using index; Using temporary; Using filesort |
| prn   | ref    | PRIMARY,project_releases_pid                | project_releases_pid              |       4 | prp.nid |    1 | Using where                                               |
| pp    | eq_ref | PRIMARY                                     | PRIMARY                           |       4 | prn.pid |    1 |                                                           |
| np    | ref    | PRIMARY,node_status_type,nid,tracker_global | PRIMARY                           |       4 | prn.pid |    1 | Using where                                               |
| nr    | ref    | PRIMARY,node_status_type,nid,tracker_global | PRIMARY                           |       4 | prn.nid |    1 | Using where                                               |
| c     | eq_ref | PRIMARY                                     | PRIMARY                           |       4 | prn.pid |    1 |                                                           |
+-------+--------+---------------------------------------------+-----------------------------------+---------+---------+------+-----------------------------------------------------------+
6 rows in set (0.00 sec)