Symfony Profiler

Query Metrics

228 Database Queries

5 Different statements

57.06 ms Query time

0 Invalid entities

2092 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

46.53 ms
(81.54%)

185

SELECT t0.id AS id_1, t0.value AS value_2, t0.vote_id AS vote_id_3, t0.criterion_id AS criterion_id_4 FROM vote_score t0 WHERE t0.vote_id = ?

Parameters:

[
  67
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.value AS value_2,
  t0.vote_id AS vote_id_3,
  t0.criterion_id AS criterion_id_4
FROM
  vote_score t0
WHERE
  t0.vote_id = ?

SELECT t0.id AS id_1, t0.value AS value_2, t0.vote_id AS vote_id_3, t0.criterion_id AS criterion_id_4 FROM vote_score t0 WHERE t0.vote_id = 67;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1872)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 1817)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2729)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 315)
7	App\Entity\Vote->getValueForCriterion (line 124)
8	App\Controller\ResultsController->index (line 72)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
11	Symfony\Component\HttpKernel\Kernel->handle (line 191)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
13	require_once (line 32)
14	require_once (line 5)

5.31 ms
(9.31%)

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.room_id AS room_id_5 FROM voter t0 WHERE t0.id = ?

Parameters:

[
  1
]

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.room_id AS room_id_5
FROM
  voter t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.room_id AS room_id_5 FROM voter t0 WHERE t0.id = 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
3	Doctrine\ORM\EntityManager->find (line 366)
4	Doctrine\ORM\EntityRepository->find (line 86)
5	Symfony\Bridge\Doctrine\Security\User\EntityUserProvider->refreshUser (line 97)
6	Symfony\Component\Security\Http\Firewall\ContextListener->refreshUser (line 212)
7	Symfony\Component\Security\Http\Firewall\ContextListener->authenticate (line 129)
8	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 52)
9	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->{closure:Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext::authenticate():74} (line 77)
10	Symfony\Component\Security\Core\Authentication\Token\Storage\TokenStorage::getToken (line 34)
11	Symfony\Component\Security\Core\Authentication\Token\Storage\UsageTrackingTokenStorage->getToken (line 42)
12	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->getUser (line 378)
13	App\Controller\ResultsController->index (line 31)
14	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
15	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
16	Symfony\Component\HttpKernel\Kernel->handle (line 191)
17	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
18	require_once (line 32)
19	require_once (line 5)

4.65 ms
(8.15%)

SELECT t0.id AS id_1, t0.comment AS comment_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.voter_id AS voter_id_5, t0.project_id AS project_id_6 FROM vote t0 WHERE t0.project_id = ?

Parameters:

[
  14
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.comment AS comment_2,
  t0.created_at AS created_at_3,
  t0.updated_at AS updated_at_4,
  t0.voter_id AS voter_id_5,
  t0.project_id AS project_id_6
FROM
  vote t0
WHERE
  t0.project_id = ?

SELECT t0.id AS id_1, t0.comment AS comment_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.voter_id AS voter_id_5, t0.project_id AS project_id_6 FROM vote t0 WHERE t0.project_id = 14;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 963)
2	Doctrine\ORM\EntityRepository->findBy (line 110)
3	App\Controller\ResultsController->index (line 41)
4	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
5	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
6	Symfony\Component\HttpKernel\Kernel->handle (line 191)
7	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
8	require_once (line 32)
9	require_once (line 5)

0.33 ms
(0.58%)

SELECT t0.id AS id_1, t0.title AS title_2, t0.coefficient AS coefficient_3, t0.is_annex AS is_annex_4 FROM criterion t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.coefficient AS coefficient_3,
  t0.is_annex AS is_annex_4
FROM
  criterion t0

SELECT t0.id AS id_1, t0.title AS title_2, t0.coefficient AS coefficient_3, t0.is_annex AS is_annex_4 FROM criterion t0;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 963)
2	Doctrine\ORM\EntityRepository->findBy (line 110)
3	Doctrine\ORM\EntityRepository->findAll (line 96)
4	App\Controller\ResultsController->index (line 20)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
7	Symfony\Component\HttpKernel\Kernel->handle (line 191)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
9	require_once (line 32)
10	require_once (line 5)

0.25 ms
(0.43%)

SELECT t0.id AS id_1, t0.title AS title_2, t0.short_description AS short_description_3, t0.establishment AS establishment_4, t0.room_id AS room_id_5 FROM project t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.short_description AS short_description_3,
  t0.establishment AS establishment_4,
  t0.room_id AS room_id_5
FROM
  project t0

SELECT t0.id AS id_1, t0.title AS title_2, t0.short_description AS short_description_3, t0.establishment AS establishment_4, t0.room_id AS room_id_5 FROM project t0;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 963)
2	Doctrine\ORM\EntityRepository->findBy (line 110)
3	Doctrine\ORM\EntityRepository->findAll (line 96)
4	App\Controller\ResultsController->index (line 39)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
7	Symfony\Component\HttpKernel\Kernel->handle (line 191)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
9	require_once (line 32)
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\VoteScore	1850
App\Entity\Vote	185
App\Entity\Voter	28
App\Entity\Project	17
App\Entity\Criterion	10
App\Entity\Room	2

Entities Mapping

Class	Mapping errors
App\Entity\Criterion	No errors.
App\Entity\VoteScore	No errors.
App\Entity\Voter	No errors.
App\Entity\Room	No errors.
App\Entity\Vote	No errors.
App\Entity\Project	No errors.

Symfony Profiler

GET http://jury.ecotrophelia.org/results

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping