[ DB ] CONNECT:[ UseTime:0.002683s ] pgsql:dbname=icbc_cms;host=127.0.0.1;port=5432
[ SQL ] SELECT column_name as field,data_type as type FROM information_schema.columns WHERE table_schema='public' AND table_name='cmf_portal_topic' ORDER BY ordinal_position; [ RunTime:0.006202s ]
[ SQL ] SELECT id,topic_title,thumbnail FROM cmf_portal_topic WHERE status = 1 ORDER BY list_order DESC LIMIT 8 [ RunTime:0.001024s ]
[ 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.009579s ]
[ SQL ] SELECT indexname AS key_name,indexdef AS index_definition FROM pg_indexes WHERE schemaname='public' AND tablename='cmf_theme_file' [ RunTime:0.001816s ]
[ 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.004438s ]
[ SQL ] SELECT * FROM cmf_theme_file WHERE theme = 'simpleboot3' AND file = 'portal/advanced' LIMIT 1 [ RunTime:0.000819s ]
[ 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.004379s ]
[ 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.004547s ]
[ 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.003189s ]
[ 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.004723s ]
[ SQL ] SELECT * FROM cmf_theme_file WHERE theme = 'simpleboot3' AND file = 'portal/article' LIMIT 1 [ RunTime:0.000747s ]
[ 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.004350s ]
[ 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.004559s ]
[ 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.001883s ]
[ 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.004525s ]
[ SQL ] SELECT * FROM cmf_theme_file WHERE theme = 'simpleboot3' AND file = 'portal/contact' LIMIT 1 [ RunTime:0.000769s ]
[ 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.004510s ]
[ 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.004573s ]
[ 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.001852s ]
[ 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.004595s ]
[ SQL ] SELECT * FROM cmf_theme_file WHERE theme = 'simpleboot3' AND file = 'portal/index' LIMIT 1 [ RunTime:0.000680s ]
[ 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.004402s ]
[ 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.004525s ]
[ 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.002861s ]
[ 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.004613s ]
[ SQL ] SELECT * FROM cmf_theme_file WHERE theme = 'simpleboot3' AND file = 'portal/list' LIMIT 1 [ RunTime:0.000652s ]
[ 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.004356s ]
[ 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.004462s ]
[ 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.007385s ]
[ 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.004705s ]
[ SQL ] SELECT * FROM cmf_theme_file WHERE theme = 'simpleboot3' AND file = 'portal/list_jckz' LIMIT 1 [ RunTime:0.000634s ]
[ 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.004456s ]
[ 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.004533s ]
[ 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.001714s ]
[ 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.004495s ]
[ SQL ] SELECT * FROM cmf_theme_file WHERE theme = 'simpleboot3' AND file = 'portal/list_tw' LIMIT 1 [ RunTime:0.000605s ]
[ 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.004332s ]
[ 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.004584s ]
[ 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.001675s ]
[ 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.004577s ]
[ SQL ] SELECT * FROM cmf_theme_file WHERE theme = 'simpleboot3' AND file = 'portal/page' LIMIT 1 [ RunTime:0.000596s ]
[ 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.004385s ]
[ 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.004476s ]
[ 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.001660s ]
[ 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.004512s ]
[ SQL ] SELECT * FROM cmf_theme_file WHERE theme = 'simpleboot3' AND file = 'portal/search' LIMIT 1 [ RunTime:0.000646s ]
[ 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.004605s ]
[ 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.004581s ]
[ 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.001708s ]
[ 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.004612s ]
[ SQL ] SELECT * FROM cmf_theme_file WHERE theme = 'simpleboot3' AND file = 'public/config' LIMIT 1 [ RunTime:0.000728s ]
[ 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.004691s ]
[ 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.004433s ]
[ 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.001679s ]
[ 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.004423s ]
[ SQL ] SELECT * FROM cmf_theme_file WHERE theme = 'simpleboot3' AND file = 'public/nav' LIMIT 1 [ RunTime:0.000625s ]
[ 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.004267s ]
[ 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.004332s ]
[ 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.001579s ]
[ 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.004515s ]
[ SQL ] SELECT * FROM cmf_theme_file WHERE theme = 'simpleboot3' [ RunTime:0.000773s ]
[ 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.001158s ]
[ 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.000680s ]
[ 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.000600s ]
[ 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.000569s ]
[ 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.000660s ]
[ 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.000656s ]
[ 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.000645s ]
[ 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.000644s ]
[ 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.000597s ]
[ 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,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.009232s ]
[ SQL ] SELECT indexname AS key_name,indexdef AS index_definition FROM pg_indexes WHERE schemaname='public' AND tablename='cmf_theme' [ RunTime:0.001378s ]
[ 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.004304s ]
[ 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.004301s ]
[ 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.001746s ]
[ 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.004381s ]
[ 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.004307s ]
[ SQL ] SELECT more FROM cmf_theme_file WHERE theme = 'simpleboot3' AND ( is_public = 1 OR file = 'portal/index' ) [ RunTime:0.000646s ]
[ 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.004756s ]
[ 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.009986s ]
[ SQL ] SELECT indexname AS key_name,indexdef AS index_definition FROM pg_indexes WHERE schemaname='public' AND tablename='cmf_portal_post' [ RunTime:0.001709s ]
[ 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 < 1766696740 ) AND post.post_status = 1 AND post.post_type = 1 AND post.delete_time = 0 AND category_post.category_id = '17' GROUP BY post.id ORDER BY post.create_time DESC LIMIT 5 [ RunTime:0.003926s ]
[ 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.004836s ]
[ 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 < 1766696740 ) AND post.post_status = 1 AND post.post_type = 1 AND post.delete_time = 0 AND thumbnail <> '' GROUP BY post.id ORDER BY published_time DESC LIMIT 5 [ RunTime:0.001929s ]
[ 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.004763s ]
[ 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 < 1766696740 ) AND post.post_status = 1 AND post.post_type = 1 AND post.delete_time = 0 AND category_post.category_id = '19' GROUP BY post.id ORDER BY published_time DESC LIMIT 8 [ RunTime:0.003716s ]
[ 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.004974s ]
[ 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 < 1766696740 ) AND post.post_status = 1 AND post.post_type = 1 AND post.delete_time = 0 AND category_post.category_id = '17' GROUP BY post.id ) _group_count_ LIMIT 1 [ RunTime:0.001382s ]
[ 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.004976s ]
[ 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 < 1766696740 ) AND post.post_status = 1 AND post.post_type = 1 AND post.delete_time = 0 AND category_post.category_id = '17' GROUP BY post.id ORDER BY published_time DESC LIMIT 7 OFFSET 0 [ RunTime:0.003731s ]
[ 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.005088s ]
[ 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 < 1766696740 ) AND post.post_status = 1 AND post.post_type = 1 AND post.delete_time = 0 AND category_post.category_id = '17' GROUP BY post.id ) _group_count_ LIMIT 1 [ RunTime:0.001434s ]
[ 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.004724s ]
[ 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 < 1766696740 ) AND post.post_status = 1 AND post.post_type = 1 AND post.delete_time = 0 AND category_post.category_id = '17' GROUP BY post.id ORDER BY published_time DESC LIMIT 7 OFFSET 7 [ RunTime:0.003769s ]
[ 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.004807s ]
[ 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 < 1766696740 ) AND post.post_status = 1 AND post.post_type = 1 AND post.delete_time = 0 AND category_post.category_id = '20' GROUP BY post.id ) _group_count_ LIMIT 1 [ RunTime:0.001337s ]
[ 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.004709s ]
[ 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 < 1766696740 ) AND post.post_status = 1 AND post.post_type = 1 AND post.delete_time = 0 AND category_post.category_id = '20' GROUP BY post.id ORDER BY published_time DESC LIMIT 7 OFFSET 0 [ RunTime:0.003413s ]
[ 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.004777s ]
[ 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 < 1766696740 ) AND post.post_status = 1 AND post.post_type = 1 AND post.delete_time = 0 AND category_post.category_id = '20' GROUP BY post.id ) _group_count_ LIMIT 1 [ RunTime:0.001327s ]
[ 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.004268s ]
[ 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 < 1766696740 ) AND post.post_status = 1 AND post.post_type = 1 AND post.delete_time = 0 AND category_post.category_id = '20' GROUP BY post.id ORDER BY published_time DESC LIMIT 7 OFFSET 7 [ RunTime:0.003556s ]
[ 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.004639s ]
[ 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 < 1766696740 ) AND post.post_status = 1 AND post.post_type = 1 AND post.delete_time = 0 AND category_post.category_id = '21' GROUP BY post.id ) _group_count_ LIMIT 1 [ RunTime:0.001197s ]
[ 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.004616s ]
[ 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 < 1766696740 ) AND post.post_status = 1 AND post.post_type = 1 AND post.delete_time = 0 AND category_post.category_id = '21' GROUP BY post.id ORDER BY published_time DESC LIMIT 7 OFFSET 0 [ RunTime:0.003433s ]
[ 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.004420s ]
[ 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 < 1766696740 ) AND post.post_status = 1 AND post.post_type = 1 AND post.delete_time = 0 AND category_post.category_id = '21' GROUP BY post.id ) _group_count_ LIMIT 1 [ RunTime:0.001138s ]
[ 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.004177s ]
[ 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 < 1766696740 ) AND post.post_status = 1 AND post.post_type = 1 AND post.delete_time = 0 AND category_post.category_id = '21' GROUP BY post.id ORDER BY published_time DESC LIMIT 7 OFFSET 7 [ RunTime:0.003256s ]
[ 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.004321s ]
[ 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 < 1766696740 ) AND post.post_status = 1 AND post.post_type = 1 AND post.delete_time = 0 AND category_post.category_id = '22' GROUP BY post.id ) _group_count_ LIMIT 1 [ RunTime:0.001151s ]
[ 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.004205s ]
[ 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 < 1766696740 ) AND post.post_status = 1 AND post.post_type = 1 AND post.delete_time = 0 AND category_post.category_id = '22' GROUP BY post.id ORDER BY published_time DESC LIMIT 7 OFFSET 0 [ RunTime:0.003258s ]
[ 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.004311s ]
[ 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 < 1766696740 ) AND post.post_status = 1 AND post.post_type = 1 AND post.delete_time = 0 AND category_post.category_id = '22' GROUP BY post.id ) _group_count_ LIMIT 1 [ RunTime:0.001241s ]
[ 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.004204s ]
[ 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 < 1766696740 ) AND post.post_status = 1 AND post.post_type = 1 AND post.delete_time = 0 AND category_post.category_id = '22' GROUP BY post.id ORDER BY published_time DESC LIMIT 7 OFFSET 7 [ RunTime:0.003255s ]
[ 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.004299s ]
[ 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 < 1766696740 ) AND post.post_status = 1 AND post.post_type = 1 AND post.delete_time = 0 AND category_post.category_id = '16' GROUP BY post.id ORDER BY post.create_time DESC LIMIT 8 [ RunTime:0.003219s ]
