电子图书馆

欢迎访问数字图书馆! 登录 | 注册

当前位置：首页>电子图书>TS轻工业、手工业、生活服务业

《PostgreSQL查询引擎源码技术探析》 李浩

75 总阅读量 | 0 总收藏量

评分：0 分

图书介绍
读者评价

PostgreSQL作为当今最先进的开源关系型数据库，本书揭示PostgreSQL查询引擎的运行原理和实现技术细节，其中包括：基础数据结构；SQL词法语法分析及查询语法树；查询分析及查询重写；子链接及子查询处理；查询访问路径创建；查询计划生成，等等。以深入浅出的方式讨论每个主题并结合基础数据结构、图表、源码等对所讨论的主题进行详细分析，以使读者对PostgreSQL查询引擎的运行机制及实现细节能有全面且深入的认识。

总体评价

您的评分：分

共有 0 条评论

相关推荐

基本文件流程错误 SQL 调试

D:\tongru\public\index.php ( 1.51 KB )
D:\tongru\simplewind\thinkphp\base.php ( 2.60 KB )
D:\tongru\simplewind\thinkphp\library\think\Loader.php ( 21.07 KB )
D:\tongru\simplewind\vendor\composer\autoload_static.php ( 5.62 KB )
D:\tongru\simplewind\vendor\topthink\think-helper\src\helper.php ( 2.88 KB )
D:\tongru\simplewind\vendor\ezyang\htmlpurifier\library\HTMLPurifier.composer.php ( 0.10 KB )
D:\tongru\simplewind\vendor\topthink\think-captcha\src\helper.php ( 1.94 KB )
D:\tongru\simplewind\thinkphp\library\think\Route.php ( 60.23 KB )
D:\tongru\simplewind\thinkphp\library\think\Config.php ( 6.38 KB )
D:\tongru\simplewind\thinkphp\library\think\Validate.php ( 41.63 KB )
D:\tongru\simplewind\vendor\topthink\think-queue\src\common.php ( 1.19 KB )
D:\tongru\simplewind\thinkphp\library\think\Console.php ( 23.13 KB )
D:\tongru\simplewind\thinkphp\library\think\Error.php ( 3.75 KB )
D:\tongru\simplewind\thinkphp\convention.php ( 10.37 KB )
D:\tongru\simplewind\thinkphp\library\think\App.php ( 21.51 KB )
D:\tongru\simplewind\thinkphp\library\think\Request.php ( 49.78 KB )
D:\tongru\app\config.php ( 9.53 KB )
D:\tongru\data\conf\config.php ( 0.11 KB )
D:\tongru\app\database.php ( 0.74 KB )
D:\tongru\data\conf\database.php ( 0.49 KB )
D:\tongru\app\debug.php ( 0.69 KB )
D:\tongru\simplewind\thinkphp\library\think\Hook.php ( 4.71 KB )
D:\tongru\app\tags.php ( 1.33 KB )
D:\tongru\simplewind\thinkphp\library\think\Env.php ( 1.21 KB )
D:\tongru\simplewind\cmf\common.php ( 62.70 KB )
D:\tongru\simplewind\thinkphp\helper.php ( 17.30 KB )
D:\tongru\simplewind\thinkphp\library\think\Debug.php ( 7.13 KB )
D:\tongru\simplewind\cmf\behavior\InitHookBehavior.php ( 2.58 KB )
D:\tongru\simplewind\extend\think\facade\Route.php ( 0.74 KB )
D:\tongru\simplewind\thinkphp\library\think\Cache.php ( 6.10 KB )
D:\tongru\simplewind\thinkphp\library\think\Log.php ( 6.05 KB )
D:\tongru\simplewind\thinkphp\library\think\cache\driver\File.php ( 7.27 KB )
D:\tongru\simplewind\thinkphp\library\think\cache\Driver.php ( 5.98 KB )
D:\tongru\simplewind\thinkphp\library\think\Collection.php ( 10.91 KB )
D:\tongru\simplewind\extend\think\facade\Hook.php ( 1.46 KB )
D:\tongru\simplewind\thinkphp\library\think\Lang.php ( 7.41 KB )
D:\tongru\simplewind\thinkphp\lang\zh-cn.php ( 11.81 KB )
D:\tongru\app\route.php ( 0.76 KB )
D:\tongru\data\conf\route.php ( 5.98 KB )
D:\tongru\simplewind\cmf\behavior\LangBehavior.php ( 1.20 KB )
D:\tongru\simplewind\extend\think\facade\Lang.php ( 0.73 KB )
D:\tongru\simplewind\cmf\lang\zh-cn.php ( 3.08 KB )
D:\tongru\app\admin\lang\zh-cn\common.php ( 0.60 KB )
D:\tongru\app\api\lang\zh-cn\common.php ( 0.76 KB )
D:\tongru\app\plugcode\lang\zh-cn\common.php ( 0.76 KB )
D:\tongru\app\portal\lang\zh-cn\common.php ( 0.76 KB )
D:\tongru\app\product\lang\zh-cn\common.php ( 0.76 KB )
D:\tongru\app\portal\lang\zh-cn.php ( 0.93 KB )
D:\tongru\simplewind\cmf\behavior\InitAppHookBehavior.php ( 2.03 KB )
D:\tongru\app\portal\controller\ZyarticleController.php ( 8.95 KB )
D:\tongru\simplewind\cmf\controller\HomeBaseController.php ( 8.36 KB )
D:\tongru\simplewind\cmf\controller\BaseController.php ( 2.50 KB )
D:\tongru\simplewind\thinkphp\library\think\Controller.php ( 6.07 KB )
D:\tongru\simplewind\thinkphp\library\traits\controller\Jump.php ( 4.90 KB )
D:\tongru\simplewind\thinkphp\library\think\Cookie.php ( 7.54 KB )
D:\tongru\simplewind\thinkphp\library\think\View.php ( 6.77 KB )
D:\tongru\simplewind\thinkphp\library\think\view\driver\Think.php ( 5.64 KB )
D:\tongru\simplewind\thinkphp\library\think\Template.php ( 44.90 KB )
D:\tongru\simplewind\thinkphp\library\think\template\driver\File.php ( 2.24 KB )
D:\tongru\simplewind\cmf\behavior\HomeLangBehavior.php ( 1.09 KB )
D:\tongru\app\api\lang\zh-cn\home.php ( 0.62 KB )
D:\tongru\app\plugcode\lang\zh-cn\home.php ( 0.62 KB )
D:\tongru\app\portal\lang\zh-cn\home.php ( 0.62 KB )
D:\tongru\app\product\lang\zh-cn\home.php ( 0.62 KB )
D:\tongru\simplewind\thinkphp\library\think\Session.php ( 10.86 KB )
D:\tongru\simplewind\thinkphp\library\think\Db.php ( 6.67 KB )
D:\tongru\simplewind\thinkphp\library\think\db\connector\Mysql.php ( 3.89 KB )
D:\tongru\simplewind\thinkphp\library\think\db\Connection.php ( 29.97 KB )
D:\tongru\simplewind\thinkphp\library\think\db\Query.php ( 93.77 KB )
D:\tongru\simplewind\thinkphp\library\think\db\builder\Mysql.php ( 4.53 KB )
D:\tongru\simplewind\thinkphp\library\think\db\Builder.php ( 31.55 KB )
D:\tongru\app\portal\model\PortalPostModel.php ( 12.23 KB )
D:\tongru\simplewind\thinkphp\library\think\Model.php ( 69.14 KB )
D:\tongru\app\portal\model\PortalCategoryModel.php ( 11.98 KB )
D:\tongru\app\portal\service\PostService.php ( 21.34 KB )
D:\tongru\simplewind\thinkphp\library\think\model\Collection.php ( 2.27 KB )
D:\tongru\app\portal\model\PortalCommentModel.php ( 0.72 KB )
D:\tongru\app\admin\model\ThemeModel.php ( 8.12 KB )
D:\tongru\simplewind\cmf\lib\taglib\Cmf.php ( 11.62 KB )
D:\tongru\simplewind\thinkphp\library\think\template\TagLib.php ( 12.30 KB )
D:\tongru\simplewind\thinkphp\library\think\template\taglib\Cx.php ( 23.82 KB )
D:\tongru\data\runtime\temp\c4693de146225f5c51d932d036e004a6.php ( 22.64 KB )
D:\tongru\app\admin\model\RouteModel.php ( 6.45 KB )
D:\tongru\app\api\url.php ( 1.55 KB )
D:\tongru\app\plugcode\url.php ( 1.55 KB )
D:\tongru\app\portal\url.php ( 1.55 KB )
D:\tongru\app\product\url.php ( 1.55 KB )
D:\tongru\app\user\url.php ( 0.98 KB )
D:\tongru\simplewind\extend\think\facade\Url.php ( 0.73 KB )
D:\tongru\simplewind\thinkphp\library\think\Url.php ( 12.72 KB )
D:\tongru\simplewind\vendor\electrolinux\phpquery\phpQuery\phpQuery.php ( 41.76 KB )
D:\tongru\simplewind\vendor\electrolinux\phpquery\phpQuery\phpQuery\DOMEvent.php ( 2.25 KB )
D:\tongru\simplewind\vendor\electrolinux\phpquery\phpQuery\phpQuery\DOMDocumentWrapper.php ( 22.43 KB )
D:\tongru\simplewind\vendor\electrolinux\phpquery\phpQuery\phpQuery\phpQueryEvents.php ( 4.85 KB )
D:\tongru\simplewind\vendor\electrolinux\phpquery\phpQuery\phpQuery\Callback.php ( 4.02 KB )
D:\tongru\simplewind\vendor\electrolinux\phpquery\phpQuery\phpQuery\phpQueryObject.php ( 87.94 KB )
D:\tongru\simplewind\vendor\electrolinux\phpquery\phpQuery\phpQuery\compat\mbstring.php ( 1.51 KB )
D:\tongru\simplewind\cmf\lib\Storage.php ( 3.89 KB )
D:\tongru\simplewind\cmf\lib\storage\Local.php ( 2.86 KB )
D:\tongru\simplewind\thinkphp\library\think\Response.php ( 8.28 KB )
D:\tongru\simplewind\thinkphp\library\think\debug\Html.php ( 4.17 KB )

[ CACHE ] INIT File
[ BEHAVIOR ] Run cmf\behavior\InitHookBehavior @app_init [ RunTime:0.003993s ]
[ LANG ] D:\tongru\simplewind\thinkphp\lang\zh-cn.php
[ ROUTE ] array ( 'type' => 'module', 'module' => array ( 0 => 'portal', 1 => 'zyarticle', 2 => 'index', ), )
[ HEADER ] array ( 'connection' => 'close', 'cache-control' => 'max-age=259200', 'x-forwarded-for' => '10.1.49.83', 'via' => '1.1 squid-proxy-5b5d847c96-w8vv6 (squid/6.10)', 'host' => 'ts.trdlib.com', 'accept-encoding' => 'gzip, br, zstd, deflate', 'user-agent' => 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)', 'accept' => '*/*', )
[ PARAM ] array ( 'id' => '1135163', )
[ LANG ] D:\tongru\simplewind\cmf\behavior/../lang\zh-cn.php
[ LANG ] D:\tongru\public/../app/admin\lang\zh-cn\common.php
[ LANG ] D:\tongru\public/../app/api\lang\zh-cn\common.php
[ LANG ] D:\tongru\public/../app/plugcode\lang\zh-cn\common.php
[ LANG ] D:\tongru\public/../app/portal\lang\zh-cn\common.php
[ LANG ] D:\tongru\public/../app/product\lang\zh-cn\common.php
[ BEHAVIOR ] Run cmf\behavior\LangBehavior @app_begin [ RunTime:0.003125s ]
[ LANG ] D:\tongru\public/../app/portal\lang\zh-cn.php
[ BEHAVIOR ] Run cmf\behavior\InitAppHookBehavior @module_init [ RunTime:0.000518s ]
[ LANG ] D:\tongru\public/../app/api\lang\zh-cn\home.php
[ LANG ] D:\tongru\public/../app/plugcode\lang\zh-cn\home.php
[ LANG ] D:\tongru\public/../app/portal\lang\zh-cn\home.php
[ LANG ] D:\tongru\public/../app/product\lang\zh-cn\home.php
[ BEHAVIOR ] Run cmf\behavior\HomeLangBehavior @home_init [ RunTime:0.001604s ]
[ SESSION ] INIT array ( 'id' => '', 'var_session_id' => '', 'prefix' => 'think', 'type' => '', 'auto_start' => true, )
[ RUN ] app\portal\controller\ZyarticleController->index[ D:\tongru\app\portal\controller\ZyarticleController.php ]
[ DB ] INIT mysql
[ VIEW ] D:\tongru\public/themes/sucaihu/portal\zyarticle.html [ array ( 0 => 'site_info', 1 => 'cate', 2 => 'tui', 3 => 'comment_count', 4 => 'comment_list', 5 => 'article', 6 => 'cmf_settings', 7 => 'is_favorite', 8 => 'aid', 9 => 'zhangjie', 10 => 'bookid', 11 => 'url', 12 => 'theme_vars', 13 => 'theme_widgets', ) ]

[ DB ] CONNECT:[ UseTime:0.000571s ] mysql:host=127.0.0.1;port=3306;dbname=tongru;charset=utf8
[ SQL ] SHOW COLUMNS FROM `sch_tuisong_log` [ RunTime:0.009861s ]
[ SQL ] SELECT * FROM `sch_tuisong_log` WHERE `tuisong_id` = '0' AND `user_id` = 0 LIMIT 1 [ RunTime:0.000312s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'sch_tuisong_log', 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 5, 'extra' => 'Using where', ) ]
[ SQL ] SHOW COLUMNS FROM `sch_portal_post` [ RunTime:0.008715s ]
[ SQL ] SELECT `post`.* FROM `sch_portal_post` `post` WHERE `post`.`post_type` = 1 AND `post`.`post_status` = 1 AND `post`.`delete_time` = 0 AND `post`.`id` = '1135163' AND ( `post`.`published_time` < '1768846049' and `post`.`published_time` > '0' ) LIMIT 1 [ RunTime:0.003339s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'post', 'type' => 'const', 'possible_keys' => 'PRIMARY,id,type_status_time_leibie,type_status_createtime', 'key' => 'PRIMARY', 'key_len' => '8', 'ref' => 'const', 'rows' => 1, 'extra' => '', ) ]
[ SQL ] SHOW COLUMNS FROM `sch_chubanshe` [ RunTime:0.008497s ]
[ SQL ] SELECT * FROM `sch_chubanshe` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000335s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'sch_chubanshe', 'type' => 'const', 'possible_keys' => 'PRIMARY', 'key' => 'PRIMARY', 'key_len' => '4', 'ref' => 'const', 'rows' => 1, 'extra' => '', ) ]
[ SQL ] SHOW COLUMNS FROM `sch_portal_category` [ RunTime:0.008842s ]
[ SQL ] SELECT * FROM `sch_portal_category` WHERE `id` = 218 LIMIT 1 [ RunTime:0.000280s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'sch_portal_category', 'type' => 'const', 'possible_keys' => 'PRIMARY,id', 'key' => 'PRIMARY', 'key_len' => '8', 'ref' => 'const', 'rows' => 1, 'extra' => '', ) ]
[ SQL ] SELECT * FROM `sch_portal_post` WHERE `category_id` = 218 LIMIT 0,4 [ RunTime:0.023669s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'sch_portal_post', 'type' => 'ref', 'possible_keys' => 'category_leibie_nianling_sex,category_id', 'key' => 'category_id', 'key_len' => '9', 'ref' => 'const', 'rows' => 23942, 'extra' => 'Using where', ) ]
[ SQL ] UPDATE `sch_portal_post` SET `post_hits`=`post_hits`+1 WHERE `id` = 1135163 [ RunTime:0.006691s ]
[ SQL ] SHOW COLUMNS FROM `sch_user` [ RunTime:0.010555s ]
[ SQL ] SELECT * FROM `sch_user` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000325s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => NULL, 'type' => NULL, 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => NULL, 'extra' => 'Impossible WHERE noticed after reading const tables', ) ]
[ SQL ] SHOW COLUMNS FROM `sch_read_log` [ RunTime:0.008119s ]
[ SQL ] SELECT * FROM `sch_read_log` WHERE `user_id` = 0 AND `article_id` = 1135163 LIMIT 1 [ RunTime:0.001161s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'sch_read_log', 'type' => 'ref', 'possible_keys' => 'article_id', 'key' => 'article_id', 'key_len' => '5', 'ref' => 'const', 'rows' => 1, 'extra' => 'Using where', ) ]
[ SQL ] SHOW COLUMNS FROM `sch_portal_comment` [ RunTime:0.008986s ]
[ SQL ] SELECT * FROM `sch_portal_comment` WHERE `object_id` = 1135163 ORDER BY `create_time` DESC LIMIT 0,10 [ RunTime:0.001218s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'sch_portal_comment', 'type' => 'ref', 'possible_keys' => 'object_id', 'key' => 'object_id', 'key_len' => '4', 'ref' => 'const', 'rows' => 1, 'extra' => 'Using where; Using filesort', ) ]
[ SQL ] SHOW COLUMNS FROM `sch_portal_post_map` [ RunTime:0.007877s ]
[ SQL ] SELECT * FROM `sch_portal_post_map` WHERE `bookid` = 1135163 AND `post_status` = 1 ORDER BY `id` ASC [ RunTime:2.506292s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'sch_portal_post_map', 'type' => 'ref', 'possible_keys' => 'type_status_date', 'key' => 'type_status_date', 'key_len' => '1', 'ref' => 'const', 'rows' => 49543, 'extra' => 'Using where; Using filesort', ) ]
[ SQL ] SHOW COLUMNS FROM `sch_zhangyue_setting` [ RunTime:0.009393s ]
[ SQL ] SELECT * FROM `sch_zhangyue_setting` WHERE `id` = 607 LIMIT 1 [ RunTime:0.000242s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'sch_zhangyue_setting', 'type' => 'const', 'possible_keys' => 'PRIMARY', 'key' => 'PRIMARY', 'key_len' => '8', 'ref' => 'const', 'rows' => 1, 'extra' => '', ) ]
[ SQL ] SHOW COLUMNS FROM `sch_theme_file` [ RunTime:0.008895s ]
[ SQL ] SELECT * FROM `sch_theme_file` WHERE `theme` = 'sucaihu' AND `file` = 'portal/article' LIMIT 1 [ RunTime:0.000246s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'sch_theme_file', 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 38, 'extra' => 'Using where', ) ]
[ SQL ] UPDATE `sch_theme_file` SET `theme`='sucaihu',`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` = 'sucaihu' AND `file` = 'portal/article' [ RunTime:0.008959s ]
[ SQL ] SELECT * FROM `sch_theme_file` WHERE `theme` = 'sucaihu' AND `file` = 'portal/articleread' LIMIT 1 [ RunTime:0.000252s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'sch_theme_file', 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 38, 'extra' => 'Using where', ) ]
[ SQL ] UPDATE `sch_theme_file` SET `theme`='sucaihu',`action`='portal/Articleread/index',`file`='portal/articleread',`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` = 'sucaihu' AND `file` = 'portal/articleread' [ RunTime:0.004819s ]
[ SQL ] SELECT * FROM `sch_theme_file` WHERE `theme` = 'sucaihu' AND `file` = 'portal/contact' LIMIT 1 [ RunTime:0.000262s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'sch_theme_file', 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 38, 'extra' => 'Using where', ) ]
[ SQL ] UPDATE `sch_theme_file` SET `theme`='sucaihu',`action`='portal/Page/index',`file`='portal/contact',`name`='联系我们页',`more`='{\"vars\":{\"baidu_map_info_window_text\":{\"title\":\"\\u767e\\u5ea6\\u5730\\u56fe\\u6807\\u6ce8\\u6587\\u5b57\",\"name\":\"baidu_map_info_window_text\",\"value\":\"ThinkCMF<br\\/><span class=\'\'>\\u5730\\u5740\\uff1a\\u4e0a\\u6d77\\u5e02\\u5f90\\u6c47\\u533a\\u659c\\u571f\\u8def2601\\u53f7<\\/span>\",\"type\":\"text\",\"tip\":\"\\u767e\\u5ea6\\u5730\\u56fe\\u6807\\u6ce8\\u6587\\u5b57,\\u652f\\u6301\\u7b80\\u5355html\\u4ee3\\u7801\",\"rule\":[]},\"company_location\":{\"title\":\"\\u516c\\u53f8\\u5750\\u6807\",\"value\":\"\",\"type\":\"location\",\"tip\":\"\",\"rule\":{\"require\":true}},\"address_cn\":{\"title\":\"\\u516c\\u53f8\\u5730\\u5740\",\"value\":\"\\u4e0a\\u6d77\\u5e02\\u5f90\\u6c47\\u533a\\u659c\\u571f\\u8def0001\\u53f7\",\"type\":\"text\",\"tip\":\"\",\"rule\":{\"require\":true}},\"address_en\":{\"title\":\"\\u516c\\u53f8\\u5730\\u5740\\uff08\\u82f1\\u6587\\uff09\",\"value\":\"NO.0001 Xie Tu Road, Shanghai China\",\"type\":\"text\",\"tip\":\"\",\"rule\":{\"require\":true}},\"email\":{\"title\":\"\\u516c\\u53f8\\u90ae\\u7bb1\",\"value\":\"catman@thinkcmf.com\",\"type\":\"text\",\"tip\":\"\",\"rule\":{\"require\":true}},\"phone_cn\":{\"title\":\"\\u516c\\u53f8\\u7535\\u8bdd\",\"value\":\"021 1000 0001\",\"type\":\"text\",\"tip\":\"\",\"rule\":{\"require\":true}},\"phone_en\":{\"title\":\"\\u516c\\u53f8\\u7535\\u8bdd\\uff08\\u82f1\\u6587\\uff09\",\"value\":\"+8621 1000 0001\",\"type\":\"text\",\"tip\":\"\",\"rule\":{\"require\":true}},\"qq\":{\"title\":\"\\u8054\\u7cfbQQ\",\"value\":\"478519726\",\"type\":\"text\",\"tip\":\"\\u591a\\u4e2a QQ\\u4ee5\\u82f1\\u6587\\u9017\\u53f7\\u9694\\u5f00\",\"rule\":{\"require\":true}}}}',`config_more`='{\"vars\":{\"baidu_map_info_window_text\":{\"title\":\"\\u767e\\u5ea6\\u5730\\u56fe\\u6807\\u6ce8\\u6587\\u5b57\",\"name\":\"baidu_map_info_window_text\",\"value\":\"ThinkCMF<br\\/><span class=\'\'>\\u5730\\u5740\\uff1a\\u4e0a\\u6d77\\u5e02\\u5f90\\u6c47\\u533a\\u659c\\u571f\\u8def2601\\u53f7<\\/span>\",\"type\":\"text\",\"tip\":\"\\u767e\\u5ea6\\u5730\\u56fe\\u6807\\u6ce8\\u6587\\u5b57,\\u652f\\u6301\\u7b80\\u5355html\\u4ee3\\u7801\",\"rule\":[]},\"company_location\":{\"title\":\"\\u516c\\u53f8\\u5750\\u6807\",\"value\":\"\",\"type\":\"location\",\"tip\":\"\",\"rule\":{\"require\":true}},\"address_cn\":{\"title\":\"\\u516c\\u53f8\\u5730\\u5740\",\"value\":\"\\u4e0a\\u6d77\\u5e02\\u5f90\\u6c47\\u533a\\u659c\\u571f\\u8def0001\\u53f7\",\"type\":\"text\",\"tip\":\"\",\"rule\":{\"require\":true}},\"address_en\":{\"title\":\"\\u516c\\u53f8\\u5730\\u5740\\uff08\\u82f1\\u6587\\uff09\",\"value\":\"NO.0001 Xie Tu Road, Shanghai China\",\"type\":\"text\",\"tip\":\"\",\"rule\":{\"require\":true}},\"email\":{\"title\":\"\\u516c\\u53f8\\u90ae\\u7bb1\",\"value\":\"catman@thinkcmf.com\",\"type\":\"text\",\"tip\":\"\",\"rule\":{\"require\":true}},\"phone_cn\":{\"title\":\"\\u516c\\u53f8\\u7535\\u8bdd\",\"value\":\"021 1000 0001\",\"type\":\"text\",\"tip\":\"\",\"rule\":{\"require\":true}},\"phone_en\":{\"title\":\"\\u516c\\u53f8\\u7535\\u8bdd\\uff08\\u82f1\\u6587\\uff09\",\"value\":\"+8621 1000 0001\",\"type\":\"text\",\"tip\":\"\",\"rule\":{\"require\":true}},\"qq\":{\"title\":\"\\u8054\\u7cfbQQ\",\"value\":\"478519726\",\"type\":\"text\",\"tip\":\"\\u591a\\u4e2a QQ\\u4ee5\\u82f1\\u6587\\u9017\\u53f7\\u9694\\u5f00\",\"rule\":{\"require\":true}}}}',`description`='联系我们页模板文件',`is_public`=0,`list_order`=10 WHERE `theme` = 'sucaihu' AND `file` = 'portal/contact' [ RunTime:0.005953s ]
[ SQL ] SELECT * FROM `sch_theme_file` WHERE `theme` = 'sucaihu' AND `file` = 'portal/ebookinfo' LIMIT 1 [ RunTime:0.000241s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'sch_theme_file', 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 38, 'extra' => 'Using where', ) ]
[ SQL ] UPDATE `sch_theme_file` SET `theme`='sucaihu',`action`='portal/Article/index',`file`='portal/ebookinfo',`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` = 'sucaihu' AND `file` = 'portal/ebookinfo' [ RunTime:0.004708s ]
[ SQL ] SELECT * FROM `sch_theme_file` WHERE `theme` = 'sucaihu' AND `file` = 'portal/ebooklist' LIMIT 1 [ RunTime:0.000257s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'sch_theme_file', 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 38, 'extra' => 'Using where', ) ]
[ SQL ] UPDATE `sch_theme_file` SET `theme`='sucaihu',`action`='portal/List/index',`file`='portal/ebooklist',`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` = 'sucaihu' AND `file` = 'portal/ebooklist' [ RunTime:0.004942s ]
[ SQL ] SELECT * FROM `sch_theme_file` WHERE `theme` = 'sucaihu' AND `file` = 'portal/guangpaninfo' LIMIT 1 [ RunTime:0.000254s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'sch_theme_file', 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 38, 'extra' => 'Using where', ) ]
[ SQL ] UPDATE `sch_theme_file` SET `theme`='sucaihu',`action`='portal/Article/index',`file`='portal/guangpaninfo',`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` = 'sucaihu' AND `file` = 'portal/guangpaninfo' [ RunTime:0.004675s ]
[ SQL ] SELECT * FROM `sch_theme_file` WHERE `theme` = 'sucaihu' AND `file` = 'portal/guangpanlist' LIMIT 1 [ RunTime:0.000232s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'sch_theme_file', 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 38, 'extra' => 'Using where', ) ]
[ SQL ] UPDATE `sch_theme_file` SET `theme`='sucaihu',`action`='portal/List/index',`file`='portal/guangpanlist',`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` = 'sucaihu' AND `file` = 'portal/guangpanlist' [ RunTime:0.004656s ]
[ SQL ] SELECT * FROM `sch_theme_file` WHERE `theme` = 'sucaihu' AND `file` = 'portal/hotlist' LIMIT 1 [ RunTime:0.000239s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'sch_theme_file', 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 38, 'extra' => 'Using where', ) ]
[ SQL ] UPDATE `sch_theme_file` SET `theme`='sucaihu',`action`='portal/hotlist/index',`file`='portal/hotlist',`name`='文章列表页',`more`='{\"vars\":[]}',`config_more`='{\"vars\":[]}',`description`='文章列表模板文件',`is_public`=0,`list_order`=10 WHERE `theme` = 'sucaihu' AND `file` = 'portal/hotlist' [ RunTime:0.004678s ]
[ SQL ] SELECT * FROM `sch_theme_file` WHERE `theme` = 'sucaihu' AND `file` = 'portal/index' LIMIT 1 [ RunTime:0.000239s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'sch_theme_file', 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 38, 'extra' => 'Using where', ) ]
[ SQL ] UPDATE `sch_theme_file` SET `theme`='sucaihu',`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\":{\"features\":{\"title\":\"\\u5feb\\u901f\\u4e86\\u89e3ThinkCMF\",\"display\":\"1\",\"vars\":{\"sub_title\":{\"title\":\"\\u526f\\u6807\\u9898\",\"value\":\"Quickly understand the ThinkCMF\",\"type\":\"text\",\"placeholder\":\"\\u8bf7\\u8f93\\u5165\\u526f\\u6807\\u9898\",\"tip\":\"\",\"rule\":{\"require\":true}},\"features\":{\"title\":\"\\u7279\\u6027\\u4ecb\\u7ecd\",\"value\":[{\"title\":\"MVC\\u5206\\u5c42\\u6a21\\u5f0f\",\"icon\":\"bars\",\"content\":\"\\u4f7f\\u7528MVC\\u5e94\\u7528\\u7a0b\\u5e8f\\u88ab\\u5206\\u6210\\u4e09\\u4e2a\\u6838\\u5fc3\\u90e8\\u4ef6\\uff1a\\u6a21\\u578b\\uff08M\\uff09\\u3001\\u89c6\\u56fe\\uff08V\\uff09\\u3001\\u63a7\\u5236\\u5668\\uff08C\\uff09\\uff0c\\u4ed6\\u4e0d\\u662f\\u4e00\\u4e2a\\u65b0\\u7684\\u6982\\u5ff5\\uff0c\\u53ea\\u662fThinkCMF\\u5c06\\u5176\\u53d1\\u6325\\u5230\\u4e86\\u6781\\u81f4\\u3002\"},{\"title\":\"\\u7528\\u6237\\u7ba1\\u7406\",\"icon\":\"group\",\"content\":\"ThinkCMF\\u5185\\u7f6e\\u4e86\\u7075\\u6d3b\\u7684\\u7528\\u6237\\u7ba1\\u7406\\u65b9\\u5f0f\\uff0c\\u5e76\\u53ef\\u76f4\\u63a5\\u4e0e\\u7b2c\\u4e09\\u65b9\\u7ad9\\u70b9\\u8fdb\\u884c\\u4e92\\u8054\\u4e92\\u901a\\uff0c\\u5982\\u679c\\u4f60\\u613f\\u610f\\u751a\\u81f3\\u53ef\\u4ee5\\u5bf9\\u5355\\u4e2a\\u7528\\u6237\\u6216\\u7fa4\\u4f53\\u7528\\u6237\\u7684\\u884c\\u4e3a\\u8fdb\\u884c\\u8bb0\\u5f55\\u53ca\\u5206\\u4eab\\uff0c\\u4e3a\\u60a8\\u7684\\u8fd0\\u8425\\u51b3\\u7b56\\u63d0\\u4f9b\\u6709\\u6548\\u53c2\\u8003\\u6570\\u636e\\u3002\"},{\"title\":\"\\u4e91\\u7aef\\u90e8\\u7f72\",\"icon\":\"cloud\",\"content\":\"\\u901a\\u8fc7\\u9a71\\u52a8\\u7684\\u65b9\\u5f0f\\u53ef\\u4ee5\\u8f7b\\u677e\\u652f\\u6301\\u4e91\\u5e73\\u53f0\\u7684\\u90e8\\u7f72\\uff0c\\u8ba9\\u4f60\\u7684\\u7f51\\u7ad9\\u65e0\\u7f1d\\u8fc1\\u79fb\\uff0c\\u5185\\u7f6e\\u5df2\\u7ecf\\u652f\\u6301SAE\\u3001BAE\\uff0c\\u6b63\\u5f0f\\u7248\\u5c06\\u5bf9\\u4e91\\u7aef\\u90e8\\u7f72\\u8fdb\\u884c\\u8fdb\\u4e00\\u6b65\\u4f18\\u5316\\u3002\"},{\"title\":\"\\u5b89\\u5168\\u7b56\\u7565\",\"icon\":\"heart\",\"content\":\"\\u63d0\\u4f9b\\u7684\\u7a33\\u5065\\u7684\\u5b89\\u5168\\u7b56\\u7565\\uff0c\\u5305\\u62ec\\u5907\\u4efd\\u6062\\u590d\\uff0c\\u5bb9\\u9519\\uff0c\\u9632\\u6cbb\\u6076\\u610f\\u653b\\u51fb\\u767b\\u9646\\uff0c\\u7f51\\u9875\\u9632\\u7be1\\u6539\\u7b49\\u591a\\u9879\\u5b89\\u5168\\u7ba1\\u7406\\u529f\\u80fd\\uff0c\\u4fdd\\u8bc1\\u7cfb\\u7edf\\u5b89\\u5168\\uff0c\\u53ef\\u9760\\uff0c\\u7a33\\u5b9a\\u7684\\u8fd0\\u884c\\u3002\"},{\"title\":\"\\u5e94\\u7528\\u6a21\\u5757\\u5316\",\"icon\":\"cubes\",\"content\":\"\\u63d0\\u51fa\\u5168\\u65b0\\u7684\\u5e94\\u7528\\u6a21\\u5f0f\\u8fdb\\u884c\\u6269\\u5c55\\uff0c\\u4e0d\\u7ba1\\u662f\\u4f60\\u5f00\\u53d1\\u4e00\\u4e2a\\u5c0f\\u529f\\u80fd\\u8fd8\\u662f\\u4e00\\u4e2a\\u5168\\u65b0\\u7684\\u7ad9\\u70b9\\uff0c\\u5728ThinkCMF\\u4e2d\\u4f60\\u53ea\\u662f\\u589e\\u52a0\\u4e86\\u4e00\\u4e2aAPP\\uff0c\\u6bcf\\u4e2a\\u72ec\\u7acb\\u8fd0\\u884c\\u4e92\\u4e0d\\u5f71\\u54cd\\uff0c\\u4fbf\\u4e8e\\u7075\\u6d3b\\u6269\\u5c55\\u548c\\u4e8c\\u6b21\\u5f00\\u53d1\\u3002\"},{\"title\":\"\\u514d\\u8d39\\u5f00\\u6e90\",\"icon\":\"certificate\",\"content\":\"\\u4ee3\\u7801\\u9075\\u5faaApache2\\u5f00\\u6e90\\u534f\\u8bae\\uff0c\\u514d\\u8d39\\u4f7f\\u7528\\uff0c\\u5bf9\\u5546\\u4e1a\\u7528\\u6237\\u4e5f\\u65e0\\u4efb\\u4f55\\u9650\\u5236\\u3002\"}],\"type\":\"array\",\"item\":{\"title\":{\"title\":\"\\u6807\\u9898\",\"value\":\"\",\"type\":\"text\",\"rule\":{\"require\":true}},\"icon\":{\"title\":\"\\u56fe\\u6807\",\"value\":\"\",\"type\":\"text\"},\"content\":{\"title\":\"\\u63cf\\u8ff0\",\"value\":\"\",\"type\":\"textarea\"}},\"tip\":\"\"}}},\"last_news\":{\"title\":\"\\u6700\\u65b0\\u8d44\\u8baf\",\"display\":\"1\",\"vars\":{\"last_news_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\":{\"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\":{\"features\":{\"title\":\"\\u5feb\\u901f\\u4e86\\u89e3ThinkCMF\",\"display\":\"1\",\"vars\":{\"sub_title\":{\"title\":\"\\u526f\\u6807\\u9898\",\"value\":\"Quickly understand the ThinkCMF\",\"type\":\"text\",\"placeholder\":\"\\u8bf7\\u8f93\\u5165\\u526f\\u6807\\u9898\",\"tip\":\"\",\"rule\":{\"require\":true}},\"features\":{\"title\":\"\\u7279\\u6027\\u4ecb\\u7ecd\",\"value\":[{\"title\":\"MVC\\u5206\\u5c42\\u6a21\\u5f0f\",\"icon\":\"bars\",\"content\":\"\\u4f7f\\u7528MVC\\u5e94\\u7528\\u7a0b\\u5e8f\\u88ab\\u5206\\u6210\\u4e09\\u4e2a\\u6838\\u5fc3\\u90e8\\u4ef6\\uff1a\\u6a21\\u578b\\uff08M\\uff09\\u3001\\u89c6\\u56fe\\uff08V\\uff09\\u3001\\u63a7\\u5236\\u5668\\uff08C\\uff09\\uff0c\\u4ed6\\u4e0d\\u662f\\u4e00\\u4e2a\\u65b0\\u7684\\u6982\\u5ff5\\uff0c\\u53ea\\u662fThinkCMF\\u5c06\\u5176\\u53d1\\u6325\\u5230\\u4e86\\u6781\\u81f4\\u3002\"},{\"title\":\"\\u7528\\u6237\\u7ba1\\u7406\",\"icon\":\"group\",\"content\":\"ThinkCMF\\u5185\\u7f6e\\u4e86\\u7075\\u6d3b\\u7684\\u7528\\u6237\\u7ba1\\u7406\\u65b9\\u5f0f\\uff0c\\u5e76\\u53ef\\u76f4\\u63a5\\u4e0e\\u7b2c\\u4e09\\u65b9\\u7ad9\\u70b9\\u8fdb\\u884c\\u4e92\\u8054\\u4e92\\u901a\\uff0c\\u5982\\u679c\\u4f60\\u613f\\u610f\\u751a\\u81f3\\u53ef\\u4ee5\\u5bf9\\u5355\\u4e2a\\u7528\\u6237\\u6216\\u7fa4\\u4f53\\u7528\\u6237\\u7684\\u884c\\u4e3a\\u8fdb\\u884c\\u8bb0\\u5f55\\u53ca\\u5206\\u4eab\\uff0c\\u4e3a\\u60a8\\u7684\\u8fd0\\u8425\\u51b3\\u7b56\\u63d0\\u4f9b\\u6709\\u6548\\u53c2\\u8003\\u6570\\u636e\\u3002\"},{\"title\":\"\\u4e91\\u7aef\\u90e8\\u7f72\",\"icon\":\"cloud\",\"content\":\"\\u901a\\u8fc7\\u9a71\\u52a8\\u7684\\u65b9\\u5f0f\\u53ef\\u4ee5\\u8f7b\\u677e\\u652f\\u6301\\u4e91\\u5e73\\u53f0\\u7684\\u90e8\\u7f72\\uff0c\\u8ba9\\u4f60\\u7684\\u7f51\\u7ad9\\u65e0\\u7f1d\\u8fc1\\u79fb\\uff0c\\u5185\\u7f6e\\u5df2\\u7ecf\\u652f\\u6301SAE\\u3001BAE\\uff0c\\u6b63\\u5f0f\\u7248\\u5c06\\u5bf9\\u4e91\\u7aef\\u90e8\\u7f72\\u8fdb\\u884c\\u8fdb\\u4e00\\u6b65\\u4f18\\u5316\\u3002\"},{\"title\":\"\\u5b89\\u5168\\u7b56\\u7565\",\"icon\":\"heart\",\"content\":\"\\u63d0\\u4f9b\\u7684\\u7a33\\u5065\\u7684\\u5b89\\u5168\\u7b56\\u7565\\uff0c\\u5305\\u62ec\\u5907\\u4efd\\u6062\\u590d\\uff0c\\u5bb9\\u9519\\uff0c\\u9632\\u6cbb\\u6076\\u610f\\u653b\\u51fb\\u767b\\u9646\\uff0c\\u7f51\\u9875\\u9632\\u7be1\\u6539\\u7b49\\u591a\\u9879\\u5b89\\u5168\\u7ba1\\u7406\\u529f\\u80fd\\uff0c\\u4fdd\\u8bc1\\u7cfb\\u7edf\\u5b89\\u5168\\uff0c\\u53ef\\u9760\\uff0c\\u7a33\\u5b9a\\u7684\\u8fd0\\u884c\\u3002\"},{\"title\":\"\\u5e94\\u7528\\u6a21\\u5757\\u5316\",\"icon\":\"cubes\",\"content\":\"\\u63d0\\u51fa\\u5168\\u65b0\\u7684\\u5e94\\u7528\\u6a21\\u5f0f\\u8fdb\\u884c\\u6269\\u5c55\\uff0c\\u4e0d\\u7ba1\\u662f\\u4f60\\u5f00\\u53d1\\u4e00\\u4e2a\\u5c0f\\u529f\\u80fd\\u8fd8\\u662f\\u4e00\\u4e2a\\u5168\\u65b0\\u7684\\u7ad9\\u70b9\\uff0c\\u5728ThinkCMF\\u4e2d\\u4f60\\u53ea\\u662f\\u589e\\u52a0\\u4e86\\u4e00\\u4e2aAPP\\uff0c\\u6bcf\\u4e2a\\u72ec\\u7acb\\u8fd0\\u884c\\u4e92\\u4e0d\\u5f71\\u54cd\\uff0c\\u4fbf\\u4e8e\\u7075\\u6d3b\\u6269\\u5c55\\u548c\\u4e8c\\u6b21\\u5f00\\u53d1\\u3002\"},{\"title\":\"\\u514d\\u8d39\\u5f00\\u6e90\",\"icon\":\"certificate\",\"content\":\"\\u4ee3\\u7801\\u9075\\u5faaApache2\\u5f00\\u6e90\\u534f\\u8bae\\uff0c\\u514d\\u8d39\\u4f7f\\u7528\\uff0c\\u5bf9\\u5546\\u4e1a\\u7528\\u6237\\u4e5f\\u65e0\\u4efb\\u4f55\\u9650\\u5236\\u3002\"}],\"type\":\"array\",\"item\":{\"title\":{\"title\":\"\\u6807\\u9898\",\"value\":\"\",\"type\":\"text\",\"rule\":{\"require\":true}},\"icon\":{\"title\":\"\\u56fe\\u6807\",\"value\":\"\",\"type\":\"text\"},\"content\":{\"title\":\"\\u63cf\\u8ff0\",\"value\":\"\",\"type\":\"textarea\"}},\"tip\":\"\"}}},\"last_news\":{\"title\":\"\\u6700\\u65b0\\u8d44\\u8baf\",\"display\":\"1\",\"vars\":{\"last_news_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`=5 WHERE `theme` = 'sucaihu' AND `file` = 'portal/index' [ RunTime:0.004976s ]
[ SQL ] SELECT * FROM `sch_theme_file` WHERE `theme` = 'sucaihu' AND `file` = 'portal/jiansuo' LIMIT 1 [ RunTime:0.000260s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'sch_theme_file', 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 38, 'extra' => 'Using where', ) ]
[ SQL ] UPDATE `sch_theme_file` SET `theme`='sucaihu',`action`='portal/Jiansuo/index',`file`='portal/jiansuo',`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` = 'sucaihu' AND `file` = 'portal/jiansuo' [ RunTime:0.004666s ]
[ SQL ] SELECT * FROM `sch_theme_file` WHERE `theme` = 'sucaihu' AND `file` = 'portal/list' LIMIT 1 [ RunTime:0.000250s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'sch_theme_file', 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 38, 'extra' => 'Using where', ) ]
[ SQL ] UPDATE `sch_theme_file` SET `theme`='sucaihu',`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` = 'sucaihu' AND `file` = 'portal/list' [ RunTime:0.004714s ]
[ SQL ] SELECT * FROM `sch_theme_file` WHERE `theme` = 'sucaihu' AND `file` = 'portal/newlist' LIMIT 1 [ RunTime:0.000239s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'sch_theme_file', 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 38, 'extra' => 'Using where', ) ]
[ SQL ] UPDATE `sch_theme_file` SET `theme`='sucaihu',`action`='portal/Newlist/index',`file`='portal/newlist',`name`='文章列表页',`more`='{\"vars\":[]}',`config_more`='{\"vars\":[]}',`description`='文章列表模板文件',`is_public`=0,`list_order`=10 WHERE `theme` = 'sucaihu' AND `file` = 'portal/newlist' [ RunTime:0.004723s ]
[ SQL ] SELECT * FROM `sch_theme_file` WHERE `theme` = 'sucaihu' AND `file` = 'portal/page' LIMIT 1 [ RunTime:0.000251s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'sch_theme_file', 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 38, 'extra' => 'Using where', ) ]
[ SQL ] UPDATE `sch_theme_file` SET `theme`='sucaihu',`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` = 'sucaihu' AND `file` = 'portal/page' [ RunTime:0.005118s ]
[ SQL ] SELECT * FROM `sch_theme_file` WHERE `theme` = 'sucaihu' AND `file` = 'portal/readactivity' LIMIT 1 [ RunTime:0.000247s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'sch_theme_file', 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 38, 'extra' => 'Using where', ) ]
[ SQL ] UPDATE `sch_theme_file` SET `theme`='sucaihu',`action`='portal/Tzlist/index',`file`='portal/readactivity',`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` = 'sucaihu' AND `file` = 'portal/readactivity' [ RunTime:0.004639s ]
[ SQL ] SELECT * FROM `sch_theme_file` WHERE `theme` = 'sucaihu' AND `file` = 'portal/scan_read' LIMIT 1 [ RunTime:0.000230s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'sch_theme_file', 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 38, 'extra' => 'Using where', ) ]
[ SQL ] UPDATE `sch_theme_file` SET `theme`='sucaihu',`action`='portal/index/scan_read',`file`='portal/scan_read',`name`='扫码阅读',`more`='{\"vars\":[]}',`config_more`='{\"vars\":[]}',`description`='扫码阅读',`is_public`=0,`list_order`=10 WHERE `theme` = 'sucaihu' AND `file` = 'portal/scan_read' [ RunTime:0.005014s ]
[ SQL ] SELECT * FROM `sch_theme_file` WHERE `theme` = 'sucaihu' AND `file` = 'portal/search' LIMIT 1 [ RunTime:0.000229s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'sch_theme_file', 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 38, 'extra' => 'Using where', ) ]
[ SQL ] UPDATE `sch_theme_file` SET `theme`='sucaihu',`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` = 'sucaihu' AND `file` = 'portal/search' [ RunTime:0.004633s ]
[ SQL ] SELECT * FROM `sch_theme_file` WHERE `theme` = 'sucaihu' AND `file` = 'portal/shijianzhou' LIMIT 1 [ RunTime:0.000252s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'sch_theme_file', 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 38, 'extra' => 'Using where', ) ]
[ SQL ] UPDATE `sch_theme_file` SET `theme`='sucaihu',`action`='portal/Tzlist/index',`file`='portal/shijianzhou',`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` = 'sucaihu' AND `file` = 'portal/shijianzhou' [ RunTime:0.004776s ]
[ SQL ] SELECT * FROM `sch_theme_file` WHERE `theme` = 'sucaihu' AND `file` = 'portal/shijianzhouinfo' LIMIT 1 [ RunTime:0.000233s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'sch_theme_file', 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 38, 'extra' => 'Using where', ) ]
[ SQL ] UPDATE `sch_theme_file` SET `theme`='sucaihu',`action`='portal/Tongzhi/index',`file`='portal/shijianzhouinfo',`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` = 'sucaihu' AND `file` = 'portal/shijianzhouinfo' [ RunTime:0.005520s ]
[ SQL ] SELECT * FROM `sch_theme_file` WHERE `theme` = 'sucaihu' AND `file` = 'portal/shijianzhoulist' LIMIT 1 [ RunTime:0.000234s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'sch_theme_file', 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 38, 'extra' => 'Using where', ) ]
[ SQL ] UPDATE `sch_theme_file` SET `theme`='sucaihu',`action`='portal/Tzlist/index',`file`='portal/shijianzhoulist',`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` = 'sucaihu' AND `file` = 'portal/shijianzhoulist' [ RunTime:0.006520s ]
[ SQL ] SELECT * FROM `sch_theme_file` WHERE `theme` = 'sucaihu' AND `file` = 'portal/tongzhi' LIMIT 1 [ RunTime:0.000250s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'sch_theme_file', 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 38, 'extra' => 'Using where', ) ]
[ SQL ] UPDATE `sch_theme_file` SET `theme`='sucaihu',`action`='portal/Tongzhi/index',`file`='portal/tongzhi',`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` = 'sucaihu' AND `file` = 'portal/tongzhi' [ RunTime:0.004631s ]
[ SQL ] SELECT * FROM `sch_theme_file` WHERE `theme` = 'sucaihu' AND `file` = 'portal/tzlist' LIMIT 1 [ RunTime:0.000229s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'sch_theme_file', 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 38, 'extra' => 'Using where', ) ]
[ SQL ] UPDATE `sch_theme_file` SET `theme`='sucaihu',`action`='portal/Tzlist/index',`file`='portal/tzlist',`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` = 'sucaihu' AND `file` = 'portal/tzlist' [ RunTime:0.004968s ]
[ SQL ] SELECT * FROM `sch_theme_file` WHERE `theme` = 'sucaihu' AND `file` = 'portal/vip' LIMIT 1 [ RunTime:0.000246s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'sch_theme_file', 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 38, 'extra' => 'Using where', ) ]
[ SQL ] UPDATE `sch_theme_file` SET `theme`='sucaihu',`action`='portal/Page/index',`file`='portal/vip',`name`='VIP说明页',`more`='{\"vars\":{\"baidu_map_info_window_text\":{\"title\":\"\\u767e\\u5ea6\\u5730\\u56fe\\u6807\\u6ce8\\u6587\\u5b57\",\"name\":\"baidu_map_info_window_text\",\"value\":\"ThinkCMF<br\\/><span class=\'\'>\\u5730\\u5740\\uff1a\\u4e0a\\u6d77\\u5e02\\u5f90\\u6c47\\u533a\\u659c\\u571f\\u8def2601\\u53f7<\\/span>\",\"type\":\"text\",\"tip\":\"\\u767e\\u5ea6\\u5730\\u56fe\\u6807\\u6ce8\\u6587\\u5b57,\\u652f\\u6301\\u7b80\\u5355html\\u4ee3\\u7801\",\"rule\":[]},\"company_location\":{\"title\":\"\\u516c\\u53f8\\u5750\\u6807\",\"value\":\"\",\"type\":\"location\",\"tip\":\"\",\"rule\":{\"require\":true}},\"address_cn\":{\"title\":\"\\u516c\\u53f8\\u5730\\u5740\",\"value\":\"\\u4e0a\\u6d77\\u5e02\\u5f90\\u6c47\\u533a\\u659c\\u571f\\u8def0001\\u53f7\",\"type\":\"text\",\"tip\":\"\",\"rule\":{\"require\":true}},\"address_en\":{\"title\":\"\\u516c\\u53f8\\u5730\\u5740\\uff08\\u82f1\\u6587\\uff09\",\"value\":\"NO.0001 Xie Tu Road, Shanghai China\",\"type\":\"text\",\"tip\":\"\",\"rule\":{\"require\":true}},\"email\":{\"title\":\"\\u516c\\u53f8\\u90ae\\u7bb1\",\"value\":\"catman@thinkcmf.com\",\"type\":\"text\",\"tip\":\"\",\"rule\":{\"require\":true}},\"phone_cn\":{\"title\":\"\\u516c\\u53f8\\u7535\\u8bdd\",\"value\":\"021 1000 0001\",\"type\":\"text\",\"tip\":\"\",\"rule\":{\"require\":true}},\"phone_en\":{\"title\":\"\\u516c\\u53f8\\u7535\\u8bdd\\uff08\\u82f1\\u6587\\uff09\",\"value\":\"+8621 1000 0001\",\"type\":\"text\",\"tip\":\"\",\"rule\":{\"require\":true}},\"qq\":{\"title\":\"\\u8054\\u7cfbQQ\",\"value\":\"79246760\",\"type\":\"text\",\"tip\":\"\\u591a\\u4e2a QQ\\u4ee5\\u82f1\\u6587\\u9017\\u53f7\\u9694\\u5f00\",\"rule\":{\"require\":true}}}}',`config_more`='{\"vars\":{\"baidu_map_info_window_text\":{\"title\":\"\\u767e\\u5ea6\\u5730\\u56fe\\u6807\\u6ce8\\u6587\\u5b57\",\"name\":\"baidu_map_info_window_text\",\"value\":\"ThinkCMF<br\\/><span class=\'\'>\\u5730\\u5740\\uff1a\\u4e0a\\u6d77\\u5e02\\u5f90\\u6c47\\u533a\\u659c\\u571f\\u8def2601\\u53f7<\\/span>\",\"type\":\"text\",\"tip\":\"\\u767e\\u5ea6\\u5730\\u56fe\\u6807\\u6ce8\\u6587\\u5b57,\\u652f\\u6301\\u7b80\\u5355html\\u4ee3\\u7801\",\"rule\":[]},\"company_location\":{\"title\":\"\\u516c\\u53f8\\u5750\\u6807\",\"value\":\"\",\"type\":\"location\",\"tip\":\"\",\"rule\":{\"require\":true}},\"address_cn\":{\"title\":\"\\u516c\\u53f8\\u5730\\u5740\",\"value\":\"\\u4e0a\\u6d77\\u5e02\\u5f90\\u6c47\\u533a\\u659c\\u571f\\u8def0001\\u53f7\",\"type\":\"text\",\"tip\":\"\",\"rule\":{\"require\":true}},\"address_en\":{\"title\":\"\\u516c\\u53f8\\u5730\\u5740\\uff08\\u82f1\\u6587\\uff09\",\"value\":\"NO.0001 Xie Tu Road, Shanghai China\",\"type\":\"text\",\"tip\":\"\",\"rule\":{\"require\":true}},\"email\":{\"title\":\"\\u516c\\u53f8\\u90ae\\u7bb1\",\"value\":\"catman@thinkcmf.com\",\"type\":\"text\",\"tip\":\"\",\"rule\":{\"require\":true}},\"phone_cn\":{\"title\":\"\\u516c\\u53f8\\u7535\\u8bdd\",\"value\":\"021 1000 0001\",\"type\":\"text\",\"tip\":\"\",\"rule\":{\"require\":true}},\"phone_en\":{\"title\":\"\\u516c\\u53f8\\u7535\\u8bdd\\uff08\\u82f1\\u6587\\uff09\",\"value\":\"+8621 1000 0001\",\"type\":\"text\",\"tip\":\"\",\"rule\":{\"require\":true}},\"qq\":{\"title\":\"\\u8054\\u7cfbQQ\",\"value\":\"79246760\",\"type\":\"text\",\"tip\":\"\\u591a\\u4e2a QQ\\u4ee5\\u82f1\\u6587\\u9017\\u53f7\\u9694\\u5f00\",\"rule\":{\"require\":true}}}}',`description`='VIP说明页模板文件',`is_public`=0,`list_order`=10 WHERE `theme` = 'sucaihu' AND `file` = 'portal/vip' [ RunTime:0.006029s ]
[ SQL ] SELECT * FROM `sch_theme_file` WHERE `theme` = 'sucaihu' AND `file` = 'portal/zyarticle' LIMIT 1 [ RunTime:0.000229s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'sch_theme_file', 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 38, 'extra' => 'Using where', ) ]
[ SQL ] UPDATE `sch_theme_file` SET `theme`='sucaihu',`action`='portal/zyarticle/index',`file`='portal/zyarticle',`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` = 'sucaihu' AND `file` = 'portal/zyarticle' [ RunTime:0.004786s ]
[ SQL ] SELECT * FROM `sch_theme_file` WHERE `theme` = 'sucaihu' AND `file` = 'portal/zzbookinfo' LIMIT 1 [ RunTime:0.000240s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'sch_theme_file', 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 38, 'extra' => 'Using where', ) ]
[ SQL ] UPDATE `sch_theme_file` SET `theme`='sucaihu',`action`='portal/Article/index',`file`='portal/zzbookinfo',`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` = 'sucaihu' AND `file` = 'portal/zzbookinfo' [ RunTime:0.004769s ]
[ SQL ] SELECT * FROM `sch_theme_file` WHERE `theme` = 'sucaihu' AND `file` = 'portal/zzbooklist' LIMIT 1 [ RunTime:0.000256s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'sch_theme_file', 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 38, 'extra' => 'Using where', ) ]
[ SQL ] UPDATE `sch_theme_file` SET `theme`='sucaihu',`action`='portal/List/index',`file`='portal/zzbooklist',`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` = 'sucaihu' AND `file` = 'portal/zzbooklist' [ RunTime:0.004673s ]
[ SQL ] SELECT * FROM `sch_theme_file` WHERE `theme` = 'sucaihu' [ RunTime:0.000339s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'sch_theme_file', 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 38, 'extra' => 'Using where', ) ]
[ SQL ] SHOW COLUMNS FROM `sch_theme` [ RunTime:0.009133s ]
[ SQL ] UPDATE `sch_theme` SET `name`='sucaihu',`version`='1.0.1',`demo_url`='http://www.yunmasucai.com',`author`='漂泊者',`lang`='zh-cn',`author_url`='http://www.yunmasucai.com',`keywords`='素材虎模板',`description`='素材虎模板' WHERE `theme` = 'sucaihu' [ RunTime:0.001109s ]
[ SQL ] SELECT `more` FROM `sch_theme_file` WHERE `theme` = 'sucaihu' AND ( `is_public` = 1 OR `file` = 'portal/zyarticle' ) [ RunTime:0.000199s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'sch_theme_file', 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 38, 'extra' => 'Using where', ) ]
[ SQL ] SHOW COLUMNS FROM `sch_option` [ RunTime:0.008521s ]
[ SQL ] SELECT `option_value` FROM `sch_option` WHERE `option_name` = 'storage' LIMIT 1 [ RunTime:0.000219s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => NULL, 'type' => NULL, 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => NULL, 'extra' => 'Impossible WHERE noticed after reading const tables', ) ]

2.927337s