Query Metrics
17
Database Queries
3
Different statements
10.16 ms
Query time
0
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
5.02 ms (49.45%) |
15 |
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.52 ms (44.52%) |
1 |
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
]
|
0.61 ms (6.03%) |
1 |
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
]
|
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. |