[DEBUG] 2025-02-20 21:56:40 +09:00 service QQE::Service::Site->execute execute
[DEBUG] 2025-02-20 21:56:40 +09:00 service QQE::Service::Site::Basic::Teacher->view execute
[DEBUG] 2025-02-20 21:56:40 +09:00 service QQE::Service::Auth::Student->check_token execute
[DEBUG] 2025-02-20 21:56:40 +09:00 service QQE::Service::Auth->check_token execute
[DEBUG] 2025-02-20 21:56:40 +09:00 service QQE::Service::Auth->check_token failed 301 token が指定されていません
[DEBUG] 2025-02-20 21:56:40 +09:00 service QQE::Service::Auth::Student->check_token failed 301 token が指定されていません
[DEBUG] 2025-02-20 21:56:40 +09:00 service QQE::Service::SNS::Teacher->view execute
[DEBUG] 2025-02-20 21:56:40 +09:00 schema DB=default table=teacher SELECT * FROM teacher WHERE deleted_flag = 'f' AND id = '223210441' LIMIT 1 OFFSET 0
[DEBUG] 2025-02-20 21:56:40 +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:223210441
[DEBUG] 2025-02-20 21:56:40 +09:00 service QQE::Service::SNS::Teacher->view success
[DEBUG] 2025-02-20 21:56:40 +09:00 service QQE::Service::Site::Basic::Teacher->view success
[DEBUG] 2025-02-20 21:56:40 +09:00 service QQE::Service::Site->execute success
[DEBUG] 2025-02-20 21:56:40 +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-02-20 21:56:40 +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-02-20 21:56:40 +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-02-20 21:56:40 +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-02-20 21:56:40 +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-02-20 21:56:40 +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-02-20 21:56:40 +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-02-20 21:56:40 +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-02-20 21:56:40 +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-02-20 21:56:40 +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-02-20 21:56:40 +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-02-20 21:56:40 +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-02-20 21:56:40 +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-02-20 21:56:40 +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-02-20 21:56:40 +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-02-20 21:56:40 +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-02-20 21:56:40 +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-02-20 21:56:40 +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-02-20 21:56:40 +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-02-20 21:56:40 +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-02-20 21:56:40 +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-02-20 21:56:40 +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-02-20 21:56:40 +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-02-20 21:56:40 +09:00 schema DB=default table=curriculum_original SELECT * FROM curriculum_original WHERE code = 'C0386' AND deleted_flag = 'f' LIMIT 1 OFFSET 0
[DEBUG] 2025-02-20 21:56:40 +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-02-20 21:56:40 +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-02-20 21:56:40 +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-02-20 21:56:40 +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-02-20 21:56:40 +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-02-20 21:56:40 +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-02-20 21:56:40 +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-02-20 21:56:40 +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-02-20 21:56:40 +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-02-20 21:56:40 +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-02-20 21:56:40 +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-02-20 21:56:40 +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-02-20 21:56:40 +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-02-20 21:56:40 +09:00 schema DB=default table=curriculum_original SELECT * FROM curriculum_original WHERE code = 'C0455' AND deleted_flag = 'f' LIMIT 1 OFFSET 0
[DEBUG] 2025-02-20 21:56:40 +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-02-20 21:56:40 +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-02-20 21:56:40 +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-02-20 21:56:40 +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-02-20 21:56:40 +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-02-20 21:56:40 +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-02-20 21:56:40 +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-02-20 21:56:40 +09:00 schema DB=default table=curriculum_original SELECT * FROM curriculum_original WHERE code = 'C0522' AND deleted_flag = 'f' LIMIT 1 OFFSET 0
[DEBUG] 2025-02-20 21:56:40 +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-02-20 21:56:40 +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-02-20 21:56:40 +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-02-20 21:56:40 +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-02-20 21:56:40 +09:00 schema DB=default table=curriculum_original SELECT * FROM curriculum_original WHERE code = 'C0579' AND deleted_flag = 'f' LIMIT 1 OFFSET 0
[DEBUG] 2025-02-20 21:56:40 +09:00 service QQE::Service::Site->execute execute
[DEBUG] 2025-02-20 21:56:40 +09:00 service QQE::Service::Site::Basic::Schedule::Teacher->get_collection_of_week execute
[DEBUG] 2025-02-20 21:56:40 +09:00 service QQE::Service::Auth::Student->check_token execute
[DEBUG] 2025-02-20 21:56:40 +09:00 service QQE::Service::Auth->check_token execute
[DEBUG] 2025-02-20 21:56:40 +09:00 service QQE::Service::Auth->check_token failed 301 token が指定されていません
[DEBUG] 2025-02-20 21:56:40 +09:00 service QQE::Service::Auth::Student->check_token failed 301 token が指定されていません
[DEBUG] 2025-02-20 21:56:40 +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 223210441 2025-02-16 13:00:00 +09:00 2025-02-16 17:00:00 +09:00 2025-02-16 13:00:00 +09:00 2025-02-16 17:00:00 +09:00 2025-02-16 13:00:00 +09:00 2025-02-16 17:00:00 +09:00 2025-02-16 13:00:00 +09:00 2025-02-16 17:00:00 +09:00
[DEBUG] 2025-02-20 21:56:40 +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 223210441 2025-02-16 13:00:00 +09:00 2025-02-16 17:00:00 +09:00 2025-02-16 13:00:00 +09:00 2025-02-16 17:00:00 +09:00 2025-02-16 13:00:00 +09:00 2025-02-16 17:00:00 +09:00 2025-02-16 13:00:00 +09:00 2025-02-16 17:00:00 +09:00
[DEBUG] 2025-02-20 21:56:40 +09:00 schema DB=default table=company_contract_group_schedule SELECT * FROM company_contract_group_schedule WHERE teacher_ids && ARRAY[223210441] 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-02-16 13:00:00 +09:00 2025-02-16 17:00:00 +09:00 2025-02-16 13:00:00 +09:00 2025-02-16 17:00:00 +09:00 2025-02-16 13:00:00 +09:00 2025-02-16 17:00:00 +09:00 2025-02-16 13:00:00 +09:00 2025-02-16 17:00:00 +09:00
[DEBUG] 2025-02-20 21:56:40 +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 223210441 2025-02-16 13:00:00 +09:00 2025-02-16 17:00:00 +09:00 2025-02-16 13:00:00 +09:00 2025-02-16 17:00:00 +09:00 2025-02-16 13:00:00 +09:00 2025-02-16 17:00:00 +09:00 2025-02-16 13:00:00 +09:00 2025-02-16 17:00:00 +09:00
[DEBUG] 2025-02-20 21:56:40 +09:00 schema DB=default table=student SELECT * FROM student WHERE id in (265166386,271798096,268689115,214213688,276089297,278311154) AND deleted_flag = 'f'
[DEBUG] 2025-02-20 21:56:40 +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 223210441 2025-02-17 13:00:00 +09:00 2025-02-17 17:00:00 +09:00 2025-02-17 13:00:00 +09:00 2025-02-17 17:00:00 +09:00 2025-02-17 13:00:00 +09:00 2025-02-17 17:00:00 +09:00 2025-02-17 13:00:00 +09:00 2025-02-17 17:00:00 +09:00
[DEBUG] 2025-02-20 21:56:40 +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 223210441 2025-02-17 13:00:00 +09:00 2025-02-17 17:00:00 +09:00 2025-02-17 13:00:00 +09:00 2025-02-17 17:00:00 +09:00 2025-02-17 13:00:00 +09:00 2025-02-17 17:00:00 +09:00 2025-02-17 13:00:00 +09:00 2025-02-17 17:00:00 +09:00
[DEBUG] 2025-02-20 21:56:40 +09:00 schema DB=default table=company_contract_group_schedule SELECT * FROM company_contract_group_schedule WHERE teacher_ids && ARRAY[223210441] 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-02-17 13:00:00 +09:00 2025-02-17 17:00:00 +09:00 2025-02-17 13:00:00 +09:00 2025-02-17 17:00:00 +09:00 2025-02-17 13:00:00 +09:00 2025-02-17 17:00:00 +09:00 2025-02-17 13:00:00 +09:00 2025-02-17 17:00:00 +09:00
[DEBUG] 2025-02-20 21:56:40 +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 223210441 2025-02-17 13:00:00 +09:00 2025-02-17 17:00:00 +09:00 2025-02-17 13:00:00 +09:00 2025-02-17 17:00:00 +09:00 2025-02-17 13:00:00 +09:00 2025-02-17 17:00:00 +09:00 2025-02-17 13:00:00 +09:00 2025-02-17 17:00:00 +09:00
[DEBUG] 2025-02-20 21:56:40 +09:00 schema DB=default table=student SELECT * FROM student WHERE id in (75196350,171771609,247624988) AND deleted_flag = 'f'
[DEBUG] 2025-02-20 21:56:40 +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 223210441 2025-02-18 13:00:00 +09:00 2025-02-18 17:00:00 +09:00 2025-02-18 13:00:00 +09:00 2025-02-18 17:00:00 +09:00 2025-02-18 13:00:00 +09:00 2025-02-18 17:00:00 +09:00 2025-02-18 13:00:00 +09:00 2025-02-18 17:00:00 +09:00
[DEBUG] 2025-02-20 21:56:40 +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 223210441 2025-02-18 13:00:00 +09:00 2025-02-18 17:00:00 +09:00 2025-02-18 13:00:00 +09:00 2025-02-18 17:00:00 +09:00 2025-02-18 13:00:00 +09:00 2025-02-18 17:00:00 +09:00 2025-02-18 13:00:00 +09:00 2025-02-18 17:00:00 +09:00
[DEBUG] 2025-02-20 21:56:40 +09:00 schema DB=default table=company_contract_group_schedule SELECT * FROM company_contract_group_schedule WHERE teacher_ids && ARRAY[223210441] 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-02-18 13:00:00 +09:00 2025-02-18 17:00:00 +09:00 2025-02-18 13:00:00 +09:00 2025-02-18 17:00:00 +09:00 2025-02-18 13:00:00 +09:00 2025-02-18 17:00:00 +09:00 2025-02-18 13:00:00 +09:00 2025-02-18 17:00:00 +09:00
[DEBUG] 2025-02-20 21:56:40 +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 223210441 2025-02-18 13:00:00 +09:00 2025-02-18 17:00:00 +09:00 2025-02-18 13:00:00 +09:00 2025-02-18 17:00:00 +09:00 2025-02-18 13:00:00 +09:00 2025-02-18 17:00:00 +09:00 2025-02-18 13:00:00 +09:00 2025-02-18 17:00:00 +09:00
[DEBUG] 2025-02-20 21:56:40 +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 223210441 2025-02-19 13:00:00 +09:00 2025-02-19 17:00:00 +09:00 2025-02-19 13:00:00 +09:00 2025-02-19 17:00:00 +09:00 2025-02-19 13:00:00 +09:00 2025-02-19 17:00:00 +09:00 2025-02-19 13:00:00 +09:00 2025-02-19 17:00:00 +09:00
[DEBUG] 2025-02-20 21:56:40 +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 223210441 2025-02-19 13:00:00 +09:00 2025-02-19 17:00:00 +09:00 2025-02-19 13:00:00 +09:00 2025-02-19 17:00:00 +09:00 2025-02-19 13:00:00 +09:00 2025-02-19 17:00:00 +09:00 2025-02-19 13:00:00 +09:00 2025-02-19 17:00:00 +09:00
[DEBUG] 2025-02-20 21:56:40 +09:00 schema DB=default table=company_contract_group_schedule SELECT * FROM company_contract_group_schedule WHERE teacher_ids && ARRAY[223210441] 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-02-19 13:00:00 +09:00 2025-02-19 17:00:00 +09:00 2025-02-19 13:00:00 +09:00 2025-02-19 17:00:00 +09:00 2025-02-19 13:00:00 +09:00 2025-02-19 17:00:00 +09:00 2025-02-19 13:00:00 +09:00 2025-02-19 17:00:00 +09:00
[DEBUG] 2025-02-20 21:56:40 +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 223210441 2025-02-19 13:00:00 +09:00 2025-02-19 17:00:00 +09:00 2025-02-19 13:00:00 +09:00 2025-02-19 17:00:00 +09:00 2025-02-19 13:00:00 +09:00 2025-02-19 17:00:00 +09:00 2025-02-19 13:00:00 +09:00 2025-02-19 17:00:00 +09:00
[DEBUG] 2025-02-20 21:56:40 +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 223210441 2025-02-20 13:00:00 +09:00 2025-02-20 17:00:00 +09:00 2025-02-20 13:00:00 +09:00 2025-02-20 17:00:00 +09:00 2025-02-20 13:00:00 +09:00 2025-02-20 17:00:00 +09:00 2025-02-20 13:00:00 +09:00 2025-02-20 17:00:00 +09:00
[DEBUG] 2025-02-20 21:56:40 +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 223210441 2025-02-20 13:00:00 +09:00 2025-02-20 17:00:00 +09:00 2025-02-20 13:00:00 +09:00 2025-02-20 17:00:00 +09:00 2025-02-20 13:00:00 +09:00 2025-02-20 17:00:00 +09:00 2025-02-20 13:00:00 +09:00 2025-02-20 17:00:00 +09:00
[DEBUG] 2025-02-20 21:56:40 +09:00 schema DB=default table=company_contract_group_schedule SELECT * FROM company_contract_group_schedule WHERE teacher_ids && ARRAY[223210441] 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-02-20 13:00:00 +09:00 2025-02-20 17:00:00 +09:00 2025-02-20 13:00:00 +09:00 2025-02-20 17:00:00 +09:00 2025-02-20 13:00:00 +09:00 2025-02-20 17:00:00 +09:00 2025-02-20 13:00:00 +09:00 2025-02-20 17:00:00 +09:00
[DEBUG] 2025-02-20 21:56:40 +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 223210441 2025-02-20 13:00:00 +09:00 2025-02-20 17:00:00 +09:00 2025-02-20 13:00:00 +09:00 2025-02-20 17:00:00 +09:00 2025-02-20 13:00:00 +09:00 2025-02-20 17:00:00 +09:00 2025-02-20 13:00:00 +09:00 2025-02-20 17:00:00 +09:00
[DEBUG] 2025-02-20 21:56:40 +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 223210441 2025-02-21 13:00:00 +09:00 2025-02-21 17:00:00 +09:00 2025-02-21 13:00:00 +09:00 2025-02-21 17:00:00 +09:00 2025-02-21 13:00:00 +09:00 2025-02-21 17:00:00 +09:00 2025-02-21 13:00:00 +09:00 2025-02-21 17:00:00 +09:00
[DEBUG] 2025-02-20 21:56:40 +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 223210441 2025-02-21 13:00:00 +09:00 2025-02-21 17:00:00 +09:00 2025-02-21 13:00:00 +09:00 2025-02-21 17:00:00 +09:00 2025-02-21 13:00:00 +09:00 2025-02-21 17:00:00 +09:00 2025-02-21 13:00:00 +09:00 2025-02-21 17:00:00 +09:00
[DEBUG] 2025-02-20 21:56:40 +09:00 schema DB=default table=company_contract_group_schedule SELECT * FROM company_contract_group_schedule WHERE teacher_ids && ARRAY[223210441] 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-02-21 13:00:00 +09:00 2025-02-21 17:00:00 +09:00 2025-02-21 13:00:00 +09:00 2025-02-21 17:00:00 +09:00 2025-02-21 13:00:00 +09:00 2025-02-21 17:00:00 +09:00 2025-02-21 13:00:00 +09:00 2025-02-21 17:00:00 +09:00
[DEBUG] 2025-02-20 21:56:40 +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 223210441 2025-02-21 13:00:00 +09:00 2025-02-21 17:00:00 +09:00 2025-02-21 13:00:00 +09:00 2025-02-21 17:00:00 +09:00 2025-02-21 13:00:00 +09:00 2025-02-21 17:00:00 +09:00 2025-02-21 13:00:00 +09:00 2025-02-21 17:00:00 +09:00
[DEBUG] 2025-02-20 21:56:40 +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 223210441 2025-02-22 13:00:00 +09:00 2025-02-22 17:00:00 +09:00 2025-02-22 13:00:00 +09:00 2025-02-22 17:00:00 +09:00 2025-02-22 13:00:00 +09:00 2025-02-22 17:00:00 +09:00 2025-02-22 13:00:00 +09:00 2025-02-22 17:00:00 +09:00
[DEBUG] 2025-02-20 21:56:40 +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 223210441 2025-02-22 13:00:00 +09:00 2025-02-22 17:00:00 +09:00 2025-02-22 13:00:00 +09:00 2025-02-22 17:00:00 +09:00 2025-02-22 13:00:00 +09:00 2025-02-22 17:00:00 +09:00 2025-02-22 13:00:00 +09:00 2025-02-22 17:00:00 +09:00
[DEBUG] 2025-02-20 21:56:40 +09:00 schema DB=default table=company_contract_group_schedule SELECT * FROM company_contract_group_schedule WHERE teacher_ids && ARRAY[223210441] 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-02-22 13:00:00 +09:00 2025-02-22 17:00:00 +09:00 2025-02-22 13:00:00 +09:00 2025-02-22 17:00:00 +09:00 2025-02-22 13:00:00 +09:00 2025-02-22 17:00:00 +09:00 2025-02-22 13:00:00 +09:00 2025-02-22 17:00:00 +09:00
[DEBUG] 2025-02-20 21:56:40 +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 223210441 2025-02-22 13:00:00 +09:00 2025-02-22 17:00:00 +09:00 2025-02-22 13:00:00 +09:00 2025-02-22 17:00:00 +09:00 2025-02-22 13:00:00 +09:00 2025-02-22 17:00:00 +09:00 2025-02-22 13:00:00 +09:00 2025-02-22 17:00:00 +09:00
[DEBUG] 2025-02-20 21:56:40 +09:00 schema DB=default table=teacher SELECT * FROM teacher WHERE deleted_flag = 'f' AND id = '223210441' LIMIT 1 OFFSET 0
[DEBUG] 2025-02-20 21:56:40 +09:00 service QQE::Service::Site::Basic::Schedule::Teacher->get_collection_of_week success
[DEBUG] 2025-02-20 21:56:40 +09:00 service QQE::Service::Site->execute success
[DEBUG] 2025-02-20 21:56:40 +09:00 service QQE::Service::Site->execute execute
[DEBUG] 2025-02-20 21:56:41 +09:00 service QQE::Service::Site::Basic::Curriculum->search execute
[DEBUG] 2025-02-20 21:56:41 +09:00 service QQE::Service::Auth::Student->check_token execute
[DEBUG] 2025-02-20 21:56:41 +09:00 service QQE::Service::Auth->check_token execute
[DEBUG] 2025-02-20 21:56:41 +09:00 service QQE::Service::Auth->check_token failed 301 token が指定されていません
[DEBUG] 2025-02-20 21:56:41 +09:00 service QQE::Service::Auth::Student->check_token failed 301 token が指定されていません
[DEBUG] 2025-02-20 21:56:41 +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-02-20 21:56:41 +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-02-20 21:56:41 +09:00 service QQE::Service::Site::Basic::Curriculum->search success
[DEBUG] 2025-02-20 21:56:41 +09:00 service QQE::Service::Site->execute success
[DEBUG] 2025-02-20 21:56:41 +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-02-20 21:56:41 +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