Redirect 302 redirect from GET @app_auth_microsoft_connect (f85125)

GET https://hudsonrose.cwd-mm.com/app/login

Query Metrics

14 Database Queries
4 Different statements
7.15 ms Query time
0 Invalid entities
29 Managed entities

Queries

Group similar statements

# Time Info
1 1.09 ms
SELECT s0_.identifier AS identifier_0, s0_.value AS value_1, s0_.id AS id_2, s0_.uuid AS uuid_3, s0_.created AS created_4, s0_.modified AS modified_5 FROM system_config s0_
Parameters:
[]
2 0.97 ms
SELECT u0_.name AS name_0, u0_.email AS email_1, u0_.password AS password_2, u0_.last_active AS last_active_3, u0_.avatar AS avatar_4, u0_.archived AS archived_5, u0_.sidebar_collapsed AS sidebar_collapsed_6, u0_.microsoft_id AS microsoft_id_7, u0_.nickname AS nickname_8, u0_.email_notifications_enabled AS email_notifications_enabled_9, u0_.traditional_login_enabled AS traditional_login_enabled_10, u0_.id AS id_11, u0_.uuid AS uuid_12, u0_.created AS created_13, u0_.modified AS modified_14, u0_.role_id AS role_id_15, u0_.location_id AS location_id_16 FROM users_user u0_ LEFT JOIN users_role u1_ ON u0_.role_id = u1_.id WHERE u0_.archived IS NULL AND u0_.archived IS NULL ORDER BY u0_.name ASC
Parameters:
[]
3 0.82 ms
SELECT t0.connection_type AS connection_type_1, t0.from_email AS from_email_2, t0.from_name AS from_name_3, t0.smtp_host AS smtp_host_4, t0.smtp_port AS smtp_port_5, t0.smtp_username AS smtp_username_6, t0.smtp_password_encrypted AS smtp_password_encrypted_7, t0.smtp_encryption AS smtp_encryption_8, t0.oauth_access_token_encrypted AS oauth_access_token_encrypted_9, t0.oauth_refresh_token_encrypted AS oauth_refresh_token_encrypted_10, t0.oauth_token_expiry AS oauth_token_expiry_11, t0.oauth_microsoft_id AS oauth_microsoft_id_12, t0.status AS status_13, t0.last_tested AS last_tested_14, t0.last_test_error AS last_test_error_15, t0.id AS id_16, t0.uuid AS uuid_17, t0.created AS created_18, t0.modified AS modified_19, t0.user_id AS user_id_20 FROM mail_account t0 WHERE t0.user_id = ?
Parameters:
[
  17
]
4 0.47 ms
SELECT t0.oauth_access_token_encrypted AS oauth_access_token_encrypted_1, t0.oauth_refresh_token_encrypted AS oauth_refresh_token_encrypted_2, t0.oauth_token_expiry AS oauth_token_expiry_3, t0.calendly_user_uri AS calendly_user_uri_4, t0.calendly_organization_uri AS calendly_organization_uri_5, t0.account_email AS account_email_6, t0.account_name AS account_name_7, t0.status AS status_8, t0.last_synced AS last_synced_9, t0.last_error AS last_error_10, t0.id AS id_11, t0.uuid AS uuid_12, t0.created AS created_13, t0.modified AS modified_14, t0.user_id AS user_id_15 FROM calendar_calendly_integration t0 WHERE t0.user_id = ?
Parameters:
[
  17
]
5 0.44 ms
SELECT t0.connection_type AS connection_type_1, t0.from_email AS from_email_2, t0.from_name AS from_name_3, t0.smtp_host AS smtp_host_4, t0.smtp_port AS smtp_port_5, t0.smtp_username AS smtp_username_6, t0.smtp_password_encrypted AS smtp_password_encrypted_7, t0.smtp_encryption AS smtp_encryption_8, t0.oauth_access_token_encrypted AS oauth_access_token_encrypted_9, t0.oauth_refresh_token_encrypted AS oauth_refresh_token_encrypted_10, t0.oauth_token_expiry AS oauth_token_expiry_11, t0.oauth_microsoft_id AS oauth_microsoft_id_12, t0.status AS status_13, t0.last_tested AS last_tested_14, t0.last_test_error AS last_test_error_15, t0.id AS id_16, t0.uuid AS uuid_17, t0.created AS created_18, t0.modified AS modified_19, t0.user_id AS user_id_20 FROM mail_account t0 WHERE t0.user_id = ?
Parameters:
[
  13
]
6 0.38 ms
SELECT t0.oauth_access_token_encrypted AS oauth_access_token_encrypted_1, t0.oauth_refresh_token_encrypted AS oauth_refresh_token_encrypted_2, t0.oauth_token_expiry AS oauth_token_expiry_3, t0.calendly_user_uri AS calendly_user_uri_4, t0.calendly_organization_uri AS calendly_organization_uri_5, t0.account_email AS account_email_6, t0.account_name AS account_name_7, t0.status AS status_8, t0.last_synced AS last_synced_9, t0.last_error AS last_error_10, t0.id AS id_11, t0.uuid AS uuid_12, t0.created AS created_13, t0.modified AS modified_14, t0.user_id AS user_id_15 FROM calendar_calendly_integration t0 WHERE t0.user_id = ?
Parameters:
[
  13
]
7 0.37 ms
SELECT t0.connection_type AS connection_type_1, t0.from_email AS from_email_2, t0.from_name AS from_name_3, t0.smtp_host AS smtp_host_4, t0.smtp_port AS smtp_port_5, t0.smtp_username AS smtp_username_6, t0.smtp_password_encrypted AS smtp_password_encrypted_7, t0.smtp_encryption AS smtp_encryption_8, t0.oauth_access_token_encrypted AS oauth_access_token_encrypted_9, t0.oauth_refresh_token_encrypted AS oauth_refresh_token_encrypted_10, t0.oauth_token_expiry AS oauth_token_expiry_11, t0.oauth_microsoft_id AS oauth_microsoft_id_12, t0.status AS status_13, t0.last_tested AS last_tested_14, t0.last_test_error AS last_test_error_15, t0.id AS id_16, t0.uuid AS uuid_17, t0.created AS created_18, t0.modified AS modified_19, t0.user_id AS user_id_20 FROM mail_account t0 WHERE t0.user_id = ?
Parameters:
[
  16
]
8 0.35 ms
SELECT t0.oauth_access_token_encrypted AS oauth_access_token_encrypted_1, t0.oauth_refresh_token_encrypted AS oauth_refresh_token_encrypted_2, t0.oauth_token_expiry AS oauth_token_expiry_3, t0.calendly_user_uri AS calendly_user_uri_4, t0.calendly_organization_uri AS calendly_organization_uri_5, t0.account_email AS account_email_6, t0.account_name AS account_name_7, t0.status AS status_8, t0.last_synced AS last_synced_9, t0.last_error AS last_error_10, t0.id AS id_11, t0.uuid AS uuid_12, t0.created AS created_13, t0.modified AS modified_14, t0.user_id AS user_id_15 FROM calendar_calendly_integration t0 WHERE t0.user_id = ?
Parameters:
[
  16
]
9 0.37 ms
SELECT t0.connection_type AS connection_type_1, t0.from_email AS from_email_2, t0.from_name AS from_name_3, t0.smtp_host AS smtp_host_4, t0.smtp_port AS smtp_port_5, t0.smtp_username AS smtp_username_6, t0.smtp_password_encrypted AS smtp_password_encrypted_7, t0.smtp_encryption AS smtp_encryption_8, t0.oauth_access_token_encrypted AS oauth_access_token_encrypted_9, t0.oauth_refresh_token_encrypted AS oauth_refresh_token_encrypted_10, t0.oauth_token_expiry AS oauth_token_expiry_11, t0.oauth_microsoft_id AS oauth_microsoft_id_12, t0.status AS status_13, t0.last_tested AS last_tested_14, t0.last_test_error AS last_test_error_15, t0.id AS id_16, t0.uuid AS uuid_17, t0.created AS created_18, t0.modified AS modified_19, t0.user_id AS user_id_20 FROM mail_account t0 WHERE t0.user_id = ?
Parameters:
[
  12
]
10 0.34 ms
SELECT t0.oauth_access_token_encrypted AS oauth_access_token_encrypted_1, t0.oauth_refresh_token_encrypted AS oauth_refresh_token_encrypted_2, t0.oauth_token_expiry AS oauth_token_expiry_3, t0.calendly_user_uri AS calendly_user_uri_4, t0.calendly_organization_uri AS calendly_organization_uri_5, t0.account_email AS account_email_6, t0.account_name AS account_name_7, t0.status AS status_8, t0.last_synced AS last_synced_9, t0.last_error AS last_error_10, t0.id AS id_11, t0.uuid AS uuid_12, t0.created AS created_13, t0.modified AS modified_14, t0.user_id AS user_id_15 FROM calendar_calendly_integration t0 WHERE t0.user_id = ?
Parameters:
[
  12
]
11 0.38 ms
SELECT t0.connection_type AS connection_type_1, t0.from_email AS from_email_2, t0.from_name AS from_name_3, t0.smtp_host AS smtp_host_4, t0.smtp_port AS smtp_port_5, t0.smtp_username AS smtp_username_6, t0.smtp_password_encrypted AS smtp_password_encrypted_7, t0.smtp_encryption AS smtp_encryption_8, t0.oauth_access_token_encrypted AS oauth_access_token_encrypted_9, t0.oauth_refresh_token_encrypted AS oauth_refresh_token_encrypted_10, t0.oauth_token_expiry AS oauth_token_expiry_11, t0.oauth_microsoft_id AS oauth_microsoft_id_12, t0.status AS status_13, t0.last_tested AS last_tested_14, t0.last_test_error AS last_test_error_15, t0.id AS id_16, t0.uuid AS uuid_17, t0.created AS created_18, t0.modified AS modified_19, t0.user_id AS user_id_20 FROM mail_account t0 WHERE t0.user_id = ?
Parameters:
[
  15
]
12 0.33 ms
SELECT t0.oauth_access_token_encrypted AS oauth_access_token_encrypted_1, t0.oauth_refresh_token_encrypted AS oauth_refresh_token_encrypted_2, t0.oauth_token_expiry AS oauth_token_expiry_3, t0.calendly_user_uri AS calendly_user_uri_4, t0.calendly_organization_uri AS calendly_organization_uri_5, t0.account_email AS account_email_6, t0.account_name AS account_name_7, t0.status AS status_8, t0.last_synced AS last_synced_9, t0.last_error AS last_error_10, t0.id AS id_11, t0.uuid AS uuid_12, t0.created AS created_13, t0.modified AS modified_14, t0.user_id AS user_id_15 FROM calendar_calendly_integration t0 WHERE t0.user_id = ?
Parameters:
[
  15
]
13 0.50 ms
SELECT t0.connection_type AS connection_type_1, t0.from_email AS from_email_2, t0.from_name AS from_name_3, t0.smtp_host AS smtp_host_4, t0.smtp_port AS smtp_port_5, t0.smtp_username AS smtp_username_6, t0.smtp_password_encrypted AS smtp_password_encrypted_7, t0.smtp_encryption AS smtp_encryption_8, t0.oauth_access_token_encrypted AS oauth_access_token_encrypted_9, t0.oauth_refresh_token_encrypted AS oauth_refresh_token_encrypted_10, t0.oauth_token_expiry AS oauth_token_expiry_11, t0.oauth_microsoft_id AS oauth_microsoft_id_12, t0.status AS status_13, t0.last_tested AS last_tested_14, t0.last_test_error AS last_test_error_15, t0.id AS id_16, t0.uuid AS uuid_17, t0.created AS created_18, t0.modified AS modified_19, t0.user_id AS user_id_20 FROM mail_account t0 WHERE t0.user_id = ?
Parameters:
[
  14
]
14 0.33 ms
SELECT t0.oauth_access_token_encrypted AS oauth_access_token_encrypted_1, t0.oauth_refresh_token_encrypted AS oauth_refresh_token_encrypted_2, t0.oauth_token_expiry AS oauth_token_expiry_3, t0.calendly_user_uri AS calendly_user_uri_4, t0.calendly_organization_uri AS calendly_organization_uri_5, t0.account_email AS account_email_6, t0.account_name AS account_name_7, t0.status AS status_8, t0.last_synced AS last_synced_9, t0.last_error AS last_error_10, t0.id AS id_11, t0.uuid AS uuid_12, t0.created AS created_13, t0.modified AS modified_14, t0.user_id AS user_id_15 FROM calendar_calendly_integration t0 WHERE t0.user_id = ?
Parameters:
[
  14
]

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\System\Config\Config 21
App\Entity\Users\User 6
App\Entity\Users\Role 1
App\Entity\Locations\Location 1