Symfony Profiler

[
  "route" => "admin_conversations_show"
  "route_parameters" => [
    "_route" => "admin_conversations_show"
    "_controller" => "App\Admin\Infrastructure\Http\AdminConversationController::show"
    "id" => "019bdba2-4850-7499-be26-48c8939e0dec"
  ]
  "request_uri" => "https://mercure.terrenourriciere.org/admin/conversations/019bdba2-4850-7499-be26-48c8939e0dec"
  "method" => "GET"
]

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

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

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

[
  "params" => [
    "driver" => "pdo_pgsql"
    "idle_connection_ttl" => 600
    "host" => "database"
    "port" => 5432
    "user" => "gtvoccitanie"
    "password" => "<redacted>"
    "driverOptions" => []
    "defaultTableOptions" => []
    "dbname" => "gtvoccitanie"
    "serverVersion" => "16"
    "charset" => "utf8"
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.requester_user_id AS requester_user_id_2, t0.filiere_id AS filiere_id_3, t0.created_at AS created_at_4 FROM conversation t0 WHERE t0.id = ?"
  "params" => [
    1 => "019bdba2-4850-7499-be26-48c8939e0dec"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#898
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.user_id AS user_id_2, t0.filiere_id AS filiere_id_3, t0.joined_at AS joined_at_4, t0.left_at AS left_at_5, t0.conversation_id AS conversation_id_6 FROM conversation_participant t0 WHERE t0.conversation_id = ?"
  "params" => [
    1 => "019bdba2-4850-7499-be26-48c8939e0dec"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#898
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.author_user_id AS author_user_id_2, t0.content AS content_3, t0.created_at AS created_at_4, t0.conversation_id AS conversation_id_5 FROM message t0 WHERE t0.conversation_id = ?"
  "params" => [
    1 => "019bdba2-4850-7499-be26-48c8939e0dec"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#898
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT u0_.id AS id_0, u0_.uuid AS uuid_1, u0_.nom AS nom_2, u0_.prenom AS prenom_3, u0_.email AS email_4, u0_.email_secondaire AS email_secondaire_5, u0_.numero_ordinal AS numero_ordinal_6, u0_.telephone AS telephone_7, u0_.password_hash AS password_hash_8, u0_.status AS status_9, u0_.roles AS roles_10, u0_.departements AS departements_11, u0_.created_at AS created_at_12, u0_.filiere_id AS filiere_id_13 FROM users u0_ WHERE u0_.uuid IN (?, ?)"
  "params" => [
    1 => Symfony\Component\Uid\UuidV7 {#1063
      #uid: "019bdba1-35de-7cfb-bc05-f24b76fb2db0"
      toBase58: "1CXJisRfRJdamfzqujAFy1"
      toBase32: "01KFDT2DEYFKXVR1FJ9DVFPBDG"
      time: "2026-01-20 13:38:54.046000 UTC"
    }
    2 => Symfony\Component\Uid\UuidV7 {#1061
      #uid: "019bdba1-3832-7b7b-83b8-760640b2d9a6"
      toBase58: "1CXJisUDDDYv7Y3Bo9eyw3"
      toBase32: "01KFDT2E1JFDXR7E3P0S0B5PD6"
      time: "2026-01-20 13:38:54.642000 UTC"
    }
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#898
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#898}
  ]
]

[
  "sql" => "SELECT f0_.id AS id_0, f0_.name AS name_1, f0_.slug AS slug_2, f0_.created_at AS created_at_3 FROM filiere f0_ WHERE f0_.id IN (?)"
  "params" => [
    1 => Symfony\Component\Uid\UuidV7 {#1057
      #uid: "019bdba1-35d3-7b16-86a8-af458a1783f5"
      toBase58: "1CXJisRcgzPgVJVJGeG8Ct"
      toBase32: "01KFDT2DEKFCB8DA5F8P51F0ZN"
      time: "2026-01-20 13:38:54.035000 UTC"
    }
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#898
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT m0_.id AS id_0, m0_.storage_path AS storage_path_1, m0_.original_name AS original_name_2, m0_.mime_type AS mime_type_3, m0_.size_bytes AS size_bytes_4, m0_.created_at AS created_at_5, m0_.message_id AS message_id_6 FROM message_attachment m0_ WHERE m0_.message_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)"
  "params" => [
    1 => Symfony\Component\Uid\UuidV7 {#851
      #uid: "019bdba2-4a94-7a08-b0f4-745498d98610"
      toBase58: "1CXJixeXTrJ8ncmsEX9Loy"
      toBase32: "01KFDT4JMMF84B1X3MAJCDK1GG"
      time: "2026-01-20 13:40:04.884000 UTC"
    }
    2 => Symfony\Component\Uid\UuidV7 {#792
      #uid: "019bdba2-6ab9-7518-98d9-9ebc8afa551e"
      toBase58: "1CXJiyFi3XyT9PN8sAEsqX"
      toBase32: "01KFDT4TNSEMC9HPCYQJ5FMN8Y"
      time: "2026-01-20 13:40:13.113000 UTC"
    }
    3 => Symfony\Component\Uid\UuidV7 {#912
      #uid: "019bdba2-82c3-704d-93bc-b821ab551162"
      toBase58: "1CXJiyi25SrN9mkjHhuBZT"
      toBase32: "01KFDT50P3E16S7F5R46NNA4B2"
      time: "2026-01-20 13:40:19.267000 UTC"
    }
    4 => Symfony\Component\Uid\UuidV7 {#919
      #uid: "019bdba4-5bc1-7d1e-8da5-e7bf433ab4a2"
      toBase58: "1CXJj8diNzTk9881QAJFxV"
      toBase32: "01KFDT8PY1FMF8V9F7QX1KND52"
      time: "2026-01-20 13:42:20.353000 UTC"
    }
    5 => Symfony\Component\Uid\UuidV7 {#926
      #uid: "019bdba4-80c2-7d3e-b5ac-d9ae83bcda6c"
      toBase58: "1CXJj9LDSr1pUzaXEr3sDm"
      toBase32: "01KFDT9062FMZBBB6SNT1VSPKC"
      time: "2026-01-20 13:42:29.826000 UTC"
    }
    6 => Symfony\Component\Uid\UuidV7 {#947
      #uid: "019bdba5-f81d-7f9e-9b6b-07249e56c57c"
      toBase58: "1CXJjGR3c6WoRhmgJJTyTy"
      toBase32: "01KFDTBY0XFYF9PTR74JF5DHBW"
      time: "2026-01-20 13:44:05.917000 UTC"
    }
    7 => Symfony\Component\Uid\UuidV7 {#954
      #uid: "019bdbc7-0be1-7d12-8bd7-d32d7e25d1f3"
      toBase58: "1CXJn2D6imn4PfUKjWmwLW"
      toBase32: "01KFDWE2Z1FM98QNYK5NZ2BMFK"
      time: "2026-01-20 14:20:13.665000 UTC"
    }
    8 => Symfony\Component\Uid\UuidV7 {#961
      #uid: "019bdbc8-6011-77b0-b44c-6147be6ce4c8"
      toBase58: "1CXJn8dSMY2hz6Ab36PvUw"
      toBase32: "01KFDWGR0HEYRB8K318YZ6SS68"
      time: "2026-01-20 14:21:40.753000 UTC"
    }
    9 => Symfony\Component\Uid\UuidV7 {#968
      #uid: "019bdbc8-78c6-7f43-b3d6-70aba6e7c539"
      toBase58: "1CXJn96UoZHc4MuRmbDa1N"
      toBase32: "01KFDWGY66FX1V7NKGNEKEFH9S"
      time: "2026-01-20 14:21:47.078000 UTC"
    }
    10 => Symfony\Component\Uid\UuidV7 {#975
      #uid: "019bdbc8-994e-7e94-a13f-255dc9cc1f92"
      toBase58: "1CXJn9i5wMQ7SukBasWoSh"
      toBase32: "01KFDWH6AEFTAA2FS5BQ4WR7WJ"
      time: "2026-01-20 14:21:55.406000 UTC"
    }
    11 => Symfony\Component\Uid\UuidV7 {#982
      #uid: "019bdbc8-a72c-7753-a4e7-f894512d92ce"
      toBase58: "1CXJn9yGEykCXWX9FX9ETw"
      toBase32: "01KFDWH9SCEX9T9SZRJH8JV4PE"
      time: "2026-01-20 14:21:58.956000 UTC"
    }
    12 => Symfony\Component\Uid\UuidV7 {#989
      #uid: "019bdbc8-b558-7953-bac6-4d52a9b049fe"
      toBase58: "1CXJnAEmtxszcRsn787WCD"
      toBase32: "01KFDWHDARF59VNHJDAAMV0JFY"
      time: "2026-01-20 14:22:02.584000 UTC"
    }
    13 => Symfony\Component\Uid\UuidV7 {#996
      #uid: "019bdbc9-4f7f-7f24-b558-516c19aaad5f"
      toBase58: "1CXJnD9Vjf8R6R8cj5qcF8"
      toBase32: "01KFDWJKVZFWJBAP2HDGCTNBAZ"
      time: "2026-01-20 14:22:42.047000 UTC"
    }
    14 => Symfony\Component\Uid\UuidV7 {#1003
      #uid: "019bdbcb-6819-7f51-bb76-bbe1d2293e8e"
      toBase58: "1CXJnPGp3rSeEvU5MV91aM"
      toBase32: "01KFDWPT0SFX8VPXNVW792JFME"
      time: "2026-01-20 14:24:59.417000 UTC"
    }
    15 => Symfony\Component\Uid\UuidV7 {#933
      #uid: "019bdbce-dcee-7f6d-9130-10655cc73cb8"
      toBase58: "1CXJnfyGambidKTMwHNNWj"
      toBase32: "01KFDWXQ7EFXPS2C0GCNECEF5R"
      time: "2026-01-20 14:28:45.934000 UTC"
    }
    16 => Symfony\Component\Uid\UuidV7 {#940
      #uid: "019bdbcf-8e9b-7d25-b883-75e5060c03b4"
      toBase58: "1CXJnjKjihCMVHjzWk912j"
      toBase32: "01KFDWZ3MVFMJVH0VNWM30R0XM"
      time: "2026-01-20 14:29:31.419000 UTC"
    }
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#898
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#898}
    3 => Doctrine\DBAL\ParameterType {#898}
    4 => Doctrine\DBAL\ParameterType {#898}
    5 => Doctrine\DBAL\ParameterType {#898}
    6 => Doctrine\DBAL\ParameterType {#898}
    7 => Doctrine\DBAL\ParameterType {#898}
    8 => Doctrine\DBAL\ParameterType {#898}
    9 => Doctrine\DBAL\ParameterType {#898}
    10 => Doctrine\DBAL\ParameterType {#898}
    11 => Doctrine\DBAL\ParameterType {#898}
    12 => Doctrine\DBAL\ParameterType {#898}
    13 => Doctrine\DBAL\ParameterType {#898}
    14 => Doctrine\DBAL\ParameterType {#898}
    15 => Doctrine\DBAL\ParameterType {#898}
    16 => Doctrine\DBAL\ParameterType {#898}
  ]
]