Symfony Profiler

Query Metrics

7 Database Queries

5 Different statements

3.17 ms Query time

0 Invalid entities

11 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

1.32 ms
(41.52%)

SELECT DISTINCT p0_.id AS id_0, p0_.date_add AS date_add_1 FROM post p0_ WHERE p0_.post_type = ? ORDER BY p0_.date_add ASC LIMIT 10

Parameters:

[
  "post"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT p0_.id AS id_0,
  p0_.date_add AS date_add_1
FROM
  post p0_
WHERE
  p0_.post_type = ?
ORDER BY
  p0_.date_add ASC
LIMIT
  10

SELECT DISTINCT p0_.id AS id_0, p0_.date_add AS date_add_1 FROM post p0_ WHERE p0_.post_type = 'post' ORDER BY p0_.date_add ASC LIMIT 10;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 935)
4	Doctrine\ORM\AbstractQuery->execute (line 891)
5	Doctrine\ORM\AbstractQuery->getScalarResult (line 725)
6	Doctrine\ORM\Tools\Pagination\Paginator->getIterator (line 127)
7	App\Pagination\Paginator->paginate (line 50)
8	App\Repository\PostRepository->findLastNews (line 41)
9	App\Controller\NewsIndexController->index (line 16)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
12	Symfony\Component\HttpKernel\Kernel->handle (line 182)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
14	require_once (line 29)
15	require_once (line 5)

0.92 ms
(28.98%)

SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.thumbnail AS thumbnail_4, t0.short_content AS short_content_5, t0.content AS content_6, t0.date_add AS date_add_7, t0.date_upd AS date_upd_8, t0.date_pub AS date_pub_9, t0.post_type AS post_type_10, t0.post_meta AS post_meta_11, t0.event_start AS event_start_12, t0.event_end AS event_end_13, t0.gallery AS gallery_14, t0.user_id AS user_id_15, t0.status_id AS status_id_16, t0.region_id AS region_id_17, t0.parent_id AS parent_id_18 FROM post t0 INNER JOIN post_post_category ON t0.id = post_post_category.post_id WHERE post_post_category.post_category_id = ?

Parameters:

[
  2
]

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.thumbnail AS thumbnail_4,
  t0.short_content AS short_content_5,
  t0.content AS content_6,
  t0.date_add AS date_add_7,
  t0.date_upd AS date_upd_8,
  t0.date_pub AS date_pub_9,
  t0.post_type AS post_type_10,
  t0.post_meta AS post_meta_11,
  t0.event_start AS event_start_12,
  t0.event_end AS event_end_13,
  t0.gallery AS gallery_14,
  t0.user_id AS user_id_15,
  t0.status_id AS status_id_16,
  t0.region_id AS region_id_17,
  t0.parent_id AS parent_id_18
FROM
  post t0
  INNER JOIN post_post_category ON t0.id = post_post_category.post_id
WHERE
  post_post_category.post_category_id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.thumbnail AS thumbnail_4, t0.short_content AS short_content_5, t0.content AS content_6, t0.date_add AS date_add_7, t0.date_upd AS date_upd_8, t0.date_pub AS date_pub_9, t0.post_type AS post_type_10, t0.post_meta AS post_meta_11, t0.event_start AS event_start_12, t0.event_end AS event_end_13, t0.gallery AS gallery_14, t0.user_id AS user_id_15, t0.status_id AS status_id_16, t0.region_id AS region_id_17, t0.parent_id AS parent_id_18 FROM post t0 INNER JOIN post_post_category ON t0.id = post_post_category.post_id WHERE post_post_category.post_category_id = 2;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getManyToManyStatement (line 1085)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadManyToManyCollection (line 1014)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2726)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->count (line 39)
7	Doctrine\ORM\PersistentCollection->count (line 391)
8	Twig\Extension\CoreExtension->length (line 1272)
9	__TwigTemplate_b845e76005904979dd9962165ea029ec::doDisplay (line 73)
10	Twig\Template->yield (line 402)
11	Twig\Template->display (line 358)
12	Twig\Template->render (line 373)
13	Twig\TemplateWrapper->render (line 51)
14	Twig\Environment->render (line 333)
15	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 459)
16	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 464)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 278)
18	App\Controller\WidgetController->event_categories (line 23)
19	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
20	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
21	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler->handle (line 86)
22	Symfony\Component\HttpKernel\Fragment\InlineFragmentRenderer::render (line 75)
23	Symfony\Component\HttpKernel\Fragment\FragmentHandler->render (line 81)
24	Symfony\Component\HttpKernel\DependencyInjection\LazyLoadingFragmentHandler->render (line 46)
25	Symfony\Bridge\Twig\Extension\HttpKernelRuntime->renderFragment (line 41)
26	__TwigTemplate_7c6d4f0ae6dd601cb6c1a33a0cc6c370->block_sidebar (line 153)
27	Twig\Template->yieldBlock (line 446)
28	__TwigTemplate_7c6d4f0ae6dd601cb6c1a33a0cc6c370->block_main (line 93)
29	Twig\Template->yieldBlock (line 446)
30	__TwigTemplate_6d0f842980170b6fc241f22674b87d23->block_body (line 303)
31	Twig\Template->yieldBlock (line 446)
32	__TwigTemplate_6d0f842980170b6fc241f22674b87d23->doDisplay (line 86)
33	Twig\Template->yield (line 402)
34	__TwigTemplate_7c6d4f0ae6dd601cb6c1a33a0cc6c370->doDisplay (line 55)
35	Twig\Template->yield (line 402)
36	__TwigTemplate_fa7db3a8f2146b620a553c891b92e567->doDisplay (line 55)
37	Twig\Template->yield (line 402)
38	Twig\Template->display (line 358)
39	Twig\Template->render (line 373)
40	Twig\TemplateWrapper->render (line 51)
41	Twig\Environment->render (line 333)
42	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 459)
43	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 464)
44	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 278)
45	App\Controller\NewsIndexController->index (line 18)
46	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
47	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
48	Symfony\Component\HttpKernel\Kernel->handle (line 182)
49	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
50	require_once (line 29)
51	require_once (line 5)

0.37 ms
(11.56%)

SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.slug AS slug_2, p0_.thumbnail AS thumbnail_3, p0_.short_content AS short_content_4, p0_.content AS content_5, p0_.date_add AS date_add_6, p0_.date_upd AS date_upd_7, p0_.date_pub AS date_pub_8, p0_.post_type AS post_type_9, p0_.post_meta AS post_meta_10, p0_.event_start AS event_start_11, p0_.event_end AS event_end_12, p0_.gallery AS gallery_13, p0_.user_id AS user_id_14, p0_.status_id AS status_id_15, p0_.region_id AS region_id_16, p0_.parent_id AS parent_id_17 FROM post p0_ WHERE p0_.post_type = ? AND p0_.id IN (?, ?, ?, ?) ORDER BY p0_.date_add ASC

Parameters:

[
  "post"
  25
  24
  21
  17
]

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_.thumbnail AS thumbnail_3,
  p0_.short_content AS short_content_4,
  p0_.content AS content_5,
  p0_.date_add AS date_add_6,
  p0_.date_upd AS date_upd_7,
  p0_.date_pub AS date_pub_8,
  p0_.post_type AS post_type_9,
  p0_.post_meta AS post_meta_10,
  p0_.event_start AS event_start_11,
  p0_.event_end AS event_end_12,
  p0_.gallery AS gallery_13,
  p0_.user_id AS user_id_14,
  p0_.status_id AS status_id_15,
  p0_.region_id AS region_id_16,
  p0_.parent_id AS parent_id_17
FROM
  post p0_
WHERE
  p0_.post_type = ?
  AND p0_.id IN (?, ?, ?, ?)
ORDER BY
  p0_.date_add ASC

SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.slug AS slug_2, p0_.thumbnail AS thumbnail_3, p0_.short_content AS short_content_4, p0_.content AS content_5, p0_.date_add AS date_add_6, p0_.date_upd AS date_upd_7, p0_.date_pub AS date_pub_8, p0_.post_type AS post_type_9, p0_.post_meta AS post_meta_10, p0_.event_start AS event_start_11, p0_.event_end AS event_end_12, p0_.gallery AS gallery_13, p0_.user_id AS user_id_14, p0_.status_id AS status_id_15, p0_.region_id AS region_id_16, p0_.parent_id AS parent_id_17 FROM post p0_ WHERE p0_.post_type = 'post' AND p0_.id IN (25, 24, 21, 17) ORDER BY p0_.date_add ASC;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 935)
4	Doctrine\ORM\AbstractQuery->execute (line 891)
5	Doctrine\ORM\AbstractQuery->getResult (line 689)
6	Doctrine\ORM\Tools\Pagination\Paginator->getIterator (line 145)
7	App\Pagination\Paginator->paginate (line 50)
8	App\Repository\PostRepository->findLastNews (line 41)
9	App\Controller\NewsIndexController->index (line 16)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
12	Symfony\Component\HttpKernel\Kernel->handle (line 182)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
14	require_once (line 29)
15	require_once (line 5)

0.33 ms
(10.52%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.is_active AS is_active_4, t0.category_type AS category_type_5 FROM post_category t0 WHERE t0.is_active = ? AND t0.category_type = ?

Parameters:

[
  1
  "event"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.description AS description_3,
  t0.is_active AS is_active_4,
  t0.category_type AS category_type_5
FROM
  post_category t0
WHERE
  t0.is_active = ?
  AND t0.category_type = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.is_active AS is_active_4, t0.category_type AS category_type_5 FROM post_category t0 WHERE t0.is_active = 1 AND t0.category_type = 'event';

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 942)
2	Doctrine\ORM\EntityRepository->findBy (line 110)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 73)
4	App\Controller\WidgetController->event_categories (line 21)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
7	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler->handle (line 86)
8	Symfony\Component\HttpKernel\Fragment\InlineFragmentRenderer::render (line 75)
9	Symfony\Component\HttpKernel\Fragment\FragmentHandler->render (line 81)
10	Symfony\Component\HttpKernel\DependencyInjection\LazyLoadingFragmentHandler->render (line 46)
11	Symfony\Bridge\Twig\Extension\HttpKernelRuntime->renderFragment (line 41)
12	__TwigTemplate_7c6d4f0ae6dd601cb6c1a33a0cc6c370->block_sidebar (line 153)
13	Twig\Template->yieldBlock (line 446)
14	__TwigTemplate_7c6d4f0ae6dd601cb6c1a33a0cc6c370->block_main (line 93)
15	Twig\Template->yieldBlock (line 446)
16	__TwigTemplate_6d0f842980170b6fc241f22674b87d23->block_body (line 303)
17	Twig\Template->yieldBlock (line 446)
18	__TwigTemplate_6d0f842980170b6fc241f22674b87d23->doDisplay (line 86)
19	Twig\Template->yield (line 402)
20	__TwigTemplate_7c6d4f0ae6dd601cb6c1a33a0cc6c370->doDisplay (line 55)
21	Twig\Template->yield (line 402)
22	__TwigTemplate_fa7db3a8f2146b620a553c891b92e567->doDisplay (line 55)
23	Twig\Template->yield (line 402)
24	Twig\Template->display (line 358)
25	Twig\Template->render (line 373)
26	Twig\TemplateWrapper->render (line 51)
27	Twig\Environment->render (line 333)
28	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 459)
29	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 464)
30	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 278)
31	App\Controller\NewsIndexController->index (line 18)
32	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
33	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
34	Symfony\Component\HttpKernel\Kernel->handle (line 182)
35	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
36	require_once (line 29)
37	require_once (line 5)

0.24 ms
(7.42%)

SELECT count(*) AS sclr_0 FROM post p0_ WHERE p0_.post_type = ?

Parameters:

[
  "post"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  count(*) AS sclr_0
FROM
  post p0_
WHERE
  p0_.post_type = ?

SELECT count(*) AS sclr_0 FROM post p0_ WHERE p0_.post_type = 'post';

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 935)
4	Doctrine\ORM\AbstractQuery->execute (line 891)
5	Doctrine\ORM\AbstractQuery->getScalarResult (line 725)
6	Doctrine\ORM\Tools\Pagination\Paginator->count (line 96)
7	App\Pagination\Paginator->paginate (line 51)
8	App\Repository\PostRepository->findLastNews (line 41)
9	App\Controller\NewsIndexController->index (line 16)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
12	Symfony\Component\HttpKernel\Kernel->handle (line 182)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
14	require_once (line 29)
15	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\Post	5
App\Entity\PostCategory	3
App\Entity\User	2
App\Entity\PostStatus	1

Entities Mapping

Class	Mapping errors
App\Entity\Post	No errors.
App\Entity\User	No errors.
App\Entity\PostStatus	No errors.
App\Entity\Region	No errors.
App\Entity\PostCategory	No errors.
App\Entity\EventTicket	No errors.
App\Entity\Role	No errors.
App\Entity\Permission	No errors.
App\Entity\Company	No errors.
App\Entity\Contact	No errors.

Symfony Profiler

GET https://dev.gielda-eventow.pl/aktualnosci

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping