https://api.animate.de/api/gasddfDAS890DUGguwdgqaudDGFSAD/cityplz/Bonn/53111/53229

Query Metrics

3 Database Queries
2 Different statements
20.91 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 1.64 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.66 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 18.62 ms
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" => "Bonn"
  ":city2" => "Bonn %"
  ":city3" => "Bonn-%"
  ":plzmin" => "53111"
  ":plzmax" => "53229"
]

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.