Symfony Profiler

Query Metrics

3 Database Queries

3 Different statements

2.12 ms Query time

0 Invalid entities

0 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

1.55 ms
(73.09%)

SELECT e0_.foreign_key AS foreign_key_0 FROM ext_translations e0_ WHERE e0_.locale = ? AND e0_.object_class = ? AND e0_.field = ? AND e0_.content = ? LIMIT 1

Parameters:

[
  "cs"
  "Greendot\EshopBundle\Entity\Project\Producer"
  "slug"
  "1"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  e0_.foreign_key AS foreign_key_0
FROM
  ext_translations e0_
WHERE
  e0_.locale = ?
  AND e0_.object_class = ?
  AND e0_.field = ?
  AND e0_.content = ?
LIMIT
  1

SELECT e0_.foreign_key AS foreign_key_0 FROM ext_translations e0_ WHERE e0_.locale = 'cs' AND e0_.object_class = 'Greendot\\EshopBundle\\Entity\\Project\\Producer' AND e0_.field = 'slug' AND e0_.content = '1' 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\HintedRepositoryBase->findIdInTranslations (line 83)
7	Greendot\EshopBundle\Repository\HintedRepositoryBase->findOneByHinted (line 44)
8	Greendot\EshopBundle\I18n\TranslatedEntityValueResolver->resolve (line 48)
9	Symfony\Component\HttpKernel\Controller\ArgumentResolver\TraceableValueResolver->resolve (line 37)
10	Symfony\Component\HttpKernel\Controller\ArgumentResolver->getArguments (line 91)
11	Symfony\Component\HttpKernel\Controller\TraceableArgumentResolver->getArguments (line 33)
12	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 175)
13	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
14	Symfony\Component\HttpKernel\Kernel->handle (line 193)
15	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
16	require_once (line 29)
17	require_once (line 5)

0.29 ms
(13.91%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.menu_name AS menu_name_3, t0.title AS title_4, t0.description AS description_5, t0.html AS html_6, t0.is_menu AS is_menu_7, t0.slug AS slug_8, t0.upload_id AS upload_id_9 FROM producer t0 WHERE t0.slug = ? LIMIT 1

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.menu_name AS menu_name_3,
  t0.title AS title_4,
  t0.description AS description_5,
  t0.html AS html_6,
  t0.is_menu AS is_menu_7,
  t0.slug AS slug_8,
  t0.upload_id AS upload_id_9
FROM
  producer t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.menu_name AS menu_name_3, t0.title AS title_4, t0.description AS description_5, t0.html AS html_6, t0.is_menu AS is_menu_7, t0.slug AS slug_8, t0.upload_id AS upload_id_9 FROM producer t0 WHERE t0.slug = '1' 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	Greendot\EshopBundle\Repository\HintedRepositoryBase->findOneByHinted (line 52)
5	Greendot\EshopBundle\I18n\TranslatedEntityValueResolver->resolve (line 48)
6	Symfony\Component\HttpKernel\Controller\ArgumentResolver\TraceableValueResolver->resolve (line 37)
7	Symfony\Component\HttpKernel\Controller\ArgumentResolver->getArguments (line 91)
8	Symfony\Component\HttpKernel\Controller\TraceableArgumentResolver->getArguments (line 33)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 175)
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)

0.28 ms
(13.01%)

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	ContainerXoUkwCr\App_KernelDevDebugContainer::get_Container_Private_ProfilerService (line 919)
13	ContainerXoUkwCr\App_KernelDevDebugContainer::getProfilerListenerService (line 4115)
14	ContainerXoUkwCr\App_KernelDevDebugContainer::ContainerXoUkwCr\{closure} (line 1295)
15	Symfony\Component\EventDispatcher\EventDispatcher::sortListeners (line 221)
16	Symfony\Component\EventDispatcher\EventDispatcher->getListeners (line 70)
17	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->preProcess (line 256)
18	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 120)
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	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

Entities Mapping

Class	Mapping errors
Greendot\EshopBundle\Entity\Project\Producer	No errors.
Gedmo\Translatable\Entity\MappedSuperclass\AbstractTranslation	No errors.
Gedmo\Translatable\Entity\Translation	No errors.
Greendot\EshopBundle\Entity\Project\Upload	No errors.
Greendot\EshopBundle\Entity\Project\Settings	No errors.
Greendot\EshopBundle\Entity\Project\Product	No errors.
Greendot\EshopBundle\Entity\Project\ProducerUploadGroup	No errors.
Greendot\EshopBundle\Entity\Project\UploadGroup	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\UploadType	No errors.
Greendot\EshopBundle\Entity\Project\InformationBlock	No errors.

Symfony Profiler

GET http://proklima.greendot.cz/dodavatele/1

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping