Symfony Profiler

Query Metrics

22 Database Queries

7 Different statements

92.16 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

37.95 ms
(41.18%)

SELECT c.TABLE_NAME,       c.COLUMN_NAME        AS field,
       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' ORDER BY ORDINAL_POSITION

Parameters:

[
  "cmsagencetwco_chanoine"
  "cmsagencetwco_chanoine"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  c.TABLE_NAME,
  c.COLUMN_NAME AS field,
  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'
ORDER BY
  ORDINAL_POSITION

SELECT c.TABLE_NAME,       c.COLUMN_NAME        AS field,
       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 = 'cmsagencetwco_chanoine' AND t.TABLE_SCHEMA = 'cmsagencetwco_chanoine' AND t.TABLE_TYPE = 'BASE TABLE' ORDER BY ORDINAL_POSITION;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 478)
2	Doctrine\DBAL\Schema\MySQLSchemaManager->selectTableColumns (line 561)
3	Doctrine\DBAL\Schema\AbstractSchemaManager->fetchTableColumnsByTable (line 408)
4	Doctrine\DBAL\Schema\AbstractSchemaManager->doListTables (line 66)
5	Doctrine\DBAL\Schema\MySQLSchemaManager->listTables (line 23)
6	App\EventSubscriber\LocaleSubscriber->__construct (line 1479)
7	ContainerTrwD3vd\App_KernelDevDebugContainer::getLocaleSubscriberService (line 1099)
8	ContainerTrwD3vd\App_KernelDevDebugContainer::ContainerTrwD3vd\{closure} (line 221)
9	Symfony\Component\EventDispatcher\EventDispatcher->sortListeners (line 70)
10	Symfony\Component\EventDispatcher\EventDispatcher->getListeners (line 252)
11	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->preProcess (line 116)
12	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 159)
13	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
14	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
15	Symfony\Component\HttpKernel\Kernel->handle (line 35)
16	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
17	require_once (line 5)

27.05 ms
(29.35%)

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_TYPE = 'BASE TABLE'

Parameters:

[
  "cmsagencetwco_chanoine"
]

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_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 = 'cmsagencetwco_chanoine' AND t.TABLE_TYPE = 'BASE TABLE';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 568)
2	Doctrine\DBAL\Schema\MySQLSchemaManager->fetchTableOptionsByTable (line 411)
3	Doctrine\DBAL\Schema\AbstractSchemaManager->doListTables (line 66)
4	Doctrine\DBAL\Schema\MySQLSchemaManager->listTables (line 23)
5	App\EventSubscriber\LocaleSubscriber->__construct (line 1479)
6	ContainerTrwD3vd\App_KernelDevDebugContainer::getLocaleSubscriberService (line 1099)
7	ContainerTrwD3vd\App_KernelDevDebugContainer::ContainerTrwD3vd\{closure} (line 221)
8	Symfony\Component\EventDispatcher\EventDispatcher->sortListeners (line 70)
9	Symfony\Component\EventDispatcher\EventDispatcher->getListeners (line 252)
10	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->preProcess (line 116)
11	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 159)
12	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
13	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
14	Symfony\Component\HttpKernel\Kernel->handle (line 35)
15	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
16	require_once (line 5)

15.01 ms
(16.29%)

SELECT DISTINCT k.TABLE_NAME,            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.REFERENCED_COLUMN_NAME IS NOT NULL /*!50116 AND c.CONSTRAINT_SCHEMA = 'cmsagencetwco_chanoine' */ ORDER BY k.ORDINAL_POSITION

Parameters:

[
  "cmsagencetwco_chanoine"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT k.TABLE_NAME,
  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.REFERENCED_COLUMN_NAME IS NOT NULL
  /*!50116 AND c.CONSTRAINT_SCHEMA = 'cmsagencetwco_chanoine' */
ORDER BY
  k.ORDINAL_POSITION

SELECT DISTINCT k.TABLE_NAME,            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 = 'cmsagencetwco_chanoine' AND k.REFERENCED_COLUMN_NAME IS NOT NULL /*!50116 AND c.CONSTRAINT_SCHEMA = 'cmsagencetwco_chanoine' */ ORDER BY k.ORDINAL_POSITION;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 552)
2	Doctrine\DBAL\Schema\MySQLSchemaManager->selectForeignKeyColumns (line 590)
3	Doctrine\DBAL\Schema\AbstractSchemaManager->fetchForeignKeyColumnsByTable (line 410)
4	Doctrine\DBAL\Schema\AbstractSchemaManager->doListTables (line 66)
5	Doctrine\DBAL\Schema\MySQLSchemaManager->listTables (line 23)
6	App\EventSubscriber\LocaleSubscriber->__construct (line 1479)
7	ContainerTrwD3vd\App_KernelDevDebugContainer::getLocaleSubscriberService (line 1099)
8	ContainerTrwD3vd\App_KernelDevDebugContainer::ContainerTrwD3vd\{closure} (line 221)
9	Symfony\Component\EventDispatcher\EventDispatcher->sortListeners (line 70)
10	Symfony\Component\EventDispatcher\EventDispatcher->getListeners (line 252)
11	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->preProcess (line 116)
12	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 159)
13	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
14	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
15	Symfony\Component\HttpKernel\Kernel->handle (line 35)
16	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
17	require_once (line 5)

5.74 ms
(6.23%)

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 406)
5	Doctrine\DBAL\Schema\AbstractSchemaManager->doListTables (line 66)
6	Doctrine\DBAL\Schema\MySQLSchemaManager->listTables (line 23)
7	App\EventSubscriber\LocaleSubscriber->__construct (line 1479)
8	ContainerTrwD3vd\App_KernelDevDebugContainer::getLocaleSubscriberService (line 1099)
9	ContainerTrwD3vd\App_KernelDevDebugContainer::ContainerTrwD3vd\{closure} (line 221)
10	Symfony\Component\EventDispatcher\EventDispatcher->sortListeners (line 70)
11	Symfony\Component\EventDispatcher\EventDispatcher->getListeners (line 252)
12	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->preProcess (line 116)
13	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 159)
14	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
15	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
16	Symfony\Component\HttpKernel\Kernel->handle (line 35)
17	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
18	require_once (line 5)

5.67 ms
(6.15%)

SELECT TABLE_NAME,        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 = ? ORDER BY SEQ_IN_INDEX

Parameters:

[
  "cmsagencetwco_chanoine"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  TABLE_NAME,
  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 = ?
ORDER BY
  SEQ_IN_INDEX

SELECT TABLE_NAME,        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 = 'cmsagencetwco_chanoine' ORDER BY SEQ_IN_INDEX;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 508)
2	Doctrine\DBAL\Schema\MySQLSchemaManager->selectIndexColumns (line 573)
3	Doctrine\DBAL\Schema\AbstractSchemaManager->fetchIndexColumnsByTable (line 409)
4	Doctrine\DBAL\Schema\AbstractSchemaManager->doListTables (line 66)
5	Doctrine\DBAL\Schema\MySQLSchemaManager->listTables (line 23)
6	App\EventSubscriber\LocaleSubscriber->__construct (line 1479)
7	ContainerTrwD3vd\App_KernelDevDebugContainer::getLocaleSubscriberService (line 1099)
8	ContainerTrwD3vd\App_KernelDevDebugContainer::ContainerTrwD3vd\{closure} (line 221)
9	Symfony\Component\EventDispatcher\EventDispatcher->sortListeners (line 70)
10	Symfony\Component\EventDispatcher\EventDispatcher->getListeners (line 252)
11	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->preProcess (line 116)
12	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 159)
13	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
14	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
15	Symfony\Component\HttpKernel\Kernel->handle (line 35)
16	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
17	require_once (line 5)

0.45 ms
(0.49%)

SELECT l0_.code AS code_0 FROM locale l0_

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  l0_.code AS code_0
FROM
  locale l0_

SELECT l0_.code AS code_0 FROM locale l0_;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 31)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 330)
3	Doctrine\ORM\Query->_doExecute (line 1218)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1172)
5	Doctrine\ORM\AbstractQuery->execute (line 907)
6	Doctrine\ORM\AbstractQuery->getResult (line 46)
7	App\Repository\LocaleRepository->getAvailableLocales (line 31)
8	App\EventSubscriber\LocaleSubscriber->__construct (line 1479)
9	ContainerTrwD3vd\App_KernelDevDebugContainer::getLocaleSubscriberService (line 1099)
10	ContainerTrwD3vd\App_KernelDevDebugContainer::ContainerTrwD3vd\{closure} (line 221)
11	Symfony\Component\EventDispatcher\EventDispatcher->sortListeners (line 70)
12	Symfony\Component\EventDispatcher\EventDispatcher->getListeners (line 252)
13	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->preProcess (line 116)
14	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 159)
15	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
16	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
17	Symfony\Component\HttpKernel\Kernel->handle (line 35)
18	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
19	require_once (line 5)

0.28 ms
(0.30%)

SELECT t0.code AS code_1, t0.isdefault AS isdefault_2, t0.id AS id_3 FROM locale t0 WHERE t0.isdefault = ? LIMIT 1

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.code AS code_1,
  t0.isdefault AS isdefault_2,
  t0.id AS id_3
FROM
  locale t0
WHERE
  t0.isdefault = ?
LIMIT
  1

SELECT t0.code AS code_1, t0.isdefault AS isdefault_2, t0.id AS id_3 FROM locale t0 WHERE t0.isdefault = 1 LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 776)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 240)
3	Doctrine\ORM\EntityRepository->findOneBy (line 33)
4	App\Repository\LocaleRepository->getDefaultLocale (line 32)
5	App\EventSubscriber\LocaleSubscriber->__construct (line 1479)
6	ContainerTrwD3vd\App_KernelDevDebugContainer::getLocaleSubscriberService (line 1099)
7	ContainerTrwD3vd\App_KernelDevDebugContainer::ContainerTrwD3vd\{closure} (line 221)
8	Symfony\Component\EventDispatcher\EventDispatcher->sortListeners (line 70)
9	Symfony\Component\EventDispatcher\EventDispatcher->getListeners (line 252)
10	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->preProcess (line 116)
11	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 159)
12	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
13	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
14	Symfony\Component\HttpKernel\Kernel->handle (line 35)
15	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
16	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\Locale	No errors.

Symfony Profiler

GET https://chanoine.cms.agence-twco.com/api/menus

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping