SELECT
COLUMN_NAME,
DATA_TYPE,
DATA_DEFAULT,
CASE NULLABLE WHEN 'Y' THEN 0 ELSE 1 END AS NOTNULL,
CASE COLUMN_NAME WHEN 'ID' THEN 1 ELSE 0 END AS AUTO_IN,
CASE COLUMN_NAME WHEN 'ID' THEN 1 ELSE 0 END AS PK
FROM USER_TAB_COLUMNS
WHERE TABLE_NAME = 'CP_HOOK'; [ RunTime:0.004007s ]
SELECT
COLUMN_NAME,
DATA_TYPE,
DATA_DEFAULT,
CASE NULLABLE WHEN 'Y' THEN 0 ELSE 1 END AS NOTNULL,
CASE COLUMN_NAME WHEN 'ID' THEN 1 ELSE 0 END AS AUTO_IN,
CASE COLUMN_NAME WHEN 'ID' THEN 1 ELSE 0 END AS PK
FROM USER_TAB_COLUMNS
WHERE TABLE_NAME = 'CP_HOOK'; [ RunTime:0.002722s ]
SELECT HOOK,ID FROM CP_HOOK WHERE ( ( app = '' OR app = 'cmf' ) AND type = '3' ) OR type = '1' [ RunTime:0.003808s ]
SELECT
COLUMN_NAME,
DATA_TYPE,
DATA_DEFAULT,
CASE NULLABLE WHEN 'Y' THEN 0 ELSE 1 END AS NOTNULL,
CASE COLUMN_NAME WHEN 'ID' THEN 1 ELSE 0 END AS AUTO_IN,
CASE COLUMN_NAME WHEN 'ID' THEN 1 ELSE 0 END AS PK
FROM USER_TAB_COLUMNS
WHERE TABLE_NAME = 'CP_HOOK_PLUGIN'; [ RunTime:0.002942s ]
SELECT
COLUMN_NAME,
DATA_TYPE,
DATA_DEFAULT,
CASE NULLABLE WHEN 'Y' THEN 0 ELSE 1 END AS NOTNULL,
CASE COLUMN_NAME WHEN 'ID' THEN 1 ELSE 0 END AS AUTO_IN,
CASE COLUMN_NAME WHEN 'ID' THEN 1 ELSE 0 END AS PK
FROM USER_TAB_COLUMNS
WHERE TABLE_NAME = 'CP_HOOK_PLUGIN'; [ RunTime:0.001590s ]
SELECT HOOK,PLUGIN FROM CP_HOOK_PLUGIN WHERE status = '1' AND 0 = 1 ORDER BY list_order ASC [ RunTime:0.000624s ]
SELECT
COLUMN_NAME,
DATA_TYPE,
DATA_DEFAULT,
CASE NULLABLE WHEN 'Y' THEN 0 ELSE 1 END AS NOTNULL,
CASE COLUMN_NAME WHEN 'ID' THEN 1 ELSE 0 END AS AUTO_IN,
CASE COLUMN_NAME WHEN 'ID' THEN 1 ELSE 0 END AS PK
FROM USER_TAB_COLUMNS
WHERE TABLE_NAME = 'CP_OPTION'; [ RunTime:0.001244s ]
SELECT
COLUMN_NAME,
DATA_TYPE,
DATA_DEFAULT,
CASE NULLABLE WHEN 'Y' THEN 0 ELSE 1 END AS NOTNULL,
CASE COLUMN_NAME WHEN 'ID' THEN 1 ELSE 0 END AS AUTO_IN,
CASE COLUMN_NAME WHEN 'ID' THEN 1 ELSE 0 END AS PK
FROM USER_TAB_COLUMNS
WHERE TABLE_NAME = 'CP_OPTION'; [ RunTime:0.001907s ]
SELECT OPTION_VALUE FROM CP_OPTION WHERE option_name = 'cdn_settings' LIMIT 1 [ RunTime:0.000924s ]
SELECT
COLUMN_NAME,
DATA_TYPE,
DATA_DEFAULT,
CASE NULLABLE WHEN 'Y' THEN 0 ELSE 1 END AS NOTNULL,
CASE COLUMN_NAME WHEN 'ID' THEN 1 ELSE 0 END AS AUTO_IN,
CASE COLUMN_NAME WHEN 'ID' THEN 1 ELSE 0 END AS PK
FROM USER_TAB_COLUMNS
WHERE TABLE_NAME = 'CP_TALENT_OPTION'; [ RunTime:0.003383s ]
SELECT
COLUMN_NAME,
DATA_TYPE,
DATA_DEFAULT,
CASE NULLABLE WHEN 'Y' THEN 0 ELSE 1 END AS NOTNULL,
CASE COLUMN_NAME WHEN 'ID' THEN 1 ELSE 0 END AS AUTO_IN,
CASE COLUMN_NAME WHEN 'ID' THEN 1 ELSE 0 END AS PK
FROM USER_TAB_COLUMNS
WHERE TABLE_NAME = 'CP_TALENT_OPTION'; [ RunTime:0.003216s ]
SELECT * FROM CP_TALENT_OPTION WHERE type = '1' LIMIT 1 [ RunTime:0.001405s ]
SELECT
COLUMN_NAME,
DATA_TYPE,
DATA_DEFAULT,
CASE NULLABLE WHEN 'Y' THEN 0 ELSE 1 END AS NOTNULL,
CASE COLUMN_NAME WHEN 'ID' THEN 1 ELSE 0 END AS AUTO_IN,
CASE COLUMN_NAME WHEN 'ID' THEN 1 ELSE 0 END AS PK
FROM USER_TAB_COLUMNS
WHERE TABLE_NAME = 'CP_THEME_FILE'; [ RunTime:0.003035s ]
SELECT * FROM CP_THEME_FILE WHERE theme = 'default' AND file = 'portal/article' LIMIT 1 [ RunTime:0.001839s ]
UPDATE CP_THEME_FILE SET THEME = 'default' , ACTION = 'portal/Article/index' , FILE = 'portal/article' , NAME = '文章页' , MORE = '{\"widgets_blocks\":{\"top\":{\"title\":\"\\u9876\\u90e8\",\"widgets\":{\"top_nav_202206300003\":{\"title\":\"\\u9876\\u90e8\\u5bfc\\u822a\",\"name\":\"nav\",\"display\":\"1\",\"public_widget_id\":\"top_nav\",\"version\":\"1.0.0\",\"action\":\"\",\"vars\":{\"company_name\":\"ThinkCMF\",\"nav_id\":\"\"}}}},\"body_left\":{\"title\":\"\\u4e3b\\u4f53\\u5de6\",\"widgets\":{\"article_202206300003\":{\"title\":\"\\u6587\\u7ae0\\u5185\\u5bb9\",\"name\":\"article\",\"display\":\"1\",\"version\":\"1.0.0\",\"action\":\"portal\\/Article\\/index\",\"vars\":[]},\"article_last_news_202206300003\":{\"title\":\"\\u6700\\u65b0\\u8d44\\u8baf\",\"name\":\"last_news\",\"display\":\"1\",\"version\":\"1.0.0\",\"action\":\"\",\"vars\":{\"last_news_category_id\":\"\"}}}},\"body_right\":{\"title\":\"\\u4e3b\\u4f53\\u53f3\",\"widgets\":{\"article_side_hot_articles_202206300004\":{\"title\":\"\\u70ed\\u95e8\\u6587\\u7ae0\",\"name\":\"side_hot_articles\",\"display\":\"1\",\"version\":\"1.0.0\",\"action\":\"\",\"vars\":{\"hottest_articles_category_id\":\"\"}},\"article_side_last_articles_202206300004\":{\"title\":\"\\u6700\\u65b0\\u6587\\u7ae0\",\"name\":\"side_last_articles\",\"display\":\"1\",\"version\":\"1.0.0\",\"action\":\"\",\"vars\":{\"last_articles_category_id\":\"\"}}}},\"footer\":{\"title\":\"\\u5e95\\u90e8\",\"widgets\":{\"footer_202206300003\":{\"title\":\"\\u5e95\\u90e8\",\"name\":\"footer\",\"display\":\"1\",\"public_widget_id\":\"footer\",\"version\":\"1.0.0\",\"action\":\"\",\"vars\":[]}}}}}' , CONFIG_MORE = '{\"widgets_blocks\":{\"top\":{\"title\":\"\\u9876\\u90e8\",\"widgets\":{\"top_nav_202206300003\":{\"title\":\"\\u9876\\u90e8\\u5bfc\\u822a\",\"name\":\"nav\",\"display\":\"1\",\"public_widget_id\":\"top_nav\"}}},\"body_left\":{\"title\":\"\\u4e3b\\u4f53\\u5de6\",\"widgets\":{\"article_202206300003\":{\"title\":\"\\u6587\\u7ae0\\u5185\\u5bb9\",\"name\":\"article\",\"display\":\"1\"},\"article_last_news_202206300003\":{\"title\":\"\\u6700\\u65b0\\u8d44\\u8baf\",\"name\":\"last_news\",\"display\":\"1\"}}},\"body_right\":{\"title\":\"\\u4e3b\\u4f53\\u53f3\",\"widgets\":{\"article_side_hot_articles_202206300004\":{\"title\":\"\\u70ed\\u95e8\\u6587\\u7ae0\",\"name\":\"side_hot_articles\",\"display\":\"1\"},\"article_side_last_articles_202206300004\":{\"title\":\"\\u6700\\u65b0\\u6587\\u7ae0\",\"name\":\"side_last_articles\",\"display\":\"1\"}}},\"footer\":{\"title\":\"\\u5e95\\u90e8\",\"widgets\":{\"footer_202206300003\":{\"title\":\"\\u5e95\\u90e8\",\"name\":\"footer\",\"display\":\"1\",\"public_widget_id\":\"footer\"}}}}}' , DESCRIPTION = '文章页模板文件' , IS_PUBLIC = 0 , LIST_ORDER = '10' WHERE theme = 'default' AND file = 'portal/article' [ RunTime:0.005183s ]
SELECT * FROM CP_THEME_FILE WHERE theme = 'default' AND file = 'portal/contact' LIMIT 1 [ RunTime:0.001782s ]
SELECT * FROM CP_THEME_FILE WHERE theme = 'default' AND file = 'portal/index' LIMIT 1 [ RunTime:0.001902s ]
UPDATE CP_THEME_FILE SET THEME = 'default' , ACTION = 'portal/Index/index' , FILE = 'portal/index' , NAME = '首页' , MORE = '{\"widgets_blocks\":{\"top\":{\"title\":\"\\u9876\\u90e8\",\"widgets\":{\"top_nav_202206300003\":{\"title\":\"\\u9876\\u90e8\\u5bfc\\u822a\",\"name\":\"nav\",\"display\":\"1\",\"public_widget_id\":\"top_nav\",\"version\":\"1.0.0\",\"action\":\"\",\"vars\":{\"company_name\":\"ThinkCMF\",\"nav_id\":\"\"}}}},\"body\":{\"title\":\"\\u4e3b\\u4f53\",\"widgets\":{\"home_slider_202206300003\":{\"title\":\"\\u9996\\u9875\\u5e7b\\u706f\\u7247\",\"name\":\"slider\",\"display\":\"1\",\"version\":\"1.0.0\",\"action\":\"\",\"vars\":{\"slide_id\":\"\",\"fullscreen\":1}},\"home_features_202206300003\":{\"title\":\"\\u4ea7\\u54c1\\u7279\\u6027\",\"name\":\"features\",\"display\":\"1\",\"version\":\"1.0.0\",\"action\":\"\",\"vars\":{\"sub_title\":\"Quickly understand the ThinkCMF\",\"features\":[{\"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\"}]}},\"home_last_news_202206300003\":{\"title\":\"\\u6700\\u65b0\\u8d44\\u8baf\",\"name\":\"last_news\",\"display\":\"1\",\"version\":\"1.0.0\",\"action\":\"\",\"vars\":{\"last_news_category_id\":\"\"}},\"home_last_news_202206300004\":{\"title\":\"\\u6700\\u65b0\\u8d44\\u8baf\",\"name\":\"last_news\",\"display\":\"1\",\"version\":\"1.0.0\",\"action\":\"\",\"vars\":{\"last_news_category_id\":\"\"}}}},\"footer\":{\"title\":\"\\u5e95\\u90e8\",\"widgets\":{\"home_footer_202206300003\":{\"title\":\"\\u5e95\\u90e8\",\"name\":\"footer\",\"display\":\"1\",\"public_widget_id\":\"footer\",\"version\":\"1.0.0\",\"action\":\"\",\"vars\":[]}}}}}' , CONFIG_MORE = '{\"widgets_blocks\":{\"top\":{\"title\":\"\\u9876\\u90e8\",\"widgets\":{\"top_nav_202206300003\":{\"title\":\"\\u9876\\u90e8\\u5bfc\\u822a\",\"name\":\"nav\",\"display\":\"1\",\"public_widget_id\":\"top_nav\"}}},\"body\":{\"title\":\"\\u4e3b\\u4f53\",\"widgets\":{\"home_slider_202206300003\":{\"title\":\"\\u9996\\u9875\\u5e7b\\u706f\\u7247\",\"name\":\"slider\",\"display\":\"1\"},\"home_features_202206300003\":{\"title\":\"\\u4ea7\\u54c1\\u7279\\u6027\",\"name\":\"features\",\"display\":\"1\"},\"home_last_news_202206300003\":{\"title\":\"\\u6700\\u65b0\\u8d44\\u8baf\",\"name\":\"last_news\",\"display\":\"1\"},\"home_last_news_202206300004\":{\"title\":\"\\u6700\\u65b0\\u8d44\\u8baf\",\"name\":\"last_news\",\"display\":\"1\"}}},\"footer\":{\"title\":\"\\u5e95\\u90e8\",\"widgets\":{\"home_footer_202206300003\":{\"title\":\"\\u5e95\\u90e8\",\"name\":\"footer\",\"display\":\"1\",\"public_widget_id\":\"footer\"}}}}}' , DESCRIPTION = '首页模板文件' , IS_PUBLIC = 0 , LIST_ORDER = '5' WHERE theme = 'default' AND file = 'portal/index' [ RunTime:0.017650s ]
SELECT * FROM CP_THEME_FILE WHERE theme = 'default' AND file = 'portal/list' LIMIT 1 [ RunTime:0.009394s ]
UPDATE CP_THEME_FILE SET THEME = 'default' , ACTION = 'portal/List/index' , FILE = 'portal/list' , NAME = '文章列表页' , MORE = '{\"widgets_blocks\":{\"top\":{\"title\":\"\\u9876\\u90e8\",\"widgets\":{\"top_nav_202206300003\":{\"title\":\"\\u9876\\u90e8\\u5bfc\\u822a\",\"name\":\"nav\",\"display\":\"1\",\"public_widget_id\":\"top_nav\",\"version\":\"1.0.0\",\"action\":\"\",\"vars\":{\"company_name\":\"ThinkCMF\",\"nav_id\":\"\"}}}},\"body_left\":{\"title\":\"\\u4e3b\\u4f53\\u5de6\",\"widgets\":{\"list_articles_202206300003\":{\"title\":\"\\u6587\\u7ae0\\u5217\\u8868\",\"name\":\"list_articles\",\"display\":\"1\",\"version\":\"1.0.0\",\"action\":\"portal\\/List\\/index\",\"vars\":[]},\"list_last_news_202206300003\":{\"title\":\"\\u6700\\u65b0\\u8d44\\u8baf\",\"name\":\"last_news\",\"display\":\"1\",\"version\":\"1.0.0\",\"action\":\"\",\"vars\":{\"last_news_category_id\":\"\"}}}},\"body_right\":{\"title\":\"\\u4e3b\\u4f53\\u53f3\",\"widgets\":{\"list_side_hot_articles_202206300004\":{\"title\":\"\\u70ed\\u95e8\\u6587\\u7ae0\",\"name\":\"side_hot_articles\",\"display\":\"1\",\"version\":\"1.0.0\",\"action\":\"\",\"vars\":{\"hottest_articles_category_id\":\"\"}},\"list_side_last_articles_202206300004\":{\"title\":\"\\u6700\\u65b0\\u6587\\u7ae0\",\"name\":\"side_last_articles\",\"display\":\"1\",\"version\":\"1.0.0\",\"action\":\"\",\"vars\":{\"last_articles_category_id\":\"\"}}}},\"footer\":{\"title\":\"\\u5e95\\u90e8\",\"widgets\":{\"home_footer_202206300003\":{\"title\":\"\\u5e95\\u90e8\",\"name\":\"footer\",\"display\":\"1\",\"public_widget_id\":\"footer\",\"version\":\"1.0.0\",\"action\":\"\",\"vars\":[]}}}}}' , CONFIG_MORE = '{\"widgets_blocks\":{\"top\":{\"title\":\"\\u9876\\u90e8\",\"widgets\":{\"top_nav_202206300003\":{\"title\":\"\\u9876\\u90e8\\u5bfc\\u822a\",\"name\":\"nav\",\"display\":\"1\",\"public_widget_id\":\"top_nav\"}}},\"body_left\":{\"title\":\"\\u4e3b\\u4f53\\u5de6\",\"widgets\":{\"list_articles_202206300003\":{\"title\":\"\\u6587\\u7ae0\\u5217\\u8868\",\"name\":\"list_articles\",\"display\":\"1\"},\"list_last_news_202206300003\":{\"title\":\"\\u6700\\u65b0\\u8d44\\u8baf\",\"name\":\"last_news\",\"display\":\"1\"}}},\"body_right\":{\"title\":\"\\u4e3b\\u4f53\\u53f3\",\"widgets\":{\"list_side_hot_articles_202206300004\":{\"title\":\"\\u70ed\\u95e8\\u6587\\u7ae0\",\"name\":\"side_hot_articles\",\"display\":\"1\"},\"list_side_last_articles_202206300004\":{\"title\":\"\\u6700\\u65b0\\u6587\\u7ae0\",\"name\":\"side_last_articles\",\"display\":\"1\"}}},\"footer\":{\"title\":\"\\u5e95\\u90e8\",\"widgets\":{\"home_footer_202206300003\":{\"title\":\"\\u5e95\\u90e8\",\"name\":\"footer\",\"display\":\"1\",\"public_widget_id\":\"footer\"}}}}}' , DESCRIPTION = '文章列表模板文件' , IS_PUBLIC = 0 , LIST_ORDER = '10' WHERE theme = 'default' AND file = 'portal/list' [ RunTime:0.020959s ]
SELECT * FROM CP_THEME_FILE WHERE theme = 'default' AND file = 'portal/page' LIMIT 1 [ RunTime:0.004949s ]
UPDATE CP_THEME_FILE SET THEME = 'default' , ACTION = 'portal/Page/index' , FILE = 'portal/page' , NAME = '单页面' , MORE = '{\"widgets_blocks\":{\"top\":{\"title\":\"\\u9876\\u90e8\",\"widgets\":{\"top_nav_202206300003\":{\"title\":\"\\u9876\\u90e8\\u5bfc\\u822a\",\"name\":\"nav\",\"display\":\"1\",\"public_widget_id\":\"top_nav\",\"version\":\"1.0.0\",\"action\":\"\",\"vars\":{\"company_name\":\"ThinkCMF\",\"nav_id\":\"\"}}}},\"body_left\":{\"title\":\"\\u4e3b\\u4f53\\u5de6\",\"widgets\":{\"page_202206300003\":{\"title\":\"\\u9875\\u9762\\u5185\\u5bb9\",\"name\":\"page\",\"display\":\"1\",\"version\":\"1.0.0\",\"action\":\"portal\\/Page\\/index\",\"vars\":[]},\"page_last_news_202206300003\":{\"title\":\"\\u6700\\u65b0\\u8d44\\u8baf\",\"name\":\"last_news\",\"display\":\"1\",\"version\":\"1.0.0\",\"action\":\"\",\"vars\":{\"last_news_category_id\":\"\"}}}},\"body_right\":{\"title\":\"\\u4e3b\\u4f53\\u53f3\",\"widgets\":{\"page_side_hot_articles_202206300004\":{\"title\":\"\\u70ed\\u95e8\\u6587\\u7ae0\",\"name\":\"side_hot_articles\",\"display\":\"1\",\"version\":\"1.0.0\",\"action\":\"\",\"vars\":{\"hottest_articles_category_id\":\"\"}},\"page_side_last_articles_202206300004\":{\"title\":\"\\u6700\\u65b0\\u6587\\u7ae0\",\"name\":\"side_last_articles\",\"display\":\"1\",\"version\":\"1.0.0\",\"action\":\"\",\"vars\":{\"last_articles_category_id\":\"\"}}}},\"footer\":{\"title\":\"\\u5e95\\u90e8\",\"widgets\":{\"footer_202206300003\":{\"title\":\"\\u5e95\\u90e8\",\"name\":\"footer\",\"display\":\"1\",\"public_widget_id\":\"footer\",\"version\":\"1.0.0\",\"action\":\"\",\"vars\":[]}}}}}' , CONFIG_MORE = '{\"widgets_blocks\":{\"top\":{\"title\":\"\\u9876\\u90e8\",\"widgets\":{\"top_nav_202206300003\":{\"title\":\"\\u9876\\u90e8\\u5bfc\\u822a\",\"name\":\"nav\",\"display\":\"1\",\"public_widget_id\":\"top_nav\"}}},\"body_left\":{\"title\":\"\\u4e3b\\u4f53\\u5de6\",\"widgets\":{\"page_202206300003\":{\"title\":\"\\u9875\\u9762\\u5185\\u5bb9\",\"name\":\"page\",\"display\":\"1\"},\"page_last_news_202206300003\":{\"title\":\"\\u6700\\u65b0\\u8d44\\u8baf\",\"name\":\"last_news\",\"display\":\"1\"}}},\"body_right\":{\"title\":\"\\u4e3b\\u4f53\\u53f3\",\"widgets\":{\"page_side_hot_articles_202206300004\":{\"title\":\"\\u70ed\\u95e8\\u6587\\u7ae0\",\"name\":\"side_hot_articles\",\"display\":\"1\"},\"page_side_last_articles_202206300004\":{\"title\":\"\\u6700\\u65b0\\u6587\\u7ae0\",\"name\":\"side_last_articles\",\"display\":\"1\"}}},\"footer\":{\"title\":\"\\u5e95\\u90e8\",\"widgets\":{\"footer_202206300003\":{\"title\":\"\\u5e95\\u90e8\",\"name\":\"footer\",\"display\":\"1\",\"public_widget_id\":\"footer\"}}}}}' , DESCRIPTION = '单页面模板文件' , IS_PUBLIC = 0 , LIST_ORDER = '10' WHERE theme = 'default' AND file = 'portal/page' [ RunTime:0.014479s ]
SELECT * FROM CP_THEME_FILE WHERE theme = 'default' AND file = 'public/config' LIMIT 1 [ RunTime:0.005255s ]
UPDATE CP_THEME_FILE SET THEME = 'default' , ACTION = 'public/Config' , FILE = 'public/config' , NAME = '模板全局配置' , MORE = '{\"vars\":{\"enable_mobile\":{\"title\":\"\\u624b\\u673a\\u6ce8\\u518c\",\"type\":\"select\",\"value\":1,\"options\":{\"1\":\"\\u5f00\\u542f\",\"0\":\"\\u5173\\u95ed\"},\"tip\":\"\"}},\"widgets_blocks\":{\"public\":{\"title\":\"\\u5168\\u5c40\",\"widgets\":{\"top_nav\":{\"title\":\"\\u9876\\u90e8\\u5bfc\\u822a\",\"name\":\"nav\",\"display\":\"1\",\"version\":\"1.0.0\",\"action\":\"\",\"vars\":{\"company_name\":\"ThinkCMF\",\"nav_id\":\"\"}},\"footer\":{\"title\":\"\\u5e95\\u90e8\",\"name\":\"footer\",\"display\":\"1\",\"version\":\"1.0.0\",\"action\":\"\",\"vars\":[]}}}}}' , CONFIG_MORE = '{\"vars\":{\"enable_mobile\":{\"title\":\"\\u624b\\u673a\\u6ce8\\u518c\",\"type\":\"select\",\"value\":1,\"options\":{\"1\":\"\\u5f00\\u542f\",\"0\":\"\\u5173\\u95ed\"},\"tip\":\"\"}},\"widgets_blocks\":{\"public\":{\"title\":\"\\u5168\\u5c40\",\"widgets\":{\"top_nav\":{\"title\":\"\\u9876\\u90e8\\u5bfc\\u822a\",\"name\":\"nav\",\"display\":\"1\"},\"footer\":{\"title\":\"\\u5e95\\u90e8\",\"name\":\"footer\",\"display\":\"1\"}}}}}' , DESCRIPTION = '模板全局配置文件' , IS_PUBLIC = 1 , LIST_ORDER = '0' WHERE theme = 'default' AND file = 'public/config' [ RunTime:0.017113s ]
SELECT * FROM CP_THEME_FILE WHERE theme = 'default' [ RunTime:0.006544s ]
SELECT
COLUMN_NAME,
DATA_TYPE,
DATA_DEFAULT,
CASE NULLABLE WHEN 'Y' THEN 0 ELSE 1 END AS NOTNULL,
CASE COLUMN_NAME WHEN 'ID' THEN 1 ELSE 0 END AS AUTO_IN,
CASE COLUMN_NAME WHEN 'ID' THEN 1 ELSE 0 END AS PK
FROM USER_TAB_COLUMNS
WHERE TABLE_NAME = 'CP_THEME'; [ RunTime:0.008816s ]
UPDATE CP_THEME SET NAME = 'default' , VERSION = '8.0.0' , DEMO_URL = 'http://demo.thinkcmf.com' , AUTHOR = 'ThinkCMF' , LANG = 'zh-cn' , AUTHOR_URL = 'http://www.thinkcmf.com' , KEYWORDS = 'ThinkCMF默认模板' , DESCRIPTION = 'ThinkCMF默认模板' WHERE theme = 'default' [ RunTime:0.017310s ]
SELECT
COLUMN_NAME,
DATA_TYPE,
DATA_DEFAULT,
CASE NULLABLE WHEN 'Y' THEN 0 ELSE 1 END AS NOTNULL,
CASE COLUMN_NAME WHEN 'ID' THEN 1 ELSE 0 END AS AUTO_IN,
CASE COLUMN_NAME WHEN 'ID' THEN 1 ELSE 0 END AS PK
FROM USER_TAB_COLUMNS
WHERE TABLE_NAME = 'CP_THEME_FILE'; [ RunTime:0.007981s ]
SELECT MORE,FILE,ID,IS_PUBLIC FROM CP_THEME_FILE WHERE theme = 'default' AND ( is_public = '1' OR file = 'portal/index' ) ORDER BY is_public DESC [ RunTime:0.005061s ]
正在生成，请稍候...
未登录
点击进行对话
