http://ti.conalepmex.edu.mx/sigmec/otro/1433/edit

Query Metrics

8 Database Queries
7 Different statements
2.07 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 0.31 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:
[
  229
]
2 0.49 ms
SELECT t0.id_otro AS id_otro_1, t0.marbete AS marbete_2, t0.descripcion AS descripcion_3, t0.marca AS marca_4, t0.modelo AS modelo_5, t0.serie AS serie_6, t0.uso AS uso_7, t0.mac AS mac_8, t0.ip AS ip_9, t0.estatus AS estatus_10, t0.falta AS falta_11, t0.factualizacion AS factualizacion_12, t0.mantenimiento_count AS mantenimiento_count_13, t0.ubicacion AS ubicacion_14, t0.usuario AS usuario_15, t0.unidad AS unidad_16 FROM otro t0 WHERE t0.id_otro = ? LIMIT 1
Parameters:
[
  "1433"
]
3 0.22 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:
[
  426
]
4 0.29 ms
SELECT t0.id_ubi AS id_ubi_1, t0.area AS area_2, t0.activo AS activo_3, t0.unidad AS unidad_4 FROM ubicacion t0 WHERE t0.id_ubi = ?
Parameters:
[
  1001
]
5 0.18 ms
SELECT t0.id_uni AS id_uni_1, t0.nombre AS nombre_2, t0.consecutivo AS consecutivo_3, t0.activa AS activa_4, t0.matricula AS matricula_5, t0.mat_ti AS mat_ti_6, t0.director AS director_7, t0.sexo AS sexo_8, t0.telefono AS telefono_9, t0.correo AS correo_10, t0.calle AS calle_11, t0.colonia AS colonia_12, t0.municipio AS municipio_13, t0.cp AS cp_14 FROM unidad t0 WHERE t0.id_uni = ?
Parameters:
[
  3151910
]
6 0.20 ms
SELECT u0_.id_usu AS id_usu_0, u0_.nombre AS nombre_1, u0_.papellido AS papellido_2, u0_.sapellido AS sapellido_3, u0_.correo AS correo_4, u0_.contrasena AS contrasena_5, u0_.estatus AS estatus_6, u0_.unidad AS unidad_7, u0_.rol AS rol_8 FROM usuario u0_ WHERE u0_.rol >= 3 AND u0_.estatus = 'Activo' AND u0_.unidad = ? ORDER BY u0_.nombre ASC
Parameters:
[
  3151910
]
7 0.18 ms
SELECT u0_.id_ubi AS id_ubi_0, u0_.area AS area_1, u0_.activo AS activo_2, u0_.unidad AS unidad_3 FROM ubicacion u0_ WHERE u0_.activo = 1 AND u0_.unidad = ? ORDER BY u0_.area ASC
Parameters:
[
  3151910
]
8 0.19 ms
SELECT u0_.id_uni AS id_uni_0, u0_.nombre AS nombre_1, u0_.consecutivo AS consecutivo_2, u0_.activa AS activa_3, u0_.matricula AS matricula_4, u0_.mat_ti AS mat_ti_5, u0_.director AS director_6, u0_.sexo AS sexo_7, u0_.telefono AS telefono_8, u0_.correo AS correo_9, u0_.calle AS calle_10, u0_.colonia AS colonia_11, u0_.municipio AS municipio_12, u0_.cp AS cp_13 FROM unidad u0_ WHERE u0_.id_uni = ? ORDER BY u0_.nombre ASC
Parameters:
[
  3151910
]

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\Otro No errors.
App\Entity\Ubicacion No errors.