Symfony Profiler

Query Metrics

17 Database Queries

9 Different statements

6.24 ms Query time

0 Invalid entities

0 Managed entities

Grouped Statements

Show all queries

organisation connection

Time▼

Count

Info

1.21 ms
(19.45%)

SELECT DATABASE()

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  DATABASE()

SELECT DATABASE();

#	File/Call
1	Sentry\SentryBundle\Tracing\Doctrine\DBAL\TracingDriverConnectionForV4->traceFunction (line 246)
2	Sentry\SentryBundle\Tracing\Doctrine\DBAL\TracingDriverConnectionForV4->query (line 117)
3	Doctrine\DBAL\Connection->executeQuery (line 804)
4	Doctrine\DBAL\Connection->fetchOne (line 332)
5	Doctrine\DBAL\Connection->getDatabase (line 161)
6	Doctrine\DBAL\Schema\AbstractSchemaManager->getDatabase (line 1458)
7	Doctrine\DBAL\Schema\AbstractSchemaManager->listTableNames (line 208)
8	Doctrine\DBAL\Schema\AbstractSchemaManager->tablesExist (line 184)
9	Doctrine\Migrations\Metadata\Storage\TableMetadataStorage->isInitialized (line 245)
10	Doctrine\Migrations\Metadata\Storage\TableMetadataStorage->getExecutedMigrations (line 80)
11	Doctrine\Bundle\MigrationsBundle\Collector\MigrationsCollector->collect (line 44)
12	Symfony\Component\HttpKernel\Profiler\Profiler->collect (line 158)
13	Symfony\Component\HttpKernel\EventListener\ProfilerListener->onKernelResponse (line 102)
14	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
15	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
16	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
17	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 129)
18	Symfony\Component\HttpKernel\HttpKernel->filterResponse (line 216)
19	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 204)
20	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
21	Symfony\Component\HttpKernel\EventListener\ErrorListener->onKernelException (line 99)
22	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
23	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
24	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
25	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 129)
26	Symfony\Component\HttpKernel\HttpKernel->handleThrowable (line 241)
27	Symfony\Component\HttpKernel\HttpKernel->handle (line 91)
28	Symfony\Component\HttpKernel\Kernel->handle (line 193)
29	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
30	require_once (line 32)
31	require_once (line 5)

1.10 ms
(17.66%)

SELECT TABLE_NAME
FROM information_schema.TABLES
WHERE TABLE_SCHEMA = ?
  AND TABLE_TYPE = 'BASE TABLE'
ORDER BY TABLE_NAME

Parameters:

[
  "docker_admin"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  TABLE_NAME
FROM
  information_schema.TABLES
WHERE
  TABLE_SCHEMA = ?
  AND TABLE_TYPE = 'BASE TABLE'
ORDER BY
  TABLE_NAME

SELECT TABLE_NAME
FROM information_schema.TABLES
WHERE TABLE_SCHEMA = 'docker_admin'
  AND TABLE_TYPE = 'BASE TABLE'
ORDER BY TABLE_NAME;

#	File/Call
1	Sentry\SentryBundle\Tracing\Doctrine\DBAL\TracingStatementForV4->execute (line 36)
2	Doctrine\DBAL\Connection->executeQuery (line 802)
3	Doctrine\DBAL\Schema\MySQLSchemaManager->selectTableNames (line 360)
4	Doctrine\DBAL\Schema\AbstractSchemaManager->listTableNames (line 207)
5	Doctrine\DBAL\Schema\AbstractSchemaManager->tablesExist (line 184)
6	Doctrine\Migrations\Metadata\Storage\TableMetadataStorage->isInitialized (line 245)
7	Doctrine\Migrations\Metadata\Storage\TableMetadataStorage->getExecutedMigrations (line 80)
8	Doctrine\Bundle\MigrationsBundle\Collector\MigrationsCollector->collect (line 44)
9	Symfony\Component\HttpKernel\Profiler\Profiler->collect (line 158)
10	Symfony\Component\HttpKernel\EventListener\ProfilerListener->onKernelResponse (line 102)
11	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
12	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
13	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
14	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 129)
15	Symfony\Component\HttpKernel\HttpKernel->filterResponse (line 216)
16	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 204)
17	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
18	Symfony\Component\HttpKernel\EventListener\ErrorListener->onKernelException (line 99)
19	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
20	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
21	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
22	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 129)
23	Symfony\Component\HttpKernel\HttpKernel->handleThrowable (line 241)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 91)
25	Symfony\Component\HttpKernel\Kernel->handle (line 193)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
27	require_once (line 32)
28	require_once (line 5)

1.02 ms
(16.38%)

SELECT c.TABLE_NAME,
       c.COLUMN_NAME,
       c.DATA_TYPE,
       c.COLUMN_TYPE,
       c.CHARACTER_MAXIMUM_LENGTH,
       c.CHARACTER_OCTET_LENGTH,
       c.NUMERIC_PRECISION,
       c.NUMERIC_SCALE,
       c.IS_NULLABLE,
       c.COLUMN_DEFAULT,
       c.EXTRA,
       c.COLUMN_COMMENT,
       c.CHARACTER_SET_NAME,
       c.COLLATION_NAME
FROM information_schema.COLUMNS c
         INNER JOIN information_schema.TABLES t
                    ON t.TABLE_NAME = c.TABLE_NAME
WHERE c.TABLE_SCHEMA = ? AND t.TABLE_SCHEMA = ? AND t.TABLE_NAME = ?
  AND t.TABLE_TYPE = 'BASE TABLE'
ORDER BY c.TABLE_NAME,
         c.ORDINAL_POSITION

Parameters:

[
  "docker_admin"
  "docker_admin"
  "doctrine_migration_versions"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  c.TABLE_NAME,
  c.COLUMN_NAME,
  c.DATA_TYPE,
  c.COLUMN_TYPE,
  c.CHARACTER_MAXIMUM_LENGTH,
  c.CHARACTER_OCTET_LENGTH,
  c.NUMERIC_PRECISION,
  c.NUMERIC_SCALE,
  c.IS_NULLABLE,
  c.COLUMN_DEFAULT,
  c.EXTRA,
  c.COLUMN_COMMENT,
  c.CHARACTER_SET_NAME,
  c.COLLATION_NAME
FROM
  information_schema.COLUMNS c
  INNER JOIN information_schema.TABLES t ON t.TABLE_NAME = c.TABLE_NAME
WHERE
  c.TABLE_SCHEMA = ?
  AND t.TABLE_SCHEMA = ?
  AND t.TABLE_NAME = ?
  AND t.TABLE_TYPE = 'BASE TABLE'
ORDER BY
  c.TABLE_NAME,
  c.ORDINAL_POSITION

SELECT c.TABLE_NAME,
       c.COLUMN_NAME,
       c.DATA_TYPE,
       c.COLUMN_TYPE,
       c.CHARACTER_MAXIMUM_LENGTH,
       c.CHARACTER_OCTET_LENGTH,
       c.NUMERIC_PRECISION,
       c.NUMERIC_SCALE,
       c.IS_NULLABLE,
       c.COLUMN_DEFAULT,
       c.EXTRA,
       c.COLUMN_COMMENT,
       c.CHARACTER_SET_NAME,
       c.COLLATION_NAME
FROM information_schema.COLUMNS c
         INNER JOIN information_schema.TABLES t
                    ON t.TABLE_NAME = c.TABLE_NAME
WHERE c.TABLE_SCHEMA = 'docker_admin' AND t.TABLE_SCHEMA = 'docker_admin' AND t.TABLE_NAME = 'doctrine_migration_versions'
  AND t.TABLE_TYPE = 'BASE TABLE'
ORDER BY c.TABLE_NAME,
         c.ORDINAL_POSITION;

#	File/Call
1	Sentry\SentryBundle\Tracing\Doctrine\DBAL\TracingStatementForV4->execute (line 36)
2	Doctrine\DBAL\Connection->executeQuery (line 802)
3	Doctrine\DBAL\Connection->iterateNumeric (line 685)
4	Doctrine\DBAL\Platforms\MySQL\MySQLMetadataProvider->getTableColumns (line 186)
5	Doctrine\DBAL\Schema\Introspection\IntrospectingSchemaProvider->getColumnsForTable (line 157)
6	Doctrine\DBAL\Schema\AbstractSchemaManager->{closure:Doctrine\DBAL\Schema\AbstractSchemaManager::introspectTableColumns():723} (line 724)
7	Doctrine\DBAL\Schema\AbstractSchemaManager::introspectTableObjects (line 937)
8	Doctrine\DBAL\Schema\AbstractSchemaManager->introspectTableColumns (line 721)
9	Doctrine\DBAL\Schema\AbstractSchemaManager->introspectTable0 (line 658)
10	Doctrine\DBAL\Schema\AbstractSchemaManager->introspectTableByUnquotedName (line 688)
11	Doctrine\Migrations\Metadata\Storage\TableMetadataStorage->needsUpdate (line 223)
12	Doctrine\Migrations\Metadata\Storage\TableMetadataStorage->checkInitialization (line 256)
13	Doctrine\Migrations\Metadata\Storage\TableMetadataStorage->getExecutedMigrations (line 84)
14	Doctrine\Bundle\MigrationsBundle\Collector\MigrationsCollector->collect (line 44)
15	Symfony\Component\HttpKernel\Profiler\Profiler->collect (line 158)
16	Symfony\Component\HttpKernel\EventListener\ProfilerListener->onKernelResponse (line 102)
17	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
18	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
19	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
20	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 129)
21	Symfony\Component\HttpKernel\HttpKernel->filterResponse (line 216)
22	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 204)
23	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
24	Symfony\Component\HttpKernel\EventListener\ErrorListener->onKernelException (line 99)
25	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
26	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
27	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
28	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 129)
29	Symfony\Component\HttpKernel\HttpKernel->handleThrowable (line 241)
30	Symfony\Component\HttpKernel\HttpKernel->handle (line 91)
31	Symfony\Component\HttpKernel\Kernel->handle (line 193)
32	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
33	require_once (line 32)
34	require_once (line 5)

0.75 ms
(12.08%)

SELECT k.TABLE_NAME,
       k.CONSTRAINT_NAME,
       k.REFERENCED_TABLE_NAME,
       c.UPDATE_RULE,
       c.DELETE_RULE,
       k.COLUMN_NAME,
       k.REFERENCED_COLUMN_NAME
FROM information_schema.KEY_COLUMN_USAGE k
         INNER JOIN information_schema.REFERENTIAL_CONSTRAINTS c
                    ON c.CONSTRAINT_NAME = k.CONSTRAINT_NAME
                        AND c.TABLE_NAME = k.TABLE_NAME
WHERE k.TABLE_SCHEMA = ? AND c.CONSTRAINT_SCHEMA = ? AND k.TABLE_NAME = ?
  AND k.REFERENCED_COLUMN_NAME IS NOT NULL
ORDER BY k.TABLE_NAME,
         k.CONSTRAINT_NAME,
         k.ORDINAL_POSITION

Parameters:

[
  "docker_admin"
  "docker_admin"
  "doctrine_migration_versions"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  k.TABLE_NAME,
  k.CONSTRAINT_NAME,
  k.REFERENCED_TABLE_NAME,
  c.UPDATE_RULE,
  c.DELETE_RULE,
  k.COLUMN_NAME,
  k.REFERENCED_COLUMN_NAME
FROM
  information_schema.KEY_COLUMN_USAGE k
  INNER JOIN information_schema.REFERENTIAL_CONSTRAINTS c ON c.CONSTRAINT_NAME = k.CONSTRAINT_NAME
  AND c.TABLE_NAME = k.TABLE_NAME
WHERE
  k.TABLE_SCHEMA = ?
  AND c.CONSTRAINT_SCHEMA = ?
  AND k.TABLE_NAME = ?
  AND k.REFERENCED_COLUMN_NAME IS NOT NULL
ORDER BY
  k.TABLE_NAME,
  k.CONSTRAINT_NAME,
  k.ORDINAL_POSITION

SELECT k.TABLE_NAME,
       k.CONSTRAINT_NAME,
       k.REFERENCED_TABLE_NAME,
       c.UPDATE_RULE,
       c.DELETE_RULE,
       k.COLUMN_NAME,
       k.REFERENCED_COLUMN_NAME
FROM information_schema.KEY_COLUMN_USAGE k
         INNER JOIN information_schema.REFERENTIAL_CONSTRAINTS c
                    ON c.CONSTRAINT_NAME = k.CONSTRAINT_NAME
                        AND c.TABLE_NAME = k.TABLE_NAME
WHERE k.TABLE_SCHEMA = 'docker_admin' AND c.CONSTRAINT_SCHEMA = 'docker_admin' AND k.TABLE_NAME = 'doctrine_migration_versions'
  AND k.REFERENCED_COLUMN_NAME IS NOT NULL
ORDER BY k.TABLE_NAME,
         k.CONSTRAINT_NAME,
         k.ORDINAL_POSITION;

#	File/Call
1	Sentry\SentryBundle\Tracing\Doctrine\DBAL\TracingStatementForV4->execute (line 36)
2	Doctrine\DBAL\Connection->executeQuery (line 802)
3	Doctrine\DBAL\Connection->iterateNumeric (line 685)
4	Doctrine\DBAL\Platforms\MySQL\MySQLMetadataProvider->getForeignKeyConstraintColumns (line 565)
5	Doctrine\DBAL\Schema\Introspection\IntrospectingSchemaProvider->getForeignKeyConstraintsForTable (line 301)
6	Doctrine\DBAL\Schema\AbstractSchemaManager->{closure:Doctrine\DBAL\Schema\AbstractSchemaManager::introspectTableForeignKeyConstraints():865} (line 866)
7	Doctrine\DBAL\Schema\AbstractSchemaManager::introspectTableObjects (line 937)
8	Doctrine\DBAL\Schema\AbstractSchemaManager->introspectTableForeignKeyConstraints (line 863)
9	Doctrine\DBAL\Schema\AbstractSchemaManager->introspectTable0 (line 672)
10	Doctrine\DBAL\Schema\AbstractSchemaManager->introspectTableByUnquotedName (line 688)
11	Doctrine\Migrations\Metadata\Storage\TableMetadataStorage->needsUpdate (line 223)
12	Doctrine\Migrations\Metadata\Storage\TableMetadataStorage->checkInitialization (line 256)
13	Doctrine\Migrations\Metadata\Storage\TableMetadataStorage->getExecutedMigrations (line 84)
14	Doctrine\Bundle\MigrationsBundle\Collector\MigrationsCollector->collect (line 44)
15	Symfony\Component\HttpKernel\Profiler\Profiler->collect (line 158)
16	Symfony\Component\HttpKernel\EventListener\ProfilerListener->onKernelResponse (line 102)
17	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
18	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
19	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
20	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 129)
21	Symfony\Component\HttpKernel\HttpKernel->filterResponse (line 216)
22	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 204)
23	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
24	Symfony\Component\HttpKernel\EventListener\ErrorListener->onKernelException (line 99)
25	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
26	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
27	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
28	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 129)
29	Symfony\Component\HttpKernel\HttpKernel->handleThrowable (line 241)
30	Symfony\Component\HttpKernel\HttpKernel->handle (line 91)
31	Symfony\Component\HttpKernel\Kernel->handle (line 193)
32	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
33	require_once (line 32)
34	require_once (line 5)

0.74 ms
(11.79%)

SELECT tc.TABLE_NAME,
       tc.CONSTRAINT_NAME,
       kcu.COLUMN_NAME
FROM information_schema.TABLE_CONSTRAINTS tc
         INNER JOIN information_schema.KEY_COLUMN_USAGE kcu
                    ON kcu.TABLE_NAME = tc.TABLE_NAME
                        AND kcu.CONSTRAINT_NAME = tc.CONSTRAINT_NAME
WHERE tc.TABLE_SCHEMA = ? AND kcu.TABLE_SCHEMA = ? AND tc.TABLE_NAME = ?
  AND tc.CONSTRAINT_TYPE = 'PRIMARY KEY'
ORDER BY TABLE_NAME,
    kcu.ORDINAL_POSITION

Parameters:

[
  "docker_admin"
  "docker_admin"
  "doctrine_migration_versions"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  tc.TABLE_NAME,
  tc.CONSTRAINT_NAME,
  kcu.COLUMN_NAME
FROM
  information_schema.TABLE_CONSTRAINTS tc
  INNER JOIN information_schema.KEY_COLUMN_USAGE kcu ON kcu.TABLE_NAME = tc.TABLE_NAME
  AND kcu.CONSTRAINT_NAME = tc.CONSTRAINT_NAME
WHERE
  tc.TABLE_SCHEMA = ?
  AND kcu.TABLE_SCHEMA = ?
  AND tc.TABLE_NAME = ?
  AND tc.CONSTRAINT_TYPE = 'PRIMARY KEY'
ORDER BY
  TABLE_NAME,
  kcu.ORDINAL_POSITION

SELECT tc.TABLE_NAME,
       tc.CONSTRAINT_NAME,
       kcu.COLUMN_NAME
FROM information_schema.TABLE_CONSTRAINTS tc
         INNER JOIN information_schema.KEY_COLUMN_USAGE kcu
                    ON kcu.TABLE_NAME = tc.TABLE_NAME
                        AND kcu.CONSTRAINT_NAME = tc.CONSTRAINT_NAME
WHERE tc.TABLE_SCHEMA = 'docker_admin' AND kcu.TABLE_SCHEMA = 'docker_admin' AND tc.TABLE_NAME = 'doctrine_migration_versions'
  AND tc.CONSTRAINT_TYPE = 'PRIMARY KEY'
ORDER BY TABLE_NAME,
    kcu.ORDINAL_POSITION;

#	File/Call
1	Sentry\SentryBundle\Tracing\Doctrine\DBAL\TracingStatementForV4->execute (line 36)
2	Doctrine\DBAL\Connection->executeQuery (line 802)
3	Doctrine\DBAL\Connection->iterateNumeric (line 685)
4	Doctrine\DBAL\Platforms\MySQL\MySQLMetadataProvider->getPrimaryKeyConstraintColumns (line 493)
5	Doctrine\DBAL\Schema\Introspection\IntrospectingSchemaProvider->getPrimaryKeyConstraintForTable (line 252)
6	Doctrine\DBAL\Schema\AbstractSchemaManager->{closure:Doctrine\DBAL\Schema\AbstractSchemaManager::introspectTablePrimaryKeyConstraint():841} (line 846)
7	Doctrine\DBAL\Schema\AbstractSchemaManager::introspectTableObjects (line 937)
8	Doctrine\DBAL\Schema\AbstractSchemaManager->introspectTablePrimaryKeyConstraint (line 839)
9	Doctrine\DBAL\Schema\AbstractSchemaManager->introspectTable0 (line 670)
10	Doctrine\DBAL\Schema\AbstractSchemaManager->introspectTableByUnquotedName (line 688)
11	Doctrine\Migrations\Metadata\Storage\TableMetadataStorage->needsUpdate (line 223)
12	Doctrine\Migrations\Metadata\Storage\TableMetadataStorage->checkInitialization (line 256)
13	Doctrine\Migrations\Metadata\Storage\TableMetadataStorage->getExecutedMigrations (line 84)
14	Doctrine\Bundle\MigrationsBundle\Collector\MigrationsCollector->collect (line 44)
15	Symfony\Component\HttpKernel\Profiler\Profiler->collect (line 158)
16	Symfony\Component\HttpKernel\EventListener\ProfilerListener->onKernelResponse (line 102)
17	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
18	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
19	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
20	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 129)
21	Symfony\Component\HttpKernel\HttpKernel->filterResponse (line 216)
22	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 204)
23	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
24	Symfony\Component\HttpKernel\EventListener\ErrorListener->onKernelException (line 99)
25	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
26	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
27	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
28	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 129)
29	Symfony\Component\HttpKernel\HttpKernel->handleThrowable (line 241)
30	Symfony\Component\HttpKernel\HttpKernel->handle (line 91)
31	Symfony\Component\HttpKernel\Kernel->handle (line 193)
32	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
33	require_once (line 32)
34	require_once (line 5)

0.57 ms
(9.12%)

SELECT t.TABLE_NAME,
           t.ENGINE,
           t.AUTO_INCREMENT,
           t.TABLE_COMMENT,
           t.CREATE_OPTIONS,
           t.TABLE_COLLATION,
           ccsa.CHARACTER_SET_NAME
      FROM information_schema.TABLES t
        INNER JOIN information_schema.COLLATION_CHARACTER_SET_APPLICABILITY ccsa
          ON ccsa.COLLATION_NAME = t.TABLE_COLLATION WHERE t.TABLE_SCHEMA = ? AND t.TABLE_NAME = ? AND t.TABLE_TYPE = 'BASE TABLE'

Parameters:

[
  "docker_admin"
  "doctrine_migration_versions"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t.TABLE_NAME,
  t.ENGINE,
  t.AUTO_INCREMENT,
  t.TABLE_COMMENT,
  t.CREATE_OPTIONS,
  t.TABLE_COLLATION,
  ccsa.CHARACTER_SET_NAME
FROM
  information_schema.TABLES t
  INNER JOIN information_schema.COLLATION_CHARACTER_SET_APPLICABILITY ccsa ON ccsa.COLLATION_NAME = t.TABLE_COLLATION
WHERE
  t.TABLE_SCHEMA = ?
  AND t.TABLE_NAME = ?
  AND t.TABLE_TYPE = 'BASE TABLE'

SELECT t.TABLE_NAME,
           t.ENGINE,
           t.AUTO_INCREMENT,
           t.TABLE_COMMENT,
           t.CREATE_OPTIONS,
           t.TABLE_COLLATION,
           ccsa.CHARACTER_SET_NAME
      FROM information_schema.TABLES t
        INNER JOIN information_schema.COLLATION_CHARACTER_SET_APPLICABILITY ccsa
          ON ccsa.COLLATION_NAME = t.TABLE_COLLATION WHERE t.TABLE_SCHEMA = 'docker_admin' AND t.TABLE_NAME = 'doctrine_migration_versions' AND t.TABLE_TYPE = 'BASE TABLE';

#	File/Call
1	Sentry\SentryBundle\Tracing\Doctrine\DBAL\TracingStatementForV4->execute (line 36)
2	Doctrine\DBAL\Connection->executeQuery (line 802)
3	Doctrine\DBAL\Connection->iterateNumeric (line 685)
4	Doctrine\DBAL\Platforms\MySQL\MySQLMetadataProvider->getTableOptions (line 622)
5	Doctrine\DBAL\Schema\Introspection\IntrospectingSchemaProvider->getOptionsForTable (line 358)
6	Doctrine\DBAL\Schema\AbstractSchemaManager->introspectTableOptions (line 960)
7	Doctrine\DBAL\Schema\AbstractSchemaManager->introspectTable0 (line 664)
8	Doctrine\DBAL\Schema\AbstractSchemaManager->introspectTableByUnquotedName (line 688)
9	Doctrine\Migrations\Metadata\Storage\TableMetadataStorage->needsUpdate (line 223)
10	Doctrine\Migrations\Metadata\Storage\TableMetadataStorage->checkInitialization (line 256)
11	Doctrine\Migrations\Metadata\Storage\TableMetadataStorage->getExecutedMigrations (line 84)
12	Doctrine\Bundle\MigrationsBundle\Collector\MigrationsCollector->collect (line 44)
13	Symfony\Component\HttpKernel\Profiler\Profiler->collect (line 158)
14	Symfony\Component\HttpKernel\EventListener\ProfilerListener->onKernelResponse (line 102)
15	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
16	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
17	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
18	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 129)
19	Symfony\Component\HttpKernel\HttpKernel->filterResponse (line 216)
20	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 204)
21	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
22	Symfony\Component\HttpKernel\EventListener\ErrorListener->onKernelException (line 99)
23	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
24	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
25	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
26	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 129)
27	Symfony\Component\HttpKernel\HttpKernel->handleThrowable (line 241)
28	Symfony\Component\HttpKernel\HttpKernel->handle (line 91)
29	Symfony\Component\HttpKernel\Kernel->handle (line 193)
30	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
31	require_once (line 32)
32	require_once (line 5)

0.47 ms
(7.48%)

SELECT TABLE_NAME,
       INDEX_NAME,
       INDEX_TYPE,
       NON_UNIQUE,
       COLUMN_NAME,
       SUB_PART
FROM information_schema.STATISTICS
WHERE TABLE_SCHEMA = ? AND TABLE_NAME = ?
  AND INDEX_NAME != 'PRIMARY'
ORDER BY TABLE_NAME,
    SEQ_IN_INDEX

Parameters:

[
  "docker_admin"
  "doctrine_migration_versions"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  TABLE_NAME,
  INDEX_NAME,
  INDEX_TYPE,
  NON_UNIQUE,
  COLUMN_NAME,
  SUB_PART
FROM
  information_schema.STATISTICS
WHERE
  TABLE_SCHEMA = ?
  AND TABLE_NAME = ?
  AND INDEX_NAME != 'PRIMARY'
ORDER BY
  TABLE_NAME,
  SEQ_IN_INDEX

SELECT TABLE_NAME,
       INDEX_NAME,
       INDEX_TYPE,
       NON_UNIQUE,
       COLUMN_NAME,
       SUB_PART
FROM information_schema.STATISTICS
WHERE TABLE_SCHEMA = 'docker_admin' AND TABLE_NAME = 'doctrine_migration_versions'
  AND INDEX_NAME != 'PRIMARY'
ORDER BY TABLE_NAME,
    SEQ_IN_INDEX;

#	File/Call
1	Sentry\SentryBundle\Tracing\Doctrine\DBAL\TracingStatementForV4->execute (line 36)
2	Doctrine\DBAL\Connection->executeQuery (line 802)
3	Doctrine\DBAL\Connection->iterateNumeric (line 685)
4	Doctrine\DBAL\Platforms\MySQL\MySQLMetadataProvider->getIndexColumns (line 402)
5	Doctrine\DBAL\Schema\Introspection\IntrospectingSchemaProvider->getIndexesForTable (line 193)
6	Doctrine\DBAL\Schema\AbstractSchemaManager->{closure:Doctrine\DBAL\Schema\AbstractSchemaManager::introspectTableIndexes():783} (line 784)
7	Doctrine\DBAL\Schema\AbstractSchemaManager::introspectTableObjects (line 937)
8	Doctrine\DBAL\Schema\AbstractSchemaManager->introspectTableIndexes (line 781)
9	Doctrine\DBAL\Schema\AbstractSchemaManager->introspectTable0 (line 671)
10	Doctrine\DBAL\Schema\AbstractSchemaManager->introspectTableByUnquotedName (line 688)
11	Doctrine\Migrations\Metadata\Storage\TableMetadataStorage->needsUpdate (line 223)
12	Doctrine\Migrations\Metadata\Storage\TableMetadataStorage->checkInitialization (line 256)
13	Doctrine\Migrations\Metadata\Storage\TableMetadataStorage->getExecutedMigrations (line 84)
14	Doctrine\Bundle\MigrationsBundle\Collector\MigrationsCollector->collect (line 44)
15	Symfony\Component\HttpKernel\Profiler\Profiler->collect (line 158)
16	Symfony\Component\HttpKernel\EventListener\ProfilerListener->onKernelResponse (line 102)
17	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
18	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
19	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
20	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 129)
21	Symfony\Component\HttpKernel\HttpKernel->filterResponse (line 216)
22	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 204)
23	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
24	Symfony\Component\HttpKernel\EventListener\ErrorListener->onKernelException (line 99)
25	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
26	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
27	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
28	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 129)
29	Symfony\Component\HttpKernel\HttpKernel->handleThrowable (line 241)
30	Symfony\Component\HttpKernel\HttpKernel->handle (line 91)
31	Symfony\Component\HttpKernel\Kernel->handle (line 193)
32	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
33	require_once (line 32)
34	require_once (line 5)

0.19 ms
(3.06%)

SELECT @@character_set_database, @@collation_database

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  @@character_set_database,
  @@collation_database

SELECT @@character_set_database, @@collation_database;

#	File/Call
1	Sentry\SentryBundle\Tracing\Doctrine\DBAL\TracingDriverConnectionForV4->traceFunction (line 246)
2	Sentry\SentryBundle\Tracing\Doctrine\DBAL\TracingDriverConnectionForV4->query (line 117)
3	Doctrine\DBAL\Connection->executeQuery (line 804)
4	Doctrine\DBAL\Connection->fetchNumeric (line 316)
5	Doctrine\DBAL\Schema\MySQLSchemaManager->getDefaultTableOptions (line 534)
6	Doctrine\DBAL\Schema\MySQLSchemaManager->createComparator (line 345)
7	Doctrine\Migrations\Metadata\Storage\TableMetadataStorage->needsUpdate (line 208)
8	Doctrine\Migrations\Metadata\Storage\TableMetadataStorage->checkInitialization (line 256)
9	Doctrine\Migrations\Metadata\Storage\TableMetadataStorage->getExecutedMigrations (line 84)
10	Doctrine\Bundle\MigrationsBundle\Collector\MigrationsCollector->collect (line 44)
11	Symfony\Component\HttpKernel\Profiler\Profiler->collect (line 158)
12	Symfony\Component\HttpKernel\EventListener\ProfilerListener->onKernelResponse (line 102)
13	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
14	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
15	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
16	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 129)
17	Symfony\Component\HttpKernel\HttpKernel->filterResponse (line 216)
18	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 204)
19	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
20	Symfony\Component\HttpKernel\EventListener\ErrorListener->onKernelException (line 99)
21	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
22	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
23	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
24	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 129)
25	Symfony\Component\HttpKernel\HttpKernel->handleThrowable (line 241)
26	Symfony\Component\HttpKernel\HttpKernel->handle (line 91)
27	Symfony\Component\HttpKernel\Kernel->handle (line 193)
28	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
29	require_once (line 32)
30	require_once (line 5)

0.19 ms
(2.96%)

SELECT * FROM doctrine_migration_versions

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  *
FROM
  doctrine_migration_versions

SELECT * FROM doctrine_migration_versions;

#	File/Call
1	Sentry\SentryBundle\Tracing\Doctrine\DBAL\TracingDriverConnectionForV4->traceFunction (line 246)
2	Sentry\SentryBundle\Tracing\Doctrine\DBAL\TracingDriverConnectionForV4->query (line 117)
3	Doctrine\DBAL\Connection->executeQuery (line 804)
4	Doctrine\DBAL\Connection->fetchAllAssociative (line 622)
5	Doctrine\Migrations\Metadata\Storage\TableMetadataStorage->getExecutedMigrations (line 85)
6	Doctrine\Bundle\MigrationsBundle\Collector\MigrationsCollector->collect (line 44)
7	Symfony\Component\HttpKernel\Profiler\Profiler->collect (line 158)
8	Symfony\Component\HttpKernel\EventListener\ProfilerListener->onKernelResponse (line 102)
9	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
10	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
11	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
12	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 129)
13	Symfony\Component\HttpKernel\HttpKernel->filterResponse (line 216)
14	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 204)
15	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
16	Symfony\Component\HttpKernel\EventListener\ErrorListener->onKernelException (line 99)
17	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
18	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
19	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
20	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 129)
21	Symfony\Component\HttpKernel\HttpKernel->handleThrowable (line 241)
22	Symfony\Component\HttpKernel\HttpKernel->handle (line 91)
23	Symfony\Component\HttpKernel\Kernel->handle (line 193)
24	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
25	require_once (line 32)
26	require_once (line 5)

Database Connections

Name	Service
organisation	doctrine.dbal.organisation_connection
commun	doctrine.dbal.commun_connection

Entity Managers

Name	Service
organisation	doctrine.orm.organisation_entity_manager
commun	doctrine.orm.commun_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

organisation entity manager

Class	Amount of managed objects

commun entity manager

Class	Amount of managed objects

Symfony Profiler

GET https://semnoz.loic.allsoftware.work/sitemap.xml

Query Metrics

Grouped Statements

organisation connection

Database Connections

Entity Managers

Second Level Cache

Managed Entities

organisation entity manager

commun entity manager

Entities Mapping

organisation entity manager

commun entity manager

Symfony Profiler

GET https://semnoz.loic.allsoftware.work/sitemap.xml

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

organisation connection

Database Connections

Entity Managers

Second Level Cache

Managed Entities

organisation entity manager

commun entity manager

Entities Mapping

organisation entity manager

commun entity manager