Symfony Profiler

Query Metrics

529 Database Queries

5 Different statements

286.60 ms Query time

3 Invalid entities

758 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

154.79 ms
(54.01%)

264

SELECT t0.id AS id_1, t0.path AS path_2, t0.level AS level_3, t0.number AS number_4, t0.name AS name_5, t0.description AS description_6, t0.display_as_catalogue AS display_as_catalogue_7, t0.display_as_list AS display_as_list_8, t0.display_as_table AS display_as_table_9, t0.article_count AS article_count_10, t0.recursive_article_count AS recursive_article_count_11, t0.children_have_articles AS children_have_articles_12, t0.shopping_cart_popup AS shopping_cart_popup_13, t0.message_shopping_cart_popup AS message_shopping_cart_popup_14, t0.erp_id AS erp_id_15, t0.parent_id AS parent_id_16 FROM oc_web_groups t0 WHERE t0.parent_id = ? ORDER BY t0.number ASC

Parameters:

[
  333
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.path AS path_2,
  t0.level AS level_3,
  t0.number AS number_4,
  t0.name AS name_5,
  t0.description AS description_6,
  t0.display_as_catalogue AS display_as_catalogue_7,
  t0.display_as_list AS display_as_list_8,
  t0.display_as_table AS display_as_table_9,
  t0.article_count AS article_count_10,
  t0.recursive_article_count AS recursive_article_count_11,
  t0.children_have_articles AS children_have_articles_12,
  t0.shopping_cart_popup AS shopping_cart_popup_13,
  t0.message_shopping_cart_popup AS message_shopping_cart_popup_14,
  t0.erp_id AS erp_id_15,
  t0.parent_id AS parent_id_16
FROM
  oc_web_groups t0
WHERE
  t0.parent_id = ?
ORDER BY
  t0.number ASC

SELECT t0.id AS id_1, t0.path AS path_2, t0.level AS level_3, t0.number AS number_4, t0.name AS name_5, t0.description AS description_6, t0.display_as_catalogue AS display_as_catalogue_7, t0.display_as_list AS display_as_list_8, t0.display_as_table AS display_as_table_9, t0.article_count AS article_count_10, t0.recursive_article_count AS recursive_article_count_11, t0.children_have_articles AS children_have_articles_12, t0.shopping_cart_popup AS shopping_cart_popup_13, t0.message_shopping_cart_popup AS message_shopping_cart_popup_14, t0.erp_id AS erp_id_15, t0.parent_id AS parent_id_16 FROM oc_web_groups t0 WHERE t0.parent_id = 333 ORDER BY t0.number ASC;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1872)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 1817)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2729)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->count (line 39)
7	Doctrine\ORM\PersistentCollection->count (line 391)
8	Doctrine\ORM\PersistentCollection->isEmpty (line 446)
9	App\Entity\WebGroup->hasChildren (line 322)
10	App\Tools\WebGroupHelper->translateGroupsRecursive (line 265)
11	App\EventListener\RequestListener->updateWebGroups (line 267)
12	App\EventListener\RequestListener->onKernelRequest (line 130)
13	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
14	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
15	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
16	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
19	Symfony\Component\HttpKernel\EventListener\ErrorListener->onKernelException (line 99)
20	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
21	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
22	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
23	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
24	Symfony\Component\HttpKernel\HttpKernel->handleThrowable (line 241)
25	Symfony\Component\HttpKernel\HttpKernel->handle (line 91)
26	Symfony\Component\HttpKernel\Kernel->handle (line 193)
27	{closure} (line 30)
28	Symfony\Component\Runtime\Resolver\DebugClosureResolver::Symfony\Component\Runtime\Resolver\{closure} (line 25)
29	require (line 27)
30	require (line 5)
31	require (line 7)

125.40 ms
(43.75%)

257

SELECT t0.id AS id_1, t0.type AS type_2, t0.value AS value_3, t0.web_group_id AS web_group_id_4, t0.language_id AS language_id_5 FROM oc_web_group_translations t0 WHERE t0.web_group_id = ?

Parameters:

[
  340
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.type AS type_2,
  t0.value AS value_3,
  t0.web_group_id AS web_group_id_4,
  t0.language_id AS language_id_5
FROM
  oc_web_group_translations t0
WHERE
  t0.web_group_id = ?

SELECT t0.id AS id_1, t0.type AS type_2, t0.value AS value_3, t0.web_group_id AS web_group_id_4, t0.language_id AS language_id_5 FROM oc_web_group_translations t0 WHERE t0.web_group_id = 340;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1872)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 1817)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2729)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 313)
7	App\Tools\WebGroupHelper->translateGroup (line 279)
8	App\Tools\WebGroupHelper->translateGroupsRecursive (line 263)
9	App\Tools\WebGroupHelper->translateGroupsRecursive (line 266)
10	App\EventListener\RequestListener->updateWebGroups (line 267)
11	App\EventListener\RequestListener->onKernelRequest (line 130)
12	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
13	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
14	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
15	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
16	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
17	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
18	Symfony\Component\HttpKernel\EventListener\ErrorListener->onKernelException (line 99)
19	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
20	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
21	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
22	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
23	Symfony\Component\HttpKernel\HttpKernel->handleThrowable (line 241)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 91)
25	Symfony\Component\HttpKernel\Kernel->handle (line 193)
26	{closure} (line 30)
27	Symfony\Component\Runtime\Resolver\DebugClosureResolver::Symfony\Component\Runtime\Resolver\{closure} (line 25)
28	require (line 27)
29	require (line 5)
30	require (line 7)

3.93 ms
(1.37%)

SELECT o0_.id AS id_0, o0_.name AS name_1, o0_.configuration AS configuration_2, o0_.value AS value_3, o0_.is_editable AS is_editable_4, o0_.modification_date AS modification_date_5 FROM oc_settings o0_ WHERE o0_.name = ?

Parameters:

[
  "open-site"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  o0_.id AS id_0,
  o0_.name AS name_1,
  o0_.configuration AS configuration_2,
  o0_.value AS value_3,
  o0_.is_editable AS is_editable_4,
  o0_.modification_date AS modification_date_5
FROM
  oc_settings o0_
WHERE
  o0_.name = ?

SELECT o0_.id AS id_0, o0_.name AS name_1, o0_.configuration AS configuration_2, o0_.value AS value_3, o0_.is_editable AS is_editable_4, o0_.modification_date AS modification_date_5 FROM oc_settings o0_ WHERE o0_.name = 'open-site';

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 737)
6	App\Repository\SettingRepository->findOneByName (line 53)
7	App\Service\SettingService->getValue (line 56)
8	App\Service\SettingService->run (line 38)
9	App\EventListener\RequestListener->validateOpenSite (line 195)
10	App\EventListener\RequestListener->validateAndSetOpenSiteState (line 227)
11	App\EventListener\RequestListener->onKernelRequest (line 124)
12	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
13	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
14	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
15	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
16	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
17	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
18	Symfony\Component\HttpKernel\EventListener\ErrorListener->onKernelException (line 99)
19	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
20	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
21	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
22	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
23	Symfony\Component\HttpKernel\HttpKernel->handleThrowable (line 241)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 91)
25	Symfony\Component\HttpKernel\Kernel->handle (line 193)
26	{closure} (line 30)
27	Symfony\Component\Runtime\Resolver\DebugClosureResolver::Symfony\Component\Runtime\Resolver\{closure} (line 25)
28	require (line 27)
29	require (line 5)
30	require (line 7)

1.30 ms
(0.46%)

SELECT o0_.id AS id_0, o0_.code AS code_1, o0_.name AS name_2, o0_.locale AS locale_3, o0_.erp_id AS erp_id_4 FROM oc_languages o0_ WHERE o0_.locale LIKE ?

Parameters:

