[ DB ] CONNECT:[ UseTime:1.003842s ] mysql:host=localhost;port=3306;dbname=chinaburn;charset=utf8mb4
[ SQL ] SHOW COLUMNS FROM `ct_portal_post` [ RunTime:0.005859s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `ct_portal_post` `a` INNER JOIN `ct_user` `u` ON `a`.`user_id`=`u`.`id` INNER JOIN `ct_portal_category_post` `b` ON `a`.`id`=`b`.`post_id` WHERE `a`.`create_time` >= 0 AND `a`.`delete_time` = 0 AND `b`.`category_id` = 99 AND `a`.`post_type` = 1 LIMIT 1 [ RunTime:0.002930s ]
[ SQL ] SELECT `a`.*,b.id AS post_category_id,`b`.`list_order`,`b`.`category_id` FROM `ct_portal_post` `a` INNER JOIN `ct_user` `u` ON `a`.`user_id`=`u`.`id` INNER JOIN `ct_portal_category_post` `b` ON `a`.`id`=`b`.`post_id` WHERE `a`.`create_time` >= 0 AND `a`.`delete_time` = 0 AND `b`.`category_id` = 99 AND `a`.`post_type` = 1 ORDER BY `is_top` DESC,`published_time` DESC LIMIT 0,1 [ RunTime:0.003906s ]
[ SQL ] SHOW COLUMNS FROM `ct_portal_category` [ RunTime:0.005859s ]
[ SQL ] SELECT * FROM `ct_portal_category` WHERE `id` = 99 LIMIT 1 [ RunTime:0.000000s ]
[ SQL ] SELECT `name` FROM `ct_portal_category` WHERE `id` = 8 LIMIT 1 [ RunTime:0.000000s ]
[ SQL ] SELECT `id`,`name` FROM `ct_portal_category` WHERE `parent_id` = 99 [ RunTime:0.000976s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `ct_portal_post` `a` INNER JOIN `ct_user` `u` ON `a`.`user_id`=`u`.`id` INNER JOIN `ct_portal_category_post` `b` ON `a`.`id`=`b`.`post_id` WHERE `a`.`create_time` >= 0 AND `a`.`delete_time` = 0 AND `b`.`category_id` = 26 AND `a`.`post_type` = 1 LIMIT 1 [ RunTime:0.001953s ]
[ SQL ] SELECT `a`.*,b.id AS post_category_id,`b`.`list_order`,`b`.`category_id` FROM `ct_portal_post` `a` INNER JOIN `ct_user` `u` ON `a`.`user_id`=`u`.`id` INNER JOIN `ct_portal_category_post` `b` ON `a`.`id`=`b`.`post_id` WHERE `a`.`create_time` >= 0 AND `a`.`delete_time` = 0 AND `b`.`category_id` = 26 AND `a`.`post_type` = 1 ORDER BY `is_top` DESC,`published_time` DESC LIMIT 0,8 [ RunTime:0.005859s ]
[ SQL ] SHOW COLUMNS FROM `ct_theme_file` [ RunTime:0.006836s ]
[ SQL ] SELECT * FROM `ct_theme_file` WHERE `theme` = 'simpleboot3' AND `file` = 'portal/article' LIMIT 1 [ RunTime:0.000000s ]
[ SQL ] UPDATE `ct_theme_file` SET `theme`='simpleboot3',`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` = 'simpleboot3' AND `file` = 'portal/article' [ RunTime:0.001953s ]
[ SQL ] SELECT * FROM `ct_theme_file` WHERE `theme` = 'simpleboot3' AND `file` = 'portal/contact' LIMIT 1 [ RunTime:0.000000s ]
[ SQL ] UPDATE `ct_theme_file` SET `theme`='simpleboot3',`action`='portal/Page/index',`file`='portal/contact',`name`='聯系我們頁',`more`='{\"vars\":{\"baidu_map_info_window_text\":{\"title\":\"\\u767e\\u5ea6\\u5730\\u56fe\\u6807\\u6ce8\\u6587\\u5b57\",\"name\":\"baidu_map_info_window_text\",\"value\":\"ThinkCMF<br\\/><span class=\'\'>\\u5730\\u5740\\uff1a\\u4e0a\\u6d77\\u5e02\\u5f90\\u6c47\\u533a\\u659c\\u571f\\u8def2601\\u53f7<\\/span>\",\"type\":\"text\",\"tip\":\"\\u767e\\u5ea6\\u5730\\u56fe\\u6807\\u6ce8\\u6587\\u5b57,\\u652f\\u6301\\u7b80\\u5355html\\u4ee3\\u7801\",\"rule\":[]},\"company_location\":{\"title\":\"\\u516c\\u53f8\\u5750\\u6807\",\"value\":\"\",\"type\":\"location\",\"tip\":\"\",\"rule\":{\"require\":true}},\"address_cn\":{\"title\":\"\\u516c\\u53f8\\u5730\\u5740\",\"value\":\"\\u4e0a\\u6d77\\u5e02\\u5f90\\u6c47\\u533a\\u659c\\u571f\\u8def0001\\u53f7\",\"type\":\"text\",\"tip\":\"\",\"rule\":{\"require\":true}},\"address_en\":{\"title\":\"\\u516c\\u53f8\\u5730\\u5740\\uff08\\u82f1\\u6587\\uff09\",\"value\":\"NO.0001 Xie Tu Road, Shanghai China\",\"type\":\"text\",\"tip\":\"\",\"rule\":{\"require\":true}},\"email\":{\"title\":\"\\u516c\\u53f8\\u90ae\\u7bb1\",\"value\":\"catman@thinkcmf.com\",\"type\":\"text\",\"tip\":\"\",\"rule\":{\"require\":true}},\"phone_cn\":{\"title\":\"\\u516c\\u53f8\\u7535\\u8bdd\",\"value\":\"021 1000 0001\",\"type\":\"text\",\"tip\":\"\",\"rule\":{\"require\":true}},\"phone_en\":{\"title\":\"\\u516c\\u53f8\\u7535\\u8bdd\\uff08\\u82f1\\u6587\\uff09\",\"value\":\"+8621 1000 0001\",\"type\":\"text\",\"tip\":\"\",\"rule\":{\"require\":true}},\"qq\":{\"title\":\"\\u8054\\u7cfbQQ\",\"value\":\"478519726\",\"type\":\"text\",\"tip\":\"\\u591a\\u4e2a QQ\\u4ee5\\u82f1\\u6587\\u9017\\u53f7\\u9694\\u5f00\",\"rule\":{\"require\":true}}}}',`config_more`='{\"vars\":{\"baidu_map_info_window_text\":{\"title\":\"\\u767e\\u5ea6\\u5730\\u56fe\\u6807\\u6ce8\\u6587\\u5b57\",\"name\":\"baidu_map_info_window_text\",\"value\":\"ThinkCMF<br\\/><span class=\'\'>\\u5730\\u5740\\uff1a\\u4e0a\\u6d77\\u5e02\\u5f90\\u6c47\\u533a\\u659c\\u571f\\u8def2601\\u53f7<\\/span>\",\"type\":\"text\",\"tip\":\"\\u767e\\u5ea6\\u5730\\u56fe\\u6807\\u6ce8\\u6587\\u5b57,\\u652f\\u6301\\u7b80\\u5355html\\u4ee3\\u7801\",\"rule\":[]},\"company_location\":{\"title\":\"\\u516c\\u53f8\\u5750\\u6807\",\"value\":\"\",\"type\":\"location\",\"tip\":\"\",\"rule\":{\"require\":true}},\"address_cn\":{\"title\":\"\\u516c\\u53f8\\u5730\\u5740\",\"value\":\"\\u4e0a\\u6d77\\u5e02\\u5f90\\u6c47\\u533a\\u659c\\u571f\\u8def0001\\u53f7\",\"type\":\"text\",\"tip\":\"\",\"rule\":{\"require\":true}},\"address_en\":{\"title\":\"\\u516c\\u53f8\\u5730\\u5740\\uff08\\u82f1\\u6587\\uff09\",\"value\":\"NO.0001 Xie Tu Road, Shanghai China\",\"type\":\"text\",\"tip\":\"\",\"rule\":{\"require\":true}},\"email\":{\"title\":\"\\u516c\\u53f8\\u90ae\\u7bb1\",\"value\":\"catman@thinkcmf.com\",\"type\":\"text\",\"tip\":\"\",\"rule\":{\"require\":true}},\"phone_cn\":{\"title\":\"\\u516c\\u53f8\\u7535\\u8bdd\",\"value\":\"021 1000 0001\",\"type\":\"text\",\"tip\":\"\",\"rule\":{\"require\":true}},\"phone_en\":{\"title\":\"\\u516c\\u53f8\\u7535\\u8bdd\\uff08\\u82f1\\u6587\\uff09\",\"value\":\"+8621 1000 0001\",\"type\":\"text\",\"tip\":\"\",\"rule\":{\"require\":true}},\"qq\":{\"title\":\"\\u8054\\u7cfbQQ\",\"value\":\"478519726\",\"type\":\"text\",\"tip\":\"\\u591a\\u4e2a QQ\\u4ee5\\u82f1\\u6587\\u9017\\u53f7\\u9694\\u5f00\",\"rule\":{\"require\":true}}}}',`description`='聯系我們頁模板文件',`is_public`=0,`list_order`=10 WHERE `theme` = 'simpleboot3' AND `file` = 'portal/contact' [ RunTime:0.002929s ]
[ SQL ] SELECT * FROM `ct_theme_file` WHERE `theme` = 'simpleboot3' AND `file` = 'portal/list' LIMIT 1 [ RunTime:0.000976s ]
[ SQL ] UPDATE `ct_theme_file` SET `theme`='simpleboot3',`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` = 'simpleboot3' AND `file` = 'portal/list' [ RunTime:0.002930s ]
[ SQL ] SELECT * FROM `ct_theme_file` WHERE `theme` = 'simpleboot3' AND `file` = 'portal/page' LIMIT 1 [ RunTime:0.000977s ]
[ SQL ] UPDATE `ct_theme_file` SET `theme`='simpleboot3',`action`='portal/Page/index',`file`='portal/page',`name`='單頁面',`more`='{\"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`='{\"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` = 'simpleboot3' AND `file` = 'portal/page' [ RunTime:0.003906s ]
[ SQL ] SELECT * FROM `ct_theme_file` WHERE `theme` = 'simpleboot3' AND `file` = 'portal/search' LIMIT 1 [ RunTime:0.000000s ]
[ SQL ] UPDATE `ct_theme_file` SET `theme`='simpleboot3',`action`='portal/search/index',`file`='portal/search',`name`='搜索頁面',`more`='{\"vars\":{\"varName1\":{\"title\":\"\\u70ed\\u95e8\\u641c\\u7d22\",\"value\":\"1\",\"type\":\"text\",\"tip\":\"\\u8fd9\\u662f\\u4e00\\u4e2atext\",\"rule\":{\"require\":true}}}}',`config_more`='{\"vars\":{\"varName1\":{\"title\":\"\\u70ed\\u95e8\\u641c\\u7d22\",\"value\":\"1\",\"type\":\"text\",\"tip\":\"\\u8fd9\\u662f\\u4e00\\u4e2atext\",\"rule\":{\"require\":true}}}}',`description`='搜索模板文件',`is_public`=0,`list_order`=10 WHERE `theme` = 'simpleboot3' AND `file` = 'portal/search' [ RunTime:0.001953s ]
[ SQL ] SELECT * FROM `ct_theme_file` WHERE `theme` = 'simpleboot3' AND `file` = 'public/config' LIMIT 1 [ RunTime:0.000976s ]
[ SQL ] UPDATE `ct_theme_file` SET `theme`='simpleboot3',`action`='public/Config',`file`='public/config',`name`='模板全局配置',`more`='{\"vars\":{\"enable_mobile\":{\"title\":\"\\u624b\\u673a\\u6ce8\\u518c\",\"value\":1,\"type\":\"select\",\"options\":{\"1\":\"\\u5f00\\u542f\",\"0\":\"\\u5173\\u95ed\"},\"tip\":\"\"}}}',`config_more`='{\"vars\":{\"enable_mobile\":{\"title\":\"\\u624b\\u673a\\u6ce8\\u518c\",\"value\":1,\"type\":\"select\",\"options\":{\"1\":\"\\u5f00\\u542f\",\"0\":\"\\u5173\\u95ed\"},\"tip\":\"\"}}}',`description`='模板全局配置文件',`is_public`=1,`list_order`=0 WHERE `theme` = 'simpleboot3' AND `file` = 'public/config' [ RunTime:0.004883s ]
[ SQL ] SELECT * FROM `ct_theme_file` WHERE `theme` = 'simpleboot3' AND `file` = 'public/nav' LIMIT 1 [ RunTime:0.000000s ]
[ SQL ] UPDATE `ct_theme_file` SET `theme`='simpleboot3',`action`='public/Nav',`file`='public/nav',`name`='導航條',`more`='{\"vars\":{\"company_name\":{\"title\":\"\\u516c\\u53f8\\u540d\\u79f0\",\"name\":\"company_name\",\"value\":\"ThinkCMF\",\"type\":\"text\",\"tip\":\"\",\"rule\":[]}}}',`config_more`='{\"vars\":{\"company_name\":{\"title\":\"\\u516c\\u53f8\\u540d\\u79f0\",\"name\":\"company_name\",\"value\":\"ThinkCMF\",\"type\":\"text\",\"tip\":\"\",\"rule\":[]}}}',`description`='導航條模板文件',`is_public`=1,`list_order`=1 WHERE `theme` = 'simpleboot3' AND `file` = 'public/nav' [ RunTime:0.003906s ]
[ SQL ] SELECT * FROM `ct_theme_file` WHERE `theme` = 'simpleboot3' [ RunTime:0.000977s ]
[ SQL ] SHOW COLUMNS FROM `ct_theme` [ RunTime:0.004883s ]
[ SQL ] UPDATE `ct_theme` SET `name`='simpleboot3',`version`='1.0.2',`demo_url`='http://demo.thinkcmf.com',`author`='ThinkCMF',`lang`='zh-cn',`author_url`='http://www.thinkcmf.com',`keywords`='ThinkCMF模板',`description`='ThinkCMF默認模板' WHERE `theme` = 'simpleboot3' [ RunTime:0.005859s ]
[ SQL ] SELECT `more` FROM `ct_theme_file` WHERE `theme` = 'simpleboot3' AND ( `is_public` = 1 OR `file` = 'portal/shaoshang' ) [ RunTime:0.000000s ]
[ SQL ] SELECT post.*,min(category_post.category_id) as category_id FROM `ct_portal_post` `post` INNER JOIN `ct_portal_category_post` `category_post` ON `post`.`id`=`category_post`.`post_id` WHERE ( `post`.`published_time` > '0' AND `post`.`published_time` < 1654480334 ) AND `post`.`post_status` = 1 AND `post`.`post_type` = 1 AND `post`.`delete_time` = 0 AND `category_post`.`category_id` = '198' GROUP BY `post`.`id` ORDER BY `post`.`published_time` DESC LIMIT 10 [ RunTime:0.003906s ]
[ SQL ] SELECT post.*,min(category_post.category_id) as category_id FROM `ct_portal_post` `post` INNER JOIN `ct_portal_category_post` `category_post` ON `post`.`id`=`category_post`.`post_id` WHERE ( `post`.`published_time` > '0' AND `post`.`published_time` < 1654480334 ) AND `post`.`post_status` = 1 AND `post`.`post_type` = 1 AND `post`.`delete_time` = 0 AND `category_post`.`category_id` = '199' GROUP BY `post`.`id` ORDER BY `post`.`published_time` DESC LIMIT 10 [ RunTime:0.003906s ]
[ SQL ] SELECT post.*,min(category_post.category_id) as category_id FROM `ct_portal_post` `post` INNER JOIN `ct_portal_category_post` `category_post` ON `post`.`id`=`category_post`.`post_id` WHERE ( `post`.`published_time` > '0' AND `post`.`published_time` < 1654480334 ) AND `post`.`post_status` = 1 AND `post`.`post_type` = 1 AND `post`.`delete_time` = 0 AND `category_post`.`category_id` = '200' GROUP BY `post`.`id` ORDER BY `post`.`published_time` DESC LIMIT 10 [ RunTime:0.005859s ]
[ SQL ] SELECT * FROM `ct_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 8 ORDER BY `list_order` ASC [ RunTime:0.000000s ]
[ SQL ] SELECT post.*,min(category_post.category_id) as category_id FROM `ct_portal_post` `post` INNER JOIN `ct_portal_category_post` `category_post` ON `post`.`id`=`category_post`.`post_id` WHERE ( `post`.`published_time` > '0' AND `post`.`published_time` < 1654480334 ) AND `post`.`post_status` = 1 AND `post`.`post_type` = 1 AND `post`.`delete_time` = 0 AND `category_post`.`category_id` = '25' GROUP BY `post`.`id` ORDER BY `post`.`is_top` DESC,`post`.`published_time` DESC,`post`.`recommended` DESC LIMIT 3 [ RunTime:0.004883s ]
[ SQL ] SELECT * FROM `ct_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 246 ORDER BY `list_order` ASC [ RunTime:0.000977s ]
[ SQL ] SELECT * FROM `ct_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 247 ORDER BY `list_order` ASC [ RunTime:0.000976s ]
[ SQL ] SELECT * FROM `ct_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 248 ORDER BY `list_order` ASC [ RunTime:0.000977s ]
[ SQL ] SELECT * FROM `ct_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 249 ORDER BY `list_order` ASC [ RunTime:0.000976s ]