POST http://personal.hnzn.org/planilla/mensual/18/asignacion

Query Metrics

494 Database Queries
19 Different statements
75.95 ms Query time
6 Invalid entities

Grouped Statements

Show all queries

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
  • The field App\Entity\Agente#carpetaMedica is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\CarpetaMedica#agente does not contain the required 'inversedBy="carpetaMedica"' attribute.
  • The field App\Entity\Agente#agenteBaja is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\AgenteBaja#agente does not contain the required 'inversedBy="agenteBaja"' attribute.
  • The field App\Entity\Agente#listasDeCobro is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\ListaDeCobro#agentes does not contain the required 'inversedBy="listasDeCobro"' attribute.
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
  • The field App\Entity\Adjunto#parte is on the owning side of a bi-directional relationship, but the specified inversedBy association on the target-entity App\Entity\ParteEnfermo#adjunto does not contain the required 'mappedBy="parte"' attribute.
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
  • The field App\Entity\Domicilio#persona is on the owning side of a bi-directional relationship, but the specified inversedBy association on the target-entity App\Entity\Persona#domicilio does not contain the required 'mappedBy="persona"' attribute.
  • If association App\Entity\Domicilio#persona is many-to-one, then the inversed side App\Entity\Persona#domicilio has to be one-to-many.
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
  • The association App\Entity\TitulosAgente#agente refers to the inverse side field App\Entity\Agente#titulosAgentes which does not exist.
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
  • The association App\Entity\AgenteSaldos#agente refers to the inverse side field App\Entity\Agente#agenteSaldos which does not exist.
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
  • The association App\Entity\WhatsappContactoUsuario#contacto refers to the inverse side field App\Entity\WhatsappContacto#whatsappContactoUsuarios which does not exist.
  • The association App\Entity\WhatsappContactoUsuario#usuarios refers to the inverse side field App\Entity\User#whatsappContactoUsuarios which does not exist.
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.