Symfony Profiler

Query Metrics

3 Database Queries

3 Different statements

5.31 ms Query time

0 Invalid entities

1 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

2.50 ms
(47.20%)

SELECT DISTINCT s0_.id AS id_0, s0_.published_at AS published_at_1 FROM symfony_demo_post s0_ INNER JOIN symfony_demo_user s1_ ON s0_.author_id = s1_.id LEFT JOIN symfony_demo_post_tag s3_ ON s0_.id = s3_.post_id LEFT JOIN symfony_demo_tag s2_ ON s2_.id = s3_.tag_id WHERE s0_.published_at <= ? AND EXISTS (SELECT 1 FROM symfony_demo_post_tag s4_ WHERE s4_.post_id = s0_.id AND s4_.tag_id IN (?)) ORDER BY s0_.published_at DESC LIMIT 10

Parameters:

[
  "2026-09-12 12:53:36"
  13
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT s0_.id AS id_0,
  s0_.published_at AS published_at_1
FROM
  symfony_demo_post s0_
  INNER JOIN symfony_demo_user s1_ ON s0_.author_id = s1_.id
  LEFT JOIN symfony_demo_post_tag s3_ ON s0_.id = s3_.post_id
  LEFT JOIN symfony_demo_tag s2_ ON s2_.id = s3_.tag_id
WHERE
  s0_.published_at <= ?
  AND EXISTS (
    SELECT
      1
    FROM
      symfony_demo_post_tag s4_
    WHERE
      s4_.post_id = s0_.id
      AND s4_.tag_id IN (?)
  )
ORDER BY
  s0_.published_at DESC
LIMIT
  10

SELECT DISTINCT s0_.id AS id_0, s0_.published_at AS published_at_1 FROM symfony_demo_post s0_ INNER JOIN symfony_demo_user s1_ ON s0_.author_id = s1_.id LEFT JOIN symfony_demo_post_tag s3_ ON s0_.id = s3_.post_id LEFT JOIN symfony_demo_tag s2_ ON s2_.id = s3_.tag_id WHERE s0_.published_at <= '2026-09-12 12:53:36' AND EXISTS (SELECT 1 FROM symfony_demo_post_tag s4_ WHERE s4_.post_id = s0_.id AND s4_.tag_id IN (13)) ORDER BY s0_.published_at DESC 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 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	App\Pagination\Paginator->paginate (line 71)
8	App\Repository\PostRepository->findLatest (line 59)
9	App\Controller\BlogController->index (line 60)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 188)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 79)
12	Symfony\Component\HttpKernel\Kernel->handle (line 143)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
14	require_once (line 32)
15	require_once (line 5)

2.05 ms
(38.70%)

SELECT t0.id AS id_1, t0.name AS name_2 FROM symfony_demo_tag t0 WHERE t0.name = ? LIMIT 1

Parameters:

[
  "noel"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2
FROM
  symfony_demo_tag t0
WHERE
  t0.name = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2 FROM symfony_demo_tag t0 WHERE t0.name = 'noel' LIMIT 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\EntityRepository->findOneBy (line 125)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepository->findOneBy (line 86)
4	App\Controller\BlogController->index (line 57)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 188)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 79)
7	Symfony\Component\HttpKernel\Kernel->handle (line 143)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
9	require_once (line 32)
10	require_once (line 5)

0.75 ms
(14.10%)

SELECT count(DISTINCT s0_.id) AS sclr_0 FROM symfony_demo_post s0_ INNER JOIN symfony_demo_user s1_ ON s0_.author_id = s1_.id LEFT JOIN symfony_demo_post_tag s3_ ON s0_.id = s3_.post_id LEFT JOIN symfony_demo_tag s2_ ON s2_.id = s3_.tag_id WHERE s0_.published_at <= ? AND EXISTS (SELECT 1 FROM symfony_demo_post_tag s4_ WHERE s4_.post_id = s0_.id AND s4_.tag_id IN (?))

Parameters:

[
  "2026-09-12 12:53:36"
  13
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  count(DISTINCT s0_.id) AS sclr_0
FROM
  symfony_demo_post s0_
  INNER JOIN symfony_demo_user s1_ ON s0_.author_id = s1_.id
  LEFT JOIN symfony_demo_post_tag s3_ ON s0_.id = s3_.post_id
  LEFT JOIN symfony_demo_tag s2_ ON s2_.id = s3_.tag_id
WHERE
  s0_.published_at <= ?
  AND EXISTS (
    SELECT
      1
    FROM
      symfony_demo_post_tag s4_
    WHERE
      s4_.post_id = s0_.id
      AND s4_.tag_id IN (?)
  )

SELECT count(DISTINCT s0_.id) AS sclr_0 FROM symfony_demo_post s0_ INNER JOIN symfony_demo_user s1_ ON s0_.author_id = s1_.id LEFT JOIN symfony_demo_post_tag s3_ ON s0_.id = s3_.post_id LEFT JOIN symfony_demo_tag s2_ ON s2_.id = s3_.tag_id WHERE s0_.published_at <= '2026-09-12 12:53:36' AND EXISTS (SELECT 1 FROM symfony_demo_post_tag s4_ WHERE s4_.post_id = s0_.id AND s4_.tag_id IN (13));

#	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\Pagination\Paginator->paginate (line 72)
8	App\Repository\PostRepository->findLatest (line 59)
9	App\Controller\BlogController->index (line 60)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 188)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 79)
12	Symfony\Component\HttpKernel\Kernel->handle (line 143)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
14	require_once (line 32)
15	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\Tag	1

Entities Mapping

Class	Mapping errors
App\Entity\Tag	No errors.
App\Entity\Post	No errors.
App\Entity\User	No errors.

GET http://masaepiano.com/en/blog/?tag=noel

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping