http://ti.conalepmex.edu.mx/sigmec/equipo/5311/edit Return to referer URL

Query Metrics

21 Database Queries
17 Different statements
64.88 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

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.