[ SQL ] SELECT `post`.* FROM `hz_portal_post` `post` INNER JOIN `hz_portal_category_post` `relation` ON `post`.`id`=`relation`.`post_id` WHERE `post`.`post_type` = 1 AND `post`.`post_status` = 1 AND `post`.`delete_time` = 0 AND `relation`.`category_id` = 25 AND `relation`.`post_id` < 98 AND ( `post`.`published_time` < 1727082204 and `post`.`published_time` > 0 ) ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000987s ]
[ SQL ] SELECT `post`.* FROM `hz_portal_post` `post` INNER JOIN `hz_portal_category_post` `relation` ON `post`.`id`=`relation`.`post_id` WHERE `post`.`post_type` = 1 AND `post`.`post_status` = 1 AND `post`.`delete_time` = 0 AND `relation`.`category_id` = 25 AND `relation`.`post_id` > 98 AND ( `post`.`published_time` < 1727082204 and `post`.`published_time` > 0 ) ORDER BY `id` ASC LIMIT 1 [ RunTime:0.000665s ]
[ SQL ] UPDATE `hz_theme_file` SET `theme` = 'default' , `action` = 'portal/List/index' , `file` = 'portal/apply' , `name` = '技術中心' , `more` = '{\"vars\":[],\"widgets\":{\"email\":{\"title\":\"\\u90ae\\u7bb1\\u6536\\u96c6\\u8bbe\\u7f6e\",\"display\":\"1\",\"vars\":{\"title\":{\"title\":\"\\u90ae\\u7bb1\\u6536\\u96c6\\u6807\\u9898\",\"value\":\"WANT TO STAY UP TO DATE? JUST SIGN UP FOR OUR NEWSLETTER!\",\"type\":\"text\"},\"desc\":{\"title\":\"\\u90ae\\u7bb1\\u6536\\u96c6\\u63cf\\u8ff0\",\"value\":\"WANT TO KEEP UP TO DATE WITH THE LATEST DEVELOPMENTS HERE AT D&S? OUR EMAIL NEWSLETTER MAY BE JUST WHAT YOU\\u2019RE LOOKING FOR. SIGN UP WITH YOUR EMAIL ADDRESS BELOW.\",\"type\":\"text\"}}},\"video\":{\"title\":\"\\u81ea\\u5b9a\\u4e49\\u89c6\\u9891\\u5c55\\u793a\",\"display\":\"1\",\"vars\":{\"video\":{\"title\":\"\\u81ea\\u5b9a\\u4e49\\u89c6\\u9891\\u6dfb\\u52a0\",\"value\":[[]],\"type\":\"array\",\"item\":{\"title\":{\"title\":\"\\u6807\\u9898\",\"value\":\"\",\"type\":\"text\",\"rule\":{\"require\":true}},\"time\":{\"title\":\"\\u4e0a\\u4f20\\u65f6\\u95f4\",\"value\":\"\",\"type\":\"date\"},\"video\":{\"title\":\"\\u89c6\\u9891\",\"value\":\"\",\"type\":\"text\",\"dataSource\":{\"api\":\"portal\\/category\\/video\",\"multi\":false},\"placeholder\":\"\\u8bf7\\u9009\\u62e9\",\"tip\":\"\",\"rule\":{\"require\":true}}},\"tip\":\"\"}}}}}' , `config_more` = '{\"vars\":[],\"widgets\":{\"email\":{\"title\":\"\\u90ae\\u7bb1\\u6536\\u96c6\\u8bbe\\u7f6e\",\"display\":\"1\",\"vars\":{\"title\":{\"title\":\"\\u90ae\\u7bb1\\u6536\\u96c6\\u6807\\u9898\",\"value\":\"WANT TO STAY UP TO DATE? JUST SIGN UP FOR OUR NEWSLETTER!\",\"type\":\"text\"},\"desc\":{\"title\":\"\\u90ae\\u7bb1\\u6536\\u96c6\\u63cf\\u8ff0\",\"value\":\"WANT TO KEEP UP TO DATE WITH THE LATEST DEVELOPMENTS HERE AT D&S? OUR EMAIL NEWSLETTER MAY BE JUST WHAT YOU\\u2019RE LOOKING FOR. SIGN UP WITH YOUR EMAIL ADDRESS BELOW.\",\"type\":\"text\"}}},\"video\":{\"title\":\"\\u81ea\\u5b9a\\u4e49\\u89c6\\u9891\\u5c55\\u793a\",\"display\":\"1\",\"vars\":{\"video\":{\"title\":\"\\u81ea\\u5b9a\\u4e49\\u89c6\\u9891\\u6dfb\\u52a0\",\"value\":[[]],\"type\":\"array\",\"item\":{\"title\":{\"title\":\"\\u6807\\u9898\",\"value\":\"\",\"type\":\"text\",\"rule\":{\"require\":true}},\"time\":{\"title\":\"\\u4e0a\\u4f20\\u65f6\\u95f4\",\"value\":\"\",\"type\":\"date\"},\"video\":{\"title\":\"\\u89c6\\u9891\",\"value\":\"\",\"type\":\"text\",\"dataSource\":{\"api\":\"portal\\/category\\/video\",\"multi\":false},\"placeholder\":\"\\u8bf7\\u9009\\u62e9\",\"tip\":\"\",\"rule\":{\"require\":true}}},\"tip\":\"\"}}}}}' , `description` = '技術中心列表模板文件' , `is_public` = 0 , `list_order` = 10 WHERE `theme` = 'default' AND `file` = 'portal/apply' [ RunTime:0.008900s ]
[ SQL ] SELECT * FROM `hz_theme_file` WHERE `theme` = 'default' AND `file` = 'portal/attestation-center' LIMIT 1 [ RunTime:0.000602s ]
[ SQL ] UPDATE `hz_theme_file` SET `theme` = 'default' , `action` = 'portal/List/index' , `file` = 'portal/news' , `name` = '新聞中心' , `more` = '{\"vars\":[],\"widgets\":{\"email\":{\"title\":\"\\u90ae\\u7bb1\\u6536\\u96c6\\u8bbe\\u7f6e\",\"display\":1,\"vars\":{\"title\":{\"title\":\"\\u90ae\\u7bb1\\u6536\\u96c6\\u6807\\u9898\",\"value\":\"\",\"type\":\"text\"},\"desc\":{\"title\":\"\\u90ae\\u7bb1\\u6536\\u96c6\\u63cf\\u8ff0\",\"value\":\"\",\"type\":\"text\"}}},\"video\":{\"title\":\"\\u81ea\\u5b9a\\u4e49\\u89c6\\u9891\\u5c55\\u793a\",\"display\":1,\"vars\":{\"video\":{\"title\":\"\\u81ea\\u5b9a\\u4e49\\u89c6\\u9891\\u6dfb\\u52a0\",\"value\":[{\"title\":\"\\u4f18\\u7f8e1\",\"time\":\"2020-08-08\",\"video_text_\":\"1111\",\"video\":\"46\"},{\"title\":\"\\u4f18\\u7f8e2\",\"time\":\"2020-08-08\",\"video_text_\":\"1111\",\"video\":\"46\"}],\"type\":\"array\",\"item\":{\"title\":{\"title\":\"\\u6807\\u9898\",\"value\":\"\",\"type\":\"text\",\"rule\":{\"require\":true}},\"time\":{\"title\":\"\\u4e0a\\u4f20\\u65f6\\u95f4\",\"value\":\"\",\"type\":\"date\"},\"video\":{\"title\":\"\\u89c6\\u9891\",\"value\":\"\",\"type\":\"text\",\"dataSource\":{\"api\":\"portal\\/category\\/video\",\"multi\":false},\"placeholder\":\"\\u8bf7\\u9009\\u62e9\",\"tip\":\"\",\"rule\":{\"require\":true}}},\"tip\":\"\"}}}}}' , `config_more` = '{\"vars\":[],\"widgets\":{\"email\":{\"title\":\"\\u90ae\\u7bb1\\u6536\\u96c6\\u8bbe\\u7f6e\",\"display\":\"1\",\"vars\":{\"title\":{\"title\":\"\\u90ae\\u7bb1\\u6536\\u96c6\\u6807\\u9898\",\"value\":\"WANT TO STAY UP TO DATE? JUST SIGN UP FOR OUR NEWSLETTER!\",\"type\":\"text\"},\"desc\":{\"title\":\"\\u90ae\\u7bb1\\u6536\\u96c6\\u63cf\\u8ff0\",\"value\":\"WANT TO KEEP UP TO DATE WITH THE LATEST DEVELOPMENTS HERE AT D&S? OUR EMAIL NEWSLETTER MAY BE JUST WHAT YOU\\u2019RE LOOKING FOR. SIGN UP WITH YOUR EMAIL ADDRESS BELOW.\",\"type\":\"text\"}}},\"video\":{\"title\":\"\\u81ea\\u5b9a\\u4e49\\u89c6\\u9891\\u5c55\\u793a\",\"display\":\"1\",\"vars\":{\"video\":{\"title\":\"\\u81ea\\u5b9a\\u4e49\\u89c6\\u9891\\u6dfb\\u52a0\",\"value\":[[]],\"type\":\"array\",\"item\":{\"title\":{\"title\":\"\\u6807\\u9898\",\"value\":\"\",\"type\":\"text\",\"rule\":{\"require\":true}},\"time\":{\"title\":\"\\u4e0a\\u4f20\\u65f6\\u95f4\",\"value\":\"\",\"type\":\"date\"},\"video\":{\"title\":\"\\u89c6\\u9891\",\"value\":\"\",\"type\":\"text\",\"dataSource\":{\"api\":\"portal\\/category\\/video\",\"multi\":false},\"placeholder\":\"\\u8bf7\\u9009\\u62e9\",\"tip\":\"\",\"rule\":{\"require\":true}}},\"tip\":\"\"}}}}}' , `description` = '新聞列表模板文件' , `is_public` = 0 , `list_order` = 10 WHERE `theme` = 'default' AND `file` = 'portal/news' [ RunTime:0.010179s ]
[ SQL ] SELECT * FROM `hz_theme_file` WHERE `theme` = 'default' AND `file` = 'portal/profile' LIMIT 1 [ RunTime:0.000598s ]
[ SQL ] UPDATE `hz_theme_file` SET `theme` = 'default' , `action` = 'portal/List/index' , `file` = 'portal/video' , `name` = '視頻列表頁' , `more` = '{\"vars\":[],\"widgets\":{\"email\":{\"title\":\"\\u90ae\\u7bb1\\u6536\\u96c6\\u8bbe\\u7f6e\",\"display\":\"1\",\"vars\":{\"title\":{\"title\":\"\\u90ae\\u7bb1\\u6536\\u96c6\\u6807\\u9898\",\"value\":\"WANT TO STAY UP TO DATE? JUST SIGN UP FOR OUR NEWSLETTER!\",\"type\":\"text\"},\"desc\":{\"title\":\"\\u90ae\\u7bb1\\u6536\\u96c6\\u63cf\\u8ff0\",\"value\":\"WANT TO KEEP UP TO DATE WITH THE LATEST DEVELOPMENTS HERE AT D&S? OUR EMAIL NEWSLETTER MAY BE JUST WHAT YOU\\u2019RE LOOKING FOR. SIGN UP WITH YOUR EMAIL ADDRESS BELOW.\",\"type\":\"text\"}}}}}' , `config_more` = '{\"vars\":[],\"widgets\":{\"email\":{\"title\":\"\\u90ae\\u7bb1\\u6536\\u96c6\\u8bbe\\u7f6e\",\"display\":\"1\",\"vars\":{\"title\":{\"title\":\"\\u90ae\\u7bb1\\u6536\\u96c6\\u6807\\u9898\",\"value\":\"WANT TO STAY UP TO DATE? JUST SIGN UP FOR OUR NEWSLETTER!\",\"type\":\"text\"},\"desc\":{\"title\":\"\\u90ae\\u7bb1\\u6536\\u96c6\\u63cf\\u8ff0\",\"value\":\"WANT TO KEEP UP TO DATE WITH THE LATEST DEVELOPMENTS HERE AT D&S? OUR EMAIL NEWSLETTER MAY BE JUST WHAT YOU\\u2019RE LOOKING FOR. SIGN UP WITH YOUR EMAIL ADDRESS BELOW.\",\"type\":\"text\"}}}}}' , `description` = '視頻列表頁模板文件' , `is_public` = 0 , `list_order` = 10 WHERE `theme` = 'default' AND `file` = 'portal/video' [ RunTime:0.009614s ]
[ SQL ] SELECT * FROM `hz_theme_file` WHERE `theme` = 'default' AND `file` = 'project/gdproducts' LIMIT 1 [ RunTime:0.000624s ]
[ SQL ] SELECT * FROM `hz_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 1 ORDER BY `list_order` ASC [ RunTime:0.000438s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM ( SELECT count(*) AS think_count FROM `hz_portal_post` `post` INNER JOIN `hz_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 ( `post`.`published_time` > 0 and `post`.`published_time` < 1727082205 ) GROUP BY `post`.`id` ) `_group_count_` [ RunTime:0.000899s ]
[ SQL ] SELECT post.*,min(category_post.category_id) as category_id FROM `hz_portal_post` `post` INNER JOIN `hz_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 ( `post`.`published_time` > 0 and `post`.`published_time` < 1727082205 ) GROUP BY `post`.`id` ORDER BY `post`.`update_time` DESC LIMIT 0,5 [ RunTime:0.002638s ]
[ SQL ] SHOW COLUMNS FROM `hz_project_category` [ RunTime:0.000970s ]
[ SQL ] SELECT * FROM `hz_project_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 1 ORDER BY `list_order` ASC [ RunTime:0.000574s ]
[ SQL ] SELECT * FROM `hz_project_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 31 ORDER BY `list_order` ASC [ RunTime:0.000533s ]
[ SQL ] SELECT * FROM `hz_project_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 61 ORDER BY `list_order` ASC [ RunTime:0.000376s ]
[ SQL ] SHOW COLUMNS FROM `hz_project_post` [ RunTime:0.000831s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM ( SELECT count(*) AS think_count FROM `hz_project_post` `post` INNER JOIN `hz_project_category_post` `category_post` ON `post`.`id`=`category_post`.`post_id` WHERE `post`.`post_status` = 1 AND `post`.`delete_time` = 0 AND ( `category_post`.`category_id` IN (31,61,63,68,73,74,77,86,87,88,89,90,91,92,33,79,39,35,34,37,64,65) ) AND ( `post`.`published_time` > 0 and `post`.`published_time` < 1727082205 ) GROUP BY `post`.`id` ) `_group_count_` [ RunTime:0.000985s ]
[ SQL ] SELECT post.*,min(category_post.category_id) as category_id FROM `hz_project_post` `post` INNER JOIN `hz_project_category_post` `category_post` ON `post`.`id`=`category_post`.`post_id` WHERE `post`.`post_status` = 1 AND `post`.`delete_time` = 0 AND ( `category_post`.`category_id` IN (31,61,63,68,73,74,77,86,87,88,89,90,91,92,33,79,39,35,34,37,64,65) ) AND ( `post`.`published_time` > 0 and `post`.`published_time` < 1727082205 ) GROUP BY `post`.`id` ORDER BY `post`.`published_time` DESC LIMIT 0,8 [ RunTime:0.001403s ]