Symfony Profiler

Query Metrics

7 Database Queries

6 Different statements

2.85 ms Query time

0 Invalid entities

8 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

0.90 ms
(31.70%)

SELECT t0.id AS id_1, t0.email AS email_2, t0.first_name AS first_name_3, t0.last_name AS last_name_4, t0.roles AS roles_5, t0.password AS password_6, t0.shibboleth_id AS shibboleth_id_7, t0.enabled AS enabled_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.last_login_at AS last_login_at_11 FROM app_user t0 WHERE t0.id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.first_name AS first_name_3,
  t0.last_name AS last_name_4,
  t0.roles AS roles_5,
  t0.password AS password_6,
  t0.shibboleth_id AS shibboleth_id_7,
  t0.enabled AS enabled_8,
  t0.created_at AS created_at_9,
  t0.updated_at AS updated_at_10,
  t0.last_login_at AS last_login_at_11
FROM
  app_user t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.first_name AS first_name_3, t0.last_name AS last_name_4, t0.roles AS roles_5, t0.password AS password_6, t0.shibboleth_id AS shibboleth_id_7, t0.enabled AS enabled_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.last_login_at AS last_login_at_11 FROM app_user t0 WHERE t0.id = 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
3	Doctrine\ORM\EntityManager->find (line 366)
4	Doctrine\ORM\EntityRepository->find (line 86)
5	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepository->find (line 66)
6	Symfony\Bridge\Doctrine\Security\User\EntityUserProvider->refreshUser (line 97)
7	Symfony\Component\Security\Http\Firewall\ContextListener->refreshUser (line 212)
8	Symfony\Component\Security\Http\Firewall\ContextListener->authenticate (line 129)
9	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 52)
10	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->authenticate (line 64)
11	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 88)
12	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 86)
13	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
14	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
15	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
16	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
19	Symfony\Component\HttpKernel\Kernel->handle (line 191)
20	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
21	require_once (line 32)
22	require_once (line 5)

0.47 ms
(16.45%)

SELECT DISTINCT l0_.id AS id_0, l0_.created_at AS created_at_1 FROM loan l0_ ORDER BY l0_.created_at DESC LIMIT 20

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT l0_.id AS id_0,
  l0_.created_at AS created_at_1
FROM
  loan l0_
ORDER BY
  l0_.created_at DESC
LIMIT
  20

SELECT DISTINCT l0_.id AS id_0, l0_.created_at AS created_at_1 FROM loan l0_ ORDER BY l0_.created_at DESC LIMIT 20;

#	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->getScalarResult (line 724)
6	Doctrine\ORM\Tools\Pagination\Paginator->getIterator (line 127)
7	EasyCorp\Bundle\EasyAdminBundle\Orm\EntityPaginator->paginate (line 71)
8	EasyCorp\Bundle\EasyAdminBundle\Factory\PaginatorFactory->create (line 26)
9	EasyCorp\Bundle\EasyAdminBundle\Controller\AbstractCrudController->index (line 151)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
12	Symfony\Component\HttpKernel\Kernel->handle (line 191)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
14	require_once (line 32)
15	require_once (line 5)

0.44 ms
(15.30%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.description AS description_4, t0.icon AS icon_5, t0.access_role AS access_role_6 FROM article_type t0 ORDER BY t0.name ASC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.description AS description_4,
  t0.icon AS icon_5,
  t0.access_role AS access_role_6
FROM
  article_type t0
ORDER BY
  t0.name ASC

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.description AS description_4, t0.icon AS icon_5, t0.access_role AS access_role_6 FROM article_type t0 ORDER BY t0.name ASC;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 963)
2	Doctrine\ORM\EntityRepository->findBy (line 110)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepository->findBy (line 78)
4	App\Twig\AppExtension->getGlobals (line 16)
5	Twig\ExtensionSet->getGlobals (line 365)
6	Twig\Environment->getGlobals (line 908)
7	Twig\Template->yield (line 398)
8	Twig\Template->display (line 358)
9	Twig\Template->render (line 373)
10	Twig\TemplateWrapper->render (line 51)
11	Twig\Environment->render (line 333)
12	EasyCorp\Bundle\EasyAdminBundle\EventListener\CrudResponseListener->onKernelView (line 49)
13	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
14	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
15	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
16	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 188)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
19	Symfony\Component\HttpKernel\Kernel->handle (line 191)
20	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
21	require_once (line 32)
22	require_once (line 5)

0.38 ms
(13.36%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.inventory_number AS inventory_number_3, t0.image AS image_4, t0.description AS description_5, t0.notes AS notes_6, t0.status AS status_7, t0.restrict_to_role AS restrict_to_role_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.article_type_id AS article_type_id_11, t0.category_id AS category_id_12, t0.created_by_id AS created_by_id_13 FROM article t0 WHERE t0.id = ?

Parameters:

[
  99
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.inventory_number AS inventory_number_3,
  t0.image AS image_4,
  t0.description AS description_5,
  t0.notes AS notes_6,
  t0.status AS status_7,
  t0.restrict_to_role AS restrict_to_role_8,
  t0.created_at AS created_at_9,
  t0.updated_at AS updated_at_10,
  t0.article_type_id AS article_type_id_11,
  t0.category_id AS category_id_12,
  t0.created_by_id AS created_by_id_13
FROM
  article t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.inventory_number AS inventory_number_3, t0.image AS image_4, t0.description AS description_5, t0.notes AS notes_6, t0.status AS status_7, t0.restrict_to_role AS restrict_to_role_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.article_type_id AS article_type_id_11, t0.category_id AS category_id_12, t0.created_by_id AS created_by_id_13 FROM article t0 WHERE t0.id = 99;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
3	Doctrine\ORM\Proxy\ProxyFactory->{closure:Doctrine\ORM\Proxy\ProxyFactory::getProxy():217} (line 223)
4	App\Entity\Article::__toString (line 239)
5	EasyCorp\Bundle\EasyAdminBundle\Field\Configurator\AssociationConfigurator->formatAsString (line 295)
6	EasyCorp\Bundle\EasyAdminBundle\Field\Configurator\AssociationConfigurator->configureToOneAssociation (line 267)
7	EasyCorp\Bundle\EasyAdminBundle\Field\Configurator\AssociationConfigurator->configure (line 162)
8	EasyCorp\Bundle\EasyAdminBundle\Factory\FieldFactory->processFields (line 106)
9	EasyCorp\Bundle\EasyAdminBundle\Factory\FieldFactory->processFieldsForAll (line 132)
10	EasyCorp\Bundle\EasyAdminBundle\Controller\AbstractCrudController->index (line 162)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
13	Symfony\Component\HttpKernel\Kernel->handle (line 191)
14	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
15	require_once (line 32)
16	require_once (line 5)

0.33 ms
(11.62%)

SELECT l0_.id AS id_0, l0_.start_date AS start_date_1, l0_.due_date AS due_date_2, l0_.actual_return_date AS actual_return_date_3, l0_.status AS status_4, l0_.notes AS notes_5, l0_.extension_requested AS extension_requested_6, l0_.extension_requested_until AS extension_requested_until_7, l0_.extension_note AS extension_note_8, l0_.created_at AS created_at_9, l0_.updated_at AS updated_at_10, l0_.article_id AS article_id_11, l0_.user_id AS user_id_12, l0_.handed_out_by_id AS handed_out_by_id_13, l0_.returned_to_id AS returned_to_id_14, l0_.created_by_id AS created_by_id_15 FROM loan l0_ WHERE l0_.id IN (?) ORDER BY l0_.created_at DESC

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  l0_.id AS id_0,
  l0_.start_date AS start_date_1,
  l0_.due_date AS due_date_2,
  l0_.actual_return_date AS actual_return_date_3,
  l0_.status AS status_4,
  l0_.notes AS notes_5,
  l0_.extension_requested AS extension_requested_6,
  l0_.extension_requested_until AS extension_requested_until_7,
  l0_.extension_note AS extension_note_8,
  l0_.created_at AS created_at_9,
  l0_.updated_at AS updated_at_10,
  l0_.article_id AS article_id_11,
  l0_.user_id AS user_id_12,
  l0_.handed_out_by_id AS handed_out_by_id_13,
  l0_.returned_to_id AS returned_to_id_14,
  l0_.created_by_id AS created_by_id_15
FROM
  loan l0_
WHERE
  l0_.id IN (?)
ORDER BY
  l0_.created_at DESC

SELECT l0_.id AS id_0, l0_.start_date AS start_date_1, l0_.due_date AS due_date_2, l0_.actual_return_date AS actual_return_date_3, l0_.status AS status_4, l0_.notes AS notes_5, l0_.extension_requested AS extension_requested_6, l0_.extension_requested_until AS extension_requested_until_7, l0_.extension_note AS extension_note_8, l0_.created_at AS created_at_9, l0_.updated_at AS updated_at_10, l0_.article_id AS article_id_11, l0_.user_id AS user_id_12, l0_.handed_out_by_id AS handed_out_by_id_13, l0_.returned_to_id AS returned_to_id_14, l0_.created_by_id AS created_by_id_15 FROM loan l0_ WHERE l0_.id IN (1) ORDER BY l0_.created_at DESC;

#	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	Doctrine\ORM\Tools\Pagination\Paginator->getIterator (line 145)
7	EasyCorp\Bundle\EasyAdminBundle\Orm\EntityPaginator->paginate (line 71)
8	EasyCorp\Bundle\EasyAdminBundle\Factory\PaginatorFactory->create (line 26)
9	EasyCorp\Bundle\EasyAdminBundle\Controller\AbstractCrudController->index (line 151)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
12	Symfony\Component\HttpKernel\Kernel->handle (line 191)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
14	require_once (line 32)
15	require_once (line 5)

0.33 ms
(11.57%)

SELECT count(*) AS sclr_0 FROM loan l0_

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  count(*) AS sclr_0
FROM
  loan l0_

SELECT count(*) AS sclr_0 FROM loan l0_;

#	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->getScalarResult (line 724)
6	Doctrine\ORM\Tools\Pagination\Paginator->count (line 96)
7	EasyCorp\Bundle\EasyAdminBundle\Orm\EntityPaginator->paginate (line 72)
8	EasyCorp\Bundle\EasyAdminBundle\Factory\PaginatorFactory->create (line 26)
9	EasyCorp\Bundle\EasyAdminBundle\Controller\AbstractCrudController->index (line 151)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
12	Symfony\Component\HttpKernel\Kernel->handle (line 191)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
14	require_once (line 32)
15	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\User	3
App\Entity\ArticleType	2
App\Entity\Loan	1
App\Entity\Article	1
App\Entity\Category	1

Entities Mapping

Class	Mapping errors
App\Entity\User	No errors.
App\Entity\Loan	No errors.
App\Entity\Article	No errors.
App\Entity\ArticleType	No errors.
App\Entity\Category	No errors.
App\Entity\AttributeValue	No errors.
App\Entity\AttributeDefinition	No errors.

Symfony Profiler

GET https://loanhub.fhw.crowbyte.org/admin/loan

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping