Symfony Profiler

SELECT
  t0.id AS id_5,
  t0.username AS username_6,
  t0.email AS email_7,
  t0.roles AS roles_8,
  t0.password AS password_9,
  t0.nom AS nom_10,
  t0.prenom AS prenom_11,
  t0.telephone AS telephone_12,
  t0.adresse AS adresse_13,
  t0.date_naissance AS date_naissance_14,
  t0.cin AS cin_15,
  t0.date_creation AS date_creation_16,
  t0.derniere_connexion AS derniere_connexion_17,
  t0.actif AS actif_18,
  t0.type,
  t1.specialite AS specialite_19,
  t1.numero_inpe AS numero_inpe_20,
  t1.biographie AS biographie_21,
  t1.tarif_consultation AS tarif_consultation_22,
  t2.numero_assurance_maladie AS numero_assurance_maladie_23,
  t2.type_assurance AS type_assurance_24,
  t2.antecedents_medicaux AS antecedents_medicaux_25,
  t2.allergies AS allergies_26,
  t2.groupe_sanguin AS groupe_sanguin_27,
  t2.profession AS profession_28,
  t2.responsable AS responsable_29,
  t2.sexe AS sexe_30,
  t2.antecedents_chirurgicaux AS antecedents_chirurgicaux_31,
  t2.antecedents_familiales AS antecedents_familiales_32,
  t2.note AS note_33,
  t3.poste AS poste_34,
  t4.poste AS poste_35,
  t4.date_embauche AS date_embauche_36,
  t4.competences AS competences_37
FROM
  `users` t0
  LEFT JOIN medecins t1 ON t0.id = t1.id
  LEFT JOIN patients t2 ON t0.id = t2.id
  LEFT JOIN admins t3 ON t0.id = t3.id
  LEFT JOIN secretaire t4 ON t0.id = t4.id
WHERE
  t0.id = ?

SELECT t0.id AS id_5, t0.username AS username_6, t0.email AS email_7, t0.roles AS roles_8, t0.password AS password_9, t0.nom AS nom_10, t0.prenom AS prenom_11, t0.telephone AS telephone_12, t0.adresse AS adresse_13, t0.date_naissance AS date_naissance_14, t0.cin AS cin_15, t0.date_creation AS date_creation_16, t0.derniere_connexion AS derniere_connexion_17, t0.actif AS actif_18, t0.type, t1.specialite AS specialite_19, t1.numero_inpe AS numero_inpe_20, t1.biographie AS biographie_21, t1.tarif_consultation AS tarif_consultation_22, t2.numero_assurance_maladie AS numero_assurance_maladie_23, t2.type_assurance AS type_assurance_24, t2.antecedents_medicaux AS antecedents_medicaux_25, t2.allergies AS allergies_26, t2.groupe_sanguin AS groupe_sanguin_27, t2.profession AS profession_28, t2.responsable AS responsable_29, t2.sexe AS sexe_30, t2.antecedents_chirurgicaux AS antecedents_chirurgicaux_31, t2.antecedents_familiales AS antecedents_familiales_32, t2.note AS note_33, t3.poste AS poste_34, t4.poste AS poste_35, t4.date_embauche AS date_embauche_36, t4.competences AS competences_37 FROM `users` t0 LEFT JOIN medecins t1 ON t0.id = t1.id LEFT JOIN patients t2 ON t0.id = t2.id LEFT JOIN admins t3 ON t0.id = t3.id LEFT JOIN secretaire t4 ON t0.id = t4.id WHERE t0.id = 6;

SELECT
  t0.id AS id_1,
  t0.date_consultation AS date_consultation_2,
  t0.diagnostic AS diagnostic_3,
  t0.notes AS notes_4,
  t0.montant AS montant_5,
  t0.statut AS statut_6,
  t0.poids AS poids_7,
  t0.taille AS taille_8,
  t0.temperature AS temperature_9,
  t0.frequence_cardiaque AS frequence_cardiaque_10,
  t0.glycemie AS glycemie_11,
  t0.pression_arterielle AS pression_arterielle_12,
  t0.examan_clinique AS examan_clinique_13,
  t0.rendez_vous_id AS rendez_vous_id_14,
  t0.salle_attente_id AS salle_attente_id_15,
  t0.patient_id AS patient_id_16,
  t0.medecin_id AS medecin_id_17,
  t18.id AS id_19,
  t18.montant AS montant_20,
  t18.date_paiement AS date_paiement_21,
  t18.methode AS methode_22,
  t18.reference AS reference_23,
  t18.recu_genere AS recu_genere_24,
  t18.notes AS notes_25,
  t18.montant_assurance AS montant_assurance_26,
  t18.montant_patient AS montant_patient_27,
  t18.consultation_id AS consultation_id_28,
  t0.consultation_motif_id AS consultation_motif_id_29
