+----+-------------+-------+--------+---------------------------------------------+--------------+---------+------------------------+------+----------------------------------------------------+
| id | select_type | table | type   | possible_keys                               | key          | key_len | ref                    | rows | Extra                                              |
+----+-------------+-------+--------+---------------------------------------------+--------------+---------+------------------------+------+----------------------------------------------------+
|  1 | SIMPLE      | m     | ref    | idx_tag_type,idx_core_content_id            | idx_tag_type | 4       | const                  |  218 | Using where; Using temporary; Using filesort       |
|  1 | SIMPLE      | c     | eq_ref | PRIMARY,tag_idx,idx_access,idx_content_type | PRIMARY      | 4       | test.m.core_content_id |    1 | Using where                                        |
|  1 | SIMPLE      | tc    | eq_ref | PRIMARY                                     | PRIMARY      | 4       | test.c.core_catid      |    1 | Using where                                        |
|  1 | SIMPLE      | ct    | ref    | idx_alias                                   | idx_alias    | 302     | test.m.type_alias      |    1 | Using where                                        |
|  1 | SIMPLE      | ua    | ALL    | PRIMARY                                     | NULL         | NULL    | NULL                   |    2 | Using where; Using join buffer (Block Nested Loop) |
+----+-------------+-------+--------+---------------------------------------------+--------------+---------+------------------------+------+----------------------------------------------------+
5 rows in set, 3 warnings (0.01 sec)