Symfony Profiler

Query Metrics

5 Database Queries

2 Different statements

3.76 ms Query time

2 Invalid entities

5 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

2.76 ms
(73.45%)

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 78)
18	__TwigTemplate_41218eea4d6295a5309769a614b2a507->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 54)
28	__TwigTemplate_41218eea4d6295a5309769a614b2a507->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 150)
37	App\Controller\Front\RegisterController->registerAssociate (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)

1.00 ms
(26.55%)

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)

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

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\Configuration	No errors.

Symfony Profiler

GET https://staging.meribel-mottaret-lesbleuets.fr/enregistrement/associe?account=standard

Configuration Settings

Theme

Page Width