POST http://dev.sosadvanced.pt/api/session/heartbeat

Query Metrics

6 Database Queries
6 Different statements
9.97 ms Query time
0 Invalid entities
4 Managed entities

Queries

Group similar statements

# Time Info
1 1.77 ms
SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4, t0.allowed AS allowed_5, t0.active AS active_6, t0.email AS email_7, t0.token AS token_8, t0.companies AS companies_9, t0.tenant_code AS tenant_code_10, t11.leadfieldsshow AS leadfieldsshow_12, t11.homepage_widgets AS homepage_widgets_13, t11.user_id AS user_id_14 FROM user t0 LEFT JOIN user_apps_settings t11 ON t11.user_id = t0.id WHERE t0.id = ?
Parameters:
[
  1
]
2 1.10 ms
SELECT t0.id AS id_1, t0.code AS code_2, t0.db_host AS db_host_3, t0.db_port AS db_port_4, t0.db_name AS db_name_5, t0.db_user AS db_user_6, t0.db_password AS db_password_7, t0.db_charset AS db_charset_8, t0.company_id AS company_id_9, t0.json_data AS json_data_10 FROM tenant t0 WHERE t0.code = ? LIMIT 1
Parameters:
[
  "sos"
]
3 1.46 ms
SELECT u0_.id AS id_0, u0_.session_id AS session_id_1, u0_.login_at AS login_at_2, u0_.last_heartbeat_at AS last_heartbeat_at_3, u0_.logout_at AS logout_at_4, u0_.ip AS ip_5, u0_.user_agent AS user_agent_6, u0_.user_id AS user_id_7 FROM user_session u0_ WHERE u0_.session_id = ? AND u0_.logout_at IS NULL ORDER BY u0_.login_at DESC LIMIT 1
Parameters:
[
  "32f59cb0f8dd2a7987e933e50d87b91e"
]
4 0.36 ms
"START TRANSACTION"
Parameters:
[]
5 0.82 ms
UPDATE user_session SET last_heartbeat_at = ? WHERE id = ?
Parameters:
[
  "2026-02-27 08:55:16"
  26
]
6 4.47 ms
"COMMIT"
Parameters:
[]

Database Connections

Name Service
system doctrine.dbal.system_connection

Entity Managers

Name Service
system doctrine.orm.system_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

system entity manager

Class Amount of managed objects
App\Entity\User 1
App\Entity\UserAppsSettings 1
App\Entity\Tenant 1
App\Entity\UserSession 1

Entities Mapping

Class Mapping errors
App\Entity\User No errors.
App\Entity\UserAppsSettings No errors.
App\Entity\Tenant No errors.
App\Entity\UserSession No errors.