---------------------------------------------------------------
[ 2023-03-17T00:31:27+08:00 ] 39.144.18.30 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922056976109
[ sql ] [ DB ] CONNECT:[ UseTime:0.002540s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.013261s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922056976109' LIMIT 1 [ RunTime:0.000829s ]
---------------------------------------------------------------
[ 2023-03-17T00:31:28+08:00 ] 39.144.18.30 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922056976109&create_time=1678984287&v1=0.027963&v2=0.694796&v3=0.028535&v4=0.028084&v5=12.420000&t=12.320364&h=39.249939&rssi=17&ccid=898604650119C1078513&imsi=460048590708513&v6=-00.000&end=
[ sql ] [ DB ] CONNECT:[ UseTime:0.002149s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010967s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922056976109' LIMIT 1 [ RunTime:0.000651s ]
[ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922056976109',`create_time`=1678984287,`v1`=0.027963,`v2`=0.694796,`v3`=0.028535,`v4`=0.028084,`v5`=12.42,`t`=12.320364,`h`=39.249939,`rssi`=17,`ccid`='898604650119C1078513',`imsi`='460048590708513',`v6`=-0,`update_time`=1678984288 WHERE `imei` = '868922056976109' [ RunTime:0.000586s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011117s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922056976109' , 1678984287 , 0.027963 , 0.694796 , 0.028535 , 0.028084 , 12.42 , 12.320364 , 39.249939 , 17 , '898604650119C1078513' , '460048590708513' , -0 , 1678984288) [ RunTime:0.000652s ]
---------------------------------------------------------------
[ 2023-03-17T01:31:27+08:00 ] 39.144.2.247 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922056976109
[ sql ] [ DB ] CONNECT:[ UseTime:0.005766s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.013267s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922056976109' LIMIT 1 [ RunTime:0.001880s ]
---------------------------------------------------------------
[ 2023-03-17T01:31:29+08:00 ] 39.144.2.247 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922056976109&create_time=1678987887&v1=0.028084&v2=0.639305&v3=0.028535&v4=0.028023&v5=12.420000&t=12.223838&h=39.295715&rssi=17&ccid=898604650119C1078513&imsi=460048590708513&v6=-00.000&end=
[ sql ] [ DB ] CONNECT:[ UseTime:0.001558s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010933s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922056976109' LIMIT 1 [ RunTime:0.000732s ]
[ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922056976109',`create_time`=1678987887,`v1`=0.028084,`v2`=0.639305,`v3`=0.028535,`v4`=0.028023,`v5`=12.42,`t`=12.223838,`h`=39.295715,`rssi`=17,`ccid`='898604650119C1078513',`imsi`='460048590708513',`v6`=-0,`update_time`=1678987889 WHERE `imei` = '868922056976109' [ RunTime:0.000752s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.013770s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922056976109' , 1678987887 , 0.028084 , 0.639305 , 0.028535 , 0.028023 , 12.42 , 12.223838 , 39.295715 , 17 , '898604650119C1078513' , '460048590708513' , -0 , 1678987889) [ RunTime:0.001431s ]
---------------------------------------------------------------
[ 2023-03-17T02:03:55+08:00 ] 39.144.4.71 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055643643
[ sql ] [ DB ] CONNECT:[ UseTime:0.002442s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011768s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000730s ]
---------------------------------------------------------------
[ 2023-03-17T02:03:55+08:00 ] 39.144.7.211 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013
[ sql ] [ DB ] CONNECT:[ UseTime:0.002429s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010501s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000697s ]
---------------------------------------------------------------
[ 2023-03-17T02:04:04+08:00 ] 39.144.4.71 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055643643&date=230317&time=020301&v1=-01.296&v2=+00.021&v3=-00.964&v4=-00.022&v5=05.7&t=+05.4&h=62.0&rssi=+229&ccid=4600485905031420000099m9990000000323000001g3080,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.011163s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000722s ]
[ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055643643',`date`='230317',`time`='020301',`v1`=-1.296,`v2`=0.021,`v3`=-0.964,`v4`=-0.022,`v5`=5.7,`t`=5.4,`h`=62,`rssi`=229,`ccid`='4600485905031420000099m9990000000323000001g3080,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1678989844 WHERE `imei` = '868922055643643' [ RunTime:0.000683s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010891s ]
[ 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' , '230317' , '020301' , -1.296 , 0.021 , -0.964 , -0.022 , 5.7 , 5.4 , 62 , 229 , '4600485905031420000099m9990000000323000001g3080,N,00E000=-00.000' , 0 , 0 , 1678989844 , 1678989844) [ RunTime:0.000785s ]
---------------------------------------------------------------
[ 2023-03-17T02:04:04+08:00 ] 39.144.7.211 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=230317&time=020301&v1=-00.239&v2=+00.001&v3=-00.014&v4=-00.017&v5=05.6&t=+06.0&h=64.6&rssi=+225&ccid=4600485905031430000099m9990000000021000000g2750,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.001928s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.029681s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000744s ]
[ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644013',`date`='230317',`time`='020301',`v1`=-0.239,`v2`=0.001,`v3`=-0.014,`v4`=-0.017,`v5`=5.6,`t`=6,`h`=64.6,`rssi`=225,`ccid`='4600485905031430000099m9990000000021000000g2750,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1678989844 WHERE `imei` = '868922055644013' [ RunTime:0.000520s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011602s ]
[ 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' , '230317' , '020301' , -0.239 , 0.001 , -0.014 , -0.017 , 5.6 , 6 , 64.6 , 225 , '4600485905031430000099m9990000000021000000g2750,N,00E000=-00.000' , 0 , 0 , 1678989844 , 1678989844) [ RunTime:0.000573s ]
---------------------------------------------------------------
[ 2023-03-17T03:32:28+08:00 ] 223.104.255.231 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922056976109
[ 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.010743s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922056976109' LIMIT 1 [ RunTime:0.000685s ]
---------------------------------------------------------------
[ 2023-03-17T03:32:29+08:00 ] 223.104.255.231 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922056976109&create_time=1678995148&v1=0.028204&v2=0.637427&v3=0.028535&v4=0.028144&v5=12.420000&t=11.869909&h=39.448303&rssi=17&ccid=898604650119C1078513&imsi=460048590708513&v6=-00.000&end=
[ sql ] [ DB ] CONNECT:[ UseTime:0.001765s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010666s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922056976109' LIMIT 1 [ RunTime:0.000852s ]
[ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922056976109',`create_time`=1678995148,`v1`=0.028204,`v2`=0.637427,`v3`=0.028535,`v4`=0.028144,`v5`=12.42,`t`=11.869909,`h`=39.448303,`rssi`=17,`ccid`='898604650119C1078513',`imsi`='460048590708513',`v6`=-0,`update_time`=1678995149 WHERE `imei` = '868922056976109' [ RunTime:0.001035s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011551s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922056976109' , 1678995148 , 0.028204 , 0.637427 , 0.028535 , 0.028144 , 12.42 , 11.869909 , 39.448303 , 17 , '898604650119C1078513' , '460048590708513' , -0 , 1678995149) [ RunTime:0.000605s ]
---------------------------------------------------------------
[ 2023-03-17T03:32:31+08:00 ] 223.104.255.231 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922056976109&create_time=1678991461&v1=0.028084&v2=0.630751&v3=0.028565&v4=0.028023&v5=12.600000&t=12.170213&h=39.356750&rssi=17&ccid=898604650119C1078513&imsi=460048590708513&v6=-00.000&end=
[ sql ] [ DB ] CONNECT:[ UseTime:0.001660s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010896s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922056976109' LIMIT 1 [ RunTime:0.000753s ]
[ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922056976109',`create_time`=1678991461,`v1`=0.028084,`v2`=0.630751,`v3`=0.028565,`v4`=0.028023,`v5`=12.6,`t`=12.170213,`h`=39.35675,`rssi`=17,`ccid`='898604650119C1078513',`imsi`='460048590708513',`v6`=-0,`update_time`=1678995151 WHERE `imei` = '868922056976109' [ RunTime:0.000583s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010581s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922056976109' , 1678991461 , 0.028084 , 0.630751 , 0.028565 , 0.028023 , 12.6 , 12.170213 , 39.35675 , 17 , '898604650119C1078513' , '460048590708513' , -0 , 1678995151) [ RunTime:0.000519s ]
---------------------------------------------------------------
[ 2023-03-17T04:32:27+08:00 ] 39.144.5.207 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922056976109
[ sql ] [ DB ] CONNECT:[ UseTime:0.002671s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010431s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922056976109' LIMIT 1 [ RunTime:0.000750s ]
---------------------------------------------------------------
[ 2023-03-17T04:32:29+08:00 ] 39.144.5.207 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922056976109&create_time=1678998747&v1=0.027963&v2=1.275063&v3=0.028535&v4=0.028144&v5=12.420000&t=11.784109&h=39.425415&rssi=16&ccid=898604650119C1078513&imsi=460048590708513&v6=-00.000&end=
[ sql ] [ DB ] CONNECT:[ UseTime:0.002066s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012105s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922056976109' LIMIT 1 [ RunTime:0.000714s ]
[ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922056976109',`create_time`=1678998747,`v1`=0.027963,`v2`=1.275063,`v3`=0.028535,`v4`=0.028144,`v5`=12.42,`t`=11.784109,`h`=39.425415,`rssi`=16,`ccid`='898604650119C1078513',`imsi`='460048590708513',`v6`=-0,`update_time`=1678998749 WHERE `imei` = '868922056976109' [ RunTime:0.000664s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.012998s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922056976109' , 1678998747 , 0.027963 , 1.275063 , 0.028535 , 0.028144 , 12.42 , 11.784109 , 39.425415 , 16 , '898604650119C1078513' , '460048590708513' , -0 , 1678998749) [ RunTime:0.000698s ]
---------------------------------------------------------------
[ 2023-03-17T05:32:27+08:00 ] 39.144.17.195 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922056976109
[ sql ] [ DB ] CONNECT:[ UseTime:0.002518s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011149s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922056976109' LIMIT 1 [ RunTime:0.000670s ]
---------------------------------------------------------------
[ 2023-03-17T05:32:28+08:00 ] 39.144.17.195 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922056976109&create_time=1679002347&v1=0.028084&v2=0.693962&v3=0.028535&v4=0.028084&v5=12.420000&t=11.730483&h=39.494080&rssi=16&ccid=898604650119C1078513&imsi=460048590708513&v6=-00.000&end=
[ sql ] [ DB ] CONNECT:[ UseTime:0.001706s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010747s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922056976109' LIMIT 1 [ RunTime:0.000995s ]
[ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922056976109',`create_time`=1679002347,`v1`=0.028084,`v2`=0.693962,`v3`=0.028535,`v4`=0.028084,`v5`=12.42,`t`=11.730483,`h`=39.49408,`rssi`=16,`ccid`='898604650119C1078513',`imsi`='460048590708513',`v6`=-0,`update_time`=1679002348 WHERE `imei` = '868922056976109' [ RunTime:0.000604s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010684s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922056976109' , 1679002347 , 0.028084 , 0.693962 , 0.028535 , 0.028084 , 12.42 , 11.730483 , 39.49408 , 16 , '898604650119C1078513' , '460048590708513' , -0 , 1679002348) [ RunTime:0.000631s ]
---------------------------------------------------------------
[ 2023-03-17T06:04:51+08:00 ] 218.204.252.17 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684076
[ sql ] [ DB ] CONNECT:[ UseTime:0.002826s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012191s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000673s ]
---------------------------------------------------------------
[ 2023-03-17T06:04:59+08:00 ] 218.204.252.17 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055684076&date=230317&time=060401&v1=-01.273&v2=+00.023&v3=-01.105&v4=-00.634&v5=05.7&t=+05.0&h=80.9&rssi=+226&imsi=460044618415249&v6=-00.000&a1=00.198&a2=01.290&a3=00.000&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.001705s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011259s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000651s ]
[ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684076',`date`='230317',`time`='060401',`v1`=-1.273,`v2`=0.023,`v3`=-1.105,`v4`=-0.634,`v5`=5.7,`t`=5,`h`=80.9,`rssi`=226,`imsi`='460044618415249',`v6`=-0,`a1`=0.198,`a2`=1.29,`update_time`=1679004299 WHERE `imei` = '868922055684076' [ RunTime:0.000605s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011897s ]
[ 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' , '230317' , '060401' , -1.273 , 0.023 , -1.105 , -0.634 , 5.7 , 5 , 80.9 , 226 , '460044618415249' , -0 , 0.198 , 1.29 , 1679004299 , 1679004299) [ RunTime:0.000730s ]
---------------------------------------------------------------
[ 2023-03-17T06:32:27+08:00 ] 39.144.2.123 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922056976109
[ sql ] [ DB ] CONNECT:[ UseTime:0.002690s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010586s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922056976109' LIMIT 1 [ RunTime:0.000793s ]
---------------------------------------------------------------
[ 2023-03-17T06:32:28+08:00 ] 39.144.2.123 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922056976109&create_time=1679005947&v1=0.028084&v2=0.631064&v3=0.028565&v4=0.028023&v5=12.420000&t=11.719758&h=39.494080&rssi=16&ccid=898604650119C1078513&imsi=460048590708513&v6=-00.000&end=
[ 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.011166s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922056976109' LIMIT 1 [ RunTime:0.000680s ]
[ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922056976109',`create_time`=1679005947,`v1`=0.028084,`v2`=0.631064,`v3`=0.028565,`v4`=0.028023,`v5`=12.42,`t`=11.719758,`h`=39.49408,`rssi`=16,`ccid`='898604650119C1078513',`imsi`='460048590708513',`v6`=-0,`update_time`=1679005948 WHERE `imei` = '868922056976109' [ RunTime:0.000691s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011264s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922056976109' , 1679005947 , 0.028084 , 0.631064 , 0.028565 , 0.028023 , 12.42 , 11.719758 , 39.49408 , 16 , '898604650119C1078513' , '460048590708513' , -0 , 1679005948) [ RunTime:0.001181s ]
---------------------------------------------------------------
[ 2023-03-17T07:32:27+08:00 ] 39.144.8.196 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922056976109
[ sql ] [ DB ] CONNECT:[ UseTime:0.002149s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011097s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922056976109' LIMIT 1 [ RunTime:0.000713s ]
---------------------------------------------------------------
[ 2023-03-17T07:32:28+08:00 ] 39.144.8.196 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922056976109&create_time=1679009547&v1=0.028023&v2=0.637949&v3=0.028565&v4=0.028084&v5=12.420000&t=12.288189&h=39.356750&rssi=17&ccid=898604650119C1078513&imsi=460048590708513&v6=-00.000&end=
[ sql ] [ DB ] CONNECT:[ UseTime:0.001714s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009633s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922056976109' LIMIT 1 [ RunTime:0.000659s ]
[ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922056976109',`create_time`=1679009547,`v1`=0.028023,`v2`=0.637949,`v3`=0.028565,`v4`=0.028084,`v5`=12.42,`t`=12.288189,`h`=39.35675,`rssi`=17,`ccid`='898604650119C1078513',`imsi`='460048590708513',`v6`=-0,`update_time`=1679009548 WHERE `imei` = '868922056976109' [ RunTime:0.000593s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.012590s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922056976109' , 1679009547 , 0.028023 , 0.637949 , 0.028565 , 0.028084 , 12.42 , 12.288189 , 39.35675 , 17 , '898604650119C1078513' , '460048590708513' , -0 , 1679009548) [ RunTime:0.000667s ]
---------------------------------------------------------------
[ 2023-03-17T08:32:26+08:00 ] 39.144.16.16 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922056976109
[ sql ] [ DB ] CONNECT:[ UseTime:0.002761s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012067s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922056976109' LIMIT 1 [ RunTime:0.001027s ]
---------------------------------------------------------------
[ 2023-03-17T08:32:28+08:00 ] 39.144.16.16 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922056976109&create_time=1679013146&v1=0.028144&v2=0.719205&v3=0.028565&v4=0.028023&v5=12.420000&t=12.620667&h=39.455933&rssi=16&ccid=898604650119C1078513&imsi=460048590708513&v6=-00.000&end=
[ sql ] [ DB ] CONNECT:[ UseTime:0.001630s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010337s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922056976109' LIMIT 1 [ RunTime:0.000676s ]
[ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922056976109',`create_time`=1679013146,`v1`=0.028144,`v2`=0.719205,`v3`=0.028565,`v4`=0.028023,`v5`=12.42,`t`=12.620667,`h`=39.455933,`rssi`=16,`ccid`='898604650119C1078513',`imsi`='460048590708513',`v6`=-0,`update_time`=1679013148 WHERE `imei` = '868922056976109' [ RunTime:0.000611s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.012226s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922056976109' , 1679013146 , 0.028144 , 0.719205 , 0.028565 , 0.028023 , 12.42 , 12.620667 , 39.455933 , 16 , '898604650119C1078513' , '460048590708513' , -0 , 1679013148) [ RunTime:0.000660s ]
---------------------------------------------------------------
[ 2023-03-17T09:32:28+08:00 ] 218.204.252.181 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922056976109
[ sql ] [ DB ] CONNECT:[ UseTime:0.002356s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011796s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922056976109' LIMIT 1 [ RunTime:0.000755s ]
---------------------------------------------------------------
[ 2023-03-17T09:32:31+08:00 ] 218.204.252.181 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922056976109&create_time=1679016748&v1=0.028204&v2=1.638785&v3=0.028656&v4=0.028023&v5=12.420000&t=13.843328&h=39.166016&rssi=16&ccid=898604650119C1078513&imsi=460048590708513&v6=-00.000&end=
[ sql ] [ DB ] CONNECT:[ UseTime:0.001680s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010104s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922056976109' LIMIT 1 [ RunTime:0.000716s ]
[ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922056976109',`create_time`=1679016748,`v1`=0.028204,`v2`=1.638785,`v3`=0.028656,`v4`=0.028023,`v5`=12.42,`t`=13.843328,`h`=39.166016,`rssi`=16,`ccid`='898604650119C1078513',`imsi`='460048590708513',`v6`=-0,`update_time`=1679016751 WHERE `imei` = '868922056976109' [ RunTime:0.000644s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011729s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922056976109' , 1679016748 , 0.028204 , 1.638785 , 0.028656 , 0.028023 , 12.42 , 13.843328 , 39.166016 , 16 , '898604650119C1078513' , '460048590708513' , -0 , 1679016751) [ RunTime:0.000637s ]
---------------------------------------------------------------
[ 2023-03-17T10:32:28+08:00 ] 221.178.125.141 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922056976109
[ sql ] [ DB ] CONNECT:[ UseTime:0.003001s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010583s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922056976109' LIMIT 1 [ RunTime:0.000715s ]
---------------------------------------------------------------
[ 2023-03-17T10:32:29+08:00 ] 221.178.125.141 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922056976109&create_time=1679020348&v1=0.028204&v2=1.031503&v3=0.028716&v4=0.028565&v5=12.420000&t=14.722786&h=39.211792&rssi=18&ccid=898604650119C1078513&imsi=460048590708513&v6=-00.000&end=
[ sql ] [ DB ] CONNECT:[ UseTime:0.001827s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011210s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922056976109' LIMIT 1 [ RunTime:0.000821s ]
[ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922056976109',`create_time`=1679020348,`v1`=0.028204,`v2`=1.031503,`v3`=0.028716,`v4`=0.028565,`v5`=12.42,`t`=14.722786,`h`=39.211792,`rssi`=18,`ccid`='898604650119C1078513',`imsi`='460048590708513',`v6`=-0,`update_time`=1679020349 WHERE `imei` = '868922056976109' [ RunTime:0.000647s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.012698s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922056976109' , 1679020348 , 0.028204 , 1.031503 , 0.028716 , 0.028565 , 12.42 , 14.722786 , 39.211792 , 18 , '898604650119C1078513' , '460048590708513' , -0 , 1679020349) [ RunTime:0.000672s ]
---------------------------------------------------------------
[ 2023-03-17T11:16:37+08:00 ] 27.223.153.169 POST /admin/login/login.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.003616s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_manager` [ RunTime:0.014134s ]
[ sql ] [ SQL ] SELECT * FROM `collect_manager` WHERE `username` = 'admin' AND `password` = 'b8c6b861afec5f2a9a13ad8f963df1c7' LIMIT 1 [ RunTime:0.000719s ]
---------------------------------------------------------------
[ 2023-03-17T11:16:40+08:00 ] 27.223.153.169 GET /admin/show/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001532s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011560s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000414s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000912s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000956s ]
---------------------------------------------------------------
[ 2023-03-17T11:16:45+08:00 ] 27.223.153.169 GET /admin/map/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.002139s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009337s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000977s ]
---------------------------------------------------------------
[ 2023-03-17T11:22:49+08:00 ] 27.223.153.169 GET /admin/show/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.002339s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009014s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000485s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000844s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001228s ]
---------------------------------------------------------------
[ 2023-03-17T11:22:51+08:00 ] 27.223.153.169 GET /admin/show/read/id/47/imei/868922055684209.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001779s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011251s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 47 LIMIT 1 [ RunTime:0.000732s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.012041s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055684209' LIMIT 1 [ RunTime:0.000505s ]
[ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055684209' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.001458s ]
---------------------------------------------------------------
[ 2023-03-17T11:22:55+08:00 ] 27.223.153.169 GET /admin/show/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.002170s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010388s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000430s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000818s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000797s ]
---------------------------------------------------------------
[ 2023-03-17T11:22:58+08:00 ] 27.223.153.169 GET /admin/show/read/id/41/imei/868922055644021.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001952s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.008529s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 41 LIMIT 1 [ RunTime:0.000645s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011001s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055644021' LIMIT 1 [ RunTime:0.000583s ]
[ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055644021' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.002976s ]
---------------------------------------------------------------
[ 2023-03-17T11:22:59+08:00 ] 27.223.153.169 GET /admin/show/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001930s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009388s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000516s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.001243s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000740s ]
---------------------------------------------------------------
[ 2023-03-17T11:23:07+08:00 ] 27.223.153.169 GET /admin/show/read/id/34/imei/868922055681494.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.002054s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010132s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 34 LIMIT 1 [ RunTime:0.000743s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009314s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055681494' LIMIT 1 [ RunTime:0.000567s ]
[ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055681494' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.003937s ]
---------------------------------------------------------------
[ 2023-03-17T11:23:16+08:00 ] 27.223.153.169 GET /admin/show/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.002035s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010096s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000341s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000782s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000843s ]
---------------------------------------------------------------
[ 2023-03-17T11:23:19+08:00 ] 27.223.153.169 GET /admin/show/index.html?page=2
[ sql ] [ DB ] CONNECT:[ UseTime:0.001972s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010999s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000390s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 10,10 [ RunTime:0.000865s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000772s ]
---------------------------------------------------------------
[ 2023-03-17T11:23:22+08:00 ] 27.223.153.169 GET /admin/show/read/id/33/imei/868922055644013.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001789s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009285s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 33 LIMIT 1 [ RunTime:0.000731s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010934s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000802s ]
[ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055644013' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.006147s ]
---------------------------------------------------------------
[ 2023-03-17T11:23:33+08:00 ] 27.223.153.169 GET /admin/show/index.html
[ 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.011316s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000385s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000810s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000883s ]
---------------------------------------------------------------
[ 2023-03-17T11:23:37+08:00 ] 27.223.153.169 GET /admin/show/edit/id/34.html
[ 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.010326s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 34 LIMIT 1 [ RunTime:0.000947s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.012666s ]
[ sql ] [ SQL ] SELECT * FROM `collect_user` WHERE `collect_user`.`delete_time` IS NULL [ RunTime:0.001242s ]
---------------------------------------------------------------
[ 2023-03-17T11:23:53+08:00 ] 27.223.153.169 GET /admin/show/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.002143s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010527s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000420s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000781s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000844s ]
---------------------------------------------------------------
[ 2023-03-17T11:23:56+08:00 ] 27.223.153.169 GET /admin/show/read/id/34/imei/868922055681494.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.002042s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011417s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 34 LIMIT 1 [ RunTime:0.000788s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011282s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055681494' LIMIT 1 [ RunTime:0.000572s ]
[ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055681494' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.001219s ]
---------------------------------------------------------------
[ 2023-03-17T11:23:58+08:00 ] 27.223.153.169 GET /admin/show/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001687s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009941s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000401s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000772s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000814s ]
---------------------------------------------------------------
[ 2023-03-17T11:24:03+08:00 ] 27.223.153.169 GET /admin/show/index.html?page=2
[ sql ] [ DB ] CONNECT:[ UseTime:0.002796s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009885s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000340s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 10,10 [ RunTime:0.000846s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000859s ]
---------------------------------------------------------------
[ 2023-03-17T11:24:06+08:00 ] 27.223.153.169 GET /admin/show/read/id/22/imei/868922055677740.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001837s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009152s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 22 LIMIT 1 [ RunTime:0.000733s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011668s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.001114s ]
[ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055677740' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.022721s ]
---------------------------------------------------------------
[ 2023-03-17T11:24:08+08:00 ] 27.223.153.169 GET /admin/show/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001841s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010709s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000548s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000826s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000811s ]
---------------------------------------------------------------
[ 2023-03-17T11:24:09+08:00 ] 27.223.153.169 GET /admin/show/index.html?page=2
[ sql ] [ DB ] CONNECT:[ UseTime:0.001963s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010879s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000381s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 10,10 [ RunTime:0.000902s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000777s ]
---------------------------------------------------------------
[ 2023-03-17T11:24:20+08:00 ] 27.223.153.169 GET /admin/show/edit/id/22.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.002223s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010548s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 22 LIMIT 1 [ RunTime:0.000709s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.011336s ]
[ sql ] [ SQL ] SELECT * FROM `collect_user` WHERE `collect_user`.`delete_time` IS NULL [ RunTime:0.000491s ]
---------------------------------------------------------------
[ 2023-03-17T11:24:35+08:00 ] 27.223.153.169 POST /admin/show/update.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001862s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009076s ]
[ sql ] [ SQL ] UPDATE `collect_show` SET `device_name`='STM32',`interval`=1440,`gps`='3601.007292,12009.762356',`username`='user1',`introduce`='stm32f103c8t6
2022.10.21安装在变电站高压线旁
',`update_time`=1679023475 WHERE `id` = 22 [ RunTime:0.000729s ]
---------------------------------------------------------------
[ 2023-03-17T11:24:36+08:00 ] 27.223.153.169 GET /admin/show/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001918s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010108s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000396s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000758s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000759s ]
---------------------------------------------------------------
[ 2023-03-17T11:24:41+08:00 ] 27.223.153.169 GET /admin/map/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001827s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012070s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001051s ]
---------------------------------------------------------------
[ 2023-03-17T11:27:24+08:00 ] 27.223.153.169 GET /admin/show/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.002364s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011027s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000566s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000818s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000854s ]
---------------------------------------------------------------
[ 2023-03-17T11:27:27+08:00 ] 27.223.153.169 GET /admin/show/index.html?page=2
[ sql ] [ DB ] CONNECT:[ UseTime:0.001978s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011347s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000417s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 10,10 [ RunTime:0.000943s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000817s ]
---------------------------------------------------------------
[ 2023-03-17T11:27:29+08:00 ] 27.223.153.169 GET /admin/show/read/id/22/imei/868922055677740.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.002033s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011041s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 22 LIMIT 1 [ RunTime:0.000811s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010352s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.001397s ]
[ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055677740' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.010759s ]
---------------------------------------------------------------
[ 2023-03-17T11:27:37+08:00 ] 27.223.153.169 GET /admin/show/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001901s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011740s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000424s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000878s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000888s ]
---------------------------------------------------------------
[ 2023-03-17T11:27:39+08:00 ] 27.223.153.169 GET /admin/show/index.html?page=2
[ sql ] [ DB ] CONNECT:[ UseTime:0.002330s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010926s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000422s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 10,10 [ RunTime:0.001007s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000920s ]
---------------------------------------------------------------
[ 2023-03-17T11:27:42+08:00 ] 27.223.153.169 GET /admin/show/edit/id/22.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001923s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009744s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 22 LIMIT 1 [ RunTime:0.000688s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.011300s ]
[ sql ] [ SQL ] SELECT * FROM `collect_user` WHERE `collect_user`.`delete_time` IS NULL [ RunTime:0.000520s ]
---------------------------------------------------------------
[ 2023-03-17T11:32:26+08:00 ] 39.144.18.24 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922056976109
[ sql ] [ DB ] CONNECT:[ UseTime:0.002009s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009557s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922056976109' LIMIT 1 [ RunTime:0.000714s ]
---------------------------------------------------------------
[ 2023-03-17T11:32:28+08:00 ] 39.144.18.24 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922056976109&create_time=1679023946&v1=0.027903&v2=1.501411&v3=0.028776&v4=0.028625&v5=12.420000&t=16.685478&h=38.960022&rssi=17&ccid=898604650119C1078513&imsi=460048590708513&v6=-00.000&end=
[ sql ] [ DB ] CONNECT:[ UseTime:0.001805s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009593s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922056976109' LIMIT 1 [ RunTime:0.000703s ]
[ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922056976109',`create_time`=1679023946,`v1`=0.027903,`v2`=1.501411,`v3`=0.028776,`v4`=0.028625,`v5`=12.42,`t`=16.685478,`h`=38.960022,`rssi`=17,`ccid`='898604650119C1078513',`imsi`='460048590708513',`v6`=-0,`update_time`=1679023948 WHERE `imei` = '868922056976109' [ RunTime:0.000560s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010066s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922056976109' , 1679023946 , 0.027903 , 1.501411 , 0.028776 , 0.028625 , 12.42 , 16.685478 , 38.960022 , 17 , '898604650119C1078513' , '460048590708513' , -0 , 1679023948) [ RunTime:0.000715s ]
---------------------------------------------------------------
[ 2023-03-17T12:32:27+08:00 ] 39.144.15.26 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922056976109
[ sql ] [ DB ] CONNECT:[ UseTime:0.002171s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.013506s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922056976109' LIMIT 1 [ RunTime:0.000712s ]
---------------------------------------------------------------
[ 2023-03-17T12:32:29+08:00 ] 39.144.15.26 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922056976109&create_time=1679027547&v1=0.028144&v2=0.997707&v3=0.028836&v4=0.028505&v5=12.600000&t=16.814180&h=39.333862&rssi=17&ccid=898604650119C1078513&imsi=460048590708513&v6=-00.000&end=
[ sql ] [ DB ] CONNECT:[ UseTime:0.001594s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011122s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922056976109' LIMIT 1 [ RunTime:0.000688s ]
[ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922056976109',`create_time`=1679027547,`v1`=0.028144,`v2`=0.997707,`v3`=0.028836,`v4`=0.028505,`v5`=12.6,`t`=16.81418,`h`=39.333862,`rssi`=17,`ccid`='898604650119C1078513',`imsi`='460048590708513',`v6`=-0,`update_time`=1679027549 WHERE `imei` = '868922056976109' [ RunTime:0.000619s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.016596s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922056976109' , 1679027547 , 0.028144 , 0.997707 , 0.028836 , 0.028505 , 12.6 , 16.81418 , 39.333862 , 17 , '898604650119C1078513' , '460048590708513' , -0 , 1679027549) [ RunTime:0.000709s ]
---------------------------------------------------------------
[ 2023-03-17T13:32:28+08:00 ] 218.204.252.139 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922056976109
[ sql ] [ DB ] CONNECT:[ UseTime:0.003111s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011527s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922056976109' LIMIT 1 [ RunTime:0.000680s ]
---------------------------------------------------------------
[ 2023-03-17T13:32:29+08:00 ] 218.204.252.139 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922056976109&create_time=1679031148&v1=0.028204&v2=1.545429&v3=0.028716&v4=0.028324&v5=12.420000&t=16.063423&h=39.661926&rssi=17&ccid=898604650119C1078513&imsi=460048590708513&v6=-00.000&end=
[ sql ] [ DB ] CONNECT:[ UseTime:0.001932s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010573s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922056976109' LIMIT 1 [ RunTime:0.000840s ]
[ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922056976109',`create_time`=1679031148,`v1`=0.028204,`v2`=1.545429,`v3`=0.028716,`v4`=0.028324,`v5`=12.42,`t`=16.063423,`h`=39.661926,`rssi`=17,`ccid`='898604650119C1078513',`imsi`='460048590708513',`v6`=-0,`update_time`=1679031149 WHERE `imei` = '868922056976109' [ RunTime:0.000577s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010558s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922056976109' , 1679031148 , 0.028204 , 1.545429 , 0.028716 , 0.028324 , 12.42 , 16.063423 , 39.661926 , 17 , '898604650119C1078513' , '460048590708513' , -0 , 1679031149) [ RunTime:0.000600s ]
---------------------------------------------------------------
[ 2023-03-17T14:03:55+08:00 ] 111.55.139.161 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013
[ sql ] [ DB ] CONNECT:[ UseTime:0.003460s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012024s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000726s ]
---------------------------------------------------------------
[ 2023-03-17T14:03:56+08:00 ] 117.132.191.68 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055643643
[ 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.013197s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.001763s ]
---------------------------------------------------------------
[ 2023-03-17T14:04:03+08:00 ] 111.55.139.161 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=230317&time=140301&v1=-00.233&v2=+00.002&v3=+00.020&v4=-00.017&v5=05.9&t=+15.7&h=63.1&rssi=+228&ccid=4600485905031430000099m9990000000038000000g2680,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.010178s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009621s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000657s ]
[ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644013',`date`='230317',`time`='140301',`v1`=-0.233,`v2`=0.002,`v3`=0.02,`v4`=-0.017,`v5`=5.9,`t`=15.7,`h`=63.1,`rssi`=228,`ccid`='4600485905031430000099m9990000000038000000g2680,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1679033043 WHERE `imei` = '868922055644013' [ RunTime:0.000605s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.012381s ]
[ 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' , '230317' , '140301' , -0.233 , 0.002 , 0.02 , -0.017 , 5.9 , 15.7 , 63.1 , 228 , '4600485905031430000099m9990000000038000000g2680,N,00E000=-00.000' , 0 , 0 , 1679033043 , 1679033043) [ RunTime:0.000647s ]
---------------------------------------------------------------
[ 2023-03-17T14:04:04+08:00 ] 117.132.191.68 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055643643&date=230317&time=140301&v1=-01.289&v2=+00.057&v3=-00.945&v4=-00.023&v5=05.9&t=+14.1&h=60.6&rssi=+231&ccid=4600485905031420000099m9990000000336000001g3000,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.003097s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010558s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.001236s ]
[ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055643643',`date`='230317',`time`='140301',`v1`=-1.289,`v2`=0.057,`v3`=-0.945,`v4`=-0.023,`v5`=5.9,`t`=14.1,`h`=60.6,`rssi`=231,`ccid`='4600485905031420000099m9990000000336000001g3000,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1679033044 WHERE `imei` = '868922055643643' [ RunTime:0.000531s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010712s ]
[ 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' , '230317' , '140301' , -1.289 , 0.057 , -0.945 , -0.023 , 5.9 , 14.1 , 60.6 , 231 , '4600485905031420000099m9990000000336000001g3000,N,00E000=-00.000' , 0 , 0 , 1679033044 , 1679033044) [ RunTime:0.000503s ]
---------------------------------------------------------------
[ 2023-03-17T14:28:02+08:00 ] 27.223.153.169 GET /admin/show/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.002459s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012600s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000469s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000916s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000930s ]
---------------------------------------------------------------
[ 2023-03-17T14:28:13+08:00 ] 27.223.153.169 GET /admin/show/read/id/43/imei/868922056976109.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001958s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010016s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 43 LIMIT 1 [ RunTime:0.000723s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011942s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922056976109' LIMIT 1 [ RunTime:0.000519s ]
[ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922056976109' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.000945s ]
---------------------------------------------------------------
[ 2023-03-17T14:28:21+08:00 ] 27.223.153.169 GET /admin/show/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.002155s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009999s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000385s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000735s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000837s ]
---------------------------------------------------------------
[ 2023-03-17T14:28:27+08:00 ] 27.223.153.169 GET /admin/show/edit/id/43.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001833s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011793s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 43 LIMIT 1 [ RunTime:0.000651s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.009196s ]
[ sql ] [ SQL ] SELECT * FROM `collect_user` WHERE `collect_user`.`delete_time` IS NULL [ RunTime:0.000476s ]
---------------------------------------------------------------
[ 2023-03-17T14:28:30+08:00 ] 27.223.153.169 POST /admin/show/update.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.002116s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009253s ]
[ sql ] [ SQL ] UPDATE `collect_show` SET `device_name`='',`interval`=720,`gps`='',`username`='admin',`introduce`=' ',`update_time`=1679034510 WHERE `id` = 43 [ RunTime:0.001342s ]
---------------------------------------------------------------
[ 2023-03-17T14:28:32+08:00 ] 27.223.153.169 GET /admin/show/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001726s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009075s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000386s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000849s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000785s ]
---------------------------------------------------------------
[ 2023-03-17T14:28:34+08:00 ] 27.223.153.169 GET /admin/show/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.002247s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011969s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000382s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000739s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000847s ]
---------------------------------------------------------------
[ 2023-03-17T14:28:54+08:00 ] 27.223.153.169 GET /admin/show/read/id/43/imei/868922056976109.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.002006s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011042s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 43 LIMIT 1 [ RunTime:0.000683s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010875s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922056976109' LIMIT 1 [ RunTime:0.000517s ]
[ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922056976109' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.000996s ]
---------------------------------------------------------------
[ 2023-03-17T14:29:01+08:00 ] 27.223.153.169 GET /admin/show/read/id/43/imei/868922056976109.html?page=2
[ sql ] [ DB ] CONNECT:[ UseTime:0.001969s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009816s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 43 LIMIT 1 [ RunTime:0.000660s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011945s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922056976109' LIMIT 1 [ RunTime:0.000540s ]
[ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922056976109' ORDER BY `update_time` DESC LIMIT 10,10 [ RunTime:0.000961s ]
---------------------------------------------------------------
[ 2023-03-17T14:32:29+08:00 ] 39.144.15.90 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922056976109
[ sql ] [ DB ] CONNECT:[ UseTime:0.001800s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011294s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922056976109' LIMIT 1 [ RunTime:0.000667s ]
---------------------------------------------------------------
[ 2023-03-17T14:32:31+08:00 ] 39.144.15.90 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922056976109&create_time=1679034749&v1=0.028264&v2=1.515284&v3=0.028957&v4=0.028084&v5=12.420000&t=16.556778&h=39.425415&rssi=31&ccid=898604650119C1078513&imsi=460048590708513&v6=-00.000&end=
[ sql ] [ DB ] CONNECT:[ UseTime:0.001885s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010159s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922056976109' LIMIT 1 [ RunTime:0.000731s ]
[ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922056976109',`create_time`=1679034749,`v1`=0.028264,`v2`=1.515284,`v3`=0.028957,`v4`=0.028084,`v5`=12.42,`t`=16.556778,`h`=39.425415,`rssi`=31,`ccid`='898604650119C1078513',`imsi`='460048590708513',`v6`=-0,`update_time`=1679034751 WHERE `imei` = '868922056976109' [ RunTime:0.000538s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010887s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922056976109' , 1679034749 , 0.028264 , 1.515284 , 0.028957 , 0.028084 , 12.42 , 16.556778 , 39.425415 , 31 , '898604650119C1078513' , '460048590708513' , -0 , 1679034751) [ RunTime:0.000592s ]
---------------------------------------------------------------
[ 2023-03-17T14:33:14+08:00 ] 39.144.5.237 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055677740
[ sql ] [ DB ] CONNECT:[ UseTime:0.001655s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010826s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000661s ]
---------------------------------------------------------------
[ 2023-03-17T14:33:15+08:00 ] 39.144.5.237 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055677740&create_time=1679034794&v1=0.007435&v2=14.592186&v3=0.007495&v4=0.007856&v5=13.140000&t=20.782354&h=38.273407&rssi=15&ccid=89860426102071188504&imsi=460044618415254&v6=-00.000&end
[ sql ] [ DB ] CONNECT:[ UseTime:0.001596s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010017s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000720s ]
[ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055677740',`create_time`=1679034794,`v1`=0.007435,`v2`=14.592186,`v3`=0.007495,`v4`=0.007856,`v5`=13.14,`t`=20.782354,`h`=38.273407,`rssi`=15,`ccid`='89860426102071188504',`imsi`='460044618415254',`v6`=-0,`update_time`=1679034795 WHERE `imei` = '868922055677740' [ RunTime:0.000594s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010283s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055677740' , 1679034794 , 0.007435 , 14.592186 , 0.007495 , 0.007856 , 13.14 , 20.782354 , 38.273407 , 15 , '89860426102071188504' , '460044618415254' , -0 , 1679034795) [ RunTime:0.000606s ]
---------------------------------------------------------------
[ 2023-03-17T14:39:02+08:00 ] 27.223.153.169 GET /admin/show/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.002160s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009335s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000410s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000791s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001277s ]
---------------------------------------------------------------
[ 2023-03-17T14:39:04+08:00 ] 27.223.153.169 GET /admin/show/index.html?page=2
[ sql ] [ DB ] CONNECT:[ UseTime:0.001607s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010643s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000329s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 10,10 [ RunTime:0.001272s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000768s ]
---------------------------------------------------------------
[ 2023-03-17T14:39:08+08:00 ] 27.223.153.169 GET /admin/show/read/id/22/imei/868922055677740.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001879s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010215s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 22 LIMIT 1 [ RunTime:0.000673s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011690s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.001228s ]
[ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055677740' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.012316s ]
---------------------------------------------------------------
[ 2023-03-17T14:39:10+08:00 ] 27.223.153.169 GET /admin/show/read/id/22/imei/868922055677740.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001639s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011729s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 22 LIMIT 1 [ RunTime:0.000674s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010321s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000998s ]
[ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055677740' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.010813s ]
---------------------------------------------------------------
[ 2023-03-17T14:51:36+08:00 ] 111.55.137.20 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055677740
[ sql ] [ DB ] CONNECT:[ UseTime:0.002747s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011208s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000675s ]
---------------------------------------------------------------
[ 2023-03-17T15:02:54+08:00 ] 39.144.7.68 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055677740
[ sql ] [ DB ] CONNECT:[ UseTime:0.002311s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009903s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000649s ]
---------------------------------------------------------------
[ 2023-03-17T15:02:59+08:00 ] 39.144.7.68 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055677740&create_time=1420041627&v1=0.007375&v2=11.149391&v3=0.007224&v4=0.007555&v5=13.140000&t=20.782354&h=37.685944&rssi=30&ccid=89860426102071188504&imsi=460044618415254&v6=-00.000&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.001500s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010634s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000628s ]
[ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055677740',`create_time`=1420041627,`v1`=0.007375,`v2`=11.149391,`v3`=0.007224,`v4`=0.007555,`v5`=13.14,`t`=20.782354,`h`=37.685944,`rssi`=30,`ccid`='89860426102071188504',`imsi`='460044618415254',`v6`=-0,`update_time`=1679036579 WHERE `imei` = '868922055677740' [ RunTime:0.000590s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009739s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055677740' , 1420041627 , 0.007375 , 11.149391 , 0.007224 , 0.007555 , 13.14 , 20.782354 , 37.685944 , 30 , '89860426102071188504' , '460044618415254' , -0 , 1679036579) [ RunTime:0.000604s ]
---------------------------------------------------------------
[ 2023-03-17T15:06:02+08:00 ] 27.223.153.169 GET /admin/show/read/id/22/imei/868922055677740.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001745s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:2.209346s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 22 LIMIT 1 [ RunTime:0.001283s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011406s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.001441s ]
[ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055677740' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.010752s ]
---------------------------------------------------------------
[ 2023-03-17T15:06:17+08:00 ] 111.55.136.209 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055677740
[ sql ] [ DB ] CONNECT:[ UseTime:0.002093s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010887s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000796s ]
---------------------------------------------------------------
[ 2023-03-17T15:06:22+08:00 ] 111.55.136.209 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055677740&create_time=1420041628&v1=0.007314&v2=9.792551&v3=0.007555&v4=0.007736&v5=13.140000&t=21.533110&h=35.435272&rssi=28&ccid=89860426102071188504&imsi=460044618415254&v6=-00.000&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.002014s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010534s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000675s ]
[ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055677740',`create_time`=1420041628,`v1`=0.007314,`v2`=9.792551,`v3`=0.007555,`v4`=0.007736,`v5`=13.14,`t`=21.53311,`h`=35.435272,`rssi`=28,`ccid`='89860426102071188504',`imsi`='460044618415254',`v6`=-0,`update_time`=1679036782 WHERE `imei` = '868922055677740' [ RunTime:0.000532s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010290s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055677740' , 1420041628 , 0.007314 , 9.792551 , 0.007555 , 0.007736 , 13.14 , 21.53311 , 35.435272 , 28 , '89860426102071188504' , '460044618415254' , -0 , 1679036782) [ RunTime:0.000559s ]
---------------------------------------------------------------
[ 2023-03-17T15:06:32+08:00 ] 27.223.153.169 GET /admin/show/read/id/22/imei/868922055677740.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001990s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011401s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 22 LIMIT 1 [ RunTime:0.000750s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010126s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000942s ]
[ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055677740' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.010079s ]
---------------------------------------------------------------
[ 2023-03-17T15:07:15+08:00 ] 39.144.10.223 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055677740
[ sql ] [ DB ] CONNECT:[ UseTime:0.001536s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009195s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000705s ]
---------------------------------------------------------------
[ 2023-03-17T15:07:21+08:00 ] 39.144.10.223 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055677740&create_time=1420041686&v1=0.007495&v2=9.652361&v3=0.007555&v4=0.007615&v5=13.140000&t=22.423292&h=34.641815&rssi=29&ccid=89860426102071188504&imsi=460044618415254&v6=-00.000&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.001620s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009664s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000649s ]
[ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055677740',`create_time`=1420041686,`v1`=0.007495,`v2`=9.652361,`v3`=0.007555,`v4`=0.007615,`v5`=13.14,`t`=22.423292,`h`=34.641815,`rssi`=29,`ccid`='89860426102071188504',`imsi`='460044618415254',`v6`=-0,`update_time`=1679036840 WHERE `imei` = '868922055677740' [ RunTime:0.000522s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009461s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055677740' , 1420041686 , 0.007495 , 9.652361 , 0.007555 , 0.007615 , 13.14 , 22.423292 , 34.641815 , 29 , '89860426102071188504' , '460044618415254' , -0 , 1679036840) [ RunTime:0.000477s ]
---------------------------------------------------------------
[ 2023-03-17T15:07:47+08:00 ] 27.223.153.169 GET /admin/show/read/id/22/imei/868922055677740.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001845s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.013796s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 22 LIMIT 1 [ RunTime:0.000669s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009520s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000963s ]
[ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055677740' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.010337s ]
---------------------------------------------------------------
[ 2023-03-17T15:07:49+08:00 ] 27.223.153.169 GET /admin/show/read/id/22/imei/868922055677740.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001652s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010745s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 22 LIMIT 1 [ RunTime:0.000681s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011442s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000971s ]
[ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055677740' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.010219s ]
---------------------------------------------------------------
[ 2023-03-17T15:10:47+08:00 ] 27.223.153.169 GET /admin/show/read/id/22/imei/868922055677740.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.002568s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009702s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 22 LIMIT 1 [ RunTime:0.000692s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010985s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000996s ]
[ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055677740' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.010118s ]
---------------------------------------------------------------
[ 2023-03-17T15:27:57+08:00 ] 111.55.136.185 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055677740
[ sql ] [ DB ] CONNECT:[ UseTime:0.003425s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.013372s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000738s ]
---------------------------------------------------------------
[ 2023-03-17T15:28:02+08:00 ] 111.55.136.185 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055677740&create_time=1420041628&v1=0.007435&v2=9.081900&v3=0.007585&v4=0.007676&v5=13.140000&t=21.082657&h=37.182404&rssi=28&ccid=89860426102071188504&imsi=460044618415254&v6=-00.000&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.001687s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009912s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000652s ]
[ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055677740',`create_time`=1420041628,`v1`=0.007435,`v2`=9.0819,`v3`=0.007585,`v4`=0.007676,`v5`=13.14,`t`=21.082657,`h`=37.182404,`rssi`=28,`ccid`='89860426102071188504',`imsi`='460044618415254',`v6`=-0,`update_time`=1679038082 WHERE `imei` = '868922055677740' [ RunTime:0.000608s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010831s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055677740' , 1420041628 , 0.007435 , 9.0819 , 0.007585 , 0.007676 , 13.14 , 21.082657 , 37.182404 , 28 , '89860426102071188504' , '460044618415254' , -0 , 1679038082) [ RunTime:0.000595s ]