Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

10 Database Queries

7 Different statements

5.17 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

1.86 ms
(36.05%)

SELECT t0.id AS id_1, t0.type AS type_2, t0.filename AS filename_3, t0.width AS width_4, t0.height AS height_5, t0.size AS size_6, t0.mime_type AS mime_type_7, t0.updated_at AS updated_at_8 FROM app_images t0 WHERE t0.type = ? LIMIT 1

Parameters:

[
  "FAVICON"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.type AS type_2,
  t0.filename AS filename_3,
  t0.width AS width_4,
  t0.height AS height_5,
  t0.size AS size_6,
  t0.mime_type AS mime_type_7,
  t0.updated_at AS updated_at_8
FROM
  app_images t0
WHERE
  t0.type = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.type AS type_2, t0.filename AS filename_3, t0.width AS width_4, t0.height AS height_5, t0.size AS size_6, t0.mime_type AS mime_type_7, t0.updated_at AS updated_at_8 FROM app_images t0 WHERE t0.type = 'FAVICON' 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 28)
4	App\Services\Twig\ImageRenderExtension->renderImage (line 80)
5	__TwigTemplate_ad8909372376f6cf9b98dedf54bfee77->block_favicon (line 456)
6	Twig\Template->yieldBlock (line 77)
7	__TwigTemplate_f92f8880b5c50cb99318a7a33c541e25->doDisplay (line 411)
8	Twig\Template->yield (line 56)
9	__TwigTemplate_ad8909372376f6cf9b98dedf54bfee77->doDisplay (line 411)
10	Twig\Template->yield (line 54)
11	__TwigTemplate_4eea6dcd3e1c91cd83787a5e141c34ab->doDisplay (line 411)
12	Twig\Template->yield (line 56)
13	__TwigTemplate_6345de5286c6a6faf7d445368ef7984a->doDisplay (line 411)
14	Twig\Template->yield (line 56)
15	__TwigTemplate_80b1799ed693ebfc4b6d6d397def99e8->doDisplay (line 411)
16	Twig\Template->yield (line 366)
17	Twig\Template->display (line 381)
18	Twig\Template->render (line 51)
19	Twig\TemplateWrapper->render (line 333)
20	Twig\Environment->render (line 258)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->renderView (line 266)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 29)
23	OneOrtho\UserBundle\Security\Controller\SecurityController->login (line 181)
24	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
25	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
26	Symfony\Component\HttpKernel\Kernel->handle (line 35)
27	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
28	require_once (line 5)
29	require (line 13)

1.22 ms
(23.54%)

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.46 ms
(8.88%)

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 404)
7	Symfony\Component\DependencyInjection\Container->getService (line 40)
8	Symfony\Component\DependencyInjection\Argument\ServiceLocator->get (line 258)
9	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->renderView (line 266)
10	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 29)
11	OneOrtho\UserBundle\Security\Controller\SecurityController->login (line 181)
12	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
13	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
14	Symfony\Component\HttpKernel\Kernel->handle (line 35)
15	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
16	require_once (line 5)
17	require (line 13)

0.46 ms
(8.88%)

SELECT a0_.id AS id_0, a0_.primary_color AS primary_color_1, a0_.secondary_color AS secondary_color_2, a0_.text_color_btn AS text_color_btn_3, a0_.text_color_title AS text_color_title_4, a0_.primary_color_report AS primary_color_report_5, a0_.text_color_report AS text_color_report_6, a0_.production_labels_color AS production_labels_color_7, a0_.production_labels_text_color AS production_labels_text_color_8, a0_.kn3d_primary_color AS kn3d_primary_color_9, a0_.kn3d_primary_text_color AS kn3d_primary_text_color_10, a0_.kn3d_secondary_color AS kn3d_secondary_color_11, a0_.kn3d_secondary_text_color AS kn3d_secondary_text_color_12, a0_.kn3d_tertiary_color AS kn3d_tertiary_color_13, a0_.kn3d_tertiary_text_color AS kn3d_tertiary_text_color_14 FROM app_theme a0_ LIMIT 1

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  a0_.id AS id_0,
  a0_.primary_color AS primary_color_1,
  a0_.secondary_color AS secondary_color_2,
  a0_.text_color_btn AS text_color_btn_3,
  a0_.text_color_title AS text_color_title_4,
  a0_.primary_color_report AS primary_color_report_5,
  a0_.text_color_report AS text_color_report_6,
  a0_.production_labels_color AS production_labels_color_7,
  a0_.production_labels_text_color AS production_labels_text_color_8,
  a0_.kn3d_primary_color AS kn3d_primary_color_9,
  a0_.kn3d_primary_text_color AS kn3d_primary_text_color_10,
  a0_.kn3d_secondary_color AS kn3d_secondary_color_11,
  a0_.kn3d_secondary_text_color AS kn3d_secondary_text_color_12,
  a0_.kn3d_tertiary_color AS kn3d_tertiary_color_13,
  a0_.kn3d_tertiary_text_color AS kn3d_tertiary_text_color_14
FROM
  app_theme a0_
LIMIT
  1

SELECT a0_.id AS id_0, a0_.primary_color AS primary_color_1, a0_.secondary_color AS secondary_color_2, a0_.text_color_btn AS text_color_btn_3, a0_.text_color_title AS text_color_title_4, a0_.primary_color_report AS primary_color_report_5, a0_.text_color_report AS text_color_report_6, a0_.production_labels_color AS production_labels_color_7, a0_.production_labels_text_color AS production_labels_text_color_8, a0_.kn3d_primary_color AS kn3d_primary_color_9, a0_.kn3d_primary_text_color AS kn3d_primary_text_color_10, a0_.kn3d_secondary_color AS kn3d_secondary_color_11, a0_.kn3d_secondary_text_color AS kn3d_secondary_text_color_12, a0_.kn3d_tertiary_color AS kn3d_tertiary_color_13, a0_.kn3d_tertiary_text_color AS kn3d_tertiary_text_color_14 FROM app_theme a0_ LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 31)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 330)
3	Doctrine\ORM\Query->_doExecute (line 1213)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1167)
5	Doctrine\ORM\AbstractQuery->execute (line 958)
6	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 58)
7	App\Repository\ThemeRepository->findGlobalSettings (line 23)
8	App\Services\Twig\ThemeRenderExtension->getGlobals (line 365)
9	Twig\ExtensionSet->getGlobals (line 908)
10	Twig\Environment->getGlobals (line 406)
11	Twig\Template->yield (line 366)
12	Twig\Template->display (line 381)
13	Twig\Template->render (line 51)
14	Twig\TemplateWrapper->render (line 333)
15	Twig\Environment->render (line 258)
16	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->renderView (line 266)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 29)
18	OneOrtho\UserBundle\Security\Controller\SecurityController->login (line 181)
19	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
20	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
21	Symfony\Component\HttpKernel\Kernel->handle (line 35)
22	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
23	require_once (line 5)
24	require (line 13)

0.44 ms
(8.57%)

SELECT l.code FROM oo_users_locale l

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  l.code
FROM
  oo_users_locale l

SELECT l.code FROM oo_users_locale l;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 348)
2	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line 295)
3	Doctrine\DBAL\Query\QueryBuilder->fetchAllAssociative (line 32)
4	OneOrtho\UserBundle\RegionalSettings\Repository\LocaleRepository->getAllCodes (line 44)
5	OneOrtho\UserBundle\RegionalSettings\RegionalSettingsContext->getDefinedLocalesCodes (line 1918)
6	Twig\Extension\CoreExtension::getAttribute (line 120)
7	__TwigTemplate_6345de5286c6a6faf7d445368ef7984a->block_body (line 456)
8	Twig\Template->yieldBlock (line 110)
9	__TwigTemplate_f92f8880b5c50cb99318a7a33c541e25->doDisplay (line 411)
10	Twig\Template->yield (line 56)
11	__TwigTemplate_ad8909372376f6cf9b98dedf54bfee77->doDisplay (line 411)
12	Twig\Template->yield (line 54)
13	__TwigTemplate_4eea6dcd3e1c91cd83787a5e141c34ab->doDisplay (line 411)
14	Twig\Template->yield (line 56)
15	__TwigTemplate_6345de5286c6a6faf7d445368ef7984a->doDisplay (line 411)
16	Twig\Template->yield (line 56)
17	__TwigTemplate_80b1799ed693ebfc4b6d6d397def99e8->doDisplay (line 411)
18	Twig\Template->yield (line 366)
19	Twig\Template->display (line 381)
20	Twig\Template->render (line 51)
21	Twig\TemplateWrapper->render (line 333)
22	Twig\Environment->render (line 258)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->renderView (line 266)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 29)
25	OneOrtho\UserBundle\Security\Controller\SecurityController->login (line 181)
26	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
27	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
28	Symfony\Component\HttpKernel\Kernel->handle (line 35)
29	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
30	require_once (line 5)
31	require (line 13)

0.37 ms
(7.23%)

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 404)
7	Symfony\Component\DependencyInjection\Container->getService (line 40)
8	Symfony\Component\DependencyInjection\Argument\ServiceLocator->get (line 258)
9	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->renderView (line 266)
10	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 29)
11	OneOrtho\UserBundle\Security\Controller\SecurityController->login (line 181)
12	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
13	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
14	Symfony\Component\HttpKernel\Kernel->handle (line 35)
15	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
16	require_once (line 5)
17	require (line 13)

0.36 ms
(6.87%)

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 404)
7	Symfony\Component\DependencyInjection\Container->getService (line 40)
8	Symfony\Component\DependencyInjection\Argument\ServiceLocator->get (line 258)
9	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->renderView (line 266)
10	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 29)
11	OneOrtho\UserBundle\Security\Controller\SecurityController->login (line 181)
12	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
13	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
14	Symfony\Component\HttpKernel\Kernel->handle (line 35)
15	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
16	require_once (line 5)
17	require (line 13)

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.

Entities Mapping

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.
App\Entity\Theme	No errors.
App\Entity\Image	No errors.

Symfony Profiler

http://astem.projets-la-sentinelle.fr/en/login

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping