Files
ai_wht_B/log10bjh_wht_server_api_2512162219.log

1589 lines
122 KiB
Plaintext
Raw Permalink Normal View History

2026-01-06 14:18:39 +08:00
22:19:07 - article_server - INFO - 日志系统已启动 - 记录器: article_server
22:19:07 - article_server - INFO - 主日志文件: logs/article_server.log
22:19:07 - article_server - INFO - 错误日志文件: logs/article_error.log
22:19:07 - article_server - INFO - 日志保留策略: 每天午夜分割主日志保留3天
22:19:07 - article_server - INFO - 错误日志保留策略: 每天午夜分割保留9天
22:19:07 - article_server - INFO - 万花筒API服务模块已加载
22:19:18 - article_server - INFO - [API访问] GET /api/images/list - IP: 36.27.52.26 - User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/143.0.0.0 Sa
22:19:18 - article_server - INFO - [API访问] GET /api/users/info - IP: 36.27.52.26 - User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/143.0.0.0 Sa
22:19:18 - article_server - INFO - [Token验证成功] 用户ID: 4
22:19:18 - article_server - INFO - [Token验证成功] 用户ID: 4
22:19:18 - article_server - INFO - [获取用户信息] 开始处理请求, IP: 36.27.52.26
22:19:18 - article_server - INFO - [获取用户信息] 用户ID: 4, IP: 36.27.52.26
22:19:18 - article_server - INFO - 数据库连接成功,字符集设置完成
22:19:18 - article_server - INFO - [SQL执行] 开始执行查询SQL
22:19:18 - article_server - INFO - [SQL语句]
SELECT COUNT(*) as total
FROM ai_images
WHERE enterprise_id = %s AND status = %s
22:19:18 - article_server - INFO - [SQL参数] [1, 'active']
22:19:18 - article_server - INFO - [SQL结果] 查询完成,返回 1 条记录
22:19:18 - article_server - INFO - [SQL数据] 查询结果: [{'total': 1}]
22:19:18 - article_server - INFO - 数据库连接成功,字符集设置完成
22:19:18 - article_server - INFO - [SQL执行] 开始执行查询SQL
22:19:18 - article_server - INFO - [SQL语句]
SELECT id, enterprise_id, enterprise_name, username, real_name, email, phone,
wechat_openid, wechat_unionid, xhs_cookie, xhs_phone, xhs_account,
is_bound_xhs, bound_at, department, role, status, created_at, updated_at
FROM ai_users
WHERE id = %s AND status != 'deleted'
22:19:18 - article_server - INFO - [SQL参数] (4,)
22:19:18 - article_server - INFO - [SQL执行] 开始执行查询SQL
22:19:18 - article_server - INFO - [SQL语句]
SELECT id, product_id, product_name, image_name, image_url, image_thumb_url, thumbnail_url,
image_type_id, image_type_name, department, keywords,
size_type, file_size, width, height, status,
created_at, updated_at
FROM ai_images
WHERE enterprise_id = %s AND status = %s
ORDER BY created_at DESC
LIMIT %s OFFSET %s
22:19:18 - article_server - INFO - [SQL参数] [1, 'active', 100, 0]
22:19:18 - article_server - INFO - [SQL结果] 查询完成,返回 1 条记录
22:19:18 - article_server - INFO - [SQL数据] 查询结果: [{'id': 4, 'enterprise_id': 1, 'enterprise_name': 'rwl企业4号', 'username': 'user004', 'real_name': '饶文龙', 'email': None, 'phone': '13621242430', 'wechat_openid': None, 'wechat_unionid': None, 'xhs_cookie': None, 'xhs_phone': '', 'xhs_account': '小红书用户4', 'is_bound_xhs': 1, 'bound_at': None, 'department': '技术部', 'role': 'enterprise', 'status': 'active', 'created_at': datetime.datetime(2025, 12, 12, 16, 58, 22), 'updated_at': datetime.datetime(2025, 12, 16, 13, 47, 4)}]
22:19:18 - article_server - INFO - [SQL结果] 查询完成,返回 1 条记录
22:19:18 - article_server - INFO - [SQL数据] 查询结果: [{'id': 23, 'product_id': 32, 'product_name': '测试产品_7766', 'image_name': '图片描述图片描述', 'image_url': '20251216/1765893522846382.png', 'image_thumb_url': '20251216/1765893522846382_thumb.png', 'thumbnail_url': '20251216/1765893522846382_thumb.png', 'image_type_id': 2, 'image_type_name': '场景图(图片类型)', 'department': '', 'keywords': '图片描述,图片描述1', 'size_type': 'medical', 'file_size': 1263901, 'width': 993, 'height': 1280, 'status': 'active', 'created_at': datetime.datetime(2025, 12, 16, 13, 58, 50), 'updated_at': datetime.datetime(2025, 12, 16, 13, 58, 50)}]
22:19:18 - article_server - INFO - [获取用户信息] 查询成功, 用户: user004, 角色: enterprise, 企业: rwl企业4号, IP: 36.27.52.26
22:19:18 - article_server - INFO - [SQL执行] 开始执行插入SQL
22:19:18 - article_server - INFO - [SQL语句]
INSERT INTO ai_logs
(user_id, action, target_type, target_id, description,
ip_address, user_agent, request_data, response_data,
status, error_message, created_at)
VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, NOW())
22:19:18 - article_server - INFO - [SQL参数] (4, 'get_user_info', 'user', 4, '查询用户信息: user004', '36.27.52.26', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/143.0.0.0 Safari/537.36', None, None, 'success', None)
22:19:18 - article_server - INFO - [SQL执行] 开始执行查询SQL
22:19:18 - article_server - INFO - [SQL语句]
SELECT tag_id, tag_name
FROM ai_image_tags
WHERE image_id = %s AND enterprise_id = %s
ORDER BY created_at
22:19:18 - article_server - INFO - [SQL参数] [23, 1]
22:19:18 - article_server - INFO - [SQL结果] 查询完成,返回 2 条记录
22:19:18 - article_server - INFO - [SQL数据] 查询结果: [{'tag_id': 1, 'tag_name': '图片描述'}, {'tag_id': 2, 'tag_name': '图片描述1'}]
22:19:18 - article_server - INFO - [SQL结果] 插入完成新记录ID: 33
22:19:18 - article_server - INFO - 获取图片列表成功,总数: 1
22:19:18 - article_server - INFO - [API响应] GET /api/images/list - IP: 36.27.52.26 - 状态码: 200
22:19:18 - article_server - INFO - [业务日志] 操作: get_user_info | 用户ID: 4 | 目标: user#4 | 状态: success | IP: 36.27.52.26 | 日志ID: 33
22:19:18 - article_server - INFO - [API响应] GET /api/users/info - IP: 36.27.52.26 - 状态码: 200
22:19:48 - article_server - INFO - [API访问] POST /api/images/upload - IP: 36.27.52.26 - User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/143.0.0.0 Sa
22:19:48 - article_server - INFO - [Token验证成功] 用户ID: 4
22:19:48 - article_server - INFO - [上传图片] 图片尺寸优化: 缩放到 (810, 1080)
22:19:48 - article_server - INFO - [上传图片] 优化原图保存成功: /home/work/baijiahao/tags_images/Images/20251216/1765894788102778.png
22:19:48 - article_server - INFO - [上传图片] 缩略图生成成功: /home/work/baijiahao/tags_images/Images/20251216/1765894788102778_thumb.png (尺寸: (120, 160))
22:19:48 - article_server - INFO - [上传图片] 开始调用 TransformerImage 处理图片
22:19:48 - article_server - INFO - [OSS业务] 开始处理图片上传请求 - 文件: 1765894788102778.png
22:19:48 - article_server - INFO - [OSS业务] 文件信息 - 大小: 506058 bytes, 路径: /home/work/baijiahao/tags_images/Images/20251216/1765894788102778.png
22:19:48 - article_server - INFO - [OSS上传] 开始上传文件: /home/work/baijiahao/tags_images/Images/20251216/1765894788102778.png -> Images/20251216/1765894788102778.png
22:19:48 - article_server - INFO - [OSS业务] OSS配置 - Bucket: bxmkb-beijing, Endpoint: https://oss-cn-beijing.aliyuncs.com/
22:19:51 - article_server - INFO - [OSS业务] 上传耗时: 2.80 秒
22:19:51 - article_server - INFO - [OSS上传] 文件上传成功: Images/20251216/1765894788102778.png -> https://bxmkb-beijing.oss-cn-beijing.aliyuncs.com//Images/20251216/1765894788102778.png
22:19:51 - article_server - INFO - [OSS业务] 上传成功 - OSS Key: Images/20251216/1765894788102778.png, 文件大小: 506058 bytes, 耗时: 2.80s
22:19:51 - article_server - INFO - [上传图片] 原图上传结果: {'success': True, 'message': '上传成功', 'oss_url': 'https://bxmkb-beijing.oss-cn-beijing.aliyuncs.com//Images/20251216/1765894788102778.png', 'oss_key': 'Images/20251216/1765894788102778.png'}
22:19:51 - article_server - INFO - [OSS业务] 开始处理图片上传请求 - 文件: 1765894788102778_thumb.png
22:19:51 - article_server - INFO - [OSS业务] 文件信息 - 大小: 23155 bytes, 路径: /home/work/baijiahao/tags_images/Images/20251216/1765894788102778_thumb.png
22:19:51 - article_server - INFO - [OSS上传] 开始上传文件: /home/work/baijiahao/tags_images/Images/20251216/1765894788102778_thumb.png -> Images/20251216/1765894788102778_thumb.png
22:19:51 - article_server - INFO - [OSS业务] OSS配置 - Bucket: bxmkb-beijing, Endpoint: https://oss-cn-beijing.aliyuncs.com/
22:19:51 - article_server - INFO - [OSS业务] 上传耗时: 0.02 秒
22:19:51 - article_server - INFO - [OSS上传] 文件上传成功: Images/20251216/1765894788102778_thumb.png -> https://bxmkb-beijing.oss-cn-beijing.aliyuncs.com//Images/20251216/1765894788102778_thumb.png
22:19:51 - article_server - INFO - [OSS业务] 上传成功 - OSS Key: Images/20251216/1765894788102778_thumb.png, 文件大小: 23155 bytes, 耗时: 0.02s
22:19:51 - article_server - INFO - [上传图片] 缩图上传结果: {'success': True, 'message': '上传成功', 'oss_url': 'https://bxmkb-beijing.oss-cn-beijing.aliyuncs.com//Images/20251216/1765894788102778_thumb.png', 'oss_key': 'Images/20251216/1765894788102778_thumb.png'}
22:19:51 - article_server - INFO - 数据库连接成功,字符集设置完成
22:19:51 - article_server - INFO - [SQL执行] 开始执行插入SQL
22:19:51 - article_server - INFO - [SQL语句]
INSERT INTO ai_images
(enterprise_id, product_id, product_name, image_name, image_url, image_thumb_url, thumbnail_url,
image_type_id, image_type_name, department, keywords, size_type,
file_size, width, height, upload_user_id, status)
VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s)
22:19:51 - article_server - INFO - [SQL参数] (1, 33, '产品4', '产品4产品4产品4', '20251216/1765894788102778.png', '20251216/1765894788102778_thumb.png', '20251216/1765894788102778_thumb.png', 3, '细节图(图片类型)', '', '产品4,产品43', 'medical', 1988355, 1701, 2268, 4, 'active')
22:19:51 - article_server - INFO - [SQL结果] 插入完成新记录ID: 24
22:19:51 - article_server - INFO - [上传图片] 步骤(1) ai_images 入库成功: image_id=24
22:19:51 - article_server - INFO - [SQL执行] 开始执行查询SQL
22:19:51 - article_server - INFO - [SQL语句] SELECT id FROM ai_image_tags_name WHERE enterprise_id = %s AND tag_name = %s
22:19:51 - article_server - INFO - [SQL参数] (1, '产品4')
22:19:51 - article_server - INFO - [SQL结果] 查询完成,返回 0 条记录
22:19:51 - article_server - INFO - [SQL执行] 开始执行插入SQL
22:19:51 - article_server - INFO - [SQL语句]
INSERT INTO ai_image_tags_name
(enterprise_id, tag_name, status)
VALUES (%s, %s, %s)
22:19:51 - article_server - INFO - [SQL参数] (1, '产品4', 'active')
22:19:51 - article_server - INFO - [SQL结果] 插入完成新记录ID: 3
22:19:51 - article_server - INFO - [上传图片] 步骤(2) 新标签入库成功: tag_name=产品4, tag_id=3
22:19:51 - article_server - INFO - [SQL执行] 开始执行查询SQL
22:19:51 - article_server - INFO - [SQL语句] SELECT id FROM ai_image_tags_name WHERE enterprise_id = %s AND tag_name = %s
22:19:51 - article_server - INFO - [SQL参数] (1, '产品43')
22:19:51 - article_server - INFO - [SQL结果] 查询完成,返回 0 条记录
22:19:51 - article_server - INFO - [SQL执行] 开始执行插入SQL
22:19:51 - article_server - INFO - [SQL语句]
INSERT INTO ai_image_tags_name
(enterprise_id, tag_name, status)
VALUES (%s, %s, %s)
22:19:51 - article_server - INFO - [SQL参数] (1, '产品43', 'active')
22:19:51 - article_server - INFO - [SQL结果] 插入完成新记录ID: 4
22:19:51 - article_server - INFO - [上传图片] 步骤(2) 新标签入库成功: tag_name=产品43, tag_id=4
22:19:51 - article_server - INFO - [SQL执行] 开始执行插入SQL
22:19:51 - article_server - INFO - [SQL语句]
INSERT INTO ai_image_tags
(enterprise_id, product_id, image_id, image_name, image_url, image_thumb_url,
tag_id, tag_name, created_user_id)
VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s)
22:19:51 - article_server - INFO - [SQL参数] (1, 33, 24, '产品4产品4产品4', '20251216/1765894788102778.png', '20251216/1765894788102778_thumb.png', 3, '产品4', 4)
22:19:52 - article_server - INFO - [SQL结果] 插入完成新记录ID: 3
22:19:52 - article_server - INFO - [上传图片] 步骤(3) 关系映射入库成功: image_id=24, tag_id=3, tag_name=产品4, product_id=33
22:19:52 - article_server - INFO - [SQL执行] 开始执行插入SQL
22:19:52 - article_server - INFO - [SQL语句]
INSERT INTO ai_image_tags
(enterprise_id, product_id, image_id, image_name, image_url, image_thumb_url,
tag_id, tag_name, created_user_id)
VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s)
22:19:52 - article_server - INFO - [SQL参数] (1, 33, 24, '产品4产品4产品4', '20251216/1765894788102778.png', '20251216/1765894788102778_thumb.png', 4, '产品43', 4)
22:19:52 - article_server - INFO - [SQL结果] 插入完成新记录ID: 4
22:19:52 - article_server - INFO - [上传图片] 步骤(3) 关系映射入库成功: image_id=24, tag_id=4, tag_name=产品43, product_id=33
22:19:52 - article_server - INFO - [SQL执行] 开始执行插入SQL
22:19:52 - article_server - INFO - [SQL语句]
INSERT INTO ai_product_images
(enterprise_id, product_id, product_name, image_id, image_name, image_url, thumbnail_url,
type_name, description, file_size, width, height, upload_user_id, status)
VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s)
22:19:52 - article_server - INFO - [SQL参数] (1, 33, '产品4', 24, '产品4产品4产品4', '20251216/1765894788102778.png', '20251216/1765894788102778_thumb.png', '细节图(图片类型)', '', 1988355, 1701, 2268, 4, 'active')
22:19:52 - article_server - INFO - [SQL结果] 插入完成新记录ID: 12
22:19:52 - article_server - INFO - [上传图片] 步骤(4) ai_product_images 入库成功: product_image_id=12, product_id=33, image_id=24
22:19:52 - article_server - INFO - [上传图片] 全部完成: image_id=24, 标签数=2, 关系数=2, product_image_id=12
22:19:52 - article_server - INFO - [API响应] POST /api/images/upload - IP: 36.27.52.26 - 状态码: 200
22:19:52 - article_server - INFO - [API访问] GET /api/images/list - IP: 36.27.52.26 - User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/143.0.0.0 Sa
22:19:52 - article_server - INFO - [Token验证成功] 用户ID: 4
22:19:52 - article_server - INFO - [SQL执行] 开始执行查询SQL
22:19:52 - article_server - INFO - [SQL语句]
SELECT COUNT(*) as total
FROM ai_images
WHERE enterprise_id = %s AND status = %s
22:19:52 - article_server - INFO - [SQL参数] [1, 'active']
22:19:52 - article_server - INFO - [SQL结果] 查询完成,返回 1 条记录
22:19:52 - article_server - INFO - [SQL数据] 查询结果: [{'total': 2}]
22:19:52 - article_server - INFO - [SQL执行] 开始执行查询SQL
22:19:52 - article_server - INFO - [SQL语句]
SELECT id, product_id, product_name, image_name, image_url, image_thumb_url, thumbnail_url,
image_type_id, image_type_name, department, keywords,
size_type, file_size, width, height, status,
created_at, updated_at
FROM ai_images
WHERE enterprise_id = %s AND status = %s
ORDER BY created_at DESC
LIMIT %s OFFSET %s
22:19:52 - article_server - INFO - [SQL参数] [1, 'active', 100, 0]
22:19:52 - article_server - INFO - [SQL结果] 查询完成,返回 2 条记录
22:19:52 - article_server - INFO - [SQL数据] 查询结果: [{'id': 24, 'product_id': 33, 'product_name': '产品4', 'image_name': '产品4产品4产品4', 'image_url': '20251216/1765894788102778.png', 'image_thumb_url': '20251216/1765894788102778_thumb.png', 'thumbnail_url': '20251216/1765894788102778_thumb.png', 'image_type_id': 3, 'image_type_name': '细节图(图片类型)', 'department': '', 'keywords': '产品4,产品43', 'size_type': 'medical', 'file_size': 1988355, 'width': 1701, 'height': 2268, 'status': 'active', 'created_at': datetime.datetime(2025, 12, 16, 14, 19, 51), 'updated_at': datetime.datetime(2025, 12, 16, 14, 19, 51)}, {'id': 23, 'product_id': 32, 'product_name': '测试产品_7766', 'image_name': '图片描述图片描述', 'image_url': '20251216/1765893522846382.png', 'image_thumb_url': '20251216/1765893522846382_thumb.png', 'thumbnail_url': '20251216/1765893522846382_thumb.png', 'image_type_id': 2, 'image_type_name': '场景图(图片类型)', 'department': '', 'keywords': '图片描述,图片描述1', 'size_type': 'medical', 'file_size': 1263901, 'width': 993, 'height': 1280, 'status': 'active', 'created_at': datetime.datetime(2025, 12, 16, 13, 58, 50), 'updated_at': datetime.datetime(2025, 12, 16, 13, 58, 50)}]
22:19:52 - article_server - INFO - [SQL执行] 开始执行查询SQL
22:19:52 - article_server - INFO - [SQL语句]
SELECT tag_id, tag_name
FROM ai_image_tags
WHERE image_id = %s AND enterprise_id = %s
ORDER BY created_at
22:19:52 - article_server - INFO - [SQL参数] [24, 1]
22:19:52 - article_server - INFO - [SQL结果] 查询完成,返回 2 条记录
22:19:52 - article_server - INFO - [SQL数据] 查询结果: [{'tag_id': 3, 'tag_name': '产品4'}, {'tag_id': 4, 'tag_name': '产品43'}]
22:19:52 - article_server - INFO - [SQL执行] 开始执行查询SQL
22:19:52 - article_server - INFO - [SQL语句]
SELECT tag_id, tag_name
FROM ai_image_tags
WHERE image_id = %s AND enterprise_id = %s
ORDER BY created_at
22:19:52 - article_server - INFO - [SQL参数] [23, 1]
22:19:52 - article_server - INFO - [SQL结果] 查询完成,返回 2 条记录
22:19:52 - article_server - INFO - [SQL数据] 查询结果: [{'tag_id': 1, 'tag_name': '图片描述'}, {'tag_id': 2, 'tag_name': '图片描述1'}]
22:19:52 - article_server - INFO - 获取图片列表成功,总数: 2
22:19:52 - article_server - INFO - [API响应] GET /api/images/list - IP: 36.27.52.26 - 状态码: 200
22:19:54 - article_server - INFO - [API访问] GET /api/images/list - IP: 36.27.52.26 - User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/143.0.0.0 Sa
22:19:54 - article_server - INFO - [Token验证成功] 用户ID: 4
22:19:54 - article_server - INFO - [API访问] GET /api/users/info - IP: 36.27.52.26 - User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/143.0.0.0 Sa
22:19:54 - article_server - INFO - [Token验证成功] 用户ID: 4
22:19:54 - article_server - INFO - [获取用户信息] 开始处理请求, IP: 36.27.52.26
22:19:54 - article_server - INFO - [获取用户信息] 用户ID: 4, IP: 36.27.52.26
22:19:54 - article_server - INFO - [SQL执行] 开始执行查询SQL
22:19:54 - article_server - INFO - [SQL语句]
SELECT id, enterprise_id, enterprise_name, username, real_name, email, phone,
wechat_openid, wechat_unionid, xhs_cookie, xhs_phone, xhs_account,
is_bound_xhs, bound_at, department, role, status, created_at, updated_at
FROM ai_users
WHERE id = %s AND status != 'deleted'
22:19:54 - article_server - INFO - [SQL参数] (4,)
22:19:54 - article_server - INFO - [SQL执行] 开始执行查询SQL
22:19:54 - article_server - INFO - [SQL语句]
SELECT COUNT(*) as total
FROM ai_images
WHERE enterprise_id = %s AND status = %s
22:19:54 - article_server - INFO - [SQL参数] [1, 'active']
22:19:54 - article_server - INFO - [SQL结果] 查询完成,返回 1 条记录
22:19:54 - article_server - INFO - [SQL数据] 查询结果: [{'id': 4, 'enterprise_id': 1, 'enterprise_name': 'rwl企业4号', 'username': 'user004', 'real_name': '饶文龙', 'email': None, 'phone': '13621242430', 'wechat_openid': None, 'wechat_unionid': None, 'xhs_cookie': None, 'xhs_phone': '', 'xhs_account': '小红书用户4', 'is_bound_xhs': 1, 'bound_at': None, 'department': '技术部', 'role': 'enterprise', 'status': 'active', 'created_at': datetime.datetime(2025, 12, 12, 16, 58, 22), 'updated_at': datetime.datetime(2025, 12, 16, 13, 47, 4)}]
22:19:54 - article_server - INFO - [SQL结果] 查询完成,返回 1 条记录
22:19:54 - article_server - INFO - [SQL数据] 查询结果: [{'total': 2}]
22:19:54 - article_server - INFO - [获取用户信息] 查询成功, 用户: user004, 角色: enterprise, 企业: rwl企业4号, IP: 36.27.52.26
22:19:54 - article_server - INFO - [SQL执行] 开始执行插入SQL
22:19:54 - article_server - INFO - [SQL语句]
INSERT INTO ai_logs
(user_id, action, target_type, target_id, description,
ip_address, user_agent, request_data, response_data,
status, error_message, created_at)
VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, NOW())
22:19:54 - article_server - INFO - [SQL参数] (4, 'get_user_info', 'user', 4, '查询用户信息: user004', '36.27.52.26', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/143.0.0.0 Safari/537.36', None, None, 'success', None)
22:19:54 - article_server - INFO - [SQL执行] 开始执行查询SQL
22:19:54 - article_server - INFO - [SQL语句]
SELECT id, product_id, product_name, image_name, image_url, image_thumb_url, thumbnail_url,
image_type_id, image_type_name, department, keywords,
size_type, file_size, width, height, status,
created_at, updated_at
FROM ai_images
WHERE enterprise_id = %s AND status = %s
ORDER BY created_at DESC
LIMIT %s OFFSET %s
22:19:54 - article_server - INFO - [SQL参数] [1, 'active', 100, 0]
22:19:54 - article_server - INFO - [SQL结果] 插入完成新记录ID: 34
22:19:54 - article_server - INFO - [SQL结果] 查询完成,返回 2 条记录
22:19:54 - article_server - INFO - [SQL数据] 查询结果: [{'id': 24, 'product_id': 33, 'product_name': '产品4', 'image_name': '产品4产品4产品4', 'image_url': '20251216/1765894788102778.png', 'image_thumb_url': '20251216/1765894788102778_thumb.png', 'thumbnail_url': '20251216/1765894788102778_thumb.png', 'image_type_id': 3, 'image_type_name': '细节图(图片类型)', 'department': '', 'keywords': '产品4,产品43', 'size_type': 'medical', 'file_size': 1988355, 'width': 1701, 'height': 2268, 'status': 'active', 'created_at': datetime.datetime(2025, 12, 16, 14, 19, 51), 'updated_at': datetime.datetime(2025, 12, 16, 14, 19, 51)}, {'id': 23, 'product_id': 32, 'product_name': '测试产品_7766', 'image_name': '图片描述图片描述', 'image_url': '20251216/1765893522846382.png', 'image_thumb_url': '20251216/1765893522846382_thumb.png', 'thumbnail_url': '20251216/1765893522846382_thumb.png', 'image_type_id': 2, 'image_type_name': '场景图(图片类型)', 'department': '', 'keywords': '图片描述,图片描述1', 'size_type': 'medical', 'file_size': 1263901, 'width': 993, 'height': 1280, 'status': 'active', 'created_at': datetime.datetime(2025, 12, 16, 13, 58, 50), 'updated_at': datetime.datetime(2025, 12, 16, 13, 58, 50)}]
22:19:54 - article_server - INFO - [业务日志] 操作: get_user_info | 用户ID: 4 | 目标: user#4 | 状态: success | IP: 36.27.52.26 | 日志ID: 34
22:19:54 - article_server - INFO - [API响应] GET /api/users/info - IP: 36.27.52.26 - 状态码: 200
22:19:54 - article_server - INFO - [SQL执行] 开始执行查询SQL
22:19:54 - article_server - INFO - [SQL语句]
SELECT tag_id, tag_name
FROM ai_image_tags
WHERE image_id = %s AND enterprise_id = %s
ORDER BY created_at
22:19:54 - article_server - INFO - [SQL参数] [24, 1]
22:19:54 - article_server - INFO - [SQL结果] 查询完成,返回 2 条记录
22:19:54 - article_server - INFO - [SQL数据] 查询结果: [{'tag_id': 3, 'tag_name': '产品4'}, {'tag_id': 4, 'tag_name': '产品43'}]
22:19:54 - article_server - INFO - [SQL执行] 开始执行查询SQL
22:19:54 - article_server - INFO - [SQL语句]
SELECT tag_id, tag_name
FROM ai_image_tags
WHERE image_id = %s AND enterprise_id = %s
ORDER BY created_at
22:19:54 - article_server - INFO - [SQL参数] [23, 1]
22:19:54 - article_server - INFO - [SQL结果] 查询完成,返回 2 条记录
22:19:54 - article_server - INFO - [SQL数据] 查询结果: [{'tag_id': 1, 'tag_name': '图片描述'}, {'tag_id': 2, 'tag_name': '图片描述1'}]
22:19:54 - article_server - INFO - 获取图片列表成功,总数: 2
22:19:54 - article_server - INFO - [API响应] GET /api/images/list - IP: 36.27.52.26 - 状态码: 200
22:19:55 - article_server - INFO - [API访问] DELETE /api/images/23 - IP: 36.27.52.26 - User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/143.0.0.0 Sa
22:19:55 - article_server - INFO - [Token验证成功] 用户ID: 4
22:19:55 - article_server - INFO - [SQL执行] 开始执行查询SQL
22:19:55 - article_server - INFO - [SQL语句] SELECT id FROM ai_images WHERE id = %s
22:19:55 - article_server - INFO - [SQL参数] (23,)
22:19:56 - article_server - INFO - [SQL结果] 查询完成,返回 1 条记录
22:19:56 - article_server - INFO - [SQL数据] 查询结果: [{'id': 23}]
22:19:56 - article_server - INFO - [SQL执行] 开始执行更新SQL
22:19:56 - article_server - INFO - [SQL语句] UPDATE ai_images SET status = 'deleted' WHERE id = %s
22:19:56 - article_server - INFO - [SQL参数] (23,)
22:19:56 - article_server - INFO - [SQL结果] 更新完成,影响 1 行
22:19:56 - article_server - INFO - 删除图片成功: ID 23
22:19:56 - article_server - INFO - [API响应] DELETE /api/images/23 - IP: 36.27.52.26 - 状态码: 200
22:19:56 - article_server - INFO - [API访问] GET /api/images/list - IP: 36.27.52.26 - User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/143.0.0.0 Sa
22:19:56 - article_server - INFO - [Token验证成功] 用户ID: 4
22:19:56 - article_server - INFO - [SQL执行] 开始执行查询SQL
22:19:56 - article_server - INFO - [SQL语句]
SELECT COUNT(*) as total
FROM ai_images
WHERE enterprise_id = %s AND status = %s
22:19:56 - article_server - INFO - [SQL参数] [1, 'active']
22:19:56 - article_server - INFO - [SQL结果] 查询完成,返回 1 条记录
22:19:56 - article_server - INFO - [SQL数据] 查询结果: [{'total': 1}]
22:19:56 - article_server - INFO - [SQL执行] 开始执行查询SQL
22:19:56 - article_server - INFO - [SQL语句]
SELECT id, product_id, product_name, image_name, image_url, image_thumb_url, thumbnail_url,
image_type_id, image_type_name, department, keywords,
size_type, file_size, width, height, status,
created_at, updated_at
FROM ai_images
WHERE enterprise_id = %s AND status = %s
ORDER BY created_at DESC
LIMIT %s OFFSET %s
22:19:56 - article_server - INFO - [SQL参数] [1, 'active', 100, 0]
22:19:56 - article_server - INFO - [SQL结果] 查询完成,返回 1 条记录
22:19:56 - article_server - INFO - [SQL数据] 查询结果: [{'id': 24, 'product_id': 33, 'product_name': '产品4', 'image_name': '产品4产品4产品4', 'image_url': '20251216/1765894788102778.png', 'image_thumb_url': '20251216/1765894788102778_thumb.png', 'thumbnail_url': '20251216/1765894788102778_thumb.png', 'image_type_id': 3, 'image_type_name': '细节图(图片类型)', 'department': '', 'keywords': '产品4,产品43', 'size_type': 'medical', 'file_size': 1988355, 'width': 1701, 'height': 2268, 'status': 'active', 'created_at': datetime.datetime(2025, 12, 16, 14, 19, 51), 'updated_at': datetime.datetime(2025, 12, 16, 14, 19, 51)}]
22:19:56 - article_server - INFO - [SQL执行] 开始执行查询SQL
22:19:56 - article_server - INFO - [SQL语句]
SELECT tag_id, tag_name
FROM ai_image_tags
WHERE image_id = %s AND enterprise_id = %s
ORDER BY created_at
22:19:56 - article_server - INFO - [SQL参数] [24, 1]
22:19:56 - article_server - INFO - [SQL结果] 查询完成,返回 2 条记录
22:19:56 - article_server - INFO - [SQL数据] 查询结果: [{'tag_id': 3, 'tag_name': '产品4'}, {'tag_id': 4, 'tag_name': '产品43'}]
22:19:56 - article_server - INFO - 获取图片列表成功,总数: 1
22:19:56 - article_server - INFO - [API响应] GET /api/images/list - IP: 36.27.52.26 - 状态码: 200
22:19:58 - article_server - INFO - [API访问] GET /api/images/list - IP: 36.27.52.26 - User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/143.0.0.0 Sa
22:19:58 - article_server - INFO - [Token验证成功] 用户ID: 4
22:19:58 - article_server - INFO - [API访问] GET /api/users/info - IP: 36.27.52.26 - User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/143.0.0.0 Sa
22:19:58 - article_server - INFO - [Token验证成功] 用户ID: 4
22:19:58 - article_server - INFO - [获取用户信息] 开始处理请求, IP: 36.27.52.26
22:19:58 - article_server - INFO - [获取用户信息] 用户ID: 4, IP: 36.27.52.26
22:19:58 - article_server - INFO - [SQL执行] 开始执行查询SQL
22:19:58 - article_server - INFO - [SQL语句]
SELECT COUNT(*) as total
FROM ai_images
WHERE enterprise_id = %s AND status = %s
22:19:58 - article_server - INFO - [SQL参数] [1, 'active']
22:19:58 - article_server - INFO - [SQL结果] 查询完成,返回 1 条记录
22:19:58 - article_server - INFO - [SQL数据] 查询结果: [{'total': 1}]
22:19:58 - article_server - INFO - [SQL执行] 开始执行查询SQL
22:19:58 - article_server - INFO - [SQL语句]
SELECT id, product_id, product_name, image_name, image_url, image_thumb_url, thumbnail_url,
image_type_id, image_type_name, department, keywords,
size_type, file_size, width, height, status,
created_at, updated_at
FROM ai_images
WHERE enterprise_id = %s AND status = %s
ORDER BY created_at DESC
LIMIT %s OFFSET %s
22:19:58 - article_server - INFO - [SQL参数] [1, 'active', 100, 0]
22:19:58 - article_server - INFO - [SQL结果] 查询完成,返回 1 条记录
22:19:58 - article_server - INFO - [SQL数据] 查询结果: [{'id': 24, 'product_id': 33, 'product_name': '产品4', 'image_name': '产品4产品4产品4', 'image_url': '20251216/1765894788102778.png', 'image_thumb_url': '20251216/1765894788102778_thumb.png', 'thumbnail_url': '20251216/1765894788102778_thumb.png', 'image_type_id': 3, 'image_type_name': '细节图(图片类型)', 'department': '', 'keywords': '产品4,产品43', 'size_type': 'medical', 'file_size': 1988355, 'width': 1701, 'height': 2268, 'status': 'active', 'created_at': datetime.datetime(2025, 12, 16, 14, 19, 51), 'updated_at': datetime.datetime(2025, 12, 16, 14, 19, 51)}]
22:19:58 - article_server - INFO - 数据库连接成功,字符集设置完成
22:19:58 - article_server - INFO - [SQL执行] 开始执行查询SQL
22:19:58 - article_server - INFO - [SQL语句]
SELECT id, enterprise_id, enterprise_name, username, real_name, email, phone,
wechat_openid, wechat_unionid, xhs_cookie, xhs_phone, xhs_account,
is_bound_xhs, bound_at, department, role, status, created_at, updated_at
FROM ai_users
WHERE id = %s AND status != 'deleted'
22:19:58 - article_server - INFO - [SQL参数] (4,)
22:19:58 - article_server - INFO - [SQL结果] 查询完成,返回 1 条记录
22:19:58 - article_server - INFO - [SQL数据] 查询结果: [{'id': 4, 'enterprise_id': 1, 'enterprise_name': 'rwl企业4号', 'username': 'user004', 'real_name': '饶文龙', 'email': None, 'phone': '13621242430', 'wechat_openid': None, 'wechat_unionid': None, 'xhs_cookie': None, 'xhs_phone': '', 'xhs_account': '小红书用户4', 'is_bound_xhs': 1, 'bound_at': None, 'department': '技术部', 'role': 'enterprise', 'status': 'active', 'created_at': datetime.datetime(2025, 12, 12, 16, 58, 22), 'updated_at': datetime.datetime(2025, 12, 16, 13, 47, 4)}]
22:19:58 - article_server - INFO - [获取用户信息] 查询成功, 用户: user004, 角色: enterprise, 企业: rwl企业4号, IP: 36.27.52.26
22:19:58 - article_server - INFO - [SQL执行] 开始执行查询SQL
22:19:58 - article_server - INFO - [SQL语句]
SELECT tag_id, tag_name
FROM ai_image_tags
WHERE image_id = %s AND enterprise_id = %s
ORDER BY created_at
22:19:58 - article_server - INFO - [SQL参数] [24, 1]
22:19:58 - article_server - INFO - [SQL执行] 开始执行插入SQL
22:19:58 - article_server - INFO - [SQL语句]
INSERT INTO ai_logs
(user_id, action, target_type, target_id, description,
ip_address, user_agent, request_data, response_data,
status, error_message, created_at)
VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, NOW())
22:19:58 - article_server - INFO - [SQL参数] (4, 'get_user_info', 'user', 4, '查询用户信息: user004', '36.27.52.26', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/143.0.0.0 Safari/537.36', None, None, 'success', None)
22:19:58 - article_server - INFO - [SQL结果] 查询完成,返回 2 条记录
22:19:58 - article_server - INFO - [SQL数据] 查询结果: [{'tag_id': 3, 'tag_name': '产品4'}, {'tag_id': 4, 'tag_name': '产品43'}]
22:19:58 - article_server - INFO - [SQL结果] 插入完成新记录ID: 35
22:19:58 - article_server - INFO - 获取图片列表成功,总数: 1
22:19:58 - article_server - INFO - [API响应] GET /api/images/list - IP: 36.27.52.26 - 状态码: 200
22:19:58 - article_server - INFO - [业务日志] 操作: get_user_info | 用户ID: 4 | 目标: user#4 | 状态: success | IP: 36.27.52.26 | 日志ID: 35
22:19:58 - article_server - INFO - [API响应] GET /api/users/info - IP: 36.27.52.26 - 状态码: 200
22:20:07 - article_server - INFO - [API访问] GET /api/prompts/tags/list - IP: 36.27.52.26 - User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/143.0.0.0 Sa
22:20:07 - article_server - INFO - [API访问] GET /api/prompts/list - IP: 36.27.52.26 - User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/143.0.0.0 Sa
22:20:07 - article_server - INFO - [Token验证成功] 用户ID: 4
22:20:07 - article_server - INFO - [Token验证成功] 用户ID: 4
22:20:07 - article_server - INFO - [SQL执行] 开始执行查询SQL
22:20:07 - article_server - INFO - [SQL语句] SELECT COUNT(*) as total FROM ai_prompt_workflow WHERE enterprise_id = %s
22:20:07 - article_server - INFO - [SQL参数] (1,)
22:20:07 - article_server - INFO - [SQL执行] 开始执行查询SQL
22:20:07 - article_server - INFO - [SQL语句] SELECT COUNT(*) as total FROM ai_prompt_tags WHERE enterprise_id = %s
22:20:07 - article_server - INFO - [SQL参数] [1]
22:20:07 - article_server - INFO - [SQL结果] 查询完成,返回 1 条记录
22:20:07 - article_server - INFO - [SQL数据] 查询结果: [{'total': 8}]
22:20:07 - article_server - INFO - [SQL结果] 查询完成,返回 1 条记录
22:20:07 - article_server - INFO - [SQL数据] 查询结果: [{'total': 0}]
22:20:07 - article_server - INFO - [SQL执行] 开始执行查询SQL
22:20:07 - article_server - INFO - [SQL语句]
SELECT id, prompt_workflow_name, workflow_id, content, usage_count, created_at, updated_at
FROM ai_prompt_workflow
WHERE enterprise_id = %s
ORDER BY created_at DESC
LIMIT %s OFFSET %s
22:20:07 - article_server - INFO - [SQL参数] (1, 20, 0)
22:20:07 - article_server - INFO - [SQL执行] 开始执行查询SQL
22:20:07 - article_server - INFO - [SQL语句]
SELECT id, tag_name, created_user_id, created_at, updated_at
FROM ai_prompt_tags
WHERE enterprise_id = %s
ORDER BY created_at DESC
LIMIT %s OFFSET %s
22:20:07 - article_server - INFO - [SQL参数] [1, 100, 0]
22:20:07 - article_server - INFO - [SQL结果] 查询完成,返回 8 条记录
22:20:07 - article_server - INFO - [SQL结果] 查询完成,返回 0 条记录
22:20:07 - article_server - INFO - [SQL执行] 开始执行查询SQL
22:20:07 - article_server - INFO - [SQL语句]
SELECT t.id, t.tag_name
FROM ai_prompt_tags t
INNER JOIN ai_prompt_tags_relation r ON t.id = r.tag_id
WHERE r.prompt_workflow_id = %s
22:20:07 - article_server - INFO - [SQL参数] (25,)
22:20:07 - article_server - INFO - 获取标签列表成功,总数: 0
22:20:07 - article_server - INFO - [API响应] GET /api/prompts/tags/list - IP: 36.27.52.26 - 状态码: 200
22:20:07 - article_server - INFO - [SQL结果] 查询完成,返回 1 条记录
22:20:07 - article_server - INFO - [SQL数据] 查询结果: [{'id': 13, 'tag_name': 'gggggggggggg'}]
22:20:07 - article_server - INFO - [SQL执行] 开始执行查询SQL
22:20:07 - article_server - INFO - [SQL语句]
SELECT t.id, t.tag_name
FROM ai_prompt_tags t
INNER JOIN ai_prompt_tags_relation r ON t.id = r.tag_id
WHERE r.prompt_workflow_id = %s
22:20:07 - article_server - INFO - [SQL参数] (16,)
22:20:07 - article_server - INFO - [SQL结果] 查询完成,返回 0 条记录
22:20:07 - article_server - INFO - [SQL执行] 开始执行查询SQL
22:20:07 - article_server - INFO - [SQL语句]
SELECT t.id, t.tag_name
FROM ai_prompt_tags t
INNER JOIN ai_prompt_tags_relation r ON t.id = r.tag_id
WHERE r.prompt_workflow_id = %s
22:20:07 - article_server - INFO - [SQL参数] (15,)
22:20:07 - article_server - INFO - [SQL结果] 查询完成,返回 0 条记录
22:20:07 - article_server - INFO - [SQL执行] 开始执行查询SQL
22:20:07 - article_server - INFO - [SQL语句]
SELECT t.id, t.tag_name
FROM ai_prompt_tags t
INNER JOIN ai_prompt_tags_relation r ON t.id = r.tag_id
WHERE r.prompt_workflow_id = %s
22:20:07 - article_server - INFO - [SQL参数] (14,)
22:20:07 - article_server - INFO - [SQL结果] 查询完成,返回 0 条记录
22:20:07 - article_server - INFO - [SQL执行] 开始执行查询SQL
22:20:07 - article_server - INFO - [SQL语句]
SELECT t.id, t.tag_name
FROM ai_prompt_tags t
INNER JOIN ai_prompt_tags_relation r ON t.id = r.tag_id
WHERE r.prompt_workflow_id = %s
22:20:07 - article_server - INFO - [SQL参数] (13,)
22:20:07 - article_server - INFO - [SQL结果] 查询完成,返回 0 条记录
22:20:08 - article_server - INFO - [SQL执行] 开始执行查询SQL
22:20:08 - article_server - INFO - [SQL语句]
SELECT t.id, t.tag_name
FROM ai_prompt_tags t
INNER JOIN ai_prompt_tags_relation r ON t.id = r.tag_id
WHERE r.prompt_workflow_id = %s
22:20:08 - article_server - INFO - [SQL参数] (12,)
22:20:08 - article_server - INFO - [SQL结果] 查询完成,返回 0 条记录
22:20:08 - article_server - INFO - [SQL执行] 开始执行查询SQL
22:20:08 - article_server - INFO - [SQL语句]
SELECT t.id, t.tag_name
FROM ai_prompt_tags t
INNER JOIN ai_prompt_tags_relation r ON t.id = r.tag_id
WHERE r.prompt_workflow_id = %s
22:20:08 - article_server - INFO - [SQL参数] (11,)
22:20:08 - article_server - INFO - [SQL结果] 查询完成,返回 0 条记录
22:20:08 - article_server - INFO - [SQL执行] 开始执行查询SQL
22:20:08 - article_server - INFO - [SQL语句]
SELECT t.id, t.tag_name
FROM ai_prompt_tags t
INNER JOIN ai_prompt_tags_relation r ON t.id = r.tag_id
WHERE r.prompt_workflow_id = %s
22:20:08 - article_server - INFO - [SQL参数] (1,)
22:20:08 - article_server - INFO - [SQL结果] 查询完成,返回 0 条记录
22:20:08 - article_server - INFO - 获取提示词列表成功,总数: 8
22:20:08 - article_server - INFO - [API响应] GET /api/prompts/list - IP: 36.27.52.26 - 状态码: 200
22:21:31 - article_server - INFO - [API访问] PUT /api/prompts/25 - IP: 36.27.52.26 - User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/143.0.0.0 Sa
22:21:31 - article_server - INFO - [Token验证成功] 用户ID: 4
22:21:31 - article_server - INFO - [SQL执行] 开始执行查询SQL
22:21:31 - article_server - INFO - [SQL语句] SELECT id FROM ai_prompt_workflow WHERE id = %s AND enterprise_id = %s
22:21:31 - article_server - INFO - [SQL参数] (25, 1)
22:21:31 - article_server - INFO - [SQL结果] 查询完成,返回 1 条记录
22:21:31 - article_server - INFO - [SQL数据] 查询结果: [{'id': 25}]
22:21:32 - article_server - INFO - [SQL执行] 开始执行更新SQL
22:21:32 - article_server - INFO - [SQL语句] UPDATE ai_prompt_workflow SET prompt_workflow_name = %s, content = %s, updated_at = NOW() WHERE id = %s
22:21:32 - article_server - INFO - [SQL参数] ['Inject基础提示词', '你是一个健康类自媒体的编辑每天需要撰写健康类内容。我将要给你一个topic这个topic是一个问句。请你先产生一个段落的回复然后再段展开回复。每个段落都需要用一个emoji开头。最后请生成tag。段落与段落之间空一行保证可读性。\n详细要求如下\n一、核心要求\n1.\t目标受众 普通大众,非专业人士。务必:\n¡\t避免使用专业术语和书面化表达\n¡\t内容安全限制\n\uf06e\t❌ 禁止提及任何人体私密部位或敏感功能\n\uf06e\t❌ 禁用可能引发恐慌的词汇(如"危险""致命"\n2.\t内容核心 围绕“主题”,聚焦病症、问题、危害或困扰, 解释原因、原理,介绍症状、类型,提供积极、实用的解决方案、改善建议或注意事项等有价值的内容均可。\n3.\t唯一性与实用性 生成的内容需确保信息准确(基于常识)且每次生成的内容不应与历史输出重复(针对同一主题多次生成时)。\n二、内容结构及具体要求\n\uf06c\t【首段提问】 (title)\n¡\t对应内容为{{title}}\n\n\uf06c\t【次段简答】 (short-answer)\n¡\t字数 60-120字。 \n **内容要求**\n 1. 第一句话必须直接回答{{title}}的提问可以拓展1-2句话\n 2. 直接明晰,不要太笼统,禁止罗里吧嗦\n 3. 段前不要emoji表情符号\n \n **✅ 合格示例**\n 发现HPV16或18阳性这通常意味着宫颈癌筛查结果显示存在感染。接下来一般会建议做阴道镜检查再根据检查的具体情况决定治疗方案。\n\n **❌ 不合格示例**\n • 使用emoji开头\n • 没有直接回答问题\n • 过于笼统泛泛而谈 \n\n\uf06c\t【分段细答】 (contents)\n¡\t数量要求2-3段。\n¡\t字数要求 60~100字/段。\n¡\t核心要求\n\uf06e\t语言口语化、自然流畅。\n\uf06e\t段落内容必须围绕核心观点展开根据不同情况分类详细阐述问题可以是具体可行的建议吃什么、做什么、注意什么等疾病的科普主要症状、影响、诱因等或者其它逻辑合理的内容也可以。\n\uf06e\t内容有一定的逻辑包括但不限于首先、其次、最后第一第二第三不仅、而且、还有初级、中级、高级。\n\uf06e\t每段内容均衡不超过五句话确保信息全面且易于消化。\n\uf06e\t分段细答部分应当是次段简答部分的延伸但用词不能和次段简答部分有太多重复请保持多样性。\n\uf06e\t 在生成回答前,必须执行以下创造性流程:\n\t\t结构性禁令排除法行文结构不得是“定义→成因→症状→治疗”或“是什么→为什么→怎么办”及其任何变体。\n\t\t动态自我审视核心步骤\n\t\t回顾主动审视历史内容中针对相同或相似主题已使用过的所有核心阐述逻辑。\n\t\t规避明确禁止重复或小幅修改上述任何逻辑。\n\t\t创新基于当前问题的具体内涵生成一个在本质上全新的、服务于核心问题的最佳解释路径。该路径必须与所有已回顾的逻辑存在根本性差异。\n\t\t输出确认最终采用的逻辑结构应是本次对话上下文中一次独特的、未经使用的创造性表达形式。\n\n\uf06c\t【标签】 (tags)\n¡\t**单个关键词字数4-8个字。\n¡\t内容* (1)根据正文内容生成5个内容强相关tag (2)标签格式:每个关键词前后都有# (例: #养生小知识# #中医养生##习惯养成# #健康养生#\n三、变量输入\n\uf06c\t主题 {{title}}\n四、最终安全规则\n4.\t全篇禁止出现人体私密部位描述\n5.\t关键安全信息重复出现≥2次\n6.\t每句话≤20字复合句用逗号分隔\n7、不能出现 "下面就给大家仔细说说"“下面具体讲讲”<E2809D>
22:21:32 - article_server - INFO - [SQL结果] 更新完成,影响 1 行
22:21:32 - article_server - INFO - [SQL执行] 开始执行更新SQL
22:21:32 - article_server - INFO - [SQL语句] DELETE FROM ai_prompt_tags_relation WHERE prompt_workflow_id = %s
22:21:32 - article_server - INFO - [SQL参数] (25,)
22:21:32 - article_server - INFO - [SQL结果] 更新完成,影响 1 行
22:21:32 - article_server - INFO - [SQL执行] 开始执行查询SQL
22:21:32 - article_server - INFO - [SQL语句] SELECT prompt_workflow_name FROM ai_prompt_workflow WHERE id = %s
22:21:32 - article_server - INFO - [SQL参数] (25,)
22:21:32 - article_server - INFO - [SQL结果] 查询完成,返回 1 条记录
22:21:32 - article_server - INFO - [SQL数据] 查询结果: [{'prompt_workflow_name': 'Inject基础提示词'}]
22:21:32 - article_server - INFO - [SQL执行] 开始执行查询SQL
22:21:32 - article_server - INFO - [SQL语句] SELECT id FROM ai_prompt_tags WHERE enterprise_id = %s AND tag_name = %s
22:21:32 - article_server - INFO - [SQL参数] (1, '去重')
22:21:32 - article_server - INFO - [SQL结果] 查询完成,返回 0 条记录
22:21:32 - article_server - INFO - [SQL执行] 开始执行插入SQL
22:21:32 - article_server - INFO - [SQL语句] INSERT INTO ai_prompt_tags (enterprise_id, tag_name, created_user_id) VALUES (%s, %s, %s)
22:21:32 - article_server - INFO - [SQL参数] (1, '去重', 4)
22:21:32 - article_server - INFO - [SQL结果] 插入完成新记录ID: 14
22:21:32 - article_server - INFO - [SQL执行] 开始执行插入SQL
22:21:32 - article_server - INFO - [SQL语句] INSERT INTO ai_prompt_tags_relation (enterprise_id, prompt_workflow_id, prompt_workflow_name, tag_id, tag_name, created_user_id) VALUES (%s, %s, %s, %s, %s, %s)
22:21:32 - article_server - INFO - [SQL参数] (1, 25, 'Inject基础提示词', 14, '去重', 4)
22:21:32 - article_server - INFO - [SQL结果] 插入完成新记录ID: 18
22:21:32 - article_server - INFO - [SQL执行] 开始执行查询SQL
22:21:32 - article_server - INFO - [SQL语句] SELECT id FROM ai_prompt_tags WHERE enterprise_id = %s AND tag_name = %s
22:21:32 - article_server - INFO - [SQL参数] (1, '基础提示词')
22:21:32 - article_server - INFO - [SQL结果] 查询完成,返回 0 条记录
22:21:32 - article_server - INFO - [SQL执行] 开始执行插入SQL
22:21:32 - article_server - INFO - [SQL语句] INSERT INTO ai_prompt_tags (enterprise_id, tag_name, created_user_id) VALUES (%s, %s, %s)
22:21:32 - article_server - INFO - [SQL参数] (1, '基础提示词', 4)
22:21:32 - article_server - INFO - [SQL结果] 插入完成新记录ID: 15
22:21:32 - article_server - INFO - [SQL执行] 开始执行插入SQL
22:21:32 - article_server - INFO - [SQL语句] INSERT INTO ai_prompt_tags_relation (enterprise_id, prompt_workflow_id, prompt_workflow_name, tag_id, tag_name, created_user_id) VALUES (%s, %s, %s, %s, %s, %s)
22:21:32 - article_server - INFO - [SQL参数] (1, 25, 'Inject基础提示词', 15, '基础提示词', 4)
22:21:32 - article_server - INFO - [SQL结果] 插入完成新记录ID: 19
22:21:32 - article_server - INFO - 更新提示词成功: ID 25
22:21:32 - article_server - INFO - [API响应] PUT /api/prompts/25 - IP: 36.27.52.26 - 状态码: 200
22:21:32 - article_server - INFO - [API访问] GET /api/prompts/list - IP: 36.27.52.26 - User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/143.0.0.0 Sa
22:21:32 - article_server - INFO - [Token验证成功] 用户ID: 4
22:21:32 - article_server - INFO - [SQL执行] 开始执行查询SQL
22:21:32 - article_server - INFO - [SQL语句] SELECT COUNT(*) as total FROM ai_prompt_workflow WHERE enterprise_id = %s
22:21:32 - article_server - INFO - [SQL参数] (1,)
22:21:32 - article_server - INFO - [SQL结果] 查询完成,返回 1 条记录
22:21:32 - article_server - INFO - [SQL数据] 查询结果: [{'total': 8}]
22:21:32 - article_server - INFO - [SQL执行] 开始执行查询SQL
22:21:32 - article_server - INFO - [SQL语句]
SELECT id, prompt_workflow_name, workflow_id, content, usage_count, created_at, updated_at
FROM ai_prompt_workflow
WHERE enterprise_id = %s
ORDER BY created_at DESC
LIMIT %s OFFSET %s
22:21:32 - article_server - INFO - [SQL参数] (1, 20, 0)
22:21:32 - article_server - INFO - [SQL结果] 查询完成,返回 8 条记录
22:21:32 - article_server - INFO - [SQL执行] 开始执行查询SQL
22:21:32 - article_server - INFO - [SQL语句]
SELECT t.id, t.tag_name
FROM ai_prompt_tags t
INNER JOIN ai_prompt_tags_relation r ON t.id = r.tag_id
WHERE r.prompt_workflow_id = %s
22:21:32 - article_server - INFO - [SQL参数] (25,)
22:21:32 - article_server - INFO - [SQL结果] 查询完成,返回 2 条记录
22:21:32 - article_server - INFO - [SQL数据] 查询结果: [{'id': 14, 'tag_name': '去重'}, {'id': 15, 'tag_name': '基础提示词'}]
22:21:33 - article_server - INFO - [SQL执行] 开始执行查询SQL
22:21:33 - article_server - INFO - [SQL语句]
SELECT t.id, t.tag_name
FROM ai_prompt_tags t
INNER JOIN ai_prompt_tags_relation r ON t.id = r.tag_id
WHERE r.prompt_workflow_id = %s
22:21:33 - article_server - INFO - [SQL参数] (16,)
22:21:33 - article_server - INFO - [SQL结果] 查询完成,返回 0 条记录
22:21:33 - article_server - INFO - [SQL执行] 开始执行查询SQL
22:21:33 - article_server - INFO - [SQL语句]
SELECT t.id, t.tag_name
FROM ai_prompt_tags t
INNER JOIN ai_prompt_tags_relation r ON t.id = r.tag_id
WHERE r.prompt_workflow_id = %s
22:21:33 - article_server - INFO - [SQL参数] (15,)
22:21:33 - article_server - INFO - [SQL结果] 查询完成,返回 0 条记录
22:21:33 - article_server - INFO - [SQL执行] 开始执行查询SQL
22:21:33 - article_server - INFO - [SQL语句]
SELECT t.id, t.tag_name
FROM ai_prompt_tags t
INNER JOIN ai_prompt_tags_relation r ON t.id = r.tag_id
WHERE r.prompt_workflow_id = %s
22:21:33 - article_server - INFO - [SQL参数] (14,)
22:21:33 - article_server - INFO - [SQL结果] 查询完成,返回 0 条记录
22:21:33 - article_server - INFO - [SQL执行] 开始执行查询SQL
22:21:33 - article_server - INFO - [SQL语句]
SELECT t.id, t.tag_name
FROM ai_prompt_tags t
INNER JOIN ai_prompt_tags_relation r ON t.id = r.tag_id
WHERE r.prompt_workflow_id = %s
22:21:33 - article_server - INFO - [SQL参数] (13,)
22:21:33 - article_server - INFO - [SQL结果] 查询完成,返回 0 条记录
22:21:33 - article_server - INFO - [SQL执行] 开始执行查询SQL
22:21:33 - article_server - INFO - [SQL语句]
SELECT t.id, t.tag_name
FROM ai_prompt_tags t
INNER JOIN ai_prompt_tags_relation r ON t.id = r.tag_id
WHERE r.prompt_workflow_id = %s
22:21:33 - article_server - INFO - [SQL参数] (12,)
22:21:33 - article_server - INFO - [SQL结果] 查询完成,返回 0 条记录
22:21:33 - article_server - INFO - [SQL执行] 开始执行查询SQL
22:21:33 - article_server - INFO - [SQL语句]
SELECT t.id, t.tag_name
FROM ai_prompt_tags t
INNER JOIN ai_prompt_tags_relation r ON t.id = r.tag_id
WHERE r.prompt_workflow_id = %s
22:21:33 - article_server - INFO - [SQL参数] (11,)
22:21:33 - article_server - INFO - [SQL结果] 查询完成,返回 0 条记录
22:21:33 - article_server - INFO - [SQL执行] 开始执行查询SQL
22:21:33 - article_server - INFO - [SQL语句]
SELECT t.id, t.tag_name
FROM ai_prompt_tags t
INNER JOIN ai_prompt_tags_relation r ON t.id = r.tag_id
WHERE r.prompt_workflow_id = %s
22:21:33 - article_server - INFO - [SQL参数] (1,)
22:21:33 - article_server - INFO - [SQL结果] 查询完成,返回 0 条记录
22:21:33 - article_server - INFO - 获取提示词列表成功,总数: 8
22:21:33 - article_server - INFO - [API响应] GET /api/prompts/list - IP: 36.27.52.26 - 状态码: 200
22:21:49 - article_server - INFO - [API访问] DELETE /api/prompts/16 - IP: 36.27.52.26 - User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/143.0.0.0 Sa
22:21:49 - article_server - INFO - [Token验证成功] 用户ID: 4
22:21:49 - article_server - INFO - 数据库连接成功,字符集设置完成
22:21:49 - article_server - INFO - [SQL执行] 开始执行查询SQL
22:21:49 - article_server - INFO - [SQL语句] SELECT id, prompt_workflow_name FROM ai_prompt_workflow WHERE id = %s AND enterprise_id = %s
22:21:49 - article_server - INFO - [SQL参数] (16, 1)
22:21:49 - article_server - INFO - [SQL结果] 查询完成,返回 1 条记录
22:21:49 - article_server - INFO - [SQL数据] 查询结果: [{'id': 16, 'prompt_workflow_name': '测试提示词'}]
22:21:49 - article_server - INFO - [SQL执行] 开始执行更新SQL
22:21:49 - article_server - INFO - [SQL语句] DELETE FROM ai_prompt_tags_relation WHERE prompt_workflow_id = %s
22:21:49 - article_server - INFO - [SQL参数] (16,)
22:21:49 - article_server - INFO - [SQL结果] 更新完成,影响 0 行
22:21:49 - article_server - INFO - [SQL执行] 开始执行更新SQL
22:21:49 - article_server - INFO - [SQL语句] DELETE FROM ai_prompt_workflow WHERE id = %s
22:21:49 - article_server - INFO - [SQL参数] (16,)
22:21:49 - article_server - INFO - [SQL结果] 更新完成,影响 1 行
22:21:49 - article_server - INFO - 删除提示词成功: 测试提示词
22:21:49 - article_server - INFO - [API响应] DELETE /api/prompts/16 - IP: 36.27.52.26 - 状态码: 200
22:21:49 - article_server - INFO - [API访问] GET /api/prompts/list - IP: 36.27.52.26 - User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/143.0.0.0 Sa
22:21:49 - article_server - INFO - [Token验证成功] 用户ID: 4
22:21:49 - article_server - INFO - [SQL执行] 开始执行查询SQL
22:21:49 - article_server - INFO - [SQL语句] SELECT COUNT(*) as total FROM ai_prompt_workflow WHERE enterprise_id = %s
22:21:49 - article_server - INFO - [SQL参数] (1,)
22:21:49 - article_server - INFO - [SQL结果] 查询完成,返回 1 条记录
22:21:49 - article_server - INFO - [SQL数据] 查询结果: [{'total': 7}]
22:21:49 - article_server - INFO - [SQL执行] 开始执行查询SQL
22:21:49 - article_server - INFO - [SQL语句]
SELECT id, prompt_workflow_name, workflow_id, content, usage_count, created_at, updated_at
FROM ai_prompt_workflow
WHERE enterprise_id = %s
ORDER BY created_at DESC
LIMIT %s OFFSET %s
22:21:49 - article_server - INFO - [SQL参数] (1, 20, 0)
22:21:49 - article_server - INFO - [SQL结果] 查询完成,返回 7 条记录
22:21:49 - article_server - INFO - [SQL执行] 开始执行查询SQL
22:21:49 - article_server - INFO - [SQL语句]
SELECT t.id, t.tag_name
FROM ai_prompt_tags t
INNER JOIN ai_prompt_tags_relation r ON t.id = r.tag_id
WHERE r.prompt_workflow_id = %s
22:21:49 - article_server - INFO - [SQL参数] (25,)
22:21:49 - article_server - INFO - [SQL结果] 查询完成,返回 2 条记录
22:21:49 - article_server - INFO - [SQL数据] 查询结果: [{'id': 14, 'tag_name': '去重'}, {'id': 15, 'tag_name': '基础提示词'}]
22:21:49 - article_server - INFO - [SQL执行] 开始执行查询SQL
22:21:49 - article_server - INFO - [SQL语句]
SELECT t.id, t.tag_name
FROM ai_prompt_tags t
INNER JOIN ai_prompt_tags_relation r ON t.id = r.tag_id
WHERE r.prompt_workflow_id = %s
22:21:49 - article_server - INFO - [SQL参数] (15,)
22:21:49 - article_server - INFO - [SQL结果] 查询完成,返回 0 条记录
22:21:49 - article_server - INFO - [SQL执行] 开始执行查询SQL
22:21:49 - article_server - INFO - [SQL语句]
SELECT t.id, t.tag_name
FROM ai_prompt_tags t
INNER JOIN ai_prompt_tags_relation r ON t.id = r.tag_id
WHERE r.prompt_workflow_id = %s
22:21:49 - article_server - INFO - [SQL参数] (14,)
22:21:49 - article_server - INFO - [SQL结果] 查询完成,返回 0 条记录
22:21:49 - article_server - INFO - [SQL执行] 开始执行查询SQL
22:21:49 - article_server - INFO - [SQL语句]
SELECT t.id, t.tag_name
FROM ai_prompt_tags t
INNER JOIN ai_prompt_tags_relation r ON t.id = r.tag_id
WHERE r.prompt_workflow_id = %s
22:21:49 - article_server - INFO - [SQL参数] (13,)
22:21:49 - article_server - INFO - [SQL结果] 查询完成,返回 0 条记录
22:21:50 - article_server - INFO - [SQL执行] 开始执行查询SQL
22:21:50 - article_server - INFO - [SQL语句]
SELECT t.id, t.tag_name
FROM ai_prompt_tags t
INNER JOIN ai_prompt_tags_relation r ON t.id = r.tag_id
WHERE r.prompt_workflow_id = %s
22:21:50 - article_server - INFO - [SQL参数] (12,)
22:21:50 - article_server - INFO - [SQL结果] 查询完成,返回 0 条记录
22:21:50 - article_server - INFO - [SQL执行] 开始执行查询SQL
22:21:50 - article_server - INFO - [SQL语句]
SELECT t.id, t.tag_name
FROM ai_prompt_tags t
INNER JOIN ai_prompt_tags_relation r ON t.id = r.tag_id
WHERE r.prompt_workflow_id = %s
22:21:50 - article_server - INFO - [SQL参数] (11,)
22:21:50 - article_server - INFO - [SQL结果] 查询完成,返回 0 条记录
22:21:50 - article_server - INFO - [SQL执行] 开始执行查询SQL
22:21:50 - article_server - INFO - [SQL语句]
SELECT t.id, t.tag_name
FROM ai_prompt_tags t
INNER JOIN ai_prompt_tags_relation r ON t.id = r.tag_id
WHERE r.prompt_workflow_id = %s
22:21:50 - article_server - INFO - [SQL参数] (1,)
22:21:50 - article_server - INFO - [SQL结果] 查询完成,返回 0 条记录
22:21:50 - article_server - INFO - 获取提示词列表成功,总数: 7
22:21:50 - article_server - INFO - [API响应] GET /api/prompts/list - IP: 36.27.52.26 - 状态码: 200
22:21:53 - article_server - INFO - [API访问] DELETE /api/prompts/15 - IP: 36.27.52.26 - User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/143.0.0.0 Sa
22:21:53 - article_server - INFO - [Token验证成功] 用户ID: 4
22:21:53 - article_server - INFO - [SQL执行] 开始执行查询SQL
22:21:53 - article_server - INFO - [SQL语句] SELECT id, prompt_workflow_name FROM ai_prompt_workflow WHERE id = %s AND enterprise_id = %s
22:21:53 - article_server - INFO - [SQL参数] (15, 1)
22:21:53 - article_server - INFO - [SQL结果] 查询完成,返回 1 条记录
22:21:53 - article_server - INFO - [SQL数据] 查询结果: [{'id': 15, 'prompt_workflow_name': '测试提示词'}]
22:21:53 - article_server - INFO - [SQL执行] 开始执行更新SQL
22:21:53 - article_server - INFO - [SQL语句] DELETE FROM ai_prompt_tags_relation WHERE prompt_workflow_id = %s
22:21:53 - article_server - INFO - [SQL参数] (15,)
22:21:53 - article_server - INFO - [SQL结果] 更新完成,影响 0 行
22:21:54 - article_server - INFO - [SQL执行] 开始执行更新SQL
22:21:54 - article_server - INFO - [SQL语句] DELETE FROM ai_prompt_workflow WHERE id = %s
22:21:54 - article_server - INFO - [SQL参数] (15,)
22:21:54 - article_server - INFO - [SQL结果] 更新完成,影响 1 行
22:21:54 - article_server - INFO - 删除提示词成功: 测试提示词
22:21:54 - article_server - INFO - [API响应] DELETE /api/prompts/15 - IP: 36.27.52.26 - 状态码: 200
22:21:54 - article_server - INFO - [API访问] GET /api/prompts/list - IP: 36.27.52.26 - User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/143.0.0.0 Sa
22:21:54 - article_server - INFO - [Token验证成功] 用户ID: 4
22:21:54 - article_server - INFO - [SQL执行] 开始执行查询SQL
22:21:54 - article_server - INFO - [SQL语句] SELECT COUNT(*) as total FROM ai_prompt_workflow WHERE enterprise_id = %s
22:21:54 - article_server - INFO - [SQL参数] (1,)
22:21:54 - article_server - INFO - [SQL结果] 查询完成,返回 1 条记录
22:21:54 - article_server - INFO - [SQL数据] 查询结果: [{'total': 6}]
22:21:54 - article_server - INFO - [SQL执行] 开始执行查询SQL
22:21:54 - article_server - INFO - [SQL语句]
SELECT id, prompt_workflow_name, workflow_id, content, usage_count, created_at, updated_at
FROM ai_prompt_workflow
WHERE enterprise_id = %s
ORDER BY created_at DESC
LIMIT %s OFFSET %s
22:21:54 - article_server - INFO - [SQL参数] (1, 20, 0)
22:21:54 - article_server - INFO - [SQL结果] 查询完成,返回 6 条记录
22:21:54 - article_server - INFO - [SQL执行] 开始执行查询SQL
22:21:54 - article_server - INFO - [SQL语句]
SELECT t.id, t.tag_name
FROM ai_prompt_tags t
INNER JOIN ai_prompt_tags_relation r ON t.id = r.tag_id
WHERE r.prompt_workflow_id = %s
22:21:54 - article_server - INFO - [SQL参数] (25,)
22:21:54 - article_server - INFO - [SQL结果] 查询完成,返回 2 条记录
22:21:54 - article_server - INFO - [SQL数据] 查询结果: [{'id': 14, 'tag_name': '去重'}, {'id': 15, 'tag_name': '基础提示词'}]
22:21:54 - article_server - INFO - [SQL执行] 开始执行查询SQL
22:21:54 - article_server - INFO - [SQL语句]
SELECT t.id, t.tag_name
FROM ai_prompt_tags t
INNER JOIN ai_prompt_tags_relation r ON t.id = r.tag_id
WHERE r.prompt_workflow_id = %s
22:21:54 - article_server - INFO - [SQL参数] (14,)
22:21:54 - article_server - INFO - [SQL结果] 查询完成,返回 0 条记录
22:21:54 - article_server - INFO - [SQL执行] 开始执行查询SQL
22:21:54 - article_server - INFO - [SQL语句]
SELECT t.id, t.tag_name
FROM ai_prompt_tags t
INNER JOIN ai_prompt_tags_relation r ON t.id = r.tag_id
WHERE r.prompt_workflow_id = %s
22:21:54 - article_server - INFO - [SQL参数] (13,)
22:21:54 - article_server - INFO - [SQL结果] 查询完成,返回 0 条记录
22:21:54 - article_server - INFO - [SQL执行] 开始执行查询SQL
22:21:54 - article_server - INFO - [SQL语句]
SELECT t.id, t.tag_name
FROM ai_prompt_tags t
INNER JOIN ai_prompt_tags_relation r ON t.id = r.tag_id
WHERE r.prompt_workflow_id = %s
22:21:54 - article_server - INFO - [SQL参数] (12,)
22:21:54 - article_server - INFO - [SQL结果] 查询完成,返回 0 条记录
22:21:54 - article_server - INFO - [SQL执行] 开始执行查询SQL
22:21:54 - article_server - INFO - [SQL语句]
SELECT t.id, t.tag_name
FROM ai_prompt_tags t
INNER JOIN ai_prompt_tags_relation r ON t.id = r.tag_id
WHERE r.prompt_workflow_id = %s
22:21:54 - article_server - INFO - [SQL参数] (11,)
22:21:54 - article_server - INFO - [SQL结果] 查询完成,返回 0 条记录
22:21:54 - article_server - INFO - [SQL执行] 开始执行查询SQL
22:21:54 - article_server - INFO - [SQL语句]
SELECT t.id, t.tag_name
FROM ai_prompt_tags t
INNER JOIN ai_prompt_tags_relation r ON t.id = r.tag_id
WHERE r.prompt_workflow_id = %s
22:21:54 - article_server - INFO - [SQL参数] (1,)
22:21:54 - article_server - INFO - [SQL结果] 查询完成,返回 0 条记录
22:21:54 - article_server - INFO - 获取提示词列表成功,总数: 6
22:21:54 - article_server - INFO - [API响应] GET /api/prompts/list - IP: 36.27.52.26 - 状态码: 200
22:22:00 - article_server - INFO - [API访问] DELETE /api/prompts/12 - IP: 36.27.52.26 - User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/143.0.0.0 Sa
22:22:00 - article_server - INFO - [Token验证成功] 用户ID: 4
22:22:00 - article_server - INFO - [SQL执行] 开始执行查询SQL
22:22:00 - article_server - INFO - [SQL语句] SELECT id, prompt_workflow_name FROM ai_prompt_workflow WHERE id = %s AND enterprise_id = %s
22:22:00 - article_server - INFO - [SQL参数] (12, 1)
22:22:00 - article_server - INFO - [SQL结果] 查询完成,返回 1 条记录
22:22:00 - article_server - INFO - [SQL数据] 查询结果: [{'id': 12, 'prompt_workflow_name': '测试提示词'}]
22:22:00 - article_server - INFO - [SQL执行] 开始执行更新SQL
22:22:00 - article_server - INFO - [SQL语句] DELETE FROM ai_prompt_tags_relation WHERE prompt_workflow_id = %s
22:22:00 - article_server - INFO - [SQL参数] (12,)
22:22:00 - article_server - INFO - [SQL结果] 更新完成,影响 0 行
22:22:00 - article_server - INFO - [SQL执行] 开始执行更新SQL
22:22:00 - article_server - INFO - [SQL语句] DELETE FROM ai_prompt_workflow WHERE id = %s
22:22:00 - article_server - INFO - [SQL参数] (12,)
22:22:00 - article_server - INFO - [SQL结果] 更新完成,影响 1 行
22:22:00 - article_server - INFO - 删除提示词成功: 测试提示词
22:22:00 - article_server - INFO - [API响应] DELETE /api/prompts/12 - IP: 36.27.52.26 - 状态码: 200
22:22:00 - article_server - INFO - [API访问] GET /api/prompts/list - IP: 36.27.52.26 - User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/143.0.0.0 Sa
22:22:00 - article_server - INFO - [Token验证成功] 用户ID: 4
22:22:00 - article_server - INFO - 数据库连接成功,字符集设置完成
22:22:00 - article_server - INFO - [SQL执行] 开始执行查询SQL
22:22:00 - article_server - INFO - [SQL语句] SELECT COUNT(*) as total FROM ai_prompt_workflow WHERE enterprise_id = %s
22:22:00 - article_server - INFO - [SQL参数] (1,)
22:22:00 - article_server - INFO - [SQL结果] 查询完成,返回 1 条记录
22:22:00 - article_server - INFO - [SQL数据] 查询结果: [{'total': 5}]
22:22:00 - article_server - INFO - [SQL执行] 开始执行查询SQL
22:22:00 - article_server - INFO - [SQL语句]
SELECT id, prompt_workflow_name, workflow_id, content, usage_count, created_at, updated_at
FROM ai_prompt_workflow
WHERE enterprise_id = %s
ORDER BY created_at DESC
LIMIT %s OFFSET %s
22:22:00 - article_server - INFO - [SQL参数] (1, 20, 0)
22:22:00 - article_server - INFO - [SQL结果] 查询完成,返回 5 条记录
22:22:00 - article_server - INFO - [SQL执行] 开始执行查询SQL
22:22:00 - article_server - INFO - [SQL语句]
SELECT t.id, t.tag_name
FROM ai_prompt_tags t
INNER JOIN ai_prompt_tags_relation r ON t.id = r.tag_id
WHERE r.prompt_workflow_id = %s
22:22:00 - article_server - INFO - [SQL参数] (25,)
22:22:00 - article_server - INFO - [SQL结果] 查询完成,返回 2 条记录
22:22:00 - article_server - INFO - [SQL数据] 查询结果: [{'id': 14, 'tag_name': '去重'}, {'id': 15, 'tag_name': '基础提示词'}]
22:22:00 - article_server - INFO - [SQL执行] 开始执行查询SQL
22:22:00 - article_server - INFO - [SQL语句]
SELECT t.id, t.tag_name
FROM ai_prompt_tags t
INNER JOIN ai_prompt_tags_relation r ON t.id = r.tag_id
WHERE r.prompt_workflow_id = %s
22:22:00 - article_server - INFO - [SQL参数] (14,)
22:22:00 - article_server - INFO - [SQL结果] 查询完成,返回 0 条记录
22:22:00 - article_server - INFO - [SQL执行] 开始执行查询SQL
22:22:00 - article_server - INFO - [SQL语句]
SELECT t.id, t.tag_name
FROM ai_prompt_tags t
INNER JOIN ai_prompt_tags_relation r ON t.id = r.tag_id
WHERE r.prompt_workflow_id = %s
22:22:00 - article_server - INFO - [SQL参数] (13,)
22:22:00 - article_server - INFO - [SQL结果] 查询完成,返回 0 条记录
22:22:00 - article_server - INFO - [SQL执行] 开始执行查询SQL
22:22:00 - article_server - INFO - [SQL语句]
SELECT t.id, t.tag_name
FROM ai_prompt_tags t
INNER JOIN ai_prompt_tags_relation r ON t.id = r.tag_id
WHERE r.prompt_workflow_id = %s
22:22:00 - article_server - INFO - [SQL参数] (11,)
22:22:00 - article_server - INFO - [SQL结果] 查询完成,返回 0 条记录
22:22:01 - article_server - INFO - [SQL执行] 开始执行查询SQL
22:22:01 - article_server - INFO - [SQL语句]
SELECT t.id, t.tag_name
FROM ai_prompt_tags t
INNER JOIN ai_prompt_tags_relation r ON t.id = r.tag_id
WHERE r.prompt_workflow_id = %s
22:22:01 - article_server - INFO - [SQL参数] (1,)
22:22:01 - article_server - INFO - [SQL结果] 查询完成,返回 0 条记录
22:22:01 - article_server - INFO - 获取提示词列表成功,总数: 5
22:22:01 - article_server - INFO - [API响应] GET /api/prompts/list - IP: 36.27.52.26 - 状态码: 200
22:22:03 - article_server - INFO - [API访问] DELETE /api/prompts/11 - IP: 36.27.52.26 - User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/143.0.0.0 Sa
22:22:03 - article_server - INFO - [Token验证成功] 用户ID: 4
22:22:04 - article_server - INFO - [SQL执行] 开始执行查询SQL
22:22:04 - article_server - INFO - [SQL语句] SELECT id, prompt_workflow_name FROM ai_prompt_workflow WHERE id = %s AND enterprise_id = %s
22:22:04 - article_server - INFO - [SQL参数] (11, 1)
22:22:04 - article_server - INFO - [SQL结果] 查询完成,返回 1 条记录
22:22:04 - article_server - INFO - [SQL数据] 查询结果: [{'id': 11, 'prompt_workflow_name': '测试提示词'}]
22:22:04 - article_server - INFO - [SQL执行] 开始执行更新SQL
22:22:04 - article_server - INFO - [SQL语句] DELETE FROM ai_prompt_tags_relation WHERE prompt_workflow_id = %s
22:22:04 - article_server - INFO - [SQL参数] (11,)
22:22:04 - article_server - INFO - [SQL结果] 更新完成,影响 0 行
22:22:04 - article_server - INFO - [SQL执行] 开始执行更新SQL
22:22:04 - article_server - INFO - [SQL语句] DELETE FROM ai_prompt_workflow WHERE id = %s
22:22:04 - article_server - INFO - [SQL参数] (11,)
22:22:04 - article_server - INFO - [SQL结果] 更新完成,影响 1 行
22:22:04 - article_server - INFO - 删除提示词成功: 测试提示词
22:22:04 - article_server - INFO - [API响应] DELETE /api/prompts/11 - IP: 36.27.52.26 - 状态码: 200
22:22:04 - article_server - INFO - [API访问] GET /api/prompts/list - IP: 36.27.52.26 - User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/143.0.0.0 Sa
22:22:04 - article_server - INFO - [Token验证成功] 用户ID: 4
22:22:04 - article_server - INFO - [SQL执行] 开始执行查询SQL
22:22:04 - article_server - INFO - [SQL语句] SELECT COUNT(*) as total FROM ai_prompt_workflow WHERE enterprise_id = %s
22:22:04 - article_server - INFO - [SQL参数] (1,)
22:22:04 - article_server - INFO - [SQL结果] 查询完成,返回 1 条记录
22:22:04 - article_server - INFO - [SQL数据] 查询结果: [{'total': 4}]
22:22:04 - article_server - INFO - [SQL执行] 开始执行查询SQL
22:22:04 - article_server - INFO - [SQL语句]
SELECT id, prompt_workflow_name, workflow_id, content, usage_count, created_at, updated_at
FROM ai_prompt_workflow
WHERE enterprise_id = %s
ORDER BY created_at DESC
LIMIT %s OFFSET %s
22:22:04 - article_server - INFO - [SQL参数] (1, 20, 0)
22:22:04 - article_server - INFO - [SQL结果] 查询完成,返回 4 条记录
22:22:04 - article_server - INFO - [SQL执行] 开始执行查询SQL
22:22:04 - article_server - INFO - [SQL语句]
SELECT t.id, t.tag_name
FROM ai_prompt_tags t
INNER JOIN ai_prompt_tags_relation r ON t.id = r.tag_id
WHERE r.prompt_workflow_id = %s
22:22:04 - article_server - INFO - [SQL参数] (25,)
22:22:04 - article_server - INFO - [SQL结果] 查询完成,返回 2 条记录
22:22:04 - article_server - INFO - [SQL数据] 查询结果: [{'id': 14, 'tag_name': '去重'}, {'id': 15, 'tag_name': '基础提示词'}]
22:22:04 - article_server - INFO - [SQL执行] 开始执行查询SQL
22:22:04 - article_server - INFO - [SQL语句]
SELECT t.id, t.tag_name
FROM ai_prompt_tags t
INNER JOIN ai_prompt_tags_relation r ON t.id = r.tag_id
WHERE r.prompt_workflow_id = %s
22:22:04 - article_server - INFO - [SQL参数] (14,)
22:22:04 - article_server - INFO - [SQL结果] 查询完成,返回 0 条记录
22:22:04 - article_server - INFO - [SQL执行] 开始执行查询SQL
22:22:04 - article_server - INFO - [SQL语句]
SELECT t.id, t.tag_name
FROM ai_prompt_tags t
INNER JOIN ai_prompt_tags_relation r ON t.id = r.tag_id
WHERE r.prompt_workflow_id = %s
22:22:04 - article_server - INFO - [SQL参数] (13,)
22:22:04 - article_server - INFO - [SQL结果] 查询完成,返回 0 条记录
22:22:04 - article_server - INFO - [SQL执行] 开始执行查询SQL
22:22:04 - article_server - INFO - [SQL语句]
SELECT t.id, t.tag_name
FROM ai_prompt_tags t
INNER JOIN ai_prompt_tags_relation r ON t.id = r.tag_id
WHERE r.prompt_workflow_id = %s
22:22:04 - article_server - INFO - [SQL参数] (1,)
22:22:04 - article_server - INFO - [SQL结果] 查询完成,返回 0 条记录
22:22:04 - article_server - INFO - 获取提示词列表成功,总数: 4
22:22:04 - article_server - INFO - [API响应] GET /api/prompts/list - IP: 36.27.52.26 - 状态码: 200
22:22:07 - article_server - INFO - [API访问] DELETE /api/prompts/13 - IP: 36.27.52.26 - User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/143.0.0.0 Sa
22:22:07 - article_server - INFO - [Token验证成功] 用户ID: 4
22:22:07 - article_server - INFO - [SQL执行] 开始执行查询SQL
22:22:07 - article_server - INFO - [SQL语句] SELECT id, prompt_workflow_name FROM ai_prompt_workflow WHERE id = %s AND enterprise_id = %s
22:22:07 - article_server - INFO - [SQL参数] (13, 1)
22:22:07 - article_server - INFO - [SQL结果] 查询完成,返回 1 条记录
22:22:07 - article_server - INFO - [SQL数据] 查询结果: [{'id': 13, 'prompt_workflow_name': '测试提示词'}]
22:22:07 - article_server - INFO - [SQL执行] 开始执行更新SQL
22:22:07 - article_server - INFO - [SQL语句] DELETE FROM ai_prompt_tags_relation WHERE prompt_workflow_id = %s
22:22:07 - article_server - INFO - [SQL参数] (13,)
22:22:07 - article_server - INFO - [SQL结果] 更新完成,影响 0 行
22:22:07 - article_server - INFO - [SQL执行] 开始执行更新SQL
22:22:07 - article_server - INFO - [SQL语句] DELETE FROM ai_prompt_workflow WHERE id = %s
22:22:07 - article_server - INFO - [SQL参数] (13,)
22:22:07 - article_server - INFO - [SQL结果] 更新完成,影响 1 行
22:22:07 - article_server - INFO - 删除提示词成功: 测试提示词
22:22:07 - article_server - INFO - [API响应] DELETE /api/prompts/13 - IP: 36.27.52.26 - 状态码: 200
22:22:08 - article_server - INFO - [API访问] GET /api/prompts/list - IP: 36.27.52.26 - User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/143.0.0.0 Sa
22:22:08 - article_server - INFO - [Token验证成功] 用户ID: 4
22:22:08 - article_server - INFO - [SQL执行] 开始执行查询SQL
22:22:08 - article_server - INFO - [SQL语句] SELECT COUNT(*) as total FROM ai_prompt_workflow WHERE enterprise_id = %s
22:22:08 - article_server - INFO - [SQL参数] (1,)
22:22:08 - article_server - INFO - [SQL结果] 查询完成,返回 1 条记录
22:22:08 - article_server - INFO - [SQL数据] 查询结果: [{'total': 3}]
22:22:08 - article_server - INFO - [SQL执行] 开始执行查询SQL
22:22:08 - article_server - INFO - [SQL语句]
SELECT id, prompt_workflow_name, workflow_id, content, usage_count, created_at, updated_at
FROM ai_prompt_workflow
WHERE enterprise_id = %s
ORDER BY created_at DESC
LIMIT %s OFFSET %s
22:22:08 - article_server - INFO - [SQL参数] (1, 20, 0)
22:22:08 - article_server - INFO - [SQL结果] 查询完成,返回 3 条记录
22:22:08 - article_server - INFO - [SQL数据] 查询结果: [{'id': 25, 'prompt_workflow_name': 'Inject基础提示词', 'workflow_id': 'WF-51A137DE', 'content': '你是一个健康类自媒体的编辑每天需要撰写健康类内容。我将要给你一个topic这个topic是一个问句。请你先产生一个段落的回复然后再段展开回复。每个段落都需要用一个emoji开头。最后请生成tag。段落与段落之间空一行保证可读性。\n详细要求如下\n一、核心要求\n1.\t目标受众 普通大众,非专业人士。务必:\n¡\t避免使用专业术语和书面化表达\n¡\t内容安全限制\n\uf06e\t❌ 禁止提及任何人体私密部位或敏感功能\n\uf06e\t❌ 禁用可能引发恐慌的词汇(如"危险""致命"\n2.\t内容核心 围绕“主题”,聚焦病症、问题、危害或困扰, 解释原因、原理,介绍症状、类型,提供积极、实用的解决方案、改善建议或注意事项等有价值的内容均可。\n3.\t唯一性与实用性 生成的内容需确保信息准确(基于常识)且每次生成的内容不应与历史输出重复(针对同一主题多次生成时)。\n二、内容结构及具体要求\n\uf06c\t【首段提问】 (title)\n¡\t对应内容为{{title}}\n\n\uf06c\t【次段简答】 (short-answer)\n¡\t字数 60-120字。 \n **内容要求**\n 1. 第一句话必须直接回答{{title}}的提问可以拓展1-2句话\n 2. 直接明晰,不要太笼统,禁止罗里吧嗦\n 3. 段前不要emoji表情符号\n \n **✅ 合格示例**\n 发现HPV16或18阳性这通常意味着宫颈癌筛查结果显示存在感染。接下来一般会建议做阴道镜检查再根据检查的具体情况决定治疗方案。\n\n **❌ 不合格示例**\n • 使用emoji开头\n • 没有直接回答问题\n • 过于笼统泛泛而谈 \n\n\uf06c\t【分段细答】 (contents)\n¡\t数量要求2-3段。\n¡\t字数要求 60~100字/段。\n¡\t核心要求\n\uf06e\t语言口语化、自然流畅。\n\uf06e\t段落内容必须围绕核心观点展开根据不同情况分类详细阐述问题可以是具体可行的建议吃什么、做什么、注意什么等疾病的科普主要症状、影响、诱因等或者其它逻辑合理的内容也可以。\n\uf06e\t内容有一定的逻辑包括但不限于首先、其次、最后第一第二第三不仅、而且、还有初级、中级、高级。\n\uf06e\t每段内容均衡不超过五句话确保信息全面且易于消化。\n\uf06e\t分段细答部分应当是次段简答部分的延伸但用词不能和次段简答部分有太多重复请保持多样性。\n\uf06e\t 在生成回答前,必须执行以下创造性流程:\n\t\t结构性禁令排除法行文结构不得是“定义→成因→症状→治疗”或“是什么→为什么→怎么办”及其任何变体。\n\t\t动态自我审视核心步骤\n\t\t回顾主动审视历史内容中针对相同或相似主题已使用过的所有核心阐述逻辑。\n\t\t规避明确禁止重复或小幅修改上述任何逻辑。\n\t\t创新基于当前问题的具体内涵生成一个在本质上全新的、服务于核心问题的最佳解释路径。该路径必须与所有已回顾的逻辑存在根本性差异。\n\t\t输出确认最终采用的逻辑结构应是本次对话上下文中一次独特的、未经使用的创造性表达形式。\n\n\uf06c\t【标签】 (tags)\n¡\t**单个关键词字数4-8个字。\n¡\t内容* (1)根据正文内容生成5个内容强相关tag (2)标签格式:每个关键词前后都有# (例: #养生小知识# #中医养生##习惯养成# #健康养生#\n三、变量输入\n\uf06c\t主题 {{title}}\n四、最终安全规则\n4.\t全篇禁止出现人体私密部位描述\n5.\t关键安全信息重复出现≥2次\n6.\t每句话≤20字复合句用逗<E794A8>
22:22:08 - article_server - INFO - [SQL执行] 开始执行查询SQL
22:22:08 - article_server - INFO - [SQL语句]
SELECT t.id, t.tag_name
FROM ai_prompt_tags t
INNER JOIN ai_prompt_tags_relation r ON t.id = r.tag_id
WHERE r.prompt_workflow_id = %s
22:22:08 - article_server - INFO - [SQL参数] (25,)
22:22:08 - article_server - INFO - [SQL结果] 查询完成,返回 2 条记录
22:22:08 - article_server - INFO - [SQL数据] 查询结果: [{'id': 14, 'tag_name': '去重'}, {'id': 15, 'tag_name': '基础提示词'}]
22:22:08 - article_server - INFO - [SQL执行] 开始执行查询SQL
22:22:08 - article_server - INFO - [SQL语句]
SELECT t.id, t.tag_name
FROM ai_prompt_tags t
INNER JOIN ai_prompt_tags_relation r ON t.id = r.tag_id
WHERE r.prompt_workflow_id = %s
22:22:08 - article_server - INFO - [SQL参数] (14,)
22:22:08 - article_server - INFO - [SQL结果] 查询完成,返回 0 条记录
22:22:08 - article_server - INFO - [SQL执行] 开始执行查询SQL
22:22:08 - article_server - INFO - [SQL语句]
SELECT t.id, t.tag_name
FROM ai_prompt_tags t
INNER JOIN ai_prompt_tags_relation r ON t.id = r.tag_id
WHERE r.prompt_workflow_id = %s
22:22:08 - article_server - INFO - [SQL参数] (1,)
22:22:08 - article_server - INFO - [SQL结果] 查询完成,返回 0 条记录
22:22:08 - article_server - INFO - 获取提示词列表成功,总数: 3
22:22:08 - article_server - INFO - [API响应] GET /api/prompts/list - IP: 36.27.52.26 - 状态码: 200
22:22:11 - article_server - INFO - [API访问] GET /api/articles/list - IP: 36.27.52.26 - User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/143.0.0.0 Sa
22:22:11 - article_server - INFO - [Token验证成功] 用户ID: 4
22:22:11 - article_server - INFO - [获取文章列表] 开始处理请求, IP: 36.27.52.26
22:22:11 - article_server - INFO - [获取文章列表] 用户信息 - 用户ID: 4, 企业ID: 1, IP: 36.27.52.26
22:22:11 - article_server - INFO - [获取文章列表] 查询参数: page=1, pageSize=20, keyword=, product_id=, status=, 企业ID: 1, IP: 36.27.52.26
22:22:11 - article_server - INFO - [SQL执行] 开始执行查询SQL
22:22:11 - article_server - INFO - [SQL语句]
SELECT COUNT(*) as total
FROM ai_articles a
WHERE a.enterprise_id = %s
22:22:11 - article_server - INFO - [SQL参数] [1]
22:22:11 - article_server - INFO - [SQL结果] 查询完成,返回 1 条记录
22:22:11 - article_server - INFO - [SQL数据] 查询结果: [{'total': 12}]
22:22:11 - article_server - INFO - [API访问] GET /api/articles/list_dashboard - IP: 36.27.52.26 - User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/143.0.0.0 Sa
22:22:11 - article_server - INFO - [Token验证成功] 用户ID: 4
22:22:11 - article_server - INFO - [文章仪表盘] 开始处理请求, IP: 36.27.52.26
22:22:11 - article_server - INFO - [API访问] GET /api/products/list - IP: 36.27.52.26 - User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/143.0.0.0 Sa
22:22:11 - article_server - INFO - [Token验证成功] 用户ID: 4
22:22:11 - article_server - INFO - [获取产品列表] 开始处理请求, IP: 36.27.52.26
22:22:11 - article_server - INFO - [获取产品列表] 用户信息 - 用户ID: 4, 企业ID: 1, IP: 36.27.52.26
22:22:11 - article_server - INFO - [获取产品列表] 查询参数: page=1, pageSize=100, keyword=, type=, status=, 企业ID: 1, IP: 36.27.52.26
22:22:11 - article_server - INFO - [SQL执行] 开始执行查询SQL
22:22:11 - article_server - INFO - [SQL语句]
SELECT COUNT(id) as total
FROM ai_articles
WHERE enterprise_id = %s
22:22:11 - article_server - INFO - [SQL参数] (1,)
22:22:11 - article_server - INFO - [API访问] GET /api/prompts/list - IP: 36.27.52.26 - User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/143.0.0.0 Sa
22:22:11 - article_server - INFO - [Token验证成功] 用户ID: 4
22:22:11 - article_server - INFO - [SQL执行] 开始执行查询SQL
22:22:11 - article_server - INFO - [SQL语句]
SELECT a.id, a.batch_id, a.enterprise_id, a.product_id, a.topic_type_id,
a.prompt_workflow_id, a.topic, a.title, a.content, a.department,
a.departmentids, a.author_id, a.author_name, a.department_id, a.department_name,
a.created_user_id, a.review_user_id, a.publish_user_id, a.status, a.channel,
a.review_comment, a.publish_time, a.publish_link, a.baijiahao_id, a.baijiahao_status,
a.word_count, a.image_count, a.coze_tag, a.created_at, a.updated_at,
p.name as product_name,
pw.prompt_workflow_name as prompt_name
FROM ai_articles a
LEFT JOIN ai_products p ON a.product_id = p.id
LEFT JOIN ai_prompt_workflow pw ON a.prompt_workflow_id = pw.id
WHERE a.enterprise_id = %s
ORDER BY a.created_at DESC
LIMIT %s OFFSET %s
22:22:11 - article_server - INFO - [SQL参数] [1, 20, 0]
22:22:11 - article_server - INFO - [SQL执行] 开始执行查询SQL
22:22:11 - article_server - INFO - [SQL语句] SELECT COUNT(*) as total FROM ai_products WHERE enterprise_id = %s AND status != 'deleted'
22:22:11 - article_server - INFO - [SQL参数] [1]
22:22:11 - article_server - INFO - [SQL结果] 查询完成,返回 1 条记录
22:22:11 - article_server - INFO - [SQL数据] 查询结果: [{'total': 12}]
22:22:11 - article_server - INFO - [SQL执行] 开始执行查询SQL
22:22:11 - article_server - INFO - [SQL语句] SELECT COUNT(*) as total FROM ai_prompt_workflow WHERE enterprise_id = %s
22:22:11 - article_server - INFO - [SQL参数] (1,)
22:22:11 - article_server - INFO - [SQL结果] 查询完成,返回 12 条记录
22:22:11 - article_server - INFO - [SQL结果] 查询完成,返回 1 条记录
22:22:11 - article_server - INFO - [SQL数据] 查询结果: [{'total': 5}]
22:22:11 - article_server - INFO - [SQL结果] 查询完成,返回 1 条记录
22:22:11 - article_server - INFO - [SQL数据] 查询结果: [{'total': 3}]
22:22:11 - article_server - INFO - [SQL执行] 开始执行查询SQL
22:22:11 - article_server - INFO - [SQL语句]
SELECT COUNT(id) as total
FROM ai_articles
WHERE enterprise_id = %s AND status = 'published_review'
22:22:11 - article_server - INFO - [SQL参数] (1,)
22:22:11 - article_server - INFO - [SQL执行] 开始执行查询SQL
22:22:11 - article_server - INFO - [SQL语句]
SELECT id, image_id, image_url, image_thumb_url, image_tag_id,
sort_order, keywords_id, keywords_name, department_id,
department_name, image_source, created_at
FROM ai_article_images
WHERE article_id = %s
ORDER BY sort_order ASC, created_at ASC
22:22:11 - article_server - INFO - [SQL参数] (31,)
22:22:11 - article_server - INFO - [SQL结果] 查询完成,返回 1 条记录
22:22:11 - article_server - INFO - [SQL数据] 查询结果: [{'total': 0}]
22:22:11 - article_server - INFO - [SQL执行] 开始执行查询SQL
22:22:11 - article_server - INFO - [SQL语句]
SELECT p.id, p.name, p.type_name, p.knowledge, p.status,
p.articles_total, p.published_total,
p.image_url, p.image_thumbnail_url,
p.created_at, p.updated_at
FROM ai_products p
WHERE enterprise_id = %s AND status != 'deleted'
ORDER BY p.created_at DESC
LIMIT %s OFFSET %s
22:22:11 - article_server - INFO - [SQL参数] [1, 100, 0]
22:22:11 - article_server - INFO - [SQL结果] 查询完成,返回 0 条记录
22:22:11 - article_server - INFO - [SQL执行] 开始执行查询SQL
22:22:11 - article_server - INFO - [SQL语句]
SELECT id, prompt_workflow_name, workflow_id, content, usage_count, created_at, updated_at
FROM ai_prompt_workflow
WHERE enterprise_id = %s
ORDER BY created_at DESC
LIMIT %s OFFSET %s
22:22:11 - article_server - INFO - [SQL参数] (1, 100, 0)
22:22:11 - article_server - INFO - [SQL结果] 查询完成,返回 5 条记录
22:22:11 - article_server - INFO - [SQL执行] 开始执行查询SQL
22:22:11 - article_server - INFO - [SQL语句]
SELECT COUNT(id) as total
FROM ai_articles
WHERE enterprise_id = %s AND status = 'published'
22:22:11 - article_server - INFO - [SQL参数] (1,)
22:22:11 - article_server - INFO - [SQL结果] 查询完成,返回 3 条记录
22:22:11 - article_server - INFO - [SQL数据] 查询结果: [{'id': 25, 'prompt_workflow_name': 'Inject基础提示词', 'workflow_id': 'WF-51A137DE', 'content': '你是一个健康类自媒体的编辑每天需要撰写健康类内容。我将要给你一个topic这个topic是一个问句。请你先产生一个段落的回复然后再段展开回复。每个段落都需要用一个emoji开头。最后请生成tag。段落与段落之间空一行保证可读性。\n详细要求如下\n一、核心要求\n1.\t目标受众 普通大众,非专业人士。务必:\n¡\t避免使用专业术语和书面化表达\n¡\t内容安全限制\n\uf06e\t❌ 禁止提及任何人体私密部位或敏感功能\n\uf06e\t❌ 禁用可能引发恐慌的词汇(如"危险""致命"\n2.\t内容核心 围绕“主题”,聚焦病症、问题、危害或困扰, 解释原因、原理,介绍症状、类型,提供积极、实用的解决方案、改善建议或注意事项等有价值的内容均可。\n3.\t唯一性与实用性 生成的内容需确保信息准确(基于常识)且每次生成的内容不应与历史输出重复(针对同一主题多次生成时)。\n二、内容结构及具体要求\n\uf06c\t【首段提问】 (title)\n¡\t对应内容为{{title}}\n\n\uf06c\t【次段简答】 (short-answer)\n¡\t字数 60-120字。 \n **内容要求**\n 1. 第一句话必须直接回答{{title}}的提问可以拓展1-2句话\n 2. 直接明晰,不要太笼统,禁止罗里吧嗦\n 3. 段前不要emoji表情符号\n \n **✅ 合格示例**\n 发现HPV16或18阳性这通常意味着宫颈癌筛查结果显示存在感染。接下来一般会建议做阴道镜检查再根据检查的具体情况决定治疗方案。\n\n **❌ 不合格示例**\n • 使用emoji开头\n • 没有直接回答问题\n • 过于笼统泛泛而谈 \n\n\uf06c\t【分段细答】 (contents)\n¡\t数量要求2-3段。\n¡\t字数要求 60~100字/段。\n¡\t核心要求\n\uf06e\t语言口语化、自然流畅。\n\uf06e\t段落内容必须围绕核心观点展开根据不同情况分类详细阐述问题可以是具体可行的建议吃什么、做什么、注意什么等疾病的科普主要症状、影响、诱因等或者其它逻辑合理的内容也可以。\n\uf06e\t内容有一定的逻辑包括但不限于首先、其次、最后第一第二第三不仅、而且、还有初级、中级、高级。\n\uf06e\t每段内容均衡不超过五句话确保信息全面且易于消化。\n\uf06e\t分段细答部分应当是次段简答部分的延伸但用词不能和次段简答部分有太多重复请保持多样性。\n\uf06e\t 在生成回答前,必须执行以下创造性流程:\n\t\t结构性禁令排除法行文结构不得是“定义→成因→症状→治疗”或“是什么→为什么→怎么办”及其任何变体。\n\t\t动态自我审视核心步骤\n\t\t回顾主动审视历史内容中针对相同或相似主题已使用过的所有核心阐述逻辑。\n\t\t规避明确禁止重复或小幅修改上述任何逻辑。\n\t\t创新基于当前问题的具体内涵生成一个在本质上全新的、服务于核心问题的最佳解释路径。该路径必须与所有已回顾的逻辑存在根本性差异。\n\t\t输出确认最终采用的逻辑结构应是本次对话上下文中一次独特的、未经使用的创造性表达形式。\n\n\uf06c\t【标签】 (tags)\n¡\t**单个关键词字数4-8个字。\n¡\t内容* (1)根据正文内容生成5个内容强相关tag (2)标签格式:每个关键词前后都有# (例: #养生小知识# #中医养生##习惯养成# #健康养生#\n三、变量输入\n\uf06c\t主题 {{title}}\n四、最终安全规则\n4.\t全篇禁止出现人体私密部位描述\n5.\t关键安全信息重复出现≥2次\n6.\t每句话≤20字复合句用逗<E794A8>
22:22:11 - article_server - INFO - [SQL执行] 开始执行查询SQL
22:22:11 - article_server - INFO - [SQL语句]
SELECT id, coze_tag, created_at
FROM ai_article_tags
WHERE article_id = %s
22:22:11 - article_server - INFO - [SQL参数] (31,)
22:22:11 - article_server - INFO - [SQL结果] 查询完成,返回 1 条记录
22:22:11 - article_server - INFO - [SQL数据] 查询结果: [{'total': 0}]
22:22:11 - article_server - INFO - [SQL执行] 开始执行查询SQL
22:22:11 - article_server - INFO - [SQL语句]
SELECT id, tag_name
FROM ai_product_tags
WHERE product_id = %s
22:22:11 - article_server - INFO - [SQL参数] (25,)
22:22:11 - article_server - INFO - [SQL结果] 查询完成,返回 0 条记录
22:22:11 - article_server - INFO - [文章仪表盘] 查询成功, 企业ID: 1, 总数: 12, 可发: 0, 已发: 0, IP: 36.27.52.26
22:22:11 - article_server - INFO - [API响应] GET /api/articles/list_dashboard - IP: 36.27.52.26 - 状态码: 200
22:22:11 - article_server - INFO - [SQL执行] 开始执行查询SQL
22:22:11 - article_server - INFO - [SQL语句]
SELECT t.id, t.tag_name
FROM ai_prompt_tags t
INNER JOIN ai_prompt_tags_relation r ON t.id = r.tag_id
WHERE r.prompt_workflow_id = %s
22:22:11 - article_server - INFO - [SQL参数] (25,)
22:22:11 - article_server - INFO - [SQL结果] 查询完成,返回 0 条记录
22:22:11 - article_server - INFO - [SQL结果] 查询完成,返回 2 条记录
22:22:11 - article_server - INFO - [SQL数据] 查询结果: [{'id': 14, 'tag_name': '去重'}, {'id': 15, 'tag_name': '基础提示词'}]
22:22:11 - article_server - INFO - [SQL执行] 开始执行查询SQL
22:22:11 - article_server - INFO - [SQL语句]
SELECT id, image_id, image_url, image_thumb_url, image_tag_id,
sort_order, keywords_id, keywords_name, department_id,
department_name, image_source, created_at
FROM ai_article_images
WHERE article_id = %s
ORDER BY sort_order ASC, created_at ASC
22:22:11 - article_server - INFO - [SQL参数] (30,)
22:22:11 - article_server - INFO - [SQL执行] 开始执行查询SQL
22:22:11 - article_server - INFO - [SQL语句]
SELECT id, tag_name
FROM ai_product_tags
WHERE product_id = %s
22:22:11 - article_server - INFO - [SQL参数] (13,)
22:22:11 - article_server - INFO - [SQL结果] 查询完成,返回 0 条记录
22:22:11 - article_server - INFO - [SQL结果] 查询完成,返回 0 条记录
22:22:11 - article_server - INFO - [SQL执行] 开始执行查询SQL
22:22:11 - article_server - INFO - [SQL语句]
SELECT t.id, t.tag_name
FROM ai_prompt_tags t
INNER JOIN ai_prompt_tags_relation r ON t.id = r.tag_id
WHERE r.prompt_workflow_id = %s
22:22:11 - article_server - INFO - [SQL参数] (14,)
22:22:11 - article_server - INFO - [SQL结果] 查询完成,返回 0 条记录
22:22:11 - article_server - INFO - [SQL执行] 开始执行查询SQL
22:22:11 - article_server - INFO - [SQL语句]
SELECT id, coze_tag, created_at
FROM ai_article_tags
WHERE article_id = %s
22:22:11 - article_server - INFO - [SQL参数] (30,)
22:22:11 - article_server - INFO - [SQL执行] 开始执行查询SQL
22:22:11 - article_server - INFO - [SQL语句]
SELECT id, tag_name
FROM ai_product_tags
WHERE product_id = %s
22:22:11 - article_server - INFO - [SQL参数] (12,)
22:22:11 - article_server - INFO - [SQL结果] 查询完成,返回 0 条记录
22:22:11 - article_server - INFO - [SQL结果] 查询完成,返回 0 条记录
22:22:11 - article_server - INFO - [SQL执行] 开始执行查询SQL
22:22:11 - article_server - INFO - [SQL语句]
SELECT t.id, t.tag_name
FROM ai_prompt_tags t
INNER JOIN ai_prompt_tags_relation r ON t.id = r.tag_id
WHERE r.prompt_workflow_id = %s
22:22:11 - article_server - INFO - [SQL参数] (1,)
22:22:11 - article_server - INFO - [SQL执行] 开始执行查询SQL
22:22:11 - article_server - INFO - [SQL语句]
SELECT id, image_id, image_url, image_thumb_url, image_tag_id,
sort_order, keywords_id, keywords_name, department_id,
department_name, image_source, created_at
FROM ai_article_images
WHERE article_id = %s
ORDER BY sort_order ASC, created_at ASC
22:22:11 - article_server - INFO - [SQL参数] (28,)
22:22:11 - article_server - INFO - [SQL结果] 查询完成,返回 0 条记录
22:22:11 - article_server - INFO - [SQL执行] 开始执行查询SQL
22:22:11 - article_server - INFO - [SQL语句]
SELECT id, tag_name
FROM ai_product_tags
WHERE product_id = %s
22:22:11 - article_server - INFO - [SQL参数] (11,)
22:22:11 - article_server - INFO - [SQL结果] 查询完成,返回 0 条记录
22:22:11 - article_server - INFO - 获取提示词列表成功,总数: 3
22:22:11 - article_server - INFO - [API响应] GET /api/prompts/list - IP: 36.27.52.26 - 状态码: 200
22:22:11 - article_server - INFO - [SQL结果] 查询完成,返回 0 条记录
22:22:11 - article_server - INFO - [SQL执行] 开始执行查询SQL
22:22:11 - article_server - INFO - [SQL语句]
SELECT id, coze_tag, created_at
FROM ai_article_tags
WHERE article_id = %s
22:22:11 - article_server - INFO - [SQL参数] (28,)
22:22:11 - article_server - INFO - [SQL执行] 开始执行查询SQL
22:22:11 - article_server - INFO - [SQL语句]
SELECT id, tag_name
FROM ai_product_tags
WHERE product_id = %s
22:22:11 - article_server - INFO - [SQL参数] (1,)
22:22:11 - article_server - INFO - [SQL结果] 查询完成,返回 0 条记录
22:22:11 - article_server - INFO - [SQL结果] 查询完成,返回 1 条记录
22:22:11 - article_server - INFO - [SQL数据] 查询结果: [{'id': 1, 'tag_name': '保湿'}]
22:22:11 - article_server - INFO - [获取产品列表] 查询成功, 总数: 5, 当前页: 1, 每页: 100, 返回数量: 5, 企业ID: 1, IP: 36.27.52.26
22:22:11 - article_server - INFO - [API响应] GET /api/products/list - IP: 36.27.52.26 - 状态码: 200
22:22:11 - article_server - INFO - [SQL执行] 开始执行查询SQL
22:22:11 - article_server - INFO - [SQL语句]
SELECT id, image_id, image_url, image_thumb_url, image_tag_id,
sort_order, keywords_id, keywords_name, department_id,
department_name, image_source, created_at
FROM ai_article_images
WHERE article_id = %s
ORDER BY sort_order ASC, created_at ASC
22:22:11 - article_server - INFO - [SQL参数] (26,)
22:22:11 - article_server - INFO - [SQL结果] 查询完成,返回 0 条记录
22:22:11 - article_server - INFO - [SQL执行] 开始执行查询SQL
22:22:11 - article_server - INFO - [SQL语句]
SELECT id, coze_tag, created_at
FROM ai_article_tags
WHERE article_id = %s
22:22:11 - article_server - INFO - [SQL参数] (26,)
22:22:11 - article_server - INFO - [SQL结果] 查询完成,返回 0 条记录
22:22:11 - article_server - INFO - [SQL执行] 开始执行查询SQL
22:22:11 - article_server - INFO - [SQL语句]
SELECT id, image_id, image_url, image_thumb_url, image_tag_id,
sort_order, keywords_id, keywords_name, department_id,
department_name, image_source, created_at
FROM ai_article_images
WHERE article_id = %s
ORDER BY sort_order ASC, created_at ASC
22:22:11 - article_server - INFO - [SQL参数] (24,)
22:22:11 - article_server - INFO - [SQL结果] 查询完成,返回 0 条记录
22:22:12 - article_server - INFO - [SQL执行] 开始执行查询SQL
22:22:12 - article_server - INFO - [SQL语句]
SELECT id, coze_tag, created_at
FROM ai_article_tags
WHERE article_id = %s
22:22:12 - article_server - INFO - [SQL参数] (24,)
22:22:12 - article_server - INFO - [SQL结果] 查询完成,返回 0 条记录
22:22:12 - article_server - INFO - [SQL执行] 开始执行查询SQL
22:22:12 - article_server - INFO - [SQL语句]
SELECT id, image_id, image_url, image_thumb_url, image_tag_id,
sort_order, keywords_id, keywords_name, department_id,
department_name, image_source, created_at
FROM ai_article_images
WHERE article_id = %s
ORDER BY sort_order ASC, created_at ASC
22:22:12 - article_server - INFO - [SQL参数] (22,)
22:22:12 - article_server - INFO - [SQL结果] 查询完成,返回 0 条记录
22:22:12 - article_server - INFO - [SQL执行] 开始执行查询SQL
22:22:12 - article_server - INFO - [SQL语句]
SELECT id, coze_tag, created_at
FROM ai_article_tags
WHERE article_id = %s
22:22:12 - article_server - INFO - [SQL参数] (22,)
22:22:12 - article_server - INFO - [SQL结果] 查询完成,返回 0 条记录
22:22:12 - article_server - INFO - [SQL执行] 开始执行查询SQL
22:22:12 - article_server - INFO - [SQL语句]
SELECT id, image_id, image_url, image_thumb_url, image_tag_id,
sort_order, keywords_id, keywords_name, department_id,
department_name, image_source, created_at
FROM ai_article_images
WHERE article_id = %s
ORDER BY sort_order ASC, created_at ASC
22:22:12 - article_server - INFO - [SQL参数] (20,)
22:22:12 - article_server - INFO - [SQL结果] 查询完成,返回 0 条记录
22:22:12 - article_server - INFO - [SQL执行] 开始执行查询SQL
22:22:12 - article_server - INFO - [SQL语句]
SELECT id, coze_tag, created_at
FROM ai_article_tags
WHERE article_id = %s
22:22:12 - article_server - INFO - [SQL参数] (20,)
22:22:12 - article_server - INFO - [SQL结果] 查询完成,返回 0 条记录
22:22:12 - article_server - INFO - [SQL执行] 开始执行查询SQL
22:22:12 - article_server - INFO - [SQL语句]
SELECT id, image_id, image_url, image_thumb_url, image_tag_id,
sort_order, keywords_id, keywords_name, department_id,
department_name, image_source, created_at
FROM ai_article_images
WHERE article_id = %s
ORDER BY sort_order ASC, created_at ASC
22:22:12 - article_server - INFO - [SQL参数] (18,)
22:22:12 - article_server - INFO - [SQL结果] 查询完成,返回 0 条记录
22:22:12 - article_server - INFO - [SQL执行] 开始执行查询SQL
22:22:12 - article_server - INFO - [SQL语句]
SELECT id, coze_tag, created_at
FROM ai_article_tags
WHERE article_id = %s
22:22:12 - article_server - INFO - [SQL参数] (18,)
22:22:12 - article_server - INFO - [SQL结果] 查询完成,返回 0 条记录
22:22:12 - article_server - INFO - [SQL执行] 开始执行查询SQL
22:22:12 - article_server - INFO - [SQL语句]
SELECT id, image_id, image_url, image_thumb_url, image_tag_id,
sort_order, keywords_id, keywords_name, department_id,
department_name, image_source, created_at
FROM ai_article_images
WHERE article_id = %s
ORDER BY sort_order ASC, created_at ASC
22:22:12 - article_server - INFO - [SQL参数] (16,)
22:22:12 - article_server - INFO - [SQL结果] 查询完成,返回 0 条记录
22:22:12 - article_server - INFO - [SQL执行] 开始执行查询SQL
22:22:12 - article_server - INFO - [SQL语句]
SELECT id, coze_tag, created_at
FROM ai_article_tags
WHERE article_id = %s
22:22:12 - article_server - INFO - [SQL参数] (16,)
22:22:12 - article_server - INFO - [SQL结果] 查询完成,返回 0 条记录
22:22:12 - article_server - INFO - [SQL执行] 开始执行查询SQL
22:22:12 - article_server - INFO - [SQL语句]
SELECT id, image_id, image_url, image_thumb_url, image_tag_id,
sort_order, keywords_id, keywords_name, department_id,
department_name, image_source, created_at
FROM ai_article_images
WHERE article_id = %s
ORDER BY sort_order ASC, created_at ASC
22:22:12 - article_server - INFO - [SQL参数] (14,)
22:22:12 - article_server - INFO - [SQL结果] 查询完成,返回 0 条记录
22:22:12 - article_server - INFO - [SQL执行] 开始执行查询SQL
22:22:12 - article_server - INFO - [SQL语句]
SELECT id, coze_tag, created_at
FROM ai_article_tags
WHERE article_id = %s
22:22:12 - article_server - INFO - [SQL参数] (14,)
22:22:12 - article_server - INFO - [SQL结果] 查询完成,返回 0 条记录
22:22:12 - article_server - INFO - [SQL执行] 开始执行查询SQL
22:22:12 - article_server - INFO - [SQL语句]
SELECT id, image_id, image_url, image_thumb_url, image_tag_id,
sort_order, keywords_id, keywords_name, department_id,
department_name, image_source, created_at
FROM ai_article_images
WHERE article_id = %s
ORDER BY sort_order ASC, created_at ASC
22:22:12 - article_server - INFO - [SQL参数] (12,)
22:22:12 - article_server - INFO - [SQL结果] 查询完成,返回 0 条记录
22:22:12 - article_server - INFO - [SQL执行] 开始执行查询SQL
22:22:12 - article_server - INFO - [SQL语句]
SELECT id, coze_tag, created_at
FROM ai_article_tags
WHERE article_id = %s
22:22:12 - article_server - INFO - [SQL参数] (12,)
22:22:12 - article_server - INFO - [SQL结果] 查询完成,返回 0 条记录
22:22:12 - article_server - INFO - [SQL执行] 开始执行查询SQL
22:22:12 - article_server - INFO - [SQL语句]
SELECT id, image_id, image_url, image_thumb_url, image_tag_id,
sort_order, keywords_id, keywords_name, department_id,
department_name, image_source, created_at
FROM ai_article_images
WHERE article_id = %s
ORDER BY sort_order ASC, created_at ASC
22:22:12 - article_server - INFO - [SQL参数] (1,)
22:22:12 - article_server - INFO - [SQL结果] 查询完成,返回 0 条记录
22:22:12 - article_server - INFO - [SQL执行] 开始执行查询SQL
22:22:12 - article_server - INFO - [SQL语句]
SELECT id, coze_tag, created_at
FROM ai_article_tags
WHERE article_id = %s
22:22:12 - article_server - INFO - [SQL参数] (1,)
22:22:13 - article_server - INFO - [SQL结果] 查询完成,返回 0 条记录
22:22:13 - article_server - INFO - [获取文章列表] 查询成功, 总数: 12, 当前页: 1, 每页: 20, 返回数量: 12, 企业ID: 1, IP: 36.27.52.26
22:22:13 - article_server - INFO - [API响应] GET /api/articles/list - IP: 36.27.52.26 - 状态码: 200
22:24:00 - article_server - INFO - [API访问] POST /api/articles/generate - IP: 36.27.52.26 - User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/143.0.0.0 Sa
22:24:00 - article_server - INFO - [Token验证成功] 用户ID: 4
22:24:00 - article_server - INFO - [生成文案] 开始处理生成文案请求, IP: 36.27.52.26
22:24:00 - article_server - INFO - [生成文案] 用户信息 - 用户ID: 4, 企业ID: 1, IP: 36.27.52.26
22:24:00 - article_server - INFO - [生成文案] 收到生成请求, 产品ID: 25, 提示词ID: 25, 主题数: 13, 企业ID: 1, IP: 36.27.52.26
22:24:00 - article_server - INFO - [生成文案] 验证产品是否存在, 产品ID: 25, 企业ID: 1
22:24:00 - article_server - INFO - [SQL执行] 开始执行查询SQL
22:24:00 - article_server - INFO - [SQL语句] SELECT id, name FROM ai_products WHERE id = %s AND enterprise_id = %s
22:24:00 - article_server - INFO - [SQL参数] (25, 1)
22:24:00 - article_server - INFO - [SQL结果] 查询完成,返回 1 条记录
22:24:00 - article_server - INFO - [SQL数据] 查询结果: [{'id': 25, 'name': '产品21'}]
22:24:00 - article_server - INFO - [生成文案] 产品验证成功, 产品名称: 产品21, ID: 25
22:24:00 - article_server - INFO - [生成文案] 验证提示词是否存在, 提示词ID: 25, 企业ID: 1
22:24:00 - article_server - INFO - [SQL执行] 开始执行查询SQL
22:24:00 - article_server - INFO - [SQL语句] SELECT id FROM ai_prompt_workflow WHERE id = %s AND enterprise_id = %s
22:24:00 - article_server - INFO - [SQL参数] (25, 1)
22:24:00 - article_server - INFO - [SQL结果] 查询完成,返回 1 条记录
22:24:00 - article_server - INFO - [SQL数据] 查询结果: [{'id': 25}]
22:24:00 - article_server - INFO - [生成文案] 提示词验证成功, ID: 25
22:24:00 - article_server - INFO - [生成文案] 开始生成文案, 主题数量: 10, 产品: 产品21, 企业ID: 1
22:24:00 - article_server - INFO - [生成文案] 开始生成主题文案: 20几岁就有前列腺钙化需要治疗吗, 产品: 产品21
22:24:00 - article_server - INFO - [SQL执行] 开始执行插入SQL
22:24:00 - article_server - INFO - [SQL语句]
INSERT INTO ai_articles
(enterprise_id, product_id, prompt_workflow_id, title, topic, status)
VALUES (%s, %s, %s, %s, %s, %s, %s)
22:24:00 - article_server - INFO - [SQL参数] (1, 25, 25, '关于产品21的20几岁就有前列腺钙化需要治疗吗分享', '20几岁就有前列腺钙化需要治疗吗', 'draft')
22:24:00 - article_server - ERROR - 数据库操作失败: not enough arguments for format string
22:24:00 - article_server - ERROR - [SQL执行失败] 插入SQL执行异常: not enough arguments for format string
22:24:00 - article_server - ERROR - [SQL语句]
INSERT INTO ai_articles
(enterprise_id, product_id, prompt_workflow_id, title, topic, status)
VALUES (%s, %s, %s, %s, %s, %s, %s)
22:24:00 - article_server - ERROR - [SQL参数] (1, 25, 25, '关于产品21的20几岁就有前列腺钙化需要治疗吗分享', '20几岁就有前列腺钙化需要治疗吗', 'draft')
22:24:00 - article_server - ERROR - [生成文案] 处理请求时发生错误: not enough arguments for format string
Traceback (most recent call last):
File "/home/work/ai_wht/article_routes.py", line 245, in generate_article
article_id = db_manager.execute_insert(sql, (
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/home/work/ai_wht/database_config.py", line 254, in execute_insert
return self._execute_with_retry(_insert_operation)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/home/work/ai_wht/database_config.py", line 103, in _execute_with_retry
return operation(*args, **kwargs)
^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/home/work/ai_wht/database_config.py", line 239, in _insert_operation
cursor.execute(sql, params)
File "/home/work/keyword_crawl/venv/lib/python3.12/site-packages/pymysql/cursors.py", line 151, in execute
query = self.mogrify(query, args)
^^^^^^^^^^^^^^^^^^^^^^^^^
File "/home/work/keyword_crawl/venv/lib/python3.12/site-packages/pymysql/cursors.py", line 129, in mogrify
query = query % self._escape_args(args, conn)
~~~~~~^~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
TypeError: not enough arguments for format string
22:24:00 - article_server - INFO - [API响应] POST /api/articles/generate - IP: 36.27.52.26 - 状态码: 500
22:24:09 - article_server - INFO - [API访问] POST /api/articles/generate - IP: 36.27.52.26 - User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/143.0.0.0 Sa
22:24:09 - article_server - INFO - [Token验证成功] 用户ID: 4
22:24:09 - article_server - INFO - [生成文案] 开始处理生成文案请求, IP: 36.27.52.26
22:24:09 - article_server - INFO - [生成文案] 用户信息 - 用户ID: 4, 企业ID: 1, IP: 36.27.52.26
22:24:09 - article_server - INFO - [生成文案] 收到生成请求, 产品ID: 25, 提示词ID: 25, 主题数: 13, 企业ID: 1, IP: 36.27.52.26
22:24:09 - article_server - INFO - [生成文案] 验证产品是否存在, 产品ID: 25, 企业ID: 1
22:24:09 - article_server - INFO - [SQL执行] 开始执行查询SQL
22:24:09 - article_server - INFO - [SQL语句] SELECT id, name FROM ai_products WHERE id = %s AND enterprise_id = %s
22:24:09 - article_server - INFO - [SQL参数] (25, 1)
22:24:09 - article_server - INFO - [SQL结果] 查询完成,返回 1 条记录
22:24:09 - article_server - INFO - [SQL数据] 查询结果: [{'id': 25, 'name': '产品21'}]
22:24:09 - article_server - INFO - [生成文案] 产品验证成功, 产品名称: 产品21, ID: 25
22:24:09 - article_server - INFO - [生成文案] 验证提示词是否存在, 提示词ID: 25, 企业ID: 1
22:24:10 - article_server - INFO - [SQL执行] 开始执行查询SQL
22:24:10 - article_server - INFO - [SQL语句] SELECT id FROM ai_prompt_workflow WHERE id = %s AND enterprise_id = %s
22:24:10 - article_server - INFO - [SQL参数] (25, 1)
22:24:10 - article_server - INFO - [SQL结果] 查询完成,返回 1 条记录
22:24:10 - article_server - INFO - [SQL数据] 查询结果: [{'id': 25}]
22:24:10 - article_server - INFO - [生成文案] 提示词验证成功, ID: 25
22:24:10 - article_server - INFO - [生成文案] 开始生成文案, 主题数量: 10, 产品: 产品21, 企业ID: 1
22:24:10 - article_server - INFO - [生成文案] 开始生成主题文案: 20几岁就有前列腺钙化需要治疗吗, 产品: 产品21
22:24:10 - article_server - INFO - [SQL执行] 开始执行插入SQL
22:24:10 - article_server - INFO - [SQL语句]
INSERT INTO ai_articles
(enterprise_id, product_id, prompt_workflow_id, title, topic, status)
VALUES (%s, %s, %s, %s, %s, %s, %s)
22:24:10 - article_server - INFO - [SQL参数] (1, 25, 25, '关于产品21的20几岁就有前列腺钙化需要治疗吗分享', '20几岁就有前列腺钙化需要治疗吗', 'draft')
22:24:10 - article_server - ERROR - 数据库操作失败: not enough arguments for format string
22:24:10 - article_server - ERROR - [SQL执行失败] 插入SQL执行异常: not enough arguments for format string
22:24:10 - article_server - ERROR - [SQL语句]
INSERT INTO ai_articles
(enterprise_id, product_id, prompt_workflow_id, title, topic, status)
VALUES (%s, %s, %s, %s, %s, %s, %s)
22:24:10 - article_server - ERROR - [SQL参数] (1, 25, 25, '关于产品21的20几岁就有前列腺钙化需要治疗吗分享', '20几岁就有前列腺钙化需要治疗吗', 'draft')
22:24:10 - article_server - ERROR - [生成文案] 处理请求时发生错误: not enough arguments for format string
Traceback (most recent call last):
File "/home/work/ai_wht/article_routes.py", line 245, in generate_article
article_id = db_manager.execute_insert(sql, (
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/home/work/ai_wht/database_config.py", line 254, in execute_insert
return self._execute_with_retry(_insert_operation)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/home/work/ai_wht/database_config.py", line 103, in _execute_with_retry
return operation(*args, **kwargs)
^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/home/work/ai_wht/database_config.py", line 239, in _insert_operation
cursor.execute(sql, params)
File "/home/work/keyword_crawl/venv/lib/python3.12/site-packages/pymysql/cursors.py", line 151, in execute
query = self.mogrify(query, args)
^^^^^^^^^^^^^^^^^^^^^^^^^
File "/home/work/keyword_crawl/venv/lib/python3.12/site-packages/pymysql/cursors.py", line 129, in mogrify
query = query % self._escape_args(args, conn)
~~~~~~^~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
TypeError: not enough arguments for format string
22:24:10 - article_server - INFO - [API响应] POST /api/articles/generate - IP: 36.27.52.26 - 状态码: 500