http://pms.cmet.ustc.edu.cn/applicant/user/info

Query Metrics

10 Database Queries
10 Different statements
1.72 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 0.33 ms
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:
[
  "11286"
]
2 0.24 ms
SELECT t0.number AS number_1, t0.gender AS gender_2, t0.major AS major_3, t0.phone AS phone_4, t0.mobile AS mobile_5, t0.email AS email_6, t0.address AS address_7, t0.zipcode AS zipcode_8, t0.id AS id_9, t0.name AS name_10, t0.subject_id AS subject_id_11, t0.title_id AS title_id_12, t0.qualification_id AS qualification_id_13, t0.degree_id AS degree_id_14, t0.college_id AS college_id_15 FROM user_info t0 WHERE t0.id = ?
Parameters:
[
  505
]
3 0.14 ms
SELECT t0.id AS id_1, t0.name AS name_2 FROM title t0 WHERE t0.id = ?
Parameters:
[
  17
]
4 0.13 ms
SELECT t0.id AS id_1, t0.name AS name_2 FROM qualification t0 WHERE t0.id = ?
Parameters:
[
  1
]
5 0.12 ms
SELECT t0.id AS id_1, t0.name AS name_2 FROM degree t0 WHERE t0.id = ?
Parameters:
[
  1
]
6 0.14 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.valid AS valid_3 FROM college t0 WHERE t0.id = ?
Parameters:
[
  29
]
7 0.17 ms
SELECT t0_.id AS id_0, t0_.name AS name_1 FROM title t0_
Parameters:
[]
8 0.14 ms
SELECT q0_.id AS id_0, q0_.name AS name_1 FROM qualification q0_
Parameters:
[]
9 0.13 ms
SELECT d0_.id AS id_0, d0_.name AS name_1 FROM degree d0_
Parameters:
[]
10 0.17 ms
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.valid AS valid_2 FROM college c0_
Parameters:
[]

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\Title No errors.
App\Entity\Qualification No errors.
App\Entity\Degree No errors.
App\Entity\Subject No errors.