[2024-05-19T08:54:19+08:00][sql] CONNECT:[ UseTime:0.010803s ] mysql:host=127.0.0.1;port=3306;dbname=zhyfzndq;charset=utf8 [2024-05-19T08:54:19+08:00][sql] SHOW FULL COLUMNS FROM `set` [ RunTime:0.001166s ] [2024-05-19T08:54:19+08:00][sql] UPDATE `set` SET `value` = 'zhyfzndq' WHERE `field` = 'database' [ RunTime:0.000321s ] [2024-05-19T08:54:19+08:00][sql] UPDATE `set` SET `value` = '珠海易发智能电气有限公司' WHERE `field` = 'title' [ RunTime:0.000214s ] [2024-05-19T08:54:19+08:00][sql] UPDATE `set` SET `value` = '63,64,65,69,71,73,367,368,369,379' WHERE `field` = 'product_sort' [ RunTime:0.000209s ] [2024-05-19T09:18:54+08:00][sql] CONNECT:[ UseTime:0.000951s ] mysql:host=127.0.0.1;port=3306;dbname=zhyfzmqc;charset=utf8 [2024-05-19T09:18:54+08:00][sql] SHOW FULL COLUMNS FROM `set` [ RunTime:0.001151s ] [2024-05-19T09:18:54+08:00][sql] UPDATE `set` SET `value` = 'zhyfzmqc' WHERE `field` = 'database' [ RunTime:0.000272s ] [2024-05-19T09:18:54+08:00][sql] UPDATE `set` SET `value` = '珠海易发照明器材有限公司' WHERE `field` = 'title' [ RunTime:0.000239s ] [2024-05-19T09:18:54+08:00][sql] UPDATE `set` SET `value` = '63,64,65,66,69,70,71,73,367,368,369,370,372,379' WHERE `field` = 'product_sort' [ RunTime:0.000209s ] [2024-05-19T15:10:43+08:00][sql] CONNECT:[ UseTime:0.010533s ] mysql:host=127.0.0.1;port=3306;dbname=ahwtxhgdkj;charset=utf8 [2024-05-19T15:10:43+08:00][sql] SHOW FULL COLUMNS FROM `set` [ RunTime:0.000688s ] [2024-05-19T15:10:43+08:00][sql] UPDATE `set` SET `value` = 'ahwtxhgdkj' WHERE `field` = 'database' [ RunTime:0.000279s ] [2024-05-19T15:10:43+08:00][sql] UPDATE `set` SET `value` = '安徽皖投新辉光电科技有限公司' WHERE `field` = 'title' [ RunTime:0.000209s ] [2024-05-19T15:10:43+08:00][sql] UPDATE `set` SET `value` = '391' WHERE `field` = 'product_sort' [ RunTime:0.000190s ] [2024-05-19T15:10:50+08:00][sql] CONNECT:[ UseTime:0.010891s ] mysql:host=127.0.0.1;port=3306;dbname=ahwtxhgdkj;charset=utf8 [2024-05-19T15:10:50+08:00][sql] SHOW FULL COLUMNS FROM `set` [ RunTime:0.000832s ] [2024-05-19T15:10:50+08:00][sql] UPDATE `set` SET `value` = 'ahwtxhgdkj' WHERE `field` = 'database' [ RunTime:0.000282s ] [2024-05-19T15:10:50+08:00][sql] UPDATE `set` SET `value` = '安徽皖投新辉光电科技有限公司' WHERE `field` = 'title' [ RunTime:0.000310s ] [2024-05-19T15:10:50+08:00][sql] UPDATE `set` SET `value` = '391' WHERE `field` = 'product_sort' [ RunTime:0.000185s ] [2024-05-19T15:10:51+08:00][sql] CONNECT:[ UseTime:0.010716s ] mysql:host=127.0.0.1;port=3306;dbname=ahwtxhgdkj;charset=utf8 [2024-05-19T15:10:51+08:00][sql] SHOW FULL COLUMNS FROM `set` [ RunTime:0.000700s ] [2024-05-19T15:10:51+08:00][sql] UPDATE `set` SET `value` = 'ahwtxhgdkj' WHERE `field` = 'database' [ RunTime:0.000275s ] [2024-05-19T15:10:51+08:00][sql] UPDATE `set` SET `value` = '安徽皖投新辉光电科技有限公司' WHERE `field` = 'title' [ RunTime:0.000252s ] [2024-05-19T15:10:51+08:00][sql] UPDATE `set` SET `value` = '391' WHERE `field` = 'product_sort' [ RunTime:0.000192s ] [2024-05-19T15:10:51+08:00][sql] SHOW FULL COLUMNS FROM `cust` [ RunTime:0.001029s ] [2024-05-19T15:10:51+08:00][sql] SELECT MAX(`number`) AS think_max FROM `cust` LIMIT 1 [ RunTime:0.000200s ] [2024-05-19T15:10:51+08:00][sql] SELECT * FROM `cust` WHERE `name` = '样品' LIMIT 1 [ RunTime:0.000264s ] [2024-05-19T15:10:51+08:00][sql] INSERT INTO `cust` SET `number` = '00001' , `name` = '样品' , `create_time` = '2024-05-19 15:10:51.147202' , `update_time` = '2024-05-19 15:10:51.147214' [ RunTime:0.000259s ] [2024-05-19T15:10:51+08:00][sql] SHOW FULL COLUMNS FROM `project` [ RunTime:0.001159s ] [2024-05-19T15:10:51+08:00][sql] SELECT * FROM `project` WHERE `name` = '' AND `cust` = 1 LIMIT 1 [ RunTime:0.000367s ] [2024-05-19T15:10:51+08:00][sql] INSERT INTO `project` SET `name` = '' , `cust` = 1 , `create_time` = '2024-05-19 15:10:51.164950' , `update_time` = '2024-05-19 15:10:51.164962' [ RunTime:0.000284s ] [2024-05-19T15:10:51+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.001042s ] [2024-05-19T15:10:51+08:00][sql] SELECT * FROM `product` [ RunTime:0.000310s ] [2024-05-19T15:10:51+08:00][sql] SELECT `value` FROM `set` WHERE `field` = 'lead_time' LIMIT 1 [ RunTime:0.000263s ] [2024-05-19T15:10:51+08:00][sql] SELECT `value` FROM `set` WHERE `field` = 'so_maker' LIMIT 1 [ RunTime:0.000295s ] [2024-05-19T15:10:51+08:00][sql] SELECT `value` FROM `set` WHERE `field` = 'so_ratif' LIMIT 1 [ RunTime:0.000178s ] [2024-05-19T15:10:51+08:00][sql] SELECT `value` FROM `set` WHERE `field` = 'put_man' LIMIT 1 [ RunTime:0.000225s ] [2024-05-19T15:10:51+08:00][sql] SHOW FULL COLUMNS FROM `so` [ RunTime:0.000848s ] [2024-05-19T15:10:51+08:00][sql] SELECT * FROM `so` WHERE `cust` = 1 AND `project` = '1' AND `report_time` = '2023-11-13' LIMIT 1 [ RunTime:0.000222s ] [2024-05-19T15:10:51+08:00][sql] SELECT MAX(`number`) AS think_max FROM `so` WHERE `number` LIKE '20231106%' LIMIT 1 [ RunTime:0.000262s ] [2024-05-19T15:10:51+08:00][sql] INSERT INTO `so` SET `number` = '20231106001' , `cust` = 1 , `project` = '1' , `addr` = '' , `linkman` = 0 , `req` = '' , `status` = 6 , `create_time` = '2023-11-06' , `report_time` = '2023-11-13' , `maker` = 0 , `ratif` = 0 , `update_time` = '2024-05-19 15:10:51.172412' [ RunTime:0.000295s ] [2024-05-19T15:10:51+08:00][sql] SHOW FULL COLUMNS FROM `pp` [ RunTime:0.000814s ] [2024-05-19T15:10:51+08:00][sql] SELECT * FROM `pp` WHERE `start_num` = '41062AA09728AA' AND `end_num` = '41062AA09729AA' LIMIT 1 [ RunTime:0.000210s ] [2024-05-19T15:10:51+08:00][sql] INSERT INTO `pp` SET `so` = 1 , `count` = 12 , `product` = 1 , `status` = 6 , `name` = '家用可燃气体探测器' , `type` = 'JT-IST-T2-L1W0' , `specs` = '\\' , `unit` = '只' , `need_time` = '2023-11-12' , `create_time` = '2023-11-06' , `report_time` = '2023-11-13' , `start_num` = '41062AA09728AA' , `end_num` = '41062AA09729AA' , `update_time` = '2024-05-19 15:10:51.174875' [ RunTime:0.000343s ] [2024-05-19T15:10:51+08:00][sql] CONNECT:[ UseTime:0.011022s ] mysql:host=127.0.0.1;port=3306;dbname=ahwtxhgdkj;charset=utf8 [2024-05-19T15:10:51+08:00][sql] SHOW FULL COLUMNS FROM `set` [ RunTime:0.000701s ] [2024-05-19T15:10:51+08:00][sql] UPDATE `set` SET `value` = 'ahwtxhgdkj' WHERE `field` = 'database' [ RunTime:0.000368s ] [2024-05-19T15:10:51+08:00][sql] UPDATE `set` SET `value` = '安徽皖投新辉光电科技有限公司' WHERE `field` = 'title' [ RunTime:0.000221s ] [2024-05-19T15:10:51+08:00][sql] UPDATE `set` SET `value` = '391' WHERE `field` = 'product_sort' [ RunTime:0.000187s ] [2024-05-19T15:10:51+08:00][sql] SHOW FULL COLUMNS FROM `pp` [ RunTime:0.001071s ] [2024-05-19T15:10:51+08:00][sql] SELECT * FROM `pp` WHERE `so` = 1 [ RunTime:0.000267s ] [2024-05-19T15:10:51+08:00][sql] SHOW FULL COLUMNS FROM `bom` [ RunTime:0.000994s ] [2024-05-19T15:10:51+08:00][sql] SELECT * FROM `bom` WHERE `product` = 1 [ RunTime:0.000214s ] [2024-05-19T15:10:51+08:00][sql] SHOW FULL COLUMNS FROM `bom_info` [ RunTime:0.000911s ] [2024-05-19T15:10:51+08:00][sql] SELECT * FROM `bom_info` WHERE `bom` = 1 [ RunTime:0.000254s ] [2024-05-19T15:10:51+08:00][sql] SHOW FULL COLUMNS FROM `raw` [ RunTime:0.000902s ] [2024-05-19T15:10:51+08:00][sql] SELECT * FROM `raw` [ RunTime:0.000270s ] [2024-05-19T15:10:51+08:00][sql] SHOW FULL COLUMNS FROM `mrp` [ RunTime:0.001181s ] [2024-05-19T15:10:51+08:00][sql] SELECT * FROM `mrp` WHERE `pp` = 1 AND `raw` = 1 LIMIT 1 [ RunTime:0.000262s ] [2024-05-19T15:10:51+08:00][sql] INSERT INTO `mrp` SET `so` = 1 , `pp` = 1 , `count` = 12 , `raw` = 1 , `need_time` = '2023-11-12 00:00:00' , `status` = 5 , `create_time` = '2023-11-06 00:00:00' , `update_time` = '2024-05-19 15:10:51.330434' [ RunTime:0.000287s ] [2024-05-19T15:10:51+08:00][sql] SELECT * FROM `mrp` WHERE `pp` = 1 AND `raw` = 2 LIMIT 1 [ RunTime:0.000288s ] [2024-05-19T15:10:51+08:00][sql] INSERT INTO `mrp` SET `so` = 1 , `pp` = 1 , `count` = 48 , `raw` = 2 , `need_time` = '2023-11-12 00:00:00' , `status` = 5 , `create_time` = '2023-11-06 00:00:00' , `update_time` = '2024-05-19 15:10:51.331502' [ RunTime:0.000189s ] [2024-05-19T15:10:51+08:00][sql] SELECT * FROM `mrp` WHERE `pp` = 1 AND `raw` = 3 LIMIT 1 [ RunTime:0.000193s ] [2024-05-19T15:10:51+08:00][sql] INSERT INTO `mrp` SET `so` = 1 , `pp` = 1 , `count` = 12 , `raw` = 3 , `need_time` = '2023-11-12 00:00:00' , `status` = 5 , `create_time` = '2023-11-06 00:00:00' , `update_time` = '2024-05-19 15:10:51.332275' [ RunTime:0.000190s ] [2024-05-19T15:10:51+08:00][sql] SELECT * FROM `mrp` WHERE `pp` = 1 AND `raw` = 4 LIMIT 1 [ RunTime:0.000207s ] [2024-05-19T15:10:51+08:00][sql] INSERT INTO `mrp` SET `so` = 1 , `pp` = 1 , `count` = 12 , `raw` = 4 , `need_time` = '2023-11-12 00:00:00' , `status` = 5 , `create_time` = '2023-11-06 00:00:00' , `update_time` = '2024-05-19 15:10:51.333149' [ RunTime:0.000263s ] [2024-05-19T15:10:51+08:00][sql] SELECT * FROM `mrp` WHERE `pp` = 1 AND `raw` = 5 LIMIT 1 [ RunTime:0.000186s ] [2024-05-19T15:10:51+08:00][sql] INSERT INTO `mrp` SET `so` = 1 , `pp` = 1 , `count` = 12 , `raw` = 5 , `need_time` = '2023-11-12 00:00:00' , `status` = 5 , `create_time` = '2023-11-06 00:00:00' , `update_time` = '2024-05-19 15:10:51.334026' [ RunTime:0.000176s ] [2024-05-19T15:10:51+08:00][sql] CONNECT:[ UseTime:0.010567s ] mysql:host=127.0.0.1;port=3306;dbname=ahwtxhgdkj;charset=utf8 [2024-05-19T15:10:51+08:00][sql] SHOW FULL COLUMNS FROM `set` [ RunTime:0.000674s ] [2024-05-19T15:10:51+08:00][sql] UPDATE `set` SET `value` = 'ahwtxhgdkj' WHERE `field` = 'database' [ RunTime:0.000296s ] [2024-05-19T15:10:51+08:00][sql] UPDATE `set` SET `value` = '安徽皖投新辉光电科技有限公司' WHERE `field` = 'title' [ RunTime:0.000211s ] [2024-05-19T15:10:51+08:00][sql] UPDATE `set` SET `value` = '391' WHERE `field` = 'product_sort' [ RunTime:0.000193s ] [2024-05-19T15:10:51+08:00][sql] CONNECT:[ UseTime:0.010448s ] mysql:host=127.0.0.1;port=3306;dbname=ahwtxhgdkj;charset=utf8 [2024-05-19T15:10:51+08:00][sql] SHOW FULL COLUMNS FROM `set` [ RunTime:0.000657s ] [2024-05-19T15:10:51+08:00][sql] UPDATE `set` SET `value` = 'ahwtxhgdkj' WHERE `field` = 'database' [ RunTime:0.000261s ] [2024-05-19T15:10:51+08:00][sql] UPDATE `set` SET `value` = '安徽皖投新辉光电科技有限公司' WHERE `field` = 'title' [ RunTime:0.000197s ] [2024-05-19T15:10:51+08:00][sql] UPDATE `set` SET `value` = '391' WHERE `field` = 'product_sort' [ RunTime:0.000191s ] [2024-05-19T15:10:51+08:00][sql] SHOW FULL COLUMNS FROM `mrp` [ RunTime:0.000944s ] [2024-05-19T15:10:51+08:00][sql] SELECT * FROM `mrp` WHERE `id` IN (1,2,3,4,5) [ RunTime:0.000240s ] [2024-05-19T15:10:51+08:00][sql] SHOW FULL COLUMNS FROM `raw` [ RunTime:0.001209s ] [2024-05-19T15:10:51+08:00][sql] SELECT * FROM `raw` WHERE `id` IN (1,2,3,4,5) [ RunTime:0.000430s ] [2024-05-19T15:10:51+08:00][sql] SHOW FULL COLUMNS FROM `supplier` [ RunTime:0.000708s ] [2024-05-19T15:10:51+08:00][sql] SELECT * FROM `supplier` [ RunTime:0.000258s ] [2024-05-19T15:10:51+08:00][sql] SELECT `value` FROM `set` WHERE `field` = 'po_base' LIMIT 1 [ RunTime:0.000350s ] [2024-05-19T15:10:51+08:00][sql] SELECT `value` FROM `set` WHERE `field` = 'po_base' LIMIT 1 [ RunTime:0.000191s ] [2024-05-19T15:10:51+08:00][sql] SELECT `value` FROM `set` WHERE `field` = 'po_base' LIMIT 1 [ RunTime:0.000180s ] [2024-05-19T15:10:51+08:00][sql] SELECT `value` FROM `set` WHERE `field` = 'po_base' LIMIT 1 [ RunTime:0.000184s ] [2024-05-19T15:10:51+08:00][sql] SELECT `value` FROM `set` WHERE `field` = 'po_base' LIMIT 1 [ RunTime:0.000197s ] [2024-05-19T15:10:51+08:00][sql] SHOW FULL COLUMNS FROM `po` [ RunTime:0.001245s ] [2024-05-19T15:10:51+08:00][sql] SELECT `number` FROM `po` [ RunTime:0.000198s ] [2024-05-19T15:11:28+08:00][sql] CONNECT:[ UseTime:0.010471s ] mysql:host=127.0.0.1;port=3306;dbname=ahwtxhgdkj;charset=utf8 [2024-05-19T15:11:28+08:00][sql] SHOW FULL COLUMNS FROM `set` [ RunTime:0.000708s ] [2024-05-19T15:11:28+08:00][sql] UPDATE `set` SET `value` = 'ahwtxhgdkj' WHERE `field` = 'database' [ RunTime:0.000293s ] [2024-05-19T15:11:28+08:00][sql] UPDATE `set` SET `value` = '安徽皖投新辉光电科技有限公司' WHERE `field` = 'title' [ RunTime:0.000207s ] [2024-05-19T15:11:28+08:00][sql] UPDATE `set` SET `value` = '391' WHERE `field` = 'product_sort' [ RunTime:0.000223s ] [2024-05-19T15:11:28+08:00][sql] SELECT `value` FROM `set` WHERE `field` = 'po_maker' LIMIT 1 [ RunTime:0.000285s ] [2024-05-19T15:11:28+08:00][sql] SELECT `value` FROM `set` WHERE `field` = 'po_ratif' LIMIT 1 [ RunTime:0.000198s ] [2024-05-19T15:11:28+08:00][sql] SHOW FULL COLUMNS FROM `po` [ RunTime:0.000903s ] [2024-05-19T15:11:28+08:00][sql] SELECT * FROM `po` WHERE `mrp` = '1' AND `so` = '1' AND `raw` = 1 LIMIT 1 [ RunTime:0.000305s ] [2024-05-19T15:11:28+08:00][sql] SELECT MAX(`number`) AS think_max FROM `po` WHERE `number` LIKE '20231106%' LIMIT 1 [ RunTime:0.000214s ] [2024-05-19T15:11:28+08:00][sql] INSERT INTO `po` SET `number` = '20231106001' , `so` = '1' , `mrp` = '1' , `raw` = 1 , `count` = '12' , `po_count` = '50' , `create_time` = '2023-11-06 00:00:00' , `deliver_time` = '2023-11-08 00:00:00' , `supplier` = 1 , `status` = 8 , `po_unit` = '个' , `maker` = 0 , `ratif` = 0 , `update_time` = '2024-05-19 15:11:28.166037' [ RunTime:0.000303s ] [2024-05-19T15:11:28+08:00][sql] SELECT * FROM `po` WHERE `mrp` = '2' AND `so` = '1' AND `raw` = 2 LIMIT 1 [ RunTime:0.000249s ] [2024-05-19T15:11:28+08:00][sql] SELECT MAX(`number`) AS think_max FROM `po` WHERE `number` LIKE '20231106%' LIMIT 1 [ RunTime:0.000177s ] [2024-05-19T15:11:28+08:00][sql] INSERT INTO `po` SET `number` = '20231106002' , `so` = '1' , `mrp` = '2' , `raw` = 2 , `count` = '48' , `po_count` = '300' , `create_time` = '2023-11-06 00:00:00' , `deliver_time` = '2023-11-08 00:00:00' , `supplier` = 2 , `status` = 8 , `po_unit` = '颗' , `maker` = 0 , `ratif` = 0 , `update_time` = '2024-05-19 15:11:28.167400' [ RunTime:0.000273s ] [2024-05-19T15:11:28+08:00][sql] SELECT * FROM `po` WHERE `mrp` = '3' AND `so` = '1' AND `raw` = 3 LIMIT 1 [ RunTime:0.000236s ] [2024-05-19T15:11:28+08:00][sql] SELECT MAX(`number`) AS think_max FROM `po` WHERE `number` LIKE '20231106%' LIMIT 1 [ RunTime:0.000201s ] [2024-05-19T15:11:28+08:00][sql] INSERT INTO `po` SET `number` = '20231106003' , `so` = '1' , `mrp` = '3' , `raw` = 3 , `count` = '12' , `po_count` = '50' , `create_time` = '2023-11-06 00:00:00' , `deliver_time` = '2023-11-08 00:00:00' , `supplier` = 3 , `status` = 8 , `po_unit` = '套' , `maker` = 0 , `ratif` = 0 , `update_time` = '2024-05-19 15:11:28.168868' [ RunTime:0.000223s ] [2024-05-19T15:11:28+08:00][sql] SELECT * FROM `po` WHERE `mrp` = '4' AND `so` = '1' AND `raw` = 4 LIMIT 1 [ RunTime:0.000219s ] [2024-05-19T15:11:28+08:00][sql] SELECT MAX(`number`) AS think_max FROM `po` WHERE `number` LIKE '20231106%' LIMIT 1 [ RunTime:0.000239s ] [2024-05-19T15:11:28+08:00][sql] INSERT INTO `po` SET `number` = '20231106004' , `so` = '1' , `mrp` = '4' , `raw` = 4 , `count` = '12' , `po_count` = '50' , `create_time` = '2023-11-06 00:00:00' , `deliver_time` = '2023-11-08 00:00:00' , `supplier` = 4 , `status` = 8 , `po_unit` = '个' , `maker` = 0 , `ratif` = 0 , `update_time` = '2024-05-19 15:11:28.170210' [ RunTime:0.000217s ] [2024-05-19T15:11:28+08:00][sql] SELECT * FROM `po` WHERE `mrp` = '5' AND `so` = '1' AND `raw` = 5 LIMIT 1 [ RunTime:0.000212s ] [2024-05-19T15:11:28+08:00][sql] SELECT MAX(`number`) AS think_max FROM `po` WHERE `number` LIKE '20231106%' LIMIT 1 [ RunTime:0.000193s ] [2024-05-19T15:11:28+08:00][sql] INSERT INTO `po` SET `number` = '20231106005' , `so` = '1' , `mrp` = '5' , `raw` = 5 , `count` = '12' , `po_count` = '50' , `create_time` = '2023-11-06 00:00:00' , `deliver_time` = '2023-11-08 00:00:00' , `supplier` = 5 , `status` = 8 , `po_unit` = '块' , `maker` = 0 , `ratif` = 0 , `update_time` = '2024-05-19 15:11:28.171480' [ RunTime:0.000245s ] [2024-05-19T15:11:28+08:00][sql] CONNECT:[ UseTime:0.010507s ] mysql:host=127.0.0.1;port=3306;dbname=ahwtxhgdkj;charset=utf8 [2024-05-19T15:11:28+08:00][sql] SHOW FULL COLUMNS FROM `set` [ RunTime:0.000704s ] [2024-05-19T15:11:28+08:00][sql] UPDATE `set` SET `value` = 'ahwtxhgdkj' WHERE `field` = 'database' [ RunTime:0.000274s ] [2024-05-19T15:11:28+08:00][sql] UPDATE `set` SET `value` = '安徽皖投新辉光电科技有限公司' WHERE `field` = 'title' [ RunTime:0.000212s ] [2024-05-19T15:11:28+08:00][sql] UPDATE `set` SET `value` = '391' WHERE `field` = 'product_sort' [ RunTime:0.000266s ] [2024-05-19T15:11:28+08:00][sql] SHOW FULL COLUMNS FROM `po` [ RunTime:0.001113s ] [2024-05-19T15:11:28+08:00][sql] SELECT * FROM `po` WHERE `id` IN (1,2,3,4,5) [ RunTime:0.000285s ] [2024-05-19T15:11:28+08:00][sql] SHOW FULL COLUMNS FROM `an` [ RunTime:0.001301s ] [2024-05-19T15:11:28+08:00][sql] SELECT * FROM `an` WHERE `po` = 1 AND `raw` = 1 LIMIT 1 [ RunTime:0.000242s ] [2024-05-19T15:11:28+08:00][sql] SELECT MAX(`number`) AS think_max FROM `an` WHERE `number` LIKE '20231107%' LIMIT 1 [ RunTime:0.000232s ] [2024-05-19T15:11:28+08:00][sql] SELECT `value` FROM `set` WHERE `field` = 'an_maker' LIMIT 1 [ RunTime:0.000305s ] [2024-05-19T15:11:28+08:00][sql] INSERT INTO `an` SET `po` = 1 , `number` = '20231107001' , `raw` = 1 , `count` = '50.00' , `supplier` = 1 , `status` = 3 , `create_time` = '2023-11-07 03:35:28' , `update_time` = '2024-05-19 15:11:28.352102' [ RunTime:0.000312s ] [2024-05-19T15:11:28+08:00][sql] SELECT * FROM `an` WHERE `po` = 2 AND `raw` = 2 LIMIT 1 [ RunTime:0.000293s ] [2024-05-19T15:11:28+08:00][sql] SELECT MAX(`number`) AS think_max FROM `an` WHERE `number` LIKE '20231107%' LIMIT 1 [ RunTime:0.000180s ] [2024-05-19T15:11:28+08:00][sql] SELECT `value` FROM `set` WHERE `field` = 'an_maker' LIMIT 1 [ RunTime:0.000224s ] [2024-05-19T15:11:28+08:00][sql] INSERT INTO `an` SET `po` = 2 , `number` = '20231107002' , `raw` = 2 , `count` = '300.00' , `supplier` = 2 , `status` = 3 , `create_time` = '2023-11-07 11:40:06' , `update_time` = '2024-05-19 15:11:28.353826' [ RunTime:0.000244s ] [2024-05-19T15:11:28+08:00][sql] SELECT * FROM `an` WHERE `po` = 3 AND `raw` = 3 LIMIT 1 [ RunTime:0.000318s ] [2024-05-19T15:11:28+08:00][sql] SELECT MAX(`number`) AS think_max FROM `an` WHERE `number` LIKE '20231107%' LIMIT 1 [ RunTime:0.000174s ] [2024-05-19T15:11:28+08:00][sql] SELECT `value` FROM `set` WHERE `field` = 'an_maker' LIMIT 1 [ RunTime:0.000181s ] [2024-05-19T15:11:28+08:00][sql] INSERT INTO `an` SET `po` = 3 , `number` = '20231107003' , `raw` = 3 , `count` = '50.00' , `supplier` = 3 , `status` = 3 , `create_time` = '2023-11-07 06:58:36' , `update_time` = '2024-05-19 15:11:28.355363' [ RunTime:0.000299s ] [2024-05-19T15:11:28+08:00][sql] SELECT * FROM `an` WHERE `po` = 4 AND `raw` = 4 LIMIT 1 [ RunTime:0.000224s ] [2024-05-19T15:11:28+08:00][sql] SELECT MAX(`number`) AS think_max FROM `an` WHERE `number` LIKE '20231107%' LIMIT 1 [ RunTime:0.000169s ] [2024-05-19T15:11:28+08:00][sql] SELECT `value` FROM `set` WHERE `field` = 'an_maker' LIMIT 1 [ RunTime:0.000283s ] [2024-05-19T15:11:28+08:00][sql] INSERT INTO `an` SET `po` = 4 , `number` = '20231107004' , `raw` = 4 , `count` = '50.00' , `supplier` = 4 , `status` = 3 , `create_time` = '2023-11-07 05:01:09' , `update_time` = '2024-05-19 15:11:28.356942' [ RunTime:0.000231s ] [2024-05-19T15:11:28+08:00][sql] SELECT * FROM `an` WHERE `po` = 5 AND `raw` = 5 LIMIT 1 [ RunTime:0.000203s ] [2024-05-19T15:11:28+08:00][sql] SELECT MAX(`number`) AS think_max FROM `an` WHERE `number` LIKE '20231107%' LIMIT 1 [ RunTime:0.000177s ] [2024-05-19T15:11:28+08:00][sql] SELECT `value` FROM `set` WHERE `field` = 'an_maker' LIMIT 1 [ RunTime:0.000207s ] [2024-05-19T15:11:28+08:00][sql] INSERT INTO `an` SET `po` = 5 , `number` = '20231107005' , `raw` = 5 , `count` = '50.00' , `supplier` = 5 , `status` = 3 , `create_time` = '2023-11-07 04:49:26' , `update_time` = '2024-05-19 15:11:28.358375' [ RunTime:0.000205s ] [2024-05-19T15:11:28+08:00][sql] CONNECT:[ UseTime:0.011078s ] mysql:host=127.0.0.1;port=3306;dbname=ahwtxhgdkj;charset=utf8 [2024-05-19T15:11:28+08:00][sql] SHOW FULL COLUMNS FROM `set` [ RunTime:0.000667s ] [2024-05-19T15:11:28+08:00][sql] UPDATE `set` SET `value` = 'ahwtxhgdkj' WHERE `field` = 'database' [ RunTime:0.000322s ] [2024-05-19T15:11:28+08:00][sql] UPDATE `set` SET `value` = '安徽皖投新辉光电科技有限公司' WHERE `field` = 'title' [ RunTime:0.000201s ] [2024-05-19T15:11:28+08:00][sql] UPDATE `set` SET `value` = '391' WHERE `field` = 'product_sort' [ RunTime:0.000177s ] [2024-05-19T15:11:28+08:00][sql] SHOW FULL COLUMNS FROM `an` [ RunTime:0.001026s ] [2024-05-19T15:11:28+08:00][sql] SELECT * FROM `an` WHERE `id` IN (1,2,3,4,5) [ RunTime:0.000270s ] [2024-05-19T15:11:28+08:00][sql] SHOW FULL COLUMNS FROM `raw` [ RunTime:0.000655s ] [2024-05-19T15:11:28+08:00][sql] SELECT * FROM `raw` WHERE `id` IN (1,2,3,4,5) [ RunTime:0.000252s ] [2024-05-19T15:11:28+08:00][sql] SHOW FULL COLUMNS FROM `iqc` [ RunTime:0.001158s ] [2024-05-19T15:11:28+08:00][sql] SELECT * FROM `iqc` WHERE `an` = '1' AND `raw` = 1 LIMIT 1 [ RunTime:0.000348s ] [2024-05-19T15:11:28+08:00][sql] SELECT MAX(`number`) AS think_max FROM `iqc` WHERE `number` LIKE '20231108%' LIMIT 1 [ RunTime:0.000183s ] [2024-05-19T15:11:28+08:00][sql] SELECT `value` FROM `set` WHERE `field` = 'iqc_maker' LIMIT 1 [ RunTime:0.000215s ] [2024-05-19T15:11:28+08:00][sql] SELECT `value` FROM `set` WHERE `field` = 'iqc_ratif' LIMIT 1 [ RunTime:0.000292s ] [2024-05-19T15:11:28+08:00][sql] INSERT INTO `iqc` SET `number` = '20231108001' , `an` = '1' , `raw` = 1 , `supplier` = 1 , `count` = '50.00' , `result` = '1' , `maker` = 0 , `ratif` = 0 , `remark` = '' , `status` = 4 , `create_time` = '2023-11-08' , `update_time` = '2024-05-19 15:11:28.511409' [ RunTime:0.000354s ] [2024-05-19T15:11:28+08:00][sql] SHOW FULL COLUMNS FROM `tpl` [ RunTime:0.000910s ] [2024-05-19T15:11:28+08:00][sql] SELECT * FROM `tpl` WHERE `status` = 1 AND `tpl_sort` = '14' AND `sort` = 983 [ RunTime:0.000333s ] [2024-05-19T15:11:28+08:00][sql] SHOW FULL COLUMNS FROM `tpl_info` [ RunTime:0.000915s ] [2024-05-19T15:11:28+08:00][sql] SELECT * FROM `tpl_info` WHERE `tpl` = 7 ORDER BY `order` ASC [ RunTime:0.000298s ] [2024-05-19T15:11:28+08:00][sql] SHOW FULL COLUMNS FROM `iqc_note` [ RunTime:0.001050s ] [2024-05-19T15:11:28+08:00][sql] SELECT * FROM `iqc_note` WHERE `iqc` = 1 AND `tpl_raw_info` = 48 LIMIT 1 [ RunTime:0.000363s ] [2024-05-19T15:11:28+08:00][sql] INSERT INTO `iqc_note` SET `iqc` = 1 , `tpl_raw_info` = 48 , `qc_count` = '8' , `count` = '8' , `note` = '1,1,1,1,1,1,1,1,' , `ng` = '0' , `create_time` = '2023-11-08' , `remark` = '' , `update_time` = '2024-05-19 15:11:28.530716' [ RunTime:0.000285s ] [2024-05-19T15:11:28+08:00][sql] SELECT * FROM `iqc_note` WHERE `iqc` = 1 AND `tpl_raw_info` = 49 LIMIT 1 [ RunTime:0.000274s ] [2024-05-19T15:11:28+08:00][sql] INSERT INTO `iqc_note` SET `iqc` = 1 , `tpl_raw_info` = 49 , `qc_count` = '8' , `count` = '8' , `note` = '1,1,1,1,1,1,1,1,' , `ng` = '0' , `create_time` = '2023-11-08' , `remark` = '' , `update_time` = '2024-05-19 15:11:28.531735' [ RunTime:0.000244s ] [2024-05-19T15:11:28+08:00][sql] SELECT * FROM `iqc_note` WHERE `iqc` = 1 AND `tpl_raw_info` = 50 LIMIT 1 [ RunTime:0.000264s ] [2024-05-19T15:11:28+08:00][sql] INSERT INTO `iqc_note` SET `iqc` = 1 , `tpl_raw_info` = 50 , `qc_count` = '8' , `count` = '8' , `note` = '1,1,1,1,1,1,1,1,' , `ng` = '0' , `create_time` = '2023-11-08' , `remark` = '' , `update_time` = '2024-05-19 15:11:28.532650' [ RunTime:0.000183s ] [2024-05-19T15:11:28+08:00][sql] SELECT * FROM `iqc_note` WHERE `iqc` = 1 AND `tpl_raw_info` = 51 LIMIT 1 [ RunTime:0.000188s ] [2024-05-19T15:11:28+08:00][sql] INSERT INTO `iqc_note` SET `iqc` = 1 , `tpl_raw_info` = 51 , `qc_count` = '8' , `count` = '8' , `note` = '1,1,1,1,1,1,1,1,' , `ng` = '0' , `create_time` = '2023-11-08' , `remark` = '' , `update_time` = '2024-05-19 15:11:28.533469' [ RunTime:0.000182s ] [2024-05-19T15:11:28+08:00][sql] SELECT * FROM `iqc` WHERE `an` = '2' AND `raw` = 2 LIMIT 1 [ RunTime:0.000204s ] [2024-05-19T15:11:28+08:00][sql] SELECT MAX(`number`) AS think_max FROM `iqc` WHERE `number` LIKE '20231108%' LIMIT 1 [ RunTime:0.000238s ] [2024-05-19T15:11:28+08:00][sql] SELECT `value` FROM `set` WHERE `field` = 'iqc_maker' LIMIT 1 [ RunTime:0.000188s ] [2024-05-19T15:11:28+08:00][sql] SELECT `value` FROM `set` WHERE `field` = 'iqc_ratif' LIMIT 1 [ RunTime:0.000183s ] [2024-05-19T15:11:28+08:00][sql] INSERT INTO `iqc` SET `number` = '20231108002' , `an` = '2' , `raw` = 2 , `supplier` = 2 , `count` = '300.00' , `result` = '1' , `maker` = 0 , `ratif` = 0 , `remark` = '' , `status` = 4 , `create_time` = '2023-11-08' , `update_time` = '2024-05-19 15:11:28.535555' [ RunTime:0.000212s ] [2024-05-19T15:11:28+08:00][sql] SELECT * FROM `tpl` WHERE `status` = 1 AND `tpl_sort` = '14' AND `sort` = 990 [ RunTime:0.000220s ] [2024-05-19T15:11:28+08:00][sql] SELECT * FROM `tpl_info` WHERE `tpl` = 8 ORDER BY `order` ASC [ RunTime:0.000256s ] [2024-05-19T15:11:28+08:00][sql] SELECT * FROM `iqc_note` WHERE `iqc` = 2 AND `tpl_raw_info` = 52 LIMIT 1 [ RunTime:0.000235s ] [2024-05-19T15:11:28+08:00][sql] INSERT INTO `iqc_note` SET `iqc` = 2 , `tpl_raw_info` = 52 , `qc_count` = '50' , `count` = '50' , `note` = '1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,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-08' , `remark` = '' , `update_time` = '2024-05-19 15:11:28.537702' [ RunTime:0.000199s ] [2024-05-19T15:11:28+08:00][sql] SELECT * FROM `iqc_note` WHERE `iqc` = 2 AND `tpl_raw_info` = 53 LIMIT 1 [ RunTime:0.000270s ] [2024-05-19T15:11:28+08:00][sql] INSERT INTO `iqc_note` SET `iqc` = 2 , `tpl_raw_info` = 53 , `qc_count` = '50' , `count` = '50' , `note` = '1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,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-08' , `remark` = '' , `update_time` = '2024-05-19 15:11:28.538631' [ RunTime:0.000233s ] [2024-05-19T15:11:28+08:00][sql] SELECT * FROM `iqc` WHERE `an` = '3' AND `raw` = 3 LIMIT 1 [ RunTime:0.000262s ] [2024-05-19T15:11:28+08:00][sql] SELECT MAX(`number`) AS think_max FROM `iqc` WHERE `number` LIKE '20231108%' LIMIT 1 [ RunTime:0.000187s ] [2024-05-19T15:11:28+08:00][sql] SELECT `value` FROM `set` WHERE `field` = 'iqc_maker' LIMIT 1 [ RunTime:0.000336s ] [2024-05-19T15:11:28+08:00][sql] SELECT `value` FROM `set` WHERE `field` = 'iqc_ratif' LIMIT 1 [ RunTime:0.000385s ] [2024-05-19T15:11:28+08:00][sql] INSERT INTO `iqc` SET `number` = '20231108003' , `an` = '3' , `raw` = 3 , `supplier` = 3 , `count` = '50.00' , `result` = '1' , `maker` = 0 , `ratif` = 0 , `remark` = '' , `status` = 4 , `create_time` = '2023-11-08' , `update_time` = '2024-05-19 15:11:28.540774' [ RunTime:0.000312s ] [2024-05-19T15:11:28+08:00][sql] SELECT * FROM `tpl` WHERE `status` = 1 AND `tpl_sort` = '14' AND `sort` = 991 [ RunTime:0.000277s ] [2024-05-19T15:11:28+08:00][sql] SELECT * FROM `tpl_info` WHERE `tpl` = 9 ORDER BY `order` ASC [ RunTime:0.000335s ] [2024-05-19T15:11:28+08:00][sql] SELECT * FROM `iqc_note` WHERE `iqc` = 3 AND `tpl_raw_info` = 54 LIMIT 1 [ RunTime:0.000219s ] [2024-05-19T15:11:28+08:00][sql] INSERT INTO `iqc_note` SET `iqc` = 3 , `tpl_raw_info` = 54 , `qc_count` = '8' , `count` = '8' , `note` = '1,1,1,1,1,1,1,1,' , `ng` = '0' , `create_time` = '2023-11-08' , `remark` = '' , `update_time` = '2024-05-19 15:11:28.542836' [ RunTime:0.000308s ] [2024-05-19T15:11:28+08:00][sql] SELECT * FROM `iqc_note` WHERE `iqc` = 3 AND `tpl_raw_info` = 55 LIMIT 1 [ RunTime:0.000242s ] [2024-05-19T15:11:28+08:00][sql] INSERT INTO `iqc_note` SET `iqc` = 3 , `tpl_raw_info` = 55 , `qc_count` = '8' , `count` = '8' , `note` = '1,1,1,1,1,1,1,1,' , `ng` = '0' , `create_time` = '2023-11-08' , `remark` = '' , `update_time` = '2024-05-19 15:11:28.543773' [ RunTime:0.000296s ] [2024-05-19T15:11:28+08:00][sql] SELECT * FROM `iqc_note` WHERE `iqc` = 3 AND `tpl_raw_info` = 56 LIMIT 1 [ RunTime:0.000201s ] [2024-05-19T15:11:28+08:00][sql] INSERT INTO `iqc_note` SET `iqc` = 3 , `tpl_raw_info` = 56 , `qc_count` = '8' , `count` = '8' , `note` = '1,1,1,1,1,1,1,1,' , `ng` = '0' , `create_time` = '2023-11-08' , `remark` = '' , `update_time` = '2024-05-19 15:11:28.544651' [ RunTime:0.000955s ] [2024-05-19T15:11:28+08:00][sql] SELECT * FROM `iqc` WHERE `an` = '4' AND `raw` = 4 LIMIT 1 [ RunTime:0.000313s ] [2024-05-19T15:11:28+08:00][sql] SELECT MAX(`number`) AS think_max FROM `iqc` WHERE `number` LIKE '20231108%' LIMIT 1 [ RunTime:0.000215s ] [2024-05-19T15:11:28+08:00][sql] SELECT `value` FROM `set` WHERE `field` = 'iqc_maker' LIMIT 1 [ RunTime:0.000203s ] [2024-05-19T15:11:28+08:00][sql] SELECT `value` FROM `set` WHERE `field` = 'iqc_ratif' LIMIT 1 [ RunTime:0.000181s ] [2024-05-19T15:11:28+08:00][sql] INSERT INTO `iqc` SET `number` = '20231108004' , `an` = '4' , `raw` = 4 , `supplier` = 4 , `count` = '50.00' , `result` = '1' , `maker` = 0 , `ratif` = 0 , `remark` = '' , `status` = 4 , `create_time` = '2023-11-08' , `update_time` = '2024-05-19 15:11:28.547283' [ RunTime:0.000212s ] [2024-05-19T15:11:28+08:00][sql] SELECT * FROM `tpl` WHERE `status` = 1 AND `tpl_sort` = '14' AND `sort` = 992 [ RunTime:0.000219s ] [2024-05-19T15:11:28+08:00][sql] SELECT * FROM `tpl_info` WHERE `tpl` = 10 ORDER BY `order` ASC [ RunTime:0.000268s ] [2024-05-19T15:11:28+08:00][sql] SELECT * FROM `iqc_note` WHERE `iqc` = 4 AND `tpl_raw_info` = 57 LIMIT 1 [ RunTime:0.000297s ] [2024-05-19T15:11:28+08:00][sql] INSERT INTO `iqc_note` SET `iqc` = 4 , `tpl_raw_info` = 57 , `qc_count` = '8' , `count` = '8' , `note` = '1,1,1,1,1,1,1,1,' , `ng` = '0' , `create_time` = '2023-11-08' , `remark` = '' , `update_time` = '2024-05-19 15:11:28.549202' [ RunTime:0.000204s ] [2024-05-19T15:11:28+08:00][sql] SELECT * FROM `iqc_note` WHERE `iqc` = 4 AND `tpl_raw_info` = 58 LIMIT 1 [ RunTime:0.000283s ] [2024-05-19T15:11:28+08:00][sql] INSERT INTO `iqc_note` SET `iqc` = 4 , `tpl_raw_info` = 58 , `qc_count` = '8' , `count` = '8' , `note` = '1,1,1,1,1,1,1,1,' , `ng` = '0' , `create_time` = '2023-11-08' , `remark` = '' , `update_time` = '2024-05-19 15:11:28.550103' [ RunTime:0.000164s ] [2024-05-19T15:11:28+08:00][sql] SELECT * FROM `iqc` WHERE `an` = '5' AND `raw` = 5 LIMIT 1 [ RunTime:0.000197s ] [2024-05-19T15:11:28+08:00][sql] SELECT MAX(`number`) AS think_max FROM `iqc` WHERE `number` LIKE '20231108%' LIMIT 1 [ RunTime:0.000250s ] [2024-05-19T15:11:28+08:00][sql] SELECT `value` FROM `set` WHERE `field` = 'iqc_maker' LIMIT 1 [ RunTime:0.000178s ] [2024-05-19T15:11:28+08:00][sql] SELECT `value` FROM `set` WHERE `field` = 'iqc_ratif' LIMIT 1 [ RunTime:0.000177s ] [2024-05-19T15:11:28+08:00][sql] INSERT INTO `iqc` SET `number` = '20231108005' , `an` = '5' , `raw` = 5 , `supplier` = 5 , `count` = '50.00' , `result` = '1' , `maker` = 0 , `ratif` = 0 , `remark` = '' , `status` = 4 , `create_time` = '2023-11-08' , `update_time` = '2024-05-19 15:11:28.551864' [ RunTime:0.000304s ] [2024-05-19T15:11:28+08:00][sql] SELECT * FROM `tpl` WHERE `status` = 1 AND `tpl_sort` = '14' AND `sort` = 399 [ RunTime:0.000229s ] [2024-05-19T15:11:28+08:00][sql] SELECT * FROM `tpl_info` WHERE `tpl` = 6 ORDER BY `order` ASC [ RunTime:0.000330s ] [2024-05-19T15:11:28+08:00][sql] SELECT * FROM `iqc_note` WHERE `iqc` = 5 AND `tpl_raw_info` = 44 LIMIT 1 [ RunTime:0.000306s ] [2024-05-19T15:11:28+08:00][sql] INSERT INTO `iqc_note` SET `iqc` = 5 , `tpl_raw_info` = 44 , `qc_count` = '8' , `count` = '8' , `note` = '1,1,1,1,1,1,1,1,' , `ng` = '0' , `create_time` = '2023-11-08' , `remark` = '' , `update_time` = '2024-05-19 15:11:28.553958' [ RunTime:0.000207s ] [2024-05-19T15:11:28+08:00][sql] SELECT * FROM `iqc_note` WHERE `iqc` = 5 AND `tpl_raw_info` = 45 LIMIT 1 [ RunTime:0.000316s ] [2024-05-19T15:11:28+08:00][sql] INSERT INTO `iqc_note` SET `iqc` = 5 , `tpl_raw_info` = 45 , `qc_count` = '8' , `count` = '8' , `note` = '1,1,1,1,1,1,1,1,' , `ng` = '0' , `create_time` = '2023-11-08' , `remark` = '' , `update_time` = '2024-05-19 15:11:28.554895' [ RunTime:0.000202s ] [2024-05-19T15:11:28+08:00][sql] SELECT * FROM `iqc_note` WHERE `iqc` = 5 AND `tpl_raw_info` = 46 LIMIT 1 [ RunTime:0.000208s ] [2024-05-19T15:11:28+08:00][sql] INSERT INTO `iqc_note` SET `iqc` = 5 , `tpl_raw_info` = 46 , `qc_count` = '8' , `count` = '8' , `note` = '1,1,1,1,1,1,1,1,' , `ng` = '0' , `create_time` = '2023-11-08' , `remark` = '' , `update_time` = '2024-05-19 15:11:28.555834' [ RunTime:0.000171s ] [2024-05-19T15:11:28+08:00][sql] SELECT * FROM `iqc_note` WHERE `iqc` = 5 AND `tpl_raw_info` = 47 LIMIT 1 [ RunTime:0.000211s ] [2024-05-19T15:11:28+08:00][sql] INSERT INTO `iqc_note` SET `iqc` = 5 , `tpl_raw_info` = 47 , `qc_count` = '8' , `count` = '8' , `note` = '1,1,1,1,1,1,1,1,' , `ng` = '0' , `create_time` = '2023-11-08' , `remark` = '' , `update_time` = '2024-05-19 15:11:28.556641' [ RunTime:0.000179s ] [2024-05-19T15:11:28+08:00][sql] CONNECT:[ UseTime:0.010132s ] mysql:host=127.0.0.1;port=3306;dbname=ahwtxhgdkj;charset=utf8 [2024-05-19T15:11:28+08:00][sql] SHOW FULL COLUMNS FROM `set` [ RunTime:0.000700s ] [2024-05-19T15:11:28+08:00][sql] UPDATE `set` SET `value` = 'ahwtxhgdkj' WHERE `field` = 'database' [ RunTime:0.000268s ] [2024-05-19T15:11:28+08:00][sql] UPDATE `set` SET `value` = '安徽皖投新辉光电科技有限公司' WHERE `field` = 'title' [ RunTime:0.000240s ] [2024-05-19T15:11:28+08:00][sql] UPDATE `set` SET `value` = '391' WHERE `field` = 'product_sort' [ RunTime:0.000179s ] [2024-05-19T15:11:28+08:00][sql] SHOW FULL COLUMNS FROM `an` [ RunTime:0.001152s ] [2024-05-19T15:11:28+08:00][sql] SELECT * FROM `an` WHERE `id` IN (1,2,3,4,5) [ RunTime:0.000275s ] [2024-05-19T15:11:28+08:00][sql] SHOW FULL COLUMNS FROM `iqc` [ RunTime:0.001024s ] [2024-05-19T15:11:28+08:00][sql] SELECT * FROM `iqc` WHERE `an` IN ('1','2','3','4','5') [ RunTime:0.000361s ] [2024-05-19T15:11:28+08:00][sql] SELECT `value` FROM `set` WHERE `field` = 'pass_man' LIMIT 1 [ RunTime:0.000228s ] [2024-05-19T15:11:28+08:00][sql] SELECT `value` FROM `set` WHERE `field` = 'put_man' LIMIT 1 [ RunTime:0.000311s ] [2024-05-19T15:11:28+08:00][sql] SHOW FULL COLUMNS FROM `in` [ RunTime:0.001427s ] [2024-05-19T15:11:28+08:00][sql] SELECT * FROM `in` WHERE `raw` = 1 AND `an` = 1 LIMIT 1 [ RunTime:0.000283s ] [2024-05-19T15:11:28+08:00][sql] SELECT MAX(`number`) AS think_max FROM `in` WHERE `number` LIKE '20231107%' LIMIT 1 [ RunTime:0.000294s ] [2024-05-19T15:11:28+08:00][sql] INSERT INTO `in` SET `number` = '20231107001' , `raw` = 1 , `count` = 50.00 , `supplier` = 1 , `an` = 1 , `po` = 1 , `iqc` = 1 , `create_time` = '2023-11-08 00:00:00' , `pass_man` = 0 , `put_man` = 0 , `update_time` = '2024-05-19 15:11:28.711277' [ RunTime:0.000326s ] [2024-05-19T15:11:28+08:00][sql] SELECT * FROM `in` WHERE `raw` = 2 AND `an` = 2 LIMIT 1 [ RunTime:0.000315s ] [2024-05-19T15:11:28+08:00][sql] SELECT MAX(`number`) AS think_max FROM `in` WHERE `number` LIKE '20231107%' LIMIT 1 [ RunTime:0.000192s ] [2024-05-19T15:11:28+08:00][sql] INSERT INTO `in` SET `number` = '20231107002' , `raw` = 2 , `count` = 300.00 , `supplier` = 2 , `an` = 2 , `po` = 2 , `iqc` = 2 , `create_time` = '2023-11-08 00:00:00' , `pass_man` = 0 , `put_man` = 0 , `update_time` = '2024-05-19 15:11:28.712669' [ RunTime:0.000202s ] [2024-05-19T15:11:28+08:00][sql] SELECT * FROM `in` WHERE `raw` = 3 AND `an` = 3 LIMIT 1 [ RunTime:0.000247s ] [2024-05-19T15:11:28+08:00][sql] SELECT MAX(`number`) AS think_max FROM `in` WHERE `number` LIKE '20231107%' LIMIT 1 [ RunTime:0.000228s ] [2024-05-19T15:11:28+08:00][sql] INSERT INTO `in` SET `number` = '20231107003' , `raw` = 3 , `count` = 50.00 , `supplier` = 3 , `an` = 3 , `po` = 3 , `iqc` = 3 , `create_time` = '2023-11-08 00:00:00' , `pass_man` = 0 , `put_man` = 0 , `update_time` = '2024-05-19 15:11:28.713822' [ RunTime:0.000186s ] [2024-05-19T15:11:28+08:00][sql] SELECT * FROM `in` WHERE `raw` = 4 AND `an` = 4 LIMIT 1 [ RunTime:0.000210s ] [2024-05-19T15:11:28+08:00][sql] SELECT MAX(`number`) AS think_max FROM `in` WHERE `number` LIKE '20231107%' LIMIT 1 [ RunTime:0.000280s ] [2024-05-19T15:11:28+08:00][sql] INSERT INTO `in` SET `number` = '20231107004' , `raw` = 4 , `count` = 50.00 , `supplier` = 4 , `an` = 4 , `po` = 4 , `iqc` = 4 , `create_time` = '2023-11-08 00:00:00' , `pass_man` = 0 , `put_man` = 0 , `update_time` = '2024-05-19 15:11:28.715056' [ RunTime:0.000224s ] [2024-05-19T15:11:28+08:00][sql] SELECT * FROM `in` WHERE `raw` = 5 AND `an` = 5 LIMIT 1 [ RunTime:0.000304s ] [2024-05-19T15:11:28+08:00][sql] SELECT MAX(`number`) AS think_max FROM `in` WHERE `number` LIKE '20231107%' LIMIT 1 [ RunTime:0.000182s ] [2024-05-19T15:11:28+08:00][sql] INSERT INTO `in` SET `number` = '20231107005' , `raw` = 5 , `count` = 50.00 , `supplier` = 5 , `an` = 5 , `po` = 5 , `iqc` = 5 , `create_time` = '2023-11-08 00:00:00' , `pass_man` = 0 , `put_man` = 0 , `update_time` = '2024-05-19 15:11:28.716239' [ RunTime:0.000195s ] [2024-05-19T15:11:28+08:00][sql] CONNECT:[ UseTime:0.010970s ] mysql:host=127.0.0.1;port=3306;dbname=ahwtxhgdkj;charset=utf8 [2024-05-19T15:11:28+08:00][sql] SHOW FULL COLUMNS FROM `set` [ RunTime:0.000749s ] [2024-05-19T15:11:28+08:00][sql] UPDATE `set` SET `value` = 'ahwtxhgdkj' WHERE `field` = 'database' [ RunTime:0.000268s ] [2024-05-19T15:11:28+08:00][sql] UPDATE `set` SET `value` = '安徽皖投新辉光电科技有限公司' WHERE `field` = 'title' [ RunTime:0.000197s ] [2024-05-19T15:11:28+08:00][sql] UPDATE `set` SET `value` = '391' WHERE `field` = 'product_sort' [ RunTime:0.000185s ] [2024-05-19T15:11:28+08:00][sql] SHOW FULL COLUMNS FROM `pp` [ RunTime:0.001064s ] [2024-05-19T15:11:28+08:00][sql] SELECT * FROM `pp` WHERE `id` = 1 [ RunTime:0.000255s ] [2024-05-19T15:11:28+08:00][sql] SHOW FULL COLUMNS FROM `in` [ RunTime:0.000955s ] [2024-05-19T15:11:28+08:00][sql] SELECT MIN(`create_time`) AS think_min FROM `in` WHERE `id` IN (1,2,3,4,5) LIMIT 1 [ RunTime:0.000356s ] [2024-05-19T15:11:28+08:00][sql] SELECT `value` FROM `set` WHERE `field` = 'mo_maker' LIMIT 1 [ RunTime:0.000259s ] [2024-05-19T15:11:28+08:00][sql] SELECT `value` FROM `set` WHERE `field` = 'mo_ratif' LIMIT 1 [ RunTime:0.000190s ] [2024-05-19T15:11:28+08:00][sql] SHOW FULL COLUMNS FROM `mo` [ RunTime:0.001289s ] [2024-05-19T15:11:28+08:00][sql] SELECT * FROM `mo` WHERE `product` = 1 AND `pp` = '1' LIMIT 1 [ RunTime:0.000267s ] [2024-05-19T15:11:28+08:00][sql] SELECT `value` FROM `set` WHERE `field` = 'pp_base' LIMIT 1 [ RunTime:0.000210s ] [2024-05-19T15:11:28+08:00][sql] SELECT MAX(`number`) AS think_max FROM `mo` WHERE `number` LIKE '20231109%' LIMIT 1 [ RunTime:0.000180s ] [2024-05-19T15:11:28+08:00][sql] INSERT INTO `mo` SET `number` = '20231109001' , `status` = 11 , `product` = 1 , `count` = 12 , `plan_count` = 12.6 , `pmr_step` = 0 , `cpp_step` = 0 , `mo_step` = 0 , `remark` = '' , `create_time` = '2023-11-09' , `so` = '1' , `pp` = '1' , `cpp_status` = 2 , `pqc_status` = 2 , `fqc_status` = 2 , `oqc_status` = 2 , `end_count` = 12.6 , `maker` = 0 , `ratif` = 0 , `update_time` = '2024-05-19 15:11:28.863877' [ RunTime:0.000282s ] [2024-05-19T15:11:29+08:00][sql] CONNECT:[ UseTime:0.010550s ] mysql:host=127.0.0.1;port=3306;dbname=ahwtxhgdkj;charset=utf8 [2024-05-19T15:11:29+08:00][sql] SHOW FULL COLUMNS FROM `set` [ RunTime:0.000690s ] [2024-05-19T15:11:29+08:00][sql] UPDATE `set` SET `value` = 'ahwtxhgdkj' WHERE `field` = 'database' [ RunTime:0.000282s ] [2024-05-19T15:11:29+08:00][sql] UPDATE `set` SET `value` = '安徽皖投新辉光电科技有限公司' WHERE `field` = 'title' [ RunTime:0.000198s ] [2024-05-19T15:11:29+08:00][sql] UPDATE `set` SET `value` = '391' WHERE `field` = 'product_sort' [ RunTime:0.000254s ] [2024-05-19T15:11:29+08:00][sql] SHOW FULL COLUMNS FROM `mo` [ RunTime:0.001030s ] [2024-05-19T15:11:29+08:00][sql] SELECT * FROM `mo` WHERE `id` = 1 [ RunTime:0.000290s ] [2024-05-19T15:11:29+08:00][sql] SELECT `value` FROM `set` WHERE `field` = 'raw_man' LIMIT 1 [ RunTime:0.000215s ] [2024-05-19T15:11:29+08:00][sql] SELECT `value` FROM `set` WHERE `field` = 'put_man' LIMIT 1 [ RunTime:0.000198s ] [2024-05-19T15:11:29+08:00][sql] SHOW FULL COLUMNS FROM `sp` [ RunTime:0.001129s ] [2024-05-19T15:11:29+08:00][sql] SELECT * FROM `sp` WHERE `mo` = 1 AND `product` = 1 LIMIT 1 [ RunTime:0.000243s ] [2024-05-19T15:11:29+08:00][sql] INSERT INTO `sp` SET `mo` = 1 , `product` = 1 , `status` = 2 , `raw_man` = 0 , `create_time` = '2023-11-09 00:00:00' , `put_man` = 0 , `update_time` = '2024-05-19 15:11:29.020915' [ RunTime:0.000249s ] [2024-05-19T15:11:29+08:00][sql] SHOW FULL COLUMNS FROM `bom` [ RunTime:0.000899s ] [2024-05-19T15:11:29+08:00][sql] SELECT * FROM `bom` WHERE `product` = 1 LIMIT 1 [ RunTime:0.000254s ] [2024-05-19T15:11:29+08:00][sql] SHOW FULL COLUMNS FROM `bom_info` [ RunTime:0.000931s ] [2024-05-19T15:11:29+08:00][sql] SELECT * FROM `bom_info` WHERE `bom` = 1 [ RunTime:0.000411s ] [2024-05-19T15:11:29+08:00][sql] SHOW FULL COLUMNS FROM `out` [ RunTime:0.001401s ] [2024-05-19T15:11:29+08:00][sql] SELECT * FROM `out` WHERE `sp` = 1 AND `raw` = 1 LIMIT 1 [ RunTime:0.000298s ] [2024-05-19T15:11:29+08:00][sql] INSERT INTO `out` SET `sp` = 1 , `raw` = 1 , `supplier` = NULL , `count` = '12' , `out_count` = '12' , `unit` = '' , `status` = 1 , `create_time` = '2023-11-09 00:00:00' , `out_time` = NULL , `put_man` = 0 , `update_time` = '2024-05-19 15:11:29.047841' [ RunTime:0.000390s ] [2024-05-19T15:11:29+08:00][sql] SELECT * FROM `out` WHERE `sp` = 1 AND `raw` = 2 LIMIT 1 [ RunTime:0.000210s ] [2024-05-19T15:11:29+08:00][sql] INSERT INTO `out` SET `sp` = 1 , `raw` = 2 , `supplier` = NULL , `count` = '48' , `out_count` = '48' , `unit` = '' , `status` = 1 , `create_time` = '2023-11-09 00:00:00' , `out_time` = NULL , `put_man` = 0 , `update_time` = '2024-05-19 15:11:29.048929' [ RunTime:0.000308s ] [2024-05-19T15:11:29+08:00][sql] SELECT * FROM `out` WHERE `sp` = 1 AND `raw` = 3 LIMIT 1 [ RunTime:0.000248s ] [2024-05-19T15:11:29+08:00][sql] INSERT INTO `out` SET `sp` = 1 , `raw` = 3 , `supplier` = NULL , `count` = '12' , `out_count` = '12' , `unit` = '' , `status` = 1 , `create_time` = '2023-11-09 00:00:00' , `out_time` = NULL , `put_man` = 0 , `update_time` = '2024-05-19 15:11:29.049910' [ RunTime:0.000288s ] [2024-05-19T15:11:29+08:00][sql] SELECT * FROM `out` WHERE `sp` = 1 AND `raw` = 4 LIMIT 1 [ RunTime:0.000322s ] [2024-05-19T15:11:29+08:00][sql] INSERT INTO `out` SET `sp` = 1 , `raw` = 4 , `supplier` = NULL , `count` = '12' , `out_count` = '12' , `unit` = '' , `status` = 1 , `create_time` = '2023-11-09 00:00:00' , `out_time` = NULL , `put_man` = 0 , `update_time` = '2024-05-19 15:11:29.050938' [ RunTime:0.000239s ] [2024-05-19T15:11:29+08:00][sql] SELECT * FROM `out` WHERE `sp` = 1 AND `raw` = 5 LIMIT 1 [ RunTime:0.000204s ] [2024-05-19T15:11:29+08:00][sql] INSERT INTO `out` SET `sp` = 1 , `raw` = 5 , `supplier` = NULL , `count` = '12' , `out_count` = '12' , `unit` = '' , `status` = 1 , `create_time` = '2023-11-09 00:00:00' , `out_time` = NULL , `put_man` = 0 , `update_time` = '2024-05-19 15:11:29.051791' [ RunTime:0.000195s ] [2024-05-19T15:11:29+08:00][sql] CONNECT:[ UseTime:0.010490s ] mysql:host=127.0.0.1;port=3306;dbname=ahwtxhgdkj;charset=utf8 [2024-05-19T15:11:29+08:00][sql] SHOW FULL COLUMNS FROM `set` [ RunTime:0.000630s ] [2024-05-19T15:11:29+08:00][sql] UPDATE `set` SET `value` = 'ahwtxhgdkj' WHERE `field` = 'database' [ RunTime:0.000265s ] [2024-05-19T15:11:29+08:00][sql] UPDATE `set` SET `value` = '安徽皖投新辉光电科技有限公司' WHERE `field` = 'title' [ RunTime:0.000197s ] [2024-05-19T15:11:29+08:00][sql] UPDATE `set` SET `value` = '391' WHERE `field` = 'product_sort' [ RunTime:0.000175s ] [2024-05-19T15:11:29+08:00][sql] CONNECT:[ UseTime:0.000862s ] mysql:host=127.0.0.1;port=3306;dbname=ahwtxhgdkj;charset=utf8 [2024-05-19T15:11:29+08:00][sql] SHOW FULL COLUMNS FROM `set` [ RunTime:0.000764s ] [2024-05-19T15:11:29+08:00][sql] UPDATE `set` SET `value` = 'ahwtxhgdkj' WHERE `field` = 'database' [ RunTime:0.000287s ] [2024-05-19T15:11:29+08:00][sql] UPDATE `set` SET `value` = '安徽皖投新辉光电科技有限公司' WHERE `field` = 'title' [ RunTime:0.000320s ] [2024-05-19T15:11:29+08:00][sql] UPDATE `set` SET `value` = '391' WHERE `field` = 'product_sort' [ RunTime:0.000179s ] [2024-05-19T15:11:29+08:00][sql] SHOW FULL COLUMNS FROM `mo` [ RunTime:0.001304s ] [2024-05-19T15:11:29+08:00][sql] SELECT * FROM `mo` WHERE `id` = 1 [ RunTime:0.000413s ] [2024-05-19T15:11:29+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.000563s ] [2024-05-19T15:11:29+08:00][sql] SELECT * FROM `product` WHERE `id` = 1 [ RunTime:0.000238s ] [2024-05-19T15:11:29+08:00][sql] SELECT `value` FROM `set` WHERE `field` = 'pmr_maker' LIMIT 1 [ RunTime:0.000211s ] [2024-05-19T15:11:29+08:00][sql] SHOW FULL COLUMNS FROM `tpl` [ RunTime:0.000574s ] [2024-05-19T15:11:29+08:00][sql] SELECT * FROM `tpl` WHERE `status` = 1 AND `tpl_sort` = '12' AND `sort` = 391 [ RunTime:0.000252s ] [2024-05-19T15:11:29+08:00][sql] SHOW FULL COLUMNS FROM `tpl_info` [ RunTime:0.000938s ] [2024-05-19T15:11:29+08:00][sql] SELECT * FROM `tpl_info` WHERE `tpl` = 4 ORDER BY `order` ASC [ RunTime:0.000327s ] [2024-05-19T15:11:29+08:00][sql] SHOW FULL COLUMNS FROM `pmr` [ RunTime:0.001284s ] [2024-05-19T15:11:29+08:00][sql] SELECT * FROM `pmr` WHERE `mo` = 1 AND `product` = 1 AND `tpl_info` = 37 LIMIT 1 [ RunTime:0.000253s ] [2024-05-19T15:11:29+08:00][sql] INSERT INTO `pmr` SET `mo` = 1 , `product` = 1 , `tpl_info` = 37 , `count` = 12 , `ng` = 0 , `create_time` = '2023-11-09' , `test` = 'PCB工装测试' , `req` = '自制工装通电测试无异常' , `step` = '' , `maker` = 0 , `update_time` = '2024-05-19 15:11:29.355153' [ RunTime:0.000274s ] [2024-05-19T15:11:29+08:00][sql] SELECT * FROM `pmr` WHERE `mo` = 1 AND `product` = 1 AND `tpl_info` = 38 LIMIT 1 [ RunTime:0.000209s ] [2024-05-19T15:11:29+08:00][sql] INSERT INTO `pmr` SET `mo` = 1 , `product` = 1 , `tpl_info` = 38 , `count` = 12 , `ng` = 0 , `create_time` = '2023-11-09' , `test` = '装配' , `req` = '装配到位，螺丝锁紧无缺失' , `step` = '' , `maker` = 0 , `update_time` = '2024-05-19 15:11:29.356221' [ RunTime:0.000204s ] [2024-05-19T15:11:29+08:00][sql] SELECT * FROM `pmr` WHERE `mo` = 1 AND `product` = 1 AND `tpl_info` = 39 LIMIT 1 [ RunTime:0.000239s ] [2024-05-19T15:11:29+08:00][sql] INSERT INTO `pmr` SET `mo` = 1 , `product` = 1 , `tpl_info` = 39 , `count` = 12 , `ng` = 0 , `create_time` = '2023-11-09' , `test` = '标定' , `req` = '产品报警浓度值和分析仪的显示浓度差不能超过3%' , `step` = '' , `maker` = 0 , `update_time` = '2024-05-19 15:11:29.357109' [ RunTime:0.000278s ] [2024-05-19T15:11:29+08:00][sql] SELECT * FROM `pmr` WHERE `mo` = 1 AND `product` = 1 AND `tpl_info` = 40 LIMIT 1 [ RunTime:0.000230s ] [2024-05-19T15:11:29+08:00][sql] INSERT INTO `pmr` SET `mo` = 1 , `product` = 1 , `tpl_info` = 40 , `count` = 12 , `ng` = 0 , `create_time` = '2023-11-09' , `test` = '老化' , `req` = '老化24小时，功能无异常' , `step` = '' , `maker` = 0 , `update_time` = '2024-05-19 15:11:29.358030' [ RunTime:0.000179s ] [2024-05-19T15:11:29+08:00][sql] SELECT * FROM `pmr` WHERE `mo` = 1 AND `product` = 1 AND `tpl_info` = 41 LIMIT 1 [ RunTime:0.000201s ] [2024-05-19T15:11:29+08:00][sql] INSERT INTO `pmr` SET `mo` = 1 , `product` = 1 , `tpl_info` = 41 , `count` = 12 , `ng` = 0 , `create_time` = '2023-11-09' , `test` = '包装' , `req` = '装入说明书等配件' , `step` = '' , `maker` = 0 , `update_time` = '2024-05-19 15:11:29.358909' [ RunTime:0.000183s ] [2024-05-19T15:11:29+08:00][sql] CONNECT:[ UseTime:0.010820s ] mysql:host=127.0.0.1;port=3306;dbname=ahwtxhgdkj;charset=utf8 [2024-05-19T15:11:29+08:00][sql] SHOW FULL COLUMNS FROM `set` [ RunTime:0.000701s ] [2024-05-19T15:11:29+08:00][sql] UPDATE `set` SET `value` = 'ahwtxhgdkj' WHERE `field` = 'database' [ RunTime:0.000319s ] [2024-05-19T15:11:29+08:00][sql] UPDATE `set` SET `value` = '安徽皖投新辉光电科技有限公司' WHERE `field` = 'title' [ RunTime:0.000235s ] [2024-05-19T15:11:29+08:00][sql] UPDATE `set` SET `value` = '391' WHERE `field` = 'product_sort' [ RunTime:0.000177s ] [2024-05-19T15:11:29+08:00][sql] SHOW FULL COLUMNS FROM `mo` [ RunTime:0.001124s ] [2024-05-19T15:11:29+08:00][sql] SELECT * FROM `mo` WHERE `id` = 1 [ RunTime:0.000247s ] [2024-05-19T15:11:29+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.000924s ] [2024-05-19T15:11:29+08:00][sql] SELECT * FROM `product` WHERE `id` = 1 [ RunTime:0.000252s ] [2024-05-19T15:11:29+08:00][sql] SHOW FULL COLUMNS FROM `tpl` [ RunTime:0.000555s ] [2024-05-19T15:11:29+08:00][sql] SELECT * FROM `tpl` WHERE `status` = 1 AND `tpl_sort` = '13' AND `sort` = 391 [ RunTime:0.000241s ] [2024-05-19T15:11:29+08:00][sql] SHOW FULL COLUMNS FROM `tpl_info` [ RunTime:0.000614s ] [2024-05-19T15:11:29+08:00][sql] SELECT * FROM `tpl_info` WHERE `tpl` = 5 ORDER BY `order` ASC [ RunTime:0.000314s ] [2024-05-19T15:11:29+08:00][sql] SHOW FULL COLUMNS FROM `cpp` [ RunTime:0.001272s ] [2024-05-19T15:11:29+08:00][sql] SELECT * FROM `cpp` WHERE `mo` = 1 AND `tpl_info` = 42 LIMIT 1 [ RunTime:0.000252s ] [2024-05-19T15:11:29+08:00][sql] SELECT `value` FROM `set` WHERE `field` = 'cpp_maker' LIMIT 1 [ RunTime:0.000225s ] [2024-05-19T15:11:29+08:00][sql] INSERT INTO `cpp` SET `mo` = 1 , `product` = '1' , `tpl_info` = 42 , `note` = '3,3,3,3,3,3,3,3,3,3,3,3' , `step` = '' , `maker` = 0 , `create_time` = '2023-11-09' , `update_time` = '2024-05-19 15:11:29.527165' [ RunTime:0.000351s ] [2024-05-19T15:11:29+08:00][sql] SELECT * FROM `cpp` WHERE `mo` = 1 AND `tpl_info` = 43 LIMIT 1 [ RunTime:0.000201s ] [2024-05-19T15:11:29+08:00][sql] SELECT `value` FROM `set` WHERE `field` = 'cpp_maker' LIMIT 1 [ RunTime:0.000338s ] [2024-05-19T15:11:29+08:00][sql] INSERT INTO `cpp` SET `mo` = 1 , `product` = '1' , `tpl_info` = 43 , `note` = '350,350,350,350,350,350,350,350,350,350,350,350' , `step` = '' , `maker` = 0 , `create_time` = '2023-11-09' , `update_time` = '2024-05-19 15:11:29.528656' [ RunTime:0.000270s ] [2024-05-19T15:11:29+08:00][sql] CONNECT:[ UseTime:0.011067s ] mysql:host=127.0.0.1;port=3306;dbname=ahwtxhgdkj;charset=utf8 [2024-05-19T15:11:29+08:00][sql] SHOW FULL COLUMNS FROM `set` [ RunTime:0.000673s ] [2024-05-19T15:11:29+08:00][sql] UPDATE `set` SET `value` = 'ahwtxhgdkj' WHERE `field` = 'database' [ RunTime:0.000309s ] [2024-05-19T15:11:29+08:00][sql] UPDATE `set` SET `value` = '安徽皖投新辉光电科技有限公司' WHERE `field` = 'title' [ RunTime:0.000201s ] [2024-05-19T15:11:29+08:00][sql] UPDATE `set` SET `value` = '391' WHERE `field` = 'product_sort' [ RunTime:0.000298s ] [2024-05-19T15:11:29+08:00][sql] SHOW FULL COLUMNS FROM `mo` [ RunTime:0.001152s ] [2024-05-19T15:11:29+08:00][sql] SELECT * FROM `mo` WHERE `id` = 1 [ RunTime:0.000319s ] [2024-05-19T15:11:29+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.000570s ] [2024-05-19T15:11:29+08:00][sql] SELECT * FROM `product` WHERE `id` = 1 [ RunTime:0.000234s ] [2024-05-19T15:11:29+08:00][sql] SELECT `value` FROM `set` WHERE `field` = 'capacity' LIMIT 1 [ RunTime:0.000233s ] [2024-05-19T15:11:29+08:00][sql] SELECT `value` FROM `set` WHERE `field` = 'pqc_maker' LIMIT 1 [ RunTime:0.000246s ] [2024-05-19T15:11:29+08:00][sql] SHOW FULL COLUMNS FROM `tpl` [ RunTime:0.000934s ] [2024-05-19T15:11:29+08:00][sql] SELECT * FROM `tpl` WHERE `status` = 1 AND `tpl_sort` = '6' AND `sort` = 391 [ RunTime:0.000298s ] [2024-05-19T15:11:29+08:00][sql] SHOW FULL COLUMNS FROM `tpl_info` [ RunTime:0.000962s ] [2024-05-19T15:11:29+08:00][sql] SELECT * FROM `tpl_info` WHERE `tpl` = 1 ORDER BY `order` ASC [ RunTime:0.000320s ] [2024-05-19T15:11:29+08:00][sql] SHOW FULL COLUMNS FROM `pqc` [ RunTime:0.001199s ] [2024-05-19T15:11:29+08:00][sql] SELECT * FROM `pqc` WHERE `mo` = 1 AND `tpl_info` = 1 LIMIT 1 [ RunTime:0.000246s ] [2024-05-19T15:11:29+08:00][sql] INSERT INTO `pqc` SET `mo` = 1 , `product` = 1 , `tpl_info` = 1 , `qc_count` = 1 , `note` = '1' , `result` = 1 , `status` = 1 , `create_time` = '2023-11-09' , `maker` = 0 , `update_time` = '2024-05-19 15:11:29.689372' [ RunTime:0.000299s ] [2024-05-19T15:11:29+08:00][sql] SELECT * FROM `pqc` WHERE `mo` = 1 AND `tpl_info` = 2 LIMIT 1 [ RunTime:0.000203s ] [2024-05-19T15:11:29+08:00][sql] INSERT INTO `pqc` SET `mo` = 1 , `product` = 1 , `tpl_info` = 2 , `qc_count` = 1 , `note` = '1' , `result` = 1 , `status` = 1 , `create_time` = '2023-11-09' , `maker` = 0 , `update_time` = '2024-05-19 15:11:29.690610' [ RunTime:0.000202s ] [2024-05-19T15:11:29+08:00][sql] SELECT * FROM `pqc` WHERE `mo` = 1 AND `tpl_info` = 3 LIMIT 1 [ RunTime:0.000274s ] [2024-05-19T15:11:29+08:00][sql] INSERT INTO `pqc` SET `mo` = 1 , `product` = 1 , `tpl_info` = 3 , `qc_count` = 1 , `note` = '1' , `result` = 1 , `status` = 1 , `create_time` = '2023-11-09' , `maker` = 0 , `update_time` = '2024-05-19 15:11:29.691524' [ RunTime:0.000232s ] [2024-05-19T15:11:29+08:00][sql] SELECT * FROM `pqc` WHERE `mo` = 1 AND `tpl_info` = 4 LIMIT 1 [ RunTime:0.000231s ] [2024-05-19T15:11:29+08:00][sql] INSERT INTO `pqc` SET `mo` = 1 , `product` = 1 , `tpl_info` = 4 , `qc_count` = 1 , `note` = '1' , `result` = 1 , `status` = 1 , `create_time` = '2023-11-09' , `maker` = 0 , `update_time` = '2024-05-19 15:11:29.692509' [ RunTime:0.000225s ] [2024-05-19T15:11:29+08:00][sql] CONNECT:[ UseTime:0.011092s ] mysql:host=127.0.0.1;port=3306;dbname=ahwtxhgdkj;charset=utf8 [2024-05-19T15:11:29+08:00][sql] SHOW FULL COLUMNS FROM `set` [ RunTime:0.000991s ] [2024-05-19T15:11:29+08:00][sql] UPDATE `set` SET `value` = 'ahwtxhgdkj' WHERE `field` = 'database' [ RunTime:0.000421s ] [2024-05-19T15:11:29+08:00][sql] UPDATE `set` SET `value` = '安徽皖投新辉光电科技有限公司' WHERE `field` = 'title' [ RunTime:0.000209s ] [2024-05-19T15:11:29+08:00][sql] UPDATE `set` SET `value` = '391' WHERE `field` = 'product_sort' [ RunTime:0.000180s ] [2024-05-19T15:11:29+08:00][sql] SHOW FULL COLUMNS FROM `mo` [ RunTime:0.001078s ] [2024-05-19T15:11:29+08:00][sql] SELECT * FROM `mo` WHERE `id` = 1 [ RunTime:0.000254s ] [2024-05-19T15:11:29+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.000964s ] [2024-05-19T15:11:29+08:00][sql] SELECT * FROM `product` WHERE `id` = 1 [ RunTime:0.000242s ] [2024-05-19T15:11:29+08:00][sql] SHOW FULL COLUMNS FROM `fqc` [ RunTime:0.001385s ] [2024-05-19T15:11:29+08:00][sql] SELECT `number` FROM `fqc` WHERE `create_time` >= '2023-11-09 00:00:00' [ RunTime:0.000223s ] [2024-05-19T15:11:29+08:00][sql] SHOW FULL COLUMNS FROM `tpl` [ RunTime:0.000705s ] [2024-05-19T15:11:29+08:00][sql] SELECT * FROM `tpl` WHERE `status` = 1 AND `tpl_sort` = '7' AND `sort` = 391 [ RunTime:0.000274s ] [2024-05-19T15:11:29+08:00][sql] SHOW FULL COLUMNS FROM `tpl_info` [ RunTime:0.001070s ] [2024-05-19T15:11:29+08:00][sql] SELECT * FROM `tpl_info` WHERE `tpl` = 2 ORDER BY `order` ASC [ RunTime:0.000309s ] [2024-05-19T15:11:29+08:00][sql] SELECT `value` FROM `set` WHERE `field` = 'fqc_maker' LIMIT 1 [ RunTime:0.000269s ] [2024-05-19T15:11:29+08:00][sql] SELECT `value` FROM `set` WHERE `field` = 'fqc_maker' LIMIT 1 [ RunTime:0.000304s ] [2024-05-19T15:11:29+08:00][sql] SELECT `value` FROM `set` WHERE `field` = 'fqc_maker' LIMIT 1 [ RunTime:0.000189s ] [2024-05-19T15:11:29+08:00][sql] SELECT `value` FROM `set` WHERE `field` = 'fqc_maker' LIMIT 1 [ RunTime:0.000179s ] [2024-05-19T15:11:29+08:00][sql] SELECT `value` FROM `set` WHERE `field` = 'fqc_maker' LIMIT 1 [ RunTime:0.000286s ] [2024-05-19T15:11:29+08:00][sql] SELECT `value` FROM `set` WHERE `field` = 'fqc_maker' LIMIT 1 [ RunTime:0.000179s ] [2024-05-19T15:11:29+08:00][sql] SELECT `value` FROM `set` WHERE `field` = 'fqc_maker' LIMIT 1 [ RunTime:0.000284s ] [2024-05-19T15:11:29+08:00][sql] SELECT `value` FROM `set` WHERE `field` = 'fqc_maker' LIMIT 1 [ RunTime:0.000184s ] [2024-05-19T15:11:29+08:00][sql] SELECT `value` FROM `set` WHERE `field` = 'fqc_maker' LIMIT 1 [ RunTime:0.000174s ] [2024-05-19T15:11:29+08:00][sql] SELECT `value` FROM `set` WHERE `field` = 'fqc_maker' LIMIT 1 [ RunTime:0.000285s ] [2024-05-19T15:11:29+08:00][sql] SELECT `value` FROM `set` WHERE `field` = 'fqc_maker' LIMIT 1 [ RunTime:0.000184s ] [2024-05-19T15:11:29+08:00][sql] SELECT `value` FROM `set` WHERE `field` = 'fqc_maker' LIMIT 1 [ RunTime:0.000176s ] [2024-05-19T15:11:29+08:00][sql] insert into `fqc`(number,mo,product,note,result,create_time)values('20231109001_0001', '1', '1', '{"5":9.08,"6":0.6,"7":19.63,"8":1,"9":96.08,"10":1}', '1', '2023-11-09'),('20231109001_0002', '1', '1', '{"5":10.25,"6":0.1,"7":15.64,"8":1,"9":92.54,"10":1}', '1', '2023-11-09'),('20231109001_0003', '1', '1', '{"5":9.55,"6":0.7,"7":17.44,"8":1,"9":83.09,"10":1}', '1', '2023-11-09'),('20231109001_0004', '1', '1', '{"5":10.36,"6":0.33,"7":18.07,"8":1,"9":91.65,"10":1}', '1', '2023-11-09'),('20231109001_0005', '1', '1', '{"5":9.25,"6":0.05,"7":15.57,"8":1,"9":84.54,"10":1}', '1', '2023-11-09'),('20231109001_0006', '1', '1', '{"5":9.46,"6":1.4,"7":16.5,"8":1,"9":81.52,"10":1}', '1', '2023-11-09'),('20231109001_0007', '1', '1', '{"5":9.43,"6":1.41,"7":19.58,"8":1,"9":92.07,"10":1}', '1', '2023-11-09'),('20231109001_0008', '1', '1', '{"5":9.97,"6":1.33,"7":18.19,"8":1,"9":99.22,"10":1}', '1', '2023-11-09'),('20231109001_0009', '1', '1', '{"5":9.86,"6":1.38,"7":16.91,"8":1,"9":83.79,"10":1}', '1', '2023-11-09'),('20231109001_0010', '1', '1', '{"5":10.91,"6":1.09,"7":16.72,"8":1,"9":99.67,"10":1}', '1', '2023-11-09'),('20231109001_0011', '1', '1', '{"5":9.63,"6":1.21,"7":16.68,"8":1,"9":87.63,"10":1}', '1', '2023-11-09'),('20231109001_0012', '1', '1', '{"5":9.62,"6":0.26,"7":15.01,"8":1,"9":96.82,"10":1}', '1', '2023-11-09') [ RunTime:0.000476s ] [2024-05-19T15:11:30+08:00][sql] CONNECT:[ UseTime:0.011304s ] mysql:host=127.0.0.1;port=3306;dbname=ahwtxhgdkj;charset=utf8 [2024-05-19T15:11:30+08:00][sql] SHOW FULL COLUMNS FROM `set` [ RunTime:0.000790s ] [2024-05-19T15:11:30+08:00][sql] UPDATE `set` SET `value` = 'ahwtxhgdkj' WHERE `field` = 'database' [ RunTime:0.000275s ] [2024-05-19T15:11:30+08:00][sql] UPDATE `set` SET `value` = '安徽皖投新辉光电科技有限公司' WHERE `field` = 'title' [ RunTime:0.000216s ] [2024-05-19T15:11:30+08:00][sql] UPDATE `set` SET `value` = '391' WHERE `field` = 'product_sort' [ RunTime:0.000216s ] [2024-05-19T15:11:30+08:00][sql] SHOW FULL COLUMNS FROM `mo` [ RunTime:0.001097s ] [2024-05-19T15:11:30+08:00][sql] SELECT * FROM `mo` WHERE `id` = 1 [ RunTime:0.000250s ] [2024-05-19T15:11:30+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.000653s ] [2024-05-19T15:11:30+08:00][sql] SELECT * FROM `product` WHERE `id` = 1 [ RunTime:0.000240s ] [2024-05-19T15:11:30+08:00][sql] SELECT `value` FROM `set` WHERE `field` = 'capacity' LIMIT 1 [ RunTime:0.000332s ] [2024-05-19T15:11:30+08:00][sql] SELECT `value` FROM `set` WHERE `field` = 'pass_man' LIMIT 1 [ RunTime:0.000188s ] [2024-05-19T15:11:30+08:00][sql] SELECT `value` FROM `set` WHERE `field` = 'put_man' LIMIT 1 [ RunTime:0.000256s ] [2024-05-19T15:11:30+08:00][sql] SHOW FULL COLUMNS FROM `up` [ RunTime:0.001336s ] [2024-05-19T15:11:30+08:00][sql] SELECT * FROM `up` WHERE `mo` = 1 AND `product` = 1 LIMIT 1 [ RunTime:0.000249s ] [2024-05-19T15:11:30+08:00][sql] SELECT MAX(`number`) AS think_max FROM `up` WHERE `number` LIKE '20231110%' LIMIT 1 [ RunTime:0.000195s ] [2024-05-19T15:11:30+08:00][sql] INSERT INTO `up` SET `number` = '20231110001' , `mo` = 1 , `so` = 1 , `product` = 1 , `count` = 12 , `create_time` = '2023-11-09 00:00:00' , `status` = 1 , `pass_man` = 0 , `put_man` = 0 , `update_time` = '2024-05-19 15:11:30.035339' [ RunTime:0.000309s ] [2024-05-19T15:11:30+08:00][sql] CONNECT:[ UseTime:0.010881s ] mysql:host=127.0.0.1;port=3306;dbname=ahwtxhgdkj;charset=utf8 [2024-05-19T15:11:30+08:00][sql] SHOW FULL COLUMNS FROM `set` [ RunTime:0.000651s ] [2024-05-19T15:11:30+08:00][sql] UPDATE `set` SET `value` = 'ahwtxhgdkj' WHERE `field` = 'database' [ RunTime:0.000280s ] [2024-05-19T15:11:30+08:00][sql] UPDATE `set` SET `value` = '安徽皖投新辉光电科技有限公司' WHERE `field` = 'title' [ RunTime:0.000198s ] [2024-05-19T15:11:30+08:00][sql] UPDATE `set` SET `value` = '391' WHERE `field` = 'product_sort' [ RunTime:0.000179s ] [2024-05-19T15:11:30+08:00][sql] SHOW FULL COLUMNS FROM `mo` [ RunTime:0.001203s ] [2024-05-19T15:11:30+08:00][sql] SELECT * FROM `mo` WHERE `id` = 1 [ RunTime:0.000307s ] [2024-05-19T15:11:30+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.000497s ] [2024-05-19T15:11:30+08:00][sql] SELECT * FROM `product` WHERE `id` = 1 [ RunTime:0.000341s ] [2024-05-19T15:11:30+08:00][sql] SELECT `value` FROM `set` WHERE `field` = 'oqc_maker' LIMIT 1 [ RunTime:0.000330s ] [2024-05-19T15:11:30+08:00][sql] SHOW FULL COLUMNS FROM `tpl` [ RunTime:0.000852s ] [2024-05-19T15:11:30+08:00][sql] SELECT * FROM `tpl` WHERE `status` = 1 AND `tpl_sort` = '8' AND `sort` = 391 [ RunTime:0.000271s ] [2024-05-19T15:11:30+08:00][sql] SHOW FULL COLUMNS FROM `tpl_info` [ RunTime:0.000826s ] [2024-05-19T15:11:30+08:00][sql] SELECT * FROM `tpl_info` WHERE `tpl` = 3 ORDER BY `order` ASC [ RunTime:0.000394s ] [2024-05-19T15:11:30+08:00][sql] SHOW FULL COLUMNS FROM `fqc` [ RunTime:0.000864s ] [2024-05-19T15:11:30+08:00][sql] SELECT * FROM `fqc` WHERE `mo` = 1 ORDER BY rand() LIMIT 3 [ RunTime:0.000868s ] [2024-05-19T15:11:30+08:00][sql] SHOW FULL COLUMNS FROM `oqc` [ RunTime:0.001196s ] [2024-05-19T15:11:30+08:00][sql] SELECT COUNT(*) AS think_count FROM `oqc` WHERE `mo` = 1 AND `product` = 1 LIMIT 1 [ RunTime:0.000282s ] [2024-05-19T15:11:30+08:00][sql] INSERT INTO `oqc` SET `number` = '20231109001_0011' , `mo` = 1 , `product` = 1 , `note` = '{\"36\":1,\"35\":1,\"34\":1,\"33\":1,\"32\":1,\"31\":1,\"30\":1,\"29\":97.04,\"28\":1,\"27\":1,\"26\":20.05,\"25\":1,\"24\":1,\"23\":1,\"22\":1,\"21\":1,\"20\":1,\"19\":1,\"18\":1,\"17\":1,\"16\":9.66,\"15\":1.09,\"14\":11.47,\"13\":1.3,\"12\":1,\"11\":1}' , `result` = 1 , `create_time` = '2023-11-09' , `maker` = 0 , `update_time` = '2024-05-19 15:11:30.229780' [ RunTime:0.000286s ] [2024-05-19T15:11:30+08:00][sql] SELECT COUNT(*) AS think_count FROM `oqc` WHERE `mo` = 1 AND `product` = 1 LIMIT 1 [ RunTime:0.000237s ] [2024-05-19T15:11:30+08:00][sql] INSERT INTO `oqc` SET `number` = '20231109001_0012' , `mo` = 1 , `product` = 1 , `note` = '{\"36\":1,\"35\":1,\"34\":1,\"33\":1,\"32\":1,\"31\":1,\"30\":1,\"29\":99.99,\"28\":1,\"27\":1,\"26\":24.09,\"25\":1,\"24\":1,\"23\":1,\"22\":1,\"21\":1,\"20\":1,\"19\":1,\"18\":1,\"17\":1,\"16\":9.66,\"15\":0.85,\"14\":11.31,\"13\":0.82,\"12\":1,\"11\":1}' , `result` = 1 , `create_time` = '2023-11-09' , `maker` = 0 , `update_time` = '2024-05-19 15:11:30.230843' [ RunTime:0.000209s ] [2024-05-19T15:11:30+08:00][sql] SELECT COUNT(*) AS think_count FROM `oqc` WHERE `mo` = 1 AND `product` = 1 LIMIT 1 [ RunTime:0.000236s ] [2024-05-19T15:11:30+08:00][sql] INSERT INTO `oqc` SET `number` = '20231109001_0001' , `mo` = 1 , `product` = 1 , `note` = '{\"36\":1,\"35\":1,\"34\":1,\"33\":1,\"32\":1,\"31\":1,\"30\":1,\"29\":97.46,\"28\":1,\"27\":1,\"26\":21.76,\"25\":1,\"24\":1,\"23\":1,\"22\":1,\"21\":1,\"20\":1,\"19\":1,\"18\":1,\"17\":1,\"16\":10.09,\"15\":0.67,\"14\":16.9,\"13\":1.49,\"12\":1,\"11\":1}' , `result` = 1 , `create_time` = '2023-11-09' , `maker` = 0 , `update_time` = '2024-05-19 15:11:30.231735' [ RunTime:0.000920s ] [2024-05-19T15:11:30+08:00][sql] CONNECT:[ UseTime:0.011364s ] mysql:host=127.0.0.1;port=3306;dbname=ahwtxhgdkj;charset=utf8 [2024-05-19T15:11:30+08:00][sql] SHOW FULL COLUMNS FROM `set` [ RunTime:0.000656s ] [2024-05-19T15:11:30+08:00][sql] UPDATE `set` SET `value` = 'ahwtxhgdkj' WHERE `field` = 'database' [ RunTime:0.000369s ] [2024-05-19T15:11:30+08:00][sql] UPDATE `set` SET `value` = '安徽皖投新辉光电科技有限公司' WHERE `field` = 'title' [ RunTime:0.000198s ] [2024-05-19T15:11:30+08:00][sql] UPDATE `set` SET `value` = '391' WHERE `field` = 'product_sort' [ RunTime:0.000183s ] [2024-05-19T15:11:30+08:00][sql] SHOW FULL COLUMNS FROM `pp` [ RunTime:0.000612s ] [2024-05-19T15:11:30+08:00][sql] SELECT * FROM `pp` WHERE `so` = 1 [ RunTime:0.000273s ] [2024-05-19T15:11:30+08:00][sql] SHOW FULL COLUMNS FROM `so` [ RunTime:0.001100s ] [2024-05-19T15:11:30+08:00][sql] SELECT * FROM `so` WHERE `id` = 1 [ RunTime:0.000292s ] [2024-05-19T15:11:30+08:00][sql] SELECT `value` FROM `set` WHERE `field` = 'pass_man' LIMIT 1 [ RunTime:0.000336s ] [2024-05-19T15:11:30+08:00][sql] SELECT `value` FROM `set` WHERE `field` = 'put_man' LIMIT 1 [ RunTime:0.000194s ] [2024-05-19T15:11:30+08:00][sql] SELECT `value` FROM `set` WHERE `field` = 'store_man' LIMIT 1 [ RunTime:0.000186s ] [2024-05-19T15:11:30+08:00][sql] SHOW FULL COLUMNS FROM `sell` [ RunTime:0.001103s ] [2024-05-19T15:11:30+08:00][sql] SELECT * FROM `sell` WHERE `so` = 1 AND `pp` = 1 AND `product` = 1 LIMIT 1 [ RunTime:0.000243s ] [2024-05-19T15:11:30+08:00][sql] INSERT INTO `sell` SET `so` = 1 , `pp` = 1 , `product` = 1 , `count` = 12 , `cust` = 1 , `create_time` = '2023-11-12 12:00:00' , `report_time` = '2023-11-13 00:00:00' , `start_num` = '41062AA09728AA' , `status` = 2 , `end_num` = '41062AA09729AA' , `pass_man` = 0 , `store_man` = 0 , `qa_man` = 0 , `update_time` = '2024-05-19 15:11:30.397571' [ RunTime:0.000301s ]