[ SQL ] UPDATE `cmf_theme_file` SET `theme` = 'project' , `action` = 'portal/Page/index' , `file` = 'portal/english/index' , `name` = 'English_01首頁' , `more` = '{\"widgets\":{\"english_section01\":{\"title\":\"\\u82f1\\u6587\\u7248\\u4ea7\\u54c1\\u4f18\\u52bf\",\"display\":1,\"vars\":{\"section01_title\":{\"title\":\"\\u9996\\u9875\\u677f\\u575701\\u7684\\u6807\\u9898\",\"value\":\"Advantages\",\"type\":\"text\",\"tip\":\"\\u8bf7\\u8f93\\u5165\\u9996\\u9875\\u677f\\u575701\\u7684\\u6807\\u9898\",\"rule\":[]},\"section01_image\":{\"title\":\"\\u9996\\u9875\\u677f\\u575701\\u7684\\u4ea7\\u54c1\\u4ecb\\u7ecd\\u56fe\\u7247\",\"value\":\"default\\/20220323\\/eee9466b0bf08083775f6aeb6e45f067.jpg\",\"type\":\"image\",\"tip\":\"\\u8bf7\\u8f93\\u5165\\u9996\\u9875\\u677f\\u575701\\u7684\\u56fe\\u7247\",\"rule\":[]}}},\"english_section02\":{\"title\":\"\\u82f1\\u6587\\u7248\\u4ea7\\u54c1\\u4e2d\\u5fc3\",\"display\":1,\"vars\":{\"section02_title\":{\"title\":\"\\u9996\\u9875\\u677f\\u575702\\u7684\\u6807\\u9898\",\"value\":\"Product Center\",\"type\":\"text\",\"tip\":\"\\u8bf7\\u8f93\\u5165\\u9996\\u9875\\u677f\\u575702\\u7684\\u6807\\u9898\",\"rule\":[]},\"section02_dataId\":{\"title\":\"\\u9996\\u9875\\u677f\\u575702\\u7684\\u6570\\u636e\\u6765\\u6e90\\u5206\\u7c7bid\",\"value\":\"17\",\"type\":\"text\",\"dataSource\":{\"api\":\"portal\\/Category\\/index\",\"multi\":false},\"tip\":\"\\u8bf7\\u9009\\u62e9\\u9996\\u9875\\u677f\\u575702\\u7684\\u5206\\u7c7bid\",\"rule\":[],\"valueText\":\"Products\"}}},\"english_section03\":{\"title\":\"\\u82f1\\u6587\\u7248\\u5de5\\u7a0b\\u6848\\u4f8b\",\"display\":1,\"vars\":{\"section03_title\":{\"title\":\"\\u9996\\u9875\\u677f\\u575703\\u7684\\u6807\\u9898\",\"value\":\"Case\",\"type\":\"text\",\"tip\":\"\\u8bf7\\u8f93\\u5165\\u9996\\u9875\\u677f\\u575703\\u7684\\u6807\\u9898\",\"rule\":[]},\"section03_dataId\":{\"title\":\"\\u9996\\u9875\\u677f\\u575703\\u7684\\u6570\\u636e\\u6765\\u6e90\\u5206\\u7c7bid\",\"value\":\"20\",\"type\":\"text\",\"dataSource\":{\"api\":\"portal\\/Category\\/index\",\"multi\":false},\"tip\":\"\\u8bf7\\u9009\\u62e9\\u9996\\u9875\\u677f\\u575703\\u7684\\u5206\\u7c7bid\",\"rule\":[],\"valueText\":\"Engineering Case\"}}},\"english_section04\":{\"title\":\"\\u82f1\\u6587\\u7248\\u5173\\u4e8e\\u6211\\u4eec\",\"display\":1,\"vars\":{\"section04_title\":{\"title\":\"\\u9996\\u9875\\u677f\\u575704\\u7684\\u6807\\u9898\",\"value\":\"About Us\",\"type\":\"text\",\"tip\":\"\\u8bf7\\u8f93\\u5165\\u9996\\u9875\\u677f\\u575704\\u7684\\u6807\\u9898\",\"rule\":[]},\"section04_company_name\":{\"title\":\"\\u516c\\u53f8\\u540d\\u79f0\",\"value\":\"JIU ZHOU ELC (Zhongshan) Co., Ltd\",\"type\":\"text\",\"tip\":\"\\u8bf7\\u8f93\\u5165\\u516c\\u53f8\\u540d\\u79f0\",\"rule\":[]},\"section04_company_desc\":{\"title\":\"\\u516c\\u53f8\\u7b80\\u4ecb\",\"value\":\"JIUZHOU Electric (Zhongshan) Co., Ltd. was established in September 2020 with a registered capital of 55.55 million yuan. The plant covers an area of more than 5000 square meters. It is located in the economic center of Dawan District, the hometown of great man Sun Yat Sen, and Dongfang Industrial Park, Nanlang Town, Zhongshan City, Guangdong Province. It is a modern enterprise focusing on bus duct research and development, production, sales and service.Since its establishment, the company has adhered to the management concept of "people-oriented, honest business, innovative management and continuous improvement", gathered elites in the industry, and established a young and professional scientific research team and service team. The core members have more than 20 years of experience in busway and management. In order to better serve customers and improve product quality, the company has introduced the most advanced bus duct automatic production line and intelligent monitoring and detection line in the industry, combined domestic and foreign advanced technology and management methods with the actual situation of the enterprise, carefully created a series of high-quality power products for users, and won a number of national patents at one stroke, It has been fully recognized by the authoritative institutions in the industry and unanimously praised by the majority of users. It has practiced the enterprise purpose of "satisfying customers, being responsible for society, helping employees achieve achievements and making the enterprise develop" with practical actions, and fulfilled the enterprise mission of "creating value for customers, creating opportunities for employees, creating benefits for society and establishing brand for enterprises". In the face of global economic integration today, "JIUZHOU people" will always adhere to the belief of "revitalizing enterprises through science and technology and casting brands through quality". Based on the principle of win-win cooperation and sustainable development, Kyushu people are willing to sincerely cooperate with friends from all walks of life to create a better future hand in hand.\",\"type\":\"text\",\"tip\":\"\\u8bf7\\u8f93\\u5165\\u516c\\u53f8\\u7b80\\u4ecb\\u63cf\\u8ff0\",\"rule\":[]},\"section04_company_image\":{\"title\":\"\\u516c\\u53f8\\u56fe\\u7247\",\"value\":\"portal\\/20220331\\/4985dd61058a0e52851d7b32579e9d73.png\",\"type\":\"image\",\"tip\":\"\\u8bf7\\u9009\\u62e9\\u516c\\u53f8\\u56fe\\u7247\",\"rule\":[]}}},\"english_section05\":{\"title\":\"\\u82f1\\u6587\\u7248\\u65b0\\u95fb\\u8d44\\u8baf\",\"display\":1,\"vars\":{\"section05_title\":{\"title\":\"\\u9996\\u9875\\u677f\\u575705\\u7684\\u6807\\u9898\",\"value\":\"News Information\",\"type\":\"text\",\"tip\":\"\\u8bf7\\u8f93\\u5165\\u9996\\u9875\\u677f\\u575705\\u7684\\u6807\\u9898\",\"rule\":[]},\"section05_news_image\":{\"title\":\"\\u65b0\\u95fb\\u56fe\\u7247\",\"value\":\"default\\/20220323\\/e2634a5a3ea1552593dc26f18459188a.png\",\"type\":\"image\",\"tip\":\"\\u8bf7\\u9009\\u62e9\\u65b0\\u95fb\\u56fe\\u7247\",\"rule\":[]},\"section05_dataId\":{\"title\":\"\\u9996\\u9875\\u677f\\u575705\\u7684\\u6570\\u636e\\u6765\\u6e90\\u5206\\u7c7bid\",\"value\":\"26\",\"type\":\"text\",\"dataSource\":{\"api\":\"portal\\/Category\\/index\",\"multi\":false},\"tip\":\"\\u8bf7\\u9009\\u62e9\\u9996\\u9875\\u677f\\u575705\\u7684\\u5206\\u7c7bid\",\"rule\":[],\"valueText\":\"News Information\"}}},\"english_section06\":{\"title\":\"\\u82f1\\u6587\\u7248\\u4f01\\u4e1a\\u8d44\\u8d28\",\"display\":1,\"vars\":{\"section06_title\":{\"title\":\"\\u9996\\u9875\\u677f\\u575706\\u7684\\u6807\\u9898\",\"value\":\"Enterprise Qualification\",\"type\":\"text\",\"tip\":\"\\u8bf7\\u8f93\\u5165\\u9996\\u9875\\u677f\\u575706\\u7684\\u6807\\u9898\",\"rule\":[]}}}}}' , `config_more` = '{\"widgets\":{\"english_section01\":{\"title\":\"\\u82f1\\u6587\\u7248\\u4ea7\\u54c1\\u4f18\\u52bf\",\"display\":\"1\",\"vars\":{\"section01_title\":{\"title\":\"\\u9996\\u9875\\u677f\\u575701\\u7684\\u6807\\u9898\",\"value\":\"\",\"type\":\"text\",\"tip\":\"\\u8bf7\\u8f93\\u5165\\u9996\\u9875\\u677f\\u575701\\u7684\\u6807\\u9898\",\"rule\":[]},\"section01_image\":{\"title\":\"\\u9996\\u9875\\u677f\\u575701\\u7684\\u4ea7\\u54c1\\u4ecb\\u7ecd\\u56fe\\u7247\",\"value\":\"\",\"type\":\"image\",\"tip\":\"\\u8bf7\\u8f93\\u5165\\u9996\\u9875\\u677f\\u575701\\u7684\\u56fe\\u7247\",\"rule\":[]}}},\"english_section02\":{\"title\":\"\\u82f1\\u6587\\u7248\\u4ea7\\u54c1\\u4e2d\\u5fc3\",\"display\":\"1\",\"vars\":{\"section02_title\":{\"title\":\"\\u9996\\u9875\\u677f\\u575702\\u7684\\u6807\\u9898\",\"value\":\"\",\"type\":\"text\",\"tip\":\"\\u8bf7\\u8f93\\u5165\\u9996\\u9875\\u677f\\u575702\\u7684\\u6807\\u9898\",\"rule\":[]},\"section02_dataId\":{\"title\":\"\\u9996\\u9875\\u677f\\u575702\\u7684\\u6570\\u636e\\u6765\\u6e90\\u5206\\u7c7bid\",\"value\":\"\",\"type\":\"text\",\"dataSource\":{\"api\":\"portal\\/Category\\/index\",\"multi\":false},\"tip\":\"\\u8bf7\\u9009\\u62e9\\u9996\\u9875\\u677f\\u575702\\u7684\\u5206\\u7c7bid\",\"rule\":[]}}},\"english_section03\":{\"title\":\"\\u82f1\\u6587\\u7248\\u5de5\\u7a0b\\u6848\\u4f8b\",\"display\":\"1\",\"vars\":{\"section03_title\":{\"title\":\"\\u9996\\u9875\\u677f\\u575703\\u7684\\u6807\\u9898\",\"value\":\"\",\"type\":\"text\",\"tip\":\"\\u8bf7\\u8f93\\u5165\\u9996\\u9875\\u677f\\u575703\\u7684\\u6807\\u9898\",\"rule\":[]},\"section03_dataId\":{\"title\":\"\\u9996\\u9875\\u677f\\u575703\\u7684\\u6570\\u636e\\u6765\\u6e90\\u5206\\u7c7bid\",\"value\":\"\",\"type\":\"text\",\"dataSource\":{\"api\":\"portal\\/Category\\/index\",\"multi\":false},\"tip\":\"\\u8bf7\\u9009\\u62e9\\u9996\\u9875\\u677f\\u575703\\u7684\\u5206\\u7c7bid\",\"rule\":[]}}},\"english_section04\":{\"title\":\"\\u82f1\\u6587\\u7248\\u5173\\u4e8e\\u6211\\u4eec\",\"display\":\"1\",\"vars\":{\"section04_title\":{\"title\":\"\\u9996\\u9875\\u677f\\u575704\\u7684\\u6807\\u9898\",\"value\":\"\",\"type\":\"text\",\"tip\":\"\\u8bf7\\u8f93\\u5165\\u9996\\u9875\\u677f\\u575704\\u7684\\u6807\\u9898\",\"rule\":[]},\"section04_company_name\":{\"title\":\"\\u516c\\u53f8\\u540d\\u79f0\",\"value\":\"\",\"type\":\"text\",\"tip\":\"\\u8bf7\\u8f93\\u5165\\u516c\\u53f8\\u540d\\u79f0\",\"rule\":[]},\"section04_company_desc\":{\"title\":\"\\u516c\\u53f8\\u7b80\\u4ecb\",\"value\":\"\",\"type\":\"text\",\"tip\":\"\\u8bf7\\u8f93\\u5165\\u516c\\u53f8\\u7b80\\u4ecb\\u63cf\\u8ff0\",\"rule\":[]},\"section04_company_image\":{\"title\":\"\\u516c\\u53f8\\u56fe\\u7247\",\"value\":\"\",\"type\":\"image\",\"tip\":\"\\u8bf7\\u9009\\u62e9\\u516c\\u53f8\\u56fe\\u7247\",\"rule\":[]}}},\"english_section05\":{\"title\":\"\\u82f1\\u6587\\u7248\\u65b0\\u95fb\\u8d44\\u8baf\",\"display\":\"1\",\"vars\":{\"section05_title\":{\"title\":\"\\u9996\\u9875\\u677f\\u575705\\u7684\\u6807\\u9898\",\"value\":\"\",\"type\":\"text\",\"tip\":\"\\u8bf7\\u8f93\\u5165\\u9996\\u9875\\u677f\\u575705\\u7684\\u6807\\u9898\",\"rule\":[]},\"section05_news_image\":{\"title\":\"\\u65b0\\u95fb\\u56fe\\u7247\",\"value\":\"\",\"type\":\"image\",\"tip\":\"\\u8bf7\\u9009\\u62e9\\u65b0\\u95fb\\u56fe\\u7247\",\"rule\":[]},\"section05_dataId\":{\"title\":\"\\u9996\\u9875\\u677f\\u575705\\u7684\\u6570\\u636e\\u6765\\u6e90\\u5206\\u7c7bid\",\"value\":\"\",\"type\":\"text\",\"dataSource\":{\"api\":\"portal\\/Category\\/index\",\"multi\":false},\"tip\":\"\\u8bf7\\u9009\\u62e9\\u9996\\u9875\\u677f\\u575705\\u7684\\u5206\\u7c7bid\",\"rule\":[]}}},\"english_section06\":{\"title\":\"\\u82f1\\u6587\\u7248\\u4f01\\u4e1a\\u8d44\\u8d28\",\"display\":\"1\",\"vars\":{\"section06_title\":{\"title\":\"\\u9996\\u9875\\u677f\\u575706\\u7684\\u6807\\u9898\",\"value\":\"\",\"type\":\"text\",\"tip\":\"\\u8bf7\\u8f93\\u5165\\u9996\\u9875\\u677f\\u575706\\u7684\\u6807\\u9898\",\"rule\":[]}}}}}' , `description` = 'English_01首頁模板文件' , `is_public` = 1 , `list_order` = 80 WHERE `theme` = 'project' AND `file` = 'portal/english/index' [ RunTime:0.004300s ]
[ SQL ] SELECT * FROM `cmf_theme_file` WHERE `theme` = 'project' AND `file` = 'portal/english/news' LIMIT 1 [ RunTime:0.004174s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM ( SELECT count(*) AS think_count FROM `cmf_portal_post` `post` INNER JOIN `cmf_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 ( `category_post`.`category_id` = '8' ) AND ( `post`.`published_time` > 0 AND `post`.`published_time` < 1782538649 ) GROUP BY `post`.`id` ) `_group_count_` [ RunTime:0.004499s ]
[ 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`.`post_status` = 1 AND `post`.`post_type` = 1 AND `post`.`delete_time` = 0 AND ( `category_post`.`category_id` = '8' ) AND ( `post`.`published_time` > 0 AND `post`.`published_time` < 1782538649 ) GROUP BY `post`.`id` ORDER BY `post`.`create_time` DESC LIMIT 10,5 [ RunTime:0.004607s ]
