Query Metrics
21
Database Queries
17
Different statements
64.88 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
37.64 ms (58.01%) |
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.id_equipo = ? AND t0.estatus IN (?, ?, ?) AND t0.tipo_equipo = ?
Parameters:
[ 5311 1 2 3 "Equipo" ] |
|
17.36 ms (26.76%) |
1 |
SELECT t0.id_equ AS id_equ_1, t0.marbete AS marbete_2, t0.descripcion AS descripcion_3, t0.modelo AS modelo_4, t0.serie AS serie_5, t0.procesador AS procesador_6, t0.nucleos AS nucleos_7, t0.cpu_velocidad AS cpu_velocidad_8, t0.ram AS ram_9, t0.hhd AS hhd_10, t0.ssd AS ssd_11, t0.mac AS mac_12, t0.ip AS ip_13, t0.monitor_marbete AS monitor_marbete_14, t0.monitor_modelo AS monitor_modelo_15, t0.monitor_serie AS monitor_serie_16, t0.monitor_tipo AS monitor_tipo_17, t0.monitor_pulgadas AS monitor_pulgadas_18, t0.teclado_modelo AS teclado_modelo_19, t0.teclado_serie AS teclado_serie_20, t0.mouse_modelo AS mouse_modelo_21, t0.mouse_serie AS mouse_serie_22, t0.uso AS uso_23, t0.funcion AS funcion_24, t0.funcion_descripcion AS funcion_descripcion_25, t0.estatus AS estatus_26, t0.falta AS falta_27, t0.factualizacion AS factualizacion_28, t0.emhv AS emhv_29, t0.mantenimiento_count AS mantenimiento_count_30, t0.allinone AS allinone_31, t0.color AS color_32, t0.piso AS piso_33, t0.seccion_aula AS seccion_aula_34, t0.num_puerta_cubi AS num_puerta_cubi_35, t0.usuario AS usuario_36, t0.ubicacion AS ubicacion_37, t0.unidad AS unidad_38, t0.id_material AS id_material_39, t0.id_uso AS id_uso_40, t0.id_marca AS id_marca_41, t0.monitor_marca AS monitor_marca_42, t0.teclado_marca AS teclado_marca_43, t0.mouse_marca AS mouse_marca_44 FROM equipo t0 WHERE t0.marbete = ? LIMIT 2
Parameters:
[
"2383001728"
]
|
|
2.44 ms (3.76%) |
1 |
"COMMIT"
Parameters:
[] |
|
1.12 ms (1.72%) |
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:
[
480
]
|
|
1.06 ms (1.63%) |
4 |
SELECT c0_.id_marca AS id_marca_0, c0_.marca AS marca_1 FROM c_marcas c0_ WHERE c0_.id_marca IN (?) ORDER BY c0_.id_marca ASC
Parameters:
[
"194"
]
|
|
0.86 ms (1.33%) |
1 |
UPDATE equipo SET factualizacion = ?, color = ?, seccion_aula = ?, num_puerta_cubi = ?, usuario = ?, id_material = ?, id_uso = ? WHERE id_equ = ?
Parameters:
[ "2026-03-25 11:29:46" "NEGRO" "G" "1" 720 27 1 5311 ] |
|
0.76 ms (1.17%) |
1 |
SELECT t0.id_equ AS id_equ_1, t0.marbete AS marbete_2, t0.descripcion AS descripcion_3, t0.modelo AS modelo_4, t0.serie AS serie_5, t0.procesador AS procesador_6, t0.nucleos AS nucleos_7, t0.cpu_velocidad AS cpu_velocidad_8, t0.ram AS ram_9, t0.hhd AS hhd_10, t0.ssd AS ssd_11, t0.mac AS mac_12, t0.ip AS ip_13, t0.monitor_marbete AS monitor_marbete_14, t0.monitor_modelo AS monitor_modelo_15, t0.monitor_serie AS monitor_serie_16, t0.monitor_tipo AS monitor_tipo_17, t0.monitor_pulgadas AS monitor_pulgadas_18, t0.teclado_modelo AS teclado_modelo_19, t0.teclado_serie AS teclado_serie_20, t0.mouse_modelo AS mouse_modelo_21, t0.mouse_serie AS mouse_serie_22, t0.uso AS uso_23, t0.funcion AS funcion_24, t0.funcion_descripcion AS funcion_descripcion_25, t0.estatus AS estatus_26, t0.falta AS falta_27, t0.factualizacion AS factualizacion_28, t0.emhv AS emhv_29, t0.mantenimiento_count AS mantenimiento_count_30, t0.allinone AS allinone_31, t0.color AS color_32, t0.piso AS piso_33, t0.seccion_aula AS seccion_aula_34, t0.num_puerta_cubi AS num_puerta_cubi_35, t0.usuario AS usuario_36, t0.ubicacion AS ubicacion_37, t0.unidad AS unidad_38, t0.id_material AS id_material_39, t0.id_uso AS id_uso_40, t0.id_marca AS id_marca_41, t0.monitor_marca AS monitor_marca_42, t0.teclado_marca AS teclado_marca_43, t0.mouse_marca AS mouse_marca_44 FROM equipo t0 WHERE t0.id_equ = ? LIMIT 1
Parameters:
[
"5311"
]
|
|
0.67 ms (1.03%) |
1 |
UPDATE solicitud SET usuario = ? WHERE id_sol = ?
Parameters:
[ 720 "262380966" ] |
|
0.47 ms (0.72%) |
1 |
SELECT t0.id_marca AS id_marca_1, t0.marca AS marca_2 FROM c_marcas t0 WHERE t0.id_marca = ?
Parameters:
[
194
]
|
|
0.40 ms (0.62%) |
1 |
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 = ? AND u0_.id_uni IN (?) ORDER BY u0_.nombre ASC
Parameters:
[ 3152380 "3152380" ] |
|
0.36 ms (0.56%) |
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:
[
3152380
]
|
|
0.33 ms (0.50%) |
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 = ? AND u0_.id_ubi IN (?) ORDER BY u0_.area ASC
Parameters:
[ 3152380 "670" ] |
|
0.32 ms (0.49%) |
1 |
"START TRANSACTION"
Parameters:
[] |
|
0.30 ms (0.46%) |
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 = ? AND u0_.id_usu IN (?) ORDER BY u0_.nombre ASC
Parameters:
[ 3152380 "720" ] |
|
0.29 ms (0.44%) |
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:
[
670
]
|
|
0.26 ms (0.40%) |
1 |
SELECT c0_.id_material AS id_material_0, c0_.material AS material_1 FROM c_material c0_ WHERE c0_.id_material IN (?) ORDER BY c0_.material ASC
Parameters:
[
"27"
]
|
|
0.24 ms (0.38%) |
1 |
SELECT c0_.id_uso AS id_uso_0, c0_.estatus_uso AS estatus_uso_1 FROM c_estado_uso c0_ WHERE c0_.id_uso IN (?) ORDER BY c0_.estatus_uso ASC
Parameters:
[
"1"
]
|
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\CMaterial | No errors. |
| App\Entity\CEstadoUso | No errors. |
| App\Entity\CMarcas | No errors. |
| App\Entity\Solicitud | No errors. |