Symfony Profiler

Query Metrics

5 Database Queries

4 Different statements

1.98 ms Query time

0 Invalid entities

10 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

0.79 ms
(39.94%)

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

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 = ?

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 = 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1872)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 1817)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2729)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 315)
7	App\Controller\AccueilController->index (line 55)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 193)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
12	require_once (line 32)
13	require_once (line 5)

0.61 ms
(30.53%)

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.EstActif = ? AND t0.IDStatutEvenement = ? ORDER BY t0.Date ASC

Parameters:

View formatted query View runnable query Explain query View query backtrace

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.EstActif = ?
  AND t0.IDStatutEvenement = ?
ORDER BY
  t0.Date ASC

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.EstActif = 1 AND t0.IDStatutEvenement = 3 ORDER BY t0.Date ASC;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 963)
2	Doctrine\ORM\EntityRepository->findBy (line 110)
3	App\Controller\AccueilController->index (line 28)
4	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
5	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
6	Symfony\Component\HttpKernel\Kernel->handle (line 193)
7	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
8	require_once (line 32)
9	require_once (line 5)

0.31 ms
(15.41%)

SELECT t0.IDStatutEvenement AS IDStatutEvenement_1, t0.Code AS Code_2, t0.Libelle AS Libelle_3, t0.DateCreation AS DateCreation_4, t0.DateModif AS DateModif_5, t0.CodeCouleur AS CodeCouleur_6, t0.Icone AS Icone_7, t0.Description AS Description_8 FROM StatutEvenement t0 WHERE t0.Code = ? LIMIT 1

Parameters:

[
  "3"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.IDStatutEvenement AS IDStatutEvenement_1,
  t0.Code AS Code_2,
  t0.Libelle AS Libelle_3,
  t0.DateCreation AS DateCreation_4,
  t0.DateModif AS DateModif_5,
  t0.CodeCouleur AS CodeCouleur_6,
  t0.Icone AS Icone_7,
  t0.Description AS Description_8
FROM
  StatutEvenement t0
WHERE
  t0.Code = ?
LIMIT
  1

SELECT t0.IDStatutEvenement AS IDStatutEvenement_1, t0.Code AS Code_2, t0.Libelle AS Libelle_3, t0.DateCreation AS DateCreation_4, t0.DateModif AS DateModif_5, t0.CodeCouleur AS CodeCouleur_6, t0.Icone AS Icone_7, t0.Description AS Description_8 FROM StatutEvenement t0 WHERE t0.Code = '3' LIMIT 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\EntityRepository->findOneBy (line 125)
3	App\Controller\AccueilController->index (line 26)
4	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
5	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
6	Symfony\Component\HttpKernel\Kernel->handle (line 193)
7	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
8	require_once (line 32)
9	require_once (line 5)

0.28 ms
(14.12%)

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

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 = ?

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 = 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
3	Doctrine\ORM\Proxy\ProxyFactory->{closure:Doctrine\ORM\Proxy\ProxyFactory::createLazyInitializer():294} (line 295)
4	Proxies\__CG__\App\Entity\CategorieEvenement::{closure:{closure:Doctrine\ORM\Proxy\ProxyFactory::getProxyFactory():371}:372} (line 373)
5	Symfony\Component\VarExporter\Internal\LazyObjectState::initialize (line 60)
6	Proxies\__CG__\App\Entity\CategorieEvenement->__get (line 153)
7	App\Entity\CategorieEvenement->getLibelle (line 69)
8	App\Controller\AccueilController->index (line 78)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
11	Symfony\Component\HttpKernel\Kernel->handle (line 193)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
13	require_once (line 32)
14	require_once (line 5)

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\Course	4
App\Entity\Evenement	2
App\Entity\Organisateur	2
App\Entity\StatutEvenement	1
App\Entity\CategorieEvenement	1

Entities Mapping

Class	Mapping errors
App\Entity\StatutEvenement	No errors.
App\Entity\Evenement	No errors.
App\Entity\Organisateur	No errors.
App\Entity\CategorieEvenement	No errors.
App\Entity\Course	No errors.
App\Entity\PcParCourse	No errors.
App\Entity\Participant	No errors.

Symfony Profiler

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

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping