Symfony Profiler

[
  "route" => "api.event.agenda.index"
  "route_parameters" => [
    "_route" => "api.event.agenda.index"
    "domain" => "lunagate.rhvm.net"
    "_controller" => "App\Controller\Api\EventAgendaController::index"
    "proxyId" => "019d9ae3-20d9-7372-a832-a94fd1c7b901"
  ]
  "request_uri" => "https://api.lunagate.rhvm.net/event/019d9ae3-20d9-7372-a832-a94fd1c7b901/agenda"
  "method" => "GET"
]

[
  "firewall_name" => "api"
  "authenticators" => 1
]

[
  "firewall_name" => "api"
  "authenticator" => "Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator"
]

[
  "params" => [
    "persistent" => false
    "driver" => "pdo_pgsql"
    "idle_connection_ttl" => 600
    "host" => "ep-crimson-sea-ab9kdsu7-pooler.eu-west-2.aws.neon.tech"
    "port" => null
    "user" => "Designer326773"
    "password" => "<redacted>"
    "driverOptions" => []
    "serverVersion" => "17"
    "defaultTableOptions" => []
    "dbname" => "odin_general"
    "sslmode" => "require"
    "channel_binding" => "require"
    "charset" => "utf8"
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "019d3150-fddc-7640-904d-9e42560acdb9"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#568
      +name: "STRING"
    }
  ]
]

[
  "token" => Lexik\Bundle\JWTAuthenticationBundle\Security\Authenticator\Token\JWTPostAuthenticationToken {#600
    -user: App\Entity\UserAccountList {#576 …}
    -roleNames: [
      "ROLE_USER"
    ]
    -attributes: []
    -firewallName: "api"
    -token: "eyJ0eXAiOiJKV1QiLCJhbGciOiJSUzI1NiJ9.eyJpYXQiOjE3NzY2MjMyMzYsImV4cCI6MTc3NjYyNjgzNiwicm9sZXMiOlsiUk9MRV9VU0VSIl0sInVzZXJfaWQiOiIwMTlkMzE1MC1mZGRjLTc2NDAtOTA0ZC05ZTQyNTYwYWNkYjkifQ.uTpNu1sV1jjGhKZ7dLPwsLULLOBSKEhOy8-g88Zaqn3HMt4qCnTcC-MRIHrZaDJdd2PtJA0Pheqw8t6gRYw6K1I3jijLm1v0u5d3Hu9cPwbOCyM920_4jgx1E-m3lR5kKhgYdTuQjomRNdynhnY6dMX1R2mbqnRhdIBCR9ChXH1rMzShvMQHH9669LBlTSS9n3zKNW88H2WETXyMq002FZ__5vC4k4D3kD3xpdF0uxJzCck9s7J3jWOXVSXXjXxijdsIFdDbGsVT21PzOCwUnjIxkVmYj6VcsgwANeuZkYsu96JuJ9ckW2LEuLrD67351nghrn6tRYYwLOFCQQdEXlDySPUH2mRr4ihYd4_gflYsXqEUL6iplm186AaOASsYfrKUY2TgzTMXpWUNpuOs6_gdOb_zViW0upNnOfY4LC0SEUCr0ddsKy-FytfQeT5GekX2D7ccDl9ov2uqcMlQ_M_c3qp7i3Ll2azVgsHYa2-yvWPdtW29ZgJsdyiUTnoubUhrFpH9z9UXCWlvdW9MKYR0xxUX2BvKyS2EJ5sKPizPCvlCRsEdVT0fdpi21Jow_JkoISgZW3xGjpJ1USR7jydDU_NTpD_zv08-4gqyuH2S__SsXbQPB_b27M7o5_ZFFOQxiWvXpiAc2_72TzvuwltNC6LmVNp54BDcc67-VFA"
  }
  "authenticator" => "Lexik\Bundle\JWTAuthenticationBundle\Security\Authenticator\JWTAuthenticator"
]

[
  "authenticator" => "Lexik\Bundle\JWTAuthenticationBundle\Security\Authenticator\JWTAuthenticator"
]

[
  "sql" => "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"
  "params" => [
    1 => "019d9ae3-20d9-7372-a832-a94fd1c7b901"
    2 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#568
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#834
      +name: "BOOLEAN"
    }
  ]
]

[
  "sql" => "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 > ?))"
  "params" => [
    1 => "019d9ae3-201d-7ad1-9434-6e7ad8d3f272"
    2 => "2026-04-19 18:33:05"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#568
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#568}
  ]
]

[
  "sql" => "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 > ?))"
  "params" => [
    1 => Symfony\Component\Uid\UuidV7 {#567
      #uid: "019d3150-fddc-7640-904d-9e42560acdb9"
      toBase58: "1CZULaPrDRDvwLRxGJkQ7z"
      toBase32: "01KMRN1ZEWES090KCY89B0NKDS"
      time: "2026-03-27 22:01:24.700400 UTC"
    }
    2 => Symfony\Component\Uid\UuidV7 {#903
      #uid: "019d3151-3668-79ee-8c3d-07e8d3bf0334"
      toBase58: "1CZULbTjuLvca6c3vrbQBu"
      toBase32: "01KMRN2DK8F7Q8RF87X39VY0SM"
      time: "2026-03-27 22:01:39.176635 UTC"
    }
    3 => "2026-04-19 18:33:05"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#568
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#568}
    3 => Doctrine\DBAL\ParameterType {#568}
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => Symfony\Component\Uid\UuidV7 {#1020
      #uid: "019d9ae3-201d-7ad1-9434-6e7ad8d3f272"
      toBase58: "1Ca99e3Byz4JxQ2UMp6mpd"
      toBase32: "01KPDE680XFB8S8D3EFBCD7WKJ"
      time: "2026-04-17 10:01:09.405692 UTC"
    }
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#568
      +name: "STRING"
    }
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => Symfony\Component\Uid\UuidV7 {#1020
      #uid: "019d9ae3-201d-7ad1-9434-6e7ad8d3f272"
      toBase58: "1Ca99e3Byz4JxQ2UMp6mpd"
      toBase32: "01KPDE680XFB8S8D3EFBCD7WKJ"
      time: "2026-04-17 10:01:09.405692 UTC"
    }
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#568
      +name: "STRING"
    }
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => Symfony\Component\Uid\UuidV7 {#1020
      #uid: "019d9ae3-201d-7ad1-9434-6e7ad8d3f272"
      toBase58: "1Ca99e3Byz4JxQ2UMp6mpd"
      toBase32: "01KPDE680XFB8S8D3EFBCD7WKJ"
      time: "2026-04-17 10:01:09.405692 UTC"
    }
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#568
      +name: "STRING"
    }
  ]
]