Symfony Profiler

Query Metrics

5 Database Queries

3 Different statements

4.45 ms Query time

2 Invalid entities

4 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

2.11 ms
(47.39%)

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 452)
13	Twig\Template->yieldBlock (line 477)
14	Twig\Template->yieldParentBlock (line 104)
15	__TwigTemplate_1f19a0c1b00ddfaf901b66f24c801ad3->block_title (line 432)
16	Twig\Template->yieldBlock (line 125)
17	__TwigTemplate_692ca1a32ee90cd799b8ee42df86d9b4->doDisplay (line 388)
18	Twig\Template->yield (line 55)
19	__TwigTemplate_e7465592976de05b89e476e017a4a353->doDisplay (line 388)
20	Twig\Template->yield (line 55)
21	__TwigTemplate_c75c1fe2e3ec37b7dca2e9be270d9c68->doDisplay (line 388)
22	Twig\Template->yield (line 56)
23	__TwigTemplate_1f19a0c1b00ddfaf901b66f24c801ad3->doDisplay (line 388)
24	Twig\Template->yield (line 344)
25	Twig\Template->display (line 359)
26	Twig\Template->render (line 51)
27	Twig\TemplateWrapper->render (line 334)
28	Twig\Environment->render (line 448)
29	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
30	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
31	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 247)
32	App\Controller\Front\AdvertRentController->advertFrontTraitList (line 69)
33	App\Controller\Front\AdvertRentController->list (line 181)
34	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
35	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
36	Symfony\Component\HttpKernel\Kernel->handle (line 35)
37	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
38	require_once (line 5)

1.22 ms
(27.52%)

SELECT n0_.id AS id_0, n0_.slug AS slug_1, n0_.updated_at AS updated_at_2, n0_.published AS published_3, n0_.photos_rz_authorization AS photos_rz_authorization_4, n0_.created_at AS created_at_5, n0_.title AS title_6, n0_.title_slugified AS title_slugified_7, n0_.price AS price_8, n0_.period_number AS period_number_9, n0_.studio_number AS studio_number_10, n0_.datefrom AS datefrom_11, n0_.dateto AS dateto_12, n0_.tel AS tel_13, n0_.email AS email_14, n0_.content AS content_15, n0_.quick_response_code_filename AS quick_response_code_filename_16, n0_.user_id AS user_id_17, n0_.studio_id AS studio_id_18, n0_.period_id AS period_id_19 FROM nw_advert_rent n0_ LEFT JOIN nw_studio n1_ ON n0_.studio_id = n1_.id WHERE n1_.residence_id = ? AND (n0_.dateto BETWEEN ? AND ?) ORDER BY n0_.datefrom ASC

Parameters:

[
  25
  "2026-09-08 00:00:00"
  "2029-09-08 00:00:00"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  n0_.id AS id_0,
  n0_.slug AS slug_1,
  n0_.updated_at AS updated_at_2,
  n0_.published AS published_3,
  n0_.photos_rz_authorization AS photos_rz_authorization_4,
  n0_.created_at AS created_at_5,
  n0_.title AS title_6,
  n0_.title_slugified AS title_slugified_7,
  n0_.price AS price_8,
  n0_.period_number AS period_number_9,
  n0_.studio_number AS studio_number_10,
  n0_.datefrom AS datefrom_11,
  n0_.dateto AS dateto_12,
  n0_.tel AS tel_13,
  n0_.email AS email_14,
  n0_.content AS content_15,
  n0_.quick_response_code_filename AS quick_response_code_filename_16,
  n0_.user_id AS user_id_17,
  n0_.studio_id AS studio_id_18,
  n0_.period_id AS period_id_19
FROM
  nw_advert_rent n0_
  LEFT JOIN nw_studio n1_ ON n0_.studio_id = n1_.id
WHERE
  n1_.residence_id = ?
  AND (
    n0_.dateto BETWEEN ?
    AND ?
  )
ORDER BY
  n0_.datefrom ASC

SELECT n0_.id AS id_0, n0_.slug AS slug_1, n0_.updated_at AS updated_at_2, n0_.published AS published_3, n0_.photos_rz_authorization AS photos_rz_authorization_4, n0_.created_at AS created_at_5, n0_.title AS title_6, n0_.title_slugified AS title_slugified_7, n0_.price AS price_8, n0_.period_number AS period_number_9, n0_.studio_number AS studio_number_10, n0_.datefrom AS datefrom_11, n0_.dateto AS dateto_12, n0_.tel AS tel_13, n0_.email AS email_14, n0_.content AS content_15, n0_.quick_response_code_filename AS quick_response_code_filename_16, n0_.user_id AS user_id_17, n0_.studio_id AS studio_id_18, n0_.period_id AS period_id_19 FROM nw_advert_rent n0_ LEFT JOIN nw_studio n1_ ON n0_.studio_id = n1_.id WHERE n1_.residence_id = 25 AND (n0_.dateto BETWEEN '2026-09-08 00:00:00' AND '2029-09-08 00:00:00') ORDER BY n0_.datefrom 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 224)
7	App\Repository\AdvertRentRepository->betweenByResidence (line 150)
8	App\Controller\Front\AdvertRentController->advertFrontTraitList (line 69)
9	App\Controller\Front\AdvertRentController->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.12 ms
(25.09%)

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	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\AdvertRent	No errors.
App\Entity\Studio	No errors.
App\Entity\User	No errors.
App\Entity\Period	No errors.
App\Entity\Configuration	No errors.

Symfony Profiler

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

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping