Symfony Profiler

[
  "route" => "api.organisation.database.lists.show"
  "route_parameters" => [
    "_route" => "api.organisation.database.lists.show"
    "domain" => "lunagate.rhvm.net"
    "_controller" => "App\Controller\Api\OrganisationContactListController::show"
    "proxyId" => "019c059e-aa37-737c-8b9a-48863296191a"
    "listId" => "019c47ff-d440-7c95-a70a-94213d0e43d1"
  ]
  "request_uri" => "https://api.lunagate.rhvm.net/organisation/019c059e-aa37-737c-8b9a-48863296191a/database/lists/019c47ff-d440-7c95-a70a-94213d0e43d1"
  "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 => "019c059d-34d0-7844-b22d-6f9733cdff43"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#560
      +name: "STRING"
    }
  ]
]

[
  "token" => Lexik\Bundle\JWTAuthenticationBundle\Security\Authenticator\Token\JWTPostAuthenticationToken {#593
    -user: App\Entity\UserAccountList {#570 …}
    -roleNames: [
      "ROLE_USER"
    ]
    -attributes: []
    -firewallName: "api"
    -token: "eyJ0eXAiOiJKV1QiLCJhbGciOiJSUzI1NiJ9.eyJpYXQiOjE3NzA3NDM2OTAsImV4cCI6MTc3MDc0NzI5MCwicm9sZXMiOlsiUk9MRV9VU0VSIl0sInVzZXJfaWQiOiIwMTljMDU5ZC0zNGQwLTc4NDQtYjIyZC02Zjk3MzNjZGZmNDMifQ.RpUT3nKpBTgFfwULnQ74JT_maUyc_ZOcShoW4B2z_Xyumf9b_c2f7U4TT9RVm3ecHW_Hc8O23FOEpEjzz9B9ilQNGKRXa40swnDvjLURCkKGrOpv6b9mffzU7gt3tDUBpVPLADHV_NF8nnTGh8cXZixeiyhlXyF-fzTy1u1BHgE8wFzW1O2Kz3D8f__rEQGScA6ReVRZsMU11cXTjLuKWATObF_rxAqzQER3DuHAzE6T2vsZNCO2UFFGwB_sP66olNoWpBdCSEXjUETRi4rosQxF1N-e3pADoBrKDZzJrQNCwU3chUxpDYqghMjCsjWpsUDwV108wqPe8HZZQcR8aNhD_4TuV2uadYDy3Cxz41y4RlGxTBY4Odxmq2oACZ4usH0ZgEVZQZDSCwRoY2fRQuz-lTwFCtQmaUPlG44O5n5V4zvBHqzAHeHWLzkDo-U4gAJvMuEvIvMQ7MGClko_eTcKcXhKGfAIM4OtLPd7cZD6JrTdWz7ZWyC1Fx6bY2dv4a86VezBEqEs7GV_dDjhE05xP-63-hbl7f4UYvIN5J_9DgC81HHUx3ME9Ewpr0IKXRVG99d1OFDbjaaaMI7cmitDfWIQsxoY5qj0PcPdS74kaP0W_NKTmRpEe6S_uOTiRpkUr_A8-Cx_fGyJH6GGiY-o_jbQnCGLIPEPzvpJXV0"
  }
  "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 => "019c059e-aa37-737c-8b9a-48863296191a"
    2 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#560
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#879
      +name: "BOOLEAN"
    }
  ]
]

[
  "sql" => "SELECT o0_.organisation_id AS organisation_id_0, o0_.name AS name_1, o0_.plan_code AS plan_code_2, o0_.plan_selected_timestamp AS plan_selected_timestamp_3, o0_.created_timestamp AS created_timestamp_4, o0_.deleted_timestamp AS deleted_timestamp_5, o0_.deletion_scheduled_timestamp AS deletion_scheduled_timestamp_6 FROM organisation_list o0_ WHERE o0_.organisation_id = ? AND o0_.deleted_timestamp IS NULL"
  "params" => [
    1 => "019c059e-aa09-7377-bafe-e1ddd5d20c36"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#560
      +name: "STRING"
    }
  ]
]

[
  "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_.created_timestamp AS created_timestamp_6, o0_.deleted_timestamp AS deleted_timestamp_7, o0_.user_id AS user_id_8 FROM organisation_team_permission o0_ WHERE o0_.user_id = ? AND o0_.organisation_id = ? AND o0_.deleted_timestamp IS NULL"
  "params" => [
    1 => Symfony\Component\Uid\UuidV7 {#559
      #uid: "019c059d-34d0-7844-b22d-6f9733cdff43"
      toBase58: "1CXaA6MWTpyh5T8iUFRC34"
      toBase32: "01KG2STD6GF12B4BBFJWSWVZT3"
      time: "2026-01-28 17:18:34.704529 UTC"
    }
    2 => Symfony\Component\Uid\UuidV7 {#1023
      #uid: "019c059e-aa09-7377-bafe-e1ddd5d20c36"
      toBase58: "1CXaADQ1DofdtfuE2jYAjP"
      toBase32: "01KG2SXAG9EDVVNZQ1VQAX431P"
      time: "2026-01-28 17:20:10.249221 UTC"
    }
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#560
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#560}
  ]
]

[
  "sql" => "SELECT t0.list_id AS list_id_1, t0.name AS name_2, t0.description AS description_3, t0.list_type AS list_type_4, t0.query_definition AS query_definition_5, t0.created_timestamp AS created_timestamp_6, t0.updated_timestamp AS updated_timestamp_7, t0.snapshot_timestamp AS snapshot_timestamp_8, t0.deleted_timestamp AS deleted_timestamp_9, t0.organisation_id AS organisation_id_10 FROM organisation_contact_list_definition t0 WHERE t0.list_id = ?"
  "params" => [
    1 => "019c47ff-d440-7c95-a70a-94213d0e43d1"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#560
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT o0_.field_definition_id AS field_definition_id_0, o0_.field_name AS field_name_1, o0_.field_label AS field_label_2, o0_.field_type AS field_type_3, o0_.is_required AS is_required_4, o0_.display_order AS display_order_5, o0_.field_settings AS field_settings_6, o0_.created_timestamp AS created_timestamp_7, o0_.updated_timestamp AS updated_timestamp_8, o0_.deleted_timestamp AS deleted_timestamp_9, o1_.option_id AS option_id_10, o1_.option_label AS option_label_11, o1_.option_value AS option_value_12, o1_.display_order AS display_order_13, o1_.is_active AS is_active_14, o1_.created_timestamp AS created_timestamp_15, o0_.organisation_id AS organisation_id_16, o1_.field_definition_id AS field_definition_id_17 FROM organisation_contact_field_definition o0_ LEFT JOIN organisation_contact_field_option o1_ ON o0_.field_definition_id = o1_.field_definition_id WHERE o0_.organisation_id = ? AND o0_.deleted_timestamp IS NULL ORDER BY o0_.display_order ASC, o0_.field_name ASC, o1_.display_order ASC"
  "params" => [
    1 => Symfony\Component\Uid\UuidV7 {#1023
      #uid: "019c059e-aa09-7377-bafe-e1ddd5d20c36"
      toBase58: "1CXaADQ1DofdtfuE2jYAjP"
      toBase32: "01KG2SXAG9EDVVNZQ1VQAX431P"
      time: "2026-01-28 17:20:10.249221 UTC"
    }
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#560
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT o0_.contact_id AS contact_id_0, o0_.contact_email AS contact_email_1, o0_.first_name AS first_name_2, o0_.last_name AS last_name_3, o0_.tags AS tags_4, o0_.created_timestamp AS created_timestamp_5, o0_.updated_timestamp AS updated_timestamp_6, o0_.deleted_timestamp AS deleted_timestamp_7, o1_.field_id AS field_id_8, o1_.field_value AS field_value_9, o1_.created_timestamp AS created_timestamp_10, o1_.updated_timestamp AS updated_timestamp_11, o2_.field_definition_id AS field_definition_id_12, o2_.field_name AS field_name_13, o2_.field_label AS field_label_14, o2_.field_type AS field_type_15, o2_.is_required AS is_required_16, o2_.display_order AS display_order_17, o2_.field_settings AS field_settings_18, o2_.created_timestamp AS created_timestamp_19, o2_.updated_timestamp AS updated_timestamp_20, o2_.deleted_timestamp AS deleted_timestamp_21, o0_.organisation_id AS organisation_id_22, o0_.user_id AS user_id_23, o1_.contact_id AS contact_id_24, o1_.field_definition_id AS field_definition_id_25, o2_.organisation_id AS organisation_id_26 FROM organisation_contact_list o0_ LEFT JOIN organisation_contact_custom_field o1_ ON o0_.contact_id = o1_.contact_id LEFT JOIN organisation_contact_field_definition o2_ ON o1_.field_definition_id = o2_.field_definition_id WHERE o0_.organisation_id = ? AND o0_.deleted_timestamp IS NULL ORDER BY o0_.created_timestamp DESC"
  "params" => [
    1 => Symfony\Component\Uid\UuidV7 {#1023
      #uid: "019c059e-aa09-7377-bafe-e1ddd5d20c36"
      toBase58: "1CXaADQ1DofdtfuE2jYAjP"
      toBase32: "01KG2SXAG9EDVVNZQ1VQAX431P"
      time: "2026-01-28 17:20:10.249221 UTC"
    }
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#560
      +name: "STRING"
    }
  ]
]