conn = sqlite3.connect('logistics.db')
cursor = conn.cursor()
cursor.execute('''
    SELECT track_id, location, timestamp
    FROM tracking
    WHERE package_id = ?
    ORDER BY timestamp DESC''', ('PKG12345',))
# 获取最新轨迹
latest_record = cursor.fetchone()