-------+---------------+
| tree  |          0 | PRIMARY    |            1 | child         | A         |      114595 |     NULL | NULL   |      | BTREE      |         |               |
| tree  |          0 | PRIMARY    |            2 | parent        | A         |      114595 |     NULL | NULL   |      | BTREE      |         |               |
| tree  |          0 | PRIMARY    |            3 | relation_type | A         |      114595 |     NULL | NULL   |      | BTREE      |         |               |
| tree  |          1 | idx_tree   |            1 | child         | A         |      114595 |     NULL | NULL   |      | BTREE      |         |               |
| tree  |          1 | idx_tree   |            2 | parent        | A         |      114595 |     NULL | NULL   |      | BTREE      |         |               |
| tree  |          1 | idx_tree   |            3 | relation_type | A         |      114595 |     NULL | NULL   |      | BTREE      |         |               |
| tree  |          1 | idx_tree_1 |            1 | parent        | A         |        7639 |     NULL | NULL   |      | BTREE      |         |               |
| tree  |          1 | idx_tree_2 |            1 | child         | A         |      114595 |     NULL | NULL   |      | BTREE      |         |               |
| tree  |          1 | idx_tree_3 |            1 | relation_type | A         |         130 |     NULL | NULL   |      | BTREE      |         |               |
| tree  |          1 | idx_tree_4 |            1 | parent        | A         |       11459 |     NULL | NULL   |      | BTREE      |         |               |
| tree  |          1 | idx_tree_4 |            2 | child         | A         |      114595 |     NULL | NULL   |      | BTREE      |         |               |
| tree  |          1 | idx_tree_4 |            3 | relation_type | A         |      114595 |     NULL | NULL   |      | BTREE      |         |               |
| tree  |          1 | parent     |            1 | parent        | A         |       16370 |     NULL | NULL   |      | BTREE      |         |               |
| tree  |          1 | child      |            1 | child         | A         |      114595 |     NULL | NULL   |      | BTREE      |         |               |
| tree  |          1 | parent_2   |            1 | parent        | A         |        2728 |     NULL | NULL   |      | BTREE      |         |               |
| tree  |          1 | child_2    |            1 | child         | A         |      114595 |     NULL | NULL   |      | BTREE      |         |               |
| tree  |          1 | idx_tree_5 |            1 | parent        | A         |        5456 |     NULL | NULL   |      | BTREE      |         |               |
| tree  |          1 | idx_tree_5 |            2 | relation_type | A         |        5456 |     NULL | NULL   |      | BTREE      |         |               |
| tree  |          1 | idx_tree_6 |            1 | child         | A         |      114595 |     NULL | NULL   |      | BTREE      |         |               |
| tree  |          1 | idx_tree_6 |            2 | relation_type | A         |      114595 |     NULL | NULL   |      | BTREE      |         |               |
+-------+------------+------------+--------------+---------------+-----------+-------------+----------+--------+------+------------+---------+---------------+