Symfony Profiler

Query Metrics

3 Database Queries

3 Different statements

2.46 ms Query time

0 Invalid entities

93 Managed entities

Queries

Group similar statements

#▲

Time

Info

0.71 ms

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 FROM profesion t0 WHERE t0.slug = ? LIMIT 1

Parameters:

[
  "tecnologo-medico"
]

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
FROM
  profesion t0
WHERE
  t0.slug = ?
LIMIT
  1

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 FROM profesion t0 WHERE t0.slug = 'tecnologo-medico' 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\ServiceEntityRepositoryProxy->findOneBy (line 81)
4	App\Controller\CalendarioActividadController->fetch (line 42)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
7	Symfony\Component\HttpKernel\Kernel->handle (line 182)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
9	require_once (line 29)
10	require_once (line 5)

1.22 ms

SELECT a0_.id AS id_0, a0_.ajuste_horas AS ajuste_horas_1, a0_.ajuste_precio AS ajuste_precio_2, a0_.capacidad AS capacidad_3, a0_.fecha AS fecha_4, a0_.precio_especial AS precio_especial_5, a1_.id AS id_6, a1_.fecha_sometida AS fecha_sometida_7, a1_.fecha_inicial AS fecha_inicial_8, a1_.codigo_asignado AS codigo_asignado_9, a1_.horas_sometidas AS horas_sometidas_10, a1_.precio_regular AS precio_regular_11, a1_.duracion AS duracion_12, a1_.codigo_inicial AS codigo_inicial_13, a1_.codigo_final AS codigo_final_14, a1_.is_active AS is_active_15, a1_.added_juntas AS added_juntas_16, a2_.id AS id_17, a2_.title AS title_18, a2_.is_modulo AS is_modulo_19, a2_.is_active AS is_active_20, a2_.image_name AS image_name_21, a2_.image_size AS image_size_22, a2_.updated_at AS updated_at_23, a3_.id AS id_24, a3_.status AS status_25, a3_.orden AS orden_26, a3_.label_color AS label_color_27, j4_.id AS id_28, j4_.horas_aprobadas AS horas_aprobadas_29, j4_.fecha_aprobada AS fecha_aprobada_30, p5_.id AS id_31, p5_.profesion AS profesion_32, p5_.siglas AS siglas_33, p5_.codigo_profesion AS codigo_profesion_34, p5_.horas_requeridas_total AS horas_requeridas_total_35, p5_.horas_requeridas_presencial AS horas_requeridas_presencial_36, p5_.is_default AS is_default_37, p5_.is_featured AS is_featured_38, p5_.slug AS slug_39, a0_.aprobacion_id AS aprobacion_id_40, a0_.actividad_status_id AS actividad_status_id_41, a0_.codigo_id AS codigo_id_42, a1_.aprobacion_name_id AS aprobacion_name_id_43, a1_.aprobacion_status_id AS aprobacion_status_id_44, a1_.aprobacion_class_id AS aprobacion_class_id_45, j4_.aprobacion_id AS aprobacion_id_46, j4_.profesion_id AS profesion_id_47, j4_.junta_status_id AS junta_status_id_48 FROM actividad a0_ LEFT JOIN aprobacion a1_ ON a0_.aprobacion_id = a1_.id LEFT JOIN aprobacion_name a2_ ON a1_.aprobacion_name_id = a2_.id LEFT JOIN actividad_status a3_ ON a0_.actividad_status_id = a3_.id LEFT JOIN junta j4_ ON a1_.id = j4_.aprobacion_id LEFT JOIN profesion p5_ ON j4_.profesion_id = p5_.id WHERE a0_.fecha > ? AND j4_.horas_aprobadas > 0 AND j4_.junta_status_id = 3 ORDER BY a0_.fecha ASC, a2_.title ASC

Parameters:

[
  "2025-12-08 15:30:11"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  a0_.id AS id_0,
  a0_.ajuste_horas AS ajuste_horas_1,
  a0_.ajuste_precio AS ajuste_precio_2,
  a0_.capacidad AS capacidad_3,
  a0_.fecha AS fecha_4,
  a0_.precio_especial AS precio_especial_5,
  a1_.id AS id_6,
  a1_.fecha_sometida AS fecha_sometida_7,
  a1_.fecha_inicial AS fecha_inicial_8,
  a1_.codigo_asignado AS codigo_asignado_9,
  a1_.horas_sometidas AS horas_sometidas_10,
  a1_.precio_regular AS precio_regular_11,
  a1_.duracion AS duracion_12,
  a1_.codigo_inicial AS codigo_inicial_13,
  a1_.codigo_final AS codigo_final_14,
  a1_.is_active AS is_active_15,
  a1_.added_juntas AS added_juntas_16,
  a2_.id AS id_17,
  a2_.title AS title_18,
  a2_.is_modulo AS is_modulo_19,
  a2_.is_active AS is_active_20,
  a2_.image_name AS image_name_21,
  a2_.image_size AS image_size_22,
  a2_.updated_at AS updated_at_23,
  a3_.id AS id_24,
  a3_.status AS status_25,
  a3_.orden AS orden_26,
  a3_.label_color AS label_color_27,
  j4_.id AS id_28,
  j4_.horas_aprobadas AS horas_aprobadas_29,
  j4_.fecha_aprobada AS fecha_aprobada_30,
  p5_.id AS id_31,
  p5_.profesion AS profesion_32,
  p5_.siglas AS siglas_33,
  p5_.codigo_profesion AS codigo_profesion_34,
  p5_.horas_requeridas_total AS horas_requeridas_total_35,
  p5_.horas_requeridas_presencial AS horas_requeridas_presencial_36,
  p5_.is_default AS is_default_37,
  p5_.is_featured AS is_featured_38,
  p5_.slug AS slug_39,
  a0_.aprobacion_id AS aprobacion_id_40,
  a0_.actividad_status_id AS actividad_status_id_41,
  a0_.codigo_id AS codigo_id_42,
  a1_.aprobacion_name_id AS aprobacion_name_id_43,
  a1_.aprobacion_status_id AS aprobacion_status_id_44,
  a1_.aprobacion_class_id AS aprobacion_class_id_45,
  j4_.aprobacion_id AS aprobacion_id_46,
  j4_.profesion_id AS profesion_id_47,
  j4_.junta_status_id AS junta_status_id_48
FROM
  actividad a0_
  LEFT JOIN aprobacion a1_ ON a0_.aprobacion_id = a1_.id
  LEFT JOIN aprobacion_name a2_ ON a1_.aprobacion_name_id = a2_.id
  LEFT JOIN actividad_status a3_ ON a0_.actividad_status_id = a3_.id
  LEFT JOIN junta j4_ ON a1_.id = j4_.aprobacion_id
  LEFT JOIN profesion p5_ ON j4_.profesion_id = p5_.id
WHERE
  a0_.fecha > ?
  AND j4_.horas_aprobadas > 0
  AND j4_.junta_status_id = 3
ORDER BY
  a0_.fecha ASC,
  a2_.title ASC

SELECT a0_.id AS id_0, a0_.ajuste_horas AS ajuste_horas_1, a0_.ajuste_precio AS ajuste_precio_2, a0_.capacidad AS capacidad_3, a0_.fecha AS fecha_4, a0_.precio_especial AS precio_especial_5, a1_.id AS id_6, a1_.fecha_sometida AS fecha_sometida_7, a1_.fecha_inicial AS fecha_inicial_8, a1_.codigo_asignado AS codigo_asignado_9, a1_.horas_sometidas AS horas_sometidas_10, a1_.precio_regular AS precio_regular_11, a1_.duracion AS duracion_12, a1_.codigo_inicial AS codigo_inicial_13, a1_.codigo_final AS codigo_final_14, a1_.is_active AS is_active_15, a1_.added_juntas AS added_juntas_16, a2_.id AS id_17, a2_.title AS title_18, a2_.is_modulo AS is_modulo_19, a2_.is_active AS is_active_20, a2_.image_name AS image_name_21, a2_.image_size AS image_size_22, a2_.updated_at AS updated_at_23, a3_.id AS id_24, a3_.status AS status_25, a3_.orden AS orden_26, a3_.label_color AS label_color_27, j4_.id AS id_28, j4_.horas_aprobadas AS horas_aprobadas_29, j4_.fecha_aprobada AS fecha_aprobada_30, p5_.id AS id_31, p5_.profesion AS profesion_32, p5_.siglas AS siglas_33, p5_.codigo_profesion AS codigo_profesion_34, p5_.horas_requeridas_total AS horas_requeridas_total_35, p5_.horas_requeridas_presencial AS horas_requeridas_presencial_36, p5_.is_default AS is_default_37, p5_.is_featured AS is_featured_38, p5_.slug AS slug_39, a0_.aprobacion_id AS aprobacion_id_40, a0_.actividad_status_id AS actividad_status_id_41, a0_.codigo_id AS codigo_id_42, a1_.aprobacion_name_id AS aprobacion_name_id_43, a1_.aprobacion_status_id AS aprobacion_status_id_44, a1_.aprobacion_class_id AS aprobacion_class_id_45, j4_.aprobacion_id AS aprobacion_id_46, j4_.profesion_id AS profesion_id_47, j4_.junta_status_id AS junta_status_id_48 FROM actividad a0_ LEFT JOIN aprobacion a1_ ON a0_.aprobacion_id = a1_.id LEFT JOIN aprobacion_name a2_ ON a1_.aprobacion_name_id = a2_.id LEFT JOIN actividad_status a3_ ON a0_.actividad_status_id = a3_.id LEFT JOIN junta j4_ ON a1_.id = j4_.aprobacion_id LEFT JOIN profesion p5_ ON j4_.profesion_id = p5_.id WHERE a0_.fecha > '2025-12-08 15:30:11' AND j4_.horas_aprobadas > 0 AND j4_.junta_status_id = 3 ORDER BY a0_.fecha ASC, a2_.title 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->getResult (line 688)
6	App\Repository\ActividadRepository->actividadesFuturasQuery (line 59)
7	App\Repository\ActividadRepository->findActividadesFuturasParaProfesion (line 124)
8	App\Controller\CalendarioActividadController->fetch (line 43)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
11	Symfony\Component\HttpKernel\Kernel->handle (line 182)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
13	require_once (line 29)
14	require_once (line 5)

0.53 ms

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 FROM profesion t0 WHERE t0.is_default = ? ORDER BY t0.profesion ASC

Parameters:

[
  1
]

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
FROM
  profesion t0
WHERE
  t0.is_default = ?
ORDER BY
  t0.profesion ASC

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 FROM profesion t0 WHERE t0.is_default = 1 ORDER BY t0.profesion ASC;

#	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	App\Controller\CalendarioActividadController->fetch (line 49)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
7	Symfony\Component\HttpKernel\Kernel->handle (line 182)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
9	require_once (line 29)
10	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\Profesion	44
App\Entity\Junta	25
App\Entity\Actividad	7
App\Entity\Codigo	7
App\Entity\Aprobacion	3
App\Entity\AprobacionName	3
App\Entity\AprobacionStatus	2
App\Entity\ActividadStatus	1
App\Entity\JuntaStatus	1

Entities Mapping

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

Symfony Profiler

GET https://previmed.computechapps.com/calendario/actividad/tecnologo-medico

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping