Symfony Profiler

Query Metrics

3 Database Queries

2 Different statements

3.03 ms Query time

0 Invalid entities

0 Managed entities

Grouped Statements

Show all queries

default connection

Time▼

Count

Info

1.65 ms
(54.55%)

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\Twig\BrandingExtension->resolveBranding (line 110)
10	CTS\SkeletonCore\Twig\BrandingExtension->getGlobals (line 34)
11	Twig\ExtensionSet->getGlobals (line 365)
12	Twig\Environment->getGlobals (line 908)
13	Twig\Template->yield (line 406)
14	Twig\Template->display (line 366)
15	Twig\Template->render (line 381)
16	Twig\TemplateWrapper->render (line 51)
17	Twig\Environment->render (line 333)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
21	CTS\SkeletonCore\Controller\ErrorController->show (line 41)
22	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
23	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
24	Symfony\Component\HttpKernel\EventListener\ErrorListener->onKernelException (line 99)
25	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
26	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
27	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
28	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 129)
29	Symfony\Component\HttpKernel\HttpKernel->handleThrowable (line 241)
30	Symfony\Component\HttpKernel\HttpKernel->handle (line 91)
31	Symfony\Component\HttpKernel\Kernel->handle (line 193)
32	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
33	require_once (line 32)
34	require_once (line 5)

1.38 ms
(45.45%)

SELECT t0.id AS id_1, t0.slug AS slug_2, t0.display_name AS display_name_3, t0.status AS status_4, t0.db_name AS db_name_5, t0.php_fpm_socket AS php_fpm_socket_6, t0.subdomain AS subdomain_7, t0.custom_domain AS custom_domain_8, t0.mercure_jwt_secret AS mercure_jwt_secret_9, t0.branding AS branding_10, t0.notes AS notes_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.provisioned_at AS provisioned_at_14, t0.suspended_at AS suspended_at_15, t0.archived_at AS archived_at_16, t0.license_key AS license_key_17, t0.self_organization_id AS self_organization_id_18 FROM cp_tenants t0 WHERE t0.slug = ? LIMIT 1

Parameters:

[
  "local"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.slug AS slug_2,
  t0.display_name AS display_name_3,
  t0.status AS status_4,
  t0.db_name AS db_name_5,
  t0.php_fpm_socket AS php_fpm_socket_6,
  t0.subdomain AS subdomain_7,
  t0.custom_domain AS custom_domain_8,
  t0.mercure_jwt_secret AS mercure_jwt_secret_9,
  t0.branding AS branding_10,
  t0.notes AS notes_11,
  t0.created_at AS created_at_12,
  t0.updated_at AS updated_at_13,
  t0.provisioned_at AS provisioned_at_14,
  t0.suspended_at AS suspended_at_15,
  t0.archived_at AS archived_at_16,
  t0.license_key AS license_key_17,
  t0.self_organization_id AS self_organization_id_18
FROM
  cp_tenants t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.slug AS slug_2, t0.display_name AS display_name_3, t0.status AS status_4, t0.db_name AS db_name_5, t0.php_fpm_socket AS php_fpm_socket_6, t0.subdomain AS subdomain_7, t0.custom_domain AS custom_domain_8, t0.mercure_jwt_secret AS mercure_jwt_secret_9, t0.branding AS branding_10, t0.notes AS notes_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.provisioned_at AS provisioned_at_14, t0.suspended_at AS suspended_at_15, t0.archived_at AS archived_at_16, t0.license_key AS license_key_17, t0.self_organization_id AS self_organization_id_18 FROM cp_tenants t0 WHERE t0.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\Persisters\Entity\BasicEntityPersister->load (line 738)
4	Doctrine\ORM\EntityRepository->findOneBy (line 125)
5	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 81)
6	CTS\SkeletonCore\Repository\TenantRepository->findOneBySlug (line 24)
7	CTS\SkeletonCore\Twig\LicenseExtension->resolveLicenseCheck (line 51)
8	CTS\SkeletonCore\Twig\LicenseExtension->getGlobals (line 37)
9	Twig\ExtensionSet->getGlobals (line 365)
10	Twig\Environment->getGlobals (line 908)
11	Twig\Template->yield (line 406)
12	Twig\Template->display (line 366)
13	Twig\Template->render (line 381)
14	Twig\TemplateWrapper->render (line 51)
15	Twig\Environment->render (line 333)
16	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
19	CTS\SkeletonCore\Controller\ErrorController->show (line 41)
20	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
21	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
22	Symfony\Component\HttpKernel\EventListener\ErrorListener->onKernelException (line 99)
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->handleThrowable (line 241)
28	Symfony\Component\HttpKernel\HttpKernel->handle (line 91)
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)

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

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\Shared\Entity\Organization	No errors.
CTS\Shared\Entity\OrganizationType	No errors.
CTS\Shared\Entity\OrganizationDocument	No errors.
CTS\Shared\Entity\UserOrganization	No errors.
CTS\Shared\Entity\OrganizationAddress	No errors.
CTS\Shared\Entity\Contact	No errors.
CTS\Shared\Entity\OrganizationAlias	No errors.
CTS\Shared\Entity\OrganizationPaymentTerm	No errors.
CTS\Shared\Entity\AgentNetworkMembership	No errors.
CTS\Shared\Entity\AgentNetwork	No errors.
CTS\Shared\Entity\Airline	No errors.
CTS\Shared\Entity\SeaCarrier	No errors.
CTS\Shared\Entity\ErpConnection	No errors.
CTS\SkeletonCore\Entity\User	No errors.
CTS\Shared\Entity\PaymentCondition	No errors.
CTS\Shared\Entity\OrganizationErpId	No errors.

legacy entity manager

No loaded entities.

legacy_adhocs entity manager

No loaded entities.

Symfony Profiler

GET https://cargopulse.srv2.nesh.pt/privacy

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