[ SQL ] UPDATE `cmf_theme_file` SET `theme` = 'simpleboot3' , `action` = 'portal/Index/index' , `file` = 'portal/index' , `name` = '首頁' , `more` = '{\"widgets\":{\"page1\":{\"title\":\"\\u9996\\u9875\\u7b2c\\u4e00\\u680f\",\"display\":1,\"vars\":{\"name\":{\"title\":\"\\u6807\\u9898\",\"value\":\"\\u4ea7\\u54c1\\u5c55\\u793a\",\"type\":\"text\",\"tip\":\"\",\"rule\":{\"require\":true}},\"alias\":{\"title\":\"\\u522b\\u540d\",\"value\":\"PRODUCTS\",\"type\":\"text\",\"tip\":\"\",\"rule\":{\"require\":true}},\"category_id\":{\"title\":\"\\u6587\\u7ae0\\u5206\\u7c7bID\",\"value\":\"25\",\"type\":\"text\",\"dataSource\":{\"api\":\"portal\\/Category\\/index\",\"multi\":true},\"placeholder\":\"\\u8bf7\\u9009\\u62e9\\u5206\\u7c7b\",\"tip\":\"\",\"rule\":{\"require\":true},\"valueText\":\"\\u4ea7\\u54c1\\u5c55\\u793a\"}}},\"page2\":{\"title\":\"\\u9996\\u9875\\u7b2c\\u4e8c\\u680f\",\"display\":1,\"vars\":{\"name\":{\"title\":\"\\u540d\\u79f0\",\"value\":\"\\u5173\\u4e8e\\u6211\\u4eec\",\"type\":\"text\",\"tip\":\"\",\"rule\":{\"require\":true}},\"alias\":{\"title\":\"\\u522b\\u540d\",\"value\":\"ABOUT US\",\"type\":\"text\",\"tip\":\"\",\"rule\":{\"require\":true}},\"desc\":{\"title\":\"\\u6587\\u5b57\\u63cf\\u8ff0\",\"value\":\"\\u6b66\\u6c49\\u96e8\\u795e\\u6d88\\u9632\\u6709\\u9650\\u516c\\u53f8\\u5ea7\\u843d\\u4e8e\\u6b66\\u6c49\\u5e02\\u6c49\\u5357\\u7ecf\\u6d4e\\u5f00\\u53d1\\u533a\\u534e\\u9876\\u5de5\\u4e1a\\u56ed\\uff0c\\u5382\\u623f\\u9762\\u79ef7000\\u33a1\\u3002\\u4ee5\\u4e13\\u4e1a\\u7684\\u4eba\\u624d\\u961f\\u4f0d\\uff0c\\u56fd\\u9645\\u5316\\u7ecf\\u8425\\u7406\\u5ff5\\uff0c\\u89c4\\u8303\\u7684\\u7ba1\\u7406\\u6a21\\u5f0f\\uff0c\\u4e00\\u6d41\\u7684\\u751f\\u4ea7\\u5de5\\u827a\\uff0c\\u5b8c\\u5584\\u7684\\u68c0\\u6d4b\\u624b\\u6bb5\\u548c\\u91d1\\u724c\\u7684\\u552e\\u540e\\u670d\\u52a1\\u5f15\\u9886\\u4e16\\u754c\\u6d88\\u9632\\u884c\\u4e1a\\u65b0\\u6f6e\\u6d41\\u3002\\r\\n\\r\\n\\u516c\\u53f8\\u662f\\u4e00\\u5bb6\\u96c6\\u73af\\u4fdd\\u578b\\u6d88\\u9632\\u4ea7\\u54c1\\u7684\\u7814\\u7a76\\u3001\\u751f\\u4ea7\\u3001\\u9500\\u552e\\u3001\\u6d88\\u9632\\u5de5\\u7a0b\\u8bbe\\u8ba1\\u3001\\u5b89\\u88c5\\u4e0e\\u7ef4\\u62a4\\u4e8e\\u4e00\\u4f53\\u7684\\u9ad8\\u79d1\\u6280\\u4f01\\u4e1a\\uff0c\\u6240\\u6709\\u4ea7\\u54c1\\u90fd\\u901a\\u8fc7\\u4e86\\u56fd\\u5bb6\\u578b\\u5f0f\\u68c0\\u9a8c\\uff0c\\u62e5\\u6709\\u591a\\u9879\\u5b8c\\u5168\\u77e5\\u8bc6\\u4ea7\\u6743\\uff0c\\u4e3b\\u8981\\u7ecf\\u8425\\u8303\\u56f4:\\u201c\\u96e8\\u795e\\u201d\\u724cABC\\u8d85\\u7ec6\\u5e72\\u7c89\\u706d\\u706b\\u5242\\uff0cD\\u7c7b\\u5e72\\u7c89\\u706d\\u706b\\u5242\\uff0c\\u60ac\\u6302\\u5f0f\\u3001\\u58c1\\u88c5\\u3001\\u67dc\\u5f0f\\u3001\\u8f66\\u7528\\u5e72\\u7c89\\u706d\\u706b\\u88c5\\u7f6e\\uff0c\\u5e72\\u7c89\\u706d\\u706b\\u7cfb\\u7edf\\u53ca\\u76f8\\u5173\\u6d88\\u9632\\u5668\\u6750\\u7684\\u751f\\u4ea7\\u3001\\u9500\\u552e\\u3002\\u53ef\\u4ee5\\u4e3a\\u51b6\\u91d1\\u3001\\u7535\\u529b\\u3001\\u77f3\\u6cb9\\u3001\\u77f3\\u5316\\u3001\\u6587\\u535a\\u6863\\u6848\\u9986\\u3001\\u7535\\u4fe1\\u57fa\\u7ad9\\u3001\\u5fae\\u673a\\u623f\\u3001\\u5730\\u4e0b\\u96a7\\u9053\\u3001\\u529e\\u516c\\u573a\\u6240\\u3001\\u4f53\\u80b2\\u573a\\u9986\\u7b49\\u7279\\u79cd\\u5efa\\u7b51\\u63d0\\u4f9b\\u73af\\u4fdd\\u3001\\u5148\\u8fdb\\u3001\\u53ef\\u9760\\u3001\\u9ad8\\u6548\\u3001\\u7ecf\\u6d4e\\u7684\\u6d88\\u9632\\u8bbe\\u8ba1\\u65b9\\u6848\\u548c\\u7ef4\\u62a4\\u3002\",\"type\":\"textarea\",\"tip\":\"\",\"rule\":{\"require\":true}},\"image\":{\"title\":\"\\u56fe\\u7247\",\"value\":\"default\\/20211111\\/0589a5bc77b98edd9f807be8bf4bfbdc.jpg\",\"type\":\"image\",\"tip\":\"\",\"rule\":{\"require\":true}},\"more_link\":{\"title\":\"\\u94fe\\u63a5\",\"value\":\"\\/portal\\/list\\/index\\/id\\/39.html\",\"type\":\"text\",\"tip\":\"\",\"rule\":{\"require\":true}}}},\"page3\":{\"title\":\"\\u9996\\u9875\\u7b2c\\u4e09\\u680f\",\"display\":1,\"vars\":{\"name\":{\"title\":\"\\u540d\\u79f0\",\"value\":\"\\u4e94\\u5927\\u54c1\\u8d28\\u4fdd\\u8bc1\",\"type\":\"text\",\"tip\":\"\",\"rule\":{\"require\":true}},\"alias\":{\"title\":\"\\u522b\\u540d\",\"value\":\"Five quality assurance\",\"type\":\"text\",\"tip\":\"\",\"rule\":{\"require\":true}},\"one_name\":{\"title\":\"1-\\u540d\\u79f0\",\"value\":\"\\u9500\\u552e\\u7f51\\u7edc\",\"type\":\"text\",\"tip\":\"\",\"rule\":{\"require\":true}},\"one_alias\":{\"title\":\"1-\\u522b\\u540d\",\"value\":\"The sales network\",\"type\":\"text\",\"tip\":\"\",\"rule\":{\"require\":true}},\"one_desc\":{\"title\":\"1-\\u63cf\\u8ff0\",\"value\":\"\\u7528\\u4e13\\u4e1a\\u7684\\u4eba\\u505a\\u4e13\\u4e1a\\u7684\\u4e8b\\r\\n\\u591f\\u9510\\u5229 \\u80fd\\u8fa8\\u8bc6\\u53cc\\u65b9\\u7684\\u4ef7\\u503c\\u89c2---\\u6c9f\\u901a\\u548c\\u4e92\\u52a8\\r\\n\\u591f\\u611f\\u6027 \\u80fd\\u627e\\u5230\\u542f\\u52a8\\u5ba2\\u6237\\u5fc3\\u6249\\u7684\\u94a5\\u5319\\r\\n\\u591f\\u575a\\u6301 \\u80fd\\u6301\\u7eed\\u5730\\u5efa\\u9020\\u8fd9\\u79cd\\u5173\\u7cfb\\r\\nUse professional people to do professional things\\r\\n\\r\\nSharp enough to recognize the values of both parties - communication and interaction\\r\\n\\r\\nSensitive enough to find the key to a client\'s heart\\r\\n\\r\\nPersistent enough to build this relationship on a sustained basis\",\"type\":\"textarea\",\"tip\":\"\",\"rule\":{\"require\":true}},\"one_image\":{\"title\":\"1-\\u56fe\\u7247\",\"value\":\"default\\/20211111\\/ae67d2aaa3b4dc6edfbb9ed97d89145c.jpg\",\"type\":\"image\",\"tip\":\"\",\"rule\":{\"require\":true}},\"two_name\":{\"title\":\"2-\\u540d\\u79f0\",\"value\":\"\\u578b\\u5f0f\\u68c0\\u9a8c\\u62a5\\u544a\",\"type\":\"text\",\"tip\":\"\",\"rule\":{\"require\":true}},\"two_alias\":{\"title\":\"2-\\u522b\\u540d\",\"value\":\"Type inspection report\",\"type\":\"text\",\"tip\":\"\",\"rule\":{\"require\":true}},\"two_image\":{\"title\":\"2-\\u56fe\\u7247\",\"value\":\"default\\/20211111\\/76541b052eca3a2395a0c6051e341c82.jpg\",\"type\":\"image\",\"tip\":\"\",\"rule\":{\"require\":true}},\"three_name\":{\"title\":\"3-\\u540d\\u79f0\",\"value\":\"\\u8d44\\u8d28\\u8bc1\\u7167\",\"type\":\"text\",\"tip\":\"\",\"rule\":{\"require\":true}},\"three_alias\":{\"title\":\"3-\\u522b\\u540d\",\"value\":\"Qualification certificate\",\"type\":\"text\",\"tip\":\"\",\"rule\":{\"require\":true}},\"three_image\":{\"title\":\"3-\\u56fe\\u7247\",\"value\":\"default\\/20211111\\/7ea0b5cada39f84f54a2813f7b6054fb.jpg\",\"type\":\"image\",\"tip\":\"\",\"rule\":{\"require\":true}},\"four_name\":{\"title\":\"4-\\u540d\\u79f0\",\"value\":\"\\u751f\\u4ea7\\u5de5\\u827a\\/\\u8bbe\\u5907\\u5c55\\u793a\",\"type\":\"text\",\"tip\":\"\",\"rule\":{\"require\":true}},\"four_alias\":{\"title\":\"4-\\u522b\\u540d\",\"value\":\"Display of production process equipment\",\"type\":\"text\",\"tip\":\"\",\"rule\":{\"require\":true}},\"four_image\":{\"title\":\"4-\\u56fe\\u7247\",\"value\":\"default\\/20211111\\/31bd3ec268660e52aba79f66c108ace2.jpg\",\"type\":\"image\",\"tip\":\"\",\"rule\":{\"require\":true}},\"five_name\":{\"title\":\"5-\\u540d\\u79f0\",\"value\":\"\\u5b8c\\u5584\\u7684\\u68c0\\u6d4b\\u624b\\u6bb5\",\"type\":\"text\",\"tip\":\"\",\"rule\":{\"require\":true}},\"five_alias\":{\"title\":\"5-\\u522b\\u540d\",\"value\":\"Perfect detection means\",\"type\":\"text\",\"tip\":\"\",\"rule\":{\"require\":true}},\"five_image\":{\"title\":\"5-\\u56fe\\u7247\",\"value\":\"default\\/20211111\\/55b32f18b51ee8d8d5809e32720ae6b2.jpg\",\"type\":\"image\",\"tip\":\"\",\"rule\":{\"require\":true}}}},\"page4\":{\"title\":\"\\u9996\\u9875\\u7b2c\\u56db\\u680f\",\"display\":1,\"vars\":{\"name\":{\"title\":\"\\u540d\\u79f0\",\"value\":\"\\u6210\\u529f\\u6848\\u4f8b\",\"type\":\"text\",\"tip\":\"\",\"rule\":{\"require\":true}},\"alias\":{\"title\":\"\\u522b\\u540d\",\"value\":\"SUCCESS CASES\",\"type\":\"text\",\"tip\":\"\",\"rule\":{\"require\":true}},\"category_id\":{\"title\":\"\\u6587\\u7ae0\\u5206\\u7c7bID\",\"value\":\"17\",\"type\":\"text\",\"dataSource\":{\"api\":\"portal\\/Category\\/index\",\"multi\":true},\"placeholder\":\"\\u8bf7\\u9009\\u62e9\\u5206\\u7c7b\",\"tip\":\"\",\"rule\":{\"require\":true},\"valueText\":\"\\u6210\\u529f\\u6848\\u4f8b\"}}},\"page5\":{\"title\":\"\\u9996\\u9875\\u7b2c\\u4e94\\u680f\",\"display\":1,\"vars\":{\"name\":{\"title\":\"\\u540d\\u79f0\",\"value\":\"\\u65b0\\u95fb\\u4e2d\\u5fc3\",\"type\":\"text\",\"tip\":\"\",\"rule\":{\"require\":true}},\"alias\":{\"title\":\"\\u522b\\u540d\",\"value\":\"NEWS CENTER\",\"type\":\"text\",\"tip\":\"\",\"rule\":{\"require\":true}},\"category_id\":{\"title\":\"\\u6587\\u7ae0\\u5206\\u7c7bID\",\"value\":\"16\",\"type\":\"text\",\"dataSource\":{\"api\":\"portal\\/Category\\/index\",\"multi\":true},\"placeholder\":\"\\u8bf7\\u9009\\u62e9\\u5206\\u7c7b\",\"tip\":\"\",\"rule\":{\"require\":true},\"valueText\":\"\\u65b0\\u95fb\\u8d44\\u8baf\"}}},\"page6\":{\"title\":\"\\u9996\\u9875\\u7b2c\\u516d\\u680f\",\"display\":1,\"vars\":{\"name\":{\"title\":\"\\u540d\\u79f0\",\"value\":\"\\u5408\\u4f5c\\u4f19\\u4f34\",\"type\":\"text\",\"tip\":\"\",\"rule\":{\"require\":true}},\"alias\":{\"title\":\"\\u522b\\u540d\",\"value\":\"PARTNER\",\"type\":\"text\",\"tip\":\"\",\"rule\":{\"require\":true}}}},\"page7\":{\"title\":\"\\u9996\\u9875\\u7b2c\\u4e03\\u680f\",\"display\":1,\"vars\":{\"name\":{\"title\":\"\\u540d\\u79f0\",\"value\":\"\\u8054\\u7cfb\\u6211\\u4eec\",\"type\":\"text\",\"tip\":\"\",\"rule\":{\"require\":true}},\"alias\":{\"title\":\"\\u522b\\u540d\",\"value\":\"CONTACT US\",\"type\":\"text\",\"tip\":\"\",\"rule\":{\"require\":true}}}}}}' , `config_more` = '{\"widgets\":{\"page1\":{\"title\":\"\\u9996\\u9875\\u7b2c\\u4e00\\u680f\",\"display\":\"1\",\"vars\":{\"name\":{\"title\":\"\\u6807\\u9898\",\"value\":\"\",\"type\":\"text\",\"tip\":\"\",\"rule\":{\"require\":true}},\"alias\":{\"title\":\"\\u522b\\u540d\",\"value\":\"\",\"type\":\"text\",\"tip\":\"\",\"rule\":{\"require\":true}},\"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}}}},\"page2\":{\"title\":\"\\u9996\\u9875\\u7b2c\\u4e8c\\u680f\",\"display\":\"1\",\"vars\":{\"name\":{\"title\":\"\\u540d\\u79f0\",\"value\":\"\",\"type\":\"text\",\"tip\":\"\",\"rule\":{\"require\":true}},\"alias\":{\"title\":\"\\u522b\\u540d\",\"value\":\"\",\"type\":\"text\",\"tip\":\"\",\"rule\":{\"require\":true}},\"desc\":{\"title\":\"\\u6587\\u5b57\\u63cf\\u8ff0\",\"value\":\"\",\"type\":\"textarea\",\"tip\":\"\",\"rule\":{\"require\":true}},\"image\":{\"title\":\"\\u56fe\\u7247\",\"value\":\"\",\"type\":\"image\",\"tip\":\"\",\"rule\":{\"require\":true}},\"more_link\":{\"title\":\"\\u94fe\\u63a5\",\"value\":\"\",\"type\":\"text\",\"tip\":\"\",\"rule\":{\"require\":true}}}},\"page3\":{\"title\":\"\\u9996\\u9875\\u7b2c\\u4e09\\u680f\",\"display\":\"1\",\"vars\":{\"name\":{\"title\":\"\\u540d\\u79f0\",\"value\":\"\",\"type\":\"text\",\"tip\":\"\",\"rule\":{\"require\":true}},\"alias\":{\"title\":\"\\u522b\\u540d\",\"value\":\"\",\"type\":\"text\",\"tip\":\"\",\"rule\":{\"require\":true}},\"one_name\":{\"title\":\"1-\\u540d\\u79f0\",\"value\":\"\",\"type\":\"text\",\"tip\":\"\",\"rule\":{\"require\":true}},\"one_alias\":{\"title\":\"1-\\u522b\\u540d\",\"value\":\"\",\"type\":\"text\",\"tip\":\"\",\"rule\":{\"require\":true}},\"one_desc\":{\"title\":\"1-\\u63cf\\u8ff0\",\"value\":\"\",\"type\":\"textarea\",\"tip\":\"\",\"rule\":{\"require\":true}},\"one_image\":{\"title\":\"1-\\u56fe\\u7247\",\"value\":\"\",\"type\":\"image\",\"tip\":\"\",\"rule\":{\"require\":true}},\"two_name\":{\"title\":\"2-\\u540d\\u79f0\",\"value\":\"\",\"type\":\"text\",\"tip\":\"\",\"rule\":{\"require\":true}},\"two_alias\":{\"title\":\"2-\\u522b\\u540d\",\"value\":\"\",\"type\":\"text\",\"tip\":\"\",\"rule\":{\"require\":true}},\"two_image\":{\"title\":\"2-\\u56fe\\u7247\",\"value\":\"\",\"type\":\"image\",\"tip\":\"\",\"rule\":{\"require\":true}},\"three_name\":{\"title\":\"3-\\u540d\\u79f0\",\"value\":\"\",\"type\":\"text\",\"tip\":\"\",\"rule\":{\"require\":true}},\"three_alias\":{\"title\":\"3-\\u522b\\u540d\",\"value\":\"\",\"type\":\"text\",\"tip\":\"\",\"rule\":{\"require\":true}},\"three_image\":{\"title\":\"3-\\u56fe\\u7247\",\"value\":\"\",\"type\":\"image\",\"tip\":\"\",\"rule\":{\"require\":true}},\"four_name\":{\"title\":\"4-\\u540d\\u79f0\",\"value\":\"\",\"type\":\"text\",\"tip\":\"\",\"rule\":{\"require\":true}},\"four_alias\":{\"title\":\"4-\\u522b\\u540d\",\"value\":\"\",\"type\":\"text\",\"tip\":\"\",\"rule\":{\"require\":true}},\"four_image\":{\"title\":\"4-\\u56fe\\u7247\",\"value\":\"\",\"type\":\"image\",\"tip\":\"\",\"rule\":{\"require\":true}},\"five_name\":{\"title\":\"5-\\u540d\\u79f0\",\"value\":\"\",\"type\":\"text\",\"tip\":\"\",\"rule\":{\"require\":true}},\"five_alias\":{\"title\":\"5-\\u522b\\u540d\",\"value\":\"\",\"type\":\"text\",\"tip\":\"\",\"rule\":{\"require\":true}},\"five_image\":{\"title\":\"5-\\u56fe\\u7247\",\"value\":\"\",\"type\":\"image\",\"tip\":\"\",\"rule\":{\"require\":true}}}},\"page4\":{\"title\":\"\\u9996\\u9875\\u7b2c\\u56db\\u680f\",\"display\":\"1\",\"vars\":{\"name\":{\"title\":\"\\u540d\\u79f0\",\"value\":\"\",\"type\":\"text\",\"tip\":\"\",\"rule\":{\"require\":true}},\"alias\":{\"title\":\"\\u522b\\u540d\",\"value\":\"\",\"type\":\"text\",\"tip\":\"\",\"rule\":{\"require\":true}},\"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}}}},\"page5\":{\"title\":\"\\u9996\\u9875\\u7b2c\\u4e94\\u680f\",\"display\":\"1\",\"vars\":{\"name\":{\"title\":\"\\u540d\\u79f0\",\"value\":\"\",\"type\":\"text\",\"tip\":\"\",\"rule\":{\"require\":true}},\"alias\":{\"title\":\"\\u522b\\u540d\",\"value\":\"\",\"type\":\"text\",\"tip\":\"\",\"rule\":{\"require\":true}},\"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}}}},\"page6\":{\"title\":\"\\u9996\\u9875\\u7b2c\\u516d\\u680f\",\"display\":\"1\",\"vars\":{\"name\":{\"title\":\"\\u540d\\u79f0\",\"value\":\"\",\"type\":\"text\",\"tip\":\"\",\"rule\":{\"require\":true}},\"alias\":{\"title\":\"\\u522b\\u540d\",\"value\":\"\",\"type\":\"text\",\"tip\":\"\",\"rule\":{\"require\":true}}}},\"page7\":{\"title\":\"\\u9996\\u9875\\u7b2c\\u4e03\\u680f\",\"display\":\"1\",\"vars\":{\"name\":{\"title\":\"\\u540d\\u79f0\",\"value\":\"\",\"type\":\"text\",\"tip\":\"\",\"rule\":{\"require\":true}},\"alias\":{\"title\":\"\\u522b\\u540d\",\"value\":\"\",\"type\":\"text\",\"tip\":\"\",\"rule\":{\"require\":true}}}}}}' , `description` = '首頁模板文件' , `is_public` = 0 , `list_order` = 5 WHERE `theme` = 'simpleboot3' AND `file` = 'portal/index' [ RunTime:0.171599s ]
[ SQL ] SELECT * FROM `cmf_theme_file` WHERE `theme` = 'simpleboot3' AND `file` = 'public/config' LIMIT 1 [ RunTime:0.000000s ]
[ SQL ] SHOW COLUMNS FROM `cmf_portal_post` [ RunTime:0.015600s ]
[ 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` = '16' ) AND ( `post`.`published_time` > '0' and `post`.`published_time` < '1637169278' ) GROUP BY `post`.`id` ) `_group_count_` 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`.`post_status` = '1' AND `post`.`post_type` = '1' AND `post`.`delete_time` = '0' AND ( `post`.`create_time` >= '0' ) AND ( `category_post`.`category_id` = '16' ) AND ( `post`.`published_time` > '0' and `post`.`published_time` < '1637169278' ) GROUP BY `post`.`id` ORDER BY `post`.`create_time` DESC LIMIT 8,8 [ RunTime:0.015600s ]
