MySQL优化题

柔情只为你懂 2023-05-22 06:41 24阅读 0赞

题目：

假如两个库表分别有如下字段：

<table style="width:500px;"> 
 <tbody> 
  <tr> 
   <td colspan="3">表名：customers(客户基本信息，约1亿条数据)</td> 
  </tr> 
  <tr> 
   <td>字段名</td> 
   <td>数据类型</td> 
   <td>是否非空</td> 
  </tr> 
  <tr> 
   <td>id</td> 
   <td>bigint(10)</td> 
   <td>是</td> 
  </tr> 
  <tr> 
   <td>name</td> 
   <td>varchar(20)</td> 
   <td>是</td> 
  </tr> 
  <tr> 
   <td>city</td> 
   <td>varchar(20)</td> 
   <td>是</td> 
  </tr> 
  <tr> 
   <td>gender</td> 
   <td>tinyint(1)</td> 
   <td>是</td> 
  </tr> 
  <tr> 
   <td>birthday</td> 
   <td>date</td> 
   <td>是</td> 
  </tr> 
  <tr> 
   <td>mobile</td> 
   <td>varchar(20)</td> 
   <td>&nbsp;</td> 
  </tr> 
  <tr> 
   <td>photo</td> 
   <td>varchar(255)</td> 
   <td>&nbsp;</td> 
  </tr> 
 </tbody> 
</table>

<table style="width:500px;"> 
 <tbody> 
  <tr> 
   <td colspan="3">表名：salary(客户收入情况，约600万条记录)</td> 
  </tr> 
  <tr> 
   <td>字段名</td> 
   <td>数据类型</td> 
   <td>是否非空</td> 
  </tr> 
  <tr> 
   <td>id</td> 
   <td>bigint(11)</td> 
   <td>是</td> 
  </tr> 
  <tr> 
   <td>monthsalary</td> 
   <td>decimal(10,2)</td> 
   <td>是</td> 
  </tr> 
  <tr> 
   <td>yearbonus</td> 
   <td>decimal(10,2)</td> 
   <td>&nbsp;</td> 
  </tr> 
 </tbody> 
</table>

请写出sql语句分别满足如下查询需求：（请注意查询性能，优化语句为方便测试目前数据库数据为2198031条数据，仅供参考）

(1)女性客户数量和平均月薪;

(2)不同城市的客户数量和平均月薪;  
(3)列出没有手机号，或者没有照片，或者没有年奖金的客户姓名

(4)不同年龄段(0到100岁之间，每10岁为一个年龄段)的客户年收入;

(5)列出每个城市的年收入最高和最低的男性和女性的姓名和全年收入

答：

## 1)sql语句 ##

select count(*)as c,avg(monthsalary) as a_monthsalary from customers where gender=0

未做优化前 ：时间耗时为2.079s

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM5Mzk5OTY2_size_16_color_FFFFFF_t_70][]![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM5Mzk5OTY2_size_16_color_FFFFFF_t_70 1][]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM5Mzk5OTY2_size_16_color_FFFFFF_t_70 2][]

**优化思路一： 时间耗时为9.491s**

ALTER TABLE customers ADD INDEX gender(gender);

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM5Mzk5OTY2_size_16_color_FFFFFF_t_70 3][]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM5Mzk5OTY2_size_16_color_FFFFFF_t_70 4][]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM5Mzk5OTY2_size_16_color_FFFFFF_t_70 5][] **优化思路二：时间耗时为2.134s**

ALTER TABLE customers ADD INDEX monthsalary(monthsalary);

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM5Mzk5OTY2_size_16_color_FFFFFF_t_70 6][]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM5Mzk5OTY2_size_16_color_FFFFFF_t_70 7][]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM5Mzk5OTY2_size_16_color_FFFFFF_t_70 8][]** 优化思路三：时间耗时为1.306s**

ALTER TABLE customers ADD INDEX monthsalary_gender(monthsalary,gender);

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM5Mzk5OTY2_size_16_color_FFFFFF_t_70 9][]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM5Mzk5OTY2_size_16_color_FFFFFF_t_70 10][]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM5Mzk5OTY2_size_16_color_FFFFFF_t_70 11][] **优化思路四：时间耗时为1.176s（最佳）**

ALTER TABLE customers ADD INDEX gender_monthsalary(gender,monthsalary);

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM5Mzk5OTY2_size_16_color_FFFFFF_t_70 12][]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM5Mzk5OTY2_size_16_color_FFFFFF_t_70 13][]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM5Mzk5OTY2_size_16_color_FFFFFF_t_70 14][]

## 2) sql语句 ##

select count(*) c,avg(monthsalary) from customers1 GROUP BY city;

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM5Mzk5OTY2_size_16_color_FFFFFF_t_70 15][]

**优化一： 耗时时间为：108.47s**

ALTER TABLE customers ADD INDEX city(city);

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM5Mzk5OTY2_size_16_color_FFFFFF_t_70 16][]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM5Mzk5OTY2_size_16_color_FFFFFF_t_70 17][]![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM5Mzk5OTY2_size_16_color_FFFFFF_t_70 18][]

**优化思路二：耗时时间为： 3.858s**

ALTER TABLE customers ADD INDEX monthsalary(monthsalary);

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM5Mzk5OTY2_size_16_color_FFFFFF_t_70 19][]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM5Mzk5OTY2_size_16_color_FFFFFF_t_70 20][] ![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM5Mzk5OTY2_size_16_color_FFFFFF_t_70 21][]

**优化思路三：耗时时间为： 3.183s**

ALTER TABLE customers ADD INDEX monthsalary_city(monthsalary,city);

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM5Mzk5OTY2_size_16_color_FFFFFF_t_70 22][]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM5Mzk5OTY2_size_16_color_FFFFFF_t_70 23][]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM5Mzk5OTY2_size_16_color_FFFFFF_t_70 24][] **优化思路四：耗时时间为：3.37S**

ALTER TABLE customers ADD INDEX gender_monthsalary_city(gender,monthsalary,city);

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM5Mzk5OTY2_size_16_color_FFFFFF_t_70 25][]

![20200430130442834.png][]

**优化思路五：耗时时间为： 1.720s**

ALTER TABLE customers ADD INDEX city_monthsalary_gender(city,monthsalary,gender);

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM5Mzk5OTY2_size_16_color_FFFFFF_t_70 26][]

![20200430130834274.png][] ![20200430130921996.png][]

**优化思路六：耗时时间为：** **1.698S （最佳）**

ALTER TABLE customers ADD INDEX city_monthsalary(city,monthsalary);

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM5Mzk5OTY2_size_16_color_FFFFFF_t_70 27][]

![20200430131407906.png][] ![20200430131451852.png][]

## 3) 第一种方案 sql语句 ##

select name from customers where mobile="0" or photo='' or yearbonus="0"

** 未加索引前：2.459s**![20200430131904219.png][]

** 优化思路一：覆盖索引 （先计算占比）**

select
    count(distinct mobile)/ count(*) as mobile_select,
    count(distinct photo)/ count(*) as photo_select,
    count(distinct yearbonus) / count(*) as yearbonus_select,
    count(*) as counts
    from customers;

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM5Mzk5OTY2_size_16_color_FFFFFF_t_70 28][]

**创建索引： 耗时时间为：2.178S**

ALTER TABLE customers ADD INDEX mobile_yearbonus_photo(mobile,yearbonus,photo);

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM5Mzk5OTY2_size_16_color_FFFFFF_t_70 29][]

![20200430132715157.png][]

![20200430132837295.png][]** 优化思路二：耗时时间为：2.343s**

ALTER TABLE customers add INDEX mobile_yearbonus_photo(mobile,yearbonus,photo);
    ALTER TABLE customers ADD INDEX idx_mobile_name(mobile,`name`);
    ALTER TABLE customers ADD INDEX idx_photo_name(photo,`name`);
    ALTER TABLE customers ADD INDEX idx_yearbonus_name(yearbonus,`name`);

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM5Mzk5OTY2_size_16_color_FFFFFF_t_70 30][]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM5Mzk5OTY2_size_16_color_FFFFFF_t_70 31][] ![202004301336035.png][]

由此可见索引对使用or连接的sql语句不起作用。

**方案二：SQL语句 **

SELECT name from customers where mobile="0"
    UNION ALL
    SELECT name from customers where photo="0" 
    UNION ALL
    SELECT name from customers where yearbonus=0

**未加任何索引前：耗时时间为：5.74s **

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM5Mzk5OTY2_size_16_color_FFFFFF_t_70 32][]

**优化思路一： 耗时时间为：2066.578s**

ALTER TABLE customers add INDEX mobile_yearbonus_photo(mobile,yearbonus,photo);

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM5Mzk5OTY2_size_16_color_FFFFFF_t_70 33][]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM5Mzk5OTY2_size_16_color_FFFFFF_t_70 34][]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM5Mzk5OTY2_size_16_color_FFFFFF_t_70 35][]** 优化思路三：2.885s（最佳）**

ALTER TABLE customers ADD INDEX idx_mobile_name(mobile,`name`);
    ALTER TABLE customers ADD INDEX idx_photo_name(photo,`name`);
    ALTER TABLE customers ADD INDEX idx_yearbonus_name(yearbonus,`name`);

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM5Mzk5OTY2_size_16_color_FFFFFF_t_70 36][]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM5Mzk5OTY2_size_16_color_FFFFFF_t_70 37][]

## 4）sql语句 ##

select elt(
     interval(
       TIMESTAMPDIFF(YEAR, birthdate, CURDATE()),0,10,20,30,40,50,60,70,80,90,100),
       "0-10","10-20","200-30","30-40","40-50","50-60","60-70","70-80","80-90","90-100",">100"
    ) as age ,monthsalary*12+yearbonus as income
    from customers  GROUP BY age order by null

**未优化前：耗时时间为：4.614s **

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM5Mzk5OTY2_size_16_color_FFFFFF_t_70 38][]

**优化思路一：耗时时间为：5.296s**

计算占比：

select
    count(distinct yearbonus)/ count(*) as year_select,
    count(distinct monthsalary)/ count(*) as mon_select,
    count(distinct TIMESTAMPDIFF(YEAR, birthdate, CURDATE())) / count(*) as bir_select,
    count(*) as counts
    from customers;

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM5Mzk5OTY2_size_16_color_FFFFFF_t_70 39][] ![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM5Mzk5OTY2_size_16_color_FFFFFF_t_70 40][]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM5Mzk5OTY2_size_16_color_FFFFFF_t_70 41][]

** 优化思路二：耗时时间为：4.124s**

ALTER TABLE customers ADD INDEX birthdate_yearbonus_monthsalary(birthdate,yearbonus,monthsalary)

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM5Mzk5OTY2_size_16_color_FFFFFF_t_70 42][]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM5Mzk5OTY2_size_16_color_FFFFFF_t_70 43][] ![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM5Mzk5OTY2_size_16_color_FFFFFF_t_70 44][]

## 5）sql语句 ##

#最小
    select a.name,b.income FROM
      customers a,
    	(
    		select
    			city,gender,min(monthsalary * 12 + yearbonus) as income
    		from
    			customers 
    		group by city,gender
    	) b
    where
    	a.city = b.city and
    	a.gender = b.gender and
    	(a.monthsalary * 12 + a.yearbonus) = b.income
    
    #最大
    select a.name,b.income  FROM customers a,
      (
        select
            city,gender,max(monthsalary * 12 + yearbonus) as income
        from
            customers ignore index(idx_gender_city_monthsalary)
        group by city,gender
    ) b
    where
        a.city = b.city and
        a.gender = b.gender and
        (a.monthsalary * 12 + a.yearbonus) = b.income

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM5Mzk5OTY2_size_16_color_FFFFFF_t_70 45][]

**优化思路一：耗时时间：7.263s**

alter table customers1 add index idx_gender_city_name_monthsalary_yearbonus(gender, city, name, monthsalary, yearbonus);

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM5Mzk5OTY2_size_16_color_FFFFFF_t_70 46][]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM5Mzk5OTY2_size_16_color_FFFFFF_t_70 47][] ![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM5Mzk5OTY2_size_16_color_FFFFFF_t_70 48][]

**优化思路二： 耗时时间：6.848s**

alter table customers add index idx_gender_city_monthsalary_yearbonus(gender, city, monthsalary, yearbonus);

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM5Mzk5OTY2_size_16_color_FFFFFF_t_70 49][]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM5Mzk5OTY2_size_16_color_FFFFFF_t_70 50][]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM5Mzk5OTY2_size_16_color_FFFFFF_t_70 51][] 如果使用sql语句优化后仍然不是很理想的情况下，就要考虑分库分表，或者是程序来替代mysql的一些函数运算。（因为mysql函数是无法进行优化的，比如：函数的分组可以通过程序的数组来进行分组等等），以上只是针对这道题所做的一些优化，仅作为参考。

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM5Mzk5OTY2_size_16_color_FFFFFF_t_70]: https://img-blog.csdnimg.cn/20200430111102115.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM5Mzk5OTY2,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM5Mzk5OTY2_size_16_color_FFFFFF_t_70 1]: /images/20230521/2c0a438bc5fb49ba9c7953ee9e126555.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM5Mzk5OTY2_size_16_color_FFFFFF_t_70 2]: /images/20230521/7ec187fd911d4f439fe8e11a24f93ae6.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM5Mzk5OTY2_size_16_color_FFFFFF_t_70 3]: /images/20230521/f41973b08df7443e826542d0dedd9c70.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM5Mzk5OTY2_size_16_color_FFFFFF_t_70 4]: /images/20230521/5a5d739578014d6e84a531930bfc4c65.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM5Mzk5OTY2_size_16_color_FFFFFF_t_70 5]: /images/20230521/19dfd3307fb245f0bade6f136c970967.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM5Mzk5OTY2_size_16_color_FFFFFF_t_70 6]: /images/20230521/6265da2f755648589ae7d0d25aac0c20.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM5Mzk5OTY2_size_16_color_FFFFFF_t_70 7]: /images/20230521/bccdb44c316c45cba00d67ed5fa3c867.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM5Mzk5OTY2_size_16_color_FFFFFF_t_70 8]: /images/20230521/6728a2fbeead485a96aa85a6fdac2a74.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM5Mzk5OTY2_size_16_color_FFFFFF_t_70 9]: /images/20230521/8d3741cb026e4f808706b4cfd7809243.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM5Mzk5OTY2_size_16_color_FFFFFF_t_70 10]: /images/20230521/bdc314c1cd9944a087ea3503011bc770.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM5Mzk5OTY2_size_16_color_FFFFFF_t_70 11]: /images/20230521/09ebf7d723904634a16c27013fef300e.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM5Mzk5OTY2_size_16_color_FFFFFF_t_70 12]: /images/20230521/a3894314e1fe4d878494a51646b01be2.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM5Mzk5OTY2_size_16_color_FFFFFF_t_70 13]: /images/20230521/3e4a6524f0d54bf1a3189ee426a0390f.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM5Mzk5OTY2_size_16_color_FFFFFF_t_70 14]: /images/20230521/90cb9aefc0114068b49f98643dfe6b10.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM5Mzk5OTY2_size_16_color_FFFFFF_t_70 15]: /images/20230521/c80e9643b04043aeaea6c787155abf83.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM5Mzk5OTY2_size_16_color_FFFFFF_t_70 16]: /images/20230521/efc2764faa6245c7aae4978a896ad95d.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM5Mzk5OTY2_size_16_color_FFFFFF_t_70 17]: https://img-blog.csdnimg.cn/20200430123844561.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM5Mzk5OTY2,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM5Mzk5OTY2_size_16_color_FFFFFF_t_70 18]: /images/20230521/faa74bf33bc542cf95790a5f66e83111.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM5Mzk5OTY2_size_16_color_FFFFFF_t_70 19]: /images/20230521/fe9209ee9af64fcfa6f547bf68c58549.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM5Mzk5OTY2_size_16_color_FFFFFF_t_70 20]: https://img-blog.csdnimg.cn/20200430124543771.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM5Mzk5OTY2,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM5Mzk5OTY2_size_16_color_FFFFFF_t_70 21]: /images/20230521/33596fd1c8554bbabd6f86a38d5325b1.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM5Mzk5OTY2_size_16_color_FFFFFF_t_70 22]: /images/20230521/371d4a17ab854ba89bc701569212f4af.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM5Mzk5OTY2_size_16_color_FFFFFF_t_70 23]: /images/20230521/0da75c3a8b6f420cb3cdd28ed19824ad.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM5Mzk5OTY2_size_16_color_FFFFFF_t_70 24]: /images/20230521/52285f89c8d3420387803f9a74941271.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM5Mzk5OTY2_size_16_color_FFFFFF_t_70 25]: /images/20230521/2da8dd3a8b434584ab06f97333e5ad94.png
[20200430130442834.png]: /images/20230521/94abfbaa55ef4393aec919c675b7a460.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM5Mzk5OTY2_size_16_color_FFFFFF_t_70 26]: /images/20230521/a51675cb5aae4eed8498543ed1eb986a.png
[20200430130834274.png]: https://img-blog.csdnimg.cn/20200430130834274.png
[20200430130921996.png]: /images/20230521/b7602b40cb924670bb908320da4f65b2.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM5Mzk5OTY2_size_16_color_FFFFFF_t_70 27]: /images/20230521/fd0648d8f9d640f49fde108691dad4e7.png
[20200430131407906.png]: https://img-blog.csdnimg.cn/20200430131407906.png
[20200430131451852.png]: /images/20230521/78b9bd2d49f240589f8057e6a626d6b6.png
[20200430131904219.png]: /images/20230521/7d2fd3f2856a455f8e7852966abf3142.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM5Mzk5OTY2_size_16_color_FFFFFF_t_70 28]: /images/20230521/06b4eea714e74f6a8a4f6be61702d7fe.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM5Mzk5OTY2_size_16_color_FFFFFF_t_70 29]: /images/20230521/89a93e762ab845e5992de82a42d53880.png
[20200430132715157.png]: /images/20230521/4629ba1ded1e41d5a7095ba5e279f196.png
[20200430132837295.png]: /images/20230521/1ed8d5a705254b7596ce8ee06986ba17.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM5Mzk5OTY2_size_16_color_FFFFFF_t_70 30]: /images/20230521/b5a4b6a0e8224332873c369cf3e409d1.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM5Mzk5OTY2_size_16_color_FFFFFF_t_70 31]: https://img-blog.csdnimg.cn/20200430133531694.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM5Mzk5OTY2,size_16,color_FFFFFF,t_70
[202004301336035.png]: /images/20230521/5ca8eb874143485aa49af3b1991522a4.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM5Mzk5OTY2_size_16_color_FFFFFF_t_70 32]: /images/20230521/7f276924fdc9474bb803d2fd524f0265.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM5Mzk5OTY2_size_16_color_FFFFFF_t_70 33]: /images/20230521/73cee916e22d4fdf83a1a09e251bfe66.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM5Mzk5OTY2_size_16_color_FFFFFF_t_70 34]: /images/20230521/1bf942a87fea47789d66bec0827fa35d.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM5Mzk5OTY2_size_16_color_FFFFFF_t_70 35]: /images/20230521/18b94614ea974df0875478015acb0386.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM5Mzk5OTY2_size_16_color_FFFFFF_t_70 36]: /images/20230521/090eec0d908b452a9bff4a626187c662.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM5Mzk5OTY2_size_16_color_FFFFFF_t_70 37]: /images/20230521/f44b36328121416eaa4ee55b5146ba6c.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM5Mzk5OTY2_size_16_color_FFFFFF_t_70 38]: /images/20230521/55d304b196a54941b04115b043bb5436.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM5Mzk5OTY2_size_16_color_FFFFFF_t_70 39]: https://img-blog.csdnimg.cn/2020043014470311.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM5Mzk5OTY2,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM5Mzk5OTY2_size_16_color_FFFFFF_t_70 40]: /images/20230521/ca5b7a6147b4459dbc456ad85f7c1858.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM5Mzk5OTY2_size_16_color_FFFFFF_t_70 41]: /images/20230521/4e8e1975e974413eaf0f85da705ad3df.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM5Mzk5OTY2_size_16_color_FFFFFF_t_70 42]: /images/20230521/49945fbceefe4d6d8e459af58f3badb6.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM5Mzk5OTY2_size_16_color_FFFFFF_t_70 43]: https://img-blog.csdnimg.cn/20200430145407920.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM5Mzk5OTY2,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM5Mzk5OTY2_size_16_color_FFFFFF_t_70 44]: /images/20230521/d246866a96234fe7b49728c0a6953cda.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM5Mzk5OTY2_size_16_color_FFFFFF_t_70 45]: /images/20230521/6003a7be02f740258a865d93589565c2.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM5Mzk5OTY2_size_16_color_FFFFFF_t_70 46]: /images/20230521/de0b735dda3948f4a47cffb368b429f7.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM5Mzk5OTY2_size_16_color_FFFFFF_t_70 47]: https://img-blog.csdnimg.cn/20200430170348387.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM5Mzk5OTY2,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM5Mzk5OTY2_size_16_color_FFFFFF_t_70 48]: /images/20230521/4de5ef8fa2c04381a963d58958d88dff.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM5Mzk5OTY2_size_16_color_FFFFFF_t_70 49]: /images/20230521/b60f91c7d4304d92ade7e2430433c217.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM5Mzk5OTY2_size_16_color_FFFFFF_t_70 50]: /images/20230521/03f14d92ec68447eb0b59a4f84514937.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM5Mzk5OTY2_size_16_color_FFFFFF_t_70 51]: /images/20230521/c257cea886484ca598fcbcadc11124b5.png