Query Metrics
5
Database Queries
4
Different statements
52.73 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 1.70 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 | 1.24 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 | 31.46 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" => "Erfurt" ":limit" => 50000 ] |
| 4 | 7.92 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" => "Erfurt%" ":limit" => 50000 ":name" => "Erfurt" ] |
| 5 | 10.40 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" => "%Erfurt%" ":city2" => "Erfurt%" ":limit" => 50000 ":name" => "Erfurt" ] |
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. |