Query Metrics
494
Database Queries
19
Different statements
75.95 ms
Query time
6
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
26.60 ms (35.02%) |
1 |
"COMMIT"
Parameters:
[] |
|
11.25 ms (14.81%) |
119 |
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.apellido AS apellido_3, t0.identificacion AS identificacion_4, t0.email AS email_5, t0.telefono AS telefono_6, t0.deleted_at AS deleted_at_7, t0.cuil AS cuil_8, t0.fecha_nacimiento AS fecha_nacimiento_9, t0.cbu_alias AS cbu_alias_10, t0.numero_cuenta AS numero_cuenta_11, t0.estado_civil_id AS estado_civil_id_12, t0.genero_id AS genero_id_13, t0.domicilio_id AS domicilio_id_14, t0.constancia_cbu_id AS constancia_cbu_id_15 FROM persona t0 WHERE t0.id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
14
]
|
|
11.02 ms (14.51%) |
117 |
SELECT t0.username AS username_1, t0.username_canonical AS username_canonical_2, t0.email AS email_3, t0.email_canonical AS email_canonical_4, t0.enabled AS enabled_5, t0.salt AS salt_6, t0.password AS password_7, t0.last_login AS last_login_8, t0.confirmation_token AS confirmation_token_9, t0.password_requested_at AS password_requested_at_10, t0.roles AS roles_11, t0.id AS id_12, t0.createdAt AS createdAt_13, t0.agente_id AS agente_id_14, t0.sistema_id AS sistema_id_15 FROM user t0 WHERE t0.agente_id = ?
Parameters:
[
13
]
|
|
10.35 ms (13.63%) |
117 |
SELECT t0.id AS id_1, t0.fecha_turno AS fecha_turno_2, t0.numero AS numero_3, t0.deleted_at AS deleted_at_4, t0.apto_id AS apto_id_5, t0.estado_id AS estado_id_6, t0.agente_id AS agente_id_7 FROM carpeta_medica t0 WHERE t0.agente_id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
13
]
|
|
9.59 ms (12.63%) |
117 |
SELECT t0.id AS id_1, t0.fecha AS fecha_2, t0.descripcion AS descripcion_3, t0.agente_id AS agente_id_4, t0.motivo_id AS motivo_id_5 FROM agente_baja t0 WHERE t0.agente_id = ?
Parameters:
[
13
]
|
|
1.15 ms (1.52%) |
6 |
SELECT s0_.id AS id_0, s0_.descripcion AS descripcion_1, s0_.email AS email_2, s0_.planilla_enfermeria AS planilla_enfermeria_3, s0_.responsable_id AS responsable_id_4 FROM servicio s0_ WHERE s0_.planilla_enfermeria = ? ORDER BY s0_.descripcion ASC
Parameters:
[
1
]
|
|
0.73 ms (0.96%) |
2 |
SELECT t0.id AS id_1, t0.codigo AS codigo_2, t0.fecha_ingreso AS fecha_ingreso_3, t0.deleted_at AS deleted_at_4, t0.movilidad_horaria AS movilidad_horaria_5, t0.fecha_planta AS fecha_planta_6, t0.mayor_jornada AS mayor_jornada_7, t0.saldo_horas_extras AS saldo_horas_extras_8, t0.horas_dia AS horas_dia_9, t0.fecha_antiguedad AS fecha_antiguedad_10, t0.control_planilla AS control_planilla_11, t0.cuidados_intensivos AS cuidados_intensivos_12, t0.activo AS activo_13, t0.saldo_lao AS saldo_lao_14, t0.guardia_activa AS guardia_activa_15, t0.carga_horaria AS carga_horaria_16, t0.excluir_reparto AS excluir_reparto_17, t0.log_view AS log_view_18, t0.persona_id AS persona_id_19, t20.id AS id_21, t20.fecha_turno AS fecha_turno_22, t20.numero AS numero_23, t20.deleted_at AS deleted_at_24, t20.apto_id AS apto_id_25, t20.estado_id AS estado_id_26, t20.agente_id AS agente_id_27, t0.ccategoria_id AS ccategoria_id_28, t0.funcion_id AS funcion_id_29, t0.escalafon_id AS escalafon_id_30, t0.revista_id AS revista_id_31, t0.tarea_id AS tarea_id_32, t0.subservicio_id AS subservicio_id_33, t0.categoria_id AS categoria_id_34, t35.username AS username_36, t35.username_canonical AS username_canonical_37, t35.email AS email_38, t35.email_canonical AS email_canonical_39, t35.enabled AS enabled_40, t35.salt AS salt_41, t35.password AS password_42, t35.last_login AS last_login_43, t35.confirmation_token AS confirmation_token_44, t35.password_requested_at AS password_requested_at_45, t35.roles AS roles_46, t35.id AS id_47, t35.createdAt AS createdAt_48, t35.agente_id AS agente_id_49, t35.sistema_id AS sistema_id_50, t51.id AS id_52, t51.fecha AS fecha_53, t51.descripcion AS descripcion_54, t51.agente_id AS agente_id_55, t51.motivo_id AS motivo_id_56 FROM agente t0 LEFT JOIN carpeta_medica t20 ON t20.agente_id = t0.id AND ((t20.deleted_at IS NULL)) LEFT JOIN user t35 ON t35.agente_id = t0.id LEFT JOIN agente_baja t51 ON t51.agente_id = t0.id WHERE t0.id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
325
]
|
|
0.64 ms (0.84%) |
1 |
SELECT a0_.id AS id_0, a0_.fecha_inicio AS fecha_inicio_1, a0_.fecha_fin AS fecha_fin_2, a0_.franja AS franja_3, a0_.activo AS activo_4, a0_.observaciones AS observaciones_5, a0_.created_at AS created_at_6, a0_.planilla_id AS planilla_id_7, a0_.agente_id AS agente_id_8, a0_.creado_por_id AS creado_por_id_9 FROM asignacion_horario_enfermeria a0_ WHERE a0_.planilla_id = ? AND a0_.agente_id = ? AND a0_.activo = 1 AND a0_.fecha_inicio < ? AND a0_.fecha_fin > ? AND ((a0_.franja IS NULL OR a0_.franja <> ?)) ORDER BY a0_.fecha_inicio ASC
Parameters:
[ 18 500 "2026-11-06 12:00:00" "2026-11-06 06:00:00" "pasiva" ] |
|
0.61 ms (0.80%) |
1 |
SELECT a0_.id AS id_0, a0_.codigo AS codigo_1, a0_.fecha_ingreso AS fecha_ingreso_2, a0_.deleted_at AS deleted_at_3, a0_.movilidad_horaria AS movilidad_horaria_4, a0_.fecha_planta AS fecha_planta_5, a0_.mayor_jornada AS mayor_jornada_6, a0_.saldo_horas_extras AS saldo_horas_extras_7, a0_.horas_dia AS horas_dia_8, a0_.fecha_antiguedad AS fecha_antiguedad_9, a0_.control_planilla AS control_planilla_10, a0_.cuidados_intensivos AS cuidados_intensivos_11, a0_.activo AS activo_12, a0_.saldo_lao AS saldo_lao_13, a0_.guardia_activa AS guardia_activa_14, a0_.carga_horaria AS carga_horaria_15, a0_.excluir_reparto AS excluir_reparto_16, a0_.log_view AS log_view_17, a0_.persona_id AS persona_id_18, a0_.ccategoria_id AS ccategoria_id_19, a0_.funcion_id AS funcion_id_20, a0_.escalafon_id AS escalafon_id_21, a0_.revista_id AS revista_id_22, a0_.tarea_id AS tarea_id_23, a0_.subservicio_id AS subservicio_id_24, a0_.categoria_id AS categoria_id_25 FROM agente a0_ INNER JOIN agente_servicio a2_ ON a0_.id = a2_.agente_id INNER JOIN servicio s1_ ON s1_.id = a2_.servicio_id WHERE (s1_.id IN (?) AND a0_.activo = 1) AND (a0_.deleted_at IS NULL)
Parameters:
[
1033
]
|
|
0.58 ms (0.77%) |
2 |
SELECT t0.id AS id_1, t0.descripcion AS descripcion_2, t0.email AS email_3, t0.planilla_enfermeria AS planilla_enfermeria_4, t0.responsable_id AS responsable_id_5 FROM servicio t0 INNER JOIN agente_servicio ON t0.id = agente_servicio.servicio_id WHERE agente_servicio.agente_id = ?
Parameters:
[
325
]
|
|
0.54 ms (0.71%) |
3 |
SELECT s0_.id AS id_0, s0_.descripcion AS descripcion_1, s0_.email AS email_2, s0_.servicio_id AS servicio_id_3, s0_.responsable_id AS responsable_id_4 FROM subservicio s0_ WHERE s0_.servicio_id IN (?) ORDER BY s0_.descripcion ASC
Parameters:
[
[
1049
1033
]
]
|
|
0.51 ms (0.68%) |
1 |
SELECT p0_.id AS id_0, p0_.descripcion AS descripcion_1, p0_.fecha_desde AS fecha_desde_2, p0_.cerrado AS cerrado_3, p0_.fecha_hasta AS fecha_hasta_4, p0_.deleted_at AS deleted_at_5, p0_.fecha_cierre AS fecha_cierre_6, p0_.created_at AS created_at_7, a1_.id AS id_8, a1_.codigo AS codigo_9, a1_.descripcion AS descripcion_10, a1_.limite AS limite_11, a1_.suma AS suma_12, a1_.resta AS resta_13, a1_.deleted_at AS deleted_at_14, a1_.dia_habiles AS dia_habiles_15, a1_.limite_mensual AS limite_mensual_16, u2_.id AS id_17, u2_.descripcion AS descripcion_18, u2_.codigo AS codigo_19, p0_.articulo_id AS articulo_id_20, p0_.agente_id AS agente_id_21, p0_.parte_renovacion_id AS parte_renovacion_id_22, p0_.adjunto_id AS adjunto_id_23, a1_.unidad_id AS unidad_id_24, a1_.periodo_id AS periodo_id_25 FROM parte_enfermo p0_ LEFT JOIN articulos a1_ ON p0_.articulo_id = a1_.id AND (a1_.deleted_at IS NULL) LEFT JOIN unidad_medida u2_ ON a1_.unidad_id = u2_.id WHERE (p0_.agente_id = ? AND p0_.cerrado = 0 AND p0_.fecha_desde <= ? AND ((p0_.fecha_hasta IS NULL OR p0_.fecha_hasta >= ?))) AND (p0_.deleted_at IS NULL) ORDER BY p0_.fecha_desde DESC
Parameters:
[ 500 "2026-11-06" "2026-11-06" ] |
|
0.46 ms (0.60%) |
1 |
SELECT a0_.id AS id_0, a0_.fecha_inicio AS fecha_inicio_1, a0_.fecha_fin AS fecha_fin_2, a0_.franja AS franja_3, a0_.activo AS activo_4, a0_.observaciones AS observaciones_5, a0_.created_at AS created_at_6, a0_.planilla_id AS planilla_id_7, a0_.agente_id AS agente_id_8, a0_.creado_por_id AS creado_por_id_9 FROM asignacion_horario_enfermeria a0_ WHERE a0_.planilla_id = ? AND a0_.activo = 1 AND a0_.fecha_inicio <= ? AND a0_.fecha_fin >= ? AND a0_.fecha_inicio >= ? ORDER BY a0_.fecha_inicio ASC
Parameters:
[ 18 "2026-11-06 23:59:59" "2026-11-06 00:00:00" "2026-11-05 00:00:00" ] |
|
0.41 ms (0.53%) |
1 |
SELECT t0.username AS username_1, t0.username_canonical AS username_canonical_2, t0.email AS email_3, t0.email_canonical AS email_canonical_4, t0.enabled AS enabled_5, t0.salt AS salt_6, t0.password AS password_7, t0.last_login AS last_login_8, t0.confirmation_token AS confirmation_token_9, t0.password_requested_at AS password_requested_at_10, t0.roles AS roles_11, t0.id AS id_12, t0.createdAt AS createdAt_13, t0.agente_id AS agente_id_14, t0.sistema_id AS sistema_id_15 FROM user t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
884
]
|
|
0.40 ms (0.52%) |
1 |
SELECT t0.id AS id_1, t0.descripcion AS descripcion_2, t0.rol AS rol_3, t0.activo AS activo_4, t0.app_id AS app_id_5 FROM rol t0 INNER JOIN user_app_rol ON t0.id = user_app_rol.rol_id WHERE user_app_rol.user_id = ?
Parameters:
[
884
]
|
|
0.30 ms (0.39%) |
1 |
SELECT t0.id AS id_1, t0.anio AS anio_2, t0.mes AS mes_3, t0.observaciones AS observaciones_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.servicio_id AS servicio_id_7, t0.creado_por_id AS creado_por_id_8 FROM planilla_horario_enfermeria t0 WHERE t0.id = ?
Parameters:
[
"18"
]
|
|
0.28 ms (0.37%) |
1 |
UPDATE planilla_horario_enfermeria SET updated_at = ? WHERE id = ?
Parameters:
[ "2026-10-27 18:39:51" 18 ] |
|
0.27 ms (0.36%) |
1 |
INSERT INTO asignacion_horario_enfermeria (fecha_inicio, fecha_fin, franja, activo, observaciones, created_at, planilla_id, agente_id, creado_por_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ 1 => "2026-11-06 06:00:00" 2 => "2026-11-06 12:00:00" 3 => "manana" 4 => 1 5 => "" 6 => "2026-10-27 18:39:51" 7 => 18 8 => 500 9 => 325 ] |
|
0.26 ms (0.35%) |
1 |
"START TRANSACTION"
Parameters:
[] |
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.
Entities Mapping
| Class | Mapping errors |
|---|---|
| FOS\UserBundle\Model\User | No errors. |
| App\Entity\User | No errors. |
| App\Entity\Agente |
|
| App\Entity\Sistema | No errors. |
| App\Entity\Reclamo | No errors. |
| App\Entity\Tarea | No errors. |
| App\Entity\Anotacion | No errors. |
| App\Entity\Rol | No errors. |
| App\Entity\Servicio | No errors. |
| App\Entity\Subservicio | No errors. |
| App\Entity\PlanillaHorarioEnfermeriaDepartamento | No errors. |
| App\Entity\PlanillaHorarioEnfermeria | No errors. |
| App\Entity\AsignacionHorarioEnfermeria | No errors. |
| App\Entity\ParteEnfermo | No errors. |
| App\Entity\App | No errors. |
| App\Entity\Persona | No errors. |
| App\Entity\CarpetaMedica | No errors. |
| App\Entity\TipoApto | No errors. |
| App\Entity\EstadoCarpeta | No errors. |
| App\Entity\Categoria | No errors. |
| App\Entity\Funcion | No errors. |
| App\Entity\Escalafon | No errors. |
| App\Entity\Revista | No errors. |
| App\Entity\Tareas | No errors. |
| App\Entity\AgenteBaja | No errors. |
| App\Entity\MotivosBaja | No errors. |
| App\Entity\Cardex | No errors. |
| App\Entity\Fichada | No errors. |
| App\Entity\MovimientoArticulos | No errors. |
| App\Entity\Turno | No errors. |
| App\Entity\ComisionServicio | No errors. |
| App\Entity\Template | No errors. |
| App\Entity\LogImpresion | No errors. |
| App\Entity\Lao | No errors. |
| App\Entity\SolicitudLao | No errors. |
| App\Entity\RepartoObraSocialDetalle | No errors. |
| App\Entity\ListaDeCobro | No errors. |
| App\Entity\Articulos | No errors. |
| App\Entity\UnidadMedida | No errors. |
| App\Entity\Adjunto |
|
| App\Entity\MovimientoHorarioEnfermeria | No errors. |
| App\Entity\MailConfig | No errors. |
| App\Entity\EstadoReclamo | No errors. |
| App\Entity\EstadoTarea | No errors. |
| App\Entity\EstadoCivil | No errors. |
| App\Entity\Genero | No errors. |
| App\Entity\Domicilio |
|
| App\Entity\Titulo | No errors. |
| App\Entity\TipoFichada | No errors. |
| App\Entity\Reloj | No errors. |
| App\Entity\EstadoMovimientoArticulos | No errors. |
| App\Entity\Horario | No errors. |
| App\Entity\TipoComision | No errors. |
| App\Entity\SolicitudLaoDetalle | No errors. |
| App\Entity\EstadoSolicitudLao | No errors. |
| App\Entity\RepartoObraSocial | No errors. |
| App\Entity\Recaudacion | No errors. |
| App\Entity\ClaseAdjunto | No errors. |
| App\Entity\Paro | No errors. |
| App\Entity\RepartoBaja | No errors. |
| App\Entity\Pais | No errors. |
| App\Entity\Tokens | No errors. |
| App\Entity\FechaPlanta | No errors. |
| App\Entity\TitulosAgente |
|
| App\Entity\TipoParo | No errors. |
| App\Entity\WhatsappContacto | No errors. |
| App\Entity\TipoTitulo | No errors. |
| App\Entity\Correo | No errors. |
| App\Entity\Exceptions | No errors. |
| App\Entity\AgenteSaldos |
|
| App\Entity\Cargo | No errors. |
| App\Entity\ModeloImpresion | No errors. |
| App\Entity\Notificacion | No errors. |
| App\Entity\TipoFeriado | No errors. |
| App\Entity\Whatsapp | No errors. |
| App\Entity\Agrupamiento | No errors. |
| App\Entity\WhatsappSistema | No errors. |
| App\Entity\Localidad | No errors. |
| App\Entity\Token | No errors. |
| App\Entity\WhatsappContactoUsuario |
|
| App\Entity\Feriados | No errors. |
| App\Entity\HorasTotales | No errors. |
| App\Entity\Menu | No errors. |
| App\Entity\Provincia | No errors. |
| App\Entity\EstadoReparto | No errors. |
| App\Entity\Operacion | No errors. |
| App\Entity\TipoNotificacion | No errors. |
| Gedmo\Loggable\Entity\MappedSuperclass\AbstractLogEntry | No errors. |
| Gedmo\Loggable\Entity\LogEntry | No errors. |
| Vich\UploaderBundle\Entity\File | No errors. |