[ DB ] CONNECT:[ UseTime:0.000155s ] sqlsrv:Database=yhhy_db;Server=localhost
[ 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_class' [ RunTime:0.000891s ]
[ SQL ] SELECT column_name FROM information_schema.key_column_usage WHERE table_name='pdpx_class' [ RunTime:0.000735s ]
[ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT * FROM [pdpx_class] WHERE [lid] = 12) AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.000590s ]
[ 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.001041s ]
[ SQL ] SELECT column_name FROM information_schema.key_column_usage WHERE table_name='pdpx' [ RunTime:0.000768s ]
[ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT COUNT(*) AS tp_count FROM [pdpx] WHERE [lb] = 12 AND [tpid] <> '') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.045761s ]
[ 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 4000 + 1 AND 4000 + 10) [ RunTime:0.189265s ]
[ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY id desc) AS ROW_NUMBER FROM (SELECT [id],[mz],[lb] FROM [pdpx] WHERE [lb] = 13) AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 8) [ RunTime:0.010086s ]
[ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY id desc) AS ROW_NUMBER FROM (SELECT [id],[mz],[xx],[tpid],[lb] FROM [pdpx] WHERE [lb] = 12 AND [tpid] <> '') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 3) [ RunTime:0.000855s ]