Symfony Profiler

Query Metrics

2 Database Queries

2 Different statements

133.71 ms Query time

2 Invalid entities

143 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

121.39 ms
(90.78%)

SELECT e0_.id AS id_0, e0_.slug AS slug_1, e0_.created_at AS created_at_2, e0_.is_activated AS is_activated_3, e1_.id AS id_4, e1_.title AS title_5, e1_.content AS content_6, l2_.id AS id_7, l2_.name AS name_8, e3_.id AS id_9, e3_.slug AS slug_10, e3_.program_name AS program_name_11, e3_.program_original_name AS program_original_name_12, e3_.program_mime_type AS program_mime_type_13, e3_.program_size AS program_size_14, e3_.program_updated_at AS program_updated_at_15, e3_.is_activated AS is_activated_16, e3_.is_enabled AS is_enabled_17, e3_.start_at AS start_at_18, e3_.end_at AS end_at_19, e3_.status AS status_20, e3_.created_at AS created_at_21, e3_.is_show_chat AS is_show_chat_22, e3_.is_registration AS is_registration_23, e3_.is_calendar AS is_calendar_24, e3_.is_nmo AS is_nmo_25, e3_.is_show_slider AS is_show_slider_26, e3_.image_name AS image_name_27, e3_.image_original_name AS image_original_name_28, e3_.image_mime_type AS image_mime_type_29, e3_.image_size AS image_size_30, e3_.image_updated_at AS image_updated_at_31, e3_.card_image_name AS card_image_name_32, e3_.card_image_original_name AS card_image_original_name_33, e3_.card_image_mime_type AS card_image_mime_type_34, e3_.card_image_size AS card_image_size_35, e3_.card_image_updated_at AS card_image_updated_at_36, e1_.lang_id AS lang_id_37, e1_.event_group_id AS event_group_id_38, e3_.poll_id AS poll_id_39, e3_.event_group_id AS event_group_id_40 FROM event_group e0_ LEFT JOIN event_group_translate e1_ ON e0_.id = e1_.event_group_id LEFT JOIN language l2_ ON e1_.lang_id = l2_.id LEFT JOIN event e3_ ON e0_.id = e3_.event_group_id AND (e3_.is_enabled = ? AND e3_.is_activated = ?) WHERE e0_.is_activated = ? AND e0_.slug IS NOT NULL AND e0_.slug <> ? ORDER BY e0_.created_at DESC, e0_.id DESC

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  e0_.id AS id_0,
  e0_.slug AS slug_1,
  e0_.created_at AS created_at_2,
  e0_.is_activated AS is_activated_3,
  e1_.id AS id_4,
  e1_.title AS title_5,
  e1_.content AS content_6,
  l2_.id AS id_7,
  l2_.name AS name_8,
  e3_.id AS id_9,
  e3_.slug AS slug_10,
  e3_.program_name AS program_name_11,
  e3_.program_original_name AS program_original_name_12,
  e3_.program_mime_type AS program_mime_type_13,
  e3_.program_size AS program_size_14,
  e3_.program_updated_at AS program_updated_at_15,
  e3_.is_activated AS is_activated_16,
  e3_.is_enabled AS is_enabled_17,
  e3_.start_at AS start_at_18,
  e3_.end_at AS end_at_19,
  e3_.status AS status_20,
  e3_.created_at AS created_at_21,
  e3_.is_show_chat AS is_show_chat_22,
  e3_.is_registration AS is_registration_23,
  e3_.is_calendar AS is_calendar_24,
  e3_.is_nmo AS is_nmo_25,
  e3_.is_show_slider AS is_show_slider_26,
  e3_.image_name AS image_name_27,
  e3_.image_original_name AS image_original_name_28,
  e3_.image_mime_type AS image_mime_type_29,
  e3_.image_size AS image_size_30,
  e3_.image_updated_at AS image_updated_at_31,
  e3_.card_image_name AS card_image_name_32,
  e3_.card_image_original_name AS card_image_original_name_33,
  e3_.card_image_mime_type AS card_image_mime_type_34,
  e3_.card_image_size AS card_image_size_35,
  e3_.card_image_updated_at AS card_image_updated_at_36,
  e1_.lang_id AS lang_id_37,
  e1_.event_group_id AS event_group_id_38,
  e3_.poll_id AS poll_id_39,
  e3_.event_group_id AS event_group_id_40
FROM
  event_group e0_
  LEFT JOIN event_group_translate e1_ ON e0_.id = e1_.event_group_id
  LEFT JOIN language l2_ ON e1_.lang_id = l2_.id
  LEFT JOIN event e3_ ON e0_.id = e3_.event_group_id
  AND (
    e3_.is_enabled = ?
    AND e3_.is_activated = ?
  )
WHERE
  e0_.is_activated = ?
  AND e0_.slug IS NOT NULL
  AND e0_.slug <> ?
ORDER BY
  e0_.created_at DESC,
  e0_.id DESC

SELECT e0_.id AS id_0, e0_.slug AS slug_1, e0_.created_at AS created_at_2, e0_.is_activated AS is_activated_3, e1_.id AS id_4, e1_.title AS title_5, e1_.content AS content_6, l2_.id AS id_7, l2_.name AS name_8, e3_.id AS id_9, e3_.slug AS slug_10, e3_.program_name AS program_name_11, e3_.program_original_name AS program_original_name_12, e3_.program_mime_type AS program_mime_type_13, e3_.program_size AS program_size_14, e3_.program_updated_at AS program_updated_at_15, e3_.is_activated AS is_activated_16, e3_.is_enabled AS is_enabled_17, e3_.start_at AS start_at_18, e3_.end_at AS end_at_19, e3_.status AS status_20, e3_.created_at AS created_at_21, e3_.is_show_chat AS is_show_chat_22, e3_.is_registration AS is_registration_23, e3_.is_calendar AS is_calendar_24, e3_.is_nmo AS is_nmo_25, e3_.is_show_slider AS is_show_slider_26, e3_.image_name AS image_name_27, e3_.image_original_name AS image_original_name_28, e3_.image_mime_type AS image_mime_type_29, e3_.image_size AS image_size_30, e3_.image_updated_at AS image_updated_at_31, e3_.card_image_name AS card_image_name_32, e3_.card_image_original_name AS card_image_original_name_33, e3_.card_image_mime_type AS card_image_mime_type_34, e3_.card_image_size AS card_image_size_35, e3_.card_image_updated_at AS card_image_updated_at_36, e1_.lang_id AS lang_id_37, e1_.event_group_id AS event_group_id_38, e3_.poll_id AS poll_id_39, e3_.event_group_id AS event_group_id_40 FROM event_group e0_ LEFT JOIN event_group_translate e1_ ON e0_.id = e1_.event_group_id LEFT JOIN language l2_ ON e1_.lang_id = l2_.id LEFT JOIN event e3_ ON e0_.id = e3_.event_group_id AND (e3_.is_enabled = 1 AND e3_.is_activated = 1) WHERE e0_.is_activated = 1 AND e0_.slug IS NOT NULL AND e0_.slug <> '' ORDER BY e0_.created_at DESC, e0_.id DESC;

#	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\EventGroupRepository->findActiveForIndex (line 38)
7	App\Controller\EventGroupController->index (line 30)
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)

12.33 ms
(9.22%)

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 174)
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 439)
29	Twig\Template->yield (line 402)
30	__TwigTemplate_ab62897d611cb098c1bd0bc9134d0255->doDisplay (line 54)
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\EventGroupController->index (line 33)
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

Entities Mapping

Class	Mapping errors
App\Entity\Event\EventGroup	No errors.
App\Entity\Event\EventGroupTranslate	No errors.
App\Entity\Language	No errors.
App\Entity\ImageEmbeddableClass	No errors.
App\Entity\Event\Event	No errors.
App\Entity\Poll\Poll	No errors.
App\Entity\Specialty	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\PageTranslate	No errors.
App\Entity\Event\EventTranslate	No errors.
App\Entity\Event\EventOrganizationTranslate	No errors.
App\Entity\Event\EventTab	No errors.
App\Entity\SpeakerTranslate	No errors.
App\Entity\Banner	No errors.
App\Entity\Faq	No errors.
App\Entity\User\UserEventRegister	No errors.
App\Entity\User\UserCertificate	No errors.
App\Entity\Test\Test	No errors.
App\Entity\Speaker	No errors.
App\Entity\Event\EventOrganization	No errors.
App\Entity\Certificate\CustomCertificate	No errors.
App\Entity\Poll\PollQuestion	No errors.
App\Entity\User\UserPoll	No errors.
App\Entity\User\UserPollAnswer	No errors.
App\Entity\User\UserTest	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\Page	No errors.
App\Entity\Test\TestQuestion	No errors.
App\Entity\Certificate\CustomCertificateElement	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\Event\ChatReportJob	No errors.
Vich\UploaderBundle\Entity\File	No errors.

Symfony Profiler

GET https://vconfe.ru/groups

Configuration Settings

Theme

Page Width