Symfony Profiler

Query Metrics

2 Database Queries

2 Different statements

1.20 ms Query time

1 Invalid entities

31 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

0.84 ms
(70.31%)

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, a2_.id AS id_16, a2_.aprobacion AS aprobacion_17, a2_.is_modulo AS is_modulo_18, a2_.is_active AS is_active_19, a3_.id AS id_20, a3_.status AS status_21, a3_.orden AS orden_22, a3_.label_color AS label_color_23, j4_.id AS id_24, j4_.horas_aprobadas AS horas_aprobadas_25, j4_.fecha_aprobada AS fecha_aprobada_26, p5_.id AS id_27, p5_.profesion AS profesion_28, p5_.siglas AS siglas_29, p5_.codigo_profesion AS codigo_profesion_30, p5_.horas_requeridas_total AS horas_requeridas_total_31, p5_.horas_requeridas_presencial AS horas_requeridas_presencial_32, p5_.is_default AS is_default_33, p5_.is_featured AS is_featured_34, p5_.slug AS slug_35, a0_.aprobacion_id AS aprobacion_id_36, a0_.actividad_status_id AS actividad_status_id_37, a0_.codigo_id AS codigo_id_38, a1_.aprobacion_name_id AS aprobacion_name_id_39, j4_.aprobacion_id AS aprobacion_id_40, j4_.profesion_id AS profesion_id_41, j4_.junta_status_id AS junta_status_id_42 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 ORDER BY a0_.fecha ASC, a2_.aprobacion ASC

Parameters:

[
  "2025-11-08 08:41:16"
]

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,
  a2_.id AS id_16,
  a2_.aprobacion AS aprobacion_17,
  a2_.is_modulo AS is_modulo_18,
  a2_.is_active AS is_active_19,
  a3_.id AS id_20,
  a3_.status AS status_21,
  a3_.orden AS orden_22,
  a3_.label_color AS label_color_23,
  j4_.id AS id_24,
  j4_.horas_aprobadas AS horas_aprobadas_25,
  j4_.fecha_aprobada AS fecha_aprobada_26,
  p5_.id AS id_27,
  p5_.profesion AS profesion_28,
  p5_.siglas AS siglas_29,
  p5_.codigo_profesion AS codigo_profesion_30,
  p5_.horas_requeridas_total AS horas_requeridas_total_31,
  p5_.horas_requeridas_presencial AS horas_requeridas_presencial_32,
  p5_.is_default AS is_default_33,
  p5_.is_featured AS is_featured_34,
  p5_.slug AS slug_35,
  a0_.aprobacion_id AS aprobacion_id_36,
  a0_.actividad_status_id AS actividad_status_id_37,
  a0_.codigo_id AS codigo_id_38,
  a1_.aprobacion_name_id AS aprobacion_name_id_39,
  j4_.aprobacion_id AS aprobacion_id_40,
  j4_.profesion_id AS profesion_id_41,
  j4_.junta_status_id AS junta_status_id_42
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
ORDER BY
  a0_.fecha ASC,
  a2_.aprobacion 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, a2_.id AS id_16, a2_.aprobacion AS aprobacion_17, a2_.is_modulo AS is_modulo_18, a2_.is_active AS is_active_19, a3_.id AS id_20, a3_.status AS status_21, a3_.orden AS orden_22, a3_.label_color AS label_color_23, j4_.id AS id_24, j4_.horas_aprobadas AS horas_aprobadas_25, j4_.fecha_aprobada AS fecha_aprobada_26, p5_.id AS id_27, p5_.profesion AS profesion_28, p5_.siglas AS siglas_29, p5_.codigo_profesion AS codigo_profesion_30, p5_.horas_requeridas_total AS horas_requeridas_total_31, p5_.horas_requeridas_presencial AS horas_requeridas_presencial_32, p5_.is_default AS is_default_33, p5_.is_featured AS is_featured_34, p5_.slug AS slug_35, a0_.aprobacion_id AS aprobacion_id_36, a0_.actividad_status_id AS actividad_status_id_37, a0_.codigo_id AS codigo_id_38, a1_.aprobacion_name_id AS aprobacion_name_id_39, j4_.aprobacion_id AS aprobacion_id_40, j4_.profesion_id AS profesion_id_41, j4_.junta_status_id AS junta_status_id_42 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-11-08 08:41:16' AND j4_.horas_aprobadas > 0 ORDER BY a0_.fecha ASC, a2_.aprobacion 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 58)
7	App\Repository\ActividadRepository->findActividadesFuturasParaProfesion (line 135)
8	App\Controller\ProfesionController->show (line 52)
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.36 ms
(29.69%)

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.id = ?

Parameters:

[
  "24"
]

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.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 FROM profesion t0 WHERE t0.id = '24';

#	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 182)
14	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
15	require_once (line 29)
16	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\Junta	9
App\Entity\Actividad	7
App\Entity\Profesion	5
App\Entity\Aprobacion	4
App\Entity\AprobacionName	4
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\JuntaStatus	No errors.
App\Entity\Seccion	No errors.
App\Entity\Matricula	The mappings App\Entity\Matricula#cartItem and App\Entity\CartItem#matriculas are inconsistent with each other.

Symfony Profiler

GET https://previadmin.computechapps.com/profesion/24

Configuration Settings

Theme

Page Width