Query Metrics
6
Database Queries
6
Different statements
2.34 ms
Query time
0
Invalid entities
9
Managed entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 0.41 ms |
SELECT t0.id AS id_1, t0.email AS email_2, t0.is_guest AS is_guest_3, t0.guest_token AS guest_token_4, t0.one_shot AS one_shot_5, t0.roles_json AS roles_json_6, t0.account_totp_secret AS account_totp_secret_7, t0.account_totp_enabled AS account_totp_enabled_8, t0.account_totp_enabled_at AS account_totp_enabled_at_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11 FROM users t0 WHERE t0.guest_token = ? AND t0.is_guest = ? LIMIT 1
Parameters:
[ "962625e7f2398802d245b59c5c7f3700e0d33fa8fa3d0eef276e225d26a0012a" 1 ]
|
||||||||||||||||||||||||||||||||
| 2 | 0.32 ms |
SELECT t0.id AS id_1, t0.email AS email_2, t0.status AS status_3, t0.last_error AS last_error_4, t0.estimated_size_bytes AS estimated_size_bytes_5, t0.migrated_bytes AS migrated_bytes_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.user_id AS user_id_9, t0.domain_id AS domain_id_10 FROM mailboxes t0 WHERE t0.id = ?
Parameters:
[
1
]
|
||||||||||||||||||||||||||||||||
| 3 | 0.40 ms |
SELECT t0.id AS id_1, t0.email AS email_2, t0.status AS status_3, t0.last_error AS last_error_4, t0.estimated_size_bytes AS estimated_size_bytes_5, t0.migrated_bytes AS migrated_bytes_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.user_id AS user_id_9, t0.domain_id AS domain_id_10 FROM mailboxes t0 WHERE t0.user_id = ? ORDER BY t0.id DESC
Parameters:
[
1
]
|
||||||||||||||||||||||||||||||||
| 4 | 0.30 ms |
SELECT t0.id AS id_1, t0.domain AS domain_2, t0.mailbox_count AS mailbox_count_3, t0.totp_secret AS totp_secret_4, t0.totp_enabled AS totp_enabled_5, t0.totp_enabled_at AS totp_enabled_at_6, t0.user_id AS user_id_7 FROM domains t0 WHERE t0.id = ?
Parameters:
[
1
]
|
||||||||||||||||||||||||||||||||
| 5 | 0.38 ms |
SELECT t0.id AS id_1, t0.email AS email_2, t0.status AS status_3, t0.last_error AS last_error_4, t0.imap_host AS imap_host_5, t0.imap_port AS imap_port_6, t0.imap_encryption AS imap_encryption_7, t0.login AS login_8, t0.last_synced_at AS last_synced_at_9, t0.estimated_size_bytes AS estimated_size_bytes_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.mailbox_id AS mailbox_id_13, t0.credential_id AS credential_id_14 FROM mailbox_sources t0 WHERE t0.mailbox_id = ? ORDER BY t0.id DESC
Parameters:
[
1
]
|
||||||||||||||||||||||||||||||||
| 6 | 0.52 ms |
SELECT t0.id AS id_1, t0.kind AS kind_2, t0.imap_host AS imap_host_3, t0.imap_port AS imap_port_4, t0.imap_encryption AS imap_encryption_5, t0.login AS login_6, t0.connection_test_status AS connection_test_status_7, t0.connection_test_error AS connection_test_error_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.mailbox_id AS mailbox_id_11, t0.credential_id AS credential_id_12 FROM mailbox_endpoints t0 WHERE t0.mailbox_id = ?
Parameters:
[
1
]
|
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\Credential | 3 |
| App\Entity\MailboxSource | 2 |
| App\Entity\User | 1 |
| App\Entity\Mailbox | 1 |
| App\Entity\Domain | 1 |
| App\Entity\MailboxEndpoint | 1 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\User | No errors. |
| App\Entity\Mailbox | No errors. |
| App\Entity\Domain | No errors. |
| App\Entity\MailboxEndpoint | No errors. |
| App\Entity\MailboxSource | No errors. |
| App\Entity\Credential | No errors. |