POST https://ivsdev4.ipivs.com/wowza/api/sendWowzaState

Query Metrics

8 Database Queries
6 Different statements
944.79 ms Query time
2 Invalid entities
5 Managed entities

Queries

Group similar statements

# Time Info
1 0.42 ms
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:
[]
2 0.43 ms
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:
[]
3 0.35 ms
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:
[
  "ivsdev4.ipivs.com"
]
4 0.32 ms
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:
[
  87
]
5 0.11 ms
"START TRANSACTION"
Parameters:
[]
6 0.24 ms
UPDATE wowza_storage SET available_size = ? WHERE id = ?
Parameters:
[
  "60430934016"
  87
]
7 942.35 ms
"COMMIT"
Parameters:
[]
8 0.56 ms
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:
[]

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\TranscriptionService 1
Valt\CamBundle\Entity\Wowza\Routing 1
Valt\CamBundle\Entity\Wowza\Status 1
Valt\CamBundle\Entity\Wowza\Storage 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.