--------------------------------------------------------------- [ 2026-10-07T00:02:20+08:00 ] 110.80.135.11 GET / [ info ] www.clcoa.com/ [运行时间：0.029474s][吞吐率：33.93req/s] [内存消耗：3,332.71kb] [文件加载：69] [ info ] [ BEHAVIOR ] Run Closure @app_init [ RunTime:0.000042s ] [ info ] [ CACHE ] INIT File [ info ] [ BEHAVIOR ] Run Closure @app_init [ RunTime:0.001237s ] [ info ] [ LANG ] /alidata/www/gendan/thinkphp/lang/zh-cn.php [ info ] [ ROUTE ] array ( 'type' => 'module', 'module' => array ( 0 => '', 1 => NULL, 2 => NULL, ), ) [ info ] [ HEADER ] array ( 'host' => 'www.clcoa.com', 'x-real-ip' => '110.80.135.11', 'x-forwarded-for' => '110.80.135.11', 'x-forwarded-proto' => 'http', 'connection' => 'close', ) [ info ] [ PARAM ] array ( ) [ info ] [ LANG ] /alidata/www/gendan/public/../application/admin/lang/zh-cn.php [ info ] [ BEHAVIOR ] Run app\common\behavior\Common @module_init [ RunTime:0.001623s ] [ info ] [ SESSION ] INIT array ( 'id' => '', 'var_session_id' => '', 'prefix' => 'think', 'type' => '', 'auto_start' => true, 'expire' => 2592000, ) [ info ] [ VIEW ] /alidata/www/gendan/public/../application/common/view/tpl/dispatch_jump.tpl [ array ( 0 => 'code', 1 => 'msg', 2 => 'data', 3 => 'url', 4 => 'wait', ) ] [ info ] [ BEHAVIOR ] Run app\admin\behavior\AdminLog @app_end [ RunTime:0.000115s ] [ info ] [ LOG ] INIT File --------------------------------------------------------------- [ 2026-10-07T00:10:53+08:00 ] 121.28.82.38 GET / [ info ] www.clcoa.com/ [运行时间：0.027244s][吞吐率：36.71req/s] [内存消耗：3,333.45kb] [文件加载：69] [ info ] [ BEHAVIOR ] Run Closure @app_init [ RunTime:0.000038s ] [ info ] [ CACHE ] INIT File [ info ] [ BEHAVIOR ] Run Closure @app_init [ RunTime:0.001109s ] [ info ] [ LANG ] /alidata/www/gendan/thinkphp/lang/zh-cn.php [ info ] [ ROUTE ] array ( 'type' => 'module', 'module' => array ( 0 => '', 1 => NULL, 2 => NULL, ), ) [ info ] [ HEADER ] array ( 'accept' => 'text/html,application/xhtml+xml,text/plain;q=0.9,*/*;q=0.5', 'accept-language' => 'zh-CN,zh;q=0.9,en;q=0.5', 'user-agent' => 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 Chrome/134.0.0.0 Safari/537.36', 'accept-encoding' => 'gzip, deflate', 'host' => 'www.clcoa.com', ) [ info ] [ PARAM ] array ( ) [ info ] [ LANG ] /alidata/www/gendan/public/../application/admin/lang/zh-cn.php [ info ] [ BEHAVIOR ] Run app\common\behavior\Common @module_init [ RunTime:0.001556s ] [ info ] [ SESSION ] INIT array ( 'id' => '', 'var_session_id' => '', 'prefix' => 'think', 'type' => '', 'auto_start' => true, 'expire' => 2592000, ) [ info ] [ VIEW ] /alidata/www/gendan/public/../application/common/view/tpl/dispatch_jump.tpl [ array ( 0 => 'code', 1 => 'msg', 2 => 'data', 3 => 'url', 4 => 'wait', ) ] [ info ] [ BEHAVIOR ] Run app\admin\behavior\AdminLog @app_end [ RunTime:0.000105s ] [ info ] [ LOG ] INIT File --------------------------------------------------------------- [ 2026-10-07T00:20:37+08:00 ] 45.55.42.181 GET / [ info ] 47.105.33.115:8080/ [运行时间：0.031183s][吞吐率：32.07req/s] [内存消耗：3,332.71kb] [文件加载：69] [ info ] [ BEHAVIOR ] Run Closure @app_init [ RunTime:0.000042s ] [ info ] [ CACHE ] INIT File [ info ] [ BEHAVIOR ] Run Closure @app_init [ RunTime:0.001265s ] [ info ] [ LANG ] /alidata/www/gendan/thinkphp/lang/zh-cn.php [ info ] [ ROUTE ] array ( 'type' => 'module', 'module' => array ( 0 => '', 1 => NULL, 2 => NULL, ), ) [ info ] [ HEADER ] array ( 'host' => '47.105.33.115:8080', 'user-agent' => 'Mozilla/5.0 zgrab/0.x', 'accept' => '*/*', 'accept-encoding' => 'gzip', ) [ info ] [ PARAM ] array ( ) [ info ] [ LANG ] /alidata/www/gendan/public/../application/admin/lang/zh-cn.php [ info ] [ BEHAVIOR ] Run app\common\behavior\Common @module_init [ RunTime:0.001660s ] [ info ] [ SESSION ] INIT array ( 'id' => '', 'var_session_id' => '', 'prefix' => 'think', 'type' => '', 'auto_start' => true, 'expire' => 2592000, ) [ info ] [ VIEW ] /alidata/www/gendan/public/../application/common/view/tpl/dispatch_jump.tpl [ array ( 0 => 'code', 1 => 'msg', 2 => 'data', 3 => 'url', 4 => 'wait', ) ] [ info ] [ BEHAVIOR ] Run app\admin\behavior\AdminLog @app_end [ RunTime:0.000107s ] [ info ] [ LOG ] INIT File --------------------------------------------------------------- [ 2026-10-07T00:20:50+08:00 ] 45.198.224.123 GET / [ info ] 47.105.33.115/ [运行时间：0.027970s][吞吐率：35.75req/s] [内存消耗：3,293.24kb] [文件加载：67] [ info ] [ BEHAVIOR ] Run Closure @app_init [ RunTime:0.000037s ] [ info ] [ CACHE ] INIT File [ info ] [ BEHAVIOR ] Run Closure @app_init [ RunTime:0.001146s ] [ info ] [ ROUTE ] array ( 'type' => 'module', 'module' => array ( 0 => '', 1 => NULL, 2 => NULL, ), ) [ info ] [ HEADER ] array ( 'host' => '47.105.33.115', 'x-real-ip' => '45.198.224.123', 'x-forwarded-for' => '45.198.224.123', 'x-forwarded-proto' => 'http', 'connection' => 'close', 'user-agent' => 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/90.0.4430.85 Safari/537.36 Edg/90.0.818.46', 'accept-encoding' => 'gzip, deflate, gzip, deflate', 'accept' => '*/*', 'x-requested-with' => 'XMLHttpRequest', 'content-type' => 'application/x-www-form-urlencoded; charset=UTF-8', 'accept-language' => 'en US,en;q=0.9,sv;q=0.8', ) [ info ] [ PARAM ] array ( ) [ info ] [ BEHAVIOR ] Run app\common\behavior\Common @module_init [ RunTime:0.001592s ] [ info ] [ SESSION ] INIT array ( 'id' => '', 'var_session_id' => '', 'prefix' => 'think', 'type' => '', 'auto_start' => true, 'expire' => 2592000, ) [ info ] [ BEHAVIOR ] Run app\admin\behavior\AdminLog @app_end [ RunTime:0.000097s ] [ info ] [ LOG ] INIT File --------------------------------------------------------------- [ 2026-10-07T00:25:43+08:00 ] 89.21.67.148 GET / [ info ] 192.0.2.1/ [运行时间：0.029514s][吞吐率：33.88req/s] [内存消耗：3,333.63kb] [文件加载：69] [ info ] [ BEHAVIOR ] Run Closure @app_init [ RunTime:0.000040s ] [ info ] [ CACHE ] INIT File [ info ] [ BEHAVIOR ] Run Closure @app_init [ RunTime:0.001194s ] [ info ] [ LANG ] /alidata/www/gendan/thinkphp/lang/zh-cn.php [ info ] [ ROUTE ] array ( 'type' => 'module', 'module' => array ( 0 => '', 1 => NULL, 2 => NULL, ), ) [ info ] [ HEADER ] array ( 'host' => '192.0.2.1', 'x-real-ip' => '89.21.67.148', 'x-forwarded-for' => '89.21.67.148', 'x-forwarded-proto' => 'http', 'connection' => 'close', 'user-agent' => 'Mozilla/5.0', 'accept' => '*/*', ) [ info ] [ PARAM ] array ( ) [ info ] [ LANG ] /alidata/www/gendan/public/../application/admin/lang/zh-cn.php [ info ] [ BEHAVIOR ] Run app\common\behavior\Common @module_init [ RunTime:0.001608s ] [ info ] [ SESSION ] INIT array ( 'id' => '', 'var_session_id' => '', 'prefix' => 'think', 'type' => '', 'auto_start' => true, 'expire' => 2592000, ) [ info ] [ VIEW ] /alidata/www/gendan/public/../application/common/view/tpl/dispatch_jump.tpl [ array ( 0 => 'code', 1 => 'msg', 2 => 'data', 3 => 'url', 4 => 'wait', ) ] [ info ] [ BEHAVIOR ] Run app\admin\behavior\AdminLog @app_end [ RunTime:0.000111s ] [ info ] [ LOG ] INIT File --------------------------------------------------------------- [ 2026-10-07T00:25:50+08:00 ] 193.176.31.155 GET / [ info ] 47.105.33.115/ [运行时间：0.026807s][吞吐率：37.30req/s] [内存消耗：3,333.94kb] [文件加载：69] [ info ] [ BEHAVIOR ] Run Closure @app_init [ RunTime:0.000036s ] [ info ] [ CACHE ] INIT File [ info ] [ BEHAVIOR ] Run Closure @app_init [ RunTime:0.001102s ] [ info ] [ LANG ] /alidata/www/gendan/thinkphp/lang/zh-cn.php [ info ] [ ROUTE ] array ( 'type' => 'module', 'module' => array ( 0 => '', 1 => NULL, 2 => NULL, ), ) [ info ] [ HEADER ] array ( 'host' => '47.105.33.115', 'x-real-ip' => '193.176.31.155', 'x-forwarded-for' => '193.176.31.155', 'x-forwarded-proto' => 'http', 'connection' => 'close', 'user-agent' => 'Mozilla/5.0', 'accept' => '*/*', 'accept-encoding' => 'gzip', ) [ info ] [ PARAM ] array ( ) [ info ] [ LANG ] /alidata/www/gendan/public/../application/admin/lang/zh-cn.php [ info ] [ BEHAVIOR ] Run app\common\behavior\Common @module_init [ RunTime:0.001468s ] [ info ] [ SESSION ] INIT array ( 'id' => '', 'var_session_id' => '', 'prefix' => 'think', 'type' => '', 'auto_start' => true, 'expire' => 2592000, ) [ info ] [ VIEW ] /alidata/www/gendan/public/../application/common/view/tpl/dispatch_jump.tpl [ array ( 0 => 'code', 1 => 'msg', 2 => 'data', 3 => 'url', 4 => 'wait', ) ] [ info ] [ BEHAVIOR ] Run app\admin\behavior\AdminLog @app_end [ RunTime:0.000095s ] [ info ] [ LOG ] INIT File --------------------------------------------------------------- [ 2026-10-07T00:25:51+08:00 ] 193.176.31.212 GET /favicon.ico [ info ] 47.105.33.115/favicon.ico [运行时间：0.019241s][吞吐率：51.97req/s] [内存消耗：2,226.94kb] [文件加载：51] [ info ] [ BEHAVIOR ] Run Closure @app_init [ RunTime:0.000038s ] [ info ] [ CACHE ] INIT File [ info ] [ BEHAVIOR ] Run Closure @app_init [ RunTime:0.001106s ] [ info ] [ LANG ] /alidata/www/gendan/thinkphp/lang/zh-cn.php [ info ] [ ROUTE ] array ( 'type' => 'module', 'module' => array ( 0 => 'favicon.ico', 1 => NULL, 2 => NULL, ), ) [ info ] [ HEADER ] array ( 'host' => '47.105.33.115', 'x-real-ip' => '193.176.31.212', 'x-forwarded-for' => '193.176.31.212', 'x-forwarded-proto' => 'http', 'connection' => 'close', 'user-agent' => 'Mozilla/5.0', 'accept' => '*/*', 'accept-encoding' => 'gzip', ) [ info ] [ PARAM ] array ( ) [ info ] [ LOG ] INIT File --------------------------------------------------------------- [ 2026-10-07T00:25:51+08:00 ] 185.223.235.34 GET /mcp/ [ info ] 47.105.33.115/mcp/ [运行时间：0.019166s][吞吐率：52.18req/s] [内存消耗：2,227.23kb] [文件加载：51] [ info ] [ BEHAVIOR ] Run Closure @app_init [ RunTime:0.000039s ] [ info ] [ CACHE ] INIT File [ info ] [ BEHAVIOR ] Run Closure @app_init [ RunTime:0.001113s ] [ info ] [ LANG ] /alidata/www/gendan/thinkphp/lang/zh-cn.php [ info ] [ ROUTE ] array ( 'type' => 'module', 'module' => array ( 0 => 'mcp', 1 => NULL, 2 => NULL, ), ) [ info ] [ HEADER ] array ( 'host' => '47.105.33.115', 'x-real-ip' => '185.223.235.34', 'x-forwarded-for' => '185.223.235.34', 'x-forwarded-proto' => 'http', 'connection' => 'close', 'user-agent' => 'Mozilla/5.0', 'accept' => 'application/json', 'accept-encoding' => 'gzip', ) [ info ] [ PARAM ] array ( ) [ info ] [ LOG ] INIT File --------------------------------------------------------------- [ 2026-10-07T00:25:51+08:00 ] 89.21.67.182 GET /api/mcp [ info ] 47.105.33.115/api/mcp [运行时间：0.022883s][吞吐率：43.70req/s] [内存消耗：2,497.55kb] [文件加载：58] [ info ] [ BEHAVIOR ] Run Closure @app_init [ RunTime:0.000038s ] [ info ] [ CACHE ] INIT File [ info ] [ BEHAVIOR ] Run Closure @app_init [ RunTime:0.001159s ] [ info ] [ LANG ] /alidata/www/gendan/thinkphp/lang/zh-cn.php [ info ] [ ROUTE ] array ( 'type' => 'module', 'module' => array ( 0 => 'api', 1 => 'mcp', 2 => NULL, ), ) [ info ] [ HEADER ] array ( 'host' => '47.105.33.115', 'x-real-ip' => '89.21.67.182', 'x-forwarded-for' => '89.21.67.182', 'x-forwarded-proto' => 'http', 'connection' => 'close', 'user-agent' => 'Mozilla/5.0', 'accept' => 'application/json', 'accept-encoding' => 'gzip', ) [ info ] [ PARAM ] array ( ) [ info ] [ LANG ] /alidata/www/gendan/public/../application/api/lang/zh-cn.php [ info ] [ BEHAVIOR ] Run app\common\behavior\Common @module_init [ RunTime:0.001547s ] [ info ] [ LOG ] INIT File --------------------------------------------------------------- [ 2026-10-07T00:25:51+08:00 ] 193.176.31.253 GET / [ info ] 47.105.33.115/ [运行时间：0.029965s][吞吐率：33.37req/s] [内存消耗：3,333.82kb] [文件加载：69] [ info ] [ BEHAVIOR ] Run Closure @app_init [ RunTime:0.000030s ] [ info ] [ CACHE ] INIT File [ info ] [ BEHAVIOR ] Run Closure @app_init [ RunTime:0.001154s ] [ info ] [ LANG ] /alidata/www/gendan/thinkphp/lang/zh-cn.php [ info ] [ ROUTE ] array ( 'type' => 'module', 'module' => array ( 0 => '', 1 => NULL, 2 => NULL, ), ) [ info ] [ HEADER ] array ( 'host' => '47.105.33.115', 'x-real-ip' => '193.176.31.253', 'x-forwarded-for' => '193.176.31.253', 'x-forwarded-proto' => 'http', 'connection' => 'close', 'user-agent' => 'Mozilla/5.0', 'accept' => 'application/json', 'accept-encoding' => 'gzip', ) [ info ] [ PARAM ] array ( ) [ info ] [ LANG ] /alidata/www/gendan/public/../application/admin/lang/zh-cn.php [ info ] [ BEHAVIOR ] Run app\common\behavior\Common @module_init [ RunTime:0.001574s ] [ info ] [ SESSION ] INIT array ( 'id' => '', 'var_session_id' => '', 'prefix' => 'think', 'type' => '', 'auto_start' => true, 'expire' => 2592000, ) [ info ] [ VIEW ] /alidata/www/gendan/public/../application/common/view/tpl/dispatch_jump.tpl [ array ( 0 => 'code', 1 => 'msg', 2 => 'data', 3 => 'url', 4 => 'wait', ) ] [ info ] [ BEHAVIOR ] Run app\admin\behavior\AdminLog @app_end [ RunTime:0.000123s ] [ info ] [ LOG ] INIT File --------------------------------------------------------------- [ 2026-10-07T00:25:52+08:00 ] 193.176.31.245 GET /mcp [ info ] 47.105.33.115/mcp [运行时间：0.020189s][吞吐率：49.53req/s] [内存消耗：2,227.23kb] [文件加载：51] [ info ] [ BEHAVIOR ] Run Closure @app_init [ RunTime:0.000038s ] [ info ] [ CACHE ] INIT File [ info ] [ BEHAVIOR ] Run Closure @app_init [ RunTime:0.001147s ] [ info ] [ LANG ] /alidata/www/gendan/thinkphp/lang/zh-cn.php [ info ] [ ROUTE ] array ( 'type' => 'module', 'module' => array ( 0 => 'mcp', 1 => NULL, 2 => NULL, ), ) [ info ] [ HEADER ] array ( 'host' => '47.105.33.115', 'x-real-ip' => '193.176.31.245', 'x-forwarded-for' => '193.176.31.245', 'x-forwarded-proto' => 'http', 'connection' => 'close', 'user-agent' => 'Mozilla/5.0', 'accept' => 'application/json', 'accept-encoding' => 'gzip', ) [ info ] [ PARAM ] array ( ) [ info ] [ LOG ] INIT File --------------------------------------------------------------- [ 2026-10-07T00:25:53+08:00 ] 81.19.216.74 GET /sse [ info ] 47.105.33.115/sse [运行时间：0.019612s][吞吐率：50.99req/s] [内存消耗：2,227.21kb] [文件加载：51] [ info ] [ BEHAVIOR ] Run Closure @app_init [ RunTime:0.000037s ] [ info ] [ CACHE ] INIT File [ info ] [ BEHAVIOR ] Run Closure @app_init [ RunTime:0.001166s ] [ info ] [ LANG ] /alidata/www/gendan/thinkphp/lang/zh-cn.php [ info ] [ ROUTE ] array ( 'type' => 'module', 'module' => array ( 0 => 'sse', 1 => NULL, 2 => NULL, ), ) [ info ] [ HEADER ] array ( 'host' => '47.105.33.115', 'x-real-ip' => '81.19.216.74', 'x-forwarded-for' => '81.19.216.74', 'x-forwarded-proto' => 'http', 'connection' => 'close', 'user-agent' => 'Mozilla/5.0', 'accept' => 'text/event-stream', 'accept-encoding' => 'gzip', ) [ info ] [ PARAM ] array ( ) [ info ] [ LOG ] INIT File --------------------------------------------------------------- [ 2026-10-07T00:30:39+08:00 ] 121.29.51.109 GET / [ info ] www.clcoa.com/ [运行时间：0.028032s][吞吐率：35.67req/s] [内存消耗：3,334.41kb] [文件加载：69] [ info ] [ BEHAVIOR ] Run Closure @app_init [ RunTime:0.000042s ] [ info ] [ CACHE ] INIT File [ info ] [ BEHAVIOR ] Run Closure @app_init [ RunTime:0.001137s ] [ info ] [ LANG ] /alidata/www/gendan/thinkphp/lang/zh-cn.php [ info ] [ ROUTE ] array ( 'type' => 'module', 'module' => array ( 0 => '', 1 => NULL, 2 => NULL, ), ) [ info ] [ HEADER ] array ( 'host' => 'www.clcoa.com', 'user-agent' => 'Dalvik/2.1.0 (Linux; U; Android 9.0; ZTE BA520 Build/MRA58K)', 'accept-encoding' => 'gzip, deflate', 'accept' => 'text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.9', 'connection' => 'keep-alive', 'cache-control' => 'no-cache', 'accept-language' => 'zh-CN,zh;q=0.9', ) [ info ] [ PARAM ] array ( ) [ info ] [ LANG ] /alidata/www/gendan/public/../application/admin/lang/zh-cn.php [ info ] [ BEHAVIOR ] Run app\common\behavior\Common @module_init [ RunTime:0.001497s ] [ info ] [ SESSION ] INIT array ( 'id' => '', 'var_session_id' => '', 'prefix' => 'think', 'type' => '', 'auto_start' => true, 'expire' => 2592000, ) [ info ] [ VIEW ] /alidata/www/gendan/public/../application/common/view/tpl/dispatch_jump.tpl [ array ( 0 => 'code', 1 => 'msg', 2 => 'data', 3 => 'url', 4 => 'wait', ) ] [ info ] [ BEHAVIOR ] Run app\admin\behavior\AdminLog @app_end [ RunTime:0.000100s ] [ info ] [ LOG ] INIT File --------------------------------------------------------------- [ 2026-10-07T00:34:15+08:00 ] 121.29.51.109 GET / [ info ] www.clcoa.com/ [运行时间：0.027520s][吞吐率：36.34req/s] [内存消耗：3,335.09kb] [文件加载：69] [ info ] [ BEHAVIOR ] Run Closure @app_init [ RunTime:0.000046s ] [ info ] [ CACHE ] INIT File [ info ] [ BEHAVIOR ] Run Closure @app_init [ RunTime:0.001091s ] [ info ] [ LANG ] /alidata/www/gendan/thinkphp/lang/zh-cn.php [ info ] [ ROUTE ] array ( 'type' => 'module', 'module' => array ( 0 => '', 1 => NULL, 2 => NULL, ), ) [ info ] [ HEADER ] array ( 'host' => 'www.clcoa.com', 'x-real-ip' => '121.29.51.109', 'x-forwarded-for' => '121.29.51.109', 'x-forwarded-proto' => 'http', 'connection' => 'close', 'user-agent' => 'Dalvik/2.1.0 (Linux; U; Android 9.0; ZTE BA520 Build/MRA58K)', 'accept-encoding' => 'gzip, deflate', 'accept' => 'text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.9', 'cache-control' => 'no-cache', 'accept-language' => 'zh-CN,zh;q=0.9', ) [ info ] [ PARAM ] array ( ) [ info ] [ LANG ] /alidata/www/gendan/public/../application/admin/lang/zh-cn.php [ info ] [ BEHAVIOR ] Run app\common\behavior\Common @module_init [ RunTime:0.001482s ] [ info ] [ SESSION ] INIT array ( 'id' => '', 'var_session_id' => '', 'prefix' => 'think', 'type' => '', 'auto_start' => true, 'expire' => 2592000, ) [ info ] [ VIEW ] /alidata/www/gendan/public/../application/common/view/tpl/dispatch_jump.tpl [ array ( 0 => 'code', 1 => 'msg', 2 => 'data', 3 => 'url', 4 => 'wait', ) ] [ info ] [ BEHAVIOR ] Run app\admin\behavior\AdminLog @app_end [ RunTime:0.000094s ] [ info ] [ LOG ] INIT File --------------------------------------------------------------- [ 2026-10-07T00:34:18+08:00 ] 151.245.151.28 GET / [ info ] 47.105.33.115:8080/ [运行时间：0.028931s][吞吐率：34.56req/s] [内存消耗：3,284.64kb] [文件加载：67] [ info ] [ BEHAVIOR ] Run Closure @app_init [ RunTime:0.000041s ] [ info ] [ CACHE ] INIT File [ info ] [ BEHAVIOR ] Run Closure @app_init [ RunTime:0.001143s ] [ info ] [ ROUTE ] array ( 'type' => 'module', 'module' => array ( 0 => '', 1 => NULL, 2 => NULL, ), ) [ info ] [ HEADER ] array ( 'host' => '47.105.33.115:8080', 'user-agent' => 'Mozilla/5.0 (compatible; ForestEngine/1.0; +https://forestengine.net/)', 'accept' => 'text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,*/*;q=0.8', 'accept-language' => 'en-US,en;q=0.9', 'accept-encoding' => 'gzip', 'connection' => 'keep-alive', ) [ info ] [ PARAM ] array ( ) [ info ] [ BEHAVIOR ] Run app\common\behavior\Common @module_init [ RunTime:0.001620s ] [ info ] [ SESSION ] INIT array ( 'id' => '', 'var_session_id' => '', 'prefix' => 'think', 'type' => '', 'auto_start' => true, 'expire' => 2592000, ) [ info ] [ VIEW ] /alidata/www/gendan/public/../application/common/view/tpl/dispatch_jump.tpl [ array ( 0 => 'code', 1 => 'msg', 2 => 'data', 3 => 'url', 4 => 'wait', ) ] [ info ] [ BEHAVIOR ] Run app\admin\behavior\AdminLog @app_end [ RunTime:0.000128s ] [ info ] [ LOG ] INIT File --------------------------------------------------------------- [ 2026-10-07T00:37:56+08:00 ] 3.208.27.95 GET / [ info ] 47.105.33.115/ [运行时间：0.026832s][吞吐率：37.27req/s] [内存消耗：3,334.02kb] [文件加载：69] [ info ] [ BEHAVIOR ] Run Closure @app_init [ RunTime:0.000035s ] [ info ] [ CACHE ] INIT File [ info ] [ BEHAVIOR ] Run Closure @app_init [ RunTime:0.001128s ] [ info ] [ LANG ] /alidata/www/gendan/thinkphp/lang/zh-cn.php [ info ] [ ROUTE ] array ( 'type' => 'module', 'module' => array ( 0 => '', 1 => NULL, 2 => NULL, ), ) [ info ] [ HEADER ] array ( 'host' => '47.105.33.115', 'x-real-ip' => '3.208.27.95', 'x-forwarded-for' => '3.208.27.95', 'x-forwarded-proto' => 'http', 'connection' => 'close', 'user-agent' => 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/136.0.0.0 Safari/537.36', 'accept' => '*/*', 'accept-encoding' => 'gzip', ) [ info ] [ PARAM ] array ( ) [ info ] [ LANG ] /alidata/www/gendan/public/../application/admin/lang/zh-cn.php [ info ] [ BEHAVIOR ] Run app\common\behavior\Common @module_init [ RunTime:0.001510s ] [ info ] [ SESSION ] INIT array ( 'id' => '', 'var_session_id' => '', 'prefix' => 'think', 'type' => '', 'auto_start' => true, 'expire' => 2592000, ) [ info ] [ VIEW ] /alidata/www/gendan/public/../application/common/view/tpl/dispatch_jump.tpl [ array ( 0 => 'code', 1 => 'msg', 2 => 'data', 3 => 'url', 4 => 'wait', ) ] [ info ] [ BEHAVIOR ] Run app\admin\behavior\AdminLog @app_end [ RunTime:0.000105s ] [ info ] [ LOG ] INIT File --------------------------------------------------------------- [ 2026-10-07T00:37:56+08:00 ] 13.219.99.134 GET / [ info ] 47.105.33.115:8080/ [运行时间：0.046918s][吞吐率：21.31req/s] [内存消耗：3,333.05kb] [文件加载：69] [ info ] [ BEHAVIOR ] Run Closure @app_init [ RunTime:0.000070s ] [ info ] [ CACHE ] INIT File [ info ] [ BEHAVIOR ] Run Closure @app_init [ RunTime:0.001940s ] [ info ] [ LANG ] /alidata/www/gendan/thinkphp/lang/zh-cn.php [ info ] [ ROUTE ] array ( 'type' => 'module', 'module' => array ( 0 => '', 1 => NULL, 2 => NULL, ), ) [ info ] [ HEADER ] array ( 'host' => '47.105.33.115:8080', 'user-agent' => 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/136.0.0.0 Safari/537.36', 'accept' => '*/*', 'accept-encoding' => 'gzip', ) [ info ] [ PARAM ] array ( ) [ info ] [ LANG ] /alidata/www/gendan/public/../application/admin/lang/zh-cn.php [ info ] [ BEHAVIOR ] Run app\common\behavior\Common @module_init [ RunTime:0.002630s ] [ info ] [ SESSION ] INIT array ( 'id' => '', 'var_session_id' => '', 'prefix' => 'think', 'type' => '', 'auto_start' => true, 'expire' => 2592000, ) [ info ] [ VIEW ] /alidata/www/gendan/public/../application/common/view/tpl/dispatch_jump.tpl [ array ( 0 => 'code', 1 => 'msg', 2 => 'data', 3 => 'url', 4 => 'wait', ) ] [ info ] [ BEHAVIOR ] Run app\admin\behavior\AdminLog @app_end [ RunTime:0.000159s ] [ info ] [ LOG ] INIT File --------------------------------------------------------------- [ 2026-10-07T00:44:13+08:00 ] 45.198.224.123 GET / [ info ] 47.105.33.115/ [运行时间：0.027794s][吞吐率：35.98req/s] [内存消耗：3,293.24kb] [文件加载：67] [ info ] [ BEHAVIOR ] Run Closure @app_init [ RunTime:0.000040s ] [ info ] [ CACHE ] INIT File [ info ] [ BEHAVIOR ] Run Closure @app_init [ RunTime:0.001127s ] [ info ] [ ROUTE ] array ( 'type' => 'module', 'module' => array ( 0 => '', 1 => NULL, 2 => NULL, ), ) [ info ] [ HEADER ] array ( 'host' => '47.105.33.115', 'x-real-ip' => '45.198.224.123', 'x-forwarded-for' => '45.198.224.123', 'x-forwarded-proto' => 'http', 'connection' => 'close', 'user-agent' => 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/90.0.4430.85 Safari/537.36 Edg/90.0.818.46', 'accept-encoding' => 'gzip, deflate, gzip, deflate', 'accept' => '*/*', 'x-requested-with' => 'XMLHttpRequest', 'content-type' => 'application/x-www-form-urlencoded; charset=UTF-8', 'accept-language' => 'en US,en;q=0.9,sv;q=0.8', ) [ info ] [ PARAM ] array ( ) [ info ] [ BEHAVIOR ] Run app\common\behavior\Common @module_init [ RunTime:0.001522s ] [ info ] [ SESSION ] INIT array ( 'id' => '', 'var_session_id' => '', 'prefix' => 'think', 'type' => '', 'auto_start' => true, 'expire' => 2592000, ) [ info ] [ BEHAVIOR ] Run app\admin\behavior\AdminLog @app_end [ RunTime:0.000101s ] [ info ] [ LOG ] INIT File --------------------------------------------------------------- [ 2026-10-07T00:50:44+08:00 ] 40.80.203.142 POST /mcp [ info ] 47.105.33.115/mcp [运行时间：0.020065s][吞吐率：49.84req/s] [内存消耗：2,232.59kb] [文件加载：51] [ info ] [ BEHAVIOR ] Run Closure @app_init [ RunTime:0.000052s ] [ info ] [ CACHE ] INIT File [ info ] [ BEHAVIOR ] Run Closure @app_init [ RunTime:0.001172s ] [ info ] [ LANG ] /alidata/www/gendan/thinkphp/lang/zh-cn.php [ info ] [ ROUTE ] array ( 'type' => 'module', 'module' => array ( 0 => 'mcp', 1 => NULL, 2 => NULL, ), ) [ info ] [ HEADER ] array ( 'host' => '47.105.33.115', 'user-agent' => 'Mozilla/5.0 zgrab/0.x', 'content-length' => '168', 'accept' => 'application/json, text/event-stream', 'content-type' => 'application/json', 'accept-encoding' => 'gzip', ) [ info ] [ PARAM ] array ( 'jsonrpc' => '2.0', 'id' => 1, 'method' => 'initialize', 'params' => array ( 'protocolVersion' => '2025-03-26', 'capabilities' => array ( ), 'clientInfo' => array ( 'name' => 'mcp-fingerprint-probe', 'version' => '1.0', ), ), ) [ info ] [ LOG ] INIT File --------------------------------------------------------------- [ 2026-10-07T00:57:01+08:00 ] 94.231.206.104 GET / [ info ] 47.105.33.115/ [运行时间：0.028427s][吞吐率：35.18req/s] [内存消耗：3,334.05kb] [文件加载：69] [ info ] [ BEHAVIOR ] Run Closure @app_init [ RunTime:0.000038s ] [ info ] [ CACHE ] INIT File [ info ] [ BEHAVIOR ] Run Closure @app_init [ RunTime:0.001139s ] [ info ] [ LANG ] /alidata/www/gendan/thinkphp/lang/zh-cn.php [ info ] [ ROUTE ] array ( 'type' => 'module', 'module' => array ( 0 => '', 1 => NULL, 2 => NULL, ), ) [ info ] [ HEADER ] array ( 'host' => '47.105.33.115', 'connection' => 'close', 'user-agent' => 'Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:134.0) Gecko/20100101 Firefox/134.0', 'accept' => 'text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8', 'accept-charset' => 'GBK,utf-8;q=0.7,*;q=0.3', 'accept-language' => 'zh-CN,zh;q=0.8', ) [ info ] [ PARAM ] array ( ) [ info ] [ LANG ] /alidata/www/gendan/public/../application/admin/lang/zh-cn.php [ info ] [ BEHAVIOR ] Run app\common\behavior\Common @module_init [ RunTime:0.001504s ] [ info ] [ SESSION ] INIT array ( 'id' => '', 'var_session_id' => '', 'prefix' => 'think', 'type' => '', 'auto_start' => true, 'expire' => 2592000, ) [ info ] [ VIEW ] /alidata/www/gendan/public/../application/common/view/tpl/dispatch_jump.tpl [ array ( 0 => 'code', 1 => 'msg', 2 => 'data', 3 => 'url', 4 => 'wait', ) ] [ info ] [ BEHAVIOR ] Run app\admin\behavior\AdminLog @app_end [ RunTime:0.000098s ] [ info ] [ LOG ] INIT File --------------------------------------------------------------- [ 2026-10-07T01:00:07+08:00 ] 47.105.33.115 POST /admin/ordermge/orderinfo/predis [ info ] 47.105.33.115/admin/ordermge/orderinfo/predis [运行时间：5.861020s][吞吐率：0.17req/s] [内存消耗：7,222.06kb] [文件加载：99] [ info ] [ BEHAVIOR ] Run Closure @app_init [ RunTime:0.000038s ] [ info ] [ CACHE ] INIT File [ info ] [ BEHAVIOR ] Run Closure @app_init [ RunTime:0.001104s ] [ info ] [ LANG ] /alidata/www/gendan/thinkphp/lang/zh-cn.php [ info ] [ ROUTE ] array ( 'type' => 'module', 'module' => array ( 0 => 'admin', 1 => 'ordermge.orderinfo', 2 => 'predis', ), ) [ info ] [ HEADER ] array ( 'host' => '47.105.33.115', 'content-type' => 'application/x-www-form-urlencoded', 'content-length' => '0', 'connection' => 'Close', ) [ info ] [ PARAM ] array ( ) [ info ] [ LANG ] /alidata/www/gendan/public/../application/admin/lang/zh-cn.php [ info ] [ BEHAVIOR ] Run app\common\behavior\Common @module_init [ RunTime:0.001486s ] [ info ] [ SESSION ] INIT array ( 'id' => '', 'var_session_id' => '', 'prefix' => 'think', 'type' => '', 'auto_start' => true, 'expire' => 2592000, ) [ info ] [ LANG ] /alidata/www/gendan/public/../application/admin/lang/zh-cn/ordermge/orderinfo.php [ info ] [ DB ] INIT mysql [ info ] [ RUN ] app\admin\controller\ordermge\Orderinfo->predis[ /alidata/www/gendan/application/admin/controller/ordermge/Orderinfo.php ] [ info ] [ LOG ] INIT File [ sql ] [ DB ] CONNECT:[ UseTime:0.000594s ] mysql:host=127.0.0.1;dbname=ordertrackce;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `ot_factorymge` [ RunTime:0.000808s ] [ sql ] [ SQL ] SELECT * FROM `ot_factorymge` [ RunTime:0.000512s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `ot_orderandmaterial` [ RunTime:0.000663s ] [ sql ] [ SQL ] SELECT sum(quantity*price) as total FROM `ot_orderandmaterial` WHERE ( factorymge_id=1 ) AND ( createtime>1791216000 ) AND ( createtime<1791302400 ) LIMIT 1 [ RunTime:0.002089s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `ot_orderinfo` [ RunTime:0.000964s ] [ sql ] [ SQL ] SELECT `id` FROM `ot_orderinfo` WHERE ( factorymge_id=1 ) AND ( produced_time>1791216000 ) AND ( produced_time<1791302400 ) [ RunTime:0.020958s ] [ sql ] [ SQL ] SELECT sum(quantity*price) as total FROM `ot_orderandmaterial` WHERE `orderinfo_id` IN ('') LIMIT 1 [ RunTime:0.002562s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `ot_accountsreceivable` [ RunTime:0.001000s ] [ sql ] [ SQL ] SELECT sum(money) as total FROM `ot_accountsreceivable` WHERE ( factorymge_id=1 ) AND ( createtime>1791216000 ) AND ( createtime<1791302400 ) LIMIT 1 [ RunTime:0.008930s ] [ sql ] [ SQL ] SELECT sum(reced_money) as total FROM `ot_accountsreceivable` WHERE ( factorymge_id=1 ) AND ( createtime>1791216000 ) AND ( createtime<1791302400 ) LIMIT 1 [ RunTime:0.009451s ] [ sql ] [ SQL ] SELECT * FROM `ot_orderinfo` WHERE ( factorymge_id=1 ) AND ( produced_time>1791216000 ) AND ( produced_time<1791302400 ) [ RunTime:0.069223s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `ot_outboundandorder` [ RunTime:0.001057s ] [ sql ] [ SQL ] SELECT sum(money) as total FROM `ot_outboundandorder` WHERE ( factorymge_id=1 ) AND ( createtime>1791216000 ) AND ( createtime<1791302400 ) LIMIT 1 [ RunTime:0.016998s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `ot_putinstorage` [ RunTime:0.001165s ] [ sql ] [ SQL ] SELECT sum(money) as total FROM `ot_putinstorage` WHERE ( factorymge_id=1 ) AND ( createtime>1791216000 ) AND ( createtime<1791302400 ) LIMIT 1 [ RunTime:0.002587s ] [ sql ] [ SQL ] SELECT sum(quantity*price) as total FROM `ot_orderandmaterial` WHERE ( factorymge_id=1 ) AND ( createtime>1791216000 ) AND ( createtime<1791302400 ) LIMIT 1 [ RunTime:0.003385s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `ot_accountspayable` [ RunTime:0.000952s ] [ sql ] [ SQL ] SELECT sum(paid_money) as total FROM `ot_accountspayable` WHERE ( factorymge_id=1 ) AND ( createtime>1791216000 ) AND ( createtime<1791302400 ) LIMIT 1 [ RunTime:0.005490s ] [ sql ] [ SQL ] SELECT sum(money) as total FROM `ot_accountspayable` WHERE ( factorymge_id=1 ) AND ( createtime>1791216000 ) AND ( createtime<1791302400 ) LIMIT 1 [ RunTime:0.005485s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `ot_ladger` [ RunTime:0.001175s ] [ sql ] [ SQL ] SELECT sum(reced_money) as total FROM `ot_ladger` WHERE ( factorymge_id=1 ) AND ( createtime>1791216000 ) AND ( createtime<1791302400 ) LIMIT 1 [ RunTime:0.004819s ] [ sql ] [ SQL ] SELECT sum(payable_money) as total FROM `ot_ladger` WHERE ( factorymge_id=1 ) AND ( createtime>1791216000 ) AND ( createtime<1791302400 ) LIMIT 1 [ RunTime:0.004820s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `ot_zichan` [ RunTime:0.001138s ] [ sql ] [ SQL ] SELECT * FROM `ot_zichan` WHERE `factorymge_id` = 1 AND `year` = 2026 AND `month` = 10 AND `day` = 6 LIMIT 1 [ RunTime:0.017028s ] [ sql ] [ SQL ] INSERT INTO `ot_zichan` (`carmaterialcountpricediffer` , `shoudbeshoucountpricediffer` , `productcountpricediffer` , `lingcountpricediffer` , `shoudbefucountpricediffer` , `xianjindiffer` , `countpricediffer` , `factorymge_id` , `createtime` , `year` , `month` , `day`) VALUES (0 , 0 , 0 , 0 , 0 , 0 , 0 , 1 , 1791306002 , 2026 , 10 , 6) [ RunTime:0.005787s ] [ sql ] [ SQL ] SELECT sum(quantity*price) as total FROM `ot_orderandmaterial` WHERE ( factorymge_id=19 ) AND ( createtime>1791216000 ) AND ( createtime<1791302400 ) LIMIT 1 [ RunTime:0.001855s ] [ sql ] [ SQL ] SELECT `id` FROM `ot_orderinfo` WHERE ( factorymge_id=19 ) AND ( produced_time>1791216000 ) AND ( produced_time<1791302400 ) [ RunTime:0.020681s ] [ sql ] [ SQL ] SELECT sum(quantity*price) as total FROM `ot_orderandmaterial` WHERE `orderinfo_id` IN ('') LIMIT 1 [ RunTime:0.002334s ] [ sql ] [ SQL ] SELECT sum(money) as total FROM `ot_accountsreceivable` WHERE ( factorymge_id=19 ) AND ( createtime>1791216000 ) AND ( createtime<1791302400 ) LIMIT 1 [ RunTime:0.008854s ] [ sql ] [ SQL ] SELECT sum(reced_money) as total FROM `ot_accountsreceivable` WHERE ( factorymge_id=19 ) AND ( createtime>1791216000 ) AND ( createtime<1791302400 ) LIMIT 1 [ RunTime:0.009178s ] [ sql ] [ SQL ] SELECT * FROM `ot_orderinfo` WHERE ( factorymge_id=19 ) AND ( produced_time>1791216000 ) AND ( produced_time<1791302400 ) [ RunTime:0.085370s ] [ sql ] [ SQL ] SELECT sum(money) as total FROM `ot_outboundandorder` WHERE ( factorymge_id=19 ) AND ( createtime>1791216000 ) AND ( createtime<1791302400 ) LIMIT 1 [ RunTime:0.011977s ] [ sql ] [ SQL ] SELECT sum(money) as total FROM `ot_putinstorage` WHERE ( factorymge_id=19 ) AND ( createtime>1791216000 ) AND ( createtime<1791302400 ) LIMIT 1 [ RunTime:0.001964s ] [ sql ] [ SQL ] SELECT sum(quantity*price) as total FROM `ot_orderandmaterial` WHERE ( factorymge_id=19 ) AND ( createtime>1791216000 ) AND ( createtime<1791302400 ) LIMIT 1 [ RunTime:0.002270s ] [ sql ] [ SQL ] SELECT sum(paid_money) as total FROM `ot_accountspayable` WHERE ( factorymge_id=19 ) AND ( createtime>1791216000 ) AND ( createtime<1791302400 ) LIMIT 1 [ RunTime:0.003891s ] [ sql ] [ SQL ] SELECT sum(money) as total FROM `ot_accountspayable` WHERE ( factorymge_id=19 ) AND ( createtime>1791216000 ) AND ( createtime<1791302400 ) LIMIT 1 [ RunTime:0.003382s ] [ sql ] [ SQL ] SELECT sum(reced_money) as total FROM `ot_ladger` WHERE ( factorymge_id=19 ) AND ( createtime>1791216000 ) AND ( createtime<1791302400 ) LIMIT 1 [ RunTime:0.003710s ] [ sql ] [ SQL ] SELECT sum(payable_money) as total FROM `ot_ladger` WHERE ( factorymge_id=19 ) AND ( createtime>1791216000 ) AND ( createtime<1791302400 ) LIMIT 1 [ RunTime:0.003605s ] [ sql ] [ SQL ] SELECT * FROM `ot_zichan` WHERE `factorymge_id` = 19 AND `year` = 2026 AND `month` = 10 AND `day` = 6 LIMIT 1 [ RunTime:0.022083s ] [ sql ] [ SQL ] INSERT INTO `ot_zichan` (`carmaterialcountpricediffer` , `shoudbeshoucountpricediffer` , `productcountpricediffer` , `lingcountpricediffer` , `shoudbefucountpricediffer` , `xianjindiffer` , `countpricediffer` , `factorymge_id` , `createtime` , `year` , `month` , `day`) VALUES (0 , 0 , 0 , 0 , 0 , 0 , 0 , 19 , 1791306002 , 2026 , 10 , 6) [ RunTime:0.005828s ] [ sql ] [ SQL ] SELECT sum(quantity*price) as total FROM `ot_orderandmaterial` WHERE ( factorymge_id=26 ) AND ( createtime>1791216000 ) AND ( createtime<1791302400 ) LIMIT 1 [ RunTime:0.001929s ] [ sql ] [ SQL ] SELECT `id` FROM `ot_orderinfo` WHERE ( factorymge_id=26 ) AND ( produced_time>1791216000 ) AND ( produced_time<1791302400 ) [ RunTime:0.020007s ] [ sql ] [ SQL ] SELECT sum(quantity*price) as total FROM `ot_orderandmaterial` WHERE `orderinfo_id` IN (60329,60386,60387,60388,60389,60392,60393,60394,60395,60398) LIMIT 1 [ RunTime:0.001963s ] [ sql ] [ SQL ] SELECT sum(money) as total FROM `ot_accountsreceivable` WHERE ( factorymge_id=26 ) AND ( createtime>1791216000 ) AND ( createtime<1791302400 ) LIMIT 1 [ RunTime:0.007318s ] [ sql ] [ SQL ] SELECT sum(reced_money) as total FROM `ot_accountsreceivable` WHERE ( factorymge_id=26 ) AND ( createtime>1791216000 ) AND ( createtime<1791302400 ) LIMIT 1 [ RunTime:0.007099s ] [ sql ] [ SQL ] SELECT * FROM `ot_orderinfo` WHERE ( factorymge_id=26 ) AND ( produced_time>1791216000 ) AND ( produced_time<1791302400 ) [ RunTime:0.067890s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `ot_productinfo` [ RunTime:0.000989s ] [ sql ] [ SQL ] SELECT * FROM `ot_productinfo` WHERE `id` = 2581 LIMIT 1 [ RunTime:0.000348s ] [ sql ] [ SQL ] SELECT * FROM `ot_productinfo` WHERE `id` = 512 LIMIT 1 [ RunTime:0.000298s ] [ sql ] [ SQL ] SELECT * FROM `ot_productinfo` WHERE `id` = 632 LIMIT 1 [ RunTime:0.000263s ] [ sql ] [ SQL ] SELECT * FROM `ot_productinfo` WHERE `id` = 507 LIMIT 1 [ RunTime:0.000243s ] [ sql ] [ SQL ] SELECT * FROM `ot_productinfo` WHERE `id` = 1583 LIMIT 1 [ RunTime:0.000278s ] [ sql ] [ SQL ] SELECT * FROM `ot_productinfo` WHERE `id` = 3289 LIMIT 1 [ RunTime:0.000281s ] [ sql ] [ SQL ] SELECT * FROM `ot_productinfo` WHERE `id` = 512 LIMIT 1 [ RunTime:0.000491s ] [ sql ] [ SQL ] SELECT * FROM `ot_productinfo` WHERE `id` = 731 LIMIT 1 [ RunTime:0.000290s ] [ sql ] [ SQL ] SELECT * FROM `ot_productinfo` WHERE `id` = 3331 LIMIT 1 [ RunTime:0.000293s ] [ sql ] [ SQL ] SELECT * FROM `ot_productinfo` WHERE `id` = 732 LIMIT 1 [ RunTime:0.000271s ] [ sql ] [ SQL ] SELECT sum(money) as total FROM `ot_outboundandorder` WHERE ( factorymge_id=26 ) AND ( createtime>1791216000 ) AND ( createtime<1791302400 ) LIMIT 1 [ RunTime:0.010142s ] [ sql ] [ SQL ] SELECT sum(money) as total FROM `ot_putinstorage` WHERE ( factorymge_id=26 ) AND ( createtime>1791216000 ) AND ( createtime<1791302400 ) LIMIT 1 [ RunTime:0.001484s ] [ sql ] [ SQL ] SELECT sum(quantity*price) as total FROM `ot_orderandmaterial` WHERE ( factorymge_id=26 ) AND ( createtime>1791216000 ) AND ( createtime<1791302400 ) LIMIT 1 [ RunTime:0.001823s ] [ sql ] [ SQL ] SELECT sum(paid_money) as total FROM `ot_accountspayable` WHERE ( factorymge_id=26 ) AND ( createtime>1791216000 ) AND ( createtime<1791302400 ) LIMIT 1 [ RunTime:0.002966s ] [ sql ] [ SQL ] SELECT sum(money) as total FROM `ot_accountspayable` WHERE ( factorymge_id=26 ) AND ( createtime>1791216000 ) AND ( createtime<1791302400 ) LIMIT 1 [ RunTime:0.002691s ] [ sql ] [ SQL ] SELECT sum(reced_money) as total FROM `ot_ladger` WHERE ( factorymge_id=26 ) AND ( createtime>1791216000 ) AND ( createtime<1791302400 ) LIMIT 1 [ RunTime:0.002461s ] [ sql ] [ SQL ] SELECT sum(payable_money) as total FROM `ot_ladger` WHERE ( factorymge_id=26 ) AND ( createtime>1791216000 ) AND ( createtime<1791302400 ) LIMIT 1 [ RunTime:0.002735s ] [ sql ] [ SQL ] SELECT * FROM `ot_zichan` WHERE `factorymge_id` = 26 AND `year` = 2026 AND `month` = 10 AND `day` = 6 LIMIT 1 [ RunTime:0.017953s ] [ sql ] [ SQL ] INSERT INTO `ot_zichan` (`carmaterialcountpricediffer` , `shoudbeshoucountpricediffer` , `productcountpricediffer` , `lingcountpricediffer` , `shoudbefucountpricediffer` , `xianjindiffer` , `countpricediffer` , `factorymge_id` , `createtime` , `year` , `month` , `day`) VALUES (0 , 0 , 6049.7 , 0 , 0 , 0 , 6049.7 , 26 , 1791306002 , 2026 , 10 , 6) [ RunTime:0.006360s ] [ sql ] [ SQL ] SELECT sum(quantity*price) as total FROM `ot_orderandmaterial` WHERE ( factorymge_id=27 ) AND ( createtime>1791216000 ) AND ( createtime<1791302400 ) LIMIT 1 [ RunTime:0.002147s ] [ sql ] [ SQL ] SELECT `id` FROM `ot_orderinfo` WHERE ( factorymge_id=27 ) AND ( produced_time>1791216000 ) AND ( produced_time<1791302400 ) [ RunTime:0.021333s ] [ sql ] [ SQL ] SELECT sum(quantity*price) as total FROM `ot_orderandmaterial` WHERE `orderinfo_id` IN ('') LIMIT 1 [ RunTime:0.001734s ] [ sql ] [ SQL ] SELECT sum(money) as total FROM `ot_accountsreceivable` WHERE ( factorymge_id=27 ) AND ( createtime>1791216000 ) AND ( createtime<1791302400 ) LIMIT 1 [ RunTime:0.007328s ] [ sql ] [ SQL ] SELECT sum(reced_money) as total FROM `ot_accountsreceivable` WHERE ( factorymge_id=27 ) AND ( createtime>1791216000 ) AND ( createtime<1791302400 ) LIMIT 1 [ RunTime:0.007523s ] [ sql ] [ SQL ] SELECT * FROM `ot_orderinfo` WHERE ( factorymge_id=27 ) AND ( produced_time>1791216000 ) AND ( produced_time<1791302400 ) [ RunTime:0.069725s ] [ sql ] [ SQL ] SELECT sum(money) as total FROM `ot_outboundandorder` WHERE ( factorymge_id=27 ) AND ( createtime>1791216000 ) AND ( createtime<1791302400 ) LIMIT 1 [ RunTime:0.008870s ] [ sql ] [ SQL ] SELECT sum(money) as total FROM `ot_putinstorage` WHERE ( factorymge_id=27 ) AND ( createtime>1791216000 ) AND ( createtime<1791302400 ) LIMIT 1 [ RunTime:0.001379s ] [ sql ] [ SQL ] SELECT sum(quantity*price) as total FROM `ot_orderandmaterial` WHERE ( factorymge_id=27 ) AND ( createtime>1791216000 ) AND ( createtime<1791302400 ) LIMIT 1 [ RunTime:0.001688s ] [ sql ] [ SQL ] SELECT sum(paid_money) as total FROM `ot_accountspayable` WHERE ( factorymge_id=27 ) AND ( createtime>1791216000 ) AND ( createtime<1791302400 ) LIMIT 1 [ RunTime:0.002719s ] [ sql ] [ SQL ] SELECT sum(money) as total FROM `ot_accountspayable` WHERE ( factorymge_id=27 ) AND ( createtime>1791216000 ) AND ( createtime<1791302400 ) LIMIT 1 [ RunTime:0.002624s ] [ sql ] [ SQL ] SELECT sum(reced_money) as total FROM `ot_ladger` WHERE ( factorymge_id=27 ) AND ( createtime>1791216000 ) AND ( createtime<1791302400 ) LIMIT 1 [ RunTime:0.002368s ] [ sql ] [ SQL ] SELECT sum(payable_money) as total FROM `ot_ladger` WHERE ( factorymge_id=27 ) AND ( createtime>1791216000 ) AND ( createtime<1791302400 ) LIMIT 1 [ RunTime:0.002391s ] [ sql ] [ SQL ] SELECT * FROM `ot_zichan` WHERE `factorymge_id` = 27 AND `year` = 2026 AND `month` = 10 AND `day` = 6 LIMIT 1 [ RunTime:0.017018s ] [ sql ] [ SQL ] INSERT INTO `ot_zichan` (`carmaterialcountpricediffer` , `shoudbeshoucountpricediffer` , `productcountpricediffer` , `lingcountpricediffer` , `shoudbefucountpricediffer` , `xianjindiffer` , `countpricediffer` , `factorymge_id` , `createtime` , `year` , `month` , `day`) VALUES (0 , 0 , 0 , 0 , 0 , 0 , 0 , 27 , 1791306002 , 2026 , 10 , 6) [ RunTime:0.006961s ] [ sql ] [ SQL ] SELECT sum(quantity*price) as total FROM `ot_orderandmaterial` WHERE ( factorymge_id=28 ) AND ( createtime>1791216000 ) AND ( createtime<1791302400 ) LIMIT 1 [ RunTime:0.002098s ] [ sql ] [ SQL ] SELECT `id` FROM `ot_orderinfo` WHERE ( factorymge_id=28 ) AND ( produced_time>1791216000 ) AND ( produced_time<1791302400 ) [ RunTime:0.020050s ] [ sql ] [ SQL ] SELECT sum(quantity*price) as total FROM `ot_orderandmaterial` WHERE `orderinfo_id` IN ('') LIMIT 1 [ RunTime:0.001874s ] [ sql ] [ SQL ] SELECT sum(money) as total FROM `ot_accountsreceivable` WHERE ( factorymge_id=28 ) AND ( createtime>1791216000 ) AND ( createtime<1791302400 ) LIMIT 1 [ RunTime:0.007817s ] [ sql ] [ SQL ] SELECT sum(reced_money) as total FROM `ot_accountsreceivable` WHERE ( factorymge_id=28 ) AND ( createtime>1791216000 ) AND ( createtime<1791302400 ) LIMIT 1 [ RunTime:0.007778s ] [ sql ] [ SQL ] SELECT * FROM `ot_orderinfo` WHERE ( factorymge_id=28 ) AND ( produced_time>1791216000 ) AND ( produced_time<1791302400 ) [ RunTime:0.069411s ] [ sql ] [ SQL ] SELECT sum(money) as total FROM `ot_outboundandorder` WHERE ( factorymge_id=28 ) AND ( createtime>1791216000 ) AND ( createtime<1791302400 ) LIMIT 1 [ RunTime:0.009512s ] [ sql ] [ SQL ] SELECT sum(money) as total FROM `ot_putinstorage` WHERE ( factorymge_id=28 ) AND ( createtime>1791216000 ) AND ( createtime<1791302400 ) LIMIT 1 [ RunTime:0.001438s ] [ sql ] [ SQL ] SELECT sum(quantity*price) as total FROM `ot_orderandmaterial` WHERE ( factorymge_id=28 ) AND ( createtime>1791216000 ) AND ( createtime<1791302400 ) LIMIT 1 [ RunTime:0.001733s ] [ sql ] [ SQL ] SELECT sum(paid_money) as total FROM `ot_accountspayable` WHERE ( factorymge_id=28 ) AND ( createtime>1791216000 ) AND ( createtime<1791302400 ) LIMIT 1 [ RunTime:0.003272s ] [ sql ] [ SQL ] SELECT sum(money) as total FROM `ot_accountspayable` WHERE ( factorymge_id=28 ) AND ( createtime>1791216000 ) AND ( createtime<1791302400 ) LIMIT 1 [ RunTime:0.004780s ] [ sql ] [ SQL ] SELECT sum(reced_money) as total FROM `ot_ladger` WHERE ( factorymge_id=28 ) AND ( createtime>1791216000 ) AND ( createtime<1791302400 ) LIMIT 1 [ RunTime:0.002459s ] [ sql ] [ SQL ] SELECT sum(payable_money) as total FROM `ot_ladger` WHERE ( factorymge_id=28 ) AND ( createtime>1791216000 ) AND ( createtime<1791302400 ) LIMIT 1 [ RunTime:0.002612s ] [ sql ] [ SQL ] SELECT * FROM `ot_zichan` WHERE `factorymge_id` = 28 AND `year` = 2026 AND `month` = 10 AND `day` = 6 LIMIT 1 [ RunTime:0.018559s ] [ sql ] [ SQL ] INSERT INTO `ot_zichan` (`carmaterialcountpricediffer` , `shoudbeshoucountpricediffer` , `productcountpricediffer` , `lingcountpricediffer` , `shoudbefucountpricediffer` , `xianjindiffer` , `countpricediffer` , `factorymge_id` , `createtime` , `year` , `month` , `day`) VALUES (0 , 0 , 0 , 0 , 0 , 0 , 0 , 28 , 1791306002 , 2026 , 10 , 6) [ RunTime:0.006307s ] [ sql ] [ SQL ] SELECT sum(quantity*price) as total FROM `ot_orderandmaterial` WHERE ( factorymge_id=29 ) AND ( createtime>1791216000 ) AND ( createtime<1791302400 ) LIMIT 1 [ RunTime:0.001894s ] [ sql ] [ SQL ] SELECT `id` FROM `ot_orderinfo` WHERE ( factorymge_id=29 ) AND ( produced_time>1791216000 ) AND ( produced_time<1791302400 ) [ RunTime:0.020574s ] [ sql ] [ SQL ] SELECT sum(quantity*price) as total FROM `ot_orderandmaterial` WHERE `orderinfo_id` IN ('') LIMIT 1 [ RunTime:0.001737s ] [ sql ] [ SQL ] SELECT sum(money) as total FROM `ot_accountsreceivable` WHERE ( factorymge_id=29 ) AND ( createtime>1791216000 ) AND ( createtime<1791302400 ) LIMIT 1 [ RunTime:0.007624s ] [ sql ] [ SQL ] SELECT sum(reced_money) as total FROM `ot_accountsreceivable` WHERE ( factorymge_id=29 ) AND ( createtime>1791216000 ) AND ( createtime<1791302400 ) LIMIT 1 [ RunTime:0.009623s ] [ sql ] [ SQL ] SELECT * FROM `ot_orderinfo` WHERE ( factorymge_id=29 ) AND ( produced_time>1791216000 ) AND ( produced_time<1791302400 ) [ RunTime:0.076394s ] [ sql ] [ SQL ] SELECT sum(money) as total FROM `ot_outboundandorder` WHERE ( factorymge_id=29 ) AND ( createtime>1791216000 ) AND ( createtime<1791302400 ) LIMIT 1 [ RunTime:0.008806s ] [ sql ] [ SQL ] SELECT sum(money) as total FROM `ot_putinstorage` WHERE ( factorymge_id=29 ) AND ( createtime>1791216000 ) AND ( createtime<1791302400 ) LIMIT 1 [ RunTime:0.001421s ] [ sql ] [ SQL ] SELECT sum(quantity*price) as total FROM `ot_orderandmaterial` WHERE ( factorymge_id=29 ) AND ( createtime>1791216000 ) AND ( createtime<1791302400 ) LIMIT 1 [ RunTime:0.001776s ] [ sql ] [ SQL ] SELECT sum(paid_money) as total FROM `ot_accountspayable` WHERE ( factorymge_id=29 ) AND ( createtime>1791216000 ) AND ( createtime<1791302400 ) LIMIT 1 [ RunTime:0.002765s ] [ sql ] [ SQL ] SELECT sum(money) as total FROM `ot_accountspayable` WHERE ( factorymge_id=29 ) AND ( createtime>1791216000 ) AND ( createtime<1791302400 ) LIMIT 1 [ RunTime:0.002879s ] [ sql ] [ SQL ] SELECT sum(reced_money) as total FROM `ot_ladger` WHERE ( factorymge_id=29 ) AND ( createtime>1791216000 ) AND ( createtime<1791302400 ) LIMIT 1 [ RunTime:0.002834s ] [ sql ] [ SQL ] SELECT sum(payable_money) as total FROM `ot_ladger` WHERE ( factorymge_id=29 ) AND ( createtime>1791216000 ) AND ( createtime<1791302400 ) LIMIT 1 [ RunTime:0.002853s ] [ sql ] [ SQL ] SELECT * FROM `ot_zichan` WHERE `factorymge_id` = 29 AND `year` = 2026 AND `month` = 10 AND `day` = 6 LIMIT 1 [ RunTime:0.022043s ] [ sql ] [ SQL ] INSERT INTO `ot_zichan` (`carmaterialcountpricediffer` , `shoudbeshoucountpricediffer` , `productcountpricediffer` , `lingcountpricediffer` , `shoudbefucountpricediffer` , `xianjindiffer` , `countpricediffer` , `factorymge_id` , `createtime` , `year` , `month` , `day`) VALUES (0 , 0 , 0 , 0 , 0 , 0 , 0 , 29 , 1791306002 , 2026 , 10 , 6) [ RunTime:0.003720s ] [ sql ] [ SQL ] SELECT sum(quantity*price) as total FROM `ot_orderandmaterial` WHERE ( factorymge_id=30 ) AND ( createtime>1791216000 ) AND ( createtime<1791302400 ) LIMIT 1 [ RunTime:0.002128s ] [ sql ] [ SQL ] SELECT `id` FROM `ot_orderinfo` WHERE ( factorymge_id=30 ) AND ( produced_time>1791216000 ) AND ( produced_time<1791302400 ) [ RunTime:0.025446s ] [ sql ] [ SQL ] SELECT sum(quantity*price) as total FROM `ot_orderandmaterial` WHERE `orderinfo_id` IN ('') LIMIT 1 [ RunTime:0.002130s ] [ sql ] [ SQL ] SELECT sum(money) as total FROM `ot_accountsreceivable` WHERE ( factorymge_id=30 ) AND ( createtime>1791216000 ) AND ( createtime<1791302400 ) LIMIT 1 [ RunTime:0.008188s ] [ sql ] [ SQL ] SELECT sum(reced_money) as total FROM `ot_accountsreceivable` WHERE ( factorymge_id=30 ) AND ( createtime>1791216000 ) AND ( createtime<1791302400 ) LIMIT 1 [ RunTime:0.008536s ] [ sql ] [ SQL ] SELECT * FROM `ot_orderinfo` WHERE ( factorymge_id=30 ) AND ( produced_time>1791216000 ) AND ( produced_time<1791302400 ) [ RunTime:0.076654s ] [ sql ] [ SQL ] SELECT sum(money) as total FROM `ot_outboundandorder` WHERE ( factorymge_id=30 ) AND ( createtime>1791216000 ) AND ( createtime<1791302400 ) LIMIT 1 [ RunTime:0.008798s ] [ sql ] [ SQL ] SELECT sum(money) as total FROM `ot_putinstorage` WHERE ( factorymge_id=30 ) AND ( createtime>1791216000 ) AND ( createtime<1791302400 ) LIMIT 1 [ RunTime:0.001370s ] [ sql ] [ SQL ] SELECT sum(quantity*price) as total FROM `ot_orderandmaterial` WHERE ( factorymge_id=30 ) AND ( createtime>1791216000 ) AND ( createtime<1791302400 ) LIMIT 1 [ RunTime:0.001931s ] [ sql ] [ SQL ] SELECT sum(paid_money) as total FROM `ot_accountspayable` WHERE ( factorymge_id=30 ) AND ( createtime>1791216000 ) AND ( createtime<1791302400 ) LIMIT 1 [ RunTime:0.003516s ] [ sql ] [ SQL ] SELECT sum(money) as total FROM `ot_accountspayable` WHERE ( factorymge_id=30 ) AND ( createtime>1791216000 ) AND ( createtime<1791302400 ) LIMIT 1 [ RunTime:0.002590s ] [ sql ] [ SQL ] SELECT sum(reced_money) as total FROM `ot_ladger` WHERE ( factorymge_id=30 ) AND ( createtime>1791216000 ) AND ( createtime<1791302400 ) LIMIT 1 [ RunTime:0.003461s ] [ sql ] [ SQL ] SELECT sum(payable_money) as total FROM `ot_ladger` WHERE ( factorymge_id=30 ) AND ( createtime>1791216000 ) AND ( createtime<1791302400 ) LIMIT 1 [ RunTime:0.002760s ] [ sql ] [ SQL ] SELECT * FROM `ot_zichan` WHERE `factorymge_id` = 30 AND `year` = 2026 AND `month` = 10 AND `day` = 6 LIMIT 1 [ RunTime:0.018020s ] [ sql ] [ SQL ] INSERT INTO `ot_zichan` (`carmaterialcountpricediffer` , `shoudbeshoucountpricediffer` , `productcountpricediffer` , `lingcountpricediffer` , `shoudbefucountpricediffer` , `xianjindiffer` , `countpricediffer` , `factorymge_id` , `createtime` , `year` , `month` , `day`) VALUES (0 , 0 , 0 , 0 , 0 , 0 , 0 , 30 , 1791306003 , 2026 , 10 , 6) [ RunTime:0.005544s ] [ sql ] [ SQL ] SELECT sum(quantity*price) as total FROM `ot_orderandmaterial` WHERE ( factorymge_id=31 ) AND ( createtime>1791216000 ) AND ( createtime<1791302400 ) LIMIT 1 [ RunTime:0.001728s ] [ sql ] [ SQL ] SELECT `id` FROM `ot_orderinfo` WHERE ( factorymge_id=31 ) AND ( produced_time>1791216000 ) AND ( produced_time<1791302400 ) [ RunTime:0.023344s ] [ sql ] [ SQL ] SELECT sum(quantity*price) as total FROM `ot_orderandmaterial` WHERE `orderinfo_id` IN ('') LIMIT 1 [ RunTime:0.002055s ] [ sql ] [ SQL ] SELECT sum(money) as total FROM `ot_accountsreceivable` WHERE ( factorymge_id=31 ) AND ( createtime>1791216000 ) AND ( createtime<1791302400 ) LIMIT 1 [ RunTime:0.008466s ] [ sql ] [ SQL ] SELECT sum(reced_money) as total FROM `ot_accountsreceivable` WHERE ( factorymge_id=31 ) AND ( createtime>1791216000 ) AND ( createtime<1791302400 ) LIMIT 1 [ RunTime:0.008438s ] [ sql ] [ SQL ] SELECT * FROM `ot_orderinfo` WHERE ( factorymge_id=31 ) AND ( produced_time>1791216000 ) AND ( produced_time<1791302400 ) [ RunTime:0.077066s ] [ sql ] [ SQL ] SELECT sum(money) as total FROM `ot_outboundandorder` WHERE ( factorymge_id=31 ) AND ( createtime>1791216000 ) AND ( createtime<1791302400 ) LIMIT 1 [ RunTime:0.010681s ] [ sql ] [ SQL ] SELECT sum(money) as total FROM `ot_putinstorage` WHERE ( factorymge_id=31 ) AND ( createtime>1791216000 ) AND ( createtime<1791302400 ) LIMIT 1 [ RunTime:0.001801s ] [ sql ] [ SQL ] SELECT sum(quantity*price) as total FROM `ot_orderandmaterial` WHERE ( factorymge_id=31 ) AND ( createtime>1791216000 ) AND ( createtime<1791302400 ) LIMIT 1 [ RunTime:0.002406s ] [ sql ] [ SQL ] SELECT sum(paid_money) as total FROM `ot_accountspayable` WHERE ( factorymge_id=31 ) AND ( createtime>1791216000 ) AND ( createtime<1791302400 ) LIMIT 1 [ RunTime:0.003429s ] [ sql ] [ SQL ] SELECT sum(money) as total FROM `ot_accountspayable` WHERE ( factorymge_id=31 ) AND ( createtime>1791216000 ) AND ( createtime<1791302400 ) LIMIT 1 [ RunTime:0.003360s ] [ sql ] [ SQL ] SELECT sum(reced_money) as total FROM `ot_ladger` WHERE ( factorymge_id=31 ) AND ( createtime>1791216000 ) AND ( createtime<1791302400 ) LIMIT 1 [ RunTime:0.003142s ] [ sql ] [ SQL ] SELECT sum(payable_money) as total FROM `ot_ladger` WHERE ( factorymge_id=31 ) AND ( createtime>1791216000 ) AND ( createtime<1791302400 ) LIMIT 1 [ RunTime:0.002727s ] [ sql ] [ SQL ] SELECT * FROM `ot_zichan` WHERE `factorymge_id` = 31 AND `year` = 2026 AND `month` = 10 AND `day` = 6 LIMIT 1 [ RunTime:0.021567s ] [ sql ] [ SQL ] INSERT INTO `ot_zichan` (`carmaterialcountpricediffer` , `shoudbeshoucountpricediffer` , `productcountpricediffer` , `lingcountpricediffer` , `shoudbefucountpricediffer` , `xianjindiffer` , `countpricediffer` , `factorymge_id` , `createtime` , `year` , `month` , `day`) VALUES (0 , 0 , 0 , 0 , 0 , 0 , 0 , 31 , 1791306003 , 2026 , 10 , 6) [ RunTime:0.005228s ] [ sql ] [ SQL ] SELECT sum(quantity*price) as total FROM `ot_orderandmaterial` WHERE ( factorymge_id=32 ) AND ( createtime>1791216000 ) AND ( createtime<1791302400 ) LIMIT 1 [ RunTime:0.002086s ] [ sql ] [ SQL ] SELECT `id` FROM `ot_orderinfo` WHERE ( factorymge_id=32 ) AND ( produced_time>1791216000 ) AND ( produced_time<1791302400 ) [ RunTime:0.022901s ] [ sql ] [ SQL ] SELECT sum(quantity*price) as total FROM `ot_orderandmaterial` WHERE `orderinfo_id` IN ('') LIMIT 1 [ RunTime:0.001955s ] [ sql ] [ SQL ] SELECT sum(money) as total FROM `ot_accountsreceivable` WHERE ( factorymge_id=32 ) AND ( createtime>1791216000 ) AND ( createtime<1791302400 ) LIMIT 1 [ RunTime:0.008117s ] [ sql ] [ SQL ] SELECT sum(reced_money) as total FROM `ot_accountsreceivable` WHERE ( factorymge_id=32 ) AND ( createtime>1791216000 ) AND ( createtime<1791302400 ) LIMIT 1 [ RunTime:0.007377s ] [ sql ] [ SQL ] SELECT * FROM `ot_orderinfo` WHERE ( factorymge_id=32 ) AND ( produced_time>1791216000 ) AND ( produced_time<1791302400 ) [ RunTime:0.072482s ] [ sql ] [ SQL ] SELECT sum(money) as total FROM `ot_outboundandorder` WHERE ( factorymge_id=32 ) AND ( createtime>1791216000 ) AND ( createtime<1791302400 ) LIMIT 1 [ RunTime:0.009901s ] [ sql ] [ SQL ] SELECT sum(money) as total FROM `ot_putinstorage` WHERE ( factorymge_id=32 ) AND ( createtime>1791216000 ) AND ( createtime<1791302400 ) LIMIT 1 [ RunTime:0.001507s ] [ sql ] [ SQL ] SELECT sum(quantity*price) as total FROM `ot_orderandmaterial` WHERE ( factorymge_id=32 ) AND ( createtime>1791216000 ) AND ( createtime<1791302400 ) LIMIT 1 [ RunTime:0.001863s ] [ sql ] [ SQL ] SELECT sum(paid_money) as total FROM `ot_accountspayable` WHERE ( factorymge_id=32 ) AND ( createtime>1791216000 ) AND ( createtime<1791302400 ) LIMIT 1 [ RunTime:0.003243s ] [ sql ] [ SQL ] SELECT sum(money) as total FROM `ot_accountspayable` WHERE ( factorymge_id=32 ) AND ( createtime>1791216000 ) AND ( createtime<1791302400 ) LIMIT 1 [ RunTime:0.002962s ] [ sql ] [ SQL ] SELECT sum(reced_money) as total FROM `ot_ladger` WHERE ( factorymge_id=32 ) AND ( createtime>1791216000 ) AND ( createtime<1791302400 ) LIMIT 1 [ RunTime:0.002618s ] [ sql ] [ SQL ] SELECT sum(payable_money) as total FROM `ot_ladger` WHERE ( factorymge_id=32 ) AND ( createtime>1791216000 ) AND ( createtime<1791302400 ) LIMIT 1 [ RunTime:0.002615s ] [ sql ] [ SQL ] SELECT * FROM `ot_zichan` WHERE `factorymge_id` = 32 AND `year` = 2026 AND `month` = 10 AND `day` = 6 LIMIT 1 [ RunTime:0.019942s ] [ sql ] [ SQL ] INSERT INTO `ot_zichan` (`carmaterialcountpricediffer` , `shoudbeshoucountpricediffer` , `productcountpricediffer` , `lingcountpricediffer` , `shoudbefucountpricediffer` , `xianjindiffer` , `countpricediffer` , `factorymge_id` , `createtime` , `year` , `month` , `day`) VALUES (0 , 0 , 0 , 0 , 0 , 0 , 0 , 32 , 1791306003 , 2026 , 10 , 6) [ RunTime:0.006623s ] [ sql ] [ SQL ] SELECT sum(quantity*price) as total FROM `ot_orderandmaterial` WHERE ( factorymge_id=34 ) AND ( createtime>1791216000 ) AND ( createtime<1791302400 ) LIMIT 1 [ RunTime:0.003281s ] [ sql ] [ SQL ] SELECT `id` FROM `ot_orderinfo` WHERE ( factorymge_id=34 ) AND ( produced_time>1791216000 ) AND ( produced_time<1791302400 ) [ RunTime:0.035178s ] [ sql ] [ SQL ] SELECT sum(quantity*price) as total FROM `ot_orderandmaterial` WHERE `orderinfo_id` IN ('') LIMIT 1 [ RunTime:0.002784s ] [ sql ] [ SQL ] SELECT sum(money) as total FROM `ot_accountsreceivable` WHERE ( factorymge_id=34 ) AND ( createtime>1791216000 ) AND ( createtime<1791302400 ) LIMIT 1 [ RunTime:0.011193s ] [ sql ] [ SQL ] SELECT sum(reced_money) as total FROM `ot_accountsreceivable` WHERE ( factorymge_id=34 ) AND ( createtime>1791216000 ) AND ( createtime<1791302400 ) LIMIT 1 [ RunTime:0.007455s ] [ sql ] [ SQL ] SELECT * FROM `ot_orderinfo` WHERE ( factorymge_id=34 ) AND ( produced_time>1791216000 ) AND ( produced_time<1791302400 ) [ RunTime:0.077728s ] [ sql ] [ SQL ] SELECT sum(money) as total FROM `ot_outboundandorder` WHERE ( factorymge_id=34 ) AND ( createtime>1791216000 ) AND ( createtime<1791302400 ) LIMIT 1 [ RunTime:0.010037s ] [ sql ] [ SQL ] SELECT sum(money) as total FROM `ot_putinstorage` WHERE ( factorymge_id=34 ) AND ( createtime>1791216000 ) AND ( createtime<1791302400 ) LIMIT 1 [ RunTime:0.001592s ] [ sql ] [ SQL ] SELECT sum(quantity*price) as total FROM `ot_orderandmaterial` WHERE ( factorymge_id=34 ) AND ( createtime>1791216000 ) AND ( createtime<1791302400 ) LIMIT 1 [ RunTime:0.002127s ] [ sql ] [ SQL ] SELECT sum(paid_money) as total FROM `ot_accountspayable` WHERE ( factorymge_id=34 ) AND ( createtime>1791216000 ) AND ( createtime<1791302400 ) LIMIT 1 [ RunTime:0.003143s ] [ sql ] [ SQL ] SELECT sum(money) as total FROM `ot_accountspayable` WHERE ( factorymge_id=34 ) AND ( createtime>1791216000 ) AND ( createtime<1791302400 ) LIMIT 1 [ RunTime:0.003176s ] [ sql ] [ SQL ] SELECT sum(reced_money) as total FROM `ot_ladger` WHERE ( factorymge_id=34 ) AND ( createtime>1791216000 ) AND ( createtime<1791302400 ) LIMIT 1 [ RunTime:0.003030s ] [ sql ] [ SQL ] SELECT sum(payable_money) as total FROM `ot_ladger` WHERE ( factorymge_id=34 ) AND ( createtime>1791216000 ) AND ( createtime<1791302400 ) LIMIT 1 [ RunTime:0.002418s ] [ sql ] [ SQL ] SELECT * FROM `ot_zichan` WHERE `factorymge_id` = 34 AND `year` = 2026 AND `month` = 10 AND `day` = 6 LIMIT 1 [ RunTime:0.018876s ] [ sql ] [ SQL ] INSERT INTO `ot_zichan` (`carmaterialcountpricediffer` , `shoudbeshoucountpricediffer` , `productcountpricediffer` , `lingcountpricediffer` , `shoudbefucountpricediffer` , `xianjindiffer` , `countpricediffer` , `factorymge_id` , `createtime` , `year` , `month` , `day`) VALUES (0 , 0 , 0 , 0 , 0 , 0 , 0 , 34 , 1791306003 , 2026 , 10 , 6) [ RunTime:0.004542s ] [ sql ] [ SQL ] SELECT sum(quantity*price) as total FROM `ot_orderandmaterial` WHERE ( factorymge_id=35 ) AND ( createtime>1791216000 ) AND ( createtime<1791302400 ) LIMIT 1 [ RunTime:0.002114s ] [ sql ] [ SQL ] SELECT `id` FROM `ot_orderinfo` WHERE ( factorymge_id=35 ) AND ( produced_time>1791216000 ) AND ( produced_time<1791302400 ) [ RunTime:0.021406s ] [ sql ] [ SQL ] SELECT sum(quantity*price) as total FROM `ot_orderandmaterial` WHERE `orderinfo_id` IN ('') LIMIT 1 [ RunTime:0.001990s ] [ sql ] [ SQL ] SELECT sum(money) as total FROM `ot_accountsreceivable` WHERE ( factorymge_id=35 ) AND ( createtime>1791216000 ) AND ( createtime<1791302400 ) LIMIT 1 [ RunTime:0.008925s ] [ sql ] [ SQL ] SELECT sum(reced_money) as total FROM `ot_accountsreceivable` WHERE ( factorymge_id=35 ) AND ( createtime>1791216000 ) AND ( createtime<1791302400 ) LIMIT 1 [ RunTime:0.008794s ] [ sql ] [ SQL ] SELECT * FROM `ot_orderinfo` WHERE ( factorymge_id=35 ) AND ( produced_time>1791216000 ) AND ( produced_time<1791302400 ) [ RunTime:0.075646s ] [ sql ] [ SQL ] SELECT sum(money) as total FROM `ot_outboundandorder` WHERE ( factorymge_id=35 ) AND ( createtime>1791216000 ) AND ( createtime<1791302400 ) LIMIT 1 [ RunTime:0.010467s ] [ sql ] [ SQL ] SELECT sum(money) as total FROM `ot_putinstorage` WHERE ( factorymge_id=35 ) AND ( createtime>1791216000 ) AND ( createtime<1791302400 ) LIMIT 1 [ RunTime:0.001718s ] [ sql ] [ SQL ] SELECT sum(quantity*price) as total FROM `ot_orderandmaterial` WHERE ( factorymge_id=35 ) AND ( createtime>1791216000 ) AND ( createtime<1791302400 ) LIMIT 1 [ RunTime:0.002025s ] [ sql ] [ SQL ] SELECT sum(paid_money) as total FROM `ot_accountspayable` WHERE ( factorymge_id=35 ) AND ( createtime>1791216000 ) AND ( createtime<1791302400 ) LIMIT 1 [ RunTime:0.003168s ] [ sql ] [ SQL ] SELECT sum(money) as total FROM `ot_accountspayable` WHERE ( factorymge_id=35 ) AND ( createtime>1791216000 ) AND ( createtime<1791302400 ) LIMIT 1 [ RunTime:0.003253s ] [ sql ] [ SQL ] SELECT sum(reced_money) as total FROM `ot_ladger` WHERE ( factorymge_id=35 ) AND ( createtime>1791216000 ) AND ( createtime<1791302400 ) LIMIT 1 [ RunTime:0.002769s ] [ sql ] [ SQL ] SELECT sum(payable_money) as total FROM `ot_ladger` WHERE ( factorymge_id=35 ) AND ( createtime>1791216000 ) AND ( createtime<1791302400 ) LIMIT 1 [ RunTime:0.003029s ] [ sql ] [ SQL ] SELECT * FROM `ot_zichan` WHERE `factorymge_id` = 35 AND `year` = 2026 AND `month` = 10 AND `day` = 6 LIMIT 1 [ RunTime:0.020014s ] [ sql ] [ SQL ] INSERT INTO `ot_zichan` (`carmaterialcountpricediffer` , `shoudbeshoucountpricediffer` , `productcountpricediffer` , `lingcountpricediffer` , `shoudbefucountpricediffer` , `xianjindiffer` , `countpricediffer` , `factorymge_id` , `createtime` , `year` , `month` , `day`) VALUES (0 , 0 , 0 , 0 , 0 , 0 , 0 , 35 , 1791306003 , 2026 , 10 , 6) [ RunTime:0.005564s ] [ sql ] [ SQL ] SELECT sum(quantity*price) as total FROM `ot_orderandmaterial` WHERE ( factorymge_id=36 ) AND ( createtime>1791216000 ) AND ( createtime<1791302400 ) LIMIT 1 [ RunTime:0.002194s ] [ sql ] [ SQL ] SELECT `id` FROM `ot_orderinfo` WHERE ( factorymge_id=36 ) AND ( produced_time>1791216000 ) AND ( produced_time<1791302400 ) [ RunTime:0.023608s ] [ sql ] [ SQL ] SELECT sum(quantity*price) as total FROM `ot_orderandmaterial` WHERE `orderinfo_id` IN ('') LIMIT 1 [ RunTime:0.001919s ] [ sql ] [ SQL ] SELECT sum(money) as total FROM `ot_accountsreceivable` WHERE ( factorymge_id=36 ) AND ( createtime>1791216000 ) AND ( createtime<1791302400 ) LIMIT 1 [ RunTime:0.009170s ] [ sql ] [ SQL ] SELECT sum(reced_money) as total FROM `ot_accountsreceivable` WHERE ( factorymge_id=36 ) AND ( createtime>1791216000 ) AND ( createtime<1791302400 ) LIMIT 1 [ RunTime:0.007391s ] [ sql ] [ SQL ] SELECT * FROM `ot_orderinfo` WHERE ( factorymge_id=36 ) AND ( produced_time>1791216000 ) AND ( produced_time<1791302400 ) [ RunTime:0.082204s ] [ sql ] [ SQL ] SELECT sum(money) as total FROM `ot_outboundandorder` WHERE ( factorymge_id=36 ) AND ( createtime>1791216000 ) AND ( createtime<1791302400 ) LIMIT 1 [ RunTime:0.010777s ] [ sql ] [ SQL ] SELECT sum(money) as total FROM `ot_putinstorage` WHERE ( factorymge_id=36 ) AND ( createtime>1791216000 ) AND ( createtime<1791302400 ) LIMIT 1 [ RunTime:0.001762s ] [ sql ] [ SQL ] SELECT sum(quantity*price) as total FROM `ot_orderandmaterial` WHERE ( factorymge_id=36 ) AND ( createtime>1791216000 ) AND ( createtime<1791302400 ) LIMIT 1 [ RunTime:0.002475s ] [ sql ] [ SQL ] SELECT sum(paid_money) as total FROM `ot_accountspayable` WHERE ( factorymge_id=36 ) AND ( createtime>1791216000 ) AND ( createtime<1791302400 ) LIMIT 1 [ RunTime:0.004119s ] [ sql ] [ SQL ] SELECT sum(money) as total FROM `ot_accountspayable` WHERE ( factorymge_id=36 ) AND ( createtime>1791216000 ) AND ( createtime<1791302400 ) LIMIT 1 [ RunTime:0.003635s ] [ sql ] [ SQL ] SELECT sum(reced_money) as total FROM `ot_ladger` WHERE ( factorymge_id=36 ) AND ( createtime>1791216000 ) AND ( createtime<1791302400 ) LIMIT 1 [ RunTime:0.002916s ] [ sql ] [ SQL ] SELECT sum(payable_money) as total FROM `ot_ladger` WHERE ( factorymge_id=36 ) AND ( createtime>1791216000 ) AND ( createtime<1791302400 ) LIMIT 1 [ RunTime:0.002844s ] [ sql ] [ SQL ] SELECT * FROM `ot_zichan` WHERE `factorymge_id` = 36 AND `year` = 2026 AND `month` = 10 AND `day` = 6 LIMIT 1 [ RunTime:0.019761s ] [ sql ] [ SQL ] INSERT INTO `ot_zichan` (`carmaterialcountpricediffer` , `shoudbeshoucountpricediffer` , `productcountpricediffer` , `lingcountpricediffer` , `shoudbefucountpricediffer` , `xianjindiffer` , `countpricediffer` , `factorymge_id` , `createtime` , `year` , `month` , `day`) VALUES (0 , 0 , 0 , 0 , 0 , 0 , 0 , 36 , 1791306003 , 2026 , 10 , 6) [ RunTime:0.004873s ] [ sql ] [ SQL ] SELECT sum(quantity*price) as total FROM `ot_orderandmaterial` WHERE ( factorymge_id=38 ) AND ( createtime>1791216000 ) AND ( createtime<1791302400 ) LIMIT 1 [ RunTime:0.002266s ] [ sql ] [ SQL ] SELECT `id` FROM `ot_orderinfo` WHERE ( factorymge_id=38 ) AND ( produced_time>1791216000 ) AND ( produced_time<1791302400 ) [ RunTime:0.021563s ] [ sql ] [ SQL ] SELECT sum(quantity*price) as total FROM `ot_orderandmaterial` WHERE `orderinfo_id` IN ('') LIMIT 1 [ RunTime:0.001861s ] [ sql ] [ SQL ] SELECT sum(money) as total FROM `ot_accountsreceivable` WHERE ( factorymge_id=38 ) AND ( createtime>1791216000 ) AND ( createtime<1791302400 ) LIMIT 1 [ RunTime:0.008702s ] [ sql ] [ SQL ] SELECT sum(reced_money) as total FROM `ot_accountsreceivable` WHERE ( factorymge_id=38 ) AND ( createtime>1791216000 ) AND ( createtime<1791302400 ) LIMIT 1 [ RunTime:0.008327s ] [ sql ] [ SQL ] SELECT * FROM `ot_orderinfo` WHERE ( factorymge_id=38 ) AND ( produced_time>1791216000 ) AND ( produced_time<1791302400 ) [ RunTime:0.081797s ] [ sql ] [ SQL ] SELECT sum(money) as total FROM `ot_outboundandorder` WHERE ( factorymge_id=38 ) AND ( createtime>1791216000 ) AND ( createtime<1791302400 ) LIMIT 1 [ RunTime:0.010950s ] [ sql ] [ SQL ] SELECT sum(money) as total FROM `ot_putinstorage` WHERE ( factorymge_id=38 ) AND ( createtime>1791216000 ) AND ( createtime<1791302400 ) LIMIT 1 [ RunTime:0.001538s ] [ sql ] [ SQL ] SELECT sum(quantity*price) as total FROM `ot_orderandmaterial` WHERE ( factorymge_id=38 ) AND ( createtime>1791216000 ) AND ( createtime<1791302400 ) LIMIT 1 [ RunTime:0.001769s ] [ sql ] [ SQL ] SELECT sum(paid_money) as total FROM `ot_accountspayable` WHERE ( factorymge_id=38 ) AND ( createtime>1791216000 ) AND ( createtime<1791302400 ) LIMIT 1 [ RunTime:0.003497s ] [ sql ] [ SQL ] SELECT sum(money) as total FROM `ot_accountspayable` WHERE ( factorymge_id=38 ) AND ( createtime>1791216000 ) AND ( createtime<1791302400 ) LIMIT 1 [ RunTime:0.002722s ] [ sql ] [ SQL ] SELECT sum(reced_money) as total FROM `ot_ladger` WHERE ( factorymge_id=38 ) AND ( createtime>1791216000 ) AND ( createtime<1791302400 ) LIMIT 1 [ RunTime:0.002820s ] [ sql ] [ SQL ] SELECT sum(payable_money) as total FROM `ot_ladger` WHERE ( factorymge_id=38 ) AND ( createtime>1791216000 ) AND ( createtime<1791302400 ) LIMIT 1 [ RunTime:0.002537s ] [ sql ] [ SQL ] SELECT * FROM `ot_zichan` WHERE `factorymge_id` = 38 AND `year` = 2026 AND `month` = 10 AND `day` = 6 LIMIT 1 [ RunTime:0.019562s ] [ sql ] [ SQL ] INSERT INTO `ot_zichan` (`carmaterialcountpricediffer` , `shoudbeshoucountpricediffer` , `productcountpricediffer` , `lingcountpricediffer` , `shoudbefucountpricediffer` , `xianjindiffer` , `countpricediffer` , `factorymge_id` , `createtime` , `year` , `month` , `day`) VALUES (0 , 0 , 0 , 0 , 0 , 0 , 0 , 38 , 1791306004 , 2026 , 10 , 6) [ RunTime:0.006035s ] [ sql ] [ SQL ] SELECT sum(quantity*price) as total FROM `ot_orderandmaterial` WHERE ( factorymge_id=39 ) AND ( createtime>1791216000 ) AND ( createtime<1791302400 ) LIMIT 1 [ RunTime:0.001956s ] [ sql ] [ SQL ] SELECT `id` FROM `ot_orderinfo` WHERE ( factorymge_id=39 ) AND ( produced_time>1791216000 ) AND ( produced_time<1791302400 ) [ RunTime:0.023735s ] [ sql ] [ SQL ] SELECT sum(quantity*price) as total FROM `ot_orderandmaterial` WHERE `orderinfo_id` IN ('') LIMIT 1 [ RunTime:0.002453s ] [ sql ] [ SQL ] SELECT sum(money) as total FROM `ot_accountsreceivable` WHERE ( factorymge_id=39 ) AND ( createtime>1791216000 ) AND ( createtime<1791302400 ) LIMIT 1 [ RunTime:0.007995s ] [ sql ] [ SQL ] SELECT sum(reced_money) as total FROM `ot_accountsreceivable` WHERE ( factorymge_id=39 ) AND ( createtime>1791216000 ) AND ( createtime<1791302400 ) LIMIT 1 [ RunTime:0.007068s ] [ sql ] [ SQL ] SELECT * FROM `ot_orderinfo` WHERE ( factorymge_id=39 ) AND ( produced_time>1791216000 ) AND ( produced_time<1791302400 ) [ RunTime:0.068131s ] [ sql ] [ SQL ] SELECT sum(money) as total FROM `ot_outboundandorder` WHERE ( factorymge_id=39 ) AND ( createtime>1791216000 ) AND ( createtime<1791302400 ) LIMIT 1 [ RunTime:0.008813s ] [ sql ] [ SQL ] SELECT sum(money) as total FROM `ot_putinstorage` WHERE ( factorymge_id=39 ) AND ( createtime>1791216000 ) AND ( createtime<1791302400 ) LIMIT 1 [ RunTime:0.001327s ] [ sql ] [ SQL ] SELECT sum(quantity*price) as total FROM `ot_orderandmaterial` WHERE ( factorymge_id=39 ) AND ( createtime>1791216000 ) AND ( createtime<1791302400 ) LIMIT 1 [ RunTime:0.001687s ] [ sql ] [ SQL ] SELECT sum(paid_money) as total FROM `ot_accountspayable` WHERE ( factorymge_id=39 ) AND ( createtime>1791216000 ) AND ( createtime<1791302400 ) LIMIT 1 [ RunTime:0.002618s ] [ sql ] [ SQL ] SELECT sum(money) as total FROM `ot_accountspayable` WHERE ( factorymge_id=39 ) AND ( createtime>1791216000 ) AND ( createtime<1791302400 ) LIMIT 1 [ RunTime:0.002515s ] [ sql ] [ SQL ] SELECT sum(reced_money) as total FROM `ot_ladger` WHERE ( factorymge_id=39 ) AND ( createtime>1791216000 ) AND ( createtime<1791302400 ) LIMIT 1 [ RunTime:0.002322s ] [ sql ] [ SQL ] SELECT sum(payable_money) as total FROM `ot_ladger` WHERE ( factorymge_id=39 ) AND ( createtime>1791216000 ) AND ( createtime<1791302400 ) LIMIT 1 [ RunTime:0.002249s ] [ sql ] [ SQL ] SELECT * FROM `ot_zichan` WHERE `factorymge_id` = 39 AND `year` = 2026 AND `month` = 10 AND `day` = 6 LIMIT 1 [ RunTime:0.016716s ] [ sql ] [ SQL ] INSERT INTO `ot_zichan` (`carmaterialcountpricediffer` , `shoudbeshoucountpricediffer` , `productcountpricediffer` , `lingcountpricediffer` , `shoudbefucountpricediffer` , `xianjindiffer` , `countpricediffer` , `factorymge_id` , `createtime` , `year` , `month` , `day`) VALUES (0 , 0 , 0 , 0 , 0 , 0 , 0 , 39 , 1791306004 , 2026 , 10 , 6) [ RunTime:0.006832s ] [ sql ] [ SQL ] SELECT sum(quantity*price) as total FROM `ot_orderandmaterial` WHERE ( factorymge_id=40 ) AND ( createtime>1791216000 ) AND ( createtime<1791302400 ) LIMIT 1 [ RunTime:0.001861s ] [ sql ] [ SQL ] SELECT `id` FROM `ot_orderinfo` WHERE ( factorymge_id=40 ) AND ( produced_time>1791216000 ) AND ( produced_time<1791302400 ) [ RunTime:0.019866s ] [ sql ] [ SQL ] SELECT sum(quantity*price) as total FROM `ot_orderandmaterial` WHERE `orderinfo_id` IN (60038,60368,60373) LIMIT 1 [ RunTime:0.001661s ] [ sql ] [ SQL ] SELECT sum(money) as total FROM `ot_accountsreceivable` WHERE ( factorymge_id=40 ) AND ( createtime>1791216000 ) AND ( createtime<1791302400 ) LIMIT 1 [ RunTime:0.007345s ] [ sql ] [ SQL ] SELECT sum(reced_money) as total FROM `ot_accountsreceivable` WHERE ( factorymge_id=40 ) AND ( createtime>1791216000 ) AND ( createtime<1791302400 ) LIMIT 1 [ RunTime:0.007086s ] [ sql ] [ SQL ] SELECT * FROM `ot_orderinfo` WHERE ( factorymge_id=40 ) AND ( produced_time>1791216000 ) AND ( produced_time<1791302400 ) [ RunTime:0.067174s ] [ sql ] [ SQL ] SELECT * FROM `ot_productinfo` WHERE `id` = 1084 LIMIT 1 [ RunTime:0.000338s ] [ sql ] [ SQL ] SELECT * FROM `ot_productinfo` WHERE `id` = 1077 LIMIT 1 [ RunTime:0.000270s ] [ sql ] [ SQL ] SELECT * FROM `ot_productinfo` WHERE `id` = 1106 LIMIT 1 [ RunTime:0.000262s ] [ sql ] [ SQL ] SELECT sum(money) as total FROM `ot_outboundandorder` WHERE ( factorymge_id=40 ) AND ( createtime>1791216000 ) AND ( createtime<1791302400 ) LIMIT 1 [ RunTime:0.009553s ] [ sql ] [ SQL ] SELECT sum(money) as total FROM `ot_putinstorage` WHERE ( factorymge_id=40 ) AND ( createtime>1791216000 ) AND ( createtime<1791302400 ) LIMIT 1 [ RunTime:0.001423s ] [ sql ] [ SQL ] SELECT sum(quantity*price) as total FROM `ot_orderandmaterial` WHERE ( factorymge_id=40 ) AND ( createtime>1791216000 ) AND ( createtime<1791302400 ) LIMIT 1 [ RunTime:0.001911s ] [ sql ] [ SQL ] SELECT sum(paid_money) as total FROM `ot_accountspayable` WHERE ( factorymge_id=40 ) AND ( createtime>1791216000 ) AND ( createtime<1791302400 ) LIMIT 1 [ RunTime:0.002824s ] [ sql ] [ SQL ] SELECT sum(money) as total FROM `ot_accountspayable` WHERE ( factorymge_id=40 ) AND ( createtime>1791216000 ) AND ( createtime<1791302400 ) LIMIT 1 [ RunTime:0.002759s ] [ sql ] [ SQL ] SELECT sum(reced_money) as total FROM `ot_ladger` WHERE ( factorymge_id=40 ) AND ( createtime>1791216000 ) AND ( createtime<1791302400 ) LIMIT 1 [ RunTime:0.002413s ] [ sql ] [ SQL ] SELECT sum(payable_money) as total FROM `ot_ladger` WHERE ( factorymge_id=40 ) AND ( createtime>1791216000 ) AND ( createtime<1791302400 ) LIMIT 1 [ RunTime:0.002396s ] [ sql ] [ SQL ] SELECT * FROM `ot_zichan` WHERE `factorymge_id` = 40 AND `year` = 2026 AND `month` = 10 AND `day` = 6 LIMIT 1 [ RunTime:0.017079s ] [ sql ] [ SQL ] INSERT INTO `ot_zichan` (`carmaterialcountpricediffer` , `shoudbeshoucountpricediffer` , `productcountpricediffer` , `lingcountpricediffer` , `shoudbefucountpricediffer` , `xianjindiffer` , `countpricediffer` , `factorymge_id` , `createtime` , `year` , `month` , `day`) VALUES (-47343.065 , 0 , 62406.65 , 0 , 0 , 0 , 15063.585 , 40 , 1791306004 , 2026 , 10 , 6) [ RunTime:0.005167s ] [ sql ] [ SQL ] SELECT sum(quantity*price) as total FROM `ot_orderandmaterial` WHERE ( factorymge_id=41 ) AND ( createtime>1791216000 ) AND ( createtime<1791302400 ) LIMIT 1 [ RunTime:0.001783s ] [ sql ] [ SQL ] SELECT `id` FROM `ot_orderinfo` WHERE ( factorymge_id=41 ) AND ( produced_time>1791216000 ) AND ( produced_time<1791302400 ) [ RunTime:0.020869s ] [ sql ] [ SQL ] SELECT sum(quantity*price) as total FROM `ot_orderandmaterial` WHERE `orderinfo_id` IN ('') LIMIT 1 [ RunTime:0.001804s ] [ sql ] [ SQL ] SELECT sum(money) as total FROM `ot_accountsreceivable` WHERE ( factorymge_id=41 ) AND ( createtime>1791216000 ) AND ( createtime<1791302400 ) LIMIT 1 [ RunTime:0.007601s ] [ sql ] [ SQL ] SELECT sum(reced_money) as total FROM `ot_accountsreceivable` WHERE ( factorymge_id=41 ) AND ( createtime>1791216000 ) AND ( createtime<1791302400 ) LIMIT 1 [ RunTime:0.007828s ] [ sql ] [ SQL ] SELECT * FROM `ot_orderinfo` WHERE ( factorymge_id=41 ) AND ( produced_time>1791216000 ) AND ( produced_time<1791302400 ) [ RunTime:0.070390s ] [ sql ] [ SQL ] SELECT sum(money) as total FROM `ot_outboundandorder` WHERE ( factorymge_id=41 ) AND ( createtime>1791216000 ) AND ( createtime<1791302400 ) LIMIT 1 [ RunTime:0.009377s ] [ sql ] [ SQL ] SELECT sum(money) as total FROM `ot_putinstorage` WHERE ( factorymge_id=41 ) AND ( createtime>1791216000 ) AND ( createtime<1791302400 ) LIMIT 1 [ RunTime:0.001582s ] [ sql ] [ SQL ] SELECT sum(quantity*price) as total FROM `ot_orderandmaterial` WHERE ( factorymge_id=41 ) AND ( createtime>1791216000 ) AND ( createtime<1791302400 ) LIMIT 1 [ RunTime:0.001784s ] [ sql ] [ SQL ] SELECT sum(paid_money) as total FROM `ot_accountspayable` WHERE ( factorymge_id=41 ) AND ( createtime>1791216000 ) AND ( createtime<1791302400 ) LIMIT 1 [ RunTime:0.003086s ] [ sql ] [ SQL ] SELECT sum(money) as total FROM `ot_accountspayable` WHERE ( factorymge_id=41 ) AND ( createtime>1791216000 ) AND ( createtime<1791302400 ) LIMIT 1 [ RunTime:0.002991s ] [ sql ] [ SQL ] SELECT sum(reced_money) as total FROM `ot_ladger` WHERE ( factorymge_id=41 ) AND ( createtime>1791216000 ) AND ( createtime<1791302400 ) LIMIT 1 [ RunTime:0.003394s ] [ sql ] [ SQL ] SELECT sum(payable_money) as total FROM `ot_ladger` WHERE ( factorymge_id=41 ) AND ( createtime>1791216000 ) AND ( createtime<1791302400 ) LIMIT 1 [ RunTime:0.002681s ] [ sql ] [ SQL ] SELECT * FROM `ot_zichan` WHERE `factorymge_id` = 41 AND `year` = 2026 AND `month` = 10 AND `day` = 6 LIMIT 1 [ RunTime:0.030135s ] [ sql ] [ SQL ] INSERT INTO `ot_zichan` (`carmaterialcountpricediffer` , `shoudbeshoucountpricediffer` , `productcountpricediffer` , `lingcountpricediffer` , `shoudbefucountpricediffer` , `xianjindiffer` , `countpricediffer` , `factorymge_id` , `createtime` , `year` , `month` , `day`) VALUES (0 , 0 , 0 , 0 , 0 , 0 , 0 , 41 , 1791306004 , 2026 , 10 , 6) [ RunTime:0.006007s ] [ sql ] [ SQL ] SELECT sum(quantity*price) as total FROM `ot_orderandmaterial` WHERE ( factorymge_id=42 ) AND ( createtime>1791216000 ) AND ( createtime<1791302400 ) LIMIT 1 [ RunTime:0.002021s ] [ sql ] [ SQL ] SELECT `id` FROM `ot_orderinfo` WHERE ( factorymge_id=42 ) AND ( produced_time>1791216000 ) AND ( produced_time<1791302400 ) [ RunTime:0.020654s ] [ sql ] [ SQL ] SELECT sum(quantity*price) as total FROM `ot_orderandmaterial` WHERE `orderinfo_id` IN ('') LIMIT 1 [ RunTime:0.001967s ] [ sql ] [ SQL ] SELECT sum(money) as total FROM `ot_accountsreceivable` WHERE ( factorymge_id=42 ) AND ( createtime>1791216000 ) AND ( createtime<1791302400 ) LIMIT 1 [ RunTime:0.009056s ] [ sql ] [ SQL ] SELECT sum(reced_money) as total FROM `ot_accountsreceivable` WHERE ( factorymge_id=42 ) AND ( createtime>1791216000 ) AND ( createtime<1791302400 ) LIMIT 1 [ RunTime:0.008110s ] [ sql ] [ SQL ] SELECT * FROM `ot_orderinfo` WHERE ( factorymge_id=42 ) AND ( produced_time>1791216000 ) AND ( produced_time<1791302400 ) [ RunTime:0.081646s ] [ sql ] [ SQL ] SELECT sum(money) as total FROM `ot_outboundandorder` WHERE ( factorymge_id=42 ) AND ( createtime>1791216000 ) AND ( createtime<1791302400 ) LIMIT 1 [ RunTime:0.010010s ] [ sql ] [ SQL ] SELECT sum(money) as total FROM `ot_putinstorage` WHERE ( factorymge_id=42 ) AND ( createtime>1791216000 ) AND ( createtime<1791302400 ) LIMIT 1 [ RunTime:0.001622s ] [ sql ] [ SQL ] SELECT sum(quantity*price) as total FROM `ot_orderandmaterial` WHERE ( factorymge_id=42 ) AND ( createtime>1791216000 ) AND ( createtime<1791302400 ) LIMIT 1 [ RunTime:0.002187s ] [ sql ] [ SQL ] SELECT sum(paid_money) as total FROM `ot_accountspayable` WHERE ( factorymge_id=42 ) AND ( createtime>1791216000 ) AND ( createtime<1791302400 ) LIMIT 1 [ RunTime:0.003074s ] [ sql ] [ SQL ] SELECT sum(money) as total FROM `ot_accountspayable` WHERE ( factorymge_id=42 ) AND ( createtime>1791216000 ) AND ( createtime<1791302400 ) LIMIT 1 [ RunTime:0.002761s ] [ sql ] [ SQL ] SELECT sum(reced_money) as total FROM `ot_ladger` WHERE ( factorymge_id=42 ) AND ( createtime>1791216000 ) AND ( createtime<1791302400 ) LIMIT 1 [ RunTime:0.002699s ] [ sql ] [ SQL ] SELECT sum(payable_money) as total FROM `ot_ladger` WHERE ( factorymge_id=42 ) AND ( createtime>1791216000 ) AND ( createtime<1791302400 ) LIMIT 1 [ RunTime:0.003037s ] [ sql ] [ SQL ] SELECT * FROM `ot_zichan` WHERE `factorymge_id` = 42 AND `year` = 2026 AND `month` = 10 AND `day` = 6 LIMIT 1 [ RunTime:0.019284s ] [ sql ] [ SQL ] INSERT INTO `ot_zichan` (`carmaterialcountpricediffer` , `shoudbeshoucountpricediffer` , `productcountpricediffer` , `lingcountpricediffer` , `shoudbefucountpricediffer` , `xianjindiffer` , `countpricediffer` , `factorymge_id` , `createtime` , `year` , `month` , `day`) VALUES (0 , 0 , 0 , 0 , 0 , 0 , 0 , 42 , 1791306004 , 2026 , 10 , 6) [ RunTime:0.004947s ] [ sql ] [ SQL ] SELECT * FROM `ot_factorymge` [ RunTime:0.000668s ] [ sql ] [ SQL ] SELECT * FROM `ot_zichan` WHERE `factorymge_id` = 1 AND `year` = 2026 AND `month` = 10 AND `day` = 5 LIMIT 1 [ RunTime:0.021262s ] [ sql ] [ SQL ] SELECT * FROM `ot_zichan` WHERE `factorymge_id` = 1 AND `year` = 2026 AND `month` = 10 AND `day` = 6 LIMIT 1 [ RunTime:0.018219s ] [ sql ] [ SQL ] SELECT `orderinfo`.`id` FROM `ot_orderinfo` `orderinfo` LEFT JOIN `ot_factorymge` `factorymge` ON `orderinfo`.`factorymge_id`=`factorymge`.`id` LEFT JOIN `ot_productinfo` `productinfo` ON `orderinfo`.`productinfo_id`=`productinfo`.`id` WHERE ( orderinfo.factorymge_id = 1 ) AND ( orderinfo.pid = 0 ) AND ( orderinfo.actual_amount > 0 ) AND ( orderinfo.order_status in ("1","2") ) [ RunTime:0.028251s ] [ sql ] [ SQL ] SELECT sum(quantity*price) as total FROM `ot_orderandmaterial` WHERE `orderinfo_id` IN (3900,5808,12356) LIMIT 1 [ RunTime:0.002731s ] [ sql ] [ SQL ] SELECT `orderinfo`.`id`,`orderinfo`.`nei_number`,`orderinfo`.`number`,`orderinfo`.`pid`,`orderinfo`.`order_company`,`orderinfo`.`order_connect`,`orderinfo`.`order_phone`,`orderinfo`.`kehu_id`,`orderinfo`.`price`,`orderinfo`.`material_id`,`orderinfo`.`pProductinfo_id`,`orderinfo`.`productinfo_id`,`orderinfo`.`order_type`,`orderinfo`.`order_status`,`orderinfo`.`all_order_status`,`orderinfo`.`shengchan_status`,`orderinfo`.`zuixinshuoming`,`orderinfo`.`guzhangshu`,`orderinfo`.`zuixinguzhang`,`orderinfo`.`techprocess_id`,`orderinfo`.`actual_amount`,`orderinfo`.`kucun_amount`,`orderinfo`.`produce_amount`,`orderinfo`.`produced_amount`,`orderinfo`.`waste_amount`,`orderinfo`.`produced_time`,`orderinfo`.`send_amount`,`orderinfo`.`ruku_posi`,`orderinfo`.`sent_amount`,`orderinfo`.`out_time`,`orderinfo`.`build_order_staffid`,`orderinfo`.`factorymge_id`,`orderinfo`.`admin_id`,`orderinfo`.`remind_day`,`orderinfo`.`build_time`,`orderinfo`.`end_time`,`orderinfo`.`responsible_staffinfos`,`orderinfo`.`responsible_staffinfovars`,`orderinfo`.`feedback`,`orderinfo`.`guoqitime`,`orderinfo`.`guoqi_status`,`orderinfo`.`put_position`,`orderinfo`.`createtime`,`orderinfo`.`updatetime`,`orderinfo`.`is_modify`,`orderinfo`.`purchaseorder_id`,factorymge.id AS factorymge__id,factorymge.name AS factorymge__name,factorymge.connect_name AS factorymge__connect_name,factorymge.phone_num AS factorymge__phone_num,factorymge.fax_num AS factorymge__fax_num,factorymge.build_order_yuan AS factorymge__build_order_yuan,factorymge.operator AS factorymge__operator,factorymge.city AS factorymge__city,factorymge.address AS factorymge__address,factorymge.en_switch AS factorymge__en_switch,factorymge.admin_id AS factorymge__admin_id,factorymge.createtime AS factorymge__createtime,factorymge.updatetime AS factorymge__updatetime,productinfo.id AS productinfo__id,productinfo.product_avatar AS productinfo__product_avatar,productinfo.name AS productinfo__name,productinfo.product_num AS productinfo__product_num,productinfo.kucun AS productinfo__kucun,productinfo.takeup_kucun AS productinfo__takeup_kucun,productinfo.staff_ids AS productinfo__staff_ids,productinfo.staff_names AS productinfo__staff_names,productinfo.pid AS productinfo__pid,productinfo.corresponding_num AS productinfo__corresponding_num,productinfo.position AS productinfo__position,productinfo.price AS productinfo__price,productinfo.factorymge_id AS productinfo__factorymge_id,productinfo.product_status AS productinfo__product_status,productinfo.admin_id AS productinfo__admin_id,productinfo.createtime AS productinfo__createtime,productinfo.updatetime AS productinfo__updatetime,sum(orderinfo.send_amount*orderinfo.price) as total FROM `ot_orderinfo` `orderinfo` LEFT JOIN `ot_factorymge` `factorymge` ON `orderinfo`.`factorymge_id`=`factorymge`.`id` LEFT JOIN `ot_productinfo` `productinfo` ON `orderinfo`.`productinfo_id`=`productinfo`.`id` WHERE ( orderinfo.factorymge_id = 1 ) AND ( orderinfo.pid != 0 ) AND ( orderinfo.actual_amount > 0 ) AND ( orderinfo.order_status in ("1","2") ) AND ( orderinfo.produced_time = 0 ) LIMIT 1 [ RunTime:0.086707s ] [ sql ] [ SQL ] SELECT `productinfo`.`id`,`productinfo`.`product_avatar`,`productinfo`.`name`,`productinfo`.`product_num`,`productinfo`.`kucun`,`productinfo`.`takeup_kucun`,`productinfo`.`staff_ids`,`productinfo`.`staff_names`,`productinfo`.`pid`,`productinfo`.`corresponding_num`,`productinfo`.`position`,`productinfo`.`price`,`productinfo`.`factorymge_id`,`productinfo`.`product_status`,`productinfo`.`admin_id`,`productinfo`.`createtime`,`productinfo`.`updatetime`,factorymge.id AS factorymge__id,factorymge.name AS factorymge__name,factorymge.connect_name AS factorymge__connect_name,factorymge.phone_num AS factorymge__phone_num,factorymge.fax_num AS factorymge__fax_num,factorymge.build_order_yuan AS factorymge__build_order_yuan,factorymge.operator AS factorymge__operator,factorymge.city AS factorymge__city,factorymge.address AS factorymge__address,factorymge.en_switch AS factorymge__en_switch,factorymge.admin_id AS factorymge__admin_id,factorymge.createtime AS factorymge__createtime,factorymge.updatetime AS factorymge__updatetime,sum(kucun*price) as total FROM `ot_productinfo` `productinfo` LEFT JOIN `ot_factorymge` `factorymge` ON `productinfo`.`factorymge_id`=`factorymge`.`id` WHERE ( factorymge_id=1 ) AND `product_status` = '1' LIMIT 1 [ RunTime:0.003408s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `ot_material` [ RunTime:0.001247s ] [ sql ] [ SQL ] SELECT `material`.`id`,`material`.`name`,`material`.`number`,`material`.`avatar`,`material`.`amount`,`material`.`warn_amount`,`material`.`occupy_amount`,`material`.`factorymge_id`,`material`.`is_stop_status`,`material`.`admin_id`,`material`.`price`,`material`.`danwei`,`material`.`quehuo_status`,`material`.`put_position`,`material`.`is_has_sup`,`material`.`staff_ids`,`material`.`staff_names`,`material`.`createtime`,`material`.`updatetime`,`material`.`is_delete`,factorymge.id AS factorymge__id,factorymge.name AS factorymge__name,factorymge.connect_name AS factorymge__connect_name,factorymge.phone_num AS factorymge__phone_num,factorymge.fax_num AS factorymge__fax_num,factorymge.build_order_yuan AS factorymge__build_order_yuan,factorymge.operator AS factorymge__operator,factorymge.city AS factorymge__city,factorymge.address AS factorymge__address,factorymge.en_switch AS factorymge__en_switch,factorymge.admin_id AS factorymge__admin_id,factorymge.createtime AS factorymge__createtime,factorymge.updatetime AS factorymge__updatetime,sum(amount*price) as total FROM `ot_material` `material` LEFT JOIN `ot_factorymge` `factorymge` ON `material`.`factorymge_id`=`factorymge`.`id` WHERE ( factorymge_id=1 ) LIMIT 1 [ RunTime:0.000518s ] [ sql ] [ SQL ] UPDATE `ot_zichan` SET `carmaterialcountprice`=0,`carmaterialcountpricediffer`=0,`countpricediffer`=0,`shoudbeshoucountprice`=0,`productcountprice`=0,`lingcountprice`=0,`shoudbefucountprice`=0,`xianjin`=0,`countprice`=0 WHERE `id` = 26166 [ RunTime:0.004654s ] [ sql ] [ SQL ] SELECT * FROM `ot_zichan` WHERE `factorymge_id` = 19 AND `year` = 2026 AND `month` = 10 AND `day` = 5 LIMIT 1 [ RunTime:0.021042s ] [ sql ] [ SQL ] SELECT * FROM `ot_zichan` WHERE `factorymge_id` = 19 AND `year` = 2026 AND `month` = 10 AND `day` = 6 LIMIT 1 [ RunTime:0.021903s ] [ sql ] [ SQL ] SELECT `orderinfo`.`id` FROM `ot_orderinfo` `orderinfo` LEFT JOIN `ot_factorymge` `factorymge` ON `orderinfo`.`factorymge_id`=`factorymge`.`id` LEFT JOIN `ot_productinfo` `productinfo` ON `orderinfo`.`productinfo_id`=`productinfo`.`id` WHERE ( orderinfo.factorymge_id = 19 ) AND ( orderinfo.pid = 0 ) AND ( orderinfo.actual_amount > 0 ) AND ( orderinfo.order_status in ("1","2") ) [ RunTime:0.025446s ] [ sql ] [ SQL ] SELECT sum(quantity*price) as total FROM `ot_orderandmaterial` WHERE `orderinfo_id` IN (12075,15662,17481,17486) LIMIT 1 [ RunTime:0.002834s ] [ sql ] [ SQL ] SELECT `orderinfo`.`id`,`orderinfo`.`nei_number`,`orderinfo`.`number`,`orderinfo`.`pid`,`orderinfo`.`order_company`,`orderinfo`.`order_connect`,`orderinfo`.`order_phone`,`orderinfo`.`kehu_id`,`orderinfo`.`price`,`orderinfo`.`material_id`,`orderinfo`.`pProductinfo_id`,`orderinfo`.`productinfo_id`,`orderinfo`.`order_type`,`orderinfo`.`order_status`,`orderinfo`.`all_order_status`,`orderinfo`.`shengchan_status`,`orderinfo`.`zuixinshuoming`,`orderinfo`.`guzhangshu`,`orderinfo`.`zuixinguzhang`,`orderinfo`.`techprocess_id`,`orderinfo`.`actual_amount`,`orderinfo`.`kucun_amount`,`orderinfo`.`produce_amount`,`orderinfo`.`produced_amount`,`orderinfo`.`waste_amount`,`orderinfo`.`produced_time`,`orderinfo`.`send_amount`,`orderinfo`.`ruku_posi`,`orderinfo`.`sent_amount`,`orderinfo`.`out_time`,`orderinfo`.`build_order_staffid`,`orderinfo`.`factorymge_id`,`orderinfo`.`admin_id`,`orderinfo`.`remind_day`,`orderinfo`.`build_time`,`orderinfo`.`end_time`,`orderinfo`.`responsible_staffinfos`,`orderinfo`.`responsible_staffinfovars`,`orderinfo`.`feedback`,`orderinfo`.`guoqitime`,`orderinfo`.`guoqi_status`,`orderinfo`.`put_position`,`orderinfo`.`createtime`,`orderinfo`.`updatetime`,`orderinfo`.`is_modify`,`orderinfo`.`purchaseorder_id`,factorymge.id AS factorymge__id,factorymge.name AS factorymge__name,factorymge.connect_name AS factorymge__connect_name,factorymge.phone_num AS factorymge__phone_num,factorymge.fax_num AS factorymge__fax_num,factorymge.build_order_yuan AS factorymge__build_order_yuan,factorymge.operator AS factorymge__operator,factorymge.city AS factorymge__city,factorymge.address AS factorymge__address,factorymge.en_switch AS factorymge__en_switch,factorymge.admin_id AS factorymge__admin_id,factorymge.createtime AS factorymge__createtime,factorymge.updatetime AS factorymge__updatetime,productinfo.id AS productinfo__id,productinfo.product_avatar AS productinfo__product_avatar,productinfo.name AS productinfo__name,productinfo.product_num AS productinfo__product_num,productinfo.kucun AS productinfo__kucun,productinfo.takeup_kucun AS productinfo__takeup_kucun,productinfo.staff_ids AS productinfo__staff_ids,productinfo.staff_names AS productinfo__staff_names,productinfo.pid AS productinfo__pid,productinfo.corresponding_num AS productinfo__corresponding_num,productinfo.position AS productinfo__position,productinfo.price AS productinfo__price,productinfo.factorymge_id AS productinfo__factorymge_id,productinfo.product_status AS productinfo__product_status,productinfo.admin_id AS productinfo__admin_id,productinfo.createtime AS productinfo__createtime,productinfo.updatetime AS productinfo__updatetime,sum(orderinfo.send_amount*orderinfo.price) as total FROM `ot_orderinfo` `orderinfo` LEFT JOIN `ot_factorymge` `factorymge` ON `orderinfo`.`factorymge_id`=`factorymge`.`id` LEFT JOIN `ot_productinfo` `productinfo` ON `orderinfo`.`productinfo_id`=`productinfo`.`id` WHERE ( orderinfo.factorymge_id = 19 ) AND ( orderinfo.pid != 0 ) AND ( orderinfo.actual_amount > 0 ) AND ( orderinfo.order_status in ("1","2") ) AND ( orderinfo.produced_time = 0 ) LIMIT 1 [ RunTime:0.086196s ] [ sql ] [ SQL ] SELECT `productinfo`.`id`,`productinfo`.`product_avatar`,`productinfo`.`name`,`productinfo`.`product_num`,`productinfo`.`kucun`,`productinfo`.`takeup_kucun`,`productinfo`.`staff_ids`,`productinfo`.`staff_names`,`productinfo`.`pid`,`productinfo`.`corresponding_num`,`productinfo`.`position`,`productinfo`.`price`,`productinfo`.`factorymge_id`,`productinfo`.`product_status`,`productinfo`.`admin_id`,`productinfo`.`createtime`,`productinfo`.`updatetime`,factorymge.id AS factorymge__id,factorymge.name AS factorymge__name,factorymge.connect_name AS factorymge__connect_name,factorymge.phone_num AS factorymge__phone_num,factorymge.fax_num AS factorymge__fax_num,factorymge.build_order_yuan AS factorymge__build_order_yuan,factorymge.operator AS factorymge__operator,factorymge.city AS factorymge__city,factorymge.address AS factorymge__address,factorymge.en_switch AS factorymge__en_switch,factorymge.admin_id AS factorymge__admin_id,factorymge.createtime AS factorymge__createtime,factorymge.updatetime AS factorymge__updatetime,sum(kucun*price) as total FROM `ot_productinfo` `productinfo` LEFT JOIN `ot_factorymge` `factorymge` ON `productinfo`.`factorymge_id`=`factorymge`.`id` WHERE ( factorymge_id=19 ) AND `product_status` = '1' LIMIT 1 [ RunTime:0.003584s ] [ sql ] [ SQL ] SELECT `material`.`id`,`material`.`name`,`material`.`number`,`material`.`avatar`,`material`.`amount`,`material`.`warn_amount`,`material`.`occupy_amount`,`material`.`factorymge_id`,`material`.`is_stop_status`,`material`.`admin_id`,`material`.`price`,`material`.`danwei`,`material`.`quehuo_status`,`material`.`put_position`,`material`.`is_has_sup`,`material`.`staff_ids`,`material`.`staff_names`,`material`.`createtime`,`material`.`updatetime`,`material`.`is_delete`,factorymge.id AS factorymge__id,factorymge.name AS factorymge__name,factorymge.connect_name AS factorymge__connect_name,factorymge.phone_num AS factorymge__phone_num,factorymge.fax_num AS factorymge__fax_num,factorymge.build_order_yuan AS factorymge__build_order_yuan,factorymge.operator AS factorymge__operator,factorymge.city AS factorymge__city,factorymge.address AS factorymge__address,factorymge.en_switch AS factorymge__en_switch,factorymge.admin_id AS factorymge__admin_id,factorymge.createtime AS factorymge__createtime,factorymge.updatetime AS factorymge__updatetime,sum(amount*price) as total FROM `ot_material` `material` LEFT JOIN `ot_factorymge` `factorymge` ON `material`.`factorymge_id`=`factorymge`.`id` WHERE ( factorymge_id=19 ) LIMIT 1 [ RunTime:0.001020s ] [ sql ] [ SQL ] UPDATE `ot_zichan` SET `carmaterialcountprice`=2520,`carmaterialcountpricediffer`=0,`countpricediffer`=0,`shoudbeshoucountprice`=0,`productcountprice`=122782.8,`lingcountprice`=173869.05,`shoudbefucountprice`=0,`xianjin`=0,`countprice`=299171.85 WHERE `id` = 26167 [ RunTime:0.005671s ] [ sql ] [ SQL ] SELECT * FROM `ot_zichan` WHERE `factorymge_id` = 26 AND `year` = 2026 AND `month` = 10 AND `day` = 5 LIMIT 1 [ RunTime:0.018400s ] [ sql ] [ SQL ] SELECT * FROM `ot_zichan` WHERE `factorymge_id` = 26 AND `year` = 2026 AND `month` = 10 AND `day` = 6 LIMIT 1 [ RunTime:0.017269s ] [ sql ] [ SQL ] SELECT `orderinfo`.`id` FROM `ot_orderinfo` `orderinfo` LEFT JOIN `ot_factorymge` `factorymge` ON `orderinfo`.`factorymge_id`=`factorymge`.`id` LEFT JOIN `ot_productinfo` `productinfo` ON `orderinfo`.`productinfo_id`=`productinfo`.`id` WHERE ( orderinfo.factorymge_id = 26 ) AND ( orderinfo.pid = 0 ) AND ( orderinfo.actual_amount > 0 ) AND ( orderinfo.order_status in ("1","2") ) [ RunTime:0.026135s ] [ sql ] [ SQL ] SELECT sum(quantity*price) as total FROM `ot_orderandmaterial` WHERE `orderinfo_id` IN (60042,60159,60257,60258,60265,60266,60333,60334) LIMIT 1 [ RunTime:0.002137s ] [ sql ] [ SQL ] SELECT `orderinfo`.`id`,`orderinfo`.`nei_number`,`orderinfo`.`number`,`orderinfo`.`pid`,`orderinfo`.`order_company`,`orderinfo`.`order_connect`,`orderinfo`.`order_phone`,`orderinfo`.`kehu_id`,`orderinfo`.`price`,`orderinfo`.`material_id`,`orderinfo`.`pProductinfo_id`,`orderinfo`.`productinfo_id`,`orderinfo`.`order_type`,`orderinfo`.`order_status`,`orderinfo`.`all_order_status`,`orderinfo`.`shengchan_status`,`orderinfo`.`zuixinshuoming`,`orderinfo`.`guzhangshu`,`orderinfo`.`zuixinguzhang`,`orderinfo`.`techprocess_id`,`orderinfo`.`actual_amount`,`orderinfo`.`kucun_amount`,`orderinfo`.`produce_amount`,`orderinfo`.`produced_amount`,`orderinfo`.`waste_amount`,`orderinfo`.`produced_time`,`orderinfo`.`send_amount`,`orderinfo`.`ruku_posi`,`orderinfo`.`sent_amount`,`orderinfo`.`out_time`,`orderinfo`.`build_order_staffid`,`orderinfo`.`factorymge_id`,`orderinfo`.`admin_id`,`orderinfo`.`remind_day`,`orderinfo`.`build_time`,`orderinfo`.`end_time`,`orderinfo`.`responsible_staffinfos`,`orderinfo`.`responsible_staffinfovars`,`orderinfo`.`feedback`,`orderinfo`.`guoqitime`,`orderinfo`.`guoqi_status`,`orderinfo`.`put_position`,`orderinfo`.`createtime`,`orderinfo`.`updatetime`,`orderinfo`.`is_modify`,`orderinfo`.`purchaseorder_id`,factorymge.id AS factorymge__id,factorymge.name AS factorymge__name,factorymge.connect_name AS factorymge__connect_name,factorymge.phone_num AS factorymge__phone_num,factorymge.fax_num AS factorymge__fax_num,factorymge.build_order_yuan AS factorymge__build_order_yuan,factorymge.operator AS factorymge__operator,factorymge.city AS factorymge__city,factorymge.address AS factorymge__address,factorymge.en_switch AS factorymge__en_switch,factorymge.admin_id AS factorymge__admin_id,factorymge.createtime AS factorymge__createtime,factorymge.updatetime AS factorymge__updatetime,productinfo.id AS productinfo__id,productinfo.product_avatar AS productinfo__product_avatar,productinfo.name AS productinfo__name,productinfo.product_num AS productinfo__product_num,productinfo.kucun AS productinfo__kucun,productinfo.takeup_kucun AS productinfo__takeup_kucun,productinfo.staff_ids AS productinfo__staff_ids,productinfo.staff_names AS productinfo__staff_names,productinfo.pid AS productinfo__pid,productinfo.corresponding_num AS productinfo__corresponding_num,productinfo.position AS productinfo__position,productinfo.price AS productinfo__price,productinfo.factorymge_id AS productinfo__factorymge_id,productinfo.product_status AS productinfo__product_status,productinfo.admin_id AS productinfo__admin_id,productinfo.createtime AS productinfo__createtime,productinfo.updatetime AS productinfo__updatetime,sum(orderinfo.send_amount*orderinfo.price) as total FROM `ot_orderinfo` `orderinfo` LEFT JOIN `ot_factorymge` `factorymge` ON `orderinfo`.`factorymge_id`=`factorymge`.`id` LEFT JOIN `ot_productinfo` `productinfo` ON `orderinfo`.`productinfo_id`=`productinfo`.`id` WHERE ( orderinfo.factorymge_id = 26 ) AND ( orderinfo.pid != 0 ) AND ( orderinfo.actual_amount > 0 ) AND ( orderinfo.order_status in ("1","2") ) AND ( orderinfo.produced_time = 0 ) LIMIT 1 [ RunTime:0.072381s ] [ sql ] [ SQL ] SELECT `productinfo`.`id`,`productinfo`.`product_avatar`,`productinfo`.`name`,`productinfo`.`product_num`,`productinfo`.`kucun`,`productinfo`.`takeup_kucun`,`productinfo`.`staff_ids`,`productinfo`.`staff_names`,`productinfo`.`pid`,`productinfo`.`corresponding_num`,`productinfo`.`position`,`productinfo`.`price`,`productinfo`.`factorymge_id`,`productinfo`.`product_status`,`productinfo`.`admin_id`,`productinfo`.`createtime`,`productinfo`.`updatetime`,factorymge.id AS factorymge__id,factorymge.name AS factorymge__name,factorymge.connect_name AS factorymge__connect_name,factorymge.phone_num AS factorymge__phone_num,factorymge.fax_num AS factorymge__fax_num,factorymge.build_order_yuan AS factorymge__build_order_yuan,factorymge.operator AS factorymge__operator,factorymge.city AS factorymge__city,factorymge.address AS factorymge__address,factorymge.en_switch AS factorymge__en_switch,factorymge.admin_id AS factorymge__admin_id,factorymge.createtime AS factorymge__createtime,factorymge.updatetime AS factorymge__updatetime,sum(kucun*price) as total FROM `ot_productinfo` `productinfo` LEFT JOIN `ot_factorymge` `factorymge` ON `productinfo`.`factorymge_id`=`factorymge`.`id` WHERE ( factorymge_id=26 ) AND `product_status` = '1' LIMIT 1 [ RunTime:0.003246s ] [ sql ] [ SQL ] SELECT `material`.`id`,`material`.`name`,`material`.`number`,`material`.`avatar`,`material`.`amount`,`material`.`warn_amount`,`material`.`occupy_amount`,`material`.`factorymge_id`,`material`.`is_stop_status`,`material`.`admin_id`,`material`.`price`,`material`.`danwei`,`material`.`quehuo_status`,`material`.`put_position`,`material`.`is_has_sup`,`material`.`staff_ids`,`material`.`staff_names`,`material`.`createtime`,`material`.`updatetime`,`material`.`is_delete`,factorymge.id AS factorymge__id,factorymge.name AS factorymge__name,factorymge.connect_name AS factorymge__connect_name,factorymge.phone_num AS factorymge__phone_num,factorymge.fax_num AS factorymge__fax_num,factorymge.build_order_yuan AS factorymge__build_order_yuan,factorymge.operator AS factorymge__operator,factorymge.city AS factorymge__city,factorymge.address AS factorymge__address,factorymge.en_switch AS factorymge__en_switch,factorymge.admin_id AS factorymge__admin_id,factorymge.createtime AS factorymge__createtime,factorymge.updatetime AS factorymge__updatetime,sum(amount*price) as total FROM `ot_material` `material` LEFT JOIN `ot_factorymge` `factorymge` ON `material`.`factorymge_id`=`factorymge`.`id` WHERE ( factorymge_id=26 ) LIMIT 1 [ RunTime:0.000894s ] [ sql ] [ SQL ] UPDATE `ot_zichan` SET `carmaterialcountprice`=170.4,`carmaterialcountpricediffer`=0,`countpricediffer`=6049.7,`shoudbeshoucountprice`=0,`productcountprice`=3682854,`lingcountprice`=1594438.15,`shoudbefucountprice`=0,`xianjin`=0,`countprice`=5277462.55 WHERE `id` = 26168 [ RunTime:0.006490s ] [ sql ] [ SQL ] SELECT * FROM `ot_zichan` WHERE `factorymge_id` = 27 AND `year` = 2026 AND `month` = 10 AND `day` = 5 LIMIT 1 [ RunTime:0.018061s ] [ sql ] [ SQL ] SELECT * FROM `ot_zichan` WHERE `factorymge_id` = 27 AND `year` = 2026 AND `month` = 10 AND `day` = 6 LIMIT 1 [ RunTime:0.018134s ] [ sql ] [ SQL ] SELECT `orderinfo`.`id` FROM `ot_orderinfo` `orderinfo` LEFT JOIN `ot_factorymge` `factorymge` ON `orderinfo`.`factorymge_id`=`factorymge`.`id` LEFT JOIN `ot_productinfo` `productinfo` ON `orderinfo`.`productinfo_id`=`productinfo`.`id` WHERE ( orderinfo.factorymge_id = 27 ) AND ( orderinfo.pid = 0 ) AND ( orderinfo.actual_amount > 0 ) AND ( orderinfo.order_status in ("1","2") ) [ RunTime:0.024787s ] [ sql ] [ SQL ] SELECT sum(quantity*price) as total FROM `ot_orderandmaterial` WHERE `orderinfo_id` IN ('') LIMIT 1 [ RunTime:0.001848s ] [ sql ] [ SQL ] SELECT `orderinfo`.`id`,`orderinfo`.`nei_number`,`orderinfo`.`number`,`orderinfo`.`pid`,`orderinfo`.`order_company`,`orderinfo`.`order_connect`,`orderinfo`.`order_phone`,`orderinfo`.`kehu_id`,`orderinfo`.`price`,`orderinfo`.`material_id`,`orderinfo`.`pProductinfo_id`,`orderinfo`.`productinfo_id`,`orderinfo`.`order_type`,`orderinfo`.`order_status`,`orderinfo`.`all_order_status`,`orderinfo`.`shengchan_status`,`orderinfo`.`zuixinshuoming`,`orderinfo`.`guzhangshu`,`orderinfo`.`zuixinguzhang`,`orderinfo`.`techprocess_id`,`orderinfo`.`actual_amount`,`orderinfo`.`kucun_amount`,`orderinfo`.`produce_amount`,`orderinfo`.`produced_amount`,`orderinfo`.`waste_amount`,`orderinfo`.`produced_time`,`orderinfo`.`send_amount`,`orderinfo`.`ruku_posi`,`orderinfo`.`sent_amount`,`orderinfo`.`out_time`,`orderinfo`.`build_order_staffid`,`orderinfo`.`factorymge_id`,`orderinfo`.`admin_id`,`orderinfo`.`remind_day`,`orderinfo`.`build_time`,`orderinfo`.`end_time`,`orderinfo`.`responsible_staffinfos`,`orderinfo`.`responsible_staffinfovars`,`orderinfo`.`feedback`,`orderinfo`.`guoqitime`,`orderinfo`.`guoqi_status`,`orderinfo`.`put_position`,`orderinfo`.`createtime`,`orderinfo`.`updatetime`,`orderinfo`.`is_modify`,`orderinfo`.`purchaseorder_id`,factorymge.id AS factorymge__id,factorymge.name AS factorymge__name,factorymge.connect_name AS factorymge__connect_name,factorymge.phone_num AS factorymge__phone_num,factorymge.fax_num AS factorymge__fax_num,factorymge.build_order_yuan AS factorymge__build_order_yuan,factorymge.operator AS factorymge__operator,factorymge.city AS factorymge__city,factorymge.address AS factorymge__address,factorymge.en_switch AS factorymge__en_switch,factorymge.admin_id AS factorymge__admin_id,factorymge.createtime AS factorymge__createtime,factorymge.updatetime AS factorymge__updatetime,productinfo.id AS productinfo__id,productinfo.product_avatar AS productinfo__product_avatar,productinfo.name AS productinfo__name,productinfo.product_num AS productinfo__product_num,productinfo.kucun AS productinfo__kucun,productinfo.takeup_kucun AS productinfo__takeup_kucun,productinfo.staff_ids AS productinfo__staff_ids,productinfo.staff_names AS productinfo__staff_names,productinfo.pid AS productinfo__pid,productinfo.corresponding_num AS productinfo__corresponding_num,productinfo.position AS productinfo__position,productinfo.price AS productinfo__price,productinfo.factorymge_id AS productinfo__factorymge_id,productinfo.product_status AS productinfo__product_status,productinfo.admin_id AS productinfo__admin_id,productinfo.createtime AS productinfo__createtime,productinfo.updatetime AS productinfo__updatetime,sum(orderinfo.send_amount*orderinfo.price) as total FROM `ot_orderinfo` `orderinfo` LEFT JOIN `ot_factorymge` `factorymge` ON `orderinfo`.`factorymge_id`=`factorymge`.`id` LEFT JOIN `ot_productinfo` `productinfo` ON `orderinfo`.`productinfo_id`=`productinfo`.`id` WHERE ( orderinfo.factorymge_id = 27 ) AND ( orderinfo.pid != 0 ) AND ( orderinfo.actual_amount > 0 ) AND ( orderinfo.order_status in ("1","2") ) AND ( orderinfo.produced_time = 0 ) LIMIT 1 [ RunTime:0.073337s ] [ sql ] [ SQL ] SELECT `productinfo`.`id`,`productinfo`.`product_avatar`,`productinfo`.`name`,`productinfo`.`product_num`,`productinfo`.`kucun`,`productinfo`.`takeup_kucun`,`productinfo`.`staff_ids`,`productinfo`.`staff_names`,`productinfo`.`pid`,`productinfo`.`corresponding_num`,`productinfo`.`position`,`productinfo`.`price`,`productinfo`.`factorymge_id`,`productinfo`.`product_status`,`productinfo`.`admin_id`,`productinfo`.`createtime`,`productinfo`.`updatetime`,factorymge.id AS factorymge__id,factorymge.name AS factorymge__name,factorymge.connect_name AS factorymge__connect_name,factorymge.phone_num AS factorymge__phone_num,factorymge.fax_num AS factorymge__fax_num,factorymge.build_order_yuan AS factorymge__build_order_yuan,factorymge.operator AS factorymge__operator,factorymge.city AS factorymge__city,factorymge.address AS factorymge__address,factorymge.en_switch AS factorymge__en_switch,factorymge.admin_id AS factorymge__admin_id,factorymge.createtime AS factorymge__createtime,factorymge.updatetime AS factorymge__updatetime,sum(kucun*price) as total FROM `ot_productinfo` `productinfo` LEFT JOIN `ot_factorymge` `factorymge` ON `productinfo`.`factorymge_id`=`factorymge`.`id` WHERE ( factorymge_id=27 ) AND `product_status` = '1' LIMIT 1 [ RunTime:0.002885s ] [ sql ] [ SQL ] SELECT `material`.`id`,`material`.`name`,`material`.`number`,`material`.`avatar`,`material`.`amount`,`material`.`warn_amount`,`material`.`occupy_amount`,`material`.`factorymge_id`,`material`.`is_stop_status`,`material`.`admin_id`,`material`.`price`,`material`.`danwei`,`material`.`quehuo_status`,`material`.`put_position`,`material`.`is_has_sup`,`material`.`staff_ids`,`material`.`staff_names`,`material`.`createtime`,`material`.`updatetime`,`material`.`is_delete`,factorymge.id AS factorymge__id,factorymge.name AS factorymge__name,factorymge.connect_name AS factorymge__connect_name,factorymge.phone_num AS factorymge__phone_num,factorymge.fax_num AS factorymge__fax_num,factorymge.build_order_yuan AS factorymge__build_order_yuan,factorymge.operator AS factorymge__operator,factorymge.city AS factorymge__city,factorymge.address AS factorymge__address,factorymge.en_switch AS factorymge__en_switch,factorymge.admin_id AS factorymge__admin_id,factorymge.createtime AS factorymge__createtime,factorymge.updatetime AS factorymge__updatetime,sum(amount*price) as total FROM `ot_material` `material` LEFT JOIN `ot_factorymge` `factorymge` ON `material`.`factorymge_id`=`factorymge`.`id` WHERE ( factorymge_id=27 ) LIMIT 1 [ RunTime:0.000721s ] [ sql ] [ SQL ] UPDATE `ot_zichan` SET `carmaterialcountprice`=0,`carmaterialcountpricediffer`=0,`countpricediffer`=0,`shoudbeshoucountprice`=0,`productcountprice`=NULL,`lingcountprice`=0,`shoudbefucountprice`=0,`xianjin`=0,`countprice`=0 WHERE `id` = 26169 [ RunTime:0.005320s ] [ sql ] [ SQL ] SELECT * FROM `ot_zichan` WHERE `factorymge_id` = 28 AND `year` = 2026 AND `month` = 10 AND `day` = 5 LIMIT 1 [ RunTime:0.017251s ] [ sql ] [ SQL ] SELECT * FROM `ot_zichan` WHERE `factorymge_id` = 28 AND `year` = 2026 AND `month` = 10 AND `day` = 6 LIMIT 1 [ RunTime:0.032863s ] [ sql ] [ SQL ] SELECT `orderinfo`.`id` FROM `ot_orderinfo` `orderinfo` LEFT JOIN `ot_factorymge` `factorymge` ON `orderinfo`.`factorymge_id`=`factorymge`.`id` LEFT JOIN `ot_productinfo` `productinfo` ON `orderinfo`.`productinfo_id`=`productinfo`.`id` WHERE ( orderinfo.factorymge_id = 28 ) AND ( orderinfo.pid = 0 ) AND ( orderinfo.actual_amount > 0 ) AND ( orderinfo.order_status in ("1","2") ) [ RunTime:0.032236s ] [ sql ] [ SQL ] SELECT sum(quantity*price) as total FROM `ot_orderandmaterial` WHERE `orderinfo_id` IN ('') LIMIT 1 [ RunTime:0.002215s ] [ sql ] [ SQL ] SELECT `orderinfo`.`id`,`orderinfo`.`nei_number`,`orderinfo`.`number`,`orderinfo`.`pid`,`orderinfo`.`order_company`,`orderinfo`.`order_connect`,`orderinfo`.`order_phone`,`orderinfo`.`kehu_id`,`orderinfo`.`price`,`orderinfo`.`material_id`,`orderinfo`.`pProductinfo_id`,`orderinfo`.`productinfo_id`,`orderinfo`.`order_type`,`orderinfo`.`order_status`,`orderinfo`.`all_order_status`,`orderinfo`.`shengchan_status`,`orderinfo`.`zuixinshuoming`,`orderinfo`.`guzhangshu`,`orderinfo`.`zuixinguzhang`,`orderinfo`.`techprocess_id`,`orderinfo`.`actual_amount`,`orderinfo`.`kucun_amount`,`orderinfo`.`produce_amount`,`orderinfo`.`produced_amount`,`orderinfo`.`waste_amount`,`orderinfo`.`produced_time`,`orderinfo`.`send_amount`,`orderinfo`.`ruku_posi`,`orderinfo`.`sent_amount`,`orderinfo`.`out_time`,`orderinfo`.`build_order_staffid`,`orderinfo`.`factorymge_id`,`orderinfo`.`admin_id`,`orderinfo`.`remind_day`,`orderinfo`.`build_time`,`orderinfo`.`end_time`,`orderinfo`.`responsible_staffinfos`,`orderinfo`.`responsible_staffinfovars`,`orderinfo`.`feedback`,`orderinfo`.`guoqitime`,`orderinfo`.`guoqi_status`,`orderinfo`.`put_position`,`orderinfo`.`createtime`,`orderinfo`.`updatetime`,`orderinfo`.`is_modify`,`orderinfo`.`purchaseorder_id`,factorymge.id AS factorymge__id,factorymge.name AS factorymge__name,factorymge.connect_name AS factorymge__connect_name,factorymge.phone_num AS factorymge__phone_num,factorymge.fax_num AS factorymge__fax_num,factorymge.build_order_yuan AS factorymge__build_order_yuan,factorymge.operator AS factorymge__operator,factorymge.city AS factorymge__city,factorymge.address AS factorymge__address,factorymge.en_switch AS factorymge__en_switch,factorymge.admin_id AS factorymge__admin_id,factorymge.createtime AS factorymge__createtime,factorymge.updatetime AS factorymge__updatetime,productinfo.id AS productinfo__id,productinfo.product_avatar AS productinfo__product_avatar,productinfo.name AS productinfo__name,productinfo.product_num AS productinfo__product_num,productinfo.kucun AS productinfo__kucun,productinfo.takeup_kucun AS productinfo__takeup_kucun,productinfo.staff_ids AS productinfo__staff_ids,productinfo.staff_names AS productinfo__staff_names,productinfo.pid AS productinfo__pid,productinfo.corresponding_num AS productinfo__corresponding_num,productinfo.position AS productinfo__position,productinfo.price AS productinfo__price,productinfo.factorymge_id AS productinfo__factorymge_id,productinfo.product_status AS productinfo__product_status,productinfo.admin_id AS productinfo__admin_id,productinfo.createtime AS productinfo__createtime,productinfo.updatetime AS productinfo__updatetime,sum(orderinfo.send_amount*orderinfo.price) as total FROM `ot_orderinfo` `orderinfo` LEFT JOIN `ot_factorymge` `factorymge` ON `orderinfo`.`factorymge_id`=`factorymge`.`id` LEFT JOIN `ot_productinfo` `productinfo` ON `orderinfo`.`productinfo_id`=`productinfo`.`id` WHERE ( orderinfo.factorymge_id = 28 ) AND ( orderinfo.pid != 0 ) AND ( orderinfo.actual_amount > 0 ) AND ( orderinfo.order_status in ("1","2") ) AND ( orderinfo.produced_time = 0 ) LIMIT 1 [ RunTime:0.088159s ] [ sql ] [ SQL ] SELECT `productinfo`.`id`,`productinfo`.`product_avatar`,`productinfo`.`name`,`productinfo`.`product_num`,`productinfo`.`kucun`,`productinfo`.`takeup_kucun`,`productinfo`.`staff_ids`,`productinfo`.`staff_names`,`productinfo`.`pid`,`productinfo`.`corresponding_num`,`productinfo`.`position`,`productinfo`.`price`,`productinfo`.`factorymge_id`,`productinfo`.`product_status`,`productinfo`.`admin_id`,`productinfo`.`createtime`,`productinfo`.`updatetime`,factorymge.id AS factorymge__id,factorymge.name AS factorymge__name,factorymge.connect_name AS factorymge__connect_name,factorymge.phone_num AS factorymge__phone_num,factorymge.fax_num AS factorymge__fax_num,factorymge.build_order_yuan AS factorymge__build_order_yuan,factorymge.operator AS factorymge__operator,factorymge.city AS factorymge__city,factorymge.address AS factorymge__address,factorymge.en_switch AS factorymge__en_switch,factorymge.admin_id AS factorymge__admin_id,factorymge.createtime AS factorymge__createtime,factorymge.updatetime AS factorymge__updatetime,sum(kucun*price) as total FROM `ot_productinfo` `productinfo` LEFT JOIN `ot_factorymge` `factorymge` ON `productinfo`.`factorymge_id`=`factorymge`.`id` WHERE ( factorymge_id=28 ) AND `product_status` = '1' LIMIT 1 [ RunTime:0.003351s ] [ sql ] [ SQL ] SELECT `material`.`id`,`material`.`name`,`material`.`number`,`material`.`avatar`,`material`.`amount`,`material`.`warn_amount`,`material`.`occupy_amount`,`material`.`factorymge_id`,`material`.`is_stop_status`,`material`.`admin_id`,`material`.`price`,`material`.`danwei`,`material`.`quehuo_status`,`material`.`put_position`,`material`.`is_has_sup`,`material`.`staff_ids`,`material`.`staff_names`,`material`.`createtime`,`material`.`updatetime`,`material`.`is_delete`,factorymge.id AS factorymge__id,factorymge.name AS factorymge__name,factorymge.connect_name AS factorymge__connect_name,factorymge.phone_num AS factorymge__phone_num,factorymge.fax_num AS factorymge__fax_num,factorymge.build_order_yuan AS factorymge__build_order_yuan,factorymge.operator AS factorymge__operator,factorymge.city AS factorymge__city,factorymge.address AS factorymge__address,factorymge.en_switch AS factorymge__en_switch,factorymge.admin_id AS factorymge__admin_id,factorymge.createtime AS factorymge__createtime,factorymge.updatetime AS factorymge__updatetime,sum(amount*price) as total FROM `ot_material` `material` LEFT JOIN `ot_factorymge` `factorymge` ON `material`.`factorymge_id`=`factorymge`.`id` WHERE ( factorymge_id=28 ) LIMIT 1 [ RunTime:0.000615s ] [ sql ] [ SQL ] UPDATE `ot_zichan` SET `carmaterialcountprice`=0,`carmaterialcountpricediffer`=0,`countpricediffer`=0,`shoudbeshoucountprice`=0,`productcountprice`=NULL,`lingcountprice`=0,`shoudbefucountprice`=0,`xianjin`=0,`countprice`=0 WHERE `id` = 26170 [ RunTime:0.004609s ] [ sql ] [ SQL ] SELECT * FROM `ot_zichan` WHERE `factorymge_id` = 29 AND `year` = 2026 AND `month` = 10 AND `day` = 5 LIMIT 1 [ RunTime:0.018265s ] [ sql ] [ SQL ] SELECT * FROM `ot_zichan` WHERE `factorymge_id` = 29 AND `year` = 2026 AND `month` = 10 AND `day` = 6 LIMIT 1 [ RunTime:0.022143s ] [ sql ] [ SQL ] SELECT `orderinfo`.`id` FROM `ot_orderinfo` `orderinfo` LEFT JOIN `ot_factorymge` `factorymge` ON `orderinfo`.`factorymge_id`=`factorymge`.`id` LEFT JOIN `ot_productinfo` `productinfo` ON `orderinfo`.`productinfo_id`=`productinfo`.`id` WHERE ( orderinfo.factorymge_id = 29 ) AND ( orderinfo.pid = 0 ) AND ( orderinfo.actual_amount > 0 ) AND ( orderinfo.order_status in ("1","2") ) [ RunTime:0.027683s ] [ sql ] [ SQL ] SELECT sum(quantity*price) as total FROM `ot_orderandmaterial` WHERE `orderinfo_id` IN ('') LIMIT 1 [ RunTime:0.002085s ] [ sql ] [ SQL ] SELECT `orderinfo`.`id`,`orderinfo`.`nei_number`,`orderinfo`.`number`,`orderinfo`.`pid`,`orderinfo`.`order_company`,`orderinfo`.`order_connect`,`orderinfo`.`order_phone`,`orderinfo`.`kehu_id`,`orderinfo`.`price`,`orderinfo`.`material_id`,`orderinfo`.`pProductinfo_id`,`orderinfo`.`productinfo_id`,`orderinfo`.`order_type`,`orderinfo`.`order_status`,`orderinfo`.`all_order_status`,`orderinfo`.`shengchan_status`,`orderinfo`.`zuixinshuoming`,`orderinfo`.`guzhangshu`,`orderinfo`.`zuixinguzhang`,`orderinfo`.`techprocess_id`,`orderinfo`.`actual_amount`,`orderinfo`.`kucun_amount`,`orderinfo`.`produce_amount`,`orderinfo`.`produced_amount`,`orderinfo`.`waste_amount`,`orderinfo`.`produced_time`,`orderinfo`.`send_amount`,`orderinfo`.`ruku_posi`,`orderinfo`.`sent_amount`,`orderinfo`.`out_time`,`orderinfo`.`build_order_staffid`,`orderinfo`.`factorymge_id`,`orderinfo`.`admin_id`,`orderinfo`.`remind_day`,`orderinfo`.`build_time`,`orderinfo`.`end_time`,`orderinfo`.`responsible_staffinfos`,`orderinfo`.`responsible_staffinfovars`,`orderinfo`.`feedback`,`orderinfo`.`guoqitime`,`orderinfo`.`guoqi_status`,`orderinfo`.`put_position`,`orderinfo`.`createtime`,`orderinfo`.`updatetime`,`orderinfo`.`is_modify`,`orderinfo`.`purchaseorder_id`,factorymge.id AS factorymge__id,factorymge.name AS factorymge__name,factorymge.connect_name AS factorymge__connect_name,factorymge.phone_num AS factorymge__phone_num,factorymge.fax_num AS factorymge__fax_num,factorymge.build_order_yuan AS factorymge__build_order_yuan,factorymge.operator AS factorymge__operator,factorymge.city AS factorymge__city,factorymge.address AS factorymge__address,factorymge.en_switch AS factorymge__en_switch,factorymge.admin_id AS factorymge__admin_id,factorymge.createtime AS factorymge__createtime,factorymge.updatetime AS factorymge__updatetime,productinfo.id AS productinfo__id,productinfo.product_avatar AS productinfo__product_avatar,productinfo.name AS productinfo__name,productinfo.product_num AS productinfo__product_num,productinfo.kucun AS productinfo__kucun,productinfo.takeup_kucun AS productinfo__takeup_kucun,productinfo.staff_ids AS productinfo__staff_ids,productinfo.staff_names AS productinfo__staff_names,productinfo.pid AS productinfo__pid,productinfo.corresponding_num AS productinfo__corresponding_num,productinfo.position AS productinfo__position,productinfo.price AS productinfo__price,productinfo.factorymge_id AS productinfo__factorymge_id,productinfo.product_status AS productinfo__product_status,productinfo.admin_id AS productinfo__admin_id,productinfo.createtime AS productinfo__createtime,productinfo.updatetime AS productinfo__updatetime,sum(orderinfo.send_amount*orderinfo.price) as total FROM `ot_orderinfo` `orderinfo` LEFT JOIN `ot_factorymge` `factorymge` ON `orderinfo`.`factorymge_id`=`factorymge`.`id` LEFT JOIN `ot_productinfo` `productinfo` ON `orderinfo`.`productinfo_id`=`productinfo`.`id` WHERE ( orderinfo.factorymge_id = 29 ) AND ( orderinfo.pid != 0 ) AND ( orderinfo.actual_amount > 0 ) AND ( orderinfo.order_status in ("1","2") ) AND ( orderinfo.produced_time = 0 ) LIMIT 1 [ RunTime:0.090293s ] [ sql ] [ SQL ] SELECT `productinfo`.`id`,`productinfo`.`product_avatar`,`productinfo`.`name`,`productinfo`.`product_num`,`productinfo`.`kucun`,`productinfo`.`takeup_kucun`,`productinfo`.`staff_ids`,`productinfo`.`staff_names`,`productinfo`.`pid`,`productinfo`.`corresponding_num`,`productinfo`.`position`,`productinfo`.`price`,`productinfo`.`factorymge_id`,`productinfo`.`product_status`,`productinfo`.`admin_id`,`productinfo`.`createtime`,`productinfo`.`updatetime`,factorymge.id AS factorymge__id,factorymge.name AS factorymge__name,factorymge.connect_name AS factorymge__connect_name,factorymge.phone_num AS factorymge__phone_num,factorymge.fax_num AS factorymge__fax_num,factorymge.build_order_yuan AS factorymge__build_order_yuan,factorymge.operator AS factorymge__operator,factorymge.city AS factorymge__city,factorymge.address AS factorymge__address,factorymge.en_switch AS factorymge__en_switch,factorymge.admin_id AS factorymge__admin_id,factorymge.createtime AS factorymge__createtime,factorymge.updatetime AS factorymge__updatetime,sum(kucun*price) as total FROM `ot_productinfo` `productinfo` LEFT JOIN `ot_factorymge` `factorymge` ON `productinfo`.`factorymge_id`=`factorymge`.`id` WHERE ( factorymge_id=29 ) AND `product_status` = '1' LIMIT 1 [ RunTime:0.004688s ] [ sql ] [ SQL ] SELECT `material`.`id`,`material`.`name`,`material`.`number`,`material`.`avatar`,`material`.`amount`,`material`.`warn_amount`,`material`.`occupy_amount`,`material`.`factorymge_id`,`material`.`is_stop_status`,`material`.`admin_id`,`material`.`price`,`material`.`danwei`,`material`.`quehuo_status`,`material`.`put_position`,`material`.`is_has_sup`,`material`.`staff_ids`,`material`.`staff_names`,`material`.`createtime`,`material`.`updatetime`,`material`.`is_delete`,factorymge.id AS factorymge__id,factorymge.name AS factorymge__name,factorymge.connect_name AS factorymge__connect_name,factorymge.phone_num AS factorymge__phone_num,factorymge.fax_num AS factorymge__fax_num,factorymge.build_order_yuan AS factorymge__build_order_yuan,factorymge.operator AS factorymge__operator,factorymge.city AS factorymge__city,factorymge.address AS factorymge__address,factorymge.en_switch AS factorymge__en_switch,factorymge.admin_id AS factorymge__admin_id,factorymge.createtime AS factorymge__createtime,factorymge.updatetime AS factorymge__updatetime,sum(amount*price) as total FROM `ot_material` `material` LEFT JOIN `ot_factorymge` `factorymge` ON `material`.`factorymge_id`=`factorymge`.`id` WHERE ( factorymge_id=29 ) LIMIT 1 [ RunTime:0.000794s ] [ sql ] [ SQL ] UPDATE `ot_zichan` SET `carmaterialcountprice`=0,`carmaterialcountpricediffer`=0,`countpricediffer`=0,`shoudbeshoucountprice`=0,`productcountprice`=NULL,`lingcountprice`=NULL,`shoudbefucountprice`=0,`xianjin`=0,`countprice`=0 WHERE `id` = 26171 [ RunTime:0.005890s ] [ sql ] [ SQL ] SELECT * FROM `ot_zichan` WHERE `factorymge_id` = 30 AND `year` = 2026 AND `month` = 10 AND `day` = 5 LIMIT 1 [ RunTime:0.024424s ] [ sql ] [ SQL ] SELECT * FROM `ot_zichan` WHERE `factorymge_id` = 30 AND `year` = 2026 AND `month` = 10 AND `day` = 6 LIMIT 1 [ RunTime:0.020531s ] [ sql ] [ SQL ] SELECT `orderinfo`.`id` FROM `ot_orderinfo` `orderinfo` LEFT JOIN `ot_factorymge` `factorymge` ON `orderinfo`.`factorymge_id`=`factorymge`.`id` LEFT JOIN `ot_productinfo` `productinfo` ON `orderinfo`.`productinfo_id`=`productinfo`.`id` WHERE ( orderinfo.factorymge_id = 30 ) AND ( orderinfo.pid = 0 ) AND ( orderinfo.actual_amount > 0 ) AND ( orderinfo.order_status in ("1","2") ) [ RunTime:0.032057s ] [ sql ] [ SQL ] SELECT sum(quantity*price) as total FROM `ot_orderandmaterial` WHERE `orderinfo_id` IN ('') LIMIT 1 [ RunTime:0.002492s ] [ sql ] [ SQL ] SELECT `orderinfo`.`id`,`orderinfo`.`nei_number`,`orderinfo`.`number`,`orderinfo`.`pid`,`orderinfo`.`order_company`,`orderinfo`.`order_connect`,`orderinfo`.`order_phone`,`orderinfo`.`kehu_id`,`orderinfo`.`price`,`orderinfo`.`material_id`,`orderinfo`.`pProductinfo_id`,`orderinfo`.`productinfo_id`,`orderinfo`.`order_type`,`orderinfo`.`order_status`,`orderinfo`.`all_order_status`,`orderinfo`.`shengchan_status`,`orderinfo`.`zuixinshuoming`,`orderinfo`.`guzhangshu`,`orderinfo`.`zuixinguzhang`,`orderinfo`.`techprocess_id`,`orderinfo`.`actual_amount`,`orderinfo`.`kucun_amount`,`orderinfo`.`produce_amount`,`orderinfo`.`produced_amount`,`orderinfo`.`waste_amount`,`orderinfo`.`produced_time`,`orderinfo`.`send_amount`,`orderinfo`.`ruku_posi`,`orderinfo`.`sent_amount`,`orderinfo`.`out_time`,`orderinfo`.`build_order_staffid`,`orderinfo`.`factorymge_id`,`orderinfo`.`admin_id`,`orderinfo`.`remind_day`,`orderinfo`.`build_time`,`orderinfo`.`end_time`,`orderinfo`.`responsible_staffinfos`,`orderinfo`.`responsible_staffinfovars`,`orderinfo`.`feedback`,`orderinfo`.`guoqitime`,`orderinfo`.`guoqi_status`,`orderinfo`.`put_position`,`orderinfo`.`createtime`,`orderinfo`.`updatetime`,`orderinfo`.`is_modify`,`orderinfo`.`purchaseorder_id`,factorymge.id AS factorymge__id,factorymge.name AS factorymge__name,factorymge.connect_name AS factorymge__connect_name,factorymge.phone_num AS factorymge__phone_num,factorymge.fax_num AS factorymge__fax_num,factorymge.build_order_yuan AS factorymge__build_order_yuan,factorymge.operator AS factorymge__operator,factorymge.city AS factorymge__city,factorymge.address AS factorymge__address,factorymge.en_switch AS factorymge__en_switch,factorymge.admin_id AS factorymge__admin_id,factorymge.createtime AS factorymge__createtime,factorymge.updatetime AS factorymge__updatetime,productinfo.id AS productinfo__id,productinfo.product_avatar AS productinfo__product_avatar,productinfo.name AS productinfo__name,productinfo.product_num AS productinfo__product_num,productinfo.kucun AS productinfo__kucun,productinfo.takeup_kucun AS productinfo__takeup_kucun,productinfo.staff_ids AS productinfo__staff_ids,productinfo.staff_names AS productinfo__staff_names,productinfo.pid AS productinfo__pid,productinfo.corresponding_num AS productinfo__corresponding_num,productinfo.position AS productinfo__position,productinfo.price AS productinfo__price,productinfo.factorymge_id AS productinfo__factorymge_id,productinfo.product_status AS productinfo__product_status,productinfo.admin_id AS productinfo__admin_id,productinfo.createtime AS productinfo__createtime,productinfo.updatetime AS productinfo__updatetime,sum(orderinfo.send_amount*orderinfo.price) as total FROM `ot_orderinfo` `orderinfo` LEFT JOIN `ot_factorymge` `factorymge` ON `orderinfo`.`factorymge_id`=`factorymge`.`id` LEFT JOIN `ot_productinfo` `productinfo` ON `orderinfo`.`productinfo_id`=`productinfo`.`id` WHERE ( orderinfo.factorymge_id = 30 ) AND ( orderinfo.pid != 0 ) AND ( orderinfo.actual_amount > 0 ) AND ( orderinfo.order_status in ("1","2") ) AND ( orderinfo.produced_time = 0 ) LIMIT 1 [ RunTime:0.082126s ] [ sql ] [ SQL ] SELECT `productinfo`.`id`,`productinfo`.`product_avatar`,`productinfo`.`name`,`productinfo`.`product_num`,`productinfo`.`kucun`,`productinfo`.`takeup_kucun`,`productinfo`.`staff_ids`,`productinfo`.`staff_names`,`productinfo`.`pid`,`productinfo`.`corresponding_num`,`productinfo`.`position`,`productinfo`.`price`,`productinfo`.`factorymge_id`,`productinfo`.`product_status`,`productinfo`.`admin_id`,`productinfo`.`createtime`,`productinfo`.`updatetime`,factorymge.id AS factorymge__id,factorymge.name AS factorymge__name,factorymge.connect_name AS factorymge__connect_name,factorymge.phone_num AS factorymge__phone_num,factorymge.fax_num AS factorymge__fax_num,factorymge.build_order_yuan AS factorymge__build_order_yuan,factorymge.operator AS factorymge__operator,factorymge.city AS factorymge__city,factorymge.address AS factorymge__address,factorymge.en_switch AS factorymge__en_switch,factorymge.admin_id AS factorymge__admin_id,factorymge.createtime AS factorymge__createtime,factorymge.updatetime AS factorymge__updatetime,sum(kucun*price) as total FROM `ot_productinfo` `productinfo` LEFT JOIN `ot_factorymge` `factorymge` ON `productinfo`.`factorymge_id`=`factorymge`.`id` WHERE ( factorymge_id=30 ) AND `product_status` = '1' LIMIT 1 [ RunTime:0.003958s ] [ sql ] [ SQL ] SELECT `material`.`id`,`material`.`name`,`material`.`number`,`material`.`avatar`,`material`.`amount`,`material`.`warn_amount`,`material`.`occupy_amount`,`material`.`factorymge_id`,`material`.`is_stop_status`,`material`.`admin_id`,`material`.`price`,`material`.`danwei`,`material`.`quehuo_status`,`material`.`put_position`,`material`.`is_has_sup`,`material`.`staff_ids`,`material`.`staff_names`,`material`.`createtime`,`material`.`updatetime`,`material`.`is_delete`,factorymge.id AS factorymge__id,factorymge.name AS factorymge__name,factorymge.connect_name AS factorymge__connect_name,factorymge.phone_num AS factorymge__phone_num,factorymge.fax_num AS factorymge__fax_num,factorymge.build_order_yuan AS factorymge__build_order_yuan,factorymge.operator AS factorymge__operator,factorymge.city AS factorymge__city,factorymge.address AS factorymge__address,factorymge.en_switch AS factorymge__en_switch,factorymge.admin_id AS factorymge__admin_id,factorymge.createtime AS factorymge__createtime,factorymge.updatetime AS factorymge__updatetime,sum(amount*price) as total FROM `ot_material` `material` LEFT JOIN `ot_factorymge` `factorymge` ON `material`.`factorymge_id`=`factorymge`.`id` WHERE ( factorymge_id=30 ) LIMIT 1 [ RunTime:0.000921s ] [ sql ] [ SQL ] UPDATE `ot_zichan` SET `carmaterialcountprice`=0,`carmaterialcountpricediffer`=0,`countpricediffer`=0,`shoudbeshoucountprice`=0,`productcountprice`=NULL,`lingcountprice`=0,`shoudbefucountprice`=0,`xianjin`=0,`countprice`=0 WHERE `id` = 26172 [ RunTime:0.005400s ] [ sql ] [ SQL ] SELECT * FROM `ot_zichan` WHERE `factorymge_id` = 31 AND `year` = 2026 AND `month` = 10 AND `day` = 5 LIMIT 1 [ RunTime:0.019969s ] [ sql ] [ SQL ] SELECT * FROM `ot_zichan` WHERE `factorymge_id` = 31 AND `year` = 2026 AND `month` = 10 AND `day` = 6 LIMIT 1 [ RunTime:0.018971s ] [ sql ] [ SQL ] SELECT `orderinfo`.`id` FROM `ot_orderinfo` `orderinfo` LEFT JOIN `ot_factorymge` `factorymge` ON `orderinfo`.`factorymge_id`=`factorymge`.`id` LEFT JOIN `ot_productinfo` `productinfo` ON `orderinfo`.`productinfo_id`=`productinfo`.`id` WHERE ( orderinfo.factorymge_id = 31 ) AND ( orderinfo.pid = 0 ) AND ( orderinfo.actual_amount > 0 ) AND ( orderinfo.order_status in ("1","2") ) [ RunTime:0.030405s ] [ sql ] [ SQL ] SELECT sum(quantity*price) as total FROM `ot_orderandmaterial` WHERE `orderinfo_id` IN ('') LIMIT 1 [ RunTime:0.001774s ] [ sql ] [ SQL ] SELECT `orderinfo`.`id`,`orderinfo`.`nei_number`,`orderinfo`.`number`,`orderinfo`.`pid`,`orderinfo`.`order_company`,`orderinfo`.`order_connect`,`orderinfo`.`order_phone`,`orderinfo`.`kehu_id`,`orderinfo`.`price`,`orderinfo`.`material_id`,`orderinfo`.`pProductinfo_id`,`orderinfo`.`productinfo_id`,`orderinfo`.`order_type`,`orderinfo`.`order_status`,`orderinfo`.`all_order_status`,`orderinfo`.`shengchan_status`,`orderinfo`.`zuixinshuoming`,`orderinfo`.`guzhangshu`,`orderinfo`.`zuixinguzhang`,`orderinfo`.`techprocess_id`,`orderinfo`.`actual_amount`,`orderinfo`.`kucun_amount`,`orderinfo`.`produce_amount`,`orderinfo`.`produced_amount`,`orderinfo`.`waste_amount`,`orderinfo`.`produced_time`,`orderinfo`.`send_amount`,`orderinfo`.`ruku_posi`,`orderinfo`.`sent_amount`,`orderinfo`.`out_time`,`orderinfo`.`build_order_staffid`,`orderinfo`.`factorymge_id`,`orderinfo`.`admin_id`,`orderinfo`.`remind_day`,`orderinfo`.`build_time`,`orderinfo`.`end_time`,`orderinfo`.`responsible_staffinfos`,`orderinfo`.`responsible_staffinfovars`,`orderinfo`.`feedback`,`orderinfo`.`guoqitime`,`orderinfo`.`guoqi_status`,`orderinfo`.`put_position`,`orderinfo`.`createtime`,`orderinfo`.`updatetime`,`orderinfo`.`is_modify`,`orderinfo`.`purchaseorder_id`,factorymge.id AS factorymge__id,factorymge.name AS factorymge__name,factorymge.connect_name AS factorymge__connect_name,factorymge.phone_num AS factorymge__phone_num,factorymge.fax_num AS factorymge__fax_num,factorymge.build_order_yuan AS factorymge__build_order_yuan,factorymge.operator AS factorymge__operator,factorymge.city AS factorymge__city,factorymge.address AS factorymge__address,factorymge.en_switch AS factorymge__en_switch,factorymge.admin_id AS factorymge__admin_id,factorymge.createtime AS factorymge__createtime,factorymge.updatetime AS factorymge__updatetime,productinfo.id AS productinfo__id,productinfo.product_avatar AS productinfo__product_avatar,productinfo.name AS productinfo__name,productinfo.product_num AS productinfo__product_num,productinfo.kucun AS productinfo__kucun,productinfo.takeup_kucun AS productinfo__takeup_kucun,productinfo.staff_ids AS productinfo__staff_ids,productinfo.staff_names AS productinfo__staff_names,productinfo.pid AS productinfo__pid,productinfo.corresponding_num AS productinfo__corresponding_num,productinfo.position AS productinfo__position,productinfo.price AS productinfo__price,productinfo.factorymge_id AS productinfo__factorymge_id,productinfo.product_status AS productinfo__product_status,productinfo.admin_id AS productinfo__admin_id,productinfo.createtime AS productinfo__createtime,productinfo.updatetime AS productinfo__updatetime,sum(orderinfo.send_amount*orderinfo.price) as total FROM `ot_orderinfo` `orderinfo` LEFT JOIN `ot_factorymge` `factorymge` ON `orderinfo`.`factorymge_id`=`factorymge`.`id` LEFT JOIN `ot_productinfo` `productinfo` ON `orderinfo`.`productinfo_id`=`productinfo`.`id` WHERE ( orderinfo.factorymge_id = 31 ) AND ( orderinfo.pid != 0 ) AND ( orderinfo.actual_amount > 0 ) AND ( orderinfo.order_status in ("1","2") ) AND ( orderinfo.produced_time = 0 ) LIMIT 1 [ RunTime:0.076561s ] [ sql ] [ SQL ] SELECT `productinfo`.`id`,`productinfo`.`product_avatar`,`productinfo`.`name`,`productinfo`.`product_num`,`productinfo`.`kucun`,`productinfo`.`takeup_kucun`,`productinfo`.`staff_ids`,`productinfo`.`staff_names`,`productinfo`.`pid`,`productinfo`.`corresponding_num`,`productinfo`.`position`,`productinfo`.`price`,`productinfo`.`factorymge_id`,`productinfo`.`product_status`,`productinfo`.`admin_id`,`productinfo`.`createtime`,`productinfo`.`updatetime`,factorymge.id AS factorymge__id,factorymge.name AS factorymge__name,factorymge.connect_name AS factorymge__connect_name,factorymge.phone_num AS factorymge__phone_num,factorymge.fax_num AS factorymge__fax_num,factorymge.build_order_yuan AS factorymge__build_order_yuan,factorymge.operator AS factorymge__operator,factorymge.city AS factorymge__city,factorymge.address AS factorymge__address,factorymge.en_switch AS factorymge__en_switch,factorymge.admin_id AS factorymge__admin_id,factorymge.createtime AS factorymge__createtime,factorymge.updatetime AS factorymge__updatetime,sum(kucun*price) as total FROM `ot_productinfo` `productinfo` LEFT JOIN `ot_factorymge` `factorymge` ON `productinfo`.`factorymge_id`=`factorymge`.`id` WHERE ( factorymge_id=31 ) AND `product_status` = '1' LIMIT 1 [ RunTime:0.002610s ] [ sql ] [ SQL ] SELECT `material`.`id`,`material`.`name`,`material`.`number`,`material`.`avatar`,`material`.`amount`,`material`.`warn_amount`,`material`.`occupy_amount`,`material`.`factorymge_id`,`material`.`is_stop_status`,`material`.`admin_id`,`material`.`price`,`material`.`danwei`,`material`.`quehuo_status`,`material`.`put_position`,`material`.`is_has_sup`,`material`.`staff_ids`,`material`.`staff_names`,`material`.`createtime`,`material`.`updatetime`,`material`.`is_delete`,factorymge.id AS factorymge__id,factorymge.name AS factorymge__name,factorymge.connect_name AS factorymge__connect_name,factorymge.phone_num AS factorymge__phone_num,factorymge.fax_num AS factorymge__fax_num,factorymge.build_order_yuan AS factorymge__build_order_yuan,factorymge.operator AS factorymge__operator,factorymge.city AS factorymge__city,factorymge.address AS factorymge__address,factorymge.en_switch AS factorymge__en_switch,factorymge.admin_id AS factorymge__admin_id,factorymge.createtime AS factorymge__createtime,factorymge.updatetime AS factorymge__updatetime,sum(amount*price) as total FROM `ot_material` `material` LEFT JOIN `ot_factorymge` `factorymge` ON `material`.`factorymge_id`=`factorymge`.`id` WHERE ( factorymge_id=31 ) LIMIT 1 [ RunTime:0.000400s ] [ sql ] [ SQL ] UPDATE `ot_zichan` SET `carmaterialcountprice`=0,`carmaterialcountpricediffer`=0,`countpricediffer`=0,`shoudbeshoucountprice`=0,`productcountprice`=NULL,`lingcountprice`=NULL,`shoudbefucountprice`=0,`xianjin`=0,`countprice`=0 WHERE `id` = 26173 [ RunTime:0.004468s ] [ sql ] [ SQL ] SELECT * FROM `ot_zichan` WHERE `factorymge_id` = 32 AND `year` = 2026 AND `month` = 10 AND `day` = 5 LIMIT 1 [ RunTime:0.017005s ] [ sql ] [ SQL ] SELECT * FROM `ot_zichan` WHERE `factorymge_id` = 32 AND `year` = 2026 AND `month` = 10 AND `day` = 6 LIMIT 1 [ RunTime:0.016888s ] [ sql ] [ SQL ] SELECT `orderinfo`.`id` FROM `ot_orderinfo` `orderinfo` LEFT JOIN `ot_factorymge` `factorymge` ON `orderinfo`.`factorymge_id`=`factorymge`.`id` LEFT JOIN `ot_productinfo` `productinfo` ON `orderinfo`.`productinfo_id`=`productinfo`.`id` WHERE ( orderinfo.factorymge_id = 32 ) AND ( orderinfo.pid = 0 ) AND ( orderinfo.actual_amount > 0 ) AND ( orderinfo.order_status in ("1","2") ) [ RunTime:0.023763s ] [ sql ] [ SQL ] SELECT sum(quantity*price) as total FROM `ot_orderandmaterial` WHERE `orderinfo_id` IN (15506) LIMIT 1 [ RunTime:0.001604s ] [ sql ] [ SQL ] SELECT `orderinfo`.`id`,`orderinfo`.`nei_number`,`orderinfo`.`number`,`orderinfo`.`pid`,`orderinfo`.`order_company`,`orderinfo`.`order_connect`,`orderinfo`.`order_phone`,`orderinfo`.`kehu_id`,`orderinfo`.`price`,`orderinfo`.`material_id`,`orderinfo`.`pProductinfo_id`,`orderinfo`.`productinfo_id`,`orderinfo`.`order_type`,`orderinfo`.`order_status`,`orderinfo`.`all_order_status`,`orderinfo`.`shengchan_status`,`orderinfo`.`zuixinshuoming`,`orderinfo`.`guzhangshu`,`orderinfo`.`zuixinguzhang`,`orderinfo`.`techprocess_id`,`orderinfo`.`actual_amount`,`orderinfo`.`kucun_amount`,`orderinfo`.`produce_amount`,`orderinfo`.`produced_amount`,`orderinfo`.`waste_amount`,`orderinfo`.`produced_time`,`orderinfo`.`send_amount`,`orderinfo`.`ruku_posi`,`orderinfo`.`sent_amount`,`orderinfo`.`out_time`,`orderinfo`.`build_order_staffid`,`orderinfo`.`factorymge_id`,`orderinfo`.`admin_id`,`orderinfo`.`remind_day`,`orderinfo`.`build_time`,`orderinfo`.`end_time`,`orderinfo`.`responsible_staffinfos`,`orderinfo`.`responsible_staffinfovars`,`orderinfo`.`feedback`,`orderinfo`.`guoqitime`,`orderinfo`.`guoqi_status`,`orderinfo`.`put_position`,`orderinfo`.`createtime`,`orderinfo`.`updatetime`,`orderinfo`.`is_modify`,`orderinfo`.`purchaseorder_id`,factorymge.id AS factorymge__id,factorymge.name AS factorymge__name,factorymge.connect_name AS factorymge__connect_name,factorymge.phone_num AS factorymge__phone_num,factorymge.fax_num AS factorymge__fax_num,factorymge.build_order_yuan AS factorymge__build_order_yuan,factorymge.operator AS factorymge__operator,factorymge.city AS factorymge__city,factorymge.address AS factorymge__address,factorymge.en_switch AS factorymge__en_switch,factorymge.admin_id AS factorymge__admin_id,factorymge.createtime AS factorymge__createtime,factorymge.updatetime AS factorymge__updatetime,productinfo.id AS productinfo__id,productinfo.product_avatar AS productinfo__product_avatar,productinfo.name AS productinfo__name,productinfo.product_num AS productinfo__product_num,productinfo.kucun AS productinfo__kucun,productinfo.takeup_kucun AS productinfo__takeup_kucun,productinfo.staff_ids AS productinfo__staff_ids,productinfo.staff_names AS productinfo__staff_names,productinfo.pid AS productinfo__pid,productinfo.corresponding_num AS productinfo__corresponding_num,productinfo.position AS productinfo__position,productinfo.price AS productinfo__price,productinfo.factorymge_id AS productinfo__factorymge_id,productinfo.product_status AS productinfo__product_status,productinfo.admin_id AS productinfo__admin_id,productinfo.createtime AS productinfo__createtime,productinfo.updatetime AS productinfo__updatetime,sum(orderinfo.send_amount*orderinfo.price) as total FROM `ot_orderinfo` `orderinfo` LEFT JOIN `ot_factorymge` `factorymge` ON `orderinfo`.`factorymge_id`=`factorymge`.`id` LEFT JOIN `ot_productinfo` `productinfo` ON `orderinfo`.`productinfo_id`=`productinfo`.`id` WHERE ( orderinfo.factorymge_id = 32 ) AND ( orderinfo.pid != 0 ) AND ( orderinfo.actual_amount > 0 ) AND ( orderinfo.order_status in ("1","2") ) AND ( orderinfo.produced_time = 0 ) LIMIT 1 [ RunTime:0.069716s ] [ sql ] [ SQL ] SELECT `productinfo`.`id`,`productinfo`.`product_avatar`,`productinfo`.`name`,`productinfo`.`product_num`,`productinfo`.`kucun`,`productinfo`.`takeup_kucun`,`productinfo`.`staff_ids`,`productinfo`.`staff_names`,`productinfo`.`pid`,`productinfo`.`corresponding_num`,`productinfo`.`position`,`productinfo`.`price`,`productinfo`.`factorymge_id`,`productinfo`.`product_status`,`productinfo`.`admin_id`,`productinfo`.`createtime`,`productinfo`.`updatetime`,factorymge.id AS factorymge__id,factorymge.name AS factorymge__name,factorymge.connect_name AS factorymge__connect_name,factorymge.phone_num AS factorymge__phone_num,factorymge.fax_num AS factorymge__fax_num,factorymge.build_order_yuan AS factorymge__build_order_yuan,factorymge.operator AS factorymge__operator,factorymge.city AS factorymge__city,factorymge.address AS factorymge__address,factorymge.en_switch AS factorymge__en_switch,factorymge.admin_id AS factorymge__admin_id,factorymge.createtime AS factorymge__createtime,factorymge.updatetime AS factorymge__updatetime,sum(kucun*price) as total FROM `ot_productinfo` `productinfo` LEFT JOIN `ot_factorymge` `factorymge` ON `productinfo`.`factorymge_id`=`factorymge`.`id` WHERE ( factorymge_id=32 ) AND `product_status` = '1' LIMIT 1 [ RunTime:0.002602s ] [ sql ] [ SQL ] SELECT `material`.`id`,`material`.`name`,`material`.`number`,`material`.`avatar`,`material`.`amount`,`material`.`warn_amount`,`material`.`occupy_amount`,`material`.`factorymge_id`,`material`.`is_stop_status`,`material`.`admin_id`,`material`.`price`,`material`.`danwei`,`material`.`quehuo_status`,`material`.`put_position`,`material`.`is_has_sup`,`material`.`staff_ids`,`material`.`staff_names`,`material`.`createtime`,`material`.`updatetime`,`material`.`is_delete`,factorymge.id AS factorymge__id,factorymge.name AS factorymge__name,factorymge.connect_name AS factorymge__connect_name,factorymge.phone_num AS factorymge__phone_num,factorymge.fax_num AS factorymge__fax_num,factorymge.build_order_yuan AS factorymge__build_order_yuan,factorymge.operator AS factorymge__operator,factorymge.city AS factorymge__city,factorymge.address AS factorymge__address,factorymge.en_switch AS factorymge__en_switch,factorymge.admin_id AS factorymge__admin_id,factorymge.createtime AS factorymge__createtime,factorymge.updatetime AS factorymge__updatetime,sum(amount*price) as total FROM `ot_material` `material` LEFT JOIN `ot_factorymge` `factorymge` ON `material`.`factorymge_id`=`factorymge`.`id` WHERE ( factorymge_id=32 ) LIMIT 1 [ RunTime:0.000562s ] [ sql ] [ SQL ] UPDATE `ot_zichan` SET `carmaterialcountprice`=0,`carmaterialcountpricediffer`=0,`countpricediffer`=0,`shoudbeshoucountprice`=0,`productcountprice`=60,`lingcountprice`=39912.5,`shoudbefucountprice`=0,`xianjin`=0,`countprice`=39972.5 WHERE `id` = 26174 [ RunTime:0.005057s ] [ sql ] [ SQL ] SELECT * FROM `ot_zichan` WHERE `factorymge_id` = 34 AND `year` = 2026 AND `month` = 10 AND `day` = 5 LIMIT 1 [ RunTime:0.016853s ] [ sql ] [ SQL ] SELECT * FROM `ot_zichan` WHERE `factorymge_id` = 34 AND `year` = 2026 AND `month` = 10 AND `day` = 6 LIMIT 1 [ RunTime:0.016815s ] [ sql ] [ SQL ] SELECT `orderinfo`.`id` FROM `ot_orderinfo` `orderinfo` LEFT JOIN `ot_factorymge` `factorymge` ON `orderinfo`.`factorymge_id`=`factorymge`.`id` LEFT JOIN `ot_productinfo` `productinfo` ON `orderinfo`.`productinfo_id`=`productinfo`.`id` WHERE ( orderinfo.factorymge_id = 34 ) AND ( orderinfo.pid = 0 ) AND ( orderinfo.actual_amount > 0 ) AND ( orderinfo.order_status in ("1","2") ) [ RunTime:0.023525s ] [ sql ] [ SQL ] SELECT sum(quantity*price) as total FROM `ot_orderandmaterial` WHERE `orderinfo_id` IN ('') LIMIT 1 [ RunTime:0.001920s ] [ sql ] [ SQL ] SELECT `orderinfo`.`id`,`orderinfo`.`nei_number`,`orderinfo`.`number`,`orderinfo`.`pid`,`orderinfo`.`order_company`,`orderinfo`.`order_connect`,`orderinfo`.`order_phone`,`orderinfo`.`kehu_id`,`orderinfo`.`price`,`orderinfo`.`material_id`,`orderinfo`.`pProductinfo_id`,`orderinfo`.`productinfo_id`,`orderinfo`.`order_type`,`orderinfo`.`order_status`,`orderinfo`.`all_order_status`,`orderinfo`.`shengchan_status`,`orderinfo`.`zuixinshuoming`,`orderinfo`.`guzhangshu`,`orderinfo`.`zuixinguzhang`,`orderinfo`.`techprocess_id`,`orderinfo`.`actual_amount`,`orderinfo`.`kucun_amount`,`orderinfo`.`produce_amount`,`orderinfo`.`produced_amount`,`orderinfo`.`waste_amount`,`orderinfo`.`produced_time`,`orderinfo`.`send_amount`,`orderinfo`.`ruku_posi`,`orderinfo`.`sent_amount`,`orderinfo`.`out_time`,`orderinfo`.`build_order_staffid`,`orderinfo`.`factorymge_id`,`orderinfo`.`admin_id`,`orderinfo`.`remind_day`,`orderinfo`.`build_time`,`orderinfo`.`end_time`,`orderinfo`.`responsible_staffinfos`,`orderinfo`.`responsible_staffinfovars`,`orderinfo`.`feedback`,`orderinfo`.`guoqitime`,`orderinfo`.`guoqi_status`,`orderinfo`.`put_position`,`orderinfo`.`createtime`,`orderinfo`.`updatetime`,`orderinfo`.`is_modify`,`orderinfo`.`purchaseorder_id`,factorymge.id AS factorymge__id,factorymge.name AS factorymge__name,factorymge.connect_name AS factorymge__connect_name,factorymge.phone_num AS factorymge__phone_num,factorymge.fax_num AS factorymge__fax_num,factorymge.build_order_yuan AS factorymge__build_order_yuan,factorymge.operator AS factorymge__operator,factorymge.city AS factorymge__city,factorymge.address AS factorymge__address,factorymge.en_switch AS factorymge__en_switch,factorymge.admin_id AS factorymge__admin_id,factorymge.createtime AS factorymge__createtime,factorymge.updatetime AS factorymge__updatetime,productinfo.id AS productinfo__id,productinfo.product_avatar AS productinfo__product_avatar,productinfo.name AS productinfo__name,productinfo.product_num AS productinfo__product_num,productinfo.kucun AS productinfo__kucun,productinfo.takeup_kucun AS productinfo__takeup_kucun,productinfo.staff_ids AS productinfo__staff_ids,productinfo.staff_names AS productinfo__staff_names,productinfo.pid AS productinfo__pid,productinfo.corresponding_num AS productinfo__corresponding_num,productinfo.position AS productinfo__position,productinfo.price AS productinfo__price,productinfo.factorymge_id AS productinfo__factorymge_id,productinfo.product_status AS productinfo__product_status,productinfo.admin_id AS productinfo__admin_id,productinfo.createtime AS productinfo__createtime,productinfo.updatetime AS productinfo__updatetime,sum(orderinfo.send_amount*orderinfo.price) as total FROM `ot_orderinfo` `orderinfo` LEFT JOIN `ot_factorymge` `factorymge` ON `orderinfo`.`factorymge_id`=`factorymge`.`id` LEFT JOIN `ot_productinfo` `productinfo` ON `orderinfo`.`productinfo_id`=`productinfo`.`id` WHERE ( orderinfo.factorymge_id = 34 ) AND ( orderinfo.pid != 0 ) AND ( orderinfo.actual_amount > 0 ) AND ( orderinfo.order_status in ("1","2") ) AND ( orderinfo.produced_time = 0 ) LIMIT 1 [ RunTime:0.069195s ] [ sql ] [ SQL ] SELECT `productinfo`.`id`,`productinfo`.`product_avatar`,`productinfo`.`name`,`productinfo`.`product_num`,`productinfo`.`kucun`,`productinfo`.`takeup_kucun`,`productinfo`.`staff_ids`,`productinfo`.`staff_names`,`productinfo`.`pid`,`productinfo`.`corresponding_num`,`productinfo`.`position`,`productinfo`.`price`,`productinfo`.`factorymge_id`,`productinfo`.`product_status`,`productinfo`.`admin_id`,`productinfo`.`createtime`,`productinfo`.`updatetime`,factorymge.id AS factorymge__id,factorymge.name AS factorymge__name,factorymge.connect_name AS factorymge__connect_name,factorymge.phone_num AS factorymge__phone_num,factorymge.fax_num AS factorymge__fax_num,factorymge.build_order_yuan AS factorymge__build_order_yuan,factorymge.operator AS factorymge__operator,factorymge.city AS factorymge__city,factorymge.address AS factorymge__address,factorymge.en_switch AS factorymge__en_switch,factorymge.admin_id AS factorymge__admin_id,factorymge.createtime AS factorymge__createtime,factorymge.updatetime AS factorymge__updatetime,sum(kucun*price) as total FROM `ot_productinfo` `productinfo` LEFT JOIN `ot_factorymge` `factorymge` ON `productinfo`.`factorymge_id`=`factorymge`.`id` WHERE ( factorymge_id=34 ) AND `product_status` = '1' LIMIT 1 [ RunTime:0.002594s ] [ sql ] [ SQL ] SELECT `material`.`id`,`material`.`name`,`material`.`number`,`material`.`avatar`,`material`.`amount`,`material`.`warn_amount`,`material`.`occupy_amount`,`material`.`factorymge_id`,`material`.`is_stop_status`,`material`.`admin_id`,`material`.`price`,`material`.`danwei`,`material`.`quehuo_status`,`material`.`put_position`,`material`.`is_has_sup`,`material`.`staff_ids`,`material`.`staff_names`,`material`.`createtime`,`material`.`updatetime`,`material`.`is_delete`,factorymge.id AS factorymge__id,factorymge.name AS factorymge__name,factorymge.connect_name AS factorymge__connect_name,factorymge.phone_num AS factorymge__phone_num,factorymge.fax_num AS factorymge__fax_num,factorymge.build_order_yuan AS factorymge__build_order_yuan,factorymge.operator AS factorymge__operator,factorymge.city AS factorymge__city,factorymge.address AS factorymge__address,factorymge.en_switch AS factorymge__en_switch,factorymge.admin_id AS factorymge__admin_id,factorymge.createtime AS factorymge__createtime,factorymge.updatetime AS factorymge__updatetime,sum(amount*price) as total FROM `ot_material` `material` LEFT JOIN `ot_factorymge` `factorymge` ON `material`.`factorymge_id`=`factorymge`.`id` WHERE ( factorymge_id=34 ) LIMIT 1 [ RunTime:0.000376s ] [ sql ] [ SQL ] UPDATE `ot_zichan` SET `carmaterialcountprice`=0,`carmaterialcountpricediffer`=0,`countpricediffer`=0,`shoudbeshoucountprice`=0,`productcountprice`=NULL,`lingcountprice`=NULL,`shoudbefucountprice`=0,`xianjin`=0,`countprice`=0 WHERE `id` = 26175 [ RunTime:0.004548s ] [ sql ] [ SQL ] SELECT * FROM `ot_zichan` WHERE `factorymge_id` = 35 AND `year` = 2026 AND `month` = 10 AND `day` = 5 LIMIT 1 [ RunTime:0.017018s ] [ sql ] [ SQL ] SELECT * FROM `ot_zichan` WHERE `factorymge_id` = 35 AND `year` = 2026 AND `month` = 10 AND `day` = 6 LIMIT 1 [ RunTime:0.019653s ] [ sql ] [ SQL ] SELECT `orderinfo`.`id` FROM `ot_orderinfo` `orderinfo` LEFT JOIN `ot_factorymge` `factorymge` ON `orderinfo`.`factorymge_id`=`factorymge`.`id` LEFT JOIN `ot_productinfo` `productinfo` ON `orderinfo`.`productinfo_id`=`productinfo`.`id` WHERE ( orderinfo.factorymge_id = 35 ) AND ( orderinfo.pid = 0 ) AND ( orderinfo.actual_amount > 0 ) AND ( orderinfo.order_status in ("1","2") ) [ RunTime:0.023104s ] [ sql ] [ SQL ] SELECT sum(quantity*price) as total FROM `ot_orderandmaterial` WHERE `orderinfo_id` IN ('') LIMIT 1 [ RunTime:0.001662s ] [ sql ] [ SQL ] SELECT `orderinfo`.`id`,`orderinfo`.`nei_number`,`orderinfo`.`number`,`orderinfo`.`pid`,`orderinfo`.`order_company`,`orderinfo`.`order_connect`,`orderinfo`.`order_phone`,`orderinfo`.`kehu_id`,`orderinfo`.`price`,`orderinfo`.`material_id`,`orderinfo`.`pProductinfo_id`,`orderinfo`.`productinfo_id`,`orderinfo`.`order_type`,`orderinfo`.`order_status`,`orderinfo`.`all_order_status`,`orderinfo`.`shengchan_status`,`orderinfo`.`zuixinshuoming`,`orderinfo`.`guzhangshu`,`orderinfo`.`zuixinguzhang`,`orderinfo`.`techprocess_id`,`orderinfo`.`actual_amount`,`orderinfo`.`kucun_amount`,`orderinfo`.`produce_amount`,`orderinfo`.`produced_amount`,`orderinfo`.`waste_amount`,`orderinfo`.`produced_time`,`orderinfo`.`send_amount`,`orderinfo`.`ruku_posi`,`orderinfo`.`sent_amount`,`orderinfo`.`out_time`,`orderinfo`.`build_order_staffid`,`orderinfo`.`factorymge_id`,`orderinfo`.`admin_id`,`orderinfo`.`remind_day`,`orderinfo`.`build_time`,`orderinfo`.`end_time`,`orderinfo`.`responsible_staffinfos`,`orderinfo`.`responsible_staffinfovars`,`orderinfo`.`feedback`,`orderinfo`.`guoqitime`,`orderinfo`.`guoqi_status`,`orderinfo`.`put_position`,`orderinfo`.`createtime`,`orderinfo`.`updatetime`,`orderinfo`.`is_modify`,`orderinfo`.`purchaseorder_id`,factorymge.id AS factorymge__id,factorymge.name AS factorymge__name,factorymge.connect_name AS factorymge__connect_name,factorymge.phone_num AS factorymge__phone_num,factorymge.fax_num AS factorymge__fax_num,factorymge.build_order_yuan AS factorymge__build_order_yuan,factorymge.operator AS factorymge__operator,factorymge.city AS factorymge__city,factorymge.address AS factorymge__address,factorymge.en_switch AS factorymge__en_switch,factorymge.admin_id AS factorymge__admin_id,factorymge.createtime AS factorymge__createtime,factorymge.updatetime AS factorymge__updatetime,productinfo.id AS productinfo__id,productinfo.product_avatar AS productinfo__product_avatar,productinfo.name AS productinfo__name,productinfo.product_num AS productinfo__product_num,productinfo.kucun AS productinfo__kucun,productinfo.takeup_kucun AS productinfo__takeup_kucun,productinfo.staff_ids AS productinfo__staff_ids,productinfo.staff_names AS productinfo__staff_names,productinfo.pid AS productinfo__pid,productinfo.corresponding_num AS productinfo__corresponding_num,productinfo.position AS productinfo__position,productinfo.price AS productinfo__price,productinfo.factorymge_id AS productinfo__factorymge_id,productinfo.product_status AS productinfo__product_status,productinfo.admin_id AS productinfo__admin_id,productinfo.createtime AS productinfo__createtime,productinfo.updatetime AS productinfo__updatetime,sum(orderinfo.send_amount*orderinfo.price) as total FROM `ot_orderinfo` `orderinfo` LEFT JOIN `ot_factorymge` `factorymge` ON `orderinfo`.`factorymge_id`=`factorymge`.`id` LEFT JOIN `ot_productinfo` `productinfo` ON `orderinfo`.`productinfo_id`=`productinfo`.`id` WHERE ( orderinfo.factorymge_id = 35 ) AND ( orderinfo.pid != 0 ) AND ( orderinfo.actual_amount > 0 ) AND ( orderinfo.order_status in ("1","2") ) AND ( orderinfo.produced_time = 0 ) LIMIT 1 [ RunTime:0.070177s ] [ sql ] [ SQL ] SELECT `productinfo`.`id`,`productinfo`.`product_avatar`,`productinfo`.`name`,`productinfo`.`product_num`,`productinfo`.`kucun`,`productinfo`.`takeup_kucun`,`productinfo`.`staff_ids`,`productinfo`.`staff_names`,`productinfo`.`pid`,`productinfo`.`corresponding_num`,`productinfo`.`position`,`productinfo`.`price`,`productinfo`.`factorymge_id`,`productinfo`.`product_status`,`productinfo`.`admin_id`,`productinfo`.`createtime`,`productinfo`.`updatetime`,factorymge.id AS factorymge__id,factorymge.name AS factorymge__name,factorymge.connect_name AS factorymge__connect_name,factorymge.phone_num AS factorymge__phone_num,factorymge.fax_num AS factorymge__fax_num,factorymge.build_order_yuan AS factorymge__build_order_yuan,factorymge.operator AS factorymge__operator,factorymge.city AS factorymge__city,factorymge.address AS factorymge__address,factorymge.en_switch AS factorymge__en_switch,factorymge.admin_id AS factorymge__admin_id,factorymge.createtime AS factorymge__createtime,factorymge.updatetime AS factorymge__updatetime,sum(kucun*price) as total FROM `ot_productinfo` `productinfo` LEFT JOIN `ot_factorymge` `factorymge` ON `productinfo`.`factorymge_id`=`factorymge`.`id` WHERE ( factorymge_id=35 ) AND `product_status` = '1' LIMIT 1 [ RunTime:0.002714s ] [ sql ] [ SQL ] SELECT `material`.`id`,`material`.`name`,`material`.`number`,`material`.`avatar`,`material`.`amount`,`material`.`warn_amount`,`material`.`occupy_amount`,`material`.`factorymge_id`,`material`.`is_stop_status`,`material`.`admin_id`,`material`.`price`,`material`.`danwei`,`material`.`quehuo_status`,`material`.`put_position`,`material`.`is_has_sup`,`material`.`staff_ids`,`material`.`staff_names`,`material`.`createtime`,`material`.`updatetime`,`material`.`is_delete`,factorymge.id AS factorymge__id,factorymge.name AS factorymge__name,factorymge.connect_name AS factorymge__connect_name,factorymge.phone_num AS factorymge__phone_num,factorymge.fax_num AS factorymge__fax_num,factorymge.build_order_yuan AS factorymge__build_order_yuan,factorymge.operator AS factorymge__operator,factorymge.city AS factorymge__city,factorymge.address AS factorymge__address,factorymge.en_switch AS factorymge__en_switch,factorymge.admin_id AS factorymge__admin_id,factorymge.createtime AS factorymge__createtime,factorymge.updatetime AS factorymge__updatetime,sum(amount*price) as total FROM `ot_material` `material` LEFT JOIN `ot_factorymge` `factorymge` ON `material`.`factorymge_id`=`factorymge`.`id` WHERE ( factorymge_id=35 ) LIMIT 1 [ RunTime:0.000496s ] [ sql ] [ SQL ] UPDATE `ot_zichan` SET `carmaterialcountprice`=0,`carmaterialcountpricediffer`=0,`countpricediffer`=0,`shoudbeshoucountprice`=0,`productcountprice`=0,`lingcountprice`=NULL,`shoudbefucountprice`=0,`xianjin`=0,`countprice`=0 WHERE `id` = 26176 [ RunTime:0.014068s ] [ sql ] [ SQL ] SELECT * FROM `ot_zichan` WHERE `factorymge_id` = 36 AND `year` = 2026 AND `month` = 10 AND `day` = 5 LIMIT 1 [ RunTime:0.018880s ] [ sql ] [ SQL ] SELECT * FROM `ot_zichan` WHERE `factorymge_id` = 36 AND `year` = 2026 AND `month` = 10 AND `day` = 6 LIMIT 1 [ RunTime:0.018021s ] [ sql ] [ SQL ] SELECT `orderinfo`.`id` FROM `ot_orderinfo` `orderinfo` LEFT JOIN `ot_factorymge` `factorymge` ON `orderinfo`.`factorymge_id`=`factorymge`.`id` LEFT JOIN `ot_productinfo` `productinfo` ON `orderinfo`.`productinfo_id`=`productinfo`.`id` WHERE ( orderinfo.factorymge_id = 36 ) AND ( orderinfo.pid = 0 ) AND ( orderinfo.actual_amount > 0 ) AND ( orderinfo.order_status in ("1","2") ) [ RunTime:0.024743s ] [ sql ] [ SQL ] SELECT sum(quantity*price) as total FROM `ot_orderandmaterial` WHERE `orderinfo_id` IN ('') LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SELECT `orderinfo`.`id`,`orderinfo`.`nei_number`,`orderinfo`.`number`,`orderinfo`.`pid`,`orderinfo`.`order_company`,`orderinfo`.`order_connect`,`orderinfo`.`order_phone`,`orderinfo`.`kehu_id`,`orderinfo`.`price`,`orderinfo`.`material_id`,`orderinfo`.`pProductinfo_id`,`orderinfo`.`productinfo_id`,`orderinfo`.`order_type`,`orderinfo`.`order_status`,`orderinfo`.`all_order_status`,`orderinfo`.`shengchan_status`,`orderinfo`.`zuixinshuoming`,`orderinfo`.`guzhangshu`,`orderinfo`.`zuixinguzhang`,`orderinfo`.`techprocess_id`,`orderinfo`.`actual_amount`,`orderinfo`.`kucun_amount`,`orderinfo`.`produce_amount`,`orderinfo`.`produced_amount`,`orderinfo`.`waste_amount`,`orderinfo`.`produced_time`,`orderinfo`.`send_amount`,`orderinfo`.`ruku_posi`,`orderinfo`.`sent_amount`,`orderinfo`.`out_time`,`orderinfo`.`build_order_staffid`,`orderinfo`.`factorymge_id`,`orderinfo`.`admin_id`,`orderinfo`.`remind_day`,`orderinfo`.`build_time`,`orderinfo`.`end_time`,`orderinfo`.`responsible_staffinfos`,`orderinfo`.`responsible_staffinfovars`,`orderinfo`.`feedback`,`orderinfo`.`guoqitime`,`orderinfo`.`guoqi_status`,`orderinfo`.`put_position`,`orderinfo`.`createtime`,`orderinfo`.`updatetime`,`orderinfo`.`is_modify`,`orderinfo`.`purchaseorder_id`,factorymge.id AS factorymge__id,factorymge.name AS factorymge__name,factorymge.connect_name AS factorymge__connect_name,factorymge.phone_num AS factorymge__phone_num,factorymge.fax_num AS factorymge__fax_num,factorymge.build_order_yuan AS factorymge__build_order_yuan,factorymge.operator AS factorymge__operator,factorymge.city AS factorymge__city,factorymge.address AS factorymge__address,factorymge.en_switch AS factorymge__en_switch,factorymge.admin_id AS factorymge__admin_id,factorymge.createtime AS factorymge__createtime,factorymge.updatetime AS factorymge__updatetime,productinfo.id AS productinfo__id,productinfo.product_avatar AS productinfo__product_avatar,productinfo.name AS productinfo__name,productinfo.product_num AS productinfo__product_num,productinfo.kucun AS productinfo__kucun,productinfo.takeup_kucun AS productinfo__takeup_kucun,productinfo.staff_ids AS productinfo__staff_ids,productinfo.staff_names AS productinfo__staff_names,productinfo.pid AS productinfo__pid,productinfo.corresponding_num AS productinfo__corresponding_num,productinfo.position AS productinfo__position,productinfo.price AS productinfo__price,productinfo.factorymge_id AS productinfo__factorymge_id,productinfo.product_status AS productinfo__product_status,productinfo.admin_id AS productinfo__admin_id,productinfo.createtime AS productinfo__createtime,productinfo.updatetime AS productinfo__updatetime,sum(orderinfo.send_amount*orderinfo.price) as total FROM `ot_orderinfo` `orderinfo` LEFT JOIN `ot_factorymge` `factorymge` ON `orderinfo`.`factorymge_id`=`factorymge`.`id` LEFT JOIN `ot_productinfo` `productinfo` ON `orderinfo`.`productinfo_id`=`productinfo`.`id` WHERE ( orderinfo.factorymge_id = 36 ) AND ( orderinfo.pid != 0 ) AND ( orderinfo.actual_amount > 0 ) AND ( orderinfo.order_status in ("1","2") ) AND ( orderinfo.produced_time = 0 ) LIMIT 1 [ RunTime:0.082816s ] [ sql ] [ SQL ] SELECT `productinfo`.`id`,`productinfo`.`product_avatar`,`productinfo`.`name`,`productinfo`.`product_num`,`productinfo`.`kucun`,`productinfo`.`takeup_kucun`,`productinfo`.`staff_ids`,`productinfo`.`staff_names`,`productinfo`.`pid`,`productinfo`.`corresponding_num`,`productinfo`.`position`,`productinfo`.`price`,`productinfo`.`factorymge_id`,`productinfo`.`product_status`,`productinfo`.`admin_id`,`productinfo`.`createtime`,`productinfo`.`updatetime`,factorymge.id AS factorymge__id,factorymge.name AS factorymge__name,factorymge.connect_name AS factorymge__connect_name,factorymge.phone_num AS factorymge__phone_num,factorymge.fax_num AS factorymge__fax_num,factorymge.build_order_yuan AS factorymge__build_order_yuan,factorymge.operator AS factorymge__operator,factorymge.city AS factorymge__city,factorymge.address AS factorymge__address,factorymge.en_switch AS factorymge__en_switch,factorymge.admin_id AS factorymge__admin_id,factorymge.createtime AS factorymge__createtime,factorymge.updatetime AS factorymge__updatetime,sum(kucun*price) as total FROM `ot_productinfo` `productinfo` LEFT JOIN `ot_factorymge` `factorymge` ON `productinfo`.`factorymge_id`=`factorymge`.`id` WHERE ( factorymge_id=36 ) AND `product_status` = '1' LIMIT 1 [ RunTime:0.003502s ] [ sql ] [ SQL ] SELECT `material`.`id`,`material`.`name`,`material`.`number`,`material`.`avatar`,`material`.`amount`,`material`.`warn_amount`,`material`.`occupy_amount`,`material`.`factorymge_id`,`material`.`is_stop_status`,`material`.`admin_id`,`material`.`price`,`material`.`danwei`,`material`.`quehuo_status`,`material`.`put_position`,`material`.`is_has_sup`,`material`.`staff_ids`,`material`.`staff_names`,`material`.`createtime`,`material`.`updatetime`,`material`.`is_delete`,factorymge.id AS factorymge__id,factorymge.name AS factorymge__name,factorymge.connect_name AS factorymge__connect_name,factorymge.phone_num AS factorymge__phone_num,factorymge.fax_num AS factorymge__fax_num,factorymge.build_order_yuan AS factorymge__build_order_yuan,factorymge.operator AS factorymge__operator,factorymge.city AS factorymge__city,factorymge.address AS factorymge__address,factorymge.en_switch AS factorymge__en_switch,factorymge.admin_id AS factorymge__admin_id,factorymge.createtime AS factorymge__createtime,factorymge.updatetime AS factorymge__updatetime,sum(amount*price) as total FROM `ot_material` `material` LEFT JOIN `ot_factorymge` `factorymge` ON `material`.`factorymge_id`=`factorymge`.`id` WHERE ( factorymge_id=36 ) LIMIT 1 [ RunTime:0.000602s ] [ sql ] [ SQL ] UPDATE `ot_zichan` SET `carmaterialcountprice`=0,`carmaterialcountpricediffer`=0,`countpricediffer`=0,`shoudbeshoucountprice`=0,`productcountprice`=805,`lingcountprice`=NULL,`shoudbefucountprice`=0,`xianjin`=0,`countprice`=805 WHERE `id` = 26177 [ RunTime:0.007336s ] [ sql ] [ SQL ] SELECT * FROM `ot_zichan` WHERE `factorymge_id` = 38 AND `year` = 2026 AND `month` = 10 AND `day` = 5 LIMIT 1 [ RunTime:0.017165s ] [ sql ] [ SQL ] SELECT * FROM `ot_zichan` WHERE `factorymge_id` = 38 AND `year` = 2026 AND `month` = 10 AND `day` = 6 LIMIT 1 [ RunTime:0.020413s ] [ sql ] [ SQL ] SELECT `orderinfo`.`id` FROM `ot_orderinfo` `orderinfo` LEFT JOIN `ot_factorymge` `factorymge` ON `orderinfo`.`factorymge_id`=`factorymge`.`id` LEFT JOIN `ot_productinfo` `productinfo` ON `orderinfo`.`productinfo_id`=`productinfo`.`id` WHERE ( orderinfo.factorymge_id = 38 ) AND ( orderinfo.pid = 0 ) AND ( orderinfo.actual_amount > 0 ) AND ( orderinfo.order_status in ("1","2") ) [ RunTime:0.027784s ] [ sql ] [ SQL ] SELECT sum(quantity*price) as total FROM `ot_orderandmaterial` WHERE `orderinfo_id` IN ('') LIMIT 1 [ RunTime:0.002022s ] [ sql ] [ SQL ] SELECT `orderinfo`.`id`,`orderinfo`.`nei_number`,`orderinfo`.`number`,`orderinfo`.`pid`,`orderinfo`.`order_company`,`orderinfo`.`order_connect`,`orderinfo`.`order_phone`,`orderinfo`.`kehu_id`,`orderinfo`.`price`,`orderinfo`.`material_id`,`orderinfo`.`pProductinfo_id`,`orderinfo`.`productinfo_id`,`orderinfo`.`order_type`,`orderinfo`.`order_status`,`orderinfo`.`all_order_status`,`orderinfo`.`shengchan_status`,`orderinfo`.`zuixinshuoming`,`orderinfo`.`guzhangshu`,`orderinfo`.`zuixinguzhang`,`orderinfo`.`techprocess_id`,`orderinfo`.`actual_amount`,`orderinfo`.`kucun_amount`,`orderinfo`.`produce_amount`,`orderinfo`.`produced_amount`,`orderinfo`.`waste_amount`,`orderinfo`.`produced_time`,`orderinfo`.`send_amount`,`orderinfo`.`ruku_posi`,`orderinfo`.`sent_amount`,`orderinfo`.`out_time`,`orderinfo`.`build_order_staffid`,`orderinfo`.`factorymge_id`,`orderinfo`.`admin_id`,`orderinfo`.`remind_day`,`orderinfo`.`build_time`,`orderinfo`.`end_time`,`orderinfo`.`responsible_staffinfos`,`orderinfo`.`responsible_staffinfovars`,`orderinfo`.`feedback`,`orderinfo`.`guoqitime`,`orderinfo`.`guoqi_status`,`orderinfo`.`put_position`,`orderinfo`.`createtime`,`orderinfo`.`updatetime`,`orderinfo`.`is_modify`,`orderinfo`.`purchaseorder_id`,factorymge.id AS factorymge__id,factorymge.name AS factorymge__name,factorymge.connect_name AS factorymge__connect_name,factorymge.phone_num AS factorymge__phone_num,factorymge.fax_num AS factorymge__fax_num,factorymge.build_order_yuan AS factorymge__build_order_yuan,factorymge.operator AS factorymge__operator,factorymge.city AS factorymge__city,factorymge.address AS factorymge__address,factorymge.en_switch AS factorymge__en_switch,factorymge.admin_id AS factorymge__admin_id,factorymge.createtime AS factorymge__createtime,factorymge.updatetime AS factorymge__updatetime,productinfo.id AS productinfo__id,productinfo.product_avatar AS productinfo__product_avatar,productinfo.name AS productinfo__name,productinfo.product_num AS productinfo__product_num,productinfo.kucun AS productinfo__kucun,productinfo.takeup_kucun AS productinfo__takeup_kucun,productinfo.staff_ids AS productinfo__staff_ids,productinfo.staff_names AS productinfo__staff_names,productinfo.pid AS productinfo__pid,productinfo.corresponding_num AS productinfo__corresponding_num,productinfo.position AS productinfo__position,productinfo.price AS productinfo__price,productinfo.factorymge_id AS productinfo__factorymge_id,productinfo.product_status AS productinfo__product_status,productinfo.admin_id AS productinfo__admin_id,productinfo.createtime AS productinfo__createtime,productinfo.updatetime AS productinfo__updatetime,sum(orderinfo.send_amount*orderinfo.price) as total FROM `ot_orderinfo` `orderinfo` LEFT JOIN `ot_factorymge` `factorymge` ON `orderinfo`.`factorymge_id`=`factorymge`.`id` LEFT JOIN `ot_productinfo` `productinfo` ON `orderinfo`.`productinfo_id`=`productinfo`.`id` WHERE ( orderinfo.factorymge_id = 38 ) AND ( orderinfo.pid != 0 ) AND ( orderinfo.actual_amount > 0 ) AND ( orderinfo.order_status in ("1","2") ) AND ( orderinfo.produced_time = 0 ) LIMIT 1 [ RunTime:0.080593s ] [ sql ] [ SQL ] SELECT `productinfo`.`id`,`productinfo`.`product_avatar`,`productinfo`.`name`,`productinfo`.`product_num`,`productinfo`.`kucun`,`productinfo`.`takeup_kucun`,`productinfo`.`staff_ids`,`productinfo`.`staff_names`,`productinfo`.`pid`,`productinfo`.`corresponding_num`,`productinfo`.`position`,`productinfo`.`price`,`productinfo`.`factorymge_id`,`productinfo`.`product_status`,`productinfo`.`admin_id`,`productinfo`.`createtime`,`productinfo`.`updatetime`,factorymge.id AS factorymge__id,factorymge.name AS factorymge__name,factorymge.connect_name AS factorymge__connect_name,factorymge.phone_num AS factorymge__phone_num,factorymge.fax_num AS factorymge__fax_num,factorymge.build_order_yuan AS factorymge__build_order_yuan,factorymge.operator AS factorymge__operator,factorymge.city AS factorymge__city,factorymge.address AS factorymge__address,factorymge.en_switch AS factorymge__en_switch,factorymge.admin_id AS factorymge__admin_id,factorymge.createtime AS factorymge__createtime,factorymge.updatetime AS factorymge__updatetime,sum(kucun*price) as total FROM `ot_productinfo` `productinfo` LEFT JOIN `ot_factorymge` `factorymge` ON `productinfo`.`factorymge_id`=`factorymge`.`id` WHERE ( factorymge_id=38 ) AND `product_status` = '1' LIMIT 1 [ RunTime:0.003760s ] [ sql ] [ SQL ] SELECT `material`.`id`,`material`.`name`,`material`.`number`,`material`.`avatar`,`material`.`amount`,`material`.`warn_amount`,`material`.`occupy_amount`,`material`.`factorymge_id`,`material`.`is_stop_status`,`material`.`admin_id`,`material`.`price`,`material`.`danwei`,`material`.`quehuo_status`,`material`.`put_position`,`material`.`is_has_sup`,`material`.`staff_ids`,`material`.`staff_names`,`material`.`createtime`,`material`.`updatetime`,`material`.`is_delete`,factorymge.id AS factorymge__id,factorymge.name AS factorymge__name,factorymge.connect_name AS factorymge__connect_name,factorymge.phone_num AS factorymge__phone_num,factorymge.fax_num AS factorymge__fax_num,factorymge.build_order_yuan AS factorymge__build_order_yuan,factorymge.operator AS factorymge__operator,factorymge.city AS factorymge__city,factorymge.address AS factorymge__address,factorymge.en_switch AS factorymge__en_switch,factorymge.admin_id AS factorymge__admin_id,factorymge.createtime AS factorymge__createtime,factorymge.updatetime AS factorymge__updatetime,sum(amount*price) as total FROM `ot_material` `material` LEFT JOIN `ot_factorymge` `factorymge` ON `material`.`factorymge_id`=`factorymge`.`id` WHERE ( factorymge_id=38 ) LIMIT 1 [ RunTime:0.000562s ] [ sql ] [ SQL ] UPDATE `ot_zichan` SET `carmaterialcountprice`=0,`carmaterialcountpricediffer`=0,`countpricediffer`=0,`shoudbeshoucountprice`=0,`productcountprice`=NULL,`lingcountprice`=NULL,`shoudbefucountprice`=0,`xianjin`=0,`countprice`=0 WHERE `id` = 26178 [ RunTime:0.004342s ] [ sql ] [ SQL ] SELECT * FROM `ot_zichan` WHERE `factorymge_id` = 39 AND `year` = 2026 AND `month` = 10 AND `day` = 5 LIMIT 1 [ RunTime:0.018551s ] [ sql ] [ SQL ] SELECT * FROM `ot_zichan` WHERE `factorymge_id` = 39 AND `year` = 2026 AND `month` = 10 AND `day` = 6 LIMIT 1 [ RunTime:0.017914s ] [ sql ] [ SQL ] SELECT `orderinfo`.`id` FROM `ot_orderinfo` `orderinfo` LEFT JOIN `ot_factorymge` `factorymge` ON `orderinfo`.`factorymge_id`=`factorymge`.`id` LEFT JOIN `ot_productinfo` `productinfo` ON `orderinfo`.`productinfo_id`=`productinfo`.`id` WHERE ( orderinfo.factorymge_id = 39 ) AND ( orderinfo.pid = 0 ) AND ( orderinfo.actual_amount > 0 ) AND ( orderinfo.order_status in ("1","2") ) [ RunTime:0.028758s ] [ sql ] [ SQL ] SELECT sum(quantity*price) as total FROM `ot_orderandmaterial` WHERE `orderinfo_id` IN ('') LIMIT 1 [ RunTime:0.002013s ] [ sql ] [ SQL ] SELECT `orderinfo`.`id`,`orderinfo`.`nei_number`,`orderinfo`.`number`,`orderinfo`.`pid`,`orderinfo`.`order_company`,`orderinfo`.`order_connect`,`orderinfo`.`order_phone`,`orderinfo`.`kehu_id`,`orderinfo`.`price`,`orderinfo`.`material_id`,`orderinfo`.`pProductinfo_id`,`orderinfo`.`productinfo_id`,`orderinfo`.`order_type`,`orderinfo`.`order_status`,`orderinfo`.`all_order_status`,`orderinfo`.`shengchan_status`,`orderinfo`.`zuixinshuoming`,`orderinfo`.`guzhangshu`,`orderinfo`.`zuixinguzhang`,`orderinfo`.`techprocess_id`,`orderinfo`.`actual_amount`,`orderinfo`.`kucun_amount`,`orderinfo`.`produce_amount`,`orderinfo`.`produced_amount`,`orderinfo`.`waste_amount`,`orderinfo`.`produced_time`,`orderinfo`.`send_amount`,`orderinfo`.`ruku_posi`,`orderinfo`.`sent_amount`,`orderinfo`.`out_time`,`orderinfo`.`build_order_staffid`,`orderinfo`.`factorymge_id`,`orderinfo`.`admin_id`,`orderinfo`.`remind_day`,`orderinfo`.`build_time`,`orderinfo`.`end_time`,`orderinfo`.`responsible_staffinfos`,`orderinfo`.`responsible_staffinfovars`,`orderinfo`.`feedback`,`orderinfo`.`guoqitime`,`orderinfo`.`guoqi_status`,`orderinfo`.`put_position`,`orderinfo`.`createtime`,`orderinfo`.`updatetime`,`orderinfo`.`is_modify`,`orderinfo`.`purchaseorder_id`,factorymge.id AS factorymge__id,factorymge.name AS factorymge__name,factorymge.connect_name AS factorymge__connect_name,factorymge.phone_num AS factorymge__phone_num,factorymge.fax_num AS factorymge__fax_num,factorymge.build_order_yuan AS factorymge__build_order_yuan,factorymge.operator AS factorymge__operator,factorymge.city AS factorymge__city,factorymge.address AS factorymge__address,factorymge.en_switch AS factorymge__en_switch,factorymge.admin_id AS factorymge__admin_id,factorymge.createtime AS factorymge__createtime,factorymge.updatetime AS factorymge__updatetime,productinfo.id AS productinfo__id,productinfo.product_avatar AS productinfo__product_avatar,productinfo.name AS productinfo__name,productinfo.product_num AS productinfo__product_num,productinfo.kucun AS productinfo__kucun,productinfo.takeup_kucun AS productinfo__takeup_kucun,productinfo.staff_ids AS productinfo__staff_ids,productinfo.staff_names AS productinfo__staff_names,productinfo.pid AS productinfo__pid,productinfo.corresponding_num AS productinfo__corresponding_num,productinfo.position AS productinfo__position,productinfo.price AS productinfo__price,productinfo.factorymge_id AS productinfo__factorymge_id,productinfo.product_status AS productinfo__product_status,productinfo.admin_id AS productinfo__admin_id,productinfo.createtime AS productinfo__createtime,productinfo.updatetime AS productinfo__updatetime,sum(orderinfo.send_amount*orderinfo.price) as total FROM `ot_orderinfo` `orderinfo` LEFT JOIN `ot_factorymge` `factorymge` ON `orderinfo`.`factorymge_id`=`factorymge`.`id` LEFT JOIN `ot_productinfo` `productinfo` ON `orderinfo`.`productinfo_id`=`productinfo`.`id` WHERE ( orderinfo.factorymge_id = 39 ) AND ( orderinfo.pid != 0 ) AND ( orderinfo.actual_amount > 0 ) AND ( orderinfo.order_status in ("1","2") ) AND ( orderinfo.produced_time = 0 ) LIMIT 1 [ RunTime:0.081358s ] [ sql ] [ SQL ] SELECT `productinfo`.`id`,`productinfo`.`product_avatar`,`productinfo`.`name`,`productinfo`.`product_num`,`productinfo`.`kucun`,`productinfo`.`takeup_kucun`,`productinfo`.`staff_ids`,`productinfo`.`staff_names`,`productinfo`.`pid`,`productinfo`.`corresponding_num`,`productinfo`.`position`,`productinfo`.`price`,`productinfo`.`factorymge_id`,`productinfo`.`product_status`,`productinfo`.`admin_id`,`productinfo`.`createtime`,`productinfo`.`updatetime`,factorymge.id AS factorymge__id,factorymge.name AS factorymge__name,factorymge.connect_name AS factorymge__connect_name,factorymge.phone_num AS factorymge__phone_num,factorymge.fax_num AS factorymge__fax_num,factorymge.build_order_yuan AS factorymge__build_order_yuan,factorymge.operator AS factorymge__operator,factorymge.city AS factorymge__city,factorymge.address AS factorymge__address,factorymge.en_switch AS factorymge__en_switch,factorymge.admin_id AS factorymge__admin_id,factorymge.createtime AS factorymge__createtime,factorymge.updatetime AS factorymge__updatetime,sum(kucun*price) as total FROM `ot_productinfo` `productinfo` LEFT JOIN `ot_factorymge` `factorymge` ON `productinfo`.`factorymge_id`=`factorymge`.`id` WHERE ( factorymge_id=39 ) AND `product_status` = '1' LIMIT 1 [ RunTime:0.003731s ] [ sql ] [ SQL ] SELECT `material`.`id`,`material`.`name`,`material`.`number`,`material`.`avatar`,`material`.`amount`,`material`.`warn_amount`,`material`.`occupy_amount`,`material`.`factorymge_id`,`material`.`is_stop_status`,`material`.`admin_id`,`material`.`price`,`material`.`danwei`,`material`.`quehuo_status`,`material`.`put_position`,`material`.`is_has_sup`,`material`.`staff_ids`,`material`.`staff_names`,`material`.`createtime`,`material`.`updatetime`,`material`.`is_delete`,factorymge.id AS factorymge__id,factorymge.name AS factorymge__name,factorymge.connect_name AS factorymge__connect_name,factorymge.phone_num AS factorymge__phone_num,factorymge.fax_num AS factorymge__fax_num,factorymge.build_order_yuan AS factorymge__build_order_yuan,factorymge.operator AS factorymge__operator,factorymge.city AS factorymge__city,factorymge.address AS factorymge__address,factorymge.en_switch AS factorymge__en_switch,factorymge.admin_id AS factorymge__admin_id,factorymge.createtime AS factorymge__createtime,factorymge.updatetime AS factorymge__updatetime,sum(amount*price) as total FROM `ot_material` `material` LEFT JOIN `ot_factorymge` `factorymge` ON `material`.`factorymge_id`=`factorymge`.`id` WHERE ( factorymge_id=39 ) LIMIT 1 [ RunTime:0.000658s ] [ sql ] [ SQL ] UPDATE `ot_zichan` SET `carmaterialcountprice`=0,`carmaterialcountpricediffer`=0,`countpricediffer`=0,`shoudbeshoucountprice`=0,`productcountprice`=0,`lingcountprice`=140,`shoudbefucountprice`=0,`xianjin`=0,`countprice`=140 WHERE `id` = 26179 [ RunTime:0.005488s ] [ sql ] [ SQL ] SELECT * FROM `ot_zichan` WHERE `factorymge_id` = 40 AND `year` = 2026 AND `month` = 10 AND `day` = 5 LIMIT 1 [ RunTime:0.024226s ] [ sql ] [ SQL ] SELECT * FROM `ot_zichan` WHERE `factorymge_id` = 40 AND `year` = 2026 AND `month` = 10 AND `day` = 6 LIMIT 1 [ RunTime:0.020027s ] [ sql ] [ SQL ] SELECT `orderinfo`.`id` FROM `ot_orderinfo` `orderinfo` LEFT JOIN `ot_factorymge` `factorymge` ON `orderinfo`.`factorymge_id`=`factorymge`.`id` LEFT JOIN `ot_productinfo` `productinfo` ON `orderinfo`.`productinfo_id`=`productinfo`.`id` WHERE ( orderinfo.factorymge_id = 40 ) AND ( orderinfo.pid = 0 ) AND ( orderinfo.actual_amount > 0 ) AND ( orderinfo.order_status in ("1","2") ) [ RunTime:0.025745s ] [ sql ] [ SQL ] SELECT sum(quantity*price) as total FROM `ot_orderandmaterial` WHERE `orderinfo_id` IN (37629,47147,48212,51578,52055,54680,56140,56469,56843,57835,58390,58558,58978,59006,59259,59355,59359,59360,59431,59432,59434,59435,59439,59441,59828,59881,59885,59886,59887,59889,59922,59960,59976,59980,59981,59982,60013,60037,60045,60046,60142,60144,60146,60148,60149,60308,60309,60310,60313,60314,60342,60343,60344,60345,60346,60347,60348,60349,60352,60353,60354,60355,60356,60357,60358,60359,60360,60361,60362,60363,60364,60366,60367,60369,60370,60371,60372,60375,60377,60378,60396,60397,60400,60401,60402,60403,60404,60405,60406,60407,60408,60409,60410,60411,60412,60413,60414) LIMIT 1 [ RunTime:0.002579s ] [ sql ] [ SQL ] SELECT `orderinfo`.`id`,`orderinfo`.`nei_number`,`orderinfo`.`number`,`orderinfo`.`pid`,`orderinfo`.`order_company`,`orderinfo`.`order_connect`,`orderinfo`.`order_phone`,`orderinfo`.`kehu_id`,`orderinfo`.`price`,`orderinfo`.`material_id`,`orderinfo`.`pProductinfo_id`,`orderinfo`.`productinfo_id`,`orderinfo`.`order_type`,`orderinfo`.`order_status`,`orderinfo`.`all_order_status`,`orderinfo`.`shengchan_status`,`orderinfo`.`zuixinshuoming`,`orderinfo`.`guzhangshu`,`orderinfo`.`zuixinguzhang`,`orderinfo`.`techprocess_id`,`orderinfo`.`actual_amount`,`orderinfo`.`kucun_amount`,`orderinfo`.`produce_amount`,`orderinfo`.`produced_amount`,`orderinfo`.`waste_amount`,`orderinfo`.`produced_time`,`orderinfo`.`send_amount`,`orderinfo`.`ruku_posi`,`orderinfo`.`sent_amount`,`orderinfo`.`out_time`,`orderinfo`.`build_order_staffid`,`orderinfo`.`factorymge_id`,`orderinfo`.`admin_id`,`orderinfo`.`remind_day`,`orderinfo`.`build_time`,`orderinfo`.`end_time`,`orderinfo`.`responsible_staffinfos`,`orderinfo`.`responsible_staffinfovars`,`orderinfo`.`feedback`,`orderinfo`.`guoqitime`,`orderinfo`.`guoqi_status`,`orderinfo`.`put_position`,`orderinfo`.`createtime`,`orderinfo`.`updatetime`,`orderinfo`.`is_modify`,`orderinfo`.`purchaseorder_id`,factorymge.id AS factorymge__id,factorymge.name AS factorymge__name,factorymge.connect_name AS factorymge__connect_name,factorymge.phone_num AS factorymge__phone_num,factorymge.fax_num AS factorymge__fax_num,factorymge.build_order_yuan AS factorymge__build_order_yuan,factorymge.operator AS factorymge__operator,factorymge.city AS factorymge__city,factorymge.address AS factorymge__address,factorymge.en_switch AS factorymge__en_switch,factorymge.admin_id AS factorymge__admin_id,factorymge.createtime AS factorymge__createtime,factorymge.updatetime AS factorymge__updatetime,productinfo.id AS productinfo__id,productinfo.product_avatar AS productinfo__product_avatar,productinfo.name AS productinfo__name,productinfo.product_num AS productinfo__product_num,productinfo.kucun AS productinfo__kucun,productinfo.takeup_kucun AS productinfo__takeup_kucun,productinfo.staff_ids AS productinfo__staff_ids,productinfo.staff_names AS productinfo__staff_names,productinfo.pid AS productinfo__pid,productinfo.corresponding_num AS productinfo__corresponding_num,productinfo.position AS productinfo__position,productinfo.price AS productinfo__price,productinfo.factorymge_id AS productinfo__factorymge_id,productinfo.product_status AS productinfo__product_status,productinfo.admin_id AS productinfo__admin_id,productinfo.createtime AS productinfo__createtime,productinfo.updatetime AS productinfo__updatetime,sum(orderinfo.send_amount*orderinfo.price) as total FROM `ot_orderinfo` `orderinfo` LEFT JOIN `ot_factorymge` `factorymge` ON `orderinfo`.`factorymge_id`=`factorymge`.`id` LEFT JOIN `ot_productinfo` `productinfo` ON `orderinfo`.`productinfo_id`=`productinfo`.`id` WHERE ( orderinfo.factorymge_id = 40 ) AND ( orderinfo.pid != 0 ) AND ( orderinfo.actual_amount > 0 ) AND ( orderinfo.order_status in ("1","2") ) AND ( orderinfo.produced_time = 0 ) LIMIT 1 [ RunTime:0.077133s ] [ sql ] [ SQL ] SELECT `productinfo`.`id`,`productinfo`.`product_avatar`,`productinfo`.`name`,`productinfo`.`product_num`,`productinfo`.`kucun`,`productinfo`.`takeup_kucun`,`productinfo`.`staff_ids`,`productinfo`.`staff_names`,`productinfo`.`pid`,`productinfo`.`corresponding_num`,`productinfo`.`position`,`productinfo`.`price`,`productinfo`.`factorymge_id`,`productinfo`.`product_status`,`productinfo`.`admin_id`,`productinfo`.`createtime`,`productinfo`.`updatetime`,factorymge.id AS factorymge__id,factorymge.name AS factorymge__name,factorymge.connect_name AS factorymge__connect_name,factorymge.phone_num AS factorymge__phone_num,factorymge.fax_num AS factorymge__fax_num,factorymge.build_order_yuan AS factorymge__build_order_yuan,factorymge.operator AS factorymge__operator,factorymge.city AS factorymge__city,factorymge.address AS factorymge__address,factorymge.en_switch AS factorymge__en_switch,factorymge.admin_id AS factorymge__admin_id,factorymge.createtime AS factorymge__createtime,factorymge.updatetime AS factorymge__updatetime,sum(kucun*price) as total FROM `ot_productinfo` `productinfo` LEFT JOIN `ot_factorymge` `factorymge` ON `productinfo`.`factorymge_id`=`factorymge`.`id` WHERE ( factorymge_id=40 ) AND `product_status` = '1' LIMIT 1 [ RunTime:0.003057s ] [ sql ] [ SQL ] SELECT `material`.`id`,`material`.`name`,`material`.`number`,`material`.`avatar`,`material`.`amount`,`material`.`warn_amount`,`material`.`occupy_amount`,`material`.`factorymge_id`,`material`.`is_stop_status`,`material`.`admin_id`,`material`.`price`,`material`.`danwei`,`material`.`quehuo_status`,`material`.`put_position`,`material`.`is_has_sup`,`material`.`staff_ids`,`material`.`staff_names`,`material`.`createtime`,`material`.`updatetime`,`material`.`is_delete`,factorymge.id AS factorymge__id,factorymge.name AS factorymge__name,factorymge.connect_name AS factorymge__connect_name,factorymge.phone_num AS factorymge__phone_num,factorymge.fax_num AS factorymge__fax_num,factorymge.build_order_yuan AS factorymge__build_order_yuan,factorymge.operator AS factorymge__operator,factorymge.city AS factorymge__city,factorymge.address AS factorymge__address,factorymge.en_switch AS factorymge__en_switch,factorymge.admin_id AS factorymge__admin_id,factorymge.createtime AS factorymge__createtime,factorymge.updatetime AS factorymge__updatetime,sum(amount*price) as total FROM `ot_material` `material` LEFT JOIN `ot_factorymge` `factorymge` ON `material`.`factorymge_id`=`factorymge`.`id` WHERE ( factorymge_id=40 ) LIMIT 1 [ RunTime:0.000999s ] [ sql ] [ SQL ] UPDATE `ot_zichan` SET `carmaterialcountprice`=4491093.418,`carmaterialcountpricediffer`=-47343.062000001,`countpricediffer`=15063.587999999,`shoudbeshoucountprice`=-1020525.72,`productcountprice`=3069244.3622,`lingcountprice`=3682399.428,`shoudbefucountprice`=375927.81,`xianjin`=5570106.1,`countprice`=15416389.7782 WHERE `id` = 26180 [ RunTime:0.003966s ] [ sql ] [ SQL ] SELECT * FROM `ot_zichan` WHERE `factorymge_id` = 41 AND `year` = 2026 AND `month` = 10 AND `day` = 5 LIMIT 1 [ RunTime:0.017770s ] [ sql ] [ SQL ] SELECT * FROM `ot_zichan` WHERE `factorymge_id` = 41 AND `year` = 2026 AND `month` = 10 AND `day` = 6 LIMIT 1 [ RunTime:0.017197s ] [ sql ] [ SQL ] SELECT `orderinfo`.`id` FROM `ot_orderinfo` `orderinfo` LEFT JOIN `ot_factorymge` `factorymge` ON `orderinfo`.`factorymge_id`=`factorymge`.`id` LEFT JOIN `ot_productinfo` `productinfo` ON `orderinfo`.`productinfo_id`=`productinfo`.`id` WHERE ( orderinfo.factorymge_id = 41 ) AND ( orderinfo.pid = 0 ) AND ( orderinfo.actual_amount > 0 ) AND ( orderinfo.order_status in ("1","2") ) [ RunTime:0.024011s ] [ sql ] [ SQL ] SELECT sum(quantity*price) as total FROM `ot_orderandmaterial` WHERE `orderinfo_id` IN ('') LIMIT 1 [ RunTime:0.001782s ] [ sql ] [ SQL ] SELECT `orderinfo`.`id`,`orderinfo`.`nei_number`,`orderinfo`.`number`,`orderinfo`.`pid`,`orderinfo`.`order_company`,`orderinfo`.`order_connect`,`orderinfo`.`order_phone`,`orderinfo`.`kehu_id`,`orderinfo`.`price`,`orderinfo`.`material_id`,`orderinfo`.`pProductinfo_id`,`orderinfo`.`productinfo_id`,`orderinfo`.`order_type`,`orderinfo`.`order_status`,`orderinfo`.`all_order_status`,`orderinfo`.`shengchan_status`,`orderinfo`.`zuixinshuoming`,`orderinfo`.`guzhangshu`,`orderinfo`.`zuixinguzhang`,`orderinfo`.`techprocess_id`,`orderinfo`.`actual_amount`,`orderinfo`.`kucun_amount`,`orderinfo`.`produce_amount`,`orderinfo`.`produced_amount`,`orderinfo`.`waste_amount`,`orderinfo`.`produced_time`,`orderinfo`.`send_amount`,`orderinfo`.`ruku_posi`,`orderinfo`.`sent_amount`,`orderinfo`.`out_time`,`orderinfo`.`build_order_staffid`,`orderinfo`.`factorymge_id`,`orderinfo`.`admin_id`,`orderinfo`.`remind_day`,`orderinfo`.`build_time`,`orderinfo`.`end_time`,`orderinfo`.`responsible_staffinfos`,`orderinfo`.`responsible_staffinfovars`,`orderinfo`.`feedback`,`orderinfo`.`guoqitime`,`orderinfo`.`guoqi_status`,`orderinfo`.`put_position`,`orderinfo`.`createtime`,`orderinfo`.`updatetime`,`orderinfo`.`is_modify`,`orderinfo`.`purchaseorder_id`,factorymge.id AS factorymge__id,factorymge.name AS factorymge__name,factorymge.connect_name AS factorymge__connect_name,factorymge.phone_num AS factorymge__phone_num,factorymge.fax_num AS factorymge__fax_num,factorymge.build_order_yuan AS factorymge__build_order_yuan,factorymge.operator AS factorymge__operator,factorymge.city AS factorymge__city,factorymge.address AS factorymge__address,factorymge.en_switch AS factorymge__en_switch,factorymge.admin_id AS factorymge__admin_id,factorymge.createtime AS factorymge__createtime,factorymge.updatetime AS factorymge__updatetime,productinfo.id AS productinfo__id,productinfo.product_avatar AS productinfo__product_avatar,productinfo.name AS productinfo__name,productinfo.product_num AS productinfo__product_num,productinfo.kucun AS productinfo__kucun,productinfo.takeup_kucun AS productinfo__takeup_kucun,productinfo.staff_ids AS productinfo__staff_ids,productinfo.staff_names AS productinfo__staff_names,productinfo.pid AS productinfo__pid,productinfo.corresponding_num AS productinfo__corresponding_num,productinfo.position AS productinfo__position,productinfo.price AS productinfo__price,productinfo.factorymge_id AS productinfo__factorymge_id,productinfo.product_status AS productinfo__product_status,productinfo.admin_id AS productinfo__admin_id,productinfo.createtime AS productinfo__createtime,productinfo.updatetime AS productinfo__updatetime,sum(orderinfo.send_amount*orderinfo.price) as total FROM `ot_orderinfo` `orderinfo` LEFT JOIN `ot_factorymge` `factorymge` ON `orderinfo`.`factorymge_id`=`factorymge`.`id` LEFT JOIN `ot_productinfo` `productinfo` ON `orderinfo`.`productinfo_id`=`productinfo`.`id` WHERE ( orderinfo.factorymge_id = 41 ) AND ( orderinfo.pid != 0 ) AND ( orderinfo.actual_amount > 0 ) AND ( orderinfo.order_status in ("1","2") ) AND ( orderinfo.produced_time = 0 ) LIMIT 1 [ RunTime:0.072337s ] [ sql ] [ SQL ] SELECT `productinfo`.`id`,`productinfo`.`product_avatar`,`productinfo`.`name`,`productinfo`.`product_num`,`productinfo`.`kucun`,`productinfo`.`takeup_kucun`,`productinfo`.`staff_ids`,`productinfo`.`staff_names`,`productinfo`.`pid`,`productinfo`.`corresponding_num`,`productinfo`.`position`,`productinfo`.`price`,`productinfo`.`factorymge_id`,`productinfo`.`product_status`,`productinfo`.`admin_id`,`productinfo`.`createtime`,`productinfo`.`updatetime`,factorymge.id AS factorymge__id,factorymge.name AS factorymge__name,factorymge.connect_name AS factorymge__connect_name,factorymge.phone_num AS factorymge__phone_num,factorymge.fax_num AS factorymge__fax_num,factorymge.build_order_yuan AS factorymge__build_order_yuan,factorymge.operator AS factorymge__operator,factorymge.city AS factorymge__city,factorymge.address AS factorymge__address,factorymge.en_switch AS factorymge__en_switch,factorymge.admin_id AS factorymge__admin_id,factorymge.createtime AS factorymge__createtime,factorymge.updatetime AS factorymge__updatetime,sum(kucun*price) as total FROM `ot_productinfo` `productinfo` LEFT JOIN `ot_factorymge` `factorymge` ON `productinfo`.`factorymge_id`=`factorymge`.`id` WHERE ( factorymge_id=41 ) AND `product_status` = '1' LIMIT 1 [ RunTime:0.002784s ] [ sql ] [ SQL ] SELECT `material`.`id`,`material`.`name`,`material`.`number`,`material`.`avatar`,`material`.`amount`,`material`.`warn_amount`,`material`.`occupy_amount`,`material`.`factorymge_id`,`material`.`is_stop_status`,`material`.`admin_id`,`material`.`price`,`material`.`danwei`,`material`.`quehuo_status`,`material`.`put_position`,`material`.`is_has_sup`,`material`.`staff_ids`,`material`.`staff_names`,`material`.`createtime`,`material`.`updatetime`,`material`.`is_delete`,factorymge.id AS factorymge__id,factorymge.name AS factorymge__name,factorymge.connect_name AS factorymge__connect_name,factorymge.phone_num AS factorymge__phone_num,factorymge.fax_num AS factorymge__fax_num,factorymge.build_order_yuan AS factorymge__build_order_yuan,factorymge.operator AS factorymge__operator,factorymge.city AS factorymge__city,factorymge.address AS factorymge__address,factorymge.en_switch AS factorymge__en_switch,factorymge.admin_id AS factorymge__admin_id,factorymge.createtime AS factorymge__createtime,factorymge.updatetime AS factorymge__updatetime,sum(amount*price) as total FROM `ot_material` `material` LEFT JOIN `ot_factorymge` `factorymge` ON `material`.`factorymge_id`=`factorymge`.`id` WHERE ( factorymge_id=41 ) LIMIT 1 [ RunTime:0.000406s ] [ sql ] [ SQL ] UPDATE `ot_zichan` SET `carmaterialcountprice`=0,`carmaterialcountpricediffer`=0,`countpricediffer`=0,`shoudbeshoucountprice`=0,`productcountprice`=NULL,`lingcountprice`=NULL,`shoudbefucountprice`=0,`xianjin`=0,`countprice`=0 WHERE `id` = 26181 [ RunTime:0.005229s ] [ sql ] [ SQL ] SELECT * FROM `ot_zichan` WHERE `factorymge_id` = 42 AND `year` = 2026 AND `month` = 10 AND `day` = 5 LIMIT 1 [ RunTime:0.017039s ] [ sql ] [ SQL ] SELECT * FROM `ot_zichan` WHERE `factorymge_id` = 42 AND `year` = 2026 AND `month` = 10 AND `day` = 6 LIMIT 1 [ RunTime:0.016885s ] [ sql ] [ SQL ] SELECT `orderinfo`.`id` FROM `ot_orderinfo` `orderinfo` LEFT JOIN `ot_factorymge` `factorymge` ON `orderinfo`.`factorymge_id`=`factorymge`.`id` LEFT JOIN `ot_productinfo` `productinfo` ON `orderinfo`.`productinfo_id`=`productinfo`.`id` WHERE ( orderinfo.factorymge_id = 42 ) AND ( orderinfo.pid = 0 ) AND ( orderinfo.actual_amount > 0 ) AND ( orderinfo.order_status in ("1","2") ) [ RunTime:0.023920s ] [ sql ] [ SQL ] SELECT sum(quantity*price) as total FROM `ot_orderandmaterial` WHERE `orderinfo_id` IN ('') LIMIT 1 [ RunTime:0.001742s ] [ sql ] [ SQL ] SELECT `orderinfo`.`id`,`orderinfo`.`nei_number`,`orderinfo`.`number`,`orderinfo`.`pid`,`orderinfo`.`order_company`,`orderinfo`.`order_connect`,`orderinfo`.`order_phone`,`orderinfo`.`kehu_id`,`orderinfo`.`price`,`orderinfo`.`material_id`,`orderinfo`.`pProductinfo_id`,`orderinfo`.`productinfo_id`,`orderinfo`.`order_type`,`orderinfo`.`order_status`,`orderinfo`.`all_order_status`,`orderinfo`.`shengchan_status`,`orderinfo`.`zuixinshuoming`,`orderinfo`.`guzhangshu`,`orderinfo`.`zuixinguzhang`,`orderinfo`.`techprocess_id`,`orderinfo`.`actual_amount`,`orderinfo`.`kucun_amount`,`orderinfo`.`produce_amount`,`orderinfo`.`produced_amount`,`orderinfo`.`waste_amount`,`orderinfo`.`produced_time`,`orderinfo`.`send_amount`,`orderinfo`.`ruku_posi`,`orderinfo`.`sent_amount`,`orderinfo`.`out_time`,`orderinfo`.`build_order_staffid`,`orderinfo`.`factorymge_id`,`orderinfo`.`admin_id`,`orderinfo`.`remind_day`,`orderinfo`.`build_time`,`orderinfo`.`end_time`,`orderinfo`.`responsible_staffinfos`,`orderinfo`.`responsible_staffinfovars`,`orderinfo`.`feedback`,`orderinfo`.`guoqitime`,`orderinfo`.`guoqi_status`,`orderinfo`.`put_position`,`orderinfo`.`createtime`,`orderinfo`.`updatetime`,`orderinfo`.`is_modify`,`orderinfo`.`purchaseorder_id`,factorymge.id AS factorymge__id,factorymge.name AS factorymge__name,factorymge.connect_name AS factorymge__connect_name,factorymge.phone_num AS factorymge__phone_num,factorymge.fax_num AS factorymge__fax_num,factorymge.build_order_yuan AS factorymge__build_order_yuan,factorymge.operator AS factorymge__operator,factorymge.city AS factorymge__city,factorymge.address AS factorymge__address,factorymge.en_switch AS factorymge__en_switch,factorymge.admin_id AS factorymge__admin_id,factorymge.createtime AS factorymge__createtime,factorymge.updatetime AS factorymge__updatetime,productinfo.id AS productinfo__id,productinfo.product_avatar AS productinfo__product_avatar,productinfo.name AS productinfo__name,productinfo.product_num AS productinfo__product_num,productinfo.kucun AS productinfo__kucun,productinfo.takeup_kucun AS productinfo__takeup_kucun,productinfo.staff_ids AS productinfo__staff_ids,productinfo.staff_names AS productinfo__staff_names,productinfo.pid AS productinfo__pid,productinfo.corresponding_num AS productinfo__corresponding_num,productinfo.position AS productinfo__position,productinfo.price AS productinfo__price,productinfo.factorymge_id AS productinfo__factorymge_id,productinfo.product_status AS productinfo__product_status,productinfo.admin_id AS productinfo__admin_id,productinfo.createtime AS productinfo__createtime,productinfo.updatetime AS productinfo__updatetime,sum(orderinfo.send_amount*orderinfo.price) as total FROM `ot_orderinfo` `orderinfo` LEFT JOIN `ot_factorymge` `factorymge` ON `orderinfo`.`factorymge_id`=`factorymge`.`id` LEFT JOIN `ot_productinfo` `productinfo` ON `orderinfo`.`productinfo_id`=`productinfo`.`id` WHERE ( orderinfo.factorymge_id = 42 ) AND ( orderinfo.pid != 0 ) AND ( orderinfo.actual_amount > 0 ) AND ( orderinfo.order_status in ("1","2") ) AND ( orderinfo.produced_time = 0 ) LIMIT 1 [ RunTime:0.080953s ] [ sql ] [ SQL ] SELECT `productinfo`.`id`,`productinfo`.`product_avatar`,`productinfo`.`name`,`productinfo`.`product_num`,`productinfo`.`kucun`,`productinfo`.`takeup_kucun`,`productinfo`.`staff_ids`,`productinfo`.`staff_names`,`productinfo`.`pid`,`productinfo`.`corresponding_num`,`productinfo`.`position`,`productinfo`.`price`,`productinfo`.`factorymge_id`,`productinfo`.`product_status`,`productinfo`.`admin_id`,`productinfo`.`createtime`,`productinfo`.`updatetime`,factorymge.id AS factorymge__id,factorymge.name AS factorymge__name,factorymge.connect_name AS factorymge__connect_name,factorymge.phone_num AS factorymge__phone_num,factorymge.fax_num AS factorymge__fax_num,factorymge.build_order_yuan AS factorymge__build_order_yuan,factorymge.operator AS factorymge__operator,factorymge.city AS factorymge__city,factorymge.address AS factorymge__address,factorymge.en_switch AS factorymge__en_switch,factorymge.admin_id AS factorymge__admin_id,factorymge.createtime AS factorymge__createtime,factorymge.updatetime AS factorymge__updatetime,sum(kucun*price) as total FROM `ot_productinfo` `productinfo` LEFT JOIN `ot_factorymge` `factorymge` ON `productinfo`.`factorymge_id`=`factorymge`.`id` WHERE ( factorymge_id=42 ) AND `product_status` = '1' LIMIT 1 [ RunTime:0.003132s ] [ sql ] [ SQL ] SELECT `material`.`id`,`material`.`name`,`material`.`number`,`material`.`avatar`,`material`.`amount`,`material`.`warn_amount`,`material`.`occupy_amount`,`material`.`factorymge_id`,`material`.`is_stop_status`,`material`.`admin_id`,`material`.`price`,`material`.`danwei`,`material`.`quehuo_status`,`material`.`put_position`,`material`.`is_has_sup`,`material`.`staff_ids`,`material`.`staff_names`,`material`.`createtime`,`material`.`updatetime`,`material`.`is_delete`,factorymge.id AS factorymge__id,factorymge.name AS factorymge__name,factorymge.connect_name AS factorymge__connect_name,factorymge.phone_num AS factorymge__phone_num,factorymge.fax_num AS factorymge__fax_num,factorymge.build_order_yuan AS factorymge__build_order_yuan,factorymge.operator AS factorymge__operator,factorymge.city AS factorymge__city,factorymge.address AS factorymge__address,factorymge.en_switch AS factorymge__en_switch,factorymge.admin_id AS factorymge__admin_id,factorymge.createtime AS factorymge__createtime,factorymge.updatetime AS factorymge__updatetime,sum(amount*price) as total FROM `ot_material` `material` LEFT JOIN `ot_factorymge` `factorymge` ON `material`.`factorymge_id`=`factorymge`.`id` WHERE ( factorymge_id=42 ) LIMIT 1 [ RunTime:0.000823s ] [ sql ] [ SQL ] UPDATE `ot_zichan` SET `carmaterialcountprice`=0,`carmaterialcountpricediffer`=0,`countpricediffer`=0,`shoudbeshoucountprice`=0,`productcountprice`=0,`lingcountprice`=0,`shoudbefucountprice`=0,`xianjin`=0,`countprice`=0 WHERE `id` = 26182 [ RunTime:0.007356s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `ot_admin_log` [ RunTime:0.000729s ] [ error ] [10501]SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'useragent' cannot be null[/alidata/www/gendan/thinkphp/library/think/db/Connection.php:463] --------------------------------------------------------------- [ 2026-10-07T01:00:39+08:00 ] 66.132.195.107 GET / [ info ] 47.105.33.115:8080/ [运行时间：0.027160s][吞吐率：36.82req/s] [内存消耗：3,332.94kb] [文件加载：69] [ info ] [ BEHAVIOR ] Run Closure @app_init [ RunTime:0.000039s ] [ info ] [ CACHE ] INIT File [ info ] [ BEHAVIOR ] Run Closure @app_init [ RunTime:0.001105s ] [ info ] [ LANG ] /alidata/www/gendan/thinkphp/lang/zh-cn.php [ info ] [ ROUTE ] array ( 'type' => 'module', 'module' => array ( 0 => '', 1 => NULL, 2 => NULL, ), ) [ info ] [ HEADER ] array ( 'host' => '47.105.33.115:8080', 'user-agent' => 'Mozilla/5.0 (compatible; CensysInspect/1.1; +https://about.censys.io/)', 'accept' => '*/*', 'accept-encoding' => 'gzip', ) [ info ] [ PARAM ] array ( ) [ info ] [ LANG ] /alidata/www/gendan/public/../application/admin/lang/zh-cn.php [ info ] [ BEHAVIOR ] Run app\common\behavior\Common @module_init [ RunTime:0.001507s ] [ info ] [ SESSION ] INIT array ( 'id' => '', 'var_session_id' => '', 'prefix' => 'think', 'type' => '', 'auto_start' => true, 'expire' => 2592000, ) [ info ] [ VIEW ] /alidata/www/gendan/public/../application/common/view/tpl/dispatch_jump.tpl [ array ( 0 => 'code', 1 => 'msg', 2 => 'data', 3 => 'url', 4 => 'wait', ) ] [ info ] [ BEHAVIOR ] Run app\admin\behavior\AdminLog @app_end [ RunTime:0.000101s ] [ info ] [ LOG ] INIT File --------------------------------------------------------------- [ 2026-10-07T01:00:45+08:00 ] 66.132.195.107 GET /favicon.ico [ info ] 47.105.33.115:8080/favicon.ico [运行时间：0.019027s][吞吐率：52.56req/s] [内存消耗：2,225.45kb] [文件加载：51] [ info ] [ BEHAVIOR ] Run Closure @app_init [ RunTime:0.000037s ] [ info ] [ CACHE ] INIT File [ info ] [ BEHAVIOR ] Run Closure @app_init [ RunTime:0.001123s ] [ info ] [ LANG ] /alidata/www/gendan/thinkphp/lang/zh-cn.php [ info ] [ ROUTE ] array ( 'type' => 'module', 'module' => array ( 0 => 'favicon.ico', 1 => NULL, 2 => NULL, ), ) [ info ] [ HEADER ] array ( 'host' => '47.105.33.115:8080', 'user-agent' => 'Mozilla/5.0 (compatible; CensysInspect/1.1; +https://about.censys.io/)', 'accept-encoding' => 'gzip', 'connection' => 'close', ) [ info ] [ PARAM ] array ( ) [ info ] [ LOG ] INIT File --------------------------------------------------------------- [ 2026-10-07T01:00:56+08:00 ] 66.132.195.107 GET /login [ info ] 47.105.33.115:8080/login [运行时间：0.019370s][吞吐率：51.63req/s] [内存消耗：2,225.59kb] [文件加载：51] [ info ] [ BEHAVIOR ] Run Closure @app_init [ RunTime:0.000039s ] [ info ] [ CACHE ] INIT File [ info ] [ BEHAVIOR ] Run Closure @app_init [ RunTime:0.001168s ] [ info ] [ LANG ] /alidata/www/gendan/thinkphp/lang/zh-cn.php [ info ] [ ROUTE ] array ( 'type' => 'module', 'module' => array ( 0 => 'login', 1 => NULL, 2 => NULL, ), ) [ info ] [ HEADER ] array ( 'host' => '47.105.33.115:8080', 'user-agent' => 'Mozilla/5.0 (compatible; CensysInspect/1.1; +https://about.censys.io/)', 'accept' => '*/*', 'accept-encoding' => 'gzip', ) [ info ] [ PARAM ] array ( ) [ info ] [ LOG ] INIT File