sym 50 并发压测数据，页面显示需要 8 秒左右

50 并发

[INFO ]-[2018-01-06 02:34:06]-[org.b3log.symphony.SymphonyServletListener:258]: Stopwatch: 
[100]%, [82557]ms [Request initialized [/article/1515141092284]]
  [0]%, [0]ms [Resolve skin]
  [97.46]%, [80456]ms [Request URI [/article/1515141092284]]
    [0.01090]%, [9]ms [Get article by id]
    [0.007268]%, [6]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.003634]%, [3]ms [Revision count]
    [0.001211]%, [1]ms [Process content]
      [0]%, [0]ms [Link article]
      [0]%, [0]ms [Link tag]
      [0]%, [0]ms [ToC]
    [7.951]%, [6564]ms [Fills relevant articles]
      [0.04724]%, [39]ms [Organize articles]
    [70.33]%, [58061]ms [Fills random articles]
      [0.06783]%, [56]ms [Organize articles]
    [18.58]%, [15336]ms [Fills hot articles]
      [0.8540]%, [705]ms [Organize articles]
    [0.006056]%, [5]ms [Fills article thank]
    [0.004845]%, [4]ms [Get previous]
    [0.003634]%, [3]ms [Get next]
    [0.02059]%, [17]ms [Gets nice comments]
      [0]%, [0]ms [Organizes comments]
    [0.2677]%, [221]ms [Get comments]
      [0.2604]%, [215]ms [Query comments]
      [0.001211]%, [1]ms [Organizes comments]
        [0.001211]%, [1]ms [Organize comment]
          [0]%, [0]ms [Link article]
          [0]%, [0]ms [Link tag]
        [0]%, [0]ms [Organize comment]
          [0]%, [0]ms [Link article]
          [0]%, [0]ms [Link tag]
      [0.006056]%, [5]ms [Revision, paging, original]
        [0.003634]%, [3]ms [Revision count]
        [0.002423]%, [2]ms [Revision count]
    [0.2568]%, [212]ms [Fills comment thank]
    [0.01211]%, [10]ms [Grant permissions]

[INFO ]-[2018-01-06 02:34:07]-[org.b3log.symphony.SymphonyServletListener:258]: Stopwatch: 
[100]%, [60192]ms [Request initialized [/article/1515141092284]]
  [0]%, [0]ms [Resolve skin]
  [92.86]%, [55897]ms [Request URI [/article/1515141092284]]
    [0.01661]%, [10]ms [Get article by id]
      [0.003323]%, [2]ms [Meta Desc]
    [0.008307]%, [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.004984]%, [3]ms [Revision count]
    [0]%, [0]ms [Process content]
      [0]%, [0]ms [Link article]
      [0]%, [0]ms [Link tag]
      [0]%, [0]ms [ToC]
    [16.51]%, [9940]ms [Fills relevant articles]
      [0.08971]%, [54]ms [Organize articles]
    [0.8506]%, [512]ms [Fills random articles]
      [0.4502]%, [271]ms [Organize articles]
        [0]%, [0]ms [Meta Desc]
    [75.38]%, [45372]ms [Fills hot articles]
      [1.477]%, [889]ms [Organize articles]
    [0.008307]%, [5]ms [Fills article thank]
    [0.006645]%, [4]ms [Get previous]
    [0.004984]%, [3]ms [Get next]
    [0.02658]%, [16]ms [Gets nice comments]
      [0]%, [0]ms [Organizes comments]
    [0.01495]%, [9]ms [Get comments]
      [0.004984]%, [3]ms [Query comments]
      [0.001661]%, [1]ms [Organizes comments]
        [0.001661]%, [1]ms [Organize comment]
          [0]%, [0]ms [Link article]
          [0]%, [0]ms [Link tag]
        [0]%, [0]ms [Organize comment]
          [0]%, [0]ms [Link article]
          [0]%, [0]ms [Link tag]
      [0.008307]%, [5]ms [Revision, paging, original]
        [0.004984]%, [3]ms [Revision count]
        [0.003323]%, [2]ms [Revision count]
    [0.008307]%, [5]ms [Fills comment thank]
    [0.01661]%, [10]ms [Grant permissions]

[INFO ]-[2018-01-06 02:34:07]-[org.b3log.symphony.SymphonyServletListener:258]: Stopwatch: 
[100]%, [51111]ms [Request initialized [/article/1515141092284]]
  [0]%, [0]ms [Resolve skin]
  [97.11]%, [49633]ms [Request URI [/article/1515141092284]]
    [0.02152]%, [11]ms [Get article by id]
      [0.003913]%, [2]ms [Meta Desc]
    [0.009783]%, [5]ms [Fills header]
      [0]%, [0]ms [Fills personal nav]
      [0]%, [0]ms [Fills lang]
      [0.001957]%, [1]ms [Fills domain nav]
    [0]%, [0]ms [Fills footer]
    [0.003913]%, [2]ms [Revision count]
    [0.001957]%, [1]ms [Process content]
      [0]%, [0]ms [Link article]
      [0]%, [0]ms [Link tag]
      [0]%, [0]ms [ToC]
    [35.00]%, [17890]ms [Fills relevant articles]
      [0.5341]%, [273]ms [Organize articles]
    [27.94]%, [14281]ms [Fills random articles]
      [0.1017]%, [52]ms [Organize articles]
    [33.20]%, [16969]ms [Fills hot articles]
      [2.174]%, [1111]ms [Organize articles]
    [0.01174]%, [6]ms [Fills article thank]
    [0.005870]%, [3]ms [Get previous]
    [0.007826]%, [4]ms [Get next]
    [0.4030]%, [206]ms [Gets nice comments]
      [0]%, [0]ms [Organizes comments]
    [0.04109]%, [21]ms [Get comments]
      [0.03130]%, [16]ms [Query comments]
      [0.001957]%, [1]ms [Organizes comments]
        [0]%, [0]ms [Organize comment]
          [0]%, [0]ms [Link article]
          [0]%, [0]ms [Link tag]
        [0.001957]%, [1]ms [Organize comment]
          [0]%, [0]ms [Link article]
          [0]%, [0]ms [Link tag]
      [0.007826]%, [4]ms [Revision, paging, original]
        [0.003913]%, [2]ms [Revision count]
        [0.003913]%, [2]ms [Revision count]
    [0.007826]%, [4]ms [Fills comment thank]
    [0.4422]%, [226]ms [Grant permissions]

mysql 慢查询日志

Time: 2018-01-05T18:34:46.988231Z

User@Host: root[root] @ [39.106.78.43] Id: 66

Query_time: 9.308157 Lock_time: 0.000074 Rows_sent: 10 Rows_examined: 10

SET timestamp=1515177286;
select * from symphony_article where (articleRandomDouble>=0.0 and articleRandomDouble<=0.14903612799060428 and articleStatus=0) limit 0,10;

Time: 2018-01-05T18:34:47.099090Z

User@Host: root[root] @ [39.106.78.43] Id: 90

Query_time: 3.201170 Lock_time: 0.000053 Rows_sent: 10 Rows_examined: 10

SET timestamp=1515177287;
select * from symphony_article where (articleRandomDouble>=0.0 and articleRandomDouble<=0.2115804003590963 and articleStatus=0) limit 0,10;

Time: 2018-01-05T18:34:53.816299Z

User@Host: root[root] @ [39.106.78.43] Id: 110

Query_time: 10.270199 Lock_time: 0.000070 Rows_sent: 10 Rows_examined: 10

SET timestamp=1515177293;
select * from symphony_article where (articleRandomDouble>=0.0 and articleRandomDouble<=0.2243257601725649 and articleStatus=0) limit 0,10;

Time: 2018-01-05T18:34:55.204640Z

User@Host: root[root] @ [39.106.78.43] Id: 91

Query_time: 9.119072 Lock_time: 0.000055 Rows_sent: 10 Rows_examined: 10

SET timestamp=1515177295;
select * from symphony_article where (articleRandomDouble>=0.0 and articleRandomDouble<=0.08403220448379822 and articleStatus=0) limit 0,10;

Time: 2018-01-05T18:34:56.003507Z

User@Host: root[root] @ [39.106.78.43] Id: 63

Query_time: 13.580180 Lock_time: 0.000079 Rows_sent: 10 Rows_examined: 10

SET timestamp=1515177296;
select * from symphony_article where (articleRandomDouble>=0.0 and articleRandomDouble<=0.1886439661577446 and articleStatus=0) limit 0,10;

Time: 2018-01-05T18:35:14.121694Z

User@Host: root[root] @ [39.106.78.43] Id: 96

Query_time: 9.479376 Lock_time: 0.000054 Rows_sent: 10 Rows_examined: 10

SET timestamp=1515177314;
select * from symphony_article where (articleRandomDouble>=0.0 and articleRandomDouble<=0.20281843434473845 and articleStatus=0) limit 0,10;

Time: 2018-01-05T18:35:25.187416Z

User@Host: root[root] @ [39.106.78.43] Id: 85

Query_time: 13.541373 Lock_time: 0.000070 Rows_sent: 10 Rows_examined: 10

SET timestamp=1515177325;
select * from symphony_article where (articleRandomDouble>=0.0 and articleRandomDouble<=0.23714774126729965 and articleStatus=0) limit 0,10;

Time: 2018-01-05T18:35:26.602330Z

User@Host: root[root] @ [39.106.78.43] Id: 84

Query_time: 9.806743 Lock_time: 0.000061 Rows_sent: 10 Rows_examined: 10

SET timestamp=1515177326;
select * from symphony_article where (articleRandomDouble>=0.0 and articleRandomDouble<=0.07125141651478761 and articleStatus=0) limit 0,10;