SELECT column_name, data_type, column_default, is_nullable
FROM information_schema.tables AS t
JOIN information_schema.columns AS c
ON t.table_catalog = c.table_catalog
AND t.table_schema = c.table_schema
AND t.table_name = c.table_name
WHERE t.table_name = 'cmf_hook' [ RunTime:0.007165s ]
SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [hook],[id] FROM [cmf_hook] WHERE ( ( [app] = '' OR [app] = 'cmf' ) AND [type] = 3 ) OR [type] = 1) AS thinkphp) AS T1 [ RunTime:0.012186s ]
SELECT column_name, data_type, column_default, is_nullable
FROM information_schema.tables AS t
JOIN information_schema.columns AS c
ON t.table_catalog = c.table_catalog
AND t.table_schema = c.table_schema
AND t.table_name = c.table_name
WHERE t.table_name = 'cmf_hook_plugin' [ RunTime:0.012685s ]
SELECT column_name, data_type, column_default, is_nullable
FROM information_schema.tables AS t
JOIN information_schema.columns AS c
ON t.table_catalog = c.table_catalog
AND t.table_schema = c.table_schema
AND t.table_name = c.table_name
WHERE t.table_name = 'cmf_portal_post' [ RunTime:0.008895s ]
SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [post].* FROM [cmf_portal_post] [post] WHERE [post].[post_type] = '1' AND [post].[post_status] = '1' AND [post].[delete_time] = '0' AND [post].[id] = '3' AND ( [post].[published_time] > '0' AND [post].[published_time] < '1780486939' )) AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.012366s ]
SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY [id] DESC) AS ROW_NUMBER FROM (SELECT [post].* FROM [cmf_portal_post] [post] WHERE [post].[post_type] = '1' AND [post].[post_status] = '1' AND [post].[delete_time] = '0' AND [post].[id] < '3' AND ( [post].[published_time] > '0' AND [post].[published_time] < '1780486939' )) AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.012004s ]
SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY [id] ASC) AS ROW_NUMBER FROM (SELECT [post].* FROM [cmf_portal_post] [post] WHERE [post].[post_type] = '1' AND [post].[post_status] = '1' AND [post].[delete_time] = '0' AND [post].[id] > '3' AND ( [post].[published_time] > '0' AND [post].[published_time] < '1780486939' )) AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.012873s ]
SELECT column_name, data_type, column_default, is_nullable
FROM information_schema.tables AS t
JOIN information_schema.columns AS c
ON t.table_catalog = c.table_catalog
AND t.table_schema = c.table_schema
AND t.table_name = c.table_name
WHERE t.table_name = 'cmf_portal_category_post' [ RunTime:0.011187s ]
SELECT column_name, data_type, column_default, is_nullable
FROM information_schema.tables AS t
JOIN information_schema.columns AS c
ON t.table_catalog = c.table_catalog
AND t.table_schema = c.table_schema
AND t.table_name = c.table_name
WHERE t.table_name = 'cmf_portal_category' [ RunTime:0.012139s ]
SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [cmf_portal_category].*,[pivot].[id] AS [pivot__id],[pivot].[post_id] AS [pivot__post_id],[pivot].[category_id] AS [pivot__category_id],[pivot].[list_order] AS [pivot__list_order],[pivot].[status] AS [pivot__status] FROM [cmf_portal_category] INNER JOIN [cmf_portal_category_post] [pivot] ON [pivot].[category_id]=[cmf_portal_category].[id] WHERE [pivot].[post_id] = '3') AS thinkphp) AS T1 [ RunTime:0.013583s ]
UPDATE [cmf_portal_post] SET [post_hits] = [post_hits] + 1 FROM [cmf_portal_post] WHERE [id] = 3 [ RunTime:0.014342s ]
SELECT column_name, data_type, column_default, is_nullable
FROM information_schema.tables AS t
JOIN information_schema.columns AS c
ON t.table_catalog = c.table_catalog
AND t.table_schema = c.table_schema
AND t.table_name = c.table_name
WHERE t.table_name = 'cmf_theme_file' [ RunTime:0.014294s ]
SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT * FROM [cmf_theme_file] WHERE [theme] = 'default' AND [file] = 'portal/article') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.013064s ]
SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT * FROM [cmf_theme_file] WHERE [theme] = 'default' AND [file] = 'portal/articlex') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.010741s ]
SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT * FROM [cmf_theme_file] WHERE [theme] = 'default' AND [file] = 'portal/contact') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.012145s ]
SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT * FROM [cmf_theme_file] WHERE [theme] = 'default' AND [file] = 'portal/index - 副本') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.011927s ]
SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT * FROM [cmf_theme_file] WHERE [theme] = 'default' AND [file] = 'portal/index') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.013889s ]
SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT * FROM [cmf_theme_file] WHERE [theme] = 'default' AND [file] = 'portal/list') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.012454s ]
SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT * FROM [cmf_theme_file] WHERE [theme] = 'default' AND [file] = 'portal/page') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.012598s ]
SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT * FROM [cmf_theme_file] WHERE [theme] = 'default' AND [file] = 'portal/search') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.012005s ]
SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT * FROM [cmf_theme_file] WHERE [theme] = 'default' AND [file] = 'public/config') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.013462s ]
SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT * FROM [cmf_theme_file] WHERE [theme] = 'default') AS thinkphp) AS T1 [ RunTime:0.014577s ]
SELECT column_name, data_type, column_default, is_nullable
FROM information_schema.tables AS t
JOIN information_schema.columns AS c
ON t.table_catalog = c.table_catalog
AND t.table_schema = c.table_schema
AND t.table_name = c.table_name
WHERE t.table_name = 'cmf_theme' [ RunTime:0.012221s ]
SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY [is_public] desc) AS ROW_NUMBER FROM (SELECT [more],[file],[id],[is_public] FROM [cmf_theme_file] WHERE [theme] = 'default' AND ( [is_public] = 1 OR [file] = 'portal/articlex' )) AS thinkphp) AS T1 [ RunTime:0.011446s ]
SELECT column_name, data_type, column_default, is_nullable
FROM information_schema.tables AS t
JOIN information_schema.columns AS c
ON t.table_catalog = c.table_catalog
AND t.table_schema = c.table_schema
AND t.table_name = c.table_name
WHERE t.table_name = 'cmf_nav' [ RunTime:0.013514s ]
SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [id] FROM [cmf_nav] WHERE [is_main] = 1) AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.012174s ]
SELECT column_name, data_type, column_default, is_nullable
FROM information_schema.tables AS t
JOIN information_schema.columns AS c
ON t.table_catalog = c.table_catalog
AND t.table_schema = c.table_schema
AND t.table_name = c.table_name
WHERE t.table_name = 'cmf_nav_menu' [ RunTime:0.014110s ]
SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY [list_order] ASC) AS ROW_NUMBER FROM (SELECT * FROM [cmf_nav_menu] WHERE [nav_id] = 1 AND [status] = 1) AS thinkphp) AS T1 [ RunTime:0.011483s ]
SELECT column_name, data_type, column_default, is_nullable
FROM information_schema.tables AS t
JOIN information_schema.columns AS c
ON t.table_catalog = c.table_catalog
AND t.table_schema = c.table_schema
AND t.table_name = c.table_name
WHERE t.table_name = 'cmf_slide' [ RunTime:0.012542s ]
SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT COUNT(*) AS think_count FROM [cmf_slide] WHERE [id] = 1 AND [status] = 1 AND [delete_time] = 0) AS thinkphp) AS T1 [ RunTime:0.011858s ]
SELECT column_name, data_type, column_default, is_nullable
FROM information_schema.tables AS t
JOIN information_schema.columns AS c
ON t.table_catalog = c.table_catalog
AND t.table_schema = c.table_schema
AND t.table_name = c.table_name
WHERE t.table_name = 'cmf_slide_item' [ RunTime:0.012077s ]
SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY [list_order] ASC) AS ROW_NUMBER FROM (SELECT * FROM [cmf_slide_item] WHERE [status] = 1 AND [slide_id] = 1) AS thinkphp) AS T1 [ RunTime:0.012265s ]
SELECT column_name, data_type, column_default, is_nullable
FROM information_schema.tables AS t
JOIN information_schema.columns AS c
ON t.table_catalog = c.table_catalog
AND t.table_schema = c.table_schema
AND t.table_name = c.table_name
WHERE t.table_name = 'cmf_option' [ RunTime:0.011395s ]
SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [option_value] FROM [cmf_option] WHERE [option_name] = 'storage') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.010825s ]
SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [post].* FROM [cmf_portal_post] [post] INNER JOIN [cmf_portal_category_post] [category_post] ON [post].[id]=[category_post].[post_id] WHERE [post].[post_status] = '1' AND [post].[post_type] = '1' AND [post].[delete_time] = '0' AND ( [category_post].[category_id] = '1' ) AND ( [post].[published_time] > '0' AND [post].[published_time] < '1780486939' )) AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 10) [ RunTime:0.013991s ]
SELECT column_name, data_type, column_default, is_nullable
FROM information_schema.tables AS t
JOIN information_schema.columns AS c
ON t.table_catalog = c.table_catalog
AND t.table_schema = c.table_schema
AND t.table_name = c.table_name
WHERE t.table_name = 'cmf_user' [ RunTime:0.012808s ]
SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT * FROM [cmf_user] WHERE [id] = 1) AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.012257s ]
SELECT column_name, data_type, column_default, is_nullable
FROM information_schema.tables AS t
JOIN information_schema.columns AS c
ON t.table_catalog = c.table_catalog
AND t.table_schema = c.table_schema
AND t.table_name = c.table_name
WHERE t.table_name = 'cmf_link' [ RunTime:0.014079s ]
SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY [list_order] ASC) AS ROW_NUMBER FROM (SELECT * FROM [cmf_link] WHERE [status] = 1) AS thinkphp) AS T1 [ RunTime:0.011759s ]