https://birth.habitechsolutions.cm/en/marriage/certificate/complete_marriage

Query Metrics

13 Database Queries
4 Different statements
4.38 ms Query time
2 Invalid entities

Queries

Group similar statements

#▲ Time Info
1 0.82 ms
SELECT h0_.id AS id_0, h0_.name AS name_1, h0_.description AS description_2, h0_.update_at AS update_at_3, h0_.phone_number AS phone_number_4, h0_.neighborhood AS neighborhood_5, h0_.municipality_id AS municipality_id_6, h0_.hospital_category_id AS hospital_category_id_7 FROM hospital h0_
Parameters:
[]
2 0.47 ms
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
]
3 0.36 ms
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
]
4 0.33 ms
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
]
5 0.32 ms
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:
[
  98
]
6 0.27 ms
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:
[
  98
]
7 0.25 ms
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:
[
  246
]
8 0.27 ms
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:
[
  246
]
9 0.27 ms
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:
[
  225
]
10 0.23 ms
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:
[
  96
]
11 0.26 ms
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:
[
  96
]
12 0.27 ms
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:
[
  99
]
13 0.25 ms
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:
[
  99
]

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.