Symfony Profiler

Query Metrics

3 Database Queries

1 Different statements

1.83 ms Query time

0 Invalid entities

0 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

1.83 ms
(100.00%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.domain AS domain_3, t0.active AS active_4, t0.from_email AS from_email_5, t0.from_name AS from_name_6, t0.office365_client_id AS office365_client_id_7, t0.office365_client_secret AS office365_client_secret_8, t0.office365_tenant_id AS office365_tenant_id_9, t0.office365_redirect_uri AS office365_redirect_uri_10, t0.stripe_secret_key AS stripe_secret_key_11, t0.stripe_publishable_key AS stripe_publishable_key_12, t0.stripe_webhook_secret AS stripe_webhook_secret_13, t14.id AS id_15, t14.access_token AS access_token_16, t14.refresh_token AS refresh_token_17, t14.expires_at AS expires_at_18, t14.created_at AS created_at_19, t14.updated_at AS updated_at_20, t14.tenant_id AS tenant_id_21 FROM tenants t0 LEFT JOIN oauth_tokens t14 ON t14.tenant_id = t0.id WHERE t0.domain = ? LIMIT 1

Parameters:

[
  "116.203.200.184"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.domain AS domain_3,
  t0.active AS active_4,
  t0.from_email AS from_email_5,
  t0.from_name AS from_name_6,
  t0.office365_client_id AS office365_client_id_7,
  t0.office365_client_secret AS office365_client_secret_8,
  t0.office365_tenant_id AS office365_tenant_id_9,
  t0.office365_redirect_uri AS office365_redirect_uri_10,
  t0.stripe_secret_key AS stripe_secret_key_11,
  t0.stripe_publishable_key AS stripe_publishable_key_12,
  t0.stripe_webhook_secret AS stripe_webhook_secret_13,
  t14.id AS id_15,
  t14.access_token AS access_token_16,
  t14.refresh_token AS refresh_token_17,
  t14.expires_at AS expires_at_18,
  t14.created_at AS created_at_19,
  t14.updated_at AS updated_at_20,
  t14.tenant_id AS tenant_id_21
FROM
  tenants t0
  LEFT JOIN oauth_tokens t14 ON t14.tenant_id = t0.id
WHERE
  t0.domain = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.domain AS domain_3, t0.active AS active_4, t0.from_email AS from_email_5, t0.from_name AS from_name_6, t0.office365_client_id AS office365_client_id_7, t0.office365_client_secret AS office365_client_secret_8, t0.office365_tenant_id AS office365_tenant_id_9, t0.office365_redirect_uri AS office365_redirect_uri_10, t0.stripe_secret_key AS stripe_secret_key_11, t0.stripe_publishable_key AS stripe_publishable_key_12, t0.stripe_webhook_secret AS stripe_webhook_secret_13, t14.id AS id_15, t14.access_token AS access_token_16, t14.refresh_token AS refresh_token_17, t14.expires_at AS expires_at_18, t14.created_at AS created_at_19, t14.updated_at AS updated_at_20, t14.tenant_id AS tenant_id_21 FROM tenants t0 LEFT JOIN oauth_tokens t14 ON t14.tenant_id = t0.id WHERE t0.domain = '116.203.200.184' 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\Security\TenantRoleListener->onKernelRequest (line 39)
5	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
6	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
7	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
8	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
11	Symfony\Component\HttpKernel\EventListener\ErrorListener->onKernelException (line 99)
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 126)
16	Symfony\Component\HttpKernel\HttpKernel->handleThrowable (line 241)
17	Symfony\Component\HttpKernel\HttpKernel->handle (line 91)
18	Symfony\Component\HttpKernel\Kernel->handle (line 182)
19	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
20	require_once (line 29)
21	require_once (line 5)

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

Entities Mapping

Class	Mapping errors
App\Entity\Tenant	No errors.
App\Entity\OAuthToken	No errors.

Symfony Profiler

GET https://116.203.200.184/.git/index

Configuration Settings

Theme

Page Width