--------------------------------------------------------------- [ 2023-04-04T02:03:54+08:00 ] 39.144.3.72 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055643643 [ sql ] [ DB ] CONNECT:[ UseTime:0.002495s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.013252s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000845s ] --------------------------------------------------------------- [ 2023-04-04T02:03:54+08:00 ] 39.144.6.37 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013 [ sql ] [ DB ] CONNECT:[ UseTime:0.001726s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009786s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000652s ] --------------------------------------------------------------- [ 2023-04-04T02:04:02+08:00 ] 39.144.3.72 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055643643&date=230404&time=020301&v1=-01.301&v2=+00.019&v3=-00.951&v4=-00.024&v5=05.9&t=+12.7&h=61.3&rssi=+229&ccid=4600485905031420000099m9990000000345000001g3120,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001751s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.015612s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000748s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055643643',`date`='230404',`time`='020301',`v1`=-1.301,`v2`=0.019,`v3`=-0.951,`v4`=-0.024,`v5`=5.9,`t`=12.7,`h`=61.3,`rssi`=229,`ccid`='4600485905031420000099m9990000000345000001g3120,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1680545042 WHERE `imei` = '868922055643643' [ RunTime:0.000644s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.012343s ] [ 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' , '230404' , '020301' , -1.301 , 0.019 , -0.951 , -0.024 , 5.9 , 12.7 , 61.3 , 229 , '4600485905031420000099m9990000000345000001g3120,N,00E000=-00.000' , 0 , 0 , 1680545042 , 1680545042) [ RunTime:0.000660s ] --------------------------------------------------------------- [ 2023-04-04T02:04:03+08:00 ] 39.144.6.37 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=230404&time=020301&v1=-00.212&v2=+00.001&v3=-00.305&v4=-00.016&v5=05.9&t=+13.1&h=64.2&rssi=+224&ccid=4600485905031430000099m9990000000022000000g2370,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002190s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011399s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000731s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644013',`date`='230404',`time`='020301',`v1`=-0.212,`v2`=0.001,`v3`=-0.305,`v4`=-0.016,`v5`=5.9,`t`=13.1,`h`=64.2,`rssi`=224,`ccid`='4600485905031430000099m9990000000022000000g2370,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1680545043 WHERE `imei` = '868922055644013' [ RunTime:0.000641s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010274s ] [ 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' , '230404' , '020301' , -0.212 , 0.001 , -0.305 , -0.016 , 5.9 , 13.1 , 64.2 , 224 , '4600485905031430000099m9990000000022000000g2370,N,00E000=-00.000' , 0 , 0 , 1680545043 , 1680545043) [ RunTime:0.000561s ] --------------------------------------------------------------- [ 2023-04-04T09:54:25+08:00 ] 39.144.2.217 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055677740 [ sql ] [ DB ] CONNECT:[ UseTime:0.003448s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.028793s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.001706s ] --------------------------------------------------------------- [ 2023-04-04T09:54:27+08:00 ] 39.144.2.217 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055677740&create_time=1680573265&v1=0.007013&v2=4.831240&v3=0.006652&v4=0.007856&v5=13.140000&t=17.403954&h=71.636772&rssi=12&ccid=89860426102071188504&imsi=460044618415254&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001681s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011145s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000687s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055677740',`create_time`=1680573265,`v1`=0.007013,`v2`=4.83124,`v3`=0.006652,`v4`=0.007856,`v5`=13.14,`t`=17.403954,`h`=71.636772,`rssi`=12,`ccid`='89860426102071188504',`imsi`='460044618415254',`v6`=-0,`update_time`=1680573267 WHERE `imei` = '868922055677740' [ RunTime:0.000588s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011469s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055677740' , 1680573265 , 0.007013 , 4.83124 , 0.006652 , 0.007856 , 13.14 , 17.403954 , 71.636772 , 12 , '89860426102071188504' , '460044618415254' , -0 , 1680573267) [ RunTime:0.000748s ] --------------------------------------------------------------- [ 2023-04-04T09:55:10+08:00 ] 27.193.135.0 POST /admin/login/login.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001580s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_manager` [ RunTime:0.015038s ] [ sql ] [ SQL ] SELECT * FROM `collect_manager` WHERE `username` = 'admin' AND `password` = 'b8c6b861afec5f2a9a13ad8f963df1c7' LIMIT 1 [ RunTime:0.000711s ] --------------------------------------------------------------- [ 2023-04-04T09:55:14+08:00 ] 27.193.135.0 GET /admin/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001689s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012050s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000390s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000795s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000957s ] --------------------------------------------------------------- [ 2023-04-04T09:55:16+08:00 ] 27.193.135.0 GET /admin/show/index.html?page=3 [ sql ] [ DB ] CONNECT:[ UseTime:0.002567s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.017833s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000558s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 20,10 [ RunTime:0.001554s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001523s ] --------------------------------------------------------------- [ 2023-04-04T09:55:19+08:00 ] 27.193.135.0 GET /admin/show/edit/id/22.html [ 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.011626s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 22 LIMIT 1 [ RunTime:0.000684s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.012801s ] [ sql ] [ SQL ] SELECT * FROM `collect_user` WHERE `collect_user`.`delete_time` IS NULL [ RunTime:0.001137s ] --------------------------------------------------------------- [ 2023-04-04T09:55:22+08:00 ] 27.193.135.0 POST /admin/show/update.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002019s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009513s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `device_name`='STM32',`interval`=2,`gps`='120.10943075811658,36.01656835848008',`username`='user1',`introduce`='

stm32f103c8t6

2022.10.21安装在变电站高压线旁

',`update_time`=1680573322 WHERE `id` = 22 [ RunTime:0.000588s ] --------------------------------------------------------------- [ 2023-04-04T09:55:23+08:00 ] 27.193.135.0 GET /admin/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002177s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010776s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000464s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000986s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001001s ] --------------------------------------------------------------- [ 2023-04-04T09:55:53+08:00 ] 39.144.14.207 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055677740 [ sql ] [ DB ] CONNECT:[ UseTime:0.002773s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010368s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000694s ] --------------------------------------------------------------- [ 2023-04-04T09:55:55+08:00 ] 39.144.14.207 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055677740&create_time=1680573353&v1=0.007013&v2=1.944616&v3=0.006712&v4=0.007856&v5=13.140000&t=18.487186&h=69.088554&rssi=12&ccid=89860426102071188504&imsi=460044618415254&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002127s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011506s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000789s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055677740',`create_time`=1680573353,`v1`=0.007013,`v2`=1.944616,`v3`=0.006712,`v4`=0.007856,`v5`=13.14,`t`=18.487186,`h`=69.088554,`rssi`=12,`ccid`='89860426102071188504',`imsi`='460044618415254',`v6`=-0,`update_time`=1680573355 WHERE `imei` = '868922055677740' [ RunTime:0.000597s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009992s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055677740' , 1680573353 , 0.007013 , 1.944616 , 0.006712 , 0.007856 , 13.14 , 18.487186 , 69.088554 , 12 , '89860426102071188504' , '460044618415254' , -0 , 1680573355) [ RunTime:0.000579s ] --------------------------------------------------------------- [ 2023-04-04T09:59:12+08:00 ] 39.144.1.227 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055677740 [ sql ] [ DB ] CONNECT:[ UseTime:0.002409s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009679s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000670s ] --------------------------------------------------------------- [ 2023-04-04T09:59:14+08:00 ] 39.144.1.227 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055677740&create_time=1680573552&v1=0.007194&v2=1.982793&v3=0.006351&v4=0.008157&v5=13.140000&t=19.977974&h=64.793205&rssi=13&ccid=89860426102071188504&imsi=460044618415254&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001716s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012287s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000726s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055677740',`create_time`=1680573552,`v1`=0.007194,`v2`=1.982793,`v3`=0.006351,`v4`=0.008157,`v5`=13.14,`t`=19.977974,`h`=64.793205,`rssi`=13,`ccid`='89860426102071188504',`imsi`='460044618415254',`v6`=-0,`update_time`=1680573554 WHERE `imei` = '868922055677740' [ RunTime:0.000540s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010315s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055677740' , 1680573552 , 0.007194 , 1.982793 , 0.006351 , 0.008157 , 13.14 , 19.977974 , 64.793205 , 13 , '89860426102071188504' , '460044618415254' , -0 , 1680573554) [ RunTime:0.000508s ] --------------------------------------------------------------- [ 2023-04-04T10:08:38+08:00 ] 111.55.136.49 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055677740 [ sql ] [ DB ] CONNECT:[ UseTime:0.002223s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010179s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000671s ] --------------------------------------------------------------- [ 2023-04-04T10:08:39+08:00 ] 111.55.136.49 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055677740&create_time=1680574118&v1=0.007134&v2=3.333479&v3=0.006923&v4=0.007676&v5=13.140000&t=18.712414&h=66.258049&rssi=13&ccid=89860426102071188504&imsi=460044618415254&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001661s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010890s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000671s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055677740',`create_time`=1680574118,`v1`=0.007134,`v2`=3.333479,`v3`=0.006923,`v4`=0.007676,`v5`=13.14,`t`=18.712414,`h`=66.258049,`rssi`=13,`ccid`='89860426102071188504',`imsi`='460044618415254',`v6`=-0,`update_time`=1680574119 WHERE `imei` = '868922055677740' [ RunTime:0.000569s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009976s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055677740' , 1680574118 , 0.007134 , 3.333479 , 0.006923 , 0.007676 , 13.14 , 18.712414 , 66.258049 , 13 , '89860426102071188504' , '460044618415254' , -0 , 1680574119) [ RunTime:0.000710s ] --------------------------------------------------------------- [ 2023-04-04T10:08:42+08:00 ] 111.55.136.49 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055677740&create_time=1420041608&v1=0.007013&v2=2.352670&v3=0.006893&v4=0.007856&v5=-95.040001&t=20.213924&h=61.939808&rssi=13&ccid=89860426102071188504&imsi=460044618415254&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001782s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012660s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000824s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055677740',`create_time`=1420041608,`v1`=0.007013,`v2`=2.35267,`v3`=0.006893,`v4`=0.007856,`v5`=-95.040001,`t`=20.213924,`h`=61.939808,`rssi`=13,`ccid`='89860426102071188504',`imsi`='460044618415254',`v6`=-0,`update_time`=1680574122 WHERE `imei` = '868922055677740' [ RunTime:0.000578s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009553s ] [ 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.007013 , 2.35267 , 0.006893 , 0.007856 , -95.040001 , 20.213924 , 61.939808 , 13 , '89860426102071188504' , '460044618415254' , -0 , 1680574122) [ RunTime:0.000611s ] --------------------------------------------------------------- [ 2023-04-04T10:08:44+08:00 ] 111.55.136.49 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055677740&create_time=1420041665&v1=0.007194&v2=1.564413&v3=0.007104&v4=0.007856&v5=-95.040001&t=20.063774&h=63.000294&rssi=13&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.009045s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000660s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055677740',`create_time`=1420041665,`v1`=0.007194,`v2`=1.564413,`v3`=0.007104,`v4`=0.007856,`v5`=-95.040001,`t`=20.063774,`h`=63.000294,`rssi`=13,`ccid`='89860426102071188504',`imsi`='460044618415254',`v6`=-0,`update_time`=1680574124 WHERE `imei` = '868922055677740' [ RunTime:0.000814s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010194s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055677740' , 1420041665 , 0.007194 , 1.564413 , 0.007104 , 0.007856 , -95.040001 , 20.063774 , 63.000294 , 13 , '89860426102071188504' , '460044618415254' , -0 , 1680574124) [ RunTime:0.000502s ] --------------------------------------------------------------- [ 2023-04-04T10:12:50+08:00 ] 39.144.14.142 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684076 [ sql ] [ DB ] CONNECT:[ UseTime:0.001711s ] 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` = '868922055684076' LIMIT 1 [ RunTime:0.000664s ] --------------------------------------------------------------- [ 2023-04-04T10:12:59+08:00 ] 39.144.14.142 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055684076&date=230404&time=101201&v1=-01.253&v2=+00.024&v3=-01.157&v4=-00.323&v5=05.9&t=+11.5&h=80.7&rssi=+228&imsi=460044618415249&v6=-00.000&a1=00.105&a2=01.289&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001525s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010415s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000639s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684076',`date`='230404',`time`='101201',`v1`=-1.253,`v2`=0.024,`v3`=-1.157,`v4`=-0.323,`v5`=5.9,`t`=11.5,`h`=80.7,`rssi`=228,`imsi`='460044618415249',`v6`=-0,`a1`=0.105,`a2`=1.289,`update_time`=1680574379 WHERE `imei` = '868922055684076' [ RunTime:0.000581s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010898s ] [ 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' , '230404' , '101201' , -1.253 , 0.024 , -1.157 , -0.323 , 5.9 , 11.5 , 80.7 , 228 , '460044618415249' , -0 , 0.105 , 1.289 , 1680574379 , 1680574379) [ RunTime:0.000629s ] --------------------------------------------------------------- [ 2023-04-04T11:12:40+08:00 ] 111.55.139.231 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055677740 [ sql ] [ DB ] CONNECT:[ UseTime:0.002903s ] 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.001711s ] --------------------------------------------------------------- [ 2023-04-04T11:12:41+08:00 ] 111.55.139.231 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055677740&create_time=1680577960&v1=0.006773&v2=1.490667&v3=0.006201&v4=0.008097&v5=13.140000&t=17.650631&h=69.958305&rssi=18&ccid=89860426102071188504&imsi=460044618415254&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001620s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009839s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000662s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055677740',`create_time`=1680577960,`v1`=0.006773,`v2`=1.490667,`v3`=0.006201,`v4`=0.008097,`v5`=13.14,`t`=17.650631,`h`=69.958305,`rssi`=18,`ccid`='89860426102071188504',`imsi`='460044618415254',`v6`=-0,`update_time`=1680577961 WHERE `imei` = '868922055677740' [ RunTime:0.000613s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.012397s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055677740' , 1680577960 , 0.006773 , 1.490667 , 0.006201 , 0.008097 , 13.14 , 17.650631 , 69.958305 , 18 , '89860426102071188504' , '460044618415254' , -0 , 1680577961) [ RunTime:0.000636s ] --------------------------------------------------------------- [ 2023-04-04T11:12:43+08:00 ] 111.55.139.231 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055677740&create_time=1420041608&v1=0.006411&v2=1.575053&v3=0.005749&v4=0.007916&v5=-95.040001&t=17.296703&h=72.193718&rssi=18&ccid=89860426102071188504&imsi=460044618415254&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002151s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.008477s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.001764s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055677740',`create_time`=1420041608,`v1`=0.006411,`v2`=1.575053,`v3`=0.005749,`v4`=0.007916,`v5`=-95.040001,`t`=17.296703,`h`=72.193718,`rssi`=18,`ccid`='89860426102071188504',`imsi`='460044618415254',`v6`=-0,`update_time`=1680577963 WHERE `imei` = '868922055677740' [ RunTime:0.000510s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010613s ] [ 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.006411 , 1.575053 , 0.005749 , 0.007916 , -95.040001 , 17.296703 , 72.193718 , 18 , '89860426102071188504' , '460044618415254' , -0 , 1680577963) [ RunTime:0.000502s ] --------------------------------------------------------------- [ 2023-04-04T11:12:44+08:00 ] 111.55.139.231 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055677740&create_time=1420041608&v1=0.006773&v2=1.904666&v3=0.006472&v4=0.007736&v5=-95.040001&t=18.004559&h=68.195915&rssi=18&ccid=89860426102071188504&imsi=460044618415254&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001547s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010327s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000663s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055677740',`create_time`=1420041608,`v1`=0.006773,`v2`=1.904666,`v3`=0.006472,`v4`=0.007736,`v5`=-95.040001,`t`=18.004559,`h`=68.195915,`rssi`=18,`ccid`='89860426102071188504',`imsi`='460044618415254',`v6`=-0,`update_time`=1680577964 WHERE `imei` = '868922055677740' [ RunTime:0.000525s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009903s ] [ 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.006773 , 1.904666 , 0.006472 , 0.007736 , -95.040001 , 18.004559 , 68.195915 , 18 , '89860426102071188504' , '460044618415254' , -0 , 1680577964) [ RunTime:0.000524s ] --------------------------------------------------------------- [ 2023-04-04T11:12:45+08:00 ] 111.55.139.231 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055677740&create_time=1420041608&v1=0.006652&v2=1.598105&v3=0.005900&v4=0.008037&v5=13.140000&t=16.878426&h=72.033501&rssi=18&ccid=89860426102071188504&imsi=460044618415254&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001546s ] 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` = '868922055677740' LIMIT 1 [ RunTime:0.000634s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055677740',`create_time`=1420041608,`v1`=0.006652,`v2`=1.598105,`v3`=0.0059,`v4`=0.008037,`v5`=13.14,`t`=16.878426,`h`=72.033501,`rssi`=18,`ccid`='89860426102071188504',`imsi`='460044618415254',`v6`=-0,`update_time`=1680577965 WHERE `imei` = '868922055677740' [ RunTime:0.000506s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010722s ] [ 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.006652 , 1.598105 , 0.0059 , 0.008037 , 13.14 , 16.878426 , 72.033501 , 18 , '89860426102071188504' , '460044618415254' , -0 , 1680577965) [ RunTime:0.000492s ] --------------------------------------------------------------- [ 2023-04-04T11:19:25+08:00 ] 39.144.15.218 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055677740 [ sql ] [ DB ] CONNECT:[ UseTime:0.001811s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011156s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000645s ] --------------------------------------------------------------- [ 2023-04-04T11:19:27+08:00 ] 39.144.15.218 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055677740&create_time=1680578365&v1=0.006773&v2=2.033800&v3=0.006020&v4=0.008037&v5=13.140000&t=17.457581&h=72.460747&rssi=22&ccid=89860426102071188504&imsi=460044618415254&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001858s ] 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 * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000729s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055677740',`create_time`=1680578365,`v1`=0.006773,`v2`=2.0338,`v3`=0.00602,`v4`=0.008037,`v5`=13.14,`t`=17.457581,`h`=72.460747,`rssi`=22,`ccid`='89860426102071188504',`imsi`='460044618415254',`v6`=-0,`update_time`=1680578367 WHERE `imei` = '868922055677740' [ RunTime:0.000650s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011738s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055677740' , 1680578365 , 0.006773 , 2.0338 , 0.00602 , 0.008037 , 13.14 , 17.457581 , 72.460747 , 22 , '89860426102071188504' , '460044618415254' , -0 , 1680578367) [ RunTime:0.000528s ] --------------------------------------------------------------- [ 2023-04-04T11:22:08+08:00 ] 221.178.124.25 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055677740 [ sql ] [ DB ] CONNECT:[ UseTime:0.002092s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010314s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.001038s ] --------------------------------------------------------------- [ 2023-04-04T11:22:10+08:00 ] 221.178.124.25 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055677740&create_time=1680578528&v1=0.006712&v2=2.264843&v3=0.006171&v4=0.008157&v5=12.960000&t=18.197611&h=69.103813&rssi=19&ccid=89860426102071188504&imsi=460044618415254&v6=-00.000&end=$ [ 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.010188s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000733s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055677740',`create_time`=1680578528,`v1`=0.006712,`v2`=2.264843,`v3`=0.006171,`v4`=0.008157,`v5`=12.96,`t`=18.197611,`h`=69.103813,`rssi`=19,`ccid`='89860426102071188504',`imsi`='460044618415254',`v6`=-0,`update_time`=1680578530 WHERE `imei` = '868922055677740' [ RunTime:0.000663s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011274s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055677740' , 1680578528 , 0.006712 , 2.264843 , 0.006171 , 0.008157 , 12.96 , 18.197611 , 69.103813 , 19 , '89860426102071188504' , '460044618415254' , -0 , 1680578530) [ RunTime:0.000519s ] --------------------------------------------------------------- [ 2023-04-04T11:39:03+08:00 ] 27.193.135.0 GET /admin/show/index.html?page=3 [ sql ] [ DB ] CONNECT:[ UseTime:0.002236s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011021s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000430s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 20,10 [ RunTime:0.000987s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000971s ] --------------------------------------------------------------- [ 2023-04-04T11:39:12+08:00 ] 27.193.135.0 GET /admin/show/read/id/22/imei/868922055677740.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002372s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010992s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 22 LIMIT 1 [ RunTime:0.000696s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.012127s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.005161s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055677740' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.019988s ] --------------------------------------------------------------- [ 2023-04-04T11:39:22+08:00 ] 27.193.135.0 GET /admin/show/index.html?page=3 [ sql ] [ DB ] CONNECT:[ UseTime:0.001716s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009759s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.001346s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 20,10 [ RunTime:0.000964s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000907s ] --------------------------------------------------------------- [ 2023-04-04T12:05:03+08:00 ] 111.55.141.49 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055677740 [ sql ] [ DB ] CONNECT:[ UseTime:0.002414s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011563s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000701s ] --------------------------------------------------------------- [ 2023-04-04T12:05:04+08:00 ] 111.55.141.49 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055677740&create_time=1680581103&v1=0.006472&v2=2.347663&v3=0.005870&v4=0.007977&v5=12.960000&t=17.028576&h=72.018242&rssi=21&ccid=89860426102071188504&imsi=460044618415254&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001809s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010058s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000706s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055677740',`create_time`=1680581103,`v1`=0.006472,`v2`=2.347663,`v3`=0.00587,`v4`=0.007977,`v5`=12.96,`t`=17.028576,`h`=72.018242,`rssi`=21,`ccid`='89860426102071188504',`imsi`='460044618415254',`v6`=-0,`update_time`=1680581104 WHERE `imei` = '868922055677740' [ RunTime:0.000651s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011572s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055677740' , 1680581103 , 0.006472 , 2.347663 , 0.00587 , 0.007977 , 12.96 , 17.028576 , 72.018242 , 21 , '89860426102071188504' , '460044618415254' , -0 , 1680581104) [ RunTime:0.000720s ] --------------------------------------------------------------- [ 2023-04-04T12:58:23+08:00 ] 39.144.5.37 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055677740 [ sql ] [ DB ] CONNECT:[ UseTime:0.002895s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012912s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000770s ] --------------------------------------------------------------- [ 2023-04-04T12:58:24+08:00 ] 39.144.5.37 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055677740&create_time=1680584302&v1=0.006050&v2=3.171593&v3=0.005418&v4=0.007796&v5=13.140000&t=16.545948&h=75.741394&rssi=20&ccid=89860426102071188504&imsi=460044618415254&v6=-00.000&end=$ [ 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.009774s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000670s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055677740',`create_time`=1680584302,`v1`=0.00605,`v2`=3.171593,`v3`=0.005418,`v4`=0.007796,`v5`=13.14,`t`=16.545948,`h`=75.741394,`rssi`=20,`ccid`='89860426102071188504',`imsi`='460044618415254',`v6`=-0,`update_time`=1680584304 WHERE `imei` = '868922055677740' [ RunTime:0.000603s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011632s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055677740' , 1680584302 , 0.00605 , 3.171593 , 0.005418 , 0.007796 , 13.14 , 16.545948 , 75.741394 , 20 , '89860426102071188504' , '460044618415254' , -0 , 1680584304) [ RunTime:0.000799s ] --------------------------------------------------------------- [ 2023-04-04T13:01:29+08:00 ] 39.144.12.92 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055677740 [ sql ] [ DB ] CONNECT:[ UseTime:0.002319s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.016846s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.001060s ] --------------------------------------------------------------- [ 2023-04-04T13:01:30+08:00 ] 39.144.12.92 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055677740&create_time=1680584489&v1=0.006773&v2=2.977267&v3=0.006110&v4=0.007977&v5=13.140000&t=17.296703&h=72.460747&rssi=22&ccid=89860426102071188504&imsi=460044618415254&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001759s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009978s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000899s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055677740',`create_time`=1680584489,`v1`=0.006773,`v2`=2.977267,`v3`=0.00611,`v4`=0.007977,`v5`=13.14,`t`=17.296703,`h`=72.460747,`rssi`=22,`ccid`='89860426102071188504',`imsi`='460044618415254',`v6`=-0,`update_time`=1680584490 WHERE `imei` = '868922055677740' [ RunTime:0.000587s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010929s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055677740' , 1680584489 , 0.006773 , 2.977267 , 0.00611 , 0.007977 , 13.14 , 17.296703 , 72.460747 , 22 , '89860426102071188504' , '460044618415254' , -0 , 1680584490) [ RunTime:0.000575s ] --------------------------------------------------------------- [ 2023-04-04T13:06:17+08:00 ] 221.178.124.10 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055677740 [ sql ] [ DB ] CONNECT:[ UseTime:0.003046s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010097s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000671s ] --------------------------------------------------------------- [ 2023-04-04T13:06:19+08:00 ] 221.178.124.10 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055677740&create_time=1680584777&v1=0.006411&v2=4.026815&v3=0.005659&v4=0.007916&v5=13.140000&t=17.210903&h=72.262383&rssi=19&ccid=89860426102071188504&imsi=460044618415254&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001842s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009433s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000749s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055677740',`create_time`=1680584777,`v1`=0.006411,`v2`=4.026815,`v3`=0.005659,`v4`=0.007916,`v5`=13.14,`t`=17.210903,`h`=72.262383,`rssi`=19,`ccid`='89860426102071188504',`imsi`='460044618415254',`v6`=-0,`update_time`=1680584779 WHERE `imei` = '868922055677740' [ RunTime:0.000613s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010283s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055677740' , 1680584777 , 0.006411 , 4.026815 , 0.005659 , 0.007916 , 13.14 , 17.210903 , 72.262383 , 19 , '89860426102071188504' , '460044618415254' , -0 , 1680584779) [ RunTime:0.000528s ] --------------------------------------------------------------- [ 2023-04-04T13:08:24+08:00 ] 39.144.6.185 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055677740 [ sql ] [ DB ] CONNECT:[ UseTime:0.002830s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.013193s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000751s ] --------------------------------------------------------------- [ 2023-04-04T13:08:26+08:00 ] 39.144.6.185 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055677740&create_time=1680584904&v1=0.006472&v2=2.389073&v3=0.006080&v4=0.007977&v5=13.140000&t=17.865133&h=70.446587&rssi=21&ccid=89860426102071188504&imsi=460044618415254&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.010973s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010989s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000790s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055677740',`create_time`=1680584904,`v1`=0.006472,`v2`=2.389073,`v3`=0.00608,`v4`=0.007977,`v5`=13.14,`t`=17.865133,`h`=70.446587,`rssi`=21,`ccid`='89860426102071188504',`imsi`='460044618415254',`v6`=-0,`update_time`=1680584906 WHERE `imei` = '868922055677740' [ RunTime:0.000618s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010698s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055677740' , 1680584904 , 0.006472 , 2.389073 , 0.00608 , 0.007977 , 13.14 , 17.865133 , 70.446587 , 21 , '89860426102071188504' , '460044618415254' , -0 , 1680584906) [ RunTime:0.000559s ] --------------------------------------------------------------- [ 2023-04-04T13:14:15+08:00 ] 39.144.12.126 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055677740 [ sql ] [ DB ] CONNECT:[ UseTime:0.002621s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.014719s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000782s ] --------------------------------------------------------------- [ 2023-04-04T13:14:16+08:00 ] 39.144.12.126 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055677740&create_time=1680585255&v1=0.006472&v2=2.272457&v3=0.005960&v4=0.007856&v5=13.140000&t=17.082201&h=72.331047&rssi=19&ccid=89860426102071188504&imsi=460044618415254&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001996s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009726s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000632s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055677740',`create_time`=1680585255,`v1`=0.006472,`v2`=2.272457,`v3`=0.00596,`v4`=0.007856,`v5`=13.14,`t`=17.082201,`h`=72.331047,`rssi`=19,`ccid`='89860426102071188504',`imsi`='460044618415254',`v6`=-0,`update_time`=1680585256 WHERE `imei` = '868922055677740' [ RunTime:0.000627s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009694s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055677740' , 1680585255 , 0.006472 , 2.272457 , 0.00596 , 0.007856 , 13.14 , 17.082201 , 72.331047 , 19 , '89860426102071188504' , '460044618415254' , -0 , 1680585256) [ RunTime:0.000728s ] --------------------------------------------------------------- [ 2023-04-04T13:25:00+08:00 ] 39.144.15.191 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055677740 [ 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.011290s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000636s ] --------------------------------------------------------------- [ 2023-04-04T13:25:01+08:00 ] 39.144.15.191 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055677740&create_time=1680585900&v1=0.006472&v2=15.522093&v3=0.005268&v4=0.007856&v5=13.140000&t=16.481598&h=74.818237&rssi=21&ccid=89860426102071188504&imsi=460044618415254&v6=-00.000&end=$ [ 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.010115s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000645s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055677740',`create_time`=1680585900,`v1`=0.006472,`v2`=15.522093,`v3`=0.005268,`v4`=0.007856,`v5`=13.14,`t`=16.481598,`h`=74.818237,`rssi`=21,`ccid`='89860426102071188504',`imsi`='460044618415254',`v6`=-0,`update_time`=1680585901 WHERE `imei` = '868922055677740' [ RunTime:0.000526s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.008115s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055677740' , 1680585900 , 0.006472 , 15.522093 , 0.005268 , 0.007856 , 13.14 , 16.481598 , 74.818237 , 21 , '89860426102071188504' , '460044618415254' , -0 , 1680585901) [ RunTime:0.000524s ] --------------------------------------------------------------- [ 2023-04-04T13:28:52+08:00 ] 39.144.3.124 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055677740 [ sql ] [ DB ] CONNECT:[ UseTime:0.002256s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012176s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000668s ] --------------------------------------------------------------- [ 2023-04-04T13:28:53+08:00 ] 39.144.3.124 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055677740&create_time=1680586132&v1=0.006592&v2=2.933979&v3=0.005689&v4=0.008097&v5=13.140000&t=17.178728&h=72.369194&rssi=20&ccid=89860426102071188504&imsi=460044618415254&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001736s ] 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` = '868922055677740' LIMIT 1 [ RunTime:0.000660s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055677740',`create_time`=1680586132,`v1`=0.006592,`v2`=2.933979,`v3`=0.005689,`v4`=0.008097,`v5`=13.14,`t`=17.178728,`h`=72.369194,`rssi`=20,`ccid`='89860426102071188504',`imsi`='460044618415254',`v6`=-0,`update_time`=1680586133 WHERE `imei` = '868922055677740' [ RunTime:0.000550s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011441s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055677740' , 1680586132 , 0.006592 , 2.933979 , 0.005689 , 0.008097 , 13.14 , 17.178728 , 72.369194 , 20 , '89860426102071188504' , '460044618415254' , -0 , 1680586133) [ RunTime:0.000520s ] --------------------------------------------------------------- [ 2023-04-04T13:31:18+08:00 ] 39.144.16.189 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055677740 [ sql ] [ DB ] CONNECT:[ UseTime:0.001963s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012464s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000785s ] --------------------------------------------------------------- [ 2023-04-04T13:31:20+08:00 ] 39.144.16.189 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055677740&create_time=1680586278&v1=0.006592&v2=2.935439&v3=0.006201&v4=0.007856&v5=13.140000&t=17.768606&h=69.935417&rssi=20&ccid=89860426102071188504&imsi=460044618415254&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002474s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009682s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.001680s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055677740',`create_time`=1680586278,`v1`=0.006592,`v2`=2.935439,`v3`=0.006201,`v4`=0.007856,`v5`=13.14,`t`=17.768606,`h`=69.935417,`rssi`=20,`ccid`='89860426102071188504',`imsi`='460044618415254',`v6`=-0,`update_time`=1680586280 WHERE `imei` = '868922055677740' [ RunTime:0.000515s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009734s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055677740' , 1680586278 , 0.006592 , 2.935439 , 0.006201 , 0.007856 , 13.14 , 17.768606 , 69.935417 , 20 , '89860426102071188504' , '460044618415254' , -0 , 1680586280) [ RunTime:0.000527s ] --------------------------------------------------------------- [ 2023-04-04T13:33:18+08:00 ] 39.144.14.147 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055677740 [ sql ] [ DB ] CONNECT:[ UseTime:0.001751s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010549s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000952s ] --------------------------------------------------------------- [ 2023-04-04T13:33:20+08:00 ] 39.144.14.147 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055677740&create_time=1680586398&v1=0.006893&v2=2.921879&v3=0.006231&v4=0.007796&v5=13.140000&t=18.122534&h=68.356133&rssi=21&ccid=89860426102071188504&imsi=460044618415254&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001772s ] 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` = '868922055677740' LIMIT 1 [ RunTime:0.000818s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055677740',`create_time`=1680586398,`v1`=0.006893,`v2`=2.921879,`v3`=0.006231,`v4`=0.007796,`v5`=13.14,`t`=18.122534,`h`=68.356133,`rssi`=21,`ccid`='89860426102071188504',`imsi`='460044618415254',`v6`=-0,`update_time`=1680586400 WHERE `imei` = '868922055677740' [ RunTime:0.000618s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.013505s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055677740' , 1680586398 , 0.006893 , 2.921879 , 0.006231 , 0.007796 , 13.14 , 18.122534 , 68.356133 , 21 , '89860426102071188504' , '460044618415254' , -0 , 1680586400) [ RunTime:0.000625s ] --------------------------------------------------------------- [ 2023-04-04T13:38:52+08:00 ] 39.144.7.158 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055677740 [ sql ] [ DB ] CONNECT:[ UseTime:0.002920s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011530s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000733s ] --------------------------------------------------------------- [ 2023-04-04T13:38:53+08:00 ] 39.144.7.158 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055677740&create_time=1680586732&v1=0.006652&v2=2.325863&v3=0.006020&v4=0.007916&v5=13.140000&t=17.210903&h=72.239494&rssi=19&ccid=89860426102071188504&imsi=460044618415254&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002082s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011445s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000658s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055677740',`create_time`=1680586732,`v1`=0.006652,`v2`=2.325863,`v3`=0.00602,`v4`=0.007916,`v5`=13.14,`t`=17.210903,`h`=72.239494,`rssi`=19,`ccid`='89860426102071188504',`imsi`='460044618415254',`v6`=-0,`update_time`=1680586733 WHERE `imei` = '868922055677740' [ RunTime:0.000615s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010853s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055677740' , 1680586732 , 0.006652 , 2.325863 , 0.00602 , 0.007916 , 13.14 , 17.210903 , 72.239494 , 19 , '89860426102071188504' , '460044618415254' , -0 , 1680586733) [ RunTime:0.000607s ] --------------------------------------------------------------- [ 2023-04-04T13:52:30+08:00 ] 221.178.125.106 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055677740 [ sql ] [ DB ] CONNECT:[ UseTime:0.002338s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.013948s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000785s ] --------------------------------------------------------------- [ 2023-04-04T13:52:31+08:00 ] 221.178.125.106 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055677740&create_time=1680587550&v1=0.006291&v2=2.164081&v3=0.005689&v4=0.008097&v5=13.140000&t=16.449423&h=74.101074&rssi=23&ccid=89860426102071188504&imsi=460044618415254&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001603s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011171s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000640s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055677740',`create_time`=1680587550,`v1`=0.006291,`v2`=2.164081,`v3`=0.005689,`v4`=0.008097,`v5`=13.14,`t`=16.449423,`h`=74.101074,`rssi`=23,`ccid`='89860426102071188504',`imsi`='460044618415254',`v6`=-0,`update_time`=1680587551 WHERE `imei` = '868922055677740' [ RunTime:0.000596s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010643s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055677740' , 1680587550 , 0.006291 , 2.164081 , 0.005689 , 0.008097 , 13.14 , 16.449423 , 74.101074 , 23 , '89860426102071188504' , '460044618415254' , -0 , 1680587551) [ RunTime:0.000631s ] --------------------------------------------------------------- [ 2023-04-04T14:03:55+08:00 ] 111.55.140.39 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055643643 [ sql ] [ DB ] CONNECT:[ UseTime:0.002864s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012584s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000778s ] --------------------------------------------------------------- [ 2023-04-04T14:03:55+08:00 ] 218.204.252.205 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013 [ sql ] [ DB ] CONNECT:[ UseTime:0.001726s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011827s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000713s ] --------------------------------------------------------------- [ 2023-04-04T14:04:04+08:00 ] 111.55.140.39 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055643643&date=230404&time=140301&v1=-01.292&v2=+00.045&v3=-00.973&v4=-00.023&v5=05.7&t=+12.8&h=61.1&rssi=+229&ccid=4600485905031420000099m9990000000316000001g3040,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002436s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.013713s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.001090s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055643643',`date`='230404',`time`='140301',`v1`=-1.292,`v2`=0.045,`v3`=-0.973,`v4`=-0.023,`v5`=5.7,`t`=12.8,`h`=61.1,`rssi`=229,`ccid`='4600485905031420000099m9990000000316000001g3040,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1680588243 WHERE `imei` = '868922055643643' [ RunTime:0.000821s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.014422s ] [ 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' , '230404' , '140301' , -1.292 , 0.045 , -0.973 , -0.023 , 5.7 , 12.8 , 61.1 , 229 , '4600485905031420000099m9990000000316000001g3040,N,00E000=-00.000' , 0 , 0 , 1680588244 , 1680588244) [ RunTime:0.000712s ] --------------------------------------------------------------- [ 2023-04-04T14:04:04+08:00 ] 218.204.252.205 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=230404&time=140301&v1=+00.894&v2=+00.002&v3=+00.846&v4=+00.584&v5=05.9&t=+12.8&h=63.8&rssi=+227&ccid=4600485905031430000099m9990000000061000000g7440,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.003106s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.013576s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000924s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644013',`date`='230404',`time`='140301',`v1`=0.894,`v2`=0.002,`v3`=0.846,`v4`=0.584,`v5`=5.9,`t`=12.8,`h`=63.8,`rssi`=227,`ccid`='4600485905031430000099m9990000000061000000g7440,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1680588244 WHERE `imei` = '868922055644013' [ RunTime:0.000711s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.012325s ] [ 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' , '230404' , '140301' , 0.894 , 0.002 , 0.846 , 0.584 , 5.9 , 12.8 , 63.8 , 227 , '4600485905031430000099m9990000000061000000g7440,N,00E000=-00.000' , 0 , 0 , 1680588244 , 1680588244) [ RunTime:0.000834s ] --------------------------------------------------------------- [ 2023-04-04T14:57:38+08:00 ] 218.204.253.45 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055677740 [ sql ] [ DB ] CONNECT:[ UseTime:0.002426s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.013205s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000691s ] --------------------------------------------------------------- [ 2023-04-04T15:01:58+08:00 ] 111.55.137.38 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055677740 [ sql ] [ DB ] CONNECT:[ UseTime:0.002133s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012234s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.001040s ] --------------------------------------------------------------- [ 2023-04-04T15:02:00+08:00 ] 111.55.137.38 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055677740&create_time=1680591718&v1=0.006652&v2=2.963081&v3=0.006201&v4=0.007676&v5=13.140000&t=17.339603&h=70.477104&rssi=21&ccid=89860426102071188504&imsi=460044618415254&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002001s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009476s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.001318s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055677740',`create_time`=1680591718,`v1`=0.006652,`v2`=2.963081,`v3`=0.006201,`v4`=0.007676,`v5`=13.14,`t`=17.339603,`h`=70.477104,`rssi`=21,`ccid`='89860426102071188504',`imsi`='460044618415254',`v6`=-0,`update_time`=1680591720 WHERE `imei` = '868922055677740' [ RunTime:0.000629s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.012147s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055677740' , 1680591718 , 0.006652 , 2.963081 , 0.006201 , 0.007676 , 13.14 , 17.339603 , 70.477104 , 21 , '89860426102071188504' , '460044618415254' , -0 , 1680591720) [ RunTime:0.000741s ] --------------------------------------------------------------- [ 2023-04-04T15:09:22+08:00 ] 39.144.14.192 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055677740 [ sql ] [ DB ] CONNECT:[ UseTime:0.002499s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.014782s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000737s ] --------------------------------------------------------------- [ 2023-04-04T15:09:24+08:00 ] 39.144.14.192 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055677740&create_time=1680592162&v1=0.006712&v2=2.888083&v3=0.006261&v4=0.007676&v5=13.140000&t=17.082201&h=71.644402&rssi=21&ccid=89860426102071188504&imsi=460044618415254&v6=-00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001715s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011494s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000907s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055677740',`create_time`=1680592162,`v1`=0.006712,`v2`=2.888083,`v3`=0.006261,`v4`=0.007676,`v5`=13.14,`t`=17.082201,`h`=71.644402,`rssi`=21,`ccid`='89860426102071188504',`imsi`='460044618415254',`v6`=-0,`update_time`=1680592164 WHERE `imei` = '868922055677740' [ RunTime:0.000637s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011546s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055677740' , 1680592162 , 0.006712 , 2.888083 , 0.006261 , 0.007676 , 13.14 , 17.082201 , 71.644402 , 21 , '89860426102071188504' , '460044618415254' , -0 , 1680592164) [ RunTime:0.000640s ]