Symfony Profiler

Query Metrics

7 Database Queries

6 Different statements

3.69 ms Query time

0 Invalid entities

30 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

1.25 ms
(33.95%)

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.parcelle_id AS parcelle_id_5 FROM parcelle_images t0 WHERE t0.parcelle_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.parcelle_id AS parcelle_id_5
FROM
  parcelle_images t0
WHERE
  t0.parcelle_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.parcelle_id AS parcelle_id_5 FROM parcelle_images t0 WHERE t0.parcelle_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_4392407a88c89354d94725ce1c378e6b->doDisplay (line 388)
11	Twig\Template->yield (line 250)
12	__TwigTemplate_ca9d980f37cb31b58dc9aa312c6a5742->block_body (line 432)
13	Twig\Template->yieldBlock (line 202)
14	__TwigTemplate_07b4fca2d3cae95870f72423bc680fbe->doDisplay (line 388)
15	Twig\Template->yield (line 54)
16	__TwigTemplate_ca9d980f37cb31b58dc9aa312c6a5742->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 160)
25	App\Controller\HomeController->concession (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.92 ms
(24.77%)

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

Parameters:

View formatted query View runnable query Explain query View query backtrace

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

SELECT count(DISTINCT p0_.id) AS sclr_0 FROM parcelle p0_ WHERE p0_.sold = 0 AND p0_.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 155)
16	App\Controller\HomeController->concession (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.65 ms
(17.57%)

SELECT p0_.id AS id_0, p0_.name AS name_1 FROM parcelle_options p0_

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.id AS id_0,
  p0_.name AS name_1
FROM
  parcelle_options p0_

SELECT p0_.id AS id_0, p0_.name AS name_1 FROM parcelle_options p0_;

#	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 162)
21	App\Controller\HomeController->concession (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.32 ms
(8.55%)

SELECT t0.id AS id_1, t0.name AS name_2 FROM `option` t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2
FROM
  `option` t0

SELECT t0.id AS id_1, t0.name AS name_2 FROM `option` 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 163)
6	App\Controller\HomeController->concession (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)

0.31 ms
(8.47%)

SELECT p0_.id AS id_0, p0_.titre AS titre_1, p0_.prix AS prix_2, p0_.adresse AS adresse_3, p0_.created_at AS created_at_4, p0_.updated_at AS updated_at_5, p0_.description AS description_6, p0_.sold AS sold_7, p0_.devise AS devise_8, p0_.is_visible AS is_visible_9, p0_.largeur AS largeur_10, p0_.longueur AS longueur_11, p0_.utilisateur_id AS utilisateur_id_12 FROM parcelle p0_ WHERE p0_.sold = ? AND p0_.is_visible = ? AND p0_.id IN (?, ?)

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.id AS id_0,
  p0_.titre AS titre_1,
  p0_.prix AS prix_2,
  p0_.adresse AS adresse_3,
  p0_.created_at AS created_at_4,
  p0_.updated_at AS updated_at_5,
  p0_.description AS description_6,
  p0_.sold AS sold_7,
  p0_.devise AS devise_8,
  p0_.is_visible AS is_visible_9,
  p0_.largeur AS largeur_10,
  p0_.longueur AS longueur_11,
  p0_.utilisateur_id AS utilisateur_id_12
FROM
  parcelle p0_
WHERE
  p0_.sold = ?
  AND p0_.is_visible = ?
  AND p0_.id IN (?, ?)

SELECT p0_.id AS id_0, p0_.titre AS titre_1, p0_.prix AS prix_2, p0_.adresse AS adresse_3, p0_.created_at AS created_at_4, p0_.updated_at AS updated_at_5, p0_.description AS description_6, p0_.sold AS sold_7, p0_.devise AS devise_8, p0_.is_visible AS is_visible_9, p0_.largeur AS largeur_10, p0_.longueur AS longueur_11, p0_.utilisateur_id AS utilisateur_id_12 FROM parcelle p0_ WHERE p0_.sold = 0 AND p0_.is_visible = 1 AND p0_.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 155)
16	App\Controller\HomeController->concession (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.25 ms
(6.69%)

SELECT DISTINCT p0_.id AS id_0 FROM parcelle p0_ WHERE p0_.sold = ? AND p0_.is_visible = ? LIMIT 12

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT p0_.id AS id_0
FROM
  parcelle p0_
WHERE
  p0_.sold = ?
  AND p0_.is_visible = ?
LIMIT
  12

SELECT DISTINCT p0_.id AS id_0 FROM parcelle p0_ WHERE p0_.sold = 0 AND p0_.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 155)
16	App\Controller\HomeController->concession (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\ParcelleImages	17
App\Entity\Option	9
App\Entity\Parcelle	2
App\Entity\ParcelleOptions	2

Entities Mapping

Class	Mapping errors
App\Entity\ParcelleOptions	No errors.
App\Entity\Parcelle	No errors.
App\Entity\Utilisateur	No errors.
App\Entity\ParcelleImages	No errors.
App\Entity\Option	No errors.
App\Entity\Maison	No errors.

Symfony Profiler

GET http://www.home-search.org/concession

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping