php性能优化进阶不要在for循环中DB操作【mysql优化】【php框架】

目录

• 前言
• 场景说明
• 解题思路
• 代码示例：
• 性能对比
• 反思总结

 !isset($data["hobby"]) ? [] : HobbyInfo::getByIds($data["hobby"]),
//          "profession" => !isset($data["profession"]) ? [] : ProfessionInfo::getByIds($data["profession"]),
//优化之后
            "hobby" => !isset($data["hobby"]) ? [] : self::_renderHobby($data["hobby"], $hobbyInfo),
            "profession" => !isset($data["profession"]) ? [] : self::_renderProfession($data["profession"], $professionInfo),
            .
            .
            .
        return $ret;
    }
}

protected static function _renderProfession($userProfession, $professionInfo)
{
    $ret = [];
    if ($userProfession) {
        $userProfessiOnIds= explode(",", $userProfession);
        foreach ($userProfessionIds as $key => $userProfessionId) {
            if (isset($professionInfo[$userProfessionId])) {
                $ret[$key] = $professionInfo[$userProfessionId];
            }
        }
    }
    return $ret;
}

public static function getBatchUserIntro($userid, $userList)
{
    $retData = [];
    if (empty($userList)) {
        return $retData;
    }
    .
    .
    .
    $hobbyInfo = HobbyInfo::getAllInfo();
    //按需批量查职业，不全量查询职业
    $professiOnIds= array_column($batchUserInfo, "profession");
    $professiOnIds= implode(",", $professionIds);
    $professiOnIds= array_unique(explode(",", $professionIds));
    $professiOnInfo= ProfessionInfo::batchGetByIds($professionIds);
    foreach ($batchUserInfo as $item) {
        $retData[$item["userid"]] = CommonRender::renderUserinfo($item, $hobbyInfo, $professionInfo, $expectInfo);
    }
    return $retData;
}

public static function batchGetByIds($ids = [])
{
    //兼容职业为空的情况
    foreach ($ids as $key => $id) {
        if (empty($id)) {
            unset($ids[$key]);
        }
    }
    if (empty($ids)) {
        return [];
    }
    return self::query()->selectRaw("id,name,pid")
        ->whereIn("id", $ids)
        ->get()
        ->keyBy("id")
        ->toArray();
}