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

Query Metrics

16 Database Queries
3 Different statements
12.02 ms Query time
6 Invalid entities

Queries

Group similar statements

# Time Info
1 0.67 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 7.02 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_.created_at AS created_at_29, u0_.updated_at AS updated_at_30, u0_.image_name AS image_name_31, u0_.domain_id AS domain_id_32 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:
[
  6
]
3 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:
[
  2
]
4 0.43 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.37 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
]
6 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:
[
  1
]
7 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
]
8 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:
[
  4
]
9 0.23 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
]
10 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:
[
  3
]
11 0.21 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
]
12 0.21 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
]
13 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:
[
  10
]
14 0.23 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
]
15 0.21 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.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:
[
  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
  • The field App\Entity\SchoolYear#paymentPlan is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\PaymentPlan#schoolYear does not contain the required 'inversedBy="paymentPlan"' attribute.
App\Entity\PaymentPlan
  • The association App\Entity\PaymentPlan#payments refers to the owning side field App\Entity\Payment#paymentPlan which does not exist.
  • The field App\Entity\PaymentPlan#installments is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Installment#paymentPlan does not contain the required 'inversedBy="installments"' attribute.
App\Entity\Quater No errors.
App\Entity\Subscription No errors.
App\Entity\User
  • The association App\Entity\User#fullTeacherOf refers to the owning side field App\Entity\ClassRoom#fullTeacher which does not exist.
  • The field App\Entity\User#attributions is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Attribution#teacher does not contain the required 'inversedBy="attributions"' attribute.
App\Entity\Attribution No errors.
App\Entity\Domain
  • The association App\Entity\Domain#headOfDepartment refers to the inverse side field App\Entity\User#headOfDepartementOf which does not exist.
App\Entity\Email No errors.
App\Entity\ClassRoom
  • The mappings App\Entity\ClassRoom#mainTeachers and App\Entity\MainTeacher#classRoom are inconsistent with each other.
App\Entity\Course
  • The field App\Entity\Course#attributions is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Attribution#course does not contain the required 'inversedBy="attributions"' attribute.