[ DB ] CONNECT:[ UseTime:0.000210s ] sqlsrv:Database=yhhy_db;Server=192.168.23.112
[ SQL ] 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 = 'bbs_list' [ RunTime:0.001300s ]
[ SQL ] SELECT column_name FROM information_schema.key_column_usage WHERE table_name='bbs_list' [ RunTime:0.000746s ]
[ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT * FROM [bbs_list] WHERE [id] = 26) AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.000893s ]
[ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT * FROM [bbs_list] WHERE [id] = 26) AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.000794s ]
[ SQL ] UPDATE [bbs_list] SET [dj]=2042,[date1]='2023-12-10 14:50:25' FROM [bbs_list] WHERE [id] = 26 [ RunTime:0.001808s ]
[ SQL ] 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 = 'bbs_pl' [ RunTime:0.001154s ]
[ SQL ] SELECT column_name FROM information_schema.key_column_usage WHERE table_name='bbs_pl' [ RunTime:0.000649s ]
[ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT COUNT(*) AS tp_count FROM [bbs_pl] WHERE [newsid] = 26 AND [pid] = 0) AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.000849s ]
[ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT * FROM [bbs_pl] WHERE [newsid] = 26 AND [pid] = 0) AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 0 + 1 AND 0 + 5) [ RunTime:0.000813s ]
[ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT COUNT(*) AS tp_count FROM [bbs_pl] WHERE [newsid] = 26) AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.000806s ]
[ SQL ] 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 = 'userinfo' [ RunTime:0.001533s ]
[ SQL ] SELECT column_name FROM information_schema.key_column_usage WHERE table_name='userinfo' [ RunTime:0.000710s ]
[ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT * FROM [userinfo] WHERE [usercode] IS NULL OR [phone] IS NULL) AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.001738s ]
[ SQL ] 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 = 'pdpx' [ RunTime:0.001245s ]
[ SQL ] SELECT column_name FROM information_schema.key_column_usage WHERE table_name='pdpx' [ RunTime:0.000836s ]
[ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY [id] desc) AS ROW_NUMBER FROM (SELECT * FROM [pdpx]) AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 10) [ RunTime:0.000958s ]
[ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY [id] desc) AS ROW_NUMBER FROM (SELECT * FROM [pdpx] WHERE [lb] = 12 AND [tpid] <> '') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 5) [ RunTime:0.000984s ]
登录
注册
