Query Metrics
2
Database Queries
2
Different statements
10.91 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
10.72 ms (98.28%) |
1 |
SELECT s.estatus, count(s.estatus) as solicitudCont FROM solicitud s WHERE (s.unidad = 3150820 AND s.tipo_mantenimiento IN ('MC', 'ST') AND s.fregistro >= concat(year(now()),'-01-01')) OR (s.unidad = 3150820 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:
[] |
|
0.19 ms (1.72%) |
1 |
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:
[
75
]
|
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. |