Symfony Profiler

Query Metrics

63 Database Queries

6 Different statements

32.06 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

13.51 ms
(42.14%)

SELECT t0.id AS id_1, t0.type AS type_2, t0.sort_order AS sort_order_3, t0.is_deleted AS is_deleted_4, t0.restrict_sites AS restrict_sites_5, t0.time_created AS time_created_6, t0.time_published AS time_published_7, t0.time_deleted AS time_deleted_8, t0.published_revision_id AS published_revision_id_9, t0.draft_revision_id AS draft_revision_id_10 FROM cms_content_entry t0 WHERE t0.id = ?

Parameters:

[
  4
]

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.is_deleted AS is_deleted_4,
  t0.restrict_sites AS restrict_sites_5,
  t0.time_created AS time_created_6,
  t0.time_published AS time_published_7,
  t0.time_deleted AS time_deleted_8,
  t0.published_revision_id AS published_revision_id_9,
  t0.draft_revision_id AS draft_revision_id_10
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.is_deleted AS is_deleted_4, t0.restrict_sites AS restrict_sites_5, t0.time_created AS time_created_6, t0.time_published AS time_published_7, t0.time_deleted AS time_deleted_8, t0.published_revision_id AS published_revision_id_9, t0.draft_revision_id AS draft_revision_id_10 FROM cms_content_entry t0 WHERE t0.id = 4;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 776)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 794)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 521)
4	Doctrine\ORM\EntityManager->find (line 197)
5	Doctrine\ORM\EntityRepository->find (line 57)
6	Cms\CmsBundle\Content\Resolver\ContentResolver->resolve (line 42)
7	Cms\CmsBundle\Content\Resolver\Resolver->resolve (line 52)
8	Cms\CmsBundle\Content\Resolver\ReferenceArrayResolver->Cms\CmsBundle\Content\Resolver\{closure} (line 86)
9	Cms\CmsBundle\Content\Resolver\ReferenceResolverContext->resolveRootPath (line 36)
10	Cms\CmsBundle\Content\Resolver\ReferenceResolverContext->resolve (line 71)
11	Cms\CmsBundle\Content\Resolver\ReferenceArrayResolver->resolve (line 23)
12	Cms\CmsBundle\Content\Resolver\LinkResolver->resolve (line 42)
13	Cms\CmsBundle\Content\Resolver\Resolver->resolve (line 47)
14	Cms\CmsBundle\Content\Resolver\MenuResolver->resolveChild (line 32)
15	Cms\CmsBundle\Content\Resolver\MenuResolver->Cms\CmsBundle\Content\Resolver\{closure} (line 1)
16	array_map (line 32)
17	Cms\CmsBundle\Content\Resolver\MenuResolver->resolveChild (line 20)
18	Cms\CmsBundle\Content\Resolver\MenuResolver->Cms\CmsBundle\Content\Resolver\{closure} (line 1)
19	array_map (line 20)
20	Cms\CmsBundle\Content\Resolver\MenuResolver->resolve (line 42)
21	Cms\CmsBundle\Content\Resolver\Resolver->resolve (line 33)
22	Cms\CmsBundle\Content\Resolver\OptionResolver->resolve (line 42)
23	Cms\CmsBundle\Content\Resolver\Resolver->resolve (line 52)
24	Cms\CmsBundle\Content\Resolver\ReferenceArrayResolver->Cms\CmsBundle\Content\Resolver\{closure} (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 97)
28	Cms\CmsBundle\Content\Resolver\CustomComponentResolver->resolve (line 42)
29	Cms\CmsBundle\Content\Resolver\Resolver->resolve (line 52)
30	Cms\CmsBundle\Content\Resolver\ReferenceArrayResolver->Cms\CmsBundle\Content\Resolver\{closure} (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 34)
34	App\Content\Resolver\ViewTrackerResolver->resolve (line 42)
35	Cms\CmsBundle\Content\Resolver\Resolver->resolve (line 281)
36	Cms\CmsBundle\Controller\ContentController->contentEntryRevision (line 164)
37	Cms\CmsBundle\Content\Link\CmsLinkManager->handleLink (line 53)
38	Cms\CmsBundle\Content\Link\LinkManager->handleLink (line 167)
39	Cms\CmsBundle\Controller\ContentController->resolve (line 183)
40	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
41	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
42	Symfony\Component\HttpKernel\Kernel->handle (line 35)
43	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
44	require_once (line 5)

12.64 ms
(39.43%)

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.parent_id AS parent_id_6, t0.author_id AS author_id_7 FROM cms_content_entry_revision t0 WHERE t0.id = ?

Parameters:

[
  1111
]

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.parent_id AS parent_id_6,
  t0.author_id AS author_id_7
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.parent_id AS parent_id_6, t0.author_id AS author_id_7 FROM cms_content_entry_revision t0 WHERE t0.id = 1111;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 776)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 794)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 364)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 471)
5	Proxies\__CG__\Cms\CmsBundle\Entity\ContentEntryRevision::Doctrine\ORM\Proxy\{closure} (line 59)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 129)
7	Proxies\__CG__\Cms\CmsBundle\Entity\ContentEntryRevision->__get (line 65)
8	Cms\CmsBundle\Content\Resolver\ContentResolver->resolve (line 42)
9	Cms\CmsBundle\Content\Resolver\Resolver->resolve (line 26)
10	Cms\CmsBundle\Content\Resolver\ContentFieldResolver->resolve (line 42)
11	Cms\CmsBundle\Content\Resolver\Resolver->resolve (line 52)
12	Cms\CmsBundle\Content\Resolver\ReferenceArrayResolver->Cms\CmsBundle\Content\Resolver\{closure} (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 71)
16	Cms\CmsBundle\Content\Resolver\CustomComponentResolver->resolve (line 42)
17	Cms\CmsBundle\Content\Resolver\Resolver->resolve (line 52)
18	Cms\CmsBundle\Content\Resolver\ReferenceArrayResolver->Cms\CmsBundle\Content\Resolver\{closure} (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 19)
22	Cms\CmsBundle\Content\Resolver\ArrayResolver->resolve (line 42)
23	Cms\CmsBundle\Content\Resolver\Resolver->resolve (line 52)
24	Cms\CmsBundle\Content\Resolver\ReferenceArrayResolver->Cms\CmsBundle\Content\Resolver\{closure} (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 71)
28	Cms\CmsBundle\Content\Resolver\CustomComponentResolver->resolve (line 42)
29	Cms\CmsBundle\Content\Resolver\Resolver->resolve (line 52)
30	Cms\CmsBundle\Content\Resolver\ReferenceArrayResolver->Cms\CmsBundle\Content\Resolver\{closure} (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 34)
34	App\Content\Resolver\ViewTrackerResolver->resolve (line 42)
35	Cms\CmsBundle\Content\Resolver\Resolver->resolve (line 281)
36	Cms\CmsBundle\Controller\ContentController->contentEntryRevision (line 164)
37	Cms\CmsBundle\Content\Link\CmsLinkManager->handleLink (line 53)
38	Cms\CmsBundle\Content\Link\LinkManager->handleLink (line 167)
39	Cms\CmsBundle\Controller\ContentController->resolve (line 183)
40	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
41	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
42	Symfony\Component\HttpKernel\Kernel->handle (line 35)
43	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
44	require_once (line 5)

2.85 ms
(8.90%)

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.public_storage AS public_storage_8, t0.public_storage_identifier AS public_storage_identifier_9, t0.width AS width_10, t0.height AS height_11, t0.derivatives AS derivatives_12, t0.enqueued_derivatives AS enqueued_derivatives_13, t0.folder_id AS folder_id_14 FROM cms_upload t0 WHERE t0.id = ?

Parameters:

[
  154
]

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.public_storage AS public_storage_8,
  t0.public_storage_identifier AS public_storage_identifier_9,
  t0.width AS width_10,
  t0.height AS height_11,
  t0.derivatives AS derivatives_12,
  t0.enqueued_derivatives AS enqueued_derivatives_13,
  t0.folder_id AS folder_id_14
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.public_storage AS public_storage_8, t0.public_storage_identifier AS public_storage_identifier_9, t0.width AS width_10, t0.height AS height_11, t0.derivatives AS derivatives_12, t0.enqueued_derivatives AS enqueued_derivatives_13, t0.folder_id AS folder_id_14 FROM cms_upload t0 WHERE t0.id = 154;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 776)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 794)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 521)
4	Doctrine\ORM\EntityManager->find (line 197)
5	Doctrine\ORM\EntityRepository->find (line 41)
6	Cms\CmsBundle\Content\Resolver\UploadImageSourceResolver->resolve (line 42)
7	Cms\CmsBundle\Content\Resolver\Resolver->resolve (line 71)
8	Cms\CmsBundle\Content\Resolver\ContentFieldResolver->resolve (line 42)
9	Cms\CmsBundle\Content\Resolver\Resolver->resolve (line 52)
10	Cms\CmsBundle\Content\Resolver\ReferenceArrayResolver->Cms\CmsBundle\Content\Resolver\{closure} (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->Cms\CmsBundle\Content\Resolver\{closure} (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 19)
20	Cms\CmsBundle\Content\Resolver\ArrayResolver->resolve (line 42)
21	Cms\CmsBundle\Content\Resolver\Resolver->resolve (line 52)
22	Cms\CmsBundle\Content\Resolver\ReferenceArrayResolver->Cms\CmsBundle\Content\Resolver\{closure} (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 52)
28	Cms\CmsBundle\Content\Resolver\ReferenceArrayResolver->Cms\CmsBundle\Content\Resolver\{closure} (line 86)
29	Cms\CmsBundle\Content\Resolver\ReferenceResolverContext->resolveRootPath (line 36)
30	Cms\CmsBundle\Content\Resolver\ReferenceResolverContext->resolve (line 71)
31	Cms\CmsBundle\Content\Resolver\ReferenceArrayResolver->resolve (line 34)
32	App\Content\Resolver\ViewTrackerResolver->resolve (line 42)
33	Cms\CmsBundle\Content\Resolver\Resolver->resolve (line 281)
34	Cms\CmsBundle\Controller\ContentController->contentEntryRevision (line 164)
35	Cms\CmsBundle\Content\Link\CmsLinkManager->handleLink (line 53)
36	Cms\CmsBundle\Content\Link\LinkManager->handleLink (line 167)
37	Cms\CmsBundle\Controller\ContentController->resolve (line 183)
38	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
39	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
40	Symfony\Component\HttpKernel\Kernel->handle (line 35)
41	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
42	require_once (line 5)

1.45 ms
(4.51%)

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:

[
  1111
]

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 (1111);

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 33)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 327)
3	Doctrine\ORM\Query->_doExecute (line 1212)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1166)
5	Doctrine\ORM\AbstractQuery->execute (line 913)
6	Doctrine\ORM\AbstractQuery->getArrayResult (line 115)
7	Cms\CmsBundle\Content\CustomContentTypeManager->getFieldValues (line 257)
8	Cms\CmsBundle\Content\ContentManager->getFieldValues (line 432)
9	Cms\CmsBundle\Controller\ContentController->getResolverContext (line 275)
10	Cms\CmsBundle\Controller\ContentController->contentEntryRevision (line 164)
11	Cms\CmsBundle\Content\Link\CmsLinkManager->handleLink (line 53)
12	Cms\CmsBundle\Content\Link\LinkManager->handleLink (line 167)
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.89 ms
(2.78%)

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:

[
  1111
  "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 (1111) AND c0_.locale = 'nl';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 33)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 327)
3	Doctrine\ORM\Query->_doExecute (line 1212)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1166)
5	Doctrine\ORM\AbstractQuery->execute (line 901)
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 42)
10	Cms\CmsBundle\Content\Resolver\ContentFieldResolver->resolve (line 42)
11	Cms\CmsBundle\Content\Resolver\Resolver->resolve (line 52)
12	Cms\CmsBundle\Content\Resolver\ReferenceArrayResolver->Cms\CmsBundle\Content\Resolver\{closure} (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 71)
16	Cms\CmsBundle\Content\Resolver\CustomComponentResolver->resolve (line 42)
17	Cms\CmsBundle\Content\Resolver\Resolver->resolve (line 52)
18	Cms\CmsBundle\Content\Resolver\ReferenceArrayResolver->Cms\CmsBundle\Content\Resolver\{closure} (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 19)
22	Cms\CmsBundle\Content\Resolver\ArrayResolver->resolve (line 42)
23	Cms\CmsBundle\Content\Resolver\Resolver->resolve (line 52)
24	Cms\CmsBundle\Content\Resolver\ReferenceArrayResolver->Cms\CmsBundle\Content\Resolver\{closure} (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 71)
28	Cms\CmsBundle\Content\Resolver\CustomComponentResolver->resolve (line 42)
29	Cms\CmsBundle\Content\Resolver\Resolver->resolve (line 52)
30	Cms\CmsBundle\Content\Resolver\ReferenceArrayResolver->Cms\CmsBundle\Content\Resolver\{closure} (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 34)
34	App\Content\Resolver\ViewTrackerResolver->resolve (line 42)
35	Cms\CmsBundle\Content\Resolver\Resolver->resolve (line 281)
36	Cms\CmsBundle\Controller\ContentController->contentEntryRevision (line 164)
37	Cms\CmsBundle\Content\Link\CmsLinkManager->handleLink (line 53)
38	Cms\CmsBundle\Content\Link\LinkManager->handleLink (line 167)
39	Cms\CmsBundle\Controller\ContentController->resolve (line 183)
40	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
41	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
42	Symfony\Component\HttpKernel\Kernel->handle (line 35)
43	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
44	require_once (line 5)

0.72 ms
(2.23%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.summary AS summary_4, t0.published AS published_5, t0.deleted AS deleted_6, t0.image_id AS image_id_7 FROM quality_report t0 WHERE t0.id = ?

Parameters:

[
  "6"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.summary AS summary_4,
  t0.published AS published_5,
  t0.deleted AS deleted_6,
  t0.image_id AS image_id_7
FROM
  quality_report t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.summary AS summary_4, t0.published AS published_5, t0.deleted AS deleted_6, t0.image_id AS image_id_7 FROM quality_report t0 WHERE t0.id = '6';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 776)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 794)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 521)
4	Doctrine\ORM\EntityManager->find (line 197)
5	Doctrine\ORM\EntityRepository->find (line 26)
6	App\Content\Resolver\QualityReportLinkResolver->resolve (line 42)
7	Cms\CmsBundle\Content\Resolver\Resolver->resolve (line 52)
8	Cms\CmsBundle\Content\Resolver\ReferenceArrayResolver->Cms\CmsBundle\Content\Resolver\{closure} (line 86)
9	Cms\CmsBundle\Content\Resolver\ReferenceResolverContext->resolveRootPath (line 36)
10	Cms\CmsBundle\Content\Resolver\ReferenceResolverContext->resolve (line 71)
11	Cms\CmsBundle\Content\Resolver\ReferenceArrayResolver->resolve (line 23)
12	Cms\CmsBundle\Content\Resolver\LinkResolver->resolve (line 42)
13	Cms\CmsBundle\Content\Resolver\Resolver->resolve (line 52)
14	Cms\CmsBundle\Content\Resolver\ReferenceArrayResolver->Cms\CmsBundle\Content\Resolver\{closure} (line 86)
15	Cms\CmsBundle\Content\Resolver\ReferenceResolverContext->resolveRootPath (line 36)
16	Cms\CmsBundle\Content\Resolver\ReferenceResolverContext->resolve (line 71)
17	Cms\CmsBundle\Content\Resolver\ReferenceArrayResolver->resolve (line 19)
18	Cms\CmsBundle\Content\Resolver\ArrayResolver->resolve (line 42)
19	Cms\CmsBundle\Content\Resolver\Resolver->resolve (line 33)
20	Cms\CmsBundle\Content\Resolver\OptionResolver->resolve (line 42)
21	Cms\CmsBundle\Content\Resolver\Resolver->resolve (line 52)
22	Cms\CmsBundle\Content\Resolver\ReferenceArrayResolver->Cms\CmsBundle\Content\Resolver\{closure} (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 97)
26	Cms\CmsBundle\Content\Resolver\CustomComponentResolver->resolve (line 42)
27	Cms\CmsBundle\Content\Resolver\Resolver->resolve (line 52)
28	Cms\CmsBundle\Content\Resolver\ReferenceArrayResolver->Cms\CmsBundle\Content\Resolver\{closure} (line 86)
29	Cms\CmsBundle\Content\Resolver\ReferenceResolverContext->resolveRootPath (line 36)
30	Cms\CmsBundle\Content\Resolver\ReferenceResolverContext->resolve (line 71)
31	Cms\CmsBundle\Content\Resolver\ReferenceArrayResolver->resolve (line 34)
32	App\Content\Resolver\ViewTrackerResolver->resolve (line 42)
33	Cms\CmsBundle\Content\Resolver\Resolver->resolve (line 281)
34	Cms\CmsBundle\Controller\ContentController->contentEntryRevision (line 164)
35	Cms\CmsBundle\Content\Link\CmsLinkManager->handleLink (line 53)
36	Cms\CmsBundle\Content\Link\LinkManager->handleLink (line 167)
37	Cms\CmsBundle\Controller\ContentController->resolve (line 183)
38	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
39	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
40	Symfony\Component\HttpKernel\Kernel->handle (line 35)
41	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
42	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.

Entities Mapping

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

Symfony Profiler

GET https://gors.boldrdev.nl/nieuws/diana-joosse

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping