Symfony Profiler

Query Metrics

8 Database Queries

6 Different statements

11.39 ms Query time

0 Invalid entities

460 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

4.62 ms
(40.51%)

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:

[
  2026
  "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 = 2026 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)

1.91 ms
(16.74%)

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)

1.67 ms
(14.64%)

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:

[
  2026
  "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 = 2026 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)

1.57 ms
(13.81%)

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 = 2026 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.26 ms
(11.04%)

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:

[
  175
]

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 = 175;

#	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)

0.37 ms
(3.26%)

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

Parameters:

[
  213
]

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 = 213;

#	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)

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	364
App\Entity\Course	95
App\Entity\University	1

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

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping