Symfony Profiler

Query Metrics

245 Database Queries

9 Different statements

92.04 ms Query time

0 Invalid entities

604 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

84.29 ms
(91.57%)

237

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:

[
  254
]

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 = 254;

#	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\User::getFullName (line 336)
5	App\Form\OpportunityFilterType->{closure:App\Form\OpportunityFilterType::buildForm():24} (line 25)
6	Symfony\Component\Form\ChoiceList\Factory\DefaultChoiceListFactory->addChoiceView (line 158)
7	Symfony\Component\Form\ChoiceList\Factory\DefaultChoiceListFactory::addChoiceViewsFromStructuredValues (line 233)
8	Symfony\Component\Form\ChoiceList\Factory\DefaultChoiceListFactory::createView (line 123)
9	Symfony\Component\Form\ChoiceList\Factory\PropertyAccessDecorator->createView (line 178)
10	Symfony\Component\Form\ChoiceList\Factory\CachingFactoryDecorator->createView (line 187)
11	Symfony\Component\Form\Extension\Core\Type\ChoiceType->createChoiceListView (line 479)
12	Symfony\Component\Form\Extension\Core\Type\ChoiceType->buildView (line 234)
13	Symfony\Component\Form\ResolvedFormType->buildView (line 107)
14	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildView (line 78)
15	Symfony\Component\Form\ResolvedFormType->buildView (line 105)
16	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildView (line 78)
17	Symfony\Component\Form\Form->createView (line 888)
18	Symfony\Component\Form\Form->createView (line 891)
19	App\Controller\HomeController->index (line 67)
20	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
21	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
22	Symfony\Component\HttpKernel\Kernel->handle (line 182)
23	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
24	require_once (line 29)
25	require_once (line 5)

2.08 ms
(2.26%)

SELECT f0_.rut AS rut_0, f0_.status AS status_1, f0_.post AS post_2, f0_.biography AS biography_3, f0_.interest_areas AS interest_areas_4, f0_.english_interest_areas AS english_interest_areas_5, f0_.user_id AS user_id_6 FROM faculty f0_ INNER JOIN `user` u1_ ON f0_.user_id = u1_.id ORDER BY u1_.name ASC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  f0_.rut AS rut_0,
  f0_.status AS status_1,
  f0_.post AS post_2,
  f0_.biography AS biography_3,
  f0_.interest_areas AS interest_areas_4,
  f0_.english_interest_areas AS english_interest_areas_5,
  f0_.user_id AS user_id_6
FROM
  faculty f0_
  INNER JOIN `user` u1_ ON f0_.user_id = u1_.id
ORDER BY
  u1_.name ASC

SELECT f0_.rut AS rut_0, f0_.status AS status_1, f0_.post AS post_2, f0_.biography AS biography_3, f0_.interest_areas AS interest_areas_4, f0_.english_interest_areas AS english_interest_areas_5, f0_.user_id AS user_id_6 FROM faculty f0_ INNER JOIN `user` u1_ ON f0_.user_id = u1_.id 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 67)
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)

1.26 ms
(1.37%)

SELECT r0_.id AS id_0, r0_.line AS line_1, r0_.english_name AS english_name_2, r0_.description AS description_3, r0_.area_id AS area_id_4, r0_.department_id AS department_id_5 FROM research_line r0_ 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_.area_id AS area_id_4,
  r0_.department_id AS department_id_5
FROM
  research_line r0_
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_.area_id AS area_id_4, r0_.department_id AS department_id_5 FROM research_line r0_ 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 67)
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.97 ms
(1.06%)

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_.cod_curriculum AS cod_curriculum_4 FROM research_area r0_ 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_.cod_curriculum AS cod_curriculum_4
FROM
  research_area r0_
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_.cod_curriculum AS cod_curriculum_4 FROM research_area r0_ 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 67)
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.88 ms
(0.96%)

SELECT s0_.id AS id_0, s0_.status AS status_1 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
FROM
  status s0_
WHERE
  s0_.status IN (?, ?)
ORDER BY
  s0_.status ASC

SELECT s0_.id AS id_0, s0_.status AS status_1 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 67)
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.76 ms
(0.82%)

SELECT c0_.codCurriculum AS codCurriculum_0, c0_.nom_curriculum AS nom_curriculum_1 FROM cod_curriculum c0_ 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
FROM
  cod_curriculum c0_
ORDER BY
  c0_.nom_curriculum ASC

SELECT c0_.codCurriculum AS codCurriculum_0, c0_.nom_curriculum AS nom_curriculum_1 FROM cod_curriculum c0_ 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\HomeController->index (line 67)
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.68 ms
(0.74%)

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 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
  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 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	ContainerNqT9BNg\PaginatorProxyBa079e5->paginate (line 20)
15	App\Controller\HomeController->index (line 48)
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.64 ms
(0.70%)

SELECT o0_.id AS id_0, o0_.creation_date AS creation_date_1, o0_.title AS title_2, o0_.english_title AS english_title_3, o0_.description AS description_4, o0_.english_description AS english_description_5, o0_.total_slots AS total_slots_6, o0_.picture AS picture_7, o0_.published_deadline AS published_deadline_8, f1_.rut AS rut_9, f1_.status AS status_10, f1_.post AS post_11, f1_.biography AS biography_12, f1_.interest_areas AS interest_areas_13, f1_.english_interest_areas AS english_interest_areas_14, r2_.id AS id_15, r2_.line AS line_16, r2_.english_name AS english_name_17, r2_.description AS description_18, r3_.id AS id_19, r3_.area AS area_20, r3_.english_name AS english_name_21, r3_.cod_param_77_vig AS cod_param_77_vig_22, c4_.codCurriculum AS codCurriculum_23, c4_.nom_curriculum AS nom_curriculum_24, k5_.id AS id_25, k5_.keyword AS keyword_26, s6_.id AS id_27, s6_.status AS status_28, o0_.faculty_rut AS faculty_rut_29, o0_.second_faculty_rut AS second_faculty_rut_30, o0_.status_id AS status_id_31, o0_.cod_curriculum_id AS cod_curriculum_id_32, o0_.created_by_admin_id AS created_by_admin_id_33, f1_.user_id AS user_id_34, r2_.area_id AS area_id_35, r2_.department_id AS department_id_36, r3_.cod_curriculum AS cod_curriculum_37 FROM opportunity o0_ LEFT JOIN faculty f1_ ON o0_.faculty_rut = f1_.rut LEFT JOIN opportunity_research_line o7_ ON o0_.id = o7_.opportunity_id LEFT JOIN research_line r2_ ON r2_.id = o7_.research_line_id LEFT JOIN research_area r3_ ON r2_.area_id = r3_.id LEFT JOIN cod_curriculum c4_ ON r3_.cod_curriculum = c4_.codCurriculum LEFT JOIN opportunity_keyword o8_ ON o0_.id = o8_.opportunity_id LEFT JOIN keyword k5_ ON k5_.id = o8_.keyword_id LEFT JOIN status s6_ ON o0_.status_id = s6_.id WHERE o0_.status_id IN (?, ?) AND o0_.id IN (?, ?, ?, ?, ?, ?, ?) ORDER BY o0_.creation_date DESC

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  o0_.id AS id_0,
  o0_.creation_date AS creation_date_1,
  o0_.title AS title_2,
  o0_.english_title AS english_title_3,
  o0_.description AS description_4,
  o0_.english_description AS english_description_5,
  o0_.total_slots AS total_slots_6,
  o0_.picture AS picture_7,
  o0_.published_deadline AS published_deadline_8,
  f1_.rut AS rut_9,
  f1_.status AS status_10,
  f1_.post AS post_11,
  f1_.biography AS biography_12,
  f1_.interest_areas AS interest_areas_13,
  f1_.english_interest_areas AS english_interest_areas_14,
  r2_.id AS id_15,
  r2_.line AS line_16,
  r2_.english_name AS english_name_17,
  r2_.description AS description_18,
  r3_.id AS id_19,
  r3_.area AS area_20,
  r3_.english_name AS english_name_21,
  r3_.cod_param_77_vig AS cod_param_77_vig_22,
  c4_.codCurriculum AS codCurriculum_23,
  c4_.nom_curriculum AS nom_curriculum_24,
  k5_.id AS id_25,
  k5_.keyword AS keyword_26,
  s6_.id AS id_27,
  s6_.status AS status_28,
  o0_.faculty_rut AS faculty_rut_29,
  o0_.second_faculty_rut AS second_faculty_rut_30,
  o0_.status_id AS status_id_31,
  o0_.cod_curriculum_id AS cod_curriculum_id_32,
  o0_.created_by_admin_id AS created_by_admin_id_33,
  f1_.user_id AS user_id_34,
  r2_.area_id AS area_id_35,
  r2_.department_id AS department_id_36,
  r3_.cod_curriculum AS cod_curriculum_37
FROM
  opportunity o0_
  LEFT JOIN faculty f1_ ON o0_.faculty_rut = f1_.rut
  LEFT JOIN opportunity_research_line o7_ ON o0_.id = o7_.opportunity_id
  LEFT JOIN research_line r2_ ON r2_.id = o7_.research_line_id
  LEFT JOIN research_area r3_ ON r2_.area_id = r3_.id
  LEFT JOIN cod_curriculum c4_ ON r3_.cod_curriculum = c4_.codCurriculum
  LEFT JOIN opportunity_keyword o8_ ON o0_.id = o8_.opportunity_id
  LEFT JOIN keyword k5_ ON k5_.id = o8_.keyword_id
  LEFT JOIN status s6_ ON o0_.status_id = s6_.id
WHERE
  o0_.status_id IN (?, ?)
  AND o0_.id IN (?, ?, ?, ?, ?, ?, ?)
ORDER BY
  o0_.creation_date DESC

SELECT o0_.id AS id_0, o0_.creation_date AS creation_date_1, o0_.title AS title_2, o0_.english_title AS english_title_3, o0_.description AS description_4, o0_.english_description AS english_description_5, o0_.total_slots AS total_slots_6, o0_.picture AS picture_7, o0_.published_deadline AS published_deadline_8, f1_.rut AS rut_9, f1_.status AS status_10, f1_.post AS post_11, f1_.biography AS biography_12, f1_.interest_areas AS interest_areas_13, f1_.english_interest_areas AS english_interest_areas_14, r2_.id AS id_15, r2_.line AS line_16, r2_.english_name AS english_name_17, r2_.description AS description_18, r3_.id AS id_19, r3_.area AS area_20, r3_.english_name AS english_name_21, r3_.cod_param_77_vig AS cod_param_77_vig_22, c4_.codCurriculum AS codCurriculum_23, c4_.nom_curriculum AS nom_curriculum_24, k5_.id AS id_25, k5_.keyword AS keyword_26, s6_.id AS id_27, s6_.status AS status_28, o0_.faculty_rut AS faculty_rut_29, o0_.second_faculty_rut AS second_faculty_rut_30, o0_.status_id AS status_id_31, o0_.cod_curriculum_id AS cod_curriculum_id_32, o0_.created_by_admin_id AS created_by_admin_id_33, f1_.user_id AS user_id_34, r2_.area_id AS area_id_35, r2_.department_id AS department_id_36, r3_.cod_curriculum AS cod_curriculum_37 FROM opportunity o0_ LEFT JOIN faculty f1_ ON o0_.faculty_rut = f1_.rut LEFT JOIN opportunity_research_line o7_ ON o0_.id = o7_.opportunity_id LEFT JOIN research_line r2_ ON r2_.id = o7_.research_line_id LEFT JOIN research_area r3_ ON r2_.area_id = r3_.id LEFT JOIN cod_curriculum c4_ ON r3_.cod_curriculum = c4_.codCurriculum LEFT JOIN opportunity_keyword o8_ ON o0_.id = o8_.opportunity_id LEFT JOIN keyword k5_ ON k5_.id = o8_.keyword_id LEFT JOIN status s6_ ON o0_.status_id = s6_.id WHERE o0_.status_id IN (1, 2) AND o0_.id IN (7, 6, 5, 4, 3, 2, 1) ORDER BY o0_.creation_date DESC;

#	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	Doctrine\ORM\Tools\Pagination\Paginator->getIterator (line 145)
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	ContainerNqT9BNg\PaginatorProxyBa079e5->paginate (line 20)
15	App\Controller\HomeController->index (line 48)
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.49 ms
(0.53%)

SELECT DISTINCT o0_.id AS id_0, o0_.creation_date AS creation_date_1 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 o0_.status_id IN (?, ?) ORDER BY 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_.creation_date AS creation_date_1
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
  o0_.status_id IN (?, ?)
ORDER BY
  o0_.creation_date DESC
LIMIT
  9

SELECT DISTINCT o0_.id AS id_0, o0_.creation_date AS creation_date_1 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 o0_.status_id IN (1, 2) ORDER BY 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	ContainerNqT9BNg\PaginatorProxyBa079e5->paginate (line 20)
15	App\Controller\HomeController->index (line 48)
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)

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	238
App\Entity\Faculty	237
App\Entity\ResearchLine	53
App\Entity\ResearchArea	40
App\Entity\Keyword	13
App\Entity\Department	9
App\Entity\Opportunity	7
App\Entity\CodCurriculum	5
App\Entity\Status	2

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	No errors.
App\Entity\Keyword	No errors.
App\Entity\Application	No errors.
App\Entity\FacultyAssignment	No errors.
App\Entity\Applicant	No errors.
App\Entity\Country	No errors.
App\Entity\University	No errors.

Symfony Profiler

GET http://146.155.173.135/

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping