Site Is So Slow!

[eluser]Jay Logan[/eluser]
So this is the query I ran. The ID's would change based on the user and meet. I chose one of my bigger meets.

Code:

SELECT Meet_Event.*, Event.*, COUNT(Meet_Athlete.id) AS Total, COUNT(Coach.id) AS Coach FROM meet_events AS Meet_Event LEFT JOIN events AS Event ON Meet_Event.event_id = Event.id LEFT JOIN meet_athletes AS Meet_Athlete ON Meet_Event.id = Meet_Athlete.meet_event_id LEFT JOIN athletes AS Athlete ON Meet_Athlete.athlete_id = Athlete.id LEFT JOIN roster AS Roster ON Roster.athlete_id = Athlete.id Left Join coaches AS Coach ON Roster.coach_id = Coach.id AND Coach.id = 1000000 WHERE Meet_Event.meet_id = 815398826 GROUP BY Meet_Event.id ORDER BY Event.type DESC, Event.name ASC, Meet_Event.gender ASC

It took about 5 minutes to process in phpMyAdmin and here are the contents from "Explain".

Code:

id     select_type     table     type     possible_keys     key     key_len     ref     rows     Extra
1     SIMPLE     Meet_Event     ALL     NULL     NULL     NULL     NULL     4730     Using where; Using temporary; Using filesort
1     SIMPLE     Event     eq_ref     PRIMARY     PRIMARY     34     ptentry_entrysystem.Meet_Event.event_id     1      
1     SIMPLE     Meet_Athlete     ALL     NULL     NULL     NULL     NULL     6277      
1     SIMPLE     Athlete     eq_ref     PRIMARY     PRIMARY     8     ptentry_entrysystem.Meet_Athlete.athlete_id     1     Using index
1     SIMPLE     Roster     ALL     NULL     NULL     NULL     NULL     27059      
1     SIMPLE     Coach     const     PRIMARY     PRIMARY     8     const     1     Using index