[
  "de"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  o0_.id AS id_0,
  o0_.code AS code_1,
  o0_.name AS name_2,
  o0_.locale AS locale_3,
  o0_.erp_id AS erp_id_4
FROM
  oc_languages o0_
WHERE
  o0_.locale LIKE ?

SELECT o0_.id AS id_0, o0_.code AS code_1, o0_.name AS name_2, o0_.locale AS locale_3, o0_.erp_id AS erp_id_4 FROM oc_languages o0_ WHERE o0_.locale LIKE 'de';

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 737)
6	App\Repository\LanguageRepository->findOneByLocale (line 94)
7	App\EventListener\RequestListener->onKernelRequest (line 107)
8	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
9	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
10	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
11	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
12	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
13	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
14	Symfony\Component\HttpKernel\EventListener\ErrorListener->onKernelException (line 99)
15	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
16	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
17	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
18	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
19	Symfony\Component\HttpKernel\HttpKernel->handleThrowable (line 241)
20	Symfony\Component\HttpKernel\HttpKernel->handle (line 91)
21	Symfony\Component\HttpKernel\Kernel->handle (line 193)
22	{closure} (line 30)
23	Symfony\Component\Runtime\Resolver\DebugClosureResolver::Symfony\Component\Runtime\Resolver\{closure} (line 25)
24	require (line 27)
25	require (line 5)
26	require (line 7)

1.17 ms
(0.41%)

SELECT o0_.id AS id_0, o0_.path AS path_1, o0_.level AS level_2, o0_.number AS number_3, o0_.name AS name_4, o0_.description AS description_5, o0_.display_as_catalogue AS display_as_catalogue_6, o0_.display_as_list AS display_as_list_7, o0_.display_as_table AS display_as_table_8, o0_.article_count AS article_count_9, o0_.recursive_article_count AS recursive_article_count_10, o0_.children_have_articles AS children_have_articles_11, o0_.shopping_cart_popup AS shopping_cart_popup_12, o0_.message_shopping_cart_popup AS message_shopping_cart_popup_13, o0_.erp_id AS erp_id_14, o1_.id AS id_15, o1_.type AS type_16, o1_.value AS value_17, o2_.id AS id_18, o2_.file AS file_19, o2_.hash AS hash_20, o2_.size AS size_21, o2_.width AS width_22, o2_.height AS height_23, o2_.type AS type_24, o2_.mime_type AS mime_type_25, o2_.erp_id AS erp_id_26, o0_.parent_id AS parent_id_27, o1_.web_group_id AS web_group_id_28, o1_.language_id AS language_id_29 FROM oc_web_groups o0_ LEFT JOIN oc_web_group_translations o1_ ON o0_.id = o1_.web_group_id LEFT JOIN oc_web_group_media o3_ ON o0_.id = o3_.web_group_id LEFT JOIN oc_media o2_ ON o2_.id = o3_.media_id WHERE o0_.parent_id IS NULL AND (o0_.article_count > 0 OR o0_.children_have_articles = 1) ORDER BY o0_.number ASC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  o0_.id AS id_0,
  o0_.path AS path_1,
  o0_.level AS level_2,
  o0_.number AS number_3,
  o0_.name AS name_4,
  o0_.description AS description_5,
  o0_.display_as_catalogue AS display_as_catalogue_6,
  o0_.display_as_list AS display_as_list_7,
  o0_.display_as_table AS display_as_table_8,
  o0_.article_count AS article_count_9,
  o0_.recursive_article_count AS recursive_article_count_10,
  o0_.children_have_articles AS children_have_articles_11,
  o0_.shopping_cart_popup AS shopping_cart_popup_12,
  o0_.message_shopping_cart_popup AS message_shopping_cart_popup_13,
  o0_.erp_id AS erp_id_14,
  o1_.id AS id_15,
  o1_.type AS type_16,
  o1_.value AS value_17,
  o2_.id AS id_18,
  o2_.file AS file_19,
  o2_.hash AS hash_20,
  o2_.size AS size_21,
  o2_.width AS width_22,
  o2_.height AS height_23,
  o2_.type AS type_24,
  o2_.mime_type AS mime_type_25,
  o2_.erp_id AS erp_id_26,
  o0_.parent_id AS parent_id_27,
  o1_.web_group_id AS web_group_id_28,
  o1_.language_id AS language_id_29
FROM
  oc_web_groups o0_
  LEFT JOIN oc_web_group_translations o1_ ON o0_.id = o1_.web_group_id
  LEFT JOIN oc_web_group_media o3_ ON o0_.id = o3_.web_group_id
  LEFT JOIN oc_media o2_ ON o2_.id = o3_.media_id
WHERE
  o0_.parent_id IS NULL
  AND (
    o0_.article_count > 0
    OR o0_.children_have_articles = 1
  )
ORDER BY
  o0_.number ASC

SELECT o0_.id AS id_0, o0_.path AS path_1, o0_.level AS level_2, o0_.number AS number_3, o0_.name AS name_4, o0_.description AS description_5, o0_.display_as_catalogue AS display_as_catalogue_6, o0_.display_as_list AS display_as_list_7, o0_.display_as_table AS display_as_table_8, o0_.article_count AS article_count_9, o0_.recursive_article_count AS recursive_article_count_10, o0_.children_have_articles AS children_have_articles_11, o0_.shopping_cart_popup AS shopping_cart_popup_12, o0_.message_shopping_cart_popup AS message_shopping_cart_popup_13, o0_.erp_id AS erp_id_14, o1_.id AS id_15, o1_.type AS type_16, o1_.value AS value_17, o2_.id AS id_18, o2_.file AS file_19, o2_.hash AS hash_20, o2_.size AS size_21, o2_.width AS width_22, o2_.height AS height_23, o2_.type AS type_24, o2_.mime_type AS mime_type_25, o2_.erp_id AS erp_id_26, o0_.parent_id AS parent_id_27, o1_.web_group_id AS web_group_id_28, o1_.language_id AS language_id_29 FROM oc_web_groups o0_ LEFT JOIN oc_web_group_translations o1_ ON o0_.id = o1_.web_group_id LEFT JOIN oc_web_group_media o3_ ON o0_.id = o3_.web_group_id LEFT JOIN oc_media o2_ ON o2_.id = o3_.media_id WHERE o0_.parent_id IS NULL AND (o0_.article_count > 0 OR o0_.children_have_articles = 1) ORDER BY o0_.number ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 804)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
3	Doctrine\ORM\Query->_doExecute (line 296)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
5	Doctrine\ORM\AbstractQuery->execute (line 886)
6	Doctrine\ORM\AbstractQuery->getResult (line 688)
7	App\Repository\WebGroupRepository->findByParent (line 122)
8	App\EventListener\RequestListener->updateWebGroups (line 266)
9	App\EventListener\RequestListener->onKernelRequest (line 130)
10	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
11	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
12	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
13	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
14	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
15	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
16	Symfony\Component\HttpKernel\EventListener\ErrorListener->onKernelException (line 99)
17	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
18	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
19	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
20	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
21	Symfony\Component\HttpKernel\HttpKernel->handleThrowable (line 241)
22	Symfony\Component\HttpKernel\HttpKernel->handle (line 91)
23	Symfony\Component\HttpKernel\Kernel->handle (line 193)
24	{closure} (line 30)
25	Symfony\Component\Runtime\Resolver\DebugClosureResolver::Symfony\Component\Runtime\Resolver\{closure} (line 25)
26	require (line 27)
27	require (line 5)
28	require (line 7)

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\WebGroupTranslation	486
App\Entity\WebGroup	264
App\Entity\Setting	4
App\Entity\Language	3
App\Entity\Media	1

Entities Mapping

Class	Mapping errors
App\Entity\Language	No errors.
App\Entity\Setting	No errors.
App\Entity\WebGroup	The mappings App\Entity\WebGroup#medias and App\Entity\Media#webGroups are inconsistent with each other.
App\Entity\WebGroupTranslation	No errors.
App\Entity\Media	The association App\Entity\Media#articles refers to the owning side field App\Entity\Article#media which does not exist. The association App\Entity\Media#webGroups refers to the owning side field App\Entity\WebGroup#media which does not exist.
App\Entity\Article	The mappings App\Entity\Article#medias and App\Entity\Media#articles are inconsistent with each other.

Symfony Profiler

GET https://vhost03.bugfixservice.de/sitemap_index.xml

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping