Query Metrics
17
Database Queries
3
Different statements
10.16 ms
Query time
0
Invalid entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 0.61 ms |
SELECT t0.id AS id_1, t0.registration_deadline AS registration_deadline_2, t0.rate AS rate_3, t0.code AS code_4, t0.wording AS wording_5, t0.start_date AS start_date_6, t0.end_date AS end_date_7, t0.activated AS activated_8, t9.id AS id_10, t9.weight AS weight_11, t9.school_year_id AS school_year_id_12 FROM school_year t0 LEFT JOIN payment_plan t9 ON t9.school_year_id = t0.id WHERE t0.activated = ? LIMIT 1
Parameters:
[
1
]
|
2 | 4.52 ms |
SELECT u0_.id AS id_0, u0_.email AS email_1, u0_.github_id AS github_id_2, u0_.github_access_token AS github_access_token_3, u0_.facebook_id AS facebook_id_4, u0_.facebook_access_token AS facebook_access_token_5, u0_.google_id AS google_id_6, u0_.google_access_token AS google_access_token_7, u0_.linkedin_id AS linkedin_id_8, u0_.linkedin_access_token AS linkedin_access_token_9, u0_.twitter_id AS twitter_id_10, u0_.twitter_access_token AS twitter_access_token_11, u0_.yahoo_id AS yahoo_id_12, u0_.yahoo_access_token AS yahoo_access_token_13, u0_.password AS password_14, u0_.is_verified AS is_verified_15, u0_.avatarPath AS avatarPath_16, u0_.phoneNumber AS phoneNumber_17, u0_.gender AS gender_18, u0_.birthday AS birthday_19, u0_.birthplace AS birthplace_20, u0_.nationality AS nationality_21, u0_.location AS location_22, u0_.region AS region_23, u0_.department AS department_24, u0_.academicLevel AS academicLevel_25, u0_.numCni AS numCni_26, u0_.status AS status_27, u0_.full_name AS full_name_28, u0_.security_question AS security_question_29, u0_.security_answer AS security_answer_30, u0_.created_at AS created_at_31, u0_.updated_at AS updated_at_32, u0_.image_name AS image_name_33, u0_.domain_id AS domain_id_34 FROM user u0_ LEFT JOIN attribution a1_ ON u0_.id = a1_.teacher_id LEFT JOIN school_year s2_ ON a1_.year_id = s2_.id WHERE s2_.id = ? ORDER BY u0_.full_name ASC
Parameters:
[
7
]
|
3 | 0.61 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.headOfDepartmentId AS headOfDepartmentId_3 FROM domain t0 WHERE t0.id = ?
Parameters:
[
2
]
|
4 | 0.20 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.headOfDepartmentId AS headOfDepartmentId_3 FROM domain t0 WHERE t0.id = ?
Parameters:
[
14
]
|
5 | 0.24 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.headOfDepartmentId AS headOfDepartmentId_3 FROM domain t0 WHERE t0.id = ?
Parameters:
[
12
]
|
6 | 0.74 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.headOfDepartmentId AS headOfDepartmentId_3 FROM domain t0 WHERE t0.id = ?
Parameters:
[
8
]
|
7 | 0.28 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.headOfDepartmentId AS headOfDepartmentId_3 FROM domain t0 WHERE t0.id = ?
Parameters:
[
1
]
|
8 | 0.63 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.headOfDepartmentId AS headOfDepartmentId_3 FROM domain t0 WHERE t0.id = ?
Parameters:
[
6
]
|
9 | 0.30 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.headOfDepartmentId AS headOfDepartmentId_3 FROM domain t0 WHERE t0.id = ?
Parameters:
[
13
]
|
10 | 0.29 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.headOfDepartmentId AS headOfDepartmentId_3 FROM domain t0 WHERE t0.id = ?
Parameters:
[
4
]
|
11 | 0.27 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.headOfDepartmentId AS headOfDepartmentId_3 FROM domain t0 WHERE t0.id = ?
Parameters:
[
9
]
|
12 | 0.33 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.headOfDepartmentId AS headOfDepartmentId_3 FROM domain t0 WHERE t0.id = ?
Parameters:
[
5
]
|
13 | 0.25 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.headOfDepartmentId AS headOfDepartmentId_3 FROM domain t0 WHERE t0.id = ?
Parameters:
[
10
]
|
14 | 0.27 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.headOfDepartmentId AS headOfDepartmentId_3 FROM domain t0 WHERE t0.id = ?
Parameters:
[
3
]
|
15 | 0.22 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.headOfDepartmentId AS headOfDepartmentId_3 FROM domain t0 WHERE t0.id = ?
Parameters:
[
16
]
|
16 | 0.22 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.headOfDepartmentId AS headOfDepartmentId_3 FROM domain t0 WHERE t0.id = ?
Parameters:
[
7
]
|
17 | 0.17 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.headOfDepartmentId AS headOfDepartmentId_3 FROM domain t0 WHERE t0.id = ?
Parameters:
[
11
]
|
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\SchoolYear | No errors. |
App\Entity\PaymentPlan | No errors. |
App\Entity\Quater | No errors. |
App\Entity\Subscription | No errors. |
App\Entity\User | No errors. |
App\Entity\Attribution | No errors. |
App\Entity\Domain | No errors. |
App\Entity\Email | No errors. |
App\Entity\MainTeacher | No errors. |
App\Entity\Course | No errors. |