Symfony Profiler

Query Metrics

2 Database Queries

2 Different statements

2.64 ms Query time

0 Invalid entities

0 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

1.51 ms
(57.28%)

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT a0_.id AS id_0, a0_.researcher_id AS researcher_id_1, a0_.daisng_id AS daisng_id_2, a0_.bio AS bio_3, a0_.vigent AS vigent_4 FROM author a0_ INNER JOIN `user` u1_ ON a0_.user_id = u1_.id WHERE a0_.vigent = 1 ORDER BY u1_.name 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
          a0_.id AS id_0,
          a0_.researcher_id AS researcher_id_1,
          a0_.daisng_id AS daisng_id_2,
          a0_.bio AS bio_3,
          a0_.vigent AS vigent_4
        FROM
          author a0_
          INNER JOIN `user` u1_ ON a0_.user_id = u1_.id
        WHERE
          a0_.vigent = 1
        ORDER BY
          u1_.name ASC
      ) dctrn_result
  ) dctrn_table

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT a0_.id AS id_0, a0_.researcher_id AS researcher_id_1, a0_.daisng_id AS daisng_id_2, a0_.bio AS bio_3, a0_.vigent AS vigent_4 FROM author a0_ INNER JOIN `user` u1_ ON a0_.user_id = u1_.id WHERE a0_.vigent = 1 ORDER BY u1_.name ASC) dctrn_result) dctrn_table;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getScalarResult (line 724)
6	Doctrine\ORM\Tools\Pagination\Paginator->count (line 96)
7	App\Controller\AuthorController->index_public (line 87)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 193)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
12	require_once (line 32)
13	require_once (line 5)

1.13 ms
(42.72%)

SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, name_9 FROM (SELECT a0_.id AS id_0, a0_.researcher_id AS researcher_id_1, a0_.daisng_id AS daisng_id_2, a0_.bio AS bio_3, a0_.vigent AS vigent_4, u1_.id AS id_5, u1_.email AS email_6, u1_.roles AS roles_7, u1_.password AS password_8, u1_.name AS name_9, u1_.last_name AS last_name_10, u1_.rut AS rut_11, u1_.sex AS sex_12, u1_.photo AS photo_13 FROM author a0_ INNER JOIN `user` u1_ ON a0_.user_id = u1_.id WHERE a0_.vigent = 1) dctrn_result_inner ORDER BY name_9 ASC) dctrn_result LIMIT 12

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT id_0
FROM
  (
    SELECT
      DISTINCT id_0,
      name_9
    FROM
      (
        SELECT
          a0_.id AS id_0,
          a0_.researcher_id AS researcher_id_1,
          a0_.daisng_id AS daisng_id_2,
          a0_.bio AS bio_3,
          a0_.vigent AS vigent_4,
          u1_.id AS id_5,
          u1_.email AS email_6,
          u1_.roles AS roles_7,
          u1_.password AS password_8,
          u1_.name AS name_9,
          u1_.last_name AS last_name_10,
          u1_.rut AS rut_11,
          u1_.sex AS sex_12,
          u1_.photo AS photo_13
        FROM
          author a0_
          INNER JOIN `user` u1_ ON a0_.user_id = u1_.id
        WHERE
          a0_.vigent = 1
      ) dctrn_result_inner
    ORDER BY
      name_9 ASC
  ) dctrn_result
LIMIT
  12

SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, name_9 FROM (SELECT a0_.id AS id_0, a0_.researcher_id AS researcher_id_1, a0_.daisng_id AS daisng_id_2, a0_.bio AS bio_3, a0_.vigent AS vigent_4, u1_.id AS id_5, u1_.email AS email_6, u1_.roles AS roles_7, u1_.password AS password_8, u1_.name AS name_9, u1_.last_name AS last_name_10, u1_.rut AS rut_11, u1_.sex AS sex_12, u1_.photo AS photo_13 FROM author a0_ INNER JOIN `user` u1_ ON a0_.user_id = u1_.id WHERE a0_.vigent = 1) dctrn_result_inner ORDER BY name_9 ASC) dctrn_result LIMIT 12;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getScalarResult (line 724)
6	Doctrine\ORM\Tools\Pagination\Paginator->getIterator (line 127)
7	__TwigTemplate_7e627cef28ecbb6d60aa805c1f4cd98d->block_body (line 193)
8	Twig\Template->yieldBlock (line 446)
9	__TwigTemplate_38eaba2a0cb85571c2805727c2d60d4a->doDisplay (line 553)
10	Twig\Template->yield (line 402)
11	__TwigTemplate_7e627cef28ecbb6d60aa805c1f4cd98d->doDisplay (line 56)
12	Twig\Template->yield (line 402)
13	Twig\Template->display (line 358)
14	Twig\Template->render (line 373)
15	Twig\TemplateWrapper->render (line 51)
16	Twig\Environment->render (line 333)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
20	App\Controller\AuthorController->index_public (line 84)
21	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
22	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
23	Symfony\Component\HttpKernel\Kernel->handle (line 193)
24	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
25	require_once (line 32)
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.

Managed Entities

default entity manager

Class	Amount of managed objects

Entities Mapping

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

Symfony Profiler

GET https://researchingcc.dev-investigacion.ing.uc.cl/author/public

Configuration Settings

Theme

Page Width