Symfony Profiler

Query Metrics

2 Database Queries

2 Different statements

0.95 ms Query time

2 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

0.63 ms
(66.84%)

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.nome AS nome_5, t0.tipo_acesso AS tipo_acesso_6, t0.enabled AS enabled_7 FROM user t0 WHERE t0.id = ?

Parameters:

[
  115
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.nome AS nome_5,
  t0.tipo_acesso AS tipo_acesso_6,
  t0.enabled AS enabled_7
FROM
  user t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.nome AS nome_5, t0.tipo_acesso AS tipo_acesso_6, t0.enabled AS enabled_7 FROM user t0 WHERE t0.id = 115;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 776)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 794)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 521)
4	Doctrine\ORM\EntityManager->find (line 197)
5	Doctrine\ORM\EntityRepository->find (line 92)
6	Symfony\Bridge\Doctrine\Security\User\EntityUserProvider->refreshUser (line 207)
7	Symfony\Component\Security\Http\Firewall\ContextListener->refreshUser (line 127)
8	Symfony\Component\Security\Http\Firewall\ContextListener->authenticate (line 46)
9	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 73)
10	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->Symfony\Bundle\SecurityBundle\Security\{closure} (line 34)
11	Symfony\Component\Security\Core\Authentication\Token\Storage\TokenStorage->getToken (line 44)
12	Symfony\Component\Security\Core\Authentication\Token\Storage\UsageTrackingTokenStorage->getToken (line 228)
13	EasyCorp\Bundle\EasyAdminBundle\Factory\AdminContextFactory->getUser (line 66)
14	EasyCorp\Bundle\EasyAdminBundle\Factory\AdminContextFactory->create (line 78)
15	EasyCorp\Bundle\EasyAdminBundle\EventListener\AdminRouterSubscriber->onKernelRequest (line 116)
16	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
17	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
18	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 127)
19	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 139)
20	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 74)
21	Symfony\Component\HttpKernel\HttpKernel->handle (line 184)
22	Symfony\Component\HttpKernel\Kernel->handle (line 35)
23	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
24	require_once (line 5)

0.31 ms
(33.16%)

SELECT COUNT(m0_.id) AS sclr_0 FROM messenger_messages m0_ WHERE m0_.delivered_at IS NULL AND m0_.body LIKE ?

Parameters:

[
  "%;i:115;s:8:%"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(m0_.id) AS sclr_0
FROM
  messenger_messages m0_
WHERE
  m0_.delivered_at IS NULL
  AND m0_.body LIKE ?

SELECT COUNT(m0_.id) AS sclr_0 FROM messenger_messages m0_ WHERE m0_.delivered_at IS NULL AND m0_.body LIKE '%;i:115;s:8:%';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 33)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 327)
3	Doctrine\ORM\Query->_doExecute (line 1212)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1166)
5	Doctrine\ORM\AbstractQuery->execute (line 991)
6	Doctrine\ORM\AbstractQuery->getSingleResult (line 1020)
7	Doctrine\ORM\AbstractQuery->getSingleScalarResult (line 66)
8	App\Repository\MessengerMessagesRepository->countPendingMessagesByUser (line 4791)
9	App\Controller\Admin\DashboardController->count (line 163)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 74)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 184)
12	Symfony\Component\HttpKernel\Kernel->handle (line 35)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
14	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.

Entities Mapping

Class	Mapping errors
App\Entity\User	The field App\Entity\User#clientes is on the owning side of a bi-directional relationship, but the specified inversedBy association on the target-entity App\Entity\Cliente#users does not contain the required 'mappedBy="clientes"' attribute.
App\Entity\Documento	No errors.
App\Entity\Cliente	The field App\Entity\Cliente#users is on the owning side of a bi-directional relationship, but the specified inversedBy association on the target-entity App\Entity\User#clientes does not contain the required 'mappedBy="users"' attribute.
App\Entity\Fluxo	No errors.
App\Entity\Etapa	No errors.
App\Entity\MessengerMessages	No errors.

Symfony Profiler

GET https://index.arquivosdoc.com.br/fila/count

Configuration Settings

Theme