https://birth.habitechsolutions.cm/hospital/

Query Metrics

15 Database Queries
5 Different statements
8.34 ms Query time
2 Invalid entities

Grouped Statements

Show all queries

Time▼ Count Info
2.15 ms
(25.76%)
2
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.update_at AS update_at_4, t0.department_id AS department_id_5 FROM city t0 WHERE t0.id = ?
Parameters:
[
  91
]
2.14 ms
(25.67%)
5
SELECT t0.id AS id_1, t0.name AS name_2, t0.location AS location_3, t0.updade_at AS updade_at_4, t0.subdivision_id AS subdivision_id_5 FROM municipality t0 WHERE t0.id = ?
Parameters:
[
  100
]
1.79 ms
(21.52%)
5
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.update_at AS update_at_4, t0.city_id AS city_id_5, t0.municipality_id AS municipality_id_6 FROM subdivision t0 WHERE t0.id = ?
Parameters:
[
  100
]
1.18 ms
(14.14%)
2
SELECT t0.id AS id_1, t0.wording AS wording_2, t0.description AS description_3, t0.update_at AS update_at_4 FROM hospital_category t0 WHERE t0.id = ?
Parameters:
[
  3
]
1.08 ms
(12.91%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.update_at AS update_at_4, t0.phone_number AS phone_number_5, t0.neighborhood AS neighborhood_6, t0.municipality_id AS municipality_id_7, t0.hospital_category_id AS hospital_category_id_8 FROM hospital t0
Parameters:
[]

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\Hospital
  • The mappings App\Entity\Hospital#children and App\Entity\Child#hospital are inconsistent with each other.
App\Entity\Municipality No errors.
App\Entity\HospitalCategory No errors.
App\Entity\Child
  • The association App\Entity\Child#hospital refers to the inverse side field App\Entity\Hospital#Children which does not exist.
App\Entity\User No errors.
App\Entity\DeathCertificate No errors.
App\Entity\Subdivision No errors.
App\Entity\City No errors.
App\Entity\Department No errors.