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 = 'CF_USER' [ RunTime:0.000695s ]
SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY [GAME_POINT] DESC) AS ROW_NUMBER FROM (SELECT [NICK],[LEV],[EXP],[GAME_POINT],[LAST_PLAY_DATE] FROM [CF_USER] WHERE [NICK] NOT LIKE '%[GM]%') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 10) [ RunTime:0.000452s ]
SHOW FULL COLUMNS FROM `cf_news` [ RunTime:0.000559s ]
SELECT * FROM `cf_news` ORDER BY `create_time` DESC LIMIT 1 [ RunTime:0.000216s ]
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 = 'CF_MIN_CU' [ RunTime:0.000800s ]
SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT * FROM [CF_MIN_CU] WHERE [SERVER] = '1') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.000314s ]