Symfony Profiler

Query Metrics

4 Database Queries

4 Different statements

137.47 ms Query time

0 Invalid entities

4 Managed entities

Queries

Group similar statements

default connection

#▲

Time

Info

34.42 ms

SELECT t0.user_id AS user_id_1, t0.password AS password_2, t0.roles AS roles_3, t0.first_name AS first_name_4, t0.last_name AS last_name_5, t0.is_banned AS is_banned_6, t0.created_timestamp AS created_timestamp_7, t0.deleted_timestamp AS deleted_timestamp_8, t0.must_login_after AS must_login_after_9 FROM user_account_list t0 WHERE t0.user_id = ? LIMIT 1

Parameters:

[
  "019c059d-34d0-7844-b22d-6f9733cdff43"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.user_id AS user_id_1,
  t0.password AS password_2,
  t0.roles AS roles_3,
  t0.first_name AS first_name_4,
  t0.last_name AS last_name_5,
  t0.is_banned AS is_banned_6,
  t0.created_timestamp AS created_timestamp_7,
  t0.deleted_timestamp AS deleted_timestamp_8,
  t0.must_login_after AS must_login_after_9
FROM
  user_account_list t0
WHERE
  t0.user_id = ?
LIMIT
  1

SELECT t0.user_id AS user_id_1, t0.password AS password_2, t0.roles AS roles_3, t0.first_name AS first_name_4, t0.last_name AS last_name_5, t0.is_banned AS is_banned_6, t0.created_timestamp AS created_timestamp_7, t0.deleted_timestamp AS deleted_timestamp_8, t0.must_login_after AS must_login_after_9 FROM user_account_list t0 WHERE t0.user_id = '019c059d-34d0-7844-b22d-6f9733cdff43' 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\ServiceEntityRepository->findOneBy (line 86)
4	Symfony\Bridge\Doctrine\Security\User\EntityUserProvider->loadUserByIdentifier (line 55)
5	Lexik\Bundle\JWTAuthenticationBundle\Security\Authenticator\JWTAuthenticator->loadUser (line 208)
6	Lexik\Bundle\JWTAuthenticationBundle\Security\Authenticator\JWTAuthenticator->{closure:Lexik\Bundle\JWTAuthenticationBundle\Security\Authenticator\JWTAuthenticator::authenticate():105} (line 105)
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 126)
14	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticator (line 176)
15	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticators (line 154)
16	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->authenticateRequest (line 136)
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 52)
20	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 88)
21	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 86)
22	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
23	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
24	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
25	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
26	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
27	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
28	Symfony\Component\HttpKernel\Kernel->handle (line 191)
29	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
30	require_once (line 32)
31	require_once (line 5)

34.29 ms

SELECT t0.proxy_id AS proxy_id_1, t0.organisation_id AS organisation_id_2, t0.resource_type AS resource_type_3, t0.resource_id AS resource_id_4, t0.is_active AS is_active_5, t0.created_timestamp AS created_timestamp_6, t0.deleted_timestamp AS deleted_timestamp_7 FROM organisation_resource_proxy t0 WHERE t0.proxy_id = ? AND t0.is_active = ? LIMIT 1

Parameters:

[
  "019c059e-aa37-737c-8b9a-48863296191a"
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.proxy_id AS proxy_id_1,
  t0.organisation_id AS organisation_id_2,
  t0.resource_type AS resource_type_3,
  t0.resource_id AS resource_id_4,
  t0.is_active AS is_active_5,
  t0.created_timestamp AS created_timestamp_6,
  t0.deleted_timestamp AS deleted_timestamp_7
FROM
  organisation_resource_proxy t0
WHERE
  t0.proxy_id = ?
  AND t0.is_active = ?
LIMIT
  1

SELECT t0.proxy_id AS proxy_id_1, t0.organisation_id AS organisation_id_2, t0.resource_type AS resource_type_3, t0.resource_id AS resource_id_4, t0.is_active AS is_active_5, t0.created_timestamp AS created_timestamp_6, t0.deleted_timestamp AS deleted_timestamp_7 FROM organisation_resource_proxy t0 WHERE t0.proxy_id = '019c059e-aa37-737c-8b9a-48863296191a' AND t0.is_active = 1 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\ServiceEntityRepository->findOneBy (line 86)
4	App\Service\ProxyResolver->resolve (line 29)
5	App\Controller\Api\OrganisationContactController->resolveOrganisationFromProxy (line 444)
6	App\Controller\Api\OrganisationContactController->importInitiate (line 225)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
9	Symfony\Component\HttpKernel\Kernel->handle (line 191)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
11	require_once (line 32)
12	require_once (line 5)

34.16 ms

SELECT o0_.organisation_id AS organisation_id_0, o0_.name AS name_1, o0_.plan_code AS plan_code_2, o0_.plan_selected_timestamp AS plan_selected_timestamp_3, o0_.created_timestamp AS created_timestamp_4, o0_.deleted_timestamp AS deleted_timestamp_5, o0_.deletion_scheduled_timestamp AS deletion_scheduled_timestamp_6 FROM organisation_list o0_ WHERE o0_.organisation_id = ? AND o0_.deleted_timestamp IS NULL

Parameters:

[
  "019c059e-aa09-7377-bafe-e1ddd5d20c36"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  o0_.organisation_id AS organisation_id_0,
  o0_.name AS name_1,
  o0_.plan_code AS plan_code_2,
  o0_.plan_selected_timestamp AS plan_selected_timestamp_3,
  o0_.created_timestamp AS created_timestamp_4,
  o0_.deleted_timestamp AS deleted_timestamp_5,
  o0_.deletion_scheduled_timestamp AS deletion_scheduled_timestamp_6
FROM
  organisation_list o0_
WHERE
  o0_.organisation_id = ?
  AND o0_.deleted_timestamp IS NULL

SELECT o0_.organisation_id AS organisation_id_0, o0_.name AS name_1, o0_.plan_code AS plan_code_2, o0_.plan_selected_timestamp AS plan_selected_timestamp_3, o0_.created_timestamp AS created_timestamp_4, o0_.deleted_timestamp AS deleted_timestamp_5, o0_.deletion_scheduled_timestamp AS deletion_scheduled_timestamp_6 FROM organisation_list o0_ WHERE o0_.organisation_id = '019c059e-aa09-7377-bafe-e1ddd5d20c36' AND o0_.deleted_timestamp IS NULL;

#	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\OrganisationListRepository->findOne (line 26)
7	App\Controller\Api\OrganisationContactController->resolveOrganisationFromProxy (line 453)
8	App\Controller\Api\OrganisationContactController->importInitiate (line 225)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
11	Symfony\Component\HttpKernel\Kernel->handle (line 191)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
13	require_once (line 32)
14	require_once (line 5)

34.60 ms

SELECT o0_.id AS id_0, o0_.contact_id AS contact_id_1, o0_.organisation_id AS organisation_id_2, o0_.scope_type AS scope_type_3, o0_.scope_id AS scope_id_4, o0_.permission_level AS permission_level_5, o0_.created_timestamp AS created_timestamp_6, o0_.deleted_timestamp AS deleted_timestamp_7, o0_.user_id AS user_id_8 FROM organisation_team_permission o0_ WHERE o0_.user_id = ? AND o0_.organisation_id = ? AND o0_.deleted_timestamp IS NULL

Parameters:

[
  Symfony\Component\Uid\UuidV7 {#559
    __toString(): "019c059d-34d0-7844-b22d-6f9733cdff43"
  }
  Symfony\Component\Uid\UuidV7 {#1018
    __toString(): "019c059e-aa09-7377-bafe-e1ddd5d20c36"
  }
]

View formatted query View runnable query View query backtrace

SELECT
  o0_.id AS id_0,
  o0_.contact_id AS contact_id_1,
  o0_.organisation_id AS organisation_id_2,
  o0_.scope_type AS scope_type_3,
  o0_.scope_id AS scope_id_4,
  o0_.permission_level AS permission_level_5,
  o0_.created_timestamp AS created_timestamp_6,
  o0_.deleted_timestamp AS deleted_timestamp_7,
  o0_.user_id AS user_id_8
FROM
  organisation_team_permission o0_
WHERE
  o0_.user_id = ?
  AND o0_.organisation_id = ?
  AND o0_.deleted_timestamp IS NULL

SELECT o0_.id AS id_0, o0_.contact_id AS contact_id_1, o0_.organisation_id AS organisation_id_2, o0_.scope_type AS scope_type_3, o0_.scope_id AS scope_id_4, o0_.permission_level AS permission_level_5, o0_.created_timestamp AS created_timestamp_6, o0_.deleted_timestamp AS deleted_timestamp_7, o0_.user_id AS user_id_8 FROM organisation_team_permission o0_ WHERE o0_.user_id = '019c059d-34d0-7844-b22d-6f9733cdff43' AND o0_.organisation_id = '019c059e-aa09-7377-bafe-e1ddd5d20c36' AND o0_.deleted_timestamp IS NULL;

#	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->getResult (line 688)
6	App\Repository\OrganisationTeamPermissionRepository->findActivePermissionsForUser (line 29)
7	App\Service\PermissionService->hasOrganisationAccess (line 140)
8	App\Controller\Api\OrganisationContactController->importInitiate (line 235)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
11	Symfony\Component\HttpKernel\Kernel->handle (line 191)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
13	require_once (line 32)
14	require_once (line 5)

Database Connections

Name	Service
default	doctrine.dbal.default_connection
read_only	doctrine.dbal.read_only_connection

Entity Managers

Name	Service
default	doctrine.orm.default_entity_manager
read_only	doctrine.orm.read_only_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

default entity manager

Class	Amount of managed objects
App\Entity\UserAccountList	1
App\Entity\OrganisationResourceProxy	1
App\Entity\OrganisationList	1
App\Entity\OrganisationTeamPermission	1

read_only entity manager

Class	Amount of managed objects

Entities Mapping

default entity manager

Class	Mapping errors
App\Entity\UserAccountList	No errors.
App\Entity\UserAccountEmail	No errors.
App\Entity\OrganisationResourceProxy	No errors.
App\Entity\OrganisationList	No errors.
App\Entity\OrganisationTeamPermission	No errors.

read_only entity manager

No loaded entities.

Symfony Profiler

POST https://api.lunagate.rhvm.net/organisation/019c059e-aa37-737c-8b9a-48863296191a/database/contacts/import/initiate

Configuration Settings

Theme

Page Width

Query Metrics

Queries

default connection

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

read_only entity manager

Entities Mapping

default entity manager

read_only entity manager