[ SQL ] UPDATE `cmf_theme_file` SET `theme` = 'new' , `action` = 'portal/Index/index' , `file` = 'portal/index' , `name` = '首页' , `more` = '{\"vars\":{\"top_slide\":{\"title\":\"\\u9876\\u90e8\\u5e7b\\u706f\\u7247\",\"value\":\"\",\"type\":\"text\",\"dataSource\":{\"api\":\"admin\\/Slide\\/index\",\"multi\":false},\"placeholder\":\"\\u8bf7\\u9009\\u62e9\\u9876\\u90e8\\u5e7b\\u706f\\u7247\",\"tip\":\"\\u9876\\u90e8\\u5e7b\\u706f\\u7247\",\"rule\":{\"require\":true}}},\"widgets\":{\"recommend\":{\"title\":\"\\u4ea7\\u54c1\\u63a8\\u8350\",\"display\":1,\"vars\":{\"items\":{\"title\":\"\\u63a8\\u8350\",\"value\":[{\"id\":\"30\",\"title\":\"Xiangshan Revolutionary Memorial Hall case scene\",\"desc\":\"Barbecue\",\"icon\":\"default\\/20220117\\/41f40623994a93d72c4500597f567838.png\",\"content\":\"Create an immersive dining environment with projectors and multimedia software\"},{\"id\":\"32\",\"title\":\"Dacheng Seafood Barbeque\",\"desc\":\"Immersive, beautiful wheel fantasy\",\"icon\":\"default\\/20220117\\/917a40f6238329e7936a4bf6e9c522a7.jpg\",\"content\":\"Customise the setting scene mode, match different atmospheres, create more collaboration functions, and create an immersive feeling.\"},{\"id\":\"33\",\"title\":\" Light and shadow memorial meeting for Yuan Longping \",\"desc\":\"Immersive children\'s entertainment amusement park\",\"icon\":\"default\\/20220117\\/838439533ad97ae9f4822380847c9ee7.jpg\",\"content\":\"Immersive children\'s entertainment amusement park\\r\\nProducts, videos, installation and use, full range of services\"}],\"type\":\"array\",\"item\":{\"id\":{\"title\":\"\\u6587\\u7ae0id\",\"value\":\"\",\"type\":\"text\"},\"title\":{\"title\":\"\\u6807\\u9898\",\"value\":\"\",\"type\":\"text\",\"rule\":{\"require\":true}},\"desc\":{\"title\":\"\\u7b80\\u8ff0\",\"value\":\"\",\"type\":\"textarea\"},\"icon\":{\"title\":\"\\u56fe\\u7247\",\"value\":\"\",\"type\":\"image\"},\"content\":{\"title\":\"\\u5185\\u5bb9\",\"value\":\"\",\"type\":\"textarea\"}},\"tip\":\"\"}}},\"products\":{\"title\":\"\\u4ea7\\u54c1\\u4e2d\\u5fc3\",\"display\":1,\"vars\":{\"sub_title\":{\"title\":\"\\u526f\\u6807\\u9898\",\"value\":\"PRODUCT\",\"type\":\"text\",\"placeholder\":\"\\u8bf7\\u8f93\\u5165\\u526f\\u6807\\u9898\",\"tip\":\"\",\"rule\":{\"require\":true}},\"products_category_id\":{\"title\":\"\\u6587\\u7ae0\\u5206\\u7c7bID\",\"value\":\"1,6\",\"type\":\"text\",\"dataSource\":{\"api\":\"portal\\/Category\\/index\",\"multi\":true},\"placeholder\":\"\\u8bf7\\u9009\\u62e9\\u5206\\u7c7b\",\"tip\":\"\",\"rule\":{\"require\":true},\"valueText\":\"products\"}}},\"news\":{\"title\":\"News\",\"display\":1,\"vars\":{\"sub_title\":{\"title\":\"\\u526f\\u6807\\u9898\",\"value\":\"Latest industry news\",\"type\":\"text\",\"placeholder\":\"\\u8bf7\\u8f93\\u5165\\u526f\\u6807\\u9898\",\"tip\":\"\",\"rule\":{\"require\":true}},\"background\":{\"title\":\"\\u80cc\\u666f\\u56fe\\u7247\",\"value\":\"default\\/20210516\\/5faa56df2645311b4d52872492ede22e.jpg\",\"type\":\"image\",\"tip\":\"\",\"rule\":{\"require\":true}},\"news_category_id\":{\"title\":\"\\u6587\\u7ae0\\u5206\\u7c7bID\",\"value\":\"2,7\",\"type\":\"text\",\"dataSource\":{\"api\":\"portal\\/Category\\/index\",\"multi\":true},\"placeholder\":\"\\u8bf7\\u9009\\u62e9\\u5206\\u7c7b\",\"tip\":\"\",\"rule\":{\"require\":true},\"valueText\":\"news\"}}},\"about\":{\"title\":\"\\u5173\\u4e8e\",\"display\":1,\"vars\":{\"sub_title\":{\"title\":\"\\u526f\\u6807\\u9898\",\"value\":\"ABOUT\",\"type\":\"text\",\"placeholder\":\"\\u8bf7\\u8f93\\u5165\\u526f\\u6807\\u9898\",\"tip\":\"\",\"rule\":{\"require\":true}},\"thumbnail\":{\"title\":\"\\u7f29\\u7565\\u56fe\",\"value\":\"default\\/20210517\\/2f17d4983a44fc5b1cfa8674d78232c8.png\",\"type\":\"image\",\"tip\":\"\\u8bf7\\u9009\\u62e9\\u56fe\\u7247\",\"rule\":{\"require\":true}},\"content\":{\"title\":\"\\u5173\\u4e8e\\u6211\\u4eec\",\"value\":\"DHN is a focus on the high-end projection research\\r\\nDevelopment, sales, service as one of the national high-tech\\r\\nTechnological enterprises.\\r\\nDHN business is mainly divided into two sectors, on the one hand\\r\\nCommitted to projector hardware research and development and production, another\\r\\nThe aspect revolves around the hardware achievement, the development project turns the product\\r\\nThe ultimate goal is to achieve "light and shadow" in each line\\r\\nApplication of industries.\\r\\nOn the road of brand development, all the employees of the company are adhering to the enthusiasm for the projection cause, practicing the development mission of creating first-class national brand, breaking through the application limitations of the projection industry, having the courage to innovate and constantly develop, and unswervingly becoming a national brand with national characteristics!\",\"type\":\"textarea\",\"rule\":{\"require\":true},\"message\":{\"require\":\"\\u4e0d\\u80fd\\u4e3a\\u7a7a\"}}}},\"service\":{\"title\":\"Service\",\"display\":1,\"vars\":{\"sub_title\":{\"title\":\"\\u526f\\u6807\\u9898\",\"value\":\"We will provide you with high quality service\",\"type\":\"text\",\"placeholder\":\"\\u8bf7\\u8f93\\u5165\\u526f\\u6807\\u9898\",\"tip\":\"\",\"rule\":{\"require\":true}},\"items\":{\"title\":\"\\u7279\\u6027\\u4ecb\\u7ecd\",\"value\":[{\"title\":\"Master core technology\",\"icon\":\"default\\/20210517\\/75f51ccfbaaaa5a09b51235c1a247804.png\",\"content\":\"DHN has its own R & D team, adhering to the scientific and rigorous attitude in the field of projection exploration, through unremitting efforts to gradually stand out, with the industry can not be matched by the core technology, in the footsteps of the market at the same time also developed an exclusive exclusive projection function...\"},{\"title\":\"Multi-series product coverage\",\"icon\":\"default\\/20210517\\/9c7cdf565f99ab8c82114d4690c830b3.png\",\"content\":\"DHN develops different products for different scenarios and applications, covering all aspects of the product line.\"},{\"title\":\"Specialised services\",\"icon\":\"default\\/20210517\\/25c058438a0f491c8735a253c3ea764a.png\",\"content\":\"DHN adheres to the attitude of continuous improvement in product service. It has its own service system and team from product research and development and sales to service system.\"},{\"title\":\"A new era of projection object display\",\"icon\":\"default\\/20210517\\/ed4b9be7780dc32889f2eb593a149a3e.png\",\"content\":\"The projection object display industry is proposed for the market application of DHN, that is, "make objects in life image and display, realise the information interaction between people and machines, machines and machines, and people". It covers all walks of life, such as our common light and shadow restaurants, light and shadow gyms, light and shadow subway\\/garage\\/in-station advertising, and light and shadow cultural tourism.\"}],\"type\":\"array\",\"item\":{\"title\":{\"title\":\"\\u6807\\u9898\",\"value\":\"\",\"type\":\"text\",\"rule\":{\"require\":true}},\"icon\":{\"title\":\"\\u56fe\\u6807\",\"value\":\"\",\"type\":\"image\"},\"content\":{\"title\":\"\\u63cf\\u8ff0\",\"value\":\"\",\"type\":\"textarea\"}},\"tip\":\"\"}}}}}' , `config_more` = '{\"vars\":{\"top_slide\":{\"title\":\"\\u9876\\u90e8\\u5e7b\\u706f\\u7247\",\"value\":\"\",\"type\":\"text\",\"dataSource\":{\"api\":\"admin\\/Slide\\/index\",\"multi\":false},\"placeholder\":\"\\u8bf7\\u9009\\u62e9\\u9876\\u90e8\\u5e7b\\u706f\\u7247\",\"tip\":\"\\u9876\\u90e8\\u5e7b\\u706f\\u7247\",\"rule\":{\"require\":true}}},\"widgets\":{\"recommend\":{\"title\":\"\\u4ea7\\u54c1\\u63a8\\u8350\",\"display\":\"1\",\"vars\":{\"items\":{\"title\":\"\\u63a8\\u8350\",\"value\":[{\"id\":\"6\",\"title\":\"\\u5bb6\\u7528\\u9707\\u64bc\\u97f3\\u8d28\\u97f3\\u54cd\",\"desc\":\"household\",\"icon\":\"http:\\/\\/demos.admin868.com\\/demo161\\/skin\\/images\\/0294704598c8ff41ef288709cf856aa1_origin.jpg\",\"content\":\"\\u8d85\\u7ea7\\u4eba\\u5de5\\u667a\\u80fd\\u672a\\u6765\\u751f\\u6d3b\\uff0c\\u5c0f\\u667a\\u5f00\\u542f\\uff01\\u4e0a\\u73ed\\u8bbe\\u5907\\u5fd8\\uff0c\\u4e0b\\u73ed\\u641c\\u6b4c\\u66f2\\uff01\"},{\"id\":\"3\",\"title\":\"Intelligence\\u9ad8\\u7ea7\\u8f66\\u8f7d\\u97f3\\u54cd\",\"desc\":\"\\u590d\\u53e4\\u9ed1\\u8272\\u73b0\\u4ee3\\u5531\\u7247\\u673a\",\"icon\":\"http:\\/\\/demos.admin868.com\\/demo161\\/skin\\/images\\/a75a9caba9b4449c27aed570bfab11ce_origin.jpg\",\"content\":\"\\u81ea\\u5b9a\\u4e49\\u8bbe\\u5b9a\\u573a\\u666f\\u6a21\\u5f0f\\uff0c\\u642d\\u914d\\u4e0d\\u540c\\u6c1b\\u56f4\\uff0c\\u521b\\u9020\\u66f4\\u591a\\u534f\\u4f5c\\u529f\\u80fd\\uff0c\\u8425\\u9020\\u8eab\\u4e34\\u5176\\u5883\\u4e4b\\u611f\\uff01\"},{\"id\":\"9\",\"title\":\"Voice\\u667a\\u80fd\\u4fbf\\u6377\\u97f3\\u54cd\",\"desc\":\"Wheel hub wheel\",\"icon\":\"http:\\/\\/demos.admin868.com\\/demo161\\/skin\\/images\\/c49fd53eab013e45faee52a31b5ae4e4_origin.jpg\",\"content\":\"\\u81ea\\u5b9a\\u4e49\\u8bbe\\u5b9a\\u573a\\u666f\\u6a21\\u5f0f\\uff0c\\u642d\\u914d\\u4e0d\\u540c\\u6c1b\\u56f4\\uff0c\\u521b\\u9020\\u66f4\\u591a\\u534f\\u4f5c\\u529f\\u80fd\\uff0c\\u8425\\u9020\\u8eab\\u4e34\\u5176\\u5883\\u4e4b\\u611f\\uff01\"}],\"type\":\"array\",\"item\":{\"id\":{\"title\":\"\\u6587\\u7ae0id\",\"value\":\"\",\"type\":\"text\"},\"title\":{\"title\":\"\\u6807\\u9898\",\"value\":\"\",\"type\":\"text\",\"rule\":{\"require\":true}},\"desc\":{\"title\":\"\\u7b80\\u8ff0\",\"value\":\"\",\"type\":\"textarea\"},\"icon\":{\"title\":\"\\u56fe\\u7247\",\"value\":\"\",\"type\":\"image\"},\"content\":{\"title\":\"\\u5185\\u5bb9\",\"value\":\"\",\"type\":\"textarea\"}},\"tip\":\"\"}}},\"products\":{\"title\":\"\\u4ea7\\u54c1\\u4e2d\\u5fc3\",\"display\":\"1\",\"vars\":{\"sub_title\":{\"title\":\"\\u526f\\u6807\\u9898\",\"value\":\"PRODUCT\",\"type\":\"text\",\"placeholder\":\"\\u8bf7\\u8f93\\u5165\\u526f\\u6807\\u9898\",\"tip\":\"\",\"rule\":{\"require\":true}},\"products_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}}}},\"news\":{\"title\":\"\\u8d44\\u8baf\",\"display\":\"1\",\"vars\":{\"sub_title\":{\"title\":\"\\u526f\\u6807\\u9898\",\"value\":\"NEWS\",\"type\":\"text\",\"placeholder\":\"\\u8bf7\\u8f93\\u5165\\u526f\\u6807\\u9898\",\"tip\":\"\",\"rule\":{\"require\":true}},\"background\":{\"title\":\"\\u80cc\\u666f\\u56fe\\u7247\",\"value\":\"\\/themes\\/new\\/public\\/assets\\/images\\/b9f8dd60bc3118137b47e0f1e0439112_origin.jpg\",\"type\":\"image\",\"tip\":\"\",\"rule\":{\"require\":true}},\"news_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}}}},\"about\":{\"title\":\"\\u5173\\u4e8e\",\"display\":\"1\",\"vars\":{\"sub_title\":{\"title\":\"\\u526f\\u6807\\u9898\",\"value\":\"ABOUT\",\"type\":\"text\",\"placeholder\":\"\\u8bf7\\u8f93\\u5165\\u526f\\u6807\\u9898\",\"tip\":\"\",\"rule\":{\"require\":true}},\"thumbnail\":{\"title\":\"\\u7f29\\u7565\\u56fe\",\"value\":\"http:\\/\\/demo1.lehanwangluo.com\\/themes\\/new\\/public\\/assets\\/images\\/about.jpg\",\"type\":\"image\",\"tip\":\"\\u8bf7\\u9009\\u62e9\\u56fe\\u7247\",\"rule\":{\"require\":true}},\"content\":{\"title\":\"\\u5173\\u4e8e\\u6211\\u4eec\",\"value\":\"1\",\"type\":\"textarea\",\"rule\":{\"require\":true},\"message\":{\"require\":\"\\u4e0d\\u80fd\\u4e3a\\u7a7a\"}}}},\"service\":{\"title\":\"\\u670d\\u52a1\\u652f\\u6301\",\"display\":\"1\",\"vars\":{\"sub_title\":{\"title\":\"\\u526f\\u6807\\u9898\",\"value\":\"SERVICE\",\"type\":\"text\",\"placeholder\":\"\\u8bf7\\u8f93\\u5165\\u526f\\u6807\\u9898\",\"tip\":\"\",\"rule\":{\"require\":true}},\"items\":{\"title\":\"\\u7279\\u6027\\u4ecb\\u7ecd\",\"value\":[{\"title\":\"\\u97f3\\u8d28\\u4fdd\\u8bc1\",\"icon\":\"http:\\/\\/demo1.lehanwangluo.com\\/themes\\/new\\/public\\/assets\\/images\\/38575a3fef005988290b9c4caac84f55_origin.png\",\"content\":\"\\u6eda\\u6eda\\u7ea2\\u5c18\\u4e4b\\u4e2d\\uff0c\\u603b\\u6709\\u4e00\\u6735\\u82b1\\uff0c\\u4e3a\\u4f60\\u7efd\\u653e\\u5f02\\u5f69\\uff0c\\u7b49\\u4f60\\u4f4e\\u7709\\uff0c\\u7b49\\u4f60\\u56de\\u7738\\u4e00\\u7b11\\uff0c\\u7b49\\u4f60\\u5c06\\u5ae3\\u7136\\u7684\\u6545\\u4e8b\\uff0c\\u5316\\u4f5c\\u4e00\\u4e2a\\u4e2a\\u5c81\\u6708\\u7684\\u97f3\\u7b26\\uff0c\\u8df3\\u8dc3\\u5728\\u751f\\u547d\\u7684\\u8109\\u640f\\u4e0a\\u3002...\"},{\"title\":\"\\u81ea\\u52a8\\u5b9a\\u65f6\",\"icon\":\"http:\\/\\/demo1.lehanwangluo.com\\/themes\\/new\\/public\\/assets\\/images\\/5dbcc99ce6cd43c29df1d25c1994fcf7_origin.png\",\"content\":\"\\u5728\\u8fd9\\u4e2a\\u590f\\u82b1\\u707f\\u70c2\\u65f6\\u5019\\uff0c\\u6bcf\\u4e00\\u6735\\u82b1\\u91cc\\uff0c\\u90fd\\u542b\\u7740\\u5999\\u7406\\uff0c\\u542b\\u7740\\u6e29\\u60c5\\u3002\\u5fae\\u98ce\\u7a20\\u5bc6\\u7740\\u7ef5\\u8f6f\\u7684\\u60c5\\u6000\\uff0c\\u6e05\\u6f88\\u5982\\u6c34\\u7684\\u601d\\u60f3\\uff0c\\u5f9c\\u5f89\\u5728\\u9759\\u8c27\\u7684\\u5348\\u540e\\u3002...\"},{\"title\":\"\\u58f0\\u63a7\\u667a\\u80fd\",\"icon\":\"http:\\/\\/demo1.lehanwangluo.com\\/themes\\/new\\/public\\/assets\\/images\\/23e988658770e1aad91d898681c247f6_origin.png\",\"content\":\"\\u7a97\\u5916\\u7684\\u9633\\u5149\\uff0c\\u7a7f\\u900f\\u5bc6\\u5bc6\\u531d\\u531d\\u7684\\u53f6\\u5b50\\uff0c\\u6d12\\u4e0b\\u4e00\\u9053\\u9053\\u7684\\u6591\\u9a73\\u3002\\u4e00\\u4e2a\\u4eba\\u7684\\u5348\\u540e\\uff0c\\u60ec\\u610f\\u758f\\u6717\\u3002\\u5076\\u5c14\\u770b\\u770b\\u8fdc\\u5904\\uff0c\\u8f66\\u8f86\\u6e38\\u9f99\\u822c\\uff0c\\u4e0d\\u77e5\\u9177\\u6691\\uff0c\\u9a76\\u5411\\u8fdc\\u65b9\\u3002...\"},{\"title\":\"\\u73af\\u7ed5\\u7acb\\u4f53\\u58f0\",\"icon\":\"http:\\/\\/demo1.lehanwangluo.com\\/themes\\/new\\/public\\/assets\\/images\\/a95c2d839e1bc58b7c42c90a066267cc_origin.png\",\"content\":\"\\u5b64\\u72ec\\uff0c\\u662f\\u4e00\\u79cd\\u5883\\u754c\\uff0c\\u4e5f\\u662f\\u4e00\\u79cd\\u4eab\\u53d7\\uff0c\\u8ba9\\u7075\\u9b42\\u5b81\\u9759\\uff0c\\u4e0d\\u88ab\\u5916\\u754c\\u55a7\\u56a3\\u6253\\u6270\\u3002\\u771f\\u6b63\\u7518\\u613f\\u4eab\\u53d7\\u5b64\\u72ec\\u7684\\u4eba\\uff0c\\u5185\\u5fc3\\u4f1a\\u9690\\u73b0\\u51fa\\u4e0d\\u53ef\\u8a00\\u55bb\\u7684\\u5feb\\u4e50\\u3002...\"}],\"type\":\"array\",\"item\":{\"title\":{\"title\":\"\\u6807\\u9898\",\"value\":\"\",\"type\":\"text\",\"rule\":{\"require\":true}},\"icon\":{\"title\":\"\\u56fe\\u6807\",\"value\":\"\",\"type\":\"image\"},\"content\":{\"title\":\"\\u63cf\\u8ff0\",\"value\":\"\",\"type\":\"textarea\"}},\"tip\":\"\"}}}}}' , `description` = '首页模板文件' , `is_public` = 0 , `list_order` = 5 WHERE `theme` = 'new' AND `file` = 'portal/index' [ RunTime:0.004531s ]
[ SQL ] SELECT * FROM `cmf_theme_file` WHERE `theme` = 'new' AND `file` = 'portal/list_article' LIMIT 1 [ RunTime:0.000346s ]
[ SQL ] SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 1 ORDER BY `list_order` ASC [ RunTime:0.000414s ]
[ SQL ] SHOW COLUMNS FROM `cmf_portal_post` [ RunTime:0.000594s ]
[ 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 ( `post`.`create_time` >= 0 ) AND ( `category_post`.`category_id` IN (3,4,5,8,9,10,16,17) ) AND ( `post`.`published_time` > 0 and `post`.`published_time` < 1745735612 ) GROUP BY `post`.`id` ) `_group_count_` [ RunTime:0.000655s ]
[ 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 ( `post`.`create_time` >= 0 ) AND ( `category_post`.`category_id` IN (3,4,5,8,9,10,16,17) ) AND ( `post`.`published_time` > 0 and `post`.`published_time` < 1745735612 ) GROUP BY `post`.`id` ORDER BY `published_time` DESC LIMIT 0,16 [ RunTime:0.001037s ]
