GitLab

3.0.3.RELEASE 线上 /mfang/member/workspace/1401720739140210689/folderFullPath接口需要4秒

  <select id="getWorkspaceFullPathFolderList-bak" resultType="WorkspaceFolder">
    SET
    @i = 0;
    SELECT id,
           parent_id,
           workspace_id,
           `name`,
           create_time,
           create_by,
           last_update_time,
           last_update_by,
           is_deleted,
           is_in_recycle
    FROM mf_workspace_folder
    WHERE id IN (
      SELECT t._id AS id
      FROM (
             SELECT (@i := @i + 1) AS `index`,
                    @r AS _id,
    ( SELECT @r := parent_id FROM mf_workspace_folder WHERE id = _id AND workspace_id = #{workspaceId}) AS parent_id
             FROM
               ( SELECT @r := #{folderId}, @i = 1 ) temp,
               mf_workspace_folder AS h
           ) AS t
      WHERE t.parent_id IS NOT NULL
    ORDER BY
      t.`index` DESC
      )
  </select>