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.007500s ]
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.010961s ]
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.011280s ]
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.008038s ]
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] < '1776353400' )) AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.011325s ]
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] < '1776353400' )) AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.010638s ]
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] < '1776353400' )) AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.010429s ]
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.010673s ]
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.011342s ]
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.010459s ]
UPDATE [cmf_portal_post] SET [post_hits] = [post_hits] + 1 FROM [cmf_portal_post] WHERE [id] = 3 [ RunTime:0.010688s ]
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.010053s ]
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.011856s ]
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.009312s ]
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.008635s ]
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.009409s ]
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.010098s ]
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.011770s ]
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.009950s ]
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.009949s ]
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.012095s ]
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.011273s ]
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.011612s ]
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.010973s ]
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.088095s ]
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.010868s ]
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.090861s ]
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.011247s ]
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.088372s ]
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.010343s ]
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.089915s ]
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.010859s ]
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.088124s ]
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.008764s ]
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] < '1776353402' )) AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 10) [ RunTime:0.012125s ]
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.094209s ]
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.013222s ]
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.089670s ]
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.009724s ]
