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

Grouped Statements

Show all queries

Time Count Info
16.30 ms
(98.58%)
1
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:
[]
0.24 ms
(1.42%)
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:
[
  361
]

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.