Symfony Profiler

Query Metrics

14 Database Queries

6 Different statements

5.32 ms Query time

0 Invalid entities

6 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

1.34 ms
(25.24%)

SELECT t0.rut AS rut_1, t0.biography AS biography_2, t0.interest_areas AS interest_areas_3, t0.english_interest_areas AS english_interest_areas_4, t0.active AS active_5, t0.english_bio AS english_bio_6, t0.user_id AS user_id_7 FROM faculty t0 WHERE t0.user_id = ?

Parameters:

[
  159
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.rut AS rut_1,
  t0.biography AS biography_2,
  t0.interest_areas AS interest_areas_3,
  t0.english_interest_areas AS english_interest_areas_4,
  t0.active AS active_5,
  t0.english_bio AS english_bio_6,
  t0.user_id AS user_id_7
FROM
  faculty t0
WHERE
  t0.user_id = ?

SELECT t0.rut AS rut_1, t0.biography AS biography_2, t0.interest_areas AS interest_areas_3, t0.english_interest_areas AS english_interest_areas_4, t0.active AS active_5, t0.english_bio AS english_bio_6, t0.user_id AS user_id_7 FROM faculty t0 WHERE t0.user_id = 159;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 740)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToOneEntity (line 839)
3	Doctrine\ORM\UnitOfWork->createEntity (line 2457)
4	Doctrine\ORM\Internal\Hydration\ObjectHydrator->getEntity (line 268)
5	Doctrine\ORM\Internal\Hydration\ObjectHydrator->hydrateRowData (line 495)
6	Doctrine\ORM\Internal\Hydration\ObjectHydrator->hydrateAllData (line 147)
7	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 171)
8	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 948)
9	Doctrine\ORM\AbstractQuery->execute (line 891)
10	Doctrine\ORM\AbstractQuery->getResult (line 689)
11	App\Repository\UserRepository->findByRoles (line 273)
12	App\Controller\Admin\UserController->vincularAdministrativo (line 141)
13	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
14	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
15	Symfony\Component\HttpKernel\Kernel->handle (line 182)
16	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
17	require_once (line 29)
18	require_once (line 5)

1.19 ms
(22.44%)

SELECT t0.id AS id_1, t0.career AS career_2, t0.curriculum AS curriculum_3, t0.other_university AS other_university_4, t0.user_id AS user_id_5, t0.cod_pais AS cod_pais_6, t0.cod_universidad AS cod_universidad_7 FROM applicant t0 WHERE t0.user_id = ?

Parameters:

[
  159
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.career AS career_2,
  t0.curriculum AS curriculum_3,
  t0.other_university AS other_university_4,
  t0.user_id AS user_id_5,
  t0.cod_pais AS cod_pais_6,
  t0.cod_universidad AS cod_universidad_7
FROM
  applicant t0
WHERE
  t0.user_id = ?

SELECT t0.id AS id_1, t0.career AS career_2, t0.curriculum AS curriculum_3, t0.other_university AS other_university_4, t0.user_id AS user_id_5, t0.cod_pais AS cod_pais_6, t0.cod_universidad AS cod_universidad_7 FROM applicant t0 WHERE t0.user_id = 159;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 740)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToOneEntity (line 839)
3	Doctrine\ORM\UnitOfWork->createEntity (line 2457)
4	Doctrine\ORM\Internal\Hydration\ObjectHydrator->getEntity (line 268)
5	Doctrine\ORM\Internal\Hydration\ObjectHydrator->hydrateRowData (line 495)
6	Doctrine\ORM\Internal\Hydration\ObjectHydrator->hydrateAllData (line 147)
7	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 171)
8	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 948)
9	Doctrine\ORM\AbstractQuery->execute (line 891)
10	Doctrine\ORM\AbstractQuery->getResult (line 689)
11	App\Repository\UserRepository->findByRoles (line 273)
12	App\Controller\Admin\UserController->vincularAdministrativo (line 141)
13	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
14	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
15	Symfony\Component\HttpKernel\Kernel->handle (line 182)
16	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
17	require_once (line 29)
18	require_once (line 5)

1.04 ms
(19.66%)

SELECT u0_.id AS id_0, u0_.email AS email_1, u0_.roles AS roles_2, u0_.password AS password_3, u0_.deactivated_notifications AS deactivated_notifications_4, u0_.sex AS sex_5, u0_.rut AS rut_6, u0_.name AS name_7, u0_.last_name AS last_name_8, u0_.phone AS phone_9, u0_.picture AS picture_10, u0_.reset_token AS reset_token_11, u0_.reset_token_expires_at AS reset_token_expires_at_12, u0_.career AS career_13, u0_.curriculum AS curriculum_14, u0_.other_university AS other_university_15, u0_.cod_pais AS cod_pais_16, u0_.cod_universidad AS cod_universidad_17 FROM `user` u0_ WHERE u0_.roles LIKE ? OR u0_.roles LIKE ?

Parameters:

[
  "%"ROLE_ADMINISTRATIVE"%"
  "%"ROLE_OTHER"%"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  u0_.id AS id_0,
  u0_.email AS email_1,
  u0_.roles AS roles_2,
  u0_.password AS password_3,
  u0_.deactivated_notifications AS deactivated_notifications_4,
  u0_.sex AS sex_5,
  u0_.rut AS rut_6,
  u0_.name AS name_7,
  u0_.last_name AS last_name_8,
  u0_.phone AS phone_9,
  u0_.picture AS picture_10,
  u0_.reset_token AS reset_token_11,
  u0_.reset_token_expires_at AS reset_token_expires_at_12,
  u0_.career AS career_13,
  u0_.curriculum AS curriculum_14,
  u0_.other_university AS other_university_15,
  u0_.cod_pais AS cod_pais_16,
  u0_.cod_universidad AS cod_universidad_17
FROM
  `user` u0_
WHERE
  u0_.roles LIKE ?
  OR u0_.roles LIKE ?

SELECT u0_.id AS id_0, u0_.email AS email_1, u0_.roles AS roles_2, u0_.password AS password_3, u0_.deactivated_notifications AS deactivated_notifications_4, u0_.sex AS sex_5, u0_.rut AS rut_6, u0_.name AS name_7, u0_.last_name AS last_name_8, u0_.phone AS phone_9, u0_.picture AS picture_10, u0_.reset_token AS reset_token_11, u0_.reset_token_expires_at AS reset_token_expires_at_12, u0_.career AS career_13, u0_.curriculum AS curriculum_14, u0_.other_university AS other_university_15, u0_.cod_pais AS cod_pais_16, u0_.cod_universidad AS cod_universidad_17 FROM `user` u0_ WHERE u0_.roles LIKE '%\"ROLE_ADMINISTRATIVE\"%' OR u0_.roles LIKE '%\"ROLE_OTHER\"%';

#	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\Repository\UserRepository->findByRoles (line 273)
7	App\Controller\Admin\UserController->vincularAdministrativo (line 141)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 182)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
12	require_once (line 29)
13	require_once (line 5)

0.81 ms
(15.26%)

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.57 ms
(10.72%)

SELECT u0_.id AS id_0, u0_.email AS email_1, u0_.roles AS roles_2, u0_.password AS password_3, u0_.deactivated_notifications AS deactivated_notifications_4, u0_.sex AS sex_5, u0_.rut AS rut_6, u0_.name AS name_7, u0_.last_name AS last_name_8, u0_.phone AS phone_9, u0_.picture AS picture_10, u0_.reset_token AS reset_token_11, u0_.reset_token_expires_at AS reset_token_expires_at_12, u0_.career AS career_13, u0_.curriculum AS curriculum_14, u0_.other_university AS other_university_15, u0_.cod_pais AS cod_pais_16, u0_.cod_universidad AS cod_universidad_17 FROM `user` u0_ INNER JOIN user_assistants u2_ ON u0_.id = u2_.user_target INNER JOIN `user` u1_ ON u1_.id = u2_.user_source

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  u0_.id AS id_0,
  u0_.email AS email_1,
  u0_.roles AS roles_2,
  u0_.password AS password_3,
  u0_.deactivated_notifications AS deactivated_notifications_4,
  u0_.sex AS sex_5,
  u0_.rut AS rut_6,
  u0_.name AS name_7,
  u0_.last_name AS last_name_8,
  u0_.phone AS phone_9,
  u0_.picture AS picture_10,
  u0_.reset_token AS reset_token_11,
  u0_.reset_token_expires_at AS reset_token_expires_at_12,
  u0_.career AS career_13,
  u0_.curriculum AS curriculum_14,
  u0_.other_university AS other_university_15,
  u0_.cod_pais AS cod_pais_16,
  u0_.cod_universidad AS cod_universidad_17
FROM
  `user` u0_
  INNER JOIN user_assistants u2_ ON u0_.id = u2_.user_target
  INNER JOIN `user` u1_ ON u1_.id = u2_.user_source

SELECT u0_.id AS id_0, u0_.email AS email_1, u0_.roles AS roles_2, u0_.password AS password_3, u0_.deactivated_notifications AS deactivated_notifications_4, u0_.sex AS sex_5, u0_.rut AS rut_6, u0_.name AS name_7, u0_.last_name AS last_name_8, u0_.phone AS phone_9, u0_.picture AS picture_10, u0_.reset_token AS reset_token_11, u0_.reset_token_expires_at AS reset_token_expires_at_12, u0_.career AS career_13, u0_.curriculum AS curriculum_14, u0_.other_university AS other_university_15, u0_.cod_pais AS cod_pais_16, u0_.cod_universidad AS cod_universidad_17 FROM `user` u0_ INNER JOIN user_assistants u2_ ON u0_.id = u2_.user_target INNER JOIN `user` u1_ ON u1_.id = u2_.user_source;

#	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\Repository\UserRepository->findUsuariosConProfesoresACargo (line 293)
7	App\Controller\Admin\UserController->vincularAdministrativo (line 143)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 182)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
12	require_once (line 29)
13	require_once (line 5)

0.36 ms
(6.68%)

SELECT u0_.id AS id_0, u0_.email AS email_1, u0_.roles AS roles_2, u0_.password AS password_3, u0_.deactivated_notifications AS deactivated_notifications_4, u0_.sex AS sex_5, u0_.rut AS rut_6, u0_.name AS name_7, u0_.last_name AS last_name_8, u0_.phone AS phone_9, u0_.picture AS picture_10, u0_.reset_token AS reset_token_11, u0_.reset_token_expires_at AS reset_token_expires_at_12, u0_.career AS career_13, u0_.curriculum AS curriculum_14, u0_.other_university AS other_university_15, u0_.cod_pais AS cod_pais_16, u0_.cod_universidad AS cod_universidad_17 FROM `user` u0_ WHERE u0_.roles LIKE ?

Parameters:

[
  "%"ROLE_PROFESSOR"%"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  u0_.id AS id_0,
  u0_.email AS email_1,
  u0_.roles AS roles_2,
  u0_.password AS password_3,
  u0_.deactivated_notifications AS deactivated_notifications_4,
  u0_.sex AS sex_5,
  u0_.rut AS rut_6,
  u0_.name AS name_7,
  u0_.last_name AS last_name_8,
  u0_.phone AS phone_9,
  u0_.picture AS picture_10,
  u0_.reset_token AS reset_token_11,
  u0_.reset_token_expires_at AS reset_token_expires_at_12,
  u0_.career AS career_13,
  u0_.curriculum AS curriculum_14,
  u0_.other_university AS other_university_15,
  u0_.cod_pais AS cod_pais_16,
  u0_.cod_universidad AS cod_universidad_17
FROM
  `user` u0_
WHERE
  u0_.roles LIKE ?

SELECT u0_.id AS id_0, u0_.email AS email_1, u0_.roles AS roles_2, u0_.password AS password_3, u0_.deactivated_notifications AS deactivated_notifications_4, u0_.sex AS sex_5, u0_.rut AS rut_6, u0_.name AS name_7, u0_.last_name AS last_name_8, u0_.phone AS phone_9, u0_.picture AS picture_10, u0_.reset_token AS reset_token_11, u0_.reset_token_expires_at AS reset_token_expires_at_12, u0_.career AS career_13, u0_.curriculum AS curriculum_14, u0_.other_university AS other_university_15, u0_.cod_pais AS cod_pais_16, u0_.cod_universidad AS cod_universidad_17 FROM `user` u0_ WHERE u0_.roles LIKE '%\"ROLE_PROFESSOR\"%';

#	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\Repository\UserRepository->findByRoles (line 273)
7	App\Controller\Admin\UserController->vincularAdministrativo (line 142)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 182)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
12	require_once (line 29)
13	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\User	6

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.

Symfony Profiler

GET https://oportunidadespostgrado-test.ing.uc.cl/es/admin/user/vincular-config

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping