0.74 ms (27.70%)
|
1 |
SELECT t0.id AS id_1, t0.provider AS provider_2, t0.provider_user_id AS provider_user_id_3, t0.created_at AS created_at_4, t0.user_id AS user_id_5 FROM oauth_identity t0 WHERE t0.provider = ? AND t0.provider_user_id = ? LIMIT 1
Parameters: [
"github"
"3796847"
]
SELECT t0.id AS id_1, t0.provider AS provider_2, t0.provider_user_id AS provider_user_id_3, t0.created_at AS created_at_4, t0.user_id AS user_id_5 FROM oauth_identity t0 WHERE t0.provider = 'github' AND t0.provider_user_id = '3796847' LIMIT 1;
|
0.50 ms (18.54%)
|
1 |
SELECT u0_.id AS id_0, u0_.email AS email_1, u0_.name AS name_2, u0_.roles AS roles_3, u0_.password AS password_4, u0_.active AS active_5, u0_.channels_enabled AS channels_enabled_6, u0_.totp_secret AS totp_secret_7, u0_.is_totp_enabled AS is_totp_enabled_8, u0_.recovery_codes AS recovery_codes_9, u0_.created_at AS created_at_10, u0_.password_reset_token AS password_reset_token_11, u0_.password_reset_expires_at AS password_reset_expires_at_12, u0_.password_reset_requested_at AS password_reset_requested_at_13, u0_.parent_id AS parent_id_14 FROM `user` u0_ WHERE u0_.parent_id IS NULL AND u0_.active = 1 AND u0_.roles LIKE ? LIMIT 1
Parameters: [
"%"ROLE_ADMIN"%"
]
SELECT u0_.id AS id_0, u0_.email AS email_1, u0_.name AS name_2, u0_.roles AS roles_3, u0_.password AS password_4, u0_.active AS active_5, u0_.channels_enabled AS channels_enabled_6, u0_.totp_secret AS totp_secret_7, u0_.is_totp_enabled AS is_totp_enabled_8, u0_.recovery_codes AS recovery_codes_9, u0_.created_at AS created_at_10, u0_.password_reset_token AS password_reset_token_11, u0_.password_reset_expires_at AS password_reset_expires_at_12, u0_.password_reset_requested_at AS password_reset_requested_at_13, u0_.parent_id AS parent_id_14 FROM `user` u0_ WHERE u0_.parent_id IS NULL AND u0_.active = 1 AND u0_.roles LIKE '%\"ROLE_ADMIN\"%' LIMIT 1;
|
0.41 ms (15.38%)
|
1 |
INSERT INTO oauth_identity (provider, provider_user_id, created_at, user_id) VALUES (?, ?, ?, ?)
Parameters: [
"github"
"3796847"
"2026-03-25 19:15:59"
6
]
INSERT INTO oauth_identity (provider, provider_user_id, created_at, user_id) VALUES ('github', '3796847', '2026-03-25 19:15:59', 6);
|
0.35 ms (12.95%)
|
1 |
SELECT t0.id AS id_1, t0.email AS email_2, t0.name AS name_3, t0.roles AS roles_4, t0.password AS password_5, t0.active AS active_6, t0.channels_enabled AS channels_enabled_7, t0.totp_secret AS totp_secret_8, t0.is_totp_enabled AS is_totp_enabled_9, t0.recovery_codes AS recovery_codes_10, t0.created_at AS created_at_11, t0.password_reset_token AS password_reset_token_12, t0.password_reset_expires_at AS password_reset_expires_at_13, t0.password_reset_requested_at AS password_reset_requested_at_14, t0.parent_id AS parent_id_15 FROM `user` t0 WHERE t0.email = ? LIMIT 1
Parameters: [
"moshking666@gmail.com"
]
SELECT t0.id AS id_1, t0.email AS email_2, t0.name AS name_3, t0.roles AS roles_4, t0.password AS password_5, t0.active AS active_6, t0.channels_enabled AS channels_enabled_7, t0.totp_secret AS totp_secret_8, t0.is_totp_enabled AS is_totp_enabled_9, t0.recovery_codes AS recovery_codes_10, t0.created_at AS created_at_11, t0.password_reset_token AS password_reset_token_12, t0.password_reset_expires_at AS password_reset_expires_at_13, t0.password_reset_requested_at AS password_reset_requested_at_14, t0.parent_id AS parent_id_15 FROM `user` t0 WHERE t0.email = 'moshking666@gmail.com' LIMIT 1;
|
0.32 ms (12.10%)
|
1 |
INSERT INTO `user` (email, name, roles, password, active, channels_enabled, totp_secret, is_totp_enabled, recovery_codes, created_at, password_reset_token, password_reset_expires_at, password_reset_requested_at, parent_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters: [
"moshking666@gmail.com"
"luebke"
"["ROLE_USER"]"
null
1
0
null
0
null
"2026-03-25 19:15:58"
null
null
null
1
]
INSERT INTO `user` (email, name, roles, password, active, channels_enabled, totp_secret, is_totp_enabled, recovery_codes, created_at, password_reset_token, password_reset_expires_at, password_reset_requested_at, parent_id) VALUES ('moshking666@gmail.com', 'luebke', '[\"ROLE_USER\"]', NULL, 1, 0, NULL, 0, NULL, '2026-03-25 19:15:58', NULL, NULL, NULL, 1);
|
0.18 ms (6.70%)
|
1 |
"START TRANSACTION"
"START TRANSACTION";
|
0.18 ms (6.63%)
|
1 |
"COMMIT"
|