Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception 1
• Logs 1
• Events
• Routing
• Cache
• Translation
• Security
• Twig
• HTTP Client
• Doctrine
• Migrations 3
• Debug
• Emails
• Notifications
• VichUploader
• Configuration

Query Metrics

SELECT TABLE_NAME
FROM ALL_TABLES
WHERE OWNER = ?
ORDER BY TABLE_NAME

[
  "ADMTRAMITESDAE"
]

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;

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

[
  "ADMTRAMITESDAE"
  "DOCTRINE_MIGRATION_VERSIONS"
]

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;

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

[
  "ADMTRAMITESDAE"
  "DOCTRINE_MIGRATION_VERSIONS"
]

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;

SELECT SYS_CONTEXT('USERENV', 'CURRENT_SCHEMA') FROM DUAL

[]

SELECT
  SYS_CONTEXT('USERENV', 'CURRENT_SCHEMA')
FROM
  DUAL

SELECT SYS_CONTEXT('USERENV', 'CURRENT_SCHEMA') FROM DUAL;

SELECT * FROM doctrine_migration_versions

[]

SELECT
  *
FROM
  doctrine_migration_versions

SELECT * FROM doctrine_migration_versions;

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

[
  "ADMTRAMITESDAE"
  "DOCTRINE_MIGRATION_VERSIONS"
]

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;

SELECT TABLE_NAME, COMMENTS FROM ALL_TAB_COMMENTS WHERE OWNER = ? AND TABLE_NAME = ?

[
  "ADMTRAMITESDAE"
  "DOCTRINE_MIGRATION_VERSIONS"
]

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';

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 = '.,'

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 = '.,';