Query Metrics
5
Database Queries
4
Different statements
78.08 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 3.13 ms |
SELECT t0_.id AS id_0, t0_.token AS token_1, t0_.app_id AS app_id_2 FROM tokens t0_ WHERE t0_.token = ?
Parameters:
[
"gasddfDAS890DUGguwdgqaudDGFSAD"
]
|
| 2 | 0.55 ms |
SELECT t0_.id AS id_0, t0_.token AS token_1, t0_.app_id AS app_id_2 FROM tokens t0_ WHERE t0_.token = ?
Parameters:
[
"gasddfDAS890DUGguwdgqaudDGFSAD"
]
|
| 3 | 53.20 ms |
SELECT name,plz,landkreis FROM plz_complete where name = :cityexact group by plz order by name,plz COLLATE utf8mb4_german2_ci limit :limit
Parameters:
[ ":cityexact" => "70771 Leinfeld" ":limit" => 50000 ] |
| 4 | 12.34 ms |
SELECT name,plz,landkreis FROM plz_complete where name like :city and name != :name group by landkreis,plz order by name,plz COLLATE utf8mb4_german2_ci limit :limit
Parameters:
[ ":city" => "70771 Leinfeld%" ":limit" => 50000 ":name" => "70771 Leinfeld" ] |
| 5 | 8.86 ms |
SELECT name,plz,landkreis FROM plz_complete where name like :city and name not like :city2 and name != :name group by landkreis,plz order by name,plz COLLATE utf8mb4_german2_ci limit :limit
Parameters:
[ ":city" => "%70771 Leinfeld%" ":city2" => "70771 Leinfeld%" ":limit" => 50000 ":name" => "70771 Leinfeld" ] |
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\Tokens | No errors. |
| App\Entity\Apps | No errors. |