[ 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.009215s ]
[ SQL ] SELECT * FROM `hz_theme_file` WHERE `theme` = 'default' AND `file` = 'portal/attestation-center' LIMIT 1 [ RunTime:0.000643s ]
[ 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.010570s ]
[ SQL ] SELECT * FROM `hz_theme_file` WHERE `theme` = 'default' AND `file` = 'portal/profile' LIMIT 1 [ RunTime:0.000466s ]
[ 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.010455s ]
[ SQL ] SELECT * FROM `hz_theme_file` WHERE `theme` = 'default' AND `file` = 'project/gdproducts' LIMIT 1 [ RunTime:0.000546s ]
[ SQL ] SELECT * FROM `hz_project_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 1 ORDER BY `list_order` ASC [ RunTime:0.000471s ]
[ SQL ] SELECT * FROM `hz_project_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 31 ORDER BY `list_order` ASC [ RunTime:0.000388s ]
[ 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) ) AND ( `post`.`published_time` > 0 and `post`.`published_time` < 1725758470 ) GROUP BY `post`.`id` ) `_group_count_` [ RunTime:0.000950s ]
[ 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) ) AND ( `post`.`published_time` > 0 and `post`.`published_time` < 1725758470 ) GROUP BY `post`.`id` ORDER BY `post`.`published_time` DESC LIMIT 0,4 [ RunTime:0.001382s ]