[2024-11-14T09:37:46+08:00][sql] CONNECT:[ UseTime:0.012900s ] mysql:host=127.0.0.1;port=3306;dbname=hbzahxkj;charset=utf8 [2024-11-14T09:37:46+08:00][sql] SHOW FULL COLUMNS FROM `set` [ RunTime:0.000751s ] [2024-11-14T09:37:46+08:00][sql] UPDATE `set` SET `value` = 'hbzahxkj' WHERE `field` = 'database' [ RunTime:0.000282s ] [2024-11-14T09:37:46+08:00][sql] UPDATE `set` SET `value` = '河北中安禾信科技有限公司' WHERE `field` = 'title' [ RunTime:0.000222s ] [2024-11-14T09:37:46+08:00][sql] UPDATE `set` SET `value` = '42,43,389' WHERE `field` = 'product_sort' [ RunTime:0.000206s ] [2024-11-14T09:37:52+08:00][sql] CONNECT:[ UseTime:0.013037s ] mysql:host=127.0.0.1;port=3306;dbname=hbzahxkj;charset=utf8 [2024-11-14T09:37:52+08:00][sql] SHOW FULL COLUMNS FROM `set` [ RunTime:0.000678s ] [2024-11-14T09:37:52+08:00][sql] UPDATE `set` SET `value` = 'hbzahxkj' WHERE `field` = 'database' [ RunTime:0.000310s ] [2024-11-14T09:37:52+08:00][sql] UPDATE `set` SET `value` = '河北中安禾信科技有限公司' WHERE `field` = 'title' [ RunTime:0.000202s ] [2024-11-14T09:37:52+08:00][sql] UPDATE `set` SET `value` = '42,43,389' WHERE `field` = 'product_sort' [ RunTime:0.000182s ] [2024-11-14T09:37:53+08:00][sql] CONNECT:[ UseTime:0.007422s ] mysql:host=127.0.0.1;port=3306;dbname=hbzahxkj;charset=utf8 [2024-11-14T09:37:53+08:00][sql] SHOW FULL COLUMNS FROM `set` [ RunTime:0.000730s ] [2024-11-14T09:37:53+08:00][sql] UPDATE `set` SET `value` = 'hbzahxkj' WHERE `field` = 'database' [ RunTime:0.000314s ] [2024-11-14T09:37:53+08:00][sql] UPDATE `set` SET `value` = '河北中安禾信科技有限公司' WHERE `field` = 'title' [ RunTime:0.000220s ] [2024-11-14T09:37:53+08:00][sql] UPDATE `set` SET `value` = '42,43,389' WHERE `field` = 'product_sort' [ RunTime:0.000189s ] [2024-11-14T09:37:53+08:00][sql] SHOW FULL COLUMNS FROM `cust` [ RunTime:0.001086s ] [2024-11-14T09:37:53+08:00][sql] SELECT MAX(`number`) AS think_max FROM `cust` LIMIT 1 [ RunTime:0.000262s ] [2024-11-14T09:37:53+08:00][sql] SELECT * FROM `cust` WHERE `name` = '宿州市九颂洲樾小区' LIMIT 1 [ RunTime:0.000243s ] [2024-11-14T09:37:53+08:00][sql] SHOW FULL COLUMNS FROM `project` [ RunTime:0.000951s ] [2024-11-14T09:37:53+08:00][sql] SELECT * FROM `project` WHERE `name` = '' AND `cust` = 1 LIMIT 1 [ RunTime:0.000263s ] [2024-11-14T09:37:53+08:00][sql] SELECT * FROM `cust` WHERE `name` = '宿州市九颂洲樾小区' LIMIT 1 [ RunTime:0.000236s ] [2024-11-14T09:37:53+08:00][sql] SELECT * FROM `project` WHERE `name` = '' AND `cust` = 1 LIMIT 1 [ RunTime:0.000245s ] [2024-11-14T09:37:53+08:00][sql] SELECT * FROM `cust` WHERE `name` = '宿州市九颂洲樾小区' LIMIT 1 [ RunTime:0.000245s ] [2024-11-14T09:37:53+08:00][sql] SELECT * FROM `project` WHERE `name` = '' AND `cust` = 1 LIMIT 1 [ RunTime:0.000193s ] [2024-11-14T09:37:53+08:00][sql] SHOW FULL COLUMNS FROM `product` [ RunTime:0.000546s ] [2024-11-14T09:37:53+08:00][sql] SELECT * FROM `product` [ RunTime:0.000224s ] [2024-11-14T09:37:53+08:00][sql] SELECT `value` FROM `set` WHERE `field` = 'lead_time' LIMIT 1 [ RunTime:0.000234s ] [2024-11-14T09:37:53+08:00][sql] SHOW FULL COLUMNS FROM `so` [ RunTime:0.000915s ] [2024-11-14T09:37:53+08:00][sql] SELECT * FROM `so` WHERE `cust` = 1 AND `project` = '1' AND `report_time` = '2024-04-15' LIMIT 1 [ RunTime:0.000261s ] [2024-11-14T09:37:53+08:00][sql] SHOW FULL COLUMNS FROM `pp` [ RunTime:0.000894s ] [2024-11-14T09:37:53+08:00][sql] SELECT * FROM `pp` WHERE `start_num` = '41062AA09728AA' AND `end_num` = '41062AA09730AA' LIMIT 1 [ RunTime:0.000427s ] [2024-11-14T09:37:53+08:00][sql] SELECT * FROM `pp` WHERE `start_num` = '41062AA09731AA' AND `end_num` = '41062AA09733AA' LIMIT 1 [ RunTime:0.000299s ] [2024-11-14T09:37:53+08:00][sql] SELECT * FROM `pp` WHERE `start_num` = '41062AA09734AA' AND `end_num` = '41062AA09736AA' LIMIT 1 [ RunTime:0.000253s ] [2024-11-14T09:37:53+08:00][sql] CONNECT:[ UseTime:0.002849s ] mysql:host=127.0.0.1;port=3306;dbname=hbzahxkj;charset=utf8 [2024-11-14T09:37:53+08:00][sql] SHOW FULL COLUMNS FROM `set` [ RunTime:0.000684s ] [2024-11-14T09:37:53+08:00][sql] UPDATE `set` SET `value` = 'hbzahxkj' WHERE `field` = 'database' [ RunTime:0.000260s ] [2024-11-14T09:37:53+08:00][sql] UPDATE `set` SET `value` = '河北中安禾信科技有限公司' WHERE `field` = 'title' [ RunTime:0.000197s ] [2024-11-14T09:37:53+08:00][sql] UPDATE `set` SET `value` = '42,43,389' WHERE `field` = 'product_sort' [ RunTime:0.000231s ] [2024-11-14T09:37:53+08:00][sql] SHOW FULL COLUMNS FROM `pp` [ RunTime:0.001006s ] [2024-11-14T09:37:53+08:00][sql] SELECT * FROM `pp` WHERE `so` = 1 [ RunTime:0.000327s ] [2024-11-14T09:37:53+08:00][sql] SHOW FULL COLUMNS FROM `bom` [ RunTime:0.000976s ] [2024-11-14T09:37:53+08:00][sql] SELECT * FROM `bom` WHERE `product` IN (1,2,3) [ RunTime:0.000284s ] [2024-11-14T09:37:53+08:00][sql] SHOW FULL COLUMNS FROM `bom_info` [ RunTime:0.000962s ] [2024-11-14T09:37:53+08:00][sql] SELECT * FROM `bom_info` WHERE `bom` IN (1,2,3) [ RunTime:0.000352s ] [2024-11-14T09:37:53+08:00][sql] SHOW FULL COLUMNS FROM `raw` [ RunTime:0.000954s ] [2024-11-14T09:37:53+08:00][sql] SELECT * FROM `raw` [ RunTime:0.000299s ] [2024-11-14T09:37:53+08:00][sql] SHOW FULL COLUMNS FROM `mrp` [ RunTime:0.000942s ] [2024-11-14T09:37:53+08:00][sql] SELECT * FROM `mrp` WHERE `pp` = 1 AND `raw` = 1 LIMIT 1 [ RunTime:0.000326s ] [2024-11-14T09:37:53+08:00][sql] SELECT * FROM `mrp` WHERE `pp` = 1 AND `raw` = 2 LIMIT 1 [ RunTime:0.000309s ] [2024-11-14T09:37:53+08:00][sql] SELECT * FROM `mrp` WHERE `pp` = 1 AND `raw` = 3 LIMIT 1 [ RunTime:0.000240s ] [2024-11-14T09:37:53+08:00][sql] SELECT * FROM `mrp` WHERE `pp` = 1 AND `raw` = 4 LIMIT 1 [ RunTime:0.000200s ] [2024-11-14T09:37:53+08:00][sql] SELECT * FROM `mrp` WHERE `pp` = 1 AND `raw` = 5 LIMIT 1 [ RunTime:0.000201s ] [2024-11-14T09:37:53+08:00][sql] SELECT * FROM `mrp` WHERE `pp` = 1 AND `raw` = 6 LIMIT 1 [ RunTime:0.000213s ] [2024-11-14T09:37:53+08:00][sql] SELECT * FROM `mrp` WHERE `pp` = 1 AND `raw` = 7 LIMIT 1 [ RunTime:0.000181s ] [2024-11-14T09:37:53+08:00][sql] SELECT * FROM `mrp` WHERE `pp` = 1 AND `raw` = 8 LIMIT 1 [ RunTime:0.000191s ] [2024-11-14T09:37:53+08:00][sql] SELECT * FROM `mrp` WHERE `pp` = 1 AND `raw` = 9 LIMIT 1 [ RunTime:0.000199s ] [2024-11-14T09:37:53+08:00][sql] SELECT * FROM `mrp` WHERE `pp` = 1 AND `raw` = 10 LIMIT 1 [ RunTime:0.000180s ] [2024-11-14T09:37:53+08:00][sql] SELECT * FROM `mrp` WHERE `pp` = 1 AND `raw` = 11 LIMIT 1 [ RunTime:0.000191s ] [2024-11-14T09:37:53+08:00][sql] SELECT * FROM `mrp` WHERE `pp` = 1 AND `raw` = 12 LIMIT 1 [ RunTime:0.000197s ] [2024-11-14T09:37:53+08:00][sql] SELECT * FROM `mrp` WHERE `pp` = 1 AND `raw` = 13 LIMIT 1 [ RunTime:0.000178s ] [2024-11-14T09:37:53+08:00][sql] SELECT * FROM `mrp` WHERE `pp` = 2 AND `raw` = 1 LIMIT 1 [ RunTime:0.000190s ] [2024-11-14T09:37:53+08:00][sql] SELECT * FROM `mrp` WHERE `pp` = 2 AND `raw` = 3 LIMIT 1 [ RunTime:0.000208s ] [2024-11-14T09:37:53+08:00][sql] SELECT * FROM `mrp` WHERE `pp` = 2 AND `raw` = 4 LIMIT 1 [ RunTime:0.000179s ] [2024-11-14T09:37:53+08:00][sql] SELECT * FROM `mrp` WHERE `pp` = 2 AND `raw` = 5 LIMIT 1 [ RunTime:0.000189s ] [2024-11-14T09:37:53+08:00][sql] SELECT * FROM `mrp` WHERE `pp` = 2 AND `raw` = 6 LIMIT 1 [ RunTime:0.000211s ] [2024-11-14T09:37:53+08:00][sql] SELECT * FROM `mrp` WHERE `pp` = 2 AND `raw` = 11 LIMIT 1 [ RunTime:0.000180s ] [2024-11-14T09:37:53+08:00][sql] SELECT * FROM `mrp` WHERE `pp` = 2 AND `raw` = 13 LIMIT 1 [ RunTime:0.000190s ] [2024-11-14T09:37:53+08:00][sql] SELECT * FROM `mrp` WHERE `pp` = 2 AND `raw` = 14 LIMIT 1 [ RunTime:0.000212s ] [2024-11-14T09:37:53+08:00][sql] SELECT * FROM `mrp` WHERE `pp` = 2 AND `raw` = 15 LIMIT 1 [ RunTime:0.000179s ] [2024-11-14T09:37:53+08:00][sql] SELECT * FROM `mrp` WHERE `pp` = 2 AND `raw` = 16 LIMIT 1 [ RunTime:0.000190s ] [2024-11-14T09:37:53+08:00][sql] SELECT * FROM `mrp` WHERE `pp` = 2 AND `raw` = 17 LIMIT 1 [ RunTime:0.000212s ] [2024-11-14T09:37:53+08:00][sql] SELECT * FROM `mrp` WHERE `pp` = 2 AND `raw` = 18 LIMIT 1 [ RunTime:0.000182s ] [2024-11-14T09:37:53+08:00][sql] SELECT * FROM `mrp` WHERE `pp` = 3 AND `raw` = 1 LIMIT 1 [ RunTime:0.000191s ] [2024-11-14T09:37:53+08:00][sql] SELECT * FROM `mrp` WHERE `pp` = 3 AND `raw` = 3 LIMIT 1 [ RunTime:0.000214s ] [2024-11-14T09:37:53+08:00][sql] SELECT * FROM `mrp` WHERE `pp` = 3 AND `raw` = 6 LIMIT 1 [ RunTime:0.000187s ] [2024-11-14T09:37:53+08:00][sql] SELECT * FROM `mrp` WHERE `pp` = 3 AND `raw` = 7 LIMIT 1 [ RunTime:0.000196s ] [2024-11-14T09:37:53+08:00][sql] SELECT * FROM `mrp` WHERE `pp` = 3 AND `raw` = 8 LIMIT 1 [ RunTime:0.000219s ] [2024-11-14T09:37:53+08:00][sql] SELECT * FROM `mrp` WHERE `pp` = 3 AND `raw` = 11 LIMIT 1 [ RunTime:0.000191s ] [2024-11-14T09:37:53+08:00][sql] SELECT * FROM `mrp` WHERE `pp` = 3 AND `raw` = 13 LIMIT 1 [ RunTime:0.000193s ] [2024-11-14T09:37:53+08:00][sql] SELECT * FROM `mrp` WHERE `pp` = 3 AND `raw` = 19 LIMIT 1 [ RunTime:0.000208s ] [2024-11-14T09:37:53+08:00][sql] SELECT * FROM `mrp` WHERE `pp` = 3 AND `raw` = 20 LIMIT 1 [ RunTime:0.000194s ] [2024-11-14T09:37:53+08:00][sql] SELECT * FROM `mrp` WHERE `pp` = 3 AND `raw` = 21 LIMIT 1 [ RunTime:0.000189s ] [2024-11-14T09:37:53+08:00][sql] SELECT * FROM `mrp` WHERE `pp` = 3 AND `raw` = 22 LIMIT 1 [ RunTime:0.000203s ] [2024-11-14T09:37:53+08:00][sql] CONNECT:[ UseTime:0.004800s ] mysql:host=127.0.0.1;port=3306;dbname=hbzahxkj;charset=utf8 [2024-11-14T09:37:53+08:00][sql] SHOW FULL COLUMNS FROM `set` [ RunTime:0.000641s ] [2024-11-14T09:37:53+08:00][sql] UPDATE `set` SET `value` = 'hbzahxkj' WHERE `field` = 'database' [ RunTime:0.000286s ] [2024-11-14T09:37:53+08:00][sql] UPDATE `set` SET `value` = '河北中安禾信科技有限公司' WHERE `field` = 'title' [ RunTime:0.000195s ] [2024-11-14T09:37:53+08:00][sql] UPDATE `set` SET `value` = '42,43,389' WHERE `field` = 'product_sort' [ RunTime:0.000212s ] [2024-11-14T09:37:53+08:00][sql] CONNECT:[ UseTime:0.000774s ] mysql:host=127.0.0.1;port=3306;dbname=hbzahxkj;charset=utf8 [2024-11-14T09:37:53+08:00][sql] SHOW FULL COLUMNS FROM `set` [ RunTime:0.000643s ] [2024-11-14T09:37:53+08:00][sql] UPDATE `set` SET `value` = 'hbzahxkj' WHERE `field` = 'database' [ RunTime:0.000263s ] [2024-11-14T09:37:53+08:00][sql] UPDATE `set` SET `value` = '河北中安禾信科技有限公司' WHERE `field` = 'title' [ RunTime:0.000196s ] [2024-11-14T09:37:53+08:00][sql] UPDATE `set` SET `value` = '42,43,389' WHERE `field` = 'product_sort' [ RunTime:0.000179s ] [2024-11-14T09:37:53+08:00][sql] SHOW FULL COLUMNS FROM `mrp` [ RunTime:0.000994s ] [2024-11-14T09:37:53+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.000404s ] [2024-11-14T09:37:53+08:00][sql] SHOW FULL COLUMNS FROM `raw` [ RunTime:0.001009s ] [2024-11-14T09:37:53+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.000406s ] [2024-11-14T09:37:53+08:00][sql] SHOW FULL COLUMNS FROM `supplier` [ RunTime:0.000941s ] [2024-11-14T09:37:53+08:00][sql] SELECT * FROM `supplier` [ RunTime:0.000299s ] [2024-11-14T09:37:53+08:00][sql] SELECT `value` FROM `set` WHERE `field` = 'po_base' LIMIT 1 [ RunTime:0.000265s ] [2024-11-14T09:37:53+08:00][sql] SELECT `value` FROM `set` WHERE `field` = 'po_base' LIMIT 1 [ RunTime:0.000228s ] [2024-11-14T09:37:53+08:00][sql] SELECT `value` FROM `set` WHERE `field` = 'po_base' LIMIT 1 [ RunTime:0.000251s ] [2024-11-14T09:37:53+08:00][sql] SELECT `value` FROM `set` WHERE `field` = 'po_base' LIMIT 1 [ RunTime:0.000226s ] [2024-11-14T09:37:53+08:00][sql] SELECT `value` FROM `set` WHERE `field` = 'po_base' LIMIT 1 [ RunTime:0.000195s ] [2024-11-14T09:37:53+08:00][sql] SELECT `value` FROM `set` WHERE `field` = 'po_base' LIMIT 1 [ RunTime:0.000200s ] [2024-11-14T09:37:53+08:00][sql] SELECT `value` FROM `set` WHERE `field` = 'po_base' LIMIT 1 [ RunTime:0.000176s ] [2024-11-14T09:37:53+08:00][sql] SELECT `value` FROM `set` WHERE `field` = 'po_base' LIMIT 1 [ RunTime:0.000192s ] [2024-11-14T09:37:53+08:00][sql] SELECT `value` FROM `set` WHERE `field` = 'po_base' LIMIT 1 [ RunTime:0.000197s ] [2024-11-14T09:37:53+08:00][sql] SELECT `value` FROM `set` WHERE `field` = 'po_base' LIMIT 1 [ RunTime:0.000174s ] [2024-11-14T09:37:53+08:00][sql] SELECT `value` FROM `set` WHERE `field` = 'po_base' LIMIT 1 [ RunTime:0.000182s ] [2024-11-14T09:37:53+08:00][sql] SELECT `value` FROM `set` WHERE `field` = 'po_base' LIMIT 1 [ RunTime:0.000214s ] [2024-11-14T09:37:53+08:00][sql] SELECT `value` FROM `set` WHERE `field` = 'po_base' LIMIT 1 [ RunTime:0.000179s ] [2024-11-14T09:37:53+08:00][sql] SELECT `value` FROM `set` WHERE `field` = 'po_base' LIMIT 1 [ RunTime:0.000205s ] [2024-11-14T09:37:53+08:00][sql] SELECT `value` FROM `set` WHERE `field` = 'po_base' LIMIT 1 [ RunTime:0.000188s ] [2024-11-14T09:37:53+08:00][sql] SELECT `value` FROM `set` WHERE `field` = 'po_base' LIMIT 1 [ RunTime:0.000182s ] [2024-11-14T09:37:53+08:00][sql] SELECT `value` FROM `set` WHERE `field` = 'po_base' LIMIT 1 [ RunTime:0.000221s ] [2024-11-14T09:37:53+08:00][sql] SELECT `value` FROM `set` WHERE `field` = 'po_base' LIMIT 1 [ RunTime:0.000196s ] [2024-11-14T09:37:53+08:00][sql] SELECT `value` FROM `set` WHERE `field` = 'po_base' LIMIT 1 [ RunTime:0.000186s ] [2024-11-14T09:37:53+08:00][sql] SELECT `value` FROM `set` WHERE `field` = 'po_base' LIMIT 1 [ RunTime:0.000211s ] [2024-11-14T09:37:53+08:00][sql] SELECT `value` FROM `set` WHERE `field` = 'po_base' LIMIT 1 [ RunTime:0.000188s ] [2024-11-14T09:37:53+08:00][sql] SELECT `value` FROM `set` WHERE `field` = 'po_base' LIMIT 1 [ RunTime:0.000188s ] [2024-11-14T09:37:53+08:00][sql] SELECT `value` FROM `set` WHERE `field` = 'po_base' LIMIT 1 [ RunTime:0.000178s ] [2024-11-14T09:37:53+08:00][sql] SELECT `value` FROM `set` WHERE `field` = 'po_base' LIMIT 1 [ RunTime:0.000182s ] [2024-11-14T09:37:53+08:00][sql] SELECT `value` FROM `set` WHERE `field` = 'po_base' LIMIT 1 [ RunTime:0.000202s ] [2024-11-14T09:37:53+08:00][sql] SELECT `value` FROM `set` WHERE `field` = 'po_base' LIMIT 1 [ RunTime:0.000177s ] [2024-11-14T09:37:53+08:00][sql] SELECT `value` FROM `set` WHERE `field` = 'po_base' LIMIT 1 [ RunTime:0.000182s ] [2024-11-14T09:37:53+08:00][sql] SELECT `value` FROM `set` WHERE `field` = 'po_base' LIMIT 1 [ RunTime:0.000222s ] [2024-11-14T09:37:53+08:00][sql] SELECT `value` FROM `set` WHERE `field` = 'po_base' LIMIT 1 [ RunTime:0.000179s ] [2024-11-14T09:37:53+08:00][sql] SELECT `value` FROM `set` WHERE `field` = 'po_base' LIMIT 1 [ RunTime:0.000207s ] [2024-11-14T09:37:53+08:00][sql] SELECT `value` FROM `set` WHERE `field` = 'po_base' LIMIT 1 [ RunTime:0.000188s ] [2024-11-14T09:37:53+08:00][sql] SELECT `value` FROM `set` WHERE `field` = 'po_base' LIMIT 1 [ RunTime:0.000183s ] [2024-11-14T09:37:53+08:00][sql] SELECT `value` FROM `set` WHERE `field` = 'po_base' LIMIT 1 [ RunTime:0.000220s ] [2024-11-14T09:37:53+08:00][sql] SELECT `value` FROM `set` WHERE `field` = 'po_base' LIMIT 1 [ RunTime:0.000174s ] [2024-11-14T09:37:53+08:00][sql] SELECT `value` FROM `set` WHERE `field` = 'po_base' LIMIT 1 [ RunTime:0.000186s ] [2024-11-14T09:37:53+08:00][sql] SELECT `value` FROM `set` WHERE `field` = 'po_base' LIMIT 1 [ RunTime:0.000211s ] [2024-11-14T09:37:53+08:00][sql] SHOW FULL COLUMNS FROM `po` [ RunTime:0.001133s ] [2024-11-14T09:37:53+08:00][sql] SELECT `number` FROM `po` [ RunTime:0.000259s ]