--------------------------------------------------------------- [ 2023-04-08T02:03:55+08:00 ] 111.55.141.72 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055643643 [ sql ] [ DB ] CONNECT:[ UseTime:0.002748s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011180s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000678s ] --------------------------------------------------------------- [ 2023-04-08T02:03:55+08:00 ] 39.144.16.157 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013 [ sql ] [ DB ] CONNECT:[ UseTime:0.001628s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.008960s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000713s ] --------------------------------------------------------------- [ 2023-04-08T02:04:03+08:00 ] 111.55.141.72 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055643643&date=230408&time=020301&v1=-01.342&v2=+00.018&v3=-00.967&v4=-00.021&v5=05.7&t=+05.8&h=62.0&rssi=+229&ccid=4600485905031420000099m9990000000384000001g3530,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001817s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010842s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000633s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055643643',`date`='230408',`time`='020301',`v1`=-1.342,`v2`=0.018,`v3`=-0.967,`v4`=-0.021,`v5`=5.7,`t`=5.8,`h`=62,`rssi`=229,`ccid`='4600485905031420000099m9990000000384000001g3530,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1680890643 WHERE `imei` = '868922055643643' [ RunTime:0.000632s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009857s ] [ 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' , '230408' , '020301' , -1.342 , 0.018 , -0.967 , -0.021 , 5.7 , 5.8 , 62 , 229 , '4600485905031420000099m9990000000384000001g3530,N,00E000=-00.000' , 0 , 0 , 1680890643 , 1680890643) [ RunTime:0.000600s ] --------------------------------------------------------------- [ 2023-04-08T02:04:04+08:00 ] 39.144.16.157 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=230408&time=020301&v1=+00.229&v2=+00.001&v3=+00.482&v4=+00.177&v5=05.7&t=+06.3&h=64.7&rssi=+225&ccid=4600485905031430000099m9990000000286000000g1330,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002169s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009875s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000658s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644013',`date`='230408',`time`='020301',`v1`=0.229,`v2`=0.001,`v3`=0.482,`v4`=0.177,`v5`=5.7,`t`=6.3,`h`=64.7,`rssi`=225,`ccid`='4600485905031430000099m9990000000286000000g1330,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1680890644 WHERE `imei` = '868922055644013' [ RunTime:0.000522s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011311s ] [ 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' , '230408' , '020301' , 0.229 , 0.001 , 0.482 , 0.177 , 5.7 , 6.3 , 64.7 , 225 , '4600485905031430000099m9990000000286000000g1330,N,00E000=-00.000' , 0 , 0 , 1680890644 , 1680890644) [ RunTime:0.000807s ] --------------------------------------------------------------- [ 2023-04-08T09:03:35+08:00 ] 117.132.198.56 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055677740 [ sql ] [ DB ] CONNECT:[ UseTime:0.003185s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.014257s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.001794s ] --------------------------------------------------------------- [ 2023-04-08T09:03:36+08:00 ] 117.132.198.56 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055677740&create_time=1680915814&v1=0.007615&v2=1.001149&v3=0.007856&v4=0.008217&v5=12.960000&t=25.029486&h=39.135529&rssi=23&ccid=89860426102071188504&imsi=460044618415254&v6=-00.000&gps=120.185646,35.985177&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001604s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009465s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000687s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055677740',`create_time`=1680915814,`v1`=0.007615,`v2`=1.001149,`v3`=0.007856,`v4`=0.008217,`v5`=12.96,`t`=25.029486,`h`=39.135529,`rssi`=23,`ccid`='89860426102071188504',`imsi`='460044618415254',`v6`=-0,`gps`='120.185646,35.985177',`update_time`=1680915816 WHERE `imei` = '868922055677740' [ RunTime:0.000660s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011364s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `gps` , `update_time`) VALUES ('868922055677740' , 1680915814 , 0.007615 , 1.001149 , 0.007856 , 0.008217 , 12.96 , 25.029486 , 39.135529 , 23 , '89860426102071188504' , '460044618415254' , -0 , '120.185646,35.985177' , 1680915816) [ RunTime:0.001189s ] --------------------------------------------------------------- [ 2023-04-08T09:05:33+08:00 ] 124.129.66.161 POST /admin/login/login.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001729s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_manager` [ RunTime:0.011800s ] [ sql ] [ SQL ] SELECT * FROM `collect_manager` WHERE `username` = 'admin' AND `password` = 'b8c6b861afec5f2a9a13ad8f963df1c7' LIMIT 1 [ RunTime:0.000639s ] --------------------------------------------------------------- [ 2023-04-08T09:05:37+08:00 ] 124.129.66.161 GET /admin/show/index.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_show` [ RunTime:0.013569s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000537s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.001678s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001377s ] --------------------------------------------------------------- [ 2023-04-08T09:05:38+08:00 ] 124.129.66.161 GET /admin/map/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001616s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010757s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001024s ] --------------------------------------------------------------- [ 2023-04-08T09:06:35+08:00 ] 221.178.127.43 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055677740 [ sql ] [ DB ] CONNECT:[ UseTime:0.001581s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011537s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000725s ] --------------------------------------------------------------- [ 2023-04-08T09:06:36+08:00 ] 221.178.127.43 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055677740&create_time=1680915995&v1=0.007977&v2=0.906229&v3=0.008217&v4=0.008398&v5=12.960000&t=28.836889&h=33.039639&rssi=22&ccid=89860426102071188504&imsi=460044618415254&v6=-00.000&gps=0.006500,0.006000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002051s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010702s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000812s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055677740',`create_time`=1680915995,`v1`=0.007977,`v2`=0.906229,`v3`=0.008217,`v4`=0.008398,`v5`=12.96,`t`=28.836889,`h`=33.039639,`rssi`=22,`ccid`='89860426102071188504',`imsi`='460044618415254',`v6`=-0,`gps`='0.006500,0.006000',`update_time`=1680915996 WHERE `imei` = '868922055677740' [ RunTime:0.000586s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011547s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `gps` , `update_time`) VALUES ('868922055677740' , 1680915995 , 0.007977 , 0.906229 , 0.008217 , 0.008398 , 12.96 , 28.836889 , 33.039639 , 22 , '89860426102071188504' , '460044618415254' , -0 , '0.006500,0.006000' , 1680915996) [ RunTime:0.000539s ] --------------------------------------------------------------- [ 2023-04-08T09:09:05+08:00 ] 39.144.12.141 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055677740 [ sql ] [ DB ] CONNECT:[ UseTime:0.002563s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010946s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000682s ] --------------------------------------------------------------- [ 2023-04-08T09:09:06+08:00 ] 39.144.12.141 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055677740&create_time=1680916145&v1=0.008157&v2=0.926882&v3=0.008278&v4=0.008398&v5=12.960000&t=29.930847&h=31.345913&rssi=23&ccid=89860426102071188504&imsi=460044618415254&v6=-00.000&gps=0.006500,0.006000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002007s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009140s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000659s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055677740',`create_time`=1680916145,`v1`=0.008157,`v2`=0.926882,`v3`=0.008278,`v4`=0.008398,`v5`=12.96,`t`=29.930847,`h`=31.345913,`rssi`=23,`ccid`='89860426102071188504',`imsi`='460044618415254',`v6`=-0,`gps`='0.006500,0.006000',`update_time`=1680916146 WHERE `imei` = '868922055677740' [ RunTime:0.000506s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010798s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `gps` , `update_time`) VALUES ('868922055677740' , 1680916145 , 0.008157 , 0.926882 , 0.008278 , 0.008398 , 12.96 , 29.930847 , 31.345913 , 23 , '89860426102071188504' , '460044618415254' , -0 , '0.006500,0.006000' , 1680916146) [ RunTime:0.000494s ] --------------------------------------------------------------- [ 2023-04-08T09:10:53+08:00 ] 39.144.14.201 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055677740 [ sql ] [ DB ] CONNECT:[ UseTime:0.002130s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011438s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.001015s ] --------------------------------------------------------------- [ 2023-04-08T09:10:54+08:00 ] 39.144.14.201 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055677740&create_time=1680916253&v1=0.008278&v2=1.154691&v3=0.008428&v4=0.008338&v5=13.140000&t=29.941572&h=31.506130&rssi=22&ccid=89860426102071188504&imsi=460044618415254&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001748s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010383s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000641s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055677740',`create_time`=1680916253,`v1`=0.008278,`v2`=1.154691,`v3`=0.008428,`v4`=0.008338,`v5`=13.14,`t`=29.941572,`h`=31.50613,`rssi`=22,`ccid`='89860426102071188504',`imsi`='460044618415254',`v6`=-0,`update_time`=1680916254 WHERE `imei` = '868922055677740' [ RunTime:0.000519s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009502s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055677740' , 1680916253 , 0.008278 , 1.154691 , 0.008428 , 0.008338 , 13.14 , 29.941572 , 31.50613 , 22 , '89860426102071188504' , '460044618415254' , -0 , 1680916254) [ RunTime:0.000594s ] --------------------------------------------------------------- [ 2023-04-08T09:11:52+08:00 ] 218.204.253.222 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055677740 [ sql ] [ DB ] CONNECT:[ UseTime:0.001954s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009831s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000653s ] --------------------------------------------------------------- [ 2023-04-08T09:11:54+08:00 ] 218.204.253.222 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055677740&create_time=1680916312&v1=0.008338&v2=1.667783&v3=0.008428&v4=0.008338&v5=12.960000&t=30.338400&h=31.345913&rssi=22&ccid=89860426102071188504&imsi=460044618415254&v6=-00.000&gps=120.185896,35.987260&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001805s ] 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` = '868922055677740' LIMIT 1 [ RunTime:0.000682s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055677740',`create_time`=1680916312,`v1`=0.008338,`v2`=1.667783,`v3`=0.008428,`v4`=0.008338,`v5`=12.96,`t`=30.3384,`h`=31.345913,`rssi`=22,`ccid`='89860426102071188504',`imsi`='460044618415254',`v6`=-0,`gps`='120.185896,35.987260',`update_time`=1680916314 WHERE `imei` = '868922055677740' [ RunTime:0.000523s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010044s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `gps` , `update_time`) VALUES ('868922055677740' , 1680916312 , 0.008338 , 1.667783 , 0.008428 , 0.008338 , 12.96 , 30.3384 , 31.345913 , 22 , '89860426102071188504' , '460044618415254' , -0 , '120.185896,35.987260' , 1680916314) [ RunTime:0.000645s ] --------------------------------------------------------------- [ 2023-04-08T09:12:56+08:00 ] 124.129.66.161 GET /admin/map/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001390s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009915s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001208s ] --------------------------------------------------------------- [ 2023-04-08T09:20:38+08:00 ] 39.144.7.130 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055677740 [ sql ] [ DB ] CONNECT:[ UseTime:0.002393s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012268s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000699s ] --------------------------------------------------------------- [ 2023-04-08T09:20:40+08:00 ] 39.144.7.130 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055677740&create_time=1680916838&v1=0.007254&v2=0.584334&v3=0.007525&v4=0.007676&v5=13.140000&t=22.165890&h=45.582375&rssi=25&ccid=89860426102071188504&imsi=460044618415254&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001983s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011465s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000678s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055677740',`create_time`=1680916838,`v1`=0.007254,`v2`=0.584334,`v3`=0.007525,`v4`=0.007676,`v5`=13.14,`t`=22.16589,`h`=45.582375,`rssi`=25,`ccid`='89860426102071188504',`imsi`='460044618415254',`v6`=-0,`update_time`=1680916840 WHERE `imei` = '868922055677740' [ RunTime:0.000610s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.018199s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055677740' , 1680916838 , 0.007254 , 0.584334 , 0.007525 , 0.007676 , 13.14 , 22.16589 , 45.582375 , 25 , '89860426102071188504' , '460044618415254' , -0 , 1680916840) [ RunTime:0.000593s ] --------------------------------------------------------------- [ 2023-04-08T09:24:43+08:00 ] 39.144.8.244 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055677740 [ sql ] [ DB ] CONNECT:[ UseTime:0.002737s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011754s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000666s ] --------------------------------------------------------------- [ 2023-04-08T09:24:45+08:00 ] 39.144.8.244 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055677740&create_time=1680917083&v1=0.007375&v2=0.455409&v3=0.007525&v4=0.007736&v5=13.140000&t=21.618910&h=44.064121&rssi=25&ccid=89860426102071188504&imsi=460044618415254&v6=-00.000&gps=120.185031,35.984997&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002334s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009776s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000663s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055677740',`create_time`=1680917083,`v1`=0.007375,`v2`=0.455409,`v3`=0.007525,`v4`=0.007736,`v5`=13.14,`t`=21.61891,`h`=44.064121,`rssi`=25,`ccid`='89860426102071188504',`imsi`='460044618415254',`v6`=-0,`gps`='120.185031,35.984997',`update_time`=1680917085 WHERE `imei` = '868922055677740' [ RunTime:0.000537s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010323s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `gps` , `update_time`) VALUES ('868922055677740' , 1680917083 , 0.007375 , 0.455409 , 0.007525 , 0.007736 , 13.14 , 21.61891 , 44.064121 , 25 , '89860426102071188504' , '460044618415254' , -0 , '120.185031,35.984997' , 1680917085) [ RunTime:0.000507s ] --------------------------------------------------------------- [ 2023-04-08T09:25:07+08:00 ] 124.129.66.161 GET /admin/map/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001408s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010701s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001036s ] --------------------------------------------------------------- [ 2023-04-08T09:27:21+08:00 ] 39.144.16.113 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055677740 [ sql ] [ DB ] CONNECT:[ UseTime:0.002369s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010393s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000624s ] --------------------------------------------------------------- [ 2023-04-08T09:27:23+08:00 ] 39.144.16.113 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055677740&create_time=1680917241&v1=0.007555&v2=0.477210&v3=0.007615&v4=0.007796&v5=13.140000&t=22.101540&h=41.348057&rssi=26&ccid=89860426102071188504&imsi=460044618415254&v6=-00.000&gps=120.184898,35.984971&end=$ [ 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.011705s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000742s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055677740',`create_time`=1680917241,`v1`=0.007555,`v2`=0.47721,`v3`=0.007615,`v4`=0.007796,`v5`=13.14,`t`=22.10154,`h`=41.348057,`rssi`=26,`ccid`='89860426102071188504',`imsi`='460044618415254',`v6`=-0,`gps`='120.184898,35.984971',`update_time`=1680917243 WHERE `imei` = '868922055677740' [ RunTime:0.000607s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010640s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `gps` , `update_time`) VALUES ('868922055677740' , 1680917241 , 0.007555 , 0.47721 , 0.007615 , 0.007796 , 13.14 , 22.10154 , 41.348057 , 26 , '89860426102071188504' , '460044618415254' , -0 , '120.184898,35.984971' , 1680917243) [ RunTime:0.000531s ] --------------------------------------------------------------- [ 2023-04-08T09:27:48+08:00 ] 124.129.66.161 GET /admin/map/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001465s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009609s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001065s ] --------------------------------------------------------------- [ 2023-04-08T10:10:51+08:00 ] 39.144.15.11 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684076 [ sql ] [ DB ] CONNECT:[ UseTime:0.003023s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011984s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000685s ] --------------------------------------------------------------- [ 2023-04-08T10:10:59+08:00 ] 39.144.15.11 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055684076&date=230408&time=101001&v1=-01.273&v2=+00.019&v3=-01.170&v4=-00.384&v5=05.9&t=+18.9&h=79.5&rssi=+228&imsi=460044618415249&v6=-00.000&a1=00.118&a2=01.290&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001545s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010584s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000674s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684076',`date`='230408',`time`='101001',`v1`=-1.273,`v2`=0.019,`v3`=-1.17,`v4`=-0.384,`v5`=5.9,`t`=18.9,`h`=79.5,`rssi`=228,`imsi`='460044618415249',`v6`=-0,`a1`=0.118,`a2`=1.29,`update_time`=1680919859 WHERE `imei` = '868922055684076' [ RunTime:0.000609s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.012319s ] [ 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' , '230408' , '101001' , -1.273 , 0.019 , -1.17 , -0.384 , 5.9 , 18.9 , 79.5 , 228 , '460044618415249' , -0 , 0.118 , 1.29 , 1680919859 , 1680919859) [ RunTime:0.000636s ] --------------------------------------------------------------- [ 2023-04-08T14:03:55+08:00 ] 39.144.3.89 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055643643 [ sql ] [ DB ] CONNECT:[ UseTime:0.002690s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010546s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000664s ] --------------------------------------------------------------- [ 2023-04-08T14:03:55+08:00 ] 221.178.127.54 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013 [ sql ] [ DB ] CONNECT:[ UseTime:0.001606s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010711s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000642s ] --------------------------------------------------------------- [ 2023-04-08T14:04:03+08:00 ] 221.178.127.54 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=230408&time=140301&v1=+00.409&v2=+00.001&v3=+00.578&v4=+00.288&v5=06.0&t=+23.3&h=62.8&rssi=+222&ccid=4600485905031430000099m9990000000189000000g2960,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ 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.011123s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000743s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644013',`date`='230408',`time`='140301',`v1`=0.409,`v2`=0.001,`v3`=0.578,`v4`=0.288,`v5`=6,`t`=23.3,`h`=62.8,`rssi`=222,`ccid`='4600485905031430000099m9990000000189000000g2960,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1680933843 WHERE `imei` = '868922055644013' [ RunTime:0.000692s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.012153s ] [ 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' , '230408' , '140301' , 0.409 , 0.001 , 0.578 , 0.288 , 6 , 23.3 , 62.8 , 222 , '4600485905031430000099m9990000000189000000g2960,N,00E000=-00.000' , 0 , 0 , 1680933843 , 1680933843) [ RunTime:0.000669s ] --------------------------------------------------------------- [ 2023-04-08T14:04:04+08:00 ] 39.144.3.89 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055643643&date=230408&time=140301&v1=-01.325&v2=+00.038&v3=-00.993&v4=-00.022&v5=05.9&t=+19.3&h=59.6&rssi=+229&ccid=4600485905031420000099m9990000000332000001g3350,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002148s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011078s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000632s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055643643',`date`='230408',`time`='140301',`v1`=-1.325,`v2`=0.038,`v3`=-0.993,`v4`=-0.022,`v5`=5.9,`t`=19.3,`h`=59.6,`rssi`=229,`ccid`='4600485905031420000099m9990000000332000001g3350,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1680933844 WHERE `imei` = '868922055643643' [ RunTime:0.000523s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010779s ] [ 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' , '230408' , '140301' , -1.325 , 0.038 , -0.993 , -0.022 , 5.9 , 19.3 , 59.6 , 229 , '4600485905031420000099m9990000000332000001g3350,N,00E000=-00.000' , 0 , 0 , 1680933844 , 1680933844) [ RunTime:0.000509s ]