Symfony Profiler

Query Metrics

22 Database Queries

5 Different statements

4.81 ms Query time

6 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

3.12 ms
(64.86%)

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:

[
  43985
]

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 = 43985;

#	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 1635)
9	twig_get_attribute (line 88)
10	__TwigTemplate_8b386db1ba787dbf85ee75cbaf24a6f8->doDisplay (line 394)
11	Twig\Template->displayWithErrorHandling (line 367)
12	Twig\Template->display (line 379)
13	Twig\Template->render (line 38)
14	Twig\TemplateWrapper->render (line 280)
15	Twig\Environment->render (line 243)
16	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->renderView (line 254)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 31)
18	App\Controller\Site\Content\PartnerController->footer (line 181)
19	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
20	Symfony\Component\HttpKernel\HttpKernel->handle (line 86)
21	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 78)
22	Symfony\Component\HttpKernel\Fragment\InlineFragmentRenderer->render (line 83)
23	Symfony\Component\HttpKernel\Fragment\FragmentHandler->render (line 47)
24	Symfony\Component\HttpKernel\DependencyInjection\LazyLoadingFragmentHandler->render (line 44)
25	Symfony\Bridge\Twig\Extension\HttpKernelRuntime->renderFragment (line 494)
26	__TwigTemplate_d53dece85589918dbeb201351010d90b->doDisplay (line 394)
27	Twig\Template->displayWithErrorHandling (line 367)
28	Twig\Template->display (line 50)
29	__TwigTemplate_351535d3d6fb2dc638fca60c4bf566f1->doDisplay (line 394)
30	Twig\Template->displayWithErrorHandling (line 367)
31	Twig\Template->display (line 379)
32	Twig\Template->render (line 38)
33	Twig\TemplateWrapper->render (line 280)
34	Twig\Environment->render (line 243)
35	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->renderView (line 254)
36	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 35)
37	App\Controller\Site\TeamController->index (line 181)
38	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
39	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
40	Symfony\Component\HttpKernel\Kernel->handle (line 35)
41	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
42	require_once (line 5)

0.54 ms
(11.25%)

SELECT t0.id AS id_1, t0.full_name AS full_name_2, t0.short_name AS short_name_3, t0.main AS main_4, t0.date_create AS date_create_5, t0.date_update AS date_update_6, t0.object_status AS object_status_7, t0.club_id AS club_id_8, t0.logo_id AS logo_id_9 FROM team t0 WHERE t0.main = ? LIMIT 1

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.full_name AS full_name_2,
  t0.short_name AS short_name_3,
  t0.main AS main_4,
  t0.date_create AS date_create_5,
  t0.date_update AS date_update_6,
  t0.object_status AS object_status_7,
  t0.club_id AS club_id_8,
  t0.logo_id AS logo_id_9
FROM
  team t0
WHERE
  t0.main = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.full_name AS full_name_2, t0.short_name AS short_name_3, t0.main AS main_4, t0.date_create AS date_create_5, t0.date_update AS date_update_6, t0.object_status AS object_status_7, t0.club_id AS club_id_8, t0.logo_id AS logo_id_9 FROM team t0 WHERE t0.main = 1 LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 774)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 241)
3	Doctrine\ORM\EntityRepository->findOneBy (line 16)
4	App\Controller\Site\TeamController->index (line 181)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
7	Symfony\Component\HttpKernel\Kernel->handle (line 35)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
9	require_once (line 5)

0.41 ms
(8.45%)

SELECT t0.id AS id_1, t0.full_name AS full_name_2, t0.short_name AS short_name_3, t0.date_create AS date_create_4, t0.date_update AS date_update_5, t0.object_status AS object_status_6, t0.logo_id AS logo_id_7, t0.city_id AS city_id_8 FROM club t0 WHERE t0.id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.full_name AS full_name_2,
  t0.short_name AS short_name_3,
  t0.date_create AS date_create_4,
  t0.date_update AS date_update_5,
  t0.object_status AS object_status_6,
  t0.logo_id AS logo_id_7,
  t0.city_id AS city_id_8
FROM
  club t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.full_name AS full_name_2, t0.short_name AS short_name_3, t0.date_create AS date_create_4, t0.date_update AS date_update_5, t0.object_status AS object_status_6, t0.logo_id AS logo_id_7, t0.city_id AS city_id_8 FROM club t0 WHERE t0.id = 1;

#	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\Team\Club::Doctrine\ORM\Proxy\{closure} (line 100)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 185)
7	Proxies\__CG__\App\Entity\Team\Club->__get (line 235)
8	App\Entity\Team\Club->getActiveTeams (line 19)
9	App\Controller\Site\TeamController->index (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.38 ms
(7.91%)

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_351535d3d6fb2dc638fca60c4bf566f1->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 35)
23	App\Controller\Site\TeamController->index (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.36 ms
(7.53%)

SELECT t0.id AS id_1, t0.full_name AS full_name_2, t0.short_name AS short_name_3, t0.main AS main_4, t0.date_create AS date_create_5, t0.date_update AS date_update_6, t0.object_status AS object_status_7, t0.club_id AS club_id_8, t0.logo_id AS logo_id_9 FROM team t0 WHERE t0.club_id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.full_name AS full_name_2,
  t0.short_name AS short_name_3,
  t0.main AS main_4,
  t0.date_create AS date_create_5,
  t0.date_update AS date_update_6,
  t0.object_status AS object_status_7,
  t0.club_id AS club_id_8,
  t0.logo_id AS logo_id_9
FROM
  team t0
WHERE
  t0.club_id = ?

SELECT t0.id AS id_1, t0.full_name AS full_name_2, t0.short_name AS short_name_3, t0.main AS main_4, t0.date_create AS date_create_5, t0.date_update AS date_update_6, t0.object_status AS object_status_7, t0.club_id AS club_id_8, t0.logo_id AS logo_id_9 FROM team t0 WHERE t0.club_id = 1;

#	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 235)
8	App\Entity\Team\Club->getActiveTeams (line 19)
9	App\Controller\Site\TeamController->index (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)

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\Team\Team	No errors.
App\Entity\Team\Club	The association App\Entity\Team\Club#city refers to the inverse side field App\Entity\Reference\City#clubs which does not exist.
App\Entity\Service\File	No errors.
App\Entity\Team\TeamPlayer	No errors.
App\Entity\Team\TeamStaff	No errors.
App\Entity\Team\TeamPersonnel	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.
App\Entity\Reference\City	No errors.
App\Entity\Team\ClubPlayer	No errors.
App\Entity\Team\ClubStaff	No errors.
App\Entity\Team\ClubPersonnel	No errors.
App\Entity\Content\Partner	No errors.
App\Entity\Human\Player	No errors.
App\Entity\Human\Staff	No errors.
App\Entity\Human\Personnel	No errors.
App\Entity\Tournament\Tour	No errors.
App\Entity\Game\GamePlayer	No errors.
App\Entity\Game\GameEvent	No errors.
App\Entity\Content\Stadium	The association App\Entity\Content\Stadium#city refers to the inverse side field App\Entity\Reference\City#stadiums which does not exist.
App\Entity\Game\GameStaff	No errors.
App\Entity\Game\GameReferee	No errors.
App\Entity\Game\GameStats	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\VideoGame	The association App\Entity\Service\VideoGame#game refers to the inverse side field App\Entity\Game\Game#video which does not exist.
App\Entity\Service\PhotoGame	The association App\Entity\Service\PhotoGame#game refers to the inverse side field App\Entity\Game\Game#photo which does not exist.
App\Entity\Reference\Country	No errors.
App\Entity\Reference\TeamPlayerRole	No errors.
App\Entity\Reference\PlayerPosition	No errors.

Symfony Profiler

GET https://test.fcakron.ru/team?team=%C2%AB%D0%90%D0%BA%D1%80%D0%BE%D0%BD-2%C2%BB

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping