查看时间戳类型的绑定变量

逃离我推掉我的手 2023-01-17 10:45 157阅读 0赞

当我们需要找到某条使用绑定变量的SQL语句中具体用到的参数值时，通常会使用v$sql\_bind\_capture视图，如果是字符串类型的变量，直接检索即可，

select sql_id, name, position, datatype_string, last_captured, value_string 
      from v$sql_bind_capture
     where sql_id='&sql_id';

测试过程如下，

SQL> create table test(c1 varchar2(1), c2 date, c3 timestamp);
    Table created.
    
    
    SQL> var x1 varchar2(1)
    SQL> exec :x1 := 1
    PL/SQL procedure successfully completed.
    
    
    SQL> select * from test where c1 = :x1;
    no rows selected
    
    
    SQL> set serveroutput on
    
    
    SQL> exec sys.print_table('select sql_id, name, position, datatype_string, last_captured, value_string from v$sql_bind_capture where sql_id=''9acwyk91jxtm4''');
    SQL_ID                        : 9acwyk91jxtm4
    NAME                          : :X1
    POSITION                      : 1
    DATATYPE_STRING               : VARCHAR2(32)
    LAST_CAPTURED                 : 20-apr-2021 21:16:13
    VALUE_STRING                  : 1
    -----------------
    PL/SQL procedure successfully completed.

默认情况，每隔15分钟，会自动采集一次变量值，显示在这个v$sql\_bind\_capture，这是受隐藏参数\_cursor\_bind\_capture\_interval的控制，默认取值900秒=15分钟，dba\_hist\_sqlbind则是从v$sql\_bind\_capture采集的，可以检索历史绑定变量的信息，

![af82d84e7dac880ab7099f72950b5bd6.png][]

另外从《[v$和v\_$的一些玄机][v_v]》和《[同名的同义词和视图解惑][Link 1]》我们知道在Oracle中数据字典定义的名称，还是存在玄机的，v$sql\_bind\_capture其实是个同义词，他的基表是v\_$sql\_bind\_capture，其实是张视图，

SQL> select object_name, object_type from dba_objects where object_name in (upper('v$sql_bind_capture'),upper('v_$sql_bind_capture'),upper('o$sql_bind_capture'));
    OBJECT_NAME               OBJECT_TYPE
    ------------------------- -------------------
    V_$SQL_BIND_CAPTURE       VIEW
    V$SQL_BIND_CAPTURE        SYNONYM

v\_$sql\_bind\_capture又是来自于o$sql\_bind\_capture，环环相扣，

create or replace view sys.v_$sql_bind_capture as
    select "ADDRESS","HASH_VALUE","SQL_ID","CHILD_ADDRESS","CHILD_NUMBER","NAME","POSITION","DUP_POSITION","DATATYPE","DATATYPE_STRING","CHARACTER_SID","PRECISION","SCALE","MAX_LENGTH","WAS_CAPTURED","LAST_CAPTURED","VALUE_STRING","VALUE_ANYDATA" from o$sql_bind_capture;

可能有些扯远了，刚才说到了绑定变量类型值的查看，如果碰到传入参数类型为时间戳时，用如上的SQL，得到的可能就是一个空值。

P.S. 这里说的时间戳，指的是Timestamp，不是Date。

因为在sqlplus下不能定义日期类型的变量，不好模拟绑定变量的情况，

![14cabe7c3bce4b0d402d05fa37302eaf.png][]

我们在Java中，模拟传入一个Timestamp类型的绑定变量的场景，

Timestamp c1 = new Timestamp(new java.util.Date().getTime());
    Class.forName("oracle.jdbc.driver.OracleDriver");
    Connection conn = DriverManager.getConnection(url, name, password);
    String sql = "select /*+ test */ * from test where c3 = ?";
    PreparedStatement ps = conn.prepareStatement(sql);
    ps.setTimestamp(1, c1);
    ResultSet rs = ps.executeQuery();

P.S. 如果模拟的是Date类型变量，可以将上述1和6行改为如下，

java.sql.Date c1 = new java.sql.Date(new java.util.Date().getTime());
    ...
    ps.setDate(1, c1);

此时执行v$sql\_bind\_capture的检索，value\_string确实是空的，

SQL> exec sys.print_table('select sql_id, name, position, datatype_string, last_captured, value_string from v$sql_bind_capture where sql_id=''8d09fh0d9hf1x''');
    SQL_ID                        : 8d09fh0d9hf1x
    NAME                          : :1
    POSITION                      : 1
    DATATYPE_STRING               : TIMESTAMP
    LAST_CAPTURED                 : 20-apr-2021 14:20:09
    VALUE_STRING                  :
    -----------------
    PL/SQL procedure successfully completed.

需要在上述SQL中，增加一些条件，利用了ANYDATA的accesstimestamp函数，如下所示，才可看到Timestamp类型的绑定变量值，

SQL> SELECT SQL_ID,NAME, POSITION, datatype_string, max_length, value_string, DUMP (value_anydata), ANYDATA.accesstimestamp (value_anydata)
           FROM v$sql_bind_capture a
          WHERE a.value_string IS NULL AND a.value_anydata IS NOT NULL AND datatype_string = 'TIMESTAMP' and sql_id='8d09fh0d9hf1x';
    SQL_ID        NAME         POSITION DATATYPE_STRING MAX_LENGTH VALUE_STRING    DUMP(VALUE_ANYDATA)                                     ANYDATA.ACCESSTIMESTAMP(VALUE_ANYDATA)
    ------------- ---------- ---------- --------------- ---------- --------------- ------------------------------------------------------- ---------------------------------------------------------------------------
    8d09fh0d9hf1x :1                  1 TIMESTAMP               11                 Typ=58 Len=25: 128,214,252,11,0,0,0,0,112,138,241,129,1 20-APR-21 02.20.08.857000000 PM
                                                                                   08,127,0,0,24,75,226,129,108,127,0,0,16

究其原因，MOS(444551.1)指出这是一个bug，在12c上才修复，

> This is due to Bug 6156624 which is fixed in 12c.  The "bug" is that binds are not converted into a string for the value\_string column.

因此，在12c前，要看到Timestamp类型绑定变量参数的值，就得依靠ANYDATA，我们是可以从《PL/SQL Packages and Types Reference》找到对这个ANADATA的介绍，

> An ANYDATA TYPE contains an instance of a given type, plus a description of the type. In this sense, an ANYDATA is self-describing. An ANYDATA can be persistently stored in the database.
> 
>   
> Access functions are available based on SQL. These functions do not throw exceptions on type-mismatch. Instead, they return NULL if the type of the ANYDATA does not correspond to the type of access. If you wish to use only ANYDATA functions of the appropriate types returned in a query, you should use a WHERE clause which uses GETTYPENAME and choose the type you are interested in (say "SYS.NUMBER"). Each of these functions returns the value of a specified datatype inside a SYS.ANYDATA wrapper.

他包含了如下这些函数，

![2258f9de0ac9ac6d587fabfd73c58c0a.png][]

ANYDATA是一种Type类型，可以看下定义，但说实话，Type这种数据库对象，至少对我来说，确实很少接触，

SQL> exec sys.print_table('select * from dba_types where owner=''SYS'' and type_name=''ANYDATA''');
    OWNER              : SYS
    TYPE_NAME          : ANYDATA
    TYPE_OID           : 00000000000000000000000000020011
    TYPECODE           : ANYDATA
    ATTRIBUTES         : 0
    METHODS            : 95
    PREDEFINED         : NO
    INCOMPLETE         : NO
    FINAL              : YES
    INSTANTIABLE       : YES
    PERSISTABLE        : YES
    SUPERTYPE_OWNER    :
    SUPERTYPE_NAME     :
    LOCAL_ATTRIBUTES   :
    LOCAL_METHODS      :
    TYPEID             :
    -----------------
    
    
    PL/SQL procedure successfully completed.

v$sql\_bind\_capture(/dba\_hist\_sqlbind)是我们排查和绑定变量相关问题时非常重要的一种手段，例如能根据绑定变量值的类型，判断是否存在隐式转换。

**近期更新的文章：**

《[写代码如何事半功倍？][Link 2]》

《[支持超过4000字节的varchar2类型][4000_varchar2]》

《[“自以为对的”MyBatis空闲连接探测的机制][MyBatis]》

《[小白学习MySQL - 索引键长度限制的问题][MySQL -]》

《[积累一些SQL][SQL]》

《[创建主键的三种方式对指定索引表空间操作的纠正][Link 3]》

《[Oracle优化器的“短路”][Oracle]》

《[小白学习MySQL - MySQL会不会受到“高水位”的影响？][MySQL - MySQL]》

《[MySQL行转列的小需求][MySQL]》

《[Oracle的greatest和least函数][Oracle_greatest_least]》

《[我的股市生涯][Link 4]》

《[Oracle创建主键的三种方式][Oracle 1]》

《[非Oracle Linux下Oracle 19c CDB数据库安装][Oracle Linux_Oracle 19c CDB]》

《[小白学习MySQL - 数据库软件和初始化安装][MySQL - 1]》

《[小白学习MySQL - 闲聊聊][MySQL - 2]》

《[Redis和Sentinel的安装部署和配置][Redis_Sentinel]》

《[“火线”和“零线”][Link 5]》

《[通过索引提升SQL性能案例一则][SQL 1]》

《[如何手动添加jar包到maven本地库？][jar_maven]》

《[1元股权转让的一点思考][1]》

《[如何打造一个经常宕机的业务系统？][Link 6]》

《[Linux恢复误删文件的操作][Linux]》

《[Linux的scp指令使用场景][Linux_scp]》

《[Oracle处理IN的几种方式][Oracle_IN]》

《[如何搭建一支拖垮公司的技术团队？][Link 7]》

《[IP地址解析的规则][IP]》

《[MySQL的skip-grant-tables][MySQL_skip-grant-tables]》

《[国产数据库不平凡的一年][Link 8]》

《[Oracle要求顺序的top数据检索问题][Oracle_top]》

《[日常工作中碰到的几个技术问题][Link 9]》

《[了解一下sqlhc][sqlhc]》

《[Oracle的MD5函数介绍][Oracle_MD5]》

《[Oracle 19c的examples静默安装][Oracle 19c_examples]》

《[sqlplus登录缓慢的解决][sqlplus]》

《[COST值相同？是真是假？][COST]》

《[Oracle 11g的examples静默安装][Oracle 11g_examples]》

**文章分类和索引：**

《[公众号700篇文章分类和索引][700]》

[af82d84e7dac880ab7099f72950b5bd6.png]: /images/20221021/c65c860f5dea4792971f07780676442f.png
[v_v]: http://mp.weixin.qq.com/s?__biz=MzI2NzM1OTM4OA%3D%3D&chksm=ea82a5c2ddf52cd4ed4a1a6de5d89f7a6638d8d9378c66739e63ebfd7f670002d76212eb88a2&idx=1&mid=2247491633&scene=21&sn=56f7465a50792828e5c679c69c2f6182#wechat_redirect
[Link 1]: http://mp.weixin.qq.com/s?__biz=MzI2NzM1OTM4OA%3D%3D&chksm=ea82a5c9ddf52cdfe10f04528a52dc3522a0bce8e452ad8f28aa72546ac95c83399c23fbf563&idx=1&mid=2247491642&scene=21&sn=9f4541a6750ff754c17d6d9ddd1da09c#wechat_redirect
[14cabe7c3bce4b0d402d05fa37302eaf.png]: /images/20221021/202fbe82a561465b8ee8961424294f25.png
[2258f9de0ac9ac6d587fabfd73c58c0a.png]: /images/20221021/cc5dd7ff99694026a27e838bf7438199.png
[Link 2]: http://mp.weixin.qq.com/s?__biz=MzI2NzM1OTM4OA%3D%3D&chksm=ea82a432ddf52d2475aa2c81573af45a075b055cc1d4171c4036b73bc8c9a0648f2ea2952904&idx=1&mid=2247492033&scene=21&sn=d471b5da9c7c18e065fe38b299737db6#wechat_redirect
[4000_varchar2]: http://mp.weixin.qq.com/s?__biz=MzI2NzM1OTM4OA%3D%3D&chksm=ea82a449ddf52d5feea2ac1b64a23f9214b1f939e84e5360dc857deeb7dadff780ad488a1c9c&idx=1&mid=2247492026&scene=21&sn=f31d0e69ea77eb0b33ff32da933a3fe6#wechat_redirect
[MyBatis]: http://mp.weixin.qq.com/s?__biz=MzI2NzM1OTM4OA%3D%3D&chksm=ea82a447ddf52d51b3277a619583a9263ba5290f1263d28ed38997781ba6a64eff6fe8677438&idx=1&mid=2247492020&scene=21&sn=9bb5bcf1a299874b0ae8489a55c1f472#wechat_redirect
[MySQL -]: http://mp.weixin.qq.com/s?__biz=MzI2NzM1OTM4OA%3D%3D&chksm=ea82a466ddf52d701aa8f23065ac5d0ef4e0ff1bf1b6deb53a923e3d3ab007d6d41d92a73088&idx=1&mid=2247491989&scene=21&sn=3979107e0b99ebddc6b6ccfc8f9b901c#wechat_redirect
[SQL]: http://mp.weixin.qq.com/s?__biz=MzI2NzM1OTM4OA%3D%3D&chksm=ea82a47cddf52d6a74b2c27077f15c3631b93e90641f229a3333fa8f7829bd7242c07032dcec&idx=1&mid=2247491983&scene=21&sn=4fdcc1c999d116d9d1939ca8a57f9e8a#wechat_redirect
[Link 3]: http://mp.weixin.qq.com/s?__biz=MzI2NzM1OTM4OA%3D%3D&chksm=ea82a475ddf52d63e6f63dcbe1e8e29edec27e7645162d2499f550befafc1686c0704f82f579&idx=1&mid=2247491974&scene=21&sn=614617190c55f9090f5124767a164e21#wechat_redirect
[Oracle]: http://mp.weixin.qq.com/s?__biz=MzI2NzM1OTM4OA%3D%3D&chksm=ea82a48fddf52d9999788838c494741b2d3f73b0b30e9cf3425c63ddfad149739e8ccaaf66d9&idx=1&mid=2247491964&scene=21&sn=01531283836cc00f996bd199bf9dd541#wechat_redirect
[MySQL - MySQL]: http://mp.weixin.qq.com/s?__biz=MzI2NzM1OTM4OA%3D%3D&chksm=ea82a485ddf52d936279d52b0e62463f699412cf886e9b51eaf48114e7561dec55ccc21189be&idx=1&mid=2247491958&scene=21&sn=6917dcc719cab7b5537194eed27b4ed2#wechat_redirect
[MySQL]: http://mp.weixin.qq.com/s?__biz=MzI2NzM1OTM4OA%3D%3D&chksm=ea82a482ddf52d94fb3b283f9452a162ececef623aa4b86b2daa973729ccfff77af76b834671&idx=1&mid=2247491953&scene=21&sn=ced41f36822ad38a783363553da3df6d#wechat_redirect
[Oracle_greatest_least]: http://mp.weixin.qq.com/s?__biz=MzI2NzM1OTM4OA%3D%3D&chksm=ea82a49addf52d8c587878484b9818e5156867d3d8dace598b0da14a6e7ea2be00d2495e4510&idx=1&mid=2247491945&scene=21&sn=a8263a92dc9a32ac82d96c6a1fca6464#wechat_redirect
[Link 4]: http://mp.weixin.qq.com/s?__biz=MzI2NzM1OTM4OA%3D%3D&chksm=ea82a4aeddf52db865a96331d9a023f535d44393483a2d043c91eb1de4ef0d51c64264eb571e&idx=1&mid=2247491933&scene=21&sn=65fbd01000f8d350592c715f5f7c8779#wechat_redirect
[Oracle 1]: http://mp.weixin.qq.com/s?__biz=MzI2NzM1OTM4OA%3D%3D&chksm=ea82a4a7ddf52db166b63c72899ebcf8a6fbebc15bec11312bd89400bd29d88f0bfc9a8a812c&idx=1&mid=2247491924&scene=21&sn=6eafb363347d9624e2427d40510acd3f#wechat_redirect
[Oracle Linux_Oracle 19c CDB]: http://mp.weixin.qq.com/s?__biz=MzI2NzM1OTM4OA%3D%3D&chksm=ea82a4a3ddf52db52f85ca508e24fa60fe999ab2b73826fa79f8ea32df5aab88e36e44e267d8&idx=1&mid=2247491920&scene=21&sn=7db77f383482f0b45a094439d9af7dc7#wechat_redirect
[MySQL - 1]: http://mp.weixin.qq.com/s?__biz=MzI2NzM1OTM4OA%3D%3D&chksm=ea82a4c8ddf52dde849a70b34f2b62ff16593f81898cca7bc1fd7f0321588823016f0becaa18&idx=1&mid=2247491899&scene=21&sn=7affd185a81761eeaa5c3e143fc6f894#wechat_redirect
[MySQL - 2]: http://mp.weixin.qq.com/s?__biz=MzI2NzM1OTM4OA%3D%3D&chksm=ea82a4dcddf52dcad1708150cc6ceb101423eb5f4326ceff0f9dd53c05103bea76c1c5b7ccbc&idx=1&mid=2247491887&scene=21&sn=91485c182868ef19ad822c3ac9bf2ea9#wechat_redirect
[Redis_Sentinel]: http://mp.weixin.qq.com/s?__biz=MzI2NzM1OTM4OA%3D%3D&chksm=ea82a4c3ddf52dd5f4475241b627f5f1cf6aa602d15c94eec40795b600ff95bda09db52e108a&idx=1&mid=2247491888&scene=21&sn=f4133fb5ae9ce0018149e02c2c195b06#wechat_redirect
[Link 5]: http://mp.weixin.qq.com/s?__biz=MzI2NzM1OTM4OA%3D%3D&chksm=ea82a4ebddf52dfda1f8a857c0a1a527c7d7e663640b07ff8a67ad295e8c3218b87647981126&idx=1&mid=2247491864&scene=21&sn=e7cb2840e3ce2bab373f77f63d4b9a9d#wechat_redirect
[SQL 1]: http://mp.weixin.qq.com/s?__biz=MzI2NzM1OTM4OA%3D%3D&chksm=ea82a4fdddf52debb9cc3041f52085038f09b173444ada300999b058dc7ad19a9102fd1b5695&idx=1&mid=2247491854&scene=21&sn=d0f6880089bcbb4fe8ab7a658a460cd0#wechat_redirect
[jar_maven]: http://mp.weixin.qq.com/s?__biz=MzI2NzM1OTM4OA%3D%3D&chksm=ea82a4faddf52dec09683e7b533b56ed0430b99cda91ba3b41df893504d77690f68b8447c68a&idx=1&mid=2247491849&scene=21&sn=d502e38f03e1a222353544d1ce0aaaee#wechat_redirect
[1]: http://mp.weixin.qq.com/s?__biz=MzI2NzM1OTM4OA%3D%3D&chksm=ea82a4f6ddf52de04ccf3ab1219e1be19c9fa6a38cf8e3e74682d1f31b82cb1d8333692c1cce&idx=1&mid=2247491845&scene=21&sn=da9d31fd892da7e76671f0720721847e#wechat_redirect
[Link 6]: http://mp.weixin.qq.com/s?__biz=MzI2NzM1OTM4OA%3D%3D&chksm=ea82a51eddf52c085623fb43d61a2201e44477e04169098dd533076dbdf99377b931d671964d&idx=1&mid=2247491821&scene=21&sn=8169bff24df141481de7dfa370b91909#wechat_redirect
[Linux]: http://mp.weixin.qq.com/s?__biz=MzI2NzM1OTM4OA%3D%3D&chksm=ea82a514ddf52c02eb450efabec94a91e5f5e85ab76653cc4dd9d4cf87e8e15f766f5821f8b7&idx=1&mid=2247491815&scene=21&sn=d3954508c6e9ed2acc10a936aecc92b2#wechat_redirect
[Linux_scp]: http://mp.weixin.qq.com/s?__biz=MzI2NzM1OTM4OA%3D%3D&chksm=ea82a512ddf52c04b580ef998bcf292225635f04c743efee72fcc04fa0ffa8834e8f5351ea2f&idx=1&mid=2247491809&scene=21&sn=4b6e5ad829253bb6522f97c241f19d37#wechat_redirect
[Oracle_IN]: http://mp.weixin.qq.com/s?__biz=MzI2NzM1OTM4OA%3D%3D&chksm=ea82a528ddf52c3ed5a5613456abcaad5af328c5e8c59ed2fcf3a8ae21f0e87f2705545c80b6&idx=1&mid=2247491803&scene=21&sn=d40ee2f3334435f933b881e43389b716#wechat_redirect
[Link 7]: http://mp.weixin.qq.com/s?__biz=MzI2NzM1OTM4OA%3D%3D&chksm=ea82a527ddf52c310590250aea3a7f50e6ef0f3239a097a68a2f5506bae22bc618ce000e3440&idx=1&mid=2247491796&scene=21&sn=3fedb602e4d5acf03fc5460f288bf43c#wechat_redirect
[IP]: http://mp.weixin.qq.com/s?__biz=MzI2NzM1OTM4OA%3D%3D&chksm=ea82a53fddf52c29969fa924ed4644ebfabb1ce3d117443134060e4f7cc8f37e8177f5338700&idx=1&mid=2247491788&scene=21&sn=2790176fc4bd58abb337fd0ce786a190#wechat_redirect
[MySQL_skip-grant-tables]: http://mp.weixin.qq.com/s?__biz=MzI2NzM1OTM4OA%3D%3D&chksm=ea82a535ddf52c23f84ef003cdbadc868463c274971da2b6c79b5fe78660fc013b696c4f4339&idx=1&mid=2247491782&scene=21&sn=40c079eb9f84430e163ead1ee7b9fc85#wechat_redirect
[Link 8]: http://mp.weixin.qq.com/s?__biz=MzI2NzM1OTM4OA%3D%3D&chksm=ea82a549ddf52c5fb741cde2dad195f245871b0d7226a612ca326524d5af0968d674b64f0ac8&idx=1&mid=2247491770&scene=21&sn=d706bcda7de477177a15b14f64c99517#wechat_redirect
[Oracle_top]: http://mp.weixin.qq.com/s?__biz=MzI2NzM1OTM4OA%3D%3D&chksm=ea82a541ddf52c572d7c9c90b93b9f37674c07761a26b7b2566302f24fcb86636cae4e1c4cb8&idx=1&mid=2247491762&scene=21&sn=e92bdd8616515e6403c3ae3280142373#wechat_redirect
[Link 9]: http://mp.weixin.qq.com/s?__biz=MzI2NzM1OTM4OA%3D%3D&chksm=ea82a559ddf52c4f288da18bb70439b1e213a90f0587fdf2cd1d00c948f33f35be40de33bd05&idx=1&mid=2247491754&scene=21&sn=95533b540fe5809c9516468ad2f58c3e#wechat_redirect
[sqlhc]: http://mp.weixin.qq.com/s?__biz=MzI2NzM1OTM4OA%3D%3D&chksm=ea82a555ddf52c43093e82ff00b137c136c5aade5e902f84b523e609429a2de7bfacbd18ad67&idx=1&mid=2247491750&scene=21&sn=6ef9cc04a1a88217277d96072aa86fe2#wechat_redirect
[Oracle_MD5]: http://mp.weixin.qq.com/s?__biz=MzI2NzM1OTM4OA%3D%3D&chksm=ea82a57addf52c6c9d61af3dcf4f1ec9f6b93e51e6fd2d606c36fb8a243d70562c14cc525554&idx=1&mid=2247491721&scene=21&sn=8bdb65a2e11ef287f48d3d213642e4a8#wechat_redirect
[Oracle 19c_examples]: http://mp.weixin.qq.com/s?__biz=MzI2NzM1OTM4OA%3D%3D&chksm=ea82a588ddf52c9e16329e277f2dfdc74734b91bfde0770c545933fca6fb4d7cb224825169c4&idx=1&mid=2247491707&scene=21&sn=569f50f91b58c7cbcb652089e420ea11#wechat_redirect
[sqlplus]: http://mp.weixin.qq.com/s?__biz=MzI2NzM1OTM4OA%3D%3D&chksm=ea82a582ddf52c949d97894f8a2defe4b7fc21d58defa73dcae13f1cfe56d0cec41935b81c88&idx=1&mid=2247491697&scene=21&sn=ecb0e5cc2dc189be23279649b6aee945#wechat_redirect
[COST]: http://mp.weixin.qq.com/s?__biz=MzI2NzM1OTM4OA%3D%3D&chksm=ea82a5afddf52cb9bd94da2c5abd6f5bdcefad9035eacccf0fb96db79ff09ec8c38ae9f1941a&idx=1&mid=2247491676&scene=21&sn=4c9c289836ef2d1774136a88705960c7#wechat_redirect
[Oracle 11g_examples]: http://mp.weixin.qq.com/s?__biz=MzI2NzM1OTM4OA%3D%3D&chksm=ea82a5ccddf52cda2812771d563eea1db4c3b66f9891869920171bbe5650a45a2865bde0100e&idx=1&mid=2247491647&scene=21&sn=eca45fd1d7dffbf91ab199198adc1591#wechat_redirect
[700]: http://mp.weixin.qq.com/s?__biz=MzI2NzM1OTM4OA%3D%3D&chksm=ea82a5dfddf52cc949a5b8b316ee905927ff399713b34aec7d806c656e8ada09bfb562c039ca&idx=1&mid=2247491628&scene=21&sn=83bd320bd28da84501fada2e8d515e77#wechat_redirect