求SQL查询语句优化

-Arvin 2017-11-01 02:39:28 
SELECT  CgPlanAdjustGUID ,

        CgPlanName

FROM    cg_CgPlan a

WHERE   ( ( ( ISNULL(a.IsProject, 0) = 0 )

            AND a.BUGUID IN (

            SELECT DISTINCT

                    bu.BUGUID

            FROM    myStationUser su

                    INNER JOIN myStation s ON su.StationGUID = s.StationGUID

                    INNER JOIN myBusinessUnit bu ON s.CompanyGUID = bu.BUGUID

            WHERE   su.UserGUID = 'AD942525-768C-4377-AD61-B7518339DAE8'

                    AND bu.IsCompany = 1 )

          )

          OR ( ( ISNULL(a.IsProject, 0) = 1 )

               AND ( SELECT COUNT(1)

                     FROM   ( SELECT DISTINCT

                                        t.ProjGUID

                              FROM      myStationObject so

                                        INNER JOIN myStationUser su ON so.StationGUID = su.StationGUID

                                        INNER JOIN vcg_FullProjectTree t ON so.ObjectGUID = t.ObjectGUID

                              WHERE     so.ObjectType = 'project'

                                        AND su.UserGUID = 'AD942525-768C-4377-AD61-B7518339DAE8'

                                        AND t.ApplySys LIKE '%,0220,%'

                                        AND a.ProjectGUIDList LIKE '%'

                                        + CAST(t.ProjGUID AS VARCHAR(36))

                                        + '%'

                            ) m

                   ) > 0

             )

        )

        AND ( a.ManagerGUID = 'AD942525-768C-4377-AD61-B7518339DAE8'

              OR EXISTS ( SELECT    1

                          FROM      Cg_CgSolutionTeam cgst

                                    INNER	 JOIN Cg_CgSolutionTeamMember cgstm ON cgst.TeamGUID = cgstm.TeamGUID

                                    INNER JOIN MyUserToOrg d ON cgstm.MemberGUID = d.OrgGuid

                                    INNER JOIN cg_CgSolution c ON cgst.CgSolutionGUID = c.CgSolutionGUID

                          WHERE     c.CgPlanAdjustGUID = a.CgPlanAdjustGUID

                                    AND d.UserGuid = 'AD942525-768C-4377-AD61-B7518339DAE8' )

              OR EXISTS ( SELECT    1

                          FROM      cg_ProcDataAuthor cpda

                                    INNER JOIN MyUserToOrg mut ON cpda.AuthorGUID = mut.OrgGuid

                          WHERE     cpda.BUGUID = a.BUGUID

                                    AND mut.UserGuid = 'AD942525-768C-4377-AD61-B7518339DAE8' )

            )

求SQL优化，单表数据量很少不过万，查询时间30秒。求大神优化最好能在5秒内。
...全文
460 6 打赏 收藏 转发到动态 举报
写回复
用AI写文章
6 条回复
切换为时间正序
请发表友善的回复…
发表回复
-Arvin 2017-11-09
  • 打赏
  • 举报
 回复
谢谢两位 结帖
-Arvin 2017-11-09
  • 打赏
  • 举报
 回复
引用 4 楼 qq_37170555 的回复:
[quote=引用 3 楼 -Arvin的回复:][quote=引用 1 楼 qq_37170555 的回复:] 

SELECT a.CgPlanAdjustGUID,
       a.CgPlanName
FROM   cg_CgPlan a
       INNER JOIN (
                SELECT DISTINCT
                       bu.BUGUID
                FROM   myStationUser su
                       INNER JOIN myStation s
                            ON  su.StationGUID = s.StationGUID
                       INNER JOIN myBusinessUnit bu
                            ON  s.CompanyGUID = bu.BUGUID
                WHERE  su.UserGUID = 'AD942525-768C-4377-AD'
            ) b
            ON  a.BUGUID = b.BUGUID
WHERE  ISNULL(a.IsProject, 0) = 0
       AND (
               a.ManagerGUID = 'AD942525-768C-4377-AD61-B7518339DAE8'
               OR EXISTS (
                      SELECT 1
                      FROM   Cg_CgSolutionTeam cgst
                             INNER     JOIN Cg_CgSolutionTeamMember cgstm
                                  ON  cgst.TeamGUID = cgstm.TeamGUID
                             INNER JOIN MyUserToOrg d
                                  ON  cgstm.MemberGUID = d.OrgGuid
                             INNER JOIN cg_CgSolution c
                                  ON  cgst.CgSolutionGUID = c.CgSolutionGUID
                      WHERE  c.CgPlanAdjustGUID = a.CgPlanAdjustGUID
                             AND d.UserGuid = 
                                 'AD942525-768C-4377-AD61-B7518339DAE8'
                  )
               OR EXISTS (
                      SELECT 1
                      FROM   cg_ProcDataAuthor cpda
                             INNER JOIN MyUserToOrg mut
                                  ON  cpda.AuthorGUID = mut.OrgGuid
                      WHERE  cpda.BUGUID = a.BUGUID
                             AND mut.UserGuid = 
                                 'AD942525-768C-4377-AD61-B7518339DAE8'
                  )
           )
union
SELECT a.CgPlanAdjustGUID,
       a.CgPlanName
FROM   cg_CgPlan a      
WHERE  ISNULL(a.IsProject, 0) = 1 
AND (
  SELECT COUNT(1)
  FROM   (
             SELECT DISTINCT
                    t.ProjGUID
             FROM   myStationObject so
                    INNER JOIN myStationUser su
                         ON  so.StationGUID = su.StationGUID
                    INNER JOIN vcg_FullProjectTree t
                         ON  so.ObjectGUID = t.ObjectGUID
             WHERE  so.ObjectType = 'project'
                    AND su.UserGUID = 
                        'AD942525-768C-4377-AD61-B7518339DAE8'
                    AND t.ApplySys LIKE '%,0220,%'
                    AND a.ProjectGUIDList LIKE '%'
                        + CAST(t.ProjGUID AS VARCHAR(36))
                        + '%'
         ) m
) > 0
AND
(
   a.ManagerGUID = 'AD942525-768C-4377-AD61-B7518339DAE8'
   OR EXISTS (
          SELECT 1
          FROM   Cg_CgSolutionTeam cgst
                 INNER     JOIN Cg_CgSolutionTeamMember cgstm
                      ON  cgst.TeamGUID = cgstm.TeamGUID
                 INNER JOIN MyUserToOrg d
                      ON  cgstm.MemberGUID = d.OrgGuid
                 INNER JOIN cg_CgSolution c
                      ON  cgst.CgSolutionGUID = c.CgSolutionGUID
          WHERE  c.CgPlanAdjustGUID = a.CgPlanAdjustGUID
                 AND d.UserGuid = 
                     'AD942525-768C-4377-AD61-B7518339DAE8'
      )
   OR EXISTS (
          SELECT 1
          FROM   cg_ProcDataAuthor cpda
                 INNER JOIN MyUserToOrg mut
                      ON  cpda.AuthorGUID = mut.OrgGuid
          WHERE  cpda.BUGUID = a.BUGUID
                 AND mut.UserGuid = 
                     'AD942525-768C-4377-AD61-B7518339DAE8'
      )
)
这样试试看有没有稍微快点，你这什么都没有，就一堆代码，很难优化的，只能看看你语句上有没有优化的余地。索引和逻辑方面根本没有办法优化。
1秒都不到。。。 学习了。[/quote] 没问题了就结贴吧[/quote] 引用错了，哈哈 。是下面个那版主哥的 1秒钟。
听雨停了 2017-11-02
  • 打赏
  • 举报
 回复
引用 3 楼 -Arvin的回复:
[quote=引用 1 楼 qq_37170555 的回复:] 

SELECT a.CgPlanAdjustGUID,
       a.CgPlanName
FROM   cg_CgPlan a
       INNER JOIN (
                SELECT DISTINCT
                       bu.BUGUID
                FROM   myStationUser su
                       INNER JOIN myStation s
                            ON  su.StationGUID = s.StationGUID
                       INNER JOIN myBusinessUnit bu
                            ON  s.CompanyGUID = bu.BUGUID
                WHERE  su.UserGUID = 'AD942525-768C-4377-AD'
            ) b
            ON  a.BUGUID = b.BUGUID
WHERE  ISNULL(a.IsProject, 0) = 0
       AND (
               a.ManagerGUID = 'AD942525-768C-4377-AD61-B7518339DAE8'
               OR EXISTS (
                      SELECT 1
                      FROM   Cg_CgSolutionTeam cgst
                             INNER     JOIN Cg_CgSolutionTeamMember cgstm
                                  ON  cgst.TeamGUID = cgstm.TeamGUID
                             INNER JOIN MyUserToOrg d
                                  ON  cgstm.MemberGUID = d.OrgGuid
                             INNER JOIN cg_CgSolution c
                                  ON  cgst.CgSolutionGUID = c.CgSolutionGUID
                      WHERE  c.CgPlanAdjustGUID = a.CgPlanAdjustGUID
                             AND d.UserGuid = 
                                 'AD942525-768C-4377-AD61-B7518339DAE8'
                  )
               OR EXISTS (
                      SELECT 1
                      FROM   cg_ProcDataAuthor cpda
                             INNER JOIN MyUserToOrg mut
                                  ON  cpda.AuthorGUID = mut.OrgGuid
                      WHERE  cpda.BUGUID = a.BUGUID
                             AND mut.UserGuid = 
                                 'AD942525-768C-4377-AD61-B7518339DAE8'
                  )
           )
union
SELECT a.CgPlanAdjustGUID,
       a.CgPlanName
FROM   cg_CgPlan a      
WHERE  ISNULL(a.IsProject, 0) = 1 
AND (
  SELECT COUNT(1)
  FROM   (
             SELECT DISTINCT
                    t.ProjGUID
             FROM   myStationObject so
                    INNER JOIN myStationUser su
                         ON  so.StationGUID = su.StationGUID
                    INNER JOIN vcg_FullProjectTree t
                         ON  so.ObjectGUID = t.ObjectGUID
             WHERE  so.ObjectType = 'project'
                    AND su.UserGUID = 
                        'AD942525-768C-4377-AD61-B7518339DAE8'
                    AND t.ApplySys LIKE '%,0220,%'
                    AND a.ProjectGUIDList LIKE '%'
                        + CAST(t.ProjGUID AS VARCHAR(36))
                        + '%'
         ) m
) > 0
AND
(
   a.ManagerGUID = 'AD942525-768C-4377-AD61-B7518339DAE8'
   OR EXISTS (
          SELECT 1
          FROM   Cg_CgSolutionTeam cgst
                 INNER     JOIN Cg_CgSolutionTeamMember cgstm
                      ON  cgst.TeamGUID = cgstm.TeamGUID
                 INNER JOIN MyUserToOrg d
                      ON  cgstm.MemberGUID = d.OrgGuid
                 INNER JOIN cg_CgSolution c
                      ON  cgst.CgSolutionGUID = c.CgSolutionGUID
          WHERE  c.CgPlanAdjustGUID = a.CgPlanAdjustGUID
                 AND d.UserGuid = 
                     'AD942525-768C-4377-AD61-B7518339DAE8'
      )
   OR EXISTS (
          SELECT 1
          FROM   cg_ProcDataAuthor cpda
                 INNER JOIN MyUserToOrg mut
                      ON  cpda.AuthorGUID = mut.OrgGuid
          WHERE  cpda.BUGUID = a.BUGUID
                 AND mut.UserGuid = 
                     'AD942525-768C-4377-AD61-B7518339DAE8'
      )
)
这样试试看有没有稍微快点，你这什么都没有，就一堆代码，很难优化的，只能看看你语句上有没有优化的余地。索引和逻辑方面根本没有办法优化。
1秒都不到。。。 学习了。[/quote] 没问题了就结贴吧
-Arvin 2017-11-01
  • 打赏
  • 举报
 回复
引用 1 楼 qq_37170555 的回复:

SELECT a.CgPlanAdjustGUID,
       a.CgPlanName
FROM   cg_CgPlan a
       INNER JOIN (
                SELECT DISTINCT
                       bu.BUGUID
                FROM   myStationUser su
                       INNER JOIN myStation s
                            ON  su.StationGUID = s.StationGUID
                       INNER JOIN myBusinessUnit bu
                            ON  s.CompanyGUID = bu.BUGUID
                WHERE  su.UserGUID = 'AD942525-768C-4377-AD'
            ) b
            ON  a.BUGUID = b.BUGUID
WHERE  ISNULL(a.IsProject, 0) = 0
       AND (
               a.ManagerGUID = 'AD942525-768C-4377-AD61-B7518339DAE8'
               OR EXISTS (
                      SELECT 1
                      FROM   Cg_CgSolutionTeam cgst
                             INNER     JOIN Cg_CgSolutionTeamMember cgstm
                                  ON  cgst.TeamGUID = cgstm.TeamGUID
                             INNER JOIN MyUserToOrg d
                                  ON  cgstm.MemberGUID = d.OrgGuid
                             INNER JOIN cg_CgSolution c
                                  ON  cgst.CgSolutionGUID = c.CgSolutionGUID
                      WHERE  c.CgPlanAdjustGUID = a.CgPlanAdjustGUID
                             AND d.UserGuid = 
                                 'AD942525-768C-4377-AD61-B7518339DAE8'
                  )
               OR EXISTS (
                      SELECT 1
                      FROM   cg_ProcDataAuthor cpda
                             INNER JOIN MyUserToOrg mut
                                  ON  cpda.AuthorGUID = mut.OrgGuid
                      WHERE  cpda.BUGUID = a.BUGUID
                             AND mut.UserGuid = 
                                 'AD942525-768C-4377-AD61-B7518339DAE8'
                  )
           )
union
SELECT a.CgPlanAdjustGUID,
       a.CgPlanName
FROM   cg_CgPlan a      
WHERE  ISNULL(a.IsProject, 0) = 1 
AND (
  SELECT COUNT(1)
  FROM   (
             SELECT DISTINCT
                    t.ProjGUID
             FROM   myStationObject so
                    INNER JOIN myStationUser su
                         ON  so.StationGUID = su.StationGUID
                    INNER JOIN vcg_FullProjectTree t
                         ON  so.ObjectGUID = t.ObjectGUID
             WHERE  so.ObjectType = 'project'
                    AND su.UserGUID = 
                        'AD942525-768C-4377-AD61-B7518339DAE8'
                    AND t.ApplySys LIKE '%,0220,%'
                    AND a.ProjectGUIDList LIKE '%'
                        + CAST(t.ProjGUID AS VARCHAR(36))
                        + '%'
         ) m
) > 0
AND
(
   a.ManagerGUID = 'AD942525-768C-4377-AD61-B7518339DAE8'
   OR EXISTS (
          SELECT 1
          FROM   Cg_CgSolutionTeam cgst
                 INNER     JOIN Cg_CgSolutionTeamMember cgstm
                      ON  cgst.TeamGUID = cgstm.TeamGUID
                 INNER JOIN MyUserToOrg d
                      ON  cgstm.MemberGUID = d.OrgGuid
                 INNER JOIN cg_CgSolution c
                      ON  cgst.CgSolutionGUID = c.CgSolutionGUID
          WHERE  c.CgPlanAdjustGUID = a.CgPlanAdjustGUID
                 AND d.UserGuid = 
                     'AD942525-768C-4377-AD61-B7518339DAE8'
      )
   OR EXISTS (
          SELECT 1
          FROM   cg_ProcDataAuthor cpda
                 INNER JOIN MyUserToOrg mut
                      ON  cpda.AuthorGUID = mut.OrgGuid
          WHERE  cpda.BUGUID = a.BUGUID
                 AND mut.UserGuid = 
                     'AD942525-768C-4377-AD61-B7518339DAE8'
      )
)
这样试试看有没有稍微快点，你这什么都没有，就一堆代码，很难优化的，只能看看你语句上有没有优化的余地。索引和逻辑方面根本没有办法优化。
1秒都不到。。。 学习了。
吉普赛的歌 2017-11-01
  • 打赏
  • 举报
 回复 
IF NOT EXISTS(
	SELECT CgPlanAdjustGUID,
		   CgPlanName
	FROM   cg_CgPlan a
	WHERE a.ManagerGUID = 'AD942525-768C-4377-AD61-B7518339DAE8'
	OR EXISTS (
			SELECT 1
			FROM   Cg_CgSolutionTeam cgst
					INNER	 JOIN Cg_CgSolutionTeamMember cgstm
						ON  cgst.TeamGUID = cgstm.TeamGUID
					INNER JOIN MyUserToOrg d
						ON  cgstm.MemberGUID = d.OrgGuid
					INNER JOIN cg_CgSolution c
						ON  cgst.CgSolutionGUID = c.CgSolutionGUID
			WHERE  c.CgPlanAdjustGUID = a.CgPlanAdjustGUID
					AND d.UserGuid = 
						'AD942525-768C-4377-AD61-B7518339DAE8'
		)
	OR EXISTS (
			SELECT 1
			FROM   cg_ProcDataAuthor cpda
					INNER JOIN MyUserToOrg mut
						ON  cpda.AuthorGUID = mut.OrgGuid
			WHERE  cpda.BUGUID = a.BUGUID
					AND mut.UserGuid = 
						'AD942525-768C-4377-AD61-B7518339DAE8'
		)
)
BEGIN
	SELECT CgPlanAdjustGUID,
		   CgPlanName
	FROM   cg_CgPlan a
	WHERE 1=0 
END
ELSE
BEGIN
	SELECT CgPlanAdjustGUID,
       CgPlanName
	FROM   cg_CgPlan a
	WHERE  ISNULL(a.IsProject, 0) = 0
			AND EXISTS (SELECT 1
							FROM   myStationUser su
									INNER JOIN myStation s
										ON  su.StationGUID = s.StationGUID
									INNER JOIN myBusinessUnit bu
										ON  s.CompanyGUID = bu.BUGUID
							WHERE  su.UserGUID = 'AD942525-768C-4377-AD61-B7518339DAE8'
									AND bu.IsCompany = 1
									AND bu.BUGUID=a.BUGUID
							)
	UNION ALL
	SELECT CgPlanAdjustGUID,
       CgPlanName
	FROM   cg_CgPlan a
	WHERE ISNULL(a.IsProject, 0) = 1
		AND EXISTS(
			SELECT 1
			FROM   myStationObject so
				INNER JOIN myStationUser su
						ON  so.StationGUID = su.StationGUID
				INNER JOIN vcg_FullProjectTree t
						ON  so.ObjectGUID = t.ObjectGUID
			WHERE  so.ObjectType = 'project'
				AND su.UserGUID = 
					'AD942525-768C-4377-AD61-B7518339DAE8'
				AND t.ApplySys LIKE '%,0220,%'
				AND a.ProjectGUIDList LIKE '%'
					+ CAST(t.ProjGUID AS VARCHAR(36))
					+ '%'
		)
END
先看看这个需要多少秒吧？
听雨停了 2017-11-01
  • 打赏
  • 举报
 回复 

SELECT a.CgPlanAdjustGUID,
       a.CgPlanName
FROM   cg_CgPlan a
       INNER JOIN (
                SELECT DISTINCT
                       bu.BUGUID
                FROM   myStationUser su
                       INNER JOIN myStation s
                            ON  su.StationGUID = s.StationGUID
                       INNER JOIN myBusinessUnit bu
                            ON  s.CompanyGUID = bu.BUGUID
                WHERE  su.UserGUID = 'AD942525-768C-4377-AD'
            ) b
            ON  a.BUGUID = b.BUGUID
WHERE  ISNULL(a.IsProject, 0) = 0
       AND (
               a.ManagerGUID = 'AD942525-768C-4377-AD61-B7518339DAE8'
               OR EXISTS (
                      SELECT 1
                      FROM   Cg_CgSolutionTeam cgst
                             INNER     JOIN Cg_CgSolutionTeamMember cgstm
                                  ON  cgst.TeamGUID = cgstm.TeamGUID
                             INNER JOIN MyUserToOrg d
                                  ON  cgstm.MemberGUID = d.OrgGuid
                             INNER JOIN cg_CgSolution c
                                  ON  cgst.CgSolutionGUID = c.CgSolutionGUID
                      WHERE  c.CgPlanAdjustGUID = a.CgPlanAdjustGUID
                             AND d.UserGuid = 
                                 'AD942525-768C-4377-AD61-B7518339DAE8'
                  )
               OR EXISTS (
                      SELECT 1
                      FROM   cg_ProcDataAuthor cpda
                             INNER JOIN MyUserToOrg mut
                                  ON  cpda.AuthorGUID = mut.OrgGuid
                      WHERE  cpda.BUGUID = a.BUGUID
                             AND mut.UserGuid = 
                                 'AD942525-768C-4377-AD61-B7518339DAE8'
                  )
           )
union
SELECT a.CgPlanAdjustGUID,
       a.CgPlanName
FROM   cg_CgPlan a      
WHERE  ISNULL(a.IsProject, 0) = 1 
AND (
  SELECT COUNT(1)
  FROM   (
             SELECT DISTINCT
                    t.ProjGUID
             FROM   myStationObject so
                    INNER JOIN myStationUser su
                         ON  so.StationGUID = su.StationGUID
                    INNER JOIN vcg_FullProjectTree t
                         ON  so.ObjectGUID = t.ObjectGUID
             WHERE  so.ObjectType = 'project'
                    AND su.UserGUID = 
                        'AD942525-768C-4377-AD61-B7518339DAE8'
                    AND t.ApplySys LIKE '%,0220,%'
                    AND a.ProjectGUIDList LIKE '%'
                        + CAST(t.ProjGUID AS VARCHAR(36))
                        + '%'
         ) m
) > 0
AND
(
   a.ManagerGUID = 'AD942525-768C-4377-AD61-B7518339DAE8'
   OR EXISTS (
          SELECT 1
          FROM   Cg_CgSolutionTeam cgst
                 INNER     JOIN Cg_CgSolutionTeamMember cgstm
                      ON  cgst.TeamGUID = cgstm.TeamGUID
                 INNER JOIN MyUserToOrg d
                      ON  cgstm.MemberGUID = d.OrgGuid
                 INNER JOIN cg_CgSolution c
                      ON  cgst.CgSolutionGUID = c.CgSolutionGUID
          WHERE  c.CgPlanAdjustGUID = a.CgPlanAdjustGUID
                 AND d.UserGuid = 
                     'AD942525-768C-4377-AD61-B7518339DAE8'
      )
   OR EXISTS (
          SELECT 1
          FROM   cg_ProcDataAuthor cpda
                 INNER JOIN MyUserToOrg mut
                      ON  cpda.AuthorGUID = mut.OrgGuid
          WHERE  cpda.BUGUID = a.BUGUID
                 AND mut.UserGuid = 
                     'AD942525-768C-4377-AD61-B7518339DAE8'
      )
)
这样试试看有没有稍微快点，你这什么都没有，就一堆代码，很难优化的，只能看看你语句上有没有优化的余地。索引和逻辑方面根本没有办法优化。
多种典型T-SQL语句、备份、优化、常见问题处理集合包
首先说明这个是收集与csdn 多年来的精华帖 有很多经典问题的处理方法，集多为大牛的心血为一体 包括备份还原，导入导出、行列转换、动态sql基本语法、游标、复制 等等，可以说是丰富多彩、包罗万象。 这里不多在阐述，绝对的物超所值，谁下谁知道。
SQL优化之SQL查询语句的执行顺序解析
SQL语句执行顺序 SQL语句执行顺序 结合上图，整理出如下伪SQL查询语句。 SQL语句执行顺序 从这个顺序中我们可以发现，所有的查询语句都是从FROM开始执行的。在实际执行过程中，每个步骤都会为下一个步骤生成一个虚拟表，这个虚拟表将作为下一个执行步骤的输入。 接下来，我们详细的介绍下每个步骤的具体执行过程。 1 FROM执行笛卡尔积 FROM 才是 SQ...
数据库执行SQL语句跟踪
不管你是刚学习软件开发的初学者，还是在IT职场打拼多年的职场老鸟，都免不了要同各种数据库打交道，你可能会碰到以下几个问题：1、感觉自己写的sql语句没有错，但是执行结果总是不对；2、某个功能执行的语句知道有涉及到哪几张表，但是具体执行的语句是什么，排查起来实在费力；3、在执行某个功能时，会出现某个表的数据被更新或者删除，但是不知道执行的语句到底是什么。以上的问题，学完本课程都可以轻松解决。
SQL语句的优化方法
SQL语句的优化方法
慢SQL语句优化
对慢SQL语句优化一般可以按下面几步思路：开启慢查询日志，设置超过几秒为慢SQL语句，抓取慢SQL语句；通过explain查看执行计划，对慢SQL语句分析；创建索引并调整语句，再查看执行计划，对比调优结果。 　　参数 slow_query_log：表示是否开启慢查询日志。语句“set global slow_query_log=on”临时开启慢查询日志，如果想关闭慢查询日志只需要执行“set global slow_query_log=off ”即可。 参数slow_query_log_..
community_281

594

社区成员

254,047

社区内容

发帖
与我相关
我的任务
社区描述
提出问题
其他 技术论坛（原bbs）
社区管理员
  • community_281
加入社区
  • 近7日
  • 近30日
  • 至今

加载中

查看更多榜单
社区公告
暂无公告

试试用AI创作助手写篇文章吧

+ 用AI写文章