Symfony Profiler

Query Metrics

11 Database Queries

6 Different statements

9.32 ms Query time

3 Invalid entities

37 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

3.05 ms
(32.69%)

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

1.87 ms
(20.10%)

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 266)
10	__TwigTemplate_23d0c39c0441b6013c09d5ad67f952ec->block_page (line 432)
11	Twig\Template->yieldBlock (line 107)
12	__TwigTemplate_4b941c1bbd7f2f386503afcbf291659c->block_content (line 432)
13	Twig\Template->yieldBlock (line 112)
14	__TwigTemplate_e7465592976de05b89e476e017a4a353->block_container (line 432)
15	Twig\Template->yieldBlock (line 81)
16	__TwigTemplate_e7465592976de05b89e476e017a4a353->block_main (line 432)
17	Twig\Template->yieldBlock (line 173)
18	__TwigTemplate_692ca1a32ee90cd799b8ee42df86d9b4->doDisplay (line 388)
19	Twig\Template->yield (line 55)
20	__TwigTemplate_e7465592976de05b89e476e017a4a353->doDisplay (line 388)
21	Twig\Template->yield (line 54)
22	__TwigTemplate_4b941c1bbd7f2f386503afcbf291659c->doDisplay (line 388)
23	Twig\Template->yield (line 54)
24	__TwigTemplate_23d0c39c0441b6013c09d5ad67f952ec->doDisplay (line 388)
25	Twig\Template->yield (line 344)
26	Twig\Template->display (line 359)
27	Twig\Template->render (line 51)
28	Twig\TemplateWrapper->render (line 334)
29	Twig\Environment->render (line 448)
30	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
31	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
32	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 101)
33	App\Controller\NoteController->noteTraitList (line 75)
34	App\Controller\NoteController->list (line 181)
35	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
36	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
37	Symfony\Component\HttpKernel\Kernel->handle (line 35)
38	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
39	require_once (line 5)

1.29 ms
(13.88%)

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

Parameters:

[]

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_category n0_
  LEFT JOIN nw_note_category n1_ ON (n1_.category_id = n0_.id)
  LEFT JOIN nw_note n2_ ON (n1_.note_id = n2_.id)
WHERE
  n1_.category_id IS NOT NULL

SELECT n0_.id AS id_0, n0_.date AS date_1, n0_.name AS name_2, n0_.comment AS comment_3 FROM nw_category n0_ LEFT JOIN nw_note_category n1_ ON (n1_.category_id = n0_.id) LEFT JOIN nw_note n2_ ON (n1_.note_id = n2_.id) WHERE n1_.category_id IS NOT NULL;

#	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 119)
7	App\Repository\CategoryRepository->findAllWithOneNoteAtLeast (line 98)
8	App\Controller\NoteController->noteTraitList (line 75)
9	App\Controller\NoteController->list (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)

1.16 ms
(12.42%)

SELECT n0_.id AS id_0, n0_.date AS date_1, n0_.name AS name_2, n0_.content AS content_3, n0_.slug AS slug_4, n0_.comment AS comment_5, n0_.supervisor AS supervisor_6, n0_.admin AS admin_7, n0_.editor AS editor_8, n0_.premium AS premium_9, n0_.std AS std_10, n0_.visitor AS visitor_11, n0_.front AS front_12, n0_.published AS published_13, n0_.pinned AS pinned_14, n0_.residence_id AS residence_id_15, n0_.document_id AS document_id_16 FROM nw_note n0_ WHERE n0_.residence_id = ? AND n0_.front = ? AND n0_.published = ? ORDER BY n0_.date DESC

Parameters:

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_.content AS content_3,
  n0_.slug AS slug_4,
  n0_.comment AS comment_5,
  n0_.supervisor AS supervisor_6,
  n0_.admin AS admin_7,
  n0_.editor AS editor_8,
  n0_.premium AS premium_9,
  n0_.std AS std_10,
  n0_.visitor AS visitor_11,
  n0_.front AS front_12,
  n0_.published AS published_13,
  n0_.pinned AS pinned_14,
  n0_.residence_id AS residence_id_15,
  n0_.document_id AS document_id_16
FROM
  nw_note n0_
WHERE
  n0_.residence_id = ?
  AND n0_.front = ?
  AND n0_.published = ?
ORDER BY
  n0_.date DESC

SELECT n0_.id AS id_0, n0_.date AS date_1, n0_.name AS name_2, n0_.content AS content_3, n0_.slug AS slug_4, n0_.comment AS comment_5, n0_.supervisor AS supervisor_6, n0_.admin AS admin_7, n0_.editor AS editor_8, n0_.premium AS premium_9, n0_.std AS std_10, n0_.visitor AS visitor_11, n0_.front AS front_12, n0_.published AS published_13, n0_.pinned AS pinned_14, n0_.residence_id AS residence_id_15, n0_.document_id AS document_id_16 FROM nw_note n0_ WHERE n0_.residence_id = 25 AND n0_.front = 1 AND n0_.published = 1 ORDER BY n0_.date DESC;

#	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 172)
7	App\Repository\NoteRepository->listByResidence (line 93)
8	App\Controller\NoteController->noteTraitList (line 75)
9	App\Controller\NoteController->list (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)

1.08 ms
(11.60%)

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.87 ms
(9.30%)

SELECT n0_.id AS id_0, n0_.date AS date_1, n0_.name AS name_2, n0_.comment AS comment_3 FROM nw_category n0_ WHERE n0_.name <> ? ORDER BY n0_.name ASC

Parameters:

[
  "system"
]

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_category n0_
WHERE
  n0_.name <> ?
ORDER BY
  n0_.name ASC

SELECT n0_.id AS id_0, n0_.date AS date_1, n0_.name AS name_2, n0_.comment AS comment_3 FROM nw_category n0_ WHERE n0_.name <> 'system' ORDER BY n0_.name ASC;

#	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 46)
7	App\Repository\CategoryRepository->findAllExceptSystem (line 96)
8	App\Controller\NoteController->noteTraitList (line 75)
9	App\Controller\NoteController->list (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)

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\Category	23
App\Entity\Note	6
App\Entity\Configuration	4
App\Entity\Document	3
App\Entity\Residence	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\Category	No errors.
App\Entity\NoteCategory	No errors.
App\Entity\Configuration	No errors.

Symfony Profiler

GET https://staging.meribel-mottaret-lesbleuets.fr/notes

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping