---------------------------------------------------------------
[ 2025-03-23T01:29:51+08:00 ] 111.55.120.78 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644013
[ sql ] [ DB ] CONNECT:[ UseTime:0.002614s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.333686s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000737s ]
---------------------------------------------------------------
[ 2025-03-23T01:30:00+08:00 ] 111.55.120.78 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055644013&date=250323&time=012901&v1=-00.050&v2=+00.001&v3=+00.020&v4=+00.009&v5=05.6&t=+14.9&h=73.8&rssi=+220&ccid=4600485905031430000099m9990000000037000000g0460,N,00E000=-00.000&a1=00.000&a2=00.000&a3=00.000&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.001524s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.030362s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644013' LIMIT 1 [ RunTime:0.000622s ]
[ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644013',`date`='250323',`time`='012901',`v1`=-0.05,`v2`=0.001,`v3`=0.02,`v4`=0.009,`v5`=5.6,`t`=14.9,`h`=73.8,`rssi`=220,`ccid`='4600485905031430000099m9990000000037000000g0460,N,00E000=-00.000',`a1`=0,`a2`=0,`update_time`=1742664600 WHERE `imei` = '868922055644013' [ RunTime:0.001289s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.007811s ]
[ 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' , '250323' , '012901' , -0.05 , 0.001 , 0.02 , 0.009 , 5.6 , 14.9 , 73.8 , 220 , '4600485905031430000099m9990000000037000000g0460,N,00E000=-00.000' , 0 , 0 , 1742664600 , 1742664600) [ RunTime:0.001186s ]
---------------------------------------------------------------
[ 2025-03-23T02:17:03+08:00 ] 39.144.112.12 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684209
[ sql ] [ DB ] CONNECT:[ UseTime:0.002452s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.548765s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684209' LIMIT 1 [ RunTime:0.001437s ]
---------------------------------------------------------------
[ 2025-03-23T02:17:04+08:00 ] 39.144.112.12 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055684209&create_time=1742667423&v1=-1.063174&v2=0.121011&v3=-1.045355&v4=-0.718224&v5=6.480000&t=12.127312&h=74.368042&rssi=31&ccid=898604650119C1078511&imsi=460048590708511&v6=-00.000&gps=120.428404,36.323109&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.001433s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.008131s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684209' LIMIT 1 [ RunTime:0.000725s ]
[ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684209',`create_time`=1742667423,`v1`=-1.063174,`v2`=0.121011,`v3`=-1.045355,`v4`=-0.718224,`v5`=6.48,`t`=12.127312,`h`=74.368042,`rssi`=31,`ccid`='898604650119C1078511',`imsi`='460048590708511',`v6`=-0,`gps`='120.428404,36.323109',`update_time`=1742667424 WHERE `imei` = '868922055684209' [ RunTime:0.000504s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.007984s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `gps` , `update_time`) VALUES ('868922055684209' , 1742667423 , -1.063174 , 0.121011 , -1.045355 , -0.718224 , 6.48 , 12.127312 , 74.368042 , 31 , '898604650119C1078511' , '460048590708511' , -0 , '120.428404,36.323109' , 1742667424) [ RunTime:0.001446s ]
---------------------------------------------------------------
[ 2025-03-23T09:02:06+08:00 ] 111.55.120.23 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644021
[ 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.363327s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644021' LIMIT 1 [ RunTime:0.000652s ]
---------------------------------------------------------------
[ 2025-03-23T09:02:08+08:00 ] 111.55.120.23 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055644021&create_time=1742691726&v1=-1.335643&v2=0.038365&v3=-1.116301&v4=-0.682826&v5=5.760000&t=18.615995&h=81.043762&rssi=27&ccid=898604650119C1053141&imsi=460048590503141&v6=-00.000&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.001813s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.215345s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644021' LIMIT 1 [ RunTime:0.000735s ]
[ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644021',`create_time`=1742691726,`v1`=-1.335643,`v2`=0.038365,`v3`=-1.116301,`v4`=-0.682826,`v5`=5.76,`t`=18.615995,`h`=81.043762,`rssi`=27,`ccid`='898604650119C1053141',`imsi`='460048590503141',`v6`=-0,`update_time`=1742691727 WHERE `imei` = '868922055644021' [ RunTime:0.000522s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.798889s ]
[ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055644021' , 1742691726 , -1.335643 , 0.038365 , -1.116301 , -0.682826 , 5.76 , 18.615995 , 81.043762 , 27 , '898604650119C1053141' , '460048590503141' , -0 , 1742691728) [ RunTime:0.000661s ]
---------------------------------------------------------------
[ 2025-03-23T10:57:50+08:00 ] 39.144.112.20 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684076
[ sql ] [ DB ] CONNECT:[ UseTime:0.002233s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.097010s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000679s ]
---------------------------------------------------------------
[ 2025-03-23T10:57:58+08:00 ] 39.144.112.20 GET /kaiwu/public/index.php?s=/index/index/update/logs?sta=$&imei=868922055684076&date=250323&time=105701&v1=-00.829&v2=+00.007&v3=-00.671&v4=-00.288&v5=05.7&t=+32.5&h=81.2&rssi=+231&imsi=460044618415249&v6=-00.000&a1=00.196&a2=00.954&a3=00.000&end=$
[ sql ] [ DB ] CONNECT:[ UseTime:0.001492s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.007964s ]
[ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684076' LIMIT 1 [ RunTime:0.000681s ]
[ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684076',`date`='250323',`time`='105701',`v1`=-0.829,`v2`=0.007,`v3`=-0.671,`v4`=-0.288,`v5`=5.7,`t`=32.5,`h`=81.2,`rssi`=231,`imsi`='460044618415249',`v6`=-0,`a1`=0.196,`a2`=0.954,`update_time`=1742698678 WHERE `imei` = '868922055684076' [ RunTime:0.000482s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.007976s ]
[ 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' , '250323' , '105701' , -0.829 , 0.007 , -0.671 , -0.288 , 5.7 , 32.5 , 81.2 , 231 , '460044618415249' , -0 , 0.196 , 0.954 , 1742698678 , 1742698678) [ RunTime:0.000541s ]
---------------------------------------------------------------
[ 2025-03-23T14:33:27+08:00 ] 66.249.77.162 GET /admin/multipledata/delete/id/6761.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.002022s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipledata` [ RunTime:0.008302s ]
[ sql ] [ SQL ] SELECT * FROM `collect_multipledata` WHERE `id` = 6761 [ RunTime:0.001275s ]
---------------------------------------------------------------
[ 2025-03-23T16:41:49+08:00 ] 1.27.108.227 GET /home/heating/communication/id/2/unique_identification_number/123.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.002006s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heating` [ RunTime:0.014799s ]
[ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `id` = 2 LIMIT 1 [ RunTime:0.001055s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heatingroom` [ RunTime:0.010020s ]
[ sql ] [ SQL ] SELECT * FROM `collect_heatingroom` WHERE `unique_identification_number` = '123' ORDER BY `id` ASC [ RunTime:0.000581s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heatingshow` [ RunTime:0.008252s ]
[ sql ] [ SQL ] SELECT * FROM `collect_heatingshow` WHERE `unique_identification_number` = '123' LIMIT 1 [ RunTime:0.000584s ]
---------------------------------------------------------------
[ 2025-03-23T16:41:57+08:00 ] 1.27.108.227 GET /home/heating/communication/id/2/unique_identification_number/123.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001279s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heating` [ RunTime:0.009590s ]
[ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `id` = 2 LIMIT 1 [ RunTime:0.000831s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heatingroom` [ RunTime:0.007857s ]
[ sql ] [ SQL ] SELECT * FROM `collect_heatingroom` WHERE `unique_identification_number` = '123' ORDER BY `id` ASC [ RunTime:0.000504s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heatingshow` [ RunTime:0.007410s ]
[ sql ] [ SQL ] SELECT * FROM `collect_heatingshow` WHERE `unique_identification_number` = '123' LIMIT 1 [ RunTime:0.000533s ]
---------------------------------------------------------------
[ 2025-03-23T16:42:00+08:00 ] 27.115.124.101 GET /home/heating/communication/id/2/unique_identification_number/123.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001325s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heating` [ RunTime:0.010251s ]
[ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `id` = 2 LIMIT 1 [ RunTime:0.000917s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heatingroom` [ RunTime:0.007483s ]
[ sql ] [ SQL ] SELECT * FROM `collect_heatingroom` WHERE `unique_identification_number` = '123' ORDER BY `id` ASC [ RunTime:0.000571s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heatingshow` [ RunTime:0.006971s ]
[ sql ] [ SQL ] SELECT * FROM `collect_heatingshow` WHERE `unique_identification_number` = '123' LIMIT 1 [ RunTime:0.000509s ]
---------------------------------------------------------------
[ 2025-03-23T16:42:00+08:00 ] 27.115.124.101 GET /home/heating/communication/id/2/unique_identification_number/123.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001896s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heating` [ RunTime:0.008474s ]
[ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `id` = 2 LIMIT 1 [ RunTime:0.000841s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heatingroom` [ RunTime:0.031304s ]
[ sql ] [ SQL ] SELECT * FROM `collect_heatingroom` WHERE `unique_identification_number` = '123' ORDER BY `id` ASC [ RunTime:0.000578s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heatingshow` [ RunTime:0.009838s ]
[ sql ] [ SQL ] SELECT * FROM `collect_heatingshow` WHERE `unique_identification_number` = '123' LIMIT 1 [ RunTime:0.002147s ]
---------------------------------------------------------------
[ 2025-03-23T16:42:03+08:00 ] 1.27.108.227 GET /home/heating/communication/id/2/unique_identification_number/123.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001515s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heating` [ RunTime:0.008391s ]
[ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `id` = 2 LIMIT 1 [ RunTime:0.000984s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heatingroom` [ RunTime:0.007080s ]
[ sql ] [ SQL ] SELECT * FROM `collect_heatingroom` WHERE `unique_identification_number` = '123' ORDER BY `id` ASC [ RunTime:0.000457s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heatingshow` [ RunTime:0.008083s ]
[ sql ] [ SQL ] SELECT * FROM `collect_heatingshow` WHERE `unique_identification_number` = '123' LIMIT 1 [ RunTime:0.000522s ]
---------------------------------------------------------------
[ 2025-03-23T16:42:39+08:00 ] 1.27.108.227 GET /home/heating/communication/id/2/unique_identification_number/123.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001564s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heating` [ RunTime:0.008894s ]
[ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `id` = 2 LIMIT 1 [ RunTime:0.000855s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heatingroom` [ RunTime:0.007880s ]
[ sql ] [ SQL ] SELECT * FROM `collect_heatingroom` WHERE `unique_identification_number` = '123' ORDER BY `id` ASC [ RunTime:0.000583s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heatingshow` [ RunTime:0.007161s ]
[ sql ] [ SQL ] SELECT * FROM `collect_heatingshow` WHERE `unique_identification_number` = '123' LIMIT 1 [ RunTime:0.000474s ]
---------------------------------------------------------------
[ 2025-03-23T16:42:41+08:00 ] 1.27.108.227 GET /home/heating/communication/id/2/unique_identification_number/123.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001482s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heating` [ RunTime:0.008706s ]
[ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `id` = 2 LIMIT 1 [ RunTime:0.001159s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heatingroom` [ RunTime:0.007397s ]
[ sql ] [ SQL ] SELECT * FROM `collect_heatingroom` WHERE `unique_identification_number` = '123' ORDER BY `id` ASC [ RunTime:0.000502s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heatingshow` [ RunTime:0.007535s ]
[ sql ] [ SQL ] SELECT * FROM `collect_heatingshow` WHERE `unique_identification_number` = '123' LIMIT 1 [ RunTime:0.000505s ]
---------------------------------------------------------------
[ 2025-03-23T16:59:00+08:00 ] 1.27.108.227 GET /home/heating/communication/id/2/unique_identification_number/123.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.002299s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heating` [ RunTime:0.009279s ]
[ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `id` = 2 LIMIT 1 [ RunTime:0.000867s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heatingroom` [ RunTime:0.007831s ]
[ sql ] [ SQL ] SELECT * FROM `collect_heatingroom` WHERE `unique_identification_number` = '123' ORDER BY `id` ASC [ RunTime:0.000501s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heatingshow` [ RunTime:0.007681s ]
[ sql ] [ SQL ] SELECT * FROM `collect_heatingshow` WHERE `unique_identification_number` = '123' LIMIT 1 [ RunTime:0.000522s ]
---------------------------------------------------------------
[ 2025-03-23T16:59:29+08:00 ] 1.27.108.227 POST /home/login/login.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.002086s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_user` [ RunTime:0.007787s ]
[ sql ] [ SQL ] SELECT * FROM `collect_user` WHERE `username` = 'heating' AND `password` = 'ba3c4352a7a9e9c182e1a1ca75b7e844' LIMIT 1 [ RunTime:0.001332s ]
---------------------------------------------------------------
[ 2025-03-23T16:59:30+08:00 ] 1.27.108.227 GET /home/heating/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001282s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heating` [ RunTime:0.118277s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_heating` WHERE `username` = 'heating' LIMIT 1 [ RunTime:0.000438s ]
[ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `username` = 'heating' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000822s ]
[ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `username` = 'heating' ORDER BY `id` DESC [ RunTime:0.000762s ]
---------------------------------------------------------------
[ 2025-03-23T16:59:35+08:00 ] 1.27.108.227 GET /home/heating/communication/id/2/unique_identification_number/123.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001495s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heating` [ RunTime:0.424008s ]
[ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `id` = 2 LIMIT 1 [ RunTime:0.000816s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heatingroom` [ RunTime:0.008123s ]
[ sql ] [ SQL ] SELECT * FROM `collect_heatingroom` WHERE `unique_identification_number` = '123' ORDER BY `id` ASC [ RunTime:0.000501s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heatingshow` [ RunTime:0.007098s ]
[ sql ] [ SQL ] SELECT * FROM `collect_heatingshow` WHERE `unique_identification_number` = '123' LIMIT 1 [ RunTime:0.000473s ]
---------------------------------------------------------------
[ 2025-03-23T17:00:10+08:00 ] 123.6.49.15 GET /home/heating/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001531s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heating` [ RunTime:0.011482s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_heating` WHERE `username` IS NULL LIMIT 1 [ RunTime:0.000358s ]
[ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `username` IS NULL ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000684s ]
[ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `username` IS NULL ORDER BY `id` DESC [ RunTime:0.000749s ]
---------------------------------------------------------------
[ 2025-03-23T17:00:11+08:00 ] 123.6.49.47 GET /home/heating/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001274s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heating` [ RunTime:0.008213s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_heating` WHERE `username` IS NULL LIMIT 1 [ RunTime:0.000567s ]
[ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `username` IS NULL ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000643s ]
[ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `username` IS NULL ORDER BY `id` DESC [ RunTime:0.000687s ]
---------------------------------------------------------------
[ 2025-03-23T17:00:28+08:00 ] 1.27.108.227 GET /home/heating/communication/id/2/unique_identification_number/123.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001236s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heating` [ RunTime:0.008207s ]
[ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `id` = 2 LIMIT 1 [ RunTime:0.000807s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heatingroom` [ RunTime:0.007285s ]
[ sql ] [ SQL ] SELECT * FROM `collect_heatingroom` WHERE `unique_identification_number` = '123' ORDER BY `id` ASC [ RunTime:0.000498s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heatingshow` [ RunTime:0.007093s ]
[ sql ] [ SQL ] SELECT * FROM `collect_heatingshow` WHERE `unique_identification_number` = '123' LIMIT 1 [ RunTime:0.001117s ]
---------------------------------------------------------------
[ 2025-03-23T17:02:19+08:00 ] 1.27.108.227 GET /home/heating/communication/id/2/unique_identification_number/123.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001576s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heating` [ RunTime:0.294016s ]
[ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `id` = 2 LIMIT 1 [ RunTime:0.000819s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heatingroom` [ RunTime:0.006902s ]
[ sql ] [ SQL ] SELECT * FROM `collect_heatingroom` WHERE `unique_identification_number` = '123' ORDER BY `id` ASC [ RunTime:0.000444s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heatingshow` [ RunTime:0.007211s ]
[ sql ] [ SQL ] SELECT * FROM `collect_heatingshow` WHERE `unique_identification_number` = '123' LIMIT 1 [ RunTime:0.000466s ]
---------------------------------------------------------------
[ 2025-03-23T17:02:22+08:00 ] 1.27.108.227 GET /home/heating/communication/id/2/unique_identification_number/123.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001490s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heating` [ RunTime:0.008379s ]
[ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `id` = 2 LIMIT 1 [ RunTime:0.000823s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heatingroom` [ RunTime:0.006584s ]
[ sql ] [ SQL ] SELECT * FROM `collect_heatingroom` WHERE `unique_identification_number` = '123' ORDER BY `id` ASC [ RunTime:0.000451s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heatingshow` [ RunTime:0.006883s ]
[ sql ] [ SQL ] SELECT * FROM `collect_heatingshow` WHERE `unique_identification_number` = '123' LIMIT 1 [ RunTime:0.000464s ]
---------------------------------------------------------------
[ 2025-03-23T17:03:44+08:00 ] 1.27.108.227 GET /home/heating/index.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.001505s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heating` [ RunTime:0.034998s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_heating` WHERE `username` = 'heating' LIMIT 1 [ RunTime:0.000450s ]
[ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `username` = 'heating' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000839s ]
[ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `username` = 'heating' ORDER BY `id` DESC [ RunTime:0.000658s ]
---------------------------------------------------------------
[ 2025-03-23T18:57:28+08:00 ] 66.249.77.161 GET /admin/multipleshow/read/id/16/imei/863412043560864.html?page=26%%27%0DAND%0A6054%3D8491%0AAND%09%27fvgH%%27%3D%27fvgH
[ sql ] [ DB ] CONNECT:[ UseTime:0.002324s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipleshow` [ RunTime:0.008575s ]
[ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` WHERE `id` = 16 LIMIT 1 [ RunTime:0.000578s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipledata` [ RunTime:0.007743s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_multipledata` WHERE `imei` = '863412043560864' LIMIT 1 [ RunTime:0.051568s ]
[ sql ] [ SQL ] SELECT * FROM `collect_multipledata` WHERE `imei` = '863412043560864' ORDER BY `update_time` DESC LIMIT 250,10 [ RunTime:0.003532s ]