Query Metrics
26
Database Queries
10
Different statements
4.97 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
2.52 ms (50.66%) |
17 |
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:
[
210
]
|
|
0.48 ms (9.65%) |
1 |
SELECT s0_.tipo_equipo AS tipo_equipo_0, s0_.id_equipo AS id_equipo_1, count(s0_.id_sol) AS sclr_2 FROM solicitud s0_ WHERE s0_.tipo_mantenimiento = ? AND YEAR(s0_.fatencion) = ? GROUP BY s0_.id_equipo, s0_.tipo_equipo
Parameters:
[ "MP" "2026" ] |
|
0.41 ms (8.30%) |
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.allinone AS allinone_35, t0.actualizable AS actualizable_36, t0.usuario AS usuario_37, t0.ubicacion AS ubicacion_38, t0.unidad AS unidad_39 FROM equipo t0 WHERE t0.unidad = ?
Parameters:
[
3150340
]
|
|
0.28 ms (5.53%) |
1 |
SELECT t0.id_sol AS id_sol_1, t0.tipo_equipo AS tipo_equipo_2, t0.id_equipo AS id_equipo_3, t0.periodo AS periodo_4, t0.tipo_mantenimiento AS tipo_mantenimiento_5, t0.falla AS falla_6, t0.srealizado AS srealizado_7, t0.fregistro AS fregistro_8, t0.fatencion AS fatencion_9, t0.ffin AS ffin_10, t0.fevaluacion AS fevaluacion_11, t0.refacciones AS refacciones_12, t0.estatus AS estatus_13, t0.usuario AS usuario_14, t0.ubicacion AS ubicacion_15, t0.gestor AS gestor_16, t0.unidad AS unidad_17 FROM solicitud t0 WHERE t0.unidad = ?
Parameters:
[
3150340
]
|
|
0.25 ms (5.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_.unidad = ? AND u0_.activo = ? ORDER BY u0_.area ASC
Parameters:
[ 3150340 1 ] |
|
0.25 ms (5.05%) |
1 |
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:
[
3150340
]
|
|
0.25 ms (5.04%) |
1 |
SELECT t0.id_red AS id_red_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.velocidad AS velocidad_7, t0.puertos AS puertos_8, t0.uso AS uso_9, t0.mac AS mac_10, t0.ip AS ip_11, t0.estatus AS estatus_12, t0.falta AS falta_13, t0.factualizacion AS factualizacion_14, t0.mantenimiento_count AS mantenimiento_count_15, t0.ubicacion AS ubicacion_16, t0.usuario AS usuario_17, t0.unidad AS unidad_18 FROM red t0 WHERE t0.unidad = ?
Parameters:
[
3150340
]
|
|
0.19 ms (3.84%) |
1 |
SELECT t0.id_imp AS id_imp_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.tipo AS tipo_7, t0.uso AS uso_8, t0.mac AS mac_9, t0.ip AS ip_10, t0.estatus AS estatus_11, t0.falta AS falta_12, t0.factualizacion AS factualizacion_13, t0.mantenimiento_count AS mantenimiento_count_14, t0.ubicacion AS ubicacion_15, t0.usuario AS usuario_16, t0.unidad AS unidad_17 FROM impresora t0 WHERE t0.unidad = ?
Parameters:
[
3150340
]
|
|
0.18 ms (3.64%) |
1 |
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.unidad = ?
Parameters:
[
3150340
]
|
|
0.16 ms (3.18%) |
1 |
SELECT t0.id_rol AS id_rol_1, t0.nombre AS nombre_2 FROM role t0 WHERE t0.id_rol = ?
Parameters:
[
3
]
|
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. |
| App\Entity\Red | No errors. |
| App\Entity\Impresora | No errors. |
| App\Entity\Otro | No errors. |
| App\Entity\Solicitud | No errors. |