Kylin入门案例

冷不防 2022-10-31 10:48 213阅读 0赞

### 目录 ###

*   *  测试数据表结构介绍
     *  导入测试数据
     *  Kylin方法步骤
     *  按照日期统计订单总额/总数量
     *   *  Kylin入门案例\_一张表
     *  按照订单渠道名称统计订单总额/总数量
     *   *  Kylin入门案例\_多张表
     *  按照日期、区域、产品维度统计订单总额/总数量
     *   *  Kylin入门案例\_一张事实表多张维度表

## 测试数据表结构介绍 ##

1、（事实表）dw\_sales

<table> 
 <thead> 
  <tr> 
   <th>列名</th> 
   <th>列类型</th> 
   <th>说明</th> 
  </tr> 
 </thead> 
 <tbody> 
  <tr> 
   <td>id</td> 
   <td>string</td> 
   <td>订单id</td> 
  </tr> 
  <tr> 
   <td>date1</td> 
   <td>string</td> 
   <td>订单日期</td> 
  </tr> 
  <tr> 
   <td>channelid</td> 
   <td>string</td> 
   <td>订单渠道（商场、京东、天猫）</td> 
  </tr> 
  <tr> 
   <td>productid</td> 
   <td>string</td> 
   <td>产品id</td> 
  </tr> 
  <tr> 
   <td>regionid</td> 
   <td>string</td> 
   <td>区域名称</td> 
  </tr> 
  <tr> 
   <td>amount</td> 
   <td>int</td> 
   <td>商品下单数量</td> 
  </tr> 
  <tr> 
   <td>price</td> 
   <td>double</td> 
   <td>商品金额</td> 
  </tr> 
 </tbody> 
</table>

2、（维度表\_渠道方式）dim\_channel

<table> 
 <thead> 
  <tr> 
   <th>列名</th> 
   <th>列类型</th> 
   <th>说明</th> 
  </tr> 
 </thead> 
 <tbody> 
  <tr> 
   <td>channelid</td> 
   <td>string</td> 
   <td>渠道id</td> 
  </tr> 
  <tr> 
   <td>channelname</td> 
   <td>string</td> 
   <td>渠道名称</td> 
  </tr> 
 </tbody> 
</table>

3、（维度表\_产品名称）dim\_product

<table> 
 <thead> 
  <tr> 
   <th>列名</th> 
   <th>列类型</th> 
   <th>说明</th> 
  </tr> 
 </thead> 
 <tbody> 
  <tr> 
   <td>productid</td> 
   <td>string</td> 
   <td>产品id</td> 
  </tr> 
  <tr> 
   <td>productname</td> 
   <td>string</td> 
   <td>产品名称</td> 
  </tr> 
 </tbody> 
</table>

4、（维度表\_区域）dim\_region

<table> 
 <thead> 
  <tr> 
   <th>列名</th> 
   <th>列类型</th> 
   <th>说明</th> 
  </tr> 
 </thead> 
 <tbody> 
  <tr> 
   <td>regionid</td> 
   <td>string</td> 
   <td>产品id</td> 
  </tr> 
  <tr> 
   <td>regionname</td> 
   <td>string</td> 
   <td>产品名称</td> 
  </tr> 
 </tbody> 
</table>

## 导入测试数据 ##

为了方便后续学习Kylin的使用，需要准备一些测试表、测试数据。  
dim\_channel\_data.txt

01,商场
    02,京东
    03,天猫

dim\_product\_data.txt

01,meta20
    02,p30
    03,ihpone Xs
    04,小米 9

dim\_region\_data.txt

010,北京
    021,上海

dw\_sales\_data.txt

0001,2019-02-01,01,01,010,1,3400.00
    0002,2019-02-01,02,02,021,2,6800.00
    0003,2019-02-01,01,01,010,1,3400.00
    0004,2019-02-01,01,02,021,1,3400.00
    0005,2019-02-01,02,01,010,1,3400.00
    0006,2019-02-01,01,01,021,2,6800.00
    0007,2019-02-01,03,02,010,1,3400.00
    0008,2019-02-01,01,01,021,1,3400.00
    0009,2019-02-01,01,03,010,1,3400.00
    0010,2019-02-01,02,01,021,3,10200.00
    0011,2019-02-01,01,04,010,1,3400.00
    0012,2019-02-01,03,01,021,1,3400.00
    0013,2019-02-01,01,04,010,1,3400.00
    0014,2019-02-02,01,01,010,1,3400.00
    0015,2019-02-02,02,02,021,2,6800.00
    0016,2019-02-02,01,01,010,1,3400.00
    0017,2019-02-02,01,02,021,1,3400.00
    0018,2019-02-02,02,01,010,1,3400.00
    0019,2019-02-02,01,01,021,2,6800.00
    0020,2019-02-02,03,02,010,1,3400.00
    0021,2019-02-02,01,01,021,1,3400.00
    0022,2019-02-02,01,03,010,1,3400.00
    0023,2019-02-02,02,01,021,3,10200.00
    0024,2019-02-02,01,04,010,1,3400.00
    0025,2019-02-02,03,01,021,1,3400.00
    0026,2019-02-02,01,04,010,1,3400.00
    0027,2019-02-02,01,04,010,1,3400.00

建表导入语句

-- 1、销售表：dw_sales
    -- id   唯一标识
    -- date1 日期
    -- channelId 渠道 ID
    -- productId 产品 ID
    -- regionId 区域 ID
    -- amount 数量
    -- price 金额
    create table dw_sales(id string,date1 string,channelId string, productId string, regionId string,amount int,price double)ROW FORMAT DELIMITED FIELDS TERMINATED BY ',' stored as textfile;
    
    -- 2、渠道表：dim_channel
    -- channelId 渠道ID
    -- channelName 渠道名称
    create table dim_channel(channelId string, channelName string )ROW FORMAT DELIMITED FIELDS TERMINATED BY ',' stored as textfile;
    
    -- 3、产品表：dim_product
    create table dim_product(productId string, productName string )ROW FORMAT DELIMITED FIELDS TERMINATED BY ',' stored as textfile;
    
    --4、区域表：dim_region
    create table dim_region(regionId string,regionName string)ROW FORMAT DELIMITED FIELDS TERMINATED BY ',' stored as textfile;
    
    -- 导入数据
    LOAD DATA LOCAL INPATH '/export/data/dw_sales_data.txt' OVERWRITE  INTO TABLE dw_sales;
    LOAD DATA LOCAL INPATH '/export/data/dim_channel_data.txt' OVERWRITE  INTO TABLE dim_channel;
    LOAD DATA LOCAL INPATH '/export/data/dim_product_data.txt' OVERWRITE  INTO TABLE dim_product;
    LOAD DATA LOCAL INPATH '/export/data/dim_region_data.txt' OVERWRITE  INTO TABLE dim_region;

## Kylin方法步骤 ##

要使用Kylin进行OLAP分析，需要按照以下方式来进行。

1、创建项目（Project）
    2、创建数据源（DataSource）
    - 指定有哪些数据需要进行数据分析
    3、创建模型（Model）
    - 指定具体要对哪个事实表、那些维度进行数据分析
    4、创建立方体（Cube）
    - 指定对哪个数据模型执行数据预处理，生成不同维度的数据
    5、执行构建、等待构建完成
    6、再执行SQL查询，获取结果
    - 从Cube中查询数据

## 按照日期统计订单总额/总数量 ##

select date1, sum(price) as total_money, sum(amount) as total_amount 
    from dw_sales group by date1;

### Kylin入门案例\_一张表 ###

创建项目（Project）  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQ2NTQ4ODU1_size_16_color_FFFFFF_t_70]  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQ2NTQ4ODU1_size_16_color_FFFFFF_t_70 1]  
**创建数据源（DataSource）**  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQ2NTQ4ODU1_size_16_color_FFFFFF_t_70 2]  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQ2NTQ4ODU1_size_16_color_FFFFFF_t_70 3]  
**创建模型（Model）**  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQ2NTQ4ODU1_size_16_color_FFFFFF_t_70 4]  
指定模型名称  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQ2NTQ4ODU1_size_16_color_FFFFFF_t_70 5]  
指定事实表  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQ2NTQ4ODU1_size_16_color_FFFFFF_t_70 6]  
指定维度字段  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQ2NTQ4ODU1_size_16_color_FFFFFF_t_70 7]  
指定待分析的指标  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQ2NTQ4ODU1_size_16_color_FFFFFF_t_70 8]  
指定分区和过滤条件  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQ2NTQ4ODU1_size_16_color_FFFFFF_t_70 9]  
**创建立方体（Cube）**  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQ2NTQ4ODU1_size_16_color_FFFFFF_t_70 10]  
1、选择数据模型  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQ2NTQ4ODU1_size_16_color_FFFFFF_t_70 11]

2、指定维度  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQ2NTQ4ODU1_size_16_color_FFFFFF_t_70 12]

3、指定度量  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQ2NTQ4ODU1_size_16_color_FFFFFF_t_70 13]  
4、指定刷新设置  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQ2NTQ4ODU1_size_16_color_FFFFFF_t_70 14]  
5、指定执行引擎  
不选也可以，默认hive上的  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQ2NTQ4ODU1_size_16_color_FFFFFF_t_70 15]  
**执行构建**  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQ2NTQ4ODU1_size_16_color_FFFFFF_t_70 16]  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQ2NTQ4ODU1_size_16_color_FFFFFF_t_70 17]  
数据存储在hbase  
![在这里插入图片描述][20210223171844184.png]  
**执行SQL语句分析**  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQ2NTQ4ODU1_size_16_color_FFFFFF_t_70 18]

select
      date1,
      sum(price) as total_money,
      sum(amount) as total_amount
    from
      dw_sales
    group by date1;

在hive上执行花费40s  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQ2NTQ4ODU1_size_16_color_FFFFFF_t_70 19]

## 按照订单渠道名称统计订单总额/总数量 ##

select
    	t2.channelid,
    	t2.channelname,
    	sum(t1.price) as total_money,
    	sum(t1.amount) as total_amount
    from 
    	dw_sales t1
    inner join dim_channel t2
    on t1.channelid = t2.channelid
    group by t2.channelid, t2.channelname

### Kylin入门案例\_多张表 ###

1、创建Model  
指定关联表、关联条件  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQ2NTQ4ODU1_size_16_color_FFFFFF_t_70 20]  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQ2NTQ4ODU1_size_16_color_FFFFFF_t_70 21]  
指定维度字段  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQ2NTQ4ODU1_size_16_color_FFFFFF_t_70 22]  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQ2NTQ4ODU1_size_16_color_FFFFFF_t_70 23]  
指定待分析的指标  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQ2NTQ4ODU1_size_16_color_FFFFFF_t_70 24]  
2、创建Cube  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQ2NTQ4ODU1_size_16_color_FFFFFF_t_70 25]  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQ2NTQ4ODU1_size_16_color_FFFFFF_t_70 26]  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQ2NTQ4ODU1_size_16_color_FFFFFF_t_70 27]

3、执行构建、等待构建完成  
4、执行SQL查询，获取结果  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQ2NTQ4ODU1_size_16_color_FFFFFF_t_70 28]

## 按照日期、区域、产品维度统计订单总额/总数量 ##

select
    	t1.date1, 
    	t2.regionid, 
    	t2.regionname, 
    	t3.productid, 
    	t3.productname,
    	sum(t1.price) as total_money,
    	sum(t1.amount) as total_amount
    from
    	dw_sales t1
    inner join dim_region t2
    on t1.regionid = t2.regionid
    inner join dim_product t3
    on t1.productid = t3.productid
    group by 
    	t1.date1, 
    	t2.regionid, 
    	t2.regionname, 
    	t3.productid, 
    	t3.productname
    order by 
    	t1.date1,
    	t2.regionname,
    	t3.productname

### Kylin入门案例\_一张事实表多张维度表 ###

1、创建Model

*  指定关联表、关联条件  
    ![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQ2NTQ4ODU1_size_16_color_FFFFFF_t_70 29][]  
    ![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQ2NTQ4ODU1_size_16_color_FFFFFF_t_70 30]  
    ![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQ2NTQ4ODU1_size_16_color_FFFFFF_t_70 31]  
    2、创建Cube  
    ![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQ2NTQ4ODU1_size_16_color_FFFFFF_t_70 32]  
    ![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQ2NTQ4ODU1_size_16_color_FFFFFF_t_70 33]  
    ![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQ2NTQ4ODU1_size_16_color_FFFFFF_t_70 34]

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQ2NTQ4ODU1_size_16_color_FFFFFF_t_70]: /images/20221024/673cb48d2b0241f0a5f8d83496b32087.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQ2NTQ4ODU1_size_16_color_FFFFFF_t_70 1]: /images/20221024/061197f7f67443bba7a7a95c0e3c9c2b.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQ2NTQ4ODU1_size_16_color_FFFFFF_t_70 2]: /images/20221024/886af38dcfce49d2b655015ec385c1c0.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQ2NTQ4ODU1_size_16_color_FFFFFF_t_70 3]: /images/20221024/a5922e080384412b805b4684646e3e80.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQ2NTQ4ODU1_size_16_color_FFFFFF_t_70 4]: /images/20221024/32f7a7ab062b49788efd7c66607f40e2.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQ2NTQ4ODU1_size_16_color_FFFFFF_t_70 5]: /images/20221024/3cdaa5b7b04046d3b46803a5a9afcc41.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQ2NTQ4ODU1_size_16_color_FFFFFF_t_70 6]: /images/20221024/b0d82d911f6045dcb7d1dd014131d427.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQ2NTQ4ODU1_size_16_color_FFFFFF_t_70 7]: /images/20221024/0add4050398944c0ad24a6d79eba6013.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQ2NTQ4ODU1_size_16_color_FFFFFF_t_70 8]: /images/20221024/8c0703e6f57c48bfa25a69624d4329d8.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQ2NTQ4ODU1_size_16_color_FFFFFF_t_70 9]: /images/20221024/161f8e257ca04ba3a17ce50a20944941.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQ2NTQ4ODU1_size_16_color_FFFFFF_t_70 10]: /images/20221024/382869b8e5ab4bd0ab576901da1451ef.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQ2NTQ4ODU1_size_16_color_FFFFFF_t_70 11]: /images/20221024/4c0bef5fe38b4fc8b5c075f4c99b774b.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQ2NTQ4ODU1_size_16_color_FFFFFF_t_70 12]: /images/20221024/49ef86e569f94b6cbf199cafad3d046c.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQ2NTQ4ODU1_size_16_color_FFFFFF_t_70 13]: /images/20221024/94c093d68a9f4205bab43ec4f27b7666.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQ2NTQ4ODU1_size_16_color_FFFFFF_t_70 14]: /images/20221024/1b5f4b8dac204b2a9e674a198cd34166.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQ2NTQ4ODU1_size_16_color_FFFFFF_t_70 15]: /images/20221024/ea3aac881cc54ecf98748a78269085a2.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQ2NTQ4ODU1_size_16_color_FFFFFF_t_70 16]: /images/20221024/949ee671560a45f0ba5e07e3901bb82d.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQ2NTQ4ODU1_size_16_color_FFFFFF_t_70 17]: /images/20221024/471206b7b49c4353b52c426af0935b18.png
[20210223171844184.png]: /images/20221024/0046abe7ad6c40dcbb0aa358c3194582.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQ2NTQ4ODU1_size_16_color_FFFFFF_t_70 18]: /images/20221024/a4f84c290b5241ee9ea1caeec9687cc4.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQ2NTQ4ODU1_size_16_color_FFFFFF_t_70 19]: /images/20221024/6b9b453969a1415cbffc5705e7a008dc.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQ2NTQ4ODU1_size_16_color_FFFFFF_t_70 20]: /images/20221024/b702951697f4491785ba6d80db651cda.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQ2NTQ4ODU1_size_16_color_FFFFFF_t_70 21]: /images/20221024/4d16be0caab042fbabf7db3539b212b1.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQ2NTQ4ODU1_size_16_color_FFFFFF_t_70 22]: /images/20221024/94524c65d8bd4020889f80ea1ff9b885.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQ2NTQ4ODU1_size_16_color_FFFFFF_t_70 23]: /images/20221024/67f52368fdae49b387f2e0e8669ca17b.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQ2NTQ4ODU1_size_16_color_FFFFFF_t_70 24]: /images/20221024/f202c67b9a054d10967999f298a7aee1.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQ2NTQ4ODU1_size_16_color_FFFFFF_t_70 25]: /images/20221024/fac753e2ef694e51b371f452758c336b.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQ2NTQ4ODU1_size_16_color_FFFFFF_t_70 26]: /images/20221024/da49bd41a4db4315ada3e31060429ab9.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQ2NTQ4ODU1_size_16_color_FFFFFF_t_70 27]: /images/20221024/8f38baa39e5e49a8af7032094cad1be4.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQ2NTQ4ODU1_size_16_color_FFFFFF_t_70 28]: /images/20221024/37c34814c5324d43aff8f157069337f8.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQ2NTQ4ODU1_size_16_color_FFFFFF_t_70 29]: /images/20221024/3360331968c046199fd839d69cdd78b3.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQ2NTQ4ODU1_size_16_color_FFFFFF_t_70 30]: /images/20221024/b5afa782ba174ab79a3c9ac3129ced13.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQ2NTQ4ODU1_size_16_color_FFFFFF_t_70 31]: /images/20221024/682f6a723f76436bad170d512161553a.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQ2NTQ4ODU1_size_16_color_FFFFFF_t_70 32]: /images/20221024/a4d285a5f1824300acee7b5269c68084.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQ2NTQ4ODU1_size_16_color_FFFFFF_t_70 33]: /images/20221024/f08ff8dc869f4ad28de629984284f23e.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQ2NTQ4ODU1_size_16_color_FFFFFF_t_70 34]: /images/20221024/d3e628d23f83491980b3304e51b5f87d.png