2023/03/15 11:56:14.461 [ORM]2023/03/15 11:56:14 -[Queries/default] - [ OK / db.Query / 61.3ms] - [SELECT T0.`ID`, T0.`t_name`, T0.`t__tips` FROM `warning_type` T0 ] 2023/03/15 11:56:14.463 [ORM]2023/03/15 11:56:14 -[Queries/default] - [ OK / db.Query / 62.7ms] - [SELECT T0.`ID`, T0.`t_name`, T0.`t_model` FROM `product_type` T0 ] 2023/03/15 11:56:17.690 [ORM]2023/03/15 11:56:17 -[Queries/default] - [ OK / db.Exec / 19.0ms] - [INSERT INTO z_device_data_2023122788596641 (`t_id`, `t_t`, `t_rh`, `t_site`, `t_time`, `t_sp`) VALUES (1 , 17.899999618530273, 59.5, '', '2023-03-15 11:56:00', 4577)] 2023/03/15 11:56:17.706 [ORM]2023/03/15 11:56:17 -[Queries/default] - [ OK / db.Exec / 34.3ms] - [UPDATE `device` SET `t__dattery` = ?, `t_rssi` = ?, `update_time` = ? WHERE `t_sn` = ?] - `100`, `31`, `2023-03-15 11:56:17.6722664 +0800 CST m=+4.618853401`, `2023122788596641` 2023/03/15 11:56:18.888 [ORM]2023/03/15 11:56:18 -[Queries/default] - [ OK / db.Exec / 24.3ms] - [INSERT INTO z_device_data_2023125067633148 (`t_id`, `t_t`, `t_rh`, `t_site`, `t_time`, `t_sp`) VALUES (1 , 17.100000381469727, 63.29999923706055, '', '2023-03-15 11:56:00', 4709)] 2023/03/15 11:56:18.935 [ORM]2023/03/15 11:56:18 -[Queries/default] - [ OK / db.Exec / 31.2ms] - [UPDATE `device` SET `t__dattery` = ?, `t_rssi` = ?, `update_time` = ? WHERE `t_sn` = ?] - `100`, `24`, `2023-03-15 11:56:18.9041667 +0800 CST m=+5.850743501`, `2023125067633148` 2023/03/15 11:56:20.723 [ORM]2023/03/15 11:56:20 -[Queries/default] - [ OK / db.Query / 27.9ms] - [SELECT T0.`ID`, T0.`t_pid`, T0.`t_name`, T0.`t__notice_wx`, T0.`t__notice_phone`, T0.`t__notice_message`, T0.`t__notice_mailbox`, T0.`t__notice_mechanism`, T0.`t__notice_bind`, T0.`t__state`, T0.`create_time`, T0.`update_time` FROM `company_notice` T0 WHERE T0.`t_pid` = ? ORDER BY T0.`ID` ASC ] - `37` 2023/03/15 11:56:20.762 [ORM]2023/03/15 11:56:20 -[Queries/default] - [ OK / db.Query / 26.5ms] - [SELECT T0.`ID`, T0.`t_mid`, T0.`t_name`, T0.`t_key`, T0.`t_money`, T0.`t__state`, T0.`create_time`, T0.`update_time` FROM `company` T0 WHERE T0.`ID` = ? AND T0.`t__state` = ? LIMIT 1] - `37`, `1` 2023/03/15 11:56:20.842 [ORM]2023/03/15 11:56:20 -[Queries/default] - [ OK / db.QueryRow / 27.2ms] - [SELECT `ID`, `t_uuid`, `t_pid`, `t_pids`, `t_power`, `t_user`, `t_pass`, `t_name`, `t_phone`, `t_mail`, `t_wx`, `t__state`, `create_time`, `update_time` FROM `admin` WHERE `t_uuid` = ? AND `t__state` = ? ] - `dab65906-d03a-427c-8524-7c7a57ab8058`, `1` 2023/03/15 11:56:21.269 [ORM]2023/03/15 11:56:21 -[Queries/default] - [ OK / db.Exec / 17.9ms] - [INSERT INTO z_device_data_2023123898034225 (`t_id`, `t_t`, `t_rh`, `t_site`, `t_time`, `t_sp`) VALUES (1 , 17.299999237060547, 62.20000076293945, '', '2023-03-15 11:56:00', 4563)] 2023/03/15 11:56:21.281 [ORM]2023/03/15 11:56:21 -[Queries/default] - [ OK / db.Exec / 19.4ms] - [INSERT INTO warning_sand_202303(`t_pid`, `t_tp`, `t__ntype`, `t__notice`, `t__remark`, `create_time`) VALUES (37 , 6, 0, 'oZMR-6XVx-O5gsUDOnd45aCeVamM', 'WID：0 类型：湿度超上限报警 SN：2023105182699608 主机：小管理主机2号-测试样机 设备：办公室测试2-1 备注： 通知方式：短信通知 通知对象：oZMR-6XVx-O5gsUDOnd45aCeVamM', '2023-03-15 11:56:21')] 2023/03/15 11:56:21.303 [ORM]2023/03/15 11:56:21 -[Queries/default] - [ OK / db.Exec / 32.8ms] - [UPDATE `device` SET `t__dattery` = ?, `t_rssi` = ?, `update_time` = ? WHERE `t_sn` = ?] - `100`, `22`, `2023-03-15 11:56:21.2706101 +0800 CST m=+8.217167501`, `2023123898034225` 2023/03/15 11:56:21.684 [ORM]2023/03/15 11:56:21 -[Queries/default] - [ OK / db.Exec / 18.4ms] - [INSERT INTO warning_sand_202303(`t_pid`, `t_tp`, `t__ntype`, `t__notice`, `t__remark`, `create_time`) VALUES (37 , 6, 0, 'oZMR-6eyBpryepFcaFawH7n6b2ZI', 'WID：0 类型：湿度超上限报警 SN：2023105182699608 主机：小管理主机2号-测试样机 设备：办公室测试2-1 备注：4G冰箱冯测试01 通知方式：短信通知 通知对象：oZMR-6eyBpryepFcaFawH7n6b2ZI', '2023-03-15 11:56:21')] 2023/03/15 11:56:21.718 [ORM]2023/03/15 11:56:21 -[Queries/default] - [ OK / db.Exec / 34.4ms] - [INSERT INTO `warning` (`t_pid`, `t_tp`, `t_sn`, `t__d_name`, `t_id`, `t__d_s_name`, `t__remark`, `t__ut`, `t_f_ut`, `t__text`, `t__log`, `t__msid`, `t__state`, `create_time`, `update_time`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)] - `37`, `6`, `2023105182699608`, `小管理主机2号-测试样机`, `1`, `办公室测试2-1`, `当前湿度:91.8 (↑80~↓20),`, `2023-03-15 11:56:09 +0800 CST`, `2023-03-15 11:56:09 +0800 CST`, ``, `执行通知策略 ->[小管理主机测-wj] [微信]持续时间:11秒, 间隔时间:0秒, 内发送次数:0次, 间隔还剩时间:0秒 ----> oZMR-6XVx-O5gsUDOnd45aCeVamM/bc测试->发送成功！ ----> oZMR-6eyBpryepFcaFawH7n6b2ZI/小管理主机->发送成功！ `, `14169017`, `3`, `2023-03-15 11:56:21.6842088 +0800 CST`, `2023-03-15 11:56:21.6842088 +0800 CST` 2023/03/15 11:56:22.975 [ORM]2023/03/15 11:56:22 -[Queries/default] - [ OK / db.Query / 29.0ms] - [SELECT T0.`ID`, T0.`t_pid`, T0.`t_name`, T0.`t__notice_wx`, T0.`t__notice_phone`, T0.`t__notice_message`, T0.`t__notice_mailbox`, T0.`t__notice_mechanism`, T0.`t__notice_bind`, T0.`t__state`, T0.`create_time`, T0.`update_time` FROM `company_notice` T0 WHERE T0.`t_pid` = ? ORDER BY T0.`ID` ASC ] - `37` 2023/03/15 11:56:23.013 [ORM]2023/03/15 11:56:23 -[Queries/default] - [ OK / db.Exec / 37.7ms] - [INSERT INTO `warning` (`t_pid`, `t_tp`, `t_sn`, `t__d_name`, `t_id`, `t__d_s_name`, `t__remark`, `t__ut`, `t_f_ut`, `t__text`, `t__log`, `t__msid`, `t__state`, `create_time`, `update_time`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)] - `37`, `103`, `2023105182699608`, `小管理主机2号-测试样机`, `0`, `小管理主机2号-测试样机`, `发送温湿度报警信息成功`, `2023-03-15 11:56:09 +0800 CST`, `2023-03-15 11:56:09 +0800 CST`, ``, `执行通知策略 ->[小管理主机测-wj] `, `14169019`, `1`, `2023-03-15 11:56:22.9757806 +0800 CST`, `2023-03-15 11:56:22.9757806 +0800 CST` 2023/03/15 11:56:23.715 [ORM]2023/03/15 11:56:23 -[Queries/default] - [ OK / db.Exec / 23.1ms] - [INSERT INTO z_device_data_2023105182699608 (`t_id`, `t_t`, `t_rh`, `t_site`, `t_time`, `t_sp`) VALUES (1 , 20.399999618530273, 91.80000305175781, '', '2023-03-15 11:56:09', 4674)] 2023/03/15 11:56:25.733 [ORM]2023/03/15 11:56:25 -[Queries/default] - [ OK / db.Exec / 41.9ms] - [UPDATE `device` SET `t__dattery` = ?, `t_rssi` = ?, `update_time` = ? WHERE `t_sn` = ?] - `100`, `24`, `2023-03-15 11:56:25.6919527 +0800 CST m=+12.638473901`, `2023125067633148` 2023/03/15 11:56:26.914 [ORM]2023/03/15 11:56:26 -[Queries/default] - [ OK / db.Exec / 34.0ms] - [UPDATE `device` SET `t__dattery` = ?, `t_rssi` = ?, `update_time` = ? WHERE `t_sn` = ?] - `100`, `11`, `2023-03-15 11:56:26.8803468 +0800 CST m=+13.826858201`, `2023125762710435` 2023/03/15 11:56:36.064 [ORM]2023/03/15 11:56:36 -[Queries/default] - [ OK / db.Exec / 36.3ms] - [UPDATE `device` SET `t__dattery` = ?, `t_rssi` = ?, `update_time` = ? WHERE `t_sn` = ?] - `100`, `24`, `2023-03-15 11:56:36.0283839 +0800 CST m=+22.974820301`, `2023125067633148` 2023/03/15 11:56:36.353 [ORM]2023/03/15 11:56:36 -[Queries/default] - [ OK / db.Exec / 33.4ms] - [UPDATE `device` SET `t__dattery` = ?, `t_rssi` = ?, `update_time` = ? WHERE `t_sn` = ?] - `100`, `11`, `2023-03-15 11:56:36.3204824 +0800 CST m=+23.266916401`, `2023125762710435` 2023/03/15 11:56:46.423 [ORM]2023/03/15 11:56:46 -[Queries/default] - [ OK / db.Exec / 38.2ms] - [UPDATE `device` SET `t__dattery` = ?, `t_rssi` = ?, `update_time` = ? WHERE `t_sn` = ?] - `100`, `12`, `2023-03-15 11:56:46.3850629 +0800 CST m=+33.331414401`, `2023125762710435` 2023/03/15 11:56:46.470 [ORM]2023/03/15 11:56:46 -[Queries/default] - [ OK / db.Exec / 34.0ms] - [UPDATE `device` SET `t__dattery` = ?, `t_rssi` = ?, `update_time` = ? WHERE `t_sn` = ?] - `100`, `24`, `2023-03-15 11:56:46.4364711 +0800 CST m=+33.382822201`, `2023125067633148` 2023/03/15 11:56:47.080 [ORM]2023/03/15 11:56:47 -[Queries/default] - [ OK / db.Exec / 31.9ms] - [UPDATE `device_sensor_parameter` SET `t__msid` = ?, `update_time` = ? WHERE `ID` = ?] - `1678852607`, `2023-03-15 11:56:47.0482736 +0800 CST m=+33.994619701`, `4719` 2023/03/15 11:56:47.409 [ORM]2023/03/15 11:56:47 -[Queries/default] - [ OK / db.Query / 29.0ms] - [SELECT T0.`ID`, T0.`t_sn`, T0.`t_id`, T0.`t_name`, T0.`t__tlower`, T0.`t__tupper`, T0.`t__r_hlower`, T0.`t__r_hupper`, T0.`t_enprel`, T0.`t_tprel`, T0.`t_tpreu`, T0.`t_hprel`, T0.`t_hpreu`, T0.`t_speed`, T0.`t_en`, T0.`t_free`, T0.`t_uuid`, T0.`t__msid`, T0.`t__send_state`, T0.`t__state`, T0.`create_time`, T0.`update_time` FROM `device_sensor_parameter` T0 WHERE T0.`t_sn` = ? AND T0.`t__msid` = ? ORDER BY T0.`ID` DESC ] - `2023125762710435`, `1678852607` 2023/03/15 11:56:47.462 [ORM]2023/03/15 11:56:47 -[Queries/default] - [ OK / db.Exec / 26.4ms] - [UPDATE `device_sensor` SET `t_name` = ?, `update_time` = ? WHERE `ID` = ?] - `4G冰箱冯测试01`, `2023-03-15 11:56:47.4361062 +0800 CST m=+34.382449101`, `185` 2023/03/15 11:56:47.506 [ORM]2023/03/15 11:56:47 -[Queries/default] - [ OK / db.Exec / 31.3ms] - [UPDATE `device_sensor_parameter` SET `t__send_state` = ?, `update_time` = ? WHERE `ID` = ?] - `1`, `2023-03-15 11:56:47.4756217 +0800 CST m=+34.421964301`, `4719` 2023/03/15 11:56:47.561 [ORM]2023/03/15 11:56:47 -[Queries/default] - [ OK / db.Exec / 34.3ms] - [UPDATE `device_sensor` SET `t_name` = ?, `update_time` = ? WHERE `ID` = ?] - `4G冰箱冯测试01`, `2023-03-15 11:56:47.526883 +0800 CST m=+34.473225101`, `185` 2023/03/15 11:56:47.565 [ORM]2023/03/15 11:56:47 -[Queries/default] - [ OK / db.Exec / 31.8ms] - [INSERT INTO `warning` (`t_pid`, `t_tp`, `t_sn`, `t__d_name`, `t_id`, `t__d_s_name`, `t__remark`, `t__ut`, `t_f_ut`, `t__text`, `t__log`, `t__msid`, `t__state`, `create_time`, `update_time`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)] - `37`, `102`, `2023125762710435`, `4G冰箱冯测试`, `0`, `4G冰箱冯测试`, `修改设备参数`, `2023-03-15 11:56:47.5332811 +0800 CST`, ``, ``, ``, `0`, `1`, `2023-03-15 11:56:47.5332811 +0800 CST`, `2023-03-15 11:56:47.5332811 +0800 CST` 2023/03/15 11:56:47.586 [ORM]2023/03/15 11:56:47 -[Queries/default] - [ OK / db.Exec / 21.7ms] - [UPDATE device_sensor_parameter SET `t__send_state` = 3 WHERE `t_sn` LIKE '%2023125762710435%' AND `t_id` = 1 AND `t__send_state` = '0' AND `t__state` = '2'] 2023/03/15 11:56:47.686 [ORM]2023/03/15 11:56:47 -[Queries/default] - [ OK / db.Exec / 31.3ms] - [UPDATE `device_sensor_parameter` SET `t__msid` = ?, `update_time` = ? WHERE `ID` = ?] - `1678852607`, `2023-03-15 11:56:47.65474 +0800 CST m=+34.601081101`, `4720` 2023/03/15 11:56:47.914 [ORM]2023/03/15 11:56:47 -[Queries/default] - [ OK / db.Query / 28.1ms] - [SELECT T0.`ID`, T0.`t_sn`, T0.`t_id`, T0.`t_name`, T0.`t__tlower`, T0.`t__tupper`, T0.`t__r_hlower`, T0.`t__r_hupper`, T0.`t_enprel`, T0.`t_tprel`, T0.`t_tpreu`, T0.`t_hprel`, T0.`t_hpreu`, T0.`t_speed`, T0.`t_en`, T0.`t_free`, T0.`t_uuid`, T0.`t__msid`, T0.`t__send_state`, T0.`t__state`, T0.`create_time`, T0.`update_time` FROM `device_sensor_parameter` T0 WHERE T0.`t_sn` = ? AND T0.`t__msid` = ? ORDER BY T0.`ID` DESC ] - `2023125762710435`, `1678852607` 2023/03/15 11:56:47.968 [ORM]2023/03/15 11:56:47 -[Queries/default] - [ OK / db.Exec / 26.7ms] - [UPDATE `device_sensor` SET `t_name` = ?, `update_time` = ? WHERE `ID` = ?] - `4G冰箱冯测试01`, `2023-03-15 11:56:47.9415382 +0800 CST m=+34.887876901`, `185` 2023/03/15 11:56:48.012 [ORM]2023/03/15 11:56:48 -[Queries/default] - [ OK / db.Exec / 31.0ms] - [UPDATE `device_sensor_parameter` SET `t__send_state` = ?, `update_time` = ? WHERE `ID` = ?] - `1`, `2023-03-15 11:56:47.981472 +0800 CST m=+34.927810401`, `4720` 2023/03/15 11:56:48.063 [ORM]2023/03/15 11:56:48 -[Queries/default] - [ OK / db.Exec / 27.1ms] - [UPDATE `device_sensor` SET `t_name` = ?, `update_time` = ? WHERE `ID` = ?] - `4G冰箱冯测试01`, `2023-03-15 11:56:48.0363189 +0800 CST m=+34.982656901`, `185` 2023/03/15 11:56:48.070 [ORM]2023/03/15 11:56:48 -[Queries/default] - [ OK / db.Exec / 32.1ms] - [INSERT INTO `warning` (`t_pid`, `t_tp`, `t_sn`, `t__d_name`, `t_id`, `t__d_s_name`, `t__remark`, `t__ut`, `t_f_ut`, `t__text`, `t__log`, `t__msid`, `t__state`, `create_time`, `update_time`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)] - `37`, `102`, `2023125762710435`, `4G冰箱冯测试`, `0`, `4G冰箱冯测试`, `修改设备参数`, `2023-03-15 11:56:48.0381695 +0800 CST`, ``, ``, ``, `0`, `1`, `2023-03-15 11:56:48.0381695 +0800 CST`, `2023-03-15 11:56:48.0381695 +0800 CST` 2023/03/15 11:56:48.085 [ORM]2023/03/15 11:56:48 -[Queries/default] - [ OK / db.Exec / 15.6ms] - [UPDATE device_sensor_parameter SET `t__send_state` = 3 WHERE `t_sn` LIKE '%2023125762710435%' AND `t_id` = 1 AND `t__send_state` = '0' AND `t__state` = '2'] 2023/03/15 11:56:50.967 [ORM]2023/03/15 11:56:50 -[Queries/default] - [ OK / db.Exec / 31.5ms] - [UPDATE `device` SET `t__dattery` = ?, `t_rssi` = ?, `update_time` = ? WHERE `t_sn` = ?] - `100`, `12`, `2023-03-15 11:56:50.9361504 +0800 CST m=+37.882464601`, `2023125762710435` 2023/03/15 11:56:51.442 [ORM]2023/03/15 11:56:51 -[Queries/default] - [ OK / db.Exec / 26.6ms] - [UPDATE `device` SET `t__dattery` = ?, `t_rssi` = ?, `update_time` = ? WHERE `t_sn` = ?] - `100`, `12`, `2023-03-15 11:56:51.4153522 +0800 CST m=+38.361662501`, `2023125762710435` 2023/03/15 11:56:56.647 [ORM]2023/03/15 11:56:56 -[Queries/default] - [ OK / db.Exec / 32.3ms] - [UPDATE `device` SET `t__dattery` = ?, `t_rssi` = ?, `update_time` = ? WHERE `t_sn` = ?] - `100`, `24`, `2023-03-15 11:56:56.6151066 +0800 CST m=+43.561374201`, `2023125067633148` 2023/03/15 11:56:56.935 [ORM]2023/03/15 11:56:56 -[Queries/default] - [ OK / db.Exec / 34.6ms] - [UPDATE `device` SET `t__dattery` = ?, `t_rssi` = ?, `update_time` = ? WHERE `t_sn` = ?] - `100`, `12`, `2023-03-15 11:56:56.9012373 +0800 CST m=+43.847502601`, `2023125762710435` 2023/03/15 11:56:57.008 [ORM]2023/03/15 11:56:57 -[Queries/default] - [ OK / db.Exec / 33.7ms] - [UPDATE `device_sensor_parameter` SET `t__msid` = ?, `update_time` = ? WHERE `ID` = ?] - `1678852616`, `2023-03-15 11:56:56.9750209 +0800 CST m=+43.921285601`, `4721` 2023/03/15 11:56:57.233 [ORM]2023/03/15 11:56:57 -[Queries/default] - [ OK / db.Query / 27.7ms] - [SELECT T0.`ID`, T0.`t_sn`, T0.`t_id`, T0.`t_name`, T0.`t__tlower`, T0.`t__tupper`, T0.`t__r_hlower`, T0.`t__r_hupper`, T0.`t_enprel`, T0.`t_tprel`, T0.`t_tpreu`, T0.`t_hprel`, T0.`t_hpreu`, T0.`t_speed`, T0.`t_en`, T0.`t_free`, T0.`t_uuid`, T0.`t__msid`, T0.`t__send_state`, T0.`t__state`, T0.`create_time`, T0.`update_time` FROM `device_sensor_parameter` T0 WHERE T0.`t_sn` = ? AND T0.`t__msid` = ? ORDER BY T0.`ID` DESC ] - `2023125762710435`, `1678852616` 2023/03/15 11:56:57.289 [ORM]2023/03/15 11:56:57 -[Queries/default] - [ OK / db.Exec / 26.5ms] - [UPDATE `device_sensor` SET `t_name` = ?, `update_time` = ? WHERE `ID` = ?] - `4G冰箱冯测试01`, `2023-03-15 11:56:57.2629499 +0800 CST m=+44.209212201`, `185` 2023/03/15 11:56:57.337 [ORM]2023/03/15 11:56:57 -[Queries/default] - [ OK / db.Exec / 34.4ms] - [UPDATE `device_sensor_parameter` SET `t__send_state` = ?, `update_time` = ? WHERE `ID` = ?] - `1`, `2023-03-15 11:56:57.3028976 +0800 CST m=+44.249159601`, `4721` 2023/03/15 11:56:57.387 [ORM]2023/03/15 11:56:57 -[Queries/default] - [ OK / db.Exec / 26.4ms] - [UPDATE `device_sensor` SET `t_name` = ?, `update_time` = ? WHERE `ID` = ?] - `4G冰箱冯测试01`, `2023-03-15 11:56:57.3614985 +0800 CST m=+44.307760001`, `185` 2023/03/15 11:56:57.394 [ORM]2023/03/15 11:56:57 -[Queries/default] - [ OK / db.Exec / 31.0ms] - [INSERT INTO `warning` (`t_pid`, `t_tp`, `t_sn`, `t__d_name`, `t_id`, `t__d_s_name`, `t__remark`, `t__ut`, `t_f_ut`, `t__text`, `t__log`, `t__msid`, `t__state`, `create_time`, `update_time`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)] - `37`, `102`, `2023125762710435`, `4G冰箱冯测试`, `0`, `4G冰箱冯测试`, `修改设备参数`, `2023-03-15 11:56:57.3631958 +0800 CST`, ``, ``, ``, `0`, `1`, `2023-03-15 11:56:57.3631958 +0800 CST`, `2023-03-15 11:56:57.3631958 +0800 CST` 2023/03/15 11:56:57.409 [ORM]2023/03/15 11:56:57 -[Queries/default] - [ OK / db.Exec / 15.4ms] - [UPDATE device_sensor_parameter SET `t__send_state` = 3 WHERE `t_sn` LIKE '%2023125762710435%' AND `t_id` = 1 AND `t__send_state` = '0' AND `t__state` = '2'] 2023/03/15 11:57:00.803 [ORM]2023/03/15 11:57:00 -[Queries/default] - [ OK / db.Exec / 33.3ms] - [UPDATE `device` SET `t__dattery` = ?, `t_rssi` = ?, `update_time` = ? WHERE `t_sn` = ?] - `100`, `12`, `2023-03-15 11:57:00.7700933 +0800 CST m=+47.716326801`, `2023125762710435` 2023/03/15 11:57:06.423 [ORM]2023/03/15 11:57:06 -[Queries/default] - [ OK / db.Query / 28.2ms] - [SELECT T0.`ID`, T0.`t_pid`, T0.`t_name`, T0.`t__notice_wx`, T0.`t__notice_phone`, T0.`t__notice_message`, T0.`t__notice_mailbox`, T0.`t__notice_mechanism`, T0.`t__notice_bind`, T0.`t__state`, T0.`create_time`, T0.`update_time` FROM `company_notice` T0 WHERE T0.`t_pid` = ? ORDER BY T0.`ID` ASC ] - `37` 2023/03/15 11:57:06.463 [ORM]2023/03/15 11:57:06 -[Queries/default] - [ OK / db.Query / 26.6ms] - [SELECT T0.`ID`, T0.`t_mid`, T0.`t_name`, T0.`t_key`, T0.`t_money`, T0.`t__state`, T0.`create_time`, T0.`update_time` FROM `company` T0 WHERE T0.`ID` = ? AND T0.`t__state` = ? LIMIT 1] - `37`, `1` 2023/03/15 11:57:06.545 [ORM]2023/03/15 11:57:06 -[Queries/default] - [ OK / db.QueryRow / 29.6ms] - [SELECT `ID`, `t_uuid`, `t_pid`, `t_pids`, `t_power`, `t_user`, `t_pass`, `t_name`, `t_phone`, `t_mail`, `t_wx`, `t__state`, `create_time`, `update_time` FROM `admin` WHERE `t_uuid` = ? AND `t__state` = ? ] - `dab65906-d03a-427c-8524-7c7a57ab8058`, `1` 2023/03/15 11:57:06.944 [ORM]2023/03/15 11:57:06 -[Queries/default] - [ OK / db.Exec / 32.1ms] - [UPDATE `device` SET `t__dattery` = ?, `t_rssi` = ?, `update_time` = ? WHERE `t_sn` = ?] - `100`, `24`, `2023-03-15 11:57:06.9124919 +0800 CST m=+53.858675101`, `2023125067633148` 2023/03/15 11:57:06.992 [ORM]2023/03/15 11:57:06 -[Queries/default] - [ OK / db.Exec / 18.5ms] - [INSERT INTO warning_sand_202303(`t_pid`, `t_tp`, `t__ntype`, `t__notice`, `t__remark`, `create_time`) VALUES (37 , 3, 0, 'oZMR-6XVx-O5gsUDOnd45aCeVamM', 'WID：0 类型：温度超上限预警 SN：2023125067633148 主机：4G冰箱版3148 设备：4G冰箱板3148探头 备注：已持续 18分钟 通知方式：短信通知 通知对象：oZMR-6XVx-O5gsUDOnd45aCeVamM', '2023-03-15 11:57:06')] 2023/03/15 11:57:07.240 [ORM]2023/03/15 11:57:07 -[Queries/default] - [ OK / db.Exec / 35.5ms] - [UPDATE `device` SET `t__dattery` = ?, `t_rssi` = ?, `update_time` = ? WHERE `t_sn` = ?] - `100`, `12`, `2023-03-15 11:57:07.2050374 +0800 CST m=+54.151218201`, `2023125762710435` 2023/03/15 11:57:07.438 [ORM]2023/03/15 11:57:07 -[Queries/default] - [ OK / db.Exec / 21.4ms] - [INSERT INTO warning_sand_202303(`t_pid`, `t_tp`, `t__ntype`, `t__notice`, `t__remark`, `create_time`) VALUES (37 , 3, 0, 'oZMR-6eyBpryepFcaFawH7n6b2ZI', 'WID：0 类型：温度超上限预警 SN：2023125067633148 主机：4G冰箱版3148 设备：4G冰箱板3148探头 备注：已持续 18分钟 通知方式：短信通知 通知对象：oZMR-6eyBpryepFcaFawH7n6b2ZI', '2023-03-15 11:57:07')] 2023/03/15 11:57:07.472 [ORM]2023/03/15 11:57:07 -[Queries/default] - [ OK / db.Exec / 33.4ms] - [INSERT INTO `warning` (`t_pid`, `t_tp`, `t_sn`, `t__d_name`, `t_id`, `t__d_s_name`, `t__remark`, `t__ut`, `t_f_ut`, `t__text`, `t__log`, `t__msid`, `t__state`, `create_time`, `update_time`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)] - `37`, `3`, `2023125067633148`, `4G冰箱版3148`, `1`, `4G冰箱板3148探头`, `当前温度:17.2 (↑-40~↓10),已持续 18分钟 `, `2023-03-15 11:57:05 +0800 CST`, `2023-03-15 11:39:05 +0800 CST`, ``, `执行通知策略 ->[小管理主机测-wj] [微信]持续时间:1081秒, 间隔时间:0秒, 内发送次数:0次, 间隔还剩时间:0秒 ----> oZMR-6XVx-O5gsUDOnd45aCeVamM/bc测试->发送成功！ ----> oZMR-6eyBpryepFcaFawH7n6b2ZI/小管理主机->发送成功！ `, `2625246`, `3`, `2023-03-15 11:57:07.438703 +0800 CST`, `2023-03-15 11:57:07.438703 +0800 CST` 2023/03/15 11:57:12.775 [ORM]2023/03/15 11:57:12 -[Queries/default] - [ OK / db.Query / 28.2ms] - [SELECT T0.`ID`, T0.`t_pid`, T0.`t_name`, T0.`t__notice_wx`, T0.`t__notice_phone`, T0.`t__notice_message`, T0.`t__notice_mailbox`, T0.`t__notice_mechanism`, T0.`t__notice_bind`, T0.`t__state`, T0.`create_time`, T0.`update_time` FROM `company_notice` T0 WHERE T0.`t_pid` = ? ORDER BY T0.`ID` ASC ] - `37` 2023/03/15 11:57:12.815 [ORM]2023/03/15 11:57:12 -[Queries/default] - [ OK / db.Query / 26.9ms] - [SELECT T0.`ID`, T0.`t_mid`, T0.`t_name`, T0.`t_key`, T0.`t_money`, T0.`t__state`, T0.`create_time`, T0.`update_time` FROM `company` T0 WHERE T0.`ID` = ? AND T0.`t__state` = ? LIMIT 1] - `37`, `1` 2023/03/15 11:57:12.904 [ORM]2023/03/15 11:57:12 -[Queries/default] - [ OK / db.QueryRow / 26.8ms] - [SELECT `ID`, `t_uuid`, `t_pid`, `t_pids`, `t_power`, `t_user`, `t_pass`, `t_name`, `t_phone`, `t_mail`, `t_wx`, `t__state`, `create_time`, `update_time` FROM `admin` WHERE `t_uuid` = ? AND `t__state` = ? ] - `dab65906-d03a-427c-8524-7c7a57ab8058`, `1` 2023/03/15 11:57:15.334 [ORM]2023/03/15 11:57:15 -[Queries/default] - [ OK / db.Exec / 18.9ms] - [INSERT INTO z_device_data_2023121587723246 (`t_id`, `t_t`, `t_rh`, `t_site`, `t_time`, `t_sp`) VALUES (1 , 17.5, 59.599998474121094, '', '2023-03-15 11:57:00', 4659)] 2023/03/15 11:57:15.406 [ORM]2023/03/15 11:57:15 -[Queries/default] - [ OK / db.Exec / 31.5ms] - [UPDATE `device` SET `t__dattery` = ?, `t_rssi` = ?, `update_time` = ? WHERE `t_sn` = ?] - `100`, `30`, `2023-03-15 11:57:15.3744718 +0800 CST m=+62.320585601`, `2023121587723246` 2023/03/15 11:57:16.903 [ORM]2023/03/15 11:57:16 -[Queries/default] - [ OK / db.Query / 27.8ms] - [SELECT T0.`ID`, T0.`t_pid`, T0.`t_name`, T0.`t__notice_wx`, T0.`t__notice_phone`, T0.`t__notice_message`, T0.`t__notice_mailbox`, T0.`t__notice_mechanism`, T0.`t__notice_bind`, T0.`t__state`, T0.`create_time`, T0.`update_time` FROM `company_notice` T0 WHERE T0.`t_pid` = ? ORDER BY T0.`ID` ASC ] - `37` 2023/03/15 11:57:16.935 [ORM]2023/03/15 11:57:16 -[Queries/default] - [ OK / db.Exec / 31.7ms] - [INSERT INTO `warning` (`t_pid`, `t_tp`, `t_sn`, `t__d_name`, `t_id`, `t__d_s_name`, `t__remark`, `t__ut`, `t_f_ut`, `t__text`, `t__log`, `t__msid`, `t__state`, `create_time`, `update_time`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)] - `37`, `103`, `2023105182699608`, `小管理主机2号-测试样机`, `0`, `小管理主机2号-测试样机`, `发送温湿度报警信息成功`, `2023-03-15 11:57:10 +0800 CST`, `2023-03-15 11:57:10 +0800 CST`, ``, `执行通知策略 ->[小管理主机测-wj] `, `14230043`, `1`, `2023-03-15 11:57:16.9035034 +0800 CST`, `2023-03-15 11:57:16.9035034 +0800 CST` 2023/03/15 11:57:17.412 [ORM]2023/03/15 11:57:17 -[Queries/default] - [ OK / db.Exec / 32.0ms] - [UPDATE `device` SET `t__dattery` = ?, `t_rssi` = ?, `update_time` = ? WHERE `t_sn` = ?] - `100`, `12`, `2023-03-15 11:57:17.380427 +0800 CST m=+64.326524301`, `2023125762710435` 2023/03/15 11:57:17.451 [ORM]2023/03/15 11:57:17 -[Queries/default] - [ OK / db.Exec / 32.4ms] - [UPDATE `device` SET `t__dattery` = ?, `t_rssi` = ?, `update_time` = ? WHERE `t_sn` = ?] - `100`, `24`, `2023-03-15 11:57:17.419379 +0800 CST m=+64.365476001`, `2023125067633148` 2023/03/15 11:57:17.709 [ORM]2023/03/15 11:57:17 -[Queries/default] - [ OK / db.Exec / 18.7ms] - [INSERT INTO z_device_data_2023122788596641 (`t_id`, `t_t`, `t_rh`, `t_site`, `t_time`, `t_sp`) VALUES (1 , 17.899999618530273, 59.5, '', '2023-03-15 11:57:00', 4577)] 2023/03/15 11:57:17.727 [ORM]2023/03/15 11:57:17 -[Queries/default] - [ OK / db.Exec / 31.6ms] - [UPDATE `device` SET `t__dattery` = ?, `t_rssi` = ?, `update_time` = ? WHERE `t_sn` = ?] - `100`, `31`, `2023-03-15 11:57:17.6963313 +0800 CST m=+64.642426101`, `2023122788596641` 2023/03/15 11:57:17.994 [ORM]2023/03/15 11:57:17 -[Queries/default] - [ OK / db.Exec / 18.1ms] - [INSERT INTO z_device_data_2023105182699608 (`t_id`, `t_t`, `t_rh`, `t_site`, `t_time`, `t_sp`) VALUES (1 , 21, 100, '', '2023-03-15 11:57:10', 4674)] 2023/03/15 11:57:18.862 [ORM]2023/03/15 11:57:18 -[Queries/default] - [ OK / db.Exec / 38.3ms] - [UPDATE `device` SET `t__dattery` = ?, `t_rssi` = ?, `update_time` = ? WHERE `t_sn` = ?] - `100`, `24`, `2023-03-15 11:57:18.8242837 +0800 CST m=+65.770369201`, `2023125067633148` 2023/03/15 11:57:18.894 [ORM]2023/03/15 11:57:18 -[Queries/default] - [ OK / db.Exec / 17.6ms] - [INSERT INTO z_device_data_2023125067633148 (`t_id`, `t_t`, `t_rh`, `t_site`, `t_time`, `t_sp`) VALUES (1 , 17.200000762939453, 63, '', '2023-03-15 11:57:00', 4709)] 2023/03/15 11:57:20.150 [ORM]2023/03/15 11:57:20 -[Queries/default] - [ OK / db.Exec / 32.2ms] - [INSERT INTO `warning` (`t_pid`, `t_tp`, `t_sn`, `t__d_name`, `t_id`, `t__d_s_name`, `t__remark`, `t__ut`, `t_f_ut`, `t__text`, `t__log`, `t__msid`, `t__state`, `create_time`, `update_time`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)] - `0`, `1012`, ``, `微信服务通讯`, `0`, `微信服务通讯`, `微信服务通讯 异常！`, `2023-03-15 11:57:20.1183837 +0800 CST`, ``, ``, `{"errcode":47003,"errmsg":"argument invalid! data.short_thing7.value invali rid: 6411421c-3a74d883-400d89b8"}`, `0`, `3`, `2023-03-15 11:57:20.1183837 +0800 CST`, `2023-03-15 11:57:20.1183837 +0800 CST` 2023/03/15 11:57:21.241 [ORM]2023/03/15 11:57:21 -[Queries/default] - [ OK / db.Exec / 18.5ms] - [INSERT INTO z_device_data_2023123898034225 (`t_id`, `t_t`, `t_rh`, `t_site`, `t_time`, `t_sp`) VALUES (1 , 17.399999618530273, 62, '', '2023-03-15 11:57:00', 4563)] 2023/03/15 11:57:21.290 [ORM]2023/03/15 11:57:21 -[Queries/default] - [ OK / db.Exec / 30.6ms] - [UPDATE `device` SET `t__dattery` = ?, `t_rssi` = ?, `update_time` = ? WHERE `t_sn` = ?] - `100`, `18`, `2023-03-15 11:57:21.2601375 +0800 CST m=+68.206203001`, `2023123898034225` 2023/03/15 11:57:27.533 [ORM]2023/03/15 11:57:27 -[Queries/default] - [ OK / db.Exec / 33.6ms] - [INSERT INTO `warning` (`t_pid`, `t_tp`, `t_sn`, `t__d_name`, `t_id`, `t__d_s_name`, `t__remark`, `t__ut`, `t_f_ut`, `t__text`, `t__log`, `t__msid`, `t__state`, `create_time`, `update_time`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)] - `0`, `1012`, ``, `微信服务通讯`, `0`, `微信服务通讯`, `微信服务通讯 异常！`, `2023-03-15 11:57:27.5000614 +0800 CST`, ``, ``, `{"errcode":47003,"errmsg":"argument invalid! data.short_thing7.value invali rid: 64114224-37aad149-249863f1"}`, `0`, `3`, `2023-03-15 11:57:27.5000614 +0800 CST`, `2023-03-15 11:57:27.5000614 +0800 CST` 2023/03/15 11:57:27.559 [ORM]2023/03/15 11:57:27 -[Queries/default] - [ OK / db.Exec / 30.8ms] - [UPDATE `device` SET `t__dattery` = ?, `t_rssi` = ?, `update_time` = ? WHERE `t_sn` = ?] - `100`, `24`, `2023-03-15 11:57:27.5284454 +0800 CST m=+74.474459501`, `2023125067633148` 2023/03/15 11:57:27.565 [ORM]2023/03/15 11:57:27 -[Queries/default] - [ OK / db.Exec / 32.1ms] - [INSERT INTO `warning` (`t_pid`, `t_tp`, `t_sn`, `t__d_name`, `t_id`, `t__d_s_name`, `t__remark`, `t__ut`, `t_f_ut`, `t__text`, `t__log`, `t__msid`, `t__state`, `create_time`, `update_time`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)] - `37`, `6`, `2023105182699608`, `小管理主机2号-测试样机`, `1`, `办公室测试2-1`, `当前湿度:100 (↑80~↓20),`, `2023-03-15 11:57:10 +0800 CST`, `2023-03-15 11:57:10 +0800 CST`, ``, `执行通知策略 ->[小管理主机测-wj] [微信]持续时间:2秒, 间隔时间:0秒, 内发送次数:0次, 间隔还剩时间:0秒 ----> oZMR-6XVx-O5gsUDOnd45aCeVamM/bc测试---->微信服务发送失败！[{"errcode":47003,"errmsg":"argument invalid! data.short_thing7.value invali rid: 64114218-0f58bc41-658e3294"}]!尝试发送 1 次 ---->微信服务发送失败！[{"errcode":47003,"errmsg":"argument invalid! data.short_thing7.value invali rid: 6411421a-11cbb888-2aaddd12"}]!尝试发送 2 次 ---->微信服务发送失败！[{"errcode":47003,"errmsg":"argument invalid! data.short_thing7.value invali rid: 6411421c-3a74d883-400d89b8"}]!尝试发送 3 次 ----> oZMR-6eyBpryepFcaFawH7n6b2ZI/小管理主机---->微信服务发送失败！[{"errcode":47003,"errmsg":"argument invalid! data.short_thing7.value invali rid: 64114220-54c89746-3242eea3"}]!尝试发送 1 次 ---->微信服务发送失败！[{"errcode":47003,"errmsg":"argument invalid! data.short_thing7.value invali rid: 64114221-0d624cbb-58e87426"}]!尝试发送 2 次 ---->微信服务发送失败！[{"errcode":47003,"errmsg":"argument invalid! data.short_thing7.value invali rid: 64114224-37aad149-249863f1"}]!尝试发送 3 次 `, `14230041`, `3`, `2023-03-15 11:57:27.5336745 +0800 CST`, `2023-03-15 11:57:27.5336745 +0800 CST` 2023/03/15 11:57:27.826 [ORM]2023/03/15 11:57:27 -[Queries/default] - [ OK / db.Exec / 31.3ms] - [UPDATE `device` SET `t__dattery` = ?, `t_rssi` = ?, `update_time` = ? WHERE `t_sn` = ?] - `100`, `12`, `2023-03-15 11:57:27.7949915 +0800 CST m=+74.741003401`, `2023125762710435` 2023/03/15 11:57:34.286 [ORM]2023/03/15 11:57:34 -[Queries/default] - [ OK / db.Exec / 18.8ms] - [INSERT INTO z_device_data_2023125763724116 (`t_id`, `t_t`, `t_rh`, `t_site`, `t_time`, `t_sp`) VALUES (1 , 20.5, 55.79999923706055, '106.7132,26.8291', '2023-03-15 11:55:00', 4710)] 2023/03/15 11:57:34.747 [ORM]2023/03/15 11:57:34 -[Queries/default] - [ OK / db.Exec / 32.3ms] - [UPDATE `device` SET `t__dattery` = ?, `t_rssi` = ?, `update_time` = ? WHERE `t_sn` = ?] - `55`, `29`, `2023-03-15 11:57:34.7147801 +0800 CST m=+81.660735301`, `2023125763724116` 2023/03/15 11:57:38.121 [ORM]2023/03/15 11:57:38 -[Queries/default] - [ OK / db.Exec / 31.4ms] - [UPDATE `device` SET `t__dattery` = ?, `t_rssi` = ?, `update_time` = ? WHERE `t_sn` = ?] - `100`, `13`, `2023-03-15 11:57:38.0902448 +0800 CST m=+85.036172301`, `2023125762710435` 2023/03/15 11:57:38.306 [ORM]2023/03/15 11:57:38 -[Queries/default] - [ OK / db.Exec / 35.7ms] - [UPDATE `device` SET `t__dattery` = ?, `t_rssi` = ?, `update_time` = ? WHERE `t_sn` = ?] - `100`, `24`, `2023-03-15 11:57:38.2709918 +0800 CST m=+85.216917801`, `2023125067633148` 2023/03/15 11:57:41.534 [ORM]2023/03/15 11:57:41 -[Queries/default] - [ OK / db.Exec / 31.2ms] - [UPDATE `device_sensor_parameter` SET `t__msid` = ?, `update_time` = ? WHERE `ID` = ?] - `1678852661`, `2023-03-15 11:57:41.5031759 +0800 CST m=+88.449075401`, `4722` 2023/03/15 11:57:41.803 [ORM]2023/03/15 11:57:41 -[Queries/default] - [ OK / db.Query / 27.8ms] - [SELECT T0.`ID`, T0.`t_sn`, T0.`t_id`, T0.`t_name`, T0.`t__tlower`, T0.`t__tupper`, T0.`t__r_hlower`, T0.`t__r_hupper`, T0.`t_enprel`, T0.`t_tprel`, T0.`t_tpreu`, T0.`t_hprel`, T0.`t_hpreu`, T0.`t_speed`, T0.`t_en`, T0.`t_free`, T0.`t_uuid`, T0.`t__msid`, T0.`t__send_state`, T0.`t__state`, T0.`create_time`, T0.`update_time` FROM `device_sensor_parameter` T0 WHERE T0.`t_sn` = ? AND T0.`t__msid` = ? ORDER BY T0.`ID` DESC ] - `2023125762710435`, `1678852661` 2023/03/15 11:57:41.862 [ORM]2023/03/15 11:57:41 -[Queries/default] - [ OK / db.Exec / 32.8ms] - [UPDATE `device_sensor` SET `t_name` = ?, `update_time` = ? WHERE `ID` = ?] - `4G冰箱冯测试01`, `2023-03-15 11:57:41.8299447 +0800 CST m=+88.775841601`, `185` 2023/03/15 11:57:41.907 [ORM]2023/03/15 11:57:41 -[Queries/default] - [ OK / db.Exec / 31.6ms] - [UPDATE `device_sensor_parameter` SET `t__send_state` = ?, `update_time` = ? WHERE `ID` = ?] - `1`, `2023-03-15 11:57:41.8759731 +0800 CST m=+88.821869601`, `4722` 2023/03/15 11:57:41.947 [ORM]2023/03/15 11:57:41 -[Queries/default] - [ OK / db.Exec / 26.2ms] - [UPDATE `device_sensor` SET `t_name` = ?, `update_time` = ? WHERE `ID` = ?] - `4G冰箱冯测试01`, `2023-03-15 11:57:41.9211761 +0800 CST m=+88.867072201`, `185` 2023/03/15 11:57:41.965 [ORM]2023/03/15 11:57:41 -[Queries/default] - [ OK / db.Exec / 31.8ms] - [INSERT INTO `warning` (`t_pid`, `t_tp`, `t_sn`, `t__d_name`, `t_id`, `t__d_s_name`, `t__remark`, `t__ut`, `t_f_ut`, `t__text`, `t__log`, `t__msid`, `t__state`, `create_time`, `update_time`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)] - `37`, `102`, `2023125762710435`, `4G冰箱冯测试`, `0`, `4G冰箱冯测试`, `修改设备参数`, `2023-03-15 11:57:41.9336275 +0800 CST`, ``, ``, ``, `0`, `1`, `2023-03-15 11:57:41.9336275 +0800 CST`, `2023-03-15 11:57:41.9336275 +0800 CST` 2023/03/15 11:57:41.980 [ORM]2023/03/15 11:57:41 -[Queries/default] - [ OK / db.Exec / 15.3ms] - [UPDATE device_sensor_parameter SET `t__send_state` = 3 WHERE `t_sn` LIKE '%2023125762710435%' AND `t_id` = 1 AND `t__send_state` = '0' AND `t__state` = '2'] 2023/03/15 11:57:45.412 [ORM]2023/03/15 11:57:45 -[Queries/default] - [ OK / db.Exec / 31.5ms] - [UPDATE `device` SET `t__dattery` = ?, `t_rssi` = ?, `update_time` = ? WHERE `t_sn` = ?] - `100`, `13`, `2023-03-15 11:57:45.3810265 +0800 CST m=+92.326894201`, `2023125762710435` 2023/03/15 11:57:48.436 [ORM]2023/03/15 11:57:48 -[Queries/default] - [ OK / db.Exec / 31.1ms] - [UPDATE `device` SET `t__dattery` = ?, `t_rssi` = ?, `update_time` = ? WHERE `t_sn` = ?] - `100`, `13`, `2023-03-15 11:57:48.4056709 +0800 CST m=+95.351513801`, `2023125762710435` 2023/03/15 11:57:48.528 [ORM]2023/03/15 11:57:48 -[Queries/default] - [ OK / db.Exec / 31.4ms] - [UPDATE `device` SET `t__dattery` = ?, `t_rssi` = ?, `update_time` = ? WHERE `t_sn` = ?] - `100`, `24`, `2023-03-15 11:57:48.4974561 +0800 CST m=+95.443298301`, `2023125067633148` 2023/03/15 11:57:52.643 [ORM]2023/03/15 11:57:52 -[Queries/default] - [ OK / db.Query / 27.4ms] - [SELECT T0.`ID`, T0.`t_uuid`, T0.`t_pid`, T0.`t_pids`, T0.`t_power`, T0.`t_user`, T0.`t_pass`, T0.`t_name`, T0.`t_phone`, T0.`t_mail`, T0.`t_wx`, T0.`t__state`, T0.`create_time`, T0.`update_time` FROM `admin` T0 WHERE T0.`t__state` = ? AND T0.`t_pids` LIKE ? ORDER BY T0.`ID` DESC ] - `1`, `%37%` 2023/03/15 11:57:52.671 [ORM]2023/03/15 11:57:52 -[Queries/default] - [ OK / db.QueryRow / 27.0ms] - [SELECT `ID`, `t_uuid`, `t_pid`, `t_pids`, `t_power`, `t_user`, `t_pass`, `t_name`, `t_phone`, `t_mail`, `t_wx`, `t__state`, `create_time`, `update_time` FROM `admin` WHERE `ID` = ? AND `t__state` = ? ] - `31`, `1` 2023/03/15 11:57:52.711 [ORM]2023/03/15 11:57:52 -[Queries/default] - [ OK / db.Query / 27.4ms] - [SELECT T0.`ID`, T0.`t_pid`, T0.`t_name`, T0.`t__notice_wx`, T0.`t__notice_phone`, T0.`t__notice_message`, T0.`t__notice_mailbox`, T0.`t__notice_mechanism`, T0.`t__notice_bind`, T0.`t__state`, T0.`create_time`, T0.`update_time` FROM `company_notice` T0 WHERE T0.`t_pid` = ? ORDER BY T0.`ID` ASC ] - `37` 2023/03/15 11:57:52.745 [ORM]2023/03/15 11:57:52 -[Queries/default] - [ OK / db.Exec / 33.6ms] - [INSERT INTO `warning` (`t_pid`, `t_tp`, `t_sn`, `t__d_name`, `t_id`, `t__d_s_name`, `t__remark`, `t__ut`, `t_f_ut`, `t__text`, `t__log`, `t__msid`, `t__state`, `create_time`, `update_time`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)] - `37`, `101`, `2023105182699608`, `小管理主机2号-测试样机`, `0`, `小管理主机2号-测试样机`, `RTC故障:1`, `2010-08-26 11:57:50 +0800 CST`, `2010-08-26 11:57:50 +0800 CST`, ``, `有绑定公司ID -> [37] 通知 管理员ID列表 -> [31|] 通知-> [31|bzd_ceshi_123] -> bzd_ceshi_123[31]相同报警(30分钟内),跳过该用户通知 执行通知策略 ->[小管理主机测-wj] `, `14270060`, `3`, `2023-03-15 11:57:52.7116354 +0800 CST`, `2023-03-15 11:57:52.7116354 +0800 CST` 2023/03/15 11:57:53.462 [ORM]2023/03/15 11:57:53 -[Queries/default] - [ OK / db.Query / 27.6ms] - [SELECT T0.`ID`, T0.`t_pid`, T0.`t_name`, T0.`t__notice_wx`, T0.`t__notice_phone`, T0.`t__notice_message`, T0.`t__notice_mailbox`, T0.`t__notice_mechanism`, T0.`t__notice_bind`, T0.`t__state`, T0.`create_time`, T0.`update_time` FROM `company_notice` T0 WHERE T0.`t_pid` = ? ORDER BY T0.`ID` ASC ] - `37` 2023/03/15 11:57:53.502 [ORM]2023/03/15 11:57:53 -[Queries/default] - [ OK / db.Exec / 39.2ms] - [INSERT INTO `warning` (`t_pid`, `t_tp`, `t_sn`, `t__d_name`, `t_id`, `t__d_s_name`, `t__remark`, `t__ut`, `t_f_ut`, `t__text`, `t__log`, `t__msid`, `t__state`, `create_time`, `update_time`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)] - `37`, `103`, `2023105182699608`, `小管理主机2号-测试样机`, `0`, `小管理主机2号-测试样机`, `RTC故障:1`, `2010-08-26 11:57:50 +0800 CST`, `2010-08-26 11:57:50 +0800 CST`, ``, `执行通知策略 ->[小管理主机测-wj] `, `14270062`, `1`, `2023-03-15 11:57:53.4627886 +0800 CST`, `2023-03-15 11:57:53.4627886 +0800 CST` 2023/03/15 11:57:58.672 [ORM]2023/03/15 11:57:58 -[Queries/default] - [ OK / db.Exec / 32.5ms] - [UPDATE `device` SET `t__dattery` = ?, `t_rssi` = ?, `update_time` = ? WHERE `t_sn` = ?] - `100`, `10`, `2023-03-15 11:57:58.6400275 +0800 CST m=+105.585786501`, `2023125762710435` 2023/03/15 11:57:59.402 [ORM]2023/03/15 11:57:59 -[Queries/default] - [ OK / db.Exec / 34.7ms] - [UPDATE `device` SET `t__dattery` = ?, `t_rssi` = ?, `update_time` = ? WHERE `t_sn` = ?] - `100`, `24`, `2023-03-15 11:57:59.3678433 +0800 CST m=+106.313596301`, `2023125067633148` 2023/03/15 11:58:06.045 [ORM]2023/03/15 11:58:06 -[Queries/default] - [ OK / db.Exec / 19.9ms] - [INSERT INTO z_device_data_2023105182699608 (`t_id`, `t_t`, `t_rh`, `t_site`, `t_time`, `t_sp`) VALUES (0 , 19.299999237060547, 62.400001525878906, '', '2023-03-15 11:58:00', 4097)] 2023/03/15 11:58:06.148 [ORM]2023/03/15 11:58:06 -[Queries/default] - [ OK / db.Exec / 17.5ms] - [INSERT INTO z_device_data_2023105182699608 (`t_id`, `t_t`, `t_rh`, `t_site`, `t_time`, `t_sp`) VALUES (1 , 20.899999618530273, 100, '', '2023-03-15 11:58:00', 4674)] 2023/03/15 11:58:06.260 [ORM]2023/03/15 11:58:06 -[Queries/default] - [ OK / db.Exec / 21.6ms] - [INSERT INTO z_device_data_2023105182699608 (`t_id`, `t_t`, `t_rh`, `t_site`, `t_time`, `t_sp`) VALUES (28 , 17.899999618530273, 65.9000015258789, '', '2023-03-15 11:58:00', 4061)] 2023/03/15 11:58:06.401 [ORM]2023/03/15 11:58:06 -[Queries/default] - [ OK / db.Query / 31.0ms] - [SELECT T0.`ID`, T0.`t_pid`, T0.`t_name`, T0.`t__notice_wx`, T0.`t__notice_phone`, T0.`t__notice_message`, T0.`t__notice_mailbox`, T0.`t__notice_mechanism`, T0.`t__notice_bind`, T0.`t__state`, T0.`create_time`, T0.`update_time` FROM `company_notice` T0 WHERE T0.`t_pid` = ? ORDER BY T0.`ID` ASC ] - `37` 2023/03/15 11:58:06.440 [ORM]2023/03/15 11:58:06 -[Queries/default] - [ OK / db.Query / 26.4ms] - [SELECT T0.`ID`, T0.`t_mid`, T0.`t_name`, T0.`t_key`, T0.`t_money`, T0.`t__state`, T0.`create_time`, T0.`update_time` FROM `company` T0 WHERE T0.`ID` = ? AND T0.`t__state` = ? LIMIT 1] - `37`, `1` 2023/03/15 11:58:06.520 [ORM]2023/03/15 11:58:06 -[Queries/default] - [ OK / db.QueryRow / 27.2ms] - [SELECT `ID`, `t_uuid`, `t_pid`, `t_pids`, `t_power`, `t_user`, `t_pass`, `t_name`, `t_phone`, `t_mail`, `t_wx`, `t__state`, `create_time`, `update_time` FROM `admin` WHERE `t_uuid` = ? AND `t__state` = ? ] - `dab65906-d03a-427c-8524-7c7a57ab8058`, `1` 2023/03/15 11:58:07.044 [ORM]2023/03/15 11:58:07 -[Queries/default] - [ OK / db.Exec / 18.1ms] - [INSERT INTO warning_sand_202303(`t_pid`, `t_tp`, `t__ntype`, `t__notice`, `t__remark`, `create_time`) VALUES (37 , 3, 0, 'oZMR-6XVx-O5gsUDOnd45aCeVamM', 'WID：0 类型：温度超上限预警 SN：2023125067633148 主机：4G冰箱版3148 设备：4G冰箱板3148探头 备注：已持续 19分钟 通知方式：短信通知 通知对象：oZMR-6XVx-O5gsUDOnd45aCeVamM', '2023-03-15 11:58:07')] 2023/03/15 11:58:07.498 [ORM]2023/03/15 11:58:07 -[Queries/default] - [ OK / db.Exec / 18.1ms] - [INSERT INTO warning_sand_202303(`t_pid`, `t_tp`, `t__ntype`, `t__notice`, `t__remark`, `create_time`) VALUES (37 , 3, 0, 'oZMR-6eyBpryepFcaFawH7n6b2ZI', 'WID：0 类型：温度超上限预警 SN：2023125067633148 主机：4G冰箱版3148 设备：4G冰箱板3148探头 备注：已持续 19分钟 通知方式：短信通知 通知对象：oZMR-6eyBpryepFcaFawH7n6b2ZI', '2023-03-15 11:58:07')] 2023/03/15 11:58:07.529 [ORM]2023/03/15 11:58:07 -[Queries/default] - [ OK / db.Exec / 30.8ms] - [INSERT INTO `warning` (`t_pid`, `t_tp`, `t_sn`, `t__d_name`, `t_id`, `t__d_s_name`, `t__remark`, `t__ut`, `t_f_ut`, `t__text`, `t__log`, `t__msid`, `t__state`, `create_time`, `update_time`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)] - `37`, `3`, `2023125067633148`, `4G冰箱版3148`, `1`, `4G冰箱板3148探头`, `当前温度:17.3 (↑-40~↓10),已持续 19分钟 `, `2023-03-15 11:58:05 +0800 CST`, `2023-03-15 11:39:05 +0800 CST`, ``, `执行通知策略 ->[小管理主机测-wj] [微信]持续时间:1141秒, 间隔时间:0秒, 内发送次数:0次, 间隔还剩时间:0秒 ----> oZMR-6XVx-O5gsUDOnd45aCeVamM/bc测试->发送成功！ ----> oZMR-6eyBpryepFcaFawH7n6b2ZI/小管理主机->发送成功！ `, `2685255`, `3`, `2023-03-15 11:58:07.4989209 +0800 CST`, `2023-03-15 11:58:07.4989209 +0800 CST` 2023/03/15 11:58:07.552 [ORM]2023/03/15 11:58:07 -[Queries/default] - [ OK / db.Query / 27.6ms] - [SELECT T0.`ID`, T0.`t_pid`, T0.`t_name`, T0.`t__notice_wx`, T0.`t__notice_phone`, T0.`t__notice_message`, T0.`t__notice_mailbox`, T0.`t__notice_mechanism`, T0.`t__notice_bind`, T0.`t__state`, T0.`create_time`, T0.`update_time` FROM `company_notice` T0 WHERE T0.`t_pid` = ? ORDER BY T0.`ID` ASC ] - `37` 2023/03/15 11:58:07.596 [ORM]2023/03/15 11:58:07 -[Queries/default] - [ OK / db.Exec / 43.4ms] - [INSERT INTO `warning` (`t_pid`, `t_tp`, `t_sn`, `t__d_name`, `t_id`, `t__d_s_name`, `t__remark`, `t__ut`, `t_f_ut`, `t__text`, `t__log`, `t__msid`, `t__state`, `create_time`, `update_time`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)] - `37`, `103`, `2023105182699608`, `小管理主机2号-测试样机`, `0`, `小管理主机2号-测试样机`, `记录数据[03-15 11:58]上报成功且本地备份成功`, `2023-03-15 11:58:01 +0800 CST`, `2023-03-15 11:58:01 +0800 CST`, ``, `执行通知策略 ->[小管理主机测-wj] `, `14281070`, `1`, `2023-03-15 11:58:07.5526294 +0800 CST`, `2023-03-15 11:58:07.5526294 +0800 CST` 2023/03/15 11:58:08.936 [ORM]2023/03/15 11:58:08 -[Queries/default] - [ OK / db.Exec / 32.1ms] - [UPDATE `device` SET `t__dattery` = ?, `t_rssi` = ?, `update_time` = ? WHERE `t_sn` = ?] - `100`, `10`, `2023-03-15 11:58:08.9046608 +0800 CST m=+115.850335601`, `2023125762710435` 2023/03/15 11:58:08.994 [ORM]2023/03/15 11:58:08 -[Queries/default] - [ OK / db.Exec / 33.3ms] - [UPDATE `device` SET `t__dattery` = ?, `t_rssi` = ?, `update_time` = ? WHERE `t_sn` = ?] - `100`, `24`, `2023-03-15 11:58:08.9609979 +0800 CST m=+115.906672301`, `2023125067633148` 2023/03/15 11:58:12.561 [ORM]2023/03/15 11:58:12 -[Queries/default] - [ OK / db.Query / 27.7ms] - [SELECT T0.`ID`, T0.`t_pid`, T0.`t_name`, T0.`t__notice_wx`, T0.`t__notice_phone`, T0.`t__notice_message`, T0.`t__notice_mailbox`, T0.`t__notice_mechanism`, T0.`t__notice_bind`, T0.`t__state`, T0.`create_time`, T0.`update_time` FROM `company_notice` T0 WHERE T0.`t_pid` = ? ORDER BY T0.`ID` ASC ] - `37` 2023/03/15 11:58:12.601 [ORM]2023/03/15 11:58:12 -[Queries/default] - [ OK / db.Query / 26.6ms] - [SELECT T0.`ID`, T0.`t_mid`, T0.`t_name`, T0.`t_key`, T0.`t_money`, T0.`t__state`, T0.`create_time`, T0.`update_time` FROM `company` T0 WHERE T0.`ID` = ? AND T0.`t__state` = ? LIMIT 1] - `37`, `1` 2023/03/15 11:58:12.682 [ORM]2023/03/15 11:58:12 -[Queries/default] - [ OK / db.QueryRow / 28.8ms] - [SELECT `ID`, `t_uuid`, `t_pid`, `t_pids`, `t_power`, `t_user`, `t_pass`, `t_name`, `t_phone`, `t_mail`, `t_wx`, `t__state`, `create_time`, `update_time` FROM `admin` WHERE `t_uuid` = ? AND `t__state` = ? ] - `dab65906-d03a-427c-8524-7c7a57ab8058`, `1` 2023/03/15 11:58:13.168 [ORM]2023/03/15 11:58:13 -[Queries/default] - [ OK / db.Exec / 22.6ms] - [INSERT INTO warning_sand_202303(`t_pid`, `t_tp`, `t__ntype`, `t__notice`, `t__remark`, `create_time`) VALUES (37 , 8, 0, 'oZMR-6XVx-O5gsUDOnd45aCeVamM', 'WID：0 类型：湿度超上限预警 SN：2023125762710435 主机：4G冰箱冯测试 设备：4G冰箱冯测试01 备注：已持续 2分钟 通知方式：短信通知 通知对象：oZMR-6XVx-O5gsUDOnd45aCeVamM', '2023-03-15 11:58:13')] 2023/03/15 11:58:13.248 [ORM]2023/03/15 11:58:13 -[Queries/default] - [ OK / db.Query / 27.7ms] - [SELECT T0.`ID`, T0.`t_pid`, T0.`t_name`, T0.`t__notice_wx`, T0.`t__notice_phone`, T0.`t__notice_message`, T0.`t__notice_mailbox`, T0.`t__notice_mechanism`, T0.`t__notice_bind`, T0.`t__state`, T0.`create_time`, T0.`update_time` FROM `company_notice` T0 WHERE T0.`t_pid` = ? ORDER BY T0.`ID` ASC ] - `37` 2023/03/15 11:58:13.288 [ORM]2023/03/15 11:58:13 -[Queries/default] - [ OK / db.Query / 27.0ms] - [SELECT T0.`ID`, T0.`t_mid`, T0.`t_name`, T0.`t_key`, T0.`t_money`, T0.`t__state`, T0.`create_time`, T0.`update_time` FROM `company` T0 WHERE T0.`ID` = ? AND T0.`t__state` = ? LIMIT 1] - `37`, `1` 2023/03/15 11:58:13.373 [ORM]2023/03/15 11:58:13 -[Queries/default] - [ OK / db.QueryRow / 30.2ms] - [SELECT `ID`, `t_uuid`, `t_pid`, `t_pids`, `t_power`, `t_user`, `t_pass`, `t_name`, `t_phone`, `t_mail`, `t_wx`, `t__state`, `create_time`, `update_time` FROM `admin` WHERE `t_uuid` = ? AND `t__state` = ? ] - `dab65906-d03a-427c-8524-7c7a57ab8058`, `1` 2023/03/15 11:58:13.687 [ORM]2023/03/15 11:58:13 -[Queries/default] - [ OK / db.Exec / 20.3ms] - [INSERT INTO warning_sand_202303(`t_pid`, `t_tp`, `t__ntype`, `t__notice`, `t__remark`, `create_time`) VALUES (37 , 8, 0, 'oZMR-6eyBpryepFcaFawH7n6b2ZI', 'WID：0 类型：湿度超上限预警 SN：2023125762710435 主机：4G冰箱冯测试 设备：4G冰箱冯测试01 备注：已持续 2分钟 通知方式：短信通知 通知对象：oZMR-6eyBpryepFcaFawH7n6b2ZI', '2023-03-15 11:58:13')] 2023/03/15 11:58:13.727 [ORM]2023/03/15 11:58:13 -[Queries/default] - [ OK / db.Query / 27.0ms] - [SELECT T0.`ID`, T0.`t_mid`, T0.`t_name`, T0.`t_key`, T0.`t_money`, T0.`t__state`, T0.`create_time`, T0.`update_time` FROM `company` T0 WHERE T0.`ID` = ? AND T0.`t__state` = ? LIMIT 1] - `37`, `1` 2023/03/15 11:58:13.815 [ORM]2023/03/15 11:58:13 -[Queries/default] - [ OK / db.QueryRow / 30.1ms] - [SELECT `ID`, `t_uuid`, `t_pid`, `t_pids`, `t_power`, `t_user`, `t_pass`, `t_name`, `t_phone`, `t_mail`, `t_wx`, `t__state`, `create_time`, `update_time` FROM `admin` WHERE `t_uuid` = ? AND `t__state` = ? ] - `7823d0c9-ef68-442a-943f-c3c10fb2be8b`, `1` 2023/03/15 11:58:14.413 [ORM]2023/03/15 11:58:14 -[Queries/default] - [ OK / db.Exec / 18.2ms] - [INSERT INTO warning_sand_202303(`t_pid`, `t_tp`, `t__ntype`, `t__notice`, `t__remark`, `create_time`) VALUES (37 , 8, 0, 'oZMR-6VfvmW0ocvZTIibBdsR7yyI', 'WID：0 类型：湿度超上限预警 SN：2023125762710435 主机：4G冰箱冯测试 设备：4G冰箱冯测试01 备注：已持续 2分钟 通知方式：短信通知 通知对象：oZMR-6VfvmW0ocvZTIibBdsR7yyI', '2023-03-15 11:58:14')] 2023/03/15 11:58:14.453 [ORM]2023/03/15 11:58:14 -[Queries/default] - [ OK / db.Query / 26.7ms] - [SELECT T0.`ID`, T0.`t_mid`, T0.`t_name`, T0.`t_key`, T0.`t_money`, T0.`t__state`, T0.`create_time`, T0.`update_time` FROM `company` T0 WHERE T0.`ID` = ? AND T0.`t__state` = ? LIMIT 1] - `37`, `1` 2023/03/15 11:58:14.533 [ORM]2023/03/15 11:58:14 -[Queries/default] - [ OK / db.QueryRow / 26.7ms] - [SELECT `ID`, `t_uuid`, `t_pid`, `t_pids`, `t_power`, `t_user`, `t_pass`, `t_name`, `t_phone`, `t_mail`, `t_wx`, `t__state`, `create_time`, `update_time` FROM `admin` WHERE `t_uuid` = ? AND `t__state` = ? ] - `dab65906-d03a-427c-8524-7c7a57ab8058`, `1` 2023/03/15 11:58:15.008 [ORM]2023/03/15 11:58:15 -[Queries/default] - [ OK / db.Exec / 18.9ms] - [INSERT INTO warning_sand_202303(`t_pid`, `t_tp`, `t__ntype`, `t__notice`, `t__remark`, `create_time`) VALUES (37 , 8, 0, 'oZMR-6XVx-O5gsUDOnd45aCeVamM', 'WID：0 类型：湿度超上限预警 SN：2023125762710435 主机：4G冰箱冯测试 设备：4G冰箱冯测试01 备注：已持续 2分钟 通知方式：短信通知 通知对象：oZMR-6XVx-O5gsUDOnd45aCeVamM', '2023-03-15 11:58:14')] 2023/03/15 11:58:15.438 [ORM]2023/03/15 11:58:15 -[Queries/default] - [ OK / db.Exec / 19.2ms] - [INSERT INTO warning_sand_202303(`t_pid`, `t_tp`, `t__ntype`, `t__notice`, `t__remark`, `create_time`) VALUES (37 , 8, 0, 'oZMR-6eyBpryepFcaFawH7n6b2ZI', 'WID：0 类型：湿度超上限预警 SN：2023125762710435 主机：4G冰箱冯测试 设备：4G冰箱冯测试01 备注：已持续 2分钟 通知方式：短信通知 通知对象：oZMR-6eyBpryepFcaFawH7n6b2ZI', '2023-03-15 11:58:15')] 2023/03/15 11:58:15.471 [ORM]2023/03/15 11:58:15 -[Queries/default] - [ OK / db.Exec / 33.4ms] - [INSERT INTO `warning` (`t_pid`, `t_tp`, `t_sn`, `t__d_name`, `t_id`, `t__d_s_name`, `t__remark`, `t__ut`, `t_f_ut`, `t__text`, `t__log`, `t__msid`, `t__state`, `create_time`, `update_time`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)] - `37`, `8`, `2023125762710435`, `4G冰箱冯测试`, `1`, `4G冰箱冯测试01`, `当前湿度:50.6 (↑60~↓80),已持续 2分钟 `, `2023-03-15 11:58:12 +0800 CST`, `2023-03-15 11:56:12 +0800 CST`, ``, `执行通知策略 ->[策略1] [微信]持续时间:120秒, 间隔时间:0秒, 内发送次数:0次, 间隔还剩时间:0秒 ----> oZMR-6XVx-O5gsUDOnd45aCeVamM/bc测试->发送成功！ ----> oZMR-6eyBpryepFcaFawH7n6b2ZI/小管理主机->发送成功！ 执行通知策略 ->[冰箱版测试] [微信]持续时间:121秒, 间隔时间:0秒, 内发送次数:0次, 间隔还剩时间:0秒 ----> oZMR-6VfvmW0ocvZTIibBdsR7yyI/冯靖沣->发送成功！ 执行通知策略 ->[小管理主机测-wj] [微信]持续时间:122秒, 间隔时间:0秒, 内发送次数:0次, 间隔还剩时间:0秒 ----> oZMR-6XVx-O5gsUDOnd45aCeVamM/bc测试->发送成功！ ----> oZMR-6eyBpryepFcaFawH7n6b2ZI/小管理主机->发送成功！ `, `2692690`, `3`, `2023-03-15 11:58:15.4381035 +0800 CST`, `2023-03-15 11:58:15.4381035 +0800 CST` 2023/03/15 11:58:17.595 [ORM]2023/03/15 11:58:17 -[Queries/default] - [ OK / db.Query / 27.6ms] - [SELECT T0.`ID`, T0.`t_pid`, T0.`t_name`, T0.`t__notice_wx`, T0.`t__notice_phone`, T0.`t__notice_message`, T0.`t__notice_mailbox`, T0.`t__notice_mechanism`, T0.`t__notice_bind`, T0.`t__state`, T0.`create_time`, T0.`update_time` FROM `company_notice` T0 WHERE T0.`t_pid` = ? ORDER BY T0.`ID` ASC ] - `37` 2023/03/15 11:58:17.629 [ORM]2023/03/15 11:58:17 -[Queries/default] - [ OK / db.Exec / 34.0ms] - [INSERT INTO `warning` (`t_pid`, `t_tp`, `t_sn`, `t__d_name`, `t_id`, `t__d_s_name`, `t__remark`, `t__ut`, `t_f_ut`, `t__text`, `t__log`, `t__msid`, `t__state`, `create_time`, `update_time`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)] - `37`, `103`, `2023105182699608`, `小管理主机2号-测试样机`, `0`, `小管理主机2号-测试样机`, `发送温湿度报警信息成功`, `2023-03-15 11:58:11 +0800 CST`, `2023-03-15 11:58:11 +0800 CST`, ``, `执行通知策略 ->[小管理主机测-wj] `, `14291075`, `1`, `2023-03-15 11:58:17.595551 +0800 CST`, `2023-03-15 11:58:17.595551 +0800 CST` 2023/03/15 11:58:17.744 [ORM]2023/03/15 11:58:17 -[Queries/default] - [ OK / db.Exec / 33.9ms] - [UPDATE `device` SET `t__dattery` = ?, `t_rssi` = ?, `update_time` = ? WHERE `t_sn` = ?] - `100`, `31`, `2023-03-15 11:58:17.7104737 +0800 CST m=+124.656076301`, `2023122788596641` 2023/03/15 11:58:17.746 [ORM]2023/03/15 11:58:17 -[Queries/default] - [ OK / db.Exec / 19.8ms] - [INSERT INTO z_device_data_2023122788596641 (`t_id`, `t_t`, `t_rh`, `t_site`, `t_time`, `t_sp`) VALUES (1 , 17.899999618530273, 59.599998474121094, '', '2023-03-15 11:58:00', 4577)] 2023/03/15 11:58:18.314 [ORM]2023/03/15 11:58:18 -[Queries/default] - [ OK / db.Exec / 18.9ms] - [INSERT INTO z_device_data_2023105182699608 (`t_id`, `t_t`, `t_rh`, `t_site`, `t_time`, `t_sp`) VALUES (1 , 20.600000381469727, 100, '', '2023-03-15 11:58:11', 4674)] 2023/03/15 11:58:18.829 [ORM]2023/03/15 11:58:18 -[Queries/default] - [ OK / db.Exec / 18.6ms] - [INSERT INTO z_device_data_2023125067633148 (`t_id`, `t_t`, `t_rh`, `t_site`, `t_time`, `t_sp`) VALUES (1 , 17.299999237060547, 62.79999923706055, '', '2023-03-15 11:58:00', 4709)] 2023/03/15 11:58:18.881 [ORM]2023/03/15 11:58:18 -[Queries/default] - [ OK / db.Exec / 31.7ms] - [UPDATE `device` SET `t__dattery` = ?, `t_rssi` = ?, `update_time` = ? WHERE `t_sn` = ?] - `100`, `24`, `2023-03-15 11:58:18.8496432 +0800 CST m=+125.795236501`, `2023125067633148` 2023/03/15 11:58:19.074 [ORM]2023/03/15 11:58:19 -[Queries/default] - [ OK / db.Exec / 27.3ms] - [UPDATE `device` SET `t__dattery` = ?, `t_rssi` = ?, `update_time` = ? WHERE `t_sn` = ?] - `100`, `24`, `2023-03-15 11:58:19.0469259 +0800 CST m=+125.992517601`, `2023125067633148` 2023/03/15 11:58:19.356 [ORM]2023/03/15 11:58:19 -[Queries/default] - [ OK / db.Exec / 36.0ms] - [UPDATE `device` SET `t__dattery` = ?, `t_rssi` = ?, `update_time` = ? WHERE `t_sn` = ?] - `100`, `12`, `2023-03-15 11:58:19.3199559 +0800 CST m=+126.265545301`, `2023125762710435` 2023/03/15 11:58:20.952 [ORM]2023/03/15 11:58:20 -[Queries/default] - [ OK / db.Exec / 18.8ms] - [INSERT INTO z_device_data_2023125762710435 (`t_id`, `t_t`, `t_rh`, `t_site`, `t_time`, `t_sp`) VALUES (1 , 21.600000381469727, 50.79999923706055, '', '2023-03-15 11:58:00', 4718)] 2023/03/15 11:58:21.051 [ORM]2023/03/15 11:58:21 -[Queries/default] - [ OK / db.Exec / 31.4ms] - [UPDATE `device` SET `t__dattery` = ?, `t_rssi` = ?, `update_time` = ? WHERE `t_sn` = ?] - `100`, `12`, `2023-03-15 11:58:21.0202558 +0800 CST m=+127.965831301`, `2023125762710435` 2023/03/15 11:58:21.206 [ORM]2023/03/15 11:58:21 -[Queries/default] - [ OK / db.Exec / 33.9ms] - [INSERT INTO `warning` (`t_pid`, `t_tp`, `t_sn`, `t__d_name`, `t_id`, `t__d_s_name`, `t__remark`, `t__ut`, `t_f_ut`, `t__text`, `t__log`, `t__msid`, `t__state`, `create_time`, `update_time`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)] - `0`, `1012`, ``, `微信服务通讯`, `0`, `微信服务通讯`, `微信服务通讯 异常！`, `2023-03-15 11:58:21.1730157 +0800 CST`, ``, ``, `{"errcode":47003,"errmsg":"argument invalid! data.short_thing7.value invali rid: 64114259-57db5558-2bea901c"}`, `0`, `3`, `2023-03-15 11:58:21.1730157 +0800 CST`, `2023-03-15 11:58:21.1730157 +0800 CST` 2023/03/15 11:58:21.251 [ORM]2023/03/15 11:58:21 -[Queries/default] - [ OK / db.Exec / 22.0ms] - [INSERT INTO z_device_data_2023123898034225 (`t_id`, `t_t`, `t_rh`, `t_site`, `t_time`, `t_sp`) VALUES (1 , 17.299999237060547, 62, '', '2023-03-15 11:58:00', 4563)] 2023/03/15 11:58:21.294 [ORM]2023/03/15 11:58:21 -[Queries/default] - [ OK / db.Exec / 33.8ms] - [UPDATE `device` SET `t__dattery` = ?, `t_rssi` = ?, `update_time` = ? WHERE `t_sn` = ?] - `100`, `19`, `2023-03-15 11:58:21.2606837 +0800 CST m=+128.206257201`, `2023123898034225` 2023/03/15 11:58:28.671 [ORM]2023/03/15 11:58:28 -[Queries/default] - [ OK / db.Exec / 34.9ms] - [INSERT INTO `warning` (`t_pid`, `t_tp`, `t_sn`, `t__d_name`, `t_id`, `t__d_s_name`, `t__remark`, `t__ut`, `t_f_ut`, `t__text`, `t__log`, `t__msid`, `t__state`, `create_time`, `update_time`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)] - `0`, `1012`, ``, `微信服务通讯`, `0`, `微信服务通讯`, `微信服务通讯 异常！`, `2023-03-15 11:58:28.6364968 +0800 CST`, ``, ``, `{"errcode":47003,"errmsg":"argument invalid! data.short_thing7.value invali rid: 64114261-4444affc-5c8f75e3"}`, `0`, `3`, `2023-03-15 11:58:28.6364968 +0800 CST`, `2023-03-15 11:58:28.6364968 +0800 CST` 2023/03/15 11:58:28.705 [ORM]2023/03/15 11:58:28 -[Queries/default] - [ OK / db.Exec / 34.4ms] - [INSERT INTO `warning` (`t_pid`, `t_tp`, `t_sn`, `t__d_name`, `t_id`, `t__d_s_name`, `t__remark`, `t__ut`, `t_f_ut`, `t__text`, `t__log`, `t__msid`, `t__state`, `create_time`, `update_time`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)] - `37`, `6`, `2023105182699608`, `小管理主机2号-测试样机`, `1`, `办公室测试2-1`, `当前湿度:100 (↑80~↓20),`, `2023-03-15 11:58:11 +0800 CST`, `2023-03-15 11:58:11 +0800 CST`, ``, `执行通知策略 ->[小管理主机测-wj] [微信]持续时间:2秒, 间隔时间:0秒, 内发送次数:0次, 间隔还剩时间:0秒 ----> oZMR-6XVx-O5gsUDOnd45aCeVamM/bc测试---->微信服务发送失败！[{"errcode":47003,"errmsg":"argument invalid! data.short_thing7.value invali rid: 64114255-3233c9db-592af667"}]!尝试发送 1 次 ---->微信服务发送失败！[{"errcode":47003,"errmsg":"argument invalid! data.short_thing7.value invali rid: 64114257-5e5d5365-60cad5f7"}]!尝试发送 2 次 ---->微信服务发送失败！[{"errcode":47003,"errmsg":"argument invalid! data.short_thing7.value invali rid: 64114259-57db5558-2bea901c"}]!尝试发送 3 次 ----> oZMR-6eyBpryepFcaFawH7n6b2ZI/小管理主机---->微信服务发送失败！[{"errcode":47003,"errmsg":"argument invalid! data.short_thing7.value invali rid: 6411425d-71ca000b-3176fc60"}]!尝试发送 1 次 ---->微信服务发送失败！[{"errcode":47003,"errmsg":"argument invalid! data.short_thing7.value invali rid: 6411425e-12ccf337-0670b013"}]!尝试发送 2 次 ---->微信服务发送失败！[{"errcode":47003,"errmsg":"argument invalid! data.short_thing7.value invali rid: 64114261-4444affc-5c8f75e3"}]!尝试发送 3 次 `, `14291073`, `3`, `2023-03-15 11:58:28.6714073 +0800 CST`, `2023-03-15 11:58:28.6714073 +0800 CST` 2023/03/15 11:58:29.388 [ORM]2023/03/15 11:58:29 -[Queries/default] - [ OK / db.Exec / 31.5ms] - [UPDATE `device` SET `t__dattery` = ?, `t_rssi` = ?, `update_time` = ? WHERE `t_sn` = ?] - `100`, `24`, `2023-03-15 11:58:29.3570673 +0800 CST m=+136.302574401`, `2023125067633148` 2023/03/15 11:58:29.669 [ORM]2023/03/15 11:58:29 -[Queries/default] - [ OK / db.Exec / 34.3ms] - [UPDATE `device` SET `t__dattery` = ?, `t_rssi` = ?, `update_time` = ? WHERE `t_sn` = ?] - `100`, `12`, `2023-03-15 11:58:29.6351518 +0800 CST m=+136.580656701`, `2023125762710435` 2023/03/15 11:58:39.880 [ORM]2023/03/15 11:58:39 -[Queries/default] - [ OK / db.Exec / 38.6ms] - [UPDATE `device` SET `t__dattery` = ?, `t_rssi` = ?, `update_time` = ? WHERE `t_sn` = ?] - `100`, `24`, `2023-03-15 11:58:39.8417487 +0800 CST m=+146.787169901`, `2023125067633148` 2023/03/15 11:58:39.888 [ORM]2023/03/15 11:58:39 -[Queries/default] - [ OK / db.Exec / 30.7ms] - [UPDATE `device` SET `t__dattery` = ?, `t_rssi` = ?, `update_time` = ? WHERE `t_sn` = ?] - `100`, `13`, `2023-03-15 11:58:39.8573438 +0800 CST m=+146.802764801`, `2023125762710435` 2023/03/15 11:58:49.982 [ORM]2023/03/15 11:58:49 -[Queries/default] - [ OK / db.Exec / 35.6ms] - [UPDATE `device` SET `t__dattery` = ?, `t_rssi` = ?, `update_time` = ? WHERE `t_sn` = ?] - `100`, `24`, `2023-03-15 11:58:49.9466671 +0800 CST m=+156.892005401`, `2023125067633148` 2023/03/15 11:58:50.316 [ORM]2023/03/15 11:58:50 -[Queries/default] - [ OK / db.Exec / 35.7ms] - [UPDATE `device` SET `t__dattery` = ?, `t_rssi` = ?, `update_time` = ? WHERE `t_sn` = ?] - `100`, `13`, `2023-03-15 11:58:50.2807774 +0800 CST m=+157.226113001`, `2023125762710435` 2023/03/15 11:58:52.496 [ORM]2023/03/15 11:58:52 -[Queries/default] - [ OK / db.Exec / 31.7ms] - [UPDATE `device` SET `t__dattery` = ?, `t_rssi` = ?, `update_time` = ? WHERE `t_sn` = ?] - `60`, `29`, `2023-03-15 11:58:52.4651539 +0800 CST m=+159.410471501`, `2023125763724116` 2023/03/15 11:59:00.266 [ORM]2023/03/15 11:59:00 -[Queries/default] - [ OK / db.Exec / 36.5ms] - [UPDATE `device` SET `t__dattery` = ?, `t_rssi` = ?, `update_time` = ? WHERE `t_sn` = ?] - `100`, `24`, `2023-03-15 11:59:00.2301162 +0800 CST m=+167.175370201`, `2023125067633148` 2023/03/15 11:59:00.574 [ORM]2023/03/15 11:59:00 -[Queries/default] - [ OK / db.Exec / 38.4ms] - [UPDATE `device` SET `t__dattery` = ?, `t_rssi` = ?, `update_time` = ? WHERE `t_sn` = ?] - `100`, `13`, `2023-03-15 11:59:00.5360074 +0800 CST m=+167.481258901`, `2023125762710435` 2023/03/15 11:59:06.424 [ORM]2023/03/15 11:59:06 -[Queries/default] - [ OK / db.Query / 28.1ms] - [SELECT T0.`ID`, T0.`t_pid`, T0.`t_name`, T0.`t__notice_wx`, T0.`t__notice_phone`, T0.`t__notice_message`, T0.`t__notice_mailbox`, T0.`t__notice_mechanism`, T0.`t__notice_bind`, T0.`t__state`, T0.`create_time`, T0.`update_time` FROM `company_notice` T0 WHERE T0.`t_pid` = ? ORDER BY T0.`ID` ASC ] - `37` 2023/03/15 11:59:06.464 [ORM]2023/03/15 11:59:06 -[Queries/default] - [ OK / db.Query / 26.7ms] - [SELECT T0.`ID`, T0.`t_mid`, T0.`t_name`, T0.`t_key`, T0.`t_money`, T0.`t__state`, T0.`create_time`, T0.`update_time` FROM `company` T0 WHERE T0.`ID` = ? AND T0.`t__state` = ? LIMIT 1] - `37`, `1` 2023/03/15 11:59:06.543 [ORM]2023/03/15 11:59:06 -[Queries/default] - [ OK / db.QueryRow / 26.8ms] - [SELECT `ID`, `t_uuid`, `t_pid`, `t_pids`, `t_power`, `t_user`, `t_pass`, `t_name`, `t_phone`, `t_mail`, `t_wx`, `t__state`, `create_time`, `update_time` FROM `admin` WHERE `t_uuid` = ? AND `t__state` = ? ] - `dab65906-d03a-427c-8524-7c7a57ab8058`, `1` 2023/03/15 11:59:07.004 [ORM]2023/03/15 11:59:07 -[Queries/default] - [ OK / db.Exec / 20.2ms] - [INSERT INTO warning_sand_202303(`t_pid`, `t_tp`, `t__ntype`, `t__notice`, `t__remark`, `create_time`) VALUES (37 , 3, 0, 'oZMR-6XVx-O5gsUDOnd45aCeVamM', 'WID：0 类型：温度超上限预警 SN：2023125067633148 主机：4G冰箱版3148 设备：4G冰箱板3148探头 备注：已持续 20分钟 通知方式：短信通知 通知对象：oZMR-6XVx-O5gsUDOnd45aCeVamM', '2023-03-15 11:59:06')] 2023/03/15 11:59:07.324 [ORM]2023/03/15 11:59:07 -[Queries/default] - [ OK / db.Exec / 18.3ms] - [INSERT INTO warning_sand_202303(`t_pid`, `t_tp`, `t__ntype`, `t__notice`, `t__remark`, `create_time`) VALUES (37 , 3, 0, 'oZMR-6eyBpryepFcaFawH7n6b2ZI', 'WID：0 类型：温度超上限预警 SN：2023125067633148 主机：4G冰箱版3148 设备：4G冰箱板3148探头 备注：已持续 20分钟 通知方式：短信通知 通知对象：oZMR-6eyBpryepFcaFawH7n6b2ZI', '2023-03-15 11:59:07')] 2023/03/15 11:59:07.356 [ORM]2023/03/15 11:59:07 -[Queries/default] - [ OK / db.Exec / 31.9ms] - [INSERT INTO `warning` (`t_pid`, `t_tp`, `t_sn`, `t__d_name`, `t_id`, `t__d_s_name`, `t__remark`, `t__ut`, `t_f_ut`, `t__text`, `t__log`, `t__msid`, `t__state`, `create_time`, `update_time`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)] - `37`, `3`, `2023125067633148`, `4G冰箱版3148`, `1`, `4G冰箱板3148探头`, `当前温度:17.2 (↑-40~↓10),已持续 20分钟 `, `2023-03-15 11:59:05 +0800 CST`, `2023-03-15 11:39:05 +0800 CST`, ``, `执行通知策略 ->[小管理主机测-wj] [微信]持续时间:1201秒, 间隔时间:0秒, 内发送次数:0次, 间隔还剩时间:0秒 ----> oZMR-6XVx-O5gsUDOnd45aCeVamM/bc测试->发送成功！ ----> oZMR-6eyBpryepFcaFawH7n6b2ZI/小管理主机->发送成功！ `, `2745264`, `3`, `2023-03-15 11:59:07.3247949 +0800 CST`, `2023-03-15 11:59:07.3247949 +0800 CST` 2023/03/15 11:59:10.797 [ORM]2023/03/15 11:59:10 -[Queries/default] - [ OK / db.Exec / 32.8ms] - [UPDATE `device` SET `t__dattery` = ?, `t_rssi` = ?, `update_time` = ? WHERE `t_sn` = ?] - `100`, `13`, `2023-03-15 11:59:10.7645816 +0800 CST m=+177.709749201`, `2023125762710435` 2023/03/15 11:59:10.807 [ORM]2023/03/15 11:59:10 -[Queries/default] - [ OK / db.Exec / 30.7ms] - [UPDATE `device` SET `t__dattery` = ?, `t_rssi` = ?, `update_time` = ? WHERE `t_sn` = ?] - `100`, `24`, `2023-03-15 11:59:10.776983 +0800 CST m=+177.722150501`, `2023125067633148` 2023/03/15 11:59:12.113 [ORM]2023/03/15 11:59:12 -[Queries/default] - [ OK / db.Query / 32.0ms] - [SELECT T0.`ID`, T0.`t_pid`, T0.`t_name`, T0.`t__notice_wx`, T0.`t__notice_phone`, T0.`t__notice_message`, T0.`t__notice_mailbox`, T0.`t__notice_mechanism`, T0.`t__notice_bind`, T0.`t__state`, T0.`create_time`, T0.`update_time` FROM `company_notice` T0 WHERE T0.`t_pid` = ? ORDER BY T0.`ID` ASC ] - `37` 2023/03/15 11:59:12.156 [ORM]2023/03/15 11:59:12 -[Queries/default] - [ OK / db.Query / 28.9ms] - [SELECT T0.`ID`, T0.`t_mid`, T0.`t_name`, T0.`t_key`, T0.`t_money`, T0.`t__state`, T0.`create_time`, T0.`update_time` FROM `company` T0 WHERE T0.`ID` = ? AND T0.`t__state` = ? LIMIT 1] - `37`, `1` 2023/03/15 11:59:12.235 [ORM]2023/03/15 11:59:12 -[Queries/default] - [ OK / db.QueryRow / 26.9ms] - [SELECT `ID`, `t_uuid`, `t_pid`, `t_pids`, `t_power`, `t_user`, `t_pass`, `t_name`, `t_phone`, `t_mail`, `t_wx`, `t__state`, `create_time`, `update_time` FROM `admin` WHERE `t_uuid` = ? AND `t__state` = ? ] - `dab65906-d03a-427c-8524-7c7a57ab8058`, `1` 2023/03/15 11:59:12.678 [ORM]2023/03/15 11:59:12 -[Queries/default] - [ OK / db.Exec / 22.5ms] - [INSERT INTO warning_sand_202303(`t_pid`, `t_tp`, `t__ntype`, `t__notice`, `t__remark`, `create_time`) VALUES (37 , 10, 0, 'oZMR-6XVx-O5gsUDOnd45aCeVamM', 'WID：0 类型：湿度恢复正常 SN：2023105182699608 主机：小管理主机2号-测试样机 设备：办公室测试2-1 备注：已持续 58秒 通知方式：短信通知 通知对象：oZMR-6XVx-O5gsUDOnd45aCeVamM', '2023-03-15 11:59:12')] 2023/03/15 11:59:13.138 [ORM]2023/03/15 11:59:13 -[Queries/default] - [ OK / db.Exec / 17.6ms] - [INSERT INTO warning_sand_202303(`t_pid`, `t_tp`, `t__ntype`, `t__notice`, `t__remark`, `create_time`) VALUES (37 , 10, 0, 'oZMR-6eyBpryepFcaFawH7n6b2ZI', 'WID：0 类型：湿度恢复正常 SN：2023105182699608 主机：小管理主机2号-测试样机 设备：办公室测试2-1 备注：已持续 58秒 通知方式：短信通知 通知对象：oZMR-6eyBpryepFcaFawH7n6b2ZI', '2023-03-15 11:59:13')] 2023/03/15 11:59:13.172 [ORM]2023/03/15 11:59:13 -[Queries/default] - [ OK / db.Exec / 33.8ms] - [INSERT INTO `warning` (`t_pid`, `t_tp`, `t_sn`, `t__d_name`, `t_id`, `t__d_s_name`, `t__remark`, `t__ut`, `t_f_ut`, `t__text`, `t__log`, `t__msid`, `t__state`, `create_time`, `update_time`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)] - `37`, `10`, `2023105182699608`, `小管理主机2号-测试样机`, `1`, `办公室测试2-1`, `当前湿度:80.1 (↑80~↓20),已持续 58秒`, `2023-03-15 11:59:09 +0800 CST`, `2023-03-15 11:58:11 +0800 CST`, ``, `执行通知策略 ->[小管理主机测-wj] [微信]持续时间:61秒, 间隔时间:0秒, 内发送次数:0次, 间隔还剩时间:0秒 ----> oZMR-6XVx-O5gsUDOnd45aCeVamM/bc测试->发送成功！ ----> oZMR-6eyBpryepFcaFawH7n6b2ZI/小管理主机->发送成功！ `, `14349099`, `3`, `2023-03-15 11:59:13.1387858 +0800 CST`, `2023-03-15 11:59:13.1387858 +0800 CST` 2023/03/15 11:59:14.453 [ORM]2023/03/15 11:59:14 -[Queries/default] - [ OK / db.Query / 27.6ms] - [SELECT T0.`ID`, T0.`t_pid`, T0.`t_name`, T0.`t__notice_wx`, T0.`t__notice_phone`, T0.`t__notice_message`, T0.`t__notice_mailbox`, T0.`t__notice_mechanism`, T0.`t__notice_bind`, T0.`t__state`, T0.`create_time`, T0.`update_time` FROM `company_notice` T0 WHERE T0.`t_pid` = ? ORDER BY T0.`ID` ASC ] - `37` 2023/03/15 11:59:14.487 [ORM]2023/03/15 11:59:14 -[Queries/default] - [ OK / db.Exec / 33.5ms] - [INSERT INTO `warning` (`t_pid`, `t_tp`, `t_sn`, `t__d_name`, `t_id`, `t__d_s_name`, `t__remark`, `t__ut`, `t_f_ut`, `t__text`, `t__log`, `t__msid`, `t__state`, `create_time`, `update_time`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)] - `37`, `103`, `2023105182699608`, `小管理主机2号-测试样机`, `0`, `小管理主机2号-测试样机`, `发送温湿度报警信息成功`, `2023-03-15 11:59:09 +0800 CST`, `2023-03-15 11:59:09 +0800 CST`, ``, `执行通知策略 ->[小管理主机测-wj] `, `14349101`, `1`, `2023-03-15 11:59:14.4538154 +0800 CST`, `2023-03-15 11:59:14.4538154 +0800 CST` 2023/03/15 11:59:15.184 [ORM]2023/03/15 11:59:15 -[Queries/default] - [ OK / db.Exec / 20.5ms] - [INSERT INTO z_device_data_2023105182699608 (`t_id`, `t_t`, `t_rh`, `t_site`, `t_time`, `t_sp`) VALUES (1 , 18.899999618530273, 80.0999984741211, '', '2023-03-15 11:59:09', 4674)] 2023/03/15 11:59:15.447 [ORM]2023/03/15 11:59:15 -[Queries/default] - [ OK / db.Exec / 17.8ms] - [INSERT INTO z_device_data_2023121587723246 (`t_id`, `t_t`, `t_rh`, `t_site`, `t_time`, `t_sp`) VALUES (1 , 17.5, 59.599998474121094, '', '2023-03-15 11:59:00', 4659)] 2023/03/15 11:59:15.539 [ORM]2023/03/15 11:59:15 -[Queries/default] - [ OK / db.Exec / 34.5ms] - [UPDATE `device` SET `t__dattery` = ?, `t_rssi` = ?, `update_time` = ? WHERE `t_sn` = ?] - `100`, `30`, `2023-03-15 11:59:15.5052592 +0800 CST m=+182.450387901`, `2023121587723246` 2023/03/15 11:59:16.629 [ORM]2023/03/15 11:59:16 -[Queries/default] - [ OK / db.Query / 28.3ms] - [SELECT T0.`ID`, T0.`t_pid`, T0.`t_name`, T0.`t__notice_wx`, T0.`t__notice_phone`, T0.`t__notice_message`, T0.`t__notice_mailbox`, T0.`t__notice_mechanism`, T0.`t__notice_bind`, T0.`t__state`, T0.`create_time`, T0.`update_time` FROM `company_notice` T0 WHERE T0.`t_pid` = ? ORDER BY T0.`ID` ASC ] - `37` 2023/03/15 11:59:16.672 [ORM]2023/03/15 11:59:16 -[Queries/default] - [ OK / db.Query / 28.0ms] - [SELECT T0.`ID`, T0.`t_mid`, T0.`t_name`, T0.`t_key`, T0.`t_money`, T0.`t__state`, T0.`create_time`, T0.`update_time` FROM `company` T0 WHERE T0.`ID` = ? AND T0.`t__state` = ? LIMIT 1] - `37`, `1` 2023/03/15 11:59:16.753 [ORM]2023/03/15 11:59:16 -[Queries/default] - [ OK / db.QueryRow / 28.3ms] - [SELECT `ID`, `t_uuid`, `t_pid`, `t_pids`, `t_power`, `t_user`, `t_pass`, `t_name`, `t_phone`, `t_mail`, `t_wx`, `t__state`, `create_time`, `update_time` FROM `admin` WHERE `t_uuid` = ? AND `t__state` = ? ] - `dab65906-d03a-427c-8524-7c7a57ab8058`, `1` 2023/03/15 11:59:17.262 [ORM]2023/03/15 11:59:17 -[Queries/default] - [ OK / db.Exec / 18.8ms] - [INSERT INTO warning_sand_202303(`t_pid`, `t_tp`, `t__ntype`, `t__notice`, `t__remark`, `create_time`) VALUES (37 , 8, 0, 'oZMR-6XVx-O5gsUDOnd45aCeVamM', 'WID：0 类型：湿度超上限预警 SN：2023105182699608 主机：小管理主机2号-测试样机 设备：办公室测试2-1 备注：已持续 1分钟 3秒 通知方式：短信通知 通知对象：oZMR-6XVx-O5gsUDOnd45aCeVamM', '2023-03-15 11:59:17')] 2023/03/15 11:59:17.738 [ORM]2023/03/15 11:59:17 -[Queries/default] - [ OK / db.Exec / 18.5ms] - [INSERT INTO z_device_data_2023122788596641 (`t_id`, `t_t`, `t_rh`, `t_site`, `t_time`, `t_sp`) VALUES (1 , 17.899999618530273, 59.5, '', '2023-03-15 11:59:00', 4577)] 2023/03/15 11:59:17.745 [ORM]2023/03/15 11:59:17 -[Queries/default] - [ OK / db.Exec / 17.7ms] - [INSERT INTO warning_sand_202303(`t_pid`, `t_tp`, `t__ntype`, `t__notice`, `t__remark`, `create_time`) VALUES (37 , 8, 0, 'oZMR-6eyBpryepFcaFawH7n6b2ZI', 'WID：0 类型：湿度超上限预警 SN：2023105182699608 主机：小管理主机2号-测试样机 设备：办公室测试2-1 备注：已持续 1分钟 3秒 通知方式：短信通知 通知对象：oZMR-6eyBpryepFcaFawH7n6b2ZI', '2023-03-15 11:59:17')] 2023/03/15 11:59:17.757 [ORM]2023/03/15 11:59:17 -[Queries/default] - [ OK / db.Exec / 30.8ms] - [UPDATE `device` SET `t__dattery` = ?, `t_rssi` = ?, `update_time` = ? WHERE `t_sn` = ?] - `100`, `31`, `2023-03-15 11:59:17.7264059 +0800 CST m=+184.671516401`, `2023122788596641` 2023/03/15 11:59:17.776 [ORM]2023/03/15 11:59:17 -[Queries/default] - [ OK / db.Exec / 30.9ms] - [INSERT INTO `warning` (`t_pid`, `t_tp`, `t_sn`, `t__d_name`, `t_id`, `t__d_s_name`, `t__remark`, `t__ut`, `t_f_ut`, `t__text`, `t__log`, `t__msid`, `t__state`, `create_time`, `update_time`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)] - `37`, `8`, `2023105182699608`, `小管理主机2号-测试样机`, `1`, `办公室测试2-1`, `当前湿度:80.1 (↑30~↓70),已持续 1分钟 3秒`, `2023-03-15 11:59:14 +0800 CST`, `2023-03-15 11:58:11 +0800 CST`, ``, `执行通知策略 ->[小管理主机测-wj] [微信]持续时间:65秒, 间隔时间:0秒, 内发送次数:0次, 间隔还剩时间:0秒 ----> oZMR-6XVx-O5gsUDOnd45aCeVamM/bc测试->发送成功！ ----> oZMR-6eyBpryepFcaFawH7n6b2ZI/小管理主机->发送成功！ `, `14354103`, `3`, `2023-03-15 11:59:17.7456178 +0800 CST`, `2023-03-15 11:59:17.7456178 +0800 CST` 2023/03/15 11:59:18.829 [ORM]2023/03/15 11:59:18 -[Queries/default] - [ OK / db.Exec / 18.9ms] - [INSERT INTO z_device_data_2023125067633148 (`t_id`, `t_t`, `t_rh`, `t_site`, `t_time`, `t_sp`) VALUES (1 , 17.200000762939453, 62.79999923706055, '', '2023-03-15 11:59:00', 4709)] 2023/03/15 11:59:18.879 [ORM]2023/03/15 11:59:18 -[Queries/default] - [ OK / db.Exec / 32.8ms] - [UPDATE `device` SET `t__dattery` = ?, `t_rssi` = ?, `update_time` = ? WHERE `t_sn` = ?] - `100`, `24`, `2023-03-15 11:59:18.8470599 +0800 CST m=+185.792161201`, `2023125067633148` 2023/03/15 11:59:19.025 [ORM]2023/03/15 11:59:19 -[Queries/default] - [ OK / db.Query / 27.6ms] - [SELECT T0.`ID`, T0.`t_pid`, T0.`t_name`, T0.`t__notice_wx`, T0.`t__notice_phone`, T0.`t__notice_message`, T0.`t__notice_mailbox`, T0.`t__notice_mechanism`, T0.`t__notice_bind`, T0.`t__state`, T0.`create_time`, T0.`update_time` FROM `company_notice` T0 WHERE T0.`t_pid` = ? ORDER BY T0.`ID` ASC ] - `37` 2023/03/15 11:59:19.062 [ORM]2023/03/15 11:59:19 -[Queries/default] - [ OK / db.Exec / 37.3ms] - [INSERT INTO `warning` (`t_pid`, `t_tp`, `t_sn`, `t__d_name`, `t_id`, `t__d_s_name`, `t__remark`, `t__ut`, `t_f_ut`, `t__text`, `t__log`, `t__msid`, `t__state`, `create_time`, `update_time`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)] - `37`, `103`, `2023105182699608`, `小管理主机2号-测试样机`, `0`, `小管理主机2号-测试样机`, `发送温湿度报警信息成功`, `2023-03-15 11:59:14 +0800 CST`, `2023-03-15 11:59:14 +0800 CST`, ``, `执行通知策略 ->[小管理主机测-wj] `, `14354105`, `1`, `2023-03-15 11:59:19.0252007 +0800 CST`, `2023-03-15 11:59:19.0252007 +0800 CST` 2023/03/15 11:59:19.758 [ORM]2023/03/15 11:59:19 -[Queries/default] - [ OK / db.Exec / 19.9ms] - [INSERT INTO z_device_data_2023105182699608 (`t_id`, `t_t`, `t_rh`, `t_site`, `t_time`, `t_sp`) VALUES (1 , 18.899999618530273, 80.0999984741211, '', '2023-03-15 11:59:14', 4674)] 2023/03/15 11:59:20.949 [ORM]2023/03/15 11:59:20 -[Queries/default] - [ OK / db.Exec / 31.4ms] - [UPDATE `device` SET `t__dattery` = ?, `t_rssi` = ?, `update_time` = ? WHERE `t_sn` = ?] - `100`, `24`, `2023-03-15 11:59:20.9177298 +0800 CST m=+187.862814101`, `2023125067633148` 2023/03/15 11:59:20.995 [ORM]2023/03/15 11:59:20 -[Queries/default] - [ OK / db.Exec / 30.7ms] - [UPDATE `device` SET `t__dattery` = ?, `t_rssi` = ?, `update_time` = ? WHERE `t_sn` = ?] - `100`, `10`, `2023-03-15 11:59:20.9646037 +0800 CST m=+187.909687701`, `2023125762710435` 2023/03/15 11:59:21.401 [ORM]2023/03/15 11:59:21 -[Queries/default] - [ OK / db.Exec / 18.4ms] - [INSERT INTO z_device_data_2023123898034225 (`t_id`, `t_t`, `t_rh`, `t_site`, `t_time`, `t_sp`) VALUES (1 , 17.299999237060547, 62, '', '2023-03-15 11:59:00', 4563)] 2023/03/15 11:59:21.445 [ORM]2023/03/15 11:59:21 -[Queries/default] - [ OK / db.Exec / 36.3ms] - [UPDATE `device` SET `t__dattery` = ?, `t_rssi` = ?, `update_time` = ? WHERE `t_sn` = ?] - `100`, `20`, `2023-03-15 11:59:21.4095645 +0800 CST m=+188.354644801`, `2023123898034225` 2023/03/15 11:59:31.308 [ORM]2023/03/15 11:59:31 -[Queries/default] - [ OK / db.Exec / 31.7ms] - [UPDATE `device` SET `t__dattery` = ?, `t_rssi` = ?, `update_time` = ? WHERE `t_sn` = ?] - `100`, `24`, `2023-03-15 11:59:31.2769898 +0800 CST m=+198.221989201`, `2023125067633148` 2023/03/15 11:59:31.339 [ORM]2023/03/15 11:59:31 -[Queries/default] - [ OK / db.Exec / 30.5ms] - [UPDATE `device` SET `t__dattery` = ?, `t_rssi` = ?, `update_time` = ? WHERE `t_sn` = ?] - `100`, `10`, `2023-03-15 11:59:31.3093681 +0800 CST m=+198.254367201`, `2023125762710435` 2023/03/15 11:59:34.694 [ORM]2023/03/15 11:59:34 -[Queries/default] - [ OK / db.Exec / 29.2ms] - [INSERT INTO z_device_data_2023125763724116 (`t_id`, `t_t`, `t_rh`, `t_site`, `t_time`, `t_sp`) VALUES (1 , 20.299999237060547, 55.29999923706055, '106.7132,26.8291', '2023-03-15 11:57:00', 4710)] 2023/03/15 11:59:35.161 [ORM]2023/03/15 11:59:35 -[Queries/default] - [ OK / db.Exec / 32.5ms] - [UPDATE `device` SET `t__dattery` = ?, `t_rssi` = ?, `update_time` = ? WHERE `t_sn` = ?] - `60`, `29`, `2023-03-15 11:59:35.1294507 +0800 CST m=+202.074418501`, `2023125763724116` 2023/03/15 11:59:41.671 [ORM]2023/03/15 11:59:41 -[Queries/default] - [ OK / db.Exec / 34.3ms] - [UPDATE `device` SET `t__dattery` = ?, `t_rssi` = ?, `update_time` = ? WHERE `t_sn` = ?] - `100`, `24`, `2023-03-15 11:59:41.6370876 +0800 CST m=+208.582002001`, `2023125067633148` 2023/03/15 11:59:41.872 [ORM]2023/03/15 11:59:41 -[Queries/default] - [ OK / db.Exec / 34.3ms] - [UPDATE `device` SET `t__dattery` = ?, `t_rssi` = ?, `update_time` = ? WHERE `t_sn` = ?] - `100`, `10`, `2023-03-15 11:59:41.8378684 +0800 CST m=+208.782781201`, `2023125762710435` 2023/03/15 11:59:51.797 [ORM]2023/03/15 11:59:51 -[Queries/default] - [ OK / db.Exec / 40.5ms] - [UPDATE `device` SET `t__dattery` = ?, `t_rssi` = ?, `update_time` = ? WHERE `t_sn` = ?] - `100`, `24`, `2023-03-15 11:59:51.7566934 +0800 CST m=+218.701524901`, `2023125067633148` 2023/03/15 11:59:52.182 [ORM]2023/03/15 11:59:52 -[Queries/default] - [ OK / db.Exec / 32.5ms] - [UPDATE `device` SET `t__dattery` = ?, `t_rssi` = ?, `update_time` = ? WHERE `t_sn` = ?] - `100`, `10`, `2023-03-15 11:59:52.1499442 +0800 CST m=+219.094772401`, `2023125762710435` 2023/03/15 12:00:02.076 [ORM]2023/03/15 12:00:02 -[Queries/default] - [ OK / db.Exec / 37.1ms] - [UPDATE `device` SET `t__dattery` = ?, `t_rssi` = ?, `update_time` = ? WHERE `t_sn` = ?] - `100`, `24`, `2023-03-15 12:00:02.0393277 +0800 CST m=+228.984074801`, `2023125067633148` 2023/03/15 12:00:03.565 [ORM]2023/03/15 12:00:03 -[Queries/default] - [ OK / db.Exec / 36.0ms] - [UPDATE `device` SET `t__dattery` = ?, `t_rssi` = ?, `update_time` = ? WHERE `t_sn` = ?] - `100`, `21`, `2023-03-15 12:00:03.5294341 +0800 CST m=+230.474169001`, `2023125762710435` 2023/03/15 12:00:06.131 [ORM]2023/03/15 12:00:06 -[Queries/default] - [ OK / db.Exec / 18.1ms] - [INSERT INTO z_device_data_2023105182699608 (`t_id`, `t_t`, `t_rh`, `t_site`, `t_time`, `t_sp`) VALUES (0 , 19.299999237060547, 62.79999923706055, '', '2023-03-15 12:00:00', 4097)] 2023/03/15 12:00:06.246 [ORM]2023/03/15 12:00:06 -[Queries/default] - [ OK / db.Exec / 35.7ms] - [INSERT INTO z_device_data_2023105182699608 (`t_id`, `t_t`, `t_rh`, `t_site`, `t_time`, `t_sp`) VALUES (1 , 18.799999237060547, 71.80000305175781, '', '2023-03-15 12:00:00', 4674)] 2023/03/15 12:00:06.355 [ORM]2023/03/15 12:00:06 -[Queries/default] - [ OK / db.Exec / 17.8ms] - [INSERT INTO z_device_data_2023105182699608 (`t_id`, `t_t`, `t_rh`, `t_site`, `t_time`, `t_sp`) VALUES (28 , 17.899999618530273, 66.0999984741211, '', '2023-03-15 12:00:00', 4061)] 2023/03/15 12:00:06.415 [ORM]2023/03/15 12:00:06 -[Queries/default] - [ OK / db.Query / 27.6ms] - [SELECT T0.`ID`, T0.`t_pid`, T0.`t_name`, T0.`t__notice_wx`, T0.`t__notice_phone`, T0.`t__notice_message`, T0.`t__notice_mailbox`, T0.`t__notice_mechanism`, T0.`t__notice_bind`, T0.`t__state`, T0.`create_time`, T0.`update_time` FROM `company_notice` T0 WHERE T0.`t_pid` = ? ORDER BY T0.`ID` ASC ] - `37` 2023/03/15 12:00:06.455 [ORM]2023/03/15 12:00:06 -[Queries/default] - [ OK / db.Query / 26.7ms] - [SELECT T0.`ID`, T0.`t_mid`, T0.`t_name`, T0.`t_key`, T0.`t_money`, T0.`t__state`, T0.`create_time`, T0.`update_time` FROM `company` T0 WHERE T0.`ID` = ? AND T0.`t__state` = ? LIMIT 1] - `37`, `1` 2023/03/15 12:00:06.535 [ORM]2023/03/15 12:00:06 -[Queries/default] - [ OK / db.QueryRow / 26.7ms] - [SELECT `ID`, `t_uuid`, `t_pid`, `t_pids`, `t_power`, `t_user`, `t_pass`, `t_name`, `t_phone`, `t_mail`, `t_wx`, `t__state`, `create_time`, `update_time` FROM `admin` WHERE `t_uuid` = ? AND `t__state` = ? ] - `dab65906-d03a-427c-8524-7c7a57ab8058`, `1` 2023/03/15 12:00:07.030 [ORM]2023/03/15 12:00:07 -[Queries/default] - [ OK / db.Exec / 18.1ms] - [INSERT INTO warning_sand_202303(`t_pid`, `t_tp`, `t__ntype`, `t__notice`, `t__remark`, `create_time`) VALUES (37 , 3, 0, 'oZMR-6XVx-O5gsUDOnd45aCeVamM', 'WID：0 类型：温度超上限预警 SN：2023125067633148 主机：4G冰箱版3148 设备：4G冰箱板3148探头 备注：已持续 21分钟 通知方式：短信通知 通知对象：oZMR-6XVx-O5gsUDOnd45aCeVamM', '2023-03-15 12:00:07')] 2023/03/15 12:00:07.458 [ORM]2023/03/15 12:00:07 -[Queries/default] - [ OK / db.Exec / 18.5ms] - [INSERT INTO warning_sand_202303(`t_pid`, `t_tp`, `t__ntype`, `t__notice`, `t__remark`, `create_time`) VALUES (37 , 3, 0, 'oZMR-6eyBpryepFcaFawH7n6b2ZI', 'WID：0 类型：温度超上限预警 SN：2023125067633148 主机：4G冰箱版3148 设备：4G冰箱板3148探头 备注：已持续 21分钟 通知方式：短信通知 通知对象：oZMR-6eyBpryepFcaFawH7n6b2ZI', '2023-03-15 12:00:07')] 2023/03/15 12:00:07.490 [ORM]2023/03/15 12:00:07 -[Queries/default] - [ OK / db.Exec / 31.7ms] - [INSERT INTO `warning` (`t_pid`, `t_tp`, `t_sn`, `t__d_name`, `t_id`, `t__d_s_name`, `t__remark`, `t__ut`, `t_f_ut`, `t__text`, `t__log`, `t__msid`, `t__state`, `create_time`, `update_time`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)] - `37`, `3`, `2023125067633148`, `4G冰箱版3148`, `1`, `4G冰箱板3148探头`, `当前温度:17.2 (↑-40~↓10),已持续 21分钟 `, `2023-03-15 12:00:05 +0800 CST`, `2023-03-15 11:39:05 +0800 CST`, ``, `执行通知策略 ->[小管理主机测-wj] [微信]持续时间:1261秒, 间隔时间:0秒, 内发送次数:0次, 间隔还剩时间:0秒 ----> oZMR-6XVx-O5gsUDOnd45aCeVamM/bc测试->发送成功！ ----> oZMR-6eyBpryepFcaFawH7n6b2ZI/小管理主机->发送成功！ `, `2805273`, `3`, `2023-03-15 12:00:07.4586871 +0800 CST`, `2023-03-15 12:00:07.4586871 +0800 CST` 2023/03/15 12:00:07.673 [ORM]2023/03/15 12:00:07 -[Queries/default] - [ OK / db.Query / 27.9ms] - [SELECT T0.`ID`, T0.`t_pid`, T0.`t_name`, T0.`t__notice_wx`, T0.`t__notice_phone`, T0.`t__notice_message`, T0.`t__notice_mailbox`, T0.`t__notice_mechanism`, T0.`t__notice_bind`, T0.`t__state`, T0.`create_time`, T0.`update_time` FROM `company_notice` T0 WHERE T0.`t_pid` = ? ORDER BY T0.`ID` ASC ] - `37` 2023/03/15 12:00:07.706 [ORM]2023/03/15 12:00:07 -[Queries/default] - [ OK / db.Exec / 32.4ms] - [INSERT INTO `warning` (`t_pid`, `t_tp`, `t_sn`, `t__d_name`, `t_id`, `t__d_s_name`, `t__remark`, `t__ut`, `t_f_ut`, `t__text`, `t__log`, `t__msid`, `t__state`, `create_time`, `update_time`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)] - `37`, `103`, `2023105182699608`, `小管理主机2号-测试样机`, `0`, `小管理主机2号-测试样机`, `记录数据[03-15 12:00]上报成功且本地备份成功`, `2023-03-15 12:00:01 +0800 CST`, `2023-03-15 12:00:01 +0800 CST`, ``, `执行通知策略 ->[小管理主机测-wj] `, `14401128`, `1`, `2023-03-15 12:00:07.6739599 +0800 CST`, `2023-03-15 12:00:07.6739599 +0800 CST` 2023/03/15 12:00:12.478 [ORM]2023/03/15 12:00:12 -[Queries/default] - [ OK / db.Exec / 31.5ms] - [UPDATE `device` SET `t__dattery` = ?, `t_rssi` = ?, `update_time` = ? WHERE `t_sn` = ?] - `100`, `24`, `2023-03-15 12:00:12.4469291 +0800 CST m=+239.391590901`, `2023125067633148` 2023/03/15 12:00:12.516 [ORM]2023/03/15 12:00:12 -[Queries/default] - [ OK / db.Exec / 31.3ms] - [UPDATE `device` SET `t__dattery` = ?, `t_rssi` = ?, `update_time` = ? WHERE `t_sn` = ?] - `100`, `21`, `2023-03-15 12:00:12.4848076 +0800 CST m=+239.429469101`, `2023125762710435` 2023/03/15 12:00:12.726 [ORM]2023/03/15 12:00:12 -[Queries/default] - [ OK / db.Query / 27.5ms] - [SELECT T0.`ID`, T0.`t_pid`, T0.`t_name`, T0.`t__notice_wx`, T0.`t__notice_phone`, T0.`t__notice_message`, T0.`t__notice_mailbox`, T0.`t__notice_mechanism`, T0.`t__notice_bind`, T0.`t__state`, T0.`create_time`, T0.`update_time` FROM `company_notice` T0 WHERE T0.`t_pid` = ? ORDER BY T0.`ID` ASC ] - `37` 2023/03/15 12:00:12.766 [ORM]2023/03/15 12:00:12 -[Queries/default] - [ OK / db.Query / 26.4ms] - [SELECT T0.`ID`, T0.`t_mid`, T0.`t_name`, T0.`t_key`, T0.`t_money`, T0.`t__state`, T0.`create_time`, T0.`update_time` FROM `company` T0 WHERE T0.`ID` = ? AND T0.`t__state` = ? LIMIT 1] - `37`, `1` 2023/03/15 12:00:12.851 [ORM]2023/03/15 12:00:12 -[Queries/default] - [ OK / db.QueryRow / 27.0ms] - [SELECT `ID`, `t_uuid`, `t_pid`, `t_pids`, `t_power`, `t_user`, `t_pass`, `t_name`, `t_phone`, `t_mail`, `t_wx`, `t__state`, `create_time`, `update_time` FROM `admin` WHERE `t_uuid` = ? AND `t__state` = ? ] - `dab65906-d03a-427c-8524-7c7a57ab8058`, `1` 2023/03/15 12:00:13.249 [ORM]2023/03/15 12:00:13 -[Queries/default] - [ OK / db.Exec / 18.4ms] - [INSERT INTO warning_sand_202303(`t_pid`, `t_tp`, `t__ntype`, `t__notice`, `t__remark`, `create_time`) VALUES (37 , 8, 0, 'oZMR-6XVx-O5gsUDOnd45aCeVamM', 'WID：0 类型：湿度超上限预警 SN：2023125762710435 主机：4G冰箱冯测试 设备：4G冰箱冯测试01 备注：已持续 4分钟 通知方式：短信通知 通知对象：oZMR-6XVx-O5gsUDOnd45aCeVamM', '2023-03-15 12:00:13')] 2023/03/15 12:00:13.741 [ORM]2023/03/15 12:00:13 -[Queries/default] - [ OK / db.Exec / 18.4ms] - [INSERT INTO warning_sand_202303(`t_pid`, `t_tp`, `t__ntype`, `t__notice`, `t__remark`, `create_time`) VALUES (37 , 8, 0, 'oZMR-6eyBpryepFcaFawH7n6b2ZI', 'WID：0 类型：湿度超上限预警 SN：2023125762710435 主机：4G冰箱冯测试 设备：4G冰箱冯测试01 备注：已持续 4分钟 通知方式：短信通知 通知对象：oZMR-6eyBpryepFcaFawH7n6b2ZI', '2023-03-15 12:00:13')] 2023/03/15 12:00:13.781 [ORM]2023/03/15 12:00:13 -[Queries/default] - [ OK / db.Query / 26.8ms] - [SELECT T0.`ID`, T0.`t_mid`, T0.`t_name`, T0.`t_key`, T0.`t_money`, T0.`t__state`, T0.`create_time`, T0.`update_time` FROM `company` T0 WHERE T0.`ID` = ? AND T0.`t__state` = ? LIMIT 1] - `37`, `1` 2023/03/15 12:00:13.861 [ORM]2023/03/15 12:00:13 -[Queries/default] - [ OK / db.QueryRow / 27.6ms] - [SELECT `ID`, `t_uuid`, `t_pid`, `t_pids`, `t_power`, `t_user`, `t_pass`, `t_name`, `t_phone`, `t_mail`, `t_wx`, `t__state`, `create_time`, `update_time` FROM `admin` WHERE `t_uuid` = ? AND `t__state` = ? ] - `7823d0c9-ef68-442a-943f-c3c10fb2be8b`, `1` 2023/03/15 12:00:14.324 [ORM]2023/03/15 12:00:14 -[Queries/default] - [ OK / db.Exec / 21.8ms] - [INSERT INTO warning_sand_202303(`t_pid`, `t_tp`, `t__ntype`, `t__notice`, `t__remark`, `create_time`) VALUES (37 , 8, 0, 'oZMR-6VfvmW0ocvZTIibBdsR7yyI', 'WID：0 类型：湿度超上限预警 SN：2023125762710435 主机：4G冰箱冯测试 设备：4G冰箱冯测试01 备注：已持续 4分钟 通知方式：短信通知 通知对象：oZMR-6VfvmW0ocvZTIibBdsR7yyI', '2023-03-15 12:00:14')] 2023/03/15 12:00:14.364 [ORM]2023/03/15 12:00:14 -[Queries/default] - [ OK / db.Query / 26.6ms] - [SELECT T0.`ID`, T0.`t_mid`, T0.`t_name`, T0.`t_key`, T0.`t_money`, T0.`t__state`, T0.`create_time`, T0.`update_time` FROM `company` T0 WHERE T0.`ID` = ? AND T0.`t__state` = ? LIMIT 1] - `37`, `1` 2023/03/15 12:00:14.447 [ORM]2023/03/15 12:00:14 -[Queries/default] - [ OK / db.QueryRow / 27.0ms] - [SELECT `ID`, `t_uuid`, `t_pid`, `t_pids`, `t_power`, `t_user`, `t_pass`, `t_name`, `t_phone`, `t_mail`, `t_wx`, `t__state`, `create_time`, `update_time` FROM `admin` WHERE `t_uuid` = ? AND `t__state` = ? ] - `dab65906-d03a-427c-8524-7c7a57ab8058`, `1` 2023/03/15 12:00:14.881 [ORM]2023/03/15 12:00:14 -[Queries/default] - [ OK / db.Exec / 20.6ms] - [INSERT INTO warning_sand_202303(`t_pid`, `t_tp`, `t__ntype`, `t__notice`, `t__remark`, `create_time`) VALUES (37 , 8, 0, 'oZMR-6XVx-O5gsUDOnd45aCeVamM', 'WID：0 类型：湿度超上限预警 SN：2023125762710435 主机：4G冰箱冯测试 设备：4G冰箱冯测试01 备注：已持续 4分钟 通知方式：短信通知 通知对象：oZMR-6XVx-O5gsUDOnd45aCeVamM', '2023-03-15 12:00:14')] 2023/03/15 12:00:15.296 [ORM]2023/03/15 12:00:15 -[Queries/default] - [ OK / db.Exec / 20.0ms] - [INSERT INTO warning_sand_202303(`t_pid`, `t_tp`, `t__ntype`, `t__notice`, `t__remark`, `create_time`) VALUES (37 , 8, 0, 'oZMR-6eyBpryepFcaFawH7n6b2ZI', 'WID：0 类型：湿度超上限预警 SN：2023125762710435 主机：4G冰箱冯测试 设备：4G冰箱冯测试01 备注：已持续 4分钟 通知方式：短信通知 通知对象：oZMR-6eyBpryepFcaFawH7n6b2ZI', '2023-03-15 12:00:15')] 2023/03/15 12:00:15.332 [ORM]2023/03/15 12:00:15 -[Queries/default] - [ OK / db.Exec / 35.3ms] - [INSERT INTO `warning` (`t_pid`, `t_tp`, `t_sn`, `t__d_name`, `t_id`, `t__d_s_name`, `t__remark`, `t__ut`, `t_f_ut`, `t__text`, `t__log`, `t__msid`, `t__state`, `create_time`, `update_time`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)] - `37`, `8`, `2023125762710435`, `4G冰箱冯测试`, `1`, `4G冰箱冯测试01`, `当前湿度:50.9 (↑60~↓80),已持续 4分钟 `, `2023-03-15 12:00:12 +0800 CST`, `2023-03-15 11:56:12 +0800 CST`, ``, `执行通知策略 ->[策略1] [微信]持续时间:240秒, 间隔时间:0秒, 内发送次数:0次, 间隔还剩时间:0秒 ----> oZMR-6XVx-O5gsUDOnd45aCeVamM/bc测试->发送成功！ ----> oZMR-6eyBpryepFcaFawH7n6b2ZI/小管理主机->发送成功！ 执行通知策略 ->[冰箱版测试] [微信]持续时间:241秒, 间隔时间:0秒, 内发送次数:0次, 间隔还剩时间:0秒 ----> oZMR-6VfvmW0ocvZTIibBdsR7yyI/冯靖沣->发送成功！ 执行通知策略 ->[小管理主机测-wj] [微信]持续时间:242秒, 间隔时间:0秒, 内发送次数:0次, 间隔还剩时间:0秒 ----> oZMR-6XVx-O5gsUDOnd45aCeVamM/bc测试->发送成功！ ----> oZMR-6eyBpryepFcaFawH7n6b2ZI/小管理主机->发送成功！ `, `2812705`, `3`, `2023-03-15 12:00:15.2969074 +0800 CST`, `2023-03-15 12:00:15.2969074 +0800 CST` 2023/03/15 12:00:15.949 [ORM]2023/03/15 12:00:15 -[Queries/default] - [ OK / db.Exec / 34.6ms] - [UPDATE `device` SET `t__dattery` = ?, `t_rssi` = ?, `update_time` = ? WHERE `t_sn` = ?] - `80`, `24`, `2023-03-15 12:00:15.9151759 +0800 CST m=+242.859809301`, `2023105182699608` 2023/03/15 12:00:16.569 [ORM]2023/03/15 12:00:16 -[Queries/default] - [ OK / db.Query / 27.8ms] - [SELECT T0.`ID`, T0.`t_pid`, T0.`t_name`, T0.`t__notice_wx`, T0.`t__notice_phone`, T0.`t__notice_message`, T0.`t__notice_mailbox`, T0.`t__notice_mechanism`, T0.`t__notice_bind`, T0.`t__state`, T0.`create_time`, T0.`update_time` FROM `company_notice` T0 WHERE T0.`t_pid` = ? ORDER BY T0.`ID` ASC ] - `37` 2023/03/15 12:00:16.601 [ORM]2023/03/15 12:00:16 -[Queries/default] - [ OK / db.Exec / 32.0ms] - [INSERT INTO `warning` (`t_pid`, `t_tp`, `t_sn`, `t__d_name`, `t_id`, `t__d_s_name`, `t__remark`, `t__ut`, `t_f_ut`, `t__text`, `t__log`, `t__msid`, `t__state`, `create_time`, `update_time`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)] - `37`, `103`, `2023105182699608`, `小管理主机2号-测试样机`, `0`, `小管理主机2号-测试样机`, `设备状态：mpwr:1,sq:24,ups:12.00v,batin:4.20v`, `2023-03-15 12:00:13 +0800 CST`, `2023-03-15 12:00:13 +0800 CST`, ``, `执行通知策略 ->[小管理主机测-wj] `, `14413134`, `1`, `2023-03-15 12:00:16.5696204 +0800 CST`, `2023-03-15 12:00:16.5696204 +0800 CST` 2023/03/15 12:00:17.748 [ORM]2023/03/15 12:00:17 -[Queries/default] - [ OK / db.Exec / 20.1ms] - [INSERT INTO z_device_data_2023122788596641 (`t_id`, `t_t`, `t_rh`, `t_site`, `t_time`, `t_sp`) VALUES (1 , 17.899999618530273, 59.5, '', '2023-03-15 12:00:00', 4577)] 2023/03/15 12:00:17.786 [ORM]2023/03/15 12:00:17 -[Queries/default] - [ OK / db.Exec / 35.5ms] - [UPDATE `device` SET `t__dattery` = ?, `t_rssi` = ?, `update_time` = ? WHERE `t_sn` = ?] - `100`, `31`, `2023-03-15 12:00:17.7510568 +0800 CST m=+244.695675101`, `2023122788596641` 2023/03/15 12:00:18.863 [ORM]2023/03/15 12:00:18 -[Queries/default] - [ OK / db.Exec / 27.8ms] - [INSERT INTO z_device_data_2023125067633148 (`t_id`, `t_t`, `t_rh`, `t_site`, `t_time`, `t_sp`) VALUES (1 , 17.299999237060547, 62.900001525878906, '', '2023-03-15 12:00:00', 4709)] 2023/03/15 12:00:18.911 [ORM]2023/03/15 12:00:18 -[Queries/default] - [ OK / db.Exec / 31.6ms] - [UPDATE `device` SET `t__dattery` = ?, `t_rssi` = ?, `update_time` = ? WHERE `t_sn` = ?] - `100`, `24`, `2023-03-15 12:00:18.8797065 +0800 CST m=+245.824315501`, `2023125067633148` 2023/03/15 12:00:19.932 [ORM]2023/03/15 12:00:19 -[Queries/default] - [ OK / db.Query / 27.7ms] - [SELECT T0.`ID`, T0.`t_pid`, T0.`t_name`, T0.`t__notice_wx`, T0.`t__notice_phone`, T0.`t__notice_message`, T0.`t__notice_mailbox`, T0.`t__notice_mechanism`, T0.`t__notice_bind`, T0.`t__state`, T0.`create_time`, T0.`update_time` FROM `company_notice` T0 WHERE T0.`t_pid` = ? ORDER BY T0.`ID` ASC ] - `37` 2023/03/15 12:00:19.965 [ORM]2023/03/15 12:00:19 -[Queries/default] - [ OK / db.Exec / 33.1ms] - [INSERT INTO `warning` (`t_pid`, `t_tp`, `t_sn`, `t__d_name`, `t_id`, `t__d_s_name`, `t__remark`, `t__ut`, `t_f_ut`, `t__text`, `t__log`, `t__msid`, `t__state`, `create_time`, `update_time`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)] - `37`, `103`, `2023105182699608`, `小管理主机2号-测试样机`, `0`, `小管理主机2号-测试样机`, `终端ID[28]掉线:3`, `2023-03-15 12:00:17 +0800 CST`, `2023-03-15 12:00:17 +0800 CST`, ``, `执行通知策略 ->[小管理主机测-wj] `, `14417136`, `1`, `2023-03-15 12:00:19.9320007 +0800 CST`, `2023-03-15 12:00:19.9320007 +0800 CST` 2023/03/15 12:00:20.698 [ORM]2023/03/15 12:00:20 -[Queries/default] - [ OK / db.Query / 27.9ms] - [SELECT T0.`ID`, T0.`t_pid`, T0.`t_name`, T0.`t__notice_wx`, T0.`t__notice_phone`, T0.`t__notice_message`, T0.`t__notice_mailbox`, T0.`t__notice_mechanism`, T0.`t__notice_bind`, T0.`t__state`, T0.`create_time`, T0.`update_time` FROM `company_notice` T0 WHERE T0.`t_pid` = ? ORDER BY T0.`ID` ASC ] - `37` 2023/03/15 12:00:20.738 [ORM]2023/03/15 12:00:20 -[Queries/default] - [ OK / db.Query / 26.6ms] - [SELECT T0.`ID`, T0.`t_mid`, T0.`t_name`, T0.`t_key`, T0.`t_money`, T0.`t__state`, T0.`create_time`, T0.`update_time` FROM `company` T0 WHERE T0.`ID` = ? AND T0.`t__state` = ? LIMIT 1] - `37`, `1` 2023/03/15 12:00:20.818 [ORM]2023/03/15 12:00:20 -[Queries/default] - [ OK / db.QueryRow / 26.7ms] - [SELECT `ID`, `t_uuid`, `t_pid`, `t_pids`, `t_power`, `t_user`, `t_pass`, `t_name`, `t_phone`, `t_mail`, `t_wx`, `t__state`, `create_time`, `update_time` FROM `admin` WHERE `t_uuid` = ? AND `t__state` = ? ] - `dab65906-d03a-427c-8524-7c7a57ab8058`, `1` 2023/03/15 12:00:21.231 [ORM]2023/03/15 12:00:21 -[Queries/default] - [ OK / db.Exec / 18.7ms] - [INSERT INTO warning_sand_202303(`t_pid`, `t_tp`, `t__ntype`, `t__notice`, `t__remark`, `create_time`) VALUES (37 , 113, 0, 'oZMR-6XVx-O5gsUDOnd45aCeVamM', 'WID：0 类型：传感器故障报警 SN：2023105182699608 主机：小管理主机2号-测试样机 设备：小管理主机2号-测试样机 备注：终端[28]掉线,请检查 通知方式：短信通知 通知对象：oZMR-6XVx-O5gsUDOnd45aCeVamM', '2023-03-15 12:00:21')] 2023/03/15 12:00:21.327 [ORM]2023/03/15 12:00:21 -[Queries/default] - [ OK / db.Exec / 20.2ms] - [INSERT INTO z_device_data_2023123898034225 (`t_id`, `t_t`, `t_rh`, `t_site`, `t_time`, `t_sp`) VALUES (1 , 17.299999237060547, 62.099998474121094, '', '2023-03-15 12:00:00', 4563)] 2023/03/15 12:00:21.399 [ORM]2023/03/15 12:00:21 -[Queries/default] - [ OK / db.Exec / 32.2ms] - [UPDATE `device` SET `t__dattery` = ?, `t_rssi` = ?, `update_time` = ? WHERE `t_sn` = ?] - `100`, `18`, `2023-03-15 12:00:21.3669185 +0800 CST m=+248.311507201`, `2023123898034225` 2023/03/15 12:00:21.705 [ORM]2023/03/15 12:00:21 -[Queries/default] - [ OK / db.Exec / 19.6ms] - [INSERT INTO warning_sand_202303(`t_pid`, `t_tp`, `t__ntype`, `t__notice`, `t__remark`, `create_time`) VALUES (37 , 113, 0, 'oZMR-6eyBpryepFcaFawH7n6b2ZI', 'WID：0 类型：传感器故障报警 SN：2023105182699608 主机：小管理主机2号-测试样机 设备：小管理主机2号-测试样机 备注：终端[28]掉线,请检查 通知方式：短信通知 通知对象：oZMR-6eyBpryepFcaFawH7n6b2ZI', '2023-03-15 12:00:21')] 2023/03/15 12:00:21.737 [ORM]2023/03/15 12:00:21 -[Queries/default] - [ OK / db.Exec / 32.0ms] - [INSERT INTO `warning` (`t_pid`, `t_tp`, `t_sn`, `t__d_name`, `t_id`, `t__d_s_name`, `t__remark`, `t__ut`, `t_f_ut`, `t__text`, `t__log`, `t__msid`, `t__state`, `create_time`, `update_time`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)] - `37`, `113`, `2023105182699608`, `小管理主机2号-测试样机`, `0`, `小管理主机2号-测试样机`, `终端[28]掉线,请检查`, `2023-03-15 12:00:18 +0800 CST`, `2023-03-15 12:00:18 +0800 CST`, ``, `执行通知策略 ->[小管理主机测-wj] [微信]持续时间:2秒, 间隔时间:0秒, 内发送次数:0次, 间隔还剩时间:0秒 ----> oZMR-6XVx-O5gsUDOnd45aCeVamM/bc测试->发送成功！ ----> oZMR-6eyBpryepFcaFawH7n6b2ZI/小管理主机->发送成功！ `, `14418138`, `3`, `2023-03-15 12:00:21.7053373 +0800 CST`, `2023-03-15 12:00:21.7053373 +0800 CST` 2023/03/15 12:00:22.457 [ORM]2023/03/15 12:00:22 -[Queries/default] - [ OK / db.Query / 27.6ms] - [SELECT T0.`ID`, T0.`t_pid`, T0.`t_name`, T0.`t__notice_wx`, T0.`t__notice_phone`, T0.`t__notice_message`, T0.`t__notice_mailbox`, T0.`t__notice_mechanism`, T0.`t__notice_bind`, T0.`t__state`, T0.`create_time`, T0.`update_time` FROM `company_notice` T0 WHERE T0.`t_pid` = ? ORDER BY T0.`ID` ASC ] - `37` 2023/03/15 12:00:22.496 [ORM]2023/03/15 12:00:22 -[Queries/default] - [ OK / db.Query / 26.4ms] - [SELECT T0.`ID`, T0.`t_mid`, T0.`t_name`, T0.`t_key`, T0.`t_money`, T0.`t__state`, T0.`create_time`, T0.`update_time` FROM `company` T0 WHERE T0.`ID` = ? AND T0.`t__state` = ? LIMIT 1] - `37`, `1` 2023/03/15 12:00:22.577 [ORM]2023/03/15 12:00:22 -[Queries/default] - [ OK / db.QueryRow / 26.8ms] - [SELECT `ID`, `t_uuid`, `t_pid`, `t_pids`, `t_power`, `t_user`, `t_pass`, `t_name`, `t_phone`, `t_mail`, `t_wx`, `t__state`, `create_time`, `update_time` FROM `admin` WHERE `t_uuid` = ? AND `t__state` = ? ] - `dab65906-d03a-427c-8524-7c7a57ab8058`, `1` 2023/03/15 12:00:22.800 [ORM]2023/03/15 12:00:22 -[Queries/default] - [ OK / db.Exec / 35.8ms] - [UPDATE `device` SET `t__dattery` = ?, `t_rssi` = ?, `update_time` = ? WHERE `t_sn` = ?] - `100`, `24`, `2023-03-15 12:00:22.7650529 +0800 CST m=+249.709630101`, `2023125067633148` 2023/03/15 12:00:22.818 [ORM]2023/03/15 12:00:22 -[Queries/default] - [ OK / db.Exec / 36.6ms] - [UPDATE `device` SET `t__dattery` = ?, `t_rssi` = ?, `update_time` = ? WHERE `t_sn` = ?] - `100`, `21`, `2023-03-15 12:00:22.7820426 +0800 CST m=+249.726619701`, `2023125762710435` 2023/03/15 12:00:23.003 [ORM]2023/03/15 12:00:23 -[Queries/default] - [ OK / db.Exec / 18.9ms] - [INSERT INTO warning_sand_202303(`t_pid`, `t_tp`, `t__ntype`, `t__notice`, `t__remark`, `create_time`) VALUES (37 , 113, 0, 'oZMR-6XVx-O5gsUDOnd45aCeVamM', 'WID：0 类型：传感器故障报警 SN：2023105182699608 主机：小管理主机2号-测试样机 设备：小管理主机2号-测试样机 备注：终端[28]掉线,请检查 通知方式：短信通知 通知对象：oZMR-6XVx-O5gsUDOnd45aCeVamM', '2023-03-15 12:00:22')] 2023/03/15 12:00:23.482 [ORM]2023/03/15 12:00:23 -[Queries/default] - [ OK / db.Exec / 19.4ms] - [INSERT INTO warning_sand_202303(`t_pid`, `t_tp`, `t__ntype`, `t__notice`, `t__remark`, `create_time`) VALUES (37 , 113, 0, 'oZMR-6eyBpryepFcaFawH7n6b2ZI', 'WID：0 类型：传感器故障报警 SN：2023105182699608 主机：小管理主机2号-测试样机 设备：小管理主机2号-测试样机 备注：终端[28]掉线,请检查 通知方式：短信通知 通知对象：oZMR-6eyBpryepFcaFawH7n6b2ZI', '2023-03-15 12:00:23')] 2023/03/15 12:00:23.514 [ORM]2023/03/15 12:00:23 -[Queries/default] - [ OK / db.Exec / 32.1ms] - [INSERT INTO `warning` (`t_pid`, `t_tp`, `t_sn`, `t__d_name`, `t_id`, `t__d_s_name`, `t__remark`, `t__ut`, `t_f_ut`, `t__text`, `t__log`, `t__msid`, `t__state`, `create_time`, `update_time`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)] - `37`, `113`, `2023105182699608`, `小管理主机2号-测试样机`, `0`, `小管理主机2号-测试样机`, `终端[28]掉线,请检查`, `2023-03-15 12:00:18 +0800 CST`, `2023-03-15 12:00:18 +0800 CST`, ``, `执行通知策略 ->[小管理主机测-wj] [微信]持续时间:4秒, 间隔时间:0秒, 内发送次数:0次, 间隔还剩时间:0秒 ----> oZMR-6XVx-O5gsUDOnd45aCeVamM/bc测试->发送成功！ ----> oZMR-6eyBpryepFcaFawH7n6b2ZI/小管理主机->发送成功！ `, `14418140`, `3`, `2023-03-15 12:00:23.4827956 +0800 CST`, `2023-03-15 12:00:23.4827956 +0800 CST` 2023/03/15 12:00:23.979 [ORM]2023/03/15 12:00:23 -[Queries/default] - [ OK / db.Query / 27.6ms] - [SELECT T0.`ID`, T0.`t_pid`, T0.`t_name`, T0.`t__notice_wx`, T0.`t__notice_phone`, T0.`t__notice_message`, T0.`t__notice_mailbox`, T0.`t__notice_mechanism`, T0.`t__notice_bind`, T0.`t__state`, T0.`create_time`, T0.`update_time` FROM `company_notice` T0 WHERE T0.`t_pid` = ? ORDER BY T0.`ID` ASC ] - `37` 2023/03/15 12:00:24.012 [ORM]2023/03/15 12:00:24 -[Queries/default] - [ OK / db.Exec / 32.8ms] - [INSERT INTO `warning` (`t_pid`, `t_tp`, `t_sn`, `t__d_name`, `t_id`, `t__d_s_name`, `t__remark`, `t__ut`, `t_f_ut`, `t__text`, `t__log`, `t__msid`, `t__state`, `create_time`, `update_time`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)] - `37`, `103`, `2023105182699608`, `小管理主机2号-测试样机`, `0`, `小管理主机2号-测试样机`, `终端[28]掉线上报失败，1`, `2023-03-15 12:00:18 +0800 CST`, `2023-03-15 12:00:18 +0800 CST`, ``, `执行通知策略 ->[小管理主机测-wj] `, `14418142`, `1`, `2023-03-15 12:00:23.9799966 +0800 CST`, `2023-03-15 12:00:23.9799966 +0800 CST` 2023/03/15 12:00:27.639 [ORM]2023/03/15 12:00:27 -[Queries/default] - [ OK / db.Query / 27.8ms] - [SELECT T0.`ID`, T0.`t_pid`, T0.`t_name`, T0.`t__notice_wx`, T0.`t__notice_phone`, T0.`t__notice_message`, T0.`t__notice_mailbox`, T0.`t__notice_mechanism`, T0.`t__notice_bind`, T0.`t__state`, T0.`create_time`, T0.`update_time` FROM `company_notice` T0 WHERE T0.`t_pid` = ? ORDER BY T0.`ID` ASC ] - `37` 2023/03/15 12:00:27.679 [ORM]2023/03/15 12:00:27 -[Queries/default] - [ OK / db.Query / 26.4ms] - [SELECT T0.`ID`, T0.`t_mid`, T0.`t_name`, T0.`t_key`, T0.`t_money`, T0.`t__state`, T0.`create_time`, T0.`update_time` FROM `company` T0 WHERE T0.`ID` = ? AND T0.`t__state` = ? LIMIT 1] - `37`, `1` 2023/03/15 12:00:27.759 [ORM]2023/03/15 12:00:27 -[Queries/default] - [ OK / db.QueryRow / 28.0ms] - [SELECT `ID`, `t_uuid`, `t_pid`, `t_pids`, `t_power`, `t_user`, `t_pass`, `t_name`, `t_phone`, `t_mail`, `t_wx`, `t__state`, `create_time`, `update_time` FROM `admin` WHERE `t_uuid` = ? AND `t__state` = ? ] - `dab65906-d03a-427c-8524-7c7a57ab8058`, `1` 2023/03/15 12:00:28.272 [ORM]2023/03/15 12:00:28 -[Queries/default] - [ OK / db.Exec / 26.3ms] - [INSERT INTO warning_sand_202303(`t_pid`, `t_tp`, `t__ntype`, `t__notice`, `t__remark`, `create_time`) VALUES (37 , 113, 0, 'oZMR-6XVx-O5gsUDOnd45aCeVamM', 'WID：0 类型：传感器故障报警 SN：2023105182699608 主机：小管理主机2号-测试样机 设备：小管理主机2号-测试样机 备注：终端[28]掉线,请检查 通知方式：短信通知 通知对象：oZMR-6XVx-O5gsUDOnd45aCeVamM', '2023-03-15 12:00:28')] 2023/03/15 12:00:28.643 [ORM]2023/03/15 12:00:28 -[Queries/default] - [ OK / db.Exec / 18.5ms] - [INSERT INTO warning_sand_202303(`t_pid`, `t_tp`, `t__ntype`, `t__notice`, `t__remark`, `create_time`) VALUES (37 , 113, 0, 'oZMR-6eyBpryepFcaFawH7n6b2ZI', 'WID：0 类型：传感器故障报警 SN：2023105182699608 主机：小管理主机2号-测试样机 设备：小管理主机2号-测试样机 备注：终端[28]掉线,请检查 通知方式：短信通知 通知对象：oZMR-6eyBpryepFcaFawH7n6b2ZI', '2023-03-15 12:00:28')] 2023/03/15 12:00:28.674 [ORM]2023/03/15 12:00:28 -[Queries/default] - [ OK / db.Exec / 31.5ms] - [INSERT INTO `warning` (`t_pid`, `t_tp`, `t_sn`, `t__d_name`, `t_id`, `t__d_s_name`, `t__remark`, `t__ut`, `t_f_ut`, `t__text`, `t__log`, `t__msid`, `t__state`, `create_time`, `update_time`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)] - `37`, `113`, `2023105182699608`, `小管理主机2号-测试样机`, `0`, `小管理主机2号-测试样机`, `终端[28]掉线,请检查`, `2023-03-15 12:00:25 +0800 CST`, `2023-03-15 12:00:25 +0800 CST`, ``, `执行通知策略 ->[小管理主机测-wj] [微信]持续时间:2秒, 间隔时间:0秒, 内发送次数:0次, 间隔还剩时间:0秒 ----> oZMR-6XVx-O5gsUDOnd45aCeVamM/bc测试->发送成功！ ----> oZMR-6eyBpryepFcaFawH7n6b2ZI/小管理主机->发送成功！ `, `14425145`, `3`, `2023-03-15 12:00:28.6432962 +0800 CST`, `2023-03-15 12:00:28.6432962 +0800 CST` 2023/03/15 12:00:29.372 [ORM]2023/03/15 12:00:29 -[Queries/default] - [ OK / db.Query / 28.1ms] - [SELECT T0.`ID`, T0.`t_pid`, T0.`t_name`, T0.`t__notice_wx`, T0.`t__notice_phone`, T0.`t__notice_message`, T0.`t__notice_mailbox`, T0.`t__notice_mechanism`, T0.`t__notice_bind`, T0.`t__state`, T0.`create_time`, T0.`update_time` FROM `company_notice` T0 WHERE T0.`t_pid` = ? ORDER BY T0.`ID` ASC ] - `37` 2023/03/15 12:00:29.412 [ORM]2023/03/15 12:00:29 -[Queries/default] - [ OK / db.Query / 26.6ms] - [SELECT T0.`ID`, T0.`t_mid`, T0.`t_name`, T0.`t_key`, T0.`t_money`, T0.`t__state`, T0.`create_time`, T0.`update_time` FROM `company` T0 WHERE T0.`ID` = ? AND T0.`t__state` = ? LIMIT 1] - `37`, `1` 2023/03/15 12:00:29.502 [ORM]2023/03/15 12:00:29 -[Queries/default] - [ OK / db.QueryRow / 29.4ms] - [SELECT `ID`, `t_uuid`, `t_pid`, `t_pids`, `t_power`, `t_user`, `t_pass`, `t_name`, `t_phone`, `t_mail`, `t_wx`, `t__state`, `create_time`, `update_time` FROM `admin` WHERE `t_uuid` = ? AND `t__state` = ? ] - `dab65906-d03a-427c-8524-7c7a57ab8058`, `1` 2023/03/15 12:00:29.921 [ORM]2023/03/15 12:00:29 -[Queries/default] - [ OK / db.Exec / 19.2ms] - [INSERT INTO warning_sand_202303(`t_pid`, `t_tp`, `t__ntype`, `t__notice`, `t__remark`, `create_time`) VALUES (37 , 113, 0, 'oZMR-6XVx-O5gsUDOnd45aCeVamM', 'WID：0 类型：传感器故障报警 SN：2023105182699608 主机：小管理主机2号-测试样机 设备：小管理主机2号-测试样机 备注：终端[28]掉线,请检查 通知方式：短信通知 通知对象：oZMR-6XVx-O5gsUDOnd45aCeVamM', '2023-03-15 12:00:29')] 2023/03/15 12:00:30.385 [ORM]2023/03/15 12:00:30 -[Queries/default] - [ OK / db.Exec / 19.5ms] - [INSERT INTO warning_sand_202303(`t_pid`, `t_tp`, `t__ntype`, `t__notice`, `t__remark`, `create_time`) VALUES (37 , 113, 0, 'oZMR-6eyBpryepFcaFawH7n6b2ZI', 'WID：0 类型：传感器故障报警 SN：2023105182699608 主机：小管理主机2号-测试样机 设备：小管理主机2号-测试样机 备注：终端[28]掉线,请检查 通知方式：短信通知 通知对象：oZMR-6eyBpryepFcaFawH7n6b2ZI', '2023-03-15 12:00:30')] 2023/03/15 12:00:30.426 [ORM]2023/03/15 12:00:30 -[Queries/default] - [ OK / db.Exec / 40.9ms] - [INSERT INTO `warning` (`t_pid`, `t_tp`, `t_sn`, `t__d_name`, `t_id`, `t__d_s_name`, `t__remark`, `t__ut`, `t_f_ut`, `t__text`, `t__log`, `t__msid`, `t__state`, `create_time`, `update_time`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)] - `37`, `113`, `2023105182699608`, `小管理主机2号-测试样机`, `0`, `小管理主机2号-测试样机`, `终端[28]掉线,请检查`, `2023-03-15 12:00:25 +0800 CST`, `2023-03-15 12:00:25 +0800 CST`, ``, `执行通知策略 ->[小管理主机测-wj] [微信]持续时间:4秒, 间隔时间:0秒, 内发送次数:0次, 间隔还剩时间:0秒 ----> oZMR-6XVx-O5gsUDOnd45aCeVamM/bc测试->发送成功！ ----> oZMR-6eyBpryepFcaFawH7n6b2ZI/小管理主机->发送成功！ `, `14425147`, `3`, `2023-03-15 12:00:30.3850835 +0800 CST`, `2023-03-15 12:00:30.3850835 +0800 CST` 2023/03/15 12:00:30.897 [ORM]2023/03/15 12:00:30 -[Queries/default] - [ OK / db.Query / 27.6ms] - [SELECT T0.`ID`, T0.`t_pid`, T0.`t_name`, T0.`t__notice_wx`, T0.`t__notice_phone`, T0.`t__notice_message`, T0.`t__notice_mailbox`, T0.`t__notice_mechanism`, T0.`t__notice_bind`, T0.`t__state`, T0.`create_time`, T0.`update_time` FROM `company_notice` T0 WHERE T0.`t_pid` = ? ORDER BY T0.`ID` ASC ] - `37` 2023/03/15 12:00:30.929 [ORM]2023/03/15 12:00:30 -[Queries/default] - [ OK / db.Exec / 31.6ms] - [INSERT INTO `warning` (`t_pid`, `t_tp`, `t_sn`, `t__d_name`, `t_id`, `t__d_s_name`, `t__remark`, `t__ut`, `t_f_ut`, `t__text`, `t__log`, `t__msid`, `t__state`, `create_time`, `update_time`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)] - `37`, `103`, `2023105182699608`, `小管理主机2号-测试样机`, `0`, `小管理主机2号-测试样机`, `终端[28]掉线上报失败，1`, `2023-03-15 12:00:25 +0800 CST`, `2023-03-15 12:00:25 +0800 CST`, ``, `执行通知策略 ->[小管理主机测-wj] `, `14425149`, `1`, `2023-03-15 12:00:30.8974112 +0800 CST`, `2023-03-15 12:00:30.8974112 +0800 CST` 2023/03/15 12:00:32.995 [ORM]2023/03/15 12:00:32 -[Queries/default] - [ OK / db.Exec / 37.9ms] - [UPDATE `device` SET `t__dattery` = ?, `t_rssi` = ?, `update_time` = ? WHERE `t_sn` = ?] - `100`, `24`, `2023-03-15 12:00:32.9571025 +0800 CST m=+259.901596101`, `2023125067633148` 2023/03/15 12:00:33.306 [ORM]2023/03/15 12:00:33 -[Queries/default] - [ OK / db.Exec / 32.8ms] - [UPDATE `device` SET `t__dattery` = ?, `t_rssi` = ?, `update_time` = ? WHERE `t_sn` = ?] - `100`, `21`, `2023-03-15 12:00:33.2739 +0800 CST m=+260.218391001`, `2023125762710435` 2023/03/15 12:00:33.977 [ORM]2023/03/15 12:00:33 -[Queries/default] - [ OK / db.Query / 27.9ms] - [SELECT T0.`ID`, T0.`t_pid`, T0.`t_name`, T0.`t__notice_wx`, T0.`t__notice_phone`, T0.`t__notice_message`, T0.`t__notice_mailbox`, T0.`t__notice_mechanism`, T0.`t__notice_bind`, T0.`t__state`, T0.`create_time`, T0.`update_time` FROM `company_notice` T0 WHERE T0.`t_pid` = ? ORDER BY T0.`ID` ASC ] - `37` 2023/03/15 12:00:34.017 [ORM]2023/03/15 12:00:34 -[Queries/default] - [ OK / db.Query / 27.0ms] - [SELECT T0.`ID`, T0.`t_mid`, T0.`t_name`, T0.`t_key`, T0.`t_money`, T0.`t__state`, T0.`create_time`, T0.`update_time` FROM `company` T0 WHERE T0.`ID` = ? AND T0.`t__state` = ? LIMIT 1] - `37`, `1` 2023/03/15 12:00:34.097 [ORM]2023/03/15 12:00:34 -[Queries/default] - [ OK / db.QueryRow / 26.8ms] - [SELECT `ID`, `t_uuid`, `t_pid`, `t_pids`, `t_power`, `t_user`, `t_pass`, `t_name`, `t_phone`, `t_mail`, `t_wx`, `t__state`, `create_time`, `update_time` FROM `admin` WHERE `t_uuid` = ? AND `t__state` = ? ] - `dab65906-d03a-427c-8524-7c7a57ab8058`, `1` 2023/03/15 12:00:34.522 [ORM]2023/03/15 12:00:34 -[Queries/default] - [ OK / db.Exec / 21.9ms] - [INSERT INTO warning_sand_202303(`t_pid`, `t_tp`, `t__ntype`, `t__notice`, `t__remark`, `create_time`) VALUES (37 , 113, 0, 'oZMR-6XVx-O5gsUDOnd45aCeVamM', 'WID：0 类型：传感器故障报警 SN：2023105182699608 主机：小管理主机2号-测试样机 设备：小管理主机2号-测试样机 备注：终端[28]掉线,请检查 通知方式：短信通知 通知对象：oZMR-6XVx-O5gsUDOnd45aCeVamM', '2023-03-15 12:00:34')] 2024/04/12 15:25:50.035 WarningBack:sqlC:/BZD/Cold/Cold_mqtt/models/Warning/WarningBack.go:7514.2466ms select * from information_schema.TABLES where TABLE_NAME = ? ;[warning_2024_04] 0 2024/04/12 15:25:50.053 WarningBack:sqlC:/BZD/Cold/Cold_mqtt/models/Warning/WarningBack.go:9317.3078msINSERT INTO warning_2024_04 SELECT * FROM warning WHERE ID = ? ;[25519881] 1 2024/04/12 15:28:06.925 WarningBack:sqlC:/BZD/Cold/Cold_mqtt/models/Warning/WarningBack.go:7514.3566ms select * from information_schema.TABLES where TABLE_NAME = ? ;[warning_2024_04] 0 2024/04/12 15:28:06.951 WarningBack:sqlC:/BZD/Cold/Cold_mqtt/models/Warning/WarningBack.go:9326.0461msINSERT INTO warning_2024_04 SELECT * FROM warning WHERE ID = ? ;[25519959] 1 2024/04/12 15:28:06.992 WarningBack:sqlC:/BZD/Cold/Cold_mqtt/models/Warning/WarningBack.go:9810.1024msUPDATE warning_2024_04 SET t__log = ? WHERE ID = ? ;[ 25519959] 0 2024/04/12 15:31:05.040 WarningBack:sqlC:/BZD/Cold/Cold_mqtt/models/Warning/WarningBack.go:9815.9089msUPDATE warning_2024_04 SET t__log = ? WHERE ID = ? ;[执行通知策略 ->[库房温湿度报警] [15:31:04] [电话]持续时间:79727秒, 间隔时间:0秒, 内发送次数:0次, 间隔还剩时间:0秒 25519959] 1 2024/04/12 15:40:52.171 WarningBack:sqlC:/BZD/Cold/Cold_mqtt/models/Warning/WarningBack.go:7511.9253ms select * from information_schema.TABLES where TABLE_NAME = ? ;[warning_2024_04] 0 2024/04/12 15:40:52.188 WarningBack:sqlC:/BZD/Cold/Cold_mqtt/models/Warning/WarningBack.go:9316.2367msINSERT INTO warning_2024_04 SELECT * FROM warning WHERE ID = ? ;[25520343] 1 2024/04/12 15:40:52.213 WarningBack:sqlC:/BZD/Cold/Cold_mqtt/models/Warning/WarningBack.go:989.9292msUPDATE warning_2024_04 SET t__log = ? WHERE ID = ? ;[ 25520343] 0 2024/04/12 15:40:55.725 WarningBack:sqlC:/BZD/Cold/Cold_mqtt/models/Warning/WarningBack.go:9816.1077msUPDATE warning_2024_04 SET t__log = ? WHERE ID = ? ;[执行通知策略 ->[库房温湿度报警] [15:40:55] [电话]持续时间:80318秒, 间隔时间:0秒, 内发送次数:0次, 间隔还剩时间:0秒 25520343] 1 2024/04/12 15:42:00.212 WarningBack:sqlC:/BZD/Cold/Cold_mqtt/models/Warning/WarningBack.go:7512.3595ms select * from information_schema.TABLES where TABLE_NAME = ? ;[warning_2024_04] 0 2024/04/12 15:42:00.228 WarningBack:sqlC:/BZD/Cold/Cold_mqtt/models/Warning/WarningBack.go:9315.6283msINSERT INTO warning_2024_04 SELECT * FROM warning WHERE ID = ? ;[25520366] 1 2024/04/12 15:42:00.265 WarningBack:sqlC:/BZD/Cold/Cold_mqtt/models/Warning/WarningBack.go:9810.1496msUPDATE warning_2024_04 SET t__log = ? WHERE ID = ? ;[ 25520366] 0 2024/04/12 15:52:28.436 WarningBack:sqlC:/BZD/Cold/Cold_mqtt/models/Warning/WarningBack.go:7523.1192ms select * from information_schema.TABLES where TABLE_NAME = ? ;[warning_2024_04] 0 2024/04/12 15:52:28.452 WarningBack:sqlC:/BZD/Cold/Cold_mqtt/models/Warning/WarningBack.go:9315.0646msINSERT INTO warning_2024_04 SELECT * FROM warning WHERE ID = ? ;[25520651] 1 2024/04/12 15:52:28.478 WarningBack:sqlC:/BZD/Cold/Cold_mqtt/models/Warning/WarningBack.go:989.791msUPDATE warning_2024_04 SET t__log = ? WHERE ID = ? ;[ 25520651] 0 2024/04/12 16:44:07.897 WarningBack:sqlC:/BZD/Cold/Cold_mqtt/models/Warning/WarningBack.go:7529.8757ms select * from information_schema.TABLES where TABLE_NAME = ? ;[warning_2024_04] 0 2024/04/12 16:44:07.927 WarningBack:sqlC:/BZD/Cold/Cold_mqtt/models/Warning/WarningBack.go:9329.6982msINSERT INTO warning_2024_04 SELECT * FROM warning WHERE ID = ? ;[25522057] 1 2024/04/12 16:44:07.965 WarningBack:sqlC:/BZD/Cold/Cold_mqtt/models/Warning/WarningBack.go:9821.5689msUPDATE warning_2024_04 SET t__log = ? WHERE ID = ? ;[ 25522057] 0 2024/04/12 16:44:08.039 WarningBack:sqlC:/BZD/Cold/Cold_mqtt/models/Warning/WarningBack.go:9830.3916msUPDATE warning_2024_04 SET t__log = ? WHERE ID = ? ;[执行通知策略 ->[库房温湿度报警] [16:44:07] 25522057] 1 2024/04/12 16:44:08.124 WarningBack:sqlC:/BZD/Cold/Cold_mqtt/models/Warning/WarningBack.go:9322.4495msINSERT INTO warning_2024_04 SELECT * FROM warning WHERE ID = ? ;[25522059] 1 2024/04/12 16:44:08.158 WarningBack:sqlC:/BZD/Cold/Cold_mqtt/models/Warning/WarningBack.go:989.8911msUPDATE warning_2024_04 SET t__log = ? WHERE ID = ? ;[ 25522059] 0 2024/04/12 16:44:08.225 WarningBack:sqlC:/BZD/Cold/Cold_mqtt/models/Warning/WarningBack.go:9825.226msUPDATE warning_2024_04 SET t__log = ? WHERE ID = ? ;[执行通知策略 ->[库房温湿度报警] [16:44:08] 25522059] 1