Query Metrics
                17
                Database Queries
            
            
                3
                Different statements
            
            
                21.75 ms
                Query time
            
            
                0
                Invalid entities
            
        Queries
| #▲ | Time | Info | 
|---|---|---|
| 1 | 1.57 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 | 10.32 ms | 
                                            SELECT u0_.id AS id_0, u0_.email AS email_1, u0_.password AS password_2, u0_.is_verified AS is_verified_3, u0_.avatarPath AS avatarPath_4, u0_.phoneNumber AS phoneNumber_5, u0_.gender AS gender_6, u0_.birthday AS birthday_7, u0_.birthplace AS birthplace_8, u0_.nationality AS nationality_9, u0_.location AS location_10, u0_.region AS region_11, u0_.department AS department_12, u0_.academicLevel AS academicLevel_13, u0_.numCni AS numCni_14, u0_.status AS status_15, u0_.full_name AS full_name_16, u0_.security_question AS security_question_17, u0_.security_answer AS security_answer_18, u0_.created_at AS created_at_19, u0_.updated_at AS updated_at_20, u0_.image_name AS image_name_21, u0_.domain_id AS domain_id_22 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:  
                                            
                                            
                                                                                            
                                            
                                                                                            
                                            
                                                                                    [
  8
]
                                             | 
                                    
| 3 | 1.12 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.56 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.45 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.91 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.42 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
]
                                             | 
                                    
| 8 | 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:  
                                            
                                            
                                                                                            
                                            
                                                                                            
                                            
                                                                                    [
  5
]
                                             | 
                                    
| 9 | 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:  
                                            
                                            
                                                                                            
                                            
                                                                                            
                                            
                                                                                    [
  13
]
                                             | 
                                    
| 10 | 0.44 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.41 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.45 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
]
                                             | 
                                    
| 13 | 1.02 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
]
                                             | 
                                    
| 14 | 0.66 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
]
                                             | 
                                    
| 15 | 0.79 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
]
                                             | 
                                    
| 16 | 0.58 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.82 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. |