Symfony Profiler

Query Metrics

9 Database Queries

4 Different statements

3.48 ms Query time

0 Invalid entities

19 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

1.10 ms
(31.53%)

SELECT e0_.id AS id_0, e0_.company_name AS company_name_1, e0_.login_title AS login_title_2, e0_.logo_url AS logo_url_3, e0_.primary_color AS primary_color_4, e0_.background_color AS background_color_5, e0_.text_color AS text_color_6, e0_.terms_url AS terms_url_7, e0_.privacy_policy_url AS privacy_policy_url_8, e0_.sso_domain AS sso_domain_9, e0_.origin_urls AS origin_urls_10, e0_.enable_domain_redirect AS enable_domain_redirect_11, e0_.is_active AS is_active_12, e0_.created_at AS created_at_13, e0_.updated_at AS updated_at_14 FROM empresa_marca_blanca e0_ WHERE e0_.is_active = 1 AND e0_.sso_domain = ?

Parameters:

[
  "https://panel.smartescrow.eu"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  e0_.id AS id_0,
  e0_.company_name AS company_name_1,
  e0_.login_title AS login_title_2,
  e0_.logo_url AS logo_url_3,
  e0_.primary_color AS primary_color_4,
  e0_.background_color AS background_color_5,
  e0_.text_color AS text_color_6,
  e0_.terms_url AS terms_url_7,
  e0_.privacy_policy_url AS privacy_policy_url_8,
  e0_.sso_domain AS sso_domain_9,
  e0_.origin_urls AS origin_urls_10,
  e0_.enable_domain_redirect AS enable_domain_redirect_11,
  e0_.is_active AS is_active_12,
  e0_.created_at AS created_at_13,
  e0_.updated_at AS updated_at_14
FROM
  empresa_marca_blanca e0_
WHERE
  e0_.is_active = 1
  AND e0_.sso_domain = ?

SELECT e0_.id AS id_0, e0_.company_name AS company_name_1, e0_.login_title AS login_title_2, e0_.logo_url AS logo_url_3, e0_.primary_color AS primary_color_4, e0_.background_color AS background_color_5, e0_.text_color AS text_color_6, e0_.terms_url AS terms_url_7, e0_.privacy_policy_url AS privacy_policy_url_8, e0_.sso_domain AS sso_domain_9, e0_.origin_urls AS origin_urls_10, e0_.enable_domain_redirect AS enable_domain_redirect_11, e0_.is_active AS is_active_12, e0_.created_at AS created_at_13, e0_.updated_at AS updated_at_14 FROM empresa_marca_blanca e0_ WHERE e0_.is_active = 1 AND e0_.sso_domain = 'https://panel.smartescrow.eu';

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 737)
6	App\Repository\EmpresaMarcaBlancaRepository->findBySsoDomain (line 55)
7	App\EventSubscriber\DomainRedirectSubscriber->detectEmpresa (line 158)
8	App\EventSubscriber\DomainRedirectSubscriber->onKernelRequest (line 61)
9	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
10	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
11	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
12	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
13	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
14	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
15	Symfony\Component\HttpKernel\Kernel->handle (line 182)
16	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
17	require_once (line 29)
18	require_once (line 6)

1.08 ms
(31.00%)

SELECT t0.id AS id_1, t0.company_name AS company_name_2, t0.login_title AS login_title_3, t0.logo_url AS logo_url_4, t0.primary_color AS primary_color_5, t0.background_color AS background_color_6, t0.text_color AS text_color_7, t0.terms_url AS terms_url_8, t0.privacy_policy_url AS privacy_policy_url_9, t0.sso_domain AS sso_domain_10, t0.origin_urls AS origin_urls_11, t0.enable_domain_redirect AS enable_domain_redirect_12, t0.is_active AS is_active_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15 FROM empresa_marca_blanca t0 WHERE t0.is_active = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.company_name AS company_name_2,
  t0.login_title AS login_title_3,
  t0.logo_url AS logo_url_4,
  t0.primary_color AS primary_color_5,
  t0.background_color AS background_color_6,
  t0.text_color AS text_color_7,
  t0.terms_url AS terms_url_8,
  t0.privacy_policy_url AS privacy_policy_url_9,
  t0.sso_domain AS sso_domain_10,
  t0.origin_urls AS origin_urls_11,
  t0.enable_domain_redirect AS enable_domain_redirect_12,
  t0.is_active AS is_active_13,
  t0.created_at AS created_at_14,
  t0.updated_at AS updated_at_15
FROM
  empresa_marca_blanca t0
WHERE
  t0.is_active = ?

