Query Metrics
10
Database Queries
10
Different statements
1148.22 ms
Query time
0
Invalid entities
0
Cache hits
1
Cache misses
2
Cache puts
Queries
#▲ | Time | Info |
---|---|---|
1 | 0.79 ms |
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_canonical = ? LIMIT 1
Parameters:
[
"vojtech.kosnar@email.cz"
]
|
2 | 0.29 ms |
"START TRANSACTION"
Parameters:
[] |
3 | 511.84 ms |
UPDATE fos_user SET last_login = ? WHERE id = ?
Parameters:
[ "2025-08-20 11:54:53" 680 ] |
4 | 0.73 ms |
INSERT INTO revisions (timestamp, username) VALUES (?, ?)
Parameters:
[ "2025-08-20 11:54:54" "vojtech.kosnar@email.cz" ] |
5 | 0.86 ms |
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:
[ "500656" "UPD" "vojtech.kosnar@email.cz" "vojtech.kosnar@email.cz" "vojtech.kosnar@email.cz" "vojtech.kosnar@email.cz" 1 null "$argon2id$v=19$m=65536,t=4,p=1$rKIh8EuFzC3knDHiY5Jx4A$9wnIOw+7pmoVDRQtB1I+lyA4uGk7DoVO0llcvsG/6/Q" "2025-08-20 11:54:53" null null "a:0:{}" 680 "vojtech" "kosnar" null null "000000000" "" null null null null "en" 1 null null ] |
6 | 270.82 ms |
"COMMIT"
Parameters:
[] |
7 | 0.96 ms |
UPDATE fos_user_audit SET last_login = ? WHERE rev = ? AND id = ?
Parameters:
[ "2025-08-20 11:54:53" "500656" 680 ] |
8 | 358.65 ms |
SELECT u.id, u.name, u.surname, u.email, u.roles, u.github, u.github_id, u.language, u.created FROM fos_user u WHERE u.id = :parameter
Parameters:
[ "parameter" => "680" ] |
9 | 1.55 ms |
SELECT iaua.instance_id, iaua.last_seen_material_id material_id, iaua.last_seen_material_date date, mct.chapter_id FROM ia_user_access iaua JOIN fos_user fu on iaua.user_id = fu.id JOIN instance i on i.id = iaua.instance_id JOIN materials_course_tree mct on mct.course_id = i.course_id and mct.material_id = iaua.last_seen_material_id WHERE iaua.user_id = :id AND iaua.last_seen_material_id IS NOT NULL AND fu.show_welcome_page = 1 ORDER BY iaua.last_seen_material_date DESC LIMIT 1
Parameters:
[ "id" => "680" ] |
10 | 1.72 ms |
SELECT COUNT(i.id) FROM ia_user_access ua JOIN instance i on ua.instance_id = i.id JOIN materials_course mc on i.course_id = mc.id WHERE mc.repositories = 1 AND ua.user_id = :id
Parameters:
[ "id" => 680 ] |
Database Connections
Name | Service |
---|---|
default | doctrine.dbal.default_connection |
Entity Managers
Name | Service |
---|---|
default | doctrine.orm.default_entity_manager |
Second Level Cache
0
Hits
1
Misses
2
Puts
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. |
CodersLab\Lms\Modules\Materials\Domain\Pill\Material | No errors. |