Symfony Profiler

Query Metrics

7 Database Queries

3 Different statements

2.55 ms Query time

0 Invalid entities

23 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

0.97 ms
(37.98%)

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_.contact_url AS contact_url_9, e0_.sso_domain AS sso_domain_10, e0_.origin_urls AS origin_urls_11, e0_.enable_domain_redirect AS enable_domain_redirect_12, e0_.is_active AS is_active_13, e0_.created_at AS created_at_14, e0_.updated_at AS updated_at_15 FROM empresa_marca_blanca e0_ WHERE e0_.is_active = 1 AND e0_.sso_domain = ?

Parameters:

[
  "https://panel.azelafinance.com"
]

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_.contact_url AS contact_url_9,
  e0_.sso_domain AS sso_domain_10,
  e0_.origin_urls AS origin_urls_11,
  e0_.enable_domain_redirect AS enable_domain_redirect_12,
  e0_.is_active AS is_active_13,
  e0_.created_at AS created_at_14,
  e0_.updated_at AS updated_at_15
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_.contact_url AS contact_url_9, e0_.sso_domain AS sso_domain_10, e0_.origin_urls AS origin_urls_11, e0_.enable_domain_redirect AS enable_domain_redirect_12, e0_.is_active AS is_active_13, e0_.created_at AS created_at_14, e0_.updated_at AS updated_at_15 FROM empresa_marca_blanca e0_ WHERE e0_.is_active = 1 AND e0_.sso_domain = 'https://panel.azelafinance.com';

#	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 193)
16	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
17	require_once (line 29)
18	require_once (line 6)

0.95 ms
(37.35%)

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.contact_url AS contact_url_10, t0.sso_domain AS sso_domain_11, t0.origin_urls AS origin_urls_12, t0.enable_domain_redirect AS enable_domain_redirect_13, t0.is_active AS is_active_14, t0.created_at AS created_at_15, t0.updated_at AS updated_at_16 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.contact_url AS contact_url_10,
  t0.sso_domain AS sso_domain_11,
  t0.origin_urls AS origin_urls_12,
  t0.enable_domain_redirect AS enable_domain_redirect_13,
  t0.is_active AS is_active_14,
  t0.created_at AS created_at_15,
  t0.updated_at AS updated_at_16
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.contact_url AS contact_url_10, t0.sso_domain AS sso_domain_11, t0.origin_urls AS origin_urls_12, t0.enable_domain_redirect AS enable_domain_redirect_13, t0.is_active AS is_active_14, t0.created_at AS created_at_15, t0.updated_at AS updated_at_16 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 137)
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 193)
14	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
15	require_once (line 29)
16	require_once (line 6)

0.63 ms
(24.67%)

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 144)
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 193)
14	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
15	require_once (line 29)
16	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	15
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.

Symfony Profiler

GET https://panel.azelafinance.com/login

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping