Symfony Profiler

Query Metrics

15 Database Queries

9 Different statements

18.07 ms Query time

3 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

5.05 ms
(27.96%)

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

Parameters:

[
  "ichron_demo"
]

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 = 'ichron_demo'
  AND TABLE_TYPE = 'BASE TABLE'
ORDER BY TABLE_NAME;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 435)
2	Doctrine\DBAL\Schema\MySQLSchemaManager->selectTableNames (line 356)
3	Doctrine\DBAL\Schema\AbstractSchemaManager->doListTableNames (line 58)
4	Doctrine\DBAL\Schema\MySQLSchemaManager->listTableNames (line 325)
5	Doctrine\DBAL\Schema\AbstractSchemaManager->tablesExist (line 215)
6	Doctrine\Migrations\Metadata\Storage\TableMetadataStorage->isInitialized (line 72)
7	Doctrine\Migrations\Metadata\Storage\TableMetadataStorage->getExecutedMigrations (line 43)
8	Doctrine\Bundle\MigrationsBundle\Collector\MigrationsCollector->collect (line 158)
9	Symfony\Component\HttpKernel\Profiler\Profiler->collect (line 102)
10	Symfony\Component\HttpKernel\EventListener\ProfilerListener->onKernelResponse (line 115)
11	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
12	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
13	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
14	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 216)
15	Symfony\Component\HttpKernel\HttpKernel->filterResponse (line 204)
16	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
17	Symfony\Component\HttpKernel\HttpKernel->handle (line 97)
18	Symfony\Component\HttpKernel\EventListener\ErrorListener->onKernelException (line 115)
19	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
20	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
21	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
22	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 241)
23	Symfony\Component\HttpKernel\HttpKernel->handleThrowable (line 91)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
25	Symfony\Component\HttpKernel\Kernel->handle (line 20)

3.65 ms
(20.18%)

SELECT DISTINCT            k.CONSTRAINT_NAME,
            k.COLUMN_NAME,
            k.REFERENCED_TABLE_NAME,
            k.REFERENCED_COLUMN_NAME,
            k.ORDINAL_POSITION /*!50116,
            c.UPDATE_RULE,
            c.DELETE_RULE */
FROM information_schema.key_column_usage k /*!50116
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 k.TABLE_NAME = ? AND k.REFERENCED_COLUMN_NAME IS NOT NULL /*!50116 AND c.CONSTRAINT_SCHEMA = 'ichron_demo' */ ORDER BY k.ORDINAL_POSITION

Parameters:

[
  "ichron_demo"
  "doctrine_migration_versions"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT k.CONSTRAINT_NAME,
  k.COLUMN_NAME,
  k.REFERENCED_TABLE_NAME,
  k.REFERENCED_COLUMN_NAME,
  k.ORDINAL_POSITION
  /*!50116,
              c.UPDATE_RULE,
              c.DELETE_RULE */
FROM
  information_schema.key_column_usage k
  /*!50116
  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 k.TABLE_NAME = ?
  AND k.REFERENCED_COLUMN_NAME IS NOT NULL
  /*!50116 AND c.CONSTRAINT_SCHEMA = 'ichron_demo' */
ORDER BY
  k.ORDINAL_POSITION

SELECT DISTINCT            k.CONSTRAINT_NAME,
            k.COLUMN_NAME,
            k.REFERENCED_TABLE_NAME,
            k.REFERENCED_COLUMN_NAME,
            k.ORDINAL_POSITION /*!50116,
            c.UPDATE_RULE,
            c.DELETE_RULE */
FROM information_schema.key_column_usage k /*!50116
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 = 'ichron_demo' AND k.TABLE_NAME = 'doctrine_migration_versions' AND k.REFERENCED_COLUMN_NAME IS NOT NULL /*!50116 AND c.CONSTRAINT_SCHEMA = 'ichron_demo' */ ORDER BY k.ORDINAL_POSITION;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 552)
2	Doctrine\DBAL\Schema\MySQLSchemaManager->selectForeignKeyColumns (line 688)
3	Doctrine\DBAL\Schema\AbstractSchemaManager->doListTableForeignKeys (line 107)
4	Doctrine\DBAL\Schema\MySQLSchemaManager->listTableForeignKeys (line 478)
5	Doctrine\DBAL\Schema\AbstractSchemaManager->doListTableDetails (line 83)
6	Doctrine\DBAL\Schema\MySQLSchemaManager->listTableDetails (line 614)
7	Doctrine\DBAL\Schema\AbstractSchemaManager->introspectTable (line 199)
8	Doctrine\Migrations\Metadata\Storage\TableMetadataStorage->needsUpdate (line 226)
9	Doctrine\Migrations\Metadata\Storage\TableMetadataStorage->checkInitialization (line 76)
10	Doctrine\Migrations\Metadata\Storage\TableMetadataStorage->getExecutedMigrations (line 43)
11	Doctrine\Bundle\MigrationsBundle\Collector\MigrationsCollector->collect (line 158)
12	Symfony\Component\HttpKernel\Profiler\Profiler->collect (line 102)
13	Symfony\Component\HttpKernel\EventListener\ProfilerListener->onKernelResponse (line 115)
14	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
15	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
16	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
17	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 216)
18	Symfony\Component\HttpKernel\HttpKernel->filterResponse (line 204)
19	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
20	Symfony\Component\HttpKernel\HttpKernel->handle (line 97)
21	Symfony\Component\HttpKernel\EventListener\ErrorListener->onKernelException (line 115)
22	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
23	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
24	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
25	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 241)
26	Symfony\Component\HttpKernel\HttpKernel->handleThrowable (line 91)
27	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
28	Symfony\Component\HttpKernel\Kernel->handle (line 20)

2.83 ms
(15.66%)

SELECT       c.COLUMN_NAME        AS field,
           IF(
        c.COLUMN_TYPE = 'longtext'
        AND EXISTS(
            SELECT * from information_schema.CHECK_CONSTRAINTS i_c
            WHERE i_c.CONSTRAINT_SCHEMA = 'ichron_demo'
            AND i_c.TABLE_NAME = c.TABLE_NAME
            AND i_c.CHECK_CLAUSE = CONCAT(
                'json_valid(`',
                    c.COLUMN_NAME,
                '`)'
            )
        ),
        'json',
        c.COLUMN_TYPE
    )       AS type,
       c.IS_NULLABLE        AS `null`,
       c.COLUMN_KEY         AS `key`,
       c.COLUMN_DEFAULT     AS `default`,
       c.EXTRA,
       c.COLUMN_COMMENT     AS comment,
       c.CHARACTER_SET_NAME AS characterset,
       c.COLLATION_NAME     AS collation
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_TYPE = 'BASE TABLE' AND t.TABLE_NAME = ? ORDER BY ORDINAL_POSITION

Parameters:

[
  "ichron_demo"
  "ichron_demo"
  "doctrine_migration_versions"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  c.COLUMN_NAME AS field,
  IF(
    c.COLUMN_TYPE = 'longtext'
    AND EXISTS(
      SELECT
        *
      from
        information_schema.CHECK_CONSTRAINTS i_c
      WHERE
        i_c.CONSTRAINT_SCHEMA = 'ichron_demo'
        AND i_c.TABLE_NAME = c.TABLE_NAME
        AND i_c.CHECK_CLAUSE = CONCAT(
          'json_valid(`', c.COLUMN_NAME, '`)'
        )
    ),
    'json',
    c.COLUMN_TYPE
  ) AS type,
  c.IS_NULLABLE AS `null`,
  c.COLUMN_KEY AS `key`,
  c.COLUMN_DEFAULT AS `default`,
  c.EXTRA,
  c.COLUMN_COMMENT AS comment,
  c.CHARACTER_SET_NAME AS characterset,
  c.COLLATION_NAME AS collation
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_TYPE = 'BASE TABLE'
  AND t.TABLE_NAME = ?
ORDER BY
  ORDINAL_POSITION

SELECT       c.COLUMN_NAME        AS field,
           IF(
        c.COLUMN_TYPE = 'longtext'
        AND EXISTS(
            SELECT * from information_schema.CHECK_CONSTRAINTS i_c
            WHERE i_c.CONSTRAINT_SCHEMA = 'ichron_demo'
            AND i_c.TABLE_NAME = c.TABLE_NAME
            AND i_c.CHECK_CLAUSE = CONCAT(
                'json_valid(`',
                    c.COLUMN_NAME,
                '`)'
            )
        ),
        'json',
        c.COLUMN_TYPE
    )       AS type,
       c.IS_NULLABLE        AS `null`,
       c.COLUMN_KEY         AS `key`,
       c.COLUMN_DEFAULT     AS `default`,
       c.EXTRA,
       c.COLUMN_COMMENT     AS comment,
       c.CHARACTER_SET_NAME AS characterset,
       c.COLLATION_NAME     AS collation
FROM information_schema.COLUMNS c
    INNER JOIN information_schema.TABLES t
        ON t.TABLE_NAME = c.TABLE_NAME
     WHERE c.TABLE_SCHEMA = 'ichron_demo' AND t.TABLE_SCHEMA = 'ichron_demo' AND t.TABLE_TYPE = 'BASE TABLE' AND t.TABLE_NAME = 'doctrine_migration_versions' ORDER BY ORDINAL_POSITION;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 478)
2	Doctrine\DBAL\Schema\MySQLSchemaManager->selectTableColumns (line 255)
3	Doctrine\DBAL\Schema\AbstractSchemaManager->doListTableColumns (line 91)
4	Doctrine\DBAL\Schema\MySQLSchemaManager->listTableColumns (line 485)
5	Doctrine\DBAL\Schema\AbstractSchemaManager->doListTableDetails (line 83)
6	Doctrine\DBAL\Schema\MySQLSchemaManager->listTableDetails (line 614)
7	Doctrine\DBAL\Schema\AbstractSchemaManager->introspectTable (line 199)
8	Doctrine\Migrations\Metadata\Storage\TableMetadataStorage->needsUpdate (line 226)
9	Doctrine\Migrations\Metadata\Storage\TableMetadataStorage->checkInitialization (line 76)
10	Doctrine\Migrations\Metadata\Storage\TableMetadataStorage->getExecutedMigrations (line 43)
11	Doctrine\Bundle\MigrationsBundle\Collector\MigrationsCollector->collect (line 158)
12	Symfony\Component\HttpKernel\Profiler\Profiler->collect (line 102)
13	Symfony\Component\HttpKernel\EventListener\ProfilerListener->onKernelResponse (line 115)
14	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
15	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
16	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
17	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 216)
18	Symfony\Component\HttpKernel\HttpKernel->filterResponse (line 204)
19	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
20	Symfony\Component\HttpKernel\HttpKernel->handle (line 97)
21	Symfony\Component\HttpKernel\EventListener\ErrorListener->onKernelException (line 115)
22	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
23	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
24	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
25	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 241)
26	Symfony\Component\HttpKernel\HttpKernel->handleThrowable (line 91)
27	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
28	Symfony\Component\HttpKernel\Kernel->handle (line 20)

2.34 ms
(12.96%)

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.FULL_COLLATION_NAME = t.TABLE_COLLATION WHERE t.TABLE_SCHEMA = ? AND t.TABLE_NAME = ? AND t.TABLE_TYPE = 'BASE TABLE'

Parameters:

[
  "ichron_demo"
  "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.FULL_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.FULL_COLLATION_NAME = t.TABLE_COLLATION WHERE t.TABLE_SCHEMA = 'ichron_demo' AND t.TABLE_NAME = 'doctrine_migration_versions' AND t.TABLE_TYPE = 'BASE TABLE';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 568)
2	Doctrine\DBAL\Schema\MySQLSchemaManager->fetchTableOptionsByTable (line 475)
3	Doctrine\DBAL\Schema\AbstractSchemaManager->doListTableDetails (line 83)
4	Doctrine\DBAL\Schema\MySQLSchemaManager->listTableDetails (line 614)
5	Doctrine\DBAL\Schema\AbstractSchemaManager->introspectTable (line 199)
6	Doctrine\Migrations\Metadata\Storage\TableMetadataStorage->needsUpdate (line 226)
7	Doctrine\Migrations\Metadata\Storage\TableMetadataStorage->checkInitialization (line 76)
8	Doctrine\Migrations\Metadata\Storage\TableMetadataStorage->getExecutedMigrations (line 43)
9	Doctrine\Bundle\MigrationsBundle\Collector\MigrationsCollector->collect (line 158)
10	Symfony\Component\HttpKernel\Profiler\Profiler->collect (line 102)
11	Symfony\Component\HttpKernel\EventListener\ProfilerListener->onKernelResponse (line 115)
12	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
13	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
14	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
15	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 216)
16	Symfony\Component\HttpKernel\HttpKernel->filterResponse (line 204)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 97)
19	Symfony\Component\HttpKernel\EventListener\ErrorListener->onKernelException (line 115)
20	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
21	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
22	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
23	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 241)
24	Symfony\Component\HttpKernel\HttpKernel->handleThrowable (line 91)
25	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
26	Symfony\Component\HttpKernel\Kernel->handle (line 20)

1.71 ms
(9.45%)

SELECT DATABASE()

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  DATABASE()

SELECT DATABASE();

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 622)
2	Doctrine\DBAL\Connection->fetchOne (line 262)
3	Doctrine\DBAL\Connection->getDatabase (line 1778)
4	Doctrine\DBAL\Schema\AbstractSchemaManager->getDatabase (line 352)
5	Doctrine\DBAL\Schema\AbstractSchemaManager->doListTableNames (line 58)
6	Doctrine\DBAL\Schema\MySQLSchemaManager->listTableNames (line 325)
7	Doctrine\DBAL\Schema\AbstractSchemaManager->tablesExist (line 215)
8	Doctrine\Migrations\Metadata\Storage\TableMetadataStorage->isInitialized (line 72)
9	Doctrine\Migrations\Metadata\Storage\TableMetadataStorage->getExecutedMigrations (line 43)
10	Doctrine\Bundle\MigrationsBundle\Collector\MigrationsCollector->collect (line 158)
11	Symfony\Component\HttpKernel\Profiler\Profiler->collect (line 102)
12	Symfony\Component\HttpKernel\EventListener\ProfilerListener->onKernelResponse (line 115)
13	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
14	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
15	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
16	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 216)
17	Symfony\Component\HttpKernel\HttpKernel->filterResponse (line 204)
18	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
19	Symfony\Component\HttpKernel\HttpKernel->handle (line 97)
20	Symfony\Component\HttpKernel\EventListener\ErrorListener->onKernelException (line 115)
21	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
22	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
23	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
24	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 241)
25	Symfony\Component\HttpKernel\HttpKernel->handleThrowable (line 91)
26	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
27	Symfony\Component\HttpKernel\Kernel->handle (line 20)

1.20 ms
(6.65%)

SELECT c0_.id AS id_0, c0_.titolo AS titolo_1, c0_.nome AS nome_2, c0_.tipo AS tipo_3, c0_.gruppo AS gruppo_4, c0_.predefinito AS predefinito_5, c0_.valore AS valore_6, c0_.obbligatorio AS obbligatorio_7, c0_.descrizione AS descrizione_8, c0_.ordine AS ordine_9, c0_.data_eliminazione AS data_eliminazione_10, c0_.eliminato_da_id AS eliminato_da_id_11 FROM configurazione c0_ WHERE (c0_.nome = ?) AND (c0_.data_eliminazione IS NULL)

Parameters:

[
  "white_black_list"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  c0_.id AS id_0,
  c0_.titolo AS titolo_1,
  c0_.nome AS nome_2,
  c0_.tipo AS tipo_3,
  c0_.gruppo AS gruppo_4,
  c0_.predefinito AS predefinito_5,
  c0_.valore AS valore_6,
  c0_.obbligatorio AS obbligatorio_7,
  c0_.descrizione AS descrizione_8,
  c0_.ordine AS ordine_9,
  c0_.data_eliminazione AS data_eliminazione_10,
  c0_.eliminato_da_id AS eliminato_da_id_11
FROM
  configurazione c0_
WHERE
  (c0_.nome = ?)
  AND (c0_.data_eliminazione IS NULL)

SELECT c0_.id AS id_0, c0_.titolo AS titolo_1, c0_.nome AS nome_2, c0_.tipo AS tipo_3, c0_.gruppo AS gruppo_4, c0_.predefinito AS predefinito_5, c0_.valore AS valore_6, c0_.obbligatorio AS obbligatorio_7, c0_.descrizione AS descrizione_8, c0_.ordine AS ordine_9, c0_.data_eliminazione AS data_eliminazione_10, c0_.eliminato_da_id AS eliminato_da_id_11 FROM configurazione c0_ WHERE (c0_.nome = 'white_black_list') AND (c0_.data_eliminazione IS NULL);

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 33)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 327)
3	Doctrine\ORM\Query->_doExecute (line 1212)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1166)
5	Doctrine\ORM\AbstractQuery->execute (line 953)
6	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 29)
7	App\Repository\ConfigurazioneRepository->findByName (line 34)
8	App\EventListener\IpCheck->onKernelRequest (line 115)
9	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
10	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
11	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
12	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 159)
13	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
14	Symfony\Component\HttpKernel\HttpKernel->handle (line 97)
15	Symfony\Component\HttpKernel\EventListener\ErrorListener->onKernelException (line 115)
16	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
17	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
18	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
19	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 241)
20	Symfony\Component\HttpKernel\HttpKernel->handleThrowable (line 91)
21	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
22	Symfony\Component\HttpKernel\Kernel->handle (line 20)

0.50 ms
(2.78%)

SELECT t0.id AS id_1, t0.ip AS ip_2, t0.data_eliminazione AS data_eliminazione_3, t0.eliminato_da_id AS eliminato_da_id_4 FROM white_black_list t0 WHERE ((t0.data_eliminazione IS NULL))

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.ip AS ip_2,
  t0.data_eliminazione AS data_eliminazione_3,
  t0.eliminato_da_id AS eliminato_da_id_4
FROM
  white_black_list t0
WHERE
  (
    (t0.data_eliminazione IS NULL)
  )

SELECT t0.id AS id_1, t0.ip AS ip_2, t0.data_eliminazione AS data_eliminazione_3, t0.eliminato_da_id AS eliminato_da_id_4 FROM white_black_list t0 WHERE ((t0.data_eliminazione IS NULL));

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 969)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 225)
3	Doctrine\ORM\EntityRepository->findBy (line 207)
4	Doctrine\ORM\EntityRepository->findAll (line 35)
5	App\EventListener\IpCheck->onKernelRequest (line 115)
6	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
7	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
8	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
9	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 159)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 97)
12	Symfony\Component\HttpKernel\EventListener\ErrorListener->onKernelException (line 115)
13	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
14	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
15	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
16	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 241)
17	Symfony\Component\HttpKernel\HttpKernel->handleThrowable (line 91)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
19	Symfony\Component\HttpKernel\Kernel->handle (line 20)

0.50 ms
(2.76%)

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	Doctrine\DBAL\Connection->executeQuery (line 902)
2	Doctrine\DBAL\Connection->fetchAllAssociative (line 77)
3	Doctrine\Migrations\Metadata\Storage\TableMetadataStorage->getExecutedMigrations (line 43)
4	Doctrine\Bundle\MigrationsBundle\Collector\MigrationsCollector->collect (line 158)
5	Symfony\Component\HttpKernel\Profiler\Profiler->collect (line 102)
6	Symfony\Component\HttpKernel\EventListener\ProfilerListener->onKernelResponse (line 115)
7	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
8	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
9	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
10	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 216)
11	Symfony\Component\HttpKernel\HttpKernel->filterResponse (line 204)
12	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
13	Symfony\Component\HttpKernel\HttpKernel->handle (line 97)
14	Symfony\Component\HttpKernel\EventListener\ErrorListener->onKernelException (line 115)
15	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
16	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
17	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
18	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 241)
19	Symfony\Component\HttpKernel\HttpKernel->handleThrowable (line 91)
20	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
21	Symfony\Component\HttpKernel\Kernel->handle (line 20)

0.29 ms
(1.60%)

SELECT        NON_UNIQUE  AS Non_Unique,
        INDEX_NAME  AS Key_name,
        COLUMN_NAME AS Column_Name,
        SUB_PART    AS Sub_Part,
        INDEX_TYPE  AS Index_Type
FROM information_schema.STATISTICS WHERE TABLE_SCHEMA = ? AND TABLE_NAME = ? ORDER BY SEQ_IN_INDEX

Parameters:

[
  "ichron_demo"
  "doctrine_migration_versions"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  NON_UNIQUE AS Non_Unique,
  INDEX_NAME AS Key_name,
  COLUMN_NAME AS Column_Name,
  SUB_PART AS Sub_Part,
  INDEX_TYPE AS Index_Type
FROM
  information_schema.STATISTICS
WHERE
  TABLE_SCHEMA = ?
  AND TABLE_NAME = ?
ORDER BY
  SEQ_IN_INDEX

SELECT        NON_UNIQUE  AS Non_Unique,
        INDEX_NAME  AS Key_name,
        COLUMN_NAME AS Column_Name,
        SUB_PART    AS Sub_Part,
        INDEX_TYPE  AS Index_Type
FROM information_schema.STATISTICS WHERE TABLE_SCHEMA = 'ichron_demo' AND TABLE_NAME = 'doctrine_migration_versions' ORDER BY SEQ_IN_INDEX;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 508)
2	Doctrine\DBAL\Schema\MySQLSchemaManager->selectIndexColumns (line 293)
3	Doctrine\DBAL\Schema\AbstractSchemaManager->doListTableIndexes (line 99)
4	Doctrine\DBAL\Schema\MySQLSchemaManager->listTableIndexes (line 486)
5	Doctrine\DBAL\Schema\AbstractSchemaManager->doListTableDetails (line 83)
6	Doctrine\DBAL\Schema\MySQLSchemaManager->listTableDetails (line 614)
7	Doctrine\DBAL\Schema\AbstractSchemaManager->introspectTable (line 199)
8	Doctrine\Migrations\Metadata\Storage\TableMetadataStorage->needsUpdate (line 226)
9	Doctrine\Migrations\Metadata\Storage\TableMetadataStorage->checkInitialization (line 76)
10	Doctrine\Migrations\Metadata\Storage\TableMetadataStorage->getExecutedMigrations (line 43)
11	Doctrine\Bundle\MigrationsBundle\Collector\MigrationsCollector->collect (line 158)
12	Symfony\Component\HttpKernel\Profiler\Profiler->collect (line 102)
13	Symfony\Component\HttpKernel\EventListener\ProfilerListener->onKernelResponse (line 115)
14	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
15	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
16	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
17	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 216)
18	Symfony\Component\HttpKernel\HttpKernel->filterResponse (line 204)
19	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
20	Symfony\Component\HttpKernel\HttpKernel->handle (line 97)
21	Symfony\Component\HttpKernel\EventListener\ErrorListener->onKernelException (line 115)
22	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
23	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
24	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
25	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 241)
26	Symfony\Component\HttpKernel\HttpKernel->handleThrowable (line 91)
27	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
28	Symfony\Component\HttpKernel\Kernel->handle (line 20)

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\Configurazione	No errors.
App\Entity\Utente	No errors.
App\Entity\WhiteBlackList	No errors.
App\Entity\TipologiaUtente	The field App\Entity\TipologiaUtente#utente is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Utente#tipologia does not contain the required 'inversedBy="utente"' attribute.
App\Entity\Gruppo	No errors.
App\Entity\ImapUtente	No errors.
App\Entity\ToDo	No errors.
App\Entity\GoogleCalendarUtente	No errors.
App\Entity\Campagne	No errors.
App\Entity\NoteAttivita	No errors.
App\Entity\DocumentiProtetti	No errors.
App\Entity\FiltriStampa	No errors.
App\Entity\Stampa	The association App\Entity\Stampa#filtriStampaPreferitis refers to the owning side field App\Entity\FiltriStampaPreferiti#Stampa which does not exist.
App\Entity\FiltriRicerca	No errors.
App\Entity\LogVisiteAttivita	No errors.
App\Entity\FiltriStampaPreferiti	The mappings App\Entity\FiltriStampaPreferiti#stampa and App\Entity\Stampa#filtriStampaPreferitis are inconsistent with each other.
App\Entity\Dispositivi	No errors.
App\Entity\Notifiche	No errors.

Symfony Profiler

GET https://apitest.ichron.cloud/favicon.ico

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping