Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

5 Database Queries

4 Different statements

2.29 ms Query time

0 Invalid entities

Time▼

Count

Info

1.32 ms
(57.77%)

SELECT t0.id AS id_1, t0.code AS code_2 FROM oo_users_locale t0 WHERE t0.code = ? LIMIT 1

Parameters:

[
  "en"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.code AS code_2
FROM
  oo_users_locale t0
WHERE
  t0.code = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.code AS code_2 FROM oo_users_locale t0 WHERE t0.code = 'en' LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 779)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 240)
3	Doctrine\ORM\EntityRepository->findOneBy (line 29)
4	OneOrtho\UserBundle\Translation\Subscriber\LocaleSubscriber->onKernelRequest (line 118)
5	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 230)
6	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 59)
7	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 154)
8	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 157)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
13	require_once (line 5)
14	require (line 13)

0.38 ms
(16.51%)

SELECT t0.id AS id_1, t0.days_gap AS days_gap_2 FROM oci_kn3d_intervention_transfer_deadline t0 LIMIT 1

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.days_gap AS days_gap_2
FROM
  oci_kn3d_intervention_transfer_deadline t0
LIMIT
  1

SELECT t0.id AS id_1, t0.days_gap AS days_gap_2 FROM oci_kn3d_intervention_transfer_deadline t0 LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 779)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 240)
3	Doctrine\ORM\EntityRepository->findOneBy (line 19)
4	OneOrtho\Module3DKneeBundle\Service\InterventionExpirationChecker->__construct (line 2603)
5	ContainerCUqcZSx\Astem_KernelDevDebugContainer::getInterventionExpirationCheckerService (line 1512)
6	ContainerCUqcZSx\Astem_KernelDevDebugContainer::get_Container_Private_TwigService (line 999)
7	ContainerCUqcZSx\Astem_KernelDevDebugContainer::get_Container_Private_ProfilerService (line 3947)
8	ContainerCUqcZSx\Astem_KernelDevDebugContainer::getProfilerListenerService (line 1939)
9	ContainerCUqcZSx\Astem_KernelDevDebugContainer::ContainerCUqcZSx\{closure} (line 245)
10	Symfony\Component\EventDispatcher\EventDispatcher->sortListeners (line 76)
11	Symfony\Component\EventDispatcher\EventDispatcher->getListeners (line 293)
12	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->preProcess (line 148)
13	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 239)
14	Symfony\Component\HttpKernel\HttpKernel->handleThrowable (line 132)
15	Symfony\Component\HttpKernel\HttpKernel->terminateWithException (line 74)
16	Symfony\Component\HttpKernel\EventListener\DebugHandlersListener::Symfony\Component\HttpKernel\EventListener\{closure} (line 537)
17	Symfony\Component\ErrorHandler\ErrorHandler->handleException (line 1)

0.30 ms
(13.19%)

SELECT t0.id AS id_1, t0.days_gap AS days_gap_2 FROM oci_hi3d_intervention_transfer_deadline t0 LIMIT 1

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.days_gap AS days_gap_2
FROM
  oci_hi3d_intervention_transfer_deadline t0
LIMIT
  1

SELECT t0.id AS id_1, t0.days_gap AS days_gap_2 FROM oci_hi3d_intervention_transfer_deadline t0 LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 779)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 240)
3	Doctrine\ORM\EntityRepository->findOneBy (line 19)
4	OneOrtho\Module3DHipBundle\Service\InterventionExpirationChecker->__construct (line 2583)
5	ContainerCUqcZSx\Astem_KernelDevDebugContainer::getInterventionExpirationChecker2Service (line 1516)
6	ContainerCUqcZSx\Astem_KernelDevDebugContainer::get_Container_Private_TwigService (line 999)
7	ContainerCUqcZSx\Astem_KernelDevDebugContainer::get_Container_Private_ProfilerService (line 3947)
8	ContainerCUqcZSx\Astem_KernelDevDebugContainer::getProfilerListenerService (line 1939)
9	ContainerCUqcZSx\Astem_KernelDevDebugContainer::ContainerCUqcZSx\{closure} (line 245)
10	Symfony\Component\EventDispatcher\EventDispatcher->sortListeners (line 76)
11	Symfony\Component\EventDispatcher\EventDispatcher->getListeners (line 293)
12	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->preProcess (line 148)
13	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 239)
14	Symfony\Component\HttpKernel\HttpKernel->handleThrowable (line 132)
15	Symfony\Component\HttpKernel\HttpKernel->terminateWithException (line 74)
16	Symfony\Component\HttpKernel\EventListener\DebugHandlersListener::Symfony\Component\HttpKernel\EventListener\{closure} (line 537)
17	Symfony\Component\ErrorHandler\ErrorHandler->handleException (line 1)

0.29 ms
(12.53%)

SELECT t0.id AS id_1, t0.days_gap AS days_gap_2 FROM oci_sh3d_intervention_transfer_deadline t0 LIMIT 1

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.days_gap AS days_gap_2
FROM
  oci_sh3d_intervention_transfer_deadline t0
LIMIT
  1

SELECT t0.id AS id_1, t0.days_gap AS days_gap_2 FROM oci_sh3d_intervention_transfer_deadline t0 LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 779)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 240)
3	Doctrine\ORM\EntityRepository->findOneBy (line 19)
4	OneOrtho\Module3DShoulderBundle\Service\InterventionExpirationChecker->__construct (line 2623)
5	ContainerCUqcZSx\Astem_KernelDevDebugContainer::getInterventionExpirationChecker3Service (line 1519)
6	ContainerCUqcZSx\Astem_KernelDevDebugContainer::get_Container_Private_TwigService (line 999)
7	ContainerCUqcZSx\Astem_KernelDevDebugContainer::get_Container_Private_ProfilerService (line 3947)
8	ContainerCUqcZSx\Astem_KernelDevDebugContainer::getProfilerListenerService (line 1939)
9	ContainerCUqcZSx\Astem_KernelDevDebugContainer::ContainerCUqcZSx\{closure} (line 245)
10	Symfony\Component\EventDispatcher\EventDispatcher->sortListeners (line 76)
11	Symfony\Component\EventDispatcher\EventDispatcher->getListeners (line 293)
12	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->preProcess (line 148)
13	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 239)
14	Symfony\Component\HttpKernel\HttpKernel->handleThrowable (line 132)
15	Symfony\Component\HttpKernel\HttpKernel->terminateWithException (line 74)
16	Symfony\Component\HttpKernel\EventListener\DebugHandlersListener::Symfony\Component\HttpKernel\EventListener\{closure} (line 537)
17	Symfony\Component\ErrorHandler\ErrorHandler->handleException (line 1)

Name	Service
default	doctrine.dbal.default_connection

Name	Service
default	doctrine.orm.default_entity_manager

Second Level Cache is not enabled.

Class	Mapping errors
OneOrtho\UserBundle\RegionalSettings\Entity\Locale	No errors.
OneOrtho\Module3DKneeBundle\Entity\Settings\TransferDeadline	No errors.
OneOrtho\Module3DHipBundle\Entity\Settings\TransferDeadline	No errors.
OneOrtho\Module3DShoulderBundle\Entity\Settings\TransferDeadline	No errors.