Symfony Profiler

Query Metrics

22 Database Queries

6 Different statements

3.97 ms Query time

0 Invalid entities

48 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

2.19 ms
(55.20%)

SELECT t0.id AS id_1, t0.profesion AS profesion_2, t0.siglas AS siglas_3, t0.codigo_profesion AS codigo_profesion_4, t0.horas_requeridas_total AS horas_requeridas_total_5, t0.horas_requeridas_presencial AS horas_requeridas_presencial_6, t0.is_default AS is_default_7, t0.is_featured AS is_featured_8, t0.slug AS slug_9, t0.is_public AS is_public_10, t0.icon AS icon_11 FROM profesion t0 WHERE t0.id = ?

Parameters:

[
  35
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.profesion AS profesion_2,
  t0.siglas AS siglas_3,
  t0.codigo_profesion AS codigo_profesion_4,
  t0.horas_requeridas_total AS horas_requeridas_total_5,
  t0.horas_requeridas_presencial AS horas_requeridas_presencial_6,
  t0.is_default AS is_default_7,
  t0.is_featured AS is_featured_8,
  t0.slug AS slug_9,
  t0.is_public AS is_public_10,
  t0.icon AS icon_11
FROM
  profesion t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.profesion AS profesion_2, t0.siglas AS siglas_3, t0.codigo_profesion AS codigo_profesion_4, t0.horas_requeridas_total AS horas_requeridas_total_5, t0.horas_requeridas_presencial AS horas_requeridas_presencial_6, t0.is_default AS is_default_7, t0.is_featured AS is_featured_8, t0.slug AS slug_9, t0.is_public AS is_public_10, t0.icon AS icon_11 FROM profesion t0 WHERE t0.id = 35;

#	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->Doctrine\ORM\Proxy\{closure} (line 295)
4	Proxies\__CG__\App\Entity\Profesion::Doctrine\ORM\Proxy\{closure} (line 373)
5	Symfony\Component\VarExporter\Internal\LazyObjectState::initialize (line 60)
6	Proxies\__CG__\App\Entity\Profesion->__get (line 153)
7	App\Entity\Profesion->getSiglas (line 87)
8	App\Entity\Junta->getAbrevHoras (line 99)
9	App\Entity\Actividad->getHorasAprobadasSiglasProfesion (line 299)
10	App\Controller\front\HomeController->actividad (line 95)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
13	Symfony\Component\HttpKernel\Kernel->handle (line 193)
14	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
15	require_once (line 29)
16	require_once (line 15)

0.49 ms
(12.34%)

SELECT t0.id AS id_1, t0.ajuste_horas AS ajuste_horas_2, t0.ajuste_precio AS ajuste_precio_3, t0.capacidad AS capacidad_4, t0.fecha AS fecha_5, t0.precio_especial AS precio_especial_6, t0.slug AS slug_7, t0.aprobacion_id AS aprobacion_id_8, t0.actividad_status_id AS actividad_status_id_9, t0.codigo_id AS codigo_id_10, t0.actividad_class_id AS actividad_class_id_11 FROM actividad t0 WHERE t0.id = ?

Parameters:

[
  "6"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.ajuste_horas AS ajuste_horas_2,
  t0.ajuste_precio AS ajuste_precio_3,
  t0.capacidad AS capacidad_4,
  t0.fecha AS fecha_5,
  t0.precio_especial AS precio_especial_6,
  t0.slug AS slug_7,
  t0.aprobacion_id AS aprobacion_id_8,
  t0.actividad_status_id AS actividad_status_id_9,
  t0.codigo_id AS codigo_id_10,
  t0.actividad_class_id AS actividad_class_id_11
FROM
  actividad t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.ajuste_horas AS ajuste_horas_2, t0.ajuste_precio AS ajuste_precio_3, t0.capacidad AS capacidad_4, t0.fecha AS fecha_5, t0.precio_especial AS precio_especial_6, t0.slug AS slug_7, t0.aprobacion_id AS aprobacion_id_8, t0.actividad_status_id AS actividad_status_id_9, t0.codigo_id AS codigo_id_10, t0.actividad_class_id AS actividad_class_id_11 FROM actividad t0 WHERE t0.id = '6';

#	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\ServiceEntityRepositoryProxy->find (line 61)
6	Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->find (line 129)
7	Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->resolve (line 69)
8	Symfony\Component\HttpKernel\Controller\ArgumentResolver\TraceableValueResolver->resolve (line 37)
9	Symfony\Component\HttpKernel\Controller\ArgumentResolver->getArguments (line 91)
10	Symfony\Component\HttpKernel\Controller\TraceableArgumentResolver->getArguments (line 33)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 175)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
13	Symfony\Component\HttpKernel\Kernel->handle (line 193)
14	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
15	require_once (line 29)
16	require_once (line 15)

0.43 ms
(10.73%)

SELECT t0.id AS id_1, t0.fecha_sometida AS fecha_sometida_2, t0.fecha_inicial AS fecha_inicial_3, t0.codigo_asignado AS codigo_asignado_4, t0.horas_sometidas AS horas_sometidas_5, t0.precio_regular AS precio_regular_6, t0.duracion AS duracion_7, t0.codigo_inicial AS codigo_inicial_8, t0.codigo_final AS codigo_final_9, t0.is_active AS is_active_10, t0.aprobacion_status AS aprobacion_status_11, t0.added_juntas AS added_juntas_12, t0.fecha_aprobada AS fecha_aprobada_13, t0.aprobacion_name_id AS aprobacion_name_id_14, t0.aprobacion_class_id AS aprobacion_class_id_15 FROM aprobacion t0 WHERE t0.id = ?

Parameters:

[
  8
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.fecha_sometida AS fecha_sometida_2,
  t0.fecha_inicial AS fecha_inicial_3,
  t0.codigo_asignado AS codigo_asignado_4,
  t0.horas_sometidas AS horas_sometidas_5,
  t0.precio_regular AS precio_regular_6,
  t0.duracion AS duracion_7,
  t0.codigo_inicial AS codigo_inicial_8,
  t0.codigo_final AS codigo_final_9,
  t0.is_active AS is_active_10,
  t0.aprobacion_status AS aprobacion_status_11,
  t0.added_juntas AS added_juntas_12,
  t0.fecha_aprobada AS fecha_aprobada_13,
  t0.aprobacion_name_id AS aprobacion_name_id_14,
  t0.aprobacion_class_id AS aprobacion_class_id_15
FROM
  aprobacion t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.fecha_sometida AS fecha_sometida_2, t0.fecha_inicial AS fecha_inicial_3, t0.codigo_asignado AS codigo_asignado_4, t0.horas_sometidas AS horas_sometidas_5, t0.precio_regular AS precio_regular_6, t0.duracion AS duracion_7, t0.codigo_inicial AS codigo_inicial_8, t0.codigo_final AS codigo_final_9, t0.is_active AS is_active_10, t0.aprobacion_status AS aprobacion_status_11, t0.added_juntas AS added_juntas_12, t0.fecha_aprobada AS fecha_aprobada_13, t0.aprobacion_name_id AS aprobacion_name_id_14, t0.aprobacion_class_id AS aprobacion_class_id_15 FROM aprobacion t0 WHERE t0.id = 8;

#	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->Doctrine\ORM\Proxy\{closure} (line 295)
4	Proxies\__CG__\App\Entity\Aprobacion::Doctrine\ORM\Proxy\{closure} (line 373)
5	Symfony\Component\VarExporter\Internal\LazyObjectState::initialize (line 60)
6	Proxies\__CG__\App\Entity\Aprobacion->__get (line 153)
7	App\Entity\Aprobacion->getAprobacionName (line 172)
8	App\Controller\front\HomeController->actividad (line 92)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
11	Symfony\Component\HttpKernel\Kernel->handle (line 193)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
13	require_once (line 29)
14	require_once (line 15)

0.34 ms
(8.54%)

SELECT t0.id AS id_1, t0.title AS title_2, t0.is_modulo AS is_modulo_3, t0.is_active AS is_active_4, t0.image_name AS image_name_5, t0.image_size AS image_size_6, t0.pdf_name AS pdf_name_7, t0.pdf_size AS pdf_size_8, t0.updated_at AS updated_at_9, t0.description AS description_10 FROM aprobacion_name t0 WHERE t0.id = ?

Parameters:

[
  9
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.is_modulo AS is_modulo_3,
  t0.is_active AS is_active_4,
  t0.image_name AS image_name_5,
  t0.image_size AS image_size_6,
  t0.pdf_name AS pdf_name_7,
  t0.pdf_size AS pdf_size_8,
  t0.updated_at AS updated_at_9,
  t0.description AS description_10
FROM
  aprobacion_name t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.is_modulo AS is_modulo_3, t0.is_active AS is_active_4, t0.image_name AS image_name_5, t0.image_size AS image_size_6, t0.pdf_name AS pdf_name_7, t0.pdf_size AS pdf_size_8, t0.updated_at AS updated_at_9, t0.description AS description_10 FROM aprobacion_name t0 WHERE t0.id = 9;

#	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->Doctrine\ORM\Proxy\{closure} (line 295)
4	Proxies\__CG__\App\Entity\AprobacionName::Doctrine\ORM\Proxy\{closure} (line 373)
5	Symfony\Component\VarExporter\Internal\LazyObjectState::initialize (line 60)
6	Proxies\__CG__\App\Entity\AprobacionName->__get (line 153)
7	App\Entity\AprobacionName->getImageName (line 156)
8	App\Controller\front\HomeController->actividad (line 92)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
11	Symfony\Component\HttpKernel\Kernel->handle (line 193)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
13	require_once (line 29)
14	require_once (line 15)

0.33 ms
(8.31%)

SELECT t0.id AS id_1, t0.horas_aprobadas AS horas_aprobadas_2, t0.fecha_aprobada AS fecha_aprobada_3, t0.fecha_sometida AS fecha_sometida_4, t0.fecha_no_aprobada AS fecha_no_aprobada_5, t0.horas_sometidas AS horas_sometidas_6, t0.horas_aprobadas_override AS horas_aprobadas_override_7, t0.aprobacion_id AS aprobacion_id_8, t0.profesion_id AS profesion_id_9, t0.junta_status_id AS junta_status_id_10 FROM junta t0 WHERE t0.aprobacion_id = ?

Parameters:

[
  8
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.horas_aprobadas AS horas_aprobadas_2,
  t0.fecha_aprobada AS fecha_aprobada_3,
  t0.fecha_sometida AS fecha_sometida_4,
  t0.fecha_no_aprobada AS fecha_no_aprobada_5,
  t0.horas_sometidas AS horas_sometidas_6,
  t0.horas_aprobadas_override AS horas_aprobadas_override_7,
  t0.aprobacion_id AS aprobacion_id_8,
  t0.profesion_id AS profesion_id_9,
  t0.junta_status_id AS junta_status_id_10
FROM
  junta t0
WHERE
  t0.aprobacion_id = ?

SELECT t0.id AS id_1, t0.horas_aprobadas AS horas_aprobadas_2, t0.fecha_aprobada AS fecha_aprobada_3, t0.fecha_sometida AS fecha_sometida_4, t0.fecha_no_aprobada AS fecha_no_aprobada_5, t0.horas_sometidas AS horas_sometidas_6, t0.horas_aprobadas_override AS horas_aprobadas_override_7, t0.aprobacion_id AS aprobacion_id_8, t0.profesion_id AS profesion_id_9, t0.junta_status_id AS junta_status_id_10 FROM junta t0 WHERE t0.aprobacion_id = 8;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1872)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 1817)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2729)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 315)
7	App\Entity\Actividad->getHorasAprobadasSiglasProfesion (line 297)
8	App\Controller\front\HomeController->actividad (line 95)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
11	Symfony\Component\HttpKernel\Kernel->handle (line 193)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
13	require_once (line 29)
14	require_once (line 15)

0.19 ms
(4.87%)

SELECT t0.id AS id_1, t0.status AS status_2, t0.orden AS orden_3, t0.label_color AS label_color_4 FROM actividad_status t0 WHERE t0.id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.status AS status_2,
  t0.orden AS orden_3,
  t0.label_color AS label_color_4
FROM
  actividad_status t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.status AS status_2, t0.orden AS orden_3, t0.label_color AS label_color_4 FROM actividad_status t0 WHERE t0.id = 1;

#	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->Doctrine\ORM\Proxy\{closure} (line 295)
4	Proxies\__CG__\App\Entity\ActividadStatus::Doctrine\ORM\Proxy\{closure} (line 373)
5	Symfony\Component\VarExporter\Internal\LazyObjectState::initialize (line 60)
6	Proxies\__CG__\App\Entity\ActividadStatus->__get (line 153)
7	App\Entity\ActividadStatus->__toString (line 81)
8	__TwigTemplate_2428cdc3159955d0312e9d0167ec11d9->block_body (line 155)
9	Twig\Template->yieldBlock (line 446)
10	__TwigTemplate_acef50fcd2ec0d9ed15af408d0a8a598->doDisplay (line 142)
11	Twig\Template->yield (line 402)
12	__TwigTemplate_2428cdc3159955d0312e9d0167ec11d9->doDisplay (line 56)
13	Twig\Template->yield (line 402)
14	Twig\Template->display (line 358)
15	Twig\Template->render (line 373)
16	Twig\TemplateWrapper->render (line 51)
17	Twig\Environment->render (line 333)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 463)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 468)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 282)
21	App\Controller\front\HomeController->actividad (line 97)
22	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
23	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
24	Symfony\Component\HttpKernel\Kernel->handle (line 193)
25	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
26	require_once (line 29)
27	require_once (line 15)

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\Junta	21
App\Entity\Profesion	21
App\Entity\Actividad	1
App\Entity\Aprobacion	1
App\Entity\ActividadStatus	1
App\Entity\Codigo	1
App\Entity\AprobacionName	1
App\Entity\JuntaStatus	1

Entities Mapping

Class	Mapping errors
App\Entity\Actividad	No errors.
App\Entity\Aprobacion	No errors.
App\Entity\ActividadStatus	No errors.
App\Entity\Codigo	No errors.
App\Entity\ActividadClass	No errors.
App\Entity\Seccion	No errors.
App\Entity\Matricula	No errors.
App\Entity\AprobacionName	No errors.
App\Entity\AprobacionClass	No errors.
App\Entity\Junta	No errors.
App\Entity\Profesion	No errors.
App\Entity\JuntaStatus	No errors.
App\Entity\UserProfesion	No errors.

Symfony Profiler

GET https://previadmin.computechapps.com/actividad/6

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping