Symfony Profiler

[
  "route" => "app_home"
  "route_parameters" => [
    "_route" => "app_home"
    "_controller" => "App\Controller\HomeController::index"
  ]
  "request_uri" => "https://rempla.otwoo.tech/"
  "method" => "GET"
]

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

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

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

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\DebugHandlersListener::configure"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\ValidateRequestListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Bridge\Doctrine\Middleware\IdleConnection\Listener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\SessionListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\LocaleListener::setDefaultLocale"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\AssetMapper\AssetMapperDevServerSubscriber::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\RouterListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\LocaleListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\LocaleAwareListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::configureLogoutUrlGenerator"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::onKernelRequest"
]

[
  "event" => "kernel.controller"
  "listener" => "Symfony\Bundle\FrameworkBundle\DataCollector\RouterDataCollector::onKernelController"
]

[
  "event" => "kernel.controller"
  "listener" => "Symfony\Component\HttpKernel\DataCollector\RequestDataCollector::onKernelController"
]

[
  "event" => "kernel.controller_arguments"
  "listener" => "Symfony\Component\Security\Http\EventListener\IsCsrfTokenValidAttributeListener::onKernelControllerArguments"
]

[
  "event" => "kernel.controller_arguments"
  "listener" => "Symfony\Component\Security\Http\EventListener\IsGrantedAttributeListener::onKernelControllerArguments"
]

[
  "event" => "kernel.controller_arguments"
  "listener" => "Symfony\Component\HttpKernel\EventListener\CacheAttributeListener::onKernelControllerArguments"
]

[
  "event" => "kernel.controller_arguments"
  "listener" => "ContainerGGAwJGv\RequestPayloadValueResolverGhost01ca9cc::onKernelControllerArguments"
]

[
  "event" => "kernel.controller_arguments"
  "listener" => "Symfony\Component\HttpKernel\EventListener\ErrorListener::onControllerArguments"
]

[
  "event" => "debug.security.authorization.vote"
  "listener" => "Symfony\Bundle\SecurityBundle\EventListener\VoteListener::onVoterVote"
]

[
  "event" => "Symfony\UX\TwigComponent\Event\PreRenderEvent"
  "listener" => "Symfony\UX\TwigComponent\EventListener\TwigComponentLoggerListener::onPreRender"
]

[
  "params" => [
    "use_savepoints" => true
    "driver" => "pdo_mysql"
    "idle_connection_ttl" => 600
    "host" => "127.0.0.1"
    "port" => 3306
    "user" => "otwoodb"
    "password" => "<redacted>"
    "driverOptions" => []
    "defaultTableOptions" => []
    "dbname" => "remplaclinic_web"
    "charset" => "utf8mb4"
  ]
]

[
  "sql" => "SELECT COUNT(DISTINCT u.id) AS total FROM user u INNER JOIN user_user_role r ON u.id = r.user_id AND r.user_role_id = ? WHERE u.status = 1"
  "params" => [
    1 => 4
  ]
  "types" => [
    1 => 2
  ]
]

[
  "event" => "Symfony\UX\TwigComponent\Event\PreRenderEvent"
  "listener" => "Symfony\UX\TwigComponent\EventListener\TwigComponentLoggerListener::onPreRender"
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2 FROM region t0"
]

[
  "event" => "Symfony\UX\TwigComponent\Event\PostRenderEvent"
  "listener" => "Symfony\UX\TwigComponent\EventListener\TwigComponentLoggerListener::onPostRender"
]

[
  "event" => "Symfony\UX\TwigComponent\Event\PreRenderEvent"
  "listener" => "Symfony\UX\TwigComponent\EventListener\TwigComponentLoggerListener::onPreRender"
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.speciality_parent_id AS speciality_parent_id_3 FROM speciality t0"
]

[
  "event" => "Symfony\UX\TwigComponent\Event\PostRenderEvent"
  "listener" => "Symfony\UX\TwigComponent\EventListener\TwigComponentLoggerListener::onPostRender"
]

[
  "event" => "Symfony\UX\TwigComponent\Event\PostRenderEvent"
  "listener" => "Symfony\UX\TwigComponent\EventListener\TwigComponentLoggerListener::onPostRender"
]

[
  "event" => "Symfony\UX\TwigComponent\Event\PreRenderEvent"
  "listener" => "Symfony\UX\TwigComponent\EventListener\TwigComponentLoggerListener::onPreRender"
]

[
  "sql" => "SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.logo AS logo_2 FROM partenaire_logo p0_ ORDER BY p0_.id DESC"
]

[
  "event" => "Symfony\UX\TwigComponent\Event\PostRenderEvent"
  "listener" => "Symfony\UX\TwigComponent\EventListener\TwigComponentLoggerListener::onPostRender"
]

[
  "event" => "Symfony\UX\TwigComponent\Event\PreRenderEvent"
  "listener" => "Symfony\UX\TwigComponent\EventListener\TwigComponentLoggerListener::onPreRender"
]

[
  "sql" => "SELECT r0_.id AS id_0, r0_.title AS title_1, r0_.status AS status_2, r0_.started_at AS started_at_3, r0_.show_end_at AS show_end_at_4, r0_.end_at AS end_at_5, r0_.last_sent_at AS last_sent_at_6, r0_.request_type AS request_type_7, r0_.remuneration AS remuneration_8, r0_.comment AS comment_9, r0_.position_count AS position_count_10, r0_.accomodation_included AS accomodation_included_11, r0_.transport_cost_refunded AS transport_cost_refunded_12, r0_.retrocession AS retrocession_13, r0_.replacement_type AS replacement_type_14, r0_.created_at AS created_at_15, r0_.response_count AS response_count_16, r0_.applicant_id AS applicant_id_17, r0_.region_id AS region_id_18, r0_.speciality_id AS speciality_id_19 FROM request r0_ LEFT JOIN speciality s1_ ON r0_.speciality_id = s1_.id LEFT JOIN user u2_ ON r0_.applicant_id = u2_.id WHERE r0_.status = ? AND r0_.request_type = ? ORDER BY r0_.created_at DESC LIMIT 4"
  "params" => [
    1 => 1
    2 => "replacement"
  ]
  "types" => [
    1 => 1
    2 => 2
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.ordinary_number AS ordinary_number_2, t0.civility AS civility_3, t0.surname AS surname_4, t0.name AS name_5, t0.year_of_birth AS year_of_birth_6, t0.nationality AS nationality_7, t0.email AS email_8, t0.password AS password_9, t0.status AS status_10, t0.telephone AS telephone_11, t0.telephone2 AS telephone2_12, t0.fax AS fax_13, t0.position AS position_14, t0.organism AS organism_15, t0.year_of_alternance AS year_of_alternance_16, t0.current_speciality AS current_speciality_17, t0.comment AS comment_18, t0.create_at AS create_at_19, t0.user_comment AS user_comment_20, t0.cv AS cv_21, t0.diplom AS diplom_22, t0.licence AS licence_23, t0.address_id AS address_id_24, t0.speciality_id AS speciality_id_25, t0.establishment_id AS establishment_id_26, t0.subscription_id AS subscription_id_27 FROM user t0 WHERE t0.id = ?"
  "params" => [
    1 => 70237
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.role AS role_2 FROM user_role t0 INNER JOIN user_user_role ON t0.id = user_user_role.user_role_id WHERE user_user_role.user_id = ?"
  "params" => [
    1 => 70237
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.beds_count AS beds_count_3, t0.site_web AS site_web_4, t0.consultation_count AS consultation_count_5, t0.per AS per_6, t0.service_name AS service_name_7, t0.chief_service_name AS chief_service_name_8 FROM user_establishment t0 WHERE t0.id = ?"
  "params" => [
    1 => 70231
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.ordinary_number AS ordinary_number_2, t0.civility AS civility_3, t0.surname AS surname_4, t0.name AS name_5, t0.year_of_birth AS year_of_birth_6, t0.nationality AS nationality_7, t0.email AS email_8, t0.password AS password_9, t0.status AS status_10, t0.telephone AS telephone_11, t0.telephone2 AS telephone2_12, t0.fax AS fax_13, t0.position AS position_14, t0.organism AS organism_15, t0.year_of_alternance AS year_of_alternance_16, t0.current_speciality AS current_speciality_17, t0.comment AS comment_18, t0.create_at AS create_at_19, t0.user_comment AS user_comment_20, t0.cv AS cv_21, t0.diplom AS diplom_22, t0.licence AS licence_23, t0.address_id AS address_id_24, t0.speciality_id AS speciality_id_25, t0.establishment_id AS establishment_id_26, t0.subscription_id AS subscription_id_27 FROM user t0 WHERE t0.id = ?"
  "params" => [
    1 => 6922
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.role AS role_2 FROM user_role t0 INNER JOIN user_user_role ON t0.id = user_user_role.user_role_id WHERE user_user_role.user_id = ?"
  "params" => [
    1 => 6922
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.beds_count AS beds_count_3, t0.site_web AS site_web_4, t0.consultation_count AS consultation_count_5, t0.per AS per_6, t0.service_name AS service_name_7, t0.chief_service_name AS chief_service_name_8 FROM user_establishment t0 WHERE t0.id = ?"
  "params" => [
    1 => 6922
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.ordinary_number AS ordinary_number_2, t0.civility AS civility_3, t0.surname AS surname_4, t0.name AS name_5, t0.year_of_birth AS year_of_birth_6, t0.nationality AS nationality_7, t0.email AS email_8, t0.password AS password_9, t0.status AS status_10, t0.telephone AS telephone_11, t0.telephone2 AS telephone2_12, t0.fax AS fax_13, t0.position AS position_14, t0.organism AS organism_15, t0.year_of_alternance AS year_of_alternance_16, t0.current_speciality AS current_speciality_17, t0.comment AS comment_18, t0.create_at AS create_at_19, t0.user_comment AS user_comment_20, t0.cv AS cv_21, t0.diplom AS diplom_22, t0.licence AS licence_23, t0.address_id AS address_id_24, t0.speciality_id AS speciality_id_25, t0.establishment_id AS establishment_id_26, t0.subscription_id AS subscription_id_27 FROM user t0 WHERE t0.id = ?"
  "params" => [
    1 => 64951
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.role AS role_2 FROM user_role t0 INNER JOIN user_user_role ON t0.id = user_user_role.user_role_id WHERE user_user_role.user_id = ?"
  "params" => [
    1 => 64951
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.beds_count AS beds_count_3, t0.site_web AS site_web_4, t0.consultation_count AS consultation_count_5, t0.per AS per_6, t0.service_name AS service_name_7, t0.chief_service_name AS chief_service_name_8 FROM user_establishment t0 WHERE t0.id = ?"
  "params" => [
    1 => 64951
  ]
  "types" => [
    1 => 1
  ]
]

[
  "event" => "Symfony\UX\TwigComponent\Event\PostRenderEvent"
  "listener" => "Symfony\UX\TwigComponent\EventListener\TwigComponentLoggerListener::onPostRender"
]

[
  "event" => "Symfony\UX\TwigComponent\Event\PreRenderEvent"
  "listener" => "Symfony\UX\TwigComponent\EventListener\TwigComponentLoggerListener::onPreRender"
]

[
  "sql" => "SELECT e0_.id AS id_0, e0_.title AS title_1, e0_.speciality_name AS speciality_name_2, e0_.clinic_name AS clinic_name_3, e0_.body AS body_4 FROM evidence e0_ ORDER BY e0_.id DESC"
]

[
  "event" => "Symfony\UX\TwigComponent\Event\PostRenderEvent"
  "listener" => "Symfony\UX\TwigComponent\EventListener\TwigComponentLoggerListener::onPostRender"
]

[
  "event" => "Symfony\UX\TwigComponent\Event\PreRenderEvent"
  "listener" => "Symfony\UX\TwigComponent\EventListener\TwigComponentLoggerListener::onPreRender"
]

[
  "sql" => "SELECT u0_.id AS id_0, u0_.ordinary_number AS ordinary_number_1, u0_.civility AS civility_2, u0_.surname AS surname_3, u0_.name AS name_4, u0_.year_of_birth AS year_of_birth_5, u0_.nationality AS nationality_6, u0_.email AS email_7, u0_.password AS password_8, u0_.status AS status_9, u0_.telephone AS telephone_10, u0_.telephone2 AS telephone2_11, u0_.fax AS fax_12, u0_.position AS position_13, u0_.organism AS organism_14, u0_.year_of_alternance AS year_of_alternance_15, u0_.current_speciality AS current_speciality_16, u0_.comment AS comment_17, u0_.create_at AS create_at_18, u0_.user_comment AS user_comment_19, u0_.cv AS cv_20, u0_.diplom AS diplom_21, u0_.licence AS licence_22, u0_.address_id AS address_id_23, u0_.speciality_id AS speciality_id_24, u0_.establishment_id AS establishment_id_25, u0_.subscription_id AS subscription_id_26 FROM user u0_ INNER JOIN speciality s1_ ON u0_.speciality_id = s1_.id INNER JOIN user_user_role u3_ ON u0_.id = u3_.user_id INNER JOIN user_role u2_ ON u2_.id = u3_.user_role_id AND (u2_.id = ?) WHERE u0_.status = ? ORDER BY u0_.create_at DESC LIMIT 7"
  "params" => [
    1 => 4
    2 => 1
  ]
  "types" => [
    1 => 1
    2 => 5
  ]
]

[
  "event" => "Symfony\UX\TwigComponent\Event\PostRenderEvent"
  "listener" => "Symfony\UX\TwigComponent\EventListener\TwigComponentLoggerListener::onPostRender"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\AssetMapper\AssetMapperDevServerSubscriber::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\Security\Csrf\SameOriginCsrfTokenManager::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\Security\Http\Firewall\ContextListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\EventListener\ResponseListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\WebLink\EventListener\AddLinkHeaderListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\DataCollector\RequestDataCollector::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\EventListener\CacheAttributeListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\EventListener\ProfilerListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\EventListener\ErrorListener::removeCspHeader"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Bundle\WebProfilerBundle\EventListener\WebDebugToolbarListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\EventListener\DisallowRobotsIndexingListener::onResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\EventListener\SessionListener::onKernelResponse"
]

[
  "event" => "kernel.finish_request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\LocaleListener::onKernelFinishRequest"
]

[
  "event" => "kernel.finish_request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\RouterListener::onKernelFinishRequest"
]

[
  "event" => "kernel.finish_request"
  "listener" => "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::onKernelFinishRequest"
]

[
  "event" => "kernel.finish_request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\LocaleAwareListener::onKernelFinishRequest"
]