Symfony Profiler

Query Metrics

12 Database Queries

12 Different statements

7.28 ms Query time

2 Invalid entities

171 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

1.08 ms
(14.83%)

SELECT e0_.id AS id_0, e0_.slug AS slug_1, e0_.program_name AS program_name_2, e0_.program_original_name AS program_original_name_3, e0_.program_mime_type AS program_mime_type_4, e0_.program_size AS program_size_5, e0_.program_updated_at AS program_updated_at_6, e0_.is_activated AS is_activated_7, e0_.is_enabled AS is_enabled_8, e0_.start_at AS start_at_9, e0_.end_at AS end_at_10, e0_.status AS status_11, e0_.format AS format_12, e0_.created_at AS created_at_13, e0_.is_show_chat AS is_show_chat_14, e0_.is_registration AS is_registration_15, e0_.is_calendar AS is_calendar_16, e0_.is_nmo AS is_nmo_17, e0_.is_show_slider AS is_show_slider_18, e0_.image_name AS image_name_19, e0_.image_original_name AS image_original_name_20, e0_.image_mime_type AS image_mime_type_21, e0_.image_size AS image_size_22, e0_.image_updated_at AS image_updated_at_23, e0_.card_image_name AS card_image_name_24, e0_.card_image_original_name AS card_image_original_name_25, e0_.card_image_mime_type AS card_image_mime_type_26, e0_.card_image_size AS card_image_size_27, e0_.card_image_updated_at AS card_image_updated_at_28, e1_.id AS id_29, e1_.iframe AS iframe_30, e1_.title AS title_31, e1_.sort AS sort_32, l2_.id AS id_33, l2_.name AS name_34, e0_.poll_id AS poll_id_35, e0_.event_group_id AS event_group_id_36, e1_.lang_id AS lang_id_37, e1_.event_id AS event_id_38 FROM event e0_ LEFT JOIN event_tab e1_ ON e0_.id = e1_.event_id LEFT JOIN language l2_ ON e1_.lang_id = l2_.id WHERE e0_.id = ? ORDER BY e1_.sort ASC, e1_.id ASC

Parameters:

[
  3
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  e0_.id AS id_0,
  e0_.slug AS slug_1,
  e0_.program_name AS program_name_2,
  e0_.program_original_name AS program_original_name_3,
  e0_.program_mime_type AS program_mime_type_4,
  e0_.program_size AS program_size_5,
  e0_.program_updated_at AS program_updated_at_6,
  e0_.is_activated AS is_activated_7,
  e0_.is_enabled AS is_enabled_8,
  e0_.start_at AS start_at_9,
  e0_.end_at AS end_at_10,
  e0_.status AS status_11,
  e0_.format AS format_12,
  e0_.created_at AS created_at_13,
  e0_.is_show_chat AS is_show_chat_14,
  e0_.is_registration AS is_registration_15,
  e0_.is_calendar AS is_calendar_16,
  e0_.is_nmo AS is_nmo_17,
  e0_.is_show_slider AS is_show_slider_18,
  e0_.image_name AS image_name_19,
  e0_.image_original_name AS image_original_name_20,
  e0_.image_mime_type AS image_mime_type_21,
  e0_.image_size AS image_size_22,
  e0_.image_updated_at AS image_updated_at_23,
  e0_.card_image_name AS card_image_name_24,
  e0_.card_image_original_name AS card_image_original_name_25,
  e0_.card_image_mime_type AS card_image_mime_type_26,
  e0_.card_image_size AS card_image_size_27,
  e0_.card_image_updated_at AS card_image_updated_at_28,
  e1_.id AS id_29,
  e1_.iframe AS iframe_30,
  e1_.title AS title_31,
  e1_.sort AS sort_32,
  l2_.id AS id_33,
  l2_.name AS name_34,
  e0_.poll_id AS poll_id_35,
  e0_.event_group_id AS event_group_id_36,
  e1_.lang_id AS lang_id_37,
  e1_.event_id AS event_id_38
FROM
  event e0_
  LEFT JOIN event_tab e1_ ON e0_.id = e1_.event_id
  LEFT JOIN language l2_ ON e1_.lang_id = l2_.id
WHERE
  e0_.id = ?
ORDER BY
  e1_.sort ASC,
  e1_.id ASC

SELECT e0_.id AS id_0, e0_.slug AS slug_1, e0_.program_name AS program_name_2, e0_.program_original_name AS program_original_name_3, e0_.program_mime_type AS program_mime_type_4, e0_.program_size AS program_size_5, e0_.program_updated_at AS program_updated_at_6, e0_.is_activated AS is_activated_7, e0_.is_enabled AS is_enabled_8, e0_.start_at AS start_at_9, e0_.end_at AS end_at_10, e0_.status AS status_11, e0_.format AS format_12, e0_.created_at AS created_at_13, e0_.is_show_chat AS is_show_chat_14, e0_.is_registration AS is_registration_15, e0_.is_calendar AS is_calendar_16, e0_.is_nmo AS is_nmo_17, e0_.is_show_slider AS is_show_slider_18, e0_.image_name AS image_name_19, e0_.image_original_name AS image_original_name_20, e0_.image_mime_type AS image_mime_type_21, e0_.image_size AS image_size_22, e0_.image_updated_at AS image_updated_at_23, e0_.card_image_name AS card_image_name_24, e0_.card_image_original_name AS card_image_original_name_25, e0_.card_image_mime_type AS card_image_mime_type_26, e0_.card_image_size AS card_image_size_27, e0_.card_image_updated_at AS card_image_updated_at_28, e1_.id AS id_29, e1_.iframe AS iframe_30, e1_.title AS title_31, e1_.sort AS sort_32, l2_.id AS id_33, l2_.name AS name_34, e0_.poll_id AS poll_id_35, e0_.event_group_id AS event_group_id_36, e1_.lang_id AS lang_id_37, e1_.event_id AS event_id_38 FROM event e0_ LEFT JOIN event_tab e1_ ON e0_.id = e1_.event_id LEFT JOIN language l2_ ON e1_.lang_id = l2_.id WHERE e0_.id = 3 ORDER BY e1_.sort ASC, e1_.id 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 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getResult (line 688)
6	App\Repository\Event\EventRepository->loadEventTabs (line 162)
7	App\Repository\Event\EventRepository->findOneForPage (line 120)
8	App\Controller\EventController->eventPage (line 93)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
11	Symfony\Component\HttpKernel\Kernel->handle (line 193)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
13	require_once (line 32)
14	require_once (line 5)

0.87 ms
(12.01%)

SELECT e0_.id AS id_0, e0_.slug AS slug_1, e0_.program_name AS program_name_2, e0_.program_original_name AS program_original_name_3, e0_.program_mime_type AS program_mime_type_4, e0_.program_size AS program_size_5, e0_.program_updated_at AS program_updated_at_6, e0_.is_activated AS is_activated_7, e0_.is_enabled AS is_enabled_8, e0_.start_at AS start_at_9, e0_.end_at AS end_at_10, e0_.status AS status_11, e0_.format AS format_12, e0_.created_at AS created_at_13, e0_.is_show_chat AS is_show_chat_14, e0_.is_registration AS is_registration_15, e0_.is_calendar AS is_calendar_16, e0_.is_nmo AS is_nmo_17, e0_.is_show_slider AS is_show_slider_18, e0_.image_name AS image_name_19, e0_.image_original_name AS image_original_name_20, e0_.image_mime_type AS image_mime_type_21, e0_.image_size AS image_size_22, e0_.image_updated_at AS image_updated_at_23, e0_.card_image_name AS card_image_name_24, e0_.card_image_original_name AS card_image_original_name_25, e0_.card_image_mime_type AS card_image_mime_type_26, e0_.card_image_size AS card_image_size_27, e0_.card_image_updated_at AS card_image_updated_at_28, e1_.id AS id_29, e1_.title AS title_30, e1_.seo_title AS seo_title_31, e1_.seo_description AS seo_description_32, e1_.content AS content_33, l2_.id AS id_34, l2_.name AS name_35, e3_.id AS id_36, e3_.slug AS slug_37, e3_.created_at AS created_at_38, e3_.is_activated AS is_activated_39, e4_.id AS id_40, e4_.title AS title_41, e4_.content AS content_42, l5_.id AS id_43, l5_.name AS name_44, e0_.poll_id AS poll_id_45, e0_.event_group_id AS event_group_id_46, e1_.lang_id AS lang_id_47, e1_.event_id AS event_id_48, e4_.lang_id AS lang_id_49, e4_.event_group_id AS event_group_id_50 FROM event e0_ LEFT JOIN event_translate e1_ ON e0_.id = e1_.event_id LEFT JOIN language l2_ ON e1_.lang_id = l2_.id LEFT JOIN event_group e3_ ON e0_.event_group_id = e3_.id LEFT JOIN event_group_translate e4_ ON e3_.id = e4_.event_group_id LEFT JOIN language l5_ ON e4_.lang_id = l5_.id WHERE e0_.slug = ? AND e0_.is_enabled = ? AND e0_.is_activated = ?

Parameters:

[
  "antikoagulyantnyy-klub-cikl-vnutri-antikoagulyantnyh-resheniy"
  1
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  e0_.id AS id_0,
  e0_.slug AS slug_1,
  e0_.program_name AS program_name_2,
  e0_.program_original_name AS program_original_name_3,
  e0_.program_mime_type AS program_mime_type_4,
  e0_.program_size AS program_size_5,
  e0_.program_updated_at AS program_updated_at_6,
  e0_.is_activated AS is_activated_7,
  e0_.is_enabled AS is_enabled_8,
  e0_.start_at AS start_at_9,
  e0_.end_at AS end_at_10,
  e0_.status AS status_11,
  e0_.format AS format_12,
  e0_.created_at AS created_at_13,
  e0_.is_show_chat AS is_show_chat_14,
  e0_.is_registration AS is_registration_15,
  e0_.is_calendar AS is_calendar_16,
  e0_.is_nmo AS is_nmo_17,
  e0_.is_show_slider AS is_show_slider_18,
  e0_.image_name AS image_name_19,
  e0_.image_original_name AS image_original_name_20,
  e0_.image_mime_type AS image_mime_type_21,
  e0_.image_size AS image_size_22,
  e0_.image_updated_at AS image_updated_at_23,
  e0_.card_image_name AS card_image_name_24,
  e0_.card_image_original_name AS card_image_original_name_25,
  e0_.card_image_mime_type AS card_image_mime_type_26,
  e0_.card_image_size AS card_image_size_27,
  e0_.card_image_updated_at AS card_image_updated_at_28,
  e1_.id AS id_29,
  e1_.title AS title_30,
  e1_.seo_title AS seo_title_31,
  e1_.seo_description AS seo_description_32,
  e1_.content AS content_33,
  l2_.id AS id_34,
  l2_.name AS name_35,
  e3_.id AS id_36,
  e3_.slug AS slug_37,
  e3_.created_at AS created_at_38,
  e3_.is_activated AS is_activated_39,
  e4_.id AS id_40,
  e4_.title AS title_41,
  e4_.content AS content_42,
  l5_.id AS id_43,
  l5_.name AS name_44,
  e0_.poll_id AS poll_id_45,
  e0_.event_group_id AS event_group_id_46,
  e1_.lang_id AS lang_id_47,
  e1_.event_id AS event_id_48,
  e4_.lang_id AS lang_id_49,
  e4_.event_group_id AS event_group_id_50
FROM
  event e0_
  LEFT JOIN event_translate e1_ ON e0_.id = e1_.event_id
  LEFT JOIN language l2_ ON e1_.lang_id = l2_.id
  LEFT JOIN event_group e3_ ON e0_.event_group_id = e3_.id
  LEFT JOIN event_group_translate e4_ ON e3_.id = e4_.event_group_id
  LEFT JOIN language l5_ ON e4_.lang_id = l5_.id
WHERE
  e0_.slug = ?
  AND e0_.is_enabled = ?
  AND e0_.is_activated = ?

SELECT e0_.id AS id_0, e0_.slug AS slug_1, e0_.program_name AS program_name_2, e0_.program_original_name AS program_original_name_3, e0_.program_mime_type AS program_mime_type_4, e0_.program_size AS program_size_5, e0_.program_updated_at AS program_updated_at_6, e0_.is_activated AS is_activated_7, e0_.is_enabled AS is_enabled_8, e0_.start_at AS start_at_9, e0_.end_at AS end_at_10, e0_.status AS status_11, e0_.format AS format_12, e0_.created_at AS created_at_13, e0_.is_show_chat AS is_show_chat_14, e0_.is_registration AS is_registration_15, e0_.is_calendar AS is_calendar_16, e0_.is_nmo AS is_nmo_17, e0_.is_show_slider AS is_show_slider_18, e0_.image_name AS image_name_19, e0_.image_original_name AS image_original_name_20, e0_.image_mime_type AS image_mime_type_21, e0_.image_size AS image_size_22, e0_.image_updated_at AS image_updated_at_23, e0_.card_image_name AS card_image_name_24, e0_.card_image_original_name AS card_image_original_name_25, e0_.card_image_mime_type AS card_image_mime_type_26, e0_.card_image_size AS card_image_size_27, e0_.card_image_updated_at AS card_image_updated_at_28, e1_.id AS id_29, e1_.title AS title_30, e1_.seo_title AS seo_title_31, e1_.seo_description AS seo_description_32, e1_.content AS content_33, l2_.id AS id_34, l2_.name AS name_35, e3_.id AS id_36, e3_.slug AS slug_37, e3_.created_at AS created_at_38, e3_.is_activated AS is_activated_39, e4_.id AS id_40, e4_.title AS title_41, e4_.content AS content_42, l5_.id AS id_43, l5_.name AS name_44, e0_.poll_id AS poll_id_45, e0_.event_group_id AS event_group_id_46, e1_.lang_id AS lang_id_47, e1_.event_id AS event_id_48, e4_.lang_id AS lang_id_49, e4_.event_group_id AS event_group_id_50 FROM event e0_ LEFT JOIN event_translate e1_ ON e0_.id = e1_.event_id LEFT JOIN language l2_ ON e1_.lang_id = l2_.id LEFT JOIN event_group e3_ ON e0_.event_group_id = e3_.id LEFT JOIN event_group_translate e4_ ON e3_.id = e4_.event_group_id LEFT JOIN language l5_ ON e4_.lang_id = l5_.id WHERE e0_.slug = 'antikoagulyantnyy-klub-cikl-vnutri-antikoagulyantnyh-resheniy' AND e0_.is_enabled = 1 AND e0_.is_activated = 1;

#	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	App\Repository\Event\EventRepository->findOneForPage (line 105)
7	App\Controller\EventController->eventPage (line 93)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 193)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
12	require_once (line 32)
13	require_once (line 5)

0.69 ms
(9.53%)

SELECT e0_.id AS id_0, e0_.slug AS slug_1, e0_.program_name AS program_name_2, e0_.program_original_name AS program_original_name_3, e0_.program_mime_type AS program_mime_type_4, e0_.program_size AS program_size_5, e0_.program_updated_at AS program_updated_at_6, e0_.is_activated AS is_activated_7, e0_.is_enabled AS is_enabled_8, e0_.start_at AS start_at_9, e0_.end_at AS end_at_10, e0_.status AS status_11, e0_.format AS format_12, e0_.created_at AS created_at_13, e0_.is_show_chat AS is_show_chat_14, e0_.is_registration AS is_registration_15, e0_.is_calendar AS is_calendar_16, e0_.is_nmo AS is_nmo_17, e0_.is_show_slider AS is_show_slider_18, e0_.image_name AS image_name_19, e0_.image_original_name AS image_original_name_20, e0_.image_mime_type AS image_mime_type_21, e0_.image_size AS image_size_22, e0_.image_updated_at AS image_updated_at_23, e0_.card_image_name AS card_image_name_24, e0_.card_image_original_name AS card_image_original_name_25, e0_.card_image_mime_type AS card_image_mime_type_26, e0_.card_image_size AS card_image_size_27, e0_.card_image_updated_at AS card_image_updated_at_28, s1_.id AS id_29, s1_.is_enabled AS is_enabled_30, s1_.created_at AS created_at_31, s1_.image_name AS image_name_32, s1_.image_original_name AS image_original_name_33, s1_.image_mime_type AS image_mime_type_34, s1_.image_size AS image_size_35, s1_.image_updated_at AS image_updated_at_36, s2_.id AS id_37, s2_.name AS name_38, s2_.content AS content_39, l3_.id AS id_40, l3_.name AS name_41, e0_.poll_id AS poll_id_42, e0_.event_group_id AS event_group_id_43, s2_.speaker_id AS speaker_id_44, s2_.lang_id AS lang_id_45 FROM event e0_ LEFT JOIN event_speaker e4_ ON e0_.id = e4_.event_id LEFT JOIN speaker s1_ ON s1_.id = e4_.speaker_id LEFT JOIN speaker_translate s2_ ON s1_.id = s2_.speaker_id LEFT JOIN language l3_ ON s2_.lang_id = l3_.id WHERE e0_.id = ?

Parameters:

[
  3
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  e0_.id AS id_0,
  e0_.slug AS slug_1,
  e0_.program_name AS program_name_2,
  e0_.program_original_name AS program_original_name_3,
  e0_.program_mime_type AS program_mime_type_4,
  e0_.program_size AS program_size_5,
  e0_.program_updated_at AS program_updated_at_6,
  e0_.is_activated AS is_activated_7,
  e0_.is_enabled AS is_enabled_8,
  e0_.start_at AS start_at_9,
  e0_.end_at AS end_at_10,
  e0_.status AS status_11,
  e0_.format AS format_12,
  e0_.created_at AS created_at_13,
  e0_.is_show_chat AS is_show_chat_14,
  e0_.is_registration AS is_registration_15,
  e0_.is_calendar AS is_calendar_16,
  e0_.is_nmo AS is_nmo_17,
  e0_.is_show_slider AS is_show_slider_18,
  e0_.image_name AS image_name_19,
  e0_.image_original_name AS image_original_name_20,
  e0_.image_mime_type AS image_mime_type_21,
  e0_.image_size AS image_size_22,
  e0_.image_updated_at AS image_updated_at_23,
  e0_.card_image_name AS card_image_name_24,
  e0_.card_image_original_name AS card_image_original_name_25,
  e0_.card_image_mime_type AS card_image_mime_type_26,
  e0_.card_image_size AS card_image_size_27,
  e0_.card_image_updated_at AS card_image_updated_at_28,
  s1_.id AS id_29,
  s1_.is_enabled AS is_enabled_30,
  s1_.created_at AS created_at_31,
  s1_.image_name AS image_name_32,
  s1_.image_original_name AS image_original_name_33,
  s1_.image_mime_type AS image_mime_type_34,
  s1_.image_size AS image_size_35,
  s1_.image_updated_at AS image_updated_at_36,
  s2_.id AS id_37,
  s2_.name AS name_38,
  s2_.content AS content_39,
  l3_.id AS id_40,
  l3_.name AS name_41,
  e0_.poll_id AS poll_id_42,
  e0_.event_group_id AS event_group_id_43,
  s2_.speaker_id AS speaker_id_44,
  s2_.lang_id AS lang_id_45
FROM
  event e0_
  LEFT JOIN event_speaker e4_ ON e0_.id = e4_.event_id
  LEFT JOIN speaker s1_ ON s1_.id = e4_.speaker_id
  LEFT JOIN speaker_translate s2_ ON s1_.id = s2_.speaker_id
  LEFT JOIN language l3_ ON s2_.lang_id = l3_.id
WHERE
  e0_.id = ?

SELECT e0_.id AS id_0, e0_.slug AS slug_1, e0_.program_name AS program_name_2, e0_.program_original_name AS program_original_name_3, e0_.program_mime_type AS program_mime_type_4, e0_.program_size AS program_size_5, e0_.program_updated_at AS program_updated_at_6, e0_.is_activated AS is_activated_7, e0_.is_enabled AS is_enabled_8, e0_.start_at AS start_at_9, e0_.end_at AS end_at_10, e0_.status AS status_11, e0_.format AS format_12, e0_.created_at AS created_at_13, e0_.is_show_chat AS is_show_chat_14, e0_.is_registration AS is_registration_15, e0_.is_calendar AS is_calendar_16, e0_.is_nmo AS is_nmo_17, e0_.is_show_slider AS is_show_slider_18, e0_.image_name AS image_name_19, e0_.image_original_name AS image_original_name_20, e0_.image_mime_type AS image_mime_type_21, e0_.image_size AS image_size_22, e0_.image_updated_at AS image_updated_at_23, e0_.card_image_name AS card_image_name_24, e0_.card_image_original_name AS card_image_original_name_25, e0_.card_image_mime_type AS card_image_mime_type_26, e0_.card_image_size AS card_image_size_27, e0_.card_image_updated_at AS card_image_updated_at_28, s1_.id AS id_29, s1_.is_enabled AS is_enabled_30, s1_.created_at AS created_at_31, s1_.image_name AS image_name_32, s1_.image_original_name AS image_original_name_33, s1_.image_mime_type AS image_mime_type_34, s1_.image_size AS image_size_35, s1_.image_updated_at AS image_updated_at_36, s2_.id AS id_37, s2_.name AS name_38, s2_.content AS content_39, l3_.id AS id_40, l3_.name AS name_41, e0_.poll_id AS poll_id_42, e0_.event_group_id AS event_group_id_43, s2_.speaker_id AS speaker_id_44, s2_.lang_id AS lang_id_45 FROM event e0_ LEFT JOIN event_speaker e4_ ON e0_.id = e4_.event_id LEFT JOIN speaker s1_ ON s1_.id = e4_.speaker_id LEFT JOIN speaker_translate s2_ ON s1_.id = s2_.speaker_id LEFT JOIN language l3_ ON s2_.lang_id = l3_.id WHERE e0_.id = 3;

#	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	App\Repository\Event\EventRepository->loadSpeakerCollection (line 135)
7	App\Repository\Event\EventRepository->findOneForPage (line 112)
8	App\Controller\EventController->eventPage (line 93)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
11	Symfony\Component\HttpKernel\Kernel->handle (line 193)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
13	require_once (line 32)
14	require_once (line 5)

0.57 ms
(7.83%)

SELECT e0_.id AS id_0, e0_.slug AS slug_1, e0_.program_name AS program_name_2, e0_.program_original_name AS program_original_name_3, e0_.program_mime_type AS program_mime_type_4, e0_.program_size AS program_size_5, e0_.program_updated_at AS program_updated_at_6, e0_.is_activated AS is_activated_7, e0_.is_enabled AS is_enabled_8, e0_.start_at AS start_at_9, e0_.end_at AS end_at_10, e0_.status AS status_11, e0_.format AS format_12, e0_.created_at AS created_at_13, e0_.is_show_chat AS is_show_chat_14, e0_.is_registration AS is_registration_15, e0_.is_calendar AS is_calendar_16, e0_.is_nmo AS is_nmo_17, e0_.is_show_slider AS is_show_slider_18, e0_.image_name AS image_name_19, e0_.image_original_name AS image_original_name_20, e0_.image_mime_type AS image_mime_type_21, e0_.image_size AS image_size_22, e0_.image_updated_at AS image_updated_at_23, e0_.card_image_name AS card_image_name_24, e0_.card_image_original_name AS card_image_original_name_25, e0_.card_image_mime_type AS card_image_mime_type_26, e0_.card_image_size AS card_image_size_27, e0_.card_image_updated_at AS card_image_updated_at_28, e1_.id AS id_29, e1_.website_url AS website_url_30, e1_.is_enabled AS is_enabled_31, e1_.is_show_in_partners AS is_show_in_partners_32, e1_.created_at AS created_at_33, e1_.image_name AS image_name_34, e1_.image_original_name AS image_original_name_35, e1_.image_mime_type AS image_mime_type_36, e1_.image_size AS image_size_37, e1_.image_updated_at AS image_updated_at_38, e2_.id AS id_39, e2_.title AS title_40, e2_.short_description AS short_description_41, l3_.id AS id_42, l3_.name AS name_43, e0_.poll_id AS poll_id_44, e0_.event_group_id AS event_group_id_45, e2_.lang_id AS lang_id_46, e2_.event_organization_id AS event_organization_id_47 FROM event e0_ LEFT JOIN event_organizer e4_ ON e0_.id = e4_.event_id LEFT JOIN event_organization e1_ ON e1_.id = e4_.event_organization_id LEFT JOIN event_organization_translate e2_ ON e1_.id = e2_.event_organization_id LEFT JOIN language l3_ ON e2_.lang_id = l3_.id WHERE e0_.id = ?

Parameters:

[
  3
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  e0_.id AS id_0,
  e0_.slug AS slug_1,
  e0_.program_name AS program_name_2,
  e0_.program_original_name AS program_original_name_3,
  e0_.program_mime_type AS program_mime_type_4,
  e0_.program_size AS program_size_5,
  e0_.program_updated_at AS program_updated_at_6,
  e0_.is_activated AS is_activated_7,
  e0_.is_enabled AS is_enabled_8,
  e0_.start_at AS start_at_9,
  e0_.end_at AS end_at_10,
  e0_.status AS status_11,
  e0_.format AS format_12,
  e0_.created_at AS created_at_13,
  e0_.is_show_chat AS is_show_chat_14,
  e0_.is_registration AS is_registration_15,
  e0_.is_calendar AS is_calendar_16,
  e0_.is_nmo AS is_nmo_17,
  e0_.is_show_slider AS is_show_slider_18,
  e0_.image_name AS image_name_19,
  e0_.image_original_name AS image_original_name_20,
  e0_.image_mime_type AS image_mime_type_21,
  e0_.image_size AS image_size_22,
  e0_.image_updated_at AS image_updated_at_23,
  e0_.card_image_name AS card_image_name_24,
  e0_.card_image_original_name AS card_image_original_name_25,
  e0_.card_image_mime_type AS card_image_mime_type_26,
  e0_.card_image_size AS card_image_size_27,
  e0_.card_image_updated_at AS card_image_updated_at_28,
  e1_.id AS id_29,
  e1_.website_url AS website_url_30,
  e1_.is_enabled AS is_enabled_31,
  e1_.is_show_in_partners AS is_show_in_partners_32,
  e1_.created_at AS created_at_33,
  e1_.image_name AS image_name_34,
  e1_.image_original_name AS image_original_name_35,
  e1_.image_mime_type AS image_mime_type_36,
  e1_.image_size AS image_size_37,
  e1_.image_updated_at AS image_updated_at_38,
  e2_.id AS id_39,
  e2_.title AS title_40,
  e2_.short_description AS short_description_41,
  l3_.id AS id_42,
  l3_.name AS name_43,
  e0_.poll_id AS poll_id_44,
  e0_.event_group_id AS event_group_id_45,
  e2_.lang_id AS lang_id_46,
  e2_.event_organization_id AS event_organization_id_47
FROM
  event e0_
  LEFT JOIN event_organizer e4_ ON e0_.id = e4_.event_id
  LEFT JOIN event_organization e1_ ON e1_.id = e4_.event_organization_id
  LEFT JOIN event_organization_translate e2_ ON e1_.id = e2_.event_organization_id
  LEFT JOIN language l3_ ON e2_.lang_id = l3_.id
WHERE
  e0_.id = ?

SELECT e0_.id AS id_0, e0_.slug AS slug_1, e0_.program_name AS program_name_2, e0_.program_original_name AS program_original_name_3, e0_.program_mime_type AS program_mime_type_4, e0_.program_size AS program_size_5, e0_.program_updated_at AS program_updated_at_6, e0_.is_activated AS is_activated_7, e0_.is_enabled AS is_enabled_8, e0_.start_at AS start_at_9, e0_.end_at AS end_at_10, e0_.status AS status_11, e0_.format AS format_12, e0_.created_at AS created_at_13, e0_.is_show_chat AS is_show_chat_14, e0_.is_registration AS is_registration_15, e0_.is_calendar AS is_calendar_16, e0_.is_nmo AS is_nmo_17, e0_.is_show_slider AS is_show_slider_18, e0_.image_name AS image_name_19, e0_.image_original_name AS image_original_name_20, e0_.image_mime_type AS image_mime_type_21, e0_.image_size AS image_size_22, e0_.image_updated_at AS image_updated_at_23, e0_.card_image_name AS card_image_name_24, e0_.card_image_original_name AS card_image_original_name_25, e0_.card_image_mime_type AS card_image_mime_type_26, e0_.card_image_size AS card_image_size_27, e0_.card_image_updated_at AS card_image_updated_at_28, e1_.id AS id_29, e1_.website_url AS website_url_30, e1_.is_enabled AS is_enabled_31, e1_.is_show_in_partners AS is_show_in_partners_32, e1_.created_at AS created_at_33, e1_.image_name AS image_name_34, e1_.image_original_name AS image_original_name_35, e1_.image_mime_type AS image_mime_type_36, e1_.image_size AS image_size_37, e1_.image_updated_at AS image_updated_at_38, e2_.id AS id_39, e2_.title AS title_40, e2_.short_description AS short_description_41, l3_.id AS id_42, l3_.name AS name_43, e0_.poll_id AS poll_id_44, e0_.event_group_id AS event_group_id_45, e2_.lang_id AS lang_id_46, e2_.event_organization_id AS event_organization_id_47 FROM event e0_ LEFT JOIN event_organizer e4_ ON e0_.id = e4_.event_id LEFT JOIN event_organization e1_ ON e1_.id = e4_.event_organization_id LEFT JOIN event_organization_translate e2_ ON e1_.id = e2_.event_organization_id LEFT JOIN language l3_ ON e2_.lang_id = l3_.id WHERE e0_.id = 3;

#	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	App\Repository\Event\EventRepository->loadOrganizationCollection (line 148)
7	App\Repository\Event\EventRepository->findOneForPage (line 115)
8	App\Controller\EventController->eventPage (line 93)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
11	Symfony\Component\HttpKernel\Kernel->handle (line 193)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
13	require_once (line 32)
14	require_once (line 5)

0.55 ms
(7.54%)

SELECT e0_.id AS id_0, e0_.slug AS slug_1, e0_.program_name AS program_name_2, e0_.program_original_name AS program_original_name_3, e0_.program_mime_type AS program_mime_type_4, e0_.program_size AS program_size_5, e0_.program_updated_at AS program_updated_at_6, e0_.is_activated AS is_activated_7, e0_.is_enabled AS is_enabled_8, e0_.start_at AS start_at_9, e0_.end_at AS end_at_10, e0_.status AS status_11, e0_.format AS format_12, e0_.created_at AS created_at_13, e0_.is_show_chat AS is_show_chat_14, e0_.is_registration AS is_registration_15, e0_.is_calendar AS is_calendar_16, e0_.is_nmo AS is_nmo_17, e0_.is_show_slider AS is_show_slider_18, e0_.image_name AS image_name_19, e0_.image_original_name AS image_original_name_20, e0_.image_mime_type AS image_mime_type_21, e0_.image_size AS image_size_22, e0_.image_updated_at AS image_updated_at_23, e0_.card_image_name AS card_image_name_24, e0_.card_image_original_name AS card_image_original_name_25, e0_.card_image_mime_type AS card_image_mime_type_26, e0_.card_image_size AS card_image_size_27, e0_.card_image_updated_at AS card_image_updated_at_28, s1_.id AS id_29, s1_.name AS name_30, s1_.type AS type_31, e0_.poll_id AS poll_id_32, e0_.event_group_id AS event_group_id_33 FROM event e0_ LEFT JOIN event_specialty e2_ ON e0_.id = e2_.event_id LEFT JOIN specialty s1_ ON s1_.id = e2_.specialty_id WHERE e0_.id = ?

Parameters:

[
  3
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  e0_.id AS id_0,
  e0_.slug AS slug_1,
  e0_.program_name AS program_name_2,
  e0_.program_original_name AS program_original_name_3,
  e0_.program_mime_type AS program_mime_type_4,
  e0_.program_size AS program_size_5,
  e0_.program_updated_at AS program_updated_at_6,
  e0_.is_activated AS is_activated_7,
  e0_.is_enabled AS is_enabled_8,
  e0_.start_at AS start_at_9,
  e0_.end_at AS end_at_10,
  e0_.status AS status_11,
  e0_.format AS format_12,
  e0_.created_at AS created_at_13,
  e0_.is_show_chat AS is_show_chat_14,
  e0_.is_registration AS is_registration_15,
  e0_.is_calendar AS is_calendar_16,
  e0_.is_nmo AS is_nmo_17,
  e0_.is_show_slider AS is_show_slider_18,
  e0_.image_name AS image_name_19,
  e0_.image_original_name AS image_original_name_20,
  e0_.image_mime_type AS image_mime_type_21,
  e0_.image_size AS image_size_22,
  e0_.image_updated_at AS image_updated_at_23,
  e0_.card_image_name AS card_image_name_24,
  e0_.card_image_original_name AS card_image_original_name_25,
  e0_.card_image_mime_type AS card_image_mime_type_26,
  e0_.card_image_size AS card_image_size_27,
  e0_.card_image_updated_at AS card_image_updated_at_28,
  s1_.id AS id_29,
  s1_.name AS name_30,
  s1_.type AS type_31,
  e0_.poll_id AS poll_id_32,
  e0_.event_group_id AS event_group_id_33
FROM
  event e0_
  LEFT JOIN event_specialty e2_ ON e0_.id = e2_.event_id
  LEFT JOIN specialty s1_ ON s1_.id = e2_.specialty_id
WHERE
  e0_.id = ?

SELECT e0_.id AS id_0, e0_.slug AS slug_1, e0_.program_name AS program_name_2, e0_.program_original_name AS program_original_name_3, e0_.program_mime_type AS program_mime_type_4, e0_.program_size AS program_size_5, e0_.program_updated_at AS program_updated_at_6, e0_.is_activated AS is_activated_7, e0_.is_enabled AS is_enabled_8, e0_.start_at AS start_at_9, e0_.end_at AS end_at_10, e0_.status AS status_11, e0_.format AS format_12, e0_.created_at AS created_at_13, e0_.is_show_chat AS is_show_chat_14, e0_.is_registration AS is_registration_15, e0_.is_calendar AS is_calendar_16, e0_.is_nmo AS is_nmo_17, e0_.is_show_slider AS is_show_slider_18, e0_.image_name AS image_name_19, e0_.image_original_name AS image_original_name_20, e0_.image_mime_type AS image_mime_type_21, e0_.image_size AS image_size_22, e0_.image_updated_at AS image_updated_at_23, e0_.card_image_name AS card_image_name_24, e0_.card_image_original_name AS card_image_original_name_25, e0_.card_image_mime_type AS card_image_mime_type_26, e0_.card_image_size AS card_image_size_27, e0_.card_image_updated_at AS card_image_updated_at_28, s1_.id AS id_29, s1_.name AS name_30, s1_.type AS type_31, e0_.poll_id AS poll_id_32, e0_.event_group_id AS event_group_id_33 FROM event e0_ LEFT JOIN event_specialty e2_ ON e0_.id = e2_.event_id LEFT JOIN specialty s1_ ON s1_.id = e2_.specialty_id WHERE e0_.id = 3;

#	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	App\Repository\Event\EventRepository->loadSimpleCollection (line 173)
7	App\Repository\Event\EventRepository->findOneForPage (line 114)
8	App\Controller\EventController->eventPage (line 93)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
11	Symfony\Component\HttpKernel\Kernel->handle (line 193)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
13	require_once (line 32)
14	require_once (line 5)

0.54 ms
(7.40%)

SELECT e0_.id AS id_0, e0_.slug AS slug_1, e0_.program_name AS program_name_2, e0_.program_original_name AS program_original_name_3, e0_.program_mime_type AS program_mime_type_4, e0_.program_size AS program_size_5, e0_.program_updated_at AS program_updated_at_6, e0_.is_activated AS is_activated_7, e0_.is_enabled AS is_enabled_8, e0_.start_at AS start_at_9, e0_.end_at AS end_at_10, e0_.status AS status_11, e0_.format AS format_12, e0_.created_at AS created_at_13, e0_.is_show_chat AS is_show_chat_14, e0_.is_registration AS is_registration_15, e0_.is_calendar AS is_calendar_16, e0_.is_nmo AS is_nmo_17, e0_.is_show_slider AS is_show_slider_18, e0_.image_name AS image_name_19, e0_.image_original_name AS image_original_name_20, e0_.image_mime_type AS image_mime_type_21, e0_.image_size AS image_size_22, e0_.image_updated_at AS image_updated_at_23, e0_.card_image_name AS card_image_name_24, e0_.card_image_original_name AS card_image_original_name_25, e0_.card_image_mime_type AS card_image_mime_type_26, e0_.card_image_size AS card_image_size_27, e0_.card_image_updated_at AS card_image_updated_at_28, s1_.id AS id_29, s1_.is_enabled AS is_enabled_30, s1_.created_at AS created_at_31, s1_.image_name AS image_name_32, s1_.image_original_name AS image_original_name_33, s1_.image_mime_type AS image_mime_type_34, s1_.image_size AS image_size_35, s1_.image_updated_at AS image_updated_at_36, s2_.id AS id_37, s2_.name AS name_38, s2_.content AS content_39, l3_.id AS id_40, l3_.name AS name_41, e0_.poll_id AS poll_id_42, e0_.event_group_id AS event_group_id_43, s2_.speaker_id AS speaker_id_44, s2_.lang_id AS lang_id_45 FROM event e0_ LEFT JOIN event_organizational_committee e4_ ON e0_.id = e4_.event_id LEFT JOIN speaker s1_ ON s1_.id = e4_.speaker_id LEFT JOIN speaker_translate s2_ ON s1_.id = s2_.speaker_id LEFT JOIN language l3_ ON s2_.lang_id = l3_.id WHERE e0_.id = ?

Parameters:

[
  3
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  e0_.id AS id_0,
  e0_.slug AS slug_1,
  e0_.program_name AS program_name_2,
  e0_.program_original_name AS program_original_name_3,
  e0_.program_mime_type AS program_mime_type_4,
  e0_.program_size AS program_size_5,
  e0_.program_updated_at AS program_updated_at_6,
  e0_.is_activated AS is_activated_7,
  e0_.is_enabled AS is_enabled_8,
  e0_.start_at AS start_at_9,
  e0_.end_at AS end_at_10,
  e0_.status AS status_11,
  e0_.format AS format_12,
  e0_.created_at AS created_at_13,
  e0_.is_show_chat AS is_show_chat_14,
  e0_.is_registration AS is_registration_15,
  e0_.is_calendar AS is_calendar_16,
  e0_.is_nmo AS is_nmo_17,
  e0_.is_show_slider AS is_show_slider_18,
  e0_.image_name AS image_name_19,
  e0_.image_original_name AS image_original_name_20,
  e0_.image_mime_type AS image_mime_type_21,
  e0_.image_size AS image_size_22,
  e0_.image_updated_at AS image_updated_at_23,
  e0_.card_image_name AS card_image_name_24,
  e0_.card_image_original_name AS card_image_original_name_25,
  e0_.card_image_mime_type AS card_image_mime_type_26,
  e0_.card_image_size AS card_image_size_27,
  e0_.card_image_updated_at AS card_image_updated_at_28,
  s1_.id AS id_29,
  s1_.is_enabled AS is_enabled_30,
  s1_.created_at AS created_at_31,
  s1_.image_name AS image_name_32,
  s1_.image_original_name AS image_original_name_33,
  s1_.image_mime_type AS image_mime_type_34,
  s1_.image_size AS image_size_35,
  s1_.image_updated_at AS image_updated_at_36,
  s2_.id AS id_37,
  s2_.name AS name_38,
  s2_.content AS content_39,
  l3_.id AS id_40,
  l3_.name AS name_41,
  e0_.poll_id AS poll_id_42,
  e0_.event_group_id AS event_group_id_43,
  s2_.speaker_id AS speaker_id_44,
  s2_.lang_id AS lang_id_45
FROM
  event e0_
  LEFT JOIN event_organizational_committee e4_ ON e0_.id = e4_.event_id
  LEFT JOIN speaker s1_ ON s1_.id = e4_.speaker_id
  LEFT JOIN speaker_translate s2_ ON s1_.id = s2_.speaker_id
  LEFT JOIN language l3_ ON s2_.lang_id = l3_.id
WHERE
  e0_.id = ?

SELECT e0_.id AS id_0, e0_.slug AS slug_1, e0_.program_name AS program_name_2, e0_.program_original_name AS program_original_name_3, e0_.program_mime_type AS program_mime_type_4, e0_.program_size AS program_size_5, e0_.program_updated_at AS program_updated_at_6, e0_.is_activated AS is_activated_7, e0_.is_enabled AS is_enabled_8, e0_.start_at AS start_at_9, e0_.end_at AS end_at_10, e0_.status AS status_11, e0_.format AS format_12, e0_.created_at AS created_at_13, e0_.is_show_chat AS is_show_chat_14, e0_.is_registration AS is_registration_15, e0_.is_calendar AS is_calendar_16, e0_.is_nmo AS is_nmo_17, e0_.is_show_slider AS is_show_slider_18, e0_.image_name AS image_name_19, e0_.image_original_name AS image_original_name_20, e0_.image_mime_type AS image_mime_type_21, e0_.image_size AS image_size_22, e0_.image_updated_at AS image_updated_at_23, e0_.card_image_name AS card_image_name_24, e0_.card_image_original_name AS card_image_original_name_25, e0_.card_image_mime_type AS card_image_mime_type_26, e0_.card_image_size AS card_image_size_27, e0_.card_image_updated_at AS card_image_updated_at_28, s1_.id AS id_29, s1_.is_enabled AS is_enabled_30, s1_.created_at AS created_at_31, s1_.image_name AS image_name_32, s1_.image_original_name AS image_original_name_33, s1_.image_mime_type AS image_mime_type_34, s1_.image_size AS image_size_35, s1_.image_updated_at AS image_updated_at_36, s2_.id AS id_37, s2_.name AS name_38, s2_.content AS content_39, l3_.id AS id_40, l3_.name AS name_41, e0_.poll_id AS poll_id_42, e0_.event_group_id AS event_group_id_43, s2_.speaker_id AS speaker_id_44, s2_.lang_id AS lang_id_45 FROM event e0_ LEFT JOIN event_organizational_committee e4_ ON e0_.id = e4_.event_id LEFT JOIN speaker s1_ ON s1_.id = e4_.speaker_id LEFT JOIN speaker_translate s2_ ON s1_.id = s2_.speaker_id LEFT JOIN language l3_ ON s2_.lang_id = l3_.id WHERE e0_.id = 3;

#	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	App\Repository\Event\EventRepository->loadSpeakerCollection (line 135)
7	App\Repository\Event\EventRepository->findOneForPage (line 113)
8	App\Controller\EventController->eventPage (line 93)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
11	Symfony\Component\HttpKernel\Kernel->handle (line 193)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
13	require_once (line 32)
14	require_once (line 5)

0.53 ms
(7.31%)

SELECT e0_.id AS id_0, e0_.slug AS slug_1, e0_.program_name AS program_name_2, e0_.program_original_name AS program_original_name_3, e0_.program_mime_type AS program_mime_type_4, e0_.program_size AS program_size_5, e0_.program_updated_at AS program_updated_at_6, e0_.is_activated AS is_activated_7, e0_.is_enabled AS is_enabled_8, e0_.start_at AS start_at_9, e0_.end_at AS end_at_10, e0_.status AS status_11, e0_.format AS format_12, e0_.created_at AS created_at_13, e0_.is_show_chat AS is_show_chat_14, e0_.is_registration AS is_registration_15, e0_.is_calendar AS is_calendar_16, e0_.is_nmo AS is_nmo_17, e0_.is_show_slider AS is_show_slider_18, e0_.image_name AS image_name_19, e0_.image_original_name AS image_original_name_20, e0_.image_mime_type AS image_mime_type_21, e0_.image_size AS image_size_22, e0_.image_updated_at AS image_updated_at_23, e0_.card_image_name AS card_image_name_24, e0_.card_image_original_name AS card_image_original_name_25, e0_.card_image_mime_type AS card_image_mime_type_26, e0_.card_image_size AS card_image_size_27, e0_.card_image_updated_at AS card_image_updated_at_28, e1_.id AS id_29, e1_.website_url AS website_url_30, e1_.is_enabled AS is_enabled_31, e1_.is_show_in_partners AS is_show_in_partners_32, e1_.created_at AS created_at_33, e1_.image_name AS image_name_34, e1_.image_original_name AS image_original_name_35, e1_.image_mime_type AS image_mime_type_36, e1_.image_size AS image_size_37, e1_.image_updated_at AS image_updated_at_38, e2_.id AS id_39, e2_.title AS title_40, e2_.short_description AS short_description_41, l3_.id AS id_42, l3_.name AS name_43, e0_.poll_id AS poll_id_44, e0_.event_group_id AS event_group_id_45, e2_.lang_id AS lang_id_46, e2_.event_organization_id AS event_organization_id_47 FROM event e0_ LEFT JOIN event_co_organizer e4_ ON e0_.id = e4_.event_id LEFT JOIN event_organization e1_ ON e1_.id = e4_.event_organization_id LEFT JOIN event_organization_translate e2_ ON e1_.id = e2_.event_organization_id LEFT JOIN language l3_ ON e2_.lang_id = l3_.id WHERE e0_.id = ?

Parameters:

[
  3
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  e0_.id AS id_0,
  e0_.slug AS slug_1,
  e0_.program_name AS program_name_2,
  e0_.program_original_name AS program_original_name_3,
  e0_.program_mime_type AS program_mime_type_4,
  e0_.program_size AS program_size_5,
  e0_.program_updated_at AS program_updated_at_6,
  e0_.is_activated AS is_activated_7,
  e0_.is_enabled AS is_enabled_8,
  e0_.start_at AS start_at_9,
  e0_.end_at AS end_at_10,
  e0_.status AS status_11,
  e0_.format AS format_12,
  e0_.created_at AS created_at_13,
  e0_.is_show_chat AS is_show_chat_14,
  e0_.is_registration AS is_registration_15,
  e0_.is_calendar AS is_calendar_16,
  e0_.is_nmo AS is_nmo_17,
  e0_.is_show_slider AS is_show_slider_18,
  e0_.image_name AS image_name_19,
  e0_.image_original_name AS image_original_name_20,
  e0_.image_mime_type AS image_mime_type_21,
  e0_.image_size AS image_size_22,
  e0_.image_updated_at AS image_updated_at_23,
  e0_.card_image_name AS card_image_name_24,
  e0_.card_image_original_name AS card_image_original_name_25,
  e0_.card_image_mime_type AS card_image_mime_type_26,
  e0_.card_image_size AS card_image_size_27,
  e0_.card_image_updated_at AS card_image_updated_at_28,
  e1_.id AS id_29,
  e1_.website_url AS website_url_30,
  e1_.is_enabled AS is_enabled_31,
  e1_.is_show_in_partners AS is_show_in_partners_32,
  e1_.created_at AS created_at_33,
  e1_.image_name AS image_name_34,
  e1_.image_original_name AS image_original_name_35,
  e1_.image_mime_type AS image_mime_type_36,
  e1_.image_size AS image_size_37,
  e1_.image_updated_at AS image_updated_at_38,
  e2_.id AS id_39,
  e2_.title AS title_40,
  e2_.short_description AS short_description_41,
  l3_.id AS id_42,
  l3_.name AS name_43,
  e0_.poll_id AS poll_id_44,
  e0_.event_group_id AS event_group_id_45,
  e2_.lang_id AS lang_id_46,
  e2_.event_organization_id AS event_organization_id_47
FROM
  event e0_
  LEFT JOIN event_co_organizer e4_ ON e0_.id = e4_.event_id
  LEFT JOIN event_organization e1_ ON e1_.id = e4_.event_organization_id
  LEFT JOIN event_organization_translate e2_ ON e1_.id = e2_.event_organization_id
  LEFT JOIN language l3_ ON e2_.lang_id = l3_.id
WHERE
  e0_.id = ?

SELECT e0_.id AS id_0, e0_.slug AS slug_1, e0_.program_name AS program_name_2, e0_.program_original_name AS program_original_name_3, e0_.program_mime_type AS program_mime_type_4, e0_.program_size AS program_size_5, e0_.program_updated_at AS program_updated_at_6, e0_.is_activated AS is_activated_7, e0_.is_enabled AS is_enabled_8, e0_.start_at AS start_at_9, e0_.end_at AS end_at_10, e0_.status AS status_11, e0_.format AS format_12, e0_.created_at AS created_at_13, e0_.is_show_chat AS is_show_chat_14, e0_.is_registration AS is_registration_15, e0_.is_calendar AS is_calendar_16, e0_.is_nmo AS is_nmo_17, e0_.is_show_slider AS is_show_slider_18, e0_.image_name AS image_name_19, e0_.image_original_name AS image_original_name_20, e0_.image_mime_type AS image_mime_type_21, e0_.image_size AS image_size_22, e0_.image_updated_at AS image_updated_at_23, e0_.card_image_name AS card_image_name_24, e0_.card_image_original_name AS card_image_original_name_25, e0_.card_image_mime_type AS card_image_mime_type_26, e0_.card_image_size AS card_image_size_27, e0_.card_image_updated_at AS card_image_updated_at_28, e1_.id AS id_29, e1_.website_url AS website_url_30, e1_.is_enabled AS is_enabled_31, e1_.is_show_in_partners AS is_show_in_partners_32, e1_.created_at AS created_at_33, e1_.image_name AS image_name_34, e1_.image_original_name AS image_original_name_35, e1_.image_mime_type AS image_mime_type_36, e1_.image_size AS image_size_37, e1_.image_updated_at AS image_updated_at_38, e2_.id AS id_39, e2_.title AS title_40, e2_.short_description AS short_description_41, l3_.id AS id_42, l3_.name AS name_43, e0_.poll_id AS poll_id_44, e0_.event_group_id AS event_group_id_45, e2_.lang_id AS lang_id_46, e2_.event_organization_id AS event_organization_id_47 FROM event e0_ LEFT JOIN event_co_organizer e4_ ON e0_.id = e4_.event_id LEFT JOIN event_organization e1_ ON e1_.id = e4_.event_organization_id LEFT JOIN event_organization_translate e2_ ON e1_.id = e2_.event_organization_id LEFT JOIN language l3_ ON e2_.lang_id = l3_.id WHERE e0_.id = 3;

#	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	App\Repository\Event\EventRepository->loadOrganizationCollection (line 148)
7	App\Repository\Event\EventRepository->findOneForPage (line 116)
8	App\Controller\EventController->eventPage (line 93)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
11	Symfony\Component\HttpKernel\Kernel->handle (line 193)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
13	require_once (line 32)
14	require_once (line 5)

0.52 ms
(7.18%)

SELECT e0_.id AS id_0, e0_.slug AS slug_1, e0_.program_name AS program_name_2, e0_.program_original_name AS program_original_name_3, e0_.program_mime_type AS program_mime_type_4, e0_.program_size AS program_size_5, e0_.program_updated_at AS program_updated_at_6, e0_.is_activated AS is_activated_7, e0_.is_enabled AS is_enabled_8, e0_.start_at AS start_at_9, e0_.end_at AS end_at_10, e0_.status AS status_11, e0_.format AS format_12, e0_.created_at AS created_at_13, e0_.is_show_chat AS is_show_chat_14, e0_.is_registration AS is_registration_15, e0_.is_calendar AS is_calendar_16, e0_.is_nmo AS is_nmo_17, e0_.is_show_slider AS is_show_slider_18, e0_.image_name AS image_name_19, e0_.image_original_name AS image_original_name_20, e0_.image_mime_type AS image_mime_type_21, e0_.image_size AS image_size_22, e0_.image_updated_at AS image_updated_at_23, e0_.card_image_name AS card_image_name_24, e0_.card_image_original_name AS card_image_original_name_25, e0_.card_image_mime_type AS card_image_mime_type_26, e0_.card_image_size AS card_image_size_27, e0_.card_image_updated_at AS card_image_updated_at_28, e1_.id AS id_29, e1_.website_url AS website_url_30, e1_.is_enabled AS is_enabled_31, e1_.is_show_in_partners AS is_show_in_partners_32, e1_.created_at AS created_at_33, e1_.image_name AS image_name_34, e1_.image_original_name AS image_original_name_35, e1_.image_mime_type AS image_mime_type_36, e1_.image_size AS image_size_37, e1_.image_updated_at AS image_updated_at_38, e2_.id AS id_39, e2_.title AS title_40, e2_.short_description AS short_description_41, l3_.id AS id_42, l3_.name AS name_43, e0_.poll_id AS poll_id_44, e0_.event_group_id AS event_group_id_45, e2_.lang_id AS lang_id_46, e2_.event_organization_id AS event_organization_id_47 FROM event e0_ LEFT JOIN event_information_partner e4_ ON e0_.id = e4_.event_id LEFT JOIN event_organization e1_ ON e1_.id = e4_.event_organization_id LEFT JOIN event_organization_translate e2_ ON e1_.id = e2_.event_organization_id LEFT JOIN language l3_ ON e2_.lang_id = l3_.id WHERE e0_.id = ?

Parameters:

[
  3
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  e0_.id AS id_0,
  e0_.slug AS slug_1,
  e0_.program_name AS program_name_2,
  e0_.program_original_name AS program_original_name_3,
  e0_.program_mime_type AS program_mime_type_4,
  e0_.program_size AS program_size_5,
  e0_.program_updated_at AS program_updated_at_6,
  e0_.is_activated AS is_activated_7,
  e0_.is_enabled AS is_enabled_8,
  e0_.start_at AS start_at_9,
  e0_.end_at AS end_at_10,
  e0_.status AS status_11,
  e0_.format AS format_12,
  e0_.created_at AS created_at_13,
  e0_.is_show_chat AS is_show_chat_14,
  e0_.is_registration AS is_registration_15,
  e0_.is_calendar AS is_calendar_16,
  e0_.is_nmo AS is_nmo_17,
  e0_.is_show_slider AS is_show_slider_18,
  e0_.image_name AS image_name_19,
  e0_.image_original_name AS image_original_name_20,
  e0_.image_mime_type AS image_mime_type_21,
  e0_.image_size AS image_size_22,
  e0_.image_updated_at AS image_updated_at_23,
  e0_.card_image_name AS card_image_name_24,
  e0_.card_image_original_name AS card_image_original_name_25,
  e0_.card_image_mime_type AS card_image_mime_type_26,
  e0_.card_image_size AS card_image_size_27,
  e0_.card_image_updated_at AS card_image_updated_at_28,
  e1_.id AS id_29,
  e1_.website_url AS website_url_30,
  e1_.is_enabled AS is_enabled_31,
  e1_.is_show_in_partners AS is_show_in_partners_32,
  e1_.created_at AS created_at_33,
  e1_.image_name AS image_name_34,
  e1_.image_original_name AS image_original_name_35,
  e1_.image_mime_type AS image_mime_type_36,
  e1_.image_size AS image_size_37,
  e1_.image_updated_at AS image_updated_at_38,
  e2_.id AS id_39,
  e2_.title AS title_40,
  e2_.short_description AS short_description_41,
  l3_.id AS id_42,
  l3_.name AS name_43,
  e0_.poll_id AS poll_id_44,
  e0_.event_group_id AS event_group_id_45,
  e2_.lang_id AS lang_id_46,
  e2_.event_organization_id AS event_organization_id_47
FROM
  event e0_
  LEFT JOIN event_information_partner e4_ ON e0_.id = e4_.event_id
  LEFT JOIN event_organization e1_ ON e1_.id = e4_.event_organization_id
  LEFT JOIN event_organization_translate e2_ ON e1_.id = e2_.event_organization_id
  LEFT JOIN language l3_ ON e2_.lang_id = l3_.id
WHERE
  e0_.id = ?

SELECT e0_.id AS id_0, e0_.slug AS slug_1, e0_.program_name AS program_name_2, e0_.program_original_name AS program_original_name_3, e0_.program_mime_type AS program_mime_type_4, e0_.program_size AS program_size_5, e0_.program_updated_at AS program_updated_at_6, e0_.is_activated AS is_activated_7, e0_.is_enabled AS is_enabled_8, e0_.start_at AS start_at_9, e0_.end_at AS end_at_10, e0_.status AS status_11, e0_.format AS format_12, e0_.created_at AS created_at_13, e0_.is_show_chat AS is_show_chat_14, e0_.is_registration AS is_registration_15, e0_.is_calendar AS is_calendar_16, e0_.is_nmo AS is_nmo_17, e0_.is_show_slider AS is_show_slider_18, e0_.image_name AS image_name_19, e0_.image_original_name AS image_original_name_20, e0_.image_mime_type AS image_mime_type_21, e0_.image_size AS image_size_22, e0_.image_updated_at AS image_updated_at_23, e0_.card_image_name AS card_image_name_24, e0_.card_image_original_name AS card_image_original_name_25, e0_.card_image_mime_type AS card_image_mime_type_26, e0_.card_image_size AS card_image_size_27, e0_.card_image_updated_at AS card_image_updated_at_28, e1_.id AS id_29, e1_.website_url AS website_url_30, e1_.is_enabled AS is_enabled_31, e1_.is_show_in_partners AS is_show_in_partners_32, e1_.created_at AS created_at_33, e1_.image_name AS image_name_34, e1_.image_original_name AS image_original_name_35, e1_.image_mime_type AS image_mime_type_36, e1_.image_size AS image_size_37, e1_.image_updated_at AS image_updated_at_38, e2_.id AS id_39, e2_.title AS title_40, e2_.short_description AS short_description_41, l3_.id AS id_42, l3_.name AS name_43, e0_.poll_id AS poll_id_44, e0_.event_group_id AS event_group_id_45, e2_.lang_id AS lang_id_46, e2_.event_organization_id AS event_organization_id_47 FROM event e0_ LEFT JOIN event_information_partner e4_ ON e0_.id = e4_.event_id LEFT JOIN event_organization e1_ ON e1_.id = e4_.event_organization_id LEFT JOIN event_organization_translate e2_ ON e1_.id = e2_.event_organization_id LEFT JOIN language l3_ ON e2_.lang_id = l3_.id WHERE e0_.id = 3;

#	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	App\Repository\Event\EventRepository->loadOrganizationCollection (line 148)
7	App\Repository\Event\EventRepository->findOneForPage (line 119)
8	App\Controller\EventController->eventPage (line 93)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
11	Symfony\Component\HttpKernel\Kernel->handle (line 193)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
13	require_once (line 32)
14	require_once (line 5)

0.52 ms
(7.13%)

SELECT e0_.id AS id_0, e0_.slug AS slug_1, e0_.program_name AS program_name_2, e0_.program_original_name AS program_original_name_3, e0_.program_mime_type AS program_mime_type_4, e0_.program_size AS program_size_5, e0_.program_updated_at AS program_updated_at_6, e0_.is_activated AS is_activated_7, e0_.is_enabled AS is_enabled_8, e0_.start_at AS start_at_9, e0_.end_at AS end_at_10, e0_.status AS status_11, e0_.format AS format_12, e0_.created_at AS created_at_13, e0_.is_show_chat AS is_show_chat_14, e0_.is_registration AS is_registration_15, e0_.is_calendar AS is_calendar_16, e0_.is_nmo AS is_nmo_17, e0_.is_show_slider AS is_show_slider_18, e0_.image_name AS image_name_19, e0_.image_original_name AS image_original_name_20, e0_.image_mime_type AS image_mime_type_21, e0_.image_size AS image_size_22, e0_.image_updated_at AS image_updated_at_23, e0_.card_image_name AS card_image_name_24, e0_.card_image_original_name AS card_image_original_name_25, e0_.card_image_mime_type AS card_image_mime_type_26, e0_.card_image_size AS card_image_size_27, e0_.card_image_updated_at AS card_image_updated_at_28, c1_.id AS id_29, c1_.name AS name_30, c1_.type AS type_31, c1_.background_image AS background_image_32, c1_.background_original_name AS background_original_name_33, c1_.background_mime_type AS background_mime_type_34, c1_.orientation AS orientation_35, c1_.page_format AS page_format_36, c1_.page_width AS page_width_37, c1_.page_height AS page_height_38, c1_.font_family AS font_family_39, c1_.default_font_size AS default_font_size_40, c1_.default_text_color AS default_text_color_41, c1_.created_at AS created_at_42, c1_.updated_at AS updated_at_43, c1_.is_activated AS is_activated_44, c1_.is_enabled AS is_enabled_45, c1_.description AS description_46, e0_.poll_id AS poll_id_47, e0_.event_group_id AS event_group_id_48, c1_.owner_id AS owner_id_49, c1_.event_id AS event_id_50, c1_.test_id AS test_id_51 FROM event e0_ LEFT JOIN custom_certificate c1_ ON e0_.id = c1_.event_id WHERE e0_.id = ?

Parameters:

[
  3
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  e0_.id AS id_0,
  e0_.slug AS slug_1,
  e0_.program_name AS program_name_2,
  e0_.program_original_name AS program_original_name_3,
  e0_.program_mime_type AS program_mime_type_4,
  e0_.program_size AS program_size_5,
  e0_.program_updated_at AS program_updated_at_6,
  e0_.is_activated AS is_activated_7,
  e0_.is_enabled AS is_enabled_8,
  e0_.start_at AS start_at_9,
  e0_.end_at AS end_at_10,
  e0_.status AS status_11,
  e0_.format AS format_12,
  e0_.created_at AS created_at_13,
  e0_.is_show_chat AS is_show_chat_14,
  e0_.is_registration AS is_registration_15,
  e0_.is_calendar AS is_calendar_16,
  e0_.is_nmo AS is_nmo_17,
  e0_.is_show_slider AS is_show_slider_18,
  e0_.image_name AS image_name_19,
  e0_.image_original_name AS image_original_name_20,
  e0_.image_mime_type AS image_mime_type_21,
  e0_.image_size AS image_size_22,
  e0_.image_updated_at AS image_updated_at_23,
  e0_.card_image_name AS card_image_name_24,
  e0_.card_image_original_name AS card_image_original_name_25,
  e0_.card_image_mime_type AS card_image_mime_type_26,
  e0_.card_image_size AS card_image_size_27,
  e0_.card_image_updated_at AS card_image_updated_at_28,
  c1_.id AS id_29,
  c1_.name AS name_30,
  c1_.type AS type_31,
  c1_.background_image AS background_image_32,
  c1_.background_original_name AS background_original_name_33,
  c1_.background_mime_type AS background_mime_type_34,
  c1_.orientation AS orientation_35,
  c1_.page_format AS page_format_36,
  c1_.page_width AS page_width_37,
  c1_.page_height AS page_height_38,
  c1_.font_family AS font_family_39,
  c1_.default_font_size AS default_font_size_40,
  c1_.default_text_color AS default_text_color_41,
  c1_.created_at AS created_at_42,
  c1_.updated_at AS updated_at_43,
  c1_.is_activated AS is_activated_44,
  c1_.is_enabled AS is_enabled_45,
  c1_.description AS description_46,
  e0_.poll_id AS poll_id_47,
  e0_.event_group_id AS event_group_id_48,
  c1_.owner_id AS owner_id_49,
  c1_.event_id AS event_id_50,
  c1_.test_id AS test_id_51
FROM
  event e0_
  LEFT JOIN custom_certificate c1_ ON e0_.id = c1_.event_id
WHERE
  e0_.id = ?

SELECT e0_.id AS id_0, e0_.slug AS slug_1, e0_.program_name AS program_name_2, e0_.program_original_name AS program_original_name_3, e0_.program_mime_type AS program_mime_type_4, e0_.program_size AS program_size_5, e0_.program_updated_at AS program_updated_at_6, e0_.is_activated AS is_activated_7, e0_.is_enabled AS is_enabled_8, e0_.start_at AS start_at_9, e0_.end_at AS end_at_10, e0_.status AS status_11, e0_.format AS format_12, e0_.created_at AS created_at_13, e0_.is_show_chat AS is_show_chat_14, e0_.is_registration AS is_registration_15, e0_.is_calendar AS is_calendar_16, e0_.is_nmo AS is_nmo_17, e0_.is_show_slider AS is_show_slider_18, e0_.image_name AS image_name_19, e0_.image_original_name AS image_original_name_20, e0_.image_mime_type AS image_mime_type_21, e0_.image_size AS image_size_22, e0_.image_updated_at AS image_updated_at_23, e0_.card_image_name AS card_image_name_24, e0_.card_image_original_name AS card_image_original_name_25, e0_.card_image_mime_type AS card_image_mime_type_26, e0_.card_image_size AS card_image_size_27, e0_.card_image_updated_at AS card_image_updated_at_28, c1_.id AS id_29, c1_.name AS name_30, c1_.type AS type_31, c1_.background_image AS background_image_32, c1_.background_original_name AS background_original_name_33, c1_.background_mime_type AS background_mime_type_34, c1_.orientation AS orientation_35, c1_.page_format AS page_format_36, c1_.page_width AS page_width_37, c1_.page_height AS page_height_38, c1_.font_family AS font_family_39, c1_.default_font_size AS default_font_size_40, c1_.default_text_color AS default_text_color_41, c1_.created_at AS created_at_42, c1_.updated_at AS updated_at_43, c1_.is_activated AS is_activated_44, c1_.is_enabled AS is_enabled_45, c1_.description AS description_46, e0_.poll_id AS poll_id_47, e0_.event_group_id AS event_group_id_48, c1_.owner_id AS owner_id_49, c1_.event_id AS event_id_50, c1_.test_id AS test_id_51 FROM event e0_ LEFT JOIN custom_certificate c1_ ON e0_.id = c1_.event_id WHERE e0_.id = 3;

#	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	App\Repository\Event\EventRepository->loadSimpleCollection (line 173)
7	App\Repository\Event\EventRepository->findOneForPage (line 121)
8	App\Controller\EventController->eventPage (line 93)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
11	Symfony\Component\HttpKernel\Kernel->handle (line 193)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
13	require_once (line 32)
14	require_once (line 5)

0.49 ms
(6.80%)

SELECT e0_.id AS id_0, e0_.slug AS slug_1, e0_.program_name AS program_name_2, e0_.program_original_name AS program_original_name_3, e0_.program_mime_type AS program_mime_type_4, e0_.program_size AS program_size_5, e0_.program_updated_at AS program_updated_at_6, e0_.is_activated AS is_activated_7, e0_.is_enabled AS is_enabled_8, e0_.start_at AS start_at_9, e0_.end_at AS end_at_10, e0_.status AS status_11, e0_.format AS format_12, e0_.created_at AS created_at_13, e0_.is_show_chat AS is_show_chat_14, e0_.is_registration AS is_registration_15, e0_.is_calendar AS is_calendar_16, e0_.is_nmo AS is_nmo_17, e0_.is_show_slider AS is_show_slider_18, e0_.image_name AS image_name_19, e0_.image_original_name AS image_original_name_20, e0_.image_mime_type AS image_mime_type_21, e0_.image_size AS image_size_22, e0_.image_updated_at AS image_updated_at_23, e0_.card_image_name AS card_image_name_24, e0_.card_image_original_name AS card_image_original_name_25, e0_.card_image_mime_type AS card_image_mime_type_26, e0_.card_image_size AS card_image_size_27, e0_.card_image_updated_at AS card_image_updated_at_28, e1_.id AS id_29, e1_.website_url AS website_url_30, e1_.is_enabled AS is_enabled_31, e1_.is_show_in_partners AS is_show_in_partners_32, e1_.created_at AS created_at_33, e1_.image_name AS image_name_34, e1_.image_original_name AS image_original_name_35, e1_.image_mime_type AS image_mime_type_36, e1_.image_size AS image_size_37, e1_.image_updated_at AS image_updated_at_38, e2_.id AS id_39, e2_.title AS title_40, e2_.short_description AS short_description_41, l3_.id AS id_42, l3_.name AS name_43, e0_.poll_id AS poll_id_44, e0_.event_group_id AS event_group_id_45, e2_.lang_id AS lang_id_46, e2_.event_organization_id AS event_organization_id_47 FROM event e0_ LEFT JOIN event_supporter e4_ ON e0_.id = e4_.event_id LEFT JOIN event_organization e1_ ON e1_.id = e4_.event_organization_id LEFT JOIN event_organization_translate e2_ ON e1_.id = e2_.event_organization_id LEFT JOIN language l3_ ON e2_.lang_id = l3_.id WHERE e0_.id = ?

Parameters:

[
  3
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  e0_.id AS id_0,
  e0_.slug AS slug_1,
  e0_.program_name AS program_name_2,
  e0_.program_original_name AS program_original_name_3,
  e0_.program_mime_type AS program_mime_type_4,
  e0_.program_size AS program_size_5,
  e0_.program_updated_at AS program_updated_at_6,
  e0_.is_activated AS is_activated_7,
  e0_.is_enabled AS is_enabled_8,
  e0_.start_at AS start_at_9,
  e0_.end_at AS end_at_10,
  e0_.status AS status_11,
  e0_.format AS format_12,
  e0_.created_at AS created_at_13,
  e0_.is_show_chat AS is_show_chat_14,
  e0_.is_registration AS is_registration_15,
  e0_.is_calendar AS is_calendar_16,
  e0_.is_nmo AS is_nmo_17,
  e0_.is_show_slider AS is_show_slider_18,
  e0_.image_name AS image_name_19,
  e0_.image_original_name AS image_original_name_20,
  e0_.image_mime_type AS image_mime_type_21,
  e0_.image_size AS image_size_22,
  e0_.image_updated_at AS image_updated_at_23,
  e0_.card_image_name AS card_image_name_24,
  e0_.card_image_original_name AS card_image_original_name_25,
  e0_.card_image_mime_type AS card_image_mime_type_26,
  e0_.card_image_size AS card_image_size_27,
  e0_.card_image_updated_at AS card_image_updated_at_28,
  e1_.id AS id_29,
  e1_.website_url AS website_url_30,
  e1_.is_enabled AS is_enabled_31,
  e1_.is_show_in_partners AS is_show_in_partners_32,
  e1_.created_at AS created_at_33,
  e1_.image_name AS image_name_34,
  e1_.image_original_name AS image_original_name_35,
  e1_.image_mime_type AS image_mime_type_36,
  e1_.image_size AS image_size_37,
  e1_.image_updated_at AS image_updated_at_38,
  e2_.id AS id_39,
  e2_.title AS title_40,
  e2_.short_description AS short_description_41,
  l3_.id AS id_42,
  l3_.name AS name_43,
  e0_.poll_id AS poll_id_44,
  e0_.event_group_id AS event_group_id_45,
  e2_.lang_id AS lang_id_46,
  e2_.event_organization_id AS event_organization_id_47
FROM
  event e0_
  LEFT JOIN event_supporter e4_ ON e0_.id = e4_.event_id
  LEFT JOIN event_organization e1_ ON e1_.id = e4_.event_organization_id
  LEFT JOIN event_organization_translate e2_ ON e1_.id = e2_.event_organization_id
  LEFT JOIN language l3_ ON e2_.lang_id = l3_.id
WHERE
  e0_.id = ?

SELECT e0_.id AS id_0, e0_.slug AS slug_1, e0_.program_name AS program_name_2, e0_.program_original_name AS program_original_name_3, e0_.program_mime_type AS program_mime_type_4, e0_.program_size AS program_size_5, e0_.program_updated_at AS program_updated_at_6, e0_.is_activated AS is_activated_7, e0_.is_enabled AS is_enabled_8, e0_.start_at AS start_at_9, e0_.end_at AS end_at_10, e0_.status AS status_11, e0_.format AS format_12, e0_.created_at AS created_at_13, e0_.is_show_chat AS is_show_chat_14, e0_.is_registration AS is_registration_15, e0_.is_calendar AS is_calendar_16, e0_.is_nmo AS is_nmo_17, e0_.is_show_slider AS is_show_slider_18, e0_.image_name AS image_name_19, e0_.image_original_name AS image_original_name_20, e0_.image_mime_type AS image_mime_type_21, e0_.image_size AS image_size_22, e0_.image_updated_at AS image_updated_at_23, e0_.card_image_name AS card_image_name_24, e0_.card_image_original_name AS card_image_original_name_25, e0_.card_image_mime_type AS card_image_mime_type_26, e0_.card_image_size AS card_image_size_27, e0_.card_image_updated_at AS card_image_updated_at_28, e1_.id AS id_29, e1_.website_url AS website_url_30, e1_.is_enabled AS is_enabled_31, e1_.is_show_in_partners AS is_show_in_partners_32, e1_.created_at AS created_at_33, e1_.image_name AS image_name_34, e1_.image_original_name AS image_original_name_35, e1_.image_mime_type AS image_mime_type_36, e1_.image_size AS image_size_37, e1_.image_updated_at AS image_updated_at_38, e2_.id AS id_39, e2_.title AS title_40, e2_.short_description AS short_description_41, l3_.id AS id_42, l3_.name AS name_43, e0_.poll_id AS poll_id_44, e0_.event_group_id AS event_group_id_45, e2_.lang_id AS lang_id_46, e2_.event_organization_id AS event_organization_id_47 FROM event e0_ LEFT JOIN event_supporter e4_ ON e0_.id = e4_.event_id LEFT JOIN event_organization e1_ ON e1_.id = e4_.event_organization_id LEFT JOIN event_organization_translate e2_ ON e1_.id = e2_.event_organization_id LEFT JOIN language l3_ ON e2_.lang_id = l3_.id WHERE e0_.id = 3;

#	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	App\Repository\Event\EventRepository->loadOrganizationCollection (line 148)
7	App\Repository\Event\EventRepository->findOneForPage (line 117)
8	App\Controller\EventController->eventPage (line 93)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
11	Symfony\Component\HttpKernel\Kernel->handle (line 193)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
13	require_once (line 32)
14	require_once (line 5)

0.49 ms
(6.73%)

SELECT e0_.id AS id_0, e0_.slug AS slug_1, e0_.program_name AS program_name_2, e0_.program_original_name AS program_original_name_3, e0_.program_mime_type AS program_mime_type_4, e0_.program_size AS program_size_5, e0_.program_updated_at AS program_updated_at_6, e0_.is_activated AS is_activated_7, e0_.is_enabled AS is_enabled_8, e0_.start_at AS start_at_9, e0_.end_at AS end_at_10, e0_.status AS status_11, e0_.format AS format_12, e0_.created_at AS created_at_13, e0_.is_show_chat AS is_show_chat_14, e0_.is_registration AS is_registration_15, e0_.is_calendar AS is_calendar_16, e0_.is_nmo AS is_nmo_17, e0_.is_show_slider AS is_show_slider_18, e0_.image_name AS image_name_19, e0_.image_original_name AS image_original_name_20, e0_.image_mime_type AS image_mime_type_21, e0_.image_size AS image_size_22, e0_.image_updated_at AS image_updated_at_23, e0_.card_image_name AS card_image_name_24, e0_.card_image_original_name AS card_image_original_name_25, e0_.card_image_mime_type AS card_image_mime_type_26, e0_.card_image_size AS card_image_size_27, e0_.card_image_updated_at AS card_image_updated_at_28, e1_.id AS id_29, e1_.website_url AS website_url_30, e1_.is_enabled AS is_enabled_31, e1_.is_show_in_partners AS is_show_in_partners_32, e1_.created_at AS created_at_33, e1_.image_name AS image_name_34, e1_.image_original_name AS image_original_name_35, e1_.image_mime_type AS image_mime_type_36, e1_.image_size AS image_size_37, e1_.image_updated_at AS image_updated_at_38, e2_.id AS id_39, e2_.title AS title_40, e2_.short_description AS short_description_41, l3_.id AS id_42, l3_.name AS name_43, e0_.poll_id AS poll_id_44, e0_.event_group_id AS event_group_id_45, e2_.lang_id AS lang_id_46, e2_.event_organization_id AS event_organization_id_47 FROM event e0_ LEFT JOIN event_partner e4_ ON e0_.id = e4_.event_id LEFT JOIN event_organization e1_ ON e1_.id = e4_.event_organization_id LEFT JOIN event_organization_translate e2_ ON e1_.id = e2_.event_organization_id LEFT JOIN language l3_ ON e2_.lang_id = l3_.id WHERE e0_.id = ?

Parameters:

[
  3
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  e0_.id AS id_0,
  e0_.slug AS slug_1,
  e0_.program_name AS program_name_2,
  e0_.program_original_name AS program_original_name_3,
  e0_.program_mime_type AS program_mime_type_4,
  e0_.program_size AS program_size_5,
  e0_.program_updated_at AS program_updated_at_6,
  e0_.is_activated AS is_activated_7,
  e0_.is_enabled AS is_enabled_8,
  e0_.start_at AS start_at_9,
  e0_.end_at AS end_at_10,
  e0_.status AS status_11,
  e0_.format AS format_12,
  e0_.created_at AS created_at_13,
  e0_.is_show_chat AS is_show_chat_14,
  e0_.is_registration AS is_registration_15,
  e0_.is_calendar AS is_calendar_16,
  e0_.is_nmo AS is_nmo_17,
  e0_.is_show_slider AS is_show_slider_18,
  e0_.image_name AS image_name_19,
  e0_.image_original_name AS image_original_name_20,
  e0_.image_mime_type AS image_mime_type_21,
  e0_.image_size AS image_size_22,
  e0_.image_updated_at AS image_updated_at_23,
  e0_.card_image_name AS card_image_name_24,
  e0_.card_image_original_name AS card_image_original_name_25,
  e0_.card_image_mime_type AS card_image_mime_type_26,
  e0_.card_image_size AS card_image_size_27,
  e0_.card_image_updated_at AS card_image_updated_at_28,
  e1_.id AS id_29,
  e1_.website_url AS website_url_30,
  e1_.is_enabled AS is_enabled_31,
  e1_.is_show_in_partners AS is_show_in_partners_32,
  e1_.created_at AS created_at_33,
  e1_.image_name AS image_name_34,
  e1_.image_original_name AS image_original_name_35,
  e1_.image_mime_type AS image_mime_type_36,
  e1_.image_size AS image_size_37,
  e1_.image_updated_at AS image_updated_at_38,
  e2_.id AS id_39,
  e2_.title AS title_40,
  e2_.short_description AS short_description_41,
  l3_.id AS id_42,
  l3_.name AS name_43,
  e0_.poll_id AS poll_id_44,
  e0_.event_group_id AS event_group_id_45,
  e2_.lang_id AS lang_id_46,
  e2_.event_organization_id AS event_organization_id_47
FROM
  event e0_
  LEFT JOIN event_partner e4_ ON e0_.id = e4_.event_id
  LEFT JOIN event_organization e1_ ON e1_.id = e4_.event_organization_id
  LEFT JOIN event_organization_translate e2_ ON e1_.id = e2_.event_organization_id
  LEFT JOIN language l3_ ON e2_.lang_id = l3_.id
WHERE
  e0_.id = ?

SELECT e0_.id AS id_0, e0_.slug AS slug_1, e0_.program_name AS program_name_2, e0_.program_original_name AS program_original_name_3, e0_.program_mime_type AS program_mime_type_4, e0_.program_size AS program_size_5, e0_.program_updated_at AS program_updated_at_6, e0_.is_activated AS is_activated_7, e0_.is_enabled AS is_enabled_8, e0_.start_at AS start_at_9, e0_.end_at AS end_at_10, e0_.status AS status_11, e0_.format AS format_12, e0_.created_at AS created_at_13, e0_.is_show_chat AS is_show_chat_14, e0_.is_registration AS is_registration_15, e0_.is_calendar AS is_calendar_16, e0_.is_nmo AS is_nmo_17, e0_.is_show_slider AS is_show_slider_18, e0_.image_name AS image_name_19, e0_.image_original_name AS image_original_name_20, e0_.image_mime_type AS image_mime_type_21, e0_.image_size AS image_size_22, e0_.image_updated_at AS image_updated_at_23, e0_.card_image_name AS card_image_name_24, e0_.card_image_original_name AS card_image_original_name_25, e0_.card_image_mime_type AS card_image_mime_type_26, e0_.card_image_size AS card_image_size_27, e0_.card_image_updated_at AS card_image_updated_at_28, e1_.id AS id_29, e1_.website_url AS website_url_30, e1_.is_enabled AS is_enabled_31, e1_.is_show_in_partners AS is_show_in_partners_32, e1_.created_at AS created_at_33, e1_.image_name AS image_name_34, e1_.image_original_name AS image_original_name_35, e1_.image_mime_type AS image_mime_type_36, e1_.image_size AS image_size_37, e1_.image_updated_at AS image_updated_at_38, e2_.id AS id_39, e2_.title AS title_40, e2_.short_description AS short_description_41, l3_.id AS id_42, l3_.name AS name_43, e0_.poll_id AS poll_id_44, e0_.event_group_id AS event_group_id_45, e2_.lang_id AS lang_id_46, e2_.event_organization_id AS event_organization_id_47 FROM event e0_ LEFT JOIN event_partner e4_ ON e0_.id = e4_.event_id LEFT JOIN event_organization e1_ ON e1_.id = e4_.event_organization_id LEFT JOIN event_organization_translate e2_ ON e1_.id = e2_.event_organization_id LEFT JOIN language l3_ ON e2_.lang_id = l3_.id WHERE e0_.id = 3;

#	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	App\Repository\Event\EventRepository->loadOrganizationCollection (line 148)
7	App\Repository\Event\EventRepository->findOneForPage (line 118)
8	App\Controller\EventController->eventPage (line 93)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
11	Symfony\Component\HttpKernel\Kernel->handle (line 193)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
13	require_once (line 32)
14	require_once (line 5)

0.42 ms
(5.70%)

SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.type AS type_2 FROM specialty s0_

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  s0_.id AS id_0,
  s0_.name AS name_1,
  s0_.type AS type_2
FROM
  specialty s0_

SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.type AS type_2 FROM specialty s0_;

#	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	Symfony\Bridge\Doctrine\Form\ChoiceList\ORMQueryBuilderLoader->getEntities (line 36)
6	Symfony\Bridge\Doctrine\Form\ChoiceList\DoctrineChoiceLoader->loadChoices (line 53)
7	Symfony\Component\Form\ChoiceList\Loader\AbstractChoiceLoader->loadChoiceList (line 29)
8	Symfony\Component\Form\ChoiceList\LazyChoiceList->getChoices (line 56)
9	Symfony\Component\Form\ChoiceList\Factory\DefaultChoiceListFactory->createView (line 60)
10	Symfony\Component\Form\ChoiceList\Factory\PropertyAccessDecorator->createView (line 178)
11	Symfony\Component\Form\ChoiceList\Factory\CachingFactoryDecorator->createView (line 187)
12	Symfony\Component\Form\Extension\Core\Type\ChoiceType->createChoiceListView (line 478)
13	Symfony\Component\Form\Extension\Core\Type\ChoiceType->buildView (line 233)
14	Symfony\Component\Form\ResolvedFormType->buildView (line 111)
15	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildView (line 78)
16	Symfony\Component\Form\ResolvedFormType->buildView (line 109)
17	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildView (line 78)
18	Symfony\Component\Form\Form->createView (line 892)
19	Symfony\Component\Form\Form->createView (line 895)
20	App\Controller\AuthController->registerModalForm (line 188)
21	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
22	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
23	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler->handle (line 86)
24	Symfony\Component\HttpKernel\Fragment\InlineFragmentRenderer::render (line 75)
25	Symfony\Component\HttpKernel\Fragment\FragmentHandler->render (line 81)
26	Symfony\Component\HttpKernel\DependencyInjection\LazyLoadingFragmentHandler->render (line 46)
27	Symfony\Bridge\Twig\Extension\HttpKernelRuntime->renderFragment (line 41)
28	__TwigTemplate_8fe72738aa2f63b96607b3221990da5b->doDisplay (line 546)
29	Twig\Template->yield (line 402)
30	__TwigTemplate_0ea6f3e2fd3a0789310c5e501cd56e94->doDisplay (line 86)
31	Twig\Template->yield (line 402)
32	Twig\Template->display (line 358)
33	Twig\Template->render (line 373)
34	Twig\TemplateWrapper->render (line 51)
35	Twig\Environment->render (line 333)
36	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
37	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
38	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
39	App\Controller\EventController->eventPage (line 114)
40	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
41	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
42	Symfony\Component\HttpKernel\Kernel->handle (line 193)
43	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
44	require_once (line 32)
45	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\Specialty	143
App\Entity\Event\EventOrganization	8
App\Entity\SpeakerTranslate	6
App\Entity\Event\EventOrganizationTranslate	5
App\Entity\Speaker	3
App\Entity\Language	2
App\Entity\Event\Event	1
App\Entity\Event\EventTranslate	1
App\Entity\Event\EventTab	1
App\Entity\Certificate\CustomCertificate	1

Entities Mapping

Class	Mapping errors
App\Entity\ImageEmbeddableClass	No errors.
App\Entity\Event\Event	No errors.
App\Entity\Event\EventTranslate	No errors.
App\Entity\Language	No errors.
App\Entity\Event\EventGroup	No errors.
App\Entity\Event\EventGroupTranslate	No errors.
App\Entity\Poll\Poll	No errors.
App\Entity\User\UserEventRegister	No errors.
App\Entity\User\UserCertificate	No errors.
App\Entity\Test\Test	No errors.
App\Entity\Event\EventTab	No errors.
App\Entity\Speaker	No errors.
App\Entity\Specialty	No errors.
App\Entity\Event\EventOrganization	No errors.
App\Entity\Certificate\CustomCertificate	No errors.
App\Entity\PageTranslate	No errors.
App\Entity\Event\EventOrganizationTranslate	No errors.
App\Entity\SpeakerTranslate	No errors.
App\Entity\Banner	No errors.
App\Entity\Faq	No errors.
App\Entity\User\User	The association App\Entity\User\User#tests refers to the owning side field App\Entity\Test\Test#user which does not exist.
App\Entity\Certificate\CustomCertificateElement	No errors.
App\Entity\Poll\PollQuestion	No errors.
App\Entity\User\UserPoll	No errors.
App\Entity\Test\TestQuestion	No errors.
App\Entity\User\UserTest	No errors.
App\Entity\Page	No errors.
App\Entity\User\UserPollAnswer	No errors.
App\Entity\User\UserTestAnswer	No errors.
App\Entity\City	No errors.
App\Entity\User\UserOrganization	No errors.
App\Entity\Feedback	No errors.
App\Entity\Poll\PollOption	No errors.
App\Entity\Test\TestAnswer	The association App\Entity\Test\TestAnswer#test refers to the inverse side field App\Entity\Test\Test#testAnswers which does not exist.
App\Entity\Country	No errors.
App\Entity\Newsletter	No errors.
App\Entity\Event\ChatReportJob	No errors.
App\Entity\NewsletterRecipient	No errors.
Vich\UploaderBundle\Entity\File	No errors.

Symfony Profiler

GET https://event.endocrincentr.ru/events/antikoagulyantnyy-klub-cikl-vnutri-antikoagulyantnyh-resheniy

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping