POST https://dk.fcsprint2.nl/login?p=login

Query Metrics

8 Database Queries
6 Different statements
33.60 ms Query time
0 Invalid entities
2 Managed entities

Queries

Group similar statements

# Time Info
1 0.50 ms
SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.active AS active_3, t0.id AS id_4, t0.last_used AS last_used_5, t0.username AS username_6, t0.enabled AS enabled_7, t0.used AS used_8, t0.name AS name_9, t0.organisation AS organisation_10, t0.town AS town_11, t0.country AS country_12, t0.email AS email_13, t0.password AS password_14, t0.azure_id AS azure_id_15, t0.menu_id AS menu_id_16, t0.azure_refresh_token AS azure_refresh_token_17, t0.progress AS progress_18, t0.roles AS roles_19, t0.lastlogin AS lastlogin_20, t0.user_id AS user_id_21 FROM user t0 WHERE t0.email = ? LIMIT 1
Parameters:
[
  "skole"
]
2 0.27 ms
"START TRANSACTION"
Parameters:
[]
3 0.54 ms
UPDATE user SET last_used = ?, used = ?, updated_at = ? WHERE id = ?
Parameters:
[
  "2026-09-01 12:39:16"
  4884
  "2026-09-01 12:39:16"
  1845
]
4 9.39 ms
"COMMIT"
Parameters:
[]
5 0.31 ms
"START TRANSACTION"
Parameters:
[]
6 0.44 ms
INSERT INTO login_log (logged_at, user_id) VALUES (?, ?)
Parameters:
[
  "2026-09-01 12:39:16"
  1845
]
7 10.87 ms
"COMMIT"
Parameters:
[]
8 11.27 ms
INSERT INTO login_daily_stat (login_date, login_count)
             VALUES (?, 1)
             ON DUPLICATE KEY UPDATE login_count = login_count + 1
Parameters:
[
  "2026-09-01"
]

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.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\User 1
App\Entity\LoginLog 1

Entities Mapping

Class Mapping errors
App\Entity\TimeStamped No errors.
App\Entity\User No errors.
App\Entity\Sso\TeacherStudents No errors.
App\Entity\LoginLog No errors.