GET https://nexiodesk.net/calendar/api/alarms/due

Query Metrics

6 Database Queries
4 Different statements
0.86 ms Query time
0 Invalid entities
4 Managed entities

Grouped Statements

Show all queries

Time Count Info
0.63 ms
(73.53%)
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:43:38"
]
0.12 ms
(14.27%)
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
(7.91%)
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.04 ms
(4.29%)
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.