Symfony Profiler

Query Metrics

5 Database Queries

5 Different statements

164.16 ms Query time

0 Invalid entities

13 Managed entities

Grouped Statements

Show all queries

default connection

Time▼

Count

Info

33.33 ms
(20.30%)

SELECT o0_.field_definition_id AS field_definition_id_0, o0_.field_name AS field_name_1, o0_.field_label AS field_label_2, o0_.field_type AS field_type_3, o0_.is_required AS is_required_4, o0_.display_order AS display_order_5, o0_.field_settings AS field_settings_6, o0_.created_timestamp AS created_timestamp_7, o0_.updated_timestamp AS updated_timestamp_8, o0_.deleted_timestamp AS deleted_timestamp_9, o1_.option_id AS option_id_10, o1_.option_label AS option_label_11, o1_.option_value AS option_value_12, o1_.display_order AS display_order_13, o1_.is_active AS is_active_14, o1_.created_timestamp AS created_timestamp_15, o0_.organisation_id AS organisation_id_16, o1_.field_definition_id AS field_definition_id_17 FROM organisation_contact_field_definition o0_ LEFT JOIN organisation_contact_field_option o1_ ON o0_.field_definition_id = o1_.field_definition_id WHERE o0_.organisation_id = ? AND o0_.deleted_timestamp IS NULL ORDER BY o0_.display_order ASC, o0_.field_name ASC, o1_.display_order ASC

Parameters:

[
  Symfony\Component\Uid\UuidV7 {#1017
    __toString(): "019c059e-aa09-7377-bafe-e1ddd5d20c36"
  }
]

View formatted query View runnable query View query backtrace

SELECT
  o0_.field_definition_id AS field_definition_id_0,
  o0_.field_name AS field_name_1,
  o0_.field_label AS field_label_2,
  o0_.field_type AS field_type_3,
  o0_.is_required AS is_required_4,
  o0_.display_order AS display_order_5,
  o0_.field_settings AS field_settings_6,
  o0_.created_timestamp AS created_timestamp_7,
  o0_.updated_timestamp AS updated_timestamp_8,
  o0_.deleted_timestamp AS deleted_timestamp_9,
  o1_.option_id AS option_id_10,
  o1_.option_label AS option_label_11,
  o1_.option_value AS option_value_12,
  o1_.display_order AS display_order_13,
  o1_.is_active AS is_active_14,
  o1_.created_timestamp AS created_timestamp_15,
  o0_.organisation_id AS organisation_id_16,
  o1_.field_definition_id AS field_definition_id_17
FROM
  organisation_contact_field_definition o0_
  LEFT JOIN organisation_contact_field_option o1_ ON o0_.field_definition_id = o1_.field_definition_id
WHERE
  o0_.organisation_id = ?
  AND o0_.deleted_timestamp IS NULL
ORDER BY
  o0_.display_order ASC,
  o0_.field_name ASC,
  o1_.display_order ASC

SELECT o0_.field_definition_id AS field_definition_id_0, o0_.field_name AS field_name_1, o0_.field_label AS field_label_2, o0_.field_type AS field_type_3, o0_.is_required AS is_required_4, o0_.display_order AS display_order_5, o0_.field_settings AS field_settings_6, o0_.created_timestamp AS created_timestamp_7, o0_.updated_timestamp AS updated_timestamp_8, o0_.deleted_timestamp AS deleted_timestamp_9, o1_.option_id AS option_id_10, o1_.option_label AS option_label_11, o1_.option_value AS option_value_12, o1_.display_order AS display_order_13, o1_.is_active AS is_active_14, o1_.created_timestamp AS created_timestamp_15, o0_.organisation_id AS organisation_id_16, o1_.field_definition_id AS field_definition_id_17 FROM organisation_contact_field_definition o0_ LEFT JOIN organisation_contact_field_option o1_ ON o0_.field_definition_id = o1_.field_definition_id WHERE o0_.organisation_id = '019c059e-aa09-7377-bafe-e1ddd5d20c36' AND o0_.deleted_timestamp IS NULL ORDER BY o0_.display_order ASC, o0_.field_name ASC, o1_.display_order ASC;

#	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\OrganisationContactFieldDefinitionRepository->findActiveByOrganisationWithOptions (line 101)
7	App\Service\ContactImportProcessor->buildCustomFieldMap (line 350)
8	App\Service\ContactImportProcessor->processImport (line 58)
9	App\Controller\Api\OrganisationContactController->importComplete (line 400)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
12	Symfony\Component\HttpKernel\Kernel->handle (line 191)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
14	require_once (line 32)
15	require_once (line 5)

33.12 ms
(20.18%)

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 {#1017
    __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->importComplete (line 326)
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)

32.84 ms
(20.00%)

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)

32.62 ms
(19.87%)

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->importComplete (line 316)
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)

32.25 ms
(19.65%)

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->importComplete (line 316)
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\OrganisationContactFieldDefinition	7
App\Entity\OrganisationContactFieldOption	2
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.
App\Entity\OrganisationContactFieldDefinition	No errors.
App\Entity\OrganisationContactFieldOption	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/complete

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

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