[2023-11-23T10:36:31+08:00][sql] CONNECT:[ UseTime:0.006814s ] mysql:host=127.0.0.1;port=3306;dbname=hzjiudingwang;charset=utf8 [2023-11-23T10:36:31+08:00][sql] SHOW FULL COLUMNS FROM `set` [ RunTime:0.000666s ] [2023-11-23T10:36:31+08:00][sql] UPDATE `set` SET `value` = 'hzjiudingwang' WHERE `field` = 'database' [ RunTime:0.000287s ] [2023-11-23T10:36:31+08:00][sql] UPDATE `set` SET `value` = '惠州市九鼎旺门窗有限公司' WHERE `field` = 'title' [ RunTime:0.000201s ] [2023-11-23T10:36:31+08:00][sql] UPDATE `set` SET `value` = '93,90,92' WHERE `field` = 'product_sort' [ RunTime:0.000190s ] [2023-11-23T10:38:36+08:00][sql] CONNECT:[ UseTime:0.004069s ] mysql:host=127.0.0.1;port=3306;dbname=hzjiudingwang;charset=utf8 [2023-11-23T10:38:36+08:00][sql] SHOW FULL COLUMNS FROM `set` [ RunTime:0.000744s ] [2023-11-23T10:38:36+08:00][sql] UPDATE `set` SET `value` = 'hzjiudingwang' WHERE `field` = 'database' [ RunTime:0.000299s ] [2023-11-23T10:38:36+08:00][sql] UPDATE `set` SET `value` = '惠州市九鼎旺门窗有限公司' WHERE `field` = 'title' [ RunTime:0.000213s ] [2023-11-23T10:38:36+08:00][sql] UPDATE `set` SET `value` = '93,90,92' WHERE `field` = 'product_sort' [ RunTime:0.000188s ] [2023-11-23T10:38:56+08:00][sql] CONNECT:[ UseTime:0.007047s ] mysql:host=127.0.0.1;port=3306;dbname=hzjiudingwang;charset=utf8 [2023-11-23T10:38:56+08:00][sql] SHOW FULL COLUMNS FROM `set` [ RunTime:0.000690s ] [2023-11-23T10:38:56+08:00][sql] UPDATE `set` SET `value` = 'hzjiudingwang' WHERE `field` = 'database' [ RunTime:0.000302s ] [2023-11-23T10:38:56+08:00][sql] UPDATE `set` SET `value` = '惠州市九鼎旺门窗有限公司' WHERE `field` = 'title' [ RunTime:0.000290s ] [2023-11-23T10:38:56+08:00][sql] UPDATE `set` SET `value` = '93,90,92' WHERE `field` = 'product_sort' [ RunTime:0.000263s ] [2023-11-23T10:39:01+08:00][sql] CONNECT:[ UseTime:0.011567s ] mysql:host=127.0.0.1;port=3306;dbname=hzjiudingwang;charset=utf8 [2023-11-23T10:39:01+08:00][sql] SHOW FULL COLUMNS FROM `set` [ RunTime:0.000818s ] [2023-11-23T10:39:01+08:00][sql] UPDATE `set` SET `value` = 'hzjiudingwang' WHERE `field` = 'database' [ RunTime:0.000266s ] [2023-11-23T10:39:01+08:00][sql] UPDATE `set` SET `value` = '惠州市九鼎旺门窗有限公司' WHERE `field` = 'title' [ RunTime:0.000211s ] [2023-11-23T10:39:01+08:00][sql] UPDATE `set` SET `value` = '93,90,92' WHERE `field` = 'product_sort' [ RunTime:0.000226s ] [2023-11-23T10:39:02+08:00][sql] CONNECT:[ UseTime:0.004168s ] mysql:host=127.0.0.1;port=3306;dbname=hzjiudingwang;charset=utf8 [2023-11-23T10:39:02+08:00][sql] SHOW FULL COLUMNS FROM `set` [ RunTime:0.000684s ] [2023-11-23T10:39:02+08:00][sql] UPDATE `set` SET `value` = 'hzjiudingwang' WHERE `field` = 'database' [ RunTime:0.000281s ] [2023-11-23T10:39:02+08:00][sql] UPDATE `set` SET `value` = '惠州市九鼎旺门窗有限公司' WHERE `field` = 'title' [ RunTime:0.000223s ] [2023-11-23T10:39:02+08:00][sql] UPDATE `set` SET `value` = '93,90,92' WHERE `field` = 'product_sort' [ RunTime:0.000207s ] [2023-11-23T10:39:02+08:00][sql] SHOW FULL COLUMNS FROM `cust` [ RunTime:0.021713s ] [2023-11-23T10:39:02+08:00][sql] SELECT MAX(`number`) AS think_max FROM `cust` LIMIT 1 [ RunTime:0.000347s ] [2023-11-23T10:39:02+08:00][sql] SELECT * FROM `cust` WHERE `name` = '广东思创建设工程有限公司' LIMIT 1 [ RunTime:0.000284s ] [2023-11-23T10:39:02+08:00][sql] INSERT INTO `cust` SET `number` = '00036' , `name` = '广东思创建设工程有限公司' , `create_time` = '2023-11-23 10:39:02.401396' , `update_time` = '2023-11-23 10:39:02.401409' [ RunTime:0.000216s ] [2023-11-23T10:39:02+08:00][sql] SHOW FULL COLUMNS FROM `project` [ RunTime:0.006038s ] [2023-11-23T10:39:02+08:00][sql] SELECT * FROM `project` WHERE `name` = '' AND `cust` = 18 LIMIT 1 [ RunTime:0.000358s ] [2023-11-23T10:39:02+08:00][sql] INSERT INTO `project` SET `name` = '' , `cust` = 18 , `create_time` = '2023-11-23 10:39:02.423018' , `update_time` = '2023-11-23 10:39:02.423031' [ RunTime:0.000258s ] [2023-11-23T10:39:02+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.000771s ] [2023-11-23T10:39:02+08:00][sql] SELECT * FROM `product` [ RunTime:0.000261s ] [2023-11-23T10:39:02+08:00][sql] SELECT `value` FROM `set` WHERE `field` = 'lead_time' LIMIT 1 [ RunTime:0.000323s ] [2023-11-23T10:39:02+08:00][sql] SELECT `value` FROM `set` WHERE `field` = 'so_maker' LIMIT 1 [ RunTime:0.000219s ] [2023-11-23T10:39:02+08:00][sql] SELECT `value` FROM `set` WHERE `field` = 'so_ratif' LIMIT 1 [ RunTime:0.000198s ] [2023-11-23T10:39:02+08:00][sql] SELECT `value` FROM `set` WHERE `field` = 'put_man' LIMIT 1 [ RunTime:0.000192s ] [2023-11-23T10:39:02+08:00][sql] SHOW FULL COLUMNS FROM `so` [ RunTime:0.017885s ] [2023-11-23T10:39:02+08:00][sql] SELECT * FROM `so` WHERE `cust` = 18 AND `project` = '18' AND `report_time` = '2023-11-23' LIMIT 1 [ RunTime:0.000473s ] [2023-11-23T10:39:02+08:00][sql] SELECT MAX(`number`) AS think_max FROM `so` WHERE `number` LIKE '20231116%' LIMIT 1 [ RunTime:0.000249s ] [2023-11-23T10:39:02+08:00][sql] INSERT INTO `so` SET `number` = '20231116001' , `cust` = 18 , `project` = '18' , `addr` = '' , `linkman` = 0 , `req` = '' , `status` = 6 , `create_time` = '2023-11-16' , `report_time` = '2023-11-23' , `maker` = 0 , `ratif` = 0 , `update_time` = '2023-11-23 10:39:02.464262' [ RunTime:0.000223s ] [2023-11-23T10:39:02+08:00][sql] SHOW FULL COLUMNS FROM `pp` [ RunTime:0.006075s ] [2023-11-23T10:39:02+08:00][sql] SELECT * FROM `pp` WHERE `start_num` = '62379AA64001AA' AND `end_num` = '62379AA64010AA' LIMIT 1 [ RunTime:0.000372s ] [2023-11-23T10:39:02+08:00][sql] INSERT INTO `pp` SET `so` = 23 , `count` = 10 , `product` = 3 , `status` = 6 , `name` = '钢质隔热防火门' , `type` = 'GFM-1227-bd5 A1.00(乙级)-1' , `specs` = '\\' , `unit` = '樘' , `need_time` = '2023-11-22' , `create_time` = '2023-11-16' , `report_time` = '2023-11-23' , `start_num` = '62379AA64001AA' , `end_num` = '62379AA64010AA' , `update_time` = '2023-11-23 10:39:02.510622' [ RunTime:0.000276s ] [2023-11-23T10:39:02+08:00][sql] CONNECT:[ UseTime:0.006250s ] mysql:host=127.0.0.1;port=3306;dbname=hzjiudingwang;charset=utf8 [2023-11-23T10:39:02+08:00][sql] SHOW FULL COLUMNS FROM `set` [ RunTime:0.000715s ] [2023-11-23T10:39:02+08:00][sql] UPDATE `set` SET `value` = 'hzjiudingwang' WHERE `field` = 'database' [ RunTime:0.000278s ] [2023-11-23T10:39:02+08:00][sql] UPDATE `set` SET `value` = '惠州市九鼎旺门窗有限公司' WHERE `field` = 'title' [ RunTime:0.000224s ] [2023-11-23T10:39:02+08:00][sql] UPDATE `set` SET `value` = '93,90,92' WHERE `field` = 'product_sort' [ RunTime:0.000201s ] [2023-11-23T10:39:02+08:00][sql] SHOW FULL COLUMNS FROM `pp` [ RunTime:0.006416s ] [2023-11-23T10:39:02+08:00][sql] SELECT * FROM `pp` WHERE `so` = 23 [ RunTime:0.000319s ] [2023-11-23T10:39:02+08:00][sql] SHOW FULL COLUMNS FROM `bom` [ RunTime:0.005770s ] [2023-11-23T10:39:02+08:00][sql] SELECT * FROM `bom` WHERE `product` = 3 [ RunTime:0.000327s ] [2023-11-23T10:39:02+08:00][sql] SHOW FULL COLUMNS FROM `bom_info` [ RunTime:0.007364s ] [2023-11-23T10:39:02+08:00][sql] SELECT * FROM `bom_info` WHERE `bom` = 1 [ RunTime:0.000352s ] [2023-11-23T10:39:02+08:00][sql] SHOW FULL COLUMNS FROM `raw` [ RunTime:0.006562s ] [2023-11-23T10:39:02+08:00][sql] SELECT * FROM `raw` [ RunTime:0.000347s ] [2023-11-23T10:39:02+08:00][sql] SHOW FULL COLUMNS FROM `mrp` [ RunTime:0.006634s ] [2023-11-23T10:39:02+08:00][sql] SELECT * FROM `mrp` WHERE `pp` = 59 AND `raw` = 21 LIMIT 1 [ RunTime:0.000377s ] [2023-11-23T10:39:02+08:00][sql] INSERT INTO `mrp` SET `so` = 23 , `pp` = 59 , `count` = 100 , `raw` = 21 , `need_time` = '2023-11-22 00:00:00' , `status` = 5 , `create_time` = '2023-11-16 00:00:00' , `update_time` = '2023-11-23 10:39:02.732357' [ RunTime:0.000237s ] [2023-11-23T10:39:02+08:00][sql] SELECT * FROM `mrp` WHERE `pp` = 59 AND `raw` = 13 LIMIT 1 [ RunTime:0.000246s ] [2023-11-23T10:39:02+08:00][sql] INSERT INTO `mrp` SET `so` = 23 , `pp` = 59 , `count` = 50 , `raw` = 13 , `need_time` = '2023-11-22 00:00:00' , `status` = 5 , `create_time` = '2023-11-16 00:00:00' , `update_time` = '2023-11-23 10:39:02.733374' [ RunTime:0.000183s ] [2023-11-23T10:39:02+08:00][sql] SELECT * FROM `mrp` WHERE `pp` = 59 AND `raw` = 9 LIMIT 1 [ RunTime:0.000233s ] [2023-11-23T10:39:02+08:00][sql] INSERT INTO `mrp` SET `so` = 23 , `pp` = 59 , `count` = 10 , `raw` = 9 , `need_time` = '2023-11-22 00:00:00' , `status` = 5 , `create_time` = '2023-11-16 00:00:00' , `update_time` = '2023-11-23 10:39:02.734205' [ RunTime:0.000176s ] [2023-11-23T10:39:02+08:00][sql] SELECT * FROM `mrp` WHERE `pp` = 59 AND `raw` = 8 LIMIT 1 [ RunTime:0.000216s ] [2023-11-23T10:39:02+08:00][sql] INSERT INTO `mrp` SET `so` = 23 , `pp` = 59 , `count` = 30 , `raw` = 8 , `need_time` = '2023-11-22 00:00:00' , `status` = 5 , `create_time` = '2023-11-16 00:00:00' , `update_time` = '2023-11-23 10:39:02.735013' [ RunTime:0.000180s ] [2023-11-23T10:39:02+08:00][sql] SELECT * FROM `mrp` WHERE `pp` = 59 AND `raw` = 7 LIMIT 1 [ RunTime:0.000229s ] [2023-11-23T10:39:02+08:00][sql] INSERT INTO `mrp` SET `so` = 23 , `pp` = 59 , `count` = 10 , `raw` = 7 , `need_time` = '2023-11-22 00:00:00' , `status` = 5 , `create_time` = '2023-11-16 00:00:00' , `update_time` = '2023-11-23 10:39:02.735858' [ RunTime:0.000169s ] [2023-11-23T10:39:02+08:00][sql] SELECT * FROM `mrp` WHERE `pp` = 59 AND `raw` = 3 LIMIT 1 [ RunTime:0.000224s ] [2023-11-23T10:39:02+08:00][sql] INSERT INTO `mrp` SET `so` = 23 , `pp` = 59 , `count` = 20 , `raw` = 3 , `need_time` = '2023-11-22 00:00:00' , `status` = 5 , `create_time` = '2023-11-16 00:00:00' , `update_time` = '2023-11-23 10:39:02.736648' [ RunTime:0.000163s ] [2023-11-23T10:39:02+08:00][sql] SELECT * FROM `mrp` WHERE `pp` = 59 AND `raw` = 2 LIMIT 1 [ RunTime:0.000223s ] [2023-11-23T10:39:02+08:00][sql] INSERT INTO `mrp` SET `so` = 23 , `pp` = 59 , `count` = 20 , `raw` = 2 , `need_time` = '2023-11-22 00:00:00' , `status` = 5 , `create_time` = '2023-11-16 00:00:00' , `update_time` = '2023-11-23 10:39:02.737438' [ RunTime:0.000179s ] [2023-11-23T10:39:02+08:00][sql] SELECT * FROM `mrp` WHERE `pp` = 59 AND `raw` = 1 LIMIT 1 [ RunTime:0.000228s ] [2023-11-23T10:39:02+08:00][sql] INSERT INTO `mrp` SET `so` = 23 , `pp` = 59 , `count` = 40 , `raw` = 1 , `need_time` = '2023-11-22 00:00:00' , `status` = 5 , `create_time` = '2023-11-16 00:00:00' , `update_time` = '2023-11-23 10:39:02.738235' [ RunTime:0.000173s ] [2023-11-23T10:39:02+08:00][sql] CONNECT:[ UseTime:0.015714s ] mysql:host=127.0.0.1;port=3306;dbname=hzjiudingwang;charset=utf8 [2023-11-23T10:39:02+08:00][sql] SHOW FULL COLUMNS FROM `set` [ RunTime:0.000730s ] [2023-11-23T10:39:02+08:00][sql] UPDATE `set` SET `value` = 'hzjiudingwang' WHERE `field` = 'database' [ RunTime:0.000299s ] [2023-11-23T10:39:02+08:00][sql] UPDATE `set` SET `value` = '惠州市九鼎旺门窗有限公司' WHERE `field` = 'title' [ RunTime:0.000217s ] [2023-11-23T10:39:02+08:00][sql] UPDATE `set` SET `value` = '93,90,92' WHERE `field` = 'product_sort' [ RunTime:0.000188s ] [2023-11-23T10:39:03+08:00][sql] CONNECT:[ UseTime:0.007744s ] mysql:host=127.0.0.1;port=3306;dbname=hzjiudingwang;charset=utf8 [2023-11-23T10:39:03+08:00][sql] SHOW FULL COLUMNS FROM `set` [ RunTime:0.000841s ] [2023-11-23T10:39:03+08:00][sql] UPDATE `set` SET `value` = 'hzjiudingwang' WHERE `field` = 'database' [ RunTime:0.000302s ] [2023-11-23T10:39:03+08:00][sql] UPDATE `set` SET `value` = '惠州市九鼎旺门窗有限公司' WHERE `field` = 'title' [ RunTime:0.000204s ] [2023-11-23T10:39:03+08:00][sql] UPDATE `set` SET `value` = '93,90,92' WHERE `field` = 'product_sort' [ RunTime:0.000218s ] [2023-11-23T10:39:03+08:00][sql] SHOW FULL COLUMNS FROM `mrp` [ RunTime:0.007160s ] [2023-11-23T10:39:03+08:00][sql] SELECT * FROM `mrp` WHERE `id` IN (498,499,500,501,502,503,504,505) [ RunTime:0.000389s ] [2023-11-23T10:39:03+08:00][sql] SHOW FULL COLUMNS FROM `raw` [ RunTime:0.001055s ] [2023-11-23T10:39:03+08:00][sql] SELECT * FROM `raw` WHERE `id` IN (21,13,9,8,7,3,2,1) [ RunTime:0.000393s ] [2023-11-23T10:39:03+08:00][sql] SHOW FULL COLUMNS FROM `supplier` [ RunTime:0.006298s ] [2023-11-23T10:39:03+08:00][sql] SELECT * FROM `supplier` [ RunTime:0.000391s ] [2023-11-23T10:39:03+08:00][sql] SELECT `value` FROM `set` WHERE `field` = 'po_base' LIMIT 1 [ RunTime:0.000327s ] [2023-11-23T10:39:03+08:00][sql] SELECT `value` FROM `set` WHERE `field` = 'po_base' LIMIT 1 [ RunTime:0.000220s ] [2023-11-23T10:39:03+08:00][sql] SELECT `value` FROM `set` WHERE `field` = 'po_base' LIMIT 1 [ RunTime:0.000194s ] [2023-11-23T10:39:03+08:00][sql] SELECT `value` FROM `set` WHERE `field` = 'po_base' LIMIT 1 [ RunTime:0.000223s ] [2023-11-23T10:39:03+08:00][sql] SELECT `value` FROM `set` WHERE `field` = 'po_base' LIMIT 1 [ RunTime:0.000189s ] [2023-11-23T10:39:03+08:00][sql] SELECT `value` FROM `set` WHERE `field` = 'po_base' LIMIT 1 [ RunTime:0.000186s ] [2023-11-23T10:39:03+08:00][sql] SELECT `value` FROM `set` WHERE `field` = 'po_base' LIMIT 1 [ RunTime:0.000212s ] [2023-11-23T10:39:03+08:00][sql] SELECT `value` FROM `set` WHERE `field` = 'po_base' LIMIT 1 [ RunTime:0.000204s ] [2023-11-23T10:39:03+08:00][sql] SHOW FULL COLUMNS FROM `po` [ RunTime:0.007103s ] [2023-11-23T10:39:03+08:00][sql] SELECT `number` FROM `po` [ RunTime:0.000288s ] [2023-11-23T10:39:05+08:00][sql] CONNECT:[ UseTime:0.002675s ] mysql:host=127.0.0.1;port=3306;dbname=hzjiudingwang;charset=utf8 [2023-11-23T10:39:05+08:00][sql] SHOW FULL COLUMNS FROM `set` [ RunTime:0.000684s ] [2023-11-23T10:39:05+08:00][sql] UPDATE `set` SET `value` = 'hzjiudingwang' WHERE `field` = 'database' [ RunTime:0.000284s ] [2023-11-23T10:39:05+08:00][sql] UPDATE `set` SET `value` = '惠州市九鼎旺门窗有限公司' WHERE `field` = 'title' [ RunTime:0.000249s ] [2023-11-23T10:39:05+08:00][sql] UPDATE `set` SET `value` = '93,90,92' WHERE `field` = 'product_sort' [ RunTime:0.000197s ] [2023-11-23T10:39:05+08:00][sql] SELECT `value` FROM `set` WHERE `field` = 'po_maker' LIMIT 1 [ RunTime:0.000227s ] [2023-11-23T10:39:05+08:00][sql] SELECT `value` FROM `set` WHERE `field` = 'po_ratif' LIMIT 1 [ RunTime:0.000204s ] [2023-11-23T10:39:05+08:00][sql] SHOW FULL COLUMNS FROM `po` [ RunTime:0.000772s ] [2023-11-23T10:39:05+08:00][sql] SELECT * FROM `po` WHERE `mrp` = '498' AND `so` = '23' AND `raw` = 21 LIMIT 1 [ RunTime:0.000295s ] [2023-11-23T10:39:05+08:00][sql] SELECT MAX(`number`) AS think_max FROM `po` WHERE `number` LIKE '20231116%' LIMIT 1 [ RunTime:0.000260s ] [2023-11-23T10:39:05+08:00][sql] INSERT INTO `po` SET `number` = '20231116001' , `so` = '23' , `mrp` = '498' , `raw` = 21 , `count` = '100' , `po_count` = '105' , `create_time` = '2023-11-16 00:00:00' , `deliver_time` = '2023-11-18 00:00:00' , `supplier` = 14 , `status` = 8 , `po_unit` = '米' , `maker` = 0 , `ratif` = 0 , `update_time` = '2023-11-23 10:39:05.398811' [ RunTime:0.000221s ] [2023-11-23T10:39:05+08:00][sql] SELECT * FROM `po` WHERE `mrp` = '499' AND `so` = '23' AND `raw` = 13 LIMIT 1 [ RunTime:0.000238s ] [2023-11-23T10:39:05+08:00][sql] SELECT MAX(`number`) AS think_max FROM `po` WHERE `number` LIKE '20231116%' LIMIT 1 [ RunTime:0.000203s ] [2023-11-23T10:39:05+08:00][sql] INSERT INTO `po` SET `number` = '20231116002' , `so` = '23' , `mrp` = '499' , `raw` = 13 , `count` = '50' , `po_count` = '52' , `create_time` = '2023-11-16 00:00:00' , `deliver_time` = '2023-11-18 00:00:00' , `supplier` = 21 , `status` = 8 , `po_unit` = 'kg' , `maker` = 0 , `ratif` = 0 , `update_time` = '2023-11-23 10:39:05.400107' [ RunTime:0.000214s ] [2023-11-23T10:39:05+08:00][sql] SELECT * FROM `po` WHERE `mrp` = '500' AND `so` = '23' AND `raw` = 9 LIMIT 1 [ RunTime:0.000248s ] [2023-11-23T10:39:05+08:00][sql] SELECT MAX(`number`) AS think_max FROM `po` WHERE `number` LIKE '20231116%' LIMIT 1 [ RunTime:0.000200s ] [2023-11-23T10:39:05+08:00][sql] INSERT INTO `po` SET `number` = '20231116003' , `so` = '23' , `mrp` = '500' , `raw` = 9 , `count` = '10' , `po_count` = '10' , `create_time` = '2023-11-16 00:00:00' , `deliver_time` = '2023-11-18 00:00:00' , `supplier` = 28 , `status` = 8 , `po_unit` = '块' , `maker` = 0 , `ratif` = 0 , `update_time` = '2023-11-23 10:39:05.401318' [ RunTime:0.000195s ] [2023-11-23T10:39:05+08:00][sql] SELECT * FROM `po` WHERE `mrp` = '501' AND `so` = '23' AND `raw` = 8 LIMIT 1 [ RunTime:0.000220s ] [2023-11-23T10:39:05+08:00][sql] SELECT MAX(`number`) AS think_max FROM `po` WHERE `number` LIKE '20231116%' LIMIT 1 [ RunTime:0.000200s ] [2023-11-23T10:39:05+08:00][sql] INSERT INTO `po` SET `number` = '20231116004' , `so` = '23' , `mrp` = '501' , `raw` = 8 , `count` = '30' , `po_count` = '31' , `create_time` = '2023-11-16 00:00:00' , `deliver_time` = '2023-11-18 00:00:00' , `supplier` = 26 , `status` = 8 , `po_unit` = '樘' , `maker` = 0 , `ratif` = 0 , `update_time` = '2023-11-23 10:39:05.402500' [ RunTime:0.000213s ] [2023-11-23T10:39:05+08:00][sql] SELECT * FROM `po` WHERE `mrp` = '502' AND `so` = '23' AND `raw` = 7 LIMIT 1 [ RunTime:0.000240s ] [2023-11-23T10:39:05+08:00][sql] SELECT MAX(`number`) AS think_max FROM `po` WHERE `number` LIKE '20231116%' LIMIT 1 [ RunTime:0.000230s ] [2023-11-23T10:39:05+08:00][sql] INSERT INTO `po` SET `number` = '20231116005' , `so` = '23' , `mrp` = '502' , `raw` = 7 , `count` = '10' , `po_count` = '10' , `create_time` = '2023-11-16 00:00:00' , `deliver_time` = '2023-11-18 00:00:00' , `supplier` = 25 , `status` = 8 , `po_unit` = '把' , `maker` = 0 , `ratif` = 0 , `update_time` = '2023-11-23 10:39:05.403761' [ RunTime:0.000189s ] [2023-11-23T10:39:05+08:00][sql] SELECT * FROM `po` WHERE `mrp` = '503' AND `so` = '23' AND `raw` = 3 LIMIT 1 [ RunTime:0.000230s ] [2023-11-23T10:39:05+08:00][sql] SELECT MAX(`number`) AS think_max FROM `po` WHERE `number` LIKE '20231116%' LIMIT 1 [ RunTime:0.000198s ] [2023-11-23T10:39:05+08:00][sql] INSERT INTO `po` SET `number` = '20231116006' , `so` = '23' , `mrp` = '503' , `raw` = 3 , `count` = '20' , `po_count` = '21' , `create_time` = '2023-11-16 00:00:00' , `deliver_time` = '2023-11-18 00:00:00' , `supplier` = 12 , `status` = 8 , `po_unit` = '张' , `maker` = 0 , `ratif` = 0 , `update_time` = '2023-11-23 10:39:05.404937' [ RunTime:0.000213s ] [2023-11-23T10:39:05+08:00][sql] SELECT * FROM `po` WHERE `mrp` = '504' AND `so` = '23' AND `raw` = 2 LIMIT 1 [ RunTime:0.000237s ] [2023-11-23T10:39:05+08:00][sql] SELECT MAX(`number`) AS think_max FROM `po` WHERE `number` LIKE '20231116%' LIMIT 1 [ RunTime:0.000190s ] [2023-11-23T10:39:05+08:00][sql] INSERT INTO `po` SET `number` = '20231116007' , `so` = '23' , `mrp` = '504' , `raw` = 2 , `count` = '20' , `po_count` = '21' , `create_time` = '2023-11-16 00:00:00' , `deliver_time` = '2023-11-18 00:00:00' , `supplier` = 12 , `status` = 8 , `po_unit` = '张' , `maker` = 0 , `ratif` = 0 , `update_time` = '2023-11-23 10:39:05.406117' [ RunTime:0.000232s ] [2023-11-23T10:39:05+08:00][sql] SELECT * FROM `po` WHERE `mrp` = '505' AND `so` = '23' AND `raw` = 1 LIMIT 1 [ RunTime:0.000222s ] [2023-11-23T10:39:05+08:00][sql] SELECT MAX(`number`) AS think_max FROM `po` WHERE `number` LIKE '20231116%' LIMIT 1 [ RunTime:0.000210s ] [2023-11-23T10:39:05+08:00][sql] INSERT INTO `po` SET `number` = '20231116008' , `so` = '23' , `mrp` = '505' , `raw` = 1 , `count` = '40' , `po_count` = '42' , `create_time` = '2023-11-16 00:00:00' , `deliver_time` = '2023-11-18 00:00:00' , `supplier` = 24 , `status` = 8 , `po_unit` = '个' , `maker` = 0 , `ratif` = 0 , `update_time` = '2023-11-23 10:39:05.407310' [ RunTime:0.000206s ] [2023-11-23T10:39:05+08:00][sql] CONNECT:[ UseTime:0.012592s ] mysql:host=127.0.0.1;port=3306;dbname=hzjiudingwang;charset=utf8 [2023-11-23T10:39:05+08:00][sql] SHOW FULL COLUMNS FROM `set` [ RunTime:0.000764s ] [2023-11-23T10:39:05+08:00][sql] UPDATE `set` SET `value` = 'hzjiudingwang' WHERE `field` = 'database' [ RunTime:0.000264s ] [2023-11-23T10:39:05+08:00][sql] UPDATE `set` SET `value` = '惠州市九鼎旺门窗有限公司' WHERE `field` = 'title' [ RunTime:0.000246s ] [2023-11-23T10:39:05+08:00][sql] UPDATE `set` SET `value` = '93,90,92' WHERE `field` = 'product_sort' [ RunTime:0.000216s ] [2023-11-23T10:39:05+08:00][sql] SHOW FULL COLUMNS FROM `po` [ RunTime:0.007102s ] [2023-11-23T10:39:05+08:00][sql] SELECT * FROM `po` WHERE `id` IN (36,37,38,39,40,41,42,43) [ RunTime:0.000482s ] [2023-11-23T10:39:05+08:00][sql] SHOW FULL COLUMNS FROM `an` [ RunTime:0.012693s ] [2023-11-23T10:39:05+08:00][sql] SELECT * FROM `an` WHERE `po` = 36 AND `raw` = 21 LIMIT 1 [ RunTime:0.000471s ] [2023-11-23T10:39:05+08:00][sql] SELECT MAX(`number`) AS think_max FROM `an` WHERE `number` LIKE '20231117%' LIMIT 1 [ RunTime:0.000272s ] [2023-11-23T10:39:05+08:00][sql] SELECT `value` FROM `set` WHERE `field` = 'an_maker' LIMIT 1 [ RunTime:0.000243s ] [2023-11-23T10:39:05+08:00][sql] INSERT INTO `an` SET `po` = 36 , `number` = '20231117001' , `raw` = 21 , `count` = '105.00' , `supplier` = 14 , `status` = 3 , `create_time` = '2023-11-17 10:15:02' , `update_time` = '2023-11-23 10:39:05.530431' [ RunTime:0.000252s ] [2023-11-23T10:39:05+08:00][sql] SELECT * FROM `an` WHERE `po` = 37 AND `raw` = 13 LIMIT 1 [ RunTime:0.000235s ] [2023-11-23T10:39:05+08:00][sql] SELECT MAX(`number`) AS think_max FROM `an` WHERE `number` LIKE '20231117%' LIMIT 1 [ RunTime:0.000200s ] [2023-11-23T10:39:05+08:00][sql] SELECT `value` FROM `set` WHERE `field` = 'an_maker' LIMIT 1 [ RunTime:0.000198s ] [2023-11-23T10:39:05+08:00][sql] INSERT INTO `an` SET `po` = 37 , `number` = '20231117002' , `raw` = 13 , `count` = '52.00' , `supplier` = 21 , `status` = 3 , `create_time` = '2023-11-17 09:29:56' , `update_time` = '2023-11-23 10:39:05.532023' [ RunTime:0.000209s ] [2023-11-23T10:39:05+08:00][sql] SELECT * FROM `an` WHERE `po` = 38 AND `raw` = 9 LIMIT 1 [ RunTime:0.000226s ] [2023-11-23T10:39:05+08:00][sql] SELECT MAX(`number`) AS think_max FROM `an` WHERE `number` LIKE '20231117%' LIMIT 1 [ RunTime:0.000186s ] [2023-11-23T10:39:05+08:00][sql] SELECT `value` FROM `set` WHERE `field` = 'an_maker' LIMIT 1 [ RunTime:0.000311s ] [2023-11-23T10:39:05+08:00][sql] INSERT INTO `an` SET `po` = 38 , `number` = '20231117003' , `raw` = 9 , `count` = '10.00' , `supplier` = 28 , `status` = 3 , `create_time` = '2023-11-17 10:44:13' , `update_time` = '2023-11-23 10:39:05.533639' [ RunTime:0.000213s ] [2023-11-23T10:39:05+08:00][sql] SELECT * FROM `an` WHERE `po` = 39 AND `raw` = 8 LIMIT 1 [ RunTime:0.000212s ] [2023-11-23T10:39:05+08:00][sql] SELECT MAX(`number`) AS think_max FROM `an` WHERE `number` LIKE '20231117%' LIMIT 1 [ RunTime:0.000210s ] [2023-11-23T10:39:05+08:00][sql] SELECT `value` FROM `set` WHERE `field` = 'an_maker' LIMIT 1 [ RunTime:0.000201s ] [2023-11-23T10:39:05+08:00][sql] INSERT INTO `an` SET `po` = 39 , `number` = '20231117004' , `raw` = 8 , `count` = '31.00' , `supplier` = 26 , `status` = 3 , `create_time` = '2023-11-17 12:46:05' , `update_time` = '2023-11-23 10:39:05.535110' [ RunTime:0.000231s ] [2023-11-23T10:39:05+08:00][sql] SELECT * FROM `an` WHERE `po` = 40 AND `raw` = 7 LIMIT 1 [ RunTime:0.000220s ] [2023-11-23T10:39:05+08:00][sql] SELECT MAX(`number`) AS think_max FROM `an` WHERE `number` LIKE '20231117%' LIMIT 1 [ RunTime:0.000194s ] [2023-11-23T10:39:05+08:00][sql] SELECT `value` FROM `set` WHERE `field` = 'an_maker' LIMIT 1 [ RunTime:0.000202s ] [2023-11-23T10:39:05+08:00][sql] INSERT INTO `an` SET `po` = 40 , `number` = '20231117005' , `raw` = 7 , `count` = '10.00' , `supplier` = 25 , `status` = 3 , `create_time` = '2023-11-17 04:00:22' , `update_time` = '2023-11-23 10:39:05.536591' [ RunTime:0.000180s ] [2023-11-23T10:39:05+08:00][sql] SELECT * FROM `an` WHERE `po` = 41 AND `raw` = 3 LIMIT 1 [ RunTime:0.000252s ] [2023-11-23T10:39:05+08:00][sql] SELECT MAX(`number`) AS think_max FROM `an` WHERE `number` LIKE '20231117%' LIMIT 1 [ RunTime:0.000215s ] [2023-11-23T10:39:05+08:00][sql] SELECT `value` FROM `set` WHERE `field` = 'an_maker' LIMIT 1 [ RunTime:0.000196s ] [2023-11-23T10:39:05+08:00][sql] INSERT INTO `an` SET `po` = 41 , `number` = '20231117006' , `raw` = 3 , `count` = '21.00' , `supplier` = 12 , `status` = 3 , `create_time` = '2023-11-17 02:27:53' , `update_time` = '2023-11-23 10:39:05.538041' [ RunTime:0.000185s ] [2023-11-23T10:39:05+08:00][sql] SELECT * FROM `an` WHERE `po` = 42 AND `raw` = 2 LIMIT 1 [ RunTime:0.000223s ] [2023-11-23T10:39:05+08:00][sql] SELECT MAX(`number`) AS think_max FROM `an` WHERE `number` LIKE '20231117%' LIMIT 1 [ RunTime:0.000215s ] [2023-11-23T10:39:05+08:00][sql] SELECT `value` FROM `set` WHERE `field` = 'an_maker' LIMIT 1 [ RunTime:0.000197s ] [2023-11-23T10:39:05+08:00][sql] INSERT INTO `an` SET `po` = 42 , `number` = '20231117007' , `raw` = 2 , `count` = '21.00' , `supplier` = 12 , `status` = 3 , `create_time` = '2023-11-17 02:04:32' , `update_time` = '2023-11-23 10:39:05.539490' [ RunTime:0.000193s ] [2023-11-23T10:39:05+08:00][sql] SELECT * FROM `an` WHERE `po` = 43 AND `raw` = 1 LIMIT 1 [ RunTime:0.000215s ] [2023-11-23T10:39:05+08:00][sql] SELECT MAX(`number`) AS think_max FROM `an` WHERE `number` LIKE '20231117%' LIMIT 1 [ RunTime:0.000200s ] [2023-11-23T10:39:05+08:00][sql] SELECT `value` FROM `set` WHERE `field` = 'an_maker' LIMIT 1 [ RunTime:0.000190s ] [2023-11-23T10:39:05+08:00][sql] INSERT INTO `an` SET `po` = 43 , `number` = '20231117008' , `raw` = 1 , `count` = '42.00' , `supplier` = 24 , `status` = 3 , `create_time` = '2023-11-17 03:50:29' , `update_time` = '2023-11-23 10:39:05.540900' [ RunTime:0.000191s ] [2023-11-23T10:39:05+08:00][sql] CONNECT:[ UseTime:0.000930s ] mysql:host=127.0.0.1;port=3306;dbname=hzjiudingwang;charset=utf8 [2023-11-23T10:39:05+08:00][sql] SHOW FULL COLUMNS FROM `set` [ RunTime:0.000722s ] [2023-11-23T10:39:05+08:00][sql] UPDATE `set` SET `value` = 'hzjiudingwang' WHERE `field` = 'database' [ RunTime:0.000291s ] [2023-11-23T10:39:05+08:00][sql] UPDATE `set` SET `value` = '惠州市九鼎旺门窗有限公司' WHERE `field` = 'title' [ RunTime:0.000210s ] [2023-11-23T10:39:05+08:00][sql] UPDATE `set` SET `value` = '93,90,92' WHERE `field` = 'product_sort' [ RunTime:0.000203s ] [2023-11-23T10:39:05+08:00][sql] SHOW FULL COLUMNS FROM `an` [ RunTime:0.006972s ] [2023-11-23T10:39:05+08:00][sql] SELECT * FROM `an` WHERE `id` IN (36,37,38,39,40,41,42,43) [ RunTime:0.000435s ] [2023-11-23T10:39:05+08:00][sql] SHOW FULL COLUMNS FROM `raw` [ RunTime:0.000985s ] [2023-11-23T10:39:05+08:00][sql] SELECT * FROM `raw` WHERE `id` IN (21,13,9,8,7,3,2,1) [ RunTime:0.000339s ] [2023-11-23T10:39:05+08:00][sql] SHOW FULL COLUMNS FROM `iqc` [ RunTime:0.021723s ] [2023-11-23T10:39:05+08:00][sql] SELECT * FROM `iqc` WHERE `an` = '36' AND `raw` = 21 LIMIT 1 [ RunTime:0.000411s ] [2023-11-23T10:39:05+08:00][sql] SELECT MAX(`number`) AS think_max FROM `iqc` WHERE `number` LIKE '20231118%' LIMIT 1 [ RunTime:0.000257s ] [2023-11-23T10:39:05+08:00][sql] SELECT `value` FROM `set` WHERE `field` = 'iqc_maker' LIMIT 1 [ RunTime:0.000263s ] [2023-11-23T10:39:05+08:00][sql] SELECT `value` FROM `set` WHERE `field` = 'iqc_maker' LIMIT 1 [ RunTime:0.000210s ] [2023-11-23T10:39:05+08:00][sql] SELECT `value` FROM `set` WHERE `field` = 'iqc_ratif' LIMIT 1 [ RunTime:0.000191s ] [2023-11-23T10:39:05+08:00][sql] INSERT INTO `iqc` SET `number` = '20231118001' , `an` = '36' , `raw` = 21 , `supplier` = 14 , `count` = '105.00' , `result` = '1' , `maker` = 李四 , `ratif` = 0 , `remark` = '' , `status` = 4 , `create_time` = '2023-11-18' , `update_time` = '2023-11-23 10:39:05.679252' [ RunTime:0.000238s ] [2023-11-23T10:39:05+08:00][sql] SHOW FULL COLUMNS FROM `tpl` [ RunTime:0.000599s ] [2023-11-23T10:39:05+08:00][sql] SELECT * FROM `tpl` WHERE `status` = 1 AND `tpl_sort` = '14' AND `sort` = 52 [ RunTime:0.000284s ] [2023-11-23T10:39:05+08:00][sql] SHOW FULL COLUMNS FROM `tpl_info` [ RunTime:0.000802s ] [2023-11-23T10:39:05+08:00][sql] SELECT * FROM `tpl_info` WHERE `tpl` = 14 ORDER BY `order` ASC [ RunTime:0.000477s ] [2023-11-23T10:39:05+08:00][sql] SHOW FULL COLUMNS FROM `iqc_note` [ RunTime:0.015607s ] [2023-11-23T10:39:05+08:00][sql] SELECT * FROM `iqc_note` WHERE `iqc` = 36 AND `tpl_raw_info` = 162 LIMIT 1 [ RunTime:0.000446s ] [2023-11-23T10:39:05+08:00][sql] INSERT INTO `iqc_note` SET `iqc` = 36 , `tpl_raw_info` = 162 , `qc_count` = '20' , `count` = '20' , `note` = '-0.2,0.08,-0.47,0.41,-0.94,0.11,0.38,0.26,0.93,-0.75,0.51,-0.22,0.64,-0.81,0.99,0.11,0.83,0.12,0.41,0.41,' , `ng` = '0' , `create_time` = '2023-11-18' , `remark` = '' , `update_time` = '2023-11-23 10:39:05.713528' [ RunTime:0.000253s ] [2023-11-23T10:39:05+08:00][sql] SELECT * FROM `iqc_note` WHERE `iqc` = 36 AND `tpl_raw_info` = 161 LIMIT 1 [ RunTime:0.000318s ] [2023-11-23T10:39:05+08:00][sql] INSERT INTO `iqc_note` SET `iqc` = 36 , `tpl_raw_info` = 161 , `qc_count` = '20' , `count` = '20' , `note` = '7.2,-8.05,-6.2,0.28,-3.56,5.91,-8.35,-8.93,9.42,-4.74,-5.58,5.42,8.27,-0.74,-3.11,6.71,-9.37,-8.21,-6.5,1.05,' , `ng` = '0' , `create_time` = '2023-11-18' , `remark` = '' , `update_time` = '2023-11-23 10:39:05.714656' [ RunTime:0.000249s ] [2023-11-23T10:39:05+08:00][sql] SELECT * FROM `iqc_note` WHERE `iqc` = 36 AND `tpl_raw_info` = 160 LIMIT 1 [ RunTime:0.000312s ] [2023-11-23T10:39:05+08:00][sql] INSERT INTO `iqc_note` SET `iqc` = 36 , `tpl_raw_info` = 160 , `qc_count` = '20' , `count` = '20' , `note` = '4.25,3.11,4.97,3.69,4.71,4.93,4.79,3.46,3.33,3.35,3.21,4.1,3.65,4.45,3.57,3.25,3.17,4.17,4.62,3.26,' , `ng` = '0' , `create_time` = '2023-11-18' , `remark` = '' , `update_time` = '2023-11-23 10:39:05.715664' [ RunTime:0.000181s ] [2023-11-23T10:39:05+08:00][sql] SELECT * FROM `iqc_note` WHERE `iqc` = 36 AND `tpl_raw_info` = 159 LIMIT 1 [ RunTime:0.000295s ] [2023-11-23T10:39:05+08:00][sql] INSERT INTO `iqc_note` SET `iqc` = 36 , `tpl_raw_info` = 159 , `qc_count` = '20' , `count` = '20' , `note` = '0.04,0.01,0.06,0.05,0.01,0.04,0.02,0.02,0.06,0.02,0.04,0.06,0.02,0.02,0.06,0.02,0.04,0.02,0.01,0.02,' , `ng` = '0' , `create_time` = '2023-11-18' , `remark` = '' , `update_time` = '2023-11-23 10:39:05.716582' [ RunTime:0.000183s ] [2023-11-23T10:39:05+08:00][sql] SELECT * FROM `iqc_note` WHERE `iqc` = 36 AND `tpl_raw_info` = 158 LIMIT 1 [ RunTime:0.000259s ] [2023-11-23T10:39:05+08:00][sql] INSERT INTO `iqc_note` SET `iqc` = 36 , `tpl_raw_info` = 158 , `qc_count` = '20' , `count` = '20' , `note` = '1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,' , `ng` = '0' , `create_time` = '2023-11-18' , `remark` = '' , `update_time` = '2023-11-23 10:39:05.717463' [ RunTime:0.000240s ] [2023-11-23T10:39:05+08:00][sql] SELECT * FROM `iqc_note` WHERE `iqc` = 36 AND `tpl_raw_info` = 157 LIMIT 1 [ RunTime:0.000279s ] [2023-11-23T10:39:05+08:00][sql] INSERT INTO `iqc_note` SET `iqc` = 36 , `tpl_raw_info` = 157 , `qc_count` = '20' , `count` = '20' , `note` = '1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,' , `ng` = '0' , `create_time` = '2023-11-18' , `remark` = '' , `update_time` = '2023-11-23 10:39:05.718392' [ RunTime:0.000247s ] [2023-11-23T10:39:05+08:00][sql] SELECT * FROM `iqc_note` WHERE `iqc` = 36 AND `tpl_raw_info` = 156 LIMIT 1 [ RunTime:0.000269s ] [2023-11-23T10:39:05+08:00][sql] INSERT INTO `iqc_note` SET `iqc` = 36 , `tpl_raw_info` = 156 , `qc_count` = '20' , `count` = '20' , `note` = '1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,' , `ng` = '0' , `create_time` = '2023-11-18' , `remark` = '' , `update_time` = '2023-11-23 10:39:05.719315' [ RunTime:0.000210s ] [2023-11-23T10:39:05+08:00][sql] SELECT * FROM `iqc_note` WHERE `iqc` = 36 AND `tpl_raw_info` = 155 LIMIT 1 [ RunTime:0.000267s ] [2023-11-23T10:39:05+08:00][sql] INSERT INTO `iqc_note` SET `iqc` = 36 , `tpl_raw_info` = 155 , `qc_count` = '20' , `count` = '20' , `note` = '1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,' , `ng` = '0' , `create_time` = '2023-11-18' , `remark` = '' , `update_time` = '2023-11-23 10:39:05.720208' [ RunTime:0.000200s ] [2023-11-23T10:39:05+08:00][sql] SELECT * FROM `iqc_note` WHERE `iqc` = 36 AND `tpl_raw_info` = 153 LIMIT 1 [ RunTime:0.000270s ] [2023-11-23T10:39:05+08:00][sql] INSERT INTO `iqc_note` SET `iqc` = 36 , `tpl_raw_info` = 153 , `qc_count` = '20' , `count` = '20' , `note` = '1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,' , `ng` = '0' , `create_time` = '2023-11-18' , `remark` = '' , `update_time` = '2023-11-23 10:39:05.721118' [ RunTime:0.000187s ] [2023-11-23T10:39:05+08:00][sql] SELECT * FROM `iqc_note` WHERE `iqc` = 36 AND `tpl_raw_info` = 154 LIMIT 1 [ RunTime:0.000256s ] [2023-11-23T10:39:05+08:00][sql] INSERT INTO `iqc_note` SET `iqc` = 36 , `tpl_raw_info` = 154 , `qc_count` = '20' , `count` = '20' , `note` = '1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,' , `ng` = '0' , `create_time` = '2023-11-18' , `remark` = '' , `update_time` = '2023-11-23 10:39:05.721995' [ RunTime:0.000175s ] [2023-11-23T10:39:05+08:00][sql] SELECT * FROM `iqc` WHERE `an` = '37' AND `raw` = 13 LIMIT 1 [ RunTime:0.000226s ] [2023-11-23T10:39:05+08:00][sql] SELECT MAX(`number`) AS think_max FROM `iqc` WHERE `number` LIKE '20231118%' LIMIT 1 [ RunTime:0.000215s ] [2023-11-23T10:39:05+08:00][sql] SELECT `value` FROM `set` WHERE `field` = 'iqc_maker' LIMIT 1 [ RunTime:0.000204s ] [2023-11-23T10:39:05+08:00][sql] SELECT `value` FROM `set` WHERE `field` = 'iqc_maker' LIMIT 1 [ RunTime:0.000217s ] [2023-11-23T10:39:05+08:00][sql] SELECT `value` FROM `set` WHERE `field` = 'iqc_ratif' LIMIT 1 [ RunTime:0.000178s ] [2023-11-23T10:39:05+08:00][sql] INSERT INTO `iqc` SET `number` = '20231118002' , `an` = '37' , `raw` = 13 , `supplier` = 21 , `count` = '52.00' , `result` = '1' , `maker` = 李四 , `ratif` = 0 , `remark` = '' , `status` = 4 , `create_time` = '2023-11-18' , `update_time` = '2023-11-23 10:39:05.724064' [ RunTime:0.000203s ] [2023-11-23T10:39:05+08:00][sql] SELECT * FROM `tpl` WHERE `status` = 1 AND `tpl_sort` = '14' AND `sort` = 291 [ RunTime:0.000226s ] [2023-11-23T10:39:05+08:00][sql] SELECT * FROM `tpl_info` WHERE `tpl` = 11 ORDER BY `order` ASC [ RunTime:0.000318s ] [2023-11-23T10:39:05+08:00][sql] SELECT * FROM `iqc_note` WHERE `iqc` = 37 AND `tpl_raw_info` = 130 LIMIT 1 [ RunTime:0.000297s ] [2023-11-23T10:39:05+08:00][sql] INSERT INTO `iqc_note` SET `iqc` = 37 , `tpl_raw_info` = 130 , `qc_count` = '13' , `count` = '13' , `note` = '1,1,1,1,1,1,1,1,1,1,1,1,1,' , `ng` = '0' , `create_time` = '2023-11-18' , `remark` = '' , `update_time` = '2023-11-23 10:39:05.726179' [ RunTime:0.000235s ] [2023-11-23T10:39:05+08:00][sql] SELECT * FROM `iqc_note` WHERE `iqc` = 37 AND `tpl_raw_info` = 129 LIMIT 1 [ RunTime:0.000287s ] [2023-11-23T10:39:05+08:00][sql] INSERT INTO `iqc_note` SET `iqc` = 37 , `tpl_raw_info` = 129 , `qc_count` = '13' , `count` = '13' , `note` = '1,1,1,1,1,1,1,1,1,1,1,1,1,' , `ng` = '0' , `create_time` = '2023-11-18' , `remark` = '' , `update_time` = '2023-11-23 10:39:05.727122' [ RunTime:0.000183s ] [2023-11-23T10:39:05+08:00][sql] SELECT * FROM `iqc_note` WHERE `iqc` = 37 AND `tpl_raw_info` = 128 LIMIT 1 [ RunTime:0.000250s ] [2023-11-23T10:39:05+08:00][sql] INSERT INTO `iqc_note` SET `iqc` = 37 , `tpl_raw_info` = 128 , `qc_count` = '13' , `count` = '13' , `note` = '0.61,0.17,0.87,0.12,0.84,0.02,0.25,0.3,0.85,0.7,0.97,0.33,0.49,' , `ng` = '0' , `create_time` = '2023-11-18' , `remark` = '' , `update_time` = '2023-11-23 10:39:05.727982' [ RunTime:0.000175s ] [2023-11-23T10:39:05+08:00][sql] SELECT * FROM `iqc_note` WHERE `iqc` = 37 AND `tpl_raw_info` = 127 LIMIT 1 [ RunTime:0.000256s ] [2023-11-23T10:39:05+08:00][sql] INSERT INTO `iqc_note` SET `iqc` = 37 , `tpl_raw_info` = 127 , `qc_count` = '13' , `count` = '13' , `note` = '0.23,-0.03,-0.1,-0.07,-0.03,0.05,0.07,-0.2,-0.02,0.04,-0.11,-0.18,0.07,' , `ng` = '0' , `create_time` = '2023-11-18' , `remark` = '' , `update_time` = '2023-11-23 10:39:05.728837' [ RunTime:0.000184s ] [2023-11-23T10:39:05+08:00][sql] SELECT * FROM `iqc_note` WHERE `iqc` = 37 AND `tpl_raw_info` = 126 LIMIT 1 [ RunTime:0.000302s ] [2023-11-23T10:39:05+08:00][sql] INSERT INTO `iqc_note` SET `iqc` = 37 , `tpl_raw_info` = 126 , `qc_count` = '13' , `count` = '13' , `note` = '1,1,1,1,1,1,1,1,1,1,1,1,1,' , `ng` = '0' , `create_time` = '2023-11-18' , `remark` = '' , `update_time` = '2023-11-23 10:39:05.729713' [ RunTime:0.000184s ] [2023-11-23T10:39:05+08:00][sql] SELECT * FROM `iqc` WHERE `an` = '38' AND `raw` = 9 LIMIT 1 [ RunTime:0.000234s ] [2023-11-23T10:39:05+08:00][sql] SELECT MAX(`number`) AS think_max FROM `iqc` WHERE `number` LIKE '20231118%' LIMIT 1 [ RunTime:0.000238s ] [2023-11-23T10:39:05+08:00][sql] SELECT `value` FROM `set` WHERE `field` = 'iqc_maker' LIMIT 1 [ RunTime:0.000198s ] [2023-11-23T10:39:05+08:00][sql] SELECT `value` FROM `set` WHERE `field` = 'iqc_maker' LIMIT 1 [ RunTime:0.000192s ] [2023-11-23T10:39:05+08:00][sql] SELECT `value` FROM `set` WHERE `field` = 'iqc_ratif' LIMIT 1 [ RunTime:0.000189s ] [2023-11-23T10:39:05+08:00][sql] INSERT INTO `iqc` SET `number` = '20231118003' , `an` = '38' , `raw` = 9 , `supplier` = 28 , `count` = '10.00' , `result` = '1' , `maker` = 李四 , `ratif` = 0 , `remark` = '' , `status` = 4 , `create_time` = '2023-11-18' , `update_time` = '2023-11-23 10:39:05.731760' [ RunTime:0.000251s ] [2023-11-23T10:39:05+08:00][sql] SELECT * FROM `tpl` WHERE `status` = 1 AND `tpl_sort` = '14' AND `sort` = 443 [ RunTime:0.000569s ] [2023-11-23T10:39:05+08:00][sql] SELECT * FROM `tpl_info` WHERE `tpl` = 13 ORDER BY `order` ASC [ RunTime:0.000371s ] [2023-11-23T10:39:05+08:00][sql] SELECT * FROM `iqc_note` WHERE `iqc` = 38 AND `tpl_raw_info` = 152 LIMIT 1 [ RunTime:0.000372s ] [2023-11-23T10:39:05+08:00][sql] INSERT INTO `iqc_note` SET `iqc` = 38 , `tpl_raw_info` = 152 , `qc_count` = '3' , `count` = '3' , `note` = '-0.04,0.18,0.37,' , `ng` = '0' , `create_time` = '2023-11-18' , `remark` = '' , `update_time` = '2023-11-23 10:39:05.734631' [ RunTime:0.000191s ] [2023-11-23T10:39:05+08:00][sql] SELECT * FROM `iqc_note` WHERE `iqc` = 38 AND `tpl_raw_info` = 151 LIMIT 1 [ RunTime:0.000342s ] [2023-11-23T10:39:05+08:00][sql] INSERT INTO `iqc_note` SET `iqc` = 38 , `tpl_raw_info` = 151 , `qc_count` = '3' , `count` = '3' , `note` = '-1.66,-2.4,0.68,' , `ng` = '0' , `create_time` = '2023-11-18' , `remark` = '' , `update_time` = '2023-11-23 10:39:05.735598' [ RunTime:0.000183s ] [2023-11-23T10:39:05+08:00][sql] SELECT * FROM `iqc_note` WHERE `iqc` = 38 AND `tpl_raw_info` = 150 LIMIT 1 [ RunTime:0.000312s ] [2023-11-23T10:39:05+08:00][sql] INSERT INTO `iqc_note` SET `iqc` = 38 , `tpl_raw_info` = 150 , `qc_count` = '3' , `count` = '3' , `note` = '1.32,-2.09,1,' , `ng` = '0' , `create_time` = '2023-11-18' , `remark` = '' , `update_time` = '2023-11-23 10:39:05.736510' [ RunTime:0.000190s ] [2023-11-23T10:39:05+08:00][sql] SELECT * FROM `iqc_note` WHERE `iqc` = 38 AND `tpl_raw_info` = 149 LIMIT 1 [ RunTime:0.000344s ] [2023-11-23T10:39:05+08:00][sql] INSERT INTO `iqc_note` SET `iqc` = 38 , `tpl_raw_info` = 149 , `qc_count` = '3' , `count` = '3' , `note` = '1.55,2.06,2.56,' , `ng` = '0' , `create_time` = '2023-11-18' , `remark` = '' , `update_time` = '2023-11-23 10:39:05.737453' [ RunTime:0.000182s ] [2023-11-23T10:39:05+08:00][sql] SELECT * FROM `iqc_note` WHERE `iqc` = 38 AND `tpl_raw_info` = 148 LIMIT 1 [ RunTime:0.000273s ] [2023-11-23T10:39:05+08:00][sql] INSERT INTO `iqc_note` SET `iqc` = 38 , `tpl_raw_info` = 148 , `qc_count` = '3' , `count` = '3' , `note` = '1,1,1,' , `ng` = '0' , `create_time` = '2023-11-18' , `remark` = '' , `update_time` = '2023-11-23 10:39:05.738349' [ RunTime:0.000176s ] [2023-11-23T10:39:05+08:00][sql] SELECT * FROM `iqc_note` WHERE `iqc` = 38 AND `tpl_raw_info` = 147 LIMIT 1 [ RunTime:0.000281s ] [2023-11-23T10:39:05+08:00][sql] INSERT INTO `iqc_note` SET `iqc` = 38 , `tpl_raw_info` = 147 , `qc_count` = '3' , `count` = '3' , `note` = '1,1,1,' , `ng` = '0' , `create_time` = '2023-11-18' , `remark` = '' , `update_time` = '2023-11-23 10:39:05.739238' [ RunTime:0.000184s ] [2023-11-23T10:39:05+08:00][sql] SELECT * FROM `iqc_note` WHERE `iqc` = 38 AND `tpl_raw_info` = 146 LIMIT 1 [ RunTime:0.000258s ] [2023-11-23T10:39:05+08:00][sql] INSERT INTO `iqc_note` SET `iqc` = 38 , `tpl_raw_info` = 146 , `qc_count` = '3' , `count` = '3' , `note` = '1,1,1,' , `ng` = '0' , `create_time` = '2023-11-18' , `remark` = '' , `update_time` = '2023-11-23 10:39:05.740082' [ RunTime:0.000184s ] [2023-11-23T10:39:05+08:00][sql] SELECT * FROM `iqc_note` WHERE `iqc` = 38 AND `tpl_raw_info` = 145 LIMIT 1 [ RunTime:0.000269s ] [2023-11-23T10:39:05+08:00][sql] INSERT INTO `iqc_note` SET `iqc` = 38 , `tpl_raw_info` = 145 , `qc_count` = '3' , `count` = '3' , `note` = '1,1,1,' , `ng` = '0' , `create_time` = '2023-11-18' , `remark` = '' , `update_time` = '2023-11-23 10:39:05.740950' [ RunTime:0.000336s ] [2023-11-23T10:39:05+08:00][sql] SELECT * FROM `iqc_note` WHERE `iqc` = 38 AND `tpl_raw_info` = 144 LIMIT 1 [ RunTime:0.000275s ] [2023-11-23T10:39:05+08:00][sql] INSERT INTO `iqc_note` SET `iqc` = 38 , `tpl_raw_info` = 144 , `qc_count` = '3' , `count` = '3' , `note` = '1,1,1,' , `ng` = '0' , `create_time` = '2023-11-18' , `remark` = '' , `update_time` = '2023-11-23 10:39:05.741958' [ RunTime:0.000190s ] [2023-11-23T10:39:05+08:00][sql] SELECT * FROM `iqc_note` WHERE `iqc` = 38 AND `tpl_raw_info` = 143 LIMIT 1 [ RunTime:0.000286s ] [2023-11-23T10:39:05+08:00][sql] INSERT INTO `iqc_note` SET `iqc` = 38 , `tpl_raw_info` = 143 , `qc_count` = '3' , `count` = '3' , `note` = '1,1,1,' , `ng` = '0' , `create_time` = '2023-11-18' , `remark` = '' , `update_time` = '2023-11-23 10:39:05.742836' [ RunTime:0.000198s ] [2023-11-23T10:39:05+08:00][sql] SELECT * FROM `iqc_note` WHERE `iqc` = 38 AND `tpl_raw_info` = 142 LIMIT 1 [ RunTime:0.000288s ] [2023-11-23T10:39:05+08:00][sql] INSERT INTO `iqc_note` SET `iqc` = 38 , `tpl_raw_info` = 142 , `qc_count` = '3' , `count` = '3' , `note` = '1,1,1,' , `ng` = '0' , `create_time` = '2023-11-18' , `remark` = '' , `update_time` = '2023-11-23 10:39:05.743738' [ RunTime:0.000176s ] [2023-11-23T10:39:05+08:00][sql] SELECT * FROM `iqc_note` WHERE `iqc` = 38 AND `tpl_raw_info` = 141 LIMIT 1 [ RunTime:0.000266s ] [2023-11-23T10:39:05+08:00][sql] INSERT INTO `iqc_note` SET `iqc` = 38 , `tpl_raw_info` = 141 , `qc_count` = '3' , `count` = '3' , `note` = '1,1,1,' , `ng` = '0' , `create_time` = '2023-11-18' , `remark` = '' , `update_time` = '2023-11-23 10:39:05.744573' [ RunTime:0.000177s ] [2023-11-23T10:39:05+08:00][sql] SELECT * FROM `iqc` WHERE `an` = '39' AND `raw` = 8 LIMIT 1 [ RunTime:0.000218s ] [2023-11-23T10:39:05+08:00][sql] SELECT MAX(`number`) AS think_max FROM `iqc` WHERE `number` LIKE '20231118%' LIMIT 1 [ RunTime:0.000248s ] [2023-11-23T10:39:05+08:00][sql] SELECT `value` FROM `set` WHERE `field` = 'iqc_maker' LIMIT 1 [ RunTime:0.000201s ] [2023-11-23T10:39:05+08:00][sql] SELECT `value` FROM `set` WHERE `field` = 'iqc_maker' LIMIT 1 [ RunTime:0.000193s ] [2023-11-23T10:39:05+08:00][sql] SELECT `value` FROM `set` WHERE `field` = 'iqc_ratif' LIMIT 1 [ RunTime:0.000229s ] [2023-11-23T10:39:05+08:00][sql] INSERT INTO `iqc` SET `number` = '20231118004' , `an` = '39' , `raw` = 8 , `supplier` = 26 , `count` = '31.00' , `result` = '1' , `maker` = 李四 , `ratif` = 0 , `remark` = '' , `status` = 4 , `create_time` = '2023-11-18' , `update_time` = '2023-11-23 10:39:05.746719' [ RunTime:0.000215s ] [2023-11-23T10:39:05+08:00][sql] SELECT * FROM `tpl` WHERE `status` = 1 AND `tpl_sort` = '14' AND `sort` = 342 [ RunTime:0.000260s ] [2023-11-23T10:39:05+08:00][sql] SELECT * FROM `tpl_info` WHERE `tpl` = 12 ORDER BY `order` ASC [ RunTime:0.000372s ] [2023-11-23T10:39:05+08:00][sql] SELECT * FROM `iqc_note` WHERE `iqc` = 39 AND `tpl_raw_info` = 140 LIMIT 1 [ RunTime:0.000310s ] [2023-11-23T10:39:05+08:00][sql] INSERT INTO `iqc_note` SET `iqc` = 39 , `tpl_raw_info` = 140 , `qc_count` = '8' , `count` = '8' , `note` = '-7.13,4.57,4.95,-2.55,2.51,-5.64,4.19,-7.79,' , `ng` = '0' , `create_time` = '2023-11-18' , `remark` = '' , `update_time` = '2023-11-23 10:39:05.749086' [ RunTime:0.000198s ] [2023-11-23T10:39:05+08:00][sql] SELECT * FROM `iqc_note` WHERE `iqc` = 39 AND `tpl_raw_info` = 139 LIMIT 1 [ RunTime:0.000325s ] [2023-11-23T10:39:05+08:00][sql] INSERT INTO `iqc_note` SET `iqc` = 39 , `tpl_raw_info` = 139 , `qc_count` = '8' , `count` = '8' , `note` = '0.43,0.5,0.44,0.41,0.46,0.46,0.4,0.42,' , `ng` = '0' , `create_time` = '2023-11-18' , `remark` = '' , `update_time` = '2023-11-23 10:39:05.750089' [ RunTime:0.000193s ] [2023-11-23T10:39:05+08:00][sql] SELECT * FROM `iqc_note` WHERE `iqc` = 39 AND `tpl_raw_info` = 138 LIMIT 1 [ RunTime:0.000257s ] [2023-11-23T10:39:05+08:00][sql] INSERT INTO `iqc_note` SET `iqc` = 39 , `tpl_raw_info` = 138 , `qc_count` = '8' , `count` = '8' , `note` = '0.33,0.35,0.27,0.32,0.33,0.34,0.33,0.26,' , `ng` = '0' , `create_time` = '2023-11-18' , `remark` = '' , `update_time` = '2023-11-23 10:39:05.750971' [ RunTime:0.000183s ] [2023-11-23T10:39:05+08:00][sql] SELECT * FROM `iqc_note` WHERE `iqc` = 39 AND `tpl_raw_info` = 137 LIMIT 1 [ RunTime:0.000287s ] [2023-11-23T10:39:05+08:00][sql] INSERT INTO `iqc_note` SET `iqc` = 39 , `tpl_raw_info` = 137 , `qc_count` = '8' , `count` = '8' , `note` = '1.44,1.77,2.25,0.9,1.15,-0.71,2.17,1.11,' , `ng` = '0' , `create_time` = '2023-11-18' , `remark` = '' , `update_time` = '2023-11-23 10:39:05.751888' [ RunTime:0.000195s ] [2023-11-23T10:39:05+08:00][sql] SELECT * FROM `iqc_note` WHERE `iqc` = 39 AND `tpl_raw_info` = 136 LIMIT 1 [ RunTime:0.000271s ] [2023-11-23T10:39:05+08:00][sql] INSERT INTO `iqc_note` SET `iqc` = 39 , `tpl_raw_info` = 136 , `qc_count` = '8' , `count` = '8' , `note` = '-1.59,-0.72,1.28,0.25,-2.32,1.3,-2.83,0.11,' , `ng` = '0' , `create_time` = '2023-11-18' , `remark` = '' , `update_time` = '2023-11-23 10:39:05.752824' [ RunTime:0.000181s ] [2023-11-23T10:39:05+08:00][sql] SELECT * FROM `iqc_note` WHERE `iqc` = 39 AND `tpl_raw_info` = 135 LIMIT 1 [ RunTime:0.000273s ] [2023-11-23T10:39:05+08:00][sql] INSERT INTO `iqc_note` SET `iqc` = 39 , `tpl_raw_info` = 135 , `qc_count` = '8' , `count` = '8' , `note` = '-2.16,-1.27,-2.24,0.52,-1.63,0.33,-1.31,1.91,' , `ng` = '0' , `create_time` = '2023-11-18' , `remark` = '' , `update_time` = '2023-11-23 10:39:05.753690' [ RunTime:0.000191s ] [2023-11-23T10:39:05+08:00][sql] SELECT * FROM `iqc_note` WHERE `iqc` = 39 AND `tpl_raw_info` = 134 LIMIT 1 [ RunTime:0.000300s ] [2023-11-23T10:39:05+08:00][sql] INSERT INTO `iqc_note` SET `iqc` = 39 , `tpl_raw_info` = 134 , `qc_count` = '8' , `count` = '8' , `note` = '1,1,1,1,1,1,1,1,' , `ng` = '0' , `create_time` = '2023-11-18' , `remark` = '' , `update_time` = '2023-11-23 10:39:05.754590' [ RunTime:0.000203s ] [2023-11-23T10:39:05+08:00][sql] SELECT * FROM `iqc_note` WHERE `iqc` = 39 AND `tpl_raw_info` = 133 LIMIT 1 [ RunTime:0.000285s ] [2023-11-23T10:39:05+08:00][sql] INSERT INTO `iqc_note` SET `iqc` = 39 , `tpl_raw_info` = 133 , `qc_count` = '8' , `count` = '8' , `note` = '1,1,1,1,1,1,1,1,' , `ng` = '0' , `create_time` = '2023-11-18' , `remark` = '' , `update_time` = '2023-11-23 10:39:05.755496' [ RunTime:0.000175s ] [2023-11-23T10:39:05+08:00][sql] SELECT * FROM `iqc_note` WHERE `iqc` = 39 AND `tpl_raw_info` = 132 LIMIT 1 [ RunTime:0.000254s ] [2023-11-23T10:39:05+08:00][sql] INSERT INTO `iqc_note` SET `iqc` = 39 , `tpl_raw_info` = 132 , `qc_count` = '8' , `count` = '8' , `note` = '1,1,1,1,1,1,1,1,' , `ng` = '0' , `create_time` = '2023-11-18' , `remark` = '' , `update_time` = '2023-11-23 10:39:05.756328' [ RunTime:0.000175s ] [2023-11-23T10:39:05+08:00][sql] SELECT * FROM `iqc_note` WHERE `iqc` = 39 AND `tpl_raw_info` = 131 LIMIT 1 [ RunTime:0.000276s ] [2023-11-23T10:39:05+08:00][sql] INSERT INTO `iqc_note` SET `iqc` = 39 , `tpl_raw_info` = 131 , `qc_count` = '8' , `count` = '8' , `note` = '1.57,1.71,0.59,2.44,1.52,0.61,0.87,2.93,' , `ng` = '0' , `create_time` = '2023-11-18' , `remark` = '' , `update_time` = '2023-11-23 10:39:05.757186' [ RunTime:0.000208s ] [2023-11-23T10:39:05+08:00][sql] SELECT * FROM `iqc` WHERE `an` = '40' AND `raw` = 7 LIMIT 1 [ RunTime:0.000257s ] [2023-11-23T10:39:05+08:00][sql] SELECT MAX(`number`) AS think_max FROM `iqc` WHERE `number` LIKE '20231118%' LIMIT 1 [ RunTime:0.000243s ] [2023-11-23T10:39:05+08:00][sql] SELECT `value` FROM `set` WHERE `field` = 'iqc_maker' LIMIT 1 [ RunTime:0.000212s ] [2023-11-23T10:39:05+08:00][sql] SELECT `value` FROM `set` WHERE `field` = 'iqc_maker' LIMIT 1 [ RunTime:0.000211s ] [2023-11-23T10:39:05+08:00][sql] SELECT `value` FROM `set` WHERE `field` = 'iqc_ratif' LIMIT 1 [ RunTime:0.000180s ] [2023-11-23T10:39:05+08:00][sql] INSERT INTO `iqc` SET `number` = '20231118005' , `an` = '40' , `raw` = 7 , `supplier` = 25 , `count` = '10.00' , `result` = '1' , `maker` = 李四 , `ratif` = 0 , `remark` = '' , `status` = 4 , `create_time` = '2023-11-18' , `update_time` = '2023-11-23 10:39:05.759350' [ RunTime:0.000203s ] [2023-11-23T10:39:05+08:00][sql] SELECT * FROM `tpl` WHERE `status` = 1 AND `tpl_sort` = '14' AND `sort` = 133 [ RunTime:0.000222s ] [2023-11-23T10:39:05+08:00][sql] SELECT * FROM `tpl_info` WHERE `tpl` = 7 ORDER BY `order` ASC [ RunTime:0.000332s ] [2023-11-23T10:39:05+08:00][sql] SELECT * FROM `iqc_note` WHERE `iqc` = 40 AND `tpl_raw_info` = 105 LIMIT 1 [ RunTime:0.000302s ] [2023-11-23T10:39:05+08:00][sql] INSERT INTO `iqc_note` SET `iqc` = 40 , `tpl_raw_info` = 105 , `qc_count` = '3' , `count` = '3' , `note` = '1,1,1,' , `ng` = '0' , `create_time` = '2023-11-18' , `remark` = '' , `update_time` = '2023-11-23 10:39:05.761484' [ RunTime:0.000196s ] [2023-11-23T10:39:05+08:00][sql] SELECT * FROM `iqc_note` WHERE `iqc` = 40 AND `tpl_raw_info` = 104 LIMIT 1 [ RunTime:0.000292s ] [2023-11-23T10:39:05+08:00][sql] INSERT INTO `iqc_note` SET `iqc` = 40 , `tpl_raw_info` = 104 , `qc_count` = '3' , `count` = '3' , `note` = '1,1,1,' , `ng` = '0' , `create_time` = '2023-11-18' , `remark` = '' , `update_time` = '2023-11-23 10:39:05.762390' [ RunTime:0.000178s ] [2023-11-23T10:39:05+08:00][sql] SELECT * FROM `iqc_note` WHERE `iqc` = 40 AND `tpl_raw_info` = 103 LIMIT 1 [ RunTime:0.000255s ] [2023-11-23T10:39:05+08:00][sql] INSERT INTO `iqc_note` SET `iqc` = 40 , `tpl_raw_info` = 103 , `qc_count` = '3' , `count` = '3' , `note` = '1,1,1,' , `ng` = '0' , `create_time` = '2023-11-18' , `remark` = '' , `update_time` = '2023-11-23 10:39:05.763247' [ RunTime:0.000187s ] [2023-11-23T10:39:05+08:00][sql] SELECT * FROM `iqc_note` WHERE `iqc` = 40 AND `tpl_raw_info` = 102 LIMIT 1 [ RunTime:0.000267s ] [2023-11-23T10:39:05+08:00][sql] INSERT INTO `iqc_note` SET `iqc` = 40 , `tpl_raw_info` = 102 , `qc_count` = '3' , `count` = '3' , `note` = '1.47,1.28,0.78,' , `ng` = '0' , `create_time` = '2023-11-18' , `remark` = '' , `update_time` = '2023-11-23 10:39:05.764121' [ RunTime:0.000189s ] [2023-11-23T10:39:05+08:00][sql] SELECT * FROM `iqc_note` WHERE `iqc` = 40 AND `tpl_raw_info` = 101 LIMIT 1 [ RunTime:0.000357s ] [2023-11-23T10:39:05+08:00][sql] INSERT INTO `iqc_note` SET `iqc` = 40 , `tpl_raw_info` = 101 , `qc_count` = '3' , `count` = '3' , `note` = '0.03,1.21,0.11,' , `ng` = '0' , `create_time` = '2023-11-18' , `remark` = '' , `update_time` = '2023-11-23 10:39:05.765072' [ RunTime:0.000184s ] [2023-11-23T10:39:05+08:00][sql] SELECT * FROM `iqc_note` WHERE `iqc` = 40 AND `tpl_raw_info` = 100 LIMIT 1 [ RunTime:0.000278s ] [2023-11-23T10:39:05+08:00][sql] INSERT INTO `iqc_note` SET `iqc` = 40 , `tpl_raw_info` = 100 , `qc_count` = '3' , `count` = '3' , `note` = '1,1,1,' , `ng` = '0' , `create_time` = '2023-11-18' , `remark` = '' , `update_time` = '2023-11-23 10:39:05.765956' [ RunTime:0.000194s ] [2023-11-23T10:39:05+08:00][sql] SELECT * FROM `iqc` WHERE `an` = '41' AND `raw` = 3 LIMIT 1 [ RunTime:0.000262s ] [2023-11-23T10:39:05+08:00][sql] SELECT MAX(`number`) AS think_max FROM `iqc` WHERE `number` LIKE '20231118%' LIMIT 1 [ RunTime:0.000201s ] [2023-11-23T10:39:05+08:00][sql] SELECT `value` FROM `set` WHERE `field` = 'iqc_maker' LIMIT 1 [ RunTime:0.000210s ] [2023-11-23T10:39:05+08:00][sql] SELECT `value` FROM `set` WHERE `field` = 'iqc_maker' LIMIT 1 [ RunTime:0.000218s ] [2023-11-23T10:39:05+08:00][sql] SELECT `value` FROM `set` WHERE `field` = 'iqc_ratif' LIMIT 1 [ RunTime:0.000192s ] [2023-11-23T10:39:05+08:00][sql] INSERT INTO `iqc` SET `number` = '20231118006' , `an` = '41' , `raw` = 3 , `supplier` = 12 , `count` = '21.00' , `result` = '1' , `maker` = 李四 , `ratif` = 0 , `remark` = '' , `status` = 4 , `create_time` = '2023-11-18' , `update_time` = '2023-11-23 10:39:05.768088' [ RunTime:0.000221s ] [2023-11-23T10:39:05+08:00][sql] SELECT * FROM `tpl` WHERE `status` = 1 AND `tpl_sort` = '14' AND `sort` = 450 [ RunTime:0.000241s ] [2023-11-23T10:39:05+08:00][sql] SELECT * FROM `tpl_info` WHERE `tpl` = 6 ORDER BY `order` ASC [ RunTime:0.000338s ] [2023-11-23T10:39:05+08:00][sql] SELECT * FROM `iqc_note` WHERE `iqc` = 41 AND `tpl_raw_info` = 99 LIMIT 1 [ RunTime:0.000351s ] [2023-11-23T10:39:05+08:00][sql] INSERT INTO `iqc_note` SET `iqc` = 41 , `tpl_raw_info` = 99 , `qc_count` = '5' , `count` = '5' , `note` = '1,1,1,1,1,' , `ng` = '0' , `create_time` = '2023-11-18' , `remark` = '' , `update_time` = '2023-11-23 10:39:05.770330' [ RunTime:0.000245s ] [2023-11-23T10:39:05+08:00][sql] SELECT * FROM `iqc_note` WHERE `iqc` = 41 AND `tpl_raw_info` = 98 LIMIT 1 [ RunTime:0.000281s ] [2023-11-23T10:39:05+08:00][sql] INSERT INTO `iqc_note` SET `iqc` = 41 , `tpl_raw_info` = 98 , `qc_count` = '5' , `count` = '5' , `note` = '1.83,1.11,2.71,2.12,2.82,' , `ng` = '0' , `create_time` = '2023-11-18' , `remark` = '' , `update_time` = '2023-11-23 10:39:05.771302' [ RunTime:0.000199s ] [2023-11-23T10:39:05+08:00][sql] SELECT * FROM `iqc_note` WHERE `iqc` = 41 AND `tpl_raw_info` = 97 LIMIT 1 [ RunTime:0.000265s ] [2023-11-23T10:39:05+08:00][sql] INSERT INTO `iqc_note` SET `iqc` = 41 , `tpl_raw_info` = 97 , `qc_count` = '5' , `count` = '5' , `note` = '0.74,1.62,1.06,1.14,1.89,' , `ng` = '0' , `create_time` = '2023-11-18' , `remark` = '' , `update_time` = '2023-11-23 10:39:05.772184' [ RunTime:0.000222s ] [2023-11-23T10:39:05+08:00][sql] SELECT * FROM `iqc_note` WHERE `iqc` = 41 AND `tpl_raw_info` = 96 LIMIT 1 [ RunTime:0.000258s ] [2023-11-23T10:39:05+08:00][sql] INSERT INTO `iqc_note` SET `iqc` = 41 , `tpl_raw_info` = 96 , `qc_count` = '5' , `count` = '5' , `note` = '1.66,1.53,1.43,1.76,0.81,' , `ng` = '0' , `create_time` = '2023-11-18' , `remark` = '' , `update_time` = '2023-11-23 10:39:05.773076' [ RunTime:0.000176s ] [2023-11-23T10:39:05+08:00][sql] SELECT * FROM `iqc_note` WHERE `iqc` = 41 AND `tpl_raw_info` = 95 LIMIT 1 [ RunTime:0.000261s ] [2023-11-23T10:39:05+08:00][sql] INSERT INTO `iqc_note` SET `iqc` = 41 , `tpl_raw_info` = 95 , `qc_count` = '5' , `count` = '5' , `note` = '1,1,1,1,1,' , `ng` = '0' , `create_time` = '2023-11-18' , `remark` = '' , `update_time` = '2023-11-23 10:39:05.773923' [ RunTime:0.000205s ] [2023-11-23T10:39:05+08:00][sql] SELECT * FROM `iqc_note` WHERE `iqc` = 41 AND `tpl_raw_info` = 94 LIMIT 1 [ RunTime:0.000277s ] [2023-11-23T10:39:05+08:00][sql] INSERT INTO `iqc_note` SET `iqc` = 41 , `tpl_raw_info` = 94 , `qc_count` = '5' , `count` = '5' , `note` = '1,1,1,1,1,' , `ng` = '0' , `create_time` = '2023-11-18' , `remark` = '' , `update_time` = '2023-11-23 10:39:05.774817' [ RunTime:0.000195s ] [2023-11-23T10:39:05+08:00][sql] SELECT * FROM `iqc_note` WHERE `iqc` = 41 AND `tpl_raw_info` = 93 LIMIT 1 [ RunTime:0.000285s ] [2023-11-23T10:39:05+08:00][sql] INSERT INTO `iqc_note` SET `iqc` = 41 , `tpl_raw_info` = 93 , `qc_count` = '5' , `count` = '5' , `note` = '1,1,1,1,1,' , `ng` = '0' , `create_time` = '2023-11-18' , `remark` = '' , `update_time` = '2023-11-23 10:39:05.775682' [ RunTime:0.000174s ] [2023-11-23T10:39:05+08:00][sql] SELECT * FROM `iqc` WHERE `an` = '42' AND `raw` = 2 LIMIT 1 [ RunTime:0.000211s ] [2023-11-23T10:39:05+08:00][sql] SELECT MAX(`number`) AS think_max FROM `iqc` WHERE `number` LIKE '20231118%' LIMIT 1 [ RunTime:0.000213s ] [2023-11-23T10:39:05+08:00][sql] SELECT `value` FROM `set` WHERE `field` = 'iqc_maker' LIMIT 1 [ RunTime:0.000227s ] [2023-11-23T10:39:05+08:00][sql] SELECT `value` FROM `set` WHERE `field` = 'iqc_maker' LIMIT 1 [ RunTime:0.000214s ] [2023-11-23T10:39:05+08:00][sql] SELECT `value` FROM `set` WHERE `field` = 'iqc_ratif' LIMIT 1 [ RunTime:0.000249s ] [2023-11-23T10:39:05+08:00][sql] INSERT INTO `iqc` SET `number` = '20231118007' , `an` = '42' , `raw` = 2 , `supplier` = 12 , `count` = '21.00' , `result` = '1' , `maker` = 李四 , `ratif` = 0 , `remark` = '' , `status` = 4 , `create_time` = '2023-11-18' , `update_time` = '2023-11-23 10:39:05.777838' [ RunTime:0.000209s ] [2023-11-23T10:39:05+08:00][sql] SELECT * FROM `tpl` WHERE `status` = 1 AND `tpl_sort` = '14' AND `sort` = 450 [ RunTime:0.000247s ] [2023-11-23T10:39:05+08:00][sql] SELECT * FROM `tpl_info` WHERE `tpl` = 6 ORDER BY `order` ASC [ RunTime:0.000341s ] [2023-11-23T10:39:05+08:00][sql] SELECT * FROM `iqc_note` WHERE `iqc` = 42 AND `tpl_raw_info` = 99 LIMIT 1 [ RunTime:0.000339s ] [2023-11-23T10:39:05+08:00][sql] INSERT INTO `iqc_note` SET `iqc` = 42 , `tpl_raw_info` = 99 , `qc_count` = '5' , `count` = '5' , `note` = '1,1,1,1,1,' , `ng` = '0' , `create_time` = '2023-11-18' , `remark` = '' , `update_time` = '2023-11-23 10:39:05.780074' [ RunTime:0.000219s ] [2023-11-23T10:39:05+08:00][sql] SELECT * FROM `iqc_note` WHERE `iqc` = 42 AND `tpl_raw_info` = 98 LIMIT 1 [ RunTime:0.000293s ] [2023-11-23T10:39:05+08:00][sql] INSERT INTO `iqc_note` SET `iqc` = 42 , `tpl_raw_info` = 98 , `qc_count` = '5' , `count` = '5' , `note` = '2.05,2.09,2.25,1.77,1,' , `ng` = '0' , `create_time` = '2023-11-18' , `remark` = '' , `update_time` = '2023-11-23 10:39:05.781034' [ RunTime:0.000223s ] [2023-11-23T10:39:05+08:00][sql] SELECT * FROM `iqc_note` WHERE `iqc` = 42 AND `tpl_raw_info` = 97 LIMIT 1 [ RunTime:0.000267s ] [2023-11-23T10:39:05+08:00][sql] INSERT INTO `iqc_note` SET `iqc` = 42 , `tpl_raw_info` = 97 , `qc_count` = '5' , `count` = '5' , `note` = '1.7,0.77,0.81,0.5,0.71,' , `ng` = '0' , `create_time` = '2023-11-18' , `remark` = '' , `update_time` = '2023-11-23 10:39:05.781947' [ RunTime:0.000178s ] [2023-11-23T10:39:05+08:00][sql] SELECT * FROM `iqc_note` WHERE `iqc` = 42 AND `tpl_raw_info` = 96 LIMIT 1 [ RunTime:0.000287s ] [2023-11-23T10:39:05+08:00][sql] INSERT INTO `iqc_note` SET `iqc` = 42 , `tpl_raw_info` = 96 , `qc_count` = '5' , `count` = '5' , `note` = '1.12,1.94,1.33,0.56,0.84,' , `ng` = '0' , `create_time` = '2023-11-18' , `remark` = '' , `update_time` = '2023-11-23 10:39:05.782875' [ RunTime:0.000176s ] [2023-11-23T10:39:05+08:00][sql] SELECT * FROM `iqc_note` WHERE `iqc` = 42 AND `tpl_raw_info` = 95 LIMIT 1 [ RunTime:0.000453s ] [2023-11-23T10:39:05+08:00][sql] INSERT INTO `iqc_note` SET `iqc` = 42 , `tpl_raw_info` = 95 , `qc_count` = '5' , `count` = '5' , `note` = '1,1,1,1,1,' , `ng` = '0' , `create_time` = '2023-11-18' , `remark` = '' , `update_time` = '2023-11-23 10:39:05.783953' [ RunTime:0.000209s ] [2023-11-23T10:39:05+08:00][sql] SELECT * FROM `iqc_note` WHERE `iqc` = 42 AND `tpl_raw_info` = 94 LIMIT 1 [ RunTime:0.000268s ] [2023-11-23T10:39:05+08:00][sql] INSERT INTO `iqc_note` SET `iqc` = 42 , `tpl_raw_info` = 94 , `qc_count` = '5' , `count` = '5' , `note` = '1,1,1,1,1,' , `ng` = '0' , `create_time` = '2023-11-18' , `remark` = '' , `update_time` = '2023-11-23 10:39:05.784850' [ RunTime:0.000198s ] [2023-11-23T10:39:05+08:00][sql] SELECT * FROM `iqc_note` WHERE `iqc` = 42 AND `tpl_raw_info` = 93 LIMIT 1 [ RunTime:0.000285s ] [2023-11-23T10:39:05+08:00][sql] INSERT INTO `iqc_note` SET `iqc` = 42 , `tpl_raw_info` = 93 , `qc_count` = '5' , `count` = '5' , `note` = '1,1,1,1,1,' , `ng` = '0' , `create_time` = '2023-11-18' , `remark` = '' , `update_time` = '2023-11-23 10:39:05.785744' [ RunTime:0.000177s ] [2023-11-23T10:39:05+08:00][sql] SELECT * FROM `iqc` WHERE `an` = '43' AND `raw` = 1 LIMIT 1 [ RunTime:0.000241s ] [2023-11-23T10:39:05+08:00][sql] SELECT MAX(`number`) AS think_max FROM `iqc` WHERE `number` LIKE '20231118%' LIMIT 1 [ RunTime:0.000249s ] [2023-11-23T10:39:05+08:00][sql] SELECT `value` FROM `set` WHERE `field` = 'iqc_maker' LIMIT 1 [ RunTime:0.000215s ] [2023-11-23T10:39:05+08:00][sql] SELECT `value` FROM `set` WHERE `field` = 'iqc_maker' LIMIT 1 [ RunTime:0.000211s ] [2023-11-23T10:39:05+08:00][sql] SELECT `value` FROM `set` WHERE `field` = 'iqc_ratif' LIMIT 1 [ RunTime:0.000180s ] [2023-11-23T10:39:05+08:00][sql] INSERT INTO `iqc` SET `number` = '20231118008' , `an` = '43' , `raw` = 1 , `supplier` = 24 , `count` = '42.00' , `result` = '1' , `maker` = 李四 , `ratif` = 0 , `remark` = '' , `status` = 4 , `create_time` = '2023-11-18' , `update_time` = '2023-11-23 10:39:05.787845' [ RunTime:0.000191s ] [2023-11-23T10:39:05+08:00][sql] SELECT * FROM `tpl` WHERE `status` = 1 AND `tpl_sort` = '14' AND `sort` = 137 [ RunTime:0.000236s ] [2023-11-23T10:39:05+08:00][sql] SELECT * FROM `tpl_info` WHERE `tpl` = 9 ORDER BY `order` ASC [ RunTime:0.000326s ] [2023-11-23T10:39:05+08:00][sql] SELECT * FROM `iqc_note` WHERE `iqc` = 43 AND `tpl_raw_info` = 117 LIMIT 1 [ RunTime:0.000311s ] [2023-11-23T10:39:05+08:00][sql] INSERT INTO `iqc_note` SET `iqc` = 43 , `tpl_raw_info` = 117 , `qc_count` = '8' , `count` = '8' , `note` = '1,1,1,1,1,1,1,1,' , `ng` = '0' , `create_time` = '2023-11-18' , `remark` = '' , `update_time` = '2023-11-23 10:39:05.790043' [ RunTime:0.000195s ] [2023-11-23T10:39:05+08:00][sql] SELECT * FROM `iqc_note` WHERE `iqc` = 43 AND `tpl_raw_info` = 116 LIMIT 1 [ RunTime:0.000284s ] [2023-11-23T10:39:05+08:00][sql] INSERT INTO `iqc_note` SET `iqc` = 43 , `tpl_raw_info` = 116 , `qc_count` = '8' , `count` = '8' , `note` = '3.02,3.09,3.06,3.02,3.08,3.1,3.06,3.1,' , `ng` = '0' , `create_time` = '2023-11-18' , `remark` = '' , `update_time` = '2023-11-23 10:39:05.790978' [ RunTime:0.000199s ] [2023-11-23T10:39:05+08:00][sql] SELECT * FROM `iqc_note` WHERE `iqc` = 43 AND `tpl_raw_info` = 115 LIMIT 1 [ RunTime:0.000279s ] [2023-11-23T10:39:05+08:00][sql] INSERT INTO `iqc_note` SET `iqc` = 43 , `tpl_raw_info` = 115 , `qc_count` = '8' , `count` = '8' , `note` = '0.24,0.14,0.47,0.19,-0.38,0.24,0.06,0.42,' , `ng` = '0' , `create_time` = '2023-11-18' , `remark` = '' , `update_time` = '2023-11-23 10:39:05.791861' [ RunTime:0.000188s ] [2023-11-23T10:39:05+08:00][sql] SELECT * FROM `iqc_note` WHERE `iqc` = 43 AND `tpl_raw_info` = 114 LIMIT 1 [ RunTime:0.000286s ] [2023-11-23T10:39:05+08:00][sql] INSERT INTO `iqc_note` SET `iqc` = 43 , `tpl_raw_info` = 114 , `qc_count` = '8' , `count` = '8' , `note` = '-0.2,-0.16,-0.03,0.19,-0.14,-0.08,-0.22,0.29,' , `ng` = '0' , `create_time` = '2023-11-18' , `remark` = '' , `update_time` = '2023-11-23 10:39:05.792752' [ RunTime:0.000190s ] [2023-11-23T10:39:05+08:00][sql] SELECT * FROM `iqc_note` WHERE `iqc` = 43 AND `tpl_raw_info` = 113 LIMIT 1 [ RunTime:0.000279s ] [2023-11-23T10:39:05+08:00][sql] INSERT INTO `iqc_note` SET `iqc` = 43 , `tpl_raw_info` = 113 , `qc_count` = '8' , `count` = '8' , `note` = '0.99,0.36,1.76,0.43,0.71,1.93,1.06,0.51,' , `ng` = '0' , `create_time` = '2023-11-18' , `remark` = '' , `update_time` = '2023-11-23 10:39:05.793630' [ RunTime:0.000174s ] [2023-11-23T10:39:05+08:00][sql] SELECT * FROM `iqc_note` WHERE `iqc` = 43 AND `tpl_raw_info` = 112 LIMIT 1 [ RunTime:0.000268s ] [2023-11-23T10:39:05+08:00][sql] INSERT INTO `iqc_note` SET `iqc` = 43 , `tpl_raw_info` = 112 , `qc_count` = '8' , `count` = '8' , `note` = '-0.23,-0.34,-0.48,0.26,-0.07,0.2,0.32,0.05,' , `ng` = '0' , `create_time` = '2023-11-18' , `remark` = '' , `update_time` = '2023-11-23 10:39:05.794489' [ RunTime:0.000249s ] [2023-11-23T10:39:05+08:00][sql] SELECT * FROM `iqc_note` WHERE `iqc` = 43 AND `tpl_raw_info` = 111 LIMIT 1 [ RunTime:0.000278s ] [2023-11-23T10:39:05+08:00][sql] INSERT INTO `iqc_note` SET `iqc` = 43 , `tpl_raw_info` = 111 , `qc_count` = '8' , `count` = '8' , `note` = '1,1,1,1,1,1,1,1,' , `ng` = '0' , `create_time` = '2023-11-18' , `remark` = '' , `update_time` = '2023-11-23 10:39:05.795415' [ RunTime:0.000217s ] [2023-11-23T10:39:05+08:00][sql] SELECT * FROM `iqc_note` WHERE `iqc` = 43 AND `tpl_raw_info` = 110 LIMIT 1 [ RunTime:0.000271s ] [2023-11-23T10:39:05+08:00][sql] INSERT INTO `iqc_note` SET `iqc` = 43 , `tpl_raw_info` = 110 , `qc_count` = '8' , `count` = '8' , `note` = '1,1,1,1,1,1,1,1,' , `ng` = '0' , `create_time` = '2023-11-18' , `remark` = '' , `update_time` = '2023-11-23 10:39:05.796300' [ RunTime:0.000195s ] [2023-11-23T10:39:05+08:00][sql] CONNECT:[ UseTime:0.014638s ] mysql:host=127.0.0.1;port=3306;dbname=hzjiudingwang;charset=utf8 [2023-11-23T10:39:05+08:00][sql] SHOW FULL COLUMNS FROM `set` [ RunTime:0.000739s ] [2023-11-23T10:39:05+08:00][sql] UPDATE `set` SET `value` = 'hzjiudingwang' WHERE `field` = 'database' [ RunTime:0.000307s ] [2023-11-23T10:39:05+08:00][sql] UPDATE `set` SET `value` = '惠州市九鼎旺门窗有限公司' WHERE `field` = 'title' [ RunTime:0.000231s ] [2023-11-23T10:39:05+08:00][sql] UPDATE `set` SET `value` = '93,90,92' WHERE `field` = 'product_sort' [ RunTime:0.000197s ] [2023-11-23T10:39:05+08:00][sql] SHOW FULL COLUMNS FROM `an` [ RunTime:0.000805s ] [2023-11-23T10:39:05+08:00][sql] SELECT * FROM `an` WHERE `id` IN (36,37,38,39,40,41,42,43) [ RunTime:0.000351s ] [2023-11-23T10:39:05+08:00][sql] SHOW FULL COLUMNS FROM `iqc` [ RunTime:0.008384s ] [2023-11-23T10:39:05+08:00][sql] SELECT * FROM `iqc` WHERE `an` IN ('36','37','38','39','40','41','42','43') [ RunTime:0.000410s ] [2023-11-23T10:39:05+08:00][sql] SELECT `value` FROM `set` WHERE `field` = 'pass_man' LIMIT 1 [ RunTime:0.000331s ] [2023-11-23T10:39:05+08:00][sql] SELECT `value` FROM `set` WHERE `field` = 'put_man' LIMIT 1 [ RunTime:0.000239s ] [2023-11-23T10:39:05+08:00][sql] SHOW FULL COLUMNS FROM `in` [ RunTime:0.007424s ] [2023-11-23T10:39:05+08:00][sql] SELECT * FROM `in` WHERE `raw` = 21 AND `an` = 36 LIMIT 1 [ RunTime:0.000381s ] [2023-11-23T10:39:05+08:00][sql] SELECT MAX(`number`) AS think_max FROM `in` WHERE `number` LIKE '20231117%' LIMIT 1 [ RunTime:0.000265s ] [2023-11-23T10:39:05+08:00][sql] INSERT INTO `in` SET `number` = '20231117001' , `raw` = 21 , `count` = 105.00 , `supplier` = 14 , `an` = 36 , `po` = 36 , `iqc` = 36 , `create_time` = '2023-11-18 00:00:00' , `pass_man` = 0 , `put_man` = 0 , `update_time` = '2023-11-23 10:39:05.920633' [ RunTime:0.000231s ] [2023-11-23T10:39:05+08:00][sql] SELECT * FROM `in` WHERE `raw` = 13 AND `an` = 37 LIMIT 1 [ RunTime:0.000240s ] [2023-11-23T10:39:05+08:00][sql] SELECT MAX(`number`) AS think_max FROM `in` WHERE `number` LIKE '20231117%' LIMIT 1 [ RunTime:0.000257s ] [2023-11-23T10:39:05+08:00][sql] INSERT INTO `in` SET `number` = '20231117002' , `raw` = 13 , `count` = 52.00 , `supplier` = 21 , `an` = 37 , `po` = 37 , `iqc` = 37 , `create_time` = '2023-11-18 00:00:00' , `pass_man` = 0 , `put_man` = 0 , `update_time` = '2023-11-23 10:39:05.922046' [ RunTime:0.000262s ] [2023-11-23T10:39:05+08:00][sql] SELECT * FROM `in` WHERE `raw` = 9 AND `an` = 38 LIMIT 1 [ RunTime:0.000219s ] [2023-11-23T10:39:05+08:00][sql] SELECT MAX(`number`) AS think_max FROM `in` WHERE `number` LIKE '20231117%' LIMIT 1 [ RunTime:0.000223s ] [2023-11-23T10:39:05+08:00][sql] INSERT INTO `in` SET `number` = '20231117003' , `raw` = 9 , `count` = 10.00 , `supplier` = 28 , `an` = 38 , `po` = 38 , `iqc` = 38 , `create_time` = '2023-11-18 00:00:00' , `pass_man` = 0 , `put_man` = 0 , `update_time` = '2023-11-23 10:39:05.923551' [ RunTime:0.000215s ] [2023-11-23T10:39:05+08:00][sql] SELECT * FROM `in` WHERE `raw` = 8 AND `an` = 39 LIMIT 1 [ RunTime:0.000248s ] [2023-11-23T10:39:05+08:00][sql] SELECT MAX(`number`) AS think_max FROM `in` WHERE `number` LIKE '20231117%' LIMIT 1 [ RunTime:0.000221s ] [2023-11-23T10:39:05+08:00][sql] INSERT INTO `in` SET `number` = '20231117004' , `raw` = 8 , `count` = 31.00 , `supplier` = 26 , `an` = 39 , `po` = 39 , `iqc` = 39 , `create_time` = '2023-11-18 00:00:00' , `pass_man` = 0 , `put_man` = 0 , `update_time` = '2023-11-23 10:39:05.924837' [ RunTime:0.000182s ] [2023-11-23T10:39:05+08:00][sql] SELECT * FROM `in` WHERE `raw` = 7 AND `an` = 40 LIMIT 1 [ RunTime:0.000248s ] [2023-11-23T10:39:05+08:00][sql] SELECT MAX(`number`) AS think_max FROM `in` WHERE `number` LIKE '20231117%' LIMIT 1 [ RunTime:0.000202s ] [2023-11-23T10:39:05+08:00][sql] INSERT INTO `in` SET `number` = '20231117005' , `raw` = 7 , `count` = 10.00 , `supplier` = 25 , `an` = 40 , `po` = 40 , `iqc` = 40 , `create_time` = '2023-11-18 00:00:00' , `pass_man` = 0 , `put_man` = 0 , `update_time` = '2023-11-23 10:39:05.926036' [ RunTime:0.000183s ] [2023-11-23T10:39:05+08:00][sql] SELECT * FROM `in` WHERE `raw` = 3 AND `an` = 41 LIMIT 1 [ RunTime:0.000268s ] [2023-11-23T10:39:05+08:00][sql] SELECT MAX(`number`) AS think_max FROM `in` WHERE `number` LIKE '20231117%' LIMIT 1 [ RunTime:0.000224s ] [2023-11-23T10:39:05+08:00][sql] INSERT INTO `in` SET `number` = '20231117006' , `raw` = 3 , `count` = 21.00 , `supplier` = 12 , `an` = 41 , `po` = 41 , `iqc` = 41 , `create_time` = '2023-11-18 00:00:00' , `pass_man` = 0 , `put_man` = 0 , `update_time` = '2023-11-23 10:39:05.927264' [ RunTime:0.000254s ] [2023-11-23T10:39:05+08:00][sql] SELECT * FROM `in` WHERE `raw` = 2 AND `an` = 42 LIMIT 1 [ RunTime:0.000214s ] [2023-11-23T10:39:05+08:00][sql] SELECT MAX(`number`) AS think_max FROM `in` WHERE `number` LIKE '20231117%' LIMIT 1 [ RunTime:0.000198s ] [2023-11-23T10:39:05+08:00][sql] INSERT INTO `in` SET `number` = '20231117007' , `raw` = 2 , `count` = 21.00 , `supplier` = 12 , `an` = 42 , `po` = 42 , `iqc` = 42 , `create_time` = '2023-11-18 00:00:00' , `pass_man` = 0 , `put_man` = 0 , `update_time` = '2023-11-23 10:39:05.928477' [ RunTime:0.000182s ] [2023-11-23T10:39:05+08:00][sql] SELECT * FROM `in` WHERE `raw` = 1 AND `an` = 43 LIMIT 1 [ RunTime:0.000215s ] [2023-11-23T10:39:05+08:00][sql] SELECT MAX(`number`) AS think_max FROM `in` WHERE `number` LIKE '20231117%' LIMIT 1 [ RunTime:0.000208s ] [2023-11-23T10:39:05+08:00][sql] INSERT INTO `in` SET `number` = '20231117008' , `raw` = 1 , `count` = 42.00 , `supplier` = 24 , `an` = 43 , `po` = 43 , `iqc` = 43 , `create_time` = '2023-11-18 00:00:00' , `pass_man` = 0 , `put_man` = 0 , `update_time` = '2023-11-23 10:39:05.929655' [ RunTime:0.000178s ] [2023-11-23T10:39:06+08:00][sql] CONNECT:[ UseTime:0.002273s ] mysql:host=127.0.0.1;port=3306;dbname=hzjiudingwang;charset=utf8 [2023-11-23T10:39:06+08:00][sql] SHOW FULL COLUMNS FROM `set` [ RunTime:0.000699s ] [2023-11-23T10:39:06+08:00][sql] UPDATE `set` SET `value` = 'hzjiudingwang' WHERE `field` = 'database' [ RunTime:0.000348s ] [2023-11-23T10:39:06+08:00][sql] UPDATE `set` SET `value` = '惠州市九鼎旺门窗有限公司' WHERE `field` = 'title' [ RunTime:0.000208s ] [2023-11-23T10:39:06+08:00][sql] UPDATE `set` SET `value` = '93,90,92' WHERE `field` = 'product_sort' [ RunTime:0.000202s ] [2023-11-23T10:39:06+08:00][sql] SHOW FULL COLUMNS FROM `pp` [ RunTime:0.000559s ] [2023-11-23T10:39:06+08:00][sql] SELECT * FROM `pp` WHERE `id` = 59 [ RunTime:0.000262s ] [2023-11-23T10:39:06+08:00][sql] SHOW FULL COLUMNS FROM `in` [ RunTime:0.006483s ] [2023-11-23T10:39:06+08:00][sql] SELECT MIN(`create_time`) AS think_min FROM `in` WHERE `id` IN (36,37,38,39,40,41,42,43) LIMIT 1 [ RunTime:0.000392s ] [2023-11-23T10:39:06+08:00][sql] SELECT `value` FROM `set` WHERE `field` = 'mo_maker' LIMIT 1 [ RunTime:0.000276s ] [2023-11-23T10:39:06+08:00][sql] SELECT `value` FROM `set` WHERE `field` = 'mo_ratif' LIMIT 1 [ RunTime:0.000216s ] [2023-11-23T10:39:06+08:00][sql] SHOW FULL COLUMNS FROM `mo` [ RunTime:0.007409s ] [2023-11-23T10:39:06+08:00][sql] SELECT * FROM `mo` WHERE `product` = 3 AND `pp` = '59' LIMIT 1 [ RunTime:0.000424s ] [2023-11-23T10:39:06+08:00][sql] SELECT MAX(`number`) AS think_max FROM `mo` WHERE `number` LIKE '20231119%' LIMIT 1 [ RunTime:0.000345s ] [2023-11-23T10:39:06+08:00][sql] INSERT INTO `mo` SET `number` = '20231119001' , `status` = 11 , `product` = 3 , `count` = 10 , `plan_count` = 10 , `pmr_step` = 0 , `cpp_step` = 0 , `mo_step` = 0 , `remark` = '' , `create_time` = '2023-11-19' , `so` = '23' , `pp` = '59' , `cpp_status` = 2 , `pqc_status` = 2 , `fqc_status` = 2 , `oqc_status` = 2 , `end_count` = 10 , `maker` = 0 , `ratif` = 0 , `update_time` = '2023-11-23 10:39:06.039789' [ RunTime:0.000307s ] [2023-11-23T10:39:06+08:00][sql] CONNECT:[ UseTime:0.004776s ] mysql:host=127.0.0.1;port=3306;dbname=hzjiudingwang;charset=utf8 [2023-11-23T10:39:06+08:00][sql] SHOW FULL COLUMNS FROM `set` [ RunTime:0.000842s ] [2023-11-23T10:39:06+08:00][sql] UPDATE `set` SET `value` = 'hzjiudingwang' WHERE `field` = 'database' [ RunTime:0.000301s ] [2023-11-23T10:39:06+08:00][sql] UPDATE `set` SET `value` = '惠州市九鼎旺门窗有限公司' WHERE `field` = 'title' [ RunTime:0.000301s ] [2023-11-23T10:39:06+08:00][sql] UPDATE `set` SET `value` = '93,90,92' WHERE `field` = 'product_sort' [ RunTime:0.000189s ] [2023-11-23T10:39:06+08:00][sql] SHOW FULL COLUMNS FROM `mo` [ RunTime:0.007302s ] [2023-11-23T10:39:06+08:00][sql] SELECT * FROM `mo` WHERE `id` = 39 [ RunTime:0.000401s ] [2023-11-23T10:39:06+08:00][sql] SELECT `value` FROM `set` WHERE `field` = 'raw_man' LIMIT 1 [ RunTime:0.000403s ] [2023-11-23T10:39:06+08:00][sql] SELECT `value` FROM `set` WHERE `field` = 'put_man' LIMIT 1 [ RunTime:0.000209s ] [2023-11-23T10:39:06+08:00][sql] SHOW FULL COLUMNS FROM `sp` [ RunTime:0.022310s ] [2023-11-23T10:39:06+08:00][sql] SELECT * FROM `sp` WHERE `mo` = 39 AND `product` = 3 LIMIT 1 [ RunTime:0.000408s ] [2023-11-23T10:39:06+08:00][sql] INSERT INTO `sp` SET `mo` = 39 , `product` = 3 , `status` = 2 , `raw_man` = 0 , `create_time` = '2023-11-19 00:00:00' , `put_man` = 0 , `update_time` = '2023-11-23 10:39:06.165263' [ RunTime:0.000260s ] [2023-11-23T10:39:06+08:00][sql] SHOW FULL COLUMNS FROM `bom` [ RunTime:0.000767s ] [2023-11-23T10:39:06+08:00][sql] SELECT * FROM `bom` WHERE `product` = 3 LIMIT 1 [ RunTime:0.000250s ] [2023-11-23T10:39:06+08:00][sql] SHOW FULL COLUMNS FROM `bom_info` [ RunTime:0.000719s ] [2023-11-23T10:39:06+08:00][sql] SELECT * FROM `bom_info` WHERE `bom` = 1 [ RunTime:0.000281s ] [2023-11-23T10:39:06+08:00][sql] SHOW FULL COLUMNS FROM `out` [ RunTime:0.014519s ] [2023-11-23T10:39:06+08:00][sql] SELECT * FROM `out` WHERE `sp` = 39 AND `raw` = 21 LIMIT 1 [ RunTime:0.000466s ] [2023-11-23T10:39:06+08:00][sql] INSERT INTO `out` SET `sp` = 39 , `raw` = 21 , `supplier` = NULL , `count` = '100' , `out_count` = '100' , `unit` = '' , `status` = 1 , `create_time` = '2023-11-19 00:00:00' , `out_time` = NULL , `put_man` = 0 , `update_time` = '2023-11-23 10:39:06.201339' [ RunTime:0.000271s ] [2023-11-23T10:39:06+08:00][sql] SELECT * FROM `out` WHERE `sp` = 39 AND `raw` = 13 LIMIT 1 [ RunTime:0.000305s ] [2023-11-23T10:39:06+08:00][sql] INSERT INTO `out` SET `sp` = 39 , `raw` = 13 , `supplier` = NULL , `count` = '50' , `out_count` = '50' , `unit` = '' , `status` = 1 , `create_time` = '2023-11-19 00:00:00' , `out_time` = NULL , `put_man` = 0 , `update_time` = '2023-11-23 10:39:06.202506' [ RunTime:0.000218s ] [2023-11-23T10:39:06+08:00][sql] SELECT * FROM `out` WHERE `sp` = 39 AND `raw` = 9 LIMIT 1 [ RunTime:0.000287s ] [2023-11-23T10:39:06+08:00][sql] INSERT INTO `out` SET `sp` = 39 , `raw` = 9 , `supplier` = NULL , `count` = '10' , `out_count` = '10' , `unit` = '' , `status` = 1 , `create_time` = '2023-11-19 00:00:00' , `out_time` = NULL , `put_man` = 0 , `update_time` = '2023-11-23 10:39:06.203491' [ RunTime:0.000210s ] [2023-11-23T10:39:06+08:00][sql] SELECT * FROM `out` WHERE `sp` = 39 AND `raw` = 8 LIMIT 1 [ RunTime:0.000282s ] [2023-11-23T10:39:06+08:00][sql] INSERT INTO `out` SET `sp` = 39 , `raw` = 8 , `supplier` = NULL , `count` = '30' , `out_count` = '30' , `unit` = '' , `status` = 1 , `create_time` = '2023-11-19 00:00:00' , `out_time` = NULL , `put_man` = 0 , `update_time` = '2023-11-23 10:39:06.204426' [ RunTime:0.000183s ] [2023-11-23T10:39:06+08:00][sql] SELECT * FROM `out` WHERE `sp` = 39 AND `raw` = 7 LIMIT 1 [ RunTime:0.000262s ] [2023-11-23T10:39:06+08:00][sql] INSERT INTO `out` SET `sp` = 39 , `raw` = 7 , `supplier` = NULL , `count` = '10' , `out_count` = '10' , `unit` = '' , `status` = 1 , `create_time` = '2023-11-19 00:00:00' , `out_time` = NULL , `put_man` = 0 , `update_time` = '2023-11-23 10:39:06.205352' [ RunTime:0.000181s ] [2023-11-23T10:39:06+08:00][sql] SELECT * FROM `out` WHERE `sp` = 39 AND `raw` = 3 LIMIT 1 [ RunTime:0.000258s ] [2023-11-23T10:39:06+08:00][sql] INSERT INTO `out` SET `sp` = 39 , `raw` = 3 , `supplier` = NULL , `count` = '20' , `out_count` = '20' , `unit` = '' , `status` = 1 , `create_time` = '2023-11-19 00:00:00' , `out_time` = NULL , `put_man` = 0 , `update_time` = '2023-11-23 10:39:06.206250' [ RunTime:0.000197s ] [2023-11-23T10:39:06+08:00][sql] SELECT * FROM `out` WHERE `sp` = 39 AND `raw` = 2 LIMIT 1 [ RunTime:0.000333s ] [2023-11-23T10:39:06+08:00][sql] INSERT INTO `out` SET `sp` = 39 , `raw` = 2 , `supplier` = NULL , `count` = '20' , `out_count` = '20' , `unit` = '' , `status` = 1 , `create_time` = '2023-11-19 00:00:00' , `out_time` = NULL , `put_man` = 0 , `update_time` = '2023-11-23 10:39:06.207232' [ RunTime:0.000221s ] [2023-11-23T10:39:06+08:00][sql] SELECT * FROM `out` WHERE `sp` = 39 AND `raw` = 1 LIMIT 1 [ RunTime:0.000287s ] [2023-11-23T10:39:06+08:00][sql] INSERT INTO `out` SET `sp` = 39 , `raw` = 1 , `supplier` = NULL , `count` = '40' , `out_count` = '40' , `unit` = '' , `status` = 1 , `create_time` = '2023-11-19 00:00:00' , `out_time` = NULL , `put_man` = 0 , `update_time` = '2023-11-23 10:39:06.208201' [ RunTime:0.000226s ] [2023-11-23T10:39:06+08:00][sql] CONNECT:[ UseTime:0.004113s ] mysql:host=127.0.0.1;port=3306;dbname=hzjiudingwang;charset=utf8 [2023-11-23T10:39:06+08:00][sql] SHOW FULL COLUMNS FROM `set` [ RunTime:0.000694s ] [2023-11-23T10:39:06+08:00][sql] UPDATE `set` SET `value` = 'hzjiudingwang' WHERE `field` = 'database' [ RunTime:0.000284s ] [2023-11-23T10:39:06+08:00][sql] UPDATE `set` SET `value` = '惠州市九鼎旺门窗有限公司' WHERE `field` = 'title' [ RunTime:0.000208s ] [2023-11-23T10:39:06+08:00][sql] UPDATE `set` SET `value` = '93,90,92' WHERE `field` = 'product_sort' [ RunTime:0.000235s ] [2023-11-23T10:39:06+08:00][sql] CONNECT:[ UseTime:0.011130s ] mysql:host=127.0.0.1;port=3306;dbname=hzjiudingwang;charset=utf8 [2023-11-23T10:39:06+08:00][sql] SHOW FULL COLUMNS FROM `set` [ RunTime:0.000654s ] [2023-11-23T10:39:06+08:00][sql] UPDATE `set` SET `value` = 'hzjiudingwang' WHERE `field` = 'database' [ RunTime:0.000283s ] [2023-11-23T10:39:06+08:00][sql] UPDATE `set` SET `value` = '惠州市九鼎旺门窗有限公司' WHERE `field` = 'title' [ RunTime:0.000198s ] [2023-11-23T10:39:06+08:00][sql] UPDATE `set` SET `value` = '93,90,92' WHERE `field` = 'product_sort' [ RunTime:0.000189s ] [2023-11-23T10:39:06+08:00][sql] SHOW FULL COLUMNS FROM `mo` [ RunTime:0.000721s ] [2023-11-23T10:39:06+08:00][sql] SELECT * FROM `mo` WHERE `id` = 39 [ RunTime:0.000280s ] [2023-11-23T10:39:06+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.000681s ] [2023-11-23T10:39:06+08:00][sql] SELECT * FROM `product` WHERE `id` = 3 [ RunTime:0.000261s ] [2023-11-23T10:39:06+08:00][sql] SELECT `value` FROM `set` WHERE `field` = 'pmr_maker' LIMIT 1 [ RunTime:0.000229s ] [2023-11-23T10:39:06+08:00][sql] SHOW FULL COLUMNS FROM `tpl` [ RunTime:0.000504s ] [2023-11-23T10:39:06+08:00][sql] SELECT * FROM `tpl` WHERE `status` = 1 AND `tpl_sort` = '12' AND `sort` = 90 [ RunTime:0.000264s ] [2023-11-23T10:39:06+08:00][sql] SHOW FULL COLUMNS FROM `tpl_info` [ RunTime:0.000507s ] [2023-11-23T10:39:06+08:00][sql] SELECT * FROM `tpl_info` WHERE `tpl` = 4 ORDER BY `order` ASC [ RunTime:0.000395s ] [2023-11-23T10:39:06+08:00][sql] SHOW FULL COLUMNS FROM `pmr` [ RunTime:0.011939s ] [2023-11-23T10:39:06+08:00][sql] SELECT * FROM `pmr` WHERE `mo` = 39 AND `product` = 3 AND `tpl_info` = 85 LIMIT 1 [ RunTime:0.000574s ] [2023-11-23T10:39:06+08:00][sql] INSERT INTO `pmr` SET `mo` = 39 , `product` = 3 , `tpl_info` = 85 , `count` = 10 , `ng` = 0 , `create_time` = '2023-11-19' , `test` = ' 下料工序' , `req` = '门框板:宽度±1㎜' , `step` = '' , `maker` = 0 , `update_time` = '2023-11-23 10:39:06.402656' [ RunTime:0.000272s ] [2023-11-23T10:39:06+08:00][sql] SELECT * FROM `pmr` WHERE `mo` = 39 AND `product` = 3 AND `tpl_info` = 84 LIMIT 1 [ RunTime:0.000422s ] [2023-11-23T10:39:06+08:00][sql] INSERT INTO `pmr` SET `mo` = 39 , `product` = 3 , `tpl_info` = 84 , `count` = 10 , `ng` = 0 , `create_time` = '2023-11-19' , `test` = ' 下料工序' , `req` = '门框板:长度±1㎜' , `step` = '' , `maker` = 0 , `update_time` = '2023-11-23 10:39:06.403868' [ RunTime:0.000200s ] [2023-11-23T10:39:06+08:00][sql] SELECT * FROM `pmr` WHERE `mo` = 39 AND `product` = 3 AND `tpl_info` = 83 LIMIT 1 [ RunTime:0.000430s ] [2023-11-23T10:39:06+08:00][sql] INSERT INTO `pmr` SET `mo` = 39 , `product` = 3 , `tpl_info` = 83 , `count` = 10 , `ng` = 0 , `create_time` = '2023-11-19' , `test` = ' 下料工序' , `req` = '门扇料:宽度±1㎜' , `step` = '' , `maker` = 0 , `update_time` = '2023-11-23 10:39:06.404957' [ RunTime:0.000188s ] [2023-11-23T10:39:06+08:00][sql] SELECT * FROM `pmr` WHERE `mo` = 39 AND `product` = 3 AND `tpl_info` = 82 LIMIT 1 [ RunTime:0.000442s ] [2023-11-23T10:39:06+08:00][sql] INSERT INTO `pmr` SET `mo` = 39 , `product` = 3 , `tpl_info` = 82 , `count` = 10 , `ng` = 0 , `create_time` = '2023-11-19' , `test` = ' 下料工序' , `req` = '门扇料:长度±1㎜' , `step` = '' , `maker` = 0 , `update_time` = '2023-11-23 10:39:06.406040' [ RunTime:0.000177s ] [2023-11-23T10:39:06+08:00][sql] SELECT * FROM `pmr` WHERE `mo` = 39 AND `product` = 3 AND `tpl_info` = 81 LIMIT 1 [ RunTime:0.000415s ] [2023-11-23T10:39:06+08:00][sql] INSERT INTO `pmr` SET `mo` = 39 , `product` = 3 , `tpl_info` = 81 , `count` = 10 , `ng` = 0 , `create_time` = '2023-11-19' , `test` = ' 下料工序' , `req` = '门扇料:对角线≤3㎜' , `step` = '' , `maker` = 0 , `update_time` = '2023-11-23 10:39:06.407060' [ RunTime:0.000183s ] [2023-11-23T10:39:06+08:00][sql] SELECT * FROM `pmr` WHERE `mo` = 39 AND `product` = 3 AND `tpl_info` = 80 LIMIT 1 [ RunTime:0.000403s ] [2023-11-23T10:39:06+08:00][sql] INSERT INTO `pmr` SET `mo` = 39 , `product` = 3 , `tpl_info` = 80 , `count` = 10 , `ng` = 0 , `create_time` = '2023-11-19' , `test` = '冲孔' , `req` = '锁孔' , `step` = '' , `maker` = 0 , `update_time` = '2023-11-23 10:39:06.408085' [ RunTime:0.000197s ] [2023-11-23T10:39:06+08:00][sql] SELECT * FROM `pmr` WHERE `mo` = 39 AND `product` = 3 AND `tpl_info` = 79 LIMIT 1 [ RunTime:0.000427s ] [2023-11-23T10:39:06+08:00][sql] INSERT INTO `pmr` SET `mo` = 39 , `product` = 3 , `tpl_info` = 79 , `count` = 10 , `ng` = 0 , `create_time` = '2023-11-19' , `test` = '冲孔' , `req` = '合页孔' , `step` = '' , `maker` = 0 , `update_time` = '2023-11-23 10:39:06.409169' [ RunTime:0.000205s ] [2023-11-23T10:39:06+08:00][sql] SELECT * FROM `pmr` WHERE `mo` = 39 AND `product` = 3 AND `tpl_info` = 78 LIMIT 1 [ RunTime:0.000414s ] [2023-11-23T10:39:06+08:00][sql] INSERT INTO `pmr` SET `mo` = 39 , `product` = 3 , `tpl_info` = 78 , `count` = 10 , `ng` = 0 , `create_time` = '2023-11-19' , `test` = '折弯' , `req` = '侧壁宽度' , `step` = '' , `maker` = 0 , `update_time` = '2023-11-23 10:39:06.410203' [ RunTime:0.000206s ] [2023-11-23T10:39:06+08:00][sql] SELECT * FROM `pmr` WHERE `mo` = 39 AND `product` = 3 AND `tpl_info` = 77 LIMIT 1 [ RunTime:0.000372s ] [2023-11-23T10:39:06+08:00][sql] INSERT INTO `pmr` SET `mo` = 39 , `product` = 3 , `tpl_info` = 77 , `count` = 10 , `ng` = 0 , `create_time` = '2023-11-19' , `test` = '折弯' , `req` = '槽口' , `step` = '' , `maker` = 0 , `update_time` = '2023-11-23 10:39:06.411181' [ RunTime:0.000198s ] [2023-11-23T10:39:06+08:00][sql] SELECT * FROM `pmr` WHERE `mo` = 39 AND `product` = 3 AND `tpl_info` = 76 LIMIT 1 [ RunTime:0.000376s ] [2023-11-23T10:39:06+08:00][sql] INSERT INTO `pmr` SET `mo` = 39 , `product` = 3 , `tpl_info` = 76 , `count` = 10 , `ng` = 0 , `create_time` = '2023-11-19' , `test` = '折弯' , `req` = '角度' , `step` = '' , `maker` = 0 , `update_time` = '2023-11-23 10:39:06.412170' [ RunTime:0.000218s ] [2023-11-23T10:39:06+08:00][sql] SELECT * FROM `pmr` WHERE `mo` = 39 AND `product` = 3 AND `tpl_info` = 75 LIMIT 1 [ RunTime:0.000369s ] [2023-11-23T10:39:06+08:00][sql] INSERT INTO `pmr` SET `mo` = 39 , `product` = 3 , `tpl_info` = 75 , `count` = 10 , `ng` = 0 , `create_time` = '2023-11-19' , `test` = '折弯' , `req` = '搭接 ' , `step` = '' , `maker` = 0 , `update_time` = '2023-11-23 10:39:06.413170' [ RunTime:0.000207s ] [2023-11-23T10:39:06+08:00][sql] SELECT * FROM `pmr` WHERE `mo` = 39 AND `product` = 3 AND `tpl_info` = 74 LIMIT 1 [ RunTime:0.000370s ] [2023-11-23T10:39:06+08:00][sql] INSERT INTO `pmr` SET `mo` = 39 , `product` = 3 , `tpl_info` = 74 , `count` = 10 , `ng` = 0 , `create_time` = '2023-11-19' , `test` = '焊接' , `req` = '门框高度±2㎜' , `step` = '' , `maker` = 0 , `update_time` = '2023-11-23 10:39:06.414158' [ RunTime:0.000194s ] [2023-11-23T10:39:06+08:00][sql] SELECT * FROM `pmr` WHERE `mo` = 39 AND `product` = 3 AND `tpl_info` = 73 LIMIT 1 [ RunTime:0.000381s ] [2023-11-23T10:39:06+08:00][sql] INSERT INTO `pmr` SET `mo` = 39 , `product` = 3 , `tpl_info` = 73 , `count` = 10 , `ng` = 0 , `create_time` = '2023-11-19' , `test` = '焊接' , `req` = '门框宽度±1㎜' , `step` = '' , `maker` = 0 , `update_time` = '2023-11-23 10:39:06.415139' [ RunTime:0.000195s ] [2023-11-23T10:39:06+08:00][sql] SELECT * FROM `pmr` WHERE `mo` = 39 AND `product` = 3 AND `tpl_info` = 72 LIMIT 1 [ RunTime:0.000366s ] [2023-11-23T10:39:06+08:00][sql] INSERT INTO `pmr` SET `mo` = 39 , `product` = 3 , `tpl_info` = 72 , `count` = 10 , `ng` = 0 , `create_time` = '2023-11-19' , `test` = '焊接' , `req` = '门扇高度±2㎜' , `step` = '' , `maker` = 0 , `update_time` = '2023-11-23 10:39:06.416116' [ RunTime:0.000188s ] [2023-11-23T10:39:06+08:00][sql] SELECT * FROM `pmr` WHERE `mo` = 39 AND `product` = 3 AND `tpl_info` = 71 LIMIT 1 [ RunTime:0.000423s ] [2023-11-23T10:39:06+08:00][sql] INSERT INTO `pmr` SET `mo` = 39 , `product` = 3 , `tpl_info` = 71 , `count` = 10 , `ng` = 0 , `create_time` = '2023-11-19' , `test` = '焊接' , `req` = '门扇宽度±1㎜' , `step` = '' , `maker` = 0 , `update_time` = '2023-11-23 10:39:06.417156' [ RunTime:0.000215s ] [2023-11-23T10:39:06+08:00][sql] SELECT * FROM `pmr` WHERE `mo` = 39 AND `product` = 3 AND `tpl_info` = 70 LIMIT 1 [ RunTime:0.000366s ] [2023-11-23T10:39:06+08:00][sql] INSERT INTO `pmr` SET `mo` = 39 , `product` = 3 , `tpl_info` = 70 , `count` = 10 , `ng` = 0 , `create_time` = '2023-11-19' , `test` = '焊接' , `req` = '门框侧壁宽度±2㎜' , `step` = '' , `maker` = 0 , `update_time` = '2023-11-23 10:39:06.418154' [ RunTime:0.000263s ] [2023-11-23T10:39:06+08:00][sql] SELECT * FROM `pmr` WHERE `mo` = 39 AND `product` = 3 AND `tpl_info` = 69 LIMIT 1 [ RunTime:0.000391s ] [2023-11-23T10:39:06+08:00][sql] INSERT INTO `pmr` SET `mo` = 39 , `product` = 3 , `tpl_info` = 69 , `count` = 10 , `ng` = 0 , `create_time` = '2023-11-19' , `test` = '焊接' , `req` = '门扇厚度+2,-0' , `step` = '' , `maker` = 0 , `update_time` = '2023-11-23 10:39:06.419307' [ RunTime:0.000196s ] [2023-11-23T10:39:06+08:00][sql] SELECT * FROM `pmr` WHERE `mo` = 39 AND `product` = 3 AND `tpl_info` = 68 LIMIT 1 [ RunTime:0.000439s ] [2023-11-23T10:39:06+08:00][sql] INSERT INTO `pmr` SET `mo` = 39 , `product` = 3 , `tpl_info` = 68 , `count` = 10 , `ng` = 0 , `create_time` = '2023-11-19' , `test` = '门扇填充' , `req` = '防火胶用量:0.8kg/㎡-1kg/㎡' , `step` = '' , `maker` = 0 , `update_time` = '2023-11-23 10:39:06.420365' [ RunTime:0.000206s ] [2023-11-23T10:39:06+08:00][sql] SELECT * FROM `pmr` WHERE `mo` = 39 AND `product` = 3 AND `tpl_info` = 67 LIMIT 1 [ RunTime:0.000385s ] [2023-11-23T10:39:06+08:00][sql] INSERT INTO `pmr` SET `mo` = 39 , `product` = 3 , `tpl_info` = 67 , `count` = 10 , `ng` = 0 , `create_time` = '2023-11-19' , `test` = '门扇压合' , `req` = '时间:冷压机≥4小时' , `step` = '' , `maker` = 0 , `update_time` = '2023-11-23 10:39:06.421400' [ RunTime:0.000217s ] [2023-11-23T10:39:06+08:00][sql] SELECT * FROM `pmr` WHERE `mo` = 39 AND `product` = 3 AND `tpl_info` = 66 LIMIT 1 [ RunTime:0.000420s ] [2023-11-23T10:39:06+08:00][sql] INSERT INTO `pmr` SET `mo` = 39 , `product` = 3 , `tpl_info` = 66 , `count` = 10 , `ng` = 0 , `create_time` = '2023-11-19' , `test` = '门扇压合' , `req` = '压力:6-8MPa ' , `step` = '' , `maker` = 0 , `update_time` = '2023-11-23 10:39:06.422463' [ RunTime:0.000199s ] [2023-11-23T10:39:06+08:00][sql] SELECT * FROM `pmr` WHERE `mo` = 39 AND `product` = 3 AND `tpl_info` = 65 LIMIT 1 [ RunTime:0.000387s ] [2023-11-23T10:39:06+08:00][sql] INSERT INTO `pmr` SET `mo` = 39 , `product` = 3 , `tpl_info` = 65 , `count` = 10 , `ng` = 0 , `create_time` = '2023-11-19' , `test` = '组装五金件' , `req` = '与图纸一致' , `step` = '' , `maker` = 0 , `update_time` = '2023-11-23 10:39:06.423483' [ RunTime:0.000184s ] [2023-11-23T10:39:06+08:00][sql] CONNECT:[ UseTime:0.009743s ] mysql:host=127.0.0.1;port=3306;dbname=hzjiudingwang;charset=utf8 [2023-11-23T10:39:06+08:00][sql] SHOW FULL COLUMNS FROM `set` [ RunTime:0.000738s ] [2023-11-23T10:39:06+08:00][sql] UPDATE `set` SET `value` = 'hzjiudingwang' WHERE `field` = 'database' [ RunTime:0.000315s ] [2023-11-23T10:39:06+08:00][sql] UPDATE `set` SET `value` = '惠州市九鼎旺门窗有限公司' WHERE `field` = 'title' [ RunTime:0.000222s ] [2023-11-23T10:39:06+08:00][sql] UPDATE `set` SET `value` = '93,90,92' WHERE `field` = 'product_sort' [ RunTime:0.000208s ] [2023-11-23T10:39:06+08:00][sql] SHOW FULL COLUMNS FROM `mo` [ RunTime:0.000798s ] [2023-11-23T10:39:06+08:00][sql] SELECT * FROM `mo` WHERE `id` = 39 [ RunTime:0.000290s ] [2023-11-23T10:39:06+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.000741s ] [2023-11-23T10:39:06+08:00][sql] SELECT * FROM `product` WHERE `id` = 3 [ RunTime:0.000310s ] [2023-11-23T10:39:06+08:00][sql] SHOW FULL COLUMNS FROM `tpl` [ RunTime:0.000768s ] [2023-11-23T10:39:06+08:00][sql] SELECT * FROM `tpl` WHERE `status` = 1 AND `tpl_sort` = '13' AND `sort` = 90 [ RunTime:0.000272s ] [2023-11-23T10:39:06+08:00][sql] SHOW FULL COLUMNS FROM `tpl_info` [ RunTime:0.000703s ] [2023-11-23T10:39:06+08:00][sql] SELECT * FROM `tpl_info` WHERE `tpl` = 5 ORDER BY `order` ASC [ RunTime:0.000418s ] [2023-11-23T10:39:06+08:00][sql] SHOW FULL COLUMNS FROM `cpp` [ RunTime:0.013478s ] [2023-11-23T10:39:06+08:00][sql] SELECT * FROM `cpp` WHERE `mo` = 39 AND `tpl_info` = 92 LIMIT 1 [ RunTime:0.000452s ] [2023-11-23T10:39:06+08:00][sql] SELECT `value` FROM `set` WHERE `field` = 'cpp_maker' LIMIT 1 [ RunTime:0.000256s ] [2023-11-23T10:39:06+08:00][sql] INSERT INTO `cpp` SET `mo` = 39 , `product` = '3' , `tpl_info` = 92 , `note` = '20,20,20,20,20,20,20,20,20,20' , `step` = '' , `maker` = 0 , `create_time` = '2023-11-19' , `update_time` = '2023-11-23 10:39:06.547615' [ RunTime:0.000223s ] [2023-11-23T10:39:06+08:00][sql] SELECT * FROM `cpp` WHERE `mo` = 39 AND `tpl_info` = 91 LIMIT 1 [ RunTime:0.000304s ] [2023-11-23T10:39:06+08:00][sql] SELECT `value` FROM `set` WHERE `field` = 'cpp_maker' LIMIT 1 [ RunTime:0.000218s ] [2023-11-23T10:39:06+08:00][sql] INSERT INTO `cpp` SET `mo` = 39 , `product` = '3' , `tpl_info` = 91 , `note` = '130,130,130,130,130,130,130,130,130,130' , `step` = '' , `maker` = 0 , `create_time` = '2023-11-19' , `update_time` = '2023-11-23 10:39:06.548956' [ RunTime:0.000178s ] [2023-11-23T10:39:06+08:00][sql] SELECT * FROM `cpp` WHERE `mo` = 39 AND `tpl_info` = 90 LIMIT 1 [ RunTime:0.000271s ] [2023-11-23T10:39:06+08:00][sql] SELECT `value` FROM `set` WHERE `field` = 'cpp_maker' LIMIT 1 [ RunTime:0.000207s ] [2023-11-23T10:39:06+08:00][sql] INSERT INTO `cpp` SET `mo` = 39 , `product` = '3' , `tpl_info` = 90 , `note` = '4,3.88,4.34,3.25,3.95,3.01,3.01,4.41,3.47,3.03' , `step` = '' , `maker` = 0 , `create_time` = '2023-11-19' , `update_time` = '2023-11-23 10:39:06.550158' [ RunTime:0.000204s ] [2023-11-23T10:39:06+08:00][sql] SELECT * FROM `cpp` WHERE `mo` = 39 AND `tpl_info` = 89 LIMIT 1 [ RunTime:0.000350s ] [2023-11-23T10:39:06+08:00][sql] SELECT `value` FROM `set` WHERE `field` = 'cpp_maker' LIMIT 1 [ RunTime:0.000471s ] [2023-11-23T10:39:06+08:00][sql] INSERT INTO `cpp` SET `mo` = 39 , `product` = '3' , `tpl_info` = 89 , `note` = '0.35,0.52,0.17,0.59,0.38,0.55,0.31,0.54,0.3,0.51' , `step` = '' , `maker` = 0 , `create_time` = '2023-11-19' , `update_time` = '2023-11-23 10:39:06.551764' [ RunTime:0.000188s ] [2023-11-23T10:39:06+08:00][sql] SELECT * FROM `cpp` WHERE `mo` = 39 AND `tpl_info` = 88 LIMIT 1 [ RunTime:0.000303s ] [2023-11-23T10:39:06+08:00][sql] SELECT `value` FROM `set` WHERE `field` = 'cpp_maker' LIMIT 1 [ RunTime:0.000260s ] [2023-11-23T10:39:06+08:00][sql] INSERT INTO `cpp` SET `mo` = 39 , `product` = '3' , `tpl_info` = 88 , `note` = '4.55,4.4,4.29,4.89,4.59,4.6,4.22,4.84,4.44,4.85' , `step` = '' , `maker` = 0 , `create_time` = '2023-11-19' , `update_time` = '2023-11-23 10:39:06.553075' [ RunTime:0.000195s ] [2023-11-23T10:39:06+08:00][sql] SELECT * FROM `cpp` WHERE `mo` = 39 AND `tpl_info` = 87 LIMIT 1 [ RunTime:0.000292s ] [2023-11-23T10:39:06+08:00][sql] SELECT `value` FROM `set` WHERE `field` = 'cpp_maker' LIMIT 1 [ RunTime:0.000212s ] [2023-11-23T10:39:06+08:00][sql] INSERT INTO `cpp` SET `mo` = 39 , `product` = '3' , `tpl_info` = 87 , `note` = '4.49,4.34,4.28,4.41,4.07,4.33,4.05,4.2,4,4.1' , `step` = '' , `maker` = 0 , `create_time` = '2023-11-19' , `update_time` = '2023-11-23 10:39:06.554345' [ RunTime:0.000181s ] [2023-11-23T10:39:06+08:00][sql] SELECT * FROM `cpp` WHERE `mo` = 39 AND `tpl_info` = 86 LIMIT 1 [ RunTime:0.000298s ] [2023-11-23T10:39:06+08:00][sql] SELECT `value` FROM `set` WHERE `field` = 'cpp_maker' LIMIT 1 [ RunTime:0.000223s ] [2023-11-23T10:39:06+08:00][sql] INSERT INTO `cpp` SET `mo` = 39 , `product` = '3' , `tpl_info` = 86 , `note` = '6.29,6.09,6.14,6.28,6.43,6.19,6.08,6.4,6.18,6.34' , `step` = '' , `maker` = 0 , `create_time` = '2023-11-19' , `update_time` = '2023-11-23 10:39:06.555610' [ RunTime:0.000246s ] [2023-11-23T10:39:06+08:00][sql] CONNECT:[ UseTime:0.014498s ] mysql:host=127.0.0.1;port=3306;dbname=hzjiudingwang;charset=utf8 [2023-11-23T10:39:06+08:00][sql] SHOW FULL COLUMNS FROM `set` [ RunTime:0.000821s ] [2023-11-23T10:39:06+08:00][sql] UPDATE `set` SET `value` = 'hzjiudingwang' WHERE `field` = 'database' [ RunTime:0.000334s ] [2023-11-23T10:39:06+08:00][sql] UPDATE `set` SET `value` = '惠州市九鼎旺门窗有限公司' WHERE `field` = 'title' [ RunTime:0.000205s ] [2023-11-23T10:39:06+08:00][sql] UPDATE `set` SET `value` = '93,90,92' WHERE `field` = 'product_sort' [ RunTime:0.000242s ] [2023-11-23T10:39:06+08:00][sql] SHOW FULL COLUMNS FROM `mo` [ RunTime:0.000957s ] [2023-11-23T10:39:06+08:00][sql] SELECT * FROM `mo` WHERE `id` = 39 [ RunTime:0.000288s ] [2023-11-23T10:39:06+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.000807s ] [2023-11-23T10:39:06+08:00][sql] SELECT * FROM `product` WHERE `id` = 3 [ RunTime:0.000276s ] [2023-11-23T10:39:06+08:00][sql] SELECT `value` FROM `set` WHERE `field` = 'capacity' LIMIT 1 [ RunTime:0.000274s ] [2023-11-23T10:39:06+08:00][sql] SELECT `value` FROM `set` WHERE `field` = 'pqc_maker' LIMIT 1 [ RunTime:0.000245s ] [2023-11-23T10:39:06+08:00][sql] SHOW FULL COLUMNS FROM `tpl` [ RunTime:0.000564s ] [2023-11-23T10:39:06+08:00][sql] SELECT * FROM `tpl` WHERE `status` = 1 AND `tpl_sort` = '6' AND `sort` = 90 [ RunTime:0.000248s ] [2023-11-23T10:39:06+08:00][sql] SHOW FULL COLUMNS FROM `tpl_info` [ RunTime:0.000619s ] [2023-11-23T10:39:06+08:00][sql] SELECT * FROM `tpl_info` WHERE `tpl` = 1 ORDER BY `order` ASC [ RunTime:0.000427s ] [2023-11-23T10:39:06+08:00][sql] SHOW FULL COLUMNS FROM `pqc` [ RunTime:0.011581s ] [2023-11-23T10:39:06+08:00][sql] SELECT * FROM `pqc` WHERE `mo` = 39 AND `tpl_info` = 29 LIMIT 1 [ RunTime:0.000677s ] [2023-11-23T10:39:06+08:00][sql] INSERT INTO `pqc` SET `mo` = 39 , `product` = 3 , `tpl_info` = 29 , `qc_count` = 1 , `note` = '0.8' , `result` = 1 , `status` = 1 , `create_time` = '2023-11-19' , `maker` = 0 , `update_time` = '2023-11-23 10:39:06.688143' [ RunTime:0.000532s ] [2023-11-23T10:39:06+08:00][sql] SELECT * FROM `pqc` WHERE `mo` = 39 AND `tpl_info` = 28 LIMIT 1 [ RunTime:0.000596s ] [2023-11-23T10:39:06+08:00][sql] INSERT INTO `pqc` SET `mo` = 39 , `product` = 3 , `tpl_info` = 28 , `qc_count` = 1 , `note` = '1.2' , `result` = 1 , `status` = 1 , `create_time` = '2023-11-19' , `maker` = 0 , `update_time` = '2023-11-23 10:39:06.689903' [ RunTime:0.000240s ] [2023-11-23T10:39:06+08:00][sql] SELECT * FROM `pqc` WHERE `mo` = 39 AND `tpl_info` = 27 LIMIT 1 [ RunTime:0.000473s ] [2023-11-23T10:39:06+08:00][sql] INSERT INTO `pqc` SET `mo` = 39 , `product` = 3 , `tpl_info` = 27 , `qc_count` = 1 , `note` = '3' , `result` = 1 , `status` = 1 , `create_time` = '2023-11-19' , `maker` = 0 , `update_time` = '2023-11-23 10:39:06.691074' [ RunTime:0.000237s ] [2023-11-23T10:39:06+08:00][sql] SELECT * FROM `pqc` WHERE `mo` = 39 AND `tpl_info` = 26 LIMIT 1 [ RunTime:0.000487s ] [2023-11-23T10:39:06+08:00][sql] INSERT INTO `pqc` SET `mo` = 39 , `product` = 3 , `tpl_info` = 26 , `qc_count` = 1 , `note` = '1.2' , `result` = 1 , `status` = 1 , `create_time` = '2023-11-19' , `maker` = 0 , `update_time` = '2023-11-23 10:39:06.692409' [ RunTime:0.000228s ] [2023-11-23T10:39:06+08:00][sql] SELECT * FROM `pqc` WHERE `mo` = 39 AND `tpl_info` = 25 LIMIT 1 [ RunTime:0.000523s ] [2023-11-23T10:39:06+08:00][sql] INSERT INTO `pqc` SET `mo` = 39 , `product` = 3 , `tpl_info` = 25 , `qc_count` = 1 , `note` = '1' , `result` = 1 , `status` = 1 , `create_time` = '2023-11-19' , `maker` = 0 , `update_time` = '2023-11-23 10:39:06.693650' [ RunTime:0.000177s ] [2023-11-23T10:39:06+08:00][sql] SELECT * FROM `pqc` WHERE `mo` = 39 AND `tpl_info` = 24 LIMIT 1 [ RunTime:0.000457s ] [2023-11-23T10:39:06+08:00][sql] INSERT INTO `pqc` SET `mo` = 39 , `product` = 3 , `tpl_info` = 24 , `qc_count` = 1 , `note` = '4.76' , `result` = 1 , `status` = 1 , `create_time` = '2023-11-19' , `maker` = 0 , `update_time` = '2023-11-23 10:39:06.694733' [ RunTime:0.000175s ] [2023-11-23T10:39:06+08:00][sql] SELECT * FROM `pqc` WHERE `mo` = 39 AND `tpl_info` = 23 LIMIT 1 [ RunTime:0.000462s ] [2023-11-23T10:39:06+08:00][sql] INSERT INTO `pqc` SET `mo` = 39 , `product` = 3 , `tpl_info` = 23 , `qc_count` = 1 , `note` = '2.86' , `result` = 1 , `status` = 1 , `create_time` = '2023-11-19' , `maker` = 0 , `update_time` = '2023-11-23 10:39:06.695818' [ RunTime:0.000214s ] [2023-11-23T10:39:06+08:00][sql] SELECT * FROM `pqc` WHERE `mo` = 39 AND `tpl_info` = 22 LIMIT 1 [ RunTime:0.000463s ] [2023-11-23T10:39:06+08:00][sql] INSERT INTO `pqc` SET `mo` = 39 , `product` = 3 , `tpl_info` = 22 , `qc_count` = 1 , `note` = '1' , `result` = 1 , `status` = 1 , `create_time` = '2023-11-19' , `maker` = 0 , `update_time` = '2023-11-23 10:39:06.696874' [ RunTime:0.000247s ] [2023-11-23T10:39:06+08:00][sql] SELECT * FROM `pqc` WHERE `mo` = 39 AND `tpl_info` = 21 LIMIT 1 [ RunTime:0.000429s ] [2023-11-23T10:39:06+08:00][sql] INSERT INTO `pqc` SET `mo` = 39 , `product` = 3 , `tpl_info` = 21 , `qc_count` = 1 , `note` = '1' , `result` = 1 , `status` = 1 , `create_time` = '2023-11-19' , `maker` = 0 , `update_time` = '2023-11-23 10:39:06.697985' [ RunTime:0.000177s ] [2023-11-23T10:39:06+08:00][sql] SELECT * FROM `pqc` WHERE `mo` = 39 AND `tpl_info` = 20 LIMIT 1 [ RunTime:0.000433s ] [2023-11-23T10:39:06+08:00][sql] INSERT INTO `pqc` SET `mo` = 39 , `product` = 3 , `tpl_info` = 20 , `qc_count` = 1 , `note` = '-0.01' , `result` = 1 , `status` = 1 , `create_time` = '2023-11-19' , `maker` = 0 , `update_time` = '2023-11-23 10:39:06.699027' [ RunTime:0.000250s ] [2023-11-23T10:39:06+08:00][sql] SELECT * FROM `pqc` WHERE `mo` = 39 AND `tpl_info` = 19 LIMIT 1 [ RunTime:0.000508s ] [2023-11-23T10:39:06+08:00][sql] INSERT INTO `pqc` SET `mo` = 39 , `product` = 3 , `tpl_info` = 19 , `qc_count` = 1 , `note` = '-0.58' , `result` = 1 , `status` = 1 , `create_time` = '2023-11-19' , `maker` = 0 , `update_time` = '2023-11-23 10:39:06.700315' [ RunTime:0.000211s ] [2023-11-23T10:39:06+08:00][sql] SELECT * FROM `pqc` WHERE `mo` = 39 AND `tpl_info` = 18 LIMIT 1 [ RunTime:0.000438s ] [2023-11-23T10:39:06+08:00][sql] INSERT INTO `pqc` SET `mo` = 39 , `product` = 3 , `tpl_info` = 18 , `qc_count` = 1 , `note` = '1.31' , `result` = 1 , `status` = 1 , `create_time` = '2023-11-19' , `maker` = 0 , `update_time` = '2023-11-23 10:39:06.701415' [ RunTime:0.000187s ] [2023-11-23T10:39:06+08:00][sql] SELECT * FROM `pqc` WHERE `mo` = 39 AND `tpl_info` = 17 LIMIT 1 [ RunTime:0.000422s ] [2023-11-23T10:39:06+08:00][sql] INSERT INTO `pqc` SET `mo` = 39 , `product` = 3 , `tpl_info` = 17 , `qc_count` = 1 , `note` = '0.93' , `result` = 1 , `status` = 1 , `create_time` = '2023-11-19' , `maker` = 0 , `update_time` = '2023-11-23 10:39:06.702483' [ RunTime:0.000177s ] [2023-11-23T10:39:06+08:00][sql] SELECT * FROM `pqc` WHERE `mo` = 39 AND `tpl_info` = 16 LIMIT 1 [ RunTime:0.000442s ] [2023-11-23T10:39:06+08:00][sql] INSERT INTO `pqc` SET `mo` = 39 , `product` = 3 , `tpl_info` = 16 , `qc_count` = 1 , `note` = '1' , `result` = 1 , `status` = 1 , `create_time` = '2023-11-19' , `maker` = 0 , `update_time` = '2023-11-23 10:39:06.703526' [ RunTime:0.000175s ] [2023-11-23T10:39:06+08:00][sql] SELECT * FROM `pqc` WHERE `mo` = 39 AND `tpl_info` = 15 LIMIT 1 [ RunTime:0.000478s ] [2023-11-23T10:39:06+08:00][sql] INSERT INTO `pqc` SET `mo` = 39 , `product` = 3 , `tpl_info` = 15 , `qc_count` = 1 , `note` = '1' , `result` = 1 , `status` = 1 , `create_time` = '2023-11-19' , `maker` = 0 , `update_time` = '2023-11-23 10:39:06.704608' [ RunTime:0.000198s ] [2023-11-23T10:39:06+08:00][sql] SELECT * FROM `pqc` WHERE `mo` = 39 AND `tpl_info` = 14 LIMIT 1 [ RunTime:0.000445s ] [2023-11-23T10:39:06+08:00][sql] INSERT INTO `pqc` SET `mo` = 39 , `product` = 3 , `tpl_info` = 14 , `qc_count` = 1 , `note` = '1.92' , `result` = 1 , `status` = 1 , `create_time` = '2023-11-19' , `maker` = 0 , `update_time` = '2023-11-23 10:39:06.705662' [ RunTime:0.000205s ] [2023-11-23T10:39:06+08:00][sql] SELECT * FROM `pqc` WHERE `mo` = 39 AND `tpl_info` = 13 LIMIT 1 [ RunTime:0.000442s ] [2023-11-23T10:39:06+08:00][sql] INSERT INTO `pqc` SET `mo` = 39 , `product` = 3 , `tpl_info` = 13 , `qc_count` = 1 , `note` = '-1.8' , `result` = 1 , `status` = 1 , `create_time` = '2023-11-19' , `maker` = 0 , `update_time` = '2023-11-23 10:39:06.706708' [ RunTime:0.000273s ] [2023-11-23T10:39:06+08:00][sql] SELECT * FROM `pqc` WHERE `mo` = 39 AND `tpl_info` = 12 LIMIT 1 [ RunTime:0.000487s ] [2023-11-23T10:39:06+08:00][sql] INSERT INTO `pqc` SET `mo` = 39 , `product` = 3 , `tpl_info` = 12 , `qc_count` = 1 , `note` = '0.2' , `result` = 1 , `status` = 1 , `create_time` = '2023-11-19' , `maker` = 0 , `update_time` = '2023-11-23 10:39:06.707945' [ RunTime:0.000206s ] [2023-11-23T10:39:06+08:00][sql] SELECT * FROM `pqc` WHERE `mo` = 39 AND `tpl_info` = 11 LIMIT 1 [ RunTime:0.000439s ] [2023-11-23T10:39:06+08:00][sql] INSERT INTO `pqc` SET `mo` = 39 , `product` = 3 , `tpl_info` = 11 , `qc_count` = 1 , `note` = '2.2' , `result` = 1 , `status` = 1 , `create_time` = '2023-11-19' , `maker` = 0 , `update_time` = '2023-11-23 10:39:06.709063' [ RunTime:0.000173s ] [2023-11-23T10:39:06+08:00][sql] SELECT * FROM `pqc` WHERE `mo` = 39 AND `tpl_info` = 10 LIMIT 1 [ RunTime:0.000451s ] [2023-11-23T10:39:06+08:00][sql] INSERT INTO `pqc` SET `mo` = 39 , `product` = 3 , `tpl_info` = 10 , `qc_count` = 1 , `note` = '-0.49' , `result` = 1 , `status` = 1 , `create_time` = '2023-11-19' , `maker` = 0 , `update_time` = '2023-11-23 10:39:06.710124' [ RunTime:0.000204s ] [2023-11-23T10:39:06+08:00][sql] SELECT * FROM `pqc` WHERE `mo` = 39 AND `tpl_info` = 9 LIMIT 1 [ RunTime:0.000434s ] [2023-11-23T10:39:06+08:00][sql] INSERT INTO `pqc` SET `mo` = 39 , `product` = 3 , `tpl_info` = 9 , `qc_count` = 1 , `note` = '1' , `result` = 1 , `status` = 1 , `create_time` = '2023-11-19' , `maker` = 0 , `update_time` = '2023-11-23 10:39:06.711180' [ RunTime:0.000206s ] [2023-11-23T10:39:06+08:00][sql] SELECT * FROM `pqc` WHERE `mo` = 39 AND `tpl_info` = 8 LIMIT 1 [ RunTime:0.000422s ] [2023-11-23T10:39:06+08:00][sql] INSERT INTO `pqc` SET `mo` = 39 , `product` = 3 , `tpl_info` = 8 , `qc_count` = 1 , `note` = '1' , `result` = 1 , `status` = 1 , `create_time` = '2023-11-19' , `maker` = 0 , `update_time` = '2023-11-23 10:39:06.712208' [ RunTime:0.000188s ] [2023-11-23T10:39:06+08:00][sql] SELECT * FROM `pqc` WHERE `mo` = 39 AND `tpl_info` = 7 LIMIT 1 [ RunTime:0.000406s ] [2023-11-23T10:39:06+08:00][sql] INSERT INTO `pqc` SET `mo` = 39 , `product` = 3 , `tpl_info` = 7 , `qc_count` = 1 , `note` = '2.24' , `result` = 1 , `status` = 1 , `create_time` = '2023-11-19' , `maker` = 0 , `update_time` = '2023-11-23 10:39:06.713226' [ RunTime:0.000181s ] [2023-11-23T10:39:06+08:00][sql] SELECT * FROM `pqc` WHERE `mo` = 39 AND `tpl_info` = 6 LIMIT 1 [ RunTime:0.000409s ] [2023-11-23T10:39:06+08:00][sql] INSERT INTO `pqc` SET `mo` = 39 , `product` = 3 , `tpl_info` = 6 , `qc_count` = 1 , `note` = '8.05' , `result` = 1 , `status` = 1 , `create_time` = '2023-11-19' , `maker` = 0 , `update_time` = '2023-11-23 10:39:06.714215' [ RunTime:0.000192s ] [2023-11-23T10:39:06+08:00][sql] SELECT * FROM `pqc` WHERE `mo` = 39 AND `tpl_info` = 5 LIMIT 1 [ RunTime:0.000449s ] [2023-11-23T10:39:06+08:00][sql] INSERT INTO `pqc` SET `mo` = 39 , `product` = 3 , `tpl_info` = 5 , `qc_count` = 1 , `note` = '2.29' , `result` = 1 , `status` = 1 , `create_time` = '2023-11-19' , `maker` = 0 , `update_time` = '2023-11-23 10:39:06.715329' [ RunTime:0.000172s ] [2023-11-23T10:39:06+08:00][sql] SELECT * FROM `pqc` WHERE `mo` = 39 AND `tpl_info` = 4 LIMIT 1 [ RunTime:0.000408s ] [2023-11-23T10:39:06+08:00][sql] INSERT INTO `pqc` SET `mo` = 39 , `product` = 3 , `tpl_info` = 4 , `qc_count` = 1 , `note` = '0.95' , `result` = 1 , `status` = 1 , `create_time` = '2023-11-19' , `maker` = 0 , `update_time` = '2023-11-23 10:39:06.716323' [ RunTime:0.000172s ] [2023-11-23T10:39:06+08:00][sql] SELECT * FROM `pqc` WHERE `mo` = 39 AND `tpl_info` = 3 LIMIT 1 [ RunTime:0.000422s ] [2023-11-23T10:39:06+08:00][sql] INSERT INTO `pqc` SET `mo` = 39 , `product` = 3 , `tpl_info` = 3 , `qc_count` = 1 , `note` = '1' , `result` = 1 , `status` = 1 , `create_time` = '2023-11-19' , `maker` = 0 , `update_time` = '2023-11-23 10:39:06.717335' [ RunTime:0.000173s ] [2023-11-23T10:39:06+08:00][sql] SELECT * FROM `pqc` WHERE `mo` = 39 AND `tpl_info` = 2 LIMIT 1 [ RunTime:0.000420s ] [2023-11-23T10:39:06+08:00][sql] INSERT INTO `pqc` SET `mo` = 39 , `product` = 3 , `tpl_info` = 2 , `qc_count` = 1 , `note` = '-1.07' , `result` = 1 , `status` = 1 , `create_time` = '2023-11-19' , `maker` = 0 , `update_time` = '2023-11-23 10:39:06.718346' [ RunTime:0.000178s ] [2023-11-23T10:39:06+08:00][sql] SELECT * FROM `pqc` WHERE `mo` = 39 AND `tpl_info` = 1 LIMIT 1 [ RunTime:0.000416s ] [2023-11-23T10:39:06+08:00][sql] INSERT INTO `pqc` SET `mo` = 39 , `product` = 3 , `tpl_info` = 1 , `qc_count` = 1 , `note` = '1' , `result` = 1 , `status` = 1 , `create_time` = '2023-11-19' , `maker` = 0 , `update_time` = '2023-11-23 10:39:06.719360' [ RunTime:0.000203s ] [2023-11-23T10:39:06+08:00][sql] CONNECT:[ UseTime:0.011917s ] mysql:host=127.0.0.1;port=3306;dbname=hzjiudingwang;charset=utf8 [2023-11-23T10:39:06+08:00][sql] SHOW FULL COLUMNS FROM `set` [ RunTime:0.000711s ] [2023-11-23T10:39:06+08:00][sql] UPDATE `set` SET `value` = 'hzjiudingwang' WHERE `field` = 'database' [ RunTime:0.000288s ] [2023-11-23T10:39:06+08:00][sql] UPDATE `set` SET `value` = '惠州市九鼎旺门窗有限公司' WHERE `field` = 'title' [ RunTime:0.000262s ] [2023-11-23T10:39:06+08:00][sql] UPDATE `set` SET `value` = '93,90,92' WHERE `field` = 'product_sort' [ RunTime:0.000267s ] [2023-11-23T10:39:06+08:00][sql] SHOW FULL COLUMNS FROM `mo` [ RunTime:0.000648s ] [2023-11-23T10:39:06+08:00][sql] SELECT * FROM `mo` WHERE `id` = 39 [ RunTime:0.000293s ] [2023-11-23T10:39:06+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.000594s ] [2023-11-23T10:39:06+08:00][sql] SELECT * FROM `product` WHERE `id` = 3 [ RunTime:0.000247s ] [2023-11-23T10:39:06+08:00][sql] SHOW FULL COLUMNS FROM `fqc` [ RunTime:0.008814s ] [2023-11-23T10:39:06+08:00][sql] SELECT `number` FROM `fqc` WHERE `create_time` >= '2023-11-19 00:00:00' [ RunTime:0.001248s ] [2023-11-23T10:39:06+08:00][sql] SHOW FULL COLUMNS FROM `tpl` [ RunTime:0.000877s ] [2023-11-23T10:39:06+08:00][sql] SELECT * FROM `tpl` WHERE `status` = 1 AND `tpl_sort` = '7' AND `sort` = 90 [ RunTime:0.000486s ] [2023-11-23T10:39:06+08:00][sql] SHOW FULL COLUMNS FROM `tpl_info` [ RunTime:0.000743s ] [2023-11-23T10:39:06+08:00][sql] SELECT * FROM `tpl_info` WHERE `tpl` = 2 ORDER BY `order` ASC [ RunTime:0.000434s ] [2023-11-23T10:39:06+08:00][sql] SELECT `value` FROM `set` WHERE `field` = 'fqc_maker' LIMIT 1 [ RunTime:0.000315s ] [2023-11-23T10:39:06+08:00][sql] SELECT `value` FROM `set` WHERE `field` = 'fqc_maker' LIMIT 1 [ RunTime:0.000253s ] [2023-11-23T10:39:06+08:00][sql] SELECT `value` FROM `set` WHERE `field` = 'fqc_maker' LIMIT 1 [ RunTime:0.000302s ] [2023-11-23T10:39:06+08:00][sql] SELECT `value` FROM `set` WHERE `field` = 'fqc_maker' LIMIT 1 [ RunTime:0.000289s ] [2023-11-23T10:39:06+08:00][sql] SELECT `value` FROM `set` WHERE `field` = 'fqc_maker' LIMIT 1 [ RunTime:0.000279s ] [2023-11-23T10:39:06+08:00][sql] SELECT `value` FROM `set` WHERE `field` = 'fqc_maker' LIMIT 1 [ RunTime:0.000237s ] [2023-11-23T10:39:06+08:00][sql] SELECT `value` FROM `set` WHERE `field` = 'fqc_maker' LIMIT 1 [ RunTime:0.000240s ] [2023-11-23T10:39:06+08:00][sql] SELECT `value` FROM `set` WHERE `field` = 'fqc_maker' LIMIT 1 [ RunTime:0.000241s ] [2023-11-23T10:39:06+08:00][sql] SELECT `value` FROM `set` WHERE `field` = 'fqc_maker' LIMIT 1 [ RunTime:0.000275s ] [2023-11-23T10:39:06+08:00][sql] SELECT `value` FROM `set` WHERE `field` = 'fqc_maker' LIMIT 1 [ RunTime:0.000223s ] [2023-11-23T10:39:06+08:00][sql] insert into `fqc`(number,mo,product,note,result,create_time)values('20231119001_0001', '39', '3', '{"34":1,"33":1,"32":1,"31":1,"30":1}', '1', '2023-11-19'),('20231119001_0002', '39', '3', '{"34":1,"33":1,"32":1,"31":1,"30":1}', '1', '2023-11-19'),('20231119001_0003', '39', '3', '{"34":1,"33":1,"32":1,"31":1,"30":1}', '1', '2023-11-19'),('20231119001_0004', '39', '3', '{"34":1,"33":1,"32":1,"31":1,"30":1}', '1', '2023-11-19'),('20231119001_0005', '39', '3', '{"34":1,"33":1,"32":1,"31":1,"30":1}', '1', '2023-11-19'),('20231119001_0006', '39', '3', '{"34":1,"33":1,"32":1,"31":1,"30":1}', '1', '2023-11-19'),('20231119001_0007', '39', '3', '{"34":1,"33":1,"32":1,"31":1,"30":1}', '1', '2023-11-19'),('20231119001_0008', '39', '3', '{"34":1,"33":1,"32":1,"31":1,"30":1}', '1', '2023-11-19'),('20231119001_0009', '39', '3', '{"34":1,"33":1,"32":1,"31":1,"30":1}', '1', '2023-11-19'),('20231119001_0010', '39', '3', '{"34":1,"33":1,"32":1,"31":1,"30":1}', '1', '2023-11-19') [ RunTime:0.000376s ] [2023-11-23T10:39:06+08:00][sql] CONNECT:[ UseTime:0.013396s ] mysql:host=127.0.0.1;port=3306;dbname=hzjiudingwang;charset=utf8 [2023-11-23T10:39:06+08:00][sql] SHOW FULL COLUMNS FROM `set` [ RunTime:0.000706s ] [2023-11-23T10:39:06+08:00][sql] UPDATE `set` SET `value` = 'hzjiudingwang' WHERE `field` = 'database' [ RunTime:0.000315s ] [2023-11-23T10:39:06+08:00][sql] UPDATE `set` SET `value` = '惠州市九鼎旺门窗有限公司' WHERE `field` = 'title' [ RunTime:0.000232s ] [2023-11-23T10:39:06+08:00][sql] UPDATE `set` SET `value` = '93,90,92' WHERE `field` = 'product_sort' [ RunTime:0.000203s ] [2023-11-23T10:39:06+08:00][sql] SHOW FULL COLUMNS FROM `mo` [ RunTime:0.000799s ] [2023-11-23T10:39:06+08:00][sql] SELECT * FROM `mo` WHERE `id` = 39 [ RunTime:0.000304s ] [2023-11-23T10:39:06+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.000728s ] [2023-11-23T10:39:06+08:00][sql] SELECT * FROM `product` WHERE `id` = 3 [ RunTime:0.000280s ] [2023-11-23T10:39:06+08:00][sql] SELECT `value` FROM `set` WHERE `field` = 'capacity' LIMIT 1 [ RunTime:0.000278s ] [2023-11-23T10:39:06+08:00][sql] SELECT `value` FROM `set` WHERE `field` = 'pass_man' LIMIT 1 [ RunTime:0.000210s ] [2023-11-23T10:39:06+08:00][sql] SELECT `value` FROM `set` WHERE `field` = 'put_man' LIMIT 1 [ RunTime:0.000211s ] [2023-11-23T10:39:06+08:00][sql] SHOW FULL COLUMNS FROM `up` [ RunTime:0.014016s ] [2023-11-23T10:39:06+08:00][sql] SELECT * FROM `up` WHERE `mo` = 39 AND `product` = 3 LIMIT 1 [ RunTime:0.000512s ] [2023-11-23T10:39:06+08:00][sql] SELECT MAX(`number`) AS think_max FROM `up` WHERE `number` LIKE '20231120%' LIMIT 1 [ RunTime:0.000352s ] [2023-11-23T10:39:06+08:00][sql] INSERT INTO `up` SET `number` = '20231120001' , `mo` = 39 , `so` = 23 , `product` = 3 , `count` = 10 , `create_time` = '2023-11-19 00:00:00' , `status` = 1 , `pass_man` = 0 , `put_man` = 0 , `update_time` = '2023-11-23 10:39:06.967706' [ RunTime:0.000359s ] [2023-11-23T10:39:07+08:00][sql] CONNECT:[ UseTime:0.014545s ] mysql:host=127.0.0.1;port=3306;dbname=hzjiudingwang;charset=utf8 [2023-11-23T10:39:07+08:00][sql] SHOW FULL COLUMNS FROM `set` [ RunTime:0.000839s ] [2023-11-23T10:39:07+08:00][sql] UPDATE `set` SET `value` = 'hzjiudingwang' WHERE `field` = 'database' [ RunTime:0.000306s ] [2023-11-23T10:39:07+08:00][sql] UPDATE `set` SET `value` = '惠州市九鼎旺门窗有限公司' WHERE `field` = 'title' [ RunTime:0.000241s ] [2023-11-23T10:39:07+08:00][sql] UPDATE `set` SET `value` = '93,90,92' WHERE `field` = 'product_sort' [ RunTime:0.000236s ] [2023-11-23T10:39:07+08:00][sql] SHOW FULL COLUMNS FROM `mo` [ RunTime:0.000818s ] [2023-11-23T10:39:07+08:00][sql] SELECT * FROM `mo` WHERE `id` = 39 [ RunTime:0.000294s ] [2023-11-23T10:39:07+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.000577s ] [2023-11-23T10:39:07+08:00][sql] SELECT * FROM `product` WHERE `id` = 3 [ RunTime:0.000256s ] [2023-11-23T10:39:07+08:00][sql] SELECT `value` FROM `set` WHERE `field` = 'oqc_maker' LIMIT 1 [ RunTime:0.000266s ] [2023-11-23T10:39:07+08:00][sql] SHOW FULL COLUMNS FROM `tpl` [ RunTime:0.000829s ] [2023-11-23T10:39:07+08:00][sql] SELECT * FROM `tpl` WHERE `status` = 1 AND `tpl_sort` = '8' AND `sort` = 90 [ RunTime:0.000287s ] [2023-11-23T10:39:07+08:00][sql] SHOW FULL COLUMNS FROM `tpl_info` [ RunTime:0.000727s ] [2023-11-23T10:39:07+08:00][sql] SELECT * FROM `tpl_info` WHERE `tpl` = 3 ORDER BY `order` ASC [ RunTime:0.000488s ] [2023-11-23T10:39:07+08:00][sql] SHOW FULL COLUMNS FROM `fqc` [ RunTime:0.008500s ] [2023-11-23T10:39:07+08:00][sql] SELECT * FROM `fqc` WHERE `mo` = 39 ORDER BY rand() LIMIT 3 [ RunTime:0.001552s ] [2023-11-23T10:39:07+08:00][sql] SHOW FULL COLUMNS FROM `oqc` [ RunTime:0.001000s ] [2023-11-23T10:39:07+08:00][sql] SELECT COUNT(*) AS think_count FROM `oqc` WHERE `mo` = 39 AND `product` = 3 LIMIT 1 [ RunTime:0.000303s ] [2023-11-23T10:39:07+08:00][sql] INSERT INTO `oqc` SET `number` = '20231119001_0008' , `mo` = 39 , `product` = 3 , `note` = '{\"64\":1,\"63\":0.8,\"62\":1.2,\"61\":3,\"60\":1.2,\"59\":3,\"58\":1,\"56\":1,\"57\":-1.35,\"55\":0.56,\"54\":0.27,\"53\":-0.64,\"52\":-1.72,\"51\":1.25,\"50\":1.69,\"49\":3.22,\"47\":1.28,\"46\":2.43,\"45\":14.7,\"44\":2.36,\"43\":2.4,\"42\":1.87,\"41\":1.72,\"40\":7.07,\"39\":2.55,\"38\":1,\"37\":79.93,\"36\":500,\"35\":1,\"48\":1.74}' , `result` = 1 , `create_time` = '2023-11-19' , `maker` = 0 , `update_time` = '2023-11-23 10:39:07.108595' [ RunTime:0.000250s ] [2023-11-23T10:39:07+08:00][sql] SELECT COUNT(*) AS think_count FROM `oqc` WHERE `mo` = 39 AND `product` = 3 LIMIT 1 [ RunTime:0.000242s ] [2023-11-23T10:39:07+08:00][sql] INSERT INTO `oqc` SET `number` = '20231119001_0009' , `mo` = 39 , `product` = 3 , `note` = '{\"64\":1,\"63\":0.8,\"62\":1.2,\"61\":3,\"60\":1.2,\"59\":3,\"58\":1,\"56\":1,\"57\":-0.18,\"55\":-1.53,\"54\":-0.2,\"53\":-2.45,\"52\":-1.29,\"51\":-0.47,\"50\":1.09,\"49\":3.25,\"47\":1.47,\"46\":1.6,\"45\":13.41,\"44\":2.12,\"43\":1.09,\"42\":2.22,\"41\":1.94,\"40\":7.06,\"39\":2.53,\"38\":1,\"37\":79.57,\"36\":500,\"35\":1,\"48\":1.37}' , `result` = 1 , `create_time` = '2023-11-19' , `maker` = 0 , `update_time` = '2023-11-23 10:39:07.109623' [ RunTime:0.000236s ] [2023-11-23T10:39:07+08:00][sql] SELECT COUNT(*) AS think_count FROM `oqc` WHERE `mo` = 39 AND `product` = 3 LIMIT 1 [ RunTime:0.000292s ] [2023-11-23T10:39:07+08:00][sql] INSERT INTO `oqc` SET `number` = '20231119001_0005' , `mo` = 39 , `product` = 3 , `note` = '{\"64\":1,\"63\":0.8,\"62\":1.2,\"61\":3,\"60\":1.2,\"59\":3,\"58\":1,\"56\":1,\"57\":1.14,\"55\":-0.6,\"54\":1.8,\"53\":2.49,\"52\":0.88,\"51\":-1.63,\"50\":1.22,\"49\":3.63,\"47\":1.82,\"46\":2.19,\"45\":14.57,\"44\":2.38,\"43\":2.45,\"42\":1.09,\"41\":2.28,\"40\":7.91,\"39\":2.7,\"38\":1,\"37\":78.34,\"36\":500,\"35\":1,\"48\":1.4}' , `result` = 1 , `create_time` = '2023-11-19' , `maker` = 0 , `update_time` = '2023-11-23 10:39:07.110657' [ RunTime:0.000191s ] [2023-11-23T10:39:07+08:00][sql] CONNECT:[ UseTime:0.013610s ] mysql:host=127.0.0.1;port=3306;dbname=hzjiudingwang;charset=utf8 [2023-11-23T10:39:07+08:00][sql] SHOW FULL COLUMNS FROM `set` [ RunTime:0.000699s ] [2023-11-23T10:39:07+08:00][sql] UPDATE `set` SET `value` = 'hzjiudingwang' WHERE `field` = 'database' [ RunTime:0.000294s ] [2023-11-23T10:39:07+08:00][sql] UPDATE `set` SET `value` = '惠州市九鼎旺门窗有限公司' WHERE `field` = 'title' [ RunTime:0.000201s ] [2023-11-23T10:39:07+08:00][sql] UPDATE `set` SET `value` = '93,90,92' WHERE `field` = 'product_sort' [ RunTime:0.000226s ] [2023-11-23T10:39:07+08:00][sql] SHOW FULL COLUMNS FROM `pp` [ RunTime:0.000572s ] [2023-11-23T10:39:07+08:00][sql] SELECT * FROM `pp` WHERE `so` = 23 [ RunTime:0.000274s ] [2023-11-23T10:39:07+08:00][sql] SHOW FULL COLUMNS FROM `so` [ RunTime:0.000737s ] [2023-11-23T10:39:07+08:00][sql] SELECT * FROM `so` WHERE `id` = 23 [ RunTime:0.000311s ] [2023-11-23T10:39:07+08:00][sql] SELECT `value` FROM `set` WHERE `field` = 'pass_man' LIMIT 1 [ RunTime:0.000266s ] [2023-11-23T10:39:07+08:00][sql] SELECT `value` FROM `set` WHERE `field` = 'put_man' LIMIT 1 [ RunTime:0.000203s ] [2023-11-23T10:39:07+08:00][sql] SELECT `value` FROM `set` WHERE `field` = 'store_man' LIMIT 1 [ RunTime:0.000194s ] [2023-11-23T10:39:07+08:00][sql] SHOW FULL COLUMNS FROM `sell` [ RunTime:0.011982s ] [2023-11-23T10:39:07+08:00][sql] SELECT * FROM `sell` WHERE `so` = 23 AND `pp` = 59 AND `product` = 3 LIMIT 1 [ RunTime:0.000424s ] [2023-11-23T10:39:07+08:00][sql] INSERT INTO `sell` SET `so` = 23 , `pp` = 59 , `product` = 3 , `count` = 10 , `cust` = 18 , `create_time` = '2023-11-22 12:00:00' , `report_time` = '2023-11-23 00:00:00' , `start_num` = '62379AA64001AA' , `status` = 2 , `end_num` = '62379AA64010AA' , `pass_man` = 0 , `store_man` = 0 , `qa_man` = 0 , `update_time` = '2023-11-23 10:39:07.229995' [ RunTime:0.000261s ]