http://isbbethesda.com/index.php/teachers

Query Metrics

17 Database Queries
3 Different statements
8.36 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 0.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 3.77 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:
[
  7
]
3 0.57 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.46 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.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:
[
  8
]
7 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:
[
  1
]
8 0.55 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.32 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.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:
[
  4
]
11 0.16 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.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:
[
  5
]
13 0.19 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.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:
[
  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.19 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.14 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.