Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.nombre AS nombre_2,
  t0.apellido AS apellido_3,
  t0.dni AS dni_4,
  t0.telefono AS telefono_5,
  t0.activo AS activo_6,
  t0.borrado AS borrado_7,
  t0.correo AS correo_8,
  t0.hash AS hash_9,
  t0.legajo AS legajo_10,
  t0.password AS password_11,
  t0.notificaciones_correo_activas AS notificaciones_correo_activas_12,
  t0.fecha_alta AS fecha_alta_13,
  t0.es_responsable_sector AS es_responsable_sector_14,
  t0.terminos_ycondiciones AS terminos_ycondiciones_15,
  t0.permiso_supervisor_todos AS permiso_supervisor_todos_16,
  t0.carga_rapida_tiempo AS carga_rapida_tiempo_17,
  t0.reset_password_code AS reset_password_code_18,
  t0.rol_id AS rol_id_19,
  t0.empresa_id AS empresa_id_20,
  t0.sector_id AS sector_id_21,
  t0.puesto_id AS puesto_id_22
FROM
  usuario t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.apellido AS apellido_3, t0.dni AS dni_4, t0.telefono AS telefono_5, t0.activo AS activo_6, t0.borrado AS borrado_7, t0.correo AS correo_8, t0.hash AS hash_9, t0.legajo AS legajo_10, t0.password AS password_11, t0.notificaciones_correo_activas AS notificaciones_correo_activas_12, t0.fecha_alta AS fecha_alta_13, t0.es_responsable_sector AS es_responsable_sector_14, t0.terminos_ycondiciones AS terminos_ycondiciones_15, t0.permiso_supervisor_todos AS permiso_supervisor_todos_16, t0.carga_rapida_tiempo AS carga_rapida_tiempo_17, t0.reset_password_code AS reset_password_code_18, t0.rol_id AS rol_id_19, t0.empresa_id AS empresa_id_20, t0.sector_id AS sector_id_21, t0.puesto_id AS puesto_id_22 FROM usuario t0 WHERE t0.id = 61;

SELECT
  t0.id AS id_1,
  t0.nombre AS nombre_2,
  t0.descripcion AS descripcion_3,
  t0.abreviatura AS abreviatura_4
FROM
  rol t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.descripcion AS descripcion_3, t0.abreviatura AS abreviatura_4 FROM rol t0 WHERE t0.id = 2;

SELECT
  t0.id AS id_1,
  t0.fecha AS fecha_2,
  t0.hora_inicio AS hora_inicio_3,
  t0.hora_fin AS hora_fin_4,
  t0.obs AS obs_5,
  t0.activo AS activo_6,
  t0.tiempo_total AS tiempo_total_7,
  t0.compartida AS compartida_8,
  t0.confirmada AS confirmada_9,
  t0.borrado AS borrado_10,
  t0.usuario_id AS usuario_id_11,
  t0.empresa_id AS empresa_id_12,
  t0.sector_id AS sector_id_13,
  t0.cliente_id AS cliente_id_14,
  t0.tarea_id AS tarea_id_15,
  t0.tiempo_padre_id AS tiempo_padre_id_16,
  t0.carga_rapida_id AS carga_rapida_id_17,
  t0.puesto_id AS puesto_id_18
FROM
  tiempo t0
WHERE
  t0.usuario_id = ?
  AND t0.fecha = ?
  AND t0.activo = ?
  AND t0.confirmada = ?
ORDER BY
  t0.fecha DESC,
  t0.hora_inicio DESC

SELECT t0.id AS id_1, t0.fecha AS fecha_2, t0.hora_inicio AS hora_inicio_3, t0.hora_fin AS hora_fin_4, t0.obs AS obs_5, t0.activo AS activo_6, t0.tiempo_total AS tiempo_total_7, t0.compartida AS compartida_8, t0.confirmada AS confirmada_9, t0.borrado AS borrado_10, t0.usuario_id AS usuario_id_11, t0.empresa_id AS empresa_id_12, t0.sector_id AS sector_id_13, t0.cliente_id AS cliente_id_14, t0.tarea_id AS tarea_id_15, t0.tiempo_padre_id AS tiempo_padre_id_16, t0.carga_rapida_id AS carga_rapida_id_17, t0.puesto_id AS puesto_id_18 FROM tiempo t0 WHERE t0.usuario_id = 61 AND t0.fecha = '2026-08-25' AND t0.activo = 0 AND t0.confirmada = 1 ORDER BY t0.fecha DESC, t0.hora_inicio DESC;

SELECT
  t0.id AS id_1,
  t0.fecha AS fecha_2,
  t0.hora_inicio AS hora_inicio_3,
  t0.hora_fin AS hora_fin_4,
  t0.obs AS obs_5,
  t0.activo AS activo_6,
  t0.tiempo_total AS tiempo_total_7,
  t0.compartida AS compartida_8,
  t0.confirmada AS confirmada_9,
  t0.borrado AS borrado_10,
  t0.usuario_id AS usuario_id_11,
  t0.empresa_id AS empresa_id_12,
  t0.sector_id AS sector_id_13,
  t0.cliente_id AS cliente_id_14,
  t0.tarea_id AS tarea_id_15,
  t0.tiempo_padre_id AS tiempo_padre_id_16,
  t0.carga_rapida_id AS carga_rapida_id_17,
  t0.puesto_id AS puesto_id_18
FROM
  tiempo t0
WHERE
  t0.usuario_id = ?
  AND t0.fecha = ?
  AND t0.activo = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.fecha AS fecha_2, t0.hora_inicio AS hora_inicio_3, t0.hora_fin AS hora_fin_4, t0.obs AS obs_5, t0.activo AS activo_6, t0.tiempo_total AS tiempo_total_7, t0.compartida AS compartida_8, t0.confirmada AS confirmada_9, t0.borrado AS borrado_10, t0.usuario_id AS usuario_id_11, t0.empresa_id AS empresa_id_12, t0.sector_id AS sector_id_13, t0.cliente_id AS cliente_id_14, t0.tarea_id AS tarea_id_15, t0.tiempo_padre_id AS tiempo_padre_id_16, t0.carga_rapida_id AS carga_rapida_id_17, t0.puesto_id AS puesto_id_18 FROM tiempo t0 WHERE t0.usuario_id = 61 AND t0.fecha = '2026-08-25' AND t0.activo = 1 LIMIT 1;

SELECT
  t0_.id AS id_0,
  t0_.fecha AS fecha_1,
  t0_.hora_inicio AS hora_inicio_2,
  t0_.hora_fin AS hora_fin_3,
  t0_.obs AS obs_4,
  t0_.activo AS activo_5,
  t0_.tiempo_total AS tiempo_total_6,
  t0_.compartida AS compartida_7,
  t0_.confirmada AS confirmada_8,
  t0_.borrado AS borrado_9,
  t0_.usuario_id AS usuario_id_10,
  t0_.empresa_id AS empresa_id_11,
  t0_.sector_id AS sector_id_12,
  t0_.cliente_id AS cliente_id_13,
  t0_.tarea_id AS tarea_id_14,
  t0_.tiempo_padre_id AS tiempo_padre_id_15,
  t0_.carga_rapida_id AS carga_rapida_id_16,
  t0_.puesto_id AS puesto_id_17
FROM
  tiempo t0_
WHERE
  t0_.fecha < '2026-08-25'
  AND t0_.usuario_id = '61'
  AND t0_.activo = 1
  AND t0_.confirmada = 1
  AND t0_.borrado = 0

SELECT t0_.id AS id_0, t0_.fecha AS fecha_1, t0_.hora_inicio AS hora_inicio_2, t0_.hora_fin AS hora_fin_3, t0_.obs AS obs_4, t0_.activo AS activo_5, t0_.tiempo_total AS tiempo_total_6, t0_.compartida AS compartida_7, t0_.confirmada AS confirmada_8, t0_.borrado AS borrado_9, t0_.usuario_id AS usuario_id_10, t0_.empresa_id AS empresa_id_11, t0_.sector_id AS sector_id_12, t0_.cliente_id AS cliente_id_13, t0_.tarea_id AS tarea_id_14, t0_.tiempo_padre_id AS tiempo_padre_id_15, t0_.carga_rapida_id AS carga_rapida_id_16, t0_.puesto_id AS puesto_id_17 FROM tiempo t0_ WHERE t0_.fecha < '2026-08-25' AND t0_.usuario_id = '61' AND t0_.activo = 1 AND t0_.confirmada = 1 AND t0_.borrado = 0;

SELECT
  t0.id AS id_1,
  t0.nombre AS nombre_2,
  t0.abrev AS abrev_3,
  t0.descripcion AS descripcion_4,
  t0.borrado AS borrado_5,
  t0.hash AS hash_6,
  t0.empresa_id AS empresa_id_7
FROM
  cliente t0
WHERE
  t0.empresa_id = ?
  AND t0.borrado = ?

SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.abrev AS abrev_3, t0.descripcion AS descripcion_4, t0.borrado AS borrado_5, t0.hash AS hash_6, t0.empresa_id AS empresa_id_7 FROM cliente t0 WHERE t0.empresa_id = 5 AND t0.borrado = 0;

SELECT
  t0.id AS id_1,
  t0.nombre AS nombre_2,
  t0.apellido AS apellido_3,
  t0.dni AS dni_4,
  t0.telefono AS telefono_5,
  t0.activo AS activo_6,
  t0.borrado AS borrado_7,
  t0.correo AS correo_8,
  t0.hash AS hash_9,
  t0.legajo AS legajo_10,
  t0.password AS password_11,
  t0.notificaciones_correo_activas AS notificaciones_correo_activas_12,
  t0.fecha_alta AS fecha_alta_13,
  t0.es_responsable_sector AS es_responsable_sector_14,
  t0.terminos_ycondiciones AS terminos_ycondiciones_15,
  t0.permiso_supervisor_todos AS permiso_supervisor_todos_16,
  t0.carga_rapida_tiempo AS carga_rapida_tiempo_17,
  t0.reset_password_code AS reset_password_code_18,
  t0.rol_id AS rol_id_19,
  t0.empresa_id AS empresa_id_20,
  t0.sector_id AS sector_id_21,
  t0.puesto_id AS puesto_id_22
FROM
  usuario t0
WHERE
  t0.empresa_id = ?
  AND t0.borrado = ?

SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.apellido AS apellido_3, t0.dni AS dni_4, t0.telefono AS telefono_5, t0.activo AS activo_6, t0.borrado AS borrado_7, t0.correo AS correo_8, t0.hash AS hash_9, t0.legajo AS legajo_10, t0.password AS password_11, t0.notificaciones_correo_activas AS notificaciones_correo_activas_12, t0.fecha_alta AS fecha_alta_13, t0.es_responsable_sector AS es_responsable_sector_14, t0.terminos_ycondiciones AS terminos_ycondiciones_15, t0.permiso_supervisor_todos AS permiso_supervisor_todos_16, t0.carga_rapida_tiempo AS carga_rapida_tiempo_17, t0.reset_password_code AS reset_password_code_18, t0.rol_id AS rol_id_19, t0.empresa_id AS empresa_id_20, t0.sector_id AS sector_id_21, t0.puesto_id AS puesto_id_22 FROM usuario t0 WHERE t0.empresa_id = 5 AND t0.borrado = 0;

SELECT
  t0_.id AS id_0,
  t0_.titulo AS titulo_1,
  t0_.descripcion AS descripcion_2,
  t0_.tiempo_asignado AS tiempo_asignado_3,
  t0_.tiempo_compartido AS tiempo_compartido_4,
  t0_.fecha_alta AS fecha_alta_5,
  t0_.permiso_todos AS permiso_todos_6,
  t0_.activa AS activa_7,
  t0_.tipo_tarea_id AS tipo_tarea_id_8,
  t0_.usuario_alta_id AS usuario_alta_id_9,
  t0_.empresa_id AS empresa_id_10
FROM
  tarea t0_
  INNER JOIN tarea_usuario t2_ ON t0_.id = t2_.tarea_id
  INNER JOIN usuario u1_ ON u1_.id = t2_.usuario_id
WHERE
  u1_.id = ?
  AND t0_.empresa_id = ?

SELECT t0_.id AS id_0, t0_.titulo AS titulo_1, t0_.descripcion AS descripcion_2, t0_.tiempo_asignado AS tiempo_asignado_3, t0_.tiempo_compartido AS tiempo_compartido_4, t0_.fecha_alta AS fecha_alta_5, t0_.permiso_todos AS permiso_todos_6, t0_.activa AS activa_7, t0_.tipo_tarea_id AS tipo_tarea_id_8, t0_.usuario_alta_id AS usuario_alta_id_9, t0_.empresa_id AS empresa_id_10 FROM tarea t0_ INNER JOIN tarea_usuario t2_ ON t0_.id = t2_.tarea_id INNER JOIN usuario u1_ ON u1_.id = t2_.usuario_id WHERE u1_.id = 61 AND t0_.empresa_id = 5;

SELECT
  t0.id AS id_1,
  t0.fecha AS fecha_2,
  t0.hora_inicio AS hora_inicio_3,
  t0.hora_fin AS hora_fin_4,
  t0.obs AS obs_5,
  t0.activo AS activo_6,
  t0.tiempo_total AS tiempo_total_7,
  t0.compartida AS compartida_8,
  t0.confirmada AS confirmada_9,
  t0.borrado AS borrado_10,
  t0.usuario_id AS usuario_id_11,
  t0.empresa_id AS empresa_id_12,
  t0.sector_id AS sector_id_13,
  t0.cliente_id AS cliente_id_14,
  t0.tarea_id AS tarea_id_15,
  t0.tiempo_padre_id AS tiempo_padre_id_16,
  t0.carga_rapida_id AS carga_rapida_id_17,
  t0.puesto_id AS puesto_id_18
FROM
  tiempo t0
WHERE
  t0.usuario_id = ?
  AND t0.confirmada = ?
  AND t0.borrado = ?
  AND t0.activo = ?
ORDER BY
  t0.fecha DESC

SELECT t0.id AS id_1, t0.fecha AS fecha_2, t0.hora_inicio AS hora_inicio_3, t0.hora_fin AS hora_fin_4, t0.obs AS obs_5, t0.activo AS activo_6, t0.tiempo_total AS tiempo_total_7, t0.compartida AS compartida_8, t0.confirmada AS confirmada_9, t0.borrado AS borrado_10, t0.usuario_id AS usuario_id_11, t0.empresa_id AS empresa_id_12, t0.sector_id AS sector_id_13, t0.cliente_id AS cliente_id_14, t0.tarea_id AS tarea_id_15, t0.tiempo_padre_id AS tiempo_padre_id_16, t0.carga_rapida_id AS carga_rapida_id_17, t0.puesto_id AS puesto_id_18 FROM tiempo t0 WHERE t0.usuario_id = 61 AND t0.confirmada = 0 AND t0.borrado = 0 AND t0.activo = 0 ORDER BY t0.fecha DESC;

SELECT
  t0_.id AS id_0,
  t0_.fecha AS fecha_1,
  t0_.hora_inicio AS hora_inicio_2,
  t0_.hora_fin AS hora_fin_3,
  t0_.obs AS obs_4,
  t0_.activo AS activo_5,
  t0_.tiempo_total AS tiempo_total_6,
  t0_.compartida AS compartida_7,
  t0_.confirmada AS confirmada_8,
  t0_.borrado AS borrado_9,
  t0_.usuario_id AS usuario_id_10,
  t0_.empresa_id AS empresa_id_11,
  t0_.sector_id AS sector_id_12,
  t0_.cliente_id AS cliente_id_13,
  t0_.tarea_id AS tarea_id_14,
  t0_.tiempo_padre_id AS tiempo_padre_id_15,
  t0_.carga_rapida_id AS carga_rapida_id_16,
  t0_.puesto_id AS puesto_id_17
FROM
  tiempo t0_
WHERE
  t0_.usuario_id = ?
  AND t0_.fecha = ?
  AND (
    (
      t0_.hora_inicio < ?
      AND t0_.hora_fin > ?
    )
  )

SELECT t0_.id AS id_0, t0_.fecha AS fecha_1, t0_.hora_inicio AS hora_inicio_2, t0_.hora_fin AS hora_fin_3, t0_.obs AS obs_4, t0_.activo AS activo_5, t0_.tiempo_total AS tiempo_total_6, t0_.compartida AS compartida_7, t0_.confirmada AS confirmada_8, t0_.borrado AS borrado_9, t0_.usuario_id AS usuario_id_10, t0_.empresa_id AS empresa_id_11, t0_.sector_id AS sector_id_12, t0_.cliente_id AS cliente_id_13, t0_.tarea_id AS tarea_id_14, t0_.tiempo_padre_id AS tiempo_padre_id_15, t0_.carga_rapida_id AS carga_rapida_id_16, t0_.puesto_id AS puesto_id_17 FROM tiempo t0_ WHERE t0_.usuario_id = 61 AND t0_.fecha = '2026-08-25' AND ((t0_.hora_inicio < '18:00:00' AND t0_.hora_fin > '16:00:00'));

"START TRANSACTION"

"START TRANSACTION";

UPDATE
  tarea
SET
  tiempo_asignado = ?
WHERE
  id = ?

UPDATE tarea SET tiempo_asignado = '10:43:00' WHERE id = 57;

"COMMIT"

"COMMIT";

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO tiempo (
  fecha, hora_inicio, hora_fin, obs,
  activo, tiempo_total, compartida,
  confirmada, borrado, usuario_id,
  empresa_id, sector_id, cliente_id,
  tarea_id, tiempo_padre_id, carga_rapida_id,
  puesto_id
)
VALUES
  (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?
  )

INSERT INTO tiempo (fecha, hora_inicio, hora_fin, obs, activo, tiempo_total, compartida, confirmada, borrado, usuario_id, empresa_id, sector_id, cliente_id, tarea_id, tiempo_padre_id, carga_rapida_id, puesto_id) VALUES ('2026-08-25', '16:00:00', '18:00:00', NULL, 0, '02:00:00', 0, 1, 0, 61, 5, NULL, 396, 57, NULL, NULL, NULL);

"COMMIT"

"COMMIT";

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO auditoria (
  fecha, descripcion, entidad, usuario_id,
  empresa_id
)
VALUES
  (?, ?, ?, ?, ?)

INSERT INTO auditoria (fecha, descripcion, entidad, usuario_id, empresa_id) VALUES ('2026-08-25 21:08:36', 'Tiempo cargado correctamente', 'Tiempo', 61, 5);

"COMMIT"

"COMMIT";