Symfony Profiler

Query Metrics

7 Database Queries

5 Different statements

4.74 ms Query time

2 Invalid entities

8 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

1.91 ms
(40.42%)

SELECT n0_.id AS id_0, n0_.created_at AS created_at_1, n0_.updated_at AS updated_at_2, n0_.name AS name_3, n0_.short_name AS short_name_4, n0_.summary AS summary_5, n0_.content AS content_6, n0_.comment AS comment_7, n0_.residence_id AS residence_id_8 FROM nw_configuration n0_ WHERE n0_.short_name = ? AND n0_.residence_id = ?

Parameters:

[
  "meta_title"
  25
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  n0_.id AS id_0,
  n0_.created_at AS created_at_1,
  n0_.updated_at AS updated_at_2,
  n0_.name AS name_3,
  n0_.short_name AS short_name_4,
  n0_.summary AS summary_5,
  n0_.content AS content_6,
  n0_.comment AS comment_7,
  n0_.residence_id AS residence_id_8
FROM
  nw_configuration n0_
WHERE
  n0_.short_name = ?
  AND n0_.residence_id = ?

SELECT n0_.id AS id_0, n0_.created_at AS created_at_1, n0_.updated_at AS updated_at_2, n0_.name AS name_3, n0_.short_name AS short_name_4, n0_.summary AS summary_5, n0_.content AS content_6, n0_.comment AS comment_7, n0_.residence_id AS residence_id_8 FROM nw_configuration n0_ WHERE n0_.short_name = 'meta_title' AND n0_.residence_id = 25;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 738)
6	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 46)
7	App\Repository\ConfigurationRepository->findByShortNameAndResidence (line 53)
8	App\Service\ConfigurationService->get (line 1882)
9	Twig\Extension\CoreExtension::getAttribute (line 255)
10	__TwigTemplate_692ca1a32ee90cd799b8ee42df86d9b4->block_title (line 432)
11	Twig\Template->yieldBlock (line 452)
12	Twig\Template->yieldBlock (line 477)
13	Twig\Template->yieldParentBlock (line 78)
14	__TwigTemplate_4b941c1bbd7f2f386503afcbf291659c->block_title (line 432)
15	Twig\Template->yieldBlock (line 452)
16	Twig\Template->yieldBlock (line 477)
17	Twig\Template->yieldParentBlock (line 104)
18	__TwigTemplate_d9b33de22a0a114f382b8430f5265960->block_title (line 432)
19	Twig\Template->yieldBlock (line 125)
20	__TwigTemplate_692ca1a32ee90cd799b8ee42df86d9b4->doDisplay (line 388)
21	Twig\Template->yield (line 55)
22	__TwigTemplate_e7465592976de05b89e476e017a4a353->doDisplay (line 388)
23	Twig\Template->yield (line 54)
24	__TwigTemplate_4b941c1bbd7f2f386503afcbf291659c->doDisplay (line 388)
25	Twig\Template->yield (line 55)
26	__TwigTemplate_6551de933251774a320614b5a32b6b91->doDisplay (line 388)
27	Twig\Template->yield (line 55)
28	__TwigTemplate_d9b33de22a0a114f382b8430f5265960->doDisplay (line 388)
29	Twig\Template->yield (line 344)
30	Twig\Template->display (line 359)
31	Twig\Template->render (line 51)
32	Twig\TemplateWrapper->render (line 334)
33	Twig\Environment->render (line 448)
34	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
35	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
36	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 281)
37	App\Controller\Front\PageController->privacyPolicy (line 181)
38	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
39	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
40	Symfony\Component\HttpKernel\Kernel->handle (line 35)
41	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
42	require_once (line 5)

0.91 ms
(19.17%)

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.role_suffix AS role_suffix_4, t0.email AS email_5, t0.photo AS photo_6, t0.website AS website_7, t0.key_collection_times AS key_collection_times_8, t0.come_by_car AS come_by_car_9, t0.come_by_plane AS come_by_plane_10, t0.come_by_train AS come_by_train_11, t0.description AS description_12, t0.name AS name_13, t0.name_localization AS name_localization_14, t0.slug AS slug_15, t0.template_folder AS template_folder_16, t0.address AS address_17, t0.zipcode AS zipcode_18, t0.city AS city_19, t0.country AS country_20, t0.phone AS phone_21, t0.information AS information_22, t0.manager_firstname AS manager_firstname_23, t0.manager_lastname AS manager_lastname_24, t0.manager_email AS manager_email_25, t0.comment AS comment_26, t0.public AS public_27, t0.active AS active_28, t0.configured AS configured_29, t0.position AS position_30 FROM nw_residence t0 WHERE t0.slug = ? AND t0.active = ? LIMIT 1

Parameters:

[
  "meribel-mottaret-lesbleuets"
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.created_at AS created_at_2,
  t0.updated_at AS updated_at_3,
  t0.role_suffix AS role_suffix_4,
  t0.email AS email_5,
  t0.photo AS photo_6,
  t0.website AS website_7,
  t0.key_collection_times AS key_collection_times_8,
  t0.come_by_car AS come_by_car_9,
  t0.come_by_plane AS come_by_plane_10,
  t0.come_by_train AS come_by_train_11,
  t0.description AS description_12,
  t0.name AS name_13,
  t0.name_localization AS name_localization_14,
  t0.slug AS slug_15,
  t0.template_folder AS template_folder_16,
  t0.address AS address_17,
  t0.zipcode AS zipcode_18,
  t0.city AS city_19,
  t0.country AS country_20,
  t0.phone AS phone_21,
  t0.information AS information_22,
  t0.manager_firstname AS manager_firstname_23,
  t0.manager_lastname AS manager_lastname_24,
  t0.manager_email AS manager_email_25,
  t0.comment AS comment_26,
  t0.public AS public_27,
  t0.active AS active_28,
  t0.configured AS configured_29,
  t0.position AS position_30
FROM
  nw_residence t0
WHERE
  t0.slug = ?
  AND t0.active = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.role_suffix AS role_suffix_4, t0.email AS email_5, t0.photo AS photo_6, t0.website AS website_7, t0.key_collection_times AS key_collection_times_8, t0.come_by_car AS come_by_car_9, t0.come_by_plane AS come_by_plane_10, t0.come_by_train AS come_by_train_11, t0.description AS description_12, t0.name AS name_13, t0.name_localization AS name_localization_14, t0.slug AS slug_15, t0.template_folder AS template_folder_16, t0.address AS address_17, t0.zipcode AS zipcode_18, t0.city AS city_19, t0.country AS country_20, t0.phone AS phone_21, t0.information AS information_22, t0.manager_firstname AS manager_firstname_23, t0.manager_lastname AS manager_lastname_24, t0.manager_email AS manager_email_25, t0.comment AS comment_26, t0.public AS public_27, t0.active AS active_28, t0.configured AS configured_29, t0.position AS position_30 FROM nw_residence t0 WHERE t0.slug = 'meribel-mottaret-lesbleuets' AND t0.active = 1 LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 736)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 125)
3	Doctrine\ORM\EntityRepository->findOneBy (line 110)
4	App\EventListener\PageLoadListener->onKernelController (line 116)
5	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
6	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
7	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 139)
8	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 169)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require_once (line 5)

0.68 ms
(14.29%)

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.residence_id AS residence_id_4, t0.page_id AS page_id_5, t0.content_id AS content_id_6, t0.lang_id AS lang_id_7 FROM nw_cms_link t0 WHERE t0.residence_id = ? AND t0.page_id = ? AND t0.lang_id = ?

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.created_at AS created_at_2,
  t0.updated_at AS updated_at_3,
  t0.residence_id AS residence_id_4,
  t0.page_id AS page_id_5,
  t0.content_id AS content_id_6,
  t0.lang_id AS lang_id_7
FROM
  nw_cms_link t0
WHERE
  t0.residence_id = ?
  AND t0.page_id = ?
  AND t0.lang_id = ?

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.residence_id AS residence_id_4, t0.page_id AS page_id_5, t0.content_id AS content_id_6, t0.lang_id AS lang_id_7 FROM nw_cms_link t0 WHERE t0.residence_id = 25 AND t0.page_id = 16 AND t0.lang_id = 2;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 938)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 110)
3	Doctrine\ORM\EntityRepository->findBy (line 141)
4	App\Lib\CmsPageContentManager->getContent (line 276)
5	App\Controller\Front\PageController->privacyPolicy (line 181)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
8	Symfony\Component\HttpKernel\Kernel->handle (line 35)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
10	require_once (line 5)

0.63 ms
(13.22%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.method_name AS method_name_3, t0.controller_name AS controller_name_4, t0.env_name AS env_name_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.description AS description_8 FROM nw_cms_page t0 WHERE t0.method_name = ? AND t0.controller_name = ? AND t0.env_name = ? LIMIT 1

Parameters:

[
  "privacyPolicy"
  "TrialController"
  "std"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.method_name AS method_name_3,
  t0.controller_name AS controller_name_4,
  t0.env_name AS env_name_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7,
  t0.description AS description_8
FROM
  nw_cms_page t0
WHERE
  t0.method_name = ?
  AND t0.controller_name = ?
  AND t0.env_name = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.method_name AS method_name_3, t0.controller_name AS controller_name_4, t0.env_name AS env_name_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.description AS description_8 FROM nw_cms_page t0 WHERE t0.method_name = 'privacyPolicy' AND t0.controller_name = 'TrialController' AND t0.env_name = 'std' LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 736)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 125)
3	Doctrine\ORM\EntityRepository->findOneBy (line 119)
4	App\Lib\CmsPageContentManager->getContent (line 276)
5	App\Controller\Front\PageController->privacyPolicy (line 181)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
8	Symfony\Component\HttpKernel\Kernel->handle (line 35)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
10	require_once (line 5)

0.61 ms
(12.90%)

SELECT t0.id AS id_1, t0.title AS title_2, t0.subtitle AS subtitle_3, t0.slug AS slug_4, t0.summary AS summary_5, t0.published AS published_6, t0.createdAt AS createdAt_7, t0.updated_at AS updated_at_8, t0.published_at AS published_at_9, t0.content AS content_10, t0.comment AS comment_11, t0.lang_id AS lang_id_12 FROM nw_cms_content t0 WHERE t0.id = ? LIMIT 1

Parameters:

[
  17
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.subtitle AS subtitle_3,
  t0.slug AS slug_4,
  t0.summary AS summary_5,
  t0.published AS published_6,
  t0.createdAt AS createdAt_7,
  t0.updated_at AS updated_at_8,
  t0.published_at AS published_at_9,
  t0.content AS content_10,
  t0.comment AS comment_11,
  t0.lang_id AS lang_id_12
FROM
  nw_cms_content t0
WHERE
  t0.id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.title AS title_2, t0.subtitle AS subtitle_3, t0.slug AS slug_4, t0.summary AS summary_5, t0.published AS published_6, t0.createdAt AS createdAt_7, t0.updated_at AS updated_at_8, t0.published_at AS published_at_9, t0.content AS content_10, t0.comment AS comment_11, t0.lang_id AS lang_id_12 FROM nw_cms_content t0 WHERE t0.id = 17 LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 736)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 125)
3	Doctrine\ORM\EntityRepository->findOneBy (line 186)
4	App\Lib\CmsPageContentManager->getContent (line 276)
5	App\Controller\Front\PageController->privacyPolicy (line 181)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
8	Symfony\Component\HttpKernel\Kernel->handle (line 35)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
10	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\Configuration	3
App\Entity\Residence	1
App\Entity\CmsPage	1
App\Entity\CmsLink	1
App\Entity\CmsContent	1
App\Entity\CmsLang	1

Entities Mapping

Class	Mapping errors
App\Entity\Residence	The mappings App\Entity\Residence#documents and App\Entity\DocumentResidence#residence are inconsistent with each other.
App\Entity\DocumentResidence	The association App\Entity\DocumentResidence#residence refers to the inverse side field App\Entity\Residence#documentsResidences which does not exist.
App\Entity\CmsPage	No errors.
App\Entity\CmsLink	No errors.
App\Entity\CmsContent	No errors.
App\Entity\CmsLang	No errors.
App\Entity\Configuration	No errors.

Symfony Profiler

GET https://staging.meribel-mottaret-lesbleuets.fr/politique-de-confidentialite

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping