Symfony Profiler

Query Metrics

4 Database Queries

3 Different statements

3.20 ms Query time

0 Invalid entities

2 Managed entities

Queries

Group similar statements

#▲

Time

Info

1.46 ms

SELECT DISTINCT l0_.sekce AS sekce_0 FROM legacy_rozvrh_skupina l0_ WHERE l0_.typ = ? AND l0_.aktivni = 1 ORDER BY l0_.sekce ASC

Parameters:

[
  "ucitel"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT l0_.sekce AS sekce_0
FROM
  legacy_rozvrh_skupina l0_
WHERE
  l0_.typ = ?
  AND l0_.aktivni = 1
ORDER BY
  l0_.sekce ASC

SELECT DISTINCT l0_.sekce AS sekce_0 FROM legacy_rozvrh_skupina l0_ WHERE l0_.typ = 'ucitel' AND l0_.aktivni = 1 ORDER BY l0_.sekce ASC;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getSingleColumnResult (line 712)
6	App\Repository\RozvrhSkupinaRepository->findSekce (line 34)
7	App\Controller\RozvrhVerejnyController->ucitele (line 103)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 188)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 79)
10	Symfony\Component\HttpKernel\Kernel->handle (line 143)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
12	require_once (line 32)
13	require_once (line 5)

0.37 ms

SELECT t0.id AS id_1, t0.semestr_cz AS semestr_cz_2, t0.semestr_en AS semestr_en_3, t0.mezidobi AS mezidobi_4, t0.neuplny_rozvrh AS neuplny_rozvrh_5 FROM legacy_rozvrh_nastaveni t0 LIMIT 1

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.semestr_cz AS semestr_cz_2,
  t0.semestr_en AS semestr_en_3,
  t0.mezidobi AS mezidobi_4,
  t0.neuplny_rozvrh AS neuplny_rozvrh_5
FROM
  legacy_rozvrh_nastaveni t0
LIMIT
  1

SELECT t0.id AS id_1, t0.semestr_cz AS semestr_cz_2, t0.semestr_en AS semestr_en_3, t0.mezidobi AS mezidobi_4, t0.neuplny_rozvrh AS neuplny_rozvrh_5 FROM legacy_rozvrh_nastaveni t0 LIMIT 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\EntityRepository->findOneBy (line 125)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepository->findOneBy (line 86)
4	App\Repository\RozvrhNastaveniRepository->get (line 18)
5	App\Controller\RozvrhVerejnyController->ucitele (line 107)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 188)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 79)
8	Symfony\Component\HttpKernel\Kernel->handle (line 143)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
10	require_once (line 32)
11	require_once (line 5)

0.39 ms

SELECT t0.id AS id_1, t0.slug AS slug_2, t0.obsah_cz AS obsah_cz_3, t0.obsah_en AS obsah_en_4 FROM legacy_verejny_text t0 WHERE t0.slug = ? LIMIT 1

Parameters:

[
  "mezidobi"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.slug AS slug_2,
  t0.obsah_cz AS obsah_cz_3,
  t0.obsah_en AS obsah_en_4
FROM
  legacy_verejny_text t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.slug AS slug_2, t0.obsah_cz AS obsah_cz_3, t0.obsah_en AS obsah_en_4 FROM legacy_verejny_text t0 WHERE t0.slug = 'mezidobi' LIMIT 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\EntityRepository->findOneBy (line 125)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepository->findOneBy (line 86)
4	App\Repository\VerejnyTextRepository->findBySlug (line 18)
5	App\Controller\RozvrhVerejnyController->ucitele (line 113)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 188)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 79)
8	Symfony\Component\HttpKernel\Kernel->handle (line 143)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
10	require_once (line 32)
11	require_once (line 5)

0.98 ms

SELECT DISTINCT l0_.sekce AS sekce_0 FROM legacy_rozvrh_skupina l0_ WHERE l0_.typ = ? AND l0_.aktivni = 1 ORDER BY l0_.sekce ASC

Parameters:

[
  "ucitel"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT l0_.sekce AS sekce_0
FROM
  legacy_rozvrh_skupina l0_
WHERE
  l0_.typ = ?
  AND l0_.aktivni = 1
ORDER BY
  l0_.sekce ASC

SELECT DISTINCT l0_.sekce AS sekce_0 FROM legacy_rozvrh_skupina l0_ WHERE l0_.typ = 'ucitel' AND l0_.aktivni = 1 ORDER BY l0_.sekce ASC;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getSingleColumnResult (line 712)
6	App\Repository\RozvrhSkupinaRepository->findSekce (line 34)
7	App\Twig\VerejnyNavExtension->navKatedry (line 37)
8	__TwigTemplate_af615e95ff808991d20ea7022df02471->doDisplay (line 179)
9	Twig\Template->yield (line 411)
10	__TwigTemplate_b6be239337b5bfa729bae94380ef41a9->doDisplay (line 54)
11	Twig\Template->yield (line 411)
12	Twig\Template->display (line 366)
13	Twig\Template->render (line 381)
14	Twig\TemplateWrapper->render (line 51)
15	Twig\Environment->render (line 333)
16	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 472)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 477)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 281)
19	App\Controller\RozvrhVerejnyController->ucitele (line 109)
20	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 188)
21	Symfony\Component\HttpKernel\HttpKernel->handle (line 79)
22	Symfony\Component\HttpKernel\Kernel->handle (line 143)
23	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
24	require_once (line 32)
25	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\RozvrhNastaveni	1
App\Entity\VerejnyText	1

Entities Mapping

Class	Mapping errors
App\Entity\RozvrhSkupina	No errors.
App\Entity\RozvrhNastaveni	No errors.
App\Entity\VerejnyText	No errors.

GET https://rozvrh-dev.fjfi.cvut.cz/rozvrh/ucitele/klff

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping