Query Metrics
7
Database Queries
7
Different statements
76.90 ms
Query time
0
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
69.74 ms (90.68%) |
1 |
SELECT t0.id AS id_1, t0.value AS value_2, t0.created_at AS created_at_3, t0.port AS port_4, t0.sensor_id AS sensor_id_5 FROM sensor_log_entry t0 WHERE (t0.created_at >= ? AND t0.sensor_id = ?) ORDER BY t0.created_at DESC
Parameters:
[ "2024-09-12 22:02:29" 18 ] |
2.90 ms (3.77%) |
1 |
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:
[
"iulian.arcus@tbs-avionics.com"
]
|
1.30 ms (1.69%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.long_name AS long_name_3, t0.display_type AS display_type_4, t0.last_active_date AS last_active_date_5, t0.position AS position_6, t0.is_deleted AS is_deleted_7, t0.dashboard AS dashboard_8, t0.active AS active_9, t0.source AS source_10, t0.cache_key AS cache_key_11, t0.disc_type AS disc_type_12, t0.device_id AS device_id_13, t0.type FROM sensor t0 WHERE t0.id = ? AND t0.is_deleted = ? AND t0.type IN ('all', 'pump', 'co2', 'ec', 'humidity', 'light', 'ph', 'soilmoist', 'temp', 'vpd', 'water_level') ORDER BY t0.position ASC
Parameters:
[ 18 0 ] |
0.92 ms (1.19%) |
1 |
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:
[
66
]
|
0.87 ms (1.13%) |
1 |
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:
[
1
]
|
0.64 ms (0.84%) |
1 |
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.parent_id = ? AND t0.type IN ('nutrient', 'lamp', 'fan', 'multi_socket', 'virtual')
Parameters:
[
66
]
|
0.54 ms (0.70%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.monthly_cost AS monthly_cost_3, t0.yearly_cost AS yearly_cost_4, t0.limit_sensor_storage_frequency AS limit_sensor_storage_frequency_5, t0.limit_sensor_storage_duration AS limit_sensor_storage_duration_6 FROM account t0 WHERE t0.id = ?
Parameters:
[
4
]
|
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\SystemConfig | No errors. |
App\Entity\Notification | No errors. |
App\Entity\Sensor | No errors. |
App\Entity\Sensors\AllSensor | No errors. |
App\Entity\Sensors\PumpSensor | No errors. |
App\Entity\Sensors\Co2Sensor | No errors. |
App\Entity\Sensors\EcSensor | No errors. |
App\Entity\Sensors\HumiditySensor | No errors. |
App\Entity\Sensors\LightSensor | No errors. |
App\Entity\Sensors\PhSensor | No errors. |
App\Entity\Sensors\SoilmoistureSensor | No errors. |
App\Entity\Sensors\TemperatureSensor | No errors. |
App\Entity\Sensors\VpdSensor | No errors. |
App\Entity\Sensors\WatertankSensor | 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\Relay | No errors. |
App\Entity\SensorLogEntry | No errors. |