Symfony Profiler

Query Metrics

5 Database Queries

3 Different statements

2.73 ms Query time

0 Invalid entities

6 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

1.37 ms
(50.15%)

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:

[
  3
]

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 = 3;

#	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	__TwigTemplate_a309fdb1a0fb61eea7f92d4013254c4c->block_content (line 165)
9	Twig\Template->yieldBlock (line 446)
10	__TwigTemplate_7c6d4f0ae6dd601cb6c1a33a0cc6c370->block_main (line 86)
11	Twig\Template->yieldBlock (line 446)
12	__TwigTemplate_6d0f842980170b6fc241f22674b87d23->block_body (line 303)
13	Twig\Template->yieldBlock (line 446)
14	__TwigTemplate_6d0f842980170b6fc241f22674b87d23->doDisplay (line 86)
15	Twig\Template->yield (line 402)
16	__TwigTemplate_7c6d4f0ae6dd601cb6c1a33a0cc6c370->doDisplay (line 55)
17	Twig\Template->yield (line 402)
18	__TwigTemplate_a309fdb1a0fb61eea7f92d4013254c4c->doDisplay (line 55)
19	Twig\Template->yield (line 402)
20	Twig\Template->display (line 358)
21	Twig\Template->render (line 373)
22	Twig\TemplateWrapper->render (line 51)
23	Twig\Environment->render (line 333)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 459)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 464)
26	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 278)
27	App\Controller\EventCategoryController->index (line 19)
28	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
29	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
30	Symfony\Component\HttpKernel\Kernel->handle (line 182)
31	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
32	require_once (line 29)
33	require_once (line 5)

0.99 ms
(36.37%)

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.id = ?

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.description AS description_3,
  t0.is_active AS is_active_4,
  t0.category_type AS category_type_5
FROM
  post_category t0
WHERE
  t0.id = ?

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.id = 3;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 740)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 758)
3	Doctrine\ORM\EntityManager->find (line 366)
4	Doctrine\ORM\EntityRepository->find (line 86)
5	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->find (line 61)
6	App\Controller\EventCategoryController->index (line 17)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
9	Symfony\Component\HttpKernel\Kernel->handle (line 182)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
11	require_once (line 29)
12	require_once (line 5)

0.37 ms
(13.49%)

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_a309fdb1a0fb61eea7f92d4013254c4c->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\EventCategoryController->index (line 19)
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)

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\PostCategory	3
App\Entity\Post	1
App\Entity\User	1
App\Entity\PostStatus	1

Entities Mapping

Class	Mapping errors
App\Entity\PostCategory	No errors.
App\Entity\Post	No errors.
App\Entity\User	No errors.
App\Entity\PostStatus	No errors.
App\Entity\Region	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/wydarzenia/3

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping