首頁廣西桂東電力股份有限公司

[ DB ] CONNECT:[ UseTime:0.012280s ] mysql:host=127.0.0.1;port=3306;dbname=guidian;charset=utf8mb4

[ SQL ] SHOW COLUMNS FROM `gd_portal_post` [ RunTime:0.002342s ]

[ SQL ] SELECT `post`.* FROM `gd_portal_post` `post` INNER JOIN `gd_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` = '4' AND `relation`.`post_id` = '1698' AND ( `post`.`published_time` < '1636378536' and `post`.`published_time` > '0' ) LIMIT 1 [ RunTime:0.001766s ]

[ 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 ] SELECT `post`.* FROM `gd_portal_post` `post` INNER JOIN `gd_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` = '4' AND `relation`.`post_id` < '1698' AND ( `post`.`published_time` < '1636378536' and `post`.`published_time` > '0' ) ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002390s ]

[ 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' => 41, 'filtered' => 33.32999801635742, 'extra' => 'Using index condition; Using where; Using temporary; Using filesort', ) ]

[ SQL ] SELECT `post`.* FROM `gd_portal_post` `post` INNER JOIN `gd_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` = '4' AND `relation`.`post_id` > '1698' AND ( `post`.`published_time` < '1636378536' and `post`.`published_time` > '0' ) ORDER BY `id` ASC LIMIT 1 [ RunTime:0.002527s ]

[ 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' => 41, 'filtered' => 33.32999801635742, 'extra' => 'Using index condition; Using where; Using temporary; Using filesort', ) ]

[ SQL ] SHOW COLUMNS FROM `gd_portal_category` [ RunTime:0.001687s ]

[ SQL ] SELECT * FROM `gd_portal_category` WHERE `id` = 4 AND `status` = 1 LIMIT 1 [ RunTime:0.001019s ]

[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'gd_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 `gd_portal_post` SET `post_hits`=`post_hits`+1 WHERE `id` = 1698 [ RunTime:0.024749s ]

[ SQL ] SELECT * FROM `gd_portal_category` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000997s ]

[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'gd_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 `gd_portal_category` WHERE `delete_time` = 0 ORDER BY `list_order` ASC [ RunTime:0.001833s ]

[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'gd_portal_category', 'partitions' => NULL, 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 73, 'filtered' => 10.0, 'extra' => 'Using where; Using filesort', ) ]

[ SQL ] SELECT * FROM `gd_portal_category` WHERE `id` = 1 LIMIT 1 [ RunTime:0.001047s ]

[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'gd_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 `gd_portal_category` WHERE `id` IN (0,1,4) [ RunTime:0.001146s ]

[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'gd_portal_category', 'partitions' => NULL, 'type' => 'range', 'possible_keys' => 'PRIMARY', 'key' => 'PRIMARY', 'key_len' => '8', 'ref' => NULL, 'rows' => 3, 'filtered' => 100.0, 'extra' => 'Using where', ) ]

[ SQL ] SELECT * FROM `gd_portal_category` WHERE `delete_time` = 0 AND `parent_id` = 4 ORDER BY `list_order` ASC [ RunTime:0.001171s ]

[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'gd_portal_category', 'partitions' => NULL, 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 73, 'filtered' => 1.3698630332946777, 'extra' => 'Using where; Using filesort', ) ]

[ SQL ] SHOW COLUMNS FROM `gd_theme_file` [ RunTime:0.001834s ]

[ SQL ] SELECT * FROM `gd_theme_file` WHERE `theme` = 'newdianli' AND `file` = 'portal/article' LIMIT 1 [ RunTime:0.001213s ]

[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'gd_theme_file', 'partitions' => NULL, 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 16, 'filtered' => 6.25, 'extra' => 'Using where', ) ]

[ SQL ] UPDATE `gd_theme_file` SET `theme`='newdianli',`action`='portal/Article/index',`file`='portal/article',`name`='文章頁',`more`='{\"vars\":{\"hot_articles_category_id\":{\"title\":\"Hot Articles\\u5206\\u7c7bID\",\"value\":\"1\",\"type\":\"text\",\"tip\":\"\",\"rule\":[]}}}',`config_more`='{\"vars\":{\"hot_articles_category_id\":{\"title\":\"Hot Articles\\u5206\\u7c7bID\",\"value\":\"1\",\"type\":\"text\",\"tip\":\"\",\"rule\":[]}}}',`description`='文章頁模板文件',`is_public`=0,`list_order`=10 WHERE `theme` = 'newdianli' AND `file` = 'portal/article' [ RunTime:0.025314s ]

[ SQL ] SELECT * FROM `gd_theme_file` WHERE `theme` = 'newdianli' AND `file` = 'portal/list' LIMIT 1 [ RunTime:0.001063s ]

[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'gd_theme_file', 'partitions' => NULL, 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 16, 'filtered' => 6.25, 'extra' => 'Using where', ) ]

[ SQL ] UPDATE `gd_theme_file` SET `theme`='newdianli',`action`='portal/List/index',`file`='portal/list',`name`='文章列表頁',`more`='{\"vars\":[],\"widgets\":{\"hottest_articles\":{\"title\":\"\\u70ed\\u95e8\\u6587\\u7ae0\",\"display\":\"1\",\"vars\":{\"hottest_articles_category_id\":{\"title\":\"\\u6587\\u7ae0\\u5206\\u7c7bID\",\"value\":\"\",\"type\":\"text\",\"dataSource\":{\"api\":\"portal\\/category\\/index\",\"multi\":true},\"placeholder\":\"\\u8bf7\\u9009\\u62e9\\u5206\\u7c7b\",\"tip\":\"\",\"rule\":{\"require\":true}}}},\"last_articles\":{\"title\":\"\\u6700\\u65b0\\u53d1\\u5e03\",\"display\":\"1\",\"vars\":{\"last_articles_category_id\":{\"title\":\"\\u6587\\u7ae0\\u5206\\u7c7bID\",\"value\":\"\",\"type\":\"text\",\"dataSource\":{\"api\":\"portal\\/category\\/index\",\"multi\":true},\"placeholder\":\"\\u8bf7\\u9009\\u62e9\\u5206\\u7c7b\",\"tip\":\"\",\"rule\":{\"require\":true}}}}}}',`config_more`='{\"vars\":[],\"widgets\":{\"hottest_articles\":{\"title\":\"\\u70ed\\u95e8\\u6587\\u7ae0\",\"display\":\"1\",\"vars\":{\"hottest_articles_category_id\":{\"title\":\"\\u6587\\u7ae0\\u5206\\u7c7bID\",\"value\":\"\",\"type\":\"text\",\"dataSource\":{\"api\":\"portal\\/category\\/index\",\"multi\":true},\"placeholder\":\"\\u8bf7\\u9009\\u62e9\\u5206\\u7c7b\",\"tip\":\"\",\"rule\":{\"require\":true}}}},\"last_articles\":{\"title\":\"\\u6700\\u65b0\\u53d1\\u5e03\",\"display\":\"1\",\"vars\":{\"last_articles_category_id\":{\"title\":\"\\u6587\\u7ae0\\u5206\\u7c7bID\",\"value\":\"\",\"type\":\"text\",\"dataSource\":{\"api\":\"portal\\/category\\/index\",\"multi\":true},\"placeholder\":\"\\u8bf7\\u9009\\u62e9\\u5206\\u7c7b\",\"tip\":\"\",\"rule\":{\"require\":true}}}}}}',`description`='文章列表模板文件',`is_public`=0,`list_order`=10 WHERE `theme` = 'newdianli' AND `file` = 'portal/list' [ RunTime:0.029789s ]

[ SQL ] SELECT * FROM `gd_theme_file` WHERE `theme` = 'newdianli' AND `file` = 'portal/list1' LIMIT 1 [ RunTime:0.001056s ]

[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'gd_theme_file', 'partitions' => NULL, 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 16, 'filtered' => 6.25, 'extra' => 'Using where', ) ]

[ SQL ] UPDATE `gd_theme_file` SET `theme`='newdianli',`action`='portal/List/index',`file`='portal/list1',`name`='附件列表頁',`more`='{\"vars\":[],\"widgets\":{\"hottest_articles\":{\"title\":\"\\u70ed\\u95e8\\u6587\\u7ae0\",\"display\":\"1\",\"vars\":{\"hottest_articles_category_id\":{\"title\":\"\\u6587\\u7ae0\\u5206\\u7c7bID\",\"value\":\"\",\"type\":\"text\",\"dataSource\":{\"api\":\"portal\\/category\\/index\",\"multi\":true},\"placeholder\":\"\\u8bf7\\u9009\\u62e9\\u5206\\u7c7b\",\"tip\":\"\",\"rule\":{\"require\":true}}}},\"last_articles\":{\"title\":\"\\u6700\\u65b0\\u53d1\\u5e03\",\"display\":\"1\",\"vars\":{\"last_articles_category_id\":{\"title\":\"\\u6587\\u7ae0\\u5206\\u7c7bID\",\"value\":\"\",\"type\":\"text\",\"dataSource\":{\"api\":\"portal\\/category\\/index\",\"multi\":true},\"placeholder\":\"\\u8bf7\\u9009\\u62e9\\u5206\\u7c7b\",\"tip\":\"\",\"rule\":{\"require\":true}}}}}}',`config_more`='{\"vars\":[],\"widgets\":{\"hottest_articles\":{\"title\":\"\\u70ed\\u95e8\\u6587\\u7ae0\",\"display\":\"1\",\"vars\":{\"hottest_articles_category_id\":{\"title\":\"\\u6587\\u7ae0\\u5206\\u7c7bID\",\"value\":\"\",\"type\":\"text\",\"dataSource\":{\"api\":\"portal\\/category\\/index\",\"multi\":true},\"placeholder\":\"\\u8bf7\\u9009\\u62e9\\u5206\\u7c7b\",\"tip\":\"\",\"rule\":{\"require\":true}}}},\"last_articles\":{\"title\":\"\\u6700\\u65b0\\u53d1\\u5e03\",\"display\":\"1\",\"vars\":{\"last_articles_category_id\":{\"title\":\"\\u6587\\u7ae0\\u5206\\u7c7bID\",\"value\":\"\",\"type\":\"text\",\"dataSource\":{\"api\":\"portal\\/category\\/index\",\"multi\":true},\"placeholder\":\"\\u8bf7\\u9009\\u62e9\\u5206\\u7c7b\",\"tip\":\"\",\"rule\":{\"require\":true}}}}}}',`description`='附件列表模板文件',`is_public`=0,`list_order`=10 WHERE `theme` = 'newdianli' AND `file` = 'portal/list1' [ RunTime:0.030487s ]

[ SQL ] SELECT * FROM `gd_theme_file` WHERE `theme` = 'newdianli' AND `file` = 'portal/zigongsi' LIMIT 1 [ RunTime:0.001077s ]

[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'gd_theme_file', 'partitions' => NULL, 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 16, 'filtered' => 6.25, 'extra' => 'Using where', ) ]

[ SQL ] UPDATE `gd_theme_file` SET `theme`='newdianli',`action`='portal/Article/index',`file`='portal/zigongsi',`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` = 'newdianli' AND `file` = 'portal/zigongsi' [ RunTime:0.028890s ]

[ SQL ] SELECT * FROM `gd_theme_file` WHERE `theme` = 'newdianli' [ RunTime:0.001205s ]

[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'gd_theme_file', 'partitions' => NULL, 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 16, 'filtered' => 10.0, 'extra' => 'Using where', ) ]

[ SQL ] SHOW COLUMNS FROM `gd_theme` [ RunTime:0.001998s ]

[ SQL ] UPDATE `gd_theme` SET `name`='dianli',`version`='1.0.2',`demo_url`='',`author`='dianli',`lang`='zh-cn',`author_url`='dianli',`keywords`='dianli',`description`='dianli' WHERE `theme` = 'newdianli' [ RunTime:0.027167s ]

[ SQL ] SELECT `more` FROM `gd_theme_file` WHERE `theme` = 'newdianli' AND ( `is_public` = 1 OR `file` = 'portal/article' ) [ RunTime:0.001134s ]

[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'gd_theme_file', 'partitions' => NULL, 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 16, 'filtered' => 6.25, 'extra' => 'Using where', ) ]

[ SQL ] SHOW COLUMNS FROM `gd_nav` [ RunTime:0.001932s ]

[ SQL ] SELECT `id` FROM `gd_nav` WHERE `is_main` = 1 LIMIT 1 [ RunTime:0.000854s ]

[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'gd_nav', '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 `gd_nav_menu` [ RunTime:0.001608s ]

[ SQL ] SELECT * FROM `gd_nav_menu` WHERE `nav_id` = 1 AND `status` = 1 ORDER BY `list_order` ASC [ RunTime:0.001137s ]

[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'gd_nav_menu', 'partitions' => NULL, 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 38, 'filtered' => 2.6315789222717285, 'extra' => 'Using where; Using filesort', ) ]

[ SQL ] SHOW COLUMNS FROM `gd_option` [ RunTime:0.001710s ]

[ SQL ] SELECT `option_value` FROM `gd_option` WHERE `option_name` = 'storage' LIMIT 1 [ RunTime:0.000830s ]

[ 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 `gd_link` [ RunTime:0.001692s ]

[ SQL ] SELECT * FROM `gd_link` WHERE `status` = 1 ORDER BY `list_order` ASC [ RunTime:0.001096s ]

[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'gd_link', 'partitions' => NULL, 'type' => 'ALL', 'possible_keys' => 'status', 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 7, 'filtered' => 100.0, 'extra' => 'Using where; Using filesort', ) ]

[ SQL ] SELECT * FROM `gd_nav_menu` WHERE `nav_id` = 2 AND `status` = 1 ORDER BY `list_order` ASC [ RunTime:0.001044s ]

[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'gd_nav_menu', 'partitions' => NULL, 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 38, 'filtered' => 2.6315789222717285, 'extra' => 'Using where; Using filesort', ) ]