Symfony Profiler

Query Metrics

6 Database Queries

6 Different statements

1.38 ms Query time

3 Invalid entities

2 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

0.31 ms
(22.22%)

SELECT o0_.id AS id_0, o0_.name AS name_1, o0_.name_hash AS name_hash_2, o0_.user_name AS user_name_3, o0_.user_name_hash AS user_name_hash_4, o0_.password AS password_5, o0_.token AS token_6, o0_.api_type AS api_type_7, o0_.base_url AS base_url_8, o0_.api_key AS api_key_9, o0_.status AS status_10, o0_.channel AS channel_11, o0_.short_name AS short_name_12 FROM outside_system o0_ WHERE o0_.user_name_hash = ?

Parameters:

[
  "0df29046a9d59c5039e39d69a53a3ae3daafba896e13724d6edeaf842ab88d095f5d9bfc9b3d77252e7934637e374c83710e15766f3512703f1531685471cd95"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  o0_.id AS id_0,
  o0_.name AS name_1,
  o0_.name_hash AS name_hash_2,
  o0_.user_name AS user_name_3,
  o0_.user_name_hash AS user_name_hash_4,
  o0_.password AS password_5,
  o0_.token AS token_6,
  o0_.api_type AS api_type_7,
  o0_.base_url AS base_url_8,
  o0_.api_key AS api_key_9,
  o0_.status AS status_10,
  o0_.channel AS channel_11,
  o0_.short_name AS short_name_12
FROM
  outside_system o0_
WHERE
  o0_.user_name_hash = ?

SELECT o0_.id AS id_0, o0_.name AS name_1, o0_.name_hash AS name_hash_2, o0_.user_name AS user_name_3, o0_.user_name_hash AS user_name_hash_4, o0_.password AS password_5, o0_.token AS token_6, o0_.api_type AS api_type_7, o0_.base_url AS base_url_8, o0_.api_key AS api_key_9, o0_.status AS status_10, o0_.channel AS channel_11, o0_.short_name AS short_name_12 FROM outside_system o0_ WHERE o0_.user_name_hash = '0df29046a9d59c5039e39d69a53a3ae3daafba896e13724d6edeaf842ab88d095f5d9bfc9b3d77252e7934637e374c83710e15766f3512703f1531685471cd95';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 31)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 330)
3	Doctrine\ORM\Query->_doExecute (line 1218)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1172)
5	Doctrine\ORM\AbstractQuery->execute (line 959)
6	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 34)
7	App\Repository\OutsideSystemRepository->findOneByUserName (line 22)
8	App\Security\OutsideSystemUserProvider->loadUserByIdentifier (line 87)
9	Symfony\Component\Security\Http\Authenticator\Passport\Badge\UserBadge->getUser (line 56)
10	Symfony\Component\Security\Http\Authenticator\Passport\Passport->getUser (line 42)
11	Symfony\Component\Security\Http\EventListener\UserCheckerListener->preCheckCredentials (line 116)
12	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
13	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
14	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 139)
15	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 180)
16	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticator (line 158)
17	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticators (line 140)
18	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->authenticateRequest (line 40)
19	Symfony\Component\Security\Http\Firewall\AuthenticatorManagerListener->authenticate (line 68)
20	Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticatorManagerListener->authenticate (line 46)
21	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 26)
22	Symfony\Component\Security\Http\Firewall\AbstractListener->__invoke (line 83)
23	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 95)
24	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 116)
25	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
26	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
27	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 139)
28	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 157)
29	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
30	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
31	Symfony\Component\HttpKernel\Kernel->handle (line 35)
32	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
33	require_once (line 50)

0.27 ms
(19.66%)

SELECT u0_.user_mob_device_id AS user_mob_device_id_0, u0_.user_mob_device_uuid AS user_mob_device_uuid_1, u0_.user_mob_device_push_notif_id AS user_mob_device_push_notif_id_2, u0_.user_mob_device_created_at AS user_mob_device_created_at_3, u0_.user_mob_device_refreshed_at AS user_mob_device_refreshed_at_4, u0_.user_mob_device_default_lang AS user_mob_device_default_lang_5, u0_.user_mob_device_sec_token AS user_mob_device_sec_token_6, u0_.user_mob_device_sec_token_hash AS user_mob_device_sec_token_hash_7, u0_.user_mob_device_app_version AS user_mob_device_app_version_8, u0_.user_mob_device_app_code AS user_mob_device_app_code_9, u0_.user_mob_device_app_build AS user_mob_device_app_build_10, u0_.user_mob_device_model AS user_mob_device_model_11, u0_.user_mob_device_os AS user_mob_device_os_12, u0_.user_mob_device_ip AS user_mob_device_ip_13, u0_.user_mob_device_session_counter AS user_mob_device_session_counter_14, u0_.user_mob_device_help_token AS user_mob_device_help_token_15, u0_.is_emulated AS is_emulated_16, u0_.user_mob_device_user_id AS user_mob_device_user_id_17 FROM user_mob_device u0_ WHERE u0_.user_mob_device_uuid = ? AND (u0_.user_mob_device_sec_token_hash = ? OR 1 = 0)

Parameters:

[
  "e59d2f42159214ec"
  "9cc6e4603bfebd60f56705b6c818e9579238709baf62a28d8331f265f4e6eee410cd8a1df3ec6775a58dbaa4d64103a99155c726c7c9fec36f0c987b97b50f6d"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  u0_.user_mob_device_id AS user_mob_device_id_0,
  u0_.user_mob_device_uuid AS user_mob_device_uuid_1,
  u0_.user_mob_device_push_notif_id AS user_mob_device_push_notif_id_2,
  u0_.user_mob_device_created_at AS user_mob_device_created_at_3,
  u0_.user_mob_device_refreshed_at AS user_mob_device_refreshed_at_4,
  u0_.user_mob_device_default_lang AS user_mob_device_default_lang_5,
  u0_.user_mob_device_sec_token AS user_mob_device_sec_token_6,
  u0_.user_mob_device_sec_token_hash AS user_mob_device_sec_token_hash_7,
  u0_.user_mob_device_app_version AS user_mob_device_app_version_8,
  u0_.user_mob_device_app_code AS user_mob_device_app_code_9,
  u0_.user_mob_device_app_build AS user_mob_device_app_build_10,
  u0_.user_mob_device_model AS user_mob_device_model_11,
  u0_.user_mob_device_os AS user_mob_device_os_12,
  u0_.user_mob_device_ip AS user_mob_device_ip_13,
  u0_.user_mob_device_session_counter AS user_mob_device_session_counter_14,
  u0_.user_mob_device_help_token AS user_mob_device_help_token_15,
  u0_.is_emulated AS is_emulated_16,
  u0_.user_mob_device_user_id AS user_mob_device_user_id_17
FROM
  user_mob_device u0_
WHERE
  u0_.user_mob_device_uuid = ?
  AND (
    u0_.user_mob_device_sec_token_hash = ?
    OR 1 = 0
  )

SELECT u0_.user_mob_device_id AS user_mob_device_id_0, u0_.user_mob_device_uuid AS user_mob_device_uuid_1, u0_.user_mob_device_push_notif_id AS user_mob_device_push_notif_id_2, u0_.user_mob_device_created_at AS user_mob_device_created_at_3, u0_.user_mob_device_refreshed_at AS user_mob_device_refreshed_at_4, u0_.user_mob_device_default_lang AS user_mob_device_default_lang_5, u0_.user_mob_device_sec_token AS user_mob_device_sec_token_6, u0_.user_mob_device_sec_token_hash AS user_mob_device_sec_token_hash_7, u0_.user_mob_device_app_version AS user_mob_device_app_version_8, u0_.user_mob_device_app_code AS user_mob_device_app_code_9, u0_.user_mob_device_app_build AS user_mob_device_app_build_10, u0_.user_mob_device_model AS user_mob_device_model_11, u0_.user_mob_device_os AS user_mob_device_os_12, u0_.user_mob_device_ip AS user_mob_device_ip_13, u0_.user_mob_device_session_counter AS user_mob_device_session_counter_14, u0_.user_mob_device_help_token AS user_mob_device_help_token_15, u0_.is_emulated AS is_emulated_16, u0_.user_mob_device_user_id AS user_mob_device_user_id_17 FROM user_mob_device u0_ WHERE u0_.user_mob_device_uuid = 'e59d2f42159214ec' AND (u0_.user_mob_device_sec_token_hash = '9cc6e4603bfebd60f56705b6c818e9579238709baf62a28d8331f265f4e6eee410cd8a1df3ec6775a58dbaa4d64103a99155c726c7c9fec36f0c987b97b50f6d' OR 1 = 0);

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 31)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 330)
3	Doctrine\ORM\Query->_doExecute (line 1218)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1172)
5	Doctrine\ORM\AbstractQuery->execute (line 959)
6	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 104)
7	App\Repository\User\UserMobDeviceRepository->findByUUIDAndToken (line 402)
8	App\Util\Api\AbstractApiController->isRegistered (line 248)
9	App\Util\Api\AbstractApiController->prepareAPIRequest (line 79)
10	App\Controller\Api\DeviceController->pushRegistration (line 181)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
13	Symfony\Component\HttpKernel\Kernel->handle (line 35)
14	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
15	require_once (line 50)

0.26 ms
(19.09%)

UPDATE outside_system SET name = ?, user_name = ? WHERE id = ?

Parameters:

[
  "def502002d1078e3ea23fce6065e892e6739744e2d91e8adc130502ce7ab163a5545ff24f4693f181e6130fd154a49bc827fe02fc477154840a6ebcce926ded099742f5ebe5954adfeb4b07859fc56626bbd88e98f7f4a3e3c194ce876035868f892e6039a"
  "def502008e9cbddd8cb3952fe99534feeba71d9346d97afc2aa39ea3d1a403e9b00c4fd2a6c6de4e330d0aeeaba2c22dbde23f91aa5e7b1daf134d22daca909c5242c0f52942e3e62916e1d5ef980dc4be41a3cb57948fccb3637d1e"
  1
]

View formatted query View runnable query Explain query View query backtrace

UPDATE
  outside_system
SET
  name = ?,
  user_name = ?
WHERE
  id = ?

UPDATE outside_system SET name = 'def502002d1078e3ea23fce6065e892e6739744e2d91e8adc130502ce7ab163a5545ff24f4693f181e6130fd154a49bc827fe02fc477154840a6ebcce926ded099742f5ebe5954adfeb4b07859fc56626bbd88e98f7f4a3e3c194ce876035868f892e6039a', user_name = 'def502008e9cbddd8cb3952fe99534feeba71d9346d97afc2aa39ea3d1a403e9b00c4fd2a6c6de4e330d0aeeaba2c22dbde23f91aa5e7b1daf134d22daca909c5242c0f52942e3e62916e1d5ef980dc4be41a3cb57948fccb3637d1e' WHERE id = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeStatement (line 538)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->updateTable (line 424)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->update (line 1280)
4	Doctrine\ORM\UnitOfWork->executeUpdates (line 453)
5	Doctrine\ORM\UnitOfWork->commit (line 414)
6	Doctrine\ORM\EntityManager->flush (line 528)
7	App\Service\DeviceService->pushRegistration (line 80)
8	App\Controller\Api\DeviceController->{closure:App\Controller\Api\DeviceController::pushRegistration():79} (line 255)
9	App\Util\Api\AbstractApiController->prepareAPIRequest (line 79)
10	App\Controller\Api\DeviceController->pushRegistration (line 181)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
13	Symfony\Component\HttpKernel\Kernel->handle (line 35)
14	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
15	require_once (line 50)

0.23 ms
(16.91%)

"COMMIT"

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

"COMMIT"

"COMMIT";

#	File/Call
1	Doctrine\DBAL\Connection->doCommit (line 1454)
2	Doctrine\DBAL\Connection->commit (line 477)
3	Doctrine\ORM\UnitOfWork->commit (line 414)
4	Doctrine\ORM\EntityManager->flush (line 528)
5	App\Service\DeviceService->pushRegistration (line 80)
6	App\Controller\Api\DeviceController->{closure:App\Controller\Api\DeviceController::pushRegistration():79} (line 255)
7	App\Util\Api\AbstractApiController->prepareAPIRequest (line 79)
8	App\Controller\Api\DeviceController->pushRegistration (line 181)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require_once (line 50)

0.21 ms
(15.24%)

UPDATE user_mob_device SET user_mob_device_sec_token = ? WHERE user_mob_device_id = ?

Parameters:

[
  "def50200e3bdc30ff8a006bfc01186bd761d21fd93f11e65923d35f37096f0ef21b271c410faf8eaeebfd6267f35a834f7e06df015b8bc56b302984e1a77206fc440208a99f4dbe1a1d5a7ea6a51c171dc189a3a13fd480fda01b2abd0e309248e39173dc8f1a28cb7f049be85e67274863067ddb47ad44f6d335683a4cd8bdf6b3cc85e2a65f1f36029eea6888b61fb1bb87ce47fbd7410ed3fd8992491486c3fc45d32909c575d982950b8b675268424b75997ced52c468a70e27155f9ad6f9b094a6d37c28f067a6edec1301a0dd9751b1ade"
  102
]

View formatted query View runnable query Explain query View query backtrace

UPDATE
  user_mob_device
SET
  user_mob_device_sec_token = ?
WHERE
  user_mob_device_id = ?

UPDATE user_mob_device SET user_mob_device_sec_token = 'def50200e3bdc30ff8a006bfc01186bd761d21fd93f11e65923d35f37096f0ef21b271c410faf8eaeebfd6267f35a834f7e06df015b8bc56b302984e1a77206fc440208a99f4dbe1a1d5a7ea6a51c171dc189a3a13fd480fda01b2abd0e309248e39173dc8f1a28cb7f049be85e67274863067ddb47ad44f6d335683a4cd8bdf6b3cc85e2a65f1f36029eea6888b61fb1bb87ce47fbd7410ed3fd8992491486c3fc45d32909c575d982950b8b675268424b75997ced52c468a70e27155f9ad6f9b094a6d37c28f067a6edec1301a0dd9751b1ade' WHERE user_mob_device_id = 102;

#	File/Call
1	Doctrine\DBAL\Connection->executeStatement (line 538)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->updateTable (line 424)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->update (line 1280)
4	Doctrine\ORM\UnitOfWork->executeUpdates (line 453)
5	Doctrine\ORM\UnitOfWork->commit (line 414)
6	Doctrine\ORM\EntityManager->flush (line 528)
7	App\Service\DeviceService->pushRegistration (line 80)
8	App\Controller\Api\DeviceController->{closure:App\Controller\Api\DeviceController::pushRegistration():79} (line 255)
9	App\Util\Api\AbstractApiController->prepareAPIRequest (line 79)
10	App\Controller\Api\DeviceController->pushRegistration (line 181)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
13	Symfony\Component\HttpKernel\Kernel->handle (line 35)
14	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
15	require_once (line 50)

0.09 ms
(6.89%)

"START TRANSACTION"

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

"START TRANSACTION"

"START TRANSACTION";

#	File/Call
1	Doctrine\DBAL\Connection->beginTransaction (line 427)
2	Doctrine\ORM\UnitOfWork->commit (line 414)
3	Doctrine\ORM\EntityManager->flush (line 528)
4	App\Service\DeviceService->pushRegistration (line 80)
5	App\Controller\Api\DeviceController->{closure:App\Controller\Api\DeviceController::pushRegistration():79} (line 255)
6	App\Util\Api\AbstractApiController->prepareAPIRequest (line 79)
7	App\Controller\Api\DeviceController->pushRegistration (line 181)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
10	Symfony\Component\HttpKernel\Kernel->handle (line 35)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
12	require_once (line 50)

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\Integration\OutsideSystem	1
App\Entity\User\UserMobDevice	1

Entities Mapping

Class	Mapping errors
App\Entity\Integration\OutsideSystem	No errors.
App\Entity\Enums\OutsideSystemServiceStatus	No errors.
App\Entity\Integration\OutsideSystemService	No errors.
App\Entity\Integration\UserToOutsideSystem	No errors.
App\Entity\Widget	No errors.
App\Entity\Category\Category	No errors.
App\Entity\User\UserMobDevice	No errors.
App\Entity\Enums\UserStatus	No errors.
App\Entity\User\User	The association App\Entity\User\User#queuePushes refers to the owning side field App\Entity\Queue\QueuePush#user which does not exist. The mappings App\Entity\User\User#visitSchedulerReservationsAppended and App\Entity\VisitScheduler\VisitSchedulerReservation#appendedTo are inconsistent with each other.
App\Entity\User\UserMobDeviceToCategory	No errors.
App\Entity\SendQueue	No errors.
App\Entity\User\UserMobDeviceToGarbage	No errors.
App\Entity\Notice	No errors.
App\Entity\Form\FormData	No errors.
App\Entity\User\UserToStatute	No errors.
App\Entity\User\UserMobDeviceToken	No errors.
App\Entity\User\UserMobDeviceConfig	No errors.
App\Entity\Content\ContentLikesToUserMobDevice	No errors.
App\Entity\Card\CardUsage	No errors.
App\Entity\Enums\ReservationStatus	No errors.
App\Entity\VisitScheduler\VisitSchedulerReservation	The mappings App\Entity\VisitScheduler\VisitSchedulerReservation#appendedTo and App\Entity\User\User#visitSchedulerReservations are inconsistent with each other.
App\Entity\Enums\NotificationCoordinatesStatus	No errors.
App\Entity\User\NotificationCoordinates	The field 'App\Entity\User\NotificationCoordinates#created_at' has the property type 'DateTimeInterface' that differs from the metadata field type 'string' returned by the 'string' DBAL type. The mappings App\Entity\User\NotificationCoordinates#user and App\Entity\User\User#notificationCoordinates are inconsistent with each other.
App\Entity\Enums\NotificationStatus	No errors.
App\Entity\Notification	No errors.
App\Entity\User\UserMobDeviceSession	No errors.
App\Entity\SurveySubmission	No errors.

Symfony Profiler

POST https://apka.adamow.gmina.pl/api/app/push-register

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping