基本
文件
流程
错误
SQL
调试
- 请求信息 : 2024-11-23 05:45:06 HTTP/1.1 GET : http://8.141.48.147/portal/list/index/id/8.html
- 运行时间 : 0.086385s [ 吞吐率：11.58req/s ] 内存消耗：6,276.15kb 文件加载：114
- 查询信息 : 31 queries 9 writes
- 缓存信息 : 26 reads,0 writes
- [ LANG ] /mnt/wwwroot/taonews/vendor/thinkphp/lang/zh-cn.php
- [ DB ] INIT mysql
- [ LANG ] /mnt/wwwroot/taonews/vendor/thinkcmf/cmf/src/behavior/../lang/zh-cn.php
- [ LANG ] /mnt/wwwroot/taonews/vendor/thinkcmf/cmf-app/src/admin/lang/zh-cn.php
- [ LANG ] /mnt/wwwroot/taonews/vendor/thinkcmf/cmf-app/src/admin/lang/zh-cn/common.php
- [ LANG ] /mnt/wwwroot/taonews/vendor/thinkcmf/cmf-app/src/user/lang/zh-cn.php
- [ LANG ] /mnt/wwwroot/taonews/app/portal/lang/zh-cn/common.php
- [ LANG ] /mnt/wwwroot/taonews/app/portal//lang/zh-cn.php
- [ ROUTE ] array (
)
- [ HEADER ] array (
'accept' => '*/*',
'user-agent' => 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)',
'accept-encoding' => 'gzip, br, zstd, deflate',
'host' => '8.141.48.147',
'content-type' => '',
'content-length' => '',
)
- [ PARAM ] array (
'id' => '8',
)
- [ LANG ] /mnt/wwwroot/taonews/app/portal/lang/zh-cn/home.php
- [ VIEW ] /mnt/wwwroot/taonews/public/themes/brisk/portal/list.html [ array (
0 => 'site_info',
1 => 'category',
2 => 'theme_vars',
3 => 'theme_widgets',
) ]
- [ DB ] CONNECT:[ UseTime:0.000325s ] mysql:host=127.0.0.1;port=3306;dbname=taonews_cn;charset=utf8mb4
- [ SQL ] SHOW COLUMNS FROM `cmf_hook` [ RunTime:0.000812s ]
- [ SQL ] SELECT `hook` FROM `cmf_hook` WHERE `type` = 1 OR ( `type` = 3 AND ( `app` = '' or `app` = 'cmf' ) ) [ RunTime:0.000382s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_hook',
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 71,
'extra' => 'Using where',
) ]
- [ SQL ] SHOW COLUMNS FROM `cmf_hook_plugin` [ RunTime:0.000660s ]
- [ SQL ] SELECT `hook`,`plugin` FROM `cmf_hook_plugin` WHERE `status` = 1 AND `hook` IN ('app_begin','module_init','action_begin','view_filter','app_end','log_write','response_end','admin_init','home_init','send_mobile_verification_code','body_start','before_head_end','footer_start','before_footer','before_footer_end','before_body_end','left_sidebar_start','before_left_sidebar_end','right_sidebar_start','before_right_sidebar_end','comment','guestbook','switch_theme','after_content','before_content','log_write_done','switch_admin_theme','captcha_image') ORDER BY `list_order` ASC [ RunTime:0.000398s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_hook_plugin',
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 1,
'extra' => 'Using where; Using filesort',
) ]
- [ SQL ] SHOW COLUMNS FROM `cmf_portal_category` [ RunTime:0.000736s ]
- [ SQL ] SELECT * FROM `cmf_portal_category` WHERE `id` = 8 AND `status` = 1 LIMIT 1 [ RunTime:0.000332s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_portal_category',
'type' => 'const',
'possible_keys' => 'PRIMARY',
'key' => 'PRIMARY',
'key_len' => '8',
'ref' => 'const',
'rows' => 1,
'extra' => NULL,
) ]
- [ SQL ] SHOW COLUMNS FROM `cmf_theme_file` [ RunTime:0.000611s ]
- [ SQL ] SELECT * FROM `cmf_theme_file` WHERE `theme` = 'brisk' AND `file` = 'portal/index' LIMIT 1 [ RunTime:0.000321s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_theme_file',
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 21,
'extra' => 'Using where',
) ]
- [ SQL ] UPDATE `cmf_theme_file` SET `theme` = 'brisk' , `action` = 'portal/Index/index' , `file` = 'portal/index' , `name` = '门户应用首页' , `more` = '{\"widgets\":{\"slider\":{\"title\":\"\\u9996\\u9875\\u9876\\u90e8\\u5185\\u5bb9\",\"name\":\"top_content\",\"display\":1,\"vars\":{\"slide_id\":{\"title\":\"\\u5e7b\\u706f\\u7247\",\"value\":\"1\",\"type\":\"text\",\"tip\":\"\\u8bf7\\u9009\\u62e9\\u5e7b\\u706f\\u7247\",\"dataSource\":{\"api\":\"admin\\/Slide\\/index\",\"multi\":false},\"rule\":{\"require\":true},\"message\":{\"require\":\"\\u4e0d\\u80fd\\u4e3a\\u7a7a\"},\"valueText\":\"\"}}},\"headline\":{\"title\":\"\\u4eca\\u65e5\\u5934\\u6761\",\"display\":1,\"vars\":{\"cat_ids\":{\"title\":\"\\u5934\\u6761\\u5206\\u7c7bid\",\"value\":\"1,2,3,4,5,6,7,8\",\"type\":\"text\",\"tip\":\"\\u8bf7\\u9009\\u62e9\\u5934\\u6761\\u65b0\\u95fb\\uff0c\\u6700\\u65b0\\u7f6e\\u9876\\u663e\\u793a\\u5728\\u6700\\u4e0a\\u65b9\\uff0c\\u5176\\u4f59\\u663e\\u793a\\u6700\\u65b0\\u6587\\u7ae0\",\"dataSource\":{\"api\":\"portal\\/Category\\/index\",\"multi\":true},\"valueText\":\"\\u5feb\\u8baf,\\u539f\\u521b,\\u65b0\\u80fd\\u6e90,\\u5927\\u5065\\u5eb7,\\u91d1\\u878d,\\u79d1\\u6280,\\u4e92\\u8054\\u7f51,\\u63a8\\u8350\"},\"list_num\":{\"title\":\"\\u5c55\\u793a\\u6570\\u91cf\",\"value\":\"4\",\"type\":\"number\",\"tip\":\"\\u9ed8\\u8ba4\\u5c55\\u793a4\\u4e2a\"}}},\"news\":{\"title\":\"\\u6700\\u65b0\\u53d1\\u5e03\",\"display\":1,\"vars\":{\"cat_ids\":{\"title\":\"\\u6587\\u7ae0\\u5206\\u7c7bid\",\"value\":\"1,2,3,4,5,6,7,8\",\"type\":\"text\",\"tip\":\"\\u8bf7\\u9009\\u5c55\\u793a\\u5728\\u9996\\u9875\\u4e0a\\u7684\\u6587\\u7ae0\\u5206\\u7c7b\\uff0c\\u652f\\u6301\\u591a\\u9009\\uff0c\\u6309\\u53d1\\u5e03\\u65f6\\u95f4\\u6392\\u5e8f\",\"dataSource\":{\"api\":\"portal\\/Category\\/index\",\"multi\":true},\"valueText\":\"\\u5feb\\u8baf,\\u539f\\u521b,\\u65b0\\u80fd\\u6e90,\\u5927\\u5065\\u5eb7,\\u91d1\\u878d,\\u79d1\\u6280,\\u4e92\\u8054\\u7f51,\\u63a8\\u8350\"},\"list_num\":{\"title\":\"\\u5c55\\u793a\\u6570\\u91cf\",\"value\":\"20\",\"type\":\"number\",\"tip\":\"\\u9ed8\\u8ba4\\u5c55\\u793a20\\u4e2a\"}}}}}' , `config_more` = '{\"widgets\":{\"slider\":{\"title\":\"\\u9996\\u9875\\u9876\\u90e8\\u5185\\u5bb9\",\"name\":\"top_content\",\"display\":\"1\",\"vars\":{\"slide_id\":{\"title\":\"\\u5e7b\\u706f\\u7247\",\"value\":\"1\",\"type\":\"text\",\"tip\":\"\\u8bf7\\u9009\\u62e9\\u5e7b\\u706f\\u7247\",\"dataSource\":{\"api\":\"admin\\/Slide\\/index\",\"multi\":false},\"rule\":{\"require\":true},\"message\":{\"require\":\"\\u4e0d\\u80fd\\u4e3a\\u7a7a\"}}}},\"headline\":{\"title\":\"\\u4eca\\u65e5\\u5934\\u6761\",\"display\":\"1\",\"vars\":{\"cat_ids\":{\"title\":\"\\u5934\\u6761\\u5206\\u7c7bid\",\"value\":\"\",\"type\":\"text\",\"tip\":\"\\u8bf7\\u9009\\u62e9\\u5934\\u6761\\u65b0\\u95fb\\uff0c\\u6700\\u65b0\\u7f6e\\u9876\\u663e\\u793a\\u5728\\u6700\\u4e0a\\u65b9\\uff0c\\u5176\\u4f59\\u663e\\u793a\\u6700\\u65b0\\u6587\\u7ae0\",\"dataSource\":{\"api\":\"portal\\/Category\\/index\",\"multi\":true}},\"list_num\":{\"title\":\"\\u5c55\\u793a\\u6570\\u91cf\",\"value\":\"4\",\"type\":\"number\",\"tip\":\"\\u9ed8\\u8ba4\\u5c55\\u793a4\\u4e2a\"}}},\"news\":{\"title\":\"\\u6700\\u65b0\\u53d1\\u5e03\",\"display\":\"1\",\"vars\":{\"cat_ids\":{\"title\":\"\\u6587\\u7ae0\\u5206\\u7c7bid\",\"value\":\"\",\"type\":\"text\",\"tip\":\"\\u8bf7\\u9009\\u5c55\\u793a\\u5728\\u9996\\u9875\\u4e0a\\u7684\\u6587\\u7ae0\\u5206\\u7c7b\\uff0c\\u652f\\u6301\\u591a\\u9009\\uff0c\\u6309\\u53d1\\u5e03\\u65f6\\u95f4\\u6392\\u5e8f\",\"dataSource\":{\"api\":\"portal\\/Category\\/index\",\"multi\":true}},\"list_num\":{\"title\":\"\\u5c55\\u793a\\u6570\\u91cf\",\"value\":20,\"type\":\"number\",\"tip\":\"\\u9ed8\\u8ba4\\u5c55\\u793a20\\u4e2a\"}}}}}' , `description` = '门户应用首页模板文件' , `is_public` = 0 , `list_order` = 4 WHERE `theme` = 'brisk' AND `file` = 'portal/index' [ RunTime:0.001063s ]
- [ SQL ] SELECT * FROM `cmf_theme_file` WHERE `theme` = 'brisk' AND `file` = 'portal/list' LIMIT 1 [ RunTime:0.000289s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_theme_file',
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 21,
'extra' => 'Using where',
) ]
- [ SQL ] UPDATE `cmf_theme_file` SET `theme` = 'brisk' , `action` = 'portal/List/index' , `file` = 'portal/list' , `name` = '普通列表页' , `more` = '{\"vars\":{\"bgimg\":{\"title\":\"\\u9876\\u90e8\\u80cc\\u666f\\u56fe\\u7247\",\"value\":\"\",\"type\":\"image\",\"tip\":\"\\u663e\\u793a\\u5728\\u5217\\u8868\\u9875\\u4ecb\\u7ecd\\u90e8\\u5206\\u7684\\u80cc\\u666f\\u56fe\\u7247\\uff0c\\u5efa\\u8bae\\u5bbd\\u5ea6\\u4e0d\\u5c0f\\u4e8e1920\\u50cf\\u7d20\"}},\"widgets\":{\"list\":{\"title\":\"\\u5217\\u8868\\u9875\\u5185\\u5bb9\",\"display\":\"1\",\"vars\":{\"list_num\":{\"title\":\"\\u6bcf\\u9875\\u6587\\u7ae0\\u6570\\u91cf\",\"value\":\"20\",\"type\":\"number\",\"tip\":\"\\u6700\\u65b0\\u6587\\u7ae0\\u5217\\u8868\\u663e\\u793a\\u6570\\u91cf\"},\"paging\":{\"title\":\"\\u662f\\u5426\\u5206\\u9875\",\"value\":\"1\",\"type\":\"select\",\"options\":[\"\\u4e0d\\u5206\\u9875\",\"\\u5206\\u9875\"]}}}}}' , `config_more` = '{\"vars\":{\"bgimg\":{\"title\":\"\\u9876\\u90e8\\u80cc\\u666f\\u56fe\\u7247\",\"value\":\"\",\"type\":\"image\",\"tip\":\"\\u663e\\u793a\\u5728\\u5217\\u8868\\u9875\\u4ecb\\u7ecd\\u90e8\\u5206\\u7684\\u80cc\\u666f\\u56fe\\u7247\\uff0c\\u5efa\\u8bae\\u5bbd\\u5ea6\\u4e0d\\u5c0f\\u4e8e1920\\u50cf\\u7d20\"}},\"widgets\":{\"list\":{\"title\":\"\\u5217\\u8868\\u9875\\u5185\\u5bb9\",\"display\":\"1\",\"vars\":{\"list_num\":{\"title\":\"\\u6bcf\\u9875\\u6587\\u7ae0\\u6570\\u91cf\",\"value\":\"20\",\"type\":\"number\",\"tip\":\"\\u6700\\u65b0\\u6587\\u7ae0\\u5217\\u8868\\u663e\\u793a\\u6570\\u91cf\"},\"paging\":{\"title\":\"\\u662f\\u5426\\u5206\\u9875\",\"value\":\"1\",\"type\":\"select\",\"options\":[\"\\u4e0d\\u5206\\u9875\",\"\\u5206\\u9875\"]}}}}}' , `description` = '普通单行列表模板文件' , `is_public` = 0 , `list_order` = 5 WHERE `theme` = 'brisk' AND `file` = 'portal/list' [ RunTime:0.000954s ]
- [ SQL ] SELECT * FROM `cmf_theme_file` WHERE `theme` = 'brisk' AND `file` = 'portal/list_sub' LIMIT 1 [ RunTime:0.000283s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_theme_file',
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 21,
'extra' => 'Using where',
) ]
- [ SQL ] UPDATE `cmf_theme_file` SET `theme` = 'brisk' , `action` = 'portal/List/index' , `file` = 'portal/list_sub' , `name` = '包含子分类列表页' , `more` = '{\"vars\":{\"bgimg\":{\"title\":\"\\u9876\\u90e8\\u80cc\\u666f\\u56fe\\u7247\",\"value\":\"\",\"type\":\"image\",\"tip\":\"\\u663e\\u793a\\u5728\\u5217\\u8868\\u9875\\u4ecb\\u7ecd\\u90e8\\u5206\\u7684\\u80cc\\u666f\\u56fe\\u7247\\uff0c\\u5efa\\u8bae\\u5bbd\\u5ea6\\u4e0d\\u5c0f\\u4e8e1920\\u50cf\\u7d20\"}},\"widgets\":{\"list\":{\"title\":\"\\u5217\\u8868\\u9875\\u5185\\u5bb9\",\"display\":\"1\",\"vars\":{\"list_num\":{\"title\":\"\\u6bcf\\u9875\\u6587\\u7ae0\\u6570\\u91cf\",\"value\":\"20\",\"type\":\"number\",\"tip\":\"\\u6700\\u65b0\\u6587\\u7ae0\\u5217\\u8868\\u663e\\u793a\\u6570\\u91cf\"},\"paging\":{\"title\":\"\\u662f\\u5426\\u5206\\u9875\",\"value\":\"1\",\"type\":\"select\",\"options\":[\"\\u4e0d\\u5206\\u9875\",\"\\u5206\\u9875\"]}}}}}' , `config_more` = '{\"vars\":{\"bgimg\":{\"title\":\"\\u9876\\u90e8\\u80cc\\u666f\\u56fe\\u7247\",\"value\":\"\",\"type\":\"image\",\"tip\":\"\\u663e\\u793a\\u5728\\u5217\\u8868\\u9875\\u4ecb\\u7ecd\\u90e8\\u5206\\u7684\\u80cc\\u666f\\u56fe\\u7247\\uff0c\\u5efa\\u8bae\\u5bbd\\u5ea6\\u4e0d\\u5c0f\\u4e8e1920\\u50cf\\u7d20\"}},\"widgets\":{\"list\":{\"title\":\"\\u5217\\u8868\\u9875\\u5185\\u5bb9\",\"display\":\"1\",\"vars\":{\"list_num\":{\"title\":\"\\u6bcf\\u9875\\u6587\\u7ae0\\u6570\\u91cf\",\"value\":\"20\",\"type\":\"number\",\"tip\":\"\\u6700\\u65b0\\u6587\\u7ae0\\u5217\\u8868\\u663e\\u793a\\u6570\\u91cf\"},\"paging\":{\"title\":\"\\u662f\\u5426\\u5206\\u9875\",\"value\":\"1\",\"type\":\"select\",\"options\":[\"\\u4e0d\\u5206\\u9875\",\"\\u5206\\u9875\"]}}}}}' , `description` = '包含该分类下所有子分类的列表页模板文件' , `is_public` = 0 , `list_order` = 5.1 WHERE `theme` = 'brisk' AND `file` = 'portal/list_sub' [ RunTime:0.000753s ]
- [ SQL ] SELECT * FROM `cmf_theme_file` WHERE `theme` = 'brisk' AND `file` = 'portal/search' LIMIT 1 [ RunTime:0.000297s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_theme_file',
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 21,
'extra' => 'Using where',
) ]
- [ SQL ] UPDATE `cmf_theme_file` SET `theme` = 'brisk' , `action` = 'portal/Search/index' , `file` = 'portal/search' , `name` = '搜索页' , `more` = '{\"vars\":{\"list_num\":{\"title\":\"\\u6bcf\\u9875\\u663e\\u793a\\u6570\\u91cf\",\"value\":\"20\",\"type\":\"number\"}}}' , `config_more` = '{\"vars\":{\"list_num\":{\"title\":\"\\u6bcf\\u9875\\u663e\\u793a\\u6570\\u91cf\",\"value\":\"20\",\"type\":\"number\"}}}' , `description` = '搜索页模板文件' , `is_public` = 0 , `list_order` = 10 WHERE `theme` = 'brisk' AND `file` = 'portal/search' [ RunTime:0.000922s ]
- [ SQL ] SELECT * FROM `cmf_theme_file` WHERE `theme` = 'brisk' AND `file` = 'public/config' LIMIT 1 [ RunTime:0.000307s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_theme_file',
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 21,
'extra' => 'Using where',
) ]
- [ SQL ] UPDATE `cmf_theme_file` SET `theme` = 'brisk' , `action` = 'public/Config' , `file` = 'public/config' , `name` = '模板全局配置' , `more` = '{\"vars\":{\"ad_1\":{\"title\":\"\\u4e3b\\u533a\\u5e7f\\u544a\\u4f4d\\u4e00\",\"value\":\"\",\"type\":\"image\",\"tip\":\"\\u4f4d\\u4e8e\\u4e3b\\u6587\\u7ae0\\u533a\\uff0c\\u6587\\u7ae0\\u5217\\u8868\\u7684\\u4e0a\\u65b9\"},\"ad_2\":{\"title\":\"\\u9875\\u9762\\u5e7f\\u544a\\u4f4d\",\"value\":\"\",\"type\":\"image\",\"tip\":\"\\u4f4d\\u4e8e\\u6587\\u7ae0\\u8be6\\u60c5\\u9875\\u4e0b\\u65b9\"},\"ads_1\":{\"title\":\"\\u8fb9\\u680f\\u5e7f\\u544a\\u4f4d\\u4e00\",\"value\":\"\",\"type\":\"image\",\"tip\":\"\\u4f4d\\u4e8e\\u8fb9\\u680f\\u533a\\uff0c\\u4f4d\\u7f6e\\u4ece\\u4e0a\\u81f3\\u4e0b\\u5206\\u522b\\u4e3a\\u4e00\\u3001\\u4e8c\\u3001\\u4e09\\u3001\\u56db\"},\"ads_2\":{\"title\":\"\\u8fb9\\u680f\\u5e7f\\u544a\\u4f4d\\u4e8c\",\"value\":\"\",\"type\":\"image\",\"tip\":\"\\u4f4d\\u4e8e\\u8fb9\\u680f\\u533a\\uff0c\\u4f4d\\u7f6e\\u4ece\\u4e0a\\u81f3\\u4e0b\\u5206\\u522b\\u4e3a\\u4e00\\u3001\\u4e8c\\u3001\\u4e09\\u3001\\u56db\"},\"ads_3\":{\"title\":\"\\u8fb9\\u680f\\u5e7f\\u544a\\u4f4d\\u4e09\",\"value\":\"\",\"type\":\"image\",\"tip\":\"\\u4f4d\\u4e8e\\u8fb9\\u680f\\u533a\\uff0c\\u4f4d\\u7f6e\\u4ece\\u4e0a\\u81f3\\u4e0b\\u5206\\u522b\\u4e3a\\u4e00\\u3001\\u4e8c\\u3001\\u4e09\\u3001\\u56db\"},\"ads_4\":{\"title\":\"\\u8fb9\\u680f\\u5e7f\\u544a\\u4f4d\\u56db\",\"value\":\"\",\"type\":\"image\",\"tip\":\"\\u4f4d\\u4e8e\\u8fb9\\u680f\\u533a\\uff0c\\u4f4d\\u7f6e\\u4ece\\u4e0a\\u81f3\\u4e0b\\u5206\\u522b\\u4e3a\\u4e00\\u3001\\u4e8c\\u3001\\u4e09\\u3001\\u56db\"}}}' , `config_more` = '{\"vars\":{\"ad_1\":{\"title\":\"\\u4e3b\\u533a\\u5e7f\\u544a\\u4f4d\\u4e00\",\"value\":\"\",\"type\":\"image\",\"tip\":\"\\u4f4d\\u4e8e\\u4e3b\\u6587\\u7ae0\\u533a\\uff0c\\u6587\\u7ae0\\u5217\\u8868\\u7684\\u4e0a\\u65b9\"},\"ad_2\":{\"title\":\"\\u9875\\u9762\\u5e7f\\u544a\\u4f4d\",\"value\":\"\",\"type\":\"image\",\"tip\":\"\\u4f4d\\u4e8e\\u6587\\u7ae0\\u8be6\\u60c5\\u9875\\u4e0b\\u65b9\"},\"ads_1\":{\"title\":\"\\u8fb9\\u680f\\u5e7f\\u544a\\u4f4d\\u4e00\",\"value\":\"\",\"type\":\"image\",\"tip\":\"\\u4f4d\\u4e8e\\u8fb9\\u680f\\u533a\\uff0c\\u4f4d\\u7f6e\\u4ece\\u4e0a\\u81f3\\u4e0b\\u5206\\u522b\\u4e3a\\u4e00\\u3001\\u4e8c\\u3001\\u4e09\\u3001\\u56db\"},\"ads_2\":{\"title\":\"\\u8fb9\\u680f\\u5e7f\\u544a\\u4f4d\\u4e8c\",\"value\":\"\",\"type\":\"image\",\"tip\":\"\\u4f4d\\u4e8e\\u8fb9\\u680f\\u533a\\uff0c\\u4f4d\\u7f6e\\u4ece\\u4e0a\\u81f3\\u4e0b\\u5206\\u522b\\u4e3a\\u4e00\\u3001\\u4e8c\\u3001\\u4e09\\u3001\\u56db\"},\"ads_3\":{\"title\":\"\\u8fb9\\u680f\\u5e7f\\u544a\\u4f4d\\u4e09\",\"value\":\"\",\"type\":\"image\",\"tip\":\"\\u4f4d\\u4e8e\\u8fb9\\u680f\\u533a\\uff0c\\u4f4d\\u7f6e\\u4ece\\u4e0a\\u81f3\\u4e0b\\u5206\\u522b\\u4e3a\\u4e00\\u3001\\u4e8c\\u3001\\u4e09\\u3001\\u56db\"},\"ads_4\":{\"title\":\"\\u8fb9\\u680f\\u5e7f\\u544a\\u4f4d\\u56db\",\"value\":\"\",\"type\":\"image\",\"tip\":\"\\u4f4d\\u4e8e\\u8fb9\\u680f\\u533a\\uff0c\\u4f4d\\u7f6e\\u4ece\\u4e0a\\u81f3\\u4e0b\\u5206\\u522b\\u4e3a\\u4e00\\u3001\\u4e8c\\u3001\\u4e09\\u3001\\u56db\"}}}' , `description` = '模板全局配置文件' , `is_public` = 1 , `list_order` = 0 WHERE `theme` = 'brisk' AND `file` = 'public/config' [ RunTime:0.000780s ]
- [ SQL ] SELECT * FROM `cmf_theme_file` WHERE `theme` = 'brisk' AND `file` = 'public/footer' LIMIT 1 [ RunTime:0.000282s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_theme_file',
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 21,
'extra' => 'Using where',
) ]
- [ SQL ] UPDATE `cmf_theme_file` SET `theme` = 'brisk' , `action` = 'public/footer' , `file` = 'public/footer' , `name` = '网站底部' , `more` = '{\"vars\":{\"infos\":{\"title\":\"\\u9875\\u9762\\u5e95\\u90e8\\u4fe1\\u606f\",\"type\":\"array\",\"value\":[{\"content\":\"Tao\\u8d22\\u7ecf\\u6df1\\u5ea6\\u900f\\u6790\\u8d44\\u672c\\u5e02\\u573a\\u3001\\u91d1\\u878d\\u5e02\\u573a\\u3001\\u65b0\\u79d1\\u6280\\u3001\\u65b0\\u6d88\\u8d39\\u3001\\u4e92\\u8054\\u7f51\\u65b0\\u7ecf\\u6d4e\\u7b49\\u9886\\u57df\\uff0c\\u63d0\\u4f9b\\u6709\\u6df1\\u5ea6\\u7684\\u5185\\u5bb9\\uff0c\\u6210\\u4e3a\\u6709\\u516c\\u4fe1\\u529b\\u7684\\u65b0\\u5a92\\u4f53\\u54c1\\u724c\"}],\"tip\":\"\\u663e\\u793a\\u5728\\u9875\\u9762\\u5e95\\u90e8\\u7684\\u4fe1\\u606f\\uff0c\\u6bcf\\u4e2a\\u4fe1\\u606f\\u5355\\u72ec\\u4e00\\u884c\",\"item\":{\"content\":{\"title\":\"\\u6587\\u5b57\\u5185\\u5bb9\",\"value\":\"\",\"type\":\"text\"}}},\"copyright\":{\"title\":\"\\u7248\\u6743\\u4fe1\\u606f\",\"type\":\"text\",\"value\":\"\\u6781\\u76ee\\u672a\\u6765 Copyright \\u00a9 All Rights Reserved.\",\"tip\":\"\\u663e\\u793a\\u5728\\u9875\\u9762\\u5e95\\u90e8\\u7684\\u7248\\u6743\\u4fe1\\u606f\"}}}' , `config_more` = '{\"vars\":{\"infos\":{\"title\":\"\\u9875\\u9762\\u5e95\\u90e8\\u4fe1\\u606f\",\"type\":\"array\",\"value\":[],\"tip\":\"\\u663e\\u793a\\u5728\\u9875\\u9762\\u5e95\\u90e8\\u7684\\u4fe1\\u606f\\uff0c\\u6bcf\\u4e2a\\u4fe1\\u606f\\u5355\\u72ec\\u4e00\\u884c\",\"item\":{\"content\":{\"title\":\"\\u6587\\u5b57\\u5185\\u5bb9\",\"value\":\"\",\"type\":\"text\"}}},\"copyright\":{\"title\":\"\\u7248\\u6743\\u4fe1\\u606f\",\"type\":\"text\",\"value\":\"Copyright © All Rights Reserved.\",\"tip\":\"\\u663e\\u793a\\u5728\\u9875\\u9762\\u5e95\\u90e8\\u7684\\u7248\\u6743\\u4fe1\\u606f\"}}}' , `description` = '网站底部通用模板设置' , `is_public` = 1 , `list_order` = 2 WHERE `theme` = 'brisk' AND `file` = 'public/footer' [ RunTime:0.000812s ]
- [ SQL ] SELECT * FROM `cmf_theme_file` WHERE `theme` = 'brisk' AND `file` = 'public/nav' LIMIT 1 [ RunTime:0.000321s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_theme_file',
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 21,
'extra' => 'Using where',
) ]
- [ SQL ] UPDATE `cmf_theme_file` SET `theme` = 'brisk' , `action` = 'public/nav' , `file` = 'public/nav' , `name` = '导航条' , `more` = '{\"vars\":{\"company_name\":{\"title\":\"\\u7f51\\u7ad9\\u540d\\u79f0\",\"value\":\"Tao\\u8d22\\u7ecf\\uff1a\\u65b0\\u7ecf\\u6d4e\\u670d\\u52a1\\u5e73\\u53f0\",\"type\":\"text\",\"tip\":\"\\u5bfc\\u822a\\u6761\\u5de6\\u4fa7\\u663e\\u793a\\u7684\\u7f51\\u7ad9\\u540d\\u79f0\\uff0c\\u9ed8\\u8ba4\\u4e3a\\u540e\\u53f0\\u8bbe\\u7f6e\\u7684\\u540d\\u79f0\"},\"logo\":{\"title\":\"\\u7f51\\u7ad9LOGO\",\"value\":\"default\\/20221102\\/7f12745a593966b2b2d13b7dd5a3e964.png\",\"type\":\"image\",\"tip\":\"LOGO\\u56fe\\u7247\\u5c3a\\u5bf8\\u4e3a260x60\\u50cf\\u7d20\\u3002\\u5982\\u679c\\u8bbe\\u7f6e\\u4e86LOGO\\uff0c\\u5219\\u4e0d\\u518d\\u663e\\u793a\\u7f51\\u7ad9\\u540d\\u79f0\\uff01\"},\"weixin\":{\"title\":\"\\u5fae\\u4fe1\\u516c\\u4f17\\u53f7\",\"value\":\"default\\/20221106\\/0336947d6704bf83e6e04e13fc68561a.jpeg\",\"type\":\"image\",\"tip\":\"\\u5fae\\u4fe1\\u516c\\u4f17\\u53f7\\u56fe\\u7247\"},\"nav_id\":{\"title\":\"\\u4e3b\\u5bfc\\u822a\",\"value\":\"1\",\"type\":\"text\",\"tip\":\"\\u8bf7\\u9009\\u62e9\\u9875\\u9762\\u4e3b\\u5bfc\\u822a\",\"dataSource\":{\"api\":\"admin\\/Nav\\/index\",\"multi\":false},\"rule\":{\"require\":true},\"message\":{\"require\":\"\\u4e0d\\u80fd\\u4e3a\\u7a7a\"},\"valueText\":\"\"}}}' , `config_more` = '{\"vars\":{\"company_name\":{\"title\":\"\\u7f51\\u7ad9\\u540d\\u79f0\",\"value\":\"\",\"type\":\"text\",\"tip\":\"\\u5bfc\\u822a\\u6761\\u5de6\\u4fa7\\u663e\\u793a\\u7684\\u7f51\\u7ad9\\u540d\\u79f0\\uff0c\\u9ed8\\u8ba4\\u4e3a\\u540e\\u53f0\\u8bbe\\u7f6e\\u7684\\u540d\\u79f0\"},\"logo\":{\"title\":\"\\u7f51\\u7ad9LOGO\",\"value\":\"\",\"type\":\"image\",\"tip\":\"LOGO\\u56fe\\u7247\\u5c3a\\u5bf8\\u4e3a260x60\\u50cf\\u7d20\\u3002\\u5982\\u679c\\u8bbe\\u7f6e\\u4e86LOGO\\uff0c\\u5219\\u4e0d\\u518d\\u663e\\u793a\\u7f51\\u7ad9\\u540d\\u79f0\\uff01\"},\"weixin\":{\"title\":\"\\u5fae\\u4fe1\\u516c\\u4f17\\u53f7\",\"value\":\"\",\"type\":\"image\",\"tip\":\"\\u5fae\\u4fe1\\u516c\\u4f17\\u53f7\\u56fe\\u7247\"},\"nav_id\":{\"title\":\"\\u4e3b\\u5bfc\\u822a\",\"value\":\"1\",\"type\":\"text\",\"tip\":\"\\u8bf7\\u9009\\u62e9\\u9875\\u9762\\u4e3b\\u5bfc\\u822a\",\"dataSource\":{\"api\":\"admin\\/Nav\\/index\",\"multi\":false},\"rule\":{\"require\":true},\"message\":{\"require\":\"\\u4e0d\\u80fd\\u4e3a\\u7a7a\"}}}}' , `description` = '导航条模板文件' , `is_public` = 1 , `list_order` = 1 WHERE `theme` = 'brisk' AND `file` = 'public/nav' [ RunTime:0.000978s ]
- [ SQL ] SELECT * FROM `cmf_theme_file` WHERE `theme` = 'brisk' AND `file` = 'public/widgets/right' LIMIT 1 [ RunTime:0.000297s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_theme_file',
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 21,
'extra' => 'Using where',
) ]
- [ SQL ] UPDATE `cmf_theme_file` SET `theme` = 'brisk' , `action` = 'public/widgets/right' , `file` = 'public/widgets/right' , `name` = '右侧边栏' , `more` = '{\"widgets\":{\"side1\":{\"title\":\"\\u5feb\\u8baf\",\"display\":1,\"vars\":{\"cat_ids\":{\"title\":\"\\u6587\\u7ae0\\u5206\\u7c7bid\",\"value\":\"1\",\"type\":\"text\",\"tip\":\"\\u8bf7\\u9009\\u5c55\\u793a\\u5728\\u8fb9\\u680f\\u4e0a\\u7684\\u6587\\u7ae0\\u5206\\u7c7b\\uff0c\\u4e0d\\u652f\\u6301\\u591a\\u9009\",\"dataSource\":{\"api\":\"portal\\/Category\\/index\",\"multi\":false},\"valueText\":\"\\u5feb\\u8baf\"},\"list_num\":{\"title\":\"\\u5c55\\u793a\\u6570\\u91cf\",\"value\":\"8\",\"type\":\"number\",\"tip\":\"\\u9ed8\\u8ba4\\u5c55\\u793a8\\u4e2a\"}}},\"side2\":{\"title\":\"\\u539f\\u521b\",\"display\":1,\"vars\":{\"cat_ids\":{\"title\":\"\\u6587\\u7ae0\\u5206\\u7c7bid\",\"value\":\"2\",\"type\":\"text\",\"tip\":\"\\u8bf7\\u9009\\u5c55\\u793a\\u5728\\u8fb9\\u680f\\u4e0a\\u7684\\u6587\\u7ae0\\u5206\\u7c7b\\uff0c\\u4e0d\\u652f\\u6301\\u591a\\u9009\",\"dataSource\":{\"api\":\"portal\\/Category\\/index\",\"multi\":false},\"valueText\":\"\\u539f\\u521b\"},\"list_num\":{\"title\":\"\\u5c55\\u793a\\u6570\\u91cf\",\"value\":\"8\",\"type\":\"number\",\"tip\":\"\\u9ed8\\u8ba4\\u5c55\\u793a8\\u4e2a\"}}},\"side3\":{\"title\":\"\\u4e13\\u9898\",\"display\":1,\"vars\":{\"cat_ids\":{\"title\":\"\\u6587\\u7ae0\\u5206\\u7c7bid\",\"value\":\"8\",\"type\":\"text\",\"tip\":\"\\u8bf7\\u9009\\u5c55\\u793a\\u5728\\u8fb9\\u680f\\u4e0a\\u7684\\u6587\\u7ae0\\u5206\\u7c7b\\uff0c\\u4e0d\\u652f\\u6301\\u591a\\u9009\",\"dataSource\":{\"api\":\"portal\\/Category\\/index\",\"multi\":false},\"valueText\":\"\\u63a8\\u8350\"},\"list_num\":{\"title\":\"\\u5c55\\u793a\\u6570\\u91cf\",\"value\":\"8\",\"type\":\"number\",\"tip\":\"\\u9ed8\\u8ba4\\u5c55\\u793a8\\u4e2a\"}}},\"side4\":{\"title\":\"\\u53f3\\u8fb9\\u680f\\u56db\",\"display\":0,\"vars\":{\"cat_ids\":{\"title\":\"\\u6587\\u7ae0\\u5206\\u7c7bid\",\"value\":\"\",\"type\":\"text\",\"tip\":\"\\u8bf7\\u9009\\u5c55\\u793a\\u5728\\u8fb9\\u680f\\u4e0a\\u7684\\u6587\\u7ae0\\u5206\\u7c7b\\uff0c\\u4e0d\\u652f\\u6301\\u591a\\u9009\",\"dataSource\":{\"api\":\"portal\\/Category\\/index\",\"multi\":false},\"valueText\":\"\"},\"list_num\":{\"title\":\"\\u5c55\\u793a\\u6570\\u91cf\",\"value\":\"8\",\"type\":\"number\",\"tip\":\"\\u9ed8\\u8ba4\\u5c55\\u793a8\\u4e2a\"}}},\"tags\":{\"title\":\"\\u6807\\u7b7e\\u4e91\",\"display\":1,\"vars\":{\"tag_num\":{\"title\":\"\\u6700\\u591a\\u663e\\u793a\\u6807\\u7b7e\\u6570\\u91cf\",\"value\":\"30\",\"type\":\"number\",\"tip\":\"\\u9ed8\\u8ba4\\u6700\\u591a\\u663e\\u793a30\\u4e2a\"}}},\"follow\":{\"title\":\"\\u5173\\u6ce8\\u6211\\u4eec\",\"display\":1,\"vars\":{\"qrcode\":{\"title\":\"\\u5173\\u6ce8\\u56fe\\u7247\",\"value\":\"default\\/20221118\\/b1a8ec3653c795c866018147a9d09cfb.png\",\"type\":\"image\",\"tip\":\"\\u53ef\\u4ee5\\u4e0a\\u4f20\\u5305\\u542b\\u4e8c\\u7ef4\\u7801\\u6216\\u8005\\u5176\\u5b83\\u4fe1\\u606f\\u7684\\u56fe\\u7247\"}}}}}' , `config_more` = '{\"widgets\":{\"side1\":{\"title\":\"\\u53f3\\u8fb9\\u680f\\u4e00\",\"display\":\"1\",\"vars\":{\"cat_ids\":{\"title\":\"\\u6587\\u7ae0\\u5206\\u7c7bid\",\"value\":\"\",\"type\":\"text\",\"tip\":\"\\u8bf7\\u9009\\u5c55\\u793a\\u5728\\u8fb9\\u680f\\u4e0a\\u7684\\u6587\\u7ae0\\u5206\\u7c7b\\uff0c\\u4e0d\\u652f\\u6301\\u591a\\u9009\",\"dataSource\":{\"api\":\"portal\\/Category\\/index\",\"multi\":false}},\"list_num\":{\"title\":\"\\u5c55\\u793a\\u6570\\u91cf\",\"value\":8,\"type\":\"number\",\"tip\":\"\\u9ed8\\u8ba4\\u5c55\\u793a8\\u4e2a\"}}},\"side2\":{\"title\":\"\\u53f3\\u8fb9\\u680f\\u4e8c\",\"display\":\"1\",\"vars\":{\"cat_ids\":{\"title\":\"\\u6587\\u7ae0\\u5206\\u7c7bid\",\"value\":\"\",\"type\":\"text\",\"tip\":\"\\u8bf7\\u9009\\u5c55\\u793a\\u5728\\u8fb9\\u680f\\u4e0a\\u7684\\u6587\\u7ae0\\u5206\\u7c7b\\uff0c\\u4e0d\\u652f\\u6301\\u591a\\u9009\",\"dataSource\":{\"api\":\"portal\\/Category\\/index\",\"multi\":false}},\"list_num\":{\"title\":\"\\u5c55\\u793a\\u6570\\u91cf\",\"value\":8,\"type\":\"number\",\"tip\":\"\\u9ed8\\u8ba4\\u5c55\\u793a8\\u4e2a\"}}},\"side3\":{\"title\":\"\\u53f3\\u8fb9\\u680f\\u4e09\",\"display\":\"1\",\"vars\":{\"cat_ids\":{\"title\":\"\\u6587\\u7ae0\\u5206\\u7c7bid\",\"value\":\"\",\"type\":\"text\",\"tip\":\"\\u8bf7\\u9009\\u5c55\\u793a\\u5728\\u8fb9\\u680f\\u4e0a\\u7684\\u6587\\u7ae0\\u5206\\u7c7b\\uff0c\\u4e0d\\u652f\\u6301\\u591a\\u9009\",\"dataSource\":{\"api\":\"portal\\/Category\\/index\",\"multi\":false}},\"list_num\":{\"title\":\"\\u5c55\\u793a\\u6570\\u91cf\",\"value\":8,\"type\":\"number\",\"tip\":\"\\u9ed8\\u8ba4\\u5c55\\u793a8\\u4e2a\"}}},\"side4\":{\"title\":\"\\u53f3\\u8fb9\\u680f\\u56db\",\"display\":\"1\",\"vars\":{\"cat_ids\":{\"title\":\"\\u6587\\u7ae0\\u5206\\u7c7bid\",\"value\":\"\",\"type\":\"text\",\"tip\":\"\\u8bf7\\u9009\\u5c55\\u793a\\u5728\\u8fb9\\u680f\\u4e0a\\u7684\\u6587\\u7ae0\\u5206\\u7c7b\\uff0c\\u4e0d\\u652f\\u6301\\u591a\\u9009\",\"dataSource\":{\"api\":\"portal\\/Category\\/index\",\"multi\":false}},\"list_num\":{\"title\":\"\\u5c55\\u793a\\u6570\\u91cf\",\"value\":8,\"type\":\"number\",\"tip\":\"\\u9ed8\\u8ba4\\u5c55\\u793a8\\u4e2a\"}}},\"tags\":{\"title\":\"\\u6807\\u7b7e\\u4e91\",\"display\":\"1\",\"vars\":{\"tag_num\":{\"title\":\"\\u6700\\u591a\\u663e\\u793a\\u6807\\u7b7e\\u6570\\u91cf\",\"value\":30,\"type\":\"number\",\"tip\":\"\\u9ed8\\u8ba4\\u6700\\u591a\\u663e\\u793a30\\u4e2a\"}}},\"follow\":{\"title\":\"\\u5173\\u6ce8\\u6211\\u4eec\",\"display\":\"1\",\"vars\":{\"qrcode\":{\"title\":\"\\u5173\\u6ce8\\u56fe\\u7247\",\"value\":\"\",\"type\":\"image\",\"tip\":\"\\u53ef\\u4ee5\\u4e0a\\u4f20\\u5305\\u542b\\u4e8c\\u7ef4\\u7801\\u6216\\u8005\\u5176\\u5b83\\u4fe1\\u606f\\u7684\\u56fe\\u7247\"}}}}}' , `description` = '在页面右侧的边栏设置' , `is_public` = 1 , `list_order` = 3 WHERE `theme` = 'brisk' AND `file` = 'public/widgets/right' [ RunTime:0.000844s ]
- [ SQL ] SELECT * FROM `cmf_theme_file` WHERE `theme` = 'brisk' [ RunTime:0.000327s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_theme_file',
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 21,
'extra' => 'Using where',
) ]
- [ SQL ] SHOW COLUMNS FROM `cmf_theme` [ RunTime:0.000650s ]
- [ SQL ] UPDATE `cmf_theme` SET `name` = '金融资讯类博客' , `version` = '1.0.0' , `author` = '惠达浪' , `lang` = 'zh-cn' , `keywords` = '新闻,资讯,博客,金融' , `thumbnail` = 'thumbnail.jpg' , `description` = '清爽风格，适用于个人博客、新闻、资讯类模板' , `author_url` = 'https://www.qdcrazy.cc' , `demo_url` = 'https://www.crazys.pub' WHERE `theme` = 'brisk' [ RunTime:0.000723s ]
- [ SQL ] SELECT `more` FROM `cmf_theme_file` WHERE `theme` = 'brisk' AND ( `is_public` = 1 OR `file` = 'portal/list' ) [ RunTime:0.000312s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_theme_file',
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 21,
'extra' => 'Using where',
) ]
- [ SQL ] SHOW COLUMNS FROM `cmf_option` [ RunTime:0.000584s ]
- [ SQL ] SELECT `option_value` FROM `cmf_option` WHERE `option_name` = 'storage' LIMIT 1 [ RunTime:0.000278s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => NULL,
'type' => NULL,
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => NULL,
'extra' => 'Impossible WHERE noticed after reading const tables',
) ]
- [ SQL ] SHOW COLUMNS FROM `cmf_nav_menu` [ RunTime:0.000594s ]
- [ SQL ] SELECT * FROM `cmf_nav_menu` WHERE `nav_id` = 1 AND `status` = 1 ORDER BY `list_order` ASC [ RunTime:0.000342s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_nav_menu',
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 6,
'extra' => 'Using where; Using filesort',
) ]
- [ SQL ] SELECT `id` FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 8 ORDER BY `list_order` ASC [ RunTime:0.000293s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_portal_category',
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 8,
'extra' => 'Using where; Using filesort',
) ]
- [ SQL ] SHOW COLUMNS FROM `cmf_portal_post` [ RunTime:0.000679s ]
- [ 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` = 8 ) AND ( `post`.`published_time` > 0 AND `post`.`published_time` < 1732311906 ) GROUP BY `post`.`id` ) `_group_count_` [ RunTime:0.000406s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'PRIMARY',
'table' => '<derived2>',
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 2,
'extra' => NULL,
) ]
- [ SQL ] SELECT `post`.`id`,`post_title`,`post_excerpt`,`thumbnail`,`published_time`,`post_hits`,`post_keywords`,`more` 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` = 8 ) AND ( `post`.`published_time` > 0 AND `post`.`published_time` < 1732311906 ) GROUP BY `post`.`id` ORDER BY `post`.`published_time` DESC LIMIT 0,20 [ RunTime:0.000519s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'category_post',
'type' => 'ref',
'possible_keys' => 'term_taxonomy_id',
'key' => 'term_taxonomy_id',
'key_len' => '8',
'ref' => 'const',
'rows' => 1,
'extra' => 'Using index condition; Using temporary; Using filesort',
) ]
- [ SQL ] SELECT post.id,post_title,post_excerpt,thumbnail,more,min(category_post.category_id) cid 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` = '1' ) AND ( `post`.`published_time` > 0 AND `post`.`published_time` < 1732311906 ) GROUP BY `post`.`id` ORDER BY `post`.`published_time` DESC LIMIT 8 [ RunTime:0.000678s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'category_post',
'type' => 'ref',
'possible_keys' => 'term_taxonomy_id',
'key' => 'term_taxonomy_id',
'key_len' => '8',
'ref' => 'const',
'rows' => 6,
'extra' => 'Using index condition; Using temporary; Using filesort',
) ]
- [ SQL ] SELECT post.id,post_title,post_excerpt,thumbnail,more,min(category_post.category_id) cid 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` = '2' ) AND ( `post`.`published_time` > 0 AND `post`.`published_time` < 1732311906 ) GROUP BY `post`.`id` ORDER BY `post`.`published_time` DESC LIMIT 8 [ RunTime:0.000605s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'category_post',
'type' => 'ref',
'possible_keys' => 'term_taxonomy_id',
'key' => 'term_taxonomy_id',
'key_len' => '8',
'ref' => 'const',
'rows' => 4,
'extra' => 'Using index condition; Using temporary; Using filesort',
) ]
- [ SQL ] SELECT post.id,post_title,post_excerpt,thumbnail,more,min(category_post.category_id) cid 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` = '8' ) AND ( `post`.`published_time` > 0 AND `post`.`published_time` < 1732311906 ) GROUP BY `post`.`id` ORDER BY `post`.`published_time` DESC LIMIT 8 [ RunTime:0.000555s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'category_post',
'type' => 'ref',
'possible_keys' => 'term_taxonomy_id',
'key' => 'term_taxonomy_id',
'key_len' => '8',
'ref' => 'const',
'rows' => 1,
'extra' => 'Using index condition; Using temporary; Using filesort',
) ]
- [ SQL ] SHOW COLUMNS FROM `cmf_portal_tag` [ RunTime:0.000578s ]
- [ SQL ] SELECT * FROM `cmf_portal_tag` WHERE `status` = 1 ORDER BY rand() LIMIT 30 [ RunTime:0.000380s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_portal_tag',
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 10,
'extra' => 'Using where; Using temporary; Using filesort',
) ]
0.087568s
