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.006921s ]
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.009520s ]
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.009886s ]
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.007774s ]
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] = '2' AND ( [post].[published_time] > '0' AND [post].[published_time] < '1776360475' )) AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.011289s ]
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] < '2' AND ( [post].[published_time] > '0' AND [post].[published_time] < '1776360475' )) AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.010460s ]
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] > '2' AND ( [post].[published_time] > '0' AND [post].[published_time] < '1776360475' )) AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.009729s ]
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.011355s ]
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.010255s ]
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] = '2') AS thinkphp) AS T1 [ RunTime:0.010621s ]
UPDATE [cmf_portal_post] SET [post_hits] = [post_hits] + 1 FROM [cmf_portal_post] WHERE [id] = 2 [ RunTime:0.010500s ]
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.011945s ]
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.010019s ]
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.008864s ]
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.010395s ]
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.010284s ]
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.010086s ]
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.009644s ]
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.009386s ]
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.008980s ]
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.010639s ]
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.012051s ]
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.011115s ]
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.009666s ]
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.011743s ]
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.010368s ]
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.011401s ]
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.010915s ]
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.011535s ]
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.013865s ]
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.087164s ]
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.014366s ]
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.089741s ]
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.012690s ]
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] < '1776360476' )) AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 10) [ RunTime:0.018136s ]
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.086256s ]
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.013036s ]
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.088435s ]
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.012373s ]
