---------------------------------------------------------------
[ 2023-05-23T02:03:54+08:00 ] 39.144.14.29 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055643643
[ sql ] [ DB ] CONNECT:[ UseTime:0.002455s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011640s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000726s ]
---------------------------------------------------------------
[ 2023-05-23T02:03:54+08:00 ] 221.178.124.122 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013
[ sql ] [ DB ] CONNECT:[ UseTime:0.001803s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010898s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000663s ]
---------------------------------------------------------------
[ 2023-05-23T02:04:03+08:00 ] 39.144.14.29 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055643643&date=230523&time=020301&v1=-01.375&v2=+00.020&v3=-00.944&v4=-00.045&v5=05.7&t=+14.8&h=60.1&rssi=+228&ccid=4600485905031420000099m9990000000436000001g3840,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.001598s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010104s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000675s ]
[ sql ] [ SQL ] UPDATE `collect_show`  SET `imei`='868922055643643',`date`='230523',`time`='020301',`v1`=-1.375,`v2`=0.02,`v3`=-0.944,`v4`=-0.045,`v5`=5.7,`t`=14.8,`h`=60.1,`rssi`=228,`ccid`='4600485905031420000099m9990000000436000001g3840,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1684778643  WHERE  `imei` = '868922055643643' [ RunTime:0.000629s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.012563s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `date` , `time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `a1` , `a2` , `create_time` , `update_time`) VALUES ('868922055643643' , '230523' , '020301' , -1.375 , 0.02 , -0.944 , -0.045 , 5.7 , 14.8 , 60.1 , 228 , '4600485905031420000099m9990000000436000001g3840,N,00E000=-00.000' , 0 , 0 , 1684778643 , 1684778643) [ RunTime:0.000656s ]
---------------------------------------------------------------
[ 2023-05-23T02:04:03+08:00 ] 221.178.124.122 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=230523&time=020301&v1=-00.189&v2=+00.001&v3=+00.019&v4=-00.006&v5=05.9&t=+15.3&h=63.1&rssi=+225&ccid=4600485905031430000099m9990000000037000000g2040,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.001523s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011640s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000775s ]
[ sql ] [ SQL ] UPDATE `collect_show`  SET `imei`='868922055644013',`date`='230523',`time`='020301',`v1`=-0.189,`v2`=0.001,`v3`=0.019,`v4`=-0.006,`v5`=5.9,`t`=15.3,`h`=63.1,`rssi`=225,`ccid`='4600485905031430000099m9990000000037000000g2040,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1684778643  WHERE  `imei` = '868922055644013' [ RunTime:0.000546s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009439s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `date` , `time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `a1` , `a2` , `create_time` , `update_time`) VALUES ('868922055644013' , '230523' , '020301' , -0.189 , 0.001 , 0.019 , -0.006 , 5.9 , 15.3 , 63.1 , 225 , '4600485905031430000099m9990000000037000000g2040,N,00E000=-00.000' , 0 , 0 , 1684778643 , 1684778643) [ RunTime:0.000533s ]
---------------------------------------------------------------
[ 2023-05-23T09:27:27+08:00 ] 124.129.96.125 POST /admin/login/login.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.002197s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_manager` [ RunTime:0.037847s ]
[ sql ] [ SQL ] SELECT * FROM `collect_manager` WHERE  `username` = 'admin'  AND `password` = 'b8c6b861afec5f2a9a13ad8f963df1c7' LIMIT 1 [ RunTime:0.000611s ]
---------------------------------------------------------------
[ 2023-05-23T09:27:30+08:00 ] 124.129.96.125 GET /admin/device/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001920s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.011046s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_device` LIMIT 1 [ RunTime:0.000380s ]
[ sql ] [ SQL ] SELECT * FROM `collect_device` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000572s ]
[ sql ] [ SQL ] SELECT * FROM `collect_device` ORDER BY `id` DESC [ RunTime:0.000660s ]
---------------------------------------------------------------
[ 2023-05-23T09:27:33+08:00 ] 124.129.96.125 GET /admin/device/communication/id/11/unique_identification_number/862810047306641.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001664s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.010627s ]
[ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE  `id` = 11 LIMIT 1 [ RunTime:0.000540s ]
---------------------------------------------------------------
[ 2023-05-23T10:05:11+08:00 ] 124.129.96.125 GET /admin/device/communication/id/11/unique_identification_number/862810047306641.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.002890s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.012151s ]
[ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE  `id` = 11 LIMIT 1 [ RunTime:0.000559s ]
---------------------------------------------------------------
[ 2023-05-23T10:05:25+08:00 ] 124.129.96.125 GET /admin/device/communication/id/11/unique_identification_number/862810047306641.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001911s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.019909s ]
[ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE  `id` = 11 LIMIT 1 [ RunTime:0.000582s ]
---------------------------------------------------------------
[ 2023-05-23T10:44:29+08:00 ] 124.129.96.125 GET /admin/user/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.002219s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.012414s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_user` WHERE `collect_user`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.001008s ]
[ sql ] [ SQL ] SELECT * FROM `collect_user` WHERE `collect_user`.`delete_time` IS NULL ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000584s ]
---------------------------------------------------------------
[ 2023-05-23T10:45:22+08:00 ] 124.129.96.125 POST /admin/user/save.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001968s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.012476s ]
[ sql ] [ SQL ] SELECT * FROM `collect_user` WHERE (  `username` = 'na' ) AND `collect_user`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000728s ]
[ sql ] [ SQL ] INSERT INTO `collect_user` (`username` , `password` , `user_type` , `user_phone` , `user_email` , `introduce` , `update_time`) VALUES ('na' , 'ba3c4352a7a9e9c182e1a1ca75b7e844' , 'electric_machinery' , '' , '' , '                        ' , 1684809922) [ RunTime:0.000599s ]
---------------------------------------------------------------
[ 2023-05-23T10:45:23+08:00 ] 124.129.96.125 GET /admin/user/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.002104s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.010581s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_user` WHERE `collect_user`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000483s ]
[ sql ] [ SQL ] SELECT * FROM `collect_user` WHERE `collect_user`.`delete_time` IS NULL ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000607s ]
---------------------------------------------------------------
[ 2023-05-23T10:45:31+08:00 ] 124.129.96.125 GET /admin/show/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001407s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011502s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000374s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.001494s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001013s ]
---------------------------------------------------------------
[ 2023-05-23T10:45:32+08:00 ] 124.129.96.125 GET /admin/device/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001879s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.011636s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_device` LIMIT 1 [ RunTime:0.000380s ]
[ sql ] [ SQL ] SELECT * FROM `collect_device` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000603s ]
[ sql ] [ SQL ] SELECT * FROM `collect_device` ORDER BY `id` DESC [ RunTime:0.000592s ]
---------------------------------------------------------------
[ 2023-05-23T10:45:34+08:00 ] 124.129.96.125 GET /admin/device/edit/id/11/unique_identification_number/862810047306641.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.002115s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.011276s ]
[ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE  `id` = 11 LIMIT 1 [ RunTime:0.000592s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.011096s ]
[ sql ] [ SQL ] SELECT * FROM `collect_user` WHERE `collect_user`.`delete_time` IS NULL [ RunTime:0.000492s ]
---------------------------------------------------------------
[ 2023-05-23T10:45:40+08:00 ] 124.129.96.125 POST /admin/device/update.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001940s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.010947s ]
[ sql ] [ SQL ] UPDATE `collect_device`  SET `username`='na',`field1`='字段1',`field2`='字段2',`field3`='字段3',`field4`='字段4',`field5`='字段5',`introduce`='                                                '  WHERE  `id` = 11 [ RunTime:0.000668s ]
---------------------------------------------------------------
[ 2023-05-23T10:45:41+08:00 ] 124.129.96.125 GET /admin/device/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.003913s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.009741s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_device` LIMIT 1 [ RunTime:0.000324s ]
[ sql ] [ SQL ] SELECT * FROM `collect_device` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000621s ]
[ sql ] [ SQL ] SELECT * FROM `collect_device` ORDER BY `id` DESC [ RunTime:0.000629s ]
---------------------------------------------------------------
[ 2023-05-23T10:46:01+08:00 ] 124.129.96.125 POST /home/login/login.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001668s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.010401s ]
[ sql ] [ SQL ] SELECT * FROM `collect_user` WHERE  `username` = 'na'  AND `password` = 'ba3c4352a7a9e9c182e1a1ca75b7e844' LIMIT 1 [ RunTime:0.000647s ]
---------------------------------------------------------------
[ 2023-05-23T10:46:02+08:00 ] 124.129.96.125 GET /home/device/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001855s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.010624s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_device` WHERE  `username` = 'na' LIMIT 1 [ RunTime:0.000523s ]
[ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE  `username` = 'na' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000551s ]
[ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE  `username` = 'na' ORDER BY `id` DESC [ RunTime:0.000586s ]
---------------------------------------------------------------
[ 2023-05-23T10:46:05+08:00 ] 124.129.96.125 GET /home/device/communication/id/11/unique_identification_number/862810047306641.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001613s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.010402s ]
[ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE  `id` = 11 LIMIT 1 [ RunTime:0.000571s ]
---------------------------------------------------------------
[ 2023-05-23T10:46:16+08:00 ] 124.129.96.125 GET /admin/device/communication/id/11/unique_identification_number/862810047306641.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001538s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.011176s ]
[ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE  `id` = 11 LIMIT 1 [ RunTime:0.000859s ]
---------------------------------------------------------------
[ 2023-05-23T10:47:31+08:00 ] 124.129.96.125 POST /home/login/login.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001371s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.010051s ]
[ sql ] [ SQL ] SELECT * FROM `collect_user` WHERE  `username` = 'na'  AND `password` = 'ba3c4352a7a9e9c182e1a1ca75b7e844' LIMIT 1 [ RunTime:0.000586s ]
---------------------------------------------------------------
[ 2023-05-23T10:47:32+08:00 ] 124.129.96.125 GET /home/device/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001732s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.010451s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_device` WHERE  `username` = 'na' LIMIT 1 [ RunTime:0.000450s ]
[ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE  `username` = 'na' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000526s ]
[ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE  `username` = 'na' ORDER BY `id` DESC [ RunTime:0.000564s ]
---------------------------------------------------------------
[ 2023-05-23T10:47:36+08:00 ] 124.129.96.125 GET /home/device/communication/id/11/unique_identification_number/862810047306641.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001612s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.010552s ]
[ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE  `id` = 11 LIMIT 1 [ RunTime:0.000564s ]
---------------------------------------------------------------
[ 2023-05-23T11:12:27+08:00 ] 39.144.4.81 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055678110
[ sql ] [ DB ] CONNECT:[ UseTime:0.002452s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.013069s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055678110' LIMIT 1 [ RunTime:0.000795s ]
---------------------------------------------------------------
[ 2023-05-23T11:12:29+08:00 ] 39.144.4.81 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055678110&create_time=1684811547&v1=0.029408&v2=0.014603&v3=0.027482&v4=0.001174&v5=12.240000&t=22.906034&h=78.640503&rssi=30&ccid=898604650119C1078513&imsi=460048590708513&v6=-00.000&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.001940s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.014615s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055678110' LIMIT 1 [ RunTime:0.000683s ]
[ sql ] [ SQL ] UPDATE `collect_show`  SET `imei`='868922055678110',`create_time`=1684811547,`v1`=0.029408,`v2`=0.014603,`v3`=0.027482,`v4`=0.001174,`v5`=12.24,`t`=22.906034,`h`=78.640503,`rssi`=30,`ccid`='898604650119C1078513',`imsi`='460048590708513',`v6`=-0,`update_time`=1684811549  WHERE  `imei` = '868922055678110' [ RunTime:0.000673s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.013856s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055678110' , 1684811547 , 0.029408 , 0.014603 , 0.027482 , 0.001174 , 12.24 , 22.906034 , 78.640503 , 30 , '898604650119C1078513' , '460048590708513' , -0 , 1684811549) [ RunTime:0.001329s ]
---------------------------------------------------------------
[ 2023-05-23T13:30:27+08:00 ] 124.129.96.125 POST /home/login/login.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.002433s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.012540s ]
[ sql ] [ SQL ] SELECT * FROM `collect_user` WHERE  `username` = 'na'  AND `password` = 'ba3c4352a7a9e9c182e1a1ca75b7e844' LIMIT 1 [ RunTime:0.000632s ]
---------------------------------------------------------------
[ 2023-05-23T13:30:28+08:00 ] 124.129.96.125 GET /home/device/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001759s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.011200s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_device` WHERE  `username` = 'na' LIMIT 1 [ RunTime:0.000501s ]
[ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE  `username` = 'na' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000575s ]
[ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE  `username` = 'na' ORDER BY `id` DESC [ RunTime:0.000524s ]
---------------------------------------------------------------
[ 2023-05-23T13:30:31+08:00 ] 124.129.96.125 GET /home/device/communication/id/11/unique_identification_number/862810047306641.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.002423s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.012346s ]
[ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE  `id` = 11 LIMIT 1 [ RunTime:0.000823s ]
---------------------------------------------------------------
[ 2023-05-23T13:43:55+08:00 ] 124.129.96.125 GET /home/device/communication/id/11/unique_identification_number/862810047306641.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.002243s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.011199s ]
[ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE  `id` = 11 LIMIT 1 [ RunTime:0.000637s ]
---------------------------------------------------------------
[ 2023-05-23T13:44:35+08:00 ] 124.129.96.125 GET /home/device/communication/id/11/unique_identification_number/862810047306641.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001474s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.012893s ]
[ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE  `id` = 11 LIMIT 1 [ RunTime:0.000653s ]
---------------------------------------------------------------
[ 2023-05-23T13:45:24+08:00 ] 124.129.96.125 GET /home/device/communication/id/11/unique_identification_number/862810047306641.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001695s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.010789s ]
[ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE  `id` = 11 LIMIT 1 [ RunTime:0.001498s ]
---------------------------------------------------------------
[ 2023-05-23T14:03:55+08:00 ] 39.144.7.139 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055643643
[ sql ] [ DB ] CONNECT:[ UseTime:0.002927s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011148s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000863s ]
---------------------------------------------------------------
[ 2023-05-23T14:03:55+08:00 ] 223.104.255.107 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013
[ sql ] [ DB ] CONNECT:[ UseTime:0.010871s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010784s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000714s ]
---------------------------------------------------------------
[ 2023-05-23T14:04:03+08:00 ] 39.144.7.139 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055643643&date=230523&time=140301&v1=-01.371&v2=+00.027&v3=-00.945&v4=-00.044&v5=06.2&t=+33.2&h=55.4&rssi=+230&ccid=4600485905031420000099m9990000000429000001g3780,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.003723s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010685s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000675s ]
[ sql ] [ SQL ] UPDATE `collect_show`  SET `imei`='868922055643643',`date`='230523',`time`='140301',`v1`=-1.371,`v2`=0.027,`v3`=-0.945,`v4`=-0.044,`v5`=6.2,`t`=33.2,`h`=55.4,`rssi`=230,`ccid`='4600485905031420000099m9990000000429000001g3780,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1684821843  WHERE  `imei` = '868922055643643' [ RunTime:0.000645s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010533s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `date` , `time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `a1` , `a2` , `create_time` , `update_time`) VALUES ('868922055643643' , '230523' , '140301' , -1.371 , 0.027 , -0.945 , -0.044 , 6.2 , 33.2 , 55.4 , 230 , '4600485905031420000099m9990000000429000001g3780,N,00E000=-00.000' , 0 , 0 , 1684821843 , 1684821843) [ RunTime:0.000831s ]
---------------------------------------------------------------
[ 2023-05-23T14:04:03+08:00 ] 223.104.255.107 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=230523&time=140301&v1=-00.283&v2=+00.001&v3=+00.021&v4=-00.003&v5=06.0&t=+33.3&h=59.5&rssi=+227&ccid=4600485905031430000099m9990000000043000000g3020,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.002231s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009391s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000639s ]
[ sql ] [ SQL ] UPDATE `collect_show`  SET `imei`='868922055644013',`date`='230523',`time`='140301',`v1`=-0.283,`v2`=0.001,`v3`=0.021,`v4`=-0.003,`v5`=6,`t`=33.3,`h`=59.5,`rssi`=227,`ccid`='4600485905031430000099m9990000000043000000g3020,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1684821843  WHERE  `imei` = '868922055644013' [ RunTime:0.000546s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009742s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `date` , `time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `a1` , `a2` , `create_time` , `update_time`) VALUES ('868922055644013' , '230523' , '140301' , -0.283 , 0.001 , 0.021 , -0.003 , 6 , 33.3 , 59.5 , 227 , '4600485905031430000099m9990000000043000000g3020,N,00E000=-00.000' , 0 , 0 , 1684821843 , 1684821843) [ RunTime:0.000545s ]
---------------------------------------------------------------
[ 2023-05-23T14:11:15+08:00 ] 124.129.96.125 POST /admin/login/login.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.002407s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_manager` [ RunTime:0.011239s ]
[ sql ] [ SQL ] SELECT * FROM `collect_manager` WHERE  `username` = 'admin'  AND `password` = 'b8c6b861afec5f2a9a13ad8f963df1c7' LIMIT 1 [ RunTime:0.000563s ]
---------------------------------------------------------------
[ 2023-05-23T14:11:21+08:00 ] 124.129.96.125 GET /admin/show/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001913s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011058s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000368s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000842s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000973s ]
---------------------------------------------------------------
[ 2023-05-23T14:11:47+08:00 ] 124.129.96.125 GET /admin/show/index.html?page=2
[ sql ] [ DB ] CONNECT:[ UseTime:0.001918s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010817s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000436s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 10,10 [ RunTime:0.001136s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001160s ]
---------------------------------------------------------------
[ 2023-05-23T14:12:13+08:00 ] 124.129.96.125 GET /admin/show/index.html?page=3
[ sql ] [ DB ] CONNECT:[ UseTime:0.002210s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.013251s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000408s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 20,10 [ RunTime:0.001570s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001070s ]
---------------------------------------------------------------
[ 2023-05-23T14:39:23+08:00 ] 39.144.18.87 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684548
[ sql ] [ DB ] CONNECT:[ UseTime:0.002720s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012045s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055684548' LIMIT 1 [ RunTime:0.000692s ]
---------------------------------------------------------------
[ 2023-05-23T14:39:25+08:00 ] 39.144.18.87 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055684548&create_time=1684823963&v1=0.016766&v2=0.013039&v3=0.013997&v4=-0.011769&v5=12.420000&t=23.678242&h=76.969666&rssi=28&ccid=898604650119C1053137&imsi=460048590503137&v6=-00.000&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.001908s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010853s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055684548' LIMIT 1 [ RunTime:0.000771s ]
[ sql ] [ SQL ] UPDATE `collect_show`  SET `imei`='868922055684548',`create_time`=1684823963,`v1`=0.016766,`v2`=0.013039,`v3`=0.013997,`v4`=-0.011769,`v5`=12.42,`t`=23.678242,`h`=76.969666,`rssi`=28,`ccid`='898604650119C1053137',`imsi`='460048590503137',`v6`=-0,`update_time`=1684823965  WHERE  `imei` = '868922055684548' [ RunTime:0.000739s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.012527s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055684548' , 1684823963 , 0.016766 , 0.013039 , 0.013997 , -0.011769 , 12.42 , 23.678242 , 76.969666 , 28 , '898604650119C1053137' , '460048590503137' , -0 , 1684823965) [ RunTime:0.000727s ]
---------------------------------------------------------------
[ 2023-05-23T15:41:10+08:00 ] 124.129.96.125 GET /home/device/communication/id/11/unique_identification_number/862810047306641.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.002148s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.010851s ]
[ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE  `id` = 11 LIMIT 1 [ RunTime:0.000588s ]
---------------------------------------------------------------
[ 2023-05-23T15:41:28+08:00 ] 124.129.96.125 GET /home/device/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001896s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.010164s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_device` WHERE  `username` = 'na' LIMIT 1 [ RunTime:0.000543s ]
[ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE  `username` = 'na' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000628s ]
[ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE  `username` = 'na' ORDER BY `id` DESC [ RunTime:0.000597s ]
---------------------------------------------------------------
[ 2023-05-23T15:41:30+08:00 ] 124.129.96.125 GET /home/device/communication/id/11/unique_identification_number/862810047306641.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001970s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.011773s ]
[ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE  `id` = 11 LIMIT 1 [ RunTime:0.000551s ]
---------------------------------------------------------------
[ 2023-05-23T15:45:33+08:00 ] 124.129.96.125 GET /home/device/communication/id/11/unique_identification_number/862810047306641.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001511s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.011695s ]
[ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE  `id` = 11 LIMIT 1 [ RunTime:0.000731s ]
---------------------------------------------------------------
[ 2023-05-23T15:47:10+08:00 ] 124.129.96.125 GET /home/device/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001474s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.009946s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_device` WHERE  `username` = 'na' LIMIT 1 [ RunTime:0.000486s ]
[ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE  `username` = 'na' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000556s ]
[ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE  `username` = 'na' ORDER BY `id` DESC [ RunTime:0.000546s ]
---------------------------------------------------------------
[ 2023-05-23T15:49:10+08:00 ] 124.129.96.125 GET /home/device/communication/id/11/unique_identification_number/862810047306641.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.002222s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.010085s ]
[ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE  `id` = 11 LIMIT 1 [ RunTime:0.000597s ]
---------------------------------------------------------------
[ 2023-05-23T15:50:11+08:00 ] 124.129.96.125 GET /
[ sql ] [ DB ] CONNECT:[ UseTime:0.001958s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.013518s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE  `username` = 'na' LIMIT 1 [ RunTime:0.000505s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `username` = 'na' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000629s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `username` = 'na' ORDER BY `id` DESC [ RunTime:0.000639s ]
---------------------------------------------------------------
[ 2023-05-23T15:50:29+08:00 ] 124.129.96.125 POST /admin/login/login.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001495s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_manager` [ RunTime:0.010397s ]
[ sql ] [ SQL ] SELECT * FROM `collect_manager` WHERE  `username` = 'admin'  AND `password` = 'b8c6b861afec5f2a9a13ad8f963df1c7' LIMIT 1 [ RunTime:0.000673s ]
---------------------------------------------------------------
[ 2023-05-23T15:50:33+08:00 ] 124.129.96.125 GET /admin/device/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001790s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.009661s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_device` LIMIT 1 [ RunTime:0.000915s ]
[ sql ] [ SQL ] SELECT * FROM `collect_device` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000604s ]
[ sql ] [ SQL ] SELECT * FROM `collect_device` ORDER BY `id` DESC [ RunTime:0.000608s ]
---------------------------------------------------------------
[ 2023-05-23T15:50:34+08:00 ] 124.129.96.125 GET /admin/device/communication/id/11/unique_identification_number/862810047306641.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001791s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.010144s ]
[ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE  `id` = 11 LIMIT 1 [ RunTime:0.000567s ]
---------------------------------------------------------------
[ 2023-05-23T15:52:54+08:00 ] 124.129.96.125 GET /home/device/communication/id/11/unique_identification_number/862810047306641.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001636s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.009878s ]
[ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE  `id` = 11 LIMIT 1 [ RunTime:0.000580s ]
---------------------------------------------------------------
[ 2023-05-23T16:25:02+08:00 ] 124.129.96.125 GET /home/device/communication/id/11/unique_identification_number/862810047306641.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.002287s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.011236s ]
[ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE  `id` = 11 LIMIT 1 [ RunTime:0.000603s ]
---------------------------------------------------------------
[ 2023-05-23T16:36:33+08:00 ] 124.129.96.125 GET /home/device/communication/id/11/unique_identification_number/862810047306641.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.002209s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.009360s ]
[ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE  `id` = 11 LIMIT 1 [ RunTime:0.000552s ]
---------------------------------------------------------------
[ 2023-05-23T16:36:55+08:00 ] 124.129.96.125 GET /home/device/communication/id/11/unique_identification_number/862810047306641.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.002005s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.009742s ]
[ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE  `id` = 11 LIMIT 1 [ RunTime:0.000539s ]
---------------------------------------------------------------
[ 2023-05-23T16:40:51+08:00 ] 124.129.96.125 GET /home/device/communication/id/11/unique_identification_number/862810047306641.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001637s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.009693s ]
[ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE  `id` = 11 LIMIT 1 [ RunTime:0.000634s ]
---------------------------------------------------------------
[ 2023-05-23T16:41:42+08:00 ] 124.129.96.125 GET /home/device/communication/id/11/unique_identification_number/862810047306641.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001481s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.010206s ]
[ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE  `id` = 11 LIMIT 1 [ RunTime:0.000581s ]
---------------------------------------------------------------
[ 2023-05-23T16:42:19+08:00 ] 124.129.96.125 GET /home/device/communication/id/11/unique_identification_number/862810047306641.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001902s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.008793s ]
[ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE  `id` = 11 LIMIT 1 [ RunTime:0.000530s ]
---------------------------------------------------------------
[ 2023-05-23T16:54:04+08:00 ] 39.144.18.172 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055647586
[ sql ] [ DB ] CONNECT:[ UseTime:0.002508s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010374s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055647586' LIMIT 1 [ RunTime:0.000691s ]
---------------------------------------------------------------
[ 2023-05-23T16:54:05+08:00 ] 39.144.18.172 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055647586&create_time=1684832044&v1=0.018572&v2=0.014186&v3=0.015682&v4=-0.000331&v5=12.240000&t=24.289574&h=79.754395&rssi=29&ccid=898604650119C1078512&imsi=460048590708512&v6=-00.000&gps=120.184293,35.985858&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.002269s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011210s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055647586' LIMIT 1 [ RunTime:0.000670s ]
[ sql ] [ SQL ] UPDATE `collect_show`  SET `imei`='868922055647586',`create_time`=1684832044,`v1`=0.018572,`v2`=0.014186,`v3`=0.015682,`v4`=-0.000331,`v5`=12.24,`t`=24.289574,`h`=79.754395,`rssi`=29,`ccid`='898604650119C1078512',`imsi`='460048590708512',`v6`=-0,`gps`='120.184293,35.985858',`update_time`=1684832045  WHERE  `imei` = '868922055647586' [ RunTime:0.000650s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010600s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `gps` , `update_time`) VALUES ('868922055647586' , 1684832044 , 0.018572 , 0.014186 , 0.015682 , -0.000331 , 12.24 , 24.289574 , 79.754395 , 29 , '898604650119C1078512' , '460048590708512' , -0 , '120.184293,35.985858' , 1684832045) [ RunTime:0.000677s ]
---------------------------------------------------------------
[ 2023-05-23T17:34:03+08:00 ] 218.204.252.71 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922056976208
[ sql ] [ DB ] CONNECT:[ UseTime:0.002715s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.016094s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922056976208' LIMIT 1 [ RunTime:0.000768s ]
---------------------------------------------------------------
[ 2023-05-23T17:34:04+08:00 ] 218.204.252.71 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922056976208&create_time=1684834443&v1=0.027722&v2=0.013143&v3=0.026157&v4=0.015803&v5=12.240000&t=24.107246&h=77.343506&rssi=26&ccid=898604650119C1053139&imsi=460048590503139&v6=-00.000&gps=120.185204,35.985465&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.001746s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010698s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922056976208' LIMIT 1 [ RunTime:0.000742s ]
[ sql ] [ SQL ] UPDATE `collect_show`  SET `imei`='868922056976208',`create_time`=1684834443,`v1`=0.027722,`v2`=0.013143,`v3`=0.026157,`v4`=0.015803,`v5`=12.24,`t`=24.107246,`h`=77.343506,`rssi`=26,`ccid`='898604650119C1053139',`imsi`='460048590503139',`v6`=-0,`gps`='120.185204,35.985465',`update_time`=1684834444  WHERE  `imei` = '868922056976208' [ RunTime:0.000751s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009840s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `gps` , `update_time`) VALUES ('868922056976208' , 1684834443 , 0.027722 , 0.013143 , 0.026157 , 0.015803 , 12.24 , 24.107246 , 77.343506 , 26 , '898604650119C1053139' , '460048590503139' , -0 , '120.185204,35.985465' , 1684834444) [ RunTime:0.000900s ]
---------------------------------------------------------------
[ 2023-05-23T17:39:21+08:00 ] 223.104.255.213 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684209
[ sql ] [ DB ] CONNECT:[ UseTime:0.002666s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011158s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055684209' LIMIT 1 [ RunTime:0.000768s ]
---------------------------------------------------------------
[ 2023-05-23T17:39:22+08:00 ] 223.104.255.213 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055684209&create_time=1684834761&v1=0.019656&v2=0.013456&v3=0.016676&v4=-0.006833&v5=12.420000&t=24.193047&h=79.220337&rssi=27&ccid=898604650119C1078511&imsi=460048590708511&v6=-00.000&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.001763s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010668s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055684209' LIMIT 1 [ RunTime:0.000667s ]
[ sql ] [ SQL ] UPDATE `collect_show`  SET `imei`='868922055684209',`create_time`=1684834761,`v1`=0.019656,`v2`=0.013456,`v3`=0.016676,`v4`=-0.006833,`v5`=12.42,`t`=24.193047,`h`=79.220337,`rssi`=27,`ccid`='898604650119C1078511',`imsi`='460048590708511',`v6`=-0,`update_time`=1684834762  WHERE  `imei` = '868922055684209' [ RunTime:0.000575s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010830s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055684209' , 1684834761 , 0.019656 , 0.013456 , 0.016676 , -0.006833 , 12.42 , 24.193047 , 79.220337 , 27 , '898604650119C1078511' , '460048590708511' , -0 , 1684834762) [ RunTime:0.000516s ]
---------------------------------------------------------------
[ 2023-05-23T17:42:26+08:00 ] 124.129.96.125 GET /home/device/communication/id/11/unique_identification_number/862810047306641.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001615s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.010503s ]
[ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE  `id` = 11 LIMIT 1 [ RunTime:0.000631s ]
---------------------------------------------------------------
[ 2023-05-23T18:04:21+08:00 ] 39.144.4.86 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055683920
[ sql ] [ DB ] CONNECT:[ UseTime:0.003266s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011943s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055683920' LIMIT 1 [ RunTime:0.000799s ]
---------------------------------------------------------------
[ 2023-05-23T18:04:22+08:00 ] 39.144.4.86 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055683920&create_time=1684836261&v1=0.018813&v2=0.015125&v3=0.016043&v4=-0.004666&v5=12.420000&t=23.914194&h=81.669373&rssi=26&ccid=89860426102071188500&imsi=460044618415250&v6=-00.000&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.002132s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.008615s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055683920' LIMIT 1 [ RunTime:0.000645s ]
[ sql ] [ SQL ] UPDATE `collect_show`  SET `imei`='868922055683920',`create_time`=1684836261,`v1`=0.018813,`v2`=0.015125,`v3`=0.016043,`v4`=-0.004666,`v5`=12.42,`t`=23.914194,`h`=81.669373,`rssi`=26,`ccid`='89860426102071188500',`imsi`='460044618415250',`v6`=-0,`update_time`=1684836262  WHERE  `imei` = '868922055683920' [ RunTime:0.000582s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.008930s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055683920' , 1684836261 , 0.018813 , 0.015125 , 0.016043 , -0.004666 , 12.42 , 23.914194 , 81.669373 , 26 , '89860426102071188500' , '460044618415250' , -0 , 1684836262) [ RunTime:0.000627s ]
---------------------------------------------------------------
[ 2023-05-23T18:10:50+08:00 ] 39.144.3.118 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684076
[ sql ] [ DB ] CONNECT:[ UseTime:0.003425s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012237s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000728s ]
---------------------------------------------------------------
[ 2023-05-23T18:10:59+08:00 ] 39.144.3.118 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055684076&date=230523&time=181001&v1=-00.249&v2=+00.007&v3=-00.161&v4=+00.309&v5=06.0&t=+28.3&h=79.4&rssi=+228&imsi=460044618415249&v6=-00.000&a1=00.156&a2=00.384&a3=00.000&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.001958s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009903s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000682s ]
[ sql ] [ SQL ] UPDATE `collect_show`  SET `imei`='868922055684076',`date`='230523',`time`='181001',`v1`=-0.249,`v2`=0.007,`v3`=-0.161,`v4`=0.309,`v5`=6,`t`=28.3,`h`=79.4,`rssi`=228,`imsi`='460044618415249',`v6`=-0,`a1`=0.156,`a2`=0.384,`update_time`=1684836659  WHERE  `imei` = '868922055684076' [ RunTime:0.000549s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010198s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `date` , `time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `imsi` , `v6` , `a1` , `a2` , `create_time` , `update_time`) VALUES ('868922055684076' , '230523' , '181001' , -0.249 , 0.007 , -0.161 , 0.309 , 6 , 28.3 , 79.4 , 228 , '460044618415249' , -0 , 0.156 , 0.384 , 1684836659 , 1684836659) [ RunTime:0.000541s ]
---------------------------------------------------------------
[ 2023-05-23T19:32:02+08:00 ] 124.129.96.125 POST /admin/login/login.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.002634s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_manager` [ RunTime:0.012614s ]
[ sql ] [ SQL ] SELECT * FROM `collect_manager` WHERE  `username` = 'admin'  AND `password` = 'b8c6b861afec5f2a9a13ad8f963df1c7' LIMIT 1 [ RunTime:0.000604s ]
---------------------------------------------------------------
[ 2023-05-23T19:32:05+08:00 ] 124.129.96.125 GET /admin/show/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001542s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012020s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000445s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.001573s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001048s ]
---------------------------------------------------------------
[ 2023-05-23T19:32:09+08:00 ] 124.129.96.125 GET /admin/device/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001724s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.009177s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_device` LIMIT 1 [ RunTime:0.000392s ]
[ sql ] [ SQL ] SELECT * FROM `collect_device` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000614s ]
[ sql ] [ SQL ] SELECT * FROM `collect_device` ORDER BY `id` DESC [ RunTime:0.000928s ]
---------------------------------------------------------------
[ 2023-05-23T19:32:11+08:00 ] 124.129.96.125 GET /admin/device/communication/id/11/unique_identification_number/862810047306641.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001923s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.010705s ]
[ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE  `id` = 11 LIMIT 1 [ RunTime:0.000592s ]
---------------------------------------------------------------
[ 2023-05-23T20:51:03+08:00 ] 218.204.252.243 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055683912
[ sql ] [ DB ] CONNECT:[ UseTime:0.002178s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011208s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055683912' LIMIT 1 [ RunTime:0.000728s ]
---------------------------------------------------------------
[ 2023-05-23T20:51:05+08:00 ] 218.204.252.243 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055683912&create_time=1684846263&v1=0.031876&v2=0.014395&v3=0.028686&v4=0.008217&v5=12.600000&t=23.731867&h=80.410522&rssi=27&ccid=898604650119C1053138&imsi=460048590503138&v6=-00.000&gps=120.186072,35.985564&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.001708s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012210s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055683912' LIMIT 1 [ RunTime:0.001094s ]
[ sql ] [ SQL ] UPDATE `collect_show`  SET `imei`='868922055683912',`create_time`=1684846263,`v1`=0.031876,`v2`=0.014395,`v3`=0.028686,`v4`=0.008217,`v5`=12.6,`t`=23.731867,`h`=80.410522,`rssi`=27,`ccid`='898604650119C1053138',`imsi`='460048590503138',`v6`=-0,`gps`='120.186072,35.985564',`update_time`=1684846264  WHERE  `imei` = '868922055683912' [ RunTime:0.001025s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.013649s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `gps` , `update_time`) VALUES ('868922055683912' , 1684846263 , 0.031876 , 0.014395 , 0.028686 , 0.008217 , 12.6 , 23.731867 , 80.410522 , 27 , '898604650119C1053138' , '460048590503138' , -0 , '120.186072,35.985564' , 1684846265) [ RunTime:0.001419s ]
---------------------------------------------------------------
[ 2023-05-23T20:55:57+08:00 ] 39.144.7.193 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055683771
[ sql ] [ DB ] CONNECT:[ UseTime:0.002184s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010252s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055683771' LIMIT 1 [ RunTime:0.000674s ]
---------------------------------------------------------------
[ 2023-05-23T20:55:59+08:00 ] 39.144.7.193 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055683771&create_time=1684846557&v1=0.019234&v2=0.013560&v3=0.015863&v4=-0.017187&v5=12.420000&t=23.774769&h=81.242126&rssi=27&ccid=898604650119C1053136&imsi=460048590503136&v6=-00.000&gps=120.184910,35.985706&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.001758s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010526s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055683771' LIMIT 1 [ RunTime:0.000667s ]
[ sql ] [ SQL ] UPDATE `collect_show`  SET `imei`='868922055683771',`create_time`=1684846557,`v1`=0.019234,`v2`=0.01356,`v3`=0.015863,`v4`=-0.017187,`v5`=12.42,`t`=23.774769,`h`=81.242126,`rssi`=27,`ccid`='898604650119C1053136',`imsi`='460048590503136',`v6`=-0,`gps`='120.184910,35.985706',`update_time`=1684846559  WHERE  `imei` = '868922055683771' [ RunTime:0.000557s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010107s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `gps` , `update_time`) VALUES ('868922055683771' , 1684846557 , 0.019234 , 0.01356 , 0.015863 , -0.017187 , 12.42 , 23.774769 , 81.242126 , 27 , '898604650119C1053136' , '460048590503136' , -0 , '120.184910,35.985706' , 1684846559) [ RunTime:0.000511s ]
---------------------------------------------------------------
[ 2023-05-23T23:34:24+08:00 ] 39.144.15.124 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644021
[ sql ] [ DB ] CONNECT:[ UseTime:0.002354s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.021428s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055644021' LIMIT 1 [ RunTime:0.000785s ]
---------------------------------------------------------------
[ 2023-05-23T23:34:25+08:00 ] 39.144.15.124 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055644021&create_time=1684856064&v1=0.007134&v2=0.013873&v3=0.004846&v4=-0.015923&v5=12.420000&t=23.646067&h=79.807800&rssi=10&ccid=898604650119C1053141&imsi=460048590503141&v6=-00.000&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.002016s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010101s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055644021' LIMIT 1 [ RunTime:0.000722s ]
[ sql ] [ SQL ] UPDATE `collect_show`  SET `imei`='868922055644021',`create_time`=1684856064,`v1`=0.007134,`v2`=0.013873,`v3`=0.004846,`v4`=-0.015923,`v5`=12.42,`t`=23.646067,`h`=79.8078,`rssi`=10,`ccid`='898604650119C1053141',`imsi`='460048590503141',`v6`=-0,`update_time`=1684856065  WHERE  `imei` = '868922055644021' [ RunTime:0.000637s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011647s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055644021' , 1684856064 , 0.007134 , 0.013873 , 0.004846 , -0.015923 , 12.42 , 23.646067 , 79.8078 , 10 , '898604650119C1053141' , '460048590503141' , -0 , 1684856065) [ RunTime:0.000908s ]
---------------------------------------------------------------
[ 2023-05-23T23:55:24+08:00 ] 111.55.138.97 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055680850
[ sql ] [ DB ] CONNECT:[ UseTime:0.002342s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010601s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055680850' LIMIT 1 [ RunTime:0.000743s ]
---------------------------------------------------------------
[ 2023-05-23T23:55:25+08:00 ] 111.55.138.97 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055680850&create_time=1684857324&v1=0.021401&v2=0.013143&v3=0.018271&v4=-0.006171&v5=12.240000&t=23.560266&h=78.861755&rssi=26&ccid=898604650119C1078510&imsi=460048590708510&v6=-00.000&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.001682s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010784s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055680850' LIMIT 1 [ RunTime:0.000654s ]
[ sql ] [ SQL ] UPDATE `collect_show`  SET `imei`='868922055680850',`create_time`=1684857324,`v1`=0.021401,`v2`=0.013143,`v3`=0.018271,`v4`=-0.006171,`v5`=12.24,`t`=23.560266,`h`=78.861755,`rssi`=26,`ccid`='898604650119C1078510',`imsi`='460048590708510',`v6`=-0,`update_time`=1684857325  WHERE  `imei` = '868922055680850' [ RunTime:0.000628s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011459s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055680850' , 1684857324 , 0.021401 , 0.013143 , 0.018271 , -0.006171 , 12.24 , 23.560266 , 78.861755 , 26 , '898604650119C1078510' , '460048590708510' , -0 , 1684857325) [ RunTime:0.001418s ]