[DEBUG] 2025-03-15 13:30:55 +09:00 service QQE::Service::Site->execute execute
[DEBUG] 2025-03-15 13:30:55 +09:00 service QQE::Service::Site::Basic::Teacher->view execute
[DEBUG] 2025-03-15 13:30:55 +09:00 service QQE::Service::Auth::Student->check_token execute
[DEBUG] 2025-03-15 13:30:55 +09:00 service QQE::Service::Auth->check_token execute
[DEBUG] 2025-03-15 13:30:55 +09:00 service QQE::Service::Auth->check_token failed 301 token が指定されていません
[DEBUG] 2025-03-15 13:30:55 +09:00 service QQE::Service::Auth::Student->check_token failed 301 token が指定されていません
[DEBUG] 2025-03-15 13:30:55 +09:00 service QQE::Service::SNS::Teacher->view execute
[DEBUG] 2025-03-15 13:30:55 +09:00 schema DB=default table=teacher SELECT * FROM teacher WHERE deleted_flag = 'f' AND id = '293363471' LIMIT 1 OFFSET 0
[DEBUG] 2025-03-15 13:30:55 +09:00 schema DB=default table=community SELECT * FROM community WHERE type_id = 1 AND owner_code = ? AND deleted_flag = 'f' ORDER BY id ASC LIMIT 1 OFFSET 0 teacher:293363471
[DEBUG] 2025-03-15 13:30:55 +09:00 service QQE::Service::SNS::Teacher->view success
[DEBUG] 2025-03-15 13:30:55 +09:00 service QQE::Service::Site::Basic::Teacher->view success
[DEBUG] 2025-03-15 13:30:55 +09:00 service QQE::Service::Site->execute success
[DEBUG] 2025-03-15 13:30:55 +09:00 schema DB=default table=curriculum_original SELECT * FROM curriculum_original WHERE code = 'C0376' AND deleted_flag = 'f' LIMIT 1 OFFSET 0
[DEBUG] 2025-03-15 13:30:55 +09:00 schema DB=default table=curriculum_original SELECT * FROM curriculum_original WHERE code = 'C0486' AND deleted_flag = 'f' LIMIT 1 OFFSET 0
[DEBUG] 2025-03-15 13:30:55 +09:00 schema DB=default table=curriculum_original SELECT * FROM curriculum_original WHERE code = 'C0350' AND deleted_flag = 'f' LIMIT 1 OFFSET 0
[DEBUG] 2025-03-15 13:30:55 +09:00 schema DB=default table=curriculum_original SELECT * FROM curriculum_original WHERE code = 'C0185' AND deleted_flag = 'f' LIMIT 1 OFFSET 0
[DEBUG] 2025-03-15 13:30:55 +09:00 schema DB=default table=curriculum_original SELECT * FROM curriculum_original WHERE code = 'C0182' AND deleted_flag = 'f' LIMIT 1 OFFSET 0
[DEBUG] 2025-03-15 13:30:55 +09:00 schema DB=default table=curriculum_original SELECT * FROM curriculum_original WHERE code = 'C0179' AND deleted_flag = 'f' LIMIT 1 OFFSET 0
[DEBUG] 2025-03-15 13:30:55 +09:00 schema DB=default table=curriculum_original SELECT * FROM curriculum_original WHERE code = 'C0168' AND deleted_flag = 'f' LIMIT 1 OFFSET 0
[DEBUG] 2025-03-15 13:30:55 +09:00 schema DB=default table=curriculum_original SELECT * FROM curriculum_original WHERE code = 'C0129' AND deleted_flag = 'f' LIMIT 1 OFFSET 0
[DEBUG] 2025-03-15 13:30:55 +09:00 schema DB=default table=curriculum_original SELECT * FROM curriculum_original WHERE code = 'C0234' AND deleted_flag = 'f' LIMIT 1 OFFSET 0
[DEBUG] 2025-03-15 13:30:55 +09:00 schema DB=default table=curriculum_original SELECT * FROM curriculum_original WHERE code = 'C0146' AND deleted_flag = 'f' LIMIT 1 OFFSET 0
[DEBUG] 2025-03-15 13:30:55 +09:00 schema DB=default table=curriculum_original SELECT * FROM curriculum_original WHERE code = 'C0180' AND deleted_flag = 'f' LIMIT 1 OFFSET 0
[DEBUG] 2025-03-15 13:30:55 +09:00 schema DB=default table=curriculum_original SELECT * FROM curriculum_original WHERE code = 'C0215' AND deleted_flag = 'f' LIMIT 1 OFFSET 0
[DEBUG] 2025-03-15 13:30:55 +09:00 schema DB=default table=curriculum_original SELECT * FROM curriculum_original WHERE code = 'C0217' AND deleted_flag = 'f' LIMIT 1 OFFSET 0
[DEBUG] 2025-03-15 13:30:55 +09:00 schema DB=default table=curriculum_original SELECT * FROM curriculum_original WHERE code = 'C0230' AND deleted_flag = 'f' LIMIT 1 OFFSET 0
[DEBUG] 2025-03-15 13:30:55 +09:00 schema DB=default table=curriculum_original SELECT * FROM curriculum_original WHERE code = 'C0344' AND deleted_flag = 'f' LIMIT 1 OFFSET 0
[DEBUG] 2025-03-15 13:30:55 +09:00 schema DB=default table=curriculum_original SELECT * FROM curriculum_original WHERE code = 'C0359' AND deleted_flag = 'f' LIMIT 1 OFFSET 0
[DEBUG] 2025-03-15 13:30:55 +09:00 schema DB=default table=curriculum_original SELECT * FROM curriculum_original WHERE code = 'C0360' AND deleted_flag = 'f' LIMIT 1 OFFSET 0
[DEBUG] 2025-03-15 13:30:55 +09:00 schema DB=default table=curriculum_original SELECT * FROM curriculum_original WHERE code = 'C0368' AND deleted_flag = 'f' LIMIT 1 OFFSET 0
[DEBUG] 2025-03-15 13:30:55 +09:00 schema DB=default table=curriculum_original SELECT * FROM curriculum_original WHERE code = 'C0393' AND deleted_flag = 'f' LIMIT 1 OFFSET 0
[DEBUG] 2025-03-15 13:30:55 +09:00 schema DB=default table=curriculum_original SELECT * FROM curriculum_original WHERE code = 'C0399' AND deleted_flag = 'f' LIMIT 1 OFFSET 0
[DEBUG] 2025-03-15 13:30:55 +09:00 schema DB=default table=curriculum_original SELECT * FROM curriculum_original WHERE code = 'C0404' AND deleted_flag = 'f' LIMIT 1 OFFSET 0
[DEBUG] 2025-03-15 13:30:55 +09:00 schema DB=default table=curriculum_original SELECT * FROM curriculum_original WHERE code = 'C0424' AND deleted_flag = 'f' LIMIT 1 OFFSET 0
[DEBUG] 2025-03-15 13:30:55 +09:00 schema DB=default table=curriculum_original SELECT * FROM curriculum_original WHERE code = 'C0428' AND deleted_flag = 'f' LIMIT 1 OFFSET 0
[DEBUG] 2025-03-15 13:30:55 +09:00 schema DB=default table=curriculum_original SELECT * FROM curriculum_original WHERE code = 'C0429' AND deleted_flag = 'f' LIMIT 1 OFFSET 0
[DEBUG] 2025-03-15 13:30:55 +09:00 schema DB=default table=curriculum_original SELECT * FROM curriculum_original WHERE code = 'C0441' AND deleted_flag = 'f' LIMIT 1 OFFSET 0
[DEBUG] 2025-03-15 13:30:55 +09:00 schema DB=default table=curriculum_original SELECT * FROM curriculum_original WHERE code = 'C0444' AND deleted_flag = 'f' LIMIT 1 OFFSET 0
[DEBUG] 2025-03-15 13:30:55 +09:00 schema DB=default table=curriculum_original SELECT * FROM curriculum_original WHERE code = 'C0445' AND deleted_flag = 'f' LIMIT 1 OFFSET 0
[DEBUG] 2025-03-15 13:30:55 +09:00 schema DB=default table=curriculum_original SELECT * FROM curriculum_original WHERE code = 'C0446' AND deleted_flag = 'f' LIMIT 1 OFFSET 0
[DEBUG] 2025-03-15 13:30:55 +09:00 schema DB=default table=curriculum_original SELECT * FROM curriculum_original WHERE code = 'C0447' AND deleted_flag = 'f' LIMIT 1 OFFSET 0
[DEBUG] 2025-03-15 13:30:55 +09:00 schema DB=default table=curriculum_original SELECT * FROM curriculum_original WHERE code = 'C0470' AND deleted_flag = 'f' LIMIT 1 OFFSET 0
[DEBUG] 2025-03-15 13:30:55 +09:00 schema DB=default table=curriculum_original SELECT * FROM curriculum_original WHERE code = 'C0472' AND deleted_flag = 'f' LIMIT 1 OFFSET 0
[DEBUG] 2025-03-15 13:30:55 +09:00 schema DB=default table=curriculum_original SELECT * FROM curriculum_original WHERE code = 'C0478' AND deleted_flag = 'f' LIMIT 1 OFFSET 0
[DEBUG] 2025-03-15 13:30:55 +09:00 schema DB=default table=curriculum_original SELECT * FROM curriculum_original WHERE code = 'C0480' AND deleted_flag = 'f' LIMIT 1 OFFSET 0
[DEBUG] 2025-03-15 13:30:55 +09:00 schema DB=default table=curriculum_original SELECT * FROM curriculum_original WHERE code = 'C0490' AND deleted_flag = 'f' LIMIT 1 OFFSET 0
[DEBUG] 2025-03-15 13:30:55 +09:00 service QQE::Service::Site->execute execute
[DEBUG] 2025-03-15 13:30:55 +09:00 service QQE::Service::Site::Basic::Schedule::Teacher->get_collection_of_week execute
[DEBUG] 2025-03-15 13:30:55 +09:00 service QQE::Service::Auth::Student->check_token execute
[DEBUG] 2025-03-15 13:30:55 +09:00 service QQE::Service::Auth->check_token execute
[DEBUG] 2025-03-15 13:30:55 +09:00 service QQE::Service::Auth->check_token failed 301 token が指定されていません
[DEBUG] 2025-03-15 13:30:55 +09:00 service QQE::Service::Auth::Student->check_token failed 301 token が指定されていません
[DEBUG] 2025-03-15 13:30:55 +09:00 schema DB=default table=teacher_schedule SELECT * FROM teacher_schedule WHERE teacher_id = ? AND ((start_time >= ? AND start_time < ?) OR (end_time > ? AND end_time <= ?) OR (start_time <= ? AND end_time > ?) OR (start_time <= ? AND end_time > ? )) AND deleted_flag = 'f' ORDER BY start_time ASC, id ASC 293363471 2025-03-09 12:00:00 +09:00 2025-03-09 20:00:00 +09:00 2025-03-09 12:00:00 +09:00 2025-03-09 20:00:00 +09:00 2025-03-09 12:00:00 +09:00 2025-03-09 20:00:00 +09:00 2025-03-09 12:00:00 +09:00 2025-03-09 20:00:00 +09:00
[DEBUG] 2025-03-15 13:30:55 +09:00 schema DB=default table=room_schedule SELECT * FROM room_schedule WHERE teacher_id = ? AND ((start_time >= ? AND start_time < ?) OR (end_time > ? AND end_time <= ?) OR (start_time <= ? AND end_time > ?) OR (start_time <= ? AND end_time > ? )) AND deleted_flag = 'f' ORDER BY start_time ASC, id ASC 293363471 2025-03-09 12:00:00 +09:00 2025-03-09 20:00:00 +09:00 2025-03-09 12:00:00 +09:00 2025-03-09 20:00:00 +09:00 2025-03-09 12:00:00 +09:00 2025-03-09 20:00:00 +09:00 2025-03-09 12:00:00 +09:00 2025-03-09 20:00:00 +09:00
[DEBUG] 2025-03-15 13:30:55 +09:00 schema DB=default table=company_contract_group_schedule SELECT * FROM company_contract_group_schedule WHERE teacher_ids && ARRAY[293363471] AND ((start_time >= ? AND start_time < ?) OR (end_time > ? AND end_time <= ?) OR (start_time <= ? AND end_time > ?) OR (start_time <= ? AND end_time > ? )) AND deleted_flag = 'f' ORDER BY start_time ASC, id ASC 2025-03-09 12:00:00 +09:00 2025-03-09 20:00:00 +09:00 2025-03-09 12:00:00 +09:00 2025-03-09 20:00:00 +09:00 2025-03-09 12:00:00 +09:00 2025-03-09 20:00:00 +09:00 2025-03-09 12:00:00 +09:00 2025-03-09 20:00:00 +09:00
[DEBUG] 2025-03-15 13:30:55 +09:00 schema DB=default table=lesson SELECT * FROM lesson WHERE teacher_id = ? AND ((start_time >= ? AND start_time < ?) OR (end_time > ? AND end_time <= ?) OR (start_time <= ? AND end_time > ?) OR (start_time <= ? AND ? < end_time)) AND canceled_flag = 'f' AND deleted_flag = 'f' ORDER BY start_time ASC, id ASC 293363471 2025-03-09 12:00:00 +09:00 2025-03-09 20:00:00 +09:00 2025-03-09 12:00:00 +09:00 2025-03-09 20:00:00 +09:00 2025-03-09 12:00:00 +09:00 2025-03-09 20:00:00 +09:00 2025-03-09 12:00:00 +09:00 2025-03-09 20:00:00 +09:00
[DEBUG] 2025-03-15 13:30:56 +09:00 schema DB=default table=student SELECT * FROM student WHERE id in (285942581,235193071) AND deleted_flag = 'f'
[DEBUG] 2025-03-15 13:30:56 +09:00 schema DB=default table=teacher_schedule SELECT * FROM teacher_schedule WHERE teacher_id = ? AND ((start_time >= ? AND start_time < ?) OR (end_time > ? AND end_time <= ?) OR (start_time <= ? AND end_time > ?) OR (start_time <= ? AND end_time > ? )) AND deleted_flag = 'f' ORDER BY start_time ASC, id ASC 293363471 2025-03-10 12:00:00 +09:00 2025-03-10 20:00:00 +09:00 2025-03-10 12:00:00 +09:00 2025-03-10 20:00:00 +09:00 2025-03-10 12:00:00 +09:00 2025-03-10 20:00:00 +09:00 2025-03-10 12:00:00 +09:00 2025-03-10 20:00:00 +09:00
[DEBUG] 2025-03-15 13:30:56 +09:00 schema DB=default table=room_schedule SELECT * FROM room_schedule WHERE teacher_id = ? AND ((start_time >= ? AND start_time < ?) OR (end_time > ? AND end_time <= ?) OR (start_time <= ? AND end_time > ?) OR (start_time <= ? AND end_time > ? )) AND deleted_flag = 'f' ORDER BY start_time ASC, id ASC 293363471 2025-03-10 12:00:00 +09:00 2025-03-10 20:00:00 +09:00 2025-03-10 12:00:00 +09:00 2025-03-10 20:00:00 +09:00 2025-03-10 12:00:00 +09:00 2025-03-10 20:00:00 +09:00 2025-03-10 12:00:00 +09:00 2025-03-10 20:00:00 +09:00
[DEBUG] 2025-03-15 13:30:56 +09:00 schema DB=default table=company_contract_group_schedule SELECT * FROM company_contract_group_schedule WHERE teacher_ids && ARRAY[293363471] AND ((start_time >= ? AND start_time < ?) OR (end_time > ? AND end_time <= ?) OR (start_time <= ? AND end_time > ?) OR (start_time <= ? AND end_time > ? )) AND deleted_flag = 'f' ORDER BY start_time ASC, id ASC 2025-03-10 12:00:00 +09:00 2025-03-10 20:00:00 +09:00 2025-03-10 12:00:00 +09:00 2025-03-10 20:00:00 +09:00 2025-03-10 12:00:00 +09:00 2025-03-10 20:00:00 +09:00 2025-03-10 12:00:00 +09:00 2025-03-10 20:00:00 +09:00
[DEBUG] 2025-03-15 13:30:56 +09:00 schema DB=default table=lesson SELECT * FROM lesson WHERE teacher_id = ? AND ((start_time >= ? AND start_time < ?) OR (end_time > ? AND end_time <= ?) OR (start_time <= ? AND end_time > ?) OR (start_time <= ? AND ? < end_time)) AND canceled_flag = 'f' AND deleted_flag = 'f' ORDER BY start_time ASC, id ASC 293363471 2025-03-10 12:00:00 +09:00 2025-03-10 20:00:00 +09:00 2025-03-10 12:00:00 +09:00 2025-03-10 20:00:00 +09:00 2025-03-10 12:00:00 +09:00 2025-03-10 20:00:00 +09:00 2025-03-10 12:00:00 +09:00 2025-03-10 20:00:00 +09:00
[DEBUG] 2025-03-15 13:30:56 +09:00 schema DB=default table=student SELECT * FROM student WHERE id in (293002656,268458294,266827949,242074233) AND deleted_flag = 'f'
[DEBUG] 2025-03-15 13:30:56 +09:00 schema DB=default table=teacher_schedule SELECT * FROM teacher_schedule WHERE teacher_id = ? AND ((start_time >= ? AND start_time < ?) OR (end_time > ? AND end_time <= ?) OR (start_time <= ? AND end_time > ?) OR (start_time <= ? AND end_time > ? )) AND deleted_flag = 'f' ORDER BY start_time ASC, id ASC 293363471 2025-03-11 12:00:00 +09:00 2025-03-11 20:00:00 +09:00 2025-03-11 12:00:00 +09:00 2025-03-11 20:00:00 +09:00 2025-03-11 12:00:00 +09:00 2025-03-11 20:00:00 +09:00 2025-03-11 12:00:00 +09:00 2025-03-11 20:00:00 +09:00
[DEBUG] 2025-03-15 13:30:56 +09:00 schema DB=default table=room_schedule SELECT * FROM room_schedule WHERE teacher_id = ? AND ((start_time >= ? AND start_time < ?) OR (end_time > ? AND end_time <= ?) OR (start_time <= ? AND end_time > ?) OR (start_time <= ? AND end_time > ? )) AND deleted_flag = 'f' ORDER BY start_time ASC, id ASC 293363471 2025-03-11 12:00:00 +09:00 2025-03-11 20:00:00 +09:00 2025-03-11 12:00:00 +09:00 2025-03-11 20:00:00 +09:00 2025-03-11 12:00:00 +09:00 2025-03-11 20:00:00 +09:00 2025-03-11 12:00:00 +09:00 2025-03-11 20:00:00 +09:00
[DEBUG] 2025-03-15 13:30:56 +09:00 schema DB=default table=company_contract_group_schedule SELECT * FROM company_contract_group_schedule WHERE teacher_ids && ARRAY[293363471] AND ((start_time >= ? AND start_time < ?) OR (end_time > ? AND end_time <= ?) OR (start_time <= ? AND end_time > ?) OR (start_time <= ? AND end_time > ? )) AND deleted_flag = 'f' ORDER BY start_time ASC, id ASC 2025-03-11 12:00:00 +09:00 2025-03-11 20:00:00 +09:00 2025-03-11 12:00:00 +09:00 2025-03-11 20:00:00 +09:00 2025-03-11 12:00:00 +09:00 2025-03-11 20:00:00 +09:00 2025-03-11 12:00:00 +09:00 2025-03-11 20:00:00 +09:00
[DEBUG] 2025-03-15 13:30:56 +09:00 schema DB=default table=lesson SELECT * FROM lesson WHERE teacher_id = ? AND ((start_time >= ? AND start_time < ?) OR (end_time > ? AND end_time <= ?) OR (start_time <= ? AND end_time > ?) OR (start_time <= ? AND ? < end_time)) AND canceled_flag = 'f' AND deleted_flag = 'f' ORDER BY start_time ASC, id ASC 293363471 2025-03-11 12:00:00 +09:00 2025-03-11 20:00:00 +09:00 2025-03-11 12:00:00 +09:00 2025-03-11 20:00:00 +09:00 2025-03-11 12:00:00 +09:00 2025-03-11 20:00:00 +09:00 2025-03-11 12:00:00 +09:00 2025-03-11 20:00:00 +09:00
[DEBUG] 2025-03-15 13:30:56 +09:00 schema DB=default table=student SELECT * FROM student WHERE id in (903160601,243860864,282383557,279471017,282979623,157560325,274336883) AND deleted_flag = 'f'
[DEBUG] 2025-03-15 13:30:56 +09:00 schema DB=default table=teacher_schedule SELECT * FROM teacher_schedule WHERE teacher_id = ? AND ((start_time >= ? AND start_time < ?) OR (end_time > ? AND end_time <= ?) OR (start_time <= ? AND end_time > ?) OR (start_time <= ? AND end_time > ? )) AND deleted_flag = 'f' ORDER BY start_time ASC, id ASC 293363471 2025-03-12 12:00:00 +09:00 2025-03-12 20:00:00 +09:00 2025-03-12 12:00:00 +09:00 2025-03-12 20:00:00 +09:00 2025-03-12 12:00:00 +09:00 2025-03-12 20:00:00 +09:00 2025-03-12 12:00:00 +09:00 2025-03-12 20:00:00 +09:00
[DEBUG] 2025-03-15 13:30:56 +09:00 schema DB=default table=room_schedule SELECT * FROM room_schedule WHERE teacher_id = ? AND ((start_time >= ? AND start_time < ?) OR (end_time > ? AND end_time <= ?) OR (start_time <= ? AND end_time > ?) OR (start_time <= ? AND end_time > ? )) AND deleted_flag = 'f' ORDER BY start_time ASC, id ASC 293363471 2025-03-12 12:00:00 +09:00 2025-03-12 20:00:00 +09:00 2025-03-12 12:00:00 +09:00 2025-03-12 20:00:00 +09:00 2025-03-12 12:00:00 +09:00 2025-03-12 20:00:00 +09:00 2025-03-12 12:00:00 +09:00 2025-03-12 20:00:00 +09:00
[DEBUG] 2025-03-15 13:30:56 +09:00 schema DB=default table=company_contract_group_schedule SELECT * FROM company_contract_group_schedule WHERE teacher_ids && ARRAY[293363471] AND ((start_time >= ? AND start_time < ?) OR (end_time > ? AND end_time <= ?) OR (start_time <= ? AND end_time > ?) OR (start_time <= ? AND end_time > ? )) AND deleted_flag = 'f' ORDER BY start_time ASC, id ASC 2025-03-12 12:00:00 +09:00 2025-03-12 20:00:00 +09:00 2025-03-12 12:00:00 +09:00 2025-03-12 20:00:00 +09:00 2025-03-12 12:00:00 +09:00 2025-03-12 20:00:00 +09:00 2025-03-12 12:00:00 +09:00 2025-03-12 20:00:00 +09:00
[DEBUG] 2025-03-15 13:30:56 +09:00 schema DB=default table=lesson SELECT * FROM lesson WHERE teacher_id = ? AND ((start_time >= ? AND start_time < ?) OR (end_time > ? AND end_time <= ?) OR (start_time <= ? AND end_time > ?) OR (start_time <= ? AND ? < end_time)) AND canceled_flag = 'f' AND deleted_flag = 'f' ORDER BY start_time ASC, id ASC 293363471 2025-03-12 12:00:00 +09:00 2025-03-12 20:00:00 +09:00 2025-03-12 12:00:00 +09:00 2025-03-12 20:00:00 +09:00 2025-03-12 12:00:00 +09:00 2025-03-12 20:00:00 +09:00 2025-03-12 12:00:00 +09:00 2025-03-12 20:00:00 +09:00
[DEBUG] 2025-03-15 13:30:56 +09:00 schema DB=default table=student SELECT * FROM student WHERE id in (220383118,294974432,170131774,157560325,127271135) AND deleted_flag = 'f'
[DEBUG] 2025-03-15 13:30:56 +09:00 schema DB=default table=teacher_schedule SELECT * FROM teacher_schedule WHERE teacher_id = ? AND ((start_time >= ? AND start_time < ?) OR (end_time > ? AND end_time <= ?) OR (start_time <= ? AND end_time > ?) OR (start_time <= ? AND end_time > ? )) AND deleted_flag = 'f' ORDER BY start_time ASC, id ASC 293363471 2025-03-13 12:00:00 +09:00 2025-03-13 20:00:00 +09:00 2025-03-13 12:00:00 +09:00 2025-03-13 20:00:00 +09:00 2025-03-13 12:00:00 +09:00 2025-03-13 20:00:00 +09:00 2025-03-13 12:00:00 +09:00 2025-03-13 20:00:00 +09:00
[DEBUG] 2025-03-15 13:30:56 +09:00 schema DB=default table=room_schedule SELECT * FROM room_schedule WHERE teacher_id = ? AND ((start_time >= ? AND start_time < ?) OR (end_time > ? AND end_time <= ?) OR (start_time <= ? AND end_time > ?) OR (start_time <= ? AND end_time > ? )) AND deleted_flag = 'f' ORDER BY start_time ASC, id ASC 293363471 2025-03-13 12:00:00 +09:00 2025-03-13 20:00:00 +09:00 2025-03-13 12:00:00 +09:00 2025-03-13 20:00:00 +09:00 2025-03-13 12:00:00 +09:00 2025-03-13 20:00:00 +09:00 2025-03-13 12:00:00 +09:00 2025-03-13 20:00:00 +09:00
[DEBUG] 2025-03-15 13:30:56 +09:00 schema DB=default table=company_contract_group_schedule SELECT * FROM company_contract_group_schedule WHERE teacher_ids && ARRAY[293363471] AND ((start_time >= ? AND start_time < ?) OR (end_time > ? AND end_time <= ?) OR (start_time <= ? AND end_time > ?) OR (start_time <= ? AND end_time > ? )) AND deleted_flag = 'f' ORDER BY start_time ASC, id ASC 2025-03-13 12:00:00 +09:00 2025-03-13 20:00:00 +09:00 2025-03-13 12:00:00 +09:00 2025-03-13 20:00:00 +09:00 2025-03-13 12:00:00 +09:00 2025-03-13 20:00:00 +09:00 2025-03-13 12:00:00 +09:00 2025-03-13 20:00:00 +09:00
[DEBUG] 2025-03-15 13:30:56 +09:00 schema DB=default table=lesson SELECT * FROM lesson WHERE teacher_id = ? AND ((start_time >= ? AND start_time < ?) OR (end_time > ? AND end_time <= ?) OR (start_time <= ? AND end_time > ?) OR (start_time <= ? AND ? < end_time)) AND canceled_flag = 'f' AND deleted_flag = 'f' ORDER BY start_time ASC, id ASC 293363471 2025-03-13 12:00:00 +09:00 2025-03-13 20:00:00 +09:00 2025-03-13 12:00:00 +09:00 2025-03-13 20:00:00 +09:00 2025-03-13 12:00:00 +09:00 2025-03-13 20:00:00 +09:00 2025-03-13 12:00:00 +09:00 2025-03-13 20:00:00 +09:00
[DEBUG] 2025-03-15 13:30:56 +09:00 schema DB=default table=student SELECT * FROM student WHERE id in (297412710,135004305,224023267,238550220,290706478,93865623) AND deleted_flag = 'f'
[DEBUG] 2025-03-15 13:30:56 +09:00 schema DB=default table=teacher_schedule SELECT * FROM teacher_schedule WHERE teacher_id = ? AND ((start_time >= ? AND start_time < ?) OR (end_time > ? AND end_time <= ?) OR (start_time <= ? AND end_time > ?) OR (start_time <= ? AND end_time > ? )) AND deleted_flag = 'f' ORDER BY start_time ASC, id ASC 293363471 2025-03-14 12:00:00 +09:00 2025-03-14 20:00:00 +09:00 2025-03-14 12:00:00 +09:00 2025-03-14 20:00:00 +09:00 2025-03-14 12:00:00 +09:00 2025-03-14 20:00:00 +09:00 2025-03-14 12:00:00 +09:00 2025-03-14 20:00:00 +09:00
[DEBUG] 2025-03-15 13:30:56 +09:00 schema DB=default table=room_schedule SELECT * FROM room_schedule WHERE teacher_id = ? AND ((start_time >= ? AND start_time < ?) OR (end_time > ? AND end_time <= ?) OR (start_time <= ? AND end_time > ?) OR (start_time <= ? AND end_time > ? )) AND deleted_flag = 'f' ORDER BY start_time ASC, id ASC 293363471 2025-03-14 12:00:00 +09:00 2025-03-14 20:00:00 +09:00 2025-03-14 12:00:00 +09:00 2025-03-14 20:00:00 +09:00 2025-03-14 12:00:00 +09:00 2025-03-14 20:00:00 +09:00 2025-03-14 12:00:00 +09:00 2025-03-14 20:00:00 +09:00
[DEBUG] 2025-03-15 13:30:56 +09:00 schema DB=default table=company_contract_group_schedule SELECT * FROM company_contract_group_schedule WHERE teacher_ids && ARRAY[293363471] AND ((start_time >= ? AND start_time < ?) OR (end_time > ? AND end_time <= ?) OR (start_time <= ? AND end_time > ?) OR (start_time <= ? AND end_time > ? )) AND deleted_flag = 'f' ORDER BY start_time ASC, id ASC 2025-03-14 12:00:00 +09:00 2025-03-14 20:00:00 +09:00 2025-03-14 12:00:00 +09:00 2025-03-14 20:00:00 +09:00 2025-03-14 12:00:00 +09:00 2025-03-14 20:00:00 +09:00 2025-03-14 12:00:00 +09:00 2025-03-14 20:00:00 +09:00
[DEBUG] 2025-03-15 13:30:56 +09:00 schema DB=default table=lesson SELECT * FROM lesson WHERE teacher_id = ? AND ((start_time >= ? AND start_time < ?) OR (end_time > ? AND end_time <= ?) OR (start_time <= ? AND end_time > ?) OR (start_time <= ? AND ? < end_time)) AND canceled_flag = 'f' AND deleted_flag = 'f' ORDER BY start_time ASC, id ASC 293363471 2025-03-14 12:00:00 +09:00 2025-03-14 20:00:00 +09:00 2025-03-14 12:00:00 +09:00 2025-03-14 20:00:00 +09:00 2025-03-14 12:00:00 +09:00 2025-03-14 20:00:00 +09:00 2025-03-14 12:00:00 +09:00 2025-03-14 20:00:00 +09:00
[DEBUG] 2025-03-15 13:30:56 +09:00 schema DB=default table=student SELECT * FROM student WHERE id in (233348396,135822769) AND deleted_flag = 'f'
[DEBUG] 2025-03-15 13:30:56 +09:00 schema DB=default table=teacher_schedule SELECT * FROM teacher_schedule WHERE teacher_id = ? AND ((start_time >= ? AND start_time < ?) OR (end_time > ? AND end_time <= ?) OR (start_time <= ? AND end_time > ?) OR (start_time <= ? AND end_time > ? )) AND deleted_flag = 'f' ORDER BY start_time ASC, id ASC 293363471 2025-03-15 12:00:00 +09:00 2025-03-15 20:00:00 +09:00 2025-03-15 12:00:00 +09:00 2025-03-15 20:00:00 +09:00 2025-03-15 12:00:00 +09:00 2025-03-15 20:00:00 +09:00 2025-03-15 12:00:00 +09:00 2025-03-15 20:00:00 +09:00
[DEBUG] 2025-03-15 13:30:56 +09:00 schema DB=default table=room_schedule SELECT * FROM room_schedule WHERE teacher_id = ? AND ((start_time >= ? AND start_time < ?) OR (end_time > ? AND end_time <= ?) OR (start_time <= ? AND end_time > ?) OR (start_time <= ? AND end_time > ? )) AND deleted_flag = 'f' ORDER BY start_time ASC, id ASC 293363471 2025-03-15 12:00:00 +09:00 2025-03-15 20:00:00 +09:00 2025-03-15 12:00:00 +09:00 2025-03-15 20:00:00 +09:00 2025-03-15 12:00:00 +09:00 2025-03-15 20:00:00 +09:00 2025-03-15 12:00:00 +09:00 2025-03-15 20:00:00 +09:00
[DEBUG] 2025-03-15 13:30:56 +09:00 schema DB=default table=company_contract_group_schedule SELECT * FROM company_contract_group_schedule WHERE teacher_ids && ARRAY[293363471] AND ((start_time >= ? AND start_time < ?) OR (end_time > ? AND end_time <= ?) OR (start_time <= ? AND end_time > ?) OR (start_time <= ? AND end_time > ? )) AND deleted_flag = 'f' ORDER BY start_time ASC, id ASC 2025-03-15 12:00:00 +09:00 2025-03-15 20:00:00 +09:00 2025-03-15 12:00:00 +09:00 2025-03-15 20:00:00 +09:00 2025-03-15 12:00:00 +09:00 2025-03-15 20:00:00 +09:00 2025-03-15 12:00:00 +09:00 2025-03-15 20:00:00 +09:00
[DEBUG] 2025-03-15 13:30:56 +09:00 schema DB=default table=lesson SELECT * FROM lesson WHERE teacher_id = ? AND ((start_time >= ? AND start_time < ?) OR (end_time > ? AND end_time <= ?) OR (start_time <= ? AND end_time > ?) OR (start_time <= ? AND ? < end_time)) AND canceled_flag = 'f' AND deleted_flag = 'f' ORDER BY start_time ASC, id ASC 293363471 2025-03-15 12:00:00 +09:00 2025-03-15 20:00:00 +09:00 2025-03-15 12:00:00 +09:00 2025-03-15 20:00:00 +09:00 2025-03-15 12:00:00 +09:00 2025-03-15 20:00:00 +09:00 2025-03-15 12:00:00 +09:00 2025-03-15 20:00:00 +09:00
[DEBUG] 2025-03-15 13:30:56 +09:00 schema DB=default table=teacher SELECT * FROM teacher WHERE deleted_flag = 'f' AND id = '293363471' LIMIT 1 OFFSET 0
[DEBUG] 2025-03-15 13:30:56 +09:00 service QQE::Service::Site::Basic::Schedule::Teacher->get_collection_of_week success
[DEBUG] 2025-03-15 13:30:56 +09:00 service QQE::Service::Site->execute success
[DEBUG] 2025-03-15 13:30:56 +09:00 service QQE::Service::Site->execute execute
[DEBUG] 2025-03-15 13:30:56 +09:00 service QQE::Service::Site::Basic::Curriculum->search execute
[DEBUG] 2025-03-15 13:30:56 +09:00 service QQE::Service::Auth::Student->check_token execute
[DEBUG] 2025-03-15 13:30:56 +09:00 service QQE::Service::Auth->check_token execute
[DEBUG] 2025-03-15 13:30:56 +09:00 service QQE::Service::Auth->check_token failed 301 token が指定されていません
[DEBUG] 2025-03-15 13:30:56 +09:00 service QQE::Service::Auth::Student->check_token failed 301 token が指定されていません
[DEBUG] 2025-03-15 13:30:56 +09:00 schema DB=default table=curriculum SELECT count(*) FROM curriculum WHERE site_id = 105 AND online_flag = 't' AND ftl_flag = 'f' AND allow_search_flag = 't' AND allow_show_flag = 't' AND deleted_flag = 'f';
[DEBUG] 2025-03-15 13:30:56 +09:00 schema DB=default table=curriculum SELECT * FROM curriculum WHERE site_id = 105 AND online_flag = 't' AND ftl_flag = 'f' AND allow_search_flag = 't' AND allow_show_flag = 't' AND deleted_flag = 'f' ORDER BY rating_id DESC, sort_order_for_site DESC, code ASC, id ASC LIMIT 100 OFFSET 0
[DEBUG] 2025-03-15 13:30:56 +09:00 service QQE::Service::Site::Basic::Curriculum->search success
[DEBUG] 2025-03-15 13:30:56 +09:00 service QQE::Service::Site->execute success
[DEBUG] 2025-03-15 13:30:56 +09:00 schema DB=default table=points_plan SELECT * FROM points_plan WHERE site_id = ? AND invalid_flag = 'f' AND deleted_flag = 'f' ORDER BY sort_order DESC, id ASC 105
[DEBUG] 2025-03-15 13:30:56 +09:00 schema DB=default table=subscription SELECT * FROM subscription WHERE site_id = ? AND invalid_flag = 'f' AND deleted_flag = 'f' ORDER BY sort_order DESC, id ASC 105