EXPLAIN SELECT * FROM `T_UserBase` AS users
LEFT OUTER JOIN `T_ScheduledTestTakerUsers` AS takers ON takers.`F_UserID` = users.`F_UserID`
LEFT OUTER JOIN `T_ScheduledTestsBase` AS tests ON tests.`F_TestID` = takers.`F_TestID`
LEFT OUTER JOIN `T_SessionTrack` AS sessions ON sessions.`F_UserID` = users.`F_UserID`
WHERE (tests.`F_TestID` = 4510) OR (sessions.`F_ContentID` = 4510)
id select_type table partitions type possible_keys key key_len ref rows filtered Extra