Symfony Profiler

Query Metrics

8 Database Queries

7 Different statements

5.31 ms Query time

0 Invalid entities

28 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

2.10 ms
(39.56%)

SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, start_date_32 FROM (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, e1_.id AS id_27, e1_.online AS online_28, e1_.has_seating_plan AS has_seating_plan_29, e1_.reference AS reference_30, e1_.active AS active_31, e1_.start_date AS start_date_32, e1_.end_date AS end_date_33, e2_.id AS id_34, e2_.email AS email_35, e2_.gender AS gender_36, e2_.first_name AS first_name_37, e2_.last_name AS last_name_38, e2_.slug AS slug_39, e2_.street AS street_40, e2_.street2 AS street2_41, e2_.city AS city_42, e2_.state AS state_43, e2_.postal_code AS postal_code_44, e2_.phone AS phone_45, e2_.birth_date AS birth_date_46, e2_.avatar_name AS avatar_name_47, e2_.avatar_dimensions AS avatar_dimensions_48, e2_.facebook_profile_picture AS facebook_profile_picture_49, e2_.google_profile_picture AS google_profile_picture_50, e2_.facebook_id AS facebook_id_51, e2_.google_id AS google_id_52, e2_.api_key AS api_key_53, e2_.created_at AS created_at_54, e2_.updated_at AS updated_at_55, e2_.last_login_at AS last_login_at_56, e2_.roles AS roles_57, e2_.password AS password_58, e2_.is_enabled AS is_enabled_59, e2_.is_verified AS is_verified_60 FROM eventic_event e0_ LEFT JOIN eventic_event_date e1_ ON e0_.id = e1_.event_id LEFT JOIN eventic_venue e3_ ON e1_.venue_id = e3_.id LEFT JOIN eventic_organizer e4_ ON e0_.organizer_id = e4_.id LEFT JOIN eventic_user e2_ ON e4_.user_id = e2_.id WHERE e0_.published = ? AND e1_.start_date >= CURRENT_TIMESTAMP AND e2_.is_enabled = ? ORDER BY e1_.start_date ASC) dctrn_result_inner ORDER BY start_date_32 ASC) dctrn_result LIMIT 10

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT id_0
FROM
  (
    SELECT
      DISTINCT id_0,
      start_date_32
    FROM
      (
        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,
          e1_.id AS id_27,
          e1_.online AS online_28,
          e1_.has_seating_plan AS has_seating_plan_29,
          e1_.reference AS reference_30,
          e1_.active AS active_31,
          e1_.start_date AS start_date_32,
          e1_.end_date AS end_date_33,
          e2_.id AS id_34,
          e2_.email AS email_35,
          e2_.gender AS gender_36,
          e2_.first_name AS first_name_37,
          e2_.last_name AS last_name_38,
          e2_.slug AS slug_39,
          e2_.street AS street_40,
          e2_.street2 AS street2_41,
          e2_.city AS city_42,
          e2_.state AS state_43,
          e2_.postal_code AS postal_code_44,
          e2_.phone AS phone_45,
          e2_.birth_date AS birth_date_46,
          e2_.avatar_name AS avatar_name_47,
          e2_.avatar_dimensions AS avatar_dimensions_48,
          e2_.facebook_profile_picture AS facebook_profile_picture_49,
          e2_.google_profile_picture AS google_profile_picture_50,
          e2_.facebook_id AS facebook_id_51,
          e2_.google_id AS google_id_52,
          e2_.api_key AS api_key_53,
          e2_.created_at AS created_at_54,
          e2_.updated_at AS updated_at_55,
          e2_.last_login_at AS last_login_at_56,
          e2_.roles AS roles_57,
          e2_.password AS password_58,
          e2_.is_enabled AS is_enabled_59,
          e2_.is_verified AS is_verified_60
        FROM
          eventic_event e0_
          LEFT JOIN eventic_event_date e1_ ON e0_.id = e1_.event_id
          LEFT JOIN eventic_venue e3_ ON e1_.venue_id = e3_.id
          LEFT JOIN eventic_organizer e4_ ON e0_.organizer_id = e4_.id
          LEFT JOIN eventic_user e2_ ON e4_.user_id = e2_.id
        WHERE
          e0_.published = ?
          AND e1_.start_date >= CURRENT_TIMESTAMP
          AND e2_.is_enabled = ?
        ORDER BY
          e1_.start_date ASC
      ) dctrn_result_inner
    ORDER BY
      start_date_32 ASC
  ) dctrn_result
LIMIT
  10

SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, start_date_32 FROM (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, e1_.id AS id_27, e1_.online AS online_28, e1_.has_seating_plan AS has_seating_plan_29, e1_.reference AS reference_30, e1_.active AS active_31, e1_.start_date AS start_date_32, e1_.end_date AS end_date_33, e2_.id AS id_34, e2_.email AS email_35, e2_.gender AS gender_36, e2_.first_name AS first_name_37, e2_.last_name AS last_name_38, e2_.slug AS slug_39, e2_.street AS street_40, e2_.street2 AS street2_41, e2_.city AS city_42, e2_.state AS state_43, e2_.postal_code AS postal_code_44, e2_.phone AS phone_45, e2_.birth_date AS birth_date_46, e2_.avatar_name AS avatar_name_47, e2_.avatar_dimensions AS avatar_dimensions_48, e2_.facebook_profile_picture AS facebook_profile_picture_49, e2_.google_profile_picture AS google_profile_picture_50, e2_.facebook_id AS facebook_id_51, e2_.google_id AS google_id_52, e2_.api_key AS api_key_53, e2_.created_at AS created_at_54, e2_.updated_at AS updated_at_55, e2_.last_login_at AS last_login_at_56, e2_.roles AS roles_57, e2_.password AS password_58, e2_.is_enabled AS is_enabled_59, e2_.is_verified AS is_verified_60 FROM eventic_event e0_ LEFT JOIN eventic_event_date e1_ ON e0_.id = e1_.event_id LEFT JOIN eventic_venue e3_ ON e1_.venue_id = e3_.id LEFT JOIN eventic_organizer e4_ ON e0_.organizer_id = e4_.id LEFT JOIN eventic_user e2_ ON e4_.user_id = e2_.id WHERE e0_.published = 1 AND e1_.start_date >= CURRENT_TIMESTAMP AND e2_.is_enabled = 1 ORDER BY e1_.start_date ASC) dctrn_result_inner ORDER BY start_date_32 ASC) dctrn_result 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 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getScalarResult (line 724)
6	Doctrine\ORM\Tools\Pagination\Paginator->getIterator (line 127)
7	iterator_to_array (line 45)
8	Knp\Component\Pager\Event\Subscriber\Paginate\Doctrine\ORM\QuerySubscriber::items (line 45)
9	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
10	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
11	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
12	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
13	Knp\Component\Pager\Paginator->paginate (line 97)
14	ContainerIu2eIol\PaginatorProxyBa079e5->paginate (line 20)
15	App\Controller\Front\EventController->events (line 40)
16	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
17	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
18	Symfony\Component\HttpKernel\Kernel->handle (line 191)
19	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
20	require_once (line 32)
21	require_once (line 5)

2.09 ms
(39.41%)

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (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 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) dctrn_result) dctrn_table

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(*) AS dctrn_count
FROM
  (
    SELECT
      DISTINCT id_0
    FROM
      (
        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
        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
      ) dctrn_result
  ) dctrn_table

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (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 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) dctrn_result) dctrn_table;

#	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->getScalarResult (line 724)
6	Doctrine\ORM\Tools\Pagination\Paginator->count (line 96)
7	count (line 43)
8	Knp\Component\Pager\Event\Subscriber\Paginate\Doctrine\ORM\QuerySubscriber::items (line 43)
9	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
10	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
11	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
12	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
13	Knp\Component\Pager\Paginator->paginate (line 97)
14	ContainerIu2eIol\PaginatorProxyBa079e5->paginate (line 20)
15	App\Controller\Front\EventController->events (line 40)
16	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
17	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
18	Symfony\Component\HttpKernel\Kernel->handle (line 191)
19	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
20	require_once (line 32)
21	require_once (line 5)

0.28 ms
(5.25%)

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_83a498e21fd1ead09991ec43d2552459->doDisplay (line 64)
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\EventController->events (line 47)
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.25 ms
(4.65%)

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_83a498e21fd1ead09991ec43d2552459->doDisplay (line 64)
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\EventController->events (line 47)
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
(3.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_83a498e21fd1ead09991ec43d2552459->doDisplay (line 64)
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\EventController->events (line 47)
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.20 ms
(3.71%)

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_83a498e21fd1ead09991ec43d2552459->doDisplay (line 64)
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\EventController->events (line 47)
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)

0.20 ms
(3.67%)

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_83a498e21fd1ead09991ec43d2552459->doDisplay (line 64)
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\EventController->events (line 47)
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)

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\MenuElement	2
App\Entity\AppLayoutSettings	1
App\Entity\Menu	1

Entities Mapping

Class	Mapping errors
App\Entity\Event	No errors.
App\Entity\EventDate	No errors.
App\Entity\Venue	No errors.
App\Entity\Organizer	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.

Symfony Profiler

GET https://sopovia.com/ar/events

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping