GET https://api.lunagate.rhvm.net/event/019d9ae3-20d9-7372-a832-a94fd1c7b901/agenda

Query Metrics

7 Database Queries
7 Different statements
246.12 ms Query time
0 Invalid entities
7 Managed entities

Grouped Statements

Show all queries

default connection

Time Count Info
35.42 ms
(14.39%)
1
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
    __toString(): "019d9ae3-201d-7ad1-9434-6e7ad8d3f272"
  }
]
35.37 ms
(14.37%)
1
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
    __toString(): "019d3150-fddc-7640-904d-9e42560acdb9"
  }
  Symfony\Component\Uid\UuidV7 {#903
    __toString(): "019d3151-3668-79ee-8c3d-07e8d3bf0334"
  }
  "2026-04-19 15:28:27"
]
35.33 ms
(14.35%)
1
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
    __toString(): "019d9ae3-201d-7ad1-9434-6e7ad8d3f272"
  }
]
35.18 ms
(14.29%)
1
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
]
35.12 ms
(14.27%)
1
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"
]
35.05 ms
(14.24%)
1
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 15:28:27"
]
34.67 ms
(14.08%)
1
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
    __toString(): "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