Symfony Profiler

[
  "route" => "societe_dashboard"
  "route_parameters" => [
    "_route" => "societe_dashboard"
    "_controller" => "App\Controller\Societe\DashboardController::index"
  ]
  "request_uri" => "https://amburesa.jkcprod.com/societe"
  "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 => 2
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#641
      +name: "INTEGER"
    }
  ]
]

[
  "provider" => "Symfony\Bridge\Doctrine\Security\User\EntityUserProvider"
  "username" => "erdre@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"
]

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

[
  "sql" => "SELECT r0_.statut AS statut_0, COUNT(r0_.id) AS sclr_1 FROM reservation r0_ WHERE r0_.date_heure_prise_en_charge >= ? AND r0_.societe_id = ? GROUP BY r0_.statut"
  "params" => [
    1 => "2026-11-02 00:00:00"
    2 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#994
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#641
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT DISTINCT v0_.societe_id AS sclr_0, v0_.type AS type_1 FROM vehicule v0_ WHERE v0_.actif = 1"
]

[
  "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 {#641
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT COUNT(r0_.id) AS sclr_0 FROM reservation r0_ LEFT JOIN etablissement e1_ ON r0_.etablissement_id = e1_.id LEFT JOIN societe s2_ ON r0_.societe_id = s2_.id LEFT JOIN vehicule v3_ ON r0_.vehicule_id = v3_.id LEFT JOIN reservation r4_ ON r0_.trajet_aller_id = r4_.id WHERE r0_.statut = ? AND r0_.societe_id IS NULL AND r0_.date_heure_prise_en_charge > ? AND ((e1_.id IS NOT NULL AND EXISTS (SELECT 1 FROM etablissement_societe_agreee e5_ WHERE e5_.etablissement_id = e1_.id AND e5_.societe_id IN (?))) OR (e1_.id IS NULL AND r0_.depart_departement IN (?) AND (r4_.id IS NULL OR r4_.statut <> ?))) AND r0_.type_transport IN (?, ?, ?)"
  "params" => [
    1 => "en_attente"
    2 => "2026-11-02 16:20:42"
    3 => 1
    4 => "44"
    5 => "en_attente"
    6 => "ambulance"
    7 => "vsl"
    8 => "bariatrique"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#994
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#994}
    3 => Doctrine\DBAL\ParameterType {#641
      +name: "INTEGER"
    }
    4 => Doctrine\DBAL\ParameterType {#994}
    5 => Doctrine\DBAL\ParameterType {#994}
    6 => Doctrine\DBAL\ParameterType {#994}
    7 => Doctrine\DBAL\ParameterType {#994}
    8 => Doctrine\DBAL\ParameterType {#994}
  ]
]

[
  "sql" => "SELECT r0_.id AS id_0, r0_.reference AS reference_1, r0_.statut AS statut_2, r0_.type_transport AS type_transport_3, r0_.motif AS motif_4, r0_.date_heure_prise_en_charge AS date_heure_prise_en_charge_5, r0_.heure_rendez_vous AS heure_rendez_vous_6, r0_.heure_afixer AS heure_afixer_7, r0_.heure_souhaitee AS heure_souhaitee_8, r0_.patient_nom AS patient_nom_9, r0_.patient_prenom AS patient_prenom_10, r0_.patient_date_naissance AS patient_date_naissance_11, r0_.patient_telephone AS patient_telephone_12, r0_.patient_poids AS patient_poids_13, r0_.besoin_oxygene AS besoin_oxygene_14, r0_.isolement_infectieux AS isolement_infectieux_15, r0_.accompagnant AS accompagnant_16, r0_.informations_complementaires AS informations_complementaires_17, r0_.depart_adresse AS depart_adresse_18, r0_.depart_code_postal AS depart_code_postal_19, r0_.depart_ville AS depart_ville_20, r0_.depart_departement AS depart_departement_21, r0_.depart_precisions AS depart_precisions_22, r0_.arrivee_adresse AS arrivee_adresse_23, r0_.arrivee_code_postal AS arrivee_code_postal_24, r0_.arrivee_ville AS arrivee_ville_25, r0_.arrivee_precisions AS arrivee_precisions_26, r0_.prescription_fichier AS prescription_fichier_27, r0_.prescription_nom_original AS prescription_nom_original_28, r0_.prise_le AS prise_le_29, r0_.duree_estimee_minutes AS duree_estimee_minutes_30, r0_.commentaire_regulation AS commentaire_regulation_31, r0_.motif_refus AS motif_refus_32, r0_.motif_annulation AS motif_annulation_33, r0_.created_at AS created_at_34, r0_.updated_at AS updated_at_35, r0_.anonymisee AS anonymisee_36, e1_.id AS id_37, e1_.nom AS nom_38, e1_.type AS type_39, e1_.adresse AS adresse_40, e1_.code_postal AS code_postal_41, e1_.ville AS ville_42, e1_.telephone AS telephone_43, e1_.email AS email_44, e1_.finess AS finess_45, e1_.actif AS actif_46, e1_.created_at AS created_at_47, s2_.id AS id_48, s2_.nom AS nom_49, s2_.siret AS siret_50, s2_.numero_agrement AS numero_agrement_51, s2_.adresse AS adresse_52, s2_.code_postal AS code_postal_53, s2_.ville AS ville_54, s2_.telephone AS telephone_55, s2_.email AS email_56, s2_.departements AS departements_57, s2_.actif AS actif_58, s2_.created_at AS created_at_59, v3_.id AS id_60, v3_.libelle AS libelle_61, v3_.immatriculation AS immatriculation_62, v3_.type AS type_63, v3_.actif AS actif_64, v3_.notes AS notes_65, r0_.etablissement_id AS etablissement_id_66, r0_.demandeur_id AS demandeur_id_67, r0_.trajet_aller_id AS trajet_aller_id_68, r0_.societe_id AS societe_id_69, r0_.vehicule_id AS vehicule_id_70, v3_.societe_id AS societe_id_71 FROM reservation r0_ LEFT JOIN etablissement e1_ ON r0_.etablissement_id = e1_.id LEFT JOIN societe s2_ ON r0_.societe_id = s2_.id LEFT JOIN vehicule v3_ ON r0_.vehicule_id = v3_.id LEFT JOIN reservation r4_ ON r0_.trajet_aller_id = r4_.id WHERE r0_.statut = ? AND r0_.societe_id IS NULL AND r0_.date_heure_prise_en_charge > ? AND ((e1_.id IS NOT NULL AND EXISTS (SELECT 1 FROM etablissement_societe_agreee e5_ WHERE e5_.etablissement_id = e1_.id AND e5_.societe_id IN (?))) OR (e1_.id IS NULL AND r0_.depart_departement IN (?) AND (r4_.id IS NULL OR r4_.statut <> ?))) AND r0_.type_transport IN (?, ?, ?) ORDER BY r0_.date_heure_prise_en_charge ASC LIMIT 5"
  "params" => [
    1 => "en_attente"
    2 => "2026-11-02 16:20:42"
    3 => 1
    4 => "44"
    5 => "en_attente"
    6 => "ambulance"
    7 => "vsl"
    8 => "bariatrique"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#994
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#994}
    3 => Doctrine\DBAL\ParameterType {#641
      +name: "INTEGER"
    }
    4 => Doctrine\DBAL\ParameterType {#994}
    5 => Doctrine\DBAL\ParameterType {#994}
    6 => Doctrine\DBAL\ParameterType {#994}
    7 => Doctrine\DBAL\ParameterType {#994}
    8 => Doctrine\DBAL\ParameterType {#994}
  ]
]

[
  "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 => 11
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#641
      +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 => 22
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#641
      +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 => 15
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#641
      +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 => 12
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#641
      +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 => 17
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#641
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT r0_.id AS id_0, r0_.reference AS reference_1, r0_.statut AS statut_2, r0_.type_transport AS type_transport_3, r0_.motif AS motif_4, r0_.date_heure_prise_en_charge AS date_heure_prise_en_charge_5, r0_.heure_rendez_vous AS heure_rendez_vous_6, r0_.heure_afixer AS heure_afixer_7, r0_.heure_souhaitee AS heure_souhaitee_8, r0_.patient_nom AS patient_nom_9, r0_.patient_prenom AS patient_prenom_10, r0_.patient_date_naissance AS patient_date_naissance_11, r0_.patient_telephone AS patient_telephone_12, r0_.patient_poids AS patient_poids_13, r0_.besoin_oxygene AS besoin_oxygene_14, r0_.isolement_infectieux AS isolement_infectieux_15, r0_.accompagnant AS accompagnant_16, r0_.informations_complementaires AS informations_complementaires_17, r0_.depart_adresse AS depart_adresse_18, r0_.depart_code_postal AS depart_code_postal_19, r0_.depart_ville AS depart_ville_20, r0_.depart_departement AS depart_departement_21, r0_.depart_precisions AS depart_precisions_22, r0_.arrivee_adresse AS arrivee_adresse_23, r0_.arrivee_code_postal AS arrivee_code_postal_24, r0_.arrivee_ville AS arrivee_ville_25, r0_.arrivee_precisions AS arrivee_precisions_26, r0_.prescription_fichier AS prescription_fichier_27, r0_.prescription_nom_original AS prescription_nom_original_28, r0_.prise_le AS prise_le_29, r0_.duree_estimee_minutes AS duree_estimee_minutes_30, r0_.commentaire_regulation AS commentaire_regulation_31, r0_.motif_refus AS motif_refus_32, r0_.motif_annulation AS motif_annulation_33, r0_.created_at AS created_at_34, r0_.updated_at AS updated_at_35, r0_.anonymisee AS anonymisee_36, e1_.id AS id_37, e1_.nom AS nom_38, e1_.type AS type_39, e1_.adresse AS adresse_40, e1_.code_postal AS code_postal_41, e1_.ville AS ville_42, e1_.telephone AS telephone_43, e1_.email AS email_44, e1_.finess AS finess_45, e1_.actif AS actif_46, e1_.created_at AS created_at_47, s2_.id AS id_48, s2_.nom AS nom_49, s2_.siret AS siret_50, s2_.numero_agrement AS numero_agrement_51, s2_.adresse AS adresse_52, s2_.code_postal AS code_postal_53, s2_.ville AS ville_54, s2_.telephone AS telephone_55, s2_.email AS email_56, s2_.departements AS departements_57, s2_.actif AS actif_58, s2_.created_at AS created_at_59, v3_.id AS id_60, v3_.libelle AS libelle_61, v3_.immatriculation AS immatriculation_62, v3_.type AS type_63, v3_.actif AS actif_64, v3_.notes AS notes_65, r0_.etablissement_id AS etablissement_id_66, r0_.demandeur_id AS demandeur_id_67, r0_.trajet_aller_id AS trajet_aller_id_68, r0_.societe_id AS societe_id_69, r0_.vehicule_id AS vehicule_id_70, v3_.societe_id AS societe_id_71 FROM reservation r0_ LEFT JOIN etablissement e1_ ON r0_.etablissement_id = e1_.id LEFT JOIN societe s2_ ON r0_.societe_id = s2_.id LEFT JOIN vehicule v3_ ON r0_.vehicule_id = v3_.id WHERE r0_.statut = ? AND r0_.societe_id = ? ORDER BY r0_.date_heure_prise_en_charge ASC"
  "params" => [
    1 => "acceptee"
    2 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#994
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#641
      +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 => 5
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#641
      +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 {#641
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT r0_.id AS id_0, r0_.reference AS reference_1, r0_.statut AS statut_2, r0_.type_transport AS type_transport_3, r0_.motif AS motif_4, r0_.date_heure_prise_en_charge AS date_heure_prise_en_charge_5, r0_.heure_rendez_vous AS heure_rendez_vous_6, r0_.heure_afixer AS heure_afixer_7, r0_.heure_souhaitee AS heure_souhaitee_8, r0_.patient_nom AS patient_nom_9, r0_.patient_prenom AS patient_prenom_10, r0_.patient_date_naissance AS patient_date_naissance_11, r0_.patient_telephone AS patient_telephone_12, r0_.patient_poids AS patient_poids_13, r0_.besoin_oxygene AS besoin_oxygene_14, r0_.isolement_infectieux AS isolement_infectieux_15, r0_.accompagnant AS accompagnant_16, r0_.informations_complementaires AS informations_complementaires_17, r0_.depart_adresse AS depart_adresse_18, r0_.depart_code_postal AS depart_code_postal_19, r0_.depart_ville AS depart_ville_20, r0_.depart_departement AS depart_departement_21, r0_.depart_precisions AS depart_precisions_22, r0_.arrivee_adresse AS arrivee_adresse_23, r0_.arrivee_code_postal AS arrivee_code_postal_24, r0_.arrivee_ville AS arrivee_ville_25, r0_.arrivee_precisions AS arrivee_precisions_26, r0_.prescription_fichier AS prescription_fichier_27, r0_.prescription_nom_original AS prescription_nom_original_28, r0_.prise_le AS prise_le_29, r0_.duree_estimee_minutes AS duree_estimee_minutes_30, r0_.commentaire_regulation AS commentaire_regulation_31, r0_.motif_refus AS motif_refus_32, r0_.motif_annulation AS motif_annulation_33, r0_.created_at AS created_at_34, r0_.updated_at AS updated_at_35, r0_.anonymisee AS anonymisee_36, e1_.id AS id_37, e1_.nom AS nom_38, e1_.type AS type_39, e1_.adresse AS adresse_40, e1_.code_postal AS code_postal_41, e1_.ville AS ville_42, e1_.telephone AS telephone_43, e1_.email AS email_44, e1_.finess AS finess_45, e1_.actif AS actif_46, e1_.created_at AS created_at_47, s2_.id AS id_48, s2_.nom AS nom_49, s2_.siret AS siret_50, s2_.numero_agrement AS numero_agrement_51, s2_.adresse AS adresse_52, s2_.code_postal AS code_postal_53, s2_.ville AS ville_54, s2_.telephone AS telephone_55, s2_.email AS email_56, s2_.departements AS departements_57, s2_.actif AS actif_58, s2_.created_at AS created_at_59, v3_.id AS id_60, v3_.libelle AS libelle_61, v3_.immatriculation AS immatriculation_62, v3_.type AS type_63, v3_.actif AS actif_64, v3_.notes AS notes_65, p4_.id AS id_66, p4_.prenom AS prenom_67, p4_.nom AS nom_68, p4_.qualification AS qualification_69, p4_.telephone AS telephone_70, p4_.actif AS actif_71, r0_.etablissement_id AS etablissement_id_72, r0_.demandeur_id AS demandeur_id_73, r0_.trajet_aller_id AS trajet_aller_id_74, r0_.societe_id AS societe_id_75, r0_.vehicule_id AS vehicule_id_76, v3_.societe_id AS societe_id_77, p4_.societe_id AS societe_id_78 FROM reservation r0_ LEFT JOIN etablissement e1_ ON r0_.etablissement_id = e1_.id LEFT JOIN societe s2_ ON r0_.societe_id = s2_.id LEFT JOIN vehicule v3_ ON r0_.vehicule_id = v3_.id LEFT JOIN reservation_equipage r5_ ON r0_.id = r5_.reservation_id LEFT JOIN personnel p4_ ON p4_.id = r5_.personnel_id WHERE (r0_.date_heure_prise_en_charge >= ? AND r0_.date_heure_prise_en_charge < ?) AND r0_.statut NOT IN (?, ?) AND r0_.societe_id = ? ORDER BY r0_.date_heure_prise_en_charge ASC"
  "params" => [
    1 => "2026-11-02 00:00:00"
    2 => "2026-11-03 00:00:00"
    3 => "refusee"
    4 => "annulee"
    5 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#994
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#994}
    3 => Doctrine\DBAL\ParameterType {#994}
    4 => Doctrine\DBAL\ParameterType {#994}
    5 => Doctrine\DBAL\ParameterType {#641
      +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 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#641
      +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 => 2
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#641
      +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 => 3
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#641
      +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.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 INNER JOIN etablissement_societe_agreee ON t0.id = etablissement_societe_agreee.etablissement_id WHERE etablissement_societe_agreee.societe_id = ? ORDER BY t0.nom ASC"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#641
      +name: "INTEGER"
    }
  ]
]

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