Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

206 Database Queries

15 Different statements

170.63 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
"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
"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
"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
"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.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 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 ? 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 ? 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 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 ? 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 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 ? 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 ? 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 ? 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 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 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.objeto = ? 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 ?
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.66 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.47 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	0.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: [`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	2.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: [`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	0.10 ms	"START TRANSACTION" Parameters: [] View formatted query View runnable query Explain query "START TRANSACTION" "START TRANSACTION";
6	0.26 ms	INSERT INTO fichaje_diario (fecha, entrada, empleada_id) VALUES (?, ?, ?) Parameters: [`1 => "2024-09-19 21:00:00" 2 => 0 3 => 2`] 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 ('2024-09-19 21:00:00', 0, 2);
7	1.17 ms	"COMMIT" Parameters: [] View formatted query View runnable query Explain query "COMMIT" "COMMIT";
8	0.24 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;
9	0.34 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\"%';
10	0.10 ms	"START TRANSACTION" Parameters: [] View formatted query View runnable query Explain query "START TRANSACTION" "START TRANSACTION";
11	0.34 ms	INSERT INTO notificacion (fecha, textoes, textoeus, leido, objeto, destinatario_id, tipo_id) VALUES (?, ?, ?, ?, ?, ?, ?) Parameters: [`1 => "2024-09-19" 2 => "Se ha cerrado un fichaje para Araceli Guerrero Conde con fecha: 2024-09-19" 3 => "Fitxaje bat ixti da Araceli Guerrero Conde-rentzat 19-09-2024 datarekin" 4 => 0 5 => 2 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 ('2024-09-19', 'Se ha cerrado un fichaje para Araceli Guerrero Conde con fecha: 2024-09-19', 'Fitxaje bat ixti da Araceli Guerrero Conde-rentzat 19-09-2024 datarekin', 0, 2, 2, 3);
12	0.13 ms	INSERT INTO notificacion (fecha, textoes, textoeus, leido, objeto, destinatario_id, tipo_id) VALUES (?, ?, ?, ?, ?, ?, ?) Parameters: [`1 => "2024-09-19" 2 => "Se ha cerrado un fichaje para Araceli Guerrero Conde con fecha: 2024-09-19" 3 => "Fitxaje bat ixti da Araceli Guerrero Conde-rentzat 19-09-2024 datarekin" 4 => 0 5 => 2 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 ('2024-09-19', 'Se ha cerrado un fichaje para Araceli Guerrero Conde con fecha: 2024-09-19', 'Fitxaje bat ixti da Araceli Guerrero Conde-rentzat 19-09-2024 datarekin', 0, 2, 1, 3);
13	0.13 ms	INSERT INTO notificacion (fecha, textoes, textoeus, leido, objeto, destinatario_id, tipo_id) VALUES (?, ?, ?, ?, ?, ?, ?) Parameters: [`1 => "2024-09-19" 2 => "Se ha cerrado un fichaje para Araceli Guerrero Conde con fecha: 2024-09-19" 3 => "Fitxaje bat ixti da Araceli Guerrero Conde-rentzat 19-09-2024 datarekin" 4 => 0 5 => 2 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 ('2024-09-19', 'Se ha cerrado un fichaje para Araceli Guerrero Conde con fecha: 2024-09-19', 'Fitxaje bat ixti da Araceli Guerrero Conde-rentzat 19-09-2024 datarekin', 0, 2, 3, 3);
14	0.16 ms	INSERT INTO notificacion (fecha, textoes, textoeus, leido, objeto, destinatario_id, tipo_id) VALUES (?, ?, ?, ?, ?, ?, ?) Parameters: [`1 => "2024-09-19" 2 => "Se ha cerrado un fichaje para Araceli Guerrero Conde con fecha: 2024-09-19" 3 => "Fitxaje bat ixti da Araceli Guerrero Conde-rentzat 19-09-2024 datarekin" 4 => 0 5 => 2 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 ('2024-09-19', 'Se ha cerrado un fichaje para Araceli Guerrero Conde con fecha: 2024-09-19', 'Fitxaje bat ixti da Araceli Guerrero Conde-rentzat 19-09-2024 datarekin', 0, 2, 4, 3);
15	1.08 ms	"COMMIT" Parameters: [] View formatted query View runnable query Explain query "COMMIT" "COMMIT";
16	1.34 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;
17	1.19 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	0.93 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	0.73 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	0.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: [`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.19 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	0.09 ms	"START TRANSACTION" Parameters: [] View formatted query View runnable query Explain query "START TRANSACTION" "START TRANSACTION";
23	0.15 ms	INSERT INTO fichaje_diario (fecha, entrada, empleada_id) VALUES (?, ?, ?) Parameters: [`1 => "2024-09-19 21:00:00" 2 => 0 3 => 9`] 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 ('2024-09-19 21:00:00', 0, 9);
24	1.44 ms	"COMMIT" Parameters: [] View formatted query View runnable query Explain query "COMMIT" "COMMIT";
25	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.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;
26	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\"%';
27	0.08 ms	"START TRANSACTION" Parameters: [] View formatted query View runnable query Explain query "START TRANSACTION" "START TRANSACTION";
28	0.17 ms	INSERT INTO notificacion (fecha, textoes, textoeus, leido, objeto, destinatario_id, tipo_id) VALUES (?, ?, ?, ?, ?, ?, ?) Parameters: [`1 => "2024-09-19" 2 => "Se ha cerrado un fichaje para Maria Peña Espin con fecha: 2024-09-19" 3 => "Fitxaje bat ixti da Maria Peña Espin-rentzat 19-09-2024 datarekin" 4 => 0 5 => 9 6 => 9 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 ('2024-09-19', 'Se ha cerrado un fichaje para Maria Peña Espin con fecha: 2024-09-19', 'Fitxaje bat ixti da Maria Peña Espin-rentzat 19-09-2024 datarekin', 0, 9, 9, 3);
29	0.11 ms	INSERT INTO notificacion (fecha, textoes, textoeus, leido, objeto, destinatario_id, tipo_id) VALUES (?, ?, ?, ?, ?, ?, ?) Parameters: [`1 => "2024-09-19" 2 => "Se ha cerrado un fichaje para Maria Peña Espin con fecha: 2024-09-19" 3 => "Fitxaje bat ixti da Maria Peña Espin-rentzat 19-09-2024 datarekin" 4 => 0 5 => 9 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 ('2024-09-19', 'Se ha cerrado un fichaje para Maria Peña Espin con fecha: 2024-09-19', 'Fitxaje bat ixti da Maria Peña Espin-rentzat 19-09-2024 datarekin', 0, 9, 1, 3);
30	0.12 ms	INSERT INTO notificacion (fecha, textoes, textoeus, leido, objeto, destinatario_id, tipo_id) VALUES (?, ?, ?, ?, ?, ?, ?) Parameters: [`1 => "2024-09-19" 2 => "Se ha cerrado un fichaje para Maria Peña Espin con fecha: 2024-09-19" 3 => "Fitxaje bat ixti da Maria Peña Espin-rentzat 19-09-2024 datarekin" 4 => 0 5 => 9 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 ('2024-09-19', 'Se ha cerrado un fichaje para Maria Peña Espin con fecha: 2024-09-19', 'Fitxaje bat ixti da Maria Peña Espin-rentzat 19-09-2024 datarekin', 0, 9, 2, 3);
31	0.10 ms	INSERT INTO notificacion (fecha, textoes, textoeus, leido, objeto, destinatario_id, tipo_id) VALUES (?, ?, ?, ?, ?, ?, ?) Parameters: [`1 => "2024-09-19" 2 => "Se ha cerrado un fichaje para Maria Peña Espin con fecha: 2024-09-19" 3 => "Fitxaje bat ixti da Maria Peña Espin-rentzat 19-09-2024 datarekin" 4 => 0 5 => 9 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 ('2024-09-19', 'Se ha cerrado un fichaje para Maria Peña Espin con fecha: 2024-09-19', 'Fitxaje bat ixti da Maria Peña Espin-rentzat 19-09-2024 datarekin', 0, 9, 3, 3);
32	0.09 ms	INSERT INTO notificacion (fecha, textoes, textoeus, leido, objeto, destinatario_id, tipo_id) VALUES (?, ?, ?, ?, ?, ?, ?) Parameters: [`1 => "2024-09-19" 2 => "Se ha cerrado un fichaje para Maria Peña Espin con fecha: 2024-09-19" 3 => "Fitxaje bat ixti da Maria Peña Espin-rentzat 19-09-2024 datarekin" 4 => 0 5 => 9 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 ('2024-09-19', 'Se ha cerrado un fichaje para Maria Peña Espin con fecha: 2024-09-19', 'Fitxaje bat ixti da Maria Peña Espin-rentzat 19-09-2024 datarekin', 0, 9, 4, 3);
33	0.99 ms	"COMMIT" Parameters: [] View formatted query View runnable query Explain query "COMMIT" "COMMIT";
34	0.98 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;
35	0.08 ms	"START TRANSACTION" Parameters: [] View formatted query View runnable query Explain query "START TRANSACTION" "START TRANSACTION";
36	0.13 ms	INSERT INTO fichaje_diario (fecha, entrada, empleada_id) VALUES (?, ?, ?) Parameters: [`1 => "2024-09-19 21:00:00" 2 => 0 3 => 10`] 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 ('2024-09-19 21:00:00', 0, 10);
37	0.98 ms	"COMMIT" Parameters: [] View formatted query View runnable query Explain query "COMMIT" "COMMIT";
38	0.16 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.22 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.08 ms	"START TRANSACTION" Parameters: [] View formatted query View runnable query Explain query "START TRANSACTION" "START TRANSACTION";
41	0.17 ms	INSERT INTO notificacion (fecha, textoes, textoeus, leido, objeto, destinatario_id, tipo_id) VALUES (?, ?, ?, ?, ?, ?, ?) Parameters: [`1 => "2024-09-19" 2 => "Se ha cerrado un fichaje para Yoana Azpitarte Naveda con fecha: 2024-09-19" 3 => "Fitxaje bat ixti da Yoana Azpitarte Naveda-rentzat 19-09-2024 datarekin" 4 => 0 5 => 10 6 => 10 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 ('2024-09-19', 'Se ha cerrado un fichaje para Yoana Azpitarte Naveda con fecha: 2024-09-19', 'Fitxaje bat ixti da Yoana Azpitarte Naveda-rentzat 19-09-2024 datarekin', 0, 10, 10, 3);
42	0.11 ms	INSERT INTO notificacion (fecha, textoes, textoeus, leido, objeto, destinatario_id, tipo_id) VALUES (?, ?, ?, ?, ?, ?, ?) Parameters: [`1 => "2024-09-19" 2 => "Se ha cerrado un fichaje para Yoana Azpitarte Naveda con fecha: 2024-09-19" 3 => "Fitxaje bat ixti da Yoana Azpitarte Naveda-rentzat 19-09-2024 datarekin" 4 => 0 5 => 10 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 ('2024-09-19', 'Se ha cerrado un fichaje para Yoana Azpitarte Naveda con fecha: 2024-09-19', 'Fitxaje bat ixti da Yoana Azpitarte Naveda-rentzat 19-09-2024 datarekin', 0, 10, 1, 3);
43	2.26 ms	INSERT INTO notificacion (fecha, textoes, textoeus, leido, objeto, destinatario_id, tipo_id) VALUES (?, ?, ?, ?, ?, ?, ?) Parameters: [`1 => "2024-09-19" 2 => "Se ha cerrado un fichaje para Yoana Azpitarte Naveda con fecha: 2024-09-19" 3 => "Fitxaje bat ixti da Yoana Azpitarte Naveda-rentzat 19-09-2024 datarekin" 4 => 0 5 => 10 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 ('2024-09-19', 'Se ha cerrado un fichaje para Yoana Azpitarte Naveda con fecha: 2024-09-19', 'Fitxaje bat ixti da Yoana Azpitarte Naveda-rentzat 19-09-2024 datarekin', 0, 10, 2, 3);
44	0.12 ms	INSERT INTO notificacion (fecha, textoes, textoeus, leido, objeto, destinatario_id, tipo_id) VALUES (?, ?, ?, ?, ?, ?, ?) Parameters: [`1 => "2024-09-19" 2 => "Se ha cerrado un fichaje para Yoana Azpitarte Naveda con fecha: 2024-09-19" 3 => "Fitxaje bat ixti da Yoana Azpitarte Naveda-rentzat 19-09-2024 datarekin" 4 => 0 5 => 10 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 ('2024-09-19', 'Se ha cerrado un fichaje para Yoana Azpitarte Naveda con fecha: 2024-09-19', 'Fitxaje bat ixti da Yoana Azpitarte Naveda-rentzat 19-09-2024 datarekin', 0, 10, 3, 3);
45	0.10 ms	INSERT INTO notificacion (fecha, textoes, textoeus, leido, objeto, destinatario_id, tipo_id) VALUES (?, ?, ?, ?, ?, ?, ?) Parameters: [`1 => "2024-09-19" 2 => "Se ha cerrado un fichaje para Yoana Azpitarte Naveda con fecha: 2024-09-19" 3 => "Fitxaje bat ixti da Yoana Azpitarte Naveda-rentzat 19-09-2024 datarekin" 4 => 0 5 => 10 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 ('2024-09-19', 'Se ha cerrado un fichaje para Yoana Azpitarte Naveda con fecha: 2024-09-19', 'Fitxaje bat ixti da Yoana Azpitarte Naveda-rentzat 19-09-2024 datarekin', 0, 10, 4, 3);
46	1.54 ms	"COMMIT" Parameters: [] View formatted query View runnable query Explain query "COMMIT" "COMMIT";
47	1.31 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;
48	1.04 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;
49	0.81 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;
50	1.04 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;
51	0.08 ms	"START TRANSACTION" Parameters: [] View formatted query View runnable query Explain query "START TRANSACTION" "START TRANSACTION";
52	0.14 ms	INSERT INTO fichaje_diario (fecha, entrada, empleada_id) VALUES (?, ?, ?) Parameters: [`1 => "2024-09-19 21:00:00" 2 => 0 3 => 14`] 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 ('2024-09-19 21:00:00', 0, 14);
53	1.12 ms	"COMMIT" Parameters: [] View formatted query View runnable query Explain query "COMMIT" "COMMIT";
54	0.14 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;
55	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\"%';
56	0.23 ms	"START TRANSACTION" Parameters: [] View formatted query View runnable query Explain query "START TRANSACTION" "START TRANSACTION";
57	0.15 ms	INSERT INTO notificacion (fecha, textoes, textoeus, leido, objeto, destinatario_id, tipo_id) VALUES (?, ?, ?, ?, ?, ?, ?) Parameters: [`1 => "2024-09-19" 2 => "Se ha cerrado un fichaje para Marina Azconizaga Aguirrezabal con fecha: 2024-09-19" 3 => "Fitxaje bat ixti da Marina Azconizaga Aguirrezabal-rentzat 19-09-2024 datarekin" 4 => 0 5 => 14 6 => 14 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 ('2024-09-19', 'Se ha cerrado un fichaje para Marina Azconizaga Aguirrezabal con fecha: 2024-09-19', 'Fitxaje bat ixti da Marina Azconizaga Aguirrezabal-rentzat 19-09-2024 datarekin', 0, 14, 14, 3);
58	0.10 ms	INSERT INTO notificacion (fecha, textoes, textoeus, leido, objeto, destinatario_id, tipo_id) VALUES (?, ?, ?, ?, ?, ?, ?) Parameters: [`1 => "2024-09-19" 2 => "Se ha cerrado un fichaje para Marina Azconizaga Aguirrezabal con fecha: 2024-09-19" 3 => "Fitxaje bat ixti da Marina Azconizaga Aguirrezabal-rentzat 19-09-2024 datarekin" 4 => 0 5 => 14 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 ('2024-09-19', 'Se ha cerrado un fichaje para Marina Azconizaga Aguirrezabal con fecha: 2024-09-19', 'Fitxaje bat ixti da Marina Azconizaga Aguirrezabal-rentzat 19-09-2024 datarekin', 0, 14, 1, 3);
59	0.09 ms	INSERT INTO notificacion (fecha, textoes, textoeus, leido, objeto, destinatario_id, tipo_id) VALUES (?, ?, ?, ?, ?, ?, ?) Parameters: [`1 => "2024-09-19" 2 => "Se ha cerrado un fichaje para Marina Azconizaga Aguirrezabal con fecha: 2024-09-19" 3 => "Fitxaje bat ixti da Marina Azconizaga Aguirrezabal-rentzat 19-09-2024 datarekin" 4 => 0 5 => 14 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 ('2024-09-19', 'Se ha cerrado un fichaje para Marina Azconizaga Aguirrezabal con fecha: 2024-09-19', 'Fitxaje bat ixti da Marina Azconizaga Aguirrezabal-rentzat 19-09-2024 datarekin', 0, 14, 2, 3);
60	0.10 ms	INSERT INTO notificacion (fecha, textoes, textoeus, leido, objeto, destinatario_id, tipo_id) VALUES (?, ?, ?, ?, ?, ?, ?) Parameters: [`1 => "2024-09-19" 2 => "Se ha cerrado un fichaje para Marina Azconizaga Aguirrezabal con fecha: 2024-09-19" 3 => "Fitxaje bat ixti da Marina Azconizaga Aguirrezabal-rentzat 19-09-2024 datarekin" 4 => 0 5 => 14 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 ('2024-09-19', 'Se ha cerrado un fichaje para Marina Azconizaga Aguirrezabal con fecha: 2024-09-19', 'Fitxaje bat ixti da Marina Azconizaga Aguirrezabal-rentzat 19-09-2024 datarekin', 0, 14, 3, 3);
61	0.08 ms	INSERT INTO notificacion (fecha, textoes, textoeus, leido, objeto, destinatario_id, tipo_id) VALUES (?, ?, ?, ?, ?, ?, ?) Parameters: [`1 => "2024-09-19" 2 => "Se ha cerrado un fichaje para Marina Azconizaga Aguirrezabal con fecha: 2024-09-19" 3 => "Fitxaje bat ixti da Marina Azconizaga Aguirrezabal-rentzat 19-09-2024 datarekin" 4 => 0 5 => 14 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 ('2024-09-19', 'Se ha cerrado un fichaje para Marina Azconizaga Aguirrezabal con fecha: 2024-09-19', 'Fitxaje bat ixti da Marina Azconizaga Aguirrezabal-rentzat 19-09-2024 datarekin', 0, 14, 4, 3);
62	0.98 ms	"COMMIT" Parameters: [] View formatted query View runnable query Explain query "COMMIT" "COMMIT";
63	1.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: [`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;
64	1.07 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;
65	0.70 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;
66	1.07 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;
67	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: [`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;
68	0.73 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;
69	1.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: [`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;
70	0.77 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;
71	0.28 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;
72	0.32 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;
73	0.94 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;
74	0.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: [`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;
75	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: [`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;
76	0.55 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;
77	0.47 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;
78	0.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: [`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;
79	0.18 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;
80	0.19 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;
81	0.37 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;
82	0.22 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;
83	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: [`1 "2024-09-19%"`] 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 '2024-09-19%' ORDER BY f0_.fecha ASC LIMIT 1;
84	1.40 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 "2024-09-19%"`] 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 '2024-09-19%' ORDER BY f0_.fecha ASC LIMIT 1;
85	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 ? AND f0_.fecha > ? ORDER BY f0_.fecha ASC LIMIT 1 Parameters: [`2 "2024-09-19%" "2024-09-19 09:17: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 = 2 AND f0_.fecha LIKE '2024-09-19%' AND f0_.fecha > '2024-09-19 09:17:59' ORDER BY f0_.fecha ASC LIMIT 1;
86	0.86 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 "2024-09-19%" "2024-09-19 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 = 2 AND f0_.fecha LIKE '2024-09-19%' AND f0_.fecha > '2024-09-19 21:00:00' ORDER BY f0_.fecha ASC LIMIT 1;
87	0.14 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;
88	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\"%';
89	0.09 ms	"START TRANSACTION" Parameters: [] View formatted query View runnable query Explain query "START TRANSACTION" "START TRANSACTION";
90	0.22 ms	INSERT INTO notificacion (fecha, textoes, textoeus, leido, objeto, destinatario_id, tipo_id) VALUES (?, ?, ?, ?, ?, ?, ?) Parameters: [`1 => "2024-09-19" 2 => "Araceli Guerrero Conde ha trabajado un total de 11h 42m , 2:42 horas mas de lo establecido" 3 => "Araceli Guerrero Conde 11h 42m egin du lan, gehienezko kopurua baino 2:42 gehiago" 4 => 0 5 => 2 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 ('2024-09-19', 'Araceli Guerrero Conde ha trabajado un total de 11h 42m , 2:42 horas mas de lo establecido', 'Araceli Guerrero Conde 11h 42m egin du lan, gehienezko kopurua baino 2:42 gehiago', 0, 2, 2, 1);
91	0.15 ms	INSERT INTO notificacion (fecha, textoes, textoeus, leido, objeto, destinatario_id, tipo_id) VALUES (?, ?, ?, ?, ?, ?, ?) Parameters: [`1 => "2024-09-19" 2 => "Araceli Guerrero Conde ha trabajado un total de 11h 42m , 2:42 horas mas de lo establecido" 3 => "Araceli Guerrero Conde 11h 42m egin du lan, gehienezko kopurua baino 2:42 gehiago" 4 => 0 5 => 2 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 ('2024-09-19', 'Araceli Guerrero Conde ha trabajado un total de 11h 42m , 2:42 horas mas de lo establecido', 'Araceli Guerrero Conde 11h 42m egin du lan, gehienezko kopurua baino 2:42 gehiago', 0, 2, 1, 1);
92	0.16 ms	INSERT INTO notificacion (fecha, textoes, textoeus, leido, objeto, destinatario_id, tipo_id) VALUES (?, ?, ?, ?, ?, ?, ?) Parameters: [`1 => "2024-09-19" 2 => "Araceli Guerrero Conde ha trabajado un total de 11h 42m , 2:42 horas mas de lo establecido" 3 => "Araceli Guerrero Conde 11h 42m egin du lan, gehienezko kopurua baino 2:42 gehiago" 4 => 0 5 => 2 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 ('2024-09-19', 'Araceli Guerrero Conde ha trabajado un total de 11h 42m , 2:42 horas mas de lo establecido', 'Araceli Guerrero Conde 11h 42m egin du lan, gehienezko kopurua baino 2:42 gehiago', 0, 2, 3, 1);
93	0.11 ms	INSERT INTO notificacion (fecha, textoes, textoeus, leido, objeto, destinatario_id, tipo_id) VALUES (?, ?, ?, ?, ?, ?, ?) Parameters: [`1 => "2024-09-19" 2 => "Araceli Guerrero Conde ha trabajado un total de 11h 42m , 2:42 horas mas de lo establecido" 3 => "Araceli Guerrero Conde 11h 42m egin du lan, gehienezko kopurua baino 2:42 gehiago" 4 => 0 5 => 2 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 ('2024-09-19', 'Araceli Guerrero Conde ha trabajado un total de 11h 42m , 2:42 horas mas de lo establecido', 'Araceli Guerrero Conde 11h 42m egin du lan, gehienezko kopurua baino 2:42 gehiago', 0, 2, 4, 1);
94	1.63 ms	"COMMIT" Parameters: [] View formatted query View runnable query Explain query "COMMIT" "COMMIT";
95	1.51 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 "2024-09-19%"`] 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 '2024-09-19%' ORDER BY f0_.fecha ASC LIMIT 1;
96	1.25 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 "2024-09-19%"`] 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 '2024-09-19%' ORDER BY f0_.fecha ASC LIMIT 1;
97	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: [`6 "2024-09-19%"`] 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 '2024-09-19%' ORDER BY f0_.fecha ASC LIMIT 1;
98	0.75 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 "2024-09-19%" "2024-09-19 09:02:13"`] 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 '2024-09-19%' AND f0_.fecha > '2024-09-19 09:02:13' ORDER BY f0_.fecha ASC LIMIT 1;
99	0.70 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 "2024-09-19%" "2024-09-19 17:11: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 = 6 AND f0_.fecha LIKE '2024-09-19%' AND f0_.fecha > '2024-09-19 17:11:32' ORDER BY f0_.fecha ASC LIMIT 1;
100	0.79 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 "2024-09-19%"`] 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 '2024-09-19%' ORDER BY f0_.fecha ASC LIMIT 1;
101	0.60 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 "2024-09-19%" "2024-09-19 09:23: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 = 7 AND f0_.fecha LIKE '2024-09-19%' AND f0_.fecha > '2024-09-19 09:23:00' ORDER BY f0_.fecha ASC LIMIT 1;
102	0.56 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 "2024-09-19%" "2024-09-19 14:25:13"`] 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 '2024-09-19%' AND f0_.fecha > '2024-09-19 14:25:13' ORDER BY f0_.fecha ASC LIMIT 1;
103	0.97 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 "2024-09-19%"`] 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 '2024-09-19%' ORDER BY f0_.fecha ASC LIMIT 1;
104	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: [`9 "2024-09-19%"`] 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 '2024-09-19%' ORDER BY f0_.fecha ASC LIMIT 1;
105	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: [`9 "2024-09-19%" "2024-09-19 08:00: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 = 9 AND f0_.fecha LIKE '2024-09-19%' AND f0_.fecha > '2024-09-19 08:00:22' ORDER BY f0_.fecha ASC LIMIT 1;
106	0.91 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 "2024-09-19%" "2024-09-19 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 = 9 AND f0_.fecha LIKE '2024-09-19%' AND f0_.fecha > '2024-09-19 21:00:00' ORDER BY f0_.fecha ASC LIMIT 1;
107	0.18 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;
108	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\"%';
109	0.10 ms	"START TRANSACTION" Parameters: [] View formatted query View runnable query Explain query "START TRANSACTION" "START TRANSACTION";
110	0.22 ms	INSERT INTO notificacion (fecha, textoes, textoeus, leido, objeto, destinatario_id, tipo_id) VALUES (?, ?, ?, ?, ?, ?, ?) Parameters: [`1 => "2024-09-19" 2 => "Maria Peña Espin ha trabajado un total de 12h 59m , 3:59 horas mas de lo establecido" 3 => "Maria Peña Espin 12h 59m egin du lan, gehienezko kopurua baino 3:59 gehiago" 4 => 0 5 => 9 6 => 9 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 ('2024-09-19', 'Maria Peña Espin ha trabajado un total de 12h 59m , 3:59 horas mas de lo establecido', 'Maria Peña Espin 12h 59m egin du lan, gehienezko kopurua baino 3:59 gehiago', 0, 9, 9, 1);
111	0.11 ms	INSERT INTO notificacion (fecha, textoes, textoeus, leido, objeto, destinatario_id, tipo_id) VALUES (?, ?, ?, ?, ?, ?, ?) Parameters: [`1 => "2024-09-19" 2 => "Maria Peña Espin ha trabajado un total de 12h 59m , 3:59 horas mas de lo establecido" 3 => "Maria Peña Espin 12h 59m egin du lan, gehienezko kopurua baino 3:59 gehiago" 4 => 0 5 => 9 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 ('2024-09-19', 'Maria Peña Espin ha trabajado un total de 12h 59m , 3:59 horas mas de lo establecido', 'Maria Peña Espin 12h 59m egin du lan, gehienezko kopurua baino 3:59 gehiago', 0, 9, 1, 1);
112	0.16 ms	INSERT INTO notificacion (fecha, textoes, textoeus, leido, objeto, destinatario_id, tipo_id) VALUES (?, ?, ?, ?, ?, ?, ?) Parameters: [`1 => "2024-09-19" 2 => "Maria Peña Espin ha trabajado un total de 12h 59m , 3:59 horas mas de lo establecido" 3 => "Maria Peña Espin 12h 59m egin du lan, gehienezko kopurua baino 3:59 gehiago" 4 => 0 5 => 9 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 ('2024-09-19', 'Maria Peña Espin ha trabajado un total de 12h 59m , 3:59 horas mas de lo establecido', 'Maria Peña Espin 12h 59m egin du lan, gehienezko kopurua baino 3:59 gehiago', 0, 9, 2, 1);
113	0.10 ms	INSERT INTO notificacion (fecha, textoes, textoeus, leido, objeto, destinatario_id, tipo_id) VALUES (?, ?, ?, ?, ?, ?, ?) Parameters: [`1 => "2024-09-19" 2 => "Maria Peña Espin ha trabajado un total de 12h 59m , 3:59 horas mas de lo establecido" 3 => "Maria Peña Espin 12h 59m egin du lan, gehienezko kopurua baino 3:59 gehiago" 4 => 0 5 => 9 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 ('2024-09-19', 'Maria Peña Espin ha trabajado un total de 12h 59m , 3:59 horas mas de lo establecido', 'Maria Peña Espin 12h 59m egin du lan, gehienezko kopurua baino 3:59 gehiago', 0, 9, 3, 1);
114	0.17 ms	INSERT INTO notificacion (fecha, textoes, textoeus, leido, objeto, destinatario_id, tipo_id) VALUES (?, ?, ?, ?, ?, ?, ?) Parameters: [`1 => "2024-09-19" 2 => "Maria Peña Espin ha trabajado un total de 12h 59m , 3:59 horas mas de lo establecido" 3 => "Maria Peña Espin 12h 59m egin du lan, gehienezko kopurua baino 3:59 gehiago" 4 => 0 5 => 9 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 ('2024-09-19', 'Maria Peña Espin ha trabajado un total de 12h 59m , 3:59 horas mas de lo establecido', 'Maria Peña Espin 12h 59m egin du lan, gehienezko kopurua baino 3:59 gehiago', 0, 9, 4, 1);
115	2.65 ms	"COMMIT" Parameters: [] View formatted query View runnable query Explain query "COMMIT" "COMMIT";
116	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: [`10 "2024-09-19%"`] 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 '2024-09-19%' ORDER BY f0_.fecha ASC LIMIT 1;
117	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 ? AND f0_.fecha > ? ORDER BY f0_.fecha ASC LIMIT 1 Parameters: [`10 "2024-09-19%" "2024-09-19 09:36:27"`] 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 '2024-09-19%' AND f0_.fecha > '2024-09-19 09:36:27' ORDER BY f0_.fecha ASC LIMIT 1;
118	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: [`10 "2024-09-19%" "2024-09-19 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 = 10 AND f0_.fecha LIKE '2024-09-19%' AND f0_.fecha > '2024-09-19 21:00:00' ORDER BY f0_.fecha ASC LIMIT 1;
119	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.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;
120	0.35 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\"%';
121	0.12 ms	"START TRANSACTION" Parameters: [] View formatted query View runnable query Explain query "START TRANSACTION" "START TRANSACTION";
122	0.19 ms	INSERT INTO notificacion (fecha, textoes, textoeus, leido, objeto, destinatario_id, tipo_id) VALUES (?, ?, ?, ?, ?, ?, ?) Parameters: [`1 => "2024-09-19" 2 => "Yoana Azpitarte Naveda ha trabajado un total de 11h 23m , 2:23 horas mas de lo establecido" 3 => "Yoana Azpitarte Naveda 11h 23m egin du lan, gehienezko kopurua baino 2:23 gehiago" 4 => 0 5 => 10 6 => 10 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 ('2024-09-19', 'Yoana Azpitarte Naveda ha trabajado un total de 11h 23m , 2:23 horas mas de lo establecido', 'Yoana Azpitarte Naveda 11h 23m egin du lan, gehienezko kopurua baino 2:23 gehiago', 0, 10, 10, 1);
123	0.11 ms	INSERT INTO notificacion (fecha, textoes, textoeus, leido, objeto, destinatario_id, tipo_id) VALUES (?, ?, ?, ?, ?, ?, ?) Parameters: [`1 => "2024-09-19" 2 => "Yoana Azpitarte Naveda ha trabajado un total de 11h 23m , 2:23 horas mas de lo establecido" 3 => "Yoana Azpitarte Naveda 11h 23m egin du lan, gehienezko kopurua baino 2:23 gehiago" 4 => 0 5 => 10 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 ('2024-09-19', 'Yoana Azpitarte Naveda ha trabajado un total de 11h 23m , 2:23 horas mas de lo establecido', 'Yoana Azpitarte Naveda 11h 23m egin du lan, gehienezko kopurua baino 2:23 gehiago', 0, 10, 1, 1);
124	0.11 ms	INSERT INTO notificacion (fecha, textoes, textoeus, leido, objeto, destinatario_id, tipo_id) VALUES (?, ?, ?, ?, ?, ?, ?) Parameters: [`1 => "2024-09-19" 2 => "Yoana Azpitarte Naveda ha trabajado un total de 11h 23m , 2:23 horas mas de lo establecido" 3 => "Yoana Azpitarte Naveda 11h 23m egin du lan, gehienezko kopurua baino 2:23 gehiago" 4 => 0 5 => 10 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 ('2024-09-19', 'Yoana Azpitarte Naveda ha trabajado un total de 11h 23m , 2:23 horas mas de lo establecido', 'Yoana Azpitarte Naveda 11h 23m egin du lan, gehienezko kopurua baino 2:23 gehiago', 0, 10, 2, 1);
125	0.11 ms	INSERT INTO notificacion (fecha, textoes, textoeus, leido, objeto, destinatario_id, tipo_id) VALUES (?, ?, ?, ?, ?, ?, ?) Parameters: [`1 => "2024-09-19" 2 => "Yoana Azpitarte Naveda ha trabajado un total de 11h 23m , 2:23 horas mas de lo establecido" 3 => "Yoana Azpitarte Naveda 11h 23m egin du lan, gehienezko kopurua baino 2:23 gehiago" 4 => 0 5 => 10 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 ('2024-09-19', 'Yoana Azpitarte Naveda ha trabajado un total de 11h 23m , 2:23 horas mas de lo establecido', 'Yoana Azpitarte Naveda 11h 23m egin du lan, gehienezko kopurua baino 2:23 gehiago', 0, 10, 3, 1);
126	0.09 ms	INSERT INTO notificacion (fecha, textoes, textoeus, leido, objeto, destinatario_id, tipo_id) VALUES (?, ?, ?, ?, ?, ?, ?) Parameters: [`1 => "2024-09-19" 2 => "Yoana Azpitarte Naveda ha trabajado un total de 11h 23m , 2:23 horas mas de lo establecido" 3 => "Yoana Azpitarte Naveda 11h 23m egin du lan, gehienezko kopurua baino 2:23 gehiago" 4 => 0 5 => 10 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 ('2024-09-19', 'Yoana Azpitarte Naveda ha trabajado un total de 11h 23m , 2:23 horas mas de lo establecido', 'Yoana Azpitarte Naveda 11h 23m egin du lan, gehienezko kopurua baino 2:23 gehiago', 0, 10, 4, 1);
127	1.21 ms	"COMMIT" Parameters: [] View formatted query View runnable query Explain query "COMMIT" "COMMIT";
128	1.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: [`11 "2024-09-19%"`] 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 '2024-09-19%' ORDER BY f0_.fecha ASC LIMIT 1;
129	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 ? AND f0_.fecha > ? ORDER BY f0_.fecha ASC LIMIT 1 Parameters: [`11 "2024-09-19%" "2024-09-19 08:46: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 = 11 AND f0_.fecha LIKE '2024-09-19%' AND f0_.fecha > '2024-09-19 08:46:38' ORDER BY f0_.fecha ASC LIMIT 1;
130	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: [`11 "2024-09-19%" "2024-09-19 15:17:57"`] 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 '2024-09-19%' AND f0_.fecha > '2024-09-19 15:17:57' ORDER BY f0_.fecha ASC LIMIT 1;
131	0.98 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 "2024-09-19%"`] 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 '2024-09-19%' ORDER BY f0_.fecha ASC LIMIT 1;
132	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 ? AND f0_.fecha > ? ORDER BY f0_.fecha ASC LIMIT 1 Parameters: [`12 "2024-09-19%" "2024-09-19 07:04:19"`] 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 '2024-09-19%' AND f0_.fecha > '2024-09-19 07:04:19' ORDER BY f0_.fecha ASC LIMIT 1;
133	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 ? AND f0_.fecha > ? ORDER BY f0_.fecha ASC LIMIT 1 Parameters: [`12 "2024-09-19%" "2024-09-19 15:07: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 = 12 AND f0_.fecha LIKE '2024-09-19%' AND f0_.fecha > '2024-09-19 15:07:53' ORDER BY f0_.fecha ASC LIMIT 1;
134	0.65 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 "2024-09-19%"`] 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 '2024-09-19%' ORDER BY f0_.fecha ASC LIMIT 1;
135	0.98 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 "2024-09-19%"`] 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 '2024-09-19%' ORDER BY f0_.fecha ASC LIMIT 1;
136	0.86 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: [`14 "2024-09-19%" "2024-09-19 09:38:19"`] 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 = 14 AND f0_.fecha LIKE '2024-09-19%' AND f0_.fecha > '2024-09-19 09:38:19' ORDER BY f0_.fecha ASC LIMIT 1;
137	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: [`14 "2024-09-19%" "2024-09-19 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 = 14 AND f0_.fecha LIKE '2024-09-19%' AND f0_.fecha > '2024-09-19 21:00:00' ORDER BY f0_.fecha ASC LIMIT 1;
138	0.14 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;
139	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\"%';
140	0.10 ms	"START TRANSACTION" Parameters: [] View formatted query View runnable query Explain query "START TRANSACTION" "START TRANSACTION";
141	0.17 ms	INSERT INTO notificacion (fecha, textoes, textoeus, leido, objeto, destinatario_id, tipo_id) VALUES (?, ?, ?, ?, ?, ?, ?) Parameters: [`1 => "2024-09-19" 2 => "Marina Azconizaga Aguirrezabal ha trabajado un total de 11h 21m , 2:21 horas mas de lo establecido" 3 => "Marina Azconizaga Aguirrezabal 11h 21m egin du lan, gehienezko kopurua baino 2:21 gehiago" 4 => 0 5 => 14 6 => 14 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 ('2024-09-19', 'Marina Azconizaga Aguirrezabal ha trabajado un total de 11h 21m , 2:21 horas mas de lo establecido', 'Marina Azconizaga Aguirrezabal 11h 21m egin du lan, gehienezko kopurua baino 2:21 gehiago', 0, 14, 14, 1);
142	0.12 ms	INSERT INTO notificacion (fecha, textoes, textoeus, leido, objeto, destinatario_id, tipo_id) VALUES (?, ?, ?, ?, ?, ?, ?) Parameters: [`1 => "2024-09-19" 2 => "Marina Azconizaga Aguirrezabal ha trabajado un total de 11h 21m , 2:21 horas mas de lo establecido" 3 => "Marina Azconizaga Aguirrezabal 11h 21m egin du lan, gehienezko kopurua baino 2:21 gehiago" 4 => 0 5 => 14 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 ('2024-09-19', 'Marina Azconizaga Aguirrezabal ha trabajado un total de 11h 21m , 2:21 horas mas de lo establecido', 'Marina Azconizaga Aguirrezabal 11h 21m egin du lan, gehienezko kopurua baino 2:21 gehiago', 0, 14, 1, 1);
143	0.10 ms	INSERT INTO notificacion (fecha, textoes, textoeus, leido, objeto, destinatario_id, tipo_id) VALUES (?, ?, ?, ?, ?, ?, ?) Parameters: [`1 => "2024-09-19" 2 => "Marina Azconizaga Aguirrezabal ha trabajado un total de 11h 21m , 2:21 horas mas de lo establecido" 3 => "Marina Azconizaga Aguirrezabal 11h 21m egin du lan, gehienezko kopurua baino 2:21 gehiago" 4 => 0 5 => 14 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 ('2024-09-19', 'Marina Azconizaga Aguirrezabal ha trabajado un total de 11h 21m , 2:21 horas mas de lo establecido', 'Marina Azconizaga Aguirrezabal 11h 21m egin du lan, gehienezko kopurua baino 2:21 gehiago', 0, 14, 2, 1);
144	0.15 ms	INSERT INTO notificacion (fecha, textoes, textoeus, leido, objeto, destinatario_id, tipo_id) VALUES (?, ?, ?, ?, ?, ?, ?) Parameters: [`1 => "2024-09-19" 2 => "Marina Azconizaga Aguirrezabal ha trabajado un total de 11h 21m , 2:21 horas mas de lo establecido" 3 => "Marina Azconizaga Aguirrezabal 11h 21m egin du lan, gehienezko kopurua baino 2:21 gehiago" 4 => 0 5 => 14 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 ('2024-09-19', 'Marina Azconizaga Aguirrezabal ha trabajado un total de 11h 21m , 2:21 horas mas de lo establecido', 'Marina Azconizaga Aguirrezabal 11h 21m egin du lan, gehienezko kopurua baino 2:21 gehiago', 0, 14, 3, 1);
145	0.11 ms	INSERT INTO notificacion (fecha, textoes, textoeus, leido, objeto, destinatario_id, tipo_id) VALUES (?, ?, ?, ?, ?, ?, ?) Parameters: [`1 => "2024-09-19" 2 => "Marina Azconizaga Aguirrezabal ha trabajado un total de 11h 21m , 2:21 horas mas de lo establecido" 3 => "Marina Azconizaga Aguirrezabal 11h 21m egin du lan, gehienezko kopurua baino 2:21 gehiago" 4 => 0 5 => 14 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 ('2024-09-19', 'Marina Azconizaga Aguirrezabal ha trabajado un total de 11h 21m , 2:21 horas mas de lo establecido', 'Marina Azconizaga Aguirrezabal 11h 21m egin du lan, gehienezko kopurua baino 2:21 gehiago', 0, 14, 4, 1);
146	1.24 ms	"COMMIT" Parameters: [] View formatted query View runnable query Explain query "COMMIT" "COMMIT";
147	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 ? ORDER BY f0_.fecha ASC LIMIT 1 Parameters: [`15 "2024-09-19%"`] 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 '2024-09-19%' ORDER BY f0_.fecha ASC LIMIT 1;
148	0.93 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: [`15 "2024-09-19%" "2024-09-19 08:21:14"`] 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 = 15 AND f0_.fecha LIKE '2024-09-19%' AND f0_.fecha > '2024-09-19 08:21:14' ORDER BY f0_.fecha ASC LIMIT 1;
149	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: [`15 "2024-09-19%" "2024-09-19 12:21:33"`] 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 = 15 AND f0_.fecha LIKE '2024-09-19%' AND f0_.fecha > '2024-09-19 12:21:33' ORDER BY f0_.fecha ASC LIMIT 1;
150	0.92 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 "2024-09-19%"`] 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 '2024-09-19%' ORDER BY f0_.fecha ASC LIMIT 1;
151	0.63 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 "2024-09-19%"`] 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 '2024-09-19%' ORDER BY f0_.fecha ASC LIMIT 1;
152	0.55 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 "2024-09-19%" "2024-09-19 08:34:02"`] 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 '2024-09-19%' AND f0_.fecha > '2024-09-19 08:34:02' ORDER BY f0_.fecha ASC LIMIT 1;
153	0.54 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 "2024-09-19%" "2024-09-19 13:00:27"`] 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 '2024-09-19%' AND f0_.fecha > '2024-09-19 13:00:27' ORDER BY f0_.fecha ASC LIMIT 1;
154	0.97 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 "2024-09-19%"`] 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 '2024-09-19%' ORDER BY f0_.fecha ASC LIMIT 1;
155	0.89 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 "2024-09-19%" "2024-09-19 07:55: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 = 19 AND f0_.fecha LIKE '2024-09-19%' AND f0_.fecha > '2024-09-19 07:55:30' ORDER BY f0_.fecha ASC LIMIT 1;
156	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: [`19 "2024-09-19%" "2024-09-19 16:00:24"`] 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 '2024-09-19%' AND f0_.fecha > '2024-09-19 16:00:24' ORDER BY f0_.fecha ASC LIMIT 1;
157	1.02 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 "2024-09-19%"`] 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 '2024-09-19%' ORDER BY f0_.fecha ASC LIMIT 1;
158	0.70 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 "2024-09-19%"`] 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 '2024-09-19%' ORDER BY f0_.fecha ASC LIMIT 1;
159	1.53 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 "2024-09-19%"`] 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 '2024-09-19%' ORDER BY f0_.fecha ASC LIMIT 1;
160	1.25 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 "2024-09-19%" "2024-09-19 08:08: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 = 22 AND f0_.fecha LIKE '2024-09-19%' AND f0_.fecha > '2024-09-19 08:08:22' ORDER BY f0_.fecha ASC LIMIT 1;
161	1.19 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 "2024-09-19%" "2024-09-19 16:37:49"`] 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 '2024-09-19%' AND f0_.fecha > '2024-09-19 16:37:49' ORDER BY f0_.fecha ASC LIMIT 1;
162	0.69 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 "2024-09-19%"`] 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 '2024-09-19%' ORDER BY f0_.fecha ASC LIMIT 1;
163	0.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: [`24 "2024-09-19%"`] 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 '2024-09-19%' ORDER BY f0_.fecha ASC LIMIT 1;
164	0.33 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 "2024-09-19%"`] 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 '2024-09-19%' ORDER BY f0_.fecha ASC LIMIT 1;
165	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 ? ORDER BY f0_.fecha ASC LIMIT 1 Parameters: [`26 "2024-09-19%"`] 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 '2024-09-19%' ORDER BY f0_.fecha ASC LIMIT 1;
166	0.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: [`26 "2024-09-19%" "2024-09-19 08:01: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 = 26 AND f0_.fecha LIKE '2024-09-19%' AND f0_.fecha > '2024-09-19 08:01:32' ORDER BY f0_.fecha ASC LIMIT 1;
167	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: [`26 "2024-09-19%" "2024-09-19 16:00: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 = 26 AND f0_.fecha LIKE '2024-09-19%' AND f0_.fecha > '2024-09-19 16:00:20' ORDER BY f0_.fecha ASC LIMIT 1;
168	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 ? ORDER BY f0_.fecha ASC LIMIT 1 Parameters: [`27 "2024-09-19%"`] 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 '2024-09-19%' ORDER BY f0_.fecha ASC LIMIT 1;
169	0.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: [`28 "2024-09-19%"`] 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 '2024-09-19%' ORDER BY f0_.fecha ASC LIMIT 1;
170	0.59 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 "2024-09-19%"`] 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 '2024-09-19%' ORDER BY f0_.fecha ASC LIMIT 1;
171	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: [`30 "2024-09-19%"`] 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 '2024-09-19%' ORDER BY f0_.fecha ASC LIMIT 1;
172	0.40 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 "2024-09-19%" "2024-09-19 08:49:05"`] 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 '2024-09-19%' AND f0_.fecha > '2024-09-19 08:49:05' ORDER BY f0_.fecha ASC LIMIT 1;
173	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: [`30 "2024-09-19%" "2024-09-19 17:10:41"`] 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 '2024-09-19%' AND f0_.fecha > '2024-09-19 17:10:41' ORDER BY f0_.fecha ASC LIMIT 1;
174	0.21 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 "2024-09-19%"`] 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 '2024-09-19%' ORDER BY f0_.fecha ASC LIMIT 1;
175	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: [`32 "2024-09-19%"`] 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 '2024-09-19%' ORDER BY f0_.fecha ASC LIMIT 1;
176	0.21 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: [`32 "2024-09-19%" "2024-09-19 08:59:33"`] 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 = 32 AND f0_.fecha LIKE '2024-09-19%' AND f0_.fecha > '2024-09-19 08:59:33' ORDER BY f0_.fecha ASC LIMIT 1;
177	0.21 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: [`32 "2024-09-19%" "2024-09-19 17:00: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 = 32 AND f0_.fecha LIKE '2024-09-19%' AND f0_.fecha > '2024-09-19 17:00:21' ORDER BY f0_.fecha ASC LIMIT 1;
178	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: [`33 "2024-09-19%"`] 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 '2024-09-19%' ORDER BY f0_.fecha ASC LIMIT 1;
179	0.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 ? AND f0_.fecha > ? ORDER BY f0_.fecha ASC LIMIT 1 Parameters: [`33 "2024-09-19%" "2024-09-19 08:23: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 = 33 AND f0_.fecha LIKE '2024-09-19%' AND f0_.fecha > '2024-09-19 08:23:54' ORDER BY f0_.fecha ASC LIMIT 1;
180	0.19 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 "2024-09-19%" "2024-09-19 16:26: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 '2024-09-19%' AND f0_.fecha > '2024-09-19 16:26:15' ORDER BY f0_.fecha ASC LIMIT 1;
181	0.15 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;
182	0.16 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;
183	0.14 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;
184	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;
185	0.36 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;
186	0.90 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.objeto = ? LIMIT 1 Parameters: [`4 48`] 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.objeto = ? 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 = 4 AND t0.objeto = 48 LIMIT 1;
187	0.23 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\"%';
188	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;
189	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.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;
190	0.16 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;
191	7.13 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 "2024-09-19" 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 = '2024-09-19' AND t0.destinatario_id = 1 ORDER BY t0.fecha DESC;
192	1.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: [`2 "2024-09-19" 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 = '2024-09-19' AND t0.destinatario_id = 1 ORDER BY t0.fecha DESC;
193	3.74 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 "2024-09-19" 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 = '2024-09-19' AND t0.destinatario_id = 1 ORDER BY t0.fecha DESC;
194	3.65 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 "2024-09-19"`] 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 = '2024-09-19' ORDER BY n0_.fecha DESC;
195	5.25 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 "2024-09-19" 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 = '2024-09-19' AND t0.destinatario_id = 2 ORDER BY t0.fecha DESC;
196	1.54 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 "2024-09-19" 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 = '2024-09-19' AND t0.destinatario_id = 2 ORDER BY t0.fecha DESC;
197	4.04 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 "2024-09-19" 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 = '2024-09-19' AND t0.destinatario_id = 2 ORDER BY t0.fecha DESC;
198	3.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%" 2 "2024-09-19"`] 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 = '2024-09-19' ORDER BY n0_.fecha DESC;
199	5.91 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 "2024-09-19" 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 = '2024-09-19' AND t0.destinatario_id = 3 ORDER BY t0.fecha DESC;
200	1.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: [`2 "2024-09-19" 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 = '2024-09-19' AND t0.destinatario_id = 3 ORDER BY t0.fecha DESC;
201	4.46 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 "2024-09-19" 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 = '2024-09-19' AND t0.destinatario_id = 3 ORDER BY t0.fecha DESC;
202	3.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 "2024-09-19"`] 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 = '2024-09-19' ORDER BY n0_.fecha DESC;
203	5.46 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 "2024-09-19" 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 = '2024-09-19' AND t0.destinatario_id = 4 ORDER BY t0.fecha DESC;
204	1.84 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 "2024-09-19" 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 = '2024-09-19' AND t0.destinatario_id = 4 ORDER BY t0.fecha DESC;
205	4.38 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 "2024-09-19" 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 = '2024-09-19' AND t0.destinatario_id = 4 ORDER BY t0.fecha DESC;
206	3.94 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 "2024-09-19"`] 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 = '2024-09-19' 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