Symfony Profiler

Query Metrics

18 Database Queries

8 Different statements

42.10 ms Query time

0 Invalid entities

11 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

10.61 ms
(25.19%)

SELECT t0.id AS id_1, t0.auid AS auid_2, t0.path AS path_3, t0.error_page_entity_404 AS error_page_entity_404_4, t0.error_page_entity_403 AS error_page_entity_403_5, t0.name AS name_6, t0.domain AS domain_7, t0.mode AS mode_8, t0.langcode AS langcode_9, t0.redirect_code AS redirect_code_10, t0.status AS status_11, t0.type AS type_12, t0.parent_id AS parent_id_13 FROM site t0 WHERE t0.parent_id = ? AND t0.mode = ?

Parameters:

[
  1
  "alias"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.auid AS auid_2,
  t0.path AS path_3,
  t0.error_page_entity_404 AS error_page_entity_404_4,
  t0.error_page_entity_403 AS error_page_entity_403_5,
  t0.name AS name_6,
  t0.domain AS domain_7,
  t0.mode AS mode_8,
  t0.langcode AS langcode_9,
  t0.redirect_code AS redirect_code_10,
  t0.status AS status_11,
  t0.type AS type_12,
  t0.parent_id AS parent_id_13
FROM
  site t0
WHERE
  t0.parent_id = ?
  AND t0.mode = ?

SELECT t0.id AS id_1, t0.auid AS auid_2, t0.path AS path_3, t0.error_page_entity_404 AS error_page_entity_404_4, t0.error_page_entity_403 AS error_page_entity_403_5, t0.name AS name_6, t0.domain AS domain_7, t0.mode AS mode_8, t0.langcode AS langcode_9, t0.redirect_code AS redirect_code_10, t0.status AS status_11, t0.type AS type_12, t0.parent_id AS parent_id_13 FROM site t0 WHERE t0.parent_id = 1 AND t0.mode = 'alias';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 974)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 224)
3	Doctrine\ORM\EntityRepository->findBy (line 81)
4	App\Service\Url\SiteLanguageCarrierResolver->directAlias (line 41)
5	App\Service\Url\SiteLanguageCarrierResolver->findPrimaryAliasForLanguage (line 130)
6	App\Service\Url\SiteHostMatcher->compiledSites (line 49)
7	App\Service\Url\SiteHostMatcher->candidatesFor (line 40)
8	App\EventListener\SiteDefaultLanguageRedirectListener->onKernelRequest (line 116)
9	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
10	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
11	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 139)
12	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 157)
13	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
14	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
15	Symfony\Component\HttpKernel\Kernel->handle (line 35)
16	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
17	require_once (line 71)

9.55 ms
(22.68%)

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 627)
2	Doctrine\DBAL\Connection->fetchOne (line 267)
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 708)
7	App\EntityEngine\Definition\SchemaReader->tableExists (line 175)
8	App\Service\Url\UrlAliasRepository->ready (line 29)
9	App\Service\Url\UrlEntryLookup->match (line 96)
10	App\Util\Router\SiteAwareRouter->matchRequest (line 105)
11	Symfony\Component\HttpKernel\EventListener\RouterListener->onKernelRequest (line 116)
12	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
13	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
14	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 139)
15	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 157)
16	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
17	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
18	Symfony\Component\HttpKernel\Kernel->handle (line 35)
19	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
20	require_once (line 71)

7.59 ms
(18.03%)

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

Parameters:

[
  "delk"
]

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 = 'delk'
  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 708)
5	App\EntityEngine\Definition\SchemaReader->tableExists (line 175)
6	App\Service\Url\UrlAliasRepository->ready (line 29)
7	App\Service\Url\UrlEntryLookup->match (line 96)
8	App\Util\Router\SiteAwareRouter->matchRequest (line 105)
9	Symfony\Component\HttpKernel\EventListener\RouterListener->onKernelRequest (line 116)
10	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
11	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
12	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 139)
13	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 157)
14	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
15	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
16	Symfony\Component\HttpKernel\Kernel->handle (line 35)
17	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
18	require_once (line 71)

5.12 ms
(12.17%)

SELECT       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' AND t.TABLE_NAME = ? ORDER BY ORDINAL_POSITION

Parameters:

[
  "delk"
  "delk"
  "url_alias"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  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'
  AND t.TABLE_NAME = ?
ORDER BY
  ORDINAL_POSITION

SELECT       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 = 'delk' AND t.TABLE_SCHEMA = 'delk' AND t.TABLE_TYPE = 'BASE TABLE' AND t.TABLE_NAME = 'url_alias' 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 741)
5	App\EntityEngine\Definition\SchemaReader->tableColumns (line 724)
6	App\EntityEngine\Definition\SchemaReader->columnExists (line 179)
7	App\Service\Url\UrlAliasRepository->ready (line 29)
8	App\Service\Url\UrlEntryLookup->match (line 96)
9	App\Util\Router\SiteAwareRouter->matchRequest (line 105)
10	Symfony\Component\HttpKernel\EventListener\RouterListener->onKernelRequest (line 116)
11	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
12	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
13	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 139)
14	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 157)
15	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
16	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
17	Symfony\Component\HttpKernel\Kernel->handle (line 35)
18	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
19	require_once (line 71)

4.82 ms
(11.44%)

SELECT l0_.id AS id_0, l0_.code AS code_1, l0_.name AS name_2, l0_.native_name AS native_name_3, l0_.weight AS weight_4, l0_.enabled AS enabled_5, l0_.is_default AS is_default_6 FROM language l0_ WHERE l0_.enabled = 1 ORDER BY l0_.weight ASC, l0_.code ASC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  l0_.id AS id_0,
  l0_.code AS code_1,
  l0_.name AS name_2,
  l0_.native_name AS native_name_3,
  l0_.weight AS weight_4,
  l0_.enabled AS enabled_5,
  l0_.is_default AS is_default_6
FROM
  language l0_
WHERE
  l0_.enabled = 1
ORDER BY
  l0_.weight ASC,
  l0_.code ASC

SELECT l0_.id AS id_0, l0_.code AS code_1, l0_.name AS name_2, l0_.native_name AS native_name_3, l0_.weight AS weight_4, l0_.enabled AS enabled_5, l0_.is_default AS is_default_6 FROM language l0_ WHERE l0_.enabled = 1 ORDER BY l0_.weight ASC, l0_.code ASC;

#	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 29)
7	App\Repository\LanguageRepository->findActive (line 35)
8	App\Service\Language\LanguageRegistry->getActive (line 121)
9	App\Service\Url\SiteHostMatcher->compiledSites (line 49)
10	App\Service\Url\SiteHostMatcher->candidatesFor (line 40)
11	App\EventListener\SiteDefaultLanguageRedirectListener->onKernelRequest (line 116)
12	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
13	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
14	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 139)
15	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 157)
16	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
17	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
18	Symfony\Component\HttpKernel\Kernel->handle (line 35)
19	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
20	require_once (line 71)

2.91 ms
(6.91%)

SELECT t0.id AS id_1, t0.auid AS auid_2, t0.path AS path_3, t0.error_page_entity_404 AS error_page_entity_404_4, t0.error_page_entity_403 AS error_page_entity_403_5, t0.name AS name_6, t0.domain AS domain_7, t0.mode AS mode_8, t0.langcode AS langcode_9, t0.redirect_code AS redirect_code_10, t0.status AS status_11, t0.type AS type_12, t0.parent_id AS parent_id_13 FROM site t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.auid AS auid_2,
  t0.path AS path_3,
  t0.error_page_entity_404 AS error_page_entity_404_4,
  t0.error_page_entity_403 AS error_page_entity_403_5,
  t0.name AS name_6,
  t0.domain AS domain_7,
  t0.mode AS mode_8,
  t0.langcode AS langcode_9,
  t0.redirect_code AS redirect_code_10,
  t0.status AS status_11,
  t0.type AS type_12,
  t0.parent_id AS parent_id_13
FROM
  site t0

SELECT t0.id AS id_1, t0.auid AS auid_2, t0.path AS path_3, t0.error_page_entity_404 AS error_page_entity_404_4, t0.error_page_entity_403 AS error_page_entity_403_5, t0.name AS name_6, t0.domain AS domain_7, t0.mode AS mode_8, t0.langcode AS langcode_9, t0.redirect_code AS redirect_code_10, t0.status AS status_11, t0.type AS type_12, t0.parent_id AS parent_id_13 FROM site t0;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 974)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 224)
3	Doctrine\ORM\EntityRepository->findBy (line 89)
4	App\Service\Url\SiteHostMatcher->compiledSites (line 49)
5	App\Service\Url\SiteHostMatcher->candidatesFor (line 40)
6	App\EventListener\SiteDefaultLanguageRedirectListener->onKernelRequest (line 116)
7	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
8	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
9	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 139)
10	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 157)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
13	Symfony\Component\HttpKernel\Kernel->handle (line 35)
14	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
15	require_once (line 71)

1.08 ms
(2.56%)

SELECT * FROM url_alias WHERE site_id = ? AND path = ? LIMIT 1

Parameters:

[
  1
  "/robots.txt"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  *
FROM
  url_alias
WHERE
  site_id = ?
  AND path = ?
LIMIT
  1

SELECT * FROM url_alias WHERE site_id = 1 AND path = '/robots.txt' LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 593)
2	Doctrine\DBAL\Connection->fetchAssociative (line 231)
3	App\Service\Url\UrlAliasRepository->findByPath (line 95)
4	App\Service\Url\UrlEntryLookup->findWithPageSuffix (line 55)
5	App\Service\Url\UrlEntryLookup->match (line 96)
6	App\Util\Router\SiteAwareRouter->matchRequest (line 105)
7	Symfony\Component\HttpKernel\EventListener\RouterListener->onKernelRequest (line 116)
8	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
9	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
10	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 139)
11	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 157)
12	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
13	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
14	Symfony\Component\HttpKernel\Kernel->handle (line 35)
15	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
16	require_once (line 71)

0.43 ms
(1.01%)

SELECT l0_.id AS id_0, l0_.code AS code_1, l0_.name AS name_2, l0_.native_name AS native_name_3, l0_.weight AS weight_4, l0_.enabled AS enabled_5, l0_.is_default AS is_default_6 FROM language l0_ WHERE l0_.is_default = 1 LIMIT 1

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  l0_.id AS id_0,
  l0_.code AS code_1,
  l0_.name AS name_2,
  l0_.native_name AS native_name_3,
  l0_.weight AS weight_4,
  l0_.enabled AS enabled_5,
  l0_.is_default AS is_default_6
FROM
  language l0_
WHERE
  l0_.is_default = 1
LIMIT
  1

SELECT l0_.id AS id_0, l0_.code AS code_1, l0_.name AS name_2, l0_.native_name AS native_name_3, l0_.weight AS weight_4, l0_.enabled AS enabled_5, l0_.is_default AS is_default_6 FROM language l0_ WHERE l0_.is_default = 1 LIMIT 1;

#	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 959)
6	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 50)
7	App\Repository\LanguageRepository->findDefault (line 49)
8	App\Service\Language\LanguageRegistry->getDefault (line 58)
9	App\Service\Language\LanguageRegistry->getDefaultCode (line 61)
10	App\EventListener\SiteDefaultLanguageRedirectListener->onKernelRequest (line 116)
11	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
12	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
13	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 139)
14	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 157)
15	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
16	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
17	Symfony\Component\HttpKernel\Kernel->handle (line 35)
18	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
19	require_once (line 71)

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
App\Entity\Site\Site	10
App\Entity\Language	1

Entities Mapping

Class	Mapping errors
App\Entity\Enums\SiteStatus	No errors.
App\Entity\Enums\SiteTypeFlags	No errors.
App\Entity\Site\Site	No errors.
App\Entity\Enums\ContentStatus	No errors.
App\Entity\Content\Content	No errors.
App\Entity\Category\Category	No errors.
App\Entity\User\UserSiteAccess	No errors.
App\Entity\Language	No errors.

Symfony Profiler

GET http://delk.wiemo.pl/robots.txt

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping