Query Metrics
23
Database Queries
20
Different statements
84.61 ms
Query time
0
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
26.42 ms (31.22%) |
2 |
"COMMIT"
Parameters:
[] |
20.04 ms (23.68%) |
1 |
SELECT NEXTVAL('seg_usuario_id_seq')
Parameters:
[] |
7.49 ms (8.85%) |
1 |
SELECT quote_ident(table_name) AS table_name, table_schema AS schema_name FROM information_schema.tables WHERE table_catalog = ? AND table_schema NOT LIKE 'pg\_%' AND table_schema != 'information_schema' AND table_name != 'geometry_columns' AND table_name != 'spatial_ref_sys' AND table_type = 'BASE TABLE'
Parameters:
[
"integral_produccion"
]
|
4.31 ms (5.09%) |
1 |
SELECT t0.id AS id_1, t0.username AS username_2, t0.nombres AS nombres_3, t0.apellidos AS apellidos_4, t0.telefono AS telefono_5, t0.celular AS celular_6, t0.email AS email_7, t0.direccion AS direccion_8, t0.fecha_registro AS fecha_registro_9, t0.fecha_vigencia_password AS fecha_vigencia_password_10, t0.causa_bloqueo AS causa_bloqueo_11, t0.password AS password_12, t0.eliminado AS eliminado_13, t0.fecha_eliminacion AS fecha_eliminacion_14, t0.intentos_fallidos AS intentos_fallidos_15, t0.primer_ingreso AS primer_ingreso_16, t0.activo AS activo_17, t0.conectado AS conectado_18, t0.fecha_acceso AS fecha_acceso_19, t0.cargo AS cargo_20, t0.grado AS grado_21, t0.foto AS foto_22, t0.base AS base_23, t0.centro AS centro_24, t0.unidad AS unidad_25, t0.centro_instruccion AS centro_instruccion_26 FROM seg_usuario t0 WHERE t0.id = ?
Parameters:
[
429
]
|
3.61 ms (4.27%) |
1 |
INSERT INTO seg_usuario (id, username, nombres, apellidos, telefono, celular, email, direccion, fecha_registro, fecha_vigencia_password, causa_bloqueo, password, eliminado, fecha_eliminacion, intentos_fallidos, primer_ingreso, activo, conectado, fecha_acceso, cargo, grado, foto, base, centro, unidad, centro_instruccion) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ 23287 "0925352825" "PAOLA EUGENIA" "VARGAS ASTUDILLO" null "0996264134" "negraboina@hotmail.com" null "2024-09-23 13:20:21" null null null 0 null 0 1 0 null null 3 7 null 8 33 null null ] |
2.30 ms (2.72%) |
1 |
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.sistema AS sistema_3, t0.descripcion AS descripcion_4, t0.asignable AS asignable_5 FROM seg_rol t0 INNER JOIN seg_usuario_rol ON t0.id = seg_usuario_rol.rol WHERE seg_usuario_rol.usuario = ?
Parameters:
[
429
]
|
2.28 ms (2.69%) |
2 |
SELECT CURRENT_DATABASE()
Parameters:
[] |
1.97 ms (2.33%) |
1 |
SELECT NEXTVAL('seg_codigos_activacion_id_seq')
Parameters:
[] |
1.83 ms (2.17%) |
1 |
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.sistema AS sistema_3, t0.descripcion AS descripcion_4, t0.asignable AS asignable_5 FROM seg_rol t0 WHERE t0.nombre = ? LIMIT 1
Parameters:
[
"ROLE_COORDINADOR_CENTRO"
]
|
1.73 ms (2.05%) |
1 |
SELECT schema_name FROM information_schema.schemata WHERE schema_name NOT LIKE 'pg\_%' AND schema_name != 'information_schema'
Parameters:
[] |
1.47 ms (1.73%) |
1 |
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.codigo_activacion AS codigo_activacion_3, t0.vigencia_codigo AS vigencia_codigo_4, t0.default_contrasena AS default_contrasena_5, t0.vigencia_contrasena AS vigencia_contrasena_6, t0.contrasenas_viejas AS contrasenas_viejas_7, t0.accesos_fallidos AS accesos_fallidos_8, t0.fortaleza_contrasena AS fortaleza_contrasena_9 FROM seg_configuracion t0 WHERE t0.nombre = ? LIMIT 1
Parameters:
[
"DEFAULT"
]
|
1.45 ms (1.72%) |
2 |
"START TRANSACTION"
Parameters:
[] |
1.43 ms (1.69%) |
1 |
INSERT INTO seg_usuario_rol (usuario, rol) VALUES (?, ?)
Parameters:
[ 23287 2 ] |
1.35 ms (1.59%) |
1 |
SELECT t0.id AS id_1, t0.username AS username_2, t0.nombres AS nombres_3, t0.apellidos AS apellidos_4, t0.telefono AS telefono_5, t0.celular AS celular_6, t0.email AS email_7, t0.direccion AS direccion_8, t0.fecha_registro AS fecha_registro_9, t0.fecha_vigencia_password AS fecha_vigencia_password_10, t0.causa_bloqueo AS causa_bloqueo_11, t0.password AS password_12, t0.eliminado AS eliminado_13, t0.fecha_eliminacion AS fecha_eliminacion_14, t0.intentos_fallidos AS intentos_fallidos_15, t0.primer_ingreso AS primer_ingreso_16, t0.activo AS activo_17, t0.conectado AS conectado_18, t0.fecha_acceso AS fecha_acceso_19, t0.cargo AS cargo_20, t0.grado AS grado_21, t0.foto AS foto_22, t0.base AS base_23, t0.centro AS centro_24, t0.unidad AS unidad_25, t0.centro_instruccion AS centro_instruccion_26 FROM seg_usuario t0 WHERE t0.username = ? LIMIT 1
Parameters:
[
"0925352825"
]
|
1.31 ms (1.55%) |
1 |
SELECT n0_.id AS id_0, n0_.nombre AS nombre_1 FROM nmcl_cargo n0_ WHERE n0_.id IN (?)
Parameters:
[
"3"
]
|
1.30 ms (1.53%) |
1 |
INSERT INTO seg_codigos_activacion (id, codigo, fecha_envio, fecha_vigencia, fecha_uso, usuario) VALUES (?, ?, ?, ?, ?, ?)
Parameters:
[ 27090 "9688fd46dbc6a769bcafb65bb07b4cb6" "2024-09-23 13:20:21" null null 23287 ] |
1.28 ms (1.51%) |
1 |
SELECT b0_.id AS id_0, b0_.nombre AS nombre_1, b0_.direccion AS direccion_2, b0_.geometria AS geometria_3, b0_.activo AS activo_4, b0_.localizacion AS localizacion_5, b0_.jefe AS jefe_6 FROM base_movilizacion b0_ WHERE b0_.id IN (?)
Parameters:
[
"8"
]
|
1.20 ms (1.42%) |
1 |
SELECT n0_.id AS id_0, n0_.nombre AS nombre_1, n0_.id_dir_mov AS id_dir_mov_2 FROM nmcl_grado n0_ WHERE n0_.id IN (?)
Parameters:
[
"7"
]
|
1.17 ms (1.38%) |
1 |
SELECT c0_.id AS id_0, c0_.nombre AS nombre_1, c0_.direccion AS direccion_2, c0_.geometria AS geometria_3, c0_.direccion_acuartelamiento AS direccion_acuartelamiento_4, c0_.activo AS activo_5, c0_.localizacion AS localizacion_6, c0_.jefe AS jefe_7 FROM centro_movilizacion c0_ WHERE c0_.id IN (?)
Parameters:
[
"33"
]
|
0.67 ms (0.80%) |
1 |
SHOW search_path
Parameters:
[] |
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\SeguridadUsuario | No errors. |
App\Entity\NmclCargo | No errors. |
App\Entity\NmclGrado | No errors. |
App\Entity\Adjunto | No errors. |
App\Entity\BaseMovilizacion | No errors. |
App\Entity\CentroMovilizacion | No errors. |
App\Entity\UnidadMilitar | No errors. |
App\Entity\CentroInstruccion | No errors. |
App\Entity\SeguridadRol | No errors. |
App\Entity\Notificacion | No errors. |
App\Entity\NmclDominioLocalizacion | No errors. |
App\Entity\NmclNivelLocalizacion | No errors. |
App\Entity\NmclLocalizacion | No errors. |
App\Entity\SeguridadConfiguracion | No errors. |
App\Entity\SeguridadFortalezaContrasena | No errors. |
App\Entity\SeguridadCodigoActivacion | No errors. |