Symfony Profiler

Query Metrics

2 Database Queries

2 Different statements

9.16 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

7.72 ms
(84.24%)

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.prenom AS prenom_3, t0.email AS email_4, t0.telephone AS telephone_5, t0.enfants AS enfants_6, t0.nb_enfants AS nb_enfants_7, t0.age_enfants AS age_enfants_8 FROM participants t0 INNER JOIN participants_ateliers ON t0.id = participants_ateliers.participants_id WHERE participants_ateliers.ateliers_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.prenom AS prenom_3,
  t0.email AS email_4,
  t0.telephone AS telephone_5,
  t0.enfants AS enfants_6,
  t0.nb_enfants AS nb_enfants_7,
  t0.age_enfants AS age_enfants_8
FROM
  participants t0
  INNER JOIN participants_ateliers ON t0.id = participants_ateliers.participants_id
WHERE
  participants_ateliers.ateliers_id = ?

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.prenom AS prenom_3, t0.email AS email_4, t0.telephone AS telephone_5, t0.enfants AS enfants_6, t0.nb_enfants AS nb_enfants_7, t0.age_enfants AS age_enfants_8 FROM participants t0 INNER JOIN participants_ateliers ON t0.id = participants_ateliers.participants_id WHERE participants_ateliers.ateliers_id = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1087)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getManyToManyStatement (line 1009)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadManyToManyCollection (line 3144)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 706)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 215)
6	Doctrine\ORM\PersistentCollection->initialize (line 108)
7	Doctrine\Common\Collections\AbstractLazyCollection->containsKey (line 409)
8	Doctrine\ORM\PersistentCollection->containsKey (line 498)
9	Doctrine\ORM\PersistentCollection->offsetExists (line 1411)
10	twig_get_attribute (line 96)
11	__TwigTemplate_027cb0ceaf5464e00bee2a9d2286351c->block_body (line 182)
12	Twig\Template->displayBlock (line 128)
13	__TwigTemplate_d40d568b18efaf508ac2b24914cdbb5b->doDisplay (line 405)
14	Twig\Template->displayWithErrorHandling (line 378)
15	Twig\Template->display (line 49)
16	__TwigTemplate_027cb0ceaf5464e00bee2a9d2286351c->doDisplay (line 405)
17	Twig\Template->displayWithErrorHandling (line 378)
18	Twig\Template->display (line 390)
19	Twig\Template->render (line 45)
20	Twig\TemplateWrapper->render (line 318)
21	Twig\Environment->render (line 243)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->renderView (line 254)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 203)
24	App\Controller\AteliersController->show (line 166)
25	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 74)
26	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
27	Symfony\Component\HttpKernel\Kernel->handle (line 35)
28	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
29	require_once (line 8)

1.44 ms
(15.76%)

SELECT t0.id AS id_1, t0.titre AS titre_2, t0.description AS description_3, t0.date AS date_4, t0.heure_debut AS heure_debut_5, t0.heure_fin AS heure_fin_6, t0.type AS type_7, t0.places AS places_8, t0.places_restantes AS places_restantes_9, t0.is_complete AS is_complete_10, t0.is_terminated AS is_terminated_11, t0.local AS local_12, t0.intervenant AS intervenant_13, t0.type_intervenant AS type_intervenant_14, t0.is_gratuit AS is_gratuit_15, t0.email_intervenant AS email_intervenant_16, t0.is_inscription_closed AS is_inscription_closed_17, t0.participants_min AS participants_min_18 FROM ateliers t0 WHERE t0.id = ?

Parameters:

[
  "1"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.titre AS titre_2,
  t0.description AS description_3,
  t0.date AS date_4,
  t0.heure_debut AS heure_debut_5,
  t0.heure_fin AS heure_fin_6,
  t0.type AS type_7,
  t0.places AS places_8,
  t0.places_restantes AS places_restantes_9,
  t0.is_complete AS is_complete_10,
  t0.is_terminated AS is_terminated_11,
  t0.local AS local_12,
  t0.intervenant AS intervenant_13,
  t0.type_intervenant AS type_intervenant_14,
  t0.is_gratuit AS is_gratuit_15,
  t0.email_intervenant AS email_intervenant_16,
  t0.is_inscription_closed AS is_inscription_closed_17,
  t0.participants_min AS participants_min_18
FROM
  ateliers t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.titre AS titre_2, t0.description AS description_3, t0.date AS date_4, t0.heure_debut AS heure_debut_5, t0.heure_fin AS heure_fin_6, t0.type AS type_7, t0.places AS places_8, t0.places_restantes AS places_restantes_9, t0.is_complete AS is_complete_10, t0.is_terminated AS is_terminated_11, t0.local AS local_12, t0.intervenant AS intervenant_13, t0.type_intervenant AS type_intervenant_14, t0.is_gratuit AS is_gratuit_15, t0.email_intervenant AS email_intervenant_16, t0.is_inscription_closed AS is_inscription_closed_17, t0.participants_min AS participants_min_18 FROM ateliers t0 WHERE t0.id = '1';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 771)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 789)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 521)
4	Doctrine\ORM\EntityManager->find (line 197)
5	Doctrine\ORM\EntityRepository->find (line 116)
6	Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->find (line 63)
7	Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->resolve (line 60)
8	Symfony\Component\HttpKernel\Controller\ArgumentResolver\TraceableValueResolver->resolve (line 90)
9	Symfony\Component\HttpKernel\Controller\ArgumentResolver->getArguments (line 40)
10	Symfony\Component\HttpKernel\Controller\TraceableArgumentResolver->getArguments (line 158)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 74)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
13	Symfony\Component\HttpKernel\Kernel->handle (line 35)
14	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
15	require_once (line 8)

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.

Entities Mapping

Class	Mapping errors
App\Entity\Ateliers	No errors.
App\Entity\Adherents	No errors.
App\Entity\Participants	No errors.
App\Entity\Paiement	No errors.

Symfony Profiler

GET http://artemis-parents.com/ateliers/1

Configuration Settings

Theme