Query Metrics
13
Database Queries
4
Different statements
4.38 ms
Query time
2
Invalid entities
Queries
| #▲ | 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 |
|
| App\Entity\Municipality | No errors. |
| App\Entity\HospitalCategory | No errors. |
| App\Entity\Child |
|
| 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. |