根据业务情况设置定时脚本的执行频次

 

-- 订单表新生效的url白天多晚上多？
SELECT COUNT(1),FROM_UNIXTIME(create_time,'%H') AS sh FROM order  GROUP BY sh ORDER BY sh DESC ;
-- 订单表新生效的url白天多晚上多--近一周？
SELECT COUNT(1),FROM_UNIXTIME(create_time,'%H') AS sh FROM order WHERE unix_timestamp(now()) - create_time<=3600*24*7 GROUP BY sh ORDER BY sh DESC ;

 

271 23
284 22
828 21
894 20
412 19
3886 18
7768 17
10927 16
9944 15
8765 14
5924 13
2695 12
12779 11
7194 10
8568 09
4974 08
3 00