Query Metrics
8
Database Queries
7
Different statements
3.91 ms
Query time
0
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
1.39 ms (35.54%) |
1 |
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:
[
3151880
]
|
0.75 ms (19.10%) |
1 |
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:
[
3151880
]
|
0.71 ms (18.12%) |
1 |
SELECT t0.id_equ AS id_equ_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.procesador AS procesador_7, t0.nucleos AS nucleos_8, t0.cpu_velocidad AS cpu_velocidad_9, t0.ram AS ram_10, t0.hhd AS hhd_11, t0.ssd AS ssd_12, t0.mac AS mac_13, t0.ip AS ip_14, t0.monitor_marbete AS monitor_marbete_15, t0.monitor_marca AS monitor_marca_16, t0.monitor_modelo AS monitor_modelo_17, t0.monitor_serie AS monitor_serie_18, t0.monitor_tipo AS monitor_tipo_19, t0.monitor_pulgadas AS monitor_pulgadas_20, t0.teclado_marca AS teclado_marca_21, t0.teclado_modelo AS teclado_modelo_22, t0.teclado_serie AS teclado_serie_23, t0.mouse_marca AS mouse_marca_24, t0.mouse_modelo AS mouse_modelo_25, t0.mouse_serie AS mouse_serie_26, t0.uso AS uso_27, t0.funcion AS funcion_28, t0.funcion_descripcion AS funcion_descripcion_29, t0.estatus AS estatus_30, t0.falta AS falta_31, t0.factualizacion AS factualizacion_32, t0.emhv AS emhv_33, t0.mantenimiento_count AS mantenimiento_count_34, t0.usuario AS usuario_35, t0.ubicacion AS ubicacion_36, t0.unidad AS unidad_37 FROM equipo t0 WHERE t0.id_equ = ? LIMIT 1
Parameters:
[
"6942"
]
|
0.55 ms (14.14%) |
2 |
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:
[
103
]
|
0.21 ms (5.40%) |
1 |
SELECT u0_.id_uni AS id_uni_0, u0_.nombre AS nombre_1, u0_.consecutivo AS consecutivo_2, u0_.activa AS activa_3 FROM unidad u0_ WHERE u0_.id_uni = ? ORDER BY u0_.nombre ASC
Parameters:
[
3151880
]
|
0.16 ms (4.19%) |
1 |
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:
[
144
]
|
0.14 ms (3.50%) |
1 |
SELECT t0.id_uni AS id_uni_1, t0.nombre AS nombre_2, t0.consecutivo AS consecutivo_3, t0.activa AS activa_4 FROM unidad t0 WHERE t0.id_uni = ?
Parameters:
[
3151880
]
|
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\Equipo | No errors. |
App\Entity\Ubicacion | No errors. |