国标协议GB28181视频云服务EasyGBS新建用户分配通道数过多显示空白如何优化？

if uname != defAdminUser && uname != defGuestUser && auth {
       selectsql := fmt.Sprintf(`%s.channel_device_id`, models.RoleChannel{}.TableName())
       joins1 := fmt.Sprintf(`left join %s on %s.id = %s.uid`, models.UserRole{}.TableName(),
              models.User{}.TableName(), models.UserRole{}.TableName())
       joins2 := fmt.Sprintf(`left join %s ON %s.rid = %s.role_id`, models.RoleChannel{}.TableName(),
              models.UserRole{}.TableName(), models.RoleChannel{}.TableName())
       wheresql := fmt.Sprintf(`%s.username='%s'`, models.User{}.TableName(), uname)
       var results []string
       db.SQLite.Table(models.User{}.TableName()).Select(selectsql).
              Where(wheresql).
              Joins(joins1).
              Joins(joins2).Pluck("channel_device_id", &results)

       q = q.Where("id in (?)", results)