Symfony Profiler

Query Metrics

8 Database Queries

4 Different statements

3.70 ms Query time

0 Invalid entities

33 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

1.13 ms
(30.47%)

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.added_juntas AS added_juntas_11, t0.aprobacion_name_id AS aprobacion_name_id_12, t0.aprobacion_status_id AS aprobacion_status_id_13, t0.aprobacion_class_id AS aprobacion_class_id_14 FROM aprobacion t0 WHERE t0.id = ?

Parameters:

[
  1
]

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.added_juntas AS added_juntas_11,
  t0.aprobacion_name_id AS aprobacion_name_id_12,
  t0.aprobacion_status_id AS aprobacion_status_id_13,
  t0.aprobacion_class_id AS aprobacion_class_id_14
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.added_juntas AS added_juntas_11, t0.aprobacion_name_id AS aprobacion_name_id_12, t0.aprobacion_status_id AS aprobacion_status_id_13, t0.aprobacion_class_id AS aprobacion_class_id_14 FROM aprobacion 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 289)
4	Proxies\__CG__\App\Entity\Aprobacion::Doctrine\ORM\Proxy\{closure} (line 367)
5	Symfony\Component\VarExporter\Internal\LazyObjectState::initialize (line 60)
6	Proxies\__CG__\App\Entity\Aprobacion->__get (line 153)
7	App\Entity\Aprobacion->getAprobacionName (line 162)
8	Twig\Extension\CoreExtension->getAttribute (line 1913)
9	__TwigTemplate_d17b811bd2f7e65554f562592fe7d743::doDisplay (line 54)
10	Twig\Template->yield (line 402)
11	__TwigTemplate_8e06f4c7cec68764380142788d45fa13->doDisplay (line 78)
12	Twig\Template->yield (line 402)
13	__TwigTemplate_22c08551e7a977882e2d93ebfe8e113b->block_body (line 94)
14	Twig\Template->yieldBlock (line 446)
15	__TwigTemplate_008481250c00b0afdae6284f0ae84645->doDisplay (line 127)
16	Twig\Template->yield (line 402)
17	__TwigTemplate_22c08551e7a977882e2d93ebfe8e113b->doDisplay (line 53)
18	Twig\Template->yield (line 402)
19	Twig\Template->display (line 358)
20	Twig\Template->render (line 373)
21	Twig\TemplateWrapper->render (line 51)
22	Twig\Environment->render (line 333)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 459)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 464)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 278)
26	App\Controller\HomeController->index (line 43)
27	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
28	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
29	Symfony\Component\HttpKernel\Kernel->handle (line 182)
30	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
31	require_once (line 29)
32	require_once (line 5)

1.09 ms
(29.42%)

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.aprobacion_id AS aprobacion_id_7, t0.actividad_status_id AS actividad_status_id_8, t0.codigo_id AS codigo_id_9 FROM actividad t0

Parameters:

[]

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.aprobacion_id AS aprobacion_id_7,
  t0.actividad_status_id AS actividad_status_id_8,
  t0.codigo_id AS codigo_id_9
FROM
  actividad t0

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.aprobacion_id AS aprobacion_id_7, t0.actividad_status_id AS actividad_status_id_8, t0.codigo_id AS codigo_id_9 FROM actividad t0;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 963)
2	Doctrine\ORM\EntityRepository->findBy (line 110)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 73)
4	Doctrine\ORM\EntityRepository->findAll (line 96)
5	App\Controller\HomeController->fetchFeaturedActividades (line 90)
6	App\Controller\HomeController->index (line 40)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
9	Symfony\Component\HttpKernel\Kernel->handle (line 182)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
11	require_once (line 29)
12	require_once (line 5)

0.84 ms
(22.60%)

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.updated_at AS updated_at_7 FROM aprobacion_name t0 WHERE t0.id = ?

Parameters:

[
  2
]

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.updated_at AS updated_at_7
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.updated_at AS updated_at_7 FROM aprobacion_name t0 WHERE t0.id = 2;

#	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 289)
4	Proxies\__CG__\App\Entity\AprobacionName::Doctrine\ORM\Proxy\{closure} (line 367)
5	Symfony\Component\VarExporter\Internal\LazyObjectState::initialize (line 60)
6	Proxies\__CG__\App\Entity\AprobacionName->__get (line 153)
7	App\Entity\AprobacionName->getImageName (line 143)
8	Twig\Extension\CoreExtension->getAttribute (line 1913)
9	__TwigTemplate_d17b811bd2f7e65554f562592fe7d743::doDisplay (line 54)
10	Twig\Template->yield (line 402)
11	__TwigTemplate_8e06f4c7cec68764380142788d45fa13->doDisplay (line 78)
12	Twig\Template->yield (line 402)
13	__TwigTemplate_22c08551e7a977882e2d93ebfe8e113b->block_body (line 94)
14	Twig\Template->yieldBlock (line 446)
15	__TwigTemplate_008481250c00b0afdae6284f0ae84645->doDisplay (line 127)
16	Twig\Template->yield (line 402)
17	__TwigTemplate_22c08551e7a977882e2d93ebfe8e113b->doDisplay (line 53)
18	Twig\Template->yield (line 402)
19	Twig\Template->display (line 358)
20	Twig\Template->render (line 373)
21	Twig\TemplateWrapper->render (line 51)
22	Twig\Environment->render (line 333)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 459)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 464)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 278)
26	App\Controller\HomeController->index (line 43)
27	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
28	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
29	Symfony\Component\HttpKernel\Kernel->handle (line 182)
30	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
31	require_once (line 29)
32	require_once (line 5)

0.65 ms
(17.51%)

SELECT p0_.id AS id_0, p0_.profesion AS profesion_1, p0_.siglas AS siglas_2, p0_.codigo_profesion AS codigo_profesion_3, p0_.horas_requeridas_total AS horas_requeridas_total_4, p0_.horas_requeridas_presencial AS horas_requeridas_presencial_5, p0_.is_default AS is_default_6, p0_.is_featured AS is_featured_7, p0_.slug AS slug_8 FROM profesion p0_ WHERE p0_.is_featured = ? ORDER BY p0_.profesion ASC LIMIT 6

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.id AS id_0,
  p0_.profesion AS profesion_1,
  p0_.siglas AS siglas_2,
  p0_.codigo_profesion AS codigo_profesion_3,
  p0_.horas_requeridas_total AS horas_requeridas_total_4,
  p0_.horas_requeridas_presencial AS horas_requeridas_presencial_5,
  p0_.is_default AS is_default_6,
  p0_.is_featured AS is_featured_7,
  p0_.slug AS slug_8
FROM
  profesion p0_
WHERE
  p0_.is_featured = ?
ORDER BY
  p0_.profesion ASC
LIMIT
  6

SELECT p0_.id AS id_0, p0_.profesion AS profesion_1, p0_.siglas AS siglas_2, p0_.codigo_profesion AS codigo_profesion_3, p0_.horas_requeridas_total AS horas_requeridas_total_4, p0_.horas_requeridas_presencial AS horas_requeridas_presencial_5, p0_.is_default AS is_default_6, p0_.is_featured AS is_featured_7, p0_.slug AS slug_8 FROM profesion p0_ WHERE p0_.is_featured = 1 ORDER BY p0_.profesion ASC LIMIT 6;

#	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->getResult (line 688)
6	App\Repository\ProfesionRepository->findFeatured (line 30)
7	App\Controller\HomeController->index (line 41)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 182)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
12	require_once (line 29)
13	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\Actividad	9
App\Entity\Codigo	9
App\Entity\Profesion	6
App\Entity\Aprobacion	3
App\Entity\AprobacionName	3
App\Entity\AprobacionStatus	2
App\Entity\ActividadStatus	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\Seccion	No errors.
App\Entity\Matricula	No errors.
App\Entity\Profesion	No errors.
App\Entity\UserProfesion	No errors.
App\Entity\Junta	No errors.
App\Entity\AprobacionName	No errors.
App\Entity\AprobacionStatus	No errors.
App\Entity\AprobacionClass	No errors.

Symfony Profiler

GET https://previmed.computechapps.com/

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping