Symfony Profiler

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 = ?

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 = 11;

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

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 = 'en_attente' AND r0_.societe_id IS NULL AND r0_.date_heure_prise_en_charge > '2026-11-02 16:20:42' 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 (1))) OR (e1_.id IS NULL AND r0_.depart_departement IN ('44') AND (r4_.id IS NULL OR r4_.statut <> 'en_attente'))) AND r0_.type_transport IN ('ambulance', 'vsl', 'bariatrique') ORDER BY r0_.date_heure_prise_en_charge ASC LIMIT 5;

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

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 >= '2026-11-02 00:00:00' AND r0_.date_heure_prise_en_charge < '2026-11-03 00:00:00') AND r0_.statut NOT IN ('refusee', 'annulee') AND r0_.societe_id = 1 ORDER BY r0_.date_heure_prise_en_charge ASC;

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 (?, ?, ?)

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 = 'en_attente' AND r0_.societe_id IS NULL AND r0_.date_heure_prise_en_charge > '2026-11-02 16:20:42' 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 (1))) OR (e1_.id IS NULL AND r0_.depart_departement IN ('44') AND (r4_.id IS NULL OR r4_.statut <> 'en_attente'))) AND r0_.type_transport IN ('ambulance', 'vsl', 'bariatrique');

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

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 = 'acceptee' AND r0_.societe_id = 1 ORDER BY r0_.date_heure_prise_en_charge ASC;

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

SELECT r0_.statut AS statut_0, COUNT(r0_.id) AS sclr_1 FROM reservation r0_ WHERE r0_.date_heure_prise_en_charge >= '2026-11-02 00:00:00' AND r0_.societe_id = 1 GROUP BY r0_.statut;