Symfony Profiler

Query Metrics

6 Database Queries

6 Different statements

1.90 ms Query time

0 Invalid entities

6 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

0.40 ms
(21.20%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.menu_name AS menu_name_3, t0.description AS description_4, t0.title AS title_5, t0.slug AS slug_6, t0.is_active AS is_active_7, t0.is_visible AS is_visible_8, t0.sequence AS sequence_9, t0.javascript AS javascript_10, t0.text_general AS text_general_11, t0.state AS state_12, t0.external_id AS external_id_13, t0.is_indexable AS is_indexable_14, t0.meta_description AS meta_description_15, t0.has_variant_picture AS has_variant_picture_16, t0.sold_amount AS sold_amount_17, t0.additional_data AS additional_data_18, t0.is_deleted AS is_deleted_19, t0.producer_id AS producer_id_20, t0.upload_id AS upload_id_21, t0.product_type_id AS product_type_id_22, t0.product_view_type_id AS product_view_type_id_23 FROM product t0 WHERE t0.id = ? AND ((t0.is_active = true)) LIMIT 1

Parameters:

[
  "2&amp&amp"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.menu_name AS menu_name_3,
  t0.description AS description_4,
  t0.title AS title_5,
  t0.slug AS slug_6,
  t0.is_active AS is_active_7,
  t0.is_visible AS is_visible_8,
  t0.sequence AS sequence_9,
  t0.javascript AS javascript_10,
  t0.text_general AS text_general_11,
  t0.state AS state_12,
  t0.external_id AS external_id_13,
  t0.is_indexable AS is_indexable_14,
  t0.meta_description AS meta_description_15,
  t0.has_variant_picture AS has_variant_picture_16,
  t0.sold_amount AS sold_amount_17,
  t0.additional_data AS additional_data_18,
  t0.is_deleted AS is_deleted_19,
  t0.producer_id AS producer_id_20,
  t0.upload_id AS upload_id_21,
  t0.product_type_id AS product_type_id_22,
  t0.product_view_type_id AS product_view_type_id_23
FROM
  product t0
WHERE
  t0.id = ?
  AND (
    (t0.is_active = true)
  )
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.menu_name AS menu_name_3, t0.description AS description_4, t0.title AS title_5, t0.slug AS slug_6, t0.is_active AS is_active_7, t0.is_visible AS is_visible_8, t0.sequence AS sequence_9, t0.javascript AS javascript_10, t0.text_general AS text_general_11, t0.state AS state_12, t0.external_id AS external_id_13, t0.is_indexable AS is_indexable_14, t0.meta_description AS meta_description_15, t0.has_variant_picture AS has_variant_picture_16, t0.sold_amount AS sold_amount_17, t0.additional_data AS additional_data_18, t0.is_deleted AS is_deleted_19, t0.producer_id AS producer_id_20, t0.upload_id AS upload_id_21, t0.product_type_id AS product_type_id_22, t0.product_view_type_id AS product_view_type_id_23 FROM product t0 WHERE t0.id = '2&amp&amp' AND ((t0.is_active = true)) LIMIT 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\EntityRepository->findOneBy (line 125)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 81)
4	Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->resolve (line 79)
5	Symfony\Component\HttpKernel\Controller\ArgumentResolver\TraceableValueResolver->resolve (line 37)
6	Symfony\Component\HttpKernel\Controller\ArgumentResolver->getArguments (line 91)
7	Symfony\Component\HttpKernel\Controller\TraceableArgumentResolver->getArguments (line 33)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 175)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 193)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
12	require_once (line 29)
13	require_once (line 5)

0.35 ms
(18.25%)

SELECT a0_.id AS id_0, a0_.name AS name_1, a0_.description AS description_2, a0_.class AS class_3, a0_.is_purchasable AS is_purchasable_4, a0_.sequence AS sequence_5 FROM availability a0_ LEFT JOIN product_variant p1_ ON a0_.id = p1_.availability_id AND (p1_.is_active = true) WHERE p1_.product_id = ? ORDER BY a0_.sequence ASC LIMIT 1

Parameters:

[
  2
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  a0_.id AS id_0,
  a0_.name AS name_1,
  a0_.description AS description_2,
  a0_.class AS class_3,
  a0_.is_purchasable AS is_purchasable_4,
  a0_.sequence AS sequence_5
FROM
  availability a0_
  LEFT JOIN product_variant p1_ ON a0_.id = p1_.availability_id
  AND (p1_.is_active = true)
WHERE
  p1_.product_id = ?
ORDER BY
  a0_.sequence ASC
LIMIT
  1

SELECT a0_.id AS id_0, a0_.name AS name_1, a0_.description AS description_2, a0_.class AS class_3, a0_.is_purchasable AS is_purchasable_4, a0_.sequence AS sequence_5 FROM availability a0_ LEFT JOIN product_variant p1_ ON a0_.id = p1_.availability_id AND (p1_.is_active = true) WHERE p1_.product_id = 2 ORDER BY a0_.sequence ASC LIMIT 1;

#	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	Greendot\EshopBundle\Repository\Project\AvailabilityRepository->getAvailabilityForProduct (line 55)
7	Greendot\EshopBundle\EventSubscriber\ProductEventListener->postLoad (line 34)
8	Doctrine\ORM\Event\ListenersInvoker->invoke (line 90)
9	Doctrine\ORM\Internal\HydrationCompleteHandler->hydrationComplete (line 55)
10	Doctrine\ORM\UnitOfWork->hydrationComplete (line 3214)
11	Doctrine\ORM\Internal\Hydration\SimpleObjectHydrator->cleanup (line 49)
12	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 178)
13	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 746)
14	Doctrine\ORM\EntityRepository->findOneBy (line 125)
15	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 81)
16	Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->resolve (line 79)
17	Symfony\Component\HttpKernel\Controller\ArgumentResolver\TraceableValueResolver->resolve (line 37)
18	Symfony\Component\HttpKernel\Controller\ArgumentResolver->getArguments (line 91)
19	Symfony\Component\HttpKernel\Controller\TraceableArgumentResolver->getArguments (line 33)
20	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 175)
21	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
22	Symfony\Component\HttpKernel\Kernel->handle (line 193)
23	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
24	require_once (line 29)
25	require_once (line 5)

0.33 ms
(17.67%)

SELECT p0_.data AS data_0, p1_.name AS name_1 FROM parameter p0_ LEFT JOIN product_variant p2_ ON p0_.product_variant_id = p2_.id AND (p2_.is_active = true) LEFT JOIN parameter_group p1_ ON p0_.parameter_group_id = p1_.id WHERE p2_.product_id = ?

Parameters:

[
  2
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.data AS data_0,
  p1_.name AS name_1
FROM
  parameter p0_
  LEFT JOIN product_variant p2_ ON p0_.product_variant_id = p2_.id
  AND (p2_.is_active = true)
  LEFT JOIN parameter_group p1_ ON p0_.parameter_group_id = p1_.id
WHERE
  p2_.product_id = ?

SELECT p0_.data AS data_0, p1_.name AS name_1 FROM parameter p0_ LEFT JOIN product_variant p2_ ON p0_.product_variant_id = p2_.id AND (p2_.is_active = true) LEFT JOIN parameter_group p1_ ON p0_.parameter_group_id = p1_.id WHERE p2_.product_id = 2;

#	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->getArrayResult (line 700)
6	Greendot\EshopBundle\Repository\Project\ProductRepository->calculateParameters (line 95)
7	Greendot\EshopBundle\EventSubscriber\ProductEventListener->postLoad (line 35)
8	Doctrine\ORM\Event\ListenersInvoker->invoke (line 90)
9	Doctrine\ORM\Internal\HydrationCompleteHandler->hydrationComplete (line 55)
10	Doctrine\ORM\UnitOfWork->hydrationComplete (line 3214)
11	Doctrine\ORM\Internal\Hydration\SimpleObjectHydrator->cleanup (line 49)
12	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 178)
13	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 746)
14	Doctrine\ORM\EntityRepository->findOneBy (line 125)
15	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 81)
16	Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->resolve (line 79)
17	Symfony\Component\HttpKernel\Controller\ArgumentResolver\TraceableValueResolver->resolve (line 37)
18	Symfony\Component\HttpKernel\Controller\ArgumentResolver->getArguments (line 91)
19	Symfony\Component\HttpKernel\Controller\TraceableArgumentResolver->getArguments (line 33)
20	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 175)
21	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
22	Symfony\Component\HttpKernel\Kernel->handle (line 193)
23	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
24	require_once (line 29)
25	require_once (line 5)

0.28 ms
(14.56%)

SELECT s0_.value AS value_0 FROM settings s0_ WHERE s0_.name = ? ORDER BY s0_.name ASC LIMIT 1

Parameters:

[
  "after_registration_discount"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  s0_.value AS value_0
FROM
  settings s0_
WHERE
  s0_.name = ?
ORDER BY
  s0_.name ASC
LIMIT
  1

SELECT s0_.value AS value_0 FROM settings s0_ WHERE s0_.name = 'after_registration_discount' ORDER BY s0_.name ASC LIMIT 1;

#	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->getSingleResult (line 772)
6	Doctrine\ORM\AbstractQuery->getSingleScalarResult (line 801)
7	Greendot\EshopBundle\Repository\Project\SettingsRepository->findParameterValueWithName (line 55)
8	Greendot\EshopBundle\Service\Price\ProductVariantPriceFactory->__construct (line 41)
9	ContainerXoUkwCr\App_KernelDevDebugContainer->getProductVariantPriceFactoryService (line 2339)
10	ContainerXoUkwCr\App_KernelDevDebugContainer::getCalculatedPricesServiceService (line 2296)
11	ContainerXoUkwCr\App_KernelDevDebugContainer::getTwigService (line 4637)
12	Symfony\Component\DependencyInjection\Container::getService (line 399)
13	Symfony\Component\DependencyInjection\Argument\ServiceLocator->get (line 36)
14	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 463)
15	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 468)
16	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 282)
17	Greendot\EshopBundle\Controller\FragmentController->renderAssistantBox (line 147)
18	Greendot\EshopBundle\Controller\FragmentController->fragmentAssistantBoxProduct (line 138)
19	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
20	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
21	Symfony\Component\HttpKernel\Kernel->handle (line 193)
22	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
23	require_once (line 29)
24	require_once (line 5)

0.27 ms
(14.35%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.symbol AS symbol_3, t0.rounding AS rounding_4, t0.is_default AS is_default_5, t0.default_locale AS default_locale_6, t0.is_symbol_left AS is_symbol_left_7, t0.is_deleted AS is_deleted_8 FROM currency t0 WHERE t0.id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.symbol AS symbol_3,
  t0.rounding AS rounding_4,
  t0.is_default AS is_default_5,
  t0.default_locale AS default_locale_6,
  t0.is_symbol_left AS is_symbol_left_7,
  t0.is_deleted AS is_deleted_8
FROM
  currency t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.symbol AS symbol_3, t0.rounding AS rounding_4, t0.is_default AS is_default_5, t0.default_locale AS default_locale_6, t0.is_symbol_left AS is_symbol_left_7, t0.is_deleted AS is_deleted_8 FROM currency t0 WHERE t0.id = 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
3	Doctrine\ORM\EntityManager->find (line 366)
4	Doctrine\ORM\EntityRepository->find (line 86)
5	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->find (line 61)
6	Greendot\EshopBundle\Service\CurrencyManager->get (line 41)
7	Greendot\EshopBundle\EventSubscriber\ProductEventListener->postLoad (line 33)
8	Doctrine\ORM\Event\ListenersInvoker->invoke (line 90)
9	Doctrine\ORM\Internal\HydrationCompleteHandler->hydrationComplete (line 55)
10	Doctrine\ORM\UnitOfWork->hydrationComplete (line 3214)
11	Doctrine\ORM\Internal\Hydration\SimpleObjectHydrator->cleanup (line 49)
12	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 178)
13	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 746)
14	Doctrine\ORM\EntityRepository->findOneBy (line 125)
15	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 81)
16	Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->resolve (line 79)
17	Symfony\Component\HttpKernel\Controller\ArgumentResolver\TraceableValueResolver->resolve (line 37)
18	Symfony\Component\HttpKernel\Controller\ArgumentResolver->getArguments (line 91)
19	Symfony\Component\HttpKernel\Controller\TraceableArgumentResolver->getArguments (line 33)
20	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 175)
21	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
22	Symfony\Component\HttpKernel\Kernel->handle (line 193)
23	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
24	require_once (line 29)
25	require_once (line 5)

0.26 ms
(13.97%)

SELECT t0.id AS id_1, t0.sequence AS sequence_2, t0.product_id AS product_id_3, t0.person_id AS person_id_4 FROM product_person t0 WHERE t0.product_id = ?

Parameters:

[
  2
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.sequence AS sequence_2,
  t0.product_id AS product_id_3,
  t0.person_id AS person_id_4
FROM
  product_person t0
WHERE
  t0.product_id = ?

SELECT t0.id AS id_1, t0.sequence AS sequence_2, t0.product_id AS product_id_3, t0.person_id AS person_id_4 FROM product_person t0 WHERE t0.product_id = 2;

#	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 2733)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->count (line 41)
7	Doctrine\ORM\PersistentCollection->count (line 391)
8	Greendot\EshopBundle\Controller\FragmentController->fragmentAssistantBoxProduct (line 134)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
11	Symfony\Component\HttpKernel\Kernel->handle (line 193)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
13	require_once (line 29)
14	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
Greendot\EshopBundle\Entity\Project\Product	1
Greendot\EshopBundle\Entity\Project\Producer	1
Greendot\EshopBundle\Entity\Project\Upload	1
Greendot\EshopBundle\Entity\Project\ProductViewType	1
Greendot\EshopBundle\Entity\Project\Currency	1
Greendot\EshopBundle\Entity\Project\Availability	1

Entities Mapping

Class	Mapping errors
Greendot\EshopBundle\Entity\Project\Product	No errors.
Greendot\EshopBundle\Entity\Project\Producer	No errors.
Greendot\EshopBundle\Entity\Project\Upload	No errors.
Greendot\EshopBundle\Entity\Project\ProductType	No errors.
Greendot\EshopBundle\Entity\Project\ProductViewType	No errors.
Greendot\EshopBundle\Entity\Project\ProductVariant	No errors.
Greendot\EshopBundle\Entity\Project\Review	No errors.
Greendot\EshopBundle\Entity\Project\CategoryProduct	No errors.
Greendot\EshopBundle\Entity\Project\ProductUploadGroup	No errors.
Greendot\EshopBundle\Entity\Project\ProductPerson	No errors.
Greendot\EshopBundle\Entity\Project\Label	No errors.
Greendot\EshopBundle\Entity\Project\ProductParameterGroup	No errors.
Greendot\EshopBundle\Entity\Project\ProductProduct	No errors.
Greendot\EshopBundle\Entity\Project\Comment	No errors.
Greendot\EshopBundle\Entity\Project\ProductInformationBlock	No errors.
Greendot\EshopBundle\Entity\Project\Currency	No errors.
Greendot\EshopBundle\Entity\Project\ConversionRate	No errors.
Greendot\EshopBundle\Entity\Project\Availability	No errors.
Greendot\EshopBundle\Entity\Project\Parameter	No errors.
Greendot\EshopBundle\Entity\Project\ParameterGroup	No errors.
Greendot\EshopBundle\Entity\Project\Person	No errors.
Greendot\EshopBundle\Entity\Project\Settings	No errors.

Symfony Profiler

GET https://proklima.greendot.cz/_assistant-box/product-2&amp&amp

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping