Symfony Profiler

Query Metrics

9 Database Queries

5 Different statements

8.48 ms Query time

0 Invalid entities

Show all queries

Time▼

Count

Info

2.33 ms
(27.46%)

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 AND r0_.research_line LIKE ? ORDER BY r0_.sort ASC) dctrn_result) dctrn_table

Parameters:

  0 of 0   
[▼
  "%Operations Research%"
]

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
          AND r0_.research_line LIKE ?
        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 AND r0_.research_line LIKE '%Operations Research%' 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)

2.03 ms
(23.90%)

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 AND r0_.research_line LIKE ?) dctrn_result_inner ORDER BY sort_2 ASC) dctrn_result LIMIT 4

Parameters:

  0 of 0   
[▼
  "%Operations Research%"
]

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
          AND r0_.research_line LIKE ?
      ) dctrn_result_inner
    ORDER BY
      sort_2 ASC
  ) dctrn_result
LIMIT
  4

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 AND r0_.research_line LIKE '%Operations Research%') dctrn_result_inner ORDER BY sort_2 ASC) dctrn_result LIMIT 4;

#	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)

1.58 ms
(18.60%)

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:

  0 of 0   
[▼
  39
]

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

#	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.44 ms
(16.93%)

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:

  0 of 0   
[▼
  38
]

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

#	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.11 ms
(13.12%)

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_.research_line LIKE ? AND r0_.id IN (?, ?) ORDER BY r0_.sort ASC

Parameters:

  0 of 0   
[▼
  "%Operations Research%"
  47
  67
]

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_.research_line LIKE ?
  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_.research_line LIKE '%Operations Research%' AND r0_.id IN (47, 67) 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)

Name	Service
default	doctrine.dbal.default_connection

Name	Service
default	doctrine.orm.default_entity_manager

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://researching.investigacion.ing.uc.cl/index.php/researchline/public?query=Operations%20Research

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping

Symfony Profiler

GET https://researching.investigacion.ing.uc.cl/index.php/researchline/public?query=Operations%20Research

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping