Symfony Profiler

Query Metrics

9 Database Queries

8 Different statements

3.02 ms Query time

0 Invalid entities

31 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

1.07 ms
(35.60%)

SELECT DISTINCT e0_.id AS id_0, e0_.name AS name_1, e0_.slug AS slug_2, e0_.description AS description_3, e0_.reference AS reference_4, e0_.views AS views_5, e0_.youtube_url AS youtube_url_6, e0_.external_link AS external_link_7, e0_.phone_number AS phone_number_8, e0_.email AS email_9, e0_.x AS x_10, e0_.instagram AS instagram_11, e0_.facebook AS facebook_12, e0_.linked_in AS linked_in_13, e0_.tags AS tags_14, e0_.artists AS artists_15, e0_.year AS year_16, e0_.image_name AS image_name_17, e0_.image_dimensions AS image_dimensions_18, e0_.created_at AS created_at_19, e0_.updated_at AS updated_at_20, e0_.published AS published_21, e0_.enable_reviews AS enable_reviews_22, e0_.show_attendees AS show_attendees_23, e0_.opponent_name AS opponent_name_24, e0_.journee AS journee_25, e0_.opponent_logo AS opponent_logo_26, e0_.category_id AS category_id_27, e0_.country_id AS country_id_28, e0_.organizer_id AS organizer_id_29, e0_.is_on_homepage_slider_id AS is_on_homepage_slider_id_30 FROM eventic_event e0_ LEFT JOIN eventic_event_date e1_ ON e0_.id = e1_.event_id LEFT JOIN eventic_venue e2_ ON e1_.venue_id = e2_.id LEFT JOIN eventic_organizer e3_ ON e0_.organizer_id = e3_.id LEFT JOIN eventic_user e4_ ON e3_.user_id = e4_.id WHERE e0_.published = ? AND e1_.start_date >= CURRENT_TIMESTAMP AND e4_.is_enabled = ? ORDER BY e1_.start_date ASC LIMIT 8

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT e0_.id AS id_0,
  e0_.name AS name_1,
  e0_.slug AS slug_2,
  e0_.description AS description_3,
  e0_.reference AS reference_4,
  e0_.views AS views_5,
  e0_.youtube_url AS youtube_url_6,
  e0_.external_link AS external_link_7,
  e0_.phone_number AS phone_number_8,
  e0_.email AS email_9,
  e0_.x AS x_10,
  e0_.instagram AS instagram_11,
  e0_.facebook AS facebook_12,
  e0_.linked_in AS linked_in_13,
  e0_.tags AS tags_14,
  e0_.artists AS artists_15,
  e0_.year AS year_16,
  e0_.image_name AS image_name_17,
  e0_.image_dimensions AS image_dimensions_18,
  e0_.created_at AS created_at_19,
  e0_.updated_at AS updated_at_20,
  e0_.published AS published_21,
  e0_.enable_reviews AS enable_reviews_22,
  e0_.show_attendees AS show_attendees_23,
  e0_.opponent_name AS opponent_name_24,
  e0_.journee AS journee_25,
  e0_.opponent_logo AS opponent_logo_26,
  e0_.category_id AS category_id_27,
  e0_.country_id AS country_id_28,
  e0_.organizer_id AS organizer_id_29,
  e0_.is_on_homepage_slider_id AS is_on_homepage_slider_id_30
FROM
  eventic_event e0_
  LEFT JOIN eventic_event_date e1_ ON e0_.id = e1_.event_id
  LEFT JOIN eventic_venue e2_ ON e1_.venue_id = e2_.id
  LEFT JOIN eventic_organizer e3_ ON e0_.organizer_id = e3_.id
  LEFT JOIN eventic_user e4_ ON e3_.user_id = e4_.id
WHERE
  e0_.published = ?
  AND e1_.start_date >= CURRENT_TIMESTAMP
  AND e4_.is_enabled = ?
ORDER BY
  e1_.start_date ASC
LIMIT
  8

SELECT DISTINCT e0_.id AS id_0, e0_.name AS name_1, e0_.slug AS slug_2, e0_.description AS description_3, e0_.reference AS reference_4, e0_.views AS views_5, e0_.youtube_url AS youtube_url_6, e0_.external_link AS external_link_7, e0_.phone_number AS phone_number_8, e0_.email AS email_9, e0_.x AS x_10, e0_.instagram AS instagram_11, e0_.facebook AS facebook_12, e0_.linked_in AS linked_in_13, e0_.tags AS tags_14, e0_.artists AS artists_15, e0_.year AS year_16, e0_.image_name AS image_name_17, e0_.image_dimensions AS image_dimensions_18, e0_.created_at AS created_at_19, e0_.updated_at AS updated_at_20, e0_.published AS published_21, e0_.enable_reviews AS enable_reviews_22, e0_.show_attendees AS show_attendees_23, e0_.opponent_name AS opponent_name_24, e0_.journee AS journee_25, e0_.opponent_logo AS opponent_logo_26, e0_.category_id AS category_id_27, e0_.country_id AS country_id_28, e0_.organizer_id AS organizer_id_29, e0_.is_on_homepage_slider_id AS is_on_homepage_slider_id_30 FROM eventic_event e0_ LEFT JOIN eventic_event_date e1_ ON e0_.id = e1_.event_id LEFT JOIN eventic_venue e2_ ON e1_.venue_id = e2_.id LEFT JOIN eventic_organizer e3_ ON e0_.organizer_id = e3_.id LEFT JOIN eventic_user e4_ ON e3_.user_id = e4_.id WHERE e0_.published = 1 AND e1_.start_date >= CURRENT_TIMESTAMP AND e4_.is_enabled = 1 ORDER BY e1_.start_date ASC LIMIT 8;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getResult (line 688)
6	Twig\Extension\CoreExtension->getAttribute (line 1913)
7	__TwigTemplate_aa370f98176b531ce0edf88babb4d1a4::block_content (line 564)
8	Twig\Template->yieldBlock (line 446)
9	__TwigTemplate_f8ef6bac9888e109f4528904c0245a15->doDisplay (line 241)
10	Twig\Template->yield (line 402)
11	__TwigTemplate_aa370f98176b531ce0edf88babb4d1a4->doDisplay (line 54)
12	Twig\Template->yield (line 402)
13	Twig\Template->display (line 358)
14	Twig\Template->render (line 373)
15	Twig\TemplateWrapper->render (line 51)
16	Twig\Environment->render (line 333)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 462)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 467)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 279)
20	App\Controller\Front\MainController->homepage (line 17)
21	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
22	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
23	Symfony\Component\HttpKernel\Kernel->handle (line 191)
24	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
25	require_once (line 32)
26	require_once (line 5)

0.39 ms
(12.79%)

SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.object_id AS object_id_5 FROM eventic_menu_element_translation t0 WHERE t0.object_id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.locale AS locale_2,
  t0.field AS field_3,
  t0.content AS content_4,
  t0.object_id AS object_id_5
FROM
  eventic_menu_element_translation t0
WHERE
  t0.object_id = ?

SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.object_id AS object_id_5 FROM eventic_menu_element_translation t0 WHERE t0.object_id = 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1872)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 1817)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2729)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 313)
7	Gedmo\Translatable\Mapping\Event\Adapter\ORM->loadTranslations (line 64)
8	Gedmo\Translatable\TranslatableListener->postLoad (line 529)
9	Symfony\Bridge\Doctrine\ContainerAwareEventManager->dispatchEvent (line 56)
10	Doctrine\ORM\Event\ListenersInvoker->invoke (line 95)
11	Doctrine\ORM\Internal\HydrationCompleteHandler->hydrationComplete (line 55)
12	Doctrine\ORM\UnitOfWork->hydrationComplete (line 3210)
13	Doctrine\ORM\Internal\Hydration\ObjectHydrator->cleanup (line 127)
14	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 177)
15	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadCollectionFromStatement (line 1026)
16	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 1819)
17	Doctrine\ORM\UnitOfWork->loadCollection (line 2729)
18	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
19	Doctrine\ORM\PersistentCollection->initialize (line 186)
20	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 313)
21	__TwigTemplate_3e36dcf9832490e224077b7c9f888f9d->doDisplay (line 370)
22	Twig\Template->yield (line 402)
23	__TwigTemplate_f8ef6bac9888e109f4528904c0245a15->doDisplay (line 225)
24	Twig\Template->yield (line 402)
25	__TwigTemplate_aa370f98176b531ce0edf88babb4d1a4->doDisplay (line 54)
26	Twig\Template->yield (line 402)
27	Twig\Template->display (line 358)
28	Twig\Template->render (line 373)
29	Twig\TemplateWrapper->render (line 51)
30	Twig\Environment->render (line 333)
31	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 462)
32	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 467)
33	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 279)
34	App\Controller\Front\MainController->homepage (line 17)
35	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
36	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
37	Symfony\Component\HttpKernel\Kernel->handle (line 191)
38	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
39	require_once (line 32)
40	require_once (line 5)

0.32 ms
(10.76%)

SELECT e0_.id AS id_0, e0_.name AS name_1, e0_.slug AS slug_2, e0_.header AS header_3 FROM eventic_menu e0_ WHERE e0_.slug = ?

Parameters:

[
  "header-menu"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  e0_.id AS id_0,
  e0_.name AS name_1,
  e0_.slug AS slug_2,
  e0_.header AS header_3
FROM
  eventic_menu e0_
WHERE
  e0_.slug = ?

SELECT e0_.id AS id_0, e0_.name AS name_1, e0_.slug AS slug_2, e0_.header AS header_3 FROM eventic_menu e0_ WHERE e0_.slug = 'header-menu';

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 737)
6	Twig\Extension\CoreExtension->getAttribute (line 1913)
7	__TwigTemplate_3e36dcf9832490e224077b7c9f888f9d::doDisplay (line 369)
8	Twig\Template->yield (line 402)
9	__TwigTemplate_f8ef6bac9888e109f4528904c0245a15->doDisplay (line 225)
10	Twig\Template->yield (line 402)
11	__TwigTemplate_aa370f98176b531ce0edf88babb4d1a4->doDisplay (line 54)
12	Twig\Template->yield (line 402)
13	Twig\Template->display (line 358)
14	Twig\Template->render (line 373)
15	Twig\TemplateWrapper->render (line 51)
16	Twig\Environment->render (line 333)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 462)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 467)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 279)
20	App\Controller\Front\MainController->homepage (line 17)
21	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
22	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
23	Symfony\Component\HttpKernel\Kernel->handle (line 191)
24	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
25	require_once (line 32)
26	require_once (line 5)

0.30 ms
(9.84%)

SELECT t0.id AS id_1, t0.title AS title_2, t0.paragraph AS paragraph_3, t0.content AS content_4, t0.show_search_box AS show_search_box_5, t0.updated_at AS updated_at_6, t0.custom_background_name AS custom_background_name_7 FROM eventic_homepage_hero_setting t0 WHERE t0.id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.paragraph AS paragraph_3,
  t0.content AS content_4,
  t0.show_search_box AS show_search_box_5,
  t0.updated_at AS updated_at_6,
  t0.custom_background_name AS custom_background_name_7
FROM
  eventic_homepage_hero_setting t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.paragraph AS paragraph_3, t0.content AS content_4, t0.show_search_box AS show_search_box_5, t0.updated_at AS updated_at_6, t0.custom_background_name AS custom_background_name_7 FROM eventic_homepage_hero_setting t0 WHERE t0.id = 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
3	Doctrine\ORM\EntityManager->find (line 366)
4	Doctrine\ORM\EntityRepository->find (line 86)
5	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepository->find (line 66)
6	App\Controller\Front\MainController->homepage (line 15)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
9	Symfony\Component\HttpKernel\Kernel->handle (line 191)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
11	require_once (line 32)
12	require_once (line 5)

0.27 ms
(8.81%)

SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.object_id AS object_id_5 FROM eventic_homepage_hero_setting_translation t0 WHERE t0.object_id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.locale AS locale_2,
  t0.field AS field_3,
  t0.content AS content_4,
  t0.object_id AS object_id_5
FROM
  eventic_homepage_hero_setting_translation t0
WHERE
  t0.object_id = ?

SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.object_id AS object_id_5 FROM eventic_homepage_hero_setting_translation t0 WHERE t0.object_id = 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1872)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 1817)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2729)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 313)
7	Gedmo\Translatable\Mapping\Event\Adapter\ORM->loadTranslations (line 64)
8	Gedmo\Translatable\TranslatableListener->postLoad (line 529)
9	Symfony\Bridge\Doctrine\ContainerAwareEventManager->dispatchEvent (line 56)
10	Doctrine\ORM\Event\ListenersInvoker->invoke (line 95)
11	Doctrine\ORM\Internal\HydrationCompleteHandler->hydrationComplete (line 55)
12	Doctrine\ORM\UnitOfWork->hydrationComplete (line 3210)
13	Doctrine\ORM\Internal\Hydration\SimpleObjectHydrator->cleanup (line 49)
14	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 177)
15	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 746)
16	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
17	Doctrine\ORM\EntityManager->find (line 366)
18	Doctrine\ORM\EntityRepository->find (line 86)
19	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepository->find (line 66)
20	App\Controller\Front\MainController->homepage (line 15)
21	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
22	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
23	Symfony\Component\HttpKernel\Kernel->handle (line 191)
24	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
25	require_once (line 32)
26	require_once (line 5)

0.23 ms
(7.75%)

SELECT t0.id AS id_1, t0.label AS label_2, t0.slug AS slug_3, t0.icon AS icon_4, t0.link AS link_5, t0.custom_link AS custom_link_6, t0.position AS position_7, t0.menu_id AS menu_id_8 FROM eventic_menu_element t0 WHERE t0.menu_id = ? ORDER BY t0.position ASC

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.label AS label_2,
  t0.slug AS slug_3,
  t0.icon AS icon_4,
  t0.link AS link_5,
  t0.custom_link AS custom_link_6,
  t0.position AS position_7,
  t0.menu_id AS menu_id_8
FROM
  eventic_menu_element t0
WHERE
  t0.menu_id = ?
ORDER BY
  t0.position ASC

SELECT t0.id AS id_1, t0.label AS label_2, t0.slug AS slug_3, t0.icon AS icon_4, t0.link AS link_5, t0.custom_link AS custom_link_6, t0.position AS position_7, t0.menu_id AS menu_id_8 FROM eventic_menu_element t0 WHERE t0.menu_id = 1 ORDER BY t0.position ASC;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1872)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 1817)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2729)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 313)
7	__TwigTemplate_3e36dcf9832490e224077b7c9f888f9d->doDisplay (line 370)
8	Twig\Template->yield (line 402)
9	__TwigTemplate_f8ef6bac9888e109f4528904c0245a15->doDisplay (line 225)
10	Twig\Template->yield (line 402)
11	__TwigTemplate_aa370f98176b531ce0edf88babb4d1a4->doDisplay (line 54)
12	Twig\Template->yield (line 402)
13	Twig\Template->display (line 358)
14	Twig\Template->render (line 373)
15	Twig\TemplateWrapper->render (line 51)
16	Twig\Environment->render (line 333)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 462)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 467)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 279)
20	App\Controller\Front\MainController->homepage (line 17)
21	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
22	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
23	Symfony\Component\HttpKernel\Kernel->handle (line 191)
24	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
25	require_once (line 32)
26	require_once (line 5)

0.23 ms
(7.72%)

SELECT t0.id AS id_1, t0.logo_name AS logo_name_2, t0.favicon_name AS favicon_name_3, t0.og_image_name AS og_image_name_4, t0.updated_at AS updated_at_5 FROM eventic_app_layout_setting t0 WHERE t0.id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.logo_name AS logo_name_2,
  t0.favicon_name AS favicon_name_3,
  t0.og_image_name AS og_image_name_4,
  t0.updated_at AS updated_at_5
FROM
  eventic_app_layout_setting t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.logo_name AS logo_name_2, t0.favicon_name AS favicon_name_3, t0.og_image_name AS og_image_name_4, t0.updated_at AS updated_at_5 FROM eventic_app_layout_setting t0 WHERE t0.id = 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
3	Doctrine\ORM\EntityManager->find (line 366)
4	Doctrine\ORM\EntityRepository->find (line 86)
5	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepository->find (line 66)
6	App\Service\RepositoryServices->getAppLayoutSettings (line 26)
7	Twig\Extension\CoreExtension->getAttribute (line 1913)
8	__TwigTemplate_f8ef6bac9888e109f4528904c0245a15::doDisplay (line 112)
9	Twig\Template->yield (line 402)
10	__TwigTemplate_aa370f98176b531ce0edf88babb4d1a4->doDisplay (line 54)
11	Twig\Template->yield (line 402)
12	Twig\Template->display (line 358)
13	Twig\Template->render (line 373)
14	Twig\TemplateWrapper->render (line 51)
15	Twig\Environment->render (line 333)
16	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 462)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 467)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 279)
19	App\Controller\Front\MainController->homepage (line 17)
20	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
21	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
22	Symfony\Component\HttpKernel\Kernel->handle (line 191)
23	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
24	require_once (line 32)
25	require_once (line 5)

0.20 ms
(6.73%)

SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.object_id AS object_id_5 FROM eventic_menu_translation t0 WHERE t0.object_id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.locale AS locale_2,
  t0.field AS field_3,
  t0.content AS content_4,
  t0.object_id AS object_id_5
FROM
  eventic_menu_translation t0
WHERE
  t0.object_id = ?

SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.object_id AS object_id_5 FROM eventic_menu_translation t0 WHERE t0.object_id = 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1872)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 1817)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2729)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 313)
7	Gedmo\Translatable\Mapping\Event\Adapter\ORM->loadTranslations (line 64)
8	Gedmo\Translatable\TranslatableListener->postLoad (line 529)
9	Symfony\Bridge\Doctrine\ContainerAwareEventManager->dispatchEvent (line 56)
10	Doctrine\ORM\Event\ListenersInvoker->invoke (line 95)
11	Doctrine\ORM\Internal\HydrationCompleteHandler->hydrationComplete (line 55)
12	Doctrine\ORM\UnitOfWork->hydrationComplete (line 3210)
13	Doctrine\ORM\Internal\Hydration\ObjectHydrator->cleanup (line 127)
14	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 177)
15	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 943)
16	Doctrine\ORM\AbstractQuery->execute (line 886)
17	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 737)
18	Twig\Extension\CoreExtension->getAttribute (line 1913)
19	__TwigTemplate_3e36dcf9832490e224077b7c9f888f9d::doDisplay (line 369)
20	Twig\Template->yield (line 402)
21	__TwigTemplate_f8ef6bac9888e109f4528904c0245a15->doDisplay (line 225)
22	Twig\Template->yield (line 402)
23	__TwigTemplate_aa370f98176b531ce0edf88babb4d1a4->doDisplay (line 54)
24	Twig\Template->yield (line 402)
25	Twig\Template->display (line 358)
26	Twig\Template->render (line 373)
27	Twig\TemplateWrapper->render (line 51)
28	Twig\Environment->render (line 333)
29	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 462)
30	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 467)
31	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 279)
32	App\Controller\Front\MainController->homepage (line 17)
33	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
34	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
35	Symfony\Component\HttpKernel\Kernel->handle (line 191)
36	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
37	require_once (line 32)
38	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\MenuElementTranslation	16
App\Entity\MenuTranslation	8
App\Entity\HomepageHeroSettingsTranslation	2
App\Entity\MenuElement	2
App\Entity\HomepageHeroSettings	1
App\Entity\AppLayoutSettings	1
App\Entity\Menu	1

Entities Mapping

Class	Mapping errors
App\Entity\HomepageHeroSettings	No errors.
App\Entity\HomepageHeroSettingsTranslation	No errors.
App\Entity\Event	No errors.
App\Entity\User	No errors.
App\Entity\AppLayoutSettings	No errors.
App\Entity\Menu	No errors.
App\Entity\MenuTranslation	No errors.
App\Entity\MenuElement	No errors.
App\Entity\MenuElementTranslation	No errors.
App\Entity\EventDate	No errors.
App\Entity\Venue	No errors.
App\Entity\Organizer	No errors.
App\Entity\Category	No errors.
App\Entity\Country	No errors.

Symfony Profiler

GET https://sopovia.com/

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping