--------------------------------------------------------------- [ 2025-01-24T01:20:15+08:00 ] 111.55.120.84 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055684209 [ sql ] [ DB ] CONNECT:[ UseTime:0.002894s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.012499s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684209' LIMIT 1 [ RunTime:0.001445s ] --------------------------------------------------------------- [ 2025-01-24T01:20:16+08:00 ] 111.55.120.84 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055684209&create_time=1737652815&v1=-1.031509&v2=0.143551&v3=-0.749077&v4=-0.810392&v5=6.300000&t=-1.139634&h=74.650330&rssi=31&ccid=898604650119C1078511&imsi=460048590708511&v6=-00.000&gps=120.428389,36.323194&end=$ [ sql ] [ DB ] CONNECT:[ UseTime:0.001773s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.008283s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055684209' LIMIT 1 [ RunTime:0.000614s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055684209',`create_time`=1737652815,`v1`=-1.031509,`v2`=0.143551,`v3`=-0.749077,`v4`=-0.810392,`v5`=6.3,`t`=-1.139634,`h`=74.65033,`rssi`=31,`ccid`='898604650119C1078511',`imsi`='460048590708511',`v6`=-0,`gps`='120.428389,36.323194',`update_time`=1737652816 WHERE `imei` = '868922055684209' [ RunTime:0.000541s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.013035s ] [ 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' , 1737652815 , -1.031509 , 0.143551 , -0.749077 , -0.810392 , 6.3 , -1.139634 , 74.65033 , 31 , '898604650119C1078511' , '460048590708511' , -0 , '120.428389,36.323194' , 1737652816) [ RunTime:0.003437s ] --------------------------------------------------------------- [ 2025-01-24T02:41:24+08:00 ] 66.249.74.66 GET /admin/multipleshow/read/id/14/imei/862810047306690.html?page=69 [ sql ] [ DB ] CONNECT:[ UseTime:0.002055s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipleshow` [ RunTime:0.010561s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` WHERE `id` = 14 LIMIT 1 [ RunTime:0.000526s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipledata` [ RunTime:0.011436s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_multipledata` WHERE `imei` = '862810047306690' LIMIT 1 [ RunTime:0.016239s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipledata` WHERE `imei` = '862810047306690' ORDER BY `update_time` DESC LIMIT 680,10 [ RunTime:0.003519s ] --------------------------------------------------------------- [ 2025-01-24T03:18:39+08:00 ] 66.249.74.65 GET /admin/multipleshow/read/id/16/imei/863412043560864.html?page=-8774%22%0COR%091100%3D1100--%0CYmEs [ sql ] [ DB ] CONNECT:[ UseTime:0.002365s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipleshow` [ RunTime:0.011077s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` WHERE `id` = 16 LIMIT 1 [ RunTime:0.000630s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipledata` [ RunTime:0.009450s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_multipledata` WHERE `imei` = '863412043560864' LIMIT 1 [ RunTime:0.001925s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipledata` WHERE `imei` = '863412043560864' ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.002076s ] --------------------------------------------------------------- [ 2025-01-24T07:06:06+08:00 ] 111.55.120.74 GET /kaiwu/public/index.php?s=/index/index/get_command/imei/868922055644021 [ sql ] [ DB ] CONNECT:[ UseTime:0.002157s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_show` [ RunTime:0.009955s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644021' LIMIT 1 [ RunTime:0.001471s ] --------------------------------------------------------------- [ 2025-01-24T07:06:07+08:00 ] 111.55.120.74 GET /kaiwu/public/index.php?s=/index/index/update/&imei=868922055644021&create_time=1737673566&v1=-1.309516&v2=0.044079&v3=-1.053873&v4=-0.791850&v5=5.940000&t=-3.177402&h=82.638306&rssi=23&ccid=898604650119C1053141&imsi=460048590503141&v6=-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.008630s ] [ sql ] [ SQL ] SELECT * FROM `collect_show` WHERE `imei` = '868922055644021' LIMIT 1 [ RunTime:0.001100s ] [ sql ] [ SQL ] UPDATE `collect_show` SET `imei`='868922055644021',`create_time`=1737673566,`v1`=-1.309516,`v2`=0.044079,`v3`=-1.053873,`v4`=-0.79185,`v5`=5.94,`t`=-3.177402,`h`=82.638306,`rssi`=23,`ccid`='898604650119C1053141',`imsi`='460048590503141',`v6`=-0,`update_time`=1737673567 WHERE `imei` = '868922055644021' [ RunTime:0.000749s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_data` [ RunTime:0.010801s ] [ sql ] [ SQL ] INSERT INTO `collect_data` (`imei` , `create_time` , `v1` , `v2` , `v3` , `v4` , `v5` , `t` , `h` , `rssi` , `ccid` , `imsi` , `v6` , `update_time`) VALUES ('868922055644021' , 1737673566 , -1.309516 , 0.044079 , -1.053873 , -0.79185 , 5.94 , -3.177402 , 82.638306 , 23 , '898604650119C1053141' , '460048590503141' , -0 , 1737673567) [ RunTime:0.001457s ] --------------------------------------------------------------- [ 2025-01-24T11:20:03+08:00 ] 66.249.74.65 GET /admin/multipledata/delete/id/132.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002049s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipledata` [ RunTime:0.009065s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipledata` WHERE `id` = 132 [ RunTime:0.000573s ] --------------------------------------------------------------- [ 2025-01-24T11:27:30+08:00 ] 66.249.74.64 GET /admin/multipledata/delete/id/4121.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002319s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipledata` [ RunTime:0.008569s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipledata` WHERE `id` = 4121 [ RunTime:0.000521s ] --------------------------------------------------------------- [ 2025-01-24T12:32:29+08:00 ] 66.249.74.64 GET /admin/multipledata/delete/id/4127.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002187s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipledata` [ RunTime:0.009185s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipledata` WHERE `id` = 4127 [ RunTime:0.000584s ] --------------------------------------------------------------- [ 2025-01-24T15:21:53+08:00 ] 220.195.84.139 GET /home/heating/data_analysis.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002534s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heating` [ RunTime:0.011755s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_heating` WHERE `username` = 'heating' LIMIT 1 [ RunTime:0.000503s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `username` = 'heating' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000744s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `username` = 'heating' ORDER BY `id` DESC [ RunTime:0.000838s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heatingdata` [ RunTime:0.008840s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_heatingdata` WHERE `unique_identification_number` IS NULL AND ( `create_time` >= 0 AND `create_time` <= 0 ) LIMIT 1 [ RunTime:0.000361s ] [ sql ] [ SQL ] SELECT * FROM `collect_heatingdata` WHERE `unique_identification_number` IS NULL AND ( `create_time` >= 0 AND `create_time` <= 0 ) ORDER BY `create_time` ASC LIMIT 0,1000 [ RunTime:0.000419s ] --------------------------------------------------------------- [ 2025-01-24T15:22:00+08:00 ] 220.195.84.139 GET /home/heating/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001868s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heating` [ RunTime:0.009150s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_heating` WHERE `username` = 'heating' LIMIT 1 [ RunTime:0.000424s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `username` = 'heating' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000810s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `username` = 'heating' ORDER BY `id` DESC [ RunTime:0.000823s ] --------------------------------------------------------------- [ 2025-01-24T15:22:02+08:00 ] 220.195.84.139 GET /home/device/index.html?keyword= [ sql ] [ DB ] CONNECT:[ UseTime:0.001340s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_device` [ RunTime:0.012285s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_device` WHERE `username` = 'heating' LIMIT 1 [ RunTime:0.001324s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'heating' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000504s ] [ sql ] [ SQL ] SELECT * FROM `collect_device` WHERE `username` = 'heating' ORDER BY `id` DESC [ RunTime:0.000421s ] --------------------------------------------------------------- [ 2025-01-24T15:22:08+08:00 ] 220.195.84.139 GET /home/heating/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002443s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heating` [ RunTime:0.011758s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_heating` WHERE `username` = 'heating' LIMIT 1 [ RunTime:0.000490s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `username` = 'heating' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.001001s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `username` = 'heating' ORDER BY `id` DESC [ RunTime:0.000892s ] --------------------------------------------------------------- [ 2025-01-24T15:22:11+08:00 ] 220.195.84.139 GET /home/heating/communication/id/2/unique_identification_number/123.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002339s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heating` [ RunTime:0.008708s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `id` = 2 LIMIT 1 [ RunTime:0.001170s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heatingroom` [ RunTime:0.009561s ] [ sql ] [ SQL ] SELECT * FROM `collect_heatingroom` WHERE `unique_identification_number` = '123' ORDER BY `id` ASC [ RunTime:0.000608s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heatingshow` [ RunTime:0.008255s ] [ sql ] [ SQL ] SELECT * FROM `collect_heatingshow` WHERE `unique_identification_number` = '123' LIMIT 1 [ RunTime:0.000590s ] --------------------------------------------------------------- [ 2025-01-24T15:22:13+08:00 ] 27.115.124.101 GET /home/heating/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001400s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heating` [ RunTime:0.008703s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_heating` WHERE `username` IS NULL LIMIT 1 [ RunTime:0.000307s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `username` IS NULL ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000651s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `username` IS NULL ORDER BY `id` DESC [ RunTime:0.000716s ] --------------------------------------------------------------- [ 2025-01-24T15:22:15+08:00 ] 27.115.124.38 GET /home/heating/data_analysis.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001557s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heating` [ RunTime:0.008031s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_heating` WHERE `username` IS NULL LIMIT 1 [ RunTime:0.000336s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `username` IS NULL ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000695s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `username` IS NULL ORDER BY `id` DESC [ RunTime:0.000731s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heatingdata` [ RunTime:0.007927s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_heatingdata` WHERE `unique_identification_number` IS NULL AND ( `create_time` >= 0 AND `create_time` <= 0 ) LIMIT 1 [ RunTime:0.000367s ] [ sql ] [ SQL ] SELECT * FROM `collect_heatingdata` WHERE `unique_identification_number` IS NULL AND ( `create_time` >= 0 AND `create_time` <= 0 ) ORDER BY `create_time` ASC LIMIT 0,1000 [ RunTime:0.000442s ] --------------------------------------------------------------- [ 2025-01-24T15:22:34+08:00 ] 123.6.49.44 GET /home/heating/communication/id/2/unique_identification_number/123.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001330s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heating` [ RunTime:0.008729s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `id` = 2 LIMIT 1 [ RunTime:0.000872s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heatingroom` [ RunTime:0.007426s ] [ sql ] [ SQL ] SELECT * FROM `collect_heatingroom` WHERE `unique_identification_number` = '123' ORDER BY `id` ASC [ RunTime:0.000520s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heatingshow` [ RunTime:0.007448s ] [ sql ] [ SQL ] SELECT * FROM `collect_heatingshow` WHERE `unique_identification_number` = '123' LIMIT 1 [ RunTime:0.000536s ] --------------------------------------------------------------- [ 2025-01-24T15:23:07+08:00 ] 220.195.84.139 GET /home/heating/data_analysis_day.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001574s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heating` [ RunTime:0.008529s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_heating` WHERE `username` = 'heating' LIMIT 1 [ RunTime:0.000432s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `username` = 'heating' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000804s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `username` = 'heating' ORDER BY `id` DESC [ RunTime:0.000659s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heatingdataave` [ RunTime:0.010169s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_heatingdataave` WHERE `unique_identification_number` IS NULL AND ( `create_time` >= 0 AND `create_time` <= 0 ) LIMIT 1 [ RunTime:0.000344s ] [ sql ] [ SQL ] SELECT * FROM `collect_heatingdataave` WHERE `unique_identification_number` IS NULL AND ( `create_time` >= 0 AND `create_time` <= 0 ) ORDER BY `create_time` ASC LIMIT 0,1000 [ RunTime:0.000339s ] --------------------------------------------------------------- [ 2025-01-24T15:23:19+08:00 ] 220.195.84.139 GET /home/heating/data_analysis_day.html?keyword=123&start_date=2025-01-01&end_date=2025-01-24 [ sql ] [ DB ] CONNECT:[ UseTime:0.002326s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heating` [ RunTime:0.012008s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `username` = 'heating' AND `unique_identification_number` = '123' LIMIT 1 [ RunTime:0.001343s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_heating` WHERE `unique_identification_number` = '123' AND `username` = 'heating' LIMIT 1 [ RunTime:0.000588s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `unique_identification_number` = '123' AND `username` = 'heating' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000998s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `username` = 'heating' ORDER BY `id` DESC [ RunTime:0.001170s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heatingdataave` [ RunTime:0.011098s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_heatingdataave` WHERE `unique_identification_number` = '123' AND ( `create_time` >= 1735660800 AND `create_time` <= 1737648000 ) LIMIT 1 [ RunTime:0.001538s ] [ sql ] [ SQL ] SELECT * FROM `collect_heatingdataave` WHERE `unique_identification_number` = '123' AND ( `create_time` >= 1735660800 AND `create_time` <= 1737648000 ) ORDER BY `create_time` ASC LIMIT 0,1000 [ RunTime:0.000775s ] --------------------------------------------------------------- [ 2025-01-24T15:23:26+08:00 ] 27.115.124.101 GET /home/heating/data_analysis_day.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001539s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heating` [ RunTime:0.010787s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_heating` WHERE `username` IS NULL LIMIT 1 [ RunTime:0.000367s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `username` IS NULL ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000847s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `username` IS NULL ORDER BY `id` DESC [ RunTime:0.000862s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heatingdataave` [ RunTime:0.008356s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_heatingdataave` WHERE `unique_identification_number` IS NULL AND ( `create_time` >= 0 AND `create_time` <= 0 ) LIMIT 1 [ RunTime:0.000371s ] [ sql ] [ SQL ] SELECT * FROM `collect_heatingdataave` WHERE `unique_identification_number` IS NULL AND ( `create_time` >= 0 AND `create_time` <= 0 ) ORDER BY `create_time` ASC LIMIT 0,1000 [ RunTime:0.000465s ] --------------------------------------------------------------- [ 2025-01-24T15:23:40+08:00 ] 220.195.84.139 GET /home/heating/data_analysis.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001344s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heating` [ RunTime:0.009243s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_heating` WHERE `username` = 'heating' LIMIT 1 [ RunTime:0.000451s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `username` = 'heating' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000812s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `username` = 'heating' ORDER BY `id` DESC [ RunTime:0.000662s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heatingdata` [ RunTime:0.007520s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_heatingdata` WHERE `unique_identification_number` IS NULL AND ( `create_time` >= 0 AND `create_time` <= 0 ) LIMIT 1 [ RunTime:0.000540s ] [ sql ] [ SQL ] SELECT * FROM `collect_heatingdata` WHERE `unique_identification_number` IS NULL AND ( `create_time` >= 0 AND `create_time` <= 0 ) ORDER BY `create_time` ASC LIMIT 0,1000 [ RunTime:0.000373s ] --------------------------------------------------------------- [ 2025-01-24T15:23:51+08:00 ] 220.195.84.139 GET /home/heating/data_analysis.html?keyword=123&start_date=2025-01-01&end_date=2025-01-24 [ sql ] [ DB ] CONNECT:[ UseTime:0.001866s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heating` [ RunTime:0.008873s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `username` = 'heating' AND `unique_identification_number` = '123' LIMIT 1 [ RunTime:0.000831s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_heating` WHERE `unique_identification_number` = '123' AND `username` = 'heating' LIMIT 1 [ RunTime:0.000409s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `unique_identification_number` = '123' AND `username` = 'heating' ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000666s ] [ sql ] [ SQL ] SELECT * FROM `collect_heating` WHERE `username` = 'heating' ORDER BY `id` DESC [ RunTime:0.000868s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_heatingdata` [ RunTime:0.007383s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_heatingdata` WHERE `unique_identification_number` = '123' AND ( `create_time` >= 1735660800 AND `create_time` <= 1737648000 ) LIMIT 1 [ RunTime:0.002444s ] [ sql ] [ SQL ] SELECT * FROM `collect_heatingdata` WHERE `unique_identification_number` = '123' AND ( `create_time` >= 1735660800 AND `create_time` <= 1737648000 ) ORDER BY `create_time` ASC LIMIT 0,1000 [ RunTime:0.002277s ] --------------------------------------------------------------- [ 2025-01-24T22:55:44+08:00 ] 66.249.70.64 GET /admin/multipleshow/read/id/14/imei/862810047306690.html?page=69 [ sql ] [ DB ] CONNECT:[ UseTime:0.002835s ] mysql:host=127.0.0.1;port=3306;dbname=kaiwu;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipleshow` [ RunTime:0.011318s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipleshow` WHERE `id` = 14 LIMIT 1 [ RunTime:0.000522s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `collect_multipledata` [ RunTime:0.010092s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `collect_multipledata` WHERE `imei` = '862810047306690' LIMIT 1 [ RunTime:0.016322s ] [ sql ] [ SQL ] SELECT * FROM `collect_multipledata` WHERE `imei` = '862810047306690' ORDER BY `update_time` DESC LIMIT 680,10 [ RunTime:0.004206s ]