---------------------------------------------------------------
[ 2023-04-26T02:03:55+08:00 ] 39.144.18.99 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055643643
[ sql ] [ DB ] CONNECT:[ UseTime:0.002160s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011670s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.001192s ]
---------------------------------------------------------------
[ 2023-04-26T02:03:55+08:00 ] 39.144.1.149 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013
[ sql ] [ DB ] CONNECT:[ UseTime:0.002046s ] 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 * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000739s ]
---------------------------------------------------------------
[ 2023-04-26T02:04:03+08:00 ] 39.144.18.99 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055643643&date=230426&time=020301&v1=-01.333&v2=+00.019&v3=-00.974&v4=-00.029&v5=05.7&t=+12.2&h=60.8&rssi=+230&ccid=4600485905031420000099m9990000000362000001g3420,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.002206s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010615s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000675s ]
[ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055643643',`date`='230426',`time`='020301',`v1`=-1.333,`v2`=0.019,`v3`=-0.974,`v4`=-0.029,`v5`=5.7,`t`=12.2,`h`=60.8,`rssi`=230,`ccid`='4600485905031420000099m9990000000362000001g3420,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1682445843 WHERE `imei` = '868922055643643' [ RunTime:0.000592s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011168s ]
[ 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' , '230426' , '020301' , -1.333 , 0.019 , -0.974 , -0.029 , 5.7 , 12.2 , 60.8 , 230 , '4600485905031420000099m9990000000362000001g3420,N,00E000=-00.000' , 0 , 0 , 1682445843 , 1682445843) [ RunTime:0.001280s ]
---------------------------------------------------------------
[ 2023-04-26T02:04:04+08:00 ] 39.144.1.149 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=230426&time=020301&v1=-00.247&v2=+00.001&v3=+00.013&v4=-00.012&v5=05.9&t=+12.4&h=63.5&rssi=+225&ccid=4600485905031430000099m9990000000036000000g2670,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.001623s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010737s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000673s ]
[ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644013',`date`='230426',`time`='020301',`v1`=-0.247,`v2`=0.001,`v3`=0.013,`v4`=-0.012,`v5`=5.9,`t`=12.4,`h`=63.5,`rssi`=225,`ccid`='4600485905031430000099m9990000000036000000g2670,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1682445843 WHERE `imei` = '868922055644013' [ RunTime:0.000921s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010797s ]
[ 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' , '230426' , '020301' , -0.247 , 0.001 , 0.013 , -0.012 , 5.9 , 12.4 , 63.5 , 225 , '4600485905031430000099m9990000000036000000g2670,N,00E000=-00.000' , 0 , 0 , 1682445844 , 1682445844) [ RunTime:0.001138s ]
---------------------------------------------------------------
[ 2023-04-26T04:28:28+08:00 ] 39.144.13.198 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055647586
[ sql ] [ DB ] CONNECT:[ UseTime:0.002388s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010843s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055647586' LIMIT 1 [ RunTime:0.000734s ]
---------------------------------------------------------------
[ 2023-04-26T04:28:29+08:00 ] 39.144.13.198 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055647586&create_time=1682454508&v1=0.017910&v2=0.014395&v3=0.015291&v4=-0.000030&v5=12.240000&t=15.409192&h=72.636169&rssi=26&ccid=898604650119C1078512&imsi=460048590708512&v6=-00.000&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.001796s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009673s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055647586' LIMIT 1 [ RunTime:0.000648s ]
[ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055647586',`create_time`=1682454508,`v1`=0.01791,`v2`=0.014395,`v3`=0.015291,`v4`=-3.0E-5,`v5`=12.24,`t`=15.409192,`h`=72.636169,`rssi`=26,`ccid`='898604650119C1078512',`imsi`='460048590708512',`v6`=-0,`update_time`=1682454509 WHERE `imei` = '868922055647586' [ RunTime:0.000614s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009785s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055647586' , 1682454508 , 0.01791 , 0.014395 , 0.015291 , -3.0E-5 , 12.24 , 15.409192 , 72.636169 , 26 , '898604650119C1078512' , '460048590708512' , -0 , 1682454509) [ RunTime:0.000626s ]
---------------------------------------------------------------
[ 2023-04-26T05:08:05+08:00 ] 117.132.191.112 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922056976208
[ sql ] [ DB ] CONNECT:[ UseTime:0.002424s ] 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 `imei` = '868922056976208' LIMIT 1 [ RunTime:0.000726s ]
---------------------------------------------------------------
[ 2023-04-26T05:08:06+08:00 ] 117.132.191.112 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922056976208&create_time=1682456885&v1=0.026819&v2=0.013351&v3=0.024923&v4=0.016164&v5=12.240000&t=15.527168&h=57.499451&rssi=27&ccid=898604650119C1053139&imsi=460048590503139&v6=-00.000&gps=120.184562,35.984127&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.002245s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010359s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922056976208' LIMIT 1 [ RunTime:0.000735s ]
[ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922056976208',`create_time`=1682456885,`v1`=0.026819,`v2`=0.013351,`v3`=0.024923,`v4`=0.016164,`v5`=12.24,`t`=15.527168,`h`=57.499451,`rssi`=27,`ccid`='898604650119C1053139',`imsi`='460048590503139',`v6`=-0,`gps`='120.184562,35.984127',`update_time`=1682456886 WHERE `imei` = '868922056976208' [ RunTime:0.000732s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011008s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `gps` , `update_time`) VALUES ('868922056976208' , 1682456885 , 0.026819 , 0.013351 , 0.024923 , 0.016164 , 12.24 , 15.527168 , 57.499451 , 27 , '898604650119C1053139' , '460048590503139' , -0 , '120.184562,35.984127' , 1682456886) [ RunTime:0.000981s ]
---------------------------------------------------------------
[ 2023-04-26T05:10:26+08:00 ] 39.144.11.19 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684209
[ 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.011508s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684209' LIMIT 1 [ RunTime:0.000731s ]
---------------------------------------------------------------
[ 2023-04-26T05:10:27+08:00 ] 39.144.11.19 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055684209&create_time=1682457026&v1=0.019174&v2=0.014812&v3=0.015742&v4=-0.007074&v5=12.420000&t=15.334116&h=64.281982&rssi=27&ccid=898604650119C1078511&imsi=460048590708511&v6=-00.000&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.001592s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010666s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684209' LIMIT 1 [ RunTime:0.000687s ]
[ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684209',`create_time`=1682457026,`v1`=0.019174,`v2`=0.014812,`v3`=0.015742,`v4`=-0.007074,`v5`=12.42,`t`=15.334116,`h`=64.281982,`rssi`=27,`ccid`='898604650119C1078511',`imsi`='460048590708511',`v6`=-0,`update_time`=1682457027 WHERE `imei` = '868922055684209' [ RunTime:0.000546s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009587s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055684209' , 1682457026 , 0.019174 , 0.014812 , 0.015742 , -0.007074 , 12.42 , 15.334116 , 64.281982 , 27 , '898604650119C1078511' , '460048590708511' , -0 , 1682457027) [ RunTime:0.000510s ]
---------------------------------------------------------------
[ 2023-04-26T10:29:29+08:00 ] 39.144.1.243 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055647586
[ sql ] [ DB ] CONNECT:[ UseTime:0.002493s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011697s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055647586' LIMIT 1 [ RunTime:0.000715s ]
---------------------------------------------------------------
[ 2023-04-26T10:29:31+08:00 ] 39.144.1.243 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055647586&create_time=1682476169&v1=0.018030&v2=0.017107&v3=0.015381&v4=0.000030&v5=12.420000&t=16.621128&h=75.886292&rssi=28&ccid=898604650119C1078512&imsi=460048590708512&v6=-00.000&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.001564s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010087s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055647586' LIMIT 1 [ RunTime:0.000657s ]
[ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055647586',`create_time`=1682476169,`v1`=0.01803,`v2`=0.017107,`v3`=0.015381,`v4`=3.0E-5,`v5`=12.42,`t`=16.621128,`h`=75.886292,`rssi`=28,`ccid`='898604650119C1078512',`imsi`='460048590708512',`v6`=-0,`update_time`=1682476171 WHERE `imei` = '868922055647586' [ RunTime:0.000629s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010040s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055647586' , 1682476169 , 0.01803 , 0.017107 , 0.015381 , 3.0E-5 , 12.42 , 16.621128 , 75.886292 , 28 , '898604650119C1078512' , '460048590708512' , -0 , 1682476171) [ RunTime:0.000642s ]
---------------------------------------------------------------
[ 2023-04-26T11:09:18+08:00 ] 117.132.193.86 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922056976208
[ sql ] [ DB ] CONNECT:[ UseTime:0.002187s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012185s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922056976208' LIMIT 1 [ RunTime:0.000833s ]
---------------------------------------------------------------
[ 2023-04-26T11:09:19+08:00 ] 117.132.193.86 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922056976208&create_time=1682478558&v1=0.027181&v2=0.017732&v3=0.025013&v4=0.016043&v5=12.420000&t=16.867805&h=62.153381&rssi=29&ccid=898604650119C1053139&imsi=460048590503139&v6=-00.000&gps=120.184762,35.987969&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.002787s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009503s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922056976208' LIMIT 1 [ RunTime:0.001015s ]
[ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922056976208',`create_time`=1682478558,`v1`=0.027181,`v2`=0.017732,`v3`=0.025013,`v4`=0.016043,`v5`=12.42,`t`=16.867805,`h`=62.153381,`rssi`=29,`ccid`='898604650119C1053139',`imsi`='460048590503139',`v6`=-0,`gps`='120.184762,35.987969',`update_time`=1682478559 WHERE `imei` = '868922056976208' [ RunTime:0.000676s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011342s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `gps` , `update_time`) VALUES ('868922056976208' , 1682478558 , 0.027181 , 0.017732 , 0.025013 , 0.016043 , 12.42 , 16.867805 , 62.153381 , 29 , '898604650119C1053139' , '460048590503139' , -0 , '120.184762,35.987969' , 1682478559) [ RunTime:0.000638s ]
---------------------------------------------------------------
[ 2023-04-26T11:11:26+08:00 ] 39.144.3.196 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684209
[ sql ] [ DB ] CONNECT:[ UseTime:0.002191s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010545s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684209' LIMIT 1 [ RunTime:0.000683s ]
---------------------------------------------------------------
[ 2023-04-26T11:11:27+08:00 ] 39.144.3.196 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055684209&create_time=1682478686&v1=0.019294&v2=0.020757&v3=0.015923&v4=-0.006953&v5=12.600000&t=16.814180&h=68.096680&rssi=27&ccid=898604650119C1078511&imsi=460048590708511&v6=-00.000&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.001496s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.008560s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684209' LIMIT 1 [ RunTime:0.000698s ]
[ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684209',`create_time`=1682478686,`v1`=0.019294,`v2`=0.020757,`v3`=0.015923,`v4`=-0.006953,`v5`=12.6,`t`=16.81418,`h`=68.09668,`rssi`=27,`ccid`='898604650119C1078511',`imsi`='460048590708511',`v6`=-0,`update_time`=1682478687 WHERE `imei` = '868922055684209' [ RunTime:0.000686s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.008748s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055684209' , 1682478686 , 0.019294 , 0.020757 , 0.015923 , -0.006953 , 12.6 , 16.81418 , 68.09668 , 27 , '898604650119C1078511' , '460048590708511' , -0 , 1682478687) [ RunTime:0.000495s ]
---------------------------------------------------------------
[ 2023-04-26T13:20:02+08:00 ] 124.129.96.215 POST /admin/login/login.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.002157s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_manager` [ RunTime:0.011752s ]
[ sql ] [ SQL ] SELECT * FROM `collect_manager` WHERE `username` = 'admin' AND `password` = 'b8c6b861afec5f2a9a13ad8f963df1c7' LIMIT 1 [ RunTime:0.000648s ]
---------------------------------------------------------------
[ 2023-04-26T13:20:05+08:00 ] 124.129.96.215 GET /admin/show/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001618s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011959s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000425s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000923s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001201s ]
---------------------------------------------------------------
[ 2023-04-26T13:20:52+08:00 ] 124.129.96.215 GET /admin/show/edit/id/47.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001464s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009516s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 47 LIMIT 1 [ RunTime:0.000698s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.012542s ]
[ sql ] [ SQL ] SELECT * FROM `collect_user` WHERE `collect_user`.`delete_time` IS NULL [ RunTime:0.001195s ]
---------------------------------------------------------------
[ 2023-04-26T13:20:56+08:00 ] 124.129.96.215 GET /admin/show/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.002441s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012090s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000358s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000804s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000966s ]
---------------------------------------------------------------
[ 2023-04-26T13:21:00+08:00 ] 124.129.96.215 GET /admin/show/read/id/47/imei/868922055684209.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.002057s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009339s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 47 LIMIT 1 [ RunTime:0.000670s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.012420s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055684209' LIMIT 1 [ RunTime:0.000532s ]
[ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055684209' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.004026s ]
---------------------------------------------------------------
[ 2023-04-26T13:21:06+08:00 ] 124.129.96.215 GET /admin/show/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001870s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010892s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000410s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000812s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000915s ]
---------------------------------------------------------------
[ 2023-04-26T13:21:14+08:00 ] 124.129.96.215 GET /admin/show/edit/id/47.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001808s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.008725s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 47 LIMIT 1 [ RunTime:0.000847s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.009034s ]
[ sql ] [ SQL ] SELECT * FROM `collect_user` WHERE `collect_user`.`delete_time` IS NULL [ RunTime:0.000469s ]
---------------------------------------------------------------
[ 2023-04-26T13:21:20+08:00 ] 124.129.96.215 POST /admin/show/update.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.002269s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011679s ]
[ sql ] [ SQL ] UPDATE `collect_show` SET `device_name`='带gps测试2',`interval`=1440,`gps`='120.184861,35.985146',`username`='admin',`introduce`=' ',`update_time`=1682486480 WHERE `id` = 47 [ RunTime:0.000910s ]
---------------------------------------------------------------
[ 2023-04-26T13:21:21+08:00 ] 124.129.96.215 GET /admin/show/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001761s ] 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 COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000404s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000843s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000958s ]
---------------------------------------------------------------
[ 2023-04-26T13:21:25+08:00 ] 124.129.96.215 GET /admin/show/edit/id/44.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.002116s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010775s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 44 LIMIT 1 [ RunTime:0.000811s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.011526s ]
[ sql ] [ SQL ] SELECT * FROM `collect_user` WHERE `collect_user`.`delete_time` IS NULL [ RunTime:0.000599s ]
---------------------------------------------------------------
[ 2023-04-26T13:21:30+08:00 ] 124.129.96.215 POST /admin/show/update.html
[ 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.010367s ]
[ sql ] [ SQL ] UPDATE `collect_show` SET `device_name`='带gps测试3',`interval`=1440,`gps`='120.185121,35.985750',`username`='admin',`introduce`=' ',`update_time`=1682486490 WHERE `id` = 44 [ RunTime:0.000676s ]
---------------------------------------------------------------
[ 2023-04-26T13:21:31+08:00 ] 124.129.96.215 GET /admin/show/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001899s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009732s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000384s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000791s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000934s ]
---------------------------------------------------------------
[ 2023-04-26T13:21:37+08:00 ] 124.129.96.215 GET /admin/show/index.html?page=3
[ sql ] [ DB ] CONNECT:[ UseTime:0.001780s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009573s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000335s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 20,10 [ RunTime:0.001203s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001581s ]
---------------------------------------------------------------
[ 2023-04-26T13:21:41+08:00 ] 124.129.96.215 GET /admin/show/index.html?page=2
[ sql ] [ DB ] CONNECT:[ UseTime:0.002083s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011186s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000422s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 10,10 [ RunTime:0.001005s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000902s ]
---------------------------------------------------------------
[ 2023-04-26T13:21:44+08:00 ] 124.129.96.215 GET /admin/show/edit/id/35.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001705s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009921s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 35 LIMIT 1 [ RunTime:0.000857s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.010563s ]
[ sql ] [ SQL ] SELECT * FROM `collect_user` WHERE `collect_user`.`delete_time` IS NULL [ RunTime:0.000460s ]
---------------------------------------------------------------
[ 2023-04-26T13:21:48+08:00 ] 124.129.96.215 POST /admin/show/update.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001972s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011045s ]
[ sql ] [ SQL ] UPDATE `collect_show` SET `device_name`='带gps测试1',`interval`=1440,`gps`='120.184762,35.987969',`username`='admin',`introduce`=' ',`update_time`=1682486508 WHERE `id` = 35 [ RunTime:0.000843s ]
---------------------------------------------------------------
[ 2023-04-26T13:21:50+08:00 ] 124.129.96.215 GET /admin/show/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001959s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009834s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000980s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000848s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000973s ]
---------------------------------------------------------------
[ 2023-04-26T13:21:52+08:00 ] 124.129.96.215 GET /admin/show/index.html?page=2
[ sql ] [ DB ] CONNECT:[ UseTime:0.001801s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009742s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000407s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 10,10 [ RunTime:0.000994s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001219s ]
---------------------------------------------------------------
[ 2023-04-26T13:22:05+08:00 ] 124.129.96.215 GET /admin/show/index.html?keyword=868922055683920
[ sql ] [ DB ] CONNECT:[ UseTime:0.002485s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011335s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `imei` LIKE '%868922055683920%' LIMIT 1 [ RunTime:0.000482s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` LIKE '%868922055683920%' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000649s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000969s ]
---------------------------------------------------------------
[ 2023-04-26T13:22:07+08:00 ] 124.129.96.215 GET /admin/show/edit/id/30.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001803s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009064s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 30 LIMIT 1 [ RunTime:0.000641s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.009869s ]
[ sql ] [ SQL ] SELECT * FROM `collect_user` WHERE `collect_user`.`delete_time` IS NULL [ RunTime:0.000457s ]
---------------------------------------------------------------
[ 2023-04-26T13:22:16+08:00 ] 124.129.96.215 POST /admin/show/update.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001497s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009715s ]
[ sql ] [ SQL ] UPDATE `collect_show` SET `device_name`='带gps测试4',`interval`=1440,`gps`='120.184825,35.985034',`username`='admin',`introduce`='atsaml21e17b芯片改进版本，结合stm32程序逻辑。
2022.10.21安装到变电站，1号避雷针旁边
自然接蓝色
通电接红色
',`update_time`=1682486536 WHERE `id` = 30 [ RunTime:0.000925s ]
---------------------------------------------------------------
[ 2023-04-26T13:22:17+08:00 ] 124.129.96.215 GET /admin/show/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001840s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010392s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000401s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000858s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001720s ]
---------------------------------------------------------------
[ 2023-04-26T14:03:54+08:00 ] 39.144.3.236 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055643643
[ sql ] [ DB ] CONNECT:[ UseTime:0.002772s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011130s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000737s ]
---------------------------------------------------------------
[ 2023-04-26T14:03:55+08:00 ] 39.144.12.108 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013
[ sql ] [ DB ] CONNECT:[ UseTime:0.001890s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009970s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000710s ]
---------------------------------------------------------------
[ 2023-04-26T14:04:03+08:00 ] 39.144.3.236 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055643643&date=230426&time=140301&v1=-01.333&v2=+00.042&v3=-00.992&v4=-00.028&v5=05.9&t=+20.5&h=58.6&rssi=+231&ccid=4600485905031420000099m9990000000342000001g3420,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.001598s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009685s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000737s ]
[ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055643643',`date`='230426',`time`='140301',`v1`=-1.333,`v2`=0.042,`v3`=-0.992,`v4`=-0.028,`v5`=5.9,`t`=20.5,`h`=58.6,`rssi`=231,`ccid`='4600485905031420000099m9990000000342000001g3420,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1682489043 WHERE `imei` = '868922055643643' [ RunTime:0.000645s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.012242s ]
[ 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' , '230426' , '140301' , -1.333 , 0.042 , -0.992 , -0.028 , 5.9 , 20.5 , 58.6 , 231 , '4600485905031420000099m9990000000342000001g3420,N,00E000=-00.000' , 0 , 0 , 1682489043 , 1682489043) [ RunTime:0.000624s ]
---------------------------------------------------------------
[ 2023-04-26T14:04:03+08:00 ] 39.144.12.108 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=230426&time=140301&v1=-00.247&v2=+00.002&v3=+00.020&v4=-00.011&v5=06.0&t=+24.7&h=61.9&rssi=+228&ccid=4600485905031430000099m9990000000040000000g2670,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.002120s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011380s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000672s ]
[ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644013',`date`='230426',`time`='140301',`v1`=-0.247,`v2`=0.002,`v3`=0.02,`v4`=-0.011,`v5`=6,`t`=24.7,`h`=61.9,`rssi`=228,`ccid`='4600485905031430000099m9990000000040000000g2670,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1682489043 WHERE `imei` = '868922055644013' [ RunTime:0.000543s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009233s ]
[ 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' , '230426' , '140301' , -0.247 , 0.002 , 0.02 , -0.011 , 6 , 24.7 , 61.9 , 228 , '4600485905031430000099m9990000000040000000g2670,N,00E000=-00.000' , 0 , 0 , 1682489043 , 1682489043) [ RunTime:0.000536s ]
---------------------------------------------------------------
[ 2023-04-26T14:14:50+08:00 ] 111.55.140.247 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684076
[ sql ] [ DB ] CONNECT:[ UseTime:0.002217s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.014590s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000822s ]
---------------------------------------------------------------
[ 2023-04-26T14:14:59+08:00 ] 111.55.140.247 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055684076&date=230426&time=141401&v1=-00.202&v2=+00.007&v3=-00.127&v4=+00.106&v5=06.0&t=+24.2&h=78.7&rssi=+226&imsi=460044618415249&v6=-00.000&a1=00.130&a2=00.318&a3=00.000&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.001555s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009899s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000702s ]
[ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684076',`date`='230426',`time`='141401',`v1`=-0.202,`v2`=0.007,`v3`=-0.127,`v4`=0.106,`v5`=6,`t`=24.2,`h`=78.7,`rssi`=226,`imsi`='460044618415249',`v6`=-0,`a1`=0.13,`a2`=0.318,`update_time`=1682489699 WHERE `imei` = '868922055684076' [ RunTime:0.000634s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011773s ]
[ 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' , '230426' , '141401' , -0.202 , 0.007 , -0.127 , 0.106 , 6 , 24.2 , 78.7 , 226 , '460044618415249' , -0 , 0.13 , 0.318 , 1682489699 , 1682489699) [ RunTime:0.000631s ]
---------------------------------------------------------------
[ 2023-04-26T16:30:30+08:00 ] 111.55.141.90 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055647586
[ 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.011112s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055647586' LIMIT 1 [ RunTime:0.000708s ]
---------------------------------------------------------------
[ 2023-04-26T16:30:31+08:00 ] 111.55.141.90 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055647586&create_time=1682497830&v1=0.017970&v2=0.016481&v3=0.015351&v4=-0.000151&v5=12.420000&t=16.899981&h=77.496094&rssi=27&ccid=898604650119C1078512&imsi=460048590708512&v6=-00.000&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.001589s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009950s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055647586' LIMIT 1 [ RunTime:0.000644s ]
[ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055647586',`create_time`=1682497830,`v1`=0.01797,`v2`=0.016481,`v3`=0.015351,`v4`=-0.000151,`v5`=12.42,`t`=16.899981,`h`=77.496094,`rssi`=27,`ccid`='898604650119C1078512',`imsi`='460048590708512',`v6`=-0,`update_time`=1682497831 WHERE `imei` = '868922055647586' [ RunTime:0.000624s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010829s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055647586' , 1682497830 , 0.01797 , 0.016481 , 0.015351 , -0.000151 , 12.42 , 16.899981 , 77.496094 , 27 , '898604650119C1078512' , '460048590708512' , -0 , 1682497831) [ RunTime:0.000672s ]
---------------------------------------------------------------
[ 2023-04-26T16:43:18+08:00 ] 112.224.69.225 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055678110
[ sql ] [ DB ] CONNECT:[ UseTime:0.002289s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.013790s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055678110' LIMIT 1 [ RunTime:0.000784s ]
---------------------------------------------------------------
[ 2023-04-26T16:43:19+08:00 ] 112.224.69.225 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055678110&create_time=1682498598&v1=0.031154&v2=0.012726&v3=0.026458&v4=0.001294&v5=12.420000&t=16.610403&h=45.017761&rssi=25&ccid=89860118803392574452&imsi=460015788115318&v6=-00.000&gps=120.184850,35.985093&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.001882s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010182s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055678110' LIMIT 1 [ RunTime:0.000982s ]
[ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055678110',`create_time`=1682498598,`v1`=0.031154,`v2`=0.012726,`v3`=0.026458,`v4`=0.001294,`v5`=12.42,`t`=16.610403,`h`=45.017761,`rssi`=25,`ccid`='89860118803392574452',`imsi`='460015788115318',`v6`=-0,`gps`='120.184850,35.985093',`update_time`=1682498599 WHERE `imei` = '868922055678110' [ RunTime:0.000670s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010176s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `gps` , `update_time`) VALUES ('868922055678110' , 1682498598 , 0.031154 , 0.012726 , 0.026458 , 0.001294 , 12.42 , 16.610403 , 45.017761 , 25 , '89860118803392574452' , '460015788115318' , -0 , '120.184850,35.985093' , 1682498599) [ RunTime:0.001300s ]
---------------------------------------------------------------
[ 2023-04-26T17:10:02+08:00 ] 39.144.11.8 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922056976208
[ sql ] [ DB ] CONNECT:[ UseTime:0.002632s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011538s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922056976208' LIMIT 1 [ RunTime:0.000819s ]
---------------------------------------------------------------
[ 2023-04-26T17:10:03+08:00 ] 39.144.11.8 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922056976208&create_time=1682500202&v1=0.026819&v2=0.016689&v3=0.024953&v4=0.016164&v5=12.420000&t=16.857080&h=65.693420&rssi=28&ccid=898604650119C1053139&imsi=460048590503139&v6=-00.000&gps=120.184910,35.985474&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.001741s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010065s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922056976208' LIMIT 1 [ RunTime:0.000774s ]
[ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922056976208',`create_time`=1682500202,`v1`=0.026819,`v2`=0.016689,`v3`=0.024953,`v4`=0.016164,`v5`=12.42,`t`=16.85708,`h`=65.69342,`rssi`=28,`ccid`='898604650119C1053139',`imsi`='460048590503139',`v6`=-0,`gps`='120.184910,35.985474',`update_time`=1682500203 WHERE `imei` = '868922056976208' [ RunTime:0.000776s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011859s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `gps` , `update_time`) VALUES ('868922056976208' , 1682500202 , 0.026819 , 0.016689 , 0.024953 , 0.016164 , 12.42 , 16.85708 , 65.69342 , 28 , '898604650119C1053139' , '460048590503139' , -0 , '120.184910,35.985474' , 1682500203) [ RunTime:0.001358s ]
---------------------------------------------------------------
[ 2023-04-26T17:12:26+08:00 ] 111.55.141.98 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684209
[ sql ] [ DB ] CONNECT:[ UseTime:0.001839s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.008981s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684209' LIMIT 1 [ RunTime:0.000668s ]
---------------------------------------------------------------
[ 2023-04-26T17:12:27+08:00 ] 111.55.141.98 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055684209&create_time=1682500346&v1=0.019355&v2=0.019923&v3=0.015923&v4=-0.007134&v5=12.420000&t=16.792730&h=70.660156&rssi=28&ccid=898604650119C1078511&imsi=460048590708511&v6=-00.000&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.001746s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010205s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684209' LIMIT 1 [ RunTime:0.000710s ]
[ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684209',`create_time`=1682500346,`v1`=0.019355,`v2`=0.019923,`v3`=0.015923,`v4`=-0.007134,`v5`=12.42,`t`=16.79273,`h`=70.660156,`rssi`=28,`ccid`='898604650119C1078511',`imsi`='460048590708511',`v6`=-0,`update_time`=1682500347 WHERE `imei` = '868922055684209' [ RunTime:0.000620s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010957s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055684209' , 1682500346 , 0.019355 , 0.019923 , 0.015923 , -0.007134 , 12.42 , 16.79273 , 70.660156 , 28 , '898604650119C1078511' , '460048590708511' , -0 , 1682500347) [ RunTime:0.000525s ]
---------------------------------------------------------------
[ 2023-04-26T17:37:15+08:00 ] 117.132.192.70 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055683920
[ sql ] [ DB ] CONNECT:[ UseTime:0.011478s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011875s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055683920' LIMIT 1 [ RunTime:0.000802s ]
---------------------------------------------------------------
[ 2023-04-26T17:37:16+08:00 ] 117.132.192.70 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055683920&create_time=1682501835&v1=0.018391&v2=0.014290&v3=0.015472&v4=-0.004726&v5=12.420000&t=16.782005&h=68.348450&rssi=26&ccid=89860426102071188500&imsi=460044618415250&v6=-00.000&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.001774s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010970s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055683920' LIMIT 1 [ RunTime:0.000758s ]
[ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055683920',`create_time`=1682501835,`v1`=0.018391,`v2`=0.01429,`v3`=0.015472,`v4`=-0.004726,`v5`=12.42,`t`=16.782005,`h`=68.34845,`rssi`=26,`ccid`='89860426102071188500',`imsi`='460044618415250',`v6`=-0,`update_time`=1682501836 WHERE `imei` = '868922055683920' [ RunTime:0.000657s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.012422s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055683920' , 1682501835 , 0.018391 , 0.01429 , 0.015472 , -0.004726 , 12.42 , 16.782005 , 68.34845 , 26 , '89860426102071188500' , '460044618415250' , -0 , 1682501836) [ RunTime:0.001390s ]
---------------------------------------------------------------
[ 2023-04-26T17:46:55+08:00 ] 124.129.96.215 GET /admin/show/index.html?page=2
[ sql ] [ DB ] CONNECT:[ UseTime:0.002331s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010893s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000402s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 10,10 [ RunTime:0.001028s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001011s ]
---------------------------------------------------------------
[ 2023-04-26T20:24:48+08:00 ] 124.129.96.215 POST /admin/login/login.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.002298s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_manager` [ RunTime:0.011450s ]
[ sql ] [ SQL ] SELECT * FROM `collect_manager` WHERE `username` = 'admin' AND `password` = 'b8c6b861afec5f2a9a13ad8f963df1c7' LIMIT 1 [ RunTime:0.000652s ]
---------------------------------------------------------------
[ 2023-04-26T20:24:51+08:00 ] 124.129.96.215 GET /admin/show/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001722s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011751s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000382s ]
[ 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.000932s ]
---------------------------------------------------------------
[ 2023-04-26T20:24:55+08:00 ] 124.129.96.215 GET /admin/show/index.html?keyword=868922055683912
[ sql ] [ DB ] CONNECT:[ UseTime:0.001749s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009307s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `imei` LIKE '%868922055683912%' LIMIT 1 [ RunTime:0.000486s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` LIKE '%868922055683912%' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000640s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000984s ]
---------------------------------------------------------------
[ 2023-04-26T20:24:58+08:00 ] 124.129.96.215 GET /admin/show/edit/id/37.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001921s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010308s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 37 LIMIT 1 [ RunTime:0.000639s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.009914s ]
[ sql ] [ SQL ] SELECT * FROM `collect_user` WHERE `collect_user`.`delete_time` IS NULL [ RunTime:0.000469s ]
---------------------------------------------------------------
[ 2023-04-26T20:25:12+08:00 ] 124.129.96.215 POST /admin/show/update.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001933s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011028s ]
[ sql ] [ SQL ] UPDATE `collect_show` SET `device_name`='带gps测试5',`interval`=1440,`gps`='120.184885,35.985186',`username`='admin',`introduce`=' ',`update_time`=1682511912 WHERE `id` = 37 [ RunTime:0.000829s ]
---------------------------------------------------------------
[ 2023-04-26T20:25:13+08:00 ] 124.129.96.215 GET /admin/show/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001659s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010482s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000768s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000838s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000952s ]
---------------------------------------------------------------
[ 2023-04-26T20:26:57+08:00 ] 39.144.14.39 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055683912
[ sql ] [ DB ] CONNECT:[ UseTime:0.001929s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010986s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055683912' LIMIT 1 [ RunTime:0.000644s ]
---------------------------------------------------------------
[ 2023-04-26T20:26:58+08:00 ] 39.144.14.39 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055683912&create_time=1682512017&v1=0.031274&v2=0.013143&v3=0.028174&v4=0.008338&v5=12.600000&t=15.956172&h=72.613281&rssi=27&ccid=898604650119C1053138&imsi=460048590503138&v6=-00.000&gps=120.184908,35.985017&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.002253s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009681s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055683912' LIMIT 1 [ RunTime:0.000647s ]
[ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055683912',`create_time`=1682512017,`v1`=0.031274,`v2`=0.013143,`v3`=0.028174,`v4`=0.008338,`v5`=12.6,`t`=15.956172,`h`=72.613281,`rssi`=27,`ccid`='898604650119C1053138',`imsi`='460048590503138',`v6`=-0,`gps`='120.184908,35.985017',`update_time`=1682512018 WHERE `imei` = '868922055683912' [ RunTime:0.000538s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010709s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `gps` , `update_time`) VALUES ('868922055683912' , 1682512017 , 0.031274 , 0.013143 , 0.028174 , 0.008338 , 12.6 , 15.956172 , 72.613281 , 27 , '898604650119C1053138' , '460048590503138' , -0 , '120.184908,35.985017' , 1682512018) [ RunTime:0.002960s ]
---------------------------------------------------------------
[ 2023-04-26T20:28:12+08:00 ] 124.129.96.215 GET /admin/show/index.html?keyword=868922055683771
[ sql ] [ DB ] CONNECT:[ UseTime:0.001556s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009435s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `imei` LIKE '%868922055683771%' LIMIT 1 [ RunTime:0.000494s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` LIKE '%868922055683771%' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.001074s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001122s ]
---------------------------------------------------------------
[ 2023-04-26T20:28:14+08:00 ] 124.129.96.215 GET /admin/show/edit/id/40.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001941s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011072s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 40 LIMIT 1 [ RunTime:0.000748s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.010397s ]
[ sql ] [ SQL ] SELECT * FROM `collect_user` WHERE `collect_user`.`delete_time` IS NULL [ RunTime:0.000502s ]
---------------------------------------------------------------
[ 2023-04-26T20:28:26+08:00 ] 124.129.96.215 POST /admin/show/update.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001966s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010456s ]
[ sql ] [ SQL ] UPDATE `collect_show` SET `device_name`='带gps测试',`interval`=1440,`gps`='120.185240,35.987359',`username`='admin',`introduce`=' ',`update_time`=1682512106 WHERE `id` = 40 [ RunTime:0.000618s ]
---------------------------------------------------------------
[ 2023-04-26T20:28:27+08:00 ] 124.129.96.215 GET /admin/show/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.002161s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010588s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000394s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000859s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001604s ]
---------------------------------------------------------------
[ 2023-04-26T20:30:28+08:00 ] 39.144.18.201 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055683771
[ 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.011570s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055683771' LIMIT 1 [ RunTime:0.000680s ]
---------------------------------------------------------------
[ 2023-04-26T20:30:30+08:00 ] 39.144.18.201 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055683771&create_time=1682512228&v1=0.018452&v2=0.015855&v3=0.015472&v4=-0.016525&v5=12.420000&t=15.881096&h=73.772949&rssi=17&ccid=898604650119C1053136&imsi=460048590503136&v6=-00.000&gps=120.184876,35.985378&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.001717s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010015s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055683771' LIMIT 1 [ RunTime:0.000664s ]
[ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055683771',`create_time`=1682512228,`v1`=0.018452,`v2`=0.015855,`v3`=0.015472,`v4`=-0.016525,`v5`=12.42,`t`=15.881096,`h`=73.772949,`rssi`=17,`ccid`='898604650119C1053136',`imsi`='460048590503136',`v6`=-0,`gps`='120.184876,35.985378',`update_time`=1682512230 WHERE `imei` = '868922055683771' [ RunTime:0.000565s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010374s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `gps` , `update_time`) VALUES ('868922055683771' , 1682512228 , 0.018452 , 0.015855 , 0.015472 , -0.016525 , 12.42 , 15.881096 , 73.772949 , 17 , '898604650119C1053136' , '460048590503136' , -0 , '120.184876,35.985378' , 1682512230) [ RunTime:0.000642s ]
---------------------------------------------------------------
[ 2023-04-26T23:02:56+08:00 ] 124.129.96.215 GET /admin/show/index.html?keyword=868922055644021
[ sql ] [ DB ] CONNECT:[ UseTime:0.002149s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010623s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `imei` LIKE '%868922055644021%' LIMIT 1 [ RunTime:0.000490s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` LIKE '%868922055644021%' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000712s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000990s ]
---------------------------------------------------------------
[ 2023-04-26T23:02:59+08:00 ] 124.129.96.215 GET /admin/show/edit/id/41.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001843s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010581s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 41 LIMIT 1 [ RunTime:0.000753s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.012614s ]
[ sql ] [ SQL ] SELECT * FROM `collect_user` WHERE `collect_user`.`delete_time` IS NULL [ RunTime:0.000584s ]
---------------------------------------------------------------
[ 2023-04-26T23:03:08+08:00 ] 124.129.96.215 POST /admin/show/update.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001891s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009413s ]
[ sql ] [ SQL ] UPDATE `collect_show` SET `device_name`='带gps测试',`interval`=1440,`gps`='120.184036,35.983530',`username`='admin',`introduce`=' ',`update_time`=1682521388 WHERE `id` = 41 [ RunTime:0.000937s ]
---------------------------------------------------------------
[ 2023-04-26T23:03:12+08:00 ] 124.129.96.215 GET /admin/show/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001615s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009839s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000355s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000829s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000998s ]
---------------------------------------------------------------
[ 2023-04-26T23:07:50+08:00 ] 39.144.5.15 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644021
[ sql ] [ DB ] CONNECT:[ UseTime:0.002979s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011120s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644021' LIMIT 1 [ RunTime:0.000654s ]
---------------------------------------------------------------
[ 2023-04-26T23:07:52+08:00 ] 39.144.5.15 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055644021&create_time=1682521670&v1=0.006291&v2=0.014916&v3=0.004154&v4=-0.015863&v5=12.420000&t=15.881096&h=72.239441&rssi=13&ccid=898604650119C1053141&imsi=460048590503141&v6=-00.000&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.001803s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010173s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644021' LIMIT 1 [ RunTime:0.000682s ]
[ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644021',`create_time`=1682521670,`v1`=0.006291,`v2`=0.014916,`v3`=0.004154,`v4`=-0.015863,`v5`=12.42,`t`=15.881096,`h`=72.239441,`rssi`=13,`ccid`='898604650119C1053141',`imsi`='460048590503141',`v6`=-0,`update_time`=1682521672 WHERE `imei` = '868922055644021' [ RunTime:0.000545s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011724s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055644021' , 1682521670 , 0.006291 , 0.014916 , 0.004154 , -0.015863 , 12.42 , 15.881096 , 72.239441 , 13 , '898604650119C1053141' , '460048590503141' , -0 , 1682521672) [ RunTime:0.000666s ]
---------------------------------------------------------------
[ 2023-04-26T23:08:29+08:00 ] 124.129.96.215 GET /admin/show/index.html?keyword=868922055684548
[ sql ] [ DB ] CONNECT:[ UseTime:0.001592s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010189s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `imei` LIKE '%868922055684548%' LIMIT 1 [ RunTime:0.000568s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` LIKE '%868922055684548%' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.001050s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001293s ]
---------------------------------------------------------------
[ 2023-04-26T23:08:32+08:00 ] 124.129.96.215 GET /admin/show/edit/id/39.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001764s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010267s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 39 LIMIT 1 [ RunTime:0.000632s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.008826s ]
[ sql ] [ SQL ] SELECT * FROM `collect_user` WHERE `collect_user`.`delete_time` IS NULL [ RunTime:0.000470s ]
---------------------------------------------------------------
[ 2023-04-26T23:08:39+08:00 ] 124.129.96.215 POST /admin/show/update.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.002498s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011452s ]
[ sql ] [ SQL ] UPDATE `collect_show` SET `device_name`='带gps测试',`interval`=1440,`gps`='120.184792,35.985373',`username`='admin',`introduce`=' ',`update_time`=1682521719 WHERE `id` = 39 [ RunTime:0.000786s ]
---------------------------------------------------------------
[ 2023-04-26T23:08:40+08:00 ] 124.129.96.215 GET /admin/show/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.002713s ] 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 COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000450s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000968s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001151s ]
---------------------------------------------------------------
[ 2023-04-26T23:10:52+08:00 ] 111.55.139.214 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684548
[ sql ] [ DB ] CONNECT:[ UseTime:0.002016s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010953s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684548' LIMIT 1 [ RunTime:0.000647s ]
---------------------------------------------------------------
[ 2023-04-26T23:10:54+08:00 ] 111.55.139.214 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055684548&create_time=1682521852&v1=0.016104&v2=0.017002&v3=0.013365&v4=-0.011769&v5=12.420000&t=16.074148&h=68.157715&rssi=28&ccid=898604650119C1053137&imsi=460048590503137&v6=-00.000&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.001721s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010571s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684548' LIMIT 1 [ RunTime:0.000652s ]
[ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684548',`create_time`=1682521852,`v1`=0.016104,`v2`=0.017002,`v3`=0.013365,`v4`=-0.011769,`v5`=12.42,`t`=16.074148,`h`=68.157715,`rssi`=28,`ccid`='898604650119C1053137',`imsi`='460048590503137',`v6`=-0,`update_time`=1682521854 WHERE `imei` = '868922055684548' [ RunTime:0.000956s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010990s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055684548' , 1682521852 , 0.016104 , 0.017002 , 0.013365 , -0.011769 , 12.42 , 16.074148 , 68.157715 , 28 , '898604650119C1053137' , '460048590503137' , -0 , 1682521854) [ RunTime:0.000523s ]
---------------------------------------------------------------
[ 2023-04-26T23:18:07+08:00 ] 124.129.96.215 GET /admin/show/index.html?keyword=868922056976109
[ sql ] [ DB ] CONNECT:[ UseTime:0.002251s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012351s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `imei` LIKE '%868922056976109%' LIMIT 1 [ RunTime:0.000513s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` LIKE '%868922056976109%' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000752s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001016s ]
---------------------------------------------------------------
[ 2023-04-26T23:18:09+08:00 ] 124.129.96.215 GET /admin/show/edit/id/43.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001693s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009693s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 43 LIMIT 1 [ RunTime:0.000690s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.011550s ]
[ sql ] [ SQL ] SELECT * FROM `collect_user` WHERE `collect_user`.`delete_time` IS NULL [ RunTime:0.000475s ]
---------------------------------------------------------------
[ 2023-04-26T23:18:16+08:00 ] 124.129.96.215 POST /admin/show/update.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001768s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009937s ]
[ sql ] [ SQL ] UPDATE `collect_show` SET `device_name`='带gps测试',`interval`=1440,`gps`='120.185208,35.987074',`username`='admin',`introduce`=' ',`update_time`=1682522296 WHERE `id` = 43 [ RunTime:0.000678s ]
---------------------------------------------------------------
[ 2023-04-26T23:18:17+08:00 ] 124.129.96.215 GET /admin/show/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.002450s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011184s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000342s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000904s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001033s ]
---------------------------------------------------------------
[ 2023-04-26T23:22:00+08:00 ] 124.129.96.215 GET /admin/show/index.html?keyword=868922056976109
[ sql ] [ DB ] CONNECT:[ UseTime:0.002122s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010879s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `imei` LIKE '%868922056976109%' LIMIT 1 [ RunTime:0.000543s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` LIKE '%868922056976109%' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000818s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001762s ]
---------------------------------------------------------------
[ 2023-04-26T23:24:29+08:00 ] 39.144.3.250 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055680850
[ sql ] [ DB ] CONNECT:[ UseTime:0.002408s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010157s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055680850' LIMIT 1 [ RunTime:0.000672s ]
---------------------------------------------------------------
[ 2023-04-26T23:24:30+08:00 ] 39.144.3.250 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055680850&create_time=1682522669&v1=0.020799&v2=0.013977&v3=0.017850&v4=-0.006171&v5=12.420000&t=16.235023&h=71.674866&rssi=26&ccid=898604650119C1078510&imsi=460048590708510&v6=-00.000&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.001662s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010102s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055680850' LIMIT 1 [ RunTime:0.000679s ]
[ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055680850',`create_time`=1682522669,`v1`=0.020799,`v2`=0.013977,`v3`=0.01785,`v4`=-0.006171,`v5`=12.42,`t`=16.235023,`h`=71.674866,`rssi`=26,`ccid`='898604650119C1078510',`imsi`='460048590708510',`v6`=-0,`update_time`=1682522670 WHERE `imei` = '868922055680850' [ RunTime:0.000628s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010957s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055680850' , 1682522669 , 0.020799 , 0.013977 , 0.01785 , -0.006171 , 12.42 , 16.235023 , 71.674866 , 26 , '898604650119C1078510' , '460048590708510' , -0 , 1682522670) [ RunTime:0.002284s ]
---------------------------------------------------------------
[ 2023-04-26T23:24:59+08:00 ] 124.129.96.215 GET /admin/show/index.html?keyword=868922055680850
[ sql ] [ DB ] CONNECT:[ UseTime:0.001464s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009717s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `imei` LIKE '%868922055680850%' LIMIT 1 [ RunTime:0.000487s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` LIKE '%868922055680850%' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000720s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001165s ]
---------------------------------------------------------------
[ 2023-04-26T23:25:01+08:00 ] 124.129.96.215 GET /admin/show/edit/id/45.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.003727s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010955s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 45 LIMIT 1 [ RunTime:0.001264s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.010100s ]
[ sql ] [ SQL ] SELECT * FROM `collect_user` WHERE `collect_user`.`delete_time` IS NULL [ RunTime:0.000479s ]
---------------------------------------------------------------
[ 2023-04-26T23:25:08+08:00 ] 124.129.96.215 POST /admin/show/update.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001416s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010561s ]
[ sql ] [ SQL ] UPDATE `collect_show` SET `device_name`='带gps测试',`interval`=1440,`gps`='120.184835,35.985091',`username`='admin',`introduce`=' ',`update_time`=1682522708 WHERE `id` = 45 [ RunTime:0.001028s ]
---------------------------------------------------------------
[ 2023-04-26T23:25:09+08:00 ] 124.129.96.215 GET /admin/show/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001926s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010551s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000393s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000906s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001079s ]
---------------------------------------------------------------
[ 2023-04-26T23:25:20+08:00 ] 124.129.96.215 GET /admin/show/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001908s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011552s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000414s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000949s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001111s ]
---------------------------------------------------------------
[ 2023-04-26T23:25:35+08:00 ] 124.129.96.215 GET /admin/show/index.html?page=2
[ sql ] [ DB ] CONNECT:[ UseTime:0.001982s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011008s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000412s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 10,10 [ RunTime:0.001139s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001142s ]
---------------------------------------------------------------
[ 2023-04-26T23:25:48+08:00 ] 124.129.96.215 GET /admin/show/index.html?page=1
[ sql ] [ DB ] CONNECT:[ UseTime:0.001719s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010039s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000410s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000906s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000993s ]
---------------------------------------------------------------
[ 2023-04-26T23:25:57+08:00 ] 124.129.96.215 GET /admin/show/index.html?page=3
[ sql ] [ DB ] CONNECT:[ UseTime:0.001895s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010462s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000407s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 20,10 [ RunTime:0.001032s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001048s ]
---------------------------------------------------------------
[ 2023-04-26T23:26:00+08:00 ] 124.129.96.215 GET /admin/show/index.html?page=2
[ sql ] [ DB ] CONNECT:[ UseTime:0.002063s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011500s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000357s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 10,10 [ RunTime:0.001257s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001706s ]
---------------------------------------------------------------
[ 2023-04-26T23:28:30+08:00 ] 117.132.191.196 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055680850
[ sql ] [ DB ] CONNECT:[ UseTime:0.001732s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009826s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055680850' LIMIT 1 [ RunTime:0.000660s ]
---------------------------------------------------------------
[ 2023-04-26T23:28:31+08:00 ] 117.132.191.196 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055680850&create_time=1682522910&v1=0.020799&v2=0.013247&v3=0.017910&v4=-0.006833&v5=12.420000&t=17.404060&h=71.018738&rssi=28&ccid=898604650119C1078510&imsi=460048590708510&v6=-00.000&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.001796s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011048s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055680850' LIMIT 1 [ RunTime:0.000705s ]
[ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055680850',`create_time`=1682522910,`v1`=0.020799,`v2`=0.013247,`v3`=0.01791,`v4`=-0.006833,`v5`=12.42,`t`=17.40406,`h`=71.018738,`rssi`=28,`ccid`='898604650119C1078510',`imsi`='460048590708510',`v6`=-0,`update_time`=1682522911 WHERE `imei` = '868922055680850' [ RunTime:0.000599s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.013120s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055680850' , 1682522910 , 0.020799 , 0.013247 , 0.01791 , -0.006833 , 12.42 , 17.40406 , 71.018738 , 28 , '898604650119C1078510' , '460048590708510' , -0 , 1682522911) [ RunTime:0.000555s ]