秒开之路——百度百科小程序性能优化实践
- 威海自媒体运营与推广 威海百度智能小程序运营
- 1189
§§ --- README.md §§ 1002 +> 小程序性能优化指南 + +## 体验百度百科小程序 + + + +## 小程序性能优化实践 + +### 请见 [wiki](./Wiki/性能优化实践.md)
Public @ 2023-02-24 23:36:43
基本
文件
流程
错误
SQL
调试
- 请求信息 : 2025-06-24 09:16:01 HTTP/2.0 GET : briline.net/wiki/post/id/5749
- 运行时间 : 0.607637s [ 吞吐率：1.65req/s ] 内存消耗：5,056.13kb 文件加载：72
- 查询信息 : 14 queries 1 writes
- 缓存信息 : 0 reads,0 writes
- 配置加载 : 93
- /www/wwwroot/briline.net/public/index.php ( 0.79 KB )
- /www/wwwroot/briline.net/public/public.php ( 1.08 KB )
- /www/wwwroot/briline.net/thinkphp/start.php ( 0.73 KB )
- /www/wwwroot/briline.net/thinkphp/base.php ( 2.66 KB )
- /www/wwwroot/briline.net/thinkphp/library/think/Loader.php ( 19.47 KB )
- /www/wwwroot/briline.net/vendor/composer/autoload_namespaces.php ( 0.21 KB )
- /www/wwwroot/briline.net/vendor/composer/autoload_psr4.php ( 0.84 KB )
- /www/wwwroot/briline.net/vendor/composer/autoload_classmap.php ( 0.14 KB )
- /www/wwwroot/briline.net/vendor/composer/autoload_files.php ( 0.42 KB )
- /www/wwwroot/briline.net/vendor/qiniu/php-sdk/src/Qiniu/functions.php ( 7.10 KB )
- /www/wwwroot/briline.net/vendor/qiniu/php-sdk/src/Qiniu/Config.php ( 0.70 KB )
- /www/wwwroot/briline.net/vendor/topthink/think-captcha/src/helper.php ( 1.59 KB )
- /www/wwwroot/briline.net/thinkphp/library/think/Route.php ( 59.82 KB )
- /www/wwwroot/briline.net/thinkphp/library/think/Config.php ( 6.03 KB )
- /www/wwwroot/briline.net/thinkphp/library/think/Validate.php ( 40.27 KB )
- /www/wwwroot/briline.net/vendor/topthink/think-queue/src/config.php ( 0.77 KB )
- /www/wwwroot/briline.net/thinkphp/library/think/Console.php ( 21.22 KB )
- /www/wwwroot/briline.net/thinkphp/library/think/Error.php ( 3.59 KB )
- /www/wwwroot/briline.net/thinkphp/convention.php ( 10.31 KB )
- /www/wwwroot/briline.net/thinkphp/library/think/App.php ( 21.04 KB )
- /www/wwwroot/briline.net/thinkphp/library/think/Request.php ( 50.94 KB )
- /www/wwwroot/briline.net/app/config.php ( 11.25 KB )
- /www/wwwroot/briline.net/app/database.php ( 1.41 KB )
- /www/wwwroot/briline.net/thinkphp/library/think/Hook.php ( 4.76 KB )
- /www/wwwroot/briline.net/app/tags.php ( 1.16 KB )
- /www/wwwroot/briline.net/app/common/behavior/InitBase.php ( 8.17 KB )
- /www/wwwroot/briline.net/app/common.php ( 23.29 KB )
- /www/wwwroot/briline.net/thinkphp/library/think/Env.php ( 1.25 KB )
- /www/wwwroot/briline.net/thinkphp/helper.php ( 17.86 KB )
- /www/wwwroot/briline.net/app/function.php ( 0.78 KB )
- /www/wwwroot/briline.net/app/extend.php ( 13.29 KB )
- /www/wwwroot/briline.net/thinkphp/library/think/Debug.php ( 7.06 KB )
- /www/wwwroot/briline.net/app/common/model/Config.php ( 0.78 KB )
- /www/wwwroot/briline.net/app/common/model/ModelBase.php ( 12.18 KB )
- /www/wwwroot/briline.net/thinkphp/library/think/Model.php ( 66.83 KB )
- /www/wwwroot/briline.net/thinkphp/library/think/Db.php ( 6.54 KB )
- /www/wwwroot/briline.net/thinkphp/library/think/Log.php ( 5.84 KB )
- /www/wwwroot/briline.net/thinkphp/library/think/db/connector/Mysql.php ( 3.94 KB )
- /www/wwwroot/briline.net/thinkphp/library/think/db/Connection.php ( 29.97 KB )
- /www/wwwroot/briline.net/thinkphp/library/think/db/Query.php ( 86.80 KB )
- /www/wwwroot/briline.net/thinkphp/library/think/db/builder/Mysql.php ( 2.16 KB )
- /www/wwwroot/briline.net/thinkphp/library/think/db/Builder.php ( 30.47 KB )
- /www/wwwroot/briline.net/thinkphp/library/think/Cache.php ( 6.17 KB )
- /www/wwwroot/briline.net/thinkphp/library/think/cache/driver/File.php ( 7.46 KB )
- /www/wwwroot/briline.net/thinkphp/library/think/cache/Driver.php ( 5.52 KB )
- /www/wwwroot/briline.net/app/common/behavior/InitHook.php ( 1.25 KB )
- /www/wwwroot/briline.net/app/common/model/Hook.php ( 0.77 KB )
- /www/wwwroot/briline.net/thinkphp/library/think/Lang.php ( 6.95 KB )
- /www/wwwroot/briline.net/thinkphp/lang/zh-cn.php ( 3.85 KB )
- /www/wwwroot/briline.net/app/route.php ( 0.91 KB )
- /www/wwwroot/briline.net/app/index/config.php ( 0.96 KB )
- /www/wwwroot/briline.net/app/index/common.php ( 0.68 KB )
- /www/wwwroot/briline.net/app/index/controller/Wiki.php ( 2.44 KB )
- /www/wwwroot/briline.net/app/index/controller/IndexBase.php ( 1.10 KB )
- /www/wwwroot/briline.net/app/common/controller/ControllerBase.php ( 4.75 KB )
- /www/wwwroot/briline.net/thinkphp/library/think/Controller.php ( 6.20 KB )
- /www/wwwroot/briline.net/thinkphp/library/traits/controller/Jump.php ( 4.97 KB )
- /www/wwwroot/briline.net/thinkphp/library/think/View.php ( 6.86 KB )
- /www/wwwroot/briline.net/thinkphp/library/think/view/driver/Think.php ( 5.61 KB )
- /www/wwwroot/briline.net/thinkphp/library/think/Template.php ( 46.46 KB )
- /www/wwwroot/briline.net/thinkphp/library/think/template/driver/File.php ( 2.24 KB )
- /www/wwwroot/briline.net/app/index/logic/Wiki.php ( 6.16 KB )
- /www/wwwroot/briline.net/app/index/logic/IndexBase.php ( 0.79 KB )
- /www/wwwroot/briline.net/app/common/logic/LogicBase.php ( 0.83 KB )
- /www/wwwroot/briline.net/app/common/model/Article.php ( 0.78 KB )
- /www/wwwroot/briline.net/app/common/model/ArticleTongji.php ( 0.79 KB )
- /www/wwwroot/briline.net/thinkphp/library/think/paginator/driver/Bootstrap.php ( 5.90 KB )
- /www/wwwroot/briline.net/thinkphp/library/think/Paginator.php ( 9.45 KB )
- /www/wwwroot/briline.net/thinkphp/library/think/Collection.php ( 8.63 KB )
- /www/wwwroot/briline.net/runtime/temp/ead4923c25a6b3f986358f7070f93dfa.php ( 56.51 KB )
- /www/wwwroot/briline.net/thinkphp/library/think/Response.php ( 8.64 KB )
- /www/wwwroot/briline.net/thinkphp/library/think/debug/Html.php ( 4.27 KB )
- [ DB ] INIT mysql
- [ CACHE ] INIT File
- [ BEHAVIOR ] Run app\common\behavior\InitBase @app_init [ RunTime:0.089525s ]
- [ BEHAVIOR ] Run app\common\behavior\InitHook @app_init [ RunTime:0.055933s ]
- [ LANG ] /www/wwwroot/briline.net/thinkphp/lang/zh-cn.php
- [ BIND ] 'index'
- [ ROUTE ] array ( 'type' => 'module', 'module' => array ( 0 => 'index', 1 => 'wiki', 2 => 'post', ), )
- [ HEADER ] array ( 'host' => 'briline.net', 'accept' => '*/*', 'user-agent' => 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)', 'accept-encoding' => 'gzip, br, zstd, deflate', 'content-type' => '', 'content-length' => '', )
- [ PARAM ] array ( 'id' => '5749', )
- [ RUN ] app\index\controller\Wiki->post[ /www/wwwroot/briline.net/app/index/controller/Wiki.php ]
- [ CACHE ] INIT File
- [ VIEW ] /www/wwwroot/briline.net/public/../app/index/view/wiki/wikipost.html [ array ( 0 => 'loading_icon', 1 => 'pjax_mode', 2 => 'static_root', 3 => 'qrcode', 4 => 'seo', 5 => 'catelist', 6 => 'tagslist', 7 => 'moretagslist', 8 => 'art', 9 => 'cate_article_list', 10 => 'tags_article_list', ) ]
- [ DB ] CONNECT:[ UseTime:0.025954s ] mysql:dbname=briline.net;host=106.14.77.182;port=3306;charset=utf8
- [ SQL ] SHOW COLUMNS FROM `ob_config` [ RunTime:0.018311s ]
- [ SQL ] SELECT * FROM `ob_config` [ RunTime:0.017667s ]
- [ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'ob_config', 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 25, 'extra' => NULL, ) ]
- [ SQL ] SHOW COLUMNS FROM `ob_hook` [ RunTime:0.018862s ]
- [ SQL ] SELECT `id`,`name`,`addon_list` FROM `ob_hook` [ RunTime:0.017679s ]
- [ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'ob_hook', 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 3, 'extra' => NULL, ) ]
- [ SQL ] SHOW COLUMNS FROM `ob_article` [ RunTime:0.018691s ]
- [ SQL ] SELECT * FROM `ob_article` WHERE `id` = 5749 LIMIT 1 [ RunTime:0.017738s ]
- [ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'ob_article', 'type' => 'const', 'possible_keys' => 'PRIMARY', 'key' => 'PRIMARY', 'key_len' => '4', 'ref' => 'const', 'rows' => 1, 'extra' => NULL, ) ]
- [ SQL ] select * from `ob_article_tongji` where category_id=12 and mark_type='cate' order by times desc limit 15 [ RunTime:0.018516s ]
- [ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'ob_article_tongji', 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 608, 'extra' => 'Using where; Using filesort', ) ]
- [ SQL ] select * from `ob_article_tongji` where category_id=12 and mark_type='tags' order by times desc limit 100 [ RunTime:0.018252s ]
- [ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'ob_article_tongji', 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 608, 'extra' => 'Using where; Using filesort', ) ]
- [ SQL ] select * from `ob_article_tongji` where category_id=12 and mark_type='tags' order by rand() limit 30 [ RunTime:0.018852s ]
- [ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'ob_article_tongji', 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 608, 'extra' => 'Using where; Using temporary; Using filesort', ) ]
- [ SQL ] SELECT * FROM `ob_article` WHERE `id` = 5749 LIMIT 1 [ RunTime:0.017576s ]
- [ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'ob_article', 'type' => 'const', 'possible_keys' => 'PRIMARY', 'key' => 'PRIMARY', 'key_len' => '4', 'ref' => 'const', 'rows' => 1, 'extra' => NULL, ) ]
- [ SQL ] update `ob_article` set views=views+1 where id=5749 [ RunTime:0.021641s ]
- [ SQL ] SELECT COUNT(*) AS tp_count FROM `ob_article` WHERE `category_id` = 12 AND `cate` = '威海自媒体运营与推广' AND `status` <> -1 LIMIT 1 [ RunTime:0.025136s ]
- [ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'ob_article', 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 8035, 'extra' => 'Using where', ) ]
- [ SQL ] SELECT * FROM `ob_article` WHERE `category_id` = 12 AND `cate` = '威海自媒体运营与推广' AND `status` <> -1 ORDER BY rand() LIMIT 0,2 [ RunTime:0.052541s ]
- [ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'ob_article', 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 8035, 'extra' => 'Using where; Using temporary; Using filesort', ) ]
- [ SQL ] SELECT COUNT(*) AS tp_count FROM `ob_article` WHERE `category_id` = 12 AND `tags` = '威海百度智能小程序运营' AND `status` <> -1 LIMIT 1 [ RunTime:0.024576s ]
- [ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'ob_article', 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 8035, 'extra' => 'Using where', ) ]
- [ SQL ] SELECT * FROM `ob_article` WHERE `category_id` = 12 AND `tags` = '威海百度智能小程序运营' AND `status` <> -1 ORDER BY rand() LIMIT 0,2 [ RunTime:0.038540s ]
- [ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'ob_article', 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 8035, 'extra' => 'Using where; Using temporary; Using filesort', ) ]
