POST https://dev.valt.forasoft.com/login_check

Query Metrics

12 Database Queries
10 Different statements
20.38 ms Query time
2 Invalid entities
18 Managed entities

Grouped Statements

Show all queries

Time Count Info
3.41 ms
(16.75%)
1
"COMMIT"
Parameters:
[]
3.34 ms
(16.37%)
1
"START TRANSACTION"
Parameters:
[]
3.01 ms
(14.77%)
2
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.username = ? AND t0.username_canonical = ? AND t0.saml_config_id IS NULL LIMIT 1
Parameters:
[
  "AnKl_user A"
  "AnKl_user A"
]
2.85 ms
(13.97%)
1
INSERT INTO log (user_groups_snapshot, object_type, object_id, action, action_date, end_action_date, object_name, extra_information, user_id, user_group_id, container_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  1
  "User"
  "951"
  "Logged from ip = 89.37.185.230"
  "2026-09-21 14:08:25"
  null
  "AnKl_user A"
  "username = AnKl_user A"
  951
  290
  1
]
2.36 ms
(11.57%)
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:
[
  735
]
1.28 ms
(6.27%)
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.username_canonical = ? LIMIT 1
Parameters:
[
  "ankl_user a"
]
1.18 ms
(5.78%)
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 INNER JOIN additional_user_groups ON t0.id = additional_user_groups.group_id WHERE additional_user_groups.user_id = ?
Parameters:
[
  951
]
1.06 ms
(5.18%)
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:
[
  868
]
1.01 ms
(4.97%)
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:
[
  290
]
0.89 ms
(4.38%)
1
SELECT t0.id AS id_1 FROM restrict_access t0 WHERE t0.id = ?
Parameters:
[
  868
]

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\Expiration 2
Valt\CamBundle\Entity\RestrictAccess 2
Valt\UserBundle\Entity\User 1
Valt\UserBundle\Entity\UserGroup 1
Valt\UserBundle\Entity\UserEmailSettings 1
Valt\Template\Domain\Entity\Template 1
Valt\CamBundle\Entity\RetentionRule 1
Valt\UserBundle\Entity\Container 1
Valt\UserBundle\Entity\Log 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\Sso\Domain\ValueObject\SsoConfigName No errors.
Valt\Sso\Domain\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\UserBundle\Entity\LogFilter 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\Log No errors.