---------------------------------------------------------------
[ 2022-10-31T00:03:58+08:00 ] 39.144.6.120 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013
[ sql ] [ DB ] CONNECT:[ UseTime:0.002458s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011461s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000730s ]
---------------------------------------------------------------
[ 2022-10-31T00:03:58+08:00 ] 39.144.18.152 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055643643
[ sql ] [ DB ] CONNECT:[ UseTime:0.001831s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009558s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000624s ]
---------------------------------------------------------------
[ 2022-10-31T00:04:06+08:00 ] 39.144.6.120 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=221031&time=000301&v1=-00.716&v2=+00.001&v3=-00.591&v4=+00.026&v5=05.9&t=+12.6&h=59.2&rssi=+223&ccid=4600485905031430000099m9990000000080000000g7910,N,00E000=-00.000&a1=00.000&a2=00.000&a3=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.010078s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000691s ]
[ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644013',`date`='221031',`time`='000301',`v1`=-0.716,`v2`=0.001,`v3`=-0.591,`v4`=0.026,`v5`=5.9,`t`=12.6,`h`=59.2,`rssi`=223,`ccid`='4600485905031430000099m9990000000080000000g7910,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1667145846 WHERE `imei` = '868922055644013' [ RunTime:0.000623s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011024s ]
[ 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' , '221031' , '000301' , -0.716 , 0.001 , -0.591 , 0.026 , 5.9 , 12.6 , 59.2 , 223 , '4600485905031430000099m9990000000080000000g7910,N,00E000=-00.000' , 0 , 0 , 1667145846 , 1667145846) [ RunTime:0.001364s ]
---------------------------------------------------------------
[ 2022-10-31T00:04:07+08:00 ] 39.144.18.152 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055643643&date=221031&time=000301&v1=-01.047&v2=+00.031&v3=-00.989&v4=-00.041&v5=06.2&t=+12.1&h=55.6&rssi=+229&ccid=4600485905031420000099m9990000000053000001g0680,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$
[ 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.008448s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000600s ]
[ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055643643',`date`='221031',`time`='000301',`v1`=-1.047,`v2`=0.031,`v3`=-0.989,`v4`=-0.041,`v5`=6.2,`t`=12.1,`h`=55.6,`rssi`=229,`ccid`='4600485905031420000099m9990000000053000001g0680,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1667145847 WHERE `imei` = '868922055643643' [ RunTime:0.000929s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009796s ]
[ 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' , '221031' , '000301' , -1.047 , 0.031 , -0.989 , -0.041 , 6.2 , 12.1 , 55.6 , 229 , '4600485905031420000099m9990000000053000001g0680,N,00E000=-00.000' , 0 , 0 , 1667145847 , 1667145847) [ RunTime:0.000473s ]
---------------------------------------------------------------
[ 2022-10-31T01:03:57+08:00 ] 39.144.4.65 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013
[ sql ] [ DB ] CONNECT:[ UseTime:0.002477s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009257s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000626s ]
---------------------------------------------------------------
[ 2022-10-31T01:03:58+08:00 ] 221.178.127.139 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055643643
[ sql ] [ DB ] CONNECT:[ UseTime:0.001353s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.008219s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000700s ]
---------------------------------------------------------------
[ 2022-10-31T01:04:06+08:00 ] 39.144.4.65 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=221031&time=010301&v1=-00.716&v2=+00.001&v3=-00.571&v4=+00.026&v5=05.9&t=+12.4&h=59.2&rssi=+223&ccid=4600485905031430000099m9990000000077000000g7870,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.001595s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009512s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000680s ]
[ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644013',`date`='221031',`time`='010301',`v1`=-0.716,`v2`=0.001,`v3`=-0.571,`v4`=0.026,`v5`=5.9,`t`=12.4,`h`=59.2,`rssi`=223,`ccid`='4600485905031430000099m9990000000077000000g7870,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1667149446 WHERE `imei` = '868922055644013' [ RunTime:0.000533s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010652s ]
[ 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' , '221031' , '010301' , -0.716 , 0.001 , -0.571 , 0.026 , 5.9 , 12.4 , 59.2 , 223 , '4600485905031430000099m9990000000077000000g7870,N,00E000=-00.000' , 0 , 0 , 1667149446 , 1667149446) [ RunTime:0.000646s ]
---------------------------------------------------------------
[ 2022-10-31T01:04:06+08:00 ] 221.178.127.139 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055643643&date=221031&time=010301&v1=-01.048&v2=+00.032&v3=-00.989&v4=-00.041&v5=05.7&t=+11.8&h=55.6&rssi=+229&ccid=4600485905031420000099m9990000000054000001g0690,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.001434s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010766s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000610s ]
[ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055643643',`date`='221031',`time`='010301',`v1`=-1.048,`v2`=0.032,`v3`=-0.989,`v4`=-0.041,`v5`=5.7,`t`=11.8,`h`=55.6,`rssi`=229,`ccid`='4600485905031420000099m9990000000054000001g0690,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1667149446 WHERE `imei` = '868922055643643' [ RunTime:0.000513s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010185s ]
[ 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' , '221031' , '010301' , -1.048 , 0.032 , -0.989 , -0.041 , 5.7 , 11.8 , 55.6 , 229 , '4600485905031420000099m9990000000054000001g0690,N,00E000=-00.000' , 0 , 0 , 1667149446 , 1667149446) [ RunTime:0.000514s ]
---------------------------------------------------------------
[ 2022-10-31T02:03:58+08:00 ] 39.144.17.169 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055643643
[ sql ] [ DB ] CONNECT:[ UseTime:0.002294s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010807s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000677s ]
---------------------------------------------------------------
[ 2022-10-31T02:03:58+08:00 ] 39.144.6.4 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013
[ sql ] [ DB ] CONNECT:[ UseTime:0.001611s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.008617s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000592s ]
---------------------------------------------------------------
[ 2022-10-31T02:04:06+08:00 ] 39.144.17.169 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055643643&date=221031&time=020301&v1=-01.048&v2=+00.029&v3=-00.988&v4=-00.041&v5=06.2&t=+11.8&h=55.5&rssi=+229&ccid=4600485905031420000099m9990000000057000001g0690,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.001760s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010041s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000629s ]
[ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055643643',`date`='221031',`time`='020301',`v1`=-1.048,`v2`=0.029,`v3`=-0.988,`v4`=-0.041,`v5`=6.2,`t`=11.8,`h`=55.5,`rssi`=229,`ccid`='4600485905031420000099m9990000000057000001g0690,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1667153046 WHERE `imei` = '868922055643643' [ RunTime:0.000569s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009990s ]
[ 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' , '221031' , '020301' , -1.048 , 0.029 , -0.988 , -0.041 , 6.2 , 11.8 , 55.5 , 229 , '4600485905031420000099m9990000000057000001g0690,N,00E000=-00.000' , 0 , 0 , 1667153046 , 1667153046) [ RunTime:0.000604s ]
---------------------------------------------------------------
[ 2022-10-31T02:04:07+08:00 ] 39.144.6.4 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=221031&time=020301&v1=-00.724&v2=+00.001&v3=-00.347&v4=+00.018&v5=05.9&t=+12.2&h=59.2&rssi=+225&ccid=4600485905031430000099m9990000000096000000g7860,N,00E000=-00.000&a1=00.000&a2=00.000&a3=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.009445s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000623s ]
[ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644013',`date`='221031',`time`='020301',`v1`=-0.724,`v2`=0.001,`v3`=-0.347,`v4`=0.018,`v5`=5.9,`t`=12.2,`h`=59.2,`rssi`=225,`ccid`='4600485905031430000099m9990000000096000000g7860,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1667153047 WHERE `imei` = '868922055644013' [ RunTime:0.000502s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010497s ]
[ 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' , '221031' , '020301' , -0.724 , 0.001 , -0.347 , 0.018 , 5.9 , 12.2 , 59.2 , 225 , '4600485905031430000099m9990000000096000000g7860,N,00E000=-00.000' , 0 , 0 , 1667153047 , 1667153047) [ RunTime:0.000491s ]
---------------------------------------------------------------
[ 2022-10-31T03:03:57+08:00 ] 39.144.4.91 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055643643
[ sql ] [ DB ] CONNECT:[ UseTime:0.002412s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.013153s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000840s ]
---------------------------------------------------------------
[ 2022-10-31T03:03:58+08:00 ] 221.178.127.134 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013
[ sql ] [ DB ] CONNECT:[ UseTime:0.001587s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011823s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000781s ]
---------------------------------------------------------------
[ 2022-10-31T03:04:06+08:00 ] 39.144.4.91 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055643643&date=221031&time=030301&v1=-01.049&v2=+00.032&v3=-00.988&v4=-00.040&v5=06.2&t=+11.6&h=55.5&rssi=+229&ccid=4600485905031420000099m9990000000056000001g0690,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.001400s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009659s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000677s ]
[ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055643643',`date`='221031',`time`='030301',`v1`=-1.049,`v2`=0.032,`v3`=-0.988,`v4`=-0.04,`v5`=6.2,`t`=11.6,`h`=55.5,`rssi`=229,`ccid`='4600485905031420000099m9990000000056000001g0690,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1667156646 WHERE `imei` = '868922055643643' [ RunTime:0.000628s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010791s ]
[ 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' , '221031' , '030301' , -1.049 , 0.032 , -0.988 , -0.04 , 6.2 , 11.6 , 55.5 , 229 , '4600485905031420000099m9990000000056000001g0690,N,00E000=-00.000' , 0 , 0 , 1667156646 , 1667156646) [ RunTime:0.000570s ]
---------------------------------------------------------------
[ 2022-10-31T03:04:06+08:00 ] 221.178.127.134 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=221031&time=030301&v1=-00.675&v2=+00.001&v3=-00.586&v4=+00.026&v5=05.9&t=+12.0&h=59.2&rssi=+223&ccid=4600485905031430000099m9990000000080000000g7540,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.001417s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.021977s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000634s ]
[ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644013',`date`='221031',`time`='030301',`v1`=-0.675,`v2`=0.001,`v3`=-0.586,`v4`=0.026,`v5`=5.9,`t`=12,`h`=59.2,`rssi`=223,`ccid`='4600485905031430000099m9990000000080000000g7540,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1667156646 WHERE `imei` = '868922055644013' [ RunTime:0.000501s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009833s ]
[ 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' , '221031' , '030301' , -0.675 , 0.001 , -0.586 , 0.026 , 5.9 , 12 , 59.2 , 223 , '4600485905031430000099m9990000000080000000g7540,N,00E000=-00.000' , 0 , 0 , 1667156646 , 1667156646) [ RunTime:0.000525s ]
---------------------------------------------------------------
[ 2022-10-31T04:03:58+08:00 ] 39.144.3.161 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013
[ sql ] [ DB ] CONNECT:[ UseTime:0.002407s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010485s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000681s ]
---------------------------------------------------------------
[ 2022-10-31T04:03:58+08:00 ] 39.144.13.146 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055643643
[ sql ] [ DB ] CONNECT:[ UseTime:0.001626s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.008674s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000633s ]
---------------------------------------------------------------
[ 2022-10-31T04:04:06+08:00 ] 39.144.3.161 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=221031&time=040301&v1=-00.686&v2=+00.001&v3=-00.529&v4=+00.024&v5=05.9&t=+11.7&h=59.3&rssi=+224&ccid=4600485905031430000099m9990000000089000000g7610,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.001427s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009281s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000659s ]
[ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644013',`date`='221031',`time`='040301',`v1`=-0.686,`v2`=0.001,`v3`=-0.529,`v4`=0.024,`v5`=5.9,`t`=11.7,`h`=59.3,`rssi`=224,`ccid`='4600485905031430000099m9990000000089000000g7610,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1667160246 WHERE `imei` = '868922055644013' [ RunTime:0.000594s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011339s ]
[ 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' , '221031' , '040301' , -0.686 , 0.001 , -0.529 , 0.024 , 5.9 , 11.7 , 59.3 , 224 , '4600485905031430000099m9990000000089000000g7610,N,00E000=-00.000' , 0 , 0 , 1667160246 , 1667160246) [ RunTime:0.000928s ]
---------------------------------------------------------------
[ 2022-10-31T04:04:07+08:00 ] 39.144.13.146 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055643643&date=221031&time=040301&v1=-01.050&v2=+00.029&v3=-00.988&v4=-00.041&v5=06.2&t=+11.3&h=55.5&rssi=+229&ccid=4600485905031420000099m9990000000057000001g0700,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.001368s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010074s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000572s ]
[ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055643643',`date`='221031',`time`='040301',`v1`=-1.05,`v2`=0.029,`v3`=-0.988,`v4`=-0.041,`v5`=6.2,`t`=11.3,`h`=55.5,`rssi`=229,`ccid`='4600485905031420000099m9990000000057000001g0700,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1667160247 WHERE `imei` = '868922055643643' [ RunTime:0.000461s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010077s ]
[ 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' , '221031' , '040301' , -1.05 , 0.029 , -0.988 , -0.041 , 6.2 , 11.3 , 55.5 , 229 , '4600485905031420000099m9990000000057000001g0700,N,00E000=-00.000' , 0 , 0 , 1667160247 , 1667160247) [ RunTime:0.000483s ]
---------------------------------------------------------------
[ 2022-10-31T05:03:57+08:00 ] 221.178.126.42 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013
[ sql ] [ DB ] CONNECT:[ UseTime:0.002293s ] 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 * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000639s ]
---------------------------------------------------------------
[ 2022-10-31T05:03:58+08:00 ] 39.144.6.243 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055643643
[ sql ] [ DB ] CONNECT:[ UseTime:0.001610s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009392s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000614s ]
---------------------------------------------------------------
[ 2022-10-31T05:04:06+08:00 ] 221.178.126.42 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=221031&time=050301&v1=-00.647&v2=+00.001&v3=-00.575&v4=+00.026&v5=05.9&t=+11.6&h=59.1&rssi=+224&ccid=4600485905031430000099m9990000000077000000g7250,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.001428s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009224s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000691s ]
[ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644013',`date`='221031',`time`='050301',`v1`=-0.647,`v2`=0.001,`v3`=-0.575,`v4`=0.026,`v5`=5.9,`t`=11.6,`h`=59.1,`rssi`=224,`ccid`='4600485905031430000099m9990000000077000000g7250,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1667163846 WHERE `imei` = '868922055644013' [ RunTime:0.000844s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011113s ]
[ 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' , '221031' , '050301' , -0.647 , 0.001 , -0.575 , 0.026 , 5.9 , 11.6 , 59.1 , 224 , '4600485905031430000099m9990000000077000000g7250,N,00E000=-00.000' , 0 , 0 , 1667163846 , 1667163846) [ RunTime:0.000597s ]
---------------------------------------------------------------
[ 2022-10-31T05:04:06+08:00 ] 39.144.6.243 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055643643&date=221031&time=050301&v1=-01.050&v2=+00.029&v3=-00.987&v4=-00.041&v5=06.2&t=+11.2&h=55.5&rssi=+229&ccid=4600485905031420000099m9990000000059000001g0700,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.001437s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010224s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000659s ]
[ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055643643',`date`='221031',`time`='050301',`v1`=-1.05,`v2`=0.029,`v3`=-0.987,`v4`=-0.041,`v5`=6.2,`t`=11.2,`h`=55.5,`rssi`=229,`ccid`='4600485905031420000099m9990000000059000001g0700,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1667163846 WHERE `imei` = '868922055643643' [ RunTime:0.000526s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009224s ]
[ 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' , '221031' , '050301' , -1.05 , 0.029 , -0.987 , -0.041 , 6.2 , 11.2 , 55.5 , 229 , '4600485905031420000099m9990000000059000001g0700,N,00E000=-00.000' , 0 , 0 , 1667163846 , 1667163846) [ RunTime:0.000530s ]
---------------------------------------------------------------
[ 2022-10-31T06:03:58+08:00 ] 39.144.2.180 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055643643
[ sql ] [ DB ] CONNECT:[ UseTime:0.002265s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010483s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000659s ]
---------------------------------------------------------------
[ 2022-10-31T06:03:58+08:00 ] 117.132.195.182 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013
[ sql ] [ DB ] CONNECT:[ UseTime:0.001928s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.008942s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000578s ]
---------------------------------------------------------------
[ 2022-10-31T06:04:06+08:00 ] 39.144.2.180 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055643643&date=221031&time=060301&v1=-01.050&v2=+00.033&v3=-00.987&v4=-00.041&v5=06.2&t=+11.2&h=55.5&rssi=+229&ccid=4600485905031420000099m9990000000060000001g0710,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.001461s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009306s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000633s ]
[ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055643643',`date`='221031',`time`='060301',`v1`=-1.05,`v2`=0.033,`v3`=-0.987,`v4`=-0.041,`v5`=6.2,`t`=11.2,`h`=55.5,`rssi`=229,`ccid`='4600485905031420000099m9990000000060000001g0710,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1667167446 WHERE `imei` = '868922055643643' [ RunTime:0.000882s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010130s ]
[ 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' , '221031' , '060301' , -1.05 , 0.033 , -0.987 , -0.041 , 6.2 , 11.2 , 55.5 , 229 , '4600485905031420000099m9990000000060000001g0710,N,00E000=-00.000' , 0 , 0 , 1667167446 , 1667167446) [ RunTime:0.000644s ]
---------------------------------------------------------------
[ 2022-10-31T06:04:07+08:00 ] 117.132.195.182 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=221031&time=060301&v1=-00.637&v2=+00.001&v3=-00.573&v4=+00.026&v5=05.9&t=+11.6&h=59.1&rssi=+224&ccid=4600485905031430000099m9990000000074000000g7140,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.001574s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011087s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000745s ]
[ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644013',`date`='221031',`time`='060301',`v1`=-0.637,`v2`=0.001,`v3`=-0.573,`v4`=0.026,`v5`=5.9,`t`=11.6,`h`=59.1,`rssi`=224,`ccid`='4600485905031430000099m9990000000074000000g7140,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1667167447 WHERE `imei` = '868922055644013' [ RunTime:0.000533s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.008993s ]
[ 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' , '221031' , '060301' , -0.637 , 0.001 , -0.573 , 0.026 , 5.9 , 11.6 , 59.1 , 224 , '4600485905031430000099m9990000000074000000g7140,N,00E000=-00.000' , 0 , 0 , 1667167447 , 1667167447) [ RunTime:0.000520s ]
---------------------------------------------------------------
[ 2022-10-31T07:03:57+08:00 ] 117.132.193.59 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055643643
[ sql ] [ DB ] CONNECT:[ UseTime:0.002091s ] 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` = '868922055643643' LIMIT 1 [ RunTime:0.000690s ]
---------------------------------------------------------------
[ 2022-10-31T07:03:58+08:00 ] 117.132.198.40 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013
[ sql ] [ DB ] CONNECT:[ UseTime:0.001376s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009861s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000637s ]
---------------------------------------------------------------
[ 2022-10-31T07:04:06+08:00 ] 117.132.193.59 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055643643&date=221031&time=070301&v1=-01.051&v2=+00.030&v3=-00.987&v4=-00.040&v5=06.2&t=+10.6&h=55.6&rssi=+231&ccid=4600485905031420000099m9990000000060000001g0710,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$
[ 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.012828s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000616s ]
[ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055643643',`date`='221031',`time`='070301',`v1`=-1.051,`v2`=0.03,`v3`=-0.987,`v4`=-0.04,`v5`=6.2,`t`=10.6,`h`=55.6,`rssi`=231,`ccid`='4600485905031420000099m9990000000060000001g0710,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1667171046 WHERE `imei` = '868922055643643' [ RunTime:0.000546s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010570s ]
[ 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' , '221031' , '070301' , -1.051 , 0.03 , -0.987 , -0.04 , 6.2 , 10.6 , 55.6 , 231 , '4600485905031420000099m9990000000060000001g0710,N,00E000=-00.000' , 0 , 0 , 1667171046 , 1667171046) [ RunTime:0.000776s ]
---------------------------------------------------------------
[ 2022-10-31T07:04:06+08:00 ] 117.132.198.40 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=221031&time=070301&v1=-00.617&v2=+00.001&v3=-00.558&v4=+00.024&v5=05.4&t=+11.2&h=59.3&rssi=+225&ccid=4600485905031430000099m9990000000073000000g6930,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.001396s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009319s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000616s ]
[ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644013',`date`='221031',`time`='070301',`v1`=-0.617,`v2`=0.001,`v3`=-0.558,`v4`=0.024,`v5`=5.4,`t`=11.2,`h`=59.3,`rssi`=225,`ccid`='4600485905031430000099m9990000000073000000g6930,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1667171046 WHERE `imei` = '868922055644013' [ RunTime:0.000439s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009654s ]
[ 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' , '221031' , '070301' , -0.617 , 0.001 , -0.558 , 0.024 , 5.4 , 11.2 , 59.3 , 225 , '4600485905031430000099m9990000000073000000g6930,N,00E000=-00.000' , 0 , 0 , 1667171046 , 1667171046) [ RunTime:0.000499s ]
---------------------------------------------------------------
[ 2022-10-31T08:03:58+08:00 ] 39.144.7.217 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013
[ sql ] [ DB ] CONNECT:[ UseTime:0.002198s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011480s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000671s ]
---------------------------------------------------------------
[ 2022-10-31T08:03:58+08:00 ] 39.144.10.44 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055643643
[ sql ] [ DB ] CONNECT:[ UseTime:0.001543s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010969s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000676s ]
---------------------------------------------------------------
[ 2022-10-31T08:04:06+08:00 ] 39.144.7.217 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=221031&time=080301&v1=-00.652&v2=+00.001&v3=-00.587&v4=+00.028&v5=05.9&t=+11.5&h=58.9&rssi=+225&ccid=4600485905031430000099m9990000000086000000g7320,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.001371s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010644s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000605s ]
[ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644013',`date`='221031',`time`='080301',`v1`=-0.652,`v2`=0.001,`v3`=-0.587,`v4`=0.028,`v5`=5.9,`t`=11.5,`h`=58.9,`rssi`=225,`ccid`='4600485905031430000099m9990000000086000000g7320,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1667174646 WHERE `imei` = '868922055644013' [ RunTime:0.000539s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010423s ]
[ 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' , '221031' , '080301' , -0.652 , 0.001 , -0.587 , 0.028 , 5.9 , 11.5 , 58.9 , 225 , '4600485905031430000099m9990000000086000000g7320,N,00E000=-00.000' , 0 , 0 , 1667174646 , 1667174646) [ RunTime:0.000591s ]
---------------------------------------------------------------
[ 2022-10-31T08:04:07+08:00 ] 39.144.10.44 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055643643&date=221031&time=080301&v1=-01.052&v2=+00.066&v3=-00.988&v4=-00.040&v5=06.2&t=+10.9&h=55.4&rssi=+229&ccid=4600485905031420000099m9990000000060000001g0710,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.001334s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009366s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000608s ]
[ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055643643',`date`='221031',`time`='080301',`v1`=-1.052,`v2`=0.066,`v3`=-0.988,`v4`=-0.04,`v5`=6.2,`t`=10.9,`h`=55.4,`rssi`=229,`ccid`='4600485905031420000099m9990000000060000001g0710,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1667174647 WHERE `imei` = '868922055643643' [ RunTime:0.000463s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009963s ]
[ 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' , '221031' , '080301' , -1.052 , 0.066 , -0.988 , -0.04 , 6.2 , 10.9 , 55.4 , 229 , '4600485905031420000099m9990000000060000001g0710,N,00E000=-00.000' , 0 , 0 , 1667174647 , 1667174647) [ RunTime:0.000475s ]
---------------------------------------------------------------
[ 2022-10-31T09:03:57+08:00 ] 39.144.16.16 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013
[ sql ] [ DB ] CONNECT:[ UseTime:0.002282s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010301s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000643s ]
---------------------------------------------------------------
[ 2022-10-31T09:03:58+08:00 ] 39.144.15.136 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055643643
[ sql ] [ DB ] CONNECT:[ UseTime:0.001317s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009577s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000606s ]
---------------------------------------------------------------
[ 2022-10-31T09:04:06+08:00 ] 39.144.16.16 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=221031&time=090301&v1=-00.709&v2=+00.001&v3=-00.631&v4=+00.026&v5=05.9&t=+14.0&h=57.8&rssi=+225&ccid=4600485905031430000099m9990000000069000000g7810,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.001707s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009614s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000626s ]
[ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644013',`date`='221031',`time`='090301',`v1`=-0.709,`v2`=0.001,`v3`=-0.631,`v4`=0.026,`v5`=5.9,`t`=14,`h`=57.8,`rssi`=225,`ccid`='4600485905031430000099m9990000000069000000g7810,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1667178246 WHERE `imei` = '868922055644013' [ RunTime:0.000578s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010158s ]
[ 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' , '221031' , '090301' , -0.709 , 0.001 , -0.631 , 0.026 , 5.9 , 14 , 57.8 , 225 , '4600485905031430000099m9990000000069000000g7810,N,00E000=-00.000' , 0 , 0 , 1667178246 , 1667178246) [ RunTime:0.000611s ]
---------------------------------------------------------------
[ 2022-10-31T09:04:06+08:00 ] 39.144.15.136 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055643643&date=221031&time=090301&v1=-01.051&v2=+00.069&v3=-00.986&v4=-00.040&v5=06.0&t=+13.1&h=54.3&rssi=+230&ccid=4600485905031420000099m9990000000062000001g0710,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.001624s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009636s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000611s ]
[ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055643643',`date`='221031',`time`='090301',`v1`=-1.051,`v2`=0.069,`v3`=-0.986,`v4`=-0.04,`v5`=6,`t`=13.1,`h`=54.3,`rssi`=230,`ccid`='4600485905031420000099m9990000000062000001g0710,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1667178246 WHERE `imei` = '868922055643643' [ RunTime:0.000591s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010052s ]
[ 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' , '221031' , '090301' , -1.051 , 0.069 , -0.986 , -0.04 , 6 , 13.1 , 54.3 , 230 , '4600485905031420000099m9990000000062000001g0710,N,00E000=-00.000' , 0 , 0 , 1667178246 , 1667178246) [ RunTime:0.000497s ]
---------------------------------------------------------------
[ 2022-10-31T10:03:58+08:00 ] 39.144.1.64 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055643643
[ sql ] [ DB ] CONNECT:[ UseTime:0.002153s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009551s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000683s ]
---------------------------------------------------------------
[ 2022-10-31T10:03:58+08:00 ] 39.144.11.215 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013
[ sql ] [ DB ] CONNECT:[ UseTime:0.001541s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010448s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000612s ]
---------------------------------------------------------------
[ 2022-10-31T10:04:06+08:00 ] 39.144.1.64 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055643643&date=221031&time=100301&v1=-01.054&v2=+00.066&v3=-00.988&v4=-00.041&v5=06.2&t=+15.9&h=53.7&rssi=+231&ccid=4600485905031420000099m9990000000062000001g0740,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$
[ 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.008906s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000600s ]
[ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055643643',`date`='221031',`time`='100301',`v1`=-1.054,`v2`=0.066,`v3`=-0.988,`v4`=-0.041,`v5`=6.2,`t`=15.9,`h`=53.7,`rssi`=231,`ccid`='4600485905031420000099m9990000000062000001g0740,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1667181846 WHERE `imei` = '868922055643643' [ RunTime:0.000526s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.008793s ]
[ 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' , '221031' , '100301' , -1.054 , 0.066 , -0.988 , -0.041 , 6.2 , 15.9 , 53.7 , 231 , '4600485905031420000099m9990000000062000001g0740,N,00E000=-00.000' , 0 , 0 , 1667181846 , 1667181846) [ RunTime:0.000576s ]
---------------------------------------------------------------
[ 2022-10-31T10:04:06+08:00 ] 39.144.11.215 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=221031&time=100301&v1=-00.762&v2=+00.001&v3=+00.017&v4=+00.003&v5=05.9&t=+19.7&h=55.1&rssi=+227&ccid=4600485905031430000099m9990000000049000000g8370,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.001466s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009845s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000633s ]
[ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644013',`date`='221031',`time`='100301',`v1`=-0.762,`v2`=0.001,`v3`=0.017,`v4`=0.003,`v5`=5.9,`t`=19.7,`h`=55.1,`rssi`=227,`ccid`='4600485905031430000099m9990000000049000000g8370,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1667181846 WHERE `imei` = '868922055644013' [ RunTime:0.000468s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010216s ]
[ 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' , '221031' , '100301' , -0.762 , 0.001 , 0.017 , 0.003 , 5.9 , 19.7 , 55.1 , 227 , '4600485905031430000099m9990000000049000000g8370,N,00E000=-00.000' , 0 , 0 , 1667181846 , 1667181846) [ RunTime:0.000509s ]
---------------------------------------------------------------
[ 2022-10-31T11:01:51+08:00 ] 39.144.10.68 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055681494
[ sql ] [ DB ] CONNECT:[ UseTime:0.002285s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010422s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055681494' LIMIT 1 [ RunTime:0.000704s ]
---------------------------------------------------------------
[ 2022-10-31T11:02:00+08:00 ] 39.144.10.68 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055681494&date=221031&time=110101&v1=+00.008&v2=+00.264&v3=+00.008&v4=+00.009&v5=10.7&t=+25.5&h=57.7&rssi=+226&ccid=4600485905031400000099m9990000000024000000g0180,N,00E003=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.001573s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.013827s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055681494' LIMIT 1 [ RunTime:0.000731s ]
[ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055681494',`date`='221031',`time`='110101',`v1`=0.008,`v2`=0.264,`v3`=0.008,`v4`=0.009,`v5`=10.7,`t`=25.5,`h`=57.7,`rssi`=226,`ccid`='4600485905031400000099m9990000000024000000g0180,N,00E003=-00.000',`a1`=0,`a2`=0,`update_time`=1667185320 WHERE `imei` = '868922055681494' [ RunTime:0.000645s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010493s ]
[ 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 ('868922055681494' , '221031' , '110101' , 0.008 , 0.264 , 0.008 , 0.009 , 10.7 , 25.5 , 57.7 , 226 , '4600485905031400000099m9990000000024000000g0180,N,00E003=-00.000' , 0 , 0 , 1667185320 , 1667185320) [ RunTime:0.000676s ]
---------------------------------------------------------------
[ 2022-10-31T11:03:57+08:00 ] 117.132.193.36 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055643643
[ sql ] [ DB ] CONNECT:[ UseTime:0.002173s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009905s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000762s ]
---------------------------------------------------------------
[ 2022-10-31T11:03:58+08:00 ] 117.132.193.3 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013
[ sql ] [ DB ] CONNECT:[ UseTime:0.001461s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009552s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000651s ]
---------------------------------------------------------------
[ 2022-10-31T11:04:06+08:00 ] 117.132.193.36 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055643643&date=221031&time=110301&v1=-01.055&v2=+00.071&v3=-00.988&v4=-00.042&v5=05.9&t=+18.9&h=53.1&rssi=+228&ccid=4600485905031420000099m9990000000065000001g0760,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.001619s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009722s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000587s ]
[ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055643643',`date`='221031',`time`='110301',`v1`=-1.055,`v2`=0.071,`v3`=-0.988,`v4`=-0.042,`v5`=5.9,`t`=18.9,`h`=53.1,`rssi`=228,`ccid`='4600485905031420000099m9990000000065000001g0760,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1667185446 WHERE `imei` = '868922055643643' [ RunTime:0.000477s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010479s ]
[ 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' , '221031' , '110301' , -1.055 , 0.071 , -0.988 , -0.042 , 5.9 , 18.9 , 53.1 , 228 , '4600485905031420000099m9990000000065000001g0760,N,00E000=-00.000' , 0 , 0 , 1667185446 , 1667185446) [ RunTime:0.000478s ]
---------------------------------------------------------------
[ 2022-10-31T11:04:06+08:00 ] 117.132.193.3 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=221031&time=110301&v1=-00.767&v2=+00.001&v3=+00.017&v4=+00.003&v5=06.0&t=+22.7&h=56.0&rssi=+225&ccid=4600485905031430000099m9990000000045000000g8420,N,00E000=-00.000&a1=00.000&a2=00.000&a3=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.009505s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000592s ]
[ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644013',`date`='221031',`time`='110301',`v1`=-0.767,`v2`=0.001,`v3`=0.017,`v4`=0.003,`v5`=6,`t`=22.7,`h`=56,`rssi`=225,`ccid`='4600485905031430000099m9990000000045000000g8420,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1667185446 WHERE `imei` = '868922055644013' [ RunTime:0.000452s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009988s ]
[ 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' , '221031' , '110301' , -0.767 , 0.001 , 0.017 , 0.003 , 6 , 22.7 , 56 , 225 , '4600485905031430000099m9990000000045000000g8420,N,00E000=-00.000' , 0 , 0 , 1667185446 , 1667185446) [ RunTime:0.000485s ]
---------------------------------------------------------------
[ 2022-10-31T12:03:57+08:00 ] 117.132.196.180 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055643643
[ sql ] [ DB ] CONNECT:[ UseTime:0.002709s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011300s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000679s ]
---------------------------------------------------------------
[ 2022-10-31T12:03:57+08:00 ] 117.132.192.137 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013
[ 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.011057s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000662s ]
---------------------------------------------------------------
[ 2022-10-31T12:04:05+08:00 ] 117.132.196.180 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055643643&date=221031&time=120301&v1=-01.056&v2=+00.045&v3=-00.989&v4=-00.042&v5=05.7&t=+19.6&h=53.6&rssi=+229&ccid=4600485905031420000099m9990000000064000001g0760,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.001354s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010043s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000928s ]
[ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055643643',`date`='221031',`time`='120301',`v1`=-1.056,`v2`=0.045,`v3`=-0.989,`v4`=-0.042,`v5`=5.7,`t`=19.6,`h`=53.6,`rssi`=229,`ccid`='4600485905031420000099m9990000000064000001g0760,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1667189045 WHERE `imei` = '868922055643643' [ RunTime:0.000829s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.013355s ]
[ 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' , '221031' , '120301' , -1.056 , 0.045 , -0.989 , -0.042 , 5.7 , 19.6 , 53.6 , 229 , '4600485905031420000099m9990000000064000001g0760,N,00E000=-00.000' , 0 , 0 , 1667189045 , 1667189045) [ RunTime:0.000767s ]
---------------------------------------------------------------
[ 2022-10-31T12:04:06+08:00 ] 117.132.192.137 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=221031&time=120301&v1=-00.765&v2=+00.001&v3=+00.015&v4=+00.003&v5=06.0&t=+23.6&h=56.0&rssi=+228&ccid=4600485905031430000099m9990000000043000000g8390,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.001398s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009925s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000637s ]
[ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644013',`date`='221031',`time`='120301',`v1`=-0.765,`v2`=0.001,`v3`=0.015,`v4`=0.003,`v5`=6,`t`=23.6,`h`=56,`rssi`=228,`ccid`='4600485905031430000099m9990000000043000000g8390,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1667189046 WHERE `imei` = '868922055644013' [ RunTime:0.000490s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009685s ]
[ 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' , '221031' , '120301' , -0.765 , 0.001 , 0.015 , 0.003 , 6 , 23.6 , 56 , 228 , '4600485905031430000099m9990000000043000000g8390,N,00E000=-00.000' , 0 , 0 , 1667189046 , 1667189046) [ RunTime:0.000511s ]
---------------------------------------------------------------
[ 2022-10-31T13:03:57+08:00 ] 117.132.192.238 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055643643
[ sql ] [ DB ] CONNECT:[ UseTime:0.002162s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011856s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000758s ]
---------------------------------------------------------------
[ 2022-10-31T13:03:58+08:00 ] 39.144.2.209 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013
[ sql ] [ DB ] CONNECT:[ UseTime:0.001472s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009678s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.001066s ]
---------------------------------------------------------------
[ 2022-10-31T13:04:05+08:00 ] 117.132.192.238 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055643643&date=221031&time=130301&v1=-01.059&v2=+00.063&v3=-00.989&v4=-00.042&v5=06.2&t=+20.2&h=53.7&rssi=+231&ccid=4600485905031420000099m9990000000066000001g0780,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.001408s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009641s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000641s ]
[ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055643643',`date`='221031',`time`='130301',`v1`=-1.059,`v2`=0.063,`v3`=-0.989,`v4`=-0.042,`v5`=6.2,`t`=20.2,`h`=53.7,`rssi`=231,`ccid`='4600485905031420000099m9990000000066000001g0780,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1667192645 WHERE `imei` = '868922055643643' [ RunTime:0.000590s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009383s ]
[ 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' , '221031' , '130301' , -1.059 , 0.063 , -0.989 , -0.042 , 6.2 , 20.2 , 53.7 , 231 , '4600485905031420000099m9990000000066000001g0780,N,00E000=-00.000' , 0 , 0 , 1667192645 , 1667192645) [ RunTime:0.000581s ]
---------------------------------------------------------------
[ 2022-10-31T13:04:07+08:00 ] 39.144.2.209 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=221031&time=130301&v1=-00.746&v2=+00.001&v3=+00.016&v4=+00.002&v5=06.0&t=+23.0&h=57.3&rssi=+226&ccid=4600485905031430000099m9990000000043000000g8240,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.001802s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009223s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000601s ]
[ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644013',`date`='221031',`time`='130301',`v1`=-0.746,`v2`=0.001,`v3`=0.016,`v4`=0.002,`v5`=6,`t`=23,`h`=57.3,`rssi`=226,`ccid`='4600485905031430000099m9990000000043000000g8240,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1667192646 WHERE `imei` = '868922055644013' [ RunTime:0.000478s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010322s ]
[ 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' , '221031' , '130301' , -0.746 , 0.001 , 0.016 , 0.002 , 6 , 23 , 57.3 , 226 , '4600485905031430000099m9990000000043000000g8240,N,00E000=-00.000' , 0 , 0 , 1667192647 , 1667192647) [ RunTime:0.000476s ]
---------------------------------------------------------------
[ 2022-10-31T13:50:04+08:00 ] 27.210.88.91 POST /admin/login/login.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.002148s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_manager` [ RunTime:0.013070s ]
[ sql ] [ SQL ] SELECT * FROM `collect_manager` WHERE `username` = 'admin' AND `password` = 'b8c6b861afec5f2a9a13ad8f963df1c7' LIMIT 1 [ RunTime:0.000870s ]
---------------------------------------------------------------
[ 2022-10-31T13:50:08+08:00 ] 27.210.88.91 GET /admin/show/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001373s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010611s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000354s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000796s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000589s ]
---------------------------------------------------------------
[ 2022-10-31T13:50:23+08:00 ] 27.210.88.91 GET /admin/show/edit/id/33.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.002252s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009718s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 33 LIMIT 1 [ RunTime:0.000753s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.012013s ]
[ sql ] [ SQL ] SELECT * FROM `collect_user` WHERE `collect_user`.`delete_time` IS NULL [ RunTime:0.001128s ]
---------------------------------------------------------------
[ 2022-10-31T13:52:14+08:00 ] 223.104.194.44 GET /home/map/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001508s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010688s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'biandianzhan' ORDER BY `id` DESC [ RunTime:0.000667s ]
---------------------------------------------------------------
[ 2022-10-31T13:52:19+08:00 ] 223.104.194.44 GET /home/show/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001684s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010771s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `username` = 'biandianzhan' LIMIT 1 [ RunTime:0.000445s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'biandianzhan' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000620s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'biandianzhan' ORDER BY `id` DESC [ RunTime:0.000535s ]
---------------------------------------------------------------
[ 2022-10-31T13:52:22+08:00 ] 223.104.194.44 GET /home/show/read/id/33/imei/868922055644013.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.013938s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010269s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 33 LIMIT 1 [ RunTime:0.000859s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010676s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000832s ]
[ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055644013' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.004699s ]
---------------------------------------------------------------
[ 2022-10-31T13:53:22+08:00 ] 223.104.194.44 GET /home/map/index.html
[ 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.009959s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'biandianzhan' ORDER BY `id` DESC [ RunTime:0.000704s ]
---------------------------------------------------------------
[ 2022-10-31T13:53:25+08:00 ] 223.104.194.44 GET /home/show/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001731s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.008999s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `username` = 'biandianzhan' LIMIT 1 [ RunTime:0.000495s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'biandianzhan' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000651s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'biandianzhan' ORDER BY `id` DESC [ RunTime:0.000741s ]
---------------------------------------------------------------
[ 2022-10-31T13:53:28+08:00 ] 223.104.194.44 GET /home/show/read/id/33/imei/868922055644013.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001523s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010856s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 33 LIMIT 1 [ RunTime:0.000597s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010109s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000539s ]
[ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055644013' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.001951s ]
---------------------------------------------------------------
[ 2022-10-31T13:54:09+08:00 ] 223.104.194.44 GET /home/show/read/id/32/imei/868922055643643.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001451s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010790s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 32 LIMIT 1 [ RunTime:0.000726s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010605s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000521s ]
[ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055643643' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.001551s ]
---------------------------------------------------------------
[ 2022-10-31T13:54:18+08:00 ] 223.104.194.44 GET /home/show/read/id/26/imei/868922055684076.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001451s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009586s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 26 LIMIT 1 [ RunTime:0.000751s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010472s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.002271s ]
[ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055684076' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.013734s ]
---------------------------------------------------------------
[ 2022-10-31T13:54:25+08:00 ] 223.104.194.44 GET /home/show/read/id/33/imei/868922055644013.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.002218s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010930s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 33 LIMIT 1 [ RunTime:0.000596s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010111s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000600s ]
[ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055644013' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.002005s ]
---------------------------------------------------------------
[ 2022-10-31T13:54:47+08:00 ] 223.104.194.44 GET /home/show/read/id/33/imei/868922055644013.html?page=2
[ sql ] [ DB ] CONNECT:[ UseTime:0.001511s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.008980s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 33 LIMIT 1 [ RunTime:0.000672s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010166s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000634s ]
[ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055644013' ORDER BY `update_time` DESC LIMIT 10,10 [ RunTime:0.002064s ]
---------------------------------------------------------------
[ 2022-10-31T13:54:51+08:00 ] 223.104.194.44 GET /home/show/read/id/33/imei/868922055644013.html?page=3
[ sql ] [ DB ] CONNECT:[ UseTime:0.001767s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010491s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 33 LIMIT 1 [ RunTime:0.000893s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010287s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000570s ]
[ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055644013' ORDER BY `update_time` DESC LIMIT 20,10 [ RunTime:0.002358s ]
---------------------------------------------------------------
[ 2022-10-31T13:54:55+08:00 ] 223.104.194.44 GET /home/show/read/id/33/imei/868922055644013.html?page=4
[ sql ] [ DB ] CONNECT:[ UseTime:0.001445s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011232s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 33 LIMIT 1 [ RunTime:0.000645s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.008931s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000540s ]
[ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055644013' ORDER BY `update_time` DESC LIMIT 30,10 [ RunTime:0.002280s ]
---------------------------------------------------------------
[ 2022-10-31T13:54:59+08:00 ] 223.104.194.44 GET /home/show/read/id/33/imei/868922055644013.html?page=5
[ sql ] [ DB ] CONNECT:[ UseTime:0.001773s ] 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 * FROM `collect_show` WHERE `id` = 33 LIMIT 1 [ RunTime:0.000731s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009834s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000545s ]
[ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055644013' ORDER BY `update_time` DESC LIMIT 40,10 [ RunTime:0.002393s ]
---------------------------------------------------------------
[ 2022-10-31T13:55:03+08:00 ] 27.210.88.91 GET /admin/show/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001656s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010168s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000438s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.001263s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000667s ]
---------------------------------------------------------------
[ 2022-10-31T13:55:39+08:00 ] 27.210.88.91 GET /admin/show/edit/id/33.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001526s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.008968s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 33 LIMIT 1 [ RunTime:0.000597s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.009898s ]
[ sql ] [ SQL ] SELECT * FROM `collect_user` WHERE `collect_user`.`delete_time` IS NULL [ RunTime:0.000412s ]
---------------------------------------------------------------
[ 2022-10-31T13:55:45+08:00 ] 27.210.88.91 POST /admin/show/update.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001606s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009524s ]
[ sql ] [ SQL ] UPDATE `collect_show` SET `device_name`='后王 35-避雷',`interval`=720,`gps`='120.001126,36.338007',`username`='biandianzhan',`introduce`='胶州变电站1号避雷针下
2022.10.22
',`update_time`=1667195745 WHERE `id` = 33 [ RunTime:0.000631s ]
---------------------------------------------------------------
[ 2022-10-31T13:55:46+08:00 ] 223.104.194.44 GET /home/map/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.015401s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010829s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'biandianzhan' ORDER BY `id` DESC [ RunTime:0.000711s ]
---------------------------------------------------------------
[ 2022-10-31T13:55:47+08:00 ] 27.210.88.91 GET /admin/show/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001518s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009434s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000310s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000678s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000609s ]
---------------------------------------------------------------
[ 2022-10-31T13:55:49+08:00 ] 27.210.88.91 GET /admin/show/edit/id/32.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001481s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009379s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 32 LIMIT 1 [ RunTime:0.000627s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.009802s ]
[ sql ] [ SQL ] SELECT * FROM `collect_user` WHERE `collect_user`.`delete_time` IS NULL [ RunTime:0.000428s ]
---------------------------------------------------------------
[ 2022-10-31T13:55:54+08:00 ] 27.210.88.91 POST /admin/show/update.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001602s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.008027s ]
[ sql ] [ SQL ] UPDATE `collect_show` SET `device_name`='后王 35-主接地',`interval`=720,`gps`='120.00148,36.33808',`username`='biandianzhan',`introduce`='胶州变电站高压线旁边
2022.10.22
',`update_time`=1667195754 WHERE `id` = 32 [ RunTime:0.000546s ]
---------------------------------------------------------------
[ 2022-10-31T13:55:55+08:00 ] 27.210.88.91 GET /admin/show/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001344s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010839s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000501s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000647s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000588s ]
---------------------------------------------------------------
[ 2022-10-31T14:03:57+08:00 ] 117.132.197.186 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055643643
[ sql ] [ DB ] CONNECT:[ UseTime:0.002050s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009141s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000642s ]
---------------------------------------------------------------
[ 2022-10-31T14:03:58+08:00 ] 39.144.8.35 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013
[ sql ] [ DB ] CONNECT:[ UseTime:0.001485s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.008702s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000592s ]
---------------------------------------------------------------
[ 2022-10-31T14:04:05+08:00 ] 117.132.197.186 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055643643&date=221031&time=140301&v1=-01.055&v2=+00.070&v3=-00.989&v4=-00.043&v5=06.2&t=+20.8&h=53.8&rssi=+231&ccid=4600485905031420000099m9990000000067000001g0770,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.001856s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009778s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000642s ]
[ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055643643',`date`='221031',`time`='140301',`v1`=-1.055,`v2`=0.07,`v3`=-0.989,`v4`=-0.043,`v5`=6.2,`t`=20.8,`h`=53.8,`rssi`=231,`ccid`='4600485905031420000099m9990000000067000001g0770,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1667196245 WHERE `imei` = '868922055643643' [ RunTime:0.000525s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009741s ]
[ 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' , '221031' , '140301' , -1.055 , 0.07 , -0.989 , -0.043 , 6.2 , 20.8 , 53.8 , 231 , '4600485905031420000099m9990000000067000001g0770,N,00E000=-00.000' , 0 , 0 , 1667196245 , 1667196245) [ RunTime:0.000677s ]
---------------------------------------------------------------
[ 2022-10-31T14:04:06+08:00 ] 39.144.8.35 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=221031&time=140301&v1=-00.723&v2=+00.001&v3=+00.017&v4=+00.001&v5=06.0&t=+22.0&h=57.9&rssi=+224&ccid=4600485905031430000099m9990000000044000000g8070,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.001686s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012387s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000824s ]
[ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644013',`date`='221031',`time`='140301',`v1`=-0.723,`v2`=0.001,`v3`=0.017,`v4`=0.001,`v5`=6,`t`=22,`h`=57.9,`rssi`=224,`ccid`='4600485905031430000099m9990000000044000000g8070,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1667196246 WHERE `imei` = '868922055644013' [ RunTime:0.000445s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.008294s ]
[ 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' , '221031' , '140301' , -0.723 , 0.001 , 0.017 , 0.001 , 6 , 22 , 57.9 , 224 , '4600485905031430000099m9990000000044000000g8070,N,00E000=-00.000' , 0 , 0 , 1667196246 , 1667196246) [ RunTime:0.000687s ]
---------------------------------------------------------------
[ 2022-10-31T14:40:26+08:00 ] 27.210.88.91 GET /admin/show/index.html
[ 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.011156s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000323s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000686s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000749s ]
---------------------------------------------------------------
[ 2022-10-31T16:00:56+08:00 ] 112.9.188.102 POST /home/login/login.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.002530s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.010999s ]
[ sql ] [ SQL ] SELECT * FROM `collect_user` WHERE `username` = 'biandianzhan' AND `password` = 'd14d010294c092af31274c0f4c6cc67a' LIMIT 1 [ RunTime:0.000581s ]
---------------------------------------------------------------
[ 2022-10-31T16:00:58+08:00 ] 112.9.188.102 GET /home/map/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.014621s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012124s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'biandianzhan' ORDER BY `id` DESC [ RunTime:0.000755s ]
---------------------------------------------------------------
[ 2022-10-31T16:01:02+08:00 ] 112.9.188.102 GET /home/show/index.html
[ 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.009407s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `username` = 'biandianzhan' LIMIT 1 [ RunTime:0.000478s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'biandianzhan' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000909s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'biandianzhan' ORDER BY `id` DESC [ RunTime:0.000608s ]
---------------------------------------------------------------
[ 2022-10-31T16:01:05+08:00 ] 112.9.188.102 GET /home/show/read/id/33/imei/868922055644013.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001691s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009812s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 33 LIMIT 1 [ RunTime:0.000621s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.007623s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000596s ]
[ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055644013' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.002186s ]
---------------------------------------------------------------
[ 2022-10-31T16:01:25+08:00 ] 112.9.188.102 GET /home/show/read/id/33/imei/868922055644013.html?page=3
[ sql ] [ DB ] CONNECT:[ UseTime:0.001521s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.007611s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 33 LIMIT 1 [ RunTime:0.000599s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010240s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000563s ]
[ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055644013' ORDER BY `update_time` DESC LIMIT 20,10 [ RunTime:0.002092s ]
---------------------------------------------------------------
[ 2022-10-31T16:01:32+08:00 ] 112.9.188.102 GET /home/show/read/id/33/imei/868922055644013.html?page=2
[ sql ] [ DB ] CONNECT:[ UseTime:0.001582s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009715s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 33 LIMIT 1 [ RunTime:0.000626s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009253s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000551s ]
[ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055644013' ORDER BY `update_time` DESC LIMIT 10,10 [ RunTime:0.002111s ]
---------------------------------------------------------------
[ 2022-10-31T16:01:37+08:00 ] 112.9.188.102 GET /home/show/read/id/33/imei/868922055644013.html?page=5
[ sql ] [ DB ] CONNECT:[ UseTime:0.001459s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009795s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 33 LIMIT 1 [ RunTime:0.000592s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010826s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000541s ]
[ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055644013' ORDER BY `update_time` DESC LIMIT 40,10 [ RunTime:0.002129s ]
---------------------------------------------------------------
[ 2022-10-31T16:01:43+08:00 ] 112.9.188.102 GET /home/show/read/id/33/imei/868922055644013.html?page=25
[ sql ] [ DB ] CONNECT:[ UseTime:0.001354s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009749s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 33 LIMIT 1 [ RunTime:0.000598s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009023s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000534s ]
[ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055644013' ORDER BY `update_time` DESC LIMIT 240,10 [ RunTime:0.003067s ]
---------------------------------------------------------------
[ 2022-10-31T16:01:49+08:00 ] 112.9.188.102 GET /home/show/read/id/33/imei/868922055644013.html?page=21
[ sql ] [ DB ] CONNECT:[ UseTime:0.002094s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.008979s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 33 LIMIT 1 [ RunTime:0.000865s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010204s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000578s ]
[ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055644013' ORDER BY `update_time` DESC LIMIT 200,10 [ RunTime:0.003308s ]
---------------------------------------------------------------
[ 2022-10-31T16:01:52+08:00 ] 112.9.188.102 GET /home/show/read/id/33/imei/868922055644013.html?page=18
[ sql ] [ DB ] CONNECT:[ UseTime:0.001413s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009251s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 33 LIMIT 1 [ RunTime:0.000897s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009367s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000573s ]
[ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055644013' ORDER BY `update_time` DESC LIMIT 170,10 [ RunTime:0.002956s ]
---------------------------------------------------------------
[ 2022-10-31T16:01:56+08:00 ] 112.9.188.102 GET /home/show/read/id/33/imei/868922055644013.html?page=15
[ sql ] [ DB ] CONNECT:[ UseTime:0.001382s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009493s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 33 LIMIT 1 [ RunTime:0.000613s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010609s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000637s ]
[ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055644013' ORDER BY `update_time` DESC LIMIT 140,10 [ RunTime:0.002760s ]
---------------------------------------------------------------
[ 2022-10-31T16:02:01+08:00 ] 112.9.188.102 GET /home/show/read/id/33/imei/868922055644013.html?page=12
[ sql ] [ DB ] CONNECT:[ UseTime:0.001619s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010138s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 33 LIMIT 1 [ RunTime:0.000616s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.012504s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000645s ]
[ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055644013' ORDER BY `update_time` DESC LIMIT 110,10 [ RunTime:0.002823s ]
---------------------------------------------------------------
[ 2022-10-31T16:02:06+08:00 ] 112.9.188.102 GET /home/show/read/id/33/imei/868922055644013.html?page=9
[ sql ] [ DB ] CONNECT:[ UseTime:0.001583s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009645s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 33 LIMIT 1 [ RunTime:0.000869s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010568s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000545s ]
[ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055644013' ORDER BY `update_time` DESC LIMIT 80,10 [ RunTime:0.002567s ]
---------------------------------------------------------------
[ 2022-10-31T16:02:09+08:00 ] 112.9.188.102 GET /home/show/read/id/33/imei/868922055644013.html?page=6
[ 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.009064s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 33 LIMIT 1 [ RunTime:0.000627s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010239s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000577s ]
[ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055644013' ORDER BY `update_time` DESC LIMIT 50,10 [ RunTime:0.002269s ]
---------------------------------------------------------------
[ 2022-10-31T16:02:13+08:00 ] 112.9.188.102 GET /home/show/read/id/33/imei/868922055644013.html?page=5
[ 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.009785s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 33 LIMIT 1 [ RunTime:0.000636s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010841s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000563s ]
[ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055644013' ORDER BY `update_time` DESC LIMIT 40,10 [ RunTime:0.002319s ]
---------------------------------------------------------------
[ 2022-10-31T16:02:33+08:00 ] 112.9.188.102 GET /home/data/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001577s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009663s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `username` = 'biandianzhan' LIMIT 1 [ RunTime:0.000484s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'biandianzhan' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000691s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'biandianzhan' ORDER BY `id` DESC [ RunTime:0.000585s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.008305s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` IS NULL AND ( `update_time` >= 0 AND `update_time` <= 0 ) LIMIT 1 [ RunTime:0.000499s ]
[ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` IS NULL AND ( `update_time` >= 0 AND `update_time` <= 0 ) ORDER BY `update_time` ASC LIMIT 0,1000 [ RunTime:0.000421s ]
---------------------------------------------------------------
[ 2022-10-31T16:02:45+08:00 ] 112.9.188.102 GET /home/data/index.html?keyword=868922055644013&start_date=2022-10-20&end_date=2022-10-31
[ sql ] [ DB ] CONNECT:[ UseTime:0.001399s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010608s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'biandianzhan' AND `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000624s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `imei` = '868922055644013' AND `username` = 'biandianzhan' LIMIT 1 [ RunTime:0.000403s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' AND `username` = 'biandianzhan' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000465s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'biandianzhan' ORDER BY `id` DESC [ RunTime:0.000533s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010253s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055644013' AND ( `update_time` >= 1666195200 AND `update_time` <= 1667145600 ) LIMIT 1 [ RunTime:0.001795s ]
[ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055644013' AND ( `update_time` >= 1666195200 AND `update_time` <= 1667145600 ) ORDER BY `update_time` ASC LIMIT 0,1000 [ RunTime:0.003646s ]
---------------------------------------------------------------
[ 2022-10-31T16:02:54+08:00 ] 112.9.188.102 GET /home/data/index.html?keyword=868922055644013&start_date=2022-10-22&end_date=2022-10-31
[ sql ] [ DB ] CONNECT:[ UseTime:0.001651s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010806s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'biandianzhan' AND `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000617s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `imei` = '868922055644013' AND `username` = 'biandianzhan' LIMIT 1 [ RunTime:0.000395s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' AND `username` = 'biandianzhan' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000461s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'biandianzhan' ORDER BY `id` DESC [ RunTime:0.000516s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009782s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055644013' AND ( `update_time` >= 1666368000 AND `update_time` <= 1667145600 ) LIMIT 1 [ RunTime:0.001775s ]
[ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055644013' AND ( `update_time` >= 1666368000 AND `update_time` <= 1667145600 ) ORDER BY `update_time` ASC LIMIT 0,1000 [ RunTime:0.003547s ]
---------------------------------------------------------------
[ 2022-10-31T16:03:04+08:00 ] 112.9.188.102 GET /home/data/index.html?keyword=868922055644013&start_date=2022-10-23&end_date=2022-10-31
[ 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.009972s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'biandianzhan' AND `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000757s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `imei` = '868922055644013' AND `username` = 'biandianzhan' LIMIT 1 [ RunTime:0.000413s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' AND `username` = 'biandianzhan' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000590s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'biandianzhan' ORDER BY `id` DESC [ RunTime:0.000575s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011276s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055644013' AND ( `update_time` >= 1666454400 AND `update_time` <= 1667145600 ) LIMIT 1 [ RunTime:0.001988s ]
[ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055644013' AND ( `update_time` >= 1666454400 AND `update_time` <= 1667145600 ) ORDER BY `update_time` ASC LIMIT 0,1000 [ RunTime:0.003401s ]
---------------------------------------------------------------
[ 2022-10-31T16:54:59+08:00 ] 112.9.188.102 GET /home/data/index.html?keyword=868922055644013&start_date=2022-10-23&end_date=2022-10-31
[ 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.010647s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'biandianzhan' AND `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000667s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `imei` = '868922055644013' AND `username` = 'biandianzhan' LIMIT 1 [ RunTime:0.000438s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' AND `username` = 'biandianzhan' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000447s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'biandianzhan' ORDER BY `id` DESC [ RunTime:0.000537s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011591s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055644013' AND ( `update_time` >= 1666454400 AND `update_time` <= 1667145600 ) LIMIT 1 [ RunTime:0.001955s ]
[ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055644013' AND ( `update_time` >= 1666454400 AND `update_time` <= 1667145600 ) ORDER BY `update_time` ASC LIMIT 0,1000 [ RunTime:0.003265s ]
---------------------------------------------------------------
[ 2022-10-31T19:44:13+08:00 ] 39.144.2.185 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644211
[ sql ] [ DB ] CONNECT:[ UseTime:0.002089s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010336s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644211' LIMIT 1 [ RunTime:0.000624s ]
---------------------------------------------------------------
[ 2022-10-31T19:44:14+08:00 ] 39.144.2.185 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055644211&create_time=1667216653&v1=0.026097&v2=0.126109&v3=0.022395&v4=-0.002318&v5=6.660000&t=12.277463&h=65.281433&rssi=22&ccid=89860426102071188505&imsi=460044618415255&v6=-00.000&end=
[ sql ] [ DB ] CONNECT:[ UseTime:0.001404s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010793s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644211' LIMIT 1 [ RunTime:0.000638s ]
[ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644211',`create_time`=1667216653,`v1`=0.026097,`v2`=0.126109,`v3`=0.022395,`v4`=-0.002318,`v5`=6.66,`t`=12.277463,`h`=65.281433,`rssi`=22,`ccid`='89860426102071188505',`imsi`='460044618415255',`v6`=-0,`update_time`=1667216654 WHERE `imei` = '868922055644211' [ RunTime:0.000529s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010991s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055644211' , 1667216653 , 0.026097 , 0.126109 , 0.022395 , -0.002318 , 6.66 , 12.277463 , 65.281433 , 22 , '89860426102071188505' , '460044618415255' , -0 , 1667216654) [ RunTime:0.000610s ]
---------------------------------------------------------------
[ 2022-10-31T22:03:51+08:00 ] 39.144.18.217 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684076
[ sql ] [ DB ] CONNECT:[ UseTime:0.002024s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011119s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000625s ]
---------------------------------------------------------------
[ 2022-10-31T22:03:59+08:00 ] 39.144.18.217 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055684076&date=221031&time=220301&v1=-01.280&v2=+00.026&v3=-01.115&v4=-00.760&v5=06.0&t=+12.4&h=81.4&rssi=+221&imsi=460044618415249&v6=-00.000&a1=00.194&a2=01.297&a3=00.000&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.001482s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009378s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000626s ]
[ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684076',`date`='221031',`time`='220301',`v1`=-1.28,`v2`=0.026,`v3`=-1.115,`v4`=-0.76,`v5`=6,`t`=12.4,`h`=81.4,`rssi`=221,`imsi`='460044618415249',`v6`=-0,`a1`=0.194,`a2`=1.297,`update_time`=1667225039 WHERE `imei` = '868922055684076' [ RunTime:0.000573s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009919s ]
[ 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' , '221031' , '220301' , -1.28 , 0.026 , -1.115 , -0.76 , 6 , 12.4 , 81.4 , 221 , '460044618415249' , -0 , 0.194 , 1.297 , 1667225039 , 1667225039) [ RunTime:0.000591s ]