Symfony Profiler

Query Metrics

7 Database Queries

7 Different statements

238.68 ms Query time

0 Invalid entities

21 Managed entities

Grouped Statements

Show all queries

default connection

Time▼

Count

Info

34.95 ms
(14.64%)

SELECT o0_.contact_id AS contact_id_0, o0_.contact_email AS contact_email_1, o0_.first_name AS first_name_2, o0_.last_name AS last_name_3, o0_.tags AS tags_4, o0_.created_timestamp AS created_timestamp_5, o0_.updated_timestamp AS updated_timestamp_6, o0_.deleted_timestamp AS deleted_timestamp_7, o1_.field_id AS field_id_8, o1_.field_value AS field_value_9, o1_.created_timestamp AS created_timestamp_10, o1_.updated_timestamp AS updated_timestamp_11, o2_.field_definition_id AS field_definition_id_12, o2_.field_name AS field_name_13, o2_.field_label AS field_label_14, o2_.field_type AS field_type_15, o2_.is_required AS is_required_16, o2_.display_order AS display_order_17, o2_.field_settings AS field_settings_18, o2_.created_timestamp AS created_timestamp_19, o2_.updated_timestamp AS updated_timestamp_20, o2_.deleted_timestamp AS deleted_timestamp_21, o0_.organisation_id AS organisation_id_22, o0_.user_id AS user_id_23, o1_.contact_id AS contact_id_24, o1_.field_definition_id AS field_definition_id_25, o2_.organisation_id AS organisation_id_26 FROM organisation_contact_list o0_ LEFT JOIN organisation_contact_custom_field o1_ ON o0_.contact_id = o1_.contact_id LEFT JOIN organisation_contact_field_definition o2_ ON o1_.field_definition_id = o2_.field_definition_id WHERE o0_.organisation_id = ? AND o0_.deleted_timestamp IS NULL ORDER BY o0_.created_timestamp DESC

Parameters:

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

View formatted query View runnable query View query backtrace

SELECT
  o0_.contact_id AS contact_id_0,
  o0_.contact_email AS contact_email_1,
  o0_.first_name AS first_name_2,
  o0_.last_name AS last_name_3,
  o0_.tags AS tags_4,
  o0_.created_timestamp AS created_timestamp_5,
  o0_.updated_timestamp AS updated_timestamp_6,
  o0_.deleted_timestamp AS deleted_timestamp_7,
  o1_.field_id AS field_id_8,
  o1_.field_value AS field_value_9,
  o1_.created_timestamp AS created_timestamp_10,
  o1_.updated_timestamp AS updated_timestamp_11,
  o2_.field_definition_id AS field_definition_id_12,
  o2_.field_name AS field_name_13,
  o2_.field_label AS field_label_14,
  o2_.field_type AS field_type_15,
  o2_.is_required AS is_required_16,
  o2_.display_order AS display_order_17,
  o2_.field_settings AS field_settings_18,
  o2_.created_timestamp AS created_timestamp_19,
  o2_.updated_timestamp AS updated_timestamp_20,
  o2_.deleted_timestamp AS deleted_timestamp_21,
  o0_.organisation_id AS organisation_id_22,
  o0_.user_id AS user_id_23,
  o1_.contact_id AS contact_id_24,
  o1_.field_definition_id AS field_definition_id_25,
  o2_.organisation_id AS organisation_id_26
FROM
  organisation_contact_list o0_
  LEFT JOIN organisation_contact_custom_field o1_ ON o0_.contact_id = o1_.contact_id
  LEFT JOIN organisation_contact_field_definition o2_ ON o1_.field_definition_id = o2_.field_definition_id
WHERE
  o0_.organisation_id = ?
  AND o0_.deleted_timestamp IS NULL
ORDER BY
  o0_.created_timestamp DESC

SELECT o0_.contact_id AS contact_id_0, o0_.contact_email AS contact_email_1, o0_.first_name AS first_name_2, o0_.last_name AS last_name_3, o0_.tags AS tags_4, o0_.created_timestamp AS created_timestamp_5, o0_.updated_timestamp AS updated_timestamp_6, o0_.deleted_timestamp AS deleted_timestamp_7, o1_.field_id AS field_id_8, o1_.field_value AS field_value_9, o1_.created_timestamp AS created_timestamp_10, o1_.updated_timestamp AS updated_timestamp_11, o2_.field_definition_id AS field_definition_id_12, o2_.field_name AS field_name_13, o2_.field_label AS field_label_14, o2_.field_type AS field_type_15, o2_.is_required AS is_required_16, o2_.display_order AS display_order_17, o2_.field_settings AS field_settings_18, o2_.created_timestamp AS created_timestamp_19, o2_.updated_timestamp AS updated_timestamp_20, o2_.deleted_timestamp AS deleted_timestamp_21, o0_.organisation_id AS organisation_id_22, o0_.user_id AS user_id_23, o1_.contact_id AS contact_id_24, o1_.field_definition_id AS field_definition_id_25, o2_.organisation_id AS organisation_id_26 FROM organisation_contact_list o0_ LEFT JOIN organisation_contact_custom_field o1_ ON o0_.contact_id = o1_.contact_id LEFT JOIN organisation_contact_field_definition o2_ ON o1_.field_definition_id = o2_.field_definition_id WHERE o0_.organisation_id = '019c059e-aa09-7377-bafe-e1ddd5d20c36' AND o0_.deleted_timestamp IS NULL ORDER BY o0_.created_timestamp DESC;

#	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\OrganisationContactListRepository->findActiveByUserWithCustomFields (line 98)
7	App\Service\OrganisationContactListQueryService->resolveMatches (line 78)
8	App\Controller\Api\OrganisationContactListController->resolveContactsForList (line 533)
9	App\Controller\Api\OrganisationContactListController->show (line 271)
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)

34.32 ms
(14.38%)

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 {#1023
    __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\OrganisationContactListQueryService->buildFieldMap (line 117)
8	App\Service\OrganisationContactListQueryService->resolveMatches (line 75)
9	App\Controller\Api\OrganisationContactListController->resolveContactsForList (line 533)
10	App\Controller\Api\OrganisationContactListController->show (line 271)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
13	Symfony\Component\HttpKernel\Kernel->handle (line 191)
14	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
15	require_once (line 32)
16	require_once (line 5)

34.30 ms
(14.37%)

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 {#1023
    __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\OrganisationContactListController->show (line 253)
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)

33.95 ms
(14.22%)

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\OrganisationContactListController->resolveOrganisationFromProxy (line 539)
6	App\Controller\Api\OrganisationContactListController->show (line 243)
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)

33.86 ms
(14.19%)

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\OrganisationContactListController->resolveOrganisationFromProxy (line 548)
8	App\Controller\Api\OrganisationContactListController->show (line 243)
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)

33.75 ms
(14.14%)

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)

33.56 ms
(14.06%)

SELECT t0.list_id AS list_id_1, t0.name AS name_2, t0.description AS description_3, t0.list_type AS list_type_4, t0.query_definition AS query_definition_5, t0.created_timestamp AS created_timestamp_6, t0.updated_timestamp AS updated_timestamp_7, t0.snapshot_timestamp AS snapshot_timestamp_8, t0.deleted_timestamp AS deleted_timestamp_9, t0.organisation_id AS organisation_id_10 FROM organisation_contact_list_definition t0 WHERE t0.list_id = ?

Parameters:

[
  "019c47ff-d440-7c95-a70a-94213d0e43d1"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.list_id AS list_id_1,
  t0.name AS name_2,
  t0.description AS description_3,
  t0.list_type AS list_type_4,
  t0.query_definition AS query_definition_5,
  t0.created_timestamp AS created_timestamp_6,
  t0.updated_timestamp AS updated_timestamp_7,
  t0.snapshot_timestamp AS snapshot_timestamp_8,
  t0.deleted_timestamp AS deleted_timestamp_9,
  t0.organisation_id AS organisation_id_10
FROM
  organisation_contact_list_definition t0
WHERE
  t0.list_id = ?

SELECT t0.list_id AS list_id_1, t0.name AS name_2, t0.description AS description_3, t0.list_type AS list_type_4, t0.query_definition AS query_definition_5, t0.created_timestamp AS created_timestamp_6, t0.updated_timestamp AS updated_timestamp_7, t0.snapshot_timestamp AS snapshot_timestamp_8, t0.deleted_timestamp AS deleted_timestamp_9, t0.organisation_id AS organisation_id_10 FROM organisation_contact_list_definition t0 WHERE t0.list_id = '019c47ff-d440-7c95-a70a-94213d0e43d1';

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
3	Doctrine\ORM\EntityManager->find (line 366)
4	Doctrine\ORM\EntityRepository->find (line 86)
5	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepository->find (line 66)
6	App\Controller\Api\OrganisationContactListController->show (line 257)
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)

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\OrganisationContactList	3
App\Entity\OrganisationContactCustomField	3
App\Entity\UserAccountList	2
App\Entity\OrganisationContactFieldOption	2
App\Entity\OrganisationResourceProxy	1
App\Entity\OrganisationList	1
App\Entity\OrganisationTeamPermission	1
App\Entity\OrganisationContactListDefinition	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\OrganisationContactListDefinition	No errors.
App\Entity\OrganisationContactListMember	No errors.
App\Entity\OrganisationContactFieldDefinition	No errors.
App\Entity\OrganisationContactFieldOption	No errors.
App\Entity\OrganisationContactList	No errors.
App\Entity\OrganisationContactCustomField	No errors.

read_only entity manager

No loaded entities.

Symfony Profiler

GET https://api.lunagate.rhvm.net/organisation/019c059e-aa37-737c-8b9a-48863296191a/database/lists/019c47ff-d440-7c95-a70a-94213d0e43d1

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