Symfony Profiler

Query Metrics

48 Database Queries

3 Different statements

13.48 ms Query time

0 Invalid entities

81 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

8.40 ms
(62.28%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.address AS address_3, t0.phone AS phone_4, t0.description AS description_5, t0.website AS website_6, t0.type AS type_7, t0.sports AS sports_8, t0.coordinates AS coordinates_9, t0.email AS email_10, t0.administrative_district AS administrative_district_11, t0.update_status AS update_status_12, t0.image AS image_13 FROM facility t0 WHERE t0.id = ?

Parameters:

[
  74
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.address AS address_3,
  t0.phone AS phone_4,
  t0.description AS description_5,
  t0.website AS website_6,
  t0.type AS type_7,
  t0.sports AS sports_8,
  t0.coordinates AS coordinates_9,
  t0.email AS email_10,
  t0.administrative_district AS administrative_district_11,
  t0.update_status AS update_status_12,
  t0.image AS image_13
FROM
  facility t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.address AS address_3, t0.phone AS phone_4, t0.description AS description_5, t0.website AS website_6, t0.type AS type_7, t0.sports AS sports_8, t0.coordinates AS coordinates_9, t0.email AS email_10, t0.administrative_district AS administrative_district_11, t0.update_status AS update_status_12, t0.image AS image_13 FROM facility t0 WHERE t0.id = 74;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
3	Doctrine\ORM\Proxy\ProxyFactory->{closure:Doctrine\ORM\Proxy\ProxyFactory::getProxy():217} (line 223)
4	Twig\Extension\CoreExtension::getAttribute (line 1789)
5	__TwigTemplate_c646b576e0e8c8cef70fd74ffe200b56::block_body (line 154)
6	Twig\Template->yieldBlock (line 446)
7	__TwigTemplate_73bb3cc7b090a4482aafa9082a7bb629->doDisplay (line 124)
8	Twig\Template->yield (line 402)
9	__TwigTemplate_c646b576e0e8c8cef70fd74ffe200b56->doDisplay (line 54)
10	Twig\Template->yield (line 402)
11	Twig\Template->display (line 358)
12	Twig\Template->render (line 373)
13	Twig\TemplateWrapper->render (line 51)
14	Twig\Environment->render (line 333)
15	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 462)
16	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 467)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 279)
18	App\Controller\AdminTydenSportuController->list (line 37)
19	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
20	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
21	Symfony\Component\HttpKernel\Kernel->handle (line 191)
22	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
23	require_once (line 32)
24	require_once (line 5)

4.44 ms
(32.91%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.icon AS icon_3, t0.slug AS slug_4 FROM sport t0 WHERE t0.id = ?

Parameters:

[
  28
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.icon AS icon_3,
  t0.slug AS slug_4
FROM
  sport t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.icon AS icon_3, t0.slug AS slug_4 FROM sport t0 WHERE t0.id = 28;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
3	Doctrine\ORM\Proxy\ProxyFactory->{closure:Doctrine\ORM\Proxy\ProxyFactory::getProxy():217} (line 223)
4	Twig\Extension\CoreExtension::getAttribute (line 1789)
5	__TwigTemplate_c646b576e0e8c8cef70fd74ffe200b56::block_body (line 162)
6	Twig\Template->yieldBlock (line 446)
7	__TwigTemplate_73bb3cc7b090a4482aafa9082a7bb629->doDisplay (line 124)
8	Twig\Template->yield (line 402)
9	__TwigTemplate_c646b576e0e8c8cef70fd74ffe200b56->doDisplay (line 54)
10	Twig\Template->yield (line 402)
11	Twig\Template->display (line 358)
12	Twig\Template->render (line 373)
13	Twig\TemplateWrapper->render (line 51)
14	Twig\Environment->render (line 333)
15	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 462)
16	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 467)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 279)
18	App\Controller\AdminTydenSportuController->list (line 37)
19	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
20	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
21	Symfony\Component\HttpKernel\Kernel->handle (line 191)
22	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
23	require_once (line 32)
24	require_once (line 5)

0.65 ms
(4.81%)

SELECT t0.id AS id_1, t0.email AS email_2, t0.sport_id AS sport_id_3, t0.week_description AS week_description_4, t0.website AS website_5, t0.address AS address_6, t0.monday AS monday_7, t0.tuesday AS tuesday_8, t0.wednesday AS wednesday_9, t0.thursday AS thursday_10, t0.friday AS friday_11, t0.saturday AS saturday_12, t0.sunday AS sunday_13, t0.reservation_phone AS reservation_phone_14, t0.reservation_email AS reservation_email_15, t0.reservation_web AS reservation_web_16, t0.display AS display_17, t0.hash AS hash_18, t0.full AS full_19, t0.created_by AS created_by_20, t0.created_at AS created_at_21, t0.updated_at AS updated_at_22, t0.year AS year_23, t0.slug AS slug_24, t0.facility_id AS facility_id_25, t0.club_id AS club_id_26, t0.sport_id AS sport_id_27 FROM tyden_sportu t0 ORDER BY t0.year DESC, t0.id DESC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.sport_id AS sport_id_3,
  t0.week_description AS week_description_4,
  t0.website AS website_5,
  t0.address AS address_6,
  t0.monday AS monday_7,
  t0.tuesday AS tuesday_8,
  t0.wednesday AS wednesday_9,
  t0.thursday AS thursday_10,
  t0.friday AS friday_11,
  t0.saturday AS saturday_12,
  t0.sunday AS sunday_13,
  t0.reservation_phone AS reservation_phone_14,
  t0.reservation_email AS reservation_email_15,
  t0.reservation_web AS reservation_web_16,
  t0.display AS display_17,
  t0.hash AS hash_18,
  t0.full AS full_19,
  t0.created_by AS created_by_20,
  t0.created_at AS created_at_21,
  t0.updated_at AS updated_at_22,
  t0.year AS year_23,
  t0.slug AS slug_24,
  t0.facility_id AS facility_id_25,
  t0.club_id AS club_id_26,
  t0.sport_id AS sport_id_27
FROM
  tyden_sportu t0
ORDER BY
  t0.year DESC,
  t0.id DESC

SELECT t0.id AS id_1, t0.email AS email_2, t0.sport_id AS sport_id_3, t0.week_description AS week_description_4, t0.website AS website_5, t0.address AS address_6, t0.monday AS monday_7, t0.tuesday AS tuesday_8, t0.wednesday AS wednesday_9, t0.thursday AS thursday_10, t0.friday AS friday_11, t0.saturday AS saturday_12, t0.sunday AS sunday_13, t0.reservation_phone AS reservation_phone_14, t0.reservation_email AS reservation_email_15, t0.reservation_web AS reservation_web_16, t0.display AS display_17, t0.hash AS hash_18, t0.full AS full_19, t0.created_by AS created_by_20, t0.created_at AS created_at_21, t0.updated_at AS updated_at_22, t0.year AS year_23, t0.slug AS slug_24, t0.facility_id AS facility_id_25, t0.club_id AS club_id_26, t0.sport_id AS sport_id_27 FROM tyden_sportu t0 ORDER BY t0.year DESC, t0.id DESC;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 963)
2	Doctrine\ORM\EntityRepository->findBy (line 110)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepository->findBy (line 78)
4	App\Controller\AdminTydenSportuController->list (line 35)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
7	Symfony\Component\HttpKernel\Kernel->handle (line 191)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
9	require_once (line 32)
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.

Managed Entities

default entity manager

Class	Amount of managed objects
App\Entity\TydenSportu	34
App\Entity\Facility	29
App\Entity\Sport	18

Entities Mapping

Class	Mapping errors
App\Entity\TydenSportu	No errors.
App\Entity\Facility	No errors.
App\Entity\Club	No errors.
App\Entity\Sport	No errors.
App\Entity\FacilityPhoto	No errors.

Symfony Profiler

GET https://dev.ps.netlion.cz/admin/tyden-sportu/

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping