Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception
• Logs 1
• Events
• Routing
• Cache
• Translation
• Security
• Twig
• HTTP Client
• Doctrine 1
• Debug
• Messages
• Emails
• Notifications
• Serializer
• Configuration

Query Metrics

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.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.username AS username_2, t0.roles AS roles_3, t0.password AS password_4 FROM `user` t0 WHERE t0.username = ? LIMIT 1

[
  "Admin"
]

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 t0.id AS id_1, t0.date AS date_2, t0.montant AS montant_3, t0.devis_id AS devis_id_4, t0.mode_id AS mode_id_5, t0.consultation_id AS consultation_id_6, t7.id AS id_8, t7.montant AS montant_9, t7.type AS type_10, t7.description AS description_11, t7.date_transaction AS date_transaction_12, t7.mode_de_paiement_id AS mode_de_paiement_id_13, t7.paiement_devis_id AS paiement_devis_id_14 FROM paiement_devis t0 LEFT JOIN transaction t7 ON t7.paiement_devis_id = t0.id WHERE t0.id = ?

[
  890
]

SELECT
  t0.id AS id_1,
  t0.date AS date_2,
  t0.montant AS montant_3,
  t0.devis_id AS devis_id_4,
  t0.mode_id AS mode_id_5,
  t0.consultation_id AS consultation_id_6,
  t7.id AS id_8,
  t7.montant AS montant_9,
  t7.type AS type_10,
  t7.description AS description_11,
  t7.date_transaction AS date_transaction_12,
  t7.mode_de_paiement_id AS mode_de_paiement_id_13,
  t7.paiement_devis_id AS paiement_devis_id_14
FROM
  paiement_devis t0
  LEFT JOIN transaction t7 ON t7.paiement_devis_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.date AS date_2, t0.montant AS montant_3, t0.devis_id AS devis_id_4, t0.mode_id AS mode_id_5, t0.consultation_id AS consultation_id_6, t7.id AS id_8, t7.montant AS montant_9, t7.type AS type_10, t7.description AS description_11, t7.date_transaction AS date_transaction_12, t7.mode_de_paiement_id AS mode_de_paiement_id_13, t7.paiement_devis_id AS paiement_devis_id_14 FROM paiement_devis t0 LEFT JOIN transaction t7 ON t7.paiement_devis_id = t0.id WHERE t0.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.id = ?

[
  1164
]

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;

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

[
  15
  "non_vu"
]

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.libelle AS libelle_2, t0.type AS type_3, t0.actif AS actif_4, t0.notes AS notes_5 FROM mode_de_paiement t0 WHERE t0.id = ?

[
  1
]

SELECT
  t0.id AS id_1,
  t0.libelle AS libelle_2,
  t0.type AS type_3,
  t0.actif AS actif_4,
  t0.notes AS notes_5
FROM
  mode_de_paiement t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.type AS type_3, t0.actif AS actif_4, t0.notes AS notes_5 FROM mode_de_paiement t0 WHERE t0.id = 1;