Symfony Profiler

Query Metrics

18 Database Queries

7 Different statements

197.83 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

195.08 ms
(98.61%)

SELECT t0.id AS id_1, t0.rate AS rate_2, t0.adjudicator_rate AS adjudicator_rate_3, t0.short_list AS short_list_4, t0.technical_task AS technical_task_5, t0.information AS information_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.award_id AS award_id_9, t0.area_id AS area_id_10, t0.nomination_id AS nomination_id_11 FROM award_participant t0 WHERE t0.nomination_id = ?

Parameters:

[
  11
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.rate AS rate_2,
  t0.adjudicator_rate AS adjudicator_rate_3,
  t0.short_list AS short_list_4,
  t0.technical_task AS technical_task_5,
  t0.information AS information_6,
  t0.created_at AS created_at_7,
  t0.updated_at AS updated_at_8,
  t0.award_id AS award_id_9,
  t0.area_id AS area_id_10,
  t0.nomination_id AS nomination_id_11
FROM
  award_participant t0
WHERE
  t0.nomination_id = ?

SELECT t0.id AS id_1, t0.rate AS rate_2, t0.adjudicator_rate AS adjudicator_rate_3, t0.short_list AS short_list_4, t0.technical_task AS technical_task_5, t0.information AS information_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.award_id AS award_id_9, t0.area_id AS area_id_10, t0.nomination_id AS nomination_id_11 FROM award_participant t0 WHERE t0.nomination_id = 11;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1891)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1832)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 3301)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 706)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 218)
6	Doctrine\ORM\PersistentCollection->initialize (line 313)
7	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 90)
8	__TwigTemplate_1433692a43f8119d7ce649df952f90ac->block_content (line 430)
9	Twig\Template->yieldBlock (line 87)
10	__TwigTemplate_83d2f0289c5a91655c3e4e4c16b9fe48->doDisplay (line 360)
11	Twig\Template->yield (line 49)
12	__TwigTemplate_1433692a43f8119d7ce649df952f90ac->doDisplay (line 360)
13	Twig\Template->yield (line 335)
14	Twig\Template->render (line 38)
15	Twig\TemplateWrapper->render (line 306)
16	Twig\Environment->render (line 431)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 62)
20	App\Controller\AwardController->nomination (line 183)
21	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
22	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
23	Symfony\Component\HttpKernel\Kernel->handle (line 35)
24	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
25	require_once (line 5)

1.14 ms
(0.58%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.email AS email_4, t0.site AS site_5, t0.you_tube_movie AS you_tube_movie_6, t0.description AS description_7, t0.manager_info AS manager_info_8, t0.contact_info AS contact_info_9, t0.closing_condition AS closing_condition_10, t0.closing_condition_comment AS closing_condition_comment_11, t0.address AS address_12, t0.latitude AS latitude_13, t0.longitude AS longitude_14, t0.expired_at AS expired_at_15, t0.placement_period AS placement_period_16, t0.placement_date AS placement_date_17, t0.min_price AS min_price_18, t0.min_capacity AS min_capacity_19, t0.max_capacity AS max_capacity_20, t0.view AS view_21, t0.phone_view AS phone_view_22, t0.site_view AS site_view_23, t0.address_view AS address_view_24, t0.booking_count AS booking_count_25, t0.award_participating AS award_participating_26, t0.paid AS paid_27, t0.display AS display_28, t0.created_at AS created_at_29, t0.updated_at AS updated_at_30, t0.image_id AS image_id_31, t0.appearance_image_id AS appearance_image_id_32, t0.interior_image_id AS interior_image_id_33, t0.menu_id AS menu_id_34, t0.presentation_id AS presentation_id_35, t0.manager_id AS manager_id_36, t0.region_id AS region_id_37, t0.city_id AS city_id_38, t0.district_id AS district_id_39 FROM area t0 WHERE t0.id = ? AND ((t0.region_id = '1'))

Parameters:

[
  401
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.email AS email_4,
  t0.site AS site_5,
  t0.you_tube_movie AS you_tube_movie_6,
  t0.description AS description_7,
  t0.manager_info AS manager_info_8,
  t0.contact_info AS contact_info_9,
  t0.closing_condition AS closing_condition_10,
  t0.closing_condition_comment AS closing_condition_comment_11,
  t0.address AS address_12,
  t0.latitude AS latitude_13,
  t0.longitude AS longitude_14,
  t0.expired_at AS expired_at_15,
  t0.placement_period AS placement_period_16,
  t0.placement_date AS placement_date_17,
  t0.min_price AS min_price_18,
  t0.min_capacity AS min_capacity_19,
  t0.max_capacity AS max_capacity_20,
  t0.view AS view_21,
  t0.phone_view AS phone_view_22,
  t0.site_view AS site_view_23,
  t0.address_view AS address_view_24,
  t0.booking_count AS booking_count_25,
  t0.award_participating AS award_participating_26,
  t0.paid AS paid_27,
  t0.display AS display_28,
  t0.created_at AS created_at_29,
  t0.updated_at AS updated_at_30,
  t0.image_id AS image_id_31,
  t0.appearance_image_id AS appearance_image_id_32,
  t0.interior_image_id AS interior_image_id_33,
  t0.menu_id AS menu_id_34,
  t0.presentation_id AS presentation_id_35,
  t0.manager_id AS manager_id_36,
  t0.region_id AS region_id_37,
  t0.city_id AS city_id_38,
  t0.district_id AS district_id_39
FROM
  area t0
WHERE
  t0.id = ?
  AND (
    (t0.region_id = '1')
  )

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.email AS email_4, t0.site AS site_5, t0.you_tube_movie AS you_tube_movie_6, t0.description AS description_7, t0.manager_info AS manager_info_8, t0.contact_info AS contact_info_9, t0.closing_condition AS closing_condition_10, t0.closing_condition_comment AS closing_condition_comment_11, t0.address AS address_12, t0.latitude AS latitude_13, t0.longitude AS longitude_14, t0.expired_at AS expired_at_15, t0.placement_period AS placement_period_16, t0.placement_date AS placement_date_17, t0.min_price AS min_price_18, t0.min_capacity AS min_capacity_19, t0.max_capacity AS max_capacity_20, t0.view AS view_21, t0.phone_view AS phone_view_22, t0.site_view AS site_view_23, t0.address_view AS address_view_24, t0.booking_count AS booking_count_25, t0.award_participating AS award_participating_26, t0.paid AS paid_27, t0.display AS display_28, t0.created_at AS created_at_29, t0.updated_at AS updated_at_30, t0.image_id AS image_id_31, t0.appearance_image_id AS appearance_image_id_32, t0.interior_image_id AS interior_image_id_33, t0.menu_id AS menu_id_34, t0.presentation_id AS presentation_id_35, t0.manager_id AS manager_id_36, t0.region_id AS region_id_37, t0.city_id AS city_id_38, t0.district_id AS district_id_39 FROM area t0 WHERE t0.id = 401 AND ((t0.region_id = '1'));

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 776)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 794)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 364)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 471)
5	Proxies\__CG__\App\Entity\Area\Area::Doctrine\ORM\Proxy\{closure} (line 59)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 129)
7	Proxies\__CG__\App\Entity\Area\Area->__get (line 256)
8	App\Entity\Area\Area->getSlug (line 1719)
9	Twig\Extension\CoreExtension::getAttribute (line 96)
10	__TwigTemplate_1433692a43f8119d7ce649df952f90ac->block_content (line 430)
11	Twig\Template->yieldBlock (line 87)
12	__TwigTemplate_83d2f0289c5a91655c3e4e4c16b9fe48->doDisplay (line 360)
13	Twig\Template->yield (line 49)
14	__TwigTemplate_1433692a43f8119d7ce649df952f90ac->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 62)
22	App\Controller\AwardController->nomination (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)

0.94 ms
(0.48%)

SELECT t0.id AS id_1, t0.hash AS hash_2, t0.path AS path_3, t0.link AS link_4, t0.name AS name_5, t0.file_name AS file_name_6, t0.mime_type AS mime_type_7, t0.size AS size_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10 FROM file t0 WHERE t0.id = ?

Parameters:

[
  3116
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.hash AS hash_2,
  t0.path AS path_3,
  t0.link AS link_4,
  t0.name AS name_5,
  t0.file_name AS file_name_6,
  t0.mime_type AS mime_type_7,
  t0.size AS size_8,
  t0.created_at AS created_at_9,
  t0.updated_at AS updated_at_10
FROM
  file t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.hash AS hash_2, t0.path AS path_3, t0.link AS link_4, t0.name AS name_5, t0.file_name AS file_name_6, t0.mime_type AS mime_type_7, t0.size AS size_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10 FROM file t0 WHERE t0.id = 3116;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 776)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 794)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 364)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 471)
5	Proxies\__CG__\App\Entity\File::Doctrine\ORM\Proxy\{closure} (line 59)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 129)
7	Proxies\__CG__\App\Entity\File->__get (line 219)
8	App\Entity\File->getLink (line 1719)
9	Twig\Extension\CoreExtension::getAttribute (line 101)
10	__TwigTemplate_1433692a43f8119d7ce649df952f90ac->block_content (line 430)
11	Twig\Template->yieldBlock (line 87)
12	__TwigTemplate_83d2f0289c5a91655c3e4e4c16b9fe48->doDisplay (line 360)
13	Twig\Template->yield (line 49)
14	__TwigTemplate_1433692a43f8119d7ce649df952f90ac->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 62)
22	App\Controller\AwardController->nomination (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)

0.24 ms
(0.12%)

SELECT t0.id AS id_1, t0.title AS title_2, t0.position AS position_3, t0.display AS display_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.image_id AS image_id_7, t0.award_id AS award_id_8 FROM award_nomination t0 WHERE t0.id = ?

Parameters:

[
  "11"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.position AS position_3,
  t0.display AS display_4,
  t0.created_at AS created_at_5,
  t0.updated_at AS updated_at_6,
  t0.image_id AS image_id_7,
  t0.award_id AS award_id_8
FROM
  award_nomination t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.position AS position_3, t0.display AS display_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.image_id AS image_id_7, t0.award_id AS award_id_8 FROM award_nomination t0 WHERE t0.id = '11';

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

0.19 ms
(0.09%)

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/award/nomination/11"
]

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/award/nomination/11' 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 114)
7	__TwigTemplate_83d2f0289c5a91655c3e4e4c16b9fe48->block_title (line 430)
8	Twig\Template->yieldBlock (line 58)
9	__TwigTemplate_83d2f0289c5a91655c3e4e4c16b9fe48->doDisplay (line 360)
10	Twig\Template->yield (line 49)
11	__TwigTemplate_1433692a43f8119d7ce649df952f90ac->doDisplay (line 360)
12	Twig\Template->yield (line 335)
13	Twig\Template->render (line 38)
14	Twig\TemplateWrapper->render (line 306)
15	Twig\Environment->render (line 431)
16	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 62)
19	App\Controller\AwardController->nomination (line 183)
20	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
21	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
22	Symfony\Component\HttpKernel\Kernel->handle (line 35)
23	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
24	require_once (line 5)

0.13 ms
(0.06%)

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.10 ms
(0.05%)

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 63)
5	App\Controller\AwardController->nomination (line 183)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
8	Symfony\Component\HttpKernel\Kernel->handle (line 35)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
10	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\Award\AwardNomination	No errors.
App\Entity\File	No errors.
App\Entity\Award\Award	No errors.
App\Entity\Award\AwardAdjudicator	No errors.
App\Entity\Award\AwardApplication	No errors.
App\Entity\Award\AwardCriterion	No errors.
App\Entity\Award\AwardParticipant	No errors.
App\Entity\Award\AwardAdjudicatorType	No errors.
App\Entity\Award\AwardAdjudicatorVote	No errors.
App\Entity\Award\AwardContact	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\SeoStaticMeta	No errors.
App\Entity\Account	No errors.
App\Entity\Filter\FilterDistrict	No errors.
App\Entity\Publication	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\AreaHall	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\FilterMetro	No errors.
App\Entity\Filter\FilterSelection	No errors.
App\Entity\Filter\FilterType	No errors.
App\Entity\Advertising\AdvertisingBanner	No errors.
App\Entity\Advertising\AdvertisingHomepageTag	No errors.
App\Entity\Advertising\AdvertisingSelectionItem	No errors.
App\Entity\Advertising\AdvertisingSlider	No errors.

Symfony Profiler

GET https://stg.4banket.ru/msk/award/nomination/11

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping