Query Metrics
7
Database Queries
7
Different statements
234.18 ms
Query time
0
Invalid entities
7
Managed entities
Queries
default connection
| #▲ | Time | Info | ||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 32.88 ms |
SELECT t0.user_id AS user_id_1, t0.password AS password_2, t0.roles AS roles_3, t0.first_name AS first_name_4, t0.last_name AS last_name_5, t0.is_banned AS is_banned_6, t0.created_timestamp AS created_timestamp_7, t0.deleted_timestamp AS deleted_timestamp_8, t0.must_login_after AS must_login_after_9 FROM user_account_list t0 WHERE t0.user_id = ? LIMIT 1
Parameters:
[
"019d3150-fddc-7640-904d-9e42560acdb9"
]
|
||||||||||||||||||||||||||||||||
| 2 | 33.38 ms |
SELECT t0.proxy_id AS proxy_id_1, t0.organisation_id AS organisation_id_2, t0.resource_type AS resource_type_3, t0.resource_id AS resource_id_4, t0.is_active AS is_active_5, t0.created_timestamp AS created_timestamp_6, t0.deleted_timestamp AS deleted_timestamp_7 FROM organisation_resource_proxy t0 WHERE t0.proxy_id = ? AND t0.is_active = ? LIMIT 1
Parameters:
[ "019d9ae3-20d9-7372-a832-a94fd1c7b901" 1 ]
|
||||||||||||||||||||||||||||||||
| 3 | 33.38 ms |
SELECT s0_.space_id AS space_id_0, s0_.space_type AS space_type_1, s0_.name AS name_2, s0_.public_subdomain AS public_subdomain_3, s0_.public_slug AS public_slug_4, s0_.custom_domain AS custom_domain_5, s0_.cover_image_transform AS cover_image_transform_6, s0_.article_review_enabled AS article_review_enabled_7, s0_.article_reviewer_user_ids AS article_reviewer_user_ids_8, s0_.created_timestamp AS created_timestamp_9, s0_.deleted_timestamp AS deleted_timestamp_10, s0_.organisation_id AS organisation_id_11, s0_.parent_space_id AS parent_space_id_12, s0_.cover_file_reference_id AS cover_file_reference_id_13, s0_.mail_identity_id AS mail_identity_id_14 FROM spaces_list s0_ WHERE s0_.space_id = ? AND ((s0_.deleted_timestamp IS NULL OR s0_.deleted_timestamp > ?))
Parameters:
[ "019d9ae3-201d-7ad1-9434-6e7ad8d3f272" "2026-04-19 18:33:05" ]
|
||||||||||||||||||||||||||||||||
| 4 | 33.56 ms |
SELECT o0_.id AS id_0, o0_.contact_id AS contact_id_1, o0_.organisation_id AS organisation_id_2, o0_.scope_type AS scope_type_3, o0_.scope_id AS scope_id_4, o0_.permission_level AS permission_level_5, o0_.is_cascading AS is_cascading_6, o0_.created_timestamp AS created_timestamp_7, o0_.deleted_timestamp AS deleted_timestamp_8, o0_.user_id AS user_id_9 FROM organisation_team_permission o0_ WHERE o0_.user_id = ? AND o0_.organisation_id = ? AND ((o0_.deleted_timestamp IS NULL OR o0_.deleted_timestamp > ?))
Parameters:
[ Symfony\Component\Uid\UuidV7 {#567 : "019d3150-fddc-7640-904d-9e42560acdb9" } Symfony\Component\Uid\UuidV7 {#903 : "019d3151-3668-79ee-8c3d-07e8d3bf0334" } "2026-04-19 18:33:05" ]
|
||||||||||||||||||||||||||||||||
| 5 | 33.51 ms |
SELECT e0_.date_id AS date_id_0, e0_.agenda_date AS agenda_date_1, e0_.agenda_timezone AS agenda_timezone_2, e0_.display_order AS display_order_3, e0_.created_timestamp AS created_timestamp_4, e0_.updated_timestamp AS updated_timestamp_5, e1_.stream_id AS stream_id_6, e1_.stream_name AS stream_name_7, e1_.stream_color AS stream_color_8, e1_.display_order AS display_order_9, e1_.created_timestamp AS created_timestamp_10, e1_.updated_timestamp AS updated_timestamp_11, e0_.space_id AS space_id_12, e1_.space_id AS space_id_13, e1_.date_id AS date_id_14 FROM event_agenda_date e0_ LEFT JOIN event_agenda_stream e1_ ON e0_.date_id = e1_.date_id WHERE e0_.space_id = ? ORDER BY e0_.display_order ASC, e0_.agenda_date ASC
Parameters:
[ Symfony\Component\Uid\UuidV7 {#1020 : "019d9ae3-201d-7ad1-9434-6e7ad8d3f272" } ]
|
||||||||||||||||||||||||||||||||
| 6 | 34.08 ms |
SELECT e0_.stream_id AS stream_id_0, e0_.stream_name AS stream_name_1, e0_.stream_color AS stream_color_2, e0_.display_order AS display_order_3, e0_.created_timestamp AS created_timestamp_4, e0_.updated_timestamp AS updated_timestamp_5, e1_.date_id AS date_id_6, e1_.agenda_date AS agenda_date_7, e1_.agenda_timezone AS agenda_timezone_8, e1_.display_order AS display_order_9, e1_.created_timestamp AS created_timestamp_10, e1_.updated_timestamp AS updated_timestamp_11, e2_.session_id AS session_id_12, e2_.session_title AS session_title_13, e2_.session_description AS session_description_14, e2_.session_type AS session_type_15, e2_.start_time AS start_time_16, e2_.end_time AS end_time_17, e2_.session_timezone AS session_timezone_18, e2_.display_order AS display_order_19, e2_.created_timestamp AS created_timestamp_20, e2_.updated_timestamp AS updated_timestamp_21, e0_.space_id AS space_id_22, e0_.date_id AS date_id_23, e1_.space_id AS space_id_24, e2_.stream_id AS stream_id_25, e2_.ondemand_video_file_reference_id AS ondemand_video_file_reference_id_26 FROM event_agenda_stream e0_ LEFT JOIN event_agenda_date e1_ ON e0_.date_id = e1_.date_id LEFT JOIN event_agenda_session e2_ ON e0_.stream_id = e2_.stream_id WHERE e0_.space_id = ? ORDER BY e0_.display_order ASC, e0_.stream_name ASC
Parameters:
[ Symfony\Component\Uid\UuidV7 {#1020 : "019d9ae3-201d-7ad1-9434-6e7ad8d3f272" } ]
|
||||||||||||||||||||||||||||||||
| 7 | 33.39 ms |
SELECT e0_.session_id AS session_id_0, e0_.session_title AS session_title_1, e0_.session_description AS session_description_2, e0_.session_type AS session_type_3, e0_.start_time AS start_time_4, e0_.end_time AS end_time_5, e0_.session_timezone AS session_timezone_6, e0_.display_order AS display_order_7, e0_.created_timestamp AS created_timestamp_8, e0_.updated_timestamp AS updated_timestamp_9, e0_.stream_id AS stream_id_10, e0_.ondemand_video_file_reference_id AS ondemand_video_file_reference_id_11 FROM event_agenda_session e0_ INNER JOIN event_agenda_stream e1_ ON e0_.stream_id = e1_.stream_id WHERE e1_.space_id = ? ORDER BY e1_.display_order ASC, e0_.display_order ASC, e0_.start_time ASC
Parameters:
[ Symfony\Component\Uid\UuidV7 {#1020 : "019d9ae3-201d-7ad1-9434-6e7ad8d3f272" } ]
|
Database Connections
| Name | Service |
|---|---|
| default | doctrine.dbal.default_connection |
| read_only | doctrine.dbal.read_only_connection |
Entity Managers
| Name | Service |
|---|---|
| default | doctrine.orm.default_entity_manager |
| read_only | doctrine.orm.read_only_entity_manager |
Second Level Cache
Second Level Cache is not enabled.
Managed Entities
default entity manager
| Class | Amount of managed objects |
|---|---|
| App\Entity\SpaceList | 2 |
| App\Entity\UserAccountList | 1 |
| App\Entity\OrganisationResourceProxy | 1 |
| App\Entity\OrganisationList | 1 |
| App\Entity\OrganisationMailIdentity | 1 |
| App\Entity\OrganisationTeamPermission | 1 |
read_only entity manager
| Class | Amount of managed objects |
|---|
Entities Mapping
default entity manager
| Class | Mapping errors |
|---|---|
| App\Entity\UserAccountList | No errors. |
| App\Entity\UserAccountEmail | No errors. |
| App\Entity\OrganisationResourceProxy | No errors. |
| App\Entity\SpaceList | No errors. |
| App\Entity\OrganisationList | No errors. |
| App\Entity\OrganisationStorageFileReference | No errors. |
| App\Entity\OrganisationMailIdentity | No errors. |
| App\Entity\OrganisationTeamPermission | No errors. |
| App\Entity\EventAgendaDate | No errors. |
| App\Entity\EventAgendaStream | No errors. |
| App\Entity\EventAgendaSession | No errors. |
read_only entity manager
No loaded entities.