开发者博客 - XQQ8素材

基本文件流程错误 SQL 调试

/www/wwwroot/xqq8.com/public/index.php ( 0.97 KB )
/www/wwwroot/xqq8.com/vendor/thinkphp/base.php ( 1.71 KB )
/www/wwwroot/xqq8.com/vendor/thinkphp/library/think/Loader.php ( 12.70 KB )
/www/wwwroot/xqq8.com/vendor/composer/autoload_static.php ( 6.85 KB )
/www/wwwroot/xqq8.com/vendor/thinkphp/library/think/Error.php ( 4.00 KB )
/www/wwwroot/xqq8.com/vendor/thinkphp/library/think/Container.php ( 15.53 KB )
/www/wwwroot/xqq8.com/vendor/thinkcmf/cmf/src/App.php ( 29.40 KB )
/www/wwwroot/xqq8.com/vendor/thinkphp/library/think/Env.php ( 2.85 KB )
/www/wwwroot/xqq8.com/vendor/thinkphp/library/think/Config.php ( 9.71 KB )
/www/wwwroot/xqq8.com/vendor/thinkphp/convention.php ( 11.87 KB )
/www/wwwroot/xqq8.com/app/common.php ( 26.22 KB )
/www/wwwroot/xqq8.com/vendor/thinkphp/helper.php ( 20.40 KB )
/www/wwwroot/xqq8.com/vendor/thinkcmf/cmf-app/src/app.php ( 5.33 KB )
/www/wwwroot/xqq8.com/vendor/thinkcmf/cmf-app/src/database.php ( 0.90 KB )
/www/wwwroot/xqq8.com/vendor/thinkcmf/cmf-app/src/template.php ( 2.02 KB )
/www/wwwroot/xqq8.com/vendor/thinkcmf/cmf-app/src/paginate.php ( 0.17 KB )
/www/wwwroot/xqq8.com/vendor/thinkcmf/cmf-app/src/tags.php ( 1.35 KB )
/www/wwwroot/xqq8.com/vendor/thinkphp/library/think/Hook.php ( 5.58 KB )
/www/wwwroot/xqq8.com/app/template.php ( 0.12 KB )
/www/wwwroot/xqq8.com/data/config/database.php ( 0.50 KB )
/www/wwwroot/xqq8.com/data/config/template.php ( 0.11 KB )
/www/wwwroot/xqq8.com/vendor/ezyang/htmlpurifier/library/HTMLPurifier.composer.php ( 0.10 KB )
/www/wwwroot/xqq8.com/vendor/topthink/think-captcha/src/helper.php ( 1.54 KB )
/www/wwwroot/xqq8.com/vendor/thinkphp/library/think/facade/Route.php ( 3.83 KB )
/www/wwwroot/xqq8.com/vendor/thinkphp/library/think/Facade.php ( 3.44 KB )
/www/wwwroot/xqq8.com/vendor/thinkphp/library/think/Route.php ( 25.79 KB )
/www/wwwroot/xqq8.com/vendor/thinkphp/library/think/Request.php ( 57.50 KB )
/www/wwwroot/xqq8.com/vendor/thinkphp/library/think/route/Domain.php ( 7.07 KB )
/www/wwwroot/xqq8.com/vendor/thinkphp/library/think/route/RuleGroup.php ( 16.45 KB )
/www/wwwroot/xqq8.com/vendor/thinkphp/library/think/route/Rule.php ( 28.92 KB )
/www/wwwroot/xqq8.com/vendor/thinkphp/library/think/route/RuleItem.php ( 8.84 KB )
/www/wwwroot/xqq8.com/vendor/thinkphp/library/think/route/RuleName.php ( 3.92 KB )
/www/wwwroot/xqq8.com/vendor/thinkphp/library/think/facade/Validate.php ( 4.83 KB )
/www/wwwroot/xqq8.com/vendor/thinkphp/library/think/Validate.php ( 43.85 KB )
/www/wwwroot/xqq8.com/vendor/thinkcmf/cmf/src/common.php ( 61.50 KB )
/www/wwwroot/xqq8.com/vendor/topthink/think-helper/src/helper.php ( 2.88 KB )
/www/wwwroot/xqq8.com/vendor/topthink/think-worker/src/command.php ( 0.81 KB )
/www/wwwroot/xqq8.com/vendor/thinkphp/library/think/Console.php ( 23.46 KB )
/www/wwwroot/xqq8.com/vendor/thinkphp/library/think/Db.php ( 7.67 KB )
/www/wwwroot/xqq8.com/vendor/thinkphp/library/think/Lang.php ( 7.38 KB )
/www/wwwroot/xqq8.com/vendor/thinkcmf/cmf/src/Log.php ( 8.96 KB )
/www/wwwroot/xqq8.com/vendor/thinkphp/library/think/log/driver/File.php ( 8.97 KB )
/www/wwwroot/xqq8.com/vendor/thinkphp/lang/zh-cn.php ( 12.58 KB )
/www/wwwroot/xqq8.com/data/route/route.php ( 4.66 KB )
/www/wwwroot/xqq8.com/vendor/thinkcmf/cmf/src/behavior/InitHookBehavior.php ( 2.07 KB )
/www/wwwroot/xqq8.com/vendor/thinkphp/library/think/facade/Cache.php ( 2.06 KB )
/www/wwwroot/xqq8.com/vendor/thinkphp/library/think/Cache.php ( 3.27 KB )
/www/wwwroot/xqq8.com/vendor/thinkphp/library/think/cache/driver/File.php ( 7.99 KB )
/www/wwwroot/xqq8.com/vendor/thinkphp/library/think/cache/Driver.php ( 8.64 KB )
/www/wwwroot/xqq8.com/vendor/thinkphp/library/think/db/Connection.php ( 58.93 KB )
/www/wwwroot/xqq8.com/vendor/thinkphp/library/think/db/connector/Mysql.php ( 6.24 KB )
/www/wwwroot/xqq8.com/vendor/thinkphp/library/think/db/builder/Mysql.php ( 5.54 KB )
/www/wwwroot/xqq8.com/vendor/thinkphp/library/think/db/Builder.php ( 36.78 KB )
/www/wwwroot/xqq8.com/vendor/thinkphp/library/think/db/Query.php ( 105.00 KB )
/www/wwwroot/xqq8.com/vendor/thinkphp/library/think/Debug.php ( 7.57 KB )
/www/wwwroot/xqq8.com/vendor/thinkphp/library/think/Collection.php ( 13.59 KB )
/www/wwwroot/xqq8.com/vendor/thinkcmf/cmf/src/route/dispatch/Module.php ( 5.15 KB )
/www/wwwroot/xqq8.com/vendor/thinkphp/library/think/route/Dispatch.php ( 9.26 KB )
/www/wwwroot/xqq8.com/vendor/thinkphp/library/think/Middleware.php ( 5.34 KB )
/www/wwwroot/xqq8.com/vendor/thinkphp/library/think/Cookie.php ( 7.35 KB )
/www/wwwroot/xqq8.com/vendor/thinkphp/library/think/View.php ( 5.74 KB )
/www/wwwroot/xqq8.com/vendor/thinkphp/library/think/view/driver/Think.php ( 6.12 KB )
/www/wwwroot/xqq8.com/vendor/thinkphp/library/think/Template.php ( 47.31 KB )
/www/wwwroot/xqq8.com/vendor/thinkphp/library/think/template/driver/File.php ( 2.29 KB )
/www/wwwroot/xqq8.com/vendor/thinkphp/library/think/Session.php ( 14.13 KB )
/www/wwwroot/xqq8.com/app/portal/lang/zh-cn.php ( 0.93 KB )
/www/wwwroot/xqq8.com/vendor/thinkcmf/cmf/src/behavior/LangBehavior.php ( 2.46 KB )
/www/wwwroot/xqq8.com/vendor/thinkphp/library/think/facade/Lang.php ( 1.75 KB )
/www/wwwroot/xqq8.com/vendor/thinkcmf/cmf/src/lang/zh-cn.php ( 3.14 KB )
/www/wwwroot/xqq8.com/vendor/thinkphp/library/think/facade/Env.php ( 1.17 KB )
/www/wwwroot/xqq8.com/vendor/thinkcmf/cmf-app/src/admin/lang/zh-cn.php ( 9.31 KB )
/www/wwwroot/xqq8.com/vendor/thinkcmf/cmf-app/src/admin/lang/zh-cn/common.php ( 0.60 KB )
/www/wwwroot/xqq8.com/vendor/thinkcmf/cmf-app/src/user/lang/zh-cn.php ( 4.13 KB )
/www/wwwroot/xqq8.com/app/portal/lang/zh-cn/common.php ( 0.76 KB )
/www/wwwroot/xqq8.com/vendor/thinkcmf/cmf/src/behavior/InitAppHookBehavior.php ( 2.01 KB )
/www/wwwroot/xqq8.com/app/portal/controller/ListController.php ( 2.39 KB )
/www/wwwroot/xqq8.com/vendor/thinkcmf/cmf/src/controller/HomeBaseController.php ( 8.39 KB )
/www/wwwroot/xqq8.com/vendor/thinkcmf/cmf/src/controller/BaseController.php ( 2.24 KB )
/www/wwwroot/xqq8.com/vendor/thinkphp/library/think/Controller.php ( 7.53 KB )
/www/wwwroot/xqq8.com/vendor/thinkphp/library/traits/controller/Jump.php ( 4.76 KB )
/www/wwwroot/xqq8.com/vendor/thinkphp/library/think/facade/Config.php ( 1.52 KB )
/www/wwwroot/xqq8.com/vendor/thinkphp/library/think/facade/Hook.php ( 1.46 KB )
/www/wwwroot/xqq8.com/vendor/thinkphp/library/think/facade/Cookie.php ( 1.58 KB )
/www/wwwroot/xqq8.com/vendor/thinkphp/library/think/facade/View.php ( 1.76 KB )
/www/wwwroot/xqq8.com/vendor/thinkcmf/cmf/src/behavior/HomeLangBehavior.php ( 1.52 KB )
/www/wwwroot/xqq8.com/app/portal/lang/zh-cn/home.php ( 0.62 KB )
/www/wwwroot/xqq8.com/app/portal/model/PortalCategoryModel.php ( 8.65 KB )
/www/wwwroot/xqq8.com/vendor/thinkphp/library/think/Model.php ( 27.48 KB )
/www/wwwroot/xqq8.com/vendor/thinkphp/library/think/model/concern/Attribute.php ( 17.64 KB )
/www/wwwroot/xqq8.com/vendor/thinkphp/library/think/model/concern/RelationShip.php ( 19.85 KB )
/www/wwwroot/xqq8.com/vendor/thinkphp/library/think/model/concern/ModelEvent.php ( 6.04 KB )
/www/wwwroot/xqq8.com/vendor/thinkphp/library/think/model/concern/TimeStamp.php ( 2.58 KB )
/www/wwwroot/xqq8.com/vendor/thinkphp/library/think/model/concern/Conversion.php ( 7.83 KB )
/www/wwwroot/xqq8.com/vendor/thinkcmf/cmf-app/src/admin/model/ThemeModel.php ( 8.12 KB )
/www/wwwroot/xqq8.com/data/runtime/temp/dedbc92a02d73edb5da9e89349995459.php ( 31.93 KB )
/www/wwwroot/xqq8.com/vendor/thinkphp/library/think/facade/Session.php ( 2.05 KB )
/www/wwwroot/xqq8.com/vendor/thinkcmf/cmf-app/src/admin/model/NavMenuModel.php ( 6.76 KB )
/www/wwwroot/xqq8.com/vendor/thinkphp/library/think/model/Collection.php ( 2.80 KB )
/www/wwwroot/xqq8.com/vendor/thinkcmf/cmf-extend/src/tree/Tree.php ( 14.39 KB )
/www/wwwroot/xqq8.com/vendor/thinkcmf/cmf-app/src/admin/model/RouteModel.php ( 7.06 KB )
/www/wwwroot/xqq8.com/app/portal/url.php ( 1.55 KB )
/www/wwwroot/xqq8.com/vendor/thinkcmf/cmf-app/src/user/url.php ( 0.98 KB )
/www/wwwroot/xqq8.com/vendor/thinkphp/library/think/facade/Url.php ( 1.13 KB )
/www/wwwroot/xqq8.com/vendor/thinkphp/library/think/Url.php ( 13.22 KB )
/www/wwwroot/xqq8.com/vendor/thinkcmf/cmf-app/src/admin/service/ApiService.php ( 1.33 KB )
/www/wwwroot/xqq8.com/vendor/thinkcmf/cmf/src/lib/Storage.php ( 3.89 KB )
/www/wwwroot/xqq8.com/public/plugins/qiniu/lib/Qiniu.php ( 4.20 KB )
/www/wwwroot/xqq8.com/public/plugins/qiniu/QiniuPlugin.php ( 2.53 KB )
/www/wwwroot/xqq8.com/vendor/thinkcmf/cmf/src/lib/Plugin.php ( 8.03 KB )
/www/wwwroot/xqq8.com/public/plugins/qiniu/vendor/autoload.php ( 0.17 KB )
/www/wwwroot/xqq8.com/public/plugins/qiniu/vendor/composer/autoload_real.php ( 2.36 KB )
/www/wwwroot/xqq8.com/public/plugins/qiniu/vendor/composer/ClassLoader.php ( 13.14 KB )
/www/wwwroot/xqq8.com/public/plugins/qiniu/vendor/composer/autoload_static.php ( 0.95 KB )
/www/wwwroot/xqq8.com/public/plugins/qiniu/vendor/qiniu/php-sdk/src/Qiniu/functions.php ( 7.67 KB )
/www/wwwroot/xqq8.com/public/plugins/qiniu/vendor/qiniu/php-sdk/src/Qiniu/Config.php ( 3.37 KB )
/www/wwwroot/xqq8.com/app/portal/service/ApiService.php ( 16.91 KB )
/www/wwwroot/xqq8.com/app/portal/model/PortalPostModel.php ( 12.85 KB )
/www/wwwroot/xqq8.com/vendor/thinkphp/library/think/db/Expression.php ( 1.11 KB )
/www/wwwroot/xqq8.com/vendor/thinkcmf/cmf/src/paginator/Bootstrap.php ( 7.37 KB )
/www/wwwroot/xqq8.com/vendor/thinkphp/library/think/Paginator.php ( 9.83 KB )
/www/wwwroot/xqq8.com/vendor/thinkphp/library/think/Response.php ( 9.68 KB )
/www/wwwroot/xqq8.com/vendor/thinkphp/library/think/debug/Html.php ( 4.02 KB )

[ DB ] CONNECT:[ UseTime:0.000406s ] mysql:host=127.0.0.1;port=3306;dbname=xqq8;charset=utf8mb4
[ SQL ] SHOW COLUMNS FROM `cmf_hook` [ RunTime:0.000784s ]
[ SQL ] SELECT `hook` FROM `cmf_hook` WHERE `type` = 1 OR ( `type` = 3 AND ( `app` = '' or `app` = 'cmf' ) ) [ RunTime:0.000371s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_hook', 'partitions' => NULL, 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 73, 'filtered' => 11.710000038146973, 'extra' => 'Using where', ) ]
[ SQL ] SHOW COLUMNS FROM `cmf_hook_plugin` [ RunTime:0.000476s ]
[ SQL ] SELECT `hook`,`plugin` FROM `cmf_hook_plugin` WHERE `status` = 1 AND `hook` IN ('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.000388s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_hook_plugin', 'partitions' => NULL, 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 3, 'filtered' => 33.333335876464844, 'extra' => 'Using where; Using filesort', ) ]
[ SQL ] SHOW COLUMNS FROM `cmf_portal_category` [ RunTime:0.000734s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `id` = 3 AND `status` = 1 LIMIT 1 [ RunTime:0.000355s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_portal_category', 'partitions' => NULL, 'type' => 'const', 'possible_keys' => 'PRIMARY', 'key' => 'PRIMARY', 'key_len' => '8', 'ref' => 'const', 'rows' => 1, 'filtered' => 100, 'extra' => NULL, ) ]
[ SQL ] SHOW COLUMNS FROM `cmf_theme_file` [ RunTime:0.000542s ]
[ SQL ] SELECT * FROM `cmf_theme_file` WHERE `theme` = 'sucainiao' AND `file` = 'portal/article' LIMIT 1 [ RunTime:0.000287s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_theme_file', 'partitions' => NULL, 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 13, 'filtered' => 7.6923074722290039, 'extra' => 'Using where', ) ]
[ SQL ] UPDATE `cmf_theme_file` SET `theme` = 'sucainiao' , `action` = 'portal/Article/index' , `file` = 'portal/article' , `name` = '素材详情页' , `more` = '{\"vars\":{\"hot_articles_category_id\":{\"title\":\"Hot Articles\\u5206\\u7c7bID\",\"value\":\"1\",\"type\":\"text\",\"tip\":\"\",\"rule\":[]}}}' , `config_more` = '{\"vars\":{\"hot_articles_category_id\":{\"title\":\"Hot Articles\\u5206\\u7c7bID\",\"value\":\"1\",\"type\":\"text\",\"tip\":\"\",\"rule\":[]}}}' , `description` = '素材详情页模板文件' , `is_public` = 0 , `list_order` = 10 WHERE `theme` = 'sucainiao' AND `file` = 'portal/article' [ RunTime:0.009734s ]
[ SQL ] SELECT * FROM `cmf_theme_file` WHERE `theme` = 'sucainiao' AND `file` = 'portal/index' LIMIT 1 [ RunTime:0.000609s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_theme_file', 'partitions' => NULL, 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 13, 'filtered' => 7.6923074722290039, 'extra' => 'Using where', ) ]
[ SQL ] UPDATE `cmf_theme_file` SET `theme` = 'sucainiao' , `action` = 'portal/Index/index' , `file` = 'portal/index' , `name` = '首页' , `more` = '{\"vars\":{\"top_slide\":{\"title\":\"\\u9876\\u90e8\\u5e7b\\u706f\\u7247\",\"value\":\"\",\"type\":\"text\",\"dataSource\":{\"api\":\"admin\\/Slide\\/index\",\"multi\":false},\"placeholder\":\"\\u8bf7\\u9009\\u62e9\\u9876\\u90e8\\u5e7b\\u706f\\u7247\",\"tip\":\"\\u9876\\u90e8\\u5e7b\\u706f\\u7247\",\"rule\":{\"require\":true}}},\"widgets\":{\"recommend_banner_four\":{\"title\":\"\\u63a8\\u83504\\u4e2a\\u6d3b\\u52a8\",\"display\":1,\"vars\":{\"features\":{\"title\":\"\\u63a8\\u8350Banner\",\"value\":[{\"title\":\"\\u6d77\\u91cf\\u7d20\\u6750\\u6781\\u901f\\u4e0b\\u8f7d\",\"img\":\"Fu840dv-ggihvvvRWgoR8cL_wKY-.png\",\"gif\":\"FpuOTuaMQBuCM37xqtqL_LJ2oZtn.gif\",\"url\":\"https:\\/\\/www.xqq8.com\\/\",\"content\":\"\\u6d77\\u91cf\\u7d20\\u6750\\u6781\\u901f\\u4e0b\\u8f7d\"},{\"title\":\"\\u4e0a\\u4f20\\u7d20\\u6750\\u8d5a\\u53d6\\u79ef\\u5206\\uff0c\\u6d77\\u91cf\\u79ef\\u5206\\u793c\\u54c1\\u8f7b\\u677e\\u5151\\u6362\",\"img\":\"admin\\/20200923\\/989b489aeb2e50f1a145fe357d656236.png\",\"gif\":\"admin\\/20200923\\/b0e077b5a8fa7c47a16d4dd4282308a3.gif\",\"url\":\"https:\\/\\/www.sucainiao.com\\/upload.html\",\"content\":\"\\u4e0a\\u4f20\\u7d20\\u6750\\u8d5a\\u53d6\\u79ef\\u5206\\uff0c\\u6d77\\u91cf\\u79ef\\u5206\\u793c\\u54c1\\u8f7b\\u677e\\u5151\\u6362\"},{\"title\":\"\\u70ed\\u95e8\\u5f00\\u53d1\\u89c6\\u9891\\u6559\\u7a0b\\uff0c\\u8f7b\\u677e\\u5b66\\u4e60\\u7f51\\u7ad9\\u5f00\\u53d1\",\"img\":\"admin\\/20200923\\/14d96b4f051555949d4ab0c075c39388.png\",\"gif\":\"admin\\/20200923\\/c38079e4d5cd16007f70e956e4967163.gif\",\"url\":\"https:\\/\\/www.sucainiao.com\\/\",\"content\":\"\\u70ed\\u95e8\\u5f00\\u53d1\\u89c6\\u9891\\u6559\\u7a0b\\uff0c\\u8f7b\\u677e\\u5b66\\u4e60\\u7f51\\u7ad9\\u5f00\\u53d1\"},{\"title\":\"\\u5728\\u7ebf\\u5f00\\u53d1\\u8005\\u5de5\\u5177\\u7bb1\\uff0c\\u96c6\\u5408\\u5404\\u7c7b\\u65e5\\u5e38\\u5f00\\u53d1\\u5e38\\u7528\\u5de5\\u5177\",\"img\":\"admin\\/20200923\\/1ffbe6ed61f78ac7460b3b13ffe4793d.png\",\"gif\":\"admin\\/20200923\\/f86b9de78f27c65fd0cb6eebb4620fe2.gif\",\"url\":\"https:\\/\\/www.sucainiao.com\\/tool.html\",\"content\":\"\\u5728\\u7ebf\\u5f00\\u53d1\\u8005\\u5de5\\u5177\\u7bb1\\uff0c\\u96c6\\u5408\\u5404\\u7c7b\\u65e5\\u5e38\\u5f00\\u53d1\\u5e38\\u7528\\u5de5\\u5177\"}],\"type\":\"array\",\"item\":{\"title\":{\"title\":\"\\u6807\\u9898\",\"value\":\"\",\"type\":\"text\",\"rule\":[]},\"img\":{\"title\":\"\\u9759\\u6001\\u56fe\",\"value\":\"\",\"type\":\"image\",\"rule\":[]},\"gif\":{\"title\":\"\\u52a8\\u6001\\u56fe\",\"value\":\"\",\"type\":\"image\",\"rule\":[]},\"url\":{\"title\":\"\\u8df3\\u8f6c\\u94fe\\u63a5\",\"value\":\"\",\"type\":\"text\",\"rule\":[]},\"content\":{\"title\":\"\\u63cf\\u8ff0\",\"value\":\"\",\"type\":\"textarea\"}},\"tip\":\"\"}}},\"floor_1\":{\"title\":\"\\u7f51\\u9875\\u7279\\u6548\",\"display\":1,\"vars\":{\"floor_1_category_id\":{\"title\":\"\\u7d20\\u6750\\u5206\\u7c7bID\",\"value\":\"2\",\"type\":\"text\",\"dataSource\":{\"api\":\"portal\\/Category\\/index\",\"multi\":true},\"placeholder\":\"\\u8bf7\\u9009\\u62e9\\u5206\\u7c7b\",\"tip\":\"\",\"valueText\":\"\\u56fe\\u7247\\u4ee3\\u7801\"}}},\"floor_2\":{\"title\":\"\\u540e\\u53f0\\u5f00\\u53d1\",\"display\":0,\"vars\":{\"floor_2_category_id\":{\"title\":\"\\u7d20\\u6750\\u5206\\u7c7bID\",\"value\":\"3\",\"type\":\"text\",\"dataSource\":{\"api\":\"portal\\/Category\\/index\",\"multi\":true},\"placeholder\":\"\\u8bf7\\u9009\\u62e9\\u5206\\u7c7b\",\"tip\":\"\",\"valueText\":\"\\u540e\\u53f0\\u5f00\\u53d1\"}}},\"floor_3\":{\"title\":\"\\u79fb\\u52a8\\u5f00\\u53d1\",\"display\":0,\"vars\":{\"floor_3_category_id\":{\"title\":\"\\u7d20\\u6750\\u5206\\u7c7bID\",\"value\":\"5\",\"type\":\"text\",\"dataSource\":{\"api\":\"portal\\/Category\\/index\",\"multi\":true},\"placeholder\":\"\\u8bf7\\u9009\\u62e9\\u5206\\u7c7b\",\"tip\":\"\",\"valueText\":\"\\u79fb\\u52a8\\u5f00\\u53d1\"}}},\"floor_4\":{\"title\":\"\\u7f51\\u7ad9\\u6a21\\u677f\",\"display\":0,\"vars\":{\"floor_4_category_id\":{\"title\":\"\\u7d20\\u6750\\u5206\\u7c7bID\",\"value\":\"23\",\"type\":\"text\",\"dataSource\":{\"api\":\"portal\\/Category\\/index\",\"multi\":true},\"placeholder\":\"\\u8bf7\\u9009\\u62e9\\u5206\\u7c7b\",\"tip\":\"\",\"valueText\":\"\\u540e\\u53f0\"}}},\"floor_5\":{\"title\":\"\\u6574\\u7ad9\\u6e90\\u7801\",\"display\":0,\"vars\":{\"floor_5_category_id\":{\"title\":\"\\u7d20\\u6750\\u5206\\u7c7bID\",\"value\":\"6\",\"type\":\"text\",\"dataSource\":{\"api\":\"portal\\/Category\\/index\",\"multi\":true},\"placeholder\":\"\\u8bf7\\u9009\\u62e9\\u5206\\u7c7b\",\"tip\":\"\",\"valueText\":\"\\u6574\\u7ad9\\u6e90\\u7801\"}}},\"floor_6\":{\"title\":\"\\u535a\\u5ba2\",\"display\":1,\"vars\":{\"floor_6_category_id\":{\"title\":\"\\u7d20\\u6750\\u5206\\u7c7bID\",\"value\":\"3\",\"type\":\"text\",\"dataSource\":{\"api\":\"portal\\/Category\\/index\",\"multi\":true},\"placeholder\":\"\\u8bf7\\u9009\\u62e9\\u5206\\u7c7b\",\"tip\":\"\",\"valueText\":\"\\u535a\\u5ba2\"}}}}}' , `config_more` = '{\"vars\":{\"top_slide\":{\"title\":\"\\u9876\\u90e8\\u5e7b\\u706f\\u7247\",\"value\":\"\",\"type\":\"text\",\"dataSource\":{\"api\":\"admin\\/Slide\\/index\",\"multi\":false},\"placeholder\":\"\\u8bf7\\u9009\\u62e9\\u9876\\u90e8\\u5e7b\\u706f\\u7247\",\"tip\":\"\\u9876\\u90e8\\u5e7b\\u706f\\u7247\",\"rule\":{\"require\":true}}},\"widgets\":{\"recommend_banner_four\":{\"title\":\"\\u63a8\\u83504\\u4e2a\\u6d3b\\u52a8\",\"display\":\"1\",\"vars\":{\"features\":{\"title\":\"\\u63a8\\u8350Banner\",\"value\":[{\"title\":\"\\u7d20\\u6750\\u4e30\\u5bcc\",\"img\":\"\",\"gif\":\"\",\"url\":\"https:\\/\\/www.sucainiao.com\",\"content\":\"\\u4e30\\u5bcc\\u7684\\u7f51\\u7ad9\\u5f00\\u53d1\\u7d20\\u6750\\u8d44\\u6e90\"},{\"title\":\"\\u6781\\u901f\\u4e0b\\u8f7d\",\"img\":\"\",\"gif\":\"\",\"url\":\"https:\\/\\/www.sucainiao.com\",\"content\":\"\\u591a\\u9009CDN\\u5206\\u5e03\\u5f0f\\u4e0b\\u8f7d\\uff0c\\u6781\\u901f\\u4f53\\u9a8c\"},{\"title\":\"\\u4f1a\\u5458\\u514d\\u8d39\\u4e0b\\u8f7d\",\"img\":\"\",\"gif\":\"\",\"url\":\"https:\\/\\/www.sucainiao.com\",\"content\":\"\\u4f1a\\u5458\\u4eab\\u672c\\u7ad9\\u7d20\\u6750\\u5168\\u90e8\\u514d\\u8d39\\u4e0b\\u8f7d\"},{\"title\":\"\\u4e0a\\u4f20\\u8d44\\u6e90\\u5f97N\\u5e01\",\"img\":\"\",\"gif\":\"\",\"url\":\"https:\\/\\/www.sucainiao.com\",\"content\":\"\\u4e0a\\u4f20\\u8d44\\u6e90\\u5f97\\u79ef\\u5206\\uff0c\\u5151N\\u5e01\"}],\"type\":\"array\",\"item\":{\"title\":{\"title\":\"\\u6807\\u9898\",\"value\":\"\",\"type\":\"text\",\"rule\":[]},\"img\":{\"title\":\"\\u9759\\u6001\\u56fe\",\"value\":\"\",\"type\":\"image\",\"rule\":[]},\"gif\":{\"title\":\"\\u52a8\\u6001\\u56fe\",\"value\":\"\",\"type\":\"image\",\"rule\":[]},\"url\":{\"title\":\"\\u8df3\\u8f6c\\u94fe\\u63a5\",\"value\":\"\",\"type\":\"text\",\"rule\":[]},\"content\":{\"title\":\"\\u63cf\\u8ff0\",\"value\":\"\",\"type\":\"textarea\"}},\"tip\":\"\"}}},\"floor_1\":{\"title\":\"\\u7f51\\u9875\\u7279\\u6548\",\"display\":\"1\",\"vars\":{\"floor_1_category_id\":{\"title\":\"\\u7d20\\u6750\\u5206\\u7c7bID\",\"value\":\"\",\"type\":\"text\",\"dataSource\":{\"api\":\"portal\\/Category\\/index\",\"multi\":true},\"placeholder\":\"\\u8bf7\\u9009\\u62e9\\u5206\\u7c7b\",\"tip\":\"\"}}},\"floor_2\":{\"title\":\"\\u540e\\u53f0\\u5f00\\u53d1\",\"display\":\"1\",\"vars\":{\"floor_2_category_id\":{\"title\":\"\\u7d20\\u6750\\u5206\\u7c7bID\",\"value\":\"\",\"type\":\"text\",\"dataSource\":{\"api\":\"portal\\/Category\\/index\",\"multi\":true},\"placeholder\":\"\\u8bf7\\u9009\\u62e9\\u5206\\u7c7b\",\"tip\":\"\"}}},\"floor_3\":{\"title\":\"\\u79fb\\u52a8\\u5f00\\u53d1\",\"display\":\"1\",\"vars\":{\"floor_3_category_id\":{\"title\":\"\\u7d20\\u6750\\u5206\\u7c7bID\",\"value\":\"\",\"type\":\"text\",\"dataSource\":{\"api\":\"portal\\/Category\\/index\",\"multi\":true},\"placeholder\":\"\\u8bf7\\u9009\\u62e9\\u5206\\u7c7b\",\"tip\":\"\"}}},\"floor_4\":{\"title\":\"\\u7f51\\u7ad9\\u6a21\\u677f\",\"display\":\"1\",\"vars\":{\"floor_4_category_id\":{\"title\":\"\\u7d20\\u6750\\u5206\\u7c7bID\",\"value\":\"\",\"type\":\"text\",\"dataSource\":{\"api\":\"portal\\/Category\\/index\",\"multi\":true},\"placeholder\":\"\\u8bf7\\u9009\\u62e9\\u5206\\u7c7b\",\"tip\":\"\"}}},\"floor_5\":{\"title\":\"\\u6574\\u7ad9\\u6e90\\u7801\",\"display\":\"1\",\"vars\":{\"floor_5_category_id\":{\"title\":\"\\u7d20\\u6750\\u5206\\u7c7bID\",\"value\":\"\",\"type\":\"text\",\"dataSource\":{\"api\":\"portal\\/Category\\/index\",\"multi\":true},\"placeholder\":\"\\u8bf7\\u9009\\u62e9\\u5206\\u7c7b\",\"tip\":\"\"}}},\"floor_6\":{\"title\":\"\\u89c6\\u9891\\u6559\\u7a0b\",\"display\":\"1\",\"vars\":{\"floor_6_category_id\":{\"title\":\"\\u7d20\\u6750\\u5206\\u7c7bID\",\"value\":\"\",\"type\":\"text\",\"dataSource\":{\"api\":\"portal\\/Category\\/index\",\"multi\":true},\"placeholder\":\"\\u8bf7\\u9009\\u62e9\\u5206\\u7c7b\",\"tip\":\"\"}}}}}' , `description` = '首页模板文件' , `is_public` = 0 , `list_order` = 5 WHERE `theme` = 'sucainiao' AND `file` = 'portal/index' [ RunTime:0.012784s ]
[ SQL ] SELECT * FROM `cmf_theme_file` WHERE `theme` = 'sucainiao' AND `file` = 'portal/list' LIMIT 1 [ RunTime:0.000513s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_theme_file', 'partitions' => NULL, 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 13, 'filtered' => 7.6923074722290039, 'extra' => 'Using where', ) ]
[ SQL ] UPDATE `cmf_theme_file` SET `theme` = 'sucainiao' , `action` = 'portal/List/index' , `file` = 'portal/list' , `name` = '素材列表页' , `more` = '{\"vars\":[],\"widgets\":{\"hottest_articles\":{\"title\":\"\\u70ed\\u95e8\\u6587\\u7ae0\",\"display\":\"1\",\"vars\":{\"hottest_articles_category_id\":{\"title\":\"\\u6587\\u7ae0\\u5206\\u7c7bID\",\"value\":\"\",\"type\":\"text\",\"dataSource\":{\"api\":\"portal\\/category\\/index\",\"multi\":true},\"placeholder\":\"\\u8bf7\\u9009\\u62e9\\u5206\\u7c7b\",\"tip\":\"\",\"rule\":{\"require\":true}}}},\"last_articles\":{\"title\":\"\\u6700\\u65b0\\u53d1\\u5e03\",\"display\":\"1\",\"vars\":{\"last_articles_category_id\":{\"title\":\"\\u6587\\u7ae0\\u5206\\u7c7bID\",\"value\":\"\",\"type\":\"text\",\"dataSource\":{\"api\":\"portal\\/category\\/index\",\"multi\":true},\"placeholder\":\"\\u8bf7\\u9009\\u62e9\\u5206\\u7c7b\",\"tip\":\"\",\"rule\":{\"require\":true}}}}}}' , `config_more` = '{\"vars\":[],\"widgets\":{\"hottest_articles\":{\"title\":\"\\u70ed\\u95e8\\u6587\\u7ae0\",\"display\":\"1\",\"vars\":{\"hottest_articles_category_id\":{\"title\":\"\\u6587\\u7ae0\\u5206\\u7c7bID\",\"value\":\"\",\"type\":\"text\",\"dataSource\":{\"api\":\"portal\\/category\\/index\",\"multi\":true},\"placeholder\":\"\\u8bf7\\u9009\\u62e9\\u5206\\u7c7b\",\"tip\":\"\",\"rule\":{\"require\":true}}}},\"last_articles\":{\"title\":\"\\u6700\\u65b0\\u53d1\\u5e03\",\"display\":\"1\",\"vars\":{\"last_articles_category_id\":{\"title\":\"\\u6587\\u7ae0\\u5206\\u7c7bID\",\"value\":\"\",\"type\":\"text\",\"dataSource\":{\"api\":\"portal\\/category\\/index\",\"multi\":true},\"placeholder\":\"\\u8bf7\\u9009\\u62e9\\u5206\\u7c7b\",\"tip\":\"\",\"rule\":{\"require\":true}}}}}}' , `description` = '素材列表模板文件' , `is_public` = 0 , `list_order` = 10 WHERE `theme` = 'sucainiao' AND `file` = 'portal/list' [ RunTime:0.013163s ]
[ SQL ] SELECT * FROM `cmf_theme_file` WHERE `theme` = 'sucainiao' AND `file` = 'portal/page' LIMIT 1 [ RunTime:0.000565s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_theme_file', 'partitions' => NULL, 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 13, 'filtered' => 7.6923074722290039, 'extra' => 'Using where', ) ]
[ SQL ] UPDATE `cmf_theme_file` SET `theme` = 'sucainiao' , `action` = 'portal/Page/index' , `file` = 'portal/page' , `name` = '单页面' , `more` = '{\"widgets\":{\"hottest_articles\":{\"title\":\"\\u70ed\\u95e8\\u6587\\u7ae0\",\"display\":\"1\",\"vars\":{\"hottest_articles_category_id\":{\"title\":\"\\u6587\\u7ae0\\u5206\\u7c7bID\",\"value\":\"\",\"type\":\"text\",\"dataSource\":{\"api\":\"portal\\/category\\/index\",\"multi\":true},\"placeholder\":\"\\u8bf7\\u9009\\u62e9\\u5206\\u7c7b\",\"tip\":\"\",\"rule\":{\"require\":true}}}},\"last_articles\":{\"title\":\"\\u6700\\u65b0\\u53d1\\u5e03\",\"display\":\"1\",\"vars\":{\"last_articles_category_id\":{\"title\":\"\\u6587\\u7ae0\\u5206\\u7c7bID\",\"value\":\"\",\"type\":\"text\",\"dataSource\":{\"api\":\"portal\\/category\\/index\",\"multi\":true},\"placeholder\":\"\\u8bf7\\u9009\\u62e9\\u5206\\u7c7b\",\"tip\":\"\",\"rule\":{\"require\":true}}}}}}' , `config_more` = '{\"widgets\":{\"hottest_articles\":{\"title\":\"\\u70ed\\u95e8\\u6587\\u7ae0\",\"display\":\"1\",\"vars\":{\"hottest_articles_category_id\":{\"title\":\"\\u6587\\u7ae0\\u5206\\u7c7bID\",\"value\":\"\",\"type\":\"text\",\"dataSource\":{\"api\":\"portal\\/category\\/index\",\"multi\":true},\"placeholder\":\"\\u8bf7\\u9009\\u62e9\\u5206\\u7c7b\",\"tip\":\"\",\"rule\":{\"require\":true}}}},\"last_articles\":{\"title\":\"\\u6700\\u65b0\\u53d1\\u5e03\",\"display\":\"1\",\"vars\":{\"last_articles_category_id\":{\"title\":\"\\u6587\\u7ae0\\u5206\\u7c7bID\",\"value\":\"\",\"type\":\"text\",\"dataSource\":{\"api\":\"portal\\/category\\/index\",\"multi\":true},\"placeholder\":\"\\u8bf7\\u9009\\u62e9\\u5206\\u7c7b\",\"tip\":\"\",\"rule\":{\"require\":true}}}}}}' , `description` = '单页面模板文件' , `is_public` = 0 , `list_order` = 10 WHERE `theme` = 'sucainiao' AND `file` = 'portal/page' [ RunTime:0.011222s ]
[ SQL ] SELECT * FROM `cmf_theme_file` WHERE `theme` = 'sucainiao' AND `file` = 'portal/search' LIMIT 1 [ RunTime:0.000444s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_theme_file', 'partitions' => NULL, 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 13, 'filtered' => 7.6923074722290039, 'extra' => 'Using where', ) ]
[ SQL ] UPDATE `cmf_theme_file` SET `theme` = 'sucainiao' , `action` = 'portal/search/index' , `file` = 'portal/search' , `name` = '搜索页面' , `more` = '{\"vars\":{\"varName1\":{\"title\":\"\\u70ed\\u95e8\\u641c\\u7d22\",\"value\":\"1\",\"type\":\"text\",\"tip\":\"\\u8fd9\\u662f\\u4e00\\u4e2atext\",\"rule\":{\"require\":true}}}}' , `config_more` = '{\"vars\":{\"varName1\":{\"title\":\"\\u70ed\\u95e8\\u641c\\u7d22\",\"value\":\"1\",\"type\":\"text\",\"tip\":\"\\u8fd9\\u662f\\u4e00\\u4e2atext\",\"rule\":{\"require\":true}}}}' , `description` = '搜索模板文件' , `is_public` = 0 , `list_order` = 10 WHERE `theme` = 'sucainiao' AND `file` = 'portal/search' [ RunTime:0.011295s ]
[ SQL ] SELECT * FROM `cmf_theme_file` WHERE `theme` = 'sucainiao' [ RunTime:0.000381s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_theme_file', 'partitions' => NULL, 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 13, 'filtered' => 10, 'extra' => 'Using where', ) ]
[ SQL ] SHOW COLUMNS FROM `cmf_theme` [ RunTime:0.000709s ]
[ SQL ] UPDATE `cmf_theme` SET `name` = 'sucainiao' , `version` = '2.0.0' , `demo_url` = 'http://www.sucainiao.com' , `author` = '素材鸟' , `lang` = 'zh-cn' , `author_url` = 'http://www.sucainiao.com' , `keywords` = '素材鸟模板' , `description` = '素材鸟模板' WHERE `theme` = 'sucainiao' [ RunTime:0.000380s ]
[ SQL ] SELECT `more` FROM `cmf_theme_file` WHERE `theme` = 'sucainiao' AND ( `is_public` = 1 OR `file` = 'portal/list' ) [ RunTime:0.000360s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_theme_file', 'partitions' => NULL, 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 13, 'filtered' => 7.6923074722290039, 'extra' => 'Using where', ) ]
[ SQL ] SHOW COLUMNS FROM `cmf_nav_menu` [ RunTime:0.000566s ]
[ SQL ] SELECT * FROM `cmf_nav_menu` WHERE `nav_id` = 4 AND `status` = 1 ORDER BY `list_order` ASC [ RunTime:0.000336s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_nav_menu', 'partitions' => NULL, 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 28, 'filtered' => 3.5714282989501953, 'extra' => 'Using where; Using filesort', ) ]
[ SQL ] SELECT * FROM `cmf_nav_menu` WHERE `nav_id` = 3 AND `status` = 1 ORDER BY `list_order` ASC [ RunTime:0.000358s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_nav_menu', 'partitions' => NULL, 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 28, 'filtered' => 3.5714282989501953, 'extra' => 'Using where; Using filesort', ) ]
[ SQL ] SHOW COLUMNS FROM `cmf_hot_keyword` [ RunTime:0.000495s ]
[ SQL ] SELECT `keyword`,`url`,`is_hot` FROM `cmf_hot_keyword` WHERE `status` = 1 ORDER BY `list_order` ASC LIMIT 10 [ RunTime:0.000250s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_hot_keyword', 'partitions' => NULL, 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 10, 'filtered' => 10, 'extra' => 'Using where; Using filesort', ) ]
[ SQL ] SHOW COLUMNS FROM `cmf_slide` [ RunTime:0.000588s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `cmf_slide` WHERE `id` = 2 AND `status` = 1 AND `delete_time` = 0 [ RunTime:0.000269s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_slide', 'partitions' => NULL, 'type' => 'const', 'possible_keys' => 'PRIMARY', 'key' => 'PRIMARY', 'key_len' => '4', 'ref' => 'const', 'rows' => 1, 'filtered' => 100, 'extra' => NULL, ) ]
[ SQL ] SHOW COLUMNS FROM `cmf_slide_item` [ RunTime:0.000590s ]
[ SQL ] SELECT * FROM `cmf_slide_item` WHERE `status` = 1 AND `slide_id` = 2 ORDER BY `list_order` ASC [ RunTime:0.000400s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_slide_item', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'slide_id', 'key' => 'slide_id', 'key_len' => '4', 'ref' => 'const', 'rows' => 2, 'filtered' => 20, 'extra' => 'Using index condition; Using where; Using filesort', ) ]
[ SQL ] SHOW COLUMNS FROM `cmf_plugin` [ RunTime:0.000668s ]
[ SQL ] SELECT `config` FROM `cmf_plugin` WHERE `name` = 'Qiniu' LIMIT 1 [ RunTime:0.000366s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_plugin', 'partitions' => NULL, 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 5, 'filtered' => 20, 'extra' => 'Using where', ) ]
[ SQL ] SELECT * FROM `cmf_nav_menu` WHERE `nav_id` = 1 AND `status` = 1 ORDER BY `list_order` ASC [ RunTime:0.000376s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_nav_menu', 'partitions' => NULL, 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 28, 'filtered' => 3.5714282989501953, 'extra' => 'Using where; Using filesort', ) ]
[ SQL ] SELECT `parent_id` FROM `cmf_portal_category` WHERE `status` = 1 AND `id` = 3 LIMIT 1 [ RunTime:0.000287s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_portal_category', 'partitions' => NULL, 'type' => 'const', 'possible_keys' => 'PRIMARY', 'key' => 'PRIMARY', 'key_len' => '8', 'ref' => 'const', 'rows' => 1, 'filtered' => 100, 'extra' => NULL, ) ]
[ SQL ] SELECT `id`,`name` FROM `cmf_portal_category` WHERE `status` = 1 AND `parent_id` = 3 ORDER BY `list_order` ASC [ RunTime:0.000271s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_portal_category', 'partitions' => NULL, 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 5, 'filtered' => 20, 'extra' => 'Using where; Using filesort', ) ]
[ SQL ] SHOW COLUMNS FROM `cmf_portal_category_post` [ RunTime:0.000541s ]
[ SQL ] SELECT `post_id` FROM `cmf_portal_category_post` WHERE `category_id` = 3 AND `status` = 1 [ RunTime:0.000296s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_portal_category_post', 'partitions' => NULL, 'type' => 'ALL', 'possible_keys' => 'term_taxonomy_id', 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 11, 'filtered' => 9.0909090042114258, 'extra' => 'Using where', ) ]
[ SQL ] SHOW COLUMNS FROM `cmf_portal_tag_post` [ RunTime:0.000547s ]
[ SQL ] SELECT `tag_id` FROM `cmf_portal_tag_post` WHERE `status` = 1 AND `post_id` IN (29,30,31,32,36,37,38) [ RunTime:0.000338s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_portal_tag_post', 'partitions' => NULL, 'type' => 'ALL', 'possible_keys' => 'post_id', 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 30, 'filtered' => 6, 'extra' => 'Using where', ) ]
[ SQL ] SHOW COLUMNS FROM `cmf_portal_tag` [ RunTime:0.000527s ]
[ SQL ] SELECT `id`,`name` FROM `cmf_portal_tag` WHERE `status` = 1 AND `id` IN (3,4,5,6,7,8,9,10,11,18,19,20,21,22,23) LIMIT 40 [ RunTime:0.000360s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_portal_tag', 'partitions' => NULL, 'type' => 'ALL', 'possible_keys' => 'PRIMARY', 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 23, 'filtered' => 6.5217399597167969, 'extra' => 'Using where', ) ]
[ SQL ] SHOW COLUMNS FROM `cmf_ad` [ RunTime:0.000660s ]
[ SQL ] SELECT `id`,`weight` FROM `cmf_ad` WHERE `status` = 1 AND `end_time` > 1745610717 AND `position` = 2 [ RunTime:0.000334s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_ad', 'partitions' => NULL, 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 6, 'filtered' => 16.666667938232422, 'extra' => 'Using where', ) ]
[ SQL ] SELECT COUNT(`id`) AS tp_count FROM `cmf_portal_category_post` WHERE `status` = 1 AND `category_id` = 3 [ RunTime:0.000324s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_portal_category_post', 'partitions' => NULL, 'type' => 'ALL', 'possible_keys' => 'term_taxonomy_id', 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 11, 'filtered' => 9.0909090042114258, 'extra' => 'Using where', ) ]
[ SQL ] SELECT `path` FROM `cmf_portal_category` WHERE `id` = 3 LIMIT 1 [ RunTime:0.000270s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_portal_category', 'partitions' => NULL, 'type' => 'const', 'possible_keys' => 'PRIMARY', 'key' => 'PRIMARY', 'key_len' => '8', 'ref' => 'const', 'rows' => 1, 'filtered' => 100, 'extra' => NULL, ) ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `path` LIKE '0-3-%' [ RunTime:0.000344s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_portal_category', 'partitions' => NULL, 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 5, 'filtered' => 20, 'extra' => 'Using where', ) ]
[ SQL ] SHOW COLUMNS FROM `cmf_portal_post` [ RunTime:0.000777s ]
[ SQL ] SELECT COUNT(*) AS tp_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` = '3' ) AND ( `post`.`published_time` > 0 and `post`.`published_time` < 1745610717 ) GROUP BY `post`.`id` ) `_group_count_` [ RunTime:0.000742s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'PRIMARY', 'table' => '<derived2>', 'partitions' => NULL, 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 2, 'filtered' => 100, 'extra' => NULL, ) ]
[ SQL ] 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` = '3' ) AND ( `post`.`published_time` > 0 and `post`.`published_time` < 1745610717 ) GROUP BY `post`.`id` ORDER BY `post`.`published_time` DESC LIMIT 0,20 [ RunTime:0.001442s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'post', 'partitions' => NULL, 'type' => 'range', 'possible_keys' => 'PRIMARY,type_status_date,parent_id,user_id,create_time', 'key' => 'type_status_date', 'key_len' => '6', 'ref' => NULL, 'rows' => 14, 'filtered' => 4.1666669845581055, 'extra' => 'Using index condition; Using where; Using temporary; Using filesort', ) ]
[ SQL ] SELECT `id` FROM `cmf_portal_tag` WHERE `name` = '点击量' AND `status` = 1 LIMIT 1 [ RunTime:0.000373s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_portal_tag', 'partitions' => NULL, 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 23, 'filtered' => 4.3478260040283203, 'extra' => 'Using where', ) ]
[ SQL ] SELECT `id` FROM `cmf_portal_tag` WHERE `name` = 'thinkcmf' AND `status` = 1 LIMIT 1 [ RunTime:0.000290s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_portal_tag', 'partitions' => NULL, 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 23, 'filtered' => 4.3478260040283203, 'extra' => 'Using where', ) ]
[ SQL ] SELECT `id` FROM `cmf_portal_tag` WHERE `name` = '导航' AND `status` = 1 LIMIT 1 [ RunTime:0.000278s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_portal_tag', 'partitions' => NULL, 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 23, 'filtered' => 4.3478260040283203, 'extra' => 'Using where', ) ]
[ SQL ] SELECT `id` FROM `cmf_portal_tag` WHERE `name` = 'layui' AND `status` = 1 LIMIT 1 [ RunTime:0.000285s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_portal_tag', 'partitions' => NULL, 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 23, 'filtered' => 4.3478260040283203, 'extra' => 'Using where', ) ]
[ SQL ] SELECT `id` FROM `cmf_portal_tag` WHERE `name` = 'thinkcmf' AND `status` = 1 LIMIT 1 [ RunTime:0.000298s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_portal_tag', 'partitions' => NULL, 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 23, 'filtered' => 4.3478260040283203, 'extra' => 'Using where', ) ]
[ SQL ] SELECT `id` FROM `cmf_portal_tag` WHERE `name` = '分页' AND `status` = 1 LIMIT 1 [ RunTime:0.000289s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_portal_tag', 'partitions' => NULL, 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 23, 'filtered' => 4.3478260040283203, 'extra' => 'Using where', ) ]
[ SQL ] SELECT `id` FROM `cmf_portal_tag` WHERE `name` = 'css' AND `status` = 1 LIMIT 1 [ RunTime:0.000368s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_portal_tag', 'partitions' => NULL, 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 23, 'filtered' => 4.3478260040283203, 'extra' => 'Using where', ) ]
[ SQL ] SELECT `id` FROM `cmf_portal_tag` WHERE `name` = 'uni-app' AND `status` = 1 LIMIT 1 [ RunTime:0.000255s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_portal_tag', 'partitions' => NULL, 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 23, 'filtered' => 4.3478260040283203, 'extra' => 'Using where', ) ]
[ SQL ] SELECT `id` FROM `cmf_portal_tag` WHERE `name` = '钉钉' AND `status` = 1 LIMIT 1 [ RunTime:0.000282s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_portal_tag', 'partitions' => NULL, 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 23, 'filtered' => 4.3478260040283203, 'extra' => 'Using where', ) ]
[ SQL ] SELECT `id` FROM `cmf_portal_tag` WHERE `name` = '小程序' AND `status` = 1 LIMIT 1 [ RunTime:0.000335s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_portal_tag', 'partitions' => NULL, 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 23, 'filtered' => 4.3478260040283203, 'extra' => 'Using where', ) ]
[ SQL ] SELECT `id` FROM `cmf_portal_tag` WHERE `name` = 'php' AND `status` = 1 LIMIT 1 [ RunTime:0.000291s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_portal_tag', 'partitions' => NULL, 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 23, 'filtered' => 4.3478260040283203, 'extra' => 'Using where', ) ]
[ SQL ] SELECT `id` FROM `cmf_portal_tag` WHERE `name` = '消息推送' AND `status` = 1 LIMIT 1 [ RunTime:0.000263s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_portal_tag', 'partitions' => NULL, 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 23, 'filtered' => 4.3478260040283203, 'extra' => 'Using where', ) ]
[ SQL ] SELECT `id` FROM `cmf_portal_tag` WHERE `name` = 'workerman' AND `status` = 1 LIMIT 1 [ RunTime:0.000301s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_portal_tag', 'partitions' => NULL, 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 23, 'filtered' => 4.3478260040283203, 'extra' => 'Using where', ) ]
[ SQL ] SELECT `id` FROM `cmf_portal_tag` WHERE `name` = 'PHP' AND `status` = 1 LIMIT 1 [ RunTime:0.000267s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_portal_tag', 'partitions' => NULL, 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 23, 'filtered' => 4.3478260040283203, 'extra' => 'Using where', ) ]
[ SQL ] SELECT `id` FROM `cmf_portal_tag` WHERE `name` = '面试' AND `status` = 1 LIMIT 1 [ RunTime:0.000248s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_portal_tag', 'partitions' => NULL, 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 23, 'filtered' => 4.3478260040283203, 'extra' => 'Using where', ) ]
[ SQL ] SELECT `id` FROM `cmf_portal_tag` WHERE `name` = 'thinkphp' AND `status` = 1 LIMIT 1 [ RunTime:0.000233s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_portal_tag', 'partitions' => NULL, 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 23, 'filtered' => 4.3478260040283203, 'extra' => 'Using where', ) ]
[ SQL ] SELECT `id` FROM `cmf_portal_tag` WHERE `name` = '汉字转拼音' AND `status` = 1 LIMIT 1 [ RunTime:0.000237s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_portal_tag', 'partitions' => NULL, 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 23, 'filtered' => 4.3478260040283203, 'extra' => 'Using where', ) ]
[ SQL ] SELECT `id` FROM `cmf_portal_tag` WHERE `name` = 'php' AND `status` = 1 LIMIT 1 [ RunTime:0.000276s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_portal_tag', 'partitions' => NULL, 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 23, 'filtered' => 4.3478260040283203, 'extra' => 'Using where', ) ]
[ SQL ] SELECT `id`,`weight` FROM `cmf_ad` WHERE `status` = 1 AND `end_time` > 1745610717 AND `position` = 2 [ RunTime:0.000234s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_ad', 'partitions' => NULL, 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 6, 'filtered' => 16.666667938232422, 'extra' => 'Using where', ) ]
[ SQL ] SELECT * FROM `cmf_nav_menu` WHERE `nav_id` = 3 AND `status` = 1 ORDER BY `list_order` ASC [ RunTime:0.000296s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_nav_menu', 'partitions' => NULL, 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 28, 'filtered' => 3.5714282989501953, 'extra' => 'Using where; Using filesort', ) ]
[ SQL ] SELECT * FROM `cmf_nav_menu` WHERE `nav_id` = 5 AND `status` = 1 ORDER BY `list_order` ASC [ RunTime:0.000286s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'cmf_nav_menu', 'partitions' => NULL, 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 28, 'filtered' => 3.5714282989501953, 'extra' => 'Using where; Using filesort', ) ]

页面访问量转换

基于layui导航组件的thinkcmf5.1框架前端分类导航

thinkcmf模板之分页CSS样式

uni-app开发钉钉小程序

php使用workerman实现web端消息推送的简单例子

PHP常见面试问题汇总，欢迎留言补充

thinkphp汉字转拼音类文件