使用with as优化sql解决filter

最新推荐文章于 2020-06-11 11:32:49 发布
最新推荐文章于 2020-06-11 11:32:49 发布
阅读量139 收藏
点赞数
 最近一个地市的报表系统老是说数据出得慢，基本上要到中午才能出数据，但是查看过程是比较简单的。后来发现一条sql有问题，居然要跑5个多小时。

查看跑2个小时以上的sql
SELECT SQ.SQL_TEXT,
S.SQL_ID,
S.SID,
S.SERIAL#,
S.LAST_CALL_ET,
TO_CHAR(S.LOGON_TIME, 'yyyymmdd hh24:mi:ss') LOGON_TIME
FROM V$SESSION S,
V$SQLTEXT SQ
WHERE S.SQL_ID = SQ.SQL_ID AND
LAST_CALL_ET > 10000 AND
TO_CHAR(LOGON_TIME,'yyyymmdd') =TO_CHAR(SYSDATE,'yyyymmdd');


NTERVAL '7' DAY < D.COMPLETE_DT) 4kyzp58tz0xya 232 811 15400 20111110 06:27:38
移机','资费变更') AND A.COMPLETE_DT - I 4kyzp58tz0xya 232 811 15400 20111110 06:27:38
A.BO_ACTION_NAME IN ('新装', ' 4kyzp58tz0xya 232 811 15400 20111110 06:27:38
A.PROD_ID != D.PROD_ID AND 4kyzp58tz0xya 232 811 15400 20111110 06:27:38
ARTY_ID AND A.BO_ID != D.BO_ID AND 4kyzp58tz0xya 232 811 15400 20111110 06:27:38
TAFF_ID LIKE '36%' AND A.PARTY_ID = D.P 4kyzp58tz0xya 232 811 15400 20111110 06:27:38
FROM DW_BO_ORDER D WHERE D.S 4kyzp58tz0xya 232 811 15400 20111110 06:27:38
欢乐送之E6套餐') AND NOT EXISTS (SELECT * 4kyzp58tz0xya 232 811 15400 20111110 06:27:38
'新春欢乐送之E8套餐', '新春 4kyzp58tz0xya 232 811 15400 20111110 06:27:38
) 全省_紧密融合型E9套餐产品规格', 4kyzp58tz0xya 232 811 15400 20111110 06:27:38
紧密融合型E9套餐产品规格', '(新 4kyzp58tz0xya 232 811 15400 20111110 06:27:38
'普通E9','普通新版E8', '全省_ 4kyzp58tz0xya 232 811 15400 20111110 06:27:38
2S','E6移动版', 'E9版1M(老版)', 4kyzp58tz0xya 232 811 15400 20111110 06:27:38
', 'ADSL','LAN', '手机', 'E8 - 4kyzp58tz0xya 232 811 15400 20111110 06:27:38
移机','资费变更') AND B.PROD_SPEC IN ('普通电话 4kyzp58tz0xya 232 811 15400 20111110 06:27:38
D LIKE '36%' AND A.BO_ACTION_NAME IN ('新装',' 4kyzp58tz0xya 232 811 15400 20111110 06:27:38
A.CHANNEL_ID = C.CHANNEL_ID AND A.SO_STAFF_I 4kyzp58tz0xya 232 811 15400 20111110 06:27:38
A WHERE A.PROD_ID = B.PROD_ID AND 4kyzp58tz0xya 232 811 15400 20111110 06:27:38
DW_CRM_DAY_USER B, DW_BO_ORDER 4kyzp58tz0xya 232 811 15400 20111110 06:27:38
A.PROD_ID FROM DW_CHANNEL C, 4kyzp58tz0xya 232 811 15400 20111110 06:27:38
A.SO_STAFF_ID, A.ATOM_ACTION_ID, 4kyzp58tz0xya 232 811 15400 20111110 06:27:38
B.START_DT, A.BO_ACTION_NAME, 4kyzp58tz0xya 232 811 15400 20111110 06:27:38
B.ACCESS_NUMBER, B.PROD_SPEC, 4kyzp58tz0xya 232 811 15400 20111110 06:27:38
CHANNEL_NAME, B.NAME PARTY_NAME, 4kyzp58tz0xya 232 811 15400 20111110 06:27:38
B.AREA_NAME, C.NAME 4kyzp58tz0xya 232 811 15400 20111110 06:27:38
SELECT B.AREA_ID, A.PARTY_ID, 4kyzp58tz0xya 232 811 15400 20111110 06:27:38
CREATE TABLE TMP_DTBB_FMT_10000_1 NOLOGGING AS 4kyzp58tz0xya 232 811 15400 20111110 06:27:38

找到的sql为如下：

SELECT
B.AREA_ID,
A.PARTY_ID,
B.AREA_NAME,
C.NAME CHANNEL_NAME,
B.NAME PARTY_NAME,
B.ACCESS_NUMBER,
B.PROD_SPEC,
B.START_DT,
A.BO_ACTION_NAME,
A.SO_STAFF_ID,
A.ATOM_ACTION_ID,
A.PROD_ID
FROM DW_CHANNEL C,
DW_CRM_DAY_USER B,
DW_BO_ORDER A
WHERE A.PROD_ID = B.PROD_ID AND
A.CHANNEL_ID = C.CHANNEL_ID AND
A.SO_STAFF_ID LIKE '36%' AND
A.BO_ACTION_NAME IN ('新装','移机','资费变更') AND
B.PROD_SPEC IN ('普通电话', 'ADSL','LAN', '手机',
'E8 - 2S','E6移动版', 'E9版1M(老版)',
'普通E9','普通新版E8',
'全省_紧密融合型E9套餐产品规格',
'(新) 全省_紧密融合型E9套餐产品规格',
'新春欢乐送之E8套餐',
'新春欢乐送之E6套餐') AND
NOT EXISTS (SELECT *
FROM DW_BO_ORDER D
WHERE D.STAFF_ID LIKE '36%' AND
A.PARTY_ID = D.PARTY_ID AND
A.BO_ID != D.BO_ID AND
A.PROD_ID != D.PROD_ID AND
A.BO_ACTION_NAME IN
('新装', '移机','资费变更') AND
A.COMPLETE_DT - INTERVAL '7' DAY < D.COMPLETE_DT)
下面根据sql语句去查找相关的session，发现该语句已经跑了将近4个小时，从早上6点多开始跑。

SQL> SELECT S.SQL_ID,to_char(S.LOGON_TIME,'yyyymmdd hh24:mi:ss') LOGON_TIME,S.LAST_CALL_ET,S.STATE FROM V$SESSION S WHERE S.SID=232;

SQL_ID LOGON_TIME LAST_CALL_ET STATE
------------- ----------------- ------------ -------------------
4kyzp58tz0xya 20111110 06:27:38 13647 WAITED SHORT TIME

SQL> select 13647/3600 from dual;

13647/3600
----------
3.79083333

SQL> select to_char(sysdate,'yyyymmdd hh24:mi:ss') sysdat from dual;

SYSDAT
-----------------
20111110 10:18:39

OK，现在知道导致数据出的慢的原因,现在就开始来优化这条sql，首先收集一下统计图，然后看执行计划

BEGIN
DBMS_STATS.GATHER_TABLE_STATS(ownname => 'LBAS',
tabname => 'DW_BO_ORDER',
estimate_percent => 20,
method_opt => 'for all columns size auto',
no_invalidate => FALSE,
degree => 4,
granularity => 'ALL',
cascade => TRUE);
END;
/

Plan hash value: 2142862569 ---------------------------------------------------------------------------------------------------------- | Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time | Pstart| Pstop | ---------------------------------------------------------------------------------------------------------- | 0 | SELECT STATEMENT | | 905 | 121K| 4152K (2)| 13:50:32 | | | |* 1 | FILTER | | | | | | | | |* 2 | HASH JOIN | | 905 | 121K| 12616 (2)| 00:02:32 | | | |* 3 | HASH JOIN | | 905 | 99550 | 12448 (2)| 00:02:30 | | | | 4 | PARTITION RANGE ALL| | 1979 | 108K| 9168 (2)| 00:01:51 | 1 | 5 | |* 5 | TABLE ACCESS FULL | DW_BO_ORDER | 1979 | 108K| 9168 (2)| 00:01:51 | 1 | 5 | |* 6 | TABLE ACCESS FULL | DW_CRM_DAY_USER | 309K| 15M| 3277 (2)| 00:00:40 | | | | 7 | TABLE ACCESS FULL | DW_CHANNEL | 48425 | 1276K| 168 (1)| 00:00:03 | | | |* 8 | FILTER | | | | | | | | | 9 | PARTITION RANGE ALL | | 1 | 29 | 9147 (2)| 00:01:50 | 1 | 5 | |* 10 | TABLE ACCESS FULL | DW_BO_ORDER | 1 | 29 | 9147 (2)| 00:01:50 | 1 | 5 | ---------------------------------------------------------------------------------------------------------- Predicate Information (identified by operation id): --------------------------------------------------- 1 - filter( NOT EXISTS (SELECT /*+ */ 0 FROM "DW_BO_ORDER" "D" WHERE ( :B1 = '新装' OR :B2 = '移机' OR :B3 = '资费变更' ) AND "D"."PARTY_ID"=:B4 AND TO_CHAR("D"."STAFF_ID") LIKE '36%' AND "D"."COMPLETE_DT" > :B5-INTERVAL'+07 00:00:00' DAY(2) TO SECOND(0) AND "D"."PROD_ID" < > :B6 AND "D"."BO_ID" < > :B7)) 2 - access("A"."CHANNEL_ID"="C"."CHANNEL_ID") 3 - access("A"."PROD_ID"="B"."PROD_ID") 5 - filter("A"."PROD_ID" IS NOT NULL AND ("A"."BO_ACTION_NAME"='新装' OR "A"."BO_ACTION_NAME"='移机' OR "A"."BO_ACTION_NAME"='资费变更') AND TO_CHAR("A"."SO_STAFF_ID") LIKE '36%') 6 - filter("B"."PROD_SPEC"='(新) 全省_紧密融合型E9套餐产品规格' OR "B"."PROD_SPEC"='ADSL' OR "B"."PROD_SPEC"='E6移动版' OR "B"."PROD_SPEC"='E8 - 2S' OR "B"."PROD_SPEC"='E9版1M(老版)' OR "B"."PROD_SPEC"='LAN' OR "B"."PROD_SPEC"='普通E9' OR "B"."PROD_SPEC"='普通电话' OR "B"."PROD_SPEC"='普通新版E8' OR "B"."PROD_SPEC"='全省_紧密融合型E9套餐产品规格' OR "B"."PROD_SPEC"='手机' OR "B"."PROD_SPEC"='新春欢乐送之E6套餐' OR "B"."PROD_SPEC"='新春欢乐送之E8套餐') 8 - filter( :B1 = '新装' OR :B2 = '移机' OR :B3 = '资费变更' ) 10 - filter("D"."PARTY_ID"=:B1 AND TO_CHAR("D"."STAFF_ID") LIKE '36%' AND "D"."COMPLETE_DT" > :B2-INTERVAL'+07 00:00:00' DAY(2) TO SECOND(0) AND "D"."PROD_ID" < > :B3 AND "D"."BO_ID" < > :B4)

执行计划里面有个filter在里面，这个是导致这条sql跑的慢的原因。主要语句就是在not exists 里面居然存在!=， 哎，这sql语句写得真坑爹，由于有!=的存在，CBO不能选择 HASH_AJ join的方式，准备修改sql语句，但是不管怎么改，业务逻辑总不对，最后的结果也不对。得想办法吧filter搞掉，加多种hint，最后的结果还是一样的，在朋友的帮下，最后使用了了with as. good最后居然实现了在12秒以内出数据。下面看一下

WITH D AS
(SELECT /*+ materialize */
A.PARTY_ID,
A.BO_ID,
A.PROD_ID,
A.COMPLETE_DT
FROM DW_BO_ORDER A
WHERE STAFF_ID LIKE '36%' AND
A.BO_ACTION_NAME IN ('新装',
'移机',
'资费变更'))
SELECT B.AREA_ID,
A.PARTY_ID,
B.AREA_NAME,
C.NAME CHANNEL_NAME,
B.NAME PARTY_NAME,
B.ACCESS_NUMBER,
B.PROD_SPEC,
B.START_DT,
A.BO_ACTION_NAME,
A.SO_STAFF_ID,
A.ATOM_ACTION_ID,
A.PROD_ID
FROM DW_CHANNEL C,
DW_CRM_DAY_USER B,
DW_BO_ORDER A
WHERE A.PROD_ID = B.PROD_ID AND
A.CHANNEL_ID = C.CHANNEL_ID AND
A.SO_STAFF_ID LIKE '36%' AND
A.BO_ACTION_NAME IN ('新装',
'移机',
'资费变更') AND
B.PROD_SPEC IN ('普通电话',
'ADSL',
'LAN',
'手机',
'E8 - 2S',
'E6移动版',
'E9版1M(老版)',
'普通E9',
'普通新版E8',
'全省_紧密融合型E9套餐产品规格',
'(新) 全省_紧密融合型E9套餐产品规格',
'新春欢乐送之E8套餐',
'新春欢乐送之E6套餐') AND
NOT EXISTS (SELECT *
FROM D
WHERE A.PARTY_ID = D.PARTY_ID AND
A.BO_ID != D.BO_ID AND
A.PROD_ID != D.PROD_ID AND
A.COMPLETE_DT - INTERVAL '7'
DAY < D.COMPLETE_DT);

已用时间: 00: 00: 12.37 执行计划 -------------------------------------------------------------------------------------------------------------------------- Plan hash value: 2591883460 -------------------------------------------------------------------------------------------------------------------------- | Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time | Pstart| Pstop | -------------------------------------------------------------------------------------------------------------------------- | 0 | SELECT STATEMENT | | 905 | 121K| 62428 (2)| 00:12:30 | | | | 1 | TEMP TABLE TRANSFORMATION | | | | | | | | | 2 | LOAD AS SELECT | DW_BO_ORDER | | | | | | | | 3 | PARTITION RANGE ALL | | 114K| 3228K| 9127 (2)| 00:01:50 | 1 | 5 | |* 4 | TABLE ACCESS FULL | DW_BO_ORDER | 114K| 3228K| 9127 (2)| 00:01:50 | 1 | 5 | |* 5 | FILTER | | | | | | | | |* 6 | HASH JOIN | | 905 | 121K| 12616 (2)| 00:02:32 | | | |* 7 | HASH JOIN | | 905 | 99550 | 12448 (2)| 00:02:30 | | | | 8 | PARTITION RANGE ALL | | 1979 | 108K| 9168 (2)| 00:01:51 | 1 | 5 | |* 9 | TABLE ACCESS FULL | DW_BO_ORDER | 1979 | 108K| 9168 (2)| 00:01:51 | 1 | 5 | |* 10 | TABLE ACCESS FULL | DW_CRM_DAY_USER | 309K| 15M| 3277 (2)| 00:00:40 | | | | 11 | TABLE ACCESS FULL | DW_CHANNEL | 48425 | 1276K| 168 (1)| 00:00:03 | | | |* 12 | FILTER | | | | | | | | |* 13 | VIEW | | 114K| 6791K| 90 (3)| 00:00:02 | | | | 14 | TABLE ACCESS FULL | SYS_TEMP_0FD9D662E_D625B872 | 114K| 3228K| 90 (3)| 00:00:02 | | | -------------------------------------------------------------------------------------------------------------------------- Predicate Information (identified by operation id): --------------------------------------------------- 4 - filter(TO_CHAR("STAFF_ID") LIKE '36%') 5 - filter( NOT EXISTS (SELECT /*+ */ 0 FROM (SELECT /*+ CACHE_TEMP_TABLE ("T1") */ "C0" "STAFF_ID","C1" "PARTY_ID","C2" "BO_ID","C3" "PROD_ID","C4" "COMPLETE_DT" FROM "SYS"."SYS_TEMP_0FD9D662E_D625B872" "T1") "D" WHERE ( :B1 = '新装' OR :B2 = '移机' OR :B3 = '资费变更' ) AND TO_CHAR("D"."STAFF_ID") LIKE '36%' AND "D"."PARTY_ID"=:B4 AND "D"."BO_ID" < > :B5 AND "D"."PROD_ID" < > :B6 AND "D"."COMPLETE_DT" > :B7-INTERVAL'+07 00:00:00' DAY(2) TO SECOND(0))) 6 - access("A"."CHANNEL_ID"="C"."CHANNEL_ID") 7 - access("A"."PROD_ID"="B"."PROD_ID") 9 - filter("A"."PROD_ID" IS NOT NULL AND ("A"."BO_ACTION_NAME"='新装' OR "A"."BO_ACTION_NAME"='移机' OR "A"."BO_ACTION_NAME"='资费变更') AND TO_CHAR("A"."SO_STAFF_ID") LIKE '36%') 10 - filter("B"."PROD_SPEC"='(新) 全省_紧密融合型E9套餐产品规格' OR "B"."PROD_SPEC"='ADSL' OR "B"."PROD_SPEC"='E6移动版' OR "B"."PROD_SPEC"='E8 - 2S' OR "B"."PROD_SPEC"='E9版1M(老版)' OR "B"."PROD_SPEC"='LAN' OR "B"."PROD_SPEC"='普通E9' OR "B"."PROD_SPEC"='普通电话' OR "B"."PROD_SPEC"='普通新版E8' OR "B"."PROD_SPEC"='全省_紧密融合型E9套餐产品规格' OR "B"."PROD_SPEC"='手机' OR "B"."PROD_SPEC"='新春欢乐送之E6套餐' OR "B"."PROD_SPEC"='新春欢乐送之E8套餐') 12 - filter( :B1 = '新装' OR :B2 = '移机' OR :B3 = '资费变更' ) 13 - filter(TO_CHAR("D"."STAFF_ID") LIKE '36%' AND "D"."PARTY_ID"=:B1 AND "D"."BO_ID" < > :B2 AND "D"."PROD_ID" < > :B3 AND "D"."COMPLETE_DT" > :B4-INTERVAL'+07 00:00:00' DAY(2) TO SECOND(0)) 统计信息 ---------------------------------------------------------- 2 recursive calls 29 db block gets 110506 consistent gets 22 physical reads 656 redo size 2438096 bytes sent via SQL*Net to client 449 bytes received via SQL*Net from client 11 SQL*Net roundtrips to/from client 0 sorts (memory) 0 sorts (disk) 49245 rows processed

问题解决啦，这次过程中也学到了很多东西。

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/28673746/viewspace-757815/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/28673746/viewspace-757815/

cjl421391196
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
利用FILTER特性优化SQL
zhaoyangjian724的专栏
08-11 851
SELECT A.CARDOFBANK, A.CARD_NO, to_char(A.TRANS_DATE, 'YYYY-MM-DD') , decode(A.TRANS_CODE, '111019', 0, A.TRANS_AMT), A.FEE_AMT ,
SQL优化-Filter正名
songjian1104的专栏
10-20 472
之前我写过一篇博客分析Filter也有性能好的一面，最近看了一下，感觉说的不够浅显易懂，这里再写一篇。 之前博客链接： https://blog.csdn.net/songjian1104/article/details/98325658 1 数据准备 drop table emp1; drop table dept1; create table emp1 as select * fr...
SQL优化 第八章 案例模拟 8.3 FILTER优化1
songjian1104的专栏
06-14 192
8.3.1 数据环境准备 drop table test1; drop table test2; drop table test3; create table test1 as select * from dba_objects; create table test2 as select * from test1; create table test3 as select * from...
SQL优化 第七章 查询转换 4 Filter转换
songjian1104的专栏
06-09 464
参考资料： 本系列博客主要参考资料有CUUG冉乃纲老师数据库教学笔记，《SQL优化核心思想》（罗炳森，黄超，钟侥著），《PostgreSQL技术内幕：查询优化深度探索》（张树杰著），排名不分先后。 4 Filter转换 4.1 环境准备 create table tests1 as select * from dba_objects; create table tests2 as s...
Exam Ref 70-761 Querying Data with Transact-SQL
04-12
• Assumes you have experience working with SQL Server as a database administrator, system engineer, or developer • Includes downloadable sample database and code for SQL Server 2016 SP1 (or later) ...
jeesql：使用SQL的Clojure库
01-28
**jeesql：使用SQL的Clojure库** `jeesql`是一个专为Clojure设计的库，旨在简化SQL查询的处理，同时充分利用Clojure的灵活性和表达力。这个库的核心理念是提供一种自然的方式，将SQL语句与Clojure的数据结构结合，...
微软内部资料-SQL性能优化3
11-27
 Differentiate locks, latches, and other SQL Server internal “locking” mechanism such as spinlocks and other synchronization objects. Recommended Reading  Chapter 14 “Locking”, Inside SQL ...
Sql Server 2016新功能之Row-Level Security(值得关注)
09-09
RETURNS TABLE WITH SCHEMABINDING AS RETURN SELECT 1 AS fn_securitypredicate_result WHERE @SalesRep = USER_NAME() OR USER_NAME() = 'Manager'; ``` 创建一个安全策略`SalesFilter`，并将`fn_...
MySQL慢查询查找和调优测试
12-15
此外，还可以使用以下SQL语句来检查当前数据库中哪些索引可能没有得到充分利用。这个查询会列出索引的选择性，选择性高的索引对于区分度较高的数据更有价值： ```sql SELECT t.TABLE_SCHEMA AS `db`, t.TABLE_NAME ...
使用WITH语法优化SQL一则
youyonghu001的专栏
04-21 555
对应SQL中重复执行的部分，可以使用WITH语法进行优化
SQL-- WITH AS（查询复杂数据后还要做筛选处理）
qq_36766417的博客
06-11 562
【用途及定义】 当查询结构复杂，多次重用一个子查询sql导致重复冗余时使用，将子查询语句独立出来，可以看作一种赋值用法 ORACLE,SQL SERVER,HIVE等均可使用，MYSQL8.0后做了优化，也可使用 【特点】 存储到用户临时表空间，一次分析，多次使用 增强可读性，解耦，优化查询效率的方式之一 【实现】 WITH AAA AS ( SELECT COALESCE(A.student_name,'空') sname, COALESCE(B.t
再一次利用with as 优化SQL
热门推荐
落落的专栏 专注SQL调优 性能调优
01-09 1万+
上海的一个哥们问我有个SQL跑了4个小时都没跑完，实在受不了了，找我优化一下。我确实挺佩服他的，要是我遇到跑了几分钟的，就受不了了。 SQL语句和执行计划如下： --sql id：1qbbw3th4x8yc SELECT "VOUCHER".FID "ID", "ENTRIES".FID "ENTRIES.ID", "ENTRIES".FEntryD
SQL优化之FILTER
zhaoyangjian724的专栏
06-26 2310
select count(1) over() as tcnt, rownum as rn, O.CustomerID, O.CustomerName, O.CustomerType, O.CertType, O.CertID, O.MFCustomerID, O.MCCustomer...
SQL 中With as 的用法
weixin_30832983的博客
04-09 1290
一．WITH AS的含义 WITH AS短语，也叫做子查询部分（subquery factoring），可以让你做很多事情，定义一个SQL片断，该SQL片断会被整个SQL语句所用到。有的时候，是为了让SQL语句的可读性更高些，也有可能是在UNION ALL的不同部分，作为提供数据的部分。 特别对于UNION ALL比较有用。因为UNION ALL的每个部分可能相同，但是如果每个部分都去执...
postgresql-with as处理子查询速度慢的问题
qxianx的博客
03-28 5845
在数据库查询过程中，有时候我们会遇到一些对聚合函数的结果进行过滤的情况，如果这个聚合函数本身又是个子查询获得的结果，这个时候再把它作为 一个where 条件语句的话，会导致查询效率极其的差。而通过with as 语法先把它“暂存”一下速度则会快很多。 基本用例如下： 1 我想做一个错题统计，先把错题ID和错题数查询出来 select info.answerexeid AS exeid,...
优化案例1---用分析函数优化优化执行计划中的FILTER以及标量子查询
伊文硕--Oracle的博客
05-02 4728
今天在餐饮前端库抓出一条跑的很慢的分页语句，分页语句里没有对主表group by 这些禁忌，但是还跑6秒才跑完，逻辑读大概有  735634个buffers，立马给优化了一下。 SQL 语句如下：  SELECT * FROM (SELECT (SELECT COUNT(1) FROM cy_product_sku ps
sql contains
最新发布
04-03
It is typically used in conjunction with the WHERE clause to filter the results of a query. The syntax for using the contains keyword in SQL varies depending on the specific database management ...

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值