Symfony Profiler

Query Metrics

8 Database Queries

6 Different statements

11.34 ms Query time

2 Invalid entities

9 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

4.01 ms
(35.37%)

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.address AS address_7, t0.storage_folder AS storage_folder_8, t0.use_ssl AS use_ssl_9, t0.use_s3 AS use_s3_10, t0.is_default AS is_default_11, t0.licensor AS licensor_12, t0.rtmp_username AS rtmp_username_13, t0.rtmp_password AS rtmp_password_14, t0.transcription_service_id AS transcription_service_id_15, t0.sync_id AS sync_id_16, t17.stream AS stream_18, t17.video AS video_19, t17.video_prefix AS video_prefix_20, t17.wowza_id AS wowza_id_21, t22.active AS active_23, t22.wowza_id AS wowza_id_24, t22.storage_id AS storage_id_25 FROM wowza t0 LEFT JOIN wowza_routing t17 ON t17.wowza_id = t0.id LEFT JOIN wowza_status t22 ON t22.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.address AS address_7,
  t0.storage_folder AS storage_folder_8,
  t0.use_ssl AS use_ssl_9,
  t0.use_s3 AS use_s3_10,
  t0.is_default AS is_default_11,
  t0.licensor AS licensor_12,
  t0.rtmp_username AS rtmp_username_13,
  t0.rtmp_password AS rtmp_password_14,
  t0.transcription_service_id AS transcription_service_id_15,
  t0.sync_id AS sync_id_16,
  t17.stream AS stream_18,
  t17.video AS video_19,
  t17.video_prefix AS video_prefix_20,
  t17.wowza_id AS wowza_id_21,
  t22.active AS active_23,
  t22.wowza_id AS wowza_id_24,
  t22.storage_id AS storage_id_25
FROM
  wowza t0
  LEFT JOIN wowza_routing t17 ON t17.wowza_id = t0.id
  LEFT JOIN wowza_status t22 ON t22.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.address AS address_7, t0.storage_folder AS storage_folder_8, t0.use_ssl AS use_ssl_9, t0.use_s3 AS use_s3_10, t0.is_default AS is_default_11, t0.licensor AS licensor_12, t0.rtmp_username AS rtmp_username_13, t0.rtmp_password AS rtmp_password_14, t0.transcription_service_id AS transcription_service_id_15, t0.sync_id AS sync_id_16, t17.stream AS stream_18, t17.video AS video_19, t17.video_prefix AS video_prefix_20, t17.wowza_id AS wowza_id_21, t22.active AS active_23, t22.wowza_id AS wowza_id_24, t22.storage_id AS storage_id_25 FROM wowza t0 LEFT JOIN wowza_routing t17 ON t17.wowza_id = t0.id LEFT JOIN wowza_status t22 ON t22.wowza_id = t0.id;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 963)
2	Doctrine\ORM\EntityRepository->findBy (line 110)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 73)
4	Doctrine\ORM\EntityRepository->findAll (line 96)
5	Valt\BasicBundle\Security\Token\Verifier\Claim\IssuerCheckerFactory->getWowzaAddresses (line 26)
6	Valt\BasicBundle\Security\Token\Verifier\Claim\IssuerCheckerFactory->__invoke (line 32)
7	ContainerCn4kpz3\getIssuerCheckerService->do (line 26)
8	ContainerCn4kpz3\Valt_KernelDevDebugContainer::load (line 1022)
9	ContainerCn4kpz3\getSecurity_Authenticator_AccessToken_WowzaApiService->{closure:ContainerCn4kpz3\getSecurity_Authenticator_AccessToken_WowzaApiService::do():49} (line 53)
10	Jose\Component\Checker\ClaimCheckerManager::__construct (line 27)
11	ContainerCn4kpz3\getSecurity_Authenticator_AccessToken_WowzaApiService->do (line 49)
12	ContainerCn4kpz3\Valt_KernelDevDebugContainer::load (line 1022)
13	ContainerCn4kpz3\getSecurity_Authenticator_Manager_WowzaApiService->do (line 25)
14	ContainerCn4kpz3\Valt_KernelDevDebugContainer::load (line 1022)
15	ContainerCn4kpz3\getDebug_Security_Firewall_Authenticator_WowzaApiService->do (line 24)
16	ContainerCn4kpz3\Valt_KernelDevDebugContainer::load (line 1022)
17	ContainerCn4kpz3\getSecurity_Firewall_Map_Context_WowzaApiService->{closure:ContainerCn4kpz3\getSecurity_Firewall_Map_Context_WowzaApiService::do():26} (line 28)
18	Symfony\Component\Security\Http\Firewall::{closure:Symfony\Component\Security\Http\Firewall::onKernelRequest():72} (line 77)
19	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 57)
20	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 95)
21	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 116)
22	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 220)
23	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
24	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 139)
25	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 157)
26	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
27	Symfony\Component\HttpKernel\Kernel->handle (line 197)
28	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
29	require_once (line 29)
30	require_once (line 5)

3.49 ms
(30.74%)

"COMMIT"

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

"COMMIT"

"COMMIT";

#	File/Call
1	Doctrine\DBAL\Connection->commit (line 1454)
2	Doctrine\ORM\UnitOfWork->commit (line 433)
3	Doctrine\ORM\EntityManager->flush (line 268)
4	Valt\CamBundle\Repository\WowzaRepository->flush (line 49)
5	Valt\CamBundle\Controller\Wowza\SendWowzaStateController->__invoke (line 51)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
8	Symfony\Component\HttpKernel\Kernel->handle (line 197)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
10	require_once (line 29)
11	require_once (line 5)

1.30 ms
(11.48%)

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.address AS address_7, t0.storage_folder AS storage_folder_8, t0.use_ssl AS use_ssl_9, t0.use_s3 AS use_s3_10, t0.is_default AS is_default_11, t0.licensor AS licensor_12, t0.rtmp_username AS rtmp_username_13, t0.rtmp_password AS rtmp_password_14, t0.transcription_service_id AS transcription_service_id_15, t0.sync_id AS sync_id_16, t17.stream AS stream_18, t17.video AS video_19, t17.video_prefix AS video_prefix_20, t17.wowza_id AS wowza_id_21, t22.active AS active_23, t22.wowza_id AS wowza_id_24, t22.storage_id AS storage_id_25 FROM wowza t0 LEFT JOIN wowza_routing t17 ON t17.wowza_id = t0.id LEFT JOIN wowza_status t22 ON t22.wowza_id = t0.id WHERE t0.address = ? LIMIT 1

Parameters:

[
  "dev-wowza.valt.forasoft.com"
]

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.address AS address_7,
  t0.storage_folder AS storage_folder_8,
  t0.use_ssl AS use_ssl_9,
  t0.use_s3 AS use_s3_10,
  t0.is_default AS is_default_11,
  t0.licensor AS licensor_12,
  t0.rtmp_username AS rtmp_username_13,
  t0.rtmp_password AS rtmp_password_14,
  t0.transcription_service_id AS transcription_service_id_15,
  t0.sync_id AS sync_id_16,
  t17.stream AS stream_18,
  t17.video AS video_19,
  t17.video_prefix AS video_prefix_20,
  t17.wowza_id AS wowza_id_21,
  t22.active AS active_23,
  t22.wowza_id AS wowza_id_24,
  t22.storage_id AS storage_id_25
FROM
  wowza t0
  LEFT JOIN wowza_routing t17 ON t17.wowza_id = t0.id
  LEFT JOIN wowza_status t22 ON t22.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.address AS address_7, t0.storage_folder AS storage_folder_8, t0.use_ssl AS use_ssl_9, t0.use_s3 AS use_s3_10, t0.is_default AS is_default_11, t0.licensor AS licensor_12, t0.rtmp_username AS rtmp_username_13, t0.rtmp_password AS rtmp_password_14, t0.transcription_service_id AS transcription_service_id_15, t0.sync_id AS sync_id_16, t17.stream AS stream_18, t17.video AS video_19, t17.video_prefix AS video_prefix_20, t17.wowza_id AS wowza_id_21, t22.active AS active_23, t22.wowza_id AS wowza_id_24, t22.storage_id AS storage_id_25 FROM wowza t0 LEFT JOIN wowza_routing t17 ON t17.wowza_id = t0.id LEFT JOIN wowza_status t22 ON t22.wowza_id = t0.id WHERE t0.address = 'dev-wowza.valt.forasoft.com' 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\ServiceEntityRepositoryProxy->findOneBy (line 81)
4	Symfony\Bridge\Doctrine\Security\User\EntityUserProvider->loadUserByIdentifier (line 57)
5	Symfony\Component\Security\Http\Authenticator\Passport\Badge\UserBadge->getUser (line 89)
6	Symfony\Component\Security\Http\Authenticator\Passport\Passport->getUser (line 56)
7	Symfony\Component\Security\Http\EventListener\UserCheckerListener->preCheckCredentials (line 42)
8	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 116)
9	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 220)
10	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
11	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 139)
12	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticator (line 180)
13	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticators (line 158)
14	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->authenticateRequest (line 140)
15	Symfony\Component\Security\Http\Firewall\AuthenticatorManagerListener->authenticate (line 40)
16	Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticatorManagerListener->authenticate (line 68)
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 83)
20	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 95)
21	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 116)
22	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 220)
23	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
24	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 139)
25	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 157)
26	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
27	Symfony\Component\HttpKernel\Kernel->handle (line 197)
28	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
29	require_once (line 29)
30	require_once (line 5)

1.08 ms
(9.53%)

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:

[
  3001
]

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 = 3001;

#	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 49)
5	Valt\CamBundle\Entity\Wowza\Status->activate (line 58)
6	Valt\CamBundle\Entity\Wowza->markActive (line 485)
7	Valt\CamBundle\Controller\Wowza\SendWowzaStateController->__invoke (line 42)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 197)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
12	require_once (line 29)
13	require_once (line 5)

0.92 ms
(8.15%)

UPDATE wowza_storage SET available_size = ? WHERE id = ?

Parameters:

[
  "25632280576"
  3001
]

View formatted query View runnable query Explain query View query backtrace

UPDATE
  wowza_storage
SET
  available_size = ?
WHERE
  id = ?

UPDATE wowza_storage SET available_size = '25632280576' WHERE id = 3001;

#	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	Valt\CamBundle\Repository\WowzaRepository->flush (line 49)
7	Valt\CamBundle\Controller\Wowza\SendWowzaStateController->__invoke (line 51)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 197)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
12	require_once (line 29)
13	require_once (line 5)

0.54 ms
(4.73%)

"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	Valt\CamBundle\Repository\WowzaRepository->flush (line 49)
4	Valt\CamBundle\Controller\Wowza\SendWowzaStateController->__invoke (line 51)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
7	Symfony\Component\HttpKernel\Kernel->handle (line 197)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
9	require_once (line 29)
10	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	2
Valt\CamBundle\Entity\Wowza\Routing	2
Valt\CamBundle\Entity\Wowza\Status	2
Valt\CamBundle\Entity\TranscriptionService	1
Valt\CamBundle\Entity\Wowza\Storage	1
Valt\CamBundle\Entity\WowzaSync	1

Entities Mapping

Class	Mapping 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.

Symfony Profiler

POST https://dev.valt.forasoft.com/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