+----+--------------+------------+--------+---------------------------------------+--------------------+---------+------------------------+------+-------------+ | id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra | +----+--------------+------------+--------+---------------------------------------+--------------------+---------+------------------------+------+-------------+ | 1 | PRIMARY | Listings | range | DateTime+StationID,StationID+DateTime | StationID+DateTime | 12 | NULL | 445 | Using where | | 1 | PRIMARY | Shows | eq_ref | PRIMARY | PRIMARY | 4 | tvdata.Listings.ShowID | 1 | | | 2 | UNION | Listings | range | DateTime+StationID,StationID+DateTime | StationID+DateTime | 12 | NULL | 353 | Using where | | 2 | UNION | Shows | eq_ref | PRIMARY | PRIMARY | 4 | tvdata.Listings.ShowID | 1 | | | | UNION RESULT | | ALL | NULL | NULL | NULL | NULL | NULL | | +----+--------------+------------+--------+---------------------------------------+--------------------+---------+------------------------+------+-------------+