Symfony Profiler

Query Metrics

5 Database Queries

3 Different statements

0.97 ms Query time

0 Invalid entities

6 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

0.50 ms
(51.68%)

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)

0.30 ms
(30.43%)

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)

0.17 ms
(17.89%)

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)

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\Parametre	4
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.

Symfony Profiler

GET https://lac-invest.devsoft-pro.net/login-admin

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping