Symfony Profiler

Query Metrics

22 Database Queries

10 Different statements

35.14 ms Query time

0 Invalid entities

12 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

8.29 ms
(23.58%)

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)

5.37 ms
(15.29%)

SELECT s0_.id AS id_0, s0_.theme AS theme_1, s0_.name AS name_2, s0_.json AS json_3, s0_.status AS status_4, s0_.site_id AS site_id_5 FROM site_theme s0_ WHERE s0_.site_id = ? AND (s0_.status & 2) = 2 LIMIT 1

Parameters:

[
  2
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  s0_.id AS id_0,
  s0_.theme AS theme_1,
  s0_.name AS name_2,
  s0_.json AS json_3,
  s0_.status AS status_4,
  s0_.site_id AS site_id_5
FROM
  site_theme s0_
WHERE
  s0_.site_id = ?
  AND (s0_.status & 2) = 2
LIMIT
  1

SELECT s0_.id AS id_0, s0_.theme AS theme_1, s0_.name AS name_2, s0_.json AS json_3, s0_.status AS status_4, s0_.site_id AS site_id_5 FROM site_theme s0_ WHERE s0_.site_id = 2 AND (s0_.status & 2) = 2 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 44)
7	App\Repository\Theme\SiteThemeRepository->findDefaultForSite (line 79)
8	App\Service\Theme\ThemeService->doResolveForSite (line 56)
9	App\Service\Theme\ThemeService->resolveForSite (line 45)
10	ContainerAWxz1xo\ThemeServiceProxy0924e57->resolveForSite (line 128)
11	App\Service\Theme\ThemeTemplateLoader->computeCurrentThemeKey (line 115)
12	App\Service\Theme\ThemeTemplateLoader->resolveCurrentThemeKey (line 74)
13	App\Service\Theme\ThemeTemplateLoader->themeKeyFor (line 37)
14	App\Service\Theme\ThemeTemplateLoader->getCacheKey (line 317)
15	Twig\Environment->getTemplateClass (line 370)
16	Twig\Environment->load (line 333)
17	Twig\Environment->render (line 448)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 47)
21	App\Controller\LoginController->index (line 181)
22	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
23	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
24	Symfony\Component\HttpKernel\Kernel->handle (line 35)
25	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
26	require_once (line 71)

5.11 ms
(14.53%)

SELECT * FROM ee_file_style ORDER BY applies_to ASC, name ASC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  *
FROM
  ee_file_style
ORDER BY
  applies_to ASC,
  name ASC

SELECT * FROM ee_file_style ORDER BY applies_to ASC, name ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 907)
2	Doctrine\DBAL\Connection->fetchAllAssociative (line 123)
3	App\EntityEngine\Kind\File\Style\FileStyleStorage->list (line 89)
4	App\EntityEngine\Kind\File\Style\FileStyleStorage->pickerOptions (line 29)
5	App\Form\FileStylePickerType->App\Form\{closure} (line 1007)
6	Symfony\Component\OptionsResolver\OptionsResolver->offsetGet (line 905)
7	Symfony\Component\OptionsResolver\OptionsResolver->resolve (line 76)
8	Symfony\Component\Form\ResolvedFormType->createBuilder (line 61)
9	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->createBuilder (line 54)
10	Symfony\Component\Form\FormFactory->createNamedBuilder (line 85)
11	Symfony\Component\Form\FormBuilder->create (line 212)
12	Symfony\Component\Form\FormBuilder->resolveChildren (line 134)
13	Symfony\Component\Form\FormBuilder->all (line 377)
14	App\Service\Theme\ThemeService->buildDefaultOptions (line 364)
15	App\Service\Theme\ThemeService->mergeOptions (line 102)
16	App\Service\Theme\ThemeService->doResolveForSite (line 56)
17	App\Service\Theme\ThemeService->resolveForSite (line 45)
18	ContainerAWxz1xo\ThemeServiceProxy0924e57->resolveForSite (line 128)
19	App\Service\Theme\ThemeTemplateLoader->computeCurrentThemeKey (line 115)
20	App\Service\Theme\ThemeTemplateLoader->resolveCurrentThemeKey (line 74)
21	App\Service\Theme\ThemeTemplateLoader->themeKeyFor (line 37)
22	App\Service\Theme\ThemeTemplateLoader->getCacheKey (line 317)
23	Twig\Environment->getTemplateClass (line 370)
24	Twig\Environment->load (line 333)
25	Twig\Environment->render (line 448)
26	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
27	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
28	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 47)
29	App\Controller\LoginController->index (line 181)
30	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
31	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
32	Symfony\Component\HttpKernel\Kernel->handle (line 35)
33	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
34	require_once (line 71)

5.02 ms
(14.29%)

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)

4.29 ms
(12.22%)

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)

2.67 ms
(7.60%)

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)

2.57 ms
(7.33%)

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

Parameters:

[
  2
  "/login"
]

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 = 2 AND path = '/login' 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.80 ms
(2.28%)

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)

0.56 ms
(1.59%)

SELECT t0_.id AS id_0, t0_.options_patch AS options_patch_1, t0_.advanced_options_patch AS advanced_options_patch_2, t0_.version AS version_3, t0_.inherited_default AS inherited_default_4, t0_.explicit_active AS explicit_active_5, t0_.created_at AS created_at_6, t0_.changed_at AS changed_at_7, t0_.site_id AS site_id_8, t0_.pinned_default_site_theme_id AS pinned_default_site_theme_id_9 FROM theme_site_delta t0_ WHERE t0_.site_id = ?

Parameters:

[
  2
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0_.id AS id_0,
  t0_.options_patch AS options_patch_1,
  t0_.advanced_options_patch AS advanced_options_patch_2,
  t0_.version AS version_3,
  t0_.inherited_default AS inherited_default_4,
  t0_.explicit_active AS explicit_active_5,
  t0_.created_at AS created_at_6,
  t0_.changed_at AS changed_at_7,
  t0_.site_id AS site_id_8,
  t0_.pinned_default_site_theme_id AS pinned_default_site_theme_id_9
FROM
  theme_site_delta t0_
WHERE
  t0_.site_id = ?

SELECT t0_.id AS id_0, t0_.options_patch AS options_patch_1, t0_.advanced_options_patch AS advanced_options_patch_2, t0_.version AS version_3, t0_.inherited_default AS inherited_default_4, t0_.explicit_active AS explicit_active_5, t0_.created_at AS created_at_6, t0_.changed_at AS changed_at_7, t0_.site_id AS site_id_8, t0_.pinned_default_site_theme_id AS pinned_default_site_theme_id_9 FROM theme_site_delta t0_ WHERE t0_.site_id = 2;

#	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 26)
7	App\Repository\Theme\ThemeSiteDeltaRepository->findOneBySite (line 83)
8	App\Service\Theme\ThemeLayoutResolver->getDeltaForSite (line 85)
9	App\Service\Theme\ThemeService->doResolveForSite (line 56)
10	App\Service\Theme\ThemeService->resolveForSite (line 45)
11	ContainerAWxz1xo\ThemeServiceProxy0924e57->resolveForSite (line 128)
12	App\Service\Theme\ThemeTemplateLoader->computeCurrentThemeKey (line 115)
13	App\Service\Theme\ThemeTemplateLoader->resolveCurrentThemeKey (line 74)
14	App\Service\Theme\ThemeTemplateLoader->themeKeyFor (line 37)
15	App\Service\Theme\ThemeTemplateLoader->getCacheKey (line 317)
16	Twig\Environment->getTemplateClass (line 370)
17	Twig\Environment->load (line 333)
18	Twig\Environment->render (line 448)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 47)
22	App\Controller\LoginController->index (line 181)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
25	Symfony\Component\HttpKernel\Kernel->handle (line 35)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
27	require_once (line 71)

0.46 ms
(1.31%)

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)

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
App\Entity\Theme\SiteTheme	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.
App\Entity\Enums\SiteThemeStatus	No errors.
App\Entity\Theme\SiteTheme	No errors.
App\Entity\Theme\ThemeSiteDelta	No errors.
App\Entity\Enums\BlockStatus	No errors.
App\Entity\Theme\Block	No errors.

Symfony Profiler

GET http://panel.delk.wiemo.pl/login

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping