Symfony Profiler

Query Metrics

8 Database Queries

8 Different statements

5.07 ms Query time

0 Invalid entities

14 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

1.32 ms
(25.96%)

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.title AS title_3, t0.content AS content_4, t0.utilisateur_id AS utilisateur_id_5 FROM blog t0 ORDER BY t0.created_at ASC LIMIT 2

Parameters:

[]

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.title AS title_3,
  t0.content AS content_4,
  t0.utilisateur_id AS utilisateur_id_5
FROM
  blog t0
ORDER BY
  t0.created_at ASC
LIMIT
  2

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.title AS title_3, t0.content AS content_4, t0.utilisateur_id AS utilisateur_id_5 FROM blog t0 ORDER BY t0.created_at ASC LIMIT 2;

#	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 42)
5	App\Controller\HomeController->index (line 183)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
8	Symfony\Component\HttpKernel\Kernel->handle (line 35)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
10	require_once (line 5)

0.72 ms
(14.14%)

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 58)
21	App\Controller\HomeController->index (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.69 ms
(13.69%)

SELECT count(DISTINCT m0_.id) AS sclr_0 FROM maison m0_

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  count(DISTINCT m0_.id) AS sclr_0
FROM
  maison m0_

SELECT count(DISTINCT m0_.id) AS sclr_0 FROM maison m0_;

#	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 43)
16	App\Controller\HomeController->index (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
(12.51%)

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 58)
21	App\Controller\HomeController->index (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.54 ms
(10.73%)

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_3b44b68686fcddfedcc1124ca86bdd11->doDisplay (line 388)
11	Twig\Template->yield (line 230)
12	__TwigTemplate_7300a0268ff2f4ca266969f1e8167e89->block_body (line 432)
13	Twig\Template->yieldBlock (line 202)
14	__TwigTemplate_07b4fca2d3cae95870f72423bc680fbe->doDisplay (line 388)
15	Twig\Template->yield (line 54)
16	__TwigTemplate_7300a0268ff2f4ca266969f1e8167e89->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 55)
25	App\Controller\HomeController->index (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.47 ms
(9.29%)

SELECT t0.id AS id_1, t0.titre AS titre_2, t0.adresse AS adresse_3, t0.dimension AS dimension_4, t0.loyer AS loyer_5, t0.typelectrification AS typelectrification_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.description AS description_9, t0.piece AS piece_10, t0.bedrooms AS bedrooms_11, t0.sold AS sold_12, t0.garage AS garage_13, t0.devise AS devise_14, t0.is_visible AS is_visible_15, t0.utilisateur_id AS utilisateur_id_16, t0.type_id AS type_id_17 FROM maison t0 WHERE t0.sold = ? AND t0.is_visible = ? ORDER BY t0.updated_at ASC LIMIT 4

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.titre AS titre_2,
  t0.adresse AS adresse_3,
  t0.dimension AS dimension_4,
  t0.loyer AS loyer_5,
  t0.typelectrification AS typelectrification_6,
  t0.created_at AS created_at_7,
  t0.updated_at AS updated_at_8,
  t0.description AS description_9,
  t0.piece AS piece_10,
  t0.bedrooms AS bedrooms_11,
  t0.sold AS sold_12,
  t0.garage AS garage_13,
  t0.devise AS devise_14,
  t0.is_visible AS is_visible_15,
  t0.utilisateur_id AS utilisateur_id_16,
  t0.type_id AS type_id_17
FROM
  maison t0
WHERE
  t0.sold = ?
  AND t0.is_visible = ?
ORDER BY
  t0.updated_at ASC
LIMIT
  4

SELECT t0.id AS id_1, t0.titre AS titre_2, t0.adresse AS adresse_3, t0.dimension AS dimension_4, t0.loyer AS loyer_5, t0.typelectrification AS typelectrification_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.description AS description_9, t0.piece AS piece_10, t0.bedrooms AS bedrooms_11, t0.sold AS sold_12, t0.garage AS garage_13, t0.devise AS devise_14, t0.is_visible AS is_visible_15, t0.utilisateur_id AS utilisateur_id_16, t0.type_id AS type_id_17 FROM maison t0 WHERE t0.sold = 1 AND t0.is_visible = 1 ORDER BY t0.updated_at ASC LIMIT 4;

#	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 57)
5	App\Controller\HomeController->index (line 183)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
8	Symfony\Component\HttpKernel\Kernel->handle (line 35)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
10	require_once (line 5)

0.36 ms
(7.13%)

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_.id IN (?) ORDER BY m0_.updated_at ASC

Parameters:

[
  1
]

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_.id IN (?)
ORDER BY
  m0_.updated_at ASC

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_.id IN (1) ORDER BY m0_.updated_at 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 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 43)
16	App\Controller\HomeController->index (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.33 ms
(6.55%)

SELECT DISTINCT m0_.id AS id_0, m0_.updated_at AS updated_at_1 FROM maison m0_ ORDER BY m0_.updated_at ASC LIMIT 12

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT m0_.id AS id_0,
  m0_.updated_at AS updated_at_1
FROM
  maison m0_
ORDER BY
  m0_.updated_at ASC
LIMIT
  12

SELECT DISTINCT m0_.id AS id_0, m0_.updated_at AS updated_at_1 FROM maison m0_ ORDER BY m0_.updated_at ASC 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 43)
16	App\Controller\HomeController->index (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)

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	1

Entities Mapping

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

Symfony Profiler

GET https://home-search.org/

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping