Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

24 Database Queries

6 Different statements

2.32 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

1.25 ms
(0.00%)

SELECT name FROM sqlite_master WHERE type = 'table' AND name != 'sqlite_sequence' AND name != 'geometry_columns' AND name != 'spatial_ref_sys' UNION ALL SELECT name FROM sqlite_temp_master WHERE type = 'table' ORDER BY name

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  name
FROM
  sqlite_master
WHERE
  type = 'table'
  AND name != 'sqlite_sequence'
  AND name != 'geometry_columns'
  AND name != 'spatial_ref_sys'
UNION ALL
SELECT
  name
FROM
  sqlite_temp_master
WHERE
  type = 'table'
ORDER BY
  name

SELECT name FROM sqlite_master WHERE type = 'table' AND name != 'sqlite_sequence' AND name != 'geometry_columns' AND name != 'spatial_ref_sys' UNION ALL SELECT name FROM sqlite_temp_master WHERE type = 'table' ORDER BY name;

#	File/Call
1	Doctrine\DBAL\Logging\LoggerChain->startQuery (line 1293)
2	Doctrine\DBAL\Connection->executeQuery (line 1041)
3	Doctrine\DBAL\Connection->fetchAllAssociative (line 225)
4	Doctrine\DBAL\Schema\AbstractSchemaManager->listTableNames (line 213)
5	Doctrine\DBAL\Schema\AbstractSchemaManager->tablesExist (line 204)
6	Doctrine\Migrations\Metadata\Storage\TableMetadataStorage->isInitialized (line 85)
7	Doctrine\Migrations\Metadata\Storage\TableMetadataStorage->getExecutedMigrations (line 32)
8	Doctrine\Bundle\MigrationsBundle\Collector\MigrationsCollector->collect (line 161)
9	Symfony\Component\HttpKernel\Profiler\Profiler->collect (line 89)
10	Symfony\Component\HttpKernel\EventListener\ProfilerListener->onKernelResponse (line 117)
11	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 230)
12	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 59)
13	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 151)
14	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 189)
15	Symfony\Component\HttpKernel\HttpKernel->filterResponse (line 177)
16	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 78)
17	Symfony\Component\HttpKernel\HttpKernel->handle (line 60)
18	Symfony\Component\HttpKernel\EventListener\ErrorListener->onKernelException (line 117)
19	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 230)
20	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 59)
21	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 151)
22	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 217)
23	Symfony\Component\HttpKernel\HttpKernel->handleThrowable (line 89)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 199)
25	Symfony\Component\HttpKernel\Kernel->handle (line 37)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
27	require_once (line 5)

0.53 ms
(0.00%)

SELECT sql
  FROM (
      SELECT *
        FROM sqlite_master
   UNION ALL
      SELECT *
        FROM sqlite_temp_master
  )
WHERE type = 'table'
AND name = ?

Parameters:

[
  "migration_versions"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  sql
FROM
  (
    SELECT
      *
    FROM
      sqlite_master
    UNION ALL
    SELECT
      *
    FROM
      sqlite_temp_master
  )
WHERE
  type = 'table'
  AND name = ?

SELECT sql
  FROM (
      SELECT *
        FROM sqlite_master
   UNION ALL
      SELECT *
        FROM sqlite_temp_master
  )
WHERE type = 'table'
AND name = 'migration_versions';

#	File/Call
1	Doctrine\DBAL\Logging\LoggerChain->startQuery (line 1293)
2	Doctrine\DBAL\Connection->executeQuery (line 664)
3	Doctrine\DBAL\Connection->fetchColumn (line 554)
4	Doctrine\DBAL\Schema\SqliteSchemaManager->getCreateTableSQL (line 288)
5	Doctrine\DBAL\Schema\SqliteSchemaManager->_getPortableTableColumnList (line 170)
6	Doctrine\DBAL\Schema\AbstractSchemaManager->listTableColumns (line 283)
7	Doctrine\DBAL\Schema\AbstractSchemaManager->listTableDetails (line 563)
8	Doctrine\DBAL\Schema\SqliteSchemaManager->listTableDetails (line 188)
9	Doctrine\Migrations\Metadata\Storage\TableMetadataStorage->needsUpdate (line 215)
10	Doctrine\Migrations\Metadata\Storage\TableMetadataStorage->checkInitialization (line 89)
11	Doctrine\Migrations\Metadata\Storage\TableMetadataStorage->getExecutedMigrations (line 32)
12	Doctrine\Bundle\MigrationsBundle\Collector\MigrationsCollector->collect (line 161)
13	Symfony\Component\HttpKernel\Profiler\Profiler->collect (line 89)
14	Symfony\Component\HttpKernel\EventListener\ProfilerListener->onKernelResponse (line 117)
15	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 230)
16	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 59)
17	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 151)
18	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 189)
19	Symfony\Component\HttpKernel\HttpKernel->filterResponse (line 177)
20	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 78)
21	Symfony\Component\HttpKernel\HttpKernel->handle (line 60)
22	Symfony\Component\HttpKernel\EventListener\ErrorListener->onKernelException (line 117)
23	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 230)
24	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 59)
25	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 151)
26	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 217)
27	Symfony\Component\HttpKernel\HttpKernel->handleThrowable (line 89)
28	Symfony\Component\HttpKernel\HttpKernel->handle (line 199)
29	Symfony\Component\HttpKernel\Kernel->handle (line 37)
30	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
31	require_once (line 5)

0.15 ms
(0.00%)

PRAGMA index_list('migration_versions')

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

PRAGMA index_list('migration_versions')

PRAGMA index_list('migration_versions');

#	File/Call
1	Doctrine\DBAL\Logging\LoggerChain->startQuery (line 1293)
2	Doctrine\DBAL\Connection->executeQuery (line 1041)
3	Doctrine\DBAL\Connection->fetchAllAssociative (line 186)
4	Doctrine\DBAL\Schema\AbstractSchemaManager->listTableIndexes (line 289)
5	Doctrine\DBAL\Schema\AbstractSchemaManager->listTableDetails (line 563)
6	Doctrine\DBAL\Schema\SqliteSchemaManager->listTableDetails (line 188)
7	Doctrine\Migrations\Metadata\Storage\TableMetadataStorage->needsUpdate (line 215)
8	Doctrine\Migrations\Metadata\Storage\TableMetadataStorage->checkInitialization (line 89)
9	Doctrine\Migrations\Metadata\Storage\TableMetadataStorage->getExecutedMigrations (line 32)
10	Doctrine\Bundle\MigrationsBundle\Collector\MigrationsCollector->collect (line 161)
11	Symfony\Component\HttpKernel\Profiler\Profiler->collect (line 89)
12	Symfony\Component\HttpKernel\EventListener\ProfilerListener->onKernelResponse (line 117)
13	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 230)
14	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 59)
15	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 151)
16	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 189)
17	Symfony\Component\HttpKernel\HttpKernel->filterResponse (line 177)
18	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 78)
19	Symfony\Component\HttpKernel\HttpKernel->handle (line 60)
20	Symfony\Component\HttpKernel\EventListener\ErrorListener->onKernelException (line 117)
21	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 230)
22	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 59)
23	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 151)
24	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 217)
25	Symfony\Component\HttpKernel\HttpKernel->handleThrowable (line 89)
26	Symfony\Component\HttpKernel\HttpKernel->handle (line 199)
27	Symfony\Component\HttpKernel\Kernel->handle (line 37)
28	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
29	require_once (line 5)

0.15 ms
(0.00%)

PRAGMA table_info('migration_versions')

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

PRAGMA table_info('migration_versions')

PRAGMA table_info('migration_versions');

#	File/Call
1	Doctrine\DBAL\Logging\LoggerChain->startQuery (line 1293)
2	Doctrine\DBAL\Connection->executeQuery (line 1041)
3	Doctrine\DBAL\Connection->fetchAllAssociative (line 168)
4	Doctrine\DBAL\Schema\AbstractSchemaManager->listTableColumns (line 283)
5	Doctrine\DBAL\Schema\AbstractSchemaManager->listTableDetails (line 563)
6	Doctrine\DBAL\Schema\SqliteSchemaManager->listTableDetails (line 188)
7	Doctrine\Migrations\Metadata\Storage\TableMetadataStorage->needsUpdate (line 215)
8	Doctrine\Migrations\Metadata\Storage\TableMetadataStorage->checkInitialization (line 89)
9	Doctrine\Migrations\Metadata\Storage\TableMetadataStorage->getExecutedMigrations (line 32)
10	Doctrine\Bundle\MigrationsBundle\Collector\MigrationsCollector->collect (line 161)
11	Symfony\Component\HttpKernel\Profiler\Profiler->collect (line 89)
12	Symfony\Component\HttpKernel\EventListener\ProfilerListener->onKernelResponse (line 117)
13	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 230)
14	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 59)
15	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 151)
16	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 189)
17	Symfony\Component\HttpKernel\HttpKernel->filterResponse (line 177)
18	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 78)
19	Symfony\Component\HttpKernel\HttpKernel->handle (line 60)
20	Symfony\Component\HttpKernel\EventListener\ErrorListener->onKernelException (line 117)
21	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 230)
22	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 59)
23	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 151)
24	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 217)
25	Symfony\Component\HttpKernel\HttpKernel->handleThrowable (line 89)
26	Symfony\Component\HttpKernel\HttpKernel->handle (line 199)
27	Symfony\Component\HttpKernel\Kernel->handle (line 37)
28	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
29	require_once (line 5)

0.15 ms
(0.00%)

SELECT * FROM migration_versions

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  *
FROM
  migration_versions

SELECT * FROM migration_versions;

#	File/Call
1	Doctrine\DBAL\Logging\LoggerChain->startQuery (line 1293)
2	Doctrine\DBAL\Connection->executeQuery (line 1041)
3	Doctrine\DBAL\Connection->fetchAllAssociative (line 90)
4	Doctrine\Migrations\Metadata\Storage\TableMetadataStorage->getExecutedMigrations (line 32)
5	Doctrine\Bundle\MigrationsBundle\Collector\MigrationsCollector->collect (line 161)
6	Symfony\Component\HttpKernel\Profiler\Profiler->collect (line 89)
7	Symfony\Component\HttpKernel\EventListener\ProfilerListener->onKernelResponse (line 117)
8	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 230)
9	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 59)
10	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 151)
11	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 189)
12	Symfony\Component\HttpKernel\HttpKernel->filterResponse (line 177)
13	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 78)
14	Symfony\Component\HttpKernel\HttpKernel->handle (line 60)
15	Symfony\Component\HttpKernel\EventListener\ErrorListener->onKernelException (line 117)
16	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 230)
17	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 59)
18	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 151)
19	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 217)
20	Symfony\Component\HttpKernel\HttpKernel->handleThrowable (line 89)
21	Symfony\Component\HttpKernel\HttpKernel->handle (line 199)
22	Symfony\Component\HttpKernel\Kernel->handle (line 37)
23	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
24	require_once (line 5)

0.09 ms
(0.00%)

PRAGMA TABLE_INFO ('migration_versions')

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

PRAGMA TABLE_INFO ('migration_versions')

PRAGMA TABLE_INFO ('migration_versions');

#	File/Call
1	Doctrine\DBAL\Logging\LoggerChain->startQuery (line 1293)
2	Doctrine\DBAL\Connection->executeQuery (line 1041)
3	Doctrine\DBAL\Connection->fetchAllAssociative (line 180)
4	Doctrine\DBAL\Schema\SqliteSchemaManager->_getPortableTableIndexesList (line 188)
5	Doctrine\DBAL\Schema\AbstractSchemaManager->listTableIndexes (line 289)
6	Doctrine\DBAL\Schema\AbstractSchemaManager->listTableDetails (line 563)
7	Doctrine\DBAL\Schema\SqliteSchemaManager->listTableDetails (line 188)
8	Doctrine\Migrations\Metadata\Storage\TableMetadataStorage->needsUpdate (line 215)
9	Doctrine\Migrations\Metadata\Storage\TableMetadataStorage->checkInitialization (line 89)
10	Doctrine\Migrations\Metadata\Storage\TableMetadataStorage->getExecutedMigrations (line 32)
11	Doctrine\Bundle\MigrationsBundle\Collector\MigrationsCollector->collect (line 161)
12	Symfony\Component\HttpKernel\Profiler\Profiler->collect (line 89)
13	Symfony\Component\HttpKernel\EventListener\ProfilerListener->onKernelResponse (line 117)
14	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 230)
15	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 59)
16	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 151)
17	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 189)
18	Symfony\Component\HttpKernel\HttpKernel->filterResponse (line 177)
19	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 78)
20	Symfony\Component\HttpKernel\HttpKernel->handle (line 60)
21	Symfony\Component\HttpKernel\EventListener\ErrorListener->onKernelException (line 117)
22	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 230)
23	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 59)
24	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 151)
25	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 217)
26	Symfony\Component\HttpKernel\HttpKernel->handleThrowable (line 89)
27	Symfony\Component\HttpKernel\HttpKernel->handle (line 199)
28	Symfony\Component\HttpKernel\Kernel->handle (line 37)
29	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
30	require_once (line 5)

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\Base\AbstractDBElement	No errors.
App\Entity\LogSystem\AbstractLogEntry	No errors.
App\Entity\Base\AbstractNamedDBElement	No errors.
App\Entity\Attachments\AttachmentContainingDBElement	No errors.
App\Entity\UserSystem\PermissionsEmbed	No errors.
App\Entity\UserSystem\User	No errors.

Symfony Profiler

https://sklad.pernicka.cz/en/robots.txt

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping