Symfony Profiler

Query Metrics

14 Database Queries

8 Different statements

229.46 ms Query time

0 Invalid entities

0 Managed entities

Queries

Group similar statements

default connection


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 = '.,'
SELECT SYS_CONTEXT('USERENV', 'CURRENT_SCHEMA') FROM DUAL
SELECT TABLE_NAME
FROM ALL_TABLES
WHERE OWNER = ?
ORDER BY TABLE_NAME
SELECT SYS_CONTEXT('USERENV', 'CURRENT_SCHEMA') FROM DUAL
SELECT TABLE_NAME
FROM ALL_TABLES
WHERE OWNER = ?
ORDER BY TABLE_NAME
SELECT SYS_CONTEXT('USERENV', 'CURRENT_SCHEMA') FROM DUAL
SELECT TABLE_NAME, COMMENTS FROM ALL_TAB_COMMENTS WHERE OWNER = ? AND TABLE_NAME = ?
SELECT SYS_CONTEXT('USERENV', 'CURRENT_SCHEMA') FROM DUAL
SELECT                 ALC.CONSTRAINT_NAME,
                 ALC.DELETE_RULE,
                 COLS.COLUMN_NAME LOCAL_COLUMN,
                 COLS.POSITION,
                 R_COLS.TABLE_NAME REFERENCES_TABLE,
                 R_COLS.COLUMN_NAME FOREIGN_COLUMN
            FROM ALL_CONS_COLUMNS COLS
       LEFT JOIN ALL_CONSTRAINTS ALC ON ALC.OWNER = COLS.OWNER AND ALC.CONSTRAINT_NAME = COLS.CONSTRAINT_NAME
       LEFT JOIN ALL_CONS_COLUMNS R_COLS ON R_COLS.OWNER = ALC.R_OWNER AND
                 R_COLS.CONSTRAINT_NAME = ALC.R_CONSTRAINT_NAME AND
                 R_COLS.POSITION = COLS.POSITION WHERE ALC.CONSTRAINT_TYPE = 'R' AND COLS.OWNER = ? AND COLS.TABLE_NAME = ? ORDER BY COLS.TABLE_NAME, COLS.CONSTRAINT_NAME, COLS.POSITION
SELECT                 C.COLUMN_NAME,
                 C.DATA_TYPE,
                 C.DATA_DEFAULT,
                 C.DATA_PRECISION,
                 C.DATA_SCALE,
                 C.CHAR_LENGTH,
                 C.DATA_LENGTH,
                 C.NULLABLE,
                 D.COMMENTS
            FROM ALL_TAB_COLUMNS C
        INNER JOIN ALL_TABLES T
            ON T.OWNER = C.OWNER
            AND T.TABLE_NAME = C.TABLE_NAME
       LEFT JOIN ALL_COL_COMMENTS D
           ON D.OWNER = C.OWNER
                  AND D.TABLE_NAME = C.TABLE_NAME
                  AND D.COLUMN_NAME = C.COLUMN_NAME WHERE C.OWNER = ? AND C.TABLE_NAME = ? ORDER BY C.COLUMN_ID
SELECT SYS_CONTEXT('USERENV', 'CURRENT_SCHEMA') FROM DUAL
SELECT                 IND_COL.INDEX_NAME AS NAME,
                 IND.INDEX_TYPE AS TYPE,
                 DECODE(IND.UNIQUENESS, 'NONUNIQUE', 0, 'UNIQUE', 1) AS IS_UNIQUE,
                 IND_COL.COLUMN_NAME,
                 IND_COL.COLUMN_POSITION AS COLUMN_POS,
                 CON.CONSTRAINT_TYPE AS IS_PRIMARY
            FROM ALL_IND_COLUMNS IND_COL
       LEFT JOIN ALL_INDEXES IND
              ON IND.OWNER = IND_COL.INDEX_OWNER
             AND IND.INDEX_NAME = IND_COL.INDEX_NAME
       LEFT JOIN ALL_CONSTRAINTS CON
              ON CON.OWNER = IND_COL.INDEX_OWNER
             AND CON.INDEX_NAME = IND_COL.INDEX_NAME WHERE IND_COL.INDEX_OWNER = ? AND IND_COL.TABLE_NAME = ? ORDER BY IND_COL.TABLE_NAME, IND_COL.INDEX_NAME, IND_COL.COLUMN_POSITION
SELECT * FROM doctrine_migration_versions
SELECT SYS_CONTEXT('USERENV', 'CURRENT_SCHEMA') FROM DUAL

#▲	Time	Info
1	0.61 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.51 ms	SELECT SYS_CONTEXT('USERENV', 'CURRENT_SCHEMA') FROM DUAL Parameters: [] View formatted query View runnable query Explain query SELECT SYS_CONTEXT('USERENV', 'CURRENT_SCHEMA') FROM DUAL SELECT SYS_CONTEXT('USERENV', 'CURRENT_SCHEMA') FROM DUAL;
3	37.22 ms	SELECT TABLE_NAME FROM ALL_TABLES WHERE OWNER = ? ORDER BY TABLE_NAME Parameters: [`"ADMCREDENCIAL"`] View formatted query View runnable query Explain query SELECT TABLE_NAME FROM ALL_TABLES WHERE OWNER = ? ORDER BY TABLE_NAME SELECT TABLE_NAME FROM ALL_TABLES WHERE OWNER = 'ADMCREDENCIAL' ORDER BY TABLE_NAME;
4	0.40 ms	SELECT SYS_CONTEXT('USERENV', 'CURRENT_SCHEMA') FROM DUAL Parameters: [] View formatted query View runnable query Explain query SELECT SYS_CONTEXT('USERENV', 'CURRENT_SCHEMA') FROM DUAL SELECT SYS_CONTEXT('USERENV', 'CURRENT_SCHEMA') FROM DUAL;
5	34.87 ms	SELECT TABLE_NAME FROM ALL_TABLES WHERE OWNER = ? ORDER BY TABLE_NAME Parameters: [`"ADMCREDENCIAL"`] View formatted query View runnable query Explain query SELECT TABLE_NAME FROM ALL_TABLES WHERE OWNER = ? ORDER BY TABLE_NAME SELECT TABLE_NAME FROM ALL_TABLES WHERE OWNER = 'ADMCREDENCIAL' ORDER BY TABLE_NAME;
6	0.45 ms	SELECT SYS_CONTEXT('USERENV', 'CURRENT_SCHEMA') FROM DUAL Parameters: [] View formatted query View runnable query Explain query SELECT SYS_CONTEXT('USERENV', 'CURRENT_SCHEMA') FROM DUAL SELECT SYS_CONTEXT('USERENV', 'CURRENT_SCHEMA') FROM DUAL;
7	0.59 ms	SELECT TABLE_NAME, COMMENTS FROM ALL_TAB_COMMENTS WHERE OWNER = ? AND TABLE_NAME = ? Parameters: [`"ADMCREDENCIAL" "DOCTRINE_MIGRATION_VERSIONS"`] View formatted query View runnable query Explain query SELECT TABLE_NAME, COMMENTS FROM ALL_TAB_COMMENTS WHERE OWNER = ? AND TABLE_NAME = ? SELECT TABLE_NAME, COMMENTS FROM ALL_TAB_COMMENTS WHERE OWNER = 'ADMCREDENCIAL' AND TABLE_NAME = 'DOCTRINE_MIGRATION_VERSIONS';
8	0.26 ms	SELECT SYS_CONTEXT('USERENV', 'CURRENT_SCHEMA') FROM DUAL Parameters: [] View formatted query View runnable query Explain query SELECT SYS_CONTEXT('USERENV', 'CURRENT_SCHEMA') FROM DUAL SELECT SYS_CONTEXT('USERENV', 'CURRENT_SCHEMA') FROM DUAL;
9	2.22 ms	SELECT ALC.CONSTRAINT_NAME, ALC.DELETE_RULE, COLS.COLUMN_NAME LOCAL_COLUMN, COLS.POSITION, R_COLS.TABLE_NAME REFERENCES_TABLE, R_COLS.COLUMN_NAME FOREIGN_COLUMN FROM ALL_CONS_COLUMNS COLS LEFT JOIN ALL_CONSTRAINTS ALC ON ALC.OWNER = COLS.OWNER AND ALC.CONSTRAINT_NAME = COLS.CONSTRAINT_NAME LEFT JOIN ALL_CONS_COLUMNS R_COLS ON R_COLS.OWNER = ALC.R_OWNER AND R_COLS.CONSTRAINT_NAME = ALC.R_CONSTRAINT_NAME AND R_COLS.POSITION = COLS.POSITION WHERE ALC.CONSTRAINT_TYPE = 'R' AND COLS.OWNER = ? AND COLS.TABLE_NAME = ? ORDER BY COLS.TABLE_NAME, COLS.CONSTRAINT_NAME, COLS.POSITION Parameters: [`"ADMCREDENCIAL" "DOCTRINE_MIGRATION_VERSIONS"`] View formatted query View runnable query Explain query SELECT ALC.CONSTRAINT_NAME, ALC.DELETE_RULE, COLS.COLUMN_NAME LOCAL_COLUMN, COLS.POSITION, R_COLS.TABLE_NAME REFERENCES_TABLE, R_COLS.COLUMN_NAME FOREIGN_COLUMN FROM ALL_CONS_COLUMNS COLS LEFT JOIN ALL_CONSTRAINTS ALC ON ALC.OWNER = COLS.OWNER AND ALC.CONSTRAINT_NAME = COLS.CONSTRAINT_NAME LEFT JOIN ALL_CONS_COLUMNS R_COLS ON R_COLS.OWNER = ALC.R_OWNER AND R_COLS.CONSTRAINT_NAME = ALC.R_CONSTRAINT_NAME AND R_COLS.POSITION = COLS.POSITION WHERE ALC.CONSTRAINT_TYPE = 'R' AND COLS.OWNER = ? AND COLS.TABLE_NAME = ? ORDER BY COLS.TABLE_NAME, COLS.CONSTRAINT_NAME, COLS.POSITION SELECT ALC.CONSTRAINT_NAME, ALC.DELETE_RULE, COLS.COLUMN_NAME LOCAL_COLUMN, COLS.POSITION, R_COLS.TABLE_NAME REFERENCES_TABLE, R_COLS.COLUMN_NAME FOREIGN_COLUMN FROM ALL_CONS_COLUMNS COLS LEFT JOIN ALL_CONSTRAINTS ALC ON ALC.OWNER = COLS.OWNER AND ALC.CONSTRAINT_NAME = COLS.CONSTRAINT_NAME LEFT JOIN ALL_CONS_COLUMNS R_COLS ON R_COLS.OWNER = ALC.R_OWNER AND R_COLS.CONSTRAINT_NAME = ALC.R_CONSTRAINT_NAME AND R_COLS.POSITION = COLS.POSITION WHERE ALC.CONSTRAINT_TYPE = 'R' AND COLS.OWNER = 'ADMCREDENCIAL' AND COLS.TABLE_NAME = 'DOCTRINE_MIGRATION_VERSIONS' ORDER BY COLS.TABLE_NAME, COLS.CONSTRAINT_NAME, COLS.POSITION;
10	0.54 ms	SELECT C.COLUMN_NAME, C.DATA_TYPE, C.DATA_DEFAULT, C.DATA_PRECISION, C.DATA_SCALE, C.CHAR_LENGTH, C.DATA_LENGTH, C.NULLABLE, D.COMMENTS FROM ALL_TAB_COLUMNS C INNER JOIN ALL_TABLES T ON T.OWNER = C.OWNER AND T.TABLE_NAME = C.TABLE_NAME LEFT JOIN ALL_COL_COMMENTS D ON D.OWNER = C.OWNER AND D.TABLE_NAME = C.TABLE_NAME AND D.COLUMN_NAME = C.COLUMN_NAME WHERE C.OWNER = ? AND C.TABLE_NAME = ? ORDER BY C.COLUMN_ID Parameters: [`"ADMCREDENCIAL" "DOCTRINE_MIGRATION_VERSIONS"`] View formatted query View runnable query Explain query SELECT C.COLUMN_NAME, C.DATA_TYPE, C.DATA_DEFAULT, C.DATA_PRECISION, C.DATA_SCALE, C.CHAR_LENGTH, C.DATA_LENGTH, C.NULLABLE, D.COMMENTS FROM ALL_TAB_COLUMNS C INNER JOIN ALL_TABLES T ON T.OWNER = C.OWNER AND T.TABLE_NAME = C.TABLE_NAME LEFT JOIN ALL_COL_COMMENTS D ON D.OWNER = C.OWNER AND D.TABLE_NAME = C.TABLE_NAME AND D.COLUMN_NAME = C.COLUMN_NAME WHERE C.OWNER = ? AND C.TABLE_NAME = ? ORDER BY C.COLUMN_ID SELECT C.COLUMN_NAME, C.DATA_TYPE, C.DATA_DEFAULT, C.DATA_PRECISION, C.DATA_SCALE, C.CHAR_LENGTH, C.DATA_LENGTH, C.NULLABLE, D.COMMENTS FROM ALL_TAB_COLUMNS C INNER JOIN ALL_TABLES T ON T.OWNER = C.OWNER AND T.TABLE_NAME = C.TABLE_NAME LEFT JOIN ALL_COL_COMMENTS D ON D.OWNER = C.OWNER AND D.TABLE_NAME = C.TABLE_NAME AND D.COLUMN_NAME = C.COLUMN_NAME WHERE C.OWNER = 'ADMCREDENCIAL' AND C.TABLE_NAME = 'DOCTRINE_MIGRATION_VERSIONS' ORDER BY C.COLUMN_ID;
11	0.29 ms	SELECT SYS_CONTEXT('USERENV', 'CURRENT_SCHEMA') FROM DUAL Parameters: [] View formatted query View runnable query Explain query SELECT SYS_CONTEXT('USERENV', 'CURRENT_SCHEMA') FROM DUAL SELECT SYS_CONTEXT('USERENV', 'CURRENT_SCHEMA') FROM DUAL;
12	150.40 ms	SELECT IND_COL.INDEX_NAME AS NAME, IND.INDEX_TYPE AS TYPE, DECODE(IND.UNIQUENESS, 'NONUNIQUE', 0, 'UNIQUE', 1) AS IS_UNIQUE, IND_COL.COLUMN_NAME, IND_COL.COLUMN_POSITION AS COLUMN_POS, CON.CONSTRAINT_TYPE AS IS_PRIMARY FROM ALL_IND_COLUMNS IND_COL LEFT JOIN ALL_INDEXES IND ON IND.OWNER = IND_COL.INDEX_OWNER AND IND.INDEX_NAME = IND_COL.INDEX_NAME LEFT JOIN ALL_CONSTRAINTS CON ON CON.OWNER = IND_COL.INDEX_OWNER AND CON.INDEX_NAME = IND_COL.INDEX_NAME WHERE IND_COL.INDEX_OWNER = ? AND IND_COL.TABLE_NAME = ? ORDER BY IND_COL.TABLE_NAME, IND_COL.INDEX_NAME, IND_COL.COLUMN_POSITION Parameters: [`"ADMCREDENCIAL" "DOCTRINE_MIGRATION_VERSIONS"`] View formatted query View runnable query Explain query SELECT IND_COL.INDEX_NAME AS NAME, IND.INDEX_TYPE AS TYPE, DECODE( IND.UNIQUENESS, 'NONUNIQUE', 0, 'UNIQUE', 1 ) AS IS_UNIQUE, IND_COL.COLUMN_NAME, IND_COL.COLUMN_POSITION AS COLUMN_POS, CON.CONSTRAINT_TYPE AS IS_PRIMARY FROM ALL_IND_COLUMNS IND_COL LEFT JOIN ALL_INDEXES IND ON IND.OWNER = IND_COL.INDEX_OWNER AND IND.INDEX_NAME = IND_COL.INDEX_NAME LEFT JOIN ALL_CONSTRAINTS CON ON CON.OWNER = IND_COL.INDEX_OWNER AND CON.INDEX_NAME = IND_COL.INDEX_NAME WHERE IND_COL.INDEX_OWNER = ? AND IND_COL.TABLE_NAME = ? ORDER BY IND_COL.TABLE_NAME, IND_COL.INDEX_NAME, IND_COL.COLUMN_POSITION SELECT IND_COL.INDEX_NAME AS NAME, IND.INDEX_TYPE AS TYPE, DECODE(IND.UNIQUENESS, 'NONUNIQUE', 0, 'UNIQUE', 1) AS IS_UNIQUE, IND_COL.COLUMN_NAME, IND_COL.COLUMN_POSITION AS COLUMN_POS, CON.CONSTRAINT_TYPE AS IS_PRIMARY FROM ALL_IND_COLUMNS IND_COL LEFT JOIN ALL_INDEXES IND ON IND.OWNER = IND_COL.INDEX_OWNER AND IND.INDEX_NAME = IND_COL.INDEX_NAME LEFT JOIN ALL_CONSTRAINTS CON ON CON.OWNER = IND_COL.INDEX_OWNER AND CON.INDEX_NAME = IND_COL.INDEX_NAME WHERE IND_COL.INDEX_OWNER = 'ADMCREDENCIAL' AND IND_COL.TABLE_NAME = 'DOCTRINE_MIGRATION_VERSIONS' ORDER BY IND_COL.TABLE_NAME, IND_COL.INDEX_NAME, IND_COL.COLUMN_POSITION;
13	0.72 ms	SELECT * FROM doctrine_migration_versions Parameters: [] View formatted query View runnable query Explain query SELECT * FROM doctrine_migration_versions SELECT * FROM doctrine_migration_versions;
14	0.37 ms	SELECT SYS_CONTEXT('USERENV', 'CURRENT_SCHEMA') FROM DUAL Parameters: [] View formatted query View runnable query Explain query SELECT SYS_CONTEXT('USERENV', 'CURRENT_SCHEMA') FROM DUAL SELECT SYS_CONTEXT('USERENV', 'CURRENT_SCHEMA') FROM DUAL;

Database Connections

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

Entity Managers

Name	Service
default	doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

default entity manager

Class	Amount of managed objects

Entities Mapping

Class	Mapping errors
App\Entity\Main\Bitacora	No errors.
App\Entity\Main\Grupo	No errors.
App\Entity\Main\Permiso	No errors.
App\Entity\Main\Audiencia	No errors.
App\Entity\Main\Catalogos\Areas	No errors.
App\Entity\Main\Catalogos\Documento	No errors.
App\Entity\Main\Catalogos\EstadoAtencion	No errors.
App\Entity\Main\Catalogos\NivelAplica	No errors.
App\Entity\Main\Catalogos\Prioridad	No errors.
App\Entity\Main\Catalogos\TipoDocumento	No errors.
App\Entity\Main\Catalogos\TipoSolicitud	No errors.
App\Entity\Main\Catalogos\TSIECatDocu	No errors.
App\Entity\Main\Costo	No errors.
App\Entity\Main\FundamentoJuridico	No errors.
App\Entity\Main\OficinasAtencion	No errors.
App\Entity\Main\Pregunta	No errors.
App\Entity\Main\ProcedimientoWeb	No errors.
App\Entity\Main\Requisito	No errors.
App\Entity\Main\TitulosEmitidos	No errors.
App\Entity\Main\Tramite	No errors.
App\Entity\Main\TramiteSeguimiento	No errors.
App\Entity\Main\TramiteUsuario	No errors.
App\Entity\Main\CredencialesVerificablesEmitidas	No errors.
App\Entity\Main\AlumnoCredential	No errors.
App\Entity\Main\AspirantePonteAguila	No errors.
App\Entity\Main\CredentialEstatus	No errors.
App\Entity\Main\CredentialEvent	No errors.
App\Entity\Main\Titulos	No errors.
App\Entity\Main\TituloDigital	No errors.
App\Entity\Main\AlumnoPlan	No errors.
App\Entity\Main\Escuela	No errors.
App\Entity\Main\MateriaValidada	No errors.
App\Entity\Main\OrdenImpresion	No errors.
App\Entity\Main\OrdenImpresionEstado	No errors.
App\Entity\Main\PersonaUAGro	No errors.
App\Entity\Main\TSIEArchivo	No errors.
App\Entity\Main\TSIEInscripcion	No errors.
App\Entity\Main\TramiteArchivo	No errors.
App\Entity\Main\User	No errors.
App\Entity\Main\UsuarioEscuelaPlan	No errors.
App\Entity\Main\VWCalificacionAlumnoCuadro	No errors.
App\Entity\Main\ValidacionMateriaOrden	No errors.
App\Entity\Main\ValidadorRevisor	No errors.
App\Entity\Main\Alumno	No errors.
App\Entity\Main\AlumnoPrepaPromedioPlan	No errors.
App\Entity\Main\DetalleOrdenImpresion	No errors.
App\Entity\Main\PlanEstudio	No errors.
Vich\UploaderBundle\Entity\File	No errors.

Symfony Profiler

GET https://www.tramitesdae.uagro.mx/robots.txt

Configuration Settings

Theme

Page Width

Query Metrics

Queries

default connection

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping