Symfony Profiler

Query Metrics

3 Database Queries

2 Different statements

10.04 ms Query time

0 Invalid entities

9 Managed entities

Queries

Group similar statements

#▲

Time

Info

7.45 ms

SELECT a0_.id AS id_0, a0_.heading AS heading_1, a0_.content AS content_2, a0_.created_at AS created_at_3, a0_.category AS category_4 FROM article a0_ WHERE a0_.category = ? ORDER BY a0_.created_at DESC

Parameters:

[
  "news"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  a0_.id AS id_0,
  a0_.heading AS heading_1,
  a0_.content AS content_2,
  a0_.created_at AS created_at_3,
  a0_.category AS category_4
FROM
  article a0_
WHERE
  a0_.category = ?
ORDER BY
  a0_.created_at DESC

SELECT a0_.id AS id_0, a0_.heading AS heading_1, a0_.content AS content_2, a0_.created_at AS created_at_3, a0_.category AS category_4 FROM article a0_ WHERE a0_.category = 'news' ORDER BY a0_.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 43)
7	App\Repository\ArticleRepository->findByCategory (line 360)
8	App\Controller\MainController->articleList (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require_once (line 5)

1.28 ms

SELECT t0.id AS id_1, t0.name AS name_2, t0.name_original AS name_original_3, t0.mime_type AS mime_type_4, t0.path AS path_5, t0.path_base AS path_base_6, t0.category AS category_7, t0.vehicle_id AS vehicle_id_8, t0.article_id AS article_id_9 FROM file t0 WHERE t0.article_id = ? ORDER BY t0.name_original ASC

Parameters:

[
  3
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.name_original AS name_original_3,
  t0.mime_type AS mime_type_4,
  t0.path AS path_5,
  t0.path_base AS path_base_6,
  t0.category AS category_7,
  t0.vehicle_id AS vehicle_id_8,
  t0.article_id AS article_id_9
FROM
  file t0
WHERE
  t0.article_id = ?
ORDER BY
  t0.name_original ASC

SELECT t0.id AS id_1, t0.name AS name_2, t0.name_original AS name_original_3, t0.mime_type AS mime_type_4, t0.path AS path_5, t0.path_base AS path_base_6, t0.category AS category_7, t0.vehicle_id AS vehicle_id_8, t0.article_id AS article_id_9 FROM file t0 WHERE t0.article_id = 3 ORDER BY t0.name_original ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1842)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1787)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 2706)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 636)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 186)
6	Doctrine\ORM\PersistentCollection->initialize (line 108)
7	Doctrine\Common\Collections\AbstractLazyCollection->containsKey (line 350)
8	Doctrine\ORM\PersistentCollection->containsKey (line 420)
9	Doctrine\ORM\PersistentCollection->offsetExists (line 1671)
10	Twig\Extension\CoreExtension::getAttribute (line 163)
11	__TwigTemplate_3fc406df716913e56a4b1d337f933779->doDisplay (line 388)
12	Twig\Template->yield (line 344)
13	Twig\Template->display (line 359)
14	Twig\Template->render (line 51)
15	Twig\TemplateWrapper->render (line 1493)
16	Twig\Extension\CoreExtension::include (line 144)
17	__TwigTemplate_a9915f700d40b1a1c31002f5b832fbc9->block_body (line 432)
18	Twig\Template->yieldBlock (line 101)
19	__TwigTemplate_e7dab5eb8a25f86a2312ccb26eabc1e6->doDisplay (line 388)
20	Twig\Template->yield (line 92)
21	__TwigTemplate_a9915f700d40b1a1c31002f5b832fbc9->doDisplay (line 388)
22	Twig\Template->yield (line 344)
23	Twig\Template->display (line 359)
24	Twig\Template->render (line 51)
25	Twig\TemplateWrapper->render (line 334)
26	Twig\Environment->render (line 431)
27	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
28	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
29	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 361)
30	App\Controller\MainController->articleList (line 183)
31	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
32	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
33	Symfony\Component\HttpKernel\Kernel->handle (line 35)
34	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
35	require_once (line 5)

1.31 ms

SELECT t0.id AS id_1, t0.name AS name_2, t0.name_original AS name_original_3, t0.mime_type AS mime_type_4, t0.path AS path_5, t0.path_base AS path_base_6, t0.category AS category_7, t0.vehicle_id AS vehicle_id_8, t0.article_id AS article_id_9 FROM file t0 WHERE t0.article_id = ? ORDER BY t0.name_original ASC

Parameters:

[
  2
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.name_original AS name_original_3,
  t0.mime_type AS mime_type_4,
  t0.path AS path_5,
  t0.path_base AS path_base_6,
  t0.category AS category_7,
  t0.vehicle_id AS vehicle_id_8,
  t0.article_id AS article_id_9
FROM
  file t0
WHERE
  t0.article_id = ?
ORDER BY
  t0.name_original ASC

SELECT t0.id AS id_1, t0.name AS name_2, t0.name_original AS name_original_3, t0.mime_type AS mime_type_4, t0.path AS path_5, t0.path_base AS path_base_6, t0.category AS category_7, t0.vehicle_id AS vehicle_id_8, t0.article_id AS article_id_9 FROM file t0 WHERE t0.article_id = 2 ORDER BY t0.name_original ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1842)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1787)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 2706)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 636)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 186)
6	Doctrine\ORM\PersistentCollection->initialize (line 108)
7	Doctrine\Common\Collections\AbstractLazyCollection->containsKey (line 350)
8	Doctrine\ORM\PersistentCollection->containsKey (line 420)
9	Doctrine\ORM\PersistentCollection->offsetExists (line 1671)
10	Twig\Extension\CoreExtension::getAttribute (line 163)
11	__TwigTemplate_3fc406df716913e56a4b1d337f933779->doDisplay (line 388)
12	Twig\Template->yield (line 344)
13	Twig\Template->display (line 359)
14	Twig\Template->render (line 51)
15	Twig\TemplateWrapper->render (line 1493)
16	Twig\Extension\CoreExtension::include (line 144)
17	__TwigTemplate_a9915f700d40b1a1c31002f5b832fbc9->block_body (line 432)
18	Twig\Template->yieldBlock (line 101)
19	__TwigTemplate_e7dab5eb8a25f86a2312ccb26eabc1e6->doDisplay (line 388)
20	Twig\Template->yield (line 92)
21	__TwigTemplate_a9915f700d40b1a1c31002f5b832fbc9->doDisplay (line 388)
22	Twig\Template->yield (line 344)
23	Twig\Template->display (line 359)
24	Twig\Template->render (line 51)
25	Twig\TemplateWrapper->render (line 334)
26	Twig\Environment->render (line 431)
27	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
28	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
29	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 361)
30	App\Controller\MainController->articleList (line 183)
31	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
32	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
33	Symfony\Component\HttpKernel\Kernel->handle (line 35)
34	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
35	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\File	7
App\Entity\Article	2

Entities Mapping

Class	Mapping errors
App\Entity\Article	No errors.
App\Entity\File	No errors.
App\Entity\Vehicle	No errors.

Symfony Profiler

GET https://tcc.se-ck.de/_fragment?_path=_format%3Dhtml%26_locale%3Den%26_controller%3DApp%255CController%255CMainController%253A%253Afooter

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping