Query Metrics
6
Database Queries
4
Different statements
0.72 ms
Query time
0
Invalid entities
4
Managed entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
0.34 ms (47.72%) |
1 |
SELECT c0_.id AS id_0, c0_.title AS title_1, c0_.description AS description_2, c0_.location AS location_3, c0_.ics_uid AS ics_uid_4, c0_.starts_at AS starts_at_5, c0_.ends_at AS ends_at_6, c0_.all_day AS all_day_7, c0_.color AS color_8, c0_.alarm_minutes_before AS alarm_minutes_before_9, c0_.alarm_sent_at AS alarm_sent_at_10, c0_.created_at AS created_at_11, c0_.updated_at AS updated_at_12, c0_.user_id AS user_id_13 FROM calendar_event c0_ WHERE (c0_.user_id = ? OR EXISTS (SELECT 1 FROM calendar_event_share c1_ WHERE c1_.calendar_event_id = c0_.id AND c1_.user_id IN (?))) AND c0_.alarm_minutes_before IS NOT NULL AND c0_.alarm_sent_at IS NULL AND c0_.starts_at > ?
Parameters:
[ 9 9 "2026-09-15 20:44:38" ] |
|
0.27 ms (38.34%) |
1 |
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.avatar AS avatar_7, t0.job_position AS job_position_8, t0.mailbox_view_mode AS mailbox_view_mode_9, t0.timezone AS timezone_10, t0.created_at AS created_at_11, t0.activation_token AS activation_token_12, t0.activation_token_expires_at AS activation_token_expires_at_13, t0.reset_token AS reset_token_14, t0.reset_token_expires_at AS reset_token_expires_at_15, t0.is_active AS is_active_16, t0.employment_end_date AS employment_end_date_17, t0.deactivated_at AS deactivated_at_18, t0.notifications_read_at AS notifications_read_at_19, t0.dashboard_layout AS dashboard_layout_20, t0.last_seen_at AS last_seen_at_21, t0.totp_secret AS totp_secret_22, t0.totp_enabled AS totp_enabled_23, t0.totp_enabled_at AS totp_enabled_at_24, t0.sip_extension AS sip_extension_25, t0.voip_enabled AS voip_enabled_26, t0.can_call_external AS can_call_external_27, t0.sip_secret_encrypted AS sip_secret_encrypted_28, t0.mailbox_limit AS mailbox_limit_29, t0.mail_storage_quota_mb AS mail_storage_quota_mb_30, t0.quota_suspended_at AS quota_suspended_at_31, t0.quota_locked AS quota_locked_32, t0.company_id AS company_id_33 FROM `user` t0 WHERE t0.id = ?
Parameters:
[
9
]
|
|
0.07 ms (9.21%) |
3 |
SELECT t0.id AS id_1, t0.is_default AS is_default_2, t0.platform_role AS platform_role_3, t0.permission_overrides AS permission_overrides_4, t0.created_at AS created_at_5, t0.user_id AS user_id_6, t0.tenant_id AS tenant_id_7 FROM user_tenant t0 WHERE t0.user_id = ? AND t0.tenant_id = ? LIMIT 1
Parameters:
[ 9 3 ] |
|
0.03 ms (4.72%) |
1 |
SELECT u0_.id AS id_0, u0_.is_default AS is_default_1, u0_.platform_role AS platform_role_2, u0_.permission_overrides AS permission_overrides_3, u0_.created_at AS created_at_4, t1_.id AS id_5, t1_.name AS name_6, t1_.slug AS slug_7, t1_.is_active AS is_active_8, t1_.is_platform AS is_platform_9, t1_.created_at AS created_at_10, t1_.user_slots_pool AS user_slots_pool_11, t1_.mailbox_slots_pool AS mailbox_slots_pool_12, t1_.microsoft_oauth_enabled AS microsoft_oauth_enabled_13, t1_.microsoft_oauth_tenant_id AS microsoft_oauth_tenant_id_14, t1_.microsoft_oauth_client_id AS microsoft_oauth_client_id_15, t1_.microsoft_oauth_client_secret AS microsoft_oauth_client_secret_16, t1_.microsoft_oauth_redirect_uri AS microsoft_oauth_redirect_uri_17, u0_.user_id AS user_id_18, u0_.tenant_id AS tenant_id_19 FROM user_tenant u0_ INNER JOIN tenant t1_ ON u0_.tenant_id = t1_.id WHERE u0_.user_id = ? AND t1_.is_active = 1 ORDER BY u0_.is_default DESC, t1_.name ASC
Parameters:
[
9
]
|
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\User | 1 |
| App\Entity\Company | 1 |
| App\Entity\UserTenant | 1 |
| App\Entity\Tenant | 1 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\User | No errors. |
| App\Entity\Company | No errors. |
| App\Entity\Project | No errors. |
| App\Entity\Task | No errors. |
| App\Entity\Comment | No errors. |
| App\Entity\UserEmail | No errors. |
| App\Entity\UserMailbox | No errors. |
| App\Entity\SupportLevel | No errors. |
| App\Entity\UserTenant | No errors. |
| App\Entity\Tenant | No errors. |
| App\Entity\CalendarEvent | No errors. |