Symfony Profiler

Query Metrics

3 Database Queries

3 Different statements

0.27 ms Query time

0 Invalid entities

2 Managed entities

Queries

Group similar statements

#▲

Time

Info

0.10 ms

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.06 ms

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)

0.11 ms

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)

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

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.

Symfony Profiler

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

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping