Symfony Profiler

Query Metrics

2 Database Queries

2 Different statements

4.09 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

2.34 ms
(57.22%)

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:

[
  "%Propagation of Electromagnetic and Elastic Waves in Heterogeneous and…%"
]

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 '%Propagation of Electromagnetic and Elastic Waves in Heterogeneous and…%' 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.75 ms
(42.78%)

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:

[
  "%Propagation of Electromagnetic and Elastic Waves in Heterogeneous and…%"
]

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 '%Propagation of Electromagnetic and Elastic Waves in Heterogeneous and…%') 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)

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.

Symfony Profiler

GET https://researching.dev-investigacion.ing.puc.cl/researchline/public?query=Propagation%20of%20Electromagnetic%20and%20Elastic%20Waves%20in%20Heterogeneous%20and…

Configuration Settings

Theme