---------------------------------------------------------------
[ 2023-03-21T02:03:54+08:00 ] 221.178.124.2 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055643643
[ sql ] [ DB ] CONNECT:[ UseTime:0.003069s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012537s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.001317s ]
---------------------------------------------------------------
[ 2023-03-21T02:03:55+08:00 ] 39.144.15.179 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013
[ sql ] [ DB ] CONNECT:[ UseTime:0.002300s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010431s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000863s ]
---------------------------------------------------------------
[ 2023-03-21T02:04:03+08:00 ] 221.178.124.2 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055643643&date=230321&time=020301&v1=-01.289&v2=+00.024&v3=-00.954&v4=-00.024&v5=05.7&t=+05.6&h=62.3&rssi=+230&ccid=4600485905031420000099m9990000000327000001g3000,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.001719s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009809s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000663s ]
[ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055643643',`date`='230321',`time`='020301',`v1`=-1.289,`v2`=0.024,`v3`=-0.954,`v4`=-0.024,`v5`=5.7,`t`=5.6,`h`=62.3,`rssi`=230,`ccid`='4600485905031420000099m9990000000327000001g3000,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1679335443 WHERE `imei` = '868922055643643' [ RunTime:0.000741s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.015653s ]
[ 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' , '230321' , '020301' , -1.289 , 0.024 , -0.954 , -0.024 , 5.7 , 5.6 , 62.3 , 230 , '4600485905031420000099m9990000000327000001g3000,N,00E000=-00.000' , 0 , 0 , 1679335443 , 1679335443) [ RunTime:0.001305s ]
---------------------------------------------------------------
[ 2023-03-21T02:04:04+08:00 ] 39.144.15.179 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=230321&time=020301&v1=-00.192&v2=+00.001&v3=-00.063&v4=-00.019&v5=05.7&t=+06.5&h=65.0&rssi=+225&ccid=4600485905031430000099m9990000000030000000g2120,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.002155s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010642s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000684s ]
[ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644013',`date`='230321',`time`='020301',`v1`=-0.192,`v2`=0.001,`v3`=-0.063,`v4`=-0.019,`v5`=5.7,`t`=6.5,`h`=65,`rssi`=225,`ccid`='4600485905031430000099m9990000000030000000g2120,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1679335444 WHERE `imei` = '868922055644013' [ RunTime:0.001286s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.008996s ]
[ 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' , '230321' , '020301' , -0.192 , 0.001 , -0.063 , -0.019 , 5.7 , 6.5 , 65 , 225 , '4600485905031430000099m9990000000030000000g2120,N,00E000=-00.000' , 0 , 0 , 1679335444 , 1679335444) [ RunTime:0.000528s ]
---------------------------------------------------------------
[ 2023-03-21T02:32:26+08:00 ] 39.144.18.215 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922056976109
[ sql ] [ DB ] CONNECT:[ UseTime:0.002983s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.015019s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922056976109' LIMIT 1 [ RunTime:0.000921s ]
---------------------------------------------------------------
[ 2023-03-21T02:32:27+08:00 ] 39.144.18.215 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922056976109&create_time=1679337146&v1=0.028144&v2=0.576928&v3=0.028686&v4=0.028084&v5=12.420000&t=13.081845&h=42.149109&rssi=31&ccid=898604650119C1078513&imsi=460048590708513&v6=-00.000&end=
[ sql ] [ DB ] CONNECT:[ UseTime:0.001762s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010582s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922056976109' LIMIT 1 [ RunTime:0.000678s ]
[ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922056976109',`create_time`=1679337146,`v1`=0.028144,`v2`=0.576928,`v3`=0.028686,`v4`=0.028084,`v5`=12.42,`t`=13.081845,`h`=42.149109,`rssi`=31,`ccid`='898604650119C1078513',`imsi`='460048590708513',`v6`=-0,`update_time`=1679337147 WHERE `imei` = '868922056976109' [ RunTime:0.000694s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.008827s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922056976109' , 1679337146 , 0.028144 , 0.576928 , 0.028686 , 0.028084 , 12.42 , 13.081845 , 42.149109 , 31 , '898604650119C1078513' , '460048590708513' , -0 , 1679337147) [ RunTime:0.000634s ]
---------------------------------------------------------------
[ 2023-03-21T06:03:50+08:00 ] 39.144.11.172 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684076
[ sql ] [ DB ] CONNECT:[ UseTime:0.002659s ] 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` = '868922055684076' LIMIT 1 [ RunTime:0.000778s ]
---------------------------------------------------------------
[ 2023-03-21T06:03:59+08:00 ] 39.144.11.172 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055684076&date=230321&time=060301&v1=-01.277&v2=+00.021&v3=-00.975&v4=-00.628&v5=05.7&t=+08.1&h=80.9&rssi=+228&imsi=460044618415249&v6=-00.000&a1=00.325&a2=01.292&a3=00.000&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.001584s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010504s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000687s ]
[ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684076',`date`='230321',`time`='060301',`v1`=-1.277,`v2`=0.021,`v3`=-0.975,`v4`=-0.628,`v5`=5.7,`t`=8.1,`h`=80.9,`rssi`=228,`imsi`='460044618415249',`v6`=-0,`a1`=0.325,`a2`=1.292,`update_time`=1679349839 WHERE `imei` = '868922055684076' [ RunTime:0.000606s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011114s ]
[ 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' , '230321' , '060301' , -1.277 , 0.021 , -0.975 , -0.628 , 5.7 , 8.1 , 80.9 , 228 , '460044618415249' , -0 , 0.325 , 1.292 , 1679349839 , 1679349839) [ RunTime:0.000632s ]
---------------------------------------------------------------
[ 2023-03-21T08:51:41+08:00 ] 27.210.192.79 POST /admin/login/login.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.002446s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_manager` [ RunTime:0.013532s ]
[ sql ] [ SQL ] SELECT * FROM `collect_manager` WHERE `username` = 'admin' AND `password` = 'b8c6b861afec5f2a9a13ad8f963df1c7' LIMIT 1 [ RunTime:0.000645s ]
---------------------------------------------------------------
[ 2023-03-21T08:51:44+08:00 ] 27.210.192.79 GET /admin/show/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001470s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011461s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000330s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000775s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000935s ]
---------------------------------------------------------------
[ 2023-03-21T08:51:47+08:00 ] 27.210.192.79 GET /admin/show/index.html?page=3
[ sql ] [ DB ] CONNECT:[ UseTime:0.002194s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009938s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000396s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 20,10 [ RunTime:0.000937s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000915s ]
---------------------------------------------------------------
[ 2023-03-21T08:51:50+08:00 ] 27.210.192.79 GET /admin/show/read/id/22/imei/868922055677740.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001937s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010739s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 22 LIMIT 1 [ RunTime:0.000826s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010724s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.001027s ]
[ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055677740' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.017167s ]
---------------------------------------------------------------
[ 2023-03-21T08:51:52+08:00 ] 27.210.192.79 GET /admin/show/index.html?page=3
[ sql ] [ DB ] CONNECT:[ UseTime:0.001968s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011202s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000381s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 20,10 [ RunTime:0.000921s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000956s ]
---------------------------------------------------------------
[ 2023-03-21T08:51:54+08:00 ] 27.210.192.79 GET /admin/show/edit/id/22.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001839s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011382s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 22 LIMIT 1 [ RunTime:0.000695s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.013413s ]
[ sql ] [ SQL ] SELECT * FROM `collect_user` WHERE `collect_user`.`delete_time` IS NULL [ RunTime:0.001065s ]
---------------------------------------------------------------
[ 2023-03-21T08:52:29+08:00 ] 27.210.192.79 POST /admin/show/update.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001458s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010901s ]
[ sql ] [ SQL ] UPDATE `collect_show` SET `device_name`='STM32',`interval`=1440,`gps`='120.168792,36.023056',`username`='user1',`introduce`='<p>stm32f103c8t6</p><p>2022.10.21安装在å˜ç”µç«™é«˜åŽ‹çº¿æ—</p>',`update_time`=1679359949 WHERE `id` = 22 [ RunTime:0.000731s ]
---------------------------------------------------------------
[ 2023-03-21T08:52:30+08:00 ] 27.210.192.79 GET /admin/show/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001853s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010883s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000380s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.001055s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001061s ]
---------------------------------------------------------------
[ 2023-03-21T08:52:31+08:00 ] 27.210.192.79 GET /admin/map/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001892s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009969s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001105s ]
---------------------------------------------------------------
[ 2023-03-21T09:03:10+08:00 ] 27.210.192.79 GET /admin/show/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.002053s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009307s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000404s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000797s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001020s ]
---------------------------------------------------------------
[ 2023-03-21T09:03:11+08:00 ] 27.210.192.79 GET /admin/show/edit/id/22.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001591s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011079s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 22 LIMIT 1 [ RunTime:0.000624s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.008758s ]
[ sql ] [ SQL ] SELECT * FROM `collect_user` WHERE `collect_user`.`delete_time` IS NULL [ RunTime:0.000470s ]
---------------------------------------------------------------
[ 2023-03-21T09:03:39+08:00 ] 27.210.192.79 POST /admin/show/update.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001467s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009618s ]
[ sql ] [ SQL ] UPDATE `collect_show` SET `device_name`='STM32',`interval`=1440,`gps`='120.10943075811658,36.01656835848008',`username`='user1',`introduce`='<p>stm32f103c8t6</p><p>2022.10.21安装在å˜ç”µç«™é«˜åŽ‹çº¿æ—</p>',`update_time`=1679360619 WHERE `id` = 22 [ RunTime:0.000606s ]
---------------------------------------------------------------
[ 2023-03-21T09:03:40+08:00 ] 27.210.192.79 GET /admin/show/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001671s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009529s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000327s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000739s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000902s ]
---------------------------------------------------------------
[ 2023-03-21T09:03:42+08:00 ] 27.210.192.79 GET /admin/map/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001663s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010623s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001039s ]
---------------------------------------------------------------
[ 2023-03-21T09:31:27+08:00 ] 27.210.192.79 GET /admin/map/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.002306s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011860s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001059s ]
---------------------------------------------------------------
[ 2023-03-21T12:58:58+08:00 ] 39.144.9.216 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055677740
[ sql ] [ DB ] CONNECT:[ UseTime:0.002304s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012353s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000762s ]
---------------------------------------------------------------
[ 2023-03-21T12:59:00+08:00 ] 39.144.9.216 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055677740&create_time=1679374738&v1=0.006953&v2=11.544093&v3=0.007194&v4=0.007254&v5=12.960000&t=17.457581&h=51.701153&rssi=16&ccid=89860426102071188504&imsi=460044618415254&v6=-00.000&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.002511s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.013957s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000771s ]
[ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055677740',`create_time`=1679374738,`v1`=0.006953,`v2`=11.544093,`v3`=0.007194,`v4`=0.007254,`v5`=12.96,`t`=17.457581,`h`=51.701153,`rssi`=16,`ccid`='89860426102071188504',`imsi`='460044618415254',`v6`=-0,`update_time`=1679374740 WHERE `imei` = '868922055677740' [ RunTime:0.000691s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.012258s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055677740' , 1679374738 , 0.006953 , 11.544093 , 0.007194 , 0.007254 , 12.96 , 17.457581 , 51.701153 , 16 , '89860426102071188504' , '460044618415254' , -0 , 1679374740) [ RunTime:0.000716s ]
---------------------------------------------------------------
[ 2023-03-21T12:59:02+08:00 ] 39.144.9.216 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055677740&create_time=1420041608&v1=0.007375&v2=11.513948&v3=0.006411&v4=0.007856&v5=13.140000&t=21.586735&h=37.899567&rssi=16&ccid=89860426102071188504&imsi=460044618415254&v6=-00.000&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.001651s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009728s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000706s ]
[ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055677740',`create_time`=1420041608,`v1`=0.007375,`v2`=11.513948,`v3`=0.006411,`v4`=0.007856,`v5`=13.14,`t`=21.586735,`h`=37.899567,`rssi`=16,`ccid`='89860426102071188504',`imsi`='460044618415254',`v6`=-0,`update_time`=1679374742 WHERE `imei` = '868922055677740' [ RunTime:0.000571s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011624s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055677740' , 1420041608 , 0.007375 , 11.513948 , 0.006411 , 0.007856 , 13.14 , 21.586735 , 37.899567 , 16 , '89860426102071188504' , '460044618415254' , -0 , 1679374742) [ RunTime:0.000552s ]
---------------------------------------------------------------
[ 2023-03-21T12:59:04+08:00 ] 39.144.9.216 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055677740&create_time=1420041627&v1=0.007435&v2=10.816023&v3=0.007043&v4=0.007254&v5=13.140000&t=22.348217&h=37.510468&rssi=16&ccid=89860426102071188504&imsi=460044618415254&v6=-00.000&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.001938s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010035s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000692s ]
[ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055677740',`create_time`=1420041627,`v1`=0.007435,`v2`=10.816023,`v3`=0.007043,`v4`=0.007254,`v5`=13.14,`t`=22.348217,`h`=37.510468,`rssi`=16,`ccid`='89860426102071188504',`imsi`='460044618415254',`v6`=-0,`update_time`=1679374744 WHERE `imei` = '868922055677740' [ RunTime:0.000551s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011078s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055677740' , 1420041627 , 0.007435 , 10.816023 , 0.007043 , 0.007254 , 13.14 , 22.348217 , 37.510468 , 16 , '89860426102071188504' , '460044618415254' , -0 , 1679374744) [ RunTime:0.000509s ]
---------------------------------------------------------------
[ 2023-03-21T12:59:06+08:00 ] 39.144.9.216 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055677740&create_time=1420041627&v1=0.007375&v2=11.149391&v3=0.007224&v4=0.007555&v5=13.140000&t=20.782354&h=37.685944&rssi=16&ccid=89860426102071188504&imsi=460044618415254&v6=-00.000&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.001569s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010426s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000642s ]
[ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055677740',`create_time`=1420041627,`v1`=0.007375,`v2`=11.149391,`v3`=0.007224,`v4`=0.007555,`v5`=13.14,`t`=20.782354,`h`=37.685944,`rssi`=16,`ccid`='89860426102071188504',`imsi`='460044618415254',`v6`=-0,`update_time`=1679374746 WHERE `imei` = '868922055677740' [ RunTime:0.000506s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.008818s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055677740' , 1420041627 , 0.007375 , 11.149391 , 0.007224 , 0.007555 , 13.14 , 20.782354 , 37.685944 , 16 , '89860426102071188504' , '460044618415254' , -0 , 1679374746) [ RunTime:0.000480s ]
---------------------------------------------------------------
[ 2023-03-21T12:59:09+08:00 ] 39.144.9.216 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055677740&create_time=1420041628&v1=0.007314&v2=9.792551&v3=0.007555&v4=0.007736&v5=13.140000&t=21.533110&h=35.435272&rssi=16&ccid=89860426102071188504&imsi=460044618415254&v6=-00.000&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.001810s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010696s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000651s ]
[ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055677740',`create_time`=1420041628,`v1`=0.007314,`v2`=9.792551,`v3`=0.007555,`v4`=0.007736,`v5`=13.14,`t`=21.53311,`h`=35.435272,`rssi`=16,`ccid`='89860426102071188504',`imsi`='460044618415254',`v6`=-0,`update_time`=1679374749 WHERE `imei` = '868922055677740' [ RunTime:0.000546s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010184s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055677740' , 1420041628 , 0.007314 , 9.792551 , 0.007555 , 0.007736 , 13.14 , 21.53311 , 35.435272 , 16 , '89860426102071188504' , '460044618415254' , -0 , 1679374749) [ RunTime:0.000499s ]
---------------------------------------------------------------
[ 2023-03-21T12:59:11+08:00 ] 39.144.9.216 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055677740&create_time=1420041686&v1=0.007495&v2=9.652361&v3=0.007555&v4=0.007615&v5=13.140000&t=22.423292&h=34.641815&rssi=16&ccid=89860426102071188504&imsi=460044618415254&v6=-00.000&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.001665s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010599s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000681s ]
[ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055677740',`create_time`=1420041686,`v1`=0.007495,`v2`=9.652361,`v3`=0.007555,`v4`=0.007615,`v5`=13.14,`t`=22.423292,`h`=34.641815,`rssi`=16,`ccid`='89860426102071188504',`imsi`='460044618415254',`v6`=-0,`update_time`=1679374751 WHERE `imei` = '868922055677740' [ RunTime:0.000519s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011401s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055677740' , 1420041686 , 0.007495 , 9.652361 , 0.007555 , 0.007615 , 13.14 , 22.423292 , 34.641815 , 16 , '89860426102071188504' , '460044618415254' , -0 , 1679374751) [ RunTime:0.000488s ]
---------------------------------------------------------------
[ 2023-03-21T12:59:13+08:00 ] 39.144.9.216 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055677740&create_time=1420041628&v1=0.007435&v2=9.081900&v3=0.007585&v4=0.007676&v5=13.320000&t=21.082657&h=37.182404&rssi=16&ccid=89860426102071188504&imsi=460044618415254&v6=-00.000&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.002009s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009988s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000688s ]
[ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055677740',`create_time`=1420041628,`v1`=0.007435,`v2`=9.0819,`v3`=0.007585,`v4`=0.007676,`v5`=13.32,`t`=21.082657,`h`=37.182404,`rssi`=16,`ccid`='89860426102071188504',`imsi`='460044618415254',`v6`=-0,`update_time`=1679374753 WHERE `imei` = '868922055677740' [ RunTime:0.000570s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.013185s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055677740' , 1420041628 , 0.007435 , 9.0819 , 0.007585 , 0.007676 , 13.32 , 21.082657 , 37.182404 , 16 , '89860426102071188504' , '460044618415254' , -0 , 1679374753) [ RunTime:0.000512s ]
---------------------------------------------------------------
[ 2023-03-21T12:59:16+08:00 ] 39.144.9.216 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055677740&create_time=1420041634&v1=0.007013&v2=9.949743&v3=0.007043&v4=0.007375&v5=13.140000&t=17.865133&h=50.861919&rssi=16&ccid=89860426102071188504&imsi=460044618415254&v6=-00.000&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.001589s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009211s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000671s ]
[ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055677740',`create_time`=1420041634,`v1`=0.007013,`v2`=9.949743,`v3`=0.007043,`v4`=0.007375,`v5`=13.14,`t`=17.865133,`h`=50.861919,`rssi`=16,`ccid`='89860426102071188504',`imsi`='460044618415254',`v6`=-0,`update_time`=1679374756 WHERE `imei` = '868922055677740' [ RunTime:0.000520s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009630s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055677740' , 1420041634 , 0.007013 , 9.949743 , 0.007043 , 0.007375 , 13.14 , 17.865133 , 50.861919 , 16 , '89860426102071188504' , '460044618415254' , -0 , 1679374756) [ RunTime:0.000482s ]
---------------------------------------------------------------
[ 2023-03-21T14:03:55+08:00 ] 117.132.193.129 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013
[ sql ] [ DB ] CONNECT:[ UseTime:0.002873s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012691s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.001040s ]
---------------------------------------------------------------
[ 2023-03-21T14:03:55+08:00 ] 111.55.137.54 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055643643
[ sql ] [ DB ] CONNECT:[ UseTime:0.001771s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009085s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000692s ]
---------------------------------------------------------------
[ 2023-03-21T14:04:03+08:00 ] 117.132.193.129 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=230321&time=140301&v1=-00.184&v2=+00.002&v3=+00.010&v4=-00.019&v5=05.9&t=+14.9&h=63.4&rssi=+223&ccid=4600485905031430000099m9990000000032000000g2150,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.001719s ] 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` = '868922055644013' LIMIT 1 [ RunTime:0.000702s ]
[ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644013',`date`='230321',`time`='140301',`v1`=-0.184,`v2`=0.002,`v3`=0.01,`v4`=-0.019,`v5`=5.9,`t`=14.9,`h`=63.4,`rssi`=223,`ccid`='4600485905031430000099m9990000000032000000g2150,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1679378643 WHERE `imei` = '868922055644013' [ RunTime:0.000671s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.012351s ]
[ 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' , '230321' , '140301' , -0.184 , 0.002 , 0.01 , -0.019 , 5.9 , 14.9 , 63.4 , 223 , '4600485905031430000099m9990000000032000000g2150,N,00E000=-00.000' , 0 , 0 , 1679378643 , 1679378643) [ RunTime:0.000706s ]
---------------------------------------------------------------
[ 2023-03-21T14:04:03+08:00 ] 111.55.137.54 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055643643&date=230321&time=140301&v1=-01.291&v2=+00.061&v3=-00.946&v4=-00.022&v5=05.7&t=+16.5&h=60.5&rssi=+222&ccid=4600485905031420000099m9990000000337000001g3010,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.001779s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011191s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000666s ]
[ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055643643',`date`='230321',`time`='140301',`v1`=-1.291,`v2`=0.061,`v3`=-0.946,`v4`=-0.022,`v5`=5.7,`t`=16.5,`h`=60.5,`rssi`=222,`ccid`='4600485905031420000099m9990000000337000001g3010,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1679378643 WHERE `imei` = '868922055643643' [ RunTime:0.000537s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010049s ]
[ 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' , '230321' , '140301' , -1.291 , 0.061 , -0.946 , -0.022 , 5.7 , 16.5 , 60.5 , 222 , '4600485905031420000099m9990000000337000001g3010,N,00E000=-00.000' , 0 , 0 , 1679378643 , 1679378643) [ RunTime:0.000645s ]
---------------------------------------------------------------
[ 2023-03-21T14:32:23+08:00 ] 221.178.125.229 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922056976109
[ sql ] [ DB ] CONNECT:[ UseTime:0.002573s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.013872s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922056976109' LIMIT 1 [ RunTime:0.000711s ]
---------------------------------------------------------------
[ 2023-03-21T14:32:24+08:00 ] 221.178.125.229 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922056976109&create_time=1679380343&v1=0.028084&v2=0.994578&v3=0.028896&v4=0.028084&v5=12.420000&t=16.106323&h=42.217773&rssi=31&ccid=898604650119C1078513&imsi=460048590708513&v6=-00.000&end=
[ sql ] [ DB ] CONNECT:[ UseTime:0.001975s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010423s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922056976109' LIMIT 1 [ RunTime:0.000726s ]
[ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922056976109',`create_time`=1679380343,`v1`=0.028084,`v2`=0.994578,`v3`=0.028896,`v4`=0.028084,`v5`=12.42,`t`=16.106323,`h`=42.217773,`rssi`=31,`ccid`='898604650119C1078513',`imsi`='460048590708513',`v6`=-0,`update_time`=1679380344 WHERE `imei` = '868922056976109' [ RunTime:0.000688s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011995s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922056976109' , 1679380343 , 0.028084 , 0.994578 , 0.028896 , 0.028084 , 12.42 , 16.106323 , 42.217773 , 31 , '898604650119C1078513' , '460048590708513' , -0 , 1679380344) [ RunTime:0.000759s ]
---------------------------------------------------------------
[ 2023-03-21T22:17:55+08:00 ] 39.88.175.12 POST /admin/login/login.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.002925s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_manager` [ RunTime:0.011838s ]
[ sql ] [ SQL ] SELECT * FROM `collect_manager` WHERE `username` = 'admin' AND `password` = 'b8c6b861afec5f2a9a13ad8f963df1c7' LIMIT 1 [ RunTime:0.001058s ]
---------------------------------------------------------------
[ 2023-03-21T22:18:11+08:00 ] 39.88.175.12 GET /admin/show/index.html
[ 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.013686s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000447s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000831s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000955s ]
---------------------------------------------------------------
[ 2023-03-21T22:18:13+08:00 ] 39.88.175.12 GET /admin/map/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001725s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011392s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001227s ]