Symfony Profiler

Query Metrics

89 Database Queries

4 Different statements

25.14 ms Query time

0 Invalid entities

78 Managed entities

Queries

Group similar statements

default connection


SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = ? LIMIT 1
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = ? LIMIT 1
SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.roles AS roles_3, t0.password AS password_4, t0.email AS email_5, t0.isVerified AS isVerified_6, t0.first_name AS first_name_7, t0.last_name AS last_name_8, t0.verificationCode AS verificationCode_9, t0.createdAt AS createdAt_10, t0.bannedAt AS bannedAt_11, t0.deletedAt AS deletedAt_12, t0.phoneNumber AS phoneNumber_13, t0.forgot_password_request AS forgot_password_request_14, t0.isDisabled AS isDisabled_15, t0.twoFAsecret AS twoFAsecret_16, t0.twoFAtype AS twoFAtype_17, t0.twoFAcode AS twoFAcode_18, t0.twoFAcodeIsActive AS twoFAcodeIsActive_19, t0.twoFAcodeGeneratedAt AS twoFAcodeGeneratedAt_20, t21.id AS id_22, t21.pgpEncryptedJsonFile AS pgpEncryptedJsonFile_23, t21.user_id AS user_id_24 FROM User t0 LEFT JOIN DeletedUserData t21 ON t21.user_id = t0.id WHERE t0.verificationCode IS NULL LIMIT 1
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = ? LIMIT 1
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = ? LIMIT 1
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = ? LIMIT 1
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = ? LIMIT 1
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = ? LIMIT 1
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = ? LIMIT 1
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = ? LIMIT 1
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = ? LIMIT 1
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = ? LIMIT 1
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = ? LIMIT 1
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = ? LIMIT 1
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = ? LIMIT 1
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = ? LIMIT 1
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = ? LIMIT 1
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = ? LIMIT 1
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = ? LIMIT 1
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = ? LIMIT 1
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = ? LIMIT 1
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = ? LIMIT 1
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = ? LIMIT 1
SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.roles AS roles_3, t0.password AS password_4, t0.email AS email_5, t0.isVerified AS isVerified_6, t0.first_name AS first_name_7, t0.last_name AS last_name_8, t0.verificationCode AS verificationCode_9, t0.createdAt AS createdAt_10, t0.bannedAt AS bannedAt_11, t0.deletedAt AS deletedAt_12, t0.phoneNumber AS phoneNumber_13, t0.forgot_password_request AS forgot_password_request_14, t0.isDisabled AS isDisabled_15, t0.twoFAsecret AS twoFAsecret_16, t0.twoFAtype AS twoFAtype_17, t0.twoFAcode AS twoFAcode_18, t0.twoFAcodeIsActive AS twoFAcodeIsActive_19, t0.twoFAcodeGeneratedAt AS twoFAcodeGeneratedAt_20, t21.id AS id_22, t21.pgpEncryptedJsonFile AS pgpEncryptedJsonFile_23, t21.user_id AS user_id_24 FROM User t0 LEFT JOIN DeletedUserData t21 ON t21.user_id = t0.id WHERE t0.verificationCode IS NULL LIMIT 1
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = ? LIMIT 1
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = ? LIMIT 1
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = ? LIMIT 1
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = ? LIMIT 1
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = ? LIMIT 1
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = ? LIMIT 1
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = ? LIMIT 1
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = ? LIMIT 1
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = ? LIMIT 1
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = ? LIMIT 1
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = ? LIMIT 1
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = ? LIMIT 1
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = ? LIMIT 1
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = ? LIMIT 1
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = ? LIMIT 1
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = ? LIMIT 1
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = ? LIMIT 1
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = ? LIMIT 1
SELECT t0.id AS id_1, t0.provider AS provider_2, t0.provider_id AS provider_id_3, t0.user_id AS user_id_4 FROM UserExternalAuth t0 WHERE t0.user_id IS NULL
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = ? LIMIT 1
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = ? LIMIT 1
SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.roles AS roles_3, t0.password AS password_4, t0.email AS email_5, t0.isVerified AS isVerified_6, t0.first_name AS first_name_7, t0.last_name AS last_name_8, t0.verificationCode AS verificationCode_9, t0.createdAt AS createdAt_10, t0.bannedAt AS bannedAt_11, t0.deletedAt AS deletedAt_12, t0.phoneNumber AS phoneNumber_13, t0.forgot_password_request AS forgot_password_request_14, t0.isDisabled AS isDisabled_15, t0.twoFAsecret AS twoFAsecret_16, t0.twoFAtype AS twoFAtype_17, t0.twoFAcode AS twoFAcode_18, t0.twoFAcodeIsActive AS twoFAcodeIsActive_19, t0.twoFAcodeGeneratedAt AS twoFAcodeGeneratedAt_20, t21.id AS id_22, t21.pgpEncryptedJsonFile AS pgpEncryptedJsonFile_23, t21.user_id AS user_id_24 FROM User t0 LEFT JOIN DeletedUserData t21 ON t21.user_id = t0.id WHERE t0.verificationCode IS NULL LIMIT 1
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = ? LIMIT 1
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = ? LIMIT 1
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = ? LIMIT 1
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = ? LIMIT 1
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = ? LIMIT 1
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = ? LIMIT 1
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = ? LIMIT 1
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = ? LIMIT 1
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = ? LIMIT 1
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = ? LIMIT 1
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = ? LIMIT 1
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = ? LIMIT 1
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = ? LIMIT 1
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = ? LIMIT 1
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = ? LIMIT 1
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = ? LIMIT 1
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = ? LIMIT 1
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = ? LIMIT 1
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = ? LIMIT 1
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = ? LIMIT 1
SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.roles AS roles_3, t0.password AS password_4, t0.email AS email_5, t0.isVerified AS isVerified_6, t0.first_name AS first_name_7, t0.last_name AS last_name_8, t0.verificationCode AS verificationCode_9, t0.createdAt AS createdAt_10, t0.bannedAt AS bannedAt_11, t0.deletedAt AS deletedAt_12, t0.phoneNumber AS phoneNumber_13, t0.forgot_password_request AS forgot_password_request_14, t0.isDisabled AS isDisabled_15, t0.twoFAsecret AS twoFAsecret_16, t0.twoFAtype AS twoFAtype_17, t0.twoFAcode AS twoFAcode_18, t0.twoFAcodeIsActive AS twoFAcodeIsActive_19, t0.twoFAcodeGeneratedAt AS twoFAcodeGeneratedAt_20, t21.id AS id_22, t21.pgpEncryptedJsonFile AS pgpEncryptedJsonFile_23, t21.user_id AS user_id_24 FROM User t0 LEFT JOIN DeletedUserData t21 ON t21.user_id = t0.id WHERE t0.verificationCode IS NULL LIMIT 1
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = ? LIMIT 1
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = ? LIMIT 1
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = ? LIMIT 1
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = ? LIMIT 1
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = ? LIMIT 1
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = ? LIMIT 1
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = ? LIMIT 1
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = ? LIMIT 1
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = ? LIMIT 1
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = ? LIMIT 1
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = ? LIMIT 1
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = ? LIMIT 1
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = ? LIMIT 1
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = ? LIMIT 1
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = ? LIMIT 1
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = ? LIMIT 1
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = ? LIMIT 1
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = ? LIMIT 1

#▲	Time	Info
1	0.71 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 Parameters: [] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0;
2	0.52 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = ? LIMIT 1 Parameters: [`"TURNSTILE_CHECKER"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = ? LIMIT 1 SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = 'TURNSTILE_CHECKER' LIMIT 1;
3	0.40 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = ? LIMIT 1 Parameters: [`"USER_VERIFICATION"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = ? LIMIT 1 SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = 'USER_VERIFICATION' LIMIT 1;
4	0.90 ms	SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.roles AS roles_3, t0.password AS password_4, t0.email AS email_5, t0.isVerified AS isVerified_6, t0.first_name AS first_name_7, t0.last_name AS last_name_8, t0.verificationCode AS verificationCode_9, t0.createdAt AS createdAt_10, t0.bannedAt AS bannedAt_11, t0.deletedAt AS deletedAt_12, t0.phoneNumber AS phoneNumber_13, t0.forgot_password_request AS forgot_password_request_14, t0.isDisabled AS isDisabled_15, t0.twoFAsecret AS twoFAsecret_16, t0.twoFAtype AS twoFAtype_17, t0.twoFAcode AS twoFAcode_18, t0.twoFAcodeIsActive AS twoFAcodeIsActive_19, t0.twoFAcodeGeneratedAt AS twoFAcodeGeneratedAt_20, t21.id AS id_22, t21.pgpEncryptedJsonFile AS pgpEncryptedJsonFile_23, t21.user_id AS user_id_24 FROM User t0 LEFT JOIN DeletedUserData t21 ON t21.user_id = t0.id WHERE t0.verificationCode IS NULL LIMIT 1 Parameters: [] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.roles AS roles_3, t0.password AS password_4, t0.email AS email_5, t0.isVerified AS isVerified_6, t0.first_name AS first_name_7, t0.last_name AS last_name_8, t0.verificationCode AS verificationCode_9, t0.createdAt AS createdAt_10, t0.bannedAt AS bannedAt_11, t0.deletedAt AS deletedAt_12, t0.phoneNumber AS phoneNumber_13, t0.forgot_password_request AS forgot_password_request_14, t0.isDisabled AS isDisabled_15, t0.twoFAsecret AS twoFAsecret_16, t0.twoFAtype AS twoFAtype_17, t0.twoFAcode AS twoFAcode_18, t0.twoFAcodeIsActive AS twoFAcodeIsActive_19, t0.twoFAcodeGeneratedAt AS twoFAcodeGeneratedAt_20, t21.id AS id_22, t21.pgpEncryptedJsonFile AS pgpEncryptedJsonFile_23, t21.user_id AS user_id_24 FROM User t0 LEFT JOIN DeletedUserData t21 ON t21.user_id = t0.id WHERE t0.verificationCode IS NULL LIMIT 1 SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.roles AS roles_3, t0.password AS password_4, t0.email AS email_5, t0.isVerified AS isVerified_6, t0.first_name AS first_name_7, t0.last_name AS last_name_8, t0.verificationCode AS verificationCode_9, t0.createdAt AS createdAt_10, t0.bannedAt AS bannedAt_11, t0.deletedAt AS deletedAt_12, t0.phoneNumber AS phoneNumber_13, t0.forgot_password_request AS forgot_password_request_14, t0.isDisabled AS isDisabled_15, t0.twoFAsecret AS twoFAsecret_16, t0.twoFAtype AS twoFAtype_17, t0.twoFAcode AS twoFAcode_18, t0.twoFAcodeIsActive AS twoFAcodeIsActive_19, t0.twoFAcodeGeneratedAt AS twoFAcodeGeneratedAt_20, t21.id AS id_22, t21.pgpEncryptedJsonFile AS pgpEncryptedJsonFile_23, t21.user_id AS user_id_24 FROM User t0 LEFT JOIN DeletedUserData t21 ON t21.user_id = t0.id WHERE t0.verificationCode IS NULL LIMIT 1;
5	0.29 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = ? LIMIT 1 Parameters: [`"PLATFORM_MODE"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = ? LIMIT 1 SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = 'PLATFORM_MODE' LIMIT 1;
6	0.27 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = ? LIMIT 1 Parameters: [`"AUTH_METHOD_SAML_ENABLED"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = ? LIMIT 1 SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = 'AUTH_METHOD_SAML_ENABLED' LIMIT 1;
7	0.26 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = ? LIMIT 1 Parameters: [`"AUTH_METHOD_SAML_LABEL"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = ? LIMIT 1 SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = 'AUTH_METHOD_SAML_LABEL' LIMIT 1;
8	0.26 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = ? LIMIT 1 Parameters: [`"AUTH_METHOD_SAML_DESCRIPTION"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = ? LIMIT 1 SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = 'AUTH_METHOD_SAML_DESCRIPTION' LIMIT 1;
9	0.33 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = ? LIMIT 1 Parameters: [`"AUTH_METHOD_GOOGLE_LOGIN_ENABLED"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = ? LIMIT 1 SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = 'AUTH_METHOD_GOOGLE_LOGIN_ENABLED' LIMIT 1;
10	0.26 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = ? LIMIT 1 Parameters: [`"AUTH_METHOD_GOOGLE_LOGIN_LABEL"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = ? LIMIT 1 SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = 'AUTH_METHOD_GOOGLE_LOGIN_LABEL' LIMIT 1;
11	0.25 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = ? LIMIT 1 Parameters: [`"AUTH_METHOD_GOOGLE_LOGIN_DESCRIPTION"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = ? LIMIT 1 SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = 'AUTH_METHOD_GOOGLE_LOGIN_DESCRIPTION' LIMIT 1;
12	0.25 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = ? LIMIT 1 Parameters: [`"AUTH_METHOD_MICROSOFT_LOGIN_ENABLED"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = ? LIMIT 1 SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = 'AUTH_METHOD_MICROSOFT_LOGIN_ENABLED' LIMIT 1;
13	0.25 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = ? LIMIT 1 Parameters: [`"AUTH_METHOD_MICROSOFT_LOGIN_LABEL"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = ? LIMIT 1 SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = 'AUTH_METHOD_MICROSOFT_LOGIN_LABEL' LIMIT 1;
14	0.25 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = ? LIMIT 1 Parameters: [`"AUTH_METHOD_MICROSOFT_LOGIN_DESCRIPTION"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = ? LIMIT 1 SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = 'AUTH_METHOD_MICROSOFT_LOGIN_DESCRIPTION' LIMIT 1;
15	0.27 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = ? LIMIT 1 Parameters: [`"AUTH_METHOD_REGISTER_ENABLED"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = ? LIMIT 1 SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = 'AUTH_METHOD_REGISTER_ENABLED' LIMIT 1;
16	0.25 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = ? LIMIT 1 Parameters: [`"AUTH_METHOD_REGISTER_LABEL"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = ? LIMIT 1 SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = 'AUTH_METHOD_REGISTER_LABEL' LIMIT 1;
17	0.25 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = ? LIMIT 1 Parameters: [`"AUTH_METHOD_REGISTER_DESCRIPTION"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = ? LIMIT 1 SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = 'AUTH_METHOD_REGISTER_DESCRIPTION' LIMIT 1;
18	0.25 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = ? LIMIT 1 Parameters: [`"AUTH_METHOD_LOGIN_TRADITIONAL_ENABLED"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = ? LIMIT 1 SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = 'AUTH_METHOD_LOGIN_TRADITIONAL_ENABLED' LIMIT 1;
19	0.25 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = ? LIMIT 1 Parameters: [`"AUTH_METHOD_LOGIN_TRADITIONAL_LABEL"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = ? LIMIT 1 SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = 'AUTH_METHOD_LOGIN_TRADITIONAL_LABEL' LIMIT 1;
20	0.30 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = ? LIMIT 1 Parameters: [`"AUTH_METHOD_LOGIN_TRADITIONAL_DESCRIPTION"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = ? LIMIT 1 SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = 'AUTH_METHOD_LOGIN_TRADITIONAL_DESCRIPTION' LIMIT 1;
21	0.26 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = ? LIMIT 1 Parameters: [`"AUTH_METHOD_SMS_REGISTER_ENABLED"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = ? LIMIT 1 SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = 'AUTH_METHOD_SMS_REGISTER_ENABLED' LIMIT 1;
22	0.26 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = ? LIMIT 1 Parameters: [`"CAPPORT_ENABLED"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = ? LIMIT 1 SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = 'CAPPORT_ENABLED' LIMIT 1;
23	0.33 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 Parameters: [] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0;
24	0.41 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = ? LIMIT 1 Parameters: [`"TURNSTILE_CHECKER"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = ? LIMIT 1 SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = 'TURNSTILE_CHECKER' LIMIT 1;
25	0.33 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = ? LIMIT 1 Parameters: [`"USER_VERIFICATION"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = ? LIMIT 1 SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = 'USER_VERIFICATION' LIMIT 1;
26	0.47 ms	SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.roles AS roles_3, t0.password AS password_4, t0.email AS email_5, t0.isVerified AS isVerified_6, t0.first_name AS first_name_7, t0.last_name AS last_name_8, t0.verificationCode AS verificationCode_9, t0.createdAt AS createdAt_10, t0.bannedAt AS bannedAt_11, t0.deletedAt AS deletedAt_12, t0.phoneNumber AS phoneNumber_13, t0.forgot_password_request AS forgot_password_request_14, t0.isDisabled AS isDisabled_15, t0.twoFAsecret AS twoFAsecret_16, t0.twoFAtype AS twoFAtype_17, t0.twoFAcode AS twoFAcode_18, t0.twoFAcodeIsActive AS twoFAcodeIsActive_19, t0.twoFAcodeGeneratedAt AS twoFAcodeGeneratedAt_20, t21.id AS id_22, t21.pgpEncryptedJsonFile AS pgpEncryptedJsonFile_23, t21.user_id AS user_id_24 FROM User t0 LEFT JOIN DeletedUserData t21 ON t21.user_id = t0.id WHERE t0.verificationCode IS NULL LIMIT 1 Parameters: [] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.roles AS roles_3, t0.password AS password_4, t0.email AS email_5, t0.isVerified AS isVerified_6, t0.first_name AS first_name_7, t0.last_name AS last_name_8, t0.verificationCode AS verificationCode_9, t0.createdAt AS createdAt_10, t0.bannedAt AS bannedAt_11, t0.deletedAt AS deletedAt_12, t0.phoneNumber AS phoneNumber_13, t0.forgot_password_request AS forgot_password_request_14, t0.isDisabled AS isDisabled_15, t0.twoFAsecret AS twoFAsecret_16, t0.twoFAtype AS twoFAtype_17, t0.twoFAcode AS twoFAcode_18, t0.twoFAcodeIsActive AS twoFAcodeIsActive_19, t0.twoFAcodeGeneratedAt AS twoFAcodeGeneratedAt_20, t21.id AS id_22, t21.pgpEncryptedJsonFile AS pgpEncryptedJsonFile_23, t21.user_id AS user_id_24 FROM User t0 LEFT JOIN DeletedUserData t21 ON t21.user_id = t0.id WHERE t0.verificationCode IS NULL LIMIT 1 SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.roles AS roles_3, t0.password AS password_4, t0.email AS email_5, t0.isVerified AS isVerified_6, t0.first_name AS first_name_7, t0.last_name AS last_name_8, t0.verificationCode AS verificationCode_9, t0.createdAt AS createdAt_10, t0.bannedAt AS bannedAt_11, t0.deletedAt AS deletedAt_12, t0.phoneNumber AS phoneNumber_13, t0.forgot_password_request AS forgot_password_request_14, t0.isDisabled AS isDisabled_15, t0.twoFAsecret AS twoFAsecret_16, t0.twoFAtype AS twoFAtype_17, t0.twoFAcode AS twoFAcode_18, t0.twoFAcodeIsActive AS twoFAcodeIsActive_19, t0.twoFAcodeGeneratedAt AS twoFAcodeGeneratedAt_20, t21.id AS id_22, t21.pgpEncryptedJsonFile AS pgpEncryptedJsonFile_23, t21.user_id AS user_id_24 FROM User t0 LEFT JOIN DeletedUserData t21 ON t21.user_id = t0.id WHERE t0.verificationCode IS NULL LIMIT 1;
27	0.31 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = ? LIMIT 1 Parameters: [`"PLATFORM_MODE"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = ? LIMIT 1 SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = 'PLATFORM_MODE' LIMIT 1;
28	0.31 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = ? LIMIT 1 Parameters: [`"AUTH_METHOD_SAML_ENABLED"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = ? LIMIT 1 SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = 'AUTH_METHOD_SAML_ENABLED' LIMIT 1;
29	0.33 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = ? LIMIT 1 Parameters: [`"AUTH_METHOD_SAML_LABEL"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = ? LIMIT 1 SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = 'AUTH_METHOD_SAML_LABEL' LIMIT 1;
30	0.36 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = ? LIMIT 1 Parameters: [`"AUTH_METHOD_SAML_DESCRIPTION"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = ? LIMIT 1 SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = 'AUTH_METHOD_SAML_DESCRIPTION' LIMIT 1;
31	0.25 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = ? LIMIT 1 Parameters: [`"AUTH_METHOD_GOOGLE_LOGIN_ENABLED"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = ? LIMIT 1 SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = 'AUTH_METHOD_GOOGLE_LOGIN_ENABLED' LIMIT 1;
32	0.24 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = ? LIMIT 1 Parameters: [`"AUTH_METHOD_GOOGLE_LOGIN_LABEL"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = ? LIMIT 1 SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = 'AUTH_METHOD_GOOGLE_LOGIN_LABEL' LIMIT 1;
33	0.25 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = ? LIMIT 1 Parameters: [`"AUTH_METHOD_GOOGLE_LOGIN_DESCRIPTION"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = ? LIMIT 1 SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = 'AUTH_METHOD_GOOGLE_LOGIN_DESCRIPTION' LIMIT 1;
34	0.24 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = ? LIMIT 1 Parameters: [`"AUTH_METHOD_MICROSOFT_LOGIN_ENABLED"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = ? LIMIT 1 SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = 'AUTH_METHOD_MICROSOFT_LOGIN_ENABLED' LIMIT 1;
35	0.24 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = ? LIMIT 1 Parameters: [`"AUTH_METHOD_MICROSOFT_LOGIN_LABEL"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = ? LIMIT 1 SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = 'AUTH_METHOD_MICROSOFT_LOGIN_LABEL' LIMIT 1;
36	0.25 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = ? LIMIT 1 Parameters: [`"AUTH_METHOD_MICROSOFT_LOGIN_DESCRIPTION"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = ? LIMIT 1 SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = 'AUTH_METHOD_MICROSOFT_LOGIN_DESCRIPTION' LIMIT 1;
37	0.24 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = ? LIMIT 1 Parameters: [`"AUTH_METHOD_REGISTER_ENABLED"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = ? LIMIT 1 SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = 'AUTH_METHOD_REGISTER_ENABLED' LIMIT 1;
38	0.24 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = ? LIMIT 1 Parameters: [`"AUTH_METHOD_REGISTER_LABEL"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = ? LIMIT 1 SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = 'AUTH_METHOD_REGISTER_LABEL' LIMIT 1;
39	0.27 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = ? LIMIT 1 Parameters: [`"AUTH_METHOD_REGISTER_DESCRIPTION"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = ? LIMIT 1 SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = 'AUTH_METHOD_REGISTER_DESCRIPTION' LIMIT 1;
40	0.27 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = ? LIMIT 1 Parameters: [`"AUTH_METHOD_LOGIN_TRADITIONAL_ENABLED"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = ? LIMIT 1 SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = 'AUTH_METHOD_LOGIN_TRADITIONAL_ENABLED' LIMIT 1;
41	0.25 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = ? LIMIT 1 Parameters: [`"AUTH_METHOD_LOGIN_TRADITIONAL_LABEL"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = ? LIMIT 1 SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = 'AUTH_METHOD_LOGIN_TRADITIONAL_LABEL' LIMIT 1;
42	0.25 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = ? LIMIT 1 Parameters: [`"AUTH_METHOD_LOGIN_TRADITIONAL_DESCRIPTION"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = ? LIMIT 1 SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = 'AUTH_METHOD_LOGIN_TRADITIONAL_DESCRIPTION' LIMIT 1;
43	0.24 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = ? LIMIT 1 Parameters: [`"AUTH_METHOD_SMS_REGISTER_ENABLED"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = ? LIMIT 1 SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = 'AUTH_METHOD_SMS_REGISTER_ENABLED' LIMIT 1;
44	0.25 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = ? LIMIT 1 Parameters: [`"CAPPORT_ENABLED"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = ? LIMIT 1 SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = 'CAPPORT_ENABLED' LIMIT 1;
45	0.22 ms	SELECT t0.id AS id_1, t0.provider AS provider_2, t0.provider_id AS provider_id_3, t0.user_id AS user_id_4 FROM UserExternalAuth t0 WHERE t0.user_id IS NULL Parameters: [] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.provider AS provider_2, t0.provider_id AS provider_id_3, t0.user_id AS user_id_4 FROM UserExternalAuth t0 WHERE t0.user_id IS NULL SELECT t0.id AS id_1, t0.provider AS provider_2, t0.provider_id AS provider_id_3, t0.user_id AS user_id_4 FROM UserExternalAuth t0 WHERE t0.user_id IS NULL;
46	0.33 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 Parameters: [] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0;
47	0.26 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = ? LIMIT 1 Parameters: [`"TURNSTILE_CHECKER"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = ? LIMIT 1 SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = 'TURNSTILE_CHECKER' LIMIT 1;
48	0.25 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = ? LIMIT 1 Parameters: [`"USER_VERIFICATION"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = ? LIMIT 1 SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = 'USER_VERIFICATION' LIMIT 1;
49	0.37 ms	SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.roles AS roles_3, t0.password AS password_4, t0.email AS email_5, t0.isVerified AS isVerified_6, t0.first_name AS first_name_7, t0.last_name AS last_name_8, t0.verificationCode AS verificationCode_9, t0.createdAt AS createdAt_10, t0.bannedAt AS bannedAt_11, t0.deletedAt AS deletedAt_12, t0.phoneNumber AS phoneNumber_13, t0.forgot_password_request AS forgot_password_request_14, t0.isDisabled AS isDisabled_15, t0.twoFAsecret AS twoFAsecret_16, t0.twoFAtype AS twoFAtype_17, t0.twoFAcode AS twoFAcode_18, t0.twoFAcodeIsActive AS twoFAcodeIsActive_19, t0.twoFAcodeGeneratedAt AS twoFAcodeGeneratedAt_20, t21.id AS id_22, t21.pgpEncryptedJsonFile AS pgpEncryptedJsonFile_23, t21.user_id AS user_id_24 FROM User t0 LEFT JOIN DeletedUserData t21 ON t21.user_id = t0.id WHERE t0.verificationCode IS NULL LIMIT 1 Parameters: [] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.roles AS roles_3, t0.password AS password_4, t0.email AS email_5, t0.isVerified AS isVerified_6, t0.first_name AS first_name_7, t0.last_name AS last_name_8, t0.verificationCode AS verificationCode_9, t0.createdAt AS createdAt_10, t0.bannedAt AS bannedAt_11, t0.deletedAt AS deletedAt_12, t0.phoneNumber AS phoneNumber_13, t0.forgot_password_request AS forgot_password_request_14, t0.isDisabled AS isDisabled_15, t0.twoFAsecret AS twoFAsecret_16, t0.twoFAtype AS twoFAtype_17, t0.twoFAcode AS twoFAcode_18, t0.twoFAcodeIsActive AS twoFAcodeIsActive_19, t0.twoFAcodeGeneratedAt AS twoFAcodeGeneratedAt_20, t21.id AS id_22, t21.pgpEncryptedJsonFile AS pgpEncryptedJsonFile_23, t21.user_id AS user_id_24 FROM User t0 LEFT JOIN DeletedUserData t21 ON t21.user_id = t0.id WHERE t0.verificationCode IS NULL LIMIT 1 SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.roles AS roles_3, t0.password AS password_4, t0.email AS email_5, t0.isVerified AS isVerified_6, t0.first_name AS first_name_7, t0.last_name AS last_name_8, t0.verificationCode AS verificationCode_9, t0.createdAt AS createdAt_10, t0.bannedAt AS bannedAt_11, t0.deletedAt AS deletedAt_12, t0.phoneNumber AS phoneNumber_13, t0.forgot_password_request AS forgot_password_request_14, t0.isDisabled AS isDisabled_15, t0.twoFAsecret AS twoFAsecret_16, t0.twoFAtype AS twoFAtype_17, t0.twoFAcode AS twoFAcode_18, t0.twoFAcodeIsActive AS twoFAcodeIsActive_19, t0.twoFAcodeGeneratedAt AS twoFAcodeGeneratedAt_20, t21.id AS id_22, t21.pgpEncryptedJsonFile AS pgpEncryptedJsonFile_23, t21.user_id AS user_id_24 FROM User t0 LEFT JOIN DeletedUserData t21 ON t21.user_id = t0.id WHERE t0.verificationCode IS NULL LIMIT 1;
50	0.26 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = ? LIMIT 1 Parameters: [`"PLATFORM_MODE"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = ? LIMIT 1 SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = 'PLATFORM_MODE' LIMIT 1;
51	0.26 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = ? LIMIT 1 Parameters: [`"AUTH_METHOD_SAML_ENABLED"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = ? LIMIT 1 SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = 'AUTH_METHOD_SAML_ENABLED' LIMIT 1;
52	0.25 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = ? LIMIT 1 Parameters: [`"AUTH_METHOD_SAML_LABEL"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = ? LIMIT 1 SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = 'AUTH_METHOD_SAML_LABEL' LIMIT 1;
53	0.24 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = ? LIMIT 1 Parameters: [`"AUTH_METHOD_SAML_DESCRIPTION"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = ? LIMIT 1 SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = 'AUTH_METHOD_SAML_DESCRIPTION' LIMIT 1;
54	0.24 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = ? LIMIT 1 Parameters: [`"AUTH_METHOD_GOOGLE_LOGIN_ENABLED"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = ? LIMIT 1 SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = 'AUTH_METHOD_GOOGLE_LOGIN_ENABLED' LIMIT 1;
55	0.24 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = ? LIMIT 1 Parameters: [`"AUTH_METHOD_GOOGLE_LOGIN_LABEL"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = ? LIMIT 1 SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = 'AUTH_METHOD_GOOGLE_LOGIN_LABEL' LIMIT 1;
56	0.26 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = ? LIMIT 1 Parameters: [`"AUTH_METHOD_GOOGLE_LOGIN_DESCRIPTION"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = ? LIMIT 1 SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = 'AUTH_METHOD_GOOGLE_LOGIN_DESCRIPTION' LIMIT 1;
57	0.24 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = ? LIMIT 1 Parameters: [`"AUTH_METHOD_MICROSOFT_LOGIN_ENABLED"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = ? LIMIT 1 SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = 'AUTH_METHOD_MICROSOFT_LOGIN_ENABLED' LIMIT 1;
58	0.25 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = ? LIMIT 1 Parameters: [`"AUTH_METHOD_MICROSOFT_LOGIN_LABEL"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = ? LIMIT 1 SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = 'AUTH_METHOD_MICROSOFT_LOGIN_LABEL' LIMIT 1;
59	0.24 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = ? LIMIT 1 Parameters: [`"AUTH_METHOD_MICROSOFT_LOGIN_DESCRIPTION"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = ? LIMIT 1 SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = 'AUTH_METHOD_MICROSOFT_LOGIN_DESCRIPTION' LIMIT 1;
60	0.24 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = ? LIMIT 1 Parameters: [`"AUTH_METHOD_REGISTER_ENABLED"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = ? LIMIT 1 SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = 'AUTH_METHOD_REGISTER_ENABLED' LIMIT 1;
61	0.25 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = ? LIMIT 1 Parameters: [`"AUTH_METHOD_REGISTER_LABEL"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = ? LIMIT 1 SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = 'AUTH_METHOD_REGISTER_LABEL' LIMIT 1;
62	0.24 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = ? LIMIT 1 Parameters: [`"AUTH_METHOD_REGISTER_DESCRIPTION"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = ? LIMIT 1 SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = 'AUTH_METHOD_REGISTER_DESCRIPTION' LIMIT 1;
63	0.24 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = ? LIMIT 1 Parameters: [`"AUTH_METHOD_LOGIN_TRADITIONAL_ENABLED"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = ? LIMIT 1 SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = 'AUTH_METHOD_LOGIN_TRADITIONAL_ENABLED' LIMIT 1;
64	0.25 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = ? LIMIT 1 Parameters: [`"AUTH_METHOD_LOGIN_TRADITIONAL_LABEL"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = ? LIMIT 1 SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = 'AUTH_METHOD_LOGIN_TRADITIONAL_LABEL' LIMIT 1;
65	0.26 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = ? LIMIT 1 Parameters: [`"AUTH_METHOD_LOGIN_TRADITIONAL_DESCRIPTION"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = ? LIMIT 1 SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = 'AUTH_METHOD_LOGIN_TRADITIONAL_DESCRIPTION' LIMIT 1;
66	0.25 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = ? LIMIT 1 Parameters: [`"AUTH_METHOD_SMS_REGISTER_ENABLED"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = ? LIMIT 1 SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = 'AUTH_METHOD_SMS_REGISTER_ENABLED' LIMIT 1;
67	0.25 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = ? LIMIT 1 Parameters: [`"CAPPORT_ENABLED"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = ? LIMIT 1 SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = 'CAPPORT_ENABLED' LIMIT 1;
68	0.32 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 Parameters: [] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0;
69	0.25 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = ? LIMIT 1 Parameters: [`"TURNSTILE_CHECKER"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = ? LIMIT 1 SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = 'TURNSTILE_CHECKER' LIMIT 1;
70	0.25 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = ? LIMIT 1 Parameters: [`"USER_VERIFICATION"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = ? LIMIT 1 SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = 'USER_VERIFICATION' LIMIT 1;
71	0.36 ms	SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.roles AS roles_3, t0.password AS password_4, t0.email AS email_5, t0.isVerified AS isVerified_6, t0.first_name AS first_name_7, t0.last_name AS last_name_8, t0.verificationCode AS verificationCode_9, t0.createdAt AS createdAt_10, t0.bannedAt AS bannedAt_11, t0.deletedAt AS deletedAt_12, t0.phoneNumber AS phoneNumber_13, t0.forgot_password_request AS forgot_password_request_14, t0.isDisabled AS isDisabled_15, t0.twoFAsecret AS twoFAsecret_16, t0.twoFAtype AS twoFAtype_17, t0.twoFAcode AS twoFAcode_18, t0.twoFAcodeIsActive AS twoFAcodeIsActive_19, t0.twoFAcodeGeneratedAt AS twoFAcodeGeneratedAt_20, t21.id AS id_22, t21.pgpEncryptedJsonFile AS pgpEncryptedJsonFile_23, t21.user_id AS user_id_24 FROM User t0 LEFT JOIN DeletedUserData t21 ON t21.user_id = t0.id WHERE t0.verificationCode IS NULL LIMIT 1 Parameters: [] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.roles AS roles_3, t0.password AS password_4, t0.email AS email_5, t0.isVerified AS isVerified_6, t0.first_name AS first_name_7, t0.last_name AS last_name_8, t0.verificationCode AS verificationCode_9, t0.createdAt AS createdAt_10, t0.bannedAt AS bannedAt_11, t0.deletedAt AS deletedAt_12, t0.phoneNumber AS phoneNumber_13, t0.forgot_password_request AS forgot_password_request_14, t0.isDisabled AS isDisabled_15, t0.twoFAsecret AS twoFAsecret_16, t0.twoFAtype AS twoFAtype_17, t0.twoFAcode AS twoFAcode_18, t0.twoFAcodeIsActive AS twoFAcodeIsActive_19, t0.twoFAcodeGeneratedAt AS twoFAcodeGeneratedAt_20, t21.id AS id_22, t21.pgpEncryptedJsonFile AS pgpEncryptedJsonFile_23, t21.user_id AS user_id_24 FROM User t0 LEFT JOIN DeletedUserData t21 ON t21.user_id = t0.id WHERE t0.verificationCode IS NULL LIMIT 1 SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.roles AS roles_3, t0.password AS password_4, t0.email AS email_5, t0.isVerified AS isVerified_6, t0.first_name AS first_name_7, t0.last_name AS last_name_8, t0.verificationCode AS verificationCode_9, t0.createdAt AS createdAt_10, t0.bannedAt AS bannedAt_11, t0.deletedAt AS deletedAt_12, t0.phoneNumber AS phoneNumber_13, t0.forgot_password_request AS forgot_password_request_14, t0.isDisabled AS isDisabled_15, t0.twoFAsecret AS twoFAsecret_16, t0.twoFAtype AS twoFAtype_17, t0.twoFAcode AS twoFAcode_18, t0.twoFAcodeIsActive AS twoFAcodeIsActive_19, t0.twoFAcodeGeneratedAt AS twoFAcodeGeneratedAt_20, t21.id AS id_22, t21.pgpEncryptedJsonFile AS pgpEncryptedJsonFile_23, t21.user_id AS user_id_24 FROM User t0 LEFT JOIN DeletedUserData t21 ON t21.user_id = t0.id WHERE t0.verificationCode IS NULL LIMIT 1;
72	0.25 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = ? LIMIT 1 Parameters: [`"PLATFORM_MODE"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = ? LIMIT 1 SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = 'PLATFORM_MODE' LIMIT 1;
73	0.25 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = ? LIMIT 1 Parameters: [`"AUTH_METHOD_SAML_ENABLED"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = ? LIMIT 1 SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = 'AUTH_METHOD_SAML_ENABLED' LIMIT 1;
74	0.26 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = ? LIMIT 1 Parameters: [`"AUTH_METHOD_SAML_LABEL"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = ? LIMIT 1 SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = 'AUTH_METHOD_SAML_LABEL' LIMIT 1;
75	0.28 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = ? LIMIT 1 Parameters: [`"AUTH_METHOD_SAML_DESCRIPTION"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = ? LIMIT 1 SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = 'AUTH_METHOD_SAML_DESCRIPTION' LIMIT 1;
76	0.24 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = ? LIMIT 1 Parameters: [`"AUTH_METHOD_GOOGLE_LOGIN_ENABLED"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = ? LIMIT 1 SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = 'AUTH_METHOD_GOOGLE_LOGIN_ENABLED' LIMIT 1;
77	0.24 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = ? LIMIT 1 Parameters: [`"AUTH_METHOD_GOOGLE_LOGIN_LABEL"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = ? LIMIT 1 SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = 'AUTH_METHOD_GOOGLE_LOGIN_LABEL' LIMIT 1;
78	0.24 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = ? LIMIT 1 Parameters: [`"AUTH_METHOD_GOOGLE_LOGIN_DESCRIPTION"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = ? LIMIT 1 SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = 'AUTH_METHOD_GOOGLE_LOGIN_DESCRIPTION' LIMIT 1;
79	0.24 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = ? LIMIT 1 Parameters: [`"AUTH_METHOD_MICROSOFT_LOGIN_ENABLED"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = ? LIMIT 1 SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = 'AUTH_METHOD_MICROSOFT_LOGIN_ENABLED' LIMIT 1;
80	0.24 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = ? LIMIT 1 Parameters: [`"AUTH_METHOD_MICROSOFT_LOGIN_LABEL"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = ? LIMIT 1 SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = 'AUTH_METHOD_MICROSOFT_LOGIN_LABEL' LIMIT 1;
81	0.25 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = ? LIMIT 1 Parameters: [`"AUTH_METHOD_MICROSOFT_LOGIN_DESCRIPTION"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = ? LIMIT 1 SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = 'AUTH_METHOD_MICROSOFT_LOGIN_DESCRIPTION' LIMIT 1;
82	0.24 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = ? LIMIT 1 Parameters: [`"AUTH_METHOD_REGISTER_ENABLED"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = ? LIMIT 1 SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = 'AUTH_METHOD_REGISTER_ENABLED' LIMIT 1;
83	0.24 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = ? LIMIT 1 Parameters: [`"AUTH_METHOD_REGISTER_LABEL"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = ? LIMIT 1 SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = 'AUTH_METHOD_REGISTER_LABEL' LIMIT 1;
84	0.25 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = ? LIMIT 1 Parameters: [`"AUTH_METHOD_REGISTER_DESCRIPTION"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = ? LIMIT 1 SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = 'AUTH_METHOD_REGISTER_DESCRIPTION' LIMIT 1;
85	0.24 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = ? LIMIT 1 Parameters: [`"AUTH_METHOD_LOGIN_TRADITIONAL_ENABLED"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = ? LIMIT 1 SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = 'AUTH_METHOD_LOGIN_TRADITIONAL_ENABLED' LIMIT 1;
86	0.24 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = ? LIMIT 1 Parameters: [`"AUTH_METHOD_LOGIN_TRADITIONAL_LABEL"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = ? LIMIT 1 SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = 'AUTH_METHOD_LOGIN_TRADITIONAL_LABEL' LIMIT 1;
87	0.25 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = ? LIMIT 1 Parameters: [`"AUTH_METHOD_LOGIN_TRADITIONAL_DESCRIPTION"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = ? LIMIT 1 SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = 'AUTH_METHOD_LOGIN_TRADITIONAL_DESCRIPTION' LIMIT 1;
88	0.26 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = ? LIMIT 1 Parameters: [`"AUTH_METHOD_SMS_REGISTER_ENABLED"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = ? LIMIT 1 SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = 'AUTH_METHOD_SMS_REGISTER_ENABLED' LIMIT 1;
89	0.25 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = ? LIMIT 1 Parameters: [`"CAPPORT_ENABLED"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = ? LIMIT 1 SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM Setting t0 WHERE t0.name = 'CAPPORT_ENABLED' LIMIT 1;

Database Connections

Name	Service
default	doctrine.dbal.default_connection
freeradius	doctrine.dbal.freeradius_connection

Entity Managers

Name	Service
default	doctrine.orm.default_entity_manager
freeradius	doctrine.orm.freeradius_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

default entity manager

Class	Amount of managed objects
App\Entity\Setting	77
App\Entity\User	1

freeradius entity manager

Class	Amount of managed objects

Entities Mapping

default entity manager

Class	Mapping errors
App\Entity\Setting	No errors.
App\Entity\User	No errors.
App\Entity\DeletedUserData	No errors.
App\Entity\UserRadiusProfile	No errors.
App\Entity\UserExternalAuth	No errors.
App\Entity\Event	No errors.
App\Entity\Notification	No errors.
App\Entity\OTPcode	No errors.

freeradius entity manager

No loaded entities.

Symfony Profiler

GET https://openroaming.morfusconnect.com/

Configuration Settings

Theme

Page Width

Query Metrics

Queries

default connection

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

freeradius entity manager

Entities Mapping

default entity manager

freeradius entity manager