shengyudong/ai_wht_B
1
0
Fork 0
Code Issues Pull Requests Actions Packages Projects Releases Wiki Activity
Files
main
ai_wht_B/log10bjh_wht_server_api_2512162153.log
“shengyudong” 5a384b694e 2026-1-6
2026-01-06 14:18:39 +08:00

1441 lines
105 KiB
Plaintext
Raw Permalink Blame History

This file contains ambiguous Unicode characters

This file contains Unicode characters that might be confused with other characters. If you think that this is intentional, you can safely ignore this warning. Use the Escape button to reveal them.

21:53:27 - article_server - INFO - 日志系统已启动 - 记录器: article_server
21:53:27 - article_server - INFO - 主日志文件: logs/article_server.log
21:53:27 - article_server - INFO - 错误日志文件: logs/article_error.log
21:53:27 - article_server - INFO - 日志保留策略: 每天午夜分割，主日志保留3天
21:53:27 - article_server - INFO - 错误日志保留策略: 每天午夜分割，保留9天
21:53:27 - article_server - INFO - 万花筒API服务模块已加载
21:53:41 - article_server - INFO - [API访问] DELETE /api/employees/18 - 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
21:53:41 - article_server - INFO - [Token验证成功] 用户ID: 4
21:53:41 - article_server - INFO - 数据库连接成功，字符集设置完成
21:53:41 - article_server - INFO - [SQL执行] 开始执行查询SQL
21:53:41 - article_server - INFO - [SQL语句] SELECT id, real_name FROM ai_users WHERE id = %s AND enterprise_id = %s AND status != 'deleted'
21:53:41 - article_server - INFO - [SQL参数] (18, 1)
21:53:41 - article_server - INFO - [SQL结果] 查询完成，返回 1 条记录
21:53:41 - article_server - INFO - [SQL数据] 查询结果: [{'id': 18, 'real_name': '测试员工API'}]
21:53:41 - article_server - INFO - [SQL执行] 开始执行更新SQL
21:53:41 - article_server - INFO - [SQL语句] UPDATE ai_users SET status = 'deleted', updated_at = NOW() WHERE id = %s
21:53:41 - article_server - INFO - [SQL参数] (18,)
21:53:41 - article_server - INFO - [SQL结果] 更新完成，影响 1 行
21:53:41 - article_server - INFO - [SQL执行] 开始执行更新SQL
21:53:41 - article_server - INFO - [SQL语句] UPDATE ai_enterprises SET users_total = users_total - 1 WHERE id = %s
21:53:41 - article_server - INFO - [SQL参数] (1,)
21:53:41 - article_server - INFO - [SQL结果] 更新完成，影响 1 行
21:53:41 - article_server - INFO - 删除员工成功: 测试员工API
21:53:41 - article_server - INFO - [API响应] DELETE /api/employees/18 - IP: 36.27.52.26 - 状态码: 200
21:53:41 - article_server - INFO - [API访问] GET /api/employees/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
21:53:41 - article_server - INFO - [Token验证成功] 用户ID: 4
21:53:41 - article_server - INFO - [SQL执行] 开始执行查询SQL
21:53:41 - article_server - INFO - [SQL语句] SELECT COUNT(*) as total FROM ai_users WHERE enterprise_id = %s AND status != 'deleted'
21:53:41 - article_server - INFO - [SQL参数] [1]
21:53:41 - article_server - INFO - [SQL结果] 查询完成，返回 1 条记录
21:53:41 - article_server - INFO - [SQL数据] 查询结果: [{'total': 4}]
21:53:41 - article_server - INFO - [API访问] GET /api/employees/stats - 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
21:53:41 - article_server - INFO - [Token验证成功] 用户ID: 4
21:53:41 - article_server - INFO - [SQL执行] 开始执行查询SQL
21:53:41 - article_server - INFO - [SQL语句]
SELECT id, enterprise_id, real_name as name, username, phone, role, department,
is_bound_xhs, xhs_account, status, created_at, updated_at
FROM ai_users
WHERE enterprise_id = %s AND status != 'deleted'
ORDER BY created_at DESC
LIMIT %s OFFSET %s
21:53:41 - article_server - INFO - [SQL参数] [1, 20, 0]
21:53:41 - article_server - INFO - [SQL结果] 查询完成，返回 4 条记录
21:53:41 - article_server - INFO - 获取员工列表成功，总数: 4
21:53:41 - article_server - INFO - [API响应] GET /api/employees/list - IP: 36.27.52.26 - 状态码: 200
21:53:41 - article_server - INFO - 数据库连接成功，字符集设置完成
21:53:41 - article_server - INFO - [SQL执行] 开始执行查询SQL
21:53:41 - article_server - INFO - [SQL语句]
SELECT
COUNT(*) as total_count,
SUM(CASE WHEN status = 'active' THEN 1 ELSE 0 END) as active_count,
SUM(CASE WHEN is_bound_xhs = 1 THEN 1 ELSE 0 END) as bound_xhs_count
FROM ai_users
WHERE enterprise_id = %s AND status != 'deleted'
21:53:41 - article_server - INFO - [SQL参数] (1,)
21:53:41 - article_server - INFO - [SQL结果] 查询完成，返回 1 条记录
21:53:41 - article_server - INFO - [SQL数据] 查询结果: [{'total_count': 4, 'active_count': Decimal('4'), 'bound_xhs_count': Decimal('3')}]
21:53:41 - article_server - INFO - 获取员工统计成功
21:53:41 - article_server - INFO - [API响应] GET /api/employees/stats - IP: 36.27.52.26 - 状态码: 200
21:53:49 - article_server - INFO - [API访问] GET /api/employees/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
21:53:49 - article_server - INFO - [Token验证成功] 用户ID: 4
21:53:49 - article_server - INFO - [API访问] GET /api/employees/stats - 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
21:53:49 - article_server - INFO - [Token验证成功] 用户ID: 4
21:53:49 - article_server - INFO - [SQL执行] 开始执行查询SQL
21:53:49 - article_server - INFO - [SQL语句]
SELECT
COUNT(*) as total_count,
SUM(CASE WHEN status = 'active' THEN 1 ELSE 0 END) as active_count,
SUM(CASE WHEN is_bound_xhs = 1 THEN 1 ELSE 0 END) as bound_xhs_count
FROM ai_users
WHERE enterprise_id = %s AND status != 'deleted'
21:53:49 - article_server - INFO - [SQL参数] (1,)
21:53:49 - article_server - INFO - [SQL结果] 查询完成，返回 1 条记录
21:53:49 - article_server - INFO - [SQL数据] 查询结果: [{'total_count': 4, 'active_count': Decimal('4'), 'bound_xhs_count': Decimal('3')}]
21:53:49 - 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
21:53:49 - article_server - INFO - [Token验证成功] 用户ID: 4
21:53:49 - article_server - INFO - [获取用户信息] 开始处理请求, IP: 36.27.52.26
21:53:49 - article_server - INFO - [获取用户信息] 用户ID: 4, IP: 36.27.52.26
21:53:49 - article_server - INFO - 获取员工统计成功
21:53:49 - article_server - INFO - [API响应] GET /api/employees/stats - IP: 36.27.52.26 - 状态码: 200
21:53:49 - article_server - INFO - [SQL执行] 开始执行查询SQL
21:53:49 - 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'
21:53:49 - article_server - INFO - [SQL参数] (4,)
21:53:49 - article_server - INFO - [SQL结果] 查询完成，返回 1 条记录
21:53:49 - 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)}]
21:53:49 - article_server - INFO - 数据库连接成功，字符集设置完成
21:53:49 - article_server - INFO - [SQL执行] 开始执行查询SQL
21:53:49 - article_server - INFO - [SQL语句] SELECT COUNT(*) as total FROM ai_users WHERE enterprise_id = %s AND status != 'deleted'
21:53:49 - article_server - INFO - [SQL参数] [1]
21:53:49 - article_server - INFO - [获取用户信息] 查询成功, 用户: user004, 角色: enterprise, 企业: rwl企业4号, IP: 36.27.52.26
21:53:49 - article_server - INFO - [SQL结果] 查询完成，返回 1 条记录
21:53:49 - article_server - INFO - [SQL数据] 查询结果: [{'total': 4}]
21:53:50 - article_server - INFO - [SQL执行] 开始执行插入SQL
21:53:50 - 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())
21:53:50 - 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)
21:53:50 - article_server - INFO - [SQL执行] 开始执行查询SQL
21:53:50 - article_server - INFO - [SQL语句]
SELECT id, enterprise_id, real_name as name, username, phone, role, department,
is_bound_xhs, xhs_account, status, created_at, updated_at
FROM ai_users
WHERE enterprise_id = %s AND status != 'deleted'
ORDER BY created_at DESC
LIMIT %s OFFSET %s
21:53:50 - article_server - INFO - [SQL参数] [1, 20, 0]
21:53:50 - article_server - INFO - [SQL结果] 插入完成，新记录ID: 22
21:53:50 - article_server - INFO - [SQL结果] 查询完成，返回 4 条记录
21:53:50 - article_server - INFO - [业务日志] 操作: get_user_info | 用户ID: 4 | 目标: user#4 | 状态: success | IP: 36.27.52.26 | 日志ID: 22
21:53:50 - article_server - INFO - [API响应] GET /api/users/info - IP: 36.27.52.26 - 状态码: 200
21:53:50 - article_server - INFO - 获取员工列表成功，总数: 4
21:53:50 - article_server - INFO - [API响应] GET /api/employees/list - IP: 36.27.52.26 - 状态码: 200
21:53:52 - 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
21:53:52 - article_server - INFO - [Token验证成功] 用户ID: 4
21:53:52 - article_server - INFO - [获取产品列表] 开始处理请求, IP: 36.27.52.26
21:53:52 - article_server - INFO - [获取产品列表] 用户信息 - 用户ID: 4, 企业ID: 1, IP: 36.27.52.26
21:53:52 - article_server - INFO - [获取产品列表] 查询参数: page=1, pageSize=20, keyword=, type=, status=, 企业ID: 1, IP: 36.27.52.26
21:53:52 - article_server - INFO - [API访问] GET /api/products/types/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
21:53:52 - article_server - INFO - [Token验证成功] 用户ID: 4
21:53:52 - article_server - INFO - [获取企业产品类型列表] 开始处理请求, IP: 36.27.52.26
21:53:52 - article_server - INFO - [获取企业产品类型列表] 企业ID: 1, IP: 36.27.52.26
21:53:52 - article_server - INFO - [SQL执行] 开始执行查询SQL
21:53:52 - article_server - INFO - [SQL语句] SELECT COUNT(*) as total FROM ai_products WHERE enterprise_id = %s AND status != 'deleted'
21:53:52 - article_server - INFO - [SQL参数] [1]
21:53:52 - article_server - INFO - [SQL结果] 查询完成，返回 1 条记录
21:53:52 - article_server - INFO - [SQL数据] 查询结果: [{'total': 4}]
21:53:52 - article_server - INFO - [SQL执行] 开始执行查询SQL
21:53:52 - 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
21:53:52 - article_server - INFO - [SQL参数] [1, 20, 0]
21:53:52 - article_server - INFO - [SQL结果] 查询完成，返回 4 条记录
21:53:52 - article_server - INFO - [SQL执行] 开始执行查询SQL
21:53:52 - article_server - INFO - [SQL语句]
SELECT id, tag_name
FROM ai_product_tags
WHERE product_id = %s
21:53:52 - article_server - INFO - [SQL参数] (13,)
21:53:52 - article_server - INFO - 数据库连接成功，字符集设置完成
21:53:52 - article_server - INFO - [SQL执行] 开始执行查询SQL
21:53:52 - article_server - INFO - [SQL语句] SELECT COUNT(*) as total FROM ai_product_types WHERE enterprise_id = %s
21:53:52 - article_server - INFO - [SQL参数] [1]
21:53:52 - article_server - INFO - [SQL结果] 查询完成，返回 0 条记录
21:53:52 - article_server - INFO - [SQL结果] 查询完成，返回 1 条记录
21:53:52 - article_server - INFO - [SQL数据] 查询结果: [{'total': 0}]
21:53:52 - article_server - INFO - [SQL执行] 开始执行查询SQL
21:53:52 - article_server - INFO - [SQL语句]
SELECT id, tag_name
FROM ai_product_tags
WHERE product_id = %s
21:53:52 - article_server - INFO - [SQL参数] (12,)
21:53:52 - article_server - INFO - [SQL执行] 开始执行查询SQL
21:53:52 - article_server - INFO - [SQL语句]
SELECT id, type_name, enterprise_id, product_id, created_at
FROM ai_product_types
WHERE enterprise_id = %s
ORDER BY created_at DESC
LIMIT %s OFFSET %s
21:53:52 - article_server - INFO - [SQL参数] [1, 100, 0]
21:53:52 - article_server - INFO - [SQL结果] 查询完成，返回 0 条记录
21:53:52 - article_server - INFO - [SQL结果] 查询完成，返回 0 条记录
21:53:52 - article_server - INFO - [获取企业产品类型列表] 查询成功, 企业ID: 1, 总数: 0, 返回: 0, IP: 36.27.52.26
21:53:52 - article_server - INFO - [API响应] GET /api/products/types/list - IP: 36.27.52.26 - 状态码: 200
21:53:52 - article_server - INFO - [SQL执行] 开始执行查询SQL
21:53:52 - article_server - INFO - [SQL语句]
SELECT id, tag_name
FROM ai_product_tags
WHERE product_id = %s
21:53:52 - article_server - INFO - [SQL参数] (11,)
21:53:52 - article_server - INFO - [SQL结果] 查询完成，返回 0 条记录
21:53:52 - article_server - INFO - [SQL执行] 开始执行查询SQL
21:53:52 - article_server - INFO - [SQL语句]
SELECT id, tag_name
FROM ai_product_tags
WHERE product_id = %s
21:53:52 - article_server - INFO - [SQL参数] (1,)
21:53:52 - article_server - INFO - [SQL结果] 查询完成，返回 1 条记录
21:53:52 - article_server - INFO - [SQL数据] 查询结果: [{'id': 1, 'tag_name': '保湿'}]
21:53:53 - article_server - INFO - [获取产品列表] 查询成功, 总数: 4, 当前页: 1, 每页: 20, 返回数量: 4, 企业ID: 1, IP: 36.27.52.26
21:53:53 - article_server - INFO - [API响应] GET /api/products/list - IP: 36.27.52.26 - 状态码: 200
21:54:34 - article_server - INFO - [API访问] POST /api/products/create - 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
21:54:34 - article_server - INFO - [Token验证成功] 用户ID: 4
21:54:34 - article_server - INFO - [创建产品] 开始处理创建产品请求, IP: 36.27.52.26
21:54:34 - article_server - INFO - [创建产品] 用户信息 - 用户ID: 4, 企业ID: 1, IP: 36.27.52.26
21:54:34 - article_server - INFO - [创建产品] 收到创建请求, 产品名称: 产品（2）, 类型: 防护品, 企业ID: 1, IP: 36.27.52.26
21:54:34 - article_server - INFO - [创建产品] 开始检查产品名称是否重复, 名称: 产品（2）, 企业ID: 1
21:54:34 - article_server - INFO - 数据库连接成功，字符集设置完成
21:54:34 - article_server - INFO - [SQL执行] 开始执行查询SQL
21:54:34 - article_server - INFO - [SQL语句]
SELECT id, name FROM ai_products
WHERE enterprise_id = %s AND name = %s AND status != 'deleted'
21:54:34 - article_server - INFO - [SQL参数] (1, '产品（2）')
21:54:34 - article_server - INFO - [SQL结果] 查询完成，返回 0 条记录
21:54:34 - article_server - INFO - [创建产品] 开始插入产品数据, 名称: 产品（2）, 企业ID: 1
21:54:34 - article_server - INFO - [SQL执行] 开始执行插入SQL
21:54:34 - article_server - INFO - [SQL语句]
INSERT INTO ai_products
(enterprise_id, name, type_id, type_name, knowledge, status, articles_total, published_total, image_url, image_thumbnail_url)
VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s)
21:54:34 - article_server - INFO - [SQL参数] (1, '产品（2）', 1, '防护品', '产品（2）产品（2）产品（2）', 'active', 0, 0, 'http://images16.bxmkb.cn/Images/20251201/1764586631888883_thumb.png', '')
21:54:34 - article_server - INFO - [SQL结果] 插入完成，新记录ID: 24
21:54:34 - article_server - INFO - [创建产品] 产品插入成功, ID: 24, 名称: 产品（2）, 企业ID: 1
21:54:34 - article_server - INFO - [创建产品] 开始更新企业产品总数, 企业ID: 1
21:54:34 - article_server - INFO - [SQL执行] 开始执行更新SQL
21:54:34 - article_server - INFO - [SQL语句] UPDATE ai_enterprises SET products_total = products_total + 1 WHERE id = %s
21:54:34 - article_server - INFO - [SQL参数] (1,)
21:54:34 - article_server - INFO - [SQL结果] 更新完成，影响 1 行
21:54:34 - article_server - INFO - [创建产品] 产品创建全部完成, ID: 24, 名称: 产品（2）, 企业ID: 1, IP: 36.27.52.26
21:54:34 - article_server - INFO - [SQL执行] 开始执行插入SQL
21:54:34 - 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())
21:54:34 - article_server - INFO - [SQL参数] (4, 'create_product', 'product', 24, '创建产品: 产品（2）', '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', '{"name": "产品（2）", "type_id": 1, "type_name": "防护品", "knowledge": "产品（2）产品（2）产品（2）", "image_url": "http://images16.bxmkb.cn/Images/20251201/1764586631888883_thumb.png"}', '{"id": 24}', 'success', None)
21:54:34 - article_server - INFO - [SQL结果] 插入完成，新记录ID: 23
21:54:34 - article_server - INFO - [业务日志] 操作: create_product | 用户ID: 4 | 目标: product#24 | 状态: success | IP: 36.27.52.26 | 日志ID: 23
21:54:34 - article_server - INFO - [API响应] POST /api/products/create - IP: 36.27.52.26 - 状态码: 200
21:54:34 - 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
21:54:34 - article_server - INFO - [Token验证成功] 用户ID: 4
21:54:34 - article_server - INFO - [获取产品列表] 开始处理请求, IP: 36.27.52.26
21:54:34 - article_server - INFO - [获取产品列表] 用户信息 - 用户ID: 4, 企业ID: 1, IP: 36.27.52.26
21:54:34 - article_server - INFO - [获取产品列表] 查询参数: page=1, pageSize=20, keyword=, type=, status=, 企业ID: 1, IP: 36.27.52.26
21:54:35 - article_server - INFO - [SQL执行] 开始执行查询SQL
21:54:35 - article_server - INFO - [SQL语句] SELECT COUNT(*) as total FROM ai_products WHERE enterprise_id = %s AND status != 'deleted'
21:54:35 - article_server - INFO - [SQL参数] [1]
21:54:35 - article_server - INFO - [SQL结果] 查询完成，返回 1 条记录
21:54:35 - article_server - INFO - [SQL数据] 查询结果: [{'total': 5}]
21:54:35 - article_server - INFO - [SQL执行] 开始执行查询SQL
21:54:35 - 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
21:54:35 - article_server - INFO - [SQL参数] [1, 20, 0]
21:54:35 - article_server - INFO - [SQL结果] 查询完成，返回 5 条记录
21:54:35 - article_server - INFO - [SQL执行] 开始执行查询SQL
21:54:35 - article_server - INFO - [SQL语句]
SELECT id, tag_name
FROM ai_product_tags
WHERE product_id = %s
21:54:35 - article_server - INFO - [SQL参数] (24,)
21:54:35 - article_server - INFO - [SQL结果] 查询完成，返回 0 条记录
21:54:35 - article_server - INFO - [SQL执行] 开始执行查询SQL
21:54:35 - article_server - INFO - [SQL语句]
SELECT id, tag_name
FROM ai_product_tags
WHERE product_id = %s
21:54:35 - article_server - INFO - [SQL参数] (13,)
21:54:35 - article_server - INFO - [SQL结果] 查询完成，返回 0 条记录
21:54:35 - article_server - INFO - [SQL执行] 开始执行查询SQL
21:54:35 - article_server - INFO - [SQL语句]
SELECT id, tag_name
FROM ai_product_tags
WHERE product_id = %s
21:54:35 - article_server - INFO - [SQL参数] (12,)
21:54:35 - article_server - INFO - [SQL结果] 查询完成，返回 0 条记录
21:54:35 - article_server - INFO - [SQL执行] 开始执行查询SQL
21:54:35 - article_server - INFO - [SQL语句]
SELECT id, tag_name
FROM ai_product_tags
WHERE product_id = %s
21:54:35 - article_server - INFO - [SQL参数] (11,)
21:54:35 - article_server - INFO - [SQL结果] 查询完成，返回 0 条记录
21:54:35 - article_server - INFO - [SQL执行] 开始执行查询SQL
21:54:35 - article_server - INFO - [SQL语句]
SELECT id, tag_name
FROM ai_product_tags
WHERE product_id = %s
21:54:35 - article_server - INFO - [SQL参数] (1,)
21:54:35 - article_server - INFO - [SQL结果] 查询完成，返回 1 条记录
21:54:35 - article_server - INFO - [SQL数据] 查询结果: [{'id': 1, 'tag_name': '保湿'}]
21:54:35 - article_server - INFO - [获取产品列表] 查询成功, 总数: 5, 当前页: 1, 每页: 20, 返回数量: 5, 企业ID: 1, IP: 36.27.52.26
21:54:35 - article_server - INFO - [API响应] GET /api/products/list - IP: 36.27.52.26 - 状态码: 200
21:54:38 - 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
21:54:38 - article_server - INFO - [Token验证成功] 用户ID: 4
21:54:38 - article_server - INFO - [获取产品列表] 开始处理请求, IP: 36.27.52.26
21:54:38 - article_server - INFO - [获取产品列表] 用户信息 - 用户ID: 4, 企业ID: 1, IP: 36.27.52.26
21:54:38 - article_server - INFO - [获取产品列表] 查询参数: page=1, pageSize=20, keyword=, type=, status=, 企业ID: 1, IP: 36.27.52.26
21:54:38 - article_server - INFO - [API访问] GET /api/products/types/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
21:54:38 - article_server - INFO - [Token验证成功] 用户ID: 4
21:54:38 - article_server - INFO - [获取企业产品类型列表] 开始处理请求, IP: 36.27.52.26
21:54:38 - article_server - INFO - [获取企业产品类型列表] 企业ID: 1, IP: 36.27.52.26
21:54:38 - 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
21:54:38 - article_server - INFO - [Token验证成功] 用户ID: 4
21:54:38 - article_server - INFO - [获取用户信息] 开始处理请求, IP: 36.27.52.26
21:54:38 - article_server - INFO - [获取用户信息] 用户ID: 4, IP: 36.27.52.26
21:54:38 - article_server - INFO - [SQL执行] 开始执行查询SQL
21:54:38 - 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'
21:54:38 - article_server - INFO - [SQL参数] (4,)
21:54:38 - article_server - INFO - [SQL执行] 开始执行查询SQL
21:54:38 - article_server - INFO - [SQL语句] SELECT COUNT(*) as total FROM ai_products WHERE enterprise_id = %s AND status != 'deleted'
21:54:38 - article_server - INFO - [SQL参数] [1]
21:54:38 - article_server - INFO - [SQL执行] 开始执行查询SQL
21:54:38 - article_server - INFO - [SQL语句] SELECT COUNT(*) as total FROM ai_product_types WHERE enterprise_id = %s
21:54:38 - article_server - INFO - [SQL参数] [1]
21:54:38 - article_server - INFO - [SQL结果] 查询完成，返回 1 条记录
21:54:38 - 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)}]
21:54:38 - article_server - INFO - [SQL结果] 查询完成，返回 1 条记录
21:54:38 - article_server - INFO - [SQL数据] 查询结果: [{'total': 5}]
21:54:38 - article_server - INFO - [SQL结果] 查询完成，返回 1 条记录
21:54:38 - article_server - INFO - [SQL数据] 查询结果: [{'total': 0}]
21:54:38 - article_server - INFO - [获取用户信息] 查询成功, 用户: user004, 角色: enterprise, 企业: rwl企业4号, IP: 36.27.52.26
21:54:38 - article_server - INFO - [SQL执行] 开始执行插入SQL
21:54:38 - 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())
21:54:38 - 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)
21:54:38 - article_server - INFO - [SQL执行] 开始执行查询SQL
21:54:38 - article_server - INFO - [SQL语句]
SELECT id, type_name, enterprise_id, product_id, created_at
FROM ai_product_types
WHERE enterprise_id = %s
ORDER BY created_at DESC
LIMIT %s OFFSET %s
21:54:38 - article_server - INFO - [SQL参数] [1, 100, 0]
21:54:38 - article_server - INFO - [SQL执行] 开始执行查询SQL
21:54:38 - 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
21:54:38 - article_server - INFO - [SQL参数] [1, 20, 0]
21:54:38 - article_server - INFO - [SQL结果] 插入完成，新记录ID: 24
21:54:38 - article_server - INFO - [SQL结果] 查询完成，返回 0 条记录
21:54:38 - article_server - INFO - [SQL结果] 查询完成，返回 5 条记录
21:54:38 - article_server - INFO - [业务日志] 操作: get_user_info | 用户ID: 4 | 目标: user#4 | 状态: success | IP: 36.27.52.26 | 日志ID: 24
21:54:38 - article_server - INFO - [API响应] GET /api/users/info - IP: 36.27.52.26 - 状态码: 200
21:54:38 - article_server - INFO - [获取企业产品类型列表] 查询成功, 企业ID: 1, 总数: 0, 返回: 0, IP: 36.27.52.26
21:54:38 - article_server - INFO - [API响应] GET /api/products/types/list - IP: 36.27.52.26 - 状态码: 200
21:54:38 - article_server - INFO - [SQL执行] 开始执行查询SQL
21:54:38 - article_server - INFO - [SQL语句]
SELECT id, tag_name
FROM ai_product_tags
WHERE product_id = %s
21:54:38 - article_server - INFO - [SQL参数] (24,)
21:54:38 - article_server - INFO - [SQL结果] 查询完成，返回 0 条记录
21:54:38 - article_server - INFO - [SQL执行] 开始执行查询SQL
21:54:38 - article_server - INFO - [SQL语句]
SELECT id, tag_name
FROM ai_product_tags
WHERE product_id = %s
21:54:38 - article_server - INFO - [SQL参数] (13,)
21:54:38 - article_server - INFO - [SQL结果] 查询完成，返回 0 条记录
21:54:38 - article_server - INFO - [SQL执行] 开始执行查询SQL
21:54:38 - article_server - INFO - [SQL语句]
SELECT id, tag_name
FROM ai_product_tags
WHERE product_id = %s
21:54:38 - article_server - INFO - [SQL参数] (12,)
21:54:38 - article_server - INFO - [SQL结果] 查询完成，返回 0 条记录
21:54:38 - article_server - INFO - [SQL执行] 开始执行查询SQL
21:54:38 - article_server - INFO - [SQL语句]
SELECT id, tag_name
FROM ai_product_tags
WHERE product_id = %s
21:54:38 - article_server - INFO - [SQL参数] (11,)
21:54:38 - article_server - INFO - [SQL结果] 查询完成，返回 0 条记录
21:54:38 - article_server - INFO - [SQL执行] 开始执行查询SQL
21:54:38 - article_server - INFO - [SQL语句]
SELECT id, tag_name
FROM ai_product_tags
WHERE product_id = %s
21:54:38 - article_server - INFO - [SQL参数] (1,)
21:54:38 - article_server - INFO - [SQL结果] 查询完成，返回 1 条记录
21:54:38 - article_server - INFO - [SQL数据] 查询结果: [{'id': 1, 'tag_name': '保湿'}]
21:54:38 - article_server - INFO - [获取产品列表] 查询成功, 总数: 5, 当前页: 1, 每页: 20, 返回数量: 5, 企业ID: 1, IP: 36.27.52.26
21:54:38 - article_server - INFO - [API响应] GET /api/products/list - IP: 36.27.52.26 - 状态码: 200
21:55:21 - 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
21:55:21 - article_server - INFO - [API访问] GET /api/products/types/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
21:55:21 - article_server - INFO - [Token验证成功] 用户ID: 4
21:55:21 - article_server - INFO - [获取产品列表] 开始处理请求, IP: 36.27.52.26
21:55:21 - article_server - INFO - [获取产品列表] 用户信息 - 用户ID: 4, 企业ID: 1, IP: 36.27.52.26
21:55:21 - article_server - INFO - [获取产品列表] 查询参数: page=1, pageSize=20, keyword=, type=, status=, 企业ID: 1, IP: 36.27.52.26
21:55:21 - 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
21:55:21 - article_server - INFO - [Token验证成功] 用户ID: 4
21:55:21 - article_server - INFO - [获取企业产品类型列表] 开始处理请求, IP: 36.27.52.26
21:55:21 - article_server - INFO - [获取企业产品类型列表] 企业ID: 1, IP: 36.27.52.26
21:55:21 - article_server - INFO - [Token验证成功] 用户ID: 4
21:55:21 - article_server - INFO - [获取用户信息] 开始处理请求, IP: 36.27.52.26
21:55:21 - article_server - INFO - [获取用户信息] 用户ID: 4, IP: 36.27.52.26
21:55:21 - article_server - INFO - [SQL执行] 开始执行查询SQL
21:55:21 - 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'
21:55:21 - article_server - INFO - [SQL参数] (4,)
21:55:21 - article_server - INFO - [SQL执行] 开始执行查询SQL
21:55:21 - article_server - INFO - [SQL语句] SELECT COUNT(*) as total FROM ai_product_types WHERE enterprise_id = %s
21:55:21 - article_server - INFO - [SQL参数] [1]
21:55:21 - article_server - INFO - [SQL结果] 查询完成，返回 1 条记录
21:55:21 - 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)}]
21:55:21 - article_server - INFO - [SQL结果] 查询完成，返回 1 条记录
21:55:21 - article_server - INFO - [SQL数据] 查询结果: [{'total': 0}]
21:55:21 - article_server - INFO - [获取用户信息] 查询成功, 用户: user004, 角色: enterprise, 企业: rwl企业4号, IP: 36.27.52.26
21:55:21 - article_server - INFO - [SQL执行] 开始执行插入SQL
21:55:21 - 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())
21:55:21 - 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)
21:55:21 - article_server - INFO - [SQL执行] 开始执行查询SQL
21:55:21 - article_server - INFO - [SQL语句]
SELECT id, type_name, enterprise_id, product_id, created_at
FROM ai_product_types
WHERE enterprise_id = %s
ORDER BY created_at DESC
LIMIT %s OFFSET %s
21:55:21 - article_server - INFO - [SQL参数] [1, 100, 0]
21:55:21 - article_server - INFO - [SQL结果] 插入完成，新记录ID: 25
21:55:21 - article_server - INFO - [SQL结果] 查询完成，返回 0 条记录
21:55:21 - article_server - INFO - 数据库连接成功，字符集设置完成
21:55:21 - article_server - INFO - [SQL执行] 开始执行查询SQL
21:55:21 - article_server - INFO - [SQL语句] SELECT COUNT(*) as total FROM ai_products WHERE enterprise_id = %s AND status != 'deleted'
21:55:21 - article_server - INFO - [SQL参数] [1]
21:55:21 - article_server - INFO - [业务日志] 操作: get_user_info | 用户ID: 4 | 目标: user#4 | 状态: success | IP: 36.27.52.26 | 日志ID: 25
21:55:21 - article_server - INFO - [API响应] GET /api/users/info - IP: 36.27.52.26 - 状态码: 200
21:55:21 - article_server - INFO - [获取企业产品类型列表] 查询成功, 企业ID: 1, 总数: 0, 返回: 0, IP: 36.27.52.26
21:55:21 - article_server - INFO - [API响应] GET /api/products/types/list - IP: 36.27.52.26 - 状态码: 200
21:55:21 - article_server - INFO - [SQL结果] 查询完成，返回 1 条记录
21:55:21 - article_server - INFO - [SQL数据] 查询结果: [{'total': 5}]
21:55:21 - article_server - INFO - [SQL执行] 开始执行查询SQL
21:55:21 - 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
21:55:21 - article_server - INFO - [SQL参数] [1, 20, 0]
21:55:21 - article_server - INFO - [SQL结果] 查询完成，返回 5 条记录
21:55:22 - article_server - INFO - [SQL执行] 开始执行查询SQL
21:55:22 - article_server - INFO - [SQL语句]
SELECT id, tag_name
FROM ai_product_tags
WHERE product_id = %s
21:55:22 - article_server - INFO - [SQL参数] (24,)
21:55:22 - article_server - INFO - [SQL结果] 查询完成，返回 0 条记录
21:55:22 - article_server - INFO - [SQL执行] 开始执行查询SQL
21:55:22 - article_server - INFO - [SQL语句]
SELECT id, tag_name
FROM ai_product_tags
WHERE product_id = %s
21:55:22 - article_server - INFO - [SQL参数] (13,)
21:55:22 - article_server - INFO - [SQL结果] 查询完成，返回 0 条记录
21:55:22 - article_server - INFO - [SQL执行] 开始执行查询SQL
21:55:22 - article_server - INFO - [SQL语句]
SELECT id, tag_name
FROM ai_product_tags
WHERE product_id = %s
21:55:22 - article_server - INFO - [SQL参数] (12,)
21:55:22 - article_server - INFO - [SQL结果] 查询完成，返回 0 条记录
21:55:22 - article_server - INFO - [SQL执行] 开始执行查询SQL
21:55:22 - article_server - INFO - [SQL语句]
SELECT id, tag_name
FROM ai_product_tags
WHERE product_id = %s
21:55:22 - article_server - INFO - [SQL参数] (11,)
21:55:22 - article_server - INFO - [SQL结果] 查询完成，返回 0 条记录
21:55:22 - article_server - INFO - [SQL执行] 开始执行查询SQL
21:55:22 - article_server - INFO - [SQL语句]
SELECT id, tag_name
FROM ai_product_tags
WHERE product_id = %s
21:55:22 - article_server - INFO - [SQL参数] (1,)
21:55:22 - article_server - INFO - [SQL结果] 查询完成，返回 1 条记录
21:55:22 - article_server - INFO - [SQL数据] 查询结果: [{'id': 1, 'tag_name': '保湿'}]
21:55:22 - article_server - INFO - [获取产品列表] 查询成功, 总数: 5, 当前页: 1, 每页: 20, 返回数量: 5, 企业ID: 1, IP: 36.27.52.26
21:55:22 - article_server - INFO - [API响应] GET /api/products/list - IP: 36.27.52.26 - 状态码: 200
21:57:32 - article_server - INFO - [API访问] PUT /api/products/24 - 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
21:57:32 - article_server - INFO - [Token验证成功] 用户ID: 4
21:57:32 - article_server - INFO - [SQL执行] 开始执行查询SQL
21:57:32 - article_server - INFO - [SQL语句] SELECT id FROM ai_products WHERE id = %s AND enterprise_id = %s AND status != 'deleted'
21:57:32 - article_server - INFO - [SQL参数] (24, 1)
21:57:33 - article_server - INFO - [SQL结果] 查询完成，返回 1 条记录
21:57:33 - article_server - INFO - [SQL数据] 查询结果: [{'id': 24}]
21:57:33 - article_server - INFO - [SQL执行] 开始执行更新SQL
21:57:33 - article_server - INFO - [SQL语句] UPDATE ai_products SET name = %s, type_name = %s, knowledge = %s, updated_at = NOW() WHERE id = %s
21:57:33 - article_server - INFO - [SQL参数] ['产品（2）', '防护品', '产品（2）产品（2）产品（2）', 24]
21:57:33 - article_server - INFO - [SQL结果] 更新完成，影响 1 行
21:57:33 - article_server - INFO - 更新产品成功: ID 24
21:57:33 - article_server - INFO - [SQL执行] 开始执行插入SQL
21:57:33 - 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())
21:57:33 - article_server - INFO - [SQL参数] (4, 'update_product', 'product', 24, '更新产品信息', '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', '{"name": "产品（2）", "type_name": "防护品", "knowledge": "产品（2）产品（2）产品（2）"}', None, 'success', None)
21:57:33 - article_server - INFO - [SQL结果] 插入完成，新记录ID: 26
21:57:33 - article_server - INFO - [业务日志] 操作: update_product | 用户ID: 4 | 目标: product#24 | 状态: success | IP: 36.27.52.26 | 日志ID: 26
21:57:33 - article_server - INFO - [API响应] PUT /api/products/24 - IP: 36.27.52.26 - 状态码: 200
21:57:33 - 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
21:57:33 - article_server - INFO - [Token验证成功] 用户ID: 4
21:57:33 - article_server - INFO - [获取产品列表] 开始处理请求, IP: 36.27.52.26
21:57:33 - article_server - INFO - [获取产品列表] 用户信息 - 用户ID: 4, 企业ID: 1, IP: 36.27.52.26
21:57:33 - article_server - INFO - [获取产品列表] 查询参数: page=1, pageSize=20, keyword=, type=, status=, 企业ID: 1, IP: 36.27.52.26
21:57:33 - article_server - INFO - [SQL执行] 开始执行查询SQL
21:57:33 - article_server - INFO - [SQL语句] SELECT COUNT(*) as total FROM ai_products WHERE enterprise_id = %s AND status != 'deleted'
21:57:33 - article_server - INFO - [SQL参数] [1]
21:57:33 - article_server - INFO - [SQL结果] 查询完成，返回 1 条记录
21:57:33 - article_server - INFO - [SQL数据] 查询结果: [{'total': 5}]
21:57:33 - article_server - INFO - [SQL执行] 开始执行查询SQL
21:57:33 - 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
21:57:33 - article_server - INFO - [SQL参数] [1, 20, 0]
21:57:33 - article_server - INFO - [SQL结果] 查询完成，返回 5 条记录
21:57:33 - article_server - INFO - [SQL执行] 开始执行查询SQL
21:57:33 - article_server - INFO - [SQL语句]
SELECT id, tag_name
FROM ai_product_tags
WHERE product_id = %s
21:57:33 - article_server - INFO - [SQL参数] (24,)
21:57:33 - article_server - INFO - [SQL结果] 查询完成，返回 0 条记录
21:57:33 - article_server - INFO - [SQL执行] 开始执行查询SQL
21:57:33 - article_server - INFO - [SQL语句]
SELECT id, tag_name
FROM ai_product_tags
WHERE product_id = %s
21:57:33 - article_server - INFO - [SQL参数] (13,)
21:57:33 - article_server - INFO - [SQL结果] 查询完成，返回 0 条记录
21:57:33 - article_server - INFO - [SQL执行] 开始执行查询SQL
21:57:33 - article_server - INFO - [SQL语句]
SELECT id, tag_name
FROM ai_product_tags
WHERE product_id = %s
21:57:33 - article_server - INFO - [SQL参数] (12,)
21:57:33 - article_server - INFO - [SQL结果] 查询完成，返回 0 条记录
21:57:33 - article_server - INFO - [SQL执行] 开始执行查询SQL
21:57:33 - article_server - INFO - [SQL语句]
SELECT id, tag_name
FROM ai_product_tags
WHERE product_id = %s
21:57:33 - article_server - INFO - [SQL参数] (11,)
21:57:33 - article_server - INFO - [SQL结果] 查询完成，返回 0 条记录
21:57:33 - article_server - INFO - [SQL执行] 开始执行查询SQL
21:57:33 - article_server - INFO - [SQL语句]
SELECT id, tag_name
FROM ai_product_tags
WHERE product_id = %s
21:57:33 - article_server - INFO - [SQL参数] (1,)
21:57:33 - article_server - INFO - [SQL结果] 查询完成，返回 1 条记录
21:57:33 - article_server - INFO - [SQL数据] 查询结果: [{'id': 1, 'tag_name': '保湿'}]
21:57:33 - article_server - INFO - [获取产品列表] 查询成功, 总数: 5, 当前页: 1, 每页: 20, 返回数量: 5, 企业ID: 1, IP: 36.27.52.26
21:57:33 - article_server - INFO - [API响应] GET /api/products/list - IP: 36.27.52.26 - 状态码: 200
21:57:35 - 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
21:57:35 - article_server - INFO - [Token验证成功] 用户ID: 4
21:57:35 - article_server - INFO - [获取产品列表] 开始处理请求, IP: 36.27.52.26
21:57:35 - article_server - INFO - [获取产品列表] 用户信息 - 用户ID: 4, 企业ID: 1, IP: 36.27.52.26
21:57:35 - article_server - INFO - [获取产品列表] 查询参数: page=1, pageSize=20, keyword=, type=, status=, 企业ID: 1, IP: 36.27.52.26
21:57:35 - article_server - INFO - [API访问] GET /api/products/types/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
21:57:35 - article_server - INFO - [Token验证成功] 用户ID: 4
21:57:35 - article_server - INFO - [获取企业产品类型列表] 开始处理请求, IP: 36.27.52.26
21:57:35 - article_server - INFO - [获取企业产品类型列表] 企业ID: 1, IP: 36.27.52.26
21:57:35 - article_server - INFO - [SQL执行] 开始执行查询SQL
21:57:35 - article_server - INFO - [SQL语句] SELECT COUNT(*) as total FROM ai_products WHERE enterprise_id = %s AND status != 'deleted'
21:57:35 - article_server - INFO - [SQL参数] [1]
21:57:35 - article_server - INFO - [SQL执行] 开始执行查询SQL
21:57:35 - article_server - INFO - [SQL结果] 查询完成，返回 1 条记录
21:57:35 - article_server - INFO - [SQL语句] SELECT COUNT(*) as total FROM ai_product_types WHERE enterprise_id = %s
21:57:35 - article_server - INFO - [SQL数据] 查询结果: [{'total': 5}]
21:57:35 - article_server - INFO - [SQL参数] [1]
21:57:35 - article_server - INFO - [SQL结果] 查询完成，返回 1 条记录
21:57:35 - article_server - INFO - [SQL数据] 查询结果: [{'total': 0}]
21:57:35 - 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
21:57:35 - article_server - INFO - [Token验证成功] 用户ID: 4
21:57:35 - article_server - INFO - [获取用户信息] 开始处理请求, IP: 36.27.52.26
21:57:35 - article_server - INFO - [获取用户信息] 用户ID: 4, IP: 36.27.52.26
21:57:35 - article_server - INFO - [SQL执行] 开始执行查询SQL
21:57:35 - 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
21:57:35 - article_server - INFO - [SQL参数] [1, 20, 0]
21:57:35 - article_server - INFO - [SQL执行] 开始执行查询SQL
21:57:35 - 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'
21:57:35 - article_server - INFO - [SQL参数] (4,)
21:57:35 - article_server - INFO - [SQL结果] 查询完成，返回 5 条记录
21:57:35 - article_server - INFO - [SQL结果] 查询完成，返回 1 条记录
21:57:35 - 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)}]
21:57:35 - article_server - INFO - [SQL执行] 开始执行查询SQL
21:57:35 - article_server - INFO - [SQL语句]
SELECT id, type_name, enterprise_id, product_id, created_at
FROM ai_product_types
WHERE enterprise_id = %s
ORDER BY created_at DESC
LIMIT %s OFFSET %s
21:57:35 - article_server - INFO - [SQL参数] [1, 100, 0]
21:57:35 - article_server - INFO - [获取用户信息] 查询成功, 用户: user004, 角色: enterprise, 企业: rwl企业4号, IP: 36.27.52.26
21:57:35 - article_server - INFO - [SQL结果] 查询完成，返回 0 条记录
21:57:35 - article_server - INFO - [SQL执行] 开始执行查询SQL
21:57:35 - article_server - INFO - [SQL语句]
SELECT id, tag_name
FROM ai_product_tags
WHERE product_id = %s
21:57:35 - article_server - INFO - [SQL参数] (24,)
21:57:35 - article_server - INFO - [SQL执行] 开始执行插入SQL
21:57:35 - 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())
21:57:35 - 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)
21:57:35 - article_server - INFO - [获取企业产品类型列表] 查询成功, 企业ID: 1, 总数: 0, 返回: 0, IP: 36.27.52.26
21:57:35 - article_server - INFO - [API响应] GET /api/products/types/list - IP: 36.27.52.26 - 状态码: 200
21:57:35 - article_server - INFO - [SQL结果] 查询完成，返回 0 条记录
21:57:35 - article_server - INFO - [SQL结果] 插入完成，新记录ID: 27
21:57:35 - article_server - INFO - [业务日志] 操作: get_user_info | 用户ID: 4 | 目标: user#4 | 状态: success | IP: 36.27.52.26 | 日志ID: 27
21:57:35 - article_server - INFO - [API响应] GET /api/users/info - IP: 36.27.52.26 - 状态码: 200
21:57:35 - article_server - INFO - [SQL执行] 开始执行查询SQL
21:57:35 - article_server - INFO - [SQL语句]
SELECT id, tag_name
FROM ai_product_tags
WHERE product_id = %s
21:57:35 - article_server - INFO - [SQL参数] (13,)
21:57:36 - article_server - INFO - [SQL结果] 查询完成，返回 0 条记录
21:57:36 - article_server - INFO - [SQL执行] 开始执行查询SQL
21:57:36 - article_server - INFO - [SQL语句]
SELECT id, tag_name
FROM ai_product_tags
WHERE product_id = %s
21:57:36 - article_server - INFO - [SQL参数] (12,)
21:57:36 - article_server - INFO - [SQL结果] 查询完成，返回 0 条记录
21:57:36 - article_server - INFO - [SQL执行] 开始执行查询SQL
21:57:36 - article_server - INFO - [SQL语句]
SELECT id, tag_name
FROM ai_product_tags
WHERE product_id = %s
21:57:36 - article_server - INFO - [SQL参数] (11,)
21:57:36 - article_server - INFO - [SQL结果] 查询完成，返回 0 条记录
21:57:36 - article_server - INFO - [SQL执行] 开始执行查询SQL
21:57:36 - article_server - INFO - [SQL语句]
SELECT id, tag_name
FROM ai_product_tags
WHERE product_id = %s
21:57:36 - article_server - INFO - [SQL参数] (1,)
21:57:36 - article_server - INFO - [SQL结果] 查询完成，返回 1 条记录
21:57:36 - article_server - INFO - [SQL数据] 查询结果: [{'id': 1, 'tag_name': '保湿'}]
21:57:36 - article_server - INFO - [获取产品列表] 查询成功, 总数: 5, 当前页: 1, 每页: 20, 返回数量: 5, 企业ID: 1, IP: 36.27.52.26
21:57:36 - article_server - INFO - [API响应] GET /api/products/list - IP: 36.27.52.26 - 状态码: 200
21:57:58 - article_server - INFO - [API访问] POST /api/products/create - 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
21:57:58 - article_server - INFO - [Token验证成功] 用户ID: 4
21:57:58 - article_server - INFO - [创建产品] 开始处理创建产品请求, IP: 36.27.52.26
21:57:58 - article_server - INFO - [创建产品] 用户信息 - 用户ID: 4, 企业ID: 1, IP: 36.27.52.26
21:57:58 - article_server - INFO - [创建产品] 收到创建请求, 产品名称: 产品（2）, 类型: 护肤品, 企业ID: 1, IP: 36.27.52.26
21:57:58 - article_server - INFO - [创建产品] 开始检查产品名称是否重复, 名称: 产品（2）, 企业ID: 1
21:57:58 - article_server - INFO - [SQL执行] 开始执行查询SQL
21:57:58 - article_server - INFO - [SQL语句]
SELECT id, name FROM ai_products
WHERE enterprise_id = %s AND name = %s AND status != 'deleted'
21:57:58 - article_server - INFO - [SQL参数] (1, '产品（2）')
21:57:58 - article_server - INFO - [SQL结果] 查询完成，返回 1 条记录
21:57:58 - article_server - INFO - [SQL数据] 查询结果: [{'id': 24, 'name': '产品（2）'}]
21:57:58 - article_server - WARNING - [创建产品] 产品名称已存在, 名称: 产品（2）, 已存在ID: 24, 企业ID: 1, IP: 36.27.52.26
21:57:58 - article_server - INFO - [API响应] POST /api/products/create - IP: 36.27.52.26 - 状态码: 409
21:58:02 - article_server - INFO - [API访问] POST /api/products/create - 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
21:58:02 - article_server - INFO - [Token验证成功] 用户ID: 4
21:58:02 - article_server - INFO - [创建产品] 开始处理创建产品请求, IP: 36.27.52.26
21:58:02 - article_server - INFO - [创建产品] 用户信息 - 用户ID: 4, 企业ID: 1, IP: 36.27.52.26
21:58:02 - article_server - INFO - [创建产品] 收到创建请求, 产品名称: 产品（2）1, 类型: 护肤品, 企业ID: 1, IP: 36.27.52.26
21:58:02 - article_server - INFO - [创建产品] 开始检查产品名称是否重复, 名称: 产品（2）1, 企业ID: 1
21:58:02 - article_server - INFO - [SQL执行] 开始执行查询SQL
21:58:02 - article_server - INFO - [SQL语句]
SELECT id, name FROM ai_products
WHERE enterprise_id = %s AND name = %s AND status != 'deleted'
21:58:02 - article_server - INFO - [SQL参数] (1, '产品（2）1')
21:58:02 - article_server - INFO - [SQL结果] 查询完成，返回 0 条记录
21:58:02 - article_server - INFO - [创建产品] 开始插入产品数据, 名称: 产品（2）1, 企业ID: 1
21:58:02 - article_server - INFO - [SQL执行] 开始执行插入SQL
21:58:02 - article_server - INFO - [SQL语句]
INSERT INTO ai_products
(enterprise_id, name, type_id, type_name, knowledge, status, articles_total, published_total, image_url, image_thumbnail_url)
VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s)
21:58:02 - article_server - INFO - [SQL参数] (1, '产品（2）1', 1, '护肤品', '产品（2）产品（2）产品（2）', 'active', 0, 0, 'https://pic2.zhimg.com/v2-f2baf85af5f74f1371afbd41f8f42651_r.jpg', '')
21:58:02 - article_server - INFO - [SQL结果] 插入完成，新记录ID: 25
21:58:02 - article_server - INFO - [创建产品] 产品插入成功, ID: 25, 名称: 产品（2）1, 企业ID: 1
21:58:02 - article_server - INFO - [创建产品] 开始更新企业产品总数, 企业ID: 1
21:58:02 - article_server - INFO - [SQL执行] 开始执行更新SQL
21:58:02 - article_server - INFO - [SQL语句] UPDATE ai_enterprises SET products_total = products_total + 1 WHERE id = %s
21:58:02 - article_server - INFO - [SQL参数] (1,)
21:58:02 - article_server - INFO - [SQL结果] 更新完成，影响 1 行
21:58:02 - article_server - INFO - [创建产品] 产品创建全部完成, ID: 25, 名称: 产品（2）1, 企业ID: 1, IP: 36.27.52.26
21:58:02 - article_server - INFO - [SQL执行] 开始执行插入SQL
21:58:02 - 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())
21:58:02 - article_server - INFO - [SQL参数] (4, 'create_product', 'product', 25, '创建产品: 产品（2）1', '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', '{"name": "产品（2）1", "type_id": 1, "type_name": "护肤品", "knowledge": "产品（2）产品（2）产品（2）", "image_url": "https://pic2.zhimg.com/v2-f2baf85af5f74f1371afbd41f8f42651_r.jpg"}', '{"id": 25}', 'success', None)
21:58:02 - article_server - INFO - [SQL结果] 插入完成，新记录ID: 28
21:58:02 - article_server - INFO - [业务日志] 操作: create_product | 用户ID: 4 | 目标: product#25 | 状态: success | IP: 36.27.52.26 | 日志ID: 28
21:58:02 - article_server - INFO - [API响应] POST /api/products/create - IP: 36.27.52.26 - 状态码: 200
21:58:02 - 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
21:58:02 - article_server - INFO - [Token验证成功] 用户ID: 4
21:58:02 - article_server - INFO - [获取产品列表] 开始处理请求, IP: 36.27.52.26
21:58:02 - article_server - INFO - [获取产品列表] 用户信息 - 用户ID: 4, 企业ID: 1, IP: 36.27.52.26
21:58:02 - article_server - INFO - [获取产品列表] 查询参数: page=1, pageSize=20, keyword=, type=, status=, 企业ID: 1, IP: 36.27.52.26
21:58:02 - article_server - INFO - [SQL执行] 开始执行查询SQL
21:58:02 - article_server - INFO - [SQL语句] SELECT COUNT(*) as total FROM ai_products WHERE enterprise_id = %s AND status != 'deleted'
21:58:02 - article_server - INFO - [SQL参数] [1]
21:58:02 - article_server - INFO - [SQL结果] 查询完成，返回 1 条记录
21:58:02 - article_server - INFO - [SQL数据] 查询结果: [{'total': 6}]
21:58:02 - article_server - INFO - [SQL执行] 开始执行查询SQL
21:58:02 - 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
21:58:02 - article_server - INFO - [SQL参数] [1, 20, 0]
21:58:02 - article_server - INFO - [SQL结果] 查询完成，返回 6 条记录
21:58:02 - article_server - INFO - [SQL执行] 开始执行查询SQL
21:58:02 - article_server - INFO - [SQL语句]
SELECT id, tag_name
FROM ai_product_tags
WHERE product_id = %s
21:58:02 - article_server - INFO - [SQL参数] (25,)
21:58:02 - article_server - INFO - [SQL结果] 查询完成，返回 0 条记录
21:58:02 - article_server - INFO - [SQL执行] 开始执行查询SQL
21:58:02 - article_server - INFO - [SQL语句]
SELECT id, tag_name
FROM ai_product_tags
WHERE product_id = %s
21:58:02 - article_server - INFO - [SQL参数] (24,)
21:58:02 - article_server - INFO - [SQL结果] 查询完成，返回 0 条记录
21:58:02 - article_server - INFO - [SQL执行] 开始执行查询SQL
21:58:02 - article_server - INFO - [SQL语句]
SELECT id, tag_name
FROM ai_product_tags
WHERE product_id = %s
21:58:02 - article_server - INFO - [SQL参数] (13,)
21:58:02 - article_server - INFO - [SQL结果] 查询完成，返回 0 条记录
21:58:02 - article_server - INFO - [SQL执行] 开始执行查询SQL
21:58:02 - article_server - INFO - [SQL语句]
SELECT id, tag_name
FROM ai_product_tags
WHERE product_id = %s
21:58:02 - article_server - INFO - [SQL参数] (12,)
21:58:02 - article_server - INFO - [SQL结果] 查询完成，返回 0 条记录
21:58:03 - article_server - INFO - [SQL执行] 开始执行查询SQL
21:58:03 - article_server - INFO - [SQL语句]
SELECT id, tag_name
FROM ai_product_tags
WHERE product_id = %s
21:58:03 - article_server - INFO - [SQL参数] (11,)
21:58:03 - article_server - INFO - [SQL结果] 查询完成，返回 0 条记录
21:58:03 - article_server - INFO - [SQL执行] 开始执行查询SQL
21:58:03 - article_server - INFO - [SQL语句]
SELECT id, tag_name
FROM ai_product_tags
WHERE product_id = %s
21:58:03 - article_server - INFO - [SQL参数] (1,)
21:58:03 - article_server - INFO - [SQL结果] 查询完成，返回 1 条记录
21:58:03 - article_server - INFO - [SQL数据] 查询结果: [{'id': 1, 'tag_name': '保湿'}]
21:58:03 - article_server - INFO - [获取产品列表] 查询成功, 总数: 6, 当前页: 1, 每页: 20, 返回数量: 6, 企业ID: 1, IP: 36.27.52.26
21:58:03 - article_server - INFO - [API响应] GET /api/products/list - IP: 36.27.52.26 - 状态码: 200
21:58:04 - 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
21:58:04 - article_server - INFO - [Token验证成功] 用户ID: 4
21:58:04 - article_server - INFO - [获取产品列表] 开始处理请求, IP: 36.27.52.26
21:58:04 - article_server - INFO - [获取产品列表] 用户信息 - 用户ID: 4, 企业ID: 1, IP: 36.27.52.26
21:58:04 - article_server - INFO - [获取产品列表] 查询参数: page=1, pageSize=20, keyword=, type=, status=, 企业ID: 1, IP: 36.27.52.26
21:58:04 - article_server - INFO - [API访问] GET /api/products/types/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
21:58:04 - article_server - INFO - [Token验证成功] 用户ID: 4
21:58:04 - article_server - INFO - [获取企业产品类型列表] 开始处理请求, IP: 36.27.52.26
21:58:04 - article_server - INFO - [获取企业产品类型列表] 企业ID: 1, IP: 36.27.52.26
21:58:04 - 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
21:58:04 - article_server - INFO - [Token验证成功] 用户ID: 4
21:58:04 - article_server - INFO - [获取用户信息] 开始处理请求, IP: 36.27.52.26
21:58:04 - article_server - INFO - [获取用户信息] 用户ID: 4, IP: 36.27.52.26
21:58:04 - article_server - INFO - [SQL执行] 开始执行查询SQL
21:58:04 - article_server - INFO - [SQL语句] SELECT COUNT(*) as total FROM ai_products WHERE enterprise_id = %s AND status != 'deleted'
21:58:04 - article_server - INFO - [SQL参数] [1]
21:58:04 - article_server - INFO - [SQL执行] 开始执行查询SQL
21:58:04 - article_server - INFO - [SQL语句] SELECT COUNT(*) as total FROM ai_product_types WHERE enterprise_id = %s
21:58:04 - article_server - INFO - [SQL参数] [1]
21:58:05 - article_server - INFO - [SQL执行] 开始执行查询SQL
21:58:05 - 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'
21:58:05 - article_server - INFO - [SQL参数] (4,)
21:58:05 - article_server - INFO - [SQL结果] 查询完成，返回 1 条记录
21:58:05 - article_server - INFO - [SQL数据] 查询结果: [{'total': 6}]
21:58:05 - article_server - INFO - [SQL结果] 查询完成，返回 1 条记录
21:58:05 - article_server - INFO - [SQL数据] 查询结果: [{'total': 0}]
21:58:05 - article_server - INFO - [SQL结果] 查询完成，返回 1 条记录
21:58:05 - 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)}]
21:58:05 - article_server - INFO - [获取用户信息] 查询成功, 用户: user004, 角色: enterprise, 企业: rwl企业4号, IP: 36.27.52.26
21:58:05 - article_server - INFO - [SQL执行] 开始执行查询SQL
21:58:05 - 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
21:58:05 - article_server - INFO - [SQL参数] [1, 20, 0]
21:58:05 - article_server - INFO - [SQL执行] 开始执行查询SQL
21:58:05 - article_server - INFO - [SQL语句]
SELECT id, type_name, enterprise_id, product_id, created_at
FROM ai_product_types
WHERE enterprise_id = %s
ORDER BY created_at DESC
LIMIT %s OFFSET %s
21:58:05 - article_server - INFO - [SQL参数] [1, 100, 0]
21:58:05 - article_server - INFO - [SQL执行] 开始执行插入SQL
21:58:05 - 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())
21:58:05 - 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)
21:58:05 - article_server - INFO - [SQL结果] 查询完成，返回 6 条记录
21:58:05 - article_server - INFO - [SQL结果] 查询完成，返回 0 条记录
21:58:05 - article_server - INFO - [SQL结果] 插入完成，新记录ID: 29
21:58:05 - article_server - INFO - [获取企业产品类型列表] 查询成功, 企业ID: 1, 总数: 0, 返回: 0, IP: 36.27.52.26
21:58:05 - article_server - INFO - [API响应] GET /api/products/types/list - IP: 36.27.52.26 - 状态码: 200
21:58:05 - article_server - INFO - [SQL执行] 开始执行查询SQL
21:58:05 - article_server - INFO - [SQL语句]
SELECT id, tag_name
FROM ai_product_tags
WHERE product_id = %s
21:58:05 - article_server - INFO - [SQL参数] (25,)
21:58:05 - article_server - INFO - [业务日志] 操作: get_user_info | 用户ID: 4 | 目标: user#4 | 状态: success | IP: 36.27.52.26 | 日志ID: 29
21:58:05 - article_server - INFO - [API响应] GET /api/users/info - IP: 36.27.52.26 - 状态码: 200
21:58:05 - article_server - INFO - [SQL结果] 查询完成，返回 0 条记录
21:58:05 - article_server - INFO - [SQL执行] 开始执行查询SQL
21:58:05 - article_server - INFO - [SQL语句]
SELECT id, tag_name
FROM ai_product_tags
WHERE product_id = %s
21:58:05 - article_server - INFO - [SQL参数] (24,)
21:58:05 - article_server - INFO - [SQL结果] 查询完成，返回 0 条记录
21:58:05 - 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
21:58:05 - article_server - INFO - [Token验证成功] 用户ID: 4
21:58:05 - article_server - INFO - [获取产品列表] 开始处理请求, IP: 36.27.52.26
21:58:05 - 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
21:58:05 - article_server - INFO - [获取产品列表] 用户信息 - 用户ID: 4, 企业ID: 1, IP: 36.27.52.26
21:58:05 - article_server - INFO - [获取产品列表] 查询参数: page=1, pageSize=20, keyword=, type=, status=, 企业ID: 1, IP: 36.27.52.26
21:58:05 - article_server - INFO - [Token验证成功] 用户ID: 4
21:58:05 - article_server - INFO - [获取用户信息] 开始处理请求, IP: 36.27.52.26
21:58:05 - article_server - INFO - [获取用户信息] 用户ID: 4, IP: 36.27.52.26
21:58:05 - article_server - INFO - [API访问] GET /api/products/types/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
21:58:05 - article_server - INFO - [Token验证成功] 用户ID: 4
21:58:05 - article_server - INFO - [获取企业产品类型列表] 开始处理请求, IP: 36.27.52.26
21:58:05 - article_server - INFO - [获取企业产品类型列表] 企业ID: 1, IP: 36.27.52.26
21:58:05 - article_server - INFO - [SQL执行] 开始执行查询SQL
21:58:05 - article_server - INFO - [SQL执行] 开始执行查询SQL
21:58:05 - article_server - INFO - [SQL语句] SELECT COUNT(*) as total FROM ai_products WHERE enterprise_id = %s AND status != 'deleted'
21:58:05 - 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'
21:58:05 - article_server - INFO - [SQL参数] [1]
21:58:05 - article_server - INFO - [SQL参数] (4,)
21:58:05 - article_server - INFO - [SQL执行] 开始执行查询SQL
21:58:05 - article_server - INFO - [SQL语句] SELECT COUNT(*) as total FROM ai_product_types WHERE enterprise_id = %s
21:58:05 - article_server - INFO - [SQL参数] [1]
21:58:05 - article_server - INFO - [SQL执行] 开始执行查询SQL
21:58:05 - article_server - INFO - [SQL语句]
SELECT id, tag_name
FROM ai_product_tags
WHERE product_id = %s
21:58:05 - article_server - INFO - [SQL参数] (13,)
21:58:05 - article_server - INFO - [SQL结果] 查询完成，返回 1 条记录
21:58:05 - article_server - INFO - [SQL结果] 查询完成，返回 1 条记录
21:58:05 - 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)}]
21:58:05 - article_server - INFO - [SQL数据] 查询结果: [{'total': 6}]
21:58:05 - article_server - INFO - [SQL结果] 查询完成，返回 1 条记录
21:58:05 - article_server - INFO - [SQL数据] 查询结果: [{'total': 0}]
21:58:05 - article_server - INFO - [SQL结果] 查询完成，返回 0 条记录
21:58:05 - article_server - INFO - [获取用户信息] 查询成功, 用户: user004, 角色: enterprise, 企业: rwl企业4号, IP: 36.27.52.26
21:58:05 - article_server - INFO - [SQL执行] 开始执行插入SQL
21:58:05 - 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())
21:58:05 - 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)
21:58:05 - article_server - INFO - [SQL执行] 开始执行查询SQL
21:58:05 - 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
21:58:05 - article_server - INFO - [SQL参数] [1, 20, 0]
21:58:05 - article_server - INFO - [SQL执行] 开始执行查询SQL
21:58:05 - article_server - INFO - [SQL语句]
SELECT id, tag_name
FROM ai_product_tags
WHERE product_id = %s
21:58:05 - article_server - INFO - [SQL参数] (12,)
21:58:05 - article_server - INFO - [SQL执行] 开始执行查询SQL
21:58:05 - article_server - INFO - [SQL语句]
SELECT id, type_name, enterprise_id, product_id, created_at
FROM ai_product_types
WHERE enterprise_id = %s
ORDER BY created_at DESC
LIMIT %s OFFSET %s
21:58:05 - article_server - INFO - [SQL参数] [1, 100, 0]
21:58:05 - article_server - INFO - [SQL结果] 查询完成，返回 6 条记录
21:58:05 - article_server - INFO - [SQL结果] 查询完成，返回 0 条记录
21:58:05 - article_server - INFO - [SQL结果] 插入完成，新记录ID: 30
21:58:05 - article_server - INFO - [SQL结果] 查询完成，返回 0 条记录
21:58:05 - article_server - INFO - [业务日志] 操作: get_user_info | 用户ID: 4 | 目标: user#4 | 状态: success | IP: 36.27.52.26 | 日志ID: 30
21:58:05 - article_server - INFO - [API响应] GET /api/users/info - IP: 36.27.52.26 - 状态码: 200
21:58:05 - article_server - INFO - [获取企业产品类型列表] 查询成功, 企业ID: 1, 总数: 0, 返回: 0, IP: 36.27.52.26
21:58:05 - article_server - INFO - [API响应] GET /api/products/types/list - IP: 36.27.52.26 - 状态码: 200
21:58:05 - article_server - INFO - [SQL执行] 开始执行查询SQL
21:58:05 - article_server - INFO - [SQL语句]
SELECT id, tag_name
FROM ai_product_tags
WHERE product_id = %s
21:58:05 - article_server - INFO - [SQL参数] (11,)
21:58:05 - article_server - INFO - [SQL执行] 开始执行查询SQL
21:58:05 - article_server - INFO - [SQL语句]
SELECT id, tag_name
FROM ai_product_tags
WHERE product_id = %s
21:58:05 - article_server - INFO - [SQL参数] (25,)
21:58:05 - article_server - INFO - [SQL结果] 查询完成，返回 0 条记录
21:58:05 - article_server - INFO - [SQL结果] 查询完成，返回 0 条记录
21:58:05 - article_server - INFO - [SQL执行] 开始执行查询SQL
21:58:05 - article_server - INFO - [SQL语句]
SELECT id, tag_name
FROM ai_product_tags
WHERE product_id = %s
21:58:05 - article_server - INFO - [SQL参数] (1,)
21:58:05 - article_server - INFO - [SQL执行] 开始执行查询SQL
21:58:05 - article_server - INFO - [SQL语句]
SELECT id, tag_name
FROM ai_product_tags
WHERE product_id = %s
21:58:05 - article_server - INFO - [SQL参数] (24,)
21:58:05 - article_server - INFO - [SQL结果] 查询完成，返回 1 条记录
21:58:05 - article_server - INFO - [SQL数据] 查询结果: [{'id': 1, 'tag_name': '保湿'}]
21:58:05 - article_server - INFO - [SQL结果] 查询完成，返回 0 条记录
21:58:05 - article_server - INFO - [获取产品列表] 查询成功, 总数: 6, 当前页: 1, 每页: 20, 返回数量: 6, 企业ID: 1, IP: 36.27.52.26
21:58:05 - article_server - INFO - [API响应] GET /api/products/list - IP: 36.27.52.26 - 状态码: 200
21:58:05 - article_server - INFO - [SQL执行] 开始执行查询SQL
21:58:05 - article_server - INFO - [SQL语句]
SELECT id, tag_name
FROM ai_product_tags
WHERE product_id = %s
21:58:05 - article_server - INFO - [SQL参数] (13,)
21:58:05 - article_server - INFO - [SQL结果] 查询完成，返回 0 条记录
21:58:05 - article_server - INFO - [SQL执行] 开始执行查询SQL
21:58:05 - article_server - INFO - [SQL语句]
SELECT id, tag_name
FROM ai_product_tags
WHERE product_id = %s
21:58:05 - article_server - INFO - [SQL参数] (12,)
21:58:05 - article_server - INFO - [SQL结果] 查询完成，返回 0 条记录
21:58:05 - article_server - INFO - [SQL执行] 开始执行查询SQL
21:58:05 - article_server - INFO - [SQL语句]
SELECT id, tag_name
FROM ai_product_tags
WHERE product_id = %s
21:58:05 - article_server - INFO - [SQL参数] (11,)
21:58:05 - article_server - INFO - [SQL结果] 查询完成，返回 0 条记录
21:58:05 - article_server - INFO - [SQL执行] 开始执行查询SQL
21:58:05 - article_server - INFO - [SQL语句]
SELECT id, tag_name
FROM ai_product_tags
WHERE product_id = %s
21:58:05 - article_server - INFO - [SQL参数] (1,)
21:58:05 - article_server - INFO - [SQL结果] 查询完成，返回 1 条记录
21:58:05 - article_server - INFO - [SQL数据] 查询结果: [{'id': 1, 'tag_name': '保湿'}]
21:58:05 - article_server - INFO - [获取产品列表] 查询成功, 总数: 6, 当前页: 1, 每页: 20, 返回数量: 6, 企业ID: 1, IP: 36.27.52.26
21:58:05 - article_server - INFO - [API响应] GET /api/products/list - IP: 36.27.52.26 - 状态码: 200
21:58:09 - article_server - INFO - [API访问] DELETE /api/products/24 - 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
21:58:09 - article_server - INFO - [Token验证成功] 用户ID: 4
21:58:09 - article_server - INFO - [SQL执行] 开始执行查询SQL
21:58:09 - article_server - INFO - [SQL语句] SELECT id, name FROM ai_products WHERE id = %s AND enterprise_id = %s AND status != 'deleted'
21:58:09 - article_server - INFO - [SQL参数] (24, 1)
21:58:09 - article_server - INFO - [SQL结果] 查询完成，返回 1 条记录
21:58:09 - article_server - INFO - [SQL数据] 查询结果: [{'id': 24, 'name': '产品（2）'}]
21:58:09 - article_server - INFO - [SQL执行] 开始执行更新SQL
21:58:09 - article_server - INFO - [SQL语句] UPDATE ai_products SET status = 'deleted', updated_at = NOW() WHERE id = %s
21:58:09 - article_server - INFO - [SQL参数] (24,)
21:58:09 - article_server - INFO - [SQL结果] 更新完成，影响 1 行
21:58:09 - article_server - INFO - [SQL执行] 开始执行更新SQL
21:58:09 - article_server - INFO - [SQL语句] UPDATE ai_enterprises SET products_total = products_total - 1 WHERE id = %s
21:58:09 - article_server - INFO - [SQL参数] (1,)
21:58:09 - article_server - INFO - [SQL结果] 更新完成，影响 1 行
21:58:09 - article_server - INFO - 删除产品成功: 产品（2）
21:58:09 - article_server - INFO - [SQL执行] 开始执行插入SQL
21:58:09 - 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())
21:58:09 - article_server - INFO - [SQL参数] (4, 'delete_product', 'product', 24, '删除产品: 产品（2）', '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)
21:58:09 - article_server - INFO - [SQL结果] 插入完成，新记录ID: 31
21:58:09 - article_server - INFO - [业务日志] 操作: delete_product | 用户ID: 4 | 目标: product#24 | 状态: success | IP: 36.27.52.26 | 日志ID: 31
21:58:09 - article_server - INFO - [API响应] DELETE /api/products/24 - IP: 36.27.52.26 - 状态码: 200
21:58:09 - 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
21:58:09 - article_server - INFO - [Token验证成功] 用户ID: 4
21:58:09 - article_server - INFO - [获取产品列表] 开始处理请求, IP: 36.27.52.26
21:58:09 - article_server - INFO - [获取产品列表] 用户信息 - 用户ID: 4, 企业ID: 1, IP: 36.27.52.26
21:58:09 - article_server - INFO - [获取产品列表] 查询参数: page=1, pageSize=20, keyword=, type=, status=, 企业ID: 1, IP: 36.27.52.26
21:58:09 - article_server - INFO - [SQL执行] 开始执行查询SQL
21:58:09 - article_server - INFO - [SQL语句] SELECT COUNT(*) as total FROM ai_products WHERE enterprise_id = %s AND status != 'deleted'
21:58:09 - article_server - INFO - [SQL参数] [1]
21:58:09 - article_server - INFO - [SQL结果] 查询完成，返回 1 条记录
21:58:09 - article_server - INFO - [SQL数据] 查询结果: [{'total': 5}]
21:58:09 - article_server - INFO - [SQL执行] 开始执行查询SQL
21:58:09 - 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
21:58:09 - article_server - INFO - [SQL参数] [1, 20, 0]
21:58:09 - article_server - INFO - [SQL结果] 查询完成，返回 5 条记录
21:58:09 - article_server - INFO - [SQL执行] 开始执行查询SQL
21:58:09 - article_server - INFO - [SQL语句]
SELECT id, tag_name
FROM ai_product_tags
WHERE product_id = %s
21:58:09 - article_server - INFO - [SQL参数] (25,)
21:58:09 - article_server - INFO - [SQL结果] 查询完成，返回 0 条记录
21:58:10 - article_server - INFO - [SQL执行] 开始执行查询SQL
21:58:10 - article_server - INFO - [SQL语句]
SELECT id, tag_name
FROM ai_product_tags
WHERE product_id = %s
21:58:10 - article_server - INFO - [SQL参数] (13,)
21:58:10 - article_server - INFO - [SQL结果] 查询完成，返回 0 条记录
21:58:10 - article_server - INFO - [SQL执行] 开始执行查询SQL
21:58:10 - article_server - INFO - [SQL语句]
SELECT id, tag_name
FROM ai_product_tags
WHERE product_id = %s
21:58:10 - article_server - INFO - [SQL参数] (12,)
21:58:10 - article_server - INFO - [SQL结果] 查询完成，返回 0 条记录
21:58:10 - article_server - INFO - [SQL执行] 开始执行查询SQL
21:58:10 - article_server - INFO - [SQL语句]
SELECT id, tag_name
FROM ai_product_tags
WHERE product_id = %s
21:58:10 - article_server - INFO - [SQL参数] (11,)
21:58:10 - article_server - INFO - [SQL结果] 查询完成，返回 0 条记录
21:58:10 - article_server - INFO - [SQL执行] 开始执行查询SQL
21:58:10 - article_server - INFO - [SQL语句]
SELECT id, tag_name
FROM ai_product_tags
WHERE product_id = %s
21:58:10 - article_server - INFO - [SQL参数] (1,)
21:58:10 - article_server - INFO - [SQL结果] 查询完成，返回 1 条记录
21:58:10 - article_server - INFO - [SQL数据] 查询结果: [{'id': 1, 'tag_name': '保湿'}]
21:58:10 - article_server - INFO - [获取产品列表] 查询成功, 总数: 5, 当前页: 1, 每页: 20, 返回数量: 5, 企业ID: 1, IP: 36.27.52.26
21:58:10 - article_server - INFO - [API响应] GET /api/products/list - IP: 36.27.52.26 - 状态码: 200
21:58:12 - 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
21:58:12 - article_server - INFO - [Token验证成功] 用户ID: 4
21:58:12 - article_server - INFO - [SQL执行] 开始执行查询SQL
21:58:12 - article_server - INFO - [SQL语句]
SELECT COUNT(*) as total
FROM ai_images
WHERE enterprise_id = %s AND status = %s
21:58:12 - article_server - INFO - [SQL参数] [1, 'active']
21:58:12 - article_server - INFO - [SQL结果] 查询完成，返回 1 条记录
21:58:12 - article_server - INFO - [SQL数据] 查询结果: [{'total': 0}]
21:58:12 - article_server - INFO - [SQL执行] 开始执行查询SQL
21:58:12 - 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
21:58:12 - article_server - INFO - [SQL参数] [1, 'active', 100, 0]
21:58:12 - article_server - INFO - [SQL结果] 查询完成，返回 0 条记录
21:58:12 - article_server - INFO - 获取图片列表成功，总数: 0
21:58:12 - article_server - INFO - [API响应] GET /api/images/list - IP: 36.27.52.26 - 状态码: 200
21:58:42 - 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
21:58:42 - article_server - INFO - [Token验证成功] 用户ID: 4
21:58:42 - article_server - INFO - [上传图片] 图片尺寸优化: 缩放到 (838, 1080)
21:58:43 - article_server - INFO - [上传图片] 优化原图保存成功: /home/work/baijiahao/tags_images/Images/20251216/1765893522846382.png
21:58:43 - article_server - INFO - [上传图片] 缩略图生成成功: /home/work/baijiahao/tags_images/Images/20251216/1765893522846382_thumb.png (尺寸: (120, 160))
21:58:43 - article_server - INFO - [上传图片] 开始调用 TransformerImage 处理图片
21:58:43 - article_server - INFO - [OSS业务] 开始处理图片上传请求 - 文件: 1765893522846382.png
21:58:43 - article_server - INFO - [OSS业务] 文件信息 - 大小: 988600 bytes, 路径: /home/work/baijiahao/tags_images/Images/20251216/1765893522846382.png
21:58:43 - article_server - INFO - [OSS上传] 开始上传文件: /home/work/baijiahao/tags_images/Images/20251216/1765893522846382.png -> Images/20251216/1765893522846382.png
21:58:43 - article_server - INFO - [OSS业务] OSS配置 - Bucket: oss-pai-apou8llecyqfa7c9du-cn-shanghai, Endpoint: https://oss-cn-shanghai.aliyuncs.com/
21:58:50 - article_server - INFO - [OSS业务] 上传耗时: 6.56 秒
21:58:50 - article_server - INFO - [OSS上传] 文件上传成功: Images/20251216/1765893522846382.png -> https://oss-pai-apou8llecyqfa7c9du-cn-shanghai.oss-cn-shanghai.aliyuncs.com//Images/20251216/1765893522846382.png
21:58:50 - article_server - INFO - [OSS业务] 上传成功 - OSS Key: Images/20251216/1765893522846382.png, 文件大小: 988600 bytes, 耗时: 6.56s
21:58:50 - article_server - INFO - [上传图片] 原图上传结果: {'success': True, 'message': '上传成功', 'oss_url': 'https://oss-pai-apou8llecyqfa7c9du-cn-shanghai.oss-cn-shanghai.aliyuncs.com//Images/20251216/1765893522846382.png', 'oss_key': 'Images/20251216/1765893522846382.png'}
21:58:50 - article_server - INFO - [OSS业务] 开始处理图片上传请求 - 文件: 1765893522846382_thumb.png
21:58:50 - article_server - INFO - [OSS业务] 文件信息 - 大小: 32024 bytes, 路径: /home/work/baijiahao/tags_images/Images/20251216/1765893522846382_thumb.png
21:58:50 - article_server - INFO - [OSS上传] 开始上传文件: /home/work/baijiahao/tags_images/Images/20251216/1765893522846382_thumb.png -> Images/20251216/1765893522846382_thumb.png
21:58:50 - article_server - INFO - [OSS业务] OSS配置 - Bucket: oss-pai-apou8llecyqfa7c9du-cn-shanghai, Endpoint: https://oss-cn-shanghai.aliyuncs.com/
21:58:50 - article_server - INFO - [OSS业务] 上传耗时: 0.20 秒
21:58:50 - article_server - INFO - [OSS上传] 文件上传成功: Images/20251216/1765893522846382_thumb.png -> https://oss-pai-apou8llecyqfa7c9du-cn-shanghai.oss-cn-shanghai.aliyuncs.com//Images/20251216/1765893522846382_thumb.png
21:58:50 - article_server - INFO - [OSS业务] 上传成功 - OSS Key: Images/20251216/1765893522846382_thumb.png, 文件大小: 32024 bytes, 耗时: 0.20s
21:58:50 - article_server - INFO - [上传图片] 缩图上传结果: {'success': True, 'message': '上传成功', 'oss_url': 'https://oss-pai-apou8llecyqfa7c9du-cn-shanghai.oss-cn-shanghai.aliyuncs.com//Images/20251216/1765893522846382_thumb.png', 'oss_key': 'Images/20251216/1765893522846382_thumb.png'}
21:58:50 - article_server - INFO - [SQL执行] 开始执行插入SQL
21:58:50 - 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)
21:58:50 - article_server - INFO - [SQL参数] (1, 32, '测试产品_7766', '图片描述图片描述', '20251216/1765893522846382.png', '20251216/1765893522846382_thumb.png', '20251216/1765893522846382_thumb.png', 2, '场景图（图片类型）', '', '图片描述,图片描述1', 'medical', 1263901, 993, 1280, 4, 'active')
21:58:50 - article_server - INFO - [SQL结果] 插入完成，新记录ID: 23
21:58:50 - article_server - INFO - [上传图片] 步骤(1) ai_images 入库成功: image_id=23
21:58:50 - article_server - INFO - [SQL执行] 开始执行查询SQL
21:58:50 - article_server - INFO - [SQL语句] SELECT id FROM ai_image_tags_name WHERE enterprise_id = %s AND tag_name = %s
21:58:50 - article_server - INFO - [SQL参数] (1, '图片描述')
21:58:50 - article_server - INFO - [SQL结果] 查询完成，返回 0 条记录
21:58:50 - article_server - INFO - [SQL执行] 开始执行插入SQL
21:58:50 - article_server - INFO - [SQL语句]
INSERT INTO ai_image_tags_name
(enterprise_id, tag_name, status)
VALUES (%s, %s, %s)
21:58:50 - article_server - INFO - [SQL参数] (1, '图片描述', 'active')
21:58:50 - article_server - INFO - [SQL结果] 插入完成，新记录ID: 1
21:58:50 - article_server - INFO - [上传图片] 步骤(2) 新标签入库成功: tag_name=图片描述, tag_id=1
21:58:50 - article_server - INFO - [SQL执行] 开始执行查询SQL
21:58:50 - article_server - INFO - [SQL语句] SELECT id FROM ai_image_tags_name WHERE enterprise_id = %s AND tag_name = %s
21:58:50 - article_server - INFO - [SQL参数] (1, '图片描述1')
21:58:51 - article_server - INFO - [SQL结果] 查询完成，返回 0 条记录
21:58:51 - article_server - INFO - [SQL执行] 开始执行插入SQL
21:58:51 - article_server - INFO - [SQL语句]
INSERT INTO ai_image_tags_name
(enterprise_id, tag_name, status)
VALUES (%s, %s, %s)
21:58:51 - article_server - INFO - [SQL参数] (1, '图片描述1', 'active')
21:58:51 - article_server - INFO - [SQL结果] 插入完成，新记录ID: 2
21:58:51 - article_server - INFO - [上传图片] 步骤(2) 新标签入库成功: tag_name=图片描述1, tag_id=2
21:58:51 - article_server - INFO - [SQL执行] 开始执行插入SQL
21:58: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)
21:58:51 - article_server - INFO - [SQL参数] (1, 32, 23, '图片描述图片描述', '20251216/1765893522846382.png', '20251216/1765893522846382_thumb.png', 1, '图片描述', 4)
21:58:51 - article_server - INFO - [SQL结果] 插入完成，新记录ID: 1
21:58:51 - article_server - INFO - [上传图片] 步骤(3) 关系映射入库成功: image_id=23, tag_id=1, tag_name=图片描述, product_id=32
21:58:51 - article_server - INFO - [SQL执行] 开始执行插入SQL
21:58: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)
21:58:51 - article_server - INFO - [SQL参数] (1, 32, 23, '图片描述图片描述', '20251216/1765893522846382.png', '20251216/1765893522846382_thumb.png', 2, '图片描述1', 4)
21:58:51 - article_server - INFO - [SQL结果] 插入完成，新记录ID: 2
21:58:51 - article_server - INFO - [上传图片] 步骤(3) 关系映射入库成功: image_id=23, tag_id=2, tag_name=图片描述1, product_id=32
21:58:51 - article_server - INFO - [SQL执行] 开始执行插入SQL
21:58:51 - 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)
21:58:51 - article_server - INFO - [SQL参数] (1, 32, '测试产品_7766', 23, '图片描述图片描述', '20251216/1765893522846382.png', '20251216/1765893522846382_thumb.png', '场景图（图片类型）', '', 1263901, 993, 1280, 4, 'active')
21:58:51 - article_server - INFO - [SQL结果] 插入完成，新记录ID: 11
21:58:51 - article_server - INFO - [上传图片] 步骤(4) ai_product_images 入库成功: product_image_id=11, product_id=32, image_id=23
21:58:51 - article_server - INFO - [上传图片] 全部完成: image_id=23, 标签数=2, 关系数=2, product_image_id=11
21:58:51 - article_server - INFO - [API响应] POST /api/images/upload - IP: 36.27.52.26 - 状态码: 200
21:58:51 - 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
21:58:51 - article_server - INFO - [Token验证成功] 用户ID: 4
21:58:51 - article_server - INFO - [SQL执行] 开始执行查询SQL
21:58:51 - article_server - INFO - [SQL语句]
SELECT COUNT(*) as total
FROM ai_images
WHERE enterprise_id = %s AND status = %s
21:58:51 - article_server - INFO - [SQL参数] [1, 'active']
21:58:51 - article_server - INFO - [SQL结果] 查询完成，返回 1 条记录
21:58:51 - article_server - INFO - [SQL数据] 查询结果: [{'total': 1}]
21:58:51 - article_server - INFO - [SQL执行] 开始执行查询SQL
21:58:51 - 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
21:58:51 - article_server - INFO - [SQL参数] [1, 'active', 100, 0]
21:58:51 - article_server - INFO - [SQL结果] 查询完成，返回 1 条记录
21:58:51 - 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)}]
21:58:51 - article_server - INFO - [SQL执行] 开始执行查询SQL
21:58:51 - 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
21:58:51 - article_server - INFO - [SQL参数] [23, 1]
21:58:51 - article_server - INFO - [SQL结果] 查询完成，返回 2 条记录
21:58:51 - article_server - INFO - [SQL数据] 查询结果: [{'tag_id': 1, 'tag_name': '图片描述'}, {'tag_id': 2, 'tag_name': '图片描述1'}]
21:58:51 - article_server - INFO - 获取图片列表成功，总数: 1
21:58:51 - article_server - INFO - [API响应] GET /api/images/list - IP: 36.27.52.26 - 状态码: 200
21:58: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
21:58:54 - article_server - INFO - [Token验证成功] 用户ID: 4
21:58: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
21:58:54 - article_server - INFO - [Token验证成功] 用户ID: 4
21:58:54 - article_server - INFO - [获取用户信息] 开始处理请求, IP: 36.27.52.26
21:58:54 - article_server - INFO - [获取用户信息] 用户ID: 4, IP: 36.27.52.26
21:58:54 - article_server - INFO - [SQL执行] 开始执行查询SQL
21:58:54 - article_server - INFO - [SQL语句]
SELECT COUNT(*) as total
FROM ai_images
WHERE enterprise_id = %s AND status = %s
21:58:54 - article_server - INFO - [SQL参数] [1, 'active']
21:58:54 - article_server - INFO - [SQL执行] 开始执行查询SQL
21:58: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'
21:58:54 - article_server - INFO - [SQL参数] (4,)
21:58:54 - article_server - INFO - [SQL结果] 查询完成，返回 1 条记录
21:58:54 - article_server - INFO - [SQL数据] 查询结果: [{'total': 1}]
21:58:54 - article_server - INFO - [SQL结果] 查询完成，返回 1 条记录
21:58: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)}]
21:58:54 - article_server - INFO - [获取用户信息] 查询成功, 用户: user004, 角色: enterprise, 企业: rwl企业4号, IP: 36.27.52.26
21:58:54 - article_server - INFO - [SQL执行] 开始执行查询SQL
21:58: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
21:58:54 - article_server - INFO - [SQL参数] [1, 'active', 100, 0]
21:58:54 - article_server - INFO - [SQL执行] 开始执行插入SQL
21:58: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())
21:58: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)
21:58:54 - article_server - INFO - [SQL结果] 查询完成，返回 1 条记录
21:58:54 - 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)}]
21:58:54 - article_server - INFO - [SQL结果] 插入完成，新记录ID: 32
21:58:55 - article_server - INFO - [SQL执行] 开始执行查询SQL
21:58:55 - 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
21:58:55 - article_server - INFO - [SQL参数] [23, 1]
21:58:55 - article_server - INFO - [业务日志] 操作: get_user_info | 用户ID: 4 | 目标: user#4 | 状态: success | IP: 36.27.52.26 | 日志ID: 32
21:58:55 - article_server - INFO - [API响应] GET /api/users/info - IP: 36.27.52.26 - 状态码: 200
21:58:55 - article_server - INFO - [SQL结果] 查询完成，返回 2 条记录
21:58:55 - article_server - INFO - [SQL数据] 查询结果: [{'tag_id': 1, 'tag_name': '图片描述'}, {'tag_id': 2, 'tag_name': '图片描述1'}]
21:58:55 - article_server - INFO - 获取图片列表成功，总数: 1
21:58:55 - article_server - INFO - [API响应] GET /api/images/list - IP: 36.27.52.26 - 状态码: 200
Reference in New Issue View Git Blame Copy Permalink