Query Metrics
4
Database Queries
4
Different statements
2.51 ms
Query time
0
Invalid entities
Queries
#▲ | 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. |