Symfony Profiler

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
  d0_.id AS id_0,
  d0_.date AS date_1,
  d0_.montant AS montant_2,
  d0_.reste AS reste_3,
  d0_.statut AS statut_4,
  d0_.type AS type_5,
  f1_.id AS id_6,
  f1_.motif AS motif_7,
  f1_.histoire_maladie AS histoire_maladie_8,
  f1_.soins_anterieurs AS soins_anterieurs_9,
  f1_.exo_inspection AS exo_inspection_10,
  f1_.exo_palpation AS exo_palpation_11,
  f1_.endo_inspection AS endo_inspection_12,
  f1_.endo_palpation AS endo_palpation_13,
  f1_.occlusion AS occlusion_14,
  f1_.examen_parodontal AS examen_parodontal_15,
  f1_.diagnostic AS diagnostic_16,
  f1_.traitement_urgence AS traitement_urgence_17,
  f1_.traitement_dentaire AS traitement_dentaire_18,
  f1_.traitement_parodontal AS traitement_parodontal_19,
  f1_.traitement_orthodontique AS traitement_orthodontique_20,
  f1_.autres AS autres_21,
  f1_.created_at AS created_at_22,
  f1_.tooths_check AS tooths_check_23,
  p2_.id AS id_24,
  p2_.nom AS nom_25,
  p2_.prenom AS prenom_26,
  p2_.date_naissance AS date_naissance_27,
  p2_.date_inscription AS date_inscription_28,
  p2_.sexe AS sexe_29,
  p2_.telephone AS telephone_30,
  p2_.email AS email_31,
  p2_.profession AS profession_32,
  p2_.lieu_naissance AS lieu_naissance_33,
  p2_.adresse AS adresse_34,
  p2_.num_carnet AS num_carnet_35,
  p2_.groupe_sanguin AS groupe_sanguin_36,
  p2_.referencement AS referencement_37,
  f3_.id AS id_38,
  f3_.created_at AS created_at_39,
  p4_.id AS id_40,
  p4_.nom AS nom_41,
  p4_.prenom AS prenom_42,
  p4_.date_naissance AS date_naissance_43,
  p4_.date_inscription AS date_inscription_44,
  p4_.sexe AS sexe_45,
  p4_.telephone AS telephone_46,
  p4_.email AS email_47,
  p4_.profession AS profession_48,
  p4_.lieu_naissance AS lieu_naissance_49,
  p4_.adresse AS adresse_50,
  p4_.num_carnet AS num_carnet_51,
  p4_.groupe_sanguin AS groupe_sanguin_52,
  p4_.referencement AS referencement_53,
  d0_.fiche_id AS fiche_id_54,
  d0_.fiche_medicale_id AS fiche_medicale_id_55,
  f1_.patient_id AS patient_id_56,
  p2_.derniere_consultation_id AS derniere_consultation_id_57,
  f3_.patient_id AS patient_id_58,
  f3_.medecin_id AS medecin_id_59,
  p4_.derniere_consultation_id AS derniere_consultation_id_60
FROM
  devis d0_
  LEFT JOIN fiche_observation f1_ ON d0_.fiche_id = f1_.id
  LEFT JOIN patient p2_ ON f1_.patient_id = p2_.id
  LEFT JOIN fiche_medicale f3_ ON d0_.fiche_medicale_id = f3_.id
  LEFT JOIN patient p4_ ON f3_.patient_id = p4_.id
  INNER JOIN consultation c5_ ON (c5_.facture_id = d0_.id)
WHERE
  d0_.type = ?
  AND (
    d0_.date BETWEEN ?
    AND ?
  )
ORDER BY
  d0_.date DESC

SELECT d0_.id AS id_0, d0_.date AS date_1, d0_.montant AS montant_2, d0_.reste AS reste_3, d0_.statut AS statut_4, d0_.type AS type_5, f1_.id AS id_6, f1_.motif AS motif_7, f1_.histoire_maladie AS histoire_maladie_8, f1_.soins_anterieurs AS soins_anterieurs_9, f1_.exo_inspection AS exo_inspection_10, f1_.exo_palpation AS exo_palpation_11, f1_.endo_inspection AS endo_inspection_12, f1_.endo_palpation AS endo_palpation_13, f1_.occlusion AS occlusion_14, f1_.examen_parodontal AS examen_parodontal_15, f1_.diagnostic AS diagnostic_16, f1_.traitement_urgence AS traitement_urgence_17, f1_.traitement_dentaire AS traitement_dentaire_18, f1_.traitement_parodontal AS traitement_parodontal_19, f1_.traitement_orthodontique AS traitement_orthodontique_20, f1_.autres AS autres_21, f1_.created_at AS created_at_22, f1_.tooths_check AS tooths_check_23, p2_.id AS id_24, p2_.nom AS nom_25, p2_.prenom AS prenom_26, p2_.date_naissance AS date_naissance_27, p2_.date_inscription AS date_inscription_28, p2_.sexe AS sexe_29, p2_.telephone AS telephone_30, p2_.email AS email_31, p2_.profession AS profession_32, p2_.lieu_naissance AS lieu_naissance_33, p2_.adresse AS adresse_34, p2_.num_carnet AS num_carnet_35, p2_.groupe_sanguin AS groupe_sanguin_36, p2_.referencement AS referencement_37, f3_.id AS id_38, f3_.created_at AS created_at_39, p4_.id AS id_40, p4_.nom AS nom_41, p4_.prenom AS prenom_42, p4_.date_naissance AS date_naissance_43, p4_.date_inscription AS date_inscription_44, p4_.sexe AS sexe_45, p4_.telephone AS telephone_46, p4_.email AS email_47, p4_.profession AS profession_48, p4_.lieu_naissance AS lieu_naissance_49, p4_.adresse AS adresse_50, p4_.num_carnet AS num_carnet_51, p4_.groupe_sanguin AS groupe_sanguin_52, p4_.referencement AS referencement_53, d0_.fiche_id AS fiche_id_54, d0_.fiche_medicale_id AS fiche_medicale_id_55, f1_.patient_id AS patient_id_56, p2_.derniere_consultation_id AS derniere_consultation_id_57, f3_.patient_id AS patient_id_58, f3_.medecin_id AS medecin_id_59, p4_.derniere_consultation_id AS derniere_consultation_id_60 FROM devis d0_ LEFT JOIN fiche_observation f1_ ON d0_.fiche_id = f1_.id LEFT JOIN patient p2_ ON f1_.patient_id = p2_.id LEFT JOIN fiche_medicale f3_ ON d0_.fiche_medicale_id = f3_.id LEFT JOIN patient p4_ ON f3_.patient_id = p4_.id INNER JOIN consultation c5_ ON (c5_.facture_id = d0_.id) WHERE d0_.type = 1 AND (d0_.date BETWEEN '2026-02-01 00:00:00' AND '2026-02-28 23:59:59') ORDER BY d0_.date DESC;

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.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.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;