GET https://ivsdev4.ipivs.com/api/valt/checkUserSession

Query Metrics

10 Database Queries
7 Different statements
2.06 ms Query time
3 Invalid entities
29 Managed entities

Queries

Group similar statements

# Time Info
1 0.46 ms
SELECT t0.id AS id_1, t0.username AS username_2, t0.username_canonical AS username_canonical_3, t0.password AS password_4, t0.email AS email_5, t0.email_canonical AS email_canonical_6, t0.enabled AS enabled_7, t0.salt AS salt_8, t0.roles AS roles_9, t0.userType AS userType_10, t0.ldapScript AS ldapScript_11, t0.ldapDomain AS ldapDomain_12, t0.ldapDN AS ldapDN_13, t0.display_name AS display_name_14, t0.card_number AS card_number_15, t0.pin AS pin_16, t0.control_type AS control_type_17, t0.disabled_access AS disabled_access_18, t0.ldap_extra_data AS ldap_extra_data_19, t0.login_failures AS login_failures_20, t0.login_block_start AS login_block_start_21, t0.last_passwords AS last_passwords_22, t0.last_change_password_date AS last_change_password_date_23, t0.night_mode AS night_mode_24, t0.auto_pause_record_when_comment AS auto_pause_record_when_comment_25, t0.auto_play_audio_comments AS auto_play_audio_comments_26, t0.notification_sound AS notification_sound_27, t0.avatar_filename AS avatar_filename_28, t0.avatar_original_filename AS avatar_original_filename_29, t0.emails_alerts_enabled AS emails_alerts_enabled_30, t0.zoom_step AS zoom_step_31, t0.api_token AS api_token_32, t0.deleted_at AS deleted_at_33, t0.group_id AS group_id_34, t0.ldap_sync_id AS ldap_sync_id_35, t0.saml_config_id AS saml_config_id_36, t0.zoom_account_id AS zoom_account_id_37, t38.notifications_enabled AS notifications_enabled_39, t38.notifications_frequency AS notifications_frequency_40, t38.notifications_schedule_enabled AS notifications_schedule_enabled_41, t38.notifications_cron_last_execute AS notifications_cron_last_execute_42, t38.user_id AS user_id_43, t44.created_at AS created_at_45, t44.session_id AS session_id_46, t44.device_id AS device_id_47, t44.user_id AS user_id_48, t0.expiration_from_id AS expiration_from_id_49, t0.r_access_id AS r_access_id_50 FROM users t0 LEFT JOIN user_email_settings t38 ON t38.user_id = t0.id LEFT JOIN session_connection t44 ON t44.user_id = t0.id WHERE t0.id = ? LIMIT 1
Parameters:
[
  21
]
2 0.21 ms
SELECT t0.id AS id_1 FROM restrict_access t0 WHERE t0.id = ?
Parameters:
[
  56
]
3 0.21 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:
[
  56
]
4 0.26 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:
[
  21
]
5 0.16 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 WHERE t0.id = ?
Parameters:
[
  34
]
6 0.15 ms
SELECT t0.id AS id_1 FROM restrict_access t0 WHERE t0.id = ?
Parameters:
[
  55
]
7 0.15 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:
[
  55
]
8 0.13 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:
[
  52
]
9 0.09 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:
[
  51
]
10 0.24 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\RestrictAccessWeekDay 14
Valt\CamBundle\Entity\Expiration 2
Valt\CamBundle\Entity\RestrictAccess 2
Valt\UserBundle\Entity\User 1
Valt\UserBundle\Entity\UserGroup 1
Valt\UserBundle\Entity\UserEmailSettings 1
Valt\CamBundle\Entity\Template 1
Valt\CamBundle\Entity\RetentionRule 1
Valt\UserBundle\Entity\Container 1
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\UserBundle\Entity\User No errors.
Valt\UserBundle\Entity\UserGroup No errors.
Valt\UserBundle\Entity\LdapSynchronize No errors.
Valt\SsoBundle\Entity\SsoConfig No errors.
Valt\UserBundle\Entity\Zoom\Account No errors.
Valt\UserBundle\Entity\UserEmailSettings No errors.
Valt\MobileBundle\Entity\SessionConnection No errors.
Valt\MobileBundle\Entity\Session No errors.
Valt\CamBundle\Entity\Device\MobileDevice\Cue No errors.
Valt\CamBundle\Entity\Expiration No errors.
Valt\CamBundle\Entity\RestrictAccess 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\Filter No errors.
Valt\CamBundle\Entity\Report\Report No errors.
Valt\UserBundle\Entity\UserSection No errors.
Valt\CamBundle\Entity\Evaluation No errors.
Valt\CamBundle\Entity\RestrictAccessWeekDay No errors.
Valt\CamBundle\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\UserBundle\Entity\UserGroupRight No errors.
Valt\CamBundle\Entity\TranscriptionService No errors.
Valt\MobileBundle\Entity\SessionTrack 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.