Symfony Profiler

Last 10 Latest Search

Method

Status

URL

Token

From

Until

Results

Profiler settings

Query Metrics

12 Database Queries

6 Different statements

1.06 ms Query time

0 Invalid entities

17 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

0.20 ms
(19.22%)

SELECT t0.id AS id_1, t0.contenu AS contenu_2, t0.couleur AS couleur_3, t0.taille AS taille_4 FROM texte t0 WHERE t0.id = ?

Parameters:

[
  4
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.contenu AS contenu_2,
  t0.couleur AS couleur_3,
  t0.taille AS taille_4
FROM
  texte t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.contenu AS contenu_2, t0.couleur AS couleur_3, t0.taille AS taille_4 FROM texte t0 WHERE t0.id = 4;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 736)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 754)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 220)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 286)
5	Proxies\__CG__\App\Entity\Texte::Doctrine\ORM\Proxy\{closure} (line 100)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 184)
7	Proxies\__CG__\App\Entity\Texte->__get (line 45)
8	App\Entity\Texte->getCouleur (line 1909)
9	Twig\Extension\CoreExtension::getAttribute (line 214)
10	__TwigTemplate_b55924f0aafea8715cd8273b8c0036ff->block_body (line 446)
11	Twig\Template->yieldBlock (line 390)
12	__TwigTemplate_bc8ce41a95c2fffc928638b09b0f5a66->doDisplay (line 402)
13	Twig\Template->yield (line 54)
14	__TwigTemplate_b55924f0aafea8715cd8273b8c0036ff->doDisplay (line 402)
15	Twig\Template->yield (line 358)
16	Twig\Template->display (line 373)
17	Twig\Template->render (line 51)
18	Twig\TemplateWrapper->render (line 333)
19	Twig\Environment->render (line 448)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 443)
23	App\Controller\EvenementController->listeEvenements (line 181)
24	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
25	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
26	Symfony\Component\HttpKernel\Kernel->handle (line 35)
27	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
28	require_once (line 5)

0.20 ms
(19.02%)

SELECT t0.id AS id_1, t0.nom_image_serveur AS nom_image_serveur_2, t0.nom_image_original AS nom_image_original_3, t0.taille_image AS taille_image_4, t0.extension_image AS extension_image_5, t0.telechargeable AS telechargeable_6, t0.taille AS taille_7 FROM image t0 WHERE t0.id = ?

Parameters:

[
  26
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.nom_image_serveur AS nom_image_serveur_2,
  t0.nom_image_original AS nom_image_original_3,
  t0.taille_image AS taille_image_4,
  t0.extension_image AS extension_image_5,
  t0.telechargeable AS telechargeable_6,
  t0.taille AS taille_7
FROM
  image t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nom_image_serveur AS nom_image_serveur_2, t0.nom_image_original AS nom_image_original_3, t0.taille_image AS taille_image_4, t0.extension_image AS extension_image_5, t0.telechargeable AS telechargeable_6, t0.taille AS taille_7 FROM image t0 WHERE t0.id = 26;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 736)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 754)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 220)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 286)
5	Proxies\__CG__\App\Entity\Image::Doctrine\ORM\Proxy\{closure} (line 100)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 184)
7	Proxies\__CG__\App\Entity\Image->__get (line 54)
8	App\Entity\Image->getNomImageServeur (line 1909)
9	Twig\Extension\CoreExtension::getAttribute (line 232)
10	__TwigTemplate_b55924f0aafea8715cd8273b8c0036ff->block_body (line 446)
11	Twig\Template->yieldBlock (line 390)
12	__TwigTemplate_bc8ce41a95c2fffc928638b09b0f5a66->doDisplay (line 402)
13	Twig\Template->yield (line 54)
14	__TwigTemplate_b55924f0aafea8715cd8273b8c0036ff->doDisplay (line 402)
15	Twig\Template->yield (line 358)
16	Twig\Template->display (line 373)
17	Twig\Template->render (line 51)
18	Twig\TemplateWrapper->render (line 333)
19	Twig\Environment->render (line 448)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 443)
23	App\Controller\EvenementController->listeEvenements (line 181)
24	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
25	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
26	Symfony\Component\HttpKernel\Kernel->handle (line 35)
27	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
28	require_once (line 5)

0.18 ms
(17.15%)

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.nom AS nom_5, t0.prenom AS prenom_6, t0.code_postal AS code_postal_7, t0.ville AS ville_8, t0.nom_image_original AS nom_image_original_9, t0.nom_image_serveur AS nom_image_serveur_10, t0.taille_image AS taille_image_11, t0.extention_image AS extention_image_12, t0.news_letter_validee AS news_letter_validee_13 FROM user t0 INNER JOIN user_evenement ON t0.id = user_evenement.user_id WHERE user_evenement.evenement_id = ?

Parameters:

[
  7
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.nom AS nom_5,
  t0.prenom AS prenom_6,
  t0.code_postal AS code_postal_7,
  t0.ville AS ville_8,
  t0.nom_image_original AS nom_image_original_9,
  t0.nom_image_serveur AS nom_image_serveur_10,
  t0.taille_image AS taille_image_11,
  t0.extention_image AS extention_image_12,
  t0.news_letter_validee AS news_letter_validee_13
FROM
  user t0
  INNER JOIN user_evenement ON t0.id = user_evenement.user_id
WHERE
  user_evenement.evenement_id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.nom AS nom_5, t0.prenom AS prenom_6, t0.code_postal AS code_postal_7, t0.ville AS ville_8, t0.nom_image_original AS nom_image_original_9, t0.nom_image_serveur AS nom_image_serveur_10, t0.taille_image AS taille_image_11, t0.extention_image AS extention_image_12, t0.news_letter_validee AS news_letter_validee_13 FROM user t0 INNER JOIN user_evenement ON t0.id = user_evenement.user_id WHERE user_evenement.evenement_id = 7;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1081)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getManyToManyStatement (line 1010)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadManyToManyCollection (line 2713)
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 1272)
9	Twig\Extension\CoreExtension::length (line 292)
10	__TwigTemplate_b55924f0aafea8715cd8273b8c0036ff->block_body (line 446)
11	Twig\Template->yieldBlock (line 390)
12	__TwigTemplate_bc8ce41a95c2fffc928638b09b0f5a66->doDisplay (line 402)
13	Twig\Template->yield (line 54)
14	__TwigTemplate_b55924f0aafea8715cd8273b8c0036ff->doDisplay (line 402)
15	Twig\Template->yield (line 358)
16	Twig\Template->display (line 373)
17	Twig\Template->render (line 51)
18	Twig\TemplateWrapper->render (line 333)
19	Twig\Environment->render (line 448)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 443)
23	App\Controller\EvenementController->listeEvenements (line 181)
24	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
25	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
26	Symfony\Component\HttpKernel\Kernel->handle (line 35)
27	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
28	require_once (line 5)

0.18 ms
(17.13%)

SELECT t0.id AS id_1, t0.position AS position_2, t0.centrage AS centrage_3, t0.evenement_id AS evenement_id_4, t0.image_id AS image_id_5, t0.texte_id AS texte_id_6, t0.titre_id AS titre_id_7, t0.video_id AS video_id_8, t0.post_id AS post_id_9 FROM paragraphe t0 WHERE t0.evenement_id = ?

Parameters:

[
  7
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.position AS position_2,
  t0.centrage AS centrage_3,
  t0.evenement_id AS evenement_id_4,
  t0.image_id AS image_id_5,
  t0.texte_id AS texte_id_6,
  t0.titre_id AS titre_id_7,
  t0.video_id AS video_id_8,
  t0.post_id AS post_id_9
FROM
  paragraphe t0
WHERE
  t0.evenement_id = ?

SELECT t0.id AS id_1, t0.position AS position_2, t0.centrage AS centrage_3, t0.evenement_id AS evenement_id_4, t0.image_id AS image_id_5, t0.texte_id AS texte_id_6, t0.titre_id AS titre_id_7, t0.video_id AS video_id_8, t0.post_id AS post_id_9 FROM paragraphe t0 WHERE t0.evenement_id = 7;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1848)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1793)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 2709)
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 1)
8	iterator_to_array (line 1044)
9	Twig\Extension\CoreExtension::sort (line 174)
10	__TwigTemplate_b55924f0aafea8715cd8273b8c0036ff->block_body (line 446)
11	Twig\Template->yieldBlock (line 390)
12	__TwigTemplate_bc8ce41a95c2fffc928638b09b0f5a66->doDisplay (line 402)
13	Twig\Template->yield (line 54)
14	__TwigTemplate_b55924f0aafea8715cd8273b8c0036ff->doDisplay (line 402)
15	Twig\Template->yield (line 358)
16	Twig\Template->display (line 373)
17	Twig\Template->render (line 51)
18	Twig\TemplateWrapper->render (line 333)
19	Twig\Environment->render (line 448)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 443)
23	App\Controller\EvenementController->listeEvenements (line 181)
24	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
25	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
26	Symfony\Component\HttpKernel\Kernel->handle (line 35)
27	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
28	require_once (line 5)

0.17 ms
(16.01%)

SELECT t0.id AS id_1, t0.contenu AS contenu_2, t0.couleur AS couleur_3, t0.taille AS taille_4 FROM titre t0 WHERE t0.id = ?

Parameters:

[
  7
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.contenu AS contenu_2,
  t0.couleur AS couleur_3,
  t0.taille AS taille_4
FROM
  titre t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.contenu AS contenu_2, t0.couleur AS couleur_3, t0.taille AS taille_4 FROM titre t0 WHERE t0.id = 7;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 736)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 754)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 220)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 286)
5	Proxies\__CG__\App\Entity\Titre::Doctrine\ORM\Proxy\{closure} (line 100)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 184)
7	Proxies\__CG__\App\Entity\Titre->__get (line 57)
8	App\Entity\Titre->getTaille (line 1909)
9	Twig\Extension\CoreExtension::getAttribute (line 193)
10	__TwigTemplate_b55924f0aafea8715cd8273b8c0036ff->block_body (line 446)
11	Twig\Template->yieldBlock (line 390)
12	__TwigTemplate_bc8ce41a95c2fffc928638b09b0f5a66->doDisplay (line 402)
13	Twig\Template->yield (line 54)
14	__TwigTemplate_b55924f0aafea8715cd8273b8c0036ff->doDisplay (line 402)
15	Twig\Template->yield (line 358)
16	Twig\Template->display (line 373)
17	Twig\Template->render (line 51)
18	Twig\TemplateWrapper->render (line 333)
19	Twig\Environment->render (line 448)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 443)
23	App\Controller\EvenementController->listeEvenements (line 181)
24	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
25	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
26	Symfony\Component\HttpKernel\Kernel->handle (line 35)
27	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
28	require_once (line 5)

0.12 ms
(11.47%)

SELECT t0.id AS id_1, t0.date_evenement AS date_evenement_2, t0.titre AS titre_3, t0.termine AS termine_4, t0.archive AS archive_5, t0.mail_envoye AS mail_envoye_6 FROM evenement t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.date_evenement AS date_evenement_2,
  t0.titre AS titre_3,
  t0.termine AS termine_4,
  t0.archive AS archive_5,
  t0.mail_envoye AS mail_envoye_6
FROM
  evenement t0

SELECT t0.id AS id_1, t0.date_evenement AS date_evenement_2, t0.titre AS titre_3, t0.termine AS termine_4, t0.archive AS archive_5, t0.mail_envoye AS mail_envoye_6 FROM evenement t0;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 938)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 110)
3	Doctrine\ORM\EntityRepository->findBy (line 73)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 96)
5	Doctrine\ORM\EntityRepository->findAll (line 442)
6	App\Controller\EvenementController->listeEvenements (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)

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\Paragraphe	7
App\Entity\Texte	3
App\Entity\Evenement	2
App\Entity\Titre	2
App\Entity\Image	2
App\Entity\User	1

Entities Mapping

Class	Mapping errors
App\Entity\Evenement	No errors.
App\Entity\User	No errors.
App\Entity\Paragraphe	No errors.
App\Entity\Image	No errors.
App\Entity\Texte	No errors.
App\Entity\Titre	No errors.
App\Entity\Video	No errors.
App\Entity\Post	No errors.
App\Entity\Carroussel	No errors.

Symfony Profiler

GET http://s5-5738.nuage-peda.fr/allianceQueantCoteDIvoire/liste-evenements

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping