sym 性能优化

一，数据库日志

# Time: 2018-01-08T19:38:04.794438Z
# User@Host: root[root] @  [39.106.78.43]  Id:   644
# Query_time: 10.304440  Lock_time: 0.000089 Rows_sent: 15  Rows_examined: 177
SET timestamp=1515440284;
select oId,articleBadCnt,articleCreateTime,articleAuthorId,articleAnonymous,articleContent,articleTitle,articleUA,articleGoodCnt,articleWatchCnt,articleLatestCmterName,articlePermalink,articleStick,syncWithSymphonyClient,articleCollectCnt,articleUpdateTime,articleStatus,articleTags,articleViewCount,articleType,articlePerfect,articleCommentCount,articleLatestCmtTime from symphony_article where (articleStatus=0 and articleType!=1 and articleTags not like 'B3log%' and articleTags not like 'Sandbox%') order by articleStick desc,articleLatestCmtTime desc,oId desc limit 0,15;
# Time: 2018-01-08T19:38:07.101889Z
# User@Host: root[root] @  [39.106.78.43]  Id:   641
# Query_time: 12.992505  Lock_time: 0.000069 Rows_sent: 15  Rows_examined: 15
SET timestamp=1515440287;
select oId,articleCreateTime,articleAuthorId,articleAnonymous,articleContent,articleTitle,articleLatestCmterName,articlePermalink,articleStick,syncWithSymphonyClient,articleUpdateTime,articleStatus,articleTags,articleViewCount,articleType,articlePerfect,articleCommentCount,articleLatestCmtTime from symphony_article where oId in ('1514807966264','1514804671881','1514735452369','1514734285138','1514639818439','1514638506503','1514556208300','1514554987527','1514554591839','1514468734123','1514467615500','1514466268261','1514404019696','1514386302317','1514290904792')  limit 0,2147483647;

二，程序日志

[INFO ]-[2018-01-09 09:05:50]-[org.b3log.symphony.SymphonyServletListener:258]: Stopwatch: 
[100]%, [11334]ms [Request initialized [/article/1515235394885]]
  [0.008823]%, [1]ms [Resolve skin]
  [99.89]%, [11322]ms [Request URI [/article/1515235394885]]
    [0.5735]%, [65]ms [Get article by id]
    [0.04412]%, [5]ms [Fills header]
      [0]%, [0]ms [Fills personal nav]
      [0]%, [0]ms [Fills lang]
      [0]%, [0]ms [Fills domain nav]
    [0]%, [0]ms [Fills footer]
    [0.02647]%, [3]ms [Revision count]
    [18.46]%, [2092]ms [Process content]
      [0.008823]%, [1]ms [Link article]
      [0.008823]%, [1]ms [Link tag]
      [17.72]%, [2008]ms [Md to HTML]
      [0]%, [0]ms [ToC]
    [2.973]%, [337]ms [Fills relevant articles]
      [0.8558]%, [97]ms [Organize articles]
        [0.008823]%, [1]ms [Meta Desc]
        [0.008823]%, [1]ms [Meta Desc]
        [0]%, [0]ms [Meta Desc]
        [0.008823]%, [1]ms [Meta Desc]
        [0]%, [0]ms [Meta Desc]
        [0.008823]%, [1]ms [Meta Desc]
        [0]%, [0]ms [Meta Desc]
        [0]%, [0]ms [Meta Desc]
        [0]%, [0]ms [Meta Desc]
        [0.008823]%, [1]ms [Meta Desc]
        [0.008823]%, [1]ms [Meta Desc]
        [0]%, [0]ms [Meta Desc]
    [73.17]%, [8293]ms [Fills random articles]
      [2.153]%, [244]ms [Organize articles]
        [0]%, [0]ms [Meta Desc]
    [0.6353]%, [72]ms [Fills hot articles]
      [0.5911]%, [67]ms [Organize articles]
        [0]%, [0]ms [Meta Desc]
        [0.008823]%, [1]ms [Meta Desc]
        [0]%, [0]ms [Meta Desc]
        [0]%, [0]ms [Meta Desc]
        [0.008823]%, [1]ms [Meta Desc]
        [0]%, [0]ms [Meta Desc]
        [0.008823]%, [1]ms [Meta Desc]
        [0]%, [0]ms [Meta Desc]
        [0.008823]%, [1]ms [Meta Desc]
        [0]%, [0]ms [Meta Desc]
    [0.04412]%, [5]ms [Fills article thank]
    [0.02647]%, [3]ms [Get previous]
    [1.826]%, [207]ms [Get next]
    [0.02647]%, [3]ms [Gets nice comments]
      [0]%, [0]ms [Organizes comments]
    [0.01765]%, [2]ms [Get comments]
      [0.01765]%, [2]ms [Query comments]
      [0]%, [0]ms [Organizes comments]
      [0]%, [0]ms [Revision, paging, original]
    [0]%, [0]ms [Fills comment thank]
    [2.003]%, [227]ms [Grant permissions]