--------------------------------------------------------------- [ 2023-04-11T02:03:54+08:00 ] 221.178.127.20 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055643643 [ sql ] [ DB ] CONNECT:[ UseTime:0.003084s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.015115s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.001401s ] --------------------------------------------------------------- [ 2023-04-11T02:03:55+08:00 ] 39.144.6.209 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013 [ sql ] [ DB ] CONNECT:[ UseTime:0.001675s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.008968s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000791s ] --------------------------------------------------------------- [ 2023-04-11T02:04:02+08:00 ] 221.178.127.20 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055643643&date=230411&time=020301&v1=-01.330&v2=+00.017&v3=-01.005&v4=-00.023&v5=06.2&t=+15.4&h=61.7&rssi=+228&ccid=4600485905031420000099m9990000000326000001g3400,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001645s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009623s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000651s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055643643',`date`='230411',`time`='020301',`v1`=-1.33,`v2`=0.017,`v3`=-1.005,`v4`=-0.023,`v5`=6.2,`t`=15.4,`h`=61.7,`rssi`=228,`ccid`='4600485905031420000099m9990000000326000001g3400,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1681149842 WHERE `imei` = '868922055643643' [ RunTime:0.000701s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.014288s ] [ 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' , '230411' , '020301' , -1.33 , 0.017 , -1.005 , -0.023 , 6.2 , 15.4 , 61.7 , 228 , '4600485905031420000099m9990000000326000001g3400,N,00E000=-00.000' , 0 , 0 , 1681149842 , 1681149842) [ RunTime:0.001305s ] --------------------------------------------------------------- [ 2023-04-11T02:04:04+08:00 ] 39.144.6.209 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=230411&time=020301&v1=-00.344&v2=+00.001&v3=+00.018&v4=-00.033&v5=05.9&t=+16.9&h=64.4&rssi=+226&ccid=4600485905031430000099m9990000000101000000g3760,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ 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.011199s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000688s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644013',`date`='230411',`time`='020301',`v1`=-0.344,`v2`=0.001,`v3`=0.018,`v4`=-0.033,`v5`=5.9,`t`=16.9,`h`=64.4,`rssi`=226,`ccid`='4600485905031430000099m9990000000101000000g3760,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1681149844 WHERE `imei` = '868922055644013' [ RunTime:0.000562s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010883s ] [ 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' , '230411' , '020301' , -0.344 , 0.001 , 0.018 , -0.033 , 5.9 , 16.9 , 64.4 , 226 , '4600485905031430000099m9990000000101000000g3760,N,00E000=-00.000' , 0 , 0 , 1681149844 , 1681149844) [ RunTime:0.000543s ] --------------------------------------------------------------- [ 2023-04-11T10:08:50+08:00 ] 39.144.12.65 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684076 [ sql ] [ DB ] CONNECT:[ UseTime:0.002004s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011199s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000673s ] --------------------------------------------------------------- [ 2023-04-11T10:08:59+08:00 ] 39.144.12.65 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055684076&date=230411&time=100801&v1=-01.067&v2=+00.040&v3=-00.963&v4=-00.251&v5=06.0&t=+20.0&h=80.0&rssi=+228&imsi=460044618415249&v6=-00.000&a1=00.138&a2=01.165&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002010s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009457s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000682s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684076',`date`='230411',`time`='100801',`v1`=-1.067,`v2`=0.04,`v3`=-0.963,`v4`=-0.251,`v5`=6,`t`=20,`h`=80,`rssi`=228,`imsi`='460044618415249',`v6`=-0,`a1`=0.138,`a2`=1.165,`update_time`=1681178939 WHERE `imei` = '868922055684076' [ RunTime:0.000681s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011816s ] [ 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' , '230411' , '100801' , -1.067 , 0.04 , -0.963 , -0.251 , 6 , 20 , 80 , 228 , '460044618415249' , -0 , 0.138 , 1.165 , 1681178939 , 1681178939) [ RunTime:0.000610s ] --------------------------------------------------------------- [ 2023-04-11T14:03:54+08:00 ] 111.55.136.239 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055643643 [ sql ] [ DB ] CONNECT:[ UseTime:0.003268s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010807s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000982s ] --------------------------------------------------------------- [ 2023-04-11T14:03:55+08:00 ] 221.178.126.106 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013 [ sql ] [ DB ] CONNECT:[ UseTime:0.002416s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009637s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000634s ] --------------------------------------------------------------- [ 2023-04-11T14:04:02+08:00 ] 111.55.136.239 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055643643&date=230411&time=140301&v1=-01.331&v2=+00.043&v3=-00.984&v4=-00.022&v5=05.7&t=+17.3&h=61.8&rssi=+231&ccid=4600485905031420000099m9990000000349000001g3420,N,00E000=-00.000&a1=00.000&a2=00.000&a3=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.010792s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000667s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055643643',`date`='230411',`time`='140301',`v1`=-1.331,`v2`=0.043,`v3`=-0.984,`v4`=-0.022,`v5`=5.7,`t`=17.3,`h`=61.8,`rssi`=231,`ccid`='4600485905031420000099m9990000000349000001g3420,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1681193042 WHERE `imei` = '868922055643643' [ RunTime:0.000750s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010982s ] [ 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' , '230411' , '140301' , -1.331 , 0.043 , -0.984 , -0.022 , 5.7 , 17.3 , 61.8 , 231 , '4600485905031420000099m9990000000349000001g3420,N,00E000=-00.000' , 0 , 0 , 1681193042 , 1681193042) [ RunTime:0.001343s ] --------------------------------------------------------------- [ 2023-04-11T14:04:04+08:00 ] 221.178.126.106 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=230411&time=140301&v1=-00.300&v2=+00.002&v3=+00.031&v4=-00.037&v5=06.0&t=+17.4&h=65.1&rssi=+225&ccid=4600485905031430000099m9990000000057000000g3260,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001543s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009845s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000652s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644013',`date`='230411',`time`='140301',`v1`=-0.3,`v2`=0.002,`v3`=0.031,`v4`=-0.037,`v5`=6,`t`=17.4,`h`=65.1,`rssi`=225,`ccid`='4600485905031430000099m9990000000057000000g3260,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1681193044 WHERE `imei` = '868922055644013' [ RunTime:0.000545s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010303s ] [ 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' , '230411' , '140301' , -0.3 , 0.002 , 0.031 , -0.037 , 6 , 17.4 , 65.1 , 225 , '4600485905031430000099m9990000000057000000g3260,N,00E000=-00.000' , 0 , 0 , 1681193044 , 1681193044) [ RunTime:0.001283s ] --------------------------------------------------------------- [ 2023-04-11T18:53:31+08:00 ] 27.193.154.252 POST /admin/login/login.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002260s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_manager` [ RunTime:0.012449s ] [ sql ] [ SQL ] SELECT * FROM `collect_manager` WHERE `username` = 'admin' AND `password` = 'b8c6b861afec5f2a9a13ad8f963df1c7' LIMIT 1 [ RunTime:0.000601s ] --------------------------------------------------------------- [ 2023-04-11T18:53:34+08:00 ] 27.193.154.252 GET /admin/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001458s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011214s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000378s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.002389s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001033s ] --------------------------------------------------------------- [ 2023-04-11T18:53:36+08:00 ] 27.193.154.252 GET /admin/show/index.html?page=3 [ sql ] [ DB ] CONNECT:[ UseTime:0.001640s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009098s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000430s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 20,10 [ RunTime:0.000958s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000917s ] --------------------------------------------------------------- [ 2023-04-11T18:53:39+08:00 ] 27.193.154.252 GET /admin/show/edit/id/22.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001863s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010763s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 22 LIMIT 1 [ RunTime:0.000771s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.014177s ] [ sql ] [ SQL ] SELECT * FROM `collect_user` WHERE `collect_user`.`delete_time` IS NULL [ RunTime:0.001848s ] --------------------------------------------------------------- [ 2023-04-11T19:53:46+08:00 ] 27.193.154.252 GET /admin/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002482s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011961s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000456s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000873s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000973s ] --------------------------------------------------------------- [ 2023-04-11T19:53:52+08:00 ] 27.193.154.252 GET /admin/show/edit/id/52.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001801s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010246s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 52 LIMIT 1 [ RunTime:0.000778s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.012186s ] [ sql ] [ SQL ] SELECT * FROM `collect_user` WHERE `collect_user`.`delete_time` IS NULL [ RunTime:0.000492s ] --------------------------------------------------------------- [ 2023-04-11T19:53:56+08:00 ] 27.193.154.252 GET /admin/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001796s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011450s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000411s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000867s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000978s ] --------------------------------------------------------------- [ 2023-04-11T19:54:02+08:00 ] 27.193.154.252 GET /admin/show/edit/id/48.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002446s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010539s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `id` = 48 LIMIT 1 [ RunTime:0.000792s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.011791s ] [ sql ] [ SQL ] SELECT * FROM `collect_user` WHERE `collect_user`.`delete_time` IS NULL [ RunTime:0.000528s ] --------------------------------------------------------------- [ 2023-04-11T20:11:47+08:00 ] 39.144.2.209 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055677740 [ sql ] [ DB ] CONNECT:[ UseTime:0.003073s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011570s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.001097s ] --------------------------------------------------------------- [ 2023-04-11T20:11:48+08:00 ] 39.144.2.209 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055677740&create_time=1681215107&v1=0.007074&v2=0.824243&v3=0.007194&v4=0.007435&v5=13.140000&t=17.940208&h=32.848904&rssi=25&ccid=89860426102071188504&imsi=460044618415254&v6=-00.000&gps=120.184765,35.984974&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001576s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010405s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000678s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055677740',`create_time`=1681215107,`v1`=0.007074,`v2`=0.824243,`v3`=0.007194,`v4`=0.007435,`v5`=13.14,`t`=17.940208,`h`=32.848904,`rssi`=25,`ccid`='89860426102071188504',`imsi`='460044618415254',`v6`=-0,`gps`='120.184765,35.984974',`update_time`=1681215108 WHERE `imei` = '868922055677740' [ RunTime:0.000575s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.011931s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `gps` , `update_time`) VALUES ('868922055677740' , 1681215107 , 0.007074 , 0.824243 , 0.007194 , 0.007435 , 13.14 , 17.940208 , 32.848904 , 25 , '89860426102071188504' , '460044618415254' , -0 , '120.184765,35.984974' , 1681215108) [ RunTime:0.000689s ] --------------------------------------------------------------- [ 2023-04-11T20:18:33+08:00 ] 27.193.154.252 GET /admin/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002193s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010752s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` LIMIT 1 [ RunTime:0.000404s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000782s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.000965s ] --------------------------------------------------------------- [ 2023-04-11T20:18:34+08:00 ] 27.193.154.252 GET /admin/map/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002073s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011194s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` ORDER BY `id` DESC [ RunTime:0.001061s ] --------------------------------------------------------------- [ 2023-04-11T20:25:42+08:00 ] 39.144.14.184 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055677740 [ sql ] [ DB ] CONNECT:[ UseTime:0.001971s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009860s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000779s ] --------------------------------------------------------------- [ 2023-04-11T20:25:43+08:00 ] 39.144.14.184 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055677740&create_time=1681215942&v1=0.006953&v2=0.883073&v3=0.007224&v4=0.007375&v5=13.140000&t=17.607731&h=35.404755&rssi=21&ccid=89860426102071188504&imsi=460044618415254&v6=-00.000&gps=120.184915,35.985327&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001770s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009906s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000696s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055677740',`create_time`=1681215942,`v1`=0.006953,`v2`=0.883073,`v3`=0.007224,`v4`=0.007375,`v5`=13.14,`t`=17.607731,`h`=35.404755,`rssi`=21,`ccid`='89860426102071188504',`imsi`='460044618415254',`v6`=-0,`gps`='120.184915,35.985327',`update_time`=1681215943 WHERE `imei` = '868922055677740' [ RunTime:0.000608s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010995s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `gps` , `update_time`) VALUES ('868922055677740' , 1681215942 , 0.006953 , 0.883073 , 0.007224 , 0.007375 , 13.14 , 17.607731 , 35.404755 , 21 , '89860426102071188504' , '460044618415254' , -0 , '120.184915,35.985327' , 1681215943) [ RunTime:0.000679s ] --------------------------------------------------------------- [ 2023-04-11T20:27:52+08:00 ] 39.144.12.184 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055677740 [ sql ] [ DB ] CONNECT:[ UseTime:0.002461s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010650s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000829s ] --------------------------------------------------------------- [ 2023-04-11T20:27:54+08:00 ] 39.144.12.184 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055677740&create_time=1681216072&v1=0.007134&v2=2.772510&v3=0.007194&v4=0.007495&v5=13.140000&t=19.248669&h=31.490871&rssi=21&ccid=89860426102071188504&imsi=460044618415254&v6=-00.000&gps=120.184851,35.985013&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001764s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.010772s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000732s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055677740',`create_time`=1681216072,`v1`=0.007134,`v2`=2.77251,`v3`=0.007194,`v4`=0.007495,`v5`=13.14,`t`=19.248669,`h`=31.490871,`rssi`=21,`ccid`='89860426102071188504',`imsi`='460044618415254',`v6`=-0,`gps`='120.184851,35.985013',`update_time`=1681216074 WHERE `imei` = '868922055677740' [ RunTime:0.002067s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.008699s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `gps` , `update_time`) VALUES ('868922055677740' , 1681216072 , 0.007134 , 2.77251 , 0.007194 , 0.007495 , 13.14 , 19.248669 , 31.490871 , 21 , '89860426102071188504' , '460044618415254' , -0 , '120.184851,35.985013' , 1681216074) [ RunTime:0.000515s ]