Query Metrics

7 Database Queries
7 Different statements
11.65 ms Query time
0 Invalid entities
2 Cache hits
1 Cache misses
2 Cache puts

Grouped Statements

Show all queries

Time Count Info
6.04 ms
(51.82%)
1
"COMMIT"
Parameters:
[]
1.19 ms
(10.19%)
1
UPDATE fos_user SET last_login = ? WHERE id = ?
Parameters:
[
  "2026-01-21 10:47:08"
  15
]
1.17 ms
(10.04%)
1
SELECT t0.username AS username_1, t0.username_canonical AS username_canonical_2, t0.email AS email_3, t0.email_canonical AS email_canonical_4, t0.enabled AS enabled_5, t0.salt AS salt_6, t0.password AS password_7, t0.last_login AS last_login_8, t0.confirmation_token AS confirmation_token_9, t0.password_requested_at AS password_requested_at_10, t0.roles AS roles_11, t0.id AS id_12, t0.name AS name_13, t0.surname AS surname_14, t0.github AS github_15, t0.github_id AS github_id_16, t0.phone AS phone_17, t0.avatar AS avatar_18, t0.google_id AS google_id_19, t0.google_access_token AS google_access_token_20, t0.google_refresh_token AS google_refresh_token_21, t0.github_access_token AS github_access_token_22, t0.language AS language_23, t0.show_welcome_page AS show_welcome_page_24, t0.terms AS terms_25, t0.created AS created_26 FROM fos_user t0 WHERE t0.email = ? LIMIT 1
Parameters:
[
  "jacek.tchorzewski@coderslab.pl"
]
1.05 ms
(9.04%)
1
"START TRANSACTION"
Parameters:
[]
0.93 ms
(7.98%)
1
INSERT INTO fos_user_audit (rev, revtype, username, username_canonical, email, email_canonical, enabled, salt, password, last_login, confirmation_token, password_requested_at, roles, id, name, surname, github, github_id, phone, avatar, google_id, google_access_token, google_refresh_token, github_access_token, language, show_welcome_page, terms, created) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  "502711"
  "UPD"
  "jacek.tchorzewski@coderslab.pl"
  "jacek.tchorzewski@coderslab.pl"
  "jacek.tchorzewski@coderslab.pl"
  "jacek.tchorzewski@coderslab.pl"
  1
  "FXlNk9hZlDvqURQHSXwK/Zr9yi8k/TcnShMHkSJ0am8"
  "$2y$13$ILpIbxVg0skdVcP4rMrqruWyzWc/KVrZLAWVdPNTlkKgCIgMj2RSW"
  "2026-01-21 10:47:08"
  null
  null
  "a:3:{i:0;s:16:"ROLE_SUPER_ADMIN";i:1;s:11:"ROLE_MENTOR";i:2;s:13:"ROLE_LECTURER";}"
  15
  "Jacek"
  "Tchórzewski"
  "JacekTchorzewski-CL"
  "152855"
  "604978251"
  ""
  null
  null
  null
  null
  "pl"
  0
  "2021-11-16 10:04:54"
  null
]
0.74 ms
(6.36%)
1
INSERT INTO revisions (timestamp, username) VALUES (?, ?)
Parameters:
[
  "2026-01-21 10:47:08"
  "jacek.tchorzewski@coderslab.pl"
]
0.53 ms
(4.57%)
1
UPDATE fos_user_audit SET last_login = ? WHERE rev = ?  AND id = ?
Parameters:
[
  "2026-01-21 10:47:08"
  "502711"
  15
]

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

2 Hits
1 Misses
2 Puts

Number of cache hits

Region Hits
appbundle_entity_user 2

Number of cache misses

Region Misses
appbundle_entity_user 1

Number of cache puts

Region Puts
appbundle_entity_user 2

Entities Mapping

Class Mapping errors
AppBundle\Entity\User No errors.
AppBundle\Entity\Notification No errors.
AppBundle\Entity\InstanceUser No errors.
AppBundle\Entity\ExerciseResult No errors.
AppBundle\Entity\Language No errors.