Symfony Profiler

Query Metrics

3 Database Queries

3 Different statements

2.56 ms Query time

0 Invalid entities

32 Managed entities

Queries

Group similar statements

#▲

Time

Info

0.71 ms

SELECT r0_.id AS id_0, r0_.nombre AS nombre_1, r0_.codigo AS codigo_2, r0_.grupo AS grupo_3, r0_.categoria_id AS categoria_id_4 FROM rol r0_

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  r0_.id AS id_0,
  r0_.nombre AS nombre_1,
  r0_.codigo AS codigo_2,
  r0_.grupo AS grupo_3,
  r0_.categoria_id AS categoria_id_4
FROM
  rol r0_

SELECT r0_.id AS id_0, r0_.nombre AS nombre_1, r0_.codigo AS codigo_2, r0_.grupo AS grupo_3, r0_.categoria_id AS categoria_id_4 FROM rol r0_;

#	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	Symfony\Bridge\Doctrine\Form\ChoiceList\ORMQueryBuilderLoader->getEntities (line 36)
6	Symfony\Bridge\Doctrine\Form\ChoiceList\DoctrineChoiceLoader->loadChoices (line 53)
7	Symfony\Component\Form\ChoiceList\Loader\AbstractChoiceLoader->loadChoiceList (line 29)
8	Symfony\Component\Form\ChoiceList\LazyChoiceList->getChoices (line 56)
9	Symfony\Component\Form\ChoiceList\Factory\DefaultChoiceListFactory->createView (line 60)
10	Symfony\Component\Form\ChoiceList\Factory\PropertyAccessDecorator->createView (line 178)
11	Symfony\Component\Form\ChoiceList\Factory\CachingFactoryDecorator->createView (line 187)
12	Symfony\Component\Form\Extension\Core\Type\ChoiceType->createChoiceListView (line 478)
13	Symfony\Component\Form\Extension\Core\Type\ChoiceType->buildView (line 233)
14	Symfony\Component\Form\ResolvedFormType->buildView (line 111)
15	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildView (line 78)
16	Symfony\Component\Form\ResolvedFormType->buildView (line 109)
17	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildView (line 78)
18	Symfony\Component\Form\Form->createView (line 892)
19	Symfony\Component\Form\Form->createView (line 895)
20	App\Controller\RegistrationController->saveFormsComponent (line 352)
21	App\Controller\RegistrationController->saveForms (line 157)
22	App\Controller\RegistrationController->register (line 71)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
25	Symfony\Component\HttpKernel\Kernel->handle (line 193)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
27	require_once (line 32)
28	require_once (line 5)

0.88 ms

SELECT c0_.id AS id_0, c0_.nombre AS nombre_1, c0_.codigo AS codigo_2, c0_.orden AS orden_3, c0_.grupo AS grupo_4 FROM categoria c0_ WHERE c0_.grupo = ?

Parameters:

[
  "habilitacion"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  c0_.id AS id_0,
  c0_.nombre AS nombre_1,
  c0_.codigo AS codigo_2,
  c0_.orden AS orden_3,
  c0_.grupo AS grupo_4
FROM
  categoria c0_
WHERE
  c0_.grupo = ?

SELECT c0_.id AS id_0, c0_.nombre AS nombre_1, c0_.codigo AS codigo_2, c0_.orden AS orden_3, c0_.grupo AS grupo_4 FROM categoria c0_ WHERE c0_.grupo = 'habilitacion';

#	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	Symfony\Bridge\Doctrine\Form\ChoiceList\ORMQueryBuilderLoader->getEntities (line 36)
6	Symfony\Bridge\Doctrine\Form\ChoiceList\DoctrineChoiceLoader->loadChoices (line 53)
7	Symfony\Component\Form\ChoiceList\Loader\AbstractChoiceLoader->loadChoiceList (line 29)
8	Symfony\Component\Form\ChoiceList\LazyChoiceList->getChoices (line 56)
9	Symfony\Component\Form\ChoiceList\Factory\DefaultChoiceListFactory->createView (line 60)
10	Symfony\Component\Form\ChoiceList\Factory\PropertyAccessDecorator->createView (line 178)
11	Symfony\Component\Form\ChoiceList\Factory\CachingFactoryDecorator->createView (line 202)
12	Symfony\Component\Form\Extension\Core\Type\ChoiceType->createChoiceListView (line 478)
13	Symfony\Component\Form\Extension\Core\Type\ChoiceType->buildView (line 233)
14	Symfony\Component\Form\ResolvedFormType->buildView (line 111)
15	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildView (line 78)
16	Symfony\Component\Form\ResolvedFormType->buildView (line 109)
17	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildView (line 78)
18	Symfony\Component\Form\Form->createView (line 892)
19	Symfony\Component\Form\Form->createView (line 895)
20	App\Controller\RegistrationController->saveFormsComponent (line 352)
21	App\Controller\RegistrationController->saveForms (line 157)
22	App\Controller\RegistrationController->register (line 71)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
25	Symfony\Component\HttpKernel\Kernel->handle (line 193)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
27	require_once (line 32)
28	require_once (line 5)

0.97 ms

SELECT m0_.id AS id_0, m0_.fecha AS fecha_1, m0_.h_inicio AS h_inicio_2, m0_.h_fin AS h_fin_3, m0_.observaciones AS observaciones_4, m0_.grupos AS grupos_5, m0_.club_id AS club_id_6, m0_.lugar_id AS lugar_id_7, m0_.instructor_id AS instructor_id_8, m0_.comision_directiva_id AS comision_directiva_id_9, m0_.prefectura_id AS prefectura_id_10, m0_.ordenanza_id AS ordenanza_id_11 FROM mesa_examen m0_

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  m0_.id AS id_0,
  m0_.fecha AS fecha_1,
  m0_.h_inicio AS h_inicio_2,
  m0_.h_fin AS h_fin_3,
  m0_.observaciones AS observaciones_4,
  m0_.grupos AS grupos_5,
  m0_.club_id AS club_id_6,
  m0_.lugar_id AS lugar_id_7,
  m0_.instructor_id AS instructor_id_8,
  m0_.comision_directiva_id AS comision_directiva_id_9,
  m0_.prefectura_id AS prefectura_id_10,
  m0_.ordenanza_id AS ordenanza_id_11
FROM
  mesa_examen m0_

SELECT m0_.id AS id_0, m0_.fecha AS fecha_1, m0_.h_inicio AS h_inicio_2, m0_.h_fin AS h_fin_3, m0_.observaciones AS observaciones_4, m0_.grupos AS grupos_5, m0_.club_id AS club_id_6, m0_.lugar_id AS lugar_id_7, m0_.instructor_id AS instructor_id_8, m0_.comision_directiva_id AS comision_directiva_id_9, m0_.prefectura_id AS prefectura_id_10, m0_.ordenanza_id AS ordenanza_id_11 FROM mesa_examen m0_;

#	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	Symfony\Bridge\Doctrine\Form\ChoiceList\ORMQueryBuilderLoader->getEntities (line 36)
6	Symfony\Bridge\Doctrine\Form\ChoiceList\DoctrineChoiceLoader->loadChoices (line 53)
7	Symfony\Component\Form\ChoiceList\Loader\AbstractChoiceLoader->loadChoiceList (line 29)
8	Symfony\Component\Form\ChoiceList\LazyChoiceList->getChoices (line 56)
9	Symfony\Component\Form\ChoiceList\Factory\DefaultChoiceListFactory->createView (line 60)
10	Symfony\Component\Form\ChoiceList\Factory\PropertyAccessDecorator->createView (line 178)
11	Symfony\Component\Form\ChoiceList\Factory\CachingFactoryDecorator->createView (line 202)
12	Symfony\Component\Form\Extension\Core\Type\ChoiceType->createChoiceListView (line 478)
13	Symfony\Component\Form\Extension\Core\Type\ChoiceType->buildView (line 233)
14	Symfony\Component\Form\ResolvedFormType->buildView (line 111)
15	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildView (line 78)
16	Symfony\Component\Form\ResolvedFormType->buildView (line 109)
17	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildView (line 78)
18	Symfony\Component\Form\Form->createView (line 892)
19	Symfony\Component\Form\Form->createView (line 895)
20	App\Controller\RegistrationController->saveFormsComponent (line 352)
21	App\Controller\RegistrationController->saveForms (line 157)
22	App\Controller\RegistrationController->register (line 71)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
25	Symfony\Component\HttpKernel\Kernel->handle (line 193)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
27	require_once (line 32)
28	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\Rol	19
App\Entity\Categoria	13

Entities Mapping

Class	Mapping errors
App\Entity\User	No errors.
App\Entity\Persona	No errors.
App\Entity\Rol	No errors.
App\Entity\Categoria	No errors.
App\Entity\Alumno	No errors.
App\Entity\MesaExamen	No errors.
App\Entity\EventoRolPersona	No errors.
App\Entity\Club	No errors.
App\Entity\Lugar	No errors.
App\Entity\Ordenanza	No errors.

Symfony Profiler

GET https://tsc.justamente.net/register

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping