http://ti.conalepmex.edu.mx/sigmec/solicitud/vista/contador Return to referer URL

Query Metrics

2 Database Queries
2 Different statements
16.54 ms Query time
0 Invalid entities

Queries

Group similar statements

# 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.