Query Metrics
4
Database Queries
2
Different statements
21.73 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 5.22 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.country AS country_3, t0.lat AS lat_4, t0.lon AS lon_5, t0.geoname_id AS geoname_id_6, t0.population AS population_7, t8.id AS id_9, t8.population AS population_10, t8.stop_id AS stop_id_11 FROM stop t0 LEFT JOIN stop_info t8 ON t8.stop_id = t0.id WHERE t0.id = ?
Parameters:
[
10
]
|
| 2 | 5.51 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.lang AS lang_3, t0.stop_id AS stop_id_4 FROM stop_lang t0 WHERE t0.stop_id = ? AND t0.lang = ? LIMIT 1
Parameters:
[ 10 "fr" ] |
| 3 | 5.26 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.country AS country_3, t0.lat AS lat_4, t0.lon AS lon_5, t0.geoname_id AS geoname_id_6, t0.population AS population_7, t8.id AS id_9, t8.population AS population_10, t8.stop_id AS stop_id_11 FROM stop t0 LEFT JOIN stop_info t8 ON t8.stop_id = t0.id WHERE t0.id = ?
Parameters:
[
315
]
|
| 4 | 5.75 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.lang AS lang_3, t0.stop_id AS stop_id_4 FROM stop_lang t0 WHERE t0.stop_id = ? AND t0.lang = ? LIMIT 1
Parameters:
[ 315 "fr" ] |
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\Route | No errors. |
| App\Entity\Stop | No errors. |
| App\Entity\StopInfo | No errors. |
| App\Entity\PictureStop | No errors. |
| App\Entity\StopLang | No errors. |
| App\Entity\StopAlias | No errors. |
| App\Entity\Block | No errors. |