Symfony Profiler

Query Metrics

13 Database Queries

7 Different statements

5.30 ms Query time

3 Invalid entities

0 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

1.44 ms
(27.19%)

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 = 'nq2t4_core_acceptance'
            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:

[
  "nq2t4_core_acceptance"
  "nq2t4_core_acceptance"
  "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 = 'nq2t4_core_acceptance'
        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 = 'nq2t4_core_acceptance'
            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 = 'nq2t4_core_acceptance' AND t.TABLE_SCHEMA = 'nq2t4_core_acceptance' AND t.TABLE_TYPE = 'BASE TABLE' AND t.TABLE_NAME = 'doctrine_migration_versions' ORDER BY ORDINAL_POSITION;

#	File/Call
1	Doctrine\DBAL\Schema\MySQLSchemaManager->selectTableColumns (line 478)
2	Doctrine\DBAL\Schema\AbstractSchemaManager->doListTableColumns (line 255)
3	Doctrine\DBAL\Schema\MySQLSchemaManager->listTableColumns (line 91)
4	Doctrine\DBAL\Schema\AbstractSchemaManager->doListTableDetails (line 485)
5	Doctrine\DBAL\Schema\MySQLSchemaManager->listTableDetails (line 83)
6	Doctrine\DBAL\Schema\AbstractSchemaManager->introspectTable (line 614)
7	Doctrine\Migrations\Metadata\Storage\TableMetadataStorage->needsUpdate (line 209)
8	Doctrine\Migrations\Metadata\Storage\TableMetadataStorage->checkInitialization (line 236)
9	Doctrine\Migrations\Metadata\Storage\TableMetadataStorage->getExecutedMigrations (line 80)
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 126)
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 126)
25	Symfony\Component\HttpKernel\HttpKernel->handleThrowable (line 241)
26	Symfony\Component\HttpKernel\HttpKernel->handle (line 91)
27	Symfony\Component\HttpKernel\Kernel->handle (line 182)
28	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
29	require_once (line 29)
30	require_once (line 5)

1.30 ms
(24.49%)

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

Parameters:

[
  "nq2t4_core_acceptance"
]

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

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

1.15 ms
(21.76%)

SELECT DATABASE()

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  DATABASE()

SELECT DATABASE();

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

0.66 ms
(12.40%)

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 = 'nq2t4_core_acceptance' */ ORDER BY k.ORDINAL_POSITION

Parameters:

[
  "nq2t4_core_acceptance"
  "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 = 'nq2t4_core_acceptance' */
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 = 'nq2t4_core_acceptance' AND k.TABLE_NAME = 'doctrine_migration_versions' AND k.REFERENCED_COLUMN_NAME IS NOT NULL /*!50116 AND c.CONSTRAINT_SCHEMA = 'nq2t4_core_acceptance' */ ORDER BY k.ORDINAL_POSITION;

#	File/Call
1	Doctrine\DBAL\Schema\MySQLSchemaManager->selectForeignKeyColumns (line 552)
2	Doctrine\DBAL\Schema\AbstractSchemaManager->doListTableForeignKeys (line 688)
3	Doctrine\DBAL\Schema\MySQLSchemaManager->listTableForeignKeys (line 107)
4	Doctrine\DBAL\Schema\AbstractSchemaManager->doListTableDetails (line 478)
5	Doctrine\DBAL\Schema\MySQLSchemaManager->listTableDetails (line 83)
6	Doctrine\DBAL\Schema\AbstractSchemaManager->introspectTable (line 614)
7	Doctrine\Migrations\Metadata\Storage\TableMetadataStorage->needsUpdate (line 209)
8	Doctrine\Migrations\Metadata\Storage\TableMetadataStorage->checkInitialization (line 236)
9	Doctrine\Migrations\Metadata\Storage\TableMetadataStorage->getExecutedMigrations (line 80)
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 126)
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 126)
25	Symfony\Component\HttpKernel\HttpKernel->handleThrowable (line 241)
26	Symfony\Component\HttpKernel\HttpKernel->handle (line 91)
27	Symfony\Component\HttpKernel\Kernel->handle (line 182)
28	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
29	require_once (line 29)
30	require_once (line 5)

0.45 ms
(8.43%)

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:

[
  "nq2t4_core_acceptance"
  "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 = 'nq2t4_core_acceptance' AND t.TABLE_NAME = 'doctrine_migration_versions' AND t.TABLE_TYPE = 'BASE TABLE';

#	File/Call
1	Doctrine\DBAL\Schema\MySQLSchemaManager->fetchTableOptionsByTable (line 568)
2	Doctrine\DBAL\Schema\AbstractSchemaManager->doListTableDetails (line 475)
3	Doctrine\DBAL\Schema\MySQLSchemaManager->listTableDetails (line 83)
4	Doctrine\DBAL\Schema\AbstractSchemaManager->introspectTable (line 614)
5	Doctrine\Migrations\Metadata\Storage\TableMetadataStorage->needsUpdate (line 209)
6	Doctrine\Migrations\Metadata\Storage\TableMetadataStorage->checkInitialization (line 236)
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 126)
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 126)
23	Symfony\Component\HttpKernel\HttpKernel->handleThrowable (line 241)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 91)
25	Symfony\Component\HttpKernel\Kernel->handle (line 182)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
27	require_once (line 29)
28	require_once (line 5)

0.21 ms
(3.91%)

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:

[
  "nq2t4_core_acceptance"
  "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 = 'nq2t4_core_acceptance' AND TABLE_NAME = 'doctrine_migration_versions' ORDER BY SEQ_IN_INDEX;

#	File/Call
1	Doctrine\DBAL\Schema\MySQLSchemaManager->selectIndexColumns (line 508)
2	Doctrine\DBAL\Schema\AbstractSchemaManager->doListTableIndexes (line 293)
3	Doctrine\DBAL\Schema\MySQLSchemaManager->listTableIndexes (line 99)
4	Doctrine\DBAL\Schema\AbstractSchemaManager->doListTableDetails (line 486)
5	Doctrine\DBAL\Schema\MySQLSchemaManager->listTableDetails (line 83)
6	Doctrine\DBAL\Schema\AbstractSchemaManager->introspectTable (line 614)
7	Doctrine\Migrations\Metadata\Storage\TableMetadataStorage->needsUpdate (line 209)
8	Doctrine\Migrations\Metadata\Storage\TableMetadataStorage->checkInitialization (line 236)
9	Doctrine\Migrations\Metadata\Storage\TableMetadataStorage->getExecutedMigrations (line 80)
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 126)
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 126)
25	Symfony\Component\HttpKernel\HttpKernel->handleThrowable (line 241)
26	Symfony\Component\HttpKernel\HttpKernel->handle (line 91)
27	Symfony\Component\HttpKernel\Kernel->handle (line 182)
28	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
29	require_once (line 29)
30	require_once (line 5)

0.10 ms
(1.83%)

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->fetchAllAssociative (line 907)
2	Doctrine\Migrations\Metadata\Storage\TableMetadataStorage->getExecutedMigrations (line 81)
3	Doctrine\Bundle\MigrationsBundle\Collector\MigrationsCollector->collect (line 44)
4	Symfony\Component\HttpKernel\Profiler\Profiler->collect (line 158)
5	Symfony\Component\HttpKernel\EventListener\ProfilerListener->onKernelResponse (line 102)
6	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
7	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
8	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
9	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
10	Symfony\Component\HttpKernel\HttpKernel->filterResponse (line 216)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 204)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
13	Symfony\Component\HttpKernel\EventListener\ErrorListener->onKernelException (line 99)
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 126)
18	Symfony\Component\HttpKernel\HttpKernel->handleThrowable (line 241)
19	Symfony\Component\HttpKernel\HttpKernel->handle (line 91)
20	Symfony\Component\HttpKernel\Kernel->handle (line 182)
21	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
22	require_once (line 29)
23	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.

Managed Entities

default entity manager

Class	Amount of managed objects

Entities Mapping

Class	Mapping errors
App\Entity\Cars	No errors.
App\Entity\CarsBrands	No errors.
App\Entity\CarsModels	No errors.
App\Entity\Customers	No errors.
App\Entity\Errors	No errors.
App\Entity\Exclusion	No errors.
App\Entity\ExternalApiErrorLog	No errors.
App\Entity\HelpdeskRuleCategories	No errors.
App\Entity\HelpdeskRuleCategoryContents	No errors.
App\Entity\HelpdeskRuleContents	No errors.
App\Entity\HelpdeskRules	No errors.
App\Entity\LocalMerchant	No errors.
App\Entity\LocalMerchantWithOffer	No errors.
App\Entity\MessengerMessages	No errors.
Gesdinet\JWTRefreshTokenBundle\Entity\RefreshToken	No errors.
App\Entity\RefreshToken	No errors.
App\Entity\ResetPasswordRequest	No errors.
App\Entity\WatermarkAction	No errors.
App\Entity\oauth_aos	No errors.
App\Entity\SB2BColumnDefinition	The association App\Entity\SB2BColumnDefinition#relatedTable refers to the inverse side field App\Entity\SB2BTableDefinition#sB2BColumnDefinitions which does not exist. The mappings App\Entity\SB2BColumnDefinition#sb2bKeyDefinitions and App\Entity\SB2BKeyDefinition#columns are inconsistent with each other.
App\Entity\ApiToken	No errors.
App\Entity\Communication	No errors.
App\Entity\CommunicationContents	No errors.
App\Entity\Countries	No errors.
App\Entity\Languages	No errors.
App\Entity\Logs	No errors.
App\Entity\Poll	No errors.
App\Entity\TagConcession	No errors.
App\Entity\SB2BKeyDefinition	The association App\Entity\SB2BKeyDefinition#relatedTable refers to the inverse side field App\Entity\SB2BTableDefinition#sb2bKeyDefinition which does not exist. The association App\Entity\SB2BKeyDefinition#columns refers to the inverse side field App\Entity\SB2BColumnDefinition#sb2bKeyDefinition which does not exist.
App\Entity\SB2BTableDefinition	The mappings App\Entity\SB2BTableDefinition#sb2bColumnDefinitions and App\Entity\SB2BColumnDefinition#relatedTable are inconsistent with each other. The mappings App\Entity\SB2BTableDefinition#sb2bKeyDefinitions and App\Entity\SB2BKeyDefinition#relatedTable are inconsistent with each other.
App\Entity\User	No errors.
App\Entity\Concessions	No errors.
App\Entity\AppConfig	No errors.
App\Entity\Doctype	No errors.
Zenstruck\Messenger\Monitor\History\Model\ProcessedMessage	No errors.
App\Entity\ProcessedMessage	No errors.
App\Entity\oauth	No errors.
App\Entity\SB2BAppConfig	No errors.
Vich\UploaderBundle\Entity\File	No errors.

Symfony Profiler

GET http://core-dev.fstbckgt.com/wp-login.php

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping