Symfony Profiler

Query Metrics

13 Database Queries

11 Different statements

21.61 ms Query time

2 Invalid entities

5 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

4.75 ms
(21.96%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.streaming_port AS streaming_port_3, t0.admin_port AS admin_port_4, t0.manager_port AS manager_port_5, t0.web_server_port AS web_server_port_6, t0.turn_port AS turn_port_7, t0.address AS address_8, t0.storage_folder AS storage_folder_9, t0.use_ssl AS use_ssl_10, t0.use_s3 AS use_s3_11, t0.is_default AS is_default_12, t0.licensor AS licensor_13, t0.has_gpu AS has_gpu_14, t0.has_live_asr AS has_live_asr_15, t0.rtmp_username AS rtmp_username_16, t0.rtmp_password AS rtmp_password_17, t0.llm_available AS llm_available_18, t0.llm_signer_trusted_until AS llm_signer_trusted_until_19, t0.translation_available AS translation_available_20, t0.translation_signer_trusted_until AS translation_signer_trusted_until_21, t0.transcription_service_id AS transcription_service_id_22, t0.sync_id AS sync_id_23, t24.stream AS stream_25, t24.video AS video_26, t24.video_prefix AS video_prefix_27, t24.wowza_id AS wowza_id_28, t29.active AS active_30, t29.wowza_id AS wowza_id_31, t29.storage_id AS storage_id_32 FROM wowza t0 LEFT JOIN wowza_routing t24 ON t24.wowza_id = t0.id LEFT JOIN wowza_status t29 ON t29.wowza_id = t0.id

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.streaming_port AS streaming_port_3,
  t0.admin_port AS admin_port_4,
  t0.manager_port AS manager_port_5,
  t0.web_server_port AS web_server_port_6,
  t0.turn_port AS turn_port_7,
  t0.address AS address_8,
  t0.storage_folder AS storage_folder_9,
  t0.use_ssl AS use_ssl_10,
  t0.use_s3 AS use_s3_11,
  t0.is_default AS is_default_12,
  t0.licensor AS licensor_13,
  t0.has_gpu AS has_gpu_14,
  t0.has_live_asr AS has_live_asr_15,
  t0.rtmp_username AS rtmp_username_16,
  t0.rtmp_password AS rtmp_password_17,
  t0.llm_available AS llm_available_18,
  t0.llm_signer_trusted_until AS llm_signer_trusted_until_19,
  t0.translation_available AS translation_available_20,
  t0.translation_signer_trusted_until AS translation_signer_trusted_until_21,
  t0.transcription_service_id AS transcription_service_id_22,
  t0.sync_id AS sync_id_23,
  t24.stream AS stream_25,
  t24.video AS video_26,
  t24.video_prefix AS video_prefix_27,
  t24.wowza_id AS wowza_id_28,
  t29.active AS active_30,
  t29.wowza_id AS wowza_id_31,
  t29.storage_id AS storage_id_32
FROM
  wowza t0
  LEFT JOIN wowza_routing t24 ON t24.wowza_id = t0.id
  LEFT JOIN wowza_status t29 ON t29.wowza_id = t0.id

SELECT t0.id AS id_1, t0.name AS name_2, t0.streaming_port AS streaming_port_3, t0.admin_port AS admin_port_4, t0.manager_port AS manager_port_5, t0.web_server_port AS web_server_port_6, t0.turn_port AS turn_port_7, t0.address AS address_8, t0.storage_folder AS storage_folder_9, t0.use_ssl AS use_ssl_10, t0.use_s3 AS use_s3_11, t0.is_default AS is_default_12, t0.licensor AS licensor_13, t0.has_gpu AS has_gpu_14, t0.has_live_asr AS has_live_asr_15, t0.rtmp_username AS rtmp_username_16, t0.rtmp_password AS rtmp_password_17, t0.llm_available AS llm_available_18, t0.llm_signer_trusted_until AS llm_signer_trusted_until_19, t0.translation_available AS translation_available_20, t0.translation_signer_trusted_until AS translation_signer_trusted_until_21, t0.transcription_service_id AS transcription_service_id_22, t0.sync_id AS sync_id_23, t24.stream AS stream_25, t24.video AS video_26, t24.video_prefix AS video_prefix_27, t24.wowza_id AS wowza_id_28, t29.active AS active_30, t29.wowza_id AS wowza_id_31, t29.storage_id AS storage_id_32 FROM wowza t0 LEFT JOIN wowza_routing t24 ON t24.wowza_id = t0.id LEFT JOIN wowza_status t29 ON t29.wowza_id = t0.id;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 804)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 963)
3	Doctrine\ORM\EntityRepository->findBy (line 110)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepository->findBy (line 78)
5	Doctrine\ORM\EntityRepository->findAll (line 96)
6	Valt\CamBundle\Security\Trust\WowzaTrustedIssuerProvider->getTrustedIssuers (line 17)
7	Valt\Security\Application\Profile\CommonServiceTokenProfile->acceptedIssuers (line 100)
8	Valt\Security\Infrastructure\Jose\Token\JoseTokenVerifier->__construct (line 56)
9	ContainerTxCe9q4\getJoseTokenVerifierService->do (line 30)
10	ContainerTxCe9q4\Valt_KernelDevDebugContainer::load (line 1112)
11	ContainerTxCe9q4\getSecurity_Authenticator_AccessToken_WowzaApiService->do (line 31)
12	ContainerTxCe9q4\Valt_KernelDevDebugContainer::load (line 1112)
13	ContainerTxCe9q4\getDebug_Security_Authenticator_AccessToken_WowzaApiService->do (line 26)
14	ContainerTxCe9q4\Valt_KernelDevDebugContainer::load (line 1112)
15	ContainerTxCe9q4\getSecurity_Authenticator_Manager_WowzaApiService->do (line 25)
16	ContainerTxCe9q4\Valt_KernelDevDebugContainer::load (line 1112)
17	ContainerTxCe9q4\getDebug_Security_Firewall_Authenticator_WowzaApiService->do (line 24)
18	ContainerTxCe9q4\Valt_KernelDevDebugContainer::load (line 1112)
19	ContainerTxCe9q4\getSecurity_Firewall_Map_Context_WowzaApiService->{closure:ContainerTxCe9q4\getSecurity_Firewall_Map_Context_WowzaApiService::do():25} (line 27)
20	Symfony\Component\Security\Http\Firewall::{closure:Symfony\Component\Security\Http\Firewall::onKernelRequest():70} (line 75)
21	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 54)
22	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 93)
23	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
24	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
25	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
26	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 129)
27	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
28	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
29	Symfony\Component\HttpKernel\Kernel->handle (line 193)
30	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
31	require_once (line 32)
32	require_once (line 5)

4.17 ms
(19.31%)

"COMMIT"

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

"COMMIT"

"COMMIT";

#	File/Call
1	Valt\Shared\Infrastructure\Doctrine\Middleware\TransactionBoundaryConnection->commit (line 33)
2	Doctrine\DBAL\Connection->commit (line 1083)
3	Doctrine\ORM\UnitOfWork->commit (line 434)
4	Doctrine\ORM\EntityManager->flush (line 268)
5	Valt\CamBundle\Repository\WowzaRepository->flush (line 53)
6	Valt\CamBundle\Controller\Wowza\SendWowzaStateController->__invoke (line 51)
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 34)
11	require_once (line 32)
12	require_once (line 5)

1.83 ms
(8.48%)

SELECT DISTINCT w0_.selected_llm_host_id AS selected_llm_host_id_0 FROM workload_job w0_ WHERE (w0_.status IN (?, ?, ?) AND w0_.selected_llm_host_id IS NOT NULL) AND w0_.type IN ('summary')

Parameters:

[
  "starting"
  "awaiting_confirmation"
  "running"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT w0_.selected_llm_host_id AS selected_llm_host_id_0
FROM
  workload_job w0_
WHERE
  (
    w0_.status IN (?, ?, ?)
    AND w0_.selected_llm_host_id IS NOT NULL
  )
  AND w0_.type IN ('summary')

SELECT DISTINCT w0_.selected_llm_host_id AS selected_llm_host_id_0 FROM workload_job w0_ WHERE (w0_.status IN ('starting', 'awaiting_confirmation', 'running') AND w0_.selected_llm_host_id IS NOT NULL) AND w0_.type IN ('summary');

#	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->getSingleColumnResult (line 712)
6	Valt\Workload\Infrastructure\Repository\JobRepository->findActiveSummaryLlmHostIds (line 104)
7	Valt\Workload\Infrastructure\Adapter\DoctrineSummaryLlmHostTrust->activeHostIds (line 28)
8	Valt\TranscriptSummary\Infrastructure\Security\Trust\LocalLlmTrustedKeySetProvider->getTrustedKeySets (line 28)
9	Valt\Security\Infrastructure\Jose\Key\Source\CommonServiceVerificationKeySource->getResource (line 30)
10	Valt\Security\Infrastructure\Jose\Key\KeySelector->select (line 16)
11	Valt\Security\Infrastructure\Jose\Token\JoseTokenVerifier->verify (line 73)
12	Valt\CamBundle\Security\WowzaAccessTokenHandler->getUserBadgeFrom (line 30)
13	Symfony\Component\Security\Http\Authenticator\AccessTokenAuthenticator->authenticate (line 61)
14	Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator->authenticate (line 72)
15	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticator (line 185)
16	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticators (line 167)
17	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->authenticateRequest (line 149)
18	Symfony\Component\Security\Http\Firewall\AuthenticatorManagerListener->authenticate (line 38)
19	Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticatorManagerListener->authenticate (line 58)
20	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 46)
21	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 94)
22	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 93)
23	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
24	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
25	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
26	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 129)
27	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
28	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
29	Symfony\Component\HttpKernel\Kernel->handle (line 193)
30	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
31	require_once (line 32)
32	require_once (line 5)

1.75 ms
(8.08%)

SELECT w0_.id AS id_0, w0_.name AS name_1, w0_.streaming_port AS streaming_port_2, w0_.admin_port AS admin_port_3, w0_.manager_port AS manager_port_4, w0_.web_server_port AS web_server_port_5, w0_.turn_port AS turn_port_6, w0_.address AS address_7, w0_.storage_folder AS storage_folder_8, w0_.use_ssl AS use_ssl_9, w0_.use_s3 AS use_s3_10, w0_.is_default AS is_default_11, w0_.licensor AS licensor_12, w0_.has_gpu AS has_gpu_13, w0_.has_live_asr AS has_live_asr_14, w0_.rtmp_username AS rtmp_username_15, w0_.rtmp_password AS rtmp_password_16, w0_.llm_available AS llm_available_17, w0_.llm_signer_trusted_until AS llm_signer_trusted_until_18, w0_.translation_available AS translation_available_19, w0_.translation_signer_trusted_until AS translation_signer_trusted_until_20, w0_.transcription_service_id AS transcription_service_id_21, w0_.sync_id AS sync_id_22 FROM wowza w0_ LEFT JOIN wowza_status w1_ ON w0_.id = w1_.wowza_id WHERE (w0_.llm_available = 1 AND w1_.active = 1) OR w0_.llm_signer_trusted_until > ? ORDER BY w0_.name ASC

Parameters:

[
  "2026-10-11 01:12:14"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  w0_.id AS id_0,
  w0_.name AS name_1,
  w0_.streaming_port AS streaming_port_2,
  w0_.admin_port AS admin_port_3,
  w0_.manager_port AS manager_port_4,
  w0_.web_server_port AS web_server_port_5,
  w0_.turn_port AS turn_port_6,
  w0_.address AS address_7,
  w0_.storage_folder AS storage_folder_8,
  w0_.use_ssl AS use_ssl_9,
  w0_.use_s3 AS use_s3_10,
  w0_.is_default AS is_default_11,
  w0_.licensor AS licensor_12,
  w0_.has_gpu AS has_gpu_13,
  w0_.has_live_asr AS has_live_asr_14,
  w0_.rtmp_username AS rtmp_username_15,
  w0_.rtmp_password AS rtmp_password_16,
  w0_.llm_available AS llm_available_17,
  w0_.llm_signer_trusted_until AS llm_signer_trusted_until_18,
  w0_.translation_available AS translation_available_19,
  w0_.translation_signer_trusted_until AS translation_signer_trusted_until_20,
  w0_.transcription_service_id AS transcription_service_id_21,
  w0_.sync_id AS sync_id_22
FROM
  wowza w0_
  LEFT JOIN wowza_status w1_ ON w0_.id = w1_.wowza_id
WHERE
  (
    w0_.llm_available = 1
    AND w1_.active = 1
  )
  OR w0_.llm_signer_trusted_until > ?
ORDER BY
  w0_.name ASC

SELECT w0_.id AS id_0, w0_.name AS name_1, w0_.streaming_port AS streaming_port_2, w0_.admin_port AS admin_port_3, w0_.manager_port AS manager_port_4, w0_.web_server_port AS web_server_port_5, w0_.turn_port AS turn_port_6, w0_.address AS address_7, w0_.storage_folder AS storage_folder_8, w0_.use_ssl AS use_ssl_9, w0_.use_s3 AS use_s3_10, w0_.is_default AS is_default_11, w0_.licensor AS licensor_12, w0_.has_gpu AS has_gpu_13, w0_.has_live_asr AS has_live_asr_14, w0_.rtmp_username AS rtmp_username_15, w0_.rtmp_password AS rtmp_password_16, w0_.llm_available AS llm_available_17, w0_.llm_signer_trusted_until AS llm_signer_trusted_until_18, w0_.translation_available AS translation_available_19, w0_.translation_signer_trusted_until AS translation_signer_trusted_until_20, w0_.transcription_service_id AS transcription_service_id_21, w0_.sync_id AS sync_id_22 FROM wowza w0_ LEFT JOIN wowza_status w1_ ON w0_.id = w1_.wowza_id WHERE (w0_.llm_available = 1 AND w1_.active = 1) OR w0_.llm_signer_trusted_until > '2026-10-11 01:12:14' ORDER BY w0_.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	Valt\CamBundle\Repository\WowzaRepository->findTrustedForLlmCallbacks (line 267)
7	Valt\TranscriptSummary\Infrastructure\Security\Trust\LocalLlmTrustedKeySetProvider->getTrustedKeySets (line 26)
8	Valt\Security\Infrastructure\Jose\Key\Source\CommonServiceVerificationKeySource->getResource (line 30)
9	Valt\Security\Infrastructure\Jose\Key\KeySelector->select (line 16)
10	Valt\Security\Infrastructure\Jose\Token\JoseTokenVerifier->verify (line 73)
11	Valt\CamBundle\Security\WowzaAccessTokenHandler->getUserBadgeFrom (line 30)
12	Symfony\Component\Security\Http\Authenticator\AccessTokenAuthenticator->authenticate (line 61)
13	Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator->authenticate (line 72)
14	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticator (line 185)
15	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticators (line 167)
16	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->authenticateRequest (line 149)
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 46)
20	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 94)
21	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 93)
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 129)
26	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
27	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
28	Symfony\Component\HttpKernel\Kernel->handle (line 193)
29	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
30	require_once (line 32)
31	require_once (line 5)

1.74 ms
(8.04%)

SELECT w0_.id AS id_0, w0_.name AS name_1, w0_.streaming_port AS streaming_port_2, w0_.admin_port AS admin_port_3, w0_.manager_port AS manager_port_4, w0_.web_server_port AS web_server_port_5, w0_.turn_port AS turn_port_6, w0_.address AS address_7, w0_.storage_folder AS storage_folder_8, w0_.use_ssl AS use_ssl_9, w0_.use_s3 AS use_s3_10, w0_.is_default AS is_default_11, w0_.licensor AS licensor_12, w0_.has_gpu AS has_gpu_13, w0_.has_live_asr AS has_live_asr_14, w0_.rtmp_username AS rtmp_username_15, w0_.rtmp_password AS rtmp_password_16, w0_.llm_available AS llm_available_17, w0_.llm_signer_trusted_until AS llm_signer_trusted_until_18, w0_.translation_available AS translation_available_19, w0_.translation_signer_trusted_until AS translation_signer_trusted_until_20, w0_.transcription_service_id AS transcription_service_id_21, w0_.sync_id AS sync_id_22 FROM wowza w0_ WHERE w0_.translation_available = ? OR w0_.translation_signer_trusted_until > ? ORDER BY w0_.name ASC

Parameters:

[
  1
  "2026-10-11 01:12:14"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  w0_.id AS id_0,
  w0_.name AS name_1,
  w0_.streaming_port AS streaming_port_2,
  w0_.admin_port AS admin_port_3,
  w0_.manager_port AS manager_port_4,
  w0_.web_server_port AS web_server_port_5,
  w0_.turn_port AS turn_port_6,
  w0_.address AS address_7,
  w0_.storage_folder AS storage_folder_8,
  w0_.use_ssl AS use_ssl_9,
  w0_.use_s3 AS use_s3_10,
  w0_.is_default AS is_default_11,
  w0_.licensor AS licensor_12,
  w0_.has_gpu AS has_gpu_13,
  w0_.has_live_asr AS has_live_asr_14,
  w0_.rtmp_username AS rtmp_username_15,
  w0_.rtmp_password AS rtmp_password_16,
  w0_.llm_available AS llm_available_17,
  w0_.llm_signer_trusted_until AS llm_signer_trusted_until_18,
  w0_.translation_available AS translation_available_19,
  w0_.translation_signer_trusted_until AS translation_signer_trusted_until_20,
  w0_.transcription_service_id AS transcription_service_id_21,
  w0_.sync_id AS sync_id_22
FROM
  wowza w0_
WHERE
  w0_.translation_available = ?
  OR w0_.translation_signer_trusted_until > ?
ORDER BY
  w0_.name ASC

SELECT w0_.id AS id_0, w0_.name AS name_1, w0_.streaming_port AS streaming_port_2, w0_.admin_port AS admin_port_3, w0_.manager_port AS manager_port_4, w0_.web_server_port AS web_server_port_5, w0_.turn_port AS turn_port_6, w0_.address AS address_7, w0_.storage_folder AS storage_folder_8, w0_.use_ssl AS use_ssl_9, w0_.use_s3 AS use_s3_10, w0_.is_default AS is_default_11, w0_.licensor AS licensor_12, w0_.has_gpu AS has_gpu_13, w0_.has_live_asr AS has_live_asr_14, w0_.rtmp_username AS rtmp_username_15, w0_.rtmp_password AS rtmp_password_16, w0_.llm_available AS llm_available_17, w0_.llm_signer_trusted_until AS llm_signer_trusted_until_18, w0_.translation_available AS translation_available_19, w0_.translation_signer_trusted_until AS translation_signer_trusted_until_20, w0_.transcription_service_id AS transcription_service_id_21, w0_.sync_id AS sync_id_22 FROM wowza w0_ WHERE w0_.translation_available = 1 OR w0_.translation_signer_trusted_until > '2026-10-11 01:12:14' ORDER BY w0_.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	Valt\CamBundle\Repository\WowzaRepository->findTrustedForTranslationCallbacks (line 319)
7	Valt\TranscriptionTranslation\Infrastructure\Security\Trust\TranslationTrustedKeySetProvider->getTrustedKeySets (line 26)
8	Valt\Security\Infrastructure\Jose\Key\Source\CommonServiceVerificationKeySource->getResource (line 30)
9	Valt\Security\Infrastructure\Jose\Key\KeySelector->select (line 16)
10	Valt\Security\Infrastructure\Jose\Token\JoseTokenVerifier->verify (line 73)
11	Valt\CamBundle\Security\WowzaAccessTokenHandler->getUserBadgeFrom (line 30)
12	Symfony\Component\Security\Http\Authenticator\AccessTokenAuthenticator->authenticate (line 61)
13	Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator->authenticate (line 72)
14	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticator (line 185)
15	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticators (line 167)
16	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->authenticateRequest (line 149)
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 46)
20	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 94)
21	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 93)
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 129)
26	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
27	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
28	Symfony\Component\HttpKernel\Kernel->handle (line 193)
29	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
30	require_once (line 32)
31	require_once (line 5)

1.67 ms
(7.72%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.streaming_port AS streaming_port_3, t0.admin_port AS admin_port_4, t0.manager_port AS manager_port_5, t0.web_server_port AS web_server_port_6, t0.turn_port AS turn_port_7, t0.address AS address_8, t0.storage_folder AS storage_folder_9, t0.use_ssl AS use_ssl_10, t0.use_s3 AS use_s3_11, t0.is_default AS is_default_12, t0.licensor AS licensor_13, t0.has_gpu AS has_gpu_14, t0.has_live_asr AS has_live_asr_15, t0.rtmp_username AS rtmp_username_16, t0.rtmp_password AS rtmp_password_17, t0.llm_available AS llm_available_18, t0.llm_signer_trusted_until AS llm_signer_trusted_until_19, t0.translation_available AS translation_available_20, t0.translation_signer_trusted_until AS translation_signer_trusted_until_21, t0.transcription_service_id AS transcription_service_id_22, t0.sync_id AS sync_id_23, t24.stream AS stream_25, t24.video AS video_26, t24.video_prefix AS video_prefix_27, t24.wowza_id AS wowza_id_28, t29.active AS active_30, t29.wowza_id AS wowza_id_31, t29.storage_id AS storage_id_32 FROM wowza t0 LEFT JOIN wowza_routing t24 ON t24.wowza_id = t0.id LEFT JOIN wowza_status t29 ON t29.wowza_id = t0.id WHERE t0.address = ? LIMIT 1

Parameters:

[
  "ivsdevac3.ipivs.info"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.streaming_port AS streaming_port_3,
  t0.admin_port AS admin_port_4,
  t0.manager_port AS manager_port_5,
  t0.web_server_port AS web_server_port_6,
  t0.turn_port AS turn_port_7,
  t0.address AS address_8,
  t0.storage_folder AS storage_folder_9,
  t0.use_ssl AS use_ssl_10,
  t0.use_s3 AS use_s3_11,
  t0.is_default AS is_default_12,
  t0.licensor AS licensor_13,
  t0.has_gpu AS has_gpu_14,
  t0.has_live_asr AS has_live_asr_15,
  t0.rtmp_username AS rtmp_username_16,
  t0.rtmp_password AS rtmp_password_17,
  t0.llm_available AS llm_available_18,
  t0.llm_signer_trusted_until AS llm_signer_trusted_until_19,
  t0.translation_available AS translation_available_20,
  t0.translation_signer_trusted_until AS translation_signer_trusted_until_21,
  t0.transcription_service_id AS transcription_service_id_22,
  t0.sync_id AS sync_id_23,
  t24.stream AS stream_25,
  t24.video AS video_26,
  t24.video_prefix AS video_prefix_27,
  t24.wowza_id AS wowza_id_28,
  t29.active AS active_30,
  t29.wowza_id AS wowza_id_31,
  t29.storage_id AS storage_id_32
FROM
  wowza t0
  LEFT JOIN wowza_routing t24 ON t24.wowza_id = t0.id
  LEFT JOIN wowza_status t29 ON t29.wowza_id = t0.id
WHERE
  t0.address = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.streaming_port AS streaming_port_3, t0.admin_port AS admin_port_4, t0.manager_port AS manager_port_5, t0.web_server_port AS web_server_port_6, t0.turn_port AS turn_port_7, t0.address AS address_8, t0.storage_folder AS storage_folder_9, t0.use_ssl AS use_ssl_10, t0.use_s3 AS use_s3_11, t0.is_default AS is_default_12, t0.licensor AS licensor_13, t0.has_gpu AS has_gpu_14, t0.has_live_asr AS has_live_asr_15, t0.rtmp_username AS rtmp_username_16, t0.rtmp_password AS rtmp_password_17, t0.llm_available AS llm_available_18, t0.llm_signer_trusted_until AS llm_signer_trusted_until_19, t0.translation_available AS translation_available_20, t0.translation_signer_trusted_until AS translation_signer_trusted_until_21, t0.transcription_service_id AS transcription_service_id_22, t0.sync_id AS sync_id_23, t24.stream AS stream_25, t24.video AS video_26, t24.video_prefix AS video_prefix_27, t24.wowza_id AS wowza_id_28, t29.active AS active_30, t29.wowza_id AS wowza_id_31, t29.storage_id AS storage_id_32 FROM wowza t0 LEFT JOIN wowza_routing t24 ON t24.wowza_id = t0.id LEFT JOIN wowza_status t29 ON t29.wowza_id = t0.id WHERE t0.address = 'ivsdevac3.ipivs.info' 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 57)
5	Symfony\Component\Security\Http\Authenticator\Passport\Badge\UserBadge->getUser (line 99)
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 129)
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\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 94)
19	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 93)
20	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
21	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
22	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
23	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 129)
24	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
25	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
26	Symfony\Component\HttpKernel\Kernel->handle (line 193)
27	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
28	require_once (line 32)
29	require_once (line 5)

1.44 ms
(6.65%)

SELECT t0.id AS id_1, t0.host_wowza_id AS host_wowza_id_2, t0.provider_type FROM transcription_service t0 WHERE t0.provider_type IN ('local')

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.host_wowza_id AS host_wowza_id_2,
  t0.provider_type
FROM
  transcription_service t0
WHERE
  t0.provider_type IN ('local')

SELECT t0.id AS id_1, t0.host_wowza_id AS host_wowza_id_2, t0.provider_type FROM transcription_service t0 WHERE t0.provider_type IN ('local');

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 804)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 963)
3	Doctrine\ORM\EntityRepository->findBy (line 110)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepository->findBy (line 78)
5	Doctrine\ORM\EntityRepository->findAll (line 96)
6	Valt\CamBundle\Security\Trust\LocalTranscriptionTrustedKeySetProvider->getTrustedKeySets (line 20)
7	Valt\Security\Infrastructure\Jose\Key\Source\CommonServiceVerificationKeySource->getResource (line 30)
8	Valt\Security\Infrastructure\Jose\Key\KeySelector->select (line 16)
9	Valt\Security\Infrastructure\Jose\Token\JoseTokenVerifier->verify (line 73)
10	Valt\CamBundle\Security\WowzaAccessTokenHandler->getUserBadgeFrom (line 30)
11	Symfony\Component\Security\Http\Authenticator\AccessTokenAuthenticator->authenticate (line 61)
12	Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator->authenticate (line 72)
13	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticator (line 185)
14	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticators (line 167)
15	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->authenticateRequest (line 149)
16	Symfony\Component\Security\Http\Firewall\AuthenticatorManagerListener->authenticate (line 38)
17	Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticatorManagerListener->authenticate (line 58)
18	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 46)
19	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 94)
20	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 93)
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 129)
25	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
26	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
27	Symfony\Component\HttpKernel\Kernel->handle (line 193)
28	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
29	require_once (line 32)
30	require_once (line 5)

1.36 ms
(6.29%)

UPDATE wowza_storage SET size = ?, available_size = ?, reserved_size = ? WHERE id = ?

Parameters:

[
  "209129086976"
  "88416763904"
  "0"
  21
]

View formatted query View runnable query Explain query View query backtrace

UPDATE
  wowza_storage
SET
  size = ?,
  available_size = ?,
  reserved_size = ?
WHERE
  id = ?

UPDATE wowza_storage SET size = '209129086976', available_size = '88416763904', reserved_size = '0' WHERE id = 21;

#	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 1141)
4	Doctrine\ORM\UnitOfWork->commit (line 409)
5	Doctrine\ORM\EntityManager->flush (line 268)
6	Valt\CamBundle\Repository\WowzaRepository->flush (line 53)
7	Valt\CamBundle\Controller\Wowza\SendWowzaStateController->__invoke (line 51)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 193)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
12	require_once (line 32)
13	require_once (line 5)

1.22 ms
(5.65%)

SELECT t0.id AS id_1, t0.size AS size_2, t0.available_size AS available_size_3, t0.reserved_size AS reserved_size_4 FROM wowza_storage t0 WHERE t0.id = ?

Parameters:

[
  21
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.size AS size_2,
  t0.available_size AS available_size_3,
  t0.reserved_size AS reserved_size_4
FROM
  wowza_storage t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.size AS size_2, t0.available_size AS available_size_3, t0.reserved_size AS reserved_size_4 FROM wowza_storage t0 WHERE t0.id = 21;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
3	Doctrine\ORM\Proxy\ProxyFactory->{closure:Doctrine\ORM\Proxy\ProxyFactory::getProxy():217} (line 223)
4	Valt\CamBundle\Entity\Wowza\Storage::setSize (line 50)
5	Valt\CamBundle\Entity\Wowza\Status->activate (line 58)
6	Valt\CamBundle\Entity\Wowza->markActive (line 613)
7	Valt\CamBundle\Controller\Wowza\SendWowzaStateController->__invoke (line 42)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 193)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
12	require_once (line 32)
13	require_once (line 5)

1.11 ms
(5.14%)

SELECT 1 AS sclr_0 FROM room_motion_detection r0_ INNER JOIN rooms r1_ ON r0_.room_id = r1_.id WHERE r0_.suspended_at IS NOT NULL AND r0_.enabled_by_id IS NOT NULL AND r1_.wowza_id = ? LIMIT 1

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  1 AS sclr_0
FROM
  room_motion_detection r0_
  INNER JOIN rooms r1_ ON r0_.room_id = r1_.id
WHERE
  r0_.suspended_at IS NOT NULL
  AND r0_.enabled_by_id IS NOT NULL
  AND r1_.wowza_id = ?
LIMIT
  1

SELECT 1 AS sclr_0 FROM room_motion_detection r0_ INNER JOIN rooms r1_ ON r0_.room_id = r1_.id WHERE r0_.suspended_at IS NOT NULL AND r0_.enabled_by_id IS NOT NULL AND r1_.wowza_id = 1 LIMIT 1;

#	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->getScalarResult (line 724)
6	Valt\CamBundle\Repository\MotionDetectionRepository->hasSuspendedByWowza (line 49)
7	Valt\CamBundle\EventListener\SuspendedMotionDetectionRestorer->__invoke (line 32)
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 129)
12	Valt\CamBundle\Controller\Wowza\SendWowzaStateController->__invoke (line 49)
13	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
14	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
15	Symfony\Component\HttpKernel\Kernel->handle (line 193)
16	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
17	require_once (line 32)
18	require_once (line 5)

0.58 ms
(2.67%)

"START TRANSACTION"

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

"START TRANSACTION"

"START TRANSACTION";

#	File/Call
1	Valt\Shared\Infrastructure\Doctrine\Middleware\TransactionBoundaryConnection->beginTransaction (line 26)
2	Doctrine\DBAL\Connection->beginTransaction (line 1058)
3	Doctrine\ORM\UnitOfWork->commit (line 383)
4	Doctrine\ORM\EntityManager->flush (line 268)
5	Valt\CamBundle\Repository\WowzaRepository->flush (line 53)
6	Valt\CamBundle\Controller\Wowza\SendWowzaStateController->__invoke (line 51)
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 34)
11	require_once (line 32)
12	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
Valt\CamBundle\Entity\Wowza	1
Valt\CamBundle\Entity\Wowza\Routing	1
Valt\CamBundle\Entity\Wowza\Status	1
Valt\CamBundle\Entity\Wowza\Storage	1
Valt\CamBundle\Entity\TranscriptionService	1

Entities Mapping

Class	Mapping errors
Valt\CamBundle\Entity\CallbackSidecar	No errors.
Valt\CamBundle\Entity\Wowza	The field Valt\CamBundle\Entity\Wowza#rooms is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity Valt\CamBundle\Entity\Room#wowza does not contain the required 'inversedBy: "rooms"' attribute. The field Valt\CamBundle\Entity\Wowza#videoLocations is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity Valt\CamBundle\Entity\Record\Video\VideoLocation#wowza does not contain the required 'inversedBy: "videoLocations"' attribute. The field Valt\CamBundle\Entity\Wowza#audioRecordings is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity Valt\CamBundle\Entity\Audio#wowza does not contain the required 'inversedBy: "audioRecordings"' attribute.
Valt\CamBundle\Entity\TranscriptionService	No errors.
Valt\CamBundle\Entity\WowzaSync	No errors.
Valt\CamBundle\Entity\Wowza\Routing	No errors.
Valt\CamBundle\Entity\Wowza\Status	No errors.
Valt\CamBundle\Entity\Wowza\Storage	No errors.
Valt\CamBundle\Entity\Room	The field Valt\CamBundle\Entity\Room#groups is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity Valt\UserBundle\Entity\UserGroup#rooms does not contain the required 'inversedBy: "groups"' attribute.
Valt\CamBundle\Entity\Device\Device	No errors.
Valt\CamBundle\Entity\Record\Video\VideoLocation	No errors.
Valt\CamBundle\Entity\Audio	No errors.
Valt\CamBundle\Entity\TranscriptionService\LocalTranscriptionService	No errors.
Valt\Workload\Domain\Entity\Job	No errors.
Valt\Workload\Domain\Entity\SummarySectionJob	No errors.
Valt\CamBundle\Entity\Room\MotionDetection	No errors.

Symfony Profiler

POST https://ivsdevac3.ipivs.info/wowza/api/sendWowzaState

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping