Symfony Profiler

Query Metrics

12 Database Queries

2 Different statements

5.70 ms Query time

0 Invalid entities

10 Managed entities

Grouped Statements

Show all queries

default connection

Time▼

Count

Info

4.69 ms
(82.43%)

SELECT a.* FROM (SELECT t0.locale AS LOCALE_1, t0.country AS COUNTRY_2, t0.lang AS LANG_3, t0.flag AS FLAG_4, t0.country_native AS COUNTRY_NATIVE_5, t0.sub_languages AS SUB_LANGUAGES_6 FROM LANGUAGES t0 WHERE t0.locale = ?) a WHERE ROWNUM <= 1

Parameters:

[
  "fr_fr"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  a.*
FROM
  (
    SELECT
      t0.locale AS LOCALE_1,
      t0.country AS COUNTRY_2,
      t0.lang AS LANG_3,
      t0.flag AS FLAG_4,
      t0.country_native AS COUNTRY_NATIVE_5,
      t0.sub_languages AS SUB_LANGUAGES_6
    FROM
      LANGUAGES t0
    WHERE
      t0.locale = ?
  ) a
WHERE
  ROWNUM <= 1

SELECT a.* FROM (SELECT t0.locale AS LOCALE_1, t0.country AS COUNTRY_2, t0.lang AS LANG_3, t0.flag AS FLAG_4, t0.country_native AS COUNTRY_NATIVE_5, t0.sub_languages AS SUB_LANGUAGES_6 FROM LANGUAGES t0 WHERE t0.locale = 'fr_fr') a WHERE ROWNUM <= 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\EntityRepository->findOneBy (line 125)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 81)
4	App\Service\PlatformLanguages->getLanguageEntity (line 166)
5	App\Service\PlatformLanguages->formatLanguages (line 128)
6	App\Service\PlatformLanguages->getPlatformLocales (line 32)
7	App\Controller\DefaultController->home (line 60)
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 6)

1.00 ms
(17.57%)

ALTER SESSION SET NLS_TIME_FORMAT = 'HH24:MI:SS' NLS_DATE_FORMAT = 'YYYY-MM-DD HH24:MI:SS' NLS_TIMESTAMP_FORMAT = 'YYYY-MM-DD HH24:MI:SS' NLS_TIMESTAMP_TZ_FORMAT = 'YYYY-MM-DD HH24:MI:SS TZH:TZM' NLS_NUMERIC_CHARACTERS = '.,' NLS_DATE_LANGUAGE = 'AMERICAN'

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

ALTER SESSION
SET
  NLS_TIME_FORMAT = 'HH24:MI:SS' NLS_DATE_FORMAT = 'YYYY-MM-DD HH24:MI:SS' NLS_TIMESTAMP_FORMAT = 'YYYY-MM-DD HH24:MI:SS' NLS_TIMESTAMP_TZ_FORMAT = 'YYYY-MM-DD HH24:MI:SS TZH:TZM' NLS_NUMERIC_CHARACTERS = '.,' NLS_DATE_LANGUAGE = 'AMERICAN'

ALTER SESSION SET NLS_TIME_FORMAT = 'HH24:MI:SS' NLS_DATE_FORMAT = 'YYYY-MM-DD HH24:MI:SS' NLS_TIMESTAMP_FORMAT = 'YYYY-MM-DD HH24:MI:SS' NLS_TIMESTAMP_TZ_FORMAT = 'YYYY-MM-DD HH24:MI:SS TZH:TZM' NLS_NUMERIC_CHARACTERS = '.,' NLS_DATE_LANGUAGE = 'AMERICAN';

#	File/Call
1	Doctrine\DBAL\Event\Listeners\OracleSessionInit->postConnect (line 67)
2	Symfony\Bridge\Doctrine\ContainerAwareEventManager->dispatchEvent (line 56)
3	Doctrine\DBAL\Connection->connect (line 401)
4	Doctrine\DBAL\Connection->getWrappedConnection (line 1692)
5	Doctrine\DBAL\Connection->executeQuery (line 1087)
6	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
7	Doctrine\ORM\EntityRepository->findOneBy (line 125)
8	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 81)
9	App\Service\PlatformLanguages->getLanguageEntity (line 166)
10	App\Service\PlatformLanguages->formatLanguages (line 128)
11	App\Service\PlatformLanguages->getPlatformLocales (line 32)
12	App\Controller\DefaultController->home (line 60)
13	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
14	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
15	Symfony\Component\HttpKernel\Kernel->handle (line 193)
16	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
17	require_once (line 32)
18	require_once (line 6)

Database Connections

Name	Service
default	doctrine.dbal.default_connection
tiers_connection	doctrine.dbal.tiers_connection_connection
reponses_connection	doctrine.dbal.reponses_connection_connection
guests_connection	doctrine.dbal.guests_connection_connection

Entity Managers

Name	Service
default	doctrine.orm.default_entity_manager
tiers_manager	doctrine.orm.tiers_manager_entity_manager
reponses_manager	doctrine.orm.reponses_manager_entity_manager
guests	doctrine.orm.guests_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

default entity manager

Class	Amount of managed objects
App\Entity\Meta\Languages	10

tiers_manager entity manager

Class	Amount of managed objects

reponses_manager entity manager

Class	Amount of managed objects

guests entity manager

Class	Amount of managed objects

Entities Mapping

default entity manager

Class	Mapping errors
App\Entity\Default\Patient	No errors.
App\Entity\Default\PatientPatient	No errors.
App\Entity\Meta\Languages	No errors.
App\Entity\Default\Facility	No errors.

tiers_manager entity manager

Class	Mapping errors
App\Entity\Tiers\PatientIdentity	No errors.

reponses_manager entity manager

No loaded entities.

guests entity manager

No loaded entities.

Symfony Profiler

GET http://test-ws-garmin.unicancer.fr/

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

default connection

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

tiers_manager entity manager

reponses_manager entity manager

guests entity manager

Entities Mapping

default entity manager

tiers_manager entity manager

reponses_manager entity manager

guests entity manager