[DEBUG] 2025-01-25 04:11:59 +09:00 service QQE::Service::Site->execute execute
[DEBUG] 2025-01-25 04:11:59 +09:00 service QQE::Service::Site::Basic::Teacher->view execute
[DEBUG] 2025-01-25 04:11:59 +09:00 service QQE::Service::Auth::Student->check_token execute
[DEBUG] 2025-01-25 04:11:59 +09:00 service QQE::Service::Auth->check_token execute
[DEBUG] 2025-01-25 04:11:59 +09:00 service QQE::Service::Auth->check_token failed 301 token が指定されていません
[DEBUG] 2025-01-25 04:11:59 +09:00 service QQE::Service::Auth::Student->check_token failed 301 token が指定されていません
[DEBUG] 2025-01-25 04:11:59 +09:00 service QQE::Service::SNS::Teacher->view execute
[DEBUG] 2025-01-25 04:11:59 +09:00 schema DB=default table=teacher SELECT * FROM teacher WHERE deleted_flag = 'f' AND id = '240282419' LIMIT 1 OFFSET 0
[DEBUG] 2025-01-25 04:11:59 +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:240282419
[DEBUG] 2025-01-25 04:11:59 +09:00 service QQE::Service::SNS::Teacher->view success
[DEBUG] 2025-01-25 04:11:59 +09:00 service QQE::Service::Site::Basic::Teacher->view success
[DEBUG] 2025-01-25 04:11:59 +09:00 service QQE::Service::Site->execute success
[DEBUG] 2025-01-25 04:11:59 +09:00 service QQE::Service::Site->execute execute
[DEBUG] 2025-01-25 04:11:59 +09:00 service QQE::Service::Site::Basic::Curriculum->search execute
[DEBUG] 2025-01-25 04:11:59 +09:00 service QQE::Service::Auth::Student->check_token execute
[DEBUG] 2025-01-25 04:11:59 +09:00 service QQE::Service::Auth->check_token execute
[DEBUG] 2025-01-25 04:11:59 +09:00 service QQE::Service::Auth->check_token failed 301 token が指定されていません
[DEBUG] 2025-01-25 04:11:59 +09:00 service QQE::Service::Auth::Student->check_token failed 301 token が指定されていません
[DEBUG] 2025-01-25 04:11:59 +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-01-25 04:11:59 +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-01-25 04:11:59 +09:00 service QQE::Service::Site::Basic::Curriculum->search success
[DEBUG] 2025-01-25 04:11:59 +09:00 service QQE::Service::Site->execute success
[DEBUG] 2025-01-25 04:11:59 +09:00 schema DB=default table=curriculum_original SELECT * FROM curriculum_original WHERE code = 'C0512' AND deleted_flag = 'f' LIMIT 1 OFFSET 0
[DEBUG] 2025-01-25 04:11:59 +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-01-25 04:11:59 +09:00 schema DB=default table=curriculum_original SELECT * FROM curriculum_original WHERE code = 'C0398' AND deleted_flag = 'f' LIMIT 1 OFFSET 0
[DEBUG] 2025-01-25 04:11:59 +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-01-25 04:11:59 +09:00 schema DB=default table=curriculum_original SELECT * FROM curriculum_original WHERE code = 'C0009' AND deleted_flag = 'f' LIMIT 1 OFFSET 0
[DEBUG] 2025-01-25 04:11:59 +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-01-25 04:11:59 +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-01-25 04:11:59 +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-01-25 04:11:59 +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-01-25 04:11:59 +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-01-25 04:11:59 +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-01-25 04:11:59 +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-01-25 04:11:59 +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-01-25 04:11:59 +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-01-25 04:11:59 +09:00 schema DB=default table=curriculum_original SELECT * FROM curriculum_original WHERE code = 'C0184' AND deleted_flag = 'f' LIMIT 1 OFFSET 0
[DEBUG] 2025-01-25 04:11:59 +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-01-25 04:11:59 +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-01-25 04:11:59 +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-01-25 04:11:59 +09:00 schema DB=default table=curriculum_original SELECT * FROM curriculum_original WHERE code = 'C0304' AND deleted_flag = 'f' LIMIT 1 OFFSET 0
[DEBUG] 2025-01-25 04:11:59 +09:00 schema DB=default table=curriculum_original SELECT * FROM curriculum_original WHERE code = 'C0339' AND deleted_flag = 'f' LIMIT 1 OFFSET 0
[DEBUG] 2025-01-25 04:11:59 +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-01-25 04:11:59 +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-01-25 04:11:59 +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-01-25 04:11:59 +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-01-25 04:11:59 +09:00 schema DB=default table=curriculum_original SELECT * FROM curriculum_original WHERE code = 'C0385' AND deleted_flag = 'f' LIMIT 1 OFFSET 0
[DEBUG] 2025-01-25 04:11:59 +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-01-25 04:11:59 +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-01-25 04:11:59 +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-01-25 04:11:59 +09:00 schema DB=default table=curriculum_original SELECT * FROM curriculum_original WHERE code = 'C0407' AND deleted_flag = 'f' LIMIT 1 OFFSET 0
[DEBUG] 2025-01-25 04:11:59 +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-01-25 04:11:59 +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-01-25 04:11:59 +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-01-25 04:11:59 +09:00 schema DB=default table=curriculum_original SELECT * FROM curriculum_original WHERE code = 'C0434' AND deleted_flag = 'f' LIMIT 1 OFFSET 0
[DEBUG] 2025-01-25 04:11:59 +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-01-25 04:11:59 +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-01-25 04:11:59 +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-01-25 04:11:59 +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-01-25 04:11:59 +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-01-25 04:11:59 +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-01-25 04:11:59 +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-01-25 04:11:59 +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-01-25 04:11:59 +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-01-25 04:11:59 +09:00 schema DB=default table=curriculum_original SELECT * FROM curriculum_original WHERE code = 'C0485' AND deleted_flag = 'f' LIMIT 1 OFFSET 0
[DEBUG] 2025-01-25 04:11:59 +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-01-25 04:11:59 +09:00 schema DB=default table=curriculum_original SELECT * FROM curriculum_original WHERE code = 'C0492' AND deleted_flag = 'f' LIMIT 1 OFFSET 0
[DEBUG] 2025-01-25 04:11:59 +09:00 schema DB=default table=curriculum_original SELECT * FROM curriculum_original WHERE code = 'C0499' AND deleted_flag = 'f' LIMIT 1 OFFSET 0
[DEBUG] 2025-01-25 04:11:59 +09:00 schema DB=default table=curriculum_original SELECT * FROM curriculum_original WHERE code = 'C0500' AND deleted_flag = 'f' LIMIT 1 OFFSET 0
[DEBUG] 2025-01-25 04:11:59 +09:00 schema DB=default table=curriculum_original SELECT * FROM curriculum_original WHERE code = 'C0563' AND deleted_flag = 'f' LIMIT 1 OFFSET 0
[DEBUG] 2025-01-25 04:11:59 +09:00 schema DB=default table=curriculum_original SELECT * FROM curriculum_original WHERE code = 'C0564' AND deleted_flag = 'f' LIMIT 1 OFFSET 0
[DEBUG] 2025-01-25 04:11:59 +09:00 schema DB=default table=curriculum_original SELECT * FROM curriculum_original WHERE code = 'C0565' AND deleted_flag = 'f' LIMIT 1 OFFSET 0
[DEBUG] 2025-01-25 04:11:59 +09:00 schema DB=default table=curriculum_original SELECT * FROM curriculum_original WHERE code = 'C0566' AND deleted_flag = 'f' LIMIT 1 OFFSET 0
[DEBUG] 2025-01-25 04:11:59 +09:00 service QQE::Service::Site->execute execute
[DEBUG] 2025-01-25 04:11:59 +09:00 service QQE::Service::Site::Basic::Schedule::Fixed->get_schedules_of_week execute
[DEBUG] 2025-01-25 04:11:59 +09:00 service QQE::Service::Auth::Student->check_token execute
[DEBUG] 2025-01-25 04:11:59 +09:00 service QQE::Service::Auth->check_token execute
[DEBUG] 2025-01-25 04:11:59 +09:00 service QQE::Service::Auth->check_token failed 301 token が指定されていません
[DEBUG] 2025-01-25 04:11:59 +09:00 service QQE::Service::Auth::Student->check_token failed 301 token が指定されていません
[DEBUG] 2025-01-25 04:11:59 +09:00 schema DB=default table=teacher_fixed_schedule SELECT * FROM teacher_fixed_schedule WHERE teacher_id = ? AND start_min >= ? AND end_min <= ? AND deleted_flag = 'f' ORDER BY start_min ASC 240282419 0 1560
[DEBUG] 2025-01-25 04:11:59 +09:00 schema DB=default table=teacher_fixed_schedule SELECT * FROM teacher_fixed_schedule WHERE teacher_id = ? AND start_min >= ? AND end_min <= ? AND deleted_flag = 'f' ORDER BY start_min ASC 240282419 0 -8520
[DEBUG] 2025-01-25 04:11:59 +09:00 schema DB=default table=student_lesson_order SELECT * FROM student_lesson_order WHERE teacher_id = ? AND ((start_min >= '0' AND start_min < '1560') OR (end_min > '0' AND end_min <= '1560') OR (start_min <= '0' AND end_min > '1560') OR (start_min <= '0' AND end_min > '1560')) AND (stopped_flag = 'f' OR (stopped_flag = 't' AND reservation_stop_time >= '2025-01-26 00:00:00 +09:00')) AND deleted_flag = 'f' ORDER BY start_min ASC, ordered_time ASC, id ASC 240282419
[DEBUG] 2025-01-25 04:11:59 +09:00 schema DB=default table=student_lesson_order SELECT * FROM student_lesson_order WHERE teacher_id = ? AND ((start_min >= '0' AND start_min < '-8520') OR (end_min > '0' AND end_min <= '-8520') OR (start_min <= '0' AND end_min > '-8520') OR (start_min <= '0' AND end_min > '-8520')) AND (stopped_flag = 'f' OR (stopped_flag = 't' AND reservation_stop_time >= '2025-01-26 00:00:00 +09:00')) AND deleted_flag = 'f' ORDER BY start_min ASC, ordered_time ASC 240282419
[DEBUG] 2025-01-25 04:11:59 +09:00 schema DB=default table=teacher_schedule SELECT start_time, end_time, available_site_ids FROM teacher_schedule WHERE teacher_id = ? AND ((start_time >= '2025-01-26 00:00:00 +09:00' AND start_time < '2025-01-27 02:00:00 +09:00') OR (end_time > '2025-01-26 00:00:00 +09:00' AND end_time <= '2025-01-27 02:00:00 +09:00') OR (start_time <= '2025-01-26 00:00:00 +09:00' AND end_time > '2025-01-27 02:00:00 +09:00')) AND status_id = 202 AND locked_flag = 'f' AND deleted_flag = 'f' ORDER BY start_time ASC 240282419
[DEBUG] 2025-01-25 04:11:59 +09:00 schema DB=default table=teacher_schedule SELECT start_time, end_time, available_site_ids FROM teacher_schedule WHERE teacher_id = ? AND ((start_time >= '2025-02-02 00:00:00 +09:00' AND start_time < '2025-02-03 02:00:00 +09:00') OR (end_time > '2025-02-02 00:00:00 +09:00' AND end_time <= '2025-02-03 02:00:00 +09:00') OR (start_time <= '2025-02-02 00:00:00 +09:00' AND end_time > '2025-02-03 02:00:00 +09:00')) AND status_id = 202 AND locked_flag = 'f' AND deleted_flag = 'f' ORDER BY start_time ASC 240282419
[DEBUG] 2025-01-25 04:11:59 +09:00 schema DB=default table=teacher_schedule SELECT start_time, end_time, available_site_ids FROM teacher_schedule WHERE teacher_id = ? AND ((start_time >= '2025-02-09 00:00:00 +09:00' AND start_time < '2025-02-10 02:00:00 +09:00') OR (end_time > '2025-02-09 00:00:00 +09:00' AND end_time <= '2025-02-10 02:00:00 +09:00') OR (start_time <= '2025-02-09 00:00:00 +09:00' AND end_time > '2025-02-10 02:00:00 +09:00')) AND status_id = 202 AND locked_flag = 'f' AND deleted_flag = 'f' ORDER BY start_time ASC 240282419
[DEBUG] 2025-01-25 04:11:59 +09:00 schema DB=default table=lesson SELECT start_time, end_time, student_id, id FROM lesson WHERE teacher_id = ? AND ((start_time >= '2025-01-26 00:00:00 +09:00' AND start_time < '2025-01-27 02:00:00 +09:00') OR (end_time > '2025-01-26 00:00:00 +09:00' AND end_time <= '2025-01-27 02:00:00 +09:00') OR (start_time <= '2025-01-26 00:00:00 +09:00' AND end_time > '2025-01-27 02:00:00 +09:00')) AND canceled_flag = 'f' AND deleted_flag = 'f' ORDER BY start_time ASC 240282419
[DEBUG] 2025-01-25 04:11:59 +09:00 schema DB=default table=lesson SELECT start_time, end_time, student_id, id FROM lesson WHERE teacher_id = ? AND ((start_time >= '2025-02-02 00:00:00 +09:00' AND start_time < '2025-02-03 02:00:00 +09:00') OR (end_time > '2025-02-02 00:00:00 +09:00' AND end_time <= '2025-02-03 02:00:00 +09:00') OR (start_time <= '2025-02-02 00:00:00 +09:00' AND end_time > '2025-02-03 02:00:00 +09:00')) AND canceled_flag = 'f' AND deleted_flag = 'f' ORDER BY start_time ASC 240282419
[DEBUG] 2025-01-25 04:11:59 +09:00 schema DB=default table=lesson SELECT start_time, end_time, student_id, id FROM lesson WHERE teacher_id = ? AND ((start_time >= '2025-02-09 00:00:00 +09:00' AND start_time < '2025-02-10 02:00:00 +09:00') OR (end_time > '2025-02-09 00:00:00 +09:00' AND end_time <= '2025-02-10 02:00:00 +09:00') OR (start_time <= '2025-02-09 00:00:00 +09:00' AND end_time > '2025-02-10 02:00:00 +09:00')) AND canceled_flag = 'f' AND deleted_flag = 'f' ORDER BY start_time ASC 240282419
[DEBUG] 2025-01-25 04:11:59 +09:00 schema DB=default table=teacher_fixed_schedule SELECT * FROM teacher_fixed_schedule WHERE teacher_id = ? AND start_min >= ? AND end_min <= ? AND deleted_flag = 'f' ORDER BY start_min ASC 240282419 1440 3000
[DEBUG] 2025-01-25 04:11:59 +09:00 schema DB=default table=teacher_fixed_schedule SELECT * FROM teacher_fixed_schedule WHERE teacher_id = ? AND start_min >= ? AND end_min <= ? AND deleted_flag = 'f' ORDER BY start_min ASC 240282419 0 -7080
[DEBUG] 2025-01-25 04:11:59 +09:00 schema DB=default table=student_lesson_order SELECT * FROM student_lesson_order WHERE teacher_id = ? AND ((start_min >= '1440' AND start_min < '3000') OR (end_min > '1440' AND end_min <= '3000') OR (start_min <= '1440' AND end_min > '3000') OR (start_min <= '1440' AND end_min > '3000')) AND (stopped_flag = 'f' OR (stopped_flag = 't' AND reservation_stop_time >= '2025-01-27 00:00:00 +09:00')) AND deleted_flag = 'f' ORDER BY start_min ASC, ordered_time ASC, id ASC 240282419
[DEBUG] 2025-01-25 04:11:59 +09:00 schema DB=default table=student_lesson_order SELECT * FROM student_lesson_order WHERE teacher_id = ? AND ((start_min >= '0' AND start_min < '-7080') OR (end_min > '0' AND end_min <= '-7080') OR (start_min <= '0' AND end_min > '-7080') OR (start_min <= '0' AND end_min > '-7080')) AND (stopped_flag = 'f' OR (stopped_flag = 't' AND reservation_stop_time >= '2025-01-27 00:00:00 +09:00')) AND deleted_flag = 'f' ORDER BY start_min ASC, ordered_time ASC 240282419
[DEBUG] 2025-01-25 04:11:59 +09:00 schema DB=default table=teacher_schedule SELECT start_time, end_time, available_site_ids FROM teacher_schedule WHERE teacher_id = ? AND ((start_time >= '2025-01-27 00:00:00 +09:00' AND start_time < '2025-01-28 02:00:00 +09:00') OR (end_time > '2025-01-27 00:00:00 +09:00' AND end_time <= '2025-01-28 02:00:00 +09:00') OR (start_time <= '2025-01-27 00:00:00 +09:00' AND end_time > '2025-01-28 02:00:00 +09:00')) AND status_id = 202 AND locked_flag = 'f' AND deleted_flag = 'f' ORDER BY start_time ASC 240282419
[DEBUG] 2025-01-25 04:12:00 +09:00 schema DB=default table=teacher_schedule SELECT start_time, end_time, available_site_ids FROM teacher_schedule WHERE teacher_id = ? AND ((start_time >= '2025-02-03 00:00:00 +09:00' AND start_time < '2025-02-04 02:00:00 +09:00') OR (end_time > '2025-02-03 00:00:00 +09:00' AND end_time <= '2025-02-04 02:00:00 +09:00') OR (start_time <= '2025-02-03 00:00:00 +09:00' AND end_time > '2025-02-04 02:00:00 +09:00')) AND status_id = 202 AND locked_flag = 'f' AND deleted_flag = 'f' ORDER BY start_time ASC 240282419
[DEBUG] 2025-01-25 04:12:00 +09:00 schema DB=default table=teacher_schedule SELECT start_time, end_time, available_site_ids FROM teacher_schedule WHERE teacher_id = ? AND ((start_time >= '2025-02-10 00:00:00 +09:00' AND start_time < '2025-02-11 02:00:00 +09:00') OR (end_time > '2025-02-10 00:00:00 +09:00' AND end_time <= '2025-02-11 02:00:00 +09:00') OR (start_time <= '2025-02-10 00:00:00 +09:00' AND end_time > '2025-02-11 02:00:00 +09:00')) AND status_id = 202 AND locked_flag = 'f' AND deleted_flag = 'f' ORDER BY start_time ASC 240282419
[DEBUG] 2025-01-25 04:12:00 +09:00 schema DB=default table=lesson SELECT start_time, end_time, student_id, id FROM lesson WHERE teacher_id = ? AND ((start_time >= '2025-01-27 00:00:00 +09:00' AND start_time < '2025-01-28 02:00:00 +09:00') OR (end_time > '2025-01-27 00:00:00 +09:00' AND end_time <= '2025-01-28 02:00:00 +09:00') OR (start_time <= '2025-01-27 00:00:00 +09:00' AND end_time > '2025-01-28 02:00:00 +09:00')) AND canceled_flag = 'f' AND deleted_flag = 'f' ORDER BY start_time ASC 240282419
[DEBUG] 2025-01-25 04:12:00 +09:00 schema DB=default table=lesson SELECT start_time, end_time, student_id, id FROM lesson WHERE teacher_id = ? AND ((start_time >= '2025-02-03 00:00:00 +09:00' AND start_time < '2025-02-04 02:00:00 +09:00') OR (end_time > '2025-02-03 00:00:00 +09:00' AND end_time <= '2025-02-04 02:00:00 +09:00') OR (start_time <= '2025-02-03 00:00:00 +09:00' AND end_time > '2025-02-04 02:00:00 +09:00')) AND canceled_flag = 'f' AND deleted_flag = 'f' ORDER BY start_time ASC 240282419
[DEBUG] 2025-01-25 04:12:00 +09:00 schema DB=default table=lesson SELECT start_time, end_time, student_id, id FROM lesson WHERE teacher_id = ? AND ((start_time >= '2025-02-10 00:00:00 +09:00' AND start_time < '2025-02-11 02:00:00 +09:00') OR (end_time > '2025-02-10 00:00:00 +09:00' AND end_time <= '2025-02-11 02:00:00 +09:00') OR (start_time <= '2025-02-10 00:00:00 +09:00' AND end_time > '2025-02-11 02:00:00 +09:00')) AND canceled_flag = 'f' AND deleted_flag = 'f' ORDER BY start_time ASC 240282419
[DEBUG] 2025-01-25 04:12:00 +09:00 schema DB=default table=teacher_fixed_schedule SELECT * FROM teacher_fixed_schedule WHERE teacher_id = ? AND start_min >= ? AND end_min <= ? AND deleted_flag = 'f' ORDER BY start_min ASC 240282419 2880 4440
[DEBUG] 2025-01-25 04:12:00 +09:00 schema DB=default table=teacher_fixed_schedule SELECT * FROM teacher_fixed_schedule WHERE teacher_id = ? AND start_min >= ? AND end_min <= ? AND deleted_flag = 'f' ORDER BY start_min ASC 240282419 0 -5640
[DEBUG] 2025-01-25 04:12:00 +09:00 schema DB=default table=student_lesson_order SELECT * FROM student_lesson_order WHERE teacher_id = ? AND ((start_min >= '2880' AND start_min < '4440') OR (end_min > '2880' AND end_min <= '4440') OR (start_min <= '2880' AND end_min > '4440') OR (start_min <= '2880' AND end_min > '4440')) AND (stopped_flag = 'f' OR (stopped_flag = 't' AND reservation_stop_time >= '2025-01-28 00:00:00 +09:00')) AND deleted_flag = 'f' ORDER BY start_min ASC, ordered_time ASC, id ASC 240282419
[DEBUG] 2025-01-25 04:12:00 +09:00 schema DB=default table=student_lesson_order SELECT * FROM student_lesson_order WHERE teacher_id = ? AND ((start_min >= '0' AND start_min < '-5640') OR (end_min > '0' AND end_min <= '-5640') OR (start_min <= '0' AND end_min > '-5640') OR (start_min <= '0' AND end_min > '-5640')) AND (stopped_flag = 'f' OR (stopped_flag = 't' AND reservation_stop_time >= '2025-01-28 00:00:00 +09:00')) AND deleted_flag = 'f' ORDER BY start_min ASC, ordered_time ASC 240282419
[DEBUG] 2025-01-25 04:12:00 +09:00 schema DB=default table=teacher_schedule SELECT start_time, end_time, available_site_ids FROM teacher_schedule WHERE teacher_id = ? AND ((start_time >= '2025-01-28 00:00:00 +09:00' AND start_time < '2025-01-29 02:00:00 +09:00') OR (end_time > '2025-01-28 00:00:00 +09:00' AND end_time <= '2025-01-29 02:00:00 +09:00') OR (start_time <= '2025-01-28 00:00:00 +09:00' AND end_time > '2025-01-29 02:00:00 +09:00')) AND status_id = 202 AND locked_flag = 'f' AND deleted_flag = 'f' ORDER BY start_time ASC 240282419
[DEBUG] 2025-01-25 04:12:00 +09:00 schema DB=default table=teacher_schedule SELECT start_time, end_time, available_site_ids FROM teacher_schedule WHERE teacher_id = ? AND ((start_time >= '2025-02-04 00:00:00 +09:00' AND start_time < '2025-02-05 02:00:00 +09:00') OR (end_time > '2025-02-04 00:00:00 +09:00' AND end_time <= '2025-02-05 02:00:00 +09:00') OR (start_time <= '2025-02-04 00:00:00 +09:00' AND end_time > '2025-02-05 02:00:00 +09:00')) AND status_id = 202 AND locked_flag = 'f' AND deleted_flag = 'f' ORDER BY start_time ASC 240282419
[DEBUG] 2025-01-25 04:12:00 +09:00 schema DB=default table=teacher_schedule SELECT start_time, end_time, available_site_ids FROM teacher_schedule WHERE teacher_id = ? AND ((start_time >= '2025-02-11 00:00:00 +09:00' AND start_time < '2025-02-12 02:00:00 +09:00') OR (end_time > '2025-02-11 00:00:00 +09:00' AND end_time <= '2025-02-12 02:00:00 +09:00') OR (start_time <= '2025-02-11 00:00:00 +09:00' AND end_time > '2025-02-12 02:00:00 +09:00')) AND status_id = 202 AND locked_flag = 'f' AND deleted_flag = 'f' ORDER BY start_time ASC 240282419
[DEBUG] 2025-01-25 04:12:00 +09:00 schema DB=default table=lesson SELECT start_time, end_time, student_id, id FROM lesson WHERE teacher_id = ? AND ((start_time >= '2025-01-28 00:00:00 +09:00' AND start_time < '2025-01-29 02:00:00 +09:00') OR (end_time > '2025-01-28 00:00:00 +09:00' AND end_time <= '2025-01-29 02:00:00 +09:00') OR (start_time <= '2025-01-28 00:00:00 +09:00' AND end_time > '2025-01-29 02:00:00 +09:00')) AND canceled_flag = 'f' AND deleted_flag = 'f' ORDER BY start_time ASC 240282419
[DEBUG] 2025-01-25 04:12:00 +09:00 schema DB=default table=lesson SELECT start_time, end_time, student_id, id FROM lesson WHERE teacher_id = ? AND ((start_time >= '2025-02-04 00:00:00 +09:00' AND start_time < '2025-02-05 02:00:00 +09:00') OR (end_time > '2025-02-04 00:00:00 +09:00' AND end_time <= '2025-02-05 02:00:00 +09:00') OR (start_time <= '2025-02-04 00:00:00 +09:00' AND end_time > '2025-02-05 02:00:00 +09:00')) AND canceled_flag = 'f' AND deleted_flag = 'f' ORDER BY start_time ASC 240282419
[DEBUG] 2025-01-25 04:12:00 +09:00 schema DB=default table=lesson SELECT start_time, end_time, student_id, id FROM lesson WHERE teacher_id = ? AND ((start_time >= '2025-02-11 00:00:00 +09:00' AND start_time < '2025-02-12 02:00:00 +09:00') OR (end_time > '2025-02-11 00:00:00 +09:00' AND end_time <= '2025-02-12 02:00:00 +09:00') OR (start_time <= '2025-02-11 00:00:00 +09:00' AND end_time > '2025-02-12 02:00:00 +09:00')) AND canceled_flag = 'f' AND deleted_flag = 'f' ORDER BY start_time ASC 240282419
[DEBUG] 2025-01-25 04:12:00 +09:00 schema DB=default table=teacher_fixed_schedule SELECT * FROM teacher_fixed_schedule WHERE teacher_id = ? AND start_min >= ? AND end_min <= ? AND deleted_flag = 'f' ORDER BY start_min ASC 240282419 4320 5880
[DEBUG] 2025-01-25 04:12:00 +09:00 schema DB=default table=teacher_fixed_schedule SELECT * FROM teacher_fixed_schedule WHERE teacher_id = ? AND start_min >= ? AND end_min <= ? AND deleted_flag = 'f' ORDER BY start_min ASC 240282419 0 -4200
[DEBUG] 2025-01-25 04:12:00 +09:00 schema DB=default table=student_lesson_order SELECT * FROM student_lesson_order WHERE teacher_id = ? AND ((start_min >= '4320' AND start_min < '5880') OR (end_min > '4320' AND end_min <= '5880') OR (start_min <= '4320' AND end_min > '5880') OR (start_min <= '4320' AND end_min > '5880')) AND (stopped_flag = 'f' OR (stopped_flag = 't' AND reservation_stop_time >= '2025-01-29 00:00:00 +09:00')) AND deleted_flag = 'f' ORDER BY start_min ASC, ordered_time ASC, id ASC 240282419
[DEBUG] 2025-01-25 04:12:00 +09:00 schema DB=default table=student_lesson_order SELECT * FROM student_lesson_order WHERE teacher_id = ? AND ((start_min >= '0' AND start_min < '-4200') OR (end_min > '0' AND end_min <= '-4200') OR (start_min <= '0' AND end_min > '-4200') OR (start_min <= '0' AND end_min > '-4200')) AND (stopped_flag = 'f' OR (stopped_flag = 't' AND reservation_stop_time >= '2025-01-29 00:00:00 +09:00')) AND deleted_flag = 'f' ORDER BY start_min ASC, ordered_time ASC 240282419
[DEBUG] 2025-01-25 04:12:00 +09:00 schema DB=default table=teacher_schedule SELECT start_time, end_time, available_site_ids FROM teacher_schedule WHERE teacher_id = ? AND ((start_time >= '2025-01-29 00:00:00 +09:00' AND start_time < '2025-01-30 02:00:00 +09:00') OR (end_time > '2025-01-29 00:00:00 +09:00' AND end_time <= '2025-01-30 02:00:00 +09:00') OR (start_time <= '2025-01-29 00:00:00 +09:00' AND end_time > '2025-01-30 02:00:00 +09:00')) AND status_id = 202 AND locked_flag = 'f' AND deleted_flag = 'f' ORDER BY start_time ASC 240282419
[DEBUG] 2025-01-25 04:12:00 +09:00 schema DB=default table=teacher_schedule SELECT start_time, end_time, available_site_ids FROM teacher_schedule WHERE teacher_id = ? AND ((start_time >= '2025-02-05 00:00:00 +09:00' AND start_time < '2025-02-06 02:00:00 +09:00') OR (end_time > '2025-02-05 00:00:00 +09:00' AND end_time <= '2025-02-06 02:00:00 +09:00') OR (start_time <= '2025-02-05 00:00:00 +09:00' AND end_time > '2025-02-06 02:00:00 +09:00')) AND status_id = 202 AND locked_flag = 'f' AND deleted_flag = 'f' ORDER BY start_time ASC 240282419
[DEBUG] 2025-01-25 04:12:00 +09:00 schema DB=default table=teacher_schedule SELECT start_time, end_time, available_site_ids FROM teacher_schedule WHERE teacher_id = ? AND ((start_time >= '2025-02-12 00:00:00 +09:00' AND start_time < '2025-02-13 02:00:00 +09:00') OR (end_time > '2025-02-12 00:00:00 +09:00' AND end_time <= '2025-02-13 02:00:00 +09:00') OR (start_time <= '2025-02-12 00:00:00 +09:00' AND end_time > '2025-02-13 02:00:00 +09:00')) AND status_id = 202 AND locked_flag = 'f' AND deleted_flag = 'f' ORDER BY start_time ASC 240282419
[DEBUG] 2025-01-25 04:12:00 +09:00 schema DB=default table=lesson SELECT start_time, end_time, student_id, id FROM lesson WHERE teacher_id = ? AND ((start_time >= '2025-01-29 00:00:00 +09:00' AND start_time < '2025-01-30 02:00:00 +09:00') OR (end_time > '2025-01-29 00:00:00 +09:00' AND end_time <= '2025-01-30 02:00:00 +09:00') OR (start_time <= '2025-01-29 00:00:00 +09:00' AND end_time > '2025-01-30 02:00:00 +09:00')) AND canceled_flag = 'f' AND deleted_flag = 'f' ORDER BY start_time ASC 240282419
[DEBUG] 2025-01-25 04:12:00 +09:00 schema DB=default table=lesson SELECT start_time, end_time, student_id, id FROM lesson WHERE teacher_id = ? AND ((start_time >= '2025-02-05 00:00:00 +09:00' AND start_time < '2025-02-06 02:00:00 +09:00') OR (end_time > '2025-02-05 00:00:00 +09:00' AND end_time <= '2025-02-06 02:00:00 +09:00') OR (start_time <= '2025-02-05 00:00:00 +09:00' AND end_time > '2025-02-06 02:00:00 +09:00')) AND canceled_flag = 'f' AND deleted_flag = 'f' ORDER BY start_time ASC 240282419
[DEBUG] 2025-01-25 04:12:00 +09:00 schema DB=default table=lesson SELECT start_time, end_time, student_id, id FROM lesson WHERE teacher_id = ? AND ((start_time >= '2025-02-12 00:00:00 +09:00' AND start_time < '2025-02-13 02:00:00 +09:00') OR (end_time > '2025-02-12 00:00:00 +09:00' AND end_time <= '2025-02-13 02:00:00 +09:00') OR (start_time <= '2025-02-12 00:00:00 +09:00' AND end_time > '2025-02-13 02:00:00 +09:00')) AND canceled_flag = 'f' AND deleted_flag = 'f' ORDER BY start_time ASC 240282419
[DEBUG] 2025-01-25 04:12:00 +09:00 schema DB=default table=teacher_fixed_schedule SELECT * FROM teacher_fixed_schedule WHERE teacher_id = ? AND start_min >= ? AND end_min <= ? AND deleted_flag = 'f' ORDER BY start_min ASC 240282419 5760 7320
[DEBUG] 2025-01-25 04:12:00 +09:00 schema DB=default table=teacher_fixed_schedule SELECT * FROM teacher_fixed_schedule WHERE teacher_id = ? AND start_min >= ? AND end_min <= ? AND deleted_flag = 'f' ORDER BY start_min ASC 240282419 0 -2760
[DEBUG] 2025-01-25 04:12:00 +09:00 schema DB=default table=student_lesson_order SELECT * FROM student_lesson_order WHERE teacher_id = ? AND ((start_min >= '5760' AND start_min < '7320') OR (end_min > '5760' AND end_min <= '7320') OR (start_min <= '5760' AND end_min > '7320') OR (start_min <= '5760' AND end_min > '7320')) AND (stopped_flag = 'f' OR (stopped_flag = 't' AND reservation_stop_time >= '2025-01-30 00:00:00 +09:00')) AND deleted_flag = 'f' ORDER BY start_min ASC, ordered_time ASC, id ASC 240282419
[DEBUG] 2025-01-25 04:12:00 +09:00 schema DB=default table=student_lesson_order SELECT * FROM student_lesson_order WHERE teacher_id = ? AND ((start_min >= '0' AND start_min < '-2760') OR (end_min > '0' AND end_min <= '-2760') OR (start_min <= '0' AND end_min > '-2760') OR (start_min <= '0' AND end_min > '-2760')) AND (stopped_flag = 'f' OR (stopped_flag = 't' AND reservation_stop_time >= '2025-01-30 00:00:00 +09:00')) AND deleted_flag = 'f' ORDER BY start_min ASC, ordered_time ASC 240282419
[DEBUG] 2025-01-25 04:12:00 +09:00 schema DB=default table=teacher_schedule SELECT start_time, end_time, available_site_ids FROM teacher_schedule WHERE teacher_id = ? AND ((start_time >= '2025-01-30 00:00:00 +09:00' AND start_time < '2025-01-31 02:00:00 +09:00') OR (end_time > '2025-01-30 00:00:00 +09:00' AND end_time <= '2025-01-31 02:00:00 +09:00') OR (start_time <= '2025-01-30 00:00:00 +09:00' AND end_time > '2025-01-31 02:00:00 +09:00')) AND status_id = 202 AND locked_flag = 'f' AND deleted_flag = 'f' ORDER BY start_time ASC 240282419
[DEBUG] 2025-01-25 04:12:00 +09:00 schema DB=default table=teacher_schedule SELECT start_time, end_time, available_site_ids FROM teacher_schedule WHERE teacher_id = ? AND ((start_time >= '2025-02-06 00:00:00 +09:00' AND start_time < '2025-02-07 02:00:00 +09:00') OR (end_time > '2025-02-06 00:00:00 +09:00' AND end_time <= '2025-02-07 02:00:00 +09:00') OR (start_time <= '2025-02-06 00:00:00 +09:00' AND end_time > '2025-02-07 02:00:00 +09:00')) AND status_id = 202 AND locked_flag = 'f' AND deleted_flag = 'f' ORDER BY start_time ASC 240282419
[DEBUG] 2025-01-25 04:12:00 +09:00 schema DB=default table=teacher_schedule SELECT start_time, end_time, available_site_ids FROM teacher_schedule WHERE teacher_id = ? AND ((start_time >= '2025-02-13 00:00:00 +09:00' AND start_time < '2025-02-14 02:00:00 +09:00') OR (end_time > '2025-02-13 00:00:00 +09:00' AND end_time <= '2025-02-14 02:00:00 +09:00') OR (start_time <= '2025-02-13 00:00:00 +09:00' AND end_time > '2025-02-14 02:00:00 +09:00')) AND status_id = 202 AND locked_flag = 'f' AND deleted_flag = 'f' ORDER BY start_time ASC 240282419
[DEBUG] 2025-01-25 04:12:00 +09:00 schema DB=default table=lesson SELECT start_time, end_time, student_id, id FROM lesson WHERE teacher_id = ? AND ((start_time >= '2025-01-30 00:00:00 +09:00' AND start_time < '2025-01-31 02:00:00 +09:00') OR (end_time > '2025-01-30 00:00:00 +09:00' AND end_time <= '2025-01-31 02:00:00 +09:00') OR (start_time <= '2025-01-30 00:00:00 +09:00' AND end_time > '2025-01-31 02:00:00 +09:00')) AND canceled_flag = 'f' AND deleted_flag = 'f' ORDER BY start_time ASC 240282419
[DEBUG] 2025-01-25 04:12:00 +09:00 schema DB=default table=lesson SELECT start_time, end_time, student_id, id FROM lesson WHERE teacher_id = ? AND ((start_time >= '2025-02-06 00:00:00 +09:00' AND start_time < '2025-02-07 02:00:00 +09:00') OR (end_time > '2025-02-06 00:00:00 +09:00' AND end_time <= '2025-02-07 02:00:00 +09:00') OR (start_time <= '2025-02-06 00:00:00 +09:00' AND end_time > '2025-02-07 02:00:00 +09:00')) AND canceled_flag = 'f' AND deleted_flag = 'f' ORDER BY start_time ASC 240282419
[DEBUG] 2025-01-25 04:12:00 +09:00 schema DB=default table=lesson SELECT start_time, end_time, student_id, id FROM lesson WHERE teacher_id = ? AND ((start_time >= '2025-02-13 00:00:00 +09:00' AND start_time < '2025-02-14 02:00:00 +09:00') OR (end_time > '2025-02-13 00:00:00 +09:00' AND end_time <= '2025-02-14 02:00:00 +09:00') OR (start_time <= '2025-02-13 00:00:00 +09:00' AND end_time > '2025-02-14 02:00:00 +09:00')) AND canceled_flag = 'f' AND deleted_flag = 'f' ORDER BY start_time ASC 240282419
[DEBUG] 2025-01-25 04:12:00 +09:00 schema DB=default table=teacher_fixed_schedule SELECT * FROM teacher_fixed_schedule WHERE teacher_id = ? AND start_min >= ? AND end_min <= ? AND deleted_flag = 'f' ORDER BY start_min ASC 240282419 7200 8760
[DEBUG] 2025-01-25 04:12:00 +09:00 schema DB=default table=teacher_fixed_schedule SELECT * FROM teacher_fixed_schedule WHERE teacher_id = ? AND start_min >= ? AND end_min <= ? AND deleted_flag = 'f' ORDER BY start_min ASC 240282419 0 -1320
[DEBUG] 2025-01-25 04:12:00 +09:00 schema DB=default table=student_lesson_order SELECT * FROM student_lesson_order WHERE teacher_id = ? AND ((start_min >= '7200' AND start_min < '8760') OR (end_min > '7200' AND end_min <= '8760') OR (start_min <= '7200' AND end_min > '8760') OR (start_min <= '7200' AND end_min > '8760')) AND (stopped_flag = 'f' OR (stopped_flag = 't' AND reservation_stop_time >= '2025-01-31 00:00:00 +09:00')) AND deleted_flag = 'f' ORDER BY start_min ASC, ordered_time ASC, id ASC 240282419
[DEBUG] 2025-01-25 04:12:00 +09:00 schema DB=default table=student_lesson_order SELECT * FROM student_lesson_order WHERE teacher_id = ? AND ((start_min >= '0' AND start_min < '-1320') OR (end_min > '0' AND end_min <= '-1320') OR (start_min <= '0' AND end_min > '-1320') OR (start_min <= '0' AND end_min > '-1320')) AND (stopped_flag = 'f' OR (stopped_flag = 't' AND reservation_stop_time >= '2025-01-31 00:00:00 +09:00')) AND deleted_flag = 'f' ORDER BY start_min ASC, ordered_time ASC 240282419
[DEBUG] 2025-01-25 04:12:00 +09:00 schema DB=default table=teacher_schedule SELECT start_time, end_time, available_site_ids FROM teacher_schedule WHERE teacher_id = ? AND ((start_time >= '2025-01-31 00:00:00 +09:00' AND start_time < '2025-02-01 02:00:00 +09:00') OR (end_time > '2025-01-31 00:00:00 +09:00' AND end_time <= '2025-02-01 02:00:00 +09:00') OR (start_time <= '2025-01-31 00:00:00 +09:00' AND end_time > '2025-02-01 02:00:00 +09:00')) AND status_id = 202 AND locked_flag = 'f' AND deleted_flag = 'f' ORDER BY start_time ASC 240282419
[DEBUG] 2025-01-25 04:12:00 +09:00 schema DB=default table=teacher_schedule SELECT start_time, end_time, available_site_ids FROM teacher_schedule WHERE teacher_id = ? AND ((start_time >= '2025-02-07 00:00:00 +09:00' AND start_time < '2025-02-08 02:00:00 +09:00') OR (end_time > '2025-02-07 00:00:00 +09:00' AND end_time <= '2025-02-08 02:00:00 +09:00') OR (start_time <= '2025-02-07 00:00:00 +09:00' AND end_time > '2025-02-08 02:00:00 +09:00')) AND status_id = 202 AND locked_flag = 'f' AND deleted_flag = 'f' ORDER BY start_time ASC 240282419
[DEBUG] 2025-01-25 04:12:00 +09:00 schema DB=default table=teacher_schedule SELECT start_time, end_time, available_site_ids FROM teacher_schedule WHERE teacher_id = ? AND ((start_time >= '2025-02-14 00:00:00 +09:00' AND start_time < '2025-02-15 02:00:00 +09:00') OR (end_time > '2025-02-14 00:00:00 +09:00' AND end_time <= '2025-02-15 02:00:00 +09:00') OR (start_time <= '2025-02-14 00:00:00 +09:00' AND end_time > '2025-02-15 02:00:00 +09:00')) AND status_id = 202 AND locked_flag = 'f' AND deleted_flag = 'f' ORDER BY start_time ASC 240282419
[DEBUG] 2025-01-25 04:12:00 +09:00 schema DB=default table=lesson SELECT start_time, end_time, student_id, id FROM lesson WHERE teacher_id = ? AND ((start_time >= '2025-01-31 00:00:00 +09:00' AND start_time < '2025-02-01 02:00:00 +09:00') OR (end_time > '2025-01-31 00:00:00 +09:00' AND end_time <= '2025-02-01 02:00:00 +09:00') OR (start_time <= '2025-01-31 00:00:00 +09:00' AND end_time > '2025-02-01 02:00:00 +09:00')) AND canceled_flag = 'f' AND deleted_flag = 'f' ORDER BY start_time ASC 240282419
[DEBUG] 2025-01-25 04:12:00 +09:00 schema DB=default table=lesson SELECT start_time, end_time, student_id, id FROM lesson WHERE teacher_id = ? AND ((start_time >= '2025-02-07 00:00:00 +09:00' AND start_time < '2025-02-08 02:00:00 +09:00') OR (end_time > '2025-02-07 00:00:00 +09:00' AND end_time <= '2025-02-08 02:00:00 +09:00') OR (start_time <= '2025-02-07 00:00:00 +09:00' AND end_time > '2025-02-08 02:00:00 +09:00')) AND canceled_flag = 'f' AND deleted_flag = 'f' ORDER BY start_time ASC 240282419
[DEBUG] 2025-01-25 04:12:00 +09:00 schema DB=default table=lesson SELECT start_time, end_time, student_id, id FROM lesson WHERE teacher_id = ? AND ((start_time >= '2025-02-14 00:00:00 +09:00' AND start_time < '2025-02-15 02:00:00 +09:00') OR (end_time > '2025-02-14 00:00:00 +09:00' AND end_time <= '2025-02-15 02:00:00 +09:00') OR (start_time <= '2025-02-14 00:00:00 +09:00' AND end_time > '2025-02-15 02:00:00 +09:00')) AND canceled_flag = 'f' AND deleted_flag = 'f' ORDER BY start_time ASC 240282419
[DEBUG] 2025-01-25 04:12:00 +09:00 schema DB=default table=teacher_fixed_schedule SELECT * FROM teacher_fixed_schedule WHERE teacher_id = ? AND start_min >= ? AND end_min <= ? AND deleted_flag = 'f' ORDER BY start_min ASC 240282419 8640 10200
[DEBUG] 2025-01-25 04:12:00 +09:00 schema DB=default table=teacher_fixed_schedule SELECT * FROM teacher_fixed_schedule WHERE teacher_id = ? AND start_min >= ? AND end_min <= ? AND deleted_flag = 'f' ORDER BY start_min ASC 240282419 0 120
[DEBUG] 2025-01-25 04:12:00 +09:00 schema DB=default table=student_lesson_order SELECT * FROM student_lesson_order WHERE teacher_id = ? AND ((start_min >= '8640' AND start_min < '10200') OR (end_min > '8640' AND end_min <= '10200') OR (start_min <= '8640' AND end_min > '10200') OR (start_min <= '8640' AND end_min > '10200')) AND (stopped_flag = 'f' OR (stopped_flag = 't' AND reservation_stop_time >= '2025-01-25 00:00:00 +09:00')) AND deleted_flag = 'f' ORDER BY start_min ASC, ordered_time ASC, id ASC 240282419
[DEBUG] 2025-01-25 04:12:00 +09:00 schema DB=default table=student_lesson_order SELECT * FROM student_lesson_order WHERE teacher_id = ? AND ((start_min >= '0' AND start_min < '120') OR (end_min > '0' AND end_min <= '120') OR (start_min <= '0' AND end_min > '120') OR (start_min <= '0' AND end_min > '120')) AND (stopped_flag = 'f' OR (stopped_flag = 't' AND reservation_stop_time >= '2025-01-25 00:00:00 +09:00')) AND deleted_flag = 'f' ORDER BY start_min ASC, ordered_time ASC 240282419
[DEBUG] 2025-01-25 04:12:00 +09:00 schema DB=default table=teacher_schedule SELECT start_time, end_time, available_site_ids FROM teacher_schedule WHERE teacher_id = ? AND ((start_time >= '2025-01-25 00:00:00 +09:00' AND start_time < '2025-01-26 02:00:00 +09:00') OR (end_time > '2025-01-25 00:00:00 +09:00' AND end_time <= '2025-01-26 02:00:00 +09:00') OR (start_time <= '2025-01-25 00:00:00 +09:00' AND end_time > '2025-01-26 02:00:00 +09:00')) AND status_id = 202 AND locked_flag = 'f' AND deleted_flag = 'f' ORDER BY start_time ASC 240282419
[DEBUG] 2025-01-25 04:12:00 +09:00 schema DB=default table=teacher_schedule SELECT start_time, end_time, available_site_ids FROM teacher_schedule WHERE teacher_id = ? AND ((start_time >= '2025-02-01 00:00:00 +09:00' AND start_time < '2025-02-02 02:00:00 +09:00') OR (end_time > '2025-02-01 00:00:00 +09:00' AND end_time <= '2025-02-02 02:00:00 +09:00') OR (start_time <= '2025-02-01 00:00:00 +09:00' AND end_time > '2025-02-02 02:00:00 +09:00')) AND status_id = 202 AND locked_flag = 'f' AND deleted_flag = 'f' ORDER BY start_time ASC 240282419
[DEBUG] 2025-01-25 04:12:00 +09:00 schema DB=default table=teacher_schedule SELECT start_time, end_time, available_site_ids FROM teacher_schedule WHERE teacher_id = ? AND ((start_time >= '2025-02-08 00:00:00 +09:00' AND start_time < '2025-02-09 02:00:00 +09:00') OR (end_time > '2025-02-08 00:00:00 +09:00' AND end_time <= '2025-02-09 02:00:00 +09:00') OR (start_time <= '2025-02-08 00:00:00 +09:00' AND end_time > '2025-02-09 02:00:00 +09:00')) AND status_id = 202 AND locked_flag = 'f' AND deleted_flag = 'f' ORDER BY start_time ASC 240282419
[DEBUG] 2025-01-25 04:12:00 +09:00 schema DB=default table=teacher_schedule SELECT start_time, end_time, available_site_ids FROM teacher_schedule WHERE teacher_id = ? AND ((start_time >= '2025-02-15 00:00:00 +09:00' AND start_time < '2025-02-16 02:00:00 +09:00') OR (end_time > '2025-02-15 00:00:00 +09:00' AND end_time <= '2025-02-16 02:00:00 +09:00') OR (start_time <= '2025-02-15 00:00:00 +09:00' AND end_time > '2025-02-16 02:00:00 +09:00')) AND status_id = 202 AND locked_flag = 'f' AND deleted_flag = 'f' ORDER BY start_time ASC 240282419
[DEBUG] 2025-01-25 04:12:00 +09:00 schema DB=default table=lesson SELECT start_time, end_time, student_id, id FROM lesson WHERE teacher_id = ? AND ((start_time >= '2025-01-25 00:00:00 +09:00' AND start_time < '2025-01-26 02:00:00 +09:00') OR (end_time > '2025-01-25 00:00:00 +09:00' AND end_time <= '2025-01-26 02:00:00 +09:00') OR (start_time <= '2025-01-25 00:00:00 +09:00' AND end_time > '2025-01-26 02:00:00 +09:00')) AND canceled_flag = 'f' AND deleted_flag = 'f' ORDER BY start_time ASC 240282419
[DEBUG] 2025-01-25 04:12:00 +09:00 schema DB=default table=lesson SELECT start_time, end_time, student_id, id FROM lesson WHERE teacher_id = ? AND ((start_time >= '2025-02-01 00:00:00 +09:00' AND start_time < '2025-02-02 02:00:00 +09:00') OR (end_time > '2025-02-01 00:00:00 +09:00' AND end_time <= '2025-02-02 02:00:00 +09:00') OR (start_time <= '2025-02-01 00:00:00 +09:00' AND end_time > '2025-02-02 02:00:00 +09:00')) AND canceled_flag = 'f' AND deleted_flag = 'f' ORDER BY start_time ASC 240282419
[DEBUG] 2025-01-25 04:12:00 +09:00 schema DB=default table=lesson SELECT start_time, end_time, student_id, id FROM lesson WHERE teacher_id = ? AND ((start_time >= '2025-02-08 00:00:00 +09:00' AND start_time < '2025-02-09 02:00:00 +09:00') OR (end_time > '2025-02-08 00:00:00 +09:00' AND end_time <= '2025-02-09 02:00:00 +09:00') OR (start_time <= '2025-02-08 00:00:00 +09:00' AND end_time > '2025-02-09 02:00:00 +09:00')) AND canceled_flag = 'f' AND deleted_flag = 'f' ORDER BY start_time ASC 240282419
[DEBUG] 2025-01-25 04:12:00 +09:00 schema DB=default table=lesson SELECT start_time, end_time, student_id, id FROM lesson WHERE teacher_id = ? AND ((start_time >= '2025-02-15 00:00:00 +09:00' AND start_time < '2025-02-16 02:00:00 +09:00') OR (end_time > '2025-02-15 00:00:00 +09:00' AND end_time <= '2025-02-16 02:00:00 +09:00') OR (start_time <= '2025-02-15 00:00:00 +09:00' AND end_time > '2025-02-16 02:00:00 +09:00')) AND canceled_flag = 'f' AND deleted_flag = 'f' ORDER BY start_time ASC 240282419
[DEBUG] 2025-01-25 04:12:00 +09:00 service QQE::Service::Site::Basic::Schedule::Fixed->get_schedules_of_week success
[DEBUG] 2025-01-25 04:12:00 +09:00 service QQE::Service::Site->execute success
[DEBUG] 2025-01-25 04:12:00 +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-01-25 04:12:00 +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