Query Metrics
58
Database Queries
7
Different statements
21.69 ms
Query time
0
Invalid entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 0.65 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:
[
140
]
|
2 | 2.68 ms |
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:
[
3151900
]
|
3 | 10.08 ms |
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.unidad = ?
Parameters:
[
3151900
]
|
4 | 0.51 ms |
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:
[
3151900
]
|
5 | 0.27 ms |
SELECT e0_.id_equ AS id_equ_0, e0_.marbete AS marbete_1, e0_.descripcion AS descripcion_2, e0_.marca AS marca_3, e0_.modelo AS modelo_4, e0_.serie AS serie_5, e0_.procesador AS procesador_6, e0_.nucleos AS nucleos_7, e0_.cpu_velocidad AS cpu_velocidad_8, e0_.ram AS ram_9, e0_.hhd AS hhd_10, e0_.ssd AS ssd_11, e0_.mac AS mac_12, e0_.ip AS ip_13, e0_.monitor_marbete AS monitor_marbete_14, e0_.monitor_marca AS monitor_marca_15, e0_.monitor_modelo AS monitor_modelo_16, e0_.monitor_serie AS monitor_serie_17, e0_.monitor_tipo AS monitor_tipo_18, e0_.monitor_pulgadas AS monitor_pulgadas_19, e0_.teclado_marca AS teclado_marca_20, e0_.teclado_modelo AS teclado_modelo_21, e0_.teclado_serie AS teclado_serie_22, e0_.mouse_marca AS mouse_marca_23, e0_.mouse_modelo AS mouse_modelo_24, e0_.mouse_serie AS mouse_serie_25, e0_.uso AS uso_26, e0_.funcion AS funcion_27, e0_.funcion_descripcion AS funcion_descripcion_28, e0_.estatus AS estatus_29, e0_.falta AS falta_30, e0_.factualizacion AS factualizacion_31, e0_.emhv AS emhv_32, e0_.mantenimiento_count AS mantenimiento_count_33, e0_.usuario AS usuario_34, e0_.ubicacion AS ubicacion_35, e0_.unidad AS unidad_36 FROM equipo e0_ GROUP BY e0_.marca ORDER BY e0_.marca ASC
Parameters:
[] |
6 | 0.29 ms |
SELECT t0.id_rol AS id_rol_1, t0.nombre AS nombre_2 FROM role t0 WHERE t0.id_rol = ?
Parameters:
[
3
]
|
7 | 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:
[
87
]
|
8 | 0.18 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:
[
640
]
|
9 | 0.15 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:
[
85
]
|
10 | 0.12 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:
[
648
]
|
11 | 0.13 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:
[
245
]
|
12 | 0.12 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:
[
642
]
|
13 | 0.12 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:
[
649
]
|
14 | 0.12 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:
[
727
]
|
15 | 0.20 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:
[
1088
]
|
16 | 0.13 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:
[
653
]
|
17 | 0.12 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:
[
972
]
|
18 | 0.13 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:
[
244
]
|
19 | 0.12 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:
[
643
]
|
20 | 0.12 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:
[
231
]
|
21 | 0.12 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:
[
663
]
|
22 | 0.13 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:
[
664
]
|
23 | 0.13 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:
[
1156
]
|
24 | 0.16 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:
[
313
]
|
25 | 0.12 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:
[
646
]
|
26 | 0.13 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:
[
1089
]
|
27 | 0.13 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:
[
639
]
|
28 | 0.13 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:
[
248
]
|
29 | 0.12 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:
[
650
]
|
30 | 0.13 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:
[
226
]
|
31 | 0.13 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:
[
644
]
|
32 | 0.12 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:
[
265
]
|
33 | 0.12 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:
[
647
]
|
34 | 0.13 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:
[
241
]
|
35 | 0.13 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:
[
1529
]
|
36 | 0.14 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:
[
373
]
|
37 | 0.12 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:
[
641
]
|
38 | 0.14 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:
[
239
]
|
39 | 0.19 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:
[
238
]
|
40 | 0.13 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:
[
279
]
|
41 | 0.13 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:
[
276
]
|
42 | 0.14 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:
[
234
]
|
43 | 0.13 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:
[
892
]
|
44 | 0.15 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:
[
290
]
|
45 | 0.15 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:
[
208
]
|
46 | 0.14 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:
[
293
]
|
47 | 0.13 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:
[
645
]
|
48 | 0.13 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:
[
654
]
|
49 | 0.13 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:
[
230
]
|
50 | 0.14 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:
[
204
]
|
51 | 0.13 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:
[
247
]
|
52 | 0.13 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:
[
240
]
|
53 | 0.19 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:
[
246
]
|
54 | 0.13 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:
[
88
]
|
55 | 0.13 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:
[
655
]
|
56 | 0.15 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:
[
291
]
|
57 | 0.14 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:
[
652
]
|
58 | 0.14 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:
[
651
]
|
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. |