new explain

new explain

+----+-------------+-----------------------------+--------+--------------------------------------------------+------------------+---------+----------------------------------------------------------+------+----------------------------------------------+
| id | select_type | table                       | type   | possible_keys                                    | key              | key_len | ref                                                      | rows | Extra                                        |
+----+-------------+-----------------------------+--------+--------------------------------------------------+------------------+---------+----------------------------------------------------------+------+----------------------------------------------+
|  1 | SIMPLE      | devices                     | index  | NULL                                             | PRIMARY          | 4       | NULL                                                     | 4962 | Using where; Using temporary; Using filesort |
|  1 | SIMPLE      | serial_numbers              | ref    | device_id                                        | device_id        | 4       | device_hub.devices.id                                    |    1 |                                              |
|  1 | SIMPLE      | inverter_properties         | ref    | device_id,device_active_tdx                      | device_id        | 4       | device_hub.devices.id                                    |    2 |                                              |
|  1 | SIMPLE      | lookup_metrics              | eq_ref | PRIMARY                                          | PRIMARY          | 4       | device_hub.inverter_properties.inverter_property_name_id |    1 |                                              |
|  1 | SIMPLE      | lookup_models               | eq_ref | PRIMARY                                          | PRIMARY          | 4       | device_hub.devices.model_id                              |    1 |                                              |
|  1 | SIMPLE      | inverter_connection_history | ref    | fk_inverter_connection_history_inverters1,active | active           | 6       | const,device_hub.devices.id                              |   42 |                                              |
|  1 | SIMPLE      | inverter_status_history     | ref    | active                                           | active           | 6       | device_hub.devices.id,const                              |  990 |                                              |
|  1 | SIMPLE      | inverter_lookup_status      | ref    | PRIMARY                                          | PRIMARY          | 4       | device_hub.inverter_status_history.status_id             |    1 | Using index                                  |
|  1 | SIMPLE      | inverter_monitor_polls      | eq_ref | id                                               | id               | 8       | device_hub.devices.last_poll_id                          |    1 |                                              |
|  1 | SIMPLE      | inverter_tripped_fault_list | ref    | inverter_poll_id                                 | inverter_poll_id | 4       | device_hub.devices.last_poll_id                          |    1 |                                              |
+----+-------------+-----------------------------+--------+--------------------------------------------------+------------------+---------+----------------------------------------------------------+------+----------------------------------------------+
10 rows in set (0.00 sec)