[2024-11-13T15:31:33+08:00][sql] CONNECT:[ UseTime:0.001172s ] mysql:host=127.0.0.1;port=3306;dbname=hbzahxkj;charset=utf8 [2024-11-13T15:31:33+08:00][sql] SHOW FULL COLUMNS FROM `set` [ RunTime:0.000638s ] [2024-11-13T15:31:33+08:00][sql] UPDATE `set` SET `value` = 'hbzahxkj' WHERE `field` = 'database' [ RunTime:0.000288s ] [2024-11-13T15:31:33+08:00][sql] UPDATE `set` SET `value` = '河北中安禾信科技有限公司' WHERE `field` = 'title' [ RunTime:0.000195s ] [2024-11-13T15:31:33+08:00][sql] UPDATE `set` SET `value` = '42,43,389' WHERE `field` = 'product_sort' [ RunTime:0.000189s ] [2024-11-13T15:31:49+08:00][sql] CONNECT:[ UseTime:0.011991s ] mysql:host=127.0.0.1;port=3306;dbname=hbzahxkj;charset=utf8 [2024-11-13T15:31:49+08:00][sql] SHOW FULL COLUMNS FROM `set` [ RunTime:0.000697s ] [2024-11-13T15:31:49+08:00][sql] UPDATE `set` SET `value` = 'hbzahxkj' WHERE `field` = 'database' [ RunTime:0.000276s ] [2024-11-13T15:31:49+08:00][sql] UPDATE `set` SET `value` = '河北中安禾信科技有限公司' WHERE `field` = 'title' [ RunTime:0.000213s ] [2024-11-13T15:31:49+08:00][sql] UPDATE `set` SET `value` = '42,43,389' WHERE `field` = 'product_sort' [ RunTime:0.000228s ] [2024-11-13T15:31:51+08:00][sql] CONNECT:[ UseTime:0.014210s ] mysql:host=127.0.0.1;port=3306;dbname=hbzahxkj;charset=utf8 [2024-11-13T15:31:51+08:00][sql] SHOW FULL COLUMNS FROM `set` [ RunTime:0.000722s ] [2024-11-13T15:31:51+08:00][sql] UPDATE `set` SET `value` = 'hbzahxkj' WHERE `field` = 'database' [ RunTime:0.000291s ] [2024-11-13T15:31:51+08:00][sql] UPDATE `set` SET `value` = '河北中安禾信科技有限公司' WHERE `field` = 'title' [ RunTime:0.000205s ] [2024-11-13T15:31:51+08:00][sql] UPDATE `set` SET `value` = '42,43,389' WHERE `field` = 'product_sort' [ RunTime:0.000234s ] [2024-11-13T15:31:51+08:00][sql] SHOW FULL COLUMNS FROM `cust` [ RunTime:0.001411s ] [2024-11-13T15:31:51+08:00][sql] SELECT MAX(`number`) AS think_max FROM `cust` LIMIT 1 [ RunTime:0.000234s ] [2024-11-13T15:31:51+08:00][sql] SELECT * FROM `cust` WHERE `name` = '宿州市九颂洲樾小区' LIMIT 1 [ RunTime:0.000230s ] [2024-11-13T15:31:51+08:00][sql] INSERT INTO `cust` SET `number` = '00001' , `name` = '宿州市九颂洲樾小区' , `create_time` = '2024-11-13 15:31:51.662856' , `update_time` = '2024-11-13 15:31:51.662869' [ RunTime:0.000294s ] [2024-11-13T15:31:51+08:00][sql] SHOW FULL COLUMNS FROM `project` [ RunTime:0.001266s ] [2024-11-13T15:31:51+08:00][sql] SELECT * FROM `project` WHERE `name` = '' AND `cust` = 1 LIMIT 1 [ RunTime:0.000234s ] [2024-11-13T15:31:51+08:00][sql] INSERT INTO `project` SET `name` = '' , `cust` = 1 , `create_time` = '2024-11-13 15:31:51.665586' , `update_time` = '2024-11-13 15:31:51.665597' [ RunTime:0.000237s ] [2024-11-13T15:31:51+08:00][sql] SELECT * FROM `cust` WHERE `name` = '宿州市九颂洲樾小区' LIMIT 1 [ RunTime:0.000248s ] [2024-11-13T15:31:51+08:00][sql] SELECT * FROM `project` WHERE `name` = '' AND `cust` = 1 LIMIT 1 [ RunTime:0.000238s ] [2024-11-13T15:31:51+08:00][sql] SELECT * FROM `cust` WHERE `name` = '宿州市九颂洲樾小区' LIMIT 1 [ RunTime:0.000251s ] [2024-11-13T15:31:51+08:00][sql] SELECT * FROM `project` WHERE `name` = '' AND `cust` = 1 LIMIT 1 [ RunTime:0.000236s ] [2024-11-13T15:31:51+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.000907s ] [2024-11-13T15:31:51+08:00][sql] SELECT * FROM `product` [ RunTime:0.000274s ] [2024-11-13T15:31:51+08:00][sql] SELECT `value` FROM `set` WHERE `field` = 'lead_time' LIMIT 1 [ RunTime:0.000295s ] [2024-11-13T15:31:51+08:00][sql] SHOW FULL COLUMNS FROM `so` [ RunTime:0.001332s ] [2024-11-13T15:31:51+08:00][sql] SELECT * FROM `so` WHERE `cust` = 1 AND `project` = '1' AND `report_time` = '2024-04-15' LIMIT 1 [ RunTime:0.000256s ] [2024-11-13T15:31:51+08:00][sql] SELECT MAX(`number`) AS think_max FROM `so` WHERE `number` LIKE '20240408%' LIMIT 1 [ RunTime:0.000190s ] [2024-11-13T15:31:51+08:00][sql] INSERT INTO `so` SET `number` = '20240408001' , `cust` = 1 , `project` = '1' , `addr` = NULL , `linkman` = NULL , `req` = NULL , `status` = 6 , `create_time` = '2024-04-08' , `report_time` = '2024-04-15' , `update_time` = '2024-11-13 15:31:51.673728' [ RunTime:0.000255s ] [2024-11-13T15:31:51+08:00][sql] SHOW FULL COLUMNS FROM `pp` [ RunTime:0.001178s ] [2024-11-13T15:31:51+08:00][sql] SELECT * FROM `pp` WHERE `start_num` = '41062AA09728AA' AND `end_num` = '41062AA09730AA' LIMIT 1 [ RunTime:0.000227s ] [2024-11-13T15:31:51+08:00][sql] INSERT INTO `pp` SET `so` = 1 , `count` = 2 , `product` = 1 , `status` = 6 , `name` = '双电源控制设备' , `type` = 'ZA-S-400' , `specs` = '\\' , `unit` = '台' , `need_time` = '2024-04-14' , `create_time` = '2024-04-08' , `report_time` = '2024-04-15' , `start_num` = '41062AA09728AA' , `end_num` = '41062AA09730AA' , `update_time` = '2024-11-13 15:31:51.676332' [ RunTime:0.000312s ] [2024-11-13T15:31:51+08:00][sql] SELECT * FROM `pp` WHERE `start_num` = '41062AA09731AA' AND `end_num` = '41062AA09733AA' LIMIT 1 [ RunTime:0.000233s ] [2024-11-13T15:31:51+08:00][sql] INSERT INTO `pp` SET `so` = 1 , `count` = 2 , `product` = 2 , `status` = 6 , `name` = '消防泵控制设备' , `type` = 'ZA-X-S315/KYN28/10000/6000' , `specs` = '\\' , `unit` = '台' , `need_time` = '2024-04-14' , `create_time` = '2024-04-08' , `report_time` = '2024-04-15' , `start_num` = '41062AA09731AA' , `end_num` = '41062AA09733AA' , `update_time` = '2024-11-13 15:31:51.677383' [ RunTime:0.000212s ] [2024-11-13T15:31:51+08:00][sql] SELECT * FROM `pp` WHERE `start_num` = '41062AA09734AA' AND `end_num` = '41062AA09736AA' LIMIT 1 [ RunTime:0.000250s ] [2024-11-13T15:31:51+08:00][sql] INSERT INTO `pp` SET `so` = 1 , `count` = 2 , `product` = 3 , `status` = 6 , `name` = '消防泵自动巡检控制设备' , `type` = 'ZA-XF-S315/KYN28/10000/6000' , `specs` = '\\' , `unit` = '台' , `need_time` = '2024-04-14' , `create_time` = '2024-04-08' , `report_time` = '2024-04-15' , `start_num` = '41062AA09734AA' , `end_num` = '41062AA09736AA' , `update_time` = '2024-11-13 15:31:51.678317' [ RunTime:0.000206s ] [2024-11-13T15:31:51+08:00][sql] CONNECT:[ UseTime:0.001094s ] mysql:host=127.0.0.1;port=3306;dbname=hbzahxkj;charset=utf8 [2024-11-13T15:31:51+08:00][sql] SHOW FULL COLUMNS FROM `set` [ RunTime:0.000651s ] [2024-11-13T15:31:51+08:00][sql] UPDATE `set` SET `value` = 'hbzahxkj' WHERE `field` = 'database' [ RunTime:0.000266s ] [2024-11-13T15:31:51+08:00][sql] UPDATE `set` SET `value` = '河北中安禾信科技有限公司' WHERE `field` = 'title' [ RunTime:0.000195s ] [2024-11-13T15:31:51+08:00][sql] UPDATE `set` SET `value` = '42,43,389' WHERE `field` = 'product_sort' [ RunTime:0.000192s ] [2024-11-13T15:31:51+08:00][sql] SHOW FULL COLUMNS FROM `pp` [ RunTime:0.001033s ] [2024-11-13T15:31:51+08:00][sql] SELECT * FROM `pp` WHERE `so` = 1 [ RunTime:0.000357s ] [2024-11-13T15:31:51+08:00][sql] SHOW FULL COLUMNS FROM `bom` [ RunTime:0.001011s ] [2024-11-13T15:31:51+08:00][sql] SELECT * FROM `bom` WHERE `product` IN (1,2,3) [ RunTime:0.000272s ] [2024-11-13T15:31:51+08:00][sql] SHOW FULL COLUMNS FROM `bom_info` [ RunTime:0.001461s ] [2024-11-13T15:31:51+08:00][sql] SELECT * FROM `bom_info` WHERE `bom` IN (1,2,3) [ RunTime:0.000362s ] [2024-11-13T15:31:51+08:00][sql] SHOW FULL COLUMNS FROM `raw` [ RunTime:0.001012s ] [2024-11-13T15:31:51+08:00][sql] SELECT * FROM `raw` [ RunTime:0.000336s ] [2024-11-13T15:31:51+08:00][sql] SHOW FULL COLUMNS FROM `mrp` [ RunTime:0.001561s ] [2024-11-13T15:31:51+08:00][sql] SELECT * FROM `mrp` WHERE `pp` = 1 AND `raw` = 1 LIMIT 1 [ RunTime:0.000252s ] [2024-11-13T15:31:51+08:00][sql] INSERT INTO `mrp` SET `so` = 1 , `pp` = 1 , `count` = 4 , `raw` = 1 , `need_time` = '2024-04-14 00:00:00' , `status` = 5 , `create_time` = '2024-04-08 00:00:00' , `update_time` = '2024-11-13 15:31:51.855964' [ RunTime:0.000281s ] [2024-11-13T15:31:51+08:00][sql] SELECT * FROM `mrp` WHERE `pp` = 1 AND `raw` = 2 LIMIT 1 [ RunTime:0.000194s ] [2024-11-13T15:31:51+08:00][sql] INSERT INTO `mrp` SET `so` = 1 , `pp` = 1 , `count` = 2 , `raw` = 2 , `need_time` = '2024-04-14 00:00:00' , `status` = 5 , `create_time` = '2024-04-08 00:00:00' , `update_time` = '2024-11-13 15:31:51.856917' [ RunTime:0.000192s ] [2024-11-13T15:31:51+08:00][sql] SELECT * FROM `mrp` WHERE `pp` = 1 AND `raw` = 3 LIMIT 1 [ RunTime:0.000206s ] [2024-11-13T15:31:51+08:00][sql] INSERT INTO `mrp` SET `so` = 1 , `pp` = 1 , `count` = 4 , `raw` = 3 , `need_time` = '2024-04-14 00:00:00' , `status` = 5 , `create_time` = '2024-04-08 00:00:00' , `update_time` = '2024-11-13 15:31:51.857706' [ RunTime:0.000197s ] [2024-11-13T15:31:51+08:00][sql] SELECT * FROM `mrp` WHERE `pp` = 1 AND `raw` = 4 LIMIT 1 [ RunTime:0.000219s ] [2024-11-13T15:31:51+08:00][sql] INSERT INTO `mrp` SET `so` = 1 , `pp` = 1 , `count` = 16 , `raw` = 4 , `need_time` = '2024-04-14 00:00:00' , `status` = 5 , `create_time` = '2024-04-08 00:00:00' , `update_time` = '2024-11-13 15:31:51.858489' [ RunTime:0.000181s ] [2024-11-13T15:31:51+08:00][sql] SELECT * FROM `mrp` WHERE `pp` = 1 AND `raw` = 5 LIMIT 1 [ RunTime:0.000189s ] [2024-11-13T15:31:51+08:00][sql] INSERT INTO `mrp` SET `so` = 1 , `pp` = 1 , `count` = 2 , `raw` = 5 , `need_time` = '2024-04-14 00:00:00' , `status` = 5 , `create_time` = '2024-04-08 00:00:00' , `update_time` = '2024-11-13 15:31:51.859237' [ RunTime:0.000186s ] [2024-11-13T15:31:51+08:00][sql] SELECT * FROM `mrp` WHERE `pp` = 1 AND `raw` = 6 LIMIT 1 [ RunTime:0.000222s ] [2024-11-13T15:31:51+08:00][sql] INSERT INTO `mrp` SET `so` = 1 , `pp` = 1 , `count` = 12 , `raw` = 6 , `need_time` = '2024-04-14 00:00:00' , `status` = 5 , `create_time` = '2024-04-08 00:00:00' , `update_time` = '2024-11-13 15:31:51.860033' [ RunTime:0.000191s ] [2024-11-13T15:31:51+08:00][sql] SELECT * FROM `mrp` WHERE `pp` = 1 AND `raw` = 7 LIMIT 1 [ RunTime:0.000190s ] [2024-11-13T15:31:51+08:00][sql] INSERT INTO `mrp` SET `so` = 1 , `pp` = 1 , `count` = 2 , `raw` = 7 , `need_time` = '2024-04-14 00:00:00' , `status` = 5 , `create_time` = '2024-04-08 00:00:00' , `update_time` = '2024-11-13 15:31:51.860822' [ RunTime:0.000183s ] [2024-11-13T15:31:51+08:00][sql] SELECT * FROM `mrp` WHERE `pp` = 1 AND `raw` = 8 LIMIT 1 [ RunTime:0.000224s ] [2024-11-13T15:31:51+08:00][sql] INSERT INTO `mrp` SET `so` = 1 , `pp` = 1 , `count` = 2 , `raw` = 8 , `need_time` = '2024-04-14 00:00:00' , `status` = 5 , `create_time` = '2024-04-08 00:00:00' , `update_time` = '2024-11-13 15:31:51.861630' [ RunTime:0.000313s ] [2024-11-13T15:31:51+08:00][sql] SELECT * FROM `mrp` WHERE `pp` = 1 AND `raw` = 9 LIMIT 1 [ RunTime:0.000217s ] [2024-11-13T15:31:51+08:00][sql] INSERT INTO `mrp` SET `so` = 1 , `pp` = 1 , `count` = 2 , `raw` = 9 , `need_time` = '2024-04-14 00:00:00' , `status` = 5 , `create_time` = '2024-04-08 00:00:00' , `update_time` = '2024-11-13 15:31:51.862551' [ RunTime:0.000191s ] [2024-11-13T15:31:51+08:00][sql] SELECT * FROM `mrp` WHERE `pp` = 1 AND `raw` = 10 LIMIT 1 [ RunTime:0.000186s ] [2024-11-13T15:31:51+08:00][sql] INSERT INTO `mrp` SET `so` = 1 , `pp` = 1 , `count` = 2 , `raw` = 10 , `need_time` = '2024-04-14 00:00:00' , `status` = 5 , `create_time` = '2024-04-08 00:00:00' , `update_time` = '2024-11-13 15:31:51.863339' [ RunTime:0.000181s ] [2024-11-13T15:31:51+08:00][sql] SELECT * FROM `mrp` WHERE `pp` = 1 AND `raw` = 11 LIMIT 1 [ RunTime:0.000194s ] [2024-11-13T15:31:51+08:00][sql] INSERT INTO `mrp` SET `so` = 1 , `pp` = 1 , `count` = 300 , `raw` = 11 , `need_time` = '2024-04-14 00:00:00' , `status` = 5 , `create_time` = '2024-04-08 00:00:00' , `update_time` = '2024-11-13 15:31:51.864121' [ RunTime:0.000198s ] [2024-11-13T15:31:51+08:00][sql] SELECT * FROM `mrp` WHERE `pp` = 1 AND `raw` = 12 LIMIT 1 [ RunTime:0.000191s ] [2024-11-13T15:31:51+08:00][sql] INSERT INTO `mrp` SET `so` = 1 , `pp` = 1 , `count` = 2 , `raw` = 12 , `need_time` = '2024-04-14 00:00:00' , `status` = 5 , `create_time` = '2024-04-08 00:00:00' , `update_time` = '2024-11-13 15:31:51.864893' [ RunTime:0.000175s ] [2024-11-13T15:31:51+08:00][sql] SELECT * FROM `mrp` WHERE `pp` = 1 AND `raw` = 13 LIMIT 1 [ RunTime:0.000191s ] [2024-11-13T15:31:51+08:00][sql] INSERT INTO `mrp` SET `so` = 1 , `pp` = 1 , `count` = 40 , `raw` = 13 , `need_time` = '2024-04-14 00:00:00' , `status` = 5 , `create_time` = '2024-04-08 00:00:00' , `update_time` = '2024-11-13 15:31:51.865656' [ RunTime:0.000199s ] [2024-11-13T15:31:51+08:00][sql] SELECT * FROM `mrp` WHERE `pp` = 2 AND `raw` = 1 LIMIT 1 [ RunTime:0.000209s ] [2024-11-13T15:31:51+08:00][sql] INSERT INTO `mrp` SET `so` = 1 , `pp` = 2 , `count` = 4 , `raw` = 1 , `need_time` = '2024-04-14 00:00:00' , `status` = 5 , `create_time` = '2024-04-08 00:00:00' , `update_time` = '2024-11-13 15:31:51.866466' [ RunTime:0.000190s ] [2024-11-13T15:31:51+08:00][sql] SELECT * FROM `mrp` WHERE `pp` = 2 AND `raw` = 3 LIMIT 1 [ RunTime:0.000185s ] [2024-11-13T15:31:51+08:00][sql] INSERT INTO `mrp` SET `so` = 1 , `pp` = 2 , `count` = 2 , `raw` = 3 , `need_time` = '2024-04-14 00:00:00' , `status` = 5 , `create_time` = '2024-04-08 00:00:00' , `update_time` = '2024-11-13 15:31:51.867237' [ RunTime:0.000195s ] [2024-11-13T15:31:51+08:00][sql] SELECT * FROM `mrp` WHERE `pp` = 2 AND `raw` = 4 LIMIT 1 [ RunTime:0.000194s ] [2024-11-13T15:31:51+08:00][sql] INSERT INTO `mrp` SET `so` = 1 , `pp` = 2 , `count` = 2 , `raw` = 4 , `need_time` = '2024-04-14 00:00:00' , `status` = 5 , `create_time` = '2024-04-08 00:00:00' , `update_time` = '2024-11-13 15:31:51.868042' [ RunTime:0.000204s ] [2024-11-13T15:31:51+08:00][sql] SELECT * FROM `mrp` WHERE `pp` = 2 AND `raw` = 5 LIMIT 1 [ RunTime:0.000199s ] [2024-11-13T15:31:51+08:00][sql] INSERT INTO `mrp` SET `so` = 1 , `pp` = 2 , `count` = 2 , `raw` = 5 , `need_time` = '2024-04-14 00:00:00' , `status` = 5 , `create_time` = '2024-04-08 00:00:00' , `update_time` = '2024-11-13 15:31:51.868829' [ RunTime:0.000175s ] [2024-11-13T15:31:51+08:00][sql] SELECT * FROM `mrp` WHERE `pp` = 2 AND `raw` = 6 LIMIT 1 [ RunTime:0.000189s ] [2024-11-13T15:31:51+08:00][sql] INSERT INTO `mrp` SET `so` = 1 , `pp` = 2 , `count` = 8 , `raw` = 6 , `need_time` = '2024-04-14 00:00:00' , `status` = 5 , `create_time` = '2024-04-08 00:00:00' , `update_time` = '2024-11-13 15:31:51.869601' [ RunTime:0.000182s ] [2024-11-13T15:31:51+08:00][sql] SELECT * FROM `mrp` WHERE `pp` = 2 AND `raw` = 11 LIMIT 1 [ RunTime:0.000202s ] [2024-11-13T15:31:51+08:00][sql] INSERT INTO `mrp` SET `so` = 1 , `pp` = 2 , `count` = 340 , `raw` = 11 , `need_time` = '2024-04-14 00:00:00' , `status` = 5 , `create_time` = '2024-04-08 00:00:00' , `update_time` = '2024-11-13 15:31:51.870373' [ RunTime:0.000184s ] [2024-11-13T15:31:51+08:00][sql] SELECT * FROM `mrp` WHERE `pp` = 2 AND `raw` = 13 LIMIT 1 [ RunTime:0.000184s ] [2024-11-13T15:31:51+08:00][sql] INSERT INTO `mrp` SET `so` = 1 , `pp` = 2 , `count` = 78 , `raw` = 13 , `need_time` = '2024-04-14 00:00:00' , `status` = 5 , `create_time` = '2024-04-08 00:00:00' , `update_time` = '2024-11-13 15:31:51.871130' [ RunTime:0.000989s ] [2024-11-13T15:31:51+08:00][sql] SELECT * FROM `mrp` WHERE `pp` = 2 AND `raw` = 14 LIMIT 1 [ RunTime:0.000236s ] [2024-11-13T15:31:51+08:00][sql] INSERT INTO `mrp` SET `so` = 1 , `pp` = 2 , `count` = 8 , `raw` = 14 , `need_time` = '2024-04-14 00:00:00' , `status` = 5 , `create_time` = '2024-04-08 00:00:00' , `update_time` = '2024-11-13 15:31:51.872796' [ RunTime:0.000194s ] [2024-11-13T15:31:51+08:00][sql] SELECT * FROM `mrp` WHERE `pp` = 2 AND `raw` = 15 LIMIT 1 [ RunTime:0.000198s ] [2024-11-13T15:31:51+08:00][sql] INSERT INTO `mrp` SET `so` = 1 , `pp` = 2 , `count` = 4 , `raw` = 15 , `need_time` = '2024-04-14 00:00:00' , `status` = 5 , `create_time` = '2024-04-08 00:00:00' , `update_time` = '2024-11-13 15:31:51.873628' [ RunTime:0.000162s ] [2024-11-13T15:31:51+08:00][sql] SELECT * FROM `mrp` WHERE `pp` = 2 AND `raw` = 16 LIMIT 1 [ RunTime:0.000206s ] [2024-11-13T15:31:51+08:00][sql] INSERT INTO `mrp` SET `so` = 1 , `pp` = 2 , `count` = 4 , `raw` = 16 , `need_time` = '2024-04-14 00:00:00' , `status` = 5 , `create_time` = '2024-04-08 00:00:00' , `update_time` = '2024-11-13 15:31:51.874397' [ RunTime:0.000179s ] [2024-11-13T15:31:51+08:00][sql] SELECT * FROM `mrp` WHERE `pp` = 2 AND `raw` = 17 LIMIT 1 [ RunTime:0.000193s ] [2024-11-13T15:31:51+08:00][sql] INSERT INTO `mrp` SET `so` = 1 , `pp` = 2 , `count` = 2 , `raw` = 17 , `need_time` = '2024-04-14 00:00:00' , `status` = 5 , `create_time` = '2024-04-08 00:00:00' , `update_time` = '2024-11-13 15:31:51.875170' [ RunTime:0.000166s ] [2024-11-13T15:31:51+08:00][sql] SELECT * FROM `mrp` WHERE `pp` = 2 AND `raw` = 18 LIMIT 1 [ RunTime:0.000193s ] [2024-11-13T15:31:51+08:00][sql] INSERT INTO `mrp` SET `so` = 1 , `pp` = 2 , `count` = 2 , `raw` = 18 , `need_time` = '2024-04-14 00:00:00' , `status` = 5 , `create_time` = '2024-04-08 00:00:00' , `update_time` = '2024-11-13 15:31:51.875942' [ RunTime:0.000170s ] [2024-11-13T15:31:51+08:00][sql] SELECT * FROM `mrp` WHERE `pp` = 3 AND `raw` = 1 LIMIT 1 [ RunTime:0.000190s ] [2024-11-13T15:31:51+08:00][sql] INSERT INTO `mrp` SET `so` = 1 , `pp` = 3 , `count` = 4 , `raw` = 1 , `need_time` = '2024-04-14 00:00:00' , `status` = 5 , `create_time` = '2024-04-08 00:00:00' , `update_time` = '2024-11-13 15:31:51.876697' [ RunTime:0.000159s ] [2024-11-13T15:31:51+08:00][sql] SELECT * FROM `mrp` WHERE `pp` = 3 AND `raw` = 3 LIMIT 1 [ RunTime:0.000202s ] [2024-11-13T15:31:51+08:00][sql] INSERT INTO `mrp` SET `so` = 1 , `pp` = 3 , `count` = 2 , `raw` = 3 , `need_time` = '2024-04-14 00:00:00' , `status` = 5 , `create_time` = '2024-04-08 00:00:00' , `update_time` = '2024-11-13 15:31:51.877447' [ RunTime:0.000169s ] [2024-11-13T15:31:51+08:00][sql] SELECT * FROM `mrp` WHERE `pp` = 3 AND `raw` = 6 LIMIT 1 [ RunTime:0.000195s ] [2024-11-13T15:31:51+08:00][sql] INSERT INTO `mrp` SET `so` = 1 , `pp` = 3 , `count` = 8 , `raw` = 6 , `need_time` = '2024-04-14 00:00:00' , `status` = 5 , `create_time` = '2024-04-08 00:00:00' , `update_time` = '2024-11-13 15:31:51.878203' [ RunTime:0.000162s ] [2024-11-13T15:31:51+08:00][sql] SELECT * FROM `mrp` WHERE `pp` = 3 AND `raw` = 7 LIMIT 1 [ RunTime:0.000186s ] [2024-11-13T15:31:51+08:00][sql] INSERT INTO `mrp` SET `so` = 1 , `pp` = 3 , `count` = 2 , `raw` = 7 , `need_time` = '2024-04-14 00:00:00' , `status` = 5 , `create_time` = '2024-04-08 00:00:00' , `update_time` = '2024-11-13 15:31:51.878960' [ RunTime:0.000164s ] [2024-11-13T15:31:51+08:00][sql] SELECT * FROM `mrp` WHERE `pp` = 3 AND `raw` = 8 LIMIT 1 [ RunTime:0.000197s ] [2024-11-13T15:31:51+08:00][sql] INSERT INTO `mrp` SET `so` = 1 , `pp` = 3 , `count` = 4 , `raw` = 8 , `need_time` = '2024-04-14 00:00:00' , `status` = 5 , `create_time` = '2024-04-08 00:00:00' , `update_time` = '2024-11-13 15:31:51.879724' [ RunTime:0.000161s ] [2024-11-13T15:31:51+08:00][sql] SELECT * FROM `mrp` WHERE `pp` = 3 AND `raw` = 11 LIMIT 1 [ RunTime:0.000194s ] [2024-11-13T15:31:51+08:00][sql] INSERT INTO `mrp` SET `so` = 1 , `pp` = 3 , `count` = 330 , `raw` = 11 , `need_time` = '2024-04-14 00:00:00' , `status` = 5 , `create_time` = '2024-04-08 00:00:00' , `update_time` = '2024-11-13 15:31:51.880472' [ RunTime:0.000212s ] [2024-11-13T15:31:51+08:00][sql] SELECT * FROM `mrp` WHERE `pp` = 3 AND `raw` = 13 LIMIT 1 [ RunTime:0.000192s ] [2024-11-13T15:31:51+08:00][sql] INSERT INTO `mrp` SET `so` = 1 , `pp` = 3 , `count` = 32 , `raw` = 13 , `need_time` = '2024-04-14 00:00:00' , `status` = 5 , `create_time` = '2024-04-08 00:00:00' , `update_time` = '2024-11-13 15:31:51.881299' [ RunTime:0.000169s ] [2024-11-13T15:31:51+08:00][sql] SELECT * FROM `mrp` WHERE `pp` = 3 AND `raw` = 19 LIMIT 1 [ RunTime:0.000197s ] [2024-11-13T15:31:51+08:00][sql] INSERT INTO `mrp` SET `so` = 1 , `pp` = 3 , `count` = 10 , `raw` = 19 , `need_time` = '2024-04-14 00:00:00' , `status` = 5 , `create_time` = '2024-04-08 00:00:00' , `update_time` = '2024-11-13 15:31:51.882048' [ RunTime:0.000174s ] [2024-11-13T15:31:51+08:00][sql] SELECT * FROM `mrp` WHERE `pp` = 3 AND `raw` = 20 LIMIT 1 [ RunTime:0.000191s ] [2024-11-13T15:31:51+08:00][sql] INSERT INTO `mrp` SET `so` = 1 , `pp` = 3 , `count` = 2 , `raw` = 20 , `need_time` = '2024-04-14 00:00:00' , `status` = 5 , `create_time` = '2024-04-08 00:00:00' , `update_time` = '2024-11-13 15:31:51.882825' [ RunTime:0.000169s ] [2024-11-13T15:31:51+08:00][sql] SELECT * FROM `mrp` WHERE `pp` = 3 AND `raw` = 21 LIMIT 1 [ RunTime:0.000219s ] [2024-11-13T15:31:51+08:00][sql] INSERT INTO `mrp` SET `so` = 1 , `pp` = 3 , `count` = 2 , `raw` = 21 , `need_time` = '2024-04-14 00:00:00' , `status` = 5 , `create_time` = '2024-04-08 00:00:00' , `update_time` = '2024-11-13 15:31:51.883625' [ RunTime:0.000162s ] [2024-11-13T15:31:51+08:00][sql] SELECT * FROM `mrp` WHERE `pp` = 3 AND `raw` = 22 LIMIT 1 [ RunTime:0.000203s ] [2024-11-13T15:31:51+08:00][sql] INSERT INTO `mrp` SET `so` = 1 , `pp` = 3 , `count` = 2 , `raw` = 22 , `need_time` = '2024-04-14 00:00:00' , `status` = 5 , `create_time` = '2024-04-08 00:00:00' , `update_time` = '2024-11-13 15:31:51.884389' [ RunTime:0.000164s ] [2024-11-13T15:31:52+08:00][sql] CONNECT:[ UseTime:0.013162s ] mysql:host=127.0.0.1;port=3306;dbname=hbzahxkj;charset=utf8 [2024-11-13T15:31:52+08:00][sql] SHOW FULL COLUMNS FROM `set` [ RunTime:0.000665s ] [2024-11-13T15:31:52+08:00][sql] UPDATE `set` SET `value` = 'hbzahxkj' WHERE `field` = 'database' [ RunTime:0.000267s ] [2024-11-13T15:31:52+08:00][sql] UPDATE `set` SET `value` = '河北中安禾信科技有限公司' WHERE `field` = 'title' [ RunTime:0.000197s ] [2024-11-13T15:31:52+08:00][sql] UPDATE `set` SET `value` = '42,43,389' WHERE `field` = 'product_sort' [ RunTime:0.000169s ] [2024-11-13T15:31:52+08:00][sql] CONNECT:[ UseTime:0.012702s ] mysql:host=127.0.0.1;port=3306;dbname=hbzahxkj;charset=utf8 [2024-11-13T15:31:52+08:00][sql] SHOW FULL COLUMNS FROM `set` [ RunTime:0.000687s ] [2024-11-13T15:31:52+08:00][sql] UPDATE `set` SET `value` = 'hbzahxkj' WHERE `field` = 'database' [ RunTime:0.000284s ] [2024-11-13T15:31:52+08:00][sql] UPDATE `set` SET `value` = '河北中安禾信科技有限公司' WHERE `field` = 'title' [ RunTime:0.000217s ] [2024-11-13T15:31:52+08:00][sql] UPDATE `set` SET `value` = '42,43,389' WHERE `field` = 'product_sort' [ RunTime:0.000186s ] [2024-11-13T15:31:52+08:00][sql] SHOW FULL COLUMNS FROM `mrp` [ RunTime:0.000950s ] [2024-11-13T15:31:52+08:00][sql] SELECT * FROM `mrp` WHERE `id` IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36) [ RunTime:0.000433s ] [2024-11-13T15:31:52+08:00][sql] SHOW FULL COLUMNS FROM `raw` [ RunTime:0.000610s ] [2024-11-13T15:31:52+08:00][sql] SELECT * FROM `raw` WHERE `id` IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22) [ RunTime:0.000397s ] [2024-11-13T15:31:52+08:00][sql] SHOW FULL COLUMNS FROM `supplier` [ RunTime:0.000632s ] [2024-11-13T15:31:52+08:00][sql] SELECT * FROM `supplier` [ RunTime:0.000226s ] [2024-11-13T15:31:52+08:00][sql] SELECT `value` FROM `set` WHERE `field` = 'po_base' LIMIT 1 [ RunTime:0.000250s ] [2024-11-13T15:31:52+08:00][sql] SELECT `value` FROM `set` WHERE `field` = 'po_base' LIMIT 1 [ RunTime:0.000201s ] [2024-11-13T15:31:52+08:00][sql] SELECT `value` FROM `set` WHERE `field` = 'po_base' LIMIT 1 [ RunTime:0.000247s ] [2024-11-13T15:31:52+08:00][sql] SELECT `value` FROM `set` WHERE `field` = 'po_base' LIMIT 1 [ RunTime:0.000204s ] [2024-11-13T15:31:52+08:00][sql] SELECT `value` FROM `set` WHERE `field` = 'po_base' LIMIT 1 [ RunTime:0.000188s ] [2024-11-13T15:31:52+08:00][sql] SELECT `value` FROM `set` WHERE `field` = 'po_base' LIMIT 1 [ RunTime:0.000176s ] [2024-11-13T15:31:52+08:00][sql] SELECT `value` FROM `set` WHERE `field` = 'po_base' LIMIT 1 [ RunTime:0.000180s ] [2024-11-13T15:31:52+08:00][sql] SELECT `value` FROM `set` WHERE `field` = 'po_base' LIMIT 1 [ RunTime:0.000186s ] [2024-11-13T15:31:52+08:00][sql] SELECT `value` FROM `set` WHERE `field` = 'po_base' LIMIT 1 [ RunTime:0.000176s ] [2024-11-13T15:31:52+08:00][sql] SELECT `value` FROM `set` WHERE `field` = 'po_base' LIMIT 1 [ RunTime:0.000178s ] [2024-11-13T15:31:52+08:00][sql] SELECT `value` FROM `set` WHERE `field` = 'po_base' LIMIT 1 [ RunTime:0.000215s ] [2024-11-13T15:31:52+08:00][sql] SELECT `value` FROM `set` WHERE `field` = 'po_base' LIMIT 1 [ RunTime:0.000174s ] [2024-11-13T15:31:52+08:00][sql] SELECT `value` FROM `set` WHERE `field` = 'po_base' LIMIT 1 [ RunTime:0.000189s ] [2024-11-13T15:31:52+08:00][sql] SELECT `value` FROM `set` WHERE `field` = 'po_base' LIMIT 1 [ RunTime:0.000199s ] [2024-11-13T15:31:52+08:00][sql] SELECT `value` FROM `set` WHERE `field` = 'po_base' LIMIT 1 [ RunTime:0.000172s ] [2024-11-13T15:31:52+08:00][sql] SELECT `value` FROM `set` WHERE `field` = 'po_base' LIMIT 1 [ RunTime:0.000189s ] [2024-11-13T15:31:52+08:00][sql] SELECT `value` FROM `set` WHERE `field` = 'po_base' LIMIT 1 [ RunTime:0.000222s ] [2024-11-13T15:31:52+08:00][sql] SELECT `value` FROM `set` WHERE `field` = 'po_base' LIMIT 1 [ RunTime:0.000171s ] [2024-11-13T15:31:52+08:00][sql] SELECT `value` FROM `set` WHERE `field` = 'po_base' LIMIT 1 [ RunTime:0.000188s ] [2024-11-13T15:31:52+08:00][sql] SELECT `value` FROM `set` WHERE `field` = 'po_base' LIMIT 1 [ RunTime:0.000175s ] [2024-11-13T15:31:52+08:00][sql] SELECT `value` FROM `set` WHERE `field` = 'po_base' LIMIT 1 [ RunTime:0.000174s ] [2024-11-13T15:31:52+08:00][sql] SELECT `value` FROM `set` WHERE `field` = 'po_base' LIMIT 1 [ RunTime:0.000191s ] [2024-11-13T15:31:52+08:00][sql] SELECT `value` FROM `set` WHERE `field` = 'po_base' LIMIT 1 [ RunTime:0.000176s ] [2024-11-13T15:31:52+08:00][sql] SELECT `value` FROM `set` WHERE `field` = 'po_base' LIMIT 1 [ RunTime:0.000182s ] [2024-11-13T15:31:52+08:00][sql] SELECT `value` FROM `set` WHERE `field` = 'po_base' LIMIT 1 [ RunTime:0.000216s ] [2024-11-13T15:31:52+08:00][sql] SELECT `value` FROM `set` WHERE `field` = 'po_base' LIMIT 1 [ RunTime:0.000179s ] [2024-11-13T15:31:52+08:00][sql] SELECT `value` FROM `set` WHERE `field` = 'po_base' LIMIT 1 [ RunTime:0.000179s ] [2024-11-13T15:31:52+08:00][sql] SELECT `value` FROM `set` WHERE `field` = 'po_base' LIMIT 1 [ RunTime:0.000215s ] [2024-11-13T15:31:52+08:00][sql] SELECT `value` FROM `set` WHERE `field` = 'po_base' LIMIT 1 [ RunTime:0.000184s ] [2024-11-13T15:31:52+08:00][sql] SELECT `value` FROM `set` WHERE `field` = 'po_base' LIMIT 1 [ RunTime:0.000181s ] [2024-11-13T15:31:52+08:00][sql] SELECT `value` FROM `set` WHERE `field` = 'po_base' LIMIT 1 [ RunTime:0.000237s ] [2024-11-13T15:31:52+08:00][sql] SELECT `value` FROM `set` WHERE `field` = 'po_base' LIMIT 1 [ RunTime:0.000189s ] [2024-11-13T15:31:52+08:00][sql] SELECT `value` FROM `set` WHERE `field` = 'po_base' LIMIT 1 [ RunTime:0.000181s ] [2024-11-13T15:31:52+08:00][sql] SELECT `value` FROM `set` WHERE `field` = 'po_base' LIMIT 1 [ RunTime:0.000217s ] [2024-11-13T15:31:52+08:00][sql] SELECT `value` FROM `set` WHERE `field` = 'po_base' LIMIT 1 [ RunTime:0.000188s ] [2024-11-13T15:31:52+08:00][sql] SELECT `value` FROM `set` WHERE `field` = 'po_base' LIMIT 1 [ RunTime:0.000181s ] [2024-11-13T15:31:52+08:00][sql] SHOW FULL COLUMNS FROM `po` [ RunTime:0.001411s ] [2024-11-13T15:31:52+08:00][sql] SELECT `number` FROM `po` [ RunTime:0.000167s ] [2024-11-13T15:32:08+08:00][sql] CONNECT:[ UseTime:0.009212s ] mysql:host=127.0.0.1;port=3306;dbname=hbzahxkj;charset=utf8 [2024-11-13T15:32:08+08:00][sql] SHOW FULL COLUMNS FROM `set` [ RunTime:0.000703s ] [2024-11-13T15:32:08+08:00][sql] UPDATE `set` SET `value` = 'hbzahxkj' WHERE `field` = 'database' [ RunTime:0.000284s ] [2024-11-13T15:32:08+08:00][sql] UPDATE `set` SET `value` = '河北中安禾信科技有限公司' WHERE `field` = 'title' [ RunTime:0.000212s ] [2024-11-13T15:32:08+08:00][sql] UPDATE `set` SET `value` = '42,43,389' WHERE `field` = 'product_sort' [ RunTime:0.000194s ] [2024-11-13T15:32:08+08:00][sql] SHOW FULL COLUMNS FROM `po` [ RunTime:0.000797s ] [2024-11-13T15:32:08+08:00][sql] SELECT * FROM `po` WHERE `mrp` = '1,14,26' AND `so` = '1' AND `raw` = 1 LIMIT 1 [ RunTime:0.000281s ] [2024-11-13T15:32:08+08:00][sql] SELECT MAX(`number`) AS think_max FROM `po` WHERE `number` LIKE '20240408%' LIMIT 1 [ RunTime:0.000205s ] [2024-11-13T15:32:08+08:00][sql] INSERT INTO `po` SET `number` = '20240408001' , `so` = '1' , `mrp` = '1,14,26' , `raw` = 1 , `count` = '12' , `po_count` = '12' , `create_time` = '2024-04-08 00:00:00' , `deliver_time` = '2024-04-10 00:00:00' , `supplier` = 8 , `status` = 8 , `po_unit` = '个' , `update_time` = '2024-11-13 15:32:08.968121' [ RunTime:0.000323s ] [2024-11-13T15:32:08+08:00][sql] SELECT * FROM `po` WHERE `mrp` = '2' AND `so` = '1' AND `raw` = 2 LIMIT 1 [ RunTime:0.000250s ] [2024-11-13T15:32:08+08:00][sql] SELECT MAX(`number`) AS think_max FROM `po` WHERE `number` LIKE '20240408%' LIMIT 1 [ RunTime:0.000193s ] [2024-11-13T15:32:08+08:00][sql] INSERT INTO `po` SET `number` = '20240408002' , `so` = '1' , `mrp` = '2' , `raw` = 2 , `count` = '2' , `po_count` = '2' , `create_time` = '2024-04-08 00:00:00' , `deliver_time` = '2024-04-10 00:00:00' , `supplier` = 1 , `status` = 8 , `po_unit` = '个' , `update_time` = '2024-11-13 15:32:08.969539' [ RunTime:0.000413s ] [2024-11-13T15:32:08+08:00][sql] SELECT * FROM `po` WHERE `mrp` = '3,15,27' AND `so` = '1' AND `raw` = 3 LIMIT 1 [ RunTime:0.000260s ] [2024-11-13T15:32:08+08:00][sql] SELECT MAX(`number`) AS think_max FROM `po` WHERE `number` LIKE '20240408%' LIMIT 1 [ RunTime:0.000201s ] [2024-11-13T15:32:08+08:00][sql] INSERT INTO `po` SET `number` = '20240408003' , `so` = '1' , `mrp` = '3,15,27' , `raw` = 3 , `count` = '8' , `po_count` = '8' , `create_time` = '2024-04-08 00:00:00' , `deliver_time` = '2024-04-10 00:00:00' , `supplier` = 5 , `status` = 8 , `po_unit` = '个' , `update_time` = '2024-11-13 15:32:08.970984' [ RunTime:0.000437s ] [2024-11-13T15:32:08+08:00][sql] SELECT * FROM `po` WHERE `mrp` = '4,16' AND `so` = '1' AND `raw` = 4 LIMIT 1 [ RunTime:0.000231s ] [2024-11-13T15:32:08+08:00][sql] SELECT MAX(`number`) AS think_max FROM `po` WHERE `number` LIKE '20240408%' LIMIT 1 [ RunTime:0.000190s ] [2024-11-13T15:32:08+08:00][sql] INSERT INTO `po` SET `number` = '20240408004' , `so` = '1' , `mrp` = '4,16' , `raw` = 4 , `count` = '18' , `po_count` = '18' , `create_time` = '2024-04-08 00:00:00' , `deliver_time` = '2024-04-10 00:00:00' , `supplier` = 8 , `status` = 8 , `po_unit` = '个' , `update_time` = '2024-11-13 15:32:08.972389' [ RunTime:0.000218s ] [2024-11-13T15:32:08+08:00][sql] SELECT * FROM `po` WHERE `mrp` = '5,17' AND `so` = '1' AND `raw` = 5 LIMIT 1 [ RunTime:0.000223s ] [2024-11-13T15:32:08+08:00][sql] SELECT MAX(`number`) AS think_max FROM `po` WHERE `number` LIKE '20240408%' LIMIT 1 [ RunTime:0.000231s ] [2024-11-13T15:32:08+08:00][sql] INSERT INTO `po` SET `number` = '20240408005' , `so` = '1' , `mrp` = '5,17' , `raw` = 5 , `count` = '4' , `po_count` = '4' , `create_time` = '2024-04-08 00:00:00' , `deliver_time` = '2024-04-10 00:00:00' , `supplier` = 8 , `status` = 8 , `po_unit` = '个' , `update_time` = '2024-11-13 15:32:08.973630' [ RunTime:0.000228s ] [2024-11-13T15:32:08+08:00][sql] SELECT * FROM `po` WHERE `mrp` = '6,18,28' AND `so` = '1' AND `raw` = 6 LIMIT 1 [ RunTime:0.000223s ] [2024-11-13T15:32:08+08:00][sql] SELECT MAX(`number`) AS think_max FROM `po` WHERE `number` LIKE '20240408%' LIMIT 1 [ RunTime:0.000195s ] [2024-11-13T15:32:08+08:00][sql] INSERT INTO `po` SET `number` = '20240408006' , `so` = '1' , `mrp` = '6,18,28' , `raw` = 6 , `count` = '28' , `po_count` = '29' , `create_time` = '2024-04-08 00:00:00' , `deliver_time` = '2024-04-10 00:00:00' , `supplier` = 8 , `status` = 8 , `po_unit` = '个' , `update_time` = '2024-11-13 15:32:08.974809' [ RunTime:0.000226s ] [2024-11-13T15:32:08+08:00][sql] SELECT * FROM `po` WHERE `mrp` = '7,29' AND `so` = '1' AND `raw` = 7 LIMIT 1 [ RunTime:0.000254s ] [2024-11-13T15:32:08+08:00][sql] SELECT MAX(`number`) AS think_max FROM `po` WHERE `number` LIKE '20240408%' LIMIT 1 [ RunTime:0.000202s ] [2024-11-13T15:32:08+08:00][sql] INSERT INTO `po` SET `number` = '20240408007' , `so` = '1' , `mrp` = '7,29' , `raw` = 7 , `count` = '4' , `po_count` = '4' , `create_time` = '2024-04-08 00:00:00' , `deliver_time` = '2024-04-10 00:00:00' , `supplier` = 5 , `status` = 8 , `po_unit` = '个' , `update_time` = '2024-11-13 15:32:08.976052' [ RunTime:0.000366s ] [2024-11-13T15:32:08+08:00][sql] SELECT * FROM `po` WHERE `mrp` = '8,30' AND `so` = '1' AND `raw` = 8 LIMIT 1 [ RunTime:0.000227s ] [2024-11-13T15:32:08+08:00][sql] SELECT MAX(`number`) AS think_max FROM `po` WHERE `number` LIKE '20240408%' LIMIT 1 [ RunTime:0.000187s ] [2024-11-13T15:32:08+08:00][sql] INSERT INTO `po` SET `number` = '20240408008' , `so` = '1' , `mrp` = '8,30' , `raw` = 8 , `count` = '6' , `po_count` = '6' , `create_time` = '2024-04-08 00:00:00' , `deliver_time` = '2024-04-10 00:00:00' , `supplier` = 8 , `status` = 8 , `po_unit` = '个' , `update_time` = '2024-11-13 15:32:08.977370' [ RunTime:0.000210s ] [2024-11-13T15:32:08+08:00][sql] SELECT * FROM `po` WHERE `mrp` = '9' AND `so` = '1' AND `raw` = 9 LIMIT 1 [ RunTime:0.000243s ] [2024-11-13T15:32:08+08:00][sql] SELECT MAX(`number`) AS think_max FROM `po` WHERE `number` LIKE '20240408%' LIMIT 1 [ RunTime:0.000249s ] [2024-11-13T15:32:08+08:00][sql] INSERT INTO `po` SET `number` = '20240408009' , `so` = '1' , `mrp` = '9' , `raw` = 9 , `count` = '2' , `po_count` = '2' , `create_time` = '2024-04-08 00:00:00' , `deliver_time` = '2024-04-10 00:00:00' , `supplier` = 7 , `status` = 8 , `po_unit` = '个' , `update_time` = '2024-11-13 15:32:08.978648' [ RunTime:0.000232s ] [2024-11-13T15:32:08+08:00][sql] SELECT * FROM `po` WHERE `mrp` = '10' AND `so` = '1' AND `raw` = 10 LIMIT 1 [ RunTime:0.000280s ] [2024-11-13T15:32:08+08:00][sql] SELECT MAX(`number`) AS think_max FROM `po` WHERE `number` LIKE '20240408%' LIMIT 1 [ RunTime:0.000188s ] [2024-11-13T15:32:08+08:00][sql] INSERT INTO `po` SET `number` = '20240408010' , `so` = '1' , `mrp` = '10' , `raw` = 10 , `count` = '2' , `po_count` = '2' , `create_time` = '2024-04-08 00:00:00' , `deliver_time` = '2024-04-10 00:00:00' , `supplier` = 7 , `status` = 8 , `po_unit` = '个' , `update_time` = '2024-11-13 15:32:08.979897' [ RunTime:0.000960s ] [2024-11-13T15:32:08+08:00][sql] SELECT * FROM `po` WHERE `mrp` = '11,19,31' AND `so` = '1' AND `raw` = 11 LIMIT 1 [ RunTime:0.000277s ] [2024-11-13T15:32:08+08:00][sql] SELECT MAX(`number`) AS think_max FROM `po` WHERE `number` LIKE '20240408%' LIMIT 1 [ RunTime:0.000220s ] [2024-11-13T15:32:08+08:00][sql] INSERT INTO `po` SET `number` = '20240408011' , `so` = '1' , `mrp` = '11,19,31' , `raw` = 11 , `count` = '970' , `po_count` = '1018' , `create_time` = '2024-04-08 00:00:00' , `deliver_time` = '2024-04-10 00:00:00' , `supplier` = 3 , `status` = 8 , `po_unit` = '米' , `update_time` = '2024-11-13 15:32:08.981936' [ RunTime:0.000379s ] [2024-11-13T15:32:08+08:00][sql] SELECT * FROM `po` WHERE `mrp` = '12' AND `so` = '1' AND `raw` = 12 LIMIT 1 [ RunTime:0.000275s ] [2024-11-13T15:32:08+08:00][sql] SELECT MAX(`number`) AS think_max FROM `po` WHERE `number` LIKE '20240408%' LIMIT 1 [ RunTime:0.000191s ] [2024-11-13T15:32:08+08:00][sql] INSERT INTO `po` SET `number` = '20240408012' , `so` = '1' , `mrp` = '12' , `raw` = 12 , `count` = '2' , `po_count` = '2' , `create_time` = '2024-04-08 00:00:00' , `deliver_time` = '2024-04-10 00:00:00' , `supplier` = 6 , `status` = 8 , `po_unit` = '个' , `update_time` = '2024-11-13 15:32:08.983367' [ RunTime:0.000192s ] [2024-11-13T15:32:08+08:00][sql] SELECT * FROM `po` WHERE `mrp` = '13,20,32' AND `so` = '1' AND `raw` = 13 LIMIT 1 [ RunTime:0.000225s ] [2024-11-13T15:32:08+08:00][sql] SELECT MAX(`number`) AS think_max FROM `po` WHERE `number` LIKE '20240408%' LIMIT 1 [ RunTime:0.000212s ] [2024-11-13T15:32:08+08:00][sql] INSERT INTO `po` SET `number` = '20240408013' , `so` = '1' , `mrp` = '13,20,32' , `raw` = 13 , `count` = '150' , `po_count` = '157' , `create_time` = '2024-04-08 00:00:00' , `deliver_time` = '2024-04-10 00:00:00' , `supplier` = 2 , `status` = 8 , `po_unit` = '个' , `update_time` = '2024-11-13 15:32:08.984603' [ RunTime:0.000196s ] [2024-11-13T15:32:08+08:00][sql] SELECT * FROM `po` WHERE `mrp` = '21' AND `so` = '1' AND `raw` = 14 LIMIT 1 [ RunTime:0.000235s ] [2024-11-13T15:32:08+08:00][sql] SELECT MAX(`number`) AS think_max FROM `po` WHERE `number` LIKE '20240408%' LIMIT 1 [ RunTime:0.000227s ] [2024-11-13T15:32:08+08:00][sql] INSERT INTO `po` SET `number` = '20240408014' , `so` = '1' , `mrp` = '21' , `raw` = 14 , `count` = '8' , `po_count` = '8' , `create_time` = '2024-04-08 00:00:00' , `deliver_time` = '2024-04-10 00:00:00' , `supplier` = 8 , `status` = 8 , `po_unit` = '个' , `update_time` = '2024-11-13 15:32:08.985825' [ RunTime:0.000194s ] [2024-11-13T15:32:08+08:00][sql] SELECT * FROM `po` WHERE `mrp` = '22' AND `so` = '1' AND `raw` = 15 LIMIT 1 [ RunTime:0.000233s ] [2024-11-13T15:32:08+08:00][sql] SELECT MAX(`number`) AS think_max FROM `po` WHERE `number` LIKE '20240408%' LIMIT 1 [ RunTime:0.000201s ] [2024-11-13T15:32:08+08:00][sql] INSERT INTO `po` SET `number` = '20240408015' , `so` = '1' , `mrp` = '22' , `raw` = 15 , `count` = '4' , `po_count` = '4' , `create_time` = '2024-04-08 00:00:00' , `deliver_time` = '2024-04-10 00:00:00' , `supplier` = 8 , `status` = 8 , `po_unit` = '个' , `update_time` = '2024-11-13 15:32:08.987039' [ RunTime:0.000188s ] [2024-11-13T15:32:08+08:00][sql] SELECT * FROM `po` WHERE `mrp` = '23' AND `so` = '1' AND `raw` = 16 LIMIT 1 [ RunTime:0.000239s ] [2024-11-13T15:32:08+08:00][sql] SELECT MAX(`number`) AS think_max FROM `po` WHERE `number` LIKE '20240408%' LIMIT 1 [ RunTime:0.000230s ] [2024-11-13T15:32:08+08:00][sql] INSERT INTO `po` SET `number` = '20240408016' , `so` = '1' , `mrp` = '23' , `raw` = 16 , `count` = '4' , `po_count` = '4' , `create_time` = '2024-04-08 00:00:00' , `deliver_time` = '2024-04-10 00:00:00' , `supplier` = 8 , `status` = 8 , `po_unit` = '个' , `update_time` = '2024-11-13 15:32:08.988252' [ RunTime:0.000195s ] [2024-11-13T15:32:08+08:00][sql] SELECT * FROM `po` WHERE `mrp` = '24' AND `so` = '1' AND `raw` = 17 LIMIT 1 [ RunTime:0.000223s ] [2024-11-13T15:32:08+08:00][sql] SELECT MAX(`number`) AS think_max FROM `po` WHERE `number` LIKE '20240408%' LIMIT 1 [ RunTime:0.000204s ] [2024-11-13T15:32:08+08:00][sql] INSERT INTO `po` SET `number` = '20240408017' , `so` = '1' , `mrp` = '24' , `raw` = 17 , `count` = '2' , `po_count` = '2' , `create_time` = '2024-04-08 00:00:00' , `deliver_time` = '2024-04-10 00:00:00' , `supplier` = 4 , `status` = 8 , `po_unit` = '个' , `update_time` = '2024-11-13 15:32:08.989476' [ RunTime:0.000203s ] [2024-11-13T15:32:08+08:00][sql] SELECT * FROM `po` WHERE `mrp` = '25' AND `so` = '1' AND `raw` = 18 LIMIT 1 [ RunTime:0.000235s ] [2024-11-13T15:32:08+08:00][sql] SELECT MAX(`number`) AS think_max FROM `po` WHERE `number` LIKE '20240408%' LIMIT 1 [ RunTime:0.000240s ] [2024-11-13T15:32:08+08:00][sql] INSERT INTO `po` SET `number` = '20240408018' , `so` = '1' , `mrp` = '25' , `raw` = 18 , `count` = '2' , `po_count` = '2' , `create_time` = '2024-04-08 00:00:00' , `deliver_time` = '2024-04-10 00:00:00' , `supplier` = 6 , `status` = 8 , `po_unit` = '个' , `update_time` = '2024-11-13 15:32:08.990708' [ RunTime:0.000193s ] [2024-11-13T15:32:08+08:00][sql] SELECT * FROM `po` WHERE `mrp` = '33' AND `so` = '1' AND `raw` = 19 LIMIT 1 [ RunTime:0.000235s ] [2024-11-13T15:32:08+08:00][sql] SELECT MAX(`number`) AS think_max FROM `po` WHERE `number` LIKE '20240408%' LIMIT 1 [ RunTime:0.000207s ] [2024-11-13T15:32:08+08:00][sql] INSERT INTO `po` SET `number` = '20240408019' , `so` = '1' , `mrp` = '33' , `raw` = 19 , `count` = '10' , `po_count` = '10' , `create_time` = '2024-04-08 00:00:00' , `deliver_time` = '2024-04-10 00:00:00' , `supplier` = 8 , `status` = 8 , `po_unit` = '个' , `update_time` = '2024-11-13 15:32:08.991927' [ RunTime:0.000199s ] [2024-11-13T15:32:08+08:00][sql] SELECT * FROM `po` WHERE `mrp` = '34' AND `so` = '1' AND `raw` = 20 LIMIT 1 [ RunTime:0.000236s ] [2024-11-13T15:32:08+08:00][sql] SELECT MAX(`number`) AS think_max FROM `po` WHERE `number` LIKE '20240408%' LIMIT 1 [ RunTime:0.000228s ] [2024-11-13T15:32:08+08:00][sql] INSERT INTO `po` SET `number` = '20240408020' , `so` = '1' , `mrp` = '34' , `raw` = 20 , `count` = '2' , `po_count` = '2' , `create_time` = '2024-04-08 00:00:00' , `deliver_time` = '2024-04-10 00:00:00' , `supplier` = 8 , `status` = 8 , `po_unit` = '个' , `update_time` = '2024-11-13 15:32:08.993150' [ RunTime:0.000194s ] [2024-11-13T15:32:08+08:00][sql] SELECT * FROM `po` WHERE `mrp` = '35' AND `so` = '1' AND `raw` = 21 LIMIT 1 [ RunTime:0.000227s ] [2024-11-13T15:32:08+08:00][sql] SELECT MAX(`number`) AS think_max FROM `po` WHERE `number` LIKE '20240408%' LIMIT 1 [ RunTime:0.000204s ] [2024-11-13T15:32:08+08:00][sql] INSERT INTO `po` SET `number` = '20240408021' , `so` = '1' , `mrp` = '35' , `raw` = 21 , `count` = '2' , `po_count` = '2' , `create_time` = '2024-04-08 00:00:00' , `deliver_time` = '2024-04-10 00:00:00' , `supplier` = 4 , `status` = 8 , `po_unit` = '个' , `update_time` = '2024-11-13 15:32:08.994490' [ RunTime:0.000197s ] [2024-11-13T15:32:08+08:00][sql] SELECT * FROM `po` WHERE `mrp` = '36' AND `so` = '1' AND `raw` = 22 LIMIT 1 [ RunTime:0.000231s ] [2024-11-13T15:32:08+08:00][sql] SELECT MAX(`number`) AS think_max FROM `po` WHERE `number` LIKE '20240408%' LIMIT 1 [ RunTime:0.000248s ] [2024-11-13T15:32:08+08:00][sql] INSERT INTO `po` SET `number` = '20240408022' , `so` = '1' , `mrp` = '36' , `raw` = 22 , `count` = '2' , `po_count` = '2' , `create_time` = '2024-04-08 00:00:00' , `deliver_time` = '2024-04-10 00:00:00' , `supplier` = 6 , `status` = 8 , `po_unit` = '个' , `update_time` = '2024-11-13 15:32:08.995756' [ RunTime:0.000190s ] [2024-11-13T15:32:09+08:00][sql] CONNECT:[ UseTime:0.014820s ] mysql:host=127.0.0.1;port=3306;dbname=hbzahxkj;charset=utf8 [2024-11-13T15:32:09+08:00][sql] SHOW FULL COLUMNS FROM `set` [ RunTime:0.000701s ] [2024-11-13T15:32:09+08:00][sql] UPDATE `set` SET `value` = 'hbzahxkj' WHERE `field` = 'database' [ RunTime:0.000282s ] [2024-11-13T15:32:09+08:00][sql] UPDATE `set` SET `value` = '河北中安禾信科技有限公司' WHERE `field` = 'title' [ RunTime:0.000192s ] [2024-11-13T15:32:09+08:00][sql] UPDATE `set` SET `value` = '42,43,389' WHERE `field` = 'product_sort' [ RunTime:0.000188s ] [2024-11-13T15:32:09+08:00][sql] SHOW FULL COLUMNS FROM `po` [ RunTime:0.001026s ] [2024-11-13T15:32:09+08:00][sql] SELECT * FROM `po` WHERE `id` IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22) [ RunTime:0.000439s ] [2024-11-13T15:32:09+08:00][sql] SHOW FULL COLUMNS FROM `an` [ RunTime:0.001439s ] [2024-11-13T15:32:09+08:00][sql] SELECT * FROM `an` WHERE `po` = 1 AND `raw` = 1 LIMIT 1 [ RunTime:0.000232s ] [2024-11-13T15:32:09+08:00][sql] SELECT MAX(`number`) AS think_max FROM `an` WHERE `number` LIKE '20240409%' LIMIT 1 [ RunTime:0.000210s ] [2024-11-13T15:32:09+08:00][sql] INSERT INTO `an` SET `po` = 1 , `number` = '20240409001' , `raw` = 1 , `count` = '12.00' , `supplier` = 8 , `status` = 3 , `create_time` = '2024-04-09 06:31:25' , `update_time` = '2024-11-13 15:32:09.113611' [ RunTime:0.000269s ] [2024-11-13T15:32:09+08:00][sql] SELECT * FROM `an` WHERE `po` = 2 AND `raw` = 2 LIMIT 1 [ RunTime:0.000219s ] [2024-11-13T15:32:09+08:00][sql] SELECT MAX(`number`) AS think_max FROM `an` WHERE `number` LIKE '20240409%' LIMIT 1 [ RunTime:0.000191s ] [2024-11-13T15:32:09+08:00][sql] INSERT INTO `an` SET `po` = 2 , `number` = '20240409002' , `raw` = 2 , `count` = '2.00' , `supplier` = 1 , `status` = 3 , `create_time` = '2024-04-09 07:10:52' , `update_time` = '2024-11-13 15:32:09.114956' [ RunTime:0.000243s ] [2024-11-13T15:32:09+08:00][sql] SELECT * FROM `an` WHERE `po` = 3 AND `raw` = 3 LIMIT 1 [ RunTime:0.000248s ] [2024-11-13T15:32:09+08:00][sql] SELECT MAX(`number`) AS think_max FROM `an` WHERE `number` LIKE '20240409%' LIMIT 1 [ RunTime:0.000182s ] [2024-11-13T15:32:09+08:00][sql] INSERT INTO `an` SET `po` = 3 , `number` = '20240409003' , `raw` = 3 , `count` = '8.00' , `supplier` = 5 , `status` = 3 , `create_time` = '2024-04-09 07:49:21' , `update_time` = '2024-11-13 15:32:09.116151' [ RunTime:0.000215s ] [2024-11-13T15:32:09+08:00][sql] SELECT * FROM `an` WHERE `po` = 4 AND `raw` = 4 LIMIT 1 [ RunTime:0.000201s ] [2024-11-13T15:32:09+08:00][sql] SELECT MAX(`number`) AS think_max FROM `an` WHERE `number` LIKE '20240409%' LIMIT 1 [ RunTime:0.000191s ] [2024-11-13T15:32:09+08:00][sql] INSERT INTO `an` SET `po` = 4 , `number` = '20240409004' , `raw` = 4 , `count` = '18.00' , `supplier` = 8 , `status` = 3 , `create_time` = '2024-04-09 12:36:24' , `update_time` = '2024-11-13 15:32:09.117267' [ RunTime:0.000244s ] [2024-11-13T15:32:09+08:00][sql] SELECT * FROM `an` WHERE `po` = 5 AND `raw` = 5 LIMIT 1 [ RunTime:0.000192s ] [2024-11-13T15:32:09+08:00][sql] SELECT MAX(`number`) AS think_max FROM `an` WHERE `number` LIKE '20240409%' LIMIT 1 [ RunTime:0.000178s ] [2024-11-13T15:32:09+08:00][sql] INSERT INTO `an` SET `po` = 5 , `number` = '20240409005' , `raw` = 5 , `count` = '4.00' , `supplier` = 8 , `status` = 3 , `create_time` = '2024-04-09 05:08:19' , `update_time` = '2024-11-13 15:32:09.118392' [ RunTime:0.000342s ] [2024-11-13T15:32:09+08:00][sql] SELECT * FROM `an` WHERE `po` = 6 AND `raw` = 6 LIMIT 1 [ RunTime:0.000237s ] [2024-11-13T15:32:09+08:00][sql] SELECT MAX(`number`) AS think_max FROM `an` WHERE `number` LIKE '20240409%' LIMIT 1 [ RunTime:0.000200s ] [2024-11-13T15:32:09+08:00][sql] INSERT INTO `an` SET `po` = 6 , `number` = '20240409006' , `raw` = 6 , `count` = '29.00' , `supplier` = 8 , `status` = 3 , `create_time` = '2024-04-09 12:10:25' , `update_time` = '2024-11-13 15:32:09.119693' [ RunTime:0.000206s ] [2024-11-13T15:32:09+08:00][sql] SELECT * FROM `an` WHERE `po` = 7 AND `raw` = 7 LIMIT 1 [ RunTime:0.000208s ] [2024-11-13T15:32:09+08:00][sql] SELECT MAX(`number`) AS think_max FROM `an` WHERE `number` LIKE '20240409%' LIMIT 1 [ RunTime:0.000225s ] [2024-11-13T15:32:09+08:00][sql] INSERT INTO `an` SET `po` = 7 , `number` = '20240409007' , `raw` = 7 , `count` = '4.00' , `supplier` = 5 , `status` = 3 , `create_time` = '2024-04-09 09:42:51' , `update_time` = '2024-11-13 15:32:09.120859' [ RunTime:0.000233s ] [2024-11-13T15:32:09+08:00][sql] SELECT * FROM `an` WHERE `po` = 8 AND `raw` = 8 LIMIT 1 [ RunTime:0.000242s ] [2024-11-13T15:32:09+08:00][sql] SELECT MAX(`number`) AS think_max FROM `an` WHERE `number` LIKE '20240409%' LIMIT 1 [ RunTime:0.000175s ] [2024-11-13T15:32:09+08:00][sql] INSERT INTO `an` SET `po` = 8 , `number` = '20240409008' , `raw` = 8 , `count` = '6.00' , `supplier` = 8 , `status` = 3 , `create_time` = '2024-04-09 12:27:41' , `update_time` = '2024-11-13 15:32:09.122001' [ RunTime:0.000201s ] [2024-11-13T15:32:09+08:00][sql] SELECT * FROM `an` WHERE `po` = 9 AND `raw` = 9 LIMIT 1 [ RunTime:0.000207s ] [2024-11-13T15:32:09+08:00][sql] SELECT MAX(`number`) AS think_max FROM `an` WHERE `number` LIKE '20240409%' LIMIT 1 [ RunTime:0.000208s ] [2024-11-13T15:32:09+08:00][sql] INSERT INTO `an` SET `po` = 9 , `number` = '20240409009' , `raw` = 9 , `count` = '2.00' , `supplier` = 7 , `status` = 3 , `create_time` = '2024-04-09 05:40:21' , `update_time` = '2024-11-13 15:32:09.123168' [ RunTime:0.000208s ] [2024-11-13T15:32:09+08:00][sql] SELECT * FROM `an` WHERE `po` = 10 AND `raw` = 10 LIMIT 1 [ RunTime:0.000194s ] [2024-11-13T15:32:09+08:00][sql] SELECT MAX(`number`) AS think_max FROM `an` WHERE `number` LIKE '20240409%' LIMIT 1 [ RunTime:0.000199s ] [2024-11-13T15:32:09+08:00][sql] INSERT INTO `an` SET `po` = 10 , `number` = '20240409010' , `raw` = 10 , `count` = '2.00' , `supplier` = 7 , `status` = 3 , `create_time` = '2024-04-09 06:54:53' , `update_time` = '2024-11-13 15:32:09.124280' [ RunTime:0.000239s ] [2024-11-13T15:32:09+08:00][sql] SELECT * FROM `an` WHERE `po` = 11 AND `raw` = 11 LIMIT 1 [ RunTime:0.000231s ] [2024-11-13T15:32:09+08:00][sql] SELECT MAX(`number`) AS think_max FROM `an` WHERE `number` LIKE '20240409%' LIMIT 1 [ RunTime:0.000177s ] [2024-11-13T15:32:09+08:00][sql] INSERT INTO `an` SET `po` = 11 , `number` = '20240409011' , `raw` = 11 , `count` = '1018.00' , `supplier` = 3 , `status` = 3 , `create_time` = '2024-04-09 10:11:32' , `update_time` = '2024-11-13 15:32:09.125417' [ RunTime:0.000200s ] [2024-11-13T15:32:09+08:00][sql] SELECT * FROM `an` WHERE `po` = 12 AND `raw` = 12 LIMIT 1 [ RunTime:0.000200s ] [2024-11-13T15:32:09+08:00][sql] SELECT MAX(`number`) AS think_max FROM `an` WHERE `number` LIKE '20240409%' LIMIT 1 [ RunTime:0.000215s ] [2024-11-13T15:32:09+08:00][sql] INSERT INTO `an` SET `po` = 12 , `number` = '20240409012' , `raw` = 12 , `count` = '2.00' , `supplier` = 6 , `status` = 3 , `create_time` = '2024-04-09 06:44:25' , `update_time` = '2024-11-13 15:32:09.126585' [ RunTime:0.000207s ] [2024-11-13T15:32:09+08:00][sql] SELECT * FROM `an` WHERE `po` = 13 AND `raw` = 13 LIMIT 1 [ RunTime:0.000195s ] [2024-11-13T15:32:09+08:00][sql] SELECT MAX(`number`) AS think_max FROM `an` WHERE `number` LIKE '20240409%' LIMIT 1 [ RunTime:0.000213s ] [2024-11-13T15:32:09+08:00][sql] INSERT INTO `an` SET `po` = 13 , `number` = '20240409013' , `raw` = 13 , `count` = '157.00' , `supplier` = 2 , `status` = 3 , `create_time` = '2024-04-09 11:05:54' , `update_time` = '2024-11-13 15:32:09.127710' [ RunTime:0.000230s ] [2024-11-13T15:32:09+08:00][sql] SELECT * FROM `an` WHERE `po` = 14 AND `raw` = 14 LIMIT 1 [ RunTime:0.000268s ] [2024-11-13T15:32:09+08:00][sql] SELECT MAX(`number`) AS think_max FROM `an` WHERE `number` LIKE '20240409%' LIMIT 1 [ RunTime:0.000185s ] [2024-11-13T15:32:09+08:00][sql] INSERT INTO `an` SET `po` = 14 , `number` = '20240409014' , `raw` = 14 , `count` = '8.00' , `supplier` = 8 , `status` = 3 , `create_time` = '2024-04-09 11:19:07' , `update_time` = '2024-11-13 15:32:09.128894' [ RunTime:0.000204s ] [2024-11-13T15:32:09+08:00][sql] SELECT * FROM `an` WHERE `po` = 15 AND `raw` = 15 LIMIT 1 [ RunTime:0.000215s ] [2024-11-13T15:32:09+08:00][sql] SELECT MAX(`number`) AS think_max FROM `an` WHERE `number` LIKE '20240409%' LIMIT 1 [ RunTime:0.000212s ] [2024-11-13T15:32:09+08:00][sql] INSERT INTO `an` SET `po` = 15 , `number` = '20240409015' , `raw` = 15 , `count` = '4.00' , `supplier` = 8 , `status` = 3 , `create_time` = '2024-04-09 07:57:40' , `update_time` = '2024-11-13 15:32:09.130042' [ RunTime:0.002684s ] [2024-11-13T15:32:09+08:00][sql] SELECT * FROM `an` WHERE `po` = 16 AND `raw` = 16 LIMIT 1 [ RunTime:0.000254s ] [2024-11-13T15:32:09+08:00][sql] SELECT MAX(`number`) AS think_max FROM `an` WHERE `number` LIKE '20240409%' LIMIT 1 [ RunTime:0.000204s ] [2024-11-13T15:32:09+08:00][sql] INSERT INTO `an` SET `po` = 16 , `number` = '20240409016' , `raw` = 16 , `count` = '4.00' , `supplier` = 8 , `status` = 3 , `create_time` = '2024-04-09 08:19:52' , `update_time` = '2024-11-13 15:32:09.133744' [ RunTime:0.000189s ] [2024-11-13T15:32:09+08:00][sql] SELECT * FROM `an` WHERE `po` = 17 AND `raw` = 17 LIMIT 1 [ RunTime:0.000227s ] [2024-11-13T15:32:09+08:00][sql] SELECT MAX(`number`) AS think_max FROM `an` WHERE `number` LIKE '20240409%' LIMIT 1 [ RunTime:0.000229s ] [2024-11-13T15:32:09+08:00][sql] INSERT INTO `an` SET `po` = 17 , `number` = '20240409017' , `raw` = 17 , `count` = '2.00' , `supplier` = 4 , `status` = 3 , `create_time` = '2024-04-09 05:10:04' , `update_time` = '2024-11-13 15:32:09.135035' [ RunTime:0.000364s ] [2024-11-13T15:32:09+08:00][sql] SELECT * FROM `an` WHERE `po` = 18 AND `raw` = 18 LIMIT 1 [ RunTime:0.000240s ] [2024-11-13T15:32:09+08:00][sql] SELECT MAX(`number`) AS think_max FROM `an` WHERE `number` LIKE '20240409%' LIMIT 1 [ RunTime:0.000178s ] [2024-11-13T15:32:09+08:00][sql] INSERT INTO `an` SET `po` = 18 , `number` = '20240409018' , `raw` = 18 , `count` = '2.00' , `supplier` = 6 , `status` = 3 , `create_time` = '2024-04-09 05:08:36' , `update_time` = '2024-11-13 15:32:09.136341' [ RunTime:0.000179s ] [2024-11-13T15:32:09+08:00][sql] SELECT * FROM `an` WHERE `po` = 19 AND `raw` = 19 LIMIT 1 [ RunTime:0.000201s ] [2024-11-13T15:32:09+08:00][sql] SELECT MAX(`number`) AS think_max FROM `an` WHERE `number` LIKE '20240409%' LIMIT 1 [ RunTime:0.000221s ] [2024-11-13T15:32:09+08:00][sql] INSERT INTO `an` SET `po` = 19 , `number` = '20240409019' , `raw` = 19 , `count` = '10.00' , `supplier` = 8 , `status` = 3 , `create_time` = '2024-04-09 05:14:52' , `update_time` = '2024-11-13 15:32:09.137477' [ RunTime:0.000194s ] [2024-11-13T15:32:09+08:00][sql] SELECT * FROM `an` WHERE `po` = 20 AND `raw` = 20 LIMIT 1 [ RunTime:0.000198s ] [2024-11-13T15:32:09+08:00][sql] SELECT MAX(`number`) AS think_max FROM `an` WHERE `number` LIKE '20240409%' LIMIT 1 [ RunTime:0.000195s ] [2024-11-13T15:32:09+08:00][sql] INSERT INTO `an` SET `po` = 20 , `number` = '20240409020' , `raw` = 20 , `count` = '2.00' , `supplier` = 8 , `status` = 3 , `create_time` = '2024-04-09 11:05:43' , `update_time` = '2024-11-13 15:32:09.138585' [ RunTime:0.000220s ] [2024-11-13T15:32:09+08:00][sql] SELECT * FROM `an` WHERE `po` = 21 AND `raw` = 21 LIMIT 1 [ RunTime:0.000235s ] [2024-11-13T15:32:09+08:00][sql] SELECT MAX(`number`) AS think_max FROM `an` WHERE `number` LIKE '20240409%' LIMIT 1 [ RunTime:0.000186s ] [2024-11-13T15:32:09+08:00][sql] INSERT INTO `an` SET `po` = 21 , `number` = '20240409021' , `raw` = 21 , `count` = '2.00' , `supplier` = 4 , `status` = 3 , `create_time` = '2024-04-09 11:27:02' , `update_time` = '2024-11-13 15:32:09.139763' [ RunTime:0.000185s ] [2024-11-13T15:32:09+08:00][sql] SELECT * FROM `an` WHERE `po` = 22 AND `raw` = 22 LIMIT 1 [ RunTime:0.000210s ] [2024-11-13T15:32:09+08:00][sql] SELECT MAX(`number`) AS think_max FROM `an` WHERE `number` LIKE '20240409%' LIMIT 1 [ RunTime:0.000213s ] [2024-11-13T15:32:09+08:00][sql] INSERT INTO `an` SET `po` = 22 , `number` = '20240409022' , `raw` = 22 , `count` = '2.00' , `supplier` = 6 , `status` = 3 , `create_time` = '2024-04-09 01:54:59' , `update_time` = '2024-11-13 15:32:09.140894' [ RunTime:0.000189s ] [2024-11-13T15:32:09+08:00][sql] CONNECT:[ UseTime:0.012834s ] mysql:host=127.0.0.1;port=3306;dbname=hbzahxkj;charset=utf8 [2024-11-13T15:32:09+08:00][sql] SHOW FULL COLUMNS FROM `set` [ RunTime:0.000735s ] [2024-11-13T15:32:09+08:00][sql] UPDATE `set` SET `value` = 'hbzahxkj' WHERE `field` = 'database' [ RunTime:0.000289s ] [2024-11-13T15:32:09+08:00][sql] UPDATE `set` SET `value` = '河北中安禾信科技有限公司' WHERE `field` = 'title' [ RunTime:0.000207s ] [2024-11-13T15:32:09+08:00][sql] UPDATE `set` SET `value` = '42,43,389' WHERE `field` = 'product_sort' [ RunTime:0.000218s ] [2024-11-13T15:32:09+08:00][sql] SHOW FULL COLUMNS FROM `an` [ RunTime:0.000978s ] [2024-11-13T15:32:09+08:00][sql] SELECT * FROM `an` WHERE `id` IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22) [ RunTime:0.000489s ] [2024-11-13T15:32:09+08:00][sql] SHOW FULL COLUMNS FROM `raw` [ RunTime:0.000712s ] [2024-11-13T15:32:09+08:00][sql] SELECT * FROM `raw` WHERE `id` IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22) [ RunTime:0.000367s ] [2024-11-13T15:32:09+08:00][sql] SHOW FULL COLUMNS FROM `iqc` [ RunTime:0.001411s ] [2024-11-13T15:32:09+08:00][sql] SELECT * FROM `iqc` WHERE `an` = '1' AND `raw` = 1 LIMIT 1 [ RunTime:0.000247s ] [2024-11-13T15:32:09+08:00][sql] SELECT MAX(`number`) AS think_max FROM `iqc` WHERE `number` LIKE '20240410%' LIMIT 1 [ RunTime:0.000219s ] [2024-11-13T15:32:09+08:00][sql] INSERT INTO `iqc` SET `number` = '20240410001' , `an` = '1' , `raw` = 1 , `supplier` = 8 , `count` = '12.00' , `result` = '1' , `maker` = 0 , `ratif` = 0 , `remark` = '' , `status` = 4 , `create_time` = '2024-04-10' , `update_time` = '2024-11-13 15:32:09.336593' [ RunTime:0.000298s ] [2024-11-13T15:32:09+08:00][sql] SHOW FULL COLUMNS FROM `tpl` [ RunTime:0.000993s ] [2024-11-13T15:32:09+08:00][sql] SELECT * FROM `tpl` WHERE `status` = 1 AND `tpl_sort` = '14' AND `sort` = 1042 [ RunTime:0.000325s ] [2024-11-13T15:32:09+08:00][sql] SHOW FULL COLUMNS FROM `tpl_info` [ RunTime:0.000969s ] [2024-11-13T15:32:09+08:00][sql] SELECT * FROM `tpl_info` WHERE `tpl` = 26 ORDER BY `order` ASC [ RunTime:0.000367s ] [2024-11-13T15:32:09+08:00][sql] SHOW FULL COLUMNS FROM `iqc_note` [ RunTime:0.001245s ] [2024-11-13T15:32:09+08:00][sql] SELECT * FROM `iqc_note` WHERE `iqc` = 1 AND `tpl_raw_info` = 156 LIMIT 1 [ RunTime:0.000246s ] [2024-11-13T15:32:09+08:00][sql] INSERT INTO `iqc_note` SET `iqc` = 1 , `tpl_raw_info` = 156 , `qc_count` = '3' , `count` = '3' , `note` = '1,1,1,' , `ng` = '0' , `create_time` = '2024-04-10' , `remark` = '' , `update_time` = '2024-11-13 15:32:09.343968' [ RunTime:0.000269s ] [2024-11-13T15:32:09+08:00][sql] SELECT * FROM `iqc_note` WHERE `iqc` = 1 AND `tpl_raw_info` = 155 LIMIT 1 [ RunTime:0.000237s ] [2024-11-13T15:32:09+08:00][sql] INSERT INTO `iqc_note` SET `iqc` = 1 , `tpl_raw_info` = 155 , `qc_count` = '3' , `count` = '3' , `note` = '1,1,1,' , `ng` = '0' , `create_time` = '2024-04-10' , `remark` = '' , `update_time` = '2024-11-13 15:32:09.344939' [ RunTime:0.000217s ] [2024-11-13T15:32:09+08:00][sql] SELECT * FROM `iqc_note` WHERE `iqc` = 1 AND `tpl_raw_info` = 154 LIMIT 1 [ RunTime:0.000216s ] [2024-11-13T15:32:09+08:00][sql] INSERT INTO `iqc_note` SET `iqc` = 1 , `tpl_raw_info` = 154 , `qc_count` = '3' , `count` = '3' , `note` = '1,1,1,' , `ng` = '0' , `create_time` = '2024-04-10' , `remark` = '' , `update_time` = '2024-11-13 15:32:09.345825' [ RunTime:0.000194s ] [2024-11-13T15:32:09+08:00][sql] SELECT * FROM `iqc` WHERE `an` = '2' AND `raw` = 2 LIMIT 1 [ RunTime:0.000216s ] [2024-11-13T15:32:09+08:00][sql] SELECT MAX(`number`) AS think_max FROM `iqc` WHERE `number` LIKE '20240410%' LIMIT 1 [ RunTime:0.000197s ] [2024-11-13T15:32:09+08:00][sql] INSERT INTO `iqc` SET `number` = '20240410002' , `an` = '2' , `raw` = 2 , `supplier` = 1 , `count` = '2.00' , `result` = '1' , `maker` = 0 , `ratif` = 0 , `remark` = '' , `status` = 4 , `create_time` = '2024-04-10' , `update_time` = '2024-11-13 15:32:09.346993' [ RunTime:0.000221s ] [2024-11-13T15:32:09+08:00][sql] SELECT * FROM `tpl` WHERE `status` = 1 AND `tpl_sort` = '14' AND `sort` = 1043 [ RunTime:0.000243s ] [2024-11-13T15:32:09+08:00][sql] SELECT * FROM `tpl_info` WHERE `tpl` = 27 ORDER BY `order` ASC [ RunTime:0.000299s ] [2024-11-13T15:32:09+08:00][sql] SELECT * FROM `iqc_note` WHERE `iqc` = 2 AND `tpl_raw_info` = 159 LIMIT 1 [ RunTime:0.000228s ] [2024-11-13T15:32:09+08:00][sql] INSERT INTO `iqc_note` SET `iqc` = 2 , `tpl_raw_info` = 159 , `qc_count` = '2' , `count` = '2' , `note` = '1,1,' , `ng` = '0' , `create_time` = '2024-04-10' , `remark` = '' , `update_time` = '2024-11-13 15:32:09.348978' [ RunTime:0.000201s ] [2024-11-13T15:32:09+08:00][sql] SELECT * FROM `iqc_note` WHERE `iqc` = 2 AND `tpl_raw_info` = 158 LIMIT 1 [ RunTime:0.000215s ] [2024-11-13T15:32:09+08:00][sql] INSERT INTO `iqc_note` SET `iqc` = 2 , `tpl_raw_info` = 158 , `qc_count` = '2' , `count` = '2' , `note` = '1,1,' , `ng` = '0' , `create_time` = '2024-04-10' , `remark` = '' , `update_time` = '2024-11-13 15:32:09.349830' [ RunTime:0.000214s ] [2024-11-13T15:32:09+08:00][sql] SELECT * FROM `iqc_note` WHERE `iqc` = 2 AND `tpl_raw_info` = 157 LIMIT 1 [ RunTime:0.000216s ] [2024-11-13T15:32:09+08:00][sql] INSERT INTO `iqc_note` SET `iqc` = 2 , `tpl_raw_info` = 157 , `qc_count` = '2' , `count` = '2' , `note` = '1,1,' , `ng` = '0' , `create_time` = '2024-04-10' , `remark` = '' , `update_time` = '2024-11-13 15:32:09.350660' [ RunTime:0.000190s ] [2024-11-13T15:32:09+08:00][sql] SELECT * FROM `iqc` WHERE `an` = '3' AND `raw` = 3 LIMIT 1 [ RunTime:0.000207s ] [2024-11-13T15:32:09+08:00][sql] SELECT MAX(`number`) AS think_max FROM `iqc` WHERE `number` LIKE '20240410%' LIMIT 1 [ RunTime:0.000205s ] [2024-11-13T15:32:09+08:00][sql] INSERT INTO `iqc` SET `number` = '20240410003' , `an` = '3' , `raw` = 3 , `supplier` = 5 , `count` = '8.00' , `result` = '1' , `maker` = 0 , `ratif` = 0 , `remark` = '' , `status` = 4 , `create_time` = '2024-04-10' , `update_time` = '2024-11-13 15:32:09.351830' [ RunTime:0.000221s ] [2024-11-13T15:32:09+08:00][sql] SELECT * FROM `tpl` WHERE `status` = 1 AND `tpl_sort` = '14' AND `sort` = 406 [ RunTime:0.000249s ] [2024-11-13T15:32:09+08:00][sql] SELECT * FROM `tpl_info` WHERE `tpl` = 18 ORDER BY `order` ASC [ RunTime:0.000326s ] [2024-11-13T15:32:09+08:00][sql] SELECT * FROM `iqc_note` WHERE `iqc` = 3 AND `tpl_raw_info` = 131 LIMIT 1 [ RunTime:0.000266s ] [2024-11-13T15:32:09+08:00][sql] INSERT INTO `iqc_note` SET `iqc` = 3 , `tpl_raw_info` = 131 , `qc_count` = '2' , `count` = '2' , `note` = '1,1,' , `ng` = '0' , `create_time` = '2024-04-10' , `remark` = '' , `update_time` = '2024-11-13 15:32:09.353915' [ RunTime:0.000225s ] [2024-11-13T15:32:09+08:00][sql] SELECT * FROM `iqc_note` WHERE `iqc` = 3 AND `tpl_raw_info` = 132 LIMIT 1 [ RunTime:0.000222s ] [2024-11-13T15:32:09+08:00][sql] INSERT INTO `iqc_note` SET `iqc` = 3 , `tpl_raw_info` = 132 , `qc_count` = '2' , `count` = '2' , `note` = '1,1,' , `ng` = '0' , `create_time` = '2024-04-10' , `remark` = '' , `update_time` = '2024-11-13 15:32:09.354876' [ RunTime:0.000199s ] [2024-11-13T15:32:09+08:00][sql] SELECT * FROM `iqc_note` WHERE `iqc` = 3 AND `tpl_raw_info` = 133 LIMIT 1 [ RunTime:0.000226s ] [2024-11-13T15:32:09+08:00][sql] INSERT INTO `iqc_note` SET `iqc` = 3 , `tpl_raw_info` = 133 , `qc_count` = '2' , `count` = '2' , `note` = '1,1,' , `ng` = '0' , `create_time` = '2024-04-10' , `remark` = '' , `update_time` = '2024-11-13 15:32:09.355732' [ RunTime:0.000207s ] [2024-11-13T15:32:09+08:00][sql] SELECT * FROM `iqc` WHERE `an` = '4' AND `raw` = 4 LIMIT 1 [ RunTime:0.000259s ] [2024-11-13T15:32:09+08:00][sql] SELECT MAX(`number`) AS think_max FROM `iqc` WHERE `number` LIKE '20240410%' LIMIT 1 [ RunTime:0.000212s ] [2024-11-13T15:32:09+08:00][sql] INSERT INTO `iqc` SET `number` = '20240410004' , `an` = '4' , `raw` = 4 , `supplier` = 8 , `count` = '18.00' , `result` = '1' , `maker` = 0 , `ratif` = 0 , `remark` = '' , `status` = 4 , `create_time` = '2024-04-10' , `update_time` = '2024-11-13 15:32:09.357044' [ RunTime:0.000218s ] [2024-11-13T15:32:09+08:00][sql] SELECT * FROM `tpl` WHERE `status` = 1 AND `tpl_sort` = '14' AND `sort` = 604 [ RunTime:0.000233s ] [2024-11-13T15:32:09+08:00][sql] SELECT * FROM `tpl_info` WHERE `tpl` = 24 ORDER BY `order` ASC [ RunTime:0.000320s ] [2024-11-13T15:32:09+08:00][sql] SELECT * FROM `iqc_note` WHERE `iqc` = 4 AND `tpl_raw_info` = 149 LIMIT 1 [ RunTime:0.000254s ] [2024-11-13T15:32:09+08:00][sql] INSERT INTO `iqc_note` SET `iqc` = 4 , `tpl_raw_info` = 149 , `qc_count` = '5' , `count` = '5' , `note` = '1,1,1,1,1,' , `ng` = '0' , `create_time` = '2024-04-10' , `remark` = '' , `update_time` = '2024-11-13 15:32:09.359158' [ RunTime:0.000262s ] [2024-11-13T15:32:09+08:00][sql] SELECT * FROM `iqc_note` WHERE `iqc` = 4 AND `tpl_raw_info` = 148 LIMIT 1 [ RunTime:0.000212s ] [2024-11-13T15:32:09+08:00][sql] INSERT INTO `iqc_note` SET `iqc` = 4 , `tpl_raw_info` = 148 , `qc_count` = '5' , `count` = '5' , `note` = '1,1,1,1,1,' , `ng` = '0' , `create_time` = '2024-04-10' , `remark` = '' , `update_time` = '2024-11-13 15:32:09.360049' [ RunTime:0.000228s ] [2024-11-13T15:32:09+08:00][sql] SELECT * FROM `iqc_note` WHERE `iqc` = 4 AND `tpl_raw_info` = 147 LIMIT 1 [ RunTime:0.000198s ] [2024-11-13T15:32:09+08:00][sql] INSERT INTO `iqc_note` SET `iqc` = 4 , `tpl_raw_info` = 147 , `qc_count` = '5' , `count` = '5' , `note` = '1,1,1,1,1,' , `ng` = '0' , `create_time` = '2024-04-10' , `remark` = '' , `update_time` = '2024-11-13 15:32:09.360918' [ RunTime:0.000187s ] [2024-11-13T15:32:09+08:00][sql] SELECT * FROM `iqc` WHERE `an` = '5' AND `raw` = 5 LIMIT 1 [ RunTime:0.000215s ] [2024-11-13T15:32:09+08:00][sql] SELECT MAX(`number`) AS think_max FROM `iqc` WHERE `number` LIKE '20240410%' LIMIT 1 [ RunTime:0.000205s ] [2024-11-13T15:32:09+08:00][sql] INSERT INTO `iqc` SET `number` = '20240410005' , `an` = '5' , `raw` = 5 , `supplier` = 8 , `count` = '4.00' , `result` = '1' , `maker` = 0 , `ratif` = 0 , `remark` = '' , `status` = 4 , `create_time` = '2024-04-10' , `update_time` = '2024-11-13 15:32:09.362081' [ RunTime:0.000260s ] [2024-11-13T15:32:09+08:00][sql] SELECT * FROM `tpl` WHERE `status` = 1 AND `tpl_sort` = '14' AND `sort` = 604 [ RunTime:0.000238s ] [2024-11-13T15:32:09+08:00][sql] SELECT * FROM `tpl_info` WHERE `tpl` = 24 ORDER BY `order` ASC [ RunTime:0.000297s ] [2024-11-13T15:32:09+08:00][sql] SELECT * FROM `iqc_note` WHERE `iqc` = 5 AND `tpl_raw_info` = 149 LIMIT 1 [ RunTime:0.000226s ] [2024-11-13T15:32:09+08:00][sql] INSERT INTO `iqc_note` SET `iqc` = 5 , `tpl_raw_info` = 149 , `qc_count` = '2' , `count` = '2' , `note` = '1,1,' , `ng` = '0' , `create_time` = '2024-04-10' , `remark` = '' , `update_time` = '2024-11-13 15:32:09.364042' [ RunTime:0.000243s ] [2024-11-13T15:32:09+08:00][sql] SELECT * FROM `iqc_note` WHERE `iqc` = 5 AND `tpl_raw_info` = 148 LIMIT 1 [ RunTime:0.000214s ] [2024-11-13T15:32:09+08:00][sql] INSERT INTO `iqc_note` SET `iqc` = 5 , `tpl_raw_info` = 148 , `qc_count` = '2' , `count` = '2' , `note` = '1,1,' , `ng` = '0' , `create_time` = '2024-04-10' , `remark` = '' , `update_time` = '2024-11-13 15:32:09.364923' [ RunTime:0.000977s ] [2024-11-13T15:32:09+08:00][sql] SELECT * FROM `iqc_note` WHERE `iqc` = 5 AND `tpl_raw_info` = 147 LIMIT 1 [ RunTime:0.000259s ] [2024-11-13T15:32:09+08:00][sql] INSERT INTO `iqc_note` SET `iqc` = 5 , `tpl_raw_info` = 147 , `qc_count` = '2' , `count` = '2' , `note` = '1,1,' , `ng` = '0' , `create_time` = '2024-04-10' , `remark` = '' , `update_time` = '2024-11-13 15:32:09.366620' [ RunTime:0.000234s ] [2024-11-13T15:32:09+08:00][sql] SELECT * FROM `iqc` WHERE `an` = '6' AND `raw` = 6 LIMIT 1 [ RunTime:0.000253s ] [2024-11-13T15:32:09+08:00][sql] SELECT MAX(`number`) AS think_max FROM `iqc` WHERE `number` LIKE '20240410%' LIMIT 1 [ RunTime:0.000238s ] [2024-11-13T15:32:09+08:00][sql] INSERT INTO `iqc` SET `number` = '20240410006' , `an` = '6' , `raw` = 6 , `supplier` = 8 , `count` = '29.00' , `result` = '1' , `maker` = 0 , `ratif` = 0 , `remark` = '' , `status` = 4 , `create_time` = '2024-04-10' , `update_time` = '2024-11-13 15:32:09.367925' [ RunTime:0.000238s ] [2024-11-13T15:32:09+08:00][sql] SELECT * FROM `tpl` WHERE `status` = 1 AND `tpl_sort` = '14' AND `sort` = 412 [ RunTime:0.000259s ] [2024-11-13T15:32:09+08:00][sql] SELECT * FROM `tpl_info` WHERE `tpl` = 20 ORDER BY `order` ASC [ RunTime:0.000305s ] [2024-11-13T15:32:09+08:00][sql] SELECT * FROM `iqc_note` WHERE `iqc` = 6 AND `tpl_raw_info` = 138 LIMIT 1 [ RunTime:0.000288s ] [2024-11-13T15:32:09+08:00][sql] INSERT INTO `iqc_note` SET `iqc` = 6 , `tpl_raw_info` = 138 , `qc_count` = '8' , `count` = '8' , `note` = '1,1,1,1,1,1,1,1,' , `ng` = '0' , `create_time` = '2024-04-10' , `remark` = '' , `update_time` = '2024-11-13 15:32:09.370016' [ RunTime:0.000205s ] [2024-11-13T15:32:09+08:00][sql] SELECT * FROM `iqc_note` WHERE `iqc` = 6 AND `tpl_raw_info` = 137 LIMIT 1 [ RunTime:0.000229s ] [2024-11-13T15:32:09+08:00][sql] INSERT INTO `iqc_note` SET `iqc` = 6 , `tpl_raw_info` = 137 , `qc_count` = '8' , `count` = '8' , `note` = '1,1,1,1,1,1,1,1,' , `ng` = '0' , `create_time` = '2024-04-10' , `remark` = '' , `update_time` = '2024-11-13 15:32:09.370889' [ RunTime:0.000190s ] [2024-11-13T15:32:09+08:00][sql] SELECT * FROM `iqc_note` WHERE `iqc` = 6 AND `tpl_raw_info` = 136 LIMIT 1 [ RunTime:0.000214s ] [2024-11-13T15:32:09+08:00][sql] INSERT INTO `iqc_note` SET `iqc` = 6 , `tpl_raw_info` = 136 , `qc_count` = '8' , `count` = '8' , `note` = '1,1,1,1,1,1,1,1,' , `ng` = '0' , `create_time` = '2024-04-10' , `remark` = '' , `update_time` = '2024-11-13 15:32:09.371724' [ RunTime:0.000179s ] [2024-11-13T15:32:09+08:00][sql] SELECT * FROM `iqc` WHERE `an` = '7' AND `raw` = 7 LIMIT 1 [ RunTime:0.000235s ] [2024-11-13T15:32:09+08:00][sql] SELECT MAX(`number`) AS think_max FROM `iqc` WHERE `number` LIKE '20240410%' LIMIT 1 [ RunTime:0.000214s ] [2024-11-13T15:32:09+08:00][sql] INSERT INTO `iqc` SET `number` = '20240410007' , `an` = '7' , `raw` = 7 , `supplier` = 5 , `count` = '4.00' , `result` = '1' , `maker` = 0 , `ratif` = 0 , `remark` = '' , `status` = 4 , `create_time` = '2024-04-10' , `update_time` = '2024-11-13 15:32:09.372903' [ RunTime:0.000241s ] [2024-11-13T15:32:09+08:00][sql] SELECT * FROM `tpl` WHERE `status` = 1 AND `tpl_sort` = '14' AND `sort` = 1044 [ RunTime:0.000244s ] [2024-11-13T15:32:09+08:00][sql] SELECT * FROM `tpl_info` WHERE `tpl` = 28 ORDER BY `order` ASC [ RunTime:0.000297s ] [2024-11-13T15:32:09+08:00][sql] SELECT * FROM `iqc_note` WHERE `iqc` = 7 AND `tpl_raw_info` = 162 LIMIT 1 [ RunTime:0.000235s ] [2024-11-13T15:32:09+08:00][sql] INSERT INTO `iqc_note` SET `iqc` = 7 , `tpl_raw_info` = 162 , `qc_count` = '2' , `count` = '2' , `note` = '1,1,' , `ng` = '0' , `create_time` = '2024-04-10' , `remark` = '' , `update_time` = '2024-11-13 15:32:09.374905' [ RunTime:0.000186s ] [2024-11-13T15:32:09+08:00][sql] SELECT * FROM `iqc_note` WHERE `iqc` = 7 AND `tpl_raw_info` = 161 LIMIT 1 [ RunTime:0.000222s ] [2024-11-13T15:32:09+08:00][sql] INSERT INTO `iqc_note` SET `iqc` = 7 , `tpl_raw_info` = 161 , `qc_count` = '2' , `count` = '2' , `note` = '1,1,' , `ng` = '0' , `create_time` = '2024-04-10' , `remark` = '' , `update_time` = '2024-11-13 15:32:09.375721' [ RunTime:0.000171s ] [2024-11-13T15:32:09+08:00][sql] SELECT * FROM `iqc_note` WHERE `iqc` = 7 AND `tpl_raw_info` = 160 LIMIT 1 [ RunTime:0.000196s ] [2024-11-13T15:32:09+08:00][sql] INSERT INTO `iqc_note` SET `iqc` = 7 , `tpl_raw_info` = 160 , `qc_count` = '2' , `count` = '2' , `note` = '1,1,' , `ng` = '0' , `create_time` = '2024-04-10' , `remark` = '' , `update_time` = '2024-11-13 15:32:09.376515' [ RunTime:0.000174s ] [2024-11-13T15:32:09+08:00][sql] SELECT * FROM `iqc` WHERE `an` = '8' AND `raw` = 8 LIMIT 1 [ RunTime:0.000213s ] [2024-11-13T15:32:09+08:00][sql] SELECT MAX(`number`) AS think_max FROM `iqc` WHERE `number` LIKE '20240410%' LIMIT 1 [ RunTime:0.000213s ] [2024-11-13T15:32:09+08:00][sql] INSERT INTO `iqc` SET `number` = '20240410008' , `an` = '8' , `raw` = 8 , `supplier` = 8 , `count` = '6.00' , `result` = '1' , `maker` = 0 , `ratif` = 0 , `remark` = '' , `status` = 4 , `create_time` = '2024-04-10' , `update_time` = '2024-11-13 15:32:09.377671' [ RunTime:0.000227s ] [2024-11-13T15:32:09+08:00][sql] SELECT * FROM `tpl` WHERE `status` = 1 AND `tpl_sort` = '14' AND `sort` = 1045 [ RunTime:0.000239s ] [2024-11-13T15:32:09+08:00][sql] SELECT * FROM `tpl_info` WHERE `tpl` = 29 ORDER BY `order` ASC [ RunTime:0.000277s ] [2024-11-13T15:32:09+08:00][sql] SELECT * FROM `iqc_note` WHERE `iqc` = 8 AND `tpl_raw_info` = 165 LIMIT 1 [ RunTime:0.000240s ] [2024-11-13T15:32:09+08:00][sql] INSERT INTO `iqc_note` SET `iqc` = 8 , `tpl_raw_info` = 165 , `qc_count` = '2' , `count` = '2' , `note` = '1,1,' , `ng` = '0' , `create_time` = '2024-04-10' , `remark` = '' , `update_time` = '2024-11-13 15:32:09.379623' [ RunTime:0.000211s ] [2024-11-13T15:32:09+08:00][sql] SELECT * FROM `iqc_note` WHERE `iqc` = 8 AND `tpl_raw_info` = 164 LIMIT 1 [ RunTime:0.000199s ] [2024-11-13T15:32:09+08:00][sql] INSERT INTO `iqc_note` SET `iqc` = 8 , `tpl_raw_info` = 164 , `qc_count` = '2' , `count` = '2' , `note` = '1,1,' , `ng` = '0' , `create_time` = '2024-04-10' , `remark` = '' , `update_time` = '2024-11-13 15:32:09.380468' [ RunTime:0.000174s ] [2024-11-13T15:32:09+08:00][sql] SELECT * FROM `iqc_note` WHERE `iqc` = 8 AND `tpl_raw_info` = 163 LIMIT 1 [ RunTime:0.000205s ] [2024-11-13T15:32:09+08:00][sql] INSERT INTO `iqc_note` SET `iqc` = 8 , `tpl_raw_info` = 163 , `qc_count` = '2' , `count` = '2' , `note` = '1,1,' , `ng` = '0' , `create_time` = '2024-04-10' , `remark` = '' , `update_time` = '2024-11-13 15:32:09.381274' [ RunTime:0.000207s ] [2024-11-13T15:32:09+08:00][sql] SELECT * FROM `iqc` WHERE `an` = '9' AND `raw` = 9 LIMIT 1 [ RunTime:0.000223s ] [2024-11-13T15:32:09+08:00][sql] SELECT MAX(`number`) AS think_max FROM `iqc` WHERE `number` LIKE '20240410%' LIMIT 1 [ RunTime:0.000236s ] [2024-11-13T15:32:09+08:00][sql] INSERT INTO `iqc` SET `number` = '20240410009' , `an` = '9' , `raw` = 9 , `supplier` = 7 , `count` = '2.00' , `result` = '1' , `maker` = 0 , `ratif` = 0 , `remark` = '' , `status` = 4 , `create_time` = '2024-04-10' , `update_time` = '2024-11-13 15:32:09.382496' [ RunTime:0.000245s ] [2024-11-13T15:32:09+08:00][sql] SELECT * FROM `tpl` WHERE `status` = 1 AND `tpl_sort` = '14' AND `sort` = 379 [ RunTime:0.000233s ] [2024-11-13T15:32:09+08:00][sql] SELECT * FROM `tpl_info` WHERE `tpl` = 16 ORDER BY `order` ASC [ RunTime:0.000335s ] [2024-11-13T15:32:09+08:00][sql] SELECT * FROM `iqc_note` WHERE `iqc` = 9 AND `tpl_raw_info` = 127 LIMIT 1 [ RunTime:0.000244s ] [2024-11-13T15:32:09+08:00][sql] INSERT INTO `iqc_note` SET `iqc` = 9 , `tpl_raw_info` = 127 , `qc_count` = '2' , `count` = '2' , `note` = '1,1,' , `ng` = '0' , `create_time` = '2024-04-10' , `remark` = '' , `update_time` = '2024-11-13 15:32:09.384547' [ RunTime:0.000179s ] [2024-11-13T15:32:09+08:00][sql] SELECT * FROM `iqc_note` WHERE `iqc` = 9 AND `tpl_raw_info` = 128 LIMIT 1 [ RunTime:0.000204s ] [2024-11-13T15:32:09+08:00][sql] INSERT INTO `iqc_note` SET `iqc` = 9 , `tpl_raw_info` = 128 , `qc_count` = '2' , `count` = '2' , `note` = '1,1,' , `ng` = '0' , `create_time` = '2024-04-10' , `remark` = '' , `update_time` = '2024-11-13 15:32:09.385353' [ RunTime:0.000179s ] [2024-11-13T15:32:09+08:00][sql] SELECT * FROM `iqc` WHERE `an` = '10' AND `raw` = 10 LIMIT 1 [ RunTime:0.000217s ] [2024-11-13T15:32:09+08:00][sql] SELECT MAX(`number`) AS think_max FROM `iqc` WHERE `number` LIKE '20240410%' LIMIT 1 [ RunTime:0.000195s ] [2024-11-13T15:32:09+08:00][sql] INSERT INTO `iqc` SET `number` = '20240410010' , `an` = '10' , `raw` = 10 , `supplier` = 7 , `count` = '2.00' , `result` = '1' , `maker` = 0 , `ratif` = 0 , `remark` = '' , `status` = 4 , `create_time` = '2024-04-10' , `update_time` = '2024-11-13 15:32:09.386503' [ RunTime:0.000233s ] [2024-11-13T15:32:09+08:00][sql] SELECT * FROM `tpl` WHERE `status` = 1 AND `tpl_sort` = '14' AND `sort` = 380 [ RunTime:0.000228s ] [2024-11-13T15:32:09+08:00][sql] SELECT * FROM `tpl_info` WHERE `tpl` = 17 ORDER BY `order` ASC [ RunTime:0.000295s ] [2024-11-13T15:32:09+08:00][sql] SELECT * FROM `iqc_note` WHERE `iqc` = 10 AND `tpl_raw_info` = 130 LIMIT 1 [ RunTime:0.000244s ] [2024-11-13T15:32:09+08:00][sql] INSERT INTO `iqc_note` SET `iqc` = 10 , `tpl_raw_info` = 130 , `qc_count` = '2' , `count` = '2' , `note` = '1,1,' , `ng` = '0' , `create_time` = '2024-04-10' , `remark` = '' , `update_time` = '2024-11-13 15:32:09.388485' [ RunTime:0.000180s ] [2024-11-13T15:32:09+08:00][sql] SELECT * FROM `iqc_note` WHERE `iqc` = 10 AND `tpl_raw_info` = 129 LIMIT 1 [ RunTime:0.000208s ] [2024-11-13T15:32:09+08:00][sql] INSERT INTO `iqc_note` SET `iqc` = 10 , `tpl_raw_info` = 129 , `qc_count` = '2' , `count` = '2' , `note` = '1,1,' , `ng` = '0' , `create_time` = '2024-04-10' , `remark` = '' , `update_time` = '2024-11-13 15:32:09.389298' [ RunTime:0.000192s ] [2024-11-13T15:32:09+08:00][sql] SELECT * FROM `iqc` WHERE `an` = '11' AND `raw` = 11 LIMIT 1 [ RunTime:0.000213s ] [2024-11-13T15:32:09+08:00][sql] SELECT MAX(`number`) AS think_max FROM `iqc` WHERE `number` LIKE '20240410%' LIMIT 1 [ RunTime:0.000203s ] [2024-11-13T15:32:09+08:00][sql] INSERT INTO `iqc` SET `number` = '20240410011' , `an` = '11' , `raw` = 11 , `supplier` = 3 , `count` = '1018.00' , `result` = '1' , `maker` = 0 , `ratif` = 0 , `remark` = '' , `status` = 4 , `create_time` = '2024-04-10' , `update_time` = '2024-11-13 15:32:09.390475' [ RunTime:0.000245s ] [2024-11-13T15:32:09+08:00][sql] SELECT * FROM `tpl` WHERE `status` = 1 AND `tpl_sort` = '14' AND `sort` = 419 [ RunTime:0.000252s ] [2024-11-13T15:32:09+08:00][sql] SELECT * FROM `tpl_info` WHERE `tpl` = 21 ORDER BY `order` ASC [ RunTime:0.000278s ] [2024-11-13T15:32:09+08:00][sql] SELECT * FROM `iqc_note` WHERE `iqc` = 11 AND `tpl_raw_info` = 140 LIMIT 1 [ RunTime:0.000225s ] [2024-11-13T15:32:09+08:00][sql] INSERT INTO `iqc_note` SET `iqc` = 11 , `tpl_raw_info` = 140 , `qc_count` = '80' , `count` = '80' , `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,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` = '2024-04-10' , `remark` = '' , `update_time` = '2024-11-13 15:32:09.392431' [ RunTime:0.000184s ] [2024-11-13T15:32:09+08:00][sql] SELECT * FROM `iqc_note` WHERE `iqc` = 11 AND `tpl_raw_info` = 139 LIMIT 1 [ RunTime:0.000206s ] [2024-11-13T15:32:09+08:00][sql] INSERT INTO `iqc_note` SET `iqc` = 11 , `tpl_raw_info` = 139 , `qc_count` = '80' , `count` = '80' , `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,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` = '2024-04-10' , `remark` = '' , `update_time` = '2024-11-13 15:32:09.393283' [ RunTime:0.000184s ] [2024-11-13T15:32:09+08:00][sql] SELECT * FROM `iqc` WHERE `an` = '12' AND `raw` = 12 LIMIT 1 [ RunTime:0.000212s ] [2024-11-13T15:32:09+08:00][sql] SELECT MAX(`number`) AS think_max FROM `iqc` WHERE `number` LIKE '20240410%' LIMIT 1 [ RunTime:0.000209s ] [2024-11-13T15:32:09+08:00][sql] INSERT INTO `iqc` SET `number` = '20240410012' , `an` = '12' , `raw` = 12 , `supplier` = 6 , `count` = '2.00' , `result` = '1' , `maker` = 0 , `ratif` = 0 , `remark` = '' , `status` = 4 , `create_time` = '2024-04-10' , `update_time` = '2024-11-13 15:32:09.394428' [ RunTime:0.000241s ] [2024-11-13T15:32:09+08:00][sql] SELECT * FROM `tpl` WHERE `status` = 1 AND `tpl_sort` = '14' AND `sort` = 1046 [ RunTime:0.000235s ] [2024-11-13T15:32:09+08:00][sql] SELECT * FROM `tpl_info` WHERE `tpl` = 30 ORDER BY `order` ASC [ RunTime:0.000302s ] [2024-11-13T15:32:09+08:00][sql] SELECT * FROM `iqc_note` WHERE `iqc` = 12 AND `tpl_raw_info` = 166 LIMIT 1 [ RunTime:0.000229s ] [2024-11-13T15:32:09+08:00][sql] INSERT INTO `iqc_note` SET `iqc` = 12 , `tpl_raw_info` = 166 , `qc_count` = '2' , `count` = '2' , `note` = '1,1,' , `ng` = '0' , `create_time` = '2024-04-10' , `remark` = '' , `update_time` = '2024-11-13 15:32:09.396383' [ RunTime:0.000201s ] [2024-11-13T15:32:09+08:00][sql] SELECT * FROM `iqc_note` WHERE `iqc` = 12 AND `tpl_raw_info` = 167 LIMIT 1 [ RunTime:0.000207s ] [2024-11-13T15:32:09+08:00][sql] INSERT INTO `iqc_note` SET `iqc` = 12 , `tpl_raw_info` = 167 , `qc_count` = '2' , `count` = '2' , `note` = '1,1,' , `ng` = '0' , `create_time` = '2024-04-10' , `remark` = '' , `update_time` = '2024-11-13 15:32:09.397223' [ RunTime:0.000222s ] [2024-11-13T15:32:09+08:00][sql] SELECT * FROM `iqc_note` WHERE `iqc` = 12 AND `tpl_raw_info` = 168 LIMIT 1 [ RunTime:0.000215s ] [2024-11-13T15:32:09+08:00][sql] INSERT INTO `iqc_note` SET `iqc` = 12 , `tpl_raw_info` = 168 , `qc_count` = '2' , `count` = '2' , `note` = '1,1,' , `ng` = '0' , `create_time` = '2024-04-10' , `remark` = '' , `update_time` = '2024-11-13 15:32:09.398074' [ RunTime:0.000178s ] [2024-11-13T15:32:09+08:00][sql] SELECT * FROM `iqc` WHERE `an` = '13' AND `raw` = 13 LIMIT 1 [ RunTime:0.000221s ] [2024-11-13T15:32:09+08:00][sql] SELECT MAX(`number`) AS think_max FROM `iqc` WHERE `number` LIKE '20240410%' LIMIT 1 [ RunTime:0.000213s ] [2024-11-13T15:32:09+08:00][sql] INSERT INTO `iqc` SET `number` = '20240410013' , `an` = '13' , `raw` = 13 , `supplier` = 2 , `count` = '157.00' , `result` = '1' , `maker` = 0 , `ratif` = 0 , `remark` = '' , `status` = 4 , `create_time` = '2024-04-10' , `update_time` = '2024-11-13 15:32:09.399243' [ RunTime:0.000244s ] [2024-11-13T15:32:09+08:00][sql] SELECT * FROM `tpl` WHERE `status` = 1 AND `tpl_sort` = '14' AND `sort` = 407 [ RunTime:0.000234s ] [2024-11-13T15:32:09+08:00][sql] SELECT * FROM `tpl_info` WHERE `tpl` = 19 ORDER BY `order` ASC [ RunTime:0.000287s ] [2024-11-13T15:32:09+08:00][sql] SELECT * FROM `iqc_note` WHERE `iqc` = 13 AND `tpl_raw_info` = 135 LIMIT 1 [ RunTime:0.000227s ] [2024-11-13T15:32:09+08:00][sql] INSERT INTO `iqc_note` SET `iqc` = 13 , `tpl_raw_info` = 135 , `qc_count` = '32' , `count` = '32' , `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,' , `ng` = '0' , `create_time` = '2024-04-10' , `remark` = '' , `update_time` = '2024-11-13 15:32:09.401231' [ RunTime:0.000192s ] [2024-11-13T15:32:09+08:00][sql] SELECT * FROM `iqc_note` WHERE `iqc` = 13 AND `tpl_raw_info` = 134 LIMIT 1 [ RunTime:0.000204s ] [2024-11-13T15:32:09+08:00][sql] INSERT INTO `iqc_note` SET `iqc` = 13 , `tpl_raw_info` = 134 , `qc_count` = '32' , `count` = '32' , `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,' , `ng` = '0' , `create_time` = '2024-04-10' , `remark` = '' , `update_time` = '2024-11-13 15:32:09.402057' [ RunTime:0.000180s ] [2024-11-13T15:32:09+08:00][sql] SELECT * FROM `iqc` WHERE `an` = '14' AND `raw` = 14 LIMIT 1 [ RunTime:0.000215s ] [2024-11-13T15:32:09+08:00][sql] SELECT MAX(`number`) AS think_max FROM `iqc` WHERE `number` LIKE '20240410%' LIMIT 1 [ RunTime:0.000205s ] [2024-11-13T15:32:09+08:00][sql] INSERT INTO `iqc` SET `number` = '20240410014' , `an` = '14' , `raw` = 14 , `supplier` = 8 , `count` = '8.00' , `result` = '1' , `maker` = 0 , `ratif` = 0 , `remark` = '' , `status` = 4 , `create_time` = '2024-04-10' , `update_time` = '2024-11-13 15:32:09.403224' [ RunTime:0.000241s ] [2024-11-13T15:32:09+08:00][sql] SELECT * FROM `tpl` WHERE `status` = 1 AND `tpl_sort` = '14' AND `sort` = 432 [ RunTime:0.000223s ] [2024-11-13T15:32:09+08:00][sql] SELECT * FROM `tpl_info` WHERE `tpl` = 23 ORDER BY `order` ASC [ RunTime:0.000290s ] [2024-11-13T15:32:09+08:00][sql] SELECT * FROM `iqc_note` WHERE `iqc` = 14 AND `tpl_raw_info` = 146 LIMIT 1 [ RunTime:0.000233s ] [2024-11-13T15:32:09+08:00][sql] INSERT INTO `iqc_note` SET `iqc` = 14 , `tpl_raw_info` = 146 , `qc_count` = '2' , `count` = '2' , `note` = '1,1,' , `ng` = '0' , `create_time` = '2024-04-10' , `remark` = '' , `update_time` = '2024-11-13 15:32:09.405170' [ RunTime:0.000187s ] [2024-11-13T15:32:09+08:00][sql] SELECT * FROM `iqc_note` WHERE `iqc` = 14 AND `tpl_raw_info` = 145 LIMIT 1 [ RunTime:0.000205s ] [2024-11-13T15:32:09+08:00][sql] INSERT INTO `iqc_note` SET `iqc` = 14 , `tpl_raw_info` = 145 , `qc_count` = '2' , `count` = '2' , `note` = '1,1,' , `ng` = '0' , `create_time` = '2024-04-10' , `remark` = '' , `update_time` = '2024-11-13 15:32:09.405987' [ RunTime:0.000217s ] [2024-11-13T15:32:09+08:00][sql] SELECT * FROM `iqc_note` WHERE `iqc` = 14 AND `tpl_raw_info` = 144 LIMIT 1 [ RunTime:0.000214s ] [2024-11-13T15:32:09+08:00][sql] INSERT INTO `iqc_note` SET `iqc` = 14 , `tpl_raw_info` = 144 , `qc_count` = '2' , `count` = '2' , `note` = '1,1,' , `ng` = '0' , `create_time` = '2024-04-10' , `remark` = '' , `update_time` = '2024-11-13 15:32:09.406857' [ RunTime:0.000181s ] [2024-11-13T15:32:09+08:00][sql] SELECT * FROM `iqc` WHERE `an` = '15' AND `raw` = 15 LIMIT 1 [ RunTime:0.000242s ] [2024-11-13T15:32:09+08:00][sql] SELECT MAX(`number`) AS think_max FROM `iqc` WHERE `number` LIKE '20240410%' LIMIT 1 [ RunTime:0.000205s ] [2024-11-13T15:32:09+08:00][sql] INSERT INTO `iqc` SET `number` = '20240410015' , `an` = '15' , `raw` = 15 , `supplier` = 8 , `count` = '4.00' , `result` = '1' , `maker` = 0 , `ratif` = 0 , `remark` = '' , `status` = 4 , `create_time` = '2024-04-10' , `update_time` = '2024-11-13 15:32:09.408035' [ RunTime:0.000980s ] [2024-11-13T15:32:09+08:00][sql] SELECT * FROM `tpl` WHERE `status` = 1 AND `tpl_sort` = '14' AND `sort` = 432 [ RunTime:0.000278s ] [2024-11-13T15:32:09+08:00][sql] SELECT * FROM `tpl_info` WHERE `tpl` = 23 ORDER BY `order` ASC [ RunTime:0.000309s ] [2024-11-13T15:32:09+08:00][sql] SELECT * FROM `iqc_note` WHERE `iqc` = 15 AND `tpl_raw_info` = 146 LIMIT 1 [ RunTime:0.000237s ] [2024-11-13T15:32:09+08:00][sql] INSERT INTO `iqc_note` SET `iqc` = 15 , `tpl_raw_info` = 146 , `qc_count` = '2' , `count` = '2' , `note` = '1,1,' , `ng` = '0' , `create_time` = '2024-04-10' , `remark` = '' , `update_time` = '2024-11-13 15:32:09.410879' [ RunTime:0.000190s ] [2024-11-13T15:32:09+08:00][sql] SELECT * FROM `iqc_note` WHERE `iqc` = 15 AND `tpl_raw_info` = 145 LIMIT 1 [ RunTime:0.000226s ] [2024-11-13T15:32:09+08:00][sql] INSERT INTO `iqc_note` SET `iqc` = 15 , `tpl_raw_info` = 145 , `qc_count` = '2' , `count` = '2' , `note` = '1,1,' , `ng` = '0' , `create_time` = '2024-04-10' , `remark` = '' , `update_time` = '2024-11-13 15:32:09.411745' [ RunTime:0.000178s ] [2024-11-13T15:32:09+08:00][sql] SELECT * FROM `iqc_note` WHERE `iqc` = 15 AND `tpl_raw_info` = 144 LIMIT 1 [ RunTime:0.000227s ] [2024-11-13T15:32:09+08:00][sql] INSERT INTO `iqc_note` SET `iqc` = 15 , `tpl_raw_info` = 144 , `qc_count` = '2' , `count` = '2' , `note` = '1,1,' , `ng` = '0' , `create_time` = '2024-04-10' , `remark` = '' , `update_time` = '2024-11-13 15:32:09.412566' [ RunTime:0.000177s ] [2024-11-13T15:32:09+08:00][sql] SELECT * FROM `iqc` WHERE `an` = '16' AND `raw` = 16 LIMIT 1 [ RunTime:0.000212s ] [2024-11-13T15:32:09+08:00][sql] SELECT MAX(`number`) AS think_max FROM `iqc` WHERE `number` LIKE '20240410%' LIMIT 1 [ RunTime:0.000249s ] [2024-11-13T15:32:09+08:00][sql] INSERT INTO `iqc` SET `number` = '20240410016' , `an` = '16' , `raw` = 16 , `supplier` = 8 , `count` = '4.00' , `result` = '1' , `maker` = 0 , `ratif` = 0 , `remark` = '' , `status` = 4 , `create_time` = '2024-04-10' , `update_time` = '2024-11-13 15:32:09.413745' [ RunTime:0.000217s ] [2024-11-13T15:32:09+08:00][sql] SELECT * FROM `tpl` WHERE `status` = 1 AND `tpl_sort` = '14' AND `sort` = 1045 [ RunTime:0.000246s ] [2024-11-13T15:32:09+08:00][sql] SELECT * FROM `tpl_info` WHERE `tpl` = 29 ORDER BY `order` ASC [ RunTime:0.000308s ] [2024-11-13T15:32:09+08:00][sql] SELECT * FROM `iqc_note` WHERE `iqc` = 16 AND `tpl_raw_info` = 165 LIMIT 1 [ RunTime:0.000233s ] [2024-11-13T15:32:09+08:00][sql] INSERT INTO `iqc_note` SET `iqc` = 16 , `tpl_raw_info` = 165 , `qc_count` = '2' , `count` = '2' , `note` = '1,1,' , `ng` = '0' , `create_time` = '2024-04-10' , `remark` = '' , `update_time` = '2024-11-13 15:32:09.415815' [ RunTime:0.000180s ] [2024-11-13T15:32:09+08:00][sql] SELECT * FROM `iqc_note` WHERE `iqc` = 16 AND `tpl_raw_info` = 164 LIMIT 1 [ RunTime:0.000249s ] [2024-11-13T15:32:09+08:00][sql] INSERT INTO `iqc_note` SET `iqc` = 16 , `tpl_raw_info` = 164 , `qc_count` = '2' , `count` = '2' , `note` = '1,1,' , `ng` = '0' , `create_time` = '2024-04-10' , `remark` = '' , `update_time` = '2024-11-13 15:32:09.416676' [ RunTime:0.000208s ] [2024-11-13T15:32:09+08:00][sql] SELECT * FROM `iqc_note` WHERE `iqc` = 16 AND `tpl_raw_info` = 163 LIMIT 1 [ RunTime:0.000220s ] [2024-11-13T15:32:09+08:00][sql] INSERT INTO `iqc_note` SET `iqc` = 16 , `tpl_raw_info` = 163 , `qc_count` = '2' , `count` = '2' , `note` = '1,1,' , `ng` = '0' , `create_time` = '2024-04-10' , `remark` = '' , `update_time` = '2024-11-13 15:32:09.417516' [ RunTime:0.000178s ] [2024-11-13T15:32:09+08:00][sql] SELECT * FROM `iqc` WHERE `an` = '17' AND `raw` = 17 LIMIT 1 [ RunTime:0.000213s ] [2024-11-13T15:32:09+08:00][sql] SELECT MAX(`number`) AS think_max FROM `iqc` WHERE `number` LIKE '20240410%' LIMIT 1 [ RunTime:0.000223s ] [2024-11-13T15:32:09+08:00][sql] INSERT INTO `iqc` SET `number` = '20240410017' , `an` = '17' , `raw` = 17 , `supplier` = 4 , `count` = '2.00' , `result` = '1' , `maker` = 0 , `ratif` = 0 , `remark` = '' , `status` = 4 , `create_time` = '2024-04-10' , `update_time` = '2024-11-13 15:32:09.418684' [ RunTime:0.000203s ] [2024-11-13T15:32:09+08:00][sql] SELECT * FROM `tpl` WHERE `status` = 1 AND `tpl_sort` = '14' AND `sort` = 1026 [ RunTime:0.000249s ] [2024-11-13T15:32:09+08:00][sql] SELECT * FROM `tpl_info` WHERE `tpl` = 25 ORDER BY `order` ASC [ RunTime:0.000289s ] [2024-11-13T15:32:09+08:00][sql] SELECT * FROM `iqc_note` WHERE `iqc` = 17 AND `tpl_raw_info` = 152 LIMIT 1 [ RunTime:0.000248s ] [2024-11-13T15:32:09+08:00][sql] INSERT INTO `iqc_note` SET `iqc` = 17 , `tpl_raw_info` = 152 , `qc_count` = '2' , `count` = '2' , `note` = '1,1,' , `ng` = '0' , `create_time` = '2024-04-10' , `remark` = '' , `update_time` = '2024-11-13 15:32:09.420701' [ RunTime:0.000185s ] [2024-11-13T15:32:09+08:00][sql] SELECT * FROM `iqc_note` WHERE `iqc` = 17 AND `tpl_raw_info` = 151 LIMIT 1 [ RunTime:0.000228s ] [2024-11-13T15:32:09+08:00][sql] INSERT INTO `iqc_note` SET `iqc` = 17 , `tpl_raw_info` = 151 , `qc_count` = '2' , `count` = '2' , `note` = '1,1,' , `ng` = '0' , `create_time` = '2024-04-10' , `remark` = '' , `update_time` = '2024-11-13 15:32:09.421565' [ RunTime:0.000190s ] [2024-11-13T15:32:09+08:00][sql] SELECT * FROM `iqc_note` WHERE `iqc` = 17 AND `tpl_raw_info` = 150 LIMIT 1 [ RunTime:0.000209s ] [2024-11-13T15:32:09+08:00][sql] INSERT INTO `iqc_note` SET `iqc` = 17 , `tpl_raw_info` = 150 , `qc_count` = '2' , `count` = '2' , `note` = '1,1,' , `ng` = '0' , `create_time` = '2024-04-10' , `remark` = '' , `update_time` = '2024-11-13 15:32:09.422365' [ RunTime:0.000175s ] [2024-11-13T15:32:09+08:00][sql] SELECT * FROM `iqc_note` WHERE `iqc` = 17 AND `tpl_raw_info` = 153 LIMIT 1 [ RunTime:0.000201s ] [2024-11-13T15:32:09+08:00][sql] INSERT INTO `iqc_note` SET `iqc` = 17 , `tpl_raw_info` = 153 , `qc_count` = '2' , `count` = '2' , `note` = '1,1,' , `ng` = '0' , `create_time` = '2024-04-10' , `remark` = '' , `update_time` = '2024-11-13 15:32:09.423161' [ RunTime:0.000181s ] [2024-11-13T15:32:09+08:00][sql] SELECT * FROM `iqc` WHERE `an` = '18' AND `raw` = 18 LIMIT 1 [ RunTime:0.000215s ] [2024-11-13T15:32:09+08:00][sql] SELECT MAX(`number`) AS think_max FROM `iqc` WHERE `number` LIKE '20240410%' LIMIT 1 [ RunTime:0.000207s ] [2024-11-13T15:32:09+08:00][sql] INSERT INTO `iqc` SET `number` = '20240410018' , `an` = '18' , `raw` = 18 , `supplier` = 6 , `count` = '2.00' , `result` = '1' , `maker` = 0 , `ratif` = 0 , `remark` = '' , `status` = 4 , `create_time` = '2024-04-10' , `update_time` = '2024-11-13 15:32:09.424323' [ RunTime:0.000200s ] [2024-11-13T15:32:09+08:00][sql] SELECT * FROM `tpl` WHERE `status` = 1 AND `tpl_sort` = '14' AND `sort` = 1046 [ RunTime:0.000221s ] [2024-11-13T15:32:09+08:00][sql] SELECT * FROM `tpl_info` WHERE `tpl` = 30 ORDER BY `order` ASC [ RunTime:0.000306s ] [2024-11-13T15:32:09+08:00][sql] SELECT * FROM `iqc_note` WHERE `iqc` = 18 AND `tpl_raw_info` = 166 LIMIT 1 [ RunTime:0.000247s ] [2024-11-13T15:32:09+08:00][sql] INSERT INTO `iqc_note` SET `iqc` = 18 , `tpl_raw_info` = 166 , `qc_count` = '2' , `count` = '2' , `note` = '1,1,' , `ng` = '0' , `create_time` = '2024-04-10' , `remark` = '' , `update_time` = '2024-11-13 15:32:09.426289' [ RunTime:0.000196s ] [2024-11-13T15:32:09+08:00][sql] SELECT * FROM `iqc_note` WHERE `iqc` = 18 AND `tpl_raw_info` = 167 LIMIT 1 [ RunTime:0.000203s ] [2024-11-13T15:32:09+08:00][sql] INSERT INTO `iqc_note` SET `iqc` = 18 , `tpl_raw_info` = 167 , `qc_count` = '2' , `count` = '2' , `note` = '1,1,' , `ng` = '0' , `create_time` = '2024-04-10' , `remark` = '' , `update_time` = '2024-11-13 15:32:09.427117' [ RunTime:0.000174s ] [2024-11-13T15:32:09+08:00][sql] SELECT * FROM `iqc_note` WHERE `iqc` = 18 AND `tpl_raw_info` = 168 LIMIT 1 [ RunTime:0.000212s ] [2024-11-13T15:32:09+08:00][sql] INSERT INTO `iqc_note` SET `iqc` = 18 , `tpl_raw_info` = 168 , `qc_count` = '2' , `count` = '2' , `note` = '1,1,' , `ng` = '0' , `create_time` = '2024-04-10' , `remark` = '' , `update_time` = '2024-11-13 15:32:09.427935' [ RunTime:0.000180s ] [2024-11-13T15:32:09+08:00][sql] SELECT * FROM `iqc` WHERE `an` = '19' AND `raw` = 19 LIMIT 1 [ RunTime:0.000226s ] [2024-11-13T15:32:09+08:00][sql] SELECT MAX(`number`) AS think_max FROM `iqc` WHERE `number` LIKE '20240410%' LIMIT 1 [ RunTime:0.000198s ] [2024-11-13T15:32:09+08:00][sql] INSERT INTO `iqc` SET `number` = '20240410019' , `an` = '19' , `raw` = 19 , `supplier` = 8 , `count` = '10.00' , `result` = '1' , `maker` = 0 , `ratif` = 0 , `remark` = '' , `status` = 4 , `create_time` = '2024-04-10' , `update_time` = '2024-11-13 15:32:09.429100' [ RunTime:0.000195s ] [2024-11-13T15:32:09+08:00][sql] SELECT * FROM `tpl` WHERE `status` = 1 AND `tpl_sort` = '14' AND `sort` = 432 [ RunTime:0.000236s ] [2024-11-13T15:32:09+08:00][sql] SELECT * FROM `tpl_info` WHERE `tpl` = 23 ORDER BY `order` ASC [ RunTime:0.000288s ] [2024-11-13T15:32:09+08:00][sql] SELECT * FROM `iqc_note` WHERE `iqc` = 19 AND `tpl_raw_info` = 146 LIMIT 1 [ RunTime:0.000227s ] [2024-11-13T15:32:09+08:00][sql] INSERT INTO `iqc_note` SET `iqc` = 19 , `tpl_raw_info` = 146 , `qc_count` = '3' , `count` = '3' , `note` = '1,1,1,' , `ng` = '0' , `create_time` = '2024-04-10' , `remark` = '' , `update_time` = '2024-11-13 15:32:09.431079' [ RunTime:0.000295s ] [2024-11-13T15:32:09+08:00][sql] SELECT * FROM `iqc_note` WHERE `iqc` = 19 AND `tpl_raw_info` = 145 LIMIT 1 [ RunTime:0.000215s ] [2024-11-13T15:32:09+08:00][sql] INSERT INTO `iqc_note` SET `iqc` = 19 , `tpl_raw_info` = 145 , `qc_count` = '3' , `count` = '3' , `note` = '1,1,1,' , `ng` = '0' , `create_time` = '2024-04-10' , `remark` = '' , `update_time` = '2024-11-13 15:32:09.432103' [ RunTime:0.000179s ] [2024-11-13T15:32:09+08:00][sql] SELECT * FROM `iqc_note` WHERE `iqc` = 19 AND `tpl_raw_info` = 144 LIMIT 1 [ RunTime:0.000216s ] [2024-11-13T15:32:09+08:00][sql] INSERT INTO `iqc_note` SET `iqc` = 19 , `tpl_raw_info` = 144 , `qc_count` = '3' , `count` = '3' , `note` = '1,1,1,' , `ng` = '0' , `create_time` = '2024-04-10' , `remark` = '' , `update_time` = '2024-11-13 15:32:09.432903' [ RunTime:0.000186s ] [2024-11-13T15:32:09+08:00][sql] SELECT * FROM `iqc` WHERE `an` = '20' AND `raw` = 20 LIMIT 1 [ RunTime:0.000242s ] [2024-11-13T15:32:09+08:00][sql] SELECT MAX(`number`) AS think_max FROM `iqc` WHERE `number` LIKE '20240410%' LIMIT 1 [ RunTime:0.000203s ] [2024-11-13T15:32:09+08:00][sql] INSERT INTO `iqc` SET `number` = '20240410020' , `an` = '20' , `raw` = 20 , `supplier` = 8 , `count` = '2.00' , `result` = '1' , `maker` = 0 , `ratif` = 0 , `remark` = '' , `status` = 4 , `create_time` = '2024-04-10' , `update_time` = '2024-11-13 15:32:09.434041' [ RunTime:0.000197s ] [2024-11-13T15:32:09+08:00][sql] SELECT * FROM `tpl` WHERE `status` = 1 AND `tpl_sort` = '14' AND `sort` = 427 [ RunTime:0.000233s ] [2024-11-13T15:32:09+08:00][sql] SELECT * FROM `tpl_info` WHERE `tpl` = 22 ORDER BY `order` ASC [ RunTime:0.000291s ] [2024-11-13T15:32:09+08:00][sql] SELECT * FROM `iqc_note` WHERE `iqc` = 20 AND `tpl_raw_info` = 143 LIMIT 1 [ RunTime:0.000230s ] [2024-11-13T15:32:09+08:00][sql] INSERT INTO `iqc_note` SET `iqc` = 20 , `tpl_raw_info` = 143 , `qc_count` = '2' , `count` = '2' , `note` = '1,1,' , `ng` = '0' , `create_time` = '2024-04-10' , `remark` = '' , `update_time` = '2024-11-13 15:32:09.435941' [ RunTime:0.000180s ] [2024-11-13T15:32:09+08:00][sql] SELECT * FROM `iqc_note` WHERE `iqc` = 20 AND `tpl_raw_info` = 142 LIMIT 1 [ RunTime:0.000234s ] [2024-11-13T15:32:09+08:00][sql] INSERT INTO `iqc_note` SET `iqc` = 20 , `tpl_raw_info` = 142 , `qc_count` = '2' , `count` = '2' , `note` = '1,1,' , `ng` = '0' , `create_time` = '2024-04-10' , `remark` = '' , `update_time` = '2024-11-13 15:32:09.436753' [ RunTime:0.000192s ] [2024-11-13T15:32:09+08:00][sql] SELECT * FROM `iqc_note` WHERE `iqc` = 20 AND `tpl_raw_info` = 141 LIMIT 1 [ RunTime:0.000257s ] [2024-11-13T15:32:09+08:00][sql] INSERT INTO `iqc_note` SET `iqc` = 20 , `tpl_raw_info` = 141 , `qc_count` = '2' , `count` = '2' , `note` = '1,1,' , `ng` = '0' , `create_time` = '2024-04-10' , `remark` = '' , `update_time` = '2024-11-13 15:32:09.437585' [ RunTime:0.000189s ] [2024-11-13T15:32:09+08:00][sql] SELECT * FROM `iqc` WHERE `an` = '21' AND `raw` = 21 LIMIT 1 [ RunTime:0.000212s ] [2024-11-13T15:32:09+08:00][sql] SELECT MAX(`number`) AS think_max FROM `iqc` WHERE `number` LIKE '20240410%' LIMIT 1 [ RunTime:0.000223s ] [2024-11-13T15:32:09+08:00][sql] INSERT INTO `iqc` SET `number` = '20240410021' , `an` = '21' , `raw` = 21 , `supplier` = 4 , `count` = '2.00' , `result` = '1' , `maker` = 0 , `ratif` = 0 , `remark` = '' , `status` = 4 , `create_time` = '2024-04-10' , `update_time` = '2024-11-13 15:32:09.438722' [ RunTime:0.000220s ] [2024-11-13T15:32:09+08:00][sql] SELECT * FROM `tpl` WHERE `status` = 1 AND `tpl_sort` = '14' AND `sort` = 1047 [ RunTime:0.000252s ] [2024-11-13T15:32:09+08:00][sql] SELECT * FROM `tpl_info` WHERE `tpl` = 31 ORDER BY `order` ASC [ RunTime:0.000321s ] [2024-11-13T15:32:09+08:00][sql] SELECT * FROM `iqc_note` WHERE `iqc` = 21 AND `tpl_raw_info` = 172 LIMIT 1 [ RunTime:0.000240s ] [2024-11-13T15:32:09+08:00][sql] INSERT INTO `iqc_note` SET `iqc` = 21 , `tpl_raw_info` = 172 , `qc_count` = '2' , `count` = '2' , `note` = '1,1,' , `ng` = '0' , `create_time` = '2024-04-10' , `remark` = '' , `update_time` = '2024-11-13 15:32:09.440685' [ RunTime:0.000192s ] [2024-11-13T15:32:09+08:00][sql] SELECT * FROM `iqc_note` WHERE `iqc` = 21 AND `tpl_raw_info` = 171 LIMIT 1 [ RunTime:0.000244s ] [2024-11-13T15:32:09+08:00][sql] INSERT INTO `iqc_note` SET `iqc` = 21 , `tpl_raw_info` = 171 , `qc_count` = '2' , `count` = '2' , `note` = '1,1,' , `ng` = '0' , `create_time` = '2024-04-10' , `remark` = '' , `update_time` = '2024-11-13 15:32:09.441522' [ RunTime:0.000182s ] [2024-11-13T15:32:09+08:00][sql] SELECT * FROM `iqc_note` WHERE `iqc` = 21 AND `tpl_raw_info` = 170 LIMIT 1 [ RunTime:0.000206s ] [2024-11-13T15:32:09+08:00][sql] INSERT INTO `iqc_note` SET `iqc` = 21 , `tpl_raw_info` = 170 , `qc_count` = '2' , `count` = '2' , `note` = '1,1,' , `ng` = '0' , `create_time` = '2024-04-10' , `remark` = '' , `update_time` = '2024-11-13 15:32:09.442309' [ RunTime:0.000187s ] [2024-11-13T15:32:09+08:00][sql] SELECT * FROM `iqc_note` WHERE `iqc` = 21 AND `tpl_raw_info` = 169 LIMIT 1 [ RunTime:0.000215s ] [2024-11-13T15:32:09+08:00][sql] INSERT INTO `iqc_note` SET `iqc` = 21 , `tpl_raw_info` = 169 , `qc_count` = '2' , `count` = '2' , `note` = '1,1,' , `ng` = '0' , `create_time` = '2024-04-10' , `remark` = '' , `update_time` = '2024-11-13 15:32:09.443100' [ RunTime:0.000190s ] [2024-11-13T15:32:09+08:00][sql] SELECT * FROM `iqc` WHERE `an` = '22' AND `raw` = 22 LIMIT 1 [ RunTime:0.000237s ] [2024-11-13T15:32:09+08:00][sql] SELECT MAX(`number`) AS think_max FROM `iqc` WHERE `number` LIKE '20240410%' LIMIT 1 [ RunTime:0.000208s ] [2024-11-13T15:32:09+08:00][sql] INSERT INTO `iqc` SET `number` = '20240410022' , `an` = '22' , `raw` = 22 , `supplier` = 6 , `count` = '2.00' , `result` = '1' , `maker` = 0 , `ratif` = 0 , `remark` = '' , `status` = 4 , `create_time` = '2024-04-10' , `update_time` = '2024-11-13 15:32:09.444256' [ RunTime:0.000226s ] [2024-11-13T15:32:09+08:00][sql] SELECT * FROM `tpl` WHERE `status` = 1 AND `tpl_sort` = '14' AND `sort` = 1046 [ RunTime:0.000249s ] [2024-11-13T15:32:09+08:00][sql] SELECT * FROM `tpl_info` WHERE `tpl` = 30 ORDER BY `order` ASC [ RunTime:0.000314s ] [2024-11-13T15:32:09+08:00][sql] SELECT * FROM `iqc_note` WHERE `iqc` = 22 AND `tpl_raw_info` = 166 LIMIT 1 [ RunTime:0.000231s ] [2024-11-13T15:32:09+08:00][sql] INSERT INTO `iqc_note` SET `iqc` = 22 , `tpl_raw_info` = 166 , `qc_count` = '2' , `count` = '2' , `note` = '1,1,' , `ng` = '0' , `create_time` = '2024-04-10' , `remark` = '' , `update_time` = '2024-11-13 15:32:09.446200' [ RunTime:0.000222s ] [2024-11-13T15:32:09+08:00][sql] SELECT * FROM `iqc_note` WHERE `iqc` = 22 AND `tpl_raw_info` = 167 LIMIT 1 [ RunTime:0.000244s ] [2024-11-13T15:32:09+08:00][sql] INSERT INTO `iqc_note` SET `iqc` = 22 , `tpl_raw_info` = 167 , `qc_count` = '2' , `count` = '2' , `note` = '1,1,' , `ng` = '0' , `create_time` = '2024-04-10' , `remark` = '' , `update_time` = '2024-11-13 15:32:09.447075' [ RunTime:0.000200s ] [2024-11-13T15:32:09+08:00][sql] SELECT * FROM `iqc_note` WHERE `iqc` = 22 AND `tpl_raw_info` = 168 LIMIT 1 [ RunTime:0.000222s ] [2024-11-13T15:32:09+08:00][sql] INSERT INTO `iqc_note` SET `iqc` = 22 , `tpl_raw_info` = 168 , `qc_count` = '2' , `count` = '2' , `note` = '1,1,' , `ng` = '0' , `create_time` = '2024-04-10' , `remark` = '' , `update_time` = '2024-11-13 15:32:09.447913' [ RunTime:0.000171s ] [2024-11-13T15:32:09+08:00][sql] CONNECT:[ UseTime:0.015166s ] mysql:host=127.0.0.1;port=3306;dbname=hbzahxkj;charset=utf8 [2024-11-13T15:32:09+08:00][sql] SHOW FULL COLUMNS FROM `set` [ RunTime:0.000703s ] [2024-11-13T15:32:09+08:00][sql] UPDATE `set` SET `value` = 'hbzahxkj' WHERE `field` = 'database' [ RunTime:0.000353s ] [2024-11-13T15:32:09+08:00][sql] UPDATE `set` SET `value` = '河北中安禾信科技有限公司' WHERE `field` = 'title' [ RunTime:0.000205s ] [2024-11-13T15:32:09+08:00][sql] UPDATE `set` SET `value` = '42,43,389' WHERE `field` = 'product_sort' [ RunTime:0.000184s ] [2024-11-13T15:32:09+08:00][sql] SHOW FULL COLUMNS FROM `an` [ RunTime:0.000980s ] [2024-11-13T15:32:09+08:00][sql] SELECT * FROM `an` WHERE `id` IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22) [ RunTime:0.000434s ] [2024-11-13T15:32:09+08:00][sql] SHOW FULL COLUMNS FROM `iqc` [ RunTime:0.001143s ] [2024-11-13T15:32:09+08:00][sql] SELECT * FROM `iqc` WHERE `an` IN ('1','2','3','4','5','6','7','8','9','10','11','12','13','14','15','16','17','18','19','20','21','22') [ RunTime:0.000438s ] [2024-11-13T15:32:09+08:00][sql] SHOW FULL COLUMNS FROM `in` [ RunTime:0.001435s ] [2024-11-13T15:32:09+08:00][sql] SELECT * FROM `in` WHERE `raw` = 1 AND `an` = 1 LIMIT 1 [ RunTime:0.000247s ] [2024-11-13T15:32:09+08:00][sql] SELECT MAX(`number`) AS think_max FROM `in` WHERE `number` LIKE '20240409%' LIMIT 1 [ RunTime:0.000180s ] [2024-11-13T15:32:09+08:00][sql] INSERT INTO `in` SET `number` = '20240409001' , `raw` = 1 , `count` = 12.00 , `supplier` = 8 , `an` = 1 , `po` = 1 , `iqc` = 1 , `create_time` = '2024-04-09 06:31:25' , `update_time` = '2024-11-13 15:32:09.571494' [ RunTime:0.000283s ] [2024-11-13T15:32:09+08:00][sql] SELECT * FROM `in` WHERE `raw` = 2 AND `an` = 2 LIMIT 1 [ RunTime:0.000244s ] [2024-11-13T15:32:09+08:00][sql] SELECT MAX(`number`) AS think_max FROM `in` WHERE `number` LIKE '20240409%' LIMIT 1 [ RunTime:0.000193s ] [2024-11-13T15:32:09+08:00][sql] INSERT INTO `in` SET `number` = '20240409002' , `raw` = 2 , `count` = 2.00 , `supplier` = 1 , `an` = 2 , `po` = 2 , `iqc` = 2 , `create_time` = '2024-04-09 07:10:52' , `update_time` = '2024-11-13 15:32:09.572813' [ RunTime:0.000201s ] [2024-11-13T15:32:09+08:00][sql] SELECT * FROM `in` WHERE `raw` = 3 AND `an` = 3 LIMIT 1 [ RunTime:0.000225s ] [2024-11-13T15:32:09+08:00][sql] SELECT MAX(`number`) AS think_max FROM `in` WHERE `number` LIKE '20240409%' LIMIT 1 [ RunTime:0.000230s ] [2024-11-13T15:32:09+08:00][sql] INSERT INTO `in` SET `number` = '20240409003' , `raw` = 3 , `count` = 8.00 , `supplier` = 5 , `an` = 3 , `po` = 3 , `iqc` = 3 , `create_time` = '2024-04-09 07:49:21' , `update_time` = '2024-11-13 15:32:09.574049' [ RunTime:0.000195s ] [2024-11-13T15:32:09+08:00][sql] SELECT * FROM `in` WHERE `raw` = 4 AND `an` = 4 LIMIT 1 [ RunTime:0.000197s ] [2024-11-13T15:32:09+08:00][sql] SELECT MAX(`number`) AS think_max FROM `in` WHERE `number` LIKE '20240409%' LIMIT 1 [ RunTime:0.000183s ] [2024-11-13T15:32:09+08:00][sql] INSERT INTO `in` SET `number` = '20240409004' , `raw` = 4 , `count` = 18.00 , `supplier` = 8 , `an` = 4 , `po` = 4 , `iqc` = 4 , `create_time` = '2024-04-09 12:36:24' , `update_time` = '2024-11-13 15:32:09.575176' [ RunTime:0.000214s ] [2024-11-13T15:32:09+08:00][sql] SELECT * FROM `in` WHERE `raw` = 5 AND `an` = 5 LIMIT 1 [ RunTime:0.000204s ] [2024-11-13T15:32:09+08:00][sql] SELECT MAX(`number`) AS think_max FROM `in` WHERE `number` LIKE '20240409%' LIMIT 1 [ RunTime:0.000178s ] [2024-11-13T15:32:09+08:00][sql] INSERT INTO `in` SET `number` = '20240409005' , `raw` = 5 , `count` = 4.00 , `supplier` = 8 , `an` = 5 , `po` = 5 , `iqc` = 5 , `create_time` = '2024-04-09 05:08:19' , `update_time` = '2024-11-13 15:32:09.576370' [ RunTime:0.000186s ] [2024-11-13T15:32:09+08:00][sql] SELECT * FROM `in` WHERE `raw` = 6 AND `an` = 6 LIMIT 1 [ RunTime:0.000203s ] [2024-11-13T15:32:09+08:00][sql] SELECT MAX(`number`) AS think_max FROM `in` WHERE `number` LIKE '20240409%' LIMIT 1 [ RunTime:0.000192s ] [2024-11-13T15:32:09+08:00][sql] INSERT INTO `in` SET `number` = '20240409006' , `raw` = 6 , `count` = 29.00 , `supplier` = 8 , `an` = 6 , `po` = 6 , `iqc` = 6 , `create_time` = '2024-04-09 12:10:25' , `update_time` = '2024-11-13 15:32:09.577501' [ RunTime:0.000202s ] [2024-11-13T15:32:09+08:00][sql] SELECT * FROM `in` WHERE `raw` = 7 AND `an` = 7 LIMIT 1 [ RunTime:0.000203s ] [2024-11-13T15:32:09+08:00][sql] SELECT MAX(`number`) AS think_max FROM `in` WHERE `number` LIKE '20240409%' LIMIT 1 [ RunTime:0.000197s ] [2024-11-13T15:32:09+08:00][sql] INSERT INTO `in` SET `number` = '20240409007' , `raw` = 7 , `count` = 4.00 , `supplier` = 5 , `an` = 7 , `po` = 7 , `iqc` = 7 , `create_time` = '2024-04-09 09:42:51' , `update_time` = '2024-11-13 15:32:09.578636' [ RunTime:0.000189s ] [2024-11-13T15:32:09+08:00][sql] SELECT * FROM `in` WHERE `raw` = 8 AND `an` = 8 LIMIT 1 [ RunTime:0.000207s ] [2024-11-13T15:32:09+08:00][sql] SELECT MAX(`number`) AS think_max FROM `in` WHERE `number` LIKE '20240409%' LIMIT 1 [ RunTime:0.000187s ] [2024-11-13T15:32:09+08:00][sql] INSERT INTO `in` SET `number` = '20240409008' , `raw` = 8 , `count` = 6.00 , `supplier` = 8 , `an` = 8 , `po` = 8 , `iqc` = 8 , `create_time` = '2024-04-09 12:27:41' , `update_time` = '2024-11-13 15:32:09.579803' [ RunTime:0.000237s ] [2024-11-13T15:32:09+08:00][sql] SELECT * FROM `in` WHERE `raw` = 9 AND `an` = 9 LIMIT 1 [ RunTime:0.000212s ] [2024-11-13T15:32:09+08:00][sql] SELECT MAX(`number`) AS think_max FROM `in` WHERE `number` LIKE '20240409%' LIMIT 1 [ RunTime:0.000184s ] [2024-11-13T15:32:09+08:00][sql] INSERT INTO `in` SET `number` = '20240409009' , `raw` = 9 , `count` = 2.00 , `supplier` = 7 , `an` = 9 , `po` = 9 , `iqc` = 9 , `create_time` = '2024-04-09 05:40:21' , `update_time` = '2024-11-13 15:32:09.581019' [ RunTime:0.000226s ] [2024-11-13T15:32:09+08:00][sql] SELECT * FROM `in` WHERE `raw` = 10 AND `an` = 10 LIMIT 1 [ RunTime:0.000238s ] [2024-11-13T15:32:09+08:00][sql] SELECT MAX(`number`) AS think_max FROM `in` WHERE `number` LIKE '20240409%' LIMIT 1 [ RunTime:0.000180s ] [2024-11-13T15:32:09+08:00][sql] INSERT INTO `in` SET `number` = '20240409010' , `raw` = 10 , `count` = 2.00 , `supplier` = 7 , `an` = 10 , `po` = 10 , `iqc` = 10 , `create_time` = '2024-04-09 06:54:53' , `update_time` = '2024-11-13 15:32:09.582214' [ RunTime:0.000197s ] [2024-11-13T15:32:09+08:00][sql] SELECT * FROM `in` WHERE `raw` = 11 AND `an` = 11 LIMIT 1 [ RunTime:0.000200s ] [2024-11-13T15:32:09+08:00][sql] SELECT MAX(`number`) AS think_max FROM `in` WHERE `number` LIKE '20240409%' LIMIT 1 [ RunTime:0.000201s ] [2024-11-13T15:32:09+08:00][sql] INSERT INTO `in` SET `number` = '20240409011' , `raw` = 11 , `count` = 1018.00 , `supplier` = 3 , `an` = 11 , `po` = 11 , `iqc` = 11 , `create_time` = '2024-04-09 10:11:32' , `update_time` = '2024-11-13 15:32:09.583343' [ RunTime:0.000187s ] [2024-11-13T15:32:09+08:00][sql] SELECT * FROM `in` WHERE `raw` = 12 AND `an` = 12 LIMIT 1 [ RunTime:0.000199s ] [2024-11-13T15:32:09+08:00][sql] SELECT MAX(`number`) AS think_max FROM `in` WHERE `number` LIKE '20240409%' LIMIT 1 [ RunTime:0.000187s ] [2024-11-13T15:32:09+08:00][sql] INSERT INTO `in` SET `number` = '20240409012' , `raw` = 12 , `count` = 2.00 , `supplier` = 6 , `an` = 12 , `po` = 12 , `iqc` = 12 , `create_time` = '2024-04-09 06:44:25' , `update_time` = '2024-11-13 15:32:09.584474' [ RunTime:0.000186s ] [2024-11-13T15:32:09+08:00][sql] SELECT * FROM `in` WHERE `raw` = 13 AND `an` = 13 LIMIT 1 [ RunTime:0.000213s ] [2024-11-13T15:32:09+08:00][sql] SELECT MAX(`number`) AS think_max FROM `in` WHERE `number` LIKE '20240409%' LIMIT 1 [ RunTime:0.000194s ] [2024-11-13T15:32:09+08:00][sql] INSERT INTO `in` SET `number` = '20240409013' , `raw` = 13 , `count` = 157.00 , `supplier` = 2 , `an` = 13 , `po` = 13 , `iqc` = 13 , `create_time` = '2024-04-09 11:05:54' , `update_time` = '2024-11-13 15:32:09.585649' [ RunTime:0.000916s ] [2024-11-13T15:32:09+08:00][sql] SELECT * FROM `in` WHERE `raw` = 14 AND `an` = 14 LIMIT 1 [ RunTime:0.000249s ] [2024-11-13T15:32:09+08:00][sql] SELECT MAX(`number`) AS think_max FROM `in` WHERE `number` LIKE '20240409%' LIMIT 1 [ RunTime:0.000225s ] [2024-11-13T15:32:09+08:00][sql] INSERT INTO `in` SET `number` = '20240409014' , `raw` = 14 , `count` = 8.00 , `supplier` = 8 , `an` = 14 , `po` = 14 , `iqc` = 14 , `create_time` = '2024-04-09 11:19:07' , `update_time` = '2024-11-13 15:32:09.587639' [ RunTime:0.000181s ] [2024-11-13T15:32:09+08:00][sql] SELECT * FROM `in` WHERE `raw` = 15 AND `an` = 15 LIMIT 1 [ RunTime:0.000215s ] [2024-11-13T15:32:09+08:00][sql] SELECT MAX(`number`) AS think_max FROM `in` WHERE `number` LIKE '20240409%' LIMIT 1 [ RunTime:0.000234s ] [2024-11-13T15:32:09+08:00][sql] INSERT INTO `in` SET `number` = '20240409015' , `raw` = 15 , `count` = 4.00 , `supplier` = 8 , `an` = 15 , `po` = 15 , `iqc` = 15 , `create_time` = '2024-04-09 07:57:40' , `update_time` = '2024-11-13 15:32:09.588821' [ RunTime:0.000226s ] [2024-11-13T15:32:09+08:00][sql] SELECT * FROM `in` WHERE `raw` = 16 AND `an` = 16 LIMIT 1 [ RunTime:0.000249s ] [2024-11-13T15:32:09+08:00][sql] SELECT MAX(`number`) AS think_max FROM `in` WHERE `number` LIKE '20240409%' LIMIT 1 [ RunTime:0.000192s ] [2024-11-13T15:32:09+08:00][sql] INSERT INTO `in` SET `number` = '20240409016' , `raw` = 16 , `count` = 4.00 , `supplier` = 8 , `an` = 16 , `po` = 16 , `iqc` = 16 , `create_time` = '2024-04-09 08:19:52' , `update_time` = '2024-11-13 15:32:09.589985' [ RunTime:0.000173s ] [2024-11-13T15:32:09+08:00][sql] SELECT * FROM `in` WHERE `raw` = 17 AND `an` = 17 LIMIT 1 [ RunTime:0.000236s ] [2024-11-13T15:32:09+08:00][sql] SELECT MAX(`number`) AS think_max FROM `in` WHERE `number` LIKE '20240409%' LIMIT 1 [ RunTime:0.000218s ] [2024-11-13T15:32:09+08:00][sql] INSERT INTO `in` SET `number` = '20240409017' , `raw` = 17 , `count` = 2.00 , `supplier` = 4 , `an` = 17 , `po` = 17 , `iqc` = 17 , `create_time` = '2024-04-09 05:10:04' , `update_time` = '2024-11-13 15:32:09.591156' [ RunTime:0.000181s ] [2024-11-13T15:32:09+08:00][sql] SELECT * FROM `in` WHERE `raw` = 18 AND `an` = 18 LIMIT 1 [ RunTime:0.000203s ] [2024-11-13T15:32:09+08:00][sql] SELECT MAX(`number`) AS think_max FROM `in` WHERE `number` LIKE '20240409%' LIMIT 1 [ RunTime:0.000220s ] [2024-11-13T15:32:09+08:00][sql] INSERT INTO `in` SET `number` = '20240409018' , `raw` = 18 , `count` = 2.00 , `supplier` = 6 , `an` = 18 , `po` = 18 , `iqc` = 18 , `create_time` = '2024-04-09 05:08:36' , `update_time` = '2024-11-13 15:32:09.592283' [ RunTime:0.000220s ] [2024-11-13T15:32:09+08:00][sql] SELECT * FROM `in` WHERE `raw` = 19 AND `an` = 19 LIMIT 1 [ RunTime:0.000237s ] [2024-11-13T15:32:09+08:00][sql] SELECT MAX(`number`) AS think_max FROM `in` WHERE `number` LIKE '20240409%' LIMIT 1 [ RunTime:0.000190s ] [2024-11-13T15:32:09+08:00][sql] INSERT INTO `in` SET `number` = '20240409019' , `raw` = 19 , `count` = 10.00 , `supplier` = 8 , `an` = 19 , `po` = 19 , `iqc` = 19 , `create_time` = '2024-04-09 05:14:52' , `update_time` = '2024-11-13 15:32:09.593422' [ RunTime:0.000170s ] [2024-11-13T15:32:09+08:00][sql] SELECT * FROM `in` WHERE `raw` = 20 AND `an` = 20 LIMIT 1 [ RunTime:0.000206s ] [2024-11-13T15:32:09+08:00][sql] SELECT MAX(`number`) AS think_max FROM `in` WHERE `number` LIKE '20240409%' LIMIT 1 [ RunTime:0.000243s ] [2024-11-13T15:32:09+08:00][sql] INSERT INTO `in` SET `number` = '20240409020' , `raw` = 20 , `count` = 2.00 , `supplier` = 8 , `an` = 20 , `po` = 20 , `iqc` = 20 , `create_time` = '2024-04-09 11:05:43' , `update_time` = '2024-11-13 15:32:09.594608' [ RunTime:0.000170s ] [2024-11-13T15:32:09+08:00][sql] SELECT * FROM `in` WHERE `raw` = 21 AND `an` = 21 LIMIT 1 [ RunTime:0.000202s ] [2024-11-13T15:32:09+08:00][sql] SELECT MAX(`number`) AS think_max FROM `in` WHERE `number` LIKE '20240409%' LIMIT 1 [ RunTime:0.000215s ] [2024-11-13T15:32:09+08:00][sql] INSERT INTO `in` SET `number` = '20240409021' , `raw` = 21 , `count` = 2.00 , `supplier` = 4 , `an` = 21 , `po` = 21 , `iqc` = 21 , `create_time` = '2024-04-09 11:27:02' , `update_time` = '2024-11-13 15:32:09.595718' [ RunTime:0.000189s ] [2024-11-13T15:32:09+08:00][sql] SELECT * FROM `in` WHERE `raw` = 22 AND `an` = 22 LIMIT 1 [ RunTime:0.000246s ] [2024-11-13T15:32:09+08:00][sql] SELECT MAX(`number`) AS think_max FROM `in` WHERE `number` LIKE '20240409%' LIMIT 1 [ RunTime:0.000193s ] [2024-11-13T15:32:09+08:00][sql] INSERT INTO `in` SET `number` = '20240409022' , `raw` = 22 , `count` = 2.00 , `supplier` = 6 , `an` = 22 , `po` = 22 , `iqc` = 22 , `create_time` = '2024-04-09 01:54:59' , `update_time` = '2024-11-13 15:32:09.596835' [ RunTime:0.000167s ] [2024-11-13T15:32:09+08:00][sql] CONNECT:[ UseTime:0.011688s ] mysql:host=127.0.0.1;port=3306;dbname=hbzahxkj;charset=utf8 [2024-11-13T15:32:09+08:00][sql] SHOW FULL COLUMNS FROM `set` [ RunTime:0.000713s ] [2024-11-13T15:32:09+08:00][sql] UPDATE `set` SET `value` = 'hbzahxkj' WHERE `field` = 'database' [ RunTime:0.000323s ] [2024-11-13T15:32:09+08:00][sql] UPDATE `set` SET `value` = '河北中安禾信科技有限公司' WHERE `field` = 'title' [ RunTime:0.000205s ] [2024-11-13T15:32:09+08:00][sql] UPDATE `set` SET `value` = '42,43,389' WHERE `field` = 'product_sort' [ RunTime:0.000174s ] [2024-11-13T15:32:09+08:00][sql] SHOW FULL COLUMNS FROM `pp` [ RunTime:0.000979s ] [2024-11-13T15:32:09+08:00][sql] SELECT * FROM `pp` WHERE `id` IN (1,2,3) [ RunTime:0.000317s ] [2024-11-13T15:32:09+08:00][sql] SHOW FULL COLUMNS FROM `in` [ RunTime:0.001013s ] [2024-11-13T15:32:09+08:00][sql] SELECT MIN(`create_time`) AS think_min FROM `in` WHERE `id` = in LIMIT 1 [ RunTime:0.000224s ] [2024-11-13T15:32:09+08:00][sql] SHOW FULL COLUMNS FROM `mo` [ RunTime:0.001261s ] [2024-11-13T15:32:09+08:00][sql] SELECT * FROM `mo` WHERE `product` = 1 AND `pp` = '1' LIMIT 1 [ RunTime:0.000240s ] [2024-11-13T15:32:09+08:00][sql] SELECT MAX(`number`) AS think_max FROM `mo` WHERE `number` LIKE '20240408%' LIMIT 1 [ RunTime:0.000193s ] [2024-11-13T15:32:09+08:00][sql] INSERT INTO `mo` SET `number` = '20240408001' , `status` = 11 , `product` = 1 , `count` = 2 , `plan_count` = 2 , `maker` = 0 , `ratif` = 0 , `pmr_step` = 0 , `cpp_step` = 0 , `mo_step` = 0 , `remark` = '' , `create_time` = '2024-04-08 00:00:00' , `so` = '1' , `pp` = '1' , `cpp_status` = 2 , `pqc_status` = 2 , `fqc_status` = 2 , `oqc_status` = 2 , `end_count` = 2 , `update_time` = '2024-11-13 15:32:09.738901' [ RunTime:0.000302s ] [2024-11-13T15:32:09+08:00][sql] SELECT * FROM `mo` WHERE `product` = 2 AND `pp` = '2' LIMIT 1 [ RunTime:0.000234s ] [2024-11-13T15:32:09+08:00][sql] SELECT MAX(`number`) AS think_max FROM `mo` WHERE `number` LIKE '20240408%' LIMIT 1 [ RunTime:0.000230s ] [2024-11-13T15:32:09+08:00][sql] INSERT INTO `mo` SET `number` = '20240408002' , `status` = 11 , `product` = 2 , `count` = 2 , `plan_count` = 2 , `maker` = 0 , `ratif` = 0 , `pmr_step` = 0 , `cpp_step` = 0 , `mo_step` = 0 , `remark` = '' , `create_time` = '2024-04-08 00:00:00' , `so` = '1' , `pp` = '2' , `cpp_status` = 2 , `pqc_status` = 2 , `fqc_status` = 2 , `oqc_status` = 2 , `end_count` = 2 , `update_time` = '2024-11-13 15:32:09.740333' [ RunTime:0.000276s ] [2024-11-13T15:32:09+08:00][sql] SELECT * FROM `mo` WHERE `product` = 3 AND `pp` = '3' LIMIT 1 [ RunTime:0.000261s ] [2024-11-13T15:32:09+08:00][sql] SELECT MAX(`number`) AS think_max FROM `mo` WHERE `number` LIKE '20240408%' LIMIT 1 [ RunTime:0.000195s ] [2024-11-13T15:32:09+08:00][sql] INSERT INTO `mo` SET `number` = '20240408003' , `status` = 11 , `product` = 3 , `count` = 2 , `plan_count` = 2 , `maker` = 0 , `ratif` = 0 , `pmr_step` = 0 , `cpp_step` = 0 , `mo_step` = 0 , `remark` = '' , `create_time` = '2024-04-08 00:00:00' , `so` = '1' , `pp` = '3' , `cpp_status` = 2 , `pqc_status` = 2 , `fqc_status` = 2 , `oqc_status` = 2 , `end_count` = 2 , `update_time` = '2024-11-13 15:32:09.741659' [ RunTime:0.000229s ] [2024-11-13T15:32:09+08:00][sql] CONNECT:[ UseTime:0.004912s ] mysql:host=127.0.0.1;port=3306;dbname=hbzahxkj;charset=utf8 [2024-11-13T15:32:09+08:00][sql] SHOW FULL COLUMNS FROM `set` [ RunTime:0.000708s ] [2024-11-13T15:32:09+08:00][sql] UPDATE `set` SET `value` = 'hbzahxkj' WHERE `field` = 'database' [ RunTime:0.000298s ] [2024-11-13T15:32:09+08:00][sql] UPDATE `set` SET `value` = '河北中安禾信科技有限公司' WHERE `field` = 'title' [ RunTime:0.000228s ] [2024-11-13T15:32:09+08:00][sql] UPDATE `set` SET `value` = '42,43,389' WHERE `field` = 'product_sort' [ RunTime:0.000178s ] [2024-11-13T15:32:09+08:00][sql] SHOW FULL COLUMNS FROM `mo` [ RunTime:0.001098s ] [2024-11-13T15:32:09+08:00][sql] SELECT * FROM `mo` WHERE `id` IN (1,2,3) [ RunTime:0.000412s ] [2024-11-13T15:32:09+08:00][sql] SHOW FULL COLUMNS FROM `sp` [ RunTime:0.001423s ] [2024-11-13T15:32:09+08:00][sql] SELECT * FROM `sp` WHERE `mo` = 1 AND `product` = 1 LIMIT 1 [ RunTime:0.000262s ] [2024-11-13T15:32:09+08:00][sql] INSERT INTO `sp` SET `mo` = 1 , `product` = 1 , `status` = 2 , `ratif` = 0 , `put_man` = 0 , `create_time` = '2024-04-08 00:00:00' , `update_time` = '2024-11-13 15:32:09.846374' [ RunTime:0.000267s ] [2024-11-13T15:32:09+08:00][sql] SHOW FULL COLUMNS FROM `bom` [ RunTime:0.000889s ] [2024-11-13T15:32:09+08:00][sql] SELECT * FROM `bom` WHERE `product` = 1 LIMIT 1 [ RunTime:0.000313s ] [2024-11-13T15:32:09+08:00][sql] SHOW FULL COLUMNS FROM `bom_info` [ RunTime:0.000897s ] [2024-11-13T15:32:09+08:00][sql] SELECT * FROM `bom_info` WHERE `bom` = 1 [ RunTime:0.000311s ] [2024-11-13T15:32:09+08:00][sql] SHOW FULL COLUMNS FROM `out` [ RunTime:0.001326s ] [2024-11-13T15:32:09+08:00][sql] SELECT * FROM `out` WHERE `sp` = 1 AND `raw` = 1 LIMIT 1 [ RunTime:0.000250s ] [2024-11-13T15:32:09+08:00][sql] INSERT INTO `out` SET `sp` = 1 , `raw` = 1 , `supplier` = NULL , `count` = '4' , `out_count` = '4' , `put_man` = 0 , `unit` = '' , `status` = 1 , `create_time` = '2024-04-08 00:00:00' , `out_time` = NULL , `update_time` = '2024-11-13 15:32:09.853703' [ RunTime:0.000307s ] [2024-11-13T15:32:09+08:00][sql] SELECT * FROM `out` WHERE `sp` = 1 AND `raw` = 2 LIMIT 1 [ RunTime:0.000250s ] [2024-11-13T15:32:09+08:00][sql] INSERT INTO `out` SET `sp` = 1 , `raw` = 2 , `supplier` = NULL , `count` = '2' , `out_count` = '2' , `put_man` = 0 , `unit` = '' , `status` = 1 , `create_time` = '2024-04-08 00:00:00' , `out_time` = NULL , `update_time` = '2024-11-13 15:32:09.854740' [ RunTime:0.000240s ] [2024-11-13T15:32:09+08:00][sql] SELECT * FROM `out` WHERE `sp` = 1 AND `raw` = 3 LIMIT 1 [ RunTime:0.000227s ] [2024-11-13T15:32:09+08:00][sql] INSERT INTO `out` SET `sp` = 1 , `raw` = 3 , `supplier` = NULL , `count` = '4' , `out_count` = '4' , `put_man` = 0 , `unit` = '' , `status` = 1 , `create_time` = '2024-04-08 00:00:00' , `out_time` = NULL , `update_time` = '2024-11-13 15:32:09.855640' [ RunTime:0.000219s ] [2024-11-13T15:32:09+08:00][sql] SELECT * FROM `out` WHERE `sp` = 1 AND `raw` = 4 LIMIT 1 [ RunTime:0.000201s ] [2024-11-13T15:32:09+08:00][sql] INSERT INTO `out` SET `sp` = 1 , `raw` = 4 , `supplier` = NULL , `count` = '16' , `out_count` = '16' , `put_man` = 0 , `unit` = '' , `status` = 1 , `create_time` = '2024-04-08 00:00:00' , `out_time` = NULL , `update_time` = '2024-11-13 15:32:09.856545' [ RunTime:0.000240s ] [2024-11-13T15:32:09+08:00][sql] SELECT * FROM `out` WHERE `sp` = 1 AND `raw` = 5 LIMIT 1 [ RunTime:0.000200s ] [2024-11-13T15:32:09+08:00][sql] INSERT INTO `out` SET `sp` = 1 , `raw` = 5 , `supplier` = NULL , `count` = '2' , `out_count` = '2' , `put_man` = 0 , `unit` = '' , `status` = 1 , `create_time` = '2024-04-08 00:00:00' , `out_time` = NULL , `update_time` = '2024-11-13 15:32:09.857467' [ RunTime:0.000201s ] [2024-11-13T15:32:09+08:00][sql] SELECT * FROM `out` WHERE `sp` = 1 AND `raw` = 6 LIMIT 1 [ RunTime:0.000202s ] [2024-11-13T15:32:09+08:00][sql] INSERT INTO `out` SET `sp` = 1 , `raw` = 6 , `supplier` = NULL , `count` = '12' , `out_count` = '12' , `put_man` = 0 , `unit` = '' , `status` = 1 , `create_time` = '2024-04-08 00:00:00' , `out_time` = NULL , `update_time` = '2024-11-13 15:32:09.858304' [ RunTime:0.000203s ] [2024-11-13T15:32:09+08:00][sql] SELECT * FROM `out` WHERE `sp` = 1 AND `raw` = 7 LIMIT 1 [ RunTime:0.000204s ] [2024-11-13T15:32:09+08:00][sql] INSERT INTO `out` SET `sp` = 1 , `raw` = 7 , `supplier` = NULL , `count` = '2' , `out_count` = '2' , `put_man` = 0 , `unit` = '' , `status` = 1 , `create_time` = '2024-04-08 00:00:00' , `out_time` = NULL , `update_time` = '2024-11-13 15:32:09.859213' [ RunTime:0.000224s ] [2024-11-13T15:32:09+08:00][sql] SELECT * FROM `out` WHERE `sp` = 1 AND `raw` = 8 LIMIT 1 [ RunTime:0.000240s ] [2024-11-13T15:32:09+08:00][sql] INSERT INTO `out` SET `sp` = 1 , `raw` = 8 , `supplier` = NULL , `count` = '2' , `out_count` = '2' , `put_man` = 0 , `unit` = '' , `status` = 1 , `create_time` = '2024-04-08 00:00:00' , `out_time` = NULL , `update_time` = '2024-11-13 15:32:09.860138' [ RunTime:0.000224s ] [2024-11-13T15:32:09+08:00][sql] SELECT * FROM `out` WHERE `sp` = 1 AND `raw` = 9 LIMIT 1 [ RunTime:0.000252s ] [2024-11-13T15:32:09+08:00][sql] INSERT INTO `out` SET `sp` = 1 , `raw` = 9 , `supplier` = NULL , `count` = '2' , `out_count` = '2' , `put_man` = 0 , `unit` = '' , `status` = 1 , `create_time` = '2024-04-08 00:00:00' , `out_time` = NULL , `update_time` = '2024-11-13 15:32:09.861040' [ RunTime:0.000202s ] [2024-11-13T15:32:09+08:00][sql] SELECT * FROM `out` WHERE `sp` = 1 AND `raw` = 10 LIMIT 1 [ RunTime:0.000232s ] [2024-11-13T15:32:09+08:00][sql] INSERT INTO `out` SET `sp` = 1 , `raw` = 10 , `supplier` = NULL , `count` = '2' , `out_count` = '2' , `put_man` = 0 , `unit` = '' , `status` = 1 , `create_time` = '2024-04-08 00:00:00' , `out_time` = NULL , `update_time` = '2024-11-13 15:32:09.861907' [ RunTime:0.000191s ] [2024-11-13T15:32:09+08:00][sql] SELECT * FROM `out` WHERE `sp` = 1 AND `raw` = 11 LIMIT 1 [ RunTime:0.000203s ] [2024-11-13T15:32:09+08:00][sql] INSERT INTO `out` SET `sp` = 1 , `raw` = 11 , `supplier` = NULL , `count` = '300' , `out_count` = '300' , `put_man` = 0 , `unit` = '' , `status` = 1 , `create_time` = '2024-04-08 00:00:00' , `out_time` = NULL , `update_time` = '2024-11-13 15:32:09.862809' [ RunTime:0.000201s ] [2024-11-13T15:32:09+08:00][sql] SELECT * FROM `out` WHERE `sp` = 1 AND `raw` = 12 LIMIT 1 [ RunTime:0.000214s ] [2024-11-13T15:32:09+08:00][sql] INSERT INTO `out` SET `sp` = 1 , `raw` = 12 , `supplier` = NULL , `count` = '2' , `out_count` = '2' , `put_man` = 0 , `unit` = '' , `status` = 1 , `create_time` = '2024-04-08 00:00:00' , `out_time` = NULL , `update_time` = '2024-11-13 15:32:09.863688' [ RunTime:0.000203s ] [2024-11-13T15:32:09+08:00][sql] SELECT * FROM `out` WHERE `sp` = 1 AND `raw` = 13 LIMIT 1 [ RunTime:0.000214s ] [2024-11-13T15:32:09+08:00][sql] INSERT INTO `out` SET `sp` = 1 , `raw` = 13 , `supplier` = NULL , `count` = '40' , `out_count` = '40' , `put_man` = 0 , `unit` = '' , `status` = 1 , `create_time` = '2024-04-08 00:00:00' , `out_time` = NULL , `update_time` = '2024-11-13 15:32:09.864598' [ RunTime:0.000205s ] [2024-11-13T15:32:09+08:00][sql] SELECT * FROM `sp` WHERE `mo` = 2 AND `product` = 2 LIMIT 1 [ RunTime:0.000203s ] [2024-11-13T15:32:09+08:00][sql] INSERT INTO `sp` SET `mo` = 2 , `product` = 2 , `status` = 2 , `ratif` = 0 , `put_man` = 0 , `create_time` = '2024-04-08 00:00:00' , `update_time` = '2024-11-13 15:32:09.865444' [ RunTime:0.000199s ] [2024-11-13T15:32:09+08:00][sql] SELECT * FROM `bom` WHERE `product` = 2 LIMIT 1 [ RunTime:0.000184s ] [2024-11-13T15:32:09+08:00][sql] SELECT * FROM `bom_info` WHERE `bom` = 2 [ RunTime:0.000220s ] [2024-11-13T15:32:09+08:00][sql] SELECT * FROM `out` WHERE `sp` = 2 AND `raw` = 1 LIMIT 1 [ RunTime:0.000274s ] [2024-11-13T15:32:09+08:00][sql] INSERT INTO `out` SET `sp` = 2 , `raw` = 1 , `supplier` = NULL , `count` = '4' , `out_count` = '4' , `put_man` = 0 , `unit` = '' , `status` = 1 , `create_time` = '2024-04-08 00:00:00' , `out_time` = NULL , `update_time` = '2024-11-13 15:32:09.867406' [ RunTime:0.000252s ] [2024-11-13T15:32:09+08:00][sql] SELECT * FROM `out` WHERE `sp` = 2 AND `raw` = 3 LIMIT 1 [ RunTime:0.000219s ] [2024-11-13T15:32:09+08:00][sql] INSERT INTO `out` SET `sp` = 2 , `raw` = 3 , `supplier` = NULL , `count` = '2' , `out_count` = '2' , `put_man` = 0 , `unit` = '' , `status` = 1 , `create_time` = '2024-04-08 00:00:00' , `out_time` = NULL , `update_time` = '2024-11-13 15:32:09.868322' [ RunTime:0.000267s ] [2024-11-13T15:32:09+08:00][sql] SELECT * FROM `out` WHERE `sp` = 2 AND `raw` = 4 LIMIT 1 [ RunTime:0.000205s ] [2024-11-13T15:32:09+08:00][sql] INSERT INTO `out` SET `sp` = 2 , `raw` = 4 , `supplier` = NULL , `count` = '2' , `out_count` = '2' , `put_man` = 0 , `unit` = '' , `status` = 1 , `create_time` = '2024-04-08 00:00:00' , `out_time` = NULL , `update_time` = '2024-11-13 15:32:09.869290' [ RunTime:0.000886s ] [2024-11-13T15:32:09+08:00][sql] SELECT * FROM `out` WHERE `sp` = 2 AND `raw` = 5 LIMIT 1 [ RunTime:0.000268s ] [2024-11-13T15:32:09+08:00][sql] INSERT INTO `out` SET `sp` = 2 , `raw` = 5 , `supplier` = NULL , `count` = '2' , `out_count` = '2' , `put_man` = 0 , `unit` = '' , `status` = 1 , `create_time` = '2024-04-08 00:00:00' , `out_time` = NULL , `update_time` = '2024-11-13 15:32:09.870923' [ RunTime:0.000312s ] [2024-11-13T15:32:09+08:00][sql] SELECT * FROM `out` WHERE `sp` = 2 AND `raw` = 6 LIMIT 1 [ RunTime:0.000218s ] [2024-11-13T15:32:09+08:00][sql] INSERT INTO `out` SET `sp` = 2 , `raw` = 6 , `supplier` = NULL , `count` = '8' , `out_count` = '8' , `put_man` = 0 , `unit` = '' , `status` = 1 , `create_time` = '2024-04-08 00:00:00' , `out_time` = NULL , `update_time` = '2024-11-13 15:32:09.871896' [ RunTime:0.000223s ] [2024-11-13T15:32:09+08:00][sql] SELECT * FROM `out` WHERE `sp` = 2 AND `raw` = 11 LIMIT 1 [ RunTime:0.000226s ] [2024-11-13T15:32:09+08:00][sql] INSERT INTO `out` SET `sp` = 2 , `raw` = 11 , `supplier` = NULL , `count` = '340' , `out_count` = '340' , `put_man` = 0 , `unit` = '' , `status` = 1 , `create_time` = '2024-04-08 00:00:00' , `out_time` = NULL , `update_time` = '2024-11-13 15:32:09.872766' [ RunTime:0.000179s ] [2024-11-13T15:32:09+08:00][sql] SELECT * FROM `out` WHERE `sp` = 2 AND `raw` = 13 LIMIT 1 [ RunTime:0.000208s ] [2024-11-13T15:32:09+08:00][sql] INSERT INTO `out` SET `sp` = 2 , `raw` = 13 , `supplier` = NULL , `count` = '78' , `out_count` = '78' , `put_man` = 0 , `unit` = '' , `status` = 1 , `create_time` = '2024-04-08 00:00:00' , `out_time` = NULL , `update_time` = '2024-11-13 15:32:09.873644' [ RunTime:0.000184s ] [2024-11-13T15:32:09+08:00][sql] SELECT * FROM `out` WHERE `sp` = 2 AND `raw` = 14 LIMIT 1 [ RunTime:0.000202s ] [2024-11-13T15:32:09+08:00][sql] INSERT INTO `out` SET `sp` = 2 , `raw` = 14 , `supplier` = NULL , `count` = '8' , `out_count` = '8' , `put_man` = 0 , `unit` = '' , `status` = 1 , `create_time` = '2024-04-08 00:00:00' , `out_time` = NULL , `update_time` = '2024-11-13 15:32:09.874504' [ RunTime:0.000185s ] [2024-11-13T15:32:09+08:00][sql] SELECT * FROM `out` WHERE `sp` = 2 AND `raw` = 15 LIMIT 1 [ RunTime:0.000235s ] [2024-11-13T15:32:09+08:00][sql] INSERT INTO `out` SET `sp` = 2 , `raw` = 15 , `supplier` = NULL , `count` = '4' , `out_count` = '4' , `put_man` = 0 , `unit` = '' , `status` = 1 , `create_time` = '2024-04-08 00:00:00' , `out_time` = NULL , `update_time` = '2024-11-13 15:32:09.875371' [ RunTime:0.000194s ] [2024-11-13T15:32:09+08:00][sql] SELECT * FROM `out` WHERE `sp` = 2 AND `raw` = 16 LIMIT 1 [ RunTime:0.000209s ] [2024-11-13T15:32:09+08:00][sql] INSERT INTO `out` SET `sp` = 2 , `raw` = 16 , `supplier` = NULL , `count` = '4' , `out_count` = '4' , `put_man` = 0 , `unit` = '' , `status` = 1 , `create_time` = '2024-04-08 00:00:00' , `out_time` = NULL , `update_time` = '2024-11-13 15:32:09.876201' [ RunTime:0.000227s ] [2024-11-13T15:32:09+08:00][sql] SELECT * FROM `out` WHERE `sp` = 2 AND `raw` = 17 LIMIT 1 [ RunTime:0.000196s ] [2024-11-13T15:32:09+08:00][sql] INSERT INTO `out` SET `sp` = 2 , `raw` = 17 , `supplier` = NULL , `count` = '2' , `out_count` = '2' , `put_man` = 0 , `unit` = '' , `status` = 1 , `create_time` = '2024-04-08 00:00:00' , `out_time` = NULL , `update_time` = '2024-11-13 15:32:09.877082' [ RunTime:0.000180s ] [2024-11-13T15:32:09+08:00][sql] SELECT * FROM `out` WHERE `sp` = 2 AND `raw` = 18 LIMIT 1 [ RunTime:0.000202s ] [2024-11-13T15:32:09+08:00][sql] INSERT INTO `out` SET `sp` = 2 , `raw` = 18 , `supplier` = NULL , `count` = '2' , `out_count` = '2' , `put_man` = 0 , `unit` = '' , `status` = 1 , `create_time` = '2024-04-08 00:00:00' , `out_time` = NULL , `update_time` = '2024-11-13 15:32:09.877935' [ RunTime:0.000185s ] [2024-11-13T15:32:09+08:00][sql] SELECT * FROM `sp` WHERE `mo` = 3 AND `product` = 3 LIMIT 1 [ RunTime:0.000205s ] [2024-11-13T15:32:09+08:00][sql] INSERT INTO `sp` SET `mo` = 3 , `product` = 3 , `status` = 2 , `ratif` = 0 , `put_man` = 0 , `create_time` = '2024-04-08 00:00:00' , `update_time` = '2024-11-13 15:32:09.878790' [ RunTime:0.000207s ] [2024-11-13T15:32:09+08:00][sql] SELECT * FROM `bom` WHERE `product` = 3 LIMIT 1 [ RunTime:0.000201s ] [2024-11-13T15:32:09+08:00][sql] SELECT * FROM `bom_info` WHERE `bom` = 3 [ RunTime:0.000205s ] [2024-11-13T15:32:09+08:00][sql] SELECT * FROM `out` WHERE `sp` = 3 AND `raw` = 1 LIMIT 1 [ RunTime:0.000285s ] [2024-11-13T15:32:09+08:00][sql] INSERT INTO `out` SET `sp` = 3 , `raw` = 1 , `supplier` = NULL , `count` = '4' , `out_count` = '4' , `put_man` = 0 , `unit` = '' , `status` = 1 , `create_time` = '2024-04-08 00:00:00' , `out_time` = NULL , `update_time` = '2024-11-13 15:32:09.880699' [ RunTime:0.000230s ] [2024-11-13T15:32:09+08:00][sql] SELECT * FROM `out` WHERE `sp` = 3 AND `raw` = 3 LIMIT 1 [ RunTime:0.000231s ] [2024-11-13T15:32:09+08:00][sql] INSERT INTO `out` SET `sp` = 3 , `raw` = 3 , `supplier` = NULL , `count` = '2' , `out_count` = '2' , `put_man` = 0 , `unit` = '' , `status` = 1 , `create_time` = '2024-04-08 00:00:00' , `out_time` = NULL , `update_time` = '2024-11-13 15:32:09.881594' [ RunTime:0.000201s ] [2024-11-13T15:32:09+08:00][sql] SELECT * FROM `out` WHERE `sp` = 3 AND `raw` = 6 LIMIT 1 [ RunTime:0.000198s ] [2024-11-13T15:32:09+08:00][sql] INSERT INTO `out` SET `sp` = 3 , `raw` = 6 , `supplier` = NULL , `count` = '8' , `out_count` = '8' , `put_man` = 0 , `unit` = '' , `status` = 1 , `create_time` = '2024-04-08 00:00:00' , `out_time` = NULL , `update_time` = '2024-11-13 15:32:09.882466' [ RunTime:0.000513s ] [2024-11-13T15:32:09+08:00][sql] SELECT * FROM `out` WHERE `sp` = 3 AND `raw` = 7 LIMIT 1 [ RunTime:0.000222s ] [2024-11-13T15:32:09+08:00][sql] INSERT INTO `out` SET `sp` = 3 , `raw` = 7 , `supplier` = NULL , `count` = '2' , `out_count` = '2' , `put_man` = 0 , `unit` = '' , `status` = 1 , `create_time` = '2024-04-08 00:00:00' , `out_time` = NULL , `update_time` = '2024-11-13 15:32:09.883642' [ RunTime:0.000219s ] [2024-11-13T15:32:09+08:00][sql] SELECT * FROM `out` WHERE `sp` = 3 AND `raw` = 8 LIMIT 1 [ RunTime:0.000277s ] [2024-11-13T15:32:09+08:00][sql] INSERT INTO `out` SET `sp` = 3 , `raw` = 8 , `supplier` = NULL , `count` = '4' , `out_count` = '4' , `put_man` = 0 , `unit` = '' , `status` = 1 , `create_time` = '2024-04-08 00:00:00' , `out_time` = NULL , `update_time` = '2024-11-13 15:32:09.884584' [ RunTime:0.000601s ] [2024-11-13T15:32:09+08:00][sql] SELECT * FROM `out` WHERE `sp` = 3 AND `raw` = 11 LIMIT 1 [ RunTime:0.000215s ] [2024-11-13T15:32:09+08:00][sql] INSERT INTO `out` SET `sp` = 3 , `raw` = 11 , `supplier` = NULL , `count` = '330' , `out_count` = '330' , `put_man` = 0 , `unit` = '' , `status` = 1 , `create_time` = '2024-04-08 00:00:00' , `out_time` = NULL , `update_time` = '2024-11-13 15:32:09.885917' [ RunTime:0.000185s ] [2024-11-13T15:32:09+08:00][sql] SELECT * FROM `out` WHERE `sp` = 3 AND `raw` = 13 LIMIT 1 [ RunTime:0.000217s ] [2024-11-13T15:32:09+08:00][sql] INSERT INTO `out` SET `sp` = 3 , `raw` = 13 , `supplier` = NULL , `count` = '32' , `out_count` = '32' , `put_man` = 0 , `unit` = '' , `status` = 1 , `create_time` = '2024-04-08 00:00:00' , `out_time` = NULL , `update_time` = '2024-11-13 15:32:09.886797' [ RunTime:0.000345s ] [2024-11-13T15:32:09+08:00][sql] SELECT * FROM `out` WHERE `sp` = 3 AND `raw` = 19 LIMIT 1 [ RunTime:0.000204s ] [2024-11-13T15:32:09+08:00][sql] INSERT INTO `out` SET `sp` = 3 , `raw` = 19 , `supplier` = NULL , `count` = '10' , `out_count` = '10' , `put_man` = 0 , `unit` = '' , `status` = 1 , `create_time` = '2024-04-08 00:00:00' , `out_time` = NULL , `update_time` = '2024-11-13 15:32:09.887883' [ RunTime:0.000185s ] [2024-11-13T15:32:09+08:00][sql] SELECT * FROM `out` WHERE `sp` = 3 AND `raw` = 20 LIMIT 1 [ RunTime:0.000221s ] [2024-11-13T15:32:09+08:00][sql] INSERT INTO `out` SET `sp` = 3 , `raw` = 20 , `supplier` = NULL , `count` = '2' , `out_count` = '2' , `put_man` = 0 , `unit` = '' , `status` = 1 , `create_time` = '2024-04-08 00:00:00' , `out_time` = NULL , `update_time` = '2024-11-13 15:32:09.888754' [ RunTime:0.000182s ] [2024-11-13T15:32:09+08:00][sql] SELECT * FROM `out` WHERE `sp` = 3 AND `raw` = 21 LIMIT 1 [ RunTime:0.000259s ] [2024-11-13T15:32:09+08:00][sql] INSERT INTO `out` SET `sp` = 3 , `raw` = 21 , `supplier` = NULL , `count` = '2' , `out_count` = '2' , `put_man` = 0 , `unit` = '' , `status` = 1 , `create_time` = '2024-04-08 00:00:00' , `out_time` = NULL , `update_time` = '2024-11-13 15:32:09.889651' [ RunTime:0.000188s ] [2024-11-13T15:32:09+08:00][sql] SELECT * FROM `out` WHERE `sp` = 3 AND `raw` = 22 LIMIT 1 [ RunTime:0.000243s ] [2024-11-13T15:32:09+08:00][sql] INSERT INTO `out` SET `sp` = 3 , `raw` = 22 , `supplier` = NULL , `count` = '2' , `out_count` = '2' , `put_man` = 0 , `unit` = '' , `status` = 1 , `create_time` = '2024-04-08 00:00:00' , `out_time` = NULL , `update_time` = '2024-11-13 15:32:09.890556' [ RunTime:0.000224s ] [2024-11-13T15:32:10+08:00][sql] CONNECT:[ UseTime:0.009996s ] mysql:host=127.0.0.1;port=3306;dbname=hbzahxkj;charset=utf8 [2024-11-13T15:32:10+08:00][sql] SHOW FULL COLUMNS FROM `set` [ RunTime:0.000672s ] [2024-11-13T15:32:10+08:00][sql] UPDATE `set` SET `value` = 'hbzahxkj' WHERE `field` = 'database' [ RunTime:0.000269s ] [2024-11-13T15:32:10+08:00][sql] UPDATE `set` SET `value` = '河北中安禾信科技有限公司' WHERE `field` = 'title' [ RunTime:0.000210s ] [2024-11-13T15:32:10+08:00][sql] UPDATE `set` SET `value` = '42,43,389' WHERE `field` = 'product_sort' [ RunTime:0.000230s ] [2024-11-13T15:32:10+08:00][sql] CONNECT:[ UseTime:0.000840s ] mysql:host=127.0.0.1;port=3306;dbname=hbzahxkj;charset=utf8 [2024-11-13T15:32:10+08:00][sql] SHOW FULL COLUMNS FROM `set` [ RunTime:0.000698s ] [2024-11-13T15:32:10+08:00][sql] UPDATE `set` SET `value` = 'hbzahxkj' WHERE `field` = 'database' [ RunTime:0.000259s ] [2024-11-13T15:32:10+08:00][sql] UPDATE `set` SET `value` = '河北中安禾信科技有限公司' WHERE `field` = 'title' [ RunTime:0.000199s ] [2024-11-13T15:32:10+08:00][sql] UPDATE `set` SET `value` = '42,43,389' WHERE `field` = 'product_sort' [ RunTime:0.000189s ] [2024-11-13T15:32:10+08:00][sql] SHOW FULL COLUMNS FROM `mo` [ RunTime:0.001066s ] [2024-11-13T15:32:10+08:00][sql] SELECT * FROM `mo` WHERE `id` IN (1,2,3) [ RunTime:0.000323s ] [2024-11-13T15:32:10+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.000559s ] [2024-11-13T15:32:10+08:00][sql] SELECT * FROM `product` WHERE `id` IN (1,2,3) [ RunTime:0.000313s ] [2024-11-13T15:32:10+08:00][sql] SHOW FULL COLUMNS FROM `tpl` [ RunTime:0.000942s ] [2024-11-13T15:32:10+08:00][sql] SELECT * FROM `tpl` WHERE `status` = 1 AND `tpl_sort` = '12' AND `sort` = 43 [ RunTime:0.000325s ] [2024-11-13T15:32:10+08:00][sql] SHOW FULL COLUMNS FROM `tpl_info` [ RunTime:0.000918s ] [2024-11-13T15:32:10+08:00][sql] SELECT * FROM `tpl_info` WHERE `tpl` = 11 ORDER BY `order` ASC [ RunTime:0.000328s ] [2024-11-13T15:32:10+08:00][sql] SHOW FULL COLUMNS FROM `pmr` [ RunTime:0.001213s ] [2024-11-13T15:32:10+08:00][sql] SELECT * FROM `pmr` WHERE `mo` = 1 AND `product` = 1 AND `tpl_info` = 118 LIMIT 1 [ RunTime:0.000233s ] [2024-11-13T15:32:10+08:00][sql] INSERT INTO `pmr` SET `mo` = 1 , `product` = 1 , `tpl_info` = 118 , `count` = 2 , `ng` = 0 , `create_time` = '2024-04-08' , `test` = '电器元件安装' , `req` = '走线槽、导轨及元件是否与图纸一致;' , `step` = '' , `maker` = 0 , `update_time` = '2024-11-13 15:32:10.135375' [ RunTime:0.000280s ] [2024-11-13T15:32:10+08:00][sql] SELECT * FROM `pmr` WHERE `mo` = 1 AND `product` = 1 AND `tpl_info` = 117 LIMIT 1 [ RunTime:0.000210s ] [2024-11-13T15:32:10+08:00][sql] INSERT INTO `pmr` SET `mo` = 1 , `product` = 1 , `tpl_info` = 117 , `count` = 2 , `ng` = 0 , `create_time` = '2024-04-08' , `test` = '电器元件安装' , `req` = '材料规格、型号、数量是否与图纸一致;' , `step` = '' , `maker` = 0 , `update_time` = '2024-11-13 15:32:10.136402' [ RunTime:0.000215s ] [2024-11-13T15:32:10+08:00][sql] SELECT * FROM `tpl` WHERE `status` = 1 AND `tpl_sort` = '12' AND `sort` = 42 [ RunTime:0.000246s ] [2024-11-13T15:32:10+08:00][sql] SELECT * FROM `tpl_info` WHERE `tpl` = 10 ORDER BY `order` ASC [ RunTime:0.000304s ] [2024-11-13T15:32:10+08:00][sql] SELECT * FROM `pmr` WHERE `mo` = 2 AND `product` = 2 AND `tpl_info` = 115 LIMIT 1 [ RunTime:0.000230s ] [2024-11-13T15:32:10+08:00][sql] INSERT INTO `pmr` SET `mo` = 2 , `product` = 2 , `tpl_info` = 115 , `count` = 2 , `ng` = 0 , `create_time` = '2024-04-08' , `test` = '电器元件安装' , `req` = '走线槽、导轨及元件是否与图纸一致;' , `step` = '' , `maker` = 0 , `update_time` = '2024-11-13 15:32:10.138337' [ RunTime:0.000216s ] [2024-11-13T15:32:10+08:00][sql] SELECT * FROM `pmr` WHERE `mo` = 2 AND `product` = 2 AND `tpl_info` = 116 LIMIT 1 [ RunTime:0.000216s ] [2024-11-13T15:32:10+08:00][sql] INSERT INTO `pmr` SET `mo` = 2 , `product` = 2 , `tpl_info` = 116 , `count` = 2 , `ng` = 0 , `create_time` = '2024-04-08' , `test` = '电器元件安装' , `req` = '材料规格、型号、数量是否与图纸一致;' , `step` = '' , `maker` = 0 , `update_time` = '2024-11-13 15:32:10.139197' [ RunTime:0.000211s ] [2024-11-13T15:32:10+08:00][sql] SELECT * FROM `tpl` WHERE `status` = 1 AND `tpl_sort` = '12' AND `sort` = 389 [ RunTime:0.000225s ] [2024-11-13T15:32:10+08:00][sql] SELECT * FROM `tpl_info` WHERE `tpl` = 12 ORDER BY `order` ASC [ RunTime:0.000263s ] [2024-11-13T15:32:10+08:00][sql] SELECT * FROM `pmr` WHERE `mo` = 3 AND `product` = 3 AND `tpl_info` = 120 LIMIT 1 [ RunTime:0.000216s ] [2024-11-13T15:32:10+08:00][sql] INSERT INTO `pmr` SET `mo` = 3 , `product` = 3 , `tpl_info` = 120 , `count` = 2 , `ng` = 0 , `create_time` = '2024-04-08' , `test` = '电器元件安装' , `req` = '走线槽、导轨及元件是否与图纸一致;' , `step` = '' , `maker` = 0 , `update_time` = '2024-11-13 15:32:10.141034' [ RunTime:0.000191s ] [2024-11-13T15:32:10+08:00][sql] SELECT * FROM `pmr` WHERE `mo` = 3 AND `product` = 3 AND `tpl_info` = 119 LIMIT 1 [ RunTime:0.000207s ] [2024-11-13T15:32:10+08:00][sql] INSERT INTO `pmr` SET `mo` = 3 , `product` = 3 , `tpl_info` = 119 , `count` = 2 , `ng` = 0 , `create_time` = '2024-04-08' , `test` = '电器元件安装' , `req` = '材料规格、型号、数量是否与图纸一致;' , `step` = '' , `maker` = 0 , `update_time` = '2024-11-13 15:32:10.141855' [ RunTime:0.000193s ] [2024-11-13T15:32:10+08:00][sql] CONNECT:[ UseTime:0.001553s ] mysql:host=127.0.0.1;port=3306;dbname=hbzahxkj;charset=utf8 [2024-11-13T15:32:10+08:00][sql] SHOW FULL COLUMNS FROM `set` [ RunTime:0.000692s ] [2024-11-13T15:32:10+08:00][sql] UPDATE `set` SET `value` = 'hbzahxkj' WHERE `field` = 'database' [ RunTime:0.000261s ] [2024-11-13T15:32:10+08:00][sql] UPDATE `set` SET `value` = '河北中安禾信科技有限公司' WHERE `field` = 'title' [ RunTime:0.000240s ] [2024-11-13T15:32:10+08:00][sql] UPDATE `set` SET `value` = '42,43,389' WHERE `field` = 'product_sort' [ RunTime:0.000215s ] [2024-11-13T15:32:10+08:00][sql] SHOW FULL COLUMNS FROM `mo` [ RunTime:0.001001s ] [2024-11-13T15:32:10+08:00][sql] SELECT * FROM `mo` WHERE `id` IN (1,2,3) [ RunTime:0.000317s ] [2024-11-13T15:32:10+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.000946s ] [2024-11-13T15:32:10+08:00][sql] SELECT * FROM `product` WHERE `id` IN (1,2,3) [ RunTime:0.000353s ] [2024-11-13T15:32:10+08:00][sql] SHOW FULL COLUMNS FROM `tpl` [ RunTime:0.000968s ] [2024-11-13T15:32:10+08:00][sql] SELECT * FROM `tpl` WHERE `status` = 1 AND `tpl_sort` = '13' AND `sort` = 43 [ RunTime:0.000345s ] [2024-11-13T15:32:10+08:00][sql] SHOW FULL COLUMNS FROM `tpl_info` [ RunTime:0.000864s ] [2024-11-13T15:32:10+08:00][sql] SELECT * FROM `tpl_info` WHERE `tpl` = 14 ORDER BY `order` ASC [ RunTime:0.000340s ] [2024-11-13T15:32:10+08:00][sql] SHOW FULL COLUMNS FROM `cpp` [ RunTime:0.001249s ] [2024-11-13T15:32:10+08:00][sql] SELECT * FROM `cpp` WHERE `mo` = 1 AND `tpl_info` = 124 LIMIT 1 [ RunTime:0.000218s ] [2024-11-13T15:32:10+08:00][sql] INSERT INTO `cpp` SET `mo` = 1 , `product` = '1' , `tpl_info` = 124 , `note` = '1,1' , `step` = '' , `maker` = 0 , `create_time` = '2024-04-08' , `update_time` = '2024-11-13 15:32:10.260536' [ RunTime:0.000271s ] [2024-11-13T15:32:10+08:00][sql] SELECT * FROM `cpp` WHERE `mo` = 1 AND `tpl_info` = 123 LIMIT 1 [ RunTime:0.000214s ] [2024-11-13T15:32:10+08:00][sql] INSERT INTO `cpp` SET `mo` = 1 , `product` = '1' , `tpl_info` = 123 , `note` = '1,1' , `step` = '' , `maker` = 0 , `create_time` = '2024-04-08' , `update_time` = '2024-11-13 15:32:10.261610' [ RunTime:0.000200s ] [2024-11-13T15:32:10+08:00][sql] SELECT * FROM `tpl` WHERE `status` = 1 AND `tpl_sort` = '13' AND `sort` = 42 [ RunTime:0.000230s ] [2024-11-13T15:32:10+08:00][sql] SELECT * FROM `tpl_info` WHERE `tpl` = 13 ORDER BY `order` ASC [ RunTime:0.000315s ] [2024-11-13T15:32:10+08:00][sql] SELECT * FROM `cpp` WHERE `mo` = 2 AND `tpl_info` = 121 LIMIT 1 [ RunTime:0.000208s ] [2024-11-13T15:32:10+08:00][sql] INSERT INTO `cpp` SET `mo` = 2 , `product` = '2' , `tpl_info` = 121 , `note` = '1,1' , `step` = '' , `maker` = 0 , `create_time` = '2024-04-08' , `update_time` = '2024-11-13 15:32:10.263443' [ RunTime:0.000202s ] [2024-11-13T15:32:10+08:00][sql] SELECT * FROM `cpp` WHERE `mo` = 2 AND `tpl_info` = 122 LIMIT 1 [ RunTime:0.000240s ] [2024-11-13T15:32:10+08:00][sql] INSERT INTO `cpp` SET `mo` = 2 , `product` = '2' , `tpl_info` = 122 , `note` = '1,1' , `step` = '' , `maker` = 0 , `create_time` = '2024-04-08' , `update_time` = '2024-11-13 15:32:10.264281' [ RunTime:0.000250s ] [2024-11-13T15:32:10+08:00][sql] SELECT * FROM `tpl` WHERE `status` = 1 AND `tpl_sort` = '13' AND `sort` = 389 [ RunTime:0.000271s ] [2024-11-13T15:32:10+08:00][sql] SELECT * FROM `tpl_info` WHERE `tpl` = 15 ORDER BY `order` ASC [ RunTime:0.000339s ] [2024-11-13T15:32:10+08:00][sql] SELECT * FROM `cpp` WHERE `mo` = 3 AND `tpl_info` = 126 LIMIT 1 [ RunTime:0.000228s ] [2024-11-13T15:32:10+08:00][sql] INSERT INTO `cpp` SET `mo` = 3 , `product` = '3' , `tpl_info` = 126 , `note` = '1,1' , `step` = '' , `maker` = 0 , `create_time` = '2024-04-08' , `update_time` = '2024-11-13 15:32:10.266232' [ RunTime:0.000252s ] [2024-11-13T15:32:10+08:00][sql] SELECT * FROM `cpp` WHERE `mo` = 3 AND `tpl_info` = 125 LIMIT 1 [ RunTime:0.000195s ] [2024-11-13T15:32:10+08:00][sql] INSERT INTO `cpp` SET `mo` = 3 , `product` = '3' , `tpl_info` = 125 , `note` = '1,1' , `step` = '' , `maker` = 0 , `create_time` = '2024-04-08' , `update_time` = '2024-11-13 15:32:10.267070' [ RunTime:0.000188s ] [2024-11-13T15:32:10+08:00][sql] CONNECT:[ UseTime:0.002647s ] mysql:host=127.0.0.1;port=3306;dbname=hbzahxkj;charset=utf8 [2024-11-13T15:32:10+08:00][sql] SHOW FULL COLUMNS FROM `set` [ RunTime:0.000662s ] [2024-11-13T15:32:10+08:00][sql] UPDATE `set` SET `value` = 'hbzahxkj' WHERE `field` = 'database' [ RunTime:0.000328s ] [2024-11-13T15:32:10+08:00][sql] UPDATE `set` SET `value` = '河北中安禾信科技有限公司' WHERE `field` = 'title' [ RunTime:0.000209s ] [2024-11-13T15:32:10+08:00][sql] UPDATE `set` SET `value` = '42,43,389' WHERE `field` = 'product_sort' [ RunTime:0.000176s ] [2024-11-13T15:32:10+08:00][sql] SHOW FULL COLUMNS FROM `mo` [ RunTime:0.000974s ] [2024-11-13T15:32:10+08:00][sql] SELECT * FROM `mo` WHERE `id` IN (1,2,3) [ RunTime:0.000336s ] [2024-11-13T15:32:10+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.000992s ] [2024-11-13T15:32:10+08:00][sql] SELECT * FROM `product` WHERE `id` IN (1,2,3) [ RunTime:0.000287s ] [2024-11-13T15:32:10+08:00][sql] SELECT `value` FROM `set` WHERE `field` = 'capacity' LIMIT 1 [ RunTime:0.000310s ] [2024-11-13T15:32:10+08:00][sql] SHOW FULL COLUMNS FROM `tpl` [ RunTime:0.000899s ] [2024-11-13T15:32:10+08:00][sql] SELECT * FROM `tpl` WHERE `status` = 1 AND `tpl_sort` = '6' AND `sort` = 43 [ RunTime:0.000306s ] [2024-11-13T15:32:10+08:00][sql] SHOW FULL COLUMNS FROM `tpl_info` [ RunTime:0.000918s ] [2024-11-13T15:32:10+08:00][sql] SELECT * FROM `tpl_info` WHERE `tpl` = 2 ORDER BY `order` ASC [ RunTime:0.000359s ] [2024-11-13T15:32:10+08:00][sql] SHOW FULL COLUMNS FROM `pqc` [ RunTime:0.001504s ] [2024-11-13T15:32:10+08:00][sql] SELECT * FROM `pqc` WHERE `mo` = 1 AND `tpl_info` = 24 LIMIT 1 [ RunTime:0.000283s ] [2024-11-13T15:32:10+08:00][sql] INSERT INTO `pqc` SET `mo` = 1 , `product` = 1 , `tpl_info` = 24 , `qc_count` = 1 , `note` = '1' , `result` = 1 , `maker` = 0 , `status` = 1 , `create_time` = '2024-04-08' , `update_time` = '2024-11-13 15:32:10.421790' [ RunTime:0.000275s ] [2024-11-13T15:32:10+08:00][sql] SELECT * FROM `pqc` WHERE `mo` = 1 AND `tpl_info` = 23 LIMIT 1 [ RunTime:0.000206s ] [2024-11-13T15:32:10+08:00][sql] INSERT INTO `pqc` SET `mo` = 1 , `product` = 1 , `tpl_info` = 23 , `qc_count` = 1 , `note` = '1' , `result` = 1 , `maker` = 0 , `status` = 1 , `create_time` = '2024-04-08' , `update_time` = '2024-11-13 15:32:10.422855' [ RunTime:0.000197s ] [2024-11-13T15:32:10+08:00][sql] SELECT * FROM `pqc` WHERE `mo` = 1 AND `tpl_info` = 22 LIMIT 1 [ RunTime:0.000250s ] [2024-11-13T15:32:10+08:00][sql] INSERT INTO `pqc` SET `mo` = 1 , `product` = 1 , `tpl_info` = 22 , `qc_count` = 1 , `note` = '1' , `result` = 1 , `maker` = 0 , `status` = 1 , `create_time` = '2024-04-08' , `update_time` = '2024-11-13 15:32:10.423746' [ RunTime:0.000214s ] [2024-11-13T15:32:10+08:00][sql] SELECT * FROM `pqc` WHERE `mo` = 1 AND `tpl_info` = 21 LIMIT 1 [ RunTime:0.000202s ] [2024-11-13T15:32:10+08:00][sql] INSERT INTO `pqc` SET `mo` = 1 , `product` = 1 , `tpl_info` = 21 , `qc_count` = 1 , `note` = '1' , `result` = 1 , `maker` = 0 , `status` = 1 , `create_time` = '2024-04-08' , `update_time` = '2024-11-13 15:32:10.424557' [ RunTime:0.000182s ] [2024-11-13T15:32:10+08:00][sql] SELECT * FROM `pqc` WHERE `mo` = 1 AND `tpl_info` = 20 LIMIT 1 [ RunTime:0.000191s ] [2024-11-13T15:32:10+08:00][sql] INSERT INTO `pqc` SET `mo` = 1 , `product` = 1 , `tpl_info` = 20 , `qc_count` = 1 , `note` = '1' , `result` = 1 , `maker` = 0 , `status` = 1 , `create_time` = '2024-04-08' , `update_time` = '2024-11-13 15:32:10.425373' [ RunTime:0.000185s ] [2024-11-13T15:32:10+08:00][sql] SELECT * FROM `pqc` WHERE `mo` = 1 AND `tpl_info` = 19 LIMIT 1 [ RunTime:0.000199s ] [2024-11-13T15:32:10+08:00][sql] INSERT INTO `pqc` SET `mo` = 1 , `product` = 1 , `tpl_info` = 19 , `qc_count` = 1 , `note` = '1' , `result` = 1 , `maker` = 0 , `status` = 1 , `create_time` = '2024-04-08' , `update_time` = '2024-11-13 15:32:10.426247' [ RunTime:0.000199s ] [2024-11-13T15:32:10+08:00][sql] SELECT * FROM `pqc` WHERE `mo` = 1 AND `tpl_info` = 18 LIMIT 1 [ RunTime:0.000202s ] [2024-11-13T15:32:10+08:00][sql] INSERT INTO `pqc` SET `mo` = 1 , `product` = 1 , `tpl_info` = 18 , `qc_count` = 1 , `note` = '1' , `result` = 1 , `maker` = 0 , `status` = 1 , `create_time` = '2024-04-08' , `update_time` = '2024-11-13 15:32:10.427091' [ RunTime:0.000193s ] [2024-11-13T15:32:10+08:00][sql] SELECT * FROM `pqc` WHERE `mo` = 1 AND `tpl_info` = 17 LIMIT 1 [ RunTime:0.000193s ] [2024-11-13T15:32:10+08:00][sql] INSERT INTO `pqc` SET `mo` = 1 , `product` = 1 , `tpl_info` = 17 , `qc_count` = 1 , `note` = '1' , `result` = 1 , `maker` = 0 , `status` = 1 , `create_time` = '2024-04-08' , `update_time` = '2024-11-13 15:32:10.427924' [ RunTime:0.000179s ] [2024-11-13T15:32:10+08:00][sql] SELECT * FROM `pqc` WHERE `mo` = 1 AND `tpl_info` = 16 LIMIT 1 [ RunTime:0.000206s ] [2024-11-13T15:32:10+08:00][sql] INSERT INTO `pqc` SET `mo` = 1 , `product` = 1 , `tpl_info` = 16 , `qc_count` = 1 , `note` = '1' , `result` = 1 , `maker` = 0 , `status` = 1 , `create_time` = '2024-04-08' , `update_time` = '2024-11-13 15:32:10.428736' [ RunTime:0.000183s ] [2024-11-13T15:32:10+08:00][sql] SELECT * FROM `pqc` WHERE `mo` = 1 AND `tpl_info` = 15 LIMIT 1 [ RunTime:0.000243s ] [2024-11-13T15:32:10+08:00][sql] INSERT INTO `pqc` SET `mo` = 1 , `product` = 1 , `tpl_info` = 15 , `qc_count` = 1 , `note` = '1' , `result` = 1 , `maker` = 0 , `status` = 1 , `create_time` = '2024-04-08' , `update_time` = '2024-11-13 15:32:10.429597' [ RunTime:0.000215s ] [2024-11-13T15:32:10+08:00][sql] SELECT * FROM `pqc` WHERE `mo` = 1 AND `tpl_info` = 14 LIMIT 1 [ RunTime:0.000191s ] [2024-11-13T15:32:10+08:00][sql] INSERT INTO `pqc` SET `mo` = 1 , `product` = 1 , `tpl_info` = 14 , `qc_count` = 1 , `note` = '1' , `result` = 1 , `maker` = 0 , `status` = 1 , `create_time` = '2024-04-08' , `update_time` = '2024-11-13 15:32:10.430407' [ RunTime:0.000180s ] [2024-11-13T15:32:10+08:00][sql] SELECT * FROM `pqc` WHERE `mo` = 1 AND `tpl_info` = 13 LIMIT 1 [ RunTime:0.000194s ] [2024-11-13T15:32:10+08:00][sql] INSERT INTO `pqc` SET `mo` = 1 , `product` = 1 , `tpl_info` = 13 , `qc_count` = 1 , `note` = '1' , `result` = 1 , `maker` = 0 , `status` = 1 , `create_time` = '2024-04-08' , `update_time` = '2024-11-13 15:32:10.431284' [ RunTime:0.000195s ] [2024-11-13T15:32:10+08:00][sql] SELECT * FROM `tpl` WHERE `status` = 1 AND `tpl_sort` = '6' AND `sort` = 42 [ RunTime:0.000221s ] [2024-11-13T15:32:10+08:00][sql] SELECT * FROM `tpl_info` WHERE `tpl` = 1 ORDER BY `order` ASC [ RunTime:0.000330s ] [2024-11-13T15:32:10+08:00][sql] SELECT * FROM `pqc` WHERE `mo` = 2 AND `tpl_info` = 8 LIMIT 1 [ RunTime:0.000233s ] [2024-11-13T15:32:10+08:00][sql] INSERT INTO `pqc` SET `mo` = 2 , `product` = 2 , `tpl_info` = 8 , `qc_count` = 1 , `note` = '1' , `result` = 1 , `maker` = 0 , `status` = 1 , `create_time` = '2024-04-08' , `update_time` = '2024-11-13 15:32:10.433812' [ RunTime:0.000194s ] [2024-11-13T15:32:10+08:00][sql] SELECT * FROM `pqc` WHERE `mo` = 2 AND `tpl_info` = 7 LIMIT 1 [ RunTime:0.000217s ] [2024-11-13T15:32:10+08:00][sql] INSERT INTO `pqc` SET `mo` = 2 , `product` = 2 , `tpl_info` = 7 , `qc_count` = 1 , `note` = '1' , `result` = 1 , `maker` = 0 , `status` = 1 , `create_time` = '2024-04-08' , `update_time` = '2024-11-13 15:32:10.434681' [ RunTime:0.000184s ] [2024-11-13T15:32:10+08:00][sql] SELECT * FROM `pqc` WHERE `mo` = 2 AND `tpl_info` = 6 LIMIT 1 [ RunTime:0.000188s ] [2024-11-13T15:32:10+08:00][sql] INSERT INTO `pqc` SET `mo` = 2 , `product` = 2 , `tpl_info` = 6 , `qc_count` = 1 , `note` = '1' , `result` = 1 , `maker` = 0 , `status` = 1 , `create_time` = '2024-04-08' , `update_time` = '2024-11-13 15:32:10.435499' [ RunTime:0.000236s ] [2024-11-13T15:32:10+08:00][sql] SELECT * FROM `pqc` WHERE `mo` = 2 AND `tpl_info` = 5 LIMIT 1 [ RunTime:0.000214s ] [2024-11-13T15:32:10+08:00][sql] INSERT INTO `pqc` SET `mo` = 2 , `product` = 2 , `tpl_info` = 5 , `qc_count` = 1 , `note` = '1' , `result` = 1 , `maker` = 0 , `status` = 1 , `create_time` = '2024-04-08' , `update_time` = '2024-11-13 15:32:10.436346' [ RunTime:0.000180s ] [2024-11-13T15:32:10+08:00][sql] SELECT * FROM `pqc` WHERE `mo` = 2 AND `tpl_info` = 4 LIMIT 1 [ RunTime:0.000194s ] [2024-11-13T15:32:10+08:00][sql] INSERT INTO `pqc` SET `mo` = 2 , `product` = 2 , `tpl_info` = 4 , `qc_count` = 1 , `note` = '1' , `result` = 1 , `maker` = 0 , `status` = 1 , `create_time` = '2024-04-08' , `update_time` = '2024-11-13 15:32:10.437175' [ RunTime:0.000951s ] [2024-11-13T15:32:10+08:00][sql] SELECT * FROM `pqc` WHERE `mo` = 2 AND `tpl_info` = 3 LIMIT 1 [ RunTime:0.000221s ] [2024-11-13T15:32:10+08:00][sql] INSERT INTO `pqc` SET `mo` = 2 , `product` = 2 , `tpl_info` = 3 , `qc_count` = 1 , `note` = '1' , `result` = 1 , `maker` = 0 , `status` = 1 , `create_time` = '2024-04-08' , `update_time` = '2024-11-13 15:32:10.438826' [ RunTime:0.000181s ] [2024-11-13T15:32:10+08:00][sql] SELECT * FROM `pqc` WHERE `mo` = 2 AND `tpl_info` = 2 LIMIT 1 [ RunTime:0.000208s ] [2024-11-13T15:32:10+08:00][sql] INSERT INTO `pqc` SET `mo` = 2 , `product` = 2 , `tpl_info` = 2 , `qc_count` = 1 , `note` = '1' , `result` = 1 , `maker` = 0 , `status` = 1 , `create_time` = '2024-04-08' , `update_time` = '2024-11-13 15:32:10.439702' [ RunTime:0.000166s ] [2024-11-13T15:32:10+08:00][sql] SELECT * FROM `pqc` WHERE `mo` = 2 AND `tpl_info` = 1 LIMIT 1 [ RunTime:0.000196s ] [2024-11-13T15:32:10+08:00][sql] INSERT INTO `pqc` SET `mo` = 2 , `product` = 2 , `tpl_info` = 1 , `qc_count` = 1 , `note` = '1' , `result` = 1 , `maker` = 0 , `status` = 1 , `create_time` = '2024-04-08' , `update_time` = '2024-11-13 15:32:10.440518' [ RunTime:0.000171s ] [2024-11-13T15:32:10+08:00][sql] SELECT * FROM `pqc` WHERE `mo` = 2 AND `tpl_info` = 9 LIMIT 1 [ RunTime:0.000221s ] [2024-11-13T15:32:10+08:00][sql] INSERT INTO `pqc` SET `mo` = 2 , `product` = 2 , `tpl_info` = 9 , `qc_count` = 1 , `note` = '1' , `result` = 1 , `maker` = 0 , `status` = 1 , `create_time` = '2024-04-08' , `update_time` = '2024-11-13 15:32:10.441342' [ RunTime:0.000221s ] [2024-11-13T15:32:10+08:00][sql] SELECT * FROM `pqc` WHERE `mo` = 2 AND `tpl_info` = 10 LIMIT 1 [ RunTime:0.000229s ] [2024-11-13T15:32:10+08:00][sql] INSERT INTO `pqc` SET `mo` = 2 , `product` = 2 , `tpl_info` = 10 , `qc_count` = 1 , `note` = '1' , `result` = 1 , `maker` = 0 , `status` = 1 , `create_time` = '2024-04-08' , `update_time` = '2024-11-13 15:32:10.442207' [ RunTime:0.000177s ] [2024-11-13T15:32:10+08:00][sql] SELECT * FROM `pqc` WHERE `mo` = 2 AND `tpl_info` = 11 LIMIT 1 [ RunTime:0.000194s ] [2024-11-13T15:32:10+08:00][sql] INSERT INTO `pqc` SET `mo` = 2 , `product` = 2 , `tpl_info` = 11 , `qc_count` = 1 , `note` = '1' , `result` = 1 , `maker` = 0 , `status` = 1 , `create_time` = '2024-04-08' , `update_time` = '2024-11-13 15:32:10.443013' [ RunTime:0.000168s ] [2024-11-13T15:32:10+08:00][sql] SELECT * FROM `pqc` WHERE `mo` = 2 AND `tpl_info` = 12 LIMIT 1 [ RunTime:0.000200s ] [2024-11-13T15:32:10+08:00][sql] INSERT INTO `pqc` SET `mo` = 2 , `product` = 2 , `tpl_info` = 12 , `qc_count` = 1 , `note` = '1' , `result` = 1 , `maker` = 0 , `status` = 1 , `create_time` = '2024-04-08' , `update_time` = '2024-11-13 15:32:10.443873' [ RunTime:0.000167s ] [2024-11-13T15:32:10+08:00][sql] SELECT * FROM `tpl` WHERE `status` = 1 AND `tpl_sort` = '6' AND `sort` = 389 [ RunTime:0.000235s ] [2024-11-13T15:32:10+08:00][sql] SELECT * FROM `tpl_info` WHERE `tpl` = 3 ORDER BY `order` ASC [ RunTime:0.000310s ] [2024-11-13T15:32:10+08:00][sql] SELECT * FROM `pqc` WHERE `mo` = 3 AND `tpl_info` = 36 LIMIT 1 [ RunTime:0.000241s ] [2024-11-13T15:32:10+08:00][sql] INSERT INTO `pqc` SET `mo` = 3 , `product` = 3 , `tpl_info` = 36 , `qc_count` = 1 , `note` = '1' , `result` = 1 , `maker` = 0 , `status` = 1 , `create_time` = '2024-04-08' , `update_time` = '2024-11-13 15:32:10.446116' [ RunTime:0.000177s ] [2024-11-13T15:32:10+08:00][sql] SELECT * FROM `pqc` WHERE `mo` = 3 AND `tpl_info` = 35 LIMIT 1 [ RunTime:0.000203s ] [2024-11-13T15:32:10+08:00][sql] INSERT INTO `pqc` SET `mo` = 3 , `product` = 3 , `tpl_info` = 35 , `qc_count` = 1 , `note` = '1' , `result` = 1 , `maker` = 0 , `status` = 1 , `create_time` = '2024-04-08' , `update_time` = '2024-11-13 15:32:10.447009' [ RunTime:0.000167s ] [2024-11-13T15:32:10+08:00][sql] SELECT * FROM `pqc` WHERE `mo` = 3 AND `tpl_info` = 34 LIMIT 1 [ RunTime:0.000201s ] [2024-11-13T15:32:10+08:00][sql] INSERT INTO `pqc` SET `mo` = 3 , `product` = 3 , `tpl_info` = 34 , `qc_count` = 1 , `note` = '1' , `result` = 1 , `maker` = 0 , `status` = 1 , `create_time` = '2024-04-08' , `update_time` = '2024-11-13 15:32:10.447837' [ RunTime:0.000301s ] [2024-11-13T15:32:10+08:00][sql] SELECT * FROM `pqc` WHERE `mo` = 3 AND `tpl_info` = 33 LIMIT 1 [ RunTime:0.000232s ] [2024-11-13T15:32:10+08:00][sql] INSERT INTO `pqc` SET `mo` = 3 , `product` = 3 , `tpl_info` = 33 , `qc_count` = 1 , `note` = '1' , `result` = 1 , `maker` = 0 , `status` = 1 , `create_time` = '2024-04-08' , `update_time` = '2024-11-13 15:32:10.448943' [ RunTime:0.000177s ] [2024-11-13T15:32:10+08:00][sql] SELECT * FROM `pqc` WHERE `mo` = 3 AND `tpl_info` = 32 LIMIT 1 [ RunTime:0.000230s ] [2024-11-13T15:32:10+08:00][sql] INSERT INTO `pqc` SET `mo` = 3 , `product` = 3 , `tpl_info` = 32 , `qc_count` = 1 , `note` = '1' , `result` = 1 , `maker` = 0 , `status` = 1 , `create_time` = '2024-04-08' , `update_time` = '2024-11-13 15:32:10.449799' [ RunTime:0.000218s ] [2024-11-13T15:32:10+08:00][sql] SELECT * FROM `pqc` WHERE `mo` = 3 AND `tpl_info` = 31 LIMIT 1 [ RunTime:0.000258s ] [2024-11-13T15:32:10+08:00][sql] INSERT INTO `pqc` SET `mo` = 3 , `product` = 3 , `tpl_info` = 31 , `qc_count` = 1 , `note` = '1' , `result` = 1 , `maker` = 0 , `status` = 1 , `create_time` = '2024-04-08' , `update_time` = '2024-11-13 15:32:10.450661' [ RunTime:0.000174s ] [2024-11-13T15:32:10+08:00][sql] SELECT * FROM `pqc` WHERE `mo` = 3 AND `tpl_info` = 30 LIMIT 1 [ RunTime:0.000200s ] [2024-11-13T15:32:10+08:00][sql] INSERT INTO `pqc` SET `mo` = 3 , `product` = 3 , `tpl_info` = 30 , `qc_count` = 1 , `note` = '1' , `result` = 1 , `maker` = 0 , `status` = 1 , `create_time` = '2024-04-08' , `update_time` = '2024-11-13 15:32:10.451417' [ RunTime:0.000172s ] [2024-11-13T15:32:10+08:00][sql] SELECT * FROM `pqc` WHERE `mo` = 3 AND `tpl_info` = 29 LIMIT 1 [ RunTime:0.000224s ] [2024-11-13T15:32:10+08:00][sql] INSERT INTO `pqc` SET `mo` = 3 , `product` = 3 , `tpl_info` = 29 , `qc_count` = 1 , `note` = '1' , `result` = 1 , `maker` = 0 , `status` = 1 , `create_time` = '2024-04-08' , `update_time` = '2024-11-13 15:32:10.452225' [ RunTime:0.000234s ] [2024-11-13T15:32:10+08:00][sql] SELECT * FROM `pqc` WHERE `mo` = 3 AND `tpl_info` = 28 LIMIT 1 [ RunTime:0.000246s ] [2024-11-13T15:32:10+08:00][sql] INSERT INTO `pqc` SET `mo` = 3 , `product` = 3 , `tpl_info` = 28 , `qc_count` = 1 , `note` = '1' , `result` = 1 , `maker` = 0 , `status` = 1 , `create_time` = '2024-04-08' , `update_time` = '2024-11-13 15:32:10.453095' [ RunTime:0.000169s ] [2024-11-13T15:32:10+08:00][sql] SELECT * FROM `pqc` WHERE `mo` = 3 AND `tpl_info` = 27 LIMIT 1 [ RunTime:0.000206s ] [2024-11-13T15:32:10+08:00][sql] INSERT INTO `pqc` SET `mo` = 3 , `product` = 3 , `tpl_info` = 27 , `qc_count` = 1 , `note` = '1' , `result` = 1 , `maker` = 0 , `status` = 1 , `create_time` = '2024-04-08' , `update_time` = '2024-11-13 15:32:10.453862' [ RunTime:0.000174s ] [2024-11-13T15:32:10+08:00][sql] SELECT * FROM `pqc` WHERE `mo` = 3 AND `tpl_info` = 26 LIMIT 1 [ RunTime:0.000248s ] [2024-11-13T15:32:10+08:00][sql] INSERT INTO `pqc` SET `mo` = 3 , `product` = 3 , `tpl_info` = 26 , `qc_count` = 1 , `note` = '1' , `result` = 1 , `maker` = 0 , `status` = 1 , `create_time` = '2024-04-08' , `update_time` = '2024-11-13 15:32:10.454682' [ RunTime:0.000214s ] [2024-11-13T15:32:10+08:00][sql] SELECT * FROM `pqc` WHERE `mo` = 3 AND `tpl_info` = 25 LIMIT 1 [ RunTime:0.000242s ] [2024-11-13T15:32:10+08:00][sql] INSERT INTO `pqc` SET `mo` = 3 , `product` = 3 , `tpl_info` = 25 , `qc_count` = 1 , `note` = '1' , `result` = 1 , `maker` = 0 , `status` = 1 , `create_time` = '2024-04-08' , `update_time` = '2024-11-13 15:32:10.455524' [ RunTime:0.000167s ] [2024-11-13T15:32:10+08:00][sql] CONNECT:[ UseTime:0.005795s ] mysql:host=127.0.0.1;port=3306;dbname=hbzahxkj;charset=utf8 [2024-11-13T15:32:10+08:00][sql] SHOW FULL COLUMNS FROM `set` [ RunTime:0.000637s ] [2024-11-13T15:32:10+08:00][sql] UPDATE `set` SET `value` = 'hbzahxkj' WHERE `field` = 'database' [ RunTime:0.000271s ] [2024-11-13T15:32:10+08:00][sql] UPDATE `set` SET `value` = '河北中安禾信科技有限公司' WHERE `field` = 'title' [ RunTime:0.000188s ] [2024-11-13T15:32:10+08:00][sql] UPDATE `set` SET `value` = '42,43,389' WHERE `field` = 'product_sort' [ RunTime:0.000301s ] [2024-11-13T15:32:10+08:00][sql] SHOW FULL COLUMNS FROM `mo` [ RunTime:0.001075s ] [2024-11-13T15:32:10+08:00][sql] SELECT * FROM `mo` WHERE `id` IN (1,2,3) [ RunTime:0.000325s ] [2024-11-13T15:32:10+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.000981s ] [2024-11-13T15:32:10+08:00][sql] SELECT * FROM `product` WHERE `id` IN (1,2,3) [ RunTime:0.000332s ] [2024-11-13T15:32:10+08:00][sql] SHOW FULL COLUMNS FROM `fqc` [ RunTime:0.001429s ] [2024-11-13T15:32:10+08:00][sql] SELECT `number` FROM `fqc` WHERE `create_time` >= '2024-04-08 00:00:00' [ RunTime:0.000226s ] [2024-11-13T15:32:10+08:00][sql] SHOW FULL COLUMNS FROM `tpl` [ RunTime:0.000906s ] [2024-11-13T15:32:10+08:00][sql] SELECT * FROM `tpl` WHERE `status` = 1 AND `tpl_sort` = '7' AND `sort` = 43 [ RunTime:0.000498s ] [2024-11-13T15:32:10+08:00][sql] SHOW FULL COLUMNS FROM `tpl_info` [ RunTime:0.000899s ] [2024-11-13T15:32:10+08:00][sql] SELECT * FROM `tpl_info` WHERE `tpl` = 5 ORDER BY `order` ASC [ RunTime:0.000427s ] [2024-11-13T15:32:10+08:00][sql] SELECT * FROM `tpl` WHERE `status` = 1 AND `tpl_sort` = '7' AND `sort` = 42 [ RunTime:0.000267s ] [2024-11-13T15:32:10+08:00][sql] SELECT * FROM `tpl_info` WHERE `tpl` = 4 ORDER BY `order` ASC [ RunTime:0.000491s ] [2024-11-13T15:32:10+08:00][sql] SELECT * FROM `tpl` WHERE `status` = 1 AND `tpl_sort` = '7' AND `sort` = 389 [ RunTime:0.000327s ] [2024-11-13T15:32:10+08:00][sql] SELECT * FROM `tpl_info` WHERE `tpl` = 6 ORDER BY `order` ASC [ RunTime:0.000341s ] [2024-11-13T15:32:10+08:00][sql] insert into `fqc`(number,mo,product,note,result,create_time)values('20240408001_0001', '1', '1', '{"56":1,"55":1,"54":1,"53":1,"52":1,"51":1,"50":1,"49":1,"48":1,"47":1}', '1', '2024-04-08'),('20240408001_0002', '1', '1', '{"56":1,"55":1,"54":1,"53":1,"52":1,"51":1,"50":1,"49":1,"48":1,"47":1}', '1', '2024-04-08'),('20240408002_0001', '2', '2', '{"37":1,"38":1,"39":1,"40":1,"41":1,"42":1,"43":1,"44":1,"45":1,"46":1}', '1', '2024-04-08'),('20240408002_0002', '2', '2', '{"37":1,"38":1,"39":1,"40":1,"41":1,"42":1,"43":1,"44":1,"45":1,"46":1}', '1', '2024-04-08'),('20240408003_0001', '3', '3', '{"66":1,"65":1,"64":1,"63":1,"62":1,"61":1,"60":1,"59":1,"58":1,"57":1}', '1', '2024-04-08'),('20240408003_0002', '3', '3', '{"66":1,"65":1,"64":1,"63":1,"62":1,"61":1,"60":1,"59":1,"58":1,"57":1}', '1', '2024-04-08') [ RunTime:0.000404s ] [2024-11-13T15:32:10+08:00][sql] CONNECT:[ UseTime:0.009435s ] mysql:host=127.0.0.1;port=3306;dbname=hbzahxkj;charset=utf8 [2024-11-13T15:32:10+08:00][sql] SHOW FULL COLUMNS FROM `set` [ RunTime:0.000666s ] [2024-11-13T15:32:10+08:00][sql] UPDATE `set` SET `value` = 'hbzahxkj' WHERE `field` = 'database' [ RunTime:0.000297s ] [2024-11-13T15:32:10+08:00][sql] UPDATE `set` SET `value` = '河北中安禾信科技有限公司' WHERE `field` = 'title' [ RunTime:0.000195s ] [2024-11-13T15:32:10+08:00][sql] UPDATE `set` SET `value` = '42,43,389' WHERE `field` = 'product_sort' [ RunTime:0.000196s ] [2024-11-13T15:32:10+08:00][sql] SHOW FULL COLUMNS FROM `up` [ RunTime:0.001599s ] [2024-11-13T15:32:10+08:00][sql] SHOW FULL COLUMNS FROM `mo` [ RunTime:0.000950s ] [2024-11-13T15:32:10+08:00][sql] SELECT * FROM `mo` WHERE `id` IN (1,2,3) [ RunTime:0.000371s ] [2024-11-13T15:32:10+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.000933s ] [2024-11-13T15:32:10+08:00][sql] SELECT * FROM `product` WHERE `id` IN (1,2,3) [ RunTime:0.000309s ] [2024-11-13T15:32:10+08:00][sql] SELECT `value` FROM `set` WHERE `field` = 'capacity' LIMIT 1 [ RunTime:0.000297s ] [2024-11-13T15:32:10+08:00][sql] SELECT * FROM `up` WHERE `mo` = 1 AND `product` = 1 LIMIT 1 [ RunTime:0.000263s ] [2024-11-13T15:32:10+08:00][sql] SELECT MAX(`number`) AS think_max FROM `up` WHERE `number` LIKE '20240409%' LIMIT 1 [ RunTime:0.000212s ] [2024-11-13T15:32:10+08:00][sql] INSERT INTO `up` SET `number` = '20240409001' , `mo` = 1 , `so` = 1 , `product` = 1 , `count` = 2 , `create_time` = '2024-04-08 00:00:00' , `status` = 1 , `pass_man` = 0 , `put_man` = 0 , `remark` = '' , `update_time` = '2024-11-13 15:32:10.714908' [ RunTime:0.000273s ] [2024-11-13T15:32:10+08:00][sql] SELECT * FROM `up` WHERE `mo` = 2 AND `product` = 2 LIMIT 1 [ RunTime:0.000239s ] [2024-11-13T15:32:10+08:00][sql] SELECT MAX(`number`) AS think_max FROM `up` WHERE `number` LIKE '20240409%' LIMIT 1 [ RunTime:0.000185s ] [2024-11-13T15:32:10+08:00][sql] INSERT INTO `up` SET `number` = '20240409002' , `mo` = 2 , `so` = 1 , `product` = 2 , `count` = 2 , `create_time` = '2024-04-08 00:00:00' , `status` = 1 , `pass_man` = 0 , `put_man` = 0 , `remark` = '' , `update_time` = '2024-11-13 15:32:10.716184' [ RunTime:0.000221s ] [2024-11-13T15:32:10+08:00][sql] SELECT * FROM `up` WHERE `mo` = 3 AND `product` = 3 LIMIT 1 [ RunTime:0.000209s ] [2024-11-13T15:32:10+08:00][sql] SELECT MAX(`number`) AS think_max FROM `up` WHERE `number` LIKE '20240409%' LIMIT 1 [ RunTime:0.000192s ] [2024-11-13T15:32:10+08:00][sql] INSERT INTO `up` SET `number` = '20240409003' , `mo` = 3 , `so` = 1 , `product` = 3 , `count` = 2 , `create_time` = '2024-04-08 00:00:00' , `status` = 1 , `pass_man` = 0 , `put_man` = 0 , `remark` = '' , `update_time` = '2024-11-13 15:32:10.717385' [ RunTime:0.000233s ] [2024-11-13T15:32:10+08:00][sql] CONNECT:[ UseTime:0.000772s ] mysql:host=127.0.0.1;port=3306;dbname=hbzahxkj;charset=utf8 [2024-11-13T15:32:10+08:00][sql] SHOW FULL COLUMNS FROM `set` [ RunTime:0.000627s ] [2024-11-13T15:32:10+08:00][sql] UPDATE `set` SET `value` = 'hbzahxkj' WHERE `field` = 'database' [ RunTime:0.000251s ] [2024-11-13T15:32:10+08:00][sql] UPDATE `set` SET `value` = '河北中安禾信科技有限公司' WHERE `field` = 'title' [ RunTime:0.000190s ] [2024-11-13T15:32:10+08:00][sql] UPDATE `set` SET `value` = '42,43,389' WHERE `field` = 'product_sort' [ RunTime:0.000178s ] [2024-11-13T15:32:10+08:00][sql] SHOW FULL COLUMNS FROM `mo` [ RunTime:0.000957s ] [2024-11-13T15:32:10+08:00][sql] SELECT * FROM `mo` WHERE `id` IN (1,2,3) [ RunTime:0.000374s ] [2024-11-13T15:32:10+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.000570s ] [2024-11-13T15:32:10+08:00][sql] SELECT * FROM `product` WHERE `id` IN (1,2,3) [ RunTime:0.000261s ] [2024-11-13T15:32:10+08:00][sql] SHOW FULL COLUMNS FROM `tpl` [ RunTime:0.000973s ] [2024-11-13T15:32:10+08:00][sql] SELECT * FROM `tpl` WHERE `status` = 1 AND `tpl_sort` = '8' AND `sort` = 43 [ RunTime:0.000312s ] [2024-11-13T15:32:10+08:00][sql] SHOW FULL COLUMNS FROM `tpl_info` [ RunTime:0.000877s ] [2024-11-13T15:32:10+08:00][sql] SELECT * FROM `tpl_info` WHERE `tpl` = 8 ORDER BY `order` ASC [ RunTime:0.000385s ] [2024-11-13T15:32:10+08:00][sql] SHOW FULL COLUMNS FROM `fqc` [ RunTime:0.000843s ] [2024-11-13T15:32:10+08:00][sql] SELECT * FROM `fqc` WHERE `mo` = 1 ORDER BY rand() LIMIT 2 [ RunTime:0.000483s ] [2024-11-13T15:32:10+08:00][sql] SHOW FULL COLUMNS FROM `oqc` [ RunTime:0.001541s ] [2024-11-13T15:32:10+08:00][sql] SELECT COUNT(*) AS think_count FROM `oqc` WHERE `mo` = 1 AND `product` = 1 LIMIT 1 [ RunTime:0.000272s ] [2024-11-13T15:32:10+08:00][sql] INSERT INTO `oqc` SET `number` = '20240408001_0001' , `mo` = 1 , `product` = 1 , `note` = '{\"98\":1,\"97\":1,\"96\":1,\"95\":1,\"94\":1,\"93\":1,\"92\":1,\"91\":1,\"90\":1,\"89\":1,\"88\":1,\"87\":1,\"86\":1,\"85\":1,\"84\":1,\"83\":1}' , `result` = 1 , `create_time` = '2024-04-08' , `update_time` = '2024-11-13 15:32:10.864283' [ RunTime:0.000261s ] [2024-11-13T15:32:10+08:00][sql] SELECT COUNT(*) AS think_count FROM `oqc` WHERE `mo` = 1 AND `product` = 1 LIMIT 1 [ RunTime:0.000194s ] [2024-11-13T15:32:10+08:00][sql] INSERT INTO `oqc` SET `number` = '20240408001_0002' , `mo` = 1 , `product` = 1 , `note` = '{\"98\":1,\"97\":1,\"96\":1,\"95\":1,\"94\":1,\"93\":1,\"92\":1,\"91\":1,\"90\":1,\"89\":1,\"88\":1,\"87\":1,\"86\":1,\"85\":1,\"84\":1,\"83\":1}' , `result` = 1 , `create_time` = '2024-04-08' , `update_time` = '2024-11-13 15:32:10.865307' [ RunTime:0.000206s ] [2024-11-13T15:32:10+08:00][sql] SELECT * FROM `tpl` WHERE `status` = 1 AND `tpl_sort` = '8' AND `sort` = 42 [ RunTime:0.000235s ] [2024-11-13T15:32:10+08:00][sql] SELECT * FROM `tpl_info` WHERE `tpl` = 7 ORDER BY `order` ASC [ RunTime:0.000341s ] [2024-11-13T15:32:10+08:00][sql] SELECT * FROM `fqc` WHERE `mo` = 2 ORDER BY rand() LIMIT 2 [ RunTime:0.000426s ] [2024-11-13T15:32:10+08:00][sql] SELECT COUNT(*) AS think_count FROM `oqc` WHERE `mo` = 2 AND `product` = 2 LIMIT 1 [ RunTime:0.000227s ] [2024-11-13T15:32:10+08:00][sql] INSERT INTO `oqc` SET `number` = '20240408002_0002' , `mo` = 2 , `product` = 2 , `note` = '{\"67\":1,\"68\":1,\"69\":1,\"70\":1,\"71\":1,\"72\":1,\"73\":1,\"74\":1,\"75\":1,\"76\":1,\"77\":1,\"78\":1,\"79\":1,\"80\":1,\"81\":1,\"82\":1}' , `result` = 1 , `create_time` = '2024-04-08' , `update_time` = '2024-11-13 15:32:10.868557' [ RunTime:0.000249s ] [2024-11-13T15:32:10+08:00][sql] SELECT COUNT(*) AS think_count FROM `oqc` WHERE `mo` = 2 AND `product` = 2 LIMIT 1 [ RunTime:0.000205s ] [2024-11-13T15:32:10+08:00][sql] INSERT INTO `oqc` SET `number` = '20240408002_0001' , `mo` = 2 , `product` = 2 , `note` = '{\"67\":1,\"68\":1,\"69\":1,\"70\":1,\"71\":1,\"72\":1,\"73\":1,\"74\":1,\"75\":1,\"76\":1,\"77\":1,\"78\":1,\"79\":1,\"80\":1,\"81\":1,\"82\":1}' , `result` = 1 , `create_time` = '2024-04-08' , `update_time` = '2024-11-13 15:32:10.869424' [ RunTime:0.000293s ] [2024-11-13T15:32:10+08:00][sql] SELECT * FROM `tpl` WHERE `status` = 1 AND `tpl_sort` = '8' AND `sort` = 389 [ RunTime:0.000225s ] [2024-11-13T15:32:10+08:00][sql] SELECT * FROM `tpl_info` WHERE `tpl` = 9 ORDER BY `order` ASC [ RunTime:0.000321s ] [2024-11-13T15:32:10+08:00][sql] SELECT * FROM `fqc` WHERE `mo` = 3 ORDER BY rand() LIMIT 2 [ RunTime:0.000407s ] [2024-11-13T15:32:10+08:00][sql] SELECT COUNT(*) AS think_count FROM `oqc` WHERE `mo` = 3 AND `product` = 3 LIMIT 1 [ RunTime:0.000218s ] [2024-11-13T15:32:10+08:00][sql] INSERT INTO `oqc` SET `number` = '20240408003_0002' , `mo` = 3 , `product` = 3 , `note` = '{\"114\":1,\"113\":1,\"112\":1,\"111\":1,\"110\":1,\"109\":1,\"108\":1,\"107\":1,\"106\":1,\"105\":1,\"104\":1,\"103\":1,\"102\":1,\"101\":1,\"100\":1,\"99\":1}' , `result` = 1 , `create_time` = '2024-04-08' , `update_time` = '2024-11-13 15:32:10.872596' [ RunTime:0.000932s ] [2024-11-13T15:32:10+08:00][sql] SELECT COUNT(*) AS think_count FROM `oqc` WHERE `mo` = 3 AND `product` = 3 LIMIT 1 [ RunTime:0.000231s ] [2024-11-13T15:32:10+08:00][sql] INSERT INTO `oqc` SET `number` = '20240408003_0001' , `mo` = 3 , `product` = 3 , `note` = '{\"114\":1,\"113\":1,\"112\":1,\"111\":1,\"110\":1,\"109\":1,\"108\":1,\"107\":1,\"106\":1,\"105\":1,\"104\":1,\"103\":1,\"102\":1,\"101\":1,\"100\":1,\"99\":1}' , `result` = 1 , `create_time` = '2024-04-08' , `update_time` = '2024-11-13 15:32:10.874223' [ RunTime:0.000197s ] [2024-11-13T15:32:11+08:00][sql] CONNECT:[ UseTime:0.010223s ] mysql:host=127.0.0.1;port=3306;dbname=hbzahxkj;charset=utf8 [2024-11-13T15:32:11+08:00][sql] SHOW FULL COLUMNS FROM `set` [ RunTime:0.000665s ] [2024-11-13T15:32:11+08:00][sql] UPDATE `set` SET `value` = 'hbzahxkj' WHERE `field` = 'database' [ RunTime:0.000328s ] [2024-11-13T15:32:11+08:00][sql] UPDATE `set` SET `value` = '河北中安禾信科技有限公司' WHERE `field` = 'title' [ RunTime:0.000204s ] [2024-11-13T15:32:11+08:00][sql] UPDATE `set` SET `value` = '42,43,389' WHERE `field` = 'product_sort' [ RunTime:0.000178s ] [2024-11-13T15:32:11+08:00][sql] SHOW FULL COLUMNS FROM `pp` [ RunTime:0.000554s ] [2024-11-13T15:32:11+08:00][sql] SELECT * FROM `pp` WHERE `so` = 1 [ RunTime:0.000254s ] [2024-11-13T15:32:11+08:00][sql] SHOW FULL COLUMNS FROM `so` [ RunTime:0.000975s ] [2024-11-13T15:32:11+08:00][sql] SELECT * FROM `so` WHERE `id` = 1 [ RunTime:0.000308s ] [2024-11-13T15:32:11+08:00][sql] SHOW FULL COLUMNS FROM `sell` [ RunTime:0.001618s ] [2024-11-13T15:32:11+08:00][sql] SELECT * FROM `sell` WHERE `so` = 1 AND `pp` = 1 AND `product` = 1 LIMIT 1 [ RunTime:0.000278s ] [2024-11-13T15:32:11+08:00][sql] INSERT INTO `sell` SET `so` = 1 , `pp` = 1 , `product` = 1 , `count` = 2 , `cust` = 1 , `create_time` = '2024-04-14 12:00:00' , `pass_man` = 0 , `report_time` = '2024-04-15 00:00:00' , `start_num` = '41062AA09728AA' , `status` = 2 , `end_num` = '41062AA09730AA' , `update_time` = '2024-11-13 15:32:10.996024' [ RunTime:0.000379s ] [2024-11-13T15:32:11+08:00][sql] SELECT * FROM `sell` WHERE `so` = 1 AND `pp` = 2 AND `product` = 2 LIMIT 1 [ RunTime:0.000229s ] [2024-11-13T15:32:11+08:00][sql] INSERT INTO `sell` SET `so` = 1 , `pp` = 2 , `product` = 2 , `count` = 2 , `cust` = 1 , `create_time` = '2024-04-14 12:00:00' , `pass_man` = 0 , `report_time` = '2024-04-15 00:00:00' , `start_num` = '41062AA09731AA' , `status` = 2 , `end_num` = '41062AA09733AA' , `update_time` = '2024-11-13 15:32:10.997207' [ RunTime:0.000208s ] [2024-11-13T15:32:11+08:00][sql] SELECT * FROM `sell` WHERE `so` = 1 AND `pp` = 3 AND `product` = 3 LIMIT 1 [ RunTime:0.000226s ] [2024-11-13T15:32:11+08:00][sql] INSERT INTO `sell` SET `so` = 1 , `pp` = 3 , `product` = 3 , `count` = 2 , `cust` = 1 , `create_time` = '2024-04-14 12:00:00' , `pass_man` = 0 , `report_time` = '2024-04-15 00:00:00' , `start_num` = '41062AA09734AA' , `status` = 2 , `end_num` = '41062AA09736AA' , `update_time` = '2024-11-13 15:32:10.998173' [ RunTime:0.000197s ]