Symfony Profiler

Query Metrics

4 Database Queries

4 Different statements

1.35 ms Query time

0 Invalid entities

16 Managed entities

Queries

Group similar statements

#▲

Time

Info

0.36 ms

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.symbol AS symbol_2, c0_.rounding AS rounding_3, c0_.is_default AS is_default_4, c0_.default_locale AS default_locale_5, c0_.is_symbol_left AS is_symbol_left_6, c0_.is_deleted AS is_deleted_7 FROM currency c0_ WHERE c0_.default_locale = ? LIMIT 1

Parameters:

[
  "cs"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.symbol AS symbol_2,
  c0_.rounding AS rounding_3,
  c0_.is_default AS is_default_4,
  c0_.default_locale AS default_locale_5,
  c0_.is_symbol_left AS is_symbol_left_6,
  c0_.is_deleted AS is_deleted_7
FROM
  currency c0_
WHERE
  c0_.default_locale = ?
LIMIT
  1

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.symbol AS symbol_2, c0_.rounding AS rounding_3, c0_.is_default AS is_default_4, c0_.default_locale AS default_locale_5, c0_.is_symbol_left AS is_symbol_left_6, c0_.is_deleted AS is_deleted_7 FROM currency c0_ WHERE c0_.default_locale = 'cs' 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\CurrencyRepository->findCurrencyByLocale (line 31)
7	Greendot\EshopBundle\Service\CurrencyManager->setByLocale (line 70)
8	Greendot\EshopBundle\Service\CurrencyManager->setLocale (line 96)
9	Symfony\Component\Translation\LocaleSwitcher->setLocale (line 49)
10	Symfony\Component\HttpKernel\EventListener\LocaleAwareListener->setLocale (line 68)
11	Symfony\Component\HttpKernel\EventListener\LocaleAwareListener->onKernelRequest (line 39)
12	Greendot\EshopBundle\EventSubscriber\Decorated\LocaleAwareListenerDecorator->onKernelRequest (line 26)
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\Kernel->handle (line 193)
20	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
21	require_once (line 29)
22	require_once (line 5)

0.32 ms

SELECT count(DISTINCT p0_.id) AS sclr_0 FROM producer p0_ LEFT JOIN upload u1_ ON p0_.upload_id = u1_.id

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  count(DISTINCT p0_.id) AS sclr_0
FROM
  producer p0_
  LEFT JOIN upload u1_ ON p0_.upload_id = u1_.id

SELECT count(DISTINCT p0_.id) AS sclr_0 FROM producer p0_ LEFT JOIN upload u1_ ON p0_.upload_id = u1_.id;

#	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->getScalarResult (line 724)
6	Doctrine\ORM\Tools\Pagination\Paginator->count (line 96)
7	ApiPlatform\Doctrine\Orm\Paginator->getTotalItems (line 49)
8	ApiPlatform\Hydra\Serializer\CollectionNormalizer->getPaginationData (line 64)
9	ApiPlatform\Serializer\AbstractCollectionNormalizer->normalize (line 87)
10	ApiPlatform\Hydra\Serializer\PartialCollectionViewNormalizer->normalize (line 55)
11	ApiPlatform\Hydra\Serializer\CollectionFiltersNormalizer->normalize (line 80)
12	Symfony\Component\Serializer\Debug\TraceableNormalizer->normalize (line 50)
13	Symfony\Component\Serializer\Serializer->normalize (line 152)
14	Symfony\Component\Serializer\Serializer->serialize (line 131)
15	Symfony\Component\Serializer\Debug\TraceableSerializer->serialize (line 44)
16	ApiPlatform\State\Processor\SerializeProcessor->process (line 85)
17	ApiPlatform\State\Processor\WriteProcessor->process (line 54)
18	ApiPlatform\Symfony\Controller\MainController->__invoke (line 125)
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.36 ms

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.menu_name AS menu_name_2, p0_.title AS title_3, p0_.description AS description_4, p0_.html AS html_5, p0_.is_menu AS is_menu_6, p0_.slug AS slug_7, u1_.id AS id_8, u1_.name AS name_9, u1_.extension AS extension_10, u1_.mime AS mime_11, u1_.title AS title_12, u1_.short_description AS short_description_13, u1_.description AS description_14, u1_.created AS created_15, u1_.path AS path_16, u1_.original_name AS original_name_17, u1_.width AS width_18, u1_.height AS height_19, u1_.sequence AS sequence_20, u1_.restriction AS restriction_21, p0_.upload_id AS upload_id_22, u1_.upload_group_id AS upload_group_id_23, u1_.upload_type_id AS upload_type_id_24 FROM producer p0_ LEFT JOIN upload u1_ ON p0_.upload_id = u1_.id ORDER BY p0_.id ASC LIMIT 30

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.id AS id_0,
  p0_.name AS name_1,
  p0_.menu_name AS menu_name_2,
  p0_.title AS title_3,
  p0_.description AS description_4,
  p0_.html AS html_5,
  p0_.is_menu AS is_menu_6,
  p0_.slug AS slug_7,
  u1_.id AS id_8,
  u1_.name AS name_9,
  u1_.extension AS extension_10,
  u1_.mime AS mime_11,
  u1_.title AS title_12,
  u1_.short_description AS short_description_13,
  u1_.description AS description_14,
  u1_.created AS created_15,
  u1_.path AS path_16,
  u1_.original_name AS original_name_17,
  u1_.width AS width_18,
  u1_.height AS height_19,
  u1_.sequence AS sequence_20,
  u1_.restriction AS restriction_21,
  p0_.upload_id AS upload_id_22,
  u1_.upload_group_id AS upload_group_id_23,
  u1_.upload_type_id AS upload_type_id_24
FROM
  producer p0_
  LEFT JOIN upload u1_ ON p0_.upload_id = u1_.id
ORDER BY
  p0_.id ASC
LIMIT
  30

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.menu_name AS menu_name_2, p0_.title AS title_3, p0_.description AS description_4, p0_.html AS html_5, p0_.is_menu AS is_menu_6, p0_.slug AS slug_7, u1_.id AS id_8, u1_.name AS name_9, u1_.extension AS extension_10, u1_.mime AS mime_11, u1_.title AS title_12, u1_.short_description AS short_description_13, u1_.description AS description_14, u1_.created AS created_15, u1_.path AS path_16, u1_.original_name AS original_name_17, u1_.width AS width_18, u1_.height AS height_19, u1_.sequence AS sequence_20, u1_.restriction AS restriction_21, p0_.upload_id AS upload_id_22, u1_.upload_group_id AS upload_group_id_23, u1_.upload_type_id AS upload_type_id_24 FROM producer p0_ LEFT JOIN upload u1_ ON p0_.upload_id = u1_.id ORDER BY p0_.id ASC LIMIT 30;

#	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->getResult (line 688)
6	Doctrine\ORM\Tools\Pagination\Paginator->getIterator (line 151)
7	ApiPlatform\Doctrine\Orm\AbstractPaginator->getIterator (line 69)
8	ApiPlatform\Hydra\Serializer\CollectionNormalizer->getItemsData (line 83)
9	ApiPlatform\Serializer\AbstractCollectionNormalizer->normalize (line 94)
10	ApiPlatform\Hydra\Serializer\PartialCollectionViewNormalizer->normalize (line 55)
11	ApiPlatform\Hydra\Serializer\CollectionFiltersNormalizer->normalize (line 80)
12	Symfony\Component\Serializer\Debug\TraceableNormalizer->normalize (line 50)
13	Symfony\Component\Serializer\Serializer->normalize (line 152)
14	Symfony\Component\Serializer\Serializer->serialize (line 131)
15	Symfony\Component\Serializer\Debug\TraceableSerializer->serialize (line 44)
16	ApiPlatform\State\Processor\SerializeProcessor->process (line 85)
17	ApiPlatform\State\Processor\WriteProcessor->process (line 54)
18	ApiPlatform\Symfony\Controller\MainController->__invoke (line 125)
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.32 ms

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::getPurchasePriceFactoryService (line 2361)
11	ContainerXoUkwCr\App_KernelDevDebugContainer::getAffiliateServiceService (line 1734)
12	ContainerXoUkwCr\App_KernelDevDebugContainer::getAffiliateOrderEventSubscriberService (line 1712)
13	ContainerXoUkwCr\App_KernelDevDebugContainer::ContainerXoUkwCr\{closure} (line 1326)
14	Symfony\Component\EventDispatcher\EventDispatcher::sortListeners (line 221)
15	Symfony\Component\EventDispatcher\EventDispatcher->getListeners (line 70)
16	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->preProcess (line 256)
17	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 120)
18	Symfony\Component\HttpKernel\HttpKernel->filterResponse (line 216)
19	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 204)
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)

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\Producer	6
Greendot\EshopBundle\Entity\Project\Upload	6
Greendot\EshopBundle\Entity\Project\UploadGroup	2
Greendot\EshopBundle\Entity\Project\Currency	1
Greendot\EshopBundle\Entity\Project\UploadType	1

Entities Mapping

Class	Mapping errors
Greendot\EshopBundle\Entity\Project\Currency	No errors.
Greendot\EshopBundle\Entity\Project\ConversionRate	No errors.
Greendot\EshopBundle\Entity\Project\Producer	No errors.
Greendot\EshopBundle\Entity\Project\Upload	No errors.
Greendot\EshopBundle\Entity\Project\UploadGroup	No errors.
Greendot\EshopBundle\Entity\Project\UploadType	No errors.
Greendot\EshopBundle\Entity\Project\Product	No errors.
Greendot\EshopBundle\Entity\Project\ProducerUploadGroup	No errors.
Greendot\EshopBundle\Entity\Project\ProductVariant	No errors.
Greendot\EshopBundle\Entity\Project\Category	No errors.
Greendot\EshopBundle\Entity\Project\Person	No errors.
Greendot\EshopBundle\Entity\Project\InformationBlock	No errors.
Greendot\EshopBundle\Entity\Project\Settings	No errors.

Symfony Profiler

GET https://proklima.greendot.cz/api/producers?category_id%253D461%3D=

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping