GET https://runixys.devsoft-pro.net/evenement/1

Response
200 OK
IP
216.73.217.86
Profiled on
Token
4b5f2e

Query Metrics

11 Database Queries
6 Different statements
46.36 ms Query time
0 Invalid entities
36 Managed entities

Queries

Group similar statements

#▲ Time Info
1 3.06 ms 
SELECT t0.IDEvenement AS IDEvenement_1, t0.Nom AS Nom_2, t0.Date AS Date_3, t0.Heure AS Heure_4, t0.Lieu AS Lieu_5, t0.Tags AS Tags_6, t0.Images AS Images_7, t0.EstActif AS EstActif_8, t0.DateCreation AS DateCreation_9, t0.Description AS Description_10, t0.IDOrganisateur AS IDOrganisateur_11, t0.IDCategorieEvenement AS IDCategorieEvenement_12, t0.IDStatutEvenement AS IDStatutEvenement_13 FROM Evenement t0 WHERE t0.IDEvenement = ?
Parameters: 
[
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
2 0.25 ms 
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.Prefix AS Prefix_12, t0.LieuCourse AS LieuCourse_13, t0.DateCourse AS DateCourse_14, t0.DistanceEnKm AS DistanceEnKm_15, t0.HeurePrevu AS HeurePrevu_16, t0.Denivelle AS Denivelle_17, t0.EstDetaille AS EstDetaille_18, t0.Lieu AS Lieu_19, t0.AgeMinimum AS AgeMinimum_20, t0.AgeMaximum AS AgeMaximum_21, t0.WithScratch AS WithScratch_22, t0.BarriereHor AS BarriereHor_23, t0.DistanceCourse AS DistanceCourse_24, t0.DateCreation AS DateCreation_25, t0.DateModif AS DateModif_26, t0.IDEvenement AS IDEvenement_27 FROM rd_course t0 WHERE t0.IDEvenement = ?
Parameters: 
[
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
3 3.45 ms 
SELECT e0_.IDEvenement AS IDEvenement_0, e0_.Nom AS Nom_1, e0_.Date AS Date_2, e0_.Heure AS Heure_3, e0_.Lieu AS Lieu_4, e0_.Tags AS Tags_5, e0_.Images AS Images_6, e0_.EstActif AS EstActif_7, e0_.DateCreation AS DateCreation_8, e0_.Description AS Description_9, e0_.IDOrganisateur AS IDOrganisateur_10, e0_.IDCategorieEvenement AS IDCategorieEvenement_11, e0_.IDStatutEvenement AS IDStatutEvenement_12 FROM Evenement e0_ WHERE e0_.IDEvenement <> ? AND e0_.EstActif = 1 LIMIT 3
Parameters: 
[
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
4 4.66 ms 
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.Prefix AS Prefix_12, t0.LieuCourse AS LieuCourse_13, t0.DateCourse AS DateCourse_14, t0.DistanceEnKm AS DistanceEnKm_15, t0.HeurePrevu AS HeurePrevu_16, t0.Denivelle AS Denivelle_17, t0.EstDetaille AS EstDetaille_18, t0.Lieu AS Lieu_19, t0.AgeMinimum AS AgeMinimum_20, t0.AgeMaximum AS AgeMaximum_21, t0.WithScratch AS WithScratch_22, t0.BarriereHor AS BarriereHor_23, t0.DistanceCourse AS DistanceCourse_24, t0.DateCreation AS DateCreation_25, t0.DateModif AS DateModif_26, t0.IDEvenement AS IDEvenement_27 FROM rd_course t0 WHERE t0.IDEvenement = ?
Parameters: 
[
  2
]
View formatted query    View runnable query    Explain query    View query backtrace
5 0.74 ms 
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.Prefix AS Prefix_12, t0.LieuCourse AS LieuCourse_13, t0.DateCourse AS DateCourse_14, t0.DistanceEnKm AS DistanceEnKm_15, t0.HeurePrevu AS HeurePrevu_16, t0.Denivelle AS Denivelle_17, t0.EstDetaille AS EstDetaille_18, t0.Lieu AS Lieu_19, t0.AgeMinimum AS AgeMinimum_20, t0.AgeMaximum AS AgeMaximum_21, t0.WithScratch AS WithScratch_22, t0.BarriereHor AS BarriereHor_23, t0.DistanceCourse AS DistanceCourse_24, t0.DateCreation AS DateCreation_25, t0.DateModif AS DateModif_26, t0.IDEvenement AS IDEvenement_27 FROM rd_course t0 WHERE t0.IDEvenement = ?
Parameters: 
[
  3
]
View formatted query    View runnable query    Explain query    View query backtrace
6 0.21 ms 
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.Prefix AS Prefix_12, t0.LieuCourse AS LieuCourse_13, t0.DateCourse AS DateCourse_14, t0.DistanceEnKm AS DistanceEnKm_15, t0.HeurePrevu AS HeurePrevu_16, t0.Denivelle AS Denivelle_17, t0.EstDetaille AS EstDetaille_18, t0.Lieu AS Lieu_19, t0.AgeMinimum AS AgeMinimum_20, t0.AgeMaximum AS AgeMaximum_21, t0.WithScratch AS WithScratch_22, t0.BarriereHor AS BarriereHor_23, t0.DistanceCourse AS DistanceCourse_24, t0.DateCreation AS DateCreation_25, t0.DateModif AS DateModif_26, t0.IDEvenement AS IDEvenement_27 FROM rd_course t0 WHERE t0.IDEvenement = ?
Parameters: 
[
  5
]
View formatted query    View runnable query    Explain query    View query backtrace
7 0.40 ms 
SELECT t0.IDCategorieEvenement AS IDCategorieEvenement_1, t0.Code AS Code_2, t0.Libelle AS Libelle_3, t0.Icone AS Icone_4, t0.Couleur AS Couleur_5, t0.Description AS Description_6, t0.DateCreation AS DateCreation_7, t0.DateModif AS DateModif_8, t0.UserCreation AS UserCreation_9, t0.UserModification AS UserModification_10 FROM CategorieEvenement t0 WHERE t0.IDCategorieEvenement = ?
Parameters: 
[
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
8 7.01 ms 
SELECT t0.IDParticipant AS IDParticipant_1, t0.HeureDepart AS HeureDepart_2, t0.HeureArrivee AS HeureArrivee_3, t0.HeureAbandon AS HeureAbandon_4, t0.HeureDisqualification AS HeureDisqualification_5, t0.DateAbandon AS DateAbandon_6, t0.DateDisqualification AS DateDisqualification_7, t0.DateArrivee AS DateArrivee_8, t0.TempsTotal AS TempsTotal_9, t0.Emargement AS Emargement_10, t0.estControleMobile AS estControleMobile_11, t0.estProfilPublic AS estProfilPublic_12, t0.DateCreation AS DateCreation_13, t0.DateModif AS DateModif_14, t0.Valid AS Valid_15, t0.PaymentReference AS PaymentReference_16, t0.IDCoureur AS IDCoureur_17, t0.IDEtatCoureur AS IDEtatCoureur_18, t0.IDCourse AS IDCourse_19, t0.IDDossard AS IDDossard_20, t0.IDCategorie AS IDCategorie_21 FROM Participant t0 WHERE t0.IDCourse = ?
Parameters: 
[
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
9 0.75 ms 
SELECT t0.IDParticipant AS IDParticipant_1, t0.HeureDepart AS HeureDepart_2, t0.HeureArrivee AS HeureArrivee_3, t0.HeureAbandon AS HeureAbandon_4, t0.HeureDisqualification AS HeureDisqualification_5, t0.DateAbandon AS DateAbandon_6, t0.DateDisqualification AS DateDisqualification_7, t0.DateArrivee AS DateArrivee_8, t0.TempsTotal AS TempsTotal_9, t0.Emargement AS Emargement_10, t0.estControleMobile AS estControleMobile_11, t0.estProfilPublic AS estProfilPublic_12, t0.DateCreation AS DateCreation_13, t0.DateModif AS DateModif_14, t0.Valid AS Valid_15, t0.PaymentReference AS PaymentReference_16, t0.IDCoureur AS IDCoureur_17, t0.IDEtatCoureur AS IDEtatCoureur_18, t0.IDCourse AS IDCourse_19, t0.IDDossard AS IDDossard_20, t0.IDCategorie AS IDCategorie_21 FROM Participant t0 WHERE t0.IDCourse = ?
Parameters: 
[
  2
]
View formatted query    View runnable query    Explain query    View query backtrace
10 0.36 ms 
SELECT t0.IDParticipant AS IDParticipant_1, t0.HeureDepart AS HeureDepart_2, t0.HeureArrivee AS HeureArrivee_3, t0.HeureAbandon AS HeureAbandon_4, t0.HeureDisqualification AS HeureDisqualification_5, t0.DateAbandon AS DateAbandon_6, t0.DateDisqualification AS DateDisqualification_7, t0.DateArrivee AS DateArrivee_8, t0.TempsTotal AS TempsTotal_9, t0.Emargement AS Emargement_10, t0.estControleMobile AS estControleMobile_11, t0.estProfilPublic AS estProfilPublic_12, t0.DateCreation AS DateCreation_13, t0.DateModif AS DateModif_14, t0.Valid AS Valid_15, t0.PaymentReference AS PaymentReference_16, t0.IDCoureur AS IDCoureur_17, t0.IDEtatCoureur AS IDEtatCoureur_18, t0.IDCourse AS IDCourse_19, t0.IDDossard AS IDDossard_20, t0.IDCategorie AS IDCategorie_21 FROM Participant t0 WHERE t0.IDCourse = ?
Parameters: 
[
  3
]
View formatted query    View runnable query    Explain query    View query backtrace
11 25.47 ms 
SELECT t0.IDOrganisateur AS IDOrganisateur_1, t0.Denomination AS Denomination_2, t0.Mail AS Mail_3, t0.Adresse AS Adresse_4, t0.Telephone AS Telephone_5, t0.DateCreation AS DateCreation_6, t0.DateModif AS DateModif_7, t0.Logo AS Logo_8, t0.IDUser AS IDUser_9 FROM Organisateur t0 WHERE t0.IDOrganisateur = ?
Parameters: 
[
  1
]
View formatted query    View runnable query    Explain query    View query backtrace

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\Participant 7
App\Entity\Dossard 6
App\Entity\Course 5
App\Entity\Evenement 4
App\Entity\Organisateur 3
App\Entity\Coureur 3
App\Entity\StatutEvenement 2
App\Entity\EtatCoureur 2
App\Entity\Categorie 2
App\Entity\CategorieEvenement 1
App\Entity\User 1

Entities Mapping

Class Mapping errors
App\Entity\Evenement No errors.
App\Entity\Organisateur No errors.
App\Entity\CategorieEvenement No errors.
App\Entity\StatutEvenement No errors.
App\Entity\Course No errors.
App\Entity\PcParCourse No errors.
App\Entity\Participant No errors.
App\Entity\Coureur No errors.
App\Entity\EtatCoureur No errors.
App\Entity\Dossard No errors.
App\Entity\Categorie No errors.
App\Entity\User No errors.