Symfony Profiler

Query Metrics

1 Database Queries

1 Different statements

3.32 ms Query time

1 Invalid entities

1 Managed entities

Queries

Group similar statements

#▲

Time

Info

3.32 ms

SELECT t0.is_deleted AS is_deleted_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.id AS id_4, t0.phone AS phone_5, t0.active AS active_6, t0.id_api AS id_api_7, t0.avatar AS avatar_8 FROM staff t0 WHERE t0.phone = ? LIMIT 1

Parameters:

[
  79115569852
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.is_deleted AS is_deleted_1,
  t0.created_at AS created_at_2,
  t0.updated_at AS updated_at_3,
  t0.id AS id_4,
  t0.phone AS phone_5,
  t0.active AS active_6,
  t0.id_api AS id_api_7,
  t0.avatar AS avatar_8
FROM
  staff t0
WHERE
  t0.phone = ?
LIMIT
  1

SELECT t0.is_deleted AS is_deleted_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.id AS id_4, t0.phone AS phone_5, t0.active AS active_6, t0.id_api AS id_api_7, t0.avatar AS avatar_8 FROM staff t0 WHERE t0.phone = 79115569852 LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 736)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 125)
3	Doctrine\ORM\EntityRepository->findOneBy (line 81)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 30)
5	App\Security\StaffIdentityResolver->resolveByPhone (line 41)
6	App\Security\StaffIdentityResolver->resolveOrCreateByPhone (line 109)
7	App\Security\JwtAuthenticator->authenticate (line 70)
8	Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator->authenticate (line 176)
9	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticator (line 158)
10	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticators (line 140)
11	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->authenticateRequest (line 40)
12	Symfony\Component\Security\Http\Firewall\AuthenticatorManagerListener->authenticate (line 68)
13	Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticatorManagerListener->authenticate (line 46)
14	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 26)
15	Symfony\Component\Security\Http\Firewall\AbstractListener->__invoke (line 80)
16	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 95)
17	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 115)
18	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
19	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
20	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
21	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 159)
22	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
23	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
24	Symfony\Component\HttpKernel\Kernel->handle (line 35)
25	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
26	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\Staff	1

Entities Mapping

Class	Mapping errors
App\Entity\Base	No errors.
App\Entity\Staff	The mappings App\Entity\Staff#messagesChatStaff and App\Entity\StaffAnalyticsDay#Staff are inconsistent with each other.
App\Entity\StaffAnalyticsDay	No errors.
App\Entity\HistoryUse	No errors.
App\Entity\Device	No errors.
App\Entity\Notification	No errors.
App\Entity\Push	No errors.
App\Entity\ChioCoinTransactions	No errors.
App\Entity\RequestForBenefitCafe	No errors.
App\Entity\Benefit	No errors.

Symfony Profiler

GET http://apistaff.chio-chio.ru/getEventsNext

Configuration Settings

Theme

Page Width