stm32f103c8t6
2022.10.21安装在变电站高压线旁
',`update_time`=1678149955 WHERE `id` = 22 [ RunTime:0.000797s ] --------------------------------------------------------------- [ 2023-03-07T08:45:57+08:00 ] 27.193.105.202 GET /admin/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002146s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.008995s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000346s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000754s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000747s ] --------------------------------------------------------------- [ 2023-03-07T08:45:59+08:00 ] 27.193.105.202 GET /admin/show/index.html?page=2 [ sql ] [ DB ] CONNECT:[ UseTime:0.001757s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010817s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000386s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 10,10 [ RunTime:0.000774s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000797s ] --------------------------------------------------------------- [ 2023-03-07T08:46:19+08:00 ] 27.193.105.202 GET /admin/show/read/id/22/imei/868922055677740.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002250s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012132s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 22 LIMIT 1 [ RunTime:0.000711s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.018347s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.005356s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055677740' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.019836s ] --------------------------------------------------------------- [ 2023-03-07T08:46:33+08:00 ] 27.193.105.202 GET /admin/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001887s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012187s ] [ 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.000804s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000702s ] --------------------------------------------------------------- [ 2023-03-07T08:46:35+08:00 ] 27.193.105.202 GET /admin/show/index.html?page=2 [ sql ] [ DB ] CONNECT:[ UseTime:0.001625s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011808s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000440s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 10,10 [ RunTime:0.000808s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000810s ] --------------------------------------------------------------- [ 2023-03-07T08:46:47+08:00 ] 27.193.105.202 GET /admin/show/edit/id/22.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002564s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010730s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 22 LIMIT 1 [ RunTime:0.000679s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.010878s ] [ sql ] [ SQL ] SELECT * FROM `collect_user` WHERE `collect_user`.`delete_time` IS NULL [ RunTime:0.000495s ] --------------------------------------------------------------- [ 2023-03-07T08:46:52+08:00 ] 27.193.105.202 POST /admin/show/update.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001695s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009887s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `device_name`='STM32',`interval`=1440,`gps`='120.082436,36.159645',`username`='user1',`introduce`='stm32f103c8t6
2022.10.21安装在变电站高压线旁
',`update_time`=1678150012 WHERE `id` = 22 [ RunTime:0.000544s ] --------------------------------------------------------------- [ 2023-03-07T08:46:53+08:00 ] 27.193.105.202 GET /admin/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001919s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009842s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000380s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000764s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000802s ] --------------------------------------------------------------- [ 2023-03-07T08:53:28+08:00 ] 27.193.105.202 GET /admin/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002578s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.013730s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000742s ] [ 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.000791s ] --------------------------------------------------------------- [ 2023-03-07T09:07:18+08:00 ] 27.193.105.202 GET /admin/show/index.html?page=2 [ sql ] [ DB ] CONNECT:[ UseTime:0.002250s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009143s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000379s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 10,10 [ RunTime:0.000822s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000735s ] --------------------------------------------------------------- [ 2023-03-07T09:18:20+08:00 ] 117.132.195.71 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055677740 [ sql ] [ DB ] CONNECT:[ UseTime:0.010191s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010351s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000720s ] --------------------------------------------------------------- [ 2023-03-07T09:18:21+08:00 ] 117.132.195.71 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055677740&create_time=1678151900&v1=0.013033&v2=0.176802&v3=0.007766&v4=0.021100&v5=11.160000&t=14.583259&h=59.582321&rssi=17&ccid=89860426102071188504&imsi=460044618415254&v6=-00.000&end= [ sql ] [ DB ] CONNECT:[ UseTime:0.002151s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010628s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000914s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055677740',`create_time`=1678151900,`v1`=0.013033,`v2`=0.176802,`v3`=0.007766,`v4`=0.0211,`v5`=11.16,`t`=14.583259,`h`=59.582321,`rssi`=17,`ccid`='89860426102071188504',`imsi`='460044618415254',`v6`=-0,`update_time`=1678151901 WHERE `imei` = '868922055677740' [ RunTime:0.000623s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011743s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055677740' , 1678151900 , 0.013033 , 0.176802 , 0.007766 , 0.0211 , 11.16 , 14.583259 , 59.582321 , 17 , '89860426102071188504' , '460044618415254' , -0 , 1678151901) [ RunTime:0.000623s ] --------------------------------------------------------------- [ 2023-03-07T09:48:20+08:00 ] 27.193.105.202 GET /admin/show/read/id/22/imei/868922055677740.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002301s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011063s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 22 LIMIT 1 [ RunTime:0.000941s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010920s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.001106s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055677740' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.010142s ] --------------------------------------------------------------- [ 2023-03-07T09:49:30+08:00 ] 27.193.105.202 GET /admin/thermocouple/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001531s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_thermocouple` [ RunTime:0.014610s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_thermocouple` LIMIT 1 [ RunTime:0.000386s ] [ sql ] [ SQL ] SELECT * FROM `collect_thermocouple` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000408s ] [ sql ] [ SQL ] SELECT * FROM `collect_thermocouple` ORDER BY `id` DESC [ RunTime:0.000432s ] --------------------------------------------------------------- [ 2023-03-07T09:49:33+08:00 ] 27.193.105.202 GET /admin/shelves/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001550s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_shelves` [ RunTime:0.013714s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_shelves` LIMIT 1 [ RunTime:0.000389s ] [ sql ] [ SQL ] SELECT * FROM `collect_shelves` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000539s ] [ sql ] [ SQL ] SELECT * FROM `collect_shelves` ORDER BY `id` DESC [ RunTime:0.000497s ] --------------------------------------------------------------- [ 2023-03-07T09:49:36+08:00 ] 27.193.105.202 GET /admin/thermocouple/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001734s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_thermocouple` [ RunTime:0.009454s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_thermocouple` LIMIT 1 [ RunTime:0.000378s ] [ sql ] [ SQL ] SELECT * FROM `collect_thermocouple` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000397s ] [ sql ] [ SQL ] SELECT * FROM `collect_thermocouple` ORDER BY `id` DESC [ RunTime:0.000441s ] --------------------------------------------------------------- [ 2023-03-07T09:49:37+08:00 ] 27.193.105.202 GET /admin/device/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001920s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.012832s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_device` LIMIT 1 [ RunTime:0.000395s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.001186s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` ORDER BY `id` DESC [ RunTime:0.000581s ] --------------------------------------------------------------- [ 2023-03-07T09:49:38+08:00 ] 27.193.105.202 GET /admin/thermocouple/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002473s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_thermocouple` [ RunTime:0.013651s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_thermocouple` LIMIT 1 [ RunTime:0.000520s ] [ sql ] [ SQL ] SELECT * FROM `collect_thermocouple` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000362s ] [ sql ] [ SQL ] SELECT * FROM `collect_thermocouple` ORDER BY `id` DESC [ RunTime:0.000445s ] --------------------------------------------------------------- [ 2023-03-07T10:13:08+08:00 ] 27.193.105.202 GET /admin/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002211s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.014247s ] [ 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 0,10 [ RunTime:0.000798s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000703s ] --------------------------------------------------------------- [ 2023-03-07T14:03:54+08:00 ] 39.144.14.87 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013 [ sql ] [ DB ] CONNECT:[ UseTime:0.002205s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010489s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000707s ] --------------------------------------------------------------- [ 2023-03-07T14:03:55+08:00 ] 111.55.137.215 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055643643 [ sql ] [ DB ] CONNECT:[ UseTime:0.001478s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011331s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000656s ] --------------------------------------------------------------- [ 2023-03-07T14:04:03+08:00 ] 39.144.14.87 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=230307&time=140301&v1=-00.254&v2=+00.002&v3=+00.019&v4=-00.017&v5=06.0&t=+23.0&h=64.3&rssi=+225&ccid=4600485905031430000099m9990000000040000000g2960,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002362s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009826s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000704s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644013',`date`='230307',`time`='140301',`v1`=-0.254,`v2`=0.002,`v3`=0.019,`v4`=-0.017,`v5`=6,`t`=23,`h`=64.3,`rssi`=225,`ccid`='4600485905031430000099m9990000000040000000g2960,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1678169043 WHERE `imei` = '868922055644013' [ RunTime:0.000642s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.012045s ] [ 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' , '230307' , '140301' , -0.254 , 0.002 , 0.019 , -0.017 , 6 , 23 , 64.3 , 225 , '4600485905031430000099m9990000000040000000g2960,N,00E000=-00.000' , 0 , 0 , 1678169043 , 1678169043) [ RunTime:0.000680s ] --------------------------------------------------------------- [ 2023-03-07T14:04:03+08:00 ] 111.55.137.215 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055643643&date=230307&time=140301&v1=-01.288&v2=+00.053&v3=-00.973&v4=-00.020&v5=05.9&t=+19.4&h=60.7&rssi=+231&ccid=4600485905031420000099m9990000000312000001g2980,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001545s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010803s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000638s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055643643',`date`='230307',`time`='140301',`v1`=-1.288,`v2`=0.053,`v3`=-0.973,`v4`=-0.02,`v5`=5.9,`t`=19.4,`h`=60.7,`rssi`=231,`ccid`='4600485905031420000099m9990000000312000001g2980,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1678169043 WHERE `imei` = '868922055643643' [ RunTime:0.000505s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.008830s ] [ 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' , '230307' , '140301' , -1.288 , 0.053 , -0.973 , -0.02 , 5.9 , 19.4 , 60.7 , 231 , '4600485905031420000099m9990000000312000001g2980,N,00E000=-00.000' , 0 , 0 , 1678169043 , 1678169043) [ RunTime:0.000520s ] --------------------------------------------------------------- [ 2023-03-07T14:24:03+08:00 ] 117.132.194.26 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055677740 [ sql ] [ DB ] CONNECT:[ UseTime:0.002786s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011903s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000735s ] --------------------------------------------------------------- [ 2023-03-07T14:24:05+08:00 ] 117.132.194.26 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055677740&create_time=1678170243&v1=0.008819&v2=0.678107&v3=0.007585&v4=0.011348&v5=12.240000&t=17.253803&h=61.169239&rssi=17&ccid=89860426102071188504&imsi=460044618415254&v6=-00.000&end= [ sql ] [ DB ] CONNECT:[ UseTime:0.001717s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009842s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000677s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055677740',`create_time`=1678170243,`v1`=0.008819,`v2`=0.678107,`v3`=0.007585,`v4`=0.011348,`v5`=12.24,`t`=17.253803,`h`=61.169239,`rssi`=17,`ccid`='89860426102071188504',`imsi`='460044618415254',`v6`=-0,`update_time`=1678170245 WHERE `imei` = '868922055677740' [ RunTime:0.000598s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011723s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055677740' , 1678170243 , 0.008819 , 0.678107 , 0.007585 , 0.011348 , 12.24 , 17.253803 , 61.169239 , 17 , '89860426102071188504' , '460044618415254' , -0 , 1678170245) [ RunTime:0.000742s ] --------------------------------------------------------------- [ 2023-03-07T14:38:08+08:00 ] 39.144.7.108 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055677740 [ sql ] [ DB ] CONNECT:[ UseTime:0.002585s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009949s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000911s ] --------------------------------------------------------------- [ 2023-03-07T14:38:09+08:00 ] 39.144.7.108 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055677740&create_time=1678171088&v1=0.007555&v2=1.155838&v3=0.007224&v4=0.014358&v5=12.060000&t=17.489756&h=60.825916&rssi=16&ccid=89860426102071188504&imsi=460044618415254&v6=-00.000&end= [ sql ] [ DB ] CONNECT:[ UseTime:0.001643s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010466s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000783s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055677740',`create_time`=1678171088,`v1`=0.007555,`v2`=1.155838,`v3`=0.007224,`v4`=0.014358,`v5`=12.06,`t`=17.489756,`h`=60.825916,`rssi`=16,`ccid`='89860426102071188504',`imsi`='460044618415254',`v6`=-0,`update_time`=1678171089 WHERE `imei` = '868922055677740' [ RunTime:0.000569s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011446s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055677740' , 1678171088 , 0.007555 , 1.155838 , 0.007224 , 0.014358 , 12.06 , 17.489756 , 60.825916 , 16 , '89860426102071188504' , '460044618415254' , -0 , 1678171089) [ RunTime:0.000635s ] --------------------------------------------------------------- [ 2023-03-07T14:40:27+08:00 ] 111.55.137.159 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055677740 [ sql ] [ DB ] CONNECT:[ UseTime:0.002287s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009896s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000708s ] --------------------------------------------------------------- [ 2023-03-07T14:40:29+08:00 ] 111.55.137.159 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055677740&create_time=1678171227&v1=0.007194&v2=13.637245&v3=0.007344&v4=0.006712&v5=12.060000&t=18.487186&h=58.842270&rssi=18&ccid=89860426102071188504&imsi=460044618415254&v6=-00.000&end [ sql ] [ DB ] CONNECT:[ UseTime:0.001677s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009945s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000657s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055677740',`create_time`=1678171227,`v1`=0.007194,`v2`=13.637245,`v3`=0.007344,`v4`=0.006712,`v5`=12.06,`t`=18.487186,`h`=58.84227,`rssi`=18,`ccid`='89860426102071188504',`imsi`='460044618415254',`v6`=-0,`update_time`=1678171229 WHERE `imei` = '868922055677740' [ RunTime:0.000538s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009701s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055677740' , 1678171227 , 0.007194 , 13.637245 , 0.007344 , 0.006712 , 12.06 , 18.487186 , 58.84227 , 18 , '89860426102071188504' , '460044618415254' , -0 , 1678171229) [ RunTime:0.000515s ] --------------------------------------------------------------- [ 2023-03-07T14:43:06+08:00 ] 39.144.2.236 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055677740 [ sql ] [ DB ] CONNECT:[ UseTime:0.002290s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012163s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000757s ] --------------------------------------------------------------- [ 2023-03-07T14:43:08+08:00 ] 39.144.2.236 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055677740&create_time=1678171386&v1=0.007074&v2=13.814152&v3=0.006983&v4=0.006351&v5=12.060000&t=18.937641&h=58.010666&rssi=17&ccid=89860426102071188504&imsi=460044618415254&v6=-00.000&end [ 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.011056s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000650s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055677740',`create_time`=1678171386,`v1`=0.007074,`v2`=13.814152,`v3`=0.006983,`v4`=0.006351,`v5`=12.06,`t`=18.937641,`h`=58.010666,`rssi`=17,`ccid`='89860426102071188504',`imsi`='460044618415254',`v6`=-0,`update_time`=1678171388 WHERE `imei` = '868922055677740' [ RunTime:0.000593s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011665s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055677740' , 1678171386 , 0.007074 , 13.814152 , 0.006983 , 0.006351 , 12.06 , 18.937641 , 58.010666 , 17 , '89860426102071188504' , '460044618415254' , -0 , 1678171388) [ RunTime:0.000647s ] --------------------------------------------------------------- [ 2023-03-07T14:45:46+08:00 ] 111.55.139.76 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055677740 [ sql ] [ DB ] CONNECT:[ UseTime:0.002345s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010361s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000666s ] --------------------------------------------------------------- [ 2023-03-07T14:45:48+08:00 ] 111.55.139.76 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055677740&create_time=1678171546&v1=0.006833&v2=14.121756&v3=0.007013&v4=0.005569&v5=12.060000&t=19.184317&h=57.583420&rssi=18&ccid=89860426102071188504&imsi=460044618415254&v6=-00.000&end [ sql ] [ DB ] CONNECT:[ UseTime:0.001965s ] 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` = '868922055677740' LIMIT 1 [ RunTime:0.000649s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055677740',`create_time`=1678171546,`v1`=0.006833,`v2`=14.121756,`v3`=0.007013,`v4`=0.005569,`v5`=12.06,`t`=19.184317,`h`=57.58342,`rssi`=18,`ccid`='89860426102071188504',`imsi`='460044618415254',`v6`=-0,`update_time`=1678171548 WHERE `imei` = '868922055677740' [ RunTime:0.000506s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010547s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055677740' , 1678171546 , 0.006833 , 14.121756 , 0.007013 , 0.005569 , 12.06 , 19.184317 , 57.58342 , 18 , '89860426102071188504' , '460044618415254' , -0 , 1678171548) [ RunTime:0.000522s ] --------------------------------------------------------------- [ 2023-03-07T14:48:14+08:00 ] 39.144.8.76 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055677740 [ sql ] [ DB ] CONNECT:[ UseTime:0.002342s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010523s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000738s ] --------------------------------------------------------------- [ 2023-03-07T14:48:16+08:00 ] 39.144.8.76 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055677740&create_time=1678171694&v1=0.011468&v2=0.397310&v3=0.007826&v4=0.008398&v5=12.060000&t=19.463169&h=57.148544&rssi=17&ccid=89860426102071188504&imsi=460044618415254&v6=-00.000&end= [ sql ] [ DB ] CONNECT:[ UseTime:0.003033s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011806s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000708s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055677740',`create_time`=1678171694,`v1`=0.011468,`v2`=0.39731,`v3`=0.007826,`v4`=0.008398,`v5`=12.06,`t`=19.463169,`h`=57.148544,`rssi`=17,`ccid`='89860426102071188504',`imsi`='460044618415254',`v6`=-0,`update_time`=1678171696 WHERE `imei` = '868922055677740' [ RunTime:0.000526s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.009935s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055677740' , 1678171694 , 0.011468 , 0.39731 , 0.007826 , 0.008398 , 12.06 , 19.463169 , 57.148544 , 17 , '89860426102071188504' , '460044618415254' , -0 , 1678171696) [ RunTime:0.000540s ]