--------------------------------------------------------------- [ 2021-01-08T08:23:31+08:00 ] 58.51.237.72 GET 103.45.248.127:31/h5app/login/index.html [运行时间：0.309571s] [吞吐率：3.23req/s] [内存消耗：1,758.95kb] [文件加载：46] [ info ] [ LANG ] D:\phpStudy\PHPTutorial\WWW\jxc_app\thinkphp\lang\zh-cn.php [ info ] [ ROUTE ] array ( 'type' => 'module', 'module' => array ( 0 => 'h5app', 1 => 'login', 2 => 'index', ), ) [ info ] [ HEADER ] array ( 'host' => '103.45.248.127:31', 'connection' => 'keep-alive', 'upgrade-insecure-requests' => '1', 'user-agent' => 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/78.0.3904.108 Safari/537.36', 'accept' => 'text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3', 'accept-encoding' => 'gzip, deflate', 'accept-language' => 'zh-CN,zh;q=0.9', 'cookie' => '__guid=168097185.357580965953092600.1609978174543.8318; monitor_count=3', ) [ info ] [ PARAM ] array ( ) [ info ] [ RUN ] app\h5app\controller\Login->index[ D:\phpStudy\PHPTutorial\WWW\jxc_app\application\h5app\controller\Login.php ] [ info ] [ VIEW ] D:\phpStudy\PHPTutorial\WWW\jxc_app\public/../application/h5app\view\Login\index.html [ array ( 0 => 'usermember', 1 => 'userid', 2 => 'username', 3 => 'password', ) ] [ info ] [ LOG ] INIT File --------------------------------------------------------------- [ 2021-01-08T08:25:02+08:00 ] 58.51.237.72 POST 103.45.248.127:31/h5app/login/dologin.html [运行时间：0.734375s] [吞吐率：1.36req/s] [内存消耗：2,370.66kb] [文件加载：48] [ info ] [ LANG ] D:\phpStudy\PHPTutorial\WWW\jxc_app\thinkphp\lang\zh-cn.php [ info ] [ ROUTE ] array ( 'type' => 'module', 'module' => array ( 0 => 'h5app', 1 => 'login', 2 => 'dologin', ), ) [ info ] [ HEADER ] array ( 'host' => '103.45.248.127:31', 'connection' => 'keep-alive', 'content-length' => '128', 'accept' => 'application/json, text/javascript, */*; q=0.01', 'origin' => 'http://103.45.248.127:31', 'x-requested-with' => 'XMLHttpRequest', 'user-agent' => 'Mozilla/5.0 (Linux; Android 5.0; SM-G900P Build/LRX21T) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/78.0.3904.108 Mobile Safari/537.36', 'content-type' => 'application/x-www-form-urlencoded; charset=UTF-8', 'referer' => 'http://103.45.248.127:31/h5app/login/index.html', 'accept-encoding' => 'gzip, deflate', 'accept-language' => 'zh-CN,zh;q=0.9', 'cookie' => '__guid=168097185.357580965953092600.1609978174543.8318; monitor_count=4', ) [ info ] [ PARAM ] array ( 'userid' => 'http://v.lenosoft.net/bsdepot_dc/login.asp 6E8991F2BB728422583338CCE773B159', 'username' => 'admin', 'password' => '', 'remember' => '1', ) [ info ] [ RUN ] app\h5app\controller\Login->dologin[ D:\phpStudy\PHPTutorial\WWW\jxc_app\application\h5app\controller\Login.php ] [ info ] [ DB ] INIT sqlsrv [ info ] [ LOG ] INIT File [ sql ] [ DB ] CONNECT:[ UseTime:0.357422s ] sqlsrv:Database=jxcuser;Server=127.0.0.1,1433 [ sql ] [ 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 = 't_user' [ RunTime:0.154297s ] [ sql ] [ SQL ] SELECT column_name FROM information_schema.key_column_usage WHERE table_name='t_user' [ RunTime:0.071289s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT * FROM [t_user] WHERE [userid] = 'http://v.lenosoft.net/bsdepot_dc/login.asp 6E8991F2BB728422583338CCE773B159') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.008790s ] --------------------------------------------------------------- [ 2021-01-08T08:25:18+08:00 ] 58.51.237.72 POST 103.45.248.127:31/h5app/login/dologin.html [运行时间：0.087890s] [吞吐率：11.38req/s] [内存消耗：2,370.87kb] [文件加载：48] [ info ] [ LANG ] D:\phpStudy\PHPTutorial\WWW\jxc_app\thinkphp\lang\zh-cn.php [ info ] [ ROUTE ] array ( 'type' => 'module', 'module' => array ( 0 => 'h5app', 1 => 'login', 2 => 'dologin', ), ) [ info ] [ HEADER ] array ( 'host' => '103.45.248.127:31', 'connection' => 'keep-alive', 'content-length' => '160', 'accept' => 'application/json, text/javascript, */*; q=0.01', 'origin' => 'http://103.45.248.127:31', 'x-requested-with' => 'XMLHttpRequest', 'user-agent' => 'Mozilla/5.0 (Linux; Android 5.0; SM-G900P Build/LRX21T) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/78.0.3904.108 Mobile Safari/537.36', 'content-type' => 'application/x-www-form-urlencoded; charset=UTF-8', 'referer' => 'http://103.45.248.127:31/h5app/login/index.html', 'accept-encoding' => 'gzip, deflate', 'accept-language' => 'zh-CN,zh;q=0.9', 'cookie' => '__guid=168097185.357580965953092600.1609978174543.8318; monitor_count=4', ) [ info ] [ PARAM ] array ( 'userid' => 'http://v.lenosoft.net/bsdep6E8991F2BB728422583338CCE773B159ot_dc/login.asp 6E8991F2BB728422583338CCE773B159', 'username' => 'admin', 'password' => '', 'remember' => '1', ) [ info ] [ RUN ] app\h5app\controller\Login->dologin[ D:\phpStudy\PHPTutorial\WWW\jxc_app\application\h5app\controller\Login.php ] [ info ] [ DB ] INIT sqlsrv [ info ] [ LOG ] INIT File [ sql ] [ DB ] CONNECT:[ UseTime:0.000000s ] sqlsrv:Database=jxcuser;Server=127.0.0.1,1433 [ sql ] [ 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 = 't_user' [ RunTime:0.000000s ] [ sql ] [ SQL ] SELECT column_name FROM information_schema.key_column_usage WHERE table_name='t_user' [ RunTime:0.000000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT * FROM [t_user] WHERE [userid] = 'http://v.lenosoft.net/bsdep6E8991F2BB728422583338CCE773B159ot_dc/login.asp 6E8991F2BB728422583338CCE773B159') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.000000s ] --------------------------------------------------------------- [ 2021-01-08T08:25:32+08:00 ] 58.51.237.72 POST 103.45.248.127:31/h5app/login/dologin.html [运行时间：0.075195s] [吞吐率：13.30req/s] [内存消耗：2,370.68kb] [文件加载：48] [ info ] [ LANG ] D:\phpStudy\PHPTutorial\WWW\jxc_app\thinkphp\lang\zh-cn.php [ info ] [ ROUTE ] array ( 'type' => 'module', 'module' => array ( 0 => 'h5app', 1 => 'login', 2 => 'dologin', ), ) [ info ] [ HEADER ] array ( 'host' => '103.45.248.127:31', 'connection' => 'keep-alive', 'content-length' => '125', 'accept' => 'application/json, text/javascript, */*; q=0.01', 'origin' => 'http://103.45.248.127:31', 'x-requested-with' => 'XMLHttpRequest', 'user-agent' => 'Mozilla/5.0 (Linux; Android 5.0; SM-G900P Build/LRX21T) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/78.0.3904.108 Mobile Safari/537.36', 'content-type' => 'application/x-www-form-urlencoded; charset=UTF-8', 'referer' => 'http://103.45.248.127:31/h5app/login/index.html', 'accept-encoding' => 'gzip, deflate', 'accept-language' => 'zh-CN,zh;q=0.9', 'cookie' => '__guid=168097185.357580965953092600.1609978174543.8318; monitor_count=4', ) [ info ] [ PARAM ] array ( 'userid' => '6E8991F2BB728422583338CCE773B159ot_dc/login.asp 6E8991F2BB728422583338CCE773B159', 'username' => 'admin', 'password' => '', 'remember' => '1', ) [ info ] [ RUN ] app\h5app\controller\Login->dologin[ D:\phpStudy\PHPTutorial\WWW\jxc_app\application\h5app\controller\Login.php ] [ info ] [ DB ] INIT sqlsrv [ info ] [ LOG ] INIT File [ sql ] [ DB ] CONNECT:[ UseTime:0.000000s ] sqlsrv:Database=jxcuser;Server=127.0.0.1,1433 [ sql ] [ 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 = 't_user' [ RunTime:0.002930s ] [ sql ] [ SQL ] SELECT column_name FROM information_schema.key_column_usage WHERE table_name='t_user' [ RunTime:0.001953s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT * FROM [t_user] WHERE [userid] = '6E8991F2BB728422583338CCE773B159ot_dc/login.asp 6E8991F2BB728422583338CCE773B159') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.005860s ] --------------------------------------------------------------- [ 2021-01-08T08:25:57+08:00 ] 58.51.237.72 POST 103.45.248.127:31/h5app/login/dologin.html [运行时间：0.311523s] [吞吐率：3.21req/s] [内存消耗：2,430.30kb] [文件加载：49] [ info ] [ LANG ] D:\phpStudy\PHPTutorial\WWW\jxc_app\thinkphp\lang\zh-cn.php [ info ] [ ROUTE ] array ( 'type' => 'module', 'module' => array ( 0 => 'h5app', 1 => 'login', 2 => 'dologin', ), ) [ info ] [ HEADER ] array ( 'host' => '103.45.248.127:31', 'connection' => 'keep-alive', 'content-length' => '75', 'accept' => 'application/json, text/javascript, */*; q=0.01', 'origin' => 'http://103.45.248.127:31', 'x-requested-with' => 'XMLHttpRequest', 'user-agent' => 'Mozilla/5.0 (Linux; Android 5.0; SM-G900P Build/LRX21T) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/78.0.3904.108 Mobile Safari/537.36', 'content-type' => 'application/x-www-form-urlencoded; charset=UTF-8', 'referer' => 'http://103.45.248.127:31/h5app/login/index.html', 'accept-encoding' => 'gzip, deflate', 'accept-language' => 'zh-CN,zh;q=0.9', 'cookie' => '__guid=168097185.357580965953092600.1609978174543.8318; monitor_count=4', ) [ info ] [ PARAM ] array ( 'userid' => '6E8991F2BB728422583338CCE773B159', 'username' => 'admin', 'password' => '', 'remember' => '1', ) [ info ] [ RUN ] app\h5app\controller\Login->dologin[ D:\phpStudy\PHPTutorial\WWW\jxc_app\application\h5app\controller\Login.php ] [ info ] [ DB ] INIT sqlsrv [ info ] [ DB ] INIT sqlsrv [ info ] [ LOG ] INIT File [ sql ] [ DB ] CONNECT:[ UseTime:0.000977s ] sqlsrv:Database=jxcuser;Server=127.0.0.1,1433 [ sql ] [ 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 = 't_user' [ RunTime:0.001953s ] [ sql ] [ SQL ] SELECT column_name FROM information_schema.key_column_usage WHERE table_name='t_user' [ RunTime:0.000977s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT * FROM [t_user] WHERE [userid] = '6E8991F2BB728422583338CCE773B159') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.003906s ] [ sql ] [ DB ] CONNECT:[ UseTime:0.005859s ] sqlsrv:Database=sqljxc689;Server=127.0.0.1,1433 [ sql ] [ 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 = 'Admin' [ RunTime:0.145508s ] [ sql ] [ SQL ] SELECT column_name FROM information_schema.key_column_usage WHERE table_name='Admin' [ RunTime:0.076171s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT * FROM [Admin] WHERE [UserName] = 'admin' AND [Password] = '') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.004883s ] --------------------------------------------------------------- [ 2021-01-08T08:25:58+08:00 ] 58.51.237.72 GET 103.45.248.127:31/h5app/index/index.html [运行时间：0.084961s] [吞吐率：11.77req/s] [内存消耗：1,931.22kb] [文件加载：50] [ info ] [ LANG ] D:\phpStudy\PHPTutorial\WWW\jxc_app\thinkphp\lang\zh-cn.php [ info ] [ ROUTE ] array ( 'type' => 'module', 'module' => array ( 0 => 'h5app', 1 => 'index', 2 => 'index', ), ) [ info ] [ HEADER ] array ( 'host' => '103.45.248.127:31', 'connection' => 'keep-alive', 'upgrade-insecure-requests' => '1', 'user-agent' => 'Mozilla/5.0 (Linux; Android 5.0; SM-G900P Build/LRX21T) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/78.0.3904.108 Mobile Safari/537.36', 'accept' => 'text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3', 'referer' => 'http://103.45.248.127:31/h5app/login/index.html', 'accept-encoding' => 'gzip, deflate', 'accept-language' => 'zh-CN,zh;q=0.9', 'cookie' => '__guid=168097185.357580965953092600.1609978174543.8318; monitor_count=4; mydb=sqljxc689; remember=1; userid=6E8991F2BB728422583338CCE773B159; username=admin; admin=think%3A%7B%22ID%22%3A%221%22%2C%22userdb%22%3A%22sqljxc689%22%2C%22userid%22%3A%226E8991F2BB728422583338CCE773B159%22%2C%22usernumber%22%3A%222%22%2C%22trysign%22%3A%221%22%2C%22begindate%22%3A%222020-08-18%2B00%253A00%253A00.000%22%2C%22username%22%3Anull%2C%22usermob%22%3Anull%2C%22opuser%22%3Anull%2C%22useday%22%3A%22365%22%2C%22ROW_NUMBER%22%3A%221%22%7D', ) [ info ] [ PARAM ] array ( ) [ info ] [ DB ] INIT sqlsrv [ info ] [ RUN ] app\h5app\controller\Index->index[ D:\phpStudy\PHPTutorial\WWW\jxc_app\application\h5app\controller\Index.php ] [ info ] [ VIEW ] D:\phpStudy\PHPTutorial\WWW\jxc_app\public/../application/h5app\view\Index\index.html [ array ( 0 => 'index_url', ) ] [ info ] [ LOG ] INIT File --------------------------------------------------------------- [ 2021-01-08T08:25:59+08:00 ] 58.51.237.72 GET 103.45.248.127:31/h5app/index/home.html [运行时间：0.197265s] [吞吐率：5.07req/s] [内存消耗：2,556.60kb] [文件加载：55] [ info ] [ LANG ] D:\phpStudy\PHPTutorial\WWW\jxc_app\thinkphp\lang\zh-cn.php [ info ] [ ROUTE ] array ( 'type' => 'module', 'module' => array ( 0 => 'h5app', 1 => 'index', 2 => 'home', ), ) [ info ] [ HEADER ] array ( 'host' => '103.45.248.127:31', 'connection' => 'keep-alive', 'upgrade-insecure-requests' => '1', 'user-agent' => 'Mozilla/5.0 (Linux; Android 5.0; SM-G900P Build/LRX21T) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/78.0.3904.108 Mobile Safari/537.36', 'accept' => 'text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3', 'referer' => 'http://103.45.248.127:31/h5app/index/index.html', 'accept-encoding' => 'gzip, deflate', 'accept-language' => 'zh-CN,zh;q=0.9', 'cookie' => '__guid=168097185.357580965953092600.1609978174543.8318; mydb=sqljxc689; remember=1; userid=6E8991F2BB728422583338CCE773B159; username=admin; admin=think%3A%7B%22ID%22%3A%221%22%2C%22userdb%22%3A%22sqljxc689%22%2C%22userid%22%3A%226E8991F2BB728422583338CCE773B159%22%2C%22usernumber%22%3A%222%22%2C%22trysign%22%3A%221%22%2C%22begindate%22%3A%222020-08-18%2B00%253A00%253A00.000%22%2C%22username%22%3Anull%2C%22usermob%22%3Anull%2C%22opuser%22%3Anull%2C%22useday%22%3A%22365%22%2C%22ROW_NUMBER%22%3A%221%22%7D; monitor_count=5', ) [ info ] [ PARAM ] array ( ) [ info ] [ DB ] INIT sqlsrv [ info ] [ RUN ] app\h5app\controller\Index->home[ D:\phpStudy\PHPTutorial\WWW\jxc_app\application\h5app\controller\Index.php ] [ info ] [ VIEW ] D:\phpStudy\PHPTutorial\WWW\jxc_app\public/../application/h5app\view\Index\home.html [ array ( 0 => 'index_url', 1 => 'cg_num', 2 => 'xs_num', ) ] [ info ] [ LOG ] INIT File [ sql ] [ DB ] CONNECT:[ UseTime:0.005859s ] sqlsrv:Database=sqljxc689;Server=127.0.0.1,1433 [ sql ] [ 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 = 'T_Bill' [ RunTime:0.032226s ] [ sql ] [ SQL ] SELECT column_name FROM information_schema.key_column_usage WHERE table_name='T_Bill' [ RunTime:0.062500s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT COUNT(ID) AS tp_count FROM [T_Bill] WHERE [BillType] = '采购收货' AND [AddDate] = '2021-01-08') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.004882s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT COUNT(ID) AS tp_count FROM [T_Bill] WHERE [BillType] = '销售出货' AND [AddDate] = '2021-01-08') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.000977s ] --------------------------------------------------------------- [ 2021-01-08T08:25:59+08:00 ] 58.51.237.72 GET 103.45.248.127:31/h5app/index/home.html [运行时间：0.144532s] [吞吐率：6.92req/s] [内存消耗：2,556.60kb] [文件加载：55] [ info ] [ LANG ] D:\phpStudy\PHPTutorial\WWW\jxc_app\thinkphp\lang\zh-cn.php [ info ] [ ROUTE ] array ( 'type' => 'module', 'module' => array ( 0 => 'h5app', 1 => 'index', 2 => 'home', ), ) [ info ] [ HEADER ] array ( 'host' => '103.45.248.127:31', 'connection' => 'keep-alive', 'upgrade-insecure-requests' => '1', 'user-agent' => 'Mozilla/5.0 (Linux; Android 5.0; SM-G900P Build/LRX21T) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/78.0.3904.108 Mobile Safari/537.36', 'accept' => 'text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3', 'referer' => 'http://103.45.248.127:31/h5app/index/index.html', 'accept-encoding' => 'gzip, deflate', 'accept-language' => 'zh-CN,zh;q=0.9', 'cookie' => '__guid=168097185.357580965953092600.1609978174543.8318; mydb=sqljxc689; remember=1; userid=6E8991F2BB728422583338CCE773B159; username=admin; admin=think%3A%7B%22ID%22%3A%221%22%2C%22userdb%22%3A%22sqljxc689%22%2C%22userid%22%3A%226E8991F2BB728422583338CCE773B159%22%2C%22usernumber%22%3A%222%22%2C%22trysign%22%3A%221%22%2C%22begindate%22%3A%222020-08-18%2B00%253A00%253A00.000%22%2C%22username%22%3Anull%2C%22usermob%22%3Anull%2C%22opuser%22%3Anull%2C%22useday%22%3A%22365%22%2C%22ROW_NUMBER%22%3A%221%22%7D; monitor_count=5', ) [ info ] [ PARAM ] array ( ) [ info ] [ DB ] INIT sqlsrv [ info ] [ RUN ] app\h5app\controller\Index->home[ D:\phpStudy\PHPTutorial\WWW\jxc_app\application\h5app\controller\Index.php ] [ info ] [ VIEW ] D:\phpStudy\PHPTutorial\WWW\jxc_app\public/../application/h5app\view\Index\home.html [ array ( 0 => 'index_url', 1 => 'cg_num', 2 => 'xs_num', ) ] [ info ] [ LOG ] INIT File [ sql ] [ DB ] CONNECT:[ UseTime:0.004883s ] sqlsrv:Database=sqljxc689;Server=127.0.0.1,1433 [ sql ] [ 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 = 'T_Bill' [ RunTime:0.000976s ] [ sql ] [ SQL ] SELECT column_name FROM information_schema.key_column_usage WHERE table_name='T_Bill' [ RunTime:0.059571s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT COUNT(ID) AS tp_count FROM [T_Bill] WHERE [BillType] = '采购收货' AND [AddDate] = '2021-01-08') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.000977s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT COUNT(ID) AS tp_count FROM [T_Bill] WHERE [BillType] = '销售出货' AND [AddDate] = '2021-01-08') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.000976s ] --------------------------------------------------------------- [ 2021-01-08T08:26:07+08:00 ] 27.115.124.6 GET 103.45.248.127:31/h5app/index/index.html [运行时间：0.054688s] [吞吐率：18.29req/s] [内存消耗：1,724.77kb] [文件加载：47] [ info ] [ LANG ] D:\phpStudy\PHPTutorial\WWW\jxc_app\thinkphp\lang\zh-cn.php [ info ] [ ROUTE ] array ( 'type' => 'module', 'module' => array ( 0 => 'h5app', 1 => 'index', 2 => 'index', ), ) [ info ] [ HEADER ] array ( 'host' => '103.45.248.127:31', 'connection' => 'keep-alive', 'user-agent' => 'Mozilla/5.0 (Linux; U; Android 8.1.0; zh-CN; EML-AL00 Build/HUAWEIEML-AL00) AppleWebKit/537.36 (KHTML, like Gecko) Version/4.0 Chrome/57.0.2987.108 baidu.sogo.uc.UCBrowser/11.9.4.974 UWS/2.13.1.48 Mobile Safari/537.36 AliApp(DingTalk/4.5.11) com.alibaba.android.rimet/10487439 Channel/227200 language/zh-CN', 'upgrade-insecure-requests' => '1', 'accept' => 'text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,image/apng,*/*;q=0.8', 'accept-encoding' => 'gzip, deflate', ) [ info ] [ PARAM ] array ( ) [ info ] [ LOG ] INIT File --------------------------------------------------------------- [ 2021-01-08T08:26:07+08:00 ] 180.163.220.4 GET 103.45.248.127:31/ [运行时间：0.047852s] [吞吐率：20.90req/s] [内存消耗：1,394.92kb] [文件加载：38] [ info ] [ LANG ] D:\phpStudy\PHPTutorial\WWW\jxc_app\thinkphp\lang\zh-cn.php [ info ] [ ROUTE ] array ( 'type' => 'module', 'module' => array ( 0 => '', 1 => NULL, 2 => NULL, ), ) [ info ] [ HEADER ] array ( 'host' => '103.45.248.127:31', 'connection' => 'keep-alive', 'user-agent' => 'Mozilla/5.0 (Linux; U; Android 8.1.0; zh-CN; EML-AL00 Build/HUAWEIEML-AL00) AppleWebKit/537.36 (KHTML, like Gecko) Version/4.0 Chrome/57.0.2987.108 baidu.sogo.uc.UCBrowser/11.9.4.974 UWS/2.13.1.48 Mobile Safari/537.36 AliApp(DingTalk/4.5.11) com.alibaba.android.rimet/10487439 Channel/227200 language/zh-CN', 'upgrade-insecure-requests' => '1', 'accept' => 'text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,image/apng,*/*;q=0.8', 'accept-encoding' => 'gzip, deflate', ) [ info ] [ PARAM ] array ( ) [ info ] [ LOG ] INIT File --------------------------------------------------------------- [ 2021-01-08T08:26:08+08:00 ] 27.115.124.6 GET 103.45.248.127:31/h5app/index/index.html [运行时间：0.045898s] [吞吐率：21.79req/s] [内存消耗：1,725.54kb] [文件加载：47] [ info ] [ LANG ] D:\phpStudy\PHPTutorial\WWW\jxc_app\thinkphp\lang\zh-cn.php [ info ] [ ROUTE ] array ( 'type' => 'module', 'module' => array ( 0 => 'h5app', 1 => 'index', 2 => 'index', ), ) [ info ] [ HEADER ] array ( 'host' => '103.45.248.127:31', 'connection' => 'keep-alive', 'pragma' => 'no-cache', 'cache-control' => 'no-cache', 'upgrade-insecure-requests' => '1', 'user-agent' => 'Mozilla/5.0 (Linux; U; Android 8.1.0; zh-CN; EML-AL00 Build/HUAWEIEML-AL00) AppleWebKit/537.36 (KHTML, like Gecko) Version/4.0 Chrome/57.0.2987.108 baidu.sogo.uc.UCBrowser/11.9.4.974 UWS/2.13.1.48 Mobile Safari/537.36 AliApp(DingTalk/4.5.11) com.alibaba.android.rimet/10487439 Channel/227200 language/zh-CN', 'accept' => 'text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,image/apng,*/*;q=0.8', 'referer' => 'http://baidu.com/', 'accept-encoding' => 'gzip, deflate', ) [ info ] [ PARAM ] array ( ) [ info ] [ LOG ] INIT File --------------------------------------------------------------- [ 2021-01-08T08:26:09+08:00 ] 180.163.220.5 GET 103.45.248.127:31/ [运行时间：0.037110s] [吞吐率：26.95req/s] [内存消耗：1,395.48kb] [文件加载：38] [ info ] [ LANG ] D:\phpStudy\PHPTutorial\WWW\jxc_app\thinkphp\lang\zh-cn.php [ info ] [ ROUTE ] array ( 'type' => 'module', 'module' => array ( 0 => '', 1 => NULL, 2 => NULL, ), ) [ info ] [ HEADER ] array ( 'host' => '103.45.248.127:31', 'connection' => 'keep-alive', 'pragma' => 'no-cache', 'cache-control' => 'no-cache', 'upgrade-insecure-requests' => '1', 'user-agent' => 'Mozilla/5.0 (Linux; U; Android 8.1.0; zh-CN; EML-AL00 Build/HUAWEIEML-AL00) AppleWebKit/537.36 (KHTML, like Gecko) Version/4.0 Chrome/57.0.2987.108 baidu.sogo.uc.UCBrowser/11.9.4.974 UWS/2.13.1.48 Mobile Safari/537.36 AliApp(DingTalk/4.5.11) com.alibaba.android.rimet/10487439 Channel/227200 language/zh-CN', 'accept' => 'text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,image/apng,*/*;q=0.8', 'referer' => 'http://baidu.com/', 'accept-encoding' => 'gzip, deflate', ) [ info ] [ PARAM ] array ( ) [ info ] [ LOG ] INIT File --------------------------------------------------------------- [ 2021-01-08T08:26:09+08:00 ] 27.115.124.6 GET 103.45.248.127:31/h5app/login/index.html [运行时间：0.044922s] [吞吐率：22.26req/s] [内存消耗：1,759.58kb] [文件加载：46] [ info ] [ LANG ] D:\phpStudy\PHPTutorial\WWW\jxc_app\thinkphp\lang\zh-cn.php [ info ] [ ROUTE ] array ( 'type' => 'module', 'module' => array ( 0 => 'h5app', 1 => 'login', 2 => 'index', ), ) [ info ] [ HEADER ] array ( 'host' => '103.45.248.127:31', 'connection' => 'keep-alive', 'pragma' => 'no-cache', 'cache-control' => 'no-cache', 'upgrade-insecure-requests' => '1', 'user-agent' => 'Mozilla/5.0 (Linux; U; Android 8.1.0; zh-CN; EML-AL00 Build/HUAWEIEML-AL00) AppleWebKit/537.36 (KHTML, like Gecko) Version/4.0 Chrome/57.0.2987.108 baidu.sogo.uc.UCBrowser/11.9.4.974 UWS/2.13.1.48 Mobile Safari/537.36 AliApp(DingTalk/4.5.11) com.alibaba.android.rimet/10487439 Channel/227200 language/zh-CN', 'accept' => 'text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,image/apng,*/*;q=0.8', 'referer' => 'http://baidu.com/', 'accept-encoding' => 'gzip, deflate', ) [ info ] [ PARAM ] array ( ) [ info ] [ RUN ] app\h5app\controller\Login->index[ D:\phpStudy\PHPTutorial\WWW\jxc_app\application\h5app\controller\Login.php ] [ info ] [ VIEW ] D:\phpStudy\PHPTutorial\WWW\jxc_app\public/../application/h5app\view\Login\index.html [ array ( 0 => 'usermember', 1 => 'userid', 2 => 'username', 3 => 'password', ) ] [ info ] [ LOG ] INIT File --------------------------------------------------------------- [ 2021-01-08T08:26:26+08:00 ] 27.115.124.70 GET 103.45.248.127:31/h5app/index/index.html [运行时间：0.057617s] [吞吐率：17.36req/s] [内存消耗：1,724.77kb] [文件加载：47] [ info ] [ LANG ] D:\phpStudy\PHPTutorial\WWW\jxc_app\thinkphp\lang\zh-cn.php [ info ] [ ROUTE ] array ( 'type' => 'module', 'module' => array ( 0 => 'h5app', 1 => 'index', 2 => 'index', ), ) [ info ] [ HEADER ] array ( 'host' => '103.45.248.127:31', 'connection' => 'keep-alive', 'user-agent' => 'Mozilla/5.0 (Linux; U; Android 8.1.0; zh-CN; EML-AL00 Build/HUAWEIEML-AL00) AppleWebKit/537.36 (KHTML, like Gecko) Version/4.0 Chrome/57.0.2987.108 baidu.sogo.uc.UCBrowser/11.9.4.974 UWS/2.13.1.48 Mobile Safari/537.36 AliApp(DingTalk/4.5.11) com.alibaba.android.rimet/10487439 Channel/227200 language/zh-CN', 'upgrade-insecure-requests' => '1', 'accept' => 'text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,image/apng,*/*;q=0.8', 'accept-encoding' => 'gzip, deflate', ) [ info ] [ PARAM ] array ( ) [ info ] [ LOG ] INIT File --------------------------------------------------------------- [ 2021-01-08T08:26:26+08:00 ] 27.115.124.101 GET 103.45.248.127:31/h5app/index/index.html [运行时间：0.056640s] [吞吐率：17.66req/s] [内存消耗：1,725.54kb] [文件加载：47] [ info ] [ LANG ] D:\phpStudy\PHPTutorial\WWW\jxc_app\thinkphp\lang\zh-cn.php [ info ] [ ROUTE ] array ( 'type' => 'module', 'module' => array ( 0 => 'h5app', 1 => 'index', 2 => 'index', ), ) [ info ] [ HEADER ] array ( 'host' => '103.45.248.127:31', 'connection' => 'keep-alive', 'pragma' => 'no-cache', 'cache-control' => 'no-cache', 'upgrade-insecure-requests' => '1', 'user-agent' => 'Mozilla/5.0 (Linux; U; Android 8.1.0; zh-CN; EML-AL00 Build/HUAWEIEML-AL00) AppleWebKit/537.36 (KHTML, like Gecko) Version/4.0 Chrome/57.0.2987.108 baidu.sogo.uc.UCBrowser/11.9.4.974 UWS/2.13.1.48 Mobile Safari/537.36 AliApp(DingTalk/4.5.11) com.alibaba.android.rimet/10487439 Channel/227200 language/zh-CN', 'accept' => 'text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,image/apng,*/*;q=0.8', 'referer' => 'http://baidu.com/', 'accept-encoding' => 'gzip, deflate', ) [ info ] [ PARAM ] array ( ) [ info ] [ LOG ] INIT File --------------------------------------------------------------- [ 2021-01-08T08:26:26+08:00 ] 27.115.124.101 GET 103.45.248.127:31/h5app/login/index.html [运行时间：0.049805s] [吞吐率：20.08req/s] [内存消耗：1,759.58kb] [文件加载：46] [ info ] [ LANG ] D:\phpStudy\PHPTutorial\WWW\jxc_app\thinkphp\lang\zh-cn.php [ info ] [ ROUTE ] array ( 'type' => 'module', 'module' => array ( 0 => 'h5app', 1 => 'login', 2 => 'index', ), ) [ info ] [ HEADER ] array ( 'host' => '103.45.248.127:31', 'connection' => 'keep-alive', 'pragma' => 'no-cache', 'cache-control' => 'no-cache', 'upgrade-insecure-requests' => '1', 'user-agent' => 'Mozilla/5.0 (Linux; U; Android 8.1.0; zh-CN; EML-AL00 Build/HUAWEIEML-AL00) AppleWebKit/537.36 (KHTML, like Gecko) Version/4.0 Chrome/57.0.2987.108 baidu.sogo.uc.UCBrowser/11.9.4.974 UWS/2.13.1.48 Mobile Safari/537.36 AliApp(DingTalk/4.5.11) com.alibaba.android.rimet/10487439 Channel/227200 language/zh-CN', 'accept' => 'text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,image/apng,*/*;q=0.8', 'referer' => 'http://baidu.com/', 'accept-encoding' => 'gzip, deflate', ) [ info ] [ PARAM ] array ( ) [ info ] [ RUN ] app\h5app\controller\Login->index[ D:\phpStudy\PHPTutorial\WWW\jxc_app\application\h5app\controller\Login.php ] [ info ] [ VIEW ] D:\phpStudy\PHPTutorial\WWW\jxc_app\public/../application/h5app\view\Login\index.html [ array ( 0 => 'usermember', 1 => 'userid', 2 => 'username', 3 => 'password', ) ] [ info ] [ LOG ] INIT File --------------------------------------------------------------- [ 2021-01-08T08:27:23+08:00 ] 58.51.237.72 GET 103.45.248.127:31/h5app/index/index.html [运行时间：0.060547s] [吞吐率：16.52req/s] [内存消耗：1,931.45kb] [文件加载：50] [ info ] [ LANG ] D:\phpStudy\PHPTutorial\WWW\jxc_app\thinkphp\lang\zh-cn.php [ info ] [ ROUTE ] array ( 'type' => 'module', 'module' => array ( 0 => 'h5app', 1 => 'index', 2 => 'index', ), ) [ info ] [ HEADER ] array ( 'host' => '103.45.248.127:31', 'connection' => 'keep-alive', 'cache-control' => 'max-age=0', 'upgrade-insecure-requests' => '1', 'user-agent' => 'Mozilla/5.0 (Linux; Android 5.0; SM-G900P Build/LRX21T) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/78.0.3904.108 Mobile Safari/537.36', 'accept' => 'text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3', 'referer' => 'http://103.45.248.127:31/h5app/login/index.html', 'accept-encoding' => 'gzip, deflate', 'accept-language' => 'zh-CN,zh;q=0.9', 'cookie' => '__guid=168097185.357580965953092600.1609978174543.8318; mydb=sqljxc689; remember=1; userid=6E8991F2BB728422583338CCE773B159; username=admin; admin=think%3A%7B%22ID%22%3A%221%22%2C%22userdb%22%3A%22sqljxc689%22%2C%22userid%22%3A%226E8991F2BB728422583338CCE773B159%22%2C%22usernumber%22%3A%222%22%2C%22trysign%22%3A%221%22%2C%22begindate%22%3A%222020-08-18%2B00%253A00%253A00.000%22%2C%22username%22%3Anull%2C%22usermob%22%3Anull%2C%22opuser%22%3Anull%2C%22useday%22%3A%22365%22%2C%22ROW_NUMBER%22%3A%221%22%7D; monitor_count=5', ) [ info ] [ PARAM ] array ( ) [ info ] [ DB ] INIT sqlsrv [ info ] [ RUN ] app\h5app\controller\Index->index[ D:\phpStudy\PHPTutorial\WWW\jxc_app\application\h5app\controller\Index.php ] [ info ] [ VIEW ] D:\phpStudy\PHPTutorial\WWW\jxc_app\public/../application/h5app\view\Index\index.html [ array ( 0 => 'index_url', ) ] [ info ] [ LOG ] INIT File --------------------------------------------------------------- [ 2021-01-08T08:27:23+08:00 ] 58.51.237.72 GET 103.45.248.127:31/h5app/index/home.html [运行时间：0.102539s] [吞吐率：9.75req/s] [内存消耗：2,556.60kb] [文件加载：55] [ info ] [ LANG ] D:\phpStudy\PHPTutorial\WWW\jxc_app\thinkphp\lang\zh-cn.php [ info ] [ ROUTE ] array ( 'type' => 'module', 'module' => array ( 0 => 'h5app', 1 => 'index', 2 => 'home', ), ) [ info ] [ HEADER ] array ( 'host' => '103.45.248.127:31', 'connection' => 'keep-alive', 'upgrade-insecure-requests' => '1', 'user-agent' => 'Mozilla/5.0 (Linux; Android 5.0; SM-G900P Build/LRX21T) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/78.0.3904.108 Mobile Safari/537.36', 'accept' => 'text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3', 'referer' => 'http://103.45.248.127:31/h5app/index/index.html', 'accept-encoding' => 'gzip, deflate', 'accept-language' => 'zh-CN,zh;q=0.9', 'cookie' => '__guid=168097185.357580965953092600.1609978174543.8318; mydb=sqljxc689; remember=1; userid=6E8991F2BB728422583338CCE773B159; username=admin; admin=think%3A%7B%22ID%22%3A%221%22%2C%22userdb%22%3A%22sqljxc689%22%2C%22userid%22%3A%226E8991F2BB728422583338CCE773B159%22%2C%22usernumber%22%3A%222%22%2C%22trysign%22%3A%221%22%2C%22begindate%22%3A%222020-08-18%2B00%253A00%253A00.000%22%2C%22username%22%3Anull%2C%22usermob%22%3Anull%2C%22opuser%22%3Anull%2C%22useday%22%3A%22365%22%2C%22ROW_NUMBER%22%3A%221%22%7D; monitor_count=6', ) [ info ] [ PARAM ] array ( ) [ info ] [ DB ] INIT sqlsrv [ info ] [ RUN ] app\h5app\controller\Index->home[ D:\phpStudy\PHPTutorial\WWW\jxc_app\application\h5app\controller\Index.php ] [ info ] [ VIEW ] D:\phpStudy\PHPTutorial\WWW\jxc_app\public/../application/h5app\view\Index\home.html [ array ( 0 => 'index_url', 1 => 'cg_num', 2 => 'xs_num', ) ] [ info ] [ LOG ] INIT File [ sql ] [ DB ] CONNECT:[ UseTime:0.023437s ] sqlsrv:Database=sqljxc689;Server=127.0.0.1,1433 [ sql ] [ 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 = 'T_Bill' [ RunTime:0.002930s ] [ sql ] [ SQL ] SELECT column_name FROM information_schema.key_column_usage WHERE table_name='T_Bill' [ RunTime:0.002930s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT COUNT(ID) AS tp_count FROM [T_Bill] WHERE [BillType] = '采购收货' AND [AddDate] = '2021-01-08') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.000977s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT COUNT(ID) AS tp_count FROM [T_Bill] WHERE [BillType] = '销售出货' AND [AddDate] = '2021-01-08') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.000977s ] --------------------------------------------------------------- [ 2021-01-08T08:27:23+08:00 ] 58.51.237.72 GET 103.45.248.127:31/h5app/index/home.html [运行时间：0.068360s] [吞吐率：14.63req/s] [内存消耗：2,556.60kb] [文件加载：55] [ info ] [ LANG ] D:\phpStudy\PHPTutorial\WWW\jxc_app\thinkphp\lang\zh-cn.php [ info ] [ ROUTE ] array ( 'type' => 'module', 'module' => array ( 0 => 'h5app', 1 => 'index', 2 => 'home', ), ) [ info ] [ HEADER ] array ( 'host' => '103.45.248.127:31', 'connection' => 'keep-alive', 'upgrade-insecure-requests' => '1', 'user-agent' => 'Mozilla/5.0 (Linux; Android 5.0; SM-G900P Build/LRX21T) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/78.0.3904.108 Mobile Safari/537.36', 'accept' => 'text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3', 'referer' => 'http://103.45.248.127:31/h5app/index/index.html', 'accept-encoding' => 'gzip, deflate', 'accept-language' => 'zh-CN,zh;q=0.9', 'cookie' => '__guid=168097185.357580965953092600.1609978174543.8318; mydb=sqljxc689; remember=1; userid=6E8991F2BB728422583338CCE773B159; username=admin; admin=think%3A%7B%22ID%22%3A%221%22%2C%22userdb%22%3A%22sqljxc689%22%2C%22userid%22%3A%226E8991F2BB728422583338CCE773B159%22%2C%22usernumber%22%3A%222%22%2C%22trysign%22%3A%221%22%2C%22begindate%22%3A%222020-08-18%2B00%253A00%253A00.000%22%2C%22username%22%3Anull%2C%22usermob%22%3Anull%2C%22opuser%22%3Anull%2C%22useday%22%3A%22365%22%2C%22ROW_NUMBER%22%3A%221%22%7D; monitor_count=6', ) [ info ] [ PARAM ] array ( ) [ info ] [ DB ] INIT sqlsrv [ info ] [ RUN ] app\h5app\controller\Index->home[ D:\phpStudy\PHPTutorial\WWW\jxc_app\application\h5app\controller\Index.php ] [ info ] [ VIEW ] D:\phpStudy\PHPTutorial\WWW\jxc_app\public/../application/h5app\view\Index\home.html [ array ( 0 => 'index_url', 1 => 'cg_num', 2 => 'xs_num', ) ] [ info ] [ LOG ] INIT File [ sql ] [ DB ] CONNECT:[ UseTime:0.000000s ] sqlsrv:Database=sqljxc689;Server=127.0.0.1,1433 [ sql ] [ 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 = 'T_Bill' [ RunTime:0.001953s ] [ sql ] [ SQL ] SELECT column_name FROM information_schema.key_column_usage WHERE table_name='T_Bill' [ RunTime:0.000977s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT COUNT(ID) AS tp_count FROM [T_Bill] WHERE [BillType] = '采购收货' AND [AddDate] = '2021-01-08') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.000000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT COUNT(ID) AS tp_count FROM [T_Bill] WHERE [BillType] = '销售出货' AND [AddDate] = '2021-01-08') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.000977s ]