Symfony Profiler

Query Metrics

42 Database Queries

10 Different statements

8.52 ms Query time

1 Invalid entities

18 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

2.17 ms
(25.40%)

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)

2.01 ms
(23.53%)

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.24 ms
(14.51%)

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, (CASE WHEN p0_.Prix >= ? THEN p0_.Prix - ? ELSE ? - p0_.Prix END) AS sclr_27, p0_.IDStatutPropriete AS IDStatutPropriete_28, p0_.IDTypePropriete AS IDTypePropriete_29, p0_.IDUtilisateurCreate AS IDUtilisateurCreate_30 FROM propriete p0_ WHERE p0_.IDTypePropriete = ? AND p0_.IDPropriete <> ? AND p0_.EstActif = 1 ORDER BY sclr_27 ASC LIMIT 3

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,
  (
    CASE WHEN p0_.Prix >= ? THEN
      p0_.Prix - ?
    ELSE
      ? - p0_.Prix
    END
  ) AS sclr_27,
  p0_.IDStatutPropriete AS IDStatutPropriete_28,
  p0_.IDTypePropriete AS IDTypePropriete_29,
  p0_.IDUtilisateurCreate AS IDUtilisateurCreate_30
FROM
  propriete p0_
WHERE
  p0_.IDTypePropriete = ?
  AND p0_.IDPropriete <> ?
  AND p0_.EstActif = 1
ORDER BY
  sclr_27 ASC
LIMIT
  3

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, (CASE WHEN p0_.Prix >= 3200 THEN p0_.Prix - 3200 ELSE 3200 - p0_.Prix END) AS sclr_27, p0_.IDStatutPropriete AS IDStatutPropriete_28, p0_.IDTypePropriete AS IDTypePropriete_29, p0_.IDUtilisateurCreate AS IDUtilisateurCreate_30 FROM propriete p0_ WHERE p0_.IDTypePropriete = 2 AND p0_.IDPropriete <> 34 AND p0_.EstActif = 1 ORDER BY sclr_27 ASC LIMIT 3;

#	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\Controller\Public\ProprieteController->index (line 32)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
9	Symfony\Component\HttpKernel\Kernel->handle (line 193)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
11	require_once (line 32)
12	require_once (line 5)

0.77 ms
(9.04%)

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 INNER JOIN propriete_equipement ON t0.IDEquipement = propriete_equipement.IDEquipement WHERE propriete_equipement.IDPropriete = ?

Parameters:

[
  34
]

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
  INNER JOIN propriete_equipement ON t0.IDEquipement = propriete_equipement.IDEquipement
WHERE
  propriete_equipement.IDPropriete = ?

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 INNER JOIN propriete_equipement ON t0.IDEquipement = propriete_equipement.IDEquipement WHERE propriete_equipement.IDPropriete = 34;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getManyToManyStatement (line 1106)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadManyToManyCollection (line 1035)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2733)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 315)
7	__TwigTemplate_2cde7022a687324157e52382e0ba586f->block_body (line 1151)
8	Twig\Template->yieldBlock (line 446)
9	__TwigTemplate_b173f8b0c09319e409bcf5e1c9dd771b->doDisplay (line 1004)
10	Twig\Template->yield (line 402)
11	__TwigTemplate_2cde7022a687324157e52382e0ba586f->doDisplay (line 59)
12	Twig\Template->yield (line 402)
13	Twig\Template->display (line 358)
14	Twig\Template->render (line 373)
15	Twig\TemplateWrapper->render (line 51)
16	Twig\Environment->render (line 333)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
20	App\Controller\Public\ProprieteController->index (line 53)
21	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
22	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
23	Symfony\Component\HttpKernel\Kernel->handle (line 193)
24	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
25	require_once (line 32)
26	require_once (line 5)

0.62 ms
(7.32%)

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:

[
  34
]

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 = 34;

#	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->count (line 41)
7	Doctrine\ORM\PersistentCollection->count (line 391)
8	Twig\Extension\CoreExtension->length (line 1278)
9	__TwigTemplate_2cde7022a687324157e52382e0ba586f::block_body (line 722)
10	Twig\Template->yieldBlock (line 446)
11	__TwigTemplate_b173f8b0c09319e409bcf5e1c9dd771b->doDisplay (line 1004)
12	Twig\Template->yield (line 402)
13	__TwigTemplate_2cde7022a687324157e52382e0ba586f->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\Public\ProprieteController->index (line 53)
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.60 ms
(6.99%)

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.IDPropriete = ?

Parameters:

[
  "34"
]

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.IDPropriete = ?

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.IDPropriete = '34';

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
3	Doctrine\ORM\EntityManager->find (line 366)
4	Doctrine\ORM\EntityRepository->find (line 86)
5	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->find (line 61)
6	Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->find (line 129)
7	Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->resolve (line 69)
8	Symfony\Component\HttpKernel\Controller\ArgumentResolver\TraceableValueResolver->resolve (line 37)
9	Symfony\Component\HttpKernel\Controller\ArgumentResolver->getArguments (line 91)
10	Symfony\Component\HttpKernel\Controller\TraceableArgumentResolver->getArguments (line 33)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 175)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
13	Symfony\Component\HttpKernel\Kernel->handle (line 193)
14	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
15	require_once (line 32)
16	require_once (line 5)

0.55 ms
(6.48%)

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_2cde7022a687324157e52382e0ba586f->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\Public\ProprieteController->index (line 53)
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.22 ms
(2.62%)

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.19 ms
(2.27%)

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.IDTypePropriete = ?

Parameters:

[
  2
]

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.IDTypePropriete = ?

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.IDTypePropriete = 2;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
3	Doctrine\ORM\Proxy\ProxyFactory->{closure:Doctrine\ORM\Proxy\ProxyFactory::createLazyInitializer():294} (line 295)
4	Proxies\__CG__\App\Entity\Typepropriete::{closure:{closure:Doctrine\ORM\Proxy\ProxyFactory::getProxyFactory():371}:372} (line 373)
5	Symfony\Component\VarExporter\Internal\LazyObjectState::initialize (line 60)
6	Proxies\__CG__\App\Entity\Typepropriete->__get (line 153)
7	App\Entity\Typepropriete->getLibelleEn (line 78)
8	Twig\Extension\CoreExtension->getAttribute (line 1919)
9	__TwigTemplate_2cde7022a687324157e52382e0ba586f::block_body (line 867)
10	Twig\Template->yieldBlock (line 446)
11	__TwigTemplate_b173f8b0c09319e409bcf5e1c9dd771b->doDisplay (line 1004)
12	Twig\Template->yield (line 402)
13	__TwigTemplate_2cde7022a687324157e52382e0ba586f->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\Public\ProprieteController->index (line 53)
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.16 ms
(1.84%)

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 WHERE t0.IDStatutPropriete = ?

Parameters:

[
  1
]

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
WHERE
  t0.IDStatutPropriete = ?

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 WHERE t0.IDStatutPropriete = 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
3	Doctrine\ORM\Proxy\ProxyFactory->{closure:Doctrine\ORM\Proxy\ProxyFactory::createLazyInitializer():294} (line 295)
4	Proxies\__CG__\App\Entity\Statutpropriete::{closure:{closure:Doctrine\ORM\Proxy\ProxyFactory::getProxyFactory():371}:372} (line 373)
5	Symfony\Component\VarExporter\Internal\LazyObjectState::initialize (line 60)
6	Proxies\__CG__\App\Entity\Statutpropriete->__get (line 153)
7	App\Entity\Statutpropriete->getCouleur (line 50)
8	Twig\Extension\CoreExtension->getAttribute (line 1919)
9	__TwigTemplate_2cde7022a687324157e52382e0ba586f::block_body (line 871)
10	Twig\Template->yieldBlock (line 446)
11	__TwigTemplate_b173f8b0c09319e409bcf5e1c9dd771b->doDisplay (line 1004)
12	Twig\Template->yield (line 402)
13	__TwigTemplate_2cde7022a687324157e52382e0ba586f->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\Public\ProprieteController->index (line 53)
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)

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	6
App\Entity\Parametre	4
App\Entity\Propriete	4
App\Entity\Devise	1
App\Entity\Unitemesure	1
App\Entity\Statutpropriete	1
App\Entity\Typepropriete	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.

Symfony Profiler

GET https://lac-invest.devsoft-pro.net/propriete/418465343218945645

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping