Symfony Profiler

Query Metrics

6 Database Queries

5 Different statements

17.90 ms Query time

0 Invalid entities

766 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

14.46 ms
(80.77%)

SELECT m0_.alias AS alias_0, m0_.lft AS lft_1, m0_.rgt AS rgt_2, m0_.lvl AS lvl_3, m0_.root AS root_4, m0_.id AS id_5, c1_.main_template AS main_template_6, c1_.product_template AS product_template_7, c1_.filterable AS filterable_8, c1_.id AS id_9, c1_.created_at AS created_at_10, c1_.updated_at AS updated_at_11, c2_.slug AS slug_12, c2_.title AS title_13, c2_.h1 AS h1_14, c2_.perex AS perex_15, c2_.description AS description_16, c2_.meta_title AS meta_title_17, c2_.meta_description AS meta_description_18, c2_.meta_keywords AS meta_keywords_19, c2_.locale AS locale_20, c2_.id AS id_21, i3_.name AS name_22, i3_.original_name AS original_name_23, i3_.mime_type AS mime_type_24, i3_.size AS size_25, i3_.width AS width_26, i3_.height AS height_27, i3_.id AS id_28, i3_.created_at AS created_at_29, i3_.updated_at AS updated_at_30, i4_.title AS title_31, i4_.keywords AS keywords_32, i4_.locale AS locale_33, i4_.id AS id_34, m0_.category_id AS category_id_35, m0_.parent_id AS parent_id_36, c1_.principal_image_id AS principal_image_id_37, c2_.translatable_id AS translatable_id_38, i4_.translatable_id AS translatable_id_39 FROM menu_de m0_ LEFT JOIN category c1_ ON m0_.category_id = c1_.id LEFT JOIN category_translation c2_ ON c1_.id = c2_.translatable_id AND (c2_.locale IN (?, ?)) LEFT JOIN image i3_ ON c1_.principal_image_id = i3_.id LEFT JOIN image_translation i4_ ON i3_.id = i4_.translatable_id AND (i4_.locale IN (?, ?)) ORDER BY m0_.lft ASC

Parameters:

[
  "de_AT"
  "de"
  "de_AT"
  "de"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  m0_.alias AS alias_0,
  m0_.lft AS lft_1,
  m0_.rgt AS rgt_2,
  m0_.lvl AS lvl_3,
  m0_.root AS root_4,
  m0_.id AS id_5,
  c1_.main_template AS main_template_6,
  c1_.product_template AS product_template_7,
  c1_.filterable AS filterable_8,
  c1_.id AS id_9,
  c1_.created_at AS created_at_10,
  c1_.updated_at AS updated_at_11,
  c2_.slug AS slug_12,
  c2_.title AS title_13,
  c2_.h1 AS h1_14,
  c2_.perex AS perex_15,
  c2_.description AS description_16,
  c2_.meta_title AS meta_title_17,
  c2_.meta_description AS meta_description_18,
  c2_.meta_keywords AS meta_keywords_19,
  c2_.locale AS locale_20,
  c2_.id AS id_21,
  i3_.name AS name_22,
  i3_.original_name AS original_name_23,
  i3_.mime_type AS mime_type_24,
  i3_.size AS size_25,
  i3_.width AS width_26,
  i3_.height AS height_27,
  i3_.id AS id_28,
  i3_.created_at AS created_at_29,
  i3_.updated_at AS updated_at_30,
  i4_.title AS title_31,
  i4_.keywords AS keywords_32,
  i4_.locale AS locale_33,
  i4_.id AS id_34,
  m0_.category_id AS category_id_35,
  m0_.parent_id AS parent_id_36,
  c1_.principal_image_id AS principal_image_id_37,
  c2_.translatable_id AS translatable_id_38,
  i4_.translatable_id AS translatable_id_39
FROM
  menu_de m0_
  LEFT JOIN category c1_ ON m0_.category_id = c1_.id
  LEFT JOIN category_translation c2_ ON c1_.id = c2_.translatable_id
  AND (
    c2_.locale IN (?, ?)
  )
  LEFT JOIN image i3_ ON c1_.principal_image_id = i3_.id
  LEFT JOIN image_translation i4_ ON i3_.id = i4_.translatable_id
  AND (
    i4_.locale IN (?, ?)
  )
ORDER BY
  m0_.lft ASC

SELECT m0_.alias AS alias_0, m0_.lft AS lft_1, m0_.rgt AS rgt_2, m0_.lvl AS lvl_3, m0_.root AS root_4, m0_.id AS id_5, c1_.main_template AS main_template_6, c1_.product_template AS product_template_7, c1_.filterable AS filterable_8, c1_.id AS id_9, c1_.created_at AS created_at_10, c1_.updated_at AS updated_at_11, c2_.slug AS slug_12, c2_.title AS title_13, c2_.h1 AS h1_14, c2_.perex AS perex_15, c2_.description AS description_16, c2_.meta_title AS meta_title_17, c2_.meta_description AS meta_description_18, c2_.meta_keywords AS meta_keywords_19, c2_.locale AS locale_20, c2_.id AS id_21, i3_.name AS name_22, i3_.original_name AS original_name_23, i3_.mime_type AS mime_type_24, i3_.size AS size_25, i3_.width AS width_26, i3_.height AS height_27, i3_.id AS id_28, i3_.created_at AS created_at_29, i3_.updated_at AS updated_at_30, i4_.title AS title_31, i4_.keywords AS keywords_32, i4_.locale AS locale_33, i4_.id AS id_34, m0_.category_id AS category_id_35, m0_.parent_id AS parent_id_36, c1_.principal_image_id AS principal_image_id_37, c2_.translatable_id AS translatable_id_38, i4_.translatable_id AS translatable_id_39 FROM menu_de m0_ LEFT JOIN category c1_ ON m0_.category_id = c1_.id LEFT JOIN category_translation c2_ ON c1_.id = c2_.translatable_id AND (c2_.locale IN ('de_AT', 'de')) LEFT JOIN image i3_ ON c1_.principal_image_id = i3_.id LEFT JOIN image_translation i4_ ON i3_.id = i4_.translatable_id AND (i4_.locale IN ('de_AT', 'de')) ORDER BY m0_.lft ASC;

#	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 25)
7	App\Menu\MenuBuilder->createMainMenu (line 39)
8	Knp\Menu\Provider\LazyProvider->get (line 26)
9	Knp\Menu\Provider\ChainProvider->get (line 43)
10	Knp\Menu\Twig\Helper->get (line 27)
11	Knp\Menu\Twig\MenuRuntimeExtension->get (line 77)
12	__TwigTemplate_29a6b3f7b8f3bd670371cc8fafa698e3->doDisplay (line 402)
13	Twig\Template->yield (line 67)
14	__TwigTemplate_3eabf437b0c93fc90f000f0b4c141b77->doDisplay (line 402)
15	Twig\Template->yield (line 62)
16	__TwigTemplate_70bae9145458083ada6ee135fb95cf15->doDisplay (line 402)
17	Twig\Template->yield (line 56)
18	__TwigTemplate_2de87966811d427efddabff1f8f66502->doDisplay (line 402)
19	Twig\Template->yield (line 358)
20	Twig\Template->display (line 373)
21	Twig\Template->render (line 51)
22	Twig\TemplateWrapper->render (line 333)
23	Twig\Environment->render (line 34)
24	App\Controller\Content\Category->show (line 181)
25	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
26	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
27	Symfony\Component\HttpKernel\Kernel->handle (line 30)

1.34 ms
(7.47%)

SELECT s0_.name AS name_0, s0_.email AS email_1, s0_.url AS url_2, s0_.country AS country_3, s0_.locale AS locale_4, s0_.currency AS currency_5, s0_.order_base_number AS order_base_number_6, s0_.order_email AS order_email_7, s0_.id AS id_8, s0_.created_at AS created_at_9, s0_.updated_at AS updated_at_10 FROM store s0_ ORDER BY s0_.id ASC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  s0_.name AS name_0,
  s0_.email AS email_1,
  s0_.url AS url_2,
  s0_.country AS country_3,
  s0_.locale AS locale_4,
  s0_.currency AS currency_5,
  s0_.order_base_number AS order_base_number_6,
  s0_.order_email AS order_email_7,
  s0_.id AS id_8,
  s0_.created_at AS created_at_9,
  s0_.updated_at AS updated_at_10
FROM
  store s0_
ORDER BY
  s0_.id ASC

SELECT s0_.name AS name_0, s0_.email AS email_1, s0_.url AS url_2, s0_.country AS country_3, s0_.locale AS locale_4, s0_.currency AS currency_5, s0_.order_base_number AS order_base_number_6, s0_.order_email AS order_email_7, s0_.id AS id_8, s0_.created_at AS created_at_9, s0_.updated_at AS updated_at_10 FROM store s0_ ORDER BY s0_.id ASC;

#	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 36)
7	App\Repository\StoreRepository->findAll (line 56)
8	App\Context\StoreContext->getStores (line 88)
9	App\Context\StoreContext->getStoreByHost (line 44)
10	App\EventSubscriber\ResolveStoreSubscriber->onKernelRequest (line 116)
11	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
12	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
13	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 139)
14	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 157)
15	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
16	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
17	Symfony\Component\HttpKernel\Kernel->handle (line 30)

1.11 ms
(6.19%)

SELECT s0_.id AS id_0, s0_.content_id AS content_id_1, s0_.locale AS locale_2, s0_.slug AS slug_3, s0_.type AS type_4, s0_.previous_slug AS previous_slug_5, s0_.created_at AS created_at_6, s0_.updated_at AS updated_at_7 FROM slug s0_ WHERE s0_.slug = ? AND s0_.locale IN (?, ?)

Parameters:

[
  "gesundes-und-sparsames-heizen"
  "de_AT"
  "de"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  s0_.id AS id_0,
  s0_.content_id AS content_id_1,
  s0_.locale AS locale_2,
  s0_.slug AS slug_3,
  s0_.type AS type_4,
  s0_.previous_slug AS previous_slug_5,
  s0_.created_at AS created_at_6,
  s0_.updated_at AS updated_at_7
FROM
  slug s0_
WHERE
  s0_.slug = ?
  AND s0_.locale IN (?, ?)

SELECT s0_.id AS id_0, s0_.content_id AS content_id_1, s0_.locale AS locale_2, s0_.slug AS slug_3, s0_.type AS type_4, s0_.previous_slug AS previous_slug_5, s0_.created_at AS created_at_6, s0_.updated_at AS updated_at_7 FROM slug s0_ WHERE s0_.slug = 'gesundes-und-sparsames-heizen' AND s0_.locale IN ('de_AT', 'de');

#	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 49)
7	App\Repository\SlugRepository->findOneBySlugAndLocale (line 81)
8	App\Routing\RouteProvider->findSlugsByCandidate (line 36)
9	App\Routing\RouteProvider->getRouteCollectionForRequest (line 97)
10	Symfony\Cmf\Component\Routing\NestedMatcher\NestedMatcher->matchRequest (line 203)
11	Symfony\Cmf\Component\Routing\DynamicRouter->matchRequest (line 69)
12	Symfony\Cmf\Bundle\RoutingBundle\Routing\DynamicRouter->matchRequest (line 161)
13	Symfony\Cmf\Component\Routing\ChainRouter->doMatch (line 134)
14	Symfony\Cmf\Component\Routing\ChainRouter->matchRequest (line 105)
15	Symfony\Component\HttpKernel\EventListener\RouterListener->onKernelRequest (line 116)
16	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
17	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
18	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 139)
19	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 157)
20	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
21	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
22	Symfony\Component\HttpKernel\Kernel->handle (line 30)

0.54 ms
(3.02%)

SELECT t0.position AS position_1, t0.category_id AS category_id_2, t0.image_id AS image_id_3 FROM category_image t0 WHERE t0.category_id = ? ORDER BY t0.position ASC

Parameters:

[
  411
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.position AS position_1,
  t0.category_id AS category_id_2,
  t0.image_id AS image_id_3
FROM
  category_image t0
WHERE
  t0.category_id = ?
ORDER BY
  t0.position ASC

SELECT t0.position AS position_1, t0.category_id AS category_id_2, t0.image_id AS image_id_3 FROM category_image t0 WHERE t0.category_id = 411 ORDER BY t0.position ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1848)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1793)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 2709)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 636)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 186)
6	Doctrine\ORM\PersistentCollection->initialize (line 313)
7	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 273)
8	App\Entity\Category->getImages (line 1909)
9	Twig\Extension\CoreExtension::getAttribute (line 282)
10	__TwigTemplate_70bae9145458083ada6ee135fb95cf15->block_content_title (line 446)
11	Twig\Template->yieldBlock (line 165)
12	__TwigTemplate_70bae9145458083ada6ee135fb95cf15->block_body (line 446)
13	Twig\Template->yieldBlock (line 531)
14	__TwigTemplate_29a6b3f7b8f3bd670371cc8fafa698e3->block_context (line 446)
15	Twig\Template->yieldBlock (line 155)
16	__TwigTemplate_29a6b3f7b8f3bd670371cc8fafa698e3->doDisplay (line 402)
17	Twig\Template->yield (line 67)
18	__TwigTemplate_3eabf437b0c93fc90f000f0b4c141b77->doDisplay (line 402)
19	Twig\Template->yield (line 62)
20	__TwigTemplate_70bae9145458083ada6ee135fb95cf15->doDisplay (line 402)
21	Twig\Template->yield (line 56)
22	__TwigTemplate_2de87966811d427efddabff1f8f66502->doDisplay (line 402)
23	Twig\Template->yield (line 358)
24	Twig\Template->display (line 373)
25	Twig\Template->render (line 51)
26	Twig\TemplateWrapper->render (line 333)
27	Twig\Environment->render (line 34)
28	App\Controller\Content\Category->show (line 181)
29	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
30	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
31	Symfony\Component\HttpKernel\Kernel->handle (line 30)

0.46 ms
(2.55%)

SELECT t0.main_template AS main_template_1, t0.product_template AS product_template_2, t0.filterable AS filterable_3, t0.id AS id_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.principal_image_id AS principal_image_id_7 FROM category t0 WHERE t0.id = ?

Parameters:

[
  411
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.main_template AS main_template_1,
  t0.product_template AS product_template_2,
  t0.filterable AS filterable_3,
  t0.id AS id_4,
  t0.created_at AS created_at_5,
  t0.updated_at AS updated_at_6,
  t0.principal_image_id AS principal_image_id_7
FROM
  category t0
WHERE
  t0.id = ?

SELECT t0.main_template AS main_template_1, t0.product_template AS product_template_2, t0.filterable AS filterable_3, t0.id AS id_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.principal_image_id AS principal_image_id_7 FROM category t0 WHERE t0.id = 411;

#	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 79)
7	App\Repository\SlugRepository->findContent (line 73)
8	App\Routing\RouteProvider->findContent (line 39)
9	App\Routing\RouteProvider->getRouteCollectionForRequest (line 97)
10	Symfony\Cmf\Component\Routing\NestedMatcher\NestedMatcher->matchRequest (line 203)
11	Symfony\Cmf\Component\Routing\DynamicRouter->matchRequest (line 69)
12	Symfony\Cmf\Bundle\RoutingBundle\Routing\DynamicRouter->matchRequest (line 161)
13	Symfony\Cmf\Component\Routing\ChainRouter->doMatch (line 134)
14	Symfony\Cmf\Component\Routing\ChainRouter->matchRequest (line 105)
15	Symfony\Component\HttpKernel\EventListener\RouterListener->onKernelRequest (line 116)
16	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
17	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
18	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 139)
19	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 157)
20	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
21	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
22	Symfony\Component\HttpKernel\Kernel->handle (line 30)

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\CategoryTranslation	205
App\Entity\MenuDe	203
App\Entity\Category	178
App\Entity\Image	143
App\Entity\ImageTranslation	30
App\Entity\Store	6
App\Entity\Slug	1

Entities Mapping

Class	Mapping errors
App\Entity\Store	No errors.
App\Entity\TaxRate	No errors.
App\Entity\Slug	No errors.
App\Entity\Category	No errors.
App\Entity\Image	No errors.
App\Entity\CategoryDocument	No errors.
App\Entity\CategoryImage	No errors.
App\Entity\ProductCategory	No errors.
App\Entity\Product	No errors.
App\Entity\Video	No errors.
App\Search\Entity\CategoryFilter	No errors.
App\Entity\CategoryTranslation	No errors.
App\Entity\Menu	No errors.
App\Entity\MenuDe	No errors.
App\Entity\ImageTranslation	No errors.
App\Entity\ProductImage	No errors.
App\Entity\ProductClassImage	No errors.
App\Entity\ReferenceImage	No errors.
App\Entity\SliderImage	No errors.
App\Entity\VariantImage	No errors.
App\Entity\AttributeOption	No errors.
App\Entity\ProductAttribute	No errors.
App\Entity\ProductClass	No errors.
App\Entity\Reference	No errors.
App\Entity\Variant	No errors.
App\Entity\Document	No errors.
App\Entity\Manufacturer	No errors.
App\Entity\Stock	No errors.
App\Entity\ProductAccessory	No errors.
App\Entity\ProductAdvantage	No errors.
App\Entity\ProductDocument	No errors.
App\Entity\ProductTranslation	No errors.
App\Entity\VideoTranslation	No errors.
App\Search\Entity\Filter	No errors.
App\Entity\Slider	No errors.
App\Entity\Attribute	No errors.
App\Entity\VariantAttribute	No errors.
App\Entity\AttributeOptionTranslation	No errors.
App\Entity\ProductAttributePrice	No errors.
App\Entity\ProductAttributePriceHistory	No errors.
App\Entity\ProductClassTranslation	No errors.
App\Entity\ReferenceTranslation	No errors.

Symfony Profiler

GET https://sandbox.klimapro.at/gesundes-und-sparsames-heizen

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping