Query Metrics
2
Database Queries
2
Different statements
16.54 ms
Query time
0
Invalid entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 0.24 ms |
SELECT t0.id_usu AS id_usu_1, t0.nombre AS nombre_2, t0.papellido AS papellido_3, t0.sapellido AS sapellido_4, t0.correo AS correo_5, t0.contrasena AS contrasena_6, t0.estatus AS estatus_7, t0.unidad AS unidad_8, t0.rol AS rol_9 FROM usuario t0 WHERE t0.id_usu = ?
Parameters:
[
361
]
|
2 | 16.30 ms |
SELECT s.estatus, count(s.estatus) as solicitudCont FROM solicitud s WHERE (s.unidad = 3152220 AND s.tipo_mantenimiento IN ('MC', 'ST') AND s.fregistro >= concat(year(now()),'-01-01')) OR (s.unidad = 3152220 AND s.tipo_mantenimiento = 'MP'|'MC'|'ST' AND s.fatencion BETWEEN concat(year(now()),'-01-01') AND date_add(current_date(), INTERVAL 30 DAY))GROUP BY s.estatus
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\Usuario | No errors. |
App\Entity\Unidad | No errors. |
App\Entity\Role | No errors. |
App\Entity\Solicitud | No errors. |