logx.log 115 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655
  1. 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 ]
  2. 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 ]
  3. 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)]
  4. 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`
  5. 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)]
  6. 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`
  7. 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`
  8. 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`
  9. 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`
  10. 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)]
  11. 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
  12. 类型:湿度超上限报警
  13. SN:2023105182699608
  14. 主机:小管理主机2号-测试样机
  15. 设备:办公室测试2-1
  16. 备注:
  17. 通知方式:短信通知
  18. 通知对象:oZMR-6XVx-O5gsUDOnd45aCeVamM', '2023-03-15 11:56:21')]
  19. 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`
  20. 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
  21. 类型:湿度超上限报警
  22. SN:2023105182699608
  23. 主机:小管理主机2号-测试样机
  24. 设备:办公室测试2-1
  25. 备注:4G冰箱冯测试01
  26. 通知方式:短信通知
  27. 通知对象:oZMR-6eyBpryepFcaFawH7n6b2ZI', '2023-03-15 11:56:21')]
  28. 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]
  29. [微信]持续时间:11秒, 间隔时间:0秒, 内发送次数:0次, 间隔还剩时间:0秒
  30. ----> oZMR-6XVx-O5gsUDOnd45aCeVamM/bc测试->发送成功!
  31. ----> oZMR-6eyBpryepFcaFawH7n6b2ZI/小管理主机->发送成功!
  32. `, `14169017`, `3`, `2023-03-15 11:56:21.6842088 +0800 CST`, `2023-03-15 11:56:21.6842088 +0800 CST`
  33. 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`
  34. 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]
  35. `, `14169019`, `1`, `2023-03-15 11:56:22.9757806 +0800 CST`, `2023-03-15 11:56:22.9757806 +0800 CST`
  36. 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)]
  37. 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`
  38. 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`
  39. 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`
  40. 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`
  41. 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`
  42. 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`
  43. 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`
  44. 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`
  45. 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`
  46. 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`
  47. 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`
  48. 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`, `<nil>`, ``, ``, `0`, `1`, `2023-03-15 11:56:47.5332811 +0800 CST`, `2023-03-15 11:56:47.5332811 +0800 CST`
  49. 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']
  50. 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`
  51. 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`
  52. 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`
  53. 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`
  54. 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`
  55. 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`, `<nil>`, ``, ``, `0`, `1`, `2023-03-15 11:56:48.0381695 +0800 CST`, `2023-03-15 11:56:48.0381695 +0800 CST`
  56. 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']
  57. 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`
  58. 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`
  59. 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`
  60. 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`
  61. 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`
  62. 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`
  63. 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`
  64. 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`
  65. 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`
  66. 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`, `<nil>`, ``, ``, `0`, `1`, `2023-03-15 11:56:57.3631958 +0800 CST`, `2023-03-15 11:56:57.3631958 +0800 CST`
  67. 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']
  68. 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`
  69. 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`
  70. 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`
  71. 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`
  72. 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`
  73. 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
  74. 类型:温度超上限预警
  75. SN:2023125067633148
  76. 主机:4G冰箱版3148
  77. 设备:4G冰箱板3148探头
  78. 备注:已持续 18分钟
  79. 通知方式:短信通知
  80. 通知对象:oZMR-6XVx-O5gsUDOnd45aCeVamM', '2023-03-15 11:57:06')]
  81. 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`
  82. 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
  83. 类型:温度超上限预警
  84. SN:2023125067633148
  85. 主机:4G冰箱版3148
  86. 设备:4G冰箱板3148探头
  87. 备注:已持续 18分钟
  88. 通知方式:短信通知
  89. 通知对象:oZMR-6eyBpryepFcaFawH7n6b2ZI', '2023-03-15 11:57:07')]
  90. 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]
  91. [微信]持续时间:1081秒, 间隔时间:0秒, 内发送次数:0次, 间隔还剩时间:0秒
  92. ----> oZMR-6XVx-O5gsUDOnd45aCeVamM/bc测试->发送成功!
  93. ----> oZMR-6eyBpryepFcaFawH7n6b2ZI/小管理主机->发送成功!
  94. `, `2625246`, `3`, `2023-03-15 11:57:07.438703 +0800 CST`, `2023-03-15 11:57:07.438703 +0800 CST`
  95. 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`
  96. 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`
  97. 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`
  98. 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)]
  99. 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`
  100. 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`
  101. 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]
  102. `, `14230043`, `1`, `2023-03-15 11:57:16.9035034 +0800 CST`, `2023-03-15 11:57:16.9035034 +0800 CST`
  103. 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`
  104. 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`
  105. 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)]
  106. 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`
  107. 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)]
  108. 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`
  109. 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)]
  110. 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`, `<nil>`, ``, `{"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`
  111. 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)]
  112. 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`
  113. 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`, `<nil>`, ``, `{"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`
  114. 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`
  115. 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]
  116. [微信]持续时间:2秒, 间隔时间:0秒, 内发送次数:0次, 间隔还剩时间:0秒
  117. ----> oZMR-6XVx-O5gsUDOnd45aCeVamM/bc测试---->微信服务发送失败![{"errcode":47003,"errmsg":"argument invalid! data.short_thing7.value invali rid: 64114218-0f58bc41-658e3294"}]!尝试发送 1 次
  118. ---->微信服务发送失败![{"errcode":47003,"errmsg":"argument invalid! data.short_thing7.value invali rid: 6411421a-11cbb888-2aaddd12"}]!尝试发送 2 次
  119. ---->微信服务发送失败![{"errcode":47003,"errmsg":"argument invalid! data.short_thing7.value invali rid: 6411421c-3a74d883-400d89b8"}]!尝试发送 3 次
  120. ----> oZMR-6eyBpryepFcaFawH7n6b2ZI/小管理主机---->微信服务发送失败![{"errcode":47003,"errmsg":"argument invalid! data.short_thing7.value invali rid: 64114220-54c89746-3242eea3"}]!尝试发送 1 次
  121. ---->微信服务发送失败![{"errcode":47003,"errmsg":"argument invalid! data.short_thing7.value invali rid: 64114221-0d624cbb-58e87426"}]!尝试发送 2 次
  122. ---->微信服务发送失败![{"errcode":47003,"errmsg":"argument invalid! data.short_thing7.value invali rid: 64114224-37aad149-249863f1"}]!尝试发送 3 次
  123. `, `14230041`, `3`, `2023-03-15 11:57:27.5336745 +0800 CST`, `2023-03-15 11:57:27.5336745 +0800 CST`
  124. 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`
  125. 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)]
  126. 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`
  127. 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`
  128. 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`
  129. 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`
  130. 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`
  131. 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`
  132. 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`
  133. 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`
  134. 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`, `<nil>`, ``, ``, `0`, `1`, `2023-03-15 11:57:41.9336275 +0800 CST`, `2023-03-15 11:57:41.9336275 +0800 CST`
  135. 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']
  136. 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`
  137. 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`
  138. 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`
  139. 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%`
  140. 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`
  141. 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`
  142. 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]
  143. 通知 管理员ID列表 -> [31|]
  144. 通知-> [31|bzd_ceshi_123]
  145. -> bzd_ceshi_123[31]相同报警(30分钟内),跳过该用户通知
  146. 执行通知策略 ->[小管理主机测-wj]
  147. `, `14270060`, `3`, `2023-03-15 11:57:52.7116354 +0800 CST`, `2023-03-15 11:57:52.7116354 +0800 CST`
  148. 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`
  149. 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]
  150. `, `14270062`, `1`, `2023-03-15 11:57:53.4627886 +0800 CST`, `2023-03-15 11:57:53.4627886 +0800 CST`
  151. 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`
  152. 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`
  153. 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)]
  154. 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)]
  155. 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)]
  156. 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`
  157. 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`
  158. 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`
  159. 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
  160. 类型:温度超上限预警
  161. SN:2023125067633148
  162. 主机:4G冰箱版3148
  163. 设备:4G冰箱板3148探头
  164. 备注:已持续 19分钟
  165. 通知方式:短信通知
  166. 通知对象:oZMR-6XVx-O5gsUDOnd45aCeVamM', '2023-03-15 11:58:07')]
  167. 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
  168. 类型:温度超上限预警
  169. SN:2023125067633148
  170. 主机:4G冰箱版3148
  171. 设备:4G冰箱板3148探头
  172. 备注:已持续 19分钟
  173. 通知方式:短信通知
  174. 通知对象:oZMR-6eyBpryepFcaFawH7n6b2ZI', '2023-03-15 11:58:07')]
  175. 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]
  176. [微信]持续时间:1141秒, 间隔时间:0秒, 内发送次数:0次, 间隔还剩时间:0秒
  177. ----> oZMR-6XVx-O5gsUDOnd45aCeVamM/bc测试->发送成功!
  178. ----> oZMR-6eyBpryepFcaFawH7n6b2ZI/小管理主机->发送成功!
  179. `, `2685255`, `3`, `2023-03-15 11:58:07.4989209 +0800 CST`, `2023-03-15 11:58:07.4989209 +0800 CST`
  180. 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`
  181. 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]
  182. `, `14281070`, `1`, `2023-03-15 11:58:07.5526294 +0800 CST`, `2023-03-15 11:58:07.5526294 +0800 CST`
  183. 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`
  184. 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`
  185. 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`
  186. 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`
  187. 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`
  188. 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
  189. 类型:湿度超上限预警
  190. SN:2023125762710435
  191. 主机:4G冰箱冯测试
  192. 设备:4G冰箱冯测试01
  193. 备注:已持续 2分钟
  194. 通知方式:短信通知
  195. 通知对象:oZMR-6XVx-O5gsUDOnd45aCeVamM', '2023-03-15 11:58:13')]
  196. 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`
  197. 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`
  198. 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`
  199. 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
  200. 类型:湿度超上限预警
  201. SN:2023125762710435
  202. 主机:4G冰箱冯测试
  203. 设备:4G冰箱冯测试01
  204. 备注:已持续 2分钟
  205. 通知方式:短信通知
  206. 通知对象:oZMR-6eyBpryepFcaFawH7n6b2ZI', '2023-03-15 11:58:13')]
  207. 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`
  208. 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`
  209. 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
  210. 类型:湿度超上限预警
  211. SN:2023125762710435
  212. 主机:4G冰箱冯测试
  213. 设备:4G冰箱冯测试01
  214. 备注:已持续 2分钟
  215. 通知方式:短信通知
  216. 通知对象:oZMR-6VfvmW0ocvZTIibBdsR7yyI', '2023-03-15 11:58:14')]
  217. 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`
  218. 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`
  219. 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
  220. 类型:湿度超上限预警
  221. SN:2023125762710435
  222. 主机:4G冰箱冯测试
  223. 设备:4G冰箱冯测试01
  224. 备注:已持续 2分钟
  225. 通知方式:短信通知
  226. 通知对象:oZMR-6XVx-O5gsUDOnd45aCeVamM', '2023-03-15 11:58:14')]
  227. 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
  228. 类型:湿度超上限预警
  229. SN:2023125762710435
  230. 主机:4G冰箱冯测试
  231. 设备:4G冰箱冯测试01
  232. 备注:已持续 2分钟
  233. 通知方式:短信通知
  234. 通知对象:oZMR-6eyBpryepFcaFawH7n6b2ZI', '2023-03-15 11:58:15')]
  235. 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]
  236. [微信]持续时间:120秒, 间隔时间:0秒, 内发送次数:0次, 间隔还剩时间:0秒
  237. ----> oZMR-6XVx-O5gsUDOnd45aCeVamM/bc测试->发送成功!
  238. ----> oZMR-6eyBpryepFcaFawH7n6b2ZI/小管理主机->发送成功!
  239. 执行通知策略 ->[冰箱版测试]
  240. [微信]持续时间:121秒, 间隔时间:0秒, 内发送次数:0次, 间隔还剩时间:0秒
  241. ----> oZMR-6VfvmW0ocvZTIibBdsR7yyI/冯靖沣->发送成功!
  242. 执行通知策略 ->[小管理主机测-wj]
  243. [微信]持续时间:122秒, 间隔时间:0秒, 内发送次数:0次, 间隔还剩时间:0秒
  244. ----> oZMR-6XVx-O5gsUDOnd45aCeVamM/bc测试->发送成功!
  245. ----> oZMR-6eyBpryepFcaFawH7n6b2ZI/小管理主机->发送成功!
  246. `, `2692690`, `3`, `2023-03-15 11:58:15.4381035 +0800 CST`, `2023-03-15 11:58:15.4381035 +0800 CST`
  247. 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`
  248. 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]
  249. `, `14291075`, `1`, `2023-03-15 11:58:17.595551 +0800 CST`, `2023-03-15 11:58:17.595551 +0800 CST`
  250. 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`
  251. 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)]
  252. 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)]
  253. 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)]
  254. 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`
  255. 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`
  256. 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`
  257. 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)]
  258. 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`
  259. 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`, `<nil>`, ``, `{"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`
  260. 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)]
  261. 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`
  262. 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`, `<nil>`, ``, `{"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`
  263. 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]
  264. [微信]持续时间:2秒, 间隔时间:0秒, 内发送次数:0次, 间隔还剩时间:0秒
  265. ----> oZMR-6XVx-O5gsUDOnd45aCeVamM/bc测试---->微信服务发送失败![{"errcode":47003,"errmsg":"argument invalid! data.short_thing7.value invali rid: 64114255-3233c9db-592af667"}]!尝试发送 1 次
  266. ---->微信服务发送失败![{"errcode":47003,"errmsg":"argument invalid! data.short_thing7.value invali rid: 64114257-5e5d5365-60cad5f7"}]!尝试发送 2 次
  267. ---->微信服务发送失败![{"errcode":47003,"errmsg":"argument invalid! data.short_thing7.value invali rid: 64114259-57db5558-2bea901c"}]!尝试发送 3 次
  268. ----> oZMR-6eyBpryepFcaFawH7n6b2ZI/小管理主机---->微信服务发送失败![{"errcode":47003,"errmsg":"argument invalid! data.short_thing7.value invali rid: 6411425d-71ca000b-3176fc60"}]!尝试发送 1 次
  269. ---->微信服务发送失败![{"errcode":47003,"errmsg":"argument invalid! data.short_thing7.value invali rid: 6411425e-12ccf337-0670b013"}]!尝试发送 2 次
  270. ---->微信服务发送失败![{"errcode":47003,"errmsg":"argument invalid! data.short_thing7.value invali rid: 64114261-4444affc-5c8f75e3"}]!尝试发送 3 次
  271. `, `14291073`, `3`, `2023-03-15 11:58:28.6714073 +0800 CST`, `2023-03-15 11:58:28.6714073 +0800 CST`
  272. 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`
  273. 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`
  274. 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`
  275. 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`
  276. 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`
  277. 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`
  278. 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`
  279. 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`
  280. 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`
  281. 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`
  282. 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`
  283. 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`
  284. 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
  285. 类型:温度超上限预警
  286. SN:2023125067633148
  287. 主机:4G冰箱版3148
  288. 设备:4G冰箱板3148探头
  289. 备注:已持续 20分钟
  290. 通知方式:短信通知
  291. 通知对象:oZMR-6XVx-O5gsUDOnd45aCeVamM', '2023-03-15 11:59:06')]
  292. 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
  293. 类型:温度超上限预警
  294. SN:2023125067633148
  295. 主机:4G冰箱版3148
  296. 设备:4G冰箱板3148探头
  297. 备注:已持续 20分钟
  298. 通知方式:短信通知
  299. 通知对象:oZMR-6eyBpryepFcaFawH7n6b2ZI', '2023-03-15 11:59:07')]
  300. 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]
  301. [微信]持续时间:1201秒, 间隔时间:0秒, 内发送次数:0次, 间隔还剩时间:0秒
  302. ----> oZMR-6XVx-O5gsUDOnd45aCeVamM/bc测试->发送成功!
  303. ----> oZMR-6eyBpryepFcaFawH7n6b2ZI/小管理主机->发送成功!
  304. `, `2745264`, `3`, `2023-03-15 11:59:07.3247949 +0800 CST`, `2023-03-15 11:59:07.3247949 +0800 CST`
  305. 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`
  306. 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`
  307. 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`
  308. 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`
  309. 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`
  310. 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
  311. 类型:湿度恢复正常
  312. SN:2023105182699608
  313. 主机:小管理主机2号-测试样机
  314. 设备:办公室测试2-1
  315. 备注:已持续 58秒
  316. 通知方式:短信通知
  317. 通知对象:oZMR-6XVx-O5gsUDOnd45aCeVamM', '2023-03-15 11:59:12')]
  318. 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
  319. 类型:湿度恢复正常
  320. SN:2023105182699608
  321. 主机:小管理主机2号-测试样机
  322. 设备:办公室测试2-1
  323. 备注:已持续 58秒
  324. 通知方式:短信通知
  325. 通知对象:oZMR-6eyBpryepFcaFawH7n6b2ZI', '2023-03-15 11:59:13')]
  326. 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]
  327. [微信]持续时间:61秒, 间隔时间:0秒, 内发送次数:0次, 间隔还剩时间:0秒
  328. ----> oZMR-6XVx-O5gsUDOnd45aCeVamM/bc测试->发送成功!
  329. ----> oZMR-6eyBpryepFcaFawH7n6b2ZI/小管理主机->发送成功!
  330. `, `14349099`, `3`, `2023-03-15 11:59:13.1387858 +0800 CST`, `2023-03-15 11:59:13.1387858 +0800 CST`
  331. 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`
  332. 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]
  333. `, `14349101`, `1`, `2023-03-15 11:59:14.4538154 +0800 CST`, `2023-03-15 11:59:14.4538154 +0800 CST`
  334. 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)]
  335. 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)]
  336. 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`
  337. 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`
  338. 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`
  339. 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`
  340. 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
  341. 类型:湿度超上限预警
  342. SN:2023105182699608
  343. 主机:小管理主机2号-测试样机
  344. 设备:办公室测试2-1
  345. 备注:已持续 1分钟 3秒
  346. 通知方式:短信通知
  347. 通知对象:oZMR-6XVx-O5gsUDOnd45aCeVamM', '2023-03-15 11:59:17')]
  348. 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)]
  349. 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
  350. 类型:湿度超上限预警
  351. SN:2023105182699608
  352. 主机:小管理主机2号-测试样机
  353. 设备:办公室测试2-1
  354. 备注:已持续 1分钟 3秒
  355. 通知方式:短信通知
  356. 通知对象:oZMR-6eyBpryepFcaFawH7n6b2ZI', '2023-03-15 11:59:17')]
  357. 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`
  358. 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]
  359. [微信]持续时间:65秒, 间隔时间:0秒, 内发送次数:0次, 间隔还剩时间:0秒
  360. ----> oZMR-6XVx-O5gsUDOnd45aCeVamM/bc测试->发送成功!
  361. ----> oZMR-6eyBpryepFcaFawH7n6b2ZI/小管理主机->发送成功!
  362. `, `14354103`, `3`, `2023-03-15 11:59:17.7456178 +0800 CST`, `2023-03-15 11:59:17.7456178 +0800 CST`
  363. 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)]
  364. 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`
  365. 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`
  366. 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]
  367. `, `14354105`, `1`, `2023-03-15 11:59:19.0252007 +0800 CST`, `2023-03-15 11:59:19.0252007 +0800 CST`
  368. 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)]
  369. 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`
  370. 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`
  371. 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)]
  372. 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`
  373. 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`
  374. 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`
  375. 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)]
  376. 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`
  377. 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`
  378. 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`
  379. 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`
  380. 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`
  381. 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`
  382. 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`
  383. 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)]
  384. 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)]
  385. 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)]
  386. 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`
  387. 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`
  388. 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`
  389. 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
  390. 类型:温度超上限预警
  391. SN:2023125067633148
  392. 主机:4G冰箱版3148
  393. 设备:4G冰箱板3148探头
  394. 备注:已持续 21分钟
  395. 通知方式:短信通知
  396. 通知对象:oZMR-6XVx-O5gsUDOnd45aCeVamM', '2023-03-15 12:00:07')]
  397. 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
  398. 类型:温度超上限预警
  399. SN:2023125067633148
  400. 主机:4G冰箱版3148
  401. 设备:4G冰箱板3148探头
  402. 备注:已持续 21分钟
  403. 通知方式:短信通知
  404. 通知对象:oZMR-6eyBpryepFcaFawH7n6b2ZI', '2023-03-15 12:00:07')]
  405. 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]
  406. [微信]持续时间:1261秒, 间隔时间:0秒, 内发送次数:0次, 间隔还剩时间:0秒
  407. ----> oZMR-6XVx-O5gsUDOnd45aCeVamM/bc测试->发送成功!
  408. ----> oZMR-6eyBpryepFcaFawH7n6b2ZI/小管理主机->发送成功!
  409. `, `2805273`, `3`, `2023-03-15 12:00:07.4586871 +0800 CST`, `2023-03-15 12:00:07.4586871 +0800 CST`
  410. 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`
  411. 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]
  412. `, `14401128`, `1`, `2023-03-15 12:00:07.6739599 +0800 CST`, `2023-03-15 12:00:07.6739599 +0800 CST`
  413. 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`
  414. 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`
  415. 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`
  416. 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`
  417. 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`
  418. 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
  419. 类型:湿度超上限预警
  420. SN:2023125762710435
  421. 主机:4G冰箱冯测试
  422. 设备:4G冰箱冯测试01
  423. 备注:已持续 4分钟
  424. 通知方式:短信通知
  425. 通知对象:oZMR-6XVx-O5gsUDOnd45aCeVamM', '2023-03-15 12:00:13')]
  426. 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
  427. 类型:湿度超上限预警
  428. SN:2023125762710435
  429. 主机:4G冰箱冯测试
  430. 设备:4G冰箱冯测试01
  431. 备注:已持续 4分钟
  432. 通知方式:短信通知
  433. 通知对象:oZMR-6eyBpryepFcaFawH7n6b2ZI', '2023-03-15 12:00:13')]
  434. 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`
  435. 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`
  436. 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
  437. 类型:湿度超上限预警
  438. SN:2023125762710435
  439. 主机:4G冰箱冯测试
  440. 设备:4G冰箱冯测试01
  441. 备注:已持续 4分钟
  442. 通知方式:短信通知
  443. 通知对象:oZMR-6VfvmW0ocvZTIibBdsR7yyI', '2023-03-15 12:00:14')]
  444. 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`
  445. 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`
  446. 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
  447. 类型:湿度超上限预警
  448. SN:2023125762710435
  449. 主机:4G冰箱冯测试
  450. 设备:4G冰箱冯测试01
  451. 备注:已持续 4分钟
  452. 通知方式:短信通知
  453. 通知对象:oZMR-6XVx-O5gsUDOnd45aCeVamM', '2023-03-15 12:00:14')]
  454. 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
  455. 类型:湿度超上限预警
  456. SN:2023125762710435
  457. 主机:4G冰箱冯测试
  458. 设备:4G冰箱冯测试01
  459. 备注:已持续 4分钟
  460. 通知方式:短信通知
  461. 通知对象:oZMR-6eyBpryepFcaFawH7n6b2ZI', '2023-03-15 12:00:15')]
  462. 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]
  463. [微信]持续时间:240秒, 间隔时间:0秒, 内发送次数:0次, 间隔还剩时间:0秒
  464. ----> oZMR-6XVx-O5gsUDOnd45aCeVamM/bc测试->发送成功!
  465. ----> oZMR-6eyBpryepFcaFawH7n6b2ZI/小管理主机->发送成功!
  466. 执行通知策略 ->[冰箱版测试]
  467. [微信]持续时间:241秒, 间隔时间:0秒, 内发送次数:0次, 间隔还剩时间:0秒
  468. ----> oZMR-6VfvmW0ocvZTIibBdsR7yyI/冯靖沣->发送成功!
  469. 执行通知策略 ->[小管理主机测-wj]
  470. [微信]持续时间:242秒, 间隔时间:0秒, 内发送次数:0次, 间隔还剩时间:0秒
  471. ----> oZMR-6XVx-O5gsUDOnd45aCeVamM/bc测试->发送成功!
  472. ----> oZMR-6eyBpryepFcaFawH7n6b2ZI/小管理主机->发送成功!
  473. `, `2812705`, `3`, `2023-03-15 12:00:15.2969074 +0800 CST`, `2023-03-15 12:00:15.2969074 +0800 CST`
  474. 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`
  475. 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`
  476. 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]
  477. `, `14413134`, `1`, `2023-03-15 12:00:16.5696204 +0800 CST`, `2023-03-15 12:00:16.5696204 +0800 CST`
  478. 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)]
  479. 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`
  480. 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)]
  481. 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`
  482. 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`
  483. 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]
  484. `, `14417136`, `1`, `2023-03-15 12:00:19.9320007 +0800 CST`, `2023-03-15 12:00:19.9320007 +0800 CST`
  485. 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`
  486. 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`
  487. 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`
  488. 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
  489. 类型:传感器故障报警
  490. SN:2023105182699608
  491. 主机:小管理主机2号-测试样机
  492. 设备:小管理主机2号-测试样机
  493. 备注:终端[28]掉线,请检查
  494. 通知方式:短信通知
  495. 通知对象:oZMR-6XVx-O5gsUDOnd45aCeVamM', '2023-03-15 12:00:21')]
  496. 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)]
  497. 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`
  498. 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
  499. 类型:传感器故障报警
  500. SN:2023105182699608
  501. 主机:小管理主机2号-测试样机
  502. 设备:小管理主机2号-测试样机
  503. 备注:终端[28]掉线,请检查
  504. 通知方式:短信通知
  505. 通知对象:oZMR-6eyBpryepFcaFawH7n6b2ZI', '2023-03-15 12:00:21')]
  506. 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]
  507. [微信]持续时间:2秒, 间隔时间:0秒, 内发送次数:0次, 间隔还剩时间:0秒
  508. ----> oZMR-6XVx-O5gsUDOnd45aCeVamM/bc测试->发送成功!
  509. ----> oZMR-6eyBpryepFcaFawH7n6b2ZI/小管理主机->发送成功!
  510. `, `14418138`, `3`, `2023-03-15 12:00:21.7053373 +0800 CST`, `2023-03-15 12:00:21.7053373 +0800 CST`
  511. 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`
  512. 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`
  513. 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`
  514. 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`
  515. 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`
  516. 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
  517. 类型:传感器故障报警
  518. SN:2023105182699608
  519. 主机:小管理主机2号-测试样机
  520. 设备:小管理主机2号-测试样机
  521. 备注:终端[28]掉线,请检查
  522. 通知方式:短信通知
  523. 通知对象:oZMR-6XVx-O5gsUDOnd45aCeVamM', '2023-03-15 12:00:22')]
  524. 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
  525. 类型:传感器故障报警
  526. SN:2023105182699608
  527. 主机:小管理主机2号-测试样机
  528. 设备:小管理主机2号-测试样机
  529. 备注:终端[28]掉线,请检查
  530. 通知方式:短信通知
  531. 通知对象:oZMR-6eyBpryepFcaFawH7n6b2ZI', '2023-03-15 12:00:23')]
  532. 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]
  533. [微信]持续时间:4秒, 间隔时间:0秒, 内发送次数:0次, 间隔还剩时间:0秒
  534. ----> oZMR-6XVx-O5gsUDOnd45aCeVamM/bc测试->发送成功!
  535. ----> oZMR-6eyBpryepFcaFawH7n6b2ZI/小管理主机->发送成功!
  536. `, `14418140`, `3`, `2023-03-15 12:00:23.4827956 +0800 CST`, `2023-03-15 12:00:23.4827956 +0800 CST`
  537. 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`
  538. 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]
  539. `, `14418142`, `1`, `2023-03-15 12:00:23.9799966 +0800 CST`, `2023-03-15 12:00:23.9799966 +0800 CST`
  540. 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`
  541. 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`
  542. 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`
  543. 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
  544. 类型:传感器故障报警
  545. SN:2023105182699608
  546. 主机:小管理主机2号-测试样机
  547. 设备:小管理主机2号-测试样机
  548. 备注:终端[28]掉线,请检查
  549. 通知方式:短信通知
  550. 通知对象:oZMR-6XVx-O5gsUDOnd45aCeVamM', '2023-03-15 12:00:28')]
  551. 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
  552. 类型:传感器故障报警
  553. SN:2023105182699608
  554. 主机:小管理主机2号-测试样机
  555. 设备:小管理主机2号-测试样机
  556. 备注:终端[28]掉线,请检查
  557. 通知方式:短信通知
  558. 通知对象:oZMR-6eyBpryepFcaFawH7n6b2ZI', '2023-03-15 12:00:28')]
  559. 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]
  560. [微信]持续时间:2秒, 间隔时间:0秒, 内发送次数:0次, 间隔还剩时间:0秒
  561. ----> oZMR-6XVx-O5gsUDOnd45aCeVamM/bc测试->发送成功!
  562. ----> oZMR-6eyBpryepFcaFawH7n6b2ZI/小管理主机->发送成功!
  563. `, `14425145`, `3`, `2023-03-15 12:00:28.6432962 +0800 CST`, `2023-03-15 12:00:28.6432962 +0800 CST`
  564. 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`
  565. 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`
  566. 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`
  567. 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
  568. 类型:传感器故障报警
  569. SN:2023105182699608
  570. 主机:小管理主机2号-测试样机
  571. 设备:小管理主机2号-测试样机
  572. 备注:终端[28]掉线,请检查
  573. 通知方式:短信通知
  574. 通知对象:oZMR-6XVx-O5gsUDOnd45aCeVamM', '2023-03-15 12:00:29')]
  575. 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
  576. 类型:传感器故障报警
  577. SN:2023105182699608
  578. 主机:小管理主机2号-测试样机
  579. 设备:小管理主机2号-测试样机
  580. 备注:终端[28]掉线,请检查
  581. 通知方式:短信通知
  582. 通知对象:oZMR-6eyBpryepFcaFawH7n6b2ZI', '2023-03-15 12:00:30')]
  583. 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]
  584. [微信]持续时间:4秒, 间隔时间:0秒, 内发送次数:0次, 间隔还剩时间:0秒
  585. ----> oZMR-6XVx-O5gsUDOnd45aCeVamM/bc测试->发送成功!
  586. ----> oZMR-6eyBpryepFcaFawH7n6b2ZI/小管理主机->发送成功!
  587. `, `14425147`, `3`, `2023-03-15 12:00:30.3850835 +0800 CST`, `2023-03-15 12:00:30.3850835 +0800 CST`
  588. 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`
  589. 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]
  590. `, `14425149`, `1`, `2023-03-15 12:00:30.8974112 +0800 CST`, `2023-03-15 12:00:30.8974112 +0800 CST`
  591. 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`
  592. 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`
  593. 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`
  594. 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`
  595. 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`
  596. 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
  597. 类型:传感器故障报警
  598. SN:2023105182699608
  599. 主机:小管理主机2号-测试样机
  600. 设备:小管理主机2号-测试样机
  601. 备注:终端[28]掉线,请检查
  602. 通知方式:短信通知
  603. 通知对象:oZMR-6XVx-O5gsUDOnd45aCeVamM', '2023-03-15 12:00:34')]
  604. 2024/04/12 15:25:50.035
  605. WarningBack:sqlC:/BZD/Cold/Cold_mqtt/models/Warning/WarningBack.go:7514.2466ms select * from information_schema.TABLES where TABLE_NAME = ? ;[warning_2024_04] 0
  606. 2024/04/12 15:25:50.053
  607. WarningBack:sqlC:/BZD/Cold/Cold_mqtt/models/Warning/WarningBack.go:9317.3078msINSERT INTO warning_2024_04 SELECT * FROM warning WHERE ID = ? ;[25519881] 1
  608. 2024/04/12 15:28:06.925
  609. WarningBack:sqlC:/BZD/Cold/Cold_mqtt/models/Warning/WarningBack.go:7514.3566ms select * from information_schema.TABLES where TABLE_NAME = ? ;[warning_2024_04] 0
  610. 2024/04/12 15:28:06.951
  611. WarningBack:sqlC:/BZD/Cold/Cold_mqtt/models/Warning/WarningBack.go:9326.0461msINSERT INTO warning_2024_04 SELECT * FROM warning WHERE ID = ? ;[25519959] 1
  612. 2024/04/12 15:28:06.992
  613. WarningBack:sqlC:/BZD/Cold/Cold_mqtt/models/Warning/WarningBack.go:9810.1024msUPDATE warning_2024_04 SET t__log = ? WHERE ID = ? ;[ 25519959] 0
  614. 2024/04/12 15:31:05.040
  615. WarningBack:sqlC:/BZD/Cold/Cold_mqtt/models/Warning/WarningBack.go:9815.9089msUPDATE warning_2024_04 SET t__log = ? WHERE ID = ? ;[执行通知策略 ->[库房温湿度报警] [15:31:04]
  616. [电话]持续时间:79727秒, 间隔时间:0秒, 内发送次数:0次, 间隔还剩时间:0秒
  617. 25519959] 1
  618. 2024/04/12 15:40:52.171
  619. WarningBack:sqlC:/BZD/Cold/Cold_mqtt/models/Warning/WarningBack.go:7511.9253ms select * from information_schema.TABLES where TABLE_NAME = ? ;[warning_2024_04] 0
  620. 2024/04/12 15:40:52.188
  621. WarningBack:sqlC:/BZD/Cold/Cold_mqtt/models/Warning/WarningBack.go:9316.2367msINSERT INTO warning_2024_04 SELECT * FROM warning WHERE ID = ? ;[25520343] 1
  622. 2024/04/12 15:40:52.213
  623. WarningBack:sqlC:/BZD/Cold/Cold_mqtt/models/Warning/WarningBack.go:989.9292msUPDATE warning_2024_04 SET t__log = ? WHERE ID = ? ;[ 25520343] 0
  624. 2024/04/12 15:40:55.725
  625. WarningBack:sqlC:/BZD/Cold/Cold_mqtt/models/Warning/WarningBack.go:9816.1077msUPDATE warning_2024_04 SET t__log = ? WHERE ID = ? ;[执行通知策略 ->[库房温湿度报警] [15:40:55]
  626. [电话]持续时间:80318秒, 间隔时间:0秒, 内发送次数:0次, 间隔还剩时间:0秒
  627. 25520343] 1
  628. 2024/04/12 15:42:00.212
  629. WarningBack:sqlC:/BZD/Cold/Cold_mqtt/models/Warning/WarningBack.go:7512.3595ms select * from information_schema.TABLES where TABLE_NAME = ? ;[warning_2024_04] 0
  630. 2024/04/12 15:42:00.228
  631. WarningBack:sqlC:/BZD/Cold/Cold_mqtt/models/Warning/WarningBack.go:9315.6283msINSERT INTO warning_2024_04 SELECT * FROM warning WHERE ID = ? ;[25520366] 1
  632. 2024/04/12 15:42:00.265
  633. WarningBack:sqlC:/BZD/Cold/Cold_mqtt/models/Warning/WarningBack.go:9810.1496msUPDATE warning_2024_04 SET t__log = ? WHERE ID = ? ;[ 25520366] 0
  634. 2024/04/12 15:52:28.436
  635. WarningBack:sqlC:/BZD/Cold/Cold_mqtt/models/Warning/WarningBack.go:7523.1192ms select * from information_schema.TABLES where TABLE_NAME = ? ;[warning_2024_04] 0
  636. 2024/04/12 15:52:28.452
  637. WarningBack:sqlC:/BZD/Cold/Cold_mqtt/models/Warning/WarningBack.go:9315.0646msINSERT INTO warning_2024_04 SELECT * FROM warning WHERE ID = ? ;[25520651] 1
  638. 2024/04/12 15:52:28.478
  639. WarningBack:sqlC:/BZD/Cold/Cold_mqtt/models/Warning/WarningBack.go:989.791msUPDATE warning_2024_04 SET t__log = ? WHERE ID = ? ;[ 25520651] 0
  640. 2024/04/12 16:44:07.897
  641. WarningBack:sqlC:/BZD/Cold/Cold_mqtt/models/Warning/WarningBack.go:7529.8757ms select * from information_schema.TABLES where TABLE_NAME = ? ;[warning_2024_04] 0
  642. 2024/04/12 16:44:07.927
  643. WarningBack:sqlC:/BZD/Cold/Cold_mqtt/models/Warning/WarningBack.go:9329.6982msINSERT INTO warning_2024_04 SELECT * FROM warning WHERE ID = ? ;[25522057] 1
  644. 2024/04/12 16:44:07.965
  645. WarningBack:sqlC:/BZD/Cold/Cold_mqtt/models/Warning/WarningBack.go:9821.5689msUPDATE warning_2024_04 SET t__log = ? WHERE ID = ? ;[ 25522057] 0
  646. 2024/04/12 16:44:08.039
  647. WarningBack:sqlC:/BZD/Cold/Cold_mqtt/models/Warning/WarningBack.go:9830.3916msUPDATE warning_2024_04 SET t__log = ? WHERE ID = ? ;[执行通知策略 ->[库房温湿度报警] [16:44:07]
  648. 25522057] 1
  649. 2024/04/12 16:44:08.124
  650. WarningBack:sqlC:/BZD/Cold/Cold_mqtt/models/Warning/WarningBack.go:9322.4495msINSERT INTO warning_2024_04 SELECT * FROM warning WHERE ID = ? ;[25522059] 1
  651. 2024/04/12 16:44:08.158
  652. WarningBack:sqlC:/BZD/Cold/Cold_mqtt/models/Warning/WarningBack.go:989.8911msUPDATE warning_2024_04 SET t__log = ? WHERE ID = ? ;[ 25522059] 0
  653. 2024/04/12 16:44:08.225
  654. WarningBack:sqlC:/BZD/Cold/Cold_mqtt/models/Warning/WarningBack.go:9825.226msUPDATE warning_2024_04 SET t__log = ? WHERE ID = ? ;[执行通知策略 ->[库房温湿度报警] [16:44:08]
  655. 25522059] 1