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

Query Metrics

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

Queries

Group similar statements

# Time Info
1 7.76 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.37 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.434827909559
  8.5250451955882
  "Neuhofer Str. 28-30, 68219 Mannheim, Germany"
  "DE"
  149.6228
  83.0
  "2026-06-25 05:43:20"
]
4 21.04 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.