Symfony Profiler

Query Metrics

2 Database Queries

2 Different statements

1.55 ms Query time

1 Invalid entities

152 Managed entities

Queries

Group similar statements

#▲

Time

Info

1.12 ms

SELECT e0_.id AS id_0, e0_.website_url AS website_url_1, e0_.is_enabled AS is_enabled_2, e0_.is_show_in_partners AS is_show_in_partners_3, e0_.created_at AS created_at_4, e0_.image_name AS image_name_5, e0_.image_original_name AS image_original_name_6, e0_.image_mime_type AS image_mime_type_7, e0_.image_size AS image_size_8, e0_.image_updated_at AS image_updated_at_9, e1_.id AS id_10, e1_.title AS title_11, e1_.short_description AS short_description_12, l2_.id AS id_13, l2_.name AS name_14, e1_.lang_id AS lang_id_15, e1_.event_organization_id AS event_organization_id_16 FROM event_organization e0_ LEFT JOIN event_organization_translate e1_ ON e0_.id = e1_.event_organization_id LEFT JOIN language l2_ ON e1_.lang_id = l2_.id WHERE e0_.is_enabled = ? AND e0_.is_show_in_partners = ? 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_.website_url AS website_url_1,
  e0_.is_enabled AS is_enabled_2,
  e0_.is_show_in_partners AS is_show_in_partners_3,
  e0_.created_at AS created_at_4,
  e0_.image_name AS image_name_5,
  e0_.image_original_name AS image_original_name_6,
  e0_.image_mime_type AS image_mime_type_7,
  e0_.image_size AS image_size_8,
  e0_.image_updated_at AS image_updated_at_9,
  e1_.id AS id_10,
  e1_.title AS title_11,
  e1_.short_description AS short_description_12,
  l2_.id AS id_13,
  l2_.name AS name_14,
  e1_.lang_id AS lang_id_15,
  e1_.event_organization_id AS event_organization_id_16
FROM
  event_organization e0_
  LEFT JOIN event_organization_translate e1_ ON e0_.id = e1_.event_organization_id
  LEFT JOIN language l2_ ON e1_.lang_id = l2_.id
WHERE
  e0_.is_enabled = ?
  AND e0_.is_show_in_partners = ?
ORDER BY
  e0_.created_at DESC,
  e0_.id DESC

SELECT e0_.id AS id_0, e0_.website_url AS website_url_1, e0_.is_enabled AS is_enabled_2, e0_.is_show_in_partners AS is_show_in_partners_3, e0_.created_at AS created_at_4, e0_.image_name AS image_name_5, e0_.image_original_name AS image_original_name_6, e0_.image_mime_type AS image_mime_type_7, e0_.image_size AS image_size_8, e0_.image_updated_at AS image_updated_at_9, e1_.id AS id_10, e1_.title AS title_11, e1_.short_description AS short_description_12, l2_.id AS id_13, l2_.name AS name_14, e1_.lang_id AS lang_id_15, e1_.event_organization_id AS event_organization_id_16 FROM event_organization e0_ LEFT JOIN event_organization_translate e1_ ON e0_.id = e1_.event_organization_id LEFT JOIN language l2_ ON e1_.lang_id = l2_.id WHERE e0_.is_enabled = 1 AND e0_.is_show_in_partners = 1 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\EventOrganizationRepository->findVisiblePartners (line 36)
7	App\Controller\MainController->partners (line 158)
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.42 ms

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_32d6052f724dd8119e137623e0538ed2->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\MainController->partners (line 157)
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	4
App\Entity\Event\EventOrganizationTranslate	4
App\Entity\Language	1

Entities Mapping

Class	Mapping errors
App\Entity\ImageEmbeddableClass	No errors.
App\Entity\Event\EventOrganization	No errors.
App\Entity\Event\EventOrganizationTranslate	No errors.
App\Entity\Language	No errors.
App\Entity\Event\Event	No errors.
App\Entity\PageTranslate	No errors.
App\Entity\Event\EventTranslate	No errors.
App\Entity\Event\EventGroupTranslate	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\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.

Symfony Profiler

GET https://event.endocrincentr.ru/_fragment?_path=_format%3Dhtml%26_locale%3Dru%26_controller%3DApp%255CController%255CAuthController%253A%253AregisterModalForm

Configuration Settings

Theme

Page Width