GET https://previadmin.computechapps.com/calendario/farmacia-auxiliar

Query Metrics

4 Database Queries
4 Different statements
3.30 ms Query time
0 Invalid entities
94 Managed entities

Grouped Statements

Show all queries

Time Count Info
1.51 ms
(45.90%)
1
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, a0_.slug AS slug_6, a1_.id AS id_7, a1_.fecha_sometida AS fecha_sometida_8, a1_.fecha_inicial AS fecha_inicial_9, a1_.codigo_asignado AS codigo_asignado_10, a1_.horas_sometidas AS horas_sometidas_11, a1_.precio_regular AS precio_regular_12, a1_.duracion AS duracion_13, a1_.codigo_inicial AS codigo_inicial_14, a1_.codigo_final AS codigo_final_15, a1_.is_active AS is_active_16, a1_.aprobacion_status AS aprobacion_status_17, a1_.added_juntas AS added_juntas_18, a1_.fecha_aprobada AS fecha_aprobada_19, a2_.id AS id_20, a2_.title AS title_21, a2_.is_modulo AS is_modulo_22, a2_.is_active AS is_active_23, a2_.image_name AS image_name_24, a2_.image_size AS image_size_25, a2_.pdf_name AS pdf_name_26, a2_.pdf_size AS pdf_size_27, a2_.updated_at AS updated_at_28, a2_.description AS description_29, a3_.id AS id_30, a3_.status AS status_31, a3_.orden AS orden_32, a3_.label_color AS label_color_33, j4_.id AS id_34, j4_.horas_aprobadas AS horas_aprobadas_35, j4_.fecha_aprobada AS fecha_aprobada_36, j4_.fecha_sometida AS fecha_sometida_37, j4_.fecha_no_aprobada AS fecha_no_aprobada_38, j4_.horas_sometidas AS horas_sometidas_39, j4_.horas_aprobadas_override AS horas_aprobadas_override_40, p5_.id AS id_41, p5_.profesion AS profesion_42, p5_.siglas AS siglas_43, p5_.codigo_profesion AS codigo_profesion_44, p5_.horas_requeridas_total AS horas_requeridas_total_45, p5_.horas_requeridas_presencial AS horas_requeridas_presencial_46, p5_.is_default AS is_default_47, p5_.is_featured AS is_featured_48, p5_.slug AS slug_49, p5_.is_public AS is_public_50, p5_.icon AS icon_51, a0_.aprobacion_id AS aprobacion_id_52, a0_.actividad_status_id AS actividad_status_id_53, a0_.codigo_id AS codigo_id_54, a0_.actividad_class_id AS actividad_class_id_55, a1_.aprobacion_name_id AS aprobacion_name_id_56, a1_.aprobacion_class_id AS aprobacion_class_id_57, j4_.aprobacion_id AS aprobacion_id_58, j4_.profesion_id AS profesion_id_59, j4_.junta_status_id AS junta_status_id_60 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:
[
  "2026-02-25 14:23:42"
]
0.67 ms
(20.28%)
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, t0.is_public AS is_public_10, t0.icon AS icon_11 FROM profesion t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
  "farmacia-auxiliar"
]
0.63 ms
(19.01%)
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, t0.is_public AS is_public_10, t0.icon AS icon_11 FROM profesion t0 WHERE t0.is_default = ? ORDER BY t0.profesion ASC
Parameters:
[
  1
]
0.49 ms
(14.80%)
1
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, p0_.is_public AS is_public_9, p0_.icon AS icon_10 FROM profesion p0_ WHERE p0_.id NOT IN (?, ?) ORDER BY p0_.profesion ASC
Parameters:
[
  1
  55
]

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 49
App\Entity\Junta 23
App\Entity\Actividad 6
App\Entity\Codigo 6
App\Entity\Aprobacion 4
App\Entity\AprobacionName 4
App\Entity\ActividadStatus 1
App\Entity\JuntaStatus 1

Entities Mapping