Symfony Profiler

Query Metrics

9 Database Queries

6 Different statements

6.35 ms Query time

3 Invalid entities

8 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

2.76 ms
(43.43%)

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 125)
16	__TwigTemplate_692ca1a32ee90cd799b8ee42df86d9b4->doDisplay (line 388)
17	Twig\Template->yield (line 55)
18	__TwigTemplate_e7465592976de05b89e476e017a4a353->doDisplay (line 388)
19	Twig\Template->yield (line 54)
20	__TwigTemplate_4b941c1bbd7f2f386503afcbf291659c->doDisplay (line 388)
21	Twig\Template->yield (line 54)
22	__TwigTemplate_396573900244fca9ef5c0f8df42282f3->doDisplay (line 388)
23	Twig\Template->yield (line 344)
24	Twig\Template->display (line 359)
25	Twig\Template->render (line 51)
26	Twig\TemplateWrapper->render (line 334)
27	Twig\Environment->render (line 448)
28	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
29	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
30	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 295)
31	App\Controller\NoteController->noteTraitView (line 106)
32	App\Controller\NoteController->view (line 181)
33	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
34	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
35	Symfony\Component\HttpKernel\Kernel->handle (line 35)
36	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
37	require_once (line 5)

0.94 ms
(14.72%)

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.79 ms
(12.49%)

SELECT n0_.id AS id_0, n0_.date AS date_1, n0_.name AS name_2, n0_.description AS description_3, n0_.file_name AS file_name_4, n0_.slug AS slug_5, n0_.comment AS comment_6 FROM nw_note_document n1_ LEFT JOIN nw_document n0_ ON (n1_.document_id = n0_.id) WHERE n1_.note_id = ?

Parameters:

[
  "105"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  n0_.id AS id_0,
  n0_.date AS date_1,
  n0_.name AS name_2,
  n0_.description AS description_3,
  n0_.file_name AS file_name_4,
  n0_.slug AS slug_5,
  n0_.comment AS comment_6
FROM
  nw_note_document n1_
  LEFT JOIN nw_document n0_ ON (n1_.document_id = n0_.id)
WHERE
  n1_.note_id = ?

SELECT n0_.id AS id_0, n0_.date AS date_1, n0_.name AS name_2, n0_.description AS description_3, n0_.file_name AS file_name_4, n0_.slug AS slug_5, n0_.comment AS comment_6 FROM nw_note_document n1_ LEFT JOIN nw_document n0_ ON (n1_.document_id = n0_.id) WHERE n1_.note_id = '105';

#	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 689)
6	Doctrine\ORM\AbstractQuery->getResult (line 63)
7	App\Repository\NoteDocumentRepository->documentsOfNote (line 291)
8	App\Controller\NoteController->noteTraitView (line 106)
9	App\Controller\NoteController->view (line 181)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
12	Symfony\Component\HttpKernel\Kernel->handle (line 35)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
14	require_once (line 5)

0.67 ms
(10.49%)

SELECT n0_.id AS id_0, n0_.date AS date_1, n0_.name AS name_2, n0_.comment AS comment_3 FROM nw_note_category n1_ LEFT JOIN nw_category n0_ ON (n1_.category_id = n0_.id) WHERE n1_.note_id = ?

Parameters:

[
  "105"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  n0_.id AS id_0,
  n0_.date AS date_1,
  n0_.name AS name_2,
  n0_.comment AS comment_3
FROM
  nw_note_category n1_
  LEFT JOIN nw_category n0_ ON (n1_.category_id = n0_.id)
WHERE
  n1_.note_id = ?

SELECT n0_.id AS id_0, n0_.date AS date_1, n0_.name AS name_2, n0_.comment AS comment_3 FROM nw_note_category n1_ LEFT JOIN nw_category n0_ ON (n1_.category_id = n0_.id) WHERE n1_.note_id = '105';

#	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 689)
6	Doctrine\ORM\AbstractQuery->getResult (line 63)
7	App\Repository\NoteCategoryRepository->categoriesOfNote (line 292)
8	App\Controller\NoteController->noteTraitView (line 106)
9	App\Controller\NoteController->view (line 181)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
12	Symfony\Component\HttpKernel\Kernel->handle (line 35)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
14	require_once (line 5)

0.63 ms
(9.94%)

SELECT t0.id AS id_1, t0.date AS date_2, t0.name AS name_3, t0.content AS content_4, t0.slug AS slug_5, t0.comment AS comment_6, t0.supervisor AS supervisor_7, t0.admin AS admin_8, t0.editor AS editor_9, t0.premium AS premium_10, t0.std AS std_11, t0.visitor AS visitor_12, t0.front AS front_13, t0.published AS published_14, t0.pinned AS pinned_15, t0.residence_id AS residence_id_16, t0.document_id AS document_id_17 FROM nw_note t0 WHERE t0.id = ?

Parameters:

[
  "105"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.date AS date_2,
  t0.name AS name_3,
  t0.content AS content_4,
  t0.slug AS slug_5,
  t0.comment AS comment_6,
  t0.supervisor AS supervisor_7,
  t0.admin AS admin_8,
  t0.editor AS editor_9,
  t0.premium AS premium_10,
  t0.std AS std_11,
  t0.visitor AS visitor_12,
  t0.front AS front_13,
  t0.published AS published_14,
  t0.pinned AS pinned_15,
  t0.residence_id AS residence_id_16,
  t0.document_id AS document_id_17
FROM
  nw_note t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.date AS date_2, t0.name AS name_3, t0.content AS content_4, t0.slug AS slug_5, t0.comment AS comment_6, t0.supervisor AS supervisor_7, t0.admin AS admin_8, t0.editor AS editor_9, t0.premium AS premium_10, t0.std AS std_11, t0.visitor AS visitor_12, t0.front AS front_13, t0.published AS published_14, t0.pinned AS pinned_15, t0.residence_id AS residence_id_16, t0.document_id AS document_id_17 FROM nw_note t0 WHERE t0.id = '105';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 736)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 754)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 362)
4	Doctrine\ORM\EntityManager->find (line 86)
5	Doctrine\ORM\EntityRepository->find (line 279)
6	App\Controller\NoteController->noteTraitView (line 106)
7	App\Controller\NoteController->view (line 181)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
10	Symfony\Component\HttpKernel\Kernel->handle (line 35)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
12	require_once (line 5)

0.57 ms
(8.93%)

SELECT t0.id AS id_1, t0.date AS date_2, t0.name AS name_3, t0.description AS description_4, t0.file_name AS file_name_5, t0.slug AS slug_6, t0.comment AS comment_7 FROM nw_document t0 WHERE t0.id = ?

Parameters:

[
  153
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.date AS date_2,
  t0.name AS name_3,
  t0.description AS description_4,
  t0.file_name AS file_name_5,
  t0.slug AS slug_6,
  t0.comment AS comment_7
FROM
  nw_document t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.date AS date_2, t0.name AS name_3, t0.description AS description_4, t0.file_name AS file_name_5, t0.slug AS slug_6, t0.comment AS comment_7 FROM nw_document t0 WHERE t0.id = 153;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 736)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 754)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 220)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 286)
5	Proxies\__CG__\App\Entity\Document::Doctrine\ORM\Proxy\{closure} (line 100)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 184)
7	Proxies\__CG__\App\Entity\Document->__get (line 214)
8	App\Entity\Document->getFileName (line 1882)
9	Twig\Extension\CoreExtension::getAttribute (line 56)
10	__TwigTemplate_90567974d5ee5d61dd18f149b9be8f72->doDisplay (line 388)
11	Twig\Template->yield (line 344)
12	Twig\Template->display (line 359)
13	Twig\Template->render (line 51)
14	Twig\TemplateWrapper->render (line 1493)
15	Twig\Extension\CoreExtension::include (line 110)
16	__TwigTemplate_396573900244fca9ef5c0f8df42282f3->block_page (line 432)
17	Twig\Template->yieldBlock (line 107)
18	__TwigTemplate_4b941c1bbd7f2f386503afcbf291659c->block_content (line 432)
19	Twig\Template->yieldBlock (line 112)
20	__TwigTemplate_e7465592976de05b89e476e017a4a353->block_container (line 432)
21	Twig\Template->yieldBlock (line 81)
22	__TwigTemplate_e7465592976de05b89e476e017a4a353->block_main (line 432)
23	Twig\Template->yieldBlock (line 173)
24	__TwigTemplate_692ca1a32ee90cd799b8ee42df86d9b4->doDisplay (line 388)
25	Twig\Template->yield (line 55)
26	__TwigTemplate_e7465592976de05b89e476e017a4a353->doDisplay (line 388)
27	Twig\Template->yield (line 54)
28	__TwigTemplate_4b941c1bbd7f2f386503afcbf291659c->doDisplay (line 388)
29	Twig\Template->yield (line 54)
30	__TwigTemplate_396573900244fca9ef5c0f8df42282f3->doDisplay (line 388)
31	Twig\Template->yield (line 344)
32	Twig\Template->display (line 359)
33	Twig\Template->render (line 51)
34	Twig\TemplateWrapper->render (line 334)
35	Twig\Environment->render (line 448)
36	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
37	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
38	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 295)
39	App\Controller\NoteController->noteTraitView (line 106)
40	App\Controller\NoteController->view (line 181)
41	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
42	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
43	Symfony\Component\HttpKernel\Kernel->handle (line 35)
44	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
45	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	4
App\Entity\Residence	1
App\Entity\Note	1
App\Entity\Document	1
App\Entity\Category	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\Note	No errors.
App\Entity\Document	No errors.
App\Entity\NoteResidence	The association App\Entity\NoteResidence#residence refers to the inverse side field App\Entity\Residence#notesResidences which does not exist.
App\Entity\NoteDocument	No errors.
App\Entity\NoteCategory	No errors.
App\Entity\Category	No errors.
App\Entity\Configuration	No errors.

Symfony Profiler

GET https://staging.meribel-mottaret-lesbleuets.fr/note/105

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping