EXPLAIN SQL

+----+-------------+--------------------+--------+--------------------------------------------+------------------------------------+---------+--------------------+-------+----------------------------------------------+
| id | select_type | table              | type   | possible_keys                              | key                                | key_len | ref                | rows  | Extra                                        |
+----+-------------+--------------------+--------+--------------------------------------------+------------------------------------+---------+--------------------+-------+----------------------------------------------+
|  1 | PRIMARY     | operation          | index  | NULL                                       | ix_operation_user_27               | 8       | NULL               |    85 | Using index; Using temporary; Using filesort |
|  1 | PRIMARY     | <derived2>         | ALL    | NULL                                       | NULL                               | NULL    | NULL               |    84 |                                              |
|  1 | PRIMARY     | <derived4>         | ALL    | NULL                                       | NULL                               | NULL    | NULL               |    84 |                                              |
|  1 | PRIMARY     | <derived5>         | ALL    | NULL                                       | NULL                               | NULL    | NULL               |    84 |                                              |
|  5 | DERIVED     | organization       | index  | PRIMARY                                    | NULL                               | 8       | NULL               |  8493 | Using index; Using temporary; Using filesort |
|  5 | DERIVED     | accepted           | ref    | PRIMARY,ix_accepted_organization_3         | ix_accepted_organization_3         | 8       | db.organization.id |     1 | Using index                                  |
|  5 | DERIVED     | hostname           | ref    | PRIMARY,ix_hostname_accepted_15            | ix_hostname_accepted_15            | 8       | db.accepted.id     |     2 | Using index                                  |
|  5 | DERIVED     | hostname_operation | ref    | ix_hostname_operation_hostname_16          | ix_hostname_operation_hostname_16  | 8       | db.hostname.id     |     1 |                                              |
|  4 | DERIVED     | domain             | index  | PRIMARY                                    | PRIMARY                            | 8       | NULL               | 13363 | Using index; Using temporary; Using filesort |
|  4 | DERIVED     | accepted           | eq_ref | PRIMARY,uq_accepted_1,ix_accepted_domain_1 | uq_accepted_1                      | 8       | db.domain.id       |     1 | Using index                                  |
|  4 | DERIVED     | hostname           | ref    | PRIMARY,ix_hostname_accepted_15            | ix_hostname_accepted_15            | 8       | db.accepted.id     |     2 | Using index                                  |
|  4 | DERIVED     | hostname_operation | ref    | ix_hostname_operation_hostname_16          | ix_hostname_operation_hostname_16  | 8       | db.hostname.id     |     1 |                                              |
|  2 | DERIVED     | hostname_operation | index  | NULL                                       | ix_hostname_operation_operation_17 | 8       | NULL               | 78359 | Using index; Using temporary; Using filesort |
|  2 | DERIVED     | <derived3>         | ALL    | NULL                                       | NULL                               | NULL    | NULL               |    48 |                                              |
|  3 | DERIVED     | hostname_operation | range  | ix_hostname_operation_error_18             | ix_hostname_operation_error_18     | 9       | NULL               |  1851 | Using where; Using temporary; Using filesort |
+----+-------------+--------------------+--------+--------------------------------------------+------------------------------------+---------+--------------------+-------+----------------------------------------------+