Symfony Profiler

Query Metrics

6 Database Queries

6 Different statements

197.84 ms Query time

0 Invalid entities

11 Managed entities

Grouped Statements

Show all queries

default connection

Time▼

Count

Info

36.72 ms
(18.56%)

SELECT d0_.template_id AS template_id_0, d0_.template_name AS template_name_1, d0_.template_description AS template_description_2, d0_.theme_set AS theme_set_3, d0_.created_timestamp AS created_timestamp_4, d0_.updated_timestamp AS updated_timestamp_5, d0_.deleted_timestamp AS deleted_timestamp_6 FROM design_studio_templates d0_ WHERE (d0_.deleted_timestamp IS NULL OR d0_.deleted_timestamp > ?) ORDER BY d0_.template_name ASC

Parameters:

[
  "2026-04-11 20:05:25"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  d0_.template_id AS template_id_0,
  d0_.template_name AS template_name_1,
  d0_.template_description AS template_description_2,
  d0_.theme_set AS theme_set_3,
  d0_.created_timestamp AS created_timestamp_4,
  d0_.updated_timestamp AS updated_timestamp_5,
  d0_.deleted_timestamp AS deleted_timestamp_6
FROM
  design_studio_templates d0_
WHERE
  (
    d0_.deleted_timestamp IS NULL
    OR d0_.deleted_timestamp > ?
  )
ORDER BY
  d0_.template_name ASC

SELECT d0_.template_id AS template_id_0, d0_.template_name AS template_name_1, d0_.template_description AS template_description_2, d0_.theme_set AS theme_set_3, d0_.created_timestamp AS created_timestamp_4, d0_.updated_timestamp AS updated_timestamp_5, d0_.deleted_timestamp AS deleted_timestamp_6 FROM design_studio_templates d0_ WHERE (d0_.deleted_timestamp IS NULL OR d0_.deleted_timestamp > '2026-04-11 20:05:25') ORDER BY d0_.template_name 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\DesignStudioTemplateRepository->findAllActive (line 26)
7	App\Controller\Api\BrandWebsiteDesignsController->index (line 80)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 191)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
12	require_once (line 32)
13	require_once (line 5)

32.84 ms
(16.60%)

SELECT b0_.design_id AS design_id_0, b0_.design_name AS design_name_1, b0_.status AS status_2, b0_.published_timestamp AS published_timestamp_3, b0_.pages AS pages_4, b0_.created_timestamp AS created_timestamp_5, b0_.updated_timestamp AS updated_timestamp_6, b0_.deleted_timestamp AS deleted_timestamp_7, COALESCE(b0_.updated_timestamp, b0_.created_timestamp) AS sclr_8, b0_.space_id AS space_id_9 FROM brand_website_design b0_ WHERE b0_.space_id = ? AND ((b0_.deleted_timestamp IS NULL OR b0_.deleted_timestamp > ?)) ORDER BY sclr_8 DESC

Parameters:

[
  Symfony\Component\Uid\UuidV7 {#1015
    __toString(): "019d3471-3f9e-705b-8c83-be0450ec69ef"
  }
  "2026-04-11 20:05:25"
]

View formatted query View runnable query View query backtrace

SELECT
  b0_.design_id AS design_id_0,
  b0_.design_name AS design_name_1,
  b0_.status AS status_2,
  b0_.published_timestamp AS published_timestamp_3,
  b0_.pages AS pages_4,
  b0_.created_timestamp AS created_timestamp_5,
  b0_.updated_timestamp AS updated_timestamp_6,
  b0_.deleted_timestamp AS deleted_timestamp_7,
  COALESCE(
    b0_.updated_timestamp, b0_.created_timestamp
  ) AS sclr_8,
  b0_.space_id AS space_id_9
FROM
  brand_website_design b0_
WHERE
  b0_.space_id = ?
  AND (
    (
      b0_.deleted_timestamp IS NULL
      OR b0_.deleted_timestamp > ?
    )
  )
ORDER BY
  sclr_8 DESC

SELECT b0_.design_id AS design_id_0, b0_.design_name AS design_name_1, b0_.status AS status_2, b0_.published_timestamp AS published_timestamp_3, b0_.pages AS pages_4, b0_.created_timestamp AS created_timestamp_5, b0_.updated_timestamp AS updated_timestamp_6, b0_.deleted_timestamp AS deleted_timestamp_7, COALESCE(b0_.updated_timestamp, b0_.created_timestamp) AS sclr_8, b0_.space_id AS space_id_9 FROM brand_website_design b0_ WHERE b0_.space_id = '019d3471-3f9e-705b-8c83-be0450ec69ef' AND ((b0_.deleted_timestamp IS NULL OR b0_.deleted_timestamp > '2026-04-11 20:05:25')) ORDER BY sclr_8 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\BrandWebsiteDesignRepository->findByBrand (line 30)
7	App\Controller\Api\BrandWebsiteDesignsController->index (line 79)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 191)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
12	require_once (line 32)
13	require_once (line 5)

32.47 ms
(16.41%)

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:

[
  "019d3471-4021-792e-b4fe-0393c96c3777"
  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 = '019d3471-4021-792e-b4fe-0393c96c3777' 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\BrandWebsiteDesignsController->resolveBrandFromProxy (line 388)
6	App\Controller\Api\BrandWebsiteDesignsController->resolveAccessContext (line 357)
7	App\Controller\Api\BrandWebsiteDesignsController->index (line 74)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 191)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
12	require_once (line 32)
13	require_once (line 5)

32.18 ms
(16.27%)

SELECT s0_.space_id AS space_id_0, s0_.space_type AS space_type_1, s0_.name AS name_2, s0_.public_subdomain AS public_subdomain_3, s0_.public_slug AS public_slug_4, s0_.custom_domain AS custom_domain_5, s0_.cover_image_transform AS cover_image_transform_6, s0_.article_review_enabled AS article_review_enabled_7, s0_.article_reviewer_user_ids AS article_reviewer_user_ids_8, s0_.created_timestamp AS created_timestamp_9, s0_.deleted_timestamp AS deleted_timestamp_10, s0_.organisation_id AS organisation_id_11, s0_.parent_space_id AS parent_space_id_12, s0_.cover_file_reference_id AS cover_file_reference_id_13, s0_.mail_identity_id AS mail_identity_id_14 FROM spaces_list s0_ WHERE s0_.space_id = ? AND ((s0_.deleted_timestamp IS NULL OR s0_.deleted_timestamp > ?))

Parameters:

[
  "019d3471-3f9e-705b-8c83-be0450ec69ef"
  "2026-04-11 20:05:25"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  s0_.space_id AS space_id_0,
  s0_.space_type AS space_type_1,
  s0_.name AS name_2,
  s0_.public_subdomain AS public_subdomain_3,
  s0_.public_slug AS public_slug_4,
  s0_.custom_domain AS custom_domain_5,
  s0_.cover_image_transform AS cover_image_transform_6,
  s0_.article_review_enabled AS article_review_enabled_7,
  s0_.article_reviewer_user_ids AS article_reviewer_user_ids_8,
  s0_.created_timestamp AS created_timestamp_9,
  s0_.deleted_timestamp AS deleted_timestamp_10,
  s0_.organisation_id AS organisation_id_11,
  s0_.parent_space_id AS parent_space_id_12,
  s0_.cover_file_reference_id AS cover_file_reference_id_13,
  s0_.mail_identity_id AS mail_identity_id_14
FROM
  spaces_list s0_
WHERE
  s0_.space_id = ?
  AND (
    (
      s0_.deleted_timestamp IS NULL
      OR s0_.deleted_timestamp > ?
    )
  )

SELECT s0_.space_id AS space_id_0, s0_.space_type AS space_type_1, s0_.name AS name_2, s0_.public_subdomain AS public_subdomain_3, s0_.public_slug AS public_slug_4, s0_.custom_domain AS custom_domain_5, s0_.cover_image_transform AS cover_image_transform_6, s0_.article_review_enabled AS article_review_enabled_7, s0_.article_reviewer_user_ids AS article_reviewer_user_ids_8, s0_.created_timestamp AS created_timestamp_9, s0_.deleted_timestamp AS deleted_timestamp_10, s0_.organisation_id AS organisation_id_11, s0_.parent_space_id AS parent_space_id_12, s0_.cover_file_reference_id AS cover_file_reference_id_13, s0_.mail_identity_id AS mail_identity_id_14 FROM spaces_list s0_ WHERE s0_.space_id = '019d3471-3f9e-705b-8c83-be0450ec69ef' AND ((s0_.deleted_timestamp IS NULL OR s0_.deleted_timestamp > '2026-04-11 20:05:25'));

#	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\SpaceListRepository->findOne (line 28)
7	App\Controller\Api\BrandWebsiteDesignsController->resolveBrandFromProxy (line 397)
8	App\Controller\Api\BrandWebsiteDesignsController->resolveAccessContext (line 357)
9	App\Controller\Api\BrandWebsiteDesignsController->index (line 74)
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)

31.82 ms
(16.08%)

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:

[
  "019d3150-fddc-7640-904d-9e42560acdb9"
]

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 = '019d3150-fddc-7640-904d-9e42560acdb9' 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)

31.81 ms
(16.08%)

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_.is_cascading AS is_cascading_6, o0_.created_timestamp AS created_timestamp_7, o0_.deleted_timestamp AS deleted_timestamp_8, o0_.user_id AS user_id_9 FROM organisation_team_permission o0_ WHERE o0_.user_id = ? AND o0_.organisation_id = ? AND ((o0_.deleted_timestamp IS NULL OR o0_.deleted_timestamp > ?))

Parameters:

[
  Symfony\Component\Uid\UuidV7 {#567
    __toString(): "019d3150-fddc-7640-904d-9e42560acdb9"
  }
  Symfony\Component\Uid\UuidV7 {#898
    __toString(): "019d3151-3668-79ee-8c3d-07e8d3bf0334"
  }
  "2026-04-11 20:05:25"
]

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_.is_cascading AS is_cascading_6,
  o0_.created_timestamp AS created_timestamp_7,
  o0_.deleted_timestamp AS deleted_timestamp_8,
  o0_.user_id AS user_id_9
FROM
  organisation_team_permission o0_
WHERE
  o0_.user_id = ?
  AND o0_.organisation_id = ?
  AND (
    (
      o0_.deleted_timestamp IS NULL
      OR o0_.deleted_timestamp > ?
    )
  )

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_.is_cascading AS is_cascading_6, o0_.created_timestamp AS created_timestamp_7, o0_.deleted_timestamp AS deleted_timestamp_8, o0_.user_id AS user_id_9 FROM organisation_team_permission o0_ WHERE o0_.user_id = '019d3150-fddc-7640-904d-9e42560acdb9' AND o0_.organisation_id = '019d3151-3668-79ee-8c3d-07e8d3bf0334' AND ((o0_.deleted_timestamp IS NULL OR o0_.deleted_timestamp > '2026-04-11 20:05:25'));

#	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 30)
7	App\Service\PermissionService->canAccess (line 41)
8	App\Service\PermissionService->hasPermissionLevel (line 213)
9	App\Controller\Api\BrandWebsiteDesignsController->resolveAccessContext (line 372)
10	App\Controller\Api\BrandWebsiteDesignsController->index (line 74)
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)

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\DesignStudioTemplate	4
App\Entity\UserAccountList	1
App\Entity\OrganisationResourceProxy	1
App\Entity\SpaceList	1
App\Entity\OrganisationList	1
App\Entity\OrganisationMailIdentity	1
App\Entity\OrganisationTeamPermission	1
App\Entity\BrandWebsiteDesign	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\SpaceList	No errors.
App\Entity\OrganisationList	No errors.
App\Entity\OrganisationStorageFileReference	No errors.
App\Entity\OrganisationMailIdentity	No errors.
App\Entity\OrganisationTeamPermission	No errors.
App\Entity\BrandWebsiteDesign	No errors.
App\Entity\DesignStudioTemplate	No errors.

read_only entity manager

No loaded entities.

Symfony Profiler

GET https://api.lunagate.rhvm.net/brand/019d3471-4021-792e-b4fe-0393c96c3777/website-designs

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