| 1 |
0.59 ms |
SELECT t0.username AS username_1, t0.password AS password_2, t0.locale AS locale_3, t0.salt AS salt_4, t0.locked AS locked_5, t0.enabled AS enabled_6, t0.lastLogin AS lastLogin_7, t0.confirmationKey AS confirmationKey_8, t0.passwordResetToken AS passwordResetToken_9, t0.passwordResetTokenExpiresAt AS passwordResetTokenExpiresAt_10, t0.passwordResetTokenEmailsSent AS passwordResetTokenEmailsSent_11, t0.privateKey AS privateKey_12, t0.apiKey AS apiKey_13, t0.email AS email_14, t0.id AS id_15, t0.created AS created_16, t0.changed AS changed_17, t18.method AS method_19, t18.options AS options_20, t18.id AS id_21, t18.idUsers AS idUsers_22, t0.idContacts AS idContacts_23, t0.idUsersCreator AS idUsersCreator_24, t0.idUsersChanger AS idUsersChanger_25 FROM se_users t0 LEFT JOIN se_user_two_factors t18 ON t18.idUsers = t0.id WHERE t0.username = ? LIMIT 1
SELECT t0.username AS username_1, t0.password AS password_2, t0.locale AS locale_3, t0.salt AS salt_4, t0.locked AS locked_5, t0.enabled AS enabled_6, t0.lastLogin AS lastLogin_7, t0.confirmationKey AS confirmationKey_8, t0.passwordResetToken AS passwordResetToken_9, t0.passwordResetTokenExpiresAt AS passwordResetTokenExpiresAt_10, t0.passwordResetTokenEmailsSent AS passwordResetTokenEmailsSent_11, t0.privateKey AS privateKey_12, t0.apiKey AS apiKey_13, t0.email AS email_14, t0.id AS id_15, t0.created AS created_16, t0.changed AS changed_17, t18.method AS method_19, t18.options AS options_20, t18.id AS id_21, t18.idUsers AS idUsers_22, t0.idContacts AS idContacts_23, t0.idUsersCreator AS idUsersCreator_24, t0.idUsersChanger AS idUsersChanger_25 FROM se_users t0 LEFT JOIN se_user_two_factors t18 ON t18.idUsers = t0.id WHERE t0.username = 'otidea' LIMIT 1;
|
| 2 |
0.54 ms |
SELECT s0_.username AS username_0, s0_.password AS password_1, s0_.locale AS locale_2, s0_.salt AS salt_3, s0_.locked AS locked_4, s0_.enabled AS enabled_5, s0_.lastLogin AS lastLogin_6, s0_.confirmationKey AS confirmationKey_7, s0_.passwordResetToken AS passwordResetToken_8, s0_.passwordResetTokenExpiresAt AS passwordResetTokenExpiresAt_9, s0_.passwordResetTokenEmailsSent AS passwordResetTokenEmailsSent_10, s0_.privateKey AS privateKey_11, s0_.apiKey AS apiKey_12, s0_.email AS email_13, s0_.id AS id_14, s0_.created AS created_15, s0_.changed AS changed_16, s1_.locale AS locale_17, s1_.id AS id_18, s2_.name AS name_19, s2_.role_key AS role_key_20, s2_.securitySystem AS securitySystem_21, s2_.anonymous AS anonymous_22, s2_.id AS id_23, s2_.created AS created_24, s2_.changed AS changed_25, s3_.context AS context_26, s3_.module AS module_27, s3_.permissions AS permissions_28, s3_.id AS id_29, s0_.idContacts AS idContacts_30, s0_.idUsersCreator AS idUsersCreator_31, s0_.idUsersChanger AS idUsersChanger_32, s1_.idUsers AS idUsers_33, s1_.idRoles AS idRoles_34, s2_.idSecurityTypes AS idSecurityTypes_35, s2_.idUsersCreator AS idUsersCreator_36, s2_.idUsersChanger AS idUsersChanger_37, s3_.idRoles AS idRoles_38 FROM se_users s0_ LEFT JOIN se_user_roles s1_ ON s0_.id = s1_.idUsers LEFT JOIN se_roles s2_ ON s1_.idRoles = s2_.id LEFT JOIN se_permissions s3_ ON s2_.id = s3_.idRoles WHERE s0_.email = ? OR s0_.username = ?
Parameters: [
"otidea"
"otidea"
]
SELECT s0_.username AS username_0, s0_.password AS password_1, s0_.locale AS locale_2, s0_.salt AS salt_3, s0_.locked AS locked_4, s0_.enabled AS enabled_5, s0_.lastLogin AS lastLogin_6, s0_.confirmationKey AS confirmationKey_7, s0_.passwordResetToken AS passwordResetToken_8, s0_.passwordResetTokenExpiresAt AS passwordResetTokenExpiresAt_9, s0_.passwordResetTokenEmailsSent AS passwordResetTokenEmailsSent_10, s0_.privateKey AS privateKey_11, s0_.apiKey AS apiKey_12, s0_.email AS email_13, s0_.id AS id_14, s0_.created AS created_15, s0_.changed AS changed_16, s1_.locale AS locale_17, s1_.id AS id_18, s2_.name AS name_19, s2_.role_key AS role_key_20, s2_.securitySystem AS securitySystem_21, s2_.anonymous AS anonymous_22, s2_.id AS id_23, s2_.created AS created_24, s2_.changed AS changed_25, s3_.context AS context_26, s3_.module AS module_27, s3_.permissions AS permissions_28, s3_.id AS id_29, s0_.idContacts AS idContacts_30, s0_.idUsersCreator AS idUsersCreator_31, s0_.idUsersChanger AS idUsersChanger_32, s1_.idUsers AS idUsers_33, s1_.idRoles AS idRoles_34, s2_.idSecurityTypes AS idSecurityTypes_35, s2_.idUsersCreator AS idUsersCreator_36, s2_.idUsersChanger AS idUsersChanger_37, s3_.idRoles AS idRoles_38 FROM se_users s0_ LEFT JOIN se_user_roles s1_ ON s0_.id = s1_.idUsers LEFT JOIN se_roles s2_ ON s1_.idRoles = s2_.id LEFT JOIN se_permissions s3_ ON s2_.id = s3_.idRoles WHERE s0_.email = 'otidea' OR s0_.username = 'otidea';
|