Symfony Profiler

Query Metrics

12 Database Queries

6 Different statements

8.03 ms Query time

0 Invalid entities

14 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

3.43 ms
(42.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 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 110)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 73)
4	App\Repository\CategoryRepository->findCategoryTree (line 68)
5	App\Controller\ArticleController->category (line 85)
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)

2.31 ms
(28.76%)

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:

[
  719
]

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 = 719;

#	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 2737)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->count (line 41)
7	Doctrine\ORM\PersistentCollection->count (line 391)
8	Twig\Extension\CoreExtension->testEmpty (line 1423)
9	__TwigTemplate_7178303e7762dc2b983489aaf1b579df::doDisplay (line 96)
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_1f9537d8a1a53a66894cd4730c715b4d->block_body (line 219)
17	Twig\Template->yieldBlock (line 456)
18	__TwigTemplate_351ad6c7fc2de3eb03005466e8e6c791->doDisplay (line 152)
19	Twig\Template->yield (line 411)
20	__TwigTemplate_1f9537d8a1a53a66894cd4730c715b4d->doDisplay (line 55)
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->category (line 87)
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.83 ms
(10.37%)

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 EXISTS (SELECT 1 FROM article_category a1_ WHERE a1_.article_id = a0_.id AND a1_.category_id IN (?)) 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 EXISTS (
    SELECT
      1
    FROM
      article_category a1_
    WHERE
      a1_.article_id = a0_.id
      AND a1_.category_id IN (?)
  )
  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 EXISTS (SELECT 1 FROM article_category a1_ WHERE a1_.article_id = a0_.id AND a1_.category_id IN (285)) AND a0_.id IN (719, 721, 725, 727, 730, 732) 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->getIterator (line 145)
7	iterator_to_array (line 45)
8	Knp\Component\Pager\Event\Subscriber\Paginate\Doctrine\ORM\QuerySubscriber::items (line 45)
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	ContainerS5JaJW7\PaginatorProxyBa079e5->paginate (line 25)
15	App\Controller\ArticleController->category (line 79)
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)

0.51 ms
(6.35%)

SELECT count(DISTINCT a0_.id) AS sclr_0 FROM article a0_ WHERE a0_.is_published = 1 AND EXISTS (SELECT 1 FROM article_category a1_ WHERE a1_.article_id = a0_.id AND a1_.category_id IN (?))

Parameters:

[
  285
]

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
  AND EXISTS (
    SELECT
      1
    FROM
      article_category a1_
    WHERE
      a1_.article_id = a0_.id
      AND a1_.category_id IN (?)
  )

SELECT count(DISTINCT a0_.id) AS sclr_0 FROM article a0_ WHERE a0_.is_published = 1 AND EXISTS (SELECT 1 FROM article_category a1_ WHERE a1_.article_id = a0_.id AND a1_.category_id IN (285));

#	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	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	ContainerS5JaJW7\PaginatorProxyBa079e5->paginate (line 25)
15	App\Controller\ArticleController->category (line 79)
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)

0.50 ms
(6.22%)

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 WHERE t0.slug = ? LIMIT 1

Parameters:

[
  "symfony"
]

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
WHERE
  t0.slug = ?
LIMIT
  1

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 WHERE t0.slug = 'symfony' 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\ServiceEntityRepositoryProxy->findOneBy (line 81)
4	Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->resolve (line 79)
5	Symfony\Component\HttpKernel\Controller\ArgumentResolver\TraceableValueResolver->resolve (line 37)
6	Symfony\Component\HttpKernel\Controller\ArgumentResolver->getArguments (line 91)
7	Symfony\Component\HttpKernel\Controller\TraceableArgumentResolver->getArguments (line 33)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 175)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 193)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
12	require_once (line 32)
13	require_once (line 5)

0.45 ms
(5.54%)

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 AND EXISTS (SELECT 1 FROM article_category a1_ WHERE a1_.article_id = a0_.id AND a1_.category_id IN (?)) ORDER BY a0_.published_at DESC, a0_.created_at DESC LIMIT 9

Parameters:

[
  285
]

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
  AND EXISTS (
    SELECT
      1
    FROM
      article_category a1_
    WHERE
      a1_.article_id = a0_.id
      AND a1_.category_id IN (?)
  )
ORDER BY
  a0_.published_at DESC,
  a0_.created_at DESC
LIMIT
  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 AND EXISTS (SELECT 1 FROM article_category a1_ WHERE a1_.article_id = a0_.id AND a1_.category_id IN (285)) ORDER BY a0_.published_at DESC, a0_.created_at DESC LIMIT 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->getIterator (line 127)
7	iterator_to_array (line 45)
8	Knp\Component\Pager\Event\Subscriber\Paginate\Doctrine\ORM\QuerySubscriber::items (line 45)
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	ContainerS5JaJW7\PaginatorProxyBa079e5->paginate (line 25)
15	App\Controller\ArticleController->category (line 79)
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	6

Entities Mapping

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

Symfony Profiler

GET http://www.dev.michaeljpitz.com/categorie/symfony

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping