Symfony Profiler

Query Metrics

3 Database Queries

3 Different statements

2.09 ms Query time

3 Invalid entities

2 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

1.38 ms
(66.06%)

SELECT s0_.id AS id_0, s0_.sticky_title AS sticky_title_1, s0_.sticky_message AS sticky_message_2, s0_.sticky_availability AS sticky_availability_3, s0_.sticky_type AS sticky_type_4, s0_.sticky_can_close AS sticky_can_close_5, s0_.sticky_can_permanently_close AS sticky_can_permanently_close_6, s0_.sticky_show_once AS sticky_show_once_7, s0_.sticky_link AS sticky_link_8, s0_.sticky_close_on_link AS sticky_close_on_link_9, s0_.sticky_created_by AS sticky_created_by_10, s0_.sticky_created_at AS sticky_created_at_11, s0_.sticky_updated_by AS sticky_updated_by_12, s0_.sticky_updated_at AS sticky_updated_at_13 FROM sticky s0_ WHERE s0_.sticky_availability >= ? ORDER BY s0_.id DESC, s0_.sticky_availability DESC

Parameters:

[
  1785211951
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  s0_.id AS id_0,
  s0_.sticky_title AS sticky_title_1,
  s0_.sticky_message AS sticky_message_2,
  s0_.sticky_availability AS sticky_availability_3,
  s0_.sticky_type AS sticky_type_4,
  s0_.sticky_can_close AS sticky_can_close_5,
  s0_.sticky_can_permanently_close AS sticky_can_permanently_close_6,
  s0_.sticky_show_once AS sticky_show_once_7,
  s0_.sticky_link AS sticky_link_8,
  s0_.sticky_close_on_link AS sticky_close_on_link_9,
  s0_.sticky_created_by AS sticky_created_by_10,
  s0_.sticky_created_at AS sticky_created_at_11,
  s0_.sticky_updated_by AS sticky_updated_by_12,
  s0_.sticky_updated_at AS sticky_updated_at_13
FROM
  sticky s0_
WHERE
  s0_.sticky_availability >= ?
ORDER BY
  s0_.id DESC,
  s0_.sticky_availability DESC

SELECT s0_.id AS id_0, s0_.sticky_title AS sticky_title_1, s0_.sticky_message AS sticky_message_2, s0_.sticky_availability AS sticky_availability_3, s0_.sticky_type AS sticky_type_4, s0_.sticky_can_close AS sticky_can_close_5, s0_.sticky_can_permanently_close AS sticky_can_permanently_close_6, s0_.sticky_show_once AS sticky_show_once_7, s0_.sticky_link AS sticky_link_8, s0_.sticky_close_on_link AS sticky_close_on_link_9, s0_.sticky_created_by AS sticky_created_by_10, s0_.sticky_created_at AS sticky_created_at_11, s0_.sticky_updated_by AS sticky_updated_by_12, s0_.sticky_updated_at AS sticky_updated_at_13 FROM sticky s0_ WHERE s0_.sticky_availability >= 1785211951 ORDER BY s0_.id DESC, s0_.sticky_availability DESC;

#	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 907)
6	Doctrine\ORM\AbstractQuery->getResult (line 29)
7	App\Repository\StickyRepository->findLatest (line 128)
8	App\Service\StickyService->getStickyContent (line 154)
9	App\Controller\Api\ContentController->{closure:App\Controller\Api\ContentController::urgent():153} (line 255)
10	App\Util\Api\AbstractApiController->prepareAPIRequest (line 153)
11	App\Controller\Api\ContentController->urgent (line 181)
12	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
13	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
14	Symfony\Component\HttpKernel\Kernel->handle (line 35)
15	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
16	require_once (line 50)

0.43 ms
(20.58%)

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 153)
10	App\Controller\Api\ContentController->urgent (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.28 ms
(13.36%)

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)

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.
App\Entity\Sticky	No errors.

Symfony Profiler

GET https://apka.adamow.gmina.pl/api/sticky

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping