GET https://dev.valt.forasoft.com/api/circuit/list

Query Metrics

149 Database Queries
11 Different statements
108.79 ms Query time
3 Invalid entities
308 Managed entities

Queries

Group similar statements

# Time Info
1 1.00 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, 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:
[
  911
]
2 0.68 ms
SELECT t0.id AS id_1 FROM restrict_access t0 WHERE t0.id = ?
Parameters:
[
  785
]
3 0.68 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
]
4 0.57 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
]
5 1.39 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:
[
  253
]
6 1.06 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 8.12 ms
SELECT t0.id AS id_1, t0.user_group_id AS user_group_id_2, t0.right_id AS right_id_3 FROM user_groups_rights t0 WHERE t0.user_group_id = ?
Parameters:
[
  253
]
8 0.84 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.enabled AS enabled_3 FROM rights t0 WHERE t0.id = ?
Parameters:
[
  1
]
9 0.60 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.enabled AS enabled_3 FROM rights t0 WHERE t0.id = ?
Parameters:
[
  2
]
10 0.48 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.enabled AS enabled_3 FROM rights t0 WHERE t0.id = ?
Parameters:
[
  3
]
11 0.44 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.enabled AS enabled_3 FROM rights t0 WHERE t0.id = ?
Parameters:
[
  4
]
12 0.39 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.enabled AS enabled_3 FROM rights t0 WHERE t0.id = ?
Parameters:
[
  5
]
13 0.44 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.enabled AS enabled_3 FROM rights t0 WHERE t0.id = ?
Parameters:
[
  6
]
14 0.39 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.enabled AS enabled_3 FROM rights t0 WHERE t0.id = ?
Parameters:
[
  8
]
15 0.36 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.enabled AS enabled_3 FROM rights t0 WHERE t0.id = ?
Parameters:
[
  9
]
16 0.46 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.enabled AS enabled_3 FROM rights t0 WHERE t0.id = ?
Parameters:
[
  10
]
17 0.46 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.enabled AS enabled_3 FROM rights t0 WHERE t0.id = ?
Parameters:
[
  12
]
18 0.46 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.enabled AS enabled_3 FROM rights t0 WHERE t0.id = ?
Parameters:
[
  15
]
19 0.46 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.enabled AS enabled_3 FROM rights t0 WHERE t0.id = ?
Parameters:
[
  16
]
20 0.47 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.enabled AS enabled_3 FROM rights t0 WHERE t0.id = ?
Parameters:
[
  17
]
21 0.48 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.enabled AS enabled_3 FROM rights t0 WHERE t0.id = ?
Parameters:
[
  18
]
22 0.61 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.enabled AS enabled_3 FROM rights t0 WHERE t0.id = ?
Parameters:
[
  19
]
23 0.57 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.enabled AS enabled_3 FROM rights t0 WHERE t0.id = ?
Parameters:
[
  20
]
24 0.46 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.enabled AS enabled_3 FROM rights t0 WHERE t0.id = ?
Parameters:
[
  22
]
25 0.63 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.enabled AS enabled_3 FROM rights t0 WHERE t0.id = ?
Parameters:
[
  23
]
26 0.44 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.enabled AS enabled_3 FROM rights t0 WHERE t0.id = ?
Parameters:
[
  25
]
27 0.60 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.enabled AS enabled_3 FROM rights t0 WHERE t0.id = ?
Parameters:
[
  26
]
28 0.44 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.enabled AS enabled_3 FROM rights t0 WHERE t0.id = ?
Parameters:
[
  27
]
29 0.41 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.enabled AS enabled_3 FROM rights t0 WHERE t0.id = ?
Parameters:
[
  28
]
30 0.48 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.enabled AS enabled_3 FROM rights t0 WHERE t0.id = ?
Parameters:
[
  29
]
31 0.68 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.enabled AS enabled_3 FROM rights t0 WHERE t0.id = ?
Parameters:
[
  30
]
32 0.45 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.enabled AS enabled_3 FROM rights t0 WHERE t0.id = ?
Parameters:
[
  32
]
33 0.45 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.enabled AS enabled_3 FROM rights t0 WHERE t0.id = ?
Parameters:
[
  34
]
34 0.49 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.enabled AS enabled_3 FROM rights t0 WHERE t0.id = ?
Parameters:
[
  35
]
35 0.44 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.enabled AS enabled_3 FROM rights t0 WHERE t0.id = ?
Parameters:
[
  36
]
36 0.56 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.enabled AS enabled_3 FROM rights t0 WHERE t0.id = ?
Parameters:
[
  37
]
37 0.32 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.enabled AS enabled_3 FROM rights t0 WHERE t0.id = ?
Parameters:
[
  38
]
38 0.37 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.enabled AS enabled_3 FROM rights t0 WHERE t0.id = ?
Parameters:
[
  39
]
39 0.46 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.enabled AS enabled_3 FROM rights t0 WHERE t0.id = ?
Parameters:
[
  40
]
40 0.37 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.enabled AS enabled_3 FROM rights t0 WHERE t0.id = ?
Parameters:
[
  42
]
41 0.38 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.enabled AS enabled_3 FROM rights t0 WHERE t0.id = ?
Parameters:
[
  45
]
42 0.45 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.enabled AS enabled_3 FROM rights t0 WHERE t0.id = ?
Parameters:
[
  46
]
43 0.38 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.enabled AS enabled_3 FROM rights t0 WHERE t0.id = ?
Parameters:
[
  47
]
44 0.39 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.enabled AS enabled_3 FROM rights t0 WHERE t0.id = ?
Parameters:
[
  48
]
45 0.49 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.enabled AS enabled_3 FROM rights t0 WHERE t0.id = ?
Parameters:
[
  49
]
46 0.44 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.enabled AS enabled_3 FROM rights t0 WHERE t0.id = ?
Parameters:
[
  50
]
47 0.48 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.enabled AS enabled_3 FROM rights t0 WHERE t0.id = ?
Parameters:
[
  52
]
48 0.36 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.enabled AS enabled_3 FROM rights t0 WHERE t0.id = ?
Parameters:
[
  53
]
49 0.45 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.enabled AS enabled_3 FROM rights t0 WHERE t0.id = ?
Parameters:
[
  54
]
50 0.31 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.enabled AS enabled_3 FROM rights t0 WHERE t0.id = ?
Parameters:
[
  55
]
51 0.41 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.enabled AS enabled_3 FROM rights t0 WHERE t0.id = ?
Parameters:
[
  62
]
52 0.32 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.enabled AS enabled_3 FROM rights t0 WHERE t0.id = ?
Parameters:
[
  63
]
53 0.32 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.enabled AS enabled_3 FROM rights t0 WHERE t0.id = ?
Parameters:
[
  64
]
54 0.31 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.enabled AS enabled_3 FROM rights t0 WHERE t0.id = ?
Parameters:
[
  65
]
55 0.36 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.enabled AS enabled_3 FROM rights t0 WHERE t0.id = ?
Parameters:
[
  67
]
56 0.51 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.enabled AS enabled_3 FROM rights t0 WHERE t0.id = ?
Parameters:
[
  68
]
57 0.36 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.enabled AS enabled_3 FROM rights t0 WHERE t0.id = ?
Parameters:
[
  69
]
58 0.44 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.enabled AS enabled_3 FROM rights t0 WHERE t0.id = ?
Parameters:
[
  70
]
59 0.50 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.enabled AS enabled_3 FROM rights t0 WHERE t0.id = ?
Parameters:
[
  72
]
60 0.41 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.enabled AS enabled_3 FROM rights t0 WHERE t0.id = ?
Parameters:
[
  73
]
61 0.42 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.enabled AS enabled_3 FROM rights t0 WHERE t0.id = ?
Parameters:
[
  74
]
62 0.42 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.enabled AS enabled_3 FROM rights t0 WHERE t0.id = ?
Parameters:
[
  75
]
63 0.34 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.enabled AS enabled_3 FROM rights t0 WHERE t0.id = ?
Parameters:
[
  76
]
64 0.32 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.enabled AS enabled_3 FROM rights t0 WHERE t0.id = ?
Parameters:
[
  77
]
65 0.43 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.enabled AS enabled_3 FROM rights t0 WHERE t0.id = ?
Parameters:
[
  78
]
66 0.48 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.enabled AS enabled_3 FROM rights t0 WHERE t0.id = ?
Parameters:
[
  79
]
67 0.37 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.enabled AS enabled_3 FROM rights t0 WHERE t0.id = ?
Parameters:
[
  80
]
68 0.43 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.enabled AS enabled_3 FROM rights t0 WHERE t0.id = ?
Parameters:
[
  82
]
69 0.36 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.enabled AS enabled_3 FROM rights t0 WHERE t0.id = ?
Parameters:
[
  83
]
70 0.33 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.enabled AS enabled_3 FROM rights t0 WHERE t0.id = ?
Parameters:
[
  84
]
71 0.36 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.enabled AS enabled_3 FROM rights t0 WHERE t0.id = ?
Parameters:
[
  85
]
72 0.39 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.enabled AS enabled_3 FROM rights t0 WHERE t0.id = ?
Parameters:
[
  86
]
73 0.33 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.enabled AS enabled_3 FROM rights t0 WHERE t0.id = ?
Parameters:
[
  87
]
74 0.35 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.enabled AS enabled_3 FROM rights t0 WHERE t0.id = ?
Parameters:
[
  88
]
75 0.57 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.enabled AS enabled_3 FROM rights t0 WHERE t0.id = ?
Parameters:
[
  90
]
76 0.49 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.enabled AS enabled_3 FROM rights t0 WHERE t0.id = ?
Parameters:
[
  92
]
77 0.68 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.enabled AS enabled_3 FROM rights t0 WHERE t0.id = ?
Parameters:
[
  93
]
78 0.61 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.enabled AS enabled_3 FROM rights t0 WHERE t0.id = ?
Parameters:
[
  94
]
79 0.53 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.enabled AS enabled_3 FROM rights t0 WHERE t0.id = ?
Parameters:
[
  95
]
80 0.43 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.enabled AS enabled_3 FROM rights t0 WHERE t0.id = ?
Parameters:
[
  96
]
81 0.43 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.enabled AS enabled_3 FROM rights t0 WHERE t0.id = ?
Parameters:
[
  97
]
82 0.37 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.enabled AS enabled_3 FROM rights t0 WHERE t0.id = ?
Parameters:
[
  98
]
83 0.44 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.enabled AS enabled_3 FROM rights t0 WHERE t0.id = ?
Parameters:
[
  99
]
84 0.37 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.enabled AS enabled_3 FROM rights t0 WHERE t0.id = ?
Parameters:
[
  101
]
85 0.70 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.enabled AS enabled_3 FROM rights t0 WHERE t0.id = ?
Parameters:
[
  102
]
86 0.43 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.enabled AS enabled_3 FROM rights t0 WHERE t0.id = ?
Parameters:
[
  103
]
87 0.54 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.enabled AS enabled_3 FROM rights t0 WHERE t0.id = ?
Parameters:
[
  104
]
88 0.61 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.enabled AS enabled_3 FROM rights t0 WHERE t0.id = ?
Parameters:
[
  201
]
89 0.99 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.enabled AS enabled_3 FROM rights t0 WHERE t0.id = ?
Parameters:
[
  301
]
90 0.87 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.enabled AS enabled_3 FROM rights t0 WHERE t0.id = ?
Parameters:
[
  401
]
91 0.95 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.enabled AS enabled_3 FROM rights t0 WHERE t0.id = ?
Parameters:
[
  501
]
92 0.61 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.enabled AS enabled_3 FROM rights t0 WHERE t0.id = ?
Parameters:
[
  701
]
93 0.55 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.enabled AS enabled_3 FROM rights t0 WHERE t0.id = ?
Parameters:
[
  801
]
94 0.56 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.enabled AS enabled_3 FROM rights t0 WHERE t0.id = ?
Parameters:
[
  1001
]
95 0.48 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.enabled AS enabled_3 FROM rights t0 WHERE t0.id = ?
Parameters:
[
  1032
]
96 0.66 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.enabled AS enabled_3 FROM rights t0 WHERE t0.id = ?
Parameters:
[
  1041
]
97 0.77 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.enabled AS enabled_3 FROM rights t0 WHERE t0.id = ?
Parameters:
[
  1042
]
98 0.59 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.enabled AS enabled_3 FROM rights t0 WHERE t0.id = ?
Parameters:
[
  1043
]
99 0.46 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.enabled AS enabled_3 FROM rights t0 WHERE t0.id = ?
Parameters:
[
  1044
]
100 0.58 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.enabled AS enabled_3 FROM rights t0 WHERE t0.id = ?
Parameters:
[
  1045
]
101 0.57 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.enabled AS enabled_3 FROM rights t0 WHERE t0.id = ?
Parameters:
[
  1046
]
102 1.00 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.enabled AS enabled_3 FROM rights t0 WHERE t0.id = ?
Parameters:
[
  1047
]
103 0.85 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.enabled AS enabled_3 FROM rights t0 WHERE t0.id = ?
Parameters:
[
  1048
]
104 0.93 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.enabled AS enabled_3 FROM rights t0 WHERE t0.id = ?
Parameters:
[
  1049
]
105 0.98 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.enabled AS enabled_3 FROM rights t0 WHERE t0.id = ?
Parameters:
[
  1050
]
106 1.03 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.enabled AS enabled_3 FROM rights t0 WHERE t0.id = ?
Parameters:
[
  1051
]
107 1.09 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.enabled AS enabled_3 FROM rights t0 WHERE t0.id = ?
Parameters:
[
  1052
]
108 0.85 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.enabled AS enabled_3 FROM rights t0 WHERE t0.id = ?
Parameters:
[
  1053
]
109 0.72 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.enabled AS enabled_3 FROM rights t0 WHERE t0.id = ?
Parameters:
[
  1054
]
110 0.61 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.enabled AS enabled_3 FROM rights t0 WHERE t0.id = ?
Parameters:
[
  1055
]
111 0.56 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.enabled AS enabled_3 FROM rights t0 WHERE t0.id = ?
Parameters:
[
  1056
]
112 0.72 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.enabled AS enabled_3 FROM rights t0 WHERE t0.id = ?
Parameters:
[
  1057
]
113 0.73 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.enabled AS enabled_3 FROM rights t0 WHERE t0.id = ?
Parameters:
[
  1058
]
114 0.81 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.enabled AS enabled_3 FROM rights t0 WHERE t0.id = ?
Parameters:
[
  1059
]
115 0.76 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.enabled AS enabled_3 FROM rights t0 WHERE t0.id = ?
Parameters:
[
  1060
]
116 0.74 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.enabled AS enabled_3 FROM rights t0 WHERE t0.id = ?
Parameters:
[
  1061
]
117 0.70 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.enabled AS enabled_3 FROM rights t0 WHERE t0.id = ?
Parameters:
[
  1062
]
118 0.61 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.enabled AS enabled_3 FROM rights t0 WHERE t0.id = ?
Parameters:
[
  1063
]
119 0.52 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.enabled AS enabled_3 FROM rights t0 WHERE t0.id = ?
Parameters:
[
  1064
]
120 0.49 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.enabled AS enabled_3 FROM rights t0 WHERE t0.id = ?
Parameters:
[
  1065
]
121 0.71 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.enabled AS enabled_3 FROM rights t0 WHERE t0.id = ?
Parameters:
[
  1066
]
122 0.52 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.enabled AS enabled_3 FROM rights t0 WHERE t0.id = ?
Parameters:
[
  1067
]
123 0.63 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.enabled AS enabled_3 FROM rights t0 WHERE t0.id = ?
Parameters:
[
  1068
]
124 0.44 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.enabled AS enabled_3 FROM rights t0 WHERE t0.id = ?
Parameters:
[
  1069
]
125 0.44 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.enabled AS enabled_3 FROM rights t0 WHERE t0.id = ?
Parameters:
[
  1070
]
126 0.43 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.enabled AS enabled_3 FROM rights t0 WHERE t0.id = ?
Parameters:
[
  1071
]
127 0.42 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.enabled AS enabled_3 FROM rights t0 WHERE t0.id = ?
Parameters:
[
  1072
]
128 0.38 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.enabled AS enabled_3 FROM rights t0 WHERE t0.id = ?
Parameters:
[
  1073
]
129 0.42 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.enabled AS enabled_3 FROM rights t0 WHERE t0.id = ?
Parameters:
[
  1077
]
130 0.38 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.enabled AS enabled_3 FROM rights t0 WHERE t0.id = ?
Parameters:
[
  1078
]
131 0.38 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.enabled AS enabled_3 FROM rights t0 WHERE t0.id = ?
Parameters:
[
  1079
]
132 0.44 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.enabled AS enabled_3 FROM rights t0 WHERE t0.id = ?
Parameters:
[
  1080
]
133 0.46 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.enabled AS enabled_3 FROM rights t0 WHERE t0.id = ?
Parameters:
[
  1081
]
134 0.46 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.enabled AS enabled_3 FROM rights t0 WHERE t0.id = ?
Parameters:
[
  1082
]
135 0.43 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.enabled AS enabled_3 FROM rights t0 WHERE t0.id = ?
Parameters:
[
  1083
]
136 0.40 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.enabled AS enabled_3 FROM rights t0 WHERE t0.id = ?
Parameters:
[
  1084
]
137 0.57 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.enabled AS enabled_3 FROM rights t0 WHERE t0.id = ?
Parameters:
[
  1085
]
138 0.51 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.enabled AS enabled_3 FROM rights t0 WHERE t0.id = ?
Parameters:
[
  1086
]
139 0.41 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.enabled AS enabled_3 FROM rights t0 WHERE t0.id = ?
Parameters:
[
  1087
]
140 0.48 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.enabled AS enabled_3 FROM rights t0 WHERE t0.id = ?
Parameters:
[
  1088
]
141 0.45 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.enabled AS enabled_3 FROM rights t0 WHERE t0.id = ?
Parameters:
[
  1089
]
142 0.38 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.enabled AS enabled_3 FROM rights t0 WHERE t0.id = ?
Parameters:
[
  1090
]
143 0.62 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.enabled AS enabled_3 FROM rights t0 WHERE t0.id = ?
Parameters:
[
  1091
]
144 0.57 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.enabled AS enabled_3 FROM rights t0 WHERE t0.id = ?
Parameters:
[
  1092
]
145 0.47 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.enabled AS enabled_3 FROM rights t0 WHERE t0.id = ?
Parameters:
[
  1093
]
146 16.73 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3 FROM circuit t0
Parameters:
[]
147 5.11 ms
SELECT t0.id AS id_1, t0.ordinal AS ordinal_2, t0.circuit_id AS circuit_id_3, t0.room_id AS room_id_4 FROM circuit_room t0 WHERE t0.circuit_id = ? ORDER BY t0.ordinal ASC
Parameters:
[
  "01978538-9280-71bf-a273-6b011327c4a0"
]
148 0.89 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:
[]
149 0.89 ms
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
]

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 138
Valt\UserBundle\Entity\Right 138
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\UserGroup 1
Valt\UserBundle\Entity\UserEmailSettings 1
Valt\CamBundle\Entity\RetentionRule 1
Valt\UserBundle\Entity\Container 1
Valt\Cue\Circuit\Domain\Entity\Circuit 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
  • 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\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\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\UserBundle\Entity\Right No errors.
Valt\Cue\Circuit\Domain\Entity\Circuit No errors.
Valt\Cue\Circuit\Domain\Entity\CircuitRoom 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\TranscriptionService\LocalTranscriptionService No errors.
Valt\CamBundle\Entity\Record\Video\VideoLocation No errors.
Valt\CamBundle\Entity\Audio No errors.