Query Metrics
5
Database Queries
4
Different statements
78.08 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
53.20 ms (68.14%) |
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" => "70771 Leinfeld" ":limit" => 50000 ] |
|
12.34 ms (15.81%) |
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" => "70771 Leinfeld%" ":limit" => 50000 ":name" => "70771 Leinfeld" ] |
|
8.86 ms (11.35%) |
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" => "%70771 Leinfeld%" ":city2" => "70771 Leinfeld%" ":limit" => 50000 ":name" => "70771 Leinfeld" ] |
|
3.67 ms (4.71%) |
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. |