Symfony Profiler

Query Metrics

20 Database Queries

7 Different statements

10.02 ms Query time

0 Invalid entities

114 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

2.93 ms
(29.22%)

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:

[
  "pepouzin1.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 = 'pepouzin1.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 226)
5	App\Controller\HomeController->handleClientHome (line 195)
6	App\Controller\HomeController->index (line 154)
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)

1.70 ms
(16.92%)

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:

[
  266
]

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 = 266;

#	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 315)
7	__TwigTemplate_03e107946382954c57f3e353eb0f0a4b->block_body (line 161)
8	Twig\Template->yieldBlock (line 446)
9	__TwigTemplate_54ac2cced30a099f06ebc7e994a2831e->doDisplay (line 87)
10	Twig\Template->yield (line 402)
11	__TwigTemplate_03e107946382954c57f3e353eb0f0a4b->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 280)
21	App\Controller\HomeController->handleClientHome (line 206)
22	App\Controller\HomeController->index (line 154)
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.68 ms
(16.74%)

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:

[
  55
]

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 (55);

#	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 176)
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 73)
13	App\Service\PageMapRenderer->buildMap (line 20)
14	App\Controller\HomeController->renderPageLogic (line 262)
15	App\Controller\HomeController->handleClientHome (line 206)
16	App\Controller\HomeController->index (line 154)
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)

1.57 ms
(15.63%)

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:

[
  55
]

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 = 55;

#	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 73)
8	App\Service\PageMapRenderer->buildMap (line 20)
9	App\Controller\HomeController->renderPageLogic (line 262)
10	App\Controller\HomeController->handleClientHome (line 206)
11	App\Controller\HomeController->index (line 154)
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)

0.86 ms
(8.63%)

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.protected AS protected_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.deleted_at AS deleted_at_10, t0.deleted AS deleted_11, t0.site_id AS site_id_12 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.protected AS protected_7,
  t0.created_at AS created_at_8,
  t0.updated_at AS updated_at_9,
  t0.deleted_at AS deleted_at_10,
  t0.deleted AS deleted_11,
  t0.site_id AS site_id_12
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.protected AS protected_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.deleted_at AS deleted_at_10, t0.deleted AS deleted_11, t0.site_id AS site_id_12 FROM page t0 WHERE t0.site_id = 11 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 198)
5	App\Controller\HomeController->index (line 154)
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.68 ms
(6.79%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.published AS published_3, t0.is_template AS is_template_4, t0.is_in_catalogue AS is_in_catalogue_5, t0.screenshot_path AS screenshot_path_6, t0.background_color AS background_color_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.deleted_at AS deleted_at_10, t0.deleted AS deleted_11, t0.owner_id AS owner_id_12, t0.category_id AS category_id_13 FROM site t0 WHERE t0.id = ?

Parameters:

[
  11
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.published AS published_3,
  t0.is_template AS is_template_4,
  t0.is_in_catalogue AS is_in_catalogue_5,
  t0.screenshot_path AS screenshot_path_6,
  t0.background_color AS background_color_7,
  t0.created_at AS created_at_8,
  t0.updated_at AS updated_at_9,
  t0.deleted_at AS deleted_at_10,
  t0.deleted AS deleted_11,
  t0.owner_id AS owner_id_12,
  t0.category_id AS category_id_13
FROM
  site t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.published AS published_3, t0.is_template AS is_template_4, t0.is_in_catalogue AS is_in_catalogue_5, t0.screenshot_path AS screenshot_path_6, t0.background_color AS background_color_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.deleted_at AS deleted_at_10, t0.deleted AS deleted_11, t0.owner_id AS owner_id_12, t0.category_id AS category_id_13 FROM site t0 WHERE t0.id = 11;

#	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\Site::{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\Site->__get (line 153)
7	App\Entity\Site->getBackgroundColor (line 326)
8	Twig\Extension\CoreExtension->getAttribute (line 1919)
9	__TwigTemplate_54ac2cced30a099f06ebc7e994a2831e::block_stylesheets (line 154)
10	Twig\Template->yieldBlock (line 446)
11	__TwigTemplate_54ac2cced30a099f06ebc7e994a2831e->doDisplay (line 65)
12	Twig\Template->yield (line 402)
13	__TwigTemplate_03e107946382954c57f3e353eb0f0a4b->doDisplay (line 54)
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 467)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
22	App\Controller\HomeController->renderPageLogic (line 280)
23	App\Controller\HomeController->handleClientHome (line 206)
24	App\Controller\HomeController->index (line 154)
25	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
26	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
27	Symfony\Component\HttpKernel\Kernel->handle (line 193)
28	Runtime\FrankenPhpSymfony\Runner->{closure:Runtime\FrankenPhpSymfony\Runner::run():33} (line 38)
29	frankenphp_handle_request (line 45)
30	Runtime\FrankenPhpSymfony\Runner::run (line 45)
31	require_once (line 32)
32	require_once (line 5)

0.61 ms
(6.06%)

SELECT t0.id AS id_1, t0.position AS position_2, t0.background_color AS background_color_3, t0.page_id AS page_id_4, t0.bloc_id AS bloc_id_5 FROM page_bloc t0 WHERE t0.page_id = ?

Parameters:

[
  42
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.position AS position_2,
  t0.background_color AS background_color_3,
  t0.page_id AS page_id_4,
  t0.bloc_id AS bloc_id_5
FROM
  page_bloc t0
WHERE
  t0.page_id = ?

SELECT t0.id AS id_1, t0.position AS position_2, t0.background_color AS background_color_3, t0.page_id AS page_id_4, t0.bloc_id AS bloc_id_5 FROM page_bloc t0 WHERE t0.page_id = 42;

#	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 41)
7	Doctrine\ORM\PersistentCollection->count (line 391)
8	Doctrine\ORM\PersistentCollection->isEmpty (line 446)
9	App\Controller\HomeController->renderPageLogic (line 254)
10	App\Controller\HomeController->handleClientHome (line 206)
11	App\Controller\HomeController->index (line 154)
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\Field	88
App\Entity\PageBlocValue	11
App\Entity\PageBloc	5
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	No errors.
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.
App\Entity\SiteCategory	No errors.
App\Entity\NewsletterSubscription	No errors.
App\Entity\Newsletter	No errors.

Symfony Profiler

GET https://pepouzin1.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