Symfony Profiler

Query Metrics

10 Database Queries

10 Different statements

5.73 ms Query time

1 Invalid entities

2 Managed entities

Grouped Statements

Show all queries

default connection

Time▼	Count	Info
1.37 ms (23.93%)	1	"COMMIT" Parameters: [] View formatted query View runnable query Explain query "COMMIT" "COMMIT";
0.70 ms (12.16%)	1	ALTER SESSION SET NLS_TIME_FORMAT = 'HH24:MI:SS' NLS_DATE_FORMAT = 'YYYY-MM-DD HH24:MI:SS' NLS_TIMESTAMP_FORMAT = 'YYYY-MM-DD HH24:MI:SS' NLS_TIMESTAMP_TZ_FORMAT = 'YYYY-MM-DD HH24:MI:SS TZH:TZM' NLS_NUMERIC_CHARACTERS = '.,' Parameters: [] View formatted query View runnable query Explain query ALTER SESSION SET NLS_TIME_FORMAT = 'HH24:MI:SS' NLS_DATE_FORMAT = 'YYYY-MM-DD HH24:MI:SS' NLS_TIMESTAMP_FORMAT = 'YYYY-MM-DD HH24:MI:SS' NLS_TIMESTAMP_TZ_FORMAT = 'YYYY-MM-DD HH24:MI:SS TZH:TZM' NLS_NUMERIC_CHARACTERS = '.,' ALTER SESSION SET NLS_TIME_FORMAT = 'HH24:MI:SS' NLS_DATE_FORMAT = 'YYYY-MM-DD HH24:MI:SS' NLS_TIMESTAMP_FORMAT = 'YYYY-MM-DD HH24:MI:SS' NLS_TIMESTAMP_TZ_FORMAT = 'YYYY-MM-DD HH24:MI:SS TZH:TZM' NLS_NUMERIC_CHARACTERS = '.,';
0.65 ms (11.32%)	1	SELECT t0.id AS ID_1, t0.nombre AS NOMBRE_2, t0.descripcion AS DESCRIPCION_3, t0.roles AS ROLES_4 FROM grupo t0 INNER JOIN user_grupo ON t0.id = user_grupo.grupo_id WHERE user_grupo.user_id = ? Parameters: [`12623`] View formatted query View runnable query Explain query SELECT t0.id AS ID_1, t0.nombre AS NOMBRE_2, t0.descripcion AS DESCRIPCION_3, t0.roles AS ROLES_4 FROM grupo t0 INNER JOIN user_grupo ON t0.id = user_grupo.grupo_id WHERE user_grupo.user_id = ? SELECT t0.id AS ID_1, t0.nombre AS NOMBRE_2, t0.descripcion AS DESCRIPCION_3, t0.roles AS ROLES_4 FROM grupo t0 INNER JOIN user_grupo ON t0.id = user_grupo.grupo_id WHERE user_grupo.user_id = 12623;
0.63 ms (11.04%)	1	INSERT INTO bitacora (id, entidad, fecha_movimiento, cambio, accion, observaciones, usuario, ip, entidad_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?) Parameters: [`383062 "App\Entity\Main\User" "2026-04-01 19:31:29" "{"ultimaConexion":{"anterior":"2026-03-22 08:13:56","actual":"2026-04-01 07:31:29"}}" "ACTUALIZACIÓN" null 12623 "201.113.145.210" 12623`] View formatted query View runnable query Explain query INSERT INTO bitacora ( id, entidad, fecha_movimiento, cambio, accion, observaciones, usuario, ip, entidad_id ) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?) INSERT INTO bitacora (id, entidad, fecha_movimiento, cambio, accion, observaciones, usuario, ip, entidad_id) VALUES (383062, 'App\\Entity\\Main\\User', '2026-04-01 19:31:29', '{\"ultimaConexion\":{\"anterior\":\"2026-03-22 08:13:56\",\"actual\":\"2026-04-01 07:31:29\"}}', 'ACTUALIZACIÓN', NULL, 12623, '201.113.145.210', 12623);
0.60 ms (10.39%)	1	SELECT t0_.id AS ID_0, t0_.email AS EMAIL_1, t0_.nombre AS NOMBRE_2, t0_.apellidos AS APELLIDOS_3, t0_.telefono AS TELEFONO_4, t0_.permisos AS PERMISOS_5, t0_.fecha_creacion AS FECHA_CREACION_6, t0_.usuario_creo AS USUARIO_CREO_7, t0_.fecha_actualizacion AS FECHA_ACTUALIZACION_8, t0_.usuario_actualizo AS USUARIO_ACTUALIZO_9, t0_.ultima_conexion AS ULTIMA_CONEXION_10, t0_.google_id AS GOOGLE_ID_11, t0_.llave_mx_id AS LLAVE_MX_ID_12, t0_.UNIDAD_RESPONSABLE_ID AS UNIDAD_RESPONSABLE_ID_13, t0_.matricula AS MATRICULA_14, t0_.curp AS CURP_15, t0_.numero_empleado AS NUMERO_EMPLEADO_16 FROM "user" t0_ WHERE t0_.email = ? OR t0_.google_id = ? Parameters: [`"18448113@uagro.mx" "117056416245653224665"`] View formatted query View runnable query Explain query SELECT t0_.id AS ID_0, t0_.email AS EMAIL_1, t0_.nombre AS NOMBRE_2, t0_.apellidos AS APELLIDOS_3, t0_.telefono AS TELEFONO_4, t0_.permisos AS PERMISOS_5, t0_.fecha_creacion AS FECHA_CREACION_6, t0_.usuario_creo AS USUARIO_CREO_7, t0_.fecha_actualizacion AS FECHA_ACTUALIZACION_8, t0_.usuario_actualizo AS USUARIO_ACTUALIZO_9, t0_.ultima_conexion AS ULTIMA_CONEXION_10, t0_.google_id AS GOOGLE_ID_11, t0_.llave_mx_id AS LLAVE_MX_ID_12, t0_.UNIDAD_RESPONSABLE_ID AS UNIDAD_RESPONSABLE_ID_13, t0_.matricula AS MATRICULA_14, t0_.curp AS CURP_15, t0_.numero_empleado AS NUMERO_EMPLEADO_16 FROM "user" t0_ WHERE t0_.email = ? OR t0_.google_id = ? SELECT t0_.id AS ID_0, t0_.email AS EMAIL_1, t0_.nombre AS NOMBRE_2, t0_.apellidos AS APELLIDOS_3, t0_.telefono AS TELEFONO_4, t0_.permisos AS PERMISOS_5, t0_.fecha_creacion AS FECHA_CREACION_6, t0_.usuario_creo AS USUARIO_CREO_7, t0_.fecha_actualizacion AS FECHA_ACTUALIZACION_8, t0_.usuario_actualizo AS USUARIO_ACTUALIZO_9, t0_.ultima_conexion AS ULTIMA_CONEXION_10, t0_.google_id AS GOOGLE_ID_11, t0_.llave_mx_id AS LLAVE_MX_ID_12, t0_.UNIDAD_RESPONSABLE_ID AS UNIDAD_RESPONSABLE_ID_13, t0_.matricula AS MATRICULA_14, t0_.curp AS CURP_15, t0_.numero_empleado AS NUMERO_EMPLEADO_16 FROM "user" t0_ WHERE t0_.email = '18448113@uagro.mx' OR t0_.google_id = '117056416245653224665';
0.45 ms (7.86%)	1	SELECT bitacora_id_seq.nextval FROM DUAL Parameters: [] View formatted query View runnable query Explain query SELECT bitacora_id_seq.nextval FROM DUAL SELECT bitacora_id_seq.nextval FROM DUAL;
0.37 ms (6.40%)	1	UPDATE "user" SET ultima_conexion = ? WHERE id = ? Parameters: [`"2026-04-01 19:31:29" 12623`] View formatted query View runnable query Explain query UPDATE "user" SET ultima_conexion = ? WHERE id = ? UPDATE "user" SET ultima_conexion = '2026-04-01 19:31:29' WHERE id = 12623;
0.04 ms (0.77%)	1	"START TRANSACTION" Parameters: [] View formatted query View runnable query Explain query "START TRANSACTION" "START TRANSACTION";

db19c connection

Time▼	Count	Info
0.48 ms (8.41%)	1	ALTER SESSION SET NLS_TIME_FORMAT = 'HH24:MI:SS' NLS_DATE_FORMAT = 'YYYY-MM-DD HH24:MI:SS' NLS_TIMESTAMP_FORMAT = 'YYYY-MM-DD HH24:MI:SS' NLS_TIMESTAMP_TZ_FORMAT = 'YYYY-MM-DD HH24:MI:SS TZH:TZM' NLS_NUMERIC_CHARACTERS = '.,' Parameters: [] View formatted query View runnable query Explain query ALTER SESSION SET NLS_TIME_FORMAT = 'HH24:MI:SS' NLS_DATE_FORMAT = 'YYYY-MM-DD HH24:MI:SS' NLS_TIMESTAMP_FORMAT = 'YYYY-MM-DD HH24:MI:SS' NLS_TIMESTAMP_TZ_FORMAT = 'YYYY-MM-DD HH24:MI:SS TZH:TZM' NLS_NUMERIC_CHARACTERS = '.,' ALTER SESSION SET NLS_TIME_FORMAT = 'HH24:MI:SS' NLS_DATE_FORMAT = 'YYYY-MM-DD HH24:MI:SS' NLS_TIMESTAMP_FORMAT = 'YYYY-MM-DD HH24:MI:SS' NLS_TIMESTAMP_TZ_FORMAT = 'YYYY-MM-DD HH24:MI:SS TZH:TZM' NLS_NUMERIC_CHARACTERS = '.,';
0.44 ms (7.71%)	1	SELECT t0.id AS ID_1, t0.usuario_id AS USUARIO_ID_2, t0.documento_id AS DOCUMENTO_ID_3, t0.tipo_documento_id AS TIPO_DOCUMENTO_ID_4, t0.estado AS ESTADO_5, t0.archivo AS ARCHIVO_6, t0.nombre_archivo AS NOMBRE_ARCHIVO_7, t0.fecha_subida AS FECHA_SUBIDA_8, t0.usuario_creo AS USUARIO_CREO_9, t0.observaciones AS OBSERVACIONES_10, t0.curp AS CURP_11, t0.reemplazo_rechazado AS REEMPLAZO_RECHAZADO_12, t0.fecha_observacion AS FECHA_OBSERVACION_13 FROM admcredencial.expediente_usuario t0 WHERE t0.curp = ? AND t0.usuario_id IS NULL Parameters: [`"JAEG000901MGRCSRB8"`] View formatted query View runnable query Explain query SELECT t0.id AS ID_1, t0.usuario_id AS USUARIO_ID_2, t0.documento_id AS DOCUMENTO_ID_3, t0.tipo_documento_id AS TIPO_DOCUMENTO_ID_4, t0.estado AS ESTADO_5, t0.archivo AS ARCHIVO_6, t0.nombre_archivo AS NOMBRE_ARCHIVO_7, t0.fecha_subida AS FECHA_SUBIDA_8, t0.usuario_creo AS USUARIO_CREO_9, t0.observaciones AS OBSERVACIONES_10, t0.curp AS CURP_11, t0.reemplazo_rechazado AS REEMPLAZO_RECHAZADO_12, t0.fecha_observacion AS FECHA_OBSERVACION_13 FROM admcredencial.expediente_usuario t0 WHERE t0.curp = ? AND t0.usuario_id IS NULL SELECT t0.id AS ID_1, t0.usuario_id AS USUARIO_ID_2, t0.documento_id AS DOCUMENTO_ID_3, t0.tipo_documento_id AS TIPO_DOCUMENTO_ID_4, t0.estado AS ESTADO_5, t0.archivo AS ARCHIVO_6, t0.nombre_archivo AS NOMBRE_ARCHIVO_7, t0.fecha_subida AS FECHA_SUBIDA_8, t0.usuario_creo AS USUARIO_CREO_9, t0.observaciones AS OBSERVACIONES_10, t0.curp AS CURP_11, t0.reemplazo_rechazado AS REEMPLAZO_RECHAZADO_12, t0.fecha_observacion AS FECHA_OBSERVACION_13 FROM admcredencial.expediente_usuario t0 WHERE t0.curp = 'JAEG000901MGRCSRB8' AND t0.usuario_id IS NULL;

Time▼

Count

Info

0.48 ms
(8.41%)

ALTER SESSION SET NLS_TIME_FORMAT = 'HH24:MI:SS' NLS_DATE_FORMAT = 'YYYY-MM-DD HH24:MI:SS' NLS_TIMESTAMP_FORMAT = 'YYYY-MM-DD HH24:MI:SS' NLS_TIMESTAMP_TZ_FORMAT = 'YYYY-MM-DD HH24:MI:SS TZH:TZM' NLS_NUMERIC_CHARACTERS = '.,'

Parameters:

[]

View formatted query View runnable query Explain query

ALTER SESSION
SET
  NLS_TIME_FORMAT = 'HH24:MI:SS' NLS_DATE_FORMAT = 'YYYY-MM-DD HH24:MI:SS' NLS_TIMESTAMP_FORMAT = 'YYYY-MM-DD HH24:MI:SS' NLS_TIMESTAMP_TZ_FORMAT = 'YYYY-MM-DD HH24:MI:SS TZH:TZM' NLS_NUMERIC_CHARACTERS = '.,'

ALTER SESSION SET NLS_TIME_FORMAT = 'HH24:MI:SS' NLS_DATE_FORMAT = 'YYYY-MM-DD HH24:MI:SS' NLS_TIMESTAMP_FORMAT = 'YYYY-MM-DD HH24:MI:SS' NLS_TIMESTAMP_TZ_FORMAT = 'YYYY-MM-DD HH24:MI:SS TZH:TZM' NLS_NUMERIC_CHARACTERS = '.,';

0.44 ms
(7.71%)

SELECT t0.id AS ID_1, t0.usuario_id AS USUARIO_ID_2, t0.documento_id AS DOCUMENTO_ID_3, t0.tipo_documento_id AS TIPO_DOCUMENTO_ID_4, t0.estado AS ESTADO_5, t0.archivo AS ARCHIVO_6, t0.nombre_archivo AS NOMBRE_ARCHIVO_7, t0.fecha_subida AS FECHA_SUBIDA_8, t0.usuario_creo AS USUARIO_CREO_9, t0.observaciones AS OBSERVACIONES_10, t0.curp AS CURP_11, t0.reemplazo_rechazado AS REEMPLAZO_RECHAZADO_12, t0.fecha_observacion AS FECHA_OBSERVACION_13 FROM admcredencial.expediente_usuario t0 WHERE t0.curp = ? AND t0.usuario_id IS NULL

Parameters:

[
  "JAEG000901MGRCSRB8"
]

View formatted query View runnable query Explain query

SELECT
  t0.id AS ID_1,
  t0.usuario_id AS USUARIO_ID_2,
  t0.documento_id AS DOCUMENTO_ID_3,
  t0.tipo_documento_id AS TIPO_DOCUMENTO_ID_4,
  t0.estado AS ESTADO_5,
  t0.archivo AS ARCHIVO_6,
  t0.nombre_archivo AS NOMBRE_ARCHIVO_7,
  t0.fecha_subida AS FECHA_SUBIDA_8,
  t0.usuario_creo AS USUARIO_CREO_9,
  t0.observaciones AS OBSERVACIONES_10,
  t0.curp AS CURP_11,
  t0.reemplazo_rechazado AS REEMPLAZO_RECHAZADO_12,
  t0.fecha_observacion AS FECHA_OBSERVACION_13
FROM
  admcredencial.expediente_usuario t0
WHERE
  t0.curp = ?
  AND t0.usuario_id IS NULL

SELECT t0.id AS ID_1, t0.usuario_id AS USUARIO_ID_2, t0.documento_id AS DOCUMENTO_ID_3, t0.tipo_documento_id AS TIPO_DOCUMENTO_ID_4, t0.estado AS ESTADO_5, t0.archivo AS ARCHIVO_6, t0.nombre_archivo AS NOMBRE_ARCHIVO_7, t0.fecha_subida AS FECHA_SUBIDA_8, t0.usuario_creo AS USUARIO_CREO_9, t0.observaciones AS OBSERVACIONES_10, t0.curp AS CURP_11, t0.reemplazo_rechazado AS REEMPLAZO_RECHAZADO_12, t0.fecha_observacion AS FECHA_OBSERVACION_13 FROM admcredencial.expediente_usuario t0 WHERE t0.curp = 'JAEG000901MGRCSRB8' AND t0.usuario_id IS NULL;

Database Connections

Name	Service
default	doctrine.dbal.default_connection
db19c	doctrine.dbal.db19c_connection
dbsqlweb	doctrine.dbal.dbsqlweb_connection

Entity Managers

Name	Service
default	doctrine.orm.default_entity_manager
db19c	doctrine.orm.db19c_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

default entity manager

Class	Amount of managed objects
App\Entity\Main\User	1
App\Entity\Main\Bitacora	1

db19c entity manager

Class	Amount of managed objects

Entities Mapping

default entity manager

Class	Mapping errors
App\Entity\Main\User	The mappings App\Entity\Main\User#tramiteUsuarios and App\Entity\Main\TramiteUsuario#usuario are inconsistent with each other.
App\Entity\Main\Grupo	No errors.
App\Entity\Main\TramiteUsuario	No errors.
App\Entity\Main\UsuarioEscuelaPlan	No errors.
App\Entity\Main\RevisionTramite	No errors.
App\Entity\Main\TramiteSeguimiento	No errors.
App\Entity\Main\JefeAreaAsignacion	No errors.
App\Entity\Main\Bitacora	No errors.

db19c entity manager

Class	Mapping errors
App\Entity\Db19\ExpedienteUsuario	No errors.

Symfony Profiler

GET https://tramitesdae.uagro.mx/oauth/check/google?authuser=0&code=4%2F0Aci98E-0c920Yzrsu2K-R9fl8PGNkSD5m7h2B_ZYpnmAbCZGH-jBDf3h3y44kSZ4ER_cMA&hd=uagro.mx&iss=http…

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

default connection

db19c connection

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

db19c entity manager

Entities Mapping

default entity manager

db19c entity manager