Symfony Profiler

Query Metrics

3 Database Queries

3 Different statements

1.81 ms Query time

0 Invalid entities

4 Managed entities

Queries

Group similar statements

#▲

Time

Info

0.38 ms

SELECT COUNT(b0_.id) AS sclr_0 FROM blog_post b0_ WHERE b0_.is_published = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(b0_.id) AS sclr_0
FROM
  blog_post b0_
WHERE
  b0_.is_published = ?

SELECT COUNT(b0_.id) AS sclr_0 FROM blog_post b0_ WHERE b0_.is_published = 1;

#	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 773)
6	Doctrine\ORM\AbstractQuery->getSingleResult (line 802)
7	Doctrine\ORM\AbstractQuery->getSingleScalarResult (line 36)
8	App\Repository\BlogPostRepository->countPublished (line 21)
9	App\Controller\BlogController->index (line 183)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
12	Symfony\Component\HttpKernel\Kernel->handle (line 35)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
14	require_once (line 5)

1.15 ms

SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, created_at_4 FROM (SELECT b0_.id AS id_0, b0_.title AS title_1, b0_.slug AS slug_2, b0_.content AS content_3, b0_.created_at AS created_at_4, b0_.image AS image_5, b0_.is_published AS is_published_6 FROM blog_post b0_ WHERE b0_.is_published = ?) dctrn_result_inner ORDER BY created_at_4 DESC) dctrn_result LIMIT 6 OFFSET 108

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT id_0
FROM
  (
    SELECT
      DISTINCT id_0,
      created_at_4
    FROM
      (
        SELECT
          b0_.id AS id_0,
          b0_.title AS title_1,
          b0_.slug AS slug_2,
          b0_.content AS content_3,
          b0_.created_at AS created_at_4,
          b0_.image AS image_5,
          b0_.is_published AS is_published_6
        FROM
          blog_post b0_
        WHERE
          b0_.is_published = ?
      ) dctrn_result_inner
    ORDER BY
      created_at_4 DESC
  ) dctrn_result
LIMIT
  6
OFFSET
  108

SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, created_at_4 FROM (SELECT b0_.id AS id_0, b0_.title AS title_1, b0_.slug AS slug_2, b0_.content AS content_3, b0_.created_at AS created_at_4, b0_.image AS image_5, b0_.is_published AS is_published_6 FROM blog_post b0_ WHERE b0_.is_published = 1) dctrn_result_inner ORDER BY created_at_4 DESC) dctrn_result LIMIT 6 OFFSET 108;

#	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 155)
8	__TwigTemplate_051b79fe4aa6f0fe11b8f60f92c3042c->block_content_main (line 446)
9	Twig\Template->yieldBlock (line 766)
10	__TwigTemplate_8bd109f128d898d8af5a1c808eb3a883->block_content (line 446)
11	Twig\Template->yieldBlock (line 194)
12	__TwigTemplate_8bd109f128d898d8af5a1c808eb3a883->doDisplay (line 402)
13	Twig\Template->yield (line 56)
14	__TwigTemplate_051b79fe4aa6f0fe11b8f60f92c3042c->doDisplay (line 402)
15	Twig\Template->yield (line 358)
16	Twig\Template->display (line 373)
17	Twig\Template->render (line 51)
18	Twig\TemplateWrapper->render (line 333)
19	Twig\Environment->render (line 431)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 24)
23	App\Controller\BlogController->index (line 183)
24	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
25	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
26	Symfony\Component\HttpKernel\Kernel->handle (line 35)
27	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
28	require_once (line 5)

0.28 ms

SELECT b0_.id AS id_0, b0_.title AS title_1, b0_.slug AS slug_2, b0_.content AS content_3, b0_.created_at AS created_at_4, b0_.image AS image_5, b0_.is_published AS is_published_6 FROM blog_post b0_ WHERE b0_.is_published = ? AND b0_.id IN (?, ?, ?, ?) ORDER BY b0_.created_at DESC

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  b0_.id AS id_0,
  b0_.title AS title_1,
  b0_.slug AS slug_2,
  b0_.content AS content_3,
  b0_.created_at AS created_at_4,
  b0_.image AS image_5,
  b0_.is_published AS is_published_6
FROM
  blog_post b0_
WHERE
  b0_.is_published = ?
  AND b0_.id IN (?, ?, ?, ?)
ORDER BY
  b0_.created_at DESC

SELECT b0_.id AS id_0, b0_.title AS title_1, b0_.slug AS slug_2, b0_.content AS content_3, b0_.created_at AS created_at_4, b0_.image AS image_5, b0_.is_published AS is_published_6 FROM blog_post b0_ WHERE b0_.is_published = 1 AND b0_.id IN (5, 4, 2, 1) ORDER BY b0_.created_at DESC;

#	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 155)
8	__TwigTemplate_051b79fe4aa6f0fe11b8f60f92c3042c->block_content_main (line 446)
9	Twig\Template->yieldBlock (line 766)
10	__TwigTemplate_8bd109f128d898d8af5a1c808eb3a883->block_content (line 446)
11	Twig\Template->yieldBlock (line 194)
12	__TwigTemplate_8bd109f128d898d8af5a1c808eb3a883->doDisplay (line 402)
13	Twig\Template->yield (line 56)
14	__TwigTemplate_051b79fe4aa6f0fe11b8f60f92c3042c->doDisplay (line 402)
15	Twig\Template->yield (line 358)
16	Twig\Template->display (line 373)
17	Twig\Template->render (line 51)
18	Twig\TemplateWrapper->render (line 333)
19	Twig\Environment->render (line 431)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 24)
23	App\Controller\BlogController->index (line 183)
24	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
25	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
26	Symfony\Component\HttpKernel\Kernel->handle (line 35)
27	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
28	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\BlogPost	4

Entities Mapping

Class	Mapping errors
App\Entity\BlogPost	No errors.

Symfony Profiler

GET https://stripe.wetter.allgaeu-webmarketing.de/blog?page=19

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping