Symfony Profiler

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

Query Metrics

SELECT t0.id AS id_1, t0.username AS username_2, t0.email AS email_3, t0.roles AS roles_4, t0.password AS password_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.is_active AS is_active_8, t0.avatar AS avatar_9, t0.reset_password_token AS reset_password_token_10, t0.reset_password_requested_at AS reset_password_requested_at_11, t0.compte_id AS compte_id_12, t0.profil_id AS profil_id_13 FROM app_user t0 WHERE t0.id = ?

[
  6
]

SELECT
  t0.id AS id_1,
  t0.username AS username_2,
  t0.email AS email_3,
  t0.roles AS roles_4,
  t0.password AS password_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7,
  t0.is_active AS is_active_8,
  t0.avatar AS avatar_9,
  t0.reset_password_token AS reset_password_token_10,
  t0.reset_password_requested_at AS reset_password_requested_at_11,
  t0.compte_id AS compte_id_12,
  t0.profil_id AS profil_id_13
FROM
  app_user t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.username AS username_2, t0.email AS email_3, t0.roles AS roles_4, t0.password AS password_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.is_active AS is_active_8, t0.avatar AS avatar_9, t0.reset_password_token AS reset_password_token_10, t0.reset_password_requested_at AS reset_password_requested_at_11, t0.compte_id AS compte_id_12, t0.profil_id AS profil_id_13 FROM app_user t0 WHERE t0.id = 6;

SELECT t0.id AS id_1, t0.titre AS titre_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.statut AS statut_5 FROM annee_scolaire t0 ORDER BY t0.titre DESC

[]

SELECT
  t0.id AS id_1,
  t0.titre AS titre_2,
  t0.created_at AS created_at_3,
  t0.updated_at AS updated_at_4,
  t0.statut AS statut_5
FROM
  annee_scolaire t0
ORDER BY
  t0.titre DESC

SELECT t0.id AS id_1, t0.titre AS titre_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.statut AS statut_5 FROM annee_scolaire t0 ORDER BY t0.titre DESC;

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.mail AS mail_3, t0.tel AS tel_4, t0.adresse AS adresse_5, t0.devise AS devise_6, t0.logo AS logo_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.ville_id AS ville_id_10, t0.compte_id AS compte_id_11 FROM annexe t0 WHERE t0.compte_id = ? ORDER BY t0.nom ASC

[
  4
]

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.mail AS mail_3,
  t0.tel AS tel_4,
  t0.adresse AS adresse_5,
  t0.devise AS devise_6,
  t0.logo AS logo_7,
  t0.created_at AS created_at_8,
  t0.updated_at AS updated_at_9,
  t0.ville_id AS ville_id_10,
  t0.compte_id AS compte_id_11
FROM
  annexe t0
WHERE
  t0.compte_id = ?
ORDER BY
  t0.nom ASC

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.mail AS mail_3, t0.tel AS tel_4, t0.adresse AS adresse_5, t0.devise AS devise_6, t0.logo AS logo_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.ville_id AS ville_id_10, t0.compte_id AS compte_id_11 FROM annexe t0 WHERE t0.compte_id = 4 ORDER BY t0.nom ASC;

SELECT DISTINCT t0_.id AS id_0, t0_.nom AS nom_1, t0_.niveau_scolaire AS niveau_scolaire_2, t0_.ordre AS ordre_3, t0_.section_scolaire_id AS section_scolaire_id_4 FROM type_classe t0_ INNER JOIN classe c1_ ON t0_.id = c1_.type_id WHERE c1_.compte_id = ? AND c1_.statut <> ? ORDER BY t0_.nom ASC

[
  4
  "Inactif"
]

SELECT
  DISTINCT t0_.id AS id_0,
  t0_.nom AS nom_1,
  t0_.niveau_scolaire AS niveau_scolaire_2,
  t0_.ordre AS ordre_3,
  t0_.section_scolaire_id AS section_scolaire_id_4
FROM
  type_classe t0_
  INNER JOIN classe c1_ ON t0_.id = c1_.type_id
WHERE
  c1_.compte_id = ?
  AND c1_.statut <> ?
ORDER BY
  t0_.nom ASC

SELECT DISTINCT t0_.id AS id_0, t0_.nom AS nom_1, t0_.niveau_scolaire AS niveau_scolaire_2, t0_.ordre AS ordre_3, t0_.section_scolaire_id AS section_scolaire_id_4 FROM type_classe t0_ INNER JOIN classe c1_ ON t0_.id = c1_.type_id WHERE c1_.compte_id = 4 AND c1_.statut <> 'Inactif' ORDER BY t0_.nom ASC;

SELECT e0_.id AS id_0, e0_.numero AS numero_1, e0_.libelle AS libelle_2, e0_.date_limite AS date_limite_3, e0_.est_finale AS est_finale_4, e0_.created_at AS created_at_5, e0_.updated_at AS updated_at_6, e1_.id AS id_7, e1_.niveau_scolaire AS niveau_scolaire_8, e1_.montant AS montant_9, a2_.id AS id_10, a2_.titre AS titre_11, a2_.created_at AS created_at_12, a2_.updated_at AS updated_at_13, a2_.statut AS statut_14, e0_.annee_scolaire_id AS annee_scolaire_id_15, e0_.compte_id AS compte_id_16, e1_.echeance_id AS echeance_id_17 FROM echeance_paiement e0_ LEFT JOIN echeance_montant e1_ ON e0_.id = e1_.echeance_id LEFT JOIN annee_scolaire a2_ ON e0_.annee_scolaire_id = a2_.id WHERE e0_.compte_id = ? ORDER BY a2_.titre DESC, e0_.numero ASC

[
  4
]

SELECT
  e0_.id AS id_0,
  e0_.numero AS numero_1,
  e0_.libelle AS libelle_2,
  e0_.date_limite AS date_limite_3,
  e0_.est_finale AS est_finale_4,
  e0_.created_at AS created_at_5,
  e0_.updated_at AS updated_at_6,
  e1_.id AS id_7,
  e1_.niveau_scolaire AS niveau_scolaire_8,
  e1_.montant AS montant_9,
  a2_.id AS id_10,
  a2_.titre AS titre_11,
  a2_.created_at AS created_at_12,
  a2_.updated_at AS updated_at_13,
  a2_.statut AS statut_14,
  e0_.annee_scolaire_id AS annee_scolaire_id_15,
  e0_.compte_id AS compte_id_16,
  e1_.echeance_id AS echeance_id_17
FROM
  echeance_paiement e0_
  LEFT JOIN echeance_montant e1_ ON e0_.id = e1_.echeance_id
  LEFT JOIN annee_scolaire a2_ ON e0_.annee_scolaire_id = a2_.id
WHERE
  e0_.compte_id = ?
ORDER BY
  a2_.titre DESC,
  e0_.numero ASC

SELECT e0_.id AS id_0, e0_.numero AS numero_1, e0_.libelle AS libelle_2, e0_.date_limite AS date_limite_3, e0_.est_finale AS est_finale_4, e0_.created_at AS created_at_5, e0_.updated_at AS updated_at_6, e1_.id AS id_7, e1_.niveau_scolaire AS niveau_scolaire_8, e1_.montant AS montant_9, a2_.id AS id_10, a2_.titre AS titre_11, a2_.created_at AS created_at_12, a2_.updated_at AS updated_at_13, a2_.statut AS statut_14, e0_.annee_scolaire_id AS annee_scolaire_id_15, e0_.compte_id AS compte_id_16, e1_.echeance_id AS echeance_id_17 FROM echeance_paiement e0_ LEFT JOIN echeance_montant e1_ ON e0_.id = e1_.echeance_id LEFT JOIN annee_scolaire a2_ ON e0_.annee_scolaire_id = a2_.id WHERE e0_.compte_id = 4 ORDER BY a2_.titre DESC, e0_.numero ASC;

SELECT t0.id AS id_1, t0.titre AS titre_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.statut AS statut_5 FROM annee_scolaire t0 WHERE t0.statut = ? ORDER BY t0.id DESC LIMIT 1

[
  "Actif"
]

SELECT
  t0.id AS id_1,
  t0.titre AS titre_2,
  t0.created_at AS created_at_3,
  t0.updated_at AS updated_at_4,
  t0.statut AS statut_5
FROM
  annee_scolaire t0
WHERE
  t0.statut = ?
ORDER BY
  t0.id DESC
LIMIT
  1

SELECT t0.id AS id_1, t0.titre AS titre_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.statut AS statut_5 FROM annee_scolaire t0 WHERE t0.statut = 'Actif' ORDER BY t0.id DESC LIMIT 1;

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.mail AS mail_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.type_id AS type_id_6 FROM compte t0 WHERE t0.id = ?

[
  4
]

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.mail AS mail_3,
  t0.created_at AS created_at_4,
  t0.updated_at AS updated_at_5,
  t0.type_id AS type_id_6
FROM
  compte t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.mail AS mail_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.type_id AS type_id_6 FROM compte t0 WHERE t0.id = 4;