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.007155s ]
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.011149s ]
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.011286s ]
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.072786s ]
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] < '1776505747' )) AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.016930s ]
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] < '1776505747' )) AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.014910s ]
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] < '1776505747' )) AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.016508s ]
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.078131s ]
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.089207s ]
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.016546s ]
UPDATE [cmf_portal_post] SET [post_hits] = [post_hits] + 1 FROM [cmf_portal_post] WHERE [id] = 2 [ RunTime:0.014121s ]
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.094775s ]
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.017179s ]
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.010702s ]
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.011236s ]
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.011211s ]
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.009639s ]
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.010378s ]
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.009858s ]
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.008708s ]
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.010881s ]
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.014048s ]
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.088746s ]
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.015866s ]
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.086961s ]
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.014340s ]
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.078761s ]
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.013645s ]
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.069830s ]
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.013185s ]
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.092418s ]
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.016395s ]
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.091626s ]
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.016558s ]
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] < '1776505750' )) AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 10) [ RunTime:0.024409s ]
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.094992s ]
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.016093s ]
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.094973s ]
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.014123s ]
