Symfony Profiler

Query Metrics

12 Database Queries

5 Different statements

3.60 ms Query time

0 Invalid entities

15 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

1.93 ms
(53.75%)

SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.color AS color_4, t0.description AS description_5, t0.level AS level_6 FROM category t0 INNER JOIN article_category ON t0.id = article_category.category_id WHERE article_category.article_id = ?

Parameters:

[
  1125
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.slug AS slug_3,
  t0.color AS color_4,
  t0.description AS description_5,
  t0.level AS level_6
FROM
  category t0
  INNER JOIN article_category ON t0.id = article_category.category_id
WHERE
  article_category.article_id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.color AS color_4, t0.description AS description_5, t0.level AS level_6 FROM category t0 INNER JOIN article_category ON t0.id = article_category.category_id WHERE article_category.article_id = 1125;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getManyToManyStatement (line 1106)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadManyToManyCollection (line 1035)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2932)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 629)
5	Doctrine\ORM\PersistentCollection->initialize (line 188)
6	Doctrine\Common\Collections\AbstractLazyCollection->count (line 41)
7	Doctrine\ORM\PersistentCollection->count (line 393)
8	Twig\Extension\CoreExtension->testEmpty (line 1426)
9	__TwigTemplate_ec670dc1057fdbd3a1eae730546b5dcc::doDisplay (line 97)
10	Twig\Template->yield (line 411)
11	Twig\Template->display (line 366)
12	Twig\Template->render (line 381)
13	Symfony\UX\TwigComponent\ComponentRenderer->render (line 77)
14	Symfony\UX\TwigComponent\ComponentRenderer->createAndRender (line 56)
15	Symfony\UX\TwigComponent\Twig\ComponentRuntime->render (line 51)
16	__TwigTemplate_7d74e994b97c914e7e9ee01a69bd6744->block_body (line 220)
17	Twig\Template->yieldBlock (line 458)
18	__TwigTemplate_c86bdfcce28ef7586ad30e0e8a0918e5->doDisplay (line 155)
19	Twig\Template->yield (line 411)
20	__TwigTemplate_7d74e994b97c914e7e9ee01a69bd6744->doDisplay (line 56)
21	Twig\Template->yield (line 411)
22	Twig\Template->display (line 366)
23	Twig\Template->render (line 381)
24	Twig\TemplateWrapper->render (line 51)
25	Twig\Environment->render (line 333)
26	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
27	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
28	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
29	App\Controller\ArticleController->index (line 62)
30	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
31	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
32	Symfony\Component\HttpKernel\Kernel->handle (line 193)
33	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
34	require_once (line 32)
35	require_once (line 5)

0.67 ms
(18.67%)

SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.color AS color_4, t0.description AS description_5, t0.level AS level_6 FROM category t0 ORDER BY t0.title ASC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.slug AS slug_3,
  t0.color AS color_4,
  t0.description AS description_5,
  t0.level AS level_6
FROM
  category t0
ORDER BY
  t0.title ASC

SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.color AS color_4, t0.description AS description_5, t0.level AS level_6 FROM category t0 ORDER BY t0.title ASC;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 963)
2	Doctrine\ORM\EntityRepository->findBy (line 111)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 73)
4	App\Repository\CategoryRepository->findCategoryTree (line 68)
5	App\Controller\ArticleController->index (line 60)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
8	Symfony\Component\HttpKernel\Kernel->handle (line 193)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
10	require_once (line 32)
11	require_once (line 5)

0.39 ms
(10.71%)

SELECT a0_.id AS id_0, a0_.title AS title_1, a0_.slug AS slug_2, a0_.content AS content_3, a0_.excerpt AS excerpt_4, a0_.featured_image AS featured_image_5, a0_.is_published AS is_published_6, a0_.created_at AS created_at_7, a0_.published_at AS published_at_8, a0_.updated_at AS updated_at_9 FROM article a0_ WHERE a0_.is_published = 1 AND a0_.id IN (?, ?, ?, ?, ?, ?, ?) ORDER BY a0_.published_at DESC, a0_.created_at DESC

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  a0_.id AS id_0,
  a0_.title AS title_1,
  a0_.slug AS slug_2,
  a0_.content AS content_3,
  a0_.excerpt AS excerpt_4,
  a0_.featured_image AS featured_image_5,
  a0_.is_published AS is_published_6,
  a0_.created_at AS created_at_7,
  a0_.published_at AS published_at_8,
  a0_.updated_at AS updated_at_9
FROM
  article a0_
WHERE
  a0_.is_published = 1
  AND a0_.id IN (?, ?, ?, ?, ?, ?, ?)
ORDER BY
  a0_.published_at DESC,
  a0_.created_at DESC

SELECT a0_.id AS id_0, a0_.title AS title_1, a0_.slug AS slug_2, a0_.content AS content_3, a0_.excerpt AS excerpt_4, a0_.featured_image AS featured_image_5, a0_.is_published AS is_published_6, a0_.created_at AS created_at_7, a0_.published_at AS published_at_8, a0_.updated_at AS updated_at_9 FROM article a0_ WHERE a0_.is_published = 1 AND a0_.id IN (1125, 1126, 1127, 1128, 1129, 1130, 1131) ORDER BY a0_.published_at DESC, a0_.created_at DESC;

#	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->getResult (line 688)
6	Doctrine\ORM\Tools\Pagination\Paginator->getResultForOffset (line 172)
7	Doctrine\ORM\Tools\Pagination\Paginator->getIterator (line 105)
8	iterator_to_array (line 45)
9	Knp\Component\Pager\Event\Subscriber\Paginate\Doctrine\ORM\QuerySubscriber::items (line 45)
10	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
11	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
12	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
13	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 129)
14	Knp\Component\Pager\Paginator->paginate (line 97)
15	ContainerEEEancB\PaginatorProxyBa079e5->paginate (line 25)
16	App\Controller\ArticleController->index (line 54)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
19	Symfony\Component\HttpKernel\Kernel->handle (line 193)
20	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
21	require_once (line 32)
22	require_once (line 5)

0.31 ms
(8.68%)

SELECT DISTINCT a0_.id AS id_0, a0_.published_at AS published_at_1, a0_.created_at AS created_at_2 FROM article a0_ WHERE a0_.is_published = 1 ORDER BY a0_.published_at DESC, a0_.created_at DESC LIMIT 9 OFFSET 9

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT a0_.id AS id_0,
  a0_.published_at AS published_at_1,
  a0_.created_at AS created_at_2
FROM
  article a0_
WHERE
  a0_.is_published = 1
ORDER BY
  a0_.published_at DESC,
  a0_.created_at DESC
LIMIT
  9
OFFSET
  9

SELECT DISTINCT a0_.id AS id_0, a0_.published_at AS published_at_1, a0_.created_at AS created_at_2 FROM article a0_ WHERE a0_.is_published = 1 ORDER BY a0_.published_at DESC, a0_.created_at DESC LIMIT 9 OFFSET 9;

#	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->getResultForOffset (line 154)
7	Doctrine\ORM\Tools\Pagination\Paginator->getIterator (line 105)
8	iterator_to_array (line 45)
9	Knp\Component\Pager\Event\Subscriber\Paginate\Doctrine\ORM\QuerySubscriber::items (line 45)
10	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
11	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
12	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
13	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 129)
14	Knp\Component\Pager\Paginator->paginate (line 97)
15	ContainerEEEancB\PaginatorProxyBa079e5->paginate (line 25)
16	App\Controller\ArticleController->index (line 54)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
19	Symfony\Component\HttpKernel\Kernel->handle (line 193)
20	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
21	require_once (line 32)
22	require_once (line 5)

0.29 ms
(8.19%)

SELECT count(DISTINCT a0_.id) AS sclr_0 FROM article a0_ WHERE a0_.is_published = 1

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  count(DISTINCT a0_.id) AS sclr_0
FROM
  article a0_
WHERE
  a0_.is_published = 1

SELECT count(DISTINCT a0_.id) AS sclr_0 FROM article a0_ WHERE a0_.is_published = 1;

#	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 89)
7	count (line 43)
8	Knp\Component\Pager\Event\Subscriber\Paginate\Doctrine\ORM\QuerySubscriber::items (line 43)
9	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
10	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
11	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
12	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 129)
13	Knp\Component\Pager\Paginator->paginate (line 97)
14	ContainerEEEancB\PaginatorProxyBa079e5->paginate (line 25)
15	App\Controller\ArticleController->index (line 54)
16	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
17	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
18	Symfony\Component\HttpKernel\Kernel->handle (line 193)
19	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
20	require_once (line 32)
21	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\Category	8
App\Entity\Article	7

Entities Mapping

Class	Mapping errors
App\Entity\Article	No errors.
App\Entity\Category	No errors.
App\Entity\Comment	No errors.
App\Entity\Rating	No errors.
App\Entity\Page	No errors.

Symfony Profiler

GET https://dev.michaeljpitz.com/articles?page=2

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping