Query Metrics
5
Database Queries
5
Different statements
11.48 ms
Query time
3
Invalid entities
321
Managed entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
4.37 ms (38.09%) |
1 |
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:
[
1
]
|
|
2.00 ms (17.46%) |
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.turn_port AS turn_port_7, t0.address AS address_8, t0.storage_folder AS storage_folder_9, t0.use_ssl AS use_ssl_10, t0.use_s3 AS use_s3_11, t0.is_default AS is_default_12, t0.licensor AS licensor_13, t0.has_gpu AS has_gpu_14, t0.has_llm_vision AS has_llm_vision_15, t0.has_live_asr AS has_live_asr_16, t0.scene_signer_trusted_until AS scene_signer_trusted_until_17, t0.rtmp_username AS rtmp_username_18, t0.rtmp_password AS rtmp_password_19, t0.llm_available AS llm_available_20, t0.llm_signer_trusted_until AS llm_signer_trusted_until_21, t0.dysfluency_available AS dysfluency_available_22, t0.dysfluency_signer_trusted_until AS dysfluency_signer_trusted_until_23, t0.translation_available AS translation_available_24, t0.translation_signer_trusted_until AS translation_signer_trusted_until_25, t0.transcription_service_id AS transcription_service_id_26, t0.sync_id AS sync_id_27, t28.stream AS stream_29, t28.video AS video_30, t28.video_prefix AS video_prefix_31, t28.wowza_id AS wowza_id_32, t33.active AS active_34, t33.wowza_id AS wowza_id_35, t33.storage_id AS storage_id_36 FROM wowza t0 LEFT JOIN wowza_routing t28 ON t28.wowza_id = t0.id LEFT JOIN wowza_status t33 ON t33.wowza_id = t0.id
Parameters:
[] |
|
1.90 ms (16.52%) |
1 |
SELECT r0_.id AS id_0, r0_.name AS name_1, r0_.enabled AS enabled_2 FROM rights r0_ WHERE r0_.enabled = ?
Parameters:
[
1
]
|
|
1.77 ms (15.40%) |
1 |
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:
[
1
]
|
|
1.44 ms (12.54%) |
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:
[
2
]
|
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\Right | 156 |
| Valt\UserBundle\Entity\UserGroupRight | 152 |
| Valt\UserBundle\Entity\User | 1 |
| Valt\UserBundle\Entity\UserEmailSettings | 1 |
| Valt\UserBundle\Entity\UserGroup | 1 |
| Valt\Template\Domain\Entity\Template | 1 |
| Valt\CamBundle\Entity\RetentionRule | 1 |
| Valt\CamBundle\Entity\Expiration | 1 |
| Valt\UserBundle\Entity\Container | 1 |
| Valt\CamBundle\Entity\RestrictAccess | 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\UserGroupRight | No errors. |
| Valt\UserBundle\Entity\Right | No errors. |
| Valt\UserBundle\Entity\LdapSynchronize | No errors. |
| Valt\Sso\Domain\ValueObject\SsoConfigName | No errors. |
| Valt\Sso\Domain\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 |
|
| Valt\CamBundle\Entity\Room |
|
| Valt\CamBundle\Entity\Filter | No errors. |
| Valt\UserBundle\Entity\LogFilter | 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\CallbackSidecar | 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. |