【Hive SQL 新算法】求任意时间段连续登录N天用户数/用户明细/最长连续登陆天数/用户留存率问题总结

香山上的麻雀
303 阅读45分钟

注：本计算方法原创来源于：blog.csdn.net/hweinifengk…

在原创的基础上优化的：

建测试表

CREATE TABLE `user_login_table`(	
  `user_id` int COMMENT '用户ID', 	
  `login_date` date COMMENT '登录日期'
)

插入1000条测试数据

  • 数据见文末

计算连续登陆

-- 第二段 根据登陆时间减去排列顺序 得出用户连续登陆的分组
SELECT user_id,date_sub(login_date,rank) as login_group,min(login_date) as start_login_time
    ,max(login_date) as end_login_time,count(1) as continuous_days
FROM (
	-- 第一段首先根据用户分组，登陆时间排序，结果按照登陆时间升序排列
    SELECT DISTINCT user_id,login_date,dense_rank() OVER(PARTITION BY user_id order by login_date) as rank
    FROM tmp.user_login_table ORDER BY user_id,rank
) a
GROUP BY user_id,date_sub(login_date,rank);

计算结果如下： 在这里插入图片描述

这种计算方式有个好处，在这个结果表上再进一步的运算，可以得到任意个时间段内连续登陆的用户数，及用户明细

计算留存率问题

select
first_date,
sum(case when by_day = 0 then 1 else 0 end) day_0,
    sum(case when by_day = 1 then 1 else 0 end) day_1,
    sum(case when by_day = 2 then 1 else 0 end) day_2,
    sum(case when by_day = 3 then 1 else 0 end) day_3,
    sum(case when by_day = 4 then 1 else 0 end) day_4,
    sum(case when by_day = 5 then 1 else 0 end) day_5,
    sum(case when by_day = 6 then 1 else 0 end) day_6,
    sum(case when by_day = 7 then 1 else 0 end) day_7
from(
select
user_id,
login_date,first_date,
datediff(login_date,first_date) by_day
from(
select 
    user_id,
    login_date,min(login_date) over(partition by user_id order by login_date) as first_date
from user_login_table
group by user_id,login_date
) a 
) b
group by first_date;
  • 结果如下： 在这里插入图片描述2022年1月6日14:06:04 补充，这个留存计算有点问题：
select
first_date
,case when '${a}' >= first_date then day_0 else null end as day_0
,case when '${a}' >= date_add(first_date,1) then day_1 else null end as day_1
,case when '${a}' >= date_add(first_date,2) then day_2 else null end as day_2
,case when '${a}' >= date_add(first_date,3) then day_3 else null end as day_3
,case when '${a}' >= date_add(first_date,4) then day_4 else null end as day_4
,case when '${a}' >= date_add(first_date,5) then day_5 else null end as day_5
,case when '${a}' >= date_add(first_date,6) then day_6 else null end as day_6
,case when '${a}' >= date_add(first_date,7) then day_7 else null end as day_7
from(
select
first_date,
sum(case when by_day = 0 then 1 else 0 end) day_0,
    sum(case when by_day = 1 then 1 else 0 end) day_1,
    sum(case when by_day = 2 then 1 else 0 end) day_2,
    sum(case when by_day = 3 then 1 else 0 end) day_3,
    sum(case when by_day = 4 then 1 else 0 end) day_4,
    sum(case when by_day = 5 then 1 else 0 end) day_5,
    sum(case when by_day = 6 then 1 else 0 end) day_6,
    sum(case when by_day = 7 then 1 else 0 end) day_7
from(
select
user_id,
login_date,first_date,
datediff(login_date,first_date) by_day
from(
select 
    user_id,
    login_date,min(login_date) over(partition by user_id order by login_date) as first_date
from user_login_txt
where login_date >= date_sub('${a}',7) and  login_date <= '${a}'
group by user_id,login_date
) a 
) b
group by first_date
) t;

当时间变量为 2021-06-08 时，结果： 当时间变量为 2021-06-09 时，结果： 这个是有明显的问题的，6月2号的留存问题还会变化，这是明显不对的。

测试数据

10003,2021-07-03
10001,2021-07-09
10007,2021-07-09
10012,2021-07-07
10003,2021-07-10
10015,2021-07-06
10008,2021-07-03
10006,2021-06-01
10015,2021-07-05
10018,2021-07-05
10018,2021-07-01
10002,2021-06-03
10006,2021-06-03
10002,2021-06-10
10010,2021-06-05
10015,2021-06-07
10015,2021-07-07
10003,2021-06-01
10010,2021-06-05
10013,2021-06-05
10004,2021-07-09
10016,2021-07-02
10008,2021-06-09
10013,2021-06-08
10007,2021-06-06
10012,2021-07-07
10009,2021-06-03
10010,2021-07-04
10019,2021-06-08
10014,2021-07-09
10014,2021-07-02
10017,2021-07-01
10008,2021-07-02
10004,2021-07-02
10015,2021-07-09
10007,2021-06-06
10004,2021-06-04
10019,2021-06-10
10016,2021-07-08
10000,2021-07-05
10015,2021-06-09
10011,2021-06-04
10020,2021-07-04
10015,2021-06-05
10000,2021-07-09
10003,2021-06-06
10005,2021-06-03
10003,2021-06-06
10017,2021-06-06
10017,2021-06-04
10014,2021-06-03
10019,2021-06-03
10017,2021-06-04
10011,2021-07-08
10013,2021-07-01
10011,2021-07-04
10014,2021-06-09
10010,2021-07-03
10005,2021-06-08
10001,2021-06-05
10007,2021-06-05
10016,2021-06-04
10000,2021-07-09
10010,2021-06-04
10000,2021-07-10
10013,2021-07-09
10009,2021-07-06
10011,2021-07-10
10009,2021-07-07
10016,2021-06-06
10011,2021-06-06
10015,2021-06-05
10012,2021-06-02
10002,2021-07-03
10002,2021-06-10
10015,2021-06-04
10017,2021-07-04
10009,2021-07-03
10000,2021-07-04
10011,2021-06-04
10010,2021-07-06
10010,2021-06-09
10017,2021-06-08
10012,2021-07-08
10015,2021-07-04
10010,2021-06-01
10005,2021-07-04
10004,2021-07-01
10007,2021-07-03
10007,2021-07-02
10002,2021-06-06
10003,2021-07-05
10006,2021-07-07
10016,2021-06-01
10009,2021-07-09
10005,2021-07-07
10020,2021-06-03
10007,2021-06-10
10011,2021-06-10
10020,2021-07-07
10010,2021-06-03
10017,2021-06-01
10009,2021-07-09
10013,2021-07-05
10020,2021-07-07
10013,2021-07-05
10013,2021-06-09
10001,2021-07-04
10013,2021-07-06
10002,2021-07-06
10000,2021-07-10
10012,2021-07-10
10008,2021-06-07
10012,2021-07-07
10008,2021-07-03
10019,2021-07-05
10007,2021-07-07
10005,2021-06-10
10002,2021-07-07
10007,2021-07-05
10000,2021-06-02
10003,2021-06-02
10005,2021-06-01
10001,2021-06-06
10008,2021-07-09
10015,2021-06-08
10005,2021-07-04
10005,2021-07-08
10020,2021-06-06
10014,2021-07-05
10000,2021-07-04
10002,2021-06-05
10020,2021-06-10
10003,2021-07-08
10008,2021-07-02
10004,2021-06-07
10000,2021-07-02
10003,2021-07-09
10012,2021-06-09
10013,2021-07-07
10011,2021-06-01
10005,2021-06-08
10004,2021-06-08
10019,2021-07-03
10013,2021-07-04
10001,2021-07-06
10010,2021-07-07
10014,2021-06-03
10004,2021-07-06
10013,2021-06-03
10008,2021-07-05
10007,2021-07-07
10007,2021-06-09
10000,2021-06-05
10006,2021-06-04
10010,2021-06-03
10005,2021-06-03
10006,2021-06-09
10019,2021-06-04
10020,2021-07-02
10020,2021-07-10
10002,2021-07-04
10020,2021-07-09
10015,2021-07-09
10002,2021-07-04
10020,2021-06-04
10001,2021-07-01
10005,2021-07-02
10002,2021-07-08
10010,2021-07-04
10001,2021-07-01
10006,2021-06-07
10010,2021-06-04
10003,2021-07-07
10008,2021-07-03
10016,2021-07-10
10019,2021-07-09
10000,2021-06-07
10019,2021-07-06
10019,2021-07-10
10017,2021-07-04
10009,2021-07-04
10016,2021-06-10
10003,2021-06-09
10004,2021-07-10
10014,2021-06-06
10000,2021-06-07
10011,2021-07-02
10011,2021-07-04
10015,2021-07-10
10012,2021-07-04
10008,2021-07-03
10002,2021-06-03
10016,2021-06-03
10010,2021-07-09
10006,2021-07-07
10006,2021-06-09
10013,2021-06-04
10018,2021-07-10
10010,2021-06-04
10011,2021-07-07
10009,2021-07-02
10002,2021-06-03
10006,2021-06-10
10008,2021-06-03
10017,2021-06-10
10004,2021-07-08
10020,2021-07-10
10005,2021-07-06
10007,2021-06-05
10000,2021-07-09
10002,2021-06-02
10002,2021-07-09
10011,2021-06-10
10001,2021-06-07
10019,2021-07-03
10008,2021-07-04
10014,2021-06-01
10009,2021-06-07
10009,2021-06-07
10006,2021-06-09
10017,2021-07-01
10007,2021-07-01
10012,2021-07-08
10020,2021-06-10
10003,2021-07-01
10017,2021-06-06
10015,2021-06-06
10000,2021-06-02
10018,2021-06-01
10006,2021-06-04
10010,2021-06-01
10013,2021-07-07
10012,2021-07-07
10000,2021-06-09
10020,2021-07-02
10007,2021-07-04
10018,2021-06-07
10006,2021-07-01
10006,2021-06-01
10016,2021-06-08
10019,2021-07-10
10005,2021-06-03
10003,2021-06-01
10009,2021-07-02
10003,2021-06-05
10002,2021-07-09
10000,2021-06-06
10000,2021-06-06
10017,2021-06-07
10001,2021-06-06
10019,2021-06-05
10000,2021-06-04
10008,2021-06-10
10005,2021-07-07
10002,2021-07-07
10009,2021-06-10
10013,2021-06-01
10013,2021-06-04
10019,2021-06-09
10003,2021-07-10
10003,2021-06-06
10013,2021-07-10
10007,2021-07-01
10000,2021-06-07
10003,2021-07-09
10010,2021-06-07
10015,2021-07-07
10006,2021-07-04
10003,2021-06-08
10018,2021-06-09
10001,2021-06-03
10017,2021-07-01
10005,2021-06-05
10009,2021-06-06
10001,2021-06-06
10017,2021-06-04
10014,2021-07-09
10001,2021-06-07
10005,2021-07-05
10002,2021-06-05
10017,2021-07-05
10019,2021-06-10
10019,2021-07-03
10010,2021-07-03
10006,2021-07-05
10010,2021-07-08
10019,2021-06-07
10008,2021-07-02
10008,2021-07-03
10006,2021-07-10
10018,2021-06-09
10013,2021-07-05
10019,2021-06-08
10004,2021-07-02
10000,2021-07-07
10006,2021-07-06
10008,2021-07-10
10016,2021-07-02
10019,2021-06-02
10016,2021-06-02
10012,2021-07-07
10020,2021-07-07
10002,2021-07-09
10002,2021-07-03
10000,2021-06-08
10014,2021-07-02
10015,2021-06-10
10007,2021-07-03
10007,2021-07-01
10015,2021-07-07
10016,2021-06-09
10013,2021-06-10
10004,2021-07-05
10015,2021-07-08
10017,2021-07-02
10016,2021-07-04
10019,2021-06-07
10002,2021-07-10
10013,2021-07-04
10014,2021-07-10
10019,2021-07-05
10002,2021-07-04
10009,2021-07-06
10019,2021-07-02
10004,2021-07-04
10002,2021-07-04
10016,2021-07-02
10013,2021-06-06
10003,2021-06-09
10004,2021-06-07
10006,2021-07-03
10005,2021-07-09
10020,2021-06-05
10010,2021-06-05
10005,2021-06-03
10018,2021-06-01
10018,2021-06-09
10000,2021-07-06
10009,2021-07-06
10014,2021-07-06
10005,2021-07-08
10016,2021-07-05
10001,2021-07-08
10000,2021-07-01
10018,2021-07-09
10009,2021-07-06
10012,2021-07-08
10004,2021-06-02
10015,2021-06-10
10015,2021-07-09
10005,2021-06-01
10000,2021-07-03
10014,2021-07-06
10008,2021-06-04
10015,2021-07-03
10012,2021-06-10
10008,2021-06-05
10013,2021-07-02
10018,2021-06-01
10012,2021-06-04
10020,2021-06-04
10017,2021-07-06
10008,2021-07-07
10007,2021-07-01
10007,2021-07-02
10007,2021-06-09
10019,2021-07-02
10005,2021-06-05
10020,2021-06-01
10020,2021-06-03
10016,2021-07-03
10017,2021-06-03
10004,2021-07-08
10007,2021-06-07
10006,2021-07-07
10019,2021-07-10
10005,2021-07-10
10006,2021-06-05
10020,2021-06-05
10000,2021-06-07
10019,2021-07-04
10007,2021-07-02
10011,2021-07-04
10020,2021-06-06
10019,2021-06-09
10016,2021-07-03
10003,2021-07-07
10014,2021-07-03
10003,2021-07-10
10009,2021-06-02
10011,2021-07-01
10000,2021-06-09
10005,2021-07-07
10000,2021-06-01
10008,2021-07-09
10014,2021-06-07
10002,2021-06-04
10004,2021-06-09
10013,2021-06-06
10004,2021-06-05
10009,2021-06-07
10020,2021-06-08
10005,2021-06-04
10006,2021-06-04
10003,2021-07-04
10008,2021-06-10
10006,2021-07-07
10006,2021-06-08
10008,2021-07-01
10012,2021-06-10
10007,2021-06-03
10010,2021-07-06
10014,2021-07-10
10001,2021-07-04
10008,2021-07-03
10008,2021-06-05
10004,2021-06-07
10003,2021-07-06
10010,2021-07-04
10020,2021-07-10
10000,2021-06-08
10018,2021-07-01
10008,2021-06-04
10016,2021-07-01
10011,2021-06-08
10010,2021-06-09
10019,2021-06-09
10014,2021-07-01
10001,2021-07-08
10009,2021-07-10
10009,2021-06-10
10003,2021-06-07
10000,2021-07-01
10003,2021-07-02
10006,2021-07-03
10000,2021-07-08
10003,2021-06-07
10005,2021-07-05
10020,2021-06-02
10010,2021-07-08
10000,2021-06-01
10007,2021-06-05
10007,2021-07-05
10014,2021-07-05
10009,2021-07-03
10001,2021-06-03
10019,2021-07-07
10017,2021-06-08
10016,2021-06-06
10020,2021-07-09
10018,2021-07-07
10005,2021-07-07
10010,2021-07-09
10007,2021-07-03
10000,2021-06-01
10014,2021-07-02
10018,2021-06-09
10010,2021-07-06
10020,2021-06-07
10006,2021-07-08
10001,2021-06-10
10020,2021-06-05
10019,2021-06-02
10011,2021-07-03
10010,2021-06-10
10000,2021-06-09
10018,2021-06-02
10004,2021-06-04
10018,2021-06-02
10010,2021-06-02
10000,2021-07-02
10006,2021-06-08
10018,2021-06-03
10011,2021-06-10
10019,2021-07-03
10014,2021-06-04
10003,2021-07-08
10000,2021-06-07
10002,2021-06-08
10000,2021-07-04
10000,2021-07-02
10008,2021-06-02
10020,2021-06-06
10015,2021-07-01
10012,2021-06-07
10012,2021-07-07
10005,2021-06-10
10020,2021-06-05
10013,2021-07-09
10014,2021-07-02
10013,2021-07-07
10017,2021-07-08
10018,2021-06-06
10017,2021-06-09
10018,2021-07-01
10014,2021-06-06
10013,2021-06-02
10010,2021-07-02
10019,2021-07-04
10014,2021-06-03
10001,2021-07-07
10001,2021-07-08
10019,2021-07-03
10008,2021-07-07
10008,2021-07-01
10005,2021-06-04
10011,2021-06-08
10007,2021-06-08
10012,2021-07-09
10015,2021-06-07
10017,2021-06-08
10007,2021-07-05
10001,2021-07-05
10005,2021-06-01
10000,2021-07-05
10007,2021-07-06
10010,2021-07-07
10020,2021-07-05
10005,2021-07-10
10018,2021-07-05
10017,2021-06-05
10017,2021-07-05
10019,2021-07-07
10002,2021-06-08
10009,2021-07-07
10020,2021-07-05
10003,2021-06-10
10011,2021-06-04
10004,2021-06-06
10011,2021-06-02
10004,2021-07-06
10009,2021-06-09
10004,2021-07-01
10010,2021-07-04
10020,2021-06-09
10009,2021-07-08
10018,2021-07-05
10018,2021-07-06
10006,2021-06-06
10005,2021-07-08
10020,2021-06-05
10008,2021-07-09
10012,2021-07-08
10000,2021-07-05
10014,2021-06-02
10011,2021-06-07
10005,2021-06-09
10014,2021-07-09
10013,2021-06-07
10008,2021-07-10
10000,2021-06-02
10003,2021-06-08
10001,2021-07-06
10003,2021-07-06
10016,2021-07-05
10001,2021-06-03
10019,2021-06-03
10017,2021-06-07
10020,2021-06-10
10020,2021-06-02
10011,2021-07-04
10005,2021-06-06
10009,2021-07-07
10008,2021-06-08
10010,2021-07-04
10020,2021-06-07
10018,2021-07-06
10018,2021-07-09
10005,2021-06-03
10008,2021-06-06
10008,2021-07-03
10015,2021-06-04
10001,2021-06-09
10005,2021-07-10
10010,2021-06-02
10017,2021-06-10
10002,2021-07-02
10014,2021-06-10
10004,2021-06-02
10020,2021-06-01
10005,2021-06-07
10005,2021-06-01
10005,2021-06-04
10006,2021-06-02
10016,2021-06-04
10014,2021-07-02
10013,2021-07-01
10010,2021-06-03
10011,2021-07-03
10004,2021-06-06
10010,2021-07-04
10001,2021-06-02
10009,2021-06-07
10012,2021-07-08
10009,2021-06-08
10007,2021-06-09
10019,2021-07-07
10005,2021-06-10
10018,2021-07-08
10009,2021-06-05
10001,2021-07-10
10017,2021-06-02
10000,2021-06-04
10006,2021-06-08
10001,2021-07-10
10019,2021-06-03
10011,2021-07-03
10010,2021-07-09
10010,2021-06-09
10020,2021-06-03
10014,2021-07-09
10019,2021-07-09
10011,2021-06-07
10010,2021-06-01
10001,2021-06-04
10017,2021-07-03
10013,2021-06-03
10017,2021-06-09
10005,2021-06-10
10008,2021-06-01
10009,2021-06-05
10008,2021-07-08
10003,2021-06-06
10018,2021-07-08
10019,2021-06-06
10002,2021-07-07
10019,2021-06-10
10017,2021-07-08
10010,2021-07-03
10007,2021-06-04
10017,2021-06-01
10015,2021-07-05
10006,2021-06-10
10004,2021-06-06
10002,2021-07-05
10007,2021-06-07
10009,2021-06-09
10015,2021-07-08
10009,2021-06-09
10006,2021-07-10
10016,2021-06-02
10016,2021-06-04
10019,2021-07-01
10002,2021-06-03
10011,2021-07-04
10012,2021-06-01
10002,2021-07-03
10018,2021-06-06
10015,2021-07-09
10012,2021-06-09
10004,2021-06-01
10016,2021-06-04
10010,2021-07-02
10018,2021-06-03
10010,2021-06-06
10001,2021-07-09
10013,2021-06-08
10006,2021-06-08
10002,2021-07-05
10019,2021-06-04
10019,2021-06-07
10013,2021-06-09
10005,2021-07-08
10005,2021-07-04
10001,2021-06-08
10000,2021-07-04
10001,2021-07-09
10008,2021-06-10
10006,2021-06-05
10020,2021-06-07
10011,2021-07-05
10010,2021-06-09
10008,2021-07-09
10019,2021-06-06
10006,2021-07-06
10007,2021-06-10
10002,2021-07-02
10014,2021-06-08
10013,2021-06-01
10008,2021-07-02
10004,2021-07-01
10019,2021-07-02
10008,2021-06-05
10007,2021-06-08
10015,2021-07-06
10014,2021-07-02
10019,2021-06-10
10014,2021-07-10
10020,2021-07-05
10006,2021-07-05
10002,2021-06-05
10018,2021-06-03
10006,2021-07-03
10005,2021-07-08
10007,2021-07-10
10020,2021-07-10
10001,2021-07-03
10002,2021-06-03
10020,2021-06-02
10009,2021-07-01
10001,2021-07-04
10008,2021-06-04
10007,2021-07-10
10017,2021-07-02
10000,2021-07-09
10017,2021-06-04
10004,2021-06-05
10001,2021-06-03
10010,2021-06-04
10010,2021-07-05
10007,2021-07-03
10011,2021-07-10
10020,2021-07-02
10000,2021-06-07
10014,2021-06-08
10002,2021-07-04
10004,2021-07-05
10017,2021-07-07
10007,2021-06-10
10018,2021-07-05
10012,2021-06-03
10013,2021-06-03
10006,2021-07-03
10020,2021-06-03
10000,2021-07-02
10007,2021-06-06
10007,2021-07-03
10011,2021-07-08
10013,2021-06-04
10017,2021-06-02
10001,2021-07-07
10009,2021-07-02
10003,2021-06-06
10004,2021-06-01
10007,2021-07-07
10007,2021-07-05
10000,2021-07-05
10003,2021-06-02
10004,2021-06-08
10006,2021-07-08
10010,2021-07-07
10017,2021-07-08
10013,2021-07-04
10001,2021-07-06
10016,2021-06-10
10014,2021-06-09
10013,2021-06-01
10004,2021-07-08
10003,2021-07-01
10017,2021-07-10
10010,2021-07-07
10003,2021-06-09
10012,2021-07-10
10012,2021-06-05
10000,2021-07-05
10004,2021-07-01
10010,2021-07-10
10003,2021-07-04
10020,2021-06-05
10018,2021-07-08
10019,2021-07-02
10012,2021-06-03
10018,2021-07-06
10015,2021-07-04
10002,2021-06-10
10018,2021-07-10
10005,2021-07-06
10002,2021-07-02
10011,2021-07-09
10007,2021-07-07
10017,2021-06-03
10017,2021-07-06
10013,2021-07-09
10008,2021-06-10
10019,2021-06-08
10010,2021-07-07
10006,2021-07-05
10018,2021-06-10
10004,2021-07-10
10013,2021-06-10
10017,2021-06-09
10006,2021-07-07
10008,2021-07-07
10003,2021-07-04
10002,2021-07-01
10019,2021-06-07
10001,2021-07-03
10013,2021-06-09
10004,2021-06-07
10008,2021-07-02
10011,2021-06-04
10005,2021-06-01
10014,2021-07-03
10002,2021-06-10
10003,2021-06-07
10018,2021-06-03
10004,2021-07-04
10003,2021-06-07
10006,2021-06-02
10012,2021-07-01
10002,2021-06-06
10009,2021-07-03
10014,2021-06-09
10000,2021-06-07
10020,2021-07-08
10020,2021-06-09
10011,2021-06-05
10001,2021-07-01
10001,2021-06-03
10018,2021-06-04
10007,2021-07-08
10013,2021-07-09
10001,2021-06-05
10018,2021-06-09
10012,2021-07-05
10009,2021-06-02
10006,2021-06-04
10003,2021-06-04
10008,2021-07-02
10002,2021-07-10
10013,2021-07-02
10012,2021-06-02
10004,2021-06-10
10020,2021-07-10
10004,2021-06-02
10010,2021-06-07
10018,2021-06-09
10007,2021-06-04
10010,2021-07-05
10007,2021-06-08
10006,2021-07-04
10008,2021-06-02
10001,2021-07-09
10012,2021-07-02
10013,2021-06-08
10006,2021-07-10
10007,2021-06-08
10007,2021-07-07
10020,2021-07-04
10009,2021-06-10
10000,2021-07-10
10012,2021-06-08
10007,2021-07-07
10019,2021-07-04
10005,2021-06-09
10006,2021-07-04
10010,2021-06-09
10006,2021-07-01
10010,2021-07-06
10005,2021-07-01
10017,2021-07-04
10014,2021-07-08
10000,2021-07-04
10016,2021-07-07
10001,2021-07-03
10005,2021-07-10
10002,2021-07-04
10002,2021-06-04
10002,2021-07-04
10015,2021-07-03
10007,2021-07-07
10007,2021-07-05
10004,2021-06-01
10017,2021-07-04
10020,2021-07-04
10013,2021-07-02
10010,2021-06-04
10015,2021-06-03
10002,2021-07-06
10005,2021-06-02
10014,2021-06-10
10007,2021-06-02
10010,2021-07-04
10004,2021-07-05
10008,2021-07-05
10003,2021-07-07
10011,2021-07-05
10019,2021-06-06
10017,2021-06-10
10016,2021-06-10
10007,2021-07-05
10015,2021-06-05
10003,2021-06-03
10000,2021-07-06
10004,2021-07-05
10011,2021-07-02
10006,2021-06-09
10014,2021-07-09
10010,2021-07-08
10011,2021-07-02
10013,2021-06-07
10003,2021-07-03
10002,2021-06-03
10007,2021-06-07
10008,2021-07-07
10014,2021-07-10
10013,2021-07-09
10011,2021-07-03
10001,2021-07-05
10011,2021-07-03
10011,2021-07-06
10019,2021-06-07
10020,2021-06-07
10007,2021-07-09
10015,2021-06-05
10009,2021-06-03
10000,2021-06-01
10015,2021-07-02
10005,2021-06-06
10008,2021-07-03
10013,2021-06-09
10012,2021-06-03
10005,2021-07-05
10011,2021-06-06
10000,2021-07-06
10017,2021-06-01
10001,2021-07-05
10017,2021-06-02
10012,2021-06-10
10013,2021-07-03
10006,2021-06-09
10017,2021-07-04
10001,2021-07-10
10014,2021-07-02
10020,2021-06-07
10012,2021-06-08
10019,2021-06-05
10012,2021-07-09
10016,2021-06-03
10016,2021-06-06
10016,2021-06-06
10006,2021-06-07
10013,2021-06-09
10002,2021-07-04
10017,2021-07-05
10020,2021-06-01
10000,2021-07-02
10010,2021-06-05
10008,2021-06-07
10012,2021-06-10
10008,2021-06-09
10019,2021-07-06
10004,2021-07-01
10012,2021-07-10
10003,2021-06-03
10003,2021-06-07
10015,2021-07-02
10015,2021-07-07
10019,2021-07-05
10005,2021-07-08
10016,2021-06-10
10020,2021-06-06
10007,2021-06-03
10011,2021-06-05
10006,2021-06-02
10017,2021-06-10
10010,2021-07-02
10001,2021-06-01
10005,2021-07-08
10007,2021-07-06
10004,2021-06-08
10013,2021-07-07
10010,2021-06-01
10006,2021-06-06
10020,2021-07-07
10002,2021-07-06
10017,2021-07-03
10008,2021-06-10
10011,2021-06-04
10006,2021-06-10
10000,2021-06-08
10009,2021-06-06
10020,2021-06-01
10006,2021-07-01
10009,2021-07-05
10019,2021-06-06
10010,2021-07-08
10013,2021-06-06
10000,2021-07-03
10002,2021-07-03
10018,2021-07-10
10007,2021-07-09
10018,2021-06-07
10004,2021-07-05
10006,2021-07-05
10011,2021-06-06
10014,2021-07-03
10005,2021-07-06
10001,2021-06-07
10004,2021-07-01
10005,2021-06-05
10016,2021-07-01
10009,2021-06-04
10003,2021-06-05
10019,2021-06-06
10008,2021-06-08
10019,2021-07-10
10017,2021-06-05
10009,2021-07-10
avatar
文章
阅读
粉丝