POST https://dev.valt.forasoft.com/api/room/549/view/update/1994114

Query Metrics

13 Database Queries
12 Different statements
77.49 ms Query time
3 Invalid entities
315 Managed entities

Queries

Group similar statements

# Time Info
1 2.12 ms
SELECT u0_.id AS id_0, u0_.username AS username_1, u0_.username_canonical AS username_canonical_2, u0_.password AS password_3, u0_.email AS email_4, u0_.email_canonical AS email_canonical_5, u0_.enabled AS enabled_6, u0_.salt AS salt_7, u0_.roles AS roles_8, u0_.userType AS userType_9, u0_.ldapScript AS ldapScript_10, u0_.ldapDomain AS ldapDomain_11, u0_.ldapDN AS ldapDN_12, u0_.display_name AS display_name_13, u0_.card_number AS card_number_14, u0_.pin AS pin_15, u0_.control_type AS control_type_16, u0_.disabled_access AS disabled_access_17, u0_.ldap_extra_data AS ldap_extra_data_18, u0_.login_failures AS login_failures_19, u0_.login_block_start AS login_block_start_20, u0_.last_passwords AS last_passwords_21, u0_.last_change_password_date AS last_change_password_date_22, u0_.night_mode AS night_mode_23, u0_.auto_pause_record_when_comment AS auto_pause_record_when_comment_24, u0_.auto_play_audio_comments AS auto_play_audio_comments_25, u0_.notification_sound AS notification_sound_26, u0_.avatar_filename AS avatar_filename_27, u0_.avatar_original_filename AS avatar_original_filename_28, u0_.emails_alerts_enabled AS emails_alerts_enabled_29, u0_.zoom_step AS zoom_step_30, u0_.api_token AS api_token_31, u0_.deleted_at AS deleted_at_32, u1_.id AS id_33, u1_.name AS name_34, u1_.record_duration AS record_duration_35, u1_.record_duration_selection_type AS record_duration_selection_type_36, u1_.io_record_name AS io_record_name_37, u1_.search_results AS search_results_38, u1_.room_sorting_order AS room_sorting_order_39, u1_.disabled_access AS disabled_access_40, u1_.default_review_view AS default_review_view_41, u1_.default_schedule_view AS default_schedule_view_42, u1_.default_report_view AS default_report_view_43, u1_.default_review_list_period AS default_review_list_period_44, u1_.deleted_users_video_access AS deleted_users_video_access_45, u1_.without_groups_users_video_access AS without_groups_users_video_access_46, u1_.deleted_at AS deleted_at_47, u2_.id AS id_48, r3_.id AS id_49, r3_.name AS name_50, r3_.enabled AS enabled_51, u0_.group_id AS group_id_52, u0_.ldap_sync_id AS ldap_sync_id_53, u0_.saml_config_id AS saml_config_id_54, u0_.zoom_account_id AS zoom_account_id_55, u0_.expiration_from_id AS expiration_from_id_56, u0_.r_access_id AS r_access_id_57, u1_.comment_template_id AS comment_template_id_58, u1_.marker_template_id AS marker_template_id_59, u1_.info_template_id AS info_template_id_60, u1_.evaluation_template_id AS evaluation_template_id_61, u1_.default_retention_rule_id AS default_retention_rule_id_62, u1_.expiration_from_id AS expiration_from_id_63, u1_.container_id AS container_id_64, u1_.r_access_id AS r_access_id_65, u2_.user_group_id AS user_group_id_66, u2_.right_id AS right_id_67 FROM users u0_ LEFT JOIN user_groups u1_ ON u0_.group_id = u1_.id LEFT JOIN user_groups_rights u2_ ON u1_.id = u2_.user_group_id LEFT JOIN rights r3_ ON u2_.right_id = r3_.id WHERE u0_.id = ?
Parameters:
[
  911
]
2 29.35 ms
SELECT t0.notifications_enabled AS notifications_enabled_1, t0.notifications_frequency AS notifications_frequency_2, t0.notifications_schedule_enabled AS notifications_schedule_enabled_3, t0.notifications_cron_last_execute AS notifications_cron_last_execute_4, t0.user_id AS user_id_5 FROM user_email_settings t0 WHERE t0.user_id = ?
Parameters:
[
  911
]
3 0.86 ms
SELECT t0.id AS id_1 FROM restrict_access t0 WHERE t0.id = ?
Parameters:
[
  785
]
4 1.33 ms
SELECT t0.id AS id_1, t0.week_day AS week_day_2, t0.enabled AS enabled_3, t0.start_time AS start_time_4, t0.end_time AS end_time_5, t0.full_day AS full_day_6, t0.r_access_id AS r_access_id_7 FROM restrict_access_week_day t0 WHERE t0.r_access_id = ?
Parameters:
[
  785
]
5 0.74 ms
SELECT t0.id AS id_1, t0.type AS type_2, t0.expiration_from AS expiration_from_3 FROM expiration t0 WHERE t0.id = ?
Parameters:
[
  657
]
6 0.49 ms
SELECT t0.id AS id_1, t0.type AS type_2, t0.expiration_from AS expiration_from_3 FROM expiration t0 WHERE t0.id = ?
Parameters:
[
  658
]
7 0.77 ms
SELECT t0.id AS id_1, t0.object_type AS object_type_2, t0.object_id AS object_id_3, t0.action AS action_4, t0.action_date AS action_date_5, t0.end_action_date AS end_action_date_6, t0.object_name AS object_name_7, t0.extra_information AS extra_information_8, t0.user_id AS user_id_9, t0.container_id AS container_id_10 FROM log t0 WHERE t0.id = ?
Parameters:
[
  "1994114"
]
8 0.87 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.record_duration AS record_duration_3, t0.record_duration_selection_type AS record_duration_selection_type_4, t0.io_record_name AS io_record_name_5, t0.search_results AS search_results_6, t0.room_sorting_order AS room_sorting_order_7, t0.disabled_access AS disabled_access_8, t0.default_review_view AS default_review_view_9, t0.default_schedule_view AS default_schedule_view_10, t0.default_report_view AS default_report_view_11, t0.default_review_list_period AS default_review_list_period_12, t0.deleted_users_video_access AS deleted_users_video_access_13, t0.without_groups_users_video_access AS without_groups_users_video_access_14, t0.deleted_at AS deleted_at_15, t0.comment_template_id AS comment_template_id_16, t0.marker_template_id AS marker_template_id_17, t0.info_template_id AS info_template_id_18, t0.evaluation_template_id AS evaluation_template_id_19, t0.default_retention_rule_id AS default_retention_rule_id_20, t0.expiration_from_id AS expiration_from_id_21, t0.container_id AS container_id_22, t0.r_access_id AS r_access_id_23 FROM user_groups t0 INNER JOIN additional_user_groups ON t0.id = additional_user_groups.group_id WHERE additional_user_groups.user_id = ?
Parameters:
[
  911
]
9 0.57 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.c_id AS c_id_3 FROM container t0 WHERE t0.id = ?
Parameters:
[
  1
]
10 0.74 ms
"START TRANSACTION"
Parameters:
[]
11 34.95 ms
UPDATE log SET end_action_date = ? WHERE id = ?
Parameters:
[
  "2026-09-07 17:27:49"
  1994114
]
12 3.67 ms
"COMMIT"
Parameters:
[]
13 1.04 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.has_gpu AS has_gpu_13, t0.rtmp_username AS rtmp_username_14, t0.rtmp_password AS rtmp_password_15, t0.transcription_service_id AS transcription_service_id_16, t0.sync_id AS sync_id_17, t18.stream AS stream_19, t18.video AS video_20, t18.video_prefix AS video_prefix_21, t18.wowza_id AS wowza_id_22, t23.active AS active_24, t23.wowza_id AS wowza_id_25, t23.storage_id AS storage_id_26 FROM wowza t0 LEFT JOIN wowza_routing t18 ON t18.wowza_id = t0.id LEFT JOIN wowza_status t23 ON t23.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\UserBundle\Entity\UserGroupRight 142
Valt\UserBundle\Entity\Right 142
Valt\CamBundle\Entity\RestrictAccessWeekDay 7
Valt\Template\Domain\Entity\Template 3
Valt\CamBundle\Entity\Wowza 3
Valt\CamBundle\Entity\Wowza\Routing 3
Valt\CamBundle\Entity\Wowza\Status 3
Valt\CamBundle\Entity\Expiration 2
Valt\CamBundle\Entity\RestrictAccess 2
Valt\UserBundle\Entity\User 1
Valt\UserBundle\Entity\UserEmailSettings 1
Valt\UserBundle\Entity\UserGroup 1
Valt\CamBundle\Entity\RetentionRule 1
Valt\UserBundle\Entity\Container 1
Valt\UserBundle\Entity\Log 1
Valt\CamBundle\Entity\Wowza\Storage 1
Valt\CamBundle\Entity\WowzaSync 1

Entities Mapping

Class Mapping errors
Valt\UserBundle\Entity\User No errors.
Valt\UserBundle\Entity\UserGroup No errors.
Valt\UserBundle\Entity\UserGroupRight No errors.
Valt\UserBundle\Entity\Right No errors.
Valt\UserBundle\Entity\LdapSynchronize No errors.
Valt\SsoBundle\Entity\SsoConfig No errors.
Valt\ZoomIntegration\Domain\Entity\Account No errors.
Valt\CamBundle\Entity\Expiration No errors.
Valt\CamBundle\Entity\RestrictAccess No errors.
Valt\Template\Domain\Entity\Template No errors.
Valt\CamBundle\Entity\RetentionRule No errors.
Valt\UserBundle\Entity\Container
  • The field Valt\UserBundle\Entity\Container#userGroups is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity Valt\UserBundle\Entity\UserGroup#container does not contain the required 'inversedBy: "userGroups"' attribute.
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\Filter No errors.
Valt\CamBundle\Entity\Report\Report No errors.
Valt\UserBundle\Entity\UserSection No errors.
Valt\UserBundle\Entity\UserEmailSettings No errors.
Valt\CamBundle\Entity\Evaluation No errors.
Valt\CamBundle\Entity\TranscriptionService No errors.
Valt\CamBundle\Entity\TranscriptionService\AwsTranscriptionService No errors.
Valt\Cue\Session\Domain\Entity\SessionTrackCode No errors.
Valt\Cue\Session\Domain\Entity\SessionTrack No errors.
Valt\CamBundle\Entity\RestrictAccessWeekDay No errors.
Valt\UserBundle\Entity\Log 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\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\Device\Device No errors.
Valt\CamBundle\Entity\Record\Video\VideoLocation No errors.
Valt\CamBundle\Entity\Audio No errors.