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.007132s ]
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.011016s ]
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.010776s ]
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.007750s ]
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] = '14' AND ( [post].[published_time] > '0' AND [post].[published_time] < '1776512099' )) AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.012515s ]
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] < '14' AND ( [post].[published_time] > '0' AND [post].[published_time] < '1776512099' )) AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.010920s ]
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] > '14' AND ( [post].[published_time] > '0' AND [post].[published_time] < '1776512099' )) AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.012513s ]
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.011684s ]
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.012470s ]
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] = '14') AS thinkphp) AS T1 [ RunTime:0.011157s ]
UPDATE [cmf_portal_post] SET [post_hits] = [post_hits] + 1 FROM [cmf_portal_post] WHERE [id] = 14 [ RunTime:0.011511s ]
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.012765s ]
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.012315s ]
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.009162s ]
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.012501s ]
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.011128s ]
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.010799s ]
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.010176s ]
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.010800s ]
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.010202s ]
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.011506s ]
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.011305s ]
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.010916s ]
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.010591s ]
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.011700s ]
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.009817s ]
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.011769s ]
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.011592s ]
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.012025s ]
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.010143s ]
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.010499s ]
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.010303s ]
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.010562s ]
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.009996s ]
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] = '8' ) AND ( [post].[published_time] > '0' AND [post].[published_time] < '1776512099' )) AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 10) [ RunTime:0.010906s ]
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.011462s ]
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.010903s ]
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.012607s ]
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.010494s ]
