Query Metrics
2
Database Queries
2
Different statements
1.98 ms
Query time
0
Invalid entities
2
Managed entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
1.08 ms (54.72%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.slug AS slug_4, t0.de_nom AS de_nom_5, t0.main_cities AS main_cities_6, t0.lat AS lat_7, t0.lng AS lng_8, t0.region_id AS region_id_9 FROM department t0 WHERE t0.code = ? LIMIT 1
Parameters:
[
"12"
]
|
||||||||||||||||||||||||||
|
0.90 ms (45.28%) |
1 |
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.slug AS slug_2, c0_.legacy_department AS legacy_department_3, c0_.latitude AS latitude_4, c0_.longitude AS longitude_5, c0_.website AS website_6, c0_.departement_id AS departement_id_7 FROM city c0_ WHERE c0_.departement_id = ? AND ((LOWER(c0_.slug) = ?) OR (LOWER(c0_.name) = ?)) LIMIT 1
Parameters:
[ 12 "saint-geniez-d-olt" "saint-geniez-d-olt" ]
|
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.
Managed Entities
default entity manager
| Class | Amount of managed objects |
|---|---|
| App\Entity\Department | 1 |
| App\Entity\Region | 1 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\Department | No errors. |
| App\Entity\Region | No errors. |
| App\Entity\City | No errors. |
| App\Entity\Market | No errors. |