Symfony Profiler

Query Metrics

3 Database Queries

3 Different statements

1.41 ms Query time

1 Invalid entities

1 Managed entities

Queries

Group similar statements

default connection

#▲	Time	Info
1	0.57 ms	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 = '.,';
2	0.42 ms	SELECT t0.id AS ID_1, t0.email AS EMAIL_2, t0.nombre AS NOMBRE_3, t0.apellidos AS APELLIDOS_4, t0.telefono AS TELEFONO_5, t0.permisos AS PERMISOS_6, t0.fecha_creacion AS FECHA_CREACION_7, t0.usuario_creo AS USUARIO_CREO_8, t0.fecha_actualizacion AS FECHA_ACTUALIZACION_9, t0.usuario_actualizo AS USUARIO_ACTUALIZO_10, t0.ultima_conexion AS ULTIMA_CONEXION_11, t0.google_id AS GOOGLE_ID_12, t0.UNIDAD_RESPONSABLE_ID AS UNIDAD_RESPONSABLE_ID_13, t0.matricula AS MATRICULA_14, t0.numero_empleado AS NUMERO_EMPLEADO_15 FROM "user" t0 WHERE t0.id = ? Parameters: [`3998`] View formatted query View runnable query Explain query SELECT t0.id AS ID_1, t0.email AS EMAIL_2, t0.nombre AS NOMBRE_3, t0.apellidos AS APELLIDOS_4, t0.telefono AS TELEFONO_5, t0.permisos AS PERMISOS_6, t0.fecha_creacion AS FECHA_CREACION_7, t0.usuario_creo AS USUARIO_CREO_8, t0.fecha_actualizacion AS FECHA_ACTUALIZACION_9, t0.usuario_actualizo AS USUARIO_ACTUALIZO_10, t0.ultima_conexion AS ULTIMA_CONEXION_11, t0.google_id AS GOOGLE_ID_12, t0.UNIDAD_RESPONSABLE_ID AS UNIDAD_RESPONSABLE_ID_13, t0.matricula AS MATRICULA_14, t0.numero_empleado AS NUMERO_EMPLEADO_15 FROM "user" t0 WHERE t0.id = ? SELECT t0.id AS ID_1, t0.email AS EMAIL_2, t0.nombre AS NOMBRE_3, t0.apellidos AS APELLIDOS_4, t0.telefono AS TELEFONO_5, t0.permisos AS PERMISOS_6, t0.fecha_creacion AS FECHA_CREACION_7, t0.usuario_creo AS USUARIO_CREO_8, t0.fecha_actualizacion AS FECHA_ACTUALIZACION_9, t0.usuario_actualizo AS USUARIO_ACTUALIZO_10, t0.ultima_conexion AS ULTIMA_CONEXION_11, t0.google_id AS GOOGLE_ID_12, t0.UNIDAD_RESPONSABLE_ID AS UNIDAD_RESPONSABLE_ID_13, t0.matricula AS MATRICULA_14, t0.numero_empleado AS NUMERO_EMPLEADO_15 FROM "user" t0 WHERE t0.id = 3998;
3	0.41 ms	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: [`3998`] 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 = 3998;

#▲

Time

Info

0.57 ms

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.42 ms

SELECT t0.id AS ID_1, t0.email AS EMAIL_2, t0.nombre AS NOMBRE_3, t0.apellidos AS APELLIDOS_4, t0.telefono AS TELEFONO_5, t0.permisos AS PERMISOS_6, t0.fecha_creacion AS FECHA_CREACION_7, t0.usuario_creo AS USUARIO_CREO_8, t0.fecha_actualizacion AS FECHA_ACTUALIZACION_9, t0.usuario_actualizo AS USUARIO_ACTUALIZO_10, t0.ultima_conexion AS ULTIMA_CONEXION_11, t0.google_id AS GOOGLE_ID_12, t0.UNIDAD_RESPONSABLE_ID AS UNIDAD_RESPONSABLE_ID_13, t0.matricula AS MATRICULA_14, t0.numero_empleado AS NUMERO_EMPLEADO_15 FROM "user" t0 WHERE t0.id = ?

Parameters:

[
  3998
]

View formatted query View runnable query Explain query

SELECT
  t0.id AS ID_1,
  t0.email AS EMAIL_2,
  t0.nombre AS NOMBRE_3,
  t0.apellidos AS APELLIDOS_4,
  t0.telefono AS TELEFONO_5,
  t0.permisos AS PERMISOS_6,
  t0.fecha_creacion AS FECHA_CREACION_7,
  t0.usuario_creo AS USUARIO_CREO_8,
  t0.fecha_actualizacion AS FECHA_ACTUALIZACION_9,
  t0.usuario_actualizo AS USUARIO_ACTUALIZO_10,
  t0.ultima_conexion AS ULTIMA_CONEXION_11,
  t0.google_id AS GOOGLE_ID_12,
  t0.UNIDAD_RESPONSABLE_ID AS UNIDAD_RESPONSABLE_ID_13,
  t0.matricula AS MATRICULA_14,
  t0.numero_empleado AS NUMERO_EMPLEADO_15
FROM
  "user" t0
WHERE
  t0.id = ?

SELECT t0.id AS ID_1, t0.email AS EMAIL_2, t0.nombre AS NOMBRE_3, t0.apellidos AS APELLIDOS_4, t0.telefono AS TELEFONO_5, t0.permisos AS PERMISOS_6, t0.fecha_creacion AS FECHA_CREACION_7, t0.usuario_creo AS USUARIO_CREO_8, t0.fecha_actualizacion AS FECHA_ACTUALIZACION_9, t0.usuario_actualizo AS USUARIO_ACTUALIZO_10, t0.ultima_conexion AS ULTIMA_CONEXION_11, t0.google_id AS GOOGLE_ID_12, t0.UNIDAD_RESPONSABLE_ID AS UNIDAD_RESPONSABLE_ID_13, t0.matricula AS MATRICULA_14, t0.numero_empleado AS NUMERO_EMPLEADO_15 FROM "user" t0 WHERE t0.id = 3998;

0.41 ms

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:

[
  3998
]

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 = 3998;

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

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.

db19c entity manager

No loaded entities.

Symfony Profiler

GET https://tramitesdae.uagro.mx/logout

Configuration Settings

Theme

Page Width

Query Metrics

Queries

default connection

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

db19c entity manager

Entities Mapping

default entity manager

db19c entity manager