Symfony Profiler

Query Metrics

11 Database Queries

9 Different statements

4.52 ms Query time

0 Invalid entities

282 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

1.03 ms
(22.69%)

SELECT c0_.CodPais AS CodPais_0, c0_.country AS country_1, c0_.active AS active_2, c0_.cod_a2 AS cod_a2_3 FROM country c0_ ORDER BY c0_.country ASC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  c0_.CodPais AS CodPais_0,
  c0_.country AS country_1,
  c0_.active AS active_2,
  c0_.cod_a2 AS cod_a2_3
FROM
  country c0_
ORDER BY
  c0_.country ASC

SELECT c0_.CodPais AS CodPais_0, c0_.country AS country_1, c0_.active AS active_2, c0_.cod_a2 AS cod_a2_3 FROM country c0_ ORDER BY c0_.country 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\OpportunityController->show (line 128)
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.85 ms
(18.77%)

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.deactivated_notifications AS deactivated_notifications_5, t0.sex AS sex_6, t0.rut AS rut_7, t0.name AS name_8, t0.last_name AS last_name_9, t0.phone AS phone_10, t0.picture AS picture_11, t0.reset_token AS reset_token_12, t0.reset_token_expires_at AS reset_token_expires_at_13, t0.career AS career_14, t0.curriculum AS curriculum_15, t0.other_university AS other_university_16, t17.rut AS rut_18, t17.status AS status_19, t17.post AS post_20, t17.biography AS biography_21, t17.interest_areas AS interest_areas_22, t17.english_interest_areas AS english_interest_areas_23, t17.user_id AS user_id_24, t25.id AS id_26, t25.career AS career_27, t25.curriculum AS curriculum_28, t25.other_university AS other_university_29, t25.user_id AS user_id_30, t25.cod_pais AS cod_pais_31, t25.cod_universidad AS cod_universidad_32, t0.cod_pais AS cod_pais_33, t0.cod_universidad AS cod_universidad_34 FROM `user` t0 LEFT JOIN faculty t17 ON t17.user_id = t0.id LEFT JOIN applicant t25 ON t25.user_id = t0.id WHERE t0.id = ?

Parameters:

[
  2
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.deactivated_notifications AS deactivated_notifications_5,
  t0.sex AS sex_6,
  t0.rut AS rut_7,
  t0.name AS name_8,
  t0.last_name AS last_name_9,
  t0.phone AS phone_10,
  t0.picture AS picture_11,
  t0.reset_token AS reset_token_12,
  t0.reset_token_expires_at AS reset_token_expires_at_13,
  t0.career AS career_14,
  t0.curriculum AS curriculum_15,
  t0.other_university AS other_university_16,
  t17.rut AS rut_18,
  t17.status AS status_19,
  t17.post AS post_20,
  t17.biography AS biography_21,
  t17.interest_areas AS interest_areas_22,
  t17.english_interest_areas AS english_interest_areas_23,
  t17.user_id AS user_id_24,
  t25.id AS id_26,
  t25.career AS career_27,
  t25.curriculum AS curriculum_28,
  t25.other_university AS other_university_29,
  t25.user_id AS user_id_30,
  t25.cod_pais AS cod_pais_31,
  t25.cod_universidad AS cod_universidad_32,
  t0.cod_pais AS cod_pais_33,
  t0.cod_universidad AS cod_universidad_34
FROM
  `user` t0
  LEFT JOIN faculty t17 ON t17.user_id = t0.id
  LEFT JOIN applicant t25 ON t25.user_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.deactivated_notifications AS deactivated_notifications_5, t0.sex AS sex_6, t0.rut AS rut_7, t0.name AS name_8, t0.last_name AS last_name_9, t0.phone AS phone_10, t0.picture AS picture_11, t0.reset_token AS reset_token_12, t0.reset_token_expires_at AS reset_token_expires_at_13, t0.career AS career_14, t0.curriculum AS curriculum_15, t0.other_university AS other_university_16, t17.rut AS rut_18, t17.status AS status_19, t17.post AS post_20, t17.biography AS biography_21, t17.interest_areas AS interest_areas_22, t17.english_interest_areas AS english_interest_areas_23, t17.user_id AS user_id_24, t25.id AS id_26, t25.career AS career_27, t25.curriculum AS curriculum_28, t25.other_university AS other_university_29, t25.user_id AS user_id_30, t25.cod_pais AS cod_pais_31, t25.cod_universidad AS cod_universidad_32, t0.cod_pais AS cod_pais_33, t0.cod_universidad AS cod_universidad_34 FROM `user` t0 LEFT JOIN faculty t17 ON t17.user_id = t0.id LEFT JOIN applicant t25 ON t25.user_id = t0.id WHERE t0.id = 2;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 740)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 758)
3	Doctrine\ORM\Proxy\ProxyFactory->{closure:Doctrine\ORM\Proxy\ProxyFactory::getProxy():211} (line 217)
4	Twig\Extension\CoreExtension::getAttribute (line 1785)
5	__TwigTemplate_cdda9e28a8a2b172039a3a0bdc713088::block_body (line 143)
6	Twig\Template->yieldBlock (line 446)
7	__TwigTemplate_8517ed0a5ba1c059c2894d88fecff6bb->doDisplay (line 653)
8	Twig\Template->yield (line 402)
9	__TwigTemplate_cdda9e28a8a2b172039a3a0bdc713088->doDisplay (line 56)
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 459)
16	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 464)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 278)
18	App\Controller\OpportunityController->show (line 126)
19	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
20	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
21	Symfony\Component\HttpKernel\Kernel->handle (line 182)
22	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
23	require_once (line 29)
24	require_once (line 5)

0.69 ms
(15.28%)

SELECT t0.rut AS rut_1, t0.status AS status_2, t0.post AS post_3, t0.biography AS biography_4, t0.interest_areas AS interest_areas_5, t0.english_interest_areas AS english_interest_areas_6, t0.user_id AS user_id_7 FROM faculty t0 WHERE t0.rut = ?

Parameters:

[
  5122132
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.rut AS rut_1,
  t0.status AS status_2,
  t0.post AS post_3,
  t0.biography AS biography_4,
  t0.interest_areas AS interest_areas_5,
  t0.english_interest_areas AS english_interest_areas_6,
  t0.user_id AS user_id_7
FROM
  faculty t0
WHERE
  t0.rut = ?

SELECT t0.rut AS rut_1, t0.status AS status_2, t0.post AS post_3, t0.biography AS biography_4, t0.interest_areas AS interest_areas_5, t0.english_interest_areas AS english_interest_areas_6, t0.user_id AS user_id_7 FROM faculty t0 WHERE t0.rut = 5122132;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 740)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 758)
3	Doctrine\ORM\Proxy\ProxyFactory->{closure:Doctrine\ORM\Proxy\ProxyFactory::getProxy():211} (line 217)
4	Twig\Extension\CoreExtension::getAttribute (line 1785)
5	__TwigTemplate_cdda9e28a8a2b172039a3a0bdc713088::block_body (line 143)
6	Twig\Template->yieldBlock (line 446)
7	__TwigTemplate_8517ed0a5ba1c059c2894d88fecff6bb->doDisplay (line 653)
8	Twig\Template->yield (line 402)
9	__TwigTemplate_cdda9e28a8a2b172039a3a0bdc713088->doDisplay (line 56)
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 459)
16	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 464)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 278)
18	App\Controller\OpportunityController->show (line 126)
19	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
20	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
21	Symfony\Component\HttpKernel\Kernel->handle (line 182)
22	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
23	require_once (line 29)
24	require_once (line 5)

0.61 ms
(13.38%)

SELECT t0.id AS id_1, t0.creation_date AS creation_date_2, t0.title AS title_3, t0.english_title AS english_title_4, t0.description AS description_5, t0.english_description AS english_description_6, t0.total_slots AS total_slots_7, t0.picture AS picture_8, t0.published_deadline AS published_deadline_9, t0.faculty_rut AS faculty_rut_10, t0.second_faculty_rut AS second_faculty_rut_11, t0.status_id AS status_id_12, t0.cod_curriculum_id AS cod_curriculum_id_13, t0.created_by_admin_id AS created_by_admin_id_14 FROM opportunity t0 WHERE t0.id = ?

Parameters:

[
  "3"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.creation_date AS creation_date_2,
  t0.title AS title_3,
  t0.english_title AS english_title_4,
  t0.description AS description_5,
  t0.english_description AS english_description_6,
  t0.total_slots AS total_slots_7,
  t0.picture AS picture_8,
  t0.published_deadline AS published_deadline_9,
  t0.faculty_rut AS faculty_rut_10,
  t0.second_faculty_rut AS second_faculty_rut_11,
  t0.status_id AS status_id_12,
  t0.cod_curriculum_id AS cod_curriculum_id_13,
  t0.created_by_admin_id AS created_by_admin_id_14
FROM
  opportunity t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.creation_date AS creation_date_2, t0.title AS title_3, t0.english_title AS english_title_4, t0.description AS description_5, t0.english_description AS english_description_6, t0.total_slots AS total_slots_7, t0.picture AS picture_8, t0.published_deadline AS published_deadline_9, t0.faculty_rut AS faculty_rut_10, t0.second_faculty_rut AS second_faculty_rut_11, t0.status_id AS status_id_12, t0.cod_curriculum_id AS cod_curriculum_id_13, t0.created_by_admin_id AS created_by_admin_id_14 FROM opportunity t0 WHERE t0.id = '3';

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 740)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 758)
3	Doctrine\ORM\EntityManager->find (line 366)
4	Doctrine\ORM\EntityRepository->find (line 86)
5	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->find (line 61)
6	Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->find (line 129)
7	Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->resolve (line 69)
8	Symfony\Component\HttpKernel\Controller\ArgumentResolver\TraceableValueResolver->resolve (line 37)
9	Symfony\Component\HttpKernel\Controller\ArgumentResolver->getArguments (line 91)
10	Symfony\Component\HttpKernel\Controller\TraceableArgumentResolver->getArguments (line 33)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 175)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
13	Symfony\Component\HttpKernel\Kernel->handle (line 182)
14	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
15	require_once (line 29)
16	require_once (line 5)

0.32 ms
(7.08%)

SELECT t0.id AS id_1, t0.line AS line_2, t0.english_name AS english_name_3, t0.description AS description_4, t0.area_id AS area_id_5, t0.department_id AS department_id_6 FROM research_line t0 INNER JOIN opportunity_research_line ON t0.id = opportunity_research_line.research_line_id WHERE opportunity_research_line.opportunity_id = ?

Parameters:

[
  3
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.line AS line_2,
  t0.english_name AS english_name_3,
  t0.description AS description_4,
  t0.area_id AS area_id_5,
  t0.department_id AS department_id_6
FROM
  research_line t0
  INNER JOIN opportunity_research_line ON t0.id = opportunity_research_line.research_line_id
WHERE
  opportunity_research_line.opportunity_id = ?

SELECT t0.id AS id_1, t0.line AS line_2, t0.english_name AS english_name_3, t0.description AS description_4, t0.area_id AS area_id_5, t0.department_id AS department_id_6 FROM research_line t0 INNER JOIN opportunity_research_line ON t0.id = opportunity_research_line.research_line_id WHERE opportunity_research_line.opportunity_id = 3;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getManyToManyStatement (line 1085)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadManyToManyCollection (line 1014)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2726)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 313)
7	__TwigTemplate_cdda9e28a8a2b172039a3a0bdc713088->block_body (line 247)
8	Twig\Template->yieldBlock (line 446)
9	__TwigTemplate_8517ed0a5ba1c059c2894d88fecff6bb->doDisplay (line 653)
10	Twig\Template->yield (line 402)
11	__TwigTemplate_cdda9e28a8a2b172039a3a0bdc713088->doDisplay (line 56)
12	Twig\Template->yield (line 402)
13	Twig\Template->display (line 358)
14	Twig\Template->render (line 373)
15	Twig\TemplateWrapper->render (line 51)
16	Twig\Environment->render (line 333)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 459)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 464)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 278)
20	App\Controller\OpportunityController->show (line 126)
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.32 ms
(7.05%)

SELECT t0.codCurriculum AS codCurriculum_1, t0.nom_curriculum AS nom_curriculum_2 FROM cod_curriculum t0 WHERE t0.codCurriculum = ?

Parameters:

[
  40201
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.codCurriculum AS codCurriculum_1,
  t0.nom_curriculum AS nom_curriculum_2
FROM
  cod_curriculum t0
WHERE
  t0.codCurriculum = ?

SELECT t0.codCurriculum AS codCurriculum_1, t0.nom_curriculum AS nom_curriculum_2 FROM cod_curriculum t0 WHERE t0.codCurriculum = 40201;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 740)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 758)
3	Doctrine\ORM\Proxy\ProxyFactory->{closure:Doctrine\ORM\Proxy\ProxyFactory::getProxy():211} (line 217)
4	Twig\Extension\CoreExtension::getAttribute (line 1785)
5	__TwigTemplate_cdda9e28a8a2b172039a3a0bdc713088::block_body (line 215)
6	Twig\Template->yieldBlock (line 446)
7	__TwigTemplate_8517ed0a5ba1c059c2894d88fecff6bb->doDisplay (line 653)
8	Twig\Template->yield (line 402)
9	__TwigTemplate_cdda9e28a8a2b172039a3a0bdc713088->doDisplay (line 56)
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 459)
16	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 464)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 278)
18	App\Controller\OpportunityController->show (line 126)
19	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
20	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
21	Symfony\Component\HttpKernel\Kernel->handle (line 182)
22	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
23	require_once (line 29)
24	require_once (line 5)

0.29 ms
(6.50%)

SELECT t0.id AS id_1, t0.keyword AS keyword_2 FROM keyword t0 INNER JOIN opportunity_keyword ON t0.id = opportunity_keyword.keyword_id WHERE opportunity_keyword.opportunity_id = ?

Parameters:

[
  3
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.keyword AS keyword_2
FROM
  keyword t0
  INNER JOIN opportunity_keyword ON t0.id = opportunity_keyword.keyword_id
WHERE
  opportunity_keyword.opportunity_id = ?

SELECT t0.id AS id_1, t0.keyword AS keyword_2 FROM keyword t0 INNER JOIN opportunity_keyword ON t0.id = opportunity_keyword.keyword_id WHERE opportunity_keyword.opportunity_id = 3;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getManyToManyStatement (line 1085)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadManyToManyCollection (line 1014)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2726)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 313)
7	__TwigTemplate_cdda9e28a8a2b172039a3a0bdc713088->block_body (line 284)
8	Twig\Template->yieldBlock (line 446)
9	__TwigTemplate_8517ed0a5ba1c059c2894d88fecff6bb->doDisplay (line 653)
10	Twig\Template->yield (line 402)
11	__TwigTemplate_cdda9e28a8a2b172039a3a0bdc713088->doDisplay (line 56)
12	Twig\Template->yield (line 402)
13	Twig\Template->display (line 358)
14	Twig\Template->render (line 373)
15	Twig\TemplateWrapper->render (line 51)
16	Twig\Environment->render (line 333)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 459)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 464)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 278)
20	App\Controller\OpportunityController->show (line 126)
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
(5.22%)

SELECT t0.id AS id_1, t0.area AS area_2, t0.english_name AS english_name_3, t0.cod_param_77_vig AS cod_param_77_vig_4, t0.cod_curriculum AS cod_curriculum_5 FROM research_area t0 WHERE t0.id = ?

Parameters:

[
  7
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.area AS area_2,
  t0.english_name AS english_name_3,
  t0.cod_param_77_vig AS cod_param_77_vig_4,
  t0.cod_curriculum AS cod_curriculum_5
FROM
  research_area t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.area AS area_2, t0.english_name AS english_name_3, t0.cod_param_77_vig AS cod_param_77_vig_4, t0.cod_curriculum AS cod_curriculum_5 FROM research_area t0 WHERE t0.id = 7;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 740)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 758)
3	Doctrine\ORM\Proxy\ProxyFactory->{closure:Doctrine\ORM\Proxy\ProxyFactory::getProxy():211} (line 217)
4	Twig\Extension\CoreExtension::getAttribute (line 1785)
5	__TwigTemplate_cdda9e28a8a2b172039a3a0bdc713088::block_body (line 250)
6	Twig\Template->yieldBlock (line 446)
7	__TwigTemplate_8517ed0a5ba1c059c2894d88fecff6bb->doDisplay (line 653)
8	Twig\Template->yield (line 402)
9	__TwigTemplate_cdda9e28a8a2b172039a3a0bdc713088->doDisplay (line 56)
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 459)
16	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 464)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 278)
18	App\Controller\OpportunityController->show (line 126)
19	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
20	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
21	Symfony\Component\HttpKernel\Kernel->handle (line 182)
22	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
23	require_once (line 29)
24	require_once (line 5)

0.18 ms
(4.03%)

SELECT t0.id AS id_1, t0.status AS status_2 FROM status t0 WHERE t0.id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.status AS status_2
FROM
  status t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.status AS status_2 FROM status t0 WHERE t0.id = 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 740)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 758)
3	Doctrine\ORM\Proxy\ProxyFactory->{closure:Doctrine\ORM\Proxy\ProxyFactory::getProxy():211} (line 217)
4	App\Entity\Status::__toString (line 83)
5	__TwigTemplate_cdda9e28a8a2b172039a3a0bdc713088->block_body (line 303)
6	Twig\Template->yieldBlock (line 446)
7	__TwigTemplate_8517ed0a5ba1c059c2894d88fecff6bb->doDisplay (line 653)
8	Twig\Template->yield (line 402)
9	__TwigTemplate_cdda9e28a8a2b172039a3a0bdc713088->doDisplay (line 56)
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 459)
16	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 464)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 278)
18	App\Controller\OpportunityController->show (line 126)
19	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
20	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
21	Symfony\Component\HttpKernel\Kernel->handle (line 182)
22	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
23	require_once (line 29)
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\Country	271
App\Entity\Faculty	2
App\Entity\User	2
App\Entity\Opportunity	1
App\Entity\Status	1
App\Entity\CodCurriculum	1
App\Entity\ResearchLine	1
App\Entity\ResearchArea	1
App\Entity\Department	1
App\Entity\Keyword	1

Entities Mapping

Class	Mapping errors
App\Entity\Opportunity	No errors.
App\Entity\Faculty	No errors.
App\Entity\Status	No errors.
App\Entity\CodCurriculum	No errors.
App\Entity\User	No errors.
App\Entity\Keyword	No errors.
App\Entity\Application	No errors.
App\Entity\ResearchLine	No errors.
App\Entity\University	No errors.
App\Entity\Country	No errors.
App\Entity\Applicant	No errors.
App\Entity\ResearchArea	No errors.
App\Entity\FacultyAssignment	No errors.
App\Entity\Department	No errors.

Symfony Profiler

GET http://oportunidadespostgrado-test.ing.uc.cl/index.php/opportunity/3

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping