--------------------------------------------------------------- [ 2023-12-15T02:01:52+08:00 ] 39.144.112.38 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055643643 [ sql ] [ DB ] CONNECT:[ UseTime:0.008896s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.037792s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.001530s ] --------------------------------------------------------------- [ 2023-12-15T02:01:53+08:00 ] 111.55.139.86 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013 [ sql ] [ DB ] CONNECT:[ UseTime:0.005873s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.028883s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000811s ] --------------------------------------------------------------- [ 2023-12-15T02:02:00+08:00 ] 39.144.112.38 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055643643&date=231215&time=020101&v1=-00.512&v2=+00.020&v3=-00.200&v4=+00.271&v5=05.7&t=+01.3&h=67.3&rssi=+224&ccid=4600485905031420000099m9990000000707000000g8100,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ 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.029678s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055643643' LIMIT 1 [ RunTime:0.000842s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055643643',`date`='231215',`time`='020101',`v1`=-0.512,`v2`=0.02,`v3`=-0.2,`v4`=0.271,`v5`=5.7,`t`=1.3,`h`=67.3,`rssi`=224,`ccid`='4600485905031420000099m9990000000707000000g8100,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1702576920 WHERE `imei` = '868922055643643' [ RunTime:0.000872s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.037762s ] [ 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' , '231215' , '020101' , -0.512 , 0.02 , -0.2 , 0.271 , 5.7 , 1.3 , 67.3 , 224 , '4600485905031420000099m9990000000707000000g8100,N,00E000=-00.000' , 0 , 0 , 1702576920 , 1702576920) [ RunTime:0.002999s ] --------------------------------------------------------------- [ 2023-12-15T02:02:01+08:00 ] 111.55.139.86 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=231215&time=020101&v1=-00.039&v2=+00.001&v3=-00.027&v4=+00.004&v5=05.6&t=+01.5&h=70.5&rssi=+221&ccid=4600485905031430000099m9990000000010000000g0350,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.004511s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.028637s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000817s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644013',`date`='231215',`time`='020101',`v1`=-0.039,`v2`=0.001,`v3`=-0.027,`v4`=0.004,`v5`=5.6,`t`=1.5,`h`=70.5,`rssi`=221,`ccid`='4600485905031430000099m9990000000010000000g0350,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1702576921 WHERE `imei` = '868922055644013' [ RunTime:0.000588s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.030778s ] [ 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' , '231215' , '020101' , -0.039 , 0.001 , -0.027 , 0.004 , 5.6 , 1.5 , 70.5 , 221 , '4600485905031430000099m9990000000010000000g0350,N,00E000=-00.000' , 0 , 0 , 1702576921 , 1702576921) [ RunTime:0.002154s ] --------------------------------------------------------------- [ 2023-12-15T10:17:03+08:00 ] 218.56.88.159 POST /admin/login/login.html [ sql ] [ DB ] CONNECT:[ UseTime:0.005198s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_manager` [ RunTime:0.032685s ] [ sql ] [ SQL ] SELECT * FROM `collect_manager` WHERE `username` = 'admin' AND `password` = 'b8c6b861afec5f2a9a13ad8f963df1c7' LIMIT 1 [ RunTime:0.000715s ] --------------------------------------------------------------- [ 2023-12-15T10:17:27+08:00 ] 218.56.88.159 GET /admin/user/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.003026s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.044260s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_user` WHERE `collect_user`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.001509s ] [ sql ] [ SQL ] SELECT * FROM `collect_user` WHERE `collect_user`.`delete_time` IS NULL ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000782s ] --------------------------------------------------------------- [ 2023-12-15T10:20:02+08:00 ] 218.56.88.159 POST /admin/user/save.html [ sql ] [ DB ] CONNECT:[ UseTime:0.004774s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.042502s ] [ sql ] [ SQL ] SELECT * FROM `collect_user` WHERE ( `username` = 'duolucaijiyi' ) AND `collect_user`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.001019s ] [ sql ] [ SQL ] INSERT INTO `collect_user` (`username` , `password` , `user_type` , `user_phone` , `user_email` , `introduce` , `update_time`) VALUES ('duolucaijiyi' , 'ba3c4352a7a9e9c182e1a1ca75b7e844' , 'collect' , '' , '' , ' ' , 1702606802) [ RunTime:0.000998s ] --------------------------------------------------------------- [ 2023-12-15T10:20:03+08:00 ] 218.56.88.159 GET /admin/user/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.003868s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.031610s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_user` WHERE `collect_user`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000530s ] [ sql ] [ SQL ] SELECT * FROM `collect_user` WHERE `collect_user`.`delete_time` IS NULL ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000621s ] --------------------------------------------------------------- [ 2023-12-15T10:20:05+08:00 ] 218.56.88.159 GET /admin/multipleshow/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.004716s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipleshow` [ RunTime:0.036237s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_multipleshow` LIMIT 1 [ RunTime:0.000455s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.002490s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` ORDER BY `id` DESC [ RunTime:0.001395s ] --------------------------------------------------------------- [ 2023-12-15T10:20:10+08:00 ] 218.56.88.159 GET /admin/multipleshow/edit/id/16.html [ sql ] [ DB ] CONNECT:[ UseTime:0.004941s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipleshow` [ RunTime:0.030661s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` WHERE `id` = 16 LIMIT 1 [ RunTime:0.000916s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.029741s ] [ sql ] [ SQL ] SELECT * FROM `collect_user` WHERE `collect_user`.`delete_time` IS NULL [ RunTime:0.000556s ] --------------------------------------------------------------- [ 2023-12-15T10:20:17+08:00 ] 218.56.88.159 POST /admin/multipleshow/update.html [ sql ] [ DB ] CONNECT:[ UseTime:0.004644s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipleshow` [ RunTime:0.029174s ] [ sql ] [ SQL ] UPDATE `collect_multipleshow` SET `device_name`='',`interval`=5,`outage_time`=40,`gps`='120.184810,35.985820',`username`='duolucaijiyi',`introduce`=' ',`update_time`=1702606817 WHERE `id` = 16 [ RunTime:0.002588s ] --------------------------------------------------------------- [ 2023-12-15T10:20:18+08:00 ] 218.56.88.159 GET /admin/multipleshow/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.004987s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipleshow` [ RunTime:0.028652s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_multipleshow` LIMIT 1 [ RunTime:0.000472s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.001471s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` ORDER BY `id` DESC [ RunTime:0.001362s ] --------------------------------------------------------------- [ 2023-12-15T10:20:22+08:00 ] 218.56.88.159 GET /admin/multipleshow/edit/id/15.html [ sql ] [ DB ] CONNECT:[ UseTime:0.005293s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipleshow` [ RunTime:0.026645s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` WHERE `id` = 15 LIMIT 1 [ RunTime:0.000779s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.038095s ] [ sql ] [ SQL ] SELECT * FROM `collect_user` WHERE `collect_user`.`delete_time` IS NULL [ RunTime:0.000554s ] --------------------------------------------------------------- [ 2023-12-15T10:20:27+08:00 ] 218.56.88.159 POST /admin/multipleshow/update.html [ sql ] [ DB ] CONNECT:[ UseTime:0.003850s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipleshow` [ RunTime:0.034358s ] [ sql ] [ SQL ] UPDATE `collect_multipleshow` SET `device_name`='',`interval`=5,`outage_time`=40,`gps`='120.184934,35.986853',`username`='duolucaijiyi',`introduce`=' ',`update_time`=1702606827 WHERE `id` = 15 [ RunTime:0.001238s ] --------------------------------------------------------------- [ 2023-12-15T10:20:28+08:00 ] 218.56.88.159 GET /admin/multipleshow/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.004164s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipleshow` [ RunTime:0.029196s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_multipleshow` LIMIT 1 [ RunTime:0.000444s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.001442s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` ORDER BY `id` DESC [ RunTime:0.001347s ] --------------------------------------------------------------- [ 2023-12-15T10:20:32+08:00 ] 218.56.88.159 GET /admin/multipleshow/edit/id/14.html [ sql ] [ DB ] CONNECT:[ UseTime:0.003536s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipleshow` [ RunTime:0.026843s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` WHERE `id` = 14 LIMIT 1 [ RunTime:0.000858s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.025463s ] [ sql ] [ SQL ] SELECT * FROM `collect_user` WHERE `collect_user`.`delete_time` IS NULL [ RunTime:0.000624s ] --------------------------------------------------------------- [ 2023-12-15T10:20:39+08:00 ] 218.56.88.159 POST /admin/multipleshow/update.html [ sql ] [ DB ] CONNECT:[ UseTime:0.003140s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipleshow` [ RunTime:0.027635s ] [ sql ] [ SQL ] UPDATE `collect_multipleshow` SET `device_name`='',`interval`=5,`outage_time`=40,`gps`='120.184933,35.985501',`username`='duolucaijiyi',`introduce`=' ',`update_time`=1702606839 WHERE `id` = 14 [ RunTime:0.001190s ] --------------------------------------------------------------- [ 2023-12-15T10:20:40+08:00 ] 218.56.88.159 GET /admin/multipleshow/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.004133s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipleshow` [ RunTime:0.027142s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_multipleshow` LIMIT 1 [ RunTime:0.000382s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.001539s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` ORDER BY `id` DESC [ RunTime:0.001344s ] --------------------------------------------------------------- [ 2023-12-15T10:20:43+08:00 ] 218.56.88.159 GET /admin/multipleshow/edit/id/13.html [ sql ] [ DB ] CONNECT:[ UseTime:0.004435s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipleshow` [ RunTime:0.028714s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` WHERE `id` = 13 LIMIT 1 [ RunTime:0.000769s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.024849s ] [ sql ] [ SQL ] SELECT * FROM `collect_user` WHERE `collect_user`.`delete_time` IS NULL [ RunTime:0.000616s ] --------------------------------------------------------------- [ 2023-12-15T10:20:48+08:00 ] 218.56.88.159 POST /admin/multipleshow/update.html [ sql ] [ DB ] CONNECT:[ UseTime:0.003579s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipleshow` [ RunTime:0.026190s ] [ sql ] [ SQL ] UPDATE `collect_multipleshow` SET `device_name`='',`interval`=5,`outage_time`=100,`gps`='120.184948,35.985626',`username`='duolucaijiyi',`introduce`=' ',`update_time`=1702606848 WHERE `id` = 13 [ RunTime:0.001857s ] --------------------------------------------------------------- [ 2023-12-15T10:20:49+08:00 ] 218.56.88.159 GET /admin/multipleshow/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.003733s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipleshow` [ RunTime:0.031796s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_multipleshow` LIMIT 1 [ RunTime:0.000546s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.001748s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` ORDER BY `id` DESC [ RunTime:0.001738s ] --------------------------------------------------------------- [ 2023-12-15T10:20:59+08:00 ] 218.56.88.159 GET /admin/multipleshow/edit/id/12.html [ sql ] [ DB ] CONNECT:[ UseTime:0.004150s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipleshow` [ RunTime:0.030714s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` WHERE `id` = 12 LIMIT 1 [ RunTime:0.000937s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.026907s ] [ sql ] [ SQL ] SELECT * FROM `collect_user` WHERE `collect_user`.`delete_time` IS NULL [ RunTime:0.000577s ] --------------------------------------------------------------- [ 2023-12-15T10:21:03+08:00 ] 218.56.88.159 POST /admin/multipleshow/update.html [ sql ] [ DB ] CONNECT:[ UseTime:0.004827s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipleshow` [ RunTime:0.028813s ] [ sql ] [ SQL ] UPDATE `collect_multipleshow` SET `device_name`='',`interval`=5,`outage_time`=100,`gps`='120.184872,35.985884',`username`='duolucaijiyi',`introduce`=' ',`update_time`=1702606863 WHERE `id` = 12 [ RunTime:0.001281s ] --------------------------------------------------------------- [ 2023-12-15T10:21:04+08:00 ] 218.56.88.159 GET /admin/multipleshow/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.005164s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipleshow` [ RunTime:0.040979s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_multipleshow` LIMIT 1 [ RunTime:0.000492s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.001549s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` ORDER BY `id` DESC [ RunTime:0.001335s ] --------------------------------------------------------------- [ 2023-12-15T10:21:10+08:00 ] 218.56.88.159 GET /admin/multipleshow/edit/id/11.html [ sql ] [ DB ] CONNECT:[ UseTime:0.003385s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipleshow` [ RunTime:0.028383s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` WHERE `id` = 11 LIMIT 1 [ RunTime:0.000787s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.027593s ] [ sql ] [ SQL ] SELECT * FROM `collect_user` WHERE `collect_user`.`delete_time` IS NULL [ RunTime:0.000573s ] --------------------------------------------------------------- [ 2023-12-15T10:21:16+08:00 ] 218.56.88.159 POST /admin/multipleshow/update.html [ sql ] [ DB ] CONNECT:[ UseTime:0.003100s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipleshow` [ RunTime:0.027358s ] [ sql ] [ SQL ] UPDATE `collect_multipleshow` SET `device_name`='',`interval`=5,`outage_time`=40,`gps`='120.184830,35.985259',`username`='duolucaijiyi',`introduce`=' ',`update_time`=1702606876 WHERE `id` = 11 [ RunTime:0.000876s ] --------------------------------------------------------------- [ 2023-12-15T10:21:18+08:00 ] 218.56.88.159 GET /admin/multipleshow/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.012081s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipleshow` [ RunTime:0.029491s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_multipleshow` LIMIT 1 [ RunTime:0.000474s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.001495s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` ORDER BY `id` DESC [ RunTime:0.001377s ] --------------------------------------------------------------- [ 2023-12-15T10:21:25+08:00 ] 218.56.88.159 GET /admin/multipleshow/edit/id/10.html [ sql ] [ DB ] CONNECT:[ UseTime:0.003426s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipleshow` [ RunTime:0.031172s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` WHERE `id` = 10 LIMIT 1 [ RunTime:0.000861s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.032550s ] [ sql ] [ SQL ] SELECT * FROM `collect_user` WHERE `collect_user`.`delete_time` IS NULL [ RunTime:0.000720s ] --------------------------------------------------------------- [ 2023-12-15T10:21:29+08:00 ] 218.56.88.159 POST /admin/multipleshow/update.html [ sql ] [ DB ] CONNECT:[ UseTime:0.005431s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipleshow` [ RunTime:0.027393s ] [ sql ] [ SQL ] UPDATE `collect_multipleshow` SET `device_name`='',`interval`=5,`outage_time`=40,`gps`='120.184943,35.985069',`username`='duolucaijiyi',`introduce`=' ',`update_time`=1702606889 WHERE `id` = 10 [ RunTime:0.000850s ] --------------------------------------------------------------- [ 2023-12-15T10:21:30+08:00 ] 218.56.88.159 GET /admin/multipleshow/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.014320s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipleshow` [ RunTime:0.026815s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_multipleshow` LIMIT 1 [ RunTime:0.000508s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.001621s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` ORDER BY `id` DESC [ RunTime:0.001454s ] --------------------------------------------------------------- [ 2023-12-15T10:21:36+08:00 ] 218.56.88.159 GET /admin/multipleshow/edit/id/10.html [ sql ] [ DB ] CONNECT:[ UseTime:0.005644s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipleshow` [ RunTime:0.026557s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` WHERE `id` = 10 LIMIT 1 [ RunTime:0.000767s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.029383s ] [ sql ] [ SQL ] SELECT * FROM `collect_user` WHERE `collect_user`.`delete_time` IS NULL [ RunTime:0.000562s ] --------------------------------------------------------------- [ 2023-12-15T10:21:40+08:00 ] 218.56.88.159 GET /admin/multipleshow/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.003772s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipleshow` [ RunTime:0.029044s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_multipleshow` LIMIT 1 [ RunTime:0.000449s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.001965s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` ORDER BY `id` DESC [ RunTime:0.001368s ] --------------------------------------------------------------- [ 2023-12-15T10:21:43+08:00 ] 218.56.88.159 GET /admin/multipleshow/edit/id/8.html [ sql ] [ DB ] CONNECT:[ UseTime:0.003772s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipleshow` [ RunTime:0.029475s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` WHERE `id` = 8 LIMIT 1 [ RunTime:0.000836s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.025965s ] [ sql ] [ SQL ] SELECT * FROM `collect_user` WHERE `collect_user`.`delete_time` IS NULL [ RunTime:0.000575s ] --------------------------------------------------------------- [ 2023-12-15T10:21:45+08:00 ] 218.56.88.159 GET /admin/multipleshow/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.003736s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipleshow` [ RunTime:0.028910s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_multipleshow` LIMIT 1 [ RunTime:0.000469s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.001478s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` ORDER BY `id` DESC [ RunTime:0.001451s ] --------------------------------------------------------------- [ 2023-12-15T10:21:47+08:00 ] 218.56.88.159 GET /admin/multipleshow/edit/id/9.html [ sql ] [ DB ] CONNECT:[ UseTime:0.005300s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipleshow` [ RunTime:0.026010s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` WHERE `id` = 9 LIMIT 1 [ RunTime:0.000833s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.028374s ] [ sql ] [ SQL ] SELECT * FROM `collect_user` WHERE `collect_user`.`delete_time` IS NULL [ RunTime:0.000566s ] --------------------------------------------------------------- [ 2023-12-15T10:21:50+08:00 ] 218.56.88.159 POST /admin/multipleshow/update.html [ sql ] [ DB ] CONNECT:[ UseTime:0.003695s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipleshow` [ RunTime:0.029734s ] [ sql ] [ SQL ] UPDATE `collect_multipleshow` SET `device_name`='',`interval`=5,`outage_time`=40,`gps`='120.184649,35.985377',`username`='duolucaijiyi',`introduce`=' ',`update_time`=1702606910 WHERE `id` = 9 [ RunTime:0.000834s ] --------------------------------------------------------------- [ 2023-12-15T10:21:51+08:00 ] 218.56.88.159 GET /admin/multipleshow/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.004869s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipleshow` [ RunTime:0.028541s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_multipleshow` LIMIT 1 [ RunTime:0.000467s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.001520s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` ORDER BY `id` DESC [ RunTime:0.001369s ] --------------------------------------------------------------- [ 2023-12-15T10:21:52+08:00 ] 218.56.88.159 GET /admin/multipleshow/edit/id/9.html [ sql ] [ DB ] CONNECT:[ UseTime:0.004224s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipleshow` [ RunTime:0.027718s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` WHERE `id` = 9 LIMIT 1 [ RunTime:0.000790s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.024730s ] [ sql ] [ SQL ] SELECT * FROM `collect_user` WHERE `collect_user`.`delete_time` IS NULL [ RunTime:0.000562s ] --------------------------------------------------------------- [ 2023-12-15T10:21:55+08:00 ] 218.56.88.159 GET /admin/multipleshow/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.005753s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipleshow` [ RunTime:0.027880s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_multipleshow` LIMIT 1 [ RunTime:0.000620s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.002371s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` ORDER BY `id` DESC [ RunTime:0.002605s ] --------------------------------------------------------------- [ 2023-12-15T10:21:58+08:00 ] 218.56.88.159 GET /admin/multipleshow/edit/id/8.html [ sql ] [ DB ] CONNECT:[ UseTime:0.003277s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipleshow` [ RunTime:0.029301s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` WHERE `id` = 8 LIMIT 1 [ RunTime:0.000787s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.041665s ] [ sql ] [ SQL ] SELECT * FROM `collect_user` WHERE `collect_user`.`delete_time` IS NULL [ RunTime:0.000580s ] --------------------------------------------------------------- [ 2023-12-15T10:22:02+08:00 ] 218.56.88.159 POST /admin/multipleshow/update.html [ sql ] [ DB ] CONNECT:[ UseTime:0.006227s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipleshow` [ RunTime:0.025245s ] [ sql ] [ SQL ] UPDATE `collect_multipleshow` SET `device_name`='',`interval`=5,`outage_time`=40,`gps`='120.184979,35.984900',`username`='duolucaijiyi',`introduce`=' ',`update_time`=1702606922 WHERE `id` = 8 [ RunTime:0.009825s ] --------------------------------------------------------------- [ 2023-12-15T10:22:03+08:00 ] 218.56.88.159 GET /admin/multipleshow/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.005752s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipleshow` [ RunTime:0.028182s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_multipleshow` LIMIT 1 [ RunTime:0.000466s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.001595s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` ORDER BY `id` DESC [ RunTime:0.003806s ] --------------------------------------------------------------- [ 2023-12-15T10:22:07+08:00 ] 218.56.88.159 GET /admin/multipleshow/edit/id/6.html [ sql ] [ DB ] CONNECT:[ UseTime:0.004507s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipleshow` [ RunTime:0.031911s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` WHERE `id` = 6 LIMIT 1 [ RunTime:0.000811s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.036768s ] [ sql ] [ SQL ] SELECT * FROM `collect_user` WHERE `collect_user`.`delete_time` IS NULL [ RunTime:0.000606s ] --------------------------------------------------------------- [ 2023-12-15T10:22:11+08:00 ] 218.56.88.159 POST /admin/multipleshow/update.html [ sql ] [ DB ] CONNECT:[ UseTime:0.006329s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipleshow` [ RunTime:0.026883s ] [ sql ] [ SQL ] UPDATE `collect_multipleshow` SET `device_name`='',`interval`=5,`outage_time`=40,`gps`='120.184807,35.985083',`username`='duolucaijiyi',`introduce`=' ',`update_time`=1702606931 WHERE `id` = 6 [ RunTime:0.002139s ] --------------------------------------------------------------- [ 2023-12-15T10:22:12+08:00 ] 218.56.88.159 GET /admin/multipleshow/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.005709s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipleshow` [ RunTime:0.029449s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_multipleshow` LIMIT 1 [ RunTime:0.000494s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.001722s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` ORDER BY `id` DESC [ RunTime:0.001452s ] --------------------------------------------------------------- [ 2023-12-15T10:22:46+08:00 ] 218.56.88.159 POST /home/login/login.html [ sql ] [ DB ] CONNECT:[ UseTime:0.005426s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.029204s ] [ sql ] [ SQL ] SELECT * FROM `collect_user` WHERE `username` = 'duolucaijiyi' AND `password` = 'ba3c4352a7a9e9c182e1a1ca75b7e844' LIMIT 1 [ RunTime:0.000706s ] --------------------------------------------------------------- [ 2023-12-15T10:22:47+08:00 ] 218.56.88.159 GET /home/map/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.005732s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.030306s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'duolucaijiyi' ORDER BY `id` DESC [ RunTime:0.000895s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipleshow` [ RunTime:0.032903s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` WHERE `username` = 'duolucaijiyi' ORDER BY `id` DESC [ RunTime:0.001714s ] --------------------------------------------------------------- [ 2023-12-15T10:23:08+08:00 ] 218.56.88.159 GET /home/multipleshow/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.004403s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipleshow` [ RunTime:0.030764s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_multipleshow` WHERE `username` = 'duolucaijiyi' LIMIT 1 [ RunTime:0.000826s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` WHERE `username` = 'duolucaijiyi' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.002272s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` ORDER BY `id` DESC [ RunTime:0.001594s ] --------------------------------------------------------------- [ 2023-12-15T10:23:11+08:00 ] 218.56.88.159 GET /home/multipleshow/read/id/12/imei/862810047311997.html [ sql ] [ DB ] CONNECT:[ UseTime:0.003408s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipleshow` [ RunTime:0.028886s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` WHERE `id` = 12 LIMIT 1 [ RunTime:0.001015s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipledata` [ RunTime:0.039596s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_multipledata` WHERE `imei` = '862810047311997' LIMIT 1 [ RunTime:0.014738s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipledata` WHERE `imei` = '862810047311997' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.004813s ] --------------------------------------------------------------- [ 2023-12-15T10:23:13+08:00 ] 218.56.88.159 GET /home/data/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002937s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.028074s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `username` = 'duolucaijiyi' LIMIT 1 [ RunTime:0.000569s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'duolucaijiyi' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000680s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'duolucaijiyi' ORDER BY `id` DESC [ RunTime:0.000725s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.035580s ] [ 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.000718s ] [ 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.000734s ] --------------------------------------------------------------- [ 2023-12-15T10:23:33+08:00 ] 27.115.124.38 GET /home/multipleshow/read/id/12/imei/862810047311997.html [ sql ] [ DB ] CONNECT:[ UseTime:0.003527s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipleshow` [ RunTime:0.034706s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` WHERE `id` = 12 LIMIT 1 [ RunTime:0.001354s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipledata` [ RunTime:0.029742s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_multipledata` WHERE `imei` = '862810047311997' LIMIT 1 [ RunTime:0.003719s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipledata` WHERE `imei` = '862810047311997' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.003873s ] --------------------------------------------------------------- [ 2023-12-15T10:26:43+08:00 ] 218.56.88.159 GET /home/multipleshow/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.006676s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipleshow` [ RunTime:0.025253s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_multipleshow` WHERE `username` = 'duolucaijiyi' LIMIT 1 [ RunTime:0.000574s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` WHERE `username` = 'duolucaijiyi' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.001533s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` ORDER BY `id` DESC [ RunTime:0.001370s ] --------------------------------------------------------------- [ 2023-12-15T10:26:46+08:00 ] 218.56.88.159 GET /home/multipleshow/read/id/6/imei/863412043541146.html [ sql ] [ DB ] CONNECT:[ UseTime:0.006501s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipleshow` [ RunTime:0.027187s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` WHERE `id` = 6 LIMIT 1 [ RunTime:0.000944s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipledata` [ RunTime:0.030769s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_multipledata` WHERE `imei` = '863412043541146' LIMIT 1 [ RunTime:0.003904s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipledata` WHERE `imei` = '863412043541146' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.005344s ] --------------------------------------------------------------- [ 2023-12-15T10:26:56+08:00 ] 218.56.88.159 GET /home/multipleshow/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.005591s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipleshow` [ RunTime:0.031294s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_multipleshow` WHERE `username` = 'duolucaijiyi' LIMIT 1 [ RunTime:0.000633s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` WHERE `username` = 'duolucaijiyi' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.001517s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` ORDER BY `id` DESC [ RunTime:0.001478s ] --------------------------------------------------------------- [ 2023-12-15T10:30:33+08:00 ] 218.56.88.159 GET /home [ sql ] [ DB ] CONNECT:[ UseTime:0.005942s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.032222s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `username` = 'duolucaijiyi' LIMIT 1 [ RunTime:0.000868s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'duolucaijiyi' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000794s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'duolucaijiyi' ORDER BY `id` DESC [ RunTime:0.000723s ] --------------------------------------------------------------- [ 2023-12-15T10:31:02+08:00 ] 218.56.88.159 GET /home [ sql ] [ DB ] CONNECT:[ UseTime:0.003349s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.026084s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `username` = 'duolucaijiyi' LIMIT 1 [ RunTime:0.000557s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'duolucaijiyi' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000726s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'duolucaijiyi' ORDER BY `id` DESC [ RunTime:0.000714s ] --------------------------------------------------------------- [ 2023-12-15T10:31:06+08:00 ] 218.56.88.159 GET /home [ sql ] [ DB ] CONNECT:[ UseTime:0.008456s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.029915s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `username` = 'duolucaijiyi' LIMIT 1 [ RunTime:0.000641s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'duolucaijiyi' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000750s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'duolucaijiyi' ORDER BY `id` DESC [ RunTime:0.000714s ] --------------------------------------------------------------- [ 2023-12-15T10:31:10+08:00 ] 218.56.88.159 GET /home/multipleshow/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.005712s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipleshow` [ RunTime:0.025685s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_multipleshow` WHERE `username` = 'duolucaijiyi' LIMIT 1 [ RunTime:0.000564s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` WHERE `username` = 'duolucaijiyi' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.001524s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` ORDER BY `id` DESC [ RunTime:0.001387s ] --------------------------------------------------------------- [ 2023-12-15T10:31:11+08:00 ] 218.56.88.159 GET /home/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.004630s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.031698s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `username` = 'duolucaijiyi' LIMIT 1 [ RunTime:0.000653s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'duolucaijiyi' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.001133s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'duolucaijiyi' ORDER BY `id` DESC [ RunTime:0.000868s ] --------------------------------------------------------------- [ 2023-12-15T10:31:13+08:00 ] 218.56.88.159 GET /home/show/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.005787s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.026607s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `username` = 'duolucaijiyi' LIMIT 1 [ RunTime:0.000640s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'duolucaijiyi' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000671s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'duolucaijiyi' ORDER BY `id` DESC [ RunTime:0.000717s ] --------------------------------------------------------------- [ 2023-12-15T10:31:14+08:00 ] 218.56.88.159 GET /home/multipleshow/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.004978s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipleshow` [ RunTime:0.027429s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_multipleshow` WHERE `username` = 'duolucaijiyi' LIMIT 1 [ RunTime:0.000641s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` WHERE `username` = 'duolucaijiyi' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.001621s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` ORDER BY `id` DESC [ RunTime:0.001522s ] --------------------------------------------------------------- [ 2023-12-15T14:25:38+08:00 ] 218.56.88.159 GET /home [ sql ] [ DB ] CONNECT:[ UseTime:0.007349s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.031974s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `username` = 'duolucaijiyi' LIMIT 1 [ RunTime:0.003539s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'duolucaijiyi' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000714s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'duolucaijiyi' ORDER BY `id` DESC [ RunTime:0.000833s ] --------------------------------------------------------------- [ 2023-12-15T14:25:39+08:00 ] 218.56.88.159 GET /home/multipleshow/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.003464s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipleshow` [ RunTime:0.036839s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_multipleshow` WHERE `username` = 'duolucaijiyi' LIMIT 1 [ RunTime:0.001558s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` WHERE `username` = 'duolucaijiyi' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.001755s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` ORDER BY `id` DESC [ RunTime:0.002236s ] --------------------------------------------------------------- [ 2023-12-15T14:25:39+08:00 ] 218.56.88.159 GET /home/multipleshow/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.006275s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipleshow` [ RunTime:0.037443s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_multipleshow` WHERE `username` = 'duolucaijiyi' LIMIT 1 [ RunTime:0.000612s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` WHERE `username` = 'duolucaijiyi' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.002142s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` ORDER BY `id` DESC [ RunTime:0.001403s ] --------------------------------------------------------------- [ 2023-12-15T15:08:39+08:00 ] 218.56.88.159 GET /home/multipleshow/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.004189s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipleshow` [ RunTime:0.032881s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_multipleshow` WHERE `username` = 'duolucaijiyi' LIMIT 1 [ RunTime:0.000762s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` WHERE `username` = 'duolucaijiyi' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.001826s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` ORDER BY `id` DESC [ RunTime:0.001625s ] --------------------------------------------------------------- [ 2023-12-15T15:39:52+08:00 ] 218.56.88.159 GET /home/multipleshow/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.004441s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipleshow` [ RunTime:0.037099s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_multipleshow` WHERE `username` = 'duolucaijiyi' LIMIT 1 [ RunTime:0.000793s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` WHERE `username` = 'duolucaijiyi' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.001736s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` ORDER BY `id` DESC [ RunTime:0.001667s ] --------------------------------------------------------------- [ 2023-12-15T15:39:56+08:00 ] 218.56.88.159 GET /home/data/multipledata.html [ sql ] [ DB ] CONNECT:[ UseTime:0.003364s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipleshow` [ RunTime:0.032228s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_multipleshow` WHERE `username` = 'duolucaijiyi' LIMIT 1 [ RunTime:0.000791s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` WHERE `username` = 'duolucaijiyi' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.001714s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` WHERE `username` = 'duolucaijiyi' ORDER BY `id` DESC [ RunTime:0.001538s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipledata` [ RunTime:0.043651s ] [ 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.024097s ] [ 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.003436s ] --------------------------------------------------------------- [ 2023-12-15T15:40:16+08:00 ] 218.56.88.159 GET /home/data/multipledata.html?keyword=863412043560864&start_date=2023-12-02&end_date=2023-12-15 [ sql ] [ DB ] CONNECT:[ UseTime:0.003379s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipleshow` [ RunTime:0.027543s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` WHERE `username` = 'duolucaijiyi' AND `imei` = '863412043560864' LIMIT 1 [ RunTime:0.000901s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_multipleshow` WHERE `imei` = '863412043560864' AND `username` = 'duolucaijiyi' LIMIT 1 [ RunTime:0.000717s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` WHERE `imei` = '863412043560864' AND `username` = 'duolucaijiyi' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000692s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` WHERE `username` = 'duolucaijiyi' ORDER BY `id` DESC [ RunTime:0.001772s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipledata` [ RunTime:0.030117s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_multipledata` WHERE `imei` = '863412043560864' AND ( `update_time` >= 1701446400 AND `update_time` <= 1702569600 ) LIMIT 1 [ RunTime:0.006203s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipledata` WHERE `imei` = '863412043560864' AND ( `update_time` >= 1701446400 AND `update_time` <= 1702569600 ) ORDER BY `update_time` ASC LIMIT 0,1000 [ RunTime:0.003813s ] --------------------------------------------------------------- [ 2023-12-15T15:57:04+08:00 ] 218.56.88.159 GET /home/data/multipledata.html?keyword=863412043560864&start_date=2023-12-02&end_date=2023-12-15 [ sql ] [ DB ] CONNECT:[ UseTime:0.004235s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipleshow` [ RunTime:0.038888s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` WHERE `username` = 'duolucaijiyi' AND `imei` = '863412043560864' LIMIT 1 [ RunTime:0.000886s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_multipleshow` WHERE `imei` = '863412043560864' AND `username` = 'duolucaijiyi' LIMIT 1 [ RunTime:0.000614s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` WHERE `imei` = '863412043560864' AND `username` = 'duolucaijiyi' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.001091s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` WHERE `username` = 'duolucaijiyi' ORDER BY `id` DESC [ RunTime:0.002032s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipledata` [ RunTime:0.038959s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_multipledata` WHERE `imei` = '863412043560864' AND ( `update_time` >= 1701446400 AND `update_time` <= 1702569600 ) LIMIT 1 [ RunTime:0.004191s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipledata` WHERE `imei` = '863412043560864' AND ( `update_time` >= 1701446400 AND `update_time` <= 1702569600 ) ORDER BY `update_time` ASC LIMIT 0,1000 [ RunTime:0.004430s ] --------------------------------------------------------------- [ 2023-12-15T15:59:43+08:00 ] 218.56.88.159 GET /home/data/multipledata.html?keyword=863412043560864&start_date=2023-12-02&end_date=2023-12-15 [ sql ] [ DB ] CONNECT:[ UseTime:0.005186s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipleshow` [ RunTime:0.028058s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` WHERE `username` = 'duolucaijiyi' AND `imei` = '863412043560864' LIMIT 1 [ RunTime:0.000854s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_multipleshow` WHERE `imei` = '863412043560864' AND `username` = 'duolucaijiyi' LIMIT 1 [ RunTime:0.000753s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` WHERE `imei` = '863412043560864' AND `username` = 'duolucaijiyi' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000796s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` WHERE `username` = 'duolucaijiyi' ORDER BY `id` DESC [ RunTime:0.001523s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipledata` [ RunTime:0.042569s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_multipledata` WHERE `imei` = '863412043560864' AND ( `update_time` >= 1701446400 AND `update_time` <= 1702569600 ) LIMIT 1 [ RunTime:0.003780s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipledata` WHERE `imei` = '863412043560864' AND ( `update_time` >= 1701446400 AND `update_time` <= 1702569600 ) ORDER BY `update_time` ASC LIMIT 0,1000 [ RunTime:0.003759s ] --------------------------------------------------------------- [ 2023-12-15T16:01:31+08:00 ] 218.56.88.159 GET /home/data/multipledata.html?keyword=863412043560864&start_date=2023-02-02&end_date=2023-12-15 [ sql ] [ DB ] CONNECT:[ UseTime:0.003498s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipleshow` [ RunTime:0.028669s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` WHERE `username` = 'duolucaijiyi' AND `imei` = '863412043560864' LIMIT 1 [ RunTime:0.000754s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_multipleshow` WHERE `imei` = '863412043560864' AND `username` = 'duolucaijiyi' LIMIT 1 [ RunTime:0.000531s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` WHERE `imei` = '863412043560864' AND `username` = 'duolucaijiyi' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000721s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` WHERE `username` = 'duolucaijiyi' ORDER BY `id` DESC [ RunTime:0.001457s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipledata` [ RunTime:0.030454s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_multipledata` WHERE `imei` = '863412043560864' AND ( `update_time` >= 1675267200 AND `update_time` <= 1702569600 ) LIMIT 1 [ RunTime:0.005166s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipledata` WHERE `imei` = '863412043560864' AND ( `update_time` >= 1675267200 AND `update_time` <= 1702569600 ) ORDER BY `update_time` ASC LIMIT 0,1000 [ RunTime:0.011913s ] --------------------------------------------------------------- [ 2023-12-15T16:14:19+08:00 ] 218.56.88.159 POST /home/login/login.html [ sql ] [ DB ] CONNECT:[ UseTime:0.004125s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.029200s ] [ sql ] [ SQL ] SELECT * FROM `collect_user` WHERE `username` = 'user1' AND `password` = 'ba3c4352a7a9e9c182e1a1ca75b7e844' LIMIT 1 [ RunTime:0.001352s ] --------------------------------------------------------------- [ 2023-12-15T16:14:20+08:00 ] 218.56.88.159 GET /home/map/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.003100s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.029999s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'user1' ORDER BY `id` DESC [ RunTime:0.000887s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipleshow` [ RunTime:0.032189s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` WHERE `username` = 'user1' ORDER BY `id` DESC [ RunTime:0.000767s ] --------------------------------------------------------------- [ 2023-12-15T16:14:24+08:00 ] 218.56.88.159 GET /home/data/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.003384s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.026592s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `username` = 'user1' LIMIT 1 [ RunTime:0.000592s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'user1' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000836s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'user1' ORDER BY `id` DESC [ RunTime:0.000712s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.038772s ] [ 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.000507s ] [ 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.000490s ] --------------------------------------------------------------- [ 2023-12-15T16:14:45+08:00 ] 218.56.88.159 GET /home/data/index.html?keyword=868922055677740&start_date=2020-01-15&end_date=2023-12-15 [ sql ] [ DB ] CONNECT:[ UseTime:0.004123s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.028718s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'user1' AND `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000770s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `imei` = '868922055677740' AND `username` = 'user1' LIMIT 1 [ RunTime:0.000926s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' AND `username` = 'user1' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000582s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'user1' ORDER BY `id` DESC [ RunTime:0.000827s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.034064s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055677740' AND ( `update_time` >= 1579017600 AND `update_time` <= 1702569600 ) LIMIT 1 [ RunTime:0.036814s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055677740' AND ( `update_time` >= 1579017600 AND `update_time` <= 1702569600 ) ORDER BY `update_time` ASC LIMIT 0,1000 [ RunTime:0.022585s ] --------------------------------------------------------------- [ 2023-12-15T16:15:58+08:00 ] 218.56.88.159 GET /home/data/index.html?keyword=868922055677740&start_date=2020-01-15&end_date=2023-12-15 [ sql ] [ DB ] CONNECT:[ UseTime:0.004651s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.030300s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'user1' AND `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000753s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `imei` = '868922055677740' AND `username` = 'user1' LIMIT 1 [ RunTime:0.000622s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' AND `username` = 'user1' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000563s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'user1' ORDER BY `id` DESC [ RunTime:0.000720s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.024058s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055677740' AND ( `update_time` >= 1579017600 AND `update_time` <= 1702569600 ) LIMIT 1 [ RunTime:0.013560s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055677740' AND ( `update_time` >= 1579017600 AND `update_time` <= 1702569600 ) ORDER BY `update_time` ASC LIMIT 0,1000 [ RunTime:0.028786s ] --------------------------------------------------------------- [ 2023-12-15T16:16:33+08:00 ] 218.56.88.159 GET /home/data/index.html?keyword=868922055677740&start_date=2020-01-15&end_date=2023-12-15 [ sql ] [ DB ] CONNECT:[ UseTime:0.005217s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.039733s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'user1' AND `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000693s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `imei` = '868922055677740' AND `username` = 'user1' LIMIT 1 [ RunTime:0.000588s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' AND `username` = 'user1' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000580s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'user1' ORDER BY `id` DESC [ RunTime:0.000778s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.025287s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055677740' AND ( `update_time` >= 1579017600 AND `update_time` <= 1702569600 ) LIMIT 1 [ RunTime:0.015769s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055677740' AND ( `update_time` >= 1579017600 AND `update_time` <= 1702569600 ) ORDER BY `update_time` ASC LIMIT 0,1000 [ RunTime:0.023455s ] --------------------------------------------------------------- [ 2023-12-15T16:16:39+08:00 ] 218.56.88.159 GET /home/data/index.html?keyword=868922055677740&start_date=2020-01-15&end_date=2023-12-15 [ sql ] [ DB ] CONNECT:[ UseTime:0.003457s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.025810s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'user1' AND `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000723s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `imei` = '868922055677740' AND `username` = 'user1' LIMIT 1 [ RunTime:0.000494s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' AND `username` = 'user1' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000540s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'user1' ORDER BY `id` DESC [ RunTime:0.000748s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.025376s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055677740' AND ( `update_time` >= 1579017600 AND `update_time` <= 1702569600 ) LIMIT 1 [ RunTime:0.013076s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055677740' AND ( `update_time` >= 1579017600 AND `update_time` <= 1702569600 ) ORDER BY `update_time` ASC LIMIT 0,1000 [ RunTime:0.036448s ] --------------------------------------------------------------- [ 2023-12-15T16:16:42+08:00 ] 218.56.88.159 GET /home/data/delete/id/314.html [ sql ] [ DB ] CONNECT:[ UseTime:0.003776s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.028114s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `id` = 314 [ RunTime:0.000658s ] [ sql ] [ SQL ] DELETE FROM `collect_data` WHERE `id` = 314 [ RunTime:0.000761s ] --------------------------------------------------------------- [ 2023-12-15T16:16:46+08:00 ] 218.56.88.159 GET /home/data/index.html?keyword=868922055677740&start_date=2020-01-15&end_date=2023-12-15 [ sql ] [ DB ] CONNECT:[ UseTime:0.002965s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.028055s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'user1' AND `imei` = '868922055677740' LIMIT 1 [ RunTime:0.000806s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_show` WHERE `imei` = '868922055677740' AND `username` = 'user1' LIMIT 1 [ RunTime:0.000488s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055677740' AND `username` = 'user1' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000609s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `username` = 'user1' ORDER BY `id` DESC [ RunTime:0.000882s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.024067s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_data` WHERE `imei` = '868922055677740' AND ( `update_time` >= 1579017600 AND `update_time` <= 1702569600 ) LIMIT 1 [ RunTime:0.015465s ] [ sql ] [ SQL ] SELECT * FROM `collect_data` WHERE `imei` = '868922055677740' AND ( `update_time` >= 1579017600 AND `update_time` <= 1702569600 ) ORDER BY `update_time` ASC LIMIT 0,1000 [ RunTime:0.023568s ]