Symfony Profiler

Query Metrics

4 Database Queries

4 Different statements

0.44 ms Query time

0 Invalid entities

3 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

0.15 ms
(33.35%)

SELECT h0_.id AS id_0, h0_.hero_image AS hero_image_1, h0_.hero_button_label AS hero_button_label_2, h0_.hero_button_link AS hero_button_link_3, h0_.hp_nc AS hp_nc_4, h0_.image_size AS image_size_5, h0_.overlay AS overlay_6, h0_.auto_scroll_time AS auto_scroll_time_7, h0_.created_at AS created_at_8, h0_.updated_at AS updated_at_9, h0_.site_id AS site_id_10, h0_.created_by_id AS created_by_id_11, h0_.updated_by_id AS updated_by_id_12, h0_.deleted_by_id AS deleted_by_id_13 FROM home_config h0_ WHERE h0_.hp_nc = 1 AND h0_.site_id IS NULL LIMIT 1

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  h0_.id AS id_0,
  h0_.hero_image AS hero_image_1,
  h0_.hero_button_label AS hero_button_label_2,
  h0_.hero_button_link AS hero_button_link_3,
  h0_.hp_nc AS hp_nc_4,
  h0_.image_size AS image_size_5,
  h0_.overlay AS overlay_6,
  h0_.auto_scroll_time AS auto_scroll_time_7,
  h0_.created_at AS created_at_8,
  h0_.updated_at AS updated_at_9,
  h0_.site_id AS site_id_10,
  h0_.created_by_id AS created_by_id_11,
  h0_.updated_by_id AS updated_by_id_12,
  h0_.deleted_by_id AS deleted_by_id_13
FROM
  home_config h0_
WHERE
  h0_.hp_nc = 1
  AND h0_.site_id IS NULL
LIMIT
  1

SELECT h0_.id AS id_0, h0_.hero_image AS hero_image_1, h0_.hero_button_label AS hero_button_label_2, h0_.hero_button_link AS hero_button_link_3, h0_.hp_nc AS hp_nc_4, h0_.image_size AS image_size_5, h0_.overlay AS overlay_6, h0_.auto_scroll_time AS auto_scroll_time_7, h0_.created_at AS created_at_8, h0_.updated_at AS updated_at_9, h0_.site_id AS site_id_10, h0_.created_by_id AS created_by_id_11, h0_.updated_by_id AS updated_by_id_12, h0_.deleted_by_id AS deleted_by_id_13 FROM home_config h0_ WHERE h0_.hp_nc = 1 AND h0_.site_id IS NULL LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeCacheQuery (line 851)
2	Doctrine\DBAL\Connection->executeQuery (line 789)
3	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
4	Doctrine\ORM\Query->_doExecute (line 296)
5	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
6	Doctrine\ORM\AbstractQuery->execute (line 886)
7	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 737)
8	App\Repository\HomeConfigRepository->findOneConfigHpNc (line 53)
9	App\Service\HeroService->getActualHero (line 25)
10	Twig\Extension\CoreExtension->getAttribute (line 1919)
11	__TwigTemplate_81386e2f228ff3a5f54af9189651a8f4::doDisplay (line 55)
12	Twig\Template->yield (line 402)
13	__TwigTemplate_b080c2ce533445a3b2a2d0abc05ef307->doDisplay (line 53)
14	Twig\Template->yield (line 402)
15	Twig\Template->display (line 358)
16	Twig\Template->render (line 373)
17	Twig\TemplateWrapper->render (line 51)
18	Twig\Environment->render (line 333)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 462)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 467)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 279)
22	App\Controller\SecurityController->login (line 215)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
25	Symfony\Component\HttpKernel\Kernel->handle (line 191)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
27	require_once (line 32)
28	require_once (line 5)

0.12 ms
(26.28%)

SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.slug AS slug_2, s0_.description AS description_3, s0_.image_name AS image_name_4, s0_.image_size AS image_size_5, s0_.image_dark_name AS image_dark_name_6, s0_.image_dark_size AS image_dark_size_7, s0_.active AS active_8, s0_.position AS position_9, s0_.roles_hide AS roles_hide_10, s0_.created_at AS created_at_11, s0_.updated_at AS updated_at_12 FROM site s0_ WHERE s0_.active = ? ORDER BY s0_.position ASC

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  s0_.id AS id_0,
  s0_.name AS name_1,
  s0_.slug AS slug_2,
  s0_.description AS description_3,
  s0_.image_name AS image_name_4,
  s0_.image_size AS image_size_5,
  s0_.image_dark_name AS image_dark_name_6,
  s0_.image_dark_size AS image_dark_size_7,
  s0_.active AS active_8,
  s0_.position AS position_9,
  s0_.roles_hide AS roles_hide_10,
  s0_.created_at AS created_at_11,
  s0_.updated_at AS updated_at_12
FROM
  site s0_
WHERE
  s0_.active = ?
ORDER BY
  s0_.position ASC

SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.slug AS slug_2, s0_.description AS description_3, s0_.image_name AS image_name_4, s0_.image_size AS image_size_5, s0_.image_dark_name AS image_dark_name_6, s0_.image_dark_size AS image_dark_size_7, s0_.active AS active_8, s0_.position AS position_9, s0_.roles_hide AS roles_hide_10, s0_.created_at AS created_at_11, s0_.updated_at AS updated_at_12 FROM site s0_ WHERE s0_.active = 1 ORDER BY s0_.position ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeCacheQuery (line 851)
2	Doctrine\DBAL\Connection->executeQuery (line 789)
3	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
4	Doctrine\ORM\Query->_doExecute (line 296)
5	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
6	Doctrine\ORM\AbstractQuery->execute (line 886)
7	Doctrine\ORM\AbstractQuery->getResult (line 688)
8	App\Repository\SiteRepository->findAllWithOrder (line 31)
9	App\Service\SelectedSiteContext->getAllActiveSites (line 37)
10	App\EventListener\SiteSlugListener->onKernelRequest (line 38)
11	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
12	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
13	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
14	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
15	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
16	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
17	Symfony\Component\HttpKernel\Kernel->handle (line 191)
18	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
19	require_once (line 32)
20	require_once (line 5)

0.10 ms
(22.36%)

SELECT t0.id AS id_1, t0.hero_title AS hero_title_2, t0.hero_text AS hero_text_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5 FROM home_config_translation t0 WHERE t0.translatable_id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.hero_title AS hero_title_2,
  t0.hero_text AS hero_text_3,
  t0.locale AS locale_4,
  t0.translatable_id AS translatable_id_5
FROM
  home_config_translation t0
WHERE
  t0.translatable_id = ?

SELECT t0.id AS id_1, t0.hero_title AS hero_title_2, t0.hero_text AS hero_text_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5 FROM home_config_translation t0 WHERE t0.translatable_id = 1;

#	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->get (line 120)
7	Doctrine\ORM\PersistentCollection->get (line 380)
8	App\Entity\HomeConfig->findTranslationByLocale (line 190)
9	App\Entity\HomeConfig->doTranslate (line 138)
10	App\Entity\HomeConfig->translate (line 75)
11	App\Entity\HomeConfig->proxyCurrentLocaleTranslation (line 179)
12	App\Entity\HomeConfig->getHeroTitle (line 107)
13	Twig\Extension\CoreExtension->getAttribute (line 1919)
14	__TwigTemplate_81386e2f228ff3a5f54af9189651a8f4::block_header (line 137)
15	Twig\Template->yieldBlock (line 446)
16	__TwigTemplate_074ef6e31559566e511b93bee248ce08->doDisplay (line 241)
17	Twig\Template->yield (line 402)
18	__TwigTemplate_81386e2f228ff3a5f54af9189651a8f4->doDisplay (line 66)
19	Twig\Template->yield (line 402)
20	__TwigTemplate_b080c2ce533445a3b2a2d0abc05ef307->doDisplay (line 53)
21	Twig\Template->yield (line 402)
22	Twig\Template->display (line 358)
23	Twig\Template->render (line 373)
24	Twig\TemplateWrapper->render (line 51)
25	Twig\Environment->render (line 333)
26	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 462)
27	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 467)
28	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 279)
29	App\Controller\SecurityController->login (line 215)
30	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
31	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
32	Symfony\Component\HttpKernel\Kernel->handle (line 191)
33	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
34	require_once (line 32)
35	require_once (line 5)

0.08 ms
(18.01%)

SELECT t0.id AS id_1, t0.code AS code_2, t0.locales AS locales_3, t0.automatic AS automatic_4 FROM access_code t0 WHERE t0.automatic = ? LIMIT 1

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.locales AS locales_3,
  t0.automatic AS automatic_4
FROM
  access_code t0
WHERE
  t0.automatic = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.code AS code_2, t0.locales AS locales_3, t0.automatic AS automatic_4 FROM access_code t0 WHERE t0.automatic = 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\ServiceEntityRepository->findOneBy (line 86)
4	App\Controller\SecurityController->getAccessCodeSession (line 75)
5	App\Controller\SecurityController->login (line 176)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
8	Symfony\Component\HttpKernel\Kernel->handle (line 191)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
10	require_once (line 32)
11	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
App\Entity\HomeConfig	1
App\Entity\User	1
App\Entity\HomeConfigTranslation	1

Entities Mapping

Class	Mapping errors
App\Entity\Site	No errors.
App\Entity\AccessCode	No errors.
App\Entity\ProductCategory	No errors.
App\Entity\HomeConfig	No errors.
App\Entity\User	No errors.
App\Entity\HomeSection	No errors.
App\Entity\HomeConfigTranslation	No errors.
App\Entity\AccessCodeSiteConfig	No errors.
App\Entity\Import	No errors.
App\Entity\Price	No errors.
App\Entity\Order	No errors.
App\Entity\Product	No errors.
App\Entity\Mecanique	No errors.
App\Entity\ProductCategoryTranslation	No errors.
App\Entity\UserPlace	No errors.
App\Entity\SiteRoles	No errors.
App\Entity\PlaceAddress	No errors.
App\Entity\Module	No errors.
App\Entity\Cagnotte	No errors.
App\Entity\HomeSectionTranslation	No errors.
App\Entity\Config	No errors.
App\Entity\ProductPrice	No errors.
App\Entity\OrderLine	No errors.
App\Entity\Place	No errors.
App\Entity\OrderAddress	No errors.
App\Entity\OrderPrice	No errors.
App\Entity\Delivery	No errors.
App\Entity\OrderMecanique	No errors.
App\Entity\Periode	No errors.
App\Entity\ProductSplit	No errors.
App\Entity\ProductImage	No errors.
App\Entity\ProductData	No errors.
App\Entity\ModuleProduct	No errors.
App\Entity\ProductTranslation	No errors.
App\Entity\MenuGroup	No errors.
App\Entity\MenuGroupTranslation	No errors.
App\Entity\Stock	No errors.
App\Entity\Zone	No errors.
App\Entity\Color	No errors.
App\Entity\ResetPasswordRequest	No errors.
App\Entity\Size	No errors.
App\Entity\ProductDataTranslation	No errors.
App\Entity\PlaceDatas	No errors.
App\Entity\MenuItem	No errors.
App\Entity\OrderExport	No errors.
App\Entity\Notification	No errors.
App\Entity\NotificationTranslation	No errors.
App\Entity\Groupe	No errors.
App\Entity\MenuItemTranslation	No errors.
App\Entity\Brand	No errors.
Zenstruck\Messenger\Monitor\History\Model\ProcessedMessage	No errors.
App\Entity\ProcessedMessage	No errors.
App\Entity\Admin	No errors.
App\Entity\Country	No errors.
App\Entity\PeriodeTranslation	No errors.
App\Entity\ShippingFee	No errors.
Gedmo\Tree\Entity\MappedSuperclass\AbstractClosure	No errors.
Vich\UploaderBundle\Entity\File	No errors.

Symfony Profiler

GET https://adidas.toofoot.com/fr/login

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping