https://daiteke.aplicaciones.debamatika.com/comun/fichaje/comprobarHoras/7/2024-05-06/14:05

Query Metrics

6 Database Queries
5 Different statements
3.84 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 1.01 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.is_verified AS is_verified_5, t0.nombre AS nombre_6, t0.habilitado AS habilitado_7, t0.empleada_id AS empleada_id_8, t0.contacto_id AS contacto_id_9, t0.contacto_proveedor_id AS contacto_proveedor_id_10 FROM usuario t0 WHERE t0.id = ?
Parameters:
[
  18
]
2 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:
[
  7
  "2024-05-06%"
]
3 0.50 ms
SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = ? AND f0_.fecha LIKE ? AND f0_.fecha > ? ORDER BY f0_.fecha ASC LIMIT 1
Parameters:
[
  7
  "2024-05-06%"
  "2024-05-06 09:25:07"
]
4 0.47 ms
SELECT f0_.id AS id_0, f0_.fecha AS fecha_1, f0_.entrada AS entrada_2, f0_.empleada_id AS empleada_id_3 FROM fichaje_diario f0_ WHERE f0_.empleada_id = ? AND f0_.fecha LIKE ? AND f0_.fecha > ? ORDER BY f0_.fecha ASC LIMIT 1
Parameters:
[
  7
  "2024-05-06%"
  "2024-05-06 14:27:40"
]
5 0.42 ms
SELECT f0_.id AS id_0, f0_.cantidad_horas AS cantidad_horas_1, f0_.observaciones AS observaciones_2, f0_.fecha AS fecha_3, f0_.proyecto_id AS proyecto_id_4, f0_.tarea_id AS tarea_id_5, f0_.empleada_id AS empleada_id_6 FROM fichaje f0_ WHERE f0_.empleada_id = ? AND f0_.fecha LIKE ? ORDER BY f0_.fecha ASC
Parameters:
[
  7
  "2024-05-06%"
]
6 0.46 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 WHERE t0.id = ?
Parameters:
[
  7
]

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\Accesos\Usuario No errors.
App\Entity\Admin\Empleada No errors.
App\Entity\Admin\Contacto No errors.
App\Entity\Admin\ContactoProveedor No errors.
App\Entity\Comun\Fichaje No errors.
App\Entity\Comun\FichajeDiario No errors.
App\Entity\Comun\Proyecto No errors.
App\Entity\Comun\Tarea No errors.
App\Entity\Admin\RangoSalarial No errors.
App\Entity\Comun\TareaEmpleada 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.