Symfony Profiler

Query Metrics

3 Database Queries

3 Different statements

0.80 ms Query time

0 Invalid entities

Queries

Group similar statements

#▲

Time

Info

0.39 ms

SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.slug AS slug_2, p0_.summary AS summary_3, p0_.content AS content_4, p0_.published_at AS published_at_5, p0_.author_id AS author_id_6, p0_.main_photo_id AS main_photo_id_7 FROM post p0_ WHERE p0_.slug LIKE ?

Parameters:

[
  "dopravne-inzenyrske-dny-2023"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.id AS id_0,
  p0_.title AS title_1,
  p0_.slug AS slug_2,
  p0_.summary AS summary_3,
  p0_.content AS content_4,
  p0_.published_at AS published_at_5,
  p0_.author_id AS author_id_6,
  p0_.main_photo_id AS main_photo_id_7
FROM
  post p0_
WHERE
  p0_.slug LIKE ?

SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.slug AS slug_2, p0_.summary AS summary_3, p0_.content AS content_4, p0_.published_at AS published_at_5, p0_.author_id AS author_id_6, p0_.main_photo_id AS main_photo_id_7 FROM post p0_ WHERE p0_.slug LIKE 'dopravne-inzenyrske-dny-2023';

#	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 738)
6	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 78)
7	App\Repository\PostRepository->findOneBySlug (line 239)
8	App\Controller\PostController->post_detail (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)

0.21 ms

SELECT t0.id AS id_1, t0.file_name AS file_name_2, t0.uri AS uri_3, t0.file_mime AS file_mime_4, t0.file_size AS file_size_5, t0.created_at AS created_at_6, t0.modul_id AS modul_id_7, t0.post_images_id AS post_images_id_8, t0.release_notification_id AS release_notification_id_9 FROM file_managed t0 WHERE t0.id = ?

Parameters:

[
  41
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.file_name AS file_name_2,
  t0.uri AS uri_3,
  t0.file_mime AS file_mime_4,
  t0.file_size AS file_size_5,
  t0.created_at AS created_at_6,
  t0.modul_id AS modul_id_7,
  t0.post_images_id AS post_images_id_8,
  t0.release_notification_id AS release_notification_id_9
FROM
  file_managed t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.file_name AS file_name_2, t0.uri AS uri_3, t0.file_mime AS file_mime_4, t0.file_size AS file_size_5, t0.created_at AS created_at_6, t0.modul_id AS modul_id_7, t0.post_images_id AS post_images_id_8, t0.release_notification_id AS release_notification_id_9 FROM file_managed t0 WHERE t0.id = 41;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 736)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 754)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 220)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 286)
5	Proxies\__CG__\App\Entity\FileManaged::Doctrine\ORM\Proxy\{closure} (line 59)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 129)
7	Proxies\__CG__\App\Entity\FileManaged->__get (line 77)
8	App\Entity\FileManaged->getUri (line 1882)
9	Twig\Extension\CoreExtension::getAttribute (line 51)
10	__TwigTemplate_92c6c9e712cf2a1b93bf33b33549af97->doDisplay (line 388)
11	Twig\Template->yield (line 56)
12	__TwigTemplate_2af8d5657714eb142e09a44e741b12fa->doDisplay (line 388)
13	Twig\Template->yield (line 152)
14	__TwigTemplate_ecc82127130dad21b0e146173fb9f1f0->doDisplay (line 388)
15	Twig\Template->yield (line 344)
16	Twig\Template->display (line 359)
17	Twig\Template->render (line 51)
18	Twig\TemplateWrapper->render (line 334)
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 241)
23	App\Controller\PostController->post_detail (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.19 ms

SELECT t0.id AS id_1, t0.file_name AS file_name_2, t0.uri AS uri_3, t0.file_mime AS file_mime_4, t0.file_size AS file_size_5, t0.created_at AS created_at_6, t0.modul_id AS modul_id_7, t0.post_images_id AS post_images_id_8, t0.release_notification_id AS release_notification_id_9 FROM file_managed t0 WHERE t0.post_images_id = ?

Parameters:

[
  22
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.file_name AS file_name_2,
  t0.uri AS uri_3,
  t0.file_mime AS file_mime_4,
  t0.file_size AS file_size_5,
  t0.created_at AS created_at_6,
  t0.modul_id AS modul_id_7,
  t0.post_images_id AS post_images_id_8,
  t0.release_notification_id AS release_notification_id_9
FROM
  file_managed t0
WHERE
  t0.post_images_id = ?

SELECT t0.id AS id_1, t0.file_name AS file_name_2, t0.uri AS uri_3, t0.file_mime AS file_mime_4, t0.file_size AS file_size_5, t0.created_at AS created_at_6, t0.modul_id AS modul_id_7, t0.post_images_id AS post_images_id_8, t0.release_notification_id AS release_notification_id_9 FROM file_managed t0 WHERE t0.post_images_id = 22;

#	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 39)
7	Doctrine\Common\Collections\AbstractLazyCollection->count (line 391)
8	Doctrine\ORM\PersistentCollection->count (line 72)
9	__TwigTemplate_2af8d5657714eb142e09a44e741b12fa->doDisplay (line 388)
10	Twig\Template->yield (line 152)
11	__TwigTemplate_ecc82127130dad21b0e146173fb9f1f0->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 334)
16	Twig\Environment->render (line 431)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 241)
20	App\Controller\PostController->post_detail (line 183)
21	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
22	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
23	Symfony\Component\HttpKernel\Kernel->handle (line 35)
24	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
25	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.

Entities Mapping

Class	Mapping errors
App\Entity\Post	No errors.
App\Entity\User	No errors.
App\Entity\FileManaged	No errors.
App\Entity\Comment	No errors.
App\Entity\Tag	No errors.
App\Entity\Modul	No errors.
App\Entity\ReleaseNotification	No errors.

Symfony Profiler

GET https://devedip.aeto.cz/aktuality/dopravne-inzenyrske-dny-2023

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Entities Mapping