--------------------------------------------------------------- [ 2023-12-11T02:01:52+08:00 ] 39.144.1.100 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013 [ sql ] [ DB ] CONNECT:[ UseTime:0.005374s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.030139s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.001484s ] --------------------------------------------------------------- [ 2023-12-11T02:01:53+08:00 ] 39.144.112.33 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055643643 [ sql ] [ DB ] CONNECT:[ UseTime:0.003022s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.038358s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.001203s ] --------------------------------------------------------------- [ 2023-12-11T02:02:00+08:00 ] 39.144.1.100 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=231211&time=020101&v1=-00.025&v2=+00.001&v3=+00.018&v4=+00.001&v5=05.6&t=+02.1&h=70.7&rssi=+223&ccid=4600485905031430000099m9990000000034000000g0210,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.003752s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.030124s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000818s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644013',`date`='231211',`time`='020101',`v1`=-0.025,`v2`=0.001,`v3`=0.018,`v4`=0.001,`v5`=5.6,`t`=2.1,`h`=70.7,`rssi`=223,`ccid`='4600485905031430000099m9990000000034000000g0210,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1702231320 WHERE `imei` = '868922055644013' [ RunTime:0.000841s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.039126s ] [ 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' , '231211' , '020101' , -0.025 , 0.001 , 0.018 , 0.001 , 5.6 , 2.1 , 70.7 , 223 , '4600485905031430000099m9990000000034000000g0210,N,00E000=-00.000' , 0 , 0 , 1702231320 , 1702231320) [ RunTime:0.004301s ] --------------------------------------------------------------- [ 2023-12-11T02:02:01+08:00 ] 39.144.112.33 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055643643&date=231211&time=020101&v1=-01.137&v2=+00.029&v3=-00.796&v4=-00.012&v5=05.7&t=+02.1&h=67.0&rssi=+223&ccid=4600485905031420000099m9990000000404000001g1990,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.002936s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.027331s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000726s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055643643',`date`='231211',`time`='020101',`v1`=-1.137,`v2`=0.029,`v3`=-0.796,`v4`=-0.012,`v5`=5.7,`t`=2.1,`h`=67,`rssi`=223,`ccid`='4600485905031420000099m9990000000404000001g1990,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1702231321 WHERE `imei` = '868922055643643' [ RunTime:0.000619s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.027490s ] [ 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' , '231211' , '020101' , -1.137 , 0.029 , -0.796 , -0.012 , 5.7 , 2.1 , 67 , 223 , '4600485905031420000099m9990000000404000001g1990,N,00E000=-00.000' , 0 , 0 , 1702231321 , 1702231321) [ RunTime:0.001251s ] --------------------------------------------------------------- [ 2023-12-11T08:48:27+08:00 ] 124.129.66.252 GET /admin/multipleshow/edit/id/11.html [ sql ] [ DB ] CONNECT:[ UseTime:0.005065s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipleshow` [ RunTime:0.036838s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` WHERE `id` = 11 LIMIT 1 [ RunTime:0.002222s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.032793s ] [ sql ] [ SQL ] SELECT * FROM `collect_user` WHERE `collect_user`.`delete_time` IS NULL [ RunTime:0.001223s ] --------------------------------------------------------------- [ 2023-12-11T08:48:34+08:00 ] 124.129.66.252 GET /admin/multipleshow/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.003289s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipleshow` [ RunTime:0.032075s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_multipleshow` LIMIT 1 [ RunTime:0.000871s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.001808s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` ORDER BY `id` DESC [ RunTime:0.001518s ] --------------------------------------------------------------- [ 2023-12-11T08:48:44+08:00 ] 124.129.66.252 GET /admin/multipleshow/read/id/15/imei/863412043611030.html [ sql ] [ DB ] CONNECT:[ UseTime:0.003206s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipleshow` [ RunTime:0.034402s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` WHERE `id` = 15 LIMIT 1 [ RunTime:0.000804s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipledata` [ RunTime:0.032640s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_multipledata` WHERE `imei` = '863412043611030' LIMIT 1 [ RunTime:0.021599s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipledata` WHERE `imei` = '863412043611030' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.004025s ] --------------------------------------------------------------- [ 2023-12-11T14:28:08+08:00 ] 112.224.69.153 GET /admin/multipleshow/read/id/15/imei/863412043611030.html [ sql ] [ DB ] CONNECT:[ UseTime:0.005301s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipleshow` [ RunTime:0.031908s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` WHERE `id` = 15 LIMIT 1 [ RunTime:0.002291s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipledata` [ RunTime:0.033992s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_multipledata` WHERE `imei` = '863412043611030' LIMIT 1 [ RunTime:0.007782s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipledata` WHERE `imei` = '863412043611030' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.004146s ]