Query Metrics
4
Database Queries
4
Different statements
257.46 ms
Query time
0
Invalid entities
0
Cache hits
1
Cache misses
1
Cache puts
Grouped Statements
Time▼ | Count | Info |
---|---|---|
255.26 ms (99.14%) |
1 |
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" => "d365ceb5-e044-453f-b34c-265d15984014" "uid" => 15 ] |
0.91 ms (0.35%) |
1 |
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" => "d365ceb5-e044-453f-b34c-265d15984014" ] |
0.73 ms (0.28%) |
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.id = ? LIMIT 1
Parameters:
[
15
]
|
0.56 ms (0.22%) |
1 |
SELECT roles FROM fos_user WHERE id = :uid
Parameters:
[ "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. |