ThinkCMF | 星之书笔记

网名:Oliver Wien | 奥利弗·韦恩

职业:Web前端设计师、网页设计

现居地:陕西省-西安市-雁塔区

Phone:+86 182 2052 3738

Email:oliverwien@126.com

网站搭建之cmf安装教程（一）

Published on 16 Apr 2022 by OLIVER

这一章主讲cmf安装的问题，重点是环境检测“fileinfo报错”，以及数据表填写问题。关于“安装宝塔面板”与“安装模板插件”的教程，改天有时间再写。

Filed in , with 844 Reading

cmf获取指定分类的父级分类id

Published on 09 Mar 2020 by OLIVER

在使用cmf开发模板过程中，有时候需要获取指定分类的父级分类，可以用以下函数"_wien_parentCategoriesId()"；

Filed in cmf,父级分类,id, with 2622 Reading

cmf已上线网站，利用more增加扩展参数

Published on 24 Feb 2020 by OLIVER

以官方后台模板admin_simpleboot3为例，利用more增加扩展参数。并保证不影响编辑早期文章。

Filed in , with 2936 Reading

cmf当前分类页面调用的模板文件

Published on 17 Feb 2020 by OLIVER

有时候实际开发中，由于分类可能会建立比较多，容易搞混当前那分类调用的是那个模板，所有适当的修改一下，让操作更简单明了。

Filed in , with 2947 Reading

网名:Oliver Wien | 奥利弗·韦恩

职业:Web前端设计师、网页设计

现居地:陕西省-西安市-雁塔区

Phone:+86 182 2052 3738

Email:oliverwien@126.com

基本文件流程错误 SQL 调试

/www/wwwroot/wien.ren/public/index.php ( 1.05 KB )
/www/wwwroot/wien.ren/vendor/autoload.php ( 0.17 KB )
/www/wwwroot/wien.ren/vendor/composer/autoload_real.php ( 2.49 KB )
/www/wwwroot/wien.ren/vendor/composer/platform_check.php ( 0.90 KB )
/www/wwwroot/wien.ren/vendor/composer/ClassLoader.php ( 14.03 KB )
/www/wwwroot/wien.ren/vendor/composer/autoload_static.php ( 10.65 KB )
/www/wwwroot/wien.ren/vendor/topthink/think-helper/src/helper.php ( 7.35 KB )
/www/wwwroot/wien.ren/vendor/topthink/think-orm/stubs/load_stubs.php ( 0.16 KB )
/www/wwwroot/wien.ren/vendor/topthink/framework/src/think/Exception.php ( 1.69 KB )
/www/wwwroot/wien.ren/vendor/topthink/framework/src/think/Facade.php ( 2.71 KB )
/www/wwwroot/wien.ren/vendor/ezyang/htmlpurifier/library/HTMLPurifier.composer.php ( 0.10 KB )
/www/wwwroot/wien.ren/vendor/topthink/think-captcha/src/helper.php ( 1.37 KB )
/www/wwwroot/wien.ren/vendor/thinkcmf/cmf/src/common.php ( 63.19 KB )
/www/wwwroot/wien.ren/vendor/symfony/polyfill-mbstring/bootstrap.php ( 7.07 KB )
/www/wwwroot/wien.ren/vendor/symfony/polyfill-php72/bootstrap.php ( 1.89 KB )
/www/wwwroot/wien.ren/vendor/symfony/polyfill-php80/bootstrap.php ( 1.50 KB )
/www/wwwroot/wien.ren/vendor/symfony/var-dumper/Resources/functions/dump.php ( 0.79 KB )
/www/wwwroot/wien.ren/vendor/thinkcmf/cmf/src/App.php ( 16.95 KB )
/www/wwwroot/wien.ren/vendor/topthink/framework/src/think/Container.php ( 14.97 KB )
/www/wwwroot/wien.ren/vendor/psr/container/src/ContainerInterface.php ( 1.02 KB )
/www/wwwroot/wien.ren/vendor/thinkcmf/cmf-app/src/provider.php ( 0.24 KB )
/www/wwwroot/wien.ren/vendor/thinkcmf/cmf-route/src/Http.php ( 7.30 KB )
/www/wwwroot/wien.ren/vendor/topthink/think-helper/src/helper/Str.php ( 7.27 KB )
/www/wwwroot/wien.ren/vendor/topthink/framework/src/think/Env.php ( 4.15 KB )
/www/wwwroot/wien.ren/vendor/topthink/framework/src/helper.php ( 18.36 KB )
/www/wwwroot/wien.ren/vendor/topthink/framework/src/think/Config.php ( 5.03 KB )
/www/wwwroot/wien.ren/vendor/thinkcmf/cmf/src/config/app.php ( 1.35 KB )
/www/wwwroot/wien.ren/vendor/topthink/framework/src/think/facade/Env.php ( 1.67 KB )
/www/wwwroot/wien.ren/vendor/thinkcmf/cmf/src/config/cache.php ( 0.80 KB )
/www/wwwroot/wien.ren/vendor/thinkcmf/cmf/src/config/console.php ( 1.02 KB )
/www/wwwroot/wien.ren/vendor/thinkcmf/cmf/src/config/cookie.php ( 0.49 KB )
/www/wwwroot/wien.ren/vendor/thinkcmf/cmf/src/config/database.php ( 2.34 KB )
/www/wwwroot/wien.ren/vendor/thinkcmf/cmf/src/config/filesystem.php ( 0.63 KB )
/www/wwwroot/wien.ren/vendor/thinkcmf/cmf/src/config/lang.php ( 0.75 KB )
/www/wwwroot/wien.ren/vendor/thinkcmf/cmf/src/config/log.php ( 1.37 KB )
/www/wwwroot/wien.ren/vendor/thinkcmf/cmf/src/config/middleware.php ( 0.19 KB )
/www/wwwroot/wien.ren/vendor/thinkcmf/cmf/src/config/route.php ( 1.54 KB )
/www/wwwroot/wien.ren/vendor/thinkcmf/cmf/src/config/session.php ( 0.57 KB )
/www/wwwroot/wien.ren/vendor/thinkcmf/cmf/src/config/template.php ( 0.64 KB )
/www/wwwroot/wien.ren/vendor/thinkcmf/cmf/src/config/trace.php ( 0.34 KB )
/www/wwwroot/wien.ren/vendor/thinkcmf/cmf/src/config/view.php ( 1.06 KB )
/www/wwwroot/wien.ren/data/config/database.php ( 2.41 KB )
/www/wwwroot/wien.ren/data/config/template.php ( 0.11 KB )
/www/wwwroot/wien.ren/vendor/thinkcmf/cmf-app/src/event.php ( 0.64 KB )
/www/wwwroot/wien.ren/vendor/topthink/framework/src/think/Event.php ( 6.96 KB )
/www/wwwroot/wien.ren/vendor/topthink/framework/src/think/Lang.php ( 8.29 KB )
/www/wwwroot/wien.ren/vendor/topthink/framework/src/lang/zh-cn.php ( 12.88 KB )
/www/wwwroot/wien.ren/vendor/thinkcmf/cmf/src/listener/LangListener.php ( 1.76 KB )
/www/wwwroot/wien.ren/vendor/thinkcmf/cmf/src/lang/zh-cn.php ( 3.14 KB )
/www/wwwroot/wien.ren/vendor/thinkcmf/cmf-app/src/admin/lang/zh-cn/common.php ( 0.60 KB )
/www/wwwroot/wien.ren/app/portal/lang/zh-cn/common.php ( 0.76 KB )
/www/wwwroot/wien.ren/vendor/thinkcmf/cmf/src/listener/InitHookListener.php ( 2.58 KB )
/www/wwwroot/wien.ren/vendor/topthink/framework/src/think/facade/Route.php ( 4.76 KB )
/www/wwwroot/wien.ren/vendor/thinkcmf/cmf-route/src/Route.php ( 23.45 KB )
/www/wwwroot/wien.ren/vendor/topthink/framework/src/think/route/RuleName.php ( 5.30 KB )
/www/wwwroot/wien.ren/vendor/topthink/framework/src/think/route/Domain.php ( 5.41 KB )
/www/wwwroot/wien.ren/vendor/topthink/framework/src/think/route/RuleGroup.php ( 13.91 KB )
/www/wwwroot/wien.ren/vendor/thinkcmf/cmf-route/src/route/Rule.php ( 22.99 KB )
/www/wwwroot/wien.ren/vendor/topthink/framework/src/think/route/RuleItem.php ( 9.22 KB )
/www/wwwroot/wien.ren/vendor/topthink/framework/src/think/facade/Cache.php ( 2.02 KB )
/www/wwwroot/wien.ren/vendor/topthink/framework/src/think/Cache.php ( 4.79 KB )
/www/wwwroot/wien.ren/vendor/topthink/framework/src/think/Manager.php ( 3.98 KB )
/www/wwwroot/wien.ren/vendor/psr/simple-cache/src/CacheInterface.php ( 4.50 KB )
/www/wwwroot/wien.ren/vendor/topthink/think-helper/src/helper/Arr.php ( 15.54 KB )
/www/wwwroot/wien.ren/vendor/topthink/framework/src/think/cache/driver/File.php ( 7.41 KB )
/www/wwwroot/wien.ren/vendor/topthink/framework/src/think/cache/Driver.php ( 8.01 KB )
/www/wwwroot/wien.ren/vendor/topthink/framework/src/think/contract/CacheHandlerInterface.php ( 2.25 KB )
/www/wwwroot/wien.ren/vendor/topthink/think-orm/src/facade/Db.php ( 0.94 KB )
/www/wwwroot/wien.ren/vendor/topthink/framework/src/think/Db.php ( 2.87 KB )
/www/wwwroot/wien.ren/vendor/topthink/think-orm/src/DbManager.php ( 8.31 KB )
/www/wwwroot/wien.ren/vendor/topthink/framework/src/think/Log.php ( 8.50 KB )
/www/wwwroot/wien.ren/vendor/psr/log/Psr/Log/LoggerInterface.php ( 3.04 KB )
/www/wwwroot/wien.ren/vendor/topthink/think-orm/src/db/connector/Mysql.php ( 4.39 KB )
/www/wwwroot/wien.ren/vendor/topthink/think-orm/src/db/PDOConnection.php ( 50.67 KB )
/www/wwwroot/wien.ren/vendor/topthink/think-orm/src/db/Connection.php ( 7.67 KB )
/www/wwwroot/wien.ren/vendor/topthink/think-orm/src/db/ConnectionInterface.php ( 4.56 KB )
/www/wwwroot/wien.ren/vendor/topthink/think-orm/src/db/builder/Mysql.php ( 14.22 KB )
/www/wwwroot/wien.ren/vendor/topthink/think-orm/src/db/Builder.php ( 39.52 KB )
/www/wwwroot/wien.ren/vendor/topthink/think-orm/src/db/Query.php ( 11.10 KB )
/www/wwwroot/wien.ren/vendor/topthink/think-orm/src/db/BaseQuery.php ( 36.12 KB )
/www/wwwroot/wien.ren/vendor/topthink/think-orm/src/db/concern/TimeFieldQuery.php ( 7.50 KB )
/www/wwwroot/wien.ren/vendor/topthink/think-orm/src/db/concern/AggregateQuery.php ( 2.83 KB )
/www/wwwroot/wien.ren/vendor/topthink/think-orm/src/db/concern/ModelRelationQuery.php ( 15.49 KB )
/www/wwwroot/wien.ren/vendor/topthink/think-orm/src/db/concern/ResultOperation.php ( 7.40 KB )
/www/wwwroot/wien.ren/vendor/topthink/think-orm/src/db/concern/Transaction.php ( 2.85 KB )
/www/wwwroot/wien.ren/vendor/topthink/think-orm/src/db/concern/WhereQuery.php ( 16.37 KB )
/www/wwwroot/wien.ren/vendor/topthink/think-orm/src/db/concern/JoinAndViewQuery.php ( 6.88 KB )
/www/wwwroot/wien.ren/vendor/topthink/think-orm/src/db/concern/ParamsBind.php ( 2.75 KB )
/www/wwwroot/wien.ren/vendor/topthink/think-orm/src/db/concern/TableFieldInfo.php ( 2.51 KB )
/www/wwwroot/wien.ren/vendor/topthink/framework/src/think/log/driver/File.php ( 6.04 KB )
/www/wwwroot/wien.ren/vendor/topthink/framework/src/think/contract/LogHandlerInterface.php ( 0.86 KB )
/www/wwwroot/wien.ren/vendor/topthink/framework/src/think/log/Channel.php ( 6.54 KB )
/www/wwwroot/wien.ren/vendor/topthink/framework/src/think/event/LogRecord.php ( 0.86 KB )
/www/wwwroot/wien.ren/vendor/topthink/think-helper/src/Collection.php ( 15.88 KB )
/www/wwwroot/wien.ren/vendor/topthink/think-helper/src/contract/Arrayable.php ( 0.09 KB )
/www/wwwroot/wien.ren/vendor/topthink/think-helper/src/contract/Jsonable.php ( 0.13 KB )
/www/wwwroot/wien.ren/vendor/topthink/framework/src/think/initializer/Error.php ( 3.19 KB )
/www/wwwroot/wien.ren/vendor/topthink/framework/src/think/initializer/RegisterService.php ( 1.33 KB )
/www/wwwroot/wien.ren/vendor/services.php ( 0.22 KB )
/www/wwwroot/wien.ren/vendor/topthink/framework/src/think/service/PaginatorService.php ( 1.52 KB )
/www/wwwroot/wien.ren/vendor/topthink/framework/src/think/Service.php ( 1.67 KB )
/www/wwwroot/wien.ren/vendor/topthink/framework/src/think/service/ValidateService.php ( 0.99 KB )
/www/wwwroot/wien.ren/vendor/topthink/framework/src/think/service/ModelService.php ( 1.76 KB )
/www/wwwroot/wien.ren/vendor/topthink/think-captcha/src/CaptchaService.php ( 0.52 KB )
/www/wwwroot/wien.ren/vendor/topthink/think-trace/src/Service.php ( 0.77 KB )
/www/wwwroot/wien.ren/vendor/topthink/framework/src/think/Middleware.php ( 6.78 KB )
/www/wwwroot/wien.ren/vendor/topthink/framework/src/think/initializer/BootService.php ( 0.77 KB )
/www/wwwroot/wien.ren/vendor/topthink/think-orm/src/Paginator.php ( 11.40 KB )
/www/wwwroot/wien.ren/vendor/topthink/framework/src/think/Validate.php ( 46.10 KB )
/www/wwwroot/wien.ren/vendor/topthink/think-orm/src/Model.php ( 26.11 KB )
/www/wwwroot/wien.ren/vendor/topthink/think-orm/src/model/concern/Attribute.php ( 17.00 KB )
/www/wwwroot/wien.ren/vendor/topthink/think-orm/src/model/concern/RelationShip.php ( 26.12 KB )
/www/wwwroot/wien.ren/vendor/topthink/think-orm/src/model/concern/ModelEvent.php ( 2.27 KB )
/www/wwwroot/wien.ren/vendor/topthink/think-orm/src/model/concern/TimeStamp.php ( 5.70 KB )
/www/wwwroot/wien.ren/vendor/topthink/think-orm/src/model/concern/Conversion.php ( 9.54 KB )
/www/wwwroot/wien.ren/vendor/topthink/framework/src/think/Request.php ( 53.80 KB )
/www/wwwroot/wien.ren/vendor/thinkcmf/cmf-app/src/middleware.php ( 0.25 KB )
/www/wwwroot/wien.ren/vendor/topthink/framework/src/think/Pipeline.php ( 2.61 KB )
/www/wwwroot/wien.ren/vendor/topthink/think-trace/src/TraceDebug.php ( 2.94 KB )
/www/wwwroot/wien.ren/vendor/topthink/framework/src/think/middleware/SessionInit.php ( 2.02 KB )
/www/wwwroot/wien.ren/vendor/topthink/framework/src/think/Session.php ( 1.80 KB )
/www/wwwroot/wien.ren/vendor/topthink/framework/src/think/session/driver/File.php ( 6.28 KB )
/www/wwwroot/wien.ren/vendor/topthink/framework/src/think/contract/SessionHandlerInterface.php ( 0.87 KB )
/www/wwwroot/wien.ren/vendor/topthink/framework/src/think/session/Store.php ( 7.26 KB )
/www/wwwroot/wien.ren/data/route/route.php ( 0.03 KB )
/www/wwwroot/wien.ren/vendor/thinkcmf/cmf-route/src/route/dispatch/Url.php ( 3.58 KB )
/www/wwwroot/wien.ren/vendor/thinkcmf/cmf-route/src/route/dispatch/Controller.php ( 7.29 KB )
/www/wwwroot/wien.ren/vendor/topthink/framework/src/think/route/Dispatch.php ( 6.58 KB )
/www/wwwroot/wien.ren/vendor/thinkcmf/cmf/src/listener/InitAppHookListener.php ( 2.67 KB )
/www/wwwroot/wien.ren/app/portal/lang/zh-cn.php ( 0.93 KB )
/www/wwwroot/wien.ren/app/portal/controller/ListController.php ( 1.39 KB )
/www/wwwroot/wien.ren/vendor/thinkcmf/cmf/src/controller/HomeBaseController.php ( 8.39 KB )
/www/wwwroot/wien.ren/vendor/thinkcmf/cmf/src/controller/BaseController.php ( 10.56 KB )
/www/wwwroot/wien.ren/vendor/thinkcmf/think-template/src/View.php ( 5.09 KB )
/www/wwwroot/wien.ren/vendor/topthink/framework/src/think/facade/Config.php ( 1.37 KB )
/www/wwwroot/wien.ren/vendor/topthink/framework/src/think/facade/Event.php ( 1.79 KB )
/www/wwwroot/wien.ren/vendor/topthink/framework/src/think/facade/Cookie.php ( 1.49 KB )
/www/wwwroot/wien.ren/vendor/topthink/framework/src/think/Cookie.php ( 6.15 KB )
/www/wwwroot/wien.ren/vendor/thinkcmf/think-view/src/Think.php ( 8.42 KB )
/www/wwwroot/wien.ren/vendor/thinkcmf/think-template/src/Template.php ( 47.37 KB )
/www/wwwroot/wien.ren/vendor/thinkcmf/think-template/src/template/driver/File.php ( 2.33 KB )
/www/wwwroot/wien.ren/vendor/thinkcmf/cmf/src/listener/HomeLangListener.php ( 1.28 KB )
/www/wwwroot/wien.ren/app/portal/lang/zh-cn/home.php ( 0.62 KB )
/www/wwwroot/wien.ren/app/portal/model/PortalCategoryModel.php ( 9.20 KB )
/www/wwwroot/wien.ren/vendor/thinkcmf/cmf-app/src/admin/model/ThemeModel.php ( 8.13 KB )
/www/wwwroot/wien.ren/vendor/thinkcmf/cmf-app/src/admin/model/ThemeFileModel.php ( 0.89 KB )
/www/wwwroot/wien.ren/vendor/topthink/think-orm/src/model/Collection.php ( 6.42 KB )
/www/wwwroot/wien.ren/data/runtime/temp/d2e346daac59fc75f47c32558ca2b57d.php ( 21.83 KB )
/www/wwwroot/wien.ren/vendor/thinkcmf/cmf-app/src/admin/model/NavMenuModel.php ( 6.83 KB )
/www/wwwroot/wien.ren/vendor/thinkcmf/cmf-app/src/admin/model/NavModel.php ( 0.81 KB )
/www/wwwroot/wien.ren/vendor/thinkcmf/cmf-extend/src/tree/Tree.php ( 14.39 KB )
/www/wwwroot/wien.ren/vendor/thinkcmf/cmf-app/src/admin/model/RouteModel.php ( 8.86 KB )
/www/wwwroot/wien.ren/app/portal/url.php ( 1.55 KB )
/www/wwwroot/wien.ren/vendor/thinkcmf/cmf-app/src/user/url.php ( 0.99 KB )
/www/wwwroot/wien.ren/vendor/thinkcmf/cmf-route/src/route/Url.php ( 14.94 KB )
/www/wwwroot/wien.ren/vendor/thinkcmf/cmf/src/lib/Storage.php ( 3.90 KB )
/www/wwwroot/wien.ren/vendor/thinkcmf/cmf/src/lib/storage/Local.php ( 2.86 KB )
/www/wwwroot/wien.ren/app/portal/service/ApiService.php ( 17.63 KB )
/www/wwwroot/wien.ren/app/portal/model/PortalPostModel.php ( 11.58 KB )
/www/wwwroot/wien.ren/vendor/topthink/think-orm/src/db/Raw.php ( 1.47 KB )
/www/wwwroot/wien.ren/vendor/topthink/think-orm/src/db/Fetch.php ( 12.90 KB )
/www/wwwroot/wien.ren/vendor/thinkcmf/cmf/src/paginator/Bootstrap.php ( 7.37 KB )
/www/wwwroot/wien.ren/app/portal/model/UserModel.php ( 0.81 KB )
/www/wwwroot/wien.ren/vendor/topthink/think-orm/src/model/relation/BelongsTo.php ( 11.04 KB )
/www/wwwroot/wien.ren/vendor/topthink/think-orm/src/model/relation/OneToOne.php ( 9.83 KB )
/www/wwwroot/wien.ren/vendor/topthink/think-orm/src/model/Relation.php ( 6.88 KB )
/www/wwwroot/wien.ren/app/portal/model/PortalTagModel.php ( 0.85 KB )
/www/wwwroot/wien.ren/vendor/topthink/framework/src/think/Response.php ( 8.54 KB )
/www/wwwroot/wien.ren/vendor/topthink/framework/src/think/response/Html.php ( 0.98 KB )
/www/wwwroot/wien.ren/vendor/topthink/think-trace/src/Html.php ( 4.37 KB )

CONNECT:[ UseTime:0.000479s ] mysql:host=127.0.0.1;port=3306;dbname=wien_ren;charset=utf8mb4
SHOW FULL COLUMNS FROM `cmf_hook` [ RunTime:0.000749s ]
SELECT `hook`,`id` FROM `cmf_hook` WHERE ( ( `app` = '' OR `app` = 'cmf' ) AND `type` = 3 ) OR `type` = 1 [ RunTime:0.000361s ]
SHOW FULL COLUMNS FROM `cmf_hook_plugin` [ RunTime:0.000513s ]
SELECT `hook`,`plugin` FROM `cmf_hook_plugin` WHERE `status` = 1 AND `hook` IN ('app_init','app_begin','module_init','action_begin','view_filter','app_end','log_write','response_end','admin_init','home_init','send_mobile_verification_code','body_start','before_head_end','footer_start','before_footer','before_footer_end','before_body_end','left_sidebar_start','before_left_sidebar_end','right_sidebar_start','before_right_sidebar_end','comment','guestbook','switch_theme','after_content','before_content','log_write_done','switch_admin_theme','captcha_image','app_dispatch') ORDER BY `list_order` ASC [ RunTime:0.000364s ]
SHOW FULL COLUMNS FROM `cmf_portal_category` [ RunTime:0.000771s ]
SELECT * FROM `cmf_portal_category` WHERE `id` = 12 AND `status` = 1 LIMIT 1 [ RunTime:0.000317s ]
SHOW FULL COLUMNS FROM `cmf_theme_file` [ RunTime:0.000779s ]
SELECT * FROM `cmf_theme_file` WHERE `theme` = 'BookStars' AND `file` = 'portal/article' LIMIT 1 [ RunTime:0.000345s ]
UPDATE `cmf_theme_file` SET `theme` = 'BookStars' , `action` = 'portal/Article/index' , `file` = 'portal/article' , `name` = '文章内容页' , `more` = '{\"vars\":[]}' , `config_more` = '{\"vars\":[]}' , `description` = '文章内容页文件' , `is_public` = 0 , `list_order` = '10' WHERE `theme` = 'BookStars' AND `file` = 'portal/article' [ RunTime:0.003425s ]
SELECT * FROM `cmf_theme_file` WHERE `theme` = 'BookStars' AND `file` = 'portal/article_theme' LIMIT 1 [ RunTime:0.000356s ]
UPDATE `cmf_theme_file` SET `theme` = 'BookStars' , `action` = 'portal/Article/index' , `file` = 'portal/article_theme' , `name` = '模板内容' , `more` = '{\"vars\":[]}' , `config_more` = '{\"vars\":[]}' , `description` = '模板内容文件' , `is_public` = 0 , `list_order` = '15' WHERE `theme` = 'BookStars' AND `file` = 'portal/article_theme' [ RunTime:0.003390s ]
SELECT * FROM `cmf_theme_file` WHERE `theme` = 'BookStars' AND `file` = 'portal/index' LIMIT 1 [ RunTime:0.000458s ]
UPDATE `cmf_theme_file` SET `theme` = 'BookStars' , `action` = 'portal/Index/index' , `file` = 'portal/index' , `name` = '首页' , `more` = '{\"vars\":[],\"widgets\":[]}' , `config_more` = '{\"vars\":[],\"widgets\":[]}' , `description` = '首页文件' , `is_public` = 0 , `list_order` = '5' WHERE `theme` = 'BookStars' AND `file` = 'portal/index' [ RunTime:0.003481s ]
SELECT * FROM `cmf_theme_file` WHERE `theme` = 'BookStars' AND `file` = 'portal/list' LIMIT 1 [ RunTime:0.000393s ]
UPDATE `cmf_theme_file` SET `theme` = 'BookStars' , `action` = 'portal/List/index' , `file` = 'portal/list' , `name` = '文章列表' , `more` = '{\"vars\":[],\"widgets\":[]}' , `config_more` = '{\"vars\":[],\"widgets\":[]}' , `description` = '文章列表文件' , `is_public` = 0 , `list_order` = '10' WHERE `theme` = 'BookStars' AND `file` = 'portal/list' [ RunTime:0.003141s ]
SELECT * FROM `cmf_theme_file` WHERE `theme` = 'BookStars' AND `file` = 'portal/list_flow' LIMIT 1 [ RunTime:0.000370s ]
UPDATE `cmf_theme_file` SET `theme` = 'BookStars' , `action` = 'portal/List/index' , `file` = 'portal/list_flow' , `name` = '流式列表页' , `more` = '{\"vars\":[],\"widgets\":[]}' , `config_more` = '{\"vars\":[],\"widgets\":[]}' , `description` = '流式列表页' , `is_public` = 0 , `list_order` = '10' WHERE `theme` = 'BookStars' AND `file` = 'portal/list_flow' [ RunTime:0.003081s ]
SELECT * FROM `cmf_theme_file` WHERE `theme` = 'BookStars' AND `file` = 'portal/list_theme' LIMIT 1 [ RunTime:0.000325s ]
UPDATE `cmf_theme_file` SET `theme` = 'BookStars' , `action` = 'portal/List/index' , `file` = 'portal/list_theme' , `name` = '模板列表页' , `more` = '{\"vars\":[],\"widgets\":[]}' , `config_more` = '{\"vars\":[],\"widgets\":[]}' , `description` = '模板列表页文件' , `is_public` = 0 , `list_order` = '15' WHERE `theme` = 'BookStars' AND `file` = 'portal/list_theme' [ RunTime:0.002999s ]
SELECT * FROM `cmf_theme_file` WHERE `theme` = 'BookStars' AND `file` = 'portal/page' LIMIT 1 [ RunTime:0.000304s ]
UPDATE `cmf_theme_file` SET `theme` = 'BookStars' , `action` = 'portal/Page/index' , `file` = 'portal/page' , `name` = '单页面' , `more` = '{\"widgets\":[]}' , `config_more` = '{\"widgets\":[]}' , `description` = '单页面模板文件' , `is_public` = 0 , `list_order` = '10' WHERE `theme` = 'BookStars' AND `file` = 'portal/page' [ RunTime:0.003035s ]
SELECT * FROM `cmf_theme_file` WHERE `theme` = 'BookStars' AND `file` = 'public/config' LIMIT 1 [ RunTime:0.000401s ]
UPDATE `cmf_theme_file` SET `theme` = 'BookStars' , `action` = 'public/Config' , `file` = 'public/config' , `name` = '模板全局配置' , `more` = '{\"vars\":{\"avatar\":{\"title\":\"Avatar\",\"value\":\"default\\/20200215\\/b8c466a01775dc03b1570bd5a4c29aaa.jpg\",\"type\":\"image\",\"tip\":\"\\u7ad9\\u957f\\u5934\\u50cf\",\"rule\":[]},\"user_name\":{\"title\":\"User Name\",\"value\":\"Oliver Wien | \\u5965\\u5229\\u5f17\\u00b7\\u97e6\\u6069\",\"type\":\"text\",\"tip\":\"\",\"rule\":{\"require\":true}},\"user_job\":{\"title\":\"User Job\",\"value\":\"Web\\u524d\\u7aef\\u8bbe\\u8ba1\\u5e08\\u3001\\u7f51\\u9875\\u8bbe\\u8ba1\",\"type\":\"textarea\",\"tip\":\"\",\"rule\":{\"require\":true}},\"address\":{\"title\":\"Address\",\"value\":\"\\u9655\\u897f\\u7701-\\u897f\\u5b89\\u5e02-\\u96c1\\u5854\\u533a\",\"type\":\"text\",\"tip\":\"\",\"rule\":{\"require\":true}},\"email\":{\"title\":\"Email\",\"value\":\"oliverwien@126.com\",\"type\":\"text\",\"tip\":\"\",\"rule\":{\"require\":true}},\"phone\":{\"title\":\"Phone\",\"value\":\"010 1010 1010\",\"type\":\"text\",\"tip\":\"\",\"rule\":{\"require\":true}},\"mobile_phone\":{\"title\":\"Mobile Phone\",\"value\":\"+86 182 2052 3738\",\"type\":\"text\",\"tip\":\"\",\"rule\":[]},\"qq\":{\"title\":\"QQ\",\"value\":\"921030087\",\"type\":\"text\",\"tip\":\"\\u591a\\u4e2a QQ\\u4ee5\\u82f1\\u6587\\u9017\\u53f7\\u9694\\u5f00\",\"rule\":{\"require\":true}},\"wechat_number\":{\"title\":\"Wechat Number\",\"value\":\"oliverwien\",\"type\":\"text\",\"tip\":\"\\u5fae\\u4fe1\\u53f7\",\"rule\":[]},\"wechat_code\":{\"title\":\"Wechat Code\",\"value\":\"default\\/20200215\\/bcf7ba9a39f7b9cf2b492ef73f5de6b3.jpg\",\"type\":\"image\",\"tip\":\"\\u5fae\\u4fe1\\u4e8c\\u7ef4\\u7801\\u8bbe\\u7f6e\",\"rule\":[]}}}' , `config_more` = '{\"vars\":{\"avatar\":{\"title\":\"Avatar\",\"value\":\"\",\"type\":\"image\",\"tip\":\"\\u7ad9\\u957f\\u5934\\u50cf\",\"rule\":[]},\"user_name\":{\"title\":\"User Name\",\"value\":\"Oliver Wien | \\u5965\\u5229\\u5f17\\u00b7\\u97e6\\u6069\",\"type\":\"text\",\"tip\":\"\",\"rule\":{\"require\":true}},\"user_job\":{\"title\":\"User Job\",\"value\":\"Web\\u524d\\u7aef\\u8bbe\\u8ba1\\u5e08\\u3001\\u7f51\\u9875\\u8bbe\\u8ba1\",\"type\":\"textarea\",\"tip\":\"\",\"rule\":{\"require\":true}},\"address\":{\"title\":\"Address\",\"value\":\"\\u9655\\u897f\\u7701-\\u897f\\u5b89\\u5e02\",\"type\":\"text\",\"tip\":\"\",\"rule\":{\"require\":true}},\"email\":{\"title\":\"Email\",\"value\":\"oliverwien@126.com\",\"type\":\"text\",\"tip\":\"\",\"rule\":{\"require\":true}},\"phone\":{\"title\":\"Phone\",\"value\":\"010 1010 1010\",\"type\":\"text\",\"tip\":\"\",\"rule\":{\"require\":true}},\"mobile_phone\":{\"title\":\"Mobile Phone\",\"value\":\"+86 182 2052 3738\",\"type\":\"text\",\"tip\":\"\",\"rule\":[]},\"qq\":{\"title\":\"QQ\",\"value\":\"921030087\",\"type\":\"text\",\"tip\":\"\\u591a\\u4e2a QQ\\u4ee5\\u82f1\\u6587\\u9017\\u53f7\\u9694\\u5f00\",\"rule\":{\"require\":true}},\"wechat_number\":{\"title\":\"Wechat Number\",\"value\":\"oliverwien\",\"type\":\"text\",\"tip\":\"\\u5fae\\u4fe1\\u53f7\",\"rule\":[]},\"wechat_code\":{\"title\":\"Wechat Code\",\"value\":\"\",\"type\":\"image\",\"tip\":\"\\u5fae\\u4fe1\\u4e8c\\u7ef4\\u7801\\u8bbe\\u7f6e\",\"rule\":[]}}}' , `description` = '模板全局配置文件' , `is_public` = 1 , `list_order` = '0' WHERE `theme` = 'BookStars' AND `file` = 'public/config' [ RunTime:0.003247s ]
SELECT * FROM `cmf_theme_file` WHERE `theme` = 'BookStars' AND `file` = 'public/footer' LIMIT 1 [ RunTime:0.000485s ]
UPDATE `cmf_theme_file` SET `theme` = 'BookStars' , `action` = 'public/Footer' , `file` = 'public/footer' , `name` = '通用底部' , `more` = '{\"vars\":[],\"widgets\":[]}' , `config_more` = '{\"vars\":[],\"widgets\":[]}' , `description` = '导航条模板文件' , `is_public` = 1 , `list_order` = '10' WHERE `theme` = 'BookStars' AND `file` = 'public/footer' [ RunTime:0.003228s ]
SELECT * FROM `cmf_theme_file` WHERE `theme` = 'BookStars' AND `file` = 'public/nav' LIMIT 1 [ RunTime:0.000338s ]
UPDATE `cmf_theme_file` SET `theme` = 'BookStars' , `action` = 'public/Nav' , `file` = 'public/nav' , `name` = '导航条' , `more` = '{\"vars\":[]}' , `config_more` = '{\"vars\":[]}' , `description` = '导航条模板文件' , `is_public` = 1 , `list_order` = '1' WHERE `theme` = 'BookStars' AND `file` = 'public/nav' [ RunTime:0.003112s ]
SELECT * FROM `cmf_theme_file` WHERE `theme` = 'BookStars' AND `file` = 'public/sidebar' LIMIT 1 [ RunTime:0.000306s ]
UPDATE `cmf_theme_file` SET `theme` = 'BookStars' , `action` = 'public/Sidebar' , `file` = 'public/sidebar' , `name` = '导航条' , `more` = '{\"vars\":[],\"widgets\":{\"latest_posts\":{\"title\":\"Latest posts\",\"display\":1,\"vars\":{\"latest_posts_category_id\":{\"title\":\"\\u6587\\u7ae0\\u5206\\u7c7bID\",\"value\":\"2\",\"type\":\"text\",\"dataSource\":{\"api\":\"portal\\/Category\\/index\",\"multi\":true},\"placeholder\":\"\\u8bf7\\u9009\\u62e9\\u5206\\u7c7b\",\"tip\":\"\\u53ef\\u591a\\u9009\",\"rule\":{\"require\":true},\"valueText\":\"\\u5f00\\u53d1\\u7b14\\u8bb0\"}}},\"categories\":{\"title\":\"Categories\",\"display\":1,\"vars\":{\"category_id\":{\"title\":\"\\u6587\\u7ae0\\u5206\\u7c7bID\",\"value\":\"2\",\"type\":\"text\",\"dataSource\":{\"api\":\"portal\\/Category\\/index\",\"multi\":true},\"placeholder\":\"\\u8bf7\\u9009\\u62e9\\u5206\\u7c7b\",\"tip\":\"\\u53ea\\u5355\\u9009\\uff0c\\u9009\\u62e9\\u7236\\u7ea7\\u5206\\u7c7bid\",\"rule\":{\"require\":true},\"valueText\":\"\\u5f00\\u53d1\\u7b14\\u8bb0\"}}}}}' , `config_more` = '{\"vars\":[],\"widgets\":{\"latest_posts\":{\"title\":\"Latest posts\",\"display\":\"1\",\"vars\":{\"latest_posts_category_id\":{\"title\":\"\\u6587\\u7ae0\\u5206\\u7c7bID\",\"value\":\"\",\"type\":\"text\",\"dataSource\":{\"api\":\"portal\\/Category\\/index\",\"multi\":true},\"placeholder\":\"\\u8bf7\\u9009\\u62e9\\u5206\\u7c7b\",\"tip\":\"\\u53ef\\u591a\\u9009\",\"rule\":{\"require\":true}}}},\"categories\":{\"title\":\"Categories\",\"display\":\"1\",\"vars\":{\"category_id\":{\"title\":\"\\u6587\\u7ae0\\u5206\\u7c7bID\",\"value\":\"\",\"type\":\"text\",\"dataSource\":{\"api\":\"portal\\/Category\\/index\",\"multi\":true},\"placeholder\":\"\\u8bf7\\u9009\\u62e9\\u5206\\u7c7b\",\"tip\":\"\\u53ea\\u5355\\u9009\\uff0c\\u9009\\u62e9\\u7236\\u7ea7\\u5206\\u7c7bid\",\"rule\":{\"require\":true}}}}}}' , `description` = '侧边栏模板文件' , `is_public` = 1 , `list_order` = '1' WHERE `theme` = 'BookStars' AND `file` = 'public/sidebar' [ RunTime:0.003215s ]
SELECT * FROM `cmf_theme_file` WHERE `theme` = 'BookStars' [ RunTime:0.000341s ]
SHOW FULL COLUMNS FROM `cmf_theme` [ RunTime:0.000643s ]
UPDATE `cmf_theme` SET `name` = 'BookStars' , `version` = '1.0.5' , `demo_url` = 'http://blog.wien.ren' , `author` = 'OLIVER_WIEN' , `lang` = 'zh-cn' , `author_url` = 'http://blog.wien.ren' , `keywords` = '《BookStars》,响应式,博客' , `description` = '《BookStars》星之书笔记' WHERE `theme` = 'BookStars' [ RunTime:0.003234s ]
SELECT `more` FROM `cmf_theme_file` WHERE `theme` = 'BookStars' AND ( `is_public` = 1 OR `file` = 'portal/list' ) [ RunTime:0.000286s ]
SHOW FULL COLUMNS FROM `cmf_nav` [ RunTime:0.000483s ]
SELECT `id` FROM `cmf_nav` WHERE `is_main` = 1 LIMIT 1 [ RunTime:0.000180s ]
SHOW FULL COLUMNS FROM `cmf_nav_menu` [ RunTime:0.000413s ]
SELECT * FROM `cmf_nav_menu` WHERE `nav_id` = 1 AND `status` = 1 ORDER BY `list_order` ASC [ RunTime:0.000309s ]
SHOW FULL COLUMNS FROM `cmf_portal_post` [ RunTime:0.000651s ]
SELECT COUNT(*) AS think_count FROM ( SELECT count(*) AS think_count FROM `cmf_portal_post` `post` INNER JOIN `cmf_portal_category_post` `category_post` ON `post`.`id`=`category_post`.`post_id` WHERE `post`.`post_status` = '1' AND `post`.`post_type` = '1' AND `post`.`delete_time` = '0' AND ( `post`.`create_time` >= '0' ) AND ( `category_post`.`category_id` = '12' ) AND ( `post`.`published_time` > '0' AND `post`.`published_time` < '1686247999' ) GROUP BY `post`.`id` ) `_group_count_` LIMIT 1 [ RunTime:0.001468s ]
SELECT post.*,min(category_post.category_id) as category_id FROM `cmf_portal_post` `post` INNER JOIN `cmf_portal_category_post` `category_post` ON `post`.`id`=`category_post`.`post_id` WHERE `post`.`post_status` = '1' AND `post`.`post_type` = '1' AND `post`.`delete_time` = '0' AND ( `post`.`create_time` >= '0' ) AND ( `category_post`.`category_id` = '12' ) AND ( `post`.`published_time` > '0' AND `post`.`published_time` < '1686247999' ) GROUP BY `post`.`id` ORDER BY `post`.`create_time` DESC LIMIT 0,4 [ RunTime:0.001931s ]
SHOW FULL COLUMNS FROM `cmf_user` [ RunTime:0.000560s ]
SELECT * FROM `cmf_user` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000304s ]
SELECT * FROM `cmf_user` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000279s ]
SELECT * FROM `cmf_user` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000261s ]
SELECT * FROM `cmf_user` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000246s ]
SELECT COUNT(*) AS think_count FROM ( SELECT count(*) AS think_count FROM `cmf_portal_post` `post` INNER JOIN `cmf_portal_category_post` `category_post` ON `post`.`id`=`category_post`.`post_id` WHERE `post`.`post_status` = '1' AND `post`.`post_type` = '1' AND `post`.`delete_time` = '0' AND ( `category_post`.`category_id` = '2' ) AND ( `post`.`published_time` > '0' AND `post`.`published_time` < '1686247999' ) GROUP BY `post`.`id` ) `_group_count_` LIMIT 1 [ RunTime:0.002963s ]
SELECT post.*,min(category_post.category_id) as category_id FROM `cmf_portal_post` `post` INNER JOIN `cmf_portal_category_post` `category_post` ON `post`.`id`=`category_post`.`post_id` WHERE `post`.`post_status` = '1' AND `post`.`post_type` = '1' AND `post`.`delete_time` = '0' AND ( `category_post`.`category_id` = '2' ) AND ( `post`.`published_time` > '0' AND `post`.`published_time` < '1686247999' ) GROUP BY `post`.`id` ORDER BY `post`.`published_time` DESC LIMIT 0,10 [ RunTime:0.004067s ]
SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 2 [ RunTime:0.000445s ]
SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 5 [ RunTime:0.000306s ]
SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 6 [ RunTime:0.000295s ]
SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 8 [ RunTime:0.000289s ]
SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 9 [ RunTime:0.000325s ]
SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 10 [ RunTime:0.000275s ]
SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 11 [ RunTime:0.000258s ]
SHOW FULL COLUMNS FROM `cmf_portal_tag` [ RunTime:0.000516s ]
SELECT * FROM `cmf_portal_tag` `tag` [ RunTime:0.000252s ]

0.158521s

ShowPageTrace