Query Metrics
11
Database Queries
5
Different statements
94.96 ms
Query time
0
Invalid entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 11.15 ms |
SELECT t0.id AS id_1, t0.first_name AS first_name_2, t0.last_name AS last_name_3, t0.email AS email_4, t0.roles AS roles_5, t0.password AS password_6, t0.validated AS validated_7, t0.subscribed AS subscribed_8, t0.validation_key AS validation_key_9, t0.influxdb_url AS influxdb_url_10, t0.influxdb_user AS influxdb_user_11, t0.influxdb_password AS influxdb_password_12, t0.influxdb_name AS influxdb_name_13, t0.account_id AS account_id_14 FROM "user" t0 WHERE t0.email = ? LIMIT 1
Parameters:
[
"trappy@gmail.com"
]
|
2 | 5.15 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.sn AS sn_3, t0.long_name AS long_name_4, t0.disc_type AS disc_type_5, t0.is_deleted AS is_deleted_6, t0.data AS data_7, t0.last_seen AS last_seen_8, t0.parent_id AS parent_id_9, t0.virtual_parent_id AS virtual_parent_id_10, t0.owner_id AS owner_id_11, t0.type FROM device t0 WHERE t0.id = ? AND t0.type IN ('nutrient', 'lamp', 'fan', 'multi_socket', 'virtual')
Parameters:
[
9
]
|
3 | 0.85 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.address AS address_3, t0.master AS master_4, t0.climate AS climate_5, t0.is_deleted AS is_deleted_6, t0.seasons AS seasons_7, t0.start_date AS start_date_8, t0.owner_id AS owner_id_9 FROM growbox t0 WHERE t0.id = ?
Parameters:
[
1
]
|
4 | 3.28 ms |
SELECT t0.id AS id_1, t0.cache_key AS cache_key_2, t0.data AS data_3, t0.parent_id AS parent_id_4, t0.type FROM relay t0 WHERE t0.parent_id = ? AND t0.type IN ('power', 'timer', 'dimmer', 'light')
Parameters:
[
9
]
|
5 | 8.42 ms |
SELECT t0.id AS id_1, t0.value AS value_2, t0.created_at AS created_at_3, t0.data AS data_4, t0.relay_id AS relay_id_5 FROM executed_action t0 WHERE t0.relay_id = ? ORDER BY t0.created_at DESC LIMIT 1
Parameters:
[
34
]
|
6 | 7.94 ms |
SELECT t0.id AS id_1, t0.value AS value_2, t0.created_at AS created_at_3, t0.data AS data_4, t0.relay_id AS relay_id_5 FROM executed_action t0 WHERE t0.relay_id = ? ORDER BY t0.created_at DESC LIMIT 1
Parameters:
[
37
]
|
7 | 7.31 ms |
SELECT t0.id AS id_1, t0.value AS value_2, t0.created_at AS created_at_3, t0.data AS data_4, t0.relay_id AS relay_id_5 FROM executed_action t0 WHERE t0.relay_id = ? ORDER BY t0.created_at DESC LIMIT 1
Parameters:
[
39
]
|
8 | 4.52 ms |
SELECT t0.id AS id_1, t0.value AS value_2, t0.created_at AS created_at_3, t0.data AS data_4, t0.relay_id AS relay_id_5 FROM executed_action t0 WHERE t0.relay_id = ? ORDER BY t0.created_at DESC LIMIT 1
Parameters:
[
35
]
|
9 | 42.53 ms |
SELECT t0.id AS id_1, t0.value AS value_2, t0.created_at AS created_at_3, t0.data AS data_4, t0.relay_id AS relay_id_5 FROM executed_action t0 WHERE t0.relay_id = ? ORDER BY t0.created_at DESC LIMIT 1
Parameters:
[
33
]
|
10 | 2.79 ms |
SELECT t0.id AS id_1, t0.value AS value_2, t0.created_at AS created_at_3, t0.data AS data_4, t0.relay_id AS relay_id_5 FROM executed_action t0 WHERE t0.relay_id = ? ORDER BY t0.created_at DESC LIMIT 1
Parameters:
[
36
]
|
11 | 1.03 ms |
SELECT t0.id AS id_1, t0.value AS value_2, t0.created_at AS created_at_3, t0.data AS data_4, t0.relay_id AS relay_id_5 FROM executed_action t0 WHERE t0.relay_id = ? ORDER BY t0.created_at DESC LIMIT 1
Parameters:
[
38
]
|
Database Connections
Name | Service |
---|---|
default | doctrine.dbal.default_connection |
Entity Managers
Name | Service |
---|---|
default | doctrine.orm.default_entity_manager |
Second Level Cache
Second Level Cache is not enabled.
Entities Mapping
Class | Mapping errors |
---|---|
App\Entity\User | No errors. |
App\Entity\Account | No errors. |
App\Entity\Growbox | No errors. |
App\Entity\Device | No errors. |
App\Entity\Devices\NutrientMixer | No errors. |
App\Entity\Devices\LEDLight | No errors. |
App\Entity\Devices\FanController | No errors. |
App\Entity\Devices\SmartMultiSocket | No errors. |
App\Entity\Devices\VirtualDevice | No errors. |
App\Entity\Sensor | No errors. |
App\Entity\Relay | No errors. |
App\Entity\SystemConfig | No errors. |
App\Entity\Notification | No errors. |
App\Entity\Relays\PowerRelay | No errors. |
App\Entity\Relays\TimerRelay | No errors. |
App\Entity\Relays\DimmerRelay | No errors. |
App\Entity\Relays\LightRelay | No errors. |
App\Entity\Action | No errors. |
App\Entity\ExecutedAction | No errors. |