FROM
  consultations t0
  LEFT JOIN paiements t18 ON t18.consultation_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.date_consultation AS date_consultation_2, t0.diagnostic AS diagnostic_3, t0.notes AS notes_4, t0.montant AS montant_5, t0.statut AS statut_6, t0.poids AS poids_7, t0.taille AS taille_8, t0.temperature AS temperature_9, t0.frequence_cardiaque AS frequence_cardiaque_10, t0.glycemie AS glycemie_11, t0.pression_arterielle AS pression_arterielle_12, t0.examan_clinique AS examan_clinique_13, t0.rendez_vous_id AS rendez_vous_id_14, t0.salle_attente_id AS salle_attente_id_15, t0.patient_id AS patient_id_16, t0.medecin_id AS medecin_id_17, t18.id AS id_19, t18.montant AS montant_20, t18.date_paiement AS date_paiement_21, t18.methode AS methode_22, t18.reference AS reference_23, t18.recu_genere AS recu_genere_24, t18.notes AS notes_25, t18.montant_assurance AS montant_assurance_26, t18.montant_patient AS montant_patient_27, t18.consultation_id AS consultation_id_28, t0.consultation_motif_id AS consultation_motif_id_29 FROM consultations t0 LEFT JOIN paiements t18 ON t18.consultation_id = t0.id WHERE t0.id = '1';

SELECT
  t0.id AS id_1,
  t0.use_header AS use_header_2,
  t0.use_footer AS use_footer_3,
  t0.app_name AS app_name_4,
  t0.logo AS logo_5,
  t0.updated_at AS updated_at_6,
  t0.email AS email_7,
  t0.telephone AS telephone_8,
  t0.header_code AS header_code_9,
  t0.footer_code AS footer_code_10,
  t0.adresse AS adresse_11
FROM
  setting t0
LIMIT
  1

SELECT t0.id AS id_1, t0.use_header AS use_header_2, t0.use_footer AS use_footer_3, t0.app_name AS app_name_4, t0.logo AS logo_5, t0.updated_at AS updated_at_6, t0.email AS email_7, t0.telephone AS telephone_8, t0.header_code AS header_code_9, t0.footer_code AS footer_code_10, t0.adresse AS adresse_11 FROM setting t0 LIMIT 1;

SELECT
  t1.id AS id_2,
  t1.username AS username_3,
  t1.email AS email_4,
  t1.roles AS roles_5,
  t1.password AS password_6,
  t1.nom AS nom_7,
  t1.prenom AS prenom_8,
  t1.telephone AS telephone_9,
  t1.adresse AS adresse_10,
  t1.date_naissance AS date_naissance_11,
  t1.cin AS cin_12,
  t1.date_creation AS date_creation_13,
  t1.derniere_connexion AS derniere_connexion_14,
  t1.actif AS actif_15,
  t0.numero_assurance_maladie AS numero_assurance_maladie_16,
  t0.type_assurance AS type_assurance_17,
  t0.antecedents_medicaux AS antecedents_medicaux_18,
  t0.allergies AS allergies_19,
  t0.groupe_sanguin AS groupe_sanguin_20,
  t0.profession AS profession_21,
  t0.responsable AS responsable_22,
  t0.sexe AS sexe_23,
  t0.antecedents_chirurgicaux AS antecedents_chirurgicaux_24,
  t0.antecedents_familiales AS antecedents_familiales_25,
  t0.note AS note_26,
  t1.type
FROM
  patients t0
  INNER JOIN `users` t1 ON t0.id = t1.id
WHERE
  t1.id = ?

SELECT t1.id AS id_2, t1.username AS username_3, t1.email AS email_4, t1.roles AS roles_5, t1.password AS password_6, t1.nom AS nom_7, t1.prenom AS prenom_8, t1.telephone AS telephone_9, t1.adresse AS adresse_10, t1.date_naissance AS date_naissance_11, t1.cin AS cin_12, t1.date_creation AS date_creation_13, t1.derniere_connexion AS derniere_connexion_14, t1.actif AS actif_15, t0.numero_assurance_maladie AS numero_assurance_maladie_16, t0.type_assurance AS type_assurance_17, t0.antecedents_medicaux AS antecedents_medicaux_18, t0.allergies AS allergies_19, t0.groupe_sanguin AS groupe_sanguin_20, t0.profession AS profession_21, t0.responsable AS responsable_22, t0.sexe AS sexe_23, t0.antecedents_chirurgicaux AS antecedents_chirurgicaux_24, t0.antecedents_familiales AS antecedents_familiales_25, t0.note AS note_26, t1.type FROM patients t0 INNER JOIN `users` t1 ON t0.id = t1.id WHERE t1.id = 12;

SELECT
  t0.id AS id_1,
  t0.date_creation AS date_creation_2,
  t0.notes AS notes_3,
  t0.patient_id AS patient_id_4
FROM
  dossiers_medicaux t0
WHERE
  t0.patient_id = ?

SELECT t0.id AS id_1, t0.date_creation AS date_creation_2, t0.notes AS notes_3, t0.patient_id AS patient_id_4 FROM dossiers_medicaux t0 WHERE t0.patient_id = 12;

SELECT
  t1.id AS id_2,
  t1.username AS username_3,
  t1.email AS email_4,
  t1.roles AS roles_5,
  t1.password AS password_6,
  t1.nom AS nom_7,
  t1.prenom AS prenom_8,
  t1.telephone AS telephone_9,
  t1.adresse AS adresse_10,
  t1.date_naissance AS date_naissance_11,
  t1.cin AS cin_12,
  t1.date_creation AS date_creation_13,
  t1.derniere_connexion AS derniere_connexion_14,
  t1.actif AS actif_15,
  t0.specialite AS specialite_16,
  t0.numero_inpe AS numero_inpe_17,
  t0.biographie AS biographie_18,
  t0.tarif_consultation AS tarif_consultation_19,
  t1.type
FROM
  medecins t0
  INNER JOIN `users` t1 ON t0.id = t1.id
WHERE
  t1.id = ?

SELECT t1.id AS id_2, t1.username AS username_3, t1.email AS email_4, t1.roles AS roles_5, t1.password AS password_6, t1.nom AS nom_7, t1.prenom AS prenom_8, t1.telephone AS telephone_9, t1.adresse AS adresse_10, t1.date_naissance AS date_naissance_11, t1.cin AS cin_12, t1.date_creation AS date_creation_13, t1.derniere_connexion AS derniere_connexion_14, t1.actif AS actif_15, t0.specialite AS specialite_16, t0.numero_inpe AS numero_inpe_17, t0.biographie AS biographie_18, t0.tarif_consultation AS tarif_consultation_19, t1.type FROM medecins t0 INNER JOIN `users` t1 ON t0.id = t1.id WHERE t1.id = 7;

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.prix AS prix_3,
  t0.active AS active_4
FROM
  consultation_motif t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.prix AS prix_3, t0.active AS active_4 FROM consultation_motif t0 WHERE t0.id = 1;

SELECT
  t0.id AS id_1,
  t0.date_creation AS date_creation_2,
  t0.date_expiration AS date_expiration_3,
  t0.notes_generales AS notes_generales_4,
  t0.consultation_id AS consultation_id_5,
  t0.patient_id AS patient_id_6,
  t0.medecin_id AS medecin_id_7
FROM
  ordonnances t0
WHERE
  t0.consultation_id = ?

SELECT t0.id AS id_1, t0.date_creation AS date_creation_2, t0.date_expiration AS date_expiration_3, t0.notes_generales AS notes_generales_4, t0.consultation_id AS consultation_id_5, t0.patient_id AS patient_id_6, t0.medecin_id AS medecin_id_7 FROM ordonnances t0 WHERE t0.consultation_id = 1;

SELECT
  t0.id AS id_1,
  t0.posologie AS posologie_2,
  t0.duree AS duree_3,
  t0.instructions AS instructions_4,
  t0.quantite AS quantite_5,
  t0.ordonnance_id AS ordonnance_id_6,
  t0.medicament_id AS medicament_id_7
FROM
  prescriptions t0
WHERE
  t0.ordonnance_id = ?

SELECT t0.id AS id_1, t0.posologie AS posologie_2, t0.duree AS duree_3, t0.instructions AS instructions_4, t0.quantite AS quantite_5, t0.ordonnance_id AS ordonnance_id_6, t0.medicament_id AS medicament_id_7 FROM prescriptions t0 WHERE t0.ordonnance_id = 1;

SELECT
  t0.id AS id_1,
  t0.type AS type_2,
  t0.description AS description_3,
  t0.instructions AS instructions_4,
  t0.urgence AS urgence_5,
  t0.renseignements_cliniques AS renseignements_cliniques_6,
  t0.ordonnance_id AS ordonnance_id_7,
  t0.consultation_id AS consultation_id_8
FROM
  demandes_analyse t0
WHERE
  t0.ordonnance_id = ?

SELECT t0.id AS id_1, t0.type AS type_2, t0.description AS description_3, t0.instructions AS instructions_4, t0.urgence AS urgence_5, t0.renseignements_cliniques AS renseignements_cliniques_6, t0.ordonnance_id AS ordonnance_id_7, t0.consultation_id AS consultation_id_8 FROM demandes_analyse t0 WHERE t0.ordonnance_id = 1;

SELECT
  t0.id AS id_1,
  t0.type AS type_2,
  t0.description AS description_3,
  t0.instructions AS instructions_4,
  t0.urgence AS urgence_5,
  t0.renseignements_cliniques AS renseignements_cliniques_6,
  t0.ordonnance_id AS ordonnance_id_7,
  t0.consultation_id AS consultation_id_8
FROM
  demandes_analyse t0
WHERE
  t0.consultation_id = ?

SELECT t0.id AS id_1, t0.type AS type_2, t0.description AS description_3, t0.instructions AS instructions_4, t0.urgence AS urgence_5, t0.renseignements_cliniques AS renseignements_cliniques_6, t0.ordonnance_id AS ordonnance_id_7, t0.consultation_id AS consultation_id_8 FROM demandes_analyse t0 WHERE t0.consultation_id = 1;

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.abrev AS abrev_3
FROM
  analyse t0
  INNER JOIN demande_analyse_analyse ON t0.id = demande_analyse_analyse.analyse_id
WHERE
  demande_analyse_analyse.demande_analyse_id = ?

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.abrev AS abrev_3 FROM analyse t0 INNER JOIN demande_analyse_analyse ON t0.id = demande_analyse_analyse.analyse_id WHERE demande_analyse_analyse.demande_analyse_id = 1;

SELECT
  t0.id AS id_1,
  t0.type AS type_2,
  t0.partie AS partie_3,
  t0.description AS description_4,
  t0.instructions AS instructions_5,
  t0.urgence AS urgence_6,
  t0.renseignements_cliniques AS renseignements_cliniques_7,
  t0.ordonnance_id AS ordonnance_id_8,
  t0.consultation_id AS consultation_id_9
FROM
  demandes_radio t0
WHERE
  t0.consultation_id = ?

SELECT t0.id AS id_1, t0.type AS type_2, t0.partie AS partie_3, t0.description AS description_4, t0.instructions AS instructions_5, t0.urgence AS urgence_6, t0.renseignements_cliniques AS renseignements_cliniques_7, t0.ordonnance_id AS ordonnance_id_8, t0.consultation_id AS consultation_id_9 FROM demandes_radio t0 WHERE t0.consultation_id = 1;

SELECT
  t0.id AS id_1,
  t0.type AS type_2,
  t0.partie AS partie_3,
  t0.description AS description_4,
  t0.instructions AS instructions_5,
  t0.urgence AS urgence_6,
  t0.renseignements_cliniques AS renseignements_cliniques_7,
  t0.ordonnance_id AS ordonnance_id_8,
  t0.consultation_id AS consultation_id_9
FROM
  demandes_radio t0
WHERE
  t0.ordonnance_id = ?

SELECT t0.id AS id_1, t0.type AS type_2, t0.partie AS partie_3, t0.description AS description_4, t0.instructions AS instructions_5, t0.urgence AS urgence_6, t0.renseignements_cliniques AS renseignements_cliniques_7, t0.ordonnance_id AS ordonnance_id_8, t0.consultation_id AS consultation_id_9 FROM demandes_radio t0 WHERE t0.ordonnance_id = 1;