Query Metrics

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

Queries

Group similar statements

# Time Info
1 1.30 ms
SELECT t0.id AS id_1, t0.last_visited_at AS last_visited_at_2, t0.visits AS visits_3, t0.route AS route_4, t0.url AS url_5, t0.referrer AS referrer_6, t0.ip AS ip_7, t0.os AS os_8, t0.browser AS browser_9, t0.country AS country_10, t0.city AS city_11, t0.user_id AS user_id_12 FROM visitor t0 WHERE t0.ip = ? AND t0.route = ? LIMIT 1
Parameters:
[
  "77.77.75.123"
  "addressqr"
]
2 0.10 ms
"START TRANSACTION"
Parameters:
[]
3 0.30 ms
INSERT INTO visitor (last_visited_at, visits, route, url, referrer, ip, os, browser, country, city, user_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  "2025-09-06 17:58:15"
  1
  "addressqr"
  "https://www.aperove.com/papi/wallet/addressqr?address=0x953939a984F095f1470ac04Be514124DE8459b2A&logo=1&margin=8&size=512&theme=light"
  null
  "77.77.75.123"
  "Unknown OS"
  "Unknown Browser"
  "Unknown Country"
  "Unknown City"
  null
]
4 0.80 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\Stats\Visitor No errors.
App\Entity\User\User No errors.