Symfony Profiler

Query Metrics

10 Database Queries

7 Different statements

5.28 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

1.38 ms
(26.12%)

SELECT COUNT(DISTINCT p0_.id) AS sclr_0 FROM post p0_ WHERE p0_.status = ? AND p0_.published_at <= ?

Parameters:

[
  "published"
  "2026-03-21 09:02:47"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(DISTINCT p0_.id) AS sclr_0
FROM
  post p0_
WHERE
  p0_.status = ?
  AND p0_.published_at <= ?

SELECT COUNT(DISTINCT p0_.id) AS sclr_0 FROM post p0_ WHERE p0_.status = 'published' AND p0_.published_at <= '2026-03-21 09:02:47';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 33)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 327)
3	Doctrine\ORM\Query->_doExecute (line 1212)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1166)
5	Doctrine\ORM\AbstractQuery->execute (line 937)
6	Doctrine\ORM\AbstractQuery->getScalarResult (line 120)
7	Doctrine\ORM\Tools\Pagination\Paginator->count (line 1)
8	count (line 43)
9	Knp\Component\Pager\Event\Subscriber\Paginate\Doctrine\ORM\QuerySubscriber->items (line 116)
10	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
11	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
12	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 139)
13	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 97)
14	Knp\Component\Pager\Paginator->paginate (line 25)
15	ContainerJLJAGPJ\PaginatorProxy9cc2a8f->paginate (line 33)
16	App\Controller\BlogController->index (line 181)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
19	Symfony\Component\HttpKernel\Kernel->handle (line 35)
20	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
21	require_once (line 5)

1.28 ms
(24.24%)

SELECT t0.id AS id_1, t0.city AS city_2, t0.popup_image_name AS popup_image_name_3, t0.updated_at AS updated_at_4, t0.name AS name_5, t0.post_code AS post_code_6, t0.street AS street_7, t0.phone AS phone_8, t0.email AS email_9, t0.instagram_url AS instagram_url_10, t0.minimum_booking_notice_hours AS minimum_booking_notice_hours_11 FROM place t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.city AS city_2,
  t0.popup_image_name AS popup_image_name_3,
  t0.updated_at AS updated_at_4,
  t0.name AS name_5,
  t0.post_code AS post_code_6,
  t0.street AS street_7,
  t0.phone AS phone_8,
  t0.email AS email_9,
  t0.instagram_url AS instagram_url_10,
  t0.minimum_booking_notice_hours AS minimum_booking_notice_hours_11
FROM
  place t0

SELECT t0.id AS id_1, t0.city AS city_2, t0.popup_image_name AS popup_image_name_3, t0.updated_at AS updated_at_4, t0.name AS name_5, t0.post_code AS post_code_6, t0.street AS street_7, t0.phone AS phone_8, t0.email AS email_9, t0.instagram_url AS instagram_url_10, t0.minimum_booking_notice_hours AS minimum_booking_notice_hours_11 FROM place t0;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 944)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 225)
3	Doctrine\ORM\EntityRepository->findBy (line 207)
4	Doctrine\ORM\EntityRepository->findAll (line 30)
5	App\Twig\PlaceExtension->getAllPlaces (line 257)
6	__TwigTemplate_e0ee5184198a7aa5f147595207515f62->doDisplay (line 360)
7	Twig\Template->yield (line 51)
8	__TwigTemplate_5dd7f9619e15505c76460be2c5e79935->doDisplay (line 360)
9	Twig\Template->yield (line 51)
10	__TwigTemplate_afff84423a9c54362a548903c50c459b->doDisplay (line 360)
11	Twig\Template->yield (line 335)
12	Twig\Template->render (line 38)
13	Twig\TemplateWrapper->render (line 307)
14	Twig\Environment->render (line 448)
15	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
16	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 39)
18	App\Controller\BlogController->index (line 181)
19	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
20	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
21	Symfony\Component\HttpKernel\Kernel->handle (line 35)
22	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
23	require_once (line 5)

0.65 ms
(12.33%)

SELECT t0.id AS id_1, t0.cash AS cash_2, t0.full AS full_3, t0.advance AS advance_4, t0.voucher AS voucher_5, t0.regulations_name AS regulations_name_6, t0.privacy_policy_name AS privacy_policy_name_7, t0.updated_at AS updated_at_8, t0.facebook_url AS facebook_url_9, t0.instagram_url AS instagram_url_10, t0.tiktok_url AS tiktok_url_11, t0.youtube_url AS youtube_url_12, t0.admin_email AS admin_email_13, t0.place_id AS place_id_14 FROM configuration t0 WHERE t0.place_id IS NULL LIMIT 1

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.cash AS cash_2,
  t0.full AS full_3,
  t0.advance AS advance_4,
  t0.voucher AS voucher_5,
  t0.regulations_name AS regulations_name_6,
  t0.privacy_policy_name AS privacy_policy_name_7,
  t0.updated_at AS updated_at_8,
  t0.facebook_url AS facebook_url_9,
  t0.instagram_url AS instagram_url_10,
  t0.tiktok_url AS tiktok_url_11,
  t0.youtube_url AS youtube_url_12,
  t0.admin_email AS admin_email_13,
  t0.place_id AS place_id_14
FROM
  configuration t0
WHERE
  t0.place_id IS NULL
LIMIT
  1

SELECT t0.id AS id_1, t0.cash AS cash_2, t0.full AS full_3, t0.advance AS advance_4, t0.voucher AS voucher_5, t0.regulations_name AS regulations_name_6, t0.privacy_policy_name AS privacy_policy_name_7, t0.updated_at AS updated_at_8, t0.facebook_url AS facebook_url_9, t0.instagram_url AS instagram_url_10, t0.tiktok_url AS tiktok_url_11, t0.youtube_url AS youtube_url_12, t0.admin_email AS admin_email_13, t0.place_id AS place_id_14 FROM configuration t0 WHERE t0.place_id IS NULL LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 776)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 241)
3	Doctrine\ORM\EntityRepository->findOneBy (line 125)
4	App\Controller\BlogController->resolveConfiguration (line 41)
5	App\Controller\BlogController->index (line 181)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
8	Symfony\Component\HttpKernel\Kernel->handle (line 35)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
10	require_once (line 5)

0.56 ms
(10.59%)

SELECT p0_.title_pl AS title_pl_0, p0_.title_en AS title_en_1, p0_.slug_pl AS slug_pl_2, p0_.slug_en AS slug_en_3, p0_.meta_title_pl AS meta_title_pl_4, p0_.meta_title_en AS meta_title_en_5, p0_.meta_description_pl AS meta_description_pl_6, p0_.meta_description_en AS meta_description_en_7, p0_.content_pl AS content_pl_8, p0_.content_en AS content_en_9, p0_.id AS id_10, p0_.cover_image_name AS cover_image_name_11, p0_.status AS status_12, p0_.published_at AS published_at_13 FROM post p0_ WHERE p0_.status = ? AND p0_.published_at <= ? AND p0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY p0_.published_at DESC

Parameters:

[
  "published"
  "2026-03-21 09:02:47"
  3
  4
  10
  15
  5
  1
  20
  17
  19
  7
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.title_pl AS title_pl_0,
  p0_.title_en AS title_en_1,
  p0_.slug_pl AS slug_pl_2,
  p0_.slug_en AS slug_en_3,
  p0_.meta_title_pl AS meta_title_pl_4,
  p0_.meta_title_en AS meta_title_en_5,
  p0_.meta_description_pl AS meta_description_pl_6,
  p0_.meta_description_en AS meta_description_en_7,
  p0_.content_pl AS content_pl_8,
  p0_.content_en AS content_en_9,
  p0_.id AS id_10,
  p0_.cover_image_name AS cover_image_name_11,
  p0_.status AS status_12,
  p0_.published_at AS published_at_13
FROM
  post p0_
WHERE
  p0_.status = ?
  AND p0_.published_at <= ?
  AND p0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
ORDER BY
  p0_.published_at DESC

SELECT p0_.title_pl AS title_pl_0, p0_.title_en AS title_en_1, p0_.slug_pl AS slug_pl_2, p0_.slug_en AS slug_en_3, p0_.meta_title_pl AS meta_title_pl_4, p0_.meta_title_en AS meta_title_en_5, p0_.meta_description_pl AS meta_description_pl_6, p0_.meta_description_en AS meta_description_en_7, p0_.content_pl AS content_pl_8, p0_.content_en AS content_en_9, p0_.id AS id_10, p0_.cover_image_name AS cover_image_name_11, p0_.status AS status_12, p0_.published_at AS published_at_13 FROM post p0_ WHERE p0_.status = 'published' AND p0_.published_at <= '2026-03-21 09:02:47' AND p0_.id IN (3, 4, 10, 15, 5, 1, 20, 17, 19, 7) ORDER BY p0_.published_at DESC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 33)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 327)
3	Doctrine\ORM\Query->_doExecute (line 1212)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1166)
5	Doctrine\ORM\AbstractQuery->execute (line 901)
6	Doctrine\ORM\AbstractQuery->getResult (line 171)
7	Doctrine\ORM\Tools\Pagination\Paginator->getIterator (line 1)
8	iterator_to_array (line 45)
9	Knp\Component\Pager\Event\Subscriber\Paginate\Doctrine\ORM\QuerySubscriber->items (line 116)
10	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
11	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
12	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 139)
13	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 97)
14	Knp\Component\Pager\Paginator->paginate (line 25)
15	ContainerJLJAGPJ\PaginatorProxy9cc2a8f->paginate (line 33)
16	App\Controller\BlogController->index (line 181)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
19	Symfony\Component\HttpKernel\Kernel->handle (line 35)
20	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
21	require_once (line 5)

0.55 ms
(10.45%)

SELECT t0.name_pl AS name_pl_1, t0.name_en AS name_en_2, t0.slug_pl AS slug_pl_3, t0.slug_en AS slug_en_4, t0.id AS id_5 FROM category t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.name_pl AS name_pl_1,
  t0.name_en AS name_en_2,
  t0.slug_pl AS slug_pl_3,
  t0.slug_en AS slug_en_4,
  t0.id AS id_5
FROM
  category t0

SELECT t0.name_pl AS name_pl_1, t0.name_en AS name_en_2, t0.slug_pl AS slug_pl_3, t0.slug_en AS slug_en_4, t0.id AS id_5 FROM category t0;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 944)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 225)
3	Doctrine\ORM\EntityRepository->findBy (line 207)
4	Doctrine\ORM\EntityRepository->findAll (line 27)
5	App\Twig\Extension\BlogExtension->getAllCategories (line 441)
6	__TwigTemplate_5dd7f9619e15505c76460be2c5e79935->block_blog_sidebar (line 430)
7	Twig\Template->yieldBlock (line 82)
8	__TwigTemplate_5dd7f9619e15505c76460be2c5e79935->block_body (line 430)
9	Twig\Template->yieldBlock (line 491)
10	__TwigTemplate_e0ee5184198a7aa5f147595207515f62->doDisplay (line 360)
11	Twig\Template->yield (line 51)
12	__TwigTemplate_5dd7f9619e15505c76460be2c5e79935->doDisplay (line 360)
13	Twig\Template->yield (line 51)
14	__TwigTemplate_afff84423a9c54362a548903c50c459b->doDisplay (line 360)
15	Twig\Template->yield (line 335)
16	Twig\Template->render (line 38)
17	Twig\TemplateWrapper->render (line 307)
18	Twig\Environment->render (line 448)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 39)
22	App\Controller\BlogController->index (line 181)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
25	Symfony\Component\HttpKernel\Kernel->handle (line 35)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
27	require_once (line 5)

0.47 ms
(8.94%)

SELECT t0.name_pl AS name_pl_1, t0.name_en AS name_en_2, t0.slug_pl AS slug_pl_3, t0.slug_en AS slug_en_4, t0.id AS id_5 FROM tag t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.name_pl AS name_pl_1,
  t0.name_en AS name_en_2,
  t0.slug_pl AS slug_pl_3,
  t0.slug_en AS slug_en_4,
  t0.id AS id_5
FROM
  tag t0

SELECT t0.name_pl AS name_pl_1, t0.name_en AS name_en_2, t0.slug_pl AS slug_pl_3, t0.slug_en AS slug_en_4, t0.id AS id_5 FROM tag t0;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 944)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 225)
3	Doctrine\ORM\EntityRepository->findBy (line 207)
4	Doctrine\ORM\EntityRepository->findAll (line 32)
5	App\Twig\Extension\BlogExtension->getAllTags (line 462)
6	__TwigTemplate_5dd7f9619e15505c76460be2c5e79935->block_blog_sidebar (line 430)
7	Twig\Template->yieldBlock (line 82)
8	__TwigTemplate_5dd7f9619e15505c76460be2c5e79935->block_body (line 430)
9	Twig\Template->yieldBlock (line 491)
10	__TwigTemplate_e0ee5184198a7aa5f147595207515f62->doDisplay (line 360)
11	Twig\Template->yield (line 51)
12	__TwigTemplate_5dd7f9619e15505c76460be2c5e79935->doDisplay (line 360)
13	Twig\Template->yield (line 51)
14	__TwigTemplate_afff84423a9c54362a548903c50c459b->doDisplay (line 360)
15	Twig\Template->yield (line 335)
16	Twig\Template->render (line 38)
17	Twig\TemplateWrapper->render (line 307)
18	Twig\Environment->render (line 448)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 39)
22	App\Controller\BlogController->index (line 181)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
25	Symfony\Component\HttpKernel\Kernel->handle (line 35)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
27	require_once (line 5)

0.39 ms
(7.33%)

SELECT DISTINCT p0_.id AS id_0, p0_.published_at AS published_at_1 FROM post p0_ WHERE p0_.status = ? AND p0_.published_at <= ? ORDER BY p0_.published_at DESC LIMIT 10

Parameters:

[
  "published"
  "2026-03-21 09:02:47"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT p0_.id AS id_0,
  p0_.published_at AS published_at_1
FROM
  post p0_
WHERE
  p0_.status = ?
  AND p0_.published_at <= ?
ORDER BY
  p0_.published_at DESC
LIMIT
  10

SELECT DISTINCT p0_.id AS id_0, p0_.published_at AS published_at_1 FROM post p0_ WHERE p0_.status = 'published' AND p0_.published_at <= '2026-03-21 09:02:47' ORDER BY p0_.published_at DESC LIMIT 10;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 33)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 327)
3	Doctrine\ORM\Query->_doExecute (line 1212)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1166)
5	Doctrine\ORM\AbstractQuery->execute (line 937)
6	Doctrine\ORM\AbstractQuery->getScalarResult (line 153)
7	Doctrine\ORM\Tools\Pagination\Paginator->getIterator (line 1)
8	iterator_to_array (line 45)
9	Knp\Component\Pager\Event\Subscriber\Paginate\Doctrine\ORM\QuerySubscriber->items (line 116)
10	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
11	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
12	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 139)
13	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 97)
14	Knp\Component\Pager\Paginator->paginate (line 25)
15	ContainerJLJAGPJ\PaginatorProxy9cc2a8f->paginate (line 33)
16	App\Controller\BlogController->index (line 181)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
19	Symfony\Component\HttpKernel\Kernel->handle (line 35)
20	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
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.

Entities Mapping

Class	Mapping errors
App\Entity\Post	No errors.
App\Entity\Category	No errors.
App\Entity\Tag	No errors.
App\Entity\Configuration	No errors.
App\Entity\Place	No errors.
App\Entity\Room	No errors.

Symfony Profiler

GET https://sharelocked.you2.pl/pl/blog

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping