{"Message":"只能向已回复授权信息的手机号发送","RequestId":"517D6BDF-9A27-5F55-B5A3-55BDA2F308DD","Code":"isv.SMS_TEST_NUMBER_LIMIT"}
时间: 2023-08-21 08:08:25 浏览: 70
根据您提供的引用内容,UTF-8是一种变长字符编码,用于将UNICODE字符编码成1到6个字节。如果一个UNICODE字符由2个字节表示,那么编码成UTF-8很可能需要3个字节;如果一个UNICODE字符由4个字节表示,那么编码成UTF-8可能需要6个字节。然而,使用4个或6个字节去编码一个UNICODE字符的情况非常少见。<span class="em">1</span><span class="em">2</span>
#### 引用[.reference_title]
- *1* *2* [UTF-8编码表](https://blog.csdn.net/XiaoXiaoPengBo/article/details/71170371)[target="_blank" data-report-click={"spm":"1018.2226.3001.9630","extra":{"utm_source":"vip_chatgpt_common_search_pc_result","utm_medium":"distribute.pc_search_result.none-task-cask-2~all~insert_cask~default-1-null.142^v92^chatsearchT0_1"}}] [.reference_item style="max-width: 100%"]
[ .reference_list ]
相关问题
10.3.3.120.bsquare-voip > node1.pcsync-https: Flags [S], cksum 0x517d (correct), seq 1390706576, win 64240, options [mss 1200,nop,wscale 8,nop,nop,sackOK], length
这是一条tcpdump捕获的数据包。以下是对这条数据包的解释:
- `10.3.3.120.bsquare-voip > node1.pcsync-https`:源IP地址为 `10.3.3.120` 的 `bsquare-voip` 向目标IP地址为 `node1` 的 `pcsync-https` 发送数据包。
- `Flags [S]`:标志位,表示这是一个SYN(同步)数据包。
- `cksum 0x517d (correct)`:数据包校验和,用于检测数据包是否损坏。
- `seq 1390706576`:序列号,表示这个数据包的序列号。
- `win 64240`:窗口大小,表示发送方还能发送多少数据。
- `options [mss 1200,nop,wscale 8,nop,nop,sackOK]`:选项字段,包含了一些扩展信息,如最大分段大小(MSS)、窗口缩放因子(WS)等。
- `length`:数据包长度,表示这个数据包的长度。
需要注意的是,这条数据包仅供参考,具体含义还需要结合上下文来分析。
帮我优化这个sql select sum(case when b.id_Dep_Pi_Out = '60877de521997e2901a929a1' and b.SD_CHANGE_CD in ('1', '6') and (b.id_Org_In = b.id_Org or b.id_Org_In is null) then 1 else 0 end) depOutNum, SUM(case when b.SD_CHANGE_CD in '2' and (b.id_Org_In = b.id_Org or b.id_Org_In is null) and b.id_Dep_In in ('6045e4ffd0081238ab9c034f', '6045e517d0081238ab9c1d6d', '60d29a646f58d164c48a29fa', '60877e4d21997e2901a983de', '60866c4221997e105b5f3ea2', '60877e6821997e2901a9981e', '6045e46dd0081238ab9ba5c0', '6440d7f893bb71aa979322dc', '6045e57ad0081238ab9c6225') and (b.id_Dep_Pi_In = '60877de521997e2901a929a1' or b.id_Dep_Pi_In is null) then 1 else 0 end) depInNum, SUM(case when b.SD_CHANGE_CD in '2' and b.id_Org_In != b.id_Org and b.id_Dep_In in ('6045e4ffd0081238ab9c034f', '6045e517d0081238ab9c1d6d', '60d29a646f58d164c48a29fa', '60877e4d21997e2901a983de', '60866c4221997e105b5f3ea2', '60877e6821997e2901a9981e', '6045e46dd0081238ab9ba5c0', '6440d7f893bb71aa979322dc', '6045e57ad0081238ab9c6225') and (b.id_Dep_Pi_In = '60877de521997e2901a929a1' or b.id_Dep_Pi_In is null) then 1 else 0 end) orgDepInNum from Hi_Hpl_Med_Ord a join Hi_Hpl_Med_Ord_Chndep b on a.id_Medord = b.id_Medord where b.SD_CHANGE_CD in ('2','1', '6') and a.delete_Flag = '0' and a.sd_Medordsta_Cd in '31' and b.id_Org = '6045d1b8d0081238ab92050a'
这个SQL语句的主要性能瓶颈在于三个SUM函数,每个SUM函数都包含了很复杂的CASE语句,而且这些CASE语句中还有很多重复的条件判断。为了优化这个SQL语句,可以考虑以下几个方面:
1. 尽量避免复杂的CASE语句。可以通过使用JOIN子句来筛选需要的数据,然后再对这些数据进行SUM操作。
2. 尽量避免重复的条件判断。可以将一些重复的条件抽象出来,放在WHERE子句中,避免在CASE语句中重复判断。
3. 尽量避免使用OR条件。OR条件会导致查询优化器无法使用索引,从而导致查询性能下降。可以将OR条件转换为IN条件来优化查询。
4. 尽量避免在WHERE子句中使用函数或表达式。这些操作会导致查询优化器无法使用索引,从而导致查询性能下降。
基于以上优化原则,可以重写这个SQL语句如下:
```
SELECT SUM(depOutNum) AS depOutNum,
SUM(depInNum) AS depInNum,
SUM(orgDepInNum) AS orgDepInNum
FROM (
SELECT CASE WHEN b.id_Dep_Pi_Out = '60877de521997e2901a929a1'
AND b.SD_CHANGE_CD IN ('1', '6')
AND (b.id_Org_In = b.id_Org OR b.id_Org_In IS NULL)
THEN 1
ELSE 0
END AS depOutNum,
CASE WHEN b.SD_CHANGE_CD IN ('2', '1', '6')
AND (b.id_Org_In = b.id_Org OR b.id_Org_In IS NULL)
AND b.id_Dep_In IN ('6045e4ffd0081238ab9c034f', '6045e517d0081238ab9c1d6d',
'60d29a646f58d164c48a29fa', '60877e4d21997e2901a983de',
'60866c4221997e105b5f3ea2', '60877e6821997e2901a9981e',
'6045e46dd0081238ab9ba5c0', '6440d7f893bb71aa979322dc',
'6045e57ad0081238ab9c6225')
AND (b.id_Dep_Pi_In = '60877de521997e2901a929a1' OR b.id_Dep_Pi_In IS NULL)
THEN 1
ELSE 0
END AS depInNum,
CASE WHEN b.SD_CHANGE_CD IN ('2', '1', '6')
AND b.id_Org_In != b.id_Org
AND b.id_Dep_In IN ('6045e4ffd0081238ab9c034f', '6045e517d0081238ab9c1d6d',
'60d29a646f58d164c48a29fa', '60877e4d21997e2901a983de',
'60866c4221997e105b5f3ea2', '60877e6821997e2901a9981e',
'6045e46dd0081238ab9ba5c0', '6440d7f893bb71aa979322dc',
'6045e57ad0081238ab9c6225')
AND (b.id_Dep_Pi_In = '60877de521997e2901a929a1' OR b.id_Dep_Pi_In IS NULL)
THEN 1
ELSE 0
END AS orgDepInNum
FROM Hi_Hpl_Med_Ord a
JOIN Hi_Hpl_Med_Ord_Chndep b ON a.id_Medord = b.id_Medord
WHERE b.SD_CHANGE_CD IN ('2', '1', '6')
AND a.delete_Flag = '0'
AND a.sd_Medordsta_Cd IN ('31')
AND b.id_Org = '6045d1b8d0081238ab92050a'
AND b.id_Dep_In IN ('6045e4ffd0081238ab9c034f', '6045e517d0081238ab9c1d6d',
'60d29a646f58d164c48a29fa', '60877e4d21997e2901a983de',
'60866c4221997e105b5f3ea2', '60877e6821997e2901a9981e',
'6045e46dd0081238ab9ba5c0', '6440d7f893bb71aa979322dc',
'6045e57ad0081238ab9c6225')
)
```
这个重写后的SQL语句遵循了以上的优化原则,通过使用子查询和简化的CASE语句来实现了相同的功能,并且可以更好地利用索引来提高查询的性能。
相关推荐
![zip](https://img-home.csdnimg.cn/images/20210720083736.png)
![zip](https://img-home.csdnimg.cn/images/20210720083736.png)
![doc](https://img-home.csdnimg.cn/images/20210720083327.png)
![zip](https://img-home.csdnimg.cn/images/20210720083736.png)
![whl](https://img-home.csdnimg.cn/images/20210720083646.png)
![zip](https://img-home.csdnimg.cn/images/20210720083736.png)
![zip](https://img-home.csdnimg.cn/images/20210720083736.png)
![rar](https://img-home.csdnimg.cn/images/20210720083606.png)
![7z](https://img-home.csdnimg.cn/images/20210720083312.png)
![7z](https://img-home.csdnimg.cn/images/20210720083312.png)
![zip](https://img-home.csdnimg.cn/images/20210720083736.png)
![zip](https://img-home.csdnimg.cn/images/20210720083736.png)
![rar](https://img-home.csdnimg.cn/images/20210720083606.png)
![rar](https://img-home.csdnimg.cn/images/20210720083606.png)
![zip](https://img-home.csdnimg.cn/images/20210720083736.png)