Symfony Profiler

SELECT
  p0_.id AS id_0,
  p0_.date AS date_1,
  p0_.montant AS montant_2,
  d1_.id AS id_3,
  d1_.date AS date_4,
  d1_.montant AS montant_5,
  d1_.reste AS reste_6,
  d1_.statut AS statut_7,
  d1_.type AS type_8,
  f2_.id AS id_9,
  f2_.motif AS motif_10,
  f2_.histoire_maladie AS histoire_maladie_11,
  f2_.soins_anterieurs AS soins_anterieurs_12,
  f2_.exo_inspection AS exo_inspection_13,
  f2_.exo_palpation AS exo_palpation_14,
  f2_.endo_inspection AS endo_inspection_15,
  f2_.endo_palpation AS endo_palpation_16,
  f2_.occlusion AS occlusion_17,
  f2_.examen_parodontal AS examen_parodontal_18,
  f2_.diagnostic AS diagnostic_19,
  f2_.traitement_urgence AS traitement_urgence_20,
  f2_.traitement_dentaire AS traitement_dentaire_21,
  f2_.traitement_parodontal AS traitement_parodontal_22,
  f2_.traitement_orthodontique AS traitement_orthodontique_23,
  f2_.autres AS autres_24,
  f2_.created_at AS created_at_25,
  f2_.tooths_check AS tooths_check_26,
  p3_.id AS id_27,
  p3_.nom AS nom_28,
  p3_.prenom AS prenom_29,
  p3_.date_naissance AS date_naissance_30,
  p3_.date_inscription AS date_inscription_31,
  p3_.sexe AS sexe_32,
  p3_.telephone AS telephone_33,
  p3_.email AS email_34,
  p3_.profession AS profession_35,
  p3_.lieu_naissance AS lieu_naissance_36,
  p3_.adresse AS adresse_37,
  p3_.num_carnet AS num_carnet_38,
  p3_.groupe_sanguin AS groupe_sanguin_39,
  p3_.referencement AS referencement_40,
  f4_.id AS id_41,
  f4_.created_at AS created_at_42,
  p5_.id AS id_43,
  p5_.nom AS nom_44,
  p5_.prenom AS prenom_45,
  p5_.date_naissance AS date_naissance_46,
  p5_.date_inscription AS date_inscription_47,
  p5_.sexe AS sexe_48,
  p5_.telephone AS telephone_49,
  p5_.email AS email_50,
  p5_.profession AS profession_51,
  p5_.lieu_naissance AS lieu_naissance_52,
  p5_.adresse AS adresse_53,
  p5_.num_carnet AS num_carnet_54,
  p5_.groupe_sanguin AS groupe_sanguin_55,
  p5_.referencement AS referencement_56,
  m6_.id AS id_57,
  m6_.libelle AS libelle_58,
  m6_.type AS type_59,
  m6_.actif AS actif_60,
  m6_.notes AS notes_61,
  p0_.devis_id AS devis_id_62,
  p0_.mode_id AS mode_id_63,
  p0_.consultation_id AS consultation_id_64,
  d1_.fiche_id AS fiche_id_65,
  d1_.fiche_medicale_id AS fiche_medicale_id_66,
  f2_.patient_id AS patient_id_67,
  p3_.derniere_consultation_id AS derniere_consultation_id_68,
  f4_.patient_id AS patient_id_69,
  f4_.medecin_id AS medecin_id_70,
  p5_.derniere_consultation_id AS derniere_consultation_id_71
FROM
  paiement_devis p0_
  LEFT JOIN devis d1_ ON p0_.devis_id = d1_.id
  LEFT JOIN fiche_observation f2_ ON d1_.fiche_id = f2_.id
  LEFT JOIN patient p3_ ON f2_.patient_id = p3_.id
  LEFT JOIN fiche_medicale f4_ ON d1_.fiche_medicale_id = f4_.id
  LEFT JOIN patient p5_ ON f4_.patient_id = p5_.id
  INNER JOIN mode_de_paiement m6_ ON p0_.mode_id = m6_.id
WHERE
  p0_.date BETWEEN ?
  AND ?
ORDER BY
  p0_.date DESC

SELECT p0_.id AS id_0, p0_.date AS date_1, p0_.montant AS montant_2, d1_.id AS id_3, d1_.date AS date_4, d1_.montant AS montant_5, d1_.reste AS reste_6, d1_.statut AS statut_7, d1_.type AS type_8, f2_.id AS id_9, f2_.motif AS motif_10, f2_.histoire_maladie AS histoire_maladie_11, f2_.soins_anterieurs AS soins_anterieurs_12, f2_.exo_inspection AS exo_inspection_13, f2_.exo_palpation AS exo_palpation_14, f2_.endo_inspection AS endo_inspection_15, f2_.endo_palpation AS endo_palpation_16, f2_.occlusion AS occlusion_17, f2_.examen_parodontal AS examen_parodontal_18, f2_.diagnostic AS diagnostic_19, f2_.traitement_urgence AS traitement_urgence_20, f2_.traitement_dentaire AS traitement_dentaire_21, f2_.traitement_parodontal AS traitement_parodontal_22, f2_.traitement_orthodontique AS traitement_orthodontique_23, f2_.autres AS autres_24, f2_.created_at AS created_at_25, f2_.tooths_check AS tooths_check_26, p3_.id AS id_27, p3_.nom AS nom_28, p3_.prenom AS prenom_29, p3_.date_naissance AS date_naissance_30, p3_.date_inscription AS date_inscription_31, p3_.sexe AS sexe_32, p3_.telephone AS telephone_33, p3_.email AS email_34, p3_.profession AS profession_35, p3_.lieu_naissance AS lieu_naissance_36, p3_.adresse AS adresse_37, p3_.num_carnet AS num_carnet_38, p3_.groupe_sanguin AS groupe_sanguin_39, p3_.referencement AS referencement_40, f4_.id AS id_41, f4_.created_at AS created_at_42, p5_.id AS id_43, p5_.nom AS nom_44, p5_.prenom AS prenom_45, p5_.date_naissance AS date_naissance_46, p5_.date_inscription AS date_inscription_47, p5_.sexe AS sexe_48, p5_.telephone AS telephone_49, p5_.email AS email_50, p5_.profession AS profession_51, p5_.lieu_naissance AS lieu_naissance_52, p5_.adresse AS adresse_53, p5_.num_carnet AS num_carnet_54, p5_.groupe_sanguin AS groupe_sanguin_55, p5_.referencement AS referencement_56, m6_.id AS id_57, m6_.libelle AS libelle_58, m6_.type AS type_59, m6_.actif AS actif_60, m6_.notes AS notes_61, p0_.devis_id AS devis_id_62, p0_.mode_id AS mode_id_63, p0_.consultation_id AS consultation_id_64, d1_.fiche_id AS fiche_id_65, d1_.fiche_medicale_id AS fiche_medicale_id_66, f2_.patient_id AS patient_id_67, p3_.derniere_consultation_id AS derniere_consultation_id_68, f4_.patient_id AS patient_id_69, f4_.medecin_id AS medecin_id_70, p5_.derniere_consultation_id AS derniere_consultation_id_71 FROM paiement_devis p0_ LEFT JOIN devis d1_ ON p0_.devis_id = d1_.id LEFT JOIN fiche_observation f2_ ON d1_.fiche_id = f2_.id LEFT JOIN patient p3_ ON f2_.patient_id = p3_.id LEFT JOIN fiche_medicale f4_ ON d1_.fiche_medicale_id = f4_.id LEFT JOIN patient p5_ ON f4_.patient_id = p5_.id INNER JOIN mode_de_paiement m6_ ON p0_.mode_id = m6_.id WHERE p0_.date BETWEEN '2026-02-01 00:00:00' AND '2026-02-28 23:59:59' ORDER BY p0_.date DESC;

SELECT
  t0.id AS id_1,
  t0.occlusion AS occlusion_2,
  t0.mediane AS mediane_3,
  t0.classes_angle AS classes_angle_4,
  t0.vestibules AS vestibules_5,
  t0.hbd AS hbd_6,
  t0.brossage AS brossage_7,
  t0.soccu AS soccu_8,
  t0.cinematique_mandibulaire AS cinematique_mandibulaire_9,
  t0.ouverture_buccale AS ouverture_buccale_10,
  t0.temperature_buccale AS temperature_buccale_11,
  t0.amplitude_ouverture AS amplitude_ouverture_12,
  t0.bruits_articulaires AS bruits_articulaires_13,
  t0.tissus_mous_table AS tissus_mous_table_14,
  t0.tissus_durs_table AS tissus_durs_table_15,
  t0.examen_canaux_excreteurs AS examen_canaux_excreteurs_16,
  t0.fiche_medicale_id AS fiche_medicale_id_17
FROM
  fiche_examen t0
WHERE
  t0.fiche_medicale_id = ?

SELECT t0.id AS id_1, t0.occlusion AS occlusion_2, t0.mediane AS mediane_3, t0.classes_angle AS classes_angle_4, t0.vestibules AS vestibules_5, t0.hbd AS hbd_6, t0.brossage AS brossage_7, t0.soccu AS soccu_8, t0.cinematique_mandibulaire AS cinematique_mandibulaire_9, t0.ouverture_buccale AS ouverture_buccale_10, t0.temperature_buccale AS temperature_buccale_11, t0.amplitude_ouverture AS amplitude_ouverture_12, t0.bruits_articulaires AS bruits_articulaires_13, t0.tissus_mous_table AS tissus_mous_table_14, t0.tissus_durs_table AS tissus_durs_table_15, t0.examen_canaux_excreteurs AS examen_canaux_excreteurs_16, t0.fiche_medicale_id AS fiche_medicale_id_17 FROM fiche_examen t0 WHERE t0.fiche_medicale_id = 417;

SELECT
  t0.id AS id_1,
  t0.motif_consultation AS motif_consultation_2,
  t0.anamnese AS anamnese_3,
  t0.allaitement AS allaitement_4,
  t0.grossesse_en_cours AS grossesse_en_cours_5,
  t0.menstrues AS menstrues_6,
  t0.fiche_medicale_id AS fiche_medicale_id_7
FROM
  fiche_entretien t0
WHERE
  t0.fiche_medicale_id = ?

SELECT t0.id AS id_1, t0.motif_consultation AS motif_consultation_2, t0.anamnese AS anamnese_3, t0.allaitement AS allaitement_4, t0.grossesse_en_cours AS grossesse_en_cours_5, t0.menstrues AS menstrues_6, t0.fiche_medicale_id AS fiche_medicale_id_7 FROM fiche_entretien t0 WHERE t0.fiche_medicale_id = 417;

SELECT
  t0.id AS id_1,
  t0.montant AS montant_2,
  t0.type AS type_3,
  t0.description AS description_4,
  t0.date_transaction AS date_transaction_5,
  t0.mode_de_paiement_id AS mode_de_paiement_id_6,
  t0.paiement_devis_id AS paiement_devis_id_7
FROM
  transaction t0
WHERE
  t0.paiement_devis_id = ?

SELECT t0.id AS id_1, t0.montant AS montant_2, t0.type AS type_3, t0.description AS description_4, t0.date_transaction AS date_transaction_5, t0.mode_de_paiement_id AS mode_de_paiement_id_6, t0.paiement_devis_id AS paiement_devis_id_7 FROM transaction t0 WHERE t0.paiement_devis_id = 890;

SELECT
  t0.id AS id_1,
  t0.note_seance AS note_seance_2,
  t0.type AS type_3,
  t0.statut AS statut_4,
  t0.created_at AS created_at_5,
  t0.patient_id AS patient_id_6,
  t0.fiche_id AS fiche_id_7,
  t0.fiche_medicale_id AS fiche_medicale_id_8,
  t0.medecin_id AS medecin_id_9,
  t0.infirmier_id AS infirmier_id_10,
  t0.salle_id AS salle_id_11,
  t12.id AS id_13,
  t12.date AS date_14,
  t12.montant AS montant_15,
  t12.devis_id AS devis_id_16,
  t12.mode_id AS mode_id_17,
  t12.consultation_id AS consultation_id_18,
  t0.facture_id AS facture_id_19
FROM
  consultation t0
  LEFT JOIN paiement_devis t12 ON t12.consultation_id = t0.id
WHERE
  t0.facture_id = ?

SELECT t0.id AS id_1, t0.note_seance AS note_seance_2, t0.type AS type_3, t0.statut AS statut_4, t0.created_at AS created_at_5, t0.patient_id AS patient_id_6, t0.fiche_id AS fiche_id_7, t0.fiche_medicale_id AS fiche_medicale_id_8, t0.medecin_id AS medecin_id_9, t0.infirmier_id AS infirmier_id_10, t0.salle_id AS salle_id_11, t12.id AS id_13, t12.date AS date_14, t12.montant AS montant_15, t12.devis_id AS devis_id_16, t12.mode_id AS mode_id_17, t12.consultation_id AS consultation_id_18, t0.facture_id AS facture_id_19 FROM consultation t0 LEFT JOIN paiement_devis t12 ON t12.consultation_id = t0.id WHERE t0.facture_id = 1162;

SELECT
  t0.id AS id_1,
  t0.formule_dentaire AS formule_dentaire_2,
  t0.radiographie_extra_buccale_hypothese AS radiographie_extra_buccale_hypothese_3,
  t0.radiographie_intra_buccale_hypothese AS radiographie_intra_buccale_hypothese_4,
  t0.nfs_detaillee AS nfs_detaillee_5,
  t0.tp_tca_inr AS tp_tca_inr_6,
  t0.uree AS uree_7,
  t0.creatininemie AS creatininemie_8,
  t0.glycemie AS glycemie_9,
  t0.diagnostic_positif AS diagnostic_positif_10,
  t0.fiche_medicale_id AS fiche_medicale_id_11
FROM
  fiche_bilan t0
WHERE
  t0.fiche_medicale_id = ?

SELECT t0.id AS id_1, t0.formule_dentaire AS formule_dentaire_2, t0.radiographie_extra_buccale_hypothese AS radiographie_extra_buccale_hypothese_3, t0.radiographie_intra_buccale_hypothese AS radiographie_intra_buccale_hypothese_4, t0.nfs_detaillee AS nfs_detaillee_5, t0.tp_tca_inr AS tp_tca_inr_6, t0.uree AS uree_7, t0.creatininemie AS creatininemie_8, t0.glycemie AS glycemie_9, t0.diagnostic_positif AS diagnostic_positif_10, t0.fiche_medicale_id AS fiche_medicale_id_11 FROM fiche_bilan t0 WHERE t0.fiche_medicale_id = 417;

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.lien_parente AS lien_parente_3,
  t0.telephone AS telephone_4,
  t0.patient_id AS patient_id_5
FROM
  contact_urgence t0
WHERE
  t0.patient_id = ?

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.lien_parente AS lien_parente_3, t0.telephone AS telephone_4, t0.patient_id AS patient_id_5 FROM contact_urgence t0 WHERE t0.patient_id = 417;

SELECT
  t0.id AS id_1,
  t0.username AS username_2,
  t0.roles AS roles_3,
  t0.password AS password_4
FROM
  `user` t0
WHERE
  t0.username = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4 FROM `user` t0 WHERE t0.username = 'Admin' LIMIT 1;

SELECT
  n0_.id AS id_0,
  n0_.message AS message_1,
  n0_.type AS type_2,
  n0_.date_envoi AS date_envoi_3,
  n0_.etat_vu AS etat_vu_4,
  n0_.link AS link_5,
  n0_.priority AS priority_6,
  n0_.user_id AS user_id_7,
  n0_.emitter_id AS emitter_id_8
FROM
  notification n0_
WHERE
  n0_.user_id = ?
  AND n0_.etat_vu = ?
  AND n0_.link IS NOT NULL
ORDER BY
  n0_.date_envoi DESC
LIMIT
  50

SELECT n0_.id AS id_0, n0_.message AS message_1, n0_.type AS type_2, n0_.date_envoi AS date_envoi_3, n0_.etat_vu AS etat_vu_4, n0_.link AS link_5, n0_.priority AS priority_6, n0_.user_id AS user_id_7, n0_.emitter_id AS emitter_id_8 FROM notification n0_ WHERE n0_.user_id = 15 AND n0_.etat_vu = 'non_vu' AND n0_.link IS NOT NULL ORDER BY n0_.date_envoi DESC LIMIT 50;

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.prenom AS prenom_3,
  t0.date_naissance AS date_naissance_4,
  t0.date_inscription AS date_inscription_5,
  t0.sexe AS sexe_6,
  t0.telephone AS telephone_7,
  t0.email AS email_8,
  t0.profession AS profession_9,
  t0.lieu_naissance AS lieu_naissance_10,
  t0.adresse AS adresse_11,
  t0.num_carnet AS num_carnet_12,
  t0.groupe_sanguin AS groupe_sanguin_13,
  t0.referencement AS referencement_14,
  t15.id AS id_16,
  t15.nom AS nom_17,
  t15.lien_parente AS lien_parente_18,
  t15.telephone AS telephone_19,
  t15.patient_id AS patient_id_20,
  t0.derniere_consultation_id AS derniere_consultation_id_21
FROM
  patient t0
  LEFT JOIN contact_urgence t15 ON t15.patient_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.prenom AS prenom_3, t0.date_naissance AS date_naissance_4, t0.date_inscription AS date_inscription_5, t0.sexe AS sexe_6, t0.telephone AS telephone_7, t0.email AS email_8, t0.profession AS profession_9, t0.lieu_naissance AS lieu_naissance_10, t0.adresse AS adresse_11, t0.num_carnet AS num_carnet_12, t0.groupe_sanguin AS groupe_sanguin_13, t0.referencement AS referencement_14, t15.id AS id_16, t15.nom AS nom_17, t15.lien_parente AS lien_parente_18, t15.telephone AS telephone_19, t15.patient_id AS patient_id_20, t0.derniere_consultation_id AS derniere_consultation_id_21 FROM patient t0 LEFT JOIN contact_urgence t15 ON t15.patient_id = t0.id WHERE t0.id = 112;

SELECT
  t0.id AS id_1,
  t0.note_seance AS note_seance_2,
  t0.type AS type_3,
  t0.statut AS statut_4,
  t0.created_at AS created_at_5,
  t0.patient_id AS patient_id_6,
  t0.fiche_id AS fiche_id_7,
  t0.fiche_medicale_id AS fiche_medicale_id_8,
  t0.medecin_id AS medecin_id_9,
  t0.infirmier_id AS infirmier_id_10,
  t0.salle_id AS salle_id_11,
  t12.id AS id_13,
  t12.date AS date_14,
  t12.montant AS montant_15,
  t12.devis_id AS devis_id_16,
  t12.mode_id AS mode_id_17,
  t12.consultation_id AS consultation_id_18,
  t0.facture_id AS facture_id_19
FROM
  consultation t0
  LEFT JOIN paiement_devis t12 ON t12.consultation_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.note_seance AS note_seance_2, t0.type AS type_3, t0.statut AS statut_4, t0.created_at AS created_at_5, t0.patient_id AS patient_id_6, t0.fiche_id AS fiche_id_7, t0.fiche_medicale_id AS fiche_medicale_id_8, t0.medecin_id AS medecin_id_9, t0.infirmier_id AS infirmier_id_10, t0.salle_id AS salle_id_11, t12.id AS id_13, t12.date AS date_14, t12.montant AS montant_15, t12.devis_id AS devis_id_16, t12.mode_id AS mode_id_17, t12.consultation_id AS consultation_id_18, t0.facture_id AS facture_id_19 FROM consultation t0 LEFT JOIN paiement_devis t12 ON t12.consultation_id = t0.id WHERE t0.id = 1164;