Symfony Profiler

Query Metrics

221 Database Queries

5 Different statements

35.52 ms Query time

0 Invalid entities

492 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

31.76 ms
(89.41%)

205

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.prenom AS prenom_3, t0.type AS type_4, t0.cours AS cours_5, t0.niveau AS niveau_6, t0.est_handiski AS est_handiski_7, t0.inscription_id AS inscription_id_8 FROM participant t0 WHERE t0.inscription_id = ?

Parameters:

[
  1034
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.prenom AS prenom_3,
  t0.type AS type_4,
  t0.cours AS cours_5,
  t0.niveau AS niveau_6,
  t0.est_handiski AS est_handiski_7,
  t0.inscription_id AS inscription_id_8
FROM
  participant t0
WHERE
  t0.inscription_id = ?

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.prenom AS prenom_3, t0.type AS type_4, t0.cours AS cours_5, t0.niveau AS niveau_6, t0.est_handiski AS est_handiski_7, t0.inscription_id AS inscription_id_8 FROM participant t0 WHERE t0.inscription_id = 1034;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1845)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1790)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 2722)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 636)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 186)
6	Doctrine\ORM\PersistentCollection->initialize (line 39)
7	Doctrine\Common\Collections\AbstractLazyCollection->count (line 391)
8	Doctrine\ORM\PersistentCollection->count (line 1)
9	count (line 29)
10	App\Service\SortieService->getSortiesPrettyByTypeSortie (line 36)
11	App\Controller\SortieController->sorties_par_type (line 181)
12	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
13	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
14	Symfony\Component\HttpKernel\Kernel->handle (line 35)
15	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
16	require_once (line 5)

2.41 ms
(6.79%)

SELECT t0.id AS id_1, t0.date_inscription AS date_inscription_2, t0.utilisateur_participe AS utilisateur_participe_3, t0.cours AS cours_4, t0.niveau AS niveau_5, t0.est_handiski AS est_handiski_6, t0.telephone_autre AS telephone_autre_7, t0.inscrit_id AS inscrit_id_8, t0.sortie_id AS sortie_id_9 FROM inscription t0 WHERE t0.sortie_id = ?

Parameters:

[
  359
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.date_inscription AS date_inscription_2,
  t0.utilisateur_participe AS utilisateur_participe_3,
  t0.cours AS cours_4,
  t0.niveau AS niveau_5,
  t0.est_handiski AS est_handiski_6,
  t0.telephone_autre AS telephone_autre_7,
  t0.inscrit_id AS inscrit_id_8,
  t0.sortie_id AS sortie_id_9
FROM
  inscription t0
WHERE
  t0.sortie_id = ?

SELECT t0.id AS id_1, t0.date_inscription AS date_inscription_2, t0.utilisateur_participe AS utilisateur_participe_3, t0.cours AS cours_4, t0.niveau AS niveau_5, t0.est_handiski AS est_handiski_6, t0.telephone_autre AS telephone_autre_7, t0.inscrit_id AS inscrit_id_8, t0.sortie_id AS sortie_id_9 FROM inscription t0 WHERE t0.sortie_id = 359;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1845)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1790)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 2722)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 636)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 186)
6	Doctrine\ORM\PersistentCollection->initialize (line 313)
7	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 24)
8	App\Service\SortieService->getSortiesPrettyByTypeSortie (line 36)
9	App\Controller\SortieController->sorties_par_type (line 181)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
12	Symfony\Component\HttpKernel\Kernel->handle (line 35)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
14	require_once (line 5)

0.61 ms
(1.72%)

SELECT t0.email AS email_1, t0.roles AS roles_2, t0.password AS password_3, t0.nom AS nom_4, t0.prenom AS prenom_5, t0.telephone AS telephone_6, t0.date_creation AS date_creation_7, t0.est_invite AS est_invite_8 FROM utilisateur t0 WHERE t0.email = ?

Parameters:

[
  "sophie.garet@univ-grenoble-alpes.fr"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.email AS email_1,
  t0.roles AS roles_2,
  t0.password AS password_3,
  t0.nom AS nom_4,
  t0.prenom AS prenom_5,
  t0.telephone AS telephone_6,
  t0.date_creation AS date_creation_7,
  t0.est_invite AS est_invite_8
FROM
  utilisateur t0
WHERE
  t0.email = ?

SELECT t0.email AS email_1, t0.roles AS roles_2, t0.password AS password_3, t0.nom AS nom_4, t0.prenom AS prenom_5, t0.telephone AS telephone_6, t0.date_creation AS date_creation_7, t0.est_invite AS est_invite_8 FROM utilisateur t0 WHERE t0.email = 'sophie.garet@univ-grenoble-alpes.fr';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 740)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 758)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 366)
4	Doctrine\ORM\EntityManager->find (line 86)
5	Doctrine\ORM\EntityRepository->find (line 61)
6	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->find (line 92)
7	Symfony\Bridge\Doctrine\Security\User\EntityUserProvider->refreshUser (line 214)
8	Symfony\Component\Security\Http\Firewall\ContextListener->refreshUser (line 131)
9	Symfony\Component\Security\Http\Firewall\ContextListener->authenticate (line 46)
10	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 60)
11	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->__invoke (line 80)
12	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 95)
13	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 116)
14	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
15	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
16	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 139)
17	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 157)
18	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
19	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
20	Symfony\Component\HttpKernel\Kernel->handle (line 35)
21	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
22	require_once (line 5)

0.44 ms
(1.24%)

SELECT t0.id AS id_1, t0.date AS date_2, t0.destination AS destination_3, t0.heure_depart AS heure_depart_4, t0.heure_depart_station AS heure_depart_station_5, t0.heure_rdv AS heure_rdv_6, t0.lieu AS lieu_7, t0.etat AS etat_8, t0.nb_places_bus AS nb_places_bus_9, t0.heure_retour AS heure_retour_10, t0.description AS description_11, t0.active AS active_12, t0.type_sortie_id AS type_sortie_id_13, t0.responsable_id AS responsable_id_14 FROM sortie t0 WHERE t0.type_sortie_id = ? ORDER BY t0.date ASC

Parameters:

[
  "Ski Dimanche"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.date AS date_2,
  t0.destination AS destination_3,
  t0.heure_depart AS heure_depart_4,
  t0.heure_depart_station AS heure_depart_station_5,
  t0.heure_rdv AS heure_rdv_6,
  t0.lieu AS lieu_7,
  t0.etat AS etat_8,
  t0.nb_places_bus AS nb_places_bus_9,
  t0.heure_retour AS heure_retour_10,
  t0.description AS description_11,
  t0.active AS active_12,
  t0.type_sortie_id AS type_sortie_id_13,
  t0.responsable_id AS responsable_id_14
FROM
  sortie t0
WHERE
  t0.type_sortie_id = ?
ORDER BY
  t0.date ASC

SELECT t0.id AS id_1, t0.date AS date_2, t0.destination AS destination_3, t0.heure_depart AS heure_depart_4, t0.heure_depart_station AS heure_depart_station_5, t0.heure_rdv AS heure_rdv_6, t0.lieu AS lieu_7, t0.etat AS etat_8, t0.nb_places_bus AS nb_places_bus_9, t0.heure_retour AS heure_retour_10, t0.description AS description_11, t0.active AS active_12, t0.type_sortie_id AS type_sortie_id_13, t0.responsable_id AS responsable_id_14 FROM sortie t0 WHERE t0.type_sortie_id = 'Ski Dimanche' ORDER BY t0.date ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 942)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 110)
3	Doctrine\ORM\EntityRepository->findBy (line 73)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 13)
5	App\Service\SortieService->getSortiesPrettyByTypeSortie (line 36)
6	App\Controller\SortieController->sorties_par_type (line 181)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
9	Symfony\Component\HttpKernel\Kernel->handle (line 35)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
11	require_once (line 5)

0.30 ms
(0.84%)

SELECT t0.libelle AS libelle_1, t0.description AS description_2, t0.hyperlien_site_caesug AS hyperlien_site_caesug_3, t0.tarif_caesug AS tarif_caesug_4, t0.tarif_caesug_jeune AS tarif_caesug_jeune_5, t0.tarif_invite AS tarif_invite_6, t0.tarif_invite_jeune AS tarif_invite_jeune_7, t0.couleur AS couleur_8, t0.carte_usca AS carte_usca_9, t0.responsable_id AS responsable_id_10 FROM type_sortie t0 WHERE t0.libelle = ? LIMIT 1

Parameters:

[
  "Ski Dimanche"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.libelle AS libelle_1,
  t0.description AS description_2,
  t0.hyperlien_site_caesug AS hyperlien_site_caesug_3,
  t0.tarif_caesug AS tarif_caesug_4,
  t0.tarif_caesug_jeune AS tarif_caesug_jeune_5,
  t0.tarif_invite AS tarif_invite_6,
  t0.tarif_invite_jeune AS tarif_invite_jeune_7,
  t0.couleur AS couleur_8,
  t0.carte_usca AS carte_usca_9,
  t0.responsable_id AS responsable_id_10
FROM
  type_sortie t0
WHERE
  t0.libelle = ?
LIMIT
  1

SELECT t0.libelle AS libelle_1, t0.description AS description_2, t0.hyperlien_site_caesug AS hyperlien_site_caesug_3, t0.tarif_caesug AS tarif_caesug_4, t0.tarif_caesug_jeune AS tarif_caesug_jeune_5, t0.tarif_invite AS tarif_invite_6, t0.tarif_invite_jeune AS tarif_invite_jeune_7, t0.couleur AS couleur_8, t0.carte_usca AS carte_usca_9, t0.responsable_id AS responsable_id_10 FROM type_sortie t0 WHERE t0.libelle = 'Ski Dimanche' LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 740)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 125)
3	Doctrine\ORM\EntityRepository->findOneBy (line 81)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 35)
5	App\Controller\SortieController->sorties_par_type (line 181)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
8	Symfony\Component\HttpKernel\Kernel->handle (line 35)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
10	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\Inscription	205
App\Entity\Participant	182
App\Entity\Utilisateur	77
App\Entity\Responsable	14
App\Entity\Sortie	13
App\Entity\TypeSortie	1

Entities Mapping

Class	Mapping errors
App\Entity\Utilisateur	No errors.
App\Entity\Inscription	No errors.
App\Entity\TypeSortie	No errors.
App\Entity\Responsable	No errors.
App\Entity\Sortie	No errors.
App\Entity\Participant	No errors.

Symfony Profiler

GET https://caesugski.grenoble.cnrs.fr/sorties/Ski%20Dimanche

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping