https://preprod.app.oecko.com/api/v3/thinclients/nuc-7760d05b-358c-455d-b69a-13676ef53756

Query Metrics

4 Database Queries
4 Different statements
15.85 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 2.29 ms
SELECT t0.id AS id_1, t0.mac_address AS mac_address_2, t0.name AS name_3, t0.ip_address AS ip_address_4, t0.ip_vpn AS ip_vpn_5, t0.disable_upgrades AS disable_upgrades_6, t0.update_to_version AS update_to_version_7, t0.need_config_update AS need_config_update_8, t0.software_version AS software_version_9, t0.hardware_id AS hardware_id_10, t0.software_id AS software_id_11, t0.token AS token_12, t0.last_consumption_reset AS last_consumption_reset_13, t0.last_screenshot_name AS last_screenshot_name_14, t0.last_screenshot_updated_at AS last_screenshot_updated_at_15, t0.last_known_status AS last_known_status_16, t0.last_status_update AS last_status_update_17, t0.last_unreachable_alert AS last_unreachable_alert_18, t0.data_consumption AS data_consumption_19, t0.network_quality AS network_quality_20, t0.router AS router_21, t0.imsi AS imsi_22, t0.update_tokens AS update_tokens_23, t0.registration AS registration_24, t0.environment_server AS environment_server_25, t0.entrance_id AS entrance_id_26 FROM thin_client t0 WHERE t0.software_id = ? LIMIT 1
Parameters:
[
  "nuc-7760d05b-358c-455d-b69a-13676ef53756"
]
2 1.79 ms
"START TRANSACTION"
Parameters:
[]
3 2.14 ms
UPDATE thin_client SET last_status_update = ? WHERE id = ?
Parameters:
[
  "2025-12-18 21:39:25"
  3875
]
4 9.63 ms
"COMMIT"
Parameters:
[]

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\ThinClient No errors.
App\Entity\Entrance No errors.
App\Entity\ThinClientCommand No errors.
App\Entity\SaltOperation No errors.
App\Entity\SaltGroup No errors.
App\Entity\Residence No errors.
App\Entity\Organization No errors.
App\Entity\CategorySet No errors.