push_mybatis.log 2.3 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051
  1. INFO 2021-06-24 14:16:16[scheduling-1] [sqlonly:228] - SELECT COUNT(*) AS CNT
  2. FROM PUSH_SCHEDULE
  3. WHERE SEND_STATE = 'W'
  4. AND SEND_TYPE != 'E'
  5. INFO 2021-06-24 14:16:16[scheduling-1] [sqlonly:228] - SELECT COUNT(*) AS cnt
  6. FROM PUSH_SCHEDULE PS,
  7. ( SELECT PS.PUSH_IDX AS push_idx,
  8. COUNT(*) TOTAL
  9. FROM PUSH_LOG
  10. WHERE PUSH_IDX = PS.PUSH_IDX
  11. AND DATE_FORMAT( START_DATE, '%Y-%M-%D' ) = DATE_FORMAT( NOW(), '%Y-%M-%D' ) ) PL
  12. WHERE PS.SEND_STATE = 'W'
  13. AND PS.SEND_TYPE = 'E'
  14. AND PL.PUSH_IDX = PS.push_idx
  15. AND PL.TOTAL = 0
  16. INFO 2021-06-24 14:16:47[scheduling-1] [sqlonly:228] - SELECT COUNT(*) AS CNT
  17. FROM PUSH_SCHEDULE
  18. WHERE SEND_STATE = 'W'
  19. AND SEND_TYPE != 'E'
  20. INFO 2021-06-24 14:16:47[scheduling-1] [sqlonly:228] - SELECT COUNT(*) AS cnt
  21. FROM PUSH_SCHEDULE PS,
  22. ( SELECT PS.PUSH_IDX AS push_idx,
  23. COUNT(*) TOTAL
  24. FROM PUSH_LOG
  25. WHERE PUSH_IDX = PS.PUSH_IDX
  26. AND DATE_FORMAT( START_DATE, '%Y-%M-%D' ) = DATE_FORMAT( NOW(), '%Y-%M-%D' ) ) PL
  27. WHERE PS.SEND_STATE = 'W'
  28. AND PS.SEND_TYPE = 'E'
  29. AND PL.PUSH_IDX = PS.push_idx
  30. AND PL.TOTAL = 0
  31. INFO 2021-06-24 14:17:16[scheduling-1] [sqlonly:228] - SELECT COUNT(*) AS CNT
  32. FROM PUSH_SCHEDULE
  33. WHERE SEND_STATE = 'W'
  34. AND SEND_TYPE != 'E'
  35. INFO 2021-06-24 14:17:16[scheduling-1] [sqlonly:228] - SELECT COUNT(*) AS cnt
  36. FROM PUSH_SCHEDULE PS,
  37. ( SELECT PS.PUSH_IDX AS push_idx,
  38. COUNT(*) TOTAL
  39. FROM PUSH_LOG
  40. WHERE PUSH_IDX = PS.PUSH_IDX
  41. AND DATE_FORMAT( START_DATE, '%Y-%M-%D' ) = DATE_FORMAT( NOW(), '%Y-%M-%D' ) ) PL
  42. WHERE PS.SEND_STATE = 'W'
  43. AND PS.SEND_TYPE = 'E'
  44. AND PL.PUSH_IDX = PS.push_idx
  45. AND PL.TOTAL = 0