Symfony Profiler

Query Metrics

5 Database Queries

3 Different statements

2.00 ms Query time

1 Invalid entities

21 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

0.80 ms
(40.09%)

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.biography AS biography_19, t17.interest_areas AS interest_areas_20, t17.english_interest_areas AS english_interest_areas_21, t17.active AS active_22, t17.english_bio AS english_bio_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:

[
  1
]

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.biography AS biography_19,
  t17.interest_areas AS interest_areas_20,
  t17.english_interest_areas AS english_interest_areas_21,
  t17.active AS active_22,
  t17.english_bio AS english_bio_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.biography AS biography_19, t17.interest_areas AS interest_areas_20, t17.english_interest_areas AS english_interest_areas_21, t17.active AS active_22, t17.english_bio AS english_bio_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 = 1;

#	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\Security\User\EntityUserProvider->refreshUser (line 92)
7	Symfony\Component\Security\Http\Firewall\ContextListener->refreshUser (line 212)
8	Symfony\Component\Security\Http\Firewall\ContextListener->authenticate (line 129)
9	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 46)
10	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->{closure:Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext::__invoke():71} (line 74)
11	Symfony\Component\Security\Core\Authentication\Token\Storage\TokenStorage->getToken (line 34)
12	Symfony\Component\Security\Core\Authentication\Token\Storage\UsageTrackingTokenStorage->getToken (line 42)
13	Symfony\Component\Security\Core\Authorization\AuthorizationChecker->isGranted (line 41)
14	Symfony\Component\Security\Http\EventListener\IsGrantedAttributeListener->onKernelControllerArguments (line 64)
15	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
16	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
17	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
18	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
19	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 178)
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.74 ms
(36.95%)

SELECT t0.codCurriculum AS codCurriculum_1, t0.nom_curriculum AS nom_curriculum_2, t0.active AS active_3, t0.nom_curriculum_english AS nom_curriculum_english_4 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,
  t0.active AS active_3,
  t0.nom_curriculum_english AS nom_curriculum_english_4
FROM
  cod_curriculum t0
WHERE
  t0.codCurriculum = ?

SELECT t0.codCurriculum AS codCurriculum_1, t0.nom_curriculum AS nom_curriculum_2, t0.active AS active_3, t0.nom_curriculum_english AS nom_curriculum_english_4 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	App\Entity\CodCurriculum::getNomCurriculum (line 49)
5	App\Entity\CodCurriculum->getCurriculumDinamico (line 117)
6	Twig\Extension\CoreExtension->getAttribute (line 1909)
7	__TwigTemplate_9c14807f0911e3823c8f5f1c2847b5e4::block_body (line 252)
8	Twig\Template->yieldBlock (line 446)
9	__TwigTemplate_e160f62a622d252bcdbb47069ee4a7dc->doDisplay (line 958)
10	Twig\Template->yield (line 402)
11	__TwigTemplate_9c14807f0911e3823c8f5f1c2847b5e4->doDisplay (line 55)
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\Admin\ResearchAreaController->index (line 44)
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.46 ms
(22.97%)

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 = ? ORDER BY r0_.area ASC

Parameters:

[
  1
]

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 = ?
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	Doctrine\ORM\AbstractQuery->getResult (line 689)
6	App\Controller\Admin\ResearchAreaController->index (line 45)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
9	Symfony\Component\HttpKernel\Kernel->handle (line 182)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
11	require_once (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.

Managed Entities

default entity manager

Class	Amount of managed objects
App\Entity\ResearchArea	17
App\Entity\CodCurriculum	3
App\Entity\User	1

Entities Mapping

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

Symfony Profiler

GET https://oportunidadespostgrado-test.ing.uc.cl/es/admin/research-area

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping