http://isbbethesda.com/index.php/rooms?page=9

Query Metrics

6 Database Queries
6 Different statements
4.72 ms Query time
7 Invalid entities

Queries

Group similar statements

# Time Info
1 0.77 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 0.56 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.id = ? LIMIT 1
Parameters:
[
  5
]
3 0.62 ms
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.teacher_id AS teacher_id_4, t0.class_room_id AS class_room_id_5, t0.school_year_id AS school_year_id_6 FROM main_teacher t0 WHERE t0.school_year_id = ?
Parameters:
[
  5
]
4 0.45 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.apc AS apc_3, t0.level_id AS level_id_4 FROM class_room t0
Parameters:
[]
5 1.64 ms
SELECT s0_.id AS id_0, s0_.officialExamResult AS officialExamResult_1, s0_.finance_holder AS finance_holder_2, s0_.created_at AS created_at_3, s0_.updated_at AS updated_at_4, s0_.student_id AS student_id_5, s0_.class_room_id AS class_room_id_6, s0_.school_year_id AS school_year_id_7 FROM subscription s0_ LEFT JOIN school_year s1_ ON s0_.school_year_id = s1_.id WHERE s1_.id = ? ORDER BY s0_.class_room_id ASC
Parameters:
[
  5
]
6 0.67 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.room_id AS room_id_4 FROM module t0 WHERE t0.room_id = ?
Parameters:
[
  26
]

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\MainTeacher
  • The association App\Entity\MainTeacher#teacher refers to the inverse side field App\Entity\User#mainTeachers which does not exist.
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\ClassRoom
  • The mappings App\Entity\ClassRoom#mainTeachers and App\Entity\MainTeacher#classRoom are inconsistent with each other.
App\Entity\Level No errors.
App\Entity\Module No errors.
App\Entity\AbscenceSheet No errors.
App\Entity\Student
  • The field App\Entity\Student#payments is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Payment#student does not contain the required 'inversedBy="payments"' attribute.
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.