SELECT t0.id AS id_1, t0.company_name AS company_name_2, t0.login_title AS login_title_3, t0.logo_url AS logo_url_4, t0.primary_color AS primary_color_5, t0.background_color AS background_color_6, t0.text_color AS text_color_7, t0.terms_url AS terms_url_8, t0.privacy_policy_url AS privacy_policy_url_9, t0.sso_domain AS sso_domain_10, t0.origin_urls AS origin_urls_11, t0.enable_domain_redirect AS enable_domain_redirect_12, t0.is_active AS is_active_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15 FROM empresa_marca_blanca t0 WHERE t0.is_active = 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 963)
2	Doctrine\ORM\EntityRepository->findBy (line 110)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 73)
4	App\Repository\EmpresaMarcaBlancaRepository->findByOriginUrl (line 65)
5	App\EventSubscriber\DomainRedirectSubscriber->detectEmpresa (line 112)
6	App\EventSubscriber\DomainRedirectSubscriber->onKernelRequest (line 61)
7	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
8	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
9	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
10	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
13	Symfony\Component\HttpKernel\Kernel->handle (line 182)
14	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
15	require_once (line 29)
16	require_once (line 6)

0.78 ms
(22.29%)

SELECT t0.id AS id_1, t0.platform_domains AS platform_domains_2, t0.is_active AS is_active_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.empresa_marca_blanca_id AS empresa_marca_blanca_id_6, t0.oauth_client_id AS oauth_client_id_7 FROM plataforma_marca_blanca t0 WHERE t0.is_active = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.platform_domains AS platform_domains_2,
  t0.is_active AS is_active_3,
  t0.created_at AS created_at_4,
  t0.updated_at AS updated_at_5,
  t0.empresa_marca_blanca_id AS empresa_marca_blanca_id_6,
  t0.oauth_client_id AS oauth_client_id_7
FROM
  plataforma_marca_blanca t0
WHERE
  t0.is_active = ?

SELECT t0.id AS id_1, t0.platform_domains AS platform_domains_2, t0.is_active AS is_active_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.empresa_marca_blanca_id AS empresa_marca_blanca_id_6, t0.oauth_client_id AS oauth_client_id_7 FROM plataforma_marca_blanca t0 WHERE t0.is_active = 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 963)
2	Doctrine\ORM\EntityRepository->findBy (line 110)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 73)
4	App\Repository\PlataformaMarcaBlancaRepository->findByPlatformDomain (line 49)
5	App\EventSubscriber\DomainRedirectSubscriber->detectEmpresa (line 119)
6	App\EventSubscriber\DomainRedirectSubscriber->onKernelRequest (line 61)
7	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
8	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
9	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
10	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
13	Symfony\Component\HttpKernel\Kernel->handle (line 182)
14	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
15	require_once (line 29)
16	require_once (line 6)

0.53 ms
(15.18%)

SELECT t0.id AS id_1, t0.identifier AS identifier_2, t0.secret AS secret_3, t0.name AS name_4, t0.redirect_uris AS redirect_uris_5, t0.grant_types AS grant_types_6, t0.scopes AS scopes_7, t0.is_confidential AS is_confidential_8, t0.logo_url AS logo_url_9, t0.help_text AS help_text_10, t0.terms_url AS terms_url_11, t0.privacy_policy_url AS privacy_policy_url_12, t0.created_at AS created_at_13 FROM oauth_client t0 WHERE t0.identifier = ? LIMIT 1

Parameters:

[
  "wallet"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.identifier AS identifier_2,
  t0.secret AS secret_3,
  t0.name AS name_4,
  t0.redirect_uris AS redirect_uris_5,
  t0.grant_types AS grant_types_6,
  t0.scopes AS scopes_7,
  t0.is_confidential AS is_confidential_8,
  t0.logo_url AS logo_url_9,
  t0.help_text AS help_text_10,
  t0.terms_url AS terms_url_11,
  t0.privacy_policy_url AS privacy_policy_url_12,
  t0.created_at AS created_at_13
FROM
  oauth_client t0
WHERE
  t0.identifier = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.identifier AS identifier_2, t0.secret AS secret_3, t0.name AS name_4, t0.redirect_uris AS redirect_uris_5, t0.grant_types AS grant_types_6, t0.scopes AS scopes_7, t0.is_confidential AS is_confidential_8, t0.logo_url AS logo_url_9, t0.help_text AS help_text_10, t0.terms_url AS terms_url_11, t0.privacy_policy_url AS privacy_policy_url_12, t0.created_at AS created_at_13 FROM oauth_client t0 WHERE t0.identifier = 'wallet' LIMIT 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\EntityRepository->findOneBy (line 125)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 81)
4	App\Repository\OAuthClientRepository->findOneByIdentifier (line 44)
5	App\Service\BrandingResolverService->resolveBranding (line 84)
6	App\Controller\SecurityController->login (line 89)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
9	Symfony\Component\HttpKernel\Kernel->handle (line 182)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
11	require_once (line 29)
12	require_once (line 6)

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\PlataformaMarcaBlanca	11
App\Entity\OAuthClient	5
App\Entity\EmpresaMarcaBlanca	3

Entities Mapping

Class	Mapping errors
App\Entity\EmpresaMarcaBlanca	No errors.
App\Entity\PlataformaMarcaBlanca	No errors.
App\Entity\OAuthClient	No errors.
App\Entity\User	No errors.

Symfony Profiler

GET https://panel.smartescrow.eu/login?client_id=wallet&code_challenge=cSA97f1BapEcyGVloCJJOUzkGbwDwfz4zV_QRouVP5s&code_challenge_method=S256&origin=https%3A%2F%2Fw…

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping