Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

189 Database Queries

14 Different statements

504.26 ms Query time

0 Invalid entities

Queries

Group similar statements


SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.email AS email_3, t0.telefono AS telefono_4, t0.habilitado AS habilitado_5, t0.rango_salarial_id AS rango_salarial_id_6, t7.id AS id_8, t7.email AS email_9, t7.roles AS roles_10, t7.password AS password_11, t7.is_verified AS is_verified_12, t7.nombre AS nombre_13, t7.habilitado AS habilitado_14, t7.empleada_id AS empleada_id_15, t7.contacto_id AS contacto_id_16, t7.contacto_proveedor_id AS contacto_proveedor_id_17 FROM empleada t0 LEFT JOIN usuario t7 ON t7.empleada_id = t0.id
SELECT t0.id AS id_1, t0.hora_inicio AS hora_inicio_2, t0.hora_fin AS hora_fin_3, t0.hora_aviso_max AS hora_aviso_max_4, t0.hora_aviso_min AS hora_aviso_min_5, t0.justificacion_aviso1 AS justificacion_aviso1_6, t0.justificacion_aviso2 AS justificacion_aviso2_7, t0.justificacion_aviso3 AS justificacion_aviso3_8 FROM globales t0 LIMIT 1
SELECT t0.id AS id_1, t0.fecha AS fecha_2, t0.entrada AS entrada_3, t0.empleada_id AS empleada_id_4 FROM fichaje_diario t0 WHERE t0.empleada_id = ? ORDER BY t0.fecha DESC LIMIT 1
SELECT t0.id AS id_1, t0.fecha AS fecha_2, t0.entrada AS entrada_3, t0.empleada_id AS empleada_id_4 FROM fichaje_diario t0 WHERE t0.empleada_id = ? ORDER BY t0.fecha DESC LIMIT 1
SELECT t0.id AS id_1, t0.fecha AS fecha_2, t0.entrada AS entrada_3, t0.empleada_id AS empleada_id_4 FROM fichaje_diario t0 WHERE t0.empleada_id = ? ORDER BY t0.fecha DESC LIMIT 1
"START TRANSACTION"
INSERT INTO fichaje_diario (fecha, entrada, empleada_id) VALUES (?, ?, ?)
"COMMIT"
SELECT t0.id AS id_1, t0.descripcion AS descripcion_2 FROM tipo_notificacion t0 WHERE t0.descripcion = ? LIMIT 1
SELECT u0_.id AS id_0, u0_.email AS email_1, u0_.roles AS roles_2, u0_.password AS password_3, u0_.is_verified AS is_verified_4, u0_.nombre AS nombre_5, u0_.habilitado AS habilitado_6, u0_.empleada_id AS empleada_id_7, u0_.contacto_id AS contacto_id_8, u0_.contacto_proveedor_id AS contacto_proveedor_id_9 FROM usuario u0_ WHERE u0_.roles LIKE ?
"START TRANSACTION"
INSERT INTO notificacion (fecha, textoes, textoeus, leido, objeto, destinatario_id, tipo_id) VALUES (?, ?, ?, ?, ?, ?, ?)
INSERT INTO notificacion (fecha, textoes, textoeus, leido, objeto, destinatario_id, tipo_id) VALUES (?, ?, ?, ?, ?, ?, ?)
INSERT INTO notificacion (fecha, textoes, textoeus, leido, objeto, destinatario_id, tipo_id) VALUES (?, ?, ?, ?, ?, ?, ?)
INSERT INTO notificacion (fecha, textoes, textoeus, leido, objeto, destinatario_id, tipo_id) VALUES (?, ?, ?, ?, ?, ?, ?)
"COMMIT"
SELECT t0.id AS id_1, t0.fecha AS fecha_2, t0.entrada AS entrada_3, t0.empleada_id AS empleada_id_4 FROM fichaje_diario t0 WHERE t0.empleada_id = ? ORDER BY t0.fecha DESC LIMIT 1
SELECT t0.id AS id_1, t0.fecha AS fecha_2, t0.entrada AS entrada_3, t0.empleada_id AS empleada_id_4 FROM fichaje_diario t0 WHERE t0.empleada_id = ? ORDER BY t0.fecha DESC LIMIT 1
SELECT t0.id AS id_1, t0.fecha AS fecha_2, t0.entrada AS entrada_3, t0.empleada_id AS empleada_id_4 FROM fichaje_diario t0 WHERE t0.empleada_id = ? ORDER BY t0.fecha DESC LIMIT 1
SELECT t0.id AS id_1, t0.fecha AS fecha_2, t0.entrada AS entrada_3, t0.empleada_id AS empleada_id_4 FROM fichaje_diario t0 WHERE t0.empleada_id = ? ORDER BY t0.fecha DESC LIMIT 1
SELECT t0.id AS id_1, t0.fecha AS fecha_2, t0.entrada AS entrada_3, t0.empleada_id AS empleada_id_4 FROM fichaje_diario t0 WHERE t0.empleada_id = ? ORDER BY t0.fecha DESC LIMIT 1
SELECT t0.id AS id_1, t0.fecha AS fecha_2, t0.entrada AS entrada_3, t0.empleada_id AS empleada_id_4 FROM fichaje_diario t0 WHERE t0.empleada_id = ? ORDER BY t0.fecha DESC LIMIT 1
SELECT t0.id AS id_1, t0.fecha AS fecha_2, t0.entrada AS entrada_3, t0.empleada_id AS empleada_id_4 FROM fichaje_diario t0 WHERE t0.empleada_id = ? ORDER BY t0.fecha DESC LIMIT 1
SELECT t0.id AS id_1, t0.fecha AS fecha_2, t0.entrada AS entrada_3, t0.empleada_id AS empleada_id_4 FROM fichaje_diario t0 WHERE t0.empleada_id = ? ORDER BY t0.fecha DESC LIMIT 1
SELECT t0.id AS id_1, t0.fecha AS fecha_2, t0.entrada AS entrada_3, t0.empleada_id AS empleada_id_4 FROM fichaje_diario t0 WHERE t0.empleada_id = ? ORDER BY t0.fecha DESC LIMIT 1
SELECT t0.id AS id_1, t0.fecha AS fecha_2, t0.entrada AS entrada_3, t0.empleada_id AS empleada_id_4 FROM fichaje_diario t0 WHERE t0.empleada_id = ? ORDER BY t0.fecha DESC LIMIT 1
SELECT t0.id AS id_1, t0.fecha AS fecha_2, t0.entrada AS entrada_3, t0.empleada_id AS empleada_id_4 FROM fichaje_diario t0 WHERE t0.empleada_id = ? ORDER BY t0.fecha DESC LIMIT 1
SELECT t0.id AS id_1, t0.fecha AS fecha_2, t0.entrada AS entrada_3, t0.empleada_id AS empleada_id_4 FROM fichaje_diario t0 WHERE t0.empleada_id = ? ORDER BY t0.fecha DESC LIMIT 1
SELECT t0.id AS id_1, t0.fecha AS fecha_2, t0.entrada AS entrada_3, t0.empleada_id AS empleada_id_4 FROM fichaje_diario t0 WHERE t0.empleada_id = ? ORDER BY t0.fecha DESC LIMIT 1
SELECT t0.id AS id_1, t0.fecha AS fecha_2, t0.entrada AS entrada_3, t0.empleada_id AS empleada_id_4 FROM fichaje_diario t0 WHERE t0.empleada_id = ? ORDER BY t0.fecha DESC LIMIT 1
SELECT t0.id AS id_1, t0.fecha AS fecha_2, t0.entrada AS entrada_3, t0.empleada_id AS empleada_id_4 FROM fichaje_diario t0 WHERE t0.empleada_id = ? ORDER BY t0.fecha DESC LIMIT 1
SELECT t0.id AS id_1, t0.fecha AS fecha_2, t0.entrada AS entrada_3, t0.empleada_id AS empleada_id_4 FROM fichaje_diario t0 WHERE t0.empleada_id = ? ORDER BY t0.fecha DESC LIMIT 1
SELECT t0.id AS id_1, t0.fecha AS fecha_2, t0.entrada AS entrada_3, t0.empleada_id AS empleada_id_4 FROM fichaje_diario t0 WHERE t0.empleada_id = ? ORDER BY t0.fecha DESC LIMIT 1
SELECT t0.id AS id_1, t0.fecha AS fecha_2, t0.entrada AS entrada_3, t0.empleada_id AS empleada_id_4 FROM fichaje_diario t0 WHERE t0.empleada_id = ? ORDER BY t0.fecha DESC LIMIT 1
"START TRANSACTION"
INSERT INTO fichaje_diario (fecha, entrada, empleada_id) VALUES (?, ?, ?)
"COMMIT"
SELECT t0.id AS id_1, t0.descripcion AS descripcion_2 FROM tipo_notificacion t0 WHERE t0.descripcion = ? LIMIT 1
SELECT u0_.id AS id_0, u0_.email AS email_1, u0_.roles AS roles_2, u0_.password AS password_3, u0_.is_verified AS is_verified_4, u0_.nombre AS nombre_5, u0_.habilitado AS habilitado_6, u0_.empleada_id AS empleada_id_7, u0_.contacto_id AS contacto_id_8, u0_.contacto_proveedor_id AS contacto_proveedor_id_9 FROM usuario u0_ WHERE u0_.roles LIKE ?
"START TRANSACTION"
INSERT INTO notificacion (fecha, textoes, textoeus, leido, objeto, destinatario_id, tipo_id) VALUES (?, ?, ?, ?, ?, ?, ?)
INSERT INTO notificacion (fecha, textoes, textoeus, leido, objeto, destinatario_id, tipo_id) VALUES (?, ?, ?, ?, ?, ?, ?)
INSERT INTO notificacion (fecha, textoes, textoeus, leido, objeto, destinatario_id, tipo_id) VALUES (?, ?, ?, ?, ?, ?, ?)
INSERT INTO notificacion (fecha, textoes, textoeus, leido, objeto, destinatario_id, tipo_id) VALUES (?, ?, ?, ?, ?, ?, ?)
INSERT INTO notificacion (fecha, textoes, textoeus, leido, objeto, destinatario_id, tipo_id) VALUES (?, ?, ?, ?, ?, ?, ?)
"COMMIT"
SELECT t0.id AS id_1, t0.fecha AS fecha_2, t0.entrada AS entrada_3, t0.empleada_id AS empleada_id_4 FROM fichaje_diario t0 WHERE t0.empleada_id = ? ORDER BY t0.fecha DESC LIMIT 1
SELECT t0.id AS id_1, t0.fecha AS fecha_2, t0.entrada AS entrada_3, t0.empleada_id AS empleada_id_4 FROM fichaje_diario t0 WHERE t0.empleada_id = ? ORDER BY t0.fecha DESC LIMIT 1
SELECT t0.id AS id_1, t0.fecha AS fecha_2, t0.entrada AS entrada_3, t0.empleada_id AS empleada_id_4 FROM fichaje_diario t0 WHERE t0.empleada_id = ? ORDER BY t0.fecha DESC LIMIT 1
SELECT t0.id AS id_1, t0.fecha AS fecha_2, t0.entrada AS entrada_3, t0.empleada_id AS empleada_id_4 FROM fichaje_diario t0 WHERE t0.empleada_id = ? ORDER BY t0.fecha DESC LIMIT 1
SELECT t0.id AS id_1, t0.fecha AS fecha_2, t0.entrada AS entrada_3, t0.empleada_id AS empleada_id_4 FROM fichaje_diario t0 WHERE t0.empleada_id = ? ORDER BY t0.fecha DESC LIMIT 1
SELECT t0.id AS id_1, t0.fecha AS fecha_2, t0.entrada AS entrada_3, t0.empleada_id AS empleada_id_4 FROM fichaje_diario t0 WHERE t0.empleada_id = ? ORDER BY t0.fecha DESC LIMIT 1
SELECT t0.id AS id_1, t0.fecha AS fecha_2, t0.entrada AS entrada_3, t0.empleada_id AS empleada_id_4 FROM fichaje_diario t0 WHERE t0.empleada_id = ? ORDER BY t0.fecha DESC LIMIT 1
SELECT t0.id AS id_1, t0.fecha AS fecha_2, t0.entrada AS entrada_3, t0.empleada_id AS empleada_id_4 FROM fichaje_diario t0 WHERE t0.empleada_id = ? ORDER BY t0.fecha DESC LIMIT 1
SELECT t0.id AS id_1, t0.fecha AS fecha_2, t0.entrada AS entrada_3, t0.empleada_id AS empleada_id_4 FROM fichaje_diario t0 WHERE t0.empleada_id = ? ORDER BY t0.fecha DESC LIMIT 1
SELECT t0.id AS id_1, t0.fecha AS fecha_2, t0.entrada AS entrada_3, t0.empleada_id AS empleada_id_4 FROM fichaje_diario t0 WHERE t0.empleada_id = ? ORDER BY t0.fecha DESC LIMIT 1
SELECT t0.id AS id_1, t0.fecha AS fecha_2, t0.entrada AS entrada_3, t0.empleada_id AS empleada_id_4 FROM fichaje_diario t0 WHERE t0.empleada_id = ? ORDER BY t0.fecha DESC LIMIT 1
SELECT t0.id AS id_1, t0.fecha AS fecha_2, t0.entrada AS entrada_3, t0.empleada_id AS empleada_id_4 FROM fichaje_diario t0 WHERE t0.empleada_id = ? ORDER BY t0.fecha DESC LIMIT 1
SELECT t0.id AS id_1, t0.fecha AS fecha_2, t0.entrada AS entrada_3, t0.empleada_id AS empleada_id_4 FROM fichaje_diario t0 WHERE t0.empleada_id = ? ORDER BY t0.fecha DESC LIMIT 1
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.email AS email_3, t0.telefono AS telefono_4, t0.habilitado AS habilitado_5, t0.rango_salarial_id AS rango_salarial_id_6, t7.id AS id_8, t7.email AS email_9, t7.roles AS roles_10, t7.password AS password_11, t7.is_verified AS is_verified_12, t7.nombre AS nombre_13, t7.habilitado AS habilitado_14, t7.empleada_id AS empleada_id_15, t7.contacto_id AS contacto_id_16, t7.contacto_proveedor_id AS contacto_proveedor_id_17 FROM empleada t0 LEFT JOIN usuario t7 ON t7.empleada_id = t0.id
SELECT t0.id AS id_1, t0.hora_inicio AS hora_inicio_2, t0.hora_fin AS hora_fin_3, t0.hora_aviso_max AS hora_aviso_max_4, t0.hora_aviso_min AS hora_aviso_min_5, t0.justificacion_aviso1 AS justificacion_aviso1_6, t0.justificacion_aviso2 AS justificacion_aviso2_7, t0.justificacion_aviso3 AS justificacion_aviso3_8 FROM globales t0 LIMIT 1
SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = ? AND f0_.fecha LIKE ? ORDER BY f0_.fecha ASC LIMIT 1
SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = ? AND f0_.fecha LIKE ? ORDER BY f0_.fecha ASC LIMIT 1
SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = ? AND f0_.fecha LIKE ? AND f0_.fecha > ? ORDER BY f0_.fecha ASC LIMIT 1
SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = ? AND f0_.fecha LIKE ? AND f0_.fecha > ? ORDER BY f0_.fecha ASC LIMIT 1
SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = ? AND f0_.fecha LIKE ? ORDER BY f0_.fecha ASC LIMIT 1
SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = ? AND f0_.fecha LIKE ? AND f0_.fecha > ? ORDER BY f0_.fecha ASC LIMIT 1
SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = ? AND f0_.fecha LIKE ? AND f0_.fecha > ? ORDER BY f0_.fecha ASC LIMIT 1
SELECT t0.id AS id_1, t0.descripcion AS descripcion_2 FROM tipo_notificacion t0 WHERE t0.descripcion = ? LIMIT 1
SELECT u0_.id AS id_0, u0_.email AS email_1, u0_.roles AS roles_2, u0_.password AS password_3, u0_.is_verified AS is_verified_4, u0_.nombre AS nombre_5, u0_.habilitado AS habilitado_6, u0_.empleada_id AS empleada_id_7, u0_.contacto_id AS contacto_id_8, u0_.contacto_proveedor_id AS contacto_proveedor_id_9 FROM usuario u0_ WHERE u0_.roles LIKE ?
"START TRANSACTION"
INSERT INTO notificacion (fecha, textoes, textoeus, leido, objeto, destinatario_id, tipo_id) VALUES (?, ?, ?, ?, ?, ?, ?)
INSERT INTO notificacion (fecha, textoes, textoeus, leido, objeto, destinatario_id, tipo_id) VALUES (?, ?, ?, ?, ?, ?, ?)
INSERT INTO notificacion (fecha, textoes, textoeus, leido, objeto, destinatario_id, tipo_id) VALUES (?, ?, ?, ?, ?, ?, ?)
INSERT INTO notificacion (fecha, textoes, textoeus, leido, objeto, destinatario_id, tipo_id) VALUES (?, ?, ?, ?, ?, ?, ?)
"COMMIT"
SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = ? AND f0_.fecha LIKE ? ORDER BY f0_.fecha ASC LIMIT 1
SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = ? AND f0_.fecha LIKE ? ORDER BY f0_.fecha ASC LIMIT 1
SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = ? AND f0_.fecha LIKE ? AND f0_.fecha > ? ORDER BY f0_.fecha ASC LIMIT 1
SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = ? AND f0_.fecha LIKE ? AND f0_.fecha > ? ORDER BY f0_.fecha ASC LIMIT 1
SELECT t0.id AS id_1, t0.descripcion AS descripcion_2 FROM tipo_notificacion t0 WHERE t0.descripcion = ? LIMIT 1
SELECT u0_.id AS id_0, u0_.email AS email_1, u0_.roles AS roles_2, u0_.password AS password_3, u0_.is_verified AS is_verified_4, u0_.nombre AS nombre_5, u0_.habilitado AS habilitado_6, u0_.empleada_id AS empleada_id_7, u0_.contacto_id AS contacto_id_8, u0_.contacto_proveedor_id AS contacto_proveedor_id_9 FROM usuario u0_ WHERE u0_.roles LIKE ?
"START TRANSACTION"
INSERT INTO notificacion (fecha, textoes, textoeus, leido, objeto, destinatario_id, tipo_id) VALUES (?, ?, ?, ?, ?, ?, ?)
INSERT INTO notificacion (fecha, textoes, textoeus, leido, objeto, destinatario_id, tipo_id) VALUES (?, ?, ?, ?, ?, ?, ?)
INSERT INTO notificacion (fecha, textoes, textoeus, leido, objeto, destinatario_id, tipo_id) VALUES (?, ?, ?, ?, ?, ?, ?)
INSERT INTO notificacion (fecha, textoes, textoeus, leido, objeto, destinatario_id, tipo_id) VALUES (?, ?, ?, ?, ?, ?, ?)
INSERT INTO notificacion (fecha, textoes, textoeus, leido, objeto, destinatario_id, tipo_id) VALUES (?, ?, ?, ?, ?, ?, ?)
"COMMIT"
SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = ? AND f0_.fecha LIKE ? ORDER BY f0_.fecha ASC LIMIT 1
SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = ? AND f0_.fecha LIKE ? AND f0_.fecha > ? ORDER BY f0_.fecha ASC LIMIT 1
SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = ? AND f0_.fecha LIKE ? AND f0_.fecha > ? ORDER BY f0_.fecha ASC LIMIT 1
SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = ? AND f0_.fecha LIKE ? ORDER BY f0_.fecha ASC LIMIT 1
SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = ? AND f0_.fecha LIKE ? ORDER BY f0_.fecha ASC LIMIT 1
SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = ? AND f0_.fecha LIKE ? AND f0_.fecha > ? ORDER BY f0_.fecha ASC LIMIT 1
SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = ? AND f0_.fecha LIKE ? AND f0_.fecha > ? ORDER BY f0_.fecha ASC LIMIT 1
SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = ? AND f0_.fecha LIKE ? ORDER BY f0_.fecha ASC LIMIT 1
SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = ? AND f0_.fecha LIKE ? AND f0_.fecha > ? ORDER BY f0_.fecha ASC LIMIT 1
SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = ? AND f0_.fecha LIKE ? AND f0_.fecha > ? ORDER BY f0_.fecha ASC LIMIT 1
SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = ? AND f0_.fecha LIKE ? ORDER BY f0_.fecha ASC LIMIT 1
SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = ? AND f0_.fecha LIKE ? AND f0_.fecha > ? ORDER BY f0_.fecha ASC LIMIT 1
SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = ? AND f0_.fecha LIKE ? AND f0_.fecha > ? ORDER BY f0_.fecha ASC LIMIT 1
SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = ? AND f0_.fecha LIKE ? ORDER BY f0_.fecha ASC LIMIT 1
SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = ? AND f0_.fecha LIKE ? AND f0_.fecha > ? ORDER BY f0_.fecha ASC LIMIT 1
SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = ? AND f0_.fecha LIKE ? AND f0_.fecha > ? ORDER BY f0_.fecha ASC LIMIT 1
SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = ? AND f0_.fecha LIKE ? ORDER BY f0_.fecha ASC LIMIT 1
SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = ? AND f0_.fecha LIKE ? ORDER BY f0_.fecha ASC LIMIT 1
SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = ? AND f0_.fecha LIKE ? ORDER BY f0_.fecha ASC LIMIT 1
SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = ? AND f0_.fecha LIKE ? ORDER BY f0_.fecha ASC LIMIT 1
SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = ? AND f0_.fecha LIKE ? ORDER BY f0_.fecha ASC LIMIT 1
SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = ? AND f0_.fecha LIKE ? AND f0_.fecha > ? ORDER BY f0_.fecha ASC LIMIT 1
SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = ? AND f0_.fecha LIKE ? AND f0_.fecha > ? ORDER BY f0_.fecha ASC LIMIT 1
SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = ? AND f0_.fecha LIKE ? ORDER BY f0_.fecha ASC LIMIT 1
SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = ? AND f0_.fecha LIKE ? AND f0_.fecha > ? ORDER BY f0_.fecha ASC LIMIT 1
SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = ? AND f0_.fecha LIKE ? AND f0_.fecha > ? ORDER BY f0_.fecha ASC LIMIT 1
SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = ? AND f0_.fecha LIKE ? ORDER BY f0_.fecha ASC LIMIT 1
SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = ? AND f0_.fecha LIKE ? AND f0_.fecha > ? ORDER BY f0_.fecha ASC LIMIT 1
SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = ? AND f0_.fecha LIKE ? AND f0_.fecha > ? ORDER BY f0_.fecha ASC LIMIT 1
SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = ? AND f0_.fecha LIKE ? AND f0_.fecha > ? ORDER BY f0_.fecha ASC LIMIT 1
SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = ? AND f0_.fecha LIKE ? AND f0_.fecha > ? ORDER BY f0_.fecha ASC LIMIT 1
SELECT t0.id AS id_1, t0.descripcion AS descripcion_2 FROM tipo_notificacion t0 WHERE t0.descripcion = ? LIMIT 1
SELECT u0_.id AS id_0, u0_.email AS email_1, u0_.roles AS roles_2, u0_.password AS password_3, u0_.is_verified AS is_verified_4, u0_.nombre AS nombre_5, u0_.habilitado AS habilitado_6, u0_.empleada_id AS empleada_id_7, u0_.contacto_id AS contacto_id_8, u0_.contacto_proveedor_id AS contacto_proveedor_id_9 FROM usuario u0_ WHERE u0_.roles LIKE ?
"START TRANSACTION"
INSERT INTO notificacion (fecha, textoes, textoeus, leido, objeto, destinatario_id, tipo_id) VALUES (?, ?, ?, ?, ?, ?, ?)
INSERT INTO notificacion (fecha, textoes, textoeus, leido, objeto, destinatario_id, tipo_id) VALUES (?, ?, ?, ?, ?, ?, ?)
INSERT INTO notificacion (fecha, textoes, textoeus, leido, objeto, destinatario_id, tipo_id) VALUES (?, ?, ?, ?, ?, ?, ?)
INSERT INTO notificacion (fecha, textoes, textoeus, leido, objeto, destinatario_id, tipo_id) VALUES (?, ?, ?, ?, ?, ?, ?)
INSERT INTO notificacion (fecha, textoes, textoeus, leido, objeto, destinatario_id, tipo_id) VALUES (?, ?, ?, ?, ?, ?, ?)
"COMMIT"
SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = ? AND f0_.fecha LIKE ? ORDER BY f0_.fecha ASC LIMIT 1
SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = ? AND f0_.fecha LIKE ? ORDER BY f0_.fecha ASC LIMIT 1
SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = ? AND f0_.fecha LIKE ? AND f0_.fecha > ? ORDER BY f0_.fecha ASC LIMIT 1
SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = ? AND f0_.fecha LIKE ? AND f0_.fecha > ? ORDER BY f0_.fecha ASC LIMIT 1
SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = ? AND f0_.fecha LIKE ? ORDER BY f0_.fecha ASC LIMIT 1
SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = ? AND f0_.fecha LIKE ? AND f0_.fecha > ? ORDER BY f0_.fecha ASC LIMIT 1
SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = ? AND f0_.fecha LIKE ? AND f0_.fecha > ? ORDER BY f0_.fecha ASC LIMIT 1
SELECT t0.id AS id_1, t0.descripcion AS descripcion_2 FROM tipo_notificacion t0 WHERE t0.descripcion = ? LIMIT 1
SELECT u0_.id AS id_0, u0_.email AS email_1, u0_.roles AS roles_2, u0_.password AS password_3, u0_.is_verified AS is_verified_4, u0_.nombre AS nombre_5, u0_.habilitado AS habilitado_6, u0_.empleada_id AS empleada_id_7, u0_.contacto_id AS contacto_id_8, u0_.contacto_proveedor_id AS contacto_proveedor_id_9 FROM usuario u0_ WHERE u0_.roles LIKE ?
"START TRANSACTION"
INSERT INTO notificacion (fecha, textoes, textoeus, leido, objeto, destinatario_id, tipo_id) VALUES (?, ?, ?, ?, ?, ?, ?)
INSERT INTO notificacion (fecha, textoes, textoeus, leido, objeto, destinatario_id, tipo_id) VALUES (?, ?, ?, ?, ?, ?, ?)
INSERT INTO notificacion (fecha, textoes, textoeus, leido, objeto, destinatario_id, tipo_id) VALUES (?, ?, ?, ?, ?, ?, ?)
INSERT INTO notificacion (fecha, textoes, textoeus, leido, objeto, destinatario_id, tipo_id) VALUES (?, ?, ?, ?, ?, ?, ?)
INSERT INTO notificacion (fecha, textoes, textoeus, leido, objeto, destinatario_id, tipo_id) VALUES (?, ?, ?, ?, ?, ?, ?)
"COMMIT"
SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = ? AND f0_.fecha LIKE ? ORDER BY f0_.fecha ASC LIMIT 1
SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = ? AND f0_.fecha LIKE ? ORDER BY f0_.fecha ASC LIMIT 1
SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = ? AND f0_.fecha LIKE ? ORDER BY f0_.fecha ASC LIMIT 1
SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = ? AND f0_.fecha LIKE ? ORDER BY f0_.fecha ASC LIMIT 1
SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = ? AND f0_.fecha LIKE ? ORDER BY f0_.fecha ASC LIMIT 1
SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = ? AND f0_.fecha LIKE ? ORDER BY f0_.fecha ASC LIMIT 1
SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = ? AND f0_.fecha LIKE ? ORDER BY f0_.fecha ASC LIMIT 1
SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = ? AND f0_.fecha LIKE ? AND f0_.fecha > ? ORDER BY f0_.fecha ASC LIMIT 1
SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = ? AND f0_.fecha LIKE ? AND f0_.fecha > ? ORDER BY f0_.fecha ASC LIMIT 1
SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = ? AND f0_.fecha LIKE ? ORDER BY f0_.fecha ASC LIMIT 1
SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = ? AND f0_.fecha LIKE ? ORDER BY f0_.fecha ASC LIMIT 1
SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = ? AND f0_.fecha LIKE ? ORDER BY f0_.fecha ASC LIMIT 1
SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = ? AND f0_.fecha LIKE ? AND f0_.fecha > ? ORDER BY f0_.fecha ASC LIMIT 1
SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = ? AND f0_.fecha LIKE ? AND f0_.fecha > ? ORDER BY f0_.fecha ASC LIMIT 1
SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = ? AND f0_.fecha LIKE ? ORDER BY f0_.fecha ASC LIMIT 1
SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = ? AND f0_.fecha LIKE ? ORDER BY f0_.fecha ASC LIMIT 1
SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = ? AND f0_.fecha LIKE ? ORDER BY f0_.fecha ASC LIMIT 1
SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = ? AND f0_.fecha LIKE ? AND f0_.fecha > ? ORDER BY f0_.fecha ASC LIMIT 1
SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = ? AND f0_.fecha LIKE ? AND f0_.fecha > ? ORDER BY f0_.fecha ASC LIMIT 1
SELECT t0.id AS id_1, t0.hora_inicio AS hora_inicio_2, t0.hora_fin AS hora_fin_3, t0.hora_aviso_max AS hora_aviso_max_4, t0.hora_aviso_min AS hora_aviso_min_5, t0.justificacion_aviso1 AS justificacion_aviso1_6, t0.justificacion_aviso2 AS justificacion_aviso2_7, t0.justificacion_aviso3 AS justificacion_aviso3_8 FROM globales t0 LIMIT 1
SELECT t0.id AS id_1, t0.descripcion AS descripcion_2 FROM tipo_notificacion t0 WHERE t0.descripcion = ? LIMIT 1
SELECT t0.id AS id_1, t0.descripcion AS descripcion_2 FROM tipo_notificacion t0 WHERE t0.descripcion = ? LIMIT 1
SELECT t0.id AS id_1, t0.descripcion AS descripcion_2 FROM tipo_notificacion t0 WHERE t0.descripcion = ? LIMIT 1
SELECT t0.id AS id_1, t0.fecha AS fecha_2, t0.nombre AS nombre_3, t0.presentada AS presentada_4, t0.observaciones AS observaciones_5, t0.fecha_presentada AS fecha_presentada_6, t0.proyecto_id AS proyecto_id_7 FROM justificacion t0 WHERE t0.presentada = ?
SELECT u0_.id AS id_0, u0_.email AS email_1, u0_.roles AS roles_2, u0_.password AS password_3, u0_.is_verified AS is_verified_4, u0_.nombre AS nombre_5, u0_.habilitado AS habilitado_6, u0_.empleada_id AS empleada_id_7, u0_.contacto_id AS contacto_id_8, u0_.contacto_proveedor_id AS contacto_proveedor_id_9 FROM usuario u0_ WHERE u0_.roles LIKE ?
SELECT t0.id AS id_1, t0.descripcion AS descripcion_2 FROM tipo_notificacion t0 WHERE t0.descripcion = ? LIMIT 1
SELECT t0.id AS id_1, t0.descripcion AS descripcion_2 FROM tipo_notificacion t0 WHERE t0.descripcion = ? LIMIT 1
SELECT t0.id AS id_1, t0.descripcion AS descripcion_2 FROM tipo_notificacion t0 WHERE t0.descripcion = ? LIMIT 1
SELECT t0.id AS id_1, t0.fecha AS fecha_2, t0.textoes AS textoes_3, t0.textoeus AS textoeus_4, t0.leido AS leido_5, t0.objeto AS objeto_6, t0.destinatario_id AS destinatario_id_7, t0.tipo_id AS tipo_id_8 FROM notificacion t0 WHERE t0.tipo_id = ? AND t0.fecha = ? AND t0.destinatario_id = ? ORDER BY t0.fecha DESC
SELECT t0.id AS id_1, t0.fecha AS fecha_2, t0.textoes AS textoes_3, t0.textoeus AS textoeus_4, t0.leido AS leido_5, t0.objeto AS objeto_6, t0.destinatario_id AS destinatario_id_7, t0.tipo_id AS tipo_id_8 FROM notificacion t0 WHERE t0.tipo_id = ? AND t0.fecha = ? AND t0.destinatario_id = ? ORDER BY t0.fecha DESC
SELECT t0.id AS id_1, t0.fecha AS fecha_2, t0.textoes AS textoes_3, t0.textoeus AS textoeus_4, t0.leido AS leido_5, t0.objeto AS objeto_6, t0.destinatario_id AS destinatario_id_7, t0.tipo_id AS tipo_id_8 FROM notificacion t0 WHERE t0.tipo_id = ? AND t0.fecha = ? AND t0.destinatario_id = ? ORDER BY t0.fecha DESC
SELECT n0_.id AS id_0, n0_.fecha AS fecha_1, n0_.textoes AS textoes_2, n0_.textoeus AS textoeus_3, n0_.leido AS leido_4, n0_.objeto AS objeto_5, n0_.destinatario_id AS destinatario_id_6, n0_.tipo_id AS tipo_id_7 FROM notificacion n0_ INNER JOIN tipo_notificacion t1_ ON n0_.tipo_id = t1_.id WHERE t1_.descripcion LIKE ? AND n0_.destinatario_id = ? AND n0_.fecha = ? ORDER BY n0_.fecha DESC
SELECT t0.id AS id_1, t0.fecha AS fecha_2, t0.textoes AS textoes_3, t0.textoeus AS textoeus_4, t0.leido AS leido_5, t0.objeto AS objeto_6, t0.destinatario_id AS destinatario_id_7, t0.tipo_id AS tipo_id_8 FROM notificacion t0 WHERE t0.tipo_id = ? AND t0.fecha = ? AND t0.destinatario_id = ? ORDER BY t0.fecha DESC
SELECT t0.id AS id_1, t0.fecha AS fecha_2, t0.textoes AS textoes_3, t0.textoeus AS textoeus_4, t0.leido AS leido_5, t0.objeto AS objeto_6, t0.destinatario_id AS destinatario_id_7, t0.tipo_id AS tipo_id_8 FROM notificacion t0 WHERE t0.tipo_id = ? AND t0.fecha = ? AND t0.destinatario_id = ? ORDER BY t0.fecha DESC
SELECT t0.id AS id_1, t0.fecha AS fecha_2, t0.textoes AS textoes_3, t0.textoeus AS textoeus_4, t0.leido AS leido_5, t0.objeto AS objeto_6, t0.destinatario_id AS destinatario_id_7, t0.tipo_id AS tipo_id_8 FROM notificacion t0 WHERE t0.tipo_id = ? AND t0.fecha = ? AND t0.destinatario_id = ? ORDER BY t0.fecha DESC
SELECT n0_.id AS id_0, n0_.fecha AS fecha_1, n0_.textoes AS textoes_2, n0_.textoeus AS textoeus_3, n0_.leido AS leido_4, n0_.objeto AS objeto_5, n0_.destinatario_id AS destinatario_id_6, n0_.tipo_id AS tipo_id_7 FROM notificacion n0_ INNER JOIN tipo_notificacion t1_ ON n0_.tipo_id = t1_.id WHERE t1_.descripcion LIKE ? AND n0_.destinatario_id = ? AND n0_.fecha = ? ORDER BY n0_.fecha DESC
SELECT t0.id AS id_1, t0.fecha AS fecha_2, t0.textoes AS textoes_3, t0.textoeus AS textoeus_4, t0.leido AS leido_5, t0.objeto AS objeto_6, t0.destinatario_id AS destinatario_id_7, t0.tipo_id AS tipo_id_8 FROM notificacion t0 WHERE t0.tipo_id = ? AND t0.fecha = ? AND t0.destinatario_id = ? ORDER BY t0.fecha DESC
SELECT t0.id AS id_1, t0.fecha AS fecha_2, t0.textoes AS textoes_3, t0.textoeus AS textoeus_4, t0.leido AS leido_5, t0.objeto AS objeto_6, t0.destinatario_id AS destinatario_id_7, t0.tipo_id AS tipo_id_8 FROM notificacion t0 WHERE t0.tipo_id = ? AND t0.fecha = ? AND t0.destinatario_id = ? ORDER BY t0.fecha DESC
SELECT t0.id AS id_1, t0.fecha AS fecha_2, t0.textoes AS textoes_3, t0.textoeus AS textoeus_4, t0.leido AS leido_5, t0.objeto AS objeto_6, t0.destinatario_id AS destinatario_id_7, t0.tipo_id AS tipo_id_8 FROM notificacion t0 WHERE t0.tipo_id = ? AND t0.fecha = ? AND t0.destinatario_id = ? ORDER BY t0.fecha DESC
SELECT n0_.id AS id_0, n0_.fecha AS fecha_1, n0_.textoes AS textoes_2, n0_.textoeus AS textoeus_3, n0_.leido AS leido_4, n0_.objeto AS objeto_5, n0_.destinatario_id AS destinatario_id_6, n0_.tipo_id AS tipo_id_7 FROM notificacion n0_ INNER JOIN tipo_notificacion t1_ ON n0_.tipo_id = t1_.id WHERE t1_.descripcion LIKE ? AND n0_.destinatario_id = ? AND n0_.fecha = ? ORDER BY n0_.fecha DESC
SELECT t0.id AS id_1, t0.fecha AS fecha_2, t0.textoes AS textoes_3, t0.textoeus AS textoeus_4, t0.leido AS leido_5, t0.objeto AS objeto_6, t0.destinatario_id AS destinatario_id_7, t0.tipo_id AS tipo_id_8 FROM notificacion t0 WHERE t0.tipo_id = ? AND t0.fecha = ? AND t0.destinatario_id = ? ORDER BY t0.fecha DESC
SELECT t0.id AS id_1, t0.fecha AS fecha_2, t0.textoes AS textoes_3, t0.textoeus AS textoeus_4, t0.leido AS leido_5, t0.objeto AS objeto_6, t0.destinatario_id AS destinatario_id_7, t0.tipo_id AS tipo_id_8 FROM notificacion t0 WHERE t0.tipo_id = ? AND t0.fecha = ? AND t0.destinatario_id = ? ORDER BY t0.fecha DESC
SELECT t0.id AS id_1, t0.fecha AS fecha_2, t0.textoes AS textoes_3, t0.textoeus AS textoeus_4, t0.leido AS leido_5, t0.objeto AS objeto_6, t0.destinatario_id AS destinatario_id_7, t0.tipo_id AS tipo_id_8 FROM notificacion t0 WHERE t0.tipo_id = ? AND t0.fecha = ? AND t0.destinatario_id = ? ORDER BY t0.fecha DESC
SELECT n0_.id AS id_0, n0_.fecha AS fecha_1, n0_.textoes AS textoes_2, n0_.textoeus AS textoeus_3, n0_.leido AS leido_4, n0_.objeto AS objeto_5, n0_.destinatario_id AS destinatario_id_6, n0_.tipo_id AS tipo_id_7 FROM notificacion n0_ INNER JOIN tipo_notificacion t1_ ON n0_.tipo_id = t1_.id WHERE t1_.descripcion LIKE ? AND n0_.destinatario_id = ? AND n0_.fecha = ? ORDER BY n0_.fecha DESC

#▲	Time	Info
1	1.43 ms	SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.email AS email_3, t0.telefono AS telefono_4, t0.habilitado AS habilitado_5, t0.rango_salarial_id AS rango_salarial_id_6, t7.id AS id_8, t7.email AS email_9, t7.roles AS roles_10, t7.password AS password_11, t7.is_verified AS is_verified_12, t7.nombre AS nombre_13, t7.habilitado AS habilitado_14, t7.empleada_id AS empleada_id_15, t7.contacto_id AS contacto_id_16, t7.contacto_proveedor_id AS contacto_proveedor_id_17 FROM empleada t0 LEFT JOIN usuario t7 ON t7.empleada_id = t0.id Parameters: [] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.email AS email_3, t0.telefono AS telefono_4, t0.habilitado AS habilitado_5, t0.rango_salarial_id AS rango_salarial_id_6, t7.id AS id_8, t7.email AS email_9, t7.roles AS roles_10, t7.password AS password_11, t7.is_verified AS is_verified_12, t7.nombre AS nombre_13, t7.habilitado AS habilitado_14, t7.empleada_id AS empleada_id_15, t7.contacto_id AS contacto_id_16, t7.contacto_proveedor_id AS contacto_proveedor_id_17 FROM empleada t0 LEFT JOIN usuario t7 ON t7.empleada_id = t0.id SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.email AS email_3, t0.telefono AS telefono_4, t0.habilitado AS habilitado_5, t0.rango_salarial_id AS rango_salarial_id_6, t7.id AS id_8, t7.email AS email_9, t7.roles AS roles_10, t7.password AS password_11, t7.is_verified AS is_verified_12, t7.nombre AS nombre_13, t7.habilitado AS habilitado_14, t7.empleada_id AS empleada_id_15, t7.contacto_id AS contacto_id_16, t7.contacto_proveedor_id AS contacto_proveedor_id_17 FROM empleada t0 LEFT JOIN usuario t7 ON t7.empleada_id = t0.id;
2	0.55 ms	SELECT t0.id AS id_1, t0.hora_inicio AS hora_inicio_2, t0.hora_fin AS hora_fin_3, t0.hora_aviso_max AS hora_aviso_max_4, t0.hora_aviso_min AS hora_aviso_min_5, t0.justificacion_aviso1 AS justificacion_aviso1_6, t0.justificacion_aviso2 AS justificacion_aviso2_7, t0.justificacion_aviso3 AS justificacion_aviso3_8 FROM globales t0 LIMIT 1 Parameters: [] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.hora_inicio AS hora_inicio_2, t0.hora_fin AS hora_fin_3, t0.hora_aviso_max AS hora_aviso_max_4, t0.hora_aviso_min AS hora_aviso_min_5, t0.justificacion_aviso1 AS justificacion_aviso1_6, t0.justificacion_aviso2 AS justificacion_aviso2_7, t0.justificacion_aviso3 AS justificacion_aviso3_8 FROM globales t0 LIMIT 1 SELECT t0.id AS id_1, t0.hora_inicio AS hora_inicio_2, t0.hora_fin AS hora_fin_3, t0.hora_aviso_max AS hora_aviso_max_4, t0.hora_aviso_min AS hora_aviso_min_5, t0.justificacion_aviso1 AS justificacion_aviso1_6, t0.justificacion_aviso2 AS justificacion_aviso2_7, t0.justificacion_aviso3 AS justificacion_aviso3_8 FROM globales t0 LIMIT 1;
3	2.33 ms	SELECT t0.id AS id_1, t0.fecha AS fecha_2, t0.entrada AS entrada_3, t0.empleada_id AS empleada_id_4 FROM fichaje_diario t0 WHERE t0.empleada_id = ? ORDER BY t0.fecha DESC LIMIT 1 Parameters: [`1`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.fecha AS fecha_2, t0.entrada AS entrada_3, t0.empleada_id AS empleada_id_4 FROM fichaje_diario t0 WHERE t0.empleada_id = ? ORDER BY t0.fecha DESC LIMIT 1 SELECT t0.id AS id_1, t0.fecha AS fecha_2, t0.entrada AS entrada_3, t0.empleada_id AS empleada_id_4 FROM fichaje_diario t0 WHERE t0.empleada_id = 1 ORDER BY t0.fecha DESC LIMIT 1;
4	7.05 ms	SELECT t0.id AS id_1, t0.fecha AS fecha_2, t0.entrada AS entrada_3, t0.empleada_id AS empleada_id_4 FROM fichaje_diario t0 WHERE t0.empleada_id = ? ORDER BY t0.fecha DESC LIMIT 1 Parameters: [`2`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.fecha AS fecha_2, t0.entrada AS entrada_3, t0.empleada_id AS empleada_id_4 FROM fichaje_diario t0 WHERE t0.empleada_id = ? ORDER BY t0.fecha DESC LIMIT 1 SELECT t0.id AS id_1, t0.fecha AS fecha_2, t0.entrada AS entrada_3, t0.empleada_id AS empleada_id_4 FROM fichaje_diario t0 WHERE t0.empleada_id = 2 ORDER BY t0.fecha DESC LIMIT 1;
5	6.13 ms	SELECT t0.id AS id_1, t0.fecha AS fecha_2, t0.entrada AS entrada_3, t0.empleada_id AS empleada_id_4 FROM fichaje_diario t0 WHERE t0.empleada_id = ? ORDER BY t0.fecha DESC LIMIT 1 Parameters: [`3`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.fecha AS fecha_2, t0.entrada AS entrada_3, t0.empleada_id AS empleada_id_4 FROM fichaje_diario t0 WHERE t0.empleada_id = ? ORDER BY t0.fecha DESC LIMIT 1 SELECT t0.id AS id_1, t0.fecha AS fecha_2, t0.entrada AS entrada_3, t0.empleada_id AS empleada_id_4 FROM fichaje_diario t0 WHERE t0.empleada_id = 3 ORDER BY t0.fecha DESC LIMIT 1;
6	0.10 ms	"START TRANSACTION" Parameters: [] View formatted query View runnable query Explain query "START TRANSACTION" "START TRANSACTION";
7	0.28 ms	INSERT INTO fichaje_diario (fecha, entrada, empleada_id) VALUES (?, ?, ?) Parameters: [`1 => "2025-05-15 21:00:00" 2 => 0 3 => 3`] View formatted query View runnable query Explain query INSERT INTO fichaje_diario (fecha, entrada, empleada_id) VALUES (?, ?, ?) INSERT INTO fichaje_diario (fecha, entrada, empleada_id) VALUES ('2025-05-15 21:00:00', 0, 3);
8	1.56 ms	"COMMIT" Parameters: [] View formatted query View runnable query Explain query "COMMIT" "COMMIT";
9	0.25 ms	SELECT t0.id AS id_1, t0.descripcion AS descripcion_2 FROM tipo_notificacion t0 WHERE t0.descripcion = ? LIMIT 1 Parameters: [`"tipoNotificacion.fichajeNoCerrado"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.descripcion AS descripcion_2 FROM tipo_notificacion t0 WHERE t0.descripcion = ? LIMIT 1 SELECT t0.id AS id_1, t0.descripcion AS descripcion_2 FROM tipo_notificacion t0 WHERE t0.descripcion = 'tipoNotificacion.fichajeNoCerrado' LIMIT 1;
10	0.37 ms	SELECT u0_.id AS id_0, u0_.email AS email_1, u0_.roles AS roles_2, u0_.password AS password_3, u0_.is_verified AS is_verified_4, u0_.nombre AS nombre_5, u0_.habilitado AS habilitado_6, u0_.empleada_id AS empleada_id_7, u0_.contacto_id AS contacto_id_8, u0_.contacto_proveedor_id AS contacto_proveedor_id_9 FROM usuario u0_ WHERE u0_.roles LIKE ? Parameters: [`"%"ROLE_ADMIN"%"`] View formatted query View runnable query Explain query SELECT u0_.id AS id_0, u0_.email AS email_1, u0_.roles AS roles_2, u0_.password AS password_3, u0_.is_verified AS is_verified_4, u0_.nombre AS nombre_5, u0_.habilitado AS habilitado_6, u0_.empleada_id AS empleada_id_7, u0_.contacto_id AS contacto_id_8, u0_.contacto_proveedor_id AS contacto_proveedor_id_9 FROM usuario u0_ WHERE u0_.roles LIKE ? SELECT u0_.id AS id_0, u0_.email AS email_1, u0_.roles AS roles_2, u0_.password AS password_3, u0_.is_verified AS is_verified_4, u0_.nombre AS nombre_5, u0_.habilitado AS habilitado_6, u0_.empleada_id AS empleada_id_7, u0_.contacto_id AS contacto_id_8, u0_.contacto_proveedor_id AS contacto_proveedor_id_9 FROM usuario u0_ WHERE u0_.roles LIKE '%\"ROLE_ADMIN\"%';
11	0.09 ms	"START TRANSACTION" Parameters: [] View formatted query View runnable query Explain query "START TRANSACTION" "START TRANSACTION";
12	1.32 ms	INSERT INTO notificacion (fecha, textoes, textoeus, leido, objeto, destinatario_id, tipo_id) VALUES (?, ?, ?, ?, ?, ?, ?) Parameters: [`1 => "2025-05-15" 2 => "Se ha cerrado un fichaje para Maria Alonso con fecha: 2025-05-15" 3 => "Fitxaje bat ixti da Maria Alonso-rentzat 15-05-2025 datarekin" 4 => 0 5 => 3 6 => 3 7 => 3`] View formatted query View runnable query Explain query INSERT INTO notificacion ( fecha, textoes, textoeus, leido, objeto, destinatario_id, tipo_id ) VALUES (?, ?, ?, ?, ?, ?, ?) INSERT INTO notificacion (fecha, textoes, textoeus, leido, objeto, destinatario_id, tipo_id) VALUES ('2025-05-15', 'Se ha cerrado un fichaje para Maria Alonso con fecha: 2025-05-15', 'Fitxaje bat ixti da Maria Alonso-rentzat 15-05-2025 datarekin', 0, 3, 3, 3);
13	0.19 ms	INSERT INTO notificacion (fecha, textoes, textoeus, leido, objeto, destinatario_id, tipo_id) VALUES (?, ?, ?, ?, ?, ?, ?) Parameters: [`1 => "2025-05-15" 2 => "Se ha cerrado un fichaje para Maria Alonso con fecha: 2025-05-15" 3 => "Fitxaje bat ixti da Maria Alonso-rentzat 15-05-2025 datarekin" 4 => 0 5 => 3 6 => 1 7 => 3`] View formatted query View runnable query Explain query INSERT INTO notificacion ( fecha, textoes, textoeus, leido, objeto, destinatario_id, tipo_id ) VALUES (?, ?, ?, ?, ?, ?, ?) INSERT INTO notificacion (fecha, textoes, textoeus, leido, objeto, destinatario_id, tipo_id) VALUES ('2025-05-15', 'Se ha cerrado un fichaje para Maria Alonso con fecha: 2025-05-15', 'Fitxaje bat ixti da Maria Alonso-rentzat 15-05-2025 datarekin', 0, 3, 1, 3);
14	0.15 ms	INSERT INTO notificacion (fecha, textoes, textoeus, leido, objeto, destinatario_id, tipo_id) VALUES (?, ?, ?, ?, ?, ?, ?) Parameters: [`1 => "2025-05-15" 2 => "Se ha cerrado un fichaje para Maria Alonso con fecha: 2025-05-15" 3 => "Fitxaje bat ixti da Maria Alonso-rentzat 15-05-2025 datarekin" 4 => 0 5 => 3 6 => 2 7 => 3`] View formatted query View runnable query Explain query INSERT INTO notificacion ( fecha, textoes, textoeus, leido, objeto, destinatario_id, tipo_id ) VALUES (?, ?, ?, ?, ?, ?, ?) INSERT INTO notificacion (fecha, textoes, textoeus, leido, objeto, destinatario_id, tipo_id) VALUES ('2025-05-15', 'Se ha cerrado un fichaje para Maria Alonso con fecha: 2025-05-15', 'Fitxaje bat ixti da Maria Alonso-rentzat 15-05-2025 datarekin', 0, 3, 2, 3);
15	0.17 ms	INSERT INTO notificacion (fecha, textoes, textoeus, leido, objeto, destinatario_id, tipo_id) VALUES (?, ?, ?, ?, ?, ?, ?) Parameters: [`1 => "2025-05-15" 2 => "Se ha cerrado un fichaje para Maria Alonso con fecha: 2025-05-15" 3 => "Fitxaje bat ixti da Maria Alonso-rentzat 15-05-2025 datarekin" 4 => 0 5 => 3 6 => 4 7 => 3`] View formatted query View runnable query Explain query INSERT INTO notificacion ( fecha, textoes, textoeus, leido, objeto, destinatario_id, tipo_id ) VALUES (?, ?, ?, ?, ?, ?, ?) INSERT INTO notificacion (fecha, textoes, textoeus, leido, objeto, destinatario_id, tipo_id) VALUES ('2025-05-15', 'Se ha cerrado un fichaje para Maria Alonso con fecha: 2025-05-15', 'Fitxaje bat ixti da Maria Alonso-rentzat 15-05-2025 datarekin', 0, 3, 4, 3);
16	1.36 ms	"COMMIT" Parameters: [] View formatted query View runnable query Explain query "COMMIT" "COMMIT";
17	2.01 ms	SELECT t0.id AS id_1, t0.fecha AS fecha_2, t0.entrada AS entrada_3, t0.empleada_id AS empleada_id_4 FROM fichaje_diario t0 WHERE t0.empleada_id = ? ORDER BY t0.fecha DESC LIMIT 1 Parameters: [`4`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.fecha AS fecha_2, t0.entrada AS entrada_3, t0.empleada_id AS empleada_id_4 FROM fichaje_diario t0 WHERE t0.empleada_id = ? ORDER BY t0.fecha DESC LIMIT 1 SELECT t0.id AS id_1, t0.fecha AS fecha_2, t0.entrada AS entrada_3, t0.empleada_id AS empleada_id_4 FROM fichaje_diario t0 WHERE t0.empleada_id = 4 ORDER BY t0.fecha DESC LIMIT 1;
18	2.85 ms	SELECT t0.id AS id_1, t0.fecha AS fecha_2, t0.entrada AS entrada_3, t0.empleada_id AS empleada_id_4 FROM fichaje_diario t0 WHERE t0.empleada_id = ? ORDER BY t0.fecha DESC LIMIT 1 Parameters: [`6`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.fecha AS fecha_2, t0.entrada AS entrada_3, t0.empleada_id AS empleada_id_4 FROM fichaje_diario t0 WHERE t0.empleada_id = ? ORDER BY t0.fecha DESC LIMIT 1 SELECT t0.id AS id_1, t0.fecha AS fecha_2, t0.entrada AS entrada_3, t0.empleada_id AS empleada_id_4 FROM fichaje_diario t0 WHERE t0.empleada_id = 6 ORDER BY t0.fecha DESC LIMIT 1;
19	1.00 ms	SELECT t0.id AS id_1, t0.fecha AS fecha_2, t0.entrada AS entrada_3, t0.empleada_id AS empleada_id_4 FROM fichaje_diario t0 WHERE t0.empleada_id = ? ORDER BY t0.fecha DESC LIMIT 1 Parameters: [`7`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.fecha AS fecha_2, t0.entrada AS entrada_3, t0.empleada_id AS empleada_id_4 FROM fichaje_diario t0 WHERE t0.empleada_id = ? ORDER BY t0.fecha DESC LIMIT 1 SELECT t0.id AS id_1, t0.fecha AS fecha_2, t0.entrada AS entrada_3, t0.empleada_id AS empleada_id_4 FROM fichaje_diario t0 WHERE t0.empleada_id = 7 ORDER BY t0.fecha DESC LIMIT 1;
20	1.06 ms	SELECT t0.id AS id_1, t0.fecha AS fecha_2, t0.entrada AS entrada_3, t0.empleada_id AS empleada_id_4 FROM fichaje_diario t0 WHERE t0.empleada_id = ? ORDER BY t0.fecha DESC LIMIT 1 Parameters: [`8`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.fecha AS fecha_2, t0.entrada AS entrada_3, t0.empleada_id AS empleada_id_4 FROM fichaje_diario t0 WHERE t0.empleada_id = ? ORDER BY t0.fecha DESC LIMIT 1 SELECT t0.id AS id_1, t0.fecha AS fecha_2, t0.entrada AS entrada_3, t0.empleada_id AS empleada_id_4 FROM fichaje_diario t0 WHERE t0.empleada_id = 8 ORDER BY t0.fecha DESC LIMIT 1;
21	1.74 ms	SELECT t0.id AS id_1, t0.fecha AS fecha_2, t0.entrada AS entrada_3, t0.empleada_id AS empleada_id_4 FROM fichaje_diario t0 WHERE t0.empleada_id = ? ORDER BY t0.fecha DESC LIMIT 1 Parameters: [`9`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.fecha AS fecha_2, t0.entrada AS entrada_3, t0.empleada_id AS empleada_id_4 FROM fichaje_diario t0 WHERE t0.empleada_id = ? ORDER BY t0.fecha DESC LIMIT 1 SELECT t0.id AS id_1, t0.fecha AS fecha_2, t0.entrada AS entrada_3, t0.empleada_id AS empleada_id_4 FROM fichaje_diario t0 WHERE t0.empleada_id = 9 ORDER BY t0.fecha DESC LIMIT 1;
22	1.35 ms	SELECT t0.id AS id_1, t0.fecha AS fecha_2, t0.entrada AS entrada_3, t0.empleada_id AS empleada_id_4 FROM fichaje_diario t0 WHERE t0.empleada_id = ? ORDER BY t0.fecha DESC LIMIT 1 Parameters: [`10`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.fecha AS fecha_2, t0.entrada AS entrada_3, t0.empleada_id AS empleada_id_4 FROM fichaje_diario t0 WHERE t0.empleada_id = ? ORDER BY t0.fecha DESC LIMIT 1 SELECT t0.id AS id_1, t0.fecha AS fecha_2, t0.entrada AS entrada_3, t0.empleada_id AS empleada_id_4 FROM fichaje_diario t0 WHERE t0.empleada_id = 10 ORDER BY t0.fecha DESC LIMIT 1;
23	2.74 ms	SELECT t0.id AS id_1, t0.fecha AS fecha_2, t0.entrada AS entrada_3, t0.empleada_id AS empleada_id_4 FROM fichaje_diario t0 WHERE t0.empleada_id = ? ORDER BY t0.fecha DESC LIMIT 1 Parameters: [`11`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.fecha AS fecha_2, t0.entrada AS entrada_3, t0.empleada_id AS empleada_id_4 FROM fichaje_diario t0 WHERE t0.empleada_id = ? ORDER BY t0.fecha DESC LIMIT 1 SELECT t0.id AS id_1, t0.fecha AS fecha_2, t0.entrada AS entrada_3, t0.empleada_id AS empleada_id_4 FROM fichaje_diario t0 WHERE t0.empleada_id = 11 ORDER BY t0.fecha DESC LIMIT 1;
24	2.97 ms	SELECT t0.id AS id_1, t0.fecha AS fecha_2, t0.entrada AS entrada_3, t0.empleada_id AS empleada_id_4 FROM fichaje_diario t0 WHERE t0.empleada_id = ? ORDER BY t0.fecha DESC LIMIT 1 Parameters: [`12`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.fecha AS fecha_2, t0.entrada AS entrada_3, t0.empleada_id AS empleada_id_4 FROM fichaje_diario t0 WHERE t0.empleada_id = ? ORDER BY t0.fecha DESC LIMIT 1 SELECT t0.id AS id_1, t0.fecha AS fecha_2, t0.entrada AS entrada_3, t0.empleada_id AS empleada_id_4 FROM fichaje_diario t0 WHERE t0.empleada_id = 12 ORDER BY t0.fecha DESC LIMIT 1;
25	0.96 ms	SELECT t0.id AS id_1, t0.fecha AS fecha_2, t0.entrada AS entrada_3, t0.empleada_id AS empleada_id_4 FROM fichaje_diario t0 WHERE t0.empleada_id = ? ORDER BY t0.fecha DESC LIMIT 1 Parameters: [`13`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.fecha AS fecha_2, t0.entrada AS entrada_3, t0.empleada_id AS empleada_id_4 FROM fichaje_diario t0 WHERE t0.empleada_id = ? ORDER BY t0.fecha DESC LIMIT 1 SELECT t0.id AS id_1, t0.fecha AS fecha_2, t0.entrada AS entrada_3, t0.empleada_id AS empleada_id_4 FROM fichaje_diario t0 WHERE t0.empleada_id = 13 ORDER BY t0.fecha DESC LIMIT 1;
26	1.85 ms	SELECT t0.id AS id_1, t0.fecha AS fecha_2, t0.entrada AS entrada_3, t0.empleada_id AS empleada_id_4 FROM fichaje_diario t0 WHERE t0.empleada_id = ? ORDER BY t0.fecha DESC LIMIT 1 Parameters: [`14`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.fecha AS fecha_2, t0.entrada AS entrada_3, t0.empleada_id AS empleada_id_4 FROM fichaje_diario t0 WHERE t0.empleada_id = ? ORDER BY t0.fecha DESC LIMIT 1 SELECT t0.id AS id_1, t0.fecha AS fecha_2, t0.entrada AS entrada_3, t0.empleada_id AS empleada_id_4 FROM fichaje_diario t0 WHERE t0.empleada_id = 14 ORDER BY t0.fecha DESC LIMIT 1;
27	1.78 ms	SELECT t0.id AS id_1, t0.fecha AS fecha_2, t0.entrada AS entrada_3, t0.empleada_id AS empleada_id_4 FROM fichaje_diario t0 WHERE t0.empleada_id = ? ORDER BY t0.fecha DESC LIMIT 1 Parameters: [`15`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.fecha AS fecha_2, t0.entrada AS entrada_3, t0.empleada_id AS empleada_id_4 FROM fichaje_diario t0 WHERE t0.empleada_id = ? ORDER BY t0.fecha DESC LIMIT 1 SELECT t0.id AS id_1, t0.fecha AS fecha_2, t0.entrada AS entrada_3, t0.empleada_id AS empleada_id_4 FROM fichaje_diario t0 WHERE t0.empleada_id = 15 ORDER BY t0.fecha DESC LIMIT 1;
28	1.66 ms	SELECT t0.id AS id_1, t0.fecha AS fecha_2, t0.entrada AS entrada_3, t0.empleada_id AS empleada_id_4 FROM fichaje_diario t0 WHERE t0.empleada_id = ? ORDER BY t0.fecha DESC LIMIT 1 Parameters: [`16`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.fecha AS fecha_2, t0.entrada AS entrada_3, t0.empleada_id AS empleada_id_4 FROM fichaje_diario t0 WHERE t0.empleada_id = ? ORDER BY t0.fecha DESC LIMIT 1 SELECT t0.id AS id_1, t0.fecha AS fecha_2, t0.entrada AS entrada_3, t0.empleada_id AS empleada_id_4 FROM fichaje_diario t0 WHERE t0.empleada_id = 16 ORDER BY t0.fecha DESC LIMIT 1;
29	1.37 ms	SELECT t0.id AS id_1, t0.fecha AS fecha_2, t0.entrada AS entrada_3, t0.empleada_id AS empleada_id_4 FROM fichaje_diario t0 WHERE t0.empleada_id = ? ORDER BY t0.fecha DESC LIMIT 1 Parameters: [`18`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.fecha AS fecha_2, t0.entrada AS entrada_3, t0.empleada_id AS empleada_id_4 FROM fichaje_diario t0 WHERE t0.empleada_id = ? ORDER BY t0.fecha DESC LIMIT 1 SELECT t0.id AS id_1, t0.fecha AS fecha_2, t0.entrada AS entrada_3, t0.empleada_id AS empleada_id_4 FROM fichaje_diario t0 WHERE t0.empleada_id = 18 ORDER BY t0.fecha DESC LIMIT 1;
30	1.84 ms	SELECT t0.id AS id_1, t0.fecha AS fecha_2, t0.entrada AS entrada_3, t0.empleada_id AS empleada_id_4 FROM fichaje_diario t0 WHERE t0.empleada_id = ? ORDER BY t0.fecha DESC LIMIT 1 Parameters: [`19`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.fecha AS fecha_2, t0.entrada AS entrada_3, t0.empleada_id AS empleada_id_4 FROM fichaje_diario t0 WHERE t0.empleada_id = ? ORDER BY t0.fecha DESC LIMIT 1 SELECT t0.id AS id_1, t0.fecha AS fecha_2, t0.entrada AS entrada_3, t0.empleada_id AS empleada_id_4 FROM fichaje_diario t0 WHERE t0.empleada_id = 19 ORDER BY t0.fecha DESC LIMIT 1;
31	1.76 ms	SELECT t0.id AS id_1, t0.fecha AS fecha_2, t0.entrada AS entrada_3, t0.empleada_id AS empleada_id_4 FROM fichaje_diario t0 WHERE t0.empleada_id = ? ORDER BY t0.fecha DESC LIMIT 1 Parameters: [`20`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.fecha AS fecha_2, t0.entrada AS entrada_3, t0.empleada_id AS empleada_id_4 FROM fichaje_diario t0 WHERE t0.empleada_id = ? ORDER BY t0.fecha DESC LIMIT 1 SELECT t0.id AS id_1, t0.fecha AS fecha_2, t0.entrada AS entrada_3, t0.empleada_id AS empleada_id_4 FROM fichaje_diario t0 WHERE t0.empleada_id = 20 ORDER BY t0.fecha DESC LIMIT 1;
32	0.89 ms	SELECT t0.id AS id_1, t0.fecha AS fecha_2, t0.entrada AS entrada_3, t0.empleada_id AS empleada_id_4 FROM fichaje_diario t0 WHERE t0.empleada_id = ? ORDER BY t0.fecha DESC LIMIT 1 Parameters: [`21`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.fecha AS fecha_2, t0.entrada AS entrada_3, t0.empleada_id AS empleada_id_4 FROM fichaje_diario t0 WHERE t0.empleada_id = ? ORDER BY t0.fecha DESC LIMIT 1 SELECT t0.id AS id_1, t0.fecha AS fecha_2, t0.entrada AS entrada_3, t0.empleada_id AS empleada_id_4 FROM fichaje_diario t0 WHERE t0.empleada_id = 21 ORDER BY t0.fecha DESC LIMIT 1;
33	2.71 ms	SELECT t0.id AS id_1, t0.fecha AS fecha_2, t0.entrada AS entrada_3, t0.empleada_id AS empleada_id_4 FROM fichaje_diario t0 WHERE t0.empleada_id = ? ORDER BY t0.fecha DESC LIMIT 1 Parameters: [`22`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.fecha AS fecha_2, t0.entrada AS entrada_3, t0.empleada_id AS empleada_id_4 FROM fichaje_diario t0 WHERE t0.empleada_id = ? ORDER BY t0.fecha DESC LIMIT 1 SELECT t0.id AS id_1, t0.fecha AS fecha_2, t0.entrada AS entrada_3, t0.empleada_id AS empleada_id_4 FROM fichaje_diario t0 WHERE t0.empleada_id = 22 ORDER BY t0.fecha DESC LIMIT 1;
34	1.21 ms	SELECT t0.id AS id_1, t0.fecha AS fecha_2, t0.entrada AS entrada_3, t0.empleada_id AS empleada_id_4 FROM fichaje_diario t0 WHERE t0.empleada_id = ? ORDER BY t0.fecha DESC LIMIT 1 Parameters: [`23`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.fecha AS fecha_2, t0.entrada AS entrada_3, t0.empleada_id AS empleada_id_4 FROM fichaje_diario t0 WHERE t0.empleada_id = ? ORDER BY t0.fecha DESC LIMIT 1 SELECT t0.id AS id_1, t0.fecha AS fecha_2, t0.entrada AS entrada_3, t0.empleada_id AS empleada_id_4 FROM fichaje_diario t0 WHERE t0.empleada_id = 23 ORDER BY t0.fecha DESC LIMIT 1;
35	0.12 ms	"START TRANSACTION" Parameters: [] View formatted query View runnable query Explain query "START TRANSACTION" "START TRANSACTION";
36	0.28 ms	INSERT INTO fichaje_diario (fecha, entrada, empleada_id) VALUES (?, ?, ?) Parameters: [`1 => "2025-05-15 21:00:00" 2 => 0 3 => 23`] View formatted query View runnable query Explain query INSERT INTO fichaje_diario (fecha, entrada, empleada_id) VALUES (?, ?, ?) INSERT INTO fichaje_diario (fecha, entrada, empleada_id) VALUES ('2025-05-15 21:00:00', 0, 23);
37	1.27 ms	"COMMIT" Parameters: [] View formatted query View runnable query Explain query "COMMIT" "COMMIT";
38	0.23 ms	SELECT t0.id AS id_1, t0.descripcion AS descripcion_2 FROM tipo_notificacion t0 WHERE t0.descripcion = ? LIMIT 1 Parameters: [`"tipoNotificacion.fichajeNoCerrado"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.descripcion AS descripcion_2 FROM tipo_notificacion t0 WHERE t0.descripcion = ? LIMIT 1 SELECT t0.id AS id_1, t0.descripcion AS descripcion_2 FROM tipo_notificacion t0 WHERE t0.descripcion = 'tipoNotificacion.fichajeNoCerrado' LIMIT 1;
39	0.21 ms	SELECT u0_.id AS id_0, u0_.email AS email_1, u0_.roles AS roles_2, u0_.password AS password_3, u0_.is_verified AS is_verified_4, u0_.nombre AS nombre_5, u0_.habilitado AS habilitado_6, u0_.empleada_id AS empleada_id_7, u0_.contacto_id AS contacto_id_8, u0_.contacto_proveedor_id AS contacto_proveedor_id_9 FROM usuario u0_ WHERE u0_.roles LIKE ? Parameters: [`"%"ROLE_ADMIN"%"`] View formatted query View runnable query Explain query SELECT u0_.id AS id_0, u0_.email AS email_1, u0_.roles AS roles_2, u0_.password AS password_3, u0_.is_verified AS is_verified_4, u0_.nombre AS nombre_5, u0_.habilitado AS habilitado_6, u0_.empleada_id AS empleada_id_7, u0_.contacto_id AS contacto_id_8, u0_.contacto_proveedor_id AS contacto_proveedor_id_9 FROM usuario u0_ WHERE u0_.roles LIKE ? SELECT u0_.id AS id_0, u0_.email AS email_1, u0_.roles AS roles_2, u0_.password AS password_3, u0_.is_verified AS is_verified_4, u0_.nombre AS nombre_5, u0_.habilitado AS habilitado_6, u0_.empleada_id AS empleada_id_7, u0_.contacto_id AS contacto_id_8, u0_.contacto_proveedor_id AS contacto_proveedor_id_9 FROM usuario u0_ WHERE u0_.roles LIKE '%\"ROLE_ADMIN\"%';
40	0.09 ms	"START TRANSACTION" Parameters: [] View formatted query View runnable query Explain query "START TRANSACTION" "START TRANSACTION";
41	0.23 ms	INSERT INTO notificacion (fecha, textoes, textoeus, leido, objeto, destinatario_id, tipo_id) VALUES (?, ?, ?, ?, ?, ?, ?) Parameters: [`1 => "2025-05-15" 2 => "Se ha cerrado un fichaje para Maria Teresa Iglesias Sánchez con fecha: 2025-05-15" 3 => "Fitxaje bat ixti da Maria Teresa Iglesias Sánchez-rentzat 15-05-2025 datarekin" 4 => 0 5 => 23 6 => 23 7 => 3`] View formatted query View runnable query Explain query INSERT INTO notificacion ( fecha, textoes, textoeus, leido, objeto, destinatario_id, tipo_id ) VALUES (?, ?, ?, ?, ?, ?, ?) INSERT INTO notificacion (fecha, textoes, textoeus, leido, objeto, destinatario_id, tipo_id) VALUES ('2025-05-15', 'Se ha cerrado un fichaje para Maria Teresa Iglesias Sánchez con fecha: 2025-05-15', 'Fitxaje bat ixti da Maria Teresa Iglesias Sánchez-rentzat 15-05-2025 datarekin', 0, 23, 23, 3);
42	0.17 ms	INSERT INTO notificacion (fecha, textoes, textoeus, leido, objeto, destinatario_id, tipo_id) VALUES (?, ?, ?, ?, ?, ?, ?) Parameters: [`1 => "2025-05-15" 2 => "Se ha cerrado un fichaje para Maria Teresa Iglesias Sánchez con fecha: 2025-05-15" 3 => "Fitxaje bat ixti da Maria Teresa Iglesias Sánchez-rentzat 15-05-2025 datarekin" 4 => 0 5 => 23 6 => 1 7 => 3`] View formatted query View runnable query Explain query INSERT INTO notificacion ( fecha, textoes, textoeus, leido, objeto, destinatario_id, tipo_id ) VALUES (?, ?, ?, ?, ?, ?, ?) INSERT INTO notificacion (fecha, textoes, textoeus, leido, objeto, destinatario_id, tipo_id) VALUES ('2025-05-15', 'Se ha cerrado un fichaje para Maria Teresa Iglesias Sánchez con fecha: 2025-05-15', 'Fitxaje bat ixti da Maria Teresa Iglesias Sánchez-rentzat 15-05-2025 datarekin', 0, 23, 1, 3);
43	0.11 ms	INSERT INTO notificacion (fecha, textoes, textoeus, leido, objeto, destinatario_id, tipo_id) VALUES (?, ?, ?, ?, ?, ?, ?) Parameters: [`1 => "2025-05-15" 2 => "Se ha cerrado un fichaje para Maria Teresa Iglesias Sánchez con fecha: 2025-05-15" 3 => "Fitxaje bat ixti da Maria Teresa Iglesias Sánchez-rentzat 15-05-2025 datarekin" 4 => 0 5 => 23 6 => 2 7 => 3`] View formatted query View runnable query Explain query INSERT INTO notificacion ( fecha, textoes, textoeus, leido, objeto, destinatario_id, tipo_id ) VALUES (?, ?, ?, ?, ?, ?, ?) INSERT INTO notificacion (fecha, textoes, textoeus, leido, objeto, destinatario_id, tipo_id) VALUES ('2025-05-15', 'Se ha cerrado un fichaje para Maria Teresa Iglesias Sánchez con fecha: 2025-05-15', 'Fitxaje bat ixti da Maria Teresa Iglesias Sánchez-rentzat 15-05-2025 datarekin', 0, 23, 2, 3);
44	0.10 ms	INSERT INTO notificacion (fecha, textoes, textoeus, leido, objeto, destinatario_id, tipo_id) VALUES (?, ?, ?, ?, ?, ?, ?) Parameters: [`1 => "2025-05-15" 2 => "Se ha cerrado un fichaje para Maria Teresa Iglesias Sánchez con fecha: 2025-05-15" 3 => "Fitxaje bat ixti da Maria Teresa Iglesias Sánchez-rentzat 15-05-2025 datarekin" 4 => 0 5 => 23 6 => 3 7 => 3`] View formatted query View runnable query Explain query INSERT INTO notificacion ( fecha, textoes, textoeus, leido, objeto, destinatario_id, tipo_id ) VALUES (?, ?, ?, ?, ?, ?, ?) INSERT INTO notificacion (fecha, textoes, textoeus, leido, objeto, destinatario_id, tipo_id) VALUES ('2025-05-15', 'Se ha cerrado un fichaje para Maria Teresa Iglesias Sánchez con fecha: 2025-05-15', 'Fitxaje bat ixti da Maria Teresa Iglesias Sánchez-rentzat 15-05-2025 datarekin', 0, 23, 3, 3);
45	0.10 ms	INSERT INTO notificacion (fecha, textoes, textoeus, leido, objeto, destinatario_id, tipo_id) VALUES (?, ?, ?, ?, ?, ?, ?) Parameters: [`1 => "2025-05-15" 2 => "Se ha cerrado un fichaje para Maria Teresa Iglesias Sánchez con fecha: 2025-05-15" 3 => "Fitxaje bat ixti da Maria Teresa Iglesias Sánchez-rentzat 15-05-2025 datarekin" 4 => 0 5 => 23 6 => 4 7 => 3`] View formatted query View runnable query Explain query INSERT INTO notificacion ( fecha, textoes, textoeus, leido, objeto, destinatario_id, tipo_id ) VALUES (?, ?, ?, ?, ?, ?, ?) INSERT INTO notificacion (fecha, textoes, textoeus, leido, objeto, destinatario_id, tipo_id) VALUES ('2025-05-15', 'Se ha cerrado un fichaje para Maria Teresa Iglesias Sánchez con fecha: 2025-05-15', 'Fitxaje bat ixti da Maria Teresa Iglesias Sánchez-rentzat 15-05-2025 datarekin', 0, 23, 4, 3);
46	1.08 ms	"COMMIT" Parameters: [] View formatted query View runnable query Explain query "COMMIT" "COMMIT";
47	0.49 ms	SELECT t0.id AS id_1, t0.fecha AS fecha_2, t0.entrada AS entrada_3, t0.empleada_id AS empleada_id_4 FROM fichaje_diario t0 WHERE t0.empleada_id = ? ORDER BY t0.fecha DESC LIMIT 1 Parameters: [`24`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.fecha AS fecha_2, t0.entrada AS entrada_3, t0.empleada_id AS empleada_id_4 FROM fichaje_diario t0 WHERE t0.empleada_id = ? ORDER BY t0.fecha DESC LIMIT 1 SELECT t0.id AS id_1, t0.fecha AS fecha_2, t0.entrada AS entrada_3, t0.empleada_id AS empleada_id_4 FROM fichaje_diario t0 WHERE t0.empleada_id = 24 ORDER BY t0.fecha DESC LIMIT 1;
48	0.53 ms	SELECT t0.id AS id_1, t0.fecha AS fecha_2, t0.entrada AS entrada_3, t0.empleada_id AS empleada_id_4 FROM fichaje_diario t0 WHERE t0.empleada_id = ? ORDER BY t0.fecha DESC LIMIT 1 Parameters: [`25`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.fecha AS fecha_2, t0.entrada AS entrada_3, t0.empleada_id AS empleada_id_4 FROM fichaje_diario t0 WHERE t0.empleada_id = ? ORDER BY t0.fecha DESC LIMIT 1 SELECT t0.id AS id_1, t0.fecha AS fecha_2, t0.entrada AS entrada_3, t0.empleada_id AS empleada_id_4 FROM fichaje_diario t0 WHERE t0.empleada_id = 25 ORDER BY t0.fecha DESC LIMIT 1;
49	1.97 ms	SELECT t0.id AS id_1, t0.fecha AS fecha_2, t0.entrada AS entrada_3, t0.empleada_id AS empleada_id_4 FROM fichaje_diario t0 WHERE t0.empleada_id = ? ORDER BY t0.fecha DESC LIMIT 1 Parameters: [`26`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.fecha AS fecha_2, t0.entrada AS entrada_3, t0.empleada_id AS empleada_id_4 FROM fichaje_diario t0 WHERE t0.empleada_id = ? ORDER BY t0.fecha DESC LIMIT 1 SELECT t0.id AS id_1, t0.fecha AS fecha_2, t0.entrada AS entrada_3, t0.empleada_id AS empleada_id_4 FROM fichaje_diario t0 WHERE t0.empleada_id = 26 ORDER BY t0.fecha DESC LIMIT 1;
50	1.06 ms	SELECT t0.id AS id_1, t0.fecha AS fecha_2, t0.entrada AS entrada_3, t0.empleada_id AS empleada_id_4 FROM fichaje_diario t0 WHERE t0.empleada_id = ? ORDER BY t0.fecha DESC LIMIT 1 Parameters: [`27`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.fecha AS fecha_2, t0.entrada AS entrada_3, t0.empleada_id AS empleada_id_4 FROM fichaje_diario t0 WHERE t0.empleada_id = ? ORDER BY t0.fecha DESC LIMIT 1 SELECT t0.id AS id_1, t0.fecha AS fecha_2, t0.entrada AS entrada_3, t0.empleada_id AS empleada_id_4 FROM fichaje_diario t0 WHERE t0.empleada_id = 27 ORDER BY t0.fecha DESC LIMIT 1;
51	0.33 ms	SELECT t0.id AS id_1, t0.fecha AS fecha_2, t0.entrada AS entrada_3, t0.empleada_id AS empleada_id_4 FROM fichaje_diario t0 WHERE t0.empleada_id = ? ORDER BY t0.fecha DESC LIMIT 1 Parameters: [`28`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.fecha AS fecha_2, t0.entrada AS entrada_3, t0.empleada_id AS empleada_id_4 FROM fichaje_diario t0 WHERE t0.empleada_id = ? ORDER BY t0.fecha DESC LIMIT 1 SELECT t0.id AS id_1, t0.fecha AS fecha_2, t0.entrada AS entrada_3, t0.empleada_id AS empleada_id_4 FROM fichaje_diario t0 WHERE t0.empleada_id = 28 ORDER BY t0.fecha DESC LIMIT 1;
52	0.53 ms	SELECT t0.id AS id_1, t0.fecha AS fecha_2, t0.entrada AS entrada_3, t0.empleada_id AS empleada_id_4 FROM fichaje_diario t0 WHERE t0.empleada_id = ? ORDER BY t0.fecha DESC LIMIT 1 Parameters: [`29`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.fecha AS fecha_2, t0.entrada AS entrada_3, t0.empleada_id AS empleada_id_4 FROM fichaje_diario t0 WHERE t0.empleada_id = ? ORDER BY t0.fecha DESC LIMIT 1 SELECT t0.id AS id_1, t0.fecha AS fecha_2, t0.entrada AS entrada_3, t0.empleada_id AS empleada_id_4 FROM fichaje_diario t0 WHERE t0.empleada_id = 29 ORDER BY t0.fecha DESC LIMIT 1;
53	1.01 ms	SELECT t0.id AS id_1, t0.fecha AS fecha_2, t0.entrada AS entrada_3, t0.empleada_id AS empleada_id_4 FROM fichaje_diario t0 WHERE t0.empleada_id = ? ORDER BY t0.fecha DESC LIMIT 1 Parameters: [`30`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.fecha AS fecha_2, t0.entrada AS entrada_3, t0.empleada_id AS empleada_id_4 FROM fichaje_diario t0 WHERE t0.empleada_id = ? ORDER BY t0.fecha DESC LIMIT 1 SELECT t0.id AS id_1, t0.fecha AS fecha_2, t0.entrada AS entrada_3, t0.empleada_id AS empleada_id_4 FROM fichaje_diario t0 WHERE t0.empleada_id = 30 ORDER BY t0.fecha DESC LIMIT 1;
54	0.24 ms	SELECT t0.id AS id_1, t0.fecha AS fecha_2, t0.entrada AS entrada_3, t0.empleada_id AS empleada_id_4 FROM fichaje_diario t0 WHERE t0.empleada_id = ? ORDER BY t0.fecha DESC LIMIT 1 Parameters: [`31`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.fecha AS fecha_2, t0.entrada AS entrada_3, t0.empleada_id AS empleada_id_4 FROM fichaje_diario t0 WHERE t0.empleada_id = ? ORDER BY t0.fecha DESC LIMIT 1 SELECT t0.id AS id_1, t0.fecha AS fecha_2, t0.entrada AS entrada_3, t0.empleada_id AS empleada_id_4 FROM fichaje_diario t0 WHERE t0.empleada_id = 31 ORDER BY t0.fecha DESC LIMIT 1;
55	0.30 ms	SELECT t0.id AS id_1, t0.fecha AS fecha_2, t0.entrada AS entrada_3, t0.empleada_id AS empleada_id_4 FROM fichaje_diario t0 WHERE t0.empleada_id = ? ORDER BY t0.fecha DESC LIMIT 1 Parameters: [`32`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.fecha AS fecha_2, t0.entrada AS entrada_3, t0.empleada_id AS empleada_id_4 FROM fichaje_diario t0 WHERE t0.empleada_id = ? ORDER BY t0.fecha DESC LIMIT 1 SELECT t0.id AS id_1, t0.fecha AS fecha_2, t0.entrada AS entrada_3, t0.empleada_id AS empleada_id_4 FROM fichaje_diario t0 WHERE t0.empleada_id = 32 ORDER BY t0.fecha DESC LIMIT 1;
56	0.66 ms	SELECT t0.id AS id_1, t0.fecha AS fecha_2, t0.entrada AS entrada_3, t0.empleada_id AS empleada_id_4 FROM fichaje_diario t0 WHERE t0.empleada_id = ? ORDER BY t0.fecha DESC LIMIT 1 Parameters: [`33`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.fecha AS fecha_2, t0.entrada AS entrada_3, t0.empleada_id AS empleada_id_4 FROM fichaje_diario t0 WHERE t0.empleada_id = ? ORDER BY t0.fecha DESC LIMIT 1 SELECT t0.id AS id_1, t0.fecha AS fecha_2, t0.entrada AS entrada_3, t0.empleada_id AS empleada_id_4 FROM fichaje_diario t0 WHERE t0.empleada_id = 33 ORDER BY t0.fecha DESC LIMIT 1;
57	0.24 ms	SELECT t0.id AS id_1, t0.fecha AS fecha_2, t0.entrada AS entrada_3, t0.empleada_id AS empleada_id_4 FROM fichaje_diario t0 WHERE t0.empleada_id = ? ORDER BY t0.fecha DESC LIMIT 1 Parameters: [`34`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.fecha AS fecha_2, t0.entrada AS entrada_3, t0.empleada_id AS empleada_id_4 FROM fichaje_diario t0 WHERE t0.empleada_id = ? ORDER BY t0.fecha DESC LIMIT 1 SELECT t0.id AS id_1, t0.fecha AS fecha_2, t0.entrada AS entrada_3, t0.empleada_id AS empleada_id_4 FROM fichaje_diario t0 WHERE t0.empleada_id = 34 ORDER BY t0.fecha DESC LIMIT 1;
58	0.12 ms	SELECT t0.id AS id_1, t0.fecha AS fecha_2, t0.entrada AS entrada_3, t0.empleada_id AS empleada_id_4 FROM fichaje_diario t0 WHERE t0.empleada_id = ? ORDER BY t0.fecha DESC LIMIT 1 Parameters: [`35`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.fecha AS fecha_2, t0.entrada AS entrada_3, t0.empleada_id AS empleada_id_4 FROM fichaje_diario t0 WHERE t0.empleada_id = ? ORDER BY t0.fecha DESC LIMIT 1 SELECT t0.id AS id_1, t0.fecha AS fecha_2, t0.entrada AS entrada_3, t0.empleada_id AS empleada_id_4 FROM fichaje_diario t0 WHERE t0.empleada_id = 35 ORDER BY t0.fecha DESC LIMIT 1;
59	0.13 ms	SELECT t0.id AS id_1, t0.fecha AS fecha_2, t0.entrada AS entrada_3, t0.empleada_id AS empleada_id_4 FROM fichaje_diario t0 WHERE t0.empleada_id = ? ORDER BY t0.fecha DESC LIMIT 1 Parameters: [`36`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.fecha AS fecha_2, t0.entrada AS entrada_3, t0.empleada_id AS empleada_id_4 FROM fichaje_diario t0 WHERE t0.empleada_id = ? ORDER BY t0.fecha DESC LIMIT 1 SELECT t0.id AS id_1, t0.fecha AS fecha_2, t0.entrada AS entrada_3, t0.empleada_id AS empleada_id_4 FROM fichaje_diario t0 WHERE t0.empleada_id = 36 ORDER BY t0.fecha DESC LIMIT 1;
60	0.43 ms	SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.email AS email_3, t0.telefono AS telefono_4, t0.habilitado AS habilitado_5, t0.rango_salarial_id AS rango_salarial_id_6, t7.id AS id_8, t7.email AS email_9, t7.roles AS roles_10, t7.password AS password_11, t7.is_verified AS is_verified_12, t7.nombre AS nombre_13, t7.habilitado AS habilitado_14, t7.empleada_id AS empleada_id_15, t7.contacto_id AS contacto_id_16, t7.contacto_proveedor_id AS contacto_proveedor_id_17 FROM empleada t0 LEFT JOIN usuario t7 ON t7.empleada_id = t0.id Parameters: [] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.email AS email_3, t0.telefono AS telefono_4, t0.habilitado AS habilitado_5, t0.rango_salarial_id AS rango_salarial_id_6, t7.id AS id_8, t7.email AS email_9, t7.roles AS roles_10, t7.password AS password_11, t7.is_verified AS is_verified_12, t7.nombre AS nombre_13, t7.habilitado AS habilitado_14, t7.empleada_id AS empleada_id_15, t7.contacto_id AS contacto_id_16, t7.contacto_proveedor_id AS contacto_proveedor_id_17 FROM empleada t0 LEFT JOIN usuario t7 ON t7.empleada_id = t0.id SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.email AS email_3, t0.telefono AS telefono_4, t0.habilitado AS habilitado_5, t0.rango_salarial_id AS rango_salarial_id_6, t7.id AS id_8, t7.email AS email_9, t7.roles AS roles_10, t7.password AS password_11, t7.is_verified AS is_verified_12, t7.nombre AS nombre_13, t7.habilitado AS habilitado_14, t7.empleada_id AS empleada_id_15, t7.contacto_id AS contacto_id_16, t7.contacto_proveedor_id AS contacto_proveedor_id_17 FROM empleada t0 LEFT JOIN usuario t7 ON t7.empleada_id = t0.id;
61	0.14 ms	SELECT t0.id AS id_1, t0.hora_inicio AS hora_inicio_2, t0.hora_fin AS hora_fin_3, t0.hora_aviso_max AS hora_aviso_max_4, t0.hora_aviso_min AS hora_aviso_min_5, t0.justificacion_aviso1 AS justificacion_aviso1_6, t0.justificacion_aviso2 AS justificacion_aviso2_7, t0.justificacion_aviso3 AS justificacion_aviso3_8 FROM globales t0 LIMIT 1 Parameters: [] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.hora_inicio AS hora_inicio_2, t0.hora_fin AS hora_fin_3, t0.hora_aviso_max AS hora_aviso_max_4, t0.hora_aviso_min AS hora_aviso_min_5, t0.justificacion_aviso1 AS justificacion_aviso1_6, t0.justificacion_aviso2 AS justificacion_aviso2_7, t0.justificacion_aviso3 AS justificacion_aviso3_8 FROM globales t0 LIMIT 1 SELECT t0.id AS id_1, t0.hora_inicio AS hora_inicio_2, t0.hora_fin AS hora_fin_3, t0.hora_aviso_max AS hora_aviso_max_4, t0.hora_aviso_min AS hora_aviso_min_5, t0.justificacion_aviso1 AS justificacion_aviso1_6, t0.justificacion_aviso2 AS justificacion_aviso2_7, t0.justificacion_aviso3 AS justificacion_aviso3_8 FROM globales t0 LIMIT 1;
62	0.24 ms	SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = ? AND f0_.fecha LIKE ? ORDER BY f0_.fecha ASC LIMIT 1 Parameters: [`1 "2025-05-15%"`] View formatted query View runnable query Explain query SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = ? AND f0_.fecha LIKE ? ORDER BY f0_.fecha ASC LIMIT 1 SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = 1 AND f0_.fecha LIKE '2025-05-15%' ORDER BY f0_.fecha ASC LIMIT 1;
63	1.88 ms	SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = ? AND f0_.fecha LIKE ? ORDER BY f0_.fecha ASC LIMIT 1 Parameters: [`2 "2025-05-15%"`] View formatted query View runnable query Explain query SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = ? AND f0_.fecha LIKE ? ORDER BY f0_.fecha ASC LIMIT 1 SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = 2 AND f0_.fecha LIKE '2025-05-15%' ORDER BY f0_.fecha ASC LIMIT 1;
64	1.38 ms	SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = ? AND f0_.fecha LIKE ? AND f0_.fecha > ? ORDER BY f0_.fecha ASC LIMIT 1 Parameters: [`2 "2025-05-15%" "2025-05-15 09:20:51"`] View formatted query View runnable query Explain query SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = ? AND f0_.fecha LIKE ? AND f0_.fecha > ? ORDER BY f0_.fecha ASC LIMIT 1 SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = 2 AND f0_.fecha LIKE '2025-05-15%' AND f0_.fecha > '2025-05-15 09:20:51' ORDER BY f0_.fecha ASC LIMIT 1;
65	1.20 ms	SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = ? AND f0_.fecha LIKE ? AND f0_.fecha > ? ORDER BY f0_.fecha ASC LIMIT 1 Parameters: [`2 "2025-05-15%" "2025-05-15 16:03:54"`] View formatted query View runnable query Explain query SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = ? AND f0_.fecha LIKE ? AND f0_.fecha > ? ORDER BY f0_.fecha ASC LIMIT 1 SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = 2 AND f0_.fecha LIKE '2025-05-15%' AND f0_.fecha > '2025-05-15 16:03:54' ORDER BY f0_.fecha ASC LIMIT 1;
66	1.26 ms	SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = ? AND f0_.fecha LIKE ? ORDER BY f0_.fecha ASC LIMIT 1 Parameters: [`3 "2025-05-15%"`] View formatted query View runnable query Explain query SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = ? AND f0_.fecha LIKE ? ORDER BY f0_.fecha ASC LIMIT 1 SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = 3 AND f0_.fecha LIKE '2025-05-15%' ORDER BY f0_.fecha ASC LIMIT 1;
67	1.00 ms	SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = ? AND f0_.fecha LIKE ? AND f0_.fecha > ? ORDER BY f0_.fecha ASC LIMIT 1 Parameters: [`3 "2025-05-15%" "2025-05-15 08:14:34"`] View formatted query View runnable query Explain query SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = ? AND f0_.fecha LIKE ? AND f0_.fecha > ? ORDER BY f0_.fecha ASC LIMIT 1 SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = 3 AND f0_.fecha LIKE '2025-05-15%' AND f0_.fecha > '2025-05-15 08:14:34' ORDER BY f0_.fecha ASC LIMIT 1;
68	1.01 ms	SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = ? AND f0_.fecha LIKE ? AND f0_.fecha > ? ORDER BY f0_.fecha ASC LIMIT 1 Parameters: [`3 "2025-05-15%" "2025-05-15 21:00:00"`] View formatted query View runnable query Explain query SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = ? AND f0_.fecha LIKE ? AND f0_.fecha > ? ORDER BY f0_.fecha ASC LIMIT 1 SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = 3 AND f0_.fecha LIKE '2025-05-15%' AND f0_.fecha > '2025-05-15 21:00:00' ORDER BY f0_.fecha ASC LIMIT 1;
69	0.13 ms	SELECT t0.id AS id_1, t0.descripcion AS descripcion_2 FROM tipo_notificacion t0 WHERE t0.descripcion = ? LIMIT 1 Parameters: [`"tipoNotificacion.horasSuperadas"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.descripcion AS descripcion_2 FROM tipo_notificacion t0 WHERE t0.descripcion = ? LIMIT 1 SELECT t0.id AS id_1, t0.descripcion AS descripcion_2 FROM tipo_notificacion t0 WHERE t0.descripcion = 'tipoNotificacion.horasSuperadas' LIMIT 1;
70	0.38 ms	SELECT u0_.id AS id_0, u0_.email AS email_1, u0_.roles AS roles_2, u0_.password AS password_3, u0_.is_verified AS is_verified_4, u0_.nombre AS nombre_5, u0_.habilitado AS habilitado_6, u0_.empleada_id AS empleada_id_7, u0_.contacto_id AS contacto_id_8, u0_.contacto_proveedor_id AS contacto_proveedor_id_9 FROM usuario u0_ WHERE u0_.roles LIKE ? Parameters: [`"%"ROLE_ADMIN"%"`] View formatted query View runnable query Explain query SELECT u0_.id AS id_0, u0_.email AS email_1, u0_.roles AS roles_2, u0_.password AS password_3, u0_.is_verified AS is_verified_4, u0_.nombre AS nombre_5, u0_.habilitado AS habilitado_6, u0_.empleada_id AS empleada_id_7, u0_.contacto_id AS contacto_id_8, u0_.contacto_proveedor_id AS contacto_proveedor_id_9 FROM usuario u0_ WHERE u0_.roles LIKE ? SELECT u0_.id AS id_0, u0_.email AS email_1, u0_.roles AS roles_2, u0_.password AS password_3, u0_.is_verified AS is_verified_4, u0_.nombre AS nombre_5, u0_.habilitado AS habilitado_6, u0_.empleada_id AS empleada_id_7, u0_.contacto_id AS contacto_id_8, u0_.contacto_proveedor_id AS contacto_proveedor_id_9 FROM usuario u0_ WHERE u0_.roles LIKE '%\"ROLE_ADMIN\"%';
71	0.12 ms	"START TRANSACTION" Parameters: [] View formatted query View runnable query Explain query "START TRANSACTION" "START TRANSACTION";
72	0.25 ms	INSERT INTO notificacion (fecha, textoes, textoeus, leido, objeto, destinatario_id, tipo_id) VALUES (?, ?, ?, ?, ?, ?, ?) Parameters: [`1 => "2025-05-15" 2 => "Maria Alonso ha trabajado un total de 12h 45m , 3h 45m horas mas de lo establecido" 3 => "Maria Alonso 12h 45m egin du lan, gehienezko kopurua baino 3h 45m gehiago" 4 => 0 5 => 3 6 => 3 7 => 1`] View formatted query View runnable query Explain query INSERT INTO notificacion ( fecha, textoes, textoeus, leido, objeto, destinatario_id, tipo_id ) VALUES (?, ?, ?, ?, ?, ?, ?) INSERT INTO notificacion (fecha, textoes, textoeus, leido, objeto, destinatario_id, tipo_id) VALUES ('2025-05-15', 'Maria Alonso ha trabajado un total de 12h 45m , 3h 45m horas mas de lo establecido', 'Maria Alonso 12h 45m egin du lan, gehienezko kopurua baino 3h 45m gehiago', 0, 3, 3, 1);
73	0.16 ms	INSERT INTO notificacion (fecha, textoes, textoeus, leido, objeto, destinatario_id, tipo_id) VALUES (?, ?, ?, ?, ?, ?, ?) Parameters: [`1 => "2025-05-15" 2 => "Maria Alonso ha trabajado un total de 12h 45m , 3h 45m horas mas de lo establecido" 3 => "Maria Alonso 12h 45m egin du lan, gehienezko kopurua baino 3h 45m gehiago" 4 => 0 5 => 3 6 => 1 7 => 1`] View formatted query View runnable query Explain query INSERT INTO notificacion ( fecha, textoes, textoeus, leido, objeto, destinatario_id, tipo_id ) VALUES (?, ?, ?, ?, ?, ?, ?) INSERT INTO notificacion (fecha, textoes, textoeus, leido, objeto, destinatario_id, tipo_id) VALUES ('2025-05-15', 'Maria Alonso ha trabajado un total de 12h 45m , 3h 45m horas mas de lo establecido', 'Maria Alonso 12h 45m egin du lan, gehienezko kopurua baino 3h 45m gehiago', 0, 3, 1, 1);
74	21.48 ms	INSERT INTO notificacion (fecha, textoes, textoeus, leido, objeto, destinatario_id, tipo_id) VALUES (?, ?, ?, ?, ?, ?, ?) Parameters: [`1 => "2025-05-15" 2 => "Maria Alonso ha trabajado un total de 12h 45m , 3h 45m horas mas de lo establecido" 3 => "Maria Alonso 12h 45m egin du lan, gehienezko kopurua baino 3h 45m gehiago" 4 => 0 5 => 3 6 => 2 7 => 1`] View formatted query View runnable query Explain query INSERT INTO notificacion ( fecha, textoes, textoeus, leido, objeto, destinatario_id, tipo_id ) VALUES (?, ?, ?, ?, ?, ?, ?) INSERT INTO notificacion (fecha, textoes, textoeus, leido, objeto, destinatario_id, tipo_id) VALUES ('2025-05-15', 'Maria Alonso ha trabajado un total de 12h 45m , 3h 45m horas mas de lo establecido', 'Maria Alonso 12h 45m egin du lan, gehienezko kopurua baino 3h 45m gehiago', 0, 3, 2, 1);
75	0.22 ms	INSERT INTO notificacion (fecha, textoes, textoeus, leido, objeto, destinatario_id, tipo_id) VALUES (?, ?, ?, ?, ?, ?, ?) Parameters: [`1 => "2025-05-15" 2 => "Maria Alonso ha trabajado un total de 12h 45m , 3h 45m horas mas de lo establecido" 3 => "Maria Alonso 12h 45m egin du lan, gehienezko kopurua baino 3h 45m gehiago" 4 => 0 5 => 3 6 => 4 7 => 1`] View formatted query View runnable query Explain query INSERT INTO notificacion ( fecha, textoes, textoeus, leido, objeto, destinatario_id, tipo_id ) VALUES (?, ?, ?, ?, ?, ?, ?) INSERT INTO notificacion (fecha, textoes, textoeus, leido, objeto, destinatario_id, tipo_id) VALUES ('2025-05-15', 'Maria Alonso ha trabajado un total de 12h 45m , 3h 45m horas mas de lo establecido', 'Maria Alonso 12h 45m egin du lan, gehienezko kopurua baino 3h 45m gehiago', 0, 3, 4, 1);
76	144.53 ms	"COMMIT" Parameters: [] View formatted query View runnable query Explain query "COMMIT" "COMMIT";
77	1.76 ms	SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = ? AND f0_.fecha LIKE ? ORDER BY f0_.fecha ASC LIMIT 1 Parameters: [`4 "2025-05-15%"`] View formatted query View runnable query Explain query SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = ? AND f0_.fecha LIKE ? ORDER BY f0_.fecha ASC LIMIT 1 SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = 4 AND f0_.fecha LIKE '2025-05-15%' ORDER BY f0_.fecha ASC LIMIT 1;
78	1.34 ms	SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = ? AND f0_.fecha LIKE ? ORDER BY f0_.fecha ASC LIMIT 1 Parameters: [`6 "2025-05-15%"`] View formatted query View runnable query Explain query SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = ? AND f0_.fecha LIKE ? ORDER BY f0_.fecha ASC LIMIT 1 SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = 6 AND f0_.fecha LIKE '2025-05-15%' ORDER BY f0_.fecha ASC LIMIT 1;
79	1.03 ms	SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = ? AND f0_.fecha LIKE ? AND f0_.fecha > ? ORDER BY f0_.fecha ASC LIMIT 1 Parameters: [`6 "2025-05-15%" "2025-05-15 08:31:07"`] View formatted query View runnable query Explain query SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = ? AND f0_.fecha LIKE ? AND f0_.fecha > ? ORDER BY f0_.fecha ASC LIMIT 1 SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = 6 AND f0_.fecha LIKE '2025-05-15%' AND f0_.fecha > '2025-05-15 08:31:07' ORDER BY f0_.fecha ASC LIMIT 1;
80	1.03 ms	SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = ? AND f0_.fecha LIKE ? AND f0_.fecha > ? ORDER BY f0_.fecha ASC LIMIT 1 Parameters: [`6 "2025-05-15%" "2025-05-15 18:21:03"`] View formatted query View runnable query Explain query SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = ? AND f0_.fecha LIKE ? AND f0_.fecha > ? ORDER BY f0_.fecha ASC LIMIT 1 SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = 6 AND f0_.fecha LIKE '2025-05-15%' AND f0_.fecha > '2025-05-15 18:21:03' ORDER BY f0_.fecha ASC LIMIT 1;
81	0.12 ms	SELECT t0.id AS id_1, t0.descripcion AS descripcion_2 FROM tipo_notificacion t0 WHERE t0.descripcion = ? LIMIT 1 Parameters: [`"tipoNotificacion.horasSuperadas"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.descripcion AS descripcion_2 FROM tipo_notificacion t0 WHERE t0.descripcion = ? LIMIT 1 SELECT t0.id AS id_1, t0.descripcion AS descripcion_2 FROM tipo_notificacion t0 WHERE t0.descripcion = 'tipoNotificacion.horasSuperadas' LIMIT 1;
82	0.18 ms	SELECT u0_.id AS id_0, u0_.email AS email_1, u0_.roles AS roles_2, u0_.password AS password_3, u0_.is_verified AS is_verified_4, u0_.nombre AS nombre_5, u0_.habilitado AS habilitado_6, u0_.empleada_id AS empleada_id_7, u0_.contacto_id AS contacto_id_8, u0_.contacto_proveedor_id AS contacto_proveedor_id_9 FROM usuario u0_ WHERE u0_.roles LIKE ? Parameters: [`"%"ROLE_ADMIN"%"`] View formatted query View runnable query Explain query SELECT u0_.id AS id_0, u0_.email AS email_1, u0_.roles AS roles_2, u0_.password AS password_3, u0_.is_verified AS is_verified_4, u0_.nombre AS nombre_5, u0_.habilitado AS habilitado_6, u0_.empleada_id AS empleada_id_7, u0_.contacto_id AS contacto_id_8, u0_.contacto_proveedor_id AS contacto_proveedor_id_9 FROM usuario u0_ WHERE u0_.roles LIKE ? SELECT u0_.id AS id_0, u0_.email AS email_1, u0_.roles AS roles_2, u0_.password AS password_3, u0_.is_verified AS is_verified_4, u0_.nombre AS nombre_5, u0_.habilitado AS habilitado_6, u0_.empleada_id AS empleada_id_7, u0_.contacto_id AS contacto_id_8, u0_.contacto_proveedor_id AS contacto_proveedor_id_9 FROM usuario u0_ WHERE u0_.roles LIKE '%\"ROLE_ADMIN\"%';
83	0.09 ms	"START TRANSACTION" Parameters: [] View formatted query View runnable query Explain query "START TRANSACTION" "START TRANSACTION";
84	0.23 ms	INSERT INTO notificacion (fecha, textoes, textoeus, leido, objeto, destinatario_id, tipo_id) VALUES (?, ?, ?, ?, ?, ?, ?) Parameters: [`1 => "2025-05-15" 2 => "Urko Pérez Vázquez ha trabajado un total de 9h 49m , 0h 49m horas mas de lo establecido" 3 => "Urko Pérez Vázquez 9h 49m egin du lan, gehienezko kopurua baino 0h 49m gehiago" 4 => 0 5 => 6 6 => 6 7 => 1`] View formatted query View runnable query Explain query INSERT INTO notificacion ( fecha, textoes, textoeus, leido, objeto, destinatario_id, tipo_id ) VALUES (?, ?, ?, ?, ?, ?, ?) INSERT INTO notificacion (fecha, textoes, textoeus, leido, objeto, destinatario_id, tipo_id) VALUES ('2025-05-15', 'Urko Pérez Vázquez ha trabajado un total de 9h 49m , 0h 49m horas mas de lo establecido', 'Urko Pérez Vázquez 9h 49m egin du lan, gehienezko kopurua baino 0h 49m gehiago', 0, 6, 6, 1);
85	0.16 ms	INSERT INTO notificacion (fecha, textoes, textoeus, leido, objeto, destinatario_id, tipo_id) VALUES (?, ?, ?, ?, ?, ?, ?) Parameters: [`1 => "2025-05-15" 2 => "Urko Pérez Vázquez ha trabajado un total de 9h 49m , 0h 49m horas mas de lo establecido" 3 => "Urko Pérez Vázquez 9h 49m egin du lan, gehienezko kopurua baino 0h 49m gehiago" 4 => 0 5 => 6 6 => 1 7 => 1`] View formatted query View runnable query Explain query INSERT INTO notificacion ( fecha, textoes, textoeus, leido, objeto, destinatario_id, tipo_id ) VALUES (?, ?, ?, ?, ?, ?, ?) INSERT INTO notificacion (fecha, textoes, textoeus, leido, objeto, destinatario_id, tipo_id) VALUES ('2025-05-15', 'Urko Pérez Vázquez ha trabajado un total de 9h 49m , 0h 49m horas mas de lo establecido', 'Urko Pérez Vázquez 9h 49m egin du lan, gehienezko kopurua baino 0h 49m gehiago', 0, 6, 1, 1);
86	0.11 ms	INSERT INTO notificacion (fecha, textoes, textoeus, leido, objeto, destinatario_id, tipo_id) VALUES (?, ?, ?, ?, ?, ?, ?) Parameters: [`1 => "2025-05-15" 2 => "Urko Pérez Vázquez ha trabajado un total de 9h 49m , 0h 49m horas mas de lo establecido" 3 => "Urko Pérez Vázquez 9h 49m egin du lan, gehienezko kopurua baino 0h 49m gehiago" 4 => 0 5 => 6 6 => 2 7 => 1`] View formatted query View runnable query Explain query INSERT INTO notificacion ( fecha, textoes, textoeus, leido, objeto, destinatario_id, tipo_id ) VALUES (?, ?, ?, ?, ?, ?, ?) INSERT INTO notificacion (fecha, textoes, textoeus, leido, objeto, destinatario_id, tipo_id) VALUES ('2025-05-15', 'Urko Pérez Vázquez ha trabajado un total de 9h 49m , 0h 49m horas mas de lo establecido', 'Urko Pérez Vázquez 9h 49m egin du lan, gehienezko kopurua baino 0h 49m gehiago', 0, 6, 2, 1);
87	0.09 ms	INSERT INTO notificacion (fecha, textoes, textoeus, leido, objeto, destinatario_id, tipo_id) VALUES (?, ?, ?, ?, ?, ?, ?) Parameters: [`1 => "2025-05-15" 2 => "Urko Pérez Vázquez ha trabajado un total de 9h 49m , 0h 49m horas mas de lo establecido" 3 => "Urko Pérez Vázquez 9h 49m egin du lan, gehienezko kopurua baino 0h 49m gehiago" 4 => 0 5 => 6 6 => 3 7 => 1`] View formatted query View runnable query Explain query INSERT INTO notificacion ( fecha, textoes, textoeus, leido, objeto, destinatario_id, tipo_id ) VALUES (?, ?, ?, ?, ?, ?, ?) INSERT INTO notificacion (fecha, textoes, textoeus, leido, objeto, destinatario_id, tipo_id) VALUES ('2025-05-15', 'Urko Pérez Vázquez ha trabajado un total de 9h 49m , 0h 49m horas mas de lo establecido', 'Urko Pérez Vázquez 9h 49m egin du lan, gehienezko kopurua baino 0h 49m gehiago', 0, 6, 3, 1);
88	0.10 ms	INSERT INTO notificacion (fecha, textoes, textoeus, leido, objeto, destinatario_id, tipo_id) VALUES (?, ?, ?, ?, ?, ?, ?) Parameters: [`1 => "2025-05-15" 2 => "Urko Pérez Vázquez ha trabajado un total de 9h 49m , 0h 49m horas mas de lo establecido" 3 => "Urko Pérez Vázquez 9h 49m egin du lan, gehienezko kopurua baino 0h 49m gehiago" 4 => 0 5 => 6 6 => 4 7 => 1`] View formatted query View runnable query Explain query INSERT INTO notificacion ( fecha, textoes, textoeus, leido, objeto, destinatario_id, tipo_id ) VALUES (?, ?, ?, ?, ?, ?, ?) INSERT INTO notificacion (fecha, textoes, textoeus, leido, objeto, destinatario_id, tipo_id) VALUES ('2025-05-15', 'Urko Pérez Vázquez ha trabajado un total de 9h 49m , 0h 49m horas mas de lo establecido', 'Urko Pérez Vázquez 9h 49m egin du lan, gehienezko kopurua baino 0h 49m gehiago', 0, 6, 4, 1);
89	88.21 ms	"COMMIT" Parameters: [] View formatted query View runnable query Explain query "COMMIT" "COMMIT";
90	1.28 ms	SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = ? AND f0_.fecha LIKE ? ORDER BY f0_.fecha ASC LIMIT 1 Parameters: [`7 "2025-05-15%"`] View formatted query View runnable query Explain query SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = ? AND f0_.fecha LIKE ? ORDER BY f0_.fecha ASC LIMIT 1 SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = 7 AND f0_.fecha LIKE '2025-05-15%' ORDER BY f0_.fecha ASC LIMIT 1;
91	0.87 ms	SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = ? AND f0_.fecha LIKE ? AND f0_.fecha > ? ORDER BY f0_.fecha ASC LIMIT 1 Parameters: [`7 "2025-05-15%" "2025-05-15 09:32:53"`] View formatted query View runnable query Explain query SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = ? AND f0_.fecha LIKE ? AND f0_.fecha > ? ORDER BY f0_.fecha ASC LIMIT 1 SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = 7 AND f0_.fecha LIKE '2025-05-15%' AND f0_.fecha > '2025-05-15 09:32:53' ORDER BY f0_.fecha ASC LIMIT 1;
92	0.78 ms	SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = ? AND f0_.fecha LIKE ? AND f0_.fecha > ? ORDER BY f0_.fecha ASC LIMIT 1 Parameters: [`7 "2025-05-15%" "2025-05-15 14:33:59"`] View formatted query View runnable query Explain query SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = ? AND f0_.fecha LIKE ? AND f0_.fecha > ? ORDER BY f0_.fecha ASC LIMIT 1 SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = 7 AND f0_.fecha LIKE '2025-05-15%' AND f0_.fecha > '2025-05-15 14:33:59' ORDER BY f0_.fecha ASC LIMIT 1;
93	0.96 ms	SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = ? AND f0_.fecha LIKE ? ORDER BY f0_.fecha ASC LIMIT 1 Parameters: [`8 "2025-05-15%"`] View formatted query View runnable query Explain query SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = ? AND f0_.fecha LIKE ? ORDER BY f0_.fecha ASC LIMIT 1 SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = 8 AND f0_.fecha LIKE '2025-05-15%' ORDER BY f0_.fecha ASC LIMIT 1;
94	1.44 ms	SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = ? AND f0_.fecha LIKE ? ORDER BY f0_.fecha ASC LIMIT 1 Parameters: [`9 "2025-05-15%"`] View formatted query View runnable query Explain query SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = ? AND f0_.fecha LIKE ? ORDER BY f0_.fecha ASC LIMIT 1 SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = 9 AND f0_.fecha LIKE '2025-05-15%' ORDER BY f0_.fecha ASC LIMIT 1;
95	1.13 ms	SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = ? AND f0_.fecha LIKE ? AND f0_.fecha > ? ORDER BY f0_.fecha ASC LIMIT 1 Parameters: [`9 "2025-05-15%" "2025-05-15 08:00:30"`] View formatted query View runnable query Explain query SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = ? AND f0_.fecha LIKE ? AND f0_.fecha > ? ORDER BY f0_.fecha ASC LIMIT 1 SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = 9 AND f0_.fecha LIKE '2025-05-15%' AND f0_.fecha > '2025-05-15 08:00:30' ORDER BY f0_.fecha ASC LIMIT 1;
96	1.16 ms	SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = ? AND f0_.fecha LIKE ? AND f0_.fecha > ? ORDER BY f0_.fecha ASC LIMIT 1 Parameters: [`9 "2025-05-15%" "2025-05-15 16:29:20"`] View formatted query View runnable query Explain query SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = ? AND f0_.fecha LIKE ? AND f0_.fecha > ? ORDER BY f0_.fecha ASC LIMIT 1 SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = 9 AND f0_.fecha LIKE '2025-05-15%' AND f0_.fecha > '2025-05-15 16:29:20' ORDER BY f0_.fecha ASC LIMIT 1;
97	1.04 ms	SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = ? AND f0_.fecha LIKE ? ORDER BY f0_.fecha ASC LIMIT 1 Parameters: [`10 "2025-05-15%"`] View formatted query View runnable query Explain query SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = ? AND f0_.fecha LIKE ? ORDER BY f0_.fecha ASC LIMIT 1 SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = 10 AND f0_.fecha LIKE '2025-05-15%' ORDER BY f0_.fecha ASC LIMIT 1;
98	0.85 ms	SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = ? AND f0_.fecha LIKE ? AND f0_.fecha > ? ORDER BY f0_.fecha ASC LIMIT 1 Parameters: [`10 "2025-05-15%" "2025-05-15 09:38:21"`] View formatted query View runnable query Explain query SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = ? AND f0_.fecha LIKE ? AND f0_.fecha > ? ORDER BY f0_.fecha ASC LIMIT 1 SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = 10 AND f0_.fecha LIKE '2025-05-15%' AND f0_.fecha > '2025-05-15 09:38:21' ORDER BY f0_.fecha ASC LIMIT 1;
99	0.82 ms	SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = ? AND f0_.fecha LIKE ? AND f0_.fecha > ? ORDER BY f0_.fecha ASC LIMIT 1 Parameters: [`10 "2025-05-15%" "2025-05-15 16:58:50"`] View formatted query View runnable query Explain query SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = ? AND f0_.fecha LIKE ? AND f0_.fecha > ? ORDER BY f0_.fecha ASC LIMIT 1 SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = 10 AND f0_.fecha LIKE '2025-05-15%' AND f0_.fecha > '2025-05-15 16:58:50' ORDER BY f0_.fecha ASC LIMIT 1;
100	1.38 ms	SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = ? AND f0_.fecha LIKE ? ORDER BY f0_.fecha ASC LIMIT 1 Parameters: [`11 "2025-05-15%"`] View formatted query View runnable query Explain query SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = ? AND f0_.fecha LIKE ? ORDER BY f0_.fecha ASC LIMIT 1 SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = 11 AND f0_.fecha LIKE '2025-05-15%' ORDER BY f0_.fecha ASC LIMIT 1;
101	1.06 ms	SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = ? AND f0_.fecha LIKE ? AND f0_.fecha > ? ORDER BY f0_.fecha ASC LIMIT 1 Parameters: [`11 "2025-05-15%" "2025-05-15 08:59:22"`] View formatted query View runnable query Explain query SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = ? AND f0_.fecha LIKE ? AND f0_.fecha > ? ORDER BY f0_.fecha ASC LIMIT 1 SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = 11 AND f0_.fecha LIKE '2025-05-15%' AND f0_.fecha > '2025-05-15 08:59:22' ORDER BY f0_.fecha ASC LIMIT 1;
102	1.06 ms	SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = ? AND f0_.fecha LIKE ? AND f0_.fecha > ? ORDER BY f0_.fecha ASC LIMIT 1 Parameters: [`11 "2025-05-15%" "2025-05-15 15:00:12"`] View formatted query View runnable query Explain query SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = ? AND f0_.fecha LIKE ? AND f0_.fecha > ? ORDER BY f0_.fecha ASC LIMIT 1 SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = 11 AND f0_.fecha LIKE '2025-05-15%' AND f0_.fecha > '2025-05-15 15:00:12' ORDER BY f0_.fecha ASC LIMIT 1;
103	1.26 ms	SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = ? AND f0_.fecha LIKE ? ORDER BY f0_.fecha ASC LIMIT 1 Parameters: [`12 "2025-05-15%"`] View formatted query View runnable query Explain query SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = ? AND f0_.fecha LIKE ? ORDER BY f0_.fecha ASC LIMIT 1 SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = 12 AND f0_.fecha LIKE '2025-05-15%' ORDER BY f0_.fecha ASC LIMIT 1;
104	1.05 ms	SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = ? AND f0_.fecha LIKE ? AND f0_.fecha > ? ORDER BY f0_.fecha ASC LIMIT 1 Parameters: [`12 "2025-05-15%" "2025-05-15 07:55:06"`] View formatted query View runnable query Explain query SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = ? AND f0_.fecha LIKE ? AND f0_.fecha > ? ORDER BY f0_.fecha ASC LIMIT 1 SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = 12 AND f0_.fecha LIKE '2025-05-15%' AND f0_.fecha > '2025-05-15 07:55:06' ORDER BY f0_.fecha ASC LIMIT 1;
105	1.01 ms	SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = ? AND f0_.fecha LIKE ? AND f0_.fecha > ? ORDER BY f0_.fecha ASC LIMIT 1 Parameters: [`12 "2025-05-15%" "2025-05-15 16:36:38"`] View formatted query View runnable query Explain query SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = ? AND f0_.fecha LIKE ? AND f0_.fecha > ? ORDER BY f0_.fecha ASC LIMIT 1 SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = 12 AND f0_.fecha LIKE '2025-05-15%' AND f0_.fecha > '2025-05-15 16:36:38' ORDER BY f0_.fecha ASC LIMIT 1;
106	0.71 ms	SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = ? AND f0_.fecha LIKE ? ORDER BY f0_.fecha ASC LIMIT 1 Parameters: [`13 "2025-05-15%"`] View formatted query View runnable query Explain query SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = ? AND f0_.fecha LIKE ? ORDER BY f0_.fecha ASC LIMIT 1 SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = 13 AND f0_.fecha LIKE '2025-05-15%' ORDER BY f0_.fecha ASC LIMIT 1;
107	1.22 ms	SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = ? AND f0_.fecha LIKE ? ORDER BY f0_.fecha ASC LIMIT 1 Parameters: [`14 "2025-05-15%"`] View formatted query View runnable query Explain query SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = ? AND f0_.fecha LIKE ? ORDER BY f0_.fecha ASC LIMIT 1 SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = 14 AND f0_.fecha LIKE '2025-05-15%' ORDER BY f0_.fecha ASC LIMIT 1;
108	1.17 ms	SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = ? AND f0_.fecha LIKE ? ORDER BY f0_.fecha ASC LIMIT 1 Parameters: [`15 "2025-05-15%"`] View formatted query View runnable query Explain query SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = ? AND f0_.fecha LIKE ? ORDER BY f0_.fecha ASC LIMIT 1 SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = 15 AND f0_.fecha LIKE '2025-05-15%' ORDER BY f0_.fecha ASC LIMIT 1;
109	1.13 ms	SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = ? AND f0_.fecha LIKE ? ORDER BY f0_.fecha ASC LIMIT 1 Parameters: [`16 "2025-05-15%"`] View formatted query View runnable query Explain query SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = ? AND f0_.fecha LIKE ? ORDER BY f0_.fecha ASC LIMIT 1 SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = 16 AND f0_.fecha LIKE '2025-05-15%' ORDER BY f0_.fecha ASC LIMIT 1;
110	0.94 ms	SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = ? AND f0_.fecha LIKE ? ORDER BY f0_.fecha ASC LIMIT 1 Parameters: [`18 "2025-05-15%"`] View formatted query View runnable query Explain query SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = ? AND f0_.fecha LIKE ? ORDER BY f0_.fecha ASC LIMIT 1 SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = 18 AND f0_.fecha LIKE '2025-05-15%' ORDER BY f0_.fecha ASC LIMIT 1;
111	0.80 ms	SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = ? AND f0_.fecha LIKE ? AND f0_.fecha > ? ORDER BY f0_.fecha ASC LIMIT 1 Parameters: [`18 "2025-05-15%" "2025-05-15 08:04:44"`] View formatted query View runnable query Explain query SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = ? AND f0_.fecha LIKE ? AND f0_.fecha > ? ORDER BY f0_.fecha ASC LIMIT 1 SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = 18 AND f0_.fecha LIKE '2025-05-15%' AND f0_.fecha > '2025-05-15 08:04:44' ORDER BY f0_.fecha ASC LIMIT 1;
112	0.77 ms	SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = ? AND f0_.fecha LIKE ? AND f0_.fecha > ? ORDER BY f0_.fecha ASC LIMIT 1 Parameters: [`18 "2025-05-15%" "2025-05-15 15:59:46"`] View formatted query View runnable query Explain query SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = ? AND f0_.fecha LIKE ? AND f0_.fecha > ? ORDER BY f0_.fecha ASC LIMIT 1 SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = 18 AND f0_.fecha LIKE '2025-05-15%' AND f0_.fecha > '2025-05-15 15:59:46' ORDER BY f0_.fecha ASC LIMIT 1;
113	1.26 ms	SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = ? AND f0_.fecha LIKE ? ORDER BY f0_.fecha ASC LIMIT 1 Parameters: [`19 "2025-05-15%"`] View formatted query View runnable query Explain query SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = ? AND f0_.fecha LIKE ? ORDER BY f0_.fecha ASC LIMIT 1 SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = 19 AND f0_.fecha LIKE '2025-05-15%' ORDER BY f0_.fecha ASC LIMIT 1;
114	1.03 ms	SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = ? AND f0_.fecha LIKE ? AND f0_.fecha > ? ORDER BY f0_.fecha ASC LIMIT 1 Parameters: [`19 "2025-05-15%" "2025-05-15 07:45:47"`] View formatted query View runnable query Explain query SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = ? AND f0_.fecha LIKE ? AND f0_.fecha > ? ORDER BY f0_.fecha ASC LIMIT 1 SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = 19 AND f0_.fecha LIKE '2025-05-15%' AND f0_.fecha > '2025-05-15 07:45:47' ORDER BY f0_.fecha ASC LIMIT 1;
115	1.06 ms	SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = ? AND f0_.fecha LIKE ? AND f0_.fecha > ? ORDER BY f0_.fecha ASC LIMIT 1 Parameters: [`19 "2025-05-15%" "2025-05-15 15:59:06"`] View formatted query View runnable query Explain query SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = ? AND f0_.fecha LIKE ? AND f0_.fecha > ? ORDER BY f0_.fecha ASC LIMIT 1 SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = 19 AND f0_.fecha LIKE '2025-05-15%' AND f0_.fecha > '2025-05-15 15:59:06' ORDER BY f0_.fecha ASC LIMIT 1;
116	1.36 ms	SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = ? AND f0_.fecha LIKE ? ORDER BY f0_.fecha ASC LIMIT 1 Parameters: [`20 "2025-05-15%"`] View formatted query View runnable query Explain query SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = ? AND f0_.fecha LIKE ? ORDER BY f0_.fecha ASC LIMIT 1 SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = 20 AND f0_.fecha LIKE '2025-05-15%' ORDER BY f0_.fecha ASC LIMIT 1;
117	1.09 ms	SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = ? AND f0_.fecha LIKE ? AND f0_.fecha > ? ORDER BY f0_.fecha ASC LIMIT 1 Parameters: [`20 "2025-05-15%" "2025-05-15 07:58:17"`] View formatted query View runnable query Explain query SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = ? AND f0_.fecha LIKE ? AND f0_.fecha > ? ORDER BY f0_.fecha ASC LIMIT 1 SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = 20 AND f0_.fecha LIKE '2025-05-15%' AND f0_.fecha > '2025-05-15 07:58:17' ORDER BY f0_.fecha ASC LIMIT 1;
118	1.05 ms	SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = ? AND f0_.fecha LIKE ? AND f0_.fecha > ? ORDER BY f0_.fecha ASC LIMIT 1 Parameters: [`20 "2025-05-15%" "2025-05-15 16:00:44"`] View formatted query View runnable query Explain query SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = ? AND f0_.fecha LIKE ? AND f0_.fecha > ? ORDER BY f0_.fecha ASC LIMIT 1 SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = 20 AND f0_.fecha LIKE '2025-05-15%' AND f0_.fecha > '2025-05-15 16:00:44' ORDER BY f0_.fecha ASC LIMIT 1;
119	1.03 ms	SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = ? AND f0_.fecha LIKE ? AND f0_.fecha > ? ORDER BY f0_.fecha ASC LIMIT 1 Parameters: [`20 "2025-05-15%" "2025-05-15 17:08:32"`] View formatted query View runnable query Explain query SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = ? AND f0_.fecha LIKE ? AND f0_.fecha > ? ORDER BY f0_.fecha ASC LIMIT 1 SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = 20 AND f0_.fecha LIKE '2025-05-15%' AND f0_.fecha > '2025-05-15 17:08:32' ORDER BY f0_.fecha ASC LIMIT 1;
120	1.06 ms	SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = ? AND f0_.fecha LIKE ? AND f0_.fecha > ? ORDER BY f0_.fecha ASC LIMIT 1 Parameters: [`20 "2025-05-15%" "2025-05-15 18:30:09"`] View formatted query View runnable query Explain query SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = ? AND f0_.fecha LIKE ? AND f0_.fecha > ? ORDER BY f0_.fecha ASC LIMIT 1 SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = 20 AND f0_.fecha LIKE '2025-05-15%' AND f0_.fecha > '2025-05-15 18:30:09' ORDER BY f0_.fecha ASC LIMIT 1;
121	0.15 ms	SELECT t0.id AS id_1, t0.descripcion AS descripcion_2 FROM tipo_notificacion t0 WHERE t0.descripcion = ? LIMIT 1 Parameters: [`"tipoNotificacion.horasSuperadas"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.descripcion AS descripcion_2 FROM tipo_notificacion t0 WHERE t0.descripcion = ? LIMIT 1 SELECT t0.id AS id_1, t0.descripcion AS descripcion_2 FROM tipo_notificacion t0 WHERE t0.descripcion = 'tipoNotificacion.horasSuperadas' LIMIT 1;
122	0.18 ms	SELECT u0_.id AS id_0, u0_.email AS email_1, u0_.roles AS roles_2, u0_.password AS password_3, u0_.is_verified AS is_verified_4, u0_.nombre AS nombre_5, u0_.habilitado AS habilitado_6, u0_.empleada_id AS empleada_id_7, u0_.contacto_id AS contacto_id_8, u0_.contacto_proveedor_id AS contacto_proveedor_id_9 FROM usuario u0_ WHERE u0_.roles LIKE ? Parameters: [`"%"ROLE_ADMIN"%"`] View formatted query View runnable query Explain query SELECT u0_.id AS id_0, u0_.email AS email_1, u0_.roles AS roles_2, u0_.password AS password_3, u0_.is_verified AS is_verified_4, u0_.nombre AS nombre_5, u0_.habilitado AS habilitado_6, u0_.empleada_id AS empleada_id_7, u0_.contacto_id AS contacto_id_8, u0_.contacto_proveedor_id AS contacto_proveedor_id_9 FROM usuario u0_ WHERE u0_.roles LIKE ? SELECT u0_.id AS id_0, u0_.email AS email_1, u0_.roles AS roles_2, u0_.password AS password_3, u0_.is_verified AS is_verified_4, u0_.nombre AS nombre_5, u0_.habilitado AS habilitado_6, u0_.empleada_id AS empleada_id_7, u0_.contacto_id AS contacto_id_8, u0_.contacto_proveedor_id AS contacto_proveedor_id_9 FROM usuario u0_ WHERE u0_.roles LIKE '%\"ROLE_ADMIN\"%';
123	0.07 ms	"START TRANSACTION" Parameters: [] View formatted query View runnable query Explain query "START TRANSACTION" "START TRANSACTION";
124	0.19 ms	INSERT INTO notificacion (fecha, textoes, textoeus, leido, objeto, destinatario_id, tipo_id) VALUES (?, ?, ?, ?, ?, ?, ?) Parameters: [`1 => "2025-05-15" 2 => "Malena González Altuna ha trabajado un total de 9h 24m , 0h 24m horas mas de lo establecido" 3 => "Malena González Altuna 9h 24m egin du lan, gehienezko kopurua baino 0h 24m gehiago" 4 => 0 5 => 20 6 => 20 7 => 1`] View formatted query View runnable query Explain query INSERT INTO notificacion ( fecha, textoes, textoeus, leido, objeto, destinatario_id, tipo_id ) VALUES (?, ?, ?, ?, ?, ?, ?) INSERT INTO notificacion (fecha, textoes, textoeus, leido, objeto, destinatario_id, tipo_id) VALUES ('2025-05-15', 'Malena González Altuna ha trabajado un total de 9h 24m , 0h 24m horas mas de lo establecido', 'Malena González Altuna 9h 24m egin du lan, gehienezko kopurua baino 0h 24m gehiago', 0, 20, 20, 1);
125	0.12 ms	INSERT INTO notificacion (fecha, textoes, textoeus, leido, objeto, destinatario_id, tipo_id) VALUES (?, ?, ?, ?, ?, ?, ?) Parameters: [`1 => "2025-05-15" 2 => "Malena González Altuna ha trabajado un total de 9h 24m , 0h 24m horas mas de lo establecido" 3 => "Malena González Altuna 9h 24m egin du lan, gehienezko kopurua baino 0h 24m gehiago" 4 => 0 5 => 20 6 => 1 7 => 1`] View formatted query View runnable query Explain query INSERT INTO notificacion ( fecha, textoes, textoeus, leido, objeto, destinatario_id, tipo_id ) VALUES (?, ?, ?, ?, ?, ?, ?) INSERT INTO notificacion (fecha, textoes, textoeus, leido, objeto, destinatario_id, tipo_id) VALUES ('2025-05-15', 'Malena González Altuna ha trabajado un total de 9h 24m , 0h 24m horas mas de lo establecido', 'Malena González Altuna 9h 24m egin du lan, gehienezko kopurua baino 0h 24m gehiago', 0, 20, 1, 1);
126	0.11 ms	INSERT INTO notificacion (fecha, textoes, textoeus, leido, objeto, destinatario_id, tipo_id) VALUES (?, ?, ?, ?, ?, ?, ?) Parameters: [`1 => "2025-05-15" 2 => "Malena González Altuna ha trabajado un total de 9h 24m , 0h 24m horas mas de lo establecido" 3 => "Malena González Altuna 9h 24m egin du lan, gehienezko kopurua baino 0h 24m gehiago" 4 => 0 5 => 20 6 => 2 7 => 1`] View formatted query View runnable query Explain query INSERT INTO notificacion ( fecha, textoes, textoeus, leido, objeto, destinatario_id, tipo_id ) VALUES (?, ?, ?, ?, ?, ?, ?) INSERT INTO notificacion (fecha, textoes, textoeus, leido, objeto, destinatario_id, tipo_id) VALUES ('2025-05-15', 'Malena González Altuna ha trabajado un total de 9h 24m , 0h 24m horas mas de lo establecido', 'Malena González Altuna 9h 24m egin du lan, gehienezko kopurua baino 0h 24m gehiago', 0, 20, 2, 1);
127	0.17 ms	INSERT INTO notificacion (fecha, textoes, textoeus, leido, objeto, destinatario_id, tipo_id) VALUES (?, ?, ?, ?, ?, ?, ?) Parameters: [`1 => "2025-05-15" 2 => "Malena González Altuna ha trabajado un total de 9h 24m , 0h 24m horas mas de lo establecido" 3 => "Malena González Altuna 9h 24m egin du lan, gehienezko kopurua baino 0h 24m gehiago" 4 => 0 5 => 20 6 => 3 7 => 1`] View formatted query View runnable query Explain query INSERT INTO notificacion ( fecha, textoes, textoeus, leido, objeto, destinatario_id, tipo_id ) VALUES (?, ?, ?, ?, ?, ?, ?) INSERT INTO notificacion (fecha, textoes, textoeus, leido, objeto, destinatario_id, tipo_id) VALUES ('2025-05-15', 'Malena González Altuna ha trabajado un total de 9h 24m , 0h 24m horas mas de lo establecido', 'Malena González Altuna 9h 24m egin du lan, gehienezko kopurua baino 0h 24m gehiago', 0, 20, 3, 1);
128	0.12 ms	INSERT INTO notificacion (fecha, textoes, textoeus, leido, objeto, destinatario_id, tipo_id) VALUES (?, ?, ?, ?, ?, ?, ?) Parameters: [`1 => "2025-05-15" 2 => "Malena González Altuna ha trabajado un total de 9h 24m , 0h 24m horas mas de lo establecido" 3 => "Malena González Altuna 9h 24m egin du lan, gehienezko kopurua baino 0h 24m gehiago" 4 => 0 5 => 20 6 => 4 7 => 1`] View formatted query View runnable query Explain query INSERT INTO notificacion ( fecha, textoes, textoeus, leido, objeto, destinatario_id, tipo_id ) VALUES (?, ?, ?, ?, ?, ?, ?) INSERT INTO notificacion (fecha, textoes, textoeus, leido, objeto, destinatario_id, tipo_id) VALUES ('2025-05-15', 'Malena González Altuna ha trabajado un total de 9h 24m , 0h 24m horas mas de lo establecido', 'Malena González Altuna 9h 24m egin du lan, gehienezko kopurua baino 0h 24m gehiago', 0, 20, 4, 1);
129	1.68 ms	"COMMIT" Parameters: [] View formatted query View runnable query Explain query "COMMIT" "COMMIT";
130	0.74 ms	SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = ? AND f0_.fecha LIKE ? ORDER BY f0_.fecha ASC LIMIT 1 Parameters: [`21 "2025-05-15%"`] View formatted query View runnable query Explain query SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = ? AND f0_.fecha LIKE ? ORDER BY f0_.fecha ASC LIMIT 1 SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = 21 AND f0_.fecha LIKE '2025-05-15%' ORDER BY f0_.fecha ASC LIMIT 1;
131	2.04 ms	SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = ? AND f0_.fecha LIKE ? ORDER BY f0_.fecha ASC LIMIT 1 Parameters: [`22 "2025-05-15%"`] View formatted query View runnable query Explain query SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = ? AND f0_.fecha LIKE ? ORDER BY f0_.fecha ASC LIMIT 1 SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = 22 AND f0_.fecha LIKE '2025-05-15%' ORDER BY f0_.fecha ASC LIMIT 1;
132	1.68 ms	SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = ? AND f0_.fecha LIKE ? AND f0_.fecha > ? ORDER BY f0_.fecha ASC LIMIT 1 Parameters: [`22 "2025-05-15%" "2025-05-15 07:50:53"`] View formatted query View runnable query Explain query SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = ? AND f0_.fecha LIKE ? AND f0_.fecha > ? ORDER BY f0_.fecha ASC LIMIT 1 SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = 22 AND f0_.fecha LIKE '2025-05-15%' AND f0_.fecha > '2025-05-15 07:50:53' ORDER BY f0_.fecha ASC LIMIT 1;
133	1.81 ms	SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = ? AND f0_.fecha LIKE ? AND f0_.fecha > ? ORDER BY f0_.fecha ASC LIMIT 1 Parameters: [`22 "2025-05-15%" "2025-05-15 16:32:11"`] View formatted query View runnable query Explain query SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = ? AND f0_.fecha LIKE ? AND f0_.fecha > ? ORDER BY f0_.fecha ASC LIMIT 1 SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = 22 AND f0_.fecha LIKE '2025-05-15%' AND f0_.fecha > '2025-05-15 16:32:11' ORDER BY f0_.fecha ASC LIMIT 1;
134	0.87 ms	SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = ? AND f0_.fecha LIKE ? ORDER BY f0_.fecha ASC LIMIT 1 Parameters: [`23 "2025-05-15%"`] View formatted query View runnable query Explain query SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = ? AND f0_.fecha LIKE ? ORDER BY f0_.fecha ASC LIMIT 1 SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = 23 AND f0_.fecha LIKE '2025-05-15%' ORDER BY f0_.fecha ASC LIMIT 1;
135	0.72 ms	SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = ? AND f0_.fecha LIKE ? AND f0_.fecha > ? ORDER BY f0_.fecha ASC LIMIT 1 Parameters: [`23 "2025-05-15%" "2025-05-15 08:44:51"`] View formatted query View runnable query Explain query SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = ? AND f0_.fecha LIKE ? AND f0_.fecha > ? ORDER BY f0_.fecha ASC LIMIT 1 SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = 23 AND f0_.fecha LIKE '2025-05-15%' AND f0_.fecha > '2025-05-15 08:44:51' ORDER BY f0_.fecha ASC LIMIT 1;
136	0.72 ms	SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = ? AND f0_.fecha LIKE ? AND f0_.fecha > ? ORDER BY f0_.fecha ASC LIMIT 1 Parameters: [`23 "2025-05-15%" "2025-05-15 21:00:00"`] View formatted query View runnable query Explain query SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = ? AND f0_.fecha LIKE ? AND f0_.fecha > ? ORDER BY f0_.fecha ASC LIMIT 1 SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = 23 AND f0_.fecha LIKE '2025-05-15%' AND f0_.fecha > '2025-05-15 21:00:00' ORDER BY f0_.fecha ASC LIMIT 1;
137	0.12 ms	SELECT t0.id AS id_1, t0.descripcion AS descripcion_2 FROM tipo_notificacion t0 WHERE t0.descripcion = ? LIMIT 1 Parameters: [`"tipoNotificacion.horasSuperadas"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.descripcion AS descripcion_2 FROM tipo_notificacion t0 WHERE t0.descripcion = ? LIMIT 1 SELECT t0.id AS id_1, t0.descripcion AS descripcion_2 FROM tipo_notificacion t0 WHERE t0.descripcion = 'tipoNotificacion.horasSuperadas' LIMIT 1;
138	0.19 ms	SELECT u0_.id AS id_0, u0_.email AS email_1, u0_.roles AS roles_2, u0_.password AS password_3, u0_.is_verified AS is_verified_4, u0_.nombre AS nombre_5, u0_.habilitado AS habilitado_6, u0_.empleada_id AS empleada_id_7, u0_.contacto_id AS contacto_id_8, u0_.contacto_proveedor_id AS contacto_proveedor_id_9 FROM usuario u0_ WHERE u0_.roles LIKE ? Parameters: [`"%"ROLE_ADMIN"%"`] View formatted query View runnable query Explain query SELECT u0_.id AS id_0, u0_.email AS email_1, u0_.roles AS roles_2, u0_.password AS password_3, u0_.is_verified AS is_verified_4, u0_.nombre AS nombre_5, u0_.habilitado AS habilitado_6, u0_.empleada_id AS empleada_id_7, u0_.contacto_id AS contacto_id_8, u0_.contacto_proveedor_id AS contacto_proveedor_id_9 FROM usuario u0_ WHERE u0_.roles LIKE ? SELECT u0_.id AS id_0, u0_.email AS email_1, u0_.roles AS roles_2, u0_.password AS password_3, u0_.is_verified AS is_verified_4, u0_.nombre AS nombre_5, u0_.habilitado AS habilitado_6, u0_.empleada_id AS empleada_id_7, u0_.contacto_id AS contacto_id_8, u0_.contacto_proveedor_id AS contacto_proveedor_id_9 FROM usuario u0_ WHERE u0_.roles LIKE '%\"ROLE_ADMIN\"%';
139	0.06 ms	"START TRANSACTION" Parameters: [] View formatted query View runnable query Explain query "START TRANSACTION" "START TRANSACTION";
140	0.15 ms	INSERT INTO notificacion (fecha, textoes, textoeus, leido, objeto, destinatario_id, tipo_id) VALUES (?, ?, ?, ?, ?, ?, ?) Parameters: [`1 => "2025-05-15" 2 => "Maria Teresa Iglesias Sánchez ha trabajado un total de 12h 15m , 3h 15m horas mas de lo establecido" 3 => "Maria Teresa Iglesias Sánchez 12h 15m egin du lan, gehienezko kopurua baino 3h 15m gehiago" 4 => 0 5 => 23 6 => 23 7 => 1`] View formatted query View runnable query Explain query INSERT INTO notificacion ( fecha, textoes, textoeus, leido, objeto, destinatario_id, tipo_id ) VALUES (?, ?, ?, ?, ?, ?, ?) INSERT INTO notificacion (fecha, textoes, textoeus, leido, objeto, destinatario_id, tipo_id) VALUES ('2025-05-15', 'Maria Teresa Iglesias Sánchez ha trabajado un total de 12h 15m , 3h 15m horas mas de lo establecido', 'Maria Teresa Iglesias Sánchez 12h 15m egin du lan, gehienezko kopurua baino 3h 15m gehiago', 0, 23, 23, 1);
141	0.17 ms	INSERT INTO notificacion (fecha, textoes, textoeus, leido, objeto, destinatario_id, tipo_id) VALUES (?, ?, ?, ?, ?, ?, ?) Parameters: [`1 => "2025-05-15" 2 => "Maria Teresa Iglesias Sánchez ha trabajado un total de 12h 15m , 3h 15m horas mas de lo establecido" 3 => "Maria Teresa Iglesias Sánchez 12h 15m egin du lan, gehienezko kopurua baino 3h 15m gehiago" 4 => 0 5 => 23 6 => 1 7 => 1`] View formatted query View runnable query Explain query INSERT INTO notificacion ( fecha, textoes, textoeus, leido, objeto, destinatario_id, tipo_id ) VALUES (?, ?, ?, ?, ?, ?, ?) INSERT INTO notificacion (fecha, textoes, textoeus, leido, objeto, destinatario_id, tipo_id) VALUES ('2025-05-15', 'Maria Teresa Iglesias Sánchez ha trabajado un total de 12h 15m , 3h 15m horas mas de lo establecido', 'Maria Teresa Iglesias Sánchez 12h 15m egin du lan, gehienezko kopurua baino 3h 15m gehiago', 0, 23, 1, 1);
142	0.13 ms	INSERT INTO notificacion (fecha, textoes, textoeus, leido, objeto, destinatario_id, tipo_id) VALUES (?, ?, ?, ?, ?, ?, ?) Parameters: [`1 => "2025-05-15" 2 => "Maria Teresa Iglesias Sánchez ha trabajado un total de 12h 15m , 3h 15m horas mas de lo establecido" 3 => "Maria Teresa Iglesias Sánchez 12h 15m egin du lan, gehienezko kopurua baino 3h 15m gehiago" 4 => 0 5 => 23 6 => 2 7 => 1`] View formatted query View runnable query Explain query INSERT INTO notificacion ( fecha, textoes, textoeus, leido, objeto, destinatario_id, tipo_id ) VALUES (?, ?, ?, ?, ?, ?, ?) INSERT INTO notificacion (fecha, textoes, textoeus, leido, objeto, destinatario_id, tipo_id) VALUES ('2025-05-15', 'Maria Teresa Iglesias Sánchez ha trabajado un total de 12h 15m , 3h 15m horas mas de lo establecido', 'Maria Teresa Iglesias Sánchez 12h 15m egin du lan, gehienezko kopurua baino 3h 15m gehiago', 0, 23, 2, 1);
143	0.11 ms	INSERT INTO notificacion (fecha, textoes, textoeus, leido, objeto, destinatario_id, tipo_id) VALUES (?, ?, ?, ?, ?, ?, ?) Parameters: [`1 => "2025-05-15" 2 => "Maria Teresa Iglesias Sánchez ha trabajado un total de 12h 15m , 3h 15m horas mas de lo establecido" 3 => "Maria Teresa Iglesias Sánchez 12h 15m egin du lan, gehienezko kopurua baino 3h 15m gehiago" 4 => 0 5 => 23 6 => 3 7 => 1`] View formatted query View runnable query Explain query INSERT INTO notificacion ( fecha, textoes, textoeus, leido, objeto, destinatario_id, tipo_id ) VALUES (?, ?, ?, ?, ?, ?, ?) INSERT INTO notificacion (fecha, textoes, textoeus, leido, objeto, destinatario_id, tipo_id) VALUES ('2025-05-15', 'Maria Teresa Iglesias Sánchez ha trabajado un total de 12h 15m , 3h 15m horas mas de lo establecido', 'Maria Teresa Iglesias Sánchez 12h 15m egin du lan, gehienezko kopurua baino 3h 15m gehiago', 0, 23, 3, 1);
144	0.10 ms	INSERT INTO notificacion (fecha, textoes, textoeus, leido, objeto, destinatario_id, tipo_id) VALUES (?, ?, ?, ?, ?, ?, ?) Parameters: [`1 => "2025-05-15" 2 => "Maria Teresa Iglesias Sánchez ha trabajado un total de 12h 15m , 3h 15m horas mas de lo establecido" 3 => "Maria Teresa Iglesias Sánchez 12h 15m egin du lan, gehienezko kopurua baino 3h 15m gehiago" 4 => 0 5 => 23 6 => 4 7 => 1`] View formatted query View runnable query Explain query INSERT INTO notificacion ( fecha, textoes, textoeus, leido, objeto, destinatario_id, tipo_id ) VALUES (?, ?, ?, ?, ?, ?, ?) INSERT INTO notificacion (fecha, textoes, textoeus, leido, objeto, destinatario_id, tipo_id) VALUES ('2025-05-15', 'Maria Teresa Iglesias Sánchez ha trabajado un total de 12h 15m , 3h 15m horas mas de lo establecido', 'Maria Teresa Iglesias Sánchez 12h 15m egin du lan, gehienezko kopurua baino 3h 15m gehiago', 0, 23, 4, 1);
145	1.50 ms	"COMMIT" Parameters: [] View formatted query View runnable query Explain query "COMMIT" "COMMIT";
146	0.50 ms	SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = ? AND f0_.fecha LIKE ? ORDER BY f0_.fecha ASC LIMIT 1 Parameters: [`24 "2025-05-15%"`] View formatted query View runnable query Explain query SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = ? AND f0_.fecha LIKE ? ORDER BY f0_.fecha ASC LIMIT 1 SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = 24 AND f0_.fecha LIKE '2025-05-15%' ORDER BY f0_.fecha ASC LIMIT 1;
147	0.47 ms	SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = ? AND f0_.fecha LIKE ? ORDER BY f0_.fecha ASC LIMIT 1 Parameters: [`25 "2025-05-15%"`] View formatted query View runnable query Explain query SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = ? AND f0_.fecha LIKE ? ORDER BY f0_.fecha ASC LIMIT 1 SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = 25 AND f0_.fecha LIKE '2025-05-15%' ORDER BY f0_.fecha ASC LIMIT 1;
148	2.00 ms	SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = ? AND f0_.fecha LIKE ? ORDER BY f0_.fecha ASC LIMIT 1 Parameters: [`26 "2025-05-15%"`] View formatted query View runnable query Explain query SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = ? AND f0_.fecha LIKE ? ORDER BY f0_.fecha ASC LIMIT 1 SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = 26 AND f0_.fecha LIKE '2025-05-15%' ORDER BY f0_.fecha ASC LIMIT 1;
149	0.76 ms	SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = ? AND f0_.fecha LIKE ? ORDER BY f0_.fecha ASC LIMIT 1 Parameters: [`27 "2025-05-15%"`] View formatted query View runnable query Explain query SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = ? AND f0_.fecha LIKE ? ORDER BY f0_.fecha ASC LIMIT 1 SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = 27 AND f0_.fecha LIKE '2025-05-15%' ORDER BY f0_.fecha ASC LIMIT 1;
150	0.30 ms	SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = ? AND f0_.fecha LIKE ? ORDER BY f0_.fecha ASC LIMIT 1 Parameters: [`28 "2025-05-15%"`] View formatted query View runnable query Explain query SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = ? AND f0_.fecha LIKE ? ORDER BY f0_.fecha ASC LIMIT 1 SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = 28 AND f0_.fecha LIKE '2025-05-15%' ORDER BY f0_.fecha ASC LIMIT 1;
151	0.49 ms	SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = ? AND f0_.fecha LIKE ? ORDER BY f0_.fecha ASC LIMIT 1 Parameters: [`29 "2025-05-15%"`] View formatted query View runnable query Explain query SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = ? AND f0_.fecha LIKE ? ORDER BY f0_.fecha ASC LIMIT 1 SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = 29 AND f0_.fecha LIKE '2025-05-15%' ORDER BY f0_.fecha ASC LIMIT 1;
152	0.80 ms	SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = ? AND f0_.fecha LIKE ? ORDER BY f0_.fecha ASC LIMIT 1 Parameters: [`30 "2025-05-15%"`] View formatted query View runnable query Explain query SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = ? AND f0_.fecha LIKE ? ORDER BY f0_.fecha ASC LIMIT 1 SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = 30 AND f0_.fecha LIKE '2025-05-15%' ORDER BY f0_.fecha ASC LIMIT 1;
153	0.66 ms	SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = ? AND f0_.fecha LIKE ? AND f0_.fecha > ? ORDER BY f0_.fecha ASC LIMIT 1 Parameters: [`30 "2025-05-15%" "2025-05-15 09:00:59"`] View formatted query View runnable query Explain query SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = ? AND f0_.fecha LIKE ? AND f0_.fecha > ? ORDER BY f0_.fecha ASC LIMIT 1 SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = 30 AND f0_.fecha LIKE '2025-05-15%' AND f0_.fecha > '2025-05-15 09:00:59' ORDER BY f0_.fecha ASC LIMIT 1;
154	0.66 ms	SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = ? AND f0_.fecha LIKE ? AND f0_.fecha > ? ORDER BY f0_.fecha ASC LIMIT 1 Parameters: [`30 "2025-05-15%" "2025-05-15 17:03:54"`] View formatted query View runnable query Explain query SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = ? AND f0_.fecha LIKE ? AND f0_.fecha > ? ORDER BY f0_.fecha ASC LIMIT 1 SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = 30 AND f0_.fecha LIKE '2025-05-15%' AND f0_.fecha > '2025-05-15 17:03:54' ORDER BY f0_.fecha ASC LIMIT 1;
155	0.23 ms	SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = ? AND f0_.fecha LIKE ? ORDER BY f0_.fecha ASC LIMIT 1 Parameters: [`31 "2025-05-15%"`] View formatted query View runnable query Explain query SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = ? AND f0_.fecha LIKE ? ORDER BY f0_.fecha ASC LIMIT 1 SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = 31 AND f0_.fecha LIKE '2025-05-15%' ORDER BY f0_.fecha ASC LIMIT 1;
156	0.29 ms	SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = ? AND f0_.fecha LIKE ? ORDER BY f0_.fecha ASC LIMIT 1 Parameters: [`32 "2025-05-15%"`] View formatted query View runnable query Explain query SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = ? AND f0_.fecha LIKE ? ORDER BY f0_.fecha ASC LIMIT 1 SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = 32 AND f0_.fecha LIKE '2025-05-15%' ORDER BY f0_.fecha ASC LIMIT 1;
157	0.49 ms	SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = ? AND f0_.fecha LIKE ? ORDER BY f0_.fecha ASC LIMIT 1 Parameters: [`33 "2025-05-15%"`] View formatted query View runnable query Explain query SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = ? AND f0_.fecha LIKE ? ORDER BY f0_.fecha ASC LIMIT 1 SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = 33 AND f0_.fecha LIKE '2025-05-15%' ORDER BY f0_.fecha ASC LIMIT 1;
158	0.42 ms	SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = ? AND f0_.fecha LIKE ? AND f0_.fecha > ? ORDER BY f0_.fecha ASC LIMIT 1 Parameters: [`33 "2025-05-15%" "2025-05-15 08:18:22"`] View formatted query View runnable query Explain query SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = ? AND f0_.fecha LIKE ? AND f0_.fecha > ? ORDER BY f0_.fecha ASC LIMIT 1 SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = 33 AND f0_.fecha LIKE '2025-05-15%' AND f0_.fecha > '2025-05-15 08:18:22' ORDER BY f0_.fecha ASC LIMIT 1;
159	0.42 ms	SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = ? AND f0_.fecha LIKE ? AND f0_.fecha > ? ORDER BY f0_.fecha ASC LIMIT 1 Parameters: [`33 "2025-05-15%" "2025-05-15 16:22:15"`] View formatted query View runnable query Explain query SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = ? AND f0_.fecha LIKE ? AND f0_.fecha > ? ORDER BY f0_.fecha ASC LIMIT 1 SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = 33 AND f0_.fecha LIKE '2025-05-15%' AND f0_.fecha > '2025-05-15 16:22:15' ORDER BY f0_.fecha ASC LIMIT 1;
160	0.23 ms	SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = ? AND f0_.fecha LIKE ? ORDER BY f0_.fecha ASC LIMIT 1 Parameters: [`34 "2025-05-15%"`] View formatted query View runnable query Explain query SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = ? AND f0_.fecha LIKE ? ORDER BY f0_.fecha ASC LIMIT 1 SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = 34 AND f0_.fecha LIKE '2025-05-15%' ORDER BY f0_.fecha ASC LIMIT 1;
161	0.20 ms	SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = ? AND f0_.fecha LIKE ? ORDER BY f0_.fecha ASC LIMIT 1 Parameters: [`35 "2025-05-15%"`] View formatted query View runnable query Explain query SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = ? AND f0_.fecha LIKE ? ORDER BY f0_.fecha ASC LIMIT 1 SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = 35 AND f0_.fecha LIKE '2025-05-15%' ORDER BY f0_.fecha ASC LIMIT 1;
162	0.15 ms	SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = ? AND f0_.fecha LIKE ? ORDER BY f0_.fecha ASC LIMIT 1 Parameters: [`36 "2025-05-15%"`] View formatted query View runnable query Explain query SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = ? AND f0_.fecha LIKE ? ORDER BY f0_.fecha ASC LIMIT 1 SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = 36 AND f0_.fecha LIKE '2025-05-15%' ORDER BY f0_.fecha ASC LIMIT 1;
163	0.17 ms	SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = ? AND f0_.fecha LIKE ? AND f0_.fecha > ? ORDER BY f0_.fecha ASC LIMIT 1 Parameters: [`36 "2025-05-15%" "2025-05-15 08:09:46"`] View formatted query View runnable query Explain query SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = ? AND f0_.fecha LIKE ? AND f0_.fecha > ? ORDER BY f0_.fecha ASC LIMIT 1 SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = 36 AND f0_.fecha LIKE '2025-05-15%' AND f0_.fecha > '2025-05-15 08:09:46' ORDER BY f0_.fecha ASC LIMIT 1;
164	0.23 ms	SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = ? AND f0_.fecha LIKE ? AND f0_.fecha > ? ORDER BY f0_.fecha ASC LIMIT 1 Parameters: [`36 "2025-05-15%" "2025-05-15 16:00:25"`] View formatted query View runnable query Explain query SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = ? AND f0_.fecha LIKE ? AND f0_.fecha > ? ORDER BY f0_.fecha ASC LIMIT 1 SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = 36 AND f0_.fecha LIKE '2025-05-15%' AND f0_.fecha > '2025-05-15 16:00:25' ORDER BY f0_.fecha ASC LIMIT 1;
165	0.13 ms	SELECT t0.id AS id_1, t0.hora_inicio AS hora_inicio_2, t0.hora_fin AS hora_fin_3, t0.hora_aviso_max AS hora_aviso_max_4, t0.hora_aviso_min AS hora_aviso_min_5, t0.justificacion_aviso1 AS justificacion_aviso1_6, t0.justificacion_aviso2 AS justificacion_aviso2_7, t0.justificacion_aviso3 AS justificacion_aviso3_8 FROM globales t0 LIMIT 1 Parameters: [] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.hora_inicio AS hora_inicio_2, t0.hora_fin AS hora_fin_3, t0.hora_aviso_max AS hora_aviso_max_4, t0.hora_aviso_min AS hora_aviso_min_5, t0.justificacion_aviso1 AS justificacion_aviso1_6, t0.justificacion_aviso2 AS justificacion_aviso2_7, t0.justificacion_aviso3 AS justificacion_aviso3_8 FROM globales t0 LIMIT 1 SELECT t0.id AS id_1, t0.hora_inicio AS hora_inicio_2, t0.hora_fin AS hora_fin_3, t0.hora_aviso_max AS hora_aviso_max_4, t0.hora_aviso_min AS hora_aviso_min_5, t0.justificacion_aviso1 AS justificacion_aviso1_6, t0.justificacion_aviso2 AS justificacion_aviso2_7, t0.justificacion_aviso3 AS justificacion_aviso3_8 FROM globales t0 LIMIT 1;
166	0.13 ms	SELECT t0.id AS id_1, t0.descripcion AS descripcion_2 FROM tipo_notificacion t0 WHERE t0.descripcion = ? LIMIT 1 Parameters: [`"tipoNotificacion.justificacion1"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.descripcion AS descripcion_2 FROM tipo_notificacion t0 WHERE t0.descripcion = ? LIMIT 1 SELECT t0.id AS id_1, t0.descripcion AS descripcion_2 FROM tipo_notificacion t0 WHERE t0.descripcion = 'tipoNotificacion.justificacion1' LIMIT 1;
167	0.10 ms	SELECT t0.id AS id_1, t0.descripcion AS descripcion_2 FROM tipo_notificacion t0 WHERE t0.descripcion = ? LIMIT 1 Parameters: [`"tipoNotificacion.justificacion2"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.descripcion AS descripcion_2 FROM tipo_notificacion t0 WHERE t0.descripcion = ? LIMIT 1 SELECT t0.id AS id_1, t0.descripcion AS descripcion_2 FROM tipo_notificacion t0 WHERE t0.descripcion = 'tipoNotificacion.justificacion2' LIMIT 1;
168	0.11 ms	SELECT t0.id AS id_1, t0.descripcion AS descripcion_2 FROM tipo_notificacion t0 WHERE t0.descripcion = ? LIMIT 1 Parameters: [`"tipoNotificacion.justificacion3"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.descripcion AS descripcion_2 FROM tipo_notificacion t0 WHERE t0.descripcion = ? LIMIT 1 SELECT t0.id AS id_1, t0.descripcion AS descripcion_2 FROM tipo_notificacion t0 WHERE t0.descripcion = 'tipoNotificacion.justificacion3' LIMIT 1;
169	0.24 ms	SELECT t0.id AS id_1, t0.fecha AS fecha_2, t0.nombre AS nombre_3, t0.presentada AS presentada_4, t0.observaciones AS observaciones_5, t0.fecha_presentada AS fecha_presentada_6, t0.proyecto_id AS proyecto_id_7 FROM justificacion t0 WHERE t0.presentada = ? Parameters: [`0`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.fecha AS fecha_2, t0.nombre AS nombre_3, t0.presentada AS presentada_4, t0.observaciones AS observaciones_5, t0.fecha_presentada AS fecha_presentada_6, t0.proyecto_id AS proyecto_id_7 FROM justificacion t0 WHERE t0.presentada = ? SELECT t0.id AS id_1, t0.fecha AS fecha_2, t0.nombre AS nombre_3, t0.presentada AS presentada_4, t0.observaciones AS observaciones_5, t0.fecha_presentada AS fecha_presentada_6, t0.proyecto_id AS proyecto_id_7 FROM justificacion t0 WHERE t0.presentada = 0;
170	0.19 ms	SELECT u0_.id AS id_0, u0_.email AS email_1, u0_.roles AS roles_2, u0_.password AS password_3, u0_.is_verified AS is_verified_4, u0_.nombre AS nombre_5, u0_.habilitado AS habilitado_6, u0_.empleada_id AS empleada_id_7, u0_.contacto_id AS contacto_id_8, u0_.contacto_proveedor_id AS contacto_proveedor_id_9 FROM usuario u0_ WHERE u0_.roles LIKE ? Parameters: [`"%"ROLE_ADMIN"%"`] View formatted query View runnable query Explain query SELECT u0_.id AS id_0, u0_.email AS email_1, u0_.roles AS roles_2, u0_.password AS password_3, u0_.is_verified AS is_verified_4, u0_.nombre AS nombre_5, u0_.habilitado AS habilitado_6, u0_.empleada_id AS empleada_id_7, u0_.contacto_id AS contacto_id_8, u0_.contacto_proveedor_id AS contacto_proveedor_id_9 FROM usuario u0_ WHERE u0_.roles LIKE ? SELECT u0_.id AS id_0, u0_.email AS email_1, u0_.roles AS roles_2, u0_.password AS password_3, u0_.is_verified AS is_verified_4, u0_.nombre AS nombre_5, u0_.habilitado AS habilitado_6, u0_.empleada_id AS empleada_id_7, u0_.contacto_id AS contacto_id_8, u0_.contacto_proveedor_id AS contacto_proveedor_id_9 FROM usuario u0_ WHERE u0_.roles LIKE '%\"ROLE_ADMIN\"%';
171	0.11 ms	SELECT t0.id AS id_1, t0.descripcion AS descripcion_2 FROM tipo_notificacion t0 WHERE t0.descripcion = ? LIMIT 1 Parameters: [`"tipoNotificacion.horasSuperadas"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.descripcion AS descripcion_2 FROM tipo_notificacion t0 WHERE t0.descripcion = ? LIMIT 1 SELECT t0.id AS id_1, t0.descripcion AS descripcion_2 FROM tipo_notificacion t0 WHERE t0.descripcion = 'tipoNotificacion.horasSuperadas' LIMIT 1;
172	0.10 ms	SELECT t0.id AS id_1, t0.descripcion AS descripcion_2 FROM tipo_notificacion t0 WHERE t0.descripcion = ? LIMIT 1 Parameters: [`"tipoNotificacion.horasNoCumplidas"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.descripcion AS descripcion_2 FROM tipo_notificacion t0 WHERE t0.descripcion = ? LIMIT 1 SELECT t0.id AS id_1, t0.descripcion AS descripcion_2 FROM tipo_notificacion t0 WHERE t0.descripcion = 'tipoNotificacion.horasNoCumplidas' LIMIT 1;
173	0.11 ms	SELECT t0.id AS id_1, t0.descripcion AS descripcion_2 FROM tipo_notificacion t0 WHERE t0.descripcion = ? LIMIT 1 Parameters: [`"tipoNotificacion.fichajeNoCerrado"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.descripcion AS descripcion_2 FROM tipo_notificacion t0 WHERE t0.descripcion = ? LIMIT 1 SELECT t0.id AS id_1, t0.descripcion AS descripcion_2 FROM tipo_notificacion t0 WHERE t0.descripcion = 'tipoNotificacion.fichajeNoCerrado' LIMIT 1;
174	31.26 ms	SELECT t0.id AS id_1, t0.fecha AS fecha_2, t0.textoes AS textoes_3, t0.textoeus AS textoeus_4, t0.leido AS leido_5, t0.objeto AS objeto_6, t0.destinatario_id AS destinatario_id_7, t0.tipo_id AS tipo_id_8 FROM notificacion t0 WHERE t0.tipo_id = ? AND t0.fecha = ? AND t0.destinatario_id = ? ORDER BY t0.fecha DESC Parameters: [`1 "2025-05-15" 1`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.fecha AS fecha_2, t0.textoes AS textoes_3, t0.textoeus AS textoeus_4, t0.leido AS leido_5, t0.objeto AS objeto_6, t0.destinatario_id AS destinatario_id_7, t0.tipo_id AS tipo_id_8 FROM notificacion t0 WHERE t0.tipo_id = ? AND t0.fecha = ? AND t0.destinatario_id = ? ORDER BY t0.fecha DESC SELECT t0.id AS id_1, t0.fecha AS fecha_2, t0.textoes AS textoes_3, t0.textoeus AS textoeus_4, t0.leido AS leido_5, t0.objeto AS objeto_6, t0.destinatario_id AS destinatario_id_7, t0.tipo_id AS tipo_id_8 FROM notificacion t0 WHERE t0.tipo_id = 1 AND t0.fecha = '2025-05-15' AND t0.destinatario_id = 1 ORDER BY t0.fecha DESC;
175	9.49 ms	SELECT t0.id AS id_1, t0.fecha AS fecha_2, t0.textoes AS textoes_3, t0.textoeus AS textoeus_4, t0.leido AS leido_5, t0.objeto AS objeto_6, t0.destinatario_id AS destinatario_id_7, t0.tipo_id AS tipo_id_8 FROM notificacion t0 WHERE t0.tipo_id = ? AND t0.fecha = ? AND t0.destinatario_id = ? ORDER BY t0.fecha DESC Parameters: [`2 "2025-05-15" 1`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.fecha AS fecha_2, t0.textoes AS textoes_3, t0.textoeus AS textoeus_4, t0.leido AS leido_5, t0.objeto AS objeto_6, t0.destinatario_id AS destinatario_id_7, t0.tipo_id AS tipo_id_8 FROM notificacion t0 WHERE t0.tipo_id = ? AND t0.fecha = ? AND t0.destinatario_id = ? ORDER BY t0.fecha DESC SELECT t0.id AS id_1, t0.fecha AS fecha_2, t0.textoes AS textoes_3, t0.textoeus AS textoeus_4, t0.leido AS leido_5, t0.objeto AS objeto_6, t0.destinatario_id AS destinatario_id_7, t0.tipo_id AS tipo_id_8 FROM notificacion t0 WHERE t0.tipo_id = 2 AND t0.fecha = '2025-05-15' AND t0.destinatario_id = 1 ORDER BY t0.fecha DESC;
176	5.45 ms	SELECT t0.id AS id_1, t0.fecha AS fecha_2, t0.textoes AS textoes_3, t0.textoeus AS textoeus_4, t0.leido AS leido_5, t0.objeto AS objeto_6, t0.destinatario_id AS destinatario_id_7, t0.tipo_id AS tipo_id_8 FROM notificacion t0 WHERE t0.tipo_id = ? AND t0.fecha = ? AND t0.destinatario_id = ? ORDER BY t0.fecha DESC Parameters: [`3 "2025-05-15" 1`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.fecha AS fecha_2, t0.textoes AS textoes_3, t0.textoeus AS textoeus_4, t0.leido AS leido_5, t0.objeto AS objeto_6, t0.destinatario_id AS destinatario_id_7, t0.tipo_id AS tipo_id_8 FROM notificacion t0 WHERE t0.tipo_id = ? AND t0.fecha = ? AND t0.destinatario_id = ? ORDER BY t0.fecha DESC SELECT t0.id AS id_1, t0.fecha AS fecha_2, t0.textoes AS textoes_3, t0.textoeus AS textoeus_4, t0.leido AS leido_5, t0.objeto AS objeto_6, t0.destinatario_id AS destinatario_id_7, t0.tipo_id AS tipo_id_8 FROM notificacion t0 WHERE t0.tipo_id = 3 AND t0.fecha = '2025-05-15' AND t0.destinatario_id = 1 ORDER BY t0.fecha DESC;
177	5.46 ms	SELECT n0_.id AS id_0, n0_.fecha AS fecha_1, n0_.textoes AS textoes_2, n0_.textoeus AS textoeus_3, n0_.leido AS leido_4, n0_.objeto AS objeto_5, n0_.destinatario_id AS destinatario_id_6, n0_.tipo_id AS tipo_id_7 FROM notificacion n0_ INNER JOIN tipo_notificacion t1_ ON n0_.tipo_id = t1_.id WHERE t1_.descripcion LIKE ? AND n0_.destinatario_id = ? AND n0_.fecha = ? ORDER BY n0_.fecha DESC Parameters: [`"tipoNotificacion.justificacion%" 1 "2025-05-15"`] View formatted query View runnable query Explain query SELECT n0_.id AS id_0, n0_.fecha AS fecha_1, n0_.textoes AS textoes_2, n0_.textoeus AS textoeus_3, n0_.leido AS leido_4, n0_.objeto AS objeto_5, n0_.destinatario_id AS destinatario_id_6, n0_.tipo_id AS tipo_id_7 FROM notificacion n0_ INNER JOIN tipo_notificacion t1_ ON n0_.tipo_id = t1_.id WHERE t1_.descripcion LIKE ? AND n0_.destinatario_id = ? AND n0_.fecha = ? ORDER BY n0_.fecha DESC SELECT n0_.id AS id_0, n0_.fecha AS fecha_1, n0_.textoes AS textoes_2, n0_.textoeus AS textoeus_3, n0_.leido AS leido_4, n0_.objeto AS objeto_5, n0_.destinatario_id AS destinatario_id_6, n0_.tipo_id AS tipo_id_7 FROM notificacion n0_ INNER JOIN tipo_notificacion t1_ ON n0_.tipo_id = t1_.id WHERE t1_.descripcion LIKE 'tipoNotificacion.justificacion%' AND n0_.destinatario_id = 1 AND n0_.fecha = '2025-05-15' ORDER BY n0_.fecha DESC;
178	6.88 ms	SELECT t0.id AS id_1, t0.fecha AS fecha_2, t0.textoes AS textoes_3, t0.textoeus AS textoeus_4, t0.leido AS leido_5, t0.objeto AS objeto_6, t0.destinatario_id AS destinatario_id_7, t0.tipo_id AS tipo_id_8 FROM notificacion t0 WHERE t0.tipo_id = ? AND t0.fecha = ? AND t0.destinatario_id = ? ORDER BY t0.fecha DESC Parameters: [`1 "2025-05-15" 2`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.fecha AS fecha_2, t0.textoes AS textoes_3, t0.textoeus AS textoeus_4, t0.leido AS leido_5, t0.objeto AS objeto_6, t0.destinatario_id AS destinatario_id_7, t0.tipo_id AS tipo_id_8 FROM notificacion t0 WHERE t0.tipo_id = ? AND t0.fecha = ? AND t0.destinatario_id = ? ORDER BY t0.fecha DESC SELECT t0.id AS id_1, t0.fecha AS fecha_2, t0.textoes AS textoes_3, t0.textoeus AS textoeus_4, t0.leido AS leido_5, t0.objeto AS objeto_6, t0.destinatario_id AS destinatario_id_7, t0.tipo_id AS tipo_id_8 FROM notificacion t0 WHERE t0.tipo_id = 1 AND t0.fecha = '2025-05-15' AND t0.destinatario_id = 2 ORDER BY t0.fecha DESC;
179	2.16 ms	SELECT t0.id AS id_1, t0.fecha AS fecha_2, t0.textoes AS textoes_3, t0.textoeus AS textoeus_4, t0.leido AS leido_5, t0.objeto AS objeto_6, t0.destinatario_id AS destinatario_id_7, t0.tipo_id AS tipo_id_8 FROM notificacion t0 WHERE t0.tipo_id = ? AND t0.fecha = ? AND t0.destinatario_id = ? ORDER BY t0.fecha DESC Parameters: [`2 "2025-05-15" 2`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.fecha AS fecha_2, t0.textoes AS textoes_3, t0.textoeus AS textoeus_4, t0.leido AS leido_5, t0.objeto AS objeto_6, t0.destinatario_id AS destinatario_id_7, t0.tipo_id AS tipo_id_8 FROM notificacion t0 WHERE t0.tipo_id = ? AND t0.fecha = ? AND t0.destinatario_id = ? ORDER BY t0.fecha DESC SELECT t0.id AS id_1, t0.fecha AS fecha_2, t0.textoes AS textoes_3, t0.textoeus AS textoeus_4, t0.leido AS leido_5, t0.objeto AS objeto_6, t0.destinatario_id AS destinatario_id_7, t0.tipo_id AS tipo_id_8 FROM notificacion t0 WHERE t0.tipo_id = 2 AND t0.fecha = '2025-05-15' AND t0.destinatario_id = 2 ORDER BY t0.fecha DESC;
180	5.16 ms	SELECT t0.id AS id_1, t0.fecha AS fecha_2, t0.textoes AS textoes_3, t0.textoeus AS textoeus_4, t0.leido AS leido_5, t0.objeto AS objeto_6, t0.destinatario_id AS destinatario_id_7, t0.tipo_id AS tipo_id_8 FROM notificacion t0 WHERE t0.tipo_id = ? AND t0.fecha = ? AND t0.destinatario_id = ? ORDER BY t0.fecha DESC Parameters: [`3 "2025-05-15" 2`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.fecha AS fecha_2, t0.textoes AS textoes_3, t0.textoeus AS textoeus_4, t0.leido AS leido_5, t0.objeto AS objeto_6, t0.destinatario_id AS destinatario_id_7, t0.tipo_id AS tipo_id_8 FROM notificacion t0 WHERE t0.tipo_id = ? AND t0.fecha = ? AND t0.destinatario_id = ? ORDER BY t0.fecha DESC SELECT t0.id AS id_1, t0.fecha AS fecha_2, t0.textoes AS textoes_3, t0.textoeus AS textoeus_4, t0.leido AS leido_5, t0.objeto AS objeto_6, t0.destinatario_id AS destinatario_id_7, t0.tipo_id AS tipo_id_8 FROM notificacion t0 WHERE t0.tipo_id = 3 AND t0.fecha = '2025-05-15' AND t0.destinatario_id = 2 ORDER BY t0.fecha DESC;
181	4.73 ms	SELECT n0_.id AS id_0, n0_.fecha AS fecha_1, n0_.textoes AS textoes_2, n0_.textoeus AS textoeus_3, n0_.leido AS leido_4, n0_.objeto AS objeto_5, n0_.destinatario_id AS destinatario_id_6, n0_.tipo_id AS tipo_id_7 FROM notificacion n0_ INNER JOIN tipo_notificacion t1_ ON n0_.tipo_id = t1_.id WHERE t1_.descripcion LIKE ? AND n0_.destinatario_id = ? AND n0_.fecha = ? ORDER BY n0_.fecha DESC Parameters: [`"tipoNotificacion.justificacion%" 2 "2025-05-15"`] View formatted query View runnable query Explain query SELECT n0_.id AS id_0, n0_.fecha AS fecha_1, n0_.textoes AS textoes_2, n0_.textoeus AS textoeus_3, n0_.leido AS leido_4, n0_.objeto AS objeto_5, n0_.destinatario_id AS destinatario_id_6, n0_.tipo_id AS tipo_id_7 FROM notificacion n0_ INNER JOIN tipo_notificacion t1_ ON n0_.tipo_id = t1_.id WHERE t1_.descripcion LIKE ? AND n0_.destinatario_id = ? AND n0_.fecha = ? ORDER BY n0_.fecha DESC SELECT n0_.id AS id_0, n0_.fecha AS fecha_1, n0_.textoes AS textoes_2, n0_.textoeus AS textoeus_3, n0_.leido AS leido_4, n0_.objeto AS objeto_5, n0_.destinatario_id AS destinatario_id_6, n0_.tipo_id AS tipo_id_7 FROM notificacion n0_ INNER JOIN tipo_notificacion t1_ ON n0_.tipo_id = t1_.id WHERE t1_.descripcion LIKE 'tipoNotificacion.justificacion%' AND n0_.destinatario_id = 2 AND n0_.fecha = '2025-05-15' ORDER BY n0_.fecha DESC;
182	6.61 ms	SELECT t0.id AS id_1, t0.fecha AS fecha_2, t0.textoes AS textoes_3, t0.textoeus AS textoeus_4, t0.leido AS leido_5, t0.objeto AS objeto_6, t0.destinatario_id AS destinatario_id_7, t0.tipo_id AS tipo_id_8 FROM notificacion t0 WHERE t0.tipo_id = ? AND t0.fecha = ? AND t0.destinatario_id = ? ORDER BY t0.fecha DESC Parameters: [`1 "2025-05-15" 3`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.fecha AS fecha_2, t0.textoes AS textoes_3, t0.textoeus AS textoeus_4, t0.leido AS leido_5, t0.objeto AS objeto_6, t0.destinatario_id AS destinatario_id_7, t0.tipo_id AS tipo_id_8 FROM notificacion t0 WHERE t0.tipo_id = ? AND t0.fecha = ? AND t0.destinatario_id = ? ORDER BY t0.fecha DESC SELECT t0.id AS id_1, t0.fecha AS fecha_2, t0.textoes AS textoes_3, t0.textoeus AS textoeus_4, t0.leido AS leido_5, t0.objeto AS objeto_6, t0.destinatario_id AS destinatario_id_7, t0.tipo_id AS tipo_id_8 FROM notificacion t0 WHERE t0.tipo_id = 1 AND t0.fecha = '2025-05-15' AND t0.destinatario_id = 3 ORDER BY t0.fecha DESC;
183	2.07 ms	SELECT t0.id AS id_1, t0.fecha AS fecha_2, t0.textoes AS textoes_3, t0.textoeus AS textoeus_4, t0.leido AS leido_5, t0.objeto AS objeto_6, t0.destinatario_id AS destinatario_id_7, t0.tipo_id AS tipo_id_8 FROM notificacion t0 WHERE t0.tipo_id = ? AND t0.fecha = ? AND t0.destinatario_id = ? ORDER BY t0.fecha DESC Parameters: [`2 "2025-05-15" 3`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.fecha AS fecha_2, t0.textoes AS textoes_3, t0.textoeus AS textoeus_4, t0.leido AS leido_5, t0.objeto AS objeto_6, t0.destinatario_id AS destinatario_id_7, t0.tipo_id AS tipo_id_8 FROM notificacion t0 WHERE t0.tipo_id = ? AND t0.fecha = ? AND t0.destinatario_id = ? ORDER BY t0.fecha DESC SELECT t0.id AS id_1, t0.fecha AS fecha_2, t0.textoes AS textoes_3, t0.textoeus AS textoeus_4, t0.leido AS leido_5, t0.objeto AS objeto_6, t0.destinatario_id AS destinatario_id_7, t0.tipo_id AS tipo_id_8 FROM notificacion t0 WHERE t0.tipo_id = 2 AND t0.fecha = '2025-05-15' AND t0.destinatario_id = 3 ORDER BY t0.fecha DESC;
184	5.40 ms	SELECT t0.id AS id_1, t0.fecha AS fecha_2, t0.textoes AS textoes_3, t0.textoeus AS textoeus_4, t0.leido AS leido_5, t0.objeto AS objeto_6, t0.destinatario_id AS destinatario_id_7, t0.tipo_id AS tipo_id_8 FROM notificacion t0 WHERE t0.tipo_id = ? AND t0.fecha = ? AND t0.destinatario_id = ? ORDER BY t0.fecha DESC Parameters: [`3 "2025-05-15" 3`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.fecha AS fecha_2, t0.textoes AS textoes_3, t0.textoeus AS textoeus_4, t0.leido AS leido_5, t0.objeto AS objeto_6, t0.destinatario_id AS destinatario_id_7, t0.tipo_id AS tipo_id_8 FROM notificacion t0 WHERE t0.tipo_id = ? AND t0.fecha = ? AND t0.destinatario_id = ? ORDER BY t0.fecha DESC SELECT t0.id AS id_1, t0.fecha AS fecha_2, t0.textoes AS textoes_3, t0.textoeus AS textoeus_4, t0.leido AS leido_5, t0.objeto AS objeto_6, t0.destinatario_id AS destinatario_id_7, t0.tipo_id AS tipo_id_8 FROM notificacion t0 WHERE t0.tipo_id = 3 AND t0.fecha = '2025-05-15' AND t0.destinatario_id = 3 ORDER BY t0.fecha DESC;
185	4.90 ms	SELECT n0_.id AS id_0, n0_.fecha AS fecha_1, n0_.textoes AS textoes_2, n0_.textoeus AS textoeus_3, n0_.leido AS leido_4, n0_.objeto AS objeto_5, n0_.destinatario_id AS destinatario_id_6, n0_.tipo_id AS tipo_id_7 FROM notificacion n0_ INNER JOIN tipo_notificacion t1_ ON n0_.tipo_id = t1_.id WHERE t1_.descripcion LIKE ? AND n0_.destinatario_id = ? AND n0_.fecha = ? ORDER BY n0_.fecha DESC Parameters: [`"tipoNotificacion.justificacion%" 3 "2025-05-15"`] View formatted query View runnable query Explain query SELECT n0_.id AS id_0, n0_.fecha AS fecha_1, n0_.textoes AS textoes_2, n0_.textoeus AS textoeus_3, n0_.leido AS leido_4, n0_.objeto AS objeto_5, n0_.destinatario_id AS destinatario_id_6, n0_.tipo_id AS tipo_id_7 FROM notificacion n0_ INNER JOIN tipo_notificacion t1_ ON n0_.tipo_id = t1_.id WHERE t1_.descripcion LIKE ? AND n0_.destinatario_id = ? AND n0_.fecha = ? ORDER BY n0_.fecha DESC SELECT n0_.id AS id_0, n0_.fecha AS fecha_1, n0_.textoes AS textoes_2, n0_.textoeus AS textoeus_3, n0_.leido AS leido_4, n0_.objeto AS objeto_5, n0_.destinatario_id AS destinatario_id_6, n0_.tipo_id AS tipo_id_7 FROM notificacion n0_ INNER JOIN tipo_notificacion t1_ ON n0_.tipo_id = t1_.id WHERE t1_.descripcion LIKE 'tipoNotificacion.justificacion%' AND n0_.destinatario_id = 3 AND n0_.fecha = '2025-05-15' ORDER BY n0_.fecha DESC;
186	6.76 ms	SELECT t0.id AS id_1, t0.fecha AS fecha_2, t0.textoes AS textoes_3, t0.textoeus AS textoeus_4, t0.leido AS leido_5, t0.objeto AS objeto_6, t0.destinatario_id AS destinatario_id_7, t0.tipo_id AS tipo_id_8 FROM notificacion t0 WHERE t0.tipo_id = ? AND t0.fecha = ? AND t0.destinatario_id = ? ORDER BY t0.fecha DESC Parameters: [`1 "2025-05-15" 4`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.fecha AS fecha_2, t0.textoes AS textoes_3, t0.textoeus AS textoeus_4, t0.leido AS leido_5, t0.objeto AS objeto_6, t0.destinatario_id AS destinatario_id_7, t0.tipo_id AS tipo_id_8 FROM notificacion t0 WHERE t0.tipo_id = ? AND t0.fecha = ? AND t0.destinatario_id = ? ORDER BY t0.fecha DESC SELECT t0.id AS id_1, t0.fecha AS fecha_2, t0.textoes AS textoes_3, t0.textoeus AS textoeus_4, t0.leido AS leido_5, t0.objeto AS objeto_6, t0.destinatario_id AS destinatario_id_7, t0.tipo_id AS tipo_id_8 FROM notificacion t0 WHERE t0.tipo_id = 1 AND t0.fecha = '2025-05-15' AND t0.destinatario_id = 4 ORDER BY t0.fecha DESC;
187	2.21 ms	SELECT t0.id AS id_1, t0.fecha AS fecha_2, t0.textoes AS textoes_3, t0.textoeus AS textoeus_4, t0.leido AS leido_5, t0.objeto AS objeto_6, t0.destinatario_id AS destinatario_id_7, t0.tipo_id AS tipo_id_8 FROM notificacion t0 WHERE t0.tipo_id = ? AND t0.fecha = ? AND t0.destinatario_id = ? ORDER BY t0.fecha DESC Parameters: [`2 "2025-05-15" 4`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.fecha AS fecha_2, t0.textoes AS textoes_3, t0.textoeus AS textoeus_4, t0.leido AS leido_5, t0.objeto AS objeto_6, t0.destinatario_id AS destinatario_id_7, t0.tipo_id AS tipo_id_8 FROM notificacion t0 WHERE t0.tipo_id = ? AND t0.fecha = ? AND t0.destinatario_id = ? ORDER BY t0.fecha DESC SELECT t0.id AS id_1, t0.fecha AS fecha_2, t0.textoes AS textoes_3, t0.textoeus AS textoeus_4, t0.leido AS leido_5, t0.objeto AS objeto_6, t0.destinatario_id AS destinatario_id_7, t0.tipo_id AS tipo_id_8 FROM notificacion t0 WHERE t0.tipo_id = 2 AND t0.fecha = '2025-05-15' AND t0.destinatario_id = 4 ORDER BY t0.fecha DESC;
188	5.39 ms	SELECT t0.id AS id_1, t0.fecha AS fecha_2, t0.textoes AS textoes_3, t0.textoeus AS textoeus_4, t0.leido AS leido_5, t0.objeto AS objeto_6, t0.destinatario_id AS destinatario_id_7, t0.tipo_id AS tipo_id_8 FROM notificacion t0 WHERE t0.tipo_id = ? AND t0.fecha = ? AND t0.destinatario_id = ? ORDER BY t0.fecha DESC Parameters: [`3 "2025-05-15" 4`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.fecha AS fecha_2, t0.textoes AS textoes_3, t0.textoeus AS textoeus_4, t0.leido AS leido_5, t0.objeto AS objeto_6, t0.destinatario_id AS destinatario_id_7, t0.tipo_id AS tipo_id_8 FROM notificacion t0 WHERE t0.tipo_id = ? AND t0.fecha = ? AND t0.destinatario_id = ? ORDER BY t0.fecha DESC SELECT t0.id AS id_1, t0.fecha AS fecha_2, t0.textoes AS textoes_3, t0.textoeus AS textoeus_4, t0.leido AS leido_5, t0.objeto AS objeto_6, t0.destinatario_id AS destinatario_id_7, t0.tipo_id AS tipo_id_8 FROM notificacion t0 WHERE t0.tipo_id = 3 AND t0.fecha = '2025-05-15' AND t0.destinatario_id = 4 ORDER BY t0.fecha DESC;
189	6.02 ms	SELECT n0_.id AS id_0, n0_.fecha AS fecha_1, n0_.textoes AS textoes_2, n0_.textoeus AS textoeus_3, n0_.leido AS leido_4, n0_.objeto AS objeto_5, n0_.destinatario_id AS destinatario_id_6, n0_.tipo_id AS tipo_id_7 FROM notificacion n0_ INNER JOIN tipo_notificacion t1_ ON n0_.tipo_id = t1_.id WHERE t1_.descripcion LIKE ? AND n0_.destinatario_id = ? AND n0_.fecha = ? ORDER BY n0_.fecha DESC Parameters: [`"tipoNotificacion.justificacion%" 4 "2025-05-15"`] View formatted query View runnable query Explain query SELECT n0_.id AS id_0, n0_.fecha AS fecha_1, n0_.textoes AS textoes_2, n0_.textoeus AS textoeus_3, n0_.leido AS leido_4, n0_.objeto AS objeto_5, n0_.destinatario_id AS destinatario_id_6, n0_.tipo_id AS tipo_id_7 FROM notificacion n0_ INNER JOIN tipo_notificacion t1_ ON n0_.tipo_id = t1_.id WHERE t1_.descripcion LIKE ? AND n0_.destinatario_id = ? AND n0_.fecha = ? ORDER BY n0_.fecha DESC SELECT n0_.id AS id_0, n0_.fecha AS fecha_1, n0_.textoes AS textoes_2, n0_.textoeus AS textoeus_3, n0_.leido AS leido_4, n0_.objeto AS objeto_5, n0_.destinatario_id AS destinatario_id_6, n0_.tipo_id AS tipo_id_7 FROM notificacion n0_ INNER JOIN tipo_notificacion t1_ ON n0_.tipo_id = t1_.id WHERE t1_.descripcion LIKE 'tipoNotificacion.justificacion%' AND n0_.destinatario_id = 4 AND n0_.fecha = '2025-05-15' ORDER BY n0_.fecha DESC;

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
App\Entity\Comun\FichajeDiario	No errors.
App\Entity\Admin\Empleada	No errors.
App\Entity\Admin\RangoSalarial	No errors.
App\Entity\Accesos\Usuario	No errors.
App\Entity\Admin\Contacto	No errors.
App\Entity\Admin\ContactoProveedor	No errors.
App\Entity\Comun\Proyecto	No errors.
App\Entity\Comun\TareaEmpleada	No errors.
App\Entity\Comun\Fichaje	No errors.
App\Entity\Comun\Notificacion	No errors.
App\Entity\Accion\Llamada	No errors.
App\Entity\Accion\Email	No errors.
App\Entity\Accion\Reunion	No errors.
App\Entity\Admin\Globales	No errors.
App\Entity\Comun\TipoNotificacion	No errors.
App\Entity\Comun\Justificacion	No errors.
App\Entity\Adjunto\AdjuntoJustificacion	No errors.

Symfony Profiler

https://daiteke.aplicaciones.debamatika.com/comun/notificacion/cron

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Entities Mapping