GET https://evalcomp.dataccessor.com/admin/user?role=ROLE_PROFESSOR

Query Metrics

503 Database Queries
5 Different statements
755.30 ms Query time
0 Invalid entities
334 Managed entities

Grouped Statements

Show all queries

Time Count Info
285.62 ms
(37.82%)
167
SELECT t0.id AS id_1, t0.firstname AS firstname_2, t0.lastname AS lastname_3, t0.company AS company_4, t0.user_id AS user_id_5 FROM tutor t0 WHERE t0.user_id = ?
Parameters:
[
  70
]
231.32 ms
(30.63%)
167
SELECT t0.id AS id_1, t0.firstname AS firstname_2, t0.lastname AS lastname_3, t0.user_id AS user_id_4 FROM student t0 WHERE t0.user_id = ?
Parameters:
[
  70
]
224.89 ms
(29.77%)
167
SELECT t0.id AS id_1, t0.firstname AS firstname_2, t0.lastname AS lastname_3, t0.user_id AS user_id_4 FROM professor t0 WHERE t0.user_id = ?
Parameters:
[
  70
]
9.65 ms
(1.28%)
1
SELECT t0.id AS id_1, t0.route_name AS route_name_2, t0.title AS title_3, t0.content AS content_4, t0.enabled AS enabled_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7 FROM page_help t0 WHERE t0.route_name = ? AND t0.enabled = ? LIMIT 1
Parameters:
[
  "admin_user_index"
  1
]
3.81 ms
(0.51%)
1
SELECT u0_.id AS id_0, u0_.email AS email_1, u0_.roles AS roles_2, u0_.password AS password_3, u0_.azure_id AS azure_id_4, u0_.username AS username_5, u0_.firstname AS firstname_6, u0_.lastname AS lastname_7, u0_.department AS department_8, u0_.job_title AS job_title_9, u0_.azure_groups AS azure_groups_10 FROM user u0_ WHERE u0_.roles LIKE ?
Parameters:
[
  "%ROLE_PROFESSOR%"
]

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\User 167
App\Entity\Professor 167

Entities Mapping

Class Mapping errors
App\Entity\User No errors.
App\Entity\Student No errors.
App\Entity\Professor No errors.
App\Entity\Tutor No errors.
App\Entity\PageHelp No errors.