Symfony Profiler

Query Metrics

10 Database Queries

7 Different statements

70.34 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

66.47 ms
(94.50%)

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 52)
14	__TwigTemplate_4f7d04edbc9fac0bf875fe4ebecbcb18->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 53)
22	App\Controller\BlogController->show (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)

1.23 ms
(1.75%)

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 52)
10	__TwigTemplate_4f7d04edbc9fac0bf875fe4ebecbcb18->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 53)
18	App\Controller\BlogController->show (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.94 ms
(1.34%)

SELECT t0.title_pl AS title_pl_1, t0.title_en AS title_en_2, t0.slug_pl AS slug_pl_3, t0.slug_en AS slug_en_4, t0.meta_title_pl AS meta_title_pl_5, t0.meta_title_en AS meta_title_en_6, t0.meta_description_pl AS meta_description_pl_7, t0.meta_description_en AS meta_description_en_8, t0.content_pl AS content_pl_9, t0.content_en AS content_en_10, t0.id AS id_11, t0.cover_image_name AS cover_image_name_12, t0.status AS status_13, t0.published_at AS published_at_14 FROM post t0 WHERE t0.slug_pl = ? LIMIT 1

Parameters:

[
  "molestiae-accusamus-ex-similique-non-provident"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.title_pl AS title_pl_1,
  t0.title_en AS title_en_2,
  t0.slug_pl AS slug_pl_3,
  t0.slug_en AS slug_en_4,
  t0.meta_title_pl AS meta_title_pl_5,
  t0.meta_title_en AS meta_title_en_6,
  t0.meta_description_pl AS meta_description_pl_7,
  t0.meta_description_en AS meta_description_en_8,
  t0.content_pl AS content_pl_9,
  t0.content_en AS content_en_10,
  t0.id AS id_11,
  t0.cover_image_name AS cover_image_name_12,
  t0.status AS status_13,
  t0.published_at AS published_at_14
FROM
  post t0
WHERE
  t0.slug_pl = ?
LIMIT
  1

SELECT t0.title_pl AS title_pl_1, t0.title_en AS title_en_2, t0.slug_pl AS slug_pl_3, t0.slug_en AS slug_en_4, t0.meta_title_pl AS meta_title_pl_5, t0.meta_title_en AS meta_title_en_6, t0.meta_description_pl AS meta_description_pl_7, t0.meta_description_en AS meta_description_en_8, t0.content_pl AS content_pl_9, t0.content_en AS content_en_10, t0.id AS id_11, t0.cover_image_name AS cover_image_name_12, t0.status AS status_13, t0.published_at AS published_at_14 FROM post t0 WHERE t0.slug_pl = 'molestiae-accusamus-ex-similique-non-provident' 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 69)
4	Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->resolve (line 60)
5	Symfony\Component\HttpKernel\Controller\ArgumentResolver\TraceableValueResolver->resolve (line 91)
6	Symfony\Component\HttpKernel\Controller\ArgumentResolver->getArguments (line 40)
7	Symfony\Component\HttpKernel\Controller\TraceableArgumentResolver->getArguments (line 173)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
10	Symfony\Component\HttpKernel\Kernel->handle (line 35)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
12	require_once (line 5)

0.46 ms
(0.66%)

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 INNER JOIN post_tag ON t0.id = post_tag.tag_id WHERE post_tag.post_id = ?

Parameters:

[
  19
]

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
  INNER JOIN post_tag ON t0.id = post_tag.tag_id
WHERE
  post_tag.post_id = ?

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 INNER JOIN post_tag ON t0.id = post_tag.tag_id WHERE post_tag.post_id = 19;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1092)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getManyToManyStatement (line 1014)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadManyToManyCollection (line 3305)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 706)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 218)
6	Doctrine\ORM\PersistentCollection->initialize (line 313)
7	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 1)
8	iterator_to_array (line 1249)
9	Twig\Extension\CoreExtension::toArray (line 740)
10	Twig\Extension\CoreExtension::join (line 111)
11	__TwigTemplate_4f7d04edbc9fac0bf875fe4ebecbcb18->block_meta_keywords (line 430)
12	Twig\Template->yieldBlock (line 72)
13	__TwigTemplate_e0ee5184198a7aa5f147595207515f62->doDisplay (line 360)
14	Twig\Template->yield (line 51)
15	__TwigTemplate_5dd7f9619e15505c76460be2c5e79935->doDisplay (line 360)
16	Twig\Template->yield (line 52)
17	__TwigTemplate_4f7d04edbc9fac0bf875fe4ebecbcb18->doDisplay (line 360)
18	Twig\Template->yield (line 335)
19	Twig\Template->render (line 38)
20	Twig\TemplateWrapper->render (line 307)
21	Twig\Environment->render (line 448)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 53)
25	App\Controller\BlogController->show (line 181)
26	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
27	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
28	Symfony\Component\HttpKernel\Kernel->handle (line 35)
29	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
30	require_once (line 5)

0.44 ms
(0.63%)

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 INNER JOIN post_category ON t0.id = post_category.category_id WHERE post_category.post_id = ?

Parameters:

[
  19
]

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
  INNER JOIN post_category ON t0.id = post_category.category_id
WHERE
  post_category.post_id = ?

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 INNER JOIN post_category ON t0.id = post_category.category_id WHERE post_category.post_id = 19;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1092)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getManyToManyStatement (line 1014)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadManyToManyCollection (line 3305)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 706)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 218)
6	Doctrine\ORM\PersistentCollection->initialize (line 313)
7	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 172)
8	__TwigTemplate_4f7d04edbc9fac0bf875fe4ebecbcb18->block_blog_content (line 430)
9	Twig\Template->yieldBlock (line 76)
10	__TwigTemplate_5dd7f9619e15505c76460be2c5e79935->block_body (line 430)
11	Twig\Template->yieldBlock (line 491)
12	__TwigTemplate_e0ee5184198a7aa5f147595207515f62->doDisplay (line 360)
13	Twig\Template->yield (line 51)
14	__TwigTemplate_5dd7f9619e15505c76460be2c5e79935->doDisplay (line 360)
15	Twig\Template->yield (line 52)
16	__TwigTemplate_4f7d04edbc9fac0bf875fe4ebecbcb18->doDisplay (line 360)
17	Twig\Template->yield (line 335)
18	Twig\Template->render (line 38)
19	Twig\TemplateWrapper->render (line 307)
20	Twig\Environment->render (line 448)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 53)
24	App\Controller\BlogController->show (line 181)
25	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
26	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
27	Symfony\Component\HttpKernel\Kernel->handle (line 35)
28	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
29	require_once (line 5)

0.42 ms
(0.59%)

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 55)
5	App\Controller\BlogController->show (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.37 ms
(0.52%)

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 52)
14	__TwigTemplate_4f7d04edbc9fac0bf875fe4ebecbcb18->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 53)
22	App\Controller\BlogController->show (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)

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://www.sharelocked.you2.pl/en/blog/molestiae-accusamus-ex-similique-non-provident

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping