Symfony Profiler

• Request / Response
• API Platform
• Performance
• Validator
• Forms
• Exception
• Logs 7
• 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.Nom AS Nom_3, t0.Prenom AS Prenom_4, t0.EstResponsable AS EstResponsable_5, t0.roles AS roles_6, t0.password AS password_7 FROM `user` t0 WHERE t0.username = ? LIMIT 1

[
  "wirus@gmail.com"
]

SELECT
  t0.id AS id_1,
  t0.username AS username_2,
  t0.Nom AS Nom_3,
  t0.Prenom AS Prenom_4,
  t0.EstResponsable AS EstResponsable_5,
  t0.roles AS roles_6,
  t0.password AS password_7
FROM
  `user` t0
WHERE
  t0.username = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.username AS username_2, t0.Nom AS Nom_3, t0.Prenom AS Prenom_4, t0.EstResponsable AS EstResponsable_5, t0.roles AS roles_6, t0.password AS password_7 FROM `user` t0 WHERE t0.username = 'wirus@gmail.com' LIMIT 1;

SELECT t0.IDDossard AS IDDossard_1, t0.NumDossard AS NumDossard_2, t0.QRcode AS QRcode_3, t0.IDCourse AS IDCourse_4 FROM Dossard t0 WHERE t0.NumDossard = ? LIMIT 1

[
  "1004"
]

SELECT
  t0.IDDossard AS IDDossard_1,
  t0.NumDossard AS NumDossard_2,
  t0.QRcode AS QRcode_3,
  t0.IDCourse AS IDCourse_4
FROM
  Dossard t0
WHERE
  t0.NumDossard = ?
LIMIT
  1

SELECT t0.IDDossard AS IDDossard_1, t0.NumDossard AS NumDossard_2, t0.QRcode AS QRcode_3, t0.IDCourse AS IDCourse_4 FROM Dossard t0 WHERE t0.NumDossard = '1004' LIMIT 1;

SELECT t0.IDParticipant AS IDParticipant_1, t0.HeureDepart AS HeureDepart_2, t0.HeureArrivee AS HeureArrivee_3, t0.TempsTotal AS TempsTotal_4, t0.Emargement AS Emargement_5, t0.IDCoureur AS IDCoureur_6, t0.IDEtatCoureur AS IDEtatCoureur_7, t0.IDCourse AS IDCourse_8, t0.IDDossard AS IDDossard_9 FROM Participant t0 WHERE t0.IDDossard = ? LIMIT 1

[
  8
]

SELECT
  t0.IDParticipant AS IDParticipant_1,
  t0.HeureDepart AS HeureDepart_2,
  t0.HeureArrivee AS HeureArrivee_3,
  t0.TempsTotal AS TempsTotal_4,
  t0.Emargement AS Emargement_5,
  t0.IDCoureur AS IDCoureur_6,
  t0.IDEtatCoureur AS IDEtatCoureur_7,
  t0.IDCourse AS IDCourse_8,
  t0.IDDossard AS IDDossard_9
FROM
  Participant t0
WHERE
  t0.IDDossard = ?
LIMIT
  1

SELECT t0.IDParticipant AS IDParticipant_1, t0.HeureDepart AS HeureDepart_2, t0.HeureArrivee AS HeureArrivee_3, t0.TempsTotal AS TempsTotal_4, t0.Emargement AS Emargement_5, t0.IDCoureur AS IDCoureur_6, t0.IDEtatCoureur AS IDEtatCoureur_7, t0.IDCourse AS IDCourse_8, t0.IDDossard AS IDDossard_9 FROM Participant t0 WHERE t0.IDDossard = 8 LIMIT 1;

SELECT t0.IDPointControle AS IDPointControle_1, t0.Libelle AS Libelle_2, t0.Code AS Code_3, t0.TelPC AS TelPC_4, t0.EstCloture AS EstCloture_5, t0.DateCloture AS DateCloture_6, t0.HeureCloture AS HeureCloture_7 FROM PointControle t0 WHERE t0.IDPointControle = ?

[
  3
]

SELECT
  t0.IDPointControle AS IDPointControle_1,
  t0.Libelle AS Libelle_2,
  t0.Code AS Code_3,
  t0.TelPC AS TelPC_4,
  t0.EstCloture AS EstCloture_5,
  t0.DateCloture AS DateCloture_6,
  t0.HeureCloture AS HeureCloture_7
FROM
  PointControle t0
WHERE
  t0.IDPointControle = ?

SELECT t0.IDPointControle AS IDPointControle_1, t0.Libelle AS Libelle_2, t0.Code AS Code_3, t0.TelPC AS TelPC_4, t0.EstCloture AS EstCloture_5, t0.DateCloture AS DateCloture_6, t0.HeureCloture AS HeureCloture_7 FROM PointControle t0 WHERE t0.IDPointControle = 3;

SELECT t0.IDCourse AS IDCourse_1, t0.Code AS Code_2, t0.Nom AS Nom_3, t0.PrixEnAriary AS PrixEnAriary_4, t0.PrixEnEuro AS PrixEnEuro_5, t0.DepartOK AS DepartOK_6, t0.DateDepart AS DateDepart_7, t0.HeureDepart AS HeureDepart_8, t0.DateFin AS DateFin_9, t0.HeureFin AS HeureFin_10, t0.CodeCouleur AS CodeCouleur_11, t0.LieuCourse AS LieuCourse_12, t0.DateCourse AS DateCourse_13, t0.DistanceEnKm AS DistanceEnKm_14, t0.Lieu AS Lieu_15, t0.AgeMinimum AS AgeMinimum_16, t0.AgeMaximum AS AgeMaximum_17, t0.WithScratch AS WithScratch_18, t0.BarriereHor AS BarriereHor_19, t0.DistanceCourse AS DistanceCourse_20 FROM rd_course t0 WHERE t0.IDCourse = ?

[
  3
]

SELECT
  t0.IDCourse AS IDCourse_1,
  t0.Code AS Code_2,
  t0.Nom AS Nom_3,
  t0.PrixEnAriary AS PrixEnAriary_4,
  t0.PrixEnEuro AS PrixEnEuro_5,
  t0.DepartOK AS DepartOK_6,
  t0.DateDepart AS DateDepart_7,
  t0.HeureDepart AS HeureDepart_8,
  t0.DateFin AS DateFin_9,
  t0.HeureFin AS HeureFin_10,
  t0.CodeCouleur AS CodeCouleur_11,
  t0.LieuCourse AS LieuCourse_12,
  t0.DateCourse AS DateCourse_13,
  t0.DistanceEnKm AS DistanceEnKm_14,
  t0.Lieu AS Lieu_15,
  t0.AgeMinimum AS AgeMinimum_16,
  t0.AgeMaximum AS AgeMaximum_17,
  t0.WithScratch AS WithScratch_18,
  t0.BarriereHor AS BarriereHor_19,
  t0.DistanceCourse AS DistanceCourse_20
FROM
  rd_course t0
WHERE
  t0.IDCourse = ?

SELECT t0.IDCourse AS IDCourse_1, t0.Code AS Code_2, t0.Nom AS Nom_3, t0.PrixEnAriary AS PrixEnAriary_4, t0.PrixEnEuro AS PrixEnEuro_5, t0.DepartOK AS DepartOK_6, t0.DateDepart AS DateDepart_7, t0.HeureDepart AS HeureDepart_8, t0.DateFin AS DateFin_9, t0.HeureFin AS HeureFin_10, t0.CodeCouleur AS CodeCouleur_11, t0.LieuCourse AS LieuCourse_12, t0.DateCourse AS DateCourse_13, t0.DistanceEnKm AS DistanceEnKm_14, t0.Lieu AS Lieu_15, t0.AgeMinimum AS AgeMinimum_16, t0.AgeMaximum AS AgeMaximum_17, t0.WithScratch AS WithScratch_18, t0.BarriereHor AS BarriereHor_19, t0.DistanceCourse AS DistanceCourse_20 FROM rd_course t0 WHERE t0.IDCourse = 3;

SELECT t0.IDPCParCourse AS IDPCParCourse_1, t0.numero AS numero_2, t0.IDPointControle AS IDPointControle_3, t0.IDCourse AS IDCourse_4 FROM PCParCourse t0 WHERE t0.IDCourse = ?

[
  3
]

SELECT
  t0.IDPCParCourse AS IDPCParCourse_1,
  t0.numero AS numero_2,
  t0.IDPointControle AS IDPointControle_3,
  t0.IDCourse AS IDCourse_4
FROM
  PCParCourse t0
WHERE
  t0.IDCourse = ?

SELECT t0.IDPCParCourse AS IDPCParCourse_1, t0.numero AS numero_2, t0.IDPointControle AS IDPointControle_3, t0.IDCourse AS IDCourse_4 FROM PCParCourse t0 WHERE t0.IDCourse = 3;

SELECT t0.id AS id_1, t0.username AS username_2, t0.Nom AS Nom_3, t0.Prenom AS Prenom_4, t0.EstResponsable AS EstResponsable_5, t0.roles AS roles_6, t0.password AS password_7 FROM `user` t0 INNER JOIN responsable_pc ON t0.id = responsable_pc.id_user WHERE responsable_pc.IDPointControle = ?

[
  3
]

SELECT
  t0.id AS id_1,
  t0.username AS username_2,
  t0.Nom AS Nom_3,
  t0.Prenom AS Prenom_4,
  t0.EstResponsable AS EstResponsable_5,
  t0.roles AS roles_6,
  t0.password AS password_7
FROM
  `user` t0
  INNER JOIN responsable_pc ON t0.id = responsable_pc.id_user
WHERE
  responsable_pc.IDPointControle = ?

SELECT t0.id AS id_1, t0.username AS username_2, t0.Nom AS Nom_3, t0.Prenom AS Prenom_4, t0.EstResponsable AS EstResponsable_5, t0.roles AS roles_6, t0.password AS password_7 FROM `user` t0 INNER JOIN responsable_pc ON t0.id = responsable_pc.id_user WHERE responsable_pc.IDPointControle = 3;

SELECT t0.IDCoureurParPC AS IDCoureurParPC_1, t0.Date AS Date_2, t0.HeureDePassage AS HeureDePassage_3, t0.IDPointControle AS IDPointControle_4, t0.IDParticipant AS IDParticipant_5, t0.IDUserResponsable AS IDUserResponsable_6 FROM CoureurParPC t0 WHERE t0.IDPointControle = ? AND t0.IDParticipant = ? LIMIT 1

[
  3
  5
]

SELECT
  t0.IDCoureurParPC AS IDCoureurParPC_1,
  t0.Date AS Date_2,
  t0.HeureDePassage AS HeureDePassage_3,
  t0.IDPointControle AS IDPointControle_4,
  t0.IDParticipant AS IDParticipant_5,
  t0.IDUserResponsable AS IDUserResponsable_6
FROM
  CoureurParPC t0
WHERE
  t0.IDPointControle = ?
  AND t0.IDParticipant = ?
LIMIT
  1

SELECT t0.IDCoureurParPC AS IDCoureurParPC_1, t0.Date AS Date_2, t0.HeureDePassage AS HeureDePassage_3, t0.IDPointControle AS IDPointControle_4, t0.IDParticipant AS IDParticipant_5, t0.IDUserResponsable AS IDUserResponsable_6 FROM CoureurParPC t0 WHERE t0.IDPointControle = 3 AND t0.IDParticipant = 5 LIMIT 1;

SELECT t0.IDEtatCoureur AS IDEtatCoureur_1, t0.Code AS Code_2, t0.Libelle AS Libelle_3 FROM EtatCoureur t0 WHERE t0.Code = ? LIMIT 1

[
  2
]

SELECT
  t0.IDEtatCoureur AS IDEtatCoureur_1,
  t0.Code AS Code_2,
  t0.Libelle AS Libelle_3
FROM
  EtatCoureur t0
WHERE
  t0.Code = ?
LIMIT
  1

SELECT t0.IDEtatCoureur AS IDEtatCoureur_1, t0.Code AS Code_2, t0.Libelle AS Libelle_3 FROM EtatCoureur t0 WHERE t0.Code = 2 LIMIT 1;

"START TRANSACTION"

[]

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO CoureurParPC (Date, HeureDePassage, IDPointControle, IDParticipant, IDUserResponsable) VALUES (?, ?, ?, ?, ?)

[
  "2026-03-13"
  "14:00:18"
  3
  5
  4
]

INSERT INTO CoureurParPC (
  Date, HeureDePassage, IDPointControle,
  IDParticipant, IDUserResponsable
)
VALUES
  (?, ?, ?, ?, ?)

INSERT INTO CoureurParPC (Date, HeureDePassage, IDPointControle, IDParticipant, IDUserResponsable) VALUES ('2026-03-13', '14:00:18', 3, 5, 4);

DELETE FROM CoureurParPC WHERE IDCoureurParPC = ?

[
  7
]

DELETE FROM
  CoureurParPC
WHERE
  IDCoureurParPC = ?

DELETE FROM CoureurParPC WHERE IDCoureurParPC = 7;

"COMMIT"

[]

"COMMIT"

"COMMIT";