[ DB ] CONNECT:[ UseTime:0.001013s ] sqlsrv:Database=yhhy_db;Server=10.15.6.40,1433
[ 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.003519s ]
[ SQL ] SELECT column_name FROM information_schema.key_column_usage WHERE table_name='pdpx' [ RunTime:0.002075s ]
[ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY id desc) AS ROW_NUMBER FROM (SELECT [id],[lb],[mz] FROM [pdpx] WHERE [lb] = 30) AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 10) [ RunTime:0.009900s ]
[ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY id desc) AS ROW_NUMBER FROM (SELECT [id],[lb],[mz],[xx] FROM [pdpx] WHERE [lb] = 2) AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 5) [ RunTime:0.010604s ]
[ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY id desc) AS ROW_NUMBER FROM (SELECT [id],[lb],[mz],[xx] FROM [pdpx] WHERE [lb] = 3) AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 5) [ RunTime:0.002927s ]
[ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY id desc) AS ROW_NUMBER FROM (SELECT [id],[lb],[mz],[xx] FROM [pdpx] WHERE [lb] = 9) AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 5) [ RunTime:0.006287s ]
[ 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 = 'jia_class' [ RunTime:0.003475s ]
[ SQL ] SELECT column_name FROM information_schema.key_column_usage WHERE table_name='jia_class' [ RunTime:0.001649s ]
[ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY id desc) AS ROW_NUMBER FROM (SELECT * FROM [jia_class]) AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 12) [ RunTime:0.006063s ]
[ 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_class' [ RunTime:0.042069s ]
[ SQL ] SELECT column_name FROM information_schema.key_column_usage WHERE table_name='bbs_class' [ RunTime:0.051887s ]
[ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT * FROM [bbs_class]) AS thinkphp) AS T1 [ RunTime:0.004617s ]
[ 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.030628s ]
[ SQL ] SELECT column_name FROM information_schema.key_column_usage WHERE table_name='bbs_list' [ RunTime:0.047879s ]
[ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY id desc) AS ROW_NUMBER FROM (SELECT * FROM [bbs_list] WHERE ( classid='1' )) AS thinkphp) AS T1 [ RunTime:0.008008s ]
[ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY id desc) AS ROW_NUMBER FROM (SELECT * FROM [bbs_list] WHERE ( classid='2' )) AS thinkphp) AS T1 [ RunTime:0.005782s ]
[ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY id desc) AS ROW_NUMBER FROM (SELECT * FROM [bbs_list] WHERE ( classid='3' )) AS thinkphp) AS T1 [ RunTime:0.008867s ]
[ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY id desc) AS ROW_NUMBER FROM (SELECT * FROM [bbs_list] WHERE ( classid='4' )) AS thinkphp) AS T1 [ RunTime:0.007509s ]
登录
注册
