http://www.urnerwochenblatt.hostify2.webtech.ch/api/token/refresh Return to referer URL

Query Metrics

15 Database Queries
9 Different statements
17.79 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
11.97 ms
(67.27%)
3
"COMMIT"
Parameters:
[]
2.34 ms
(13.18%)
3
SELECT t0.refresh_token AS refresh_token_1, t0.username AS username_2, t0.valid AS valid_3, t0.id AS id_4 FROM refresh_tokens t0 WHERE t0.refresh_token = ? LIMIT 1
Parameters:
[
  "dbe6add52318f1527f59dda950cc409f11a61ff33d1324548cb8a74024f9ff58bcb2565d151c1f243f3fde8cb8ed69ca8abb06dab0b18aec2349849ec71c4874"
]
0.58 ms
(3.24%)
3
"START TRANSACTION"
Parameters:
[]
0.54 ms
(3.01%)
1
UPDATE device_registrations SET last_activity = ? WHERE id = ?
Parameters:
[
  "2026-01-15 11:55:38"
  2091
]
0.50 ms
(2.82%)
1
INSERT INTO refresh_tokens (refresh_token, username, valid) VALUES (?, ?, ?)
Parameters:
[
  "44f76bdfd4f3aeabd11548b5d95298d77fa761087296543c5c2b0199f84a640222db2a860b2838d13e54eb3662660554f7592892745e8881c89d771f68474bd3"
  "urs.schnueriger@webtech.ch"
  "2026-01-15 11:57:38"
]
0.50 ms
(2.81%)
1
SELECT t0.id AS id_1, t0.device_id AS device_id_2, t0.device_name AS device_name_3, t0.ip_address AS ip_address_4, t0.user_agent AS user_agent_5, t0.first_login AS first_login_6, t0.last_activity AS last_activity_7, t0.is_active AS is_active_8, t0.refresh_token AS refresh_token_9, t0.logout_reason AS logout_reason_10, t0.logout_at AS logout_at_11, t0.user_id AS user_id_12 FROM device_registrations t0 WHERE t0.user_id = ? AND t0.device_id = ? AND t0.is_active = ? LIMIT 1
Parameters:
[
  165
  "108e7c13-f00d-4dec-ba32-ee427de60d45"
  1
]
0.49 ms
(2.75%)
1
SELECT t0.id AS id_1, t0.username AS username_2, t0.is_active AS is_active_3, t0.created_at AS created_at_4, t0.password AS password_5, t0.last_password_change AS last_password_change_6 FROM abonnent t0 WHERE t0.username = ? LIMIT 1
Parameters:
[
  "urs.schnueriger@webtech.ch"
]
0.45 ms
(2.52%)
1
SELECT t0.id AS id_1, t0.device_id AS device_id_2, t0.device_name AS device_name_3, t0.ip_address AS ip_address_4, t0.user_agent AS user_agent_5, t0.first_login AS first_login_6, t0.last_activity AS last_activity_7, t0.is_active AS is_active_8, t0.refresh_token AS refresh_token_9, t0.logout_reason AS logout_reason_10, t0.logout_at AS logout_at_11, t0.user_id AS user_id_12 FROM device_registrations t0 WHERE t0.user_id = ? AND t0.device_id = ? LIMIT 1
Parameters:
[
  165
  "108e7c13-f00d-4dec-ba32-ee427de60d45"
]
0.43 ms
(2.40%)
1
DELETE FROM refresh_tokens WHERE id = ?
Parameters:
[
  67923
]

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.