| 1 |
2.38 ms |
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.first_name AS first_name_5, t0.last_name AS last_name_6, t0.is_verified AS is_verified_7, t0.status AS status_8, t0.totp_secret AS totp_secret_9, t0.is_totp_enabled AS is_totp_enabled_10, t0.totp_algorithm AS totp_algorithm_11, t0.totp_period AS totp_period_12, t0.otp_type AS otp_type_13, t0.hotp_counter AS hotp_counter_14, t0.backup_codes AS backup_codes_15, t0.api_token AS api_token_16, t0.must_change_password AS must_change_password_17, t0.created_at AS created_at_18, t0.updated_at AS updated_at_19, t0.deleted_at AS deleted_at_20 FROM "user" t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.first_name AS first_name_5, t0.last_name AS last_name_6, t0.is_verified AS is_verified_7, t0.status AS status_8, t0.totp_secret AS totp_secret_9, t0.is_totp_enabled AS is_totp_enabled_10, t0.totp_algorithm AS totp_algorithm_11, t0.totp_period AS totp_period_12, t0.otp_type AS otp_type_13, t0.hotp_counter AS hotp_counter_14, t0.backup_codes AS backup_codes_15, t0.api_token AS api_token_16, t0.must_change_password AS must_change_password_17, t0.created_at AS created_at_18, t0.updated_at AS updated_at_19, t0.deleted_at AS deleted_at_20 FROM "user" t0 WHERE t0.id = 1;
|
| 2 |
2.16 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.symfony_role AS symfony_role_3, t0.description AS description_4, t0.color AS color_5, t0.is_system AS is_system_6, t0.is_active AS is_active_7, t0.priority AS priority_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.deleted_at AS deleted_at_11 FROM role t0 INNER JOIN user_role ON t0.id = user_role.role_id WHERE user_role.user_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.symfony_role AS symfony_role_3, t0.description AS description_4, t0.color AS color_5, t0.is_system AS is_system_6, t0.is_active AS is_active_7, t0.priority AS priority_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.deleted_at AS deleted_at_11 FROM role t0 INNER JOIN user_role ON t0.id = user_role.role_id WHERE user_role.user_id = 1;
|