只能获取最旧帖子的answerID，而不能获取被点击的帖子的get

// 示例代码：前端发送请求
function fetchAnswerId(postId) {
    fetch(`/api/getAnswerId?postId=${postId}`)
        .then(response => response.json())
        .then(data => {
            console.log('Answer ID:', data.answerId);
        })
        .catch(error => console.error('Error:', error));
}

# 示例代码：后端处理请求
from flask import Flask, request, jsonify

app = Flask(__name__)

@app.route('/api/getAnswerId', methods=['GET'])
def get_answer_id():
    post_id = request.args.get('postId')
    # 假设有一个函数可以根据postId查询到对应的answerId
    answer_id = query_answer_id_by_post_id(post_id)
    return jsonify({'answerId': answer_id})

def query_answer_id_by_post_id(post_id):
    # 这里应该是数据库查询逻辑
    # 假设查询结果为answer_id
    return answer_id

if __name__ == '__main__':
    app.run(debug=True)

CREATE INDEX idx_post_id ON answers(post_id);