图文精华

发表新帖

广告

使用了rownum分页后查询非常费时的问题

没有进行分页的语句：大概3秒出结果，一旦加上rownum分页就要很长时间才能查出结果
SELECT GU.GUEST_NAME,
  GU.ADDR_ONE || GU.ADDR_TWO || GU.ADDR_THREE || GU.ADDR_FOUR GUADDR,
  DEV.STB_TYPE,
  SIG.SIGNAL_STRENGTH,
  SIG.TUNER_SNR,
  SIG.SIGNAL_BER,
  CM.UP_CM_SIGNAL_STRENGTH,
  CM.DOWN_CM_SIGNAL_STRENGTH
  FROM (SELECT MAC_ADDR, SIGNAL_STRENGTH, SIGNAL_BER, TUNER_SNR
  FROM UT_SIGNAL_NEW USIG
  WHERE TIME = (SELECT MAX(TIME)
  FROM UT_SIGNAL_NEW
  WHERE MAC_ADDR = USIG.MAC_ADDR)) SIG
  FULL JOIN (SELECT MAC_ADDR,
  DOWN_CM_SIGNAL_STRENGTH,
  UP_CM_SIGNAL_STRENGTH
  FROM UT_CM_NEW UCM
  WHERE TIME = (SELECT MAX(TIME)
  FROM UT_CM_NEW
  WHERE MAC_ADDR = UCM.MAC_ADDR)) CM ON (UPPER(SIG.MAC_ADDR) =
  UPPER(CM.MAC_ADDR))
  JOIN (SELECT MAC_ADDR
  FROM UT_ONOFF_NEW UTNE
  WHERE TIME = (SELECT MAX(TIME)
  FROM UT_ONOFF_NEW
  WHERE MAC_ADDR = UTNE.MAC_ADDR)
  AND TYPE = 0) AA ON (UPPER(SIG.MAC_ADDR) =
  UPPER(AA.MAC_ADDR) or
  UPPER(AA.MAC_ADDR) =
  UPPER(CM.MAC_ADDR))
  left outer JOIN GUEST GU ON (UPPER(GU.MAC_ADDR) =
  UPPER(AA.MAC_ADDR))
  LEFT OUTER JOIN (SELECT DISTINCT MAC_ADDR, STB_TYPE
  FROM PB_DEVICE_INFO) DEV ON (UPPER(GU.MAC_ADDR) =
  UPPER(DEV.MAC_ADDR))
  WHERE (SIGNAL_STRENGTH BETWEEN
  (SELECT MINVALUE
  FROM RANGE
  WHERE TYPE = 1
  AND NAME = 'SIGNAL_STRENGTH') AND
  (SELECT MAXVALUE
  FROM RANGE
  WHERE TYPE = 1
  AND NAME = 'SIGNAL_STRENGTH') OR
  SIGNAL_STRENGTH IS NULL)
  AND (SIGNAL_BER BETWEEN
  (SELECT MINVALUE_BER
  FROM RANGE
  WHERE TYPE = 1
  AND NAME = 'SIGNAL_BER') AND
  (SELECT MAXVALUE_BER
  FROM RANGE
  WHERE TYPE = 1
  AND NAME = 'SIGNAL_BER') OR SIGNAL_BER IS NULL)
  AND (TUNER_SNR BETWEEN
  (SELECT MINVALUE
  FROM RANGE
  WHERE TYPE = 1
  AND NAME = 'TUNER_SNR') AND
  (SELECT MAXVALUE
  FROM RANGE
  WHERE TYPE = 1
  AND NAME = 'TUNER_SNR') OR TUNER_SNR IS NULL)
  AND (DOWN_CM_SIGNAL_STRENGTH BETWEEN
  (SELECT MINVALUE
  FROM RANGE
  WHERE TYPE = 1
  AND NAME = 'DOWN_CM_STRENGTH') AND
  (SELECT MAXVALUE
  FROM RANGE
  WHERE TYPE = 1
  AND NAME = 'DOWN_CM_STRENGTH') OR
  DOWN_CM_SIGNAL_STRENGTH IS NULL)
  AND (UP_CM_SIGNAL_STRENGTH BETWEEN
  (SELECT MINVALUE
  FROM RANGE
  WHERE TYPE = 1
  AND NAME = 'UP_CM_SIGNAL_STRENGTH') AND
  (SELECT MAXVALUE
  FROM RANGE
  WHERE TYPE = 1
  AND NAME = 'UP_CM_SIGNAL_STRENGTH') OR
  UP_CM_SIGNAL_STRENGTH IS NULL)
ORDER BY AA.MAC_ADDR
标签： 暂无标签
sweetanan888

写了 1 篇文章，拥有财富 18，被 1 人关注

0
举报 收藏
转播转播 分享分享 分享淘帖
回复

使用道具

sweetanan888
P3 | 发表于 2012-11-2 16:01:20
分页的SQL语句的执行计划：
Execution Plan
----------------------------------------------------------
Plan hash value: 2104735380

-----------------------------------------------------------------------------------------------------------------
| Id | Operation | Name | Rows | Bytes |TempSpc| Cost (%CPU)| Time |
-----------------------------------------------------------------------------------------------------------------
| 0 | SELECT STATEMENT | | 9 | 3141 | | 28083 (74)| 00:05:37 |
|* 1 | COUNT STOPKEY | | | | | | |
| 2 | VIEW | | 965M| 313G| | 28083 (74)| 00:05:37 |
|* 3 | SORT ORDER BY STOPKEY | | 965M| 188G| | 28083 (74)| 00:05:37 |
|* 4 | HASH JOIN RIGHT OUTER | | 965M| 188G| | 28083 (74)| 00:05:37 |
| 5 | VIEW | | 15947 | 280K| | 222 (2)| 00:00:03 |
| 6 | HASH UNIQUE | | 15947 | 358K| 1344K| 222 (2)| 00:00:03 |
| 7 | TABLE ACCESS FULL | PB_DEVICE_INFO | 26294 | 590K| | 84 (2)| 00:00:02 |
|* 8 | HASH JOIN | | 6054K| 1108M| | 16590 (58)| 00:03:20 |
| 9 | VIEW | VW_SQ_6 | 4486 | 98692 | | 823 (5)| 00:00:10 |
| 10 | HASH GROUP BY | | 4486 | 94206 | | 823 (5)| 00:00:10 |
| 11 | TABLE ACCESS FULL | UT_ONOFF_NEW | 296K| 6086K| | 794 (2)| 00:00:10 |
|* 12 | HASH JOIN RIGHT OUTER | | 400M| 63G| | 11091 (43)| 00:02:14 |
| 13 | TABLE ACCESS FULL | GUEST | 2948 | 187K| | 26 (0)| 00:00:01 |
| 14 | NESTED LOOPS | | 13M| 1360M| | 6388 (2)| 00:01:17 |
|* 15 | VIEW | | 5599 | 442K| | 182 (6)| 00:00:03 |
| 16 | UNION-ALL | | | | | | |
|* 17 | HASH JOIN RIGHT OUTER | | 5597 | 524K| | 91 (6)| 00:00:02 |
| 18 | VIEW | | 2 | 76 | | 5 (20)| 00:00:01 |
|* 19 | TABLE ACCESS BY INDEX ROWID| UT_CM_NEW | 1 | 27 | | 1 (0)| 00:00:01 |
| 20 | NESTED LOOPS | | 2 | 88 | | 5 (20)| 00:00:01 |
| 21 | VIEW | VW_SQ_1 | 2 | 34 | | 4 (25)| 00:00:01 |
| 22 | HASH GROUP BY | | 2 | 42 | | 4 (25)| 00:00:01 |
| 23 | TABLE ACCESS FULL | UT_CM_NEW | 5 | 105 | | 3 (0)| 00:00:01 |
|* 24 | INDEX RANGE SCAN | CM_MAC_INDEX | 3 | | | 0 (0)| 00:00:01 |
|* 25 | HASH JOIN | | 5597 | 317K| | 85 (4)| 00:00:02 |
| 26 | VIEW | VW_SQ_2 | 5597 | 136K| | 43 (5)| 00:00:01 |
| 27 | HASH GROUP BY | | 5597 | 114K| | 43 (5)| 00:00:01 |
| 28 | TABLE ACCESS FULL | UT_SIGNAL_NEW | 10535 | 216K| | 41 (0)| 00:00:01 |
| 29 | TABLE ACCESS FULL | UT_SIGNAL_NEW | 10535 | 339K| | 41 (0)| 00:00:01 |
|* 30 | HASH JOIN ANTI | | 2 | 104 | | 91 (6)| 00:00:02 |
|* 31 | TABLE ACCESS BY INDEX ROWID | UT_CM_NEW | 1 | 27 | | 1 (0)| 00:00:01 |
| 32 | NESTED LOOPS | | 2 | 88 | | 5 (20)| 00:00:01 |
| 33 | VIEW | VW_SQ_5 | 2 | 34 | | 4 (25)| 00:00:01 |
| 34 | HASH GROUP BY | | 2 | 42 | | 4 (25)| 00:00:01 |
| 35 | TABLE ACCESS FULL | UT_CM_NEW | 5 | 105 | | 3 (0)| 00:00:01 |
|* 36 | INDEX RANGE SCAN | CM_MAC_INDEX | 3 | | | 0 (0)| 00:00:01 |
| 37 | VIEW | VW_SQ_4 | 5597 | 44776 | | 85 (4)| 00:00:02 |
|* 38 | HASH JOIN | | 5597 | 207K| | 85 (4)| 00:00:02 |
| 39 | VIEW | VW_SQ_3 | 5597 | 95149 | | 43 (5)| 00:00:01 |
| 40 | HASH GROUP BY | | 5597 | 114K| | 43 (5)| 00:00:01 |
| 41 | TABLE ACCESS FULL | UT_SIGNAL_NEW | 10535 | 216K| | 41 (0)| 00:00:01 |
| 42 | TABLE ACCESS FULL | UT_SIGNAL_NEW | 10535 | 216K| | 41 (0)| 00:00:01 |
|* 43 | TABLE ACCESS FULL | RANGE | 1 | 22 | | 2 (0)| 00:00:01 |
|* 44 | TABLE ACCESS FULL | RANGE | 1 | 22 | | 2 (0)| 00:00:01 |
|* 45 | TABLE ACCESS FULL | RANGE | 1 | 21 | | 3 (0)| 00:00:01 |
|* 46 | TABLE ACCESS FULL | RANGE | 1 | 21 | | 3 (0)| 00:00:01 |
|* 47 | TABLE ACCESS FULL | RANGE | 1 | 22 | | 3 (0)| 00:00:01 |
|* 48 | TABLE ACCESS FULL | RANGE | 1 | 22 | | 3 (0)| 00:00:01 |
|* 49 | TABLE ACCESS FULL | RANGE | 1 | 22 | | 3 (0)| 00:00:01 |
|* 50 | TABLE ACCESS FULL | RANGE | 1 | 22 | | 3 (0)| 00:00:01 |
|* 51 | TABLE ACCESS FULL | RANGE | 1 | 22 | | 3 (0)| 00:00:01 |
|* 52 | TABLE ACCESS FULL | RANGE | 1 | 22 | | 3 (0)| 00:00:01 |
|* 53 | TABLE ACCESS FULL | UT_ONOFF_NEW | 2427 | 58248 | | 1 (0)| 00:00:01 |
-----------------------------------------------------------------------------------------------------------------
回复

使用道具

sweetanan888
P3 | 发表于 2012-11-2 16:01:49
分页的SQL语句的执行计划：
Execution Plan
----------------------------------------------------------
Plan hash value: 2104735380

-----------------------------------------------------------------------------------------------------------------
| Id | Operation | Name | Rows | Bytes |TempSpc| Cost (%CPU)| Time |
-----------------------------------------------------------------------------------------------------------------
| 0 | SELECT STATEMENT | | 9 | 3141 | | 28083 (74)| 00:05:37 |
|* 1 | COUNT STOPKEY | | | | | | |
| 2 | VIEW | | 965M| 313G| | 28083 (74)| 00:05:37 |
|* 3 | SORT ORDER BY STOPKEY | | 965M| 188G| | 28083 (74)| 00:05:37 |
|* 4 | HASH JOIN RIGHT OUTER | | 965M| 188G| | 28083 (74)| 00:05:37 |
| 5 | VIEW | | 15947 | 280K| | 222 (2)| 00:00:03 |
| 6 | HASH UNIQUE | | 15947 | 358K| 1344K| 222 (2)| 00:00:03 |
| 7 | TABLE ACCESS FULL | PB_DEVICE_INFO | 26294 | 590K| | 84 (2)| 00:00:02 |
|* 8 | HASH JOIN | | 6054K| 1108M| | 16590 (58)| 00:03:20 |
| 9 | VIEW | VW_SQ_6 | 4486 | 98692 | | 823 (5)| 00:00:10 |
| 10 | HASH GROUP BY | | 4486 | 94206 | | 823 (5)| 00:00:10 |
| 11 | TABLE ACCESS FULL | UT_ONOFF_NEW | 296K| 6086K| | 794 (2)| 00:00:10 |
|* 12 | HASH JOIN RIGHT OUTER | | 400M| 63G| | 11091 (43)| 00:02:14 |
| 13 | TABLE ACCESS FULL | GUEST | 2948 | 187K| | 26 (0)| 00:00:01 |
| 14 | NESTED LOOPS | | 13M| 1360M| | 6388 (2)| 00:01:17 |
|* 15 | VIEW | | 5599 | 442K| | 182 (6)| 00:00:03 |
| 16 | UNION-ALL | | | | | | |
|* 17 | HASH JOIN RIGHT OUTER | | 5597 | 524K| | 91 (6)| 00:00:02 |
| 18 | VIEW | | 2 | 76 | | 5 (20)| 00:00:01 |
|* 19 | TABLE ACCESS BY INDEX ROWID| UT_CM_NEW | 1 | 27 | | 1 (0)| 00:00:01 |
| 20 | NESTED LOOPS | | 2 | 88 | | 5 (20)| 00:00:01 |
| 21 | VIEW | VW_SQ_1 | 2 | 34 | | 4 (25)| 00:00:01 |
| 22 | HASH GROUP BY | | 2 | 42 | | 4 (25)| 00:00:01 |
| 23 | TABLE ACCESS FULL | UT_CM_NEW | 5 | 105 | | 3 (0)| 00:00:01 |
|* 24 | INDEX RANGE SCAN | CM_MAC_INDEX | 3 | | | 0 (0)| 00:00:01 |
|* 25 | HASH JOIN | | 5597 | 317K| | 85 (4)| 00:00:02 |
| 26 | VIEW | VW_SQ_2 | 5597 | 136K| | 43 (5)| 00:00:01 |
| 27 | HASH GROUP BY | | 5597 | 114K| | 43 (5)| 00:00:01 |
| 28 | TABLE ACCESS FULL | UT_SIGNAL_NEW | 10535 | 216K| | 41 (0)| 00:00:01 |
| 29 | TABLE ACCESS FULL | UT_SIGNAL_NEW | 10535 | 339K| | 41 (0)| 00:00:01 |
|* 30 | HASH JOIN ANTI | | 2 | 104 | | 91 (6)| 00:00:02 |
|* 31 | TABLE ACCESS BY INDEX ROWID | UT_CM_NEW | 1 | 27 | | 1 (0)| 00:00:01 |
| 32 | NESTED LOOPS | | 2 | 88 | | 5 (20)| 00:00:01 |
| 33 | VIEW | VW_SQ_5 | 2 | 34 | | 4 (25)| 00:00:01 |
| 34 | HASH GROUP BY | | 2 | 42 | | 4 (25)| 00:00:01 |
| 35 | TABLE ACCESS FULL | UT_CM_NEW | 5 | 105 | | 3 (0)| 00:00:01 |
|* 36 | INDEX RANGE SCAN | CM_MAC_INDEX | 3 | | | 0 (0)| 00:00:01 |
| 37 | VIEW | VW_SQ_4 | 5597 | 44776 | | 85 (4)| 00:00:02 |
|* 38 | HASH JOIN | | 5597 | 207K| | 85 (4)| 00:00:02 |
| 39 | VIEW | VW_SQ_3 | 5597 | 95149 | | 43 (5)| 00:00:01 |
| 40 | HASH GROUP BY | | 5597 | 114K| | 43 (5)| 00:00:01 |
| 41 | TABLE ACCESS FULL | UT_SIGNAL_NEW | 10535 | 216K| | 41 (0)| 00:00:01 |
| 42 | TABLE ACCESS FULL | UT_SIGNAL_NEW | 10535 | 216K| | 41 (0)| 00:00:01 |
|* 43 | TABLE ACCESS FULL | RANGE | 1 | 22 | | 2 (0)| 00:00:01 |
|* 44 | TABLE ACCESS FULL | RANGE | 1 | 22 | | 2 (0)| 00:00:01 |
|* 45 | TABLE ACCESS FULL | RANGE | 1 | 21 | | 3 (0)| 00:00:01 |
|* 46 | TABLE ACCESS FULL | RANGE | 1 | 21 | | 3 (0)| 00:00:01 |
|* 47 | TABLE ACCESS FULL | RANGE | 1 | 22 | | 3 (0)| 00:00:01 |
|* 48 | TABLE ACCESS FULL | RANGE | 1 | 22 | | 3 (0)| 00:00:01 |
|* 49 | TABLE ACCESS FULL | RANGE | 1 | 22 | | 3 (0)| 00:00:01 |
|* 50 | TABLE ACCESS FULL | RANGE | 1 | 22 | | 3 (0)| 00:00:01 |
|* 51 | TABLE ACCESS FULL | RANGE | 1 | 22 | | 3 (0)| 00:00:01 |
|* 52 | TABLE ACCESS FULL | RANGE | 1 | 22 | | 3 (0)| 00:00:01 |
|* 53 | TABLE ACCESS FULL | UT_ONOFF_NEW | 2427 | 58248 | | 1 (0)| 00:00:01 |
-----------------------------------------------------------------------------------------------------------------
回复

使用道具

sweetanan888
P3 | 发表于 2012-11-2 16:07:24
分页的SQL语句的执行计划：
Execution Plan
----------------------------------------------------------
Plan hash value: 2104735380

-----------------------------------------------------------------------------------------------------------------
| Id | Operation | Name | Rows | Bytes |TempSpc| Cost (%CPU)| Time |
-----------------------------------------------------------------------------------------------------------------
| 0 | SELECT STATEMENT | | 9 | 3141 | | 28083 (74)| 00:05:37 |
|* 1 | COUNT STOPKEY | | | | | | |
| 2 | VIEW | | 965M| 313G| | 28083 (74)| 00:05:37 |
|* 3 | SORT ORDER BY STOPKEY | | 965M| 188G| | 28083 (74)| 00:05:37 |
|* 4 | HASH JOIN RIGHT OUTER | | 965M| 188G| | 28083 (74)| 00:05:37 |
| 5 | VIEW | | 15947 | 280K| | 222 (2)| 00:00:03 |
| 6 | HASH UNIQUE | | 15947 | 358K| 1344K| 222 (2)| 00:00:03 |
| 7 | TABLE ACCESS FULL | PB_DEVICE_INFO | 26294 | 590K| | 84 (2)| 00:00:02 |
|* 8 | HASH JOIN | | 6054K| 1108M| | 16590 (58)| 00:03:20 |
| 9 | VIEW | VW_SQ_6 | 4486 | 98692 | | 823 (5)| 00:00:10 |
| 10 | HASH GROUP BY | | 4486 | 94206 | | 823 (5)| 00:00:10 |
| 11 | TABLE ACCESS FULL | UT_ONOFF_NEW | 296K| 6086K| | 794 (2)| 00:00:10 |
|* 12 | HASH JOIN RIGHT OUTER | | 400M| 63G| | 11091 (43)| 00:02:14 |
| 13 | TABLE ACCESS FULL | GUEST | 2948 | 187K| | 26 (0)| 00:00:01 |
| 14 | NESTED LOOPS | | 13M| 1360M| | 6388 (2)| 00:01:17 |
|* 15 | VIEW | | 5599 | 442K| | 182 (6)| 00:00:03 |
| 16 | UNION-ALL | | | | | | |
|* 17 | HASH JOIN RIGHT OUTER | | 5597 | 524K| | 91 (6)| 00:00:02 |
| 18 | VIEW | | 2 | 76 | | 5 (20)| 00:00:01 |
|* 19 | TABLE ACCESS BY INDEX ROWID| UT_CM_NEW | 1 | 27 | | 1 (0)| 00:00:01 |
| 20 | NESTED LOOPS | | 2 | 88 | | 5 (20)| 00:00:01 |
| 21 | VIEW | VW_SQ_1 | 2 | 34 | | 4 (25)| 00:00:01 |
| 22 | HASH GROUP BY | | 2 | 42 | | 4 (25)| 00:00:01 |
| 23 | TABLE ACCESS FULL | UT_CM_NEW | 5 | 105 | | 3 (0)| 00:00:01 |
|* 24 | INDEX RANGE SCAN | CM_MAC_INDEX | 3 | | | 0 (0)| 00:00:01 |
|* 25 | HASH JOIN | | 5597 | 317K| | 85 (4)| 00:00:02 |
| 26 | VIEW | VW_SQ_2 | 5597 | 136K| | 43 (5)| 00:00:01 |
| 27 | HASH GROUP BY | | 5597 | 114K| | 43 (5)| 00:00:01 |
| 28 | TABLE ACCESS FULL | UT_SIGNAL_NEW | 10535 | 216K| | 41 (0)| 00:00:01 |
| 29 | TABLE ACCESS FULL | UT_SIGNAL_NEW | 10535 | 339K| | 41 (0)| 00:00:01 |
|* 30 | HASH JOIN ANTI | | 2 | 104 | | 91 (6)| 00:00:02 |
|* 31 | TABLE ACCESS BY INDEX ROWID | UT_CM_NEW | 1 | 27 | | 1 (0)| 00:00:01 |
| 32 | NESTED LOOPS | | 2 | 88 | | 5 (20)| 00:00:01 |
| 33 | VIEW | VW_SQ_5 | 2 | 34 | | 4 (25)| 00:00:01 |
| 34 | HASH GROUP BY | | 2 | 42 | | 4 (25)| 00:00:01 |
| 35 | TABLE ACCESS FULL | UT_CM_NEW | 5 | 105 | | 3 (0)| 00:00:01 |
|* 36 | INDEX RANGE SCAN | CM_MAC_INDEX | 3 | | | 0 (0)| 00:00:01 |
| 37 | VIEW | VW_SQ_4 | 5597 | 44776 | | 85 (4)| 00:00:02 |
|* 38 | HASH JOIN | | 5597 | 207K| | 85 (4)| 00:00:02 |
| 39 | VIEW | VW_SQ_3 | 5597 | 95149 | | 43 (5)| 00:00:01 |
| 40 | HASH GROUP BY | | 5597 | 114K| | 43 (5)| 00:00:01 |
| 41 | TABLE ACCESS FULL | UT_SIGNAL_NEW | 10535 | 216K| | 41 (0)| 00:00:01 |
| 42 | TABLE ACCESS FULL | UT_SIGNAL_NEW | 10535 | 216K| | 41 (0)| 00:00:01 |
|* 43 | TABLE ACCESS FULL | RANGE | 1 | 22 | | 2 (0)| 00:00:01 |
|* 44 | TABLE ACCESS FULL | RANGE | 1 | 22 | | 2 (0)| 00:00:01 |
|* 45 | TABLE ACCESS FULL | RANGE | 1 | 21 | | 3 (0)| 00:00:01 |
|* 46 | TABLE ACCESS FULL | RANGE | 1 | 21 | | 3 (0)| 00:00:01 |
|* 47 | TABLE ACCESS FULL | RANGE | 1 | 22 | | 3 (0)| 00:00:01 |
|* 48 | TABLE ACCESS FULL | RANGE | 1 | 22 | | 3 (0)| 00:00:01 |
|* 49 | TABLE ACCESS FULL | RANGE | 1 | 22 | | 3 (0)| 00:00:01 |
|* 50 | TABLE ACCESS FULL | RANGE | 1 | 22 | | 3 (0)| 00:00:01 |
|* 51 | TABLE ACCESS FULL | RANGE | 1 | 22 | | 3 (0)| 00:00:01 |
|* 52 | TABLE ACCESS FULL | RANGE | 1 | 22 | | 3 (0)| 00:00:01 |
|* 53 | TABLE ACCESS FULL | UT_ONOFF_NEW | 2427 | 58248 | | 1 (0)| 00:00:01 |
-----------------------------------------------------------------------------------------------------------------
回复

使用道具

oraunix
P6 | 发表于 2012-11-7 13:38:27
分页后的SQL语句，排序时使用了大量的临时表空间
回复

使用道具

sweetanan888
P3 | 发表于 2013-1-25 13:16:33
谢谢你的回答，不过我还是想知道默认的排序是不是用orwid的啊？
回复

使用道具

高级模式
B Color Image Link Quote Code Smilies
您需要登录后才可以回帖 登录 | 加入社区

本版积分规则

关于我们· 联系我们· 加入我们· 聚知识· 合作伙伴      

© 2020 iiDBA Powered by Discuz! X3.4 Comsenz Inc.

iiDBA / Smrz 京ICP备12024223-8号 Wxb 不良信息举报电话：13718043309

意见
反馈