Symfony Profiler

Query Metrics

2 Database Queries

2 Different statements

4.80 ms Query time

0 Invalid entities

0 Managed entities

Queries

Group similar statements

#▲

Time

Info

4.01 ms

SELECT u0_.id AS id_0, u0_.email AS email_1, u0_.roles AS roles_2, u0_.password AS password_3, u0_.azure_id AS azure_id_4, u0_.username AS username_5, u0_.firstname AS firstname_6, u0_.lastname AS lastname_7, u0_.department AS department_8, u0_.job_title AS job_title_9, u0_.azure_groups AS azure_groups_10 FROM user u0_ WHERE u0_.roles LIKE ?

Parameters:

[
  "%ROLE_COMMANDANT%"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  u0_.id AS id_0,
  u0_.email AS email_1,
  u0_.roles AS roles_2,
  u0_.password AS password_3,
  u0_.azure_id AS azure_id_4,
  u0_.username AS username_5,
  u0_.firstname AS firstname_6,
  u0_.lastname AS lastname_7,
  u0_.department AS department_8,
  u0_.job_title AS job_title_9,
  u0_.azure_groups AS azure_groups_10
FROM
  user u0_
WHERE
  u0_.roles LIKE ?

SELECT u0_.id AS id_0, u0_.email AS email_1, u0_.roles AS roles_2, u0_.password AS password_3, u0_.azure_id AS azure_id_4, u0_.username AS username_5, u0_.firstname AS firstname_6, u0_.lastname AS lastname_7, u0_.department AS department_8, u0_.job_title AS job_title_9, u0_.azure_groups AS azure_groups_10 FROM user u0_ WHERE u0_.roles LIKE '%ROLE_COMMANDANT%';

#	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\Repository\UserRepository->findByRole (line 45)
7	App\Controller\BO\User\UserController->index (line 23)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 191)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
12	require_once (line 32)
13	require_once (line 5)

0.78 ms

SELECT t0.id AS id_1, t0.route_name AS route_name_2, t0.title AS title_3, t0.content AS content_4, t0.enabled AS enabled_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7 FROM page_help t0 WHERE t0.route_name = ? AND t0.enabled = ? LIMIT 1

Parameters:

[
  "admin_user_index"
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.route_name AS route_name_2,
  t0.title AS title_3,
  t0.content AS content_4,
  t0.enabled AS enabled_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7
FROM
  page_help t0
WHERE
  t0.route_name = ?
  AND t0.enabled = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.route_name AS route_name_2, t0.title AS title_3, t0.content AS content_4, t0.enabled AS enabled_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7 FROM page_help t0 WHERE t0.route_name = 'admin_user_index' AND t0.enabled = 1 LIMIT 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\EntityRepository->findOneBy (line 125)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepository->findOneBy (line 86)
4	App\Repository\PageHelpRepository->findEnabledForRoute (line 41)
5	App\Service\PageHelpResolver->currentHelp (line 33)
6	App\Twig\PageHelpExtension->currentHelp (line 38)
7	__TwigTemplate_9e6a21136e2bb684600ddf4c24b3cae8->doDisplay (line 48)
8	Twig\Template->yield (line 402)
9	__TwigTemplate_1921bcb720d83d4c436affba5d87dfc0->block_body (line 357)
10	Twig\Template->yieldBlock (line 446)
11	__TwigTemplate_1921bcb720d83d4c436affba5d87dfc0->doDisplay (line 73)
12	Twig\Template->yield (line 402)
13	__TwigTemplate_a8955d41bcff96a02ed96aad2a0752cc->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 462)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 467)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 279)
22	App\Controller\BO\User\UserController->index (line 25)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
25	Symfony\Component\HttpKernel\Kernel->handle (line 191)
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

Entities Mapping

Class	Mapping errors
App\Entity\User	No errors.
App\Entity\PageHelp	No errors.

Symfony Profiler

GET https://evalcomp.dataccessor.com/admin/user?role=ROLE_COMMANDANT

Configuration Settings

Theme

Page Width