Symfony Profiler

Query Metrics

14 Database Queries

8 Different statements

39.26 ms Query time

0 Invalid entities

Queries


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.83 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.65 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	4.10 ms	SELECT TABLE_NAME FROM ALL_TABLES WHERE OWNER = ? ORDER BY TABLE_NAME Parameters: [`"ADMTRAMITESDAE"`] 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 = 'ADMTRAMITESDAE' ORDER BY TABLE_NAME;
4	0.49 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	2.44 ms	SELECT TABLE_NAME FROM ALL_TABLES WHERE OWNER = ? ORDER BY TABLE_NAME Parameters: [`"ADMTRAMITESDAE"`] 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 = 'ADMTRAMITESDAE' ORDER BY TABLE_NAME;
6	0.55 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.87 ms	SELECT TABLE_NAME, COMMENTS FROM ALL_TAB_COMMENTS WHERE OWNER = ? AND TABLE_NAME = ? Parameters: [`"ADMTRAMITESDAE" "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 = 'ADMTRAMITESDAE' AND TABLE_NAME = 'DOCTRINE_MIGRATION_VERSIONS';
8	0.46 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	7.85 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: [`"ADMTRAMITESDAE" "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 = 'ADMTRAMITESDAE' AND COLS.TABLE_NAME = 'DOCTRINE_MIGRATION_VERSIONS' ORDER BY COLS.TABLE_NAME, COLS.CONSTRAINT_NAME, COLS.POSITION;
10	0.99 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: [`"ADMTRAMITESDAE" "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 = 'ADMTRAMITESDAE' AND C.TABLE_NAME = 'DOCTRINE_MIGRATION_VERSIONS' ORDER BY C.COLUMN_ID;
11	0.60 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	17.32 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: [`"ADMTRAMITESDAE" "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 = 'ADMTRAMITESDAE' AND IND_COL.TABLE_NAME = 'DOCTRINE_MIGRATION_VERSIONS' ORDER BY IND_COL.TABLE_NAME, IND_COL.INDEX_NAME, IND_COL.COLUMN_POSITION;
13	1.45 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.67 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

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\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\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\TramiteArchivo	No errors.
App\Entity\Main\TramiteSeguimiento	No errors.
App\Entity\Main\TramiteUsuario	No errors.
App\Entity\Main\User	No errors.
Vich\UploaderBundle\Entity\File	No errors.

Symfony Profiler

GET http://200.4.143.38/config.json

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Entities Mapping