Symfony Profiler

Query Metrics

4 Database Queries

4 Different statements

10.15 ms Query time

0 Invalid entities

3 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

8.94 ms
(88.01%)

"COMMIT"

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

"COMMIT"

"COMMIT";

#	File/Call
1	Doctrine\ORM\UnitOfWork->commit (line 433)
2	Doctrine\ORM\EntityManager->flush (line 268)
3	App\Controller\AdminTydenSportuController->edit (line 172)
4	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
5	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
6	Symfony\Component\HttpKernel\Kernel->handle (line 191)
7	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
8	require_once (line 32)
9	require_once (line 5)

0.70 ms
(6.88%)

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 WHERE t0.id = ?

Parameters:

[
  34
]

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
WHERE
  t0.id = ?

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 WHERE t0.id = 34;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
3	Doctrine\ORM\EntityManager->find (line 366)
4	Doctrine\ORM\EntityRepository->find (line 86)
5	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepository->find (line 66)
6	App\Controller\AdminTydenSportuController->edit (line 124)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
9	Symfony\Component\HttpKernel\Kernel->handle (line 191)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
11	require_once (line 32)
12	require_once (line 5)

0.34 ms
(3.30%)

UPDATE tyden_sportu SET week_description = ? WHERE id = ?

Parameters:

[
  """
    V rámci akce Týden sportu zdarma si sportoviště na Výstavišti Praha připravilo pro své návštěvníky možnost zdarma si přijít zaplavat do plaveckém bazénu.\r\n
    Kapacita bazénu je pro tuto akci 36 plavců, pokud bude v danou chvíli plno, můžete zajít do bistra Kafe přímo v bazénu a počkat, než se bazén uvolní.\r\n
    <br><br>\r\n
    Rezervace návštěvy sportoviště není nutná.
    """
  34
]

View formatted query View runnable query Explain query View query backtrace

UPDATE
  tyden_sportu
SET
  week_description = ?
WHERE
  id = ?

UPDATE tyden_sportu SET week_description = 'V rámci akce Týden sportu zdarma si sportoviště na Výstavišti Praha připravilo pro své návštěvníky možnost zdarma si přijít zaplavat do plaveckém bazénu.
Kapacita bazénu je pro tuto akci 36 plavců, pokud bude v danou chvíli plno, můžete zajít do bistra Kafe přímo v bazénu a počkat, než se bazén uvolní.
<br><br>
Rezervace návštěvy sportoviště není nutná.' WHERE id = 34;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->updateTable (line 494)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->update (line 378)
3	Doctrine\ORM\UnitOfWork->executeUpdates (line 1140)
4	Doctrine\ORM\UnitOfWork->commit (line 408)
5	Doctrine\ORM\EntityManager->flush (line 268)
6	App\Controller\AdminTydenSportuController->edit (line 172)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
9	Symfony\Component\HttpKernel\Kernel->handle (line 191)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
11	require_once (line 32)
12	require_once (line 5)

0.18 ms
(1.80%)

"START TRANSACTION"

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

"START TRANSACTION"

"START TRANSACTION";

#	File/Call
1	Doctrine\ORM\UnitOfWork->commit (line 382)
2	Doctrine\ORM\EntityManager->flush (line 268)
3	App\Controller\AdminTydenSportuController->edit (line 172)
4	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
5	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
6	Symfony\Component\HttpKernel\Kernel->handle (line 191)
7	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
8	require_once (line 32)
9	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	1
App\Entity\Facility	1
App\Entity\Sport	1

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.

Symfony Profiler

POST https://dev.ps.netlion.cz/admin/tyden-sportu/34/edit

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping