Symfony Profiler

Query Metrics

9 Database Queries

7 Different statements

14.36 ms Query time

0 Invalid entities

221 Managed entities

Grouped Statements

Show all queries

rw connection

Time▼

Count

Info

5.75 ms
(40.05%)

"COMMIT"

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

"COMMIT"

"COMMIT";

#	File/Call
1	Doctrine\ORM\UnitOfWork->commit (line 433)
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)

2.57 ms
(17.87%)

INSERT INTO 3cx_cdr_calls
            (call_id, idempotency_key, caller_id, callee_id, callee_name, direction,
             start_time, end_time, duration_seconds, ring_duration_seconds, status, recording_url,
             raw_json, created_at, updated_at)
            VALUES
            (?, ?, ?, ?, ?, ?,
             ?, ?, ?, ?, ?, ?,
             ?, NOW(), NOW())
            ON DUPLICATE KEY UPDATE
             caller_id = VALUES(caller_id),
             callee_id = VALUES(callee_id),
             callee_name = VALUES(callee_name),
             direction = VALUES(direction),
             start_time = VALUES(start_time),
             end_time = VALUES(end_time),
             duration_seconds = VALUES(duration_seconds),
             ring_duration_seconds = VALUES(ring_duration_seconds),
             status = VALUES(status),
             recording_url = VALUES(recording_url),
             raw_json = VALUES(raw_json),
             updated_at = NOW()

Parameters:

[
  "Call 00000000-01dc-de7e-f822-3a7300002b21"
  "65f383f3341a900692466519199a1924f0e46694465b6619d5b96e86d64d5ef7"
  "Ext.9900"
  "10001"
  "8032452384"
  "internal"
  "2026-05-08 00:09:53"
  "2026-05-08 00:10:05"
  12
  null
  "src_participant_terminated"
  null
  "{"raw":"Call 00000000-01dc-de7e-f822-3a7300002b21,00000000-01dc-de7e-f820-7f8a00001369,00:00:12,2026\/05\/08 00:09:42,2026\/05\/08 00:09:53,2026\/05\/08 00:10:05,src_participant_terminated,Ext.9900,8032452384,9900,10001,8032452384,,8032452384,10001,default,1,0.21,default,Chain: Ext.9900;8032452384;,Center Call","call_id":"Call 00000000-01dc-de7e-f822-3a7300002b21","source_id":"00000000-01dc-de7e-f820-7f8a00001369","caller_id":"Ext.9900","callee_id":"10001","callee_name":"8032452384","direction":"internal","start_time":"2026\/05\/08 00:09:53","end_time":"2026\/05\/08 00:10:05","duration_seconds":12,"status":"src_participant_terminated","parsed_fields":{"call_id":"Call 00000000-01dc-de7e-f822-3a7300002b21","source_id":"00000000-01dc-de7e-f820-7f8a00001369","duration":"00:00:12","ring_start_time":"2026\/05\/08 00:09:42","start_time":"2026\/05\/08 00:09:53","end_time":"2026\/05\/08 00:10:05","status":"src_participant_terminated","caller_id":"Ext.9900","caller_extension":"8032452384","dialed_number":"9900","callee_id":"10001","callee_number":"8032452384","field_13":"","callee_name":"8032452384","extension":"10001","field_16":"default","field_17":"1","field_18":"0.21","field_19":"default","route_chain":"Chain: Ext.9900;8032452384;","caller_number":"Center Call"},"source_ip":"172.16.17.4","received_at":"2026-05-08T00:09:32.859Z","ring_duration_seconds":null,"recording_url":null}"
]

View formatted query View runnable query Explain query View query backtrace

INSERT INTO 3cx_cdr_calls (
  call_id, idempotency_key, caller_id,
  callee_id, callee_name, direction,
  start_time, end_time, duration_seconds,
  ring_duration_seconds, status, recording_url,
  raw_json, created_at, updated_at
)
VALUES
  (
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    NOW(),
    NOW()
  ) ON DUPLICATE KEY
UPDATE
  caller_id =
VALUES
  (caller_id),
  callee_id =
VALUES
  (callee_id),
  callee_name =
VALUES
  (callee_name),
  direction =
VALUES
  (direction),
  start_time =
VALUES
  (start_time),
  end_time =
VALUES
  (end_time),
  duration_seconds =
VALUES
  (duration_seconds),
  ring_duration_seconds =
VALUES
  (ring_duration_seconds),
  status =
VALUES
  (status),
  recording_url =
VALUES
  (recording_url),
  raw_json =
VALUES
  (raw_json),
  updated_at = NOW()

INSERT INTO 3cx_cdr_calls
            (call_id, idempotency_key, caller_id, callee_id, callee_name, direction,
             start_time, end_time, duration_seconds, ring_duration_seconds, status, recording_url,
             raw_json, created_at, updated_at)
            VALUES
            ('Call 00000000-01dc-de7e-f822-3a7300002b21', '65f383f3341a900692466519199a1924f0e46694465b6619d5b96e86d64d5ef7', 'Ext.9900', '10001', '8032452384', 'internal',
             '2026-05-08 00:09:53', '2026-05-08 00:10:05', 12, NULL, 'src_participant_terminated', NULL,
             '{\"raw\":\"Call 00000000-01dc-de7e-f822-3a7300002b21,00000000-01dc-de7e-f820-7f8a00001369,00:00:12,2026\\/05\\/08 00:09:42,2026\\/05\\/08 00:09:53,2026\\/05\\/08 00:10:05,src_participant_terminated,Ext.9900,8032452384,9900,10001,8032452384,,8032452384,10001,default,1,0.21,default,Chain: Ext.9900;8032452384;,Center Call\",\"call_id\":\"Call 00000000-01dc-de7e-f822-3a7300002b21\",\"source_id\":\"00000000-01dc-de7e-f820-7f8a00001369\",\"caller_id\":\"Ext.9900\",\"callee_id\":\"10001\",\"callee_name\":\"8032452384\",\"direction\":\"internal\",\"start_time\":\"2026\\/05\\/08 00:09:53\",\"end_time\":\"2026\\/05\\/08 00:10:05\",\"duration_seconds\":12,\"status\":\"src_participant_terminated\",\"parsed_fields\":{\"call_id\":\"Call 00000000-01dc-de7e-f822-3a7300002b21\",\"source_id\":\"00000000-01dc-de7e-f820-7f8a00001369\",\"duration\":\"00:00:12\",\"ring_start_time\":\"2026\\/05\\/08 00:09:42\",\"start_time\":\"2026\\/05\\/08 00:09:53\",\"end_time\":\"2026\\/05\\/08 00:10:05\",\"status\":\"src_participant_terminated\",\"caller_id\":\"Ext.9900\",\"caller_extension\":\"8032452384\",\"dialed_number\":\"9900\",\"callee_id\":\"10001\",\"callee_number\":\"8032452384\",\"field_13\":\"\",\"callee_name\":\"8032452384\",\"extension\":\"10001\",\"field_16\":\"default\",\"field_17\":\"1\",\"field_18\":\"0.21\",\"field_19\":\"default\",\"route_chain\":\"Chain: Ext.9900;8032452384;\",\"caller_number\":\"Center Call\"},\"source_ip\":\"172.16.17.4\",\"received_at\":\"2026-05-08T00:09:32.859Z\",\"ring_duration_seconds\":null,\"recording_url\":null}', NOW(), NOW())
            ON DUPLICATE KEY UPDATE
             caller_id = VALUES(caller_id),
             callee_id = VALUES(callee_id),
             callee_name = VALUES(callee_name),
             direction = VALUES(direction),
             start_time = VALUES(start_time),
             end_time = VALUES(end_time),
             duration_seconds = VALUES(duration_seconds),
             ring_duration_seconds = VALUES(ring_duration_seconds),
             status = VALUES(status),
             recording_url = VALUES(recording_url),
             raw_json = VALUES(raw_json),
             updated_at = NOW();

#	File/Call
1	App\Service\ThreeCXCDRProcessor->upsertCall (line 111)
2	App\Service\ThreeCXCDRProcessor->process (line 45)
3	App\Controller\ThreeCXCDRController->__invoke (line 82)
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)

2.03 ms
(14.15%)

SELECT s0_.id AS id_0, s0_.operator_extension AS operator_extension_1, s0_.started_at AS started_at_2, s0_.completed_at AS completed_at_3, s0_.call_answered_at AS call_answered_at_4, s0_.manual_outcome AS manual_outcome_5, s0_.notes AS notes_6, s0_.callback_scheduled_at AS callback_scheduled_at_7, s0_.threecx_call_id AS threecx_call_id_8, s0_.cdr_verified AS cdr_verified_9, s0_.cdr_match_status AS cdr_match_status_10, s0_.cdr_duration_seconds AS cdr_duration_seconds_11, s0_.cdr_disposition AS cdr_disposition_12, s0_.created_at AS created_at_13, s0_.updated_at AS updated_at_14, s0_.target_id AS target_id_15, s0_.operator_user_id AS operator_user_id_16, s0_.attempted_phone_record_id AS attempted_phone_record_id_17 FROM store_call_attempt s0_ WHERE s0_.cdr_verified = ? AND s0_.completed_at IS NOT NULL ORDER BY s0_.completed_at DESC

Parameters:

[
  0
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  s0_.id AS id_0,
  s0_.operator_extension AS operator_extension_1,
  s0_.started_at AS started_at_2,
  s0_.completed_at AS completed_at_3,
  s0_.call_answered_at AS call_answered_at_4,
  s0_.manual_outcome AS manual_outcome_5,
  s0_.notes AS notes_6,
  s0_.callback_scheduled_at AS callback_scheduled_at_7,
  s0_.threecx_call_id AS threecx_call_id_8,
  s0_.cdr_verified AS cdr_verified_9,
  s0_.cdr_match_status AS cdr_match_status_10,
  s0_.cdr_duration_seconds AS cdr_duration_seconds_11,
  s0_.cdr_disposition AS cdr_disposition_12,
  s0_.created_at AS created_at_13,
  s0_.updated_at AS updated_at_14,
  s0_.target_id AS target_id_15,
  s0_.operator_user_id AS operator_user_id_16,
  s0_.attempted_phone_record_id AS attempted_phone_record_id_17
FROM
  store_call_attempt s0_
WHERE
  s0_.cdr_verified = ?
  AND s0_.completed_at IS NOT NULL
ORDER BY
  s0_.completed_at DESC

SELECT s0_.id AS id_0, s0_.operator_extension AS operator_extension_1, s0_.started_at AS started_at_2, s0_.completed_at AS completed_at_3, s0_.call_answered_at AS call_answered_at_4, s0_.manual_outcome AS manual_outcome_5, s0_.notes AS notes_6, s0_.callback_scheduled_at AS callback_scheduled_at_7, s0_.threecx_call_id AS threecx_call_id_8, s0_.cdr_verified AS cdr_verified_9, s0_.cdr_match_status AS cdr_match_status_10, s0_.cdr_duration_seconds AS cdr_duration_seconds_11, s0_.cdr_disposition AS cdr_disposition_12, s0_.created_at AS created_at_13, s0_.updated_at AS updated_at_14, s0_.target_id AS target_id_15, s0_.operator_user_id AS operator_user_id_16, s0_.attempted_phone_record_id AS attempted_phone_record_id_17 FROM store_call_attempt s0_ WHERE s0_.cdr_verified = 0 AND s0_.completed_at IS NOT NULL ORDER BY s0_.completed_at 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\StoreCallAttemptRepository->findUnverifiedAttempts (line 28)
7	App\Service\StoreCall\StoreCallCdrReconciliationService->reconcileForCdr (line 43)
8	App\Controller\ThreeCXCDRController->__invoke (line 89)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
11	Symfony\Component\HttpKernel\Kernel->handle (line 193)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
13	require_once (line 32)
14	require_once (line 5)

1.78 ms
(12.40%)

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-05-08 00:09:32"
  null
  "received"
  "00000000-01dc-de7e-f820-7f8a00001369"
  "Call 00000000-01dc-de7e-f822-3a7300002b21"
  "65f383f3341a900692466519199a1924f0e46694465b6619d5b96e86d64d5ef7"
  "{"raw":"Call 00000000-01dc-de7e-f822-3a7300002b21,00000000-01dc-de7e-f820-7f8a00001369,00:00:12,2026/05/08 00:09:42,2026/05/08 00:09:53,2026/05/08 00:10:05,src_participant_terminated,Ext.9900,8032452384,9900,10001,8032452384,,8032452384,10001,default,1,0.21,default,Chain: Ext.9900;8032452384;,Center Call","call_id":"Call 00000000-01dc-de7e-f822-3a7300002b21","source_id":"00000000-01dc-de7e-f820-7f8a00001369","caller_id":"Ext.9900","callee_id":"10001","callee_name":"8032452384","direction":"internal","start_time":"2026/05/08 00:09:53","end_time":"2026/05/08 00:10:05","duration_seconds":12,"status":"src_participant_terminated","parsed_fields":{"call_id":"Call 00000000-01dc-de7e-f822-3a7300002b21","source_id":"00000000-01dc-de7e-f820-7f8a00001369","duration":"00:00:12","ring_start_time":"2026/05/08 00:09:42","start_time":"2026/05/08 00:09:53","end_time":"2026/05/08 00:10:05","status":"src_participant_terminated","caller_id":"Ext.9900","caller_extension":"8032452384","dialed_number":"9900","callee_id":"10001","callee_number":"8032452384","field_13":"","callee_name":"8032452384","extension":"10001","field_16":"default","field_17":"1","field_18":"0.21","field_19":"default","route_chain":"Chain: Ext.9900;8032452384;","caller_number":"Center Call"},"source_ip":"172.16.17.4","received_at":"2026-05-08T00:09:32.859Z"}"
  "{"raw":"Call 00000000-01dc-de7e-f822-3a7300002b21,00000000-01dc-de7e-f820-7f8a00001369,00:00:12,2026\/05\/08 00:09:42,2026\/05\/08 00:09:53,2026\/05\/08 00:10:05,src_participant_terminated,Ext.9900,8032452384,9900,10001,8032452384,,8032452384,10001,default,1,0.21,default,Chain: Ext.9900;8032452384;,Center Call","call_id":"Call 00000000-01dc-de7e-f822-3a7300002b21","source_id":"00000000-01dc-de7e-f820-7f8a00001369","caller_id":"Ext.9900","callee_id":"10001","callee_name":"8032452384","direction":"internal","start_time":"2026\/05\/08 00:09:53","end_time":"2026\/05\/08 00:10:05","duration_seconds":12,"status":"src_participant_terminated","parsed_fields":{"call_id":"Call 00000000-01dc-de7e-f822-3a7300002b21","source_id":"00000000-01dc-de7e-f820-7f8a00001369","duration":"00:00:12","ring_start_time":"2026\/05\/08 00:09:42","start_time":"2026\/05\/08 00:09:53","end_time":"2026\/05\/08 00:10:05","status":"src_participant_terminated","caller_id":"Ext.9900","caller_extension":"8032452384","dialed_number":"9900","callee_id":"10001","callee_number":"8032452384","field_13":"","callee_name":"8032452384","extension":"10001","field_16":"default","field_17":"1","field_18":"0.21","field_19":"default","route_chain":"Chain: Ext.9900;8032452384;","caller_number":"Center Call"},"source_ip":"172.16.17.4","received_at":"2026-05-08T00:09:32.859Z"}"
  "172.70.54.249"
  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-05-08 00:09:32', NULL, 'received', '00000000-01dc-de7e-f820-7f8a00001369', 'Call 00000000-01dc-de7e-f822-3a7300002b21', '65f383f3341a900692466519199a1924f0e46694465b6619d5b96e86d64d5ef7', '{\"raw\":\"Call 00000000-01dc-de7e-f822-3a7300002b21,00000000-01dc-de7e-f820-7f8a00001369,00:00:12,2026/05/08 00:09:42,2026/05/08 00:09:53,2026/05/08 00:10:05,src_participant_terminated,Ext.9900,8032452384,9900,10001,8032452384,,8032452384,10001,default,1,0.21,default,Chain: Ext.9900;8032452384;,Center Call\",\"call_id\":\"Call 00000000-01dc-de7e-f822-3a7300002b21\",\"source_id\":\"00000000-01dc-de7e-f820-7f8a00001369\",\"caller_id\":\"Ext.9900\",\"callee_id\":\"10001\",\"callee_name\":\"8032452384\",\"direction\":\"internal\",\"start_time\":\"2026/05/08 00:09:53\",\"end_time\":\"2026/05/08 00:10:05\",\"duration_seconds\":12,\"status\":\"src_participant_terminated\",\"parsed_fields\":{\"call_id\":\"Call 00000000-01dc-de7e-f822-3a7300002b21\",\"source_id\":\"00000000-01dc-de7e-f820-7f8a00001369\",\"duration\":\"00:00:12\",\"ring_start_time\":\"2026/05/08 00:09:42\",\"start_time\":\"2026/05/08 00:09:53\",\"end_time\":\"2026/05/08 00:10:05\",\"status\":\"src_participant_terminated\",\"caller_id\":\"Ext.9900\",\"caller_extension\":\"8032452384\",\"dialed_number\":\"9900\",\"callee_id\":\"10001\",\"callee_number\":\"8032452384\",\"field_13\":\"\",\"callee_name\":\"8032452384\",\"extension\":\"10001\",\"field_16\":\"default\",\"field_17\":\"1\",\"field_18\":\"0.21\",\"field_19\":\"default\",\"route_chain\":\"Chain: Ext.9900;8032452384;\",\"caller_number\":\"Center Call\"},\"source_ip\":\"172.16.17.4\",\"received_at\":\"2026-05-08T00:09:32.859Z\"}', '{\"raw\":\"Call 00000000-01dc-de7e-f822-3a7300002b21,00000000-01dc-de7e-f820-7f8a00001369,00:00:12,2026\\/05\\/08 00:09:42,2026\\/05\\/08 00:09:53,2026\\/05\\/08 00:10:05,src_participant_terminated,Ext.9900,8032452384,9900,10001,8032452384,,8032452384,10001,default,1,0.21,default,Chain: Ext.9900;8032452384;,Center Call\",\"call_id\":\"Call 00000000-01dc-de7e-f822-3a7300002b21\",\"source_id\":\"00000000-01dc-de7e-f820-7f8a00001369\",\"caller_id\":\"Ext.9900\",\"callee_id\":\"10001\",\"callee_name\":\"8032452384\",\"direction\":\"internal\",\"start_time\":\"2026\\/05\\/08 00:09:53\",\"end_time\":\"2026\\/05\\/08 00:10:05\",\"duration_seconds\":12,\"status\":\"src_participant_terminated\",\"parsed_fields\":{\"call_id\":\"Call 00000000-01dc-de7e-f822-3a7300002b21\",\"source_id\":\"00000000-01dc-de7e-f820-7f8a00001369\",\"duration\":\"00:00:12\",\"ring_start_time\":\"2026\\/05\\/08 00:09:42\",\"start_time\":\"2026\\/05\\/08 00:09:53\",\"end_time\":\"2026\\/05\\/08 00:10:05\",\"status\":\"src_participant_terminated\",\"caller_id\":\"Ext.9900\",\"caller_extension\":\"8032452384\",\"dialed_number\":\"9900\",\"callee_id\":\"10001\",\"callee_number\":\"8032452384\",\"field_13\":\"\",\"callee_name\":\"8032452384\",\"extension\":\"10001\",\"field_16\":\"default\",\"field_17\":\"1\",\"field_18\":\"0.21\",\"field_19\":\"default\",\"route_chain\":\"Chain: Ext.9900;8032452384;\",\"caller_number\":\"Center Call\"},\"source_ip\":\"172.16.17.4\",\"received_at\":\"2026-05-08T00:09:32.859Z\"}', '172.70.54.249', 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.83 ms
(5.80%)

UPDATE 3cx_cdr_ingest_events SET processed_at = ?, status = ? WHERE id = ?

Parameters:

[
  "2026-05-08 00:09:32"
  "processed"
  5428
]

View formatted query View runnable query Explain query View query backtrace

UPDATE
  3cx_cdr_ingest_events
SET
  processed_at = ?,
  status = ?
WHERE
  id = ?

UPDATE 3cx_cdr_ingest_events SET processed_at = '2026-05-08 00:09:32', status = 'processed' WHERE id = 5428;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->updateTable (line 494)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->update (line 378)
3	Doctrine\ORM\UnitOfWork->executeUpdates (line 1140)
4	Doctrine\ORM\UnitOfWork->commit (line 408)
5	Doctrine\ORM\EntityManager->flush (line 268)
6	App\Controller\ThreeCXCDRController->__invoke (line 84)
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.81 ms
(5.62%)

SELECT t0.id AS id_1, t0.call_id AS call_id_2, t0.idempotency_key AS idempotency_key_3, t0.caller_id AS caller_id_4, t0.callee_id AS callee_id_5, t0.callee_name AS callee_name_6, t0.direction AS direction_7, t0.start_time AS start_time_8, t0.end_time AS end_time_9, t0.duration_seconds AS duration_seconds_10, t0.ring_duration_seconds AS ring_duration_seconds_11, t0.status AS status_12, t0.recording_url AS recording_url_13, t0.raw_json AS raw_json_14, t0.created_at AS created_at_15, t0.updated_at AS updated_at_16 FROM 3cx_cdr_calls t0 WHERE t0.call_id = ? LIMIT 1

Parameters:

[
  "Call 00000000-01dc-de7e-f822-3a7300002b21"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.call_id AS call_id_2,
  t0.idempotency_key AS idempotency_key_3,
  t0.caller_id AS caller_id_4,
  t0.callee_id AS callee_id_5,
  t0.callee_name AS callee_name_6,
  t0.direction AS direction_7,
  t0.start_time AS start_time_8,
  t0.end_time AS end_time_9,
  t0.duration_seconds AS duration_seconds_10,
  t0.ring_duration_seconds AS ring_duration_seconds_11,
  t0.status AS status_12,
  t0.recording_url AS recording_url_13,
  t0.raw_json AS raw_json_14,
  t0.created_at AS created_at_15,
  t0.updated_at AS updated_at_16
FROM
  3cx_cdr_calls t0
WHERE
  t0.call_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.call_id AS call_id_2, t0.idempotency_key AS idempotency_key_3, t0.caller_id AS caller_id_4, t0.callee_id AS callee_id_5, t0.callee_name AS callee_name_6, t0.direction AS direction_7, t0.start_time AS start_time_8, t0.end_time AS end_time_9, t0.duration_seconds AS duration_seconds_10, t0.ring_duration_seconds AS ring_duration_seconds_11, t0.status AS status_12, t0.recording_url AS recording_url_13, t0.raw_json AS raw_json_14, t0.created_at AS created_at_15, t0.updated_at AS updated_at_16 FROM 3cx_cdr_calls t0 WHERE t0.call_id = 'Call 00000000-01dc-de7e-f822-3a7300002b21' LIMIT 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\EntityRepository->findOneBy (line 125)
3	App\Controller\ThreeCXCDRController->__invoke (line 86)
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)

0.59 ms
(4.11%)

"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)

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
App\Entity\RW\StoreCallAttempt	72
App\Entity\RW\StoreCallTarget	72
App\Entity\RW\StoreCallTargetPhone	72
App\Entity\RW\User	3
App\Entity\RW\ThreeCXCDRIngestEvent	1
App\Entity\RW\ThreeCXCDRCall	1

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.
App\Entity\RW\ThreeCXCDRCall	No errors.
App\Entity\RW\StoreCallAttempt	No errors.
App\Entity\RW\StoreCallTarget	No errors.
App\Entity\RW\User	No errors.
App\Entity\RW\StoreCallTargetPhone	No errors.
App\Entity\RW\StoreCallAnswer	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

Grouped Statements

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