[ DB ] CONNECT:[ UseTime:0.002729s ] pgsql:dbname=icbc_cms;host=127.0.0.1;port=5432
[ SQL ] SELECT column_name as field,data_type as type,character_maximum_length as length,is_nullable as null,column_default as default,column_default as extra FROM information_schema.columns WHERE table_schema='public' AND table_name='cmf_portal_category' ORDER BY ordinal_position; [ RunTime:0.010986s ]
[ SQL ] SELECT indexname AS key_name,indexdef AS index_definition FROM pg_indexes WHERE schemaname='public' AND tablename='cmf_portal_category' [ RunTime:0.001795s ]
[ SQL ] SELECT column_name as field,data_type as type FROM information_schema.columns WHERE table_schema='public' AND table_name='cmf_portal_category' ORDER BY ordinal_position; [ RunTime:0.004330s ]
[ SQL ] SELECT * FROM cmf_portal_category WHERE id = 22 AND status = 1 LIMIT 1 [ RunTime:0.000875s ]
[ SQL ] SELECT column_name as field,data_type as type,character_maximum_length as length,is_nullable as null,column_default as default,column_default as extra FROM information_schema.columns WHERE table_schema='public' AND table_name='cmf_theme_file' ORDER BY ordinal_position; [ RunTime:0.009165s ]
[ SQL ] SELECT indexname AS key_name,indexdef AS index_definition FROM pg_indexes WHERE schemaname='public' AND tablename='cmf_theme_file' [ RunTime:0.001406s ]
[ SQL ] SELECT column_name as field,data_type as type FROM information_schema.columns WHERE table_schema='public' AND table_name='cmf_theme_file' ORDER BY ordinal_position; [ RunTime:0.004048s ]
[ SQL ] SELECT * FROM cmf_theme_file WHERE theme = 'simpleboot3' AND file = 'portal/advanced' LIMIT 1 [ RunTime:0.000765s ]
[ SQL ] SELECT column_name as field,data_type as type FROM information_schema.columns WHERE table_schema='public' AND table_name='cmf_theme_file' ORDER BY ordinal_position; [ RunTime:0.004152s ]
[ SQL ] SELECT column_name as field,data_type as type FROM information_schema.columns WHERE table_schema='public' AND table_name='cmf_theme_file' ORDER BY ordinal_position; [ RunTime:0.004082s ]
[ SQL ] UPDATE cmf_theme_file SET theme='simpleboot3',action='portal/search/advanced',file='portal/advanced',name='高级搜索页面',more='[]',config_more='[]',description='高级搜索模板文件',is_public=0,list_order=10 WHERE theme = 'simpleboot3' AND file = 'portal/advanced' [ RunTime:0.003154s ]
[ SQL ] SELECT column_name as field,data_type as type FROM information_schema.columns WHERE table_schema='public' AND table_name='cmf_theme_file' ORDER BY ordinal_position; [ RunTime:0.004346s ]
[ SQL ] SELECT * FROM cmf_theme_file WHERE theme = 'simpleboot3' AND file = 'portal/article' LIMIT 1 [ RunTime:0.000543s ]
[ SQL ] SELECT column_name as field,data_type as type FROM information_schema.columns WHERE table_schema='public' AND table_name='cmf_theme_file' ORDER BY ordinal_position; [ RunTime:0.004130s ]
[ SQL ] SELECT column_name as field,data_type as type FROM information_schema.columns WHERE table_schema='public' AND table_name='cmf_theme_file' ORDER BY ordinal_position; [ RunTime:0.004096s ]
[ SQL ] UPDATE cmf_theme_file SET theme='simpleboot3',action='portal/Article/index',file='portal/article',name='文章页',more='{"vars":{"hot_articles_category_id":{"title":"Hot Articles\u5206\u7c7bID","value":"1","type":"text","tip":"","rule":[]}}}',config_more='{"vars":{"hot_articles_category_id":{"title":"Hot Articles\u5206\u7c7bID","value":"1","type":"text","tip":"","rule":[]}}}',description='文章页模板文件',is_public=0,list_order=10 WHERE theme = 'simpleboot3' AND file = 'portal/article' [ RunTime:0.001754s ]
[ SQL ] SELECT column_name as field,data_type as type FROM information_schema.columns WHERE table_schema='public' AND table_name='cmf_theme_file' ORDER BY ordinal_position; [ RunTime:0.004294s ]
[ SQL ] SELECT * FROM cmf_theme_file WHERE theme = 'simpleboot3' AND file = 'portal/contact' LIMIT 1 [ RunTime:0.001668s ]
[ SQL ] SELECT column_name as field,data_type as type FROM information_schema.columns WHERE table_schema='public' AND table_name='cmf_theme_file' ORDER BY ordinal_position; [ RunTime:0.004496s ]
[ SQL ] SELECT column_name as field,data_type as type FROM information_schema.columns WHERE table_schema='public' AND table_name='cmf_theme_file' ORDER BY ordinal_position; [ RunTime:0.004421s ]
[ SQL ] UPDATE cmf_theme_file SET theme='simpleboot3',action='portal/Page/index',file='portal/contact',name='联系我们页',more='{"vars":{"baidu_map_info_window_text":{"title":"\u767e\u5ea6\u5730\u56fe\u6807\u6ce8\u6587\u5b57","name":"baidu_map_info_window_text","value":"ThinkCMF<br\/><span class=''''>\u5730\u5740\uff1a\u4e0a\u6d77\u5e02\u5f90\u6c47\u533a\u659c\u571f\u8def2601\u53f7<\/span>","type":"text","tip":"\u767e\u5ea6\u5730\u56fe\u6807\u6ce8\u6587\u5b57,\u652f\u6301\u7b80\u5355html\u4ee3\u7801","rule":[]},"company_location":{"title":"\u516c\u53f8\u5750\u6807","value":"","type":"location","tip":"","rule":{"require":true}},"address_cn":{"title":"\u516c\u53f8\u5730\u5740","value":"\u4e0a\u6d77\u5e02\u5f90\u6c47\u533a\u659c\u571f\u8def0001\u53f7","type":"text","tip":"","rule":{"require":true}},"address_en":{"title":"\u516c\u53f8\u5730\u5740\uff08\u82f1\u6587\uff09","value":"NO.0001 Xie Tu Road, Shanghai China","type":"text","tip":"","rule":{"require":true}},"email":{"title":"\u516c\u53f8\u90ae\u7bb1","value":"catman@thinkcmf.com","type":"text","tip":"","rule":{"require":true}},"phone_cn":{"title":"\u516c\u53f8\u7535\u8bdd","value":"021 1000 0001","type":"text","tip":"","rule":{"require":true}},"phone_en":{"title":"\u516c\u53f8\u7535\u8bdd\uff08\u82f1\u6587\uff09","value":"+8621 1000 0001","type":"text","tip":"","rule":{"require":true}},"qq":{"title":"\u8054\u7cfbQQ","value":"478519726","type":"text","tip":"\u591a\u4e2a QQ\u4ee5\u82f1\u6587\u9017\u53f7\u9694\u5f00","rule":{"require":true}}}}',config_more='{"vars":{"baidu_map_info_window_text":{"title":"\u767e\u5ea6\u5730\u56fe\u6807\u6ce8\u6587\u5b57","name":"baidu_map_info_window_text","value":"ThinkCMF<br\/><span class=''''>\u5730\u5740\uff1a\u4e0a\u6d77\u5e02\u5f90\u6c47\u533a\u659c\u571f\u8def2601\u53f7<\/span>","type":"text","tip":"\u767e\u5ea6\u5730\u56fe\u6807\u6ce8\u6587\u5b57,\u652f\u6301\u7b80\u5355html\u4ee3\u7801","rule":[]},"company_location":{"title":"\u516c\u53f8\u5750\u6807","value":"","type":"location","tip":"","rule":{"require":true}},"address_cn":{"title":"\u516c\u53f8\u5730\u5740","value":"\u4e0a\u6d77\u5e02\u5f90\u6c47\u533a\u659c\u571f\u8def0001\u53f7","type":"text","tip":"","rule":{"require":true}},"address_en":{"title":"\u516c\u53f8\u5730\u5740\uff08\u82f1\u6587\uff09","value":"NO.0001 Xie Tu Road, Shanghai China","type":"text","tip":"","rule":{"require":true}},"email":{"title":"\u516c\u53f8\u90ae\u7bb1","value":"catman@thinkcmf.com","type":"text","tip":"","rule":{"require":true}},"phone_cn":{"title":"\u516c\u53f8\u7535\u8bdd","value":"021 1000 0001","type":"text","tip":"","rule":{"require":true}},"phone_en":{"title":"\u516c\u53f8\u7535\u8bdd\uff08\u82f1\u6587\uff09","value":"+8621 1000 0001","type":"text","tip":"","rule":{"require":true}},"qq":{"title":"\u8054\u7cfbQQ","value":"478519726","type":"text","tip":"\u591a\u4e2a QQ\u4ee5\u82f1\u6587\u9017\u53f7\u9694\u5f00","rule":{"require":true}}}}',description='联系我们页模板文件',is_public=0,list_order=10 WHERE theme = 'simpleboot3' AND file = 'portal/contact' [ RunTime:0.001747s ]
[ SQL ] SELECT column_name as field,data_type as type FROM information_schema.columns WHERE table_schema='public' AND table_name='cmf_theme_file' ORDER BY ordinal_position; [ RunTime:0.004378s ]
[ SQL ] SELECT * FROM cmf_theme_file WHERE theme = 'simpleboot3' AND file = 'portal/index' LIMIT 1 [ RunTime:0.000667s ]
[ SQL ] SELECT column_name as field,data_type as type FROM information_schema.columns WHERE table_schema='public' AND table_name='cmf_theme_file' ORDER BY ordinal_position; [ RunTime:0.004073s ]
[ SQL ] SELECT column_name as field,data_type as type FROM information_schema.columns WHERE table_schema='public' AND table_name='cmf_theme_file' ORDER BY ordinal_position; [ RunTime:0.004128s ]
[ SQL ] UPDATE cmf_theme_file SET theme='simpleboot3',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":{"features":{"title":"\u5feb\u901f\u4e86\u89e3ThinkCMF","display":"1","vars":{"sub_title":{"title":"\u526f\u6807\u9898","value":"Quickly understand the ThinkCMF","type":"text","placeholder":"\u8bf7\u8f93\u5165\u526f\u6807\u9898","tip":"","rule":{"require":true}},"features":{"title":"\u7279\u6027\u4ecb\u7ecd","value":[{"title":"MVC\u5206\u5c42\u6a21\u5f0f","icon":"bars","content":"\u4f7f\u7528MVC\u5e94\u7528\u7a0b\u5e8f\u88ab\u5206\u6210\u4e09\u4e2a\u6838\u5fc3\u90e8\u4ef6\uff1a\u6a21\u578b\uff08M\uff09\u3001\u89c6\u56fe\uff08V\uff09\u3001\u63a7\u5236\u5668\uff08C\uff09\uff0c\u4ed6\u4e0d\u662f\u4e00\u4e2a\u65b0\u7684\u6982\u5ff5\uff0c\u53ea\u662fThinkCMF\u5c06\u5176\u53d1\u6325\u5230\u4e86\u6781\u81f4\u3002"},{"title":"\u7528\u6237\u7ba1\u7406","icon":"group","content":"ThinkCMF\u5185\u7f6e\u4e86\u7075\u6d3b\u7684\u7528\u6237\u7ba1\u7406\u65b9\u5f0f\uff0c\u5e76\u53ef\u76f4\u63a5\u4e0e\u7b2c\u4e09\u65b9\u7ad9\u70b9\u8fdb\u884c\u4e92\u8054\u4e92\u901a\uff0c\u5982\u679c\u4f60\u613f\u610f\u751a\u81f3\u53ef\u4ee5\u5bf9\u5355\u4e2a\u7528\u6237\u6216\u7fa4\u4f53\u7528\u6237\u7684\u884c\u4e3a\u8fdb\u884c\u8bb0\u5f55\u53ca\u5206\u4eab\uff0c\u4e3a\u60a8\u7684\u8fd0\u8425\u51b3\u7b56\u63d0\u4f9b\u6709\u6548\u53c2\u8003\u6570\u636e\u3002"},{"title":"\u4e91\u7aef\u90e8\u7f72","icon":"cloud","content":"\u901a\u8fc7\u9a71\u52a8\u7684\u65b9\u5f0f\u53ef\u4ee5\u8f7b\u677e\u652f\u6301\u4e91\u5e73\u53f0\u7684\u90e8\u7f72\uff0c\u8ba9\u4f60\u7684\u7f51\u7ad9\u65e0\u7f1d\u8fc1\u79fb\uff0c\u5185\u7f6e\u5df2\u7ecf\u652f\u6301SAE\u3001BAE\uff0c\u6b63\u5f0f\u7248\u5c06\u5bf9\u4e91\u7aef\u90e8\u7f72\u8fdb\u884c\u8fdb\u4e00\u6b65\u4f18\u5316\u3002"},{"title":"\u5b89\u5168\u7b56\u7565","icon":"heart","content":"\u63d0\u4f9b\u7684\u7a33\u5065\u7684\u5b89\u5168\u7b56\u7565\uff0c\u5305\u62ec\u5907\u4efd\u6062\u590d\uff0c\u5bb9\u9519\uff0c\u9632\u6cbb\u6076\u610f\u653b\u51fb\u767b\u9646\uff0c\u7f51\u9875\u9632\u7be1\u6539\u7b49\u591a\u9879\u5b89\u5168\u7ba1\u7406\u529f\u80fd\uff0c\u4fdd\u8bc1\u7cfb\u7edf\u5b89\u5168\uff0c\u53ef\u9760\uff0c\u7a33\u5b9a\u7684\u8fd0\u884c\u3002"},{"title":"\u5e94\u7528\u6a21\u5757\u5316","icon":"cubes","content":"\u63d0\u51fa\u5168\u65b0\u7684\u5e94\u7528\u6a21\u5f0f\u8fdb\u884c\u6269\u5c55\uff0c\u4e0d\u7ba1\u662f\u4f60\u5f00\u53d1\u4e00\u4e2a\u5c0f\u529f\u80fd\u8fd8\u662f\u4e00\u4e2a\u5168\u65b0\u7684\u7ad9\u70b9\uff0c\u5728ThinkCMF\u4e2d\u4f60\u53ea\u662f\u589e\u52a0\u4e86\u4e00\u4e2aAPP\uff0c\u6bcf\u4e2a\u72ec\u7acb\u8fd0\u884c\u4e92\u4e0d\u5f71\u54cd\uff0c\u4fbf\u4e8e\u7075\u6d3b\u6269\u5c55\u548c\u4e8c\u6b21\u5f00\u53d1\u3002"},{"title":"\u514d\u8d39\u5f00\u6e90","icon":"certificate","content":"\u4ee3\u7801\u9075\u5faaApache2\u5f00\u6e90\u534f\u8bae\uff0c\u514d\u8d39\u4f7f\u7528\uff0c\u5bf9\u5546\u4e1a\u7528\u6237\u4e5f\u65e0\u4efb\u4f55\u9650\u5236\u3002"}],"type":"array","item":{"title":{"title":"\u6807\u9898","value":"","type":"text","rule":{"require":true}},"icon":{"title":"\u56fe\u6807","value":"","type":"text"},"content":{"title":"\u63cf\u8ff0","value":"","type":"textarea"}},"tip":""}}},"last_news":{"title":"\u6700\u65b0\u8d44\u8baf","display":"1","vars":{"last_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}}}}}}',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":{"features":{"title":"\u5feb\u901f\u4e86\u89e3ThinkCMF","display":"1","vars":{"sub_title":{"title":"\u526f\u6807\u9898","value":"Quickly understand the ThinkCMF","type":"text","placeholder":"\u8bf7\u8f93\u5165\u526f\u6807\u9898","tip":"","rule":{"require":true}},"features":{"title":"\u7279\u6027\u4ecb\u7ecd","value":[{"title":"MVC\u5206\u5c42\u6a21\u5f0f","icon":"bars","content":"\u4f7f\u7528MVC\u5e94\u7528\u7a0b\u5e8f\u88ab\u5206\u6210\u4e09\u4e2a\u6838\u5fc3\u90e8\u4ef6\uff1a\u6a21\u578b\uff08M\uff09\u3001\u89c6\u56fe\uff08V\uff09\u3001\u63a7\u5236\u5668\uff08C\uff09\uff0c\u4ed6\u4e0d\u662f\u4e00\u4e2a\u65b0\u7684\u6982\u5ff5\uff0c\u53ea\u662fThinkCMF\u5c06\u5176\u53d1\u6325\u5230\u4e86\u6781\u81f4\u3002"},{"title":"\u7528\u6237\u7ba1\u7406","icon":"group","content":"ThinkCMF\u5185\u7f6e\u4e86\u7075\u6d3b\u7684\u7528\u6237\u7ba1\u7406\u65b9\u5f0f\uff0c\u5e76\u53ef\u76f4\u63a5\u4e0e\u7b2c\u4e09\u65b9\u7ad9\u70b9\u8fdb\u884c\u4e92\u8054\u4e92\u901a\uff0c\u5982\u679c\u4f60\u613f\u610f\u751a\u81f3\u53ef\u4ee5\u5bf9\u5355\u4e2a\u7528\u6237\u6216\u7fa4\u4f53\u7528\u6237\u7684\u884c\u4e3a\u8fdb\u884c\u8bb0\u5f55\u53ca\u5206\u4eab\uff0c\u4e3a\u60a8\u7684\u8fd0\u8425\u51b3\u7b56\u63d0\u4f9b\u6709\u6548\u53c2\u8003\u6570\u636e\u3002"},{"title":"\u4e91\u7aef\u90e8\u7f72","icon":"cloud","content":"\u901a\u8fc7\u9a71\u52a8\u7684\u65b9\u5f0f\u53ef\u4ee5\u8f7b\u677e\u652f\u6301\u4e91\u5e73\u53f0\u7684\u90e8\u7f72\uff0c\u8ba9\u4f60\u7684\u7f51\u7ad9\u65e0\u7f1d\u8fc1\u79fb\uff0c\u5185\u7f6e\u5df2\u7ecf\u652f\u6301SAE\u3001BAE\uff0c\u6b63\u5f0f\u7248\u5c06\u5bf9\u4e91\u7aef\u90e8\u7f72\u8fdb\u884c\u8fdb\u4e00\u6b65\u4f18\u5316\u3002"},{"title":"\u5b89\u5168\u7b56\u7565","icon":"heart","content":"\u63d0\u4f9b\u7684\u7a33\u5065\u7684\u5b89\u5168\u7b56\u7565\uff0c\u5305\u62ec\u5907\u4efd\u6062\u590d\uff0c\u5bb9\u9519\uff0c\u9632\u6cbb\u6076\u610f\u653b\u51fb\u767b\u9646\uff0c\u7f51\u9875\u9632\u7be1\u6539\u7b49\u591a\u9879\u5b89\u5168\u7ba1\u7406\u529f\u80fd\uff0c\u4fdd\u8bc1\u7cfb\u7edf\u5b89\u5168\uff0c\u53ef\u9760\uff0c\u7a33\u5b9a\u7684\u8fd0\u884c\u3002"},{"title":"\u5e94\u7528\u6a21\u5757\u5316","icon":"cubes","content":"\u63d0\u51fa\u5168\u65b0\u7684\u5e94\u7528\u6a21\u5f0f\u8fdb\u884c\u6269\u5c55\uff0c\u4e0d\u7ba1\u662f\u4f60\u5f00\u53d1\u4e00\u4e2a\u5c0f\u529f\u80fd\u8fd8\u662f\u4e00\u4e2a\u5168\u65b0\u7684\u7ad9\u70b9\uff0c\u5728ThinkCMF\u4e2d\u4f60\u53ea\u662f\u589e\u52a0\u4e86\u4e00\u4e2aAPP\uff0c\u6bcf\u4e2a\u72ec\u7acb\u8fd0\u884c\u4e92\u4e0d\u5f71\u54cd\uff0c\u4fbf\u4e8e\u7075\u6d3b\u6269\u5c55\u548c\u4e8c\u6b21\u5f00\u53d1\u3002"},{"title":"\u514d\u8d39\u5f00\u6e90","icon":"certificate","content":"\u4ee3\u7801\u9075\u5faaApache2\u5f00\u6e90\u534f\u8bae\uff0c\u514d\u8d39\u4f7f\u7528\uff0c\u5bf9\u5546\u4e1a\u7528\u6237\u4e5f\u65e0\u4efb\u4f55\u9650\u5236\u3002"}],"type":"array","item":{"title":{"title":"\u6807\u9898","value":"","type":"text","rule":{"require":true}},"icon":{"title":"\u56fe\u6807","value":"","type":"text"},"content":{"title":"\u63cf\u8ff0","value":"","type":"textarea"}},"tip":""}}},"last_news":{"title":"\u6700\u65b0\u8d44\u8baf","display":"1","vars":{"last_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}}}}}}',description='首页模板文件',is_public=0,list_order=5 WHERE theme = 'simpleboot3' AND file = 'portal/index' [ RunTime:0.001774s ]
[ SQL ] SELECT column_name as field,data_type as type FROM information_schema.columns WHERE table_schema='public' AND table_name='cmf_theme_file' ORDER BY ordinal_position; [ RunTime:0.004493s ]
[ SQL ] SELECT * FROM cmf_theme_file WHERE theme = 'simpleboot3' AND file = 'portal/list' LIMIT 1 [ RunTime:0.001528s ]
[ SQL ] SELECT column_name as field,data_type as type FROM information_schema.columns WHERE table_schema='public' AND table_name='cmf_theme_file' ORDER BY ordinal_position; [ RunTime:0.004478s ]
[ SQL ] SELECT column_name as field,data_type as type FROM information_schema.columns WHERE table_schema='public' AND table_name='cmf_theme_file' ORDER BY ordinal_position; [ RunTime:0.004740s ]
[ SQL ] UPDATE cmf_theme_file SET theme='simpleboot3',action='portal/List/index',file='portal/list',name='文章列表页',more='{"vars":[],"widgets":{"hottest_articles":{"title":"\u70ed\u95e8\u6587\u7ae0","display":"1","vars":{"hottest_articles_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}}}},"last_articles":{"title":"\u6700\u65b0\u53d1\u5e03","display":"1","vars":{"last_articles_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}}}}}}',config_more='{"vars":[],"widgets":{"hottest_articles":{"title":"\u70ed\u95e8\u6587\u7ae0","display":"1","vars":{"hottest_articles_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}}}},"last_articles":{"title":"\u6700\u65b0\u53d1\u5e03","display":"1","vars":{"last_articles_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}}}}}}',description='文章列表模板文件',is_public=0,list_order=10 WHERE theme = 'simpleboot3' AND file = 'portal/list' [ RunTime:0.019541s ]
[ SQL ] SELECT column_name as field,data_type as type FROM information_schema.columns WHERE table_schema='public' AND table_name='cmf_theme_file' ORDER BY ordinal_position; [ RunTime:0.025937s ]
[ SQL ] SELECT * FROM cmf_theme_file WHERE theme = 'simpleboot3' AND file = 'portal/list_jckz' LIMIT 1 [ RunTime:0.007953s ]
[ SQL ] SELECT column_name as field,data_type as type FROM information_schema.columns WHERE table_schema='public' AND table_name='cmf_theme_file' ORDER BY ordinal_position; [ RunTime:0.014450s ]
[ SQL ] SELECT column_name as field,data_type as type FROM information_schema.columns WHERE table_schema='public' AND table_name='cmf_theme_file' ORDER BY ordinal_position; [ RunTime:0.032192s ]
[ SQL ] UPDATE cmf_theme_file SET theme='simpleboot3',action='portal/List/index',file='portal/list_jckz',name='基层快照列表页',more='[]',config_more='[]',description='基层快照列表模板文件',is_public=0,list_order=10 WHERE theme = 'simpleboot3' AND file = 'portal/list_jckz' [ RunTime:0.017983s ]
[ SQL ] SELECT column_name as field,data_type as type FROM information_schema.columns WHERE table_schema='public' AND table_name='cmf_theme_file' ORDER BY ordinal_position; [ RunTime:0.007817s ]
[ SQL ] SELECT * FROM cmf_theme_file WHERE theme = 'simpleboot3' AND file = 'portal/list_tw' LIMIT 1 [ RunTime:0.005364s ]
[ SQL ] SELECT column_name as field,data_type as type FROM information_schema.columns WHERE table_schema='public' AND table_name='cmf_theme_file' ORDER BY ordinal_position; [ RunTime:0.013874s ]
[ SQL ] SELECT column_name as field,data_type as type FROM information_schema.columns WHERE table_schema='public' AND table_name='cmf_theme_file' ORDER BY ordinal_position; [ RunTime:0.035808s ]
[ SQL ] UPDATE cmf_theme_file SET theme='simpleboot3',action='portal/List/index',file='portal/list_tw',name='图文列表页',more='[]',config_more='[]',description='图文列表模板文件',is_public=0,list_order=10 WHERE theme = 'simpleboot3' AND file = 'portal/list_tw' [ RunTime:0.007893s ]
[ SQL ] SELECT column_name as field,data_type as type FROM information_schema.columns WHERE table_schema='public' AND table_name='cmf_theme_file' ORDER BY ordinal_position; [ RunTime:0.018875s ]
[ SQL ] SELECT * FROM cmf_theme_file WHERE theme = 'simpleboot3' AND file = 'portal/page' LIMIT 1 [ RunTime:0.003043s ]
[ SQL ] SELECT column_name as field,data_type as type FROM information_schema.columns WHERE table_schema='public' AND table_name='cmf_theme_file' ORDER BY ordinal_position; [ RunTime:0.023405s ]
[ SQL ] SELECT column_name as field,data_type as type FROM information_schema.columns WHERE table_schema='public' AND table_name='cmf_theme_file' ORDER BY ordinal_position; [ RunTime:0.027721s ]
[ SQL ] UPDATE cmf_theme_file SET theme='simpleboot3',action='portal/Page/index',file='portal/page',name='单页面',more='{"widgets":{"hottest_articles":{"title":"\u70ed\u95e8\u6587\u7ae0","display":"1","vars":{"hottest_articles_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}}}},"last_articles":{"title":"\u6700\u65b0\u53d1\u5e03","display":"1","vars":{"last_articles_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}}}}}}',config_more='{"widgets":{"hottest_articles":{"title":"\u70ed\u95e8\u6587\u7ae0","display":"1","vars":{"hottest_articles_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}}}},"last_articles":{"title":"\u6700\u65b0\u53d1\u5e03","display":"1","vars":{"last_articles_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}}}}}}',description='单页面模板文件',is_public=0,list_order=10 WHERE theme = 'simpleboot3' AND file = 'portal/page' [ RunTime:0.006925s ]
[ SQL ] SELECT column_name as field,data_type as type FROM information_schema.columns WHERE table_schema='public' AND table_name='cmf_theme_file' ORDER BY ordinal_position; [ RunTime:0.004744s ]
[ SQL ] SELECT * FROM cmf_theme_file WHERE theme = 'simpleboot3' AND file = 'portal/search' LIMIT 1 [ RunTime:0.015523s ]
[ SQL ] SELECT column_name as field,data_type as type FROM information_schema.columns WHERE table_schema='public' AND table_name='cmf_theme_file' ORDER BY ordinal_position; [ RunTime:0.022209s ]
[ SQL ] SELECT column_name as field,data_type as type FROM information_schema.columns WHERE table_schema='public' AND table_name='cmf_theme_file' ORDER BY ordinal_position; [ RunTime:0.021036s ]
[ SQL ] UPDATE cmf_theme_file SET theme='simpleboot3',action='portal/search/index',file='portal/search',name='搜索页面',more='{"vars":{"varName1":{"title":"\u70ed\u95e8\u641c\u7d22","value":"1","type":"text","tip":"\u8fd9\u662f\u4e00\u4e2atext","rule":{"require":true}}}}',config_more='{"vars":{"varName1":{"title":"\u70ed\u95e8\u641c\u7d22","value":"1","type":"text","tip":"\u8fd9\u662f\u4e00\u4e2atext","rule":{"require":true}}}}',description='搜索模板文件',is_public=0,list_order=10 WHERE theme = 'simpleboot3' AND file = 'portal/search' [ RunTime:0.006081s ]
[ SQL ] SELECT column_name as field,data_type as type FROM information_schema.columns WHERE table_schema='public' AND table_name='cmf_theme_file' ORDER BY ordinal_position; [ RunTime:0.005250s ]
[ SQL ] SELECT * FROM cmf_theme_file WHERE theme = 'simpleboot3' AND file = 'public/config' LIMIT 1 [ RunTime:0.005308s ]
[ SQL ] SELECT column_name as field,data_type as type FROM information_schema.columns WHERE table_schema='public' AND table_name='cmf_theme_file' ORDER BY ordinal_position; [ RunTime:0.004629s ]
[ SQL ] SELECT column_name as field,data_type as type FROM information_schema.columns WHERE table_schema='public' AND table_name='cmf_theme_file' ORDER BY ordinal_position; [ RunTime:0.011035s ]
[ SQL ] UPDATE cmf_theme_file SET theme='simpleboot3',action='public/Config',file='public/config',name='模板全局配置',more='{"vars":{"enable_mobile":{"title":"\u624b\u673a\u6ce8\u518c","value":1,"type":"select","options":{"1":"\u5f00\u542f","0":"\u5173\u95ed"},"tip":""}}}',config_more='{"vars":{"enable_mobile":{"title":"\u624b\u673a\u6ce8\u518c","value":1,"type":"select","options":{"1":"\u5f00\u542f","0":"\u5173\u95ed"},"tip":""}}}',description='模板全局配置文件',is_public=1,list_order=0 WHERE theme = 'simpleboot3' AND file = 'public/config' [ RunTime:0.003313s ]
[ SQL ] SELECT column_name as field,data_type as type FROM information_schema.columns WHERE table_schema='public' AND table_name='cmf_theme_file' ORDER BY ordinal_position; [ RunTime:0.005394s ]
[ SQL ] SELECT * FROM cmf_theme_file WHERE theme = 'simpleboot3' AND file = 'public/nav' LIMIT 1 [ RunTime:0.000702s ]
[ SQL ] SELECT column_name as field,data_type as type FROM information_schema.columns WHERE table_schema='public' AND table_name='cmf_theme_file' ORDER BY ordinal_position; [ RunTime:0.005099s ]
[ SQL ] SELECT column_name as field,data_type as type FROM information_schema.columns WHERE table_schema='public' AND table_name='cmf_theme_file' ORDER BY ordinal_position; [ RunTime:0.004904s ]
[ SQL ] UPDATE cmf_theme_file SET theme='simpleboot3',action='public/Nav',file='public/nav',name='导航条',more='{"vars":{"company_name":{"title":"\u516c\u53f8\u540d\u79f0","name":"company_name","value":"ThinkCMF","type":"text","tip":"","rule":[]}}}',config_more='{"vars":{"company_name":{"title":"\u516c\u53f8\u540d\u79f0","name":"company_name","value":"ThinkCMF","type":"text","tip":"","rule":[]}}}',description='导航条模板文件',is_public=1,list_order=1 WHERE theme = 'simpleboot3' AND file = 'public/nav' [ RunTime:0.001724s ]
[ SQL ] SELECT column_name as field,data_type as type FROM information_schema.columns WHERE table_schema='public' AND table_name='cmf_theme_file' ORDER BY ordinal_position; [ RunTime:0.004466s ]
[ SQL ] SELECT * FROM cmf_theme_file WHERE theme = 'simpleboot3' [ RunTime:0.001598s ]
[ SQL ] SELECT a.attname AS pk_column
FROM pg_constraint c
JOIN pg_attribute a ON a.attrelid = c.conrelid AND a.attnum = ANY(c.conkey)
WHERE c.conrelid = 'cmf_theme'::regclass AND c.contype = 'p' [ RunTime:0.001189s ]
[ SQL ] SELECT a.attname AS pk_column
FROM pg_constraint c
JOIN pg_attribute a ON a.attrelid = c.conrelid AND a.attnum = ANY(c.conkey)
WHERE c.conrelid = 'cmf_theme'::regclass AND c.contype = 'p' [ RunTime:0.000672s ]
[ SQL ] SELECT a.attname AS pk_column
FROM pg_constraint c
JOIN pg_attribute a ON a.attrelid = c.conrelid AND a.attnum = ANY(c.conkey)
WHERE c.conrelid = 'cmf_theme'::regclass AND c.contype = 'p' [ RunTime:0.000628s ]
[ SQL ] SELECT a.attname AS pk_column
FROM pg_constraint c
JOIN pg_attribute a ON a.attrelid = c.conrelid AND a.attnum = ANY(c.conkey)
WHERE c.conrelid = 'cmf_theme'::regclass AND c.contype = 'p' [ RunTime:0.000598s ]
[ SQL ] SELECT a.attname AS pk_column
FROM pg_constraint c
JOIN pg_attribute a ON a.attrelid = c.conrelid AND a.attnum = ANY(c.conkey)
WHERE c.conrelid = 'cmf_theme'::regclass AND c.contype = 'p' [ RunTime:0.000592s ]
[ SQL ] SELECT a.attname AS pk_column
FROM pg_constraint c
JOIN pg_attribute a ON a.attrelid = c.conrelid AND a.attnum = ANY(c.conkey)
WHERE c.conrelid = 'cmf_theme'::regclass AND c.contype = 'p' [ RunTime:0.000589s ]
[ SQL ] SELECT a.attname AS pk_column
FROM pg_constraint c
JOIN pg_attribute a ON a.attrelid = c.conrelid AND a.attnum = ANY(c.conkey)
WHERE c.conrelid = 'cmf_theme'::regclass AND c.contype = 'p' [ RunTime:0.000593s ]
[ SQL ] SELECT a.attname AS pk_column
FROM pg_constraint c
JOIN pg_attribute a ON a.attrelid = c.conrelid AND a.attnum = ANY(c.conkey)
WHERE c.conrelid = 'cmf_theme'::regclass AND c.contype = 'p' [ RunTime:0.000589s ]
[ SQL ] SELECT a.attname AS pk_column
FROM pg_constraint c
JOIN pg_attribute a ON a.attrelid = c.conrelid AND a.attnum = ANY(c.conkey)
WHERE c.conrelid = 'cmf_theme'::regclass AND c.contype = 'p' [ RunTime:0.000587s ]
[ SQL ] SELECT column_name as field,data_type as type FROM information_schema.columns WHERE table_schema='public' AND table_name='cmf_theme' ORDER BY ordinal_position; [ RunTime:0.004133s ]
[ SQL ] SELECT column_name as field,data_type as type,character_maximum_length as length,is_nullable as null,column_default as default,column_default as extra FROM information_schema.columns WHERE table_schema='public' AND table_name='cmf_theme' ORDER BY ordinal_position; [ RunTime:0.008851s ]
[ SQL ] SELECT indexname AS key_name,indexdef AS index_definition FROM pg_indexes WHERE schemaname='public' AND tablename='cmf_theme' [ RunTime:0.001647s ]
[ SQL ] SELECT column_name as field,data_type as type FROM information_schema.columns WHERE table_schema='public' AND table_name='cmf_theme' ORDER BY ordinal_position; [ RunTime:0.004352s ]
[ SQL ] SELECT column_name as field,data_type as type FROM information_schema.columns WHERE table_schema='public' AND table_name='cmf_theme' ORDER BY ordinal_position; [ RunTime:0.004228s ]
[ SQL ] UPDATE cmf_theme SET name='simpleboot3',version='1.0.2',demo_url='http://demo.thinkcmf.com',author='ThinkCMF',lang='zh-cn',author_url='http://www.thinkcmf.com',keywords='ThinkCMF模板',description='ThinkCMF默认模板' WHERE theme = 'simpleboot3' [ RunTime:0.001779s ]
[ SQL ] SELECT column_name as field,data_type as type FROM information_schema.columns WHERE table_schema='public' AND table_name='cmf_theme_file' ORDER BY ordinal_position; [ RunTime:0.004403s ]
[ SQL ] SELECT column_name as field,data_type as type FROM information_schema.columns WHERE table_schema='public' AND table_name='cmf_theme_file' ORDER BY ordinal_position; [ RunTime:0.004328s ]
[ SQL ] SELECT more FROM cmf_theme_file WHERE theme = 'simpleboot3' AND ( is_public = 1 OR file = 'portal/list_tw' ) [ RunTime:0.000738s ]
[ SQL ] SELECT column_name as field,data_type as type FROM information_schema.columns WHERE table_schema='public' AND table_name='cmf_portal_category' ORDER BY ordinal_position; [ RunTime:0.004602s ]
[ SQL ] SELECT path FROM cmf_portal_category WHERE id = 22 LIMIT 1 [ RunTime:0.000729s ]
[ SQL ] SELECT column_name as field,data_type as type FROM information_schema.columns WHERE table_schema='public' AND table_name='cmf_portal_category' ORDER BY ordinal_position; [ RunTime:0.004244s ]
[ SQL ] SELECT * FROM cmf_portal_category WHERE id IN (0,22) ORDER BY path ASC [ RunTime:0.000668s ]
[ SQL ] SELECT column_name as field,data_type as type FROM information_schema.columns WHERE table_schema='public' AND table_name='cmf_portal_post' ORDER BY ordinal_position; [ RunTime:0.004865s ]
[ SQL ] SELECT column_name as field,data_type as type,character_maximum_length as length,is_nullable as null,column_default as default,column_default as extra FROM information_schema.columns WHERE table_schema='public' AND table_name='cmf_portal_post' ORDER BY ordinal_position; [ RunTime:0.009948s ]
[ SQL ] SELECT indexname AS key_name,indexdef AS index_definition FROM pg_indexes WHERE schemaname='public' AND tablename='cmf_portal_post' [ RunTime:0.001529s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM ( SELECT count(*) FROM cmf_portal_post post INNER JOIN cmf_portal_category_post category_post ON post.id=category_post.post_id WHERE ( post.published_time > '0' AND post.published_time < 1766709685 ) AND post.post_status = 1 AND post.post_type = 1 AND post.delete_time = 0 AND category_post.category_id = '22' AND post.create_time >= 0 GROUP BY post.id ) _group_count_ LIMIT 1 [ RunTime:0.001664s ]
[ SQL ] SELECT column_name as field,data_type as type FROM information_schema.columns WHERE table_schema='public' AND table_name='cmf_portal_post' ORDER BY ordinal_position; [ RunTime:0.004534s ]
[ 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.published_time > '0' AND post.published_time < 1766709685 ) AND post.post_status = 1 AND post.post_type = 1 AND post.delete_time = 0 AND category_post.category_id = '22' AND post.create_time >= 0 GROUP BY post.id ORDER BY post.create_time DESC LIMIT 10 OFFSET 10 [ RunTime:0.003736s ]
