Symfony Profiler

Query Metrics

5 Database Queries

5 Different statements

6.82 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

2.51 ms
(36.74%)

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:

[
  "%Operation and Planning of Electrical Energy Systems; Cascade Failures in Electrical Power Systems; FACTS and Integration of Wind Generators into Electrical Power Systems%"
]

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 '%Operation and Planning of Electrical Energy Systems; Cascade Failures in Electrical Power Systems; FACTS and Integration of Wind Generators into Electrical Power Systems%' 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.43 ms
(35.62%)

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:

[
  "%Operation and Planning of Electrical Energy Systems; Cascade Failures in Electrical Power Systems; FACTS and Integration of Wind Generators into Electrical Power Systems%"
]

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 '%Operation and Planning of Electrical Energy Systems; Cascade Failures in Electrical Power Systems; FACTS and Integration of Wind Generators into Electrical Power Systems%') 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)

0.82 ms
(12.03%)

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:

[
  "%Operation and Planning of Electrical Energy Systems; Cascade Failures in Electrical Power Systems; FACTS and Integration of Wind Generators into Electrical Power Systems%"
  152
]

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 '%Operation and Planning of Electrical Energy Systems; Cascade Failures in Electrical Power Systems; FACTS and Integration of Wind Generators into Electrical Power Systems%' AND r0_.id IN (152) 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)

0.61 ms
(8.99%)

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:

[
  89
]

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

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

0.45 ms
(6.62%)

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:

[
  90
]

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

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

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/researchline/public?query=Operation%20and%20Planning%20of%20Electrical%20Energy%20Systems%3B%20Cascade%20Failures%20in%20Ele…

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping