Query Metrics
5
Database Queries
4
Different statements
52.73 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
31.46 ms (59.67%) |
1 |
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 ] |
|
10.40 ms (19.73%) |
1 |
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" ] |
|
7.92 ms (15.03%) |
1 |
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" ] |
|
2.94 ms (5.57%) |
2 |
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"
]
|
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. |