Symfony Profiler

Query Metrics

88 Database Queries

42 Different statements

65.58 ms Query time

0 Invalid entities

47 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

16.21 ms
(24.71%)

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)

5.35 ms
(8.17%)

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.28 ms
(8.06%)

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)

3.26 ms
(4.97%)

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 INNER JOIN navigation_site ON t0.id = navigation_site.site_id WHERE navigation_site.navigation_id = ?

Parameters:

[
  3
]

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
  INNER JOIN navigation_site ON t0.id = navigation_site.site_id
WHERE
  navigation_site.navigation_id = ?

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 INNER JOIN navigation_site ON t0.id = navigation_site.site_id WHERE navigation_site.navigation_id = 3;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1122)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getManyToManyStatement (line 1044)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadManyToManyCollection (line 3313)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 706)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 218)
6	Doctrine\ORM\PersistentCollection->initialize (line 217)
7	Doctrine\Common\Collections\AbstractLazyCollection->exists (line 177)
8	App\Entity\Navigation\Navigation->isSiteInScope (line 242)
9	App\Service\NavigationService::App\Service\{closure} (line 1)
10	array_filter (line 240)
11	App\Service\NavigationService->getForSite (line 205)
12	App\Service\Theme\BlockType\Breadcrumbs\BreadcrumbsBlockType->resolveNavigationIds (line 105)
13	App\Service\Theme\BlockType\Breadcrumbs\BreadcrumbsBlockType->render (line 52)
14	App\Service\Theme\BlockTypeRegistry->render (line 154)
15	App\Service\Theme\ThemeService->App\Service\Theme\{closure} (line 34)
16	App\Service\Theme\RenderStack->within (line 152)
17	App\Service\Theme\ThemeService->App\Service\Theme\{closure} (line 34)
18	App\Service\Theme\RenderStack->within (line 152)
19	App\Service\Theme\ThemeService->renderRegion (line 86)
20	App\Twig\ThemeExtension->themeRegion (line 193)
21	__TwigTemplate_9841bf9a74afab2a3cb3ad11d1624e81->doDisplay (line 402)
22	Twig\Template->yield (line 55)
23	__TwigTemplate_76f4671f53d28c3d5093cbcdb9c46f0f->doDisplay (line 402)
24	Twig\Template->yield (line 358)
25	Twig\Template->display (line 373)
26	Twig\Template->render (line 51)
27	Twig\TemplateWrapper->render (line 333)
28	Twig\Environment->render (line 139)
29	App\EntityEngine\Views\ViewPageUrlModule->resolve (line 53)
30	App\Controller\Public\UrlEntryDispatchController->dispatch (line 181)
31	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
32	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
33	Symfony\Component\HttpKernel\Kernel->handle (line 35)
34	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
35	require_once (line 71)

3.22 ms
(4.90%)

SELECT fu.id AS usage_id, f.*, fu.name AS usage_name, fu.description AS usage_description, fu.alt AS usage_alt, fu.focal AS usage_focal, fu.instance_id AS usage_instance_id, fi.name AS instance_name, fi.context AS instance_context, fi.author_id AS instance_author_id, fi.focal AS instance_focal FROM entity_file_usage fu JOIN entity_file f ON f.id = fu.file_id LEFT JOIN entity_file_instance fi ON fi.id = fu.instance_id WHERE fu.id = ?

Parameters:

[
  46
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  fu.id AS usage_id,
  f.*,
  fu.name AS usage_name,
  fu.description AS usage_description,
  fu.alt AS usage_alt,
  fu.focal AS usage_focal,
  fu.instance_id AS usage_instance_id,
  fi.name AS instance_name,
  fi.context AS instance_context,
  fi.author_id AS instance_author_id,
  fi.focal AS instance_focal
FROM
  entity_file_usage fu
  JOIN entity_file f ON f.id = fu.file_id
  LEFT JOIN entity_file_instance fi ON fi.id = fu.instance_id
WHERE
  fu.id = ?

SELECT fu.id AS usage_id, f.*, fu.name AS usage_name, fu.description AS usage_description, fu.alt AS usage_alt, fu.focal AS usage_focal, fu.instance_id AS usage_instance_id, fi.name AS instance_name, fi.context AS instance_context, fi.author_id AS instance_author_id, fi.focal AS instance_focal FROM entity_file_usage fu JOIN entity_file f ON f.id = fu.file_id LEFT JOIN entity_file_instance fi ON fi.id = fu.instance_id WHERE fu.id = 46;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 593)
2	Doctrine\DBAL\Connection->fetchAssociative (line 187)
3	App\EntityEngine\Kind\File\FileRepositoryService->findByUsageId (line 104)
4	App\Twig\ThemeExtension->themeFile (line 66)
5	__TwigTemplate_9841bf9a74afab2a3cb3ad11d1624e81->doDisplay (line 402)
6	Twig\Template->yield (line 55)
7	__TwigTemplate_76f4671f53d28c3d5093cbcdb9c46f0f->doDisplay (line 402)
8	Twig\Template->yield (line 358)
9	Twig\Template->display (line 373)
10	Twig\Template->render (line 51)
11	Twig\TemplateWrapper->render (line 333)
12	Twig\Environment->render (line 139)
13	App\EntityEngine\Views\ViewPageUrlModule->resolve (line 53)
14	App\Controller\Public\UrlEntryDispatchController->dispatch (line 181)
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.28 ms
(3.48%)

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)

1.92 ms
(2.92%)

SELECT t0.id AS id_1, t0.region AS region_2, t0.type AS type_3, t0.name AS name_4, t0.json AS json_5, t0.visibility AS visibility_6, t0.position AS position_7, t0.status AS status_8, t0.site_theme_id AS site_theme_id_9 FROM theme_block t0 WHERE t0.id IN (?)

Parameters:

[
  35
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.region AS region_2,
  t0.type AS type_3,
  t0.name AS name_4,
  t0.json AS json_5,
  t0.visibility AS visibility_6,
  t0.position AS position_7,
  t0.status AS status_8,
  t0.site_theme_id AS site_theme_id_9
FROM
  theme_block t0
WHERE
  t0.id IN (?)

SELECT t0.id AS id_1, t0.region AS region_2, t0.type AS type_3, t0.name AS name_4, t0.json AS json_5, t0.visibility AS visibility_6, t0.position AS position_7, t0.status AS status_8, t0.site_theme_id AS site_theme_id_9 FROM theme_block t0 WHERE t0.id IN (35);

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 974)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 224)
3	Doctrine\ORM\EntityRepository->findBy (line 415)
4	App\Service\Theme\ThemeService->hydrateBlocksInOrder (line 132)
5	App\Service\Theme\ThemeService->renderRegion (line 86)
6	App\Twig\ThemeExtension->themeRegion (line 153)
7	__TwigTemplate_9841bf9a74afab2a3cb3ad11d1624e81->doDisplay (line 402)
8	Twig\Template->yield (line 55)
9	__TwigTemplate_76f4671f53d28c3d5093cbcdb9c46f0f->doDisplay (line 402)
10	Twig\Template->yield (line 358)
11	Twig\Template->display (line 373)
12	Twig\Template->render (line 51)
13	Twig\TemplateWrapper->render (line 333)
14	Twig\Environment->render (line 139)
15	App\EntityEngine\Views\ViewPageUrlModule->resolve (line 53)
16	App\Controller\Public\UrlEntryDispatchController->dispatch (line 181)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
19	Symfony\Component\HttpKernel\Kernel->handle (line 35)
20	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
21	require_once (line 71)

1.56 ms
(2.37%)

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.50 ms
(2.28%)

SELECT * FROM ee_view ORDER BY name ASC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  *
FROM
  ee_view
ORDER BY
  name ASC

SELECT * FROM ee_view ORDER BY name ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 907)
2	Doctrine\DBAL\Connection->fetchAllAssociative (line 95)
3	App\EntityEngine\Views\ViewStorage->list (line 93)
4	App\EntityEngine\Views\Variant\EntityAttachVariantFields->fieldsForType (line 69)
5	App\EntityEngine\Registry\DisplayFieldExtensionRegistry->activeFieldsForType (line 403)
6	App\EntityEngine\Views\ViewFieldCatalog->viewModeMetaFields (line 316)
7	App\EntityEngine\Render\EntityRenderer->buildWeightedMetaFields (line 219)
8	App\EntityEngine\Render\EntityRenderer->buildEntityFields (line 161)
9	App\EntityEngine\Render\EntityRenderer->App\EntityEngine\Render\{closure} (line 34)
10	App\Service\Theme\RenderStack->within (line 142)
11	App\EntityEngine\Render\EntityRenderer->renderEntity (line 492)
12	App\EntityEngine\Views\ViewRenderService->App\EntityEngine\Views\{closure} (line 34)
13	App\Service\Theme\RenderStack->within (line 482)
14	App\EntityEngine\Views\ViewRenderService->renderPresentation (line 387)
15	App\Service\Theme\BlockType\EeView\EeViewBlockType->render (line 52)
16	App\Service\Theme\BlockTypeRegistry->render (line 154)
17	App\Service\Theme\ThemeService->App\Service\Theme\{closure} (line 34)
18	App\Service\Theme\RenderStack->within (line 152)
19	App\Service\Theme\ThemeService->App\Service\Theme\{closure} (line 34)
20	App\Service\Theme\RenderStack->within (line 152)
21	App\Service\Theme\ThemeService->renderRegion (line 86)
22	App\Twig\ThemeExtension->themeRegion (line 149)
23	__TwigTemplate_9841bf9a74afab2a3cb3ad11d1624e81->doDisplay (line 402)
24	Twig\Template->yield (line 55)
25	__TwigTemplate_76f4671f53d28c3d5093cbcdb9c46f0f->doDisplay (line 402)
26	Twig\Template->yield (line 358)
27	Twig\Template->display (line 373)
28	Twig\Template->render (line 51)
29	Twig\TemplateWrapper->render (line 333)
30	Twig\Environment->render (line 139)
31	App\EntityEngine\Views\ViewPageUrlModule->resolve (line 53)
32	App\Controller\Public\UrlEntryDispatchController->dispatch (line 181)
33	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
34	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
35	Symfony\Component\HttpKernel\Kernel->handle (line 35)
36	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
37	require_once (line 71)

1.47 ms
(2.25%)

SELECT * FROM entity_category_display WHERE type_id = ? AND view_mode_id = ? ORDER BY weight ASC

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  *
FROM
  entity_category_display
WHERE
  type_id = ?
  AND view_mode_id = ?
ORDER BY
  weight ASC

SELECT * FROM entity_category_display WHERE type_id = 14 AND view_mode_id = 5 ORDER BY weight ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 907)
2	Doctrine\DBAL\Connection->fetchAllAssociative (line 562)
3	App\EntityEngine\Definition\SchemaReader->getDisplay (line 218)
4	App\EntityEngine\Render\EntityRenderer->buildEntityFields (line 161)
5	App\EntityEngine\Render\EntityRenderer->App\EntityEngine\Render\{closure} (line 34)
6	App\Service\Theme\RenderStack->within (line 142)
7	App\EntityEngine\Render\EntityRenderer->renderEntity (line 492)
8	App\EntityEngine\Views\ViewRenderService->App\EntityEngine\Views\{closure} (line 34)
9	App\Service\Theme\RenderStack->within (line 482)
10	App\EntityEngine\Views\ViewRenderService->renderPresentation (line 387)
11	App\Service\Theme\BlockType\EeView\EeViewBlockType->render (line 52)
12	App\Service\Theme\BlockTypeRegistry->render (line 154)
13	App\Service\Theme\ThemeService->App\Service\Theme\{closure} (line 34)
14	App\Service\Theme\RenderStack->within (line 152)
15	App\Service\Theme\ThemeService->App\Service\Theme\{closure} (line 34)
16	App\Service\Theme\RenderStack->within (line 152)
17	App\Service\Theme\ThemeService->renderRegion (line 86)
18	App\Twig\ThemeExtension->themeRegion (line 149)
19	__TwigTemplate_9841bf9a74afab2a3cb3ad11d1624e81->doDisplay (line 402)
20	Twig\Template->yield (line 55)
21	__TwigTemplate_76f4671f53d28c3d5093cbcdb9c46f0f->doDisplay (line 402)
22	Twig\Template->yield (line 358)
23	Twig\Template->display (line 373)
24	Twig\Template->render (line 51)
25	Twig\TemplateWrapper->render (line 333)
26	Twig\Environment->render (line 139)
27	App\EntityEngine\Views\ViewPageUrlModule->resolve (line 53)
28	App\Controller\Public\UrlEntryDispatchController->dispatch (line 181)
29	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
30	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
31	Symfony\Component\HttpKernel\Kernel->handle (line 35)
32	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
33	require_once (line 71)

1.38 ms
(2.10%)

SELECT * FROM url_alias WHERE module = ? AND target IN (?, ?, ?) ORDER BY id ASC

Parameters:

[
  "ee"
  "category:32"
  "category:20"
  "category:19"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  *
FROM
  url_alias
WHERE
  module = ?
  AND target IN (?, ?, ?)
ORDER BY
  id ASC

SELECT * FROM url_alias WHERE module = 'ee' AND target IN ('category:32', 'category:20', 'category:19') ORDER BY id ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 907)
2	Doctrine\DBAL\Connection->fetchAllAssociative (line 149)
3	App\Service\Url\UrlAliasRepository->memoizeTargets (line 358)
4	App\Service\Url\UrlAliasRepository->findByModuleTargets (line 80)
5	App\EntityEngine\Url\EntityUrlGenerator->canonicalUrls (line 256)
6	App\EntityEngine\Storage\EntityStorage->buildEntities (line 151)
7	App\EntityEngine\Storage\EntityStorage->loadMultipleBatch (line 127)
8	App\EntityEngine\Storage\EntityStorage->loadMultiple (line 546)
9	App\EntityEngine\Query\EntityQuery->loadMultipleByIds (line 165)
10	App\EntityEngine\Views\ViewExecutor->executeLoaded (line 348)
11	App\Service\Theme\BlockType\EeView\EeViewBlockType->render (line 52)
12	App\Service\Theme\BlockTypeRegistry->render (line 154)
13	App\Service\Theme\ThemeService->App\Service\Theme\{closure} (line 34)
14	App\Service\Theme\RenderStack->within (line 152)
15	App\Service\Theme\ThemeService->App\Service\Theme\{closure} (line 34)
16	App\Service\Theme\RenderStack->within (line 152)
17	App\Service\Theme\ThemeService->renderRegion (line 86)
18	App\Twig\ThemeExtension->themeRegion (line 149)
19	__TwigTemplate_9841bf9a74afab2a3cb3ad11d1624e81->doDisplay (line 402)
20	Twig\Template->yield (line 55)
21	__TwigTemplate_76f4671f53d28c3d5093cbcdb9c46f0f->doDisplay (line 402)
22	Twig\Template->yield (line 358)
23	Twig\Template->display (line 373)
24	Twig\Template->render (line 51)
25	Twig\TemplateWrapper->render (line 333)
26	Twig\Environment->render (line 139)
27	App\EntityEngine\Views\ViewPageUrlModule->resolve (line 53)
28	App\Controller\Public\UrlEntryDispatchController->dispatch (line 181)
29	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
30	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
31	Symfony\Component\HttpKernel\Kernel->handle (line 35)
32	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
33	require_once (line 71)

1.25 ms
(1.91%)

SELECT t0.id AS id_1, t0.region AS region_2, t0.type AS type_3, t0.name AS name_4, t0.json AS json_5, t0.visibility AS visibility_6, t0.position AS position_7, t0.status AS status_8, t0.site_theme_id AS site_theme_id_9 FROM theme_block t0 WHERE t0.id IN (?, ?, ?)

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.region AS region_2,
  t0.type AS type_3,
  t0.name AS name_4,
  t0.json AS json_5,
  t0.visibility AS visibility_6,
  t0.position AS position_7,
  t0.status AS status_8,
  t0.site_theme_id AS site_theme_id_9
FROM
  theme_block t0
WHERE
  t0.id IN (?, ?, ?)

SELECT t0.id AS id_1, t0.region AS region_2, t0.type AS type_3, t0.name AS name_4, t0.json AS json_5, t0.visibility AS visibility_6, t0.position AS position_7, t0.status AS status_8, t0.site_theme_id AS site_theme_id_9 FROM theme_block t0 WHERE t0.id IN (137, 141, 139);

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 974)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 224)
3	Doctrine\ORM\EntityRepository->findBy (line 415)
4	App\Service\Theme\ThemeService->hydrateBlocksInOrder (line 132)
5	App\Service\Theme\ThemeService->renderRegion (line 86)
6	App\Twig\ThemeExtension->themeRegion (line 203)
7	__TwigTemplate_9841bf9a74afab2a3cb3ad11d1624e81->doDisplay (line 402)
8	Twig\Template->yield (line 55)
9	__TwigTemplate_76f4671f53d28c3d5093cbcdb9c46f0f->doDisplay (line 402)
10	Twig\Template->yield (line 358)
11	Twig\Template->display (line 373)
12	Twig\Template->render (line 51)
13	Twig\TemplateWrapper->render (line 333)
14	Twig\Environment->render (line 139)
15	App\EntityEngine\Views\ViewPageUrlModule->resolve (line 53)
16	App\Controller\Public\UrlEntryDispatchController->dispatch (line 181)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
19	Symfony\Component\HttpKernel\Kernel->handle (line 35)
20	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
21	require_once (line 71)

1.24 ms
(1.90%)

SELECT t0.id AS id_1, t0.region AS region_2, t0.type AS type_3, t0.name AS name_4, t0.json AS json_5, t0.visibility AS visibility_6, t0.position AS position_7, t0.status AS status_8, t0.site_theme_id AS site_theme_id_9 FROM theme_block t0 WHERE t0.id IN (?, ?)

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.region AS region_2,
  t0.type AS type_3,
  t0.name AS name_4,
  t0.json AS json_5,
  t0.visibility AS visibility_6,
  t0.position AS position_7,
  t0.status AS status_8,
  t0.site_theme_id AS site_theme_id_9
FROM
  theme_block t0
WHERE
  t0.id IN (?, ?)

SELECT t0.id AS id_1, t0.region AS region_2, t0.type AS type_3, t0.name AS name_4, t0.json AS json_5, t0.visibility AS visibility_6, t0.position AS position_7, t0.status AS status_8, t0.site_theme_id AS site_theme_id_9 FROM theme_block t0 WHERE t0.id IN (34, 136);

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 974)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 224)
3	Doctrine\ORM\EntityRepository->findBy (line 415)
4	App\Service\Theme\ThemeService->hydrateBlocksInOrder (line 132)
5	App\Service\Theme\ThemeService->renderRegion (line 86)
6	App\Twig\ThemeExtension->themeRegion (line 149)
7	__TwigTemplate_9841bf9a74afab2a3cb3ad11d1624e81->doDisplay (line 402)
8	Twig\Template->yield (line 55)
9	__TwigTemplate_76f4671f53d28c3d5093cbcdb9c46f0f->doDisplay (line 402)
10	Twig\Template->yield (line 358)
11	Twig\Template->display (line 373)
12	Twig\Template->render (line 51)
13	Twig\TemplateWrapper->render (line 333)
14	Twig\Environment->render (line 139)
15	App\EntityEngine\Views\ViewPageUrlModule->resolve (line 53)
16	App\Controller\Public\UrlEntryDispatchController->dispatch (line 181)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
19	Symfony\Component\HttpKernel\Kernel->handle (line 35)
20	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
21	require_once (line 71)

1.20 ms
(1.83%)

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

Parameters:

[
  1
  "/wyszukiwanie"
]

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 = '/wyszukiwanie' 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)

1.05 ms
(1.60%)

SELECT * FROM entity_category_meta_display WHERE type_id = ? AND view_mode_id = ?

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  *
FROM
  entity_category_meta_display
WHERE
  type_id = ?
  AND view_mode_id = ?

SELECT * FROM entity_category_meta_display WHERE type_id = 14 AND view_mode_id = 5;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 907)
2	Doctrine\DBAL\Connection->fetchAllAssociative (line 635)
3	App\EntityEngine\Definition\SchemaReader->getMetaDisplay (line 321)
4	App\EntityEngine\Render\EntityRenderer->buildWeightedMetaFields (line 219)
5	App\EntityEngine\Render\EntityRenderer->buildEntityFields (line 161)
6	App\EntityEngine\Render\EntityRenderer->App\EntityEngine\Render\{closure} (line 34)
7	App\Service\Theme\RenderStack->within (line 142)
8	App\EntityEngine\Render\EntityRenderer->renderEntity (line 492)
9	App\EntityEngine\Views\ViewRenderService->App\EntityEngine\Views\{closure} (line 34)
10	App\Service\Theme\RenderStack->within (line 482)
11	App\EntityEngine\Views\ViewRenderService->renderPresentation (line 387)
12	App\Service\Theme\BlockType\EeView\EeViewBlockType->render (line 52)
13	App\Service\Theme\BlockTypeRegistry->render (line 154)
14	App\Service\Theme\ThemeService->App\Service\Theme\{closure} (line 34)
15	App\Service\Theme\RenderStack->within (line 152)
16	App\Service\Theme\ThemeService->App\Service\Theme\{closure} (line 34)
17	App\Service\Theme\RenderStack->within (line 152)
18	App\Service\Theme\ThemeService->renderRegion (line 86)
19	App\Twig\ThemeExtension->themeRegion (line 149)
20	__TwigTemplate_9841bf9a74afab2a3cb3ad11d1624e81->doDisplay (line 402)
21	Twig\Template->yield (line 55)
22	__TwigTemplate_76f4671f53d28c3d5093cbcdb9c46f0f->doDisplay (line 402)
23	Twig\Template->yield (line 358)
24	Twig\Template->display (line 373)
25	Twig\Template->render (line 51)
26	Twig\TemplateWrapper->render (line 333)
27	Twig\Environment->render (line 139)
28	App\EntityEngine\Views\ViewPageUrlModule->resolve (line 53)
29	App\Controller\Public\UrlEntryDispatchController->dispatch (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)

0.93 ms
(1.42%)

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.90 ms
(1.37%)

SELECT id FROM entity_category_view_mode WHERE type_id = ? AND name = ?

Parameters:

[
  14
  "default"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  id
FROM
  entity_category_view_mode
WHERE
  type_id = ?
  AND name = ?

SELECT id FROM entity_category_view_mode WHERE type_id = 14 AND name = 'default';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 627)
2	Doctrine\DBAL\Connection->fetchOne (line 959)
3	App\EntityEngine\Definition\ViewModeManager->ensureDefault (line 169)
4	App\EntityEngine\Definition\ViewModeManager->get (line 211)
5	App\EntityEngine\Definition\ViewModeManager->resolveName (line 138)
6	App\EntityEngine\Render\EntityRenderer->renderEntity (line 492)
7	App\EntityEngine\Views\ViewRenderService->App\EntityEngine\Views\{closure} (line 34)
8	App\Service\Theme\RenderStack->within (line 482)
9	App\EntityEngine\Views\ViewRenderService->renderPresentation (line 387)
10	App\Service\Theme\BlockType\EeView\EeViewBlockType->render (line 52)
11	App\Service\Theme\BlockTypeRegistry->render (line 154)
12	App\Service\Theme\ThemeService->App\Service\Theme\{closure} (line 34)
13	App\Service\Theme\RenderStack->within (line 152)
14	App\Service\Theme\ThemeService->App\Service\Theme\{closure} (line 34)
15	App\Service\Theme\RenderStack->within (line 152)
16	App\Service\Theme\ThemeService->renderRegion (line 86)
17	App\Twig\ThemeExtension->themeRegion (line 149)
18	__TwigTemplate_9841bf9a74afab2a3cb3ad11d1624e81->doDisplay (line 402)
19	Twig\Template->yield (line 55)
20	__TwigTemplate_76f4671f53d28c3d5093cbcdb9c46f0f->doDisplay (line 402)
21	Twig\Template->yield (line 358)
22	Twig\Template->display (line 373)
23	Twig\Template->render (line 51)
24	Twig\TemplateWrapper->render (line 333)
25	Twig\Environment->render (line 139)
26	App\EntityEngine\Views\ViewPageUrlModule->resolve (line 53)
27	App\Controller\Public\UrlEntryDispatchController->dispatch (line 181)
28	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
29	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
30	Symfony\Component\HttpKernel\Kernel->handle (line 35)
31	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
32	require_once (line 71)

0.83 ms
(1.27%)

SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.slot AS slot_2, s0_.code AS code_3, s0_.paths AS paths_4, s0_.paths_mode AS paths_mode_5, s0_.position AS position_6, s0_.status AS status_7, s0_.site_id AS site_id_8 FROM site_injection s0_ WHERE s0_.site_id = ? AND (s0_.status & 1) = 1 ORDER BY s0_.position ASC, s0_.id ASC

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  s0_.id AS id_0,
  s0_.name AS name_1,
  s0_.slot AS slot_2,
  s0_.code AS code_3,
  s0_.paths AS paths_4,
  s0_.paths_mode AS paths_mode_5,
  s0_.position AS position_6,
  s0_.status AS status_7,
  s0_.site_id AS site_id_8
FROM
  site_injection s0_
WHERE
  s0_.site_id = ?
  AND (s0_.status & 1) = 1
ORDER BY
  s0_.position ASC,
  s0_.id ASC

SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.slot AS slot_2, s0_.code AS code_3, s0_.paths AS paths_4, s0_.paths_mode AS paths_mode_5, s0_.position AS position_6, s0_.status AS status_7, s0_.site_id AS site_id_8 FROM site_injection s0_ WHERE s0_.site_id = 1 AND (s0_.status & 1) = 1 ORDER BY s0_.position ASC, s0_.id 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 80)
7	App\Repository\Site\SiteInjectionRepository->findActiveForSite (line 26)
8	App\Service\Injection\InjectionRegistry->renderSlot (line 26)
9	App\Twig\InjectionExtension->themeInjections (line 111)
10	__TwigTemplate_9841bf9a74afab2a3cb3ad11d1624e81->doDisplay (line 402)
11	Twig\Template->yield (line 55)
12	__TwigTemplate_76f4671f53d28c3d5093cbcdb9c46f0f->doDisplay (line 402)
13	Twig\Template->yield (line 358)
14	Twig\Template->display (line 373)
15	Twig\Template->render (line 51)
16	Twig\TemplateWrapper->render (line 333)
17	Twig\Environment->render (line 139)
18	App\EntityEngine\Views\ViewPageUrlModule->resolve (line 53)
19	App\Controller\Public\UrlEntryDispatchController->dispatch (line 181)
20	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
21	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
22	Symfony\Component\HttpKernel\Kernel->handle (line 35)
23	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
24	require_once (line 71)

0.82 ms
(1.25%)

SELECT * FROM ee_view WHERE id = ?

Parameters:

[
  39
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  *
FROM
  ee_view
WHERE
  id = ?

SELECT * FROM ee_view WHERE id = 39;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 593)
2	Doctrine\DBAL\Connection->fetchAssociative (line 111)
3	App\EntityEngine\Views\ViewStorage->get (line 465)
4	App\Service\Theme\BlockType\EeView\EeViewBlockType->resolveActiveView (line 247)
5	App\Service\Theme\BlockType\EeView\EeViewBlockType->render (line 52)
6	App\Service\Theme\BlockTypeRegistry->render (line 154)
7	App\Service\Theme\ThemeService->App\Service\Theme\{closure} (line 34)
8	App\Service\Theme\RenderStack->within (line 152)
9	App\Service\Theme\ThemeService->App\Service\Theme\{closure} (line 34)
10	App\Service\Theme\RenderStack->within (line 152)
11	App\Service\Theme\ThemeService->renderRegion (line 86)
12	App\Twig\ThemeExtension->themeRegion (line 149)
13	__TwigTemplate_9841bf9a74afab2a3cb3ad11d1624e81->doDisplay (line 402)
14	Twig\Template->yield (line 55)
15	__TwigTemplate_76f4671f53d28c3d5093cbcdb9c46f0f->doDisplay (line 402)
16	Twig\Template->yield (line 358)
17	Twig\Template->display (line 373)
18	Twig\Template->render (line 51)
19	Twig\TemplateWrapper->render (line 333)
20	Twig\Environment->render (line 139)
21	App\EntityEngine\Views\ViewPageUrlModule->resolve (line 53)
22	App\Controller\Public\UrlEntryDispatchController->dispatch (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.81 ms
(1.23%)

SELECT * FROM entity_category_view_mode WHERE name = ? AND type_id = ?

Parameters:

[
  "ikona"
  14
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  *
FROM
  entity_category_view_mode
WHERE
  name = ?
  AND type_id = ?

SELECT * FROM entity_category_view_mode WHERE name = 'ikona' AND type_id = 14;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 593)
2	Doctrine\DBAL\Connection->fetchAssociative (line 178)
3	App\EntityEngine\Definition\ViewModeManager->get (line 211)
4	App\EntityEngine\Definition\ViewModeManager->resolveName (line 138)
5	App\EntityEngine\Render\EntityRenderer->renderEntity (line 492)
6	App\EntityEngine\Views\ViewRenderService->App\EntityEngine\Views\{closure} (line 34)
7	App\Service\Theme\RenderStack->within (line 482)
8	App\EntityEngine\Views\ViewRenderService->renderPresentation (line 387)
9	App\Service\Theme\BlockType\EeView\EeViewBlockType->render (line 52)
10	App\Service\Theme\BlockTypeRegistry->render (line 154)
11	App\Service\Theme\ThemeService->App\Service\Theme\{closure} (line 34)
12	App\Service\Theme\RenderStack->within (line 152)
13	App\Service\Theme\ThemeService->App\Service\Theme\{closure} (line 34)
14	App\Service\Theme\RenderStack->within (line 152)
15	App\Service\Theme\ThemeService->renderRegion (line 86)
16	App\Twig\ThemeExtension->themeRegion (line 149)
17	__TwigTemplate_9841bf9a74afab2a3cb3ad11d1624e81->doDisplay (line 402)
18	Twig\Template->yield (line 55)
19	__TwigTemplate_76f4671f53d28c3d5093cbcdb9c46f0f->doDisplay (line 402)
20	Twig\Template->yield (line 358)
21	Twig\Template->display (line 373)
22	Twig\Template->render (line 51)
23	Twig\TemplateWrapper->render (line 333)
24	Twig\Environment->render (line 139)
25	App\EntityEngine\Views\ViewPageUrlModule->resolve (line 53)
26	App\Controller\Public\UrlEntryDispatchController->dispatch (line 181)
27	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
28	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
29	Symfony\Component\HttpKernel\Kernel->handle (line 35)
30	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
31	require_once (line 71)

0.79 ms
(1.20%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.mode AS mode_3, t0.scope_all_sites AS scope_all_sites_4, t0.inherit_from_parent_site AS inherit_from_parent_site_5, t0.show_shared_in_sites AS show_shared_in_sites_6, t0.status AS status_7 FROM navigation t0 WHERE t0.id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.mode AS mode_3,
  t0.scope_all_sites AS scope_all_sites_4,
  t0.inherit_from_parent_site AS inherit_from_parent_site_5,
  t0.show_shared_in_sites AS show_shared_in_sites_6,
  t0.status AS status_7
FROM
  navigation t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.mode AS mode_3, t0.scope_all_sites AS scope_all_sites_4, t0.inherit_from_parent_site AS inherit_from_parent_site_5, t0.show_shared_in_sites AS show_shared_in_sites_6, t0.status AS status_7 FROM navigation t0 WHERE t0.id = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 781)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 799)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 530)
4	Doctrine\ORM\EntityManager->find (line 196)
5	Doctrine\ORM\EntityRepository->find (line 199)
6	App\Service\NavigationService->getEffectiveTree (line 75)
7	App\Service\Theme\BlockType\Menu\MenuBlockType->render (line 52)
8	App\Service\Theme\BlockTypeRegistry->render (line 154)
9	App\Service\Theme\ThemeService->App\Service\Theme\{closure} (line 34)
10	App\Service\Theme\RenderStack->within (line 152)
11	App\Service\Theme\ThemeService->App\Service\Theme\{closure} (line 34)
12	App\Service\Theme\RenderStack->within (line 152)
13	App\Service\Theme\ThemeService->renderRegion (line 86)
14	App\Twig\ThemeExtension->themeRegion (line 153)
15	__TwigTemplate_9841bf9a74afab2a3cb3ad11d1624e81->doDisplay (line 402)
16	Twig\Template->yield (line 55)
17	__TwigTemplate_76f4671f53d28c3d5093cbcdb9c46f0f->doDisplay (line 402)
18	Twig\Template->yield (line 358)
19	Twig\Template->display (line 373)
20	Twig\Template->render (line 51)
21	Twig\TemplateWrapper->render (line 333)
22	Twig\Environment->render (line 139)
23	App\EntityEngine\Views\ViewPageUrlModule->resolve (line 53)
24	App\Controller\Public\UrlEntryDispatchController->dispatch (line 181)
25	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
26	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
27	Symfony\Component\HttpKernel\Kernel->handle (line 35)
28	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
29	require_once (line 71)

0.78 ms
(1.18%)

SELECT id, name FROM entity_category_view_mode WHERE type_id = ?

Parameters:

[
  14
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  id,
  name
FROM
  entity_category_view_mode
WHERE
  type_id = ?

SELECT id, name FROM entity_category_view_mode WHERE type_id = 14;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 907)
2	Doctrine\DBAL\Connection->fetchAllAssociative (line 669)
3	App\EntityEngine\Definition\SchemaReader->loadViewModeIds (line 470)
4	App\EntityEngine\Definition\SchemaReader->resolveViewModeId (line 552)
5	App\EntityEngine\Definition\SchemaReader->getDisplay (line 218)
6	App\EntityEngine\Render\EntityRenderer->buildEntityFields (line 161)
7	App\EntityEngine\Render\EntityRenderer->App\EntityEngine\Render\{closure} (line 34)
8	App\Service\Theme\RenderStack->within (line 142)
9	App\EntityEngine\Render\EntityRenderer->renderEntity (line 492)
10	App\EntityEngine\Views\ViewRenderService->App\EntityEngine\Views\{closure} (line 34)
11	App\Service\Theme\RenderStack->within (line 482)
12	App\EntityEngine\Views\ViewRenderService->renderPresentation (line 387)
13	App\Service\Theme\BlockType\EeView\EeViewBlockType->render (line 52)
14	App\Service\Theme\BlockTypeRegistry->render (line 154)
15	App\Service\Theme\ThemeService->App\Service\Theme\{closure} (line 34)
16	App\Service\Theme\RenderStack->within (line 152)
17	App\Service\Theme\ThemeService->App\Service\Theme\{closure} (line 34)
18	App\Service\Theme\RenderStack->within (line 152)
19	App\Service\Theme\ThemeService->renderRegion (line 86)
20	App\Twig\ThemeExtension->themeRegion (line 149)
21	__TwigTemplate_9841bf9a74afab2a3cb3ad11d1624e81->doDisplay (line 402)
22	Twig\Template->yield (line 55)
23	__TwigTemplate_76f4671f53d28c3d5093cbcdb9c46f0f->doDisplay (line 402)
24	Twig\Template->yield (line 358)
25	Twig\Template->display (line 373)
26	Twig\Template->render (line 51)
27	Twig\TemplateWrapper->render (line 333)
28	Twig\Environment->render (line 139)
29	App\EntityEngine\Views\ViewPageUrlModule->resolve (line 53)
30	App\Controller\Public\UrlEntryDispatchController->dispatch (line 181)
31	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
32	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
33	Symfony\Component\HttpKernel\Kernel->handle (line 35)
34	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
35	require_once (line 71)

0.75 ms
(1.15%)

SELECT t0.id AS id_1, t0.region AS region_2, t0.type AS type_3, t0.name AS name_4, t0.json AS json_5, t0.visibility AS visibility_6, t0.position AS position_7, t0.status AS status_8, t0.site_theme_id AS site_theme_id_9 FROM theme_block t0 WHERE t0.id IN (?, ?, ?, ?)

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.region AS region_2,
  t0.type AS type_3,
  t0.name AS name_4,
  t0.json AS json_5,
  t0.visibility AS visibility_6,
  t0.position AS position_7,
  t0.status AS status_8,
  t0.site_theme_id AS site_theme_id_9
FROM
  theme_block t0
WHERE
  t0.id IN (?, ?, ?, ?)

SELECT t0.id AS id_1, t0.region AS region_2, t0.type AS type_3, t0.name AS name_4, t0.json AS json_5, t0.visibility AS visibility_6, t0.position AS position_7, t0.status AS status_8, t0.site_theme_id AS site_theme_id_9 FROM theme_block t0 WHERE t0.id IN (33, 32, 134, 135);

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 974)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 224)
3	Doctrine\ORM\EntityRepository->findBy (line 415)
4	App\Service\Theme\ThemeService->hydrateBlocksInOrder (line 132)
5	App\Service\Theme\ThemeService->renderRegion (line 86)
6	App\Twig\ThemeExtension->themeRegion (line 193)
7	__TwigTemplate_9841bf9a74afab2a3cb3ad11d1624e81->doDisplay (line 402)
8	Twig\Template->yield (line 55)
9	__TwigTemplate_76f4671f53d28c3d5093cbcdb9c46f0f->doDisplay (line 402)
10	Twig\Template->yield (line 358)
11	Twig\Template->display (line 373)
12	Twig\Template->render (line 51)
13	Twig\TemplateWrapper->render (line 333)
14	Twig\Environment->render (line 139)
15	App\EntityEngine\Views\ViewPageUrlModule->resolve (line 53)
16	App\Controller\Public\UrlEntryDispatchController->dispatch (line 181)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
19	Symfony\Component\HttpKernel\Kernel->handle (line 35)
20	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
21	require_once (line 71)

0.75 ms
(1.15%)

SELECT e.id FROM entity_category e WHERE e.type_id IN (?) AND NOT (e.flags & 1) = 1 AND NOT (e.flags & 2) = 2 AND e.site_id = ? ORDER BY e.id DESC

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  e.id
FROM
  entity_category e
WHERE
  e.type_id IN (?)
  AND NOT (e.flags & 1) = 1
  AND NOT (e.flags & 2) = 2
  AND e.site_id = ?
ORDER BY
  e.id DESC

SELECT e.id FROM entity_category e WHERE e.type_id IN (14) AND NOT (e.flags & 1) = 1 AND NOT (e.flags & 2) = 2 AND e.site_id = 1 ORDER BY e.id DESC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 344)
2	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line 459)
3	App\EntityEngine\Query\EntityQuery->execute (line 648)
4	App\EntityEngine\Views\ViewExecutor->resolveIdsAndPagination (line 157)
5	App\EntityEngine\Views\ViewExecutor->executeLoaded (line 348)
6	App\Service\Theme\BlockType\EeView\EeViewBlockType->render (line 52)
7	App\Service\Theme\BlockTypeRegistry->render (line 154)
8	App\Service\Theme\ThemeService->App\Service\Theme\{closure} (line 34)
9	App\Service\Theme\RenderStack->within (line 152)
10	App\Service\Theme\ThemeService->App\Service\Theme\{closure} (line 34)
11	App\Service\Theme\RenderStack->within (line 152)
12	App\Service\Theme\ThemeService->renderRegion (line 86)
13	App\Twig\ThemeExtension->themeRegion (line 149)
14	__TwigTemplate_9841bf9a74afab2a3cb3ad11d1624e81->doDisplay (line 402)
15	Twig\Template->yield (line 55)
16	__TwigTemplate_76f4671f53d28c3d5093cbcdb9c46f0f->doDisplay (line 402)
17	Twig\Template->yield (line 358)
18	Twig\Template->display (line 373)
19	Twig\Template->render (line 51)
20	Twig\TemplateWrapper->render (line 333)
21	Twig\Environment->render (line 139)
22	App\EntityEngine\Views\ViewPageUrlModule->resolve (line 53)
23	App\Controller\Public\UrlEntryDispatchController->dispatch (line 181)
24	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
25	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
26	Symfony\Component\HttpKernel\Kernel->handle (line 35)
27	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
28	require_once (line 71)

0.74 ms
(1.12%)

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:

[
  1
]

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 = 1 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 139)
18	App\EntityEngine\Views\ViewPageUrlModule->resolve (line 53)
19	App\Controller\Public\UrlEntryDispatchController->dispatch (line 181)
20	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
21	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
22	Symfony\Component\HttpKernel\Kernel->handle (line 35)
23	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
24	require_once (line 71)

0.73 ms
(1.11%)

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 139)
26	App\EntityEngine\Views\ViewPageUrlModule->resolve (line 53)
27	App\Controller\Public\UrlEntryDispatchController->dispatch (line 181)
28	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
29	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
30	Symfony\Component\HttpKernel\Kernel->handle (line 35)
31	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
32	require_once (line 71)

0.72 ms
(1.09%)

SELECT * FROM ee_view WHERE slug = ?

Parameters:

[
  "wyszukiwarka"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  *
FROM
  ee_view
WHERE
  slug = ?

SELECT * FROM ee_view WHERE slug = 'wyszukiwarka';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 593)
2	Doctrine\DBAL\Connection->fetchAssociative (line 143)
3	App\EntityEngine\Views\ViewStorage->getBySlug (line 230)
4	App\EntityEngine\Views\ViewPageUrlModule->requirePageView (line 56)
5	App\EntityEngine\Views\ViewPageUrlModule->resolve (line 53)
6	App\Controller\Public\UrlEntryDispatchController->dispatch (line 181)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
9	Symfony\Component\HttpKernel\Kernel->handle (line 35)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
11	require_once (line 71)

0.70 ms
(1.07%)

SELECT * FROM entity_category_schema

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  *
FROM
  entity_category_schema

SELECT * FROM entity_category_schema;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 907)
2	Doctrine\DBAL\Connection->fetchAllAssociative (line 884)
3	App\EntityEngine\Definition\SchemaReader->loadFields (line 89)
4	App\EntityEngine\Definition\SchemaReader->getTopFields (line 126)
5	App\EntityEngine\Definition\SchemaReader->getEffectiveTopFields (line 197)
6	App\EntityEngine\Views\ViewFieldCatalog->dataFields (line 3205)
7	App\EntityEngine\Views\ViewDefinitionCompiler->assertItemLink (line 2647)
8	App\EntityEngine\Views\ViewDefinitionCompiler->assertPresentation (line 165)
9	App\EntityEngine\Views\ViewDefinitionCompiler->compile (line 645)
10	App\EntityEngine\Views\ViewExecutor->resolveIdsAndPagination (line 157)
11	App\EntityEngine\Views\ViewExecutor->executeLoaded (line 348)
12	App\Service\Theme\BlockType\EeView\EeViewBlockType->render (line 52)
13	App\Service\Theme\BlockTypeRegistry->render (line 154)
14	App\Service\Theme\ThemeService->App\Service\Theme\{closure} (line 34)
15	App\Service\Theme\RenderStack->within (line 152)
16	App\Service\Theme\ThemeService->App\Service\Theme\{closure} (line 34)
17	App\Service\Theme\RenderStack->within (line 152)
18	App\Service\Theme\ThemeService->renderRegion (line 86)
19	App\Twig\ThemeExtension->themeRegion (line 149)
20	__TwigTemplate_9841bf9a74afab2a3cb3ad11d1624e81->doDisplay (line 402)
21	Twig\Template->yield (line 55)
22	__TwigTemplate_76f4671f53d28c3d5093cbcdb9c46f0f->doDisplay (line 402)
23	Twig\Template->yield (line 358)
24	Twig\Template->display (line 373)
25	Twig\Template->render (line 51)
26	Twig\TemplateWrapper->render (line 333)
27	Twig\Environment->render (line 139)
28	App\EntityEngine\Views\ViewPageUrlModule->resolve (line 53)
29	App\Controller\Public\UrlEntryDispatchController->dispatch (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)

0.68 ms
(1.04%)

SELECT * FROM entity_file_schema

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  *
FROM
  entity_file_schema

SELECT * FROM entity_file_schema;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 907)
2	Doctrine\DBAL\Connection->fetchAllAssociative (line 884)
3	App\EntityEngine\Definition\SchemaReader->loadFields (line 89)
4	App\EntityEngine\Definition\SchemaReader->getTopFields (line 211)
5	App\EntityEngine\Definition\SchemaReader->getDynamicFields (line 2648)
6	App\EntityEngine\Storage\EntityStorage->withRuntimeComputedFields (line 183)
7	App\EntityEngine\Storage\EntityStorage->loadMultipleBatch (line 127)
8	App\EntityEngine\Storage\EntityStorage->loadMultiple (line 272)
9	App\EntityEngine\Storage\EntityStorage->load (line 283)
10	App\EntityEngine\Storage\EntityStorage->loadFileByUsage (line 425)
11	App\EntityEngine\Storage\EntityStorage->expandTarget (line 414)
12	App\EntityEngine\Storage\EntityStorage->App\EntityEngine\Storage\{closure} (line 347)
13	App\EntityEngine\FieldType\File\FileFieldType->expand (line 416)
14	App\EntityEngine\Storage\EntityStorage->expandSingleFieldValue (line 385)
15	App\EntityEngine\Storage\EntityStorage->expandFieldValue (line 357)
16	App\EntityEngine\Storage\EntityStorage->expandData (line 453)
17	App\EntityEngine\Storage\EntityStorage->expandTarget (line 414)
18	App\EntityEngine\Storage\EntityStorage->App\EntityEngine\Storage\{closure} (line 522)
19	App\EntityEngine\FieldType\Reference\ReferenceFieldType->expand (line 416)
20	App\EntityEngine\Storage\EntityStorage->expandSingleFieldValue (line 385)
21	App\EntityEngine\Storage\EntityStorage->expandFieldValue (line 357)
22	App\EntityEngine\Storage\EntityStorage->expandData (line 335)
23	App\EntityEngine\Storage\EntityStorage->expand (line 124)
24	App\EntityEngine\Render\EntityRenderer->renderEntity (line 492)
25	App\EntityEngine\Views\ViewRenderService->App\EntityEngine\Views\{closure} (line 34)
26	App\Service\Theme\RenderStack->within (line 482)
27	App\EntityEngine\Views\ViewRenderService->renderPresentation (line 387)
28	App\Service\Theme\BlockType\EeView\EeViewBlockType->render (line 52)
29	App\Service\Theme\BlockTypeRegistry->render (line 154)
30	App\Service\Theme\ThemeService->App\Service\Theme\{closure} (line 34)
31	App\Service\Theme\RenderStack->within (line 152)
32	App\Service\Theme\ThemeService->App\Service\Theme\{closure} (line 34)
33	App\Service\Theme\RenderStack->within (line 152)
34	App\Service\Theme\ThemeService->renderRegion (line 86)
35	App\Twig\ThemeExtension->themeRegion (line 149)
36	__TwigTemplate_9841bf9a74afab2a3cb3ad11d1624e81->doDisplay (line 402)
37	Twig\Template->yield (line 55)
38	__TwigTemplate_76f4671f53d28c3d5093cbcdb9c46f0f->doDisplay (line 402)
39	Twig\Template->yield (line 358)
40	Twig\Template->display (line 373)
41	Twig\Template->render (line 51)
42	Twig\TemplateWrapper->render (line 333)
43	Twig\Environment->render (line 139)
44	App\EntityEngine\Views\ViewPageUrlModule->resolve (line 53)
45	App\Controller\Public\UrlEntryDispatchController->dispatch (line 181)
46	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
47	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
48	Symfony\Component\HttpKernel\Kernel->handle (line 35)
49	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
50	require_once (line 71)

0.59 ms
(0.90%)

SELECT def_hash FROM ee_file_style WHERE id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  def_hash
FROM
  ee_file_style
WHERE
  id = ?

SELECT def_hash FROM ee_file_style WHERE id = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 627)
2	Doctrine\DBAL\Connection->fetchOne (line 1197)
3	App\EntityEngine\Kind\File\FileApi->styleColumn (line 1163)
4	App\EntityEngine\Kind\File\FileApi->styleDefHash (line 785)
5	App\EntityEngine\Kind\File\FileApi->variantKeyFor (line 195)
6	App\EntityEngine\Kind\File\FileApi->url (line 278)
7	App\EntityEngine\Kind\File\FileApi->urlForRow (line 116)
8	App\Twig\ThemeExtension->themeFile (line 66)
9	__TwigTemplate_9841bf9a74afab2a3cb3ad11d1624e81->doDisplay (line 402)
10	Twig\Template->yield (line 55)
11	__TwigTemplate_76f4671f53d28c3d5093cbcdb9c46f0f->doDisplay (line 402)
12	Twig\Template->yield (line 358)
13	Twig\Template->display (line 373)
14	Twig\Template->render (line 51)
15	Twig\TemplateWrapper->render (line 333)
16	Twig\Environment->render (line 139)
17	App\EntityEngine\Views\ViewPageUrlModule->resolve (line 53)
18	App\Controller\Public\UrlEntryDispatchController->dispatch (line 181)
19	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
20	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
21	Symfony\Component\HttpKernel\Kernel->handle (line 35)
22	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
23	require_once (line 71)

0.59 ms
(0.90%)

SELECT definition FROM ee_file_style WHERE id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  definition
FROM
  ee_file_style
WHERE
  id = ?

SELECT definition FROM ee_file_style WHERE id = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 627)
2	Doctrine\DBAL\Connection->fetchOne (line 1197)
3	App\EntityEngine\Kind\File\FileApi->styleColumn (line 1171)
4	App\EntityEngine\Kind\File\FileApi->styleSteps (line 518)
5	App\EntityEngine\Kind\File\FileApi->dimensionsFor (line 121)
6	App\Twig\ThemeExtension->themeFile (line 66)
7	__TwigTemplate_9841bf9a74afab2a3cb3ad11d1624e81->doDisplay (line 402)
8	Twig\Template->yield (line 55)
9	__TwigTemplate_76f4671f53d28c3d5093cbcdb9c46f0f->doDisplay (line 402)
10	Twig\Template->yield (line 358)
11	Twig\Template->display (line 373)
12	Twig\Template->render (line 51)
13	Twig\TemplateWrapper->render (line 333)
14	Twig\Environment->render (line 139)
15	App\EntityEngine\Views\ViewPageUrlModule->resolve (line 53)
16	App\Controller\Public\UrlEntryDispatchController->dispatch (line 181)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
19	Symfony\Component\HttpKernel\Kernel->handle (line 35)
20	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
21	require_once (line 71)

0.59 ms
(0.89%)

SELECT COUNT(*) FROM entity_content e WHERE e.type_id IN (?, ?, ?, ?) AND NOT (e.flags & 1) = 1 AND NOT (e.flags & 2) = 2 AND (e.site_id = ? AND e.id = ?)

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(*)
FROM
  entity_content e
WHERE
  e.type_id IN (?, ?, ?, ?)
  AND NOT (e.flags & 1) = 1
  AND NOT (e.flags & 2) = 2
  AND (
    e.site_id = ?
    AND e.id = ?
  )

SELECT COUNT(*) FROM entity_content e WHERE e.type_id IN (1, 2, 3, 5) AND NOT (e.flags & 1) = 1 AND NOT (e.flags & 2) = 2 AND (e.site_id = 1 AND e.id = 0);

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 344)
2	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line 489)
3	App\EntityEngine\Query\EntityQuery->count (line 654)
4	App\EntityEngine\Views\ViewExecutor->resolveIdsAndPagination (line 157)
5	App\EntityEngine\Views\ViewExecutor->executeLoaded (line 212)
6	App\EntityEngine\Views\ViewRenderService->render (line 104)
7	App\EntityEngine\Views\ViewCurrentContentProvider->render (line 79)
8	App\Service\Theme\BlockType\CurrentContent\CurrentContentBlockType->render (line 52)
9	App\Service\Theme\BlockTypeRegistry->render (line 154)
10	App\Service\Theme\ThemeService->App\Service\Theme\{closure} (line 34)
11	App\Service\Theme\RenderStack->within (line 152)
12	App\Service\Theme\ThemeService->App\Service\Theme\{closure} (line 34)
13	App\Service\Theme\RenderStack->within (line 152)
14	App\Service\Theme\ThemeService->renderRegion (line 86)
15	App\Twig\ThemeExtension->themeRegion (line 203)
16	__TwigTemplate_9841bf9a74afab2a3cb3ad11d1624e81->doDisplay (line 402)
17	Twig\Template->yield (line 55)
18	__TwigTemplate_76f4671f53d28c3d5093cbcdb9c46f0f->doDisplay (line 402)
19	Twig\Template->yield (line 358)
20	Twig\Template->display (line 373)
21	Twig\Template->render (line 51)
22	Twig\TemplateWrapper->render (line 333)
23	Twig\Environment->render (line 139)
24	App\EntityEngine\Views\ViewPageUrlModule->resolve (line 53)
25	App\Controller\Public\UrlEntryDispatchController->dispatch (line 181)
26	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
27	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
28	Symfony\Component\HttpKernel\Kernel->handle (line 35)
29	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
30	require_once (line 71)

0.57 ms
(0.87%)

SELECT t0.id AS id_1, t0.region AS region_2, t0.type AS type_3, t0.name AS name_4, t0.json AS json_5, t0.visibility AS visibility_6, t0.position AS position_7, t0.status AS status_8, t0.site_theme_id AS site_theme_id_9 FROM theme_block t0 WHERE t0.id IN (?, ?, ?, ?, ?, ?)

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.region AS region_2,
  t0.type AS type_3,
  t0.name AS name_4,
  t0.json AS json_5,
  t0.visibility AS visibility_6,
  t0.position AS position_7,
  t0.status AS status_8,
  t0.site_theme_id AS site_theme_id_9
FROM
  theme_block t0
WHERE
  t0.id IN (?, ?, ?, ?, ?, ?)

SELECT t0.id AS id_1, t0.region AS region_2, t0.type AS type_3, t0.name AS name_4, t0.json AS json_5, t0.visibility AS visibility_6, t0.position AS position_7, t0.status AS status_8, t0.site_theme_id AS site_theme_id_9 FROM theme_block t0 WHERE t0.id IN (142, 20, 21, 22, 23, 24);

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 974)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 224)
3	Doctrine\ORM\EntityRepository->findBy (line 415)
4	App\Service\Theme\ThemeService->hydrateBlocksInOrder (line 132)
5	App\Service\Theme\ThemeService->renderRegion (line 86)
6	App\Twig\ThemeExtension->themeRegion (line 198)
7	__TwigTemplate_9841bf9a74afab2a3cb3ad11d1624e81->doDisplay (line 402)
8	Twig\Template->yield (line 55)
9	__TwigTemplate_76f4671f53d28c3d5093cbcdb9c46f0f->doDisplay (line 402)
10	Twig\Template->yield (line 358)
11	Twig\Template->display (line 373)
12	Twig\Template->render (line 51)
13	Twig\TemplateWrapper->render (line 333)
14	Twig\Environment->render (line 139)
15	App\EntityEngine\Views\ViewPageUrlModule->resolve (line 53)
16	App\Controller\Public\UrlEntryDispatchController->dispatch (line 181)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
19	Symfony\Component\HttpKernel\Kernel->handle (line 35)
20	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
21	require_once (line 71)

0.55 ms
(0.84%)

SELECT * FROM entity_file_type

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  *
FROM
  entity_file_type

SELECT * FROM entity_file_type;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 907)
2	Doctrine\DBAL\Connection->fetchAllAssociative (line 856)
3	App\EntityEngine\Definition\SchemaReader->loadTypes (line 79)
4	App\EntityEngine\Definition\SchemaReader->resolveTypeId (line 2642)
5	App\EntityEngine\Storage\EntityStorage->withRuntimeComputedFields (line 183)
6	App\EntityEngine\Storage\EntityStorage->loadMultipleBatch (line 127)
7	App\EntityEngine\Storage\EntityStorage->loadMultiple (line 272)
8	App\EntityEngine\Storage\EntityStorage->load (line 283)
9	App\EntityEngine\Storage\EntityStorage->loadFileByUsage (line 425)
10	App\EntityEngine\Storage\EntityStorage->expandTarget (line 414)
11	App\EntityEngine\Storage\EntityStorage->App\EntityEngine\Storage\{closure} (line 347)
12	App\EntityEngine\FieldType\File\FileFieldType->expand (line 416)
13	App\EntityEngine\Storage\EntityStorage->expandSingleFieldValue (line 385)
14	App\EntityEngine\Storage\EntityStorage->expandFieldValue (line 357)
15	App\EntityEngine\Storage\EntityStorage->expandData (line 453)
16	App\EntityEngine\Storage\EntityStorage->expandTarget (line 414)
17	App\EntityEngine\Storage\EntityStorage->App\EntityEngine\Storage\{closure} (line 522)
18	App\EntityEngine\FieldType\Reference\ReferenceFieldType->expand (line 416)
19	App\EntityEngine\Storage\EntityStorage->expandSingleFieldValue (line 385)
20	App\EntityEngine\Storage\EntityStorage->expandFieldValue (line 357)
21	App\EntityEngine\Storage\EntityStorage->expandData (line 335)
22	App\EntityEngine\Storage\EntityStorage->expand (line 124)
23	App\EntityEngine\Render\EntityRenderer->renderEntity (line 492)
24	App\EntityEngine\Views\ViewRenderService->App\EntityEngine\Views\{closure} (line 34)
25	App\Service\Theme\RenderStack->within (line 482)
26	App\EntityEngine\Views\ViewRenderService->renderPresentation (line 387)
27	App\Service\Theme\BlockType\EeView\EeViewBlockType->render (line 52)
28	App\Service\Theme\BlockTypeRegistry->render (line 154)
29	App\Service\Theme\ThemeService->App\Service\Theme\{closure} (line 34)
30	App\Service\Theme\RenderStack->within (line 152)
31	App\Service\Theme\ThemeService->App\Service\Theme\{closure} (line 34)
32	App\Service\Theme\RenderStack->within (line 152)
33	App\Service\Theme\ThemeService->renderRegion (line 86)
34	App\Twig\ThemeExtension->themeRegion (line 149)
35	__TwigTemplate_9841bf9a74afab2a3cb3ad11d1624e81->doDisplay (line 402)
36	Twig\Template->yield (line 55)
37	__TwigTemplate_76f4671f53d28c3d5093cbcdb9c46f0f->doDisplay (line 402)
38	Twig\Template->yield (line 358)
39	Twig\Template->display (line 373)
40	Twig\Template->render (line 51)
41	Twig\TemplateWrapper->render (line 333)
42	Twig\Environment->render (line 139)
43	App\EntityEngine\Views\ViewPageUrlModule->resolve (line 53)
44	App\Controller\Public\UrlEntryDispatchController->dispatch (line 181)
45	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
46	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
47	Symfony\Component\HttpKernel\Kernel->handle (line 35)
48	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
49	require_once (line 71)

0.55 ms
(0.84%)

SELECT * FROM entity_content_type

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  *
FROM
  entity_content_type

SELECT * FROM entity_content_type;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 907)
2	Doctrine\DBAL\Connection->fetchAllAssociative (line 856)
3	App\EntityEngine\Definition\SchemaReader->loadTypes (line 66)
4	App\EntityEngine\Definition\SchemaReader->getType (line 76)
5	App\EntityEngine\Definition\SchemaReader->resolveTypeId (line 68)
6	App\EntityEngine\Views\ViewFieldCatalog->resolveTypeIds (line 1003)
7	App\EntityEngine\Views\ViewDefinitionCompiler->collectExposedFromDefinition (line 689)
8	App\EntityEngine\Views\ViewDefinitionCompiler->exposedFieldsOf (line 864)
9	App\EntityEngine\Views\ViewDefinitionCompiler->exposedControlsOf (line 105)
10	App\EntityEngine\Views\ViewPageUrlModule->resolve (line 53)
11	App\Controller\Public\UrlEntryDispatchController->dispatch (line 181)
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.52 ms
(0.79%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.mode AS mode_3, t0.scope_all_sites AS scope_all_sites_4, t0.inherit_from_parent_site AS inherit_from_parent_site_5, t0.show_shared_in_sites AS show_shared_in_sites_6, t0.status AS status_7 FROM navigation t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.mode AS mode_3,
  t0.scope_all_sites AS scope_all_sites_4,
  t0.inherit_from_parent_site AS inherit_from_parent_site_5,
  t0.show_shared_in_sites AS show_shared_in_sites_6,
  t0.status AS status_7
FROM
  navigation t0

SELECT t0.id AS id_1, t0.name AS name_2, t0.mode AS mode_3, t0.scope_all_sites AS scope_all_sites_4, t0.inherit_from_parent_site AS inherit_from_parent_site_5, t0.show_shared_in_sites AS show_shared_in_sites_6, t0.status AS status_7 FROM navigation 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 206)
4	Doctrine\ORM\EntityRepository->findAll (line 241)
5	App\Service\NavigationService->getForSite (line 205)
6	App\Service\Theme\BlockType\Breadcrumbs\BreadcrumbsBlockType->resolveNavigationIds (line 105)
7	App\Service\Theme\BlockType\Breadcrumbs\BreadcrumbsBlockType->render (line 52)
8	App\Service\Theme\BlockTypeRegistry->render (line 154)
9	App\Service\Theme\ThemeService->App\Service\Theme\{closure} (line 34)
10	App\Service\Theme\RenderStack->within (line 152)
11	App\Service\Theme\ThemeService->App\Service\Theme\{closure} (line 34)
12	App\Service\Theme\RenderStack->within (line 152)
13	App\Service\Theme\ThemeService->renderRegion (line 86)
14	App\Twig\ThemeExtension->themeRegion (line 193)
15	__TwigTemplate_9841bf9a74afab2a3cb3ad11d1624e81->doDisplay (line 402)
16	Twig\Template->yield (line 55)
17	__TwigTemplate_76f4671f53d28c3d5093cbcdb9c46f0f->doDisplay (line 402)
18	Twig\Template->yield (line 358)
19	Twig\Template->display (line 373)
20	Twig\Template->render (line 51)
21	Twig\TemplateWrapper->render (line 333)
22	Twig\Environment->render (line 139)
23	App\EntityEngine\Views\ViewPageUrlModule->resolve (line 53)
24	App\Controller\Public\UrlEntryDispatchController->dispatch (line 181)
25	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
26	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
27	Symfony\Component\HttpKernel\Kernel->handle (line 35)
28	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
29	require_once (line 71)

0.49 ms
(0.74%)

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)

0.46 ms
(0.71%)

SELECT * FROM entity_category_view_mode WHERE name = ? AND type_id IS NULL

Parameters:

[
  "ikona"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  *
FROM
  entity_category_view_mode
WHERE
  name = ?
  AND type_id IS NULL

SELECT * FROM entity_category_view_mode WHERE name = 'ikona' AND type_id IS NULL;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 593)
2	Doctrine\DBAL\Connection->fetchAssociative (line 183)
3	App\EntityEngine\Definition\ViewModeManager->get (line 211)
4	App\EntityEngine\Definition\ViewModeManager->resolveName (line 138)
5	App\EntityEngine\Render\EntityRenderer->renderEntity (line 492)
6	App\EntityEngine\Views\ViewRenderService->App\EntityEngine\Views\{closure} (line 34)
7	App\Service\Theme\RenderStack->within (line 482)
8	App\EntityEngine\Views\ViewRenderService->renderPresentation (line 387)
9	App\Service\Theme\BlockType\EeView\EeViewBlockType->render (line 52)
10	App\Service\Theme\BlockTypeRegistry->render (line 154)
11	App\Service\Theme\ThemeService->App\Service\Theme\{closure} (line 34)
12	App\Service\Theme\RenderStack->within (line 152)
13	App\Service\Theme\ThemeService->App\Service\Theme\{closure} (line 34)
14	App\Service\Theme\RenderStack->within (line 152)
15	App\Service\Theme\ThemeService->renderRegion (line 86)
16	App\Twig\ThemeExtension->themeRegion (line 149)
17	__TwigTemplate_9841bf9a74afab2a3cb3ad11d1624e81->doDisplay (line 402)
18	Twig\Template->yield (line 55)
19	__TwigTemplate_76f4671f53d28c3d5093cbcdb9c46f0f->doDisplay (line 402)
20	Twig\Template->yield (line 358)
21	Twig\Template->display (line 373)
22	Twig\Template->render (line 51)
23	Twig\TemplateWrapper->render (line 333)
24	Twig\Environment->render (line 139)
25	App\EntityEngine\Views\ViewPageUrlModule->resolve (line 53)
26	App\Controller\Public\UrlEntryDispatchController->dispatch (line 181)
27	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
28	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
29	Symfony\Component\HttpKernel\Kernel->handle (line 35)
30	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
31	require_once (line 71)

0.45 ms
(0.68%)

SELECT id, name FROM entity_category_view_mode WHERE type_id IS NULL

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  id,
  name
FROM
  entity_category_view_mode
WHERE
  type_id IS NULL

SELECT id, name FROM entity_category_view_mode WHERE type_id IS NULL;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 907)
2	Doctrine\DBAL\Connection->fetchAllAssociative (line 693)
3	App\EntityEngine\Definition\SchemaReader->loadCommonViewModeIds (line 674)
4	App\EntityEngine\Definition\SchemaReader->loadViewModeIds (line 470)
5	App\EntityEngine\Definition\SchemaReader->resolveViewModeId (line 552)
6	App\EntityEngine\Definition\SchemaReader->getDisplay (line 218)
7	App\EntityEngine\Render\EntityRenderer->buildEntityFields (line 161)
8	App\EntityEngine\Render\EntityRenderer->App\EntityEngine\Render\{closure} (line 34)
9	App\Service\Theme\RenderStack->within (line 142)
10	App\EntityEngine\Render\EntityRenderer->renderEntity (line 492)
11	App\EntityEngine\Views\ViewRenderService->App\EntityEngine\Views\{closure} (line 34)
12	App\Service\Theme\RenderStack->within (line 482)
13	App\EntityEngine\Views\ViewRenderService->renderPresentation (line 387)
14	App\Service\Theme\BlockType\EeView\EeViewBlockType->render (line 52)
15	App\Service\Theme\BlockTypeRegistry->render (line 154)
16	App\Service\Theme\ThemeService->App\Service\Theme\{closure} (line 34)
17	App\Service\Theme\RenderStack->within (line 152)
18	App\Service\Theme\ThemeService->App\Service\Theme\{closure} (line 34)
19	App\Service\Theme\RenderStack->within (line 152)
20	App\Service\Theme\ThemeService->renderRegion (line 86)
21	App\Twig\ThemeExtension->themeRegion (line 149)
22	__TwigTemplate_9841bf9a74afab2a3cb3ad11d1624e81->doDisplay (line 402)
23	Twig\Template->yield (line 55)
24	__TwigTemplate_76f4671f53d28c3d5093cbcdb9c46f0f->doDisplay (line 402)
25	Twig\Template->yield (line 358)
26	Twig\Template->display (line 373)
27	Twig\Template->render (line 51)
28	Twig\TemplateWrapper->render (line 333)
29	Twig\Environment->render (line 139)
30	App\EntityEngine\Views\ViewPageUrlModule->resolve (line 53)
31	App\Controller\Public\UrlEntryDispatchController->dispatch (line 181)
32	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
33	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
34	Symfony\Component\HttpKernel\Kernel->handle (line 35)
35	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
36	require_once (line 71)

0.42 ms
(0.65%)

SELECT * FROM entity_category_type

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  *
FROM
  entity_category_type

SELECT * FROM entity_category_type;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 907)
2	Doctrine\DBAL\Connection->fetchAllAssociative (line 856)
3	App\EntityEngine\Definition\SchemaReader->loadTypes (line 66)
4	App\EntityEngine\Definition\SchemaReader->getType (line 76)
5	App\EntityEngine\Definition\SchemaReader->resolveTypeId (line 68)
6	App\EntityEngine\Views\ViewFieldCatalog->resolveTypeIds (line 1003)
7	App\EntityEngine\Views\ViewDefinitionCompiler->collectExposedFromDefinition (line 689)
8	App\EntityEngine\Views\ViewDefinitionCompiler->exposedFieldsOf (line 280)
9	App\Service\Theme\BlockType\EeView\EeViewBlockType->render (line 52)
10	App\Service\Theme\BlockTypeRegistry->render (line 154)
11	App\Service\Theme\ThemeService->App\Service\Theme\{closure} (line 34)
12	App\Service\Theme\RenderStack->within (line 152)
13	App\Service\Theme\ThemeService->App\Service\Theme\{closure} (line 34)
14	App\Service\Theme\RenderStack->within (line 152)
15	App\Service\Theme\ThemeService->renderRegion (line 86)
16	App\Twig\ThemeExtension->themeRegion (line 149)
17	__TwigTemplate_9841bf9a74afab2a3cb3ad11d1624e81->doDisplay (line 402)
18	Twig\Template->yield (line 55)
19	__TwigTemplate_76f4671f53d28c3d5093cbcdb9c46f0f->doDisplay (line 402)
20	Twig\Template->yield (line 358)
21	Twig\Template->display (line 373)
22	Twig\Template->render (line 51)
23	Twig\TemplateWrapper->render (line 333)
24	Twig\Environment->render (line 139)
25	App\EntityEngine\Views\ViewPageUrlModule->resolve (line 53)
26	App\Controller\Public\UrlEntryDispatchController->dispatch (line 181)
27	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
28	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
29	Symfony\Component\HttpKernel\Kernel->handle (line 35)
30	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
31	require_once (line 71)

0.40 ms
(0.61%)

SELECT e.id FROM entity_content e WHERE e.type_id IN (?, ?, ?, ?) AND NOT (e.flags & 1) = 1 AND NOT (e.flags & 2) = 2 AND (e.site_id = ? AND e.id = ?) ORDER BY e.id DESC LIMIT 20

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  e.id
FROM
  entity_content e
WHERE
  e.type_id IN (?, ?, ?, ?)
  AND NOT (e.flags & 1) = 1
  AND NOT (e.flags & 2) = 2
  AND (
    e.site_id = ?
    AND e.id = ?
  )
ORDER BY
  e.id DESC
LIMIT
  20

SELECT e.id FROM entity_content e WHERE e.type_id IN (1, 2, 3, 5) AND NOT (e.flags & 1) = 1 AND NOT (e.flags & 2) = 2 AND (e.site_id = 1 AND e.id = 0) ORDER BY e.id DESC LIMIT 20;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 344)
2	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line 459)
3	App\EntityEngine\Query\EntityQuery->execute (line 658)
4	App\EntityEngine\Views\ViewExecutor->resolveIdsAndPagination (line 157)
5	App\EntityEngine\Views\ViewExecutor->executeLoaded (line 212)
6	App\EntityEngine\Views\ViewRenderService->render (line 104)
7	App\EntityEngine\Views\ViewCurrentContentProvider->render (line 79)
8	App\Service\Theme\BlockType\CurrentContent\CurrentContentBlockType->render (line 52)
9	App\Service\Theme\BlockTypeRegistry->render (line 154)
10	App\Service\Theme\ThemeService->App\Service\Theme\{closure} (line 34)
11	App\Service\Theme\RenderStack->within (line 152)
12	App\Service\Theme\ThemeService->App\Service\Theme\{closure} (line 34)
13	App\Service\Theme\RenderStack->within (line 152)
14	App\Service\Theme\ThemeService->renderRegion (line 86)
15	App\Twig\ThemeExtension->themeRegion (line 203)
16	__TwigTemplate_9841bf9a74afab2a3cb3ad11d1624e81->doDisplay (line 402)
17	Twig\Template->yield (line 55)
18	__TwigTemplate_76f4671f53d28c3d5093cbcdb9c46f0f->doDisplay (line 402)
19	Twig\Template->yield (line 358)
20	Twig\Template->display (line 373)
21	Twig\Template->render (line 51)
22	Twig\TemplateWrapper->render (line 333)
23	Twig\Environment->render (line 139)
24	App\EntityEngine\Views\ViewPageUrlModule->resolve (line 53)
25	App\Controller\Public\UrlEntryDispatchController->dispatch (line 181)
26	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
27	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
28	Symfony\Component\HttpKernel\Kernel->handle (line 35)
29	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
30	require_once (line 71)

0.31 ms
(0.47%)

SELECT * FROM entity_file_type WHERE id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  *
FROM
  entity_file_type
WHERE
  id = ?

SELECT * FROM entity_file_type WHERE id = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 593)
2	Doctrine\DBAL\Connection->fetchAssociative (line 321)
3	App\EntityEngine\Definition\TypeManager->get (line 1045)
4	App\EntityEngine\Kind\File\FileApi->disabledFileExtensionNames (line 1075)
5	App\EntityEngine\Kind\File\FileApi->ensureExtensions (line 1017)
6	App\EntityEngine\Kind\File\FileApi->enrichRow (line 1564)
7	App\EntityEngine\Render\EntityRenderer->fileInfo (line 926)
8	App\EntityEngine\Render\EntityRenderer->App\EntityEngine\Render\{closure} (line 34)
9	App\Service\Theme\RenderStack->within (line 862)
10	App\EntityEngine\Render\EntityRenderer->renderFieldValue (line 824)
11	App\EntityEngine\Render\EntityRenderer->renderFieldRow (line 641)
12	App\EntityEngine\Render\EntityRenderer->buildEntityFieldEntry (line 285)
13	App\EntityEngine\Render\EntityRenderer->buildEntityFields (line 161)
14	App\EntityEngine\Render\EntityRenderer->App\EntityEngine\Render\{closure} (line 34)
15	App\Service\Theme\RenderStack->within (line 142)
16	App\EntityEngine\Render\EntityRenderer->renderEntity (line 1490)
17	App\EntityEngine\Render\EntityRenderer->referenceEntityHtml (line 915)
18	App\EntityEngine\Render\EntityRenderer->App\EntityEngine\Render\{closure} (line 34)
19	App\Service\Theme\RenderStack->within (line 862)
20	App\EntityEngine\Render\EntityRenderer->renderFieldValue (line 824)
21	App\EntityEngine\Render\EntityRenderer->renderFieldRow (line 641)
22	App\EntityEngine\Render\EntityRenderer->buildEntityFieldEntry (line 285)
23	App\EntityEngine\Render\EntityRenderer->buildEntityFields (line 161)
24	App\EntityEngine\Render\EntityRenderer->App\EntityEngine\Render\{closure} (line 34)
25	App\Service\Theme\RenderStack->within (line 142)
26	App\EntityEngine\Render\EntityRenderer->renderEntity (line 492)
27	App\EntityEngine\Views\ViewRenderService->App\EntityEngine\Views\{closure} (line 34)
28	App\Service\Theme\RenderStack->within (line 482)
29	App\EntityEngine\Views\ViewRenderService->renderPresentation (line 387)
30	App\Service\Theme\BlockType\EeView\EeViewBlockType->render (line 52)
31	App\Service\Theme\BlockTypeRegistry->render (line 154)
32	App\Service\Theme\ThemeService->App\Service\Theme\{closure} (line 34)
33	App\Service\Theme\RenderStack->within (line 152)
34	App\Service\Theme\ThemeService->App\Service\Theme\{closure} (line 34)
35	App\Service\Theme\RenderStack->within (line 152)
36	App\Service\Theme\ThemeService->renderRegion (line 86)
37	App\Twig\ThemeExtension->themeRegion (line 149)
38	__TwigTemplate_9841bf9a74afab2a3cb3ad11d1624e81->doDisplay (line 402)
39	Twig\Template->yield (line 55)
40	__TwigTemplate_76f4671f53d28c3d5093cbcdb9c46f0f->doDisplay (line 402)
41	Twig\Template->yield (line 358)
42	Twig\Template->display (line 373)
43	Twig\Template->render (line 51)
44	Twig\TemplateWrapper->render (line 333)
45	Twig\Environment->render (line 139)
46	App\EntityEngine\Views\ViewPageUrlModule->resolve (line 53)
47	App\Controller\Public\UrlEntryDispatchController->dispatch (line 181)
48	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
49	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
50	Symfony\Component\HttpKernel\Kernel->handle (line 35)
51	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
52	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\Theme\Block	27
App\Entity\Site\Site	10
App\Entity\Navigation\Navigation	8
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\Enums\BlockStatus	No errors.
App\Entity\Theme\Block	No errors.
App\Entity\Enums\SiteInjectionStatus	No errors.
App\Entity\Site\SiteInjection	No errors.
App\Entity\Enums\NavigationStatus	No errors.
App\Entity\Navigation\Navigation	No errors.
App\Entity\Enums\NavigationItemStatus	No errors.
App\Entity\Navigation\NavigationItem	No errors.

Symfony Profiler

GET http://delk.wiemo.pl/wyszukiwanie

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping