[ DB ] CONNECT:[ UseTime:1.016985s ] mysql:host=localhost;port=3306;dbname=sbay;charset=utf8
[ SQL ] SHOW COLUMNS FROM `cmf_theme_file` [ RunTime:0.000000s ]
[ SQL ] SELECT * FROM `cmf_theme_file` WHERE `theme` = 'sangbay' AND `file` = 'portal/article' LIMIT 1 [ RunTime:0.000000s ]
[ SQL ] UPDATE `cmf_theme_file` SET `theme`='sangbay',`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`=11 WHERE `theme` = 'sangbay' AND `file` = 'portal/article' [ RunTime:0.000000s ]
[ SQL ] SELECT * FROM `cmf_theme_file` WHERE `theme` = 'sangbay' AND `file` = 'portal/article_product' LIMIT 1 [ RunTime:0.000000s ]
[ SQL ] UPDATE `cmf_theme_file` SET `theme`='sangbay',`action`='portal/Article/index',`file`='portal/article_product',`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`=11 WHERE `theme` = 'sangbay' AND `file` = 'portal/article_product' [ RunTime:0.000000s ]
[ SQL ] SELECT * FROM `cmf_theme_file` WHERE `theme` = 'sangbay' AND `file` = 'portal/index' LIMIT 1 [ RunTime:0.000000s ]
[ SQL ] UPDATE `cmf_theme_file` SET `theme`='sangbay',`action`='portal/index/index',`file`='portal/index',`name`='pc首页',`more`='{\"vars\":[],\"widgets\":{\"frist_section\":{\"title\":\"\\u4ea7\\u54c1\\u4e2d\\u5fc3\",\"display\":1,\"vars\":{\"category_jian\":{\"title\":\"\\u4ea7\\u54c1\\u4e2d\\u5fc3\",\"value\":\"1\",\"type\":\"text\",\"dataSource\":{\"api\":\"portal\\/category\\/index\",\"multi\":false},\"placeholder\":\"\\u8bf7\\u9009\\u62e9\\u680f\\u76ee\",\"tip\":\"\",\"rule\":{\"require\":true},\"valueText\":\"\\u4ea7\\u54c1\\u4e2d\\u5fc3\"}}},\"two_section\":{\"title\":\"\\u89e3\\u51b3\\u65b9\\u6848\",\"display\":1,\"vars\":{\"category_about\":{\"title\":\"\\u89e3\\u51b3\\u65b9\\u6848\",\"value\":\"8\",\"type\":\"text\",\"dataSource\":{\"api\":\"portal\\/category\\/index\",\"multi\":false},\"placeholder\":\"\\u8bf7\\u9009\\u62e9\\u680f\\u76ee\",\"tip\":\"\",\"rule\":{\"require\":true},\"valueText\":\"\\u89e3\\u51b3\\u65b9\\u6848\"}}},\"three_section\":{\"title\":\"\\u884c\\u4e1a\\u65b0\\u95fb\",\"display\":1,\"vars\":{\"category_layout\":{\"title\":\"\\u884c\\u4e1a\\u65b0\\u95fb\",\"value\":\"3\",\"type\":\"text\",\"dataSource\":{\"api\":\"portal\\/category\\/index\",\"multi\":true},\"placeholder\":\"\\u8bf7\\u9009\\u62e9\\u680f\\u76ee\",\"tip\":\"\",\"rule\":{\"require\":true},\"valueText\":\"\\u65b0\\u95fb\\u8d44\\u8baf\"}}},\"four_section\":{\"title\":\"\\u5e38\\u89c1\\u95ee\\u9898\",\"display\":1,\"vars\":{\"category_news\":{\"title\":\"\\u5e38\\u89c1\\u95ee\\u9898\",\"value\":\"10\",\"type\":\"text\",\"dataSource\":{\"api\":\"portal\\/category\\/index\",\"multi\":false},\"placeholder\":\"\\u8bf7\\u9009\\u62e9\\u680f\\u76ee\",\"tip\":\"\",\"rule\":{\"require\":true},\"valueText\":\"\\u5e38\\u89c1\\u95ee\\u9898\"}}}}}',`config_more`='{\"vars\":[],\"widgets\":{\"frist_section\":{\"title\":\"\\u4ea7\\u54c1\\u4e2d\\u5fc3\",\"display\":\"1\",\"vars\":{\"category_jian\":{\"title\":\"\\u4ea7\\u54c1\\u4e2d\\u5fc3\",\"value\":\"4\",\"type\":\"text\",\"dataSource\":{\"api\":\"portal\\/category\\/index\",\"multi\":false},\"placeholder\":\"\\u8bf7\\u9009\\u62e9\\u680f\\u76ee\",\"tip\":\"\",\"rule\":{\"require\":true}}}},\"two_section\":{\"title\":\"\\u89e3\\u51b3\\u65b9\\u6848\",\"display\":\"1\",\"vars\":{\"category_about\":{\"title\":\"\\u89e3\\u51b3\\u65b9\\u6848\",\"value\":\"8\",\"type\":\"text\",\"dataSource\":{\"api\":\"portal\\/category\\/index\",\"multi\":false},\"placeholder\":\"\\u8bf7\\u9009\\u62e9\\u680f\\u76ee\",\"tip\":\"\",\"rule\":{\"require\":true}}}},\"three_section\":{\"title\":\"\\u884c\\u4e1a\\u65b0\\u95fb\",\"display\":\"1\",\"vars\":{\"category_layout\":{\"title\":\"\\u884c\\u4e1a\\u65b0\\u95fb\",\"value\":\"3\",\"type\":\"text\",\"dataSource\":{\"api\":\"portal\\/category\\/index\",\"multi\":true},\"placeholder\":\"\\u8bf7\\u9009\\u62e9\\u680f\\u76ee\",\"tip\":\"\",\"rule\":{\"require\":true}}}},\"four_section\":{\"title\":\"\\u5e38\\u89c1\\u95ee\\u9898\",\"display\":\"1\",\"vars\":{\"category_news\":{\"title\":\"\\u5e38\\u89c1\\u95ee\\u9898\",\"value\":\"7\",\"type\":\"text\",\"dataSource\":{\"api\":\"portal\\/category\\/index\",\"multi\":false},\"placeholder\":\"\\u8bf7\\u9009\\u62e9\\u680f\\u76ee\",\"tip\":\"\",\"rule\":{\"require\":true}}}}}}',`description`='pc设置',`is_public`=0,`list_order`=10 WHERE `theme` = 'sangbay' AND `file` = 'portal/index' [ RunTime:0.015586s ]
[ SQL ] SELECT * FROM `cmf_theme_file` WHERE `theme` = 'sangbay' AND `file` = 'portal/list' LIMIT 1 [ RunTime:0.000000s ]
[ SQL ] UPDATE `cmf_theme_file` SET `theme`='sangbay',`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` = 'sangbay' AND `file` = 'portal/list' [ RunTime:0.000000s ]
[ SQL ] SELECT * FROM `cmf_theme_file` WHERE `theme` = 'sangbay' AND `file` = 'portal/list_news' LIMIT 1 [ RunTime:0.000000s ]
[ SQL ] UPDATE `cmf_theme_file` SET `theme`='sangbay',`action`='portal/List/index',`file`='portal/list_news',`name`='新闻动态',`more`='{\"vars\":[],\"widgets\":{\"new_case\":{\"title\":\"\\u65b0\\u95fb\",\"display\":\"1\",\"vars\":{\"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\":{\"new_case\":{\"title\":\"\\u65b0\\u95fb\",\"display\":\"1\",\"vars\":{\"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` = 'sangbay' AND `file` = 'portal/list_news' [ RunTime:0.000000s ]
[ SQL ] SELECT * FROM `cmf_theme_file` WHERE `theme` = 'sangbay' AND `file` = 'portal/list_product' LIMIT 1 [ RunTime:0.000000s ]
[ SQL ] UPDATE `cmf_theme_file` SET `theme`='sangbay',`action`='portal/List/index',`file`='portal/list_product',`name`='产品中心',`more`='{\"vars\":[]}',`config_more`='{\"vars\":[]}',`description`='产品中心模板文件',`is_public`=0,`list_order`=10 WHERE `theme` = 'sangbay' AND `file` = 'portal/list_product' [ RunTime:0.000000s ]
[ SQL ] SELECT * FROM `cmf_theme_file` WHERE `theme` = 'sangbay' AND `file` = 'portal/page_about' LIMIT 1 [ RunTime:0.000000s ]
[ SQL ] UPDATE `cmf_theme_file` SET `theme`='sangbay',`action`='portal/Page/index',`file`='portal/page_about',`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}}}}}}',`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}}}}}}',`description`='关于我们单页面模板文件',`is_public`=0,`list_order`=10 WHERE `theme` = 'sangbay' AND `file` = 'portal/page_about' [ RunTime:0.000000s ]
[ SQL ] SELECT * FROM `cmf_theme_file` WHERE `theme` = 'sangbay' AND `file` = 'portal/page_message' LIMIT 1 [ RunTime:0.000000s ]
[ SQL ] UPDATE `cmf_theme_file` SET `theme`='sangbay',`action`='portal/Page/index',`file`='portal/page_message',`name`='在线留言单页面',`more`='[]',`config_more`='[]',`description`='在线留言模板文件',`is_public`=0,`list_order`=10 WHERE `theme` = 'sangbay' AND `file` = 'portal/page_message' [ RunTime:0.015586s ]
[ SQL ] SELECT * FROM `cmf_theme_file` WHERE `theme` = 'sangbay' AND `file` = 'portal/search' LIMIT 1 [ RunTime:0.000000s ]
[ SQL ] UPDATE `cmf_theme_file` SET `theme`='sangbay',`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` = 'sangbay' AND `file` = 'portal/search' [ RunTime:0.000000s ]
[ SQL ] SELECT * FROM `cmf_theme_file` WHERE `theme` = 'sangbay' AND `file` = 'public/config' LIMIT 1 [ RunTime:0.000000s ]
[ SQL ] UPDATE `cmf_theme_file` SET `theme`='sangbay',`action`='public/Config',`file`='public/config',`name`='模板全局配置',`more`='{\"vars\":[],\"widgets\":{\"contact_us\":{\"title\":\"\\u8054\\u7cfb\\u6211\\u4eec\",\"display\":1,\"vars\":{\"category_id\":{\"title\":\"\\u8054\\u7cfb\\u6211\\u4eec\\u5355\\u9875\",\"value\":\"18\",\"type\":\"text\",\"dataSource\":{\"api\":\"portal\\/Page\\/index\",\"multi\":true},\"placeholder\":\"\\u8bf7\\u9009\\u62e9\\u8054\\u7cfb\\u6211\\u4eec\\u5355\\u9875\",\"tip\":\"\",\"rule\":{\"require\":true},\"valueText\":\"\\u8054\\u7cfb\\u6211\\u4eec\"}}}}}',`config_more`='{\"vars\":[],\"widgets\":{\"contact_us\":{\"title\":\"\\u8054\\u7cfb\\u6211\\u4eec\",\"display\":\"1\",\"vars\":{\"category_id\":{\"title\":\"\\u8054\\u7cfb\\u6211\\u4eec\\u5355\\u9875\",\"value\":\"\",\"type\":\"text\",\"dataSource\":{\"api\":\"portal\\/Page\\/index\",\"multi\":true},\"placeholder\":\"\\u8bf7\\u9009\\u62e9\\u8054\\u7cfb\\u6211\\u4eec\\u5355\\u9875\",\"tip\":\"\",\"rule\":{\"require\":true}}}}}}',`description`='模板全局配置文件',`is_public`=1,`list_order`=0 WHERE `theme` = 'sangbay' AND `file` = 'public/config' [ RunTime:0.000000s ]
[ SQL ] SELECT * FROM `cmf_theme_file` WHERE `theme` = 'sangbay' AND `file` = 'public/nav' LIMIT 1 [ RunTime:0.000000s ]
[ SQL ] UPDATE `cmf_theme_file` SET `theme`='sangbay',`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` = 'sangbay' AND `file` = 'public/nav' [ RunTime:0.000000s ]
[ SQL ] SELECT * FROM `cmf_theme_file` WHERE `theme` = 'sangbay' [ RunTime:0.000000s ]
[ SQL ] SHOW COLUMNS FROM `cmf_theme` [ RunTime:0.015586s ]
[ SQL ] UPDATE `cmf_theme` SET `name`='sangbay',`version`='1.0.0',`author`='松柏传感',`lang`='zh-cn',`author_url`='http://www.XXX.com',`keywords`='上海松柏传感技术有限公司',`description`='上海松柏传感技术有限公司' WHERE `theme` = 'sangbay' [ RunTime:0.000000s ]
[ SQL ] SELECT `more` FROM `cmf_theme_file` WHERE `theme` = 'sangbay' AND ( `is_public` = 1 OR `file` = 'portal/index' ) [ RunTime:0.000000s ]
[ SQL ] SHOW COLUMNS FROM `cmf_nav_menu` [ RunTime:0.015586s ]
[ SQL ] SELECT * FROM `cmf_nav_menu` WHERE `nav_id` = 1 AND `status` = 1 ORDER BY list_order ASC [ RunTime:0.000000s ]
[ SQL ] SHOW COLUMNS FROM `cmf_portal_category` [ RunTime:0.000000s ]
[ SQL ] SELECT `path` FROM `cmf_portal_category` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000000s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `path` LIKE '0-1-%' [ RunTime:0.000000s ]
[ SQL ] SHOW COLUMNS FROM `cmf_portal_post` [ RunTime:0.000000s ]
[ SQL ] SELECT `post`.*,min(category_post.category_id) as category_id FROM `cmf_portal_post` `post` INNER JOIN `cmf_portal_category_post` `category_post` ON `post`.`id`=`category_post`.`post_id` WHERE ( `post`.`published_time` > '0' AND `post`.`published_time` < 1620967405 ) AND `post`.`post_status` = 1 AND `post`.`post_type` = 1 AND `post`.`delete_time` = 0 AND `category_post`.`category_id` IN ('1','2','7','9','11','12','13','14','15','16','17','18','19','20','21','22','23','24') AND `post`.`is_top` = 1 GROUP BY `post`.`id` ORDER BY id DESC LIMIT 3 [ RunTime:0.015586s ]
[ SQL ] SHOW COLUMNS FROM `cmf_slide` [ RunTime:0.000000s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `cmf_slide` WHERE `id` = 1 AND `status` = 1 AND `delete_time` = 0 LIMIT 1 [ RunTime:0.000000s ]
[ SQL ] SHOW COLUMNS FROM `cmf_slide_item` [ RunTime:0.000000s ]
[ SQL ] SELECT * FROM `cmf_slide_item` WHERE `status` = 1 AND `slide_id` = 1 ORDER BY list_order ASC [ RunTime:0.000000s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 1 [ RunTime:0.000000s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 2 [ RunTime:0.000000s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 11 [ RunTime:0.015586s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 13 [ RunTime:0.000000s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 23 [ RunTime:0.000000s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 1 [ RunTime:0.000000s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 1 [ RunTime:0.000000s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 2 [ RunTime:0.000000s ]
[ SQL ] SELECT `post`.*,min(category_post.category_id) as category_id FROM `cmf_portal_post` `post` INNER JOIN `cmf_portal_category_post` `category_post` ON `post`.`id`=`category_post`.`post_id` WHERE ( `post`.`published_time` > '0' AND `post`.`published_time` < 1620967405 ) AND `post`.`post_status` = 1 AND `post`.`post_type` = 1 AND `post`.`delete_time` = 0 AND `category_post`.`category_id` IN ('2','7','9','15','16','17','18') GROUP BY `post`.`id` ORDER BY post.create_time ASC LIMIT 20 [ RunTime:0.015586s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 11 [ RunTime:0.000000s ]
[ SQL ] SELECT `post`.*,min(category_post.category_id) as category_id FROM `cmf_portal_post` `post` INNER JOIN `cmf_portal_category_post` `category_post` ON `post`.`id`=`category_post`.`post_id` WHERE ( `post`.`published_time` > '0' AND `post`.`published_time` < 1620967405 ) AND `post`.`post_status` = 1 AND `post`.`post_type` = 1 AND `post`.`delete_time` = 0 AND `category_post`.`category_id` IN ('11','12','19','20') GROUP BY `post`.`id` ORDER BY post.create_time ASC LIMIT 20 [ RunTime:0.015586s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 13 [ RunTime:0.000000s ]
[ SQL ] SELECT `post`.*,min(category_post.category_id) as category_id FROM `cmf_portal_post` `post` INNER JOIN `cmf_portal_category_post` `category_post` ON `post`.`id`=`category_post`.`post_id` WHERE ( `post`.`published_time` > '0' AND `post`.`published_time` < 1620967405 ) AND `post`.`post_status` = 1 AND `post`.`post_type` = 1 AND `post`.`delete_time` = 0 AND `category_post`.`category_id` IN ('13','14','21','22') GROUP BY `post`.`id` ORDER BY post.create_time ASC LIMIT 20 [ RunTime:0.015586s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 23 [ RunTime:0.000000s ]
[ SQL ] SELECT `post`.*,min(category_post.category_id) as category_id FROM `cmf_portal_post` `post` INNER JOIN `cmf_portal_category_post` `category_post` ON `post`.`id`=`category_post`.`post_id` WHERE ( `post`.`published_time` > '0' AND `post`.`published_time` < 1620967405 ) AND `post`.`post_status` = 1 AND `post`.`post_type` = 1 AND `post`.`delete_time` = 0 AND `category_post`.`category_id` IN ('23','24') GROUP BY `post`.`id` ORDER BY post.create_time ASC LIMIT 20 [ RunTime:0.000000s ]
[ SQL ] SELECT `post`.*,min(category_post.category_id) as category_id FROM `cmf_portal_post` `post` INNER JOIN `cmf_portal_category_post` `category_post` ON `post`.`id`=`category_post`.`post_id` WHERE ( `post`.`published_time` > '0' AND `post`.`published_time` < 1620967405 ) AND `post`.`post_status` = 1 AND `post`.`post_type` = 1 AND `post`.`delete_time` = 0 AND `category_post`.`category_id` = '8' AND `post`.`recommended` = 1 GROUP BY `post`.`id` ORDER BY post.create_time DESC LIMIT 4 [ RunTime:0.015586s ]
[ SQL ] SELECT `post`.*,min(category_post.category_id) as category_id FROM `cmf_portal_post` `post` INNER JOIN `cmf_portal_category_post` `category_post` ON `post`.`id`=`category_post`.`post_id` WHERE ( `post`.`published_time` > '0' AND `post`.`published_time` < 1620967405 ) AND `post`.`post_status` = 1 AND `post`.`post_type` = 1 AND `post`.`delete_time` = 0 AND `category_post`.`category_id` = '3' AND `post`.`recommended` = 1 GROUP BY `post`.`id` ORDER BY post.create_time DESC LIMIT 1 [ RunTime:0.000000s ]
[ SQL ] SELECT `post`.*,min(category_post.category_id) as category_id FROM `cmf_portal_post` `post` INNER JOIN `cmf_portal_category_post` `category_post` ON `post`.`id`=`category_post`.`post_id` WHERE ( `post`.`published_time` > '0' AND `post`.`published_time` < 1620967405 ) AND `post`.`post_status` = 1 AND `post`.`post_type` = 1 AND `post`.`delete_time` = 0 AND `category_post`.`category_id` = '3' GROUP BY `post`.`id` ORDER BY post.create_time DESC LIMIT 8 [ RunTime:0.000000s ]
[ SQL ] SELECT `post`.*,min(category_post.category_id) as category_id FROM `cmf_portal_post` `post` INNER JOIN `cmf_portal_category_post` `category_post` ON `post`.`id`=`category_post`.`post_id` WHERE ( `post`.`published_time` > '0' AND `post`.`published_time` < 1620967405 ) AND `post`.`post_status` = 1 AND `post`.`post_type` = 1 AND `post`.`delete_time` = 0 AND `category_post`.`category_id` = '10' AND `post`.`recommended` = 1 GROUP BY `post`.`id` ORDER BY post.create_time DESC LIMIT 1 [ RunTime:0.000000s ]
[ SQL ] SELECT `post`.*,min(category_post.category_id) as category_id FROM `cmf_portal_post` `post` INNER JOIN `cmf_portal_category_post` `category_post` ON `post`.`id`=`category_post`.`post_id` WHERE ( `post`.`published_time` > '0' AND `post`.`published_time` < 1620967405 ) AND `post`.`post_status` = 1 AND `post`.`post_type` = 1 AND `post`.`delete_time` = 0 AND `category_post`.`category_id` = '10' GROUP BY `post`.`id` ORDER BY post.create_time DESC LIMIT 8 [ RunTime:0.000000s ]
[ SQL ] SHOW COLUMNS FROM `cmf_link` [ RunTime:0.015586s ]
[ SQL ] SELECT * FROM `cmf_link` WHERE `status` = 1 ORDER BY list_order ASC [ RunTime:0.000000s ]
[ SQL ] SELECT * FROM `cmf_nav_menu` WHERE `nav_id` = 2 AND `status` = 1 ORDER BY list_order ASC [ RunTime:0.000000s ]
[ SQL ] SELECT `nav_id` FROM `cmf_nav_menu` WHERE `id` = 27 AND `status` = 1 LIMIT 1 [ RunTime:0.000000s ]
[ SQL ] SELECT * FROM `cmf_nav_menu` WHERE `nav_id` = 2 AND `status` = 1 ORDER BY list_order ASC [ RunTime:0.000000s ]
[ SQL ] SELECT `nav_id` FROM `cmf_nav_menu` WHERE `id` = 30 AND `status` = 1 LIMIT 1 [ RunTime:0.000000s ]
[ SQL ] SELECT * FROM `cmf_nav_menu` WHERE `nav_id` = 2 AND `status` = 1 ORDER BY list_order ASC [ RunTime:0.000000s ]
[ SQL ] SELECT `nav_id` FROM `cmf_nav_menu` WHERE `id` = 39 AND `status` = 1 LIMIT 1 [ RunTime:0.000000s ]
[ SQL ] SELECT * FROM `cmf_nav_menu` WHERE `nav_id` = 2 AND `status` = 1 ORDER BY list_order ASC [ RunTime:0.000000s ]
