基本
文件
流程
错误
SQL
调试
- 请求信息 : 2023-12-01 04:15:26 HTTP/1.1 GET : http://punctuationmadesimple.org/news_magazine.html?page=5
- 运行时间 : 0.367295s [ 吞吐率：2.72req/s ] 内存消耗：4,986.17kb 文件加载：110
- 查询信息 : 81 queries 48 writes
- 缓存信息 : 6 reads,0 writes
- [ LANG ] D:\wwwroot\ccepc/vendor\thinkphp\lang\zh-cn.php
- [ LANG ] D:\wwwroot\ccepc\app\portal\\lang\zh-cn.php
- [ ROUTE ] array (
'rule' => 'news_magazine',
'route' => 'portal/List/index?id=39',
'option' =>
array (
'merge_rule_regex' => false,
),
'var' =>
array (
),
)
- [ HEADER ] array (
'content-type' => 'text/html',
'content-length' => '0',
'x-original-url' => '/news_magazine.html?page=5',
'user-agent' => 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/73.0.3683.103 Safari/537.36',
'host' => 'punctuationmadesimple.org',
'accept' => 'text/html, application/xhtml+xml, */*',
'connection' => 'Close',
)
- [ PARAM ] array (
'page' => '5',
'id' => '39',
)
- [ LANG ] D:\wwwroot\ccepc\vendor\thinkcmf\cmf\src\behavior/../lang\zh-cn.php
- [ LANG ] D:\wwwroot\ccepc\vendor/thinkcmf/cmf-app/src/admin/lang/zh-cn.php
- [ LANG ] D:\wwwroot\ccepc\vendor/thinkcmf/cmf-app/src/admin/lang/zh-cn/common.php
- [ LANG ] D:\wwwroot\ccepc\vendor/thinkcmf/cmf-app/src/user/lang/zh-cn.php
- [ LANG ] D:\wwwroot\ccepc/app/portal\lang\zh-cn\common.php
- [ DB ] INIT mysql
- [ LANG ] D:\wwwroot\ccepc/app/portal\lang\zh-cn\home.php
- [ VIEW ] D:\wwwroot\ccepc\public/themes/simpleboot3/portal\list_news_magazine.html [ array (
0 => 'site_info',
1 => 'category',
2 => 'theme_vars',
3 => 'theme_widgets',
) ]
- [ DB ] CONNECT:[ UseTime:0.009898s ] mysql:host=172.16.0.90;port=3306;dbname=ccepc;charset=utf8
- [ SQL ] SHOW COLUMNS FROM `cmf_plugin` [ RunTime:0.003470s ]
- [ SQL ] SELECT `config` FROM `cmf_plugin` WHERE `name` = 'TcSwitchTheme' LIMIT 1 [ RunTime:0.000801s ]
- [ 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' => 2,
'filtered' => 50.0,
'extra' => 'Using where',
) ]
- [ SQL ] SHOW COLUMNS FROM `cmf_blacklist` [ RunTime:0.001815s ]
- [ SQL ] SELECT * FROM `cmf_blacklist` WHERE `ip` = '154.203.5.89' LIMIT 1 [ RunTime:0.000784s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => NULL,
'partitions' => NULL,
'type' => NULL,
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => NULL,
'filtered' => NULL,
'extra' => 'no matching row in const table',
) ]
- [ SQL ] SHOW COLUMNS FROM `cmf_portal_category` [ RunTime:0.002228s ]
- [ SQL ] SELECT * FROM `cmf_portal_category` WHERE `id` = 39 AND `status` = 1 LIMIT 1 [ RunTime:0.001093s ]
- [ 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.0,
'extra' => NULL,
) ]
- [ SQL ] SHOW COLUMNS FROM `cmf_theme_file` [ RunTime:0.002669s ]
- [ SQL ] SELECT * FROM `cmf_theme_file` WHERE `theme` = 'simpleboot3' AND `file` = 'portal/datail_development_recruitment' LIMIT 1 [ RunTime:0.000828s ]
- [ 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' => 89,
'filtered' => 1.1235954761505127,
'extra' => 'Using where',
) ]
- [ SQL ] UPDATE `cmf_theme_file` SET `theme` = 'simpleboot3' , `action` = 'portal/Article/index' , `file` = 'portal/datail_development_recruitment' , `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` = 'simpleboot3' AND `file` = 'portal/datail_development_recruitment' [ RunTime:0.000702s ]
- [ SQL ] SELECT * FROM `cmf_theme_file` WHERE `theme` = 'simpleboot3' AND `file` = 'portal/detail_about_information_information' LIMIT 1 [ RunTime:0.000486s ]
- [ 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' => 89,
'filtered' => 1.1235954761505127,
'extra' => 'Using where',
) ]
- [ SQL ] UPDATE `cmf_theme_file` SET `theme` = 'simpleboot3' , `action` = 'portal/Article/index' , `file` = 'portal/detail_about_information_information' , `name` = '公司概况>信息公开>公开信息' , `more` = '[]' , `config_more` = '[]' , `description` = '文章页模板文件' , `is_public` = 0 , `list_order` = 2092 WHERE `theme` = 'simpleboot3' AND `file` = 'portal/detail_about_information_information' [ RunTime:0.000657s ]
- [ SQL ] SELECT * FROM `cmf_theme_file` WHERE `theme` = 'simpleboot3' AND `file` = 'portal/detail_branches_60' LIMIT 1 [ RunTime:0.000482s ]
- [ 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' => 89,
'filtered' => 1.1235954761505127,
'extra' => 'Using where',
) ]
- [ SQL ] UPDATE `cmf_theme_file` SET `theme` = 'simpleboot3' , `action` = 'portal/Article/index' , `file` = 'portal/detail_branches_60' , `name` = '分子机构>水务分公司' , `more` = '[]' , `config_more` = '[]' , `description` = '文章页模板文件' , `is_public` = 0 , `list_order` = 7010 WHERE `theme` = 'simpleboot3' AND `file` = 'portal/detail_branches_60' [ RunTime:0.000615s ]
- [ SQL ] SELECT * FROM `cmf_theme_file` WHERE `theme` = 'simpleboot3' AND `file` = 'portal/detail_branches_61' LIMIT 1 [ RunTime:0.000568s ]
- [ 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' => 89,
'filtered' => 1.1235954761505127,
'extra' => 'Using where',
) ]
- [ SQL ] UPDATE `cmf_theme_file` SET `theme` = 'simpleboot3' , `action` = 'portal/Article/index' , `file` = 'portal/detail_branches_61' , `name` = '分子机构>废气治理分公司' , `more` = '[]' , `config_more` = '[]' , `description` = '文章页模板文件' , `is_public` = 0 , `list_order` = 7020 WHERE `theme` = 'simpleboot3' AND `file` = 'portal/detail_branches_61' [ RunTime:0.000626s ]
- [ SQL ] SELECT * FROM `cmf_theme_file` WHERE `theme` = 'simpleboot3' AND `file` = 'portal/detail_branches_62' LIMIT 1 [ RunTime:0.000530s ]
- [ 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' => 89,
'filtered' => 1.1235954761505127,
'extra' => 'Using where',
) ]
- [ SQL ] UPDATE `cmf_theme_file` SET `theme` = 'simpleboot3' , `action` = 'portal/Article/index' , `file` = 'portal/detail_branches_62' , `name` = '分子机构>环境修复分公司' , `more` = '[]' , `config_more` = '[]' , `description` = '文章页模板文件' , `is_public` = 0 , `list_order` = 7030 WHERE `theme` = 'simpleboot3' AND `file` = 'portal/detail_branches_62' [ RunTime:0.000681s ]
- [ SQL ] SELECT * FROM `cmf_theme_file` WHERE `theme` = 'simpleboot3' AND `file` = 'portal/detail_branches_63' LIMIT 1 [ RunTime:0.000530s ]
- [ 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' => 89,
'filtered' => 1.1235954761505127,
'extra' => 'Using where',
) ]
- [ SQL ] UPDATE `cmf_theme_file` SET `theme` = 'simpleboot3' , `action` = 'portal/Article/index' , `file` = 'portal/detail_branches_63' , `name` = '分子机构>亚新app官网源开发大丰有限公司' , `more` = '[]' , `config_more` = '[]' , `description` = '文章页模板文件' , `is_public` = 0 , `list_order` = 7040 WHERE `theme` = 'simpleboot3' AND `file` = 'portal/detail_branches_63' [ RunTime:0.000656s ]
- [ SQL ] SELECT * FROM `cmf_theme_file` WHERE `theme` = 'simpleboot3' AND `file` = 'portal/detail_branches_64' LIMIT 1 [ RunTime:0.000534s ]
- [ 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' => 89,
'filtered' => 1.1235954761505127,
'extra' => 'Using where',
) ]
- [ SQL ] UPDATE `cmf_theme_file` SET `theme` = 'simpleboot3' , `action` = 'portal/Article/index' , `file` = 'portal/detail_branches_64' , `name` = '分子机构>武汉水务有限公司' , `more` = '[]' , `config_more` = '[]' , `description` = '文章页模板文件' , `is_public` = 0 , `list_order` = 7050 WHERE `theme` = 'simpleboot3' AND `file` = 'portal/detail_branches_64' [ RunTime:0.000614s ]
- [ SQL ] SELECT * FROM `cmf_theme_file` WHERE `theme` = 'simpleboot3' AND `file` = 'portal/detail_branches_65' LIMIT 1 [ RunTime:0.000542s ]
- [ 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' => 89,
'filtered' => 1.1235954761505127,
'extra' => 'Using where',
) ]
- [ SQL ] UPDATE `cmf_theme_file` SET `theme` = 'simpleboot3' , `action` = 'portal/Article/index' , `file` = 'portal/detail_branches_65' , `name` = '分子机构>固废处理分公司' , `more` = '[]' , `config_more` = '[]' , `description` = '文章页模板文件' , `is_public` = 0 , `list_order` = 7060 WHERE `theme` = 'simpleboot3' AND `file` = 'portal/detail_branches_65' [ RunTime:0.000658s ]
- [ SQL ] SELECT * FROM `cmf_theme_file` WHERE `theme` = 'simpleboot3' AND `file` = 'portal/detail_development_join_declare' LIMIT 1 [ RunTime:0.000537s ]
- [ 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' => 89,
'filtered' => 1.1235954761505127,
'extra' => 'Using where',
) ]
- [ SQL ] UPDATE `cmf_theme_file` SET `theme` = 'simpleboot3' , `action` = 'portal/Article/index' , `file` = 'portal/detail_development_join_declare' , `name` = '人力资源>招聘声明' , `more` = '[]' , `config_more` = '[]' , `description` = '文章页模板文件' , `is_public` = 0 , `list_order` = 8021 WHERE `theme` = 'simpleboot3' AND `file` = 'portal/detail_development_join_declare' [ RunTime:0.000592s ]
- [ SQL ] SELECT * FROM `cmf_theme_file` WHERE `theme` = 'simpleboot3' AND `file` = 'portal/detail_development_join_statement' LIMIT 1 [ RunTime:0.000579s ]
- [ 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' => 89,
'filtered' => 1.1235954761505127,
'extra' => 'Using where',
) ]
- [ SQL ] UPDATE `cmf_theme_file` SET `theme` = 'simpleboot3' , `action` = 'portal/Article/index' , `file` = 'portal/detail_development_join_statement' , `name` = '人力资源>招聘公告' , `more` = '[]' , `config_more` = '[]' , `description` = '文章页模板文件' , `is_public` = 0 , `list_order` = 8022 WHERE `theme` = 'simpleboot3' AND `file` = 'portal/detail_development_join_statement' [ RunTime:0.000585s ]
- [ SQL ] SELECT * FROM `cmf_theme_file` WHERE `theme` = 'simpleboot3' AND `file` = 'portal/detail_news_article' LIMIT 1 [ RunTime:0.000549s ]
- [ 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' => 89,
'filtered' => 1.1235954761505127,
'extra' => 'Using where',
) ]
- [ SQL ] UPDATE `cmf_theme_file` SET `theme` = 'simpleboot3' , `action` = 'portal/Article/index' , `file` = 'portal/detail_news_article' , `name` = '新闻中心>通用详情' , `more` = '[]' , `config_more` = '[]' , `description` = '文章页模板文件' , `is_public` = 0 , `list_order` = 3010 WHERE `theme` = 'simpleboot3' AND `file` = 'portal/detail_news_article' [ RunTime:0.000652s ]
- [ SQL ] SELECT * FROM `cmf_theme_file` WHERE `theme` = 'simpleboot3' AND `file` = 'portal/detail_news_magazine' LIMIT 1 [ RunTime:0.000486s ]
- [ 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' => 89,
'filtered' => 1.1235954761505127,
'extra' => 'Using where',
) ]
- [ SQL ] UPDATE `cmf_theme_file` SET `theme` = 'simpleboot3' , `action` = 'portal/Article/index' , `file` = 'portal/detail_news_magazine' , `name` = '新闻中心>企业内刊' , `more` = '[]' , `config_more` = '[]' , `description` = '文章页模板文件' , `is_public` = 0 , `list_order` = 3020 WHERE `theme` = 'simpleboot3' AND `file` = 'portal/detail_news_magazine' [ RunTime:0.000692s ]
- [ SQL ] SELECT * FROM `cmf_theme_file` WHERE `theme` = 'simpleboot3' AND `file` = 'portal/detail_party_article' LIMIT 1 [ RunTime:0.000472s ]
- [ 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' => 89,
'filtered' => 1.1235954761505127,
'extra' => 'Using where',
) ]
- [ SQL ] UPDATE `cmf_theme_file` SET `theme` = 'simpleboot3' , `action` = 'portal/Article/index' , `file` = 'portal/detail_party_article' , `name` = '党群建设>通用详情' , `more` = '[]' , `config_more` = '[]' , `description` = '文章页模板文件' , `is_public` = 0 , `list_order` = 4010 WHERE `theme` = 'simpleboot3' AND `file` = 'portal/detail_party_article' [ RunTime:0.000641s ]
- [ SQL ] SELECT * FROM `cmf_theme_file` WHERE `theme` = 'simpleboot3' AND `file` = 'portal/detail_project_achievements' LIMIT 1 [ RunTime:0.000516s ]
- [ 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' => 89,
'filtered' => 1.1235954761505127,
'extra' => 'Using where',
) ]
- [ SQL ] UPDATE `cmf_theme_file` SET `theme` = 'simpleboot3' , `action` = 'portal/Article/index' , `file` = 'portal/detail_project_achievements' , `name` = '工程业绩>业绩表' , `more` = '[]' , `config_more` = '[]' , `description` = '文章页模板文件' , `is_public` = 0 , `list_order` = 5030 WHERE `theme` = 'simpleboot3' AND `file` = 'portal/detail_project_achievements' [ RunTime:0.000633s ]
- [ SQL ] SELECT * FROM `cmf_theme_file` WHERE `theme` = 'simpleboot3' AND `file` = 'portal/detail_project_case_article' LIMIT 1 [ RunTime:0.000480s ]
- [ 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' => 89,
'filtered' => 1.1235954761505127,
'extra' => 'Using where',
) ]
- [ SQL ] UPDATE `cmf_theme_file` SET `theme` = 'simpleboot3' , `action` = 'portal/Article/index' , `file` = 'portal/detail_project_case_article' , `name` = '工程业绩>工程案例>通用详情' , `more` = '[]' , `config_more` = '[]' , `description` = '文章页模板文件' , `is_public` = 0 , `list_order` = 5020 WHERE `theme` = 'simpleboot3' AND `file` = 'portal/detail_project_case_article' [ RunTime:0.000649s ]
- [ SQL ] SELECT * FROM `cmf_theme_file` WHERE `theme` = 'simpleboot3' AND `file` = 'portal/detail_technology_platform' LIMIT 1 [ RunTime:0.000507s ]
- [ 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' => 89,
'filtered' => 1.1235954761505127,
'extra' => 'Using where',
) ]
- [ SQL ] UPDATE `cmf_theme_file` SET `theme` = 'simpleboot3' , `action` = 'portal/Article/index' , `file` = 'portal/detail_technology_platform' , `name` = '技术研发>研发平台' , `more` = '[]' , `config_more` = '[]' , `description` = '文章页模板文件' , `is_public` = 0 , `list_order` = 6020 WHERE `theme` = 'simpleboot3' AND `file` = 'portal/detail_technology_platform' [ RunTime:0.000714s ]
- [ SQL ] SELECT * FROM `cmf_theme_file` WHERE `theme` = 'simpleboot3' AND `file` = 'portal/list_about' 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' => 89,
'filtered' => 1.1235954761505127,
'extra' => 'Using where',
) ]
- [ SQL ] UPDATE `cmf_theme_file` SET `theme` = 'simpleboot3' , `action` = 'portal/List/index' , `file` = 'portal/list_about' , `name` = '公司概况(聚合页)' , `more` = '[]' , `config_more` = '[]' , `description` = '文章列表模板文件' , `is_public` = 0 , `list_order` = 2000 WHERE `theme` = 'simpleboot3' AND `file` = 'portal/list_about' [ RunTime:0.000617s ]
- [ SQL ] SELECT * FROM `cmf_theme_file` WHERE `theme` = 'simpleboot3' AND `file` = 'portal/list_about_chronicle' LIMIT 1 [ RunTime:0.000499s ]
- [ 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' => 89,
'filtered' => 1.1235954761505127,
'extra' => 'Using where',
) ]
- [ SQL ] UPDATE `cmf_theme_file` SET `theme` = 'simpleboot3' , `action` = 'portal/List/index' , `file` = 'portal/list_about_chronicle' , `name` = '公司概况>大事记' , `more` = '[]' , `config_more` = '[]' , `description` = '文章列表模板文件' , `is_public` = 0 , `list_order` = 2080 WHERE `theme` = 'simpleboot3' AND `file` = 'portal/list_about_chronicle' [ RunTime:0.000598s ]
- [ SQL ] SELECT * FROM `cmf_theme_file` WHERE `theme` = 'simpleboot3' AND `file` = 'portal/list_about_culture' LIMIT 1 [ RunTime:0.000456s ]
- [ 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' => 89,
'filtered' => 1.1235954761505127,
'extra' => 'Using where',
) ]
- [ SQL ] UPDATE `cmf_theme_file` SET `theme` = 'simpleboot3' , `action` = 'portal/List/index' , `file` = 'portal/list_about_culture' , `name` = '公司概况>企业文化' , `more` = '[]' , `config_more` = '[]' , `description` = '文章列表模板文件' , `is_public` = 0 , `list_order` = 2020 WHERE `theme` = 'simpleboot3' AND `file` = 'portal/list_about_culture' [ RunTime:0.000646s ]
- [ SQL ] SELECT * FROM `cmf_theme_file` WHERE `theme` = 'simpleboot3' AND `file` = 'portal/list_about_form' LIMIT 1 [ RunTime:0.000475s ]
- [ 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' => 89,
'filtered' => 1.1235954761505127,
'extra' => 'Using where',
) ]
- [ SQL ] UPDATE `cmf_theme_file` SET `theme` = 'simpleboot3' , `action` = 'portal/List/index' , `file` = 'portal/list_about_form' , `name` = '公司概况>业务形式' , `more` = '[]' , `config_more` = '[]' , `description` = '文章列表模板文件' , `is_public` = 0 , `list_order` = 2040 WHERE `theme` = 'simpleboot3' AND `file` = 'portal/list_about_form' [ RunTime:0.000619s ]
- [ SQL ] SELECT * FROM `cmf_theme_file` WHERE `theme` = 'simpleboot3' AND `file` = 'portal/list_about_honor' LIMIT 1 [ RunTime:0.000449s ]
- [ 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' => 89,
'filtered' => 1.1235954761505127,
'extra' => 'Using where',
) ]
- [ SQL ] UPDATE `cmf_theme_file` SET `theme` = 'simpleboot3' , `action` = 'portal/List/index' , `file` = 'portal/list_about_honor' , `name` = '公司概况>公司荣誉' , `more` = '[]' , `config_more` = '[]' , `description` = '文章列表模板文件' , `is_public` = 0 , `list_order` = 2070 WHERE `theme` = 'simpleboot3' AND `file` = 'portal/list_about_honor' [ RunTime:0.000676s ]
- [ SQL ] SELECT * FROM `cmf_theme_file` WHERE `theme` = 'simpleboot3' AND `file` = 'portal/list_about_information' LIMIT 1 [ RunTime:0.000490s ]
- [ 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' => 89,
'filtered' => 1.1235954761505127,
'extra' => 'Using where',
) ]
- [ SQL ] UPDATE `cmf_theme_file` SET `theme` = 'simpleboot3' , `action` = 'portal/List/index' , `file` = 'portal/list_about_information' , `name` = '公司概况>信息公开' , `more` = '[]' , `config_more` = '[]' , `description` = '文章列表模板文件' , `is_public` = 0 , `list_order` = 2090 WHERE `theme` = 'simpleboot3' AND `file` = 'portal/list_about_information' [ RunTime:0.000555s ]
- [ SQL ] SELECT * FROM `cmf_theme_file` WHERE `theme` = 'simpleboot3' AND `file` = 'portal/list_about_information_information' LIMIT 1 [ RunTime:0.000509s ]
- [ 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' => 89,
'filtered' => 1.1235954761505127,
'extra' => 'Using where',
) ]
- [ SQL ] UPDATE `cmf_theme_file` SET `theme` = 'simpleboot3' , `action` = 'portal/List/index' , `file` = 'portal/list_about_information_information' , `name` = '公司概况>信息公开>公开信息' , `more` = '[]' , `config_more` = '[]' , `description` = '文章列表模板文件' , `is_public` = 0 , `list_order` = 2092 WHERE `theme` = 'simpleboot3' AND `file` = 'portal/list_about_information_information' [ RunTime:0.000615s ]
- [ SQL ] SELECT * FROM `cmf_theme_file` WHERE `theme` = 'simpleboot3' AND `file` = 'portal/list_about_information_regulations' LIMIT 1 [ RunTime:0.000496s ]
- [ 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' => 89,
'filtered' => 1.1235954761505127,
'extra' => 'Using where',
) ]
- [ SQL ] UPDATE `cmf_theme_file` SET `theme` = 'simpleboot3' , `action` = 'portal/List/index' , `file` = 'portal/list_about_information_regulations' , `name` = '公司概况>信息公开>公开规定' , `more` = '[]' , `config_more` = '[]' , `description` = '文章列表模板文件' , `is_public` = 0 , `list_order` = 2091 WHERE `theme` = 'simpleboot3' AND `file` = 'portal/list_about_information_regulations' [ RunTime:0.000683s ]
- [ SQL ] SELECT * FROM `cmf_theme_file` WHERE `theme` = 'simpleboot3' AND `file` = 'portal/list_about_organization' LIMIT 1 [ RunTime:0.000498s ]
- [ 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' => 89,
'filtered' => 1.1235954761505127,
'extra' => 'Using where',
) ]
- [ SQL ] UPDATE `cmf_theme_file` SET `theme` = 'simpleboot3' , `action` = 'portal/List/index' , `file` = 'portal/list_about_organization' , `name` = '公司概况>组织机构' , `more` = '[]' , `config_more` = '[]' , `description` = '文章列表模板文件' , `is_public` = 0 , `list_order` = 2050 WHERE `theme` = 'simpleboot3' AND `file` = 'portal/list_about_organization' [ RunTime:0.000666s ]
- [ SQL ] SELECT * FROM `cmf_theme_file` WHERE `theme` = 'simpleboot3' AND `file` = 'portal/list_about_profile' LIMIT 1 [ RunTime:0.000457s ]
- [ 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' => 89,
'filtered' => 1.1235954761505127,
'extra' => 'Using where',
) ]
- [ SQL ] UPDATE `cmf_theme_file` SET `theme` = 'simpleboot3' , `action` = 'portal/List/index' , `file` = 'portal/list_about_profile' , `name` = '公司概况>公司简介' , `more` = '[]' , `config_more` = '[]' , `description` = '文章列表模板文件' , `is_public` = 0 , `list_order` = 2010 WHERE `theme` = 'simpleboot3' AND `file` = 'portal/list_about_profile' [ RunTime:0.000641s ]
- [ SQL ] SELECT * FROM `cmf_theme_file` WHERE `theme` = 'simpleboot3' AND `file` = 'portal/list_about_qualification' LIMIT 1 [ RunTime:0.000475s ]
- [ 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' => 89,
'filtered' => 1.1235954761505127,
'extra' => 'Using where',
) ]
- [ SQL ] UPDATE `cmf_theme_file` SET `theme` = 'simpleboot3' , `action` = 'portal/List/index' , `file` = 'portal/list_about_qualification' , `name` = '公司概况>公司资质' , `more` = '[]' , `config_more` = '[]' , `description` = '文章列表模板文件' , `is_public` = 0 , `list_order` = 2060 WHERE `theme` = 'simpleboot3' AND `file` = 'portal/list_about_qualification' [ RunTime:0.000609s ]
- [ SQL ] SELECT * FROM `cmf_theme_file` WHERE `theme` = 'simpleboot3' AND `file` = 'portal/list_about_scope' LIMIT 1 [ RunTime:0.000442s ]
- [ 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' => 89,
'filtered' => 1.1235954761505127,
'extra' => 'Using where',
) ]
- [ SQL ] UPDATE `cmf_theme_file` SET `theme` = 'simpleboot3' , `action` = 'portal/List/index' , `file` = 'portal/list_about_scope' , `name` = '公司概况>业务范围' , `more` = '[]' , `config_more` = '[]' , `description` = '文章列表模板文件' , `is_public` = 0 , `list_order` = 2030 WHERE `theme` = 'simpleboot3' AND `file` = 'portal/list_about_scope' [ RunTime:0.000632s ]
- [ SQL ] SELECT * FROM `cmf_theme_file` WHERE `theme` = 'simpleboot3' AND `file` = 'portal/list_branches' LIMIT 1 [ RunTime:0.000482s ]
- [ 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' => 89,
'filtered' => 1.1235954761505127,
'extra' => 'Using where',
) ]
- [ SQL ] UPDATE `cmf_theme_file` SET `theme` = 'simpleboot3' , `action` = 'portal/List/index' , `file` = 'portal/list_branches' , `name` = '分子机构(聚合页)' , `more` = '[]' , `config_more` = '[]' , `description` = '文章列表模板文件' , `is_public` = 0 , `list_order` = 7000 WHERE `theme` = 'simpleboot3' AND `file` = 'portal/list_branches' [ RunTime:0.000598s ]
- [ SQL ] SELECT * FROM `cmf_theme_file` WHERE `theme` = 'simpleboot3' AND `file` = 'portal/list_category_next' LIMIT 1 [ RunTime:0.000489s ]
- [ 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' => 89,
'filtered' => 1.1235954761505127,
'extra' => 'Using where',
) ]
- [ SQL ] UPDATE `cmf_theme_file` SET `theme` = 'simpleboot3' , `action` = 'portal/List/index' , `file` = 'portal/list_category_next' , `name` = '跳转至下一级' , `more` = '[]' , `config_more` = '[]' , `description` = '文章列表模板文件' , `is_public` = 0 , `list_order` = 102 WHERE `theme` = 'simpleboot3' AND `file` = 'portal/list_category_next' [ RunTime:0.000755s ]
- [ SQL ] SELECT * FROM `cmf_theme_file` WHERE `theme` = 'simpleboot3' AND `file` = 'portal/list_category_prev' LIMIT 1 [ RunTime:0.000451s ]
- [ 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' => 89,
'filtered' => 1.1235954761505127,
'extra' => 'Using where',
) ]
- [ SQL ] UPDATE `cmf_theme_file` SET `theme` = 'simpleboot3' , `action` = 'portal/List/index' , `file` = 'portal/list_category_prev' , `name` = '跳转至上一级' , `more` = '[]' , `config_more` = '[]' , `description` = '文章列表模板文件' , `is_public` = 0 , `list_order` = 101 WHERE `theme` = 'simpleboot3' AND `file` = 'portal/list_category_prev' [ RunTime:0.000650s ]
- [ SQL ] SELECT * FROM `cmf_theme_file` WHERE `theme` = 'simpleboot3' AND `file` = 'portal/list_contact' LIMIT 1 [ RunTime:0.000566s ]
- [ 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' => 89,
'filtered' => 1.1235954761505127,
'extra' => 'Using where',
) ]
- [ SQL ] UPDATE `cmf_theme_file` SET `theme` = 'simpleboot3' , `action` = 'portal/List/index' , `file` = 'portal/list_contact' , `name` = '联系我们' , `more` = '[]' , `config_more` = '[]' , `description` = '文章列表模板文件' , `is_public` = 0 , `list_order` = 9000 WHERE `theme` = 'simpleboot3' AND `file` = 'portal/list_contact' [ RunTime:0.000554s ]
- [ SQL ] SELECT * FROM `cmf_theme_file` WHERE `theme` = 'simpleboot3' AND `file` = 'portal/list_development_join' LIMIT 1 [ RunTime:0.000505s ]
- [ 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' => 89,
'filtered' => 1.1235954761505127,
'extra' => 'Using where',
) ]
- [ SQL ] UPDATE `cmf_theme_file` SET `theme` = 'simpleboot3' , `action` = 'portal/List/index' , `file` = 'portal/list_development_join' , `name` = '人力资源>人才招聘' , `more` = '[]' , `config_more` = '[]' , `description` = '文章列表模板文件' , `is_public` = 0 , `list_order` = 8020 WHERE `theme` = 'simpleboot3' AND `file` = 'portal/list_development_join' [ RunTime:0.000661s ]
- [ SQL ] SELECT * FROM `cmf_theme_file` WHERE `theme` = 'simpleboot3' AND `file` = 'portal/list_development_join_statement' LIMIT 1 [ RunTime:0.000490s ]
- [ 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' => 89,
'filtered' => 1.1235954761505127,
'extra' => 'Using where',
) ]
- [ SQL ] UPDATE `cmf_theme_file` SET `theme` = 'simpleboot3' , `action` = 'portal/List/index' , `file` = 'portal/list_development_join_statement' , `name` = '人力资源>招聘公告' , `more` = '[]' , `config_more` = '[]' , `description` = '文章列表模板文件' , `is_public` = 0 , `list_order` = 8022 WHERE `theme` = 'simpleboot3' AND `file` = 'portal/list_development_join_statement' [ RunTime:0.000647s ]
- [ SQL ] SELECT * FROM `cmf_theme_file` WHERE `theme` = 'simpleboot3' AND `file` = 'portal/list_development_profile' LIMIT 1 [ RunTime:0.000544s ]
- [ 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' => 89,
'filtered' => 1.1235954761505127,
'extra' => 'Using where',
) ]
- [ SQL ] UPDATE `cmf_theme_file` SET `theme` = 'simpleboot3' , `action` = 'portal/List/index' , `file` = 'portal/list_development_profile' , `name` = '人力资源>通用页面' , `more` = '[]' , `config_more` = '[]' , `description` = '文章列表模板文件' , `is_public` = 0 , `list_order` = 8010 WHERE `theme` = 'simpleboot3' AND `file` = 'portal/list_development_profile' [ RunTime:0.000661s ]
- [ SQL ] SELECT * FROM `cmf_theme_file` WHERE `theme` = 'simpleboot3' AND `file` = 'portal/list_development_salary' LIMIT 1 [ RunTime:0.000531s ]
- [ 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' => 89,
'filtered' => 1.1235954761505127,
'extra' => 'Using where',
) ]
- [ SQL ] UPDATE `cmf_theme_file` SET `theme` = 'simpleboot3' , `action` = 'portal/List/index' , `file` = 'portal/list_development_salary' , `name` = '人力资源>薪酬福利' , `more` = '[]' , `config_more` = '[]' , `description` = '文章列表模板文件' , `is_public` = 0 , `list_order` = 8030 WHERE `theme` = 'simpleboot3' AND `file` = 'portal/list_development_salary' [ RunTime:0.000582s ]
- [ SQL ] SELECT * FROM `cmf_theme_file` WHERE `theme` = 'simpleboot3' AND `file` = 'portal/list_development_training' LIMIT 1 [ RunTime:0.000510s ]
- [ 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' => 89,
'filtered' => 1.1235954761505127,
'extra' => 'Using where',
) ]
- [ SQL ] UPDATE `cmf_theme_file` SET `theme` = 'simpleboot3' , `action` = 'portal/List/index' , `file` = 'portal/list_development_training' , `name` = '人力资源>教育培训' , `more` = '[]' , `config_more` = '[]' , `description` = '文章列表模板文件' , `is_public` = 0 , `list_order` = 8040 WHERE `theme` = 'simpleboot3' AND `file` = 'portal/list_development_training' [ RunTime:0.000674s ]
- [ SQL ] SELECT * FROM `cmf_theme_file` WHERE `theme` = 'simpleboot3' AND `file` = 'portal/list_news' LIMIT 1 [ RunTime:0.000521s ]
- [ 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' => 89,
'filtered' => 1.1235954761505127,
'extra' => 'Using where',
) ]
- [ SQL ] UPDATE `cmf_theme_file` SET `theme` = 'simpleboot3' , `action` = 'portal/List/index' , `file` = 'portal/list_news' , `name` = '新闻中心(聚合页)' , `more` = '[]' , `config_more` = '[]' , `description` = '文章列表模板文件' , `is_public` = 0 , `list_order` = 3000 WHERE `theme` = 'simpleboot3' AND `file` = 'portal/list_news' [ RunTime:0.000702s ]
- [ SQL ] SELECT * FROM `cmf_theme_file` WHERE `theme` = 'simpleboot3' AND `file` = 'portal/list_news_article' LIMIT 1 [ RunTime:0.000472s ]
- [ 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' => 89,
'filtered' => 1.1235954761505127,
'extra' => 'Using where',
) ]
- [ SQL ] UPDATE `cmf_theme_file` SET `theme` = 'simpleboot3' , `action` = 'portal/List/index' , `file` = 'portal/list_news_article' , `name` = '新闻中心>通用列表' , `more` = '[]' , `config_more` = '[]' , `description` = '文章列表模板文件' , `is_public` = 0 , `list_order` = 3010 WHERE `theme` = 'simpleboot3' AND `file` = 'portal/list_news_article' [ RunTime:0.000587s ]
- [ SQL ] SELECT * FROM `cmf_theme_file` WHERE `theme` = 'simpleboot3' AND `file` = 'portal/list_news_magazine' LIMIT 1 [ RunTime:0.000458s ]
- [ 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' => 89,
'filtered' => 1.1235954761505127,
'extra' => 'Using where',
) ]
- [ SQL ] UPDATE `cmf_theme_file` SET `theme` = 'simpleboot3' , `action` = 'portal/List/index' , `file` = 'portal/list_news_magazine' , `name` = '新闻中心>企业内刊' , `more` = '[]' , `config_more` = '[]' , `description` = '文章列表模板文件' , `is_public` = 0 , `list_order` = 3020 WHERE `theme` = 'simpleboot3' AND `file` = 'portal/list_news_magazine' [ RunTime:0.000601s ]
- [ SQL ] SELECT * FROM `cmf_theme_file` WHERE `theme` = 'simpleboot3' AND `file` = 'portal/list_party_article' LIMIT 1 [ RunTime:0.000486s ]
- [ 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' => 89,
'filtered' => 1.1235954761505127,
'extra' => 'Using where',
) ]
- [ SQL ] UPDATE `cmf_theme_file` SET `theme` = 'simpleboot3' , `action` = 'portal/List/index' , `file` = 'portal/list_party_article' , `name` = '党群建设>通用列表' , `more` = '[]' , `config_more` = '[]' , `description` = '文章列表模板文件' , `is_public` = 0 , `list_order` = 4010 WHERE `theme` = 'simpleboot3' AND `file` = 'portal/list_party_article' [ RunTime:0.000676s ]
- [ SQL ] SELECT * FROM `cmf_theme_file` WHERE `theme` = 'simpleboot3' AND `file` = 'portal/list_project_achievements' LIMIT 1 [ RunTime:0.000509s ]
- [ 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' => 89,
'filtered' => 1.1235954761505127,
'extra' => 'Using where',
) ]
- [ SQL ] UPDATE `cmf_theme_file` SET `theme` = 'simpleboot3' , `action` = 'portal/List/index' , `file` = 'portal/list_project_achievements' , `name` = '工程业绩>业绩表' , `more` = '[]' , `config_more` = '[]' , `description` = '文章列表模板文件' , `is_public` = 0 , `list_order` = 5030 WHERE `theme` = 'simpleboot3' AND `file` = 'portal/list_project_achievements' [ RunTime:0.000670s ]
- [ SQL ] SELECT * FROM `cmf_theme_file` WHERE `theme` = 'simpleboot3' AND `file` = 'portal/list_project_case_article' LIMIT 1 [ RunTime:0.000500s ]
- [ 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' => 89,
'filtered' => 1.1235954761505127,
'extra' => 'Using where',
) ]
- [ SQL ] UPDATE `cmf_theme_file` SET `theme` = 'simpleboot3' , `action` = 'portal/List/index' , `file` = 'portal/list_project_case_article' , `name` = '工程业绩>工程案例>通用列表' , `more` = '[]' , `config_more` = '[]' , `description` = '文章列表模板文件' , `is_public` = 0 , `list_order` = 5020 WHERE `theme` = 'simpleboot3' AND `file` = 'portal/list_project_case_article' [ RunTime:0.000619s ]
- [ SQL ] SELECT * FROM `cmf_theme_file` WHERE `theme` = 'simpleboot3' AND `file` = 'portal/list_project_recommend' LIMIT 1 [ RunTime:0.000467s ]
- [ 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' => 89,
'filtered' => 1.1235954761505127,
'extra' => 'Using where',
) ]
- [ SQL ] UPDATE `cmf_theme_file` SET `theme` = 'simpleboot3' , `action` = 'portal/List/index' , `file` = 'portal/list_project_recommend' , `name` = '工程业绩>典型工程案例' , `more` = '[]' , `config_more` = '[]' , `description` = '文章列表模板文件' , `is_public` = 0 , `list_order` = 5010 WHERE `theme` = 'simpleboot3' AND `file` = 'portal/list_project_recommend' [ RunTime:0.000662s ]
- [ SQL ] SELECT * FROM `cmf_theme_file` WHERE `theme` = 'simpleboot3' AND `file` = 'portal/list_technology_page' LIMIT 1 [ RunTime:0.000478s ]
- [ 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' => 89,
'filtered' => 1.1235954761505127,
'extra' => 'Using where',
) ]
- [ SQL ] UPDATE `cmf_theme_file` SET `theme` = 'simpleboot3' , `action` = 'portal/List/index' , `file` = 'portal/list_technology_page' , `name` = '技术研发>专利技术&标准规范' , `more` = '[]' , `config_more` = '[]' , `description` = '文章列表模板文件' , `is_public` = 0 , `list_order` = 6030 WHERE `theme` = 'simpleboot3' AND `file` = 'portal/list_technology_page' [ RunTime:0.000659s ]
- [ SQL ] SELECT * FROM `cmf_theme_file` WHERE `theme` = 'simpleboot3' AND `file` = 'portal/list_technology_platform' LIMIT 1 [ RunTime:0.000492s ]
- [ 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' => 89,
'filtered' => 1.1235954761505127,
'extra' => 'Using where',
) ]
- [ SQL ] UPDATE `cmf_theme_file` SET `theme` = 'simpleboot3' , `action` = 'portal/List/index' , `file` = 'portal/list_technology_platform' , `name` = '技术研发>研发平台' , `more` = '[]' , `config_more` = '[]' , `description` = '文章列表模板文件' , `is_public` = 0 , `list_order` = 6020 WHERE `theme` = 'simpleboot3' AND `file` = 'portal/list_technology_platform' [ RunTime:0.000592s ]
- [ SQL ] SELECT * FROM `cmf_theme_file` WHERE `theme` = 'simpleboot3' AND `file` = 'portal/list_technology_team' LIMIT 1 [ RunTime:0.000477s ]
- [ 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' => 89,
'filtered' => 1.1235954761505127,
'extra' => 'Using where',
) ]
- [ SQL ] UPDATE `cmf_theme_file` SET `theme` = 'simpleboot3' , `action` = 'portal/List/index' , `file` = 'portal/list_technology_team' , `name` = '技术研发>研发团队' , `more` = '[]' , `config_more` = '[]' , `description` = '文章列表模板文件' , `is_public` = 0 , `list_order` = 6010 WHERE `theme` = 'simpleboot3' AND `file` = 'portal/list_technology_team' [ RunTime:0.000558s ]
- [ SQL ] SELECT * FROM `cmf_theme_file` WHERE `theme` = 'simpleboot3' [ RunTime:0.000583s ]
- [ 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' => 89,
'filtered' => 10.000000953674316,
'extra' => 'Using where',
) ]
- [ SQL ] SHOW COLUMNS FROM `cmf_theme` [ RunTime:0.002271s ]
- [ SQL ] UPDATE `cmf_theme` SET `name` = 'simpleboot3' , `version` = '1.0.2' , `demo_url` = 'http://demo.thinkcmf.com' , `author` = 'ThinkCMF' , `lang` = 'zh-cn' , `author_url` = 'http://www.thinkcmf.com' , `keywords` = 'ThinkCMF模板' , `description` = 'ThinkCMF默认模板' WHERE `theme` = 'simpleboot3' [ RunTime:0.000761s ]
- [ SQL ] SELECT `more` FROM `cmf_theme_file` WHERE `theme` = 'simpleboot3' AND ( `is_public` = 1 OR `file` = 'portal/list_news_magazine' ) [ RunTime:0.000498s ]
- [ 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' => 89,
'filtered' => 1.899999976158142,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT * FROM `cmf_portal_category` WHERE `id` = 39 LIMIT 1 [ RunTime:0.000637s ]
- [ 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.0,
'extra' => NULL,
) ]
- [ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 2 ORDER BY `list_order` ASC,`id` ASC LIMIT 99 [ RunTime:0.000980s ]
- [ 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' => 72,
'filtered' => 1.388888955116272,
'extra' => 'Using where; Using filesort',
) ]
- [ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 3 ORDER BY `list_order` ASC,`id` ASC LIMIT 99 [ RunTime:0.000882s ]
- [ 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' => 72,
'filtered' => 1.388888955116272,
'extra' => 'Using where; Using filesort',
) ]
- [ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 4 ORDER BY `list_order` ASC,`id` ASC LIMIT 99 [ RunTime:0.000900s ]
- [ 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' => 72,
'filtered' => 1.388888955116272,
'extra' => 'Using where; Using filesort',
) ]
- [ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 5 ORDER BY `list_order` ASC,`id` ASC LIMIT 99 [ RunTime:0.000923s ]
- [ 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' => 72,
'filtered' => 1.388888955116272,
'extra' => 'Using where; Using filesort',
) ]
- [ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 6 ORDER BY `list_order` ASC,`id` ASC LIMIT 99 [ RunTime:0.000977s ]
- [ 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' => 72,
'filtered' => 1.388888955116272,
'extra' => 'Using where; Using filesort',
) ]
- [ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 7 ORDER BY `list_order` ASC,`id` ASC LIMIT 99 [ RunTime:0.000937s ]
- [ 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' => 72,
'filtered' => 1.388888955116272,
'extra' => 'Using where; Using filesort',
) ]
- [ SQL ] SHOW COLUMNS FROM `cmf_portal_post` [ RunTime:0.002368s ]
- [ 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 ( `category_post`.`category_id` = '60' ) AND ( `post`.`published_time` > 0 and `post`.`published_time` < 1669839326 ) GROUP BY `post`.`id` ORDER BY `list_order` ASC,`published_time` DESC,`id` ASC LIMIT 1 [ RunTime:0.001152s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'category_post',
'partitions' => NULL,
'type' => 'ref',
'possible_keys' => 'term_taxonomy_id',
'key' => 'term_taxonomy_id',
'key_len' => '8',
'ref' => 'const',
'rows' => 1,
'filtered' => 100.0,
'extra' => 'Using temporary; Using filesort',
) ]
- [ 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 ( `category_post`.`category_id` = '61' ) AND ( `post`.`published_time` > 0 and `post`.`published_time` < 1669839326 ) GROUP BY `post`.`id` ORDER BY `list_order` ASC,`published_time` DESC,`id` ASC LIMIT 1 [ RunTime:0.001035s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'category_post',
'partitions' => NULL,
'type' => 'ref',
'possible_keys' => 'term_taxonomy_id',
'key' => 'term_taxonomy_id',
'key_len' => '8',
'ref' => 'const',
'rows' => 1,
'filtered' => 100.0,
'extra' => 'Using temporary; Using filesort',
) ]
- [ 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 ( `category_post`.`category_id` = '62' ) AND ( `post`.`published_time` > 0 and `post`.`published_time` < 1669839326 ) GROUP BY `post`.`id` ORDER BY `list_order` ASC,`published_time` DESC,`id` ASC LIMIT 1 [ RunTime:0.000929s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'category_post',
'partitions' => NULL,
'type' => 'ref',
'possible_keys' => 'term_taxonomy_id',
'key' => 'term_taxonomy_id',
'key_len' => '8',
'ref' => 'const',
'rows' => 1,
'filtered' => 100.0,
'extra' => 'Using temporary; Using filesort',
) ]
- [ 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 ( `category_post`.`category_id` = '63' ) AND ( `post`.`published_time` > 0 and `post`.`published_time` < 1669839326 ) GROUP BY `post`.`id` ORDER BY `list_order` ASC,`published_time` DESC,`id` ASC LIMIT 1 [ RunTime:0.000823s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'category_post',
'partitions' => NULL,
'type' => 'ref',
'possible_keys' => 'term_taxonomy_id',
'key' => 'term_taxonomy_id',
'key_len' => '8',
'ref' => 'const',
'rows' => 1,
'filtered' => 100.0,
'extra' => 'Using temporary; Using filesort',
) ]
- [ 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 ( `category_post`.`category_id` = '64' ) AND ( `post`.`published_time` > 0 and `post`.`published_time` < 1669839326 ) GROUP BY `post`.`id` ORDER BY `list_order` ASC,`published_time` DESC,`id` ASC LIMIT 1 [ RunTime:0.001063s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'category_post',
'partitions' => NULL,
'type' => 'ref',
'possible_keys' => 'term_taxonomy_id',
'key' => 'term_taxonomy_id',
'key_len' => '8',
'ref' => 'const',
'rows' => 1,
'filtered' => 100.0,
'extra' => 'Using temporary; Using filesort',
) ]
- [ 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 ( `category_post`.`category_id` = '72' ) AND ( `post`.`published_time` > 0 and `post`.`published_time` < 1669839326 ) GROUP BY `post`.`id` ORDER BY `list_order` ASC,`published_time` DESC,`id` ASC LIMIT 1 [ RunTime:0.000989s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'category_post',
'partitions' => NULL,
'type' => 'ref',
'possible_keys' => 'term_taxonomy_id',
'key' => 'term_taxonomy_id',
'key_len' => '8',
'ref' => 'const',
'rows' => 1,
'filtered' => 100.0,
'extra' => 'Using temporary; Using filesort',
) ]
- [ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 8 ORDER BY `list_order` ASC,`id` ASC LIMIT 99 [ RunTime:0.000910s ]
- [ 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' => 72,
'filtered' => 1.388888955116272,
'extra' => 'Using where; Using filesort',
) ]
- [ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `id` = 3 LIMIT 1 [ RunTime:0.000661s ]
- [ 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.0,
'extra' => NULL,
) ]
- [ SQL ] SHOW COLUMNS FROM `cmf_option` [ RunTime:0.002049s ]
- [ SQL ] SELECT `option_value` FROM `cmf_option` WHERE `option_name` = 'storage' LIMIT 1 [ RunTime:0.000675s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => NULL,
'partitions' => NULL,
'type' => NULL,
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => NULL,
'filtered' => NULL,
'extra' => 'no matching row in const table',
) ]
- [ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 3 ORDER BY `list_order` ASC,`id` ASC LIMIT 99 [ RunTime:0.000994s ]
- [ 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' => 72,
'filtered' => 1.388888955116272,
'extra' => 'Using where; Using filesort',
) ]
- [ 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 ( `category_post`.`category_id` = '39' ) AND ( `post`.`published_time` > 0 and `post`.`published_time` < 1669839326 ) GROUP BY `post`.`id` ) `_group_count_` [ RunTime:0.001023s ]
- [ 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.0,
'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 ( `category_post`.`category_id` = '39' ) AND ( `post`.`published_time` > 0 and `post`.`published_time` < 1669839326 ) GROUP BY `post`.`id` ORDER BY `list_order` ASC,`published_time` DESC,`id` ASC LIMIT 48,12 [ RunTime:0.001463s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'category_post',
'partitions' => NULL,
'type' => 'ref',
'possible_keys' => 'term_taxonomy_id',
'key' => 'term_taxonomy_id',
'key_len' => '8',
'ref' => 'const',
'rows' => 53,
'filtered' => 100.0,
'extra' => 'Using temporary; Using filesort',
) ]
- [ 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 ( `category_post`.`category_id` = '18' ) AND ( `post`.`published_time` > 0 and `post`.`published_time` < 1669839326 ) GROUP BY `post`.`id` ORDER BY `list_order` ASC,`post`.`published_time` DESC LIMIT 12 [ RunTime:0.000918s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'category_post',
'partitions' => NULL,
'type' => 'ref',
'possible_keys' => 'term_taxonomy_id',
'key' => 'term_taxonomy_id',
'key_len' => '8',
'ref' => 'const',
'rows' => 3,
'filtered' => 100.0,
'extra' => 'Using temporary; Using filesort',
) ]
- [ 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 ( `category_post`.`category_id` = '19' ) AND ( `post`.`published_time` > 0 and `post`.`published_time` < 1669839326 ) GROUP BY `post`.`id` ORDER BY `list_order` ASC,`post`.`published_time` DESC LIMIT 12 [ RunTime:0.000964s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'category_post',
'partitions' => NULL,
'type' => 'ref',
'possible_keys' => 'term_taxonomy_id',
'key' => 'term_taxonomy_id',
'key_len' => '8',
'ref' => 'const',
'rows' => 3,
'filtered' => 100.0,
'extra' => 'Using temporary; Using filesort',
) ]
- [ 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 ( `category_post`.`category_id` = '15' ) AND ( `post`.`published_time` > 0 and `post`.`published_time` < 1669839326 ) GROUP BY `post`.`id` ORDER BY `post`.`published_time` DESC LIMIT 1 [ RunTime:0.000843s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'category_post',
'partitions' => NULL,
'type' => 'ref',
'possible_keys' => 'term_taxonomy_id',
'key' => 'term_taxonomy_id',
'key_len' => '8',
'ref' => 'const',
'rows' => 1,
'filtered' => 100.0,
'extra' => 'Using temporary; Using filesort',
) ]
0.371081s
