Query Metrics
6
Database Queries
5
Different statements
3.84 ms
Query time
0
Invalid entities
Queries
#▲ | 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. |