Symfony Profiler

Query Metrics

4 Database Queries

4 Different statements

25.41 ms Query time

0 Invalid entities

8 Managed entities

Queries

Group similar statements

#▲

Time

Info

9.99 ms

SELECT t0.id AS id_1, t0.roles AS roles_2, t0.password AS password_3, t0.email_address AS email_address_4, t0.first_name AS first_name_5, t0.middle_name AS middle_name_6, t0.last_name AS last_name_7, t0.date_created AS date_created_8, t0.date_last_seen AS date_last_seen_9, t0.deleted_at AS deleted_at_10 FROM "user" t0 WHERE t0.email_address = ? LIMIT 1

Parameters:

[
  "[email protected]"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.roles AS roles_2,
  t0.password AS password_3,
  t0.email_address AS email_address_4,
  t0.first_name AS first_name_5,
  t0.middle_name AS middle_name_6,
  t0.last_name AS last_name_7,
  t0.date_created AS date_created_8,
  t0.date_last_seen AS date_last_seen_9,
  t0.deleted_at AS deleted_at_10
FROM
  "user" t0
WHERE
  t0.email_address = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.roles AS roles_2, t0.password AS password_3, t0.email_address AS email_address_4, t0.first_name AS first_name_5, t0.middle_name AS middle_name_6, t0.last_name AS last_name_7, t0.date_created AS date_created_8, t0.date_last_seen AS date_last_seen_9, t0.deleted_at AS deleted_at_10 FROM "user" t0 WHERE t0.email_address = '[email protected]' LIMIT 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 740)
2	Doctrine\ORM\EntityRepository->findOneBy (line 125)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 81)
4	Symfony\Bridge\Doctrine\Security\User\EntityUserProvider->loadUserByIdentifier (line 54)
5	Symfony\Component\Security\Http\Authenticator\Passport\Badge\UserBadge->getUser (line 101)
6	Symfony\Component\Security\Http\Authenticator\Passport\Passport->getUser (line 56)
7	Symfony\Component\Security\Http\EventListener\UserCheckerListener->preCheckCredentials (line 40)
8	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
9	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
10	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
11	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
12	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticator (line 189)
13	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticators (line 167)
14	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->authenticateRequest (line 149)
15	Symfony\Component\Security\Http\Firewall\AuthenticatorManagerListener->authenticate (line 38)
16	Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticatorManagerListener->authenticate (line 58)
17	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 46)
18	Symfony\Component\Security\Http\Firewall\AbstractListener->__invoke (line 26)
19	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 91)
20	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 92)
21	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
22	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
23	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
24	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
25	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
26	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
27	Symfony\Component\HttpKernel\Kernel->handle (line 182)
28	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
29	require_once (line 29)
30	require_once (line 5)

8.41 ms

SELECT count(DISTINCT e0_.id) AS sclr_0 FROM event e0_ INNER JOIN calendar c1_ ON e0_.calendar_id = c1_.id INNER JOIN calendar_permission c2_ ON c1_.id = c2_.calendar_id WHERE e0_.id IN (SELECT e3_.id FROM event e3_ INNER JOIN calendar c4_ ON e3_.calendar_id = c4_.id INNER JOIN calendar_permission c5_ ON c4_.id = c5_.calendar_id WHERE e3_.deleted_at IS NULL AND c5_.user_account_id = ? AND e3_.calendar_id IN (?, ?) AND e3_.start <= ? AND e3_.start >= ?)

Parameters:

[
  Symfony\Component\Uid\UuidV7 {#747
    __toString(): "01998c99-2cb4-7b87-b8d3-2a9876aa204d"
  }
  "01998d79-00bc-7af9-95a1-b663fba93cdf"
  "01998d28-20c1-7dc4-9e57-2192283c2475"
  "2025-09-30 23:59:59+0000"
  "2025-09-01 00:00:00+0000"
]

View formatted query View runnable query View query backtrace

SELECT
  count(DISTINCT e0_.id) AS sclr_0
FROM
  event e0_
  INNER JOIN calendar c1_ ON e0_.calendar_id = c1_.id
  INNER JOIN calendar_permission c2_ ON c1_.id = c2_.calendar_id
WHERE
  e0_.id IN (
    SELECT
      e3_.id
    FROM
      event e3_
      INNER JOIN calendar c4_ ON e3_.calendar_id = c4_.id
      INNER JOIN calendar_permission c5_ ON c4_.id = c5_.calendar_id
    WHERE
      e3_.deleted_at IS NULL
      AND c5_.user_account_id = ?
      AND e3_.calendar_id IN (?, ?)
      AND e3_.start <= ?
      AND e3_.start >= ?
  )

SELECT count(DISTINCT e0_.id) AS sclr_0 FROM event e0_ INNER JOIN calendar c1_ ON e0_.calendar_id = c1_.id INNER JOIN calendar_permission c2_ ON c1_.id = c2_.calendar_id WHERE e0_.id IN (SELECT e3_.id FROM event e3_ INNER JOIN calendar c4_ ON e3_.calendar_id = c4_.id INNER JOIN calendar_permission c5_ ON c4_.id = c5_.calendar_id WHERE e3_.deleted_at IS NULL AND c5_.user_account_id = '01998c99-2cb4-7b87-b8d3-2a9876aa204d' AND e3_.calendar_id IN ('01998d79-00bc-7af9-95a1-b663fba93cdf', '01998d28-20c1-7dc4-9e57-2192283c2475') AND e3_.start <= '2025-09-30 23:59:59+0000' AND e3_.start >= '2025-09-01 00:00:00+0000');

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 935)
4	Doctrine\ORM\AbstractQuery->execute (line 891)
5	Doctrine\ORM\AbstractQuery->getScalarResult (line 725)
6	Doctrine\ORM\Tools\Pagination\Paginator->count (line 96)
7	ApiPlatform\Doctrine\Orm\Paginator->getTotalItems (line 49)
8	ApiPlatform\Hydra\Serializer\CollectionNormalizer->getPaginationData (line 64)
9	ApiPlatform\Serializer\AbstractCollectionNormalizer->normalize (line 87)
10	ApiPlatform\Hydra\Serializer\PartialCollectionViewNormalizer->normalize (line 55)
11	ApiPlatform\Hydra\Serializer\CollectionFiltersNormalizer->normalize (line 80)
12	Symfony\Component\Serializer\Debug\TraceableNormalizer->normalize (line 50)
13	Symfony\Component\Serializer\Serializer->normalize (line 152)
14	Symfony\Component\Serializer\Serializer->serialize (line 131)
15	Symfony\Component\Serializer\Debug\TraceableSerializer->serialize (line 44)
16	ApiPlatform\State\Processor\SerializeProcessor->process (line 85)
17	ApiPlatform\State\Processor\WriteProcessor->process (line 54)
18	ApiPlatform\Symfony\Controller\MainController->__invoke (line 123)
19	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
20	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
21	Symfony\Component\HttpKernel\Kernel->handle (line 182)
22	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
23	require_once (line 29)
24	require_once (line 5)

3.23 ms

SELECT DISTINCT e0_.id AS id_0, e0_.id AS id_1 FROM event e0_ INNER JOIN calendar c1_ ON e0_.calendar_id = c1_.id INNER JOIN calendar_permission c2_ ON c1_.id = c2_.calendar_id WHERE e0_.id IN (SELECT e3_.id FROM event e3_ INNER JOIN calendar c4_ ON e3_.calendar_id = c4_.id INNER JOIN calendar_permission c5_ ON c4_.id = c5_.calendar_id WHERE e3_.deleted_at IS NULL AND c5_.user_account_id = ? AND e3_.calendar_id IN (?, ?) AND e3_.start <= ? AND e3_.start >= ?) ORDER BY e0_.id ASC LIMIT 30

Parameters:

[
  Symfony\Component\Uid\UuidV7 {#747
    __toString(): "01998c99-2cb4-7b87-b8d3-2a9876aa204d"
  }
  "01998d79-00bc-7af9-95a1-b663fba93cdf"
  "01998d28-20c1-7dc4-9e57-2192283c2475"
  "2025-09-30 23:59:59+0000"
  "2025-09-01 00:00:00+0000"
]

View formatted query View runnable query View query backtrace

SELECT
  DISTINCT e0_.id AS id_0,
  e0_.id AS id_1
FROM
  event e0_
  INNER JOIN calendar c1_ ON e0_.calendar_id = c1_.id
  INNER JOIN calendar_permission c2_ ON c1_.id = c2_.calendar_id
WHERE
  e0_.id IN (
    SELECT
      e3_.id
    FROM
      event e3_
      INNER JOIN calendar c4_ ON e3_.calendar_id = c4_.id
      INNER JOIN calendar_permission c5_ ON c4_.id = c5_.calendar_id
    WHERE
      e3_.deleted_at IS NULL
      AND c5_.user_account_id = ?
      AND e3_.calendar_id IN (?, ?)
      AND e3_.start <= ?
      AND e3_.start >= ?
  )
ORDER BY
  e0_.id ASC
LIMIT
  30

SELECT DISTINCT e0_.id AS id_0, e0_.id AS id_1 FROM event e0_ INNER JOIN calendar c1_ ON e0_.calendar_id = c1_.id INNER JOIN calendar_permission c2_ ON c1_.id = c2_.calendar_id WHERE e0_.id IN (SELECT e3_.id FROM event e3_ INNER JOIN calendar c4_ ON e3_.calendar_id = c4_.id INNER JOIN calendar_permission c5_ ON c4_.id = c5_.calendar_id WHERE e3_.deleted_at IS NULL AND c5_.user_account_id = '01998c99-2cb4-7b87-b8d3-2a9876aa204d' AND e3_.calendar_id IN ('01998d79-00bc-7af9-95a1-b663fba93cdf', '01998d28-20c1-7dc4-9e57-2192283c2475') AND e3_.start <= '2025-09-30 23:59:59+0000' AND e3_.start >= '2025-09-01 00:00:00+0000') ORDER BY e0_.id ASC LIMIT 30;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 935)
4	Doctrine\ORM\AbstractQuery->execute (line 891)
5	Doctrine\ORM\AbstractQuery->getScalarResult (line 725)
6	Doctrine\ORM\Tools\Pagination\Paginator->getIterator (line 127)
7	ApiPlatform\Doctrine\Orm\AbstractPaginator->getIterator (line 69)
8	ApiPlatform\Hydra\Serializer\CollectionNormalizer->getItemsData (line 83)
9	ApiPlatform\Serializer\AbstractCollectionNormalizer->normalize (line 94)
10	ApiPlatform\Hydra\Serializer\PartialCollectionViewNormalizer->normalize (line 55)
11	ApiPlatform\Hydra\Serializer\CollectionFiltersNormalizer->normalize (line 80)
12	Symfony\Component\Serializer\Debug\TraceableNormalizer->normalize (line 50)
13	Symfony\Component\Serializer\Serializer->normalize (line 152)
14	Symfony\Component\Serializer\Serializer->serialize (line 131)
15	Symfony\Component\Serializer\Debug\TraceableSerializer->serialize (line 44)
16	ApiPlatform\State\Processor\SerializeProcessor->process (line 85)
17	ApiPlatform\State\Processor\WriteProcessor->process (line 54)
18	ApiPlatform\Symfony\Controller\MainController->__invoke (line 123)
19	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
20	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
21	Symfony\Component\HttpKernel\Kernel->handle (line 182)
22	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
23	require_once (line 29)
24	require_once (line 5)

3.77 ms

SELECT e0_.id AS id_0, e0_.start AS start_1, e0_.finish AS finish_2, e0_.title AS title_3, e0_.description AS description_4, e0_.location AS location_5, e0_.alarm AS alarm_6, e0_.busy_state AS busy_state_7, e0_.raw AS raw_8, e0_.raw_hash AS raw_hash_9, e0_.date_added AS date_added_10, e0_.date_modified AS date_modified_11, e0_.deleted_at AS deleted_at_12, c1_.id AS id_13, c1_.name AS name_14, c1_.colour AS colour_15, c1_.date_created AS date_created_16, c1_.date_updated AS date_updated_17, c1_.deleted_at AS deleted_at_18, e0_.calendar_id AS calendar_id_19, c1_.source_id AS source_id_20 FROM event e0_ INNER JOIN calendar c1_ ON e0_.calendar_id = c1_.id INNER JOIN calendar_permission c2_ ON c1_.id = c2_.calendar_id WHERE e0_.id IN (SELECT e3_.id FROM event e3_ INNER JOIN calendar c4_ ON e3_.calendar_id = c4_.id INNER JOIN calendar_permission c5_ ON c4_.id = c5_.calendar_id WHERE e3_.deleted_at IS NULL AND c5_.user_account_id = ? AND e3_.calendar_id IN (?, ?) AND e3_.start <= ? AND e3_.start >= ?) AND e0_.id IN (?, ?, ?, ?, ?) ORDER BY e0_.id ASC

Parameters:

[
  Symfony\Component\Uid\UuidV7 {#747
    __toString(): "01998c99-2cb4-7b87-b8d3-2a9876aa204d"
  }
  "01998d79-00bc-7af9-95a1-b663fba93cdf"
  "01998d28-20c1-7dc4-9e57-2192283c2475"
  "2025-09-30 23:59:59+0000"
  "2025-09-01 00:00:00+0000"
  "01998d66-6f81-7e8f-9732-31552b39d3c0"
  "01998d66-a662-7dc6-981d-dc7cc9928ea6"
  "01998d69-be1a-7c7f-ab8a-bfeaa377857c"
  "01998d79-38b0-7b7b-a8a9-6523bff78cd1"
  "01998d79-5db8-7ea7-a3d3-10e82e23e67f"
]

View formatted query View runnable query View query backtrace

SELECT
  e0_.id AS id_0,
  e0_.start AS start_1,
  e0_.finish AS finish_2,
  e0_.title AS title_3,
  e0_.description AS description_4,
  e0_.location AS location_5,
  e0_.alarm AS alarm_6,
  e0_.busy_state AS busy_state_7,
  e0_.raw AS raw_8,
  e0_.raw_hash AS raw_hash_9,
  e0_.date_added AS date_added_10,
  e0_.date_modified AS date_modified_11,
  e0_.deleted_at AS deleted_at_12,
  c1_.id AS id_13,
  c1_.name AS name_14,
  c1_.colour AS colour_15,
  c1_.date_created AS date_created_16,
  c1_.date_updated AS date_updated_17,
  c1_.deleted_at AS deleted_at_18,
  e0_.calendar_id AS calendar_id_19,
  c1_.source_id AS source_id_20
FROM
  event e0_
  INNER JOIN calendar c1_ ON e0_.calendar_id = c1_.id
  INNER JOIN calendar_permission c2_ ON c1_.id = c2_.calendar_id
WHERE
  e0_.id IN (
    SELECT
      e3_.id
    FROM
      event e3_
      INNER JOIN calendar c4_ ON e3_.calendar_id = c4_.id
      INNER JOIN calendar_permission c5_ ON c4_.id = c5_.calendar_id
    WHERE
      e3_.deleted_at IS NULL
      AND c5_.user_account_id = ?
      AND e3_.calendar_id IN (?, ?)
      AND e3_.start <= ?
      AND e3_.start >= ?
  )
  AND e0_.id IN (?, ?, ?, ?, ?)
ORDER BY
  e0_.id ASC

SELECT e0_.id AS id_0, e0_.start AS start_1, e0_.finish AS finish_2, e0_.title AS title_3, e0_.description AS description_4, e0_.location AS location_5, e0_.alarm AS alarm_6, e0_.busy_state AS busy_state_7, e0_.raw AS raw_8, e0_.raw_hash AS raw_hash_9, e0_.date_added AS date_added_10, e0_.date_modified AS date_modified_11, e0_.deleted_at AS deleted_at_12, c1_.id AS id_13, c1_.name AS name_14, c1_.colour AS colour_15, c1_.date_created AS date_created_16, c1_.date_updated AS date_updated_17, c1_.deleted_at AS deleted_at_18, e0_.calendar_id AS calendar_id_19, c1_.source_id AS source_id_20 FROM event e0_ INNER JOIN calendar c1_ ON e0_.calendar_id = c1_.id INNER JOIN calendar_permission c2_ ON c1_.id = c2_.calendar_id WHERE e0_.id IN (SELECT e3_.id FROM event e3_ INNER JOIN calendar c4_ ON e3_.calendar_id = c4_.id INNER JOIN calendar_permission c5_ ON c4_.id = c5_.calendar_id WHERE e3_.deleted_at IS NULL AND c5_.user_account_id = '01998c99-2cb4-7b87-b8d3-2a9876aa204d' AND e3_.calendar_id IN ('01998d79-00bc-7af9-95a1-b663fba93cdf', '01998d28-20c1-7dc4-9e57-2192283c2475') AND e3_.start <= '2025-09-30 23:59:59+0000' AND e3_.start >= '2025-09-01 00:00:00+0000') AND e0_.id IN ('01998d66-6f81-7e8f-9732-31552b39d3c0', '01998d66-a662-7dc6-981d-dc7cc9928ea6', '01998d69-be1a-7c7f-ab8a-bfeaa377857c', '01998d79-38b0-7b7b-a8a9-6523bff78cd1', '01998d79-5db8-7ea7-a3d3-10e82e23e67f') ORDER BY e0_.id 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 935)
4	Doctrine\ORM\AbstractQuery->execute (line 891)
5	Doctrine\ORM\AbstractQuery->getResult (line 689)
6	Doctrine\ORM\Tools\Pagination\Paginator->getIterator (line 145)
7	ApiPlatform\Doctrine\Orm\AbstractPaginator->getIterator (line 69)
8	ApiPlatform\Hydra\Serializer\CollectionNormalizer->getItemsData (line 83)
9	ApiPlatform\Serializer\AbstractCollectionNormalizer->normalize (line 94)
10	ApiPlatform\Hydra\Serializer\PartialCollectionViewNormalizer->normalize (line 55)
11	ApiPlatform\Hydra\Serializer\CollectionFiltersNormalizer->normalize (line 80)
12	Symfony\Component\Serializer\Debug\TraceableNormalizer->normalize (line 50)
13	Symfony\Component\Serializer\Serializer->normalize (line 152)
14	Symfony\Component\Serializer\Serializer->serialize (line 131)
15	Symfony\Component\Serializer\Debug\TraceableSerializer->serialize (line 44)
16	ApiPlatform\State\Processor\SerializeProcessor->process (line 85)
17	ApiPlatform\State\Processor\WriteProcessor->process (line 54)
18	ApiPlatform\Symfony\Controller\MainController->__invoke (line 123)
19	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
20	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
21	Symfony\Component\HttpKernel\Kernel->handle (line 182)
22	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
23	require_once (line 29)
24	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
KiloSierraCharlie\CalendarManager\Entity\Event	5
KiloSierraCharlie\CalendarManager\Entity\Calendar	2
KiloSierraCharlie\CalendarManager\Entity\User	1

Entities Mapping

Class	Mapping errors
KiloSierraCharlie\CalendarManager\Entity\User	No errors.
KiloSierraCharlie\CalendarManager\Entity\CalendarPermission	No errors.
KiloSierraCharlie\CalendarManager\Entity\Event	No errors.
KiloSierraCharlie\CalendarManager\Entity\Calendar	No errors.
KiloSierraCharlie\CalendarManager\Entity\Source	No errors.

Symfony Profiler

GET http://127.0.0.1:5000/api/events?calendar%5B0%5D=%2Fapi%2Fcalendars%2F01998d79-00bc-7af9-95a1-b663fba93cdf&calendar%5B1%5D=%2Fapi%2Fcalendars%2F01998d28-20c1-7d…

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping