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

Query Metrics

155 Database Queries
22 Different statements
130.56 ms Query time
1 Invalid entities

Queries

Group similar statements

# Time Info
1 1.08 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:
[]
2 0.32 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:
[]
3 0.65 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
]
4 2.86 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
]
5 1.52 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
]
6 0.09 ms
"START TRANSACTION"
Parameters:
[]
7 0.39 ms
INSERT INTO fichaje_diario (fecha, entrada, empleada_id) VALUES (?, ?, ?)
Parameters:
[
  1 => "2025-01-03 21:00:00"
  2 => 0
  3 => 3
]
8 1.56 ms
"COMMIT"
Parameters:
[]
9 0.25 ms
SELECT t0.id AS id_1, t0.descripcion AS descripcion_2 FROM tipo_notificacion t0 WHERE t0.descripcion = ? LIMIT 1
Parameters:
[
  "tipoNotificacion.fichajeNoCerrado"
]
10 0.38 ms
SELECT u0_.id AS id_0, u0_.email AS email_1, u0_.roles AS roles_2, u0_.password AS password_3, u0_.is_verified AS is_verified_4, u0_.nombre AS nombre_5, u0_.habilitado AS habilitado_6, u0_.empleada_id AS empleada_id_7, u0_.contacto_id AS contacto_id_8, u0_.contacto_proveedor_id AS contacto_proveedor_id_9 FROM usuario u0_ WHERE u0_.roles LIKE ?
Parameters:
[
  "%"ROLE_ADMIN"%"
]
11 0.08 ms
"START TRANSACTION"
Parameters:
[]
12 0.32 ms
INSERT INTO notificacion (fecha, textoes, textoeus, leido, objeto, destinatario_id, tipo_id) VALUES (?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  1 => "2025-01-03"
  2 => "Se ha cerrado un fichaje para Maria Alonso con fecha: 2025-01-03"
  3 => "Fitxaje bat ixti da Maria Alonso-rentzat 03-01-2025 datarekin"
  4 => 0
  5 => 3
  6 => 3
  7 => 3
]
13 0.13 ms
INSERT INTO notificacion (fecha, textoes, textoeus, leido, objeto, destinatario_id, tipo_id) VALUES (?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  1 => "2025-01-03"
  2 => "Se ha cerrado un fichaje para Maria Alonso con fecha: 2025-01-03"
  3 => "Fitxaje bat ixti da Maria Alonso-rentzat 03-01-2025 datarekin"
  4 => 0
  5 => 3
  6 => 1
  7 => 3
]
14 0.10 ms
INSERT INTO notificacion (fecha, textoes, textoeus, leido, objeto, destinatario_id, tipo_id) VALUES (?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  1 => "2025-01-03"
  2 => "Se ha cerrado un fichaje para Maria Alonso con fecha: 2025-01-03"
  3 => "Fitxaje bat ixti da Maria Alonso-rentzat 03-01-2025 datarekin"
  4 => 0
  5 => 3
  6 => 2
  7 => 3
]
15 0.11 ms
INSERT INTO notificacion (fecha, textoes, textoeus, leido, objeto, destinatario_id, tipo_id) VALUES (?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  1 => "2025-01-03"
  2 => "Se ha cerrado un fichaje para Maria Alonso con fecha: 2025-01-03"
  3 => "Fitxaje bat ixti da Maria Alonso-rentzat 03-01-2025 datarekin"
  4 => 0
  5 => 3
  6 => 4
  7 => 3
]
16 1.35 ms
"COMMIT"
Parameters:
[]
17 1.68 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
]
18 1.24 ms
SELECT t0.id AS id_1, t0.fecha AS fecha_2, t0.entrada AS entrada_3, t0.empleada_id AS empleada_id_4 FROM fichaje_diario t0 WHERE t0.empleada_id = ? ORDER BY t0.fecha DESC LIMIT 1
Parameters:
[
  6
]
19 0.90 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
]
20 1.05 ms
SELECT t0.id AS id_1, t0.fecha AS fecha_2, t0.entrada AS entrada_3, t0.empleada_id AS empleada_id_4 FROM fichaje_diario t0 WHERE t0.empleada_id = ? ORDER BY t0.fecha DESC LIMIT 1
Parameters:
[
  8
]
21 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:
[
  9
]
22 1.03 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
]
23 1.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:
[
  11
]
24 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:
[
  12
]
25 0.74 ms
SELECT t0.id AS id_1, t0.fecha AS fecha_2, t0.entrada AS entrada_3, t0.empleada_id AS empleada_id_4 FROM fichaje_diario t0 WHERE t0.empleada_id = ? ORDER BY t0.fecha DESC LIMIT 1
Parameters:
[
  13
]
26 1.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:
[
  14
]
27 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
]
28 0.10 ms
"START TRANSACTION"
Parameters:
[]
29 0.14 ms
INSERT INTO fichaje_diario (fecha, entrada, empleada_id) VALUES (?, ?, ?)
Parameters:
[
  1 => "2025-01-03 21:00:00"
  2 => 0
  3 => 15
]
30 1.30 ms
"COMMIT"
Parameters:
[]
31 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"
]
32 0.18 ms
SELECT u0_.id AS id_0, u0_.email AS email_1, u0_.roles AS roles_2, u0_.password AS password_3, u0_.is_verified AS is_verified_4, u0_.nombre AS nombre_5, u0_.habilitado AS habilitado_6, u0_.empleada_id AS empleada_id_7, u0_.contacto_id AS contacto_id_8, u0_.contacto_proveedor_id AS contacto_proveedor_id_9 FROM usuario u0_ WHERE u0_.roles LIKE ?
Parameters:
[
  "%"ROLE_ADMIN"%"
]
33 0.06 ms
"START TRANSACTION"
Parameters:
[]
34 0.17 ms
INSERT INTO notificacion (fecha, textoes, textoeus, leido, objeto, destinatario_id, tipo_id) VALUES (?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  1 => "2025-01-03"
  2 => "Se ha cerrado un fichaje para Garazi Artuñedo Zugazaga con fecha: 2025-01-03"
  3 => "Fitxaje bat ixti da Garazi Artuñedo Zugazaga-rentzat 03-01-2025 datarekin"
  4 => 0
  5 => 15
  6 => 15
  7 => 3
]
35 1.63 ms
INSERT INTO notificacion (fecha, textoes, textoeus, leido, objeto, destinatario_id, tipo_id) VALUES (?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  1 => "2025-01-03"
  2 => "Se ha cerrado un fichaje para Garazi Artuñedo Zugazaga con fecha: 2025-01-03"
  3 => "Fitxaje bat ixti da Garazi Artuñedo Zugazaga-rentzat 03-01-2025 datarekin"
  4 => 0
  5 => 15
  6 => 1
  7 => 3
]
36 0.10 ms
INSERT INTO notificacion (fecha, textoes, textoeus, leido, objeto, destinatario_id, tipo_id) VALUES (?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  1 => "2025-01-03"
  2 => "Se ha cerrado un fichaje para Garazi Artuñedo Zugazaga con fecha: 2025-01-03"
  3 => "Fitxaje bat ixti da Garazi Artuñedo Zugazaga-rentzat 03-01-2025 datarekin"
  4 => 0
  5 => 15
  6 => 2
  7 => 3
]
37 0.11 ms
INSERT INTO notificacion (fecha, textoes, textoeus, leido, objeto, destinatario_id, tipo_id) VALUES (?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  1 => "2025-01-03"
  2 => "Se ha cerrado un fichaje para Garazi Artuñedo Zugazaga con fecha: 2025-01-03"
  3 => "Fitxaje bat ixti da Garazi Artuñedo Zugazaga-rentzat 03-01-2025 datarekin"
  4 => 0
  5 => 15
  6 => 3
  7 => 3
]
38 0.10 ms
INSERT INTO notificacion (fecha, textoes, textoeus, leido, objeto, destinatario_id, tipo_id) VALUES (?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  1 => "2025-01-03"
  2 => "Se ha cerrado un fichaje para Garazi Artuñedo Zugazaga con fecha: 2025-01-03"
  3 => "Fitxaje bat ixti da Garazi Artuñedo Zugazaga-rentzat 03-01-2025 datarekin"
  4 => 0
  5 => 15
  6 => 4
  7 => 3
]
39 1.08 ms
"COMMIT"
Parameters:
[]
40 1.42 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
]
41 0.87 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
]
42 1.21 ms
SELECT t0.id AS id_1, t0.fecha AS fecha_2, t0.entrada AS entrada_3, t0.empleada_id AS empleada_id_4 FROM fichaje_diario t0 WHERE t0.empleada_id = ? ORDER BY t0.fecha DESC LIMIT 1
Parameters:
[
  19
]
43 1.21 ms
SELECT t0.id AS id_1, t0.fecha AS fecha_2, t0.entrada AS entrada_3, t0.empleada_id AS empleada_id_4 FROM fichaje_diario t0 WHERE t0.empleada_id = ? ORDER BY t0.fecha DESC LIMIT 1
Parameters:
[
  20
]
44 0.76 ms
SELECT t0.id AS id_1, t0.fecha AS fecha_2, t0.entrada AS entrada_3, t0.empleada_id AS empleada_id_4 FROM fichaje_diario t0 WHERE t0.empleada_id = ? ORDER BY t0.fecha DESC LIMIT 1
Parameters:
[
  21
]
45 1.84 ms
SELECT t0.id AS id_1, t0.fecha AS fecha_2, t0.entrada AS entrada_3, t0.empleada_id AS empleada_id_4 FROM fichaje_diario t0 WHERE t0.empleada_id = ? ORDER BY t0.fecha DESC LIMIT 1
Parameters:
[
  22
]
46 0.79 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
]
47 0.27 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
]
48 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
]
49 1.12 ms
SELECT t0.id AS id_1, t0.fecha AS fecha_2, t0.entrada AS entrada_3, t0.empleada_id AS empleada_id_4 FROM fichaje_diario t0 WHERE t0.empleada_id = ? ORDER BY t0.fecha DESC LIMIT 1
Parameters:
[
  26
]
50 0.68 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
]
51 0.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:
[
  28
]
52 0.52 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
]
53 0.67 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
]
54 0.25 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
]
55 0.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:
[
  32
]
56 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:
[
  33
]
57 0.24 ms
SELECT t0.id AS id_1, t0.fecha AS fecha_2, t0.entrada AS entrada_3, t0.empleada_id AS empleada_id_4 FROM fichaje_diario t0 WHERE t0.empleada_id = ? ORDER BY t0.fecha DESC LIMIT 1
Parameters:
[
  34
]
58 0.36 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:
[]
59 0.16 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:
[]
60 0.22 ms
SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = ? AND f0_.fecha LIKE ? ORDER BY f0_.fecha ASC LIMIT 1
Parameters:
[
  1
  "2025-01-03%"
]
61 1.36 ms
SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = ? AND f0_.fecha LIKE ? ORDER BY f0_.fecha ASC LIMIT 1
Parameters:
[
  2
  "2025-01-03%"
]
62 1.11 ms
SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = ? AND f0_.fecha LIKE ? ORDER BY f0_.fecha ASC LIMIT 1
Parameters:
[
  3
  "2025-01-03%"
]
63 0.84 ms
SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = ? AND f0_.fecha LIKE ? AND f0_.fecha > ? ORDER BY f0_.fecha ASC LIMIT 1
Parameters:
[
  3
  "2025-01-03%"
  "2025-01-03 08:31:08"
]
64 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:
[
  3
  "2025-01-03%"
  "2025-01-03 21:00:00"
]
65 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"
]
66 0.18 ms
SELECT u0_.id AS id_0, u0_.email AS email_1, u0_.roles AS roles_2, u0_.password AS password_3, u0_.is_verified AS is_verified_4, u0_.nombre AS nombre_5, u0_.habilitado AS habilitado_6, u0_.empleada_id AS empleada_id_7, u0_.contacto_id AS contacto_id_8, u0_.contacto_proveedor_id AS contacto_proveedor_id_9 FROM usuario u0_ WHERE u0_.roles LIKE ?
Parameters:
[
  "%"ROLE_ADMIN"%"
]
67 0.07 ms
"START TRANSACTION"
Parameters:
[]
68 0.16 ms
INSERT INTO notificacion (fecha, textoes, textoeus, leido, objeto, destinatario_id, tipo_id) VALUES (?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  1 => "2025-01-03"
  2 => "Maria Alonso ha trabajado un total de 12h 28m , 3:28 horas mas de lo establecido"
  3 => "Maria Alonso 12h 28m egin du lan, gehienezko kopurua baino 3:28  gehiago"
  4 => 0
  5 => 3
  6 => 3
  7 => 1
]
69 0.10 ms
INSERT INTO notificacion (fecha, textoes, textoeus, leido, objeto, destinatario_id, tipo_id) VALUES (?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  1 => "2025-01-03"
  2 => "Maria Alonso ha trabajado un total de 12h 28m , 3:28 horas mas de lo establecido"
  3 => "Maria Alonso 12h 28m egin du lan, gehienezko kopurua baino 3:28  gehiago"
  4 => 0
  5 => 3
  6 => 1
  7 => 1
]
70 0.10 ms
INSERT INTO notificacion (fecha, textoes, textoeus, leido, objeto, destinatario_id, tipo_id) VALUES (?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  1 => "2025-01-03"
  2 => "Maria Alonso ha trabajado un total de 12h 28m , 3:28 horas mas de lo establecido"
  3 => "Maria Alonso 12h 28m egin du lan, gehienezko kopurua baino 3:28  gehiago"
  4 => 0
  5 => 3
  6 => 2
  7 => 1
]
71 0.12 ms
INSERT INTO notificacion (fecha, textoes, textoeus, leido, objeto, destinatario_id, tipo_id) VALUES (?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  1 => "2025-01-03"
  2 => "Maria Alonso ha trabajado un total de 12h 28m , 3:28 horas mas de lo establecido"
  3 => "Maria Alonso 12h 28m egin du lan, gehienezko kopurua baino 3:28  gehiago"
  4 => 0
  5 => 3
  6 => 4
  7 => 1
]
72 1.52 ms
"COMMIT"
Parameters:
[]
73 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:
[
  4
  "2025-01-03%"
]
74 1.12 ms
SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = ? AND f0_.fecha LIKE ? ORDER BY f0_.fecha ASC LIMIT 1
Parameters:
[
  6
  "2025-01-03%"
]
75 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:
[
  7
  "2025-01-03%"
]
76 0.87 ms
SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = ? AND f0_.fecha LIKE ? AND f0_.fecha > ? ORDER BY f0_.fecha ASC LIMIT 1
Parameters:
[
  7
  "2025-01-03%"
  "2025-01-03 09:11:49"
]
77 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:
[
  7
  "2025-01-03%"
  "2025-01-03 14:10:24"
]
78 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:
[
  8
  "2025-01-03%"
]
79 1.46 ms
SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = ? AND f0_.fecha LIKE ? ORDER BY f0_.fecha ASC LIMIT 1
Parameters:
[
  9
  "2025-01-03%"
]
80 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 ? AND f0_.fecha > ? ORDER BY f0_.fecha ASC LIMIT 1
Parameters:
[
  9
  "2025-01-03%"
  "2025-01-03 08:05:01"
]
81 1.01 ms
SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = ? AND f0_.fecha LIKE ? AND f0_.fecha > ? ORDER BY f0_.fecha ASC LIMIT 1
Parameters:
[
  9
  "2025-01-03%"
  "2025-01-03 14:22:56"
]
82 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:
[
  10
  "2025-01-03%"
]
83 1.32 ms
SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = ? AND f0_.fecha LIKE ? ORDER BY f0_.fecha ASC LIMIT 1
Parameters:
[
  11
  "2025-01-03%"
]
84 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:
[
  12
  "2025-01-03%"
]
85 0.88 ms
SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = ? AND f0_.fecha LIKE ? ORDER BY f0_.fecha ASC LIMIT 1
Parameters:
[
  13
  "2025-01-03%"
]
86 1.30 ms
SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = ? AND f0_.fecha LIKE ? ORDER BY f0_.fecha ASC LIMIT 1
Parameters:
[
  14
  "2025-01-03%"
]
87 1.12 ms
SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = ? AND f0_.fecha LIKE ? ORDER BY f0_.fecha ASC LIMIT 1
Parameters:
[
  15
  "2025-01-03%"
]
88 1.11 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
  "2025-01-03%"
  "2025-01-03 08:01:43"
]
89 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
  "2025-01-03%"
  "2025-01-03 21:00:00"
]
90 0.13 ms
SELECT t0.id AS id_1, t0.descripcion AS descripcion_2 FROM tipo_notificacion t0 WHERE t0.descripcion = ? LIMIT 1
Parameters:
[
  "tipoNotificacion.horasSuperadas"
]
91 0.18 ms
SELECT u0_.id AS id_0, u0_.email AS email_1, u0_.roles AS roles_2, u0_.password AS password_3, u0_.is_verified AS is_verified_4, u0_.nombre AS nombre_5, u0_.habilitado AS habilitado_6, u0_.empleada_id AS empleada_id_7, u0_.contacto_id AS contacto_id_8, u0_.contacto_proveedor_id AS contacto_proveedor_id_9 FROM usuario u0_ WHERE u0_.roles LIKE ?
Parameters:
[
  "%"ROLE_ADMIN"%"
]
92 0.08 ms
"START TRANSACTION"
Parameters:
[]
93 0.20 ms
INSERT INTO notificacion (fecha, textoes, textoeus, leido, objeto, destinatario_id, tipo_id) VALUES (?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  1 => "2025-01-03"
  2 => "Garazi Artuñedo Zugazaga ha trabajado un total de 12h 58m , 3:58 horas mas de lo establecido"
  3 => "Garazi Artuñedo Zugazaga 12h 58m egin du lan, gehienezko kopurua baino 3:58  gehiago"
  4 => 0
  5 => 15
  6 => 15
  7 => 1
]
94 0.11 ms
INSERT INTO notificacion (fecha, textoes, textoeus, leido, objeto, destinatario_id, tipo_id) VALUES (?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  1 => "2025-01-03"
  2 => "Garazi Artuñedo Zugazaga ha trabajado un total de 12h 58m , 3:58 horas mas de lo establecido"
  3 => "Garazi Artuñedo Zugazaga 12h 58m egin du lan, gehienezko kopurua baino 3:58  gehiago"
  4 => 0
  5 => 15
  6 => 1
  7 => 1
]
95 0.10 ms
INSERT INTO notificacion (fecha, textoes, textoeus, leido, objeto, destinatario_id, tipo_id) VALUES (?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  1 => "2025-01-03"
  2 => "Garazi Artuñedo Zugazaga ha trabajado un total de 12h 58m , 3:58 horas mas de lo establecido"
  3 => "Garazi Artuñedo Zugazaga 12h 58m egin du lan, gehienezko kopurua baino 3:58  gehiago"
  4 => 0
  5 => 15
  6 => 2
  7 => 1
]
96 0.09 ms
INSERT INTO notificacion (fecha, textoes, textoeus, leido, objeto, destinatario_id, tipo_id) VALUES (?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  1 => "2025-01-03"
  2 => "Garazi Artuñedo Zugazaga ha trabajado un total de 12h 58m , 3:58 horas mas de lo establecido"
  3 => "Garazi Artuñedo Zugazaga 12h 58m egin du lan, gehienezko kopurua baino 3:58  gehiago"
  4 => 0
  5 => 15
  6 => 3
  7 => 1
]
97 0.09 ms
INSERT INTO notificacion (fecha, textoes, textoeus, leido, objeto, destinatario_id, tipo_id) VALUES (?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  1 => "2025-01-03"
  2 => "Garazi Artuñedo Zugazaga ha trabajado un total de 12h 58m , 3:58 horas mas de lo establecido"
  3 => "Garazi Artuñedo Zugazaga 12h 58m egin du lan, gehienezko kopurua baino 3:58  gehiago"
  4 => 0
  5 => 15
  6 => 4
  7 => 1
]
98 1.42 ms
"COMMIT"
Parameters:
[]
99 1.43 ms
SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = ? AND f0_.fecha LIKE ? ORDER BY f0_.fecha ASC LIMIT 1
Parameters:
[
  16
  "2025-01-03%"
]
100 0.94 ms
SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = ? AND f0_.fecha LIKE ? ORDER BY f0_.fecha ASC LIMIT 1
Parameters:
[
  18
  "2025-01-03%"
]
101 1.18 ms
SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = ? AND f0_.fecha LIKE ? ORDER BY f0_.fecha ASC LIMIT 1
Parameters:
[
  19
  "2025-01-03%"
]
102 0.95 ms
SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = ? AND f0_.fecha LIKE ? AND f0_.fecha > ? ORDER BY f0_.fecha ASC LIMIT 1
Parameters:
[
  19
  "2025-01-03%"
  "2025-01-03 07:57:23"
]
103 1.31 ms
SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = ? AND f0_.fecha LIKE ? AND f0_.fecha > ? ORDER BY f0_.fecha ASC LIMIT 1
Parameters:
[
  19
  "2025-01-03%"
  "2025-01-03 14:02:11"
]
104 1.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:
[
  20
  "2025-01-03%"
]
105 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:
[
  20
  "2025-01-03%"
  "2025-01-03 07:48:32"
]
106 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 ? AND f0_.fecha > ? ORDER BY f0_.fecha ASC LIMIT 1
Parameters:
[
  20
  "2025-01-03%"
  "2025-01-03 14:50:55"
]
107 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 ? ORDER BY f0_.fecha ASC LIMIT 1
Parameters:
[
  21
  "2025-01-03%"
]
108 2.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:
[
  22
  "2025-01-03%"
]
109 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 ? AND f0_.fecha > ? ORDER BY f0_.fecha ASC LIMIT 1
Parameters:
[
  22
  "2025-01-03%"
  "2025-01-03 07:56:09"
]
110 2.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:
[
  22
  "2025-01-03%"
  "2025-01-03 14:31:57"
]
111 1.10 ms
SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = ? AND f0_.fecha LIKE ? ORDER BY f0_.fecha ASC LIMIT 1
Parameters:
[
  23
  "2025-01-03%"
]
112 0.35 ms
SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = ? AND f0_.fecha LIKE ? ORDER BY f0_.fecha ASC LIMIT 1
Parameters:
[
  24
  "2025-01-03%"
]
113 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 ? ORDER BY f0_.fecha ASC LIMIT 1
Parameters:
[
  25
  "2025-01-03%"
]
114 1.45 ms
SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = ? AND f0_.fecha LIKE ? ORDER BY f0_.fecha ASC LIMIT 1
Parameters:
[
  26
  "2025-01-03%"
]
115 1.32 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
  "2025-01-03%"
  "2025-01-03 08:02:16"
]
116 1.29 ms
SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = ? AND f0_.fecha LIKE ? AND f0_.fecha > ? ORDER BY f0_.fecha ASC LIMIT 1
Parameters:
[
  26
  "2025-01-03%"
  "2025-01-03 13:54:58"
]
117 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 ? ORDER BY f0_.fecha ASC LIMIT 1
Parameters:
[
  27
  "2025-01-03%"
]
118 0.39 ms
SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = ? AND f0_.fecha LIKE ? ORDER BY f0_.fecha ASC LIMIT 1
Parameters:
[
  28
  "2025-01-03%"
]
119 0.61 ms
SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = ? AND f0_.fecha LIKE ? ORDER BY f0_.fecha ASC LIMIT 1
Parameters:
[
  29
  "2025-01-03%"
]
120 0.71 ms
SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = ? AND f0_.fecha LIKE ? ORDER BY f0_.fecha ASC LIMIT 1
Parameters:
[
  30
  "2025-01-03%"
]
121 0.57 ms
SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = ? AND f0_.fecha LIKE ? AND f0_.fecha > ? ORDER BY f0_.fecha ASC LIMIT 1
Parameters:
[
  30
  "2025-01-03%"
  "2025-01-03 08:45:19"
]
122 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:
[
  30
  "2025-01-03%"
  "2025-01-03 14:48:00"
]
123 0.24 ms
SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = ? AND f0_.fecha LIKE ? ORDER BY f0_.fecha ASC LIMIT 1
Parameters:
[
  31
  "2025-01-03%"
]
124 0.30 ms
SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = ? AND f0_.fecha LIKE ? ORDER BY f0_.fecha ASC LIMIT 1
Parameters:
[
  32
  "2025-01-03%"
]
125 0.39 ms
SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = ? AND f0_.fecha LIKE ? ORDER BY f0_.fecha ASC LIMIT 1
Parameters:
[
  33
  "2025-01-03%"
]
126 0.35 ms
SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = ? AND f0_.fecha LIKE ? ORDER BY f0_.fecha ASC LIMIT 1
Parameters:
[
  34
  "2025-01-03%"
]
127 0.27 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:
[]
128 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.justificacion1"
]
129 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.justificacion2"
]
130 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.justificacion3"
]
131 0.33 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
]
132 1.11 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:
[
  6
  51
]
133 0.85 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:
[
  5
  51
]
134 0.70 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
  51
]
135 0.35 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:
[
  5
  55
]
136 0.47 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
  55
]
137 0.25 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"%"
]
138 0.13 ms
SELECT t0.id AS id_1, t0.descripcion AS descripcion_2 FROM tipo_notificacion t0 WHERE t0.descripcion = ? LIMIT 1
Parameters:
[
  "tipoNotificacion.horasSuperadas"
]
139 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.horasNoCumplidas"
]
140 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"
]
141 8.53 ms
SELECT t0.id AS id_1, t0.fecha AS fecha_2, t0.textoes AS textoes_3, t0.textoeus AS textoeus_4, t0.leido AS leido_5, t0.objeto AS objeto_6, t0.destinatario_id AS destinatario_id_7, t0.tipo_id AS tipo_id_8 FROM notificacion t0 WHERE t0.tipo_id = ? AND t0.fecha = ? AND t0.destinatario_id = ? ORDER BY t0.fecha DESC
Parameters:
[
  1
  "2025-01-03"
  1
]
142 2.00 ms
SELECT t0.id AS id_1, t0.fecha AS fecha_2, t0.textoes AS textoes_3, t0.textoeus AS textoeus_4, t0.leido AS leido_5, t0.objeto AS objeto_6, t0.destinatario_id AS destinatario_id_7, t0.tipo_id AS tipo_id_8 FROM notificacion t0 WHERE t0.tipo_id = ? AND t0.fecha = ? AND t0.destinatario_id = ? ORDER BY t0.fecha DESC
Parameters:
[
  2
  "2025-01-03"
  1
]
143 5.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:
[
  3
  "2025-01-03"
  1
]
144 4.98 ms
SELECT n0_.id AS id_0, n0_.fecha AS fecha_1, n0_.textoes AS textoes_2, n0_.textoeus AS textoeus_3, n0_.leido AS leido_4, n0_.objeto AS objeto_5, n0_.destinatario_id AS destinatario_id_6, n0_.tipo_id AS tipo_id_7 FROM notificacion n0_ INNER JOIN tipo_notificacion t1_ ON n0_.tipo_id = t1_.id WHERE t1_.descripcion LIKE ? AND n0_.destinatario_id = ? AND n0_.fecha = ? ORDER BY n0_.fecha DESC
Parameters:
[
  "tipoNotificacion.justificacion%"
  1
  "2025-01-03"
]
145 0.84 ms
SHOW FULL TABLES WHERE Table_type = 'BASE TABLE'
Parameters:
[]
146 0.32 ms
SHOW FULL TABLES WHERE Table_type = 'BASE TABLE'
Parameters:
[]
147 0.12 ms
SELECT DATABASE()
Parameters:
[]
148 0.57 ms
SELECT COLUMN_NAME AS Field, COLUMN_TYPE AS Type, IS_NULLABLE AS `Null`, COLUMN_KEY AS `Key`, COLUMN_DEFAULT AS `Default`, EXTRA AS Extra, COLUMN_COMMENT AS Comment, CHARACTER_SET_NAME AS CharacterSet, COLLATION_NAME AS Collation FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = 'daitekecrm' AND TABLE_NAME = 'doctrine_migration_versions' ORDER BY ORDINAL_POSITION ASC
Parameters:
[]
149 0.08 ms
SELECT DATABASE()
Parameters:
[]
150 5.14 ms
SELECT k.CONSTRAINT_NAME, k.COLUMN_NAME, k.REFERENCED_TABLE_NAME, k.REFERENCED_COLUMN_NAME /*!50116 , c.UPDATE_RULE, c.DELETE_RULE */ FROM INFORMATION_SCHEMA.KEY_COLUMN_USAGE k /*!50116 INNER JOIN INFORMATION_SCHEMA.REFERENTIAL_CONSTRAINTS c ON c.CONSTRAINT_NAME = k.CONSTRAINT_NAME AND c.TABLE_NAME = k.TABLE_NAME */ WHERE k.TABLE_NAME = 'doctrine_migration_versions' AND k.TABLE_SCHEMA = 'daitekecrm' /*!50116 AND c.CONSTRAINT_SCHEMA = 'daitekecrm' */ORDER BY k.ORDINAL_POSITION
Parameters:
[]
151 0.07 ms
SELECT DATABASE()
Parameters:
[]
152 0.16 ms
SELECT NON_UNIQUE AS Non_Unique, INDEX_NAME AS Key_name, COLUMN_NAME AS Column_Name, SUB_PART AS Sub_Part, INDEX_TYPE AS Index_Type FROM information_schema.STATISTICS WHERE TABLE_NAME = 'doctrine_migration_versions' AND TABLE_SCHEMA = 'daitekecrm' ORDER BY SEQ_IN_INDEX ASC
Parameters:
[]
153 0.45 ms
SELECT t.ENGINE,
       t.AUTO_INCREMENT,
       t.TABLE_COMMENT,
       t.CREATE_OPTIONS,
       t.TABLE_COLLATION,
       ccsa.CHARACTER_SET_NAME
FROM information_schema.TABLES t
    INNER JOIN information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` ccsa
        ON ccsa.COLLATION_NAME = t.TABLE_COLLATION
WHERE TABLE_TYPE = 'BASE TABLE' AND TABLE_SCHEMA = DATABASE() AND TABLE_NAME = 'doctrine_migration_versions'
Parameters:
[]
154 0.13 ms
SELECT * FROM doctrine_migration_versions
Parameters:
[]
155 0.09 ms
SELECT DATABASE()
Parameters:
[]

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

Class Mapping errors
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.
App\Entity\Admin\Salario No errors.
App\Entity\Admin\Cliente No errors.
App\Entity\Admin\Proveedor No errors.
App\Entity\Admin\Area No errors.
App\Entity\Admin\Servicio No errors.
App\Entity\Comun\Tarea No errors.
App\Entity\Accesos\Tercero
  • The association App\Entity\Accesos\Tercero#usuario refers to the inverse side field App\Entity\Accesos\Usuario#terceros which does not exist.
App\Entity\Comun\Convenio No errors.
App\Entity\Comun\Gasto No errors.
App\Entity\Accion\ProyectoReunion No errors.
App\Entity\Accion\TemaReunion No errors.