Symfony Profiler

Query Metrics

3 Database Queries

3 Different statements

2.63 ms Query time

2 Invalid entities

Queries

Group similar statements

#▲

Time

Info

0.75 ms

SELECT t0.user_id AS user_id_1, t0.user_outside_id AS user_outside_id_2, t0.user_type AS user_type_3, t0.user_api_type AS user_api_type_4, t0.user_login AS user_login_5, t0.user_password AS user_password_6, t0.user_checksum AS user_checksum_7, t0.user_status AS user_status_8, t0.user_token AS user_token_9, t0.user_token_exp AS user_token_exp_10, t0.user_last_login AS user_last_login_11, t0.user_created_at AS user_created_at_12, t0.user_updated_at AS user_updated_at_13, t0.user_deleted_at AS user_deleted_at_14, t0.user_public_approved AS user_public_approved_15, t0.user_public_blocked AS user_public_blocked_16, t0.user_public_app_code AS user_public_app_code_17, t0.user_public_app_code_sended_at AS user_public_app_code_sended_at_18, t0.user_public_app_code_registered_at AS user_public_app_code_registered_at_19, t0.user_option AS user_option_20, t0.user_public_app_code_hash AS user_public_app_code_hash_21, t0.user_api_setting_sms AS user_api_setting_sms_22, t0.user_api_setting_email AS user_api_setting_email_23, t0.user_api_setting_mobile AS user_api_setting_mobile_24, t0.user_special AS user_special_25, t0.google_authenticator_secret AS google_authenticator_secret_26, t27.user_detail_id AS user_detail_id_28, t27.user_detail_name AS user_detail_name_29, t27.user_detail_surname AS user_detail_surname_30, t27.user_detail_sex AS user_detail_sex_31, t27.user_detail_personal_id_type AS user_detail_personal_id_type_32, t27.user_detail_personal_id AS user_detail_personal_id_33, t27.user_detail_birthday AS user_detail_birthday_34, t27.user_detail_email AS user_detail_email_35, t27.user_detail_phone AS user_detail_phone_36, t27.user_detail_street AS user_detail_street_37, t27.user_detail_street_no AS user_detail_street_no_38, t27.user_detail_post_code AS user_detail_post_code_39, t27.user_detail_state AS user_detail_state_40, t27.user_detail_province AS user_detail_province_41, t27.user_detail_comunity AS user_detail_comunity_42, t27.user_detail_city AS user_detail_city_43, t27.user_detail_personal_id_hash AS user_detail_personal_id_hash_44, t27.user_detail_surname_hash AS user_detail_surname_hash_45, t27.user_id AS user_id_46 FROM user t0 LEFT JOIN user_detail t27 ON t27.user_id = t0.user_id WHERE t0.user_login = ? LIMIT 1

Parameters:

[
  "contento"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.user_id AS user_id_1,
  t0.user_outside_id AS user_outside_id_2,
  t0.user_type AS user_type_3,
  t0.user_api_type AS user_api_type_4,
  t0.user_login AS user_login_5,
  t0.user_password AS user_password_6,
  t0.user_checksum AS user_checksum_7,
  t0.user_status AS user_status_8,
  t0.user_token AS user_token_9,
  t0.user_token_exp AS user_token_exp_10,
  t0.user_last_login AS user_last_login_11,
  t0.user_created_at AS user_created_at_12,
  t0.user_updated_at AS user_updated_at_13,
  t0.user_deleted_at AS user_deleted_at_14,
  t0.user_public_approved AS user_public_approved_15,
  t0.user_public_blocked AS user_public_blocked_16,
  t0.user_public_app_code AS user_public_app_code_17,
  t0.user_public_app_code_sended_at AS user_public_app_code_sended_at_18,
  t0.user_public_app_code_registered_at AS user_public_app_code_registered_at_19,
  t0.user_option AS user_option_20,
  t0.user_public_app_code_hash AS user_public_app_code_hash_21,
  t0.user_api_setting_sms AS user_api_setting_sms_22,
  t0.user_api_setting_email AS user_api_setting_email_23,
  t0.user_api_setting_mobile AS user_api_setting_mobile_24,
  t0.user_special AS user_special_25,
  t0.google_authenticator_secret AS google_authenticator_secret_26,
  t27.user_detail_id AS user_detail_id_28,
  t27.user_detail_name AS user_detail_name_29,
  t27.user_detail_surname AS user_detail_surname_30,
  t27.user_detail_sex AS user_detail_sex_31,
  t27.user_detail_personal_id_type AS user_detail_personal_id_type_32,
  t27.user_detail_personal_id AS user_detail_personal_id_33,
  t27.user_detail_birthday AS user_detail_birthday_34,
  t27.user_detail_email AS user_detail_email_35,
  t27.user_detail_phone AS user_detail_phone_36,
  t27.user_detail_street AS user_detail_street_37,
  t27.user_detail_street_no AS user_detail_street_no_38,
  t27.user_detail_post_code AS user_detail_post_code_39,
  t27.user_detail_state AS user_detail_state_40,
  t27.user_detail_province AS user_detail_province_41,
  t27.user_detail_comunity AS user_detail_comunity_42,
  t27.user_detail_city AS user_detail_city_43,
  t27.user_detail_personal_id_hash AS user_detail_personal_id_hash_44,
  t27.user_detail_surname_hash AS user_detail_surname_hash_45,
  t27.user_id AS user_id_46
FROM
  user t0
  LEFT JOIN user_detail t27 ON t27.user_id = t0.user_id
WHERE
  t0.user_login = ?
LIMIT
  1

SELECT t0.user_id AS user_id_1, t0.user_outside_id AS user_outside_id_2, t0.user_type AS user_type_3, t0.user_api_type AS user_api_type_4, t0.user_login AS user_login_5, t0.user_password AS user_password_6, t0.user_checksum AS user_checksum_7, t0.user_status AS user_status_8, t0.user_token AS user_token_9, t0.user_token_exp AS user_token_exp_10, t0.user_last_login AS user_last_login_11, t0.user_created_at AS user_created_at_12, t0.user_updated_at AS user_updated_at_13, t0.user_deleted_at AS user_deleted_at_14, t0.user_public_approved AS user_public_approved_15, t0.user_public_blocked AS user_public_blocked_16, t0.user_public_app_code AS user_public_app_code_17, t0.user_public_app_code_sended_at AS user_public_app_code_sended_at_18, t0.user_public_app_code_registered_at AS user_public_app_code_registered_at_19, t0.user_option AS user_option_20, t0.user_public_app_code_hash AS user_public_app_code_hash_21, t0.user_api_setting_sms AS user_api_setting_sms_22, t0.user_api_setting_email AS user_api_setting_email_23, t0.user_api_setting_mobile AS user_api_setting_mobile_24, t0.user_special AS user_special_25, t0.google_authenticator_secret AS google_authenticator_secret_26, t27.user_detail_id AS user_detail_id_28, t27.user_detail_name AS user_detail_name_29, t27.user_detail_surname AS user_detail_surname_30, t27.user_detail_sex AS user_detail_sex_31, t27.user_detail_personal_id_type AS user_detail_personal_id_type_32, t27.user_detail_personal_id AS user_detail_personal_id_33, t27.user_detail_birthday AS user_detail_birthday_34, t27.user_detail_email AS user_detail_email_35, t27.user_detail_phone AS user_detail_phone_36, t27.user_detail_street AS user_detail_street_37, t27.user_detail_street_no AS user_detail_street_no_38, t27.user_detail_post_code AS user_detail_post_code_39, t27.user_detail_state AS user_detail_state_40, t27.user_detail_province AS user_detail_province_41, t27.user_detail_comunity AS user_detail_comunity_42, t27.user_detail_city AS user_detail_city_43, t27.user_detail_personal_id_hash AS user_detail_personal_id_hash_44, t27.user_detail_surname_hash AS user_detail_surname_hash_45, t27.user_id AS user_id_46 FROM user t0 LEFT JOIN user_detail t27 ON t27.user_id = t0.user_id WHERE t0.user_login = 'contento' LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 779)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 240)
3	Doctrine\ORM\EntityRepository->findOneBy (line 54)
4	Symfony\Bridge\Doctrine\Security\User\EntityUserProvider->loadUserByIdentifier (line 87)
5	Symfony\Component\Security\Http\Authenticator\Passport\Badge\UserBadge->getUser (line 56)
6	Symfony\Component\Security\Http\Authenticator\Passport\Passport->getUser (line 42)
7	Symfony\Component\Security\Http\EventListener\UserCheckerListener->preCheckCredentials (line 116)
8	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
9	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
10	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 139)
11	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 180)
12	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticator (line 158)
13	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticators (line 140)
14	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->authenticateRequest (line 40)
15	Symfony\Component\Security\Http\Firewall\AuthenticatorManagerListener->authenticate (line 68)
16	Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticatorManagerListener->authenticate (line 46)
17	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 26)
18	Symfony\Component\Security\Http\Firewall\AbstractListener->__invoke (line 83)
19	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 95)
20	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 116)
21	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
22	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
23	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 139)
24	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 157)
25	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
26	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
27	Symfony\Component\HttpKernel\Kernel->handle (line 35)
28	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
29	unknown (line 48)

0.39 ms

SELECT t0.user_to_role_id AS user_to_role_id_1, t0.read_perm AS read_perm_2, t0.write_perm AS write_perm_3, t0.user_to_role_created_at AS user_to_role_created_at_4, t0.user_to_role_updated_at AS user_to_role_updated_at_5, t0.user_id AS user_id_6, t0.user_role_id AS user_role_id_7 FROM user_to_role t0 WHERE t0.user_id = ?

Parameters:

[
  2
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.user_to_role_id AS user_to_role_id_1,
  t0.read_perm AS read_perm_2,
  t0.write_perm AS write_perm_3,
  t0.user_to_role_created_at AS user_to_role_created_at_4,
  t0.user_to_role_updated_at AS user_to_role_updated_at_5,
  t0.user_id AS user_id_6,
  t0.user_role_id AS user_role_id_7
FROM
  user_to_role t0
WHERE
  t0.user_id = ?

SELECT t0.user_to_role_id AS user_to_role_id_1, t0.read_perm AS read_perm_2, t0.write_perm AS write_perm_3, t0.user_to_role_created_at AS user_to_role_created_at_4, t0.user_to_role_updated_at AS user_to_role_updated_at_5, t0.user_id AS user_id_6, t0.user_role_id AS user_role_id_7 FROM user_to_role t0 WHERE t0.user_id = 2;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1928)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1869)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 3301)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 706)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 218)
6	Doctrine\ORM\PersistentCollection->initialize (line 313)
7	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 525)
8	App\Entity\User->getRoles (line 78)
9	Symfony\Component\Security\Http\Authenticator\HttpBasicAuthenticator->createToken (line 78)
10	Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator->createToken (line 198)
11	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticator (line 158)
12	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticators (line 140)
13	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->authenticateRequest (line 40)
14	Symfony\Component\Security\Http\Firewall\AuthenticatorManagerListener->authenticate (line 68)
15	Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticatorManagerListener->authenticate (line 46)
16	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 26)
17	Symfony\Component\Security\Http\Firewall\AbstractListener->__invoke (line 83)
18	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 95)
19	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 116)
20	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
21	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
22	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 139)
23	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 157)
24	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
25	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
26	Symfony\Component\HttpKernel\Kernel->handle (line 35)
27	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
28	unknown (line 48)

1.50 ms

SELECT t0.user_mob_device_id AS user_mob_device_id_1, t0.user_mob_device_uuid AS user_mob_device_uuid_2, t0.user_mob_device_push_notif_id AS user_mob_device_push_notif_id_3, t0.user_mob_device_created_at AS user_mob_device_created_at_4, t0.user_mob_device_refreshed_at AS user_mob_device_refreshed_at_5, t0.user_mob_device_default_lang AS user_mob_device_default_lang_6, t0.user_mob_device_sec_token AS user_mob_device_sec_token_7, t0.user_mob_device_sec_token_hash AS user_mob_device_sec_token_hash_8, t0.user_mob_device_app_version AS user_mob_device_app_version_9, t0.user_mob_device_model AS user_mob_device_model_10, t0.user_mob_device_os AS user_mob_device_os_11, t0.user_mob_device_user_id AS user_mob_device_user_id_12 FROM user_mob_device t0 WHERE t0.user_mob_device_uuid = ? AND t0.user_mob_device_sec_token = ? LIMIT 1

Parameters:

[
  "5D8EAA89-E049-4D4B-9790-E902B2708940"
  "412452a2-8535-4f30-b3b7-d42ca4548ba5-bcccc81d32ca5880a390b2983d9f5a119e518a45-c718244b-1da0-4c65-839a-698735306f4d"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.user_mob_device_id AS user_mob_device_id_1,
  t0.user_mob_device_uuid AS user_mob_device_uuid_2,
  t0.user_mob_device_push_notif_id AS user_mob_device_push_notif_id_3,
  t0.user_mob_device_created_at AS user_mob_device_created_at_4,
  t0.user_mob_device_refreshed_at AS user_mob_device_refreshed_at_5,
  t0.user_mob_device_default_lang AS user_mob_device_default_lang_6,
  t0.user_mob_device_sec_token AS user_mob_device_sec_token_7,
  t0.user_mob_device_sec_token_hash AS user_mob_device_sec_token_hash_8,
  t0.user_mob_device_app_version AS user_mob_device_app_version_9,
  t0.user_mob_device_model AS user_mob_device_model_10,
  t0.user_mob_device_os AS user_mob_device_os_11,
  t0.user_mob_device_user_id AS user_mob_device_user_id_12
FROM
  user_mob_device t0
WHERE
  t0.user_mob_device_uuid = ?
  AND t0.user_mob_device_sec_token = ?
LIMIT
  1

SELECT t0.user_mob_device_id AS user_mob_device_id_1, t0.user_mob_device_uuid AS user_mob_device_uuid_2, t0.user_mob_device_push_notif_id AS user_mob_device_push_notif_id_3, t0.user_mob_device_created_at AS user_mob_device_created_at_4, t0.user_mob_device_refreshed_at AS user_mob_device_refreshed_at_5, t0.user_mob_device_default_lang AS user_mob_device_default_lang_6, t0.user_mob_device_sec_token AS user_mob_device_sec_token_7, t0.user_mob_device_sec_token_hash AS user_mob_device_sec_token_hash_8, t0.user_mob_device_app_version AS user_mob_device_app_version_9, t0.user_mob_device_model AS user_mob_device_model_10, t0.user_mob_device_os AS user_mob_device_os_11, t0.user_mob_device_user_id AS user_mob_device_user_id_12 FROM user_mob_device t0 WHERE t0.user_mob_device_uuid = '5D8EAA89-E049-4D4B-9790-E902B2708940' AND t0.user_mob_device_sec_token = '412452a2-8535-4f30-b3b7-d42ca4548ba5-bcccc81d32ca5880a390b2983d9f5a119e518a45-c718244b-1da0-4c65-839a-698735306f4d' LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 779)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 240)
3	Doctrine\ORM\EntityRepository->findOneBy (line 25)
4	App\Service\HelperService->isRegistered (line 213)
5	App\Util\AbstractApiController->prepareAPIRequest (line 80)
6	App\Controller\Api\DeviceController->pushRegistration (line 181)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
9	Symfony\Component\HttpKernel\Kernel->handle (line 35)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
11	unknown (line 48)

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	No errors.
App\Entity\UserDetail	No errors.
App\Entity\UserToRole	No errors.
App\Entity\SendMethod	No errors.
App\Entity\Category	No errors.
App\Entity\Fault	No errors.
App\Entity\UserGroup	No errors.
App\Entity\UserMobDevice	The mappings App\Entity\UserMobDevice#userMobDeviceConfigs and App\Entity\UserMobDeviceConfig#user_mob_device are inconsistent with each other.
App\Entity\SendQueue	No errors.
App\Entity\Notice	No errors.
App\Entity\TerytHistory	No errors.
App\Entity\Unit	No errors.
App\Entity\UserToPartner	No errors.
App\Entity\UserToCityCard	No errors.
App\Entity\FormData	No errors.
App\Entity\UserToStatute	No errors.
App\Entity\UserToOutsideSystem	No errors.
App\Entity\UserRole	No errors.
App\Entity\UserMobDeviceToCategory	No errors.
App\Entity\UserMobDeviceToGarbage	No errors.
App\Entity\CityCardCode	No errors.
App\Entity\UserMobDeviceToken	No errors.
App\Entity\UserMobDeviceConfig	The association App\Entity\UserMobDeviceConfig#user_mob_device refers to the inverse side field App\Entity\UserMobDevice#userMobDeviceConfig which does not exist. The association App\Entity\UserMobDeviceConfig#key refers to the inverse side field App\Entity\UserMobDeviceConfigKey#userMobDeviceConfig which does not exist.
App\Entity\ContentLikesToUserMobDevice	No errors.

Symfony Profiler

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

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Entities Mapping