Symfony Profiler

Query Metrics

5 Database Queries

5 Different statements

9.10 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

2.62 ms
(28.80%)

SELECT t0.id AS id_1, t0.pergunta AS pergunta_2, t0.resposta AS resposta_3, t0.ordem AS ordem_4, t0.curso_id AS curso_id_5 FROM faq_curso t0 WHERE t0.curso_id = ? ORDER BY t0.ordem ASC

Parameters:

[
  15
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.pergunta AS pergunta_2,
  t0.resposta AS resposta_3,
  t0.ordem AS ordem_4,
  t0.curso_id AS curso_id_5
FROM
  faq_curso t0
WHERE
  t0.curso_id = ?
ORDER BY
  t0.ordem ASC

SELECT t0.id AS id_1, t0.pergunta AS pergunta_2, t0.resposta AS resposta_3, t0.ordem AS ordem_4, t0.curso_id AS curso_id_5 FROM faq_curso t0 WHERE t0.curso_id = 15 ORDER BY t0.ordem ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1842)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1787)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 2706)
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 1241)
9	Twig\Extension\CoreExtension::length (line 356)
10	__TwigTemplate_8acb634737517b9f7e16f6bc39a1cc8e->block_body (line 432)
11	Twig\Template->yieldBlock (line 288)
12	__TwigTemplate_531748c4b19ed064f8ed9f501176cb79->doDisplay (line 388)
13	Twig\Template->yield (line 55)
14	__TwigTemplate_8acb634737517b9f7e16f6bc39a1cc8e->doDisplay (line 388)
15	Twig\Template->yield (line 344)
16	Twig\Template->display (line 359)
17	Twig\Template->render (line 51)
18	Twig\TemplateWrapper->render (line 334)
19	Twig\Environment->render (line 431)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 87)
23	App\Controller\pub\MainController->cursoDetalhe (line 183)
24	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
25	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
26	Symfony\Component\HttpKernel\Kernel->handle (line 35)
27	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
28	require_once (line 5)

1.88 ms
(20.63%)

SELECT t0.id AS id_1, t0.nome_modulo AS nome_modulo_2, t0.descricao AS descricao_3, t0.ordem AS ordem_4, t0.curso_id AS curso_id_5 FROM grade_curricular t0 WHERE t0.curso_id = ? ORDER BY t0.ordem ASC

Parameters:

[
  15
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.nome_modulo AS nome_modulo_2,
  t0.descricao AS descricao_3,
  t0.ordem AS ordem_4,
  t0.curso_id AS curso_id_5
FROM
  grade_curricular t0
WHERE
  t0.curso_id = ?
ORDER BY
  t0.ordem ASC

SELECT t0.id AS id_1, t0.nome_modulo AS nome_modulo_2, t0.descricao AS descricao_3, t0.ordem AS ordem_4, t0.curso_id AS curso_id_5 FROM grade_curricular t0 WHERE t0.curso_id = 15 ORDER BY t0.ordem ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1842)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1787)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 2706)
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 1241)
9	Twig\Extension\CoreExtension::length (line 227)
10	__TwigTemplate_8acb634737517b9f7e16f6bc39a1cc8e->block_body (line 432)
11	Twig\Template->yieldBlock (line 288)
12	__TwigTemplate_531748c4b19ed064f8ed9f501176cb79->doDisplay (line 388)
13	Twig\Template->yield (line 55)
14	__TwigTemplate_8acb634737517b9f7e16f6bc39a1cc8e->doDisplay (line 388)
15	Twig\Template->yield (line 344)
16	Twig\Template->display (line 359)
17	Twig\Template->render (line 51)
18	Twig\TemplateWrapper->render (line 334)
19	Twig\Environment->render (line 431)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 87)
23	App\Controller\pub\MainController->cursoDetalhe (line 183)
24	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
25	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
26	Symfony\Component\HttpKernel\Kernel->handle (line 35)
27	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
28	require_once (line 5)

1.82 ms
(20.03%)

SELECT c0_.id AS id_0, c0_.titulo AS titulo_1, c0_.chamada_curta AS chamada_curta_2, c0_.chamada_longa AS chamada_longa_3, c0_.imagem_principal AS imagem_principal_4, c0_.ordem AS ordem_5, c0_.active AS active_6, c0_.updated_at AS updated_at_7 FROM curso c0_

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  c0_.id AS id_0,
  c0_.titulo AS titulo_1,
  c0_.chamada_curta AS chamada_curta_2,
  c0_.chamada_longa AS chamada_longa_3,
  c0_.imagem_principal AS imagem_principal_4,
  c0_.ordem AS ordem_5,
  c0_.active AS active_6,
  c0_.updated_at AS updated_at_7
FROM
  curso c0_

SELECT c0_.id AS id_0, c0_.titulo AS titulo_1, c0_.chamada_curta AS chamada_curta_2, c0_.chamada_longa AS chamada_longa_3, c0_.imagem_principal AS imagem_principal_4, c0_.ordem AS ordem_5, c0_.active AS active_6, c0_.updated_at AS updated_at_7 FROM curso c0_;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 35)
6	Symfony\Bridge\Doctrine\Form\ChoiceList\ORMQueryBuilderLoader->getEntities (line 53)
7	Symfony\Bridge\Doctrine\Form\ChoiceList\DoctrineChoiceLoader->loadChoices (line 29)
8	Symfony\Component\Form\ChoiceList\Loader\AbstractChoiceLoader->loadChoiceList (line 56)
9	Symfony\Component\Form\ChoiceList\LazyChoiceList->getChoices (line 60)
10	Symfony\Component\Form\ChoiceList\Factory\DefaultChoiceListFactory->createView (line 178)
11	Symfony\Component\Form\ChoiceList\Factory\PropertyAccessDecorator->createView (line 187)
12	Symfony\Component\Form\ChoiceList\Factory\CachingFactoryDecorator->createView (line 477)
13	Symfony\Component\Form\Extension\Core\Type\ChoiceType->createChoiceListView (line 234)
14	Symfony\Component\Form\Extension\Core\Type\ChoiceType->buildView (line 107)
15	Symfony\Component\Form\ResolvedFormType->buildView (line 78)
16	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildView (line 105)
17	Symfony\Component\Form\ResolvedFormType->buildView (line 78)
18	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildView (line 888)
19	Symfony\Component\Form\Form->createView (line 891)
20	Symfony\Component\Form\Form->createView (line 423)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 87)
24	App\Controller\pub\MainController->cursoDetalhe (line 183)
25	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
26	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
27	Symfony\Component\HttpKernel\Kernel->handle (line 35)
28	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
29	require_once (line 5)

1.53 ms
(16.77%)

SELECT t0.id AS id_1, t0.nome AS nome_2, t0.imagem AS imagem_3, t0.ordem AS ordem_4, t0.updated_at AS updated_at_5, t0.curso_id AS curso_id_6 FROM estrutura_curso t0 WHERE t0.curso_id = ? ORDER BY t0.ordem ASC

Parameters:

[
  15
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.nome AS nome_2,
  t0.imagem AS imagem_3,
  t0.ordem AS ordem_4,
  t0.updated_at AS updated_at_5,
  t0.curso_id AS curso_id_6
FROM
  estrutura_curso t0
WHERE
  t0.curso_id = ?
ORDER BY
  t0.ordem ASC

SELECT t0.id AS id_1, t0.nome AS nome_2, t0.imagem AS imagem_3, t0.ordem AS ordem_4, t0.updated_at AS updated_at_5, t0.curso_id AS curso_id_6 FROM estrutura_curso t0 WHERE t0.curso_id = 15 ORDER BY t0.ordem ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1842)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1787)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 2706)
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 1241)
9	Twig\Extension\CoreExtension::length (line 303)
10	__TwigTemplate_8acb634737517b9f7e16f6bc39a1cc8e->block_body (line 432)
11	Twig\Template->yieldBlock (line 288)
12	__TwigTemplate_531748c4b19ed064f8ed9f501176cb79->doDisplay (line 388)
13	Twig\Template->yield (line 55)
14	__TwigTemplate_8acb634737517b9f7e16f6bc39a1cc8e->doDisplay (line 388)
15	Twig\Template->yield (line 344)
16	Twig\Template->display (line 359)
17	Twig\Template->render (line 51)
18	Twig\TemplateWrapper->render (line 334)
19	Twig\Environment->render (line 431)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 87)
23	App\Controller\pub\MainController->cursoDetalhe (line 183)
24	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
25	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
26	Symfony\Component\HttpKernel\Kernel->handle (line 35)
27	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
28	require_once (line 5)

1.25 ms
(13.76%)

SELECT t0.id AS id_1, t0.titulo AS titulo_2, t0.chamada_curta AS chamada_curta_3, t0.chamada_longa AS chamada_longa_4, t0.imagem_principal AS imagem_principal_5, t0.ordem AS ordem_6, t0.active AS active_7, t0.updated_at AS updated_at_8 FROM curso t0 WHERE t0.id = ?

Parameters:

[
  15
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.titulo AS titulo_2,
  t0.chamada_curta AS chamada_curta_3,
  t0.chamada_longa AS chamada_longa_4,
  t0.imagem_principal AS imagem_principal_5,
  t0.ordem AS ordem_6,
  t0.active AS active_7,
  t0.updated_at AS updated_at_8
FROM
  curso t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.titulo AS titulo_2, t0.chamada_curta AS chamada_curta_3, t0.chamada_longa AS chamada_longa_4, t0.imagem_principal AS imagem_principal_5, t0.ordem AS ordem_6, t0.active AS active_7, t0.updated_at AS updated_at_8 FROM curso t0 WHERE t0.id = 15;

#	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 362)
4	Doctrine\ORM\EntityManager->find (line 86)
5	Doctrine\ORM\EntityRepository->find (line 61)
6	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->find (line 70)
7	App\Controller\pub\MainController->cursoDetalhe (line 183)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
10	Symfony\Component\HttpKernel\Kernel->handle (line 35)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
12	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\Curso	No errors.
App\Entity\GradeCurricular	No errors.
App\Entity\EstruturaCurso	No errors.
App\Entity\FaqCurso	No errors.
App\Entity\Interessado	No errors.

Symfony Profiler

GET https://cetec.wab.com.br/cursos/15

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping