Symfony Profiler

Query Metrics

4 Database Queries

3 Different statements

3.50 ms Query time

0 Invalid entities

6 Managed entities

Queries

Group similar statements

#▲

Time

Info

2.09 ms

SELECT a0_.id AS id_0, a0_.nom AS nom_1, a0_.horaire AS horaire_2, a0_.lieu AS lieu_3, a0_.date AS date_4, a0_.description AS description_5, a0_.prix AS prix_6, a0_.lien_inscription AS lien_inscription_7, a0_.place_maximum AS place_maximum_8, a0_.age_min AS age_min_9, a0_.age_max AS age_max_10, a0_.inscriptions_en_attente AS inscriptions_en_attente_11, a0_.inscriptions_validees AS inscriptions_validees_12, a0_.categorie_id AS categorie_id_13 FROM activite a0_ WHERE a0_.date >= ? AND a0_.date < ? ORDER BY a0_.date ASC

Parameters:

[
  "2030-02-01 00:00:00"
  "2030-03-01 00:00:00"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  a0_.id AS id_0,
  a0_.nom AS nom_1,
  a0_.horaire AS horaire_2,
  a0_.lieu AS lieu_3,
  a0_.date AS date_4,
  a0_.description AS description_5,
  a0_.prix AS prix_6,
  a0_.lien_inscription AS lien_inscription_7,
  a0_.place_maximum AS place_maximum_8,
  a0_.age_min AS age_min_9,
  a0_.age_max AS age_max_10,
  a0_.inscriptions_en_attente AS inscriptions_en_attente_11,
  a0_.inscriptions_validees AS inscriptions_validees_12,
  a0_.categorie_id AS categorie_id_13
FROM
  activite a0_
WHERE
  a0_.date >= ?
  AND a0_.date < ?
ORDER BY
  a0_.date ASC

SELECT a0_.id AS id_0, a0_.nom AS nom_1, a0_.horaire AS horaire_2, a0_.lieu AS lieu_3, a0_.date AS date_4, a0_.description AS description_5, a0_.prix AS prix_6, a0_.lien_inscription AS lien_inscription_7, a0_.place_maximum AS place_maximum_8, a0_.age_min AS age_min_9, a0_.age_max AS age_max_10, a0_.inscriptions_en_attente AS inscriptions_en_attente_11, a0_.inscriptions_validees AS inscriptions_validees_12, a0_.categorie_id AS categorie_id_13 FROM activite a0_ WHERE a0_.date >= '2030-02-01 00:00:00' AND a0_.date < '2030-03-01 00:00:00' ORDER BY a0_.date ASC;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 935)
4	Doctrine\ORM\AbstractQuery->execute (line 891)
5	Doctrine\ORM\AbstractQuery->getResult (line 689)
6	App\Repository\ActiviteRepository->findByMois (line 55)
7	App\Controller\MainController->actualites (line 66)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 182)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
12	require_once (line 29)
13	require_once (line 5)

0.59 ms

SELECT e0_.id AS id_0, e0_.titre AS titre_1, e0_.date AS date_2, e0_.description AS description_3, e0_.lieu AS lieu_4 FROM evenement e0_ WHERE e0_.date >= ? AND e0_.date < ? ORDER BY e0_.date ASC

Parameters:

[
  "2030-02-01 00:00:00"
  "2030-03-01 00:00:00"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  e0_.id AS id_0,
  e0_.titre AS titre_1,
  e0_.date AS date_2,
  e0_.description AS description_3,
  e0_.lieu AS lieu_4
FROM
  evenement e0_
WHERE
  e0_.date >= ?
  AND e0_.date < ?
ORDER BY
  e0_.date ASC

SELECT e0_.id AS id_0, e0_.titre AS titre_1, e0_.date AS date_2, e0_.description AS description_3, e0_.lieu AS lieu_4 FROM evenement e0_ WHERE e0_.date >= '2030-02-01 00:00:00' AND e0_.date < '2030-03-01 00:00:00' ORDER BY e0_.date ASC;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 935)
4	Doctrine\ORM\AbstractQuery->execute (line 891)
5	Doctrine\ORM\AbstractQuery->getResult (line 689)
6	App\Repository\EvenementRepository->findByMois (line 28)
7	App\Controller\MainController->actualites (line 67)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 182)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
12	require_once (line 29)
13	require_once (line 5)

0.47 ms

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.couleur_fond AS couleur_fond_3, t0.couleur_texte AS couleur_texte_4 FROM categorie t0 WHERE t0.id = ?

Parameters:

[
  4
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.couleur_fond AS couleur_fond_3,
  t0.couleur_texte AS couleur_texte_4
FROM
  categorie t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.couleur_fond AS couleur_fond_3, t0.couleur_texte AS couleur_texte_4 FROM categorie t0 WHERE t0.id = 4;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 740)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 758)
3	Doctrine\ORM\Proxy\ProxyFactory->Doctrine\ORM\Proxy\{closure} (line 289)
4	Proxies\__CG__\App\Entity\Categorie::Doctrine\ORM\Proxy\{closure} (line 367)
5	Symfony\Component\VarExporter\Internal\LazyObjectState::initialize (line 60)
6	Proxies\__CG__\App\Entity\Categorie->__get (line 153)
7	App\Entity\Categorie->getNom (line 42)
8	App\Controller\MainController->actualites (line 82)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
11	Symfony\Component\HttpKernel\Kernel->handle (line 182)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
13	require_once (line 29)
14	require_once (line 5)

0.36 ms

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.couleur_fond AS couleur_fond_3, t0.couleur_texte AS couleur_texte_4 FROM categorie t0 WHERE t0.id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.couleur_fond AS couleur_fond_3,
  t0.couleur_texte AS couleur_texte_4
FROM
  categorie t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.couleur_fond AS couleur_fond_3, t0.couleur_texte AS couleur_texte_4 FROM categorie t0 WHERE t0.id = 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 740)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 758)
3	Doctrine\ORM\Proxy\ProxyFactory->Doctrine\ORM\Proxy\{closure} (line 289)
4	Proxies\__CG__\App\Entity\Categorie::Doctrine\ORM\Proxy\{closure} (line 367)
5	Symfony\Component\VarExporter\Internal\LazyObjectState::initialize (line 60)
6	Proxies\__CG__\App\Entity\Categorie->__get (line 153)
7	App\Entity\Categorie->getNom (line 42)
8	App\Controller\MainController->actualites (line 82)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
11	Symfony\Component\HttpKernel\Kernel->handle (line 182)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
13	require_once (line 29)
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\Activite	4
App\Entity\Categorie	2

Entities Mapping

Class	Mapping errors
App\Entity\Activite	No errors.
App\Entity\Categorie	No errors.
App\Entity\Inscription	No errors.
App\Entity\Evenement	No errors.

Symfony Profiler

GET https://assodemo.tarsatech.fr/actualites?annee=2030&mois=2

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping