Query Metrics
8
Database Queries
7
Different statements
9.69 ms
Query time
3
Invalid entities
30
Managed entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
2.92 ms (30.14%) |
1 |
SELECT t0.id AS id_1 FROM restrict_access t0 WHERE t0.id = ?
Parameters:
[
790
]
|
||||||||||||||||||||||||||||||||
|
1.72 ms (17.73%) |
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.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:
[] |
||||||||||||||||||||||||||||||||
|
1.27 ms (13.11%) |
2 |
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:
[
662
]
|
||||||||||||||||||||||||||||||||
|
1.25 ms (12.88%) |
1 |
SELECT t0.id AS id_1, t0.provider_type, t0.name AS name_2, t0.aws_access_key_id AS aws_access_key_id_3, t0.aws_secret_key AS aws_secret_key_4, t0.aws_s3_bucket_name AS aws_s3_bucket_name_5, t0.aws_region AS aws_region_6, t0.host_wowza_id AS host_wowza_id_7 FROM transcription_service t0 WHERE t0.id = ? AND t0.provider_type IN ('aws', 'local')
Parameters:
[
14
]
|
||||||||||||||||||||||||||||||||
|
0.94 ms (9.73%) |
1 |
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:
[
255
]
|
||||||||||||||||||||||||||||||||
|
0.85 ms (8.78%) |
1 |
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, t0.expiration_from_id AS expiration_from_id_44, t0.r_access_id AS r_access_id_45 FROM users t0 LEFT JOIN user_email_settings t38 ON t38.user_id = t0.id WHERE t0.id = ? LIMIT 1
Parameters:
[
913
]
|
||||||||||||||||||||||||||||||||
|
0.74 ms (7.64%) |
1 |
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:
[
790
]
|
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 | 7 |
| 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\Template\Domain\Entity\Template | 2 |
| Valt\UserBundle\Entity\User | 1 |
| Valt\UserBundle\Entity\UserGroup | 1 |
| Valt\UserBundle\Entity\UserEmailSettings | 1 |
| Valt\CamBundle\Entity\RetentionRule | 1 |
| Valt\UserBundle\Entity\Container | 1 |
| Valt\CamBundle\Entity\TranscriptionService | 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\LdapSynchronize | No errors. |
| Valt\SsoBundle\Entity\SsoConfig | No errors. |
| Valt\ZoomIntegration\Domain\Entity\Account | No errors. |
| Valt\UserBundle\Entity\UserEmailSettings | No errors. |
| Valt\CamBundle\Entity\Expiration | No errors. |
| Valt\CamBundle\Entity\RestrictAccess | No errors. |
| Valt\CamBundle\Entity\Room |
|
| 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\Template\Domain\Entity\Template | No errors. |
| Valt\CamBundle\Entity\RetentionRule | No errors. |
| Valt\UserBundle\Entity\Container |
|
| Valt\UserBundle\Entity\UserGroupRight | 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\Wowza |
|
| 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\TranscriptionService\LocalTranscriptionService | No errors. |
| Valt\CamBundle\Entity\Record\Video\VideoLocation | No errors. |
| Valt\CamBundle\Entity\Audio | No errors. |