Symfony Profiler

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

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 = 'dbe6add52318f1527f59dda950cc409f11a61ff33d1324548cb8a74024f9ff58bcb2565d151c1f243f3fde8cb8ed69ca8abb06dab0b18aec2349849ec71c4874' LIMIT 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

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 = 'urs.schnueriger@webtech.ch' LIMIT 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

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 = 165 AND t0.device_id = '108e7c13-f00d-4dec-ba32-ee427de60d45' LIMIT 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

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 = 165 AND t0.device_id = '108e7c13-f00d-4dec-ba32-ee427de60d45' AND t0.is_active = 1 LIMIT 1;

"START TRANSACTION"

"START TRANSACTION";

UPDATE
  device_registrations
SET
  last_activity = ?
WHERE
  id = ?

UPDATE device_registrations SET last_activity = '2026-01-15 11:55:38' WHERE id = 2091;

"COMMIT"

"COMMIT";

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

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 = 'dbe6add52318f1527f59dda950cc409f11a61ff33d1324548cb8a74024f9ff58bcb2565d151c1f243f3fde8cb8ed69ca8abb06dab0b18aec2349849ec71c4874' LIMIT 1;

"START TRANSACTION"

"START TRANSACTION";

DELETE FROM
  refresh_tokens
WHERE
  id = ?

DELETE FROM refresh_tokens WHERE id = 67923;

"COMMIT"

"COMMIT";

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

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 = '44f76bdfd4f3aeabd11548b5d95298d77fa761087296543c5c2b0199f84a640222db2a860b2838d13e54eb3662660554f7592892745e8881c89d771f68474bd3' LIMIT 1;

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO refresh_tokens (refresh_token, username, valid)
VALUES
  (?, ?, ?)

INSERT INTO refresh_tokens (refresh_token, username, valid) VALUES ('44f76bdfd4f3aeabd11548b5d95298d77fa761087296543c5c2b0199f84a640222db2a860b2838d13e54eb3662660554f7592892745e8881c89d771f68474bd3', 'urs.schnueriger@webtech.ch', '2026-01-15 11:57:38');

"COMMIT"

"COMMIT";