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

Query Metrics

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

Queries

Group similar statements

# Time Info
1 1.05 ms
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:
[]
2 0.16 ms
"START TRANSACTION"
Parameters:
[]
3 0.36 ms
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"
]
4 3.22 ms
"COMMIT"
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.