Query Metrics

4 Database Queries
4 Different statements
253.83 ms Query time
0 Invalid entities
0 Cache hits
1 Cache misses
1 Cache puts

Queries

Group similar statements

# Time Info
1 0.72 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.75 ms
SELECT roles FROM fos_user WHERE id = :uid
Parameters:
[
  "uid" => 15
]
3 0.71 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 251.66 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.