Symfony Profiler

Query Metrics

23 Database Queries

7 Different statements

11.90 ms Query time

0 Invalid entities

30 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

4.17 ms
(35.08%)

SELECT t0.id AS id_1, t0.type AS type_2, t0.sort_order AS sort_order_3, t0.depth AS depth_4, t0.`left` AS left_5, t0.`right` AS right_6, t0.is_deleted AS is_deleted_7, t0.restrict_sites AS restrict_sites_8, t0.time_created AS time_created_9, t0.time_published AS time_published_10, t0.time_deleted AS time_deleted_11, t0.published_revision_id AS published_revision_id_12, t0.draft_revision_id AS draft_revision_id_13, t0.parent_id AS parent_id_14 FROM cms_content_entry t0 WHERE t0.id = ?

Parameters:

[
  6
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.type AS type_2,
  t0.sort_order AS sort_order_3,
  t0.depth AS depth_4,
  t0.`left` AS left_5,
  t0.`right` AS right_6,
  t0.is_deleted AS is_deleted_7,
  t0.restrict_sites AS restrict_sites_8,
  t0.time_created AS time_created_9,
  t0.time_published AS time_published_10,
  t0.time_deleted AS time_deleted_11,
  t0.published_revision_id AS published_revision_id_12,
  t0.draft_revision_id AS draft_revision_id_13,
  t0.parent_id AS parent_id_14
FROM
  cms_content_entry t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.type AS type_2, t0.sort_order AS sort_order_3, t0.depth AS depth_4, t0.`left` AS left_5, t0.`right` AS right_6, t0.is_deleted AS is_deleted_7, t0.restrict_sites AS restrict_sites_8, t0.time_created AS time_created_9, t0.time_published AS time_published_10, t0.time_deleted AS time_deleted_11, t0.published_revision_id AS published_revision_id_12, t0.draft_revision_id AS draft_revision_id_13, t0.parent_id AS parent_id_14 FROM cms_content_entry t0 WHERE t0.id = 6;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 736)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 754)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 362)
4	Doctrine\ORM\EntityManager->find (line 86)
5	Doctrine\ORM\EntityRepository->find (line 61)
6	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->find (line 68)
7	Cms\CmsBundle\Content\Resolver\ContentResolver->resolve (line 42)
8	Cms\CmsBundle\Content\Resolver\Resolver->resolve (line 52)
9	Cms\CmsBundle\Content\Resolver\ReferenceArrayResolver->{closure:Cms\CmsBundle\Content\Resolver\ReferenceArrayResolver::resolve():47} (line 86)
10	Cms\CmsBundle\Content\Resolver\ReferenceResolverContext->resolveRootPath (line 36)
11	Cms\CmsBundle\Content\Resolver\ReferenceResolverContext->resolve (line 71)
12	Cms\CmsBundle\Content\Resolver\ReferenceArrayResolver->resolve (line 71)
13	Cms\CmsBundle\Content\Resolver\CustomComponentResolver->resolve (line 42)
14	Cms\CmsBundle\Content\Resolver\Resolver->resolve (line 52)
15	Cms\CmsBundle\Content\Resolver\ReferenceArrayResolver->{closure:Cms\CmsBundle\Content\Resolver\ReferenceArrayResolver::resolve():47} (line 86)
16	Cms\CmsBundle\Content\Resolver\ReferenceResolverContext->resolveRootPath (line 36)
17	Cms\CmsBundle\Content\Resolver\ReferenceResolverContext->resolve (line 71)
18	Cms\CmsBundle\Content\Resolver\ReferenceArrayResolver->resolve (line 29)
19	Cms\CmsBundle\Content\Resolver\ArrayResolver->resolve (line 42)
20	Cms\CmsBundle\Content\Resolver\Resolver->resolve (line 52)
21	Cms\CmsBundle\Content\Resolver\ReferenceArrayResolver->{closure:Cms\CmsBundle\Content\Resolver\ReferenceArrayResolver::resolve():47} (line 86)
22	Cms\CmsBundle\Content\Resolver\ReferenceResolverContext->resolveRootPath (line 36)
23	Cms\CmsBundle\Content\Resolver\ReferenceResolverContext->resolve (line 71)
24	Cms\CmsBundle\Content\Resolver\ReferenceArrayResolver->resolve (line 71)
25	Cms\CmsBundle\Content\Resolver\CustomComponentResolver->resolve (line 42)
26	Cms\CmsBundle\Content\Resolver\Resolver->resolve (line 40)
27	Cms\CmsBundle\Content\Resolver\FieldResolver->resolve (line 42)
28	Cms\CmsBundle\Content\Resolver\Resolver->resolve (line 312)
29	Cms\CmsBundle\Controller\ContentController->contentEntryRevision (line 221)
30	Cms\CmsBundle\Content\Link\CmsLinkManager->handleLink (line 69)
31	Cms\CmsBundle\Content\Link\LinkManager->handleLink (line 176)
32	Cms\CmsBundle\Controller\ContentController->resolve (line 183)
33	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
34	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
35	Symfony\Component\HttpKernel\Kernel->handle (line 35)
36	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
37	require_once (line 5)

2.70 ms
(22.66%)

SELECT t0.id AS id_1, t0.is_published_revision AS is_published_revision_2, t0.time_created AS time_created_3, t0.autosave AS autosave_4, t0.content_entry_id AS content_entry_id_5, t0.author_id AS author_id_6 FROM cms_content_entry_revision t0 WHERE t0.id = ?

Parameters:

[
  89
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.is_published_revision AS is_published_revision_2,
  t0.time_created AS time_created_3,
  t0.autosave AS autosave_4,
  t0.content_entry_id AS content_entry_id_5,
  t0.author_id AS author_id_6
FROM
  cms_content_entry_revision t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.is_published_revision AS is_published_revision_2, t0.time_created AS time_created_3, t0.autosave AS autosave_4, t0.content_entry_id AS content_entry_id_5, t0.author_id AS author_id_6 FROM cms_content_entry_revision t0 WHERE t0.id = 89;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 736)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 754)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 220)
4	Doctrine\ORM\Proxy\ProxyFactory::{closure:Doctrine\ORM\Proxy\ProxyFactory::createLazyInitializer():219} (line 286)
5	Proxies\__CG__\Cms\CmsBundle\Entity\ContentEntryRevision::{closure:{closure:Doctrine\ORM\Proxy\ProxyFactory::getProxyFactory():284}:285} (line 59)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 146)
7	Proxies\__CG__\Cms\CmsBundle\Entity\ContentEntryRevision->__get (line 76)
8	Cms\CmsBundle\Content\Resolver\ContentResolver->resolve (line 42)
9	Cms\CmsBundle\Content\Resolver\Resolver->resolve (line 52)
10	Cms\CmsBundle\Content\Resolver\ReferenceArrayResolver->{closure:Cms\CmsBundle\Content\Resolver\ReferenceArrayResolver::resolve():47} (line 86)
11	Cms\CmsBundle\Content\Resolver\ReferenceResolverContext->resolveRootPath (line 36)
12	Cms\CmsBundle\Content\Resolver\ReferenceResolverContext->resolve (line 71)
13	Cms\CmsBundle\Content\Resolver\ReferenceArrayResolver->resolve (line 71)
14	Cms\CmsBundle\Content\Resolver\CustomComponentResolver->resolve (line 42)
15	Cms\CmsBundle\Content\Resolver\Resolver->resolve (line 52)
16	Cms\CmsBundle\Content\Resolver\ReferenceArrayResolver->{closure:Cms\CmsBundle\Content\Resolver\ReferenceArrayResolver::resolve():47} (line 86)
17	Cms\CmsBundle\Content\Resolver\ReferenceResolverContext->resolveRootPath (line 36)
18	Cms\CmsBundle\Content\Resolver\ReferenceResolverContext->resolve (line 71)
19	Cms\CmsBundle\Content\Resolver\ReferenceArrayResolver->resolve (line 29)
20	Cms\CmsBundle\Content\Resolver\ArrayResolver->resolve (line 42)
21	Cms\CmsBundle\Content\Resolver\Resolver->resolve (line 52)
22	Cms\CmsBundle\Content\Resolver\ReferenceArrayResolver->{closure:Cms\CmsBundle\Content\Resolver\ReferenceArrayResolver::resolve():47} (line 86)
23	Cms\CmsBundle\Content\Resolver\ReferenceResolverContext->resolveRootPath (line 36)
24	Cms\CmsBundle\Content\Resolver\ReferenceResolverContext->resolve (line 71)
25	Cms\CmsBundle\Content\Resolver\ReferenceArrayResolver->resolve (line 71)
26	Cms\CmsBundle\Content\Resolver\CustomComponentResolver->resolve (line 42)
27	Cms\CmsBundle\Content\Resolver\Resolver->resolve (line 40)
28	Cms\CmsBundle\Content\Resolver\FieldResolver->resolve (line 42)
29	Cms\CmsBundle\Content\Resolver\Resolver->resolve (line 312)
30	Cms\CmsBundle\Controller\ContentController->contentEntryRevision (line 221)
31	Cms\CmsBundle\Content\Link\CmsLinkManager->handleLink (line 69)
32	Cms\CmsBundle\Content\Link\LinkManager->handleLink (line 176)
33	Cms\CmsBundle\Controller\ContentController->resolve (line 183)
34	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
35	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
36	Symfony\Component\HttpKernel\Kernel->handle (line 35)
37	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
38	require_once (line 5)

1.85 ms
(15.56%)

SELECT t0.id AS id_1, t0.storage AS storage_2, t0.storage_identifier AS storage_identifier_3, t0.public_name AS public_name_4, t0.size AS size_5, t0.mime_type AS mime_type_6, t0.type AS type_7, t0.time_uploaded AS time_uploaded_8, t0.public_storage AS public_storage_9, t0.public_storage_identifier AS public_storage_identifier_10, t0.width AS width_11, t0.height AS height_12, t0.derivatives AS derivatives_13, t0.enqueued_derivatives AS enqueued_derivatives_14, t0.folder_id AS folder_id_15 FROM cms_upload t0 WHERE t0.id = ?

Parameters:

[
  5
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.storage AS storage_2,
  t0.storage_identifier AS storage_identifier_3,
  t0.public_name AS public_name_4,
  t0.size AS size_5,
  t0.mime_type AS mime_type_6,
  t0.type AS type_7,
  t0.time_uploaded AS time_uploaded_8,
  t0.public_storage AS public_storage_9,
  t0.public_storage_identifier AS public_storage_identifier_10,
  t0.width AS width_11,
  t0.height AS height_12,
  t0.derivatives AS derivatives_13,
  t0.enqueued_derivatives AS enqueued_derivatives_14,
  t0.folder_id AS folder_id_15
FROM
  cms_upload t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.storage AS storage_2, t0.storage_identifier AS storage_identifier_3, t0.public_name AS public_name_4, t0.size AS size_5, t0.mime_type AS mime_type_6, t0.type AS type_7, t0.time_uploaded AS time_uploaded_8, t0.public_storage AS public_storage_9, t0.public_storage_identifier AS public_storage_identifier_10, t0.width AS width_11, t0.height AS height_12, t0.derivatives AS derivatives_13, t0.enqueued_derivatives AS enqueued_derivatives_14, t0.folder_id AS folder_id_15 FROM cms_upload t0 WHERE t0.id = 5;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 736)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 754)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 362)
4	Doctrine\ORM\EntityManager->find (line 86)
5	Doctrine\ORM\EntityRepository->find (line 61)
6	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->find (line 46)
7	Cms\CmsBundle\Content\Resolver\UploadImageSourceResolver->resolve (line 42)
8	Cms\CmsBundle\Content\Resolver\Resolver->resolve (line 52)
9	Cms\CmsBundle\Content\Resolver\ReferenceArrayResolver->{closure:Cms\CmsBundle\Content\Resolver\ReferenceArrayResolver::resolve():47} (line 86)
10	Cms\CmsBundle\Content\Resolver\ReferenceResolverContext->resolveRootPath (line 36)
11	Cms\CmsBundle\Content\Resolver\ReferenceResolverContext->resolve (line 71)
12	Cms\CmsBundle\Content\Resolver\ReferenceArrayResolver->resolve (line 71)
13	Cms\CmsBundle\Content\Resolver\CustomComponentResolver->resolve (line 42)
14	Cms\CmsBundle\Content\Resolver\Resolver->resolve (line 52)
15	Cms\CmsBundle\Content\Resolver\ReferenceArrayResolver->{closure:Cms\CmsBundle\Content\Resolver\ReferenceArrayResolver::resolve():47} (line 86)
16	Cms\CmsBundle\Content\Resolver\ReferenceResolverContext->resolveRootPath (line 36)
17	Cms\CmsBundle\Content\Resolver\ReferenceResolverContext->resolve (line 71)
18	Cms\CmsBundle\Content\Resolver\ReferenceArrayResolver->resolve (line 29)
19	Cms\CmsBundle\Content\Resolver\ArrayResolver->resolve (line 42)
20	Cms\CmsBundle\Content\Resolver\Resolver->resolve (line 52)
21	Cms\CmsBundle\Content\Resolver\ReferenceArrayResolver->{closure:Cms\CmsBundle\Content\Resolver\ReferenceArrayResolver::resolve():47} (line 86)
22	Cms\CmsBundle\Content\Resolver\ReferenceResolverContext->resolveRootPath (line 36)
23	Cms\CmsBundle\Content\Resolver\ReferenceResolverContext->resolve (line 71)
24	Cms\CmsBundle\Content\Resolver\ReferenceArrayResolver->resolve (line 71)
25	Cms\CmsBundle\Content\Resolver\CustomComponentResolver->resolve (line 42)
26	Cms\CmsBundle\Content\Resolver\Resolver->resolve (line 40)
27	Cms\CmsBundle\Content\Resolver\FieldResolver->resolve (line 42)
28	Cms\CmsBundle\Content\Resolver\Resolver->resolve (line 312)
29	Cms\CmsBundle\Controller\ContentController->contentEntryRevision (line 221)
30	Cms\CmsBundle\Content\Link\CmsLinkManager->handleLink (line 69)
31	Cms\CmsBundle\Content\Link\LinkManager->handleLink (line 176)
32	Cms\CmsBundle\Controller\ContentController->resolve (line 183)
33	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
34	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
35	Symfony\Component\HttpKernel\Kernel->handle (line 35)
36	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
37	require_once (line 5)

1.13 ms
(9.52%)

SELECT c0_.id AS id_0, c1_.page_layout AS page_layout_1, c1_.meta_description AS meta_description_2, c1_.meta_author AS meta_author_3, c1_.primary_image AS primary_image_4 FROM cms_page c1_ LEFT JOIN cms_content_entry_revision c0_ ON c1_.content_entry_revision_id = c0_.id WHERE c0_.id IN (?)

Parameters:

[
  127
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  c0_.id AS id_0,
  c1_.page_layout AS page_layout_1,
  c1_.meta_description AS meta_description_2,
  c1_.meta_author AS meta_author_3,
  c1_.primary_image AS primary_image_4
FROM
  cms_page c1_
  LEFT JOIN cms_content_entry_revision c0_ ON c1_.content_entry_revision_id = c0_.id
WHERE
  c0_.id IN (?)

SELECT c0_.id AS id_0, c1_.page_layout AS page_layout_1, c1_.meta_description AS meta_description_2, c1_.meta_author AS meta_author_3, c1_.primary_image AS primary_image_4 FROM cms_page c1_ LEFT JOIN cms_content_entry_revision c0_ ON c1_.content_entry_revision_id = c0_.id WHERE c0_.id IN (127);

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 689)
6	Doctrine\ORM\AbstractQuery->getResult (line 128)
7	Cms\CmsBundle\Content\CmsContent->getFieldValues (line 261)
8	Cms\CmsBundle\Content\ContentManager->getFieldValues (line 487)
9	Cms\CmsBundle\Controller\ContentController->getResolverContext (line 306)
10	Cms\CmsBundle\Controller\ContentController->contentEntryRevision (line 221)
11	Cms\CmsBundle\Content\Link\CmsLinkManager->handleLink (line 69)
12	Cms\CmsBundle\Content\Link\LinkManager->handleLink (line 176)
13	Cms\CmsBundle\Controller\ContentController->resolve (line 183)
14	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
15	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
16	Symfony\Component\HttpKernel\Kernel->handle (line 35)
17	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
18	require_once (line 5)

0.91 ms
(7.61%)

SELECT c0_.id AS id_0, c0_.locale AS locale_1, c0_.name AS name_2, c0_.permalink AS permalink_3, c0_.search_text AS search_text_4, c1_.id AS id_5, c2_.id AS id_6, c0_.content_entry_revision_id AS content_entry_revision_id_7 FROM cms_content_entry_revision_translation c0_ LEFT JOIN cms_content_entry_revision c1_ ON c0_.content_entry_revision_id = c1_.id LEFT JOIN cms_content_entry c2_ ON c1_.content_entry_id = c2_.id WHERE c0_.content_entry_revision_id IN (?) AND c0_.locale = ?

Parameters:

[
  89
  "nl"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  c0_.id AS id_0,
  c0_.locale AS locale_1,
  c0_.name AS name_2,
  c0_.permalink AS permalink_3,
  c0_.search_text AS search_text_4,
  c1_.id AS id_5,
  c2_.id AS id_6,
  c0_.content_entry_revision_id AS content_entry_revision_id_7
FROM
  cms_content_entry_revision_translation c0_
  LEFT JOIN cms_content_entry_revision c1_ ON c0_.content_entry_revision_id = c1_.id
  LEFT JOIN cms_content_entry c2_ ON c1_.content_entry_id = c2_.id
WHERE
  c0_.content_entry_revision_id IN (?)
  AND c0_.locale = ?

SELECT c0_.id AS id_0, c0_.locale AS locale_1, c0_.name AS name_2, c0_.permalink AS permalink_3, c0_.search_text AS search_text_4, c1_.id AS id_5, c2_.id AS id_6, c0_.content_entry_revision_id AS content_entry_revision_id_7 FROM cms_content_entry_revision_translation c0_ LEFT JOIN cms_content_entry_revision c1_ ON c0_.content_entry_revision_id = c1_.id LEFT JOIN cms_content_entry c2_ ON c1_.content_entry_id = c2_.id WHERE c0_.content_entry_revision_id IN (89) AND c0_.locale = 'nl';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 689)
6	Doctrine\ORM\AbstractQuery->getResult (line 91)
7	Cms\CmsBundle\Content\ContentEntryTranslationCache->loadByRevisionIds (line 151)
8	Cms\CmsBundle\Content\ContentEntryTranslationCache->getByRevisionId (line 143)
9	Cms\CmsBundle\Content\ContentEntryTranslationCache->getByRevision (line 46)
10	Cms\CmsBundle\Content\Resolver\ContentFieldResolver->resolve (line 42)
11	Cms\CmsBundle\Content\Resolver\Resolver->resolve (line 52)
12	Cms\CmsBundle\Content\Resolver\ReferenceArrayResolver->{closure:Cms\CmsBundle\Content\Resolver\ReferenceArrayResolver::resolve():47} (line 86)
13	Cms\CmsBundle\Content\Resolver\ReferenceResolverContext->resolveRootPath (line 36)
14	Cms\CmsBundle\Content\Resolver\ReferenceResolverContext->resolve (line 71)
15	Cms\CmsBundle\Content\Resolver\ReferenceArrayResolver->resolve (line 27)
16	Cms\CmsBundle\Content\Resolver\GroupResolver->resolve (line 42)
17	Cms\CmsBundle\Content\Resolver\Resolver->resolve (line 52)
18	Cms\CmsBundle\Content\Resolver\ReferenceArrayResolver->{closure:Cms\CmsBundle\Content\Resolver\ReferenceArrayResolver::resolve():47} (line 86)
19	Cms\CmsBundle\Content\Resolver\ReferenceResolverContext->resolveRootPath (line 36)
20	Cms\CmsBundle\Content\Resolver\ReferenceResolverContext->resolve (line 71)
21	Cms\CmsBundle\Content\Resolver\ReferenceArrayResolver->resolve (line 97)
22	Cms\CmsBundle\Content\Resolver\CustomComponentResolver->resolve (line 42)
23	Cms\CmsBundle\Content\Resolver\Resolver->resolve (line 52)
24	Cms\CmsBundle\Content\Resolver\ReferenceArrayResolver->{closure:Cms\CmsBundle\Content\Resolver\ReferenceArrayResolver::resolve():47} (line 86)
25	Cms\CmsBundle\Content\Resolver\ReferenceResolverContext->resolveRootPath (line 36)
26	Cms\CmsBundle\Content\Resolver\ReferenceResolverContext->resolve (line 71)
27	Cms\CmsBundle\Content\Resolver\ReferenceArrayResolver->resolve (line 29)
28	Cms\CmsBundle\Content\Resolver\ArrayResolver->resolve (line 42)
29	Cms\CmsBundle\Content\Resolver\Resolver->resolve (line 52)
30	Cms\CmsBundle\Content\Resolver\ReferenceArrayResolver->{closure:Cms\CmsBundle\Content\Resolver\ReferenceArrayResolver::resolve():47} (line 86)
31	Cms\CmsBundle\Content\Resolver\ReferenceResolverContext->resolveRootPath (line 36)
32	Cms\CmsBundle\Content\Resolver\ReferenceResolverContext->resolve (line 71)
33	Cms\CmsBundle\Content\Resolver\ReferenceArrayResolver->resolve (line 71)
34	Cms\CmsBundle\Content\Resolver\CustomComponentResolver->resolve (line 42)
35	Cms\CmsBundle\Content\Resolver\Resolver->resolve (line 40)
36	Cms\CmsBundle\Content\Resolver\FieldResolver->resolve (line 42)
37	Cms\CmsBundle\Content\Resolver\Resolver->resolve (line 312)
38	Cms\CmsBundle\Controller\ContentController->contentEntryRevision (line 221)
39	Cms\CmsBundle\Content\Link\CmsLinkManager->handleLink (line 69)
40	Cms\CmsBundle\Content\Link\LinkManager->handleLink (line 176)
41	Cms\CmsBundle\Controller\ContentController->resolve (line 183)
42	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
43	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
44	Symfony\Component\HttpKernel\Kernel->handle (line 35)
45	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
46	require_once (line 5)

0.62 ms
(5.19%)

SELECT t0.id AS id_1, t0.storage AS storage_2, t0.storage_identifier AS storage_identifier_3, t0.public_name AS public_name_4, t0.size AS size_5, t0.mime_type AS mime_type_6, t0.type AS type_7, t0.time_uploaded AS time_uploaded_8, t0.public_storage AS public_storage_9, t0.public_storage_identifier AS public_storage_identifier_10, t0.width AS width_11, t0.height AS height_12, t0.derivatives AS derivatives_13, t0.enqueued_derivatives AS enqueued_derivatives_14, t0.folder_id AS folder_id_15 FROM cms_upload t0 WHERE t0.id IN (?, ?, ?, ?, ?, ?)

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.storage AS storage_2,
  t0.storage_identifier AS storage_identifier_3,
  t0.public_name AS public_name_4,
  t0.size AS size_5,
  t0.mime_type AS mime_type_6,
  t0.type AS type_7,
  t0.time_uploaded AS time_uploaded_8,
  t0.public_storage AS public_storage_9,
  t0.public_storage_identifier AS public_storage_identifier_10,
  t0.width AS width_11,
  t0.height AS height_12,
  t0.derivatives AS derivatives_13,
  t0.enqueued_derivatives AS enqueued_derivatives_14,
  t0.folder_id AS folder_id_15
FROM
  cms_upload t0
WHERE
  t0.id IN (?, ?, ?, ?, ?, ?)

SELECT t0.id AS id_1, t0.storage AS storage_2, t0.storage_identifier AS storage_identifier_3, t0.public_name AS public_name_4, t0.size AS size_5, t0.mime_type AS mime_type_6, t0.type AS type_7, t0.time_uploaded AS time_uploaded_8, t0.public_storage AS public_storage_9, t0.public_storage_identifier AS public_storage_identifier_10, t0.width AS width_11, t0.height AS height_12, t0.derivatives AS derivatives_13, t0.enqueued_derivatives AS enqueued_derivatives_14, t0.folder_id AS folder_id_15 FROM cms_upload t0 WHERE t0.id IN (2, 1, 3, 4, 5, 6);

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 938)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 110)
3	Doctrine\ORM\EntityRepository->findBy (line 73)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 36)
5	Cms\CmsBundle\Content\Resolver\GalleryResolver->resolve (line 42)
6	Cms\CmsBundle\Content\Resolver\Resolver->resolve (line 77)
7	Cms\CmsBundle\Content\Resolver\ContentFieldResolver->resolve (line 42)
8	Cms\CmsBundle\Content\Resolver\Resolver->resolve (line 52)
9	Cms\CmsBundle\Content\Resolver\ReferenceArrayResolver->{closure:Cms\CmsBundle\Content\Resolver\ReferenceArrayResolver::resolve():47} (line 86)
10	Cms\CmsBundle\Content\Resolver\ReferenceResolverContext->resolveRootPath (line 36)
11	Cms\CmsBundle\Content\Resolver\ReferenceResolverContext->resolve (line 71)
12	Cms\CmsBundle\Content\Resolver\ReferenceArrayResolver->resolve (line 33)
13	Cms\CmsBundle\Content\Resolver\LoopResolver->resolve (line 42)
14	Cms\CmsBundle\Content\Resolver\Resolver->resolve (line 52)
15	Cms\CmsBundle\Content\Resolver\ReferenceArrayResolver->{closure:Cms\CmsBundle\Content\Resolver\ReferenceArrayResolver::resolve():47} (line 86)
16	Cms\CmsBundle\Content\Resolver\ReferenceResolverContext->resolveRootPath (line 36)
17	Cms\CmsBundle\Content\Resolver\ReferenceResolverContext->resolve (line 71)
18	Cms\CmsBundle\Content\Resolver\ReferenceArrayResolver->resolve (line 27)
19	Cms\CmsBundle\Content\Resolver\GroupResolver->resolve (line 42)
20	Cms\CmsBundle\Content\Resolver\Resolver->resolve (line 52)
21	Cms\CmsBundle\Content\Resolver\ReferenceArrayResolver->{closure:Cms\CmsBundle\Content\Resolver\ReferenceArrayResolver::resolve():47} (line 86)
22	Cms\CmsBundle\Content\Resolver\ReferenceResolverContext->resolveRootPath (line 36)
23	Cms\CmsBundle\Content\Resolver\ReferenceResolverContext->resolve (line 71)
24	Cms\CmsBundle\Content\Resolver\ReferenceArrayResolver->resolve (line 97)
25	Cms\CmsBundle\Content\Resolver\CustomComponentResolver->resolve (line 42)
26	Cms\CmsBundle\Content\Resolver\Resolver->resolve (line 52)
27	Cms\CmsBundle\Content\Resolver\ReferenceArrayResolver->{closure:Cms\CmsBundle\Content\Resolver\ReferenceArrayResolver::resolve():47} (line 86)
28	Cms\CmsBundle\Content\Resolver\ReferenceResolverContext->resolveRootPath (line 36)
29	Cms\CmsBundle\Content\Resolver\ReferenceResolverContext->resolve (line 71)
30	Cms\CmsBundle\Content\Resolver\ReferenceArrayResolver->resolve (line 29)
31	Cms\CmsBundle\Content\Resolver\ArrayResolver->resolve (line 42)
32	Cms\CmsBundle\Content\Resolver\Resolver->resolve (line 52)
33	Cms\CmsBundle\Content\Resolver\ReferenceArrayResolver->{closure:Cms\CmsBundle\Content\Resolver\ReferenceArrayResolver::resolve():47} (line 86)
34	Cms\CmsBundle\Content\Resolver\ReferenceResolverContext->resolveRootPath (line 36)
35	Cms\CmsBundle\Content\Resolver\ReferenceResolverContext->resolve (line 71)
36	Cms\CmsBundle\Content\Resolver\ReferenceArrayResolver->resolve (line 71)
37	Cms\CmsBundle\Content\Resolver\CustomComponentResolver->resolve (line 42)
38	Cms\CmsBundle\Content\Resolver\Resolver->resolve (line 40)
39	Cms\CmsBundle\Content\Resolver\FieldResolver->resolve (line 42)
40	Cms\CmsBundle\Content\Resolver\Resolver->resolve (line 312)
41	Cms\CmsBundle\Controller\ContentController->contentEntryRevision (line 221)
42	Cms\CmsBundle\Content\Link\CmsLinkManager->handleLink (line 69)
43	Cms\CmsBundle\Content\Link\LinkManager->handleLink (line 176)
44	Cms\CmsBundle\Controller\ContentController->resolve (line 183)
45	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
46	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
47	Symfony\Component\HttpKernel\Kernel->handle (line 35)
48	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
49	require_once (line 5)

0.52 ms
(4.39%)

SELECT c0_.id AS id_0, c1_.`values` AS values_1 FROM cms_custom_content_entry_revision c1_ LEFT JOIN cms_content_entry_revision c0_ ON c1_.content_entry_revision_id = c0_.id WHERE c0_.id IN (?)

Parameters:

[
  89
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  c0_.id AS id_0,
  c1_.`values` AS values_1
FROM
  cms_custom_content_entry_revision c1_
  LEFT JOIN cms_content_entry_revision c0_ ON c1_.content_entry_revision_id = c0_.id
WHERE
  c0_.id IN (?)

SELECT c0_.id AS id_0, c1_.`values` AS values_1 FROM cms_custom_content_entry_revision c1_ LEFT JOIN cms_content_entry_revision c0_ ON c1_.content_entry_revision_id = c0_.id WHERE c0_.id IN (89);

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 701)
6	Doctrine\ORM\AbstractQuery->getArrayResult (line 122)
7	Cms\CmsBundle\Content\CustomContentTypeManager->getFieldValues (line 261)
8	Cms\CmsBundle\Content\ContentManager->getFieldValues (line 70)
9	Cms\CmsBundle\Content\Resolver\ContentFieldResolver->resolve (line 42)
10	Cms\CmsBundle\Content\Resolver\Resolver->resolve (line 52)
11	Cms\CmsBundle\Content\Resolver\ReferenceArrayResolver->{closure:Cms\CmsBundle\Content\Resolver\ReferenceArrayResolver::resolve():47} (line 86)
12	Cms\CmsBundle\Content\Resolver\ReferenceResolverContext->resolveRootPath (line 36)
13	Cms\CmsBundle\Content\Resolver\ReferenceResolverContext->resolve (line 71)
14	Cms\CmsBundle\Content\Resolver\ReferenceArrayResolver->resolve (line 33)
15	Cms\CmsBundle\Content\Resolver\LoopResolver->resolve (line 42)
16	Cms\CmsBundle\Content\Resolver\Resolver->resolve (line 52)
17	Cms\CmsBundle\Content\Resolver\ReferenceArrayResolver->{closure:Cms\CmsBundle\Content\Resolver\ReferenceArrayResolver::resolve():47} (line 86)
18	Cms\CmsBundle\Content\Resolver\ReferenceResolverContext->resolveRootPath (line 36)
19	Cms\CmsBundle\Content\Resolver\ReferenceResolverContext->resolve (line 71)
20	Cms\CmsBundle\Content\Resolver\ReferenceArrayResolver->resolve (line 27)
21	Cms\CmsBundle\Content\Resolver\GroupResolver->resolve (line 42)
22	Cms\CmsBundle\Content\Resolver\Resolver->resolve (line 52)
23	Cms\CmsBundle\Content\Resolver\ReferenceArrayResolver->{closure:Cms\CmsBundle\Content\Resolver\ReferenceArrayResolver::resolve():47} (line 86)
24	Cms\CmsBundle\Content\Resolver\ReferenceResolverContext->resolveRootPath (line 36)
25	Cms\CmsBundle\Content\Resolver\ReferenceResolverContext->resolve (line 71)
26	Cms\CmsBundle\Content\Resolver\ReferenceArrayResolver->resolve (line 97)
27	Cms\CmsBundle\Content\Resolver\CustomComponentResolver->resolve (line 42)
28	Cms\CmsBundle\Content\Resolver\Resolver->resolve (line 52)
29	Cms\CmsBundle\Content\Resolver\ReferenceArrayResolver->{closure:Cms\CmsBundle\Content\Resolver\ReferenceArrayResolver::resolve():47} (line 86)
30	Cms\CmsBundle\Content\Resolver\ReferenceResolverContext->resolveRootPath (line 36)
31	Cms\CmsBundle\Content\Resolver\ReferenceResolverContext->resolve (line 71)
32	Cms\CmsBundle\Content\Resolver\ReferenceArrayResolver->resolve (line 29)
33	Cms\CmsBundle\Content\Resolver\ArrayResolver->resolve (line 42)
34	Cms\CmsBundle\Content\Resolver\Resolver->resolve (line 52)
35	Cms\CmsBundle\Content\Resolver\ReferenceArrayResolver->{closure:Cms\CmsBundle\Content\Resolver\ReferenceArrayResolver::resolve():47} (line 86)
36	Cms\CmsBundle\Content\Resolver\ReferenceResolverContext->resolveRootPath (line 36)
37	Cms\CmsBundle\Content\Resolver\ReferenceResolverContext->resolve (line 71)
38	Cms\CmsBundle\Content\Resolver\ReferenceArrayResolver->resolve (line 71)
39	Cms\CmsBundle\Content\Resolver\CustomComponentResolver->resolve (line 42)
40	Cms\CmsBundle\Content\Resolver\Resolver->resolve (line 40)
41	Cms\CmsBundle\Content\Resolver\FieldResolver->resolve (line 42)
42	Cms\CmsBundle\Content\Resolver\Resolver->resolve (line 312)
43	Cms\CmsBundle\Controller\ContentController->contentEntryRevision (line 221)
44	Cms\CmsBundle\Content\Link\CmsLinkManager->handleLink (line 69)
45	Cms\CmsBundle\Content\Link\LinkManager->handleLink (line 176)
46	Cms\CmsBundle\Controller\ContentController->resolve (line 183)
47	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
48	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
49	Symfony\Component\HttpKernel\Kernel->handle (line 35)
50	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
51	require_once (line 5)

Database Connections

Name	Service
default	doctrine.dbal.default_connection

Entity Managers

Name	Service
default	doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

default entity manager

Class	Amount of managed objects
Cms\CmsBundle\Entity\ContentEntryRevision	11
Cms\CmsBundle\Entity\ContentEntry	8
Cms\CmsBundle\Entity\Upload	8
Cms\CmsBundle\Entity\Admin	2
Cms\CmsBundle\Entity\ContentEntryRevisionTranslation	1

Entities Mapping

Class	Mapping errors
Cms\CmsBundle\Entity\Page	No errors.
Cms\CmsBundle\Entity\ContentEntryRevision	No errors.
Cms\CmsBundle\Entity\ContentEntry	No errors.
Cms\CmsBundle\Entity\Upload	No errors.
Cms\CmsBundle\Entity\UploadFolder	No errors.
Cms\CmsBundle\Entity\Site	No errors.
Cms\CmsBundle\Entity\Admin	No errors.
Cms\CmsBundle\Entity\ContentEntryRevisionTranslation	No errors.
Cms\CmsBundle\Entity\CustomContentEntryRevision	No errors.

Symfony Profiler

GET https://www.kspd.z2d.nl/nl/duurzaamheid

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping