Query Metrics
3
Database Queries
2
Different statements
5.46 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 2.95 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM sector t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
"perpignan"
]
|
| 2 | 1.79 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.address AS address_4, t0.lat AS lat_5, t0.lng AS lng_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.secteur_id AS secteur_id_9, t10.id AS id_11, t10.name AS name_12, t10.slug AS slug_13, t0.city_id AS city_id_14, t15.id AS id_16, t15.name AS name_17, t15.slug AS slug_18, t15.zipcode AS zipcode_19 FROM emplacement t0 INNER JOIN sector t10 ON t0.secteur_id = t10.id INNER JOIN city t15 ON t0.city_id = t15.id WHERE t0.secteur_id = ?
Parameters:
[
4
]
|
| 3 | 0.72 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.address AS address_4, t0.lat AS lat_5, t0.lng AS lng_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.secteur_id AS secteur_id_9, t10.id AS id_11, t10.name AS name_12, t10.slug AS slug_13, t0.city_id AS city_id_14, t15.id AS id_16, t15.name AS name_17, t15.slug AS slug_18, t15.zipcode AS zipcode_19 FROM emplacement t0 INNER JOIN sector t10 ON t0.secteur_id = t10.id INNER JOIN city t15 ON t0.city_id = t15.id WHERE t0.secteur_id = ?
Parameters:
[
4
]
|
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\Sector | No errors. |
| App\Entity\Emplacement | No errors. |
| App\Entity\City | No errors. |
| App\Entity\Customer | No errors. |