| 1 |
30.60 ms |
SELECT u0_.id AS id_0, u0_.uuid AS uuid_1, u0_.email AS email_2, u0_.roles AS roles_3, u0_.password AS password_4, u0_.nick AS nick_5, u0_.is_active AS is_active_6, u0_.is_guest AS is_guest_7, u0_.first_name AS first_name_8, u0_.last_name AS last_name_9, u0_.say_hello_email_enabled AS say_hello_email_enabled_10, u0_.last_password_update AS last_password_update_11, u0_.agree_registration_clause AS agree_registration_clause_12, u0_.token AS token_13, u0_.email_validated AS email_validated_14, u0_.email_validation_token AS email_validation_token_15, u0_.subtitle AS subtitle_16, u0_.allow_change_password AS allow_change_password_17, u0_.allow_edit_profile AS allow_edit_profile_18, u0_.rpm_avatar_url AS rpm_avatar_url_19, u0_.external_id AS external_id_20, u0_.created_at AS created_at_21, u0_.updated_at AS updated_at_22, u0_.registration_origin_id AS registration_origin_id_23 FROM live.user u0_ WHERE (LOWER(u0_.email) = ? OR LOWER(u0_.nick) = ?) AND u0_.is_guest = false
Parameters: [
"prada@virtway.com"
"prada@virtway.com"
]
SELECT u0_.id AS id_0, u0_.uuid AS uuid_1, u0_.email AS email_2, u0_.roles AS roles_3, u0_.password AS password_4, u0_.nick AS nick_5, u0_.is_active AS is_active_6, u0_.is_guest AS is_guest_7, u0_.first_name AS first_name_8, u0_.last_name AS last_name_9, u0_.say_hello_email_enabled AS say_hello_email_enabled_10, u0_.last_password_update AS last_password_update_11, u0_.agree_registration_clause AS agree_registration_clause_12, u0_.token AS token_13, u0_.email_validated AS email_validated_14, u0_.email_validation_token AS email_validation_token_15, u0_.subtitle AS subtitle_16, u0_.allow_change_password AS allow_change_password_17, u0_.allow_edit_profile AS allow_edit_profile_18, u0_.rpm_avatar_url AS rpm_avatar_url_19, u0_.external_id AS external_id_20, u0_.created_at AS created_at_21, u0_.updated_at AS updated_at_22, u0_.registration_origin_id AS registration_origin_id_23 FROM live.user u0_ WHERE (LOWER(u0_.email) = 'prada@virtway.com' OR LOWER(u0_.nick) = 'prada@virtway.com') AND u0_.is_guest = false;
|
| 2 |
3.82 ms |
SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.email AS email_3, t0.roles AS roles_4, t0.password AS password_5, t0.nick AS nick_6, t0.is_active AS is_active_7, t0.is_guest AS is_guest_8, t0.first_name AS first_name_9, t0.last_name AS last_name_10, t0.say_hello_email_enabled AS say_hello_email_enabled_11, t0.last_password_update AS last_password_update_12, t0.agree_registration_clause AS agree_registration_clause_13, t0.token AS token_14, t0.email_validated AS email_validated_15, t0.email_validation_token AS email_validation_token_16, t0.subtitle AS subtitle_17, t0.allow_change_password AS allow_change_password_18, t0.allow_edit_profile AS allow_edit_profile_19, t0.rpm_avatar_url AS rpm_avatar_url_20, t0.external_id AS external_id_21, t0.created_at AS created_at_22, t0.updated_at AS updated_at_23, t0.registration_origin_id AS registration_origin_id_24 FROM live.user t0 WHERE t0.email = ? LIMIT 1
Parameters: [
"prada@virtway.com"
]
SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.email AS email_3, t0.roles AS roles_4, t0.password AS password_5, t0.nick AS nick_6, t0.is_active AS is_active_7, t0.is_guest AS is_guest_8, t0.first_name AS first_name_9, t0.last_name AS last_name_10, t0.say_hello_email_enabled AS say_hello_email_enabled_11, t0.last_password_update AS last_password_update_12, t0.agree_registration_clause AS agree_registration_clause_13, t0.token AS token_14, t0.email_validated AS email_validated_15, t0.email_validation_token AS email_validation_token_16, t0.subtitle AS subtitle_17, t0.allow_change_password AS allow_change_password_18, t0.allow_edit_profile AS allow_edit_profile_19, t0.rpm_avatar_url AS rpm_avatar_url_20, t0.external_id AS external_id_21, t0.created_at AS created_at_22, t0.updated_at AS updated_at_23, t0.registration_origin_id AS registration_origin_id_24 FROM live.user t0 WHERE t0.email = 'prada@virtway.com' LIMIT 1;
|
| 3 |
9.48 ms |
SELECT a0_.id AS id_0, a0_.token AS token_1, a0_.expired_at AS expired_at_2, a0_.created_at AS created_at_3, a0_.updated_at AS updated_at_4, a0_.user_id AS user_id_5, a0_.client_id AS client_id_6 FROM live.autologin_token a0_ WHERE a0_.user_id = ? AND a0_.client_id = ? AND a0_.expired_at > ? LIMIT 1
Parameters: [
1
2
"2026-08-06 14:16:56"
]
SELECT a0_.id AS id_0, a0_.token AS token_1, a0_.expired_at AS expired_at_2, a0_.created_at AS created_at_3, a0_.updated_at AS updated_at_4, a0_.user_id AS user_id_5, a0_.client_id AS client_id_6 FROM live.autologin_token a0_ WHERE a0_.user_id = 1 AND a0_.client_id = 2 AND a0_.expired_at > '2026-08-06 14:16:56' LIMIT 1;
|
| 7 |
23.37 ms |
INSERT INTO live.user_login (id, browser, login_type, created_at, updated_at, user_id, client_id, platform_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?)
Parameters: [
5463
"Chrome 150"
"form"
"2026-08-06 14:16:56"
"2026-08-06 14:16:56"
1
2
2
]
INSERT INTO live.user_login (id, browser, login_type, created_at, updated_at, user_id, client_id, platform_id) VALUES (5463, 'Chrome 150', 'form', '2026-08-06 14:16:56', '2026-08-06 14:16:56', 1, 2, 2);
|