Symfony Profiler

Query Metrics

156 Database Queries

6 Different statements

169.89 ms Query time

0 Invalid entities

3241 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

75.83 ms
(44.64%)

SELECT t0.id AS id_1, t0.name AS name_2 FROM course t0 WHERE t0.id = ?

Parameters:

[
  85
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2
FROM
  course t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2 FROM course t0 WHERE t0.id = 85;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
3	Doctrine\ORM\Proxy\ProxyFactory->{closure:Doctrine\ORM\Proxy\ProxyFactory::getProxy():217} (line 223)
4	Twig\Extension\CoreExtension::getAttribute (line 1795)
5	__TwigTemplate_30ce0747294aad786a080e03e105f1e9::block_body (line 248)
6	Twig\Template->yieldBlock (line 446)
7	__TwigTemplate_7e4061ab1b982f2dbcf7b5683cbb4769->doDisplay (line 241)
8	Twig\Template->yield (line 402)
9	__TwigTemplate_30ce0747294aad786a080e03e105f1e9->doDisplay (line 54)
10	Twig\Template->yield (line 402)
11	Twig\Template->display (line 358)
12	Twig\Template->render (line 373)
13	Twig\TemplateWrapper->render (line 51)
14	Twig\Environment->render (line 333)
15	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 462)
16	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 467)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 279)
18	App\Controller\Pub\MainController->alunosAprovados (line 209)
19	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
20	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
21	Symfony\Component\HttpKernel\Kernel->handle (line 191)
22	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
23	require_once (line 32)
24	require_once (line 5)

69.17 ms
(40.71%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.image AS image_3, t0.year AS year_4, t0.sector AS sector_5, t0.featured AS featured_6, t0.active AS active_7, t0.rank AS rank_8, t0.updated_at AS updated_at_9, t0.university_id AS university_id_10, t0.course_id AS course_id_11 FROM student t0 WHERE t0.university_id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.image AS image_3,
  t0.year AS year_4,
  t0.sector AS sector_5,
  t0.featured AS featured_6,
  t0.active AS active_7,
  t0.rank AS rank_8,
  t0.updated_at AS updated_at_9,
  t0.university_id AS university_id_10,
  t0.course_id AS course_id_11
FROM
  student t0
WHERE
  t0.university_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.image AS image_3, t0.year AS year_4, t0.sector AS sector_5, t0.featured AS featured_6, t0.active AS active_7, t0.rank AS rank_8, t0.updated_at AS updated_at_9, t0.university_id AS university_id_10, t0.course_id AS course_id_11 FROM student t0 WHERE t0.university_id = 1;

#	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	IteratorIterator->__construct (line 1980)
8	Twig\Extension\CoreExtension->filter (line 1980)
9	__TwigTemplate_30ce0747294aad786a080e03e105f1e9::block_body (line 362)
10	Twig\Template->yieldBlock (line 446)
11	__TwigTemplate_7e4061ab1b982f2dbcf7b5683cbb4769->doDisplay (line 241)
12	Twig\Template->yield (line 402)
13	__TwigTemplate_30ce0747294aad786a080e03e105f1e9->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 462)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 467)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 279)
22	App\Controller\Pub\MainController->alunosAprovados (line 209)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
25	Symfony\Component\HttpKernel\Kernel->handle (line 191)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
27	require_once (line 32)
28	require_once (line 5)

15.49 ms
(9.12%)

SELECT u0_.id AS id_0, u0_.name AS name_1, u0_.type AS type_2, u0_.logo AS logo_3, u0_.updated_at AS updated_at_4 FROM university u0_ INNER JOIN student s1_ ON u0_.id = s1_.university_id WHERE s1_.year = ? AND (u0_.type = ? OR u0_.type IS NULL OR u0_.type = ?) ORDER BY u0_.name ASC, s1_.name ASC

Parameters:

[
  2019
  "comum"
  ""
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  u0_.id AS id_0,
  u0_.name AS name_1,
  u0_.type AS type_2,
  u0_.logo AS logo_3,
  u0_.updated_at AS updated_at_4
FROM
  university u0_
  INNER JOIN student s1_ ON u0_.id = s1_.university_id
WHERE
  s1_.year = ?
  AND (
    u0_.type = ?
    OR u0_.type IS NULL
    OR u0_.type = ?
  )
ORDER BY
  u0_.name ASC,
  s1_.name ASC

SELECT u0_.id AS id_0, u0_.name AS name_1, u0_.type AS type_2, u0_.logo AS logo_3, u0_.updated_at AS updated_at_4 FROM university u0_ INNER JOIN student s1_ ON u0_.id = s1_.university_id WHERE s1_.year = 2019 AND (u0_.type = 'comum' OR u0_.type IS NULL OR u0_.type = '') ORDER BY u0_.name ASC, s1_.name 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 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getResult (line 688)
6	App\Repository\UniversityRepository->findActiveByYear (line 45)
7	App\Service\UniversityService->getByYear (line 35)
8	App\Controller\Pub\MainController->alunosAprovados (line 206)
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.05 ms
(2.97%)

SELECT u0_.id AS id_0, u0_.name AS name_1, u0_.type AS type_2, u0_.logo AS logo_3, u0_.updated_at AS updated_at_4 FROM university u0_ INNER JOIN student s1_ ON u0_.id = s1_.university_id WHERE s1_.year = ? AND u0_.type = ? ORDER BY u0_.name ASC, s1_.name ASC

Parameters:

[
  2019
  "federal"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  u0_.id AS id_0,
  u0_.name AS name_1,
  u0_.type AS type_2,
  u0_.logo AS logo_3,
  u0_.updated_at AS updated_at_4
FROM
  university u0_
  INNER JOIN student s1_ ON u0_.id = s1_.university_id
WHERE
  s1_.year = ?
  AND u0_.type = ?
ORDER BY
  u0_.name ASC,
  s1_.name ASC

SELECT u0_.id AS id_0, u0_.name AS name_1, u0_.type AS type_2, u0_.logo AS logo_3, u0_.updated_at AS updated_at_4 FROM university u0_ INNER JOIN student s1_ ON u0_.id = s1_.university_id WHERE s1_.year = 2019 AND u0_.type = 'federal' ORDER BY u0_.name ASC, s1_.name 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 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getResult (line 688)
6	App\Repository\UniversityRepository->findActiveByYear (line 45)
7	App\Service\UniversityService->getByYear (line 35)
8	App\Controller\Pub\MainController->alunosAprovados (line 206)
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)

2.88 ms
(1.70%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.image AS image_3, t0.year AS year_4, t0.sector AS sector_5, t0.featured AS featured_6, t0.active AS active_7, t0.rank AS rank_8, t0.updated_at AS updated_at_9, t0.university_id AS university_id_10, t0.course_id AS course_id_11 FROM student t0 WHERE t0.featured = ? AND t0.year = ? AND t0.active = ? ORDER BY t0.name ASC LIMIT 4

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.image AS image_3,
  t0.year AS year_4,
  t0.sector AS sector_5,
  t0.featured AS featured_6,
  t0.active AS active_7,
  t0.rank AS rank_8,
  t0.updated_at AS updated_at_9,
  t0.university_id AS university_id_10,
  t0.course_id AS course_id_11
FROM
  student t0
WHERE
  t0.featured = ?
  AND t0.year = ?
  AND t0.active = ?
ORDER BY
  t0.name ASC
LIMIT
  4

SELECT t0.id AS id_1, t0.name AS name_2, t0.image AS image_3, t0.year AS year_4, t0.sector AS sector_5, t0.featured AS featured_6, t0.active AS active_7, t0.rank AS rank_8, t0.updated_at AS updated_at_9, t0.university_id AS university_id_10, t0.course_id AS course_id_11 FROM student t0 WHERE t0.featured = 1 AND t0.year = 2019 AND t0.active = 1 ORDER BY t0.name ASC LIMIT 4;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 963)
2	Doctrine\ORM\EntityRepository->findBy (line 110)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepository->findBy (line 78)
4	App\Repository\StudentRepository->findFeaturedByYear (line 65)
5	App\Service\StudentService->getFeaturedByYear (line 43)
6	App\Controller\Pub\MainController->alunosAprovados (line 207)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
9	Symfony\Component\HttpKernel\Kernel->handle (line 191)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
11	require_once (line 32)
12	require_once (line 5)

1.46 ms
(0.86%)

SELECT s0_.year AS year_0 FROM student s0_ WHERE s0_.active = ? GROUP BY s0_.year ORDER BY s0_.year DESC

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  s0_.year AS year_0
FROM
  student s0_
WHERE
  s0_.active = ?
GROUP BY
  s0_.year
ORDER BY
  s0_.year DESC

SELECT s0_.year AS year_0 FROM student s0_ WHERE s0_.active = 1 GROUP BY s0_.year ORDER BY s0_.year DESC;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getResult (line 688)
6	App\Repository\StudentRepository->findYears (line 32)
7	App\Service\StudentService->getYears (line 35)
8	App\Controller\Pub\MainController->alunosAprovados (line 201)
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)

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\Student	2950
App\Entity\Course	220
App\Entity\University	71

Entities Mapping

Class	Mapping errors
App\Entity\Student	No errors.
App\Entity\University	No errors.
App\Entity\Course	No errors.

Symfony Profiler

GET https://conexao.wab.com.br/alunos-aprovados?ano=2019

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping