+----+-------------+----------------------+--------+-------------------------------------+-------------+---------+-----------------------------------+------+-----------------------------------------------------------+
| id | select_type | table                | type   | possible_keys                       | key         | key_len | ref                               | rows | Extra                                                     |
+----+-------------+----------------------+--------+-------------------------------------+-------------+---------+-----------------------------------+------+-----------------------------------------------------------+
|  1 | SIMPLE      | ACL_4                | range  | ACL1                                | ACL1        | 54      | NULL                              |  296 | Using where; Using index; Using temporary; Using filesort | 
|  1 | SIMPLE      | Groups_3             | ref    | PRIMARY,Groups1,Groups2,RUZ_Groups1 | RUZ_Groups1 | 134     | const,rt3.ACL_4.PrincipalType     |  365 | Using where; Using index                                  | 
|  1 | SIMPLE      | CachedGroupMembers_2 | ref    | DisGrouMem,GrouMem,group1,member1   | DisGrouMem  | 5       | rt3.Groups_3.id                   |    1 | Using where; Using index                                  | 
|  1 | SIMPLE      | Principals_1         | eq_ref | PRIMARY                             | PRIMARY     | 4       | rt3.CachedGroupMembers_2.MemberId |    1 | Using where                                               | 
|  1 | SIMPLE      | main                 | eq_ref | PRIMARY,Users3                      | PRIMARY     | 4       | rt3.Principals_1.id               |    1 | Using where                                               | 
+----+-------------+----------------------+--------+-------------------------------------+-------------+---------+-----------------------------------+------+-----------------------------------------------------------+
+---------------+-----------+
| PrincipalType | COUNT(id) |
+---------------+-----------+
| Group         |       298 | 
+---------------+-----------+
+----+-------------+-------+-------+---------------+------+---------+------+------+--------------------------+
| id | select_type | table | type  | possible_keys | key  | key_len | ref  | rows | Extra                    |
+----+-------------+-------+-------+---------------+------+---------+------+------+--------------------------+
|  1 | SIMPLE      | ACL_4 | range | ACL1          | ACL1 | 54      | NULL |  296 | Using where; Using index | 
+----+-------------+-------+-------+---------------+------+---------+------+------+--------------------------+
+--------------------+
| COUNT(Groups_3.id) |
+--------------------+
|                  0 | 
+--------------------+
+----+-------------+----------+-------+-----------------------------+-------------+---------+-------------------------------+------+--------------------------+
| id | select_type | table    | type  | possible_keys               | key         | key_len | ref                           | rows | Extra                    |
+----+-------------+----------+-------+-----------------------------+-------------+---------+-------------------------------+------+--------------------------+
|  1 | SIMPLE      | ACL_4    | range | ACL1                        | ACL1        | 54      | NULL                          |  296 | Using where; Using index | 
|  1 | SIMPLE      | Groups_3 | ref   | Groups1,Groups2,RUZ_Groups1 | RUZ_Groups1 | 134     | const,rt3.ACL_4.PrincipalType |  365 | Using where; Using index | 
+----+-------------+----------+-------+-----------------------------+-------------+---------+-------------------------------+------+--------------------------+
+----+-------------+-------+-------+---------------+------+---------+------+------+--------------------------+
| id | select_type | table | type  | possible_keys | key  | key_len | ref  | rows | Extra                    |
+----+-------------+-------+-------+---------------+------+---------+------+------+--------------------------+
|  1 | SIMPLE      | ACL_4 | range | ACL1          | ACL1 | 54      | NULL |  296 | Using where; Using index | 
+----+-------------+-------+-------+---------------+------+---------+------+------+--------------------------+
+----+-------------+----------+-------+-----------------------------+-------------+---------+-------------------------------+------+--------------------------+
| id | select_type | table    | type  | possible_keys               | key         | key_len | ref                           | rows | Extra                    |
+----+-------------+----------+-------+-----------------------------+-------------+---------+-------------------------------+------+--------------------------+
|  1 | SIMPLE      | ACL_4    | range | ACL1                        | ACL1        | 54      | NULL                          |  296 | Using where; Using index | 
|  1 | SIMPLE      | Groups_3 | ref   | Groups1,Groups2,RUZ_Groups1 | RUZ_Groups1 | 134     | const,rt3.ACL_4.PrincipalType |  365 | Using where; Using index | 
+----+-------------+----------+-------+-----------------------------+-------------+---------+-------------------------------+------+--------------------------+
+----+-------------+-------+-------+---------------+------+---------+------+------+--------------------------+
| id | select_type | table | type  | possible_keys | key  | key_len | ref  | rows | Extra                    |
+----+-------------+-------+-------+---------------+------+---------+------+------+--------------------------+
|  1 | SIMPLE      | ACL_4 | range | ACL1          | ACL1 | 54      | NULL |  296 | Using where; Using index | 
+----+-------------+-------+-------+---------------+------+---------+------+------+--------------------------+
+----+-------------+----------+-------+-----------------------------+-------------+---------+-------------------------------+------+--------------------------+
| id | select_type | table    | type  | possible_keys               | key         | key_len | ref                           | rows | Extra                    |
+----+-------------+----------+-------+-----------------------------+-------------+---------+-------------------------------+------+--------------------------+
|  1 | SIMPLE      | ACL_4    | range | ACL1                        | ACL1        | 54      | NULL                          |  296 | Using where; Using index | 
|  1 | SIMPLE      | Groups_3 | ref   | Groups1,Groups2,RUZ_Groups1 | RUZ_Groups1 | 134     | const,rt3.ACL_4.PrincipalType |  365 | Using where; Using index | 
+----+-------------+----------+-------+-----------------------------+-------------+---------+-------------------------------+------+--------------------------+
+--------------------+------------+------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+
| Table              | Non_unique | Key_name   | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment |
+--------------------+------------+------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+
| CachedGroupMembers |          0 | PRIMARY    |            1 | id          | A         |       97966 |     NULL | NULL   |      | BTREE      |         | 
| CachedGroupMembers |          1 | DisGrouMem |            1 | GroupId     | A         |       97966 |     NULL | NULL   | YES  | BTREE      |         | 
| CachedGroupMembers |          1 | DisGrouMem |            2 | MemberId    | A         |       97966 |     NULL | NULL   | YES  | BTREE      |         | 
| CachedGroupMembers |          1 | DisGrouMem |            3 | Disabled    | A         |       97966 |     NULL | NULL   |      | BTREE      |         | 
| CachedGroupMembers |          1 | GrouMem    |            1 | GroupId     | A         |       97966 |     NULL | NULL   | YES  | BTREE      |         | 
| CachedGroupMembers |          1 | GrouMem    |            2 | MemberId    | A         |       97966 |     NULL | NULL   | YES  | BTREE      |         | 
| CachedGroupMembers |          1 | group1     |            1 | GroupId     | A         |       97966 |     NULL | NULL   | YES  | BTREE      |         | 
| CachedGroupMembers |          1 | member1    |            1 | MemberId    | A         |       97966 |     NULL | NULL   | YES  | BTREE      |         | 
+--------------------+------------+------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+
