Symfony Profiler

Query Metrics

3 Database Queries

3 Different statements

0.74 ms Query time

0 Invalid entities

10 Managed entities

Queries

Group similar statements

#▲

Time

Info

0.40 ms

SELECT DISTINCT id_0 FROM (SELECT a0_.id AS id_0, a0_.name AS name_1, a0_.date_of_birth AS date_of_birth_2, a0_.date_of_death AS date_of_death_3, a0_.nationality AS nationality_4 FROM author a0_) dctrn_result LIMIT 10

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT id_0
FROM
  (
    SELECT
      a0_.id AS id_0,
      a0_.name AS name_1,
      a0_.date_of_birth AS date_of_birth_2,
      a0_.date_of_death AS date_of_death_3,
      a0_.nationality AS nationality_4
    FROM
      author a0_
  ) dctrn_result
LIMIT
  10

SELECT DISTINCT id_0 FROM (SELECT a0_.id AS id_0, a0_.name AS name_1, a0_.date_of_birth AS date_of_birth_2, a0_.date_of_death AS date_of_death_3, a0_.nationality AS nationality_4 FROM author a0_) dctrn_result LIMIT 10;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 935)
4	Doctrine\ORM\AbstractQuery->execute (line 891)
5	Doctrine\ORM\AbstractQuery->getScalarResult (line 725)
6	Doctrine\ORM\Tools\Pagination\Paginator->getIterator (line 127)
7	Pagerfanta\Doctrine\ORM\QueryAdapter->getSlice (line 57)
8	Pagerfanta\Pagerfanta->getCurrentPageResultsFromAdapter (line 260)
9	Pagerfanta\Pagerfanta->getCurrentPageResults (line 249)
10	Pagerfanta\Pagerfanta->getIterator (line 415)
11	__TwigTemplate_06b458aa8c95b04f1e04cae66a97237a->block_loop_content (line 137)
12	Twig\Template->yieldBlock (line 446)
13	__TwigTemplate_6ebb1088d610b1f7b7013de58779d658->block_body (line 112)
14	Twig\Template->yieldBlock (line 446)
15	__TwigTemplate_7ec869a0b9307ff1a1b189e317677c91->doDisplay (line 183)
16	Twig\Template->yield (line 402)
17	__TwigTemplate_6ebb1088d610b1f7b7013de58779d658->doDisplay (line 56)
18	Twig\Template->yield (line 402)
19	__TwigTemplate_06b458aa8c95b04f1e04cae66a97237a->doDisplay (line 58)
20	Twig\Template->yield (line 402)
21	Twig\Template->display (line 358)
22	Twig\Template->render (line 373)
23	Twig\TemplateWrapper->render (line 51)
24	Twig\Environment->render (line 333)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 459)
26	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 464)
27	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 278)
28	App\Controller\AuthorController->index (line 25)
29	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
30	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
31	Symfony\Component\HttpKernel\Kernel->handle (line 182)
32	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
33	require_once (line 29)
34	require_once (line 5)

0.21 ms

SELECT a0_.id AS id_0, a0_.name AS name_1, a0_.date_of_birth AS date_of_birth_2, a0_.date_of_death AS date_of_death_3, a0_.nationality AS nationality_4 FROM author a0_ WHERE a0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  a0_.id AS id_0,
  a0_.name AS name_1,
  a0_.date_of_birth AS date_of_birth_2,
  a0_.date_of_death AS date_of_death_3,
  a0_.nationality AS nationality_4
FROM
  author a0_
WHERE
  a0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

SELECT a0_.id AS id_0, a0_.name AS name_1, a0_.date_of_birth AS date_of_birth_2, a0_.date_of_death AS date_of_death_3, a0_.nationality AS nationality_4 FROM author a0_ WHERE a0_.id IN (1, 2, 53, 54, 55, 56, 57, 58, 59, 60);

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 935)
4	Doctrine\ORM\AbstractQuery->execute (line 891)
5	Doctrine\ORM\AbstractQuery->getResult (line 689)
6	Doctrine\ORM\Tools\Pagination\Paginator->getIterator (line 145)
7	Pagerfanta\Doctrine\ORM\QueryAdapter->getSlice (line 57)
8	Pagerfanta\Pagerfanta->getCurrentPageResultsFromAdapter (line 260)
9	Pagerfanta\Pagerfanta->getCurrentPageResults (line 249)
10	Pagerfanta\Pagerfanta->getIterator (line 415)
11	__TwigTemplate_06b458aa8c95b04f1e04cae66a97237a->block_loop_content (line 137)
12	Twig\Template->yieldBlock (line 446)
13	__TwigTemplate_6ebb1088d610b1f7b7013de58779d658->block_body (line 112)
14	Twig\Template->yieldBlock (line 446)
15	__TwigTemplate_7ec869a0b9307ff1a1b189e317677c91->doDisplay (line 183)
16	Twig\Template->yield (line 402)
17	__TwigTemplate_6ebb1088d610b1f7b7013de58779d658->doDisplay (line 56)
18	Twig\Template->yield (line 402)
19	__TwigTemplate_06b458aa8c95b04f1e04cae66a97237a->doDisplay (line 58)
20	Twig\Template->yield (line 402)
21	Twig\Template->display (line 358)
22	Twig\Template->render (line 373)
23	Twig\TemplateWrapper->render (line 51)
24	Twig\Environment->render (line 333)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 459)
26	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 464)
27	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 278)
28	App\Controller\AuthorController->index (line 25)
29	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
30	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
31	Symfony\Component\HttpKernel\Kernel->handle (line 182)
32	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
33	require_once (line 29)
34	require_once (line 5)

0.13 ms

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT a0_.id AS id_0, a0_.name AS name_1, a0_.date_of_birth AS date_of_birth_2, a0_.date_of_death AS date_of_death_3, a0_.nationality AS nationality_4 FROM author a0_) 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_.name AS name_1,
          a0_.date_of_birth AS date_of_birth_2,
          a0_.date_of_death AS date_of_death_3,
          a0_.nationality AS nationality_4
        FROM
          author a0_
      ) dctrn_result
  ) dctrn_table

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT a0_.id AS id_0, a0_.name AS name_1, a0_.date_of_birth AS date_of_birth_2, a0_.date_of_death AS date_of_death_3, a0_.nationality AS nationality_4 FROM author a0_) 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 935)
4	Doctrine\ORM\AbstractQuery->execute (line 891)
5	Doctrine\ORM\AbstractQuery->getScalarResult (line 725)
6	Doctrine\ORM\Tools\Pagination\Paginator->count (line 96)
7	Pagerfanta\Doctrine\ORM\QueryAdapter->getNbResults (line 42)
8	Pagerfanta\Pagerfanta->getNbResults (line 292)
9	Pagerfanta\Pagerfanta->calculateNbPages (line 318)
10	Pagerfanta\Pagerfanta->getNbPages (line 300)
11	Pagerfanta\View\View->initializePagerfanta (line 43)
12	Pagerfanta\Twig\View\TwigView->render (line 36)
13	Pagerfanta\Twig\Extension\PagerfantaRuntime->renderPagerfanta (line 34)
14	__TwigTemplate_6ebb1088d610b1f7b7013de58779d658->block_pagination_bottom (line 170)
15	Twig\Template->yieldBlock (line 446)
16	__TwigTemplate_6ebb1088d610b1f7b7013de58779d658->block_body (line 117)
17	Twig\Template->yieldBlock (line 446)
18	__TwigTemplate_7ec869a0b9307ff1a1b189e317677c91->doDisplay (line 183)
19	Twig\Template->yield (line 402)
20	__TwigTemplate_6ebb1088d610b1f7b7013de58779d658->doDisplay (line 56)
21	Twig\Template->yield (line 402)
22	__TwigTemplate_06b458aa8c95b04f1e04cae66a97237a->doDisplay (line 58)
23	Twig\Template->yield (line 402)
24	Twig\Template->display (line 358)
25	Twig\Template->render (line 373)
26	Twig\TemplateWrapper->render (line 51)
27	Twig\Environment->render (line 333)
28	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 459)
29	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 464)
30	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 278)
31	App\Controller\AuthorController->index (line 25)
32	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
33	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
34	Symfony\Component\HttpKernel\Kernel->handle (line 182)
35	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
36	require_once (line 29)
37	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
App\Entity\Author	10

Entities Mapping

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

Symfony Profiler

GET https://biblios.zag-com2.fr/author

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping