中國華服日
中國華服日·溯夢金陵
青瑤
墨韻
青瑤
國慶
青瑤
李商隱《錦瑟》
墨韻
墨韻
基本
文件
流程
错误
SQL
调试
请求信息 : 2021-01-18 08:16:21 HTTP/1.1 GET : https://hanfu.hk/music.html 运行时间 : 0.064638s [ 吞吐率：15.47req/s ] 内存消耗：890.63kb 文件加载：117 查询信息 : 40 queries 9 writes 缓存信息 : 6 reads,0 writes
[ LANG ] /srv/www/hanfu.hk/vendor/thinkphp/lang/zh-cn.php [ LANG ] /srv/www/hanfu.hk/app/portal//lang/zh-cn.php [ ROUTE ] array (
'rule' => 'music',
'route' => 'portal/List/index?id=4',
'option' =>
array (
'merge_rule_regex' => false,
),
'var' =>
array (
),
) [ HEADER ] array (
'host' => 'hanfu.hk',
'connection' => 'Keep-Alive',
'accept-encoding' => 'gzip',
'cf-ipcountry' => 'US',
'x-forwarded-for' => '3.239.242.55',
'cf-ray' => '613420723c9bf0f2-IAD',
'x-forwarded-proto' => 'https',
'cf-visitor' => '{"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',
'cf-request-id' => '07b4729b620000f0f21b3e6000000001',
'cf-connecting-ip' => '3.239.242.55',
'cdn-loop' => 'cloudflare',
) [ PARAM ] array (
'id' => '4',
) [ LANG ] /srv/www/hanfu.hk/vendor/thinkcmf/cmf/src/behavior/../lang/zh-cn.php [ LANG ] /srv/www/hanfu.hk/vendor/thinkcmf/cmf-app/src/admin/lang/zh-cn.php [ LANG ] /srv/www/hanfu.hk/vendor/thinkcmf/cmf-app/src/admin/lang/zh-cn/common.php [ LANG ] /srv/www/hanfu.hk/vendor/thinkcmf/cmf-app/src/user/lang/zh-cn.php [ LANG ] /srv/www/hanfu.hk/app/portal/lang/zh-cn/common.php [ LANG ] /srv/www/hanfu.hk/app/portal/lang/zh-cn/home.php [ DB ] INIT mysql [ VIEW ] /srv/www/hanfu.hk/public/themes/brisk/portal/list.html [ array (
0 => 'site_info',
1 => 'category',
2 => 'theme_vars',
3 => 'theme_widgets',
) ]
[ DB ] CONNECT:[ UseTime:0.000629s ] mysql:host=192.168.1.86;port=3306;dbname=hanfu_cmf;charset=utf8mb4 [ SQL ] SHOW COLUMNS FROM `cmf_portal_category` [ RunTime:0.000874s ] [ SQL ] SELECT * FROM `cmf_portal_category` WHERE `id` = 4 AND `status` = 1 LIMIT 1 [ RunTime:0.000427s ] [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_portal_category',
'partitions' => NULL,
'type' => 'const',
'possible_keys' => 'PRIMARY',
'key' => 'PRIMARY',
'key_len' => '8',
'ref' => 'const',
'rows' => 1,
'filtered' => 100.0,
'extra' => NULL,
) ] [ SQL ] SHOW COLUMNS FROM `cmf_theme_file` [ RunTime:0.000534s ] [ SQL ] SELECT * FROM `cmf_theme_file` WHERE `theme` = 'brisk' AND `file` = 'portal/index' LIMIT 1 [ RunTime:0.000376s ] [ 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' => 16,
'filtered' => 6.25,
'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\":\"\\ud83d\\udce3\",\"display\":1,\"vars\":{\"cat_ids\":{\"title\":\"\\u5934\\u6761\\u5206\\u7c7bid\",\"value\":\"1,3,4,5,6\",\"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\":\"\\u65b0\\u805e\\u5831\\u5c0e,\\u6d3b\\u52d5\\u8f2f\\u9304,\\u96c5\\u6a02\\u6f14\\u594f,\\u6f22\\u98a8\\u6b4c\\u821e,\\u6f22\\u5f0f\\u751f\\u6d3b\"},\"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,7,4,5,6\",\"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\":\"\\u65b0\\u805e\\u5831\\u5c0e,\\u95dc\\u65bc,\\u6d3b\\u52d5\\u8f2f\\u9304,1122\\u6f22\\u670d\\u7bc0,\\u96c5\\u6a02\\u6f14\\u594f,\\u6f22\\u98a8\\u6b4c\\u821e,\\u6f22\\u5f0f\\u751f\\u6d3b\"},\"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.000943s ] [ SQL ] SELECT * FROM `cmf_theme_file` WHERE `theme` = 'brisk' AND `file` = 'portal/list' LIMIT 1 [ RunTime:0.000342s ] [ 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' => 16,
'filtered' => 6.25,
'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\":\"https:\\/\\/hanfu.hk\\/upload\\/default\\/20201231\\/825fd7c782838c182f7140dfe18f0f68.jpg\",\"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.000779s ] [ SQL ] SELECT * FROM `cmf_theme_file` WHERE `theme` = 'brisk' AND `file` = 'portal/list_sub' LIMIT 1 [ RunTime:0.000356s ] [ 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' => 16,
'filtered' => 6.25,
'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\":\"https:\\/\\/hanfu.hk\\/upload\\/default\\/20201231\\/825fd7c782838c182f7140dfe18f0f68.jpg\",\"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.000771s ] [ SQL ] SELECT * FROM `cmf_theme_file` WHERE `theme` = 'brisk' AND `file` = 'portal/search' LIMIT 1 [ RunTime:0.000340s ] [ 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' => 16,
'filtered' => 6.25,
'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.000698s ] [ SQL ] SELECT * FROM `cmf_theme_file` WHERE `theme` = 'brisk' AND `file` = 'public/config' LIMIT 1 [ RunTime:0.000367s ] [ 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' => 16,
'filtered' => 6.25,
'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.000763s ] [ SQL ] SELECT * FROM `cmf_theme_file` WHERE `theme` = 'brisk' AND `file` = 'public/footer' LIMIT 1 [ RunTime:0.000370s ] [ 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' => 16,
'filtered' => 6.25,
'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\":[],\"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\":\"HANFU.HK \\u70ba\\u60a8\\u6536\\u96c6\\u7f8e\\u597d\\u7684\\u6f22\\u670d\\u8cc7\\u8a0a\",\"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.000745s ] [ SQL ] SELECT * FROM `cmf_theme_file` WHERE `theme` = 'brisk' AND `file` = 'public/nav' LIMIT 1 [ RunTime:0.000343s ] [ 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' => 16,
'filtered' => 6.25,
'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\":\"HANFU.HK\",\"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\\/20210101\\/bcbbb6a92dfbf6de84b1e7105025e0a5.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\"},\"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\":\"\\u4e3b\\u5bfc\\u822a\"}}}' , `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\"},\"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.000789s ] [ SQL ] SELECT * FROM `cmf_theme_file` WHERE `theme` = 'brisk' AND `file` = 'public/widgets/right' LIMIT 1 [ RunTime:0.000372s ] [ 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' => 16,
'filtered' => 6.25,
'extra' => 'Using where',
) ] [ SQL ] UPDATE `cmf_theme_file` SET `theme` = 'brisk' , `action` = 'public/widgets/right' , `file` = 'public/widgets/right' , `name` = '右侧边栏' , `more` = '{\"widgets\":{\"side1\":{\"title\":\"\\u6d3b\\u52d5\\u8f2f\\u9304\",\"display\":1,\"vars\":{\"cat_ids\":{\"title\":\"\\u6587\\u7ae0\\u5206\\u7c7bid\",\"value\":\"3\",\"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\":\"\\u6d3b\\u52d5\\u8f2f\\u9304\"},\"list_num\":{\"title\":\"\\u5c55\\u793a\\u6570\\u91cf\",\"value\":\"8\",\"type\":\"number\",\"tip\":\"\\u9ed8\\u8ba4\\u5c55\\u793a8\\u4e2a\"}}},\"side2\":{\"title\":\"\\u6f22\\u5f0f\\u751f\\u6d3b\",\"display\":1,\"vars\":{\"cat_ids\":{\"title\":\"\\u6587\\u7ae0\\u5206\\u7c7bid\",\"value\":\"6\",\"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\":\"\\u6f22\\u5f0f\\u751f\\u6d3b\"},\"list_num\":{\"title\":\"\\u5c55\\u793a\\u6570\\u91cf\",\"value\":\"8\",\"type\":\"number\",\"tip\":\"\\u9ed8\\u8ba4\\u5c55\\u793a8\\u4e2a\"}}},\"side3\":{\"title\":\"\\u96c5\\u6a02\\u6f14\\u594f\",\"display\":1,\"vars\":{\"cat_ids\":{\"title\":\"\\u6587\\u7ae0\\u5206\\u7c7bid\",\"value\":\"4\",\"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\":\"\\u96c5\\u6a02\\u6f14\\u594f\"},\"list_num\":{\"title\":\"\\u5c55\\u793a\\u6570\\u91cf\",\"value\":\"8\",\"type\":\"number\",\"tip\":\"\\u9ed8\\u8ba4\\u5c55\\u793a8\\u4e2a\"}}},\"side4\":{\"title\":\"\\u6f22\\u98a8\\u6b4c\\u821e\",\"display\":1,\"vars\":{\"cat_ids\":{\"title\":\"\\u6587\\u7ae0\\u5206\\u7c7bid\",\"value\":\"5\",\"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\":\"\\u6f22\\u98a8\\u6b4c\\u821e\"},\"list_num\":{\"title\":\"\\u5c55\\u793a\\u6570\\u91cf\",\"value\":\"8\",\"type\":\"number\",\"tip\":\"\\u9ed8\\u8ba4\\u5c55\\u793a8\\u4e2a\"}}},\"tags\":{\"title\":\"\\u71b1\\u9580\\u6a19\\u7c64\",\"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\":\"\\u95dc\\u6ce8\\u6211\\u5011\",\"display\":1,\"vars\":{\"qrcode\":{\"title\":\"\\u5173\\u6ce8\\u56fe\\u7247\",\"value\":\"default\\/20201231\\/fa0d246d11e4fd1d8b89d32f619568e7.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.000736s ] [ SQL ] SELECT * FROM `cmf_theme_file` WHERE `theme` = 'brisk' [ RunTime:0.000406s ] [ 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' => 16,
'filtered' => 10.0,
'extra' => 'Using where',
) ] [ SQL ] SHOW COLUMNS FROM `cmf_theme` [ RunTime:0.000613s ] [ 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.000301s ] [ SQL ] SELECT `more` FROM `cmf_theme_file` WHERE `theme` = 'brisk' AND ( `is_public` = 1 OR `file` = 'portal/list' ) [ RunTime:0.000373s ] [ 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' => 16,
'filtered' => 6.25,
'extra' => 'Using where',
) ] [ SQL ] SHOW COLUMNS FROM `cmf_plugin` [ RunTime:0.000562s ] [ SQL ] SELECT `config` FROM `cmf_plugin` WHERE `name` = 'PortalArticleDataVueMeta' LIMIT 1 [ RunTime:0.000279s ] [ 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' => 8,
'filtered' => 12.5,
'extra' => 'Using where',
) ] [ SQL ] SHOW COLUMNS FROM `cmf_nav_menu` [ RunTime:0.000559s ] [ SQL ] SELECT * FROM `cmf_nav_menu` WHERE `nav_id` = 1 AND `status` = 1 ORDER BY `list_order` ASC [ RunTime:0.000387s ] [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_nav_menu',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 14,
'filtered' => 7.142856597900391,
'extra' => 'Using where; Using filesort',
) ] [ SQL ] SELECT `id` FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 4 ORDER BY `list_order` ASC [ RunTime:0.000287s ] [ 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' => 6,
'filtered' => 16.666667938232422,
'extra' => 'Using where; Using filesort',
) ] [ SQL ] SHOW COLUMNS FROM `cmf_portal_post` [ RunTime:0.000600s ] [ 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` = 4 ) AND ( `post`.`published_time` > 0 AND `post`.`published_time` < 1610928981 ) GROUP BY `post`.`id` ) `_group_count_` [ RunTime:0.000622s ] [ EXPLAIN : array (
'id' => 1,
'select_type' => 'PRIMARY',
'table' => '<derived2>',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 2,
'filtered' => 100.0,
'extra' => NULL,
) ] [ SQL ] SELECT `post`.`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` = 4 ) AND ( `post`.`published_time` > 0 AND `post`.`published_time` < 1610928981 ) GROUP BY `post`.`id` ORDER BY `post`.`published_time` DESC LIMIT 0,20 [ RunTime:0.000727s ] [ 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' => 11,
'filtered' => 100.0,
'extra' => 'Using index condition; Using temporary; Using filesort',
) ] [ SQL ] SHOW COLUMNS FROM `cmf_portal_category_post` [ RunTime:0.000452s ] [ SQL ] SELECT `cmf_portal_category`.*,`pivot`.`id` AS `pivot__id`,`pivot`.`post_id` AS `pivot__post_id`,`pivot`.`category_id` AS `pivot__category_id`,`pivot`.`list_order` AS `pivot__list_order`,`pivot`.`status` AS `pivot__status` FROM `cmf_portal_category` INNER JOIN `cmf_portal_category_post` `pivot` ON `pivot`.`category_id`=`cmf_portal_category`.`id` WHERE `pivot`.`post_id` = 236 [ RunTime:0.000629s ] [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_portal_category',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => 'PRIMARY',
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 6,
'filtered' => 100.0,
'extra' => NULL,
) ] [ SQL ] SELECT `cmf_portal_category`.*,`pivot`.`id` AS `pivot__id`,`pivot`.`post_id` AS `pivot__post_id`,`pivot`.`category_id` AS `pivot__category_id`,`pivot`.`list_order` AS `pivot__list_order`,`pivot`.`status` AS `pivot__status` FROM `cmf_portal_category` INNER JOIN `cmf_portal_category_post` `pivot` ON `pivot`.`category_id`=`cmf_portal_category`.`id` WHERE `pivot`.`post_id` = 217 [ RunTime:0.000647s ] [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_portal_category',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => 'PRIMARY',
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 6,
'filtered' => 100.0,
'extra' => NULL,
) ] [ SQL ] SELECT `cmf_portal_category`.*,`pivot`.`id` AS `pivot__id`,`pivot`.`post_id` AS `pivot__post_id`,`pivot`.`category_id` AS `pivot__category_id`,`pivot`.`list_order` AS `pivot__list_order`,`pivot`.`status` AS `pivot__status` FROM `cmf_portal_category` INNER JOIN `cmf_portal_category_post` `pivot` ON `pivot`.`category_id`=`cmf_portal_category`.`id` WHERE `pivot`.`post_id` = 218 [ RunTime:0.000607s ] [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_portal_category',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => 'PRIMARY',
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 6,
'filtered' => 100.0,
'extra' => NULL,
) ] [ SQL ] SELECT `cmf_portal_category`.*,`pivot`.`id` AS `pivot__id`,`pivot`.`post_id` AS `pivot__post_id`,`pivot`.`category_id` AS `pivot__category_id`,`pivot`.`list_order` AS `pivot__list_order`,`pivot`.`status` AS `pivot__status` FROM `cmf_portal_category` INNER JOIN `cmf_portal_category_post` `pivot` ON `pivot`.`category_id`=`cmf_portal_category`.`id` WHERE `pivot`.`post_id` = 203 [ RunTime:0.000564s ] [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_portal_category',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => 'PRIMARY',
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 6,
'filtered' => 100.0,
'extra' => NULL,
) ] [ SQL ] SELECT `cmf_portal_category`.*,`pivot`.`id` AS `pivot__id`,`pivot`.`post_id` AS `pivot__post_id`,`pivot`.`category_id` AS `pivot__category_id`,`pivot`.`list_order` AS `pivot__list_order`,`pivot`.`status` AS `pivot__status` FROM `cmf_portal_category` INNER JOIN `cmf_portal_category_post` `pivot` ON `pivot`.`category_id`=`cmf_portal_category`.`id` WHERE `pivot`.`post_id` = 187 [ RunTime:0.000574s ] [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_portal_category',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => 'PRIMARY',
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 6,
'filtered' => 100.0,
'extra' => NULL,
) ] [ SQL ] SELECT `cmf_portal_category`.*,`pivot`.`id` AS `pivot__id`,`pivot`.`post_id` AS `pivot__post_id`,`pivot`.`category_id` AS `pivot__category_id`,`pivot`.`list_order` AS `pivot__list_order`,`pivot`.`status` AS `pivot__status` FROM `cmf_portal_category` INNER JOIN `cmf_portal_category_post` `pivot` ON `pivot`.`category_id`=`cmf_portal_category`.`id` WHERE `pivot`.`post_id` = 216 [ RunTime:0.000584s ] [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_portal_category',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => 'PRIMARY',
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 6,
'filtered' => 100.0,
'extra' => NULL,
) ] [ SQL ] SELECT `cmf_portal_category`.*,`pivot`.`id` AS `pivot__id`,`pivot`.`post_id` AS `pivot__post_id`,`pivot`.`category_id` AS `pivot__category_id`,`pivot`.`list_order` AS `pivot__list_order`,`pivot`.`status` AS `pivot__status` FROM `cmf_portal_category` INNER JOIN `cmf_portal_category_post` `pivot` ON `pivot`.`category_id`=`cmf_portal_category`.`id` WHERE `pivot`.`post_id` = 5 [ RunTime:0.000569s ] [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_portal_category',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => 'PRIMARY',
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 6,
'filtered' => 100.0,
'extra' => NULL,
) ] [ SQL ] SELECT `cmf_portal_category`.*,`pivot`.`id` AS `pivot__id`,`pivot`.`post_id` AS `pivot__post_id`,`pivot`.`category_id` AS `pivot__category_id`,`pivot`.`list_order` AS `pivot__list_order`,`pivot`.`status` AS `pivot__status` FROM `cmf_portal_category` INNER JOIN `cmf_portal_category_post` `pivot` ON `pivot`.`category_id`=`cmf_portal_category`.`id` WHERE `pivot`.`post_id` = 6 [ RunTime:0.000569s ] [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_portal_category',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => 'PRIMARY',
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 6,
'filtered' => 100.0,
'extra' => NULL,
) ] [ SQL ] SELECT `cmf_portal_category`.*,`pivot`.`id` AS `pivot__id`,`pivot`.`post_id` AS `pivot__post_id`,`pivot`.`category_id` AS `pivot__category_id`,`pivot`.`list_order` AS `pivot__list_order`,`pivot`.`status` AS `pivot__status` FROM `cmf_portal_category` INNER JOIN `cmf_portal_category_post` `pivot` ON `pivot`.`category_id`=`cmf_portal_category`.`id` WHERE `pivot`.`post_id` = 198 [ RunTime:0.000568s ] [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_portal_category',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => 'PRIMARY',
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 6,
'filtered' => 100.0,
'extra' => NULL,
) ] [ SQL ] SELECT `cmf_portal_category`.*,`pivot`.`id` AS `pivot__id`,`pivot`.`post_id` AS `pivot__post_id`,`pivot`.`category_id` AS `pivot__category_id`,`pivot`.`list_order` AS `pivot__list_order`,`pivot`.`status` AS `pivot__status` FROM `cmf_portal_category` INNER JOIN `cmf_portal_category_post` `pivot` ON `pivot`.`category_id`=`cmf_portal_category`.`id` WHERE `pivot`.`post_id` = 225 [ RunTime:0.000603s ] [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_portal_category',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => 'PRIMARY',
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 6,
'filtered' => 100.0,
'extra' => NULL,
) ] [ SQL ] SELECT `cmf_portal_category`.*,`pivot`.`id` AS `pivot__id`,`pivot`.`post_id` AS `pivot__post_id`,`pivot`.`category_id` AS `pivot__category_id`,`pivot`.`list_order` AS `pivot__list_order`,`pivot`.`status` AS `pivot__status` FROM `cmf_portal_category` INNER JOIN `cmf_portal_category_post` `pivot` ON `pivot`.`category_id`=`cmf_portal_category`.`id` WHERE `pivot`.`post_id` = 28 [ RunTime:0.000611s ] [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_portal_category',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => 'PRIMARY',
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 6,
'filtered' => 100.0,
'extra' => NULL,
) ] [ 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` = '3' ) AND ( `post`.`published_time` > 0 AND `post`.`published_time` < 1610928981 ) GROUP BY `post`.`id` ORDER BY `post`.`published_time` DESC LIMIT 8 [ RunTime:0.000861s ] [ 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' => 18,
'filtered' => 100.0,
'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` = '6' ) AND ( `post`.`published_time` > 0 AND `post`.`published_time` < 1610928981 ) GROUP BY `post`.`id` ORDER BY `post`.`published_time` DESC LIMIT 8 [ RunTime:0.000649s ] [ 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' => 9,
'filtered' => 100.0,
'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` = '4' ) AND ( `post`.`published_time` > 0 AND `post`.`published_time` < 1610928981 ) GROUP BY `post`.`id` ORDER BY `post`.`published_time` DESC LIMIT 8 [ RunTime:0.000690s ] [ 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' => 11,
'filtered' => 100.0,
'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` = '5' ) AND ( `post`.`published_time` > 0 AND `post`.`published_time` < 1610928981 ) GROUP BY `post`.`id` ORDER BY `post`.`published_time` DESC LIMIT 8 [ RunTime:0.000732s ] [ 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' => 22,
'filtered' => 100.0,
'extra' => 'Using index condition; Using temporary; Using filesort',
) ] [ SQL ] SHOW COLUMNS FROM `cmf_portal_tag` [ RunTime:0.000556s ] [ SQL ] SELECT * FROM `cmf_portal_tag` WHERE `status` = 1 ORDER BY rand() LIMIT 30 [ RunTime:0.000359s ] [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_portal_tag',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 19,
'filtered' => 10.0,
'extra' => 'Using where; Using temporary; Using filesort',
) ]
0.065972s
