[2024-03-20T14:19:06+08:00][sql] CONNECT:[ UseTime:0.000866s ] mysql:host=127.0.0.1;port=3306;dbname=sttianling;charset=utf8 [2024-03-20T14:19:06+08:00][sql] SHOW FULL COLUMNS FROM `set` [ RunTime:0.000657s ] [2024-03-20T14:19:06+08:00][sql] UPDATE `set` SET `value` = 'sttianling' WHERE `field` = 'database' [ RunTime:0.000274s ] [2024-03-20T14:19:06+08:00][sql] UPDATE `set` SET `value` = '汕头市天凌安防科技有限公司' WHERE `field` = 'title' [ RunTime:0.000209s ] [2024-03-20T14:19:06+08:00][sql] UPDATE `set` SET `value` = '93,90,91,92,105,106,107,108,128,395,403,408,479' WHERE `field` = 'product_sort' [ RunTime:0.000194s ] [2024-03-20T14:19:06+08:00][sql] SHOW FULL COLUMNS FROM `pp` [ RunTime:0.000559s ] [2024-03-20T14:19:06+08:00][sql] SELECT * FROM `pp` WHERE `so` IN (129,130,131,132,133,134) [ RunTime:0.000377s ] [2024-03-20T14:19:06+08:00][sql] SHOW FULL COLUMNS FROM `so` [ RunTime:0.001029s ] [2024-03-20T14:19:06+08:00][sql] SELECT * FROM `so` WHERE `id` IN (129,130,131,132,133,134) [ RunTime:0.000338s ] [2024-03-20T14:19:06+08:00][sql] SELECT `value` FROM `set` WHERE `field` = 'pass_man' LIMIT 1 [ RunTime:0.000248s ] [2024-03-20T14:19:06+08:00][sql] SELECT `value` FROM `set` WHERE `field` = 'put_man' LIMIT 1 [ RunTime:0.000205s ] [2024-03-20T14:19:06+08:00][sql] SELECT `value` FROM `set` WHERE `field` = 'store_man' LIMIT 1 [ RunTime:0.000229s ] [2024-03-20T14:19:06+08:00][sql] SHOW FULL COLUMNS FROM `sell` [ RunTime:0.048326s ] [2024-03-20T14:19:06+08:00][sql] SELECT * FROM `sell` WHERE `so` = 129 AND `pp` = 291 AND `product` = 17 LIMIT 1 [ RunTime:0.049280s ] [2024-03-20T14:19:06+08:00][sql] INSERT INTO `sell` SET `so` = 129 , `pp` = 291 , `product` = 17 , `count` = 580 , `cust` = 293 , `create_time` = '2024-01-22 12:00:00' , `report_time` = '2024-01-23 00:00:00' , `start_num` = '59170AA06345AA' , `status` = 2 , `end_num` = '59170AA06924AA' , `pass_man` = 0 , `store_man` = 0 , `qa_man` = 0 , `update_time` = '2024-03-20 14:19:06.514603' [ RunTime:0.000328s ] [2024-03-20T14:19:06+08:00][sql] SELECT * FROM `sell` WHERE `so` = 129 AND `pp` = 292 AND `product` = 16 LIMIT 1 [ RunTime:0.000370s ] [2024-03-20T14:19:06+08:00][sql] INSERT INTO `sell` SET `so` = 129 , `pp` = 292 , `product` = 16 , `count` = 348 , `cust` = 293 , `create_time` = '2024-01-22 12:00:00' , `report_time` = '2024-01-23 00:00:00' , `start_num` = '59170AA06925AA' , `status` = 2 , `end_num` = '59170AA07272AA' , `pass_man` = 0 , `store_man` = 0 , `qa_man` = 0 , `update_time` = '2024-03-20 14:19:06.515990' [ RunTime:0.000203s ] [2024-03-20T14:19:06+08:00][sql] SELECT * FROM `sell` WHERE `so` = 130 AND `pp` = 293 AND `product` = 13 LIMIT 1 [ RunTime:0.000303s ] [2024-03-20T14:19:06+08:00][sql] INSERT INTO `sell` SET `so` = 130 , `pp` = 293 , `product` = 13 , `count` = 698 , `cust` = 294 , `create_time` = '2024-01-23 12:00:00' , `report_time` = '2024-01-24 00:00:00' , `start_num` = '59170AA07273AA' , `status` = 2 , `end_num` = '59170AA07970AA' , `pass_man` = 0 , `store_man` = 0 , `qa_man` = 0 , `update_time` = '2024-03-20 14:19:06.516943' [ RunTime:0.000188s ] [2024-03-20T14:19:06+08:00][sql] SELECT * FROM `sell` WHERE `so` = 130 AND `pp` = 294 AND `product` = 12 LIMIT 1 [ RunTime:0.000258s ] [2024-03-20T14:19:06+08:00][sql] INSERT INTO `sell` SET `so` = 130 , `pp` = 294 , `product` = 12 , `count` = 946 , `cust` = 294 , `create_time` = '2024-01-23 12:00:00' , `report_time` = '2024-01-24 00:00:00' , `start_num` = '59170AA07971AA' , `status` = 2 , `end_num` = '59170AA08916AA' , `pass_man` = 0 , `store_man` = 0 , `qa_man` = 0 , `update_time` = '2024-03-20 14:19:06.517872' [ RunTime:0.000191s ] [2024-03-20T14:19:06+08:00][sql] SELECT * FROM `sell` WHERE `so` = 130 AND `pp` = 295 AND `product` = 8 LIMIT 1 [ RunTime:0.000261s ] [2024-03-20T14:19:06+08:00][sql] INSERT INTO `sell` SET `so` = 130 , `pp` = 295 , `product` = 8 , `count` = 32 , `cust` = 294 , `create_time` = '2024-01-23 12:00:00' , `report_time` = '2024-01-24 00:00:00' , `start_num` = '59170AA08917AA' , `status` = 2 , `end_num` = '59170AA08948AA' , `pass_man` = 0 , `store_man` = 0 , `qa_man` = 0 , `update_time` = '2024-03-20 14:19:06.518860' [ RunTime:0.000258s ] [2024-03-20T14:19:06+08:00][sql] SELECT * FROM `sell` WHERE `so` = 130 AND `pp` = 296 AND `product` = 6 LIMIT 1 [ RunTime:0.000262s ] [2024-03-20T14:19:06+08:00][sql] INSERT INTO `sell` SET `so` = 130 , `pp` = 296 , `product` = 6 , `count` = 33 , `cust` = 294 , `create_time` = '2024-01-23 12:00:00' , `report_time` = '2024-01-24 00:00:00' , `start_num` = '59170AA08949AA' , `status` = 2 , `end_num` = '59170AA08981AA' , `pass_man` = 0 , `store_man` = 0 , `qa_man` = 0 , `update_time` = '2024-03-20 14:19:06.519887' [ RunTime:0.000188s ] [2024-03-20T14:19:06+08:00][sql] SELECT * FROM `sell` WHERE `so` = 130 AND `pp` = 297 AND `product` = 4 LIMIT 1 [ RunTime:0.000256s ] [2024-03-20T14:19:06+08:00][sql] INSERT INTO `sell` SET `so` = 130 , `pp` = 297 , `product` = 4 , `count` = 70 , `cust` = 294 , `create_time` = '2024-01-23 12:00:00' , `report_time` = '2024-01-24 00:00:00' , `start_num` = '59170AA08982AA' , `status` = 2 , `end_num` = '59170AA09051AA' , `pass_man` = 0 , `store_man` = 0 , `qa_man` = 0 , `update_time` = '2024-03-20 14:19:06.520750' [ RunTime:0.000176s ] [2024-03-20T14:19:06+08:00][sql] SELECT * FROM `sell` WHERE `so` = 130 AND `pp` = 298 AND `product` = 32 LIMIT 1 [ RunTime:0.000254s ] [2024-03-20T14:19:06+08:00][sql] INSERT INTO `sell` SET `so` = 130 , `pp` = 298 , `product` = 32 , `count` = 22 , `cust` = 294 , `create_time` = '2024-01-23 12:00:00' , `report_time` = '2024-01-24 00:00:00' , `start_num` = '59170AA09052AA' , `status` = 2 , `end_num` = '59170AA09073AA' , `pass_man` = 0 , `store_man` = 0 , `qa_man` = 0 , `update_time` = '2024-03-20 14:19:06.521671' [ RunTime:0.000181s ] [2024-03-20T14:19:06+08:00][sql] SELECT * FROM `sell` WHERE `so` = 131 AND `pp` = 299 AND `product` = 6 LIMIT 1 [ RunTime:0.000257s ] [2024-03-20T14:19:06+08:00][sql] INSERT INTO `sell` SET `so` = 131 , `pp` = 299 , `product` = 6 , `count` = 12 , `cust` = 295 , `create_time` = '2024-02-29 12:00:00' , `report_time` = '2024-03-01 00:00:00' , `start_num` = '59170AA09074AA' , `status` = 2 , `end_num` = '59170AA09085AA' , `pass_man` = 0 , `store_man` = 0 , `qa_man` = 0 , `update_time` = '2024-03-20 14:19:06.522598' [ RunTime:0.000233s ] [2024-03-20T14:19:06+08:00][sql] SELECT * FROM `sell` WHERE `so` = 131 AND `pp` = 300 AND `product` = 4 LIMIT 1 [ RunTime:0.000263s ] [2024-03-20T14:19:06+08:00][sql] INSERT INTO `sell` SET `so` = 131 , `pp` = 300 , `product` = 4 , `count` = 9 , `cust` = 295 , `create_time` = '2024-02-29 12:00:00' , `report_time` = '2024-03-01 00:00:00' , `start_num` = '59170AA09086AA' , `status` = 2 , `end_num` = '59170AA09094AA' , `pass_man` = 0 , `store_man` = 0 , `qa_man` = 0 , `update_time` = '2024-03-20 14:19:06.523580' [ RunTime:0.000184s ] [2024-03-20T14:19:06+08:00][sql] SELECT * FROM `sell` WHERE `so` = 131 AND `pp` = 301 AND `product` = 23 LIMIT 1 [ RunTime:0.000284s ] [2024-03-20T14:19:06+08:00][sql] INSERT INTO `sell` SET `so` = 131 , `pp` = 301 , `product` = 23 , `count` = 30 , `cust` = 295 , `create_time` = '2024-02-29 12:00:00' , `report_time` = '2024-03-01 00:00:00' , `start_num` = '59170AA09095AA' , `status` = 2 , `end_num` = '59170AA09124AA' , `pass_man` = 0 , `store_man` = 0 , `qa_man` = 0 , `update_time` = '2024-03-20 14:19:06.524491' [ RunTime:0.000200s ] [2024-03-20T14:19:06+08:00][sql] SELECT * FROM `sell` WHERE `so` = 132 AND `pp` = 302 AND `product` = 13 LIMIT 1 [ RunTime:0.000273s ] [2024-03-20T14:19:06+08:00][sql] INSERT INTO `sell` SET `so` = 132 , `pp` = 302 , `product` = 13 , `count` = 14 , `cust` = 296 , `create_time` = '2024-02-29 12:00:00' , `report_time` = '2024-03-01 00:00:00' , `start_num` = '59170AA09125AA' , `status` = 2 , `end_num` = '59170AA09138AA' , `pass_man` = 0 , `store_man` = 0 , `qa_man` = 0 , `update_time` = '2024-03-20 14:19:06.525370' [ RunTime:0.000192s ] [2024-03-20T14:19:06+08:00][sql] SELECT * FROM `sell` WHERE `so` = 132 AND `pp` = 303 AND `product` = 12 LIMIT 1 [ RunTime:0.000298s ] [2024-03-20T14:19:06+08:00][sql] INSERT INTO `sell` SET `so` = 132 , `pp` = 303 , `product` = 12 , `count` = 6 , `cust` = 296 , `create_time` = '2024-02-29 12:00:00' , `report_time` = '2024-03-01 00:00:00' , `start_num` = '59170AA09139AA' , `status` = 2 , `end_num` = '59170AA09144AA' , `pass_man` = 0 , `store_man` = 0 , `qa_man` = 0 , `update_time` = '2024-03-20 14:19:06.526272' [ RunTime:0.000176s ] [2024-03-20T14:19:06+08:00][sql] SELECT * FROM `sell` WHERE `so` = 132 AND `pp` = 304 AND `product` = 8 LIMIT 1 [ RunTime:0.000255s ] [2024-03-20T14:19:06+08:00][sql] INSERT INTO `sell` SET `so` = 132 , `pp` = 304 , `product` = 8 , `count` = 23 , `cust` = 296 , `create_time` = '2024-02-29 12:00:00' , `report_time` = '2024-03-01 00:00:00' , `start_num` = '59170AA09145AA' , `status` = 2 , `end_num` = '59170AA09167AA' , `pass_man` = 0 , `store_man` = 0 , `qa_man` = 0 , `update_time` = '2024-03-20 14:19:06.527195' [ RunTime:0.000176s ] [2024-03-20T14:19:06+08:00][sql] SELECT * FROM `sell` WHERE `so` = 132 AND `pp` = 305 AND `product` = 6 LIMIT 1 [ RunTime:0.000262s ] [2024-03-20T14:19:06+08:00][sql] INSERT INTO `sell` SET `so` = 132 , `pp` = 305 , `product` = 6 , `count` = 6 , `cust` = 296 , `create_time` = '2024-02-29 12:00:00' , `report_time` = '2024-03-01 00:00:00' , `start_num` = '59170AA09168AA' , `status` = 2 , `end_num` = '59170AA09173AA' , `pass_man` = 0 , `store_man` = 0 , `qa_man` = 0 , `update_time` = '2024-03-20 14:19:06.528083' [ RunTime:0.000174s ] [2024-03-20T14:19:06+08:00][sql] SELECT * FROM `sell` WHERE `so` = 132 AND `pp` = 306 AND `product` = 4 LIMIT 1 [ RunTime:0.000261s ] [2024-03-20T14:19:06+08:00][sql] INSERT INTO `sell` SET `so` = 132 , `pp` = 306 , `product` = 4 , `count` = 18 , `cust` = 296 , `create_time` = '2024-02-29 12:00:00' , `report_time` = '2024-03-01 00:00:00' , `start_num` = '59170AA09174AA' , `status` = 2 , `end_num` = '59170AA09191AA' , `pass_man` = 0 , `store_man` = 0 , `qa_man` = 0 , `update_time` = '2024-03-20 14:19:06.529005' [ RunTime:0.000178s ] [2024-03-20T14:19:06+08:00][sql] SELECT * FROM `sell` WHERE `so` = 133 AND `pp` = 307 AND `product` = 4 LIMIT 1 [ RunTime:0.000260s ] [2024-03-20T14:19:06+08:00][sql] INSERT INTO `sell` SET `so` = 133 , `pp` = 307 , `product` = 4 , `count` = 2 , `cust` = 297 , `create_time` = '2024-02-29 12:00:00' , `report_time` = '2024-03-01 00:00:00' , `start_num` = '59170AA09192AA' , `status` = 2 , `end_num` = '59170AA09193AA' , `pass_man` = 0 , `store_man` = 0 , `qa_man` = 0 , `update_time` = '2024-03-20 14:19:06.529929' [ RunTime:0.000219s ] [2024-03-20T14:19:06+08:00][sql] SELECT * FROM `sell` WHERE `so` = 133 AND `pp` = 308 AND `product` = 6 LIMIT 1 [ RunTime:0.000261s ] [2024-03-20T14:19:06+08:00][sql] INSERT INTO `sell` SET `so` = 133 , `pp` = 308 , `product` = 6 , `count` = 4 , `cust` = 297 , `create_time` = '2024-02-29 12:00:00' , `report_time` = '2024-03-01 00:00:00' , `start_num` = '59170AA09194AA' , `status` = 2 , `end_num` = '59170AA09197AA' , `pass_man` = 0 , `store_man` = 0 , `qa_man` = 0 , `update_time` = '2024-03-20 14:19:06.530855' [ RunTime:0.000257s ] [2024-03-20T14:19:06+08:00][sql] SELECT * FROM `sell` WHERE `so` = 133 AND `pp` = 309 AND `product` = 12 LIMIT 1 [ RunTime:0.000300s ] [2024-03-20T14:19:06+08:00][sql] INSERT INTO `sell` SET `so` = 133 , `pp` = 309 , `product` = 12 , `count` = 28 , `cust` = 297 , `create_time` = '2024-02-29 12:00:00' , `report_time` = '2024-03-01 00:00:00' , `start_num` = '59170AA09198AA' , `status` = 2 , `end_num` = '59170AA09225AA' , `pass_man` = 0 , `store_man` = 0 , `qa_man` = 0 , `update_time` = '2024-03-20 14:19:06.531823' [ RunTime:0.000213s ] [2024-03-20T14:19:06+08:00][sql] SELECT * FROM `sell` WHERE `so` = 133 AND `pp` = 310 AND `product` = 8 LIMIT 1 [ RunTime:0.000269s ] [2024-03-20T14:19:06+08:00][sql] INSERT INTO `sell` SET `so` = 133 , `pp` = 310 , `product` = 8 , `count` = 3 , `cust` = 297 , `create_time` = '2024-02-29 12:00:00' , `report_time` = '2024-03-01 00:00:00' , `start_num` = '59170AA09226AA' , `status` = 2 , `end_num` = '59170AA09228AA' , `pass_man` = 0 , `store_man` = 0 , `qa_man` = 0 , `update_time` = '2024-03-20 14:19:06.532716' [ RunTime:0.000189s ] [2024-03-20T14:19:06+08:00][sql] SELECT * FROM `sell` WHERE `so` = 133 AND `pp` = 311 AND `product` = 13 LIMIT 1 [ RunTime:0.000274s ] [2024-03-20T14:19:06+08:00][sql] INSERT INTO `sell` SET `so` = 133 , `pp` = 311 , `product` = 13 , `count` = 64 , `cust` = 297 , `create_time` = '2024-02-29 12:00:00' , `report_time` = '2024-03-01 00:00:00' , `start_num` = '59170AA09229AA' , `status` = 2 , `end_num` = '59170AA09291AA' , `pass_man` = 0 , `store_man` = 0 , `qa_man` = 0 , `update_time` = '2024-03-20 14:19:06.533603' [ RunTime:0.000175s ] [2024-03-20T14:19:06+08:00][sql] SELECT * FROM `sell` WHERE `so` = 134 AND `pp` = 312 AND `product` = 6 LIMIT 1 [ RunTime:0.000259s ] [2024-03-20T14:19:06+08:00][sql] INSERT INTO `sell` SET `so` = 134 , `pp` = 312 , `product` = 6 , `count` = 12 , `cust` = 298 , `create_time` = '2024-03-02 12:00:00' , `report_time` = '2024-03-03 00:00:00' , `start_num` = '59170AA09292AA' , `status` = 2 , `end_num` = '59170AA09303AA' , `pass_man` = 0 , `store_man` = 0 , `qa_man` = 0 , `update_time` = '2024-03-20 14:19:06.534603' [ RunTime:0.000203s ] [2024-03-20T14:19:06+08:00][sql] SELECT * FROM `sell` WHERE `so` = 134 AND `pp` = 313 AND `product` = 4 LIMIT 1 [ RunTime:0.000259s ] [2024-03-20T14:19:06+08:00][sql] INSERT INTO `sell` SET `so` = 134 , `pp` = 313 , `product` = 4 , `count` = 46 , `cust` = 298 , `create_time` = '2024-03-02 12:00:00' , `report_time` = '2024-03-03 00:00:00' , `start_num` = '59170AA09304AA' , `status` = 2 , `end_num` = '59170AA09349AA' , `pass_man` = 0 , `store_man` = 0 , `qa_man` = 0 , `update_time` = '2024-03-20 14:19:06.535609' [ RunTime:0.000176s ] [2024-03-20T14:19:06+08:00][sql] SELECT * FROM `sell` WHERE `so` = 134 AND `pp` = 314 AND `product` = 10 LIMIT 1 [ RunTime:0.000256s ] [2024-03-20T14:19:06+08:00][sql] INSERT INTO `sell` SET `so` = 134 , `pp` = 314 , `product` = 10 , `count` = 7 , `cust` = 298 , `create_time` = '2024-03-02 12:00:00' , `report_time` = '2024-03-03 00:00:00' , `start_num` = '59170AA09350AA' , `status` = 2 , `end_num` = '59170AA09356AA' , `pass_man` = 0 , `store_man` = 0 , `qa_man` = 0 , `update_time` = '2024-03-20 14:19:06.536541' [ RunTime:0.000173s ] [2024-03-20T14:19:06+08:00][sql] SELECT * FROM `sell` WHERE `so` = 134 AND `pp` = 315 AND `product` = 12 LIMIT 1 [ RunTime:0.000269s ] [2024-03-20T14:19:06+08:00][sql] INSERT INTO `sell` SET `so` = 134 , `pp` = 315 , `product` = 12 , `count` = 452 , `cust` = 298 , `create_time` = '2024-03-02 12:00:00' , `report_time` = '2024-03-03 00:00:00' , `start_num` = '59170AA09357AA' , `status` = 2 , `end_num` = '59170AA09808AA' , `pass_man` = 0 , `store_man` = 0 , `qa_man` = 0 , `update_time` = '2024-03-20 14:19:06.537464' [ RunTime:0.000180s ] [2024-03-20T14:19:06+08:00][sql] SELECT * FROM `sell` WHERE `so` = 134 AND `pp` = 316 AND `product` = 8 LIMIT 1 [ RunTime:0.000274s ] [2024-03-20T14:19:06+08:00][sql] INSERT INTO `sell` SET `so` = 134 , `pp` = 316 , `product` = 8 , `count` = 30 , `cust` = 298 , `create_time` = '2024-03-02 12:00:00' , `report_time` = '2024-03-03 00:00:00' , `start_num` = '59170AA09809AA' , `status` = 2 , `end_num` = '59170AA09838AA' , `pass_man` = 0 , `store_man` = 0 , `qa_man` = 0 , `update_time` = '2024-03-20 14:19:06.538363' [ RunTime:0.000179s ] [2024-03-20T14:19:06+08:00][sql] SELECT * FROM `sell` WHERE `so` = 134 AND `pp` = 317 AND `product` = 10 LIMIT 1 [ RunTime:0.000305s ] [2024-03-20T14:19:06+08:00][sql] INSERT INTO `sell` SET `so` = 134 , `pp` = 317 , `product` = 10 , `count` = 61 , `cust` = 298 , `create_time` = '2024-03-02 12:00:00' , `report_time` = '2024-03-03 00:00:00' , `start_num` = '59170AA09839AA' , `status` = 2 , `end_num` = '59170AA09899AA' , `pass_man` = 0 , `store_man` = 0 , `qa_man` = 0 , `update_time` = '2024-03-20 14:19:06.539271' [ RunTime:0.000181s ] [2024-03-20T14:19:06+08:00][sql] SELECT * FROM `sell` WHERE `so` = 134 AND `pp` = 318 AND `product` = 13 LIMIT 1 [ RunTime:0.000288s ] [2024-03-20T14:19:06+08:00][sql] INSERT INTO `sell` SET `so` = 134 , `pp` = 318 , `product` = 13 , `count` = 53 , `cust` = 298 , `create_time` = '2024-03-02 12:00:00' , `report_time` = '2024-03-03 00:00:00' , `start_num` = '59170AA09900AA' , `status` = 2 , `end_num` = '59170AA09952AA' , `pass_man` = 0 , `store_man` = 0 , `qa_man` = 0 , `update_time` = '2024-03-20 14:19:06.540190' [ RunTime:0.000191s ]