[2024-09-13T16:20:39+08:00][sql] CONNECT:[ UseTime:0.005086s ] mysql:host=127.0.0.1;port=3306;dbname=bjsfjbzdhgf;charset=utf8 [2024-09-13T16:20:39+08:00][sql] SHOW FULL COLUMNS FROM `set` [ RunTime:0.000660s ] [2024-09-13T16:20:39+08:00][sql] UPDATE `set` SET `value` = 'bjsfjbzdhgf' WHERE `field` = 'database' [ RunTime:0.000269s ] [2024-09-13T16:20:39+08:00][sql] UPDATE `set` SET `value` = '北京四方继保自动化股份有限公司' WHERE `field` = 'title' [ RunTime:0.000199s ] [2024-09-13T16:20:39+08:00][sql] UPDATE `set` SET `value` = '77' WHERE `field` = 'product_sort' [ RunTime:0.000183s ] [2024-09-13T16:23:01+08:00][sql] CONNECT:[ UseTime:0.008910s ] mysql:host=127.0.0.1;port=3306;dbname=bjsfjbzdhgf;charset=utf8 [2024-09-13T16:23:01+08:00][sql] SHOW FULL COLUMNS FROM `set` [ RunTime:0.000745s ] [2024-09-13T16:23:01+08:00][sql] UPDATE `set` SET `value` = 'bjsfjbzdhgf' WHERE `field` = 'database' [ RunTime:0.000302s ] [2024-09-13T16:23:01+08:00][sql] UPDATE `set` SET `value` = '北京四方继保自动化股份有限公司' WHERE `field` = 'title' [ RunTime:0.000226s ] [2024-09-13T16:23:01+08:00][sql] UPDATE `set` SET `value` = '77' WHERE `field` = 'product_sort' [ RunTime:0.000201s ] [2024-09-13T16:23:04+08:00][sql] CONNECT:[ UseTime:0.008142s ] mysql:host=127.0.0.1;port=3306;dbname=bjsfjbzdhgf;charset=utf8 [2024-09-13T16:23:04+08:00][sql] SHOW FULL COLUMNS FROM `set` [ RunTime:0.000697s ] [2024-09-13T16:23:04+08:00][sql] UPDATE `set` SET `value` = 'bjsfjbzdhgf' WHERE `field` = 'database' [ RunTime:0.000281s ] [2024-09-13T16:23:04+08:00][sql] UPDATE `set` SET `value` = '北京四方继保自动化股份有限公司' WHERE `field` = 'title' [ RunTime:0.000266s ] [2024-09-13T16:23:04+08:00][sql] UPDATE `set` SET `value` = '77' WHERE `field` = 'product_sort' [ RunTime:0.000222s ] [2024-09-13T16:23:04+08:00][sql] SHOW FULL COLUMNS FROM `cust` [ RunTime:0.001231s ] [2024-09-13T16:23:04+08:00][sql] SELECT MAX(`number`) AS think_max FROM `cust` LIMIT 1 [ RunTime:0.000232s ] [2024-09-13T16:23:04+08:00][sql] SELECT * FROM `cust` WHERE `name` = '样品' LIMIT 1 [ RunTime:0.000244s ] [2024-09-13T16:23:04+08:00][sql] INSERT INTO `cust` SET `number` = '00001' , `name` = '样品' , `create_time` = '2024-09-13 16:23:04.714158' , `update_time` = '2024-09-13 16:23:04.714172' [ RunTime:0.000308s ] [2024-09-13T16:23:04+08:00][sql] SHOW FULL COLUMNS FROM `project` [ RunTime:0.001165s ] [2024-09-13T16:23:04+08:00][sql] SELECT * FROM `project` WHERE `name` = '样品' AND `cust` = 1 LIMIT 1 [ RunTime:0.000312s ] [2024-09-13T16:23:04+08:00][sql] INSERT INTO `project` SET `name` = '样品' , `cust` = 1 , `create_time` = '2024-09-13 16:23:04.732721' , `update_time` = '2024-09-13 16:23:04.732738' [ RunTime:0.000316s ] [2024-09-13T16:23:04+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.001015s ] [2024-09-13T16:23:04+08:00][sql] SELECT * FROM `product` [ RunTime:0.000281s ] [2024-09-13T16:23:04+08:00][sql] SELECT `value` FROM `set` WHERE `field` = 'lead_time' LIMIT 1 [ RunTime:0.000349s ] [2024-09-13T16:23:04+08:00][sql] SHOW FULL COLUMNS FROM `so` [ RunTime:0.001162s ] [2024-09-13T16:23:04+08:00][sql] SELECT * FROM `so` WHERE `cust` = 1 AND `project` = '1' AND `report_time` = '2022-02-18' LIMIT 1 [ RunTime:0.000286s ] [2024-09-13T16:23:04+08:00][sql] SELECT MAX(`number`) AS think_max FROM `so` WHERE `number` LIKE '20220211%' LIMIT 1 [ RunTime:0.000239s ] [2024-09-13T16:23:04+08:00][sql] INSERT INTO `so` SET `number` = '20220211001' , `cust` = 1 , `project` = '1' , `addr` = NULL , `linkman` = NULL , `req` = NULL , `status` = 6 , `create_time` = '2022-02-11' , `report_time` = '2022-02-18' , `update_time` = '2024-09-13 16:23:04.757808' [ RunTime:0.000296s ] [2024-09-13T16:23:04+08:00][sql] SHOW FULL COLUMNS FROM `pp` [ RunTime:0.001187s ] [2024-09-13T16:23:04+08:00][sql] SELECT * FROM `pp` WHERE `start_num` = '60940AA40591AA' AND `end_num` = '60940AA40596AA' LIMIT 1 [ RunTime:0.000295s ] [2024-09-13T16:23:04+08:00][sql] INSERT INTO `pp` SET `so` = 1 , `count` = 5 , `product` = 1 , `status` = 6 , `name` = '组合式电气火灾监控探测器' , `type` = 'CSC-916E' , `specs` = '\\' , `unit` = '台' , `need_time` = '2022-02-17' , `create_time` = '2022-02-11' , `report_time` = '2022-02-18' , `start_num` = '60940AA40591AA' , `end_num` = '60940AA40596AA' , `update_time` = '2024-09-13 16:23:04.788145' [ RunTime:0.000345s ] [2024-09-13T16:23:05+08:00][sql] CONNECT:[ UseTime:0.014108s ] mysql:host=127.0.0.1;port=3306;dbname=bjsfjbzdhgf;charset=utf8 [2024-09-13T16:23:05+08:00][sql] SHOW FULL COLUMNS FROM `set` [ RunTime:0.000648s ] [2024-09-13T16:23:05+08:00][sql] UPDATE `set` SET `value` = 'bjsfjbzdhgf' WHERE `field` = 'database' [ RunTime:0.000270s ] [2024-09-13T16:23:05+08:00][sql] UPDATE `set` SET `value` = '北京四方继保自动化股份有限公司' WHERE `field` = 'title' [ RunTime:0.000196s ] [2024-09-13T16:23:05+08:00][sql] UPDATE `set` SET `value` = '77' WHERE `field` = 'product_sort' [ RunTime:0.000182s ] [2024-09-13T16:23:05+08:00][sql] SHOW FULL COLUMNS FROM `pp` [ RunTime:0.001064s ] [2024-09-13T16:23:05+08:00][sql] SELECT * FROM `pp` WHERE `so` = 1 [ RunTime:0.000306s ] [2024-09-13T16:23:05+08:00][sql] SHOW FULL COLUMNS FROM `bom` [ RunTime:0.000848s ] [2024-09-13T16:23:05+08:00][sql] SELECT * FROM `bom` WHERE `product` = 1 [ RunTime:0.000276s ] [2024-09-13T16:23:05+08:00][sql] SHOW FULL COLUMNS FROM `bom_info` [ RunTime:0.000623s ] [2024-09-13T16:23:05+08:00][sql] SELECT * FROM `bom_info` WHERE `bom` = 1 [ RunTime:0.000257s ] [2024-09-13T16:23:05+08:00][sql] SHOW FULL COLUMNS FROM `raw` [ RunTime:0.000573s ] [2024-09-13T16:23:05+08:00][sql] SELECT * FROM `raw` [ RunTime:0.000229s ] [2024-09-13T16:23:05+08:00][sql] SHOW FULL COLUMNS FROM `mrp` [ RunTime:0.001135s ] [2024-09-13T16:23:05+08:00][sql] SELECT * FROM `mrp` WHERE `pp` = 1 AND `raw` = 1 LIMIT 1 [ RunTime:0.000246s ] [2024-09-13T16:23:05+08:00][sql] INSERT INTO `mrp` SET `so` = 1 , `pp` = 1 , `count` = 5 , `raw` = 1 , `need_time` = '2022-02-17 00:00:00' , `status` = 5 , `create_time` = '2022-02-11 00:00:00' , `update_time` = '2024-09-13 16:23:05.057647' [ RunTime:0.000267s ] [2024-09-13T16:23:05+08:00][sql] SELECT * FROM `mrp` WHERE `pp` = 1 AND `raw` = 2 LIMIT 1 [ RunTime:0.000202s ] [2024-09-13T16:23:05+08:00][sql] INSERT INTO `mrp` SET `so` = 1 , `pp` = 1 , `count` = 5 , `raw` = 2 , `need_time` = '2022-02-17 00:00:00' , `status` = 5 , `create_time` = '2022-02-11 00:00:00' , `update_time` = '2024-09-13 16:23:05.058662' [ RunTime:0.000211s ] [2024-09-13T16:23:05+08:00][sql] SELECT * FROM `mrp` WHERE `pp` = 1 AND `raw` = 3 LIMIT 1 [ RunTime:0.000200s ] [2024-09-13T16:23:05+08:00][sql] INSERT INTO `mrp` SET `so` = 1 , `pp` = 1 , `count` = 5 , `raw` = 3 , `need_time` = '2022-02-17 00:00:00' , `status` = 5 , `create_time` = '2022-02-11 00:00:00' , `update_time` = '2024-09-13 16:23:05.059575' [ RunTime:0.000204s ] [2024-09-13T16:23:05+08:00][sql] SELECT * FROM `mrp` WHERE `pp` = 1 AND `raw` = 4 LIMIT 1 [ RunTime:0.000200s ] [2024-09-13T16:23:05+08:00][sql] INSERT INTO `mrp` SET `so` = 1 , `pp` = 1 , `count` = 5 , `raw` = 4 , `need_time` = '2022-02-17 00:00:00' , `status` = 5 , `create_time` = '2022-02-11 00:00:00' , `update_time` = '2024-09-13 16:23:05.060425' [ RunTime:0.000186s ] [2024-09-13T16:23:05+08:00][sql] SELECT * FROM `mrp` WHERE `pp` = 1 AND `raw` = 5 LIMIT 1 [ RunTime:0.000236s ] [2024-09-13T16:23:05+08:00][sql] INSERT INTO `mrp` SET `so` = 1 , `pp` = 1 , `count` = 5 , `raw` = 5 , `need_time` = '2022-02-17 00:00:00' , `status` = 5 , `create_time` = '2022-02-11 00:00:00' , `update_time` = '2024-09-13 16:23:05.061303' [ RunTime:0.000225s ] [2024-09-13T16:23:05+08:00][sql] SELECT * FROM `mrp` WHERE `pp` = 1 AND `raw` = 6 LIMIT 1 [ RunTime:0.000246s ] [2024-09-13T16:23:05+08:00][sql] INSERT INTO `mrp` SET `so` = 1 , `pp` = 1 , `count` = 5 , `raw` = 6 , `need_time` = '2022-02-17 00:00:00' , `status` = 5 , `create_time` = '2022-02-11 00:00:00' , `update_time` = '2024-09-13 16:23:05.062197' [ RunTime:0.000191s ] [2024-09-13T16:23:05+08:00][sql] SELECT * FROM `mrp` WHERE `pp` = 1 AND `raw` = 7 LIMIT 1 [ RunTime:0.000199s ] [2024-09-13T16:23:05+08:00][sql] INSERT INTO `mrp` SET `so` = 1 , `pp` = 1 , `count` = 5 , `raw` = 7 , `need_time` = '2022-02-17 00:00:00' , `status` = 5 , `create_time` = '2022-02-11 00:00:00' , `update_time` = '2024-09-13 16:23:05.063039' [ RunTime:0.000185s ] [2024-09-13T16:23:05+08:00][sql] SELECT * FROM `mrp` WHERE `pp` = 1 AND `raw` = 8 LIMIT 1 [ RunTime:0.000193s ] [2024-09-13T16:23:05+08:00][sql] INSERT INTO `mrp` SET `so` = 1 , `pp` = 1 , `count` = 5 , `raw` = 8 , `need_time` = '2022-02-17 00:00:00' , `status` = 5 , `create_time` = '2022-02-11 00:00:00' , `update_time` = '2024-09-13 16:23:05.063861' [ RunTime:0.000189s ] [2024-09-13T16:23:05+08:00][sql] CONNECT:[ UseTime:0.003018s ] mysql:host=127.0.0.1;port=3306;dbname=bjsfjbzdhgf;charset=utf8 [2024-09-13T16:23:05+08:00][sql] SHOW FULL COLUMNS FROM `set` [ RunTime:0.000700s ] [2024-09-13T16:23:05+08:00][sql] UPDATE `set` SET `value` = 'bjsfjbzdhgf' WHERE `field` = 'database' [ RunTime:0.000279s ] [2024-09-13T16:23:05+08:00][sql] UPDATE `set` SET `value` = '北京四方继保自动化股份有限公司' WHERE `field` = 'title' [ RunTime:0.000216s ] [2024-09-13T16:23:05+08:00][sql] UPDATE `set` SET `value` = '77' WHERE `field` = 'product_sort' [ RunTime:0.000188s ] [2024-09-13T16:23:05+08:00][sql] CONNECT:[ UseTime:0.006096s ] mysql:host=127.0.0.1;port=3306;dbname=bjsfjbzdhgf;charset=utf8 [2024-09-13T16:23:05+08:00][sql] SHOW FULL COLUMNS FROM `set` [ RunTime:0.000678s ] [2024-09-13T16:23:05+08:00][sql] UPDATE `set` SET `value` = 'bjsfjbzdhgf' WHERE `field` = 'database' [ RunTime:0.000322s ] [2024-09-13T16:23:05+08:00][sql] UPDATE `set` SET `value` = '北京四方继保自动化股份有限公司' WHERE `field` = 'title' [ RunTime:0.000202s ] [2024-09-13T16:23:05+08:00][sql] UPDATE `set` SET `value` = '77' WHERE `field` = 'product_sort' [ RunTime:0.000185s ] [2024-09-13T16:23:05+08:00][sql] SHOW FULL COLUMNS FROM `mrp` [ RunTime:0.001072s ] [2024-09-13T16:23:05+08:00][sql] SELECT * FROM `mrp` WHERE `id` IN (1,2,3,4,5,6,7,8) [ RunTime:0.000340s ] [2024-09-13T16:23:05+08:00][sql] SHOW FULL COLUMNS FROM `raw` [ RunTime:0.000800s ] [2024-09-13T16:23:05+08:00][sql] SELECT * FROM `raw` WHERE `id` IN (1,2,3,4,5,6,7,8) [ RunTime:0.000341s ] [2024-09-13T16:23:05+08:00][sql] SHOW FULL COLUMNS FROM `supplier` [ RunTime:0.000557s ] [2024-09-13T16:23:05+08:00][sql] SELECT * FROM `supplier` [ RunTime:0.000270s ] [2024-09-13T16:23:05+08:00][sql] SELECT `value` FROM `set` WHERE `field` = 'po_base' LIMIT 1 [ RunTime:0.000259s ] [2024-09-13T16:23:05+08:00][sql] SELECT `value` FROM `set` WHERE `field` = 'po_base' LIMIT 1 [ RunTime:0.000205s ] [2024-09-13T16:23:05+08:00][sql] SELECT `value` FROM `set` WHERE `field` = 'po_base' LIMIT 1 [ RunTime:0.000208s ] [2024-09-13T16:23:05+08:00][sql] SELECT `value` FROM `set` WHERE `field` = 'po_base' LIMIT 1 [ RunTime:0.000226s ] [2024-09-13T16:23:05+08:00][sql] SELECT `value` FROM `set` WHERE `field` = 'po_base' LIMIT 1 [ RunTime:0.000210s ] [2024-09-13T16:23:05+08:00][sql] SELECT `value` FROM `set` WHERE `field` = 'po_base' LIMIT 1 [ RunTime:0.000180s ] [2024-09-13T16:23:05+08:00][sql] SELECT `value` FROM `set` WHERE `field` = 'po_base' LIMIT 1 [ RunTime:0.000184s ] [2024-09-13T16:23:05+08:00][sql] SELECT `value` FROM `set` WHERE `field` = 'po_base' LIMIT 1 [ RunTime:0.000178s ] [2024-09-13T16:23:05+08:00][sql] SHOW FULL COLUMNS FROM `po` [ RunTime:0.001234s ] [2024-09-13T16:23:05+08:00][sql] SELECT `number` FROM `po` [ RunTime:0.000206s ] [2024-09-13T16:23:06+08:00][sql] CONNECT:[ UseTime:0.015402s ] mysql:host=127.0.0.1;port=3306;dbname=bjsfjbzdhgf;charset=utf8 [2024-09-13T16:23:06+08:00][sql] SHOW FULL COLUMNS FROM `set` [ RunTime:0.000742s ] [2024-09-13T16:23:06+08:00][sql] UPDATE `set` SET `value` = 'bjsfjbzdhgf' WHERE `field` = 'database' [ RunTime:0.000282s ] [2024-09-13T16:23:06+08:00][sql] UPDATE `set` SET `value` = '北京四方继保自动化股份有限公司' WHERE `field` = 'title' [ RunTime:0.000251s ] [2024-09-13T16:23:06+08:00][sql] UPDATE `set` SET `value` = '77' WHERE `field` = 'product_sort' [ RunTime:0.000214s ] [2024-09-13T16:23:06+08:00][sql] SHOW FULL COLUMNS FROM `po` [ RunTime:0.000813s ] [2024-09-13T16:23:06+08:00][sql] SELECT * FROM `po` WHERE `mrp` = '1' AND `so` = '1' AND `raw` = 1 LIMIT 1 [ RunTime:0.000264s ] [2024-09-13T16:23:06+08:00][sql] SELECT MAX(`number`) AS think_max FROM `po` WHERE `number` LIKE '20220211%' LIMIT 1 [ RunTime:0.000219s ] [2024-09-13T16:23:06+08:00][sql] INSERT INTO `po` SET `number` = '20220211001' , `so` = '1' , `mrp` = '1' , `raw` = 1 , `count` = '5' , `po_count` = '5' , `create_time` = '2022-02-11 00:00:00' , `deliver_time` = '2022-02-13 00:00:00' , `supplier` = 1 , `status` = 8 , `po_unit` = '块' , `update_time` = '2024-09-13 16:23:06.635514' [ RunTime:0.000313s ] [2024-09-13T16:23:06+08:00][sql] SELECT * FROM `po` WHERE `mrp` = '2' AND `so` = '1' AND `raw` = 2 LIMIT 1 [ RunTime:0.000251s ] [2024-09-13T16:23:06+08:00][sql] SELECT MAX(`number`) AS think_max FROM `po` WHERE `number` LIKE '20220211%' LIMIT 1 [ RunTime:0.000210s ] [2024-09-13T16:23:06+08:00][sql] INSERT INTO `po` SET `number` = '20220211002' , `so` = '1' , `mrp` = '2' , `raw` = 2 , `count` = '5' , `po_count` = '5' , `create_time` = '2022-02-11 00:00:00' , `deliver_time` = '2022-02-13 00:00:00' , `supplier` = 2 , `status` = 8 , `po_unit` = '个' , `update_time` = '2024-09-13 16:23:06.636969' [ RunTime:0.000227s ] [2024-09-13T16:23:06+08:00][sql] SELECT * FROM `po` WHERE `mrp` = '3' AND `so` = '1' AND `raw` = 3 LIMIT 1 [ RunTime:0.000264s ] [2024-09-13T16:23:06+08:00][sql] SELECT MAX(`number`) AS think_max FROM `po` WHERE `number` LIKE '20220211%' LIMIT 1 [ RunTime:0.000552s ] [2024-09-13T16:23:06+08:00][sql] INSERT INTO `po` SET `number` = '20220211003' , `so` = '1' , `mrp` = '3' , `raw` = 3 , `count` = '5' , `po_count` = '5' , `create_time` = '2022-02-11 00:00:00' , `deliver_time` = '2022-02-13 00:00:00' , `supplier` = 3 , `status` = 8 , `po_unit` = '个' , `update_time` = '2024-09-13 16:23:06.638595' [ RunTime:0.000250s ] [2024-09-13T16:23:06+08:00][sql] SELECT * FROM `po` WHERE `mrp` = '4' AND `so` = '1' AND `raw` = 4 LIMIT 1 [ RunTime:0.000236s ] [2024-09-13T16:23:06+08:00][sql] SELECT MAX(`number`) AS think_max FROM `po` WHERE `number` LIKE '20220211%' LIMIT 1 [ RunTime:0.000210s ] [2024-09-13T16:23:06+08:00][sql] INSERT INTO `po` SET `number` = '20220211004' , `so` = '1' , `mrp` = '4' , `raw` = 4 , `count` = '5' , `po_count` = '5' , `create_time` = '2022-02-11 00:00:00' , `deliver_time` = '2022-02-13 00:00:00' , `supplier` = 4 , `status` = 8 , `po_unit` = '块' , `update_time` = '2024-09-13 16:23:06.639874' [ RunTime:0.000217s ] [2024-09-13T16:23:06+08:00][sql] SELECT * FROM `po` WHERE `mrp` = '5' AND `so` = '1' AND `raw` = 5 LIMIT 1 [ RunTime:0.000286s ] [2024-09-13T16:23:06+08:00][sql] SELECT MAX(`number`) AS think_max FROM `po` WHERE `number` LIKE '20220211%' LIMIT 1 [ RunTime:0.000250s ] [2024-09-13T16:23:06+08:00][sql] INSERT INTO `po` SET `number` = '20220211005' , `so` = '1' , `mrp` = '5' , `raw` = 5 , `count` = '5' , `po_count` = '5' , `create_time` = '2022-02-11 00:00:00' , `deliver_time` = '2022-02-13 00:00:00' , `supplier` = 4 , `status` = 8 , `po_unit` = '块' , `update_time` = '2024-09-13 16:23:06.641184' [ RunTime:0.000250s ] [2024-09-13T16:23:06+08:00][sql] SELECT * FROM `po` WHERE `mrp` = '6' AND `so` = '1' AND `raw` = 6 LIMIT 1 [ RunTime:0.000279s ] [2024-09-13T16:23:06+08:00][sql] SELECT MAX(`number`) AS think_max FROM `po` WHERE `number` LIKE '20220211%' LIMIT 1 [ RunTime:0.000200s ] [2024-09-13T16:23:06+08:00][sql] INSERT INTO `po` SET `number` = '20220211006' , `so` = '1' , `mrp` = '6' , `raw` = 6 , `count` = '5' , `po_count` = '5' , `create_time` = '2022-02-11 00:00:00' , `deliver_time` = '2022-02-13 00:00:00' , `supplier` = 5 , `status` = 8 , `po_unit` = '块' , `update_time` = '2024-09-13 16:23:06.642455' [ RunTime:0.000219s ] [2024-09-13T16:23:06+08:00][sql] SELECT * FROM `po` WHERE `mrp` = '7' AND `so` = '1' AND `raw` = 7 LIMIT 1 [ RunTime:0.000239s ] [2024-09-13T16:23:06+08:00][sql] SELECT MAX(`number`) AS think_max FROM `po` WHERE `number` LIKE '20220211%' LIMIT 1 [ RunTime:0.000248s ] [2024-09-13T16:23:06+08:00][sql] INSERT INTO `po` SET `number` = '20220211007' , `so` = '1' , `mrp` = '7' , `raw` = 7 , `count` = '5' , `po_count` = '5' , `create_time` = '2022-02-11 00:00:00' , `deliver_time` = '2022-02-13 00:00:00' , `supplier` = 5 , `status` = 8 , `po_unit` = '块' , `update_time` = '2024-09-13 16:23:06.643709' [ RunTime:0.000252s ] [2024-09-13T16:23:06+08:00][sql] SELECT * FROM `po` WHERE `mrp` = '8' AND `so` = '1' AND `raw` = 8 LIMIT 1 [ RunTime:0.000280s ] [2024-09-13T16:23:06+08:00][sql] SELECT MAX(`number`) AS think_max FROM `po` WHERE `number` LIKE '20220211%' LIMIT 1 [ RunTime:0.000245s ] [2024-09-13T16:23:06+08:00][sql] INSERT INTO `po` SET `number` = '20220211008' , `so` = '1' , `mrp` = '8' , `raw` = 8 , `count` = '5' , `po_count` = '5' , `create_time` = '2022-02-11 00:00:00' , `deliver_time` = '2022-02-13 00:00:00' , `supplier` = 6 , `status` = 8 , `po_unit` = '个' , `update_time` = '2024-09-13 16:23:06.645028' [ RunTime:0.000353s ] [2024-09-13T16:23:06+08:00][sql] CONNECT:[ UseTime:0.002655s ] mysql:host=127.0.0.1;port=3306;dbname=bjsfjbzdhgf;charset=utf8 [2024-09-13T16:23:06+08:00][sql] SHOW FULL COLUMNS FROM `set` [ RunTime:0.000731s ] [2024-09-13T16:23:06+08:00][sql] UPDATE `set` SET `value` = 'bjsfjbzdhgf' WHERE `field` = 'database' [ RunTime:0.000314s ] [2024-09-13T16:23:06+08:00][sql] UPDATE `set` SET `value` = '北京四方继保自动化股份有限公司' WHERE `field` = 'title' [ RunTime:0.000214s ] [2024-09-13T16:23:06+08:00][sql] UPDATE `set` SET `value` = '77' WHERE `field` = 'product_sort' [ RunTime:0.000189s ] [2024-09-13T16:23:06+08:00][sql] SHOW FULL COLUMNS FROM `po` [ RunTime:0.001097s ] [2024-09-13T16:23:06+08:00][sql] SELECT * FROM `po` WHERE `id` IN (1,2,3,4,5,6,7,8) [ RunTime:0.000368s ] [2024-09-13T16:23:06+08:00][sql] SHOW FULL COLUMNS FROM `an` [ RunTime:0.001144s ] [2024-09-13T16:23:06+08:00][sql] SELECT * FROM `an` WHERE `po` = 1 AND `raw` = 1 LIMIT 1 [ RunTime:0.000250s ] [2024-09-13T16:23:06+08:00][sql] SELECT MAX(`number`) AS think_max FROM `an` WHERE `number` LIKE '20220212%' LIMIT 1 [ RunTime:0.000189s ] [2024-09-13T16:23:06+08:00][sql] INSERT INTO `an` SET `po` = 1 , `number` = '20220212001' , `raw` = 1 , `count` = '5.00' , `supplier` = 1 , `status` = 3 , `create_time` = '2022-02-12 10:03:12' , `update_time` = '2024-09-13 16:23:06.750867' [ RunTime:0.000292s ] [2024-09-13T16:23:06+08:00][sql] SELECT * FROM `an` WHERE `po` = 2 AND `raw` = 2 LIMIT 1 [ RunTime:0.000254s ] [2024-09-13T16:23:06+08:00][sql] SELECT MAX(`number`) AS think_max FROM `an` WHERE `number` LIKE '20220212%' LIMIT 1 [ RunTime:0.000199s ] [2024-09-13T16:23:06+08:00][sql] INSERT INTO `an` SET `po` = 2 , `number` = '20220212002' , `raw` = 2 , `count` = '5.00' , `supplier` = 2 , `status` = 3 , `create_time` = '2022-02-12 06:52:01' , `update_time` = '2024-09-13 16:23:06.752237' [ RunTime:0.000214s ] [2024-09-13T16:23:06+08:00][sql] SELECT * FROM `an` WHERE `po` = 3 AND `raw` = 3 LIMIT 1 [ RunTime:0.000211s ] [2024-09-13T16:23:06+08:00][sql] SELECT MAX(`number`) AS think_max FROM `an` WHERE `number` LIKE '20220212%' LIMIT 1 [ RunTime:0.000199s ] [2024-09-13T16:23:06+08:00][sql] INSERT INTO `an` SET `po` = 3 , `number` = '20220212003' , `raw` = 3 , `count` = '5.00' , `supplier` = 3 , `status` = 3 , `create_time` = '2022-02-12 02:51:48' , `update_time` = '2024-09-13 16:23:06.753474' [ RunTime:0.000194s ] [2024-09-13T16:23:06+08:00][sql] SELECT * FROM `an` WHERE `po` = 4 AND `raw` = 4 LIMIT 1 [ RunTime:0.000199s ] [2024-09-13T16:23:06+08:00][sql] SELECT MAX(`number`) AS think_max FROM `an` WHERE `number` LIKE '20220212%' LIMIT 1 [ RunTime:0.000179s ] [2024-09-13T16:23:06+08:00][sql] INSERT INTO `an` SET `po` = 4 , `number` = '20220212004' , `raw` = 4 , `count` = '5.00' , `supplier` = 4 , `status` = 3 , `create_time` = '2022-02-12 01:38:49' , `update_time` = '2024-09-13 16:23:06.754598' [ RunTime:0.000229s ] [2024-09-13T16:23:06+08:00][sql] SELECT * FROM `an` WHERE `po` = 5 AND `raw` = 5 LIMIT 1 [ RunTime:0.000205s ] [2024-09-13T16:23:06+08:00][sql] SELECT MAX(`number`) AS think_max FROM `an` WHERE `number` LIKE '20220212%' LIMIT 1 [ RunTime:0.000182s ] [2024-09-13T16:23:06+08:00][sql] INSERT INTO `an` SET `po` = 5 , `number` = '20220212005' , `raw` = 5 , `count` = '5.00' , `supplier` = 4 , `status` = 3 , `create_time` = '2022-02-12 01:08:37' , `update_time` = '2024-09-13 16:23:06.755898' [ RunTime:0.000197s ] [2024-09-13T16:23:06+08:00][sql] SELECT * FROM `an` WHERE `po` = 6 AND `raw` = 6 LIMIT 1 [ RunTime:0.000199s ] [2024-09-13T16:23:06+08:00][sql] SELECT MAX(`number`) AS think_max FROM `an` WHERE `number` LIKE '20220212%' LIMIT 1 [ RunTime:0.000182s ] [2024-09-13T16:23:06+08:00][sql] INSERT INTO `an` SET `po` = 6 , `number` = '20220212006' , `raw` = 6 , `count` = '5.00' , `supplier` = 5 , `status` = 3 , `create_time` = '2022-02-12 08:57:59' , `update_time` = '2024-09-13 16:23:06.757088' [ RunTime:0.000237s ] [2024-09-13T16:23:06+08:00][sql] SELECT * FROM `an` WHERE `po` = 7 AND `raw` = 7 LIMIT 1 [ RunTime:0.000231s ] [2024-09-13T16:23:06+08:00][sql] SELECT MAX(`number`) AS think_max FROM `an` WHERE `number` LIKE '20220212%' LIMIT 1 [ RunTime:0.000179s ] [2024-09-13T16:23:06+08:00][sql] INSERT INTO `an` SET `po` = 7 , `number` = '20220212007' , `raw` = 7 , `count` = '5.00' , `supplier` = 5 , `status` = 3 , `create_time` = '2022-02-12 12:33:27' , `update_time` = '2024-09-13 16:23:06.758295' [ RunTime:0.000204s ] [2024-09-13T16:23:06+08:00][sql] SELECT * FROM `an` WHERE `po` = 8 AND `raw` = 8 LIMIT 1 [ RunTime:0.000204s ] [2024-09-13T16:23:06+08:00][sql] SELECT MAX(`number`) AS think_max FROM `an` WHERE `number` LIKE '20220212%' LIMIT 1 [ RunTime:0.000179s ] [2024-09-13T16:23:06+08:00][sql] INSERT INTO `an` SET `po` = 8 , `number` = '20220212008' , `raw` = 8 , `count` = '5.00' , `supplier` = 6 , `status` = 3 , `create_time` = '2022-02-12 01:42:23' , `update_time` = '2024-09-13 16:23:06.759469' [ RunTime:0.000252s ] [2024-09-13T16:23:06+08:00][sql] CONNECT:[ UseTime:0.011888s ] mysql:host=127.0.0.1;port=3306;dbname=bjsfjbzdhgf;charset=utf8 [2024-09-13T16:23:06+08:00][sql] SHOW FULL COLUMNS FROM `set` [ RunTime:0.000763s ] [2024-09-13T16:23:06+08:00][sql] UPDATE `set` SET `value` = 'bjsfjbzdhgf' WHERE `field` = 'database' [ RunTime:0.000314s ] [2024-09-13T16:23:06+08:00][sql] UPDATE `set` SET `value` = '北京四方继保自动化股份有限公司' WHERE `field` = 'title' [ RunTime:0.000243s ] [2024-09-13T16:23:06+08:00][sql] UPDATE `set` SET `value` = '77' WHERE `field` = 'product_sort' [ RunTime:0.000193s ] [2024-09-13T16:23:06+08:00][sql] SHOW FULL COLUMNS FROM `an` [ RunTime:0.001043s ] [2024-09-13T16:23:06+08:00][sql] SELECT * FROM `an` WHERE `id` IN (1,2,3,4,5,6,7,8) [ RunTime:0.000361s ] [2024-09-13T16:23:06+08:00][sql] SHOW FULL COLUMNS FROM `raw` [ RunTime:0.000601s ] [2024-09-13T16:23:06+08:00][sql] SELECT * FROM `raw` WHERE `id` IN (1,2,3,4,5,6,7,8) [ RunTime:0.000293s ] [2024-09-13T16:23:06+08:00][sql] SHOW FULL COLUMNS FROM `iqc` [ RunTime:0.001170s ] [2024-09-13T16:23:06+08:00][sql] SELECT * FROM `iqc` WHERE `an` = '1' AND `raw` = 1 LIMIT 1 [ RunTime:0.000334s ] [2024-09-13T16:23:06+08:00][sql] SELECT MAX(`number`) AS think_max FROM `iqc` WHERE `number` LIKE '20220213%' LIMIT 1 [ RunTime:0.000248s ] [2024-09-13T16:23:06+08:00][sql] INSERT INTO `iqc` SET `number` = '20220213001' , `an` = '1' , `raw` = 1 , `supplier` = 1 , `count` = '5.00' , `result` = '1' , `maker` = 0 , `ratif` = 0 , `remark` = '' , `status` = 4 , `create_time` = '2022-02-13' , `update_time` = '2024-09-13 16:23:06.879586' [ RunTime:0.000468s ] [2024-09-13T16:23:06+08:00][sql] SHOW FULL COLUMNS FROM `tpl` [ RunTime:0.000611s ] [2024-09-13T16:23:06+08:00][sql] SELECT * FROM `tpl` WHERE `status` = 1 AND `tpl_sort` = '14' AND `sort` = 393 [ RunTime:0.000256s ] [2024-09-13T16:23:06+08:00][sql] SHOW FULL COLUMNS FROM `tpl_info` [ RunTime:0.000584s ] [2024-09-13T16:23:06+08:00][sql] SELECT * FROM `tpl_info` WHERE `tpl` = 8 ORDER BY `order` ASC [ RunTime:0.000273s ] [2024-09-13T16:23:06+08:00][sql] SHOW FULL COLUMNS FROM `iqc_note` [ RunTime:0.001232s ] [2024-09-13T16:23:06+08:00][sql] SELECT * FROM `iqc_note` WHERE `iqc` = 1 AND `tpl_raw_info` = 53 LIMIT 1 [ RunTime:0.000253s ] [2024-09-13T16:23:06+08:00][sql] INSERT INTO `iqc_note` SET `iqc` = 1 , `tpl_raw_info` = 53 , `qc_count` = '2' , `count` = '2' , `note` = '1,1,' , `ng` = '0' , `create_time` = '2022-02-13' , `remark` = '' , `update_time` = '2024-09-13 16:23:06.901883' [ RunTime:0.000279s ] [2024-09-13T16:23:06+08:00][sql] SELECT * FROM `iqc_note` WHERE `iqc` = 1 AND `tpl_raw_info` = 54 LIMIT 1 [ RunTime:0.000218s ] [2024-09-13T16:23:06+08:00][sql] INSERT INTO `iqc_note` SET `iqc` = 1 , `tpl_raw_info` = 54 , `qc_count` = '2' , `count` = '2' , `note` = '1,1,' , `ng` = '0' , `create_time` = '2022-02-13' , `remark` = '' , `update_time` = '2024-09-13 16:23:06.902841' [ RunTime:0.000209s ] [2024-09-13T16:23:06+08:00][sql] SELECT * FROM `iqc_note` WHERE `iqc` = 1 AND `tpl_raw_info` = 55 LIMIT 1 [ RunTime:0.000254s ] [2024-09-13T16:23:06+08:00][sql] INSERT INTO `iqc_note` SET `iqc` = 1 , `tpl_raw_info` = 55 , `qc_count` = '2' , `count` = '2' , `note` = '1,1,' , `ng` = '0' , `create_time` = '2022-02-13' , `remark` = '' , `update_time` = '2024-09-13 16:23:06.903697' [ RunTime:0.000234s ] [2024-09-13T16:23:06+08:00][sql] SELECT * FROM `iqc` WHERE `an` = '2' AND `raw` = 2 LIMIT 1 [ RunTime:0.000255s ] [2024-09-13T16:23:06+08:00][sql] SELECT MAX(`number`) AS think_max FROM `iqc` WHERE `number` LIKE '20220213%' LIMIT 1 [ RunTime:0.000201s ] [2024-09-13T16:23:06+08:00][sql] INSERT INTO `iqc` SET `number` = '20220213002' , `an` = '2' , `raw` = 2 , `supplier` = 2 , `count` = '5.00' , `result` = '1' , `maker` = 0 , `ratif` = 0 , `remark` = '' , `status` = 4 , `create_time` = '2022-02-13' , `update_time` = '2024-09-13 16:23:06.904912' [ RunTime:0.000573s ] [2024-09-13T16:23:06+08:00][sql] SELECT * FROM `tpl` WHERE `status` = 1 AND `tpl_sort` = '14' AND `sort` = 376 [ RunTime:0.000285s ] [2024-09-13T16:23:06+08:00][sql] SELECT * FROM `tpl_info` WHERE `tpl` = 7 ORDER BY `order` ASC [ RunTime:0.000316s ] [2024-09-13T16:23:06+08:00][sql] SELECT * FROM `iqc_note` WHERE `iqc` = 2 AND `tpl_raw_info` = 49 LIMIT 1 [ RunTime:0.000219s ] [2024-09-13T16:23:06+08:00][sql] INSERT INTO `iqc_note` SET `iqc` = 2 , `tpl_raw_info` = 49 , `qc_count` = '2' , `count` = '2' , `note` = '1,1,' , `ng` = '0' , `create_time` = '2022-02-13' , `remark` = '' , `update_time` = '2024-09-13 16:23:06.907304' [ RunTime:0.000200s ] [2024-09-13T16:23:06+08:00][sql] SELECT * FROM `iqc_note` WHERE `iqc` = 2 AND `tpl_raw_info` = 50 LIMIT 1 [ RunTime:0.000209s ] [2024-09-13T16:23:06+08:00][sql] INSERT INTO `iqc_note` SET `iqc` = 2 , `tpl_raw_info` = 50 , `qc_count` = '2' , `count` = '2' , `note` = '1,1,' , `ng` = '0' , `create_time` = '2022-02-13' , `remark` = '' , `update_time` = '2024-09-13 16:23:06.908144' [ RunTime:0.000238s ] [2024-09-13T16:23:06+08:00][sql] SELECT * FROM `iqc_note` WHERE `iqc` = 2 AND `tpl_raw_info` = 51 LIMIT 1 [ RunTime:0.000254s ] [2024-09-13T16:23:06+08:00][sql] INSERT INTO `iqc_note` SET `iqc` = 2 , `tpl_raw_info` = 51 , `qc_count` = '2' , `count` = '2' , `note` = '1,1,' , `ng` = '0' , `create_time` = '2022-02-13' , `remark` = '' , `update_time` = '2024-09-13 16:23:06.909019' [ RunTime:0.000236s ] [2024-09-13T16:23:06+08:00][sql] SELECT * FROM `iqc_note` WHERE `iqc` = 2 AND `tpl_raw_info` = 52 LIMIT 1 [ RunTime:0.000199s ] [2024-09-13T16:23:06+08:00][sql] INSERT INTO `iqc_note` SET `iqc` = 2 , `tpl_raw_info` = 52 , `qc_count` = '2' , `count` = '2' , `note` = '1,1,' , `ng` = '0' , `create_time` = '2022-02-13' , `remark` = '' , `update_time` = '2024-09-13 16:23:06.909844' [ RunTime:0.000193s ] [2024-09-13T16:23:06+08:00][sql] SELECT * FROM `iqc` WHERE `an` = '3' AND `raw` = 3 LIMIT 1 [ RunTime:0.000720s ] [2024-09-13T16:23:06+08:00][sql] SELECT MAX(`number`) AS think_max FROM `iqc` WHERE `number` LIKE '20220213%' LIMIT 1 [ RunTime:0.000263s ] [2024-09-13T16:23:06+08:00][sql] INSERT INTO `iqc` SET `number` = '20220213003' , `an` = '3' , `raw` = 3 , `supplier` = 3 , `count` = '5.00' , `result` = '1' , `maker` = 0 , `ratif` = 0 , `remark` = '' , `status` = 4 , `create_time` = '2022-02-13' , `update_time` = '2024-09-13 16:23:06.911572' [ RunTime:0.000283s ] [2024-09-13T16:23:06+08:00][sql] SELECT * FROM `tpl` WHERE `status` = 1 AND `tpl_sort` = '14' AND `sort` = 411 [ RunTime:0.000250s ] [2024-09-13T16:23:06+08:00][sql] SELECT * FROM `tpl_info` WHERE `tpl` = 9 ORDER BY `order` ASC [ RunTime:0.000323s ] [2024-09-13T16:23:06+08:00][sql] SELECT * FROM `iqc_note` WHERE `iqc` = 3 AND `tpl_raw_info` = 56 LIMIT 1 [ RunTime:0.000223s ] [2024-09-13T16:23:06+08:00][sql] INSERT INTO `iqc_note` SET `iqc` = 3 , `tpl_raw_info` = 56 , `qc_count` = '2' , `count` = '2' , `note` = '1,1,' , `ng` = '0' , `create_time` = '2022-02-13' , `remark` = '' , `update_time` = '2024-09-13 16:23:06.913704' [ RunTime:0.000206s ] [2024-09-13T16:23:06+08:00][sql] SELECT * FROM `iqc_note` WHERE `iqc` = 3 AND `tpl_raw_info` = 57 LIMIT 1 [ RunTime:0.000211s ] [2024-09-13T16:23:06+08:00][sql] INSERT INTO `iqc_note` SET `iqc` = 3 , `tpl_raw_info` = 57 , `qc_count` = '2' , `count` = '2' , `note` = '1,1,' , `ng` = '0' , `create_time` = '2022-02-13' , `remark` = '' , `update_time` = '2024-09-13 16:23:06.914637' [ RunTime:0.000213s ] [2024-09-13T16:23:06+08:00][sql] SELECT * FROM `iqc_note` WHERE `iqc` = 3 AND `tpl_raw_info` = 58 LIMIT 1 [ RunTime:0.000201s ] [2024-09-13T16:23:06+08:00][sql] INSERT INTO `iqc_note` SET `iqc` = 3 , `tpl_raw_info` = 58 , `qc_count` = '2' , `count` = '2' , `note` = '1,1,' , `ng` = '0' , `create_time` = '2022-02-13' , `remark` = '' , `update_time` = '2024-09-13 16:23:06.915539' [ RunTime:0.000216s ] [2024-09-13T16:23:06+08:00][sql] SELECT * FROM `iqc_note` WHERE `iqc` = 3 AND `tpl_raw_info` = 59 LIMIT 1 [ RunTime:0.000255s ] [2024-09-13T16:23:06+08:00][sql] INSERT INTO `iqc_note` SET `iqc` = 3 , `tpl_raw_info` = 59 , `qc_count` = '2' , `count` = '2' , `note` = '1,1,' , `ng` = '0' , `create_time` = '2022-02-13' , `remark` = '' , `update_time` = '2024-09-13 16:23:06.916416' [ RunTime:0.000189s ] [2024-09-13T16:23:06+08:00][sql] SELECT * FROM `iqc` WHERE `an` = '4' AND `raw` = 4 LIMIT 1 [ RunTime:0.000248s ] [2024-09-13T16:23:06+08:00][sql] SELECT MAX(`number`) AS think_max FROM `iqc` WHERE `number` LIKE '20220213%' LIMIT 1 [ RunTime:0.000201s ] [2024-09-13T16:23:06+08:00][sql] INSERT INTO `iqc` SET `number` = '20220213004' , `an` = '4' , `raw` = 4 , `supplier` = 4 , `count` = '5.00' , `result` = '1' , `maker` = 0 , `ratif` = 0 , `remark` = '' , `status` = 4 , `create_time` = '2022-02-13' , `update_time` = '2024-09-13 16:23:06.917593' [ RunTime:0.000221s ] [2024-09-13T16:23:06+08:00][sql] SELECT * FROM `tpl` WHERE `status` = 1 AND `tpl_sort` = '14' AND `sort` = 1028 [ RunTime:0.000219s ] [2024-09-13T16:23:06+08:00][sql] SELECT * FROM `tpl_info` WHERE `tpl` = 10 ORDER BY `order` ASC [ RunTime:0.000262s ] [2024-09-13T16:23:06+08:00][sql] SELECT * FROM `iqc_note` WHERE `iqc` = 4 AND `tpl_raw_info` = 60 LIMIT 1 [ RunTime:0.000222s ] [2024-09-13T16:23:06+08:00][sql] INSERT INTO `iqc_note` SET `iqc` = 4 , `tpl_raw_info` = 60 , `qc_count` = '2' , `count` = '2' , `note` = '1,1,' , `ng` = '0' , `create_time` = '2022-02-13' , `remark` = '' , `update_time` = '2024-09-13 16:23:06.919693' [ RunTime:0.000202s ] [2024-09-13T16:23:06+08:00][sql] SELECT * FROM `iqc_note` WHERE `iqc` = 4 AND `tpl_raw_info` = 61 LIMIT 1 [ RunTime:0.000205s ] [2024-09-13T16:23:06+08:00][sql] INSERT INTO `iqc_note` SET `iqc` = 4 , `tpl_raw_info` = 61 , `qc_count` = '2' , `count` = '2' , `note` = '1,1,' , `ng` = '0' , `create_time` = '2022-02-13' , `remark` = '' , `update_time` = '2024-09-13 16:23:06.920622' [ RunTime:0.000199s ] [2024-09-13T16:23:06+08:00][sql] SELECT * FROM `iqc_note` WHERE `iqc` = 4 AND `tpl_raw_info` = 62 LIMIT 1 [ RunTime:0.000201s ] [2024-09-13T16:23:06+08:00][sql] INSERT INTO `iqc_note` SET `iqc` = 4 , `tpl_raw_info` = 62 , `qc_count` = '2' , `count` = '2' , `note` = '1,1,' , `ng` = '0' , `create_time` = '2022-02-13' , `remark` = '' , `update_time` = '2024-09-13 16:23:06.921469' [ RunTime:0.000821s ] [2024-09-13T16:23:06+08:00][sql] SELECT * FROM `iqc_note` WHERE `iqc` = 4 AND `tpl_raw_info` = 63 LIMIT 1 [ RunTime:0.000238s ] [2024-09-13T16:23:06+08:00][sql] INSERT INTO `iqc_note` SET `iqc` = 4 , `tpl_raw_info` = 63 , `qc_count` = '2' , `count` = '2' , `note` = '1,1,' , `ng` = '0' , `create_time` = '2022-02-13' , `remark` = '' , `update_time` = '2024-09-13 16:23:06.923035' [ RunTime:0.000181s ] [2024-09-13T16:23:06+08:00][sql] SELECT * FROM `iqc` WHERE `an` = '5' AND `raw` = 5 LIMIT 1 [ RunTime:0.000215s ] [2024-09-13T16:23:06+08:00][sql] SELECT MAX(`number`) AS think_max FROM `iqc` WHERE `number` LIKE '20220213%' LIMIT 1 [ RunTime:0.000247s ] [2024-09-13T16:23:06+08:00][sql] INSERT INTO `iqc` SET `number` = '20220213005' , `an` = '5' , `raw` = 5 , `supplier` = 4 , `count` = '5.00' , `result` = '1' , `maker` = 0 , `ratif` = 0 , `remark` = '' , `status` = 4 , `create_time` = '2022-02-13' , `update_time` = '2024-09-13 16:23:06.924209' [ RunTime:0.000256s ] [2024-09-13T16:23:06+08:00][sql] SELECT * FROM `tpl` WHERE `status` = 1 AND `tpl_sort` = '14' AND `sort` = 1029 [ RunTime:0.000270s ] [2024-09-13T16:23:06+08:00][sql] SELECT * FROM `tpl_info` WHERE `tpl` = 11 ORDER BY `order` ASC [ RunTime:0.000288s ] [2024-09-13T16:23:06+08:00][sql] SELECT * FROM `iqc_note` WHERE `iqc` = 5 AND `tpl_raw_info` = 64 LIMIT 1 [ RunTime:0.000265s ] [2024-09-13T16:23:06+08:00][sql] INSERT INTO `iqc_note` SET `iqc` = 5 , `tpl_raw_info` = 64 , `qc_count` = '2' , `count` = '2' , `note` = '1,1,' , `ng` = '0' , `create_time` = '2022-02-13' , `remark` = '' , `update_time` = '2024-09-13 16:23:06.926227' [ RunTime:0.000294s ] [2024-09-13T16:23:06+08:00][sql] SELECT * FROM `iqc_note` WHERE `iqc` = 5 AND `tpl_raw_info` = 65 LIMIT 1 [ RunTime:0.000257s ] [2024-09-13T16:23:06+08:00][sql] INSERT INTO `iqc_note` SET `iqc` = 5 , `tpl_raw_info` = 65 , `qc_count` = '2' , `count` = '2' , `note` = '1,1,' , `ng` = '0' , `create_time` = '2022-02-13' , `remark` = '' , `update_time` = '2024-09-13 16:23:06.927193' [ RunTime:0.000214s ] [2024-09-13T16:23:06+08:00][sql] SELECT * FROM `iqc_note` WHERE `iqc` = 5 AND `tpl_raw_info` = 66 LIMIT 1 [ RunTime:0.000213s ] [2024-09-13T16:23:06+08:00][sql] INSERT INTO `iqc_note` SET `iqc` = 5 , `tpl_raw_info` = 66 , `qc_count` = '2' , `count` = '2' , `note` = '1,1,' , `ng` = '0' , `create_time` = '2022-02-13' , `remark` = '' , `update_time` = '2024-09-13 16:23:06.928006' [ RunTime:0.000175s ] [2024-09-13T16:23:06+08:00][sql] SELECT * FROM `iqc_note` WHERE `iqc` = 5 AND `tpl_raw_info` = 67 LIMIT 1 [ RunTime:0.000206s ] [2024-09-13T16:23:06+08:00][sql] INSERT INTO `iqc_note` SET `iqc` = 5 , `tpl_raw_info` = 67 , `qc_count` = '2' , `count` = '2' , `note` = '1,1,' , `ng` = '0' , `create_time` = '2022-02-13' , `remark` = '' , `update_time` = '2024-09-13 16:23:06.928768' [ RunTime:0.000217s ] [2024-09-13T16:23:06+08:00][sql] SELECT * FROM `iqc` WHERE `an` = '6' AND `raw` = 6 LIMIT 1 [ RunTime:0.000247s ] [2024-09-13T16:23:06+08:00][sql] SELECT MAX(`number`) AS think_max FROM `iqc` WHERE `number` LIKE '20220213%' LIMIT 1 [ RunTime:0.000200s ] [2024-09-13T16:23:06+08:00][sql] INSERT INTO `iqc` SET `number` = '20220213006' , `an` = '6' , `raw` = 6 , `supplier` = 5 , `count` = '5.00' , `result` = '1' , `maker` = 0 , `ratif` = 0 , `remark` = '' , `status` = 4 , `create_time` = '2022-02-13' , `update_time` = '2024-09-13 16:23:06.929937' [ RunTime:0.000214s ] [2024-09-13T16:23:06+08:00][sql] SELECT * FROM `tpl` WHERE `status` = 1 AND `tpl_sort` = '14' AND `sort` = 1030 [ RunTime:0.000219s ] [2024-09-13T16:23:06+08:00][sql] SELECT * FROM `tpl_info` WHERE `tpl` = 12 ORDER BY `order` ASC [ RunTime:0.000286s ] [2024-09-13T16:23:06+08:00][sql] SELECT * FROM `iqc_note` WHERE `iqc` = 6 AND `tpl_raw_info` = 68 LIMIT 1 [ RunTime:0.000214s ] [2024-09-13T16:23:06+08:00][sql] INSERT INTO `iqc_note` SET `iqc` = 6 , `tpl_raw_info` = 68 , `qc_count` = '2' , `count` = '2' , `note` = '1,1,' , `ng` = '0' , `create_time` = '2022-02-13' , `remark` = '' , `update_time` = '2024-09-13 16:23:06.931791' [ RunTime:0.000180s ] [2024-09-13T16:23:06+08:00][sql] SELECT * FROM `iqc_note` WHERE `iqc` = 6 AND `tpl_raw_info` = 69 LIMIT 1 [ RunTime:0.000245s ] [2024-09-13T16:23:06+08:00][sql] INSERT INTO `iqc_note` SET `iqc` = 6 , `tpl_raw_info` = 69 , `qc_count` = '2' , `count` = '2' , `note` = '1,1,' , `ng` = '0' , `create_time` = '2022-02-13' , `remark` = '' , `update_time` = '2024-09-13 16:23:06.932622' [ RunTime:0.000224s ] [2024-09-13T16:23:06+08:00][sql] SELECT * FROM `iqc_note` WHERE `iqc` = 6 AND `tpl_raw_info` = 70 LIMIT 1 [ RunTime:0.000239s ] [2024-09-13T16:23:06+08:00][sql] INSERT INTO `iqc_note` SET `iqc` = 6 , `tpl_raw_info` = 70 , `qc_count` = '2' , `count` = '2' , `note` = '1,1,' , `ng` = '0' , `create_time` = '2022-02-13' , `remark` = '' , `update_time` = '2024-09-13 16:23:06.933468' [ RunTime:0.000173s ] [2024-09-13T16:23:06+08:00][sql] SELECT * FROM `iqc_note` WHERE `iqc` = 6 AND `tpl_raw_info` = 71 LIMIT 1 [ RunTime:0.000202s ] [2024-09-13T16:23:06+08:00][sql] INSERT INTO `iqc_note` SET `iqc` = 6 , `tpl_raw_info` = 71 , `qc_count` = '2' , `count` = '2' , `note` = '1,1,' , `ng` = '0' , `create_time` = '2022-02-13' , `remark` = '' , `update_time` = '2024-09-13 16:23:06.934278' [ RunTime:0.000174s ] [2024-09-13T16:23:06+08:00][sql] SELECT * FROM `iqc` WHERE `an` = '7' AND `raw` = 7 LIMIT 1 [ RunTime:0.000214s ] [2024-09-13T16:23:06+08:00][sql] SELECT MAX(`number`) AS think_max FROM `iqc` WHERE `number` LIKE '20220213%' LIMIT 1 [ RunTime:0.000231s ] [2024-09-13T16:23:06+08:00][sql] INSERT INTO `iqc` SET `number` = '20220213007' , `an` = '7' , `raw` = 7 , `supplier` = 5 , `count` = '5.00' , `result` = '1' , `maker` = 0 , `ratif` = 0 , `remark` = '' , `status` = 4 , `create_time` = '2022-02-13' , `update_time` = '2024-09-13 16:23:06.935463' [ RunTime:0.000270s ] [2024-09-13T16:23:06+08:00][sql] SELECT * FROM `tpl` WHERE `status` = 1 AND `tpl_sort` = '14' AND `sort` = 1031 [ RunTime:0.000218s ] [2024-09-13T16:23:06+08:00][sql] SELECT * FROM `tpl_info` WHERE `tpl` = 13 ORDER BY `order` ASC [ RunTime:0.000251s ] [2024-09-13T16:23:06+08:00][sql] SELECT * FROM `iqc_note` WHERE `iqc` = 7 AND `tpl_raw_info` = 75 LIMIT 1 [ RunTime:0.000262s ] [2024-09-13T16:23:06+08:00][sql] INSERT INTO `iqc_note` SET `iqc` = 7 , `tpl_raw_info` = 75 , `qc_count` = '2' , `count` = '2' , `note` = '1,1,' , `ng` = '0' , `create_time` = '2022-02-13' , `remark` = '' , `update_time` = '2024-09-13 16:23:06.937389' [ RunTime:0.000175s ] [2024-09-13T16:23:06+08:00][sql] SELECT * FROM `iqc_note` WHERE `iqc` = 7 AND `tpl_raw_info` = 74 LIMIT 1 [ RunTime:0.000207s ] [2024-09-13T16:23:06+08:00][sql] INSERT INTO `iqc_note` SET `iqc` = 7 , `tpl_raw_info` = 74 , `qc_count` = '2' , `count` = '2' , `note` = '1,1,' , `ng` = '0' , `create_time` = '2022-02-13' , `remark` = '' , `update_time` = '2024-09-13 16:23:06.938189' [ RunTime:0.000185s ] [2024-09-13T16:23:06+08:00][sql] SELECT * FROM `iqc_note` WHERE `iqc` = 7 AND `tpl_raw_info` = 73 LIMIT 1 [ RunTime:0.000239s ] [2024-09-13T16:23:06+08:00][sql] INSERT INTO `iqc_note` SET `iqc` = 7 , `tpl_raw_info` = 73 , `qc_count` = '2' , `count` = '2' , `note` = '1,1,' , `ng` = '0' , `create_time` = '2022-02-13' , `remark` = '' , `update_time` = '2024-09-13 16:23:06.939027' [ RunTime:0.000225s ] [2024-09-13T16:23:06+08:00][sql] SELECT * FROM `iqc_note` WHERE `iqc` = 7 AND `tpl_raw_info` = 72 LIMIT 1 [ RunTime:0.000247s ] [2024-09-13T16:23:06+08:00][sql] INSERT INTO `iqc_note` SET `iqc` = 7 , `tpl_raw_info` = 72 , `qc_count` = '2' , `count` = '2' , `note` = '1,1,' , `ng` = '0' , `create_time` = '2022-02-13' , `remark` = '' , `update_time` = '2024-09-13 16:23:06.939890' [ RunTime:0.000211s ] [2024-09-13T16:23:06+08:00][sql] SELECT * FROM `iqc` WHERE `an` = '8' AND `raw` = 8 LIMIT 1 [ RunTime:0.000207s ] [2024-09-13T16:23:06+08:00][sql] SELECT MAX(`number`) AS think_max FROM `iqc` WHERE `number` LIKE '20220213%' LIMIT 1 [ RunTime:0.000219s ] [2024-09-13T16:23:06+08:00][sql] INSERT INTO `iqc` SET `number` = '20220213008' , `an` = '8' , `raw` = 8 , `supplier` = 6 , `count` = '5.00' , `result` = '1' , `maker` = 0 , `ratif` = 0 , `remark` = '' , `status` = 4 , `create_time` = '2022-02-13' , `update_time` = '2024-09-13 16:23:06.941028' [ RunTime:0.000687s ] [2024-09-13T16:23:06+08:00][sql] SELECT * FROM `tpl` WHERE `status` = 1 AND `tpl_sort` = '14' AND `sort` = 169 [ RunTime:0.000380s ] [2024-09-13T16:23:06+08:00][sql] SELECT * FROM `tpl_info` WHERE `tpl` = 6 ORDER BY `order` ASC [ RunTime:0.000321s ] [2024-09-13T16:23:06+08:00][sql] SELECT * FROM `iqc_note` WHERE `iqc` = 8 AND `tpl_raw_info` = 45 LIMIT 1 [ RunTime:0.000232s ] [2024-09-13T16:23:06+08:00][sql] INSERT INTO `iqc_note` SET `iqc` = 8 , `tpl_raw_info` = 45 , `qc_count` = '2' , `count` = '2' , `note` = '1,1,' , `ng` = '0' , `create_time` = '2022-02-13' , `remark` = '' , `update_time` = '2024-09-13 16:23:06.943591' [ RunTime:0.000196s ] [2024-09-13T16:23:06+08:00][sql] SELECT * FROM `iqc_note` WHERE `iqc` = 8 AND `tpl_raw_info` = 46 LIMIT 1 [ RunTime:0.000216s ] [2024-09-13T16:23:06+08:00][sql] INSERT INTO `iqc_note` SET `iqc` = 8 , `tpl_raw_info` = 46 , `qc_count` = '2' , `count` = '2' , `note` = '1,1,' , `ng` = '0' , `create_time` = '2022-02-13' , `remark` = '' , `update_time` = '2024-09-13 16:23:06.944437' [ RunTime:0.000218s ] [2024-09-13T16:23:06+08:00][sql] SELECT * FROM `iqc_note` WHERE `iqc` = 8 AND `tpl_raw_info` = 47 LIMIT 1 [ RunTime:0.000246s ] [2024-09-13T16:23:06+08:00][sql] INSERT INTO `iqc_note` SET `iqc` = 8 , `tpl_raw_info` = 47 , `qc_count` = '2' , `count` = '2' , `note` = '1,1,' , `ng` = '0' , `create_time` = '2022-02-13' , `remark` = '' , `update_time` = '2024-09-13 16:23:06.945297' [ RunTime:0.000173s ] [2024-09-13T16:23:06+08:00][sql] SELECT * FROM `iqc_note` WHERE `iqc` = 8 AND `tpl_raw_info` = 48 LIMIT 1 [ RunTime:0.000218s ] [2024-09-13T16:23:06+08:00][sql] INSERT INTO `iqc_note` SET `iqc` = 8 , `tpl_raw_info` = 48 , `qc_count` = '2' , `count` = '2' , `note` = '1,1,' , `ng` = '0' , `create_time` = '2022-02-13' , `remark` = '' , `update_time` = '2024-09-13 16:23:06.946072' [ RunTime:0.000177s ] [2024-09-13T16:23:07+08:00][sql] CONNECT:[ UseTime:0.013630s ] mysql:host=127.0.0.1;port=3306;dbname=bjsfjbzdhgf;charset=utf8 [2024-09-13T16:23:07+08:00][sql] SHOW FULL COLUMNS FROM `set` [ RunTime:0.000719s ] [2024-09-13T16:23:07+08:00][sql] UPDATE `set` SET `value` = 'bjsfjbzdhgf' WHERE `field` = 'database' [ RunTime:0.000272s ] [2024-09-13T16:23:07+08:00][sql] UPDATE `set` SET `value` = '北京四方继保自动化股份有限公司' WHERE `field` = 'title' [ RunTime:0.000220s ] [2024-09-13T16:23:07+08:00][sql] UPDATE `set` SET `value` = '77' WHERE `field` = 'product_sort' [ RunTime:0.000206s ] [2024-09-13T16:23:07+08:00][sql] SHOW FULL COLUMNS FROM `an` [ RunTime:0.000982s ] [2024-09-13T16:23:07+08:00][sql] SELECT * FROM `an` WHERE `id` IN (1,2,3,4,5,6,7,8) [ RunTime:0.000377s ] [2024-09-13T16:23:07+08:00][sql] SHOW FULL COLUMNS FROM `iqc` [ RunTime:0.000940s ] [2024-09-13T16:23:07+08:00][sql] SELECT * FROM `iqc` WHERE `an` IN ('1','2','3','4','5','6','7','8') [ RunTime:0.000382s ] [2024-09-13T16:23:07+08:00][sql] SHOW FULL COLUMNS FROM `in` [ RunTime:0.001392s ] [2024-09-13T16:23:07+08:00][sql] SELECT * FROM `in` WHERE `raw` = 1 AND `an` = 1 LIMIT 1 [ RunTime:0.000330s ] [2024-09-13T16:23:07+08:00][sql] SELECT MAX(`number`) AS think_max FROM `in` WHERE `number` LIKE '20220212%' LIMIT 1 [ RunTime:0.000210s ] [2024-09-13T16:23:07+08:00][sql] INSERT INTO `in` SET `number` = '20220212001' , `raw` = 1 , `count` = 5.00 , `supplier` = 1 , `an` = 1 , `po` = 1 , `iqc` = 1 , `create_time` = '2022-02-12 10:03:12' , `update_time` = '2024-09-13 16:23:07.100813' [ RunTime:0.000286s ] [2024-09-13T16:23:07+08:00][sql] SELECT * FROM `in` WHERE `raw` = 2 AND `an` = 2 LIMIT 1 [ RunTime:0.000265s ] [2024-09-13T16:23:07+08:00][sql] SELECT MAX(`number`) AS think_max FROM `in` WHERE `number` LIKE '20220212%' LIMIT 1 [ RunTime:0.000231s ] [2024-09-13T16:23:07+08:00][sql] INSERT INTO `in` SET `number` = '20220212002' , `raw` = 2 , `count` = 5.00 , `supplier` = 2 , `an` = 2 , `po` = 2 , `iqc` = 2 , `create_time` = '2022-02-12 06:52:01' , `update_time` = '2024-09-13 16:23:07.102232' [ RunTime:0.000205s ] [2024-09-13T16:23:07+08:00][sql] SELECT * FROM `in` WHERE `raw` = 3 AND `an` = 3 LIMIT 1 [ RunTime:0.000228s ] [2024-09-13T16:23:07+08:00][sql] SELECT MAX(`number`) AS think_max FROM `in` WHERE `number` LIKE '20220212%' LIMIT 1 [ RunTime:0.000199s ] [2024-09-13T16:23:07+08:00][sql] INSERT INTO `in` SET `number` = '20220212003' , `raw` = 3 , `count` = 5.00 , `supplier` = 3 , `an` = 3 , `po` = 3 , `iqc` = 3 , `create_time` = '2022-02-12 02:51:48' , `update_time` = '2024-09-13 16:23:07.103447' [ RunTime:0.000216s ] [2024-09-13T16:23:07+08:00][sql] SELECT * FROM `in` WHERE `raw` = 4 AND `an` = 4 LIMIT 1 [ RunTime:0.000222s ] [2024-09-13T16:23:07+08:00][sql] SELECT MAX(`number`) AS think_max FROM `in` WHERE `number` LIKE '20220212%' LIMIT 1 [ RunTime:0.000219s ] [2024-09-13T16:23:07+08:00][sql] INSERT INTO `in` SET `number` = '20220212004' , `raw` = 4 , `count` = 5.00 , `supplier` = 4 , `an` = 4 , `po` = 4 , `iqc` = 4 , `create_time` = '2022-02-12 01:38:49' , `update_time` = '2024-09-13 16:23:07.104649' [ RunTime:0.000205s ] [2024-09-13T16:23:07+08:00][sql] SELECT * FROM `in` WHERE `raw` = 5 AND `an` = 5 LIMIT 1 [ RunTime:0.000211s ] [2024-09-13T16:23:07+08:00][sql] SELECT MAX(`number`) AS think_max FROM `in` WHERE `number` LIKE '20220212%' LIMIT 1 [ RunTime:0.000199s ] [2024-09-13T16:23:07+08:00][sql] INSERT INTO `in` SET `number` = '20220212005' , `raw` = 5 , `count` = 5.00 , `supplier` = 4 , `an` = 5 , `po` = 5 , `iqc` = 5 , `create_time` = '2022-02-12 01:08:37' , `update_time` = '2024-09-13 16:23:07.105855' [ RunTime:0.000234s ] [2024-09-13T16:23:07+08:00][sql] SELECT * FROM `in` WHERE `raw` = 6 AND `an` = 6 LIMIT 1 [ RunTime:0.000259s ] [2024-09-13T16:23:07+08:00][sql] SELECT MAX(`number`) AS think_max FROM `in` WHERE `number` LIKE '20220212%' LIMIT 1 [ RunTime:0.000244s ] [2024-09-13T16:23:07+08:00][sql] INSERT INTO `in` SET `number` = '20220212006' , `raw` = 6 , `count` = 5.00 , `supplier` = 5 , `an` = 6 , `po` = 6 , `iqc` = 6 , `create_time` = '2022-02-12 08:57:59' , `update_time` = '2024-09-13 16:23:07.107108' [ RunTime:0.000199s ] [2024-09-13T16:23:07+08:00][sql] SELECT * FROM `in` WHERE `raw` = 7 AND `an` = 7 LIMIT 1 [ RunTime:0.000224s ] [2024-09-13T16:23:07+08:00][sql] SELECT MAX(`number`) AS think_max FROM `in` WHERE `number` LIKE '20220212%' LIMIT 1 [ RunTime:0.000200s ] [2024-09-13T16:23:07+08:00][sql] INSERT INTO `in` SET `number` = '20220212007' , `raw` = 7 , `count` = 5.00 , `supplier` = 5 , `an` = 7 , `po` = 7 , `iqc` = 7 , `create_time` = '2022-02-12 12:33:27' , `update_time` = '2024-09-13 16:23:07.108308' [ RunTime:0.000237s ] [2024-09-13T16:23:07+08:00][sql] SELECT * FROM `in` WHERE `raw` = 8 AND `an` = 8 LIMIT 1 [ RunTime:0.000233s ] [2024-09-13T16:23:07+08:00][sql] SELECT MAX(`number`) AS think_max FROM `in` WHERE `number` LIKE '20220212%' LIMIT 1 [ RunTime:0.000196s ] [2024-09-13T16:23:07+08:00][sql] INSERT INTO `in` SET `number` = '20220212008' , `raw` = 8 , `count` = 5.00 , `supplier` = 6 , `an` = 8 , `po` = 8 , `iqc` = 8 , `create_time` = '2022-02-12 01:42:23' , `update_time` = '2024-09-13 16:23:07.109534' [ RunTime:0.000208s ] [2024-09-13T16:23:07+08:00][sql] CONNECT:[ UseTime:0.007381s ] mysql:host=127.0.0.1;port=3306;dbname=bjsfjbzdhgf;charset=utf8 [2024-09-13T16:23:07+08:00][sql] SHOW FULL COLUMNS FROM `set` [ RunTime:0.000810s ] [2024-09-13T16:23:07+08:00][sql] UPDATE `set` SET `value` = 'bjsfjbzdhgf' WHERE `field` = 'database' [ RunTime:0.000320s ] [2024-09-13T16:23:07+08:00][sql] UPDATE `set` SET `value` = '北京四方继保自动化股份有限公司' WHERE `field` = 'title' [ RunTime:0.000251s ] [2024-09-13T16:23:07+08:00][sql] UPDATE `set` SET `value` = '77' WHERE `field` = 'product_sort' [ RunTime:0.000188s ] [2024-09-13T16:23:07+08:00][sql] SHOW FULL COLUMNS FROM `pp` [ RunTime:0.001091s ] [2024-09-13T16:23:07+08:00][sql] SELECT * FROM `pp` WHERE `id` = 1 [ RunTime:0.000265s ] [2024-09-13T16:23:07+08:00][sql] SHOW FULL COLUMNS FROM `in` [ RunTime:0.001009s ] [2024-09-13T16:23:07+08:00][sql] SELECT MIN(`create_time`) AS think_min FROM `in` WHERE `id` = in LIMIT 1 [ RunTime:0.000264s ] [2024-09-13T16:23:07+08:00][sql] SHOW FULL COLUMNS FROM `mo` [ RunTime:0.001364s ] [2024-09-13T16:23:07+08:00][sql] SELECT * FROM `mo` WHERE `product` = 1 AND `pp` = '1' LIMIT 1 [ RunTime:0.000333s ] [2024-09-13T16:23:07+08:00][sql] SELECT MAX(`number`) AS think_max FROM `mo` WHERE `number` LIKE '20220211%' LIMIT 1 [ RunTime:0.000223s ] [2024-09-13T16:23:07+08:00][sql] INSERT INTO `mo` SET `number` = '20220211001' , `status` = 11 , `product` = 1 , `count` = 5 , `plan_count` = 5 , `maker` = 0 , `ratif` = 0 , `pmr_step` = 0 , `cpp_step` = 0 , `mo_step` = 0 , `remark` = '' , `create_time` = '2022-02-11 00:00:00' , `so` = '1' , `pp` = '1' , `cpp_status` = 2 , `pqc_status` = 2 , `fqc_status` = 2 , `oqc_status` = 2 , `end_count` = 5 , `update_time` = '2024-09-13 16:23:07.222574' [ RunTime:0.000315s ] [2024-09-13T16:23:07+08:00][sql] CONNECT:[ UseTime:0.008645s ] mysql:host=127.0.0.1;port=3306;dbname=bjsfjbzdhgf;charset=utf8 [2024-09-13T16:23:07+08:00][sql] SHOW FULL COLUMNS FROM `set` [ RunTime:0.000723s ] [2024-09-13T16:23:07+08:00][sql] UPDATE `set` SET `value` = 'bjsfjbzdhgf' WHERE `field` = 'database' [ RunTime:0.000338s ] [2024-09-13T16:23:07+08:00][sql] UPDATE `set` SET `value` = '北京四方继保自动化股份有限公司' WHERE `field` = 'title' [ RunTime:0.000209s ] [2024-09-13T16:23:07+08:00][sql] UPDATE `set` SET `value` = '77' WHERE `field` = 'product_sort' [ RunTime:0.000196s ] [2024-09-13T16:23:07+08:00][sql] SHOW FULL COLUMNS FROM `mo` [ RunTime:0.001082s ] [2024-09-13T16:23:07+08:00][sql] SELECT * FROM `mo` WHERE `id` = 1 [ RunTime:0.000336s ] [2024-09-13T16:23:07+08:00][sql] SHOW FULL COLUMNS FROM `sp` [ RunTime:0.001166s ] [2024-09-13T16:23:07+08:00][sql] SELECT * FROM `sp` WHERE `mo` = 1 AND `product` = 1 LIMIT 1 [ RunTime:0.000277s ] [2024-09-13T16:23:07+08:00][sql] INSERT INTO `sp` SET `mo` = 1 , `product` = 1 , `status` = 2 , `ratif` = 0 , `put_man` = 0 , `create_time` = '2022-02-11 00:00:00' , `update_time` = '2024-09-13 16:23:07.342682' [ RunTime:0.000311s ] [2024-09-13T16:23:07+08:00][sql] SHOW FULL COLUMNS FROM `bom` [ RunTime:0.000860s ] [2024-09-13T16:23:07+08:00][sql] SELECT * FROM `bom` WHERE `product` = 1 LIMIT 1 [ RunTime:0.000267s ] [2024-09-13T16:23:07+08:00][sql] SHOW FULL COLUMNS FROM `bom_info` [ RunTime:0.001029s ] [2024-09-13T16:23:07+08:00][sql] SELECT * FROM `bom_info` WHERE `bom` = 1 [ RunTime:0.000294s ] [2024-09-13T16:23:07+08:00][sql] SHOW FULL COLUMNS FROM `out` [ RunTime:0.001148s ] [2024-09-13T16:23:07+08:00][sql] SELECT * FROM `out` WHERE `sp` = 1 AND `raw` = 1 LIMIT 1 [ RunTime:0.000308s ] [2024-09-13T16:23:07+08:00][sql] INSERT INTO `out` SET `sp` = 1 , `raw` = 1 , `supplier` = NULL , `count` = '5' , `out_count` = '5' , `put_man` = 0 , `unit` = '' , `status` = 1 , `create_time` = '2022-02-11 00:00:00' , `out_time` = NULL , `update_time` = '2024-09-13 16:23:07.367798' [ RunTime:0.000304s ] [2024-09-13T16:23:07+08:00][sql] SELECT * FROM `out` WHERE `sp` = 1 AND `raw` = 2 LIMIT 1 [ RunTime:0.000227s ] [2024-09-13T16:23:07+08:00][sql] INSERT INTO `out` SET `sp` = 1 , `raw` = 2 , `supplier` = NULL , `count` = '5' , `out_count` = '5' , `put_man` = 0 , `unit` = '' , `status` = 1 , `create_time` = '2022-02-11 00:00:00' , `out_time` = NULL , `update_time` = '2024-09-13 16:23:07.369016' [ RunTime:0.000249s ] [2024-09-13T16:23:07+08:00][sql] SELECT * FROM `out` WHERE `sp` = 1 AND `raw` = 3 LIMIT 1 [ RunTime:0.000272s ] [2024-09-13T16:23:07+08:00][sql] INSERT INTO `out` SET `sp` = 1 , `raw` = 3 , `supplier` = NULL , `count` = '5' , `out_count` = '5' , `put_man` = 0 , `unit` = '' , `status` = 1 , `create_time` = '2022-02-11 00:00:00' , `out_time` = NULL , `update_time` = '2024-09-13 16:23:07.370023' [ RunTime:0.000227s ] [2024-09-13T16:23:07+08:00][sql] SELECT * FROM `out` WHERE `sp` = 1 AND `raw` = 4 LIMIT 1 [ RunTime:0.000208s ] [2024-09-13T16:23:07+08:00][sql] INSERT INTO `out` SET `sp` = 1 , `raw` = 4 , `supplier` = NULL , `count` = '5' , `out_count` = '5' , `put_man` = 0 , `unit` = '' , `status` = 1 , `create_time` = '2022-02-11 00:00:00' , `out_time` = NULL , `update_time` = '2024-09-13 16:23:07.370966' [ RunTime:0.000198s ] [2024-09-13T16:23:07+08:00][sql] SELECT * FROM `out` WHERE `sp` = 1 AND `raw` = 5 LIMIT 1 [ RunTime:0.000201s ] [2024-09-13T16:23:07+08:00][sql] INSERT INTO `out` SET `sp` = 1 , `raw` = 5 , `supplier` = NULL , `count` = '5' , `out_count` = '5' , `put_man` = 0 , `unit` = '' , `status` = 1 , `create_time` = '2022-02-11 00:00:00' , `out_time` = NULL , `update_time` = '2024-09-13 16:23:07.371908' [ RunTime:0.000200s ] [2024-09-13T16:23:07+08:00][sql] SELECT * FROM `out` WHERE `sp` = 1 AND `raw` = 6 LIMIT 1 [ RunTime:0.000204s ] [2024-09-13T16:23:07+08:00][sql] INSERT INTO `out` SET `sp` = 1 , `raw` = 6 , `supplier` = NULL , `count` = '5' , `out_count` = '5' , `put_man` = 0 , `unit` = '' , `status` = 1 , `create_time` = '2022-02-11 00:00:00' , `out_time` = NULL , `update_time` = '2024-09-13 16:23:07.372885' [ RunTime:0.000194s ] [2024-09-13T16:23:07+08:00][sql] SELECT * FROM `out` WHERE `sp` = 1 AND `raw` = 7 LIMIT 1 [ RunTime:0.000203s ] [2024-09-13T16:23:07+08:00][sql] INSERT INTO `out` SET `sp` = 1 , `raw` = 7 , `supplier` = NULL , `count` = '5' , `out_count` = '5' , `put_man` = 0 , `unit` = '' , `status` = 1 , `create_time` = '2022-02-11 00:00:00' , `out_time` = NULL , `update_time` = '2024-09-13 16:23:07.373816' [ RunTime:0.000208s ] [2024-09-13T16:23:07+08:00][sql] SELECT * FROM `out` WHERE `sp` = 1 AND `raw` = 8 LIMIT 1 [ RunTime:0.000203s ] [2024-09-13T16:23:07+08:00][sql] INSERT INTO `out` SET `sp` = 1 , `raw` = 8 , `supplier` = NULL , `count` = '5' , `out_count` = '5' , `put_man` = 0 , `unit` = '' , `status` = 1 , `create_time` = '2022-02-11 00:00:00' , `out_time` = NULL , `update_time` = '2024-09-13 16:23:07.374715' [ RunTime:0.000195s ] [2024-09-13T16:23:07+08:00][sql] CONNECT:[ UseTime:0.005484s ] mysql:host=127.0.0.1;port=3306;dbname=bjsfjbzdhgf;charset=utf8 [2024-09-13T16:23:07+08:00][sql] SHOW FULL COLUMNS FROM `set` [ RunTime:0.000692s ] [2024-09-13T16:23:07+08:00][sql] UPDATE `set` SET `value` = 'bjsfjbzdhgf' WHERE `field` = 'database' [ RunTime:0.000268s ] [2024-09-13T16:23:07+08:00][sql] UPDATE `set` SET `value` = '北京四方继保自动化股份有限公司' WHERE `field` = 'title' [ RunTime:0.000215s ] [2024-09-13T16:23:07+08:00][sql] UPDATE `set` SET `value` = '77' WHERE `field` = 'product_sort' [ RunTime:0.000187s ] [2024-09-13T16:23:07+08:00][sql] CONNECT:[ UseTime:0.015700s ] mysql:host=127.0.0.1;port=3306;dbname=bjsfjbzdhgf;charset=utf8 [2024-09-13T16:23:07+08:00][sql] SHOW FULL COLUMNS FROM `set` [ RunTime:0.000716s ] [2024-09-13T16:23:07+08:00][sql] UPDATE `set` SET `value` = 'bjsfjbzdhgf' WHERE `field` = 'database' [ RunTime:0.000303s ] [2024-09-13T16:23:07+08:00][sql] UPDATE `set` SET `value` = '北京四方继保自动化股份有限公司' WHERE `field` = 'title' [ RunTime:0.000198s ] [2024-09-13T16:23:07+08:00][sql] UPDATE `set` SET `value` = '77' WHERE `field` = 'product_sort' [ RunTime:0.000201s ] [2024-09-13T16:23:07+08:00][sql] SHOW FULL COLUMNS FROM `mo` [ RunTime:0.000985s ] [2024-09-13T16:23:07+08:00][sql] SELECT * FROM `mo` WHERE `id` = 1 [ RunTime:0.000325s ] [2024-09-13T16:23:07+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.000603s ] [2024-09-13T16:23:07+08:00][sql] SELECT * FROM `product` WHERE `id` = 1 [ RunTime:0.000247s ] [2024-09-13T16:23:07+08:00][sql] SHOW FULL COLUMNS FROM `tpl` [ RunTime:0.000497s ] [2024-09-13T16:23:07+08:00][sql] SELECT * FROM `tpl` WHERE `status` = 1 AND `tpl_sort` = '12' AND `sort` = 77 [ RunTime:0.000253s ] [2024-09-13T16:23:07+08:00][sql] SHOW FULL COLUMNS FROM `tpl_info` [ RunTime:0.000481s ] [2024-09-13T16:23:07+08:00][sql] SELECT * FROM `tpl_info` WHERE `tpl` = 4 ORDER BY `order` ASC [ RunTime:0.000286s ] [2024-09-13T16:23:07+08:00][sql] SHOW FULL COLUMNS FROM `pmr` [ RunTime:0.001148s ] [2024-09-13T16:23:07+08:00][sql] SELECT * FROM `pmr` WHERE `mo` = 1 AND `product` = 1 AND `tpl_info` = 41 LIMIT 1 [ RunTime:0.000275s ] [2024-09-13T16:23:07+08:00][sql] INSERT INTO `pmr` SET `mo` = 1 , `product` = 1 , `tpl_info` = 41 , `count` = 5 , `ng` = 0 , `create_time` = '2022-02-11' , `test` = '焊接温度' , `req` = '1' , `step` = '' , `maker` = 0 , `update_time` = '2024-09-13 16:23:07.662907' [ RunTime:0.000348s ] [2024-09-13T16:23:07+08:00][sql] SELECT * FROM `pmr` WHERE `mo` = 1 AND `product` = 1 AND `tpl_info` = 42 LIMIT 1 [ RunTime:0.000278s ] [2024-09-13T16:23:07+08:00][sql] INSERT INTO `pmr` SET `mo` = 1 , `product` = 1 , `tpl_info` = 42 , `count` = 5 , `ng` = 0 , `create_time` = '2022-02-11' , `test` = '焊接时间' , `req` = '2' , `step` = '' , `maker` = 0 , `update_time` = '2024-09-13 16:23:07.664045' [ RunTime:0.000210s ] [2024-09-13T16:23:07+08:00][sql] CONNECT:[ UseTime:0.000861s ] mysql:host=127.0.0.1;port=3306;dbname=bjsfjbzdhgf;charset=utf8 [2024-09-13T16:23:07+08:00][sql] SHOW FULL COLUMNS FROM `set` [ RunTime:0.000647s ] [2024-09-13T16:23:07+08:00][sql] UPDATE `set` SET `value` = 'bjsfjbzdhgf' WHERE `field` = 'database' [ RunTime:0.000320s ] [2024-09-13T16:23:07+08:00][sql] UPDATE `set` SET `value` = '北京四方继保自动化股份有限公司' WHERE `field` = 'title' [ RunTime:0.000206s ] [2024-09-13T16:23:07+08:00][sql] UPDATE `set` SET `value` = '77' WHERE `field` = 'product_sort' [ RunTime:0.000182s ] [2024-09-13T16:23:07+08:00][sql] SHOW FULL COLUMNS FROM `mo` [ RunTime:0.000964s ] [2024-09-13T16:23:07+08:00][sql] SELECT * FROM `mo` WHERE `id` = 1 [ RunTime:0.000272s ] [2024-09-13T16:23:07+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.000578s ] [2024-09-13T16:23:07+08:00][sql] SELECT * FROM `product` WHERE `id` = 1 [ RunTime:0.000238s ] [2024-09-13T16:23:07+08:00][sql] SHOW FULL COLUMNS FROM `tpl` [ RunTime:0.000525s ] [2024-09-13T16:23:07+08:00][sql] SELECT * FROM `tpl` WHERE `status` = 1 AND `tpl_sort` = '13' AND `sort` = 77 [ RunTime:0.000252s ] [2024-09-13T16:23:07+08:00][sql] SHOW FULL COLUMNS FROM `tpl_info` [ RunTime:0.000534s ] [2024-09-13T16:23:07+08:00][sql] SELECT * FROM `tpl_info` WHERE `tpl` = 5 ORDER BY `order` ASC [ RunTime:0.000269s ] [2024-09-13T16:23:07+08:00][sql] SHOW FULL COLUMNS FROM `cpp` [ RunTime:0.001161s ] [2024-09-13T16:23:07+08:00][sql] SELECT * FROM `cpp` WHERE `mo` = 1 AND `tpl_info` = 43 LIMIT 1 [ RunTime:0.000252s ] [2024-09-13T16:23:07+08:00][sql] INSERT INTO `cpp` SET `mo` = 1 , `product` = '1' , `tpl_info` = 43 , `note` = '1,1,1,1,1' , `step` = '' , `maker` = 0 , `create_time` = '2022-02-11' , `update_time` = '2024-09-13 16:23:07.784521' [ RunTime:0.000304s ] [2024-09-13T16:23:07+08:00][sql] SELECT * FROM `cpp` WHERE `mo` = 1 AND `tpl_info` = 44 LIMIT 1 [ RunTime:0.000207s ] [2024-09-13T16:23:07+08:00][sql] INSERT INTO `cpp` SET `mo` = 1 , `product` = '1' , `tpl_info` = 44 , `note` = '1,1,1,1,1' , `step` = '' , `maker` = 0 , `create_time` = '2022-02-11' , `update_time` = '2024-09-13 16:23:07.785579' [ RunTime:0.000210s ] [2024-09-13T16:23:07+08:00][sql] CONNECT:[ UseTime:0.001733s ] mysql:host=127.0.0.1;port=3306;dbname=bjsfjbzdhgf;charset=utf8 [2024-09-13T16:23:07+08:00][sql] SHOW FULL COLUMNS FROM `set` [ RunTime:0.000650s ] [2024-09-13T16:23:07+08:00][sql] UPDATE `set` SET `value` = 'bjsfjbzdhgf' WHERE `field` = 'database' [ RunTime:0.000302s ] [2024-09-13T16:23:07+08:00][sql] UPDATE `set` SET `value` = '北京四方继保自动化股份有限公司' WHERE `field` = 'title' [ RunTime:0.000196s ] [2024-09-13T16:23:07+08:00][sql] UPDATE `set` SET `value` = '77' WHERE `field` = 'product_sort' [ RunTime:0.000218s ] [2024-09-13T16:23:07+08:00][sql] SHOW FULL COLUMNS FROM `mo` [ RunTime:0.001000s ] [2024-09-13T16:23:07+08:00][sql] SELECT * FROM `mo` WHERE `id` = 1 [ RunTime:0.000315s ] [2024-09-13T16:23:07+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.000951s ] [2024-09-13T16:23:07+08:00][sql] SELECT * FROM `product` WHERE `id` = 1 [ RunTime:0.000297s ] [2024-09-13T16:23:07+08:00][sql] SELECT `value` FROM `set` WHERE `field` = 'capacity' LIMIT 1 [ RunTime:0.000284s ] [2024-09-13T16:23:07+08:00][sql] SHOW FULL COLUMNS FROM `tpl` [ RunTime:0.000581s ] [2024-09-13T16:23:07+08:00][sql] SELECT * FROM `tpl` WHERE `status` = 1 AND `tpl_sort` = '6' AND `sort` = 77 [ RunTime:0.000260s ] [2024-09-13T16:23:07+08:00][sql] SHOW FULL COLUMNS FROM `tpl_info` [ RunTime:0.000555s ] [2024-09-13T16:23:07+08:00][sql] SELECT * FROM `tpl_info` WHERE `tpl` = 1 ORDER BY `order` ASC [ RunTime:0.000308s ] [2024-09-13T16:23:07+08:00][sql] SHOW FULL COLUMNS FROM `pqc` [ RunTime:0.001322s ] [2024-09-13T16:23:07+08:00][sql] SELECT * FROM `pqc` WHERE `mo` = 1 AND `tpl_info` = 5 LIMIT 1 [ RunTime:0.000364s ] [2024-09-13T16:23:07+08:00][sql] INSERT INTO `pqc` SET `mo` = 1 , `product` = 1 , `tpl_info` = 5 , `qc_count` = 1 , `note` = '1' , `result` = 1 , `maker` = 0 , `status` = 1 , `create_time` = '2022-02-11' , `update_time` = '2024-09-13 16:23:07.900629' [ RunTime:0.000331s ] [2024-09-13T16:23:07+08:00][sql] SELECT * FROM `pqc` WHERE `mo` = 1 AND `tpl_info` = 4 LIMIT 1 [ RunTime:0.000315s ] [2024-09-13T16:23:07+08:00][sql] INSERT INTO `pqc` SET `mo` = 1 , `product` = 1 , `tpl_info` = 4 , `qc_count` = 1 , `note` = '1' , `result` = 1 , `maker` = 0 , `status` = 1 , `create_time` = '2022-02-11' , `update_time` = '2024-09-13 16:23:07.901941' [ RunTime:0.000308s ] [2024-09-13T16:23:07+08:00][sql] SELECT * FROM `pqc` WHERE `mo` = 1 AND `tpl_info` = 3 LIMIT 1 [ RunTime:0.000283s ] [2024-09-13T16:23:07+08:00][sql] INSERT INTO `pqc` SET `mo` = 1 , `product` = 1 , `tpl_info` = 3 , `qc_count` = 1 , `note` = '1' , `result` = 1 , `maker` = 0 , `status` = 1 , `create_time` = '2022-02-11' , `update_time` = '2024-09-13 16:23:07.902996' [ RunTime:0.000239s ] [2024-09-13T16:23:07+08:00][sql] SELECT * FROM `pqc` WHERE `mo` = 1 AND `tpl_info` = 2 LIMIT 1 [ RunTime:0.000238s ] [2024-09-13T16:23:07+08:00][sql] INSERT INTO `pqc` SET `mo` = 1 , `product` = 1 , `tpl_info` = 2 , `qc_count` = 1 , `note` = '1' , `result` = 1 , `maker` = 0 , `status` = 1 , `create_time` = '2022-02-11' , `update_time` = '2024-09-13 16:23:07.903902' [ RunTime:0.000229s ] [2024-09-13T16:23:07+08:00][sql] SELECT * FROM `pqc` WHERE `mo` = 1 AND `tpl_info` = 1 LIMIT 1 [ RunTime:0.000201s ] [2024-09-13T16:23:07+08:00][sql] INSERT INTO `pqc` SET `mo` = 1 , `product` = 1 , `tpl_info` = 1 , `qc_count` = 1 , `note` = '1' , `result` = 1 , `maker` = 0 , `status` = 1 , `create_time` = '2022-02-11' , `update_time` = '2024-09-13 16:23:07.904751' [ RunTime:0.000192s ] [2024-09-13T16:23:08+08:00][sql] CONNECT:[ UseTime:0.011695s ] mysql:host=127.0.0.1;port=3306;dbname=bjsfjbzdhgf;charset=utf8 [2024-09-13T16:23:08+08:00][sql] SHOW FULL COLUMNS FROM `set` [ RunTime:0.000643s ] [2024-09-13T16:23:08+08:00][sql] UPDATE `set` SET `value` = 'bjsfjbzdhgf' WHERE `field` = 'database' [ RunTime:0.000308s ] [2024-09-13T16:23:08+08:00][sql] UPDATE `set` SET `value` = '北京四方继保自动化股份有限公司' WHERE `field` = 'title' [ RunTime:0.000194s ] [2024-09-13T16:23:08+08:00][sql] UPDATE `set` SET `value` = '77' WHERE `field` = 'product_sort' [ RunTime:0.000188s ] [2024-09-13T16:23:08+08:00][sql] SHOW FULL COLUMNS FROM `mo` [ RunTime:0.001051s ] [2024-09-13T16:23:08+08:00][sql] SELECT * FROM `mo` WHERE `id` = 1 [ RunTime:0.000295s ] [2024-09-13T16:23:08+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.000957s ] [2024-09-13T16:23:08+08:00][sql] SELECT * FROM `product` WHERE `id` = 1 [ RunTime:0.000315s ] [2024-09-13T16:23:08+08:00][sql] SHOW FULL COLUMNS FROM `fqc` [ RunTime:0.001141s ] [2024-09-13T16:23:08+08:00][sql] SELECT `number` FROM `fqc` WHERE `create_time` >= '2022-02-11 00:00:00' [ RunTime:0.000245s ] [2024-09-13T16:23:08+08:00][sql] SHOW FULL COLUMNS FROM `tpl` [ RunTime:0.000564s ] [2024-09-13T16:23:08+08:00][sql] SELECT * FROM `tpl` WHERE `status` = 1 AND `tpl_sort` = '7' AND `sort` = 77 [ RunTime:0.000259s ] [2024-09-13T16:23:08+08:00][sql] SHOW FULL COLUMNS FROM `tpl_info` [ RunTime:0.001037s ] [2024-09-13T16:23:08+08:00][sql] SELECT * FROM `tpl_info` WHERE `tpl` = 2 ORDER BY `order` ASC [ RunTime:0.000338s ] [2024-09-13T16:23:08+08:00][sql] insert into `fqc`(number,mo,product,note,result,create_time)values('20220211001_0001', '1', '1', '{"13":1,"12":1,"11":1,"10":1,"9":1,"8":1,"7":1,"6":1}', '1', '2022-02-11'),('20220211001_0002', '1', '1', '{"13":1,"12":1,"11":1,"10":1,"9":1,"8":1,"7":1,"6":1}', '1', '2022-02-11'),('20220211001_0003', '1', '1', '{"13":1,"12":1,"11":1,"10":1,"9":1,"8":1,"7":1,"6":1}', '1', '2022-02-11'),('20220211001_0004', '1', '1', '{"13":1,"12":1,"11":1,"10":1,"9":1,"8":1,"7":1,"6":1}', '1', '2022-02-11'),('20220211001_0005', '1', '1', '{"13":1,"12":1,"11":1,"10":1,"9":1,"8":1,"7":1,"6":1}', '1', '2022-02-11') [ RunTime:0.000434s ] [2024-09-13T16:23:08+08:00][sql] CONNECT:[ UseTime:0.001561s ] mysql:host=127.0.0.1;port=3306;dbname=bjsfjbzdhgf;charset=utf8 [2024-09-13T16:23:08+08:00][sql] SHOW FULL COLUMNS FROM `set` [ RunTime:0.000693s ] [2024-09-13T16:23:08+08:00][sql] UPDATE `set` SET `value` = 'bjsfjbzdhgf' WHERE `field` = 'database' [ RunTime:0.000285s ] [2024-09-13T16:23:08+08:00][sql] UPDATE `set` SET `value` = '北京四方继保自动化股份有限公司' WHERE `field` = 'title' [ RunTime:0.000222s ] [2024-09-13T16:23:08+08:00][sql] UPDATE `set` SET `value` = '77' WHERE `field` = 'product_sort' [ RunTime:0.000212s ] [2024-09-13T16:23:08+08:00][sql] SHOW FULL COLUMNS FROM `up` [ RunTime:0.001354s ] [2024-09-13T16:23:08+08:00][sql] SHOW FULL COLUMNS FROM `mo` [ RunTime:0.001021s ] [2024-09-13T16:23:08+08:00][sql] SELECT * FROM `mo` WHERE `id` = 1 [ RunTime:0.000356s ] [2024-09-13T16:23:08+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.000987s ] [2024-09-13T16:23:08+08:00][sql] SELECT * FROM `product` WHERE `id` = 1 [ RunTime:0.000350s ] [2024-09-13T16:23:08+08:00][sql] SELECT `value` FROM `set` WHERE `field` = 'capacity' LIMIT 1 [ RunTime:0.000335s ] [2024-09-13T16:23:08+08:00][sql] SELECT * FROM `up` WHERE `mo` = 1 AND `product` = 1 LIMIT 1 [ RunTime:0.000227s ] [2024-09-13T16:23:08+08:00][sql] SELECT MAX(`number`) AS think_max FROM `up` WHERE `number` LIKE '20220212%' LIMIT 1 [ RunTime:0.000201s ] [2024-09-13T16:23:08+08:00][sql] INSERT INTO `up` SET `number` = '20220212001' , `mo` = 1 , `so` = 1 , `product` = 1 , `count` = 5 , `create_time` = '2022-02-11 00:00:00' , `status` = 1 , `pass_man` = 0 , `put_man` = 0 , `remark` = '' , `update_time` = '2024-09-13 16:23:08.131771' [ RunTime:0.000273s ] [2024-09-13T16:23:08+08:00][sql] CONNECT:[ UseTime:0.011425s ] mysql:host=127.0.0.1;port=3306;dbname=bjsfjbzdhgf;charset=utf8 [2024-09-13T16:23:08+08:00][sql] SHOW FULL COLUMNS FROM `set` [ RunTime:0.000738s ] [2024-09-13T16:23:08+08:00][sql] UPDATE `set` SET `value` = 'bjsfjbzdhgf' WHERE `field` = 'database' [ RunTime:0.000307s ] [2024-09-13T16:23:08+08:00][sql] UPDATE `set` SET `value` = '北京四方继保自动化股份有限公司' WHERE `field` = 'title' [ RunTime:0.000223s ] [2024-09-13T16:23:08+08:00][sql] UPDATE `set` SET `value` = '77' WHERE `field` = 'product_sort' [ RunTime:0.000180s ] [2024-09-13T16:23:08+08:00][sql] SHOW FULL COLUMNS FROM `mo` [ RunTime:0.001233s ] [2024-09-13T16:23:08+08:00][sql] SELECT * FROM `mo` WHERE `id` = 1 [ RunTime:0.000359s ] [2024-09-13T16:23:08+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.000641s ] [2024-09-13T16:23:08+08:00][sql] SELECT * FROM `product` WHERE `id` = 1 [ RunTime:0.000351s ] [2024-09-13T16:23:08+08:00][sql] SHOW FULL COLUMNS FROM `tpl` [ RunTime:0.000645s ] [2024-09-13T16:23:08+08:00][sql] SELECT * FROM `tpl` WHERE `status` = 1 AND `tpl_sort` = '8' AND `sort` = 77 [ RunTime:0.000324s ] [2024-09-13T16:23:08+08:00][sql] SHOW FULL COLUMNS FROM `tpl_info` [ RunTime:0.000648s ] [2024-09-13T16:23:08+08:00][sql] SELECT * FROM `tpl_info` WHERE `tpl` = 3 ORDER BY `order` ASC [ RunTime:0.000505s ] [2024-09-13T16:23:08+08:00][sql] SHOW FULL COLUMNS FROM `fqc` [ RunTime:0.001021s ] [2024-09-13T16:23:08+08:00][sql] SELECT * FROM `fqc` WHERE `mo` = 1 ORDER BY rand() LIMIT 2 [ RunTime:0.000542s ] [2024-09-13T16:23:08+08:00][sql] SHOW FULL COLUMNS FROM `oqc` [ RunTime:0.001254s ] [2024-09-13T16:23:08+08:00][sql] SELECT COUNT(*) AS think_count FROM `oqc` WHERE `mo` = 1 AND `product` = 1 LIMIT 1 [ RunTime:0.000296s ] [2024-09-13T16:23:08+08:00][sql] INSERT INTO `oqc` SET `number` = '20220211001_0003' , `mo` = 1 , `product` = 1 , `note` = '{\"30\":1,\"29\":1,\"28\":1,\"27\":1,\"26\":1,\"25\":1,\"24\":1,\"23\":1,\"22\":1,\"21\":1,\"20\":1,\"19\":1,\"18\":1,\"17\":1,\"16\":1,\"15\":1,\"14\":1,\"31\":1,\"32\":1,\"33\":1,\"34\":1,\"35\":1,\"36\":1,\"37\":1,\"38\":1,\"39\":1,\"40\":1}' , `result` = 1 , `create_time` = '2022-02-11' , `update_time` = '2024-09-13 16:23:08.262178' [ RunTime:0.000289s ] [2024-09-13T16:23:08+08:00][sql] SELECT COUNT(*) AS think_count FROM `oqc` WHERE `mo` = 1 AND `product` = 1 LIMIT 1 [ RunTime:0.000206s ] [2024-09-13T16:23:08+08:00][sql] INSERT INTO `oqc` SET `number` = '20220211001_0004' , `mo` = 1 , `product` = 1 , `note` = '{\"30\":1,\"29\":1,\"28\":1,\"27\":1,\"26\":1,\"25\":1,\"24\":1,\"23\":1,\"22\":1,\"21\":1,\"20\":1,\"19\":1,\"18\":1,\"17\":1,\"16\":1,\"15\":1,\"14\":1,\"31\":1,\"32\":1,\"33\":1,\"34\":1,\"35\":1,\"36\":1,\"37\":1,\"38\":1,\"39\":1,\"40\":1}' , `result` = 1 , `create_time` = '2022-02-11' , `update_time` = '2024-09-13 16:23:08.263222' [ RunTime:0.000205s ] [2024-09-13T16:23:08+08:00][sql] CONNECT:[ UseTime:0.010136s ] mysql:host=127.0.0.1;port=3306;dbname=bjsfjbzdhgf;charset=utf8 [2024-09-13T16:23:08+08:00][sql] SHOW FULL COLUMNS FROM `set` [ RunTime:0.000661s ] [2024-09-13T16:23:08+08:00][sql] UPDATE `set` SET `value` = 'bjsfjbzdhgf' WHERE `field` = 'database' [ RunTime:0.000269s ] [2024-09-13T16:23:08+08:00][sql] UPDATE `set` SET `value` = '北京四方继保自动化股份有限公司' WHERE `field` = 'title' [ RunTime:0.000206s ] [2024-09-13T16:23:08+08:00][sql] UPDATE `set` SET `value` = '77' WHERE `field` = 'product_sort' [ RunTime:0.000187s ] [2024-09-13T16:23:08+08:00][sql] SHOW FULL COLUMNS FROM `pp` [ RunTime:0.000549s ] [2024-09-13T16:23:08+08:00][sql] SELECT * FROM `pp` WHERE `so` = 1 [ RunTime:0.000262s ] [2024-09-13T16:23:08+08:00][sql] SHOW FULL COLUMNS FROM `so` [ RunTime:0.000976s ] [2024-09-13T16:23:08+08:00][sql] SELECT * FROM `so` WHERE `id` = 1 [ RunTime:0.000260s ] [2024-09-13T16:23:08+08:00][sql] SHOW FULL COLUMNS FROM `sell` [ RunTime:0.001195s ] [2024-09-13T16:23:08+08:00][sql] SELECT * FROM `sell` WHERE `so` = 1 AND `pp` = 1 AND `product` = 1 LIMIT 1 [ RunTime:0.000281s ] [2024-09-13T16:23:08+08:00][sql] INSERT INTO `sell` SET `so` = 1 , `pp` = 1 , `product` = 1 , `count` = 5 , `cust` = 1 , `create_time` = '2022-02-17 12:00:00' , `pass_man` = 0 , `report_time` = '2022-02-18 00:00:00' , `start_num` = '60940AA40591AA' , `status` = 2 , `end_num` = '60940AA40596AA' , `update_time` = '2024-09-13 16:23:08.380315' [ RunTime:0.000380s ]