Symfony Profiler

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

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 = 884 LIMIT 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 = ?

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 = '18';

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

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 = 884;

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

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 = 1 ORDER BY s0_.descripcion ASC;

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

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 = 1 ORDER BY s0_.descripcion ASC;

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

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 (1049, 1033) ORDER BY s0_.descripcion ASC;

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)
  )

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 = 325 AND ((t0.deleted_at IS NULL));

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

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 = 325;

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

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 = 1 ORDER BY s0_.descripcion ASC;

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

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 = 1 ORDER BY s0_.descripcion ASC;

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

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 (1049, 1033) ORDER BY s0_.descripcion ASC;

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

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 = 1 ORDER BY s0_.descripcion ASC;

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

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 = 1 ORDER BY s0_.descripcion ASC;

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

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 (1049, 1033) ORDER BY s0_.descripcion ASC;

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)
  )

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 = 500 AND ((t0.deleted_at IS NULL));

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

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 = 500;

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

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 = 500 AND p0_.cerrado = 0 AND p0_.fecha_desde <= '2026-11-06' AND ((p0_.fecha_hasta IS NULL OR p0_.fecha_hasta >= '2026-11-06'))) AND (p0_.deleted_at IS NULL) ORDER BY p0_.fecha_desde DESC;

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

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 = 18 AND a0_.agente_id = 500 AND a0_.activo = 1 AND a0_.fecha_inicio < '2026-11-06 12:00:00' AND a0_.fecha_fin > '2026-11-06 06:00:00' AND ((a0_.franja IS NULL OR a0_.franja <> 'pasiva')) ORDER BY a0_.fecha_inicio ASC;

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO asignacion_horario_enfermeria (
  fecha_inicio, fecha_fin, franja, activo,
  observaciones, created_at, planilla_id,
  agente_id, creado_por_id
)
VALUES
  (?, ?, ?, ?, ?, ?, ?, ?, ?)

INSERT INTO asignacion_horario_enfermeria (fecha_inicio, fecha_fin, franja, activo, observaciones, created_at, planilla_id, agente_id, creado_por_id) VALUES ('2026-11-06 06:00:00', '2026-11-06 12:00:00', 'manana', 1, '', '2026-10-27 18:39:51', 18, 500, 325);

UPDATE
  planilla_horario_enfermeria
SET
  updated_at = ?
WHERE
  id = ?

UPDATE planilla_horario_enfermeria SET updated_at = '2026-10-27 18:39:51' WHERE id = 18;

"COMMIT"

"COMMIT";

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)

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 (1033) AND a0_.activo = 1) AND (a0_.deleted_at IS NULL);

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)
  )

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 = 13 AND ((t0.deleted_at IS NULL));

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

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 = 13;

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

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 = 13;

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)
  )

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 = 21 AND ((t0.deleted_at IS NULL));