Symfony Profiler

Query Metrics

3 Database Queries

3 Different statements

2.30 ms Query time

0 Invalid entities

4 Managed entities

Grouped Statements

Show all queries

default connection

Time▼

Count

Info

0.92 ms
(40.04%)

SELECT a0_.id AS id_0, a0_.action AS action_1, a0_.entity_type AS entity_type_2, a0_.entity_id AS entity_id_3, a0_.details AS details_4, a0_.ip_address AS ip_address_5, a0_.created_at AS created_at_6, u1_.id AS id_7, u1_.email AS email_8, u1_.google_id AS google_id_9, u1_.first_name AS first_name_10, u1_.last_name AS last_name_11, u1_.display_name AS display_name_12, u1_.avatar AS avatar_13, u1_.roles AS roles_14, u1_.last_login_at AS last_login_at_15, u1_.created_at AS created_at_16, u1_.is_active AS is_active_17, a0_.user_id AS user_id_18 FROM audit_log a0_ LEFT JOIN user u1_ ON a0_.user_id = u1_.id ORDER BY a0_.created_at DESC LIMIT 50

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  a0_.id AS id_0,
  a0_.action AS action_1,
  a0_.entity_type AS entity_type_2,
  a0_.entity_id AS entity_id_3,
  a0_.details AS details_4,
  a0_.ip_address AS ip_address_5,
  a0_.created_at AS created_at_6,
  u1_.id AS id_7,
  u1_.email AS email_8,
  u1_.google_id AS google_id_9,
  u1_.first_name AS first_name_10,
  u1_.last_name AS last_name_11,
  u1_.display_name AS display_name_12,
  u1_.avatar AS avatar_13,
  u1_.roles AS roles_14,
  u1_.last_login_at AS last_login_at_15,
  u1_.created_at AS created_at_16,
  u1_.is_active AS is_active_17,
  a0_.user_id AS user_id_18
FROM
  audit_log a0_
  LEFT JOIN user u1_ ON a0_.user_id = u1_.id
ORDER BY
  a0_.created_at DESC
LIMIT
  50

SELECT a0_.id AS id_0, a0_.action AS action_1, a0_.entity_type AS entity_type_2, a0_.entity_id AS entity_id_3, a0_.details AS details_4, a0_.ip_address AS ip_address_5, a0_.created_at AS created_at_6, u1_.id AS id_7, u1_.email AS email_8, u1_.google_id AS google_id_9, u1_.first_name AS first_name_10, u1_.last_name AS last_name_11, u1_.display_name AS display_name_12, u1_.avatar AS avatar_13, u1_.roles AS roles_14, u1_.last_login_at AS last_login_at_15, u1_.created_at AS created_at_16, u1_.is_active AS is_active_17, a0_.user_id AS user_id_18 FROM audit_log a0_ LEFT JOIN user u1_ ON a0_.user_id = u1_.id ORDER BY a0_.created_at DESC LIMIT 50;

#	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\AuditLogRepository->findRecent (line 28)
7	App\Controller\Admin\AuditLogController->index (line 29)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 182)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
12	require_once (line 29)
13	require_once (line 5)

0.72 ms
(31.24%)

SELECT COUNT(a0_.id) AS sclr_0 FROM audit_log a0_

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(a0_.id) AS sclr_0
FROM
  audit_log a0_

SELECT COUNT(a0_.id) AS sclr_0 FROM audit_log a0_;

#	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->getSingleResult (line 772)
6	Doctrine\ORM\AbstractQuery->getSingleScalarResult (line 801)
7	App\Repository\AuditLogRepository->countAll (line 49)
8	App\Controller\Admin\AuditLogController->index (line 32)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
11	Symfony\Component\HttpKernel\Kernel->handle (line 182)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
13	require_once (line 29)
14	require_once (line 5)

0.66 ms
(28.72%)

SELECT t0.id AS id_1, t0.email AS email_2, t0.google_id AS google_id_3, t0.first_name AS first_name_4, t0.last_name AS last_name_5, t0.display_name AS display_name_6, t0.avatar AS avatar_7, t0.roles AS roles_8, t0.last_login_at AS last_login_at_9, t0.created_at AS created_at_10, t0.is_active AS is_active_11 FROM 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.google_id AS google_id_3,
  t0.first_name AS first_name_4,
  t0.last_name AS last_name_5,
  t0.display_name AS display_name_6,
  t0.avatar AS avatar_7,
  t0.roles AS roles_8,
  t0.last_login_at AS last_login_at_9,
  t0.created_at AS created_at_10,
  t0.is_active AS is_active_11
FROM
  user t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.google_id AS google_id_3, t0.first_name AS first_name_4, t0.last_name AS last_name_5, t0.display_name AS display_name_6, t0.avatar AS avatar_7, t0.roles AS roles_8, t0.last_login_at AS last_login_at_9, t0.created_at AS created_at_10, t0.is_active AS is_active_11 FROM 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\ServiceEntityRepositoryProxy->find (line 61)
6	Symfony\Bridge\Doctrine\Security\User\EntityUserProvider->refreshUser (line 92)
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 46)
10	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->__invoke (line 61)
11	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 91)
12	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 92)
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 122)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
19	Symfony\Component\HttpKernel\Kernel->handle (line 182)
20	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
21	require_once (line 29)
22	require_once (line 5)

Database Connections

Name	Service
default	doctrine.dbal.default_connection
readonly	doctrine.dbal.readonly_connection

Entity Managers

Name	Service
default	doctrine.orm.default_entity_manager
readonly	doctrine.orm.readonly_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

default entity manager

Class	Amount of managed objects
App\Entity\AuditLog	3
App\Entity\User	1

readonly entity manager

Class	Amount of managed objects

Entities Mapping

default entity manager

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

readonly entity manager

No loaded entities.

Symfony Profiler

GET https://edunexus.lycee-sacrecoeur-beziers.com/admin/audit

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

default connection

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

readonly entity manager

Entities Mapping

default entity manager

readonly entity manager