Symfony Profiler

[
  "route" => "etablissement_reservation_show"
  "route_parameters" => [
    "_route" => "etablissement_reservation_show"
    "_controller" => "App\Controller\Etablissement\ReservationController::show"
    "id" => "3"
  ]
  "request_uri" => "https://amburesa.jkcprod.com/etablissement/demandes/3"
  "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"
]

[
  "key" => "_security_main"
  "token_class" => "Symfony\Component\Security\Core\Authentication\Token\UsernamePasswordToken"
]

[
  "params" => [
    "driver" => "pdo_mysql"
    "idle_connection_ttl" => 600
    "host" => "127.0.0.1"
    "port" => 3306
    "user" => "amburesa"
    "password" => "<redacted>"
    "driverOptions" => []
    "defaultTableOptions" => []
    "dbname" => "amburesa"
    "serverVersion" => "8.0.32"
    "charset" => "utf8mb4"
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.prenom AS prenom_5, t0.nom AS nom_6, t0.telephone AS telephone_7, t0.fonction AS fonction_8, t0.actif AS actif_9, t0.created_at AS created_at_10, t0.last_login_at AS last_login_at_11, t0.etablissement_id AS etablissement_id_12, t0.societe_id AS societe_id_13 FROM `user` t0 WHERE t0.id = ?"
  "params" => [
    1 => 6
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#663
      +name: "INTEGER"
    }
  ]
]

[
  "provider" => "Symfony\Bridge\Doctrine\Security\User\EntityUserProvider"
  "username" => "urgences@chu-demo.fr"
]

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

[
  "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\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"
]

[
  "sql" => "SELECT t0.id AS id_1, t0.reference AS reference_2, t0.statut AS statut_3, t0.type_transport AS type_transport_4, t0.motif AS motif_5, t0.date_heure_prise_en_charge AS date_heure_prise_en_charge_6, t0.heure_rendez_vous AS heure_rendez_vous_7, t0.heure_afixer AS heure_afixer_8, t0.heure_souhaitee AS heure_souhaitee_9, t0.patient_nom AS patient_nom_10, t0.patient_prenom AS patient_prenom_11, t0.patient_date_naissance AS patient_date_naissance_12, t0.patient_telephone AS patient_telephone_13, t0.patient_poids AS patient_poids_14, t0.besoin_oxygene AS besoin_oxygene_15, t0.isolement_infectieux AS isolement_infectieux_16, t0.accompagnant AS accompagnant_17, t0.informations_complementaires AS informations_complementaires_18, t0.depart_adresse AS depart_adresse_19, t0.depart_code_postal AS depart_code_postal_20, t0.depart_ville AS depart_ville_21, t0.depart_departement AS depart_departement_22, t0.depart_precisions AS depart_precisions_23, t0.arrivee_adresse AS arrivee_adresse_24, t0.arrivee_code_postal AS arrivee_code_postal_25, t0.arrivee_ville AS arrivee_ville_26, t0.arrivee_precisions AS arrivee_precisions_27, t0.prescription_fichier AS prescription_fichier_28, t0.prescription_nom_original AS prescription_nom_original_29, t0.prise_le AS prise_le_30, t0.duree_estimee_minutes AS duree_estimee_minutes_31, t0.commentaire_regulation AS commentaire_regulation_32, t0.motif_refus AS motif_refus_33, t0.motif_annulation AS motif_annulation_34, t0.created_at AS created_at_35, t0.updated_at AS updated_at_36, t0.anonymisee AS anonymisee_37, t0.etablissement_id AS etablissement_id_38, t0.demandeur_id AS demandeur_id_39, t0.trajet_aller_id AS trajet_aller_id_40, t41.id AS id_42, t41.reference AS reference_43, t41.statut AS statut_44, t41.type_transport AS type_transport_45, t41.motif AS motif_46, t41.date_heure_prise_en_charge AS date_heure_prise_en_charge_47, t41.heure_rendez_vous AS heure_rendez_vous_48, t41.heure_afixer AS heure_afixer_49, t41.heure_souhaitee AS heure_souhaitee_50, t41.patient_nom AS patient_nom_51, t41.patient_prenom AS patient_prenom_52, t41.patient_date_naissance AS patient_date_naissance_53, t41.patient_telephone AS patient_telephone_54, t41.patient_poids AS patient_poids_55, t41.besoin_oxygene AS besoin_oxygene_56, t41.isolement_infectieux AS isolement_infectieux_57, t41.accompagnant AS accompagnant_58, t41.informations_complementaires AS informations_complementaires_59, t41.depart_adresse AS depart_adresse_60, t41.depart_code_postal AS depart_code_postal_61, t41.depart_ville AS depart_ville_62, t41.depart_departement AS depart_departement_63, t41.depart_precisions AS depart_precisions_64, t41.arrivee_adresse AS arrivee_adresse_65, t41.arrivee_code_postal AS arrivee_code_postal_66, t41.arrivee_ville AS arrivee_ville_67, t41.arrivee_precisions AS arrivee_precisions_68, t41.prescription_fichier AS prescription_fichier_69, t41.prescription_nom_original AS prescription_nom_original_70, t41.prise_le AS prise_le_71, t41.duree_estimee_minutes AS duree_estimee_minutes_72, t41.commentaire_regulation AS commentaire_regulation_73, t41.motif_refus AS motif_refus_74, t41.motif_annulation AS motif_annulation_75, t41.created_at AS created_at_76, t41.updated_at AS updated_at_77, t41.anonymisee AS anonymisee_78, t41.etablissement_id AS etablissement_id_79, t41.demandeur_id AS demandeur_id_80, t41.trajet_aller_id AS trajet_aller_id_81, t41.societe_id AS societe_id_82, t41.vehicule_id AS vehicule_id_83, t0.societe_id AS societe_id_84, t0.vehicule_id AS vehicule_id_85 FROM reservation t0 LEFT JOIN reservation t41 ON t41.trajet_aller_id = t0.id WHERE t0.id = ?"
  "params" => [
    1 => "3"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#663
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.reference AS reference_2, t0.statut AS statut_3, t0.type_transport AS type_transport_4, t0.motif AS motif_5, t0.date_heure_prise_en_charge AS date_heure_prise_en_charge_6, t0.heure_rendez_vous AS heure_rendez_vous_7, t0.heure_afixer AS heure_afixer_8, t0.heure_souhaitee AS heure_souhaitee_9, t0.patient_nom AS patient_nom_10, t0.patient_prenom AS patient_prenom_11, t0.patient_date_naissance AS patient_date_naissance_12, t0.patient_telephone AS patient_telephone_13, t0.patient_poids AS patient_poids_14, t0.besoin_oxygene AS besoin_oxygene_15, t0.isolement_infectieux AS isolement_infectieux_16, t0.accompagnant AS accompagnant_17, t0.informations_complementaires AS informations_complementaires_18, t0.depart_adresse AS depart_adresse_19, t0.depart_code_postal AS depart_code_postal_20, t0.depart_ville AS depart_ville_21, t0.depart_departement AS depart_departement_22, t0.depart_precisions AS depart_precisions_23, t0.arrivee_adresse AS arrivee_adresse_24, t0.arrivee_code_postal AS arrivee_code_postal_25, t0.arrivee_ville AS arrivee_ville_26, t0.arrivee_precisions AS arrivee_precisions_27, t0.prescription_fichier AS prescription_fichier_28, t0.prescription_nom_original AS prescription_nom_original_29, t0.prise_le AS prise_le_30, t0.duree_estimee_minutes AS duree_estimee_minutes_31, t0.commentaire_regulation AS commentaire_regulation_32, t0.motif_refus AS motif_refus_33, t0.motif_annulation AS motif_annulation_34, t0.created_at AS created_at_35, t0.updated_at AS updated_at_36, t0.anonymisee AS anonymisee_37, t0.etablissement_id AS etablissement_id_38, t0.demandeur_id AS demandeur_id_39, t0.trajet_aller_id AS trajet_aller_id_40, t41.id AS id_42, t41.reference AS reference_43, t41.statut AS statut_44, t41.type_transport AS type_transport_45, t41.motif AS motif_46, t41.date_heure_prise_en_charge AS date_heure_prise_en_charge_47, t41.heure_rendez_vous AS heure_rendez_vous_48, t41.heure_afixer AS heure_afixer_49, t41.heure_souhaitee AS heure_souhaitee_50, t41.patient_nom AS patient_nom_51, t41.patient_prenom AS patient_prenom_52, t41.patient_date_naissance AS patient_date_naissance_53, t41.patient_telephone AS patient_telephone_54, t41.patient_poids AS patient_poids_55, t41.besoin_oxygene AS besoin_oxygene_56, t41.isolement_infectieux AS isolement_infectieux_57, t41.accompagnant AS accompagnant_58, t41.informations_complementaires AS informations_complementaires_59, t41.depart_adresse AS depart_adresse_60, t41.depart_code_postal AS depart_code_postal_61, t41.depart_ville AS depart_ville_62, t41.depart_departement AS depart_departement_63, t41.depart_precisions AS depart_precisions_64, t41.arrivee_adresse AS arrivee_adresse_65, t41.arrivee_code_postal AS arrivee_code_postal_66, t41.arrivee_ville AS arrivee_ville_67, t41.arrivee_precisions AS arrivee_precisions_68, t41.prescription_fichier AS prescription_fichier_69, t41.prescription_nom_original AS prescription_nom_original_70, t41.prise_le AS prise_le_71, t41.duree_estimee_minutes AS duree_estimee_minutes_72, t41.commentaire_regulation AS commentaire_regulation_73, t41.motif_refus AS motif_refus_74, t41.motif_annulation AS motif_annulation_75, t41.created_at AS created_at_76, t41.updated_at AS updated_at_77, t41.anonymisee AS anonymisee_78, t41.etablissement_id AS etablissement_id_79, t41.demandeur_id AS demandeur_id_80, t41.trajet_aller_id AS trajet_aller_id_81, t41.societe_id AS societe_id_82, t41.vehicule_id AS vehicule_id_83, t0.societe_id AS societe_id_84, t0.vehicule_id AS vehicule_id_85 FROM reservation t0 LEFT JOIN reservation t41 ON t41.trajet_aller_id = t0.id WHERE t0.trajet_aller_id = ?"
  "params" => [
    1 => 4
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#663
      +name: "INTEGER"
    }
  ]
]

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

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

[
  "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" => "Symfony\Component\HttpKernel\EventListener\ErrorListener::onControllerArguments"
]

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

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

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

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

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

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

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

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

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

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

[
  "sql" => "SELECT t0.id AS id_1, t0.nom AS nom_2, t0.type AS type_3, t0.adresse AS adresse_4, t0.code_postal AS code_postal_5, t0.ville AS ville_6, t0.telephone AS telephone_7, t0.email AS email_8, t0.finess AS finess_9, t0.actif AS actif_10, t0.created_at AS created_at_11 FROM etablissement t0 WHERE t0.id = ?"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#663
      +name: "INTEGER"
    }
  ]
]

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

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

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

[
  "sql" => "SELECT t0.id AS id_1, t0.nom AS nom_2, t0.siret AS siret_3, t0.numero_agrement AS numero_agrement_4, t0.adresse AS adresse_5, t0.code_postal AS code_postal_6, t0.ville AS ville_7, t0.telephone AS telephone_8, t0.email AS email_9, t0.departements AS departements_10, t0.actif AS actif_11, t0.created_at AS created_at_12 FROM societe t0 WHERE t0.id = ?"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#663
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.immatriculation AS immatriculation_3, t0.type AS type_4, t0.actif AS actif_5, t0.notes AS notes_6, t0.societe_id AS societe_id_7 FROM vehicule t0 WHERE t0.id = ?"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#663
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.prenom AS prenom_2, t0.nom AS nom_3, t0.qualification AS qualification_4, t0.telephone AS telephone_5, t0.actif AS actif_6, t0.societe_id AS societe_id_7 FROM personnel t0 INNER JOIN reservation_equipage ON t0.id = reservation_equipage.personnel_id WHERE reservation_equipage.reservation_id = ?"
  "params" => [
    1 => 3
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#663
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.auteur_nom AS auteur_nom_3, t0.action AS action_4, t0.statut_avant AS statut_avant_5, t0.statut_apres AS statut_apres_6, t0.commentaire AS commentaire_7, t0.reservation_id AS reservation_id_8, t0.auteur_id AS auteur_id_9 FROM reservation_historique t0 WHERE t0.reservation_id = ? ORDER BY t0.created_at ASC, t0.id ASC"
  "params" => [
    1 => 3
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#663
      +name: "INTEGER"
    }
  ]
]

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

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

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

[
  "key" => "_security_main"
]

[
  "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\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"
]