POST http://analyzer.panzernews.pl/api/track

Query Metrics

9 Database Queries
7 Different statements
79.34 ms Query time
2 Invalid entities

Grouped Statements

Show all queries

Time Count Info
39.43 ms
(49.70%)
2
"COMMIT"
Parameters:
[]
38.82 ms
(48.92%)
1
SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.first_visit AS first_visit_3, t0.last_visit AS last_visit_4, t0.user_id AS user_id_5 FROM visitor t0 WHERE t0.uuid = ? AND t0.user_id = ? LIMIT 1
Parameters:
[
  b"¸ÃM\x16N*N\x06»"º.\x06W*\x15"
  1
]
0.29 ms
(0.36%)
1
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.uuid AS uuid_5, t0.accept_rules AS accept_rules_6 FROM `user` t0 WHERE t0.uuid = ? LIMIT 1
Parameters:
[
  b"\x12°ÌÖK.°\x7Fÿ‡€ïŠ\x04"
]
0.25 ms
(0.32%)
1
INSERT INTO visitor (uuid, first_visit, last_visit, user_id) VALUES (?, ?, ?, ?)
Parameters:
[
  b"¸ÃM\x16N*N\x06»"º.\x06W*\x15"
  "2024-12-03 18:56:21"
  null
  1
]
0.20 ms
(0.25%)
1
INSERT INTO visitor_action (ACTION, timestamp, visitor_id) VALUES (?, ?, ?)
Parameters:
[
  "page_load"
  "2024-12-03 18:56:21"
  66646
]
0.18 ms
(0.22%)
2
"START TRANSACTION"
Parameters:
[]
0.17 ms
(0.22%)
1
UPDATE visitor SET last_visit = ? WHERE id = ?
Parameters:
[
  "2024-12-03 18:56:21"
  66646
]

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\User No errors.
App\Entity\Visitor
  • The association App\Entity\Visitor#visitorActions refers to the owning side field App\Entity\VisitorAction#visitator which does not exist.
App\Entity\VisitorAction
  • The mappings App\Entity\VisitorAction#visitor and App\Entity\Visitor#visitorActions are inconsistent with each other.