Symfony Profiler

Query Metrics

3 Database Queries

3 Different statements

2.22 ms Query time

0 Invalid entities

0 Managed entities

Queries

Group similar statements

rw connection

#▲

Time

Info

0.44 ms

"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 382)
2	Doctrine\ORM\EntityManager->flush (line 268)
3	App\Controller\ThreeCXCDRController->__invoke (line 72)
4	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
5	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
6	Symfony\Component\HttpKernel\Kernel->handle (line 193)
7	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
8	require_once (line 32)
9	require_once (line 5)

1.10 ms

INSERT INTO 3cx_cdr_ingest_events (received_at, processed_at, status, source_id, call_id, idempotency_key, raw_record, parsed_json, source_ip, error_message) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

Parameters:

[
  "2026-06-05 22:35:48"
  null
  "received"
  "00000000-01dc-f4fa-bcae-c1f900000450"
  "Call 00000000-01dc-f4fa-bcb7-8c7800000a8c"
  "add410edcb3066f05a6462c21d5f61264c2da20be724173a276c411fa1f64a28"
  "{"raw":"Call 00000000-01dc-f4fa-bcb7-8c7800000a8c,00000000-01dc-f4fa-bcae-c1f900000450,00:00:03,2026/06/05 14:51:05,2026/06/05 14:51:06,2026/06/05 14:51:09,src_participant_terminated,9283772818,9001,10001,9001,7605980074,,Ext.9001,9001,,,,,Chain: 9283772818;Ext.9001;,9283772818","call_id":"Call 00000000-01dc-f4fa-bcb7-8c7800000a8c","source_id":"00000000-01dc-f4fa-bcae-c1f900000450","caller_id":"9283772818","callee_id":"9001","callee_name":"Ext.9001","direction":"inbound","start_time":"2026/06/05 14:51:06","end_time":"2026/06/05 14:51:09","duration_seconds":3,"status":"src_participant_terminated","parsed_fields":{"call_id":"Call 00000000-01dc-f4fa-bcb7-8c7800000a8c","source_id":"00000000-01dc-f4fa-bcae-c1f900000450","duration":"00:00:03","ring_start_time":"2026/06/05 14:51:05","start_time":"2026/06/05 14:51:06","end_time":"2026/06/05 14:51:09","status":"src_participant_terminated","caller_id":"9283772818","caller_extension":"9001","dialed_number":"10001","callee_id":"9001","callee_number":"7605980074","field_13":"","callee_name":"Ext.9001","extension":"9001","field_16":"","field_17":"","field_18":"","field_19":"","route_chain":"Chain: 9283772818;Ext.9001;","caller_number":"9283772818"},"source_ip":"172.16.17.4","received_at":"2026-06-05T14:50:55.510Z"}"
  "{"raw":"Call 00000000-01dc-f4fa-bcb7-8c7800000a8c,00000000-01dc-f4fa-bcae-c1f900000450,00:00:03,2026\/06\/05 14:51:05,2026\/06\/05 14:51:06,2026\/06\/05 14:51:09,src_participant_terminated,9283772818,9001,10001,9001,7605980074,,Ext.9001,9001,,,,,Chain: 9283772818;Ext.9001;,9283772818","call_id":"Call 00000000-01dc-f4fa-bcb7-8c7800000a8c","source_id":"00000000-01dc-f4fa-bcae-c1f900000450","caller_id":"9283772818","callee_id":"9001","callee_name":"Ext.9001","direction":"inbound","start_time":"2026\/06\/05 14:51:06","end_time":"2026\/06\/05 14:51:09","duration_seconds":3,"status":"src_participant_terminated","parsed_fields":{"call_id":"Call 00000000-01dc-f4fa-bcb7-8c7800000a8c","source_id":"00000000-01dc-f4fa-bcae-c1f900000450","duration":"00:00:03","ring_start_time":"2026\/06\/05 14:51:05","start_time":"2026\/06\/05 14:51:06","end_time":"2026\/06\/05 14:51:09","status":"src_participant_terminated","caller_id":"9283772818","caller_extension":"9001","dialed_number":"10001","callee_id":"9001","callee_number":"7605980074","field_13":"","callee_name":"Ext.9001","extension":"9001","field_16":"","field_17":"","field_18":"","field_19":"","route_chain":"Chain: 9283772818;Ext.9001;","caller_number":"9283772818"},"source_ip":"172.16.17.4","received_at":"2026-06-05T14:50:55.510Z"}"
  "10.1.20.15"
  null
]

View formatted query View runnable query Explain query View query backtrace

INSERT INTO 3cx_cdr_ingest_events (
  received_at, processed_at, status,
  source_id, call_id, idempotency_key,
  raw_record, parsed_json, source_ip,
  error_message
)
VALUES
  (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

INSERT INTO 3cx_cdr_ingest_events (received_at, processed_at, status, source_id, call_id, idempotency_key, raw_record, parsed_json, source_ip, error_message) VALUES ('2026-06-05 22:35:48', NULL, 'received', '00000000-01dc-f4fa-bcae-c1f900000450', 'Call 00000000-01dc-f4fa-bcb7-8c7800000a8c', 'add410edcb3066f05a6462c21d5f61264c2da20be724173a276c411fa1f64a28', '{\"raw\":\"Call 00000000-01dc-f4fa-bcb7-8c7800000a8c,00000000-01dc-f4fa-bcae-c1f900000450,00:00:03,2026/06/05 14:51:05,2026/06/05 14:51:06,2026/06/05 14:51:09,src_participant_terminated,9283772818,9001,10001,9001,7605980074,,Ext.9001,9001,,,,,Chain: 9283772818;Ext.9001;,9283772818\",\"call_id\":\"Call 00000000-01dc-f4fa-bcb7-8c7800000a8c\",\"source_id\":\"00000000-01dc-f4fa-bcae-c1f900000450\",\"caller_id\":\"9283772818\",\"callee_id\":\"9001\",\"callee_name\":\"Ext.9001\",\"direction\":\"inbound\",\"start_time\":\"2026/06/05 14:51:06\",\"end_time\":\"2026/06/05 14:51:09\",\"duration_seconds\":3,\"status\":\"src_participant_terminated\",\"parsed_fields\":{\"call_id\":\"Call 00000000-01dc-f4fa-bcb7-8c7800000a8c\",\"source_id\":\"00000000-01dc-f4fa-bcae-c1f900000450\",\"duration\":\"00:00:03\",\"ring_start_time\":\"2026/06/05 14:51:05\",\"start_time\":\"2026/06/05 14:51:06\",\"end_time\":\"2026/06/05 14:51:09\",\"status\":\"src_participant_terminated\",\"caller_id\":\"9283772818\",\"caller_extension\":\"9001\",\"dialed_number\":\"10001\",\"callee_id\":\"9001\",\"callee_number\":\"7605980074\",\"field_13\":\"\",\"callee_name\":\"Ext.9001\",\"extension\":\"9001\",\"field_16\":\"\",\"field_17\":\"\",\"field_18\":\"\",\"field_19\":\"\",\"route_chain\":\"Chain: 9283772818;Ext.9001;\",\"caller_number\":\"9283772818\"},\"source_ip\":\"172.16.17.4\",\"received_at\":\"2026-06-05T14:50:55.510Z\"}', '{\"raw\":\"Call 00000000-01dc-f4fa-bcb7-8c7800000a8c,00000000-01dc-f4fa-bcae-c1f900000450,00:00:03,2026\\/06\\/05 14:51:05,2026\\/06\\/05 14:51:06,2026\\/06\\/05 14:51:09,src_participant_terminated,9283772818,9001,10001,9001,7605980074,,Ext.9001,9001,,,,,Chain: 9283772818;Ext.9001;,9283772818\",\"call_id\":\"Call 00000000-01dc-f4fa-bcb7-8c7800000a8c\",\"source_id\":\"00000000-01dc-f4fa-bcae-c1f900000450\",\"caller_id\":\"9283772818\",\"callee_id\":\"9001\",\"callee_name\":\"Ext.9001\",\"direction\":\"inbound\",\"start_time\":\"2026\\/06\\/05 14:51:06\",\"end_time\":\"2026\\/06\\/05 14:51:09\",\"duration_seconds\":3,\"status\":\"src_participant_terminated\",\"parsed_fields\":{\"call_id\":\"Call 00000000-01dc-f4fa-bcb7-8c7800000a8c\",\"source_id\":\"00000000-01dc-f4fa-bcae-c1f900000450\",\"duration\":\"00:00:03\",\"ring_start_time\":\"2026\\/06\\/05 14:51:05\",\"start_time\":\"2026\\/06\\/05 14:51:06\",\"end_time\":\"2026\\/06\\/05 14:51:09\",\"status\":\"src_participant_terminated\",\"caller_id\":\"9283772818\",\"caller_extension\":\"9001\",\"dialed_number\":\"10001\",\"callee_id\":\"9001\",\"callee_number\":\"7605980074\",\"field_13\":\"\",\"callee_name\":\"Ext.9001\",\"extension\":\"9001\",\"field_16\":\"\",\"field_17\":\"\",\"field_18\":\"\",\"field_19\":\"\",\"route_chain\":\"Chain: 9283772818;Ext.9001;\",\"caller_number\":\"9283772818\"},\"source_ip\":\"172.16.17.4\",\"received_at\":\"2026-06-05T14:50:55.510Z\"}', '10.1.20.15', 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 1060)
4	Doctrine\ORM\UnitOfWork->commit (line 403)
5	Doctrine\ORM\EntityManager->flush (line 268)
6	App\Controller\ThreeCXCDRController->__invoke (line 72)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
9	Symfony\Component\HttpKernel\Kernel->handle (line 193)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
11	require_once (line 32)
12	require_once (line 5)

0.68 ms

"ROLLBACK"

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

"ROLLBACK"

"ROLLBACK";

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

Database Connections

Name	Service
rw	doctrine.dbal.rw_connection
ro	doctrine.dbal.ro_connection

Entity Managers

Name	Service
_defaults	doctrine.orm._defaults_entity_manager
rw	doctrine.orm.rw_entity_manager
ro	doctrine.orm.ro_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

_defaults entity manager

Class	Amount of managed objects

rw entity manager

Class	Amount of managed objects

ro entity manager

Class	Amount of managed objects

Entities Mapping

_defaults entity manager

No loaded entities.

rw entity manager

Class	Mapping errors
App\Entity\RW\ThreeCXCDRIngestEvent	No errors.

ro entity manager

No loaded entities.

Symfony Profiler

POST https://staging.mm-4.net/webhooks/3cx-cdr

Configuration Settings

Theme

Page Width

Query Metrics

Queries

rw connection

Database Connections

Entity Managers

Second Level Cache

Managed Entities

_defaults entity manager

rw entity manager

ro entity manager

Entities Mapping

_defaults entity manager

rw entity manager

ro entity manager