Query Metrics
15
Database Queries
15
Different statements
3.01 ms
Query time
0
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
0.53 ms (17.61%) |
1 |
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.number = ? LIMIT 2
Parameters:
[
"130406197404192725"
]
|
0.32 ms (10.54%) |
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:
[
"S1455"
]
|
0.29 ms (9.65%) |
1 |
SELECT t0_.id AS id_0, t0_.name AS name_1 FROM title t0_
Parameters:
[] |
0.27 ms (8.85%) |
1 |
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:
[
697
]
|
0.19 ms (6.16%) |
1 |
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.valid AS valid_2 FROM college c0_
Parameters:
[] |
0.17 ms (5.69%) |
1 |
SELECT q0_.id AS id_0, q0_.name AS name_1 FROM qualification q0_
Parameters:
[] |
0.15 ms (4.86%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2 FROM qualification t0 WHERE t0.id = ?
Parameters:
[
1
]
|
0.14 ms (4.79%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2 FROM title t0 WHERE t0.id = ?
Parameters:
[
1
]
|
0.14 ms (4.73%) |
1 |
SELECT t0_.id AS id_0, t0_.name AS name_1 FROM title t0_ WHERE t0_.id IN (?)
Parameters:
[
"1"
]
|
0.14 ms (4.73%) |
1 |
SELECT d0_.id AS id_0, d0_.name AS name_1 FROM degree d0_
Parameters:
[] |
0.14 ms (4.70%) |
1 |
SELECT d0_.id AS id_0, d0_.name AS name_1 FROM degree d0_ WHERE d0_.id IN (?)
Parameters:
[
"1"
]
|
0.14 ms (4.63%) |
1 |
SELECT q0_.id AS id_0, q0_.name AS name_1 FROM qualification q0_ WHERE q0_.id IN (?)
Parameters:
[
"1"
]
|
0.14 ms (4.59%) |
1 |
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.valid AS valid_2 FROM college c0_ WHERE c0_.id IN (?)
Parameters:
[
"1"
]
|
0.13 ms (4.36%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.valid AS valid_3 FROM college t0 WHERE t0.id = ?
Parameters:
[
1
]
|
0.12 ms (4.13%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2 FROM degree t0 WHERE t0.id = ?
Parameters:
[
1
]
|
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. |