Query Metrics
2
Database Queries
2
Different statements
1.95 ms
Query time
1
Invalid entities
2
Managed entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 1.13 ms |
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:
[
"06"
]
|
||||||||||||||||||||||||||
| 2 | 0.82 ms |
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:
[ 6 "imperia-oneglia" "imperia-oneglia" ]
|
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. |
| App\Entity\Location | No errors. |
| App\Entity\ZipCode | No errors. |
| App\Entity\RegionUnofficial |
|
| App\Entity\User | No errors. |
| App\Entity\RegionUnofficialMarket | No errors. |
| App\Entity\Category | No errors. |
| Vich\UploaderBundle\Entity\File | No errors. |