Symfony Profiler

Query Metrics

20 Database Queries

6 Different statements

9.99 ms Query time

1 Invalid entities

72 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

2.78 ms
(27.83%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.deleted_at AS deleted_at_5, t0.domaine_id AS domaine_id_6, t0.site_id AS site_id_7, t0.user_id AS user_id_8 FROM sub_domain t0 WHERE t0.name = ? LIMIT 1

Parameters:

[
  "pepouzin2.devlogiciel.com"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.created_at AS created_at_3,
  t0.updated_at AS updated_at_4,
  t0.deleted_at AS deleted_at_5,
  t0.domaine_id AS domaine_id_6,
  t0.site_id AS site_id_7,
  t0.user_id AS user_id_8
FROM
  sub_domain t0
WHERE
  t0.name = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.deleted_at AS deleted_at_5, t0.domaine_id AS domaine_id_6, t0.site_id AS site_id_7, t0.user_id AS user_id_8 FROM sub_domain t0 WHERE t0.name = 'pepouzin2.devlogiciel.com' 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	App\Controller\HomeController->resolveSite (line 158)
5	App\Controller\HomeController->handleClientHome (line 127)
6	App\Controller\HomeController->index (line 87)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
9	Symfony\Component\HttpKernel\Kernel->handle (line 193)
10	Runtime\FrankenPhpSymfony\Runner->{closure:Runtime\FrankenPhpSymfony\Runner::run():33} (line 38)
11	frankenphp_handle_request (line 45)
12	Runtime\FrankenPhpSymfony\Runner::run (line 45)
13	require_once (line 32)
14	require_once (line 5)

2.43 ms
(24.39%)

SELECT t0.id AS id_1, t0.value AS value_2, t0.json AS json_3, t0.page_bloc_id AS page_bloc_id_4, t0.field_id AS field_id_5 FROM page_bloc_value t0 WHERE t0.page_bloc_id = ?

Parameters:

[
  302
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.value AS value_2,
  t0.json AS json_3,
  t0.page_bloc_id AS page_bloc_id_4,
  t0.field_id AS field_id_5
FROM
  page_bloc_value t0
WHERE
  t0.page_bloc_id = ?

SELECT t0.id AS id_1, t0.value AS value_2, t0.json AS json_3, t0.page_bloc_id AS page_bloc_id_4, t0.field_id AS field_id_5 FROM page_bloc_value t0 WHERE t0.page_bloc_id = 302;

#	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->getIterator (line 313)
7	__TwigTemplate_e89aca839c4c29b2a4050123b77663a1->block_body (line 161)
8	Twig\Template->yieldBlock (line 446)
9	__TwigTemplate_6627a6241f39f88e3981e5d122707c8e->doDisplay (line 75)
10	Twig\Template->yield (line 402)
11	__TwigTemplate_e89aca839c4c29b2a4050123b77663a1->doDisplay (line 54)
12	Twig\Template->yield (line 402)
13	Twig\Template->display (line 358)
14	Twig\Template->render (line 373)
15	Twig\TemplateWrapper->render (line 51)
16	Twig\Environment->render (line 333)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
20	App\Controller\HomeController->renderPageLogic (line 209)
21	App\Controller\HomeController->handleClientHome (line 138)
22	App\Controller\HomeController->index (line 87)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
25	Symfony\Component\HttpKernel\Kernel->handle (line 193)
26	Runtime\FrankenPhpSymfony\Runner->{closure:Runtime\FrankenPhpSymfony\Runner::run():33} (line 38)
27	frankenphp_handle_request (line 45)
28	Runtime\FrankenPhpSymfony\Runner::run (line 45)
29	require_once (line 32)
30	require_once (line 5)

1.83 ms
(18.36%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3, t0.template_path AS template_path_4, t0.block_file_name AS block_file_name_5, t0.created_at AS created_at_6, t0.level AS level_7, t0.published AS published_8 FROM bloc t0 WHERE t0.id = ?

Parameters:

[
  47
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.type AS type_3,
  t0.template_path AS template_path_4,
  t0.block_file_name AS block_file_name_5,
  t0.created_at AS created_at_6,
  t0.level AS level_7,
  t0.published AS published_8
FROM
  bloc t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3, t0.template_path AS template_path_4, t0.block_file_name AS block_file_name_5, t0.created_at AS created_at_6, t0.level AS level_7, t0.published AS published_8 FROM bloc t0 WHERE t0.id = 47;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
3	Doctrine\ORM\Proxy\ProxyFactory->{closure:Doctrine\ORM\Proxy\ProxyFactory::createLazyInitializer():294} (line 295)
4	Proxies\__CG__\App\Entity\Bloc::{closure:{closure:Doctrine\ORM\Proxy\ProxyFactory::getProxyFactory():371}:372} (line 373)
5	Symfony\Component\VarExporter\Internal\LazyObjectState::initialize (line 60)
6	Proxies\__CG__\App\Entity\Bloc->__get (line 153)
7	App\Entity\Bloc->getType (line 72)
8	App\Service\PageMapRenderer->buildMap (line 20)
9	App\Controller\HomeController->renderPageLogic (line 191)
10	App\Controller\HomeController->handleClientHome (line 138)
11	App\Controller\HomeController->index (line 87)
12	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
13	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
14	Symfony\Component\HttpKernel\Kernel->handle (line 193)
15	Runtime\FrankenPhpSymfony\Runner->{closure:Runtime\FrankenPhpSymfony\Runner::run():33} (line 38)
16	frankenphp_handle_request (line 45)
17	Runtime\FrankenPhpSymfony\Runner::run (line 45)
18	require_once (line 32)
19	require_once (line 5)

1.60 ms
(15.97%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3, t0.placeholder AS placeholder_4, t0.required AS required_5, t0.default_content AS default_content_6, t0.bloc_id AS bloc_id_7 FROM field t0 WHERE t0.bloc_id IN (?)

Parameters:

[
  47
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.type AS type_3,
  t0.placeholder AS placeholder_4,
  t0.required AS required_5,
  t0.default_content AS default_content_6,
  t0.bloc_id AS bloc_id_7
FROM
  field t0
WHERE
  t0.bloc_id IN (?)

SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3, t0.placeholder AS placeholder_4, t0.required AS required_5, t0.default_content AS default_content_6, t0.bloc_id AS bloc_id_7 FROM field t0 WHERE t0.bloc_id IN (47);

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 963)
2	Doctrine\ORM\UnitOfWork->eagerLoadCollections (line 2677)
3	Doctrine\ORM\UnitOfWork->triggerEagerLoads (line 2653)
4	Doctrine\ORM\Internal\Hydration\SimpleObjectHydrator->hydrateAllData (line 63)
5	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 175)
6	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 746)
7	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
8	Doctrine\ORM\Proxy\ProxyFactory->{closure:Doctrine\ORM\Proxy\ProxyFactory::createLazyInitializer():294} (line 295)
9	Proxies\__CG__\App\Entity\Bloc::{closure:{closure:Doctrine\ORM\Proxy\ProxyFactory::getProxyFactory():371}:372} (line 373)
10	Symfony\Component\VarExporter\Internal\LazyObjectState::initialize (line 60)
11	Proxies\__CG__\App\Entity\Bloc->__get (line 153)
12	App\Entity\Bloc->getType (line 72)
13	App\Service\PageMapRenderer->buildMap (line 20)
14	App\Controller\HomeController->renderPageLogic (line 191)
15	App\Controller\HomeController->handleClientHome (line 138)
16	App\Controller\HomeController->index (line 87)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
19	Symfony\Component\HttpKernel\Kernel->handle (line 193)
20	Runtime\FrankenPhpSymfony\Runner->{closure:Runtime\FrankenPhpSymfony\Runner::run():33} (line 38)
21	frankenphp_handle_request (line 45)
22	Runtime\FrankenPhpSymfony\Runner::run (line 45)
23	require_once (line 32)
24	require_once (line 5)

0.78 ms
(7.80%)

SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.home_page AS home_page_4, t0.folder AS folder_5, t0.published AS published_6, t0.site_id AS site_id_7 FROM page t0 WHERE t0.site_id = ? AND t0.home_page = ? LIMIT 1

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.slug AS slug_3,
  t0.home_page AS home_page_4,
  t0.folder AS folder_5,
  t0.published AS published_6,
  t0.site_id AS site_id_7
FROM
  page t0
WHERE
  t0.site_id = ?
  AND t0.home_page = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.home_page AS home_page_4, t0.folder AS folder_5, t0.published AS published_6, t0.site_id AS site_id_7 FROM page t0 WHERE t0.site_id = 79 AND t0.home_page = 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	App\Controller\HomeController->handleClientHome (line 130)
5	App\Controller\HomeController->index (line 87)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
8	Symfony\Component\HttpKernel\Kernel->handle (line 193)
9	Runtime\FrankenPhpSymfony\Runner->{closure:Runtime\FrankenPhpSymfony\Runner::run():33} (line 38)
10	frankenphp_handle_request (line 45)
11	Runtime\FrankenPhpSymfony\Runner::run (line 45)
12	require_once (line 32)
13	require_once (line 5)

0.56 ms
(5.65%)

SELECT t0.id AS id_1, t0.position AS position_2, t0.page_id AS page_id_3, t0.bloc_id AS bloc_id_4 FROM page_bloc t0 WHERE t0.page_id = ?

Parameters:

[
  44
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.position AS position_2,
  t0.page_id AS page_id_3,
  t0.bloc_id AS bloc_id_4
FROM
  page_bloc t0
WHERE
  t0.page_id = ?

SELECT t0.id AS id_1, t0.position AS position_2, t0.page_id AS page_id_3, t0.bloc_id AS bloc_id_4 FROM page_bloc t0 WHERE t0.page_id = 44;

#	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->count (line 39)
7	Doctrine\ORM\PersistentCollection->count (line 391)
8	Doctrine\ORM\PersistentCollection->isEmpty (line 446)
9	App\Controller\HomeController->renderPageLogic (line 183)
10	App\Controller\HomeController->handleClientHome (line 138)
11	App\Controller\HomeController->index (line 87)
12	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
13	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
14	Symfony\Component\HttpKernel\Kernel->handle (line 193)
15	Runtime\FrankenPhpSymfony\Runner->{closure:Runtime\FrankenPhpSymfony\Runner::run():33} (line 38)
16	frankenphp_handle_request (line 45)
17	Runtime\FrankenPhpSymfony\Runner::run (line 45)
18	require_once (line 32)
19	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\PageBlocValue	33
App\Entity\Field	23
App\Entity\PageBloc	6
App\Entity\Bloc	5
App\Entity\SubDomain	1
App\Entity\Domaine	1
App\Entity\Site	1
App\Entity\User	1
App\Entity\Page	1

Entities Mapping

Class	Mapping errors
App\Entity\SubDomain	The association App\Entity\SubDomain#user refers to the inverse side field App\Entity\User#ownedSubDomains which does not exist.
App\Entity\Domaine	No errors.
App\Entity\Site	No errors.
App\Entity\User	No errors.
App\Entity\Page	No errors.
App\Entity\PageBloc	No errors.
App\Entity\Bloc	No errors.
App\Entity\PageBlocValue	No errors.
App\Entity\Field	No errors.
App\Entity\FieldOption	No errors.

Symfony Profiler

GET https://pepouzin2.devlogiciel.com/

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping