1935 lines
149 KiB
Plaintext
1935 lines
149 KiB
Plaintext
19:44:07 - article_server - INFO - 日志系统已启动 - 记录器: article_server
|
||
19:44:07 - article_server - INFO - 主日志文件: logs/article_server.log
|
||
19:44:07 - article_server - INFO - 错误日志文件: logs/article_error.log
|
||
19:44:07 - article_server - INFO - 日志保留策略: 每天午夜分割，主日志保留3天
|
||
19:44:07 - article_server - INFO - 错误日志保留策略: 每天午夜分割，保留9天
|
||
19:44:07 - article_server - INFO - 万花筒API服务模块已加载
|
||
19:44:21 - article_server - INFO - [API访问] GET /api/employees/stats - IP: 104.244.91.212 - User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/143.0.0.0 Sa
|
||
19:44:21 - article_server - INFO - [Token验证成功] 用户ID: 3
|
||
19:44:21 - article_server - INFO - [API访问] GET /api/employees/list - IP: 104.244.91.212 - User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/143.0.0.0 Sa
|
||
19:44:21 - article_server - INFO - [Token验证成功] 用户ID: 3
|
||
19:44:21 - article_server - INFO - 数据库连接成功，字符集设置完成
|
||
19:44:21 - article_server - INFO - [SQL执行] 开始执行查询SQL
|
||
19:44:21 - 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'
|
||
|
||
19:44:21 - article_server - INFO - [SQL参数] (1,)
|
||
19:44:21 - article_server - INFO - [SQL结果] 查询完成，返回 1 条记录
|
||
19:44:21 - article_server - INFO - [SQL数据] 查询结果: [{'total_count': 6, 'active_count': Decimal('6'), 'bound_xhs_count': Decimal('3')}]
|
||
19:44:21 - article_server - INFO - 数据库连接成功，字符集设置完成
|
||
19:44:21 - article_server - INFO - [SQL执行] 开始执行查询SQL
|
||
19:44:21 - article_server - INFO - [SQL语句] SELECT COUNT(*) as total FROM ai_users u WHERE u.enterprise_id = %s AND u.status != 'deleted'
|
||
19:44:21 - article_server - INFO - [SQL参数] [1]
|
||
19:44:21 - article_server - INFO - 获取员工统计成功
|
||
19:44:21 - article_server - INFO - [API响应] GET /api/employees/stats - IP: 104.244.91.212 - 状态码: 200
|
||
19:44:21 - article_server - INFO - [SQL结果] 查询完成，返回 1 条记录
|
||
19:44:21 - article_server - INFO - [SQL数据] 查询结果: [{'total': 6}]
|
||
19:44:21 - article_server - INFO - [SQL执行] 开始执行查询SQL
|
||
19:44:21 - article_server - INFO - [SQL语句]
|
||
SELECT u.id, u.enterprise_id, u.real_name as name, u.username, u.phone, u.role, u.department,
|
||
u.is_bound_xhs, a.xhs_account, u.status, u.created_at, u.updated_at
|
||
FROM ai_users u
|
||
LEFT JOIN ai_authors a ON u.id = a.created_user_id AND a.status = 'active'
|
||
WHERE u.enterprise_id = %s AND u.status != 'deleted'
|
||
ORDER BY u.created_at DESC
|
||
LIMIT %s OFFSET %s
|
||
|
||
19:44:21 - article_server - INFO - [SQL参数] [1, 10, 0]
|
||
19:44:21 - article_server - INFO - [SQL结果] 查询完成，返回 6 条记录
|
||
19:44:21 - article_server - INFO - 获取员工列表成功，总数: 6
|
||
19:44:21 - article_server - INFO - [API响应] GET /api/employees/list - IP: 104.244.91.212 - 状态码: 200
|
||
19:44:21 - article_server - INFO - [API访问] GET /api/users/info - IP: 104.244.91.212 - User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/143.0.0.0 Sa
|
||
19:44:21 - article_server - INFO - [Token验证成功] 用户ID: 3
|
||
19:44:21 - article_server - INFO - [获取用户信息] 开始处理请求, IP: 104.244.91.212
|
||
19:44:21 - article_server - INFO - [获取用户信息] 用户ID: 3, action: , IP: 104.244.91.212
|
||
19:44:21 - article_server - INFO - [SQL执行] 开始执行查询SQL
|
||
19:44:21 - article_server - INFO - [SQL语句]
|
||
SELECT id, enterprise_id, enterprise_name, username, real_name, email, phone,
|
||
wechat_openid, wechat_unionid,
|
||
is_bound_xhs, department, role, status, created_at, updated_at
|
||
FROM ai_users u
|
||
WHERE id = %s AND status != 'deleted'
|
||
|
||
19:44:21 - article_server - INFO - [SQL参数] (3,)
|
||
19:44:21 - article_server - INFO - [SQL结果] 查询完成，返回 1 条记录
|
||
19:44:21 - article_server - INFO - [SQL数据] 查询结果: [{'id': 3, 'enterprise_id': 1, 'enterprise_name': '刘勇企业3号', 'username': 'user003', 'real_name': '刘勇', 'email': None, 'phone': '18211010472', 'wechat_openid': None, 'wechat_unionid': None, 'is_bound_xhs': 1, 'department': '市场部', 'role': 'admin', 'status': 'active', 'created_at': datetime.datetime(2025, 12, 12, 16, 58, 22), 'updated_at': datetime.datetime(2025, 12, 21, 10, 43, 4)}]
|
||
19:44:21 - article_server - INFO - [SQL执行] 开始执行插入SQL
|
||
19:44: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())
|
||
|
||
19:44:21 - article_server - INFO - [SQL参数] (3, 'get_user_info', 'user', 3, '查询用户信息: user003, action=', '104.244.91.212', '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)
|
||
19:44:21 - article_server - INFO - [SQL结果] 插入完成，新记录ID: 64224
|
||
19:44:21 - article_server - INFO - [业务日志] 操作: get_user_info | 用户ID: 3 | 目标: user#3 | 状态: success | IP: 104.244.91.212 | 日志ID: 64224
|
||
19:44:21 - article_server - INFO - [API响应] GET /api/users/info - IP: 104.244.91.212 - 状态码: 200
|
||
19:44:51 - article_server - INFO - [API访问] POST /api/auth/login - IP: 104.244.91.212 - User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/143.0.0.0 Sa
|
||
19:44:51 - article_server - INFO - [用户登录] 开始处理登录请求, IP: 104.244.91.212
|
||
19:44:51 - article_server - INFO - [用户登录] 收到登录请求, 账号: 13621242430, IP: 104.244.91.212
|
||
19:44:51 - article_server - INFO - [用户登录] 开始在ai_users表查询用户, 账号: 13621242430
|
||
19:44:51 - article_server - INFO - [SQL执行] 开始执行查询SQL
|
||
19:44:51 - article_server - INFO - [SQL语句]
|
||
SELECT u.id, u.enterprise_id, u.enterprise_name, u.username, u.phone, u.password,
|
||
u.real_name, u.role, u.status, u.is_bound_xhs, a.xhs_account
|
||
FROM ai_users u
|
||
LEFT JOIN ai_authors a ON u.id = a.created_user_id AND a.status = 'active'
|
||
WHERE (u.phone = %s OR u.username = %s) AND u.status = 'active'
|
||
|
||
19:44:51 - article_server - INFO - [SQL参数] ('13621242430', '13621242430')
|
||
19:44:52 - article_server - INFO - [SQL结果] 查询完成，返回 1 条记录
|
||
19:44:52 - article_server - INFO - [SQL数据] 查询结果: [{'id': 10, 'enterprise_id': 1, 'enterprise_name': '测试企业10号', 'username': 'user010', 'phone': '13621242430', 'password': '240be518fabd2724ddb6f04eeb1da5967448d7e831c08c8fa822809f74c720a9', 'real_name': '测试用户10', 'role': 'enterprise', 'status': 'active', 'is_bound_xhs': 0, 'xhs_account': None}]
|
||
19:44:52 - article_server - INFO - [用户登录] 查询到用户信息, 用户名: user010, 角色: enterprise, 企业: 测试企业10号, 企业ID: 1
|
||
19:44:52 - article_server - INFO - [用户登录] 开始验证密码, 账号: 13621242430
|
||
19:44:52 - article_server - INFO - [用户登录] 密码验证成功, 用户名: user010, 角色: enterprise
|
||
19:44:52 - article_server - INFO - [用户登录] 检测到企业角色, 开始获取企业详细信息, 企业ID: 1
|
||
19:44:52 - article_server - INFO - [SQL执行] 开始执行查询SQL
|
||
19:44:52 - article_server - INFO - [SQL语句]
|
||
SELECT id, enterprise_ID, name, short_name, phone, email, status,
|
||
users_total, products_total, articles_total, published_total
|
||
FROM ai_enterprises
|
||
WHERE id = %s AND status = 'active'
|
||
|
||
19:44:52 - article_server - INFO - [SQL参数] (1,)
|
||
19:44:52 - article_server - INFO - [SQL结果] 查询完成，返回 1 条记录
|
||
19:44:52 - article_server - INFO - [SQL数据] 查询结果: [{'id': 1, 'enterprise_ID': 'ENT-2024-0001', 'name': '乐航', 'short_name': '企业122你们好', 'phone': '13621242430', 'email': 'raowenlong@vizee.cn', 'status': 'active', 'users_total': 2, 'products_total': 2, 'articles_total': 40, 'published_total': 0}]
|
||
19:44:52 - article_server - INFO - [用户登录] 获取企业信息成功, 企业名称: 乐航, 企业编号: ENT-2024-0001
|
||
19:44:52 - article_server - INFO - [用户登录] 开始生成token, 用户ID: 10, 角色: enterprise
|
||
19:44:52 - article_server - INFO - [Token生成] 用户: 13621242430, ID: 10, 角色: enterprise
|
||
19:44:52 - article_server - INFO - [用户登录成功] Token生成成功, 用户: user010, 角色: enterprise, 企业: 测试企业10号, IP: 104.244.91.212
|
||
19:44:52 - article_server - INFO - [API响应] POST /api/auth/login - IP: 104.244.91.212 - 状态码: 200
|
||
19:44:52 - article_server - INFO - [API访问] GET /api/users/info - IP: 104.244.91.212 - User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/143.0.0.0 Sa
|
||
19:44:52 - article_server - INFO - [Token验证成功] 用户ID: 10
|
||
19:44:52 - article_server - INFO - [获取用户信息] 开始处理请求, IP: 104.244.91.212
|
||
19:44:52 - article_server - INFO - [获取用户信息] 用户ID: 10, action: , IP: 104.244.91.212
|
||
19:44:52 - article_server - INFO - [API访问] GET /api/dashboard/recent-publishes - IP: 104.244.91.212 - User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/143.0.0.0 Sa
|
||
19:44:52 - article_server - INFO - [Token验证成功] 用户ID: 10
|
||
19:44:52 - article_server - INFO - [SQL执行] 开始执行查询SQL
|
||
19:44:52 - article_server - INFO - [SQL语句]
|
||
SELECT id, enterprise_id, enterprise_name, username, real_name, email, phone,
|
||
wechat_openid, wechat_unionid,
|
||
is_bound_xhs, department, role, status, created_at, updated_at
|
||
FROM ai_users u
|
||
WHERE id = %s AND status != 'deleted'
|
||
|
||
19:44:52 - article_server - INFO - [SQL参数] (10,)
|
||
19:44:52 - article_server - INFO - [SQL执行] 开始执行查询SQL
|
||
19:44:52 - article_server - INFO - [SQL语句]
|
||
SELECT r.id, r.publish_time,
|
||
u.real_name as employee_name,
|
||
p.name as product_name,
|
||
'success' as status
|
||
FROM ai_article_published_records r
|
||
LEFT JOIN ai_users u ON r.created_user_id = u.id
|
||
LEFT JOIN ai_products p ON r.product_id = p.id
|
||
WHERE r.enterprise_id = %s
|
||
ORDER BY r.publish_time DESC
|
||
LIMIT %s
|
||
|
||
19:44:52 - article_server - INFO - [SQL参数] (1, 5)
|
||
19:44:52 - article_server - INFO - [API访问] GET /api/dashboard/overview - IP: 104.244.91.212 - User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/143.0.0.0 Sa
|
||
19:44:52 - article_server - INFO - [SQL结果] 查询完成，返回 1 条记录
|
||
19:44:52 - article_server - INFO - [SQL数据] 查询结果: [{'id': 10, 'enterprise_id': 1, 'enterprise_name': '测试企业10号', 'username': 'user010', 'real_name': '测试用户10', 'email': None, 'phone': '13621242430', 'wechat_openid': 'ovoJF1z6ejXbXcWUHnvCw5HA0OeA', 'wechat_unionid': None, 'is_bound_xhs': 0, 'department': '运营部', 'role': 'enterprise', 'status': 'active', 'created_at': datetime.datetime(2025, 12, 12, 16, 58, 22), 'updated_at': datetime.datetime(2025, 12, 21, 10, 44, 39)}]
|
||
19:44:52 - article_server - INFO - [Token验证成功] 用户ID: 10
|
||
19:44:52 - article_server - INFO - [SQL结果] 查询完成，返回 4 条记录
|
||
19:44:52 - article_server - INFO - 获取最近发布成功
|
||
19:44:52 - article_server - INFO - [API响应] GET /api/dashboard/recent-publishes - IP: 104.244.91.212 - 状态码: 200
|
||
19:44:52 - article_server - INFO - [SQL执行] 开始执行插入SQL
|
||
19:44:52 - 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())
|
||
|
||
19:44:52 - article_server - INFO - [SQL参数] (10, 'get_user_info', 'user', 10, '查询用户信息: user010, action=', '104.244.91.212', '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)
|
||
19:44:52 - article_server - INFO - [SQL结果] 插入完成，新记录ID: 64237
|
||
19:44:52 - article_server - INFO - [业务日志] 操作: get_user_info | 用户ID: 10 | 目标: user#10 | 状态: success | IP: 104.244.91.212 | 日志ID: 64237
|
||
19:44:52 - article_server - INFO - [API响应] GET /api/users/info - IP: 104.244.91.212 - 状态码: 200
|
||
19:44:52 - article_server - INFO - 数据库连接成功，字符集设置完成
|
||
19:44:52 - article_server - INFO - [SQL执行] 开始执行查询SQL
|
||
19:44:52 - article_server - INFO - [SQL语句]
|
||
SELECT users_total, products_total, articles_total, published_total
|
||
FROM ai_enterprises
|
||
WHERE id = %s
|
||
|
||
19:44:52 - article_server - INFO - [SQL参数] (1,)
|
||
19:44:52 - article_server - INFO - [SQL结果] 查询完成，返回 1 条记录
|
||
19:44:52 - article_server - INFO - [SQL数据] 查询结果: [{'users_total': 2, 'products_total': 2, 'articles_total': 40, 'published_total': 0}]
|
||
19:44:52 - article_server - INFO - [SQL执行] 开始执行查询SQL
|
||
19:44:52 - article_server - INFO - [SQL语句]
|
||
SELECT COUNT(*) as month_published
|
||
FROM ai_article_published_records
|
||
WHERE enterprise_id = %s
|
||
AND YEAR(publish_time) = YEAR(CURDATE())
|
||
AND MONTH(publish_time) = MONTH(CURDATE())
|
||
|
||
19:44:52 - article_server - INFO - [SQL参数] (1,)
|
||
19:44:52 - article_server - INFO - [SQL结果] 查询完成，返回 1 条记录
|
||
19:44:52 - article_server - INFO - [SQL数据] 查询结果: [{'month_published': 4}]
|
||
19:44:52 - article_server - INFO - [SQL执行] 开始执行查询SQL
|
||
19:44:52 - article_server - INFO - [SQL语句]
|
||
SELECT COUNT(*) as last_month_published
|
||
FROM ai_article_published_records
|
||
WHERE enterprise_id = %s
|
||
AND YEAR(publish_time) = YEAR(DATE_SUB(CURDATE(), INTERVAL 1 MONTH))
|
||
AND MONTH(publish_time) = MONTH(DATE_SUB(CURDATE(), INTERVAL 1 MONTH))
|
||
|
||
19:44:52 - article_server - INFO - [SQL参数] (1,)
|
||
19:44:52 - article_server - INFO - [SQL结果] 查询完成，返回 1 条记录
|
||
19:44:52 - article_server - INFO - [SQL数据] 查询结果: [{'last_month_published': 0}]
|
||
19:44:52 - article_server - INFO - 获取工作台概览成功
|
||
19:44:52 - article_server - INFO - [API响应] GET /api/dashboard/overview - IP: 104.244.91.212 - 状态码: 200
|
||
19:44:53 - article_server - INFO - [API访问] GET /api/dashboard/hot-products - IP: 104.244.91.212 - User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/143.0.0.0 Sa
|
||
19:44:53 - article_server - INFO - [Token验证成功] 用户ID: 10
|
||
19:44:53 - article_server - INFO - [SQL执行] 开始执行查询SQL
|
||
19:44:53 - article_server - INFO - [SQL语句]
|
||
SELECT r.product_id, p.name as product_name,
|
||
COUNT(*) as publishes,
|
||
ROUND(COUNT(*) * 100.0 / (SELECT COUNT(*) FROM ai_article_published_records WHERE enterprise_id = %s), 0) as percentage
|
||
FROM ai_article_published_records r
|
||
LEFT JOIN ai_products p ON r.product_id = p.id
|
||
WHERE r.enterprise_id = %s
|
||
GROUP BY r.product_id, p.name
|
||
ORDER BY publishes DESC
|
||
LIMIT %s
|
||
|
||
19:44:53 - article_server - INFO - [SQL参数] (1, 1, 4)
|
||
19:44:53 - article_server - INFO - [SQL结果] 查询完成，返回 4 条记录
|
||
19:44:53 - article_server - INFO - 获取热门产品成功
|
||
19:44:53 - article_server - INFO - [API响应] GET /api/dashboard/hot-products - IP: 104.244.91.212 - 状态码: 200
|
||
19:44:54 - article_server - INFO - [API访问] GET /api/employees/list - IP: 104.244.91.212 - User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/143.0.0.0 Sa
|
||
19:44:54 - article_server - INFO - [Token验证成功] 用户ID: 10
|
||
19:44:54 - article_server - INFO - [SQL执行] 开始执行查询SQL
|
||
19:44:54 - article_server - INFO - [SQL语句] SELECT COUNT(*) as total FROM ai_users u WHERE u.enterprise_id = %s AND u.status != 'deleted'
|
||
19:44:54 - article_server - INFO - [SQL参数] [1]
|
||
19:44:54 - article_server - INFO - [API访问] GET /api/employees/stats - IP: 104.244.91.212 - User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/143.0.0.0 Sa
|
||
19:44:54 - article_server - INFO - [Token验证成功] 用户ID: 10
|
||
19:44:54 - article_server - INFO - [SQL结果] 查询完成，返回 1 条记录
|
||
19:44:54 - article_server - INFO - [SQL数据] 查询结果: [{'total': 6}]
|
||
19:44:54 - article_server - INFO - [SQL执行] 开始执行查询SQL
|
||
19:44:54 - 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'
|
||
|
||
19:44:54 - article_server - INFO - [SQL参数] (1,)
|
||
19:44:54 - article_server - INFO - [SQL结果] 查询完成，返回 1 条记录
|
||
19:44:54 - article_server - INFO - [SQL数据] 查询结果: [{'total_count': 6, 'active_count': Decimal('6'), 'bound_xhs_count': Decimal('3')}]
|
||
19:44:54 - article_server - INFO - [SQL执行] 开始执行查询SQL
|
||
19:44:54 - article_server - INFO - [SQL语句]
|
||
SELECT u.id, u.enterprise_id, u.real_name as name, u.username, u.phone, u.role, u.department,
|
||
u.is_bound_xhs, a.xhs_account, u.status, u.created_at, u.updated_at
|
||
FROM ai_users u
|
||
LEFT JOIN ai_authors a ON u.id = a.created_user_id AND a.status = 'active'
|
||
WHERE u.enterprise_id = %s AND u.status != 'deleted'
|
||
ORDER BY u.created_at DESC
|
||
LIMIT %s OFFSET %s
|
||
|
||
19:44:54 - article_server - INFO - [SQL参数] [1, 10, 0]
|
||
19:44:54 - article_server - INFO - 获取员工统计成功
|
||
19:44:54 - article_server - INFO - [API响应] GET /api/employees/stats - IP: 104.244.91.212 - 状态码: 200
|
||
19:44:54 - article_server - INFO - [SQL结果] 查询完成，返回 6 条记录
|
||
19:44:54 - article_server - INFO - 获取员工列表成功，总数: 6
|
||
19:44:54 - article_server - INFO - [API响应] GET /api/employees/list - IP: 104.244.91.212 - 状态码: 200
|
||
19:46:46 - article_server - INFO - [API访问] GET /api/employees/stats - IP: 104.244.91.212 - User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/143.0.0.0 Sa
|
||
19:46:46 - article_server - INFO - [Token验证成功] 用户ID: 10
|
||
19:46:46 - article_server - INFO - [API访问] GET /api/employees/list - IP: 104.244.91.212 - User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/143.0.0.0 Sa
|
||
19:46:46 - article_server - INFO - [Token验证成功] 用户ID: 10
|
||
19:46:46 - article_server - INFO - [SQL执行] 开始执行查询SQL
|
||
19:46:46 - 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'
|
||
|
||
19:46:46 - article_server - INFO - [SQL参数] (1,)
|
||
19:46:46 - article_server - INFO - [SQL结果] 查询完成，返回 1 条记录
|
||
19:46:46 - article_server - INFO - [SQL数据] 查询结果: [{'total_count': 5, 'active_count': Decimal('5'), 'bound_xhs_count': Decimal('3')}]
|
||
19:46:46 - article_server - INFO - 获取员工统计成功
|
||
19:46:46 - article_server - INFO - [API响应] GET /api/employees/stats - IP: 104.244.91.212 - 状态码: 200
|
||
19:46:46 - article_server - INFO - 数据库连接成功，字符集设置完成
|
||
19:46:46 - article_server - INFO - [SQL执行] 开始执行查询SQL
|
||
19:46:46 - article_server - INFO - [SQL语句] SELECT COUNT(*) as total FROM ai_users u WHERE u.enterprise_id = %s AND u.status != 'deleted'
|
||
19:46:46 - article_server - INFO - [SQL参数] [1]
|
||
19:46:46 - article_server - INFO - [SQL结果] 查询完成，返回 1 条记录
|
||
19:46:46 - article_server - INFO - [SQL数据] 查询结果: [{'total': 5}]
|
||
19:46:47 - article_server - INFO - [SQL执行] 开始执行查询SQL
|
||
19:46:47 - article_server - INFO - [SQL语句]
|
||
SELECT u.id, u.enterprise_id, u.real_name as name, u.username, u.phone, u.role, u.department,
|
||
u.is_bound_xhs, a.xhs_account, u.status, u.created_at, u.updated_at
|
||
FROM ai_users u
|
||
LEFT JOIN ai_authors a ON u.id = a.created_user_id AND a.status = 'active'
|
||
WHERE u.enterprise_id = %s AND u.status != 'deleted'
|
||
ORDER BY u.created_at DESC
|
||
LIMIT %s OFFSET %s
|
||
|
||
19:46:47 - article_server - INFO - [SQL参数] [1, 10, 0]
|
||
19:46:47 - article_server - INFO - [SQL结果] 查询完成，返回 5 条记录
|
||
19:46:47 - article_server - INFO - 获取员工列表成功，总数: 5
|
||
19:46:47 - article_server - INFO - [API响应] GET /api/employees/list - IP: 104.244.91.212 - 状态码: 200
|
||
19:46:47 - article_server - INFO - [API访问] GET /api/users/info - IP: 104.244.91.212 - User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/143.0.0.0 Sa
|
||
19:46:47 - article_server - INFO - [Token验证成功] 用户ID: 10
|
||
19:46:47 - article_server - INFO - [获取用户信息] 开始处理请求, IP: 104.244.91.212
|
||
19:46:47 - article_server - INFO - [获取用户信息] 用户ID: 10, action: , IP: 104.244.91.212
|
||
19:46:47 - article_server - INFO - [SQL执行] 开始执行查询SQL
|
||
19:46:47 - article_server - INFO - [SQL语句]
|
||
SELECT id, enterprise_id, enterprise_name, username, real_name, email, phone,
|
||
wechat_openid, wechat_unionid,
|
||
is_bound_xhs, department, role, status, created_at, updated_at
|
||
FROM ai_users u
|
||
WHERE id = %s AND status != 'deleted'
|
||
|
||
19:46:47 - article_server - INFO - [SQL参数] (10,)
|
||
19:46:47 - article_server - INFO - [SQL结果] 查询完成，返回 1 条记录
|
||
19:46:47 - article_server - INFO - [SQL数据] 查询结果: [{'id': 10, 'enterprise_id': 1, 'enterprise_name': '测试企业10号', 'username': 'user010', 'real_name': '测试用户10', 'email': None, 'phone': '13621242430', 'wechat_openid': 'ovoJF1z6ejXbXcWUHnvCw5HA0OeA', 'wechat_unionid': None, 'is_bound_xhs': 1, 'department': '运营部', 'role': 'enterprise', 'status': 'active', 'created_at': datetime.datetime(2025, 12, 12, 16, 58, 22), 'updated_at': datetime.datetime(2025, 12, 21, 11, 46, 17)}]
|
||
19:46:47 - article_server - INFO - [SQL执行] 开始执行插入SQL
|
||
19:46:47 - 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())
|
||
|
||
19:46:47 - article_server - INFO - [SQL参数] (10, 'get_user_info', 'user', 10, '查询用户信息: user010, action=', '104.244.91.212', '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)
|
||
19:46:47 - article_server - INFO - [SQL结果] 插入完成，新记录ID: 64282
|
||
19:46:47 - article_server - INFO - [业务日志] 操作: get_user_info | 用户ID: 10 | 目标: user#10 | 状态: success | IP: 104.244.91.212 | 日志ID: 64282
|
||
19:46:47 - article_server - INFO - [API响应] GET /api/users/info - IP: 104.244.91.212 - 状态码: 200
|
||
19:47:15 - article_server - INFO - [API访问] GET /api/employees/list - IP: 104.244.91.212 - User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/143.0.0.0 Sa
|
||
19:47:15 - article_server - INFO - [API访问] GET /api/employees/stats - IP: 104.244.91.212 - User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/143.0.0.0 Sa
|
||
19:47:15 - article_server - INFO - [Token验证成功] 用户ID: 10
|
||
19:47:15 - article_server - INFO - [Token验证成功] 用户ID: 10
|
||
19:47:15 - article_server - INFO - [API访问] GET /api/users/info - IP: 104.244.91.212 - User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/143.0.0.0 Sa
|
||
19:47:15 - article_server - INFO - [Token验证成功] 用户ID: 10
|
||
19:47:15 - article_server - INFO - [获取用户信息] 开始处理请求, IP: 104.244.91.212
|
||
19:47:15 - article_server - INFO - [获取用户信息] 用户ID: 10, action: , IP: 104.244.91.212
|
||
19:47:15 - article_server - INFO - [SQL执行] 开始执行查询SQL
|
||
19:47:15 - article_server - INFO - [SQL语句] SELECT COUNT(*) as total FROM ai_users u WHERE u.enterprise_id = %s AND u.status != 'deleted'
|
||
19:47:15 - article_server - INFO - [SQL参数] [1]
|
||
19:47:15 - article_server - INFO - [SQL执行] 开始执行查询SQL
|
||
19:47:15 - 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'
|
||
|
||
19:47:15 - article_server - INFO - [SQL参数] (1,)
|
||
19:47:15 - article_server - INFO - [SQL结果] 查询完成，返回 1 条记录
|
||
19:47:15 - article_server - INFO - [SQL数据] 查询结果: [{'total': 5}]
|
||
19:47:15 - article_server - INFO - [SQL结果] 查询完成，返回 1 条记录
|
||
19:47:15 - article_server - INFO - [SQL数据] 查询结果: [{'total_count': 5, 'active_count': Decimal('5'), 'bound_xhs_count': Decimal('3')}]
|
||
19:47:15 - article_server - INFO - 获取员工统计成功
|
||
19:47:15 - article_server - INFO - [API响应] GET /api/employees/stats - IP: 104.244.91.212 - 状态码: 200
|
||
19:47:15 - article_server - INFO - [SQL执行] 开始执行查询SQL
|
||
19:47:15 - article_server - INFO - [SQL语句]
|
||
SELECT u.id, u.enterprise_id, u.real_name as name, u.username, u.phone, u.role, u.department,
|
||
u.is_bound_xhs, a.xhs_account, u.status, u.created_at, u.updated_at
|
||
FROM ai_users u
|
||
LEFT JOIN ai_authors a ON u.id = a.created_user_id AND a.status = 'active'
|
||
WHERE u.enterprise_id = %s AND u.status != 'deleted'
|
||
ORDER BY u.created_at DESC
|
||
LIMIT %s OFFSET %s
|
||
|
||
19:47:15 - article_server - INFO - [SQL参数] [1, 10, 0]
|
||
19:47:15 - article_server - INFO - [SQL结果] 查询完成，返回 5 条记录
|
||
19:47:15 - article_server - INFO - 数据库连接成功，字符集设置完成
|
||
19:47:15 - article_server - INFO - [SQL执行] 开始执行查询SQL
|
||
19:47:15 - article_server - INFO - [SQL语句]
|
||
SELECT id, enterprise_id, enterprise_name, username, real_name, email, phone,
|
||
wechat_openid, wechat_unionid,
|
||
is_bound_xhs, department, role, status, created_at, updated_at
|
||
FROM ai_users u
|
||
WHERE id = %s AND status != 'deleted'
|
||
|
||
19:47:15 - article_server - INFO - [SQL参数] (10,)
|
||
19:47:15 - article_server - INFO - 获取员工列表成功，总数: 5
|
||
19:47:15 - article_server - INFO - [API响应] GET /api/employees/list - IP: 104.244.91.212 - 状态码: 200
|
||
19:47:15 - article_server - INFO - [SQL结果] 查询完成，返回 1 条记录
|
||
19:47:15 - article_server - INFO - [SQL数据] 查询结果: [{'id': 10, 'enterprise_id': 1, 'enterprise_name': '测试企业10号', 'username': '饶文龙', 'real_name': '测试用户10', 'email': None, 'phone': '13621242430', 'wechat_openid': 'ovoJF1z6ejXbXcWUHnvCw5HA0OeA', 'wechat_unionid': None, 'is_bound_xhs': 1, 'department': '运营部', 'role': 'enterprise', 'status': 'active', 'created_at': datetime.datetime(2025, 12, 12, 16, 58, 22), 'updated_at': datetime.datetime(2025, 12, 21, 11, 47, 10)}]
|
||
19:47:15 - article_server - INFO - [SQL执行] 开始执行插入SQL
|
||
19:47:15 - 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())
|
||
|
||
19:47:15 - article_server - INFO - [SQL参数] (10, 'get_user_info', 'user', 10, '查询用户信息: 饶文龙, action=', '104.244.91.212', '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)
|
||
19:47:15 - article_server - INFO - [SQL结果] 插入完成，新记录ID: 64293
|
||
19:47:15 - article_server - INFO - [业务日志] 操作: get_user_info | 用户ID: 10 | 目标: user#10 | 状态: success | IP: 104.244.91.212 | 日志ID: 64293
|
||
19:47:15 - article_server - INFO - [API响应] GET /api/users/info - IP: 104.244.91.212 - 状态码: 200
|
||
19:47:53 - article_server - INFO - [API访问] POST /api/users/add_employees - IP: 104.244.91.212 - User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/143.0.0.0 Sa
|
||
19:47:53 - article_server - INFO - [Token验证成功] 用户ID: 10
|
||
19:47:53 - article_server - INFO - [SQL执行] 开始执行查询SQL
|
||
19:47:53 - article_server - INFO - [SQL语句] SELECT id FROM ai_users WHERE phone = %s AND enterprise_id = %s
|
||
19:47:53 - article_server - INFO - [SQL参数] ('13968016804', 1)
|
||
19:47:53 - article_server - INFO - [SQL结果] 查询完成，返回 0 条记录
|
||
19:47:53 - article_server - INFO - [SQL执行] 开始执行查询SQL
|
||
19:47:53 - article_server - INFO - [SQL语句] SELECT name FROM ai_enterprises WHERE id = %s
|
||
19:47:53 - article_server - INFO - [SQL参数] (1,)
|
||
19:47:53 - article_server - INFO - [SQL结果] 查询完成，返回 1 条记录
|
||
19:47:53 - article_server - INFO - [SQL数据] 查询结果: [{'name': '乐航'}]
|
||
19:47:53 - article_server - INFO - [SQL执行] 开始执行插入SQL
|
||
19:47:53 - article_server - INFO - [SQL语句]
|
||
INSERT INTO ai_users
|
||
(enterprise_id, enterprise_name, username, real_name, phone, password, role, department, status, is_bound_xhs)
|
||
VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s)
|
||
|
||
19:47:53 - article_server - INFO - [SQL参数] (1, '乐航', '13968016804', '付胜辉', '13968016804', '3bfefcfa61c5b912c77de8e7b712b7e713f613365a8f53ef49b5da6c4bc64060', 'supervisor', '', 'active', 0)
|
||
19:47:53 - article_server - INFO - [SQL结果] 插入完成，新记录ID: 22
|
||
19:47:53 - article_server - INFO - [SQL执行] 开始执行更新SQL
|
||
19:47:53 - article_server - INFO - [SQL语句] UPDATE ai_enterprises SET users_total = users_total + 1 WHERE id = %s
|
||
19:47:53 - article_server - INFO - [SQL参数] (1,)
|
||
19:47:53 - article_server - INFO - [SQL结果] 更新完成，影响 1 行
|
||
19:47:53 - article_server - INFO - 添加员工成功: 付胜辉, ID: 22
|
||
19:47:53 - article_server - INFO - [API响应] POST /api/users/add_employees - IP: 104.244.91.212 - 状态码: 200
|
||
19:47:54 - article_server - INFO - [API访问] GET /api/employees/list - IP: 104.244.91.212 - User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/143.0.0.0 Sa
|
||
19:47:54 - article_server - INFO - [Token验证成功] 用户ID: 10
|
||
19:47:54 - article_server - INFO - [API访问] GET /api/employees/stats - IP: 104.244.91.212 - User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/143.0.0.0 Sa
|
||
19:47:54 - article_server - INFO - [Token验证成功] 用户ID: 10
|
||
19:47:54 - article_server - INFO - [SQL执行] 开始执行查询SQL
|
||
19:47:54 - article_server - INFO - [SQL语句] SELECT COUNT(*) as total FROM ai_users u WHERE u.enterprise_id = %s AND u.status != 'deleted'
|
||
19:47:54 - article_server - INFO - [SQL参数] [1]
|
||
19:47:54 - article_server - INFO - [SQL执行] 开始执行查询SQL
|
||
19:47:54 - 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'
|
||
|
||
19:47:54 - article_server - INFO - [SQL参数] (1,)
|
||
19:47:54 - article_server - INFO - [SQL结果] 查询完成，返回 1 条记录
|
||
19:47:54 - article_server - INFO - [SQL数据] 查询结果: [{'total': 6}]
|
||
19:47:54 - article_server - INFO - [SQL结果] 查询完成，返回 1 条记录
|
||
19:47:54 - article_server - INFO - [SQL数据] 查询结果: [{'total_count': 6, 'active_count': Decimal('6'), 'bound_xhs_count': Decimal('3')}]
|
||
19:47:54 - article_server - INFO - 获取员工统计成功
|
||
19:47:54 - article_server - INFO - [API响应] GET /api/employees/stats - IP: 104.244.91.212 - 状态码: 200
|
||
19:47:54 - article_server - INFO - [SQL执行] 开始执行查询SQL
|
||
19:47:54 - article_server - INFO - [SQL语句]
|
||
SELECT u.id, u.enterprise_id, u.real_name as name, u.username, u.phone, u.role, u.department,
|
||
u.is_bound_xhs, a.xhs_account, u.status, u.created_at, u.updated_at
|
||
FROM ai_users u
|
||
LEFT JOIN ai_authors a ON u.id = a.created_user_id AND a.status = 'active'
|
||
WHERE u.enterprise_id = %s AND u.status != 'deleted'
|
||
ORDER BY u.created_at DESC
|
||
LIMIT %s OFFSET %s
|
||
|
||
19:47:54 - article_server - INFO - [SQL参数] [1, 10, 0]
|
||
19:47:54 - article_server - INFO - [SQL结果] 查询完成，返回 6 条记录
|
||
19:47:54 - article_server - INFO - 获取员工列表成功，总数: 6
|
||
19:47:54 - article_server - INFO - [API响应] GET /api/employees/list - IP: 104.244.91.212 - 状态码: 200
|
||
19:48:31 - article_server - INFO - [API访问] GET /api/employees/list - IP: 104.244.91.212 - User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/143.0.0.0 Sa
|
||
19:48:31 - article_server - INFO - [Token验证成功] 用户ID: 10
|
||
19:48:31 - article_server - INFO - [API访问] GET /api/employees/stats - IP: 104.244.91.212 - User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/143.0.0.0 Sa
|
||
19:48:31 - article_server - INFO - [Token验证成功] 用户ID: 10
|
||
19:48:31 - article_server - INFO - [SQL执行] 开始执行查询SQL
|
||
19:48:31 - article_server - INFO - [SQL语句] SELECT COUNT(*) as total FROM ai_users u WHERE u.enterprise_id = %s AND u.status != 'deleted'
|
||
19:48:31 - article_server - INFO - [SQL参数] [1]
|
||
19:48:31 - article_server - INFO - [SQL执行] 开始执行查询SQL
|
||
19:48:31 - 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'
|
||
|
||
19:48:31 - article_server - INFO - [SQL参数] (1,)
|
||
19:48:31 - article_server - INFO - [SQL结果] 查询完成，返回 1 条记录
|
||
19:48:31 - article_server - INFO - [SQL数据] 查询结果: [{'total': 6}]
|
||
19:48:31 - article_server - INFO - [SQL结果] 查询完成，返回 1 条记录
|
||
19:48:31 - article_server - INFO - [SQL数据] 查询结果: [{'total_count': 6, 'active_count': Decimal('6'), 'bound_xhs_count': Decimal('3')}]
|
||
19:48:31 - article_server - INFO - 获取员工统计成功
|
||
19:48:31 - article_server - INFO - [API响应] GET /api/employees/stats - IP: 104.244.91.212 - 状态码: 200
|
||
19:48:31 - article_server - INFO - [SQL执行] 开始执行查询SQL
|
||
19:48:31 - article_server - INFO - [SQL语句]
|
||
SELECT u.id, u.enterprise_id, u.real_name as name, u.username, u.phone, u.role, u.department,
|
||
u.is_bound_xhs, a.xhs_account, u.status, u.created_at, u.updated_at
|
||
FROM ai_users u
|
||
LEFT JOIN ai_authors a ON u.id = a.created_user_id AND a.status = 'active'
|
||
WHERE u.enterprise_id = %s AND u.status != 'deleted'
|
||
ORDER BY u.created_at DESC
|
||
LIMIT %s OFFSET %s
|
||
|
||
19:48:31 - article_server - INFO - [SQL参数] [1, 10, 0]
|
||
19:48:31 - article_server - INFO - [SQL结果] 查询完成，返回 6 条记录
|
||
19:48:31 - article_server - INFO - 获取员工列表成功，总数: 6
|
||
19:48:31 - article_server - INFO - [API响应] GET /api/employees/list - IP: 104.244.91.212 - 状态码: 200
|
||
19:48:32 - article_server - INFO - [API访问] GET /api/users/info - IP: 104.244.91.212 - User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/143.0.0.0 Sa
|
||
19:48:32 - article_server - INFO - [Token验证成功] 用户ID: 10
|
||
19:48:32 - article_server - INFO - [获取用户信息] 开始处理请求, IP: 104.244.91.212
|
||
19:48:32 - article_server - INFO - [获取用户信息] 用户ID: 10, action: , IP: 104.244.91.212
|
||
19:48:32 - article_server - INFO - [SQL执行] 开始执行查询SQL
|
||
19:48:32 - article_server - INFO - [SQL语句]
|
||
SELECT id, enterprise_id, enterprise_name, username, real_name, email, phone,
|
||
wechat_openid, wechat_unionid,
|
||
is_bound_xhs, department, role, status, created_at, updated_at
|
||
FROM ai_users u
|
||
WHERE id = %s AND status != 'deleted'
|
||
|
||
19:48:32 - article_server - INFO - [SQL参数] (10,)
|
||
19:48:32 - article_server - INFO - [SQL结果] 查询完成，返回 1 条记录
|
||
19:48:32 - article_server - INFO - [SQL数据] 查询结果: [{'id': 10, 'enterprise_id': 1, 'enterprise_name': '测试企业10号', 'username': '饶文龙', 'real_name': '测试用户10', 'email': None, 'phone': '13621242430', 'wechat_openid': 'ovoJF1z6ejXbXcWUHnvCw5HA0OeA', 'wechat_unionid': None, 'is_bound_xhs': 1, 'department': '运营部', 'role': 'enterprise', 'status': 'active', 'created_at': datetime.datetime(2025, 12, 12, 16, 58, 22), 'updated_at': datetime.datetime(2025, 12, 21, 11, 47, 10)}]
|
||
19:48:32 - article_server - INFO - [SQL执行] 开始执行插入SQL
|
||
19:48:32 - 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())
|
||
|
||
19:48:32 - article_server - INFO - [SQL参数] (10, 'get_user_info', 'user', 10, '查询用户信息: 饶文龙, action=', '104.244.91.212', '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)
|
||
19:48:32 - article_server - INFO - [SQL结果] 插入完成，新记录ID: 64324
|
||
19:48:32 - article_server - INFO - [业务日志] 操作: get_user_info | 用户ID: 10 | 目标: user#10 | 状态: success | IP: 104.244.91.212 | 日志ID: 64324
|
||
19:48:32 - article_server - INFO - [API响应] GET /api/users/info - IP: 104.244.91.212 - 状态码: 200
|
||
19:48:37 - article_server - INFO - [API访问] GET /api/enterprises/info - IP: 104.244.91.212 - User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/143.0.0.0 Sa
|
||
19:48:37 - article_server - INFO - [Token验证成功] 用户ID: 10
|
||
19:48:38 - article_server - INFO - [SQL执行] 开始执行查询SQL
|
||
19:48:38 - article_server - INFO - [SQL语句]
|
||
SELECT id, enterprise_ID, name, short_name, phone, email, status,
|
||
users_total, products_total, articles_total, published_total,
|
||
created_at, updated_at
|
||
FROM ai_enterprises
|
||
WHERE id = %s
|
||
|
||
19:48:38 - article_server - INFO - [SQL参数] (1,)
|
||
19:48:38 - article_server - INFO - [SQL结果] 查询完成，返回 1 条记录
|
||
19:48:38 - article_server - INFO - [SQL数据] 查询结果: [{'id': 1, 'enterprise_ID': 'ENT-2024-0001', 'name': '乐航', 'short_name': '企业122你们好', 'phone': '13621242430', 'email': 'raowenlong@vizee.cn', 'status': 'active', 'users_total': 3, 'products_total': 2, 'articles_total': 40, 'published_total': 0, 'created_at': datetime.datetime(2025, 12, 12, 16, 58, 22), 'updated_at': datetime.datetime(2025, 12, 21, 11, 47, 53)}]
|
||
19:48:38 - article_server - INFO - 获取企业信息成功（含密码）: ID 1
|
||
19:48:38 - article_server - INFO - [API响应] GET /api/enterprises/info - IP: 104.244.91.212 - 状态码: 200
|
||
19:48:51 - article_server - INFO - [API访问] GET /api/employees/stats - IP: 104.244.91.212 - User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/143.0.0.0 Sa
|
||
19:48:51 - article_server - INFO - [Token验证成功] 用户ID: 10
|
||
19:48:51 - article_server - INFO - [API访问] GET /api/employees/list - IP: 104.244.91.212 - User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/143.0.0.0 Sa
|
||
19:48:51 - article_server - INFO - [Token验证成功] 用户ID: 10
|
||
19:48:51 - article_server - INFO - [SQL执行] 开始执行查询SQL
|
||
19:48:51 - 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'
|
||
|
||
19:48:51 - article_server - INFO - [SQL参数] (1,)
|
||
19:48:51 - article_server - INFO - [SQL结果] 查询完成，返回 1 条记录
|
||
19:48:51 - article_server - INFO - [SQL数据] 查询结果: [{'total_count': 6, 'active_count': Decimal('6'), 'bound_xhs_count': Decimal('3')}]
|
||
19:48:51 - article_server - INFO - 获取员工统计成功
|
||
19:48:51 - article_server - INFO - [API响应] GET /api/employees/stats - IP: 104.244.91.212 - 状态码: 200
|
||
19:48:51 - article_server - INFO - 数据库连接成功，字符集设置完成
|
||
19:48:51 - article_server - INFO - [SQL执行] 开始执行查询SQL
|
||
19:48:51 - article_server - INFO - [SQL语句] SELECT COUNT(*) as total FROM ai_users u WHERE u.enterprise_id = %s AND u.status != 'deleted'
|
||
19:48:51 - article_server - INFO - [SQL参数] [1]
|
||
19:48:51 - article_server - INFO - [SQL结果] 查询完成，返回 1 条记录
|
||
19:48:51 - article_server - INFO - [SQL数据] 查询结果: [{'total': 6}]
|
||
19:48:51 - article_server - INFO - [SQL执行] 开始执行查询SQL
|
||
19:48:51 - article_server - INFO - [SQL语句]
|
||
SELECT u.id, u.enterprise_id, u.real_name as name, u.username, u.phone, u.role, u.department,
|
||
u.is_bound_xhs, a.xhs_account, u.status, u.created_at, u.updated_at
|
||
FROM ai_users u
|
||
LEFT JOIN ai_authors a ON u.id = a.created_user_id AND a.status = 'active'
|
||
WHERE u.enterprise_id = %s AND u.status != 'deleted'
|
||
ORDER BY u.created_at DESC
|
||
LIMIT %s OFFSET %s
|
||
|
||
19:48:51 - article_server - INFO - [SQL参数] [1, 10, 0]
|
||
19:48:51 - article_server - INFO - [SQL结果] 查询完成，返回 6 条记录
|
||
19:48:51 - article_server - INFO - 获取员工列表成功，总数: 6
|
||
19:48:51 - article_server - INFO - [API响应] GET /api/employees/list - IP: 104.244.91.212 - 状态码: 200
|
||
19:50:05 - article_server - INFO - [API访问] GET /api/employees/list - IP: 104.244.91.212 - User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/143.0.0.0 Sa
|
||
19:50:05 - article_server - INFO - [Token验证成功] 用户ID: 10
|
||
19:50:05 - article_server - INFO - [API访问] GET /api/employees/stats - IP: 104.244.91.212 - User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/143.0.0.0 Sa
|
||
19:50:05 - article_server - INFO - [Token验证成功] 用户ID: 10
|
||
19:50:05 - article_server - INFO - [SQL执行] 开始执行查询SQL
|
||
19:50:05 - article_server - INFO - [SQL语句] SELECT COUNT(*) as total FROM ai_users u WHERE u.enterprise_id = %s AND u.status != 'deleted'
|
||
19:50:05 - article_server - INFO - [SQL参数] [1]
|
||
19:50:05 - article_server - INFO - [SQL执行] 开始执行查询SQL
|
||
19:50:05 - 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'
|
||
|
||
19:50:05 - article_server - INFO - [SQL参数] (1,)
|
||
19:50:05 - article_server - INFO - [SQL结果] 查询完成，返回 1 条记录
|
||
19:50:05 - article_server - INFO - [SQL数据] 查询结果: [{'total': 6}]
|
||
19:50:05 - article_server - INFO - [SQL结果] 查询完成，返回 1 条记录
|
||
19:50:05 - article_server - INFO - [SQL数据] 查询结果: [{'total_count': 6, 'active_count': Decimal('6'), 'bound_xhs_count': Decimal('3')}]
|
||
19:50:05 - article_server - INFO - 获取员工统计成功
|
||
19:50:05 - article_server - INFO - [API响应] GET /api/employees/stats - IP: 104.244.91.212 - 状态码: 200
|
||
19:50:05 - article_server - INFO - [SQL执行] 开始执行查询SQL
|
||
19:50:05 - article_server - INFO - [SQL语句]
|
||
SELECT u.id, u.enterprise_id, u.real_name as name, u.username, u.phone, u.role, u.department,
|
||
u.is_bound_xhs, a.xhs_account, u.status, u.created_at, u.updated_at
|
||
FROM ai_users u
|
||
LEFT JOIN ai_authors a ON u.id = a.created_user_id AND a.status = 'active'
|
||
WHERE u.enterprise_id = %s AND u.status != 'deleted'
|
||
ORDER BY u.created_at DESC
|
||
LIMIT %s OFFSET %s
|
||
|
||
19:50:05 - article_server - INFO - [SQL参数] [1, 10, 0]
|
||
19:50:05 - article_server - INFO - [SQL结果] 查询完成，返回 6 条记录
|
||
19:50:05 - article_server - INFO - 获取员工列表成功，总数: 6
|
||
19:50:05 - article_server - INFO - [API响应] GET /api/employees/list - IP: 104.244.91.212 - 状态码: 200
|
||
19:50:05 - article_server - INFO - [API访问] GET /api/users/info - IP: 104.244.91.212 - User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/143.0.0.0 Sa
|
||
19:50:05 - article_server - INFO - [Token验证成功] 用户ID: 10
|
||
19:50:05 - article_server - INFO - [获取用户信息] 开始处理请求, IP: 104.244.91.212
|
||
19:50:05 - article_server - INFO - [获取用户信息] 用户ID: 10, action: , IP: 104.244.91.212
|
||
19:50:05 - article_server - INFO - [SQL执行] 开始执行查询SQL
|
||
19:50:05 - article_server - INFO - [SQL语句]
|
||
SELECT id, enterprise_id, enterprise_name, username, real_name, email, phone,
|
||
wechat_openid, wechat_unionid,
|
||
is_bound_xhs, department, role, status, created_at, updated_at
|
||
FROM ai_users u
|
||
WHERE id = %s AND status != 'deleted'
|
||
|
||
19:50:05 - article_server - INFO - [SQL参数] (10,)
|
||
19:50:05 - article_server - INFO - [SQL结果] 查询完成，返回 1 条记录
|
||
19:50:05 - article_server - INFO - [SQL数据] 查询结果: [{'id': 10, 'enterprise_id': 1, 'enterprise_name': '测试企业10号', 'username': '饶文龙', 'real_name': '测试用户10', 'email': None, 'phone': '13621242430', 'wechat_openid': 'ovoJF1z6ejXbXcWUHnvCw5HA0OeA', 'wechat_unionid': None, 'is_bound_xhs': 1, 'department': '运营部', 'role': 'enterprise', 'status': 'active', 'created_at': datetime.datetime(2025, 12, 12, 16, 58, 22), 'updated_at': datetime.datetime(2025, 12, 21, 11, 47, 10)}]
|
||
19:50:05 - article_server - INFO - [SQL执行] 开始执行插入SQL
|
||
19:50: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())
|
||
|
||
19:50:05 - article_server - INFO - [SQL参数] (10, 'get_user_info', 'user', 10, '查询用户信息: 饶文龙, action=', '104.244.91.212', '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)
|
||
19:50:05 - article_server - INFO - [SQL结果] 插入完成，新记录ID: 64361
|
||
19:50:05 - article_server - INFO - [业务日志] 操作: get_user_info | 用户ID: 10 | 目标: user#10 | 状态: success | IP: 104.244.91.212 | 日志ID: 64361
|
||
19:50:05 - article_server - INFO - [API响应] GET /api/users/info - IP: 104.244.91.212 - 状态码: 200
|
||
19:50:13 - article_server - INFO - [API访问] GET /api/enterprises/list - IP: 104.244.91.212 - User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/143.0.0.0 Sa
|
||
19:50:13 - article_server - INFO - [Token验证成功] 用户ID: 10
|
||
19:50:13 - article_server - INFO - [获取企业列表] 开始处理请求, IP: 104.244.91.212
|
||
19:50:13 - article_server - INFO - [获取企业列表] 查询参数: page=1, pageSize=10, keyword=, status=, IP: 104.244.91.212
|
||
19:50:13 - article_server - INFO - [SQL执行] 开始执行查询SQL
|
||
19:50:13 - article_server - INFO - [SQL语句] SELECT COUNT(*) as total FROM ai_enterprises WHERE 1=1
|
||
19:50:13 - article_server - INFO - [SQL结果] 查询完成，返回 1 条记录
|
||
19:50:13 - article_server - INFO - [SQL数据] 查询结果: [{'total': 11}]
|
||
19:50:13 - article_server - INFO - [SQL执行] 开始执行查询SQL
|
||
19:50:13 - article_server - INFO - [SQL语句]
|
||
SELECT id, enterprise_ID, name, short_name, phone, email, status,
|
||
users_total, products_total, articles_total, published_total,
|
||
created_at, updated_at
|
||
FROM ai_enterprises
|
||
WHERE 1=1
|
||
ORDER BY created_at DESC
|
||
LIMIT %s OFFSET %s
|
||
|
||
19:50:13 - article_server - INFO - [SQL参数] [10, 0]
|
||
19:50:13 - article_server - INFO - [SQL结果] 查询完成，返回 10 条记录
|
||
19:50:13 - article_server - INFO - [获取企业列表] 查询成功, 总数: 11, 当前页: 1, 每页: 10, 返回数量: 10, IP: 104.244.91.212
|
||
19:50:13 - article_server - INFO - [API响应] GET /api/enterprises/list - IP: 104.244.91.212 - 状态码: 200
|
||
19:50:20 - article_server - INFO - [API访问] DELETE /api/enterprises/11 - IP: 104.244.91.212 - User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/143.0.0.0 Sa
|
||
19:50:20 - article_server - INFO - [Token验证成功] 用户ID: 10
|
||
19:50:20 - article_server - INFO - [SQL执行] 开始执行查询SQL
|
||
19:50:20 - article_server - INFO - [SQL语句] SELECT id, name FROM ai_enterprises WHERE id = %s
|
||
19:50:20 - article_server - INFO - [SQL参数] (11,)
|
||
19:50:20 - article_server - INFO - [SQL结果] 查询完成，返回 1 条记录
|
||
19:50:20 - article_server - INFO - [SQL数据] 查询结果: [{'id': 11, 'name': '测试企业API_1765537579'}]
|
||
19:50:20 - article_server - INFO - [SQL执行] 开始执行更新SQL
|
||
19:50:20 - article_server - INFO - [SQL语句] DELETE FROM ai_enterprises WHERE id = %s
|
||
19:50:20 - article_server - INFO - [SQL参数] (11,)
|
||
19:50:20 - article_server - INFO - [SQL结果] 更新完成，影响 1 行
|
||
19:50:20 - article_server - INFO - 删除企业成功: 测试企业API_1765537579
|
||
19:50:20 - article_server - INFO - [SQL执行] 开始执行插入SQL
|
||
19:50:20 - 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())
|
||
|
||
19:50:20 - article_server - INFO - [SQL参数] (10, 'delete_enterprise', 'enterprise', 11, '删除企业: 测试企业API_1765537579', '104.244.91.212', '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)
|
||
19:50:20 - article_server - INFO - [SQL结果] 插入完成，新记录ID: 64368
|
||
19:50:20 - article_server - INFO - [业务日志] 操作: delete_enterprise | 用户ID: 10 | 目标: enterprise#11 | 状态: success | IP: 104.244.91.212 | 日志ID: 64368
|
||
19:50:20 - article_server - INFO - [API响应] DELETE /api/enterprises/11 - IP: 104.244.91.212 - 状态码: 200
|
||
19:50:20 - article_server - INFO - [API访问] GET /api/enterprises/list - IP: 104.244.91.212 - User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/143.0.0.0 Sa
|
||
19:50:20 - article_server - INFO - [Token验证成功] 用户ID: 10
|
||
19:50:20 - article_server - INFO - [获取企业列表] 开始处理请求, IP: 104.244.91.212
|
||
19:50:20 - article_server - INFO - [获取企业列表] 查询参数: page=1, pageSize=10, keyword=, status=, IP: 104.244.91.212
|
||
19:50:20 - article_server - INFO - [SQL执行] 开始执行查询SQL
|
||
19:50:20 - article_server - INFO - [SQL语句] SELECT COUNT(*) as total FROM ai_enterprises WHERE 1=1
|
||
19:50:20 - article_server - INFO - [SQL结果] 查询完成，返回 1 条记录
|
||
19:50:20 - article_server - INFO - [SQL数据] 查询结果: [{'total': 10}]
|
||
19:50:20 - article_server - INFO - [SQL执行] 开始执行查询SQL
|
||
19:50:20 - article_server - INFO - [SQL语句]
|
||
SELECT id, enterprise_ID, name, short_name, phone, email, status,
|
||
users_total, products_total, articles_total, published_total,
|
||
created_at, updated_at
|
||
FROM ai_enterprises
|
||
WHERE 1=1
|
||
ORDER BY created_at DESC
|
||
LIMIT %s OFFSET %s
|
||
|
||
19:50:20 - article_server - INFO - [SQL参数] [10, 0]
|
||
19:50:20 - article_server - INFO - [SQL结果] 查询完成，返回 10 条记录
|
||
19:50:20 - article_server - INFO - [获取企业列表] 查询成功, 总数: 10, 当前页: 1, 每页: 10, 返回数量: 10, IP: 104.244.91.212
|
||
19:50:20 - article_server - INFO - [API响应] GET /api/enterprises/list - IP: 104.244.91.212 - 状态码: 200
|
||
19:50:49 - article_server - INFO - [API访问] DELETE /api/enterprises/3 - IP: 104.244.91.212 - User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/143.0.0.0 Sa
|
||
19:50:49 - article_server - INFO - [Token验证成功] 用户ID: 10
|
||
19:50:49 - article_server - INFO - [SQL执行] 开始执行查询SQL
|
||
19:50:49 - article_server - INFO - [SQL语句] SELECT id, name FROM ai_enterprises WHERE id = %s
|
||
19:50:49 - article_server - INFO - [SQL参数] (3,)
|
||
19:50:49 - article_server - INFO - [SQL结果] 查询完成，返回 1 条记录
|
||
19:50:49 - article_server - INFO - [SQL数据] 查询结果: [{'id': 3, 'name': '测试企业3号'}]
|
||
19:50:49 - article_server - INFO - [SQL执行] 开始执行更新SQL
|
||
19:50:49 - article_server - INFO - [SQL语句] DELETE FROM ai_enterprises WHERE id = %s
|
||
19:50:49 - article_server - INFO - [SQL参数] (3,)
|
||
19:50:49 - article_server - INFO - [SQL结果] 更新完成，影响 1 行
|
||
19:50:49 - article_server - INFO - 删除企业成功: 测试企业3号
|
||
19:50:49 - article_server - INFO - [SQL执行] 开始执行插入SQL
|
||
19:50:49 - 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())
|
||
|
||
19:50:49 - article_server - INFO - [SQL参数] (10, 'delete_enterprise', 'enterprise', 3, '删除企业: 测试企业3号', '104.244.91.212', '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)
|
||
19:50:49 - article_server - INFO - [SQL结果] 插入完成，新记录ID: 64379
|
||
19:50:49 - article_server - INFO - [业务日志] 操作: delete_enterprise | 用户ID: 10 | 目标: enterprise#3 | 状态: success | IP: 104.244.91.212 | 日志ID: 64379
|
||
19:50:49 - article_server - INFO - [API响应] DELETE /api/enterprises/3 - IP: 104.244.91.212 - 状态码: 200
|
||
19:50:50 - article_server - INFO - [API访问] GET /api/enterprises/list - IP: 104.244.91.212 - User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/143.0.0.0 Sa
|
||
19:50:50 - article_server - INFO - [Token验证成功] 用户ID: 10
|
||
19:50:50 - article_server - INFO - [获取企业列表] 开始处理请求, IP: 104.244.91.212
|
||
19:50:50 - article_server - INFO - [获取企业列表] 查询参数: page=1, pageSize=10, keyword=, status=, IP: 104.244.91.212
|
||
19:50:50 - article_server - INFO - [SQL执行] 开始执行查询SQL
|
||
19:50:50 - article_server - INFO - [SQL语句] SELECT COUNT(*) as total FROM ai_enterprises WHERE 1=1
|
||
19:50:50 - article_server - INFO - [SQL结果] 查询完成，返回 1 条记录
|
||
19:50:50 - article_server - INFO - [SQL数据] 查询结果: [{'total': 9}]
|
||
19:50:50 - article_server - INFO - [SQL执行] 开始执行查询SQL
|
||
19:50:50 - article_server - INFO - [SQL语句]
|
||
SELECT id, enterprise_ID, name, short_name, phone, email, status,
|
||
users_total, products_total, articles_total, published_total,
|
||
created_at, updated_at
|
||
FROM ai_enterprises
|
||
WHERE 1=1
|
||
ORDER BY created_at DESC
|
||
LIMIT %s OFFSET %s
|
||
|
||
19:50:50 - article_server - INFO - [SQL参数] [10, 0]
|
||
19:50:50 - article_server - INFO - [SQL结果] 查询完成，返回 9 条记录
|
||
19:50:50 - article_server - INFO - [获取企业列表] 查询成功, 总数: 9, 当前页: 1, 每页: 10, 返回数量: 9, IP: 104.244.91.212
|
||
19:50:50 - article_server - INFO - [API响应] GET /api/enterprises/list - IP: 104.244.91.212 - 状态码: 200
|
||
19:50:53 - article_server - INFO - [API访问] DELETE /api/enterprises/4 - IP: 104.244.91.212 - User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/143.0.0.0 Sa
|
||
19:50:53 - article_server - INFO - [Token验证成功] 用户ID: 10
|
||
19:50:53 - article_server - INFO - [SQL执行] 开始执行查询SQL
|
||
19:50:53 - article_server - INFO - [SQL语句] SELECT id, name FROM ai_enterprises WHERE id = %s
|
||
19:50:53 - article_server - INFO - [SQL参数] (4,)
|
||
19:50:53 - article_server - INFO - [SQL结果] 查询完成，返回 1 条记录
|
||
19:50:53 - article_server - INFO - [SQL数据] 查询结果: [{'id': 4, 'name': '测试企业4号'}]
|
||
19:50:53 - article_server - INFO - [SQL执行] 开始执行更新SQL
|
||
19:50:53 - article_server - INFO - [SQL语句] DELETE FROM ai_enterprises WHERE id = %s
|
||
19:50:53 - article_server - INFO - [SQL参数] (4,)
|
||
19:50:53 - article_server - INFO - [SQL结果] 更新完成，影响 1 行
|
||
19:50:53 - article_server - INFO - 删除企业成功: 测试企业4号
|
||
19:50:53 - article_server - INFO - [SQL执行] 开始执行插入SQL
|
||
19:50:53 - 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())
|
||
|
||
19:50:53 - article_server - INFO - [SQL参数] (10, 'delete_enterprise', 'enterprise', 4, '删除企业: 测试企业4号', '104.244.91.212', '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)
|
||
19:50:53 - article_server - INFO - [SQL结果] 插入完成，新记录ID: 64382
|
||
19:50:53 - article_server - INFO - [业务日志] 操作: delete_enterprise | 用户ID: 10 | 目标: enterprise#4 | 状态: success | IP: 104.244.91.212 | 日志ID: 64382
|
||
19:50:53 - article_server - INFO - [API响应] DELETE /api/enterprises/4 - IP: 104.244.91.212 - 状态码: 200
|
||
19:50:53 - article_server - INFO - [API访问] GET /api/enterprises/list - IP: 104.244.91.212 - User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/143.0.0.0 Sa
|
||
19:50:53 - article_server - INFO - [Token验证成功] 用户ID: 10
|
||
19:50:53 - article_server - INFO - [获取企业列表] 开始处理请求, IP: 104.244.91.212
|
||
19:50:53 - article_server - INFO - [获取企业列表] 查询参数: page=1, pageSize=10, keyword=, status=, IP: 104.244.91.212
|
||
19:50:53 - article_server - INFO - [SQL执行] 开始执行查询SQL
|
||
19:50:53 - article_server - INFO - [SQL语句] SELECT COUNT(*) as total FROM ai_enterprises WHERE 1=1
|
||
19:50:53 - article_server - INFO - [SQL结果] 查询完成，返回 1 条记录
|
||
19:50:53 - article_server - INFO - [SQL数据] 查询结果: [{'total': 8}]
|
||
19:50:53 - article_server - INFO - [SQL执行] 开始执行查询SQL
|
||
19:50:53 - article_server - INFO - [SQL语句]
|
||
SELECT id, enterprise_ID, name, short_name, phone, email, status,
|
||
users_total, products_total, articles_total, published_total,
|
||
created_at, updated_at
|
||
FROM ai_enterprises
|
||
WHERE 1=1
|
||
ORDER BY created_at DESC
|
||
LIMIT %s OFFSET %s
|
||
|
||
19:50:53 - article_server - INFO - [SQL参数] [10, 0]
|
||
19:50:54 - article_server - INFO - [SQL结果] 查询完成，返回 8 条记录
|
||
19:50:54 - article_server - INFO - [获取企业列表] 查询成功, 总数: 8, 当前页: 1, 每页: 10, 返回数量: 8, IP: 104.244.91.212
|
||
19:50:54 - article_server - INFO - [API响应] GET /api/enterprises/list - IP: 104.244.91.212 - 状态码: 200
|
||
19:51:24 - article_server - INFO - [API访问] GET /api/employees/list - IP: 104.244.91.212 - User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/143.0.0.0 Sa
|
||
19:51:24 - article_server - INFO - [Token验证成功] 用户ID: 10
|
||
19:51:24 - article_server - INFO - [SQL执行] 开始执行查询SQL
|
||
19:51:24 - article_server - INFO - [SQL语句] SELECT COUNT(*) as total FROM ai_users u WHERE u.enterprise_id = %s AND u.status != 'deleted'
|
||
19:51:24 - article_server - INFO - [SQL参数] [1]
|
||
19:51:24 - article_server - INFO - [SQL结果] 查询完成，返回 1 条记录
|
||
19:51:24 - article_server - INFO - [SQL数据] 查询结果: [{'total': 6}]
|
||
19:51:25 - article_server - INFO - [SQL执行] 开始执行查询SQL
|
||
19:51:25 - article_server - INFO - [SQL语句]
|
||
SELECT u.id, u.enterprise_id, u.real_name as name, u.username, u.phone, u.role, u.department,
|
||
u.is_bound_xhs, a.xhs_account, u.status, u.created_at, u.updated_at
|
||
FROM ai_users u
|
||
LEFT JOIN ai_authors a ON u.id = a.created_user_id AND a.status = 'active'
|
||
WHERE u.enterprise_id = %s AND u.status != 'deleted'
|
||
ORDER BY u.created_at DESC
|
||
LIMIT %s OFFSET %s
|
||
|
||
19:51:25 - article_server - INFO - [SQL参数] [1, 10, 0]
|
||
19:51:25 - article_server - INFO - [SQL结果] 查询完成，返回 6 条记录
|
||
19:51:25 - article_server - INFO - 获取员工列表成功，总数: 6
|
||
19:51:25 - article_server - INFO - [API响应] GET /api/employees/list - IP: 104.244.91.212 - 状态码: 200
|
||
19:51:25 - article_server - INFO - [API访问] GET /api/employees/stats - IP: 104.244.91.212 - User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/143.0.0.0 Sa
|
||
19:51:25 - article_server - INFO - [Token验证成功] 用户ID: 10
|
||
19:51:25 - article_server - INFO - [SQL执行] 开始执行查询SQL
|
||
19:51:25 - 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'
|
||
|
||
19:51:25 - article_server - INFO - [SQL参数] (1,)
|
||
19:51:25 - article_server - INFO - [SQL结果] 查询完成，返回 1 条记录
|
||
19:51:25 - article_server - INFO - [SQL数据] 查询结果: [{'total_count': 6, 'active_count': Decimal('6'), 'bound_xhs_count': Decimal('3')}]
|
||
19:51:25 - article_server - INFO - 获取员工统计成功
|
||
19:51:25 - article_server - INFO - [API响应] GET /api/employees/stats - IP: 104.244.91.212 - 状态码: 200
|
||
19:51:47 - article_server - INFO - [API访问] GET /api/products/list - IP: 104.244.91.212 - User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/143.0.0.0 Sa
|
||
19:51:47 - article_server - INFO - [Token验证成功] 用户ID: 10
|
||
19:51:47 - article_server - INFO - [获取产品列表] 开始处理请求, IP: 104.244.91.212
|
||
19:51:47 - article_server - INFO - [获取产品列表] 用户信息 - 用户ID: 10, 企业ID: 1, IP: 104.244.91.212
|
||
19:51:47 - article_server - INFO - [获取产品列表] 查询参数: page=1, pageSize=12, keyword=, type=, status=, 企业ID: 1, IP: 104.244.91.212
|
||
19:51:47 - article_server - INFO - [API访问] GET /api/products/types/list - IP: 104.244.91.212 - User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/143.0.0.0 Sa
|
||
19:51:47 - article_server - INFO - [Token验证成功] 用户ID: 10
|
||
19:51:47 - article_server - INFO - [获取企业产品类型列表] 开始处理请求, IP: 104.244.91.212
|
||
19:51:47 - article_server - INFO - [获取企业产品类型列表] 企业ID: 1, IP: 104.244.91.212
|
||
19:51:47 - article_server - INFO - [SQL执行] 开始执行查询SQL
|
||
19:51:47 - article_server - INFO - [SQL语句] SELECT COUNT(*) as total FROM ai_products WHERE enterprise_id = %s AND status != 'deleted'
|
||
19:51:47 - article_server - INFO - [SQL参数] [1]
|
||
19:51:47 - article_server - INFO - [SQL执行] 开始执行查询SQL
|
||
19:51:47 - article_server - INFO - [SQL语句] SELECT COUNT(*) as total FROM ai_product_types WHERE enterprise_id = %s
|
||
19:51:47 - article_server - INFO - [SQL参数] [1]
|
||
19:51:47 - article_server - INFO - [SQL结果] 查询完成，返回 1 条记录
|
||
19:51:47 - article_server - INFO - [SQL数据] 查询结果: [{'total': 5}]
|
||
19:51:47 - article_server - INFO - [SQL结果] 查询完成，返回 1 条记录
|
||
19:51:47 - article_server - INFO - [SQL数据] 查询结果: [{'total': 0}]
|
||
19:51:47 - article_server - INFO - [SQL执行] 开始执行查询SQL
|
||
19:51:47 - 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
|
||
|
||
19:51:47 - article_server - INFO - [SQL参数] [1, 12, 0]
|
||
19:51:47 - article_server - INFO - [SQL执行] 开始执行查询SQL
|
||
19:51:47 - 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
|
||
|
||
19:51:47 - article_server - INFO - [SQL参数] [1, 100, 0]
|
||
19:51:47 - article_server - INFO - [SQL结果] 查询完成，返回 5 条记录
|
||
19:51:47 - article_server - INFO - [SQL结果] 查询完成，返回 0 条记录
|
||
19:51:47 - article_server - INFO - [SQL执行] 开始执行查询SQL
|
||
19:51:47 - article_server - INFO - [SQL语句]
|
||
SELECT id, tag_name
|
||
FROM ai_product_tags
|
||
WHERE product_id = %s
|
||
|
||
19:51:47 - article_server - INFO - [SQL参数] (25,)
|
||
19:51:47 - article_server - INFO - [获取企业产品类型列表] 查询成功, 企业ID: 1, 总数: 0, 返回: 0, IP: 104.244.91.212
|
||
19:51:47 - article_server - INFO - [API响应] GET /api/products/types/list - IP: 104.244.91.212 - 状态码: 200
|
||
19:51:47 - article_server - INFO - [SQL结果] 查询完成，返回 0 条记录
|
||
19:51:47 - article_server - INFO - [SQL执行] 开始执行查询SQL
|
||
19:51:47 - article_server - INFO - [SQL语句]
|
||
SELECT id, tag_name
|
||
FROM ai_product_tags
|
||
WHERE product_id = %s
|
||
|
||
19:51:47 - article_server - INFO - [SQL参数] (13,)
|
||
19:51:47 - article_server - INFO - [SQL结果] 查询完成，返回 0 条记录
|
||
19:51:47 - article_server - INFO - [SQL执行] 开始执行查询SQL
|
||
19:51:47 - article_server - INFO - [SQL语句]
|
||
SELECT id, tag_name
|
||
FROM ai_product_tags
|
||
WHERE product_id = %s
|
||
|
||
19:51:47 - article_server - INFO - [SQL参数] (12,)
|
||
19:51:47 - article_server - INFO - [SQL结果] 查询完成，返回 0 条记录
|
||
19:51:47 - article_server - INFO - [SQL执行] 开始执行查询SQL
|
||
19:51:47 - article_server - INFO - [SQL语句]
|
||
SELECT id, tag_name
|
||
FROM ai_product_tags
|
||
WHERE product_id = %s
|
||
|
||
19:51:47 - article_server - INFO - [SQL参数] (11,)
|
||
19:51:47 - article_server - INFO - [SQL结果] 查询完成，返回 0 条记录
|
||
19:51:47 - article_server - INFO - [SQL执行] 开始执行查询SQL
|
||
19:51:47 - article_server - INFO - [SQL语句]
|
||
SELECT id, tag_name
|
||
FROM ai_product_tags
|
||
WHERE product_id = %s
|
||
|
||
19:51:47 - article_server - INFO - [SQL参数] (1,)
|
||
19:51:47 - article_server - INFO - [SQL结果] 查询完成，返回 1 条记录
|
||
19:51:47 - article_server - INFO - [SQL数据] 查询结果: [{'id': 1, 'tag_name': '保湿'}]
|
||
19:51:47 - article_server - INFO - [获取产品列表] 查询成功, 总数: 5, 当前页: 1, 每页: 12, 返回数量: 5, 企业ID: 1, IP: 104.244.91.212
|
||
19:51:47 - article_server - INFO - [API响应] GET /api/products/list - IP: 104.244.91.212 - 状态码: 200
|
||
19:51:52 - article_server - INFO - [API访问] DELETE /api/products/12 - IP: 104.244.91.212 - User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/143.0.0.0 Sa
|
||
19:51:52 - article_server - INFO - [Token验证成功] 用户ID: 10
|
||
19:51:52 - article_server - INFO - [SQL执行] 开始执行查询SQL
|
||
19:51:52 - article_server - INFO - [SQL语句] SELECT id, name FROM ai_products WHERE id = %s AND enterprise_id = %s AND status != 'deleted'
|
||
19:51:52 - article_server - INFO - [SQL参数] (12, 1)
|
||
19:51:52 - article_server - INFO - [SQL结果] 查询完成，返回 1 条记录
|
||
19:51:52 - article_server - INFO - [SQL数据] 查询结果: [{'id': 12, 'name': '测试产品'}]
|
||
19:51:52 - article_server - INFO - [SQL执行] 开始执行更新SQL
|
||
19:51:52 - article_server - INFO - [SQL语句] UPDATE ai_products SET status = 'deleted', updated_at = NOW() WHERE id = %s
|
||
19:51:52 - article_server - INFO - [SQL参数] (12,)
|
||
19:51:53 - article_server - INFO - [SQL结果] 更新完成，影响 1 行
|
||
19:51:53 - article_server - INFO - [SQL执行] 开始执行更新SQL
|
||
19:51:53 - article_server - INFO - [SQL语句] UPDATE ai_enterprises SET products_total = products_total - 1 WHERE id = %s
|
||
19:51:53 - article_server - INFO - [SQL参数] (1,)
|
||
19:51:53 - article_server - INFO - [SQL结果] 更新完成，影响 1 行
|
||
19:51:53 - article_server - INFO - 删除产品成功: 测试产品
|
||
19:51:53 - article_server - INFO - [SQL执行] 开始执行插入SQL
|
||
19:51:53 - 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())
|
||
|
||
19:51:53 - article_server - INFO - [SQL参数] (10, 'delete_product', 'product', 12, '删除产品: 测试产品', '104.244.91.212', '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)
|
||
19:51:53 - article_server - INFO - [SQL结果] 插入完成，新记录ID: 64405
|
||
19:51:53 - article_server - INFO - [业务日志] 操作: delete_product | 用户ID: 10 | 目标: product#12 | 状态: success | IP: 104.244.91.212 | 日志ID: 64405
|
||
19:51:53 - article_server - INFO - [API响应] DELETE /api/products/12 - IP: 104.244.91.212 - 状态码: 200
|
||
19:51:54 - article_server - INFO - [API访问] GET /api/products/list - IP: 104.244.91.212 - User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/143.0.0.0 Sa
|
||
19:51:54 - article_server - INFO - [Token验证成功] 用户ID: 10
|
||
19:51:54 - article_server - INFO - [获取产品列表] 开始处理请求, IP: 104.244.91.212
|
||
19:51:54 - article_server - INFO - [获取产品列表] 用户信息 - 用户ID: 10, 企业ID: 1, IP: 104.244.91.212
|
||
19:51:54 - article_server - INFO - [获取产品列表] 查询参数: page=1, pageSize=12, keyword=, type=, status=, 企业ID: 1, IP: 104.244.91.212
|
||
19:51:54 - article_server - INFO - [SQL执行] 开始执行查询SQL
|
||
19:51:54 - article_server - INFO - [SQL语句] SELECT COUNT(*) as total FROM ai_products WHERE enterprise_id = %s AND status != 'deleted'
|
||
19:51:54 - article_server - INFO - [SQL参数] [1]
|
||
19:51:54 - article_server - INFO - [SQL结果] 查询完成，返回 1 条记录
|
||
19:51:54 - article_server - INFO - [SQL数据] 查询结果: [{'total': 4}]
|
||
19:51:54 - article_server - INFO - [SQL执行] 开始执行查询SQL
|
||
19:51:54 - 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
|
||
|
||
19:51:54 - article_server - INFO - [SQL参数] [1, 12, 0]
|
||
19:51:54 - article_server - INFO - [SQL结果] 查询完成，返回 4 条记录
|
||
19:51:54 - article_server - INFO - [SQL执行] 开始执行查询SQL
|
||
19:51:54 - article_server - INFO - [SQL语句]
|
||
SELECT id, tag_name
|
||
FROM ai_product_tags
|
||
WHERE product_id = %s
|
||
|
||
19:51:54 - article_server - INFO - [SQL参数] (25,)
|
||
19:51:54 - article_server - INFO - [SQL结果] 查询完成，返回 0 条记录
|
||
19:51:54 - article_server - INFO - [SQL执行] 开始执行查询SQL
|
||
19:51:54 - article_server - INFO - [SQL语句]
|
||
SELECT id, tag_name
|
||
FROM ai_product_tags
|
||
WHERE product_id = %s
|
||
|
||
19:51:54 - article_server - INFO - [SQL参数] (13,)
|
||
19:51:54 - article_server - INFO - [SQL结果] 查询完成，返回 0 条记录
|
||
19:51:54 - article_server - INFO - [SQL执行] 开始执行查询SQL
|
||
19:51:54 - article_server - INFO - [SQL语句]
|
||
SELECT id, tag_name
|
||
FROM ai_product_tags
|
||
WHERE product_id = %s
|
||
|
||
19:51:54 - article_server - INFO - [SQL参数] (11,)
|
||
19:51:54 - article_server - INFO - [SQL结果] 查询完成，返回 0 条记录
|
||
19:51:54 - article_server - INFO - [SQL执行] 开始执行查询SQL
|
||
19:51:54 - article_server - INFO - [SQL语句]
|
||
SELECT id, tag_name
|
||
FROM ai_product_tags
|
||
WHERE product_id = %s
|
||
|
||
19:51:54 - article_server - INFO - [SQL参数] (1,)
|
||
19:51:54 - article_server - INFO - [SQL结果] 查询完成，返回 1 条记录
|
||
19:51:54 - article_server - INFO - [SQL数据] 查询结果: [{'id': 1, 'tag_name': '保湿'}]
|
||
19:51:54 - article_server - INFO - [获取产品列表] 查询成功, 总数: 4, 当前页: 1, 每页: 12, 返回数量: 4, 企业ID: 1, IP: 104.244.91.212
|
||
19:51:54 - article_server - INFO - [API响应] GET /api/products/list - IP: 104.244.91.212 - 状态码: 200
|
||
19:51:57 - article_server - INFO - [API访问] DELETE /api/products/11 - IP: 104.244.91.212 - User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/143.0.0.0 Sa
|
||
19:51:57 - article_server - INFO - [Token验证成功] 用户ID: 10
|
||
19:51:57 - article_server - INFO - [SQL执行] 开始执行查询SQL
|
||
19:51:57 - article_server - INFO - [SQL语句] SELECT id, name FROM ai_products WHERE id = %s AND enterprise_id = %s AND status != 'deleted'
|
||
19:51:57 - article_server - INFO - [SQL参数] (11, 1)
|
||
19:51:57 - article_server - INFO - [SQL结果] 查询完成，返回 1 条记录
|
||
19:51:57 - article_server - INFO - [SQL数据] 查询结果: [{'id': 11, 'name': '测试产品'}]
|
||
19:51:57 - article_server - INFO - [SQL执行] 开始执行更新SQL
|
||
19:51:57 - article_server - INFO - [SQL语句] UPDATE ai_products SET status = 'deleted', updated_at = NOW() WHERE id = %s
|
||
19:51:57 - article_server - INFO - [SQL参数] (11,)
|
||
19:51:57 - article_server - INFO - [SQL结果] 更新完成，影响 1 行
|
||
19:51:57 - article_server - INFO - [SQL执行] 开始执行更新SQL
|
||
19:51:57 - article_server - INFO - [SQL语句] UPDATE ai_enterprises SET products_total = products_total - 1 WHERE id = %s
|
||
19:51:57 - article_server - INFO - [SQL参数] (1,)
|
||
19:51:57 - article_server - INFO - [SQL结果] 更新完成，影响 1 行
|
||
19:51:57 - article_server - INFO - 删除产品成功: 测试产品
|
||
19:51:57 - article_server - INFO - [SQL执行] 开始执行插入SQL
|
||
19:51:57 - 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())
|
||
|
||
19:51:57 - article_server - INFO - [SQL参数] (10, 'delete_product', 'product', 11, '删除产品: 测试产品', '104.244.91.212', '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)
|
||
19:51:57 - article_server - INFO - [SQL结果] 插入完成，新记录ID: 64408
|
||
19:51:57 - article_server - INFO - [业务日志] 操作: delete_product | 用户ID: 10 | 目标: product#11 | 状态: success | IP: 104.244.91.212 | 日志ID: 64408
|
||
19:51:57 - article_server - INFO - [API响应] DELETE /api/products/11 - IP: 104.244.91.212 - 状态码: 200
|
||
19:51:58 - article_server - INFO - [API访问] GET /api/products/list - IP: 104.244.91.212 - User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/143.0.0.0 Sa
|
||
19:51:58 - article_server - INFO - [Token验证成功] 用户ID: 10
|
||
19:51:58 - article_server - INFO - [获取产品列表] 开始处理请求, IP: 104.244.91.212
|
||
19:51:58 - article_server - INFO - [获取产品列表] 用户信息 - 用户ID: 10, 企业ID: 1, IP: 104.244.91.212
|
||
19:51:58 - article_server - INFO - [获取产品列表] 查询参数: page=1, pageSize=12, keyword=, type=, status=, 企业ID: 1, IP: 104.244.91.212
|
||
19:51:58 - article_server - INFO - [SQL执行] 开始执行查询SQL
|
||
19:51:58 - article_server - INFO - [SQL语句] SELECT COUNT(*) as total FROM ai_products WHERE enterprise_id = %s AND status != 'deleted'
|
||
19:51:58 - article_server - INFO - [SQL参数] [1]
|
||
19:51:58 - article_server - INFO - [SQL结果] 查询完成，返回 1 条记录
|
||
19:51:58 - article_server - INFO - [SQL数据] 查询结果: [{'total': 3}]
|
||
19:51:58 - article_server - INFO - [SQL执行] 开始执行查询SQL
|
||
19:51:58 - 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
|
||
|
||
19:51:58 - article_server - INFO - [SQL参数] [1, 12, 0]
|
||
19:51:58 - article_server - INFO - [SQL结果] 查询完成，返回 3 条记录
|
||
19:51:58 - article_server - INFO - [SQL数据] 查询结果: [{'id': 25, 'name': '健康类自媒体', 'type_name': '护肤品', 'knowledge': '健康类自媒体，健康类自媒体', 'status': 'active', 'articles_total': 28, 'published_total': 0, 'image_url': 'https://pic2.zhimg.com/v2-f2baf85af5f74f1371afbd41f8f42651_r.jpg', 'image_thumbnail_url': '', 'created_at': datetime.datetime(2025, 12, 16, 13, 58, 2), 'updated_at': datetime.datetime(2025, 12, 21, 7, 59, 16)}, {'id': 13, 'name': '测试产品', 'type_name': '1', 'knowledge': '这是一个测试产品，用于API测试', 'status': 'active', 'articles_total': 11, 'published_total': 0, 'image_url': '', 'image_thumbnail_url': '', 'created_at': datetime.datetime(2025, 12, 12, 17, 43, 30), 'updated_at': datetime.datetime(2025, 12, 12, 20, 53, 25)}, {'id': 1, 'name': '美白面膜1', 'type_name': '护肤品', 'knowledge': '产品名称: 美白面膜\n产品特点: 温和不刺激,适合各种肤质使用\n主要成分: 天然植物萃取,添加多种维生素和矿物质', 'status': 'active', 'articles_total': 1, 'published_total': 0, 'image_url': '', 'image_thumbnail_url': '', 'created_at': datetime.datetime(2025, 12, 12, 16, 58, 22), 'updated_at': datetime.datetime(2025, 12, 18, 13, 5, 42)}]
|
||
19:51:58 - article_server - INFO - [SQL执行] 开始执行查询SQL
|
||
19:51:58 - article_server - INFO - [SQL语句]
|
||
SELECT id, tag_name
|
||
FROM ai_product_tags
|
||
WHERE product_id = %s
|
||
|
||
19:51:58 - article_server - INFO - [SQL参数] (25,)
|
||
19:51:58 - article_server - INFO - [SQL结果] 查询完成，返回 0 条记录
|
||
19:51:58 - article_server - INFO - [SQL执行] 开始执行查询SQL
|
||
19:51:58 - article_server - INFO - [SQL语句]
|
||
SELECT id, tag_name
|
||
FROM ai_product_tags
|
||
WHERE product_id = %s
|
||
|
||
19:51:58 - article_server - INFO - [SQL参数] (13,)
|
||
19:51:58 - article_server - INFO - [SQL结果] 查询完成，返回 0 条记录
|
||
19:51:58 - article_server - INFO - [SQL执行] 开始执行查询SQL
|
||
19:51:58 - article_server - INFO - [SQL语句]
|
||
SELECT id, tag_name
|
||
FROM ai_product_tags
|
||
WHERE product_id = %s
|
||
|
||
19:51:58 - article_server - INFO - [SQL参数] (1,)
|
||
19:51:58 - article_server - INFO - [SQL结果] 查询完成，返回 1 条记录
|
||
19:51:58 - article_server - INFO - [SQL数据] 查询结果: [{'id': 1, 'tag_name': '保湿'}]
|
||
19:51:58 - article_server - INFO - [获取产品列表] 查询成功, 总数: 3, 当前页: 1, 每页: 12, 返回数量: 3, 企业ID: 1, IP: 104.244.91.212
|
||
19:51:58 - article_server - INFO - [API响应] GET /api/products/list - IP: 104.244.91.212 - 状态码: 200
|
||
19:52:01 - article_server - INFO - [API访问] GET /api/images/list - IP: 104.244.91.212 - User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/143.0.0.0 Sa
|
||
19:52:01 - article_server - INFO - [Token验证成功] 用户ID: 10
|
||
19:52:01 - article_server - INFO - [API访问] GET /api/products/list - IP: 104.244.91.212 - User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/143.0.0.0 Sa
|
||
19:52:01 - article_server - INFO - [Token验证成功] 用户ID: 10
|
||
19:52:01 - article_server - INFO - [获取产品列表] 开始处理请求, IP: 104.244.91.212
|
||
19:52:01 - article_server - INFO - [获取产品列表] 用户信息 - 用户ID: 10, 企业ID: 1, IP: 104.244.91.212
|
||
19:52:01 - article_server - INFO - [获取产品列表] 查询参数: page=1, pageSize=100, keyword=, type=, status=, 企业ID: 1, IP: 104.244.91.212
|
||
19:52:01 - article_server - INFO - [SQL执行] 开始执行查询SQL
|
||
19:52:01 - article_server - INFO - [SQL语句]
|
||
SELECT COUNT(*) as total
|
||
FROM ai_images
|
||
WHERE enterprise_id = %s AND status = %s
|
||
|
||
19:52:01 - article_server - INFO - [SQL参数] [1, 'active']
|
||
19:52:01 - article_server - INFO - [SQL执行] 开始执行查询SQL
|
||
19:52:01 - article_server - INFO - [SQL语句] SELECT COUNT(*) as total FROM ai_products WHERE enterprise_id = %s AND status != 'deleted'
|
||
19:52:01 - article_server - INFO - [SQL参数] [1]
|
||
19:52:01 - article_server - INFO - [SQL结果] 查询完成，返回 1 条记录
|
||
19:52:01 - article_server - INFO - [SQL数据] 查询结果: [{'total': 8}]
|
||
19:52:01 - article_server - INFO - [SQL结果] 查询完成，返回 1 条记录
|
||
19:52:01 - article_server - INFO - [SQL数据] 查询结果: [{'total': 3}]
|
||
19:52:01 - article_server - INFO - [SQL执行] 开始执行查询SQL
|
||
19:52:01 - 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
|
||
|
||
19:52:01 - article_server - INFO - [SQL参数] [1, 'active', 10, 0]
|
||
19:52:01 - article_server - INFO - [SQL执行] 开始执行查询SQL
|
||
19:52:01 - 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
|
||
|
||
19:52:01 - article_server - INFO - [SQL参数] [1, 100, 0]
|
||
19:52:02 - article_server - INFO - [SQL结果] 查询完成，返回 8 条记录
|
||
19:52:02 - article_server - INFO - [SQL结果] 查询完成，返回 3 条记录
|
||
19:52:02 - article_server - INFO - [SQL数据] 查询结果: [{'id': 25, 'name': '健康类自媒体', 'type_name': '护肤品', 'knowledge': '健康类自媒体，健康类自媒体', 'status': 'active', 'articles_total': 28, 'published_total': 0, 'image_url': 'https://pic2.zhimg.com/v2-f2baf85af5f74f1371afbd41f8f42651_r.jpg', 'image_thumbnail_url': '', 'created_at': datetime.datetime(2025, 12, 16, 13, 58, 2), 'updated_at': datetime.datetime(2025, 12, 21, 7, 59, 16)}, {'id': 13, 'name': '测试产品', 'type_name': '1', 'knowledge': '这是一个测试产品，用于API测试', 'status': 'active', 'articles_total': 11, 'published_total': 0, 'image_url': '', 'image_thumbnail_url': '', 'created_at': datetime.datetime(2025, 12, 12, 17, 43, 30), 'updated_at': datetime.datetime(2025, 12, 12, 20, 53, 25)}, {'id': 1, 'name': '美白面膜1', 'type_name': '护肤品', 'knowledge': '产品名称: 美白面膜\n产品特点: 温和不刺激,适合各种肤质使用\n主要成分: 天然植物萃取,添加多种维生素和矿物质', 'status': 'active', 'articles_total': 1, 'published_total': 0, 'image_url': '', 'image_thumbnail_url': '', 'created_at': datetime.datetime(2025, 12, 12, 16, 58, 22), 'updated_at': datetime.datetime(2025, 12, 18, 13, 5, 42)}]
|
||
19:52:02 - article_server - INFO - [SQL执行] 开始执行查询SQL
|
||
19:52:02 - 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
|
||
|
||
19:52:02 - article_server - INFO - [SQL参数] [31, 1]
|
||
19:52:02 - article_server - INFO - [SQL执行] 开始执行查询SQL
|
||
19:52:02 - article_server - INFO - [SQL语句]
|
||
SELECT id, tag_name
|
||
FROM ai_product_tags
|
||
WHERE product_id = %s
|
||
|
||
19:52:02 - article_server - INFO - [SQL参数] (25,)
|
||
19:52:02 - article_server - INFO - [SQL结果] 查询完成，返回 3 条记录
|
||
19:52:02 - article_server - INFO - [SQL数据] 查询结果: [{'tag_id': 9, 'tag_name': '1111111'}, {'tag_id': 10, 'tag_name': '222222222'}, {'tag_id': 11, 'tag_name': '33333333'}]
|
||
19:52:02 - article_server - INFO - [SQL结果] 查询完成，返回 0 条记录
|
||
19:52:02 - article_server - INFO - [SQL执行] 开始执行查询SQL
|
||
19:52:02 - 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
|
||
|
||
19:52:02 - article_server - INFO - [SQL参数] [30, 1]
|
||
19:52:02 - article_server - INFO - [SQL执行] 开始执行查询SQL
|
||
19:52:02 - article_server - INFO - [SQL语句]
|
||
SELECT id, tag_name
|
||
FROM ai_product_tags
|
||
WHERE product_id = %s
|
||
|
||
19:52:02 - article_server - INFO - [SQL参数] (13,)
|
||
19:52:02 - article_server - INFO - [SQL结果] 查询完成，返回 3 条记录
|
||
19:52:02 - article_server - INFO - [SQL数据] 查询结果: [{'tag_id': 9, 'tag_name': '1111111'}, {'tag_id': 10, 'tag_name': '222222222'}, {'tag_id': 11, 'tag_name': '33333333'}]
|
||
19:52:02 - article_server - INFO - [SQL结果] 查询完成，返回 0 条记录
|
||
19:52:02 - article_server - INFO - [SQL执行] 开始执行查询SQL
|
||
19:52:02 - 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
|
||
|
||
19:52:02 - article_server - INFO - [SQL参数] [29, 1]
|
||
19:52:02 - article_server - INFO - [SQL执行] 开始执行查询SQL
|
||
19:52:02 - article_server - INFO - [SQL语句]
|
||
SELECT id, tag_name
|
||
FROM ai_product_tags
|
||
WHERE product_id = %s
|
||
|
||
19:52:02 - article_server - INFO - [SQL参数] (1,)
|
||
19:52:02 - article_server - INFO - [SQL结果] 查询完成，返回 3 条记录
|
||
19:52:02 - article_server - INFO - [SQL数据] 查询结果: [{'tag_id': 9, 'tag_name': '1111111'}, {'tag_id': 10, 'tag_name': '222222222'}, {'tag_id': 11, 'tag_name': '33333333'}]
|
||
19:52:02 - article_server - INFO - [SQL结果] 查询完成，返回 1 条记录
|
||
19:52:02 - article_server - INFO - [SQL数据] 查询结果: [{'id': 1, 'tag_name': '保湿'}]
|
||
19:52:02 - article_server - INFO - [获取产品列表] 查询成功, 总数: 3, 当前页: 1, 每页: 100, 返回数量: 3, 企业ID: 1, IP: 104.244.91.212
|
||
19:52:02 - article_server - INFO - [API响应] GET /api/products/list - IP: 104.244.91.212 - 状态码: 200
|
||
19:52:02 - article_server - INFO - [SQL执行] 开始执行查询SQL
|
||
19:52:02 - 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
|
||
|
||
19:52:02 - article_server - INFO - [SQL参数] [28, 1]
|
||
19:52:02 - article_server - INFO - [SQL结果] 查询完成，返回 3 条记录
|
||
19:52:02 - article_server - INFO - [SQL数据] 查询结果: [{'tag_id': 9, 'tag_name': '1111111'}, {'tag_id': 10, 'tag_name': '222222222'}, {'tag_id': 11, 'tag_name': '33333333'}]
|
||
19:52:02 - article_server - INFO - [SQL执行] 开始执行查询SQL
|
||
19:52:02 - 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
|
||
|
||
19:52:02 - article_server - INFO - [SQL参数] [27, 1]
|
||
19:52:02 - article_server - INFO - [SQL结果] 查询完成，返回 3 条记录
|
||
19:52:02 - article_server - INFO - [SQL数据] 查询结果: [{'tag_id': 9, 'tag_name': '1111111'}, {'tag_id': 10, 'tag_name': '222222222'}, {'tag_id': 11, 'tag_name': '33333333'}]
|
||
19:52:02 - article_server - INFO - [SQL执行] 开始执行查询SQL
|
||
19:52:02 - 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
|
||
|
||
19:52:02 - article_server - INFO - [SQL参数] [26, 1]
|
||
19:52:02 - article_server - INFO - [SQL结果] 查询完成，返回 4 条记录
|
||
19:52:02 - article_server - INFO - [SQL执行] 开始执行查询SQL
|
||
19:52:02 - 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
|
||
|
||
19:52:02 - article_server - INFO - [SQL参数] [25, 1]
|
||
19:52:02 - article_server - INFO - [SQL结果] 查询完成，返回 4 条记录
|
||
19:52:02 - article_server - INFO - [SQL执行] 开始执行查询SQL
|
||
19:52:02 - 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
|
||
|
||
19:52:02 - article_server - INFO - [SQL参数] [24, 1]
|
||
19:52:02 - article_server - INFO - [SQL结果] 查询完成，返回 2 条记录
|
||
19:52:02 - article_server - INFO - [SQL数据] 查询结果: [{'tag_id': 3, 'tag_name': '产品（4）'}, {'tag_id': 4, 'tag_name': '产品（4）3'}]
|
||
19:52:02 - article_server - INFO - 获取图片列表成功，总数: 8
|
||
19:52:02 - article_server - INFO - [API响应] GET /api/images/list - IP: 104.244.91.212 - 状态码: 200
|
||
19:52:03 - article_server - INFO - [API访问] GET /api/images/types/list - IP: 104.244.91.212 - User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/143.0.0.0 Sa
|
||
19:52:03 - article_server - INFO - [Token验证成功] 用户ID: 10
|
||
19:52:03 - article_server - INFO - [获取图片类型列表] current_user: {'user_id': 10, 'username': '13621242430', 'role': 'enterprise', 'enterprise_id': 1, 'exp': 1766403892, 'iat': 1766317492}, enterprise_id: 1
|
||
19:52:03 - article_server - INFO - [SQL执行] 开始执行查询SQL
|
||
19:52:03 - article_server - INFO - [SQL语句] SELECT COUNT(*) as total FROM ai_image_type WHERE enterprise_id = %s
|
||
19:52:03 - article_server - INFO - [SQL参数] [1]
|
||
19:52:03 - article_server - INFO - [SQL结果] 查询完成，返回 1 条记录
|
||
19:52:03 - article_server - INFO - [SQL数据] 查询结果: [{'total': 10}]
|
||
19:52:03 - article_server - INFO - [SQL执行] 开始执行查询SQL
|
||
19:52:03 - article_server - INFO - [SQL语句]
|
||
SELECT id, enterprise_id, type_name, keywords_id, keywords_name,
|
||
department_id, department_name, created_user_id, created_at, updated_at
|
||
FROM ai_image_type
|
||
WHERE enterprise_id = %s
|
||
ORDER BY created_at DESC
|
||
LIMIT %s OFFSET %s
|
||
|
||
19:52:03 - article_server - INFO - [SQL参数] [1, 100, 0]
|
||
19:52:03 - article_server - INFO - [SQL结果] 查询完成，返回 10 条记录
|
||
19:52:03 - article_server - INFO - [API响应] GET /api/images/types/list - IP: 104.244.91.212 - 状态码: 200
|
||
19:52:03 - article_server - INFO - [API访问] GET /api/images/list_dashboard - IP: 104.244.91.212 - User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/143.0.0.0 Sa
|
||
19:52:03 - article_server - INFO - [Token验证成功] 用户ID: 10
|
||
19:52:03 - article_server - INFO - [SQL执行] 开始执行查询SQL
|
||
19:52:03 - article_server - INFO - [SQL语句]
|
||
SELECT COUNT(id) as total
|
||
FROM ai_images
|
||
WHERE enterprise_id = %s AND status = 'active'
|
||
|
||
19:52:03 - article_server - INFO - [SQL参数] [1]
|
||
19:52:03 - article_server - INFO - [SQL结果] 查询完成，返回 1 条记录
|
||
19:52:03 - article_server - INFO - [SQL数据] 查询结果: [{'total': 8}]
|
||
19:52:03 - article_server - INFO - [SQL执行] 开始执行查询SQL
|
||
19:52:03 - article_server - INFO - [SQL语句]
|
||
SELECT COUNT(id) as total
|
||
FROM ai_images
|
||
WHERE enterprise_id = %s AND status = 'active' AND product_id > 0
|
||
|
||
19:52:03 - article_server - INFO - [SQL参数] [1]
|
||
19:52:03 - article_server - INFO - [SQL结果] 查询完成，返回 1 条记录
|
||
19:52:03 - article_server - INFO - [SQL数据] 查询结果: [{'total': 8}]
|
||
19:52:03 - article_server - INFO - [SQL执行] 开始执行查询SQL
|
||
19:52:03 - article_server - INFO - [SQL语句]
|
||
SELECT COUNT(DISTINCT product_id) as total
|
||
FROM ai_images
|
||
WHERE enterprise_id = %s AND status = 'active' AND product_id > 0
|
||
|
||
19:52:03 - article_server - INFO - [SQL参数] [1]
|
||
19:52:03 - article_server - INFO - [SQL结果] 查询完成，返回 1 条记录
|
||
19:52:03 - article_server - INFO - [SQL数据] 查询结果: [{'total': 2}]
|
||
19:52:03 - article_server - INFO - [SQL执行] 开始执行查询SQL
|
||
19:52:03 - article_server - INFO - [SQL语句]
|
||
SELECT COUNT(id) as total
|
||
FROM ai_images
|
||
WHERE enterprise_id = %s AND status = 'active'
|
||
AND image_type_name LIKE %s
|
||
|
||
19:52:03 - article_server - INFO - [SQL参数] [1, '%场景%']
|
||
19:52:03 - article_server - INFO - [SQL结果] 查询完成，返回 1 条记录
|
||
19:52:03 - article_server - INFO - [SQL数据] 查询结果: [{'total': 0}]
|
||
19:52:03 - article_server - INFO - 获取图片库仪表盘数据成功，企业ID: 1
|
||
19:52:03 - article_server - INFO - [API响应] GET /api/images/list_dashboard - IP: 104.244.91.212 - 状态码: 200
|
||
19:52:10 - article_server - INFO - [API访问] GET /api/products/types/list - IP: 104.244.91.212 - User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/143.0.0.0 Sa
|
||
19:52:10 - article_server - INFO - [Token验证成功] 用户ID: 10
|
||
19:52:10 - article_server - INFO - [获取企业产品类型列表] 开始处理请求, IP: 104.244.91.212
|
||
19:52:10 - article_server - INFO - [获取企业产品类型列表] 企业ID: 1, IP: 104.244.91.212
|
||
19:52:10 - article_server - INFO - [API访问] GET /api/products/list - IP: 104.244.91.212 - User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/143.0.0.0 Sa
|
||
19:52:10 - article_server - INFO - [Token验证成功] 用户ID: 10
|
||
19:52:10 - article_server - INFO - [获取产品列表] 开始处理请求, IP: 104.244.91.212
|
||
19:52:10 - article_server - INFO - [获取产品列表] 用户信息 - 用户ID: 10, 企业ID: 1, IP: 104.244.91.212
|
||
19:52:10 - article_server - INFO - [获取产品列表] 查询参数: page=1, pageSize=12, keyword=, type=, status=, 企业ID: 1, IP: 104.244.91.212
|
||
19:52:10 - article_server - INFO - [SQL执行] 开始执行查询SQL
|
||
19:52:10 - article_server - INFO - [SQL语句] SELECT COUNT(*) as total FROM ai_product_types WHERE enterprise_id = %s
|
||
19:52:10 - article_server - INFO - [SQL参数] [1]
|
||
19:52:10 - article_server - INFO - [SQL执行] 开始执行查询SQL
|
||
19:52:10 - article_server - INFO - [SQL语句] SELECT COUNT(*) as total FROM ai_products WHERE enterprise_id = %s AND status != 'deleted'
|
||
19:52:10 - article_server - INFO - [SQL参数] [1]
|
||
19:52:10 - article_server - INFO - [SQL结果] 查询完成，返回 1 条记录
|
||
19:52:10 - article_server - INFO - [SQL数据] 查询结果: [{'total': 3}]
|
||
19:52:10 - article_server - INFO - [SQL结果] 查询完成，返回 1 条记录
|
||
19:52:10 - article_server - INFO - [SQL数据] 查询结果: [{'total': 0}]
|
||
19:52:10 - article_server - INFO - [SQL执行] 开始执行查询SQL
|
||
19:52:10 - 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
|
||
|
||
19:52:10 - article_server - INFO - [SQL参数] [1, 12, 0]
|
||
19:52:10 - article_server - INFO - [SQL结果] 查询完成，返回 3 条记录
|
||
19:52:10 - article_server - INFO - [SQL数据] 查询结果: [{'id': 25, 'name': '健康类自媒体', 'type_name': '护肤品', 'knowledge': '健康类自媒体，健康类自媒体', 'status': 'active', 'articles_total': 28, 'published_total': 0, 'image_url': 'https://pic2.zhimg.com/v2-f2baf85af5f74f1371afbd41f8f42651_r.jpg', 'image_thumbnail_url': '', 'created_at': datetime.datetime(2025, 12, 16, 13, 58, 2), 'updated_at': datetime.datetime(2025, 12, 21, 7, 59, 16)}, {'id': 13, 'name': '测试产品', 'type_name': '1', 'knowledge': '这是一个测试产品，用于API测试', 'status': 'active', 'articles_total': 11, 'published_total': 0, 'image_url': '', 'image_thumbnail_url': '', 'created_at': datetime.datetime(2025, 12, 12, 17, 43, 30), 'updated_at': datetime.datetime(2025, 12, 12, 20, 53, 25)}, {'id': 1, 'name': '美白面膜1', 'type_name': '护肤品', 'knowledge': '产品名称: 美白面膜\n产品特点: 温和不刺激,适合各种肤质使用\n主要成分: 天然植物萃取,添加多种维生素和矿物质', 'status': 'active', 'articles_total': 1, 'published_total': 0, 'image_url': '', 'image_thumbnail_url': '', 'created_at': datetime.datetime(2025, 12, 12, 16, 58, 22), 'updated_at': datetime.datetime(2025, 12, 18, 13, 5, 42)}]
|
||
19:52:10 - article_server - INFO - [SQL执行] 开始执行查询SQL
|
||
19:52:10 - 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
|
||
|
||
19:52:10 - article_server - INFO - [SQL参数] [1, 100, 0]
|
||
19:52:10 - article_server - INFO - [SQL结果] 查询完成，返回 0 条记录
|
||
19:52:10 - article_server - INFO - [SQL执行] 开始执行查询SQL
|
||
19:52:10 - article_server - INFO - [SQL语句]
|
||
SELECT id, tag_name
|
||
FROM ai_product_tags
|
||
WHERE product_id = %s
|
||
|
||
19:52:10 - article_server - INFO - [SQL参数] (25,)
|
||
19:52:10 - article_server - INFO - [SQL结果] 查询完成，返回 0 条记录
|
||
19:52:10 - article_server - INFO - [获取企业产品类型列表] 查询成功, 企业ID: 1, 总数: 0, 返回: 0, IP: 104.244.91.212
|
||
19:52:10 - article_server - INFO - [API响应] GET /api/products/types/list - IP: 104.244.91.212 - 状态码: 200
|
||
19:52:10 - article_server - INFO - [SQL执行] 开始执行查询SQL
|
||
19:52:10 - article_server - INFO - [SQL语句]
|
||
SELECT id, tag_name
|
||
FROM ai_product_tags
|
||
WHERE product_id = %s
|
||
|
||
19:52:10 - article_server - INFO - [SQL参数] (13,)
|
||
19:52:10 - article_server - INFO - [SQL结果] 查询完成，返回 0 条记录
|
||
19:52:11 - article_server - INFO - [SQL执行] 开始执行查询SQL
|
||
19:52:11 - article_server - INFO - [SQL语句]
|
||
SELECT id, tag_name
|
||
FROM ai_product_tags
|
||
WHERE product_id = %s
|
||
|
||
19:52:11 - article_server - INFO - [SQL参数] (1,)
|
||
19:52:11 - article_server - INFO - [SQL结果] 查询完成，返回 1 条记录
|
||
19:52:11 - article_server - INFO - [SQL数据] 查询结果: [{'id': 1, 'tag_name': '保湿'}]
|
||
19:52:11 - article_server - INFO - [获取产品列表] 查询成功, 总数: 3, 当前页: 1, 每页: 12, 返回数量: 3, 企业ID: 1, IP: 104.244.91.212
|
||
19:52:11 - article_server - INFO - [API响应] GET /api/products/list - IP: 104.244.91.212 - 状态码: 200
|
||
19:52:13 - article_server - INFO - [API访问] GET /api/employees/stats - IP: 104.244.91.212 - User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/143.0.0.0 Sa
|
||
19:52:13 - article_server - INFO - [Token验证成功] 用户ID: 10
|
||
19:52:13 - article_server - INFO - [API访问] GET /api/employees/list - IP: 104.244.91.212 - User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/143.0.0.0 Sa
|
||
19:52:13 - article_server - INFO - [Token验证成功] 用户ID: 10
|
||
19:52:13 - article_server - INFO - [SQL执行] 开始执行查询SQL
|
||
19:52:13 - 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'
|
||
|
||
19:52:13 - article_server - INFO - [SQL执行] 开始执行查询SQL
|
||
19:52:13 - article_server - INFO - [SQL参数] (1,)
|
||
19:52:13 - article_server - INFO - [SQL语句] SELECT COUNT(*) as total FROM ai_users u WHERE u.enterprise_id = %s AND u.status != 'deleted'
|
||
19:52:13 - article_server - INFO - [SQL参数] [1]
|
||
19:52:13 - article_server - INFO - [SQL结果] 查询完成，返回 1 条记录
|
||
19:52:13 - article_server - INFO - [SQL数据] 查询结果: [{'total': 6}]
|
||
19:52:13 - article_server - INFO - [SQL结果] 查询完成，返回 1 条记录
|
||
19:52:13 - article_server - INFO - [SQL数据] 查询结果: [{'total_count': 6, 'active_count': Decimal('6'), 'bound_xhs_count': Decimal('3')}]
|
||
19:52:13 - article_server - INFO - 获取员工统计成功
|
||
19:52:13 - article_server - INFO - [API响应] GET /api/employees/stats - IP: 104.244.91.212 - 状态码: 200
|
||
19:52:13 - article_server - INFO - [SQL执行] 开始执行查询SQL
|
||
19:52:13 - article_server - INFO - [SQL语句]
|
||
SELECT u.id, u.enterprise_id, u.real_name as name, u.username, u.phone, u.role, u.department,
|
||
u.is_bound_xhs, a.xhs_account, u.status, u.created_at, u.updated_at
|
||
FROM ai_users u
|
||
LEFT JOIN ai_authors a ON u.id = a.created_user_id AND a.status = 'active'
|
||
WHERE u.enterprise_id = %s AND u.status != 'deleted'
|
||
ORDER BY u.created_at DESC
|
||
LIMIT %s OFFSET %s
|
||
|
||
19:52:13 - article_server - INFO - [SQL参数] [1, 10, 0]
|
||
19:52:13 - article_server - INFO - [SQL结果] 查询完成，返回 6 条记录
|
||
19:52:13 - article_server - INFO - 获取员工列表成功，总数: 6
|
||
19:52:13 - article_server - INFO - [API响应] GET /api/employees/list - IP: 104.244.91.212 - 状态码: 200
|
||
19:52:26 - article_server - INFO - [API访问] GET /api/enterprises/info - IP: 104.244.91.212 - User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/143.0.0.0 Sa
|
||
19:52:26 - article_server - INFO - [Token验证成功] 用户ID: 10
|
||
19:52:26 - article_server - INFO - [SQL执行] 开始执行查询SQL
|
||
19:52:26 - article_server - INFO - [SQL语句]
|
||
SELECT id, enterprise_ID, name, short_name, phone, email, status,
|
||
users_total, products_total, articles_total, published_total,
|
||
created_at, updated_at
|
||
FROM ai_enterprises
|
||
WHERE id = %s
|
||
|
||
19:52:26 - article_server - INFO - [SQL参数] (1,)
|
||
19:52:26 - article_server - INFO - [SQL结果] 查询完成，返回 1 条记录
|
||
19:52:26 - article_server - INFO - [SQL数据] 查询结果: [{'id': 1, 'enterprise_ID': 'ENT-2024-0001', 'name': '乐航', 'short_name': '企业122你们好', 'phone': '13621242430', 'email': 'raowenlong@vizee.cn', 'status': 'active', 'users_total': 3, 'products_total': 0, 'articles_total': 40, 'published_total': 0, 'created_at': datetime.datetime(2025, 12, 12, 16, 58, 22), 'updated_at': datetime.datetime(2025, 12, 21, 11, 51, 57)}]
|
||
19:52:26 - article_server - INFO - 获取企业信息成功（含密码）: ID 1
|
||
19:52:26 - article_server - INFO - [API响应] GET /api/enterprises/info - IP: 104.244.91.212 - 状态码: 200
|
||
19:52:34 - article_server - INFO - [API访问] GET /api/enterprises/list - IP: 104.244.91.212 - User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/143.0.0.0 Sa
|
||
19:52:34 - article_server - INFO - [Token验证成功] 用户ID: 10
|
||
19:52:34 - article_server - INFO - [获取企业列表] 开始处理请求, IP: 104.244.91.212
|
||
19:52:34 - article_server - INFO - [获取企业列表] 查询参数: page=1, pageSize=10, keyword=, status=, IP: 104.244.91.212
|
||
19:52:34 - article_server - INFO - [SQL执行] 开始执行查询SQL
|
||
19:52:34 - article_server - INFO - [SQL语句] SELECT COUNT(*) as total FROM ai_enterprises WHERE 1=1
|
||
19:52:34 - article_server - INFO - [SQL结果] 查询完成，返回 1 条记录
|
||
19:52:34 - article_server - INFO - [SQL数据] 查询结果: [{'total': 8}]
|
||
19:52:34 - article_server - INFO - [SQL执行] 开始执行查询SQL
|
||
19:52:34 - article_server - INFO - [SQL语句]
|
||
SELECT id, enterprise_ID, name, short_name, phone, email, status,
|
||
users_total, products_total, articles_total, published_total,
|
||
created_at, updated_at
|
||
FROM ai_enterprises
|
||
WHERE 1=1
|
||
ORDER BY created_at DESC
|
||
LIMIT %s OFFSET %s
|
||
|
||
19:52:34 - article_server - INFO - [SQL参数] [10, 0]
|
||
19:52:34 - article_server - INFO - [SQL结果] 查询完成，返回 8 条记录
|
||
19:52:34 - article_server - INFO - [获取企业列表] 查询成功, 总数: 8, 当前页: 1, 每页: 10, 返回数量: 8, IP: 104.244.91.212
|
||
19:52:34 - article_server - INFO - [API响应] GET /api/enterprises/list - IP: 104.244.91.212 - 状态码: 200
|
||
19:52:41 - article_server - INFO - [API访问] DELETE /api/enterprises/6 - IP: 104.244.91.212 - User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/143.0.0.0 Sa
|
||
19:52:41 - article_server - INFO - [Token验证成功] 用户ID: 10
|
||
19:52:41 - article_server - INFO - [SQL执行] 开始执行查询SQL
|
||
19:52:41 - article_server - INFO - [SQL语句] SELECT id, name FROM ai_enterprises WHERE id = %s
|
||
19:52:41 - article_server - INFO - [SQL参数] (6,)
|
||
19:52:41 - article_server - INFO - [SQL结果] 查询完成，返回 1 条记录
|
||
19:52:41 - article_server - INFO - [SQL数据] 查询结果: [{'id': 6, 'name': '测试企业6号'}]
|
||
19:52:41 - article_server - INFO - [SQL执行] 开始执行更新SQL
|
||
19:52:41 - article_server - INFO - [SQL语句] DELETE FROM ai_enterprises WHERE id = %s
|
||
19:52:41 - article_server - INFO - [SQL参数] (6,)
|
||
19:52:41 - article_server - INFO - [SQL结果] 更新完成，影响 1 行
|
||
19:52:41 - article_server - INFO - 删除企业成功: 测试企业6号
|
||
19:52:41 - article_server - INFO - [SQL执行] 开始执行插入SQL
|
||
19:52:41 - 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())
|
||
|
||
19:52:41 - article_server - INFO - [SQL参数] (10, 'delete_enterprise', 'enterprise', 6, '删除企业: 测试企业6号', '104.244.91.212', '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)
|
||
19:52:41 - article_server - INFO - [SQL结果] 插入完成，新记录ID: 64427
|
||
19:52:41 - article_server - INFO - [业务日志] 操作: delete_enterprise | 用户ID: 10 | 目标: enterprise#6 | 状态: success | IP: 104.244.91.212 | 日志ID: 64427
|
||
19:52:41 - article_server - INFO - [API响应] DELETE /api/enterprises/6 - IP: 104.244.91.212 - 状态码: 200
|
||
19:52:42 - article_server - INFO - [API访问] GET /api/enterprises/list - IP: 104.244.91.212 - User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/143.0.0.0 Sa
|
||
19:52:42 - article_server - INFO - [Token验证成功] 用户ID: 10
|
||
19:52:42 - article_server - INFO - [获取企业列表] 开始处理请求, IP: 104.244.91.212
|
||
19:52:42 - article_server - INFO - [获取企业列表] 查询参数: page=1, pageSize=10, keyword=, status=, IP: 104.244.91.212
|
||
19:52:42 - article_server - INFO - [SQL执行] 开始执行查询SQL
|
||
19:52:42 - article_server - INFO - [SQL语句] SELECT COUNT(*) as total FROM ai_enterprises WHERE 1=1
|
||
19:52:42 - article_server - INFO - [SQL结果] 查询完成，返回 1 条记录
|
||
19:52:42 - article_server - INFO - [SQL数据] 查询结果: [{'total': 7}]
|
||
19:52:42 - article_server - INFO - [SQL执行] 开始执行查询SQL
|
||
19:52:42 - article_server - INFO - [SQL语句]
|
||
SELECT id, enterprise_ID, name, short_name, phone, email, status,
|
||
users_total, products_total, articles_total, published_total,
|
||
created_at, updated_at
|
||
FROM ai_enterprises
|
||
WHERE 1=1
|
||
ORDER BY created_at DESC
|
||
LIMIT %s OFFSET %s
|
||
|
||
19:52:42 - article_server - INFO - [SQL参数] [10, 0]
|
||
19:52:42 - article_server - INFO - [SQL结果] 查询完成，返回 7 条记录
|
||
19:52:42 - article_server - INFO - [获取企业列表] 查询成功, 总数: 7, 当前页: 1, 每页: 10, 返回数量: 7, IP: 104.244.91.212
|
||
19:52:42 - article_server - INFO - [API响应] GET /api/enterprises/list - IP: 104.244.91.212 - 状态码: 200
|
||
19:52:45 - article_server - INFO - [API访问] DELETE /api/enterprises/2 - IP: 104.244.91.212 - User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/143.0.0.0 Sa
|
||
19:52:45 - article_server - INFO - [Token验证成功] 用户ID: 10
|
||
19:52:45 - article_server - INFO - [SQL执行] 开始执行查询SQL
|
||
19:52:45 - article_server - INFO - [SQL语句] SELECT id, name FROM ai_enterprises WHERE id = %s
|
||
19:52:45 - article_server - INFO - [SQL参数] (2,)
|
||
19:52:45 - article_server - INFO - [SQL结果] 查询完成，返回 1 条记录
|
||
19:52:45 - article_server - INFO - [SQL数据] 查询结果: [{'id': 2, 'name': '测试企业2号'}]
|
||
19:52:45 - article_server - INFO - [SQL执行] 开始执行更新SQL
|
||
19:52:45 - article_server - INFO - [SQL语句] DELETE FROM ai_enterprises WHERE id = %s
|
||
19:52:45 - article_server - INFO - [SQL参数] (2,)
|
||
19:52:45 - article_server - INFO - [SQL结果] 更新完成，影响 1 行
|
||
19:52:45 - article_server - INFO - 删除企业成功: 测试企业2号
|
||
19:52:45 - article_server - INFO - [SQL执行] 开始执行插入SQL
|
||
19:52:45 - 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())
|
||
|
||
19:52:45 - article_server - INFO - [SQL参数] (10, 'delete_enterprise', 'enterprise', 2, '删除企业: 测试企业2号', '104.244.91.212', '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)
|
||
19:52:45 - article_server - INFO - [SQL结果] 插入完成，新记录ID: 64429
|
||
19:52:45 - article_server - INFO - [业务日志] 操作: delete_enterprise | 用户ID: 10 | 目标: enterprise#2 | 状态: success | IP: 104.244.91.212 | 日志ID: 64429
|
||
19:52:45 - article_server - INFO - [API响应] DELETE /api/enterprises/2 - IP: 104.244.91.212 - 状态码: 200
|
||
19:52:46 - article_server - INFO - [API访问] GET /api/enterprises/list - IP: 104.244.91.212 - User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/143.0.0.0 Sa
|
||
19:52:46 - article_server - INFO - [Token验证成功] 用户ID: 10
|
||
19:52:46 - article_server - INFO - [获取企业列表] 开始处理请求, IP: 104.244.91.212
|
||
19:52:46 - article_server - INFO - [获取企业列表] 查询参数: page=1, pageSize=10, keyword=, status=, IP: 104.244.91.212
|
||
19:52:46 - article_server - INFO - [SQL执行] 开始执行查询SQL
|
||
19:52:46 - article_server - INFO - [SQL语句] SELECT COUNT(*) as total FROM ai_enterprises WHERE 1=1
|
||
19:52:46 - article_server - INFO - [SQL结果] 查询完成，返回 1 条记录
|
||
19:52:46 - article_server - INFO - [SQL数据] 查询结果: [{'total': 6}]
|
||
19:52:46 - article_server - INFO - [SQL执行] 开始执行查询SQL
|
||
19:52:46 - article_server - INFO - [SQL语句]
|
||
SELECT id, enterprise_ID, name, short_name, phone, email, status,
|
||
users_total, products_total, articles_total, published_total,
|
||
created_at, updated_at
|
||
FROM ai_enterprises
|
||
WHERE 1=1
|
||
ORDER BY created_at DESC
|
||
LIMIT %s OFFSET %s
|
||
|
||
19:52:46 - article_server - INFO - [SQL参数] [10, 0]
|
||
19:52:46 - article_server - INFO - [SQL结果] 查询完成，返回 6 条记录
|
||
19:52:46 - article_server - INFO - [获取企业列表] 查询成功, 总数: 6, 当前页: 1, 每页: 10, 返回数量: 6, IP: 104.244.91.212
|
||
19:52:46 - article_server - INFO - [API响应] GET /api/enterprises/list - IP: 104.244.91.212 - 状态码: 200
|
||
19:52:50 - article_server - INFO - [API访问] DELETE /api/enterprises/5 - IP: 104.244.91.212 - User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/143.0.0.0 Sa
|
||
19:52:50 - article_server - INFO - [Token验证成功] 用户ID: 10
|
||
19:52:50 - article_server - INFO - [SQL执行] 开始执行查询SQL
|
||
19:52:50 - article_server - INFO - [SQL语句] SELECT id, name FROM ai_enterprises WHERE id = %s
|
||
19:52:50 - article_server - INFO - [SQL参数] (5,)
|
||
19:52:50 - article_server - INFO - [SQL结果] 查询完成，返回 1 条记录
|
||
19:52:50 - article_server - INFO - [SQL数据] 查询结果: [{'id': 5, 'name': '测试企业5号'}]
|
||
19:52:50 - article_server - INFO - [SQL执行] 开始执行更新SQL
|
||
19:52:50 - article_server - INFO - [SQL语句] DELETE FROM ai_enterprises WHERE id = %s
|
||
19:52:50 - article_server - INFO - [SQL参数] (5,)
|
||
19:52:50 - article_server - INFO - [SQL结果] 更新完成，影响 1 行
|
||
19:52:50 - article_server - INFO - 删除企业成功: 测试企业5号
|
||
19:52:50 - article_server - INFO - [SQL执行] 开始执行插入SQL
|
||
19:52: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())
|
||
|
||
19:52:50 - article_server - INFO - [SQL参数] (10, 'delete_enterprise', 'enterprise', 5, '删除企业: 测试企业5号', '104.244.91.212', '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)
|
||
19:52:50 - article_server - INFO - [SQL结果] 插入完成，新记录ID: 64432
|
||
19:52:50 - article_server - INFO - [业务日志] 操作: delete_enterprise | 用户ID: 10 | 目标: enterprise#5 | 状态: success | IP: 104.244.91.212 | 日志ID: 64432
|
||
19:52:50 - article_server - INFO - [API响应] DELETE /api/enterprises/5 - IP: 104.244.91.212 - 状态码: 200
|
||
19:52:51 - article_server - INFO - [API访问] GET /api/enterprises/list - IP: 104.244.91.212 - User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/143.0.0.0 Sa
|
||
19:52:51 - article_server - INFO - [Token验证成功] 用户ID: 10
|
||
19:52:51 - article_server - INFO - [获取企业列表] 开始处理请求, IP: 104.244.91.212
|
||
19:52:51 - article_server - INFO - [获取企业列表] 查询参数: page=1, pageSize=10, keyword=, status=, IP: 104.244.91.212
|
||
19:52:51 - article_server - INFO - [SQL执行] 开始执行查询SQL
|
||
19:52:51 - article_server - INFO - [SQL语句] SELECT COUNT(*) as total FROM ai_enterprises WHERE 1=1
|
||
19:52:51 - article_server - INFO - [SQL结果] 查询完成，返回 1 条记录
|
||
19:52:51 - article_server - INFO - [SQL数据] 查询结果: [{'total': 5}]
|
||
19:52:51 - article_server - INFO - [SQL执行] 开始执行查询SQL
|
||
19:52:51 - article_server - INFO - [SQL语句]
|
||
SELECT id, enterprise_ID, name, short_name, phone, email, status,
|
||
users_total, products_total, articles_total, published_total,
|
||
created_at, updated_at
|
||
FROM ai_enterprises
|
||
WHERE 1=1
|
||
ORDER BY created_at DESC
|
||
LIMIT %s OFFSET %s
|
||
|
||
19:52:51 - article_server - INFO - [SQL参数] [10, 0]
|
||
19:52:51 - article_server - INFO - [SQL结果] 查询完成，返回 5 条记录
|
||
19:52:51 - article_server - INFO - [获取企业列表] 查询成功, 总数: 5, 当前页: 1, 每页: 10, 返回数量: 5, IP: 104.244.91.212
|
||
19:52:51 - article_server - INFO - [API响应] GET /api/enterprises/list - IP: 104.244.91.212 - 状态码: 200
|
||
19:52:59 - article_server - INFO - [API访问] DELETE /api/enterprises/9 - IP: 104.244.91.212 - User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/143.0.0.0 Sa
|
||
19:52:59 - article_server - INFO - [Token验证成功] 用户ID: 10
|
||
19:52:59 - article_server - INFO - [SQL执行] 开始执行查询SQL
|
||
19:52:59 - article_server - INFO - [SQL语句] SELECT id, name FROM ai_enterprises WHERE id = %s
|
||
19:52:59 - article_server - INFO - [SQL参数] (9,)
|
||
19:52:59 - article_server - INFO - [SQL结果] 查询完成，返回 1 条记录
|
||
19:52:59 - article_server - INFO - [SQL数据] 查询结果: [{'id': 9, 'name': '测试企业9号'}]
|
||
19:52:59 - article_server - INFO - [SQL执行] 开始执行更新SQL
|
||
19:52:59 - article_server - INFO - [SQL语句] DELETE FROM ai_enterprises WHERE id = %s
|
||
19:52:59 - article_server - INFO - [SQL参数] (9,)
|
||
19:52:59 - article_server - INFO - [SQL结果] 更新完成，影响 1 行
|
||
19:52:59 - article_server - INFO - 删除企业成功: 测试企业9号
|
||
19:52:59 - article_server - INFO - [SQL执行] 开始执行插入SQL
|
||
19:52:59 - 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())
|
||
|
||
19:52:59 - article_server - INFO - [SQL参数] (10, 'delete_enterprise', 'enterprise', 9, '删除企业: 测试企业9号', '104.244.91.212', '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)
|
||
19:52:59 - article_server - INFO - [SQL结果] 插入完成，新记录ID: 64436
|
||
19:52:59 - article_server - INFO - [业务日志] 操作: delete_enterprise | 用户ID: 10 | 目标: enterprise#9 | 状态: success | IP: 104.244.91.212 | 日志ID: 64436
|
||
19:52:59 - article_server - INFO - [API响应] DELETE /api/enterprises/9 - IP: 104.244.91.212 - 状态码: 200
|
||
19:53:00 - article_server - INFO - [API访问] GET /api/enterprises/list - IP: 104.244.91.212 - User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/143.0.0.0 Sa
|
||
19:53:00 - article_server - INFO - [Token验证成功] 用户ID: 10
|
||
19:53:00 - article_server - INFO - [获取企业列表] 开始处理请求, IP: 104.244.91.212
|
||
19:53:00 - article_server - INFO - [获取企业列表] 查询参数: page=1, pageSize=10, keyword=, status=, IP: 104.244.91.212
|
||
19:53:00 - article_server - INFO - [SQL执行] 开始执行查询SQL
|
||
19:53:00 - article_server - INFO - [SQL语句] SELECT COUNT(*) as total FROM ai_enterprises WHERE 1=1
|
||
19:53:00 - article_server - INFO - [SQL结果] 查询完成，返回 1 条记录
|
||
19:53:00 - article_server - INFO - [SQL数据] 查询结果: [{'total': 4}]
|
||
19:53:01 - article_server - INFO - [SQL执行] 开始执行查询SQL
|
||
19:53:01 - article_server - INFO - [SQL语句]
|
||
SELECT id, enterprise_ID, name, short_name, phone, email, status,
|
||
users_total, products_total, articles_total, published_total,
|
||
created_at, updated_at
|
||
FROM ai_enterprises
|
||
WHERE 1=1
|
||
ORDER BY created_at DESC
|
||
LIMIT %s OFFSET %s
|
||
|
||
19:53:01 - article_server - INFO - [SQL参数] [10, 0]
|
||
19:53:01 - article_server - INFO - [SQL结果] 查询完成，返回 4 条记录
|
||
19:53:01 - article_server - INFO - [获取企业列表] 查询成功, 总数: 4, 当前页: 1, 每页: 10, 返回数量: 4, IP: 104.244.91.212
|
||
19:53:01 - article_server - INFO - [API响应] GET /api/enterprises/list - IP: 104.244.91.212 - 状态码: 200
|
||
19:53:37 - article_server - INFO - [API访问] POST /api/enterprises/create - IP: 104.244.91.212 - User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/143.0.0.0 Sa
|
||
19:53:37 - article_server - INFO - [Token验证成功] 用户ID: 10
|
||
19:53:37 - article_server - INFO - [创建企业] 开始处理创建企业请求, IP: 104.244.91.212
|
||
19:53:37 - article_server - INFO - [创建企业] 收到创建请求, 企业名称: fafdsfadsf, 简称: fasdfdsf, 手机号: 13968016804, IP: 104.244.91.212
|
||
19:53:37 - article_server - INFO - [创建企业] 检查ai_enterprises表手机号是否已存在: 13968016804
|
||
19:53:37 - article_server - INFO - [SQL执行] 开始执行查询SQL
|
||
19:53:37 - article_server - INFO - [SQL语句] SELECT id FROM ai_enterprises WHERE phone = %s
|
||
19:53:37 - article_server - INFO - [SQL参数] ('13968016804',)
|
||
19:53:37 - article_server - INFO - [SQL结果] 查询完成，返回 0 条记录
|
||
19:53:37 - article_server - INFO - [创建企业] 检查ai_users表手机号是否已存在: 13968016804
|
||
19:53:37 - article_server - INFO - [SQL执行] 开始执行查询SQL
|
||
19:53:37 - article_server - INFO - [SQL语句] SELECT id FROM ai_users WHERE phone = %s
|
||
19:53:37 - article_server - INFO - [SQL参数] ('13968016804',)
|
||
19:53:37 - article_server - INFO - [SQL结果] 查询完成，返回 1 条记录
|
||
19:53:37 - article_server - INFO - [SQL数据] 查询结果: [{'id': 22}]
|
||
19:53:37 - article_server - WARNING - [创建企业] ai_users表中手机号已存在: 13968016804, IP: 104.244.91.212
|
||
19:53:37 - article_server - INFO - [API响应] POST /api/enterprises/create - IP: 104.244.91.212 - 状态码: 409
|
||
19:53:47 - article_server - INFO - [API访问] POST /api/enterprises/create - IP: 104.244.91.212 - User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/143.0.0.0 Sa
|
||
19:53:47 - article_server - INFO - [Token验证成功] 用户ID: 10
|
||
19:53:47 - article_server - INFO - [创建企业] 开始处理创建企业请求, IP: 104.244.91.212
|
||
19:53:47 - article_server - INFO - [创建企业] 收到创建请求, 企业名称: fafdsfadsf, 简称: fasdfdsf, 手机号: 13968016804, IP: 104.244.91.212
|
||
19:53:47 - article_server - INFO - [创建企业] 检查ai_enterprises表手机号是否已存在: 13968016804
|
||
19:53:47 - article_server - INFO - [SQL执行] 开始执行查询SQL
|
||
19:53:47 - article_server - INFO - [SQL语句] SELECT id FROM ai_enterprises WHERE phone = %s
|
||
19:53:47 - article_server - INFO - [SQL参数] ('13968016804',)
|
||
19:53:47 - article_server - INFO - [SQL结果] 查询完成，返回 0 条记录
|
||
19:53:47 - article_server - INFO - [创建企业] 检查ai_users表手机号是否已存在: 13968016804
|
||
19:53:48 - article_server - INFO - [SQL执行] 开始执行查询SQL
|
||
19:53:48 - article_server - INFO - [SQL语句] SELECT id FROM ai_users WHERE phone = %s
|
||
19:53:48 - article_server - INFO - [SQL参数] ('13968016804',)
|
||
19:53:48 - article_server - INFO - [SQL结果] 查询完成，返回 1 条记录
|
||
19:53:48 - article_server - INFO - [SQL数据] 查询结果: [{'id': 22}]
|
||
19:53:48 - article_server - WARNING - [创建企业] ai_users表中手机号已存在: 13968016804, IP: 104.244.91.212
|
||
19:53:48 - article_server - INFO - [API响应] POST /api/enterprises/create - IP: 104.244.91.212 - 状态码: 409
|
||
19:54:02 - article_server - INFO - [API访问] POST /api/enterprises/create - IP: 104.244.91.212 - User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/143.0.0.0 Sa
|
||
19:54:02 - article_server - INFO - [Token验证成功] 用户ID: 10
|
||
19:54:02 - article_server - INFO - [创建企业] 开始处理创建企业请求, IP: 104.244.91.212
|
||
19:54:02 - article_server - INFO - [创建企业] 收到创建请求, 企业名称: fafdsfadsf, 简称: fasdfdsf, 手机号: 13968016804, IP: 104.244.91.212
|
||
19:54:02 - article_server - INFO - [创建企业] 检查ai_enterprises表手机号是否已存在: 13968016804
|
||
19:54:03 - article_server - INFO - [SQL执行] 开始执行查询SQL
|
||
19:54:03 - article_server - INFO - [SQL语句] SELECT id FROM ai_enterprises WHERE phone = %s
|
||
19:54:03 - article_server - INFO - [SQL参数] ('13968016804',)
|
||
19:54:03 - article_server - INFO - [SQL结果] 查询完成，返回 0 条记录
|
||
19:54:03 - article_server - INFO - [创建企业] 检查ai_users表手机号是否已存在: 13968016804
|
||
19:54:03 - article_server - INFO - [SQL执行] 开始执行查询SQL
|
||
19:54:03 - article_server - INFO - [SQL语句] SELECT id FROM ai_users WHERE phone = %s
|
||
19:54:03 - article_server - INFO - [SQL参数] ('13968016804',)
|
||
19:54:03 - article_server - INFO - [SQL结果] 查询完成，返回 1 条记录
|
||
19:54:03 - article_server - INFO - [SQL数据] 查询结果: [{'id': 22}]
|
||
19:54:03 - article_server - WARNING - [创建企业] ai_users表中手机号已存在: 13968016804, IP: 104.244.91.212
|
||
19:54:03 - article_server - INFO - [API响应] POST /api/enterprises/create - IP: 104.244.91.212 - 状态码: 409
|
||
21:01:41 - article_server - INFO - [API访问] GET /api/dashboard/overview - IP: 104.244.91.212 - User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/143.0.0.0 Sa
|
||
21:01:41 - article_server - INFO - [Token验证成功] 用户ID: 10
|
||
21:01:41 - article_server - INFO - [SQL执行] 开始执行查询SQL
|
||
21:01:41 - article_server - INFO - [SQL语句]
|
||
SELECT users_total, products_total, articles_total, published_total
|
||
FROM ai_enterprises
|
||
WHERE id = %s
|
||
|
||
21:01:41 - article_server - INFO - [SQL参数] (1,)
|
||
21:01:41 - article_server - INFO - [SQL结果] 查询完成，返回 1 条记录
|
||
21:01:41 - article_server - INFO - [SQL数据] 查询结果: [{'users_total': 3, 'products_total': 0, 'articles_total': 40, 'published_total': 0}]
|
||
21:01:41 - article_server - INFO - [SQL执行] 开始执行查询SQL
|
||
21:01:41 - article_server - INFO - [SQL语句]
|
||
SELECT COUNT(*) as month_published
|
||
FROM ai_article_published_records
|
||
WHERE enterprise_id = %s
|
||
AND YEAR(publish_time) = YEAR(CURDATE())
|
||
AND MONTH(publish_time) = MONTH(CURDATE())
|
||
|
||
21:01:41 - article_server - INFO - [SQL参数] (1,)
|
||
21:01:41 - article_server - INFO - [SQL结果] 查询完成，返回 1 条记录
|
||
21:01:41 - article_server - INFO - [SQL数据] 查询结果: [{'month_published': 4}]
|
||
21:01:41 - article_server - INFO - [SQL执行] 开始执行查询SQL
|
||
21:01:41 - article_server - INFO - [SQL语句]
|
||
SELECT COUNT(*) as last_month_published
|
||
FROM ai_article_published_records
|
||
WHERE enterprise_id = %s
|
||
AND YEAR(publish_time) = YEAR(DATE_SUB(CURDATE(), INTERVAL 1 MONTH))
|
||
AND MONTH(publish_time) = MONTH(DATE_SUB(CURDATE(), INTERVAL 1 MONTH))
|
||
|
||
21:01:41 - article_server - INFO - [SQL参数] (1,)
|
||
21:01:41 - article_server - INFO - [SQL结果] 查询完成，返回 1 条记录
|
||
21:01:41 - article_server - INFO - [SQL数据] 查询结果: [{'last_month_published': 0}]
|
||
21:01:41 - article_server - INFO - 获取工作台概览成功
|
||
21:01:41 - article_server - INFO - [API响应] GET /api/dashboard/overview - IP: 104.244.91.212 - 状态码: 200
|
||
21:01:41 - article_server - INFO - [API访问] GET /api/dashboard/recent-publishes - IP: 104.244.91.212 - User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/143.0.0.0 Sa
|
||
21:01:41 - article_server - INFO - [Token验证成功] 用户ID: 10
|
||
21:01:41 - article_server - INFO - [SQL执行] 开始执行查询SQL
|
||
21:01:41 - article_server - INFO - [SQL语句]
|
||
SELECT r.id, r.publish_time,
|
||
u.real_name as employee_name,
|
||
p.name as product_name,
|
||
'success' as status
|
||
FROM ai_article_published_records r
|
||
LEFT JOIN ai_users u ON r.created_user_id = u.id
|
||
LEFT JOIN ai_products p ON r.product_id = p.id
|
||
WHERE r.enterprise_id = %s
|
||
ORDER BY r.publish_time DESC
|
||
LIMIT %s
|
||
|
||
21:01:41 - article_server - INFO - [SQL参数] (1, 5)
|
||
21:01:41 - article_server - INFO - [SQL结果] 查询完成，返回 4 条记录
|
||
21:01:41 - article_server - INFO - 获取最近发布成功
|
||
21:01:41 - article_server - INFO - [API响应] GET /api/dashboard/recent-publishes - IP: 104.244.91.212 - 状态码: 200
|
||
21:01:42 - article_server - INFO - [API访问] GET /api/dashboard/hot-products - IP: 104.244.91.212 - User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/143.0.0.0 Sa
|
||
21:01:42 - article_server - INFO - [Token验证成功] 用户ID: 10
|
||
21:01:42 - article_server - INFO - [SQL执行] 开始执行查询SQL
|
||
21:01:42 - article_server - INFO - [SQL语句]
|
||
SELECT r.product_id, p.name as product_name,
|
||
COUNT(*) as publishes,
|
||
ROUND(COUNT(*) * 100.0 / (SELECT COUNT(*) FROM ai_article_published_records WHERE enterprise_id = %s), 0) as percentage
|
||
FROM ai_article_published_records r
|
||
LEFT JOIN ai_products p ON r.product_id = p.id
|
||
WHERE r.enterprise_id = %s
|
||
GROUP BY r.product_id, p.name
|
||
ORDER BY publishes DESC
|
||
LIMIT %s
|
||
|
||
21:01:42 - article_server - INFO - [SQL参数] (1, 1, 4)
|
||
21:01:42 - article_server - INFO - [SQL结果] 查询完成，返回 4 条记录
|
||
21:01:42 - article_server - INFO - 获取热门产品成功
|
||
21:01:42 - article_server - INFO - [API响应] GET /api/dashboard/hot-products - IP: 104.244.91.212 - 状态码: 200
|
||
21:01:42 - article_server - INFO - [API访问] GET /api/users/info - IP: 104.244.91.212 - User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/143.0.0.0 Sa
|
||
21:01:42 - article_server - INFO - [Token验证成功] 用户ID: 10
|
||
21:01:42 - article_server - INFO - [获取用户信息] 开始处理请求, IP: 104.244.91.212
|
||
21:01:42 - article_server - INFO - [获取用户信息] 用户ID: 10, action: , IP: 104.244.91.212
|
||
21:01:42 - article_server - INFO - [SQL执行] 开始执行查询SQL
|
||
21:01:42 - article_server - INFO - [SQL语句]
|
||
SELECT id, enterprise_id, enterprise_name, username, real_name, email, phone,
|
||
wechat_openid, wechat_unionid,
|
||
is_bound_xhs, department, role, status, created_at, updated_at
|
||
FROM ai_users u
|
||
WHERE id = %s AND status != 'deleted'
|
||
|
||
21:01:42 - article_server - INFO - [SQL参数] (10,)
|
||
21:01:42 - article_server - INFO - [SQL结果] 查询完成，返回 1 条记录
|
||
21:01:42 - article_server - INFO - [SQL数据] 查询结果: [{'id': 10, 'enterprise_id': 1, 'enterprise_name': '测试企业10号', 'username': '饶文龙', 'real_name': '测试用户10', 'email': None, 'phone': '13621242430', 'wechat_openid': 'ovoJF1z6ejXbXcWUHnvCw5HA0OeA', 'wechat_unionid': None, 'is_bound_xhs': 1, 'department': '运营部', 'role': 'enterprise', 'status': 'active', 'created_at': datetime.datetime(2025, 12, 12, 16, 58, 22), 'updated_at': datetime.datetime(2025, 12, 21, 11, 47, 10)}]
|
||
21:01:42 - article_server - INFO - [SQL执行] 开始执行插入SQL
|
||
21:01:42 - 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:01:42 - article_server - INFO - [SQL参数] (10, 'get_user_info', 'user', 10, '查询用户信息: 饶文龙, action=', '104.244.91.212', '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:01:43 - article_server - INFO - [SQL结果] 插入完成，新记录ID: 66017
|
||
21:01:43 - article_server - INFO - [业务日志] 操作: get_user_info | 用户ID: 10 | 目标: user#10 | 状态: success | IP: 104.244.91.212 | 日志ID: 66017
|
||
21:01:43 - article_server - INFO - [API响应] GET /api/users/info - IP: 104.244.91.212 - 状态码: 200
|
||
21:01:46 - article_server - INFO - [API访问] GET /api/employees/list - IP: 104.244.91.212 - User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/143.0.0.0 Sa
|
||
21:01:46 - article_server - INFO - [Token验证成功] 用户ID: 10
|
||
21:01:46 - article_server - INFO - [API访问] GET /api/employees/stats - IP: 104.244.91.212 - User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/143.0.0.0 Sa
|
||
21:01:46 - article_server - INFO - [Token验证成功] 用户ID: 10
|
||
21:01:46 - article_server - INFO - [SQL执行] 开始执行查询SQL
|
||
21:01:46 - article_server - INFO - [SQL语句] SELECT COUNT(*) as total FROM ai_users u WHERE u.enterprise_id = %s AND u.status != 'deleted'
|
||
21:01:46 - article_server - INFO - [SQL参数] [1]
|
||
21:01:46 - article_server - INFO - [SQL执行] 开始执行查询SQL
|
||
21:01:46 - 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:01:46 - article_server - INFO - [SQL参数] (1,)
|
||
21:01:46 - article_server - INFO - [SQL结果] 查询完成，返回 1 条记录
|
||
21:01:46 - article_server - INFO - [SQL数据] 查询结果: [{'total_count': 6, 'active_count': Decimal('6'), 'bound_xhs_count': Decimal('3')}]
|
||
21:01:46 - article_server - INFO - [SQL结果] 查询完成，返回 1 条记录
|
||
21:01:46 - article_server - INFO - [SQL数据] 查询结果: [{'total': 6}]
|
||
21:01:46 - article_server - INFO - 获取员工统计成功
|
||
21:01:46 - article_server - INFO - [API响应] GET /api/employees/stats - IP: 104.244.91.212 - 状态码: 200
|
||
21:01:46 - article_server - INFO - [SQL执行] 开始执行查询SQL
|
||
21:01:46 - article_server - INFO - [SQL语句]
|
||
SELECT u.id, u.enterprise_id, u.real_name as name, u.username, u.phone, u.role, u.department,
|
||
u.is_bound_xhs, a.xhs_account, u.status, u.created_at, u.updated_at
|
||
FROM ai_users u
|
||
LEFT JOIN ai_authors a ON u.id = a.created_user_id AND a.status = 'active'
|
||
WHERE u.enterprise_id = %s AND u.status != 'deleted'
|
||
ORDER BY u.created_at DESC
|
||
LIMIT %s OFFSET %s
|
||
|
||
21:01:46 - article_server - INFO - [SQL参数] [1, 10, 0]
|
||
21:01:46 - article_server - INFO - [SQL结果] 查询完成，返回 6 条记录
|
||
21:01:46 - article_server - INFO - 获取员工列表成功，总数: 6
|
||
21:01:46 - article_server - INFO - [API响应] GET /api/employees/list - IP: 104.244.91.212 - 状态码: 200
|
||
21:02:03 - article_server - INFO - [API访问] POST /api/users/add_employees - IP: 104.244.91.212 - User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/143.0.0.0 Sa
|
||
21:02:03 - article_server - INFO - [Token验证成功] 用户ID: 10
|
||
21:02:03 - article_server - INFO - [SQL执行] 开始执行查询SQL
|
||
21:02:03 - article_server - INFO - [SQL语句] SELECT id FROM ai_users WHERE phone = %s AND enterprise_id = %s
|
||
21:02:03 - article_server - INFO - [SQL参数] ('15707023967', 1)
|
||
21:02:03 - article_server - INFO - [SQL结果] 查询完成，返回 1 条记录
|
||
21:02:03 - article_server - INFO - [SQL数据] 查询结果: [{'id': 18}]
|
||
21:02:03 - article_server - INFO - [API响应] POST /api/users/add_employees - IP: 104.244.91.212 - 状态码: 409
|
||
21:02:38 - article_server - INFO - [API访问] GET /api/employees/stats - IP: 104.244.91.212 - User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/143.0.0.0 Sa
|
||
21:02:38 - article_server - INFO - [Token验证成功] 用户ID: 10
|
||
21:02:38 - article_server - INFO - [API访问] GET /api/employees/list - IP: 104.244.91.212 - User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/143.0.0.0 Sa
|
||
21:02:38 - article_server - INFO - [Token验证成功] 用户ID: 10
|
||
21:02:38 - article_server - INFO - [SQL执行] 开始执行查询SQL
|
||
21:02:38 - 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:02:38 - article_server - INFO - [SQL参数] (1,)
|
||
21:02:38 - article_server - INFO - [SQL执行] 开始执行查询SQL
|
||
21:02:38 - article_server - INFO - [SQL语句] SELECT COUNT(*) as total FROM ai_users u WHERE u.enterprise_id = %s AND u.status != 'deleted'
|
||
21:02:38 - article_server - INFO - [SQL参数] [1]
|
||
21:02:38 - article_server - INFO - [API访问] GET /api/users/info - IP: 104.244.91.212 - User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/143.0.0.0 Sa
|
||
21:02:38 - article_server - INFO - [Token验证成功] 用户ID: 10
|
||
21:02:38 - article_server - INFO - [获取用户信息] 开始处理请求, IP: 104.244.91.212
|
||
21:02:38 - article_server - INFO - [获取用户信息] 用户ID: 10, action: , IP: 104.244.91.212
|
||
21:02:38 - article_server - INFO - [SQL结果] 查询完成，返回 1 条记录
|
||
21:02:38 - article_server - INFO - [SQL数据] 查询结果: [{'total_count': 7, 'active_count': Decimal('7'), 'bound_xhs_count': Decimal('4')}]
|
||
21:02:38 - article_server - INFO - [SQL结果] 查询完成，返回 1 条记录
|
||
21:02:38 - article_server - INFO - [SQL数据] 查询结果: [{'total': 7}]
|
||
21:02:38 - article_server - INFO - [SQL执行] 开始执行查询SQL
|
||
21:02:38 - article_server - INFO - [SQL语句]
|
||
SELECT id, enterprise_id, enterprise_name, username, real_name, email, phone,
|
||
wechat_openid, wechat_unionid,
|
||
is_bound_xhs, department, role, status, created_at, updated_at
|
||
FROM ai_users u
|
||
WHERE id = %s AND status != 'deleted'
|
||
|
||
21:02:38 - article_server - INFO - [SQL参数] (10,)
|
||
21:02:38 - article_server - INFO - 获取员工统计成功
|
||
21:02:38 - article_server - INFO - [API响应] GET /api/employees/stats - IP: 104.244.91.212 - 状态码: 200
|
||
21:02:38 - article_server - INFO - [SQL结果] 查询完成，返回 1 条记录
|
||
21:02:38 - article_server - INFO - [SQL数据] 查询结果: [{'id': 10, 'enterprise_id': 1, 'enterprise_name': '测试企业10号', 'username': '饶文龙', 'real_name': '测试用户10', 'email': None, 'phone': '13621242430', 'wechat_openid': 'ovoJF1z6ejXbXcWUHnvCw5HA0OeA', 'wechat_unionid': None, 'is_bound_xhs': 1, 'department': '运营部', 'role': 'enterprise', 'status': 'active', 'created_at': datetime.datetime(2025, 12, 12, 16, 58, 22), 'updated_at': datetime.datetime(2025, 12, 21, 11, 47, 10)}]
|
||
21:02:38 - article_server - INFO - [SQL执行] 开始执行查询SQL
|
||
21:02:38 - article_server - INFO - [SQL语句]
|
||
SELECT u.id, u.enterprise_id, u.real_name as name, u.username, u.phone, u.role, u.department,
|
||
u.is_bound_xhs, a.xhs_account, u.status, u.created_at, u.updated_at
|
||
FROM ai_users u
|
||
LEFT JOIN ai_authors a ON u.id = a.created_user_id AND a.status = 'active'
|
||
WHERE u.enterprise_id = %s AND u.status != 'deleted'
|
||
ORDER BY u.created_at DESC
|
||
LIMIT %s OFFSET %s
|
||
|
||
21:02:38 - article_server - INFO - [SQL参数] [1, 10, 0]
|
||
21:02:38 - article_server - INFO - [SQL结果] 查询完成，返回 7 条记录
|
||
21:02:38 - article_server - INFO - [SQL执行] 开始执行插入SQL
|
||
21:02: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:02:38 - article_server - INFO - [SQL参数] (10, 'get_user_info', 'user', 10, '查询用户信息: 饶文龙, action=', '104.244.91.212', '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:02:38 - article_server - INFO - 获取员工列表成功，总数: 7
|
||
21:02:38 - article_server - INFO - [API响应] GET /api/employees/list - IP: 104.244.91.212 - 状态码: 200
|
||
21:02:38 - article_server - INFO - [SQL结果] 插入完成，新记录ID: 66038
|
||
21:02:38 - article_server - INFO - [业务日志] 操作: get_user_info | 用户ID: 10 | 目标: user#10 | 状态: success | IP: 104.244.91.212 | 日志ID: 66038
|
||
21:02:38 - article_server - INFO - [API响应] GET /api/users/info - IP: 104.244.91.212 - 状态码: 200
|
||
21:04:07 - article_server - INFO - [API访问] GET /api/employees/list - IP: 104.244.91.212 - User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/143.0.0.0 Sa
|
||
21:04:07 - article_server - INFO - [Token验证成功] 用户ID: 10
|
||
21:04:07 - article_server - INFO - [API访问] GET /api/employees/stats - IP: 104.244.91.212 - User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/143.0.0.0 Sa
|
||
21:04:07 - article_server - INFO - [Token验证成功] 用户ID: 10
|
||
21:04:07 - article_server - INFO - [SQL执行] 开始执行查询SQL
|
||
21:04:07 - article_server - INFO - [SQL语句] SELECT COUNT(*) as total FROM ai_users u WHERE u.enterprise_id = %s AND u.status != 'deleted'
|
||
21:04:07 - article_server - INFO - [SQL参数] [1]
|
||
21:04:07 - article_server - INFO - [SQL执行] 开始执行查询SQL
|
||
21:04:07 - 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:04:07 - article_server - INFO - [SQL参数] (1,)
|
||
21:04:07 - article_server - INFO - [SQL结果] 查询完成，返回 1 条记录
|
||
21:04:07 - article_server - INFO - [SQL数据] 查询结果: [{'total': 7}]
|
||
21:04:07 - article_server - INFO - [SQL结果] 查询完成，返回 1 条记录
|
||
21:04:07 - article_server - INFO - [SQL数据] 查询结果: [{'total_count': 7, 'active_count': Decimal('7'), 'bound_xhs_count': Decimal('3')}]
|
||
21:04:07 - article_server - INFO - [SQL执行] 开始执行查询SQL
|
||
21:04:07 - article_server - INFO - [SQL语句]
|
||
SELECT u.id, u.enterprise_id, u.real_name as name, u.username, u.phone, u.role, u.department,
|
||
u.is_bound_xhs, a.xhs_account, u.status, u.created_at, u.updated_at
|
||
FROM ai_users u
|
||
LEFT JOIN ai_authors a ON u.id = a.created_user_id AND a.status = 'active'
|
||
WHERE u.enterprise_id = %s AND u.status != 'deleted'
|
||
ORDER BY u.created_at DESC
|
||
LIMIT %s OFFSET %s
|
||
|
||
21:04:07 - article_server - INFO - [SQL参数] [1, 10, 0]
|
||
21:04:07 - article_server - INFO - 获取员工统计成功
|
||
21:04:07 - article_server - INFO - [API响应] GET /api/employees/stats - IP: 104.244.91.212 - 状态码: 200
|
||
21:04:07 - article_server - INFO - [SQL结果] 查询完成，返回 7 条记录
|
||
21:04:07 - article_server - INFO - 获取员工列表成功，总数: 7
|
||
21:04:07 - article_server - INFO - [API响应] GET /api/employees/list - IP: 104.244.91.212 - 状态码: 200
|
||
21:04:08 - article_server - INFO - [API访问] GET /api/users/info - IP: 104.244.91.212 - User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/143.0.0.0 Sa
|
||
21:04:08 - article_server - INFO - [Token验证成功] 用户ID: 10
|
||
21:04:08 - article_server - INFO - [获取用户信息] 开始处理请求, IP: 104.244.91.212
|
||
21:04:08 - article_server - INFO - [获取用户信息] 用户ID: 10, action: , IP: 104.244.91.212
|
||
21:04:08 - article_server - INFO - [SQL执行] 开始执行查询SQL
|
||
21:04:08 - article_server - INFO - [SQL语句]
|
||
SELECT id, enterprise_id, enterprise_name, username, real_name, email, phone,
|
||
wechat_openid, wechat_unionid,
|
||
is_bound_xhs, department, role, status, created_at, updated_at
|
||
FROM ai_users u
|
||
WHERE id = %s AND status != 'deleted'
|
||
|
||
21:04:08 - article_server - INFO - [SQL参数] (10,)
|
||
21:04:08 - article_server - INFO - [SQL结果] 查询完成，返回 1 条记录
|
||
21:04:08 - article_server - INFO - [SQL数据] 查询结果: [{'id': 10, 'enterprise_id': 1, 'enterprise_name': '测试企业10号', 'username': '饶文龙', 'real_name': '测试用户10', 'email': None, 'phone': '13621242430', 'wechat_openid': 'ovoJF1z6ejXbXcWUHnvCw5HA0OeA', 'wechat_unionid': None, 'is_bound_xhs': 1, 'department': '运营部', 'role': 'enterprise', 'status': 'active', 'created_at': datetime.datetime(2025, 12, 12, 16, 58, 22), 'updated_at': datetime.datetime(2025, 12, 21, 11, 47, 10)}]
|
||
21:04:08 - article_server - INFO - [SQL执行] 开始执行插入SQL
|
||
21:04:08 - 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:04:08 - article_server - INFO - [SQL参数] (10, 'get_user_info', 'user', 10, '查询用户信息: 饶文龙, action=', '104.244.91.212', '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:04:08 - article_server - INFO - [SQL结果] 插入完成，新记录ID: 66074
|
||
21:04:08 - article_server - INFO - [业务日志] 操作: get_user_info | 用户ID: 10 | 目标: user#10 | 状态: success | IP: 104.244.91.212 | 日志ID: 66074
|
||
21:04:08 - article_server - INFO - [API响应] GET /api/users/info - IP: 104.244.91.212 - 状态码: 200
|