/items?rental=hoge が遅い

[ryoha000]

indexのせい？要調査

[H1rono]

該当部分

booQ/router/items.go

Lines 42 to 56 in c56f2b4

	rentalName := c.QueryParam("rental")
	if rentalName != "" {
	user, err := model.GetUserByName(rentalName)
	if err != nil {
	return c.JSON(http.StatusBadRequest, err)
	}
	if user.ID == 0 {
	return c.JSON(http.StatusBadRequest, errors.New("指定してるNameが不正です"))
	}
	res, err := model.SearchItemByRental(user.ID, me.ID)
	if err != nil {
	return c.JSON(http.StatusBadRequest, err)
	}
	return c.JSON(http.StatusOK, res)
	}

booQ/model/users.go

Lines 45 to 56 in c56f2b4

	// GetUserByName userをNameから取得する
	func GetUserByName(name string) (User, error) {
	res := User{}
	err := db.Where("name = ?", name).First(&res).Error
	if err != nil {
	if gorm.IsRecordNotFoundError(err) {
	return User{}, errors.New("nameが存在しません")
	}
	return User{}, err
	}
	return res, nil
	}

booQ/model/items.go

Lines 428 to 465 in c56f2b4

	// SearchItemsByRental itemsをRentalUserNameから取得する
	func SearchItemByRental(rentalUserID uint, meID uint) ([]GetItemResponse, error) {
	items := []Item{}
	err := db.Set("gorm:auto_preload", true).Preload("Logs.User").Preload("RentalUsers.User").Preload("RentalUsers.Owner").Preload("Comments.User").Find(&items).Error
	if err != nil {
	return []GetItemResponse{}, err
	}
	res := make([]GetItemResponse, 0, len(items))
	for _, item := range items {
	var err error
	item.LatestLogs, err = GetLatestLogs(item.Logs)
	if err != nil {
	return []GetItemResponse{}, err
	}
	match := false
	for _, rentalUser := range item.RentalUsers {
	if rentalUser.UserID == rentalUserID && rentalUser.Count < 0 {
	match = true
	}
	}
	if !match {
	continue
	}
	isLiked := false
	for _, like := range item.Likes {
	if like.ID == meID {
	isLiked = true
	break
	}
	}
	r := GetItemResponse{
	IsLiked: isLiked,
	Item: item,
	}
	res = append(res, r)
	}
	return res, nil
	}

SearchItemByRentalをいい感じにできそう