select created_at from opm_mw_raw_data where 优化 #276

New Issue

2025-12-26T23:46:34+08:00

bigtran commented

2025-12-26 23:46:34 +08:00

√ 第一个要做的事情：把opm_mw_raw_data的数据变成两个表，1个月内的，1个月外的，每天定时清理

要写一个定时程序来清理

第二个要做的事情：opm_mw_raw_data 新插入的数据，要增加对应的列 organ_sign, scode

第三个要做的事情：把硬编码消灭掉

select '两个月内',count(*) from opm_mw_raw_data where created_at >= DATE_SUB(NOW(), INTERVAL 2 MONTH)
union
select '两个月外',count(*) from opm_mw_raw_data where created_at < DATE_SUB(NOW(), INTERVAL 2 MONTH)
union
select '一个月内',count(*) from opm_mw_raw_data where created_at >= DATE_SUB(NOW(), INTERVAL 1 MONTH)
union
select '一个月外',count(*) from opm_mw_raw_data where created_at < DATE_SUB(NOW(), INTERVAL 1 MONTH)
union
select '15天内',count(*) from opm_mw_raw_data where created_at >= DATE_SUB(NOW(), INTERVAL 15 DAY)
union
select '15天外',count(*) from opm_mw_raw_data where created_at < DATE_SUB(NOW(), INTERVAL 15 DAY)
union
select '7天内',count(*) from opm_mw_raw_data where created_at >= DATE_SUB(NOW(), INTERVAL 7 DAY)
union
select '7天外',count(*) from opm_mw_raw_data where created_at < DATE_SUB(NOW(), INTERVAL 7 DAY)
union
select '3天内',count(*) from opm_mw_raw_data where created_at >= DATE_SUB(NOW(), INTERVAL 3 DAY)
union
select '3天外',count(*) from opm_mw_raw_data where created_at < DATE_SUB(NOW(), INTERVAL 3 DAY);

# √ 第一个要做的事情：把opm_mw_raw_data的数据变成两个表，1个月内的，1个月外的，每天定时清理 ## 要写一个定时程序来清理 # 第二个要做的事情：opm_mw_raw_data 新插入的数据，要增加对应的列 organ_sign, scode # 第三个要做的事情：把硬编码消灭掉 ![image.png](/attachments/7257d7fa-a7f1-4810-b3e2-b56da1f65fcd) ``` select '两个月内',count(*) from opm_mw_raw_data where created_at >= DATE_SUB(NOW(), INTERVAL 2 MONTH) union select '两个月外',count(*) from opm_mw_raw_data where created_at < DATE_SUB(NOW(), INTERVAL 2 MONTH) union select '一个月内',count(*) from opm_mw_raw_data where created_at >= DATE_SUB(NOW(), INTERVAL 1 MONTH) union select '一个月外',count(*) from opm_mw_raw_data where created_at < DATE_SUB(NOW(), INTERVAL 1 MONTH) union select '15天内',count(*) from opm_mw_raw_data where created_at >= DATE_SUB(NOW(), INTERVAL 15 DAY) union select '15天外',count(*) from opm_mw_raw_data where created_at < DATE_SUB(NOW(), INTERVAL 15 DAY) union select '7天内',count(*) from opm_mw_raw_data where created_at >= DATE_SUB(NOW(), INTERVAL 7 DAY) union select '7天外',count(*) from opm_mw_raw_data where created_at < DATE_SUB(NOW(), INTERVAL 7 DAY) union select '3天内',count(*) from opm_mw_raw_data where created_at >= DATE_SUB(NOW(), INTERVAL 3 DAY) union select '3天外',count(*) from opm_mw_raw_data where created_at < DATE_SUB(NOW(), INTERVAL 3 DAY); ```

image.png

64 KiB

image.png

69 KiB