Symfony Profiler

Query Metrics

7 Database Queries

7 Different statements

3.70 ms Query time

1 Invalid entities

20 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

0.88 ms
(23.78%)

SELECT count(DISTINCT o0_.id) AS sclr_0 FROM opportunity o0_ LEFT JOIN faculty f1_ ON o0_.faculty_rut = f1_.rut LEFT JOIN opportunity_research_line o3_ ON o0_.id = o3_.opportunity_id LEFT JOIN research_line r2_ ON r2_.id = o3_.research_line_id LEFT JOIN research_area r4_ ON r2_.area_id = r4_.id LEFT JOIN cod_curriculum c5_ ON r4_.cod_curriculum = c5_.codCurriculum LEFT JOIN opportunity_keyword o7_ ON o0_.id = o7_.opportunity_id LEFT JOIN keyword k6_ ON k6_.id = o7_.keyword_id LEFT JOIN status s8_ ON o0_.status_id = s8_.id WHERE f1_.active = 1 AND o0_.status_id IN (?, ?)

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  count(DISTINCT o0_.id) AS sclr_0
FROM
  opportunity o0_
  LEFT JOIN faculty f1_ ON o0_.faculty_rut = f1_.rut
  LEFT JOIN opportunity_research_line o3_ ON o0_.id = o3_.opportunity_id
  LEFT JOIN research_line r2_ ON r2_.id = o3_.research_line_id
  LEFT JOIN research_area r4_ ON r2_.area_id = r4_.id
  LEFT JOIN cod_curriculum c5_ ON r4_.cod_curriculum = c5_.codCurriculum
  LEFT JOIN opportunity_keyword o7_ ON o0_.id = o7_.opportunity_id
  LEFT JOIN keyword k6_ ON k6_.id = o7_.keyword_id
  LEFT JOIN status s8_ ON o0_.status_id = s8_.id
WHERE
  f1_.active = 1
  AND o0_.status_id IN (?, ?)

SELECT count(DISTINCT o0_.id) AS sclr_0 FROM opportunity o0_ LEFT JOIN faculty f1_ ON o0_.faculty_rut = f1_.rut LEFT JOIN opportunity_research_line o3_ ON o0_.id = o3_.opportunity_id LEFT JOIN research_line r2_ ON r2_.id = o3_.research_line_id LEFT JOIN research_area r4_ ON r2_.area_id = r4_.id LEFT JOIN cod_curriculum c5_ ON r4_.cod_curriculum = c5_.codCurriculum LEFT JOIN opportunity_keyword o7_ ON o0_.id = o7_.opportunity_id LEFT JOIN keyword k6_ ON k6_.id = o7_.keyword_id LEFT JOIN status s8_ ON o0_.status_id = s8_.id WHERE f1_.active = 1 AND o0_.status_id IN (1, 2);

#	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	ContainerXdHsyRZ\PaginatorProxyBa079e5->paginate (line 20)
15	App\Controller\HomeController->index (line 54)
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.79 ms
(21.42%)

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\HomeController->index (line 73)
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.78 ms
(21.04%)

SELECT DISTINCT o0_.id AS id_0, o0_.status_id AS sclr_1, o0_.creation_date AS creation_date_2 FROM opportunity o0_ LEFT JOIN faculty f1_ ON o0_.faculty_rut = f1_.rut LEFT JOIN opportunity_research_line o3_ ON o0_.id = o3_.opportunity_id LEFT JOIN research_line r2_ ON r2_.id = o3_.research_line_id LEFT JOIN research_area r4_ ON r2_.area_id = r4_.id LEFT JOIN cod_curriculum c5_ ON r4_.cod_curriculum = c5_.codCurriculum LEFT JOIN opportunity_keyword o7_ ON o0_.id = o7_.opportunity_id LEFT JOIN keyword k6_ ON k6_.id = o7_.keyword_id LEFT JOIN status s8_ ON o0_.status_id = s8_.id WHERE f1_.active = 1 AND o0_.status_id IN (?, ?) ORDER BY o0_.status_id ASC, o0_.creation_date DESC LIMIT 9

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT o0_.id AS id_0,
  o0_.status_id AS sclr_1,
  o0_.creation_date AS creation_date_2
FROM
  opportunity o0_
  LEFT JOIN faculty f1_ ON o0_.faculty_rut = f1_.rut
  LEFT JOIN opportunity_research_line o3_ ON o0_.id = o3_.opportunity_id
  LEFT JOIN research_line r2_ ON r2_.id = o3_.research_line_id
  LEFT JOIN research_area r4_ ON r2_.area_id = r4_.id
  LEFT JOIN cod_curriculum c5_ ON r4_.cod_curriculum = c5_.codCurriculum
  LEFT JOIN opportunity_keyword o7_ ON o0_.id = o7_.opportunity_id
  LEFT JOIN keyword k6_ ON k6_.id = o7_.keyword_id
  LEFT JOIN status s8_ ON o0_.status_id = s8_.id
WHERE
  f1_.active = 1
  AND o0_.status_id IN (?, ?)
ORDER BY
  o0_.status_id ASC,
  o0_.creation_date DESC
LIMIT
  9

SELECT DISTINCT o0_.id AS id_0, o0_.status_id AS sclr_1, o0_.creation_date AS creation_date_2 FROM opportunity o0_ LEFT JOIN faculty f1_ ON o0_.faculty_rut = f1_.rut LEFT JOIN opportunity_research_line o3_ ON o0_.id = o3_.opportunity_id LEFT JOIN research_line r2_ ON r2_.id = o3_.research_line_id LEFT JOIN research_area r4_ ON r2_.area_id = r4_.id LEFT JOIN cod_curriculum c5_ ON r4_.cod_curriculum = c5_.codCurriculum LEFT JOIN opportunity_keyword o7_ ON o0_.id = o7_.opportunity_id LEFT JOIN keyword k6_ ON k6_.id = o7_.keyword_id LEFT JOIN status s8_ ON o0_.status_id = s8_.id WHERE f1_.active = 1 AND o0_.status_id IN (1, 2) ORDER BY o0_.status_id ASC, o0_.creation_date DESC LIMIT 9;

#	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	ContainerXdHsyRZ\PaginatorProxyBa079e5->paginate (line 20)
15	App\Controller\HomeController->index (line 54)
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.42 ms
(11.36%)

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\HomeController->index (line 73)
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.34 ms
(9.20%)

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_english 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_english 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_english 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\HomeController->index (line 73)
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.25 ms
(6.66%)

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\HomeController->index (line 73)
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.24 ms
(6.55%)

SELECT s0_.id AS id_0, s0_.status AS status_1, s0_.english AS english_2 FROM status s0_ WHERE s0_.status IN (?, ?) ORDER BY s0_.status ASC

Parameters:

[
  "Abierta"
  "Cerrada"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  s0_.id AS id_0,
  s0_.status AS status_1,
  s0_.english AS english_2
FROM
  status s0_
WHERE
  s0_.status IN (?, ?)
ORDER BY
  s0_.status ASC

SELECT s0_.id AS id_0, s0_.status AS status_1, s0_.english AS english_2 FROM status s0_ WHERE s0_.status IN ('Abierta', 'Cerrada') ORDER BY s0_.status 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\HomeController->index (line 73)
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
App\Entity\ResearchArea	17
App\Entity\CodCurriculum	3

Entities Mapping

Class	Mapping errors
App\Entity\Faculty	No errors.
App\Entity\User	No errors.
App\Entity\CodCurriculum	No errors.
App\Entity\ResearchArea	No errors.
App\Entity\ResearchLine	No errors.
App\Entity\Department	No errors.
App\Entity\Status	No errors.
App\Entity\Opportunity	The mappings App\Entity\Opportunity#researchAreas and App\Entity\ResearchArea#opportunities are inconsistent with each other.
App\Entity\Keyword	No errors.

Symfony Profiler

GET https://146.155.173.135/es/

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping