[ DB ] CONNECT:[ UseTime:0.000150s ] 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 = 'jia_class' [ RunTime:0.004417s ]
[ SQL ] SELECT column_name FROM information_schema.key_column_usage WHERE table_name='jia_class' [ RunTime:0.004236s ]
[ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT * FROM [jia_class] WHERE [id] = 568) AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.002183s ]
[ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT * FROM [jia_class] WHERE [id] = 568) AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.001996s ]
[ 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_list' [ RunTime:0.002051s ]
[ SQL ] SELECT column_name FROM information_schema.key_column_usage WHERE table_name='jia_list' [ RunTime:0.001219s ]
[ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY pai asc) AS ROW_NUMBER FROM (SELECT [id],[pai],[classid],[bt],[parentid] FROM [jia_list] WHERE [classid] = 568 AND [parentid] = 0) AS thinkphp) AS T1 [ RunTime:0.002772s ]
[ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY pai asc) AS ROW_NUMBER FROM (SELECT [id],[type],[pai],[classid],[bt],[parentid],[jpjpm] FROM [jia_list] WHERE ( parentid='16315' )) AS thinkphp) AS T1 [ RunTime:0.087307s ]
[ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY pai asc) AS ROW_NUMBER FROM (SELECT [id],[type],[pai],[classid],[bt],[parentid],[jpjpm] FROM [jia_list] WHERE ( parentid='16305' )) AS thinkphp) AS T1 [ RunTime:0.063626s ]
[ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY pai asc) AS ROW_NUMBER FROM (SELECT [id],[type],[pai],[classid],[bt],[parentid],[jpjpm] FROM [jia_list] WHERE ( parentid='16331' )) AS thinkphp) AS T1 [ RunTime:0.079307s ]
[ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY pai asc) AS ROW_NUMBER FROM (SELECT [id],[type],[pai],[classid],[bt],[parentid],[jpjpm] FROM [jia_list] WHERE ( parentid='16333' )) AS thinkphp) AS T1 [ RunTime:0.074175s ]
[ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY pai asc) AS ROW_NUMBER FROM (SELECT [id],[type],[pai],[classid],[bt],[parentid],[jpjpm] FROM [jia_list] WHERE ( parentid='16321' )) AS thinkphp) AS T1 [ RunTime:0.080981s ]
[ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY pai asc) AS ROW_NUMBER FROM (SELECT [id],[type],[pai],[classid],[bt],[parentid],[jpjpm] FROM [jia_list] WHERE ( parentid='16308' )) AS thinkphp) AS T1 [ RunTime:0.086889s ]
[ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY pai asc) AS ROW_NUMBER FROM (SELECT [id],[type],[pai],[classid],[bt],[parentid],[jpjpm] FROM [jia_list] WHERE ( parentid='16309' )) AS thinkphp) AS T1 [ RunTime:0.088550s ]
