Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment |
ip_groups | 0 | PRIMARY | 1 | id | A | 108157 | NULL | NULL | | BTREE | |
ip_groups | 1 | ig_idx | 1 | ip_group_id | A | 13519 | NULL | NULL | YES | BTREE | |
ip_groups | 1 | mac_aid_idx | 1 | mac | A | 7725 | NULL | NULL | YES | BTREE | |
ip_groups | 1 | mac_aid_idx | 2 | is_deleted | A | 8319 | NULL | NULL | YES | BTREE | |
ip_groups | 1 | mac_aid_idx | 3 | account_id_ipg | A | 18026 | NULL | NULL | YES | BTREE | |
ip_groups | 1 | index_264d0ebccce540730e5da3d221dfa3d9 | 1 | ip_group_id | A | 13519 | NULL | NULL | YES | BTREE | |
ip_groups | 1 | index_264d0ebccce540730e5da3d221dfa3d9 | 2 | ip_type | A | 13519 | NULL | NULL | YES | BTREE | |
ip_groups | 1 | index_264d0ebccce540730e5da3d221dfa3d9 | 3 | is_deleted | A | 21631 | NULL | NULL | YES | BTREE | |