sql-2025-12-16.log 8.0 KB

12345678910111213141516171819202122232425262728293031
  1. [2025-12-16T09:59:49.600689+08:00] sql.INFO: select `bill_code`, `batch_no`, `drug_id`, `drug_name`, `crt_date`, `seal_report_url`, `report_name` from `drug_report_ass` where (`seal_report_url` != ) order by `id` desc ["RunTime:37.35ms"] []
  2. [2025-12-16T10:00:49.804948+08:00] sql.INFO: select `bill_code`, `batch_no`, `drug_id`, `drug_name`, `crt_date`, `seal_report_url`, `report_name` from `drug_report_ass` where (`seal_report_url` != ) order by `id` desc ["RunTime:13.67ms"] []
  3. [2025-12-16T10:38:14.090319+08:00] sql.INFO: select `bill_code`, `batch_no`, `drug_id`, `drug_name`, `crt_date`, `seal_report_url`, `report_name` from `drug_report_ass` where (`seal_report_url` != ) order by `id` desc ["RunTime:9.61ms"] []
  4. [2025-12-16T10:39:14.086482+08:00] sql.INFO: select `bill_code`, `batch_no`, `drug_id`, `drug_name`, `crt_date`, `seal_report_url`, `report_name` from `drug_report_ass` where (`seal_report_url` != ) order by `id` desc ["RunTime:23.43ms"] []
  5. [2025-12-16T10:40:27.077670+08:00] sql.INFO: select `bill_code`, `batch_no`, `drug_id`, `drug_name`, `crt_date`, `seal_report_url`, `report_name` from `drug_report_ass` where (`seal_report_url` != ) order by `id` desc ["RunTime:11.6ms"] []
  6. [2025-12-16T10:41:57.328910+08:00] sql.INFO: select `bill_code`, `batch_no`, `drug_id`, `drug_name`, `crt_date`, `seal_report_url`, `report_name` from `drug_report_ass` where (`seal_report_url` != ) order by `id` desc ["RunTime:9.6ms"] []
  7. [2025-12-16T10:47:43.370649+08:00] sql.INFO: select count(*) as aggregate from `drug_report_ass` ["RunTime:7.34ms"] []
  8. [2025-12-16T10:47:43.377204+08:00] sql.INFO: select * from `drug_report_ass` order by `id` desc limit 10 offset 0 ["RunTime:1.44ms"] []
  9. [2025-12-16T10:48:09.793778+08:00] sql.INFO: select count(*) as aggregate from `drug_report_ass` ["RunTime:7.24ms"] []
  10. [2025-12-16T10:48:09.797862+08:00] sql.INFO: select * from `drug_report_ass` order by `id` desc limit 10 offset 0 ["RunTime:1.13ms"] []
  11. [2025-12-16T10:49:27.160612+08:00] sql.INFO: select `bill_code`, `batch_no`, `drug_id`, `drug_name`, `crt_date`, `seal_report_url`, `report_name` from `drug_report_ass` where (`seal_report_url` != ) and `id` in (1, 2, 3) order by `id` desc ["RunTime:24.96ms"] []
  12. [2025-12-16T11:01:57.431533+08:00] sql.INFO: select `bill_code`, `batch_no`, `drug_id`, `drug_name`, `crt_date`, `seal_report_url`, `report_name` from `drug_report_ass` where (`seal_report_url` != ) order by `id` desc ["RunTime:10.42ms"] []
  13. [2025-12-16T11:02:57.448309+08:00] sql.INFO: select `bill_code`, `batch_no`, `drug_id`, `drug_name`, `crt_date`, `seal_report_url`, `report_name` from `drug_report_ass` where (`seal_report_url` != ) order by `id` desc ["RunTime:9.92ms"] []
  14. [2025-12-16T11:08:21.611011+08:00] sql.INFO: select `bill_code`, `batch_no`, `drug_id`, `drug_name`, `crt_date`, `seal_report_url`, `report_name` from `drug_report_ass` where (`seal_report_url` != ) order by `id` desc ["RunTime:2.91ms"] []
  15. [2025-12-16T11:09:21.681562+08:00] sql.INFO: select `bill_code`, `batch_no`, `drug_id`, `drug_name`, `crt_date`, `seal_report_url`, `report_name` from `drug_report_ass` where (`seal_report_url` != ) order by `id` desc ["RunTime:2.48ms"] []
  16. [2025-12-16T15:42:16.218671+08:00] sql.INFO: update `drug_report_ass` set `drug_report_sign_status` = 3, `signed_time` = 2025-12-16 10:30:00, `update_time` = 1765870935 where (`batch_no` = 2511012S and `drug_id` = 62cf8a6ee4b06a196076bda6 and `bill_detail_id` = 155391091799 and `bill_id` = 152890891572) ["RunTime:25.11ms"] []
  17. [2025-12-16T15:53:28.282462+08:00] sql.INFO: update `drug_report_ass` set `drug_report_sign_status` = 3, `signed_time` = 1765852200, `update_time` = 1765871607 where (`batch_no` = 2511012S and `drug_id` = 62cf8a6ee4b06a196076bda6 and `bill_detail_id` = 155391091799 and `bill_id` = 152890891572) ["RunTime:13.45ms"] []
  18. [2025-12-16T15:53:28.283451+08:00] sql.INFO: update `drug_report_ass` set `drug_report_sign_status` = 3, `signed_time` = 1765852201, `update_time` = 1765871607 where (`batch_no` = 2511010S and `drug_id` = 62cf8a6ee4b06a196076bda6 and `bill_detail_id` = 155417978838 and `bill_id` = 152897264973) ["RunTime:0.33ms"] []
  19. [2025-12-16T15:53:28.284313+08:00] sql.INFO: update `drug_report_ass` set `drug_report_sign_status` = 3, `signed_time` = 1765852201, `update_time` = 1765871607 where (`batch_no` = 2511011S and `drug_id` = 62cf8a6ee4b06a196076bda6 and `bill_detail_id` = 155417996801 and `bill_id` = 152897340278) ["RunTime:0.31ms"] []
  20. [2025-12-16T15:53:28.285164+08:00] sql.INFO: update `drug_report_ass` set `drug_report_sign_status` = 3, `signed_time` = 1765852341, `update_time` = 1765871607 where (`batch_no` = 2510026GN and `drug_id` = 00000000000006374505 and `bill_detail_id` = 155391613883 and `bill_id` = 152897576159) ["RunTime:0.36ms"] []
  21. [2025-12-16T15:53:28.285990+08:00] sql.INFO: update `drug_report_ass` set `drug_report_sign_status` = 3, `signed_time` = 1765852341, `update_time` = 1765871607 where (`batch_no` = 2510027GN and `drug_id` = 00000000000006374505 and `bill_detail_id` = 155391675136 and `bill_id` = 152897568271) ["RunTime:0.31ms"] []
  22. [2025-12-16T15:53:28.287033+08:00] sql.INFO: update `drug_report_ass` set `drug_report_sign_status` = 3, `signed_time` = 1765852341, `update_time` = 1765871607 where (`batch_no` = 2510031GN and `drug_id` = 00000000000006374505 and `bill_detail_id` = 155418608789 and `bill_id` = 152897544624) ["RunTime:0.48ms"] []
  23. [2025-12-16T15:53:28.287948+08:00] sql.INFO: update `drug_report_ass` set `drug_report_sign_status` = 3, `signed_time` = 1765852341, `update_time` = 1765871607 where (`batch_no` = 2510029GN and `drug_id` = 00000000000006374505 and `bill_detail_id` = 155391599865 and `bill_id` = 152897502996) ["RunTime:0.4ms"] []
  24. [2025-12-16T15:53:28.288716+08:00] sql.INFO: update `drug_report_ass` set `drug_report_sign_status` = 3, `signed_time` = 1765852341, `update_time` = 1765871607 where (`batch_no` = 2511001GN and `drug_id` = 00000000000006374505 and `bill_detail_id` = 155418612729 and `bill_id` = 152897572264) ["RunTime:0.34ms"] []
  25. [2025-12-16T15:53:28.289431+08:00] sql.INFO: update `drug_report_ass` set `drug_report_sign_status` = 3, `signed_time` = 1765852341, `update_time` = 1765871607 where (`batch_no` = 2510030GN and `drug_id` = 00000000000006374505 and `bill_detail_id` = 155391645704 and `bill_id` = 152897566277) ["RunTime:0.29ms"] []
  26. [2025-12-16T15:53:28.290067+08:00] sql.INFO: update `drug_report_ass` set `drug_report_sign_status` = 3, `signed_time` = 1765852341, `update_time` = 1765871607 where (`batch_no` = 2510028GN and `drug_id` = 00000000000006374505 and `bill_detail_id` = 155391653406 and `bill_id` = 152891113112) ["RunTime:0.27ms"] []
  27. [2025-12-16T15:53:28.290874+08:00] sql.INFO: update `drug_report_ass` set `drug_report_sign_status` = 3, `signed_time` = 1765852341, `update_time` = 1765871607 where (`batch_no` = 2510030GN and `drug_id` = 00000000000006374505 and `bill_detail_id` = 155391619652 and `bill_id` = 152891111153) ["RunTime:0.45ms"] []
  28. [2025-12-16T15:53:28.291423+08:00] sql.INFO: update `drug_report_ass` set `drug_report_sign_status` = 3, `signed_time` = 1765852342, `update_time` = 1765871607 where (`batch_no` = 2511002GN and `drug_id` = 00000000000006374505 and `bill_detail_id` = 155391655642 and `bill_id` = 152897542638) ["RunTime:0.22ms"] []
  29. [2025-12-16T15:53:28.291899+08:00] sql.INFO: update `drug_report_ass` set `drug_report_sign_status` = 3, `signed_time` = 1765852342, `update_time` = 1765871607 where (`batch_no` = 2510023GN and `drug_id` = 00000000000006374505 and `bill_detail_id` = 155391677303 and `bill_id` = 152897516985) ["RunTime:0.17ms"] []
  30. [2025-12-16T15:53:28.292417+08:00] sql.INFO: update `drug_report_ass` set `drug_report_sign_status` = 3, `signed_time` = 1765852342, `update_time` = 1765871607 where (`batch_no` = 2510025GN and `drug_id` = 00000000000006374505 and `bill_detail_id` = 155391621591 and `bill_id` = 152897522761) ["RunTime:0.2ms"] []
  31. [2025-12-16T15:53:28.292850+08:00] sql.INFO: update `drug_report_ass` set `drug_report_sign_status` = 3, `signed_time` = 1765852342, `update_time` = 1765871607 where (`batch_no` = 2510024GN and `drug_id` = 00000000000006374505 and `bill_detail_id` = 155391635745 and `bill_id` = 152897592021) ["RunTime:0.15ms"] []