Query Metrics
3
Database Queries
2
Different statements
24.75 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
22.38 ms (90.42%) |
1 |
SELECT ST_AsGeoJSON(geom) geom,plz.plz FROM plz_complete complete left join plz on complete.plz = plz.plz where (complete.name = :city or complete.name like :city2 or complete.name like :city3) and (cast(plz.plz as UNSIGNED)>=:plzmin and cast(plz.plz as UNSIGNED)<=:plzmax) COLLATE utf8mb4_german2_ci;
Parameters:
[ ":city" => "Bad Homburg vor der Höhe" ":city2" => "Bad Homburg vor der Höhe %" ":city3" => "Bad Homburg vor der Höhe-%" ":plzmin" => "61348" ":plzmax" => "61353" ] |
|
2.37 ms (9.58%) |
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. |