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

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
3.47 ms
(94.51%)
1
SELECT s.estatus, count(s.estatus) as solicitudCont FROM solicitud s WHERE
                    s.unidad = '3152220'
                    AND
                    (
                        (
                            s.tipo_mantenimiento IN ('MC', 'ST')
                            AND (
                                YEAR(s.fregistro) = YEAR(NOW())
                                OR 
                                (YEAR(s.fregistro) <> YEAR(NOW()) AND s.estatus <> 4)
                            )
                        ) 
                        OR
                        (
                            s.tipo_mantenimiento = 'MP'
                            AND YEAR(s.fatencion) = YEAR(NOW()) 
                        )
                    ) GROUP BY s.estatus
Parameters:
[]
0.20 ms
(5.49%)
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.