Symfony Profiler

Query Metrics

4 Database Queries

4 Different statements

26.02 ms Query time

0 Invalid entities

1 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

12.63 ms
(48.54%)

"COMMIT"

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

"COMMIT"

"COMMIT";

#	File/Call
1	Doctrine\ORM\UnitOfWork->commit (line 434)
2	Doctrine\ORM\EntityManager->flush (line 268)
3	App\Controller\App\Api\V1\BookingWebhookController->__invoke (line 220)
4	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
5	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
6	Symfony\Component\HttpKernel\Kernel->handle (line 191)
7	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
8	require_once (line 32)
9	require_once (line 5)

9.90 ms
(38.06%)

SELECT b0_.id AS id_0, b0_.event_id AS event_id_1, b0_.tenant_id AS tenant_id_2, b0_.event_type AS event_type_3, b0_.payload AS payload_4, b0_.received_at AS received_at_5, b0_.processed_at AS processed_at_6 FROM booking_webhook_events b0_ WHERE b0_.event_id = ?

Parameters:

[
  "0131ea59-c302-40c3-b9eb-5e86c9e78ee2"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  b0_.id AS id_0,
  b0_.event_id AS event_id_1,
  b0_.tenant_id AS tenant_id_2,
  b0_.event_type AS event_type_3,
  b0_.payload AS payload_4,
  b0_.received_at AS received_at_5,
  b0_.processed_at AS processed_at_6
FROM
  booking_webhook_events b0_
WHERE
  b0_.event_id = ?

SELECT b0_.id AS id_0, b0_.event_id AS event_id_1, b0_.tenant_id AS tenant_id_2, b0_.event_type AS event_type_3, b0_.payload AS payload_4, b0_.received_at AS received_at_5, b0_.processed_at AS processed_at_6 FROM booking_webhook_events b0_ WHERE b0_.event_id = '0131ea59-c302-40c3-b9eb-5e86c9e78ee2';

#	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\BookingWebhookEventRepository->findOneByEventId (line 28)
7	App\Controller\App\Api\V1\BookingWebhookController->__invoke (line 203)
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)

2.09 ms
(8.03%)

INSERT INTO booking_webhook_events (id, event_id, tenant_id, event_type, payload, received_at, processed_at) VALUES (?, ?, ?, ?, ?, ?, ?)

Parameters:

[
  "1f1a26f5-d53e-6442-9ab5-a173b973ab3d"
  "0131ea59-c302-40c3-b9eb-5e86c9e78ee2"
  "1f1a14e9-d487-6a62-8742-edb1223f5cbe"
  "HOLD_CREATED"
  "{"end_utc":"2026-08-28T10:30:00Z","hold_id":"bc66a7a7-01d1-4d73-aa24-469ff1086c86","event_id":"0131ea59-c302-40c3-b9eb-5e86c9e78ee2","staff_id":"1f1a15bf-999f-6c3e-bd39-ff759fe54729","timezone":"Europe\/Paris","start_utc":"2026-08-28T10:00:00Z","tenant_id":"1f1a14e9-d487-6a62-8742-edb1223f5cbe","event_type":"HOLD_CREATED","service_id":"1f1a15ba-d67c-6b7a-b60b-6b90472d9b72","hold_status":"ACTIVE","location_id":"1f1a1507-5f68-6c5e-ba59-27433644fad4","location_slug":"diloy-s-andernos","expires_at_utc":"2026-08-27T23:40:31Z","occurred_at_utc":"2026-08-27T23:30:31Z"}"
  "2026-08-27 23:31:01+0000"
  null
]

View formatted query View runnable query Explain query View query backtrace

INSERT INTO booking_webhook_events (
  id, event_id, tenant_id, event_type,
  payload, received_at, processed_at
)
VALUES
  (?, ?, ?, ?, ?, ?, ?)

INSERT INTO booking_webhook_events (id, event_id, tenant_id, event_type, payload, received_at, processed_at) VALUES ('1f1a26f5-d53e-6442-9ab5-a173b973ab3d', '0131ea59-c302-40c3-b9eb-5e86c9e78ee2', '1f1a14e9-d487-6a62-8742-edb1223f5cbe', 'HOLD_CREATED', '{\"end_utc\":\"2026-08-28T10:30:00Z\",\"hold_id\":\"bc66a7a7-01d1-4d73-aa24-469ff1086c86\",\"event_id\":\"0131ea59-c302-40c3-b9eb-5e86c9e78ee2\",\"staff_id\":\"1f1a15bf-999f-6c3e-bd39-ff759fe54729\",\"timezone\":\"Europe\\/Paris\",\"start_utc\":\"2026-08-28T10:00:00Z\",\"tenant_id\":\"1f1a14e9-d487-6a62-8742-edb1223f5cbe\",\"event_type\":\"HOLD_CREATED\",\"service_id\":\"1f1a15ba-d67c-6b7a-b60b-6b90472d9b72\",\"hold_status\":\"ACTIVE\",\"location_id\":\"1f1a1507-5f68-6c5e-ba59-27433644fad4\",\"location_slug\":\"diloy-s-andernos\",\"expires_at_utc\":\"2026-08-27T23:40:31Z\",\"occurred_at_utc\":\"2026-08-27T23:30:31Z\"}', '2026-08-27 23:31:01+0000', NULL);

#	File/Call
1	Doctrine\DBAL\Statement->executeStatement (line 133)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->executeInserts (line 253)
3	Doctrine\ORM\UnitOfWork->executeInserts (line 1061)
4	Doctrine\ORM\UnitOfWork->commit (line 404)
5	Doctrine\ORM\EntityManager->flush (line 268)
6	App\Controller\App\Api\V1\BookingWebhookController->__invoke (line 220)
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)

1.40 ms
(5.36%)

"START TRANSACTION"

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

"START TRANSACTION"

"START TRANSACTION";

#	File/Call
1	Doctrine\ORM\UnitOfWork->commit (line 383)
2	Doctrine\ORM\EntityManager->flush (line 268)
3	App\Controller\App\Api\V1\BookingWebhookController->__invoke (line 220)
4	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
5	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
6	Symfony\Component\HttpKernel\Kernel->handle (line 191)
7	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
8	require_once (line 32)
9	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
App\Entity\BookingWebhookEvent	1

Entities Mapping

Class	Mapping errors
App\Entity\BookingWebhookEvent	No errors.

Symfony Profiler

POST https://demo-api.ooklo.com/api/v1/webhook/booking

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping