Symfony Profiler

Query Metrics

529 Database Queries

5 Different statements

305.64 ms Query time

3 Invalid entities

758 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

160.57 ms
(52.53%)

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)

139.78 ms
(45.73%)

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)

2.75 ms
(0.90%)

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.31 ms
(0.43%)

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.24 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.
App\Entity\RelatedArticleList	No errors.
App\Entity\ArticleVariant	No errors.
App\Entity\ArticleRelated	No errors.
App\Entity\CutType	No errors.
App\Entity\Group	No errors.
App\Entity\QuantityRange	No errors.
App\Entity\SteelGrade	No errors.
App\Entity\MaterialType	No errors.
App\Entity\Shape	No errors.
App\Entity\Surface	No errors.
App\Entity\Unit	No errors.
App\Entity\TaxRate	No errors.
App\Entity\StockInformation	No errors.
App\Entity\ArticleTranslation	No errors.
App\Entity\ArticleBasePrice	No errors.
App\Entity\Packaging	No errors.

Symfony Profiler

GET https://vhost03.bugfixservice.de/robots.txt

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping