Symfony Profiler

Query Metrics

11 Database Queries

5 Different statements

10.59 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

3.14 ms
(29.69%)

SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, sort_2 FROM (SELECT r0_.id AS id_0, r0_.research_line AS research_line_1, r0_.sort AS sort_2, a1_.id AS id_3, a1_.researcher_id AS researcher_id_4, a1_.daisng_id AS daisng_id_5, a1_.bio AS bio_6, a1_.vigent AS vigent_7 FROM research_line r0_ INNER JOIN author_research_line a2_ ON r0_.id = a2_.research_line_id INNER JOIN author a1_ ON a1_.id = a2_.author_id WHERE a1_.vigent = 1) dctrn_result_inner ORDER BY sort_2 ASC) dctrn_result LIMIT 4 OFFSET 76

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT id_0
FROM
  (
    SELECT
      DISTINCT id_0,
      sort_2
    FROM
      (
        SELECT
          r0_.id AS id_0,
          r0_.research_line AS research_line_1,
          r0_.sort AS sort_2,
          a1_.id AS id_3,
          a1_.researcher_id AS researcher_id_4,
          a1_.daisng_id AS daisng_id_5,
          a1_.bio AS bio_6,
          a1_.vigent AS vigent_7
        FROM
          research_line r0_
          INNER JOIN author_research_line a2_ ON r0_.id = a2_.research_line_id
          INNER JOIN author a1_ ON a1_.id = a2_.author_id
        WHERE
          a1_.vigent = 1
      ) dctrn_result_inner
    ORDER BY
      sort_2 ASC
  ) dctrn_result
LIMIT
  4
OFFSET
  76

SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, sort_2 FROM (SELECT r0_.id AS id_0, r0_.research_line AS research_line_1, r0_.sort AS sort_2, a1_.id AS id_3, a1_.researcher_id AS researcher_id_4, a1_.daisng_id AS daisng_id_5, a1_.bio AS bio_6, a1_.vigent AS vigent_7 FROM research_line r0_ INNER JOIN author_research_line a2_ ON r0_.id = a2_.research_line_id INNER JOIN author a1_ ON a1_.id = a2_.author_id WHERE a1_.vigent = 1) dctrn_result_inner ORDER BY sort_2 ASC) dctrn_result LIMIT 4 OFFSET 76;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 725)
6	Doctrine\ORM\AbstractQuery->getScalarResult (line 127)
7	Doctrine\ORM\Tools\Pagination\Paginator->getIterator (line 177)
8	__TwigTemplate_b8a8f464dcbef828e770e03620d7cb3b->block_body (line 431)
9	Twig\Template->yieldBlock (line 553)
10	__TwigTemplate_121357dfd36ae00b609ce7acee96c7b7->doDisplay (line 387)
11	Twig\Template->yield (line 56)
12	__TwigTemplate_b8a8f464dcbef828e770e03620d7cb3b->doDisplay (line 387)
13	Twig\Template->yield (line 343)
14	Twig\Template->display (line 358)
15	Twig\Template->render (line 51)
16	Twig\TemplateWrapper->render (line 320)
17	Twig\Environment->render (line 431)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 82)
21	App\Controller\ResearchLineController->public_index (line 183)
22	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
23	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
24	Symfony\Component\HttpKernel\Kernel->handle (line 35)
25	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
26	require_once (line 5)

3.03 ms
(28.63%)

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT r0_.id AS id_0, r0_.research_line AS research_line_1, r0_.sort AS sort_2, a1_.id AS id_3, a1_.researcher_id AS researcher_id_4, a1_.daisng_id AS daisng_id_5, a1_.bio AS bio_6, a1_.vigent AS vigent_7 FROM research_line r0_ INNER JOIN author_research_line a2_ ON r0_.id = a2_.research_line_id INNER JOIN author a1_ ON a1_.id = a2_.author_id WHERE a1_.vigent = 1 ORDER BY r0_.sort ASC) dctrn_result) dctrn_table

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(*) AS dctrn_count
FROM
  (
    SELECT
      DISTINCT id_0
    FROM
      (
        SELECT
          r0_.id AS id_0,
          r0_.research_line AS research_line_1,
          r0_.sort AS sort_2,
          a1_.id AS id_3,
          a1_.researcher_id AS researcher_id_4,
          a1_.daisng_id AS daisng_id_5,
          a1_.bio AS bio_6,
          a1_.vigent AS vigent_7
        FROM
          research_line r0_
          INNER JOIN author_research_line a2_ ON r0_.id = a2_.research_line_id
          INNER JOIN author a1_ ON a1_.id = a2_.author_id
        WHERE
          a1_.vigent = 1
        ORDER BY
          r0_.sort ASC
      ) dctrn_result
  ) dctrn_table

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT r0_.id AS id_0, r0_.research_line AS research_line_1, r0_.sort AS sort_2, a1_.id AS id_3, a1_.researcher_id AS researcher_id_4, a1_.daisng_id AS daisng_id_5, a1_.bio AS bio_6, a1_.vigent AS vigent_7 FROM research_line r0_ INNER JOIN author_research_line a2_ ON r0_.id = a2_.research_line_id INNER JOIN author a1_ ON a1_.id = a2_.author_id WHERE a1_.vigent = 1 ORDER BY r0_.sort ASC) dctrn_result) dctrn_table;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 725)
6	Doctrine\ORM\AbstractQuery->getScalarResult (line 96)
7	Doctrine\ORM\Tools\Pagination\Paginator->count (line 85)
8	App\Controller\ResearchLineController->public_index (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require_once (line 5)

1.56 ms
(14.71%)

SELECT t0.id AS id_1, t0.research_line AS research_line_2, t0.sort AS sort_3 FROM research_line t0 INNER JOIN author_research_line ON t0.id = author_research_line.research_line_id WHERE author_research_line.author_id = ?

Parameters:

[
  123
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.research_line AS research_line_2,
  t0.sort AS sort_3
FROM
  research_line t0
  INNER JOIN author_research_line ON t0.id = author_research_line.research_line_id
WHERE
  author_research_line.author_id = ?

SELECT t0.id AS id_1, t0.research_line AS research_line_2, t0.sort AS sort_3 FROM research_line t0 INNER JOIN author_research_line ON t0.id = author_research_line.research_line_id WHERE author_research_line.author_id = 123;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1081)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getManyToManyStatement (line 1010)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadManyToManyCollection (line 2710)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 636)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 186)
6	Doctrine\ORM\PersistentCollection->initialize (line 313)
7	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 721)
8	Twig\Extension\CoreExtension::slice (line 99)
9	__TwigTemplate_411ae289b7e326b328480c98ad7a42d9->doDisplay (line 387)
10	Twig\Template->yield (line 246)
11	__TwigTemplate_b8a8f464dcbef828e770e03620d7cb3b->block_body (line 431)
12	Twig\Template->yieldBlock (line 553)
13	__TwigTemplate_121357dfd36ae00b609ce7acee96c7b7->doDisplay (line 387)
14	Twig\Template->yield (line 56)
15	__TwigTemplate_b8a8f464dcbef828e770e03620d7cb3b->doDisplay (line 387)
16	Twig\Template->yield (line 343)
17	Twig\Template->display (line 358)
18	Twig\Template->render (line 51)
19	Twig\TemplateWrapper->render (line 320)
20	Twig\Environment->render (line 431)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 82)
24	App\Controller\ResearchLineController->public_index (line 183)
25	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
26	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
27	Symfony\Component\HttpKernel\Kernel->handle (line 35)
28	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
29	require_once (line 5)

1.56 ms
(14.70%)

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.name AS name_5, t0.last_name AS last_name_6, t0.rut AS rut_7, t0.sex AS sex_8, t0.photo AS photo_9, t10.id AS id_11, t10.researcher_id AS researcher_id_12, t10.daisng_id AS daisng_id_13, t10.bio AS bio_14, t10.vigent AS vigent_15, t10.user_id AS user_id_16 FROM `user` t0 LEFT JOIN author t10 ON t10.user_id = t0.id WHERE t0.id = ?

Parameters:

[
  121
]

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.name AS name_5,
  t0.last_name AS last_name_6,
  t0.rut AS rut_7,
  t0.sex AS sex_8,
  t0.photo AS photo_9,
  t10.id AS id_11,
  t10.researcher_id AS researcher_id_12,
  t10.daisng_id AS daisng_id_13,
  t10.bio AS bio_14,
  t10.vigent AS vigent_15,
  t10.user_id AS user_id_16
FROM
  `user` t0
  LEFT JOIN author t10 ON t10.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.name AS name_5, t0.last_name AS last_name_6, t0.rut AS rut_7, t0.sex AS sex_8, t0.photo AS photo_9, t10.id AS id_11, t10.researcher_id AS researcher_id_12, t10.daisng_id AS daisng_id_13, t10.bio AS bio_14, t10.vigent AS vigent_15, t10.user_id AS user_id_16 FROM `user` t0 LEFT JOIN author t10 ON t10.user_id = t0.id WHERE t0.id = 121;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 736)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 754)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 220)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 286)
5	Proxies\__CG__\App\Entity\User::Doctrine\ORM\Proxy\{closure} (line 59)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 129)
7	Proxies\__CG__\App\Entity\User->__get (line 189)
8	App\Entity\User->getPhoto (line 1871)
9	Twig\Extension\CoreExtension::getAttribute (line 58)
10	__TwigTemplate_411ae289b7e326b328480c98ad7a42d9->doDisplay (line 387)
11	Twig\Template->yield (line 246)
12	__TwigTemplate_b8a8f464dcbef828e770e03620d7cb3b->block_body (line 431)
13	Twig\Template->yieldBlock (line 553)
14	__TwigTemplate_121357dfd36ae00b609ce7acee96c7b7->doDisplay (line 387)
15	Twig\Template->yield (line 56)
16	__TwigTemplate_b8a8f464dcbef828e770e03620d7cb3b->doDisplay (line 387)
17	Twig\Template->yield (line 343)
18	Twig\Template->display (line 358)
19	Twig\Template->render (line 51)
20	Twig\TemplateWrapper->render (line 320)
21	Twig\Environment->render (line 431)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 82)
25	App\Controller\ResearchLineController->public_index (line 183)
26	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
27	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
28	Symfony\Component\HttpKernel\Kernel->handle (line 35)
29	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
30	require_once (line 5)

1.30 ms
(12.26%)

SELECT r0_.id AS id_0, r0_.research_line AS research_line_1, r0_.sort AS sort_2, a1_.id AS id_3, a1_.researcher_id AS researcher_id_4, a1_.daisng_id AS daisng_id_5, a1_.bio AS bio_6, a1_.vigent AS vigent_7, a1_.user_id AS user_id_8 FROM research_line r0_ INNER JOIN author_research_line a2_ ON r0_.id = a2_.research_line_id INNER JOIN author a1_ ON a1_.id = a2_.author_id WHERE a1_.vigent = 1 AND r0_.id IN (?, ?, ?, ?) ORDER BY r0_.sort ASC

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  r0_.id AS id_0,
  r0_.research_line AS research_line_1,
  r0_.sort AS sort_2,
  a1_.id AS id_3,
  a1_.researcher_id AS researcher_id_4,
  a1_.daisng_id AS daisng_id_5,
  a1_.bio AS bio_6,
  a1_.vigent AS vigent_7,
  a1_.user_id AS user_id_8
FROM
  research_line r0_
  INNER JOIN author_research_line a2_ ON r0_.id = a2_.research_line_id
  INNER JOIN author a1_ ON a1_.id = a2_.author_id
WHERE
  a1_.vigent = 1
  AND r0_.id IN (?, ?, ?, ?)
ORDER BY
  r0_.sort ASC

SELECT r0_.id AS id_0, r0_.research_line AS research_line_1, r0_.sort AS sort_2, a1_.id AS id_3, a1_.researcher_id AS researcher_id_4, a1_.daisng_id AS daisng_id_5, a1_.bio AS bio_6, a1_.vigent AS vigent_7, a1_.user_id AS user_id_8 FROM research_line r0_ INNER JOIN author_research_line a2_ ON r0_.id = a2_.research_line_id INNER JOIN author a1_ ON a1_.id = a2_.author_id WHERE a1_.vigent = 1 AND r0_.id IN (180, 107, 251, 144) ORDER BY r0_.sort ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 689)
6	Doctrine\ORM\AbstractQuery->getResult (line 145)
7	Doctrine\ORM\Tools\Pagination\Paginator->getIterator (line 177)
8	__TwigTemplate_b8a8f464dcbef828e770e03620d7cb3b->block_body (line 431)
9	Twig\Template->yieldBlock (line 553)
10	__TwigTemplate_121357dfd36ae00b609ce7acee96c7b7->doDisplay (line 387)
11	Twig\Template->yield (line 56)
12	__TwigTemplate_b8a8f464dcbef828e770e03620d7cb3b->doDisplay (line 387)
13	Twig\Template->yield (line 343)
14	Twig\Template->display (line 358)
15	Twig\Template->render (line 51)
16	Twig\TemplateWrapper->render (line 320)
17	Twig\Environment->render (line 431)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 82)
21	App\Controller\ResearchLineController->public_index (line 183)
22	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
23	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
24	Symfony\Component\HttpKernel\Kernel->handle (line 35)
25	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (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.

Entities Mapping

Class	Mapping errors
App\Entity\ResearchLine	No errors.
App\Entity\Author	No errors.
App\Entity\User	No errors.
App\Entity\PublicationAuthor	No errors.

Symfony Profiler

GET https://dii-investigacion.ing.uc.cl/index.php/researchline/public?page=20

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping