广州某厂土壤及地下水修复工程
广东省首例"水土共治"的修复工程
基本
文件
流程
错误
SQL
调试
- 请求信息 : 2023-12-01 03:29:27 HTTP/1.1 GET : http://punctuationmadesimple.org/project_case_environment/1364.html
- 运行时间 : 0.406221s [ 吞吐率：2.46req/s ] 内存消耗：5,708.39kb 文件加载：116
- 查询信息 : 89 queries 49 writes
- 缓存信息 : 7 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' => 'project_case_environment/<id>',
'route' => 'portal/Article/index?cid=50',
'option' =>
array (
'merge_rule_regex' => false,
),
'var' =>
array (
'id' => '1364',
),
)
- [ HEADER ] array (
'content-type' => 'text/html',
'content-length' => '0',
'x-original-url' => '/project_case_environment/1364.html',
'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 (
'cid' => '50',
'id' => '1364',
)
- [ 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\detail_project_case_article.html [ array (
0 => 'site_info',
1 => 'category',
2 => 'article',
3 => 'prev_article',
4 => 'next_article',
5 => 'theme_vars',
6 => 'theme_widgets',
) ]
- [ DB ] CONNECT:[ UseTime:0.013405s ] mysql:host=172.16.0.90;port=3306;dbname=ccepc;charset=utf8
- [ SQL ] SHOW COLUMNS FROM `cmf_plugin` [ RunTime:0.003688s ]
- [ SQL ] SELECT `config` FROM `cmf_plugin` WHERE `name` = 'TcSwitchTheme' LIMIT 1 [ RunTime:0.000707s ]
- [ 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.001865s ]
- [ SQL ] SELECT * FROM `cmf_blacklist` WHERE `ip` = '154.203.5.89' LIMIT 1 [ RunTime:0.000686s ]
- [ 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_post` [ RunTime:0.002766s ]
- [ SQL ] SELECT `post`.* FROM `cmf_portal_post` `post` INNER JOIN `cmf_portal_category_post` `relation` ON `post`.`id`=`relation`.`post_id` WHERE `post`.`post_type` = 1 AND `post`.`post_status` = 1 AND `post`.`delete_time` = 0 AND `relation`.`category_id` = 50 AND `relation`.`post_id` = 1364 AND ( `post`.`published_time` < 1669836567 and `post`.`published_time` > 0 ) LIMIT 1 [ RunTime:0.001150s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'post',
'partitions' => NULL,
'type' => 'const',
'possible_keys' => 'PRIMARY,type_status_date',
'key' => 'PRIMARY',
'key_len' => '8',
'ref' => 'const',
'rows' => 1,
'filtered' => 100.0,
'extra' => NULL,
) ]
- [ SQL ] SHOW COLUMNS FROM `cmf_portal_category_post` [ RunTime:0.001811s ]
- [ SQL ] SELECT `a`.`list_order`,`a`.`post_id`,`cmf_portal_post`.`published_time` FROM cmf_portal_category_post as a LEFT JOIN `cmf_portal_post` ON `a`.`post_id`=`cmf_portal_post`.`id` WHERE `a`.`post_id` = 1364 AND `a`.`status` = 1 AND `cmf_portal_post`.`post_status` = 1 AND `cmf_portal_post`.`delete_time` = 0 LIMIT 1 [ RunTime:0.002084s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_portal_post',
'partitions' => NULL,
'type' => 'const',
'possible_keys' => 'PRIMARY',
'key' => 'PRIMARY',
'key_len' => '8',
'ref' => 'const',
'rows' => 1,
'filtered' => 100.0,
'extra' => NULL,
) ]
- [ SQL ] SELECT `post`.*,`relation`.`list_order`,`relation`.`post_id` FROM `cmf_portal_post` `post` INNER JOIN `cmf_portal_category_post` `relation` ON `post`.`id`=`relation`.`post_id` WHERE `post`.`id` <> 1364 AND `post`.`post_type` = 1 AND `post`.`post_status` = 1 AND `post`.`delete_time` = 0 AND `relation`.`category_id` = 50 AND `published_time` >= 1527782468 AND `relation`.`list_order` = 10000 ORDER BY `relation`.`list_order` DESC,`published_time` ASC,`id` DESC LIMIT 1 [ RunTime:0.003134s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'relation',
'partitions' => NULL,
'type' => 'ref',
'possible_keys' => 'term_taxonomy_id',
'key' => 'term_taxonomy_id',
'key_len' => '8',
'ref' => 'const',
'rows' => 14,
'filtered' => 10.0,
'extra' => 'Using where; Using temporary; Using filesort',
) ]
- [ SQL ] SELECT `a`.`list_order`,`a`.`post_id`,`cmf_portal_post`.`published_time` FROM cmf_portal_category_post as a LEFT JOIN `cmf_portal_post` ON `a`.`post_id`=`cmf_portal_post`.`id` WHERE `a`.`post_id` = 1364 AND `a`.`status` = 1 AND `cmf_portal_post`.`post_status` = 1 AND `cmf_portal_post`.`delete_time` = 0 LIMIT 1 [ RunTime:0.001068s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_portal_post',
'partitions' => NULL,
'type' => 'const',
'possible_keys' => 'PRIMARY',
'key' => 'PRIMARY',
'key_len' => '8',
'ref' => 'const',
'rows' => 1,
'filtered' => 100.0,
'extra' => NULL,
) ]
- [ SQL ] SELECT `post`.*,`relation`.`list_order`,`relation`.`post_id` FROM `cmf_portal_post` `post` INNER JOIN `cmf_portal_category_post` `relation` ON `post`.`id`=`relation`.`post_id` WHERE `post`.`id` <> 1364 AND `post`.`post_type` = 1 AND `post`.`post_status` = 1 AND `post`.`delete_time` = 0 AND `relation`.`category_id` = 50 AND `published_time` <= 1527782468 AND `relation`.`list_order` = 10000 ORDER BY `relation`.`list_order` ASC,`published_time` DESC,`id` ASC LIMIT 1 [ RunTime:0.001238s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'relation',
'partitions' => NULL,
'type' => 'ref',
'possible_keys' => 'term_taxonomy_id',
'key' => 'term_taxonomy_id',
'key_len' => '8',
'ref' => 'const',
'rows' => 14,
'filtered' => 10.0,
'extra' => 'Using where; Using temporary; Using filesort',
) ]
- [ SQL ] SHOW COLUMNS FROM `cmf_portal_category` [ RunTime:0.002117s ]
- [ SQL ] SELECT * FROM `cmf_portal_category` WHERE `id` = 50 AND `status` = 1 LIMIT 1 [ RunTime:0.000854s ]
- [ 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 ] UPDATE `cmf_portal_post` SET `post_hits` = `post_hits` + 1 WHERE `id` = 1364 [ RunTime:0.003026s ]
- [ SQL ] SHOW COLUMNS FROM `cmf_theme_file` [ RunTime:0.002507s ]
- [ SQL ] SELECT * FROM `cmf_theme_file` WHERE `theme` = 'simpleboot3' AND `file` = 'portal/datail_development_recruitment' LIMIT 1 [ RunTime:0.000824s ]
- [ 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.000712s ]
- [ SQL ] SELECT * FROM `cmf_theme_file` WHERE `theme` = 'simpleboot3' AND `file` = 'portal/detail_about_information_information' LIMIT 1 [ RunTime:0.000448s ]
- [ 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.000623s ]
- [ SQL ] SELECT * FROM `cmf_theme_file` WHERE `theme` = 'simpleboot3' AND `file` = 'portal/detail_branches_60' LIMIT 1 [ RunTime:0.000469s ]
- [ 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.000584s ]
- [ SQL ] SELECT * FROM `cmf_theme_file` WHERE `theme` = 'simpleboot3' AND `file` = 'portal/detail_branches_61' LIMIT 1 [ RunTime:0.000556s ]
- [ 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.000582s ]
- [ SQL ] SELECT * FROM `cmf_theme_file` WHERE `theme` = 'simpleboot3' AND `file` = 'portal/detail_branches_62' LIMIT 1 [ RunTime:0.000504s ]
- [ 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.000554s ]
- [ SQL ] SELECT * FROM `cmf_theme_file` WHERE `theme` = 'simpleboot3' AND `file` = 'portal/detail_branches_63' LIMIT 1 [ RunTime:0.000488s ]
- [ 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.000559s ]
- [ SQL ] SELECT * FROM `cmf_theme_file` WHERE `theme` = 'simpleboot3' AND `file` = 'portal/detail_branches_64' LIMIT 1 [ RunTime:0.000569s ]
- [ 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.000622s ]
- [ SQL ] SELECT * FROM `cmf_theme_file` WHERE `theme` = 'simpleboot3' AND `file` = 'portal/detail_branches_65' 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/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.000608s ]
- [ SQL ] SELECT * FROM `cmf_theme_file` WHERE `theme` = 'simpleboot3' AND `file` = 'portal/detail_development_join_declare' 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/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.000583s ]
- [ SQL ] SELECT * FROM `cmf_theme_file` WHERE `theme` = 'simpleboot3' AND `file` = 'portal/detail_development_join_statement' 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_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.000611s ]
- [ SQL ] SELECT * FROM `cmf_theme_file` WHERE `theme` = 'simpleboot3' AND `file` = 'portal/detail_news_article' LIMIT 1 [ RunTime:0.000493s ]
- [ 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.000659s ]
- [ SQL ] SELECT * FROM `cmf_theme_file` WHERE `theme` = 'simpleboot3' AND `file` = 'portal/detail_news_magazine' LIMIT 1 [ RunTime:0.000425s ]
- [ 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.000539s ]
- [ SQL ] SELECT * FROM `cmf_theme_file` WHERE `theme` = 'simpleboot3' AND `file` = 'portal/detail_party_article' LIMIT 1 [ RunTime:0.000413s ]
- [ 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.000535s ]
- [ SQL ] SELECT * FROM `cmf_theme_file` WHERE `theme` = 'simpleboot3' AND `file` = 'portal/detail_project_achievements' LIMIT 1 [ RunTime:0.000551s ]
- [ 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.000727s ]
- [ SQL ] SELECT * FROM `cmf_theme_file` WHERE `theme` = 'simpleboot3' AND `file` = 'portal/detail_project_case_article' 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_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.000727s ]
- [ SQL ] SELECT * FROM `cmf_theme_file` WHERE `theme` = 'simpleboot3' AND `file` = 'portal/detail_technology_platform' 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_technology_platform' , `name` = '技术研发>研发平台' , `more` = '[]' , `config_more` = '[]' , `description` = '文章页模板文件' , `is_public` = 0 , `list_order` = 6020 WHERE `theme` = 'simpleboot3' AND `file` = 'portal/detail_technology_platform' [ RunTime:0.000624s ]
- [ SQL ] SELECT * FROM `cmf_theme_file` WHERE `theme` = 'simpleboot3' AND `file` = 'portal/list_about' LIMIT 1 [ RunTime:0.000427s ]
- [ 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.000558s ]
- [ SQL ] SELECT * FROM `cmf_theme_file` WHERE `theme` = 'simpleboot3' AND `file` = 'portal/list_about_chronicle' LIMIT 1 [ RunTime:0.000443s ]
- [ 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.000553s ]
- [ SQL ] SELECT * FROM `cmf_theme_file` WHERE `theme` = 'simpleboot3' AND `file` = 'portal/list_about_culture' LIMIT 1 [ RunTime:0.000474s ]
- [ 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.000542s ]
- [ SQL ] SELECT * FROM `cmf_theme_file` WHERE `theme` = 'simpleboot3' AND `file` = 'portal/list_about_form' LIMIT 1 [ RunTime:0.000432s ]
- [ 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.000544s ]
- [ SQL ] SELECT * FROM `cmf_theme_file` WHERE `theme` = 'simpleboot3' AND `file` = 'portal/list_about_honor' LIMIT 1 [ RunTime:0.000503s ]
- [ 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.000548s ]
- [ SQL ] SELECT * FROM `cmf_theme_file` WHERE `theme` = 'simpleboot3' AND `file` = 'portal/list_about_information' 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_information' , `name` = '公司概况>信息公开' , `more` = '[]' , `config_more` = '[]' , `description` = '文章列表模板文件' , `is_public` = 0 , `list_order` = 2090 WHERE `theme` = 'simpleboot3' AND `file` = 'portal/list_about_information' [ RunTime:0.000625s ]
- [ SQL ] SELECT * FROM `cmf_theme_file` WHERE `theme` = 'simpleboot3' AND `file` = 'portal/list_about_information_information' LIMIT 1 [ RunTime:0.000432s ]
- [ 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.000555s ]
- [ SQL ] SELECT * FROM `cmf_theme_file` WHERE `theme` = 'simpleboot3' AND `file` = 'portal/list_about_information_regulations' LIMIT 1 [ RunTime:0.000419s ]
- [ 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.000583s ]
- [ SQL ] SELECT * FROM `cmf_theme_file` WHERE `theme` = 'simpleboot3' AND `file` = 'portal/list_about_organization' LIMIT 1 [ RunTime:0.000503s ]
- [ 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.000578s ]
- [ SQL ] SELECT * FROM `cmf_theme_file` WHERE `theme` = 'simpleboot3' AND `file` = 'portal/list_about_profile' LIMIT 1 [ RunTime:0.000430s ]
- [ 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.000598s ]
- [ SQL ] SELECT * FROM `cmf_theme_file` WHERE `theme` = 'simpleboot3' AND `file` = 'portal/list_about_qualification' LIMIT 1 [ RunTime:0.000470s ]
- [ 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.000613s ]
- [ SQL ] SELECT * FROM `cmf_theme_file` WHERE `theme` = 'simpleboot3' AND `file` = 'portal/list_about_scope' LIMIT 1 [ RunTime:0.000454s ]
- [ 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.000684s ]
- [ SQL ] SELECT * FROM `cmf_theme_file` WHERE `theme` = 'simpleboot3' AND `file` = 'portal/list_branches' 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_branches' , `name` = '分子机构(聚合页)' , `more` = '[]' , `config_more` = '[]' , `description` = '文章列表模板文件' , `is_public` = 0 , `list_order` = 7000 WHERE `theme` = 'simpleboot3' AND `file` = 'portal/list_branches' [ RunTime:0.000563s ]
- [ SQL ] SELECT * FROM `cmf_theme_file` WHERE `theme` = 'simpleboot3' AND `file` = 'portal/list_category_next' LIMIT 1 [ RunTime:0.000422s ]
- [ 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.000576s ]
- [ SQL ] SELECT * FROM `cmf_theme_file` WHERE `theme` = 'simpleboot3' AND `file` = 'portal/list_category_prev' LIMIT 1 [ RunTime:0.000410s ]
- [ 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.000701s ]
- [ SQL ] SELECT * FROM `cmf_theme_file` WHERE `theme` = 'simpleboot3' AND `file` = 'portal/list_contact' 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/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.000615s ]
- [ SQL ] SELECT * FROM `cmf_theme_file` WHERE `theme` = 'simpleboot3' AND `file` = 'portal/list_development_join' 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_development_join' , `name` = '人力资源>人才招聘' , `more` = '[]' , `config_more` = '[]' , `description` = '文章列表模板文件' , `is_public` = 0 , `list_order` = 8020 WHERE `theme` = 'simpleboot3' AND `file` = 'portal/list_development_join' [ RunTime:0.000605s ]
- [ SQL ] SELECT * FROM `cmf_theme_file` WHERE `theme` = 'simpleboot3' AND `file` = 'portal/list_development_join_statement' 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_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.000564s ]
- [ SQL ] SELECT * FROM `cmf_theme_file` WHERE `theme` = 'simpleboot3' AND `file` = 'portal/list_development_profile' LIMIT 1 [ RunTime:0.000470s ]
- [ 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.000644s ]
- [ SQL ] SELECT * FROM `cmf_theme_file` WHERE `theme` = 'simpleboot3' AND `file` = 'portal/list_development_salary' LIMIT 1 [ RunTime:0.000573s ]
- [ 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.000566s ]
- [ SQL ] SELECT * FROM `cmf_theme_file` WHERE `theme` = 'simpleboot3' AND `file` = 'portal/list_development_training' LIMIT 1 [ RunTime:0.000536s ]
- [ 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.000696s ]
- [ SQL ] SELECT * FROM `cmf_theme_file` WHERE `theme` = 'simpleboot3' AND `file` = 'portal/list_news' 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_news' , `name` = '新闻中心(聚合页)' , `more` = '[]' , `config_more` = '[]' , `description` = '文章列表模板文件' , `is_public` = 0 , `list_order` = 3000 WHERE `theme` = 'simpleboot3' AND `file` = 'portal/list_news' [ RunTime:0.000550s ]
- [ SQL ] SELECT * FROM `cmf_theme_file` WHERE `theme` = 'simpleboot3' AND `file` = 'portal/list_news_article' LIMIT 1 [ RunTime:0.000439s ]
- [ 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.000557s ]
- [ SQL ] SELECT * FROM `cmf_theme_file` WHERE `theme` = 'simpleboot3' AND `file` = 'portal/list_news_magazine' LIMIT 1 [ RunTime:0.000435s ]
- [ 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.000636s ]
- [ SQL ] SELECT * FROM `cmf_theme_file` WHERE `theme` = 'simpleboot3' AND `file` = 'portal/list_party_article' 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_party_article' , `name` = '党群建设>通用列表' , `more` = '[]' , `config_more` = '[]' , `description` = '文章列表模板文件' , `is_public` = 0 , `list_order` = 4010 WHERE `theme` = 'simpleboot3' AND `file` = 'portal/list_party_article' [ RunTime:0.000609s ]
- [ SQL ] SELECT * FROM `cmf_theme_file` WHERE `theme` = 'simpleboot3' AND `file` = 'portal/list_project_achievements' LIMIT 1 [ RunTime:0.000639s ]
- [ 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.000571s ]
- [ SQL ] SELECT * FROM `cmf_theme_file` WHERE `theme` = 'simpleboot3' AND `file` = 'portal/list_project_case_article' LIMIT 1 [ RunTime:0.000539s ]
- [ 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.000559s ]
- [ SQL ] SELECT * FROM `cmf_theme_file` WHERE `theme` = 'simpleboot3' AND `file` = 'portal/list_project_recommend' LIMIT 1 [ RunTime:0.000430s ]
- [ 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.000598s ]
- [ SQL ] SELECT * FROM `cmf_theme_file` WHERE `theme` = 'simpleboot3' AND `file` = 'portal/list_technology_page' LIMIT 1 [ RunTime:0.000461s ]
- [ 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.000622s ]
- [ SQL ] SELECT * FROM `cmf_theme_file` WHERE `theme` = 'simpleboot3' AND `file` = 'portal/list_technology_platform' LIMIT 1 [ RunTime:0.000461s ]
- [ 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.000636s ]
- [ SQL ] SELECT * FROM `cmf_theme_file` WHERE `theme` = 'simpleboot3' AND `file` = 'portal/list_technology_team' 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_technology_team' , `name` = '技术研发>研发团队' , `more` = '[]' , `config_more` = '[]' , `description` = '文章列表模板文件' , `is_public` = 0 , `list_order` = 6010 WHERE `theme` = 'simpleboot3' AND `file` = 'portal/list_technology_team' [ RunTime:0.000608s ]
- [ SQL ] SELECT * FROM `cmf_theme_file` WHERE `theme` = 'simpleboot3' [ RunTime:0.000535s ]
- [ 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.002631s ]
- [ 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.000686s ]
- [ SQL ] SELECT `more` FROM `cmf_theme_file` WHERE `theme` = 'simpleboot3' AND ( `is_public` = 1 OR `file` = 'portal/detail_project_case_article' ) [ 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.899999976158142,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT * FROM `cmf_portal_category` WHERE `id` = 50 LIMIT 1 [ RunTime:0.000569s ]
- [ 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.001026s ]
- [ 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.000887s ]
- [ 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.000834s ]
- [ 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.000842s ]
- [ 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.000810s ]
- [ 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.000941s ]
- [ 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 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` < 1669836567 ) GROUP BY `post`.`id` ORDER BY `list_order` ASC,`published_time` DESC,`id` ASC LIMIT 1 [ RunTime:0.001167s ]
- [ 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` < 1669836567 ) GROUP BY `post`.`id` ORDER BY `list_order` ASC,`published_time` DESC,`id` ASC LIMIT 1 [ RunTime:0.000892s ]
- [ 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` < 1669836567 ) GROUP BY `post`.`id` ORDER BY `list_order` ASC,`published_time` DESC,`id` ASC LIMIT 1 [ RunTime:0.000856s ]
- [ 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` < 1669836567 ) GROUP BY `post`.`id` ORDER BY `list_order` ASC,`published_time` DESC,`id` ASC LIMIT 1 [ 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' => 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` < 1669836567 ) GROUP BY `post`.`id` ORDER BY `list_order` ASC,`published_time` DESC,`id` ASC LIMIT 1 [ RunTime:0.000905s ]
- [ 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` < 1669836567 ) GROUP BY `post`.`id` ORDER BY `list_order` ASC,`published_time` DESC,`id` ASC LIMIT 1 [ RunTime:0.000895s ]
- [ 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.000865s ]
- [ 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` = 5 LIMIT 1 [ RunTime:0.000649s ]
- [ 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.002010s ]
- [ SQL ] SELECT `option_value` FROM `cmf_option` WHERE `option_name` = 'storage' LIMIT 1 [ RunTime:0.000696s ]
- [ 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` = 5 ORDER BY `list_order` ASC,`id` ASC LIMIT 99 [ RunTime:0.000903s ]
- [ 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 `id` FROM `cmf_portal_category` WHERE ( `path` LIKE '%-43-%' AND `status` = 1 AND `delete_time` = 0 ) [ RunTime:0.000915s ]
- [ 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',
) ]
- [ SQL ] SELECT `id` FROM `cmf_portal_category` WHERE ( `path` LIKE '%-44-%' AND `status` = 1 AND `delete_time` = 0 ) [ RunTime:0.000672s ]
- [ 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',
) ]
- [ SQL ] SELECT `id` FROM `cmf_portal_category` WHERE ( `path` LIKE '%-45-%' AND `status` = 1 AND `delete_time` = 0 ) [ RunTime:0.000683s ]
- [ 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',
) ]
- [ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 44 ORDER BY `list_order` ASC,`id` ASC LIMIT 99 [ RunTime:0.000898s ]
- [ 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 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` < 1669836567 ) GROUP BY `post`.`id` ORDER BY `list_order` ASC,`post`.`published_time` DESC LIMIT 12 [ RunTime:0.001102s ]
- [ 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` < 1669836567 ) GROUP BY `post`.`id` ORDER BY `list_order` ASC,`post`.`published_time` DESC LIMIT 12 [ RunTime:0.000959s ]
- [ 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` < 1669836567 ) GROUP BY `post`.`id` ORDER BY `post`.`published_time` DESC LIMIT 1 [ RunTime:0.001036s ]
- [ 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.410835s
