Symfony Profiler

Query Metrics

4 Database Queries

3 Different statements

4.32 ms Query time

0 Invalid entities

4 Managed entities

Queries

Group similar statements

#▲

Time

Info

2.17 ms

SELECT c0_.id AS id_0, c0_.nom AS nom_1, c0_.slug AS slug_2, c0_.description AS description_3, c0_.ordre AS ordre_4, c0_.actif AS actif_5, c0_.created_at AS created_at_6, c0_.updated_at AS updated_at_7 FROM categorie_equipe c0_ LEFT JOIN membre_equipe m1_ ON c0_.id = m1_.categorie_equipe_id WHERE c0_.actif = ? AND (m1_.actif = ? OR m1_.id IS NULL) ORDER BY c0_.ordre ASC, c0_.nom ASC, m1_.ordre ASC, m1_.nom ASC

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  c0_.id AS id_0,
  c0_.nom AS nom_1,
  c0_.slug AS slug_2,
  c0_.description AS description_3,
  c0_.ordre AS ordre_4,
  c0_.actif AS actif_5,
  c0_.created_at AS created_at_6,
  c0_.updated_at AS updated_at_7
FROM
  categorie_equipe c0_
  LEFT JOIN membre_equipe m1_ ON c0_.id = m1_.categorie_equipe_id
WHERE
  c0_.actif = ?
  AND (
    m1_.actif = ?
    OR m1_.id IS NULL
  )
ORDER BY
  c0_.ordre ASC,
  c0_.nom ASC,
  m1_.ordre ASC,
  m1_.nom ASC

SELECT c0_.id AS id_0, c0_.nom AS nom_1, c0_.slug AS slug_2, c0_.description AS description_3, c0_.ordre AS ordre_4, c0_.actif AS actif_5, c0_.created_at AS created_at_6, c0_.updated_at AS updated_at_7 FROM categorie_equipe c0_ LEFT JOIN membre_equipe m1_ ON c0_.id = m1_.categorie_equipe_id WHERE c0_.actif = 1 AND (m1_.actif = 1 OR m1_.id IS NULL) ORDER BY c0_.ordre ASC, c0_.nom ASC, m1_.ordre ASC, m1_.nom 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\CategorieEquipeRepository->findActivesAvecMembres (line 34)
7	App\Controller\EquipeController->index (line 21)
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.87 ms

SELECT o0_.id AS id_0, o0_.nom AS nom_1, o0_.telephone AS telephone_2, o0_.email AS email_3, o0_.adresse AS adresse_4, o0_.logo AS logo_5, o0_.icon AS icon_6, o0_.site_web AS site_web_7, o0_.description AS description_8, o0_.facebook AS facebook_9, o0_.twitter AS twitter_10, o0_.linkedin AS linkedin_11, o0_.youtube AS youtube_12, o0_.instagram AS instagram_13, o0_.created_at AS created_at_14, o0_.updated_at AS updated_at_15 FROM organisation o0_ LIMIT 1

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  o0_.id AS id_0,
  o0_.nom AS nom_1,
  o0_.telephone AS telephone_2,
  o0_.email AS email_3,
  o0_.adresse AS adresse_4,
  o0_.logo AS logo_5,
  o0_.icon AS icon_6,
  o0_.site_web AS site_web_7,
  o0_.description AS description_8,
  o0_.facebook AS facebook_9,
  o0_.twitter AS twitter_10,
  o0_.linkedin AS linkedin_11,
  o0_.youtube AS youtube_12,
  o0_.instagram AS instagram_13,
  o0_.created_at AS created_at_14,
  o0_.updated_at AS updated_at_15
FROM
  organisation o0_
LIMIT
  1

SELECT o0_.id AS id_0, o0_.nom AS nom_1, o0_.telephone AS telephone_2, o0_.email AS email_3, o0_.adresse AS adresse_4, o0_.logo AS logo_5, o0_.icon AS icon_6, o0_.site_web AS site_web_7, o0_.description AS description_8, o0_.facebook AS facebook_9, o0_.twitter AS twitter_10, o0_.linkedin AS linkedin_11, o0_.youtube AS youtube_12, o0_.instagram AS instagram_13, o0_.created_at AS created_at_14, o0_.updated_at AS updated_at_15 FROM organisation o0_ LIMIT 1;

#	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->getOneOrNullResult (line 738)
6	App\Repository\OrganisationRepository->findFirst (line 28)
7	App\Twig\OrganisationExtension->getOrganisation (line 28)
8	__TwigTemplate_2c94d6645de3b627514378107eef7ab6->doDisplay (line 55)
9	Twig\Template->yield (line 402)
10	Twig\Template->display (line 358)
11	Twig\Template->render (line 373)
12	Twig\TemplateWrapper->render (line 51)
13	Twig\Extension\CoreExtension->include (line 1520)
14	__TwigTemplate_486583af90b56e518f5d99a0af0f42f1::doDisplay (line 86)
15	Twig\Template->yield (line 402)
16	__TwigTemplate_ba489df5958f18f31a60b968029d4734->doDisplay (line 54)
17	Twig\Template->yield (line 402)
18	Twig\Template->display (line 358)
19	Twig\Template->render (line 373)
20	Twig\TemplateWrapper->render (line 51)
21	Twig\Environment->render (line 333)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 459)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 464)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 278)
25	App\Controller\EquipeController->index (line 23)
26	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
27	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
28	Symfony\Component\HttpKernel\Kernel->handle (line 182)
29	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
30	require_once (line 29)
31	require_once (line 5)

0.74 ms

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.prenoms AS prenoms_3, t0.photo AS photo_4, t0.titre AS titre_5, t0.ordre AS ordre_6, t0.actif AS actif_7, t0.email AS email_8, t0.telephone AS telephone_9, t0.biographie AS biographie_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.categorie_equipe_id AS categorie_equipe_id_13 FROM membre_equipe t0 WHERE t0.categorie_equipe_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.prenoms AS prenoms_3,
  t0.photo AS photo_4,
  t0.titre AS titre_5,
  t0.ordre AS ordre_6,
  t0.actif AS actif_7,
  t0.email AS email_8,
  t0.telephone AS telephone_9,
  t0.biographie AS biographie_10,
  t0.created_at AS created_at_11,
  t0.updated_at AS updated_at_12,
  t0.categorie_equipe_id AS categorie_equipe_id_13
FROM
  membre_equipe t0
WHERE
  t0.categorie_equipe_id = ?

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.prenoms AS prenoms_3, t0.photo AS photo_4, t0.titre AS titre_5, t0.ordre AS ordre_6, t0.actif AS actif_7, t0.email AS email_8, t0.telephone AS telephone_9, t0.biographie AS biographie_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.categorie_equipe_id AS categorie_equipe_id_13 FROM membre_equipe t0 WHERE t0.categorie_equipe_id = 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1845)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 1790)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2722)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 313)
7	IteratorIterator->__construct (line 1970)
8	Twig\Extension\CoreExtension->filter (line 1970)
9	__TwigTemplate_ba489df5958f18f31a60b968029d4734::block_body (line 176)
10	Twig\Template->yieldBlock (line 446)
11	__TwigTemplate_486583af90b56e518f5d99a0af0f42f1->doDisplay (line 91)
12	Twig\Template->yield (line 402)
13	__TwigTemplate_ba489df5958f18f31a60b968029d4734->doDisplay (line 54)
14	Twig\Template->yield (line 402)
15	Twig\Template->display (line 358)
16	Twig\Template->render (line 373)
17	Twig\TemplateWrapper->render (line 51)
18	Twig\Environment->render (line 333)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 459)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 464)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 278)
22	App\Controller\EquipeController->index (line 23)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
25	Symfony\Component\HttpKernel\Kernel->handle (line 182)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
27	require_once (line 29)
28	require_once (line 5)

0.54 ms

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.prenoms AS prenoms_3, t0.photo AS photo_4, t0.titre AS titre_5, t0.ordre AS ordre_6, t0.actif AS actif_7, t0.email AS email_8, t0.telephone AS telephone_9, t0.biographie AS biographie_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.categorie_equipe_id AS categorie_equipe_id_13 FROM membre_equipe t0 WHERE t0.categorie_equipe_id = ?

Parameters:

[
  2
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.prenoms AS prenoms_3,
  t0.photo AS photo_4,
  t0.titre AS titre_5,
  t0.ordre AS ordre_6,
  t0.actif AS actif_7,
  t0.email AS email_8,
  t0.telephone AS telephone_9,
  t0.biographie AS biographie_10,
  t0.created_at AS created_at_11,
  t0.updated_at AS updated_at_12,
  t0.categorie_equipe_id AS categorie_equipe_id_13
FROM
  membre_equipe t0
WHERE
  t0.categorie_equipe_id = ?

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.prenoms AS prenoms_3, t0.photo AS photo_4, t0.titre AS titre_5, t0.ordre AS ordre_6, t0.actif AS actif_7, t0.email AS email_8, t0.telephone AS telephone_9, t0.biographie AS biographie_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.categorie_equipe_id AS categorie_equipe_id_13 FROM membre_equipe t0 WHERE t0.categorie_equipe_id = 2;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1845)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 1790)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2722)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 313)
7	IteratorIterator->__construct (line 1970)
8	Twig\Extension\CoreExtension->filter (line 1970)
9	__TwigTemplate_ba489df5958f18f31a60b968029d4734::block_body (line 176)
10	Twig\Template->yieldBlock (line 446)
11	__TwigTemplate_486583af90b56e518f5d99a0af0f42f1->doDisplay (line 91)
12	Twig\Template->yield (line 402)
13	__TwigTemplate_ba489df5958f18f31a60b968029d4734->doDisplay (line 54)
14	Twig\Template->yield (line 402)
15	Twig\Template->display (line 358)
16	Twig\Template->render (line 373)
17	Twig\TemplateWrapper->render (line 51)
18	Twig\Environment->render (line 333)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 459)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 464)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 278)
22	App\Controller\EquipeController->index (line 23)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
25	Symfony\Component\HttpKernel\Kernel->handle (line 182)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
27	require_once (line 29)
28	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\CategorieEquipe	2
App\Entity\Organisation	1
App\Entity\MembreEquipe	1

Entities Mapping

Class	Mapping errors
App\Entity\CategorieEquipe	No errors.
App\Entity\MembreEquipe	No errors.
App\Entity\Organisation	No errors.

Symfony Profiler

GET https://adet-tchaada.info/notre-equipe

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping