Symfony Profiler

Query Metrics

2 Database Queries

2 Different statements

1.73 ms Query time

0 Invalid entities

0 Managed entities

Queries

Group similar statements

#▲

Time

Info

0.97 ms

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT n0_.id AS id_0, n0_.title AS title_1, n0_.date AS date_2, n0_.publish_date AS publish_date_3, n0_.cover AS cover_4, n0_.content AS content_5, n0_.headline AS headline_6, n0_.active AS active_7, n0_.type AS type_8, n0_.expire_date AS expire_date_9, n0_.updated_at AS updated_at_10 FROM notice n0_ WHERE n0_.type = ? AND n0_.active = ? ORDER BY n0_.date DESC) 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
          n0_.id AS id_0,
          n0_.title AS title_1,
          n0_.date AS date_2,
          n0_.publish_date AS publish_date_3,
          n0_.cover AS cover_4,
          n0_.content AS content_5,
          n0_.headline AS headline_6,
          n0_.active AS active_7,
          n0_.type AS type_8,
          n0_.expire_date AS expire_date_9,
          n0_.updated_at AS updated_at_10
        FROM
          notice n0_
        WHERE
          n0_.type = ?
          AND n0_.active = ?
        ORDER BY
          n0_.date DESC
      ) dctrn_result
  ) dctrn_table

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT n0_.id AS id_0, n0_.title AS title_1, n0_.date AS date_2, n0_.publish_date AS publish_date_3, n0_.cover AS cover_4, n0_.content AS content_5, n0_.headline AS headline_6, n0_.active AS active_7, n0_.type AS type_8, n0_.expire_date AS expire_date_9, n0_.updated_at AS updated_at_10 FROM notice n0_ WHERE n0_.type = 3 AND n0_.active = 1 ORDER BY n0_.date DESC) 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	__TwigTemplate_f1b1aad7aee5b88b7d5d314fa5126c21->block_body (line 135)
8	Twig\Template->yieldBlock (line 446)
9	__TwigTemplate_7e4061ab1b982f2dbcf7b5683cbb4769->doDisplay (line 241)
10	Twig\Template->yield (line 402)
11	__TwigTemplate_f1b1aad7aee5b88b7d5d314fa5126c21->doDisplay (line 54)
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 462)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 467)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 279)
20	App\Controller\Pub\MainController->eventos (line 266)
21	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
22	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
23	Symfony\Component\HttpKernel\Kernel->handle (line 191)
24	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
25	require_once (line 32)
26	require_once (line 5)

0.75 ms

SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, date_2 FROM (SELECT n0_.id AS id_0, n0_.title AS title_1, n0_.date AS date_2, n0_.publish_date AS publish_date_3, n0_.cover AS cover_4, n0_.content AS content_5, n0_.headline AS headline_6, n0_.active AS active_7, n0_.type AS type_8, n0_.expire_date AS expire_date_9, n0_.updated_at AS updated_at_10 FROM notice n0_ WHERE n0_.type = ? AND n0_.active = ?) dctrn_result_inner ORDER BY date_2 DESC) 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,
      date_2
    FROM
      (
        SELECT
          n0_.id AS id_0,
          n0_.title AS title_1,
          n0_.date AS date_2,
          n0_.publish_date AS publish_date_3,
          n0_.cover AS cover_4,
          n0_.content AS content_5,
          n0_.headline AS headline_6,
          n0_.active AS active_7,
          n0_.type AS type_8,
          n0_.expire_date AS expire_date_9,
          n0_.updated_at AS updated_at_10
        FROM
          notice n0_
        WHERE
          n0_.type = ?
          AND n0_.active = ?
      ) dctrn_result_inner
    ORDER BY
      date_2 DESC
  ) dctrn_result
LIMIT
  12

SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, date_2 FROM (SELECT n0_.id AS id_0, n0_.title AS title_1, n0_.date AS date_2, n0_.publish_date AS publish_date_3, n0_.cover AS cover_4, n0_.content AS content_5, n0_.headline AS headline_6, n0_.active AS active_7, n0_.type AS type_8, n0_.expire_date AS expire_date_9, n0_.updated_at AS updated_at_10 FROM notice n0_ WHERE n0_.type = 3 AND n0_.active = 1) dctrn_result_inner ORDER BY date_2 DESC) 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_f1b1aad7aee5b88b7d5d314fa5126c21->block_body (line 141)
8	Twig\Template->yieldBlock (line 446)
9	__TwigTemplate_7e4061ab1b982f2dbcf7b5683cbb4769->doDisplay (line 241)
10	Twig\Template->yield (line 402)
11	__TwigTemplate_f1b1aad7aee5b88b7d5d314fa5126c21->doDisplay (line 54)
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 462)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 467)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 279)
20	App\Controller\Pub\MainController->eventos (line 266)
21	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
22	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
23	Symfony\Component\HttpKernel\Kernel->handle (line 191)
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\Notice	No errors.

Symfony Profiler

GET https://conexao.wab.com.br/eventos

Configuration Settings

Theme

Page Width