2025-05-07T01:51:30.884Z 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.888Z 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.891Z 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.894Z 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.898Z 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.900Z 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.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:30.904Z 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.908Z 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.912Z 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.914Z 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.915Z 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.919Z 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.923Z 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.925Z 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.926Z 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.929Z 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.932Z 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.936Z 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.940Z 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.944Z 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.946Z 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.947Z 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.950Z 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.953Z 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.954Z 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.958Z DEBUG 2502 --- [Pool-1-worker-4] org.hibernate.SQL : insert into notification (last_sent,user_id) values (?,?)
2025-05-07T01:51:30.959Z DEBUG 2502 --- [Pool-1-worker-4] org.hibernate.SQL : insert into user_role (user_id,role_id) values (?,?)
2025-05-07T01:51:30.959Z 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.961Z 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:31.079Z 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:31.080Z DEBUG 2502 --- [Pool-1-worker-4] org.hibernate.SQL : select count(u1_0.id) from app_user u1_0
2025-05-07T01:51:31.082Z 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:31.263Z 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:31.264Z DEBUG 2502 --- [Pool-1-worker-1] org.hibernate.SQL : insert into app_user (display_name,email,notifications_enabled,password,public_id,registration_time) values (?,?,?,?,?,?)
2025-05-07T01:51:31.266Z DEBUG 2502 --- [Pool-1-worker-1] org.hibernate.SQL : insert into notification (last_sent,user_id) values (?,?)
2025-05-07T01:51:31.267Z DEBUG 2502 --- [Pool-1-worker-1] org.hibernate.SQL : insert into user_role (user_id,role_id) values (?,?)
2025-05-07T01:51:31.269Z 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.email=?
2025-05-07T01:51:31.272Z 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:31.275Z 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:31.276Z 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:31.279Z 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:31.281Z 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:31.286Z 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:31.289Z 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:31.293Z 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:31.297Z 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:31.299Z 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:31.301Z 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:31.303Z 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:31.304Z 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:31.306Z 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:31.307Z 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:31.309Z 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:31.310Z 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:31.312Z 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:31.314Z 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:31.315Z 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:31.319Z 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:31.323Z INFO 2502 --- [o-auto-1-exec-2] r$InitializeUserDetailsManagerConfigurer : Global AuthenticationManager configured with UserDetailsService bean with name appUserDetailsService
2025-05-07T01:51:31.324Z 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:31.326Z 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:31.333Z 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:31.335Z 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:31.337Z 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:31.341Z 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:31.343Z 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:31.347Z 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:31.354Z 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:31.358Z 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:31.360Z 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:31.361Z 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:31.364Z 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:31.366Z 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:31.367Z 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:31.369Z 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:31.371Z 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:31.371Z 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:31.373Z 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:31.375Z 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:31.385Z DEBUG 2502 --- [Pool-1-worker-5] org.hibernate.SQL : insert into notification (last_sent,user_id) values (?,?)
2025-05-07T01:51:31.386Z 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:31.388Z DEBUG 2502 --- [Pool-1-worker-5] org.hibernate.SQL : insert into user_role (user_id,role_id) values (?,?)
2025-05-07T01:51:31.388Z 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:31.390Z 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:31.392Z 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:31.394Z 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:31.395Z 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:31.396Z 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:31.398Z 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:31.400Z 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:31.402Z 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:31.402Z DEBUG 2502 --- [Pool-1-worker-5] 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:31.403Z 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:31.405Z 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:31.407Z DEBUG 2502 --- [Pool-1-worker-5] org.hibernate.SQL : select ss1_0.id,ss1_0.minutes_asleep,ss1_0.minutes_awake,ss1_0.notes,ss1_0.start_time,ss1_0.stop_time,ss1_0.user_id,ss1_0.zone_id from sleep_session ss1_0 join app_user u1_0 on u1_0.id=ss1_0.user_id where u1_0.public_id=? and ss1_0.id=?
2025-05-07T01:51:31.408Z 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:31.411Z 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:31.412Z DEBUG 2502 --- [Pool-1-worker-5] org.hibernate.SQL : select ss1_0.id,ss1_0.minutes_asleep,ss1_0.minutes_awake,ss1_0.notes,ss1_0.start_time,ss1_0.stop_time,ss1_0.user_id,ss1_0.zone_id from sleep_session ss1_0 join app_user u1_0 on u1_0.id=ss1_0.user_id where u1_0.public_id=? and ss1_0.id=?
2025-05-07T01:51:31.413Z 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:31.414Z DEBUG 2502 --- [Pool-1-worker-5] org.hibernate.SQL : update sleep_session set minutes_asleep=?,minutes_awake=?,notes=?,start_time=?,stop_time=?,user_id=?,zone_id=? where id=?
2025-05-07T01:51:31.416Z DEBUG 2502 --- [Pool-1-worker-5] org.hibernate.SQL : select ss1_0.id,ss1_0.minutes_asleep,ss1_0.minutes_awake,ss1_0.notes,ss1_0.start_time,ss1_0.stop_time,ss1_0.user_id,ss1_0.zone_id from sleep_session ss1_0 join app_user u1_0 on u1_0.id=ss1_0.user_id where u1_0.public_id=? and ss1_0.id=?
2025-05-07T01:51:31.417Z 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:31.419Z 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:31.421Z 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:31.423Z 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:31.425Z 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:31.426Z 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:31.428Z 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:31.430Z 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:31.433Z 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:31.435Z 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:31.436Z 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:31.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:31.441Z 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:31.443Z 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:31.445Z 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:31.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:31.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:31.459Z 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:31.461Z 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:31.463Z 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:31.465Z 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:31.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:31.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:31.472Z 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:31.474Z 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:31.477Z 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:31.479Z 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:31.481Z 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:31.485Z 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:31.487Z 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:31.488Z 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:31.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:31.495Z 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:31.498Z 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:31.586Z 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:31.603Z DEBUG 2502 --- [Pool-1-worker-1] org.hibernate.SQL : insert into app_user (display_name,email,notifications_enabled,password,public_id,registration_time) values (?,?,?,?,?,?)
2025-05-07T01:51:31.605Z DEBUG 2502 --- [Pool-1-worker-1] org.hibernate.SQL : insert into notification (last_sent,user_id) values (?,?)
2025-05-07T01:51:31.606Z DEBUG 2502 --- [Pool-1-worker-1] org.hibernate.SQL : insert into user_role (user_id,role_id) values (?,?)
2025-05-07T01:51:31.610Z 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.email=?
2025-05-07T01:51:31.614Z 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:31.617Z 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:31.618Z 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:31.620Z 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:31.621Z 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:31.623Z 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:31.625Z 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:31.627Z 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:31.629Z 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:31.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:31.635Z 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:31.638Z 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:31.639Z 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:31.639Z INFO 2502 --- [o-auto-1-exec-2] o.s.s.w.a.c.ChannelProcessingFilter : Validated configuration attributes
2025-05-07T01:51:31.642Z 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:31.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:31.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:31.647Z 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:31.649Z 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:31.654Z 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:31.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:31.661Z 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:31.663Z 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:31.669Z 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:31.673Z 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:31.676Z 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:31.679Z 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:31.683Z 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:31.684Z 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:31.686Z DEBUG 2502 --- [Pool-1-worker-5] org.hibernate.SQL : insert into notification (last_sent,user_id) values (?,?)
2025-05-07T01:51:31.687Z DEBUG 2502 --- [Pool-1-worker-5] org.hibernate.SQL : insert into user_role (user_id,role_id) values (?,?)
2025-05-07T01:51:31.690Z 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:31.691Z 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:31.694Z 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:31.695Z DEBUG 2502 --- [Pool-1-worker-5] 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:31.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:31.697Z 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:31.699Z DEBUG 2502 --- [Pool-1-worker-5] 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:31.706Z 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:31.707Z 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:31.707Z 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:31.709Z DEBUG 2502 --- [Pool-1-worker-5] 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:31.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:31.713Z 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:31.714Z 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:31.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
2025-05-07T01:51:31.717Z 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:31.718Z DEBUG 2502 --- [Pool-1-worker-5] 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:31.720Z 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:31.722Z 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:31.723Z 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:31.724Z 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:31.725Z DEBUG 2502 --- [Pool-1-worker-5] 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:31.726Z 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:31.729Z 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:31.730Z 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:31.732Z DEBUG 2502 --- [Pool-1-worker-5] 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:31.733Z 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:31.735Z 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:31.735Z 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:31.736Z 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:31.737Z DEBUG 2502 --- [Pool-1-worker-5] 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:31.738Z 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:31.740Z 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:31.741Z 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:31.742Z 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:31.743Z 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:31.744Z DEBUG 2502 --- [Pool-1-worker-5] 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:31.745Z 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:31.746Z 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:31.748Z 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:31.748Z 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:31.749Z DEBUG 2502 --- [Pool-1-worker-5] 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:31.751Z 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:31.752Z 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:31.754Z 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:31.755Z DEBUG 2502 --- [Pool-1-worker-5] 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:31.756Z 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:31.758Z DEBUG 2502 --- [Pool-1-worker-5] org.hibernate.SQL : select ss1_0.stop_time,ss1_0.minutes_asleep,ss1_0.zone_id from sleep_session ss1_0 join app_user u1_0 on u1_0.id=ss1_0.user_id where u1_0.public_id=? and ss1_0.stop_time>=? and ss1_0.stop_time<=? order by ss1_0.stop_time
2025-05-07T01:51:31.760Z 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:31.761Z 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:31.764Z 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:31.766Z 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:31.767Z 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