通过设立缓存的方式解决

目前：
<!-- [Information for Stewards] Execution Time: 13.99s -->

我發現，在mysql中使用了timestamp數據類型後，以前的時區設置已經失效了。

現在已降至10秒了。
<!-- [Information for Stewards] Execution Time: 10.54s -->

4.33+0.13+0.63 = 5.09
已節省5秒

今天晚上停工
明天繼續

今天主要处理首页分类列表缓存，估计还能节省7秒左右

{"count":1,"1":{"content":"saved","executionTime":0.881,"queued":false,"time":"2015-9-3 10:29:51","user":"1"}}
Total Time: 0.881s
光是電腦數位那個欄目就花費了0.881秒！

分類模塊的緩存終於弄好了
這是最複雜的一部分！
{"count":15,"1":{"content":"saved","executionTime":0.872,"queued":false,"time":"2015-9-3 10:53:33","user":"1"},"10":{"content":"saved","executionTime":0.862,"queued":false,"time":"2015-9-3 10:55:09","user":"1"},"18":{"content":"saved","executionTime":0.255,"queued":false,"time":"2015-9-3 10:55:18","user":"1"},"21":{"content":"saved","executionTime":0.411,"queued":false,"time":"2015-9-3 10:55:27","user":"1"},"26":{"content":"saved","executionTime":0.5,"queued":false,"time":"2015-9-3 10:55:36","user":"1"},"31":{"content":"saved","executionTime":0.242,"queued":false,"time":"2015-9-3 10:56:07","user":"1"},"39":{"content":"saved","executionTime":0.83,"queued":false,"time":"2015-9-3 10:56:19","user":"1"},"62":{"content":"saved","executionTime":0.276,"queued":false,"time":"2015-9-3 10:56:28","user":"1"},"67":{"content":"saved","executionTime":0.891,"queued":false,"time":"2015-9-3 10:56:39","user":"1"},"81":{"content":"saved","executionTime":0.848,"queued":false,"time":"2015-9-3 10:56:51","user":"1"},"85":{"content":"saved","executionTime":0.249,"queued":false,"time":"2015-9-3 10:57:04","user":"1"},"88":{"content":"saved","executionTime":0.407,"queued":false,"time":"2015-9-3 10:57:18","user":"1"},"91":{"content":"saved","executionTime":0.799,"queued":false,"time":"2015-9-3 10:57:25","user":"1"},"119":{"content":"saved","executionTime":0.009,"queued":false,"time":"2015-9-3 10:57:34","user":"1"},"134":{"content":"saved","executionTime":0.007,"queued":false,"time":"2015-9-3 10:57:44","user":"1"}}
Total Time: 7.458s
這部分節約了大約7.5秒
7.5+5 = 12.5
15 - 12.5 = 2.5

回復：6樓

7.5秒和我估計的很接近

目前：
<!-- [Information for Stewards] Execution Time: 0.98s -->

恭喜已經降到了1秒以下！
完工了

<!-- [Information for Stewards] Execution Time: 0.97s -->

<!-- [Information for Stewards] Execution Time: 0.94s -->
很好！

<!-- [Information for Stewards] Execution Time: 0.27s -->

這回，我首次使用了mediumtext這個數據類型

<!-- [Information for Stewards] Execution Time: 0.91s -->

MEDIUMTEXT最大长度为16777215(2^24-1)个字符。

回復：16樓
目前已用：137.6 kB (137,629 bytes)

16,777,215，大約16MB了，已經足夠了