--------------------------------------------------------------- [ 2023-04-01T02:03:54+08:00 ] 39.144.14.153 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055643643 [ sql ] [ DB ] CONNECT:[ UseTime:0.002239s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012323s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000725s ] --------------------------------------------------------------- [ 2023-04-01T02:03:55+08:00 ] 117.132.198.37 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013 [ sql ] [ DB ] CONNECT:[ UseTime:0.001494s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011379s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000679s ] --------------------------------------------------------------- [ 2023-04-01T02:04:02+08:00 ] 39.144.14.153 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055643643&date=230401&time=020301&v1=-01.294&v2=+00.018&v3=-00.952&v4=-00.024&v5=05.7&t=+07.9&h=62.3&rssi=+229&ccid=4600485905031420000099m9990000000338000001g3060,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002142s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010409s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000721s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055643643',`date`='230401',`time`='020301',`v1`=-1.294,`v2`=0.018,`v3`=-0.952,`v4`=-0.024,`v5`=5.7,`t`=7.9,`h`=62.3,`rssi`=229,`ccid`='4600485905031420000099m9990000000338000001g3060,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1680285842 WHERE `imei` = '868922055643643' [ RunTime:0.000704s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.013519s ] [ 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' , '230401' , '020301' , -1.294 , 0.018 , -0.952 , -0.024 , 5.7 , 7.9 , 62.3 , 229 , '4600485905031420000099m9990000000338000001g3060,N,00E000=-00.000' , 0 , 0 , 1680285842 , 1680285842) [ RunTime:0.001260s ] --------------------------------------------------------------- [ 2023-04-01T02:04:03+08:00 ] 117.132.198.37 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=230401&time=020301&v1=-00.236&v2=+00.001&v3=-00.033&v4=-00.018&v5=05.9&t=+09.8&h=65.4&rssi=+225&ccid=4600485905031430000099m9990000000012000000g2750,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001919s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011374s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000739s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644013',`date`='230401',`time`='020301',`v1`=-0.236,`v2`=0.001,`v3`=-0.033,`v4`=-0.018,`v5`=5.9,`t`=9.8,`h`=65.4,`rssi`=225,`ccid`='4600485905031430000099m9990000000012000000g2750,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1680285843 WHERE `imei` = '868922055644013' [ RunTime:0.000543s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011498s ] [ 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' , '230401' , '020301' , -0.236 , 0.001 , -0.033 , -0.018 , 5.9 , 9.8 , 65.4 , 225 , '4600485905031430000099m9990000000012000000g2750,N,00E000=-00.000' , 0 , 0 , 1680285843 , 1680285843) [ RunTime:0.000556s ] --------------------------------------------------------------- [ 2023-04-01T09:03:45+08:00 ] 112.224.75.177 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/863412049967592 [ sql ] [ DB ] CONNECT:[ UseTime:0.002252s ] 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 * FROM `collect_show` WHERE `imei` = '863412049967592' LIMIT 1 [ RunTime:0.000620s ] [ sql ] [ SQL ] INSERT INTO `collect_show` (`imei` , `create_time` , `update_time`) VALUES ('863412049967592' , 1680311025 , 1680311025) [ RunTime:0.001125s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '863412049967592' LIMIT 1 [ RunTime:0.000590s ] --------------------------------------------------------------- [ 2023-04-01T09:03:46+08:00 ] 112.224.75.177 GET /kaiwu/public/index.php?s=/index/index/update/&imei=863412049967592&create_time=1680311025&v1=0.057341&v2=5.716711&v3=0.056709&v4=0.056318&v5=7.380000&t=18.176268&h=50.022644&rssi=22&ccid=89860118803392574452&imsi=460015788115318&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001915s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010048s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '863412049967592' LIMIT 1 [ RunTime:0.000627s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='863412049967592',`create_time`=1680311025,`v1`=0.057341,`v2`=5.716711,`v3`=0.056709,`v4`=0.056318,`v5`=7.38,`t`=18.176268,`h`=50.022644,`rssi`=22,`ccid`='89860118803392574452',`imsi`='460015788115318',`v6`=-0,`update_time`=1680311026 WHERE `imei` = '863412049967592' [ RunTime:0.000553s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010996s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('863412049967592' , 1680311025 , 0.057341 , 5.716711 , 0.056709 , 0.056318 , 7.38 , 18.176268 , 50.022644 , 22 , '89860118803392574452' , '460015788115318' , -0 , 1680311026) [ RunTime:0.000641s ] --------------------------------------------------------------- [ 2023-04-01T09:04:19+08:00 ] 27.193.135.0 POST /admin/login/login.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001451s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_manager` [ RunTime:0.011929s ] [ sql ] [ SQL ] SELECT * FROM `collect_manager` WHERE `username` = 'admin' AND `password` = 'b8c6b861afec5f2a9a13ad8f963df1c7' LIMIT 1 [ RunTime:0.000599s ] --------------------------------------------------------------- [ 2023-04-01T09:04:22+08:00 ] 27.193.135.0 GET /admin/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001469s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010131s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000378s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000772s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000965s ] --------------------------------------------------------------- [ 2023-04-01T10:13:51+08:00 ] 111.55.136.231 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684076 [ sql ] [ DB ] CONNECT:[ UseTime:0.002195s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012984s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000691s ] --------------------------------------------------------------- [ 2023-04-01T10:13:59+08:00 ] 111.55.136.231 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055684076&date=230401&time=101301&v1=-01.278&v2=+00.020&v3=-01.057&v4=-00.383&v5=05.9&t=+24.6&h=79.3&rssi=+228&imsi=460044618415249&v6=-00.000&a1=00.248&a2=01.293&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002364s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012636s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000829s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684076',`date`='230401',`time`='101301',`v1`=-1.278,`v2`=0.02,`v3`=-1.057,`v4`=-0.383,`v5`=5.9,`t`=24.6,`h`=79.3,`rssi`=228,`imsi`='460044618415249',`v6`=-0,`a1`=0.248,`a2`=1.293,`update_time`=1680315239 WHERE `imei` = '868922055684076' [ RunTime:0.000751s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.013525s ] [ 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' , '230401' , '101301' , -1.278 , 0.02 , -1.057 , -0.383 , 5.9 , 24.6 , 79.3 , 228 , '460044618415249' , -0 , 0.248 , 1.293 , 1680315239 , 1680315239) [ RunTime:0.000752s ] --------------------------------------------------------------- [ 2023-04-01T10:41:17+08:00 ] 112.224.67.159 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/863412049967592 [ sql ] [ DB ] CONNECT:[ UseTime:0.002788s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012280s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '863412049967592' LIMIT 1 [ RunTime:0.000778s ] --------------------------------------------------------------- [ 2023-04-01T10:41:19+08:00 ] 112.224.67.159 GET /kaiwu/public/index.php?s=/index/index/update/&imei=863412049967592&create_time=1680316877&v1=0.052044&v2=2.088770&v3=0.045512&v4=0.052706&v5=13.140000&t=19.731407&h=44.216675&rssi=22&ccid=89860118803392574452&imsi=460015788115318&v6=-00.000&end= [ sql ] [ DB ] CONNECT:[ UseTime:0.001601s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011190s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '863412049967592' LIMIT 1 [ RunTime:0.000625s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='863412049967592',`create_time`=1680316877,`v1`=0.052044,`v2`=2.08877,`v3`=0.045512,`v4`=0.052706,`v5`=13.14,`t`=19.731407,`h`=44.216675,`rssi`=22,`ccid`='89860118803392574452',`imsi`='460015788115318',`v6`=-0,`update_time`=1680316879 WHERE `imei` = '863412049967592' [ RunTime:0.000561s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010313s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('863412049967592' , 1680316877 , 0.052044 , 2.08877 , 0.045512 , 0.052706 , 13.14 , 19.731407 , 44.216675 , 22 , '89860118803392574452' , '460015788115318' , -0 , 1680316879) [ RunTime:0.000563s ] --------------------------------------------------------------- [ 2023-04-01T10:41:22+08:00 ] 27.193.135.0 GET /admin/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001442s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010226s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000561s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000924s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000940s ] --------------------------------------------------------------- [ 2023-04-01T10:52:14+08:00 ] 112.224.71.6 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/863412049967592 [ sql ] [ DB ] CONNECT:[ UseTime:0.002399s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011285s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '863412049967592' LIMIT 1 [ RunTime:0.000763s ] --------------------------------------------------------------- [ 2023-04-01T10:52:16+08:00 ] 112.224.71.6 GET /kaiwu/public/index.php?s=/index/index/update/&imei=863412049967592&create_time=1680317534&v1=1.051796&v2=0.138834&v3=0.057462&v4=0.056559&v5=13.140000&t=16.385176&h=48.862976&rssi=21&ccid=89860118803392574452&imsi=460015788115318&v6=-00.000&end= [ sql ] [ DB ] CONNECT:[ UseTime:0.002090s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011407s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '863412049967592' LIMIT 1 [ RunTime:0.000695s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='863412049967592',`create_time`=1680317534,`v1`=1.051796,`v2`=0.138834,`v3`=0.057462,`v4`=0.056559,`v5`=13.14,`t`=16.385176,`h`=48.862976,`rssi`=21,`ccid`='89860118803392574452',`imsi`='460015788115318',`v6`=-0,`update_time`=1680317536 WHERE `imei` = '863412049967592' [ RunTime:0.000641s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010785s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('863412049967592' , 1680317534 , 1.051796 , 0.138834 , 0.057462 , 0.056559 , 13.14 , 16.385176 , 48.862976 , 21 , '89860118803392574452' , '460015788115318' , -0 , 1680317536) [ RunTime:0.000835s ] --------------------------------------------------------------- [ 2023-04-01T10:52:25+08:00 ] 27.193.135.0 GET /admin/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001519s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011279s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000360s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000772s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000964s ] --------------------------------------------------------------- [ 2023-04-01T10:55:01+08:00 ] 112.224.69.34 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/863412049967592 [ sql ] [ DB ] CONNECT:[ UseTime:0.002834s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010054s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '863412049967592' LIMIT 1 [ RunTime:0.000741s ] --------------------------------------------------------------- [ 2023-04-01T10:55:03+08:00 ] 112.224.69.34 GET /kaiwu/public/index.php?s=/index/index/update/&imei=863412049967592&create_time=1680317701&v1=1.062753&v2=0.100136&v3=1.062934&v4=0.057040&v5=13.140000&t=17.071583&h=47.077698&rssi=23&ccid=89860118803392574452&imsi=460015788115318&v6=-00.000&end= [ sql ] [ DB ] CONNECT:[ UseTime:0.002076s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009841s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '863412049967592' LIMIT 1 [ RunTime:0.000672s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='863412049967592',`create_time`=1680317701,`v1`=1.062753,`v2`=0.100136,`v3`=1.062934,`v4`=0.05704,`v5`=13.14,`t`=17.071583,`h`=47.077698,`rssi`=23,`ccid`='89860118803392574452',`imsi`='460015788115318',`v6`=-0,`update_time`=1680317703 WHERE `imei` = '863412049967592' [ RunTime:0.000534s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009563s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('863412049967592' , 1680317701 , 1.062753 , 0.100136 , 1.062934 , 0.05704 , 13.14 , 17.071583 , 47.077698 , 23 , '89860118803392574452' , '460015788115318' , -0 , 1680317703) [ RunTime:0.000578s ] --------------------------------------------------------------- [ 2023-04-01T10:55:06+08:00 ] 27.193.135.0 GET /admin/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001499s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009845s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000459s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000841s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001072s ] --------------------------------------------------------------- [ 2023-04-01T11:06:35+08:00 ] 27.193.135.0 GET /admin/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002520s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011329s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000483s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000878s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001036s ] --------------------------------------------------------------- [ 2023-04-01T11:06:37+08:00 ] 27.193.135.0 GET /admin/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001985s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010646s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000387s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000796s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000917s ] --------------------------------------------------------------- [ 2023-04-01T11:06:39+08:00 ] 27.193.135.0 GET /admin/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001640s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010580s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000340s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000738s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000911s ] --------------------------------------------------------------- [ 2023-04-01T11:06:41+08:00 ] 112.224.70.100 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/863412049967592 [ sql ] [ DB ] CONNECT:[ UseTime:0.001621s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011272s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '863412049967592' LIMIT 1 [ RunTime:0.000640s ] --------------------------------------------------------------- [ 2023-04-01T11:06:42+08:00 ] 112.224.70.100 GET /kaiwu/public/index.php?s=/index/index/update/&imei=863412049967592&create_time=1680318401&v1=0.057040&v2=56.175144&v3=0.056498&v4=1.047101&v5=13.140000&t=16.610403&h=47.840637&rssi=21&ccid=89860118803392574452&imsi=460015788115318&v6=-00.000&end [ sql ] [ DB ] CONNECT:[ UseTime:0.002281s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010539s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '863412049967592' LIMIT 1 [ RunTime:0.000725s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='863412049967592',`create_time`=1680318401,`v1`=0.05704,`v2`=56.175144,`v3`=0.056498,`v4`=1.047101,`v5`=13.14,`t`=16.610403,`h`=47.840637,`rssi`=21,`ccid`='89860118803392574452',`imsi`='460015788115318',`v6`=-0,`update_time`=1680318402 WHERE `imei` = '863412049967592' [ RunTime:0.000588s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009474s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('863412049967592' , 1680318401 , 0.05704 , 56.175144 , 0.056498 , 1.047101 , 13.14 , 16.610403 , 47.840637 , 21 , '89860118803392574452' , '460015788115318' , -0 , 1680318402) [ RunTime:0.000511s ] --------------------------------------------------------------- [ 2023-04-01T11:06:50+08:00 ] 27.193.135.0 GET /admin/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001609s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010547s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000438s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000915s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001047s ] --------------------------------------------------------------- [ 2023-04-01T14:03:54+08:00 ] 111.55.140.3 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013 [ sql ] [ DB ] CONNECT:[ UseTime:0.002706s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.015646s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000789s ] --------------------------------------------------------------- [ 2023-04-01T14:03:55+08:00 ] 39.144.15.245 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055643643 [ sql ] [ DB ] CONNECT:[ UseTime:0.001775s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009963s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000693s ] --------------------------------------------------------------- [ 2023-04-01T14:04:03+08:00 ] 111.55.140.3 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=230401&time=140301&v1=-00.196&v2=+00.002&v3=+00.021&v4=-00.018&v5=06.0&t=+25.5&h=63.5&rssi=+223&ccid=4600485905031430000099m9990000000039000000g2300,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002136s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010465s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000634s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644013',`date`='230401',`time`='140301',`v1`=-0.196,`v2`=0.002,`v3`=0.021,`v4`=-0.018,`v5`=6,`t`=25.5,`h`=63.5,`rssi`=223,`ccid`='4600485905031430000099m9990000000039000000g2300,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1680329043 WHERE `imei` = '868922055644013' [ RunTime:0.000584s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010669s ] [ 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' , '230401' , '140301' , -0.196 , 0.002 , 0.021 , -0.018 , 6 , 25.5 , 63.5 , 223 , '4600485905031430000099m9990000000039000000g2300,N,00E000=-00.000' , 0 , 0 , 1680329043 , 1680329043) [ RunTime:0.000618s ] --------------------------------------------------------------- [ 2023-04-01T14:04:03+08:00 ] 39.144.15.245 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055643643&date=230401&time=140301&v1=-01.295&v2=+00.043&v3=-00.937&v4=-00.023&v5=05.7&t=+21.6&h=59.4&rssi=+231&ccid=4600485905031420000099m9990000000353000001g3050,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002055s ] 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` = '868922055643643' LIMIT 1 [ RunTime:0.000672s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055643643',`date`='230401',`time`='140301',`v1`=-1.295,`v2`=0.043,`v3`=-0.937,`v4`=-0.023,`v5`=5.7,`t`=21.6,`h`=59.4,`rssi`=231,`ccid`='4600485905031420000099m9990000000353000001g3050,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1680329043 WHERE `imei` = '868922055643643' [ RunTime:0.000537s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.012114s ] [ 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' , '230401' , '140301' , -1.295 , 0.043 , -0.937 , -0.023 , 5.7 , 21.6 , 59.4 , 231 , '4600485905031420000099m9990000000353000001g3050,N,00E000=-00.000' , 0 , 0 , 1680329043 , 1680329043) [ RunTime:0.000678s ] --------------------------------------------------------------- [ 2023-04-01T15:20:54+08:00 ] 112.224.69.58 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/863412049967592 [ sql ] [ DB ] CONNECT:[ UseTime:0.002676s ] 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 `imei` = '863412049967592' LIMIT 1 [ RunTime:0.000670s ] --------------------------------------------------------------- [ 2023-04-01T15:20:55+08:00 ] 112.224.69.58 GET /kaiwu/public/index.php?s=/index/index/update/&imei=863412049967592&create_time=1680333654&v1=0.062759&v2=1.572445&v3=0.058003&v4=0.056378&v5=13.140000&t=16.363726&h=49.091858&rssi=16&ccid=89860118803392574452&imsi=460015788115318&v6=-00.000&end= [ sql ] [ DB ] CONNECT:[ UseTime:0.001928s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009992s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '863412049967592' LIMIT 1 [ RunTime:0.000738s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='863412049967592',`create_time`=1680333654,`v1`=0.062759,`v2`=1.572445,`v3`=0.058003,`v4`=0.056378,`v5`=13.14,`t`=16.363726,`h`=49.091858,`rssi`=16,`ccid`='89860118803392574452',`imsi`='460015788115318',`v6`=-0,`update_time`=1680333655 WHERE `imei` = '863412049967592' [ RunTime:0.000665s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010336s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('863412049967592' , 1680333654 , 0.062759 , 1.572445 , 0.058003 , 0.056378 , 13.14 , 16.363726 , 49.091858 , 16 , '89860118803392574452' , '460015788115318' , -0 , 1680333655) [ RunTime:0.000722s ]