Query Metrics
4
Database Queries
4
Different statements
248.76 ms
Query time
0
Invalid entities
0
Cache hits
1
Cache misses
1
Cache puts
Queries
#▲ | Time | Info |
---|---|---|
1 | 0.96 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.id = ? LIMIT 1
Parameters:
[
15
]
|
2 | 0.92 ms |
SELECT roles FROM fos_user WHERE id = :uid
Parameters:
[ "uid" => 15 ] |
3 | 0.96 ms |
SELECT m.access FROM materials_pill_material m JOIN materials_pill_version mpv on m.version_id = mpv.id JOIN materials_pill mp on mpv.pill_id= mp.id WHERE m.id = :id
Parameters:
[ "id" => "0618cd18-5947-4c3d-bd37-4160d09f3e08" ] |
4 | 245.92 ms |
SELECT distinct count(1) as has_access FROM materials_pill_material pm JOIN materials_course_tree mct ON pm.id = mct.material_id JOIN materials_course mc ON mc.id = mct.course_id JOIN user_language ul ON ul.language_id = mc.technology_id WHERE pm.id = :mid AND ul.user_id = :uid;
Parameters:
[ "mid" => "0618cd18-5947-4c3d-bd37-4160d09f3e08" "uid" => 15 ] |
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
1
Puts
Number of cache misses
Region | Misses |
---|---|
appbundle_entity_user | 1 |
Number of cache puts
Region | Puts |
---|---|
appbundle_entity_user | 1 |
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\Quiz | No errors. |
CodersLab\Lms\Modules\Materials\Domain\Pill\Material | No errors. |