Symfony Profiler

Query Metrics

10 Database Queries

10 Different statements

5.78 ms Query time

0 Invalid entities

0 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

1.20 ms
(20.74%)

SELECT DISTINCT count(DISTINCT f0_.rut) AS sclr_0 FROM faculty f0_ LEFT JOIN `user` u1_ ON f0_.user_id = u1_.id LEFT JOIN faculty_assignment f2_ ON f0_.rut = f2_.faculty_rut LEFT JOIN department d3_ ON f2_.department_id = d3_.id LEFT JOIN faculty_research_area f5_ ON f0_.rut = f5_.faculty_rut LEFT JOIN research_area r4_ ON r4_.id = f5_.research_area_id LEFT JOIN faculty_research_line f7_ ON f0_.rut = f7_.faculty_rut LEFT JOIN research_line r6_ ON r6_.id = f7_.research_line_id WHERE f0_.active = 1

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT count(DISTINCT f0_.rut) AS sclr_0
FROM
  faculty f0_
  LEFT JOIN `user` u1_ ON f0_.user_id = u1_.id
  LEFT JOIN faculty_assignment f2_ ON f0_.rut = f2_.faculty_rut
  LEFT JOIN department d3_ ON f2_.department_id = d3_.id
  LEFT JOIN faculty_research_area f5_ ON f0_.rut = f5_.faculty_rut
  LEFT JOIN research_area r4_ ON r4_.id = f5_.research_area_id
  LEFT JOIN faculty_research_line f7_ ON f0_.rut = f7_.faculty_rut
  LEFT JOIN research_line r6_ ON r6_.id = f7_.research_line_id
WHERE
  f0_.active = 1

SELECT DISTINCT count(DISTINCT f0_.rut) AS sclr_0 FROM faculty f0_ LEFT JOIN `user` u1_ ON f0_.user_id = u1_.id LEFT JOIN faculty_assignment f2_ ON f0_.rut = f2_.faculty_rut LEFT JOIN department d3_ ON f2_.department_id = d3_.id LEFT JOIN faculty_research_area f5_ ON f0_.rut = f5_.faculty_rut LEFT JOIN research_area r4_ ON r4_.id = f5_.research_area_id LEFT JOIN faculty_research_line f7_ ON f0_.rut = f7_.faculty_rut LEFT JOIN research_line r6_ ON r6_.id = f7_.research_line_id WHERE f0_.active = 1;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 935)
4	Doctrine\ORM\AbstractQuery->execute (line 891)
5	Doctrine\ORM\AbstractQuery->getScalarResult (line 725)
6	Doctrine\ORM\Tools\Pagination\Paginator->count (line 96)
7	count (line 43)
8	Knp\Component\Pager\Event\Subscriber\Paginate\Doctrine\ORM\QuerySubscriber::items (line 43)
9	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
10	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
11	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
12	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
13	Knp\Component\Pager\Paginator->paginate (line 97)
14	ContainerHOhRH7k\PaginatorProxyBa079e5->paginate (line 20)
15	App\Controller\FacultiesController->index (line 52)
16	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
17	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
18	Symfony\Component\HttpKernel\Kernel->handle (line 182)
19	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
20	require_once (line 29)
21	require_once (line 5)

1.00 ms
(17.30%)

SELECT d0_.id AS id_0, d0_.department AS department_1, d0_.english_name AS english_name_2, d0_.active AS active_3 FROM department d0_ WHERE d0_.active = 1 AND d0_.id IN (?) ORDER BY d0_.department ASC

Parameters:

[
  ""
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  d0_.id AS id_0,
  d0_.department AS department_1,
  d0_.english_name AS english_name_2,
  d0_.active AS active_3
FROM
  department d0_
WHERE
  d0_.active = 1
  AND d0_.id IN (?)
ORDER BY
  d0_.department ASC

SELECT d0_.id AS id_0, d0_.department AS department_1, d0_.english_name AS english_name_2, d0_.active AS active_3 FROM department d0_ WHERE d0_.active = 1 AND d0_.id IN ('') ORDER BY d0_.department 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 935)
4	Doctrine\ORM\AbstractQuery->execute (line 891)
5	Doctrine\ORM\AbstractQuery->getResult (line 689)
6	Symfony\Bridge\Doctrine\Form\ChoiceList\ORMQueryBuilderLoader->getEntitiesByIds (line 99)
7	Symfony\Bridge\Doctrine\Form\ChoiceList\DoctrineChoiceLoader->doLoadChoicesForValues (line 92)
8	Symfony\Component\Form\ChoiceList\Loader\AbstractChoiceLoader->loadChoicesForValues (line 38)
9	Symfony\Component\Form\ChoiceList\LazyChoiceList->getChoicesForValues (line 76)
10	Symfony\Component\Form\Extension\Core\DataTransformer\ChoiceToValueTransformer->reverseTransform (line 41)
11	Symfony\Component\Form\Form->viewToNorm (line 1002)
12	Symfony\Component\Form\Form->submit (line 552)
13	Symfony\Component\Form\Form->submit (line 493)
14	Symfony\Component\Form\Extension\HttpFoundation\HttpFoundationRequestHandler->handleRequest (line 107)
15	Symfony\Component\Form\Form->handleRequest (line 414)
16	App\Controller\FacultiesController->index (line 38)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
19	Symfony\Component\HttpKernel\Kernel->handle (line 182)
20	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
21	require_once (line 29)
22	require_once (line 5)

0.68 ms
(11.81%)

SELECT c0_.codCurriculum AS codCurriculum_0, c0_.nom_curriculum AS nom_curriculum_1, c0_.active AS active_2, c0_.nom_curriculum_english AS nom_curriculum_english_3 FROM cod_curriculum c0_ WHERE c0_.active = 1 AND c0_.codCurriculum IN (?) ORDER BY c0_.nom_curriculum ASC

Parameters:

[
  "40201"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  c0_.codCurriculum AS codCurriculum_0,
  c0_.nom_curriculum AS nom_curriculum_1,
  c0_.active AS active_2,
  c0_.nom_curriculum_english AS nom_curriculum_english_3
FROM
  cod_curriculum c0_
WHERE
  c0_.active = 1
  AND c0_.codCurriculum IN (?)
ORDER BY
  c0_.nom_curriculum ASC

SELECT c0_.codCurriculum AS codCurriculum_0, c0_.nom_curriculum AS nom_curriculum_1, c0_.active AS active_2, c0_.nom_curriculum_english AS nom_curriculum_english_3 FROM cod_curriculum c0_ WHERE c0_.active = 1 AND c0_.codCurriculum IN ('40201') ORDER BY c0_.nom_curriculum 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 935)
4	Doctrine\ORM\AbstractQuery->execute (line 891)
5	Doctrine\ORM\AbstractQuery->getResult (line 689)
6	Symfony\Bridge\Doctrine\Form\ChoiceList\ORMQueryBuilderLoader->getEntitiesByIds (line 99)
7	Symfony\Bridge\Doctrine\Form\ChoiceList\DoctrineChoiceLoader->doLoadChoicesForValues (line 92)
8	Symfony\Component\Form\ChoiceList\Loader\AbstractChoiceLoader->loadChoicesForValues (line 38)
9	Symfony\Component\Form\ChoiceList\LazyChoiceList->getChoicesForValues (line 76)
10	Symfony\Component\Form\Extension\Core\DataTransformer\ChoiceToValueTransformer->reverseTransform (line 41)
11	Symfony\Component\Form\Form->viewToNorm (line 1002)
12	Symfony\Component\Form\Form->submit (line 552)
13	Symfony\Component\Form\Form->submit (line 493)
14	Symfony\Component\Form\Extension\HttpFoundation\HttpFoundationRequestHandler->handleRequest (line 107)
15	Symfony\Component\Form\Form->handleRequest (line 414)
16	App\Controller\FacultiesController->index (line 38)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
19	Symfony\Component\HttpKernel\Kernel->handle (line 182)
20	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
21	require_once (line 29)
22	require_once (line 5)

0.66 ms
(11.42%)

SELECT DISTINCT f0_.rut AS rut_0 FROM faculty f0_ LEFT JOIN `user` u1_ ON f0_.user_id = u1_.id LEFT JOIN faculty_assignment f2_ ON f0_.rut = f2_.faculty_rut LEFT JOIN department d3_ ON f2_.department_id = d3_.id LEFT JOIN faculty_research_area f5_ ON f0_.rut = f5_.faculty_rut LEFT JOIN research_area r4_ ON r4_.id = f5_.research_area_id LEFT JOIN faculty_research_line f7_ ON f0_.rut = f7_.faculty_rut LEFT JOIN research_line r6_ ON r6_.id = f7_.research_line_id WHERE f0_.active = 1 LIMIT 10 OFFSET 4520

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT f0_.rut AS rut_0
FROM
  faculty f0_
  LEFT JOIN `user` u1_ ON f0_.user_id = u1_.id
  LEFT JOIN faculty_assignment f2_ ON f0_.rut = f2_.faculty_rut
  LEFT JOIN department d3_ ON f2_.department_id = d3_.id
  LEFT JOIN faculty_research_area f5_ ON f0_.rut = f5_.faculty_rut
  LEFT JOIN research_area r4_ ON r4_.id = f5_.research_area_id
  LEFT JOIN faculty_research_line f7_ ON f0_.rut = f7_.faculty_rut
  LEFT JOIN research_line r6_ ON r6_.id = f7_.research_line_id
WHERE
  f0_.active = 1
LIMIT
  10
OFFSET
  4520

SELECT DISTINCT f0_.rut AS rut_0 FROM faculty f0_ LEFT JOIN `user` u1_ ON f0_.user_id = u1_.id LEFT JOIN faculty_assignment f2_ ON f0_.rut = f2_.faculty_rut LEFT JOIN department d3_ ON f2_.department_id = d3_.id LEFT JOIN faculty_research_area f5_ ON f0_.rut = f5_.faculty_rut LEFT JOIN research_area r4_ ON r4_.id = f5_.research_area_id LEFT JOIN faculty_research_line f7_ ON f0_.rut = f7_.faculty_rut LEFT JOIN research_line r6_ ON r6_.id = f7_.research_line_id WHERE f0_.active = 1 LIMIT 10 OFFSET 4520;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 935)
4	Doctrine\ORM\AbstractQuery->execute (line 891)
5	Doctrine\ORM\AbstractQuery->getScalarResult (line 725)
6	Doctrine\ORM\Tools\Pagination\Paginator->getIterator (line 127)
7	iterator_to_array (line 45)
8	Knp\Component\Pager\Event\Subscriber\Paginate\Doctrine\ORM\QuerySubscriber::items (line 45)
9	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
10	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
11	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
12	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
13	Knp\Component\Pager\Paginator->paginate (line 97)
14	ContainerHOhRH7k\PaginatorProxyBa079e5->paginate (line 20)
15	App\Controller\FacultiesController->index (line 52)
16	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
17	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
18	Symfony\Component\HttpKernel\Kernel->handle (line 182)
19	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
20	require_once (line 29)
21	require_once (line 5)

0.51 ms
(8.79%)

SELECT f0_.rut AS rut_0, f0_.biography AS biography_1, f0_.interest_areas AS interest_areas_2, f0_.english_interest_areas AS english_interest_areas_3, f0_.active AS active_4, f0_.english_bio AS english_bio_5, f0_.user_id AS user_id_6 FROM faculty f0_ INNER JOIN `user` u1_ ON f0_.user_id = u1_.id WHERE f0_.active = 1 ORDER BY u1_.name ASC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  f0_.rut AS rut_0,
  f0_.biography AS biography_1,
  f0_.interest_areas AS interest_areas_2,
  f0_.english_interest_areas AS english_interest_areas_3,
  f0_.active AS active_4,
  f0_.english_bio AS english_bio_5,
  f0_.user_id AS user_id_6
FROM
  faculty f0_
  INNER JOIN `user` u1_ ON f0_.user_id = u1_.id
WHERE
  f0_.active = 1
ORDER BY
  u1_.name ASC

SELECT f0_.rut AS rut_0, f0_.biography AS biography_1, f0_.interest_areas AS interest_areas_2, f0_.english_interest_areas AS english_interest_areas_3, f0_.active AS active_4, f0_.english_bio AS english_bio_5, f0_.user_id AS user_id_6 FROM faculty f0_ INNER JOIN `user` u1_ ON f0_.user_id = u1_.id WHERE f0_.active = 1 ORDER BY u1_.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 935)
4	Doctrine\ORM\AbstractQuery->execute (line 891)
5	Symfony\Bridge\Doctrine\Form\ChoiceList\ORMQueryBuilderLoader->getEntities (line 35)
6	Symfony\Bridge\Doctrine\Form\ChoiceList\DoctrineChoiceLoader->loadChoices (line 53)
7	Symfony\Component\Form\ChoiceList\Loader\AbstractChoiceLoader->loadChoiceList (line 29)
8	Symfony\Component\Form\ChoiceList\LazyChoiceList->getChoices (line 56)
9	Symfony\Component\Form\ChoiceList\Factory\DefaultChoiceListFactory->createView (line 60)
10	Symfony\Component\Form\ChoiceList\Factory\PropertyAccessDecorator->createView (line 178)
11	Symfony\Component\Form\ChoiceList\Factory\CachingFactoryDecorator->createView (line 187)
12	Symfony\Component\Form\Extension\Core\Type\ChoiceType->createChoiceListView (line 479)
13	Symfony\Component\Form\Extension\Core\Type\ChoiceType->buildView (line 234)
14	Symfony\Component\Form\ResolvedFormType->buildView (line 107)
15	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildView (line 78)
16	Symfony\Component\Form\ResolvedFormType->buildView (line 105)
17	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildView (line 78)
18	Symfony\Component\Form\Form->createView (line 888)
19	Symfony\Component\Form\Form->createView (line 891)
20	App\Controller\FacultiesController->index (line 60)
21	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
22	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
23	Symfony\Component\HttpKernel\Kernel->handle (line 182)
24	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
25	require_once (line 29)
26	require_once (line 5)

0.44 ms
(7.63%)

SELECT r0_.id AS id_0, r0_.area AS area_1, r0_.english_name AS english_name_2, r0_.cod_param_77_vig AS cod_param_77_vig_3, r0_.active AS active_4, r0_.cod_curriculum AS cod_curriculum_5 FROM research_area r0_ WHERE r0_.active = 1 AND r0_.id IN (?) ORDER BY r0_.area ASC

Parameters:

[
  "37"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  r0_.id AS id_0,
  r0_.area AS area_1,
  r0_.english_name AS english_name_2,
  r0_.cod_param_77_vig AS cod_param_77_vig_3,
  r0_.active AS active_4,
  r0_.cod_curriculum AS cod_curriculum_5
FROM
  research_area r0_
WHERE
  r0_.active = 1
  AND r0_.id IN (?)
ORDER BY
  r0_.area ASC

SELECT r0_.id AS id_0, r0_.area AS area_1, r0_.english_name AS english_name_2, r0_.cod_param_77_vig AS cod_param_77_vig_3, r0_.active AS active_4, r0_.cod_curriculum AS cod_curriculum_5 FROM research_area r0_ WHERE r0_.active = 1 AND r0_.id IN ('37') ORDER BY r0_.area 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 935)
4	Doctrine\ORM\AbstractQuery->execute (line 891)
5	Doctrine\ORM\AbstractQuery->getResult (line 689)
6	Symfony\Bridge\Doctrine\Form\ChoiceList\ORMQueryBuilderLoader->getEntitiesByIds (line 99)
7	Symfony\Bridge\Doctrine\Form\ChoiceList\DoctrineChoiceLoader->doLoadChoicesForValues (line 92)
8	Symfony\Component\Form\ChoiceList\Loader\AbstractChoiceLoader->loadChoicesForValues (line 38)
9	Symfony\Component\Form\ChoiceList\LazyChoiceList->getChoicesForValues (line 76)
10	Symfony\Component\Form\Extension\Core\DataTransformer\ChoiceToValueTransformer->reverseTransform (line 41)
11	Symfony\Component\Form\Form->viewToNorm (line 1002)
12	Symfony\Component\Form\Form->submit (line 552)
13	Symfony\Component\Form\Form->submit (line 493)
14	Symfony\Component\Form\Extension\HttpFoundation\HttpFoundationRequestHandler->handleRequest (line 107)
15	Symfony\Component\Form\Form->handleRequest (line 414)
16	App\Controller\FacultiesController->index (line 38)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
19	Symfony\Component\HttpKernel\Kernel->handle (line 182)
20	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
21	require_once (line 29)
22	require_once (line 5)

0.39 ms
(6.80%)

SELECT r0_.id AS id_0, r0_.area AS area_1, r0_.english_name AS english_name_2, r0_.cod_param_77_vig AS cod_param_77_vig_3, r0_.active AS active_4, r0_.cod_curriculum AS cod_curriculum_5 FROM research_area r0_ WHERE r0_.active = 1 ORDER BY r0_.area ASC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  r0_.id AS id_0,
  r0_.area AS area_1,
  r0_.english_name AS english_name_2,
  r0_.cod_param_77_vig AS cod_param_77_vig_3,
  r0_.active AS active_4,
  r0_.cod_curriculum AS cod_curriculum_5
FROM
  research_area r0_
WHERE
  r0_.active = 1
ORDER BY
  r0_.area ASC

SELECT r0_.id AS id_0, r0_.area AS area_1, r0_.english_name AS english_name_2, r0_.cod_param_77_vig AS cod_param_77_vig_3, r0_.active AS active_4, r0_.cod_curriculum AS cod_curriculum_5 FROM research_area r0_ WHERE r0_.active = 1 ORDER BY r0_.area 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 935)
4	Doctrine\ORM\AbstractQuery->execute (line 891)
5	Symfony\Bridge\Doctrine\Form\ChoiceList\ORMQueryBuilderLoader->getEntities (line 35)
6	Symfony\Bridge\Doctrine\Form\ChoiceList\DoctrineChoiceLoader->loadChoices (line 53)
7	Symfony\Component\Form\ChoiceList\Loader\AbstractChoiceLoader->loadChoiceList (line 29)
8	Symfony\Component\Form\ChoiceList\LazyChoiceList->getChoices (line 56)
9	Symfony\Component\Form\ChoiceList\Factory\DefaultChoiceListFactory->createView (line 60)
10	Symfony\Component\Form\ChoiceList\Factory\PropertyAccessDecorator->createView (line 178)
11	Symfony\Component\Form\ChoiceList\Factory\CachingFactoryDecorator->createView (line 187)
12	Symfony\Component\Form\Extension\Core\Type\ChoiceType->createChoiceListView (line 479)
13	Symfony\Component\Form\Extension\Core\Type\ChoiceType->buildView (line 234)
14	Symfony\Component\Form\ResolvedFormType->buildView (line 107)
15	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildView (line 78)
16	Symfony\Component\Form\ResolvedFormType->buildView (line 105)
17	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildView (line 78)
18	Symfony\Component\Form\Form->createView (line 888)
19	Symfony\Component\Form\Form->createView (line 891)
20	App\Controller\FacultiesController->index (line 60)
21	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
22	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
23	Symfony\Component\HttpKernel\Kernel->handle (line 182)
24	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
25	require_once (line 29)
26	require_once (line 5)

0.31 ms
(5.42%)

SELECT d0_.id AS id_0, d0_.department AS department_1, d0_.english_name AS english_name_2, d0_.active AS active_3 FROM department d0_ WHERE d0_.active = 1 ORDER BY d0_.department ASC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  d0_.id AS id_0,
  d0_.department AS department_1,
  d0_.english_name AS english_name_2,
  d0_.active AS active_3
FROM
  department d0_
WHERE
  d0_.active = 1
ORDER BY
  d0_.department ASC

SELECT d0_.id AS id_0, d0_.department AS department_1, d0_.english_name AS english_name_2, d0_.active AS active_3 FROM department d0_ WHERE d0_.active = 1 ORDER BY d0_.department 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 935)
4	Doctrine\ORM\AbstractQuery->execute (line 891)
5	Symfony\Bridge\Doctrine\Form\ChoiceList\ORMQueryBuilderLoader->getEntities (line 35)
6	Symfony\Bridge\Doctrine\Form\ChoiceList\DoctrineChoiceLoader->loadChoices (line 53)
7	Symfony\Component\Form\ChoiceList\Loader\AbstractChoiceLoader->loadChoiceList (line 29)
8	Symfony\Component\Form\ChoiceList\LazyChoiceList->getChoices (line 56)
9	Symfony\Component\Form\ChoiceList\Factory\DefaultChoiceListFactory->createView (line 60)
10	Symfony\Component\Form\ChoiceList\Factory\PropertyAccessDecorator->createView (line 178)
11	Symfony\Component\Form\ChoiceList\Factory\CachingFactoryDecorator->createView (line 187)
12	Symfony\Component\Form\Extension\Core\Type\ChoiceType->createChoiceListView (line 479)
13	Symfony\Component\Form\Extension\Core\Type\ChoiceType->buildView (line 234)
14	Symfony\Component\Form\ResolvedFormType->buildView (line 107)
15	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildView (line 78)
16	Symfony\Component\Form\ResolvedFormType->buildView (line 105)
17	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildView (line 78)
18	Symfony\Component\Form\Form->createView (line 888)
19	Symfony\Component\Form\Form->createView (line 891)
20	App\Controller\FacultiesController->index (line 60)
21	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
22	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
23	Symfony\Component\HttpKernel\Kernel->handle (line 182)
24	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
25	require_once (line 29)
26	require_once (line 5)

0.30 ms
(5.24%)

SELECT r0_.id AS id_0, r0_.line AS line_1, r0_.english_name AS english_name_2, r0_.description AS description_3, r0_.active AS active_4, r0_.area_id AS area_id_5, r0_.department_id AS department_id_6 FROM research_line r0_ WHERE r0_.active = 1 ORDER BY r0_.line ASC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  r0_.id AS id_0,
  r0_.line AS line_1,
  r0_.english_name AS english_name_2,
  r0_.description AS description_3,
  r0_.active AS active_4,
  r0_.area_id AS area_id_5,
  r0_.department_id AS department_id_6
FROM
  research_line r0_
WHERE
  r0_.active = 1
ORDER BY
  r0_.line ASC

SELECT r0_.id AS id_0, r0_.line AS line_1, r0_.english_name AS english_name_2, r0_.description AS description_3, r0_.active AS active_4, r0_.area_id AS area_id_5, r0_.department_id AS department_id_6 FROM research_line r0_ WHERE r0_.active = 1 ORDER BY r0_.line 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 935)
4	Doctrine\ORM\AbstractQuery->execute (line 891)
5	Symfony\Bridge\Doctrine\Form\ChoiceList\ORMQueryBuilderLoader->getEntities (line 35)
6	Symfony\Bridge\Doctrine\Form\ChoiceList\DoctrineChoiceLoader->loadChoices (line 53)
7	Symfony\Component\Form\ChoiceList\Loader\AbstractChoiceLoader->loadChoiceList (line 29)
8	Symfony\Component\Form\ChoiceList\LazyChoiceList->getChoices (line 56)
9	Symfony\Component\Form\ChoiceList\Factory\DefaultChoiceListFactory->createView (line 60)
10	Symfony\Component\Form\ChoiceList\Factory\PropertyAccessDecorator->createView (line 178)
11	Symfony\Component\Form\ChoiceList\Factory\CachingFactoryDecorator->createView (line 187)
12	Symfony\Component\Form\Extension\Core\Type\ChoiceType->createChoiceListView (line 479)
13	Symfony\Component\Form\Extension\Core\Type\ChoiceType->buildView (line 234)
14	Symfony\Component\Form\ResolvedFormType->buildView (line 107)
15	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildView (line 78)
16	Symfony\Component\Form\ResolvedFormType->buildView (line 105)
17	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildView (line 78)
18	Symfony\Component\Form\Form->createView (line 888)
19	Symfony\Component\Form\Form->createView (line 891)
20	App\Controller\FacultiesController->index (line 60)
21	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
22	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
23	Symfony\Component\HttpKernel\Kernel->handle (line 182)
24	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
25	require_once (line 29)
26	require_once (line 5)

0.28 ms
(4.86%)

SELECT c0_.codCurriculum AS codCurriculum_0, c0_.nom_curriculum AS nom_curriculum_1, c0_.active AS active_2, c0_.nom_curriculum_english AS nom_curriculum_english_3 FROM cod_curriculum c0_ WHERE c0_.active = 1 ORDER BY c0_.nom_curriculum ASC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  c0_.codCurriculum AS codCurriculum_0,
  c0_.nom_curriculum AS nom_curriculum_1,
  c0_.active AS active_2,
  c0_.nom_curriculum_english AS nom_curriculum_english_3
FROM
  cod_curriculum c0_
WHERE
  c0_.active = 1
ORDER BY
  c0_.nom_curriculum ASC

SELECT c0_.codCurriculum AS codCurriculum_0, c0_.nom_curriculum AS nom_curriculum_1, c0_.active AS active_2, c0_.nom_curriculum_english AS nom_curriculum_english_3 FROM cod_curriculum c0_ WHERE c0_.active = 1 ORDER BY c0_.nom_curriculum 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 935)
4	Doctrine\ORM\AbstractQuery->execute (line 891)
5	Symfony\Bridge\Doctrine\Form\ChoiceList\ORMQueryBuilderLoader->getEntities (line 35)
6	Symfony\Bridge\Doctrine\Form\ChoiceList\DoctrineChoiceLoader->loadChoices (line 53)
7	Symfony\Component\Form\ChoiceList\Loader\AbstractChoiceLoader->loadChoiceList (line 29)
8	Symfony\Component\Form\ChoiceList\LazyChoiceList->getChoices (line 56)
9	Symfony\Component\Form\ChoiceList\Factory\DefaultChoiceListFactory->createView (line 60)
10	Symfony\Component\Form\ChoiceList\Factory\PropertyAccessDecorator->createView (line 178)
11	Symfony\Component\Form\ChoiceList\Factory\CachingFactoryDecorator->createView (line 187)
12	Symfony\Component\Form\Extension\Core\Type\ChoiceType->createChoiceListView (line 479)
13	Symfony\Component\Form\Extension\Core\Type\ChoiceType->buildView (line 234)
14	Symfony\Component\Form\ResolvedFormType->buildView (line 107)
15	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildView (line 78)
16	Symfony\Component\Form\ResolvedFormType->buildView (line 105)
17	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildView (line 78)
18	Symfony\Component\Form\Form->createView (line 888)
19	Symfony\Component\Form\Form->createView (line 891)
20	App\Controller\FacultiesController->index (line 60)
21	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
22	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
23	Symfony\Component\HttpKernel\Kernel->handle (line 182)
24	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
25	require_once (line 29)
26	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

Entities Mapping

Class	Mapping errors
App\Entity\Faculty	No errors.
App\Entity\User	No errors.
App\Entity\Department	No errors.
App\Entity\ResearchArea	No errors.
App\Entity\CodCurriculum	No errors.
App\Entity\ResearchLine	No errors.
App\Entity\FacultyAssignment	No errors.

Symfony Profiler

GET https://oportunidadespostgrado-test.ing.uc.cl/es/faculties?faculty_filter%5BCodCurriculum%5D=40201&faculty_filter%5Barea%5D=37&page=453

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping