Query Metrics

3 Database Queries
3 Different statements
9.48 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
8.90 ms
(93.86%)
1
SELECT t0.project_code AS project_code_1, t0.category_name AS category_name_2, t0.level_name AS level_name_3, t0.rank_name AS rank_name_4, t0.user_name AS user_name_5, t0.year_name AS year_name_6, t0.college_name AS college_name_7, t0.property_name AS property_name_8, t0.group_ AS group__9, t0.sort AS sort_10, t0.id AS id_11, t0.name AS name_12, t0.review_batch_id AS review_batch_id_13, t0.project_id AS project_id_14 FROM review t0 WHERE t0.review_batch_id = ?
Parameters:
[
  25
]
0.29 ms
(3.09%)
1
SELECT t0.current AS current_1, t0.id AS id_2, t0.name AS name_3 FROM review_batch t0 WHERE t0.id = ?
Parameters:
[
  "25"
]
0.29 ms
(3.05%)
1
SELECT t0.role AS role_1, t0.name AS name_2, t0.id AS id_3, t0.username AS username_4, t0.admin_college_id AS admin_college_id_5, t0.user_info_id AS user_info_id_6 FROM users t0 WHERE t0.username = ? LIMIT 1
Parameters:
[
  "05824"
]

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.

Entities Mapping

Class Mapping errors
App\Entity\User No errors.
App\Entity\College No errors.
App\Entity\UserInfo No errors.
App\Entity\Review No errors.
App\Entity\ReviewBatch No errors.
App\Entity\Project No errors.
App\Entity\Score No errors.