Symfony Profiler

Query Metrics

35 Database Queries

3 Different statements

31.64 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

18.62 ms
(58.86%)

SELECT t0.id AS id_1, t0.date_score AS date_score_2, t0.participant_id AS participant_id_3 FROM score t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.date_score AS date_score_2,
  t0.participant_id AS participant_id_3
FROM
  score t0

SELECT t0.id AS id_1, t0.date_score AS date_score_2, t0.participant_id AS participant_id_3 FROM score t0;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 904)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 110)
3	Doctrine\ORM\EntityRepository->findBy (line 72)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 96)
5	Doctrine\ORM\EntityRepository->findAll (line 114)
6	App\Controller\ScoreController->showScore (line 178)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
9	Symfony\Component\HttpKernel\Kernel->handle (line 35)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
11	require_once (line 5)

7.53 ms
(23.81%)

SELECT t0.id AS id_1, t0.label AS label_2, t0.valeur AS valeur_3, t0.description AS description_4 FROM flag t0 INNER JOIN score_flag ON t0.id = score_flag.flag_id WHERE score_flag.score_id = ?

Parameters:

[
  3
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.label AS label_2,
  t0.valeur AS valeur_3,
  t0.description AS description_4
FROM
  flag t0
  INNER JOIN score_flag ON t0.id = score_flag.flag_id
WHERE
  score_flag.score_id = ?

SELECT t0.id AS id_1, t0.label AS label_2, t0.valeur AS valeur_3, t0.description AS description_4 FROM flag t0 INNER JOIN score_flag ON t0.id = score_flag.flag_id WHERE score_flag.score_id = 3;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1047)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getManyToManyStatement (line 976)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadManyToManyCollection (line 2703)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 620)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 184)
6	Doctrine\ORM\PersistentCollection->initialize (line 313)
7	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 102)
8	__TwigTemplate_80ff4d862f8ab17858cc4fbfcbd3818b->doDisplay (line 394)
9	Twig\Template->displayWithErrorHandling (line 367)
10	Twig\Template->display (line 379)
11	Twig\Template->render (line 38)
12	Twig\TemplateWrapper->render (line 280)
13	Twig\Environment->render (line 431)
14	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
15	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
16	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 116)
17	App\Controller\ScoreController->showScore (line 178)
18	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
19	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
20	Symfony\Component\HttpKernel\Kernel->handle (line 35)
21	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
22	require_once (line 5)

5.48 ms
(17.33%)

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.prenom AS prenom_3, t0.login AS login_4, t0.active AS active_5 FROM participant t0 WHERE t0.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.prenom AS prenom_3,
  t0.login AS login_4,
  t0.active AS active_5
FROM
  participant t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.prenom AS prenom_3, t0.login AS login_4, t0.active AS active_5 FROM participant t0 WHERE t0.id = 2;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 733)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 751)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 221)
4	Doctrine\ORM\Proxy\ProxyFactory::{closure:Doctrine\ORM\Proxy\ProxyFactory::createLazyInitializer():219} (line 287)
5	Proxies\__CG__\App\Entity\Participant::{closure:{closure:Doctrine\ORM\Proxy\ProxyFactory::getProxyFactory():285}:286} (line 61)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 118)
7	Proxies\__CG__\App\Entity\Participant->__get (line 45)
8	App\Entity\Participant->getNom (line 1635)
9	twig_get_attribute (line 94)
10	__TwigTemplate_80ff4d862f8ab17858cc4fbfcbd3818b->doDisplay (line 394)
11	Twig\Template->displayWithErrorHandling (line 367)
12	Twig\Template->display (line 379)
13	Twig\Template->render (line 38)
14	Twig\TemplateWrapper->render (line 280)
15	Twig\Environment->render (line 431)
16	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 116)
19	App\Controller\ScoreController->showScore (line 178)
20	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
21	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
22	Symfony\Component\HttpKernel\Kernel->handle (line 35)
23	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
24	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.

Entities Mapping

Class	Mapping errors
App\Entity\Score	No errors.
App\Entity\Participant	No errors.
App\Entity\Flag	No errors.

Symfony Profiler

GET https://ctfpanel.adrardev.fr/score/all

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping