Symfony Profiler

Query Metrics

102 Database Queries

15 Different statements

20.18 ms Query time

1 Invalid entities

31 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

6.81 ms
(33.75%)

SELECT t0.IDDevise AS IDDevise_1, t0.LibelleDevise AS LibelleDevise_2, t0.EstActif AS EstActif_3, t0.TauxConversion AS TauxConversion_4, t0.Symbole AS Symbole_5 FROM devise t0 WHERE t0.LibelleDevise = ? LIMIT 1

Parameters:

[
  "US Dollar"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.IDDevise AS IDDevise_1,
  t0.LibelleDevise AS LibelleDevise_2,
  t0.EstActif AS EstActif_3,
  t0.TauxConversion AS TauxConversion_4,
  t0.Symbole AS Symbole_5
FROM
  devise t0
WHERE
  t0.LibelleDevise = ?
LIMIT
  1

SELECT t0.IDDevise AS IDDevise_1, t0.LibelleDevise AS LibelleDevise_2, t0.EstActif AS EstActif_3, t0.TauxConversion AS TauxConversion_4, t0.Symbole AS Symbole_5 FROM devise t0 WHERE t0.LibelleDevise = 'US Dollar' LIMIT 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\EntityRepository->findOneBy (line 125)
3	App\Service\UserPreferencesService->getPreferences (line 37)
4	App\EventSubscriber\FrontOfficePreferencesSubscriber->onKernelRequest (line 41)
5	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
6	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
7	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
8	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 129)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
11	Symfony\Component\HttpKernel\Kernel->handle (line 193)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
13	require_once (line 32)
14	require_once (line 5)

6.39 ms
(31.67%)

SELECT t0.IDUniteMesure AS IDUniteMesure_1, t0.Libelle_FR AS Libelle_FR_2, t0.EstActif AS EstActif_3, t0.Tauxconversion AS Tauxconversion_4, t0.Libelle_EN AS Libelle_EN_5, t0.Libelle_LU AS Libelle_LU_6, t0.Symbole AS Symbole_7 FROM unitemesure t0 WHERE t0.Libelle_EN = ? LIMIT 1

Parameters:

[
  "Square foot"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.IDUniteMesure AS IDUniteMesure_1,
  t0.Libelle_FR AS Libelle_FR_2,
  t0.EstActif AS EstActif_3,
  t0.Tauxconversion AS Tauxconversion_4,
  t0.Libelle_EN AS Libelle_EN_5,
  t0.Libelle_LU AS Libelle_LU_6,
  t0.Symbole AS Symbole_7
FROM
  unitemesure t0
WHERE
  t0.Libelle_EN = ?
LIMIT
  1

SELECT t0.IDUniteMesure AS IDUniteMesure_1, t0.Libelle_FR AS Libelle_FR_2, t0.EstActif AS EstActif_3, t0.Tauxconversion AS Tauxconversion_4, t0.Libelle_EN AS Libelle_EN_5, t0.Libelle_LU AS Libelle_LU_6, t0.Symbole AS Symbole_7 FROM unitemesure t0 WHERE t0.Libelle_EN = 'Square foot' LIMIT 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\EntityRepository->findOneBy (line 125)
3	App\Service\UserPreferencesService->getPreferences (line 40)
4	App\EventSubscriber\FrontOfficePreferencesSubscriber->onKernelRequest (line 41)
5	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
6	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
7	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
8	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 129)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
11	Symfony\Component\HttpKernel\Kernel->handle (line 193)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
13	require_once (line 32)
14	require_once (line 5)

1.33 ms
(6.57%)

SELECT count(DISTINCT p0_.IDPropriete) AS sclr_0 FROM propriete p0_ WHERE p0_.EstActif = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  count(DISTINCT p0_.IDPropriete) AS sclr_0
FROM
  propriete p0_
WHERE
  p0_.EstActif = ?

SELECT count(DISTINCT p0_.IDPropriete) AS sclr_0 FROM propriete p0_ WHERE p0_.EstActif = 1;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getScalarResult (line 724)
6	Doctrine\ORM\Tools\Pagination\Paginator->count (line 96)
7	count (line 43)
8	Knp\Component\Pager\Event\Subscriber\Paginate\Doctrine\ORM\QuerySubscriber::items (line 43)
9	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
10	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
11	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
12	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 129)
13	Knp\Component\Pager\Paginator->paginate (line 97)
14	ContainerWIx8n57\PaginatorProxyBa079e5->paginate (line 20)
15	App\Controller\HomeController->index (line 55)
16	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
17	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
18	Symfony\Component\HttpKernel\Kernel->handle (line 193)
19	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
20	require_once (line 32)
21	require_once (line 5)

1.27 ms
(6.27%)

SELECT DISTINCT p0_.IDPropriete AS IDPropriete_0, p0_.IDPropriete AS IDPropriete_1 FROM propriete p0_ WHERE p0_.EstActif = ? ORDER BY p0_.IDPropriete DESC LIMIT 9 OFFSET 9

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT p0_.IDPropriete AS IDPropriete_0,
  p0_.IDPropriete AS IDPropriete_1
FROM
  propriete p0_
WHERE
  p0_.EstActif = ?
ORDER BY
  p0_.IDPropriete DESC
LIMIT
  9
OFFSET
  9

SELECT DISTINCT p0_.IDPropriete AS IDPropriete_0, p0_.IDPropriete AS IDPropriete_1 FROM propriete p0_ WHERE p0_.EstActif = 1 ORDER BY p0_.IDPropriete DESC LIMIT 9 OFFSET 9;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getScalarResult (line 724)
6	Doctrine\ORM\Tools\Pagination\Paginator->getIterator (line 127)
7	iterator_to_array (line 45)
8	Knp\Component\Pager\Event\Subscriber\Paginate\Doctrine\ORM\QuerySubscriber::items (line 45)
9	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
10	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
11	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
12	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 129)
13	Knp\Component\Pager\Paginator->paginate (line 97)
14	ContainerWIx8n57\PaginatorProxyBa079e5->paginate (line 20)
15	App\Controller\HomeController->index (line 55)
16	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
17	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
18	Symfony\Component\HttpKernel\Kernel->handle (line 193)
19	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
20	require_once (line 32)
21	require_once (line 5)

1.08 ms
(5.37%)

SELECT p0_.IDPropriete AS IDPropriete_0, p0_.Reference AS Reference_1, p0_.TitreFR AS TitreFR_2, p0_.DescriptionLongueFR AS DescriptionLongueFR_3, p0_.Prix AS Prix_4, p0_.AncienPrix AS AncienPrix_5, p0_.Localisation AS Localisation_6, p0_.Adresse AS Adresse_7, p0_.NbChambres AS NbChambres_8, p0_.NbSalleBains AS NbSalleBains_9, p0_.Surface AS Surface_10, p0_.Parking AS Parking_11, p0_.EstActif AS EstActif_12, p0_.AnneeConstruction AS AnneeConstruction_13, p0_.DateCreation AS DateCreation_14, p0_.DateModif AS DateModif_15, p0_.NomProprietaire AS NomProprietaire_16, p0_.AdresseProprietaire AS AdresseProprietaire_17, p0_.TelProprietaire AS TelProprietaire_18, p0_.EmailProprietaire AS EmailProprietaire_19, p0_.TitreEN AS TitreEN_20, p0_.TitreLU AS TitreLU_21, p0_.DescCourteFR AS DescCourteFR_22, p0_.DescCourteEN AS DescCourteEN_23, p0_.DescCourteLU AS DescCourteLU_24, p0_.DescriptionLongEN AS DescriptionLongEN_25, p0_.DescriptionLongLU AS DescriptionLongLU_26, p0_.IDStatutPropriete AS IDStatutPropriete_27, p0_.IDTypePropriete AS IDTypePropriete_28, p0_.IDUtilisateurCreate AS IDUtilisateurCreate_29 FROM propriete p0_ WHERE p0_.EstActif = ? AND p0_.IDPropriete IN (?, ?, ?, ?) ORDER BY p0_.IDPropriete DESC

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.IDPropriete AS IDPropriete_0,
  p0_.Reference AS Reference_1,
  p0_.TitreFR AS TitreFR_2,
  p0_.DescriptionLongueFR AS DescriptionLongueFR_3,
  p0_.Prix AS Prix_4,
  p0_.AncienPrix AS AncienPrix_5,
  p0_.Localisation AS Localisation_6,
  p0_.Adresse AS Adresse_7,
  p0_.NbChambres AS NbChambres_8,
  p0_.NbSalleBains AS NbSalleBains_9,
  p0_.Surface AS Surface_10,
  p0_.Parking AS Parking_11,
  p0_.EstActif AS EstActif_12,
  p0_.AnneeConstruction AS AnneeConstruction_13,
  p0_.DateCreation AS DateCreation_14,
  p0_.DateModif AS DateModif_15,
  p0_.NomProprietaire AS NomProprietaire_16,
  p0_.AdresseProprietaire AS AdresseProprietaire_17,
  p0_.TelProprietaire AS TelProprietaire_18,
  p0_.EmailProprietaire AS EmailProprietaire_19,
  p0_.TitreEN AS TitreEN_20,
  p0_.TitreLU AS TitreLU_21,
  p0_.DescCourteFR AS DescCourteFR_22,
  p0_.DescCourteEN AS DescCourteEN_23,
  p0_.DescCourteLU AS DescCourteLU_24,
  p0_.DescriptionLongEN AS DescriptionLongEN_25,
  p0_.DescriptionLongLU AS DescriptionLongLU_26,
  p0_.IDStatutPropriete AS IDStatutPropriete_27,
  p0_.IDTypePropriete AS IDTypePropriete_28,
  p0_.IDUtilisateurCreate AS IDUtilisateurCreate_29
FROM
  propriete p0_
WHERE
  p0_.EstActif = ?
  AND p0_.IDPropriete IN (?, ?, ?, ?)
ORDER BY
  p0_.IDPropriete DESC

SELECT p0_.IDPropriete AS IDPropriete_0, p0_.Reference AS Reference_1, p0_.TitreFR AS TitreFR_2, p0_.DescriptionLongueFR AS DescriptionLongueFR_3, p0_.Prix AS Prix_4, p0_.AncienPrix AS AncienPrix_5, p0_.Localisation AS Localisation_6, p0_.Adresse AS Adresse_7, p0_.NbChambres AS NbChambres_8, p0_.NbSalleBains AS NbSalleBains_9, p0_.Surface AS Surface_10, p0_.Parking AS Parking_11, p0_.EstActif AS EstActif_12, p0_.AnneeConstruction AS AnneeConstruction_13, p0_.DateCreation AS DateCreation_14, p0_.DateModif AS DateModif_15, p0_.NomProprietaire AS NomProprietaire_16, p0_.AdresseProprietaire AS AdresseProprietaire_17, p0_.TelProprietaire AS TelProprietaire_18, p0_.EmailProprietaire AS EmailProprietaire_19, p0_.TitreEN AS TitreEN_20, p0_.TitreLU AS TitreLU_21, p0_.DescCourteFR AS DescCourteFR_22, p0_.DescCourteEN AS DescCourteEN_23, p0_.DescCourteLU AS DescCourteLU_24, p0_.DescriptionLongEN AS DescriptionLongEN_25, p0_.DescriptionLongLU AS DescriptionLongLU_26, p0_.IDStatutPropriete AS IDStatutPropriete_27, p0_.IDTypePropriete AS IDTypePropriete_28, p0_.IDUtilisateurCreate AS IDUtilisateurCreate_29 FROM propriete p0_ WHERE p0_.EstActif = 1 AND p0_.IDPropriete IN (12, 9, 4, 3) ORDER BY p0_.IDPropriete DESC;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getResult (line 688)
6	Doctrine\ORM\Tools\Pagination\Paginator->getIterator (line 145)
7	iterator_to_array (line 45)
8	Knp\Component\Pager\Event\Subscriber\Paginate\Doctrine\ORM\QuerySubscriber::items (line 45)
9	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
10	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
11	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
12	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 129)
13	Knp\Component\Pager\Paginator->paginate (line 97)
14	ContainerWIx8n57\PaginatorProxyBa079e5->paginate (line 20)
15	App\Controller\HomeController->index (line 55)
16	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
17	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
18	Symfony\Component\HttpKernel\Kernel->handle (line 193)
19	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
20	require_once (line 32)
21	require_once (line 5)

1.00 ms
(4.93%)

SELECT t0.IDImagePropriete AS IDImagePropriete_1, t0.LienImage AS LienImage_2, t0.EstMiseEnAvant AS EstMiseEnAvant_3, t0.EstActif AS EstActif_4, t0.DateCreation AS DateCreation_5, t0.IDPropriete AS IDPropriete_6 FROM imagepropriete t0 WHERE t0.IDPropriete = ?

Parameters:

[
  12
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.IDImagePropriete AS IDImagePropriete_1,
  t0.LienImage AS LienImage_2,
  t0.EstMiseEnAvant AS EstMiseEnAvant_3,
  t0.EstActif AS EstActif_4,
  t0.DateCreation AS DateCreation_5,
  t0.IDPropriete AS IDPropriete_6
FROM
  imagepropriete t0
WHERE
  t0.IDPropriete = ?

SELECT t0.IDImagePropriete AS IDImagePropriete_1, t0.LienImage AS LienImage_2, t0.EstMiseEnAvant AS EstMiseEnAvant_3, t0.EstActif AS EstActif_4, t0.DateCreation AS DateCreation_5, t0.IDPropriete AS IDPropriete_6 FROM imagepropriete t0 WHERE t0.IDPropriete = 12;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1872)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 1817)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2729)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 315)
7	IteratorIterator->__construct (line 1980)
8	Twig\Extension\CoreExtension->filter (line 1980)
9	__TwigTemplate_7b11564b5ba03424732c0fd0eab25fab::block_banner (line 521)
10	Twig\Template->yieldBlock (line 446)
11	__TwigTemplate_b173f8b0c09319e409bcf5e1c9dd771b->doDisplay (line 998)
12	Twig\Template->yield (line 402)
13	__TwigTemplate_7b11564b5ba03424732c0fd0eab25fab->doDisplay (line 59)
14	Twig\Template->yield (line 402)
15	Twig\Template->display (line 358)
16	Twig\Template->render (line 373)
17	Twig\TemplateWrapper->render (line 51)
18	Twig\Environment->render (line 333)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
22	App\Controller\HomeController->index (line 73)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
25	Symfony\Component\HttpKernel\Kernel->handle (line 193)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
27	require_once (line 32)
28	require_once (line 5)

0.58 ms
(2.87%)

SELECT t0.IDParametre AS IDParametre_1, t0.Nom AS Nom_2, t0.Slug AS Slug_3, t0.Valeur AS Valeur_4, t0.Type AS Type_5 FROM parametre t0 WHERE t0.Slug = ? LIMIT 1

Parameters:

[
  "social_facebook"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.IDParametre AS IDParametre_1,
  t0.Nom AS Nom_2,
  t0.Slug AS Slug_3,
  t0.Valeur AS Valeur_4,
  t0.Type AS Type_5
FROM
  parametre t0
WHERE
  t0.Slug = ?
LIMIT
  1

SELECT t0.IDParametre AS IDParametre_1, t0.Nom AS Nom_2, t0.Slug AS Slug_3, t0.Valeur AS Valeur_4, t0.Type AS Type_5 FROM parametre t0 WHERE t0.Slug = 'social_facebook' LIMIT 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\EntityRepository->findOneBy (line 125)
3	App\Twig\AppExtension->getParameterValue (line 202)
4	__TwigTemplate_181614728d8730fdbd51f5aa2e24985f->doDisplay (line 210)
5	Twig\Template->yield (line 402)
6	__TwigTemplate_b173f8b0c09319e409bcf5e1c9dd771b->doDisplay (line 1010)
7	Twig\Template->yield (line 402)
8	__TwigTemplate_7b11564b5ba03424732c0fd0eab25fab->doDisplay (line 59)
9	Twig\Template->yield (line 402)
10	Twig\Template->display (line 358)
11	Twig\Template->render (line 373)
12	Twig\TemplateWrapper->render (line 51)
13	Twig\Environment->render (line 333)
14	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
15	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
16	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
17	App\Controller\HomeController->index (line 73)
18	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
19	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
20	Symfony\Component\HttpKernel\Kernel->handle (line 193)
21	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
22	require_once (line 32)
23	require_once (line 5)

0.45 ms
(2.21%)

SELECT p0_.IDParametre AS IDParametre_0, p0_.Nom AS Nom_1, p0_.Slug AS Slug_2, p0_.Valeur AS Valeur_3, p0_.Type AS Type_4 FROM parametre p0_ WHERE p0_.Slug LIKE ?

Parameters:

[
  "social_%"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.IDParametre AS IDParametre_0,
  p0_.Nom AS Nom_1,
  p0_.Slug AS Slug_2,
  p0_.Valeur AS Valeur_3,
  p0_.Type AS Type_4
FROM
  parametre p0_
WHERE
  p0_.Slug LIKE ?

SELECT p0_.IDParametre AS IDParametre_0, p0_.Nom AS Nom_1, p0_.Slug AS Slug_2, p0_.Valeur AS Valeur_3, p0_.Type AS Type_4 FROM parametre p0_ WHERE p0_.Slug LIKE 'social_%';

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getResult (line 688)
6	App\Service\UserPreferencesService->getSocialLinks (line 70)
7	App\EventSubscriber\FrontOfficePreferencesSubscriber->onKernelRequest (line 53)
8	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
9	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
10	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
11	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 129)
12	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
13	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
14	Symfony\Component\HttpKernel\Kernel->handle (line 193)
15	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
16	require_once (line 32)
17	require_once (line 5)

0.31 ms
(1.55%)

SELECT t0.IDStatutPropriete AS IDStatutPropriete_1, t0.Slug AS Slug_2, t0.Libelle_FR AS Libelle_FR_3, t0.Libelle_EN AS Libelle_EN_4, t0.Libelle_LU AS Libelle_LU_5, t0.Couleur AS Couleur_6 FROM statutpropriete t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.IDStatutPropriete AS IDStatutPropriete_1,
  t0.Slug AS Slug_2,
  t0.Libelle_FR AS Libelle_FR_3,
  t0.Libelle_EN AS Libelle_EN_4,
  t0.Libelle_LU AS Libelle_LU_5,
  t0.Couleur AS Couleur_6
FROM
  statutpropriete t0

SELECT t0.IDStatutPropriete AS IDStatutPropriete_1, t0.Slug AS Slug_2, t0.Libelle_FR AS Libelle_FR_3, t0.Libelle_EN AS Libelle_EN_4, t0.Libelle_LU AS Libelle_LU_5, t0.Couleur AS Couleur_6 FROM statutpropriete t0;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 963)
2	Doctrine\ORM\EntityRepository->findBy (line 110)
3	Doctrine\ORM\EntityRepository->findAll (line 96)
4	App\Controller\HomeController->index (line 61)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
7	Symfony\Component\HttpKernel\Kernel->handle (line 193)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
9	require_once (line 32)
10	require_once (line 5)

0.19 ms
(0.92%)

SELECT t0.IDTypePropriete AS IDTypePropriete_1, t0.Slug AS Slug_2, t0.Libelle_FR AS Libelle_FR_3, t0.EstActif AS EstActif_4, t0.Libelle_EN AS Libelle_EN_5, t0.Libelle_LU AS Libelle_LU_6, t0.Icone AS Icone_7 FROM typepropriete t0 WHERE t0.EstActif = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.IDTypePropriete AS IDTypePropriete_1,
  t0.Slug AS Slug_2,
  t0.Libelle_FR AS Libelle_FR_3,
  t0.EstActif AS EstActif_4,
  t0.Libelle_EN AS Libelle_EN_5,
  t0.Libelle_LU AS Libelle_LU_6,
  t0.Icone AS Icone_7
FROM
  typepropriete t0
WHERE
  t0.EstActif = ?

SELECT t0.IDTypePropriete AS IDTypePropriete_1, t0.Slug AS Slug_2, t0.Libelle_FR AS Libelle_FR_3, t0.EstActif AS EstActif_4, t0.Libelle_EN AS Libelle_EN_5, t0.Libelle_LU AS Libelle_LU_6, t0.Icone AS Icone_7 FROM typepropriete t0 WHERE t0.EstActif = 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 963)
2	Doctrine\ORM\EntityRepository->findBy (line 110)
3	App\Controller\HomeController->index (line 62)
4	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
5	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
6	Symfony\Component\HttpKernel\Kernel->handle (line 193)
7	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
8	require_once (line 32)
9	require_once (line 5)

0.18 ms
(0.89%)

SELECT t0.IDPropriete AS IDPropriete_1, t0.Reference AS Reference_2, t0.TitreFR AS TitreFR_3, t0.DescriptionLongueFR AS DescriptionLongueFR_4, t0.Prix AS Prix_5, t0.AncienPrix AS AncienPrix_6, t0.Localisation AS Localisation_7, t0.Adresse AS Adresse_8, t0.NbChambres AS NbChambres_9, t0.NbSalleBains AS NbSalleBains_10, t0.Surface AS Surface_11, t0.Parking AS Parking_12, t0.EstActif AS EstActif_13, t0.AnneeConstruction AS AnneeConstruction_14, t0.DateCreation AS DateCreation_15, t0.DateModif AS DateModif_16, t0.NomProprietaire AS NomProprietaire_17, t0.AdresseProprietaire AS AdresseProprietaire_18, t0.TelProprietaire AS TelProprietaire_19, t0.EmailProprietaire AS EmailProprietaire_20, t0.TitreEN AS TitreEN_21, t0.TitreLU AS TitreLU_22, t0.DescCourteFR AS DescCourteFR_23, t0.DescCourteEN AS DescCourteEN_24, t0.DescCourteLU AS DescCourteLU_25, t0.DescriptionLongEN AS DescriptionLongEN_26, t0.DescriptionLongLU AS DescriptionLongLU_27, t0.IDStatutPropriete AS IDStatutPropriete_28, t0.IDTypePropriete AS IDTypePropriete_29, t0.IDUtilisateurCreate AS IDUtilisateurCreate_30 FROM propriete t0 WHERE t0.EstActif = ? ORDER BY t0.Prix DESC LIMIT 6

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.IDPropriete AS IDPropriete_1,
  t0.Reference AS Reference_2,
  t0.TitreFR AS TitreFR_3,
  t0.DescriptionLongueFR AS DescriptionLongueFR_4,
  t0.Prix AS Prix_5,
  t0.AncienPrix AS AncienPrix_6,
  t0.Localisation AS Localisation_7,
  t0.Adresse AS Adresse_8,
  t0.NbChambres AS NbChambres_9,
  t0.NbSalleBains AS NbSalleBains_10,
  t0.Surface AS Surface_11,
  t0.Parking AS Parking_12,
  t0.EstActif AS EstActif_13,
  t0.AnneeConstruction AS AnneeConstruction_14,
  t0.DateCreation AS DateCreation_15,
  t0.DateModif AS DateModif_16,
  t0.NomProprietaire AS NomProprietaire_17,
  t0.AdresseProprietaire AS AdresseProprietaire_18,
  t0.TelProprietaire AS TelProprietaire_19,
  t0.EmailProprietaire AS EmailProprietaire_20,
  t0.TitreEN AS TitreEN_21,
  t0.TitreLU AS TitreLU_22,
  t0.DescCourteFR AS DescCourteFR_23,
  t0.DescCourteEN AS DescCourteEN_24,
  t0.DescCourteLU AS DescCourteLU_25,
  t0.DescriptionLongEN AS DescriptionLongEN_26,
  t0.DescriptionLongLU AS DescriptionLongLU_27,
  t0.IDStatutPropriete AS IDStatutPropriete_28,
  t0.IDTypePropriete AS IDTypePropriete_29,
  t0.IDUtilisateurCreate AS IDUtilisateurCreate_30
FROM
  propriete t0
WHERE
  t0.EstActif = ?
ORDER BY
  t0.Prix DESC
LIMIT
  6

SELECT t0.IDPropriete AS IDPropriete_1, t0.Reference AS Reference_2, t0.TitreFR AS TitreFR_3, t0.DescriptionLongueFR AS DescriptionLongueFR_4, t0.Prix AS Prix_5, t0.AncienPrix AS AncienPrix_6, t0.Localisation AS Localisation_7, t0.Adresse AS Adresse_8, t0.NbChambres AS NbChambres_9, t0.NbSalleBains AS NbSalleBains_10, t0.Surface AS Surface_11, t0.Parking AS Parking_12, t0.EstActif AS EstActif_13, t0.AnneeConstruction AS AnneeConstruction_14, t0.DateCreation AS DateCreation_15, t0.DateModif AS DateModif_16, t0.NomProprietaire AS NomProprietaire_17, t0.AdresseProprietaire AS AdresseProprietaire_18, t0.TelProprietaire AS TelProprietaire_19, t0.EmailProprietaire AS EmailProprietaire_20, t0.TitreEN AS TitreEN_21, t0.TitreLU AS TitreLU_22, t0.DescCourteFR AS DescCourteFR_23, t0.DescCourteEN AS DescCourteEN_24, t0.DescCourteLU AS DescCourteLU_25, t0.DescriptionLongEN AS DescriptionLongEN_26, t0.DescriptionLongLU AS DescriptionLongLU_27, t0.IDStatutPropriete AS IDStatutPropriete_28, t0.IDTypePropriete AS IDTypePropriete_29, t0.IDUtilisateurCreate AS IDUtilisateurCreate_30 FROM propriete t0 WHERE t0.EstActif = 1 ORDER BY t0.Prix DESC LIMIT 6;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 963)
2	Doctrine\ORM\EntityRepository->findBy (line 110)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 73)
4	App\Controller\HomeController->index (line 71)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
7	Symfony\Component\HttpKernel\Kernel->handle (line 193)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
9	require_once (line 32)
10	require_once (line 5)

0.18 ms
(0.87%)

SELECT MIN(p0_.Prix) AS sclr_0, MAX(p0_.Prix) AS sclr_1 FROM propriete p0_ WHERE p0_.EstActif = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  MIN(p0_.Prix) AS sclr_0,
  MAX(p0_.Prix) AS sclr_1
FROM
  propriete p0_
WHERE
  p0_.EstActif = ?

SELECT MIN(p0_.Prix) AS sclr_0, MAX(p0_.Prix) AS sclr_1 FROM propriete p0_ WHERE p0_.EstActif = 1;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getSingleResult (line 772)
6	App\Repository\ProprieteRepository->getMinMaxPrice (line 118)
7	App\Controller\HomeController->index (line 65)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 193)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
12	require_once (line 32)
13	require_once (line 5)

0.17 ms
(0.85%)

SELECT MIN(p0_.Surface) AS sclr_0, MAX(p0_.Surface) AS sclr_1 FROM propriete p0_ WHERE p0_.EstActif = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  MIN(p0_.Surface) AS sclr_0,
  MAX(p0_.Surface) AS sclr_1
FROM
  propriete p0_
WHERE
  p0_.EstActif = ?

SELECT MIN(p0_.Surface) AS sclr_0, MAX(p0_.Surface) AS sclr_1 FROM propriete p0_ WHERE p0_.EstActif = 1;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getSingleResult (line 772)
6	App\Repository\ProprieteRepository->getMinMaxSurface (line 128)
7	App\Controller\HomeController->index (line 66)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 193)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
12	require_once (line 32)
13	require_once (line 5)

0.13 ms
(0.66%)

SELECT t0.IDEquipement AS IDEquipement_1, t0.Libelle_FR AS Libelle_FR_2, t0.EstActif AS EstActif_3, t0.DateCreation AS DateCreation_4, t0.Icone AS Icone_5, t0.Libelle_EN AS Libelle_EN_6, t0.Libelle_LU AS Libelle_LU_7 FROM equipement t0 WHERE t0.EstActif = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.IDEquipement AS IDEquipement_1,
  t0.Libelle_FR AS Libelle_FR_2,
  t0.EstActif AS EstActif_3,
  t0.DateCreation AS DateCreation_4,
  t0.Icone AS Icone_5,
  t0.Libelle_EN AS Libelle_EN_6,
  t0.Libelle_LU AS Libelle_LU_7
FROM
  equipement t0
WHERE
  t0.EstActif = ?

SELECT t0.IDEquipement AS IDEquipement_1, t0.Libelle_FR AS Libelle_FR_2, t0.EstActif AS EstActif_3, t0.DateCreation AS DateCreation_4, t0.Icone AS Icone_5, t0.Libelle_EN AS Libelle_EN_6, t0.Libelle_LU AS Libelle_LU_7 FROM equipement t0 WHERE t0.EstActif = 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 963)
2	Doctrine\ORM\EntityRepository->findBy (line 110)
3	App\Controller\HomeController->index (line 63)
4	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
5	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
6	Symfony\Component\HttpKernel\Kernel->handle (line 193)
7	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
8	require_once (line 32)
9	require_once (line 5)

0.12 ms
(0.61%)

SELECT COUNT(*) FROM propriete t0 WHERE t0.EstActif = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(*)
FROM
  propriete t0
WHERE
  t0.EstActif = ?

SELECT COUNT(*) FROM propriete t0 WHERE t0.EstActif = 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->count (line 867)
2	Doctrine\ORM\EntityRepository->count (line 140)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->count (line 87)
4	App\Controller\HomeController->index (line 68)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
7	Symfony\Component\HttpKernel\Kernel->handle (line 193)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
9	require_once (line 32)
10	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\Imagepropriete	8
App\Entity\Propriete	7
App\Entity\Typepropriete	5
App\Entity\Parametre	4
App\Entity\Statutpropriete	3
App\Entity\Equipement	2
App\Entity\Devise	1
App\Entity\Unitemesure	1

Entities Mapping

Class	Mapping errors
App\Entity\Devise	No errors.
App\Entity\Unitemesure	No errors.
App\Entity\Parametre	No errors.
App\Entity\Propriete	The field App\Entity\Propriete#favoriclient is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Favoriclient#idpropriete does not contain the required 'inversedBy: "favoriclient"' attribute.
App\Entity\Statutpropriete	No errors.
App\Entity\Typepropriete	No errors.
App\Entity\Utilisateur	No errors.
App\Entity\Imagepropriete	No errors.
App\Entity\Equipement	No errors.
App\Entity\Favoriclient	No errors.
App\Entity\Equipementpropriete	No errors.

Symfony Profiler

GET https://lac-invest.devsoft-pro.net/?page=2

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping