Symfony Profiler

Query Metrics

10 Database Queries

8 Different statements

42.04 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

34.03 ms
(80.94%)

SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.slug AS slug_2, p0_.description AS description_3, p0_.publish_at AS publish_at_4, p0_.type AS type_5, p0_.display AS display_6, p0_.created_at AS created_at_7, p0_.updated_at AS updated_at_8, p0_.image_id AS image_id_9, p0_.area_id AS area_id_10 FROM publication p0_ LEFT JOIN area a1_ ON p0_.area_id = a1_.id AND (a1_.region_id = '1') WHERE p0_.type = 'promotion' AND p0_.display = 1 AND (a1_.id IS NULL OR (a1_.paid = 1 AND a1_.display = 1)) ORDER BY RAND() ASC LIMIT 3

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.id AS id_0,
  p0_.title AS title_1,
  p0_.slug AS slug_2,
  p0_.description AS description_3,
  p0_.publish_at AS publish_at_4,
  p0_.type AS type_5,
  p0_.display AS display_6,
  p0_.created_at AS created_at_7,
  p0_.updated_at AS updated_at_8,
  p0_.image_id AS image_id_9,
  p0_.area_id AS area_id_10
FROM
  publication p0_
  LEFT JOIN area a1_ ON p0_.area_id = a1_.id
  AND (a1_.region_id = '1')
WHERE
  p0_.type = 'promotion'
  AND p0_.display = 1
  AND (
    a1_.id IS NULL
    OR (
      a1_.paid = 1
      AND a1_.display = 1
    )
  )
ORDER BY
  RAND() ASC
LIMIT
  3

SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.slug AS slug_2, p0_.description AS description_3, p0_.publish_at AS publish_at_4, p0_.type AS type_5, p0_.display AS display_6, p0_.created_at AS created_at_7, p0_.updated_at AS updated_at_8, p0_.image_id AS image_id_9, p0_.area_id AS area_id_10 FROM publication p0_ LEFT JOIN area a1_ ON p0_.area_id = a1_.id AND (a1_.region_id = '1') WHERE p0_.type = 'promotion' AND p0_.display = 1 AND (a1_.id IS NULL OR (a1_.paid = 1 AND a1_.display = 1)) ORDER BY RAND() ASC LIMIT 3;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 33)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 327)
3	Doctrine\ORM\Query->_doExecute (line 1212)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1166)
5	Doctrine\ORM\AbstractQuery->execute (line 901)
6	Doctrine\ORM\AbstractQuery->getResult (line 111)
7	App\Repository\PublicationRepository->getOther (line 43)
8	App\Controller\PublicationController->view (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require_once (line 5)

6.86 ms
(16.32%)

SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.description AS description_4, t0.publish_at AS publish_at_5, t0.type AS type_6, t0.display AS display_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.image_id AS image_id_10, t0.area_id AS area_id_11 FROM publication t0 WHERE t0.slug = ? AND t0.type = ? AND t0.display = ? LIMIT 1

Parameters:

[
  "ne-umeete-tantsevat-nauchim"
  "promotion"
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.slug AS slug_3,
  t0.description AS description_4,
  t0.publish_at AS publish_at_5,
  t0.type AS type_6,
  t0.display AS display_7,
  t0.created_at AS created_at_8,
  t0.updated_at AS updated_at_9,
  t0.image_id AS image_id_10,
  t0.area_id AS area_id_11
FROM
  publication t0
WHERE
  t0.slug = ?
  AND t0.type = ?
  AND t0.display = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.description AS description_4, t0.publish_at AS publish_at_5, t0.type AS type_6, t0.display AS display_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.image_id AS image_id_10, t0.area_id AS area_id_11 FROM publication t0 WHERE t0.slug = 'ne-umeete-tantsevat-nauchim' AND t0.type = 'promotion' AND t0.display = 1 LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 776)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 241)
3	Doctrine\ORM\EntityRepository->findOneBy (line 69)
4	Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->resolve (line 37)
5	Symfony\Component\HttpKernel\Controller\ArgumentResolver\TraceableValueResolver->resolve (line 90)
6	Symfony\Component\HttpKernel\Controller\ArgumentResolver->getArguments (line 33)
7	Symfony\Component\HttpKernel\Controller\TraceableArgumentResolver->getArguments (line 175)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
10	Symfony\Component\HttpKernel\Kernel->handle (line 35)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
12	require_once (line 5)

0.27 ms
(0.65%)

SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.genitive_title AS genitive_title_4, t0.dative_title AS dative_title_5, t0.accusative_title AS accusative_title_6, t0.instrumental_title AS instrumental_title_7, t0.prepositional_title AS prepositional_title_8, t0.default AS default_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11 FROM region t0 WHERE t0.slug = ? LIMIT 1

Parameters:

[
  "msk"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.slug AS slug_3,
  t0.genitive_title AS genitive_title_4,
  t0.dative_title AS dative_title_5,
  t0.accusative_title AS accusative_title_6,
  t0.instrumental_title AS instrumental_title_7,
  t0.prepositional_title AS prepositional_title_8,
  t0.default AS default_9,
  t0.created_at AS created_at_10,
  t0.updated_at AS updated_at_11
FROM
  region t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.genitive_title AS genitive_title_4, t0.dative_title AS dative_title_5, t0.accusative_title AS accusative_title_6, t0.instrumental_title AS instrumental_title_7, t0.prepositional_title AS prepositional_title_8, t0.default AS default_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11 FROM region t0 WHERE t0.slug = 'msk' LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 776)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 241)
3	Doctrine\ORM\EntityRepository->findOneBy (line 27)
4	App\Service\RegionService->findRegion (line 27)
5	App\EventSubscriber\RegionEventSubscriber->onKernelRequest (line 115)
6	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
7	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
8	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
9	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 159)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
12	Symfony\Component\HttpKernel\Kernel->handle (line 35)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
14	require_once (line 5)

0.27 ms
(0.64%)

SELECT a0_.id AS id_0, a0_.title AS title_1, a0_.link AS link_2, a0_.display AS display_3, a0_.created_at AS created_at_4, a0_.updated_at AS updated_at_5, f1_.id AS id_6, f1_.hash AS hash_7, f1_.path AS path_8, f1_.link AS link_9, f1_.name AS name_10, f1_.file_name AS file_name_11, f1_.mime_type AS mime_type_12, f1_.size AS size_13, f1_.created_at AS created_at_14, f1_.updated_at AS updated_at_15, a0_.image_id AS image_id_16 FROM advertising_homepage_tag a0_ LEFT JOIN file f1_ ON a0_.image_id = f1_.id WHERE a0_.display = 1 ORDER BY RAND() ASC LIMIT 14

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  a0_.id AS id_0,
  a0_.title AS title_1,
  a0_.link AS link_2,
  a0_.display AS display_3,
  a0_.created_at AS created_at_4,
  a0_.updated_at AS updated_at_5,
  f1_.id AS id_6,
  f1_.hash AS hash_7,
  f1_.path AS path_8,
  f1_.link AS link_9,
  f1_.name AS name_10,
  f1_.file_name AS file_name_11,
  f1_.mime_type AS mime_type_12,
  f1_.size AS size_13,
  f1_.created_at AS created_at_14,
  f1_.updated_at AS updated_at_15,
  a0_.image_id AS image_id_16
FROM
  advertising_homepage_tag a0_
  LEFT JOIN file f1_ ON a0_.image_id = f1_.id
WHERE
  a0_.display = 1
ORDER BY
  RAND() ASC
LIMIT
  14

SELECT a0_.id AS id_0, a0_.title AS title_1, a0_.link AS link_2, a0_.display AS display_3, a0_.created_at AS created_at_4, a0_.updated_at AS updated_at_5, f1_.id AS id_6, f1_.hash AS hash_7, f1_.path AS path_8, f1_.link AS link_9, f1_.name AS name_10, f1_.file_name AS file_name_11, f1_.mime_type AS mime_type_12, f1_.size AS size_13, f1_.created_at AS created_at_14, f1_.updated_at AS updated_at_15, a0_.image_id AS image_id_16 FROM advertising_homepage_tag a0_ LEFT JOIN file f1_ ON a0_.image_id = f1_.id WHERE a0_.display = 1 ORDER BY RAND() ASC LIMIT 14;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 33)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 327)
3	Doctrine\ORM\Query->_doExecute (line 1212)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1166)
5	Doctrine\ORM\AbstractQuery->execute (line 901)
6	Doctrine\ORM\AbstractQuery->getResult (line 43)
7	App\Repository\Advertising\AdvertisingHomepageTagRepository->getByRand (line 62)
8	App\Controller\WidgetController->homepageTag (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 86)
11	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 75)
12	Symfony\Component\HttpKernel\Fragment\InlineFragmentRenderer->render (line 81)
13	Symfony\Component\HttpKernel\Fragment\FragmentHandler->render (line 46)
14	Symfony\Component\HttpKernel\DependencyInjection\LazyLoadingFragmentHandler->render (line 41)
15	Symfony\Bridge\Twig\Extension\HttpKernelRuntime->renderFragment (line 228)
16	__TwigTemplate_b0521e6e7b7723ac6606e851f6f96e00->doDisplay (line 360)
17	Twig\Template->yield (line 335)
18	Twig\Template->render (line 38)
19	Twig\TemplateWrapper->render (line 1422)
20	Twig\Extension\CoreExtension::include (line 70)
21	__TwigTemplate_4b43215af48216346ec4272c6710f40f->doDisplay (line 360)
22	Twig\Template->yield (line 49)
23	__TwigTemplate_23105ee0561844610606fc194664a13e->doDisplay (line 360)
24	Twig\Template->yield (line 335)
25	Twig\Template->render (line 38)
26	Twig\TemplateWrapper->render (line 306)
27	Twig\Environment->render (line 431)
28	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
29	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
30	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 41)
31	App\Controller\PublicationController->view (line 183)
32	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
33	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
34	Symfony\Component\HttpKernel\Kernel->handle (line 35)
35	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
36	require_once (line 5)

0.26 ms
(0.61%)

SELECT t0.id AS id_1, t0.link AS link_2, t0.title AS title_3, t0.h1 AS h1_4, t0.keywords AS keywords_5, t0.description AS description_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8 FROM seo_static_meta t0 WHERE t0.link = ? LIMIT 1

Parameters:

[
  "/msk/publication/promotion/ne-umeete-tantsevat-nauchim"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.link AS link_2,
  t0.title AS title_3,
  t0.h1 AS h1_4,
  t0.keywords AS keywords_5,
  t0.description AS description_6,
  t0.created_at AS created_at_7,
  t0.updated_at AS updated_at_8
FROM
  seo_static_meta t0
WHERE
  t0.link = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.link AS link_2, t0.title AS title_3, t0.h1 AS h1_4, t0.keywords AS keywords_5, t0.description AS description_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8 FROM seo_static_meta t0 WHERE t0.link = '/msk/publication/promotion/ne-umeete-tantsevat-nauchim' LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 776)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 241)
3	Doctrine\ORM\EntityRepository->findOneBy (line 41)
4	App\Service\Seo\SeoService->getPageMeta (line 31)
5	App\Service\Seo\SeoService->getSeoData (line 46)
6	App\Twig\AppExtension->getSeoData (line 144)
7	__TwigTemplate_4b43215af48216346ec4272c6710f40f->block_title (line 430)
8	Twig\Template->yieldBlock (line 106)
9	__TwigTemplate_4b43215af48216346ec4272c6710f40f->block_seo (line 430)
10	Twig\Template->yieldBlock (line 61)
11	__TwigTemplate_4b43215af48216346ec4272c6710f40f->doDisplay (line 360)
12	Twig\Template->yield (line 49)
13	__TwigTemplate_23105ee0561844610606fc194664a13e->doDisplay (line 360)
14	Twig\Template->yield (line 335)
15	Twig\Template->render (line 38)
16	Twig\TemplateWrapper->render (line 306)
17	Twig\Environment->render (line 431)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 41)
21	App\Controller\PublicationController->view (line 183)
22	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
23	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
24	Symfony\Component\HttpKernel\Kernel->handle (line 35)
25	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
26	require_once (line 5)

0.15 ms
(0.35%)

SELECT a0_.id AS id_0, a0_.code AS code_1, a0_.name AS name_2, a0_.description AS description_3, a0_.created_at AS created_at_4, a0_.updated_at AS updated_at_5, a0_.event_id AS event_id_6 FROM area_event_selection a0_

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  a0_.id AS id_0,
  a0_.code AS code_1,
  a0_.name AS name_2,
  a0_.description AS description_3,
  a0_.created_at AS created_at_4,
  a0_.updated_at AS updated_at_5,
  a0_.event_id AS event_id_6
FROM
  area_event_selection a0_

SELECT a0_.id AS id_0, a0_.code AS code_1, a0_.name AS name_2, a0_.description AS description_3, a0_.created_at AS created_at_4, a0_.updated_at AS updated_at_5, a0_.event_id AS event_id_6 FROM area_event_selection a0_;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 33)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 327)
3	Doctrine\ORM\Query->_doExecute (line 1212)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1166)
5	Doctrine\ORM\AbstractQuery->execute (line 35)
6	Symfony\Bridge\Doctrine\Form\ChoiceList\ORMQueryBuilderLoader->getEntities (line 53)
7	Symfony\Bridge\Doctrine\Form\ChoiceList\DoctrineChoiceLoader->loadChoices (line 29)
8	Symfony\Component\Form\ChoiceList\Loader\AbstractChoiceLoader->loadChoiceList (line 56)
9	Symfony\Component\Form\ChoiceList\LazyChoiceList->getChoices (line 60)
10	Symfony\Component\Form\ChoiceList\Factory\DefaultChoiceListFactory->createView (line 178)
11	Symfony\Component\Form\ChoiceList\Factory\PropertyAccessDecorator->createView (line 189)
12	Symfony\Component\Form\ChoiceList\Factory\CachingFactoryDecorator->createView (line 458)
13	Symfony\Component\Form\Extension\Core\Type\ChoiceType->createChoiceListView (line 232)
14	Symfony\Component\Form\Extension\Core\Type\ChoiceType->buildView (line 107)
15	Symfony\Component\Form\ResolvedFormType->buildView (line 78)
16	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildView (line 105)
17	Symfony\Component\Form\ResolvedFormType->buildView (line 78)
18	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildView (line 888)
19	Symfony\Component\Form\Form->createView (line 891)
20	Symfony\Component\Form\Form->createView (line 423)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 27)
24	App\Controller\WidgetController->search (line 183)
25	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
26	Symfony\Component\HttpKernel\HttpKernel->handle (line 86)
27	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 75)
28	Symfony\Component\HttpKernel\Fragment\InlineFragmentRenderer->render (line 81)
29	Symfony\Component\HttpKernel\Fragment\FragmentHandler->render (line 46)
30	Symfony\Component\HttpKernel\DependencyInjection\LazyLoadingFragmentHandler->render (line 41)
31	Symfony\Bridge\Twig\Extension\HttpKernelRuntime->renderFragment (line 75)
32	__TwigTemplate_23105ee0561844610606fc194664a13e->block_content (line 430)
33	Twig\Template->yieldBlock (line 74)
34	__TwigTemplate_4b43215af48216346ec4272c6710f40f->doDisplay (line 360)
35	Twig\Template->yield (line 49)
36	__TwigTemplate_23105ee0561844610606fc194664a13e->doDisplay (line 360)
37	Twig\Template->yield (line 335)
38	Twig\Template->render (line 38)
39	Twig\TemplateWrapper->render (line 306)
40	Twig\Environment->render (line 431)
41	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
42	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
43	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 41)
44	App\Controller\PublicationController->view (line 183)
45	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
46	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
47	Symfony\Component\HttpKernel\Kernel->handle (line 35)
48	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
49	require_once (line 5)

0.12 ms
(0.28%)

SELECT t0.id AS id_1, t0.title AS title_2, t0.active AS active_3, t0.archive AS archive_4, t0.about AS about_5, t0.destinations AS destinations_6, t0.start AS start_7, t0.end AS end_8, t0.application_end AS application_end_9, t0.voting_start AS voting_start_10, t0.voting_end AS voting_end_11, t0.create_short_list_start AS create_short_list_start_12, t0.create_short_list_end AS create_short_list_end_13, t0.adjudicator_voting_start AS adjudicator_voting_start_14, t0.adjudicator_voting_end AS adjudicator_voting_end_15, t0.rewarding AS rewarding_16, t0.phone AS phone_17, t0.email AS email_18, t0.whats_app AS whats_app_19, t0.website AS website_20, t0.position AS position_21, t0.created_at AS created_at_22, t0.updated_at AS updated_at_23, t0.about_image_id AS about_image_id_24, t0.destinations_image_id AS destinations_image_id_25, t0.stages_image_id AS stages_image_id_26, t0.banner_image_id AS banner_image_id_27, t0.presentation_id AS presentation_id_28, t0.regulations_id AS regulations_id_29 FROM award t0 WHERE t0.active = ? LIMIT 1

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.active AS active_3,
  t0.archive AS archive_4,
  t0.about AS about_5,
  t0.destinations AS destinations_6,
  t0.start AS start_7,
  t0.end AS end_8,
  t0.application_end AS application_end_9,
  t0.voting_start AS voting_start_10,
  t0.voting_end AS voting_end_11,
  t0.create_short_list_start AS create_short_list_start_12,
  t0.create_short_list_end AS create_short_list_end_13,
  t0.adjudicator_voting_start AS adjudicator_voting_start_14,
  t0.adjudicator_voting_end AS adjudicator_voting_end_15,
  t0.rewarding AS rewarding_16,
  t0.phone AS phone_17,
  t0.email AS email_18,
  t0.whats_app AS whats_app_19,
  t0.website AS website_20,
  t0.position AS position_21,
  t0.created_at AS created_at_22,
  t0.updated_at AS updated_at_23,
  t0.about_image_id AS about_image_id_24,
  t0.destinations_image_id AS destinations_image_id_25,
  t0.stages_image_id AS stages_image_id_26,
  t0.banner_image_id AS banner_image_id_27,
  t0.presentation_id AS presentation_id_28,
  t0.regulations_id AS regulations_id_29
FROM
  award t0
WHERE
  t0.active = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.title AS title_2, t0.active AS active_3, t0.archive AS archive_4, t0.about AS about_5, t0.destinations AS destinations_6, t0.start AS start_7, t0.end AS end_8, t0.application_end AS application_end_9, t0.voting_start AS voting_start_10, t0.voting_end AS voting_end_11, t0.create_short_list_start AS create_short_list_start_12, t0.create_short_list_end AS create_short_list_end_13, t0.adjudicator_voting_start AS adjudicator_voting_start_14, t0.adjudicator_voting_end AS adjudicator_voting_end_15, t0.rewarding AS rewarding_16, t0.phone AS phone_17, t0.email AS email_18, t0.whats_app AS whats_app_19, t0.website AS website_20, t0.position AS position_21, t0.created_at AS created_at_22, t0.updated_at AS updated_at_23, t0.about_image_id AS about_image_id_24, t0.destinations_image_id AS destinations_image_id_25, t0.stages_image_id AS stages_image_id_26, t0.banner_image_id AS banner_image_id_27, t0.presentation_id AS presentation_id_28, t0.regulations_id AS regulations_id_29 FROM award t0 WHERE t0.active = 1 LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 776)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 241)
3	Doctrine\ORM\EntityRepository->findOneBy (line 35)
4	App\Service\AwardService->getAward (line 31)
5	App\Twig\AwardExtension->getActive (line 86)
6	__TwigTemplate_b0521e6e7b7723ac6606e851f6f96e00->doDisplay (line 360)
7	Twig\Template->yield (line 335)
8	Twig\Template->render (line 38)
9	Twig\TemplateWrapper->render (line 1422)
10	Twig\Extension\CoreExtension::include (line 70)
11	__TwigTemplate_4b43215af48216346ec4272c6710f40f->doDisplay (line 360)
12	Twig\Template->yield (line 49)
13	__TwigTemplate_23105ee0561844610606fc194664a13e->doDisplay (line 360)
14	Twig\Template->yield (line 335)
15	Twig\Template->render (line 38)
16	Twig\TemplateWrapper->render (line 306)
17	Twig\Environment->render (line 431)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 41)
21	App\Controller\PublicationController->view (line 183)
22	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
23	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
24	Symfony\Component\HttpKernel\Kernel->handle (line 35)
25	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
26	require_once (line 5)

0.10 ms
(0.23%)

SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.genitive_title AS genitive_title_4, t0.dative_title AS dative_title_5, t0.accusative_title AS accusative_title_6, t0.instrumental_title AS instrumental_title_7, t0.prepositional_title AS prepositional_title_8, t0.default AS default_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11 FROM region t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.slug AS slug_3,
  t0.genitive_title AS genitive_title_4,
  t0.dative_title AS dative_title_5,
  t0.accusative_title AS accusative_title_6,
  t0.instrumental_title AS instrumental_title_7,
  t0.prepositional_title AS prepositional_title_8,
  t0.default AS default_9,
  t0.created_at AS created_at_10,
  t0.updated_at AS updated_at_11
FROM
  region t0

SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.genitive_title AS genitive_title_4, t0.dative_title AS dative_title_5, t0.accusative_title AS accusative_title_6, t0.instrumental_title AS instrumental_title_7, t0.prepositional_title AS prepositional_title_8, t0.default AS default_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11 FROM region t0;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 944)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 225)
3	Doctrine\ORM\EntityRepository->findBy (line 207)
4	Doctrine\ORM\EntityRepository->findAll (line 46)
5	App\Service\RegionService->getRegions (line 84)
6	App\Twig\AppExtension->getRegions (line 146)
7	__TwigTemplate_b0521e6e7b7723ac6606e851f6f96e00->doDisplay (line 360)
8	Twig\Template->yield (line 335)
9	Twig\Template->render (line 38)
10	Twig\TemplateWrapper->render (line 1422)
11	Twig\Extension\CoreExtension::include (line 70)
12	__TwigTemplate_4b43215af48216346ec4272c6710f40f->doDisplay (line 360)
13	Twig\Template->yield (line 49)
14	__TwigTemplate_23105ee0561844610606fc194664a13e->doDisplay (line 360)
15	Twig\Template->yield (line 335)
16	Twig\Template->render (line 38)
17	Twig\TemplateWrapper->render (line 306)
18	Twig\Environment->render (line 431)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 41)
22	App\Controller\PublicationController->view (line 183)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
25	Symfony\Component\HttpKernel\Kernel->handle (line 35)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
27	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.

Entities Mapping

Class	Mapping errors
App\Entity\Region	No errors.
App\Entity\Area\Area	No errors.
App\Entity\Filter\Filter	No errors.
App\Entity\Filter\FilterCity	No errors.
App\Entity\Advertising\AdvertisingTop	No errors.
App\Entity\Publication	No errors.
App\Entity\File	No errors.
App\Entity\SeoStaticMeta	No errors.
App\Entity\Award\Award	No errors.
App\Entity\Award\AwardAdjudicator	No errors.
App\Entity\Award\AwardAdjudicatorType	No errors.
App\Entity\Award\AwardAdjudicatorVote	No errors.
App\Entity\Award\AwardApplication	No errors.
App\Entity\Award\AwardContact	No errors.
App\Entity\Award\AwardCriterion	No errors.
App\Entity\Award\AwardNomination	No errors.
App\Entity\Award\AwardParticipant	No errors.
App\Entity\Award\AwardPartner	No errors.
App\Entity\Award\AwardPartnerType	No errors.
App\Entity\Award\AwardQuote	No errors.
App\Entity\Award\AwardVote	No errors.
App\Entity\Advertising\AdvertisingHomepageTag	No errors.
App\Entity\Account	No errors.
App\Entity\Advertising\AdvertisingBanner	No errors.
App\Entity\Advertising\AdvertisingSelectionItem	No errors.
App\Entity\Advertising\AdvertisingSlider	No errors.
App\Entity\Area\AreaHall	No errors.
App\Entity\IntegrationCRM	No errors.
App\Entity\Area\AreaCrmEvent	No errors.
App\Entity\Area\AreaEvent	No errors.
App\Entity\Area\AreaEventSelectionArea	No errors.
App\Entity\Area\AreaManagerRequest	No errors.
App\Entity\Area\AreaPhone	No errors.
App\Entity\Area\AreaReview	No errors.
App\Entity\Filter\FilterCapability	No errors.
App\Entity\Filter\FilterDistrict	No errors.
App\Entity\Filter\FilterMetro	No errors.
App\Entity\Filter\FilterSelection	No errors.
App\Entity\Filter\FilterType	No errors.
App\Entity\Advertising\AdvertisingSelection	No errors.
App\Entity\Area\AreaEventSelection	No errors.

Symfony Profiler

GET https://stg.4banket.ru/msk/widget/search

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping