Symfony Profiler

Query Metrics

111 Database Queries

63 Different statements

72.32 ms Query time

0 Invalid entities

43 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

17.52 ms
(24.22%)

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 75)
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)

7.97 ms
(11.02%)

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)

3.29 ms
(4.55%)

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

2.33 ms
(3.22%)

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 56)
7	__TwigTemplate_01c157d2d302c0ace2ca49c30f8a8196->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 191)
13	App\EntityEngine\Url\EntityUrlModule->renderPage (line 118)
14	App\EntityEngine\Url\EntityUrlModule->resolve (line 53)
15	App\Controller\Public\UrlEntryDispatchController->dispatch (line 181)
16	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
17	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
18	Symfony\Component\HttpKernel\Kernel->handle (line 35)
19	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
20	require_once (line 71)

2.32 ms
(3.21%)

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 71)
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.64 ms
(2.26%)

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 56)
9	__TwigTemplate_01c157d2d302c0ace2ca49c30f8a8196->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 191)
15	App\EntityEngine\Url\EntityUrlModule->renderPage (line 118)
16	App\EntityEngine\Url\EntityUrlModule->resolve (line 53)
17	App\Controller\Public\UrlEntryDispatchController->dispatch (line 181)
18	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
19	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
20	Symfony\Component\HttpKernel\Kernel->handle (line 35)
21	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
22	require_once (line 71)

1.56 ms
(2.16%)

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 56)
9	__TwigTemplate_01c157d2d302c0ace2ca49c30f8a8196->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 191)
15	App\EntityEngine\Url\EntityUrlModule->renderPage (line 118)
16	App\EntityEngine\Url\EntityUrlModule->resolve (line 53)
17	App\Controller\Public\UrlEntryDispatchController->dispatch (line 181)
18	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
19	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
20	Symfony\Component\HttpKernel\Kernel->handle (line 35)
21	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
22	require_once (line 71)

1.48 ms
(2.04%)

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 189)
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 56)
17	__TwigTemplate_01c157d2d302c0ace2ca49c30f8a8196->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 191)
23	App\EntityEngine\Url\EntityUrlModule->renderPage (line 118)
24	App\EntityEngine\Url\EntityUrlModule->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)

1.45 ms
(2.00%)

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.29 ms
(1.78%)

SELECT * FROM entity_content_schema

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  *
FROM
  entity_content_schema

SELECT * FROM entity_content_schema;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 907)
2	Doctrine\DBAL\Connection->fetchAllAssociative (line 870)
3	App\EntityEngine\Definition\SchemaReader->loadFields (line 89)
4	App\EntityEngine\Definition\SchemaReader->getTopFields (line 126)
5	App\EntityEngine\Definition\SchemaReader->getEffectiveTopFields (line 2137)
6	App\EntityEngine\Storage\EntityStorage->hydrateEntities (line 234)
7	App\EntityEngine\Storage\EntityStorage->buildEntities (line 151)
8	App\EntityEngine\Storage\EntityStorage->loadMultipleBatch (line 127)
9	App\EntityEngine\Storage\EntityStorage->loadMultiple (line 272)
10	App\EntityEngine\Storage\EntityStorage->load (line 1797)
11	App\EntityEngine\Storage\EntityStorage->loadPublished (line 83)
12	App\EntityEngine\Url\EntityUrlModule->resolve (line 53)
13	App\Controller\Public\UrlEntryDispatchController->dispatch (line 181)
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)

1.10 ms
(1.52%)

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

Parameters:

[
  1
  "/wydarzenia/bieg-po-zdrowie"
]

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 = '/wydarzenia/bieg-po-zdrowie' LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 593)
2	Doctrine\DBAL\Connection->fetchAssociative (line 111)
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.09 ms
(1.51%)

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 490)
8	App\EntityEngine\Views\ViewRenderService->App\EntityEngine\Views\{closure} (line 34)
9	App\Service\Theme\RenderStack->within (line 480)
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 56)
21	__TwigTemplate_01c157d2d302c0ace2ca49c30f8a8196->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 191)
27	App\EntityEngine\Url\EntityUrlModule->renderPage (line 118)
28	App\EntityEngine\Url\EntityUrlModule->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)

1.06 ms
(1.47%)

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 45)
3	App\Service\Url\UrlAliasRepository->memoizeTargets (line 238)
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 162)
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 56)
21	__TwigTemplate_01c157d2d302c0ace2ca49c30f8a8196->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 191)
27	App\EntityEngine\Url\EntityUrlModule->renderPage (line 118)
28	App\EntityEngine\Url\EntityUrlModule->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.95 ms
(1.31%)

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.95 ms
(1.31%)

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 56)
15	__TwigTemplate_01c157d2d302c0ace2ca49c30f8a8196->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 191)
21	App\EntityEngine\Url\EntityUrlModule->renderPage (line 118)
22	App\EntityEngine\Url\EntityUrlModule->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.95 ms
(1.31%)

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 56)
9	__TwigTemplate_01c157d2d302c0ace2ca49c30f8a8196->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 191)
15	App\EntityEngine\Url\EntityUrlModule->renderPage (line 118)
16	App\EntityEngine\Url\EntityUrlModule->resolve (line 53)
17	App\Controller\Public\UrlEntryDispatchController->dispatch (line 181)
18	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
19	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
20	Symfony\Component\HttpKernel\Kernel->handle (line 35)
21	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
22	require_once (line 71)

0.93 ms
(1.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 490)
12	App\EntityEngine\Views\ViewRenderService->App\EntityEngine\Views\{closure} (line 34)
13	App\Service\Theme\RenderStack->within (line 480)
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 56)
25	__TwigTemplate_01c157d2d302c0ace2ca49c30f8a8196->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 191)
31	App\EntityEngine\Url\EntityUrlModule->renderPage (line 118)
32	App\EntityEngine\Url\EntityUrlModule->resolve (line 53)
33	App\Controller\Public\UrlEntryDispatchController->dispatch (line 181)
34	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
35	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
36	Symfony\Component\HttpKernel\Kernel->handle (line 35)
37	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
38	require_once (line 71)

0.89 ms
(1.23%)

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

Parameters:

[
  "ee"
  "content:21"
]

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 ('content:21') ORDER BY id ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 907)
2	Doctrine\DBAL\Connection->fetchAllAssociative (line 45)
3	App\Service\Url\UrlAliasRepository->memoizeTargets (line 238)
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 272)
9	App\EntityEngine\Storage\EntityStorage->load (line 1797)
10	App\EntityEngine\Storage\EntityStorage->loadPublished (line 83)
11	App\EntityEngine\Url\EntityUrlModule->resolve (line 53)
12	App\Controller\Public\UrlEntryDispatchController->dispatch (line 181)
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)

0.83 ms
(1.14%)

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 490)
7	App\EntityEngine\Views\ViewRenderService->App\EntityEngine\Views\{closure} (line 34)
8	App\Service\Theme\RenderStack->within (line 480)
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 56)
20	__TwigTemplate_01c157d2d302c0ace2ca49c30f8a8196->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 191)
26	App\EntityEngine\Url\EntityUrlModule->renderPage (line 118)
27	App\EntityEngine\Url\EntityUrlModule->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)

0.76 ms
(1.05%)

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 490)
9	App\EntityEngine\Views\ViewRenderService->App\EntityEngine\Views\{closure} (line 34)
10	App\Service\Theme\RenderStack->within (line 480)
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 56)
22	__TwigTemplate_01c157d2d302c0ace2ca49c30f8a8196->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 191)
28	App\EntityEngine\Url\EntityUrlModule->renderPage (line 118)
29	App\EntityEngine\Url\EntityUrlModule->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.74 ms
(1.02%)

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 490)
10	App\EntityEngine\Views\ViewRenderService->App\EntityEngine\Views\{closure} (line 34)
11	App\Service\Theme\RenderStack->within (line 480)
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 56)
23	__TwigTemplate_01c157d2d302c0ace2ca49c30f8a8196->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 191)
29	App\EntityEngine\Url\EntityUrlModule->renderPage (line 118)
30	App\EntityEngine\Url\EntityUrlModule->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.72 ms
(1.00%)

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 56)
9	__TwigTemplate_01c157d2d302c0ace2ca49c30f8a8196->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 191)
15	App\EntityEngine\Url\EntityUrlModule->renderPage (line 118)
16	App\EntityEngine\Url\EntityUrlModule->resolve (line 53)
17	App\Controller\Public\UrlEntryDispatchController->dispatch (line 181)
18	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
19	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
20	Symfony\Component\HttpKernel\Kernel->handle (line 35)
21	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
22	require_once (line 71)

0.71 ms
(0.98%)

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

Parameters:

View formatted query View runnable query Explain query View query backtrace

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

SELECT * FROM entity_content_meta_display WHERE type_id = 3 AND view_mode_id = 4;

#	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 157)
9	App\EntityEngine\Url\EntityCurrentContentProvider->render (line 79)
10	App\Service\Theme\BlockType\CurrentContent\CurrentContentBlockType->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 203)
18	__TwigTemplate_9841bf9a74afab2a3cb3ad11d1624e81->doDisplay (line 402)
19	Twig\Template->yield (line 56)
20	__TwigTemplate_01c157d2d302c0ace2ca49c30f8a8196->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 191)
26	App\EntityEngine\Url\EntityUrlModule->renderPage (line 118)
27	App\EntityEngine\Url\EntityUrlModule->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)

0.71 ms
(0.98%)

SELECT * FROM entity_content_data_text WHERE (entity_id IN (?)) AND (field_id IN (?, ?, ?)) AND (rev_id IN (?)) ORDER BY delta ASC, id ASC

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  *
FROM
  entity_content_data_text
WHERE
  (
    entity_id IN (?)
  )
  AND (
    field_id IN (?, ?, ?)
  )
  AND (
    rev_id IN (?)
  )
ORDER BY
  delta ASC,
  id ASC

SELECT * FROM entity_content_data_text WHERE (entity_id IN (21)) AND (field_id IN (23, 24, 25)) AND (rev_id IN (40)) ORDER BY delta ASC, id ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 344)
2	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line 70)
3	App\EntityEngine\Storage\FieldDataStorage->fetchRows (line 2232)
4	App\EntityEngine\Storage\EntityStorage->loadFieldValues (line 2168)
5	App\EntityEngine\Storage\EntityStorage->hydrateEntities (line 234)
6	App\EntityEngine\Storage\EntityStorage->buildEntities (line 151)
7	App\EntityEngine\Storage\EntityStorage->loadMultipleBatch (line 127)
8	App\EntityEngine\Storage\EntityStorage->loadMultiple (line 272)
9	App\EntityEngine\Storage\EntityStorage->load (line 1797)
10	App\EntityEngine\Storage\EntityStorage->loadPublished (line 83)
11	App\EntityEngine\Url\EntityUrlModule->resolve (line 53)
12	App\Controller\Public\UrlEntryDispatchController->dispatch (line 181)
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)

0.70 ms
(0.97%)

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 56)
11	__TwigTemplate_01c157d2d302c0ace2ca49c30f8a8196->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 191)
17	App\EntityEngine\Url\EntityUrlModule->renderPage (line 118)
18	App\EntityEngine\Url\EntityUrlModule->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.69 ms
(0.96%)

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

Parameters:

[
  "ee"
  "content:47"
  "content:36"
  "content:35"
  "content:10"
  "content:9"
  "content:7"
  "content:6"
  "content:5"
  "content:4"
  "content:3"
]

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 ('content:47', 'content:36', 'content:35', 'content:10', 'content:9', 'content:7', 'content:6', 'content:5', 'content:4', 'content:3') ORDER BY id ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 907)
2	Doctrine\DBAL\Connection->fetchAllAssociative (line 45)
3	App\Service\Url\UrlAliasRepository->memoizeTargets (line 238)
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 162)
10	App\EntityEngine\Views\ViewExecutor->executeLoaded (line 182)
11	App\EntityEngine\Views\ViewQuery->execute (line 177)
12	App\Service\Theme\BlockType\PreviousNext\PreviousNextBlockType->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 203)
20	__TwigTemplate_9841bf9a74afab2a3cb3ad11d1624e81->doDisplay (line 402)
21	Twig\Template->yield (line 56)
22	__TwigTemplate_01c157d2d302c0ace2ca49c30f8a8196->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 191)
28	App\EntityEngine\Url\EntityUrlModule->renderPage (line 118)
29	App\EntityEngine\Url\EntityUrlModule->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.69 ms
(0.95%)

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 IN (?)

Parameters:

[
  34
]

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 IN (?)

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 IN (34);

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 907)
2	Doctrine\DBAL\Connection->fetchAllAssociative (line 246)
3	App\EntityEngine\Kind\File\FileRepositoryService->findByUsageIds (line 168)
4	App\EntityEngine\Kind\File\FileRepositoryService->primeUsages (line 2315)
5	App\EntityEngine\Storage\EntityStorage->loadFieldValues (line 2168)
6	App\EntityEngine\Storage\EntityStorage->hydrateEntities (line 234)
7	App\EntityEngine\Storage\EntityStorage->buildEntities (line 151)
8	App\EntityEngine\Storage\EntityStorage->loadMultipleBatch (line 127)
9	App\EntityEngine\Storage\EntityStorage->loadMultiple (line 272)
10	App\EntityEngine\Storage\EntityStorage->load (line 1797)
11	App\EntityEngine\Storage\EntityStorage->loadPublished (line 83)
12	App\EntityEngine\Url\EntityUrlModule->resolve (line 53)
13	App\Controller\Public\UrlEntryDispatchController->dispatch (line 181)
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)

0.66 ms
(0.91%)

SELECT * FROM entity_content WHERE id IN (?)

Parameters:

[
  21
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  *
FROM
  entity_content
WHERE
  id IN (?)

SELECT * FROM entity_content WHERE id IN (21);

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 344)
2	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line 232)
3	App\EntityEngine\Storage\EntityStorage->buildEntities (line 151)
4	App\EntityEngine\Storage\EntityStorage->loadMultipleBatch (line 127)
5	App\EntityEngine\Storage\EntityStorage->loadMultiple (line 272)
6	App\EntityEngine\Storage\EntityStorage->load (line 1797)
7	App\EntityEngine\Storage\EntityStorage->loadPublished (line 83)
8	App\EntityEngine\Url\EntityUrlModule->resolve (line 53)
9	App\Controller\Public\UrlEntryDispatchController->dispatch (line 181)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
12	Symfony\Component\HttpKernel\Kernel->handle (line 35)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
14	require_once (line 71)

0.61 ms
(0.85%)

SELECT id, status_id FROM entity_content_revision WHERE id IN (?) AND status_id IS NOT NULL

Parameters:

[
  40
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  id,
  status_id
FROM
  entity_content_revision
WHERE
  id IN (?)
  AND status_id IS NOT NULL

SELECT id, status_id FROM entity_content_revision WHERE id IN (40) AND status_id IS NOT NULL;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 907)
2	Doctrine\DBAL\Connection->fetchAllAssociative (line 61)
3	App\EntityEngine\Storage\RevisionStorage->getStatuses (line 2124)
4	App\EntityEngine\Storage\EntityStorage->hydrateEntities (line 234)
5	App\EntityEngine\Storage\EntityStorage->buildEntities (line 151)
6	App\EntityEngine\Storage\EntityStorage->loadMultipleBatch (line 127)
7	App\EntityEngine\Storage\EntityStorage->loadMultiple (line 272)
8	App\EntityEngine\Storage\EntityStorage->load (line 1797)
9	App\EntityEngine\Storage\EntityStorage->loadPublished (line 83)
10	App\EntityEngine\Url\EntityUrlModule->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.58 ms
(0.81%)

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 = ? ORDER BY e.id DESC

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 = ?
ORDER BY
  e.id DESC

SELECT e.id FROM entity_content e WHERE e.type_id IN (1) 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 645)
4	App\EntityEngine\Views\ViewExecutor->resolveIdsAndPagination (line 154)
5	App\EntityEngine\Views\ViewExecutor->executeLoaded (line 182)
6	App\EntityEngine\Views\ViewQuery->execute (line 177)
7	App\Service\Theme\BlockType\PreviousNext\PreviousNextBlockType->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 203)
15	__TwigTemplate_9841bf9a74afab2a3cb3ad11d1624e81->doDisplay (line 402)
16	Twig\Template->yield (line 56)
17	__TwigTemplate_01c157d2d302c0ace2ca49c30f8a8196->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 191)
23	App\EntityEngine\Url\EntityUrlModule->renderPage (line 118)
24	App\EntityEngine\Url\EntityUrlModule->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.58 ms
(0.80%)

SELECT * FROM entity_content_translation WHERE entity_id IN (?)

Parameters:

[
  21
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  *
FROM
  entity_content_translation
WHERE
  entity_id IN (?)

SELECT * FROM entity_content_translation WHERE entity_id IN (21);

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 344)
2	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line 61)
3	App\EntityEngine\Storage\TranslationStorage->listForEntities (line 2104)
4	App\EntityEngine\Storage\EntityStorage->hydrateEntities (line 234)
5	App\EntityEngine\Storage\EntityStorage->buildEntities (line 151)
6	App\EntityEngine\Storage\EntityStorage->loadMultipleBatch (line 127)
7	App\EntityEngine\Storage\EntityStorage->loadMultiple (line 272)
8	App\EntityEngine\Storage\EntityStorage->load (line 1797)
9	App\EntityEngine\Storage\EntityStorage->loadPublished (line 83)
10	App\EntityEngine\Url\EntityUrlModule->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.56 ms
(0.78%)

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	ContainerA8mDo3G\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 191)
26	App\EntityEngine\Url\EntityUrlModule->renderPage (line 118)
27	App\EntityEngine\Url\EntityUrlModule->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)

0.55 ms
(0.77%)

SELECT * FROM entity_content_data_date WHERE (entity_id IN (?)) AND (field_id IN (?)) AND (rev_id IN (?)) ORDER BY delta ASC, id ASC

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  *
FROM
  entity_content_data_date
WHERE
  (
    entity_id IN (?)
  )
  AND (
    field_id IN (?)
  )
  AND (
    rev_id IN (?)
  )
ORDER BY
  delta ASC,
  id ASC

SELECT * FROM entity_content_data_date WHERE (entity_id IN (21)) AND (field_id IN (54)) AND (rev_id IN (40)) ORDER BY delta ASC, id ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 344)
2	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line 70)
3	App\EntityEngine\Storage\FieldDataStorage->fetchRows (line 2232)
4	App\EntityEngine\Storage\EntityStorage->loadFieldValues (line 2168)
5	App\EntityEngine\Storage\EntityStorage->hydrateEntities (line 234)
6	App\EntityEngine\Storage\EntityStorage->buildEntities (line 151)
7	App\EntityEngine\Storage\EntityStorage->loadMultipleBatch (line 127)
8	App\EntityEngine\Storage\EntityStorage->loadMultiple (line 272)
9	App\EntityEngine\Storage\EntityStorage->load (line 1797)
10	App\EntityEngine\Storage\EntityStorage->loadPublished (line 83)
11	App\EntityEngine\Url\EntityUrlModule->resolve (line 53)
12	App\Controller\Public\UrlEntryDispatchController->dispatch (line 181)
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)

0.55 ms
(0.76%)

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 56)
9	__TwigTemplate_01c157d2d302c0ace2ca49c30f8a8196->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 191)
15	App\EntityEngine\Url\EntityUrlModule->renderPage (line 118)
16	App\EntityEngine\Url\EntityUrlModule->resolve (line 53)
17	App\Controller\Public\UrlEntryDispatchController->dispatch (line 181)
18	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
19	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
20	Symfony\Component\HttpKernel\Kernel->handle (line 35)
21	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
22	require_once (line 71)

0.55 ms
(0.76%)

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 490)
6	App\EntityEngine\Views\ViewRenderService->App\EntityEngine\Views\{closure} (line 34)
7	App\Service\Theme\RenderStack->within (line 480)
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 56)
19	__TwigTemplate_01c157d2d302c0ace2ca49c30f8a8196->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 191)
25	App\EntityEngine\Url\EntityUrlModule->renderPage (line 118)
26	App\EntityEngine\Url\EntityUrlModule->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.55 ms
(0.76%)

SELECT * FROM entity_content WHERE id = ?

Parameters:

[
  21
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  *
FROM
  entity_content
WHERE
  id = ?

SELECT * FROM entity_content WHERE id = 21;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 593)
2	Doctrine\DBAL\Connection->fetchAssociative (line 1812)
3	App\EntityEngine\Storage\EntityStorage->fetchMainRow (line 1754)
4	App\EntityEngine\Storage\EntityStorage->resolvePublishedRevision (line 1792)
5	App\EntityEngine\Storage\EntityStorage->loadPublished (line 83)
6	App\EntityEngine\Url\EntityUrlModule->resolve (line 53)
7	App\Controller\Public\UrlEntryDispatchController->dispatch (line 181)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
10	Symfony\Component\HttpKernel\Kernel->handle (line 35)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
12	require_once (line 71)

0.53 ms
(0.74%)

SELECT * FROM entity_content_data_reference WHERE (entity_id IN (?)) AND (field_id IN (?, ?)) AND (rev_id IN (?)) ORDER BY delta ASC, id ASC

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  *
FROM
  entity_content_data_reference
WHERE
  (
    entity_id IN (?)
  )
  AND (
    field_id IN (?, ?)
  )
  AND (
    rev_id IN (?)
  )
ORDER BY
  delta ASC,
  id ASC

SELECT * FROM entity_content_data_reference WHERE (entity_id IN (21)) AND (field_id IN (33, 32)) AND (rev_id IN (40)) ORDER BY delta ASC, id ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 344)
2	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line 70)
3	App\EntityEngine\Storage\FieldDataStorage->fetchRows (line 2232)
4	App\EntityEngine\Storage\EntityStorage->loadFieldValues (line 2168)
5	App\EntityEngine\Storage\EntityStorage->hydrateEntities (line 234)
6	App\EntityEngine\Storage\EntityStorage->buildEntities (line 151)
7	App\EntityEngine\Storage\EntityStorage->loadMultipleBatch (line 127)
8	App\EntityEngine\Storage\EntityStorage->loadMultiple (line 272)
9	App\EntityEngine\Storage\EntityStorage->load (line 1797)
10	App\EntityEngine\Storage\EntityStorage->loadPublished (line 83)
11	App\EntityEngine\Url\EntityUrlModule->resolve (line 53)
12	App\Controller\Public\UrlEntryDispatchController->dispatch (line 181)
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)

0.53 ms
(0.74%)

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 645)
4	App\EntityEngine\Views\ViewExecutor->resolveIdsAndPagination (line 154)
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 56)
16	__TwigTemplate_01c157d2d302c0ace2ca49c30f8a8196->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 191)
22	App\EntityEngine\Url\EntityUrlModule->renderPage (line 118)
23	App\EntityEngine\Url\EntityUrlModule->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.53 ms
(0.74%)

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 56)
9	__TwigTemplate_01c157d2d302c0ace2ca49c30f8a8196->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 191)
15	App\EntityEngine\Url\EntityUrlModule->renderPage (line 118)
16	App\EntityEngine\Url\EntityUrlModule->resolve (line 53)
17	App\Controller\Public\UrlEntryDispatchController->dispatch (line 181)
18	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
19	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
20	Symfony\Component\HttpKernel\Kernel->handle (line 35)
21	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
22	require_once (line 71)

0.53 ms
(0.73%)

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	ContainerA8mDo3G\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 191)
18	App\EntityEngine\Url\EntityUrlModule->renderPage (line 118)
19	App\EntityEngine\Url\EntityUrlModule->resolve (line 53)
20	App\Controller\Public\UrlEntryDispatchController->dispatch (line 181)
21	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
22	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
23	Symfony\Component\HttpKernel\Kernel->handle (line 35)
24	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
25	require_once (line 71)

0.53 ms
(0.73%)

SELECT * FROM entity_content_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_content_display
WHERE
  type_id = ?
  AND view_mode_id = ?
ORDER BY
  weight ASC

SELECT * FROM entity_content_display WHERE type_id = 3 AND view_mode_id = 4 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 157)
8	App\EntityEngine\Url\EntityCurrentContentProvider->render (line 79)
9	App\Service\Theme\BlockType\CurrentContent\CurrentContentBlockType->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 203)
17	__TwigTemplate_9841bf9a74afab2a3cb3ad11d1624e81->doDisplay (line 402)
18	Twig\Template->yield (line 56)
19	__TwigTemplate_01c157d2d302c0ace2ca49c30f8a8196->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 191)
25	App\EntityEngine\Url\EntityUrlModule->renderPage (line 118)
26	App\EntityEngine\Url\EntityUrlModule->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.52 ms
(0.72%)

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

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 870)
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 3093)
7	App\EntityEngine\Views\ViewDefinitionCompiler->assertItemLink (line 2581)
8	App\EntityEngine\Views\ViewDefinitionCompiler->assertPresentation (line 161)
9	App\EntityEngine\Views\ViewDefinitionCompiler->compile (line 642)
10	App\EntityEngine\Views\ViewExecutor->resolveIdsAndPagination (line 154)
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 56)
22	__TwigTemplate_01c157d2d302c0ace2ca49c30f8a8196->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 191)
28	App\EntityEngine\Url\EntityUrlModule->renderPage (line 118)
29	App\EntityEngine\Url\EntityUrlModule->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.49 ms
(0.68%)

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 56)
12	__TwigTemplate_01c157d2d302c0ace2ca49c30f8a8196->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 191)
18	App\EntityEngine\Url\EntityUrlModule->renderPage (line 118)
19	App\EntityEngine\Url\EntityUrlModule->resolve (line 53)
20	App\Controller\Public\UrlEntryDispatchController->dispatch (line 181)
21	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
22	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
23	Symfony\Component\HttpKernel\Kernel->handle (line 35)
24	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
25	require_once (line 71)

0.48 ms
(0.66%)

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 842)
3	App\EntityEngine\Definition\SchemaReader->loadTypes (line 66)
4	App\EntityEngine\Definition\SchemaReader->getType (line 2150)
5	App\EntityEngine\Storage\EntityStorage->hydrateEntities (line 234)
6	App\EntityEngine\Storage\EntityStorage->buildEntities (line 151)
7	App\EntityEngine\Storage\EntityStorage->loadMultipleBatch (line 127)
8	App\EntityEngine\Storage\EntityStorage->loadMultiple (line 272)
9	App\EntityEngine\Storage\EntityStorage->load (line 1797)
10	App\EntityEngine\Storage\EntityStorage->loadPublished (line 83)
11	App\EntityEngine\Url\EntityUrlModule->resolve (line 53)
12	App\Controller\Public\UrlEntryDispatchController->dispatch (line 181)
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)

0.48 ms
(0.66%)

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 842)
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 999)
7	App\EntityEngine\Views\ViewDefinitionCompiler->collectExposedFromDefinition (line 685)
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 56)
19	__TwigTemplate_01c157d2d302c0ace2ca49c30f8a8196->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 191)
25	App\EntityEngine\Url\EntityUrlModule->renderPage (line 118)
26	App\EntityEngine\Url\EntityUrlModule->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.48 ms
(0.66%)

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

Parameters:

[
  3
  "default"
]

View formatted query View runnable query Explain query View query backtrace

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

SELECT id FROM entity_content_view_mode WHERE type_id = 3 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 157)
7	App\EntityEngine\Url\EntityCurrentContentProvider->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 56)
18	__TwigTemplate_01c157d2d302c0ace2ca49c30f8a8196->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 191)
24	App\EntityEngine\Url\EntityUrlModule->renderPage (line 118)
25	App\EntityEngine\Url\EntityUrlModule->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.48 ms
(0.66%)

SELECT * FROM entity_content_data_group WHERE (entity_id IN (?)) AND (field_id IN (?)) AND (rev_id IN (?)) ORDER BY delta ASC, id ASC

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  *
FROM
  entity_content_data_group
WHERE
  (
    entity_id IN (?)
  )
  AND (
    field_id IN (?)
  )
  AND (
    rev_id IN (?)
  )
ORDER BY
  delta ASC,
  id ASC

SELECT * FROM entity_content_data_group WHERE (entity_id IN (21)) AND (field_id IN (34)) AND (rev_id IN (40)) ORDER BY delta ASC, id ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 344)
2	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line 70)
3	App\EntityEngine\Storage\FieldDataStorage->fetchRows (line 2232)
4	App\EntityEngine\Storage\EntityStorage->loadFieldValues (line 2168)
5	App\EntityEngine\Storage\EntityStorage->hydrateEntities (line 234)
6	App\EntityEngine\Storage\EntityStorage->buildEntities (line 151)
7	App\EntityEngine\Storage\EntityStorage->loadMultipleBatch (line 127)
8	App\EntityEngine\Storage\EntityStorage->loadMultiple (line 272)
9	App\EntityEngine\Storage\EntityStorage->load (line 1797)
10	App\EntityEngine\Storage\EntityStorage->loadPublished (line 83)
11	App\EntityEngine\Url\EntityUrlModule->resolve (line 53)
12	App\Controller\Public\UrlEntryDispatchController->dispatch (line 181)
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)

0.47 ms
(0.66%)

SELECT * FROM entity_content_data_file WHERE (entity_id IN (?)) AND (field_id IN (?, ?, ?)) AND (rev_id IN (?)) ORDER BY delta ASC, id ASC

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  *
FROM
  entity_content_data_file
WHERE
  (
    entity_id IN (?)
  )
  AND (
    field_id IN (?, ?, ?)
  )
  AND (
    rev_id IN (?)
  )
ORDER BY
  delta ASC,
  id ASC

SELECT * FROM entity_content_data_file WHERE (entity_id IN (21)) AND (field_id IN (27, 28, 30)) AND (rev_id IN (40)) ORDER BY delta ASC, id ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 344)
2	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line 70)
3	App\EntityEngine\Storage\FieldDataStorage->fetchRows (line 2232)
4	App\EntityEngine\Storage\EntityStorage->loadFieldValues (line 2168)
5	App\EntityEngine\Storage\EntityStorage->hydrateEntities (line 234)
6	App\EntityEngine\Storage\EntityStorage->buildEntities (line 151)
7	App\EntityEngine\Storage\EntityStorage->loadMultipleBatch (line 127)
8	App\EntityEngine\Storage\EntityStorage->loadMultiple (line 272)
9	App\EntityEngine\Storage\EntityStorage->load (line 1797)
10	App\EntityEngine\Storage\EntityStorage->loadPublished (line 83)
11	App\EntityEngine\Url\EntityUrlModule->resolve (line 53)
12	App\Controller\Public\UrlEntryDispatchController->dispatch (line 181)
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)

0.46 ms
(0.64%)

SELECT * FROM entity_content_data_link WHERE (entity_id IN (?)) AND (field_id IN (?)) AND (rev_id IN (?)) ORDER BY delta ASC, id ASC

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  *
FROM
  entity_content_data_link
WHERE
  (
    entity_id IN (?)
  )
  AND (
    field_id IN (?)
  )
  AND (
    rev_id IN (?)
  )
ORDER BY
  delta ASC,
  id ASC

SELECT * FROM entity_content_data_link WHERE (entity_id IN (21)) AND (field_id IN (26)) AND (rev_id IN (40)) ORDER BY delta ASC, id ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 344)
2	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line 70)
3	App\EntityEngine\Storage\FieldDataStorage->fetchRows (line 2232)
4	App\EntityEngine\Storage\EntityStorage->loadFieldValues (line 2168)
5	App\EntityEngine\Storage\EntityStorage->hydrateEntities (line 234)
6	App\EntityEngine\Storage\EntityStorage->buildEntities (line 151)
7	App\EntityEngine\Storage\EntityStorage->loadMultipleBatch (line 127)
8	App\EntityEngine\Storage\EntityStorage->loadMultiple (line 272)
9	App\EntityEngine\Storage\EntityStorage->load (line 1797)
10	App\EntityEngine\Storage\EntityStorage->loadPublished (line 83)
11	App\EntityEngine\Url\EntityUrlModule->resolve (line 53)
12	App\Controller\Public\UrlEntryDispatchController->dispatch (line 181)
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)

0.45 ms
(0.62%)

SELECT * FROM entity_content_data_geolocation WHERE (entity_id IN (?)) AND (field_id IN (?)) AND (rev_id IN (?)) ORDER BY delta ASC, id ASC

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  *
FROM
  entity_content_data_geolocation
WHERE
  (
    entity_id IN (?)
  )
  AND (
    field_id IN (?)
  )
  AND (
    rev_id IN (?)
  )
ORDER BY
  delta ASC,
  id ASC

SELECT * FROM entity_content_data_geolocation WHERE (entity_id IN (21)) AND (field_id IN (31)) AND (rev_id IN (40)) ORDER BY delta ASC, id ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 344)
2	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line 70)
3	App\EntityEngine\Storage\FieldDataStorage->fetchRows (line 2232)
4	App\EntityEngine\Storage\EntityStorage->loadFieldValues (line 2168)
5	App\EntityEngine\Storage\EntityStorage->hydrateEntities (line 234)
6	App\EntityEngine\Storage\EntityStorage->buildEntities (line 151)
7	App\EntityEngine\Storage\EntityStorage->loadMultipleBatch (line 127)
8	App\EntityEngine\Storage\EntityStorage->loadMultiple (line 272)
9	App\EntityEngine\Storage\EntityStorage->load (line 1797)
10	App\EntityEngine\Storage\EntityStorage->loadPublished (line 83)
11	App\EntityEngine\Url\EntityUrlModule->resolve (line 53)
12	App\Controller\Public\UrlEntryDispatchController->dispatch (line 181)
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)

0.45 ms
(0.62%)

SELECT * FROM entity_content_data_checkbox WHERE (entity_id IN (?)) AND (field_id IN (?)) AND (rev_id IN (?)) ORDER BY delta ASC, id ASC

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  *
FROM
  entity_content_data_checkbox
WHERE
  (
    entity_id IN (?)
  )
  AND (
    field_id IN (?)
  )
  AND (
    rev_id IN (?)
  )
ORDER BY
  delta ASC,
  id ASC

SELECT * FROM entity_content_data_checkbox WHERE (entity_id IN (21)) AND (field_id IN (29)) AND (rev_id IN (40)) ORDER BY delta ASC, id ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 344)
2	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line 70)
3	App\EntityEngine\Storage\FieldDataStorage->fetchRows (line 2232)
4	App\EntityEngine\Storage\EntityStorage->loadFieldValues (line 2168)
5	App\EntityEngine\Storage\EntityStorage->hydrateEntities (line 234)
6	App\EntityEngine\Storage\EntityStorage->buildEntities (line 151)
7	App\EntityEngine\Storage\EntityStorage->loadMultipleBatch (line 127)
8	App\EntityEngine\Storage\EntityStorage->loadMultiple (line 272)
9	App\EntityEngine\Storage\EntityStorage->load (line 1797)
10	App\EntityEngine\Storage\EntityStorage->loadPublished (line 83)
11	App\EntityEngine\Url\EntityUrlModule->resolve (line 53)
12	App\Controller\Public\UrlEntryDispatchController->dispatch (line 181)
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)

0.42 ms
(0.58%)

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 490)
6	App\EntityEngine\Views\ViewRenderService->App\EntityEngine\Views\{closure} (line 34)
7	App\Service\Theme\RenderStack->within (line 480)
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 56)
19	__TwigTemplate_01c157d2d302c0ace2ca49c30f8a8196->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 191)
25	App\EntityEngine\Url\EntityUrlModule->renderPage (line 118)
26	App\EntityEngine\Url\EntityUrlModule->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.40 ms
(0.56%)

SELECT * FROM ee_wysiwyg_preset ORDER BY weight ASC, name ASC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  *
FROM
  ee_wysiwyg_preset
ORDER BY
  weight ASC,
  name ASC

SELECT * FROM ee_wysiwyg_preset ORDER BY weight ASC, name ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 907)
2	Doctrine\DBAL\Connection->fetchAllAssociative (line 42)
3	App\EntityEngine\Wysiwyg\WysiwygPresetStorage->list (line 51)
4	App\EntityEngine\Wysiwyg\WysiwygPresetStorage->listActive (line 62)
5	App\EntityEngine\Wysiwyg\WysiwygPresetStorage->activeOptions (line 140)
6	App\EntityEngine\Wysiwyg\WysiwygSanitizer->activeOptions (line 60)
7	App\EntityEngine\FieldType\RichText\RichTextFieldType->getSettingsForm (line 885)
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 157)
17	App\EntityEngine\Url\EntityCurrentContentProvider->render (line 79)
18	App\Service\Theme\BlockType\CurrentContent\CurrentContentBlockType->render (line 52)
19	App\Service\Theme\BlockTypeRegistry->render (line 154)
20	App\Service\Theme\ThemeService->App\Service\Theme\{closure} (line 34)
21	App\Service\Theme\RenderStack->within (line 152)
22	App\Service\Theme\ThemeService->App\Service\Theme\{closure} (line 34)
23	App\Service\Theme\RenderStack->within (line 152)
24	App\Service\Theme\ThemeService->renderRegion (line 86)
25	App\Twig\ThemeExtension->themeRegion (line 203)
26	__TwigTemplate_9841bf9a74afab2a3cb3ad11d1624e81->doDisplay (line 402)
27	Twig\Template->yield (line 56)
28	__TwigTemplate_01c157d2d302c0ace2ca49c30f8a8196->doDisplay (line 402)
29	Twig\Template->yield (line 358)
30	Twig\Template->display (line 373)
31	Twig\Template->render (line 51)
32	Twig\TemplateWrapper->render (line 333)
33	Twig\Environment->render (line 191)
34	App\EntityEngine\Url\EntityUrlModule->renderPage (line 118)
35	App\EntityEngine\Url\EntityUrlModule->resolve (line 53)
36	App\Controller\Public\UrlEntryDispatchController->dispatch (line 181)
37	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
38	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
39	Symfony\Component\HttpKernel\Kernel->handle (line 35)
40	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
41	require_once (line 71)

0.40 ms
(0.56%)

SELECT * FROM entity_content_translation WHERE entity_id = ?

Parameters:

[
  21
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  *
FROM
  entity_content_translation
WHERE
  entity_id = ?

SELECT * FROM entity_content_translation WHERE entity_id = 21;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 907)
2	Doctrine\DBAL\Connection->fetchAllAssociative (line 34)
3	App\EntityEngine\Storage\TranslationStorage->listForEntity (line 1760)
4	App\EntityEngine\Storage\EntityStorage->resolvePublishedRevision (line 1792)
5	App\EntityEngine\Storage\EntityStorage->loadPublished (line 83)
6	App\EntityEngine\Url\EntityUrlModule->resolve (line 53)
7	App\Controller\Public\UrlEntryDispatchController->dispatch (line 181)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
10	Symfony\Component\HttpKernel\Kernel->handle (line 35)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
12	require_once (line 71)

0.40 ms
(0.56%)

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 842)
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 490)
24	App\EntityEngine\Views\ViewRenderService->App\EntityEngine\Views\{closure} (line 34)
25	App\Service\Theme\RenderStack->within (line 480)
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 56)
37	__TwigTemplate_01c157d2d302c0ace2ca49c30f8a8196->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 191)
43	App\EntityEngine\Url\EntityUrlModule->renderPage (line 118)
44	App\EntityEngine\Url\EntityUrlModule->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.38 ms
(0.53%)

SELECT id, name FROM entity_content_view_mode WHERE type_id IS NULL

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  id,
  name
FROM
  entity_content_view_mode
WHERE
  type_id IS NULL

SELECT id, name FROM entity_content_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 157)
11	App\EntityEngine\Url\EntityCurrentContentProvider->render (line 79)
12	App\Service\Theme\BlockType\CurrentContent\CurrentContentBlockType->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 203)
20	__TwigTemplate_9841bf9a74afab2a3cb3ad11d1624e81->doDisplay (line 402)
21	Twig\Template->yield (line 56)
22	__TwigTemplate_01c157d2d302c0ace2ca49c30f8a8196->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 191)
28	App\EntityEngine\Url\EntityUrlModule->renderPage (line 118)
29	App\EntityEngine\Url\EntityUrlModule->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.34 ms
(0.47%)

SELECT id, name FROM entity_content_view_mode WHERE type_id = ?

Parameters:

[
  3
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  id,
  name
FROM
  entity_content_view_mode
WHERE
  type_id = ?

SELECT id, name FROM entity_content_view_mode WHERE type_id = 3;

#	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 157)
10	App\EntityEngine\Url\EntityCurrentContentProvider->render (line 79)
11	App\Service\Theme\BlockType\CurrentContent\CurrentContentBlockType->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 203)
19	__TwigTemplate_9841bf9a74afab2a3cb3ad11d1624e81->doDisplay (line 402)
20	Twig\Template->yield (line 56)
21	__TwigTemplate_01c157d2d302c0ace2ca49c30f8a8196->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 191)
27	App\EntityEngine\Url\EntityUrlModule->renderPage (line 118)
28	App\EntityEngine\Url\EntityUrlModule->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.33 ms
(0.46%)

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 870)
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 490)
25	App\EntityEngine\Views\ViewRenderService->App\EntityEngine\Views\{closure} (line 34)
26	App\Service\Theme\RenderStack->within (line 480)
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 56)
38	__TwigTemplate_01c157d2d302c0ace2ca49c30f8a8196->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 191)
44	App\EntityEngine\Url\EntityUrlModule->renderPage (line 118)
45	App\EntityEngine\Url\EntityUrlModule->resolve (line 53)
46	App\Controller\Public\UrlEntryDispatchController->dispatch (line 181)
47	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
48	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
49	Symfony\Component\HttpKernel\Kernel->handle (line 35)
50	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
51	require_once (line 71)

0.33 ms
(0.45%)

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

Parameters:

[
  "full"
]

View formatted query View runnable query Explain query View query backtrace

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

SELECT * FROM entity_content_view_mode WHERE name = 'full' 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 157)
6	App\EntityEngine\Url\EntityCurrentContentProvider->render (line 79)
7	App\Service\Theme\BlockType\CurrentContent\CurrentContentBlockType->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 203)
15	__TwigTemplate_9841bf9a74afab2a3cb3ad11d1624e81->doDisplay (line 402)
16	Twig\Template->yield (line 56)
17	__TwigTemplate_01c157d2d302c0ace2ca49c30f8a8196->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 191)
23	App\EntityEngine\Url\EntityUrlModule->renderPage (line 118)
24	App\EntityEngine\Url\EntityUrlModule->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.32 ms
(0.45%)

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 490)
11	App\EntityEngine\Views\ViewRenderService->App\EntityEngine\Views\{closure} (line 34)
12	App\Service\Theme\RenderStack->within (line 480)
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 56)
24	__TwigTemplate_01c157d2d302c0ace2ca49c30f8a8196->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 191)
30	App\EntityEngine\Url\EntityUrlModule->renderPage (line 118)
31	App\EntityEngine\Url\EntityUrlModule->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)

0.30 ms
(0.42%)

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 319)
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 490)
27	App\EntityEngine\Views\ViewRenderService->App\EntityEngine\Views\{closure} (line 34)
28	App\Service\Theme\RenderStack->within (line 480)
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 56)
40	__TwigTemplate_01c157d2d302c0ace2ca49c30f8a8196->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 191)
46	App\EntityEngine\Url\EntityUrlModule->renderPage (line 118)
47	App\EntityEngine\Url\EntityUrlModule->resolve (line 53)
48	App\Controller\Public\UrlEntryDispatchController->dispatch (line 181)
49	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
50	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
51	Symfony\Component\HttpKernel\Kernel->handle (line 35)
52	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
53	require_once (line 71)

0.27 ms
(0.38%)

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

Parameters:

[
  "full"
  3
]

View formatted query View runnable query Explain query View query backtrace

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

SELECT * FROM entity_content_view_mode WHERE name = 'full' AND type_id = 3;

#	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 157)
6	App\EntityEngine\Url\EntityCurrentContentProvider->render (line 79)
7	App\Service\Theme\BlockType\CurrentContent\CurrentContentBlockType->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 203)
15	__TwigTemplate_9841bf9a74afab2a3cb3ad11d1624e81->doDisplay (line 402)
16	Twig\Template->yield (line 56)
17	__TwigTemplate_01c157d2d302c0ace2ca49c30f8a8196->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 191)
23	App\EntityEngine\Url\EntityUrlModule->renderPage (line 118)
24	App\EntityEngine\Url\EntityUrlModule->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)

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	4
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/wydarzenia/bieg-po-zdrowie

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping