Symfony Profiler

Query Metrics

4 Database Queries

4 Different statements

19.72 ms Query time

0 Invalid entities

1 Managed entities

Grouped Statements

Show all queries

default connection

Time▼

Count

Info

16.53 ms
(83.80%)

UPDATE `user` SET last_login_at = ? WHERE id = ?

Parameters:

[
  "2026-08-10 20:36:16"
  90
]

View formatted query View runnable query Explain query View query backtrace

UPDATE
  `user`
SET
  last_login_at = ?
WHERE
  id = ?

UPDATE `user` SET last_login_at = '2026-08-10 20:36:16' WHERE id = 90;

#	File/Call
1	Sentry\SentryBundle\Tracing\Doctrine\DBAL\TracingStatementForV4->execute (line 36)
2	Doctrine\DBAL\Connection->executeStatement (line 903)
3	CTS\SkeletonCore\EventListener\LastLoginListener->onLoginSuccess (line 45)
4	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
5	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
6	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
7	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 129)
8	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->handleAuthenticationSuccess (line 250)
9	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticator (line 230)
10	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticators (line 167)
11	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->authenticateRequest (line 149)
12	Symfony\Component\Security\Http\Firewall\AuthenticatorManagerListener->authenticate (line 38)
13	Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticatorManagerListener->authenticate (line 58)
14	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 46)
15	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->authenticate (line 70)
16	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 94)
17	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 93)
18	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
19	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
20	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
21	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 129)
22	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
23	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
24	Symfony\Component\HttpKernel\Kernel->handle (line 193)
25	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
26	require_once (line 32)
27	require_once (line 5)

1.33 ms
(6.75%)

SELECT t0.id AS id_1, t0.display_name AS display_name_2, t0.roles AS roles_3, t0.password AS password_4, t0.email_address AS email_address_5, t0.user_name AS user_name_6, t0.is_verified AS is_verified_7, t0.google_id AS google_id_8, t0.google_access_token AS google_access_token_9, t0.azure_id AS azure_id_10, t0.azure_access_token AS azure_access_token_11, t0.is_on_premise AS is_on_premise_12, t0.preferred_theme AS preferred_theme_13, t0.preferred_locale AS preferred_locale_14, t0.api_key AS api_key_15, t0.api_key_generated_at AS api_key_generated_at_16, t0.is_customer_user AS is_customer_user_17, t0.last_login_at AS last_login_at_18, t0.email_signature AS email_signature_19, t0.is_commercial AS is_commercial_20, t0.is_awb_signer AS is_awb_signer_21, t0.is_operator AS is_operator_22, t0.profile_image_path AS profile_image_path_23, t0.job_title AS job_title_24, t0.ui_preferences AS ui_preferences_25, t0.privacy_consented_at AS privacy_consented_at_26, t0.phone AS phone_27, t0.mobile_phone AS mobile_phone_28, t0.website AS website_29, t0.totp_secret AS totp_secret_30, t0.is_two_factor_enabled AS is_two_factor_enabled_31, t0.allowed_ip_ranges AS allowed_ip_ranges_32, t0.is_active AS is_active_33, t0.department_id AS department_id_34, t0.current_department_id AS current_department_id_35, t0.customer_organization_id AS customer_organization_id_36 FROM user t0 WHERE t0.email_address = ? LIMIT 1

Parameters:

[
  "demo@cargopulse.local"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.display_name AS display_name_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.email_address AS email_address_5,
  t0.user_name AS user_name_6,
  t0.is_verified AS is_verified_7,
  t0.google_id AS google_id_8,
  t0.google_access_token AS google_access_token_9,
  t0.azure_id AS azure_id_10,
  t0.azure_access_token AS azure_access_token_11,
  t0.is_on_premise AS is_on_premise_12,
  t0.preferred_theme AS preferred_theme_13,
  t0.preferred_locale AS preferred_locale_14,
  t0.api_key AS api_key_15,
  t0.api_key_generated_at AS api_key_generated_at_16,
  t0.is_customer_user AS is_customer_user_17,
  t0.last_login_at AS last_login_at_18,
  t0.email_signature AS email_signature_19,
  t0.is_commercial AS is_commercial_20,
  t0.is_awb_signer AS is_awb_signer_21,
  t0.is_operator AS is_operator_22,
  t0.profile_image_path AS profile_image_path_23,
  t0.job_title AS job_title_24,
  t0.ui_preferences AS ui_preferences_25,
  t0.privacy_consented_at AS privacy_consented_at_26,
  t0.phone AS phone_27,
  t0.mobile_phone AS mobile_phone_28,
  t0.website AS website_29,
  t0.totp_secret AS totp_secret_30,
  t0.is_two_factor_enabled AS is_two_factor_enabled_31,
  t0.allowed_ip_ranges AS allowed_ip_ranges_32,
  t0.is_active AS is_active_33,
  t0.department_id AS department_id_34,
  t0.current_department_id AS current_department_id_35,
  t0.customer_organization_id AS customer_organization_id_36
FROM
  user t0
WHERE
  t0.email_address = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.display_name AS display_name_2, t0.roles AS roles_3, t0.password AS password_4, t0.email_address AS email_address_5, t0.user_name AS user_name_6, t0.is_verified AS is_verified_7, t0.google_id AS google_id_8, t0.google_access_token AS google_access_token_9, t0.azure_id AS azure_id_10, t0.azure_access_token AS azure_access_token_11, t0.is_on_premise AS is_on_premise_12, t0.preferred_theme AS preferred_theme_13, t0.preferred_locale AS preferred_locale_14, t0.api_key AS api_key_15, t0.api_key_generated_at AS api_key_generated_at_16, t0.is_customer_user AS is_customer_user_17, t0.last_login_at AS last_login_at_18, t0.email_signature AS email_signature_19, t0.is_commercial AS is_commercial_20, t0.is_awb_signer AS is_awb_signer_21, t0.is_operator AS is_operator_22, t0.profile_image_path AS profile_image_path_23, t0.job_title AS job_title_24, t0.ui_preferences AS ui_preferences_25, t0.privacy_consented_at AS privacy_consented_at_26, t0.phone AS phone_27, t0.mobile_phone AS mobile_phone_28, t0.website AS website_29, t0.totp_secret AS totp_secret_30, t0.is_two_factor_enabled AS is_two_factor_enabled_31, t0.allowed_ip_ranges AS allowed_ip_ranges_32, t0.is_active AS is_active_33, t0.department_id AS department_id_34, t0.current_department_id AS current_department_id_35, t0.customer_organization_id AS customer_organization_id_36 FROM user t0 WHERE t0.email_address = 'demo@cargopulse.local' LIMIT 1;

#	File/Call
1	Sentry\SentryBundle\Tracing\Doctrine\DBAL\TracingStatementForV4->execute (line 36)
2	Doctrine\DBAL\Connection->executeQuery (line 800)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
4	Doctrine\ORM\EntityRepository->findOneBy (line 125)
5	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 81)
6	Symfony\Bridge\Doctrine\Security\User\EntityUserProvider->loadUserByIdentifier (line 57)
7	Symfony\Component\Security\Http\Authenticator\Passport\Badge\UserBadge->getUser (line 97)
8	Symfony\Component\Security\Http\Authenticator\Passport\Passport->getUser (line 56)
9	Symfony\Component\Security\Http\EventListener\UserCheckerListener->preCheckCredentials (line 40)
10	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
11	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
12	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
13	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 129)
14	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticator (line 189)
15	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticators (line 167)
16	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->authenticateRequest (line 149)
17	Symfony\Component\Security\Http\Firewall\AuthenticatorManagerListener->authenticate (line 38)
18	Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticatorManagerListener->authenticate (line 58)
19	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 46)
20	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->authenticate (line 70)
21	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 94)
22	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 93)
23	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
24	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
25	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
26	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 129)
27	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
28	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
29	Symfony\Component\HttpKernel\Kernel->handle (line 193)
30	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
31	require_once (line 32)
32	require_once (line 5)

1.22 ms
(6.17%)

SELECT c0_.id AS id_0, c0_.display_name AS display_name_1, c0_.legal_name AS legal_name_2, c0_.tagline AS tagline_3, c0_.logo_path AS logo_path_4, c0_.logo_light_path AS logo_light_path_5, c0_.favicon_path AS favicon_path_6, c0_.primary_color AS primary_color_7, c0_.accent_color AS accent_color_8, c0_.dark_sidebar AS dark_sidebar_9, c0_.template AS template_10, c0_.powered_by AS powered_by_11, c0_.email_from_name AS email_from_name_12, c0_.email_from_address AS email_from_address_13, c0_.email_reply_to AS email_reply_to_14, c0_.commercial_from_name AS commercial_from_name_15, c0_.commercial_from_address AS commercial_from_address_16, c0_.finance_from_name AS finance_from_name_17, c0_.finance_from_address AS finance_from_address_18, c0_.portal_from_name AS portal_from_name_19, c0_.portal_from_address AS portal_from_address_20, c0_.portal_reply_to AS portal_reply_to_21, c0_.portal_domain AS portal_domain_22, c0_.portal_domain_status AS portal_domain_status_23, c0_.portal_domain_status_message AS portal_domain_status_message_24, c0_.portal_domain_verified_at AS portal_domain_verified_at_25, c0_.portal_domain_attempted_at AS portal_domain_attempted_at_26, c0_.portal_notification_emails AS portal_notification_emails_27, c0_.email_footer_html AS email_footer_html_28, c0_.bank_accounts AS bank_accounts_29, c0_.email_transport AS email_transport_30, c0_.email_transport_config AS email_transport_config_31, c0_.login_background_path AS login_background_path_32, c0_.login_page_message AS login_page_message_33, c0_.custom_css AS custom_css_34, c0_.locale_default AS locale_default_35, c0_.timezone_default AS timezone_default_36, c0_.compliance_request_default_basis AS compliance_request_default_basis_37, c0_.notes AS notes_38, c0_.created_at AS created_at_39, c0_.updated_at AS updated_at_40, c0_.tenant_id AS tenant_id_41 FROM cp_branding c0_ INNER JOIN cp_tenants c1_ ON c0_.tenant_id = c1_.id WHERE c1_.slug = ? LIMIT 1

Parameters:

[
  "local"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  c0_.id AS id_0,
  c0_.display_name AS display_name_1,
  c0_.legal_name AS legal_name_2,
  c0_.tagline AS tagline_3,
  c0_.logo_path AS logo_path_4,
  c0_.logo_light_path AS logo_light_path_5,
  c0_.favicon_path AS favicon_path_6,
  c0_.primary_color AS primary_color_7,
  c0_.accent_color AS accent_color_8,
  c0_.dark_sidebar AS dark_sidebar_9,
  c0_.template AS template_10,
  c0_.powered_by AS powered_by_11,
  c0_.email_from_name AS email_from_name_12,
  c0_.email_from_address AS email_from_address_13,
  c0_.email_reply_to AS email_reply_to_14,
  c0_.commercial_from_name AS commercial_from_name_15,
  c0_.commercial_from_address AS commercial_from_address_16,
  c0_.finance_from_name AS finance_from_name_17,
  c0_.finance_from_address AS finance_from_address_18,
  c0_.portal_from_name AS portal_from_name_19,
  c0_.portal_from_address AS portal_from_address_20,
  c0_.portal_reply_to AS portal_reply_to_21,
  c0_.portal_domain AS portal_domain_22,
  c0_.portal_domain_status AS portal_domain_status_23,
  c0_.portal_domain_status_message AS portal_domain_status_message_24,
  c0_.portal_domain_verified_at AS portal_domain_verified_at_25,
  c0_.portal_domain_attempted_at AS portal_domain_attempted_at_26,
  c0_.portal_notification_emails AS portal_notification_emails_27,
  c0_.email_footer_html AS email_footer_html_28,
  c0_.bank_accounts AS bank_accounts_29,
  c0_.email_transport AS email_transport_30,
  c0_.email_transport_config AS email_transport_config_31,
  c0_.login_background_path AS login_background_path_32,
  c0_.login_page_message AS login_page_message_33,
  c0_.custom_css AS custom_css_34,
  c0_.locale_default AS locale_default_35,
  c0_.timezone_default AS timezone_default_36,
  c0_.compliance_request_default_basis AS compliance_request_default_basis_37,
  c0_.notes AS notes_38,
  c0_.created_at AS created_at_39,
  c0_.updated_at AS updated_at_40,
  c0_.tenant_id AS tenant_id_41
FROM
  cp_branding c0_
  INNER JOIN cp_tenants c1_ ON c0_.tenant_id = c1_.id
WHERE
  c1_.slug = ?
LIMIT
  1

SELECT c0_.id AS id_0, c0_.display_name AS display_name_1, c0_.legal_name AS legal_name_2, c0_.tagline AS tagline_3, c0_.logo_path AS logo_path_4, c0_.logo_light_path AS logo_light_path_5, c0_.favicon_path AS favicon_path_6, c0_.primary_color AS primary_color_7, c0_.accent_color AS accent_color_8, c0_.dark_sidebar AS dark_sidebar_9, c0_.template AS template_10, c0_.powered_by AS powered_by_11, c0_.email_from_name AS email_from_name_12, c0_.email_from_address AS email_from_address_13, c0_.email_reply_to AS email_reply_to_14, c0_.commercial_from_name AS commercial_from_name_15, c0_.commercial_from_address AS commercial_from_address_16, c0_.finance_from_name AS finance_from_name_17, c0_.finance_from_address AS finance_from_address_18, c0_.portal_from_name AS portal_from_name_19, c0_.portal_from_address AS portal_from_address_20, c0_.portal_reply_to AS portal_reply_to_21, c0_.portal_domain AS portal_domain_22, c0_.portal_domain_status AS portal_domain_status_23, c0_.portal_domain_status_message AS portal_domain_status_message_24, c0_.portal_domain_verified_at AS portal_domain_verified_at_25, c0_.portal_domain_attempted_at AS portal_domain_attempted_at_26, c0_.portal_notification_emails AS portal_notification_emails_27, c0_.email_footer_html AS email_footer_html_28, c0_.bank_accounts AS bank_accounts_29, c0_.email_transport AS email_transport_30, c0_.email_transport_config AS email_transport_config_31, c0_.login_background_path AS login_background_path_32, c0_.login_page_message AS login_page_message_33, c0_.custom_css AS custom_css_34, c0_.locale_default AS locale_default_35, c0_.timezone_default AS timezone_default_36, c0_.compliance_request_default_basis AS compliance_request_default_basis_37, c0_.notes AS notes_38, c0_.created_at AS created_at_39, c0_.updated_at AS updated_at_40, c0_.tenant_id AS tenant_id_41 FROM cp_branding c0_ INNER JOIN cp_tenants c1_ ON c0_.tenant_id = c1_.id WHERE c1_.slug = 'local' LIMIT 1;

#	File/Call
1	Sentry\SentryBundle\Tracing\Doctrine\DBAL\TracingStatementForV4->execute (line 36)
2	Doctrine\DBAL\Connection->executeQuery (line 800)
3	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
4	Doctrine\ORM\Query->_doExecute (line 296)
5	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
6	Doctrine\ORM\AbstractQuery->execute (line 886)
7	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 737)
8	CTS\SkeletonCore\Repository\BrandingRepository->findByTenantSlug (line 30)
9	CTS\SkeletonCore\Service\ClientPortalUrlGenerator->resolveBranding (line 85)
10	CTS\SkeletonCore\Service\ClientPortalUrlGenerator->portalDomain (line 52)
11	CTS\SkeletonCore\EventSubscriber\ClientPortalHostSubscriber->onKernelRequest (line 62)
12	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
13	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
14	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
15	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 129)
16	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
17	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
18	Symfony\Component\HttpKernel\Kernel->handle (line 193)
19	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
20	require_once (line 32)
21	require_once (line 5)

0.65 ms
(3.28%)

SELECT enabled FROM tenant_module_state WHERE tenant_slug = ? AND module_key = ? LIMIT 1

Parameters:

[
  "local"
  "capability.oauth-login"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  enabled
FROM
  tenant_module_state
WHERE
  tenant_slug = ?
  AND module_key = ?
LIMIT
  1

SELECT enabled FROM tenant_module_state WHERE tenant_slug = 'local' AND module_key = 'capability.oauth-login' LIMIT 1;

#	File/Call
1	Sentry\SentryBundle\Tracing\Doctrine\DBAL\TracingStatementForV4->execute (line 36)
2	Doctrine\DBAL\Connection->executeQuery (line 800)
3	Doctrine\DBAL\Connection->fetchOne (line 330)
4	CTS\Shared\Module\Service\ModuleEnabledChecker->isEnabled (line 85)
5	CTS\SkeletonCore\Security\OAuthLoginCapabilityChecker->isEnabled (line 29)
6	Cargotech\OauthLogin\Security\OAuthLoginAuthenticator->supports (line 50)
7	Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator->supports (line 65)
8	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->supports (line 120)
9	Symfony\Component\Security\Http\Firewall\AuthenticatorManagerListener->supports (line 32)
10	Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticatorManagerListener->supports (line 35)
11	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->supports (line 38)
12	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->authenticate (line 62)
13	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 94)
14	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 93)
15	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
16	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
17	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
18	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 129)
19	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
20	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
21	Symfony\Component\HttpKernel\Kernel->handle (line 193)
22	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
23	require_once (line 32)
24	require_once (line 5)

Database Connections

Name	Service
default	doctrine.dbal.default_connection
legacy	doctrine.dbal.legacy_connection
legacy_adhocs	doctrine.dbal.legacy_adhocs_connection

Entity Managers

Name	Service
default	doctrine.orm.default_entity_manager
legacy	doctrine.orm.legacy_entity_manager
legacy_adhocs	doctrine.orm.legacy_adhocs_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

default entity manager

Class	Amount of managed objects
CTS\SkeletonCore\Entity\User	1

legacy entity manager

Class	Amount of managed objects

legacy_adhocs entity manager

Class	Amount of managed objects

Entities Mapping

default entity manager

Class	Mapping errors
CTS\SkeletonCore\Entity\Branding	No errors.
CTS\SkeletonCore\Entity\Tenant	No errors.
CTS\SkeletonCore\Entity\User	No errors.
CTS\Shared\Entity\Department	No errors.
CTS\Shared\Entity\Organization	No errors.
CTS\Shared\Entity\UserOrganization	No errors.

legacy entity manager

No loaded entities.

legacy_adhocs entity manager

No loaded entities.

Symfony Profiler

POST https://cargopulse.srv2.nesh.pt/pt_PT/login

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

default connection

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

legacy entity manager

legacy_adhocs entity manager

Entities Mapping

default entity manager

legacy entity manager

legacy_adhocs entity manager