https://map.i42.de/api/data.json

Query Metrics

4 Database Queries
4 Different statements
4.78 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
3.22 ms
(67.30%)
1
"COMMIT"
Parameters:
[]
1.05 ms
(21.91%)
1
SELECT country FROM tracking WHERE device_token = "bdb849df-4184-4f53-a463-6fce29b599a3" AND customer_token = "dsfasdfasdfsdfasdfasdf709asdfasdf70706asdfasdf09707asdfas0df97sd" AND country != "" AND country IS NOT NULL ORDER BY id DESC
Parameters:
[]
0.36 ms
(7.53%)
1
INSERT INTO tracking (device_token, customer_token, device_state, emergency_state, lat, lng, address, country, altitude, accuracy, created_at) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  "bdb849df-4184-4f53-a463-6fce29b599a3"
  "dsfasdfasdfsdfasdfasdf709asdfasdf70706asdfasdf09707asdfas0df97sd"
  0
  1
  49.43443062139
  8.5247576561497
  "Dänischer Tisch 41, 68219 Mannheim-Rheinau, Germany"
  "DE"
  149.931
  87.0
  "2026-06-25 07:07:03"
]
0.16 ms
(3.26%)
1
"START TRANSACTION"
Parameters:
[]

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\Tracking No errors.