基本
文件
流程
错误
SQL
调试
- 请求信息 : 2022-07-03 02:18:05 HTTP/1.1 GET : qiniu.chaofankeji.cn/list-17.html
- 运行时间 : 0.167898s [ 吞吐率：5.96req/s ] 内存消耗：9,734.66kb 文件加载：147
- 查询信息 : 20 queries 7 writes
- 缓存信息 : 0 reads,0 writes
- 配置加载 : 67
- [ CACHE ] INIT File
- [ BEHAVIOR ] Run cmf\behavior\InitHookBehavior @app_init [ RunTime:0.002326s ]
- [ LANG ] /data/www/chaofankeji/simplewind/thinkphp/lang/zh-cn.php
- [ ROUTE ] array (
'type' => 'module',
'module' =>
array (
0 => 'portal',
1 => 'List',
2 => 'index',
),
'convert' => false,
)
- [ HEADER ] array (
'host' => 'qiniu.chaofankeji.cn',
'via' => 'cn1310.l1, l2st4-5.l2',
'eagleeye-traceid' => '3ad8769b16567858855494811e',
'ali-cdn-real-port' => '59614',
'ali-cdn-real-ip' => '18.232.59.38',
'ali-swift-log-host' => 'www.chaofankeji.cn',
'ali-swift-stat-host' => 'www.chaofankeji.cn',
'x-forwarded-for' => '18.232.59.38',
'x-client-scheme' => 'https',
'user-agent' => 'CCBot/2.0 (https://commoncrawl.org/faq/)',
'accept' => 'text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8',
'accept-language' => 'en-US,en;q=0.5',
'if-modified-since' => 'Wed, 20 Oct 2021 01:38:51 GMT',
'accept-encoding' => 'br,gzip',
'ali-cdn-appview-name' => 'cdn-tengine',
'ali-swift-origin-host' => 'qiniu.chaofankeji.cn',
'x-alicdn-da-via' => '58.216.118.230,113.96.58.121',
)
- [ PARAM ] array (
'id' => '17',
'tag' => '',
)
- [ LANG ] /data/www/chaofankeji/simplewind/cmf/behavior/../lang/zh-cn.php
- [ LANG ] /data/www/chaofankeji/public/../app/admin/lang/zh-cn/common.php
- [ LANG ] /data/www/chaofankeji/public/../app/portal/lang/zh-cn/common.php
- [ BEHAVIOR ] Run cmf\behavior\LangBehavior @app_begin [ RunTime:0.001299s ]
- [ LANG ] /data/www/chaofankeji/public/../app/portal/lang/zh-cn.php
- [ BEHAVIOR ] Run cmf\behavior\InitAppHookBehavior @module_init [ RunTime:0.000365s ]
- [ LANG ] /data/www/chaofankeji/public/../app/portal/lang/zh-cn/home.php
- [ BEHAVIOR ] Run cmf\behavior\HomeLangBehavior @home_init [ RunTime:0.000486s ]
- [ RUN ] app\portal\controller\ListController->index[ /data/www/chaofankeji/app/portal/controller/ListController.php ]
- [ DB ] INIT mysql
- [ VIEW ] /data/www/chaofankeji/public/themes/pc/portal/list_case.html [ array (
0 => 'site_info',
1 => 'category',
2 => 'categoryList',
3 => 'list',
4 => 'page',
5 => 'theme_vars',
6 => 'theme_widgets',
) ]
- [ DB ] CONNECT:[ UseTime:0.000347s ] mysql:host=localhost;port=3306;dbname=chaofankeji;charset=utf8mb4
- [ SQL ] SHOW COLUMNS FROM `cf_portal_category` [ RunTime:0.001799s ]
- [ SQL ] SELECT * FROM `cf_portal_category` WHERE `id` = 17 AND `status` = 1 LIMIT 1 [ RunTime:0.000276s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cf_portal_category',
'type' => 'const',
'possible_keys' => 'PRIMARY',
'key' => 'PRIMARY',
'key_len' => '8',
'ref' => 'const',
'rows' => 1,
'extra' => NULL,
) ]
- [ SQL ] SELECT `id`,`name` FROM `cf_portal_category` WHERE `delete_time` = 0 AND `status` = 1 AND `parent_id` = 3 [ RunTime:0.000218s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cf_portal_category',
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 29,
'extra' => 'Using where',
) ]
- [ SQL ] SHOW COLUMNS FROM `cf_portal_post` [ RunTime:0.001662s ]
- [ SQL ] SELECT COUNT(*) AS tp_count FROM ( SELECT count(*) FROM `cf_portal_post` `a` INNER JOIN `cf_portal_category_post` `b` ON `a`.`id`=`b`.`post_id` WHERE `a`.`post_status` = 1 AND `a`.`delete_time` = 0 AND ( `a`.`published_time` < '1656785885' AND `a`.`published_time` > '0' ) AND `b`.`category_id` = 17 GROUP BY `b`.`post_id` ) `_group_count_` LIMIT 1 [ RunTime:0.000609s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'PRIMARY',
'table' => '<derived2>',
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 4,
'extra' => NULL,
) ]
- [ SQL ] SELECT `a`.`id`,`a`.`post_keywords`,`a`.`post_title`,`a`.`thumbnail`,`a`.`more`,`a`.`post_excerpt`,`a`.`post_content`,`a`.`post_code`,`a`.`published_time`,`a`.`post_source`,`b`.`category_id` FROM `cf_portal_post` `a` INNER JOIN `cf_portal_category_post` `b` ON `a`.`id`=`b`.`post_id` WHERE `a`.`post_status` = 1 AND `a`.`delete_time` = 0 AND ( `a`.`published_time` < '1656785885' AND `a`.`published_time` > '0' ) AND `b`.`category_id` = 17 GROUP BY `b`.`post_id` ORDER BY `a`.`is_top` DESC,`b`.`list_order` DESC,`a`.`published_time` DESC LIMIT 0,12 [ RunTime:0.001261s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'b',
'type' => 'ref',
'possible_keys' => 'term_taxonomy_id',
'key' => 'term_taxonomy_id',
'key_len' => '8',
'ref' => 'const',
'rows' => 4,
'extra' => 'Using index condition; Using where; Using temporary; Using filesort',
) ]
- [ SQL ] SHOW COLUMNS FROM `cf_theme_file` [ RunTime:0.001517s ]
- [ SQL ] SELECT * FROM `cf_theme_file` WHERE `theme` = 'pc' AND `file` = 'portal/article' LIMIT 1 [ RunTime:0.000282s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cf_theme_file',
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 14,
'extra' => 'Using where',
) ]
- [ SQL ] UPDATE `cf_theme_file` SET `theme`='pc',`action`='portal/Article/index',`file`='portal/article',`name`='资讯详情页',`more`='[]',`config_more`='[]',`description`='资讯详情页模板文件',`is_public`=0,`list_order`=10 WHERE `theme` = 'pc' AND `file` = 'portal/article' [ RunTime:0.007303s ]
- [ SQL ] SELECT * FROM `cf_theme_file` WHERE `theme` = 'pc' AND `file` = 'portal/detail' LIMIT 1 [ RunTime:0.000272s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cf_theme_file',
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 14,
'extra' => 'Using where',
) ]
- [ SQL ] UPDATE `cf_theme_file` SET `theme`='pc',`action`='portal/Article/index',`file`='portal/detail',`name`='模板详情页',`more`='[]',`config_more`='[]',`description`='资讯详情页模板文件',`is_public`=0,`list_order`=10 WHERE `theme` = 'pc' AND `file` = 'portal/detail' [ RunTime:0.003524s ]
- [ SQL ] SELECT * FROM `cf_theme_file` WHERE `theme` = 'pc' AND `file` = 'portal/list' LIMIT 1 [ RunTime:0.000292s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cf_theme_file',
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 14,
'extra' => 'Using where',
) ]
- [ SQL ] UPDATE `cf_theme_file` SET `theme`='pc',`action`='portal/List/index',`file`='portal/list',`name`='资讯列表页',`more`='[]',`config_more`='[]',`description`='资讯列表模板文件',`is_public`=0,`list_order`=10 WHERE `theme` = 'pc' AND `file` = 'portal/list' [ RunTime:0.004471s ]
- [ SQL ] SELECT * FROM `cf_theme_file` WHERE `theme` = 'pc' AND `file` = 'portal/list_case' LIMIT 1 [ RunTime:0.000254s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cf_theme_file',
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 14,
'extra' => 'Using where',
) ]
- [ SQL ] UPDATE `cf_theme_file` SET `theme`='pc',`action`='portal/List/index',`file`='portal/list_case',`name`='案例列表页',`more`='[]',`config_more`='[]',`description`='资讯列表模板文件',`is_public`=0,`list_order`=10 WHERE `theme` = 'pc' AND `file` = 'portal/list_case' [ RunTime:0.003472s ]
- [ SQL ] SELECT * FROM `cf_theme_file` WHERE `theme` = 'pc' AND `file` = 'portal/list_program' LIMIT 1 [ RunTime:0.000250s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cf_theme_file',
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 14,
'extra' => 'Using where',
) ]
- [ SQL ] UPDATE `cf_theme_file` SET `theme`='pc',`action`='portal/List/index',`file`='portal/list_program',`name`='小程序列表页',`more`='[]',`config_more`='[]',`description`='资讯列表模板文件',`is_public`=0,`list_order`=10 WHERE `theme` = 'pc' AND `file` = 'portal/list_program' [ RunTime:0.002438s ]
- [ SQL ] SELECT * FROM `cf_theme_file` WHERE `theme` = 'pc' AND `file` = 'portal/list_template' LIMIT 1 [ RunTime:0.000220s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cf_theme_file',
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 14,
'extra' => 'Using where',
) ]
- [ SQL ] UPDATE `cf_theme_file` SET `theme`='pc',`action`='portal/List/index',`file`='portal/list_template',`name`='模板列表页',`more`='[]',`config_more`='[]',`description`='资讯列表模板文件',`is_public`=0,`list_order`=10 WHERE `theme` = 'pc' AND `file` = 'portal/list_template' [ RunTime:0.003248s ]
- [ SQL ] SELECT * FROM `cf_theme_file` WHERE `theme` = 'pc' [ RunTime:0.000236s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cf_theme_file',
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 14,
'extra' => 'Using where',
) ]
- [ SQL ] SHOW COLUMNS FROM `cf_theme` [ RunTime:0.001813s ]
- [ SQL ] UPDATE `cf_theme` SET `name`='pc',`version`='1.0.2',`demo_url`='',`author`='超凡',`lang`='zh-cn',`author_url`='超凡',`keywords`='超凡模板',`description`='超凡默认模板' WHERE `theme` = 'pc' [ RunTime:0.003369s ]
- [ SQL ] SELECT `more` FROM `cf_theme_file` WHERE `theme` = 'pc' AND ( `is_public` = 1 OR `file` = 'portal/list_case' ) [ RunTime:0.000240s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cf_theme_file',
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 14,
'extra' => 'Using where',
) ]
- [ SQL ] SHOW COLUMNS FROM `cf_nav_menu` [ RunTime:0.001849s ]
- [ SQL ] SELECT * FROM `cf_nav_menu` WHERE `nav_id` = 1 AND `status` = 1 ORDER BY `list_order` ASC [ RunTime:0.000300s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cf_nav_menu',
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 10,
'extra' => 'Using where; Using filesort',
) ]
- [ SQL ] SHOW COLUMNS FROM `cf_option` [ RunTime:0.001633s ]
- [ SQL ] SELECT `option_value` FROM `cf_option` WHERE `option_name` = 'storage' LIMIT 1 [ RunTime:0.000235s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => NULL,
'type' => NULL,
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => NULL,
'extra' => 'Impossible WHERE noticed after reading const tables',
) ]
0.175525s
