[ DB ] CONNECT:[ UseTime:0.000444s ] mysql:host=127.0.0.1;port=3306;dbname=sczymz;charset=utf8
[ SQL ] SHOW COLUMNS FROM `tlk_plugin` [ RunTime:0.000793s ]
[ SQL ] SELECT `config` FROM `tlk_plugin` WHERE `name` = 'SwitchTheme' LIMIT 1 [ RunTime:0.000269s ]
[ SQL ] SHOW COLUMNS FROM `tlk_option` [ RunTime:0.000620s ]
[ SQL ] SELECT `option_value` FROM `tlk_option` WHERE `option_name` = 'cdn_settings' AND `site_id` = 1 LIMIT 1 [ RunTime:0.000248s ]
[ SQL ] SELECT `option_value` FROM `tlk_option` WHERE `option_name` = 'cdn_settings' AND `site_id` = 1 LIMIT 1 [ RunTime:0.000270s ]
[ SQL ] SHOW COLUMNS FROM `tlk_site` [ RunTime:0.000621s ]
[ SQL ] SELECT * FROM `tlk_site` WHERE `abbr` = 'www' LIMIT 1 [ RunTime:0.000254s ]
[ SQL ] SELECT `option_value` FROM `tlk_option` WHERE `option_name` = 'site_info' AND `site_id` = 1 LIMIT 1 [ RunTime:0.000274s ]
[ SQL ] SHOW COLUMNS FROM `tlk_portal_category` [ RunTime:0.000674s ]
[ SQL ] SELECT * FROM `tlk_portal_category` WHERE `id` = 1 AND `status` = 1 LIMIT 1 [ RunTime:0.000325s ]
[ SQL ] SHOW COLUMNS FROM `tlk_theme_file` [ RunTime:0.000712s ]
[ SQL ] SELECT * FROM `tlk_theme_file` WHERE `theme` = 'simpleboot3' AND `file` = 'portal/article-case' LIMIT 1 [ RunTime:0.000290s ]
[ SQL ] UPDATE `tlk_theme_file` SET `theme`='simpleboot3',`action`='portal/Article/index',`file`='portal/article-case',`name`='文章页-案例',`more`='[]',`config_more`='[]',`description`='文章页模板文件',`is_public`=0,`list_order`=10 WHERE `theme` = 'simpleboot3' AND `file` = 'portal/article-case' [ RunTime:0.005307s ]
[ SQL ] SELECT * FROM `tlk_theme_file` WHERE `theme` = 'simpleboot3' AND `file` = 'portal/article-designer' LIMIT 1 [ RunTime:0.000287s ]
[ SQL ] UPDATE `tlk_theme_file` SET `theme`='simpleboot3',`action`='portal/Article/index',`file`='portal/article-designer',`name`='文章页-设计师',`more`='[]',`config_more`='[]',`description`='文章页模板文件',`is_public`=0,`list_order`=10 WHERE `theme` = 'simpleboot3' AND `file` = 'portal/article-designer' [ RunTime:0.004336s ]
[ SQL ] SELECT * FROM `tlk_theme_file` WHERE `theme` = 'simpleboot3' AND `file` = 'portal/article-news' LIMIT 1 [ RunTime:0.000288s ]
[ SQL ] UPDATE `tlk_theme_file` SET `theme`='simpleboot3',`action`='portal/Article/index',`file`='portal/article-news',`name`='文章页-新闻',`more`='[]',`config_more`='[]',`description`='文章页模板文件',`is_public`=0,`list_order`=10 WHERE `theme` = 'simpleboot3' AND `file` = 'portal/article-news' [ RunTime:0.004688s ]
[ SQL ] SELECT * FROM `tlk_theme_file` WHERE `theme` = 'simpleboot3' AND `file` = 'portal/article' LIMIT 1 [ RunTime:0.000274s ]
[ SQL ] UPDATE `tlk_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.004630s ]
[ SQL ] SELECT * FROM `tlk_theme_file` WHERE `theme` = 'simpleboot3' AND `file` = 'portal/brand' LIMIT 1 [ RunTime:0.000363s ]
[ SQL ] UPDATE `tlk_theme_file` SET `theme`='simpleboot3',`action`='portal/List/index',`file`='portal/brand',`name`='品牌探索',`more`='[]',`config_more`='[]',`description`='品牌探索模板文件',`is_public`=0,`list_order`=10 WHERE `theme` = 'simpleboot3' AND `file` = 'portal/brand' [ RunTime:0.004202s ]
[ SQL ] SELECT * FROM `tlk_theme_file` WHERE `theme` = 'simpleboot3' AND `file` = 'portal/calc' LIMIT 1 [ RunTime:0.000348s ]
[ SQL ] UPDATE `tlk_theme_file` SET `theme`='simpleboot3',`action`='portal/List/index',`file`='portal/calc',`name`='装修报价',`more`='[]',`config_more`='[]',`description`='装修报价模板文件',`is_public`=0,`list_order`=10 WHERE `theme` = 'simpleboot3' AND `file` = 'portal/calc' [ RunTime:0.016855s ]
[ SQL ] SELECT * FROM `tlk_theme_file` WHERE `theme` = 'simpleboot3' AND `file` = 'portal/case' LIMIT 1 [ RunTime:0.000363s ]
[ SQL ] UPDATE `tlk_theme_file` SET `theme`='simpleboot3',`action`='portal/List/index',`file`='portal/case',`name`='成功案例',`more`='[]',`config_more`='[]',`description`='成功案例模板文件',`is_public`=0,`list_order`=10 WHERE `theme` = 'simpleboot3' AND `file` = 'portal/case' [ RunTime:0.005080s ]
[ SQL ] SELECT * FROM `tlk_theme_file` WHERE `theme` = 'simpleboot3' AND `file` = 'portal/catering' LIMIT 1 [ RunTime:0.000397s ]
[ SQL ] UPDATE `tlk_theme_file` SET `theme`='simpleboot3',`action`='portal/List/index',`file`='portal/catering',`name`='智能餐饮',`more`='[]',`config_more`='[]',`description`='智能餐饮模板文件',`is_public`=0,`list_order`=10 WHERE `theme` = 'simpleboot3' AND `file` = 'portal/catering' [ RunTime:0.004791s ]
[ SQL ] SELECT * FROM `tlk_theme_file` WHERE `theme` = 'simpleboot3' AND `file` = 'portal/contact' LIMIT 1 [ RunTime:0.000296s ]
[ SQL ] UPDATE `tlk_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.004848s ]
[ SQL ] SELECT * FROM `tlk_theme_file` WHERE `theme` = 'simpleboot3' AND `file` = 'portal/index' LIMIT 1 [ RunTime:0.000385s ]
[ SQL ] UPDATE `tlk_theme_file` SET `theme`='simpleboot3',`action`='portal/Index/index',`file`='portal/index',`name`='首页',`more`='[]',`config_more`='[]',`description`='首页模板文件',`is_public`=0,`list_order`=5 WHERE `theme` = 'simpleboot3' AND `file` = 'portal/index' [ RunTime:0.004996s ]
[ SQL ] SELECT * FROM `tlk_theme_file` WHERE `theme` = 'simpleboot3' AND `file` = 'portal/list' LIMIT 1 [ RunTime:0.000359s ]
[ SQL ] UPDATE `tlk_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.005304s ]
[ SQL ] SELECT * FROM `tlk_theme_file` WHERE `theme` = 'simpleboot3' AND `file` = 'portal/news' LIMIT 1 [ RunTime:0.000350s ]
[ SQL ] UPDATE `tlk_theme_file` SET `theme`='simpleboot3',`action`='portal/List/index',`file`='portal/news',`name`='工装百科',`more`='[]',`config_more`='[]',`description`='工装百科模板文件',`is_public`=0,`list_order`=10 WHERE `theme` = 'simpleboot3' AND `file` = 'portal/news' [ RunTime:0.005147s ]
[ SQL ] SELECT * FROM `tlk_theme_file` WHERE `theme` = 'simpleboot3' AND `file` = 'portal/page' LIMIT 1 [ RunTime:0.000437s ]
[ SQL ] UPDATE `tlk_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.004380s ]
[ SQL ] SELECT * FROM `tlk_theme_file` WHERE `theme` = 'simpleboot3' AND `file` = 'portal/search' LIMIT 1 [ RunTime:0.000322s ]
[ SQL ] UPDATE `tlk_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.004300s ]
[ SQL ] SELECT * FROM `tlk_theme_file` WHERE `theme` = 'simpleboot3' AND `file` = 'portal/tag' LIMIT 1 [ RunTime:0.000300s ]
[ SQL ] UPDATE `tlk_theme_file` SET `theme`='simpleboot3',`action`='portal/tag/index',`file`='portal/tag',`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/tag' [ RunTime:0.005249s ]
[ SQL ] SELECT * FROM `tlk_theme_file` WHERE `theme` = 'simpleboot3' AND `file` = 'portal/team' LIMIT 1 [ RunTime:0.000334s ]
[ SQL ] UPDATE `tlk_theme_file` SET `theme`='simpleboot3',`action`='portal/List/index',`file`='portal/team',`name`='设计团队',`more`='[]',`config_more`='[]',`description`='设计团队模板文件',`is_public`=0,`list_order`=10 WHERE `theme` = 'simpleboot3' AND `file` = 'portal/team' [ RunTime:0.004702s ]
[ SQL ] SELECT * FROM `tlk_theme_file` WHERE `theme` = 'simpleboot3' [ RunTime:0.000567s ]
[ SQL ] SHOW COLUMNS FROM `tlk_theme` [ RunTime:0.000919s ]
[ SQL ] UPDATE `tlk_theme` SET `name`='simpleboot3',`version`='1.0.2',`demo_url`='https://www.tlkjt.com',`author`='wz',`lang`='zh-cn',`author_url`='https://www.tlkjt.com',`keywords`='推来客网站建设',`description`='推来客网站建设' WHERE `theme` = 'simpleboot3' [ RunTime:0.011905s ]
[ SQL ] SELECT `more` FROM `tlk_theme_file` WHERE `theme` = 'simpleboot3' AND ( `is_public` = 1 OR `file` = 'portal/case' ) [ RunTime:0.000369s ]
[ SQL ] SELECT `option_value` FROM `tlk_option` WHERE `option_name` = 'storage' AND `site_id` = 1 LIMIT 1 [ RunTime:0.000335s ]
[ SQL ] SELECT `path` FROM `tlk_portal_category` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000286s ]
[ SQL ] SELECT * FROM `tlk_portal_category` WHERE `id` IN (0,1) ORDER BY `path` ASC [ RunTime:0.000338s ]
[ SQL ] SHOW COLUMNS FROM `tlk_portal_post` [ RunTime:0.000991s ]
[ SQL ] SELECT post.*,min(category_post.category_id) as category_id FROM `tlk_portal_post` `post` INNER JOIN `tlk_portal_category_post` `category_post` ON `post`.`id`=`category_post`.`post_id` WHERE ( `post`.`published_time` > '0' AND `post`.`published_time` < 1614406160 ) AND `post`.`post_status` = 1 AND `post`.`post_type` = 1 AND `post`.`delete_time` = 0 AND `category_post`.`category_id` = '2' GROUP BY `post`.`id` ORDER BY `list_order` ASC,`post`.`is_top` DESC,`post`.`recommended` DESC,`post`.`create_time` DESC LIMIT 10 [ RunTime:0.001157s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM ( SELECT count(*) FROM `tlk_portal_post` `post` INNER JOIN `tlk_portal_category_post` `category_post` ON `post`.`id`=`category_post`.`post_id` WHERE ( `post`.`published_time` > '0' AND `post`.`published_time` < 1614406160 ) AND `post`.`post_status` = 1 AND `post`.`post_type` = 1 AND `post`.`delete_time` = 0 AND `category_post`.`category_id` = '1' AND `case_space` = '商务空间' GROUP BY `post`.`id` ) `_group_count_` LIMIT 1 [ RunTime:0.000899s ]
[ SQL ] SELECT post.*,min(category_post.category_id) as category_id FROM `tlk_portal_post` `post` INNER JOIN `tlk_portal_category_post` `category_post` ON `post`.`id`=`category_post`.`post_id` WHERE ( `post`.`published_time` > '0' AND `post`.`published_time` < 1614406160 ) AND `post`.`post_status` = 1 AND `post`.`post_type` = 1 AND `post`.`delete_time` = 0 AND `category_post`.`category_id` = '1' AND `case_space` = '商务空间' GROUP BY `post`.`id` ORDER BY `list_order` ASC,`post`.`is_top` DESC,`post`.`recommended` DESC,`post`.`create_time` DESC LIMIT 0,12 [ RunTime:0.001189s ]
[ SQL ] SELECT * FROM `tlk_portal_post` WHERE `create_time` >= 0 AND `delete_time` = 0 AND `post_type` = 2 ORDER BY rand() [ RunTime:0.001210s ]
