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.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.id = '3';

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

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

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

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

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

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

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

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

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

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

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 = 3 ORDER BY t0.created_at ASC, t0.id ASC;

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

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