Symfony Profiler

Query Metrics

36 Database Queries

7 Different statements

9.95 ms Query time

2 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

4.38 ms
(44.06%)

SELECT t0.id AS id_1, t0.module AS module_2, t0.mime_type AS mime_type_3, t0.size AS size_4, t0.name AS name_5, t0.date_create AS date_create_6, t0.date_update AS date_update_7, t0.object_status AS object_status_8 FROM file t0 WHERE t0.id = ?

Parameters:

[
  43981
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.module AS module_2,
  t0.mime_type AS mime_type_3,
  t0.size AS size_4,
  t0.name AS name_5,
  t0.date_create AS date_create_6,
  t0.date_update AS date_update_7,
  t0.object_status AS object_status_8
FROM
  file t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.module AS module_2, t0.mime_type AS mime_type_3, t0.size AS size_4, t0.name AS name_5, t0.date_create AS date_create_6, t0.date_update AS date_update_7, t0.object_status AS object_status_8 FROM file t0 WHERE t0.id = 43981;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 774)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 792)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 365)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 472)
5	Proxies\__CG__\App\Entity\Service\File::Doctrine\ORM\Proxy\{closure} (line 100)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 185)
7	Proxies\__CG__\App\Entity\Service\File->__get (line 93)
8	App\Entity\Service\File->getPath (line 39)
9	App\Managers\Site\NewsManager->get (line 13)
10	App\Controller\Site\NewsController->inner (line 181)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
13	Symfony\Component\HttpKernel\Kernel->handle (line 35)
14	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
15	require_once (line 5)

2.03 ms
(20.44%)

SELECT n0_.id AS id_0, n0_.full_title AS full_title_1, n0_.short_title AS short_title_2, n0_.preview_text AS preview_text_3, n0_.text AS text_4, n0_.show_in_slider AS show_in_slider_5, n0_.date_publication AS date_publication_6, n0_.priority AS priority_7, n0_.video_link AS video_link_8, n0_.is_draft AS is_draft_9, n0_.date_create AS date_create_10, n0_.date_update AS date_update_11, n0_.object_status AS object_status_12, n0_.preview_image_id AS preview_image_id_13, n0_.header_image_id AS header_image_id_14, n0_.player_id AS player_id_15, n0_.staff_id AS staff_id_16, n0_.personnel_id AS personnel_id_17 FROM news n0_ WHERE n0_.id <> ? AND n0_.object_status = ? AND n0_.is_draft = 0 ORDER BY n0_.date_publication DESC LIMIT 5

Parameters:

[
  2123
  "active"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  n0_.id AS id_0,
  n0_.full_title AS full_title_1,
  n0_.short_title AS short_title_2,
  n0_.preview_text AS preview_text_3,
  n0_.text AS text_4,
  n0_.show_in_slider AS show_in_slider_5,
  n0_.date_publication AS date_publication_6,
  n0_.priority AS priority_7,
  n0_.video_link AS video_link_8,
  n0_.is_draft AS is_draft_9,
  n0_.date_create AS date_create_10,
  n0_.date_update AS date_update_11,
  n0_.object_status AS object_status_12,
  n0_.preview_image_id AS preview_image_id_13,
  n0_.header_image_id AS header_image_id_14,
  n0_.player_id AS player_id_15,
  n0_.staff_id AS staff_id_16,
  n0_.personnel_id AS personnel_id_17
FROM
  news n0_
WHERE
  n0_.id <> ?
  AND n0_.object_status = ?
  AND n0_.is_draft = 0
ORDER BY
  n0_.date_publication DESC
LIMIT
  5

SELECT n0_.id AS id_0, n0_.full_title AS full_title_1, n0_.short_title AS short_title_2, n0_.preview_text AS preview_text_3, n0_.text AS text_4, n0_.show_in_slider AS show_in_slider_5, n0_.date_publication AS date_publication_6, n0_.priority AS priority_7, n0_.video_link AS video_link_8, n0_.is_draft AS is_draft_9, n0_.date_create AS date_create_10, n0_.date_update AS date_update_11, n0_.object_status AS object_status_12, n0_.preview_image_id AS preview_image_id_13, n0_.header_image_id AS header_image_id_14, n0_.player_id AS player_id_15, n0_.staff_id AS staff_id_16, n0_.personnel_id AS personnel_id_17 FROM news n0_ WHERE n0_.id <> 2123 AND n0_.object_status = 'active' AND n0_.is_draft = 0 ORDER BY n0_.date_publication DESC LIMIT 5;

#	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 116)
7	App\Repository\Content\NewsRepository->findByFilterPublicationDESC (line 33)
8	App\Managers\Site\NewsManager->get (line 13)
9	App\Controller\Site\NewsController->inner (line 181)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
12	Symfony\Component\HttpKernel\Kernel->handle (line 35)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
14	require_once (line 5)

1.52 ms
(15.29%)

SELECT t0.id AS id_1, t0.date_create AS date_create_2, t0.date_update AS date_update_3, t0.object_status AS object_status_4, t0.news_id AS news_id_5, t0.tag_id AS tag_id_6 FROM news_tag t0 WHERE t0.news_id = ?

Parameters:

[
  2123
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.date_create AS date_create_2,
  t0.date_update AS date_update_3,
  t0.object_status AS object_status_4,
  t0.news_id AS news_id_5,
  t0.tag_id AS tag_id_6
FROM
  news_tag t0
WHERE
  t0.news_id = ?

SELECT t0.id AS id_1, t0.date_create AS date_create_2, t0.date_update AS date_update_3, t0.object_status AS object_status_4, t0.news_id AS news_id_5, t0.tag_id AS tag_id_6 FROM news_tag t0 WHERE t0.news_id = 2123;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1889)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1830)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 3289)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 706)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 215)
6	Doctrine\ORM\PersistentCollection->initialize (line 313)
7	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 28)
8	App\Managers\Site\NewsManager->get (line 13)
9	App\Controller\Site\NewsController->inner (line 181)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
12	Symfony\Component\HttpKernel\Kernel->handle (line 35)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
14	require_once (line 5)

0.70 ms
(7.08%)

SELECT t0.id AS id_1, t0.full_title AS full_title_2, t0.short_title AS short_title_3, t0.preview_text AS preview_text_4, t0.text AS text_5, t0.show_in_slider AS show_in_slider_6, t0.date_publication AS date_publication_7, t0.priority AS priority_8, t0.video_link AS video_link_9, t0.is_draft AS is_draft_10, t0.date_create AS date_create_11, t0.date_update AS date_update_12, t0.object_status AS object_status_13, t0.preview_image_id AS preview_image_id_14, t0.header_image_id AS header_image_id_15, t0.player_id AS player_id_16, t0.staff_id AS staff_id_17, t0.personnel_id AS personnel_id_18 FROM news t0 WHERE t0.id = ?

Parameters:

[
  2123
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.full_title AS full_title_2,
  t0.short_title AS short_title_3,
  t0.preview_text AS preview_text_4,
  t0.text AS text_5,
  t0.show_in_slider AS show_in_slider_6,
  t0.date_publication AS date_publication_7,
  t0.priority AS priority_8,
  t0.video_link AS video_link_9,
  t0.is_draft AS is_draft_10,
  t0.date_create AS date_create_11,
  t0.date_update AS date_update_12,
  t0.object_status AS object_status_13,
  t0.preview_image_id AS preview_image_id_14,
  t0.header_image_id AS header_image_id_15,
  t0.player_id AS player_id_16,
  t0.staff_id AS staff_id_17,
  t0.personnel_id AS personnel_id_18
FROM
  news t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.full_title AS full_title_2, t0.short_title AS short_title_3, t0.preview_text AS preview_text_4, t0.text AS text_5, t0.show_in_slider AS show_in_slider_6, t0.date_publication AS date_publication_7, t0.priority AS priority_8, t0.video_link AS video_link_9, t0.is_draft AS is_draft_10, t0.date_create AS date_create_11, t0.date_update AS date_update_12, t0.object_status AS object_status_13, t0.preview_image_id AS preview_image_id_14, t0.header_image_id AS header_image_id_15, t0.player_id AS player_id_16, t0.staff_id AS staff_id_17, t0.personnel_id AS personnel_id_18 FROM news t0 WHERE t0.id = 2123;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 774)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 792)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 521)
4	Doctrine\ORM\EntityManager->find (line 197)
5	Doctrine\ORM\EntityRepository->find (line 20)
6	App\Managers\Site\NewsManager->get (line 13)
7	App\Controller\Site\NewsController->inner (line 181)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
10	Symfony\Component\HttpKernel\Kernel->handle (line 35)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
12	require_once (line 5)

0.54 ms
(5.38%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.priority AS priority_3, t0.line AS line_4, t0.link AS link_5, t0.date_create AS date_create_6, t0.date_update AS date_update_7, t0.object_status AS object_status_8, t0.preview_image_id AS preview_image_id_9 FROM partner t0 WHERE t0.object_status = ? ORDER BY t0.line ASC, t0.priority ASC

Parameters:

[
  "active"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.priority AS priority_3,
  t0.line AS line_4,
  t0.link AS link_5,
  t0.date_create AS date_create_6,
  t0.date_update AS date_update_7,
  t0.object_status AS object_status_8,
  t0.preview_image_id AS preview_image_id_9
FROM
  partner t0
WHERE
  t0.object_status = ?
ORDER BY
  t0.line ASC,
  t0.priority ASC

SELECT t0.id AS id_1, t0.name AS name_2, t0.priority AS priority_3, t0.line AS line_4, t0.link AS link_5, t0.date_create AS date_create_6, t0.date_update AS date_update_7, t0.object_status AS object_status_8, t0.preview_image_id AS preview_image_id_9 FROM partner t0 WHERE t0.object_status = 'active' ORDER BY t0.line ASC, t0.priority ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 942)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 225)
3	Doctrine\ORM\EntityRepository->findBy (line 18)
4	App\Controller\Site\Content\PartnerController->footer (line 181)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 86)
7	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 78)
8	Symfony\Component\HttpKernel\Fragment\InlineFragmentRenderer->render (line 83)
9	Symfony\Component\HttpKernel\Fragment\FragmentHandler->render (line 47)
10	Symfony\Component\HttpKernel\DependencyInjection\LazyLoadingFragmentHandler->render (line 44)
11	Symfony\Bridge\Twig\Extension\HttpKernelRuntime->renderFragment (line 494)
12	__TwigTemplate_d53dece85589918dbeb201351010d90b->doDisplay (line 394)
13	Twig\Template->displayWithErrorHandling (line 367)
14	Twig\Template->display (line 50)
15	__TwigTemplate_0f7e242fc6c499fd93f462dc042d7965->doDisplay (line 394)
16	Twig\Template->displayWithErrorHandling (line 367)
17	Twig\Template->display (line 379)
18	Twig\Template->render (line 38)
19	Twig\TemplateWrapper->render (line 280)
20	Twig\Environment->render (line 243)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->renderView (line 254)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 13)
23	App\Controller\Site\NewsController->inner (line 181)
24	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
25	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
26	Symfony\Component\HttpKernel\Kernel->handle (line 35)
27	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
28	require_once (line 5)

0.43 ms
(4.34%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.date_create AS date_create_3, t0.date_update AS date_update_4, t0.object_status AS object_status_5 FROM tag t0 WHERE t0.id = ?

Parameters:

[
  2
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.date_create AS date_create_3,
  t0.date_update AS date_update_4,
  t0.object_status AS object_status_5
FROM
  tag t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.date_create AS date_create_3, t0.date_update AS date_update_4, t0.object_status AS object_status_5 FROM tag t0 WHERE t0.id = 2;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 774)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 792)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 365)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 472)
5	Proxies\__CG__\App\Entity\Service\Tag::Doctrine\ORM\Proxy\{closure} (line 100)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 185)
7	Proxies\__CG__\App\Entity\Service\Tag->__get (line 56)
8	App\Entity\Service\Tag->getName (line 382)
9	App\Entity\Content\News->getFirstTagNameOrDefaultTitle (line 38)
10	App\Managers\Site\NewsManager->get (line 13)
11	App\Controller\Site\NewsController->inner (line 181)
12	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
13	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
14	Symfony\Component\HttpKernel\Kernel->handle (line 35)
15	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
16	require_once (line 5)

0.34 ms
(3.42%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.date_create AS date_create_3, t0.date_update AS date_update_4, t0.object_status AS object_status_5, t0.file_id AS file_id_6, t0.news_id AS news_id_7 FROM news_image t0 WHERE t0.news_id = ?

Parameters:

[
  2123
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.date_create AS date_create_3,
  t0.date_update AS date_update_4,
  t0.object_status AS object_status_5,
  t0.file_id AS file_id_6,
  t0.news_id AS news_id_7
FROM
  news_image t0
WHERE
  t0.news_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.date_create AS date_create_3, t0.date_update AS date_update_4, t0.object_status AS object_status_5, t0.file_id AS file_id_6, t0.news_id AS news_id_7 FROM news_image t0 WHERE t0.news_id = 2123;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1889)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1830)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 3289)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 706)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 215)
6	Doctrine\ORM\PersistentCollection->initialize (line 39)
7	Doctrine\Common\Collections\AbstractLazyCollection->count (line 458)
8	Doctrine\ORM\PersistentCollection->count (line 233)
9	__TwigTemplate_0f7e242fc6c499fd93f462dc042d7965->block_body (line 171)
10	Twig\Template->displayBlock (line 491)
11	__TwigTemplate_d53dece85589918dbeb201351010d90b->doDisplay (line 394)
12	Twig\Template->displayWithErrorHandling (line 367)
13	Twig\Template->display (line 50)
14	__TwigTemplate_0f7e242fc6c499fd93f462dc042d7965->doDisplay (line 394)
15	Twig\Template->displayWithErrorHandling (line 367)
16	Twig\Template->display (line 379)
17	Twig\Template->render (line 38)
18	Twig\TemplateWrapper->render (line 280)
19	Twig\Environment->render (line 243)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->renderView (line 254)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 13)
22	App\Controller\Site\NewsController->inner (line 181)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
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\Content\News	No errors.
App\Entity\Service\File	No errors.
App\Entity\Human\Player	No errors.
App\Entity\Human\Staff	No errors.
App\Entity\Human\Personnel	No errors.
App\Entity\Service\NewsImage	No errors.
App\Entity\Service\NewsTag	No errors.
App\Entity\Service\NewsGame	The association App\Entity\Service\NewsGame#game refers to the inverse side field App\Entity\Game\Game#news which does not exist.
App\Entity\Service\Tag	No errors.
App\Entity\Content\Partner	No errors.
App\Entity\Team\TeamPlayer	No errors.
App\Entity\Team\ClubPlayer	No errors.
App\Entity\Service\Document	No errors.
App\Entity\Statistic\PlayerStatistic	No errors.
App\Entity\Reference\Country	No errors.
App\Entity\Reference\Sex	No errors.
App\Entity\Team\TeamStaff	No errors.
App\Entity\Team\ClubStaff	No errors.
App\Entity\Team\TeamPersonnel	No errors.
App\Entity\Team\ClubPersonnel	No errors.
App\Entity\Game\Game	The field App\Entity\Game\Game#gameEvents is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Game\GameEvent#game does not contain the required 'inversedBy="gameEvents"' attribute. The mappings App\Entity\Game\Game#gameNews and App\Entity\Service\NewsGame#game are inconsistent with each other. The mappings App\Entity\Game\Game#gameVideos and App\Entity\Service\VideoGame#game are inconsistent with each other. The mappings App\Entity\Game\Game#gamePhotos and App\Entity\Service\PhotoGame#game are inconsistent with each other.

Symfony Profiler

GET https://test.fcakron.ru/news/2123

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping