2025-05-07T01:51:29.599Z DEBUG 2502 --- [Pool-1-worker-1] org.hibernate.SQL : select u1_0.id from app_user u1_0 where u1_0.email=? fetch first ? rows only
2025-05-07T01:51:29.601Z DEBUG 2502 --- [Pool-1-worker-5] org.hibernate.SQL : select u1_0.id from app_user u1_0 where u1_0.email=? fetch first ? rows only
2025-05-07T01:51:29.644Z DEBUG 2502 --- [Pool-1-worker-3] org.hibernate.SQL : insert into app_user (display_name,email,notifications_enabled,password,public_id,registration_time) values (?,?,?,?,?,?)
2025-05-07T01:51:29.650Z DEBUG 2502 --- [Pool-1-worker-3] org.hibernate.SQL : insert into notification (last_sent,user_id) values (?,?)
2025-05-07T01:51:29.651Z DEBUG 2502 --- [Pool-1-worker-3] org.hibernate.SQL : insert into user_role (user_id,role_id) values (?,?)
2025-05-07T01:51:29.655Z DEBUG 2502 --- [Pool-1-worker-3] org.hibernate.SQL : select u1_0.id,u1_0.display_name,u1_0.email,u1_0.notifications_enabled,u1_0.password,u1_0.public_id,u1_0.registration_time from app_user u1_0 where u1_0.email=?
2025-05-07T01:51:29.660Z DEBUG 2502 --- [Pool-1-worker-3] org.hibernate.SQL : select r1_0.user_id,r1_0.role_id from user_role r1_0 where r1_0.user_id=?
2025-05-07T01:51:29.888Z DEBUG 2502 --- [Pool-1-worker-1] org.hibernate.SQL : SELECT n.*
FROM notification n
JOIN app_user u ON u.id = n.user_id
WHERE n.last_sent < ?
AND u.notifications_enabled = TRUE
AND NOT EXISTS (
SELECT 1
FROM sleep_session s
WHERE s.user_id = u.id
AND s.stop_time > ?
)
FOR NO KEY UPDATE
2025-05-07T01:51:29.890Z DEBUG 2502 --- [Pool-1-worker-1] org.hibernate.SQL : SELECT n.*
FROM notification n
JOIN app_user u ON u.id = n.user_id
WHERE n.last_sent < ?
AND u.notifications_enabled = TRUE
AND NOT EXISTS (
SELECT 1
FROM sleep_session s
WHERE s.user_id = u.id
AND s.stop_time > ?
)
FOR NO KEY UPDATE
2025-05-07T01:51:29.893Z DEBUG 2502 --- [Pool-1-worker-1] org.hibernate.SQL : SELECT n.*
FROM notification n
JOIN app_user u ON u.id = n.user_id
WHERE n.last_sent < ?
AND u.notifications_enabled = TRUE
AND NOT EXISTS (
SELECT 1
FROM sleep_session s
WHERE s.user_id = u.id
AND s.stop_time > ?
)
FOR NO KEY UPDATE
2025-05-07T01:51:29.896Z DEBUG 2502 --- [Pool-1-worker-1] org.hibernate.SQL : SELECT n.*
FROM notification n
JOIN app_user u ON u.id = n.user_id
WHERE n.last_sent < ?
AND u.notifications_enabled = TRUE
AND NOT EXISTS (
SELECT 1
FROM sleep_session s
WHERE s.user_id = u.id
AND s.stop_time > ?
)
FOR NO KEY UPDATE
2025-05-07T01:51:29.901Z DEBUG 2502 --- [Pool-1-worker-5] org.hibernate.SQL : select u1_0.id from app_user u1_0 where u1_0.email=? fetch first ? rows only
2025-05-07T01:51:29.901Z DEBUG 2502 --- [Pool-1-worker-1] org.hibernate.SQL : SELECT n.*
FROM notification n
JOIN app_user u ON u.id = n.user_id
WHERE n.last_sent < ?
AND u.notifications_enabled = TRUE
AND NOT EXISTS (
SELECT 1
FROM sleep_session s
WHERE s.user_id = u.id
AND s.stop_time > ?
)
FOR NO KEY UPDATE
2025-05-07T01:51:29.903Z DEBUG 2502 --- [Pool-1-worker-1] org.hibernate.SQL : SELECT n.*
FROM notification n
JOIN app_user u ON u.id = n.user_id
WHERE n.last_sent < ?
AND u.notifications_enabled = TRUE
AND NOT EXISTS (
SELECT 1
FROM sleep_session s
WHERE s.user_id = u.id
AND s.stop_time > ?
)
FOR NO KEY UPDATE
2025-05-07T01:51:29.905Z DEBUG 2502 --- [Pool-1-worker-1] org.hibernate.SQL : SELECT n.*
FROM notification n
JOIN app_user u ON u.id = n.user_id
WHERE n.last_sent < ?
AND u.notifications_enabled = TRUE
AND NOT EXISTS (
SELECT 1
FROM sleep_session s
WHERE s.user_id = u.id
AND s.stop_time > ?
)
FOR NO KEY UPDATE
2025-05-07T01:51:29.911Z DEBUG 2502 --- [Pool-1-worker-1] org.hibernate.SQL : SELECT n.*
FROM notification n
JOIN app_user u ON u.id = n.user_id
WHERE n.last_sent < ?
AND u.notifications_enabled = TRUE
AND NOT EXISTS (
SELECT 1
FROM sleep_session s
WHERE s.user_id = u.id
AND s.stop_time > ?
)
FOR NO KEY UPDATE
2025-05-07T01:51:29.917Z DEBUG 2502 --- [Pool-1-worker-1] org.hibernate.SQL : SELECT n.*
FROM notification n
JOIN app_user u ON u.id = n.user_id
WHERE n.last_sent < ?
AND u.notifications_enabled = TRUE
AND NOT EXISTS (
SELECT 1
FROM sleep_session s
WHERE s.user_id = u.id
AND s.stop_time > ?
)
FOR NO KEY UPDATE
2025-05-07T01:51:29.921Z DEBUG 2502 --- [Pool-1-worker-1] org.hibernate.SQL : SELECT n.*
FROM notification n
JOIN app_user u ON u.id = n.user_id
WHERE n.last_sent < ?
AND u.notifications_enabled = TRUE
AND NOT EXISTS (
SELECT 1
FROM sleep_session s
WHERE s.user_id = u.id
AND s.stop_time > ?
)
FOR NO KEY UPDATE
2025-05-07T01:51:29.927Z DEBUG 2502 --- [Pool-1-worker-1] org.hibernate.SQL : SELECT n.*
FROM notification n
JOIN app_user u ON u.id = n.user_id
WHERE n.last_sent < ?
AND u.notifications_enabled = TRUE
AND NOT EXISTS (
SELECT 1
FROM sleep_session s
WHERE s.user_id = u.id
AND s.stop_time > ?
)
FOR NO KEY UPDATE
2025-05-07T01:51:29.928Z DEBUG 2502 --- [Pool-1-worker-1] org.hibernate.SQL : SELECT n.*
FROM notification n
JOIN app_user u ON u.id = n.user_id
WHERE n.last_sent < ?
AND u.notifications_enabled = TRUE
AND NOT EXISTS (
SELECT 1
FROM sleep_session s
WHERE s.user_id = u.id
AND s.stop_time > ?
)
FOR NO KEY UPDATE
2025-05-07T01:51:29.935Z DEBUG 2502 --- [Pool-1-worker-1] org.hibernate.SQL : SELECT n.*
FROM notification n
JOIN app_user u ON u.id = n.user_id
WHERE n.last_sent < ?
AND u.notifications_enabled = TRUE
AND NOT EXISTS (
SELECT 1
FROM sleep_session s
WHERE s.user_id = u.id
AND s.stop_time > ?
)
FOR NO KEY UPDATE
2025-05-07T01:51:29.939Z DEBUG 2502 --- [Pool-1-worker-1] org.hibernate.SQL : SELECT n.*
FROM notification n
JOIN app_user u ON u.id = n.user_id
WHERE n.last_sent < ?
AND u.notifications_enabled = TRUE
AND NOT EXISTS (
SELECT 1
FROM sleep_session s
WHERE s.user_id = u.id
AND s.stop_time > ?
)
FOR NO KEY UPDATE
2025-05-07T01:51:29.944Z DEBUG 2502 --- [Pool-1-worker-1] org.hibernate.SQL : select u1_0.id,u1_0.display_name,u1_0.email,u1_0.notifications_enabled,u1_0.password,u1_0.public_id,u1_0.registration_time from app_user u1_0 where u1_0.public_id=?
2025-05-07T01:51:29.957Z DEBUG 2502 --- [Pool-1-worker-1] org.hibernate.SQL : insert into sleep_session (minutes_asleep,minutes_awake,notes,start_time,stop_time,user_id,zone_id,id) values (?,?,?,?,?,?,?,?)
2025-05-07T01:51:29.963Z DEBUG 2502 --- [Pool-1-worker-1] org.hibernate.SQL : SELECT n.*
FROM notification n
JOIN app_user u ON u.id = n.user_id
WHERE n.last_sent < ?
AND u.notifications_enabled = TRUE
AND NOT EXISTS (
SELECT 1
FROM sleep_session s
WHERE s.user_id = u.id
AND s.stop_time > ?
)
FOR NO KEY UPDATE
2025-05-07T01:51:29.968Z DEBUG 2502 --- [Pool-1-worker-1] org.hibernate.SQL : SELECT n.*
FROM notification n
JOIN app_user u ON u.id = n.user_id
WHERE n.last_sent < ?
AND u.notifications_enabled = TRUE
AND NOT EXISTS (
SELECT 1
FROM sleep_session s
WHERE s.user_id = u.id
AND s.stop_time > ?
)
FOR NO KEY UPDATE
2025-05-07T01:51:29.973Z DEBUG 2502 --- [Pool-1-worker-1] org.hibernate.SQL : SELECT n.*
FROM notification n
JOIN app_user u ON u.id = n.user_id
WHERE n.last_sent < ?
AND u.notifications_enabled = TRUE
AND NOT EXISTS (
SELECT 1
FROM sleep_session s
WHERE s.user_id = u.id
AND s.stop_time > ?
)
FOR NO KEY UPDATE
2025-05-07T01:51:29.975Z DEBUG 2502 --- [Pool-1-worker-1] org.hibernate.SQL : SELECT n.*
FROM notification n
JOIN app_user u ON u.id = n.user_id
WHERE n.last_sent < ?
AND u.notifications_enabled = TRUE
AND NOT EXISTS (
SELECT 1
FROM sleep_session s
WHERE s.user_id = u.id
AND s.stop_time > ?
)
FOR NO KEY UPDATE
2025-05-07T01:51:29.973Z DEBUG 2502 --- [Pool-1-worker-6] org.hibernate.SQL : insert into app_user (display_name,email,notifications_enabled,password,public_id,registration_time) values (?,?,?,?,?,?)
2025-05-07T01:51:29.978Z DEBUG 2502 --- [Pool-1-worker-6] org.hibernate.SQL : insert into notification (last_sent,user_id) values (?,?)
2025-05-07T01:51:29.981Z DEBUG 2502 --- [Pool-1-worker-6] org.hibernate.SQL : insert into user_role (user_id,role_id) values (?,?)
2025-05-07T01:51:29.984Z DEBUG 2502 --- [Pool-1-worker-1] org.hibernate.SQL : SELECT n.*
FROM notification n
JOIN app_user u ON u.id = n.user_id
WHERE n.last_sent < ?
AND u.notifications_enabled = TRUE
AND NOT EXISTS (
SELECT 1
FROM sleep_session s
WHERE s.user_id = u.id
AND s.stop_time > ?
)
FOR NO KEY UPDATE
2025-05-07T01:51:29.985Z DEBUG 2502 --- [Pool-1-worker-6] org.hibernate.SQL : select u1_0.id,u1_0.display_name,u1_0.email,u1_0.notifications_enabled,u1_0.password,u1_0.public_id,u1_0.registration_time from app_user u1_0 where u1_0.email=?
2025-05-07T01:51:29.987Z DEBUG 2502 --- [Pool-1-worker-1] org.hibernate.SQL : SELECT n.*
FROM notification n
JOIN app_user u ON u.id = n.user_id
WHERE n.last_sent < ?
AND u.notifications_enabled = TRUE
AND NOT EXISTS (
SELECT 1
FROM sleep_session s
WHERE s.user_id = u.id
AND s.stop_time > ?
)
FOR NO KEY UPDATE
2025-05-07T01:51:29.987Z DEBUG 2502 --- [Pool-1-worker-6] org.hibernate.SQL : select r1_0.user_id,r1_0.role_id from user_role r1_0 where r1_0.user_id=?
2025-05-07T01:51:29.989Z DEBUG 2502 --- [Pool-1-worker-1] org.hibernate.SQL : SELECT n.*
FROM notification n
JOIN app_user u ON u.id = n.user_id
WHERE n.last_sent < ?
AND u.notifications_enabled = TRUE
AND NOT EXISTS (
SELECT 1
FROM sleep_session s
WHERE s.user_id = u.id
AND s.stop_time > ?
)
FOR NO KEY UPDATE
2025-05-07T01:51:29.992Z DEBUG 2502 --- [Pool-1-worker-1] org.hibernate.SQL : SELECT n.*
FROM notification n
JOIN app_user u ON u.id = n.user_id
WHERE n.last_sent < ?
AND u.notifications_enabled = TRUE
AND NOT EXISTS (
SELECT 1
FROM sleep_session s
WHERE s.user_id = u.id
AND s.stop_time > ?
)
FOR NO KEY UPDATE
2025-05-07T01:51:29.997Z DEBUG 2502 --- [Pool-1-worker-6] org.hibernate.SQL : select u1_0.id from app_user u1_0 where u1_0.email=? fetch first ? rows only
2025-05-07T01:51:30.002Z DEBUG 2502 --- [Pool-1-worker-1] org.hibernate.SQL : SELECT n.*
FROM notification n
JOIN app_user u ON u.id = n.user_id
WHERE n.last_sent < ?
AND u.notifications_enabled = TRUE
AND NOT EXISTS (
SELECT 1
FROM sleep_session s
WHERE s.user_id = u.id
AND s.stop_time > ?
)
FOR NO KEY UPDATE
2025-05-07T01:51:30.005Z DEBUG 2502 --- [Pool-1-worker-1] org.hibernate.SQL : SELECT n.*
FROM notification n
JOIN app_user u ON u.id = n.user_id
WHERE n.last_sent < ?
AND u.notifications_enabled = TRUE
AND NOT EXISTS (
SELECT 1
FROM sleep_session s
WHERE s.user_id = u.id
AND s.stop_time > ?
)
FOR NO KEY UPDATE
2025-05-07T01:51:30.009Z DEBUG 2502 --- [Pool-1-worker-1] org.hibernate.SQL : SELECT n.*
FROM notification n
JOIN app_user u ON u.id = n.user_id
WHERE n.last_sent < ?
AND u.notifications_enabled = TRUE
AND NOT EXISTS (
SELECT 1
FROM sleep_session s
WHERE s.user_id = u.id
AND s.stop_time > ?
)
FOR NO KEY UPDATE
2025-05-07T01:51:30.014Z DEBUG 2502 --- [Pool-1-worker-1] org.hibernate.SQL : SELECT n.*
FROM notification n
JOIN app_user u ON u.id = n.user_id
WHERE n.last_sent < ?
AND u.notifications_enabled = TRUE
AND NOT EXISTS (
SELECT 1
FROM sleep_session s
WHERE s.user_id = u.id
AND s.stop_time > ?
)
FOR NO KEY UPDATE
2025-05-07T01:51:30.019Z DEBUG 2502 --- [Pool-1-worker-1] org.hibernate.SQL : SELECT n.*
FROM notification n
JOIN app_user u ON u.id = n.user_id
WHERE n.last_sent < ?
AND u.notifications_enabled = TRUE
AND NOT EXISTS (
SELECT 1
FROM sleep_session s
WHERE s.user_id = u.id
AND s.stop_time > ?
)
FOR NO KEY UPDATE
2025-05-07T01:51:30.022Z DEBUG 2502 --- [Pool-1-worker-1] org.hibernate.SQL : SELECT n.*
FROM notification n
JOIN app_user u ON u.id = n.user_id
WHERE n.last_sent < ?
AND u.notifications_enabled = TRUE
AND NOT EXISTS (
SELECT 1
FROM sleep_session s
WHERE s.user_id = u.id
AND s.stop_time > ?
)
FOR NO KEY UPDATE
2025-05-07T01:51:30.026Z DEBUG 2502 --- [Pool-1-worker-1] org.hibernate.SQL : SELECT n.*
FROM notification n
JOIN app_user u ON u.id = n.user_id
WHERE n.last_sent < ?
AND u.notifications_enabled = TRUE
AND NOT EXISTS (
SELECT 1
FROM sleep_session s
WHERE s.user_id = u.id
AND s.stop_time > ?
)
FOR NO KEY UPDATE
2025-05-07T01:51:30.028Z DEBUG 2502 --- [Pool-1-worker-1] org.hibernate.SQL : SELECT n.*
FROM notification n
JOIN app_user u ON u.id = n.user_id
WHERE n.last_sent < ?
AND u.notifications_enabled = TRUE
AND NOT EXISTS (
SELECT 1
FROM sleep_session s
WHERE s.user_id = u.id
AND s.stop_time > ?
)
FOR NO KEY UPDATE
2025-05-07T01:51:30.033Z DEBUG 2502 --- [Pool-1-worker-1] org.hibernate.SQL : SELECT n.*
FROM notification n
JOIN app_user u ON u.id = n.user_id
WHERE n.last_sent < ?
AND u.notifications_enabled = TRUE
AND NOT EXISTS (
SELECT 1
FROM sleep_session s
WHERE s.user_id = u.id
AND s.stop_time > ?
)
FOR NO KEY UPDATE
2025-05-07T01:51:30.035Z DEBUG 2502 --- [Pool-1-worker-1] org.hibernate.SQL : SELECT n.*
FROM notification n
JOIN app_user u ON u.id = n.user_id
WHERE n.last_sent < ?
AND u.notifications_enabled = TRUE
AND NOT EXISTS (
SELECT 1
FROM sleep_session s
WHERE s.user_id = u.id
AND s.stop_time > ?
)
FOR NO KEY UPDATE
2025-05-07T01:51:30.038Z DEBUG 2502 --- [Pool-1-worker-1] org.hibernate.SQL : SELECT n.*
FROM notification n
JOIN app_user u ON u.id = n.user_id
WHERE n.last_sent < ?
AND u.notifications_enabled = TRUE
AND NOT EXISTS (
SELECT 1
FROM sleep_session s
WHERE s.user_id = u.id
AND s.stop_time > ?
)
FOR NO KEY UPDATE
2025-05-07T01:51:30.042Z DEBUG 2502 --- [Pool-1-worker-1] org.hibernate.SQL : SELECT n.*
FROM notification n
JOIN app_user u ON u.id = n.user_id
WHERE n.last_sent < ?
AND u.notifications_enabled = TRUE
AND NOT EXISTS (
SELECT 1
FROM sleep_session s
WHERE s.user_id = u.id
AND s.stop_time > ?
)
FOR NO KEY UPDATE
2025-05-07T01:51:30.047Z DEBUG 2502 --- [Pool-1-worker-4] org.hibernate.SQL : insert into app_user (display_name,email,notifications_enabled,password,public_id,registration_time) values (?,?,?,?,?,?)
2025-05-07T01:51:30.048Z DEBUG 2502 --- [Pool-1-worker-1] org.hibernate.SQL : SELECT n.*
FROM notification n
JOIN app_user u ON u.id = n.user_id
WHERE n.last_sent < ?
AND u.notifications_enabled = TRUE
AND NOT EXISTS (
SELECT 1
FROM sleep_session s
WHERE s.user_id = u.id
AND s.stop_time > ?
)
FOR NO KEY UPDATE
2025-05-07T01:51:30.049Z DEBUG 2502 --- [Pool-1-worker-4] org.hibernate.SQL : insert into notification (last_sent,user_id) values (?,?)
2025-05-07T01:51:30.054Z DEBUG 2502 --- [Pool-1-worker-4] org.hibernate.SQL : insert into user_role (user_id,role_id) values (?,?)
2025-05-07T01:51:30.055Z DEBUG 2502 --- [Pool-1-worker-1] org.hibernate.SQL : SELECT n.*
FROM notification n
JOIN app_user u ON u.id = n.user_id
WHERE n.last_sent < ?
AND u.notifications_enabled = TRUE
AND NOT EXISTS (
SELECT 1
FROM sleep_session s
WHERE s.user_id = u.id
AND s.stop_time > ?
)
FOR NO KEY UPDATE
2025-05-07T01:51:30.057Z DEBUG 2502 --- [Pool-1-worker-1] org.hibernate.SQL : SELECT n.*
FROM notification n
JOIN app_user u ON u.id = n.user_id
WHERE n.last_sent < ?
AND u.notifications_enabled = TRUE
AND NOT EXISTS (
SELECT 1
FROM sleep_session s
WHERE s.user_id = u.id
AND s.stop_time > ?
)
FOR NO KEY UPDATE
2025-05-07T01:51:30.059Z DEBUG 2502 --- [Pool-1-worker-4] org.hibernate.SQL : select u1_0.id from app_user u1_0 where u1_0.email=? fetch first ? rows only
2025-05-07T01:51:30.061Z DEBUG 2502 --- [Pool-1-worker-1] org.hibernate.SQL : SELECT n.*
FROM notification n
JOIN app_user u ON u.id = n.user_id
WHERE n.last_sent < ?
AND u.notifications_enabled = TRUE
AND NOT EXISTS (
SELECT 1
FROM sleep_session s
WHERE s.user_id = u.id
AND s.stop_time > ?
)
FOR NO KEY UPDATE
2025-05-07T01:51:30.066Z DEBUG 2502 --- [Pool-1-worker-1] org.hibernate.SQL : select u1_0.id,u1_0.display_name,u1_0.email,u1_0.notifications_enabled,u1_0.password,u1_0.public_id,u1_0.registration_time from app_user u1_0 where u1_0.public_id=?
2025-05-07T01:51:30.066Z DEBUG 2502 --- [Pool-1-worker-5] org.hibernate.SQL : insert into app_user (display_name,email,notifications_enabled,password,public_id,registration_time) values (?,?,?,?,?,?)
2025-05-07T01:51:30.068Z DEBUG 2502 --- [Pool-1-worker-1] org.hibernate.SQL : insert into sleep_session (minutes_asleep,minutes_awake,notes,start_time,stop_time,user_id,zone_id,id) values (?,?,?,?,?,?,?,?)
2025-05-07T01:51:30.071Z DEBUG 2502 --- [Pool-1-worker-5] org.hibernate.SQL : insert into notification (last_sent,user_id) values (?,?)
2025-05-07T01:51:30.072Z DEBUG 2502 --- [Pool-1-worker-5] org.hibernate.SQL : insert into user_role (user_id,role_id) values (?,?)
2025-05-07T01:51:30.072Z DEBUG 2502 --- [Pool-1-worker-1] org.hibernate.SQL : SELECT n.*
FROM notification n
JOIN app_user u ON u.id = n.user_id
WHERE n.last_sent < ?
AND u.notifications_enabled = TRUE
AND NOT EXISTS (
SELECT 1
FROM sleep_session s
WHERE s.user_id = u.id
AND s.stop_time > ?
)
FOR NO KEY UPDATE
2025-05-07T01:51:30.075Z DEBUG 2502 --- [Pool-1-worker-5] org.hibernate.SQL : select u1_0.id,u1_0.display_name,u1_0.email,u1_0.notifications_enabled,u1_0.password,u1_0.public_id,u1_0.registration_time from app_user u1_0 where u1_0.email=?
2025-05-07T01:51:30.077Z DEBUG 2502 --- [Pool-1-worker-1] org.hibernate.SQL : SELECT n.*
FROM notification n
JOIN app_user u ON u.id = n.user_id
WHERE n.last_sent < ?
AND u.notifications_enabled = TRUE
AND NOT EXISTS (
SELECT 1
FROM sleep_session s
WHERE s.user_id = u.id
AND s.stop_time > ?
)
FOR NO KEY UPDATE
2025-05-07T01:51:30.079Z DEBUG 2502 --- [Pool-1-worker-5] org.hibernate.SQL : select r1_0.user_id,r1_0.role_id from user_role r1_0 where r1_0.user_id=?
2025-05-07T01:51:30.085Z DEBUG 2502 --- [Pool-1-worker-1] org.hibernate.SQL : SELECT n.*
FROM notification n
JOIN app_user u ON u.id = n.user_id
WHERE n.last_sent < ?
AND u.notifications_enabled = TRUE
AND NOT EXISTS (
SELECT 1
FROM sleep_session s
WHERE s.user_id = u.id
AND s.stop_time > ?
)
FOR NO KEY UPDATE
2025-05-07T01:51:30.091Z DEBUG 2502 --- [Pool-1-worker-1] org.hibernate.SQL : SELECT n.*
FROM notification n
JOIN app_user u ON u.id = n.user_id
WHERE n.last_sent < ?
AND u.notifications_enabled = TRUE
AND NOT EXISTS (
SELECT 1
FROM sleep_session s
WHERE s.user_id = u.id
AND s.stop_time > ?
)
FOR NO KEY UPDATE
2025-05-07T01:51:30.098Z DEBUG 2502 --- [Pool-1-worker-1] org.hibernate.SQL : SELECT n.*
FROM notification n
JOIN app_user u ON u.id = n.user_id
WHERE n.last_sent < ?
AND u.notifications_enabled = TRUE
AND NOT EXISTS (
SELECT 1
FROM sleep_session s
WHERE s.user_id = u.id
AND s.stop_time > ?
)
FOR NO KEY UPDATE
2025-05-07T01:51:30.100Z DEBUG 2502 --- [Pool-1-worker-1] org.hibernate.SQL : SELECT n.*
FROM notification n
JOIN app_user u ON u.id = n.user_id
WHERE n.last_sent < ?
AND u.notifications_enabled = TRUE
AND NOT EXISTS (
SELECT 1
FROM sleep_session s
WHERE s.user_id = u.id
AND s.stop_time > ?
)
FOR NO KEY UPDATE
2025-05-07T01:51:30.102Z DEBUG 2502 --- [Pool-1-worker-1] org.hibernate.SQL : SELECT n.*
FROM notification n
JOIN app_user u ON u.id = n.user_id
WHERE n.last_sent < ?
AND u.notifications_enabled = TRUE
AND NOT EXISTS (
SELECT 1
FROM sleep_session s
WHERE s.user_id = u.id
AND s.stop_time > ?
)
FOR NO KEY UPDATE
2025-05-07T01:51:30.109Z DEBUG 2502 --- [Pool-1-worker-5] org.hibernate.SQL : select c1_0.id,c1_0.name,c1_0.description,c1_0.start,c1_0.finish from challenge c1_0 join app_user u1_0 on u1_0.id=c1_0.user_id where u1_0.public_id=? order by c1_0.finish
2025-05-07T01:51:30.111Z DEBUG 2502 --- [Pool-1-worker-1] org.hibernate.SQL : SELECT n.*
FROM notification n
JOIN app_user u ON u.id = n.user_id
WHERE n.last_sent < ?
AND u.notifications_enabled = TRUE
AND NOT EXISTS (
SELECT 1
FROM sleep_session s
WHERE s.user_id = u.id
AND s.stop_time > ?
)
FOR NO KEY UPDATE
2025-05-07T01:51:30.113Z DEBUG 2502 --- [Pool-1-worker-1] org.hibernate.SQL : SELECT n.*
FROM notification n
JOIN app_user u ON u.id = n.user_id
WHERE n.last_sent < ?
AND u.notifications_enabled = TRUE
AND NOT EXISTS (
SELECT 1
FROM sleep_session s
WHERE s.user_id = u.id
AND s.stop_time > ?
)
FOR NO KEY UPDATE
2025-05-07T01:51:30.116Z DEBUG 2502 --- [Pool-1-worker-1] org.hibernate.SQL : SELECT n.*
FROM notification n
JOIN app_user u ON u.id = n.user_id
WHERE n.last_sent < ?
AND u.notifications_enabled = TRUE
AND NOT EXISTS (
SELECT 1
FROM sleep_session s
WHERE s.user_id = u.id
AND s.stop_time > ?
)
FOR NO KEY UPDATE
2025-05-07T01:51:30.120Z DEBUG 2502 --- [Pool-1-worker-1] org.hibernate.SQL : SELECT n.*
FROM notification n
JOIN app_user u ON u.id = n.user_id
WHERE n.last_sent < ?
AND u.notifications_enabled = TRUE
AND NOT EXISTS (
SELECT 1
FROM sleep_session s
WHERE s.user_id = u.id
AND s.stop_time > ?
)
FOR NO KEY UPDATE
2025-05-07T01:51:30.123Z DEBUG 2502 --- [Pool-1-worker-5] org.hibernate.SQL : select u1_0.id,u1_0.display_name,u1_0.email,u1_0.notifications_enabled,u1_0.password,u1_0.public_id,u1_0.registration_time from app_user u1_0 where u1_0.public_id=?
2025-05-07T01:51:30.125Z DEBUG 2502 --- [Pool-1-worker-1] org.hibernate.SQL : SELECT n.*
FROM notification n
JOIN app_user u ON u.id = n.user_id
WHERE n.last_sent < ?
AND u.notifications_enabled = TRUE
AND NOT EXISTS (
SELECT 1
FROM sleep_session s
WHERE s.user_id = u.id
AND s.stop_time > ?
)
FOR NO KEY UPDATE
2025-05-07T01:51:30.126Z DEBUG 2502 --- [Pool-1-worker-5] org.hibernate.SQL : insert into challenge (description,finish,name,start,user_id,id) values (?,?,?,?,?,?)
2025-05-07T01:51:30.131Z DEBUG 2502 --- [Pool-1-worker-5] org.hibernate.SQL : select c1_0.id,c1_0.name,c1_0.description,c1_0.start,c1_0.finish from challenge c1_0 join app_user u1_0 on u1_0.id=c1_0.user_id where u1_0.public_id=? order by c1_0.finish
2025-05-07T01:51:30.131Z DEBUG 2502 --- [Pool-1-worker-1] org.hibernate.SQL : SELECT n.*
FROM notification n
JOIN app_user u ON u.id = n.user_id
WHERE n.last_sent < ?
AND u.notifications_enabled = TRUE
AND NOT EXISTS (
SELECT 1
FROM sleep_session s
WHERE s.user_id = u.id
AND s.stop_time > ?
)
FOR NO KEY UPDATE
2025-05-07T01:51:30.135Z DEBUG 2502 --- [Pool-1-worker-1] org.hibernate.SQL : SELECT n.*
FROM notification n
JOIN app_user u ON u.id = n.user_id
WHERE n.last_sent < ?
AND u.notifications_enabled = TRUE
AND NOT EXISTS (
SELECT 1
FROM sleep_session s
WHERE s.user_id = u.id
AND s.stop_time > ?
)
FOR NO KEY UPDATE
2025-05-07T01:51:30.140Z DEBUG 2502 --- [Pool-1-worker-1] org.hibernate.SQL : SELECT n.*
FROM notification n
JOIN app_user u ON u.id = n.user_id
WHERE n.last_sent < ?
AND u.notifications_enabled = TRUE
AND NOT EXISTS (
SELECT 1
FROM sleep_session s
WHERE s.user_id = u.id
AND s.stop_time > ?
)
FOR NO KEY UPDATE
2025-05-07T01:51:30.142Z DEBUG 2502 --- [Pool-1-worker-5] org.hibernate.SQL : select c1_0.id,c1_0.description,c1_0.finish,c1_0.name,c1_0.start,c1_0.user_id from challenge c1_0 join app_user u1_0 on u1_0.id=c1_0.user_id where u1_0.public_id=? and c1_0.id=?
2025-05-07T01:51:30.145Z DEBUG 2502 --- [Pool-1-worker-1] org.hibernate.SQL : SELECT n.*
FROM notification n
JOIN app_user u ON u.id = n.user_id
WHERE n.last_sent < ?
AND u.notifications_enabled = TRUE
AND NOT EXISTS (
SELECT 1
FROM sleep_session s
WHERE s.user_id = u.id
AND s.stop_time > ?
)
FOR NO KEY UPDATE
2025-05-07T01:51:30.152Z DEBUG 2502 --- [Pool-1-worker-1] org.hibernate.SQL : SELECT n.*
FROM notification n
JOIN app_user u ON u.id = n.user_id
WHERE n.last_sent < ?
AND u.notifications_enabled = TRUE
AND NOT EXISTS (
SELECT 1
FROM sleep_session s
WHERE s.user_id = u.id
AND s.stop_time > ?
)
FOR NO KEY UPDATE
2025-05-07T01:51:30.155Z DEBUG 2502 --- [Pool-1-worker-1] org.hibernate.SQL : SELECT n.*
FROM notification n
JOIN app_user u ON u.id = n.user_id
WHERE n.last_sent < ?
AND u.notifications_enabled = TRUE
AND NOT EXISTS (
SELECT 1
FROM sleep_session s
WHERE s.user_id = u.id
AND s.stop_time > ?
)
FOR NO KEY UPDATE
2025-05-07T01:51:30.161Z DEBUG 2502 --- [Pool-1-worker-1] org.hibernate.SQL : SELECT n.*
FROM notification n
JOIN app_user u ON u.id = n.user_id
WHERE n.last_sent < ?
AND u.notifications_enabled = TRUE
AND NOT EXISTS (
SELECT 1
FROM sleep_session s
WHERE s.user_id = u.id
AND s.stop_time > ?
)
FOR NO KEY UPDATE
2025-05-07T01:51:30.163Z DEBUG 2502 --- [Pool-1-worker-5] org.hibernate.SQL : delete from challenge where id=?
2025-05-07T01:51:30.168Z DEBUG 2502 --- [Pool-1-worker-1] org.hibernate.SQL : SELECT n.*
FROM notification n
JOIN app_user u ON u.id = n.user_id
WHERE n.last_sent < ?
AND u.notifications_enabled = TRUE
AND NOT EXISTS (
SELECT 1
FROM sleep_session s
WHERE s.user_id = u.id
AND s.stop_time > ?
)
FOR NO KEY UPDATE
2025-05-07T01:51:30.170Z DEBUG 2502 --- [Pool-1-worker-1] org.hibernate.SQL : SELECT n.*
FROM notification n
JOIN app_user u ON u.id = n.user_id
WHERE n.last_sent < ?
AND u.notifications_enabled = TRUE
AND NOT EXISTS (
SELECT 1
FROM sleep_session s
WHERE s.user_id = u.id
AND s.stop_time > ?
)
FOR NO KEY UPDATE
2025-05-07T01:51:30.174Z DEBUG 2502 --- [Pool-1-worker-1] org.hibernate.SQL : SELECT n.*
FROM notification n
JOIN app_user u ON u.id = n.user_id
WHERE n.last_sent < ?
AND u.notifications_enabled = TRUE
AND NOT EXISTS (
SELECT 1
FROM sleep_session s
WHERE s.user_id = u.id
AND s.stop_time > ?
)
FOR NO KEY UPDATE
2025-05-07T01:51:30.179Z DEBUG 2502 --- [Pool-1-worker-6] org.hibernate.SQL : insert into app_user (display_name,email,notifications_enabled,password,public_id,registration_time) values (?,?,?,?,?,?)
2025-05-07T01:51:30.180Z DEBUG 2502 --- [Pool-1-worker-1] org.hibernate.SQL : SELECT n.*
FROM notification n
JOIN app_user u ON u.id = n.user_id
WHERE n.last_sent < ?
AND u.notifications_enabled = TRUE
AND NOT EXISTS (
SELECT 1
FROM sleep_session s
WHERE s.user_id = u.id
AND s.stop_time > ?
)
FOR NO KEY UPDATE
2025-05-07T01:51:30.182Z DEBUG 2502 --- [Pool-1-worker-6] org.hibernate.SQL : insert into notification (last_sent,user_id) values (?,?)
2025-05-07T01:51:30.183Z DEBUG 2502 --- [Pool-1-worker-5] org.hibernate.SQL : select c1_0.id,c1_0.name,c1_0.description,c1_0.start,c1_0.finish from challenge c1_0 join app_user u1_0 on u1_0.id=c1_0.user_id where u1_0.public_id=? order by c1_0.finish
2025-05-07T01:51:30.183Z DEBUG 2502 --- [Pool-1-worker-1] org.hibernate.SQL : SELECT n.*
FROM notification n
JOIN app_user u ON u.id = n.user_id
WHERE n.last_sent < ?
AND u.notifications_enabled = TRUE
AND NOT EXISTS (
SELECT 1
FROM sleep_session s
WHERE s.user_id = u.id
AND s.stop_time > ?
)
FOR NO KEY UPDATE
2025-05-07T01:51:30.184Z DEBUG 2502 --- [Pool-1-worker-6] org.hibernate.SQL : insert into user_role (user_id,role_id) values (?,?)
2025-05-07T01:51:30.189Z DEBUG 2502 --- [Pool-1-worker-6] org.hibernate.SQL : select u1_0.id,u1_0.display_name,u1_0.email,u1_0.notifications_enabled,u1_0.password,u1_0.public_id,u1_0.registration_time from app_user u1_0 where u1_0.email=?
2025-05-07T01:51:30.193Z DEBUG 2502 --- [Pool-1-worker-6] org.hibernate.SQL : select r1_0.user_id,r1_0.role_id from user_role r1_0 where r1_0.user_id=?
2025-05-07T01:51:30.416Z DEBUG 2502 --- [Pool-1-worker-1] org.hibernate.SQL : select u1_0.id,u1_0.display_name,u1_0.email,u1_0.notifications_enabled,u1_0.password,u1_0.public_id,u1_0.registration_time from app_user u1_0 where u1_0.public_id=?
2025-05-07T01:51:30.419Z DEBUG 2502 --- [Pool-1-worker-1] org.hibernate.SQL : select r1_0.user_id,r1_0.role_id from user_role r1_0 where r1_0.user_id=?
2025-05-07T01:51:30.421Z DEBUG 2502 --- [Pool-1-worker-1] org.hibernate.SQL : update app_user set display_name=?,email=?,notifications_enabled=?,password=?,registration_time=? where id=?
2025-05-07T01:51:30.424Z INFO 2502 --- [o-auto-1-exec-3] o.a.c.c.C.[Tomcat].[localhost].[/] : Initializing Spring DispatcherServlet 'dispatcherServlet'
2025-05-07T01:51:30.424Z INFO 2502 --- [o-auto-1-exec-3] o.s.web.servlet.DispatcherServlet : Initializing Servlet 'dispatcherServlet'
2025-05-07T01:51:30.424Z DEBUG 2502 --- [Pool-1-worker-5] org.hibernate.SQL : select u1_0.id from app_user u1_0 where u1_0.email=? fetch first ? rows only
2025-05-07T01:51:30.426Z DEBUG 2502 --- [Pool-1-worker-1] org.hibernate.SQL : select u1_0.id,u1_0.display_name,u1_0.email,u1_0.notifications_enabled,u1_0.password,u1_0.public_id,u1_0.registration_time from app_user u1_0 where u1_0.public_id=?
2025-05-07T01:51:30.428Z DEBUG 2502 --- [Pool-1-worker-1] org.hibernate.SQL : insert into sleep_session (minutes_asleep,minutes_awake,notes,start_time,stop_time,user_id,zone_id,id) values (?,?,?,?,?,?,?,?)
2025-05-07T01:51:30.430Z DEBUG 2502 --- [Pool-1-worker-1] org.hibernate.SQL : select u1_0.id,u1_0.display_name,u1_0.email,u1_0.notifications_enabled,u1_0.password,u1_0.public_id,u1_0.registration_time from app_user u1_0 where u1_0.public_id=?
2025-05-07T01:51:30.433Z DEBUG 2502 --- [Pool-1-worker-1] org.hibernate.SQL : insert into sleep_session (minutes_asleep,minutes_awake,notes,start_time,stop_time,user_id,zone_id,id) values (?,?,?,?,?,?,?,?)
2025-05-07T01:51:30.437Z DEBUG 2502 --- [Pool-1-worker-1] org.hibernate.SQL : SELECT n.*
FROM notification n
JOIN app_user u ON u.id = n.user_id
WHERE n.last_sent < ?
AND u.notifications_enabled = TRUE
AND NOT EXISTS (
SELECT 1
FROM sleep_session s
WHERE s.user_id = u.id
AND s.stop_time > ?
)
FOR NO KEY UPDATE
2025-05-07T01:51:30.439Z DEBUG 2502 --- [Pool-1-worker-1] org.hibernate.SQL : SELECT n.*
FROM notification n
JOIN app_user u ON u.id = n.user_id
WHERE n.last_sent < ?
AND u.notifications_enabled = TRUE
AND NOT EXISTS (
SELECT 1
FROM sleep_session s
WHERE s.user_id = u.id
AND s.stop_time > ?
)
FOR NO KEY UPDATE
2025-05-07T01:51:30.444Z DEBUG 2502 --- [Pool-1-worker-1] org.hibernate.SQL : SELECT n.*
FROM notification n
JOIN app_user u ON u.id = n.user_id
WHERE n.last_sent < ?
AND u.notifications_enabled = TRUE
AND NOT EXISTS (
SELECT 1
FROM sleep_session s
WHERE s.user_id = u.id
AND s.stop_time > ?
)
FOR NO KEY UPDATE
2025-05-07T01:51:30.446Z DEBUG 2502 --- [Pool-1-worker-1] org.hibernate.SQL : SELECT n.*
FROM notification n
JOIN app_user u ON u.id = n.user_id
WHERE n.last_sent < ?
AND u.notifications_enabled = TRUE
AND NOT EXISTS (
SELECT 1
FROM sleep_session s
WHERE s.user_id = u.id
AND s.stop_time > ?
)
FOR NO KEY UPDATE
2025-05-07T01:51:30.449Z DEBUG 2502 --- [Pool-1-worker-1] org.hibernate.SQL : SELECT n.*
FROM notification n
JOIN app_user u ON u.id = n.user_id
WHERE n.last_sent < ?
AND u.notifications_enabled = TRUE
AND NOT EXISTS (
SELECT 1
FROM sleep_session s
WHERE s.user_id = u.id
AND s.stop_time > ?
)
FOR NO KEY UPDATE
2025-05-07T01:51:30.453Z DEBUG 2502 --- [Pool-1-worker-1] org.hibernate.SQL : SELECT n.*
FROM notification n
JOIN app_user u ON u.id = n.user_id
WHERE n.last_sent < ?
AND u.notifications_enabled = TRUE
AND NOT EXISTS (
SELECT 1
FROM sleep_session s
WHERE s.user_id = u.id
AND s.stop_time > ?
)
FOR NO KEY UPDATE
2025-05-07T01:51:30.456Z DEBUG 2502 --- [Pool-1-worker-1] org.hibernate.SQL : SELECT n.*
FROM notification n
JOIN app_user u ON u.id = n.user_id
WHERE n.last_sent < ?
AND u.notifications_enabled = TRUE
AND NOT EXISTS (
SELECT 1
FROM sleep_session s
WHERE s.user_id = u.id
AND s.stop_time > ?
)
FOR NO KEY UPDATE
2025-05-07T01:51:30.458Z DEBUG 2502 --- [Pool-1-worker-1] org.hibernate.SQL : SELECT n.*
FROM notification n
JOIN app_user u ON u.id = n.user_id
WHERE n.last_sent < ?
AND u.notifications_enabled = TRUE
AND NOT EXISTS (
SELECT 1
FROM sleep_session s
WHERE s.user_id = u.id
AND s.stop_time > ?
)
FOR NO KEY UPDATE
2025-05-07T01:51:30.466Z DEBUG 2502 --- [Pool-1-worker-1] org.hibernate.SQL : SELECT n.*
FROM notification n
JOIN app_user u ON u.id = n.user_id
WHERE n.last_sent < ?
AND u.notifications_enabled = TRUE
AND NOT EXISTS (
SELECT 1
FROM sleep_session s
WHERE s.user_id = u.id
AND s.stop_time > ?
)
FOR NO KEY UPDATE
2025-05-07T01:51:30.468Z DEBUG 2502 --- [Pool-1-worker-1] org.hibernate.SQL : SELECT n.*
FROM notification n
JOIN app_user u ON u.id = n.user_id
WHERE n.last_sent < ?
AND u.notifications_enabled = TRUE
AND NOT EXISTS (
SELECT 1
FROM sleep_session s
WHERE s.user_id = u.id
AND s.stop_time > ?
)
FOR NO KEY UPDATE
2025-05-07T01:51:30.470Z DEBUG 2502 --- [Pool-1-worker-1] org.hibernate.SQL : SELECT n.*
FROM notification n
JOIN app_user u ON u.id = n.user_id
WHERE n.last_sent < ?
AND u.notifications_enabled = TRUE
AND NOT EXISTS (
SELECT 1
FROM sleep_session s
WHERE s.user_id = u.id
AND s.stop_time > ?
)
FOR NO KEY UPDATE
2025-05-07T01:51:30.473Z DEBUG 2502 --- [Pool-1-worker-1] org.hibernate.SQL : SELECT n.*
FROM notification n
JOIN app_user u ON u.id = n.user_id
WHERE n.last_sent < ?
AND u.notifications_enabled = TRUE
AND NOT EXISTS (
SELECT 1
FROM sleep_session s
WHERE s.user_id = u.id
AND s.stop_time > ?
)
FOR NO KEY UPDATE
2025-05-07T01:51:30.478Z DEBUG 2502 --- [Pool-1-worker-1] org.hibernate.SQL : SELECT n.*
FROM notification n
JOIN app_user u ON u.id = n.user_id
WHERE n.last_sent < ?
AND u.notifications_enabled = TRUE
AND NOT EXISTS (
SELECT 1
FROM sleep_session s
WHERE s.user_id = u.id
AND s.stop_time > ?
)
FOR NO KEY UPDATE
2025-05-07T01:51:30.480Z DEBUG 2502 --- [Pool-1-worker-1] org.hibernate.SQL : SELECT n.*
FROM notification n
JOIN app_user u ON u.id = n.user_id
WHERE n.last_sent < ?
AND u.notifications_enabled = TRUE
AND NOT EXISTS (
SELECT 1
FROM sleep_session s
WHERE s.user_id = u.id
AND s.stop_time > ?
)
FOR NO KEY UPDATE
2025-05-07T01:51:30.484Z DEBUG 2502 --- [Pool-1-worker-1] org.hibernate.SQL : SELECT n.*
FROM notification n
JOIN app_user u ON u.id = n.user_id
WHERE n.last_sent < ?
AND u.notifications_enabled = TRUE
AND NOT EXISTS (
SELECT 1
FROM sleep_session s
WHERE s.user_id = u.id
AND s.stop_time > ?
)
FOR NO KEY UPDATE
2025-05-07T01:51:30.486Z DEBUG 2502 --- [Pool-1-worker-1] org.hibernate.SQL : SELECT n.*
FROM notification n
JOIN app_user u ON u.id = n.user_id
WHERE n.last_sent < ?
AND u.notifications_enabled = TRUE
AND NOT EXISTS (
SELECT 1
FROM sleep_session s
WHERE s.user_id = u.id
AND s.stop_time > ?
)
FOR NO KEY UPDATE
2025-05-07T01:51:30.489Z DEBUG 2502 --- [Pool-1-worker-1] org.hibernate.SQL : SELECT n.*
FROM notification n
JOIN app_user u ON u.id = n.user_id
WHERE n.last_sent < ?
AND u.notifications_enabled = TRUE
AND NOT EXISTS (
SELECT 1
FROM sleep_session s
WHERE s.user_id = u.id
AND s.stop_time > ?
)
FOR NO KEY UPDATE
2025-05-07T01:51:30.493Z DEBUG 2502 --- [Pool-1-worker-1] org.hibernate.SQL : SELECT n.*
FROM notification n
JOIN app_user u ON u.id = n.user_id
WHERE n.last_sent < ?
AND u.notifications_enabled = TRUE
AND NOT EXISTS (
SELECT 1
FROM sleep_session s
WHERE s.user_id = u.id
AND s.stop_time > ?
)
FOR NO KEY UPDATE
2025-05-07T01:51:30.496Z DEBUG 2502 --- [Pool-1-worker-1] org.hibernate.SQL : SELECT n.*
FROM notification n
JOIN app_user u ON u.id = n.user_id
WHERE n.last_sent < ?
AND u.notifications_enabled = TRUE
AND NOT EXISTS (
SELECT 1
FROM sleep_session s
WHERE s.user_id = u.id
AND s.stop_time > ?
)
FOR NO KEY UPDATE
2025-05-07T01:51:30.499Z DEBUG 2502 --- [Pool-1-worker-1] org.hibernate.SQL : SELECT n.*
FROM notification n
JOIN app_user u ON u.id = n.user_id
WHERE n.last_sent < ?
AND u.notifications_enabled = TRUE
AND NOT EXISTS (
SELECT 1
FROM sleep_session s
WHERE s.user_id = u.id
AND s.stop_time > ?
)
FOR NO KEY UPDATE
2025-05-07T01:51:30.503Z DEBUG 2502 --- [Pool-1-worker-1] org.hibernate.SQL : SELECT n.*
FROM notification n
JOIN app_user u ON u.id = n.user_id
WHERE n.last_sent < ?
AND u.notifications_enabled = TRUE
AND NOT EXISTS (
SELECT 1
FROM sleep_session s
WHERE s.user_id = u.id
AND s.stop_time > ?
)
FOR NO KEY UPDATE
2025-05-07T01:51:30.506Z DEBUG 2502 --- [Pool-1-worker-1] org.hibernate.SQL : SELECT n.*
FROM notification n
JOIN app_user u ON u.id = n.user_id
WHERE n.last_sent < ?
AND u.notifications_enabled = TRUE
AND NOT EXISTS (
SELECT 1
FROM sleep_session s
WHERE s.user_id = u.id
AND s.stop_time > ?
)
FOR NO KEY UPDATE
2025-05-07T01:51:30.509Z DEBUG 2502 --- [Pool-1-worker-1] org.hibernate.SQL : SELECT n.*
FROM notification n
JOIN app_user u ON u.id = n.user_id
WHERE n.last_sent < ?
AND u.notifications_enabled = TRUE
AND NOT EXISTS (
SELECT 1
FROM sleep_session s
WHERE s.user_id = u.id
AND s.stop_time > ?
)
FOR NO KEY UPDATE
2025-05-07T01:51:30.511Z DEBUG 2502 --- [Pool-1-worker-1] org.hibernate.SQL : SELECT n.*
FROM notification n
JOIN app_user u ON u.id = n.user_id
WHERE n.last_sent < ?
AND u.notifications_enabled = TRUE
AND NOT EXISTS (
SELECT 1
FROM sleep_session s
WHERE s.user_id = u.id
AND s.stop_time > ?
)
FOR NO KEY UPDATE
2025-05-07T01:51:30.515Z DEBUG 2502 --- [Pool-1-worker-1] org.hibernate.SQL : SELECT n.*
FROM notification n
JOIN app_user u ON u.id = n.user_id
WHERE n.last_sent < ?
AND u.notifications_enabled = TRUE
AND NOT EXISTS (
SELECT 1
FROM sleep_session s
WHERE s.user_id = u.id
AND s.stop_time > ?
)
FOR NO KEY UPDATE
2025-05-07T01:51:30.517Z DEBUG 2502 --- [Pool-1-worker-1] org.hibernate.SQL : SELECT n.*
FROM notification n
JOIN app_user u ON u.id = n.user_id
WHERE n.last_sent < ?
AND u.notifications_enabled = TRUE
AND NOT EXISTS (
SELECT 1
FROM sleep_session s
WHERE s.user_id = u.id
AND s.stop_time > ?
)
FOR NO KEY UPDATE
2025-05-07T01:51:30.520Z DEBUG 2502 --- [Pool-1-worker-1] org.hibernate.SQL : SELECT n.*
FROM notification n
JOIN app_user u ON u.id = n.user_id
WHERE n.last_sent < ?
AND u.notifications_enabled = TRUE
AND NOT EXISTS (
SELECT 1
FROM sleep_session s
WHERE s.user_id = u.id
AND s.stop_time > ?
)
FOR NO KEY UPDATE
2025-05-07T01:51:30.528Z DEBUG 2502 --- [Pool-1-worker-5] org.hibernate.SQL : insert into app_user (display_name,email,notifications_enabled,password,public_id,registration_time) values (?,?,?,?,?,?)
2025-05-07T01:51:30.528Z DEBUG 2502 --- [Pool-1-worker-1] org.hibernate.SQL : select u1_0.id,u1_0.display_name,u1_0.email,u1_0.notifications_enabled,u1_0.password,u1_0.public_id,u1_0.registration_time from app_user u1_0 where u1_0.id=?
2025-05-07T01:51:30.530Z DEBUG 2502 --- [Pool-1-worker-5] org.hibernate.SQL : insert into notification (last_sent,user_id) values (?,?)
2025-05-07T01:51:30.531Z DEBUG 2502 --- [Pool-1-worker-5] org.hibernate.SQL : insert into user_role (user_id,role_id) values (?,?)
2025-05-07T01:51:30.533Z DEBUG 2502 --- [Pool-1-worker-5] org.hibernate.SQL : select u1_0.id,u1_0.display_name,u1_0.email,u1_0.notifications_enabled,u1_0.password,u1_0.public_id,u1_0.registration_time from app_user u1_0 where u1_0.email=?
2025-05-07T01:51:30.533Z INFO 2502 --- [Pool-1-worker-1] c.s.s.s.NotificationRetrievalService : Updating notification record for 0196a870-da5a-7260-8f50-6a725fbe59ed from 2025-05-07T01:51:30.393883Z to 2025-05-08T07:51:30.217931655Z
2025-05-07T01:51:30.534Z DEBUG 2502 --- [Pool-1-worker-1] org.hibernate.SQL : update notification set last_sent=? where user_id=?
2025-05-07T01:51:30.535Z DEBUG 2502 --- [Pool-1-worker-5] org.hibernate.SQL : select r1_0.user_id,r1_0.role_id from user_role r1_0 where r1_0.user_id=?
2025-05-07T01:51:30.537Z DEBUG 2502 --- [Pool-1-worker-5] org.hibernate.SQL : select u1_0.id from app_user u1_0 where u1_0.email=? fetch first ? rows only
2025-05-07T01:51:30.538Z DEBUG 2502 --- [Pool-1-worker-1] org.hibernate.SQL : SELECT n.*
FROM notification n
JOIN app_user u ON u.id = n.user_id
WHERE n.last_sent < ?
AND u.notifications_enabled = TRUE
AND NOT EXISTS (
SELECT 1
FROM sleep_session s
WHERE s.user_id = u.id
AND s.stop_time > ?
)
FOR NO KEY UPDATE
2025-05-07T01:51:30.541Z DEBUG 2502 --- [Pool-1-worker-1] org.hibernate.SQL : SELECT n.*
FROM notification n
JOIN app_user u ON u.id = n.user_id
WHERE n.last_sent < ?
AND u.notifications_enabled = TRUE
AND NOT EXISTS (
SELECT 1
FROM sleep_session s
WHERE s.user_id = u.id
AND s.stop_time > ?
)
FOR NO KEY UPDATE
2025-05-07T01:51:30.543Z DEBUG 2502 --- [Pool-1-worker-1] org.hibernate.SQL : SELECT n.*
FROM notification n
JOIN app_user u ON u.id = n.user_id
WHERE n.last_sent < ?
AND u.notifications_enabled = TRUE
AND NOT EXISTS (
SELECT 1
FROM sleep_session s
WHERE s.user_id = u.id
AND s.stop_time > ?
)
FOR NO KEY UPDATE
2025-05-07T01:51:30.547Z DEBUG 2502 --- [Pool-1-worker-1] org.hibernate.SQL : SELECT n.*
FROM notification n
JOIN app_user u ON u.id = n.user_id
WHERE n.last_sent < ?
AND u.notifications_enabled = TRUE
AND NOT EXISTS (
SELECT 1
FROM sleep_session s
WHERE s.user_id = u.id
AND s.stop_time > ?
)
FOR NO KEY UPDATE
2025-05-07T01:51:30.549Z DEBUG 2502 --- [Pool-1-worker-1] org.hibernate.SQL : SELECT n.*
FROM notification n
JOIN app_user u ON u.id = n.user_id
WHERE n.last_sent < ?
AND u.notifications_enabled = TRUE
AND NOT EXISTS (
SELECT 1
FROM sleep_session s
WHERE s.user_id = u.id
AND s.stop_time > ?
)
FOR NO KEY UPDATE
2025-05-07T01:51:30.560Z DEBUG 2502 --- [Pool-1-worker-1] org.hibernate.SQL : SELECT n.*
FROM notification n
JOIN app_user u ON u.id = n.user_id
WHERE n.last_sent < ?
AND u.notifications_enabled = TRUE
AND NOT EXISTS (
SELECT 1
FROM sleep_session s
WHERE s.user_id = u.id
AND s.stop_time > ?
)
FOR NO KEY UPDATE
2025-05-07T01:51:30.565Z DEBUG 2502 --- [Pool-1-worker-1] org.hibernate.SQL : SELECT n.*
FROM notification n
JOIN app_user u ON u.id = n.user_id
WHERE n.last_sent < ?
AND u.notifications_enabled = TRUE
AND NOT EXISTS (
SELECT 1
FROM sleep_session s
WHERE s.user_id = u.id
AND s.stop_time > ?
)
FOR NO KEY UPDATE
2025-05-07T01:51:30.569Z DEBUG 2502 --- [Pool-1-worker-1] org.hibernate.SQL : SELECT n.*
FROM notification n
JOIN app_user u ON u.id = n.user_id
WHERE n.last_sent < ?
AND u.notifications_enabled = TRUE
AND NOT EXISTS (
SELECT 1
FROM sleep_session s
WHERE s.user_id = u.id
AND s.stop_time > ?
)
FOR NO KEY UPDATE
2025-05-07T01:51:30.571Z DEBUG 2502 --- [Pool-1-worker-1] org.hibernate.SQL : SELECT n.*
FROM notification n
JOIN app_user u ON u.id = n.user_id
WHERE n.last_sent < ?
AND u.notifications_enabled = TRUE
AND NOT EXISTS (
SELECT 1
FROM sleep_session s
WHERE s.user_id = u.id
AND s.stop_time > ?
)
FOR NO KEY UPDATE
2025-05-07T01:51:30.572Z DEBUG 2502 --- [Pool-1-worker-1] org.hibernate.SQL : SELECT n.*
FROM notification n
JOIN app_user u ON u.id = n.user_id
WHERE n.last_sent < ?
AND u.notifications_enabled = TRUE
AND NOT EXISTS (
SELECT 1
FROM sleep_session s
WHERE s.user_id = u.id
AND s.stop_time > ?
)
FOR NO KEY UPDATE
2025-05-07T01:51:30.577Z DEBUG 2502 --- [Pool-1-worker-1] org.hibernate.SQL : SELECT n.*
FROM notification n
JOIN app_user u ON u.id = n.user_id
WHERE n.last_sent < ?
AND u.notifications_enabled = TRUE
AND NOT EXISTS (
SELECT 1
FROM sleep_session s
WHERE s.user_id = u.id
AND s.stop_time > ?
)
FOR NO KEY UPDATE
2025-05-07T01:51:30.579Z DEBUG 2502 --- [Pool-1-worker-1] org.hibernate.SQL : SELECT n.*
FROM notification n
JOIN app_user u ON u.id = n.user_id
WHERE n.last_sent < ?
AND u.notifications_enabled = TRUE
AND NOT EXISTS (
SELECT 1
FROM sleep_session s
WHERE s.user_id = u.id
AND s.stop_time > ?
)
FOR NO KEY UPDATE
2025-05-07T01:51:30.582Z DEBUG 2502 --- [Pool-1-worker-1] org.hibernate.SQL : SELECT n.*
FROM notification n
JOIN app_user u ON u.id = n.user_id
WHERE n.last_sent < ?
AND u.notifications_enabled = TRUE
AND NOT EXISTS (
SELECT 1
FROM sleep_session s
WHERE s.user_id = u.id
AND s.stop_time > ?
)
FOR NO KEY UPDATE
2025-05-07T01:51:30.585Z DEBUG 2502 --- [Pool-1-worker-1] org.hibernate.SQL : SELECT n.*
FROM notification n
JOIN app_user u ON u.id = n.user_id
WHERE n.last_sent < ?
AND u.notifications_enabled = TRUE
AND NOT EXISTS (
SELECT 1
FROM sleep_session s
WHERE s.user_id = u.id
AND s.stop_time > ?
)
FOR NO KEY UPDATE
2025-05-07T01:51:30.589Z DEBUG 2502 --- [Pool-1-worker-1] org.hibernate.SQL : SELECT n.*
FROM notification n
JOIN app_user u ON u.id = n.user_id
WHERE n.last_sent < ?
AND u.notifications_enabled = TRUE
AND NOT EXISTS (
SELECT 1
FROM sleep_session s
WHERE s.user_id = u.id
AND s.stop_time > ?
)
FOR NO KEY UPDATE
2025-05-07T01:51:30.591Z DEBUG 2502 --- [Pool-1-worker-1] org.hibernate.SQL : SELECT n.*
FROM notification n
JOIN app_user u ON u.id = n.user_id
WHERE n.last_sent < ?
AND u.notifications_enabled = TRUE
AND NOT EXISTS (
SELECT 1
FROM sleep_session s
WHERE s.user_id = u.id
AND s.stop_time > ?
)
FOR NO KEY UPDATE
2025-05-07T01:51:30.595Z DEBUG 2502 --- [Pool-1-worker-1] org.hibernate.SQL : SELECT n.*
FROM notification n
JOIN app_user u ON u.id = n.user_id
WHERE n.last_sent < ?
AND u.notifications_enabled = TRUE
AND NOT EXISTS (
SELECT 1
FROM sleep_session s
WHERE s.user_id = u.id
AND s.stop_time > ?
)
FOR NO KEY UPDATE
2025-05-07T01:51:30.600Z DEBUG 2502 --- [Pool-1-worker-1] org.hibernate.SQL : SELECT n.*
FROM notification n
JOIN app_user u ON u.id = n.user_id
WHERE n.last_sent < ?
AND u.notifications_enabled = TRUE
AND NOT EXISTS (
SELECT 1
FROM sleep_session s
WHERE s.user_id = u.id
AND s.stop_time > ?
)
FOR NO KEY UPDATE
2025-05-07T01:51:30.602Z DEBUG 2502 --- [Pool-1-worker-1] org.hibernate.SQL : SELECT n.*
FROM notification n
JOIN app_user u ON u.id = n.user_id
WHERE n.last_sent < ?
AND u.notifications_enabled = TRUE
AND NOT EXISTS (
SELECT 1
FROM sleep_session s
WHERE s.user_id = u.id
AND s.stop_time > ?
)
FOR NO KEY UPDATE
2025-05-07T01:51:30.603Z DEBUG 2502 --- [Pool-1-worker-6] org.hibernate.SQL : insert into app_user (display_name,email,notifications_enabled,password,public_id,registration_time) values (?,?,?,?,?,?)
2025-05-07T01:51:30.606Z DEBUG 2502 --- [Pool-1-worker-1] org.hibernate.SQL : SELECT n.*
FROM notification n
JOIN app_user u ON u.id = n.user_id
WHERE n.last_sent < ?
AND u.notifications_enabled = TRUE
AND NOT EXISTS (
SELECT 1
FROM sleep_session s
WHERE s.user_id = u.id
AND s.stop_time > ?
)
FOR NO KEY UPDATE
2025-05-07T01:51:30.608Z DEBUG 2502 --- [Pool-1-worker-6] org.hibernate.SQL : insert into notification (last_sent,user_id) values (?,?)
2025-05-07T01:51:30.610Z DEBUG 2502 --- [Pool-1-worker-6] org.hibernate.SQL : insert into user_role (user_id,role_id) values (?,?)
2025-05-07T01:51:30.611Z DEBUG 2502 --- [Pool-1-worker-1] org.hibernate.SQL : SELECT n.*
FROM notification n
JOIN app_user u ON u.id = n.user_id
WHERE n.last_sent < ?
AND u.notifications_enabled = TRUE
AND NOT EXISTS (
SELECT 1
FROM sleep_session s
WHERE s.user_id = u.id
AND s.stop_time > ?
)
FOR NO KEY UPDATE
2025-05-07T01:51:30.613Z DEBUG 2502 --- [Pool-1-worker-6] org.hibernate.SQL : select u1_0.id,u1_0.display_name,u1_0.email,u1_0.notifications_enabled,u1_0.password,u1_0.public_id,u1_0.registration_time from app_user u1_0 where u1_0.email=?
2025-05-07T01:51:30.618Z DEBUG 2502 --- [Pool-1-worker-1] org.hibernate.SQL : select u1_0.id,u1_0.display_name,u1_0.email,u1_0.notifications_enabled,u1_0.password,u1_0.public_id,u1_0.registration_time from app_user u1_0 where u1_0.public_id=?
2025-05-07T01:51:30.619Z DEBUG 2502 --- [Pool-1-worker-6] org.hibernate.SQL : select r1_0.user_id,r1_0.role_id from user_role r1_0 where r1_0.user_id=?
2025-05-07T01:51:30.621Z DEBUG 2502 --- [Pool-1-worker-1] org.hibernate.SQL : insert into sleep_session (minutes_asleep,minutes_awake,notes,start_time,stop_time,user_id,zone_id,id) values (?,?,?,?,?,?,?,?)
2025-05-07T01:51:30.621Z DEBUG 2502 --- [Pool-1-worker-4] org.hibernate.SQL : insert into app_user (display_name,email,notifications_enabled,password,public_id,registration_time) values (?,?,?,?,?,?)
2025-05-07T01:51:30.623Z DEBUG 2502 --- [Pool-1-worker-6] org.hibernate.SQL : select me1_0.text,me1_0.type_id from message me1_0 join app_user u1_0 on u1_0.id=me1_0.user_id where u1_0.public_id=? and me1_0.time>=? order by me1_0.time
2025-05-07T01:51:30.626Z DEBUG 2502 --- [Pool-1-worker-4] org.hibernate.SQL : insert into notification (last_sent,user_id) values (?,?)
2025-05-07T01:51:30.627Z DEBUG 2502 --- [Pool-1-worker-1] org.hibernate.SQL : SELECT n.*
FROM notification n
JOIN app_user u ON u.id = n.user_id
WHERE n.last_sent < ?
AND u.notifications_enabled = TRUE
AND NOT EXISTS (
SELECT 1
FROM sleep_session s
WHERE s.user_id = u.id
AND s.stop_time > ?
)
FOR NO KEY UPDATE
2025-05-07T01:51:30.630Z DEBUG 2502 --- [Pool-1-worker-4] org.hibernate.SQL : insert into user_role (user_id,role_id) values (?,?)
2025-05-07T01:51:30.634Z DEBUG 2502 --- [Pool-1-worker-1] org.hibernate.SQL : SELECT n.*
FROM notification n
JOIN app_user u ON u.id = n.user_id
WHERE n.last_sent < ?
AND u.notifications_enabled = TRUE
AND NOT EXISTS (
SELECT 1
FROM sleep_session s
WHERE s.user_id = u.id
AND s.stop_time > ?
)
FOR NO KEY UPDATE
2025-05-07T01:51:30.634Z DEBUG 2502 --- [Pool-1-worker-4] org.hibernate.SQL : select u1_0.id from app_user u1_0 where u1_0.email=? fetch first ? rows only
2025-05-07T01:51:30.636Z DEBUG 2502 --- [Pool-1-worker-1] org.hibernate.SQL : SELECT n.*
FROM notification n
JOIN app_user u ON u.id = n.user_id
WHERE n.last_sent < ?
AND u.notifications_enabled = TRUE
AND NOT EXISTS (
SELECT 1
FROM sleep_session s
WHERE s.user_id = u.id
AND s.stop_time > ?
)
FOR NO KEY UPDATE
2025-05-07T01:51:30.640Z DEBUG 2502 --- [Pool-1-worker-1] org.hibernate.SQL : SELECT n.*
FROM notification n
JOIN app_user u ON u.id = n.user_id
WHERE n.last_sent < ?
AND u.notifications_enabled = TRUE
AND NOT EXISTS (
SELECT 1
FROM sleep_session s
WHERE s.user_id = u.id
AND s.stop_time > ?
)
FOR NO KEY UPDATE
2025-05-07T01:51:30.644Z DEBUG 2502 --- [Pool-1-worker-1] org.hibernate.SQL : SELECT n.*
FROM notification n
JOIN app_user u ON u.id = n.user_id
WHERE n.last_sent < ?
AND u.notifications_enabled = TRUE
AND NOT EXISTS (
SELECT 1
FROM sleep_session s
WHERE s.user_id = u.id
AND s.stop_time > ?
)
FOR NO KEY UPDATE
2025-05-07T01:51:30.646Z DEBUG 2502 --- [Pool-1-worker-1] org.hibernate.SQL : SELECT n.*
FROM notification n
JOIN app_user u ON u.id = n.user_id
WHERE n.last_sent < ?
AND u.notifications_enabled = TRUE
AND NOT EXISTS (
SELECT 1
FROM sleep_session s
WHERE s.user_id = u.id
AND s.stop_time > ?
)
FOR NO KEY UPDATE
2025-05-07T01:51:30.651Z DEBUG 2502 --- [Pool-1-worker-1] org.hibernate.SQL : SELECT n.*
FROM notification n
JOIN app_user u ON u.id = n.user_id
WHERE n.last_sent < ?
AND u.notifications_enabled = TRUE
AND NOT EXISTS (
SELECT 1
FROM sleep_session s
WHERE s.user_id = u.id
AND s.stop_time > ?
)
FOR NO KEY UPDATE
2025-05-07T01:51:30.655Z DEBUG 2502 --- [Pool-1-worker-1] org.hibernate.SQL : SELECT n.*
FROM notification n
JOIN app_user u ON u.id = n.user_id
WHERE n.last_sent < ?
AND u.notifications_enabled = TRUE
AND NOT EXISTS (
SELECT 1
FROM sleep_session s
WHERE s.user_id = u.id
AND s.stop_time > ?
)
FOR NO KEY UPDATE
2025-05-07T01:51:30.657Z DEBUG 2502 --- [Pool-1-worker-1] org.hibernate.SQL : SELECT n.*
FROM notification n
JOIN app_user u ON u.id = n.user_id
WHERE n.last_sent < ?
AND u.notifications_enabled = TRUE
AND NOT EXISTS (
SELECT 1
FROM sleep_session s
WHERE s.user_id = u.id
AND s.stop_time > ?
)
FOR NO KEY UPDATE
2025-05-07T01:51:30.658Z DEBUG 2502 --- [Pool-1-worker-5] org.hibernate.SQL : insert into app_user (display_name,email,notifications_enabled,password,public_id,registration_time) values (?,?,?,?,?,?)
2025-05-07T01:51:30.659Z DEBUG 2502 --- [Pool-1-worker-1] org.hibernate.SQL : SELECT n.*
FROM notification n
JOIN app_user u ON u.id = n.user_id
WHERE n.last_sent < ?
AND u.notifications_enabled = TRUE
AND NOT EXISTS (
SELECT 1
FROM sleep_session s
WHERE s.user_id = u.id
AND s.stop_time > ?
)
FOR NO KEY UPDATE
2025-05-07T01:51:30.661Z DEBUG 2502 --- [Pool-1-worker-5] org.hibernate.SQL : insert into notification (last_sent,user_id) values (?,?)
2025-05-07T01:51:30.662Z DEBUG 2502 --- [Pool-1-worker-1] org.hibernate.SQL : SELECT n.*
FROM notification n
JOIN app_user u ON u.id = n.user_id
WHERE n.last_sent < ?
AND u.notifications_enabled = TRUE
AND NOT EXISTS (
SELECT 1
FROM sleep_session s
WHERE s.user_id = u.id
AND s.stop_time > ?
)
FOR NO KEY UPDATE
2025-05-07T01:51:30.663Z DEBUG 2502 --- [Pool-1-worker-5] org.hibernate.SQL : insert into user_role (user_id,role_id) values (?,?)
2025-05-07T01:51:30.664Z DEBUG 2502 --- [Pool-1-worker-1] org.hibernate.SQL : SELECT n.*
FROM notification n
JOIN app_user u ON u.id = n.user_id
WHERE n.last_sent < ?
AND u.notifications_enabled = TRUE
AND NOT EXISTS (
SELECT 1
FROM sleep_session s
WHERE s.user_id = u.id
AND s.stop_time > ?
)
FOR NO KEY UPDATE
2025-05-07T01:51:30.668Z DEBUG 2502 --- [Pool-1-worker-1] org.hibernate.SQL : SELECT n.*
FROM notification n
JOIN app_user u ON u.id = n.user_id
WHERE n.last_sent < ?
AND u.notifications_enabled = TRUE
AND NOT EXISTS (
SELECT 1
FROM sleep_session s
WHERE s.user_id = u.id
AND s.stop_time > ?
)
FOR NO KEY UPDATE
2025-05-07T01:51:30.668Z DEBUG 2502 --- [Pool-1-worker-5] org.hibernate.SQL : select u1_0.id,u1_0.display_name,u1_0.email,u1_0.notifications_enabled,u1_0.password,u1_0.public_id,u1_0.registration_time from app_user u1_0 where u1_0.email=?
2025-05-07T01:51:30.670Z DEBUG 2502 --- [Pool-1-worker-1] org.hibernate.SQL : SELECT n.*
FROM notification n
JOIN app_user u ON u.id = n.user_id
WHERE n.last_sent < ?
AND u.notifications_enabled = TRUE
AND NOT EXISTS (
SELECT 1
FROM sleep_session s
WHERE s.user_id = u.id
AND s.stop_time > ?
)
FOR NO KEY UPDATE
2025-05-07T01:51:30.671Z DEBUG 2502 --- [Pool-1-worker-5] org.hibernate.SQL : select r1_0.user_id,r1_0.role_id from user_role r1_0 where r1_0.user_id=?
2025-05-07T01:51:30.678Z DEBUG 2502 --- [Pool-1-worker-5] org.hibernate.SQL : select u1_0.id,u1_0.display_name,u1_0.email,u1_0.notifications_enabled,u1_0.password,u1_0.public_id,u1_0.registration_time from app_user u1_0 where u1_0.public_id=?
2025-05-07T01:51:30.681Z DEBUG 2502 --- [Pool-1-worker-5] org.hibernate.SQL : insert into challenge (description,finish,name,start,user_id,id) values (?,?,?,?,?,?)
2025-05-07T01:51:30.681Z DEBUG 2502 --- [Pool-1-worker-1] org.hibernate.SQL : SELECT n.*
FROM notification n
JOIN app_user u ON u.id = n.user_id
WHERE n.last_sent < ?
AND u.notifications_enabled = TRUE
AND NOT EXISTS (
SELECT 1
FROM sleep_session s
WHERE s.user_id = u.id
AND s.stop_time > ?
)
FOR NO KEY UPDATE
2025-05-07T01:51:30.683Z DEBUG 2502 --- [Pool-1-worker-5] org.hibernate.SQL : select u1_0.id,u1_0.display_name,u1_0.email,u1_0.notifications_enabled,u1_0.password,u1_0.public_id,u1_0.registration_time from app_user u1_0 where u1_0.public_id=?
2025-05-07T01:51:30.687Z DEBUG 2502 --- [Pool-1-worker-5] org.hibernate.SQL : insert into challenge (description,finish,name,start,user_id,id) values (?,?,?,?,?,?)
2025-05-07T01:51:30.688Z DEBUG 2502 --- [Pool-1-worker-1] org.hibernate.SQL : SELECT n.*
FROM notification n
JOIN app_user u ON u.id = n.user_id
WHERE n.last_sent < ?
AND u.notifications_enabled = TRUE
AND NOT EXISTS (
SELECT 1
FROM sleep_session s
WHERE s.user_id = u.id
AND s.stop_time > ?
)
FOR NO KEY UPDATE
2025-05-07T01:51:30.693Z DEBUG 2502 --- [Pool-1-worker-1] org.hibernate.SQL : SELECT n.*
FROM notification n
JOIN app_user u ON u.id = n.user_id
WHERE n.last_sent < ?
AND u.notifications_enabled = TRUE
AND NOT EXISTS (
SELECT 1
FROM sleep_session s
WHERE s.user_id = u.id
AND s.stop_time > ?
)
FOR NO KEY UPDATE
2025-05-07T01:51:30.695Z DEBUG 2502 --- [Pool-1-worker-1] org.hibernate.SQL : SELECT n.*
FROM notification n
JOIN app_user u ON u.id = n.user_id
WHERE n.last_sent < ?
AND u.notifications_enabled = TRUE
AND NOT EXISTS (
SELECT 1
FROM sleep_session s
WHERE s.user_id = u.id
AND s.stop_time > ?
)
FOR NO KEY UPDATE
2025-05-07T01:51:30.696Z DEBUG 2502 --- [Pool-1-worker-1] org.hibernate.SQL : SELECT n.*
FROM notification n
JOIN app_user u ON u.id = n.user_id
WHERE n.last_sent < ?
AND u.notifications_enabled = TRUE
AND NOT EXISTS (
SELECT 1
FROM sleep_session s
WHERE s.user_id = u.id
AND s.stop_time > ?
)
FOR NO KEY UPDATE
2025-05-07T01:51:30.701Z DEBUG 2502 --- [Pool-1-worker-1] org.hibernate.SQL : SELECT n.*
FROM notification n
JOIN app_user u ON u.id = n.user_id
WHERE n.last_sent < ?
AND u.notifications_enabled = TRUE
AND NOT EXISTS (
SELECT 1
FROM sleep_session s
WHERE s.user_id = u.id
AND s.stop_time > ?
)
FOR NO KEY UPDATE
2025-05-07T01:51:30.705Z DEBUG 2502 --- [Pool-1-worker-1] org.hibernate.SQL : SELECT n.*
FROM notification n
JOIN app_user u ON u.id = n.user_id
WHERE n.last_sent < ?
AND u.notifications_enabled = TRUE
AND NOT EXISTS (
SELECT 1
FROM sleep_session s
WHERE s.user_id = u.id
AND s.stop_time > ?
)
FOR NO KEY UPDATE
2025-05-07T01:51:30.708Z DEBUG 2502 --- [Pool-1-worker-5] org.hibernate.SQL : select u1_0.id from app_user u1_0 where u1_0.email=? fetch first ? rows only
2025-05-07T01:51:30.709Z DEBUG 2502 --- [Pool-1-worker-1] org.hibernate.SQL : SELECT n.*
FROM notification n
JOIN app_user u ON u.id = n.user_id
WHERE n.last_sent < ?
AND u.notifications_enabled = TRUE
AND NOT EXISTS (
SELECT 1
FROM sleep_session s
WHERE s.user_id = u.id
AND s.stop_time > ?
)
FOR NO KEY UPDATE
2025-05-07T01:51:30.713Z DEBUG 2502 --- [Pool-1-worker-1] org.hibernate.SQL : SELECT n.*
FROM notification n
JOIN app_user u ON u.id = n.user_id
WHERE n.last_sent < ?
AND u.notifications_enabled = TRUE
AND NOT EXISTS (
SELECT 1
FROM sleep_session s
WHERE s.user_id = u.id
AND s.stop_time > ?
)
FOR NO KEY UPDATE
2025-05-07T01:51:30.716Z DEBUG 2502 --- [Pool-1-worker-1] org.hibernate.SQL : SELECT n.*
FROM notification n
JOIN app_user u ON u.id = n.user_id
WHERE n.last_sent < ?
AND u.notifications_enabled = TRUE
AND NOT EXISTS (
SELECT 1
FROM sleep_session s
WHERE s.user_id = u.id
AND s.stop_time > ?
)
FOR NO KEY UPDATE