---------------------------------------------------------------
[ 2024-03-01T01:57:52+08:00 ] 39.144.112.11 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013
[ sql ] [ DB ] CONNECT:[ UseTime:0.003614s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.015131s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055644013' LIMIT 1 [ RunTime:0.001320s ]
---------------------------------------------------------------
[ 2024-03-01T01:58:00+08:00 ] 39.144.112.11 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=240301&time=015701&v1=-00.013&v2=+00.001&v3=+00.054&v4=-00.008&v5=05.4&t=-03.6&h=71.7&rssi=+222&ccid=4600485905031430000099m9990000000053000000g0150,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.001626s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012003s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000802s ]
[ sql ] [ SQL ] UPDATE `collect_show`  SET `imei`='868922055644013',`date`='240301',`time`='015701',`v1`=-0.013,`v2`=0.001,`v3`=0.054,`v4`=-0.008,`v5`=5.4,`t`=-3.6,`h`=71.7,`rssi`=222,`ccid`='4600485905031430000099m9990000000053000000g0150,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1709229480  WHERE  `imei` = '868922055644013' [ RunTime:0.000771s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.027234s ]
[ 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' , '240301' , '015701' , -0.013 , 0.001 , 0.054 , -0.008 , 5.4 , -3.6 , 71.7 , 222 , '4600485905031430000099m9990000000053000000g0150,N,00E000=-00.000' , 0 , 0 , 1709229480 , 1709229480) [ RunTime:0.002372s ]
---------------------------------------------------------------
[ 2024-03-01T14:05:43+08:00 ] 223.104.194.166 POST /home/login/login.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.004407s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.016883s ]
[ sql ] [ SQL ] SELECT * FROM `collect_user` WHERE  `username` = 'biandianzhan'  AND `password` = 'd14d010294c092af31274c0f4c6cc67a' LIMIT 1 [ RunTime:0.020589s ]
---------------------------------------------------------------
[ 2024-03-01T14:05:45+08:00 ] 223.104.194.166 GET /home/map/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001892s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012243s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `username` = 'biandianzhan' ORDER BY `id` DESC [ RunTime:0.001432s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipleshow` [ RunTime:0.015024s ]
[ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` WHERE  `username` = 'biandianzhan' ORDER BY `id` DESC [ RunTime:0.001240s ]
---------------------------------------------------------------
[ 2024-03-01T14:05:49+08:00 ] 223.104.194.166 GET /home/show/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001951s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.013785s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE  `username` = 'biandianzhan' LIMIT 1 [ RunTime:0.000559s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `username` = 'biandianzhan' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000747s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `username` = 'biandianzhan' ORDER BY `id` DESC [ RunTime:0.000732s ]
---------------------------------------------------------------
[ 2024-03-01T14:05:52+08:00 ] 223.104.194.166 GET /home/data/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001635s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012086s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE  `username` = 'biandianzhan' LIMIT 1 [ RunTime:0.000633s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `username` = 'biandianzhan' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000732s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `username` = 'biandianzhan' ORDER BY `id` DESC [ RunTime:0.000725s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.018777s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE  `imei` IS NULL  AND ( `update_time` >= 0 AND `update_time` <= 0 ) LIMIT 1 [ RunTime:0.000486s ]
[ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE  `imei` IS NULL  AND ( `update_time` >= 0 AND `update_time` <= 0 ) ORDER BY `update_time` ASC LIMIT 0,1000 [ RunTime:0.000517s ]
---------------------------------------------------------------
[ 2024-03-01T14:05:55+08:00 ] 223.104.194.166 GET /home/multipleshow/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001615s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipleshow` [ RunTime:0.011850s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_multipleshow` WHERE  `username` = 'biandianzhan' LIMIT 1 [ RunTime:0.000521s ]
[ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` WHERE  `username` = 'biandianzhan' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000661s ]
[ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` ORDER BY `id` DESC [ RunTime:0.001427s ]
---------------------------------------------------------------
[ 2024-03-01T14:05:58+08:00 ] 223.104.194.166 GET /home/data/multipledata.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001825s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipleshow` [ RunTime:0.010905s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_multipleshow` WHERE  `username` = 'biandianzhan' LIMIT 1 [ RunTime:0.000546s ]
[ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` WHERE  `username` = 'biandianzhan' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000691s ]
[ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` WHERE  `username` = 'biandianzhan' ORDER BY `id` DESC [ RunTime:0.000596s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipledata` [ RunTime:0.015523s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_multipledata` WHERE  `imei` IS NULL  AND ( `update_time` >= 0 AND `update_time` <= 0 ) LIMIT 1 [ RunTime:0.087833s ]
[ sql ] [ SQL ] SELECT * FROM `collect_multipledata` WHERE  `imei` IS NULL  AND ( `update_time` >= 0 AND `update_time` <= 0 ) ORDER BY `update_time` ASC LIMIT 0,1000 [ RunTime:0.004087s ]
---------------------------------------------------------------
[ 2024-03-01T14:06:02+08:00 ] 223.104.194.166 GET /home/data/multipledata.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.002062s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipleshow` [ RunTime:0.012342s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_multipleshow` WHERE  `username` = 'biandianzhan' LIMIT 1 [ RunTime:0.000699s ]
[ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` WHERE  `username` = 'biandianzhan' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.006927s ]
[ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` WHERE  `username` = 'biandianzhan' ORDER BY `id` DESC [ RunTime:0.000948s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipledata` [ RunTime:0.012571s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_multipledata` WHERE  `imei` IS NULL  AND ( `update_time` >= 0 AND `update_time` <= 0 ) LIMIT 1 [ RunTime:0.004411s ]
[ sql ] [ SQL ] SELECT * FROM `collect_multipledata` WHERE  `imei` IS NULL  AND ( `update_time` >= 0 AND `update_time` <= 0 ) ORDER BY `update_time` ASC LIMIT 0,1000 [ RunTime:0.005323s ]
---------------------------------------------------------------
[ 2024-03-01T14:06:04+08:00 ] 223.104.194.166 GET /home/multipleshow/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001756s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipleshow` [ RunTime:0.011201s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_multipleshow` WHERE  `username` = 'biandianzhan' LIMIT 1 [ RunTime:0.000527s ]
[ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` WHERE  `username` = 'biandianzhan' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000638s ]
[ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` ORDER BY `id` DESC [ RunTime:0.001455s ]
---------------------------------------------------------------
[ 2024-03-01T14:06:12+08:00 ] 223.104.194.166 GET /home/multipleshow/index.html?keyword=862810047311997
[ sql ] [ DB ] CONNECT:[ UseTime:0.002576s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipleshow` [ RunTime:0.011371s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_multipleshow` WHERE  `imei` LIKE '%862810047311997%'  AND `username` = 'biandianzhan' LIMIT 1 [ RunTime:0.000566s ]
[ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` WHERE  `imei` LIKE '%862810047311997%'  AND `username` = 'biandianzhan' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000659s ]
[ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` ORDER BY `id` DESC [ RunTime:0.001442s ]
---------------------------------------------------------------
[ 2024-03-01T14:06:16+08:00 ] 223.104.194.166 GET /home/map/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.002280s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.011695s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `username` = 'biandianzhan' ORDER BY `id` DESC [ RunTime:0.000892s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipleshow` [ RunTime:0.011375s ]
[ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` WHERE  `username` = 'biandianzhan' ORDER BY `id` DESC [ RunTime:0.000661s ]
---------------------------------------------------------------
[ 2024-03-01T14:06:19+08:00 ] 223.104.194.166 GET /home/map/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.002665s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009970s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE  `username` = 'biandianzhan' ORDER BY `id` DESC [ RunTime:0.000813s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipleshow` [ RunTime:0.011709s ]
[ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` WHERE  `username` = 'biandianzhan' ORDER BY `id` DESC [ RunTime:0.000620s ]
---------------------------------------------------------------
[ 2024-03-01T14:06:41+08:00 ] 223.104.194.166 GET /home/multipleshow/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001971s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipleshow` [ RunTime:0.011822s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_multipleshow` WHERE  `username` = 'biandianzhan' LIMIT 1 [ RunTime:0.000577s ]
[ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` WHERE  `username` = 'biandianzhan' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000664s ]
[ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` ORDER BY `id` DESC [ RunTime:0.001565s ]