Symfony Profiler

Query Metrics

8 Database Queries

7 Different statements

2.66 ms Query time

0 Invalid entities

17 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

0.69 ms
(25.78%)

SELECT count(DISTINCT m0_.id) AS sclr_0 FROM maison m0_ WHERE m0_.sold = ? AND m0_.is_visible = ?

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  count(DISTINCT m0_.id) AS sclr_0
FROM
  maison m0_
WHERE
  m0_.sold = ?
  AND m0_.is_visible = ?

SELECT count(DISTINCT m0_.id) AS sclr_0 FROM maison m0_ WHERE m0_.sold = 0 AND m0_.is_visible = 1;

#	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 725)
6	Doctrine\ORM\AbstractQuery->getScalarResult (line 96)
7	Doctrine\ORM\Tools\Pagination\Paginator->count (line 1)
8	count (line 43)
9	Knp\Component\Pager\Event\Subscriber\Paginate\Doctrine\ORM\QuerySubscriber->items (line 115)
10	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
11	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
12	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
13	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 97)
14	Knp\Component\Pager\Paginator->paginate (line 25)
15	ContainerMTzlRMl\PaginatorProxyBa079e5->paginate (line 72)
16	App\Controller\HomeController->location (line 183)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
19	Symfony\Component\HttpKernel\Kernel->handle (line 35)
20	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
21	require_once (line 5)

0.63 ms
(23.53%)

SELECT t0.id AS id_1, t0.image AS image_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.maison_id AS maison_id_5 FROM images_maison t0 WHERE t0.maison_id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.image AS image_2,
  t0.created_at AS created_at_3,
  t0.updated_at AS updated_at_4,
  t0.maison_id AS maison_id_5
FROM
  images_maison t0
WHERE
  t0.maison_id = ?

SELECT t0.id AS id_1, t0.image AS image_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.maison_id AS maison_id_5 FROM images_maison t0 WHERE t0.maison_id = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1842)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1787)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 2706)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 636)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 186)
6	Doctrine\ORM\PersistentCollection->initialize (line 313)
7	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 722)
8	Twig\Extension\CoreExtension::slice (line 754)
9	Twig\Extension\CoreExtension::first (line 54)
10	__TwigTemplate_e7a8645b5763fcaef76ac6e646c3270f->doDisplay (line 388)
11	Twig\Template->yield (line 259)
12	__TwigTemplate_cb9e0bb6fd7d69aef74f480f8269aee4->block_body (line 432)
13	Twig\Template->yieldBlock (line 202)
14	__TwigTemplate_6ae68ea10ee6abae1fd74b54ead91f13->doDisplay (line 388)
15	Twig\Template->yield (line 54)
16	__TwigTemplate_cb9e0bb6fd7d69aef74f480f8269aee4->doDisplay (line 388)
17	Twig\Template->yield (line 344)
18	Twig\Template->display (line 359)
19	Twig\Template->render (line 51)
20	Twig\TemplateWrapper->render (line 334)
21	Twig\Environment->render (line 431)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 77)
25	App\Controller\HomeController->location (line 183)
26	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
27	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
28	Symfony\Component\HttpKernel\Kernel->handle (line 35)
29	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
30	require_once (line 5)

0.35 ms
(13.24%)

SELECT m0_.id AS id_0, m0_.titre AS titre_1, m0_.adresse AS adresse_2, m0_.dimension AS dimension_3, m0_.loyer AS loyer_4, m0_.typelectrification AS typelectrification_5, m0_.created_at AS created_at_6, m0_.updated_at AS updated_at_7, m0_.description AS description_8, m0_.piece AS piece_9, m0_.bedrooms AS bedrooms_10, m0_.sold AS sold_11, m0_.garage AS garage_12, m0_.devise AS devise_13, m0_.is_visible AS is_visible_14, m0_.utilisateur_id AS utilisateur_id_15, m0_.type_id AS type_id_16 FROM maison m0_ WHERE m0_.sold = ? AND m0_.is_visible = ? AND m0_.id IN (?, ?)

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  m0_.id AS id_0,
  m0_.titre AS titre_1,
  m0_.adresse AS adresse_2,
  m0_.dimension AS dimension_3,
  m0_.loyer AS loyer_4,
  m0_.typelectrification AS typelectrification_5,
  m0_.created_at AS created_at_6,
  m0_.updated_at AS updated_at_7,
  m0_.description AS description_8,
  m0_.piece AS piece_9,
  m0_.bedrooms AS bedrooms_10,
  m0_.sold AS sold_11,
  m0_.garage AS garage_12,
  m0_.devise AS devise_13,
  m0_.is_visible AS is_visible_14,
  m0_.utilisateur_id AS utilisateur_id_15,
  m0_.type_id AS type_id_16
FROM
  maison m0_
WHERE
  m0_.sold = ?
  AND m0_.is_visible = ?
  AND m0_.id IN (?, ?)

SELECT m0_.id AS id_0, m0_.titre AS titre_1, m0_.adresse AS adresse_2, m0_.dimension AS dimension_3, m0_.loyer AS loyer_4, m0_.typelectrification AS typelectrification_5, m0_.created_at AS created_at_6, m0_.updated_at AS updated_at_7, m0_.description AS description_8, m0_.piece AS piece_9, m0_.bedrooms AS bedrooms_10, m0_.sold AS sold_11, m0_.garage AS garage_12, m0_.devise AS devise_13, m0_.is_visible AS is_visible_14, m0_.utilisateur_id AS utilisateur_id_15, m0_.type_id AS type_id_16 FROM maison m0_ WHERE m0_.sold = 0 AND m0_.is_visible = 1 AND m0_.id IN (1, 2);

#	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 145)
7	Doctrine\ORM\Tools\Pagination\Paginator->getIterator (line 1)
8	iterator_to_array (line 45)
9	Knp\Component\Pager\Event\Subscriber\Paginate\Doctrine\ORM\QuerySubscriber->items (line 115)
10	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
11	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
12	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
13	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 97)
14	Knp\Component\Pager\Paginator->paginate (line 25)
15	ContainerMTzlRMl\PaginatorProxyBa079e5->paginate (line 72)
16	App\Controller\HomeController->location (line 183)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
19	Symfony\Component\HttpKernel\Kernel->handle (line 35)
20	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
21	require_once (line 5)

0.34 ms
(12.80%)

SELECT t0_.id AS id_0, t0_.nom AS nom_1 FROM type t0_

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0_.id AS id_0,
  t0_.nom AS nom_1
FROM
  type t0_

SELECT t0_.id AS id_0, t0_.nom AS nom_1 FROM type t0_;

#	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 35)
6	Symfony\Bridge\Doctrine\Form\ChoiceList\ORMQueryBuilderLoader->getEntities (line 53)
7	Symfony\Bridge\Doctrine\Form\ChoiceList\DoctrineChoiceLoader->loadChoices (line 29)
8	Symfony\Component\Form\ChoiceList\Loader\AbstractChoiceLoader->loadChoiceList (line 56)
9	Symfony\Component\Form\ChoiceList\LazyChoiceList->getChoices (line 60)
10	Symfony\Component\Form\ChoiceList\Factory\DefaultChoiceListFactory->createView (line 178)
11	Symfony\Component\Form\ChoiceList\Factory\PropertyAccessDecorator->createView (line 187)
12	Symfony\Component\Form\ChoiceList\Factory\CachingFactoryDecorator->createView (line 477)
13	Symfony\Component\Form\Extension\Core\Type\ChoiceType->createChoiceListView (line 234)
14	Symfony\Component\Form\Extension\Core\Type\ChoiceType->buildView (line 107)
15	Symfony\Component\Form\ResolvedFormType->buildView (line 78)
16	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildView (line 105)
17	Symfony\Component\Form\ResolvedFormType->buildView (line 78)
18	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildView (line 888)
19	Symfony\Component\Form\Form->createView (line 891)
20	Symfony\Component\Form\Form->createView (line 79)
21	App\Controller\HomeController->location (line 183)
22	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
23	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
24	Symfony\Component\HttpKernel\Kernel->handle (line 35)
25	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
26	require_once (line 5)

0.27 ms
(10.02%)

SELECT DISTINCT m0_.id AS id_0 FROM maison m0_ WHERE m0_.sold = ? AND m0_.is_visible = ? LIMIT 12

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT m0_.id AS id_0
FROM
  maison m0_
WHERE
  m0_.sold = ?
  AND m0_.is_visible = ?
LIMIT
  12

SELECT DISTINCT m0_.id AS id_0 FROM maison m0_ WHERE m0_.sold = 0 AND m0_.is_visible = 1 LIMIT 12;

#	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 725)
6	Doctrine\ORM\AbstractQuery->getScalarResult (line 127)
7	Doctrine\ORM\Tools\Pagination\Paginator->getIterator (line 1)
8	iterator_to_array (line 45)
9	Knp\Component\Pager\Event\Subscriber\Paginate\Doctrine\ORM\QuerySubscriber->items (line 115)
10	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
11	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
12	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
13	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 97)
14	Knp\Component\Pager\Paginator->paginate (line 25)
15	ContainerMTzlRMl\PaginatorProxyBa079e5->paginate (line 72)
16	App\Controller\HomeController->location (line 183)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
19	Symfony\Component\HttpKernel\Kernel->handle (line 35)
20	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
21	require_once (line 5)

0.22 ms
(8.14%)

SELECT o0_.id AS id_0, o0_.name AS name_1 FROM `option` o0_

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  o0_.id AS id_0,
  o0_.name AS name_1
FROM
  `option` o0_

SELECT o0_.id AS id_0, o0_.name AS name_1 FROM `option` o0_;

#	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 35)
6	Symfony\Bridge\Doctrine\Form\ChoiceList\ORMQueryBuilderLoader->getEntities (line 53)
7	Symfony\Bridge\Doctrine\Form\ChoiceList\DoctrineChoiceLoader->loadChoices (line 29)
8	Symfony\Component\Form\ChoiceList\Loader\AbstractChoiceLoader->loadChoiceList (line 56)
9	Symfony\Component\Form\ChoiceList\LazyChoiceList->getChoices (line 60)
10	Symfony\Component\Form\ChoiceList\Factory\DefaultChoiceListFactory->createView (line 178)
11	Symfony\Component\Form\ChoiceList\Factory\PropertyAccessDecorator->createView (line 187)
12	Symfony\Component\Form\ChoiceList\Factory\CachingFactoryDecorator->createView (line 477)
13	Symfony\Component\Form\Extension\Core\Type\ChoiceType->createChoiceListView (line 234)
14	Symfony\Component\Form\Extension\Core\Type\ChoiceType->buildView (line 107)
15	Symfony\Component\Form\ResolvedFormType->buildView (line 78)
16	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildView (line 105)
17	Symfony\Component\Form\ResolvedFormType->buildView (line 78)
18	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildView (line 888)
19	Symfony\Component\Form\Form->createView (line 891)
20	Symfony\Component\Form\Form->createView (line 79)
21	App\Controller\HomeController->location (line 183)
22	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
23	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
24	Symfony\Component\HttpKernel\Kernel->handle (line 35)
25	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
26	require_once (line 5)

0.17 ms
(6.49%)

SELECT t0.id AS id_1, t0.nom AS nom_2 FROM type t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2
FROM
  type t0

SELECT t0.id AS id_1, t0.nom AS nom_2 FROM type t0;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 938)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 110)
3	Doctrine\ORM\EntityRepository->findBy (line 73)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 96)
5	Doctrine\ORM\EntityRepository->findAll (line 80)
6	App\Controller\HomeController->location (line 183)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
9	Symfony\Component\HttpKernel\Kernel->handle (line 35)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
11	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\Option	9
App\Entity\Type	4
App\Entity\Maison	2
App\Entity\ImagesMaison	2

Entities Mapping

Class	Mapping errors
App\Entity\Type	No errors.
App\Entity\Option	No errors.
App\Entity\Maison	No errors.
App\Entity\Utilisateur	No errors.
App\Entity\ImagesMaison	No errors.

Symfony Profiler

GET https://www.home-search.org/location

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping