2020-05-05 10:40:00.053 DEBUG org.hibernate.SQL - select exambatchi0_.EXAM_BATCH_ID as col_0_0_ from exam_batch_info exambatchi0_ cross join exam_info examinfo1_ where exambatchi0_.EXAM_ID=examinfo1_.EXAM_ID and exambatchi0_.START_TIME>=? and exambatchi0_.START_TIME=? and mediavideo0_.START_TIME=? and exambatchi0_.START_TIME=? and mediavideo0_.START_TIME=? and exambatchi0_.START_TIME=? and mediavideo0_.START_TIME=sysdate() order by clsclass0_.CREATE_TIME desc limit ? 2020-05-05 10:51:23.629 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [1] as [VARCHAR] - [1] 2020-05-05 10:51:23.629 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [2] as [VARCHAR] - [%] 2020-05-05 10:51:28.363 DEBUG org.hibernate.SQL - select count(1) as col_0_0_ from class_room classroom0_ where (classroom0_.name like ?) and classroom0_.CREATE_ID=? and classroom0_.DELETE_FLAG=0 2020-05-05 10:51:28.364 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [1] as [VARCHAR] - [%%] 2020-05-05 10:51:28.364 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [2] as [VARCHAR] - [40288a1261d106ba0161d1072e260000] 2020-05-05 10:51:28.375 DEBUG org.hibernate.SQL - select count(1) as col_0_0_ from class_room classroom0_ where (classroom0_.name like ?) and classroom0_.CREATE_ID=? and classroom0_.DELETE_FLAG=0 2020-05-05 10:51:28.375 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [1] as [VARCHAR] - [%%] 2020-05-05 10:51:28.375 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [2] as [VARCHAR] - [40288a1261d106ba0161d1072e260000] 2020-05-05 10:51:28.380 DEBUG org.hibernate.SQL - select classroom0_.ROOM_ID as ROOM_ID1_63_, classroom0_.address as address2_63_, classroom0_.CREATE_ID as CREATE_I3_63_, classroom0_.CREATE_TIME as CREATE_T4_63_, classroom0_.CREATOR as CREATOR5_63_, classroom0_.DELETE_FLAG as DELETE_F6_63_, classroom0_.name as name7_63_, classroom0_.ORG_ID as ORG_ID8_63_, classroom0_.status as status9_63_, classroom0_.UPDATE_ID as UPDATE_10_63_, classroom0_.UPDATE_TIME as UPDATE_11_63_, classroom0_.UPDATOR as UPDATOR12_63_ from class_room classroom0_ where (classroom0_.name like ?) and classroom0_.CREATE_ID=? and classroom0_.DELETE_FLAG=0 order by classroom0_.CREATE_TIME desc limit ? 2020-05-05 10:51:28.380 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [1] as [VARCHAR] - [%%] 2020-05-05 10:51:28.380 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [2] as [VARCHAR] - [40288a1261d106ba0161d1072e260000] 2020-05-05 10:55:00.017 DEBUG org.hibernate.SQL - select mediavideo0_.VIDEO_LIVE_ID as VIDEO_LI1_11_, mediavideo0_.ANCHOR as ANCHOR2_11_, mediavideo0_.ANCHOR_ID as ANCHOR_I3_11_, mediavideo0_.ATTRIBUTE as ATTRIBUT4_11_, mediavideo0_.COMPLETE_FLAG as COMPLETE5_11_, mediavideo0_.CONSULT_IMG_URL as CONSULT_6_11_, mediavideo0_.CREATE_ID as CREATE_I7_11_, mediavideo0_.CREATE_TIME as CREATE_T8_11_, mediavideo0_.CREATOR as CREATOR9_11_, mediavideo0_.DEFINITION as DEFINIT10_11_, mediavideo0_.DELETE_FLAG as DELETE_11_11_, mediavideo0_.EDIT_REPLAY_FLAG as EDIT_RE12_11_, mediavideo0_.END_TIME as END_TIM13_11_, mediavideo0_.EXPECTED_TIMES as EXPECTE14_11_, mediavideo0_.WY_HLS_PULL_URL as WY_HLS_15_11_, mediavideo0_.WY_HTTP_PULL_URL as WY_HTTP16_11_, mediavideo0_.LAST_RECORD_TIME as LAST_RE17_11_, mediavideo0_.TQ_MEETING_ID as TQ_MEET18_11_, mediavideo0_.TQ_MEETING_PWD as TQ_MEET19_11_, mediavideo0_.NAME as NAME20_11_, mediavideo0_.ON_TIME_FLAG as ON_TIME21_11_, mediavideo0_.ORDER_TIMES as ORDER_T22_11_, mediavideo0_.PERMISSION as PERMISS23_11_, mediavideo0_.PLAY_TIMES as PLAY_TI24_11_, mediavideo0_.PRAISE_TIMES as PRAISE_25_11_, mediavideo0_.PREVIEW_IMG_URL as PREVIEW26_11_, mediavideo0_.PREVIEW_VIDEO_URL as PREVIEW27_11_, mediavideo0_.WY_PUSH_URL as WY_PUSH28_11_, mediavideo0_.REMARK as REMARK29_11_, mediavideo0_.REVIEW_TIMES as REVIEW_30_11_, mediavideo0_.WY_RTMP_PULL_URL as WY_RTMP31_11_, mediavideo0_.SHARE_TIMES as SHARE_T32_11_, mediavideo0_.START_TIME as START_T33_11_, mediavideo0_.STATUS as STATUS34_11_, mediavideo0_.SUBJECT_ID as SUBJECT35_11_, mediavideo0_.SUBJECT_NAME as SUBJECT36_11_, mediavideo0_.TECENT_LIVE_NUMBER as TECENT_37_11_, mediavideo0_.UPDATE_ID as UPDATE_38_11_, mediavideo0_.UPDATE_TIME as UPDATE_39_11_, mediavideo0_.UPDATOR as UPDATOR40_11_, mediavideo0_.WATCH_MAX_TIMES as WATCH_M41_11_, mediavideo0_.WATCH_TIMES as WATCH_T42_11_, mediavideo0_.WATCHER_LIMIT as WATCHER43_11_, mediavideo0_.WY_LIVE_NUMBER as WY_LIVE44_11_ from MEDIA_VIDEO_LIVE mediavideo0_ where mediavideo0_.START_TIME>=? and mediavideo0_.START_TIME=? and exambatchi0_.START_TIME=sysdate() order by clsclass0_.CREATE_TIME desc limit ? 2020-05-05 10:55:53.008 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [1] as [VARCHAR] - [1] 2020-05-05 10:55:53.008 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [2] as [VARCHAR] - [%] 2020-05-05 10:55:53.033 DEBUG org.hibernate.SQL - select count(1) as col_0_0_ from cls_class clsclass0_ where clsclass0_.DELETE_FLAG=0 and clsclass0_.ORG_ID=? and (clsclass0_.NAME like ?) and clsclass0_.END_TIME>=sysdate() 2020-05-05 10:55:53.033 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [1] as [VARCHAR] - [1] 2020-05-05 10:55:53.033 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [2] as [VARCHAR] - [%] 2020-05-05 10:55:53.034 DEBUG org.hibernate.SQL - select count(1) as col_0_0_ from cls_class clsclass0_ where clsclass0_.DELETE_FLAG=0 and clsclass0_.ORG_ID=? and (clsclass0_.NAME like ?) and clsclass0_.END_TIME>=sysdate() 2020-05-05 10:55:53.035 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [1] as [VARCHAR] - [1] 2020-05-05 10:55:53.035 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [2] as [VARCHAR] - [%] 2020-05-05 10:55:55.043 DEBUG org.hibernate.SQL - select userteache0_.TEACHER_ID as TEACHER_1_244_, userteache0_.CREATE_ID as CREATE_I2_244_, userteache0_.CREATE_TIME as CREATE_T3_244_, userteache0_.CREATOR as CREATOR4_244_, userteache0_.DELETE_FLAG as DELETE_F5_244_, userteache0_.MOBILE_PHONE as MOBILE_P6_244_, userteache0_.NAME as NAME7_244_, userteache0_.ORGANIZATION_ID as ORGANIZA8_244_, userteache0_.TEACHER_NO as TEACHER_9_244_, userteache0_.UPDATE_ID as UPDATE_10_244_, userteache0_.UPDATE_TIME as UPDATE_11_244_, userteache0_.UPDATOR as UPDATOR12_244_, userteache0_.USER_ID as USER_ID13_244_ from user_teacher userteache0_ where (userteache0_.NAME like ?) and userteache0_.DELETE_FLAG=0 and userteache0_.ORGANIZATION_ID=? order by userteache0_.CREATE_TIME desc limit ? 2020-05-05 10:55:55.043 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [1] as [VARCHAR] - [%] 2020-05-05 10:55:55.043 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [2] as [VARCHAR] - [1] 2020-05-05 10:55:55.082 DEBUG org.hibernate.SQL - select count(1) as col_0_0_ from user_teacher userteache0_ where (userteache0_.NAME like ?) and userteache0_.DELETE_FLAG=0 and userteache0_.ORGANIZATION_ID=? 2020-05-05 10:55:55.083 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [1] as [VARCHAR] - [%] 2020-05-05 10:55:55.083 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [2] as [VARCHAR] - [1] 2020-05-05 10:55:55.085 DEBUG org.hibernate.SQL - select count(1) as col_0_0_ from user_teacher userteache0_ where (userteache0_.NAME like ?) and userteache0_.DELETE_FLAG=0 and userteache0_.ORGANIZATION_ID=? 2020-05-05 10:55:55.085 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [1] as [VARCHAR] - [%] 2020-05-05 10:55:55.085 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [2] as [VARCHAR] - [1] 2020-05-05 10:56:03.905 DEBUG org.hibernate.SQL - select count(1) as col_0_0_ from exam_paper_info exampaperi0_ where exampaperi0_.CREATE_ID=? and (exampaperi0_.EXAM_PAPER_NAME like ?) and exampaperi0_.DELETE_FLAG=0 2020-05-05 10:56:03.910 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [1] as [VARCHAR] - [40288a1261d106ba0161d1072e260000] 2020-05-05 10:56:03.911 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [2] as [VARCHAR] - [%%] 2020-05-05 10:56:03.922 DEBUG org.hibernate.SQL - select count(1) as col_0_0_ from exam_paper_info exampaperi0_ where exampaperi0_.CREATE_ID=? and (exampaperi0_.EXAM_PAPER_NAME like ?) and exampaperi0_.DELETE_FLAG=0 2020-05-05 10:56:03.928 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [1] as [VARCHAR] - [40288a1261d106ba0161d1072e260000] 2020-05-05 10:56:03.928 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [2] as [VARCHAR] - [%%] 2020-05-05 10:56:03.933 DEBUG org.hibernate.SQL - select exampaperi0_.EXAM_PAPER_ID as EXAM_PAP1_77_, exampaperi0_.CREATE_ID as CREATE_I2_77_, exampaperi0_.CREATE_TIME as CREATE_T3_77_, exampaperi0_.CREATOR as CREATOR4_77_, exampaperi0_.DELETE_FLAG as DELETE_F5_77_, exampaperi0_.DIFFICULT_LEVEL as DIFFICUL6_77_, exampaperi0_.EXAM_PAPER_NAME as EXAM_PAP7_77_, exampaperi0_.GROUP_ID as GROUP_ID8_77_, exampaperi0_.ORG_ID as ORG_ID9_77_, exampaperi0_.PAPER_STATUS as PAPER_S10_77_, exampaperi0_.TOTAL_SCORE as TOTAL_S11_77_, exampaperi0_.UPDATE_ID as UPDATE_12_77_, exampaperi0_.UPDATE_TIME as UPDATE_13_77_, exampaperi0_.UPDATOR as UPDATOR14_77_ from exam_paper_info exampaperi0_ where exampaperi0_.CREATE_ID=? and (exampaperi0_.EXAM_PAPER_NAME like ?) and exampaperi0_.DELETE_FLAG=0 order by exampaperi0_.CREATE_TIME DESC limit ? 2020-05-05 10:56:03.933 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [1] as [VARCHAR] - [40288a1261d106ba0161d1072e260000] 2020-05-05 10:56:03.934 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [2] as [VARCHAR] - [%%] 2020-05-05 10:56:06.320 DEBUG org.hibernate.SQL - select count(1) as col_0_0_ from exam_info examinfo0_ where (examinfo0_.EXAM_NAME like ?) and examinfo0_.CREATE_ID=? and examinfo0_.DELETE_FLAG=0 2020-05-05 10:56:06.321 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [1] as [VARCHAR] - [%%] 2020-05-05 10:56:06.321 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [2] as [VARCHAR] - [40288a1261d106ba0161d1072e260000] 2020-05-05 10:56:06.322 DEBUG org.hibernate.SQL - select count(1) as col_0_0_ from exam_info examinfo0_ where (examinfo0_.EXAM_NAME like ?) and examinfo0_.CREATE_ID=? and examinfo0_.DELETE_FLAG=0 2020-05-05 10:56:06.323 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [1] as [VARCHAR] - [%%] 2020-05-05 10:56:06.323 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [2] as [VARCHAR] - [40288a1261d106ba0161d1072e260000] 2020-05-05 10:56:06.332 DEBUG org.hibernate.SQL - select examinfo0_.EXAM_ID as EXAM_ID1_75_, examinfo0_.CREATE_ID as CREATE_I2_75_, examinfo0_.CREATE_TIME as CREATE_T3_75_, examinfo0_.CREATOR as CREATOR4_75_, examinfo0_.DELETE_FLAG as DELETE_F5_75_, examinfo0_.DURATION_MIN as DURATION6_75_, examinfo0_.EXAM_NAME as EXAM_NAM7_75_, examinfo0_.EXAM_STATUS as EXAM_STA8_75_, examinfo0_.EXAM_TYPE as EXAM_TYP9_75_, examinfo0_.MAX_LATE_MIN as MAX_LAT10_75_, examinfo0_.ORG_ID as ORG_ID11_75_, examinfo0_.PASSING_SCORE as PASSING12_75_, examinfo0_.SHOW_ANALYSE as SHOW_AN13_75_, examinfo0_.SHOW_CORRECT_ANSWER as SHOW_CO14_75_, examinfo0_.SHOW_SCORE as SHOW_SC15_75_, examinfo0_.SHOW_SCORE_TIME as SHOW_SC16_75_, examinfo0_.SHOW_TYPE as SHOW_TY17_75_, examinfo0_.SUBJECT_ID as SUBJECT18_75_, examinfo0_.TOTAL_SCORE as TOTAL_S19_75_, examinfo0_.UPDATE_ID as UPDATE_20_75_, examinfo0_.UPDATE_TIME as UPDATE_21_75_, examinfo0_.UPDATOR as UPDATOR22_75_ from exam_info examinfo0_ where (examinfo0_.EXAM_NAME like ?) and examinfo0_.CREATE_ID=? and examinfo0_.DELETE_FLAG=0 order by examinfo0_.CREATE_TIME desc limit ? 2020-05-05 10:56:06.333 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [1] as [VARCHAR] - [%%] 2020-05-05 10:56:06.333 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [2] as [VARCHAR] - [40288a1261d106ba0161d1072e260000] 2020-05-05 10:56:07.892 DEBUG org.hibernate.SQL - select count(1) as col_0_0_ from exercise_info exercisein0_ where (exercisein0_.name like ?) and exercisein0_.CREATE_ID=? and exercisein0_.DELETE_FLAG=0 2020-05-05 10:56:07.892 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [1] as [VARCHAR] - [%%] 2020-05-05 10:56:07.892 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [2] as [VARCHAR] - [40288a1261d106ba0161d1072e260000] 2020-05-05 10:56:07.906 DEBUG org.hibernate.SQL - select count(1) as col_0_0_ from exercise_info exercisein0_ where (exercisein0_.name like ?) and exercisein0_.CREATE_ID=? and exercisein0_.DELETE_FLAG=0 2020-05-05 10:56:07.906 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [1] as [VARCHAR] - [%%] 2020-05-05 10:56:07.906 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [2] as [VARCHAR] - [40288a1261d106ba0161d1072e260000] 2020-05-05 10:56:07.914 DEBUG org.hibernate.SQL - select exercisein0_.EXERCISE_INFO_ID as EXERCISE1_103_, exercisein0_.CLASS_COUNT as CLASS_CO2_103_, exercisein0_.COMMIT_UPLOAD_TYPE as COMMIT_U3_103_, exercisein0_.CREATE_ID as CREATE_I4_103_, exercisein0_.CREATE_TIME as CREATE_T5_103_, exercisein0_.creator as creator6_103_, exercisein0_.date as date7_103_, exercisein0_.DELETE_FLAG as DELETE_F8_103_, exercisein0_.end_time as end_time9_103_, exercisein0_.name as name10_103_, exercisein0_.org_id as org_id11_103_, exercisein0_.PASSING_SCORE as PASSING12_103_, exercisein0_.REMIND as REMIND13_103_, exercisein0_.score as score14_103_, exercisein0_.start_time as start_t15_103_, exercisein0_.status as status16_103_, exercisein0_.SUBJECT_ID as SUBJECT17_103_, exercisein0_.subject_id as subject17_103_, exercisein0_.type as type18_103_, exercisein0_.UPDATE_ID as UPDATE_19_103_, exercisein0_.UPDATE_TIME as UPDATE_20_103_, exercisein0_.updator as updator21_103_ from exercise_info exercisein0_ where (exercisein0_.name like ?) and exercisein0_.CREATE_ID=? and exercisein0_.DELETE_FLAG=0 order by exercisein0_.CREATE_TIME desc limit ? 2020-05-05 10:56:07.915 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [1] as [VARCHAR] - [%%] 2020-05-05 10:56:07.915 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [2] as [VARCHAR] - [40288a1261d106ba0161d1072e260000] 2020-05-05 10:56:09.795 DEBUG org.hibernate.SQL - select count(schevaluat0_.EVALUATE_ID) as col_0_0_ from sch_evaluate schevaluat0_ cross join sch_evaluate_template schevaluat1_ cross join exercise_group exercisegr2_ cross join SUBJECT subject3_ where 1=1 and schevaluat0_.EVALUATE_TEMPLATE_ID=schevaluat1_.EVALUATE_TEMPLATE_ID and schevaluat1_.GROUP_ID=exercisegr2_.GROUP_ID and schevaluat0_.EVALUATE_RANGE_ID=subject3_.SUBJECT_ID and schevaluat0_.CREATE_ID=? and schevaluat0_.DELETE_FLAG=? 2020-05-05 10:56:09.796 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [1] as [VARCHAR] - [40288a1261d106ba0161d1072e260000] 2020-05-05 10:56:09.796 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [2] as [BOOLEAN] - [false] 2020-05-05 10:56:11.318 DEBUG org.hibernate.SQL - select mediavideo0_.VIDEO_LIVE_ID as VIDEO_LI1_11_, mediavideo0_.ANCHOR as ANCHOR2_11_, mediavideo0_.ANCHOR_ID as ANCHOR_I3_11_, mediavideo0_.ATTRIBUTE as ATTRIBUT4_11_, mediavideo0_.COMPLETE_FLAG as COMPLETE5_11_, mediavideo0_.CONSULT_IMG_URL as CONSULT_6_11_, mediavideo0_.CREATE_ID as CREATE_I7_11_, mediavideo0_.CREATE_TIME as CREATE_T8_11_, mediavideo0_.CREATOR as CREATOR9_11_, mediavideo0_.DEFINITION as DEFINIT10_11_, mediavideo0_.DELETE_FLAG as DELETE_11_11_, mediavideo0_.EDIT_REPLAY_FLAG as EDIT_RE12_11_, mediavideo0_.END_TIME as END_TIM13_11_, mediavideo0_.EXPECTED_TIMES as EXPECTE14_11_, mediavideo0_.WY_HLS_PULL_URL as WY_HLS_15_11_, mediavideo0_.WY_HTTP_PULL_URL as WY_HTTP16_11_, mediavideo0_.LAST_RECORD_TIME as LAST_RE17_11_, mediavideo0_.TQ_MEETING_ID as TQ_MEET18_11_, mediavideo0_.TQ_MEETING_PWD as TQ_MEET19_11_, mediavideo0_.NAME as NAME20_11_, mediavideo0_.ON_TIME_FLAG as ON_TIME21_11_, mediavideo0_.ORDER_TIMES as ORDER_T22_11_, mediavideo0_.PERMISSION as PERMISS23_11_, mediavideo0_.PLAY_TIMES as PLAY_TI24_11_, mediavideo0_.PRAISE_TIMES as PRAISE_25_11_, mediavideo0_.PREVIEW_IMG_URL as PREVIEW26_11_, mediavideo0_.PREVIEW_VIDEO_URL as PREVIEW27_11_, mediavideo0_.WY_PUSH_URL as WY_PUSH28_11_, mediavideo0_.REMARK as REMARK29_11_, mediavideo0_.REVIEW_TIMES as REVIEW_30_11_, mediavideo0_.WY_RTMP_PULL_URL as WY_RTMP31_11_, mediavideo0_.SHARE_TIMES as SHARE_T32_11_, mediavideo0_.START_TIME as START_T33_11_, mediavideo0_.STATUS as STATUS34_11_, mediavideo0_.SUBJECT_ID as SUBJECT35_11_, mediavideo0_.SUBJECT_NAME as SUBJECT36_11_, mediavideo0_.TECENT_LIVE_NUMBER as TECENT_37_11_, mediavideo0_.UPDATE_ID as UPDATE_38_11_, mediavideo0_.UPDATE_TIME as UPDATE_39_11_, mediavideo0_.UPDATOR as UPDATOR40_11_, mediavideo0_.WATCH_MAX_TIMES as WATCH_M41_11_, mediavideo0_.WATCH_TIMES as WATCH_T42_11_, mediavideo0_.WATCHER_LIMIT as WATCHER43_11_, mediavideo0_.WY_LIVE_NUMBER as WY_LIVE44_11_ from MEDIA_VIDEO_LIVE mediavideo0_ where mediavideo0_.DELETE_FLAG=0 and (mediavideo0_.NAME like ?) and mediavideo0_.CREATE_ID=? order by mediavideo0_.CREATE_TIME desc limit ? 2020-05-05 10:56:11.318 DEBUG org.hibernate.SQL - select subject0_.SUBJECT_ID as col_0_0_, subject0_.NAME as col_1_0_ from SUBJECT subject0_ where subject0_.DELETE_FLAG=0 and subject0_.TYPE=1 and subject0_.ORG_ID='1' limit ? 2020-05-05 10:56:11.352 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [1] as [VARCHAR] - [%] 2020-05-05 10:56:11.352 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [2] as [VARCHAR] - [40288a1261d106ba0161d1072e260000] 2020-05-05 10:56:11.367 DEBUG org.hibernate.SQL - select count(1) as col_0_0_ from MEDIA_VIDEO_LIVE mediavideo0_ where mediavideo0_.DELETE_FLAG=0 and (mediavideo0_.NAME like ?) and mediavideo0_.CREATE_ID=? order by mediavideo0_.CREATE_TIME desc 2020-05-05 10:56:11.369 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [1] as [VARCHAR] - [%] 2020-05-05 10:56:11.369 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [2] as [VARCHAR] - [40288a1261d106ba0161d1072e260000] 2020-05-05 10:56:11.370 DEBUG org.hibernate.SQL - select count(1) as col_0_0_ from MEDIA_VIDEO_LIVE mediavideo0_ where mediavideo0_.DELETE_FLAG=0 and (mediavideo0_.NAME like ?) and mediavideo0_.CREATE_ID=? order by mediavideo0_.CREATE_TIME desc 2020-05-05 10:56:11.370 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [1] as [VARCHAR] - [%] 2020-05-05 10:56:11.370 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [2] as [VARCHAR] - [40288a1261d106ba0161d1072e260000] 2020-05-05 10:56:11.498 DEBUG org.hibernate.SQL - select min(userrole0_.type) as col_0_0_ from user_role userrole0_ cross join user_re_role_user userrerole1_ where userrole0_.DELETE_FLAG=0 and userrerole1_.DELETE_FLAG=0 and userrerole1_.USER_ID=? and userrole0_.ROLE_ID=userrerole1_.ROLE_ID limit ? 2020-05-05 10:56:11.498 DEBUG org.hibernate.SQL - select min(userrole0_.type) as col_0_0_ from user_role userrole0_ cross join user_re_role_user userrerole1_ where userrole0_.DELETE_FLAG=0 and userrerole1_.DELETE_FLAG=0 and userrerole1_.USER_ID=? and userrole0_.ROLE_ID=userrerole1_.ROLE_ID limit ? 2020-05-05 10:56:11.501 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [1] as [VARCHAR] - [40288a1261d106ba0161d1072e260000] 2020-05-05 10:56:11.501 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [1] as [VARCHAR] - [40288a1261d106ba0161d1072e260000] 2020-05-05 10:56:11.516 DEBUG org.hibernate.SQL - select clsclass0_.NAME as col_0_0_, clsclass0_.TEACHER_ID as col_1_0_, clsclass0_.CLASS_ID as col_2_0_, clsclass0_.CLASS_NUMBER as col_3_0_ from cls_class clsclass0_ where clsclass0_.DELETE_FLAG=0 limit ? 2020-05-05 10:56:11.531 DEBUG org.hibernate.SQL - select min(userrole0_.type) as col_0_0_ from user_role userrole0_ cross join user_re_role_user userrerole1_ where userrole0_.DELETE_FLAG=0 and userrerole1_.DELETE_FLAG=0 and userrerole1_.USER_ID=? and userrole0_.ROLE_ID=userrerole1_.ROLE_ID limit ? 2020-05-05 10:56:11.532 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [1] as [VARCHAR] - [40288a1261d106ba0161d1072e260000] 2020-05-05 10:56:11.547 DEBUG org.hibernate.SQL - select count(1) as col_0_0_ from cls_class clsclass0_ where clsclass0_.DELETE_FLAG=0 2020-05-05 10:56:11.549 DEBUG org.hibernate.SQL - select count(1) as col_0_0_ from cls_class clsclass0_ where clsclass0_.DELETE_FLAG=0 2020-05-05 10:56:11.559 DEBUG org.hibernate.SQL - select distinct topicinfo0_.TOPIC_ID as col_0_0_ from topic_info topicinfo0_ cross join topic_class_re topicclass1_ cross join sns_comment_object commentobj2_ cross join cls_class clsclass3_ where topicinfo0_.DELETE_FLAG=0 and topicclass1_.DELETE_FLAG=0 and commentobj2_.DELETE_FLAG=0 and topicclass1_.TOPIC_ID=topicinfo0_.TOPIC_ID and topicinfo0_.TOPIC_ID=commentobj2_.COMMENT_OBJECT_UID and (topicinfo0_.TOPIC_NAME like ?) and commentobj2_.COMMENT_OBJECT_TYPE=5 and topicclass1_.CLASS_ID=clsclass3_.CLASS_ID and clsclass3_.DELETE_FLAG=0 and topicinfo0_.TOPIC_ID=topicinfo0_.TOPIC_ID limit ? 2020-05-05 10:56:11.559 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [1] as [VARCHAR] - [%%] 2020-05-05 10:56:11.567 DEBUG org.hibernate.SQL - select count(1) as col_0_0_ from exam_info examinfo0_ where (examinfo0_.EXAM_NAME like ?) and examinfo0_.CREATE_ID=? and examinfo0_.DELETE_FLAG=0 2020-05-05 10:56:11.567 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [1] as [VARCHAR] - [%%] 2020-05-05 10:56:11.568 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [2] as [VARCHAR] - [40288a1261d106ba0161d1072e260000] 2020-05-05 10:56:11.569 DEBUG org.hibernate.SQL - select count(1) as col_0_0_ from exam_info examinfo0_ where (examinfo0_.EXAM_NAME like ?) and examinfo0_.CREATE_ID=? and examinfo0_.DELETE_FLAG=0 2020-05-05 10:56:11.569 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [1] as [VARCHAR] - [%%] 2020-05-05 10:56:11.570 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [2] as [VARCHAR] - [40288a1261d106ba0161d1072e260000] 2020-05-05 10:56:11.574 DEBUG org.hibernate.SQL - select examinfo0_.EXAM_ID as EXAM_ID1_75_, examinfo0_.CREATE_ID as CREATE_I2_75_, examinfo0_.CREATE_TIME as CREATE_T3_75_, examinfo0_.CREATOR as CREATOR4_75_, examinfo0_.DELETE_FLAG as DELETE_F5_75_, examinfo0_.DURATION_MIN as DURATION6_75_, examinfo0_.EXAM_NAME as EXAM_NAM7_75_, examinfo0_.EXAM_STATUS as EXAM_STA8_75_, examinfo0_.EXAM_TYPE as EXAM_TYP9_75_, examinfo0_.MAX_LATE_MIN as MAX_LAT10_75_, examinfo0_.ORG_ID as ORG_ID11_75_, examinfo0_.PASSING_SCORE as PASSING12_75_, examinfo0_.SHOW_ANALYSE as SHOW_AN13_75_, examinfo0_.SHOW_CORRECT_ANSWER as SHOW_CO14_75_, examinfo0_.SHOW_SCORE as SHOW_SC15_75_, examinfo0_.SHOW_SCORE_TIME as SHOW_SC16_75_, examinfo0_.SHOW_TYPE as SHOW_TY17_75_, examinfo0_.SUBJECT_ID as SUBJECT18_75_, examinfo0_.TOTAL_SCORE as TOTAL_S19_75_, examinfo0_.UPDATE_ID as UPDATE_20_75_, examinfo0_.UPDATE_TIME as UPDATE_21_75_, examinfo0_.UPDATOR as UPDATOR22_75_ from exam_info examinfo0_ where (examinfo0_.EXAM_NAME like ?) and examinfo0_.CREATE_ID=? and examinfo0_.DELETE_FLAG=0 order by examinfo0_.CREATE_TIME desc limit ? 2020-05-05 10:56:11.574 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [1] as [VARCHAR] - [%%] 2020-05-05 10:56:11.575 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [2] as [VARCHAR] - [40288a1261d106ba0161d1072e260000] 2020-05-05 10:56:11.575 DEBUG org.hibernate.SQL - select count(1) as col_0_0_ from exam_batch_info exambatchi0_ where exambatchi0_.EXAM_ID=? and exambatchi0_.DELETE_FLAG=0 2020-05-05 10:56:11.576 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [1] as [VARCHAR] - [] 2020-05-05 10:56:11.579 DEBUG org.hibernate.SQL - select count(1) as col_0_0_ from exam_batch_info exambatchi0_ where exambatchi0_.EXAM_ID=? and exambatchi0_.DELETE_FLAG=0 2020-05-05 10:56:11.579 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [1] as [VARCHAR] - [] 2020-05-05 10:56:11.584 DEBUG org.hibernate.SQL - select exambatchi0_.EXAM_BATCH_ID as EXAM_BAT1_73_, exambatchi0_.BATCH_STATUS as BATCH_ST2_73_, exambatchi0_.CREATE_ID as CREATE_I3_73_, exambatchi0_.CREATE_TIME as CREATE_T4_73_, exambatchi0_.CREATOR as CREATOR5_73_, exambatchi0_.DELETE_FLAG as DELETE_F6_73_, exambatchi0_.END_TIME as END_TIME7_73_, exambatchi0_.EXAM_BATCH_NO as EXAM_BAT8_73_, exambatchi0_.EXAM_ID as EXAM_ID9_73_, exambatchi0_.START_TIME as START_T10_73_, exambatchi0_.UPDATE_ID as UPDATE_11_73_, exambatchi0_.UPDATE_TIME as UPDATE_12_73_, exambatchi0_.UPDATOR as UPDATOR13_73_ from exam_batch_info exambatchi0_ where exambatchi0_.EXAM_ID=? and exambatchi0_.DELETE_FLAG=0 order by exambatchi0_.CREATE_TIME DESC limit ? 2020-05-05 10:56:11.585 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [1] as [VARCHAR] - [] 2020-05-05 10:56:11.603 DEBUG org.hibernate.SQL - select distinct topicinfo0_.TOPIC_ID as col_0_0_, topicinfo0_.TOPIC_NAME as col_1_0_, topicinfo0_.TOPIC_STATUS as col_2_0_, topicinfo0_.CREATOR as col_3_0_, topicinfo0_.CREATE_ID as col_4_0_, topicinfo0_.START_TIME as col_5_0_, topicinfo0_.END_TIME as col_6_0_, topicinfo0_.CLASS_ID as col_7_0_, topicinfo0_.LATEST_COMMENT_NAME as col_8_0_, topicinfo0_.LATEST_COMMENT_TIME as col_9_0_, commentobj2_.VIEW_COUNT as col_10_0_, commentobj2_.COMMENT_COUNT as col_11_0_ from topic_info topicinfo0_ cross join topic_class_re topicclass1_ cross join sns_comment_object commentobj2_ cross join cls_class clsclass3_ where topicinfo0_.DELETE_FLAG=0 and topicclass1_.DELETE_FLAG=0 and commentobj2_.DELETE_FLAG=0 and topicclass1_.TOPIC_ID=topicinfo0_.TOPIC_ID and topicinfo0_.TOPIC_ID=commentobj2_.COMMENT_OBJECT_UID and (topicinfo0_.TOPIC_NAME like ?) and commentobj2_.COMMENT_OBJECT_TYPE=5 and topicclass1_.CLASS_ID=clsclass3_.CLASS_ID and clsclass3_.DELETE_FLAG=0 and topicinfo0_.TOPIC_ID=topicinfo0_.TOPIC_ID order by topicinfo0_.CREATE_TIME desc limit ? 2020-05-05 10:56:11.604 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [1] as [VARCHAR] - [%%] 2020-05-05 10:56:12.542 DEBUG org.hibernate.SQL - select sysmenu0_.MENU_ID as col_0_0_, sysmenu0_.NAME as col_1_0_, '1' as col_2_0_ from sys_menu sysmenu0_ where sysmenu0_.DELETE_FLAG=0 limit ? 2020-05-05 10:56:12.542 DEBUG org.hibernate.SQL - select userrole0_.ROLE_ID as ROLE_ID1_242_, userrole0_.CREATE_ID as CREATE_I2_242_, userrole0_.CREATE_TIME as CREATE_T3_242_, userrole0_.CREATOR as CREATOR4_242_, userrole0_.DELETE_FLAG as DELETE_F5_242_, userrole0_.NAME as NAME6_242_, userrole0_.TOP_ORG_ID as TOP_ORG_7_242_, userrole0_.type as type8_242_, userrole0_.UPDATE_ID as UPDATE_I9_242_, userrole0_.UPDATE_TIME as UPDATE_10_242_, userrole0_.UPDATOR as UPDATOR11_242_ from user_role userrole0_ where userrole0_.DELETE_FLAG=0 and (userrole0_.NAME like ?) and userrole0_.TOP_ORG_ID=? limit ? 2020-05-05 10:56:12.542 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [1] as [VARCHAR] - [%%] 2020-05-05 10:56:12.542 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [2] as [VARCHAR] - [1] 2020-05-05 10:56:12.600 DEBUG org.hibernate.SQL - select sysmenu2_.NAME as col_0_0_, sysmenu2_.MENU_ID as col_1_0_, '1' as col_2_0_ from user_role userrole0_ cross join sys_privilege sysprivile1_ cross join sys_menu sysmenu2_ where userrole0_.ROLE_ID=sysprivile1_.ROLE_ID and sysprivile1_.MENU_ID=sysmenu2_.MENU_ID and userrole0_.ROLE_ID=? and userrole0_.DELETE_FLAG=0 and sysprivile1_.DELETE_FLAG=0 limit ? 2020-05-05 10:56:12.600 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [1] as [VARCHAR] - [2] 2020-05-05 10:56:12.610 DEBUG org.hibernate.SQL - select userrole0_.ROLE_ID as ROLE_ID1_242_0_, userrole0_.CREATE_ID as CREATE_I2_242_0_, userrole0_.CREATE_TIME as CREATE_T3_242_0_, userrole0_.CREATOR as CREATOR4_242_0_, userrole0_.DELETE_FLAG as DELETE_F5_242_0_, userrole0_.NAME as NAME6_242_0_, userrole0_.TOP_ORG_ID as TOP_ORG_7_242_0_, userrole0_.type as type8_242_0_, userrole0_.UPDATE_ID as UPDATE_I9_242_0_, userrole0_.UPDATE_TIME as UPDATE_10_242_0_, userrole0_.UPDATOR as UPDATOR11_242_0_ from user_role userrole0_ where userrole0_.ROLE_ID=? 2020-05-05 10:56:12.610 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [1] as [VARCHAR] - [2] 2020-05-05 10:56:12.646 DEBUG org.hibernate.SQL - select user0_.NAME as col_0_0_, user0_.USER_ID as col_1_0_, user0_.ACCOUNT as col_2_0_, user0_.MOBILE_PHONE as col_3_0_, user0_.PASSWORD as col_4_0_ from user user0_ cross join user_re_role_user userrerole1_ where user0_.DELETE_FLAG=0 and userrerole1_.DELETE_FLAG=0 and user0_.USER_ID=userrerole1_.USER_ID and userrerole1_.ROLE_ID=? and (user0_.NAME like ?) and user0_.ORGANIZATION_ID=? limit ? 2020-05-05 10:56:12.647 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [1] as [VARCHAR] - [2] 2020-05-05 10:56:12.647 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [2] as [VARCHAR] - [%%] 2020-05-05 10:56:12.647 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [3] as [VARCHAR] - [1] 2020-05-05 10:56:12.662 DEBUG org.hibernate.SQL - select count(1) as col_0_0_ from user user0_ cross join user_re_role_user userrerole1_ where user0_.DELETE_FLAG=0 and userrerole1_.DELETE_FLAG=0 and user0_.USER_ID=userrerole1_.USER_ID and userrerole1_.ROLE_ID=? and (user0_.NAME like ?) and user0_.ORGANIZATION_ID=? 2020-05-05 10:56:12.662 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [1] as [VARCHAR] - [2] 2020-05-05 10:56:12.662 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [2] as [VARCHAR] - [%%] 2020-05-05 10:56:12.662 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [3] as [VARCHAR] - [1] 2020-05-05 10:56:12.675 DEBUG org.hibernate.SQL - select count(1) as col_0_0_ from user user0_ cross join user_re_role_user userrerole1_ where user0_.DELETE_FLAG=0 and userrerole1_.DELETE_FLAG=0 and user0_.USER_ID=userrerole1_.USER_ID and userrerole1_.ROLE_ID=? and (user0_.NAME like ?) and user0_.ORGANIZATION_ID=? 2020-05-05 10:56:12.675 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [1] as [VARCHAR] - [2] 2020-05-05 10:56:12.675 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [2] as [VARCHAR] - [%%] 2020-05-05 10:56:12.675 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [3] as [VARCHAR] - [1] 2020-05-05 10:56:13.616 DEBUG org.hibernate.SQL - select count(1) as col_0_0_ from course_schedule_detail coursesche0_ left outer join course_schedule coursesche1_ on coursesche0_.SCHEDULE_ID=coursesche1_.SCHEDULE_ID where coursesche0_.DELETE_FLAG=0 and coursesche0_.BEGIN_TIME>=? and coursesche0_.END_TIME<=? and coursesche1_.status=? and coursesche1_.DELETE_FLAG=0 and coursesche0_.DELETE_FLAG=0 2020-05-05 10:56:13.616 DEBUG org.hibernate.SQL - select day(coursesche0_.BEGIN_TIME) as col_0_0_ from course_schedule_detail coursesche0_ left outer join course_schedule coursesche1_ on coursesche0_.SCHEDULE_ID=coursesche1_.SCHEDULE_ID where coursesche0_.DELETE_FLAG=0 and coursesche0_.BEGIN_TIME>=? and coursesche0_.END_TIME<=? and coursesche1_.status=? and coursesche1_.DELETE_FLAG=0 group by day(coursesche0_.BEGIN_TIME) limit ? 2020-05-05 10:56:13.616 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [1] as [TIMESTAMP] - [Tue May 05 00:00:00 CST 2020] 2020-05-05 10:56:13.616 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [1] as [TIMESTAMP] - [Fri May 01 00:00:00 CST 2020] 2020-05-05 10:56:13.616 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [2] as [TIMESTAMP] - [Tue May 05 23:59:59 CST 2020] 2020-05-05 10:56:13.616 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [2] as [TIMESTAMP] - [Sun May 31 23:59:59 CST 2020] 2020-05-05 10:56:13.616 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [3] as [SMALLINT] - [1] 2020-05-05 10:56:13.616 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [3] as [SMALLINT] - [1] 2020-05-05 10:56:13.626 DEBUG org.hibernate.SQL - select count(1) as col_0_0_ from course_schedule_detail coursesche0_ left outer join course_schedule coursesche1_ on coursesche0_.SCHEDULE_ID=coursesche1_.SCHEDULE_ID where coursesche0_.DELETE_FLAG=0 and coursesche0_.BEGIN_TIME>=? and coursesche0_.END_TIME<=? and coursesche1_.status=? and coursesche1_.DELETE_FLAG=0 and coursesche0_.DELETE_FLAG=0 2020-05-05 10:56:13.626 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [1] as [TIMESTAMP] - [Tue May 05 00:00:00 CST 2020] 2020-05-05 10:56:13.626 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [2] as [TIMESTAMP] - [Tue May 05 23:59:59 CST 2020] 2020-05-05 10:56:13.626 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [3] as [SMALLINT] - [1] 2020-05-05 10:56:13.642 DEBUG org.hibernate.SQL - select coursesche0_.DETAIL_ID as DETAIL_I1_69_0_, coursesche1_.SCHEDULE_ID as SCHEDULE1_68_1_, subject2_.SUBJECT_ID as SUBJECT_1_54_2_, classroom3_.ROOM_ID as ROOM_ID1_63_3_, clsclass5_.CLASS_ID as CLASS_ID1_64_4_, coursesche0_.BEGIN_TIME as BEGIN_TI2_69_0_, coursesche0_.SCHEDULE_ID as SCHEDULE8_69_0_, coursesche0_.CREATE_ID as CREATE_I3_69_0_, coursesche0_.CREATE_TIME as CREATE_T4_69_0_, coursesche0_.CREATOR as CREATOR5_69_0_, coursesche0_.DELETE_FLAG as DELETE_F6_69_0_, coursesche0_.END_TIME as END_TIME7_69_0_, coursesche0_.UPDATE_ID as UPDATE_I9_69_0_, coursesche0_.UPDATE_TIME as UPDATE_10_69_0_, coursesche0_.UPDATOR as UPDATOR11_69_0_, coursesche1_.BEGIN_TIME as BEGIN_TI2_68_1_, coursesche1_.ROOM_ID as ROOM_ID13_68_1_, coursesche1_.CREATE_ID as CREATE_I3_68_1_, coursesche1_.CREATE_TIME as CREATE_T4_68_1_, coursesche1_.CREATOR as CREATOR5_68_1_, coursesche1_.DELETE_FLAG as DELETE_F6_68_1_, coursesche1_.END_TIME as END_TIME7_68_1_, coursesche1_.FRI_TIME as FRI_TIME8_68_1_, coursesche1_.mark as mark9_68_1_, coursesche1_.MON_TIME as MON_TIM10_68_1_, coursesche1_.OPEN_FLAG as OPEN_FL11_68_1_, coursesche1_.ORG_ID as ORG_ID12_68_1_, coursesche1_.SAT_TIME as SAT_TIM14_68_1_, coursesche1_.status as status15_68_1_, coursesche1_.SUBJECT_ID as SUBJECT16_68_1_, coursesche1_.SUM_TIME as SUM_TIM17_68_1_, coursesche1_.TEACHER_ID as TEACHER18_68_1_, coursesche1_.TEACHER_NAME as TEACHER19_68_1_, coursesche1_.THU_TIME as THU_TIM20_68_1_, coursesche1_.TUE_TIME as TUE_TIM21_68_1_, coursesche1_.type as type22_68_1_, coursesche1_.UPDATE_ID as UPDATE_23_68_1_, coursesche1_.UPDATE_TIME as UPDATE_24_68_1_, coursesche1_.UPDATOR as UPDATOR25_68_1_, coursesche1_.WED_TIME as WED_TIM26_68_1_, subject2_.CODE as CODE2_54_2_, subject2_.CONTENT_FILE_ID as CONTENT_3_54_2_, subject2_.COURSE_ID as COURSE_I4_54_2_, subject2_.COVER_PAGE_FILE_ID as COVER_PA5_54_2_, subject2_.COVER_PAGE_URL as COVER_PA6_54_2_, subject2_.CREATE_ID as CREATE_I7_54_2_, subject2_.CREATE_TIME as CREATE_T8_54_2_, subject2_.CREATOR as CREATOR9_54_2_, subject2_.DELETE_FLAG as DELETE_10_54_2_, subject2_.FULL_NAME as FULL_NA11_54_2_, subject2_.LECTURE_COUNT as LECTURE12_54_2_, subject2_.NAME as NAME13_54_2_, subject2_.ORDER_NUM as ORDER_N14_54_2_, subject2_.ORG_ID as ORG_ID15_54_2_, subject2_.ORIG_COPY_SUBJECT_ID as ORIG_CO16_54_2_, subject2_.ORIG_SUBJECT_ID as ORIG_SU17_54_2_, subject2_.SCHOOL_YEAR as SCHOOL_18_54_2_, subject2_.STATUS as STATUS19_54_2_, subject2_.TEACHER_ID as TEACHER20_54_2_, subject2_.TEACHER_NAME as TEACHER21_54_2_, subject2_.TERM as TERM22_54_2_, subject2_.TYPE as TYPE23_54_2_, subject2_.UPDATE_ID as UPDATE_24_54_2_, subject2_.UPDATE_TIME as UPDATE_25_54_2_, subject2_.UPDATOR as UPDATOR26_54_2_, classroom3_.address as address2_63_3_, classroom3_.CREATE_ID as CREATE_I3_63_3_, classroom3_.CREATE_TIME as CREATE_T4_63_3_, classroom3_.CREATOR as CREATOR5_63_3_, classroom3_.DELETE_FLAG as DELETE_F6_63_3_, classroom3_.name as name7_63_3_, classroom3_.ORG_ID as ORG_ID8_63_3_, classroom3_.status as status9_63_3_, classroom3_.UPDATE_ID as UPDATE_10_63_3_, classroom3_.UPDATE_TIME as UPDATE_11_63_3_, classroom3_.UPDATOR as UPDATOR12_63_3_, clsclass5_.ADDRESS as ADDRESS2_64_4_, clsclass5_.ADDRESS_ID as ADDRESS_3_64_4_, clsclass5_.ADVANTAGE as ADVANTAG4_64_4_, clsclass5_.ARRANGEMENT as ARRANGEM5_64_4_, clsclass5_.CAN_MULTI_EXER as CAN_MULT6_64_4_, clsclass5_.CITY as CITY7_64_4_, clsclass5_.CLASS_CHARGER as CLASS_CH8_64_4_, clsclass5_.CLASS_CHARGER_ID as CLASS_CH9_64_4_, clsclass5_.CLASS_NUMBER as CLASS_N10_64_4_, clsclass5_.CLASS_TYPES as CLASS_T11_64_4_, clsclass5_.CLICK_NUM as CLICK_N12_64_4_, clsclass5_.CODE as CODE13_64_4_, clsclass5_.COLLEGE_COURSE_ID as COLLEGE14_64_4_, clsclass5_.COLLEGE_COURSE_NAME as COLLEGE15_64_4_, clsclass5_.COMMENT_COUNT as COMMENT16_64_4_, clsclass5_.COURSE_ID as COURSE_17_64_4_, clsclass5_.CREATE_ID as CREATE_18_64_4_, clsclass5_.CREATE_TIME as CREATE_19_64_4_, clsclass5_.CREATOR as CREATOR20_64_4_, clsclass5_.DELETE_FLAG as DELETE_21_64_4_, clsclass5_.DISCOUNT as DISCOUN22_64_4_, clsclass5_.DISPRICE as DISPRIC23_64_4_, clsclass5_.END_TIME as END_TIM24_64_4_, clsclass5_.EXTENDED as EXTENDE25_64_4_, clsclass5_.FULL_TEXT as FULL_TE26_64_4_, clsclass5_.GOOD_ID as GOOD_ID27_64_4_, clsclass5_.HAVA_AWARD as HAVA_AW28_64_4_, clsclass5_.HAVE_HANDOUT as HAVE_HA29_64_4_, clsclass5_.HAVE_LIVE as HAVE_LI30_64_4_, clsclass5_.HAVE_VIDEO as HAVE_VI31_64_4_, clsclass5_.IMG_PATH as IMG_PAT32_64_4_, clsclass5_.LATITUDE_Y as LATITUD33_64_4_, clsclass5_.LONGITUDE_X as LONGITU34_64_4_, clsclass5_.MODE as MODE35_64_4_, clsclass5_.NAME as NAME36_64_4_, clsclass5_.NEED_FORUM as NEED_FO37_64_4_, clsclass5_.NEED_JOIN_AUDIT as NEED_JO38_64_4_, clsclass5_.NEED_QUIT_AUDIT as NEED_QU39_64_4_, clsclass5_.ORG_ID as ORG_ID40_64_4_, clsclass5_.PAYMENT_NUM as PAYMENT41_64_4_, clsclass5_.POINTER as POINTER42_64_4_, clsclass5_.PRICE as PRICE43_64_4_, clsclass5_.PRODUCT_ID as PRODUCT44_64_4_, clsclass5_.PROGRESS as PROGRES45_64_4_, clsclass5_.PROVINCE as PROVINC46_64_4_, clsclass5_.RECOMMEND as RECOMME47_64_4_, clsclass5_.REGION as REGION48_64_4_, clsclass5_.SCORE as SCORE49_64_4_, clsclass5_.SHOU_ANALYSIS_AFTER_EXER as SHOU_AN50_64_4_, clsclass5_.START_TIME as START_T51_64_4_, clsclass5_.STU_ALL_COUNT as STU_ALL52_64_4_, clsclass5_.STUDENT_COUNT as STUDENT53_64_4_, clsclass5_.STUDY_TIME as STUDY_T54_64_4_, clsclass5_.TEACHER_ID as TEACHER55_64_4_, clsclass5_.TOP_FLAG as TOP_FLA56_64_4_, clsclass5_.UPDATE_ID as UPDATE_57_64_4_, clsclass5_.UPDATE_TIME as UPDATE_58_64_4_, clsclass5_.UPDATOR as UPDATOR59_64_4_, classes4_.SCHEDULE_ID as SCHEDULE1_68_0__, classes4_.CLASS_ID as CLASS_ID2_1_0__, classes4_.RE_ID as RE_ID3_0__ from course_schedule_detail coursesche0_ left outer join course_schedule coursesche1_ on coursesche0_.SCHEDULE_ID=coursesche1_.SCHEDULE_ID left outer join SUBJECT subject2_ on coursesche1_.SUBJECT_ID=subject2_.SUBJECT_ID left outer join class_room classroom3_ on coursesche1_.ROOM_ID=classroom3_.ROOM_ID left outer join COURSE_SCHEDULE_RE_CLS classes4_ on coursesche1_.SCHEDULE_ID=classes4_.SCHEDULE_ID left outer join cls_class clsclass5_ on classes4_.CLASS_ID=clsclass5_.CLASS_ID and ( clsclass5_.DELETE_FLAG=0) where coursesche0_.DELETE_FLAG=0 and coursesche0_.BEGIN_TIME>=? and coursesche0_.END_TIME<=? and coursesche1_.status=? and coursesche1_.DELETE_FLAG=0 and coursesche0_.DELETE_FLAG=0 order by coursesche0_.BEGIN_TIME asc 2020-05-05 10:56:13.643 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [1] as [TIMESTAMP] - [Tue May 05 00:00:00 CST 2020] 2020-05-05 10:56:13.643 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [2] as [TIMESTAMP] - [Tue May 05 23:59:59 CST 2020] 2020-05-05 10:56:13.643 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [3] as [SMALLINT] - [1] 2020-05-05 10:56:14.443 DEBUG org.hibernate.SQL - select count(1) as col_0_0_ from class_room classroom0_ where (classroom0_.name like ?) and classroom0_.CREATE_ID=? and classroom0_.DELETE_FLAG=0 2020-05-05 10:56:14.444 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [1] as [VARCHAR] - [%%] 2020-05-05 10:56:14.444 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [2] as [VARCHAR] - [40288a1261d106ba0161d1072e260000] 2020-05-05 10:56:14.445 DEBUG org.hibernate.SQL - select count(1) as col_0_0_ from class_room classroom0_ where (classroom0_.name like ?) and classroom0_.CREATE_ID=? and classroom0_.DELETE_FLAG=0 2020-05-05 10:56:14.446 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [1] as [VARCHAR] - [%%] 2020-05-05 10:56:14.446 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [2] as [VARCHAR] - [40288a1261d106ba0161d1072e260000] 2020-05-05 10:56:14.448 DEBUG org.hibernate.SQL - select classroom0_.ROOM_ID as ROOM_ID1_63_, classroom0_.address as address2_63_, classroom0_.CREATE_ID as CREATE_I3_63_, classroom0_.CREATE_TIME as CREATE_T4_63_, classroom0_.CREATOR as CREATOR5_63_, classroom0_.DELETE_FLAG as DELETE_F6_63_, classroom0_.name as name7_63_, classroom0_.ORG_ID as ORG_ID8_63_, classroom0_.status as status9_63_, classroom0_.UPDATE_ID as UPDATE_10_63_, classroom0_.UPDATE_TIME as UPDATE_11_63_, classroom0_.UPDATOR as UPDATOR12_63_ from class_room classroom0_ where (classroom0_.name like ?) and classroom0_.CREATE_ID=? and classroom0_.DELETE_FLAG=0 order by classroom0_.CREATE_TIME desc limit ? 2020-05-05 10:56:14.449 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [1] as [VARCHAR] - [%%] 2020-05-05 10:56:14.449 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [2] as [VARCHAR] - [40288a1261d106ba0161d1072e260000] 2020-05-05 11:00:00.012 DEBUG org.hibernate.SQL - select mediavideo0_.VIDEO_LIVE_ID as VIDEO_LI1_11_, mediavideo0_.ANCHOR as ANCHOR2_11_, mediavideo0_.ANCHOR_ID as ANCHOR_I3_11_, mediavideo0_.ATTRIBUTE as ATTRIBUT4_11_, mediavideo0_.COMPLETE_FLAG as COMPLETE5_11_, mediavideo0_.CONSULT_IMG_URL as CONSULT_6_11_, mediavideo0_.CREATE_ID as CREATE_I7_11_, mediavideo0_.CREATE_TIME as CREATE_T8_11_, mediavideo0_.CREATOR as CREATOR9_11_, mediavideo0_.DEFINITION as DEFINIT10_11_, mediavideo0_.DELETE_FLAG as DELETE_11_11_, mediavideo0_.EDIT_REPLAY_FLAG as EDIT_RE12_11_, mediavideo0_.END_TIME as END_TIM13_11_, mediavideo0_.EXPECTED_TIMES as EXPECTE14_11_, mediavideo0_.WY_HLS_PULL_URL as WY_HLS_15_11_, mediavideo0_.WY_HTTP_PULL_URL as WY_HTTP16_11_, mediavideo0_.LAST_RECORD_TIME as LAST_RE17_11_, mediavideo0_.TQ_MEETING_ID as TQ_MEET18_11_, mediavideo0_.TQ_MEETING_PWD as TQ_MEET19_11_, mediavideo0_.NAME as NAME20_11_, mediavideo0_.ON_TIME_FLAG as ON_TIME21_11_, mediavideo0_.ORDER_TIMES as ORDER_T22_11_, mediavideo0_.PERMISSION as PERMISS23_11_, mediavideo0_.PLAY_TIMES as PLAY_TI24_11_, mediavideo0_.PRAISE_TIMES as PRAISE_25_11_, mediavideo0_.PREVIEW_IMG_URL as PREVIEW26_11_, mediavideo0_.PREVIEW_VIDEO_URL as PREVIEW27_11_, mediavideo0_.WY_PUSH_URL as WY_PUSH28_11_, mediavideo0_.REMARK as REMARK29_11_, mediavideo0_.REVIEW_TIMES as REVIEW_30_11_, mediavideo0_.WY_RTMP_PULL_URL as WY_RTMP31_11_, mediavideo0_.SHARE_TIMES as SHARE_T32_11_, mediavideo0_.START_TIME as START_T33_11_, mediavideo0_.STATUS as STATUS34_11_, mediavideo0_.SUBJECT_ID as SUBJECT35_11_, mediavideo0_.SUBJECT_NAME as SUBJECT36_11_, mediavideo0_.TECENT_LIVE_NUMBER as TECENT_37_11_, mediavideo0_.UPDATE_ID as UPDATE_38_11_, mediavideo0_.UPDATE_TIME as UPDATE_39_11_, mediavideo0_.UPDATOR as UPDATOR40_11_, mediavideo0_.WATCH_MAX_TIMES as WATCH_M41_11_, mediavideo0_.WATCH_TIMES as WATCH_T42_11_, mediavideo0_.WATCHER_LIMIT as WATCHER43_11_, mediavideo0_.WY_LIVE_NUMBER as WY_LIVE44_11_ from MEDIA_VIDEO_LIVE mediavideo0_ where mediavideo0_.START_TIME>=? and mediavideo0_.START_TIME=? and exambatchi0_.START_TIME=? and exambatchi0_.START_TIME=? and mediavideo0_.START_TIME=? and mediavideo0_.START_TIME=? and exambatchi0_.START_TIME=? and exambatchi0_.START_TIME=? and mediavideo0_.START_TIME=? and exambatchi0_.START_TIME=? and mediavideo0_.START_TIME=? and mediavideo0_.START_TIME=? and exambatchi0_.START_TIME=? and exambatchi0_.START_TIME=? and mediavideo0_.START_TIME=? and exambatchi0_.START_TIME=? and mediavideo0_.START_TIME=? and exambatchi0_.START_TIME=? and mediavideo0_.START_TIME=? and exambatchi0_.START_TIME=? and mediavideo0_.START_TIME=sysdate() order by clsclass0_.CREATE_TIME desc limit ? 2020-05-05 11:46:27.857 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [1] as [VARCHAR] - [1] 2020-05-05 11:46:27.857 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [2] as [VARCHAR] - [%] 2020-05-05 11:46:27.886 DEBUG org.hibernate.SQL - select count(1) as col_0_0_ from cls_class clsclass0_ where clsclass0_.DELETE_FLAG=0 and clsclass0_.ORG_ID=? and (clsclass0_.NAME like ?) and clsclass0_.END_TIME>=sysdate() 2020-05-05 11:46:27.886 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [1] as [VARCHAR] - [1] 2020-05-05 11:46:27.886 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [2] as [VARCHAR] - [%] 2020-05-05 11:46:27.887 DEBUG org.hibernate.SQL - select count(1) as col_0_0_ from cls_class clsclass0_ where clsclass0_.DELETE_FLAG=0 and clsclass0_.ORG_ID=? and (clsclass0_.NAME like ?) and clsclass0_.END_TIME>=sysdate() 2020-05-05 11:46:27.887 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [1] as [VARCHAR] - [1] 2020-05-05 11:46:27.888 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [2] as [VARCHAR] - [%] 2020-05-05 11:46:29.084 DEBUG org.hibernate.SQL - select count(1) as col_0_0_ from class_room classroom0_ where (classroom0_.name like ?) and classroom0_.CREATE_ID=? and classroom0_.DELETE_FLAG=0 2020-05-05 11:46:29.084 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [1] as [VARCHAR] - [%%] 2020-05-05 11:46:29.084 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [2] as [VARCHAR] - [40288a1261d106ba0161d1072e260000] 2020-05-05 11:46:29.085 DEBUG org.hibernate.SQL - select count(1) as col_0_0_ from class_room classroom0_ where (classroom0_.name like ?) and classroom0_.CREATE_ID=? and classroom0_.DELETE_FLAG=0 2020-05-05 11:46:29.085 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [1] as [VARCHAR] - [%%] 2020-05-05 11:46:29.085 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [2] as [VARCHAR] - [40288a1261d106ba0161d1072e260000] 2020-05-05 11:46:29.087 DEBUG org.hibernate.SQL - select classroom0_.ROOM_ID as ROOM_ID1_63_, classroom0_.address as address2_63_, classroom0_.CREATE_ID as CREATE_I3_63_, classroom0_.CREATE_TIME as CREATE_T4_63_, classroom0_.CREATOR as CREATOR5_63_, classroom0_.DELETE_FLAG as DELETE_F6_63_, classroom0_.name as name7_63_, classroom0_.ORG_ID as ORG_ID8_63_, classroom0_.status as status9_63_, classroom0_.UPDATE_ID as UPDATE_10_63_, classroom0_.UPDATE_TIME as UPDATE_11_63_, classroom0_.UPDATOR as UPDATOR12_63_ from class_room classroom0_ where (classroom0_.name like ?) and classroom0_.CREATE_ID=? and classroom0_.DELETE_FLAG=0 order by classroom0_.CREATE_TIME desc limit ? 2020-05-05 11:46:29.087 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [1] as [VARCHAR] - [%%] 2020-05-05 11:46:29.087 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [2] as [VARCHAR] - [40288a1261d106ba0161d1072e260000] 2020-05-05 11:46:31.273 DEBUG org.hibernate.SQL - select count(1) as col_0_0_ from class_room classroom0_ where (classroom0_.name like ?) and classroom0_.CREATE_ID=? and classroom0_.DELETE_FLAG=0 2020-05-05 11:46:31.273 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [1] as [VARCHAR] - [%%] 2020-05-05 11:46:31.273 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [2] as [VARCHAR] - [40288a1261d106ba0161d1072e260000] 2020-05-05 11:46:31.275 DEBUG org.hibernate.SQL - select count(1) as col_0_0_ from class_room classroom0_ where (classroom0_.name like ?) and classroom0_.CREATE_ID=? and classroom0_.DELETE_FLAG=0 2020-05-05 11:46:31.275 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [1] as [VARCHAR] - [%%] 2020-05-05 11:46:31.275 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [2] as [VARCHAR] - [40288a1261d106ba0161d1072e260000] 2020-05-05 11:46:31.278 DEBUG org.hibernate.SQL - select classroom0_.ROOM_ID as ROOM_ID1_63_, classroom0_.address as address2_63_, classroom0_.CREATE_ID as CREATE_I3_63_, classroom0_.CREATE_TIME as CREATE_T4_63_, classroom0_.CREATOR as CREATOR5_63_, classroom0_.DELETE_FLAG as DELETE_F6_63_, classroom0_.name as name7_63_, classroom0_.ORG_ID as ORG_ID8_63_, classroom0_.status as status9_63_, classroom0_.UPDATE_ID as UPDATE_10_63_, classroom0_.UPDATE_TIME as UPDATE_11_63_, classroom0_.UPDATOR as UPDATOR12_63_ from class_room classroom0_ where (classroom0_.name like ?) and classroom0_.CREATE_ID=? and classroom0_.DELETE_FLAG=0 order by classroom0_.CREATE_TIME desc limit ? 2020-05-05 11:46:31.278 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [1] as [VARCHAR] - [%%] 2020-05-05 11:46:31.278 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [2] as [VARCHAR] - [40288a1261d106ba0161d1072e260000] 2020-05-05 11:46:34.203 DEBUG org.hibernate.SQL - select count(1) as col_0_0_ from class_room classroom0_ where (classroom0_.name like ?) and classroom0_.CREATE_ID=? and classroom0_.DELETE_FLAG=0 2020-05-05 11:46:34.204 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [1] as [VARCHAR] - [%%] 2020-05-05 11:46:34.204 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [2] as [VARCHAR] - [40288a1261d106ba0161d1072e260000] 2020-05-05 11:46:34.204 DEBUG org.hibernate.SQL - select count(1) as col_0_0_ from class_room classroom0_ where (classroom0_.name like ?) and classroom0_.CREATE_ID=? and classroom0_.DELETE_FLAG=0 2020-05-05 11:46:34.204 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [1] as [VARCHAR] - [%%] 2020-05-05 11:46:34.204 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [2] as [VARCHAR] - [40288a1261d106ba0161d1072e260000] 2020-05-05 11:46:34.206 DEBUG org.hibernate.SQL - select classroom0_.ROOM_ID as ROOM_ID1_63_, classroom0_.address as address2_63_, classroom0_.CREATE_ID as CREATE_I3_63_, classroom0_.CREATE_TIME as CREATE_T4_63_, classroom0_.CREATOR as CREATOR5_63_, classroom0_.DELETE_FLAG as DELETE_F6_63_, classroom0_.name as name7_63_, classroom0_.ORG_ID as ORG_ID8_63_, classroom0_.status as status9_63_, classroom0_.UPDATE_ID as UPDATE_10_63_, classroom0_.UPDATE_TIME as UPDATE_11_63_, classroom0_.UPDATOR as UPDATOR12_63_ from class_room classroom0_ where (classroom0_.name like ?) and classroom0_.CREATE_ID=? and classroom0_.DELETE_FLAG=0 order by classroom0_.CREATE_TIME desc limit ? 2020-05-05 11:46:34.207 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [1] as [VARCHAR] - [%%] 2020-05-05 11:46:34.207 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [2] as [VARCHAR] - [40288a1261d106ba0161d1072e260000] 2020-05-05 11:48:47.614 DEBUG org.hibernate.SQL - select count(1) as col_0_0_ from class_room classroom0_ where (classroom0_.name like ?) and classroom0_.CREATE_ID=? and classroom0_.DELETE_FLAG=0 2020-05-05 11:48:47.617 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [1] as [VARCHAR] - [%%] 2020-05-05 11:48:47.618 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [2] as [VARCHAR] - [40288a1261d106ba0161d1072e260000] 2020-05-05 11:48:47.620 DEBUG org.hibernate.SQL - select count(1) as col_0_0_ from class_room classroom0_ where (classroom0_.name like ?) and classroom0_.CREATE_ID=? and classroom0_.DELETE_FLAG=0 2020-05-05 11:48:47.621 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [1] as [VARCHAR] - [%%] 2020-05-05 11:48:47.621 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [2] as [VARCHAR] - [40288a1261d106ba0161d1072e260000] 2020-05-05 11:48:47.623 DEBUG org.hibernate.SQL - select classroom0_.ROOM_ID as ROOM_ID1_63_, classroom0_.address as address2_63_, classroom0_.CREATE_ID as CREATE_I3_63_, classroom0_.CREATE_TIME as CREATE_T4_63_, classroom0_.CREATOR as CREATOR5_63_, classroom0_.DELETE_FLAG as DELETE_F6_63_, classroom0_.name as name7_63_, classroom0_.ORG_ID as ORG_ID8_63_, classroom0_.status as status9_63_, classroom0_.UPDATE_ID as UPDATE_10_63_, classroom0_.UPDATE_TIME as UPDATE_11_63_, classroom0_.UPDATOR as UPDATOR12_63_ from class_room classroom0_ where (classroom0_.name like ?) and classroom0_.CREATE_ID=? and classroom0_.DELETE_FLAG=0 order by classroom0_.CREATE_TIME desc limit ? 2020-05-05 11:48:47.624 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [1] as [VARCHAR] - [%%] 2020-05-05 11:48:47.624 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [2] as [VARCHAR] - [40288a1261d106ba0161d1072e260000] 2020-05-05 11:48:50.808 DEBUG org.hibernate.SQL - select clsclass0_.CLASS_ID as CLASS_ID1_64_, clsclass0_.ADDRESS as ADDRESS2_64_, clsclass0_.ADDRESS_ID as ADDRESS_3_64_, clsclass0_.ADVANTAGE as ADVANTAG4_64_, clsclass0_.ARRANGEMENT as ARRANGEM5_64_, clsclass0_.CAN_MULTI_EXER as CAN_MULT6_64_, clsclass0_.CITY as CITY7_64_, clsclass0_.CLASS_CHARGER as CLASS_CH8_64_, clsclass0_.CLASS_CHARGER_ID as CLASS_CH9_64_, clsclass0_.CLASS_NUMBER as CLASS_N10_64_, clsclass0_.CLASS_TYPES as CLASS_T11_64_, clsclass0_.CLICK_NUM as CLICK_N12_64_, clsclass0_.CODE as CODE13_64_, clsclass0_.COLLEGE_COURSE_ID as COLLEGE14_64_, clsclass0_.COLLEGE_COURSE_NAME as COLLEGE15_64_, clsclass0_.COMMENT_COUNT as COMMENT16_64_, clsclass0_.COURSE_ID as COURSE_17_64_, clsclass0_.CREATE_ID as CREATE_18_64_, clsclass0_.CREATE_TIME as CREATE_19_64_, clsclass0_.CREATOR as CREATOR20_64_, clsclass0_.DELETE_FLAG as DELETE_21_64_, clsclass0_.DISCOUNT as DISCOUN22_64_, clsclass0_.DISPRICE as DISPRIC23_64_, clsclass0_.END_TIME as END_TIM24_64_, clsclass0_.EXTENDED as EXTENDE25_64_, clsclass0_.FULL_TEXT as FULL_TE26_64_, clsclass0_.GOOD_ID as GOOD_ID27_64_, clsclass0_.HAVA_AWARD as HAVA_AW28_64_, clsclass0_.HAVE_HANDOUT as HAVE_HA29_64_, clsclass0_.HAVE_LIVE as HAVE_LI30_64_, clsclass0_.HAVE_VIDEO as HAVE_VI31_64_, clsclass0_.IMG_PATH as IMG_PAT32_64_, clsclass0_.LATITUDE_Y as LATITUD33_64_, clsclass0_.LONGITUDE_X as LONGITU34_64_, clsclass0_.MODE as MODE35_64_, clsclass0_.NAME as NAME36_64_, clsclass0_.NEED_FORUM as NEED_FO37_64_, clsclass0_.NEED_JOIN_AUDIT as NEED_JO38_64_, clsclass0_.NEED_QUIT_AUDIT as NEED_QU39_64_, clsclass0_.ORG_ID as ORG_ID40_64_, clsclass0_.PAYMENT_NUM as PAYMENT41_64_, clsclass0_.POINTER as POINTER42_64_, clsclass0_.PRICE as PRICE43_64_, clsclass0_.PRODUCT_ID as PRODUCT44_64_, clsclass0_.PROGRESS as PROGRES45_64_, clsclass0_.PROVINCE as PROVINC46_64_, clsclass0_.RECOMMEND as RECOMME47_64_, clsclass0_.REGION as REGION48_64_, clsclass0_.SCORE as SCORE49_64_, clsclass0_.SHOU_ANALYSIS_AFTER_EXER as SHOU_AN50_64_, clsclass0_.START_TIME as START_T51_64_, clsclass0_.STU_ALL_COUNT as STU_ALL52_64_, clsclass0_.STUDENT_COUNT as STUDENT53_64_, clsclass0_.STUDY_TIME as STUDY_T54_64_, clsclass0_.TEACHER_ID as TEACHER55_64_, clsclass0_.TOP_FLAG as TOP_FLA56_64_, clsclass0_.UPDATE_ID as UPDATE_57_64_, clsclass0_.UPDATE_TIME as UPDATE_58_64_, clsclass0_.UPDATOR as UPDATOR59_64_ from cls_class clsclass0_ where clsclass0_.DELETE_FLAG=0 and clsclass0_.ORG_ID=? and (clsclass0_.NAME like ?) and clsclass0_.END_TIME>=sysdate() order by clsclass0_.CREATE_TIME desc limit ? 2020-05-05 11:48:50.808 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [1] as [VARCHAR] - [1] 2020-05-05 11:48:50.808 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [2] as [VARCHAR] - [%] 2020-05-05 11:48:50.811 DEBUG org.hibernate.SQL - select count(1) as col_0_0_ from cls_class clsclass0_ where clsclass0_.DELETE_FLAG=0 and clsclass0_.ORG_ID=? and (clsclass0_.NAME like ?) and clsclass0_.END_TIME>=sysdate() 2020-05-05 11:48:50.811 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [1] as [VARCHAR] - [1] 2020-05-05 11:48:50.811 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [2] as [VARCHAR] - [%] 2020-05-05 11:48:50.813 DEBUG org.hibernate.SQL - select count(1) as col_0_0_ from cls_class clsclass0_ where clsclass0_.DELETE_FLAG=0 and clsclass0_.ORG_ID=? and (clsclass0_.NAME like ?) and clsclass0_.END_TIME>=sysdate() 2020-05-05 11:48:50.813 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [1] as [VARCHAR] - [1] 2020-05-05 11:48:50.813 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [2] as [VARCHAR] - [%] 2020-05-05 11:48:54.126 DEBUG org.hibernate.SQL - select clsclass0_.CLASS_ID as CLASS_ID1_64_, clsclass0_.ADDRESS as ADDRESS2_64_, clsclass0_.ADDRESS_ID as ADDRESS_3_64_, clsclass0_.ADVANTAGE as ADVANTAG4_64_, clsclass0_.ARRANGEMENT as ARRANGEM5_64_, clsclass0_.CAN_MULTI_EXER as CAN_MULT6_64_, clsclass0_.CITY as CITY7_64_, clsclass0_.CLASS_CHARGER as CLASS_CH8_64_, clsclass0_.CLASS_CHARGER_ID as CLASS_CH9_64_, clsclass0_.CLASS_NUMBER as CLASS_N10_64_, clsclass0_.CLASS_TYPES as CLASS_T11_64_, clsclass0_.CLICK_NUM as CLICK_N12_64_, clsclass0_.CODE as CODE13_64_, clsclass0_.COLLEGE_COURSE_ID as COLLEGE14_64_, clsclass0_.COLLEGE_COURSE_NAME as COLLEGE15_64_, clsclass0_.COMMENT_COUNT as COMMENT16_64_, clsclass0_.COURSE_ID as COURSE_17_64_, clsclass0_.CREATE_ID as CREATE_18_64_, clsclass0_.CREATE_TIME as CREATE_19_64_, clsclass0_.CREATOR as CREATOR20_64_, clsclass0_.DELETE_FLAG as DELETE_21_64_, clsclass0_.DISCOUNT as DISCOUN22_64_, clsclass0_.DISPRICE as DISPRIC23_64_, clsclass0_.END_TIME as END_TIM24_64_, clsclass0_.EXTENDED as EXTENDE25_64_, clsclass0_.FULL_TEXT as FULL_TE26_64_, clsclass0_.GOOD_ID as GOOD_ID27_64_, clsclass0_.HAVA_AWARD as HAVA_AW28_64_, clsclass0_.HAVE_HANDOUT as HAVE_HA29_64_, clsclass0_.HAVE_LIVE as HAVE_LI30_64_, clsclass0_.HAVE_VIDEO as HAVE_VI31_64_, clsclass0_.IMG_PATH as IMG_PAT32_64_, clsclass0_.LATITUDE_Y as LATITUD33_64_, clsclass0_.LONGITUDE_X as LONGITU34_64_, clsclass0_.MODE as MODE35_64_, clsclass0_.NAME as NAME36_64_, clsclass0_.NEED_FORUM as NEED_FO37_64_, clsclass0_.NEED_JOIN_AUDIT as NEED_JO38_64_, clsclass0_.NEED_QUIT_AUDIT as NEED_QU39_64_, clsclass0_.ORG_ID as ORG_ID40_64_, clsclass0_.PAYMENT_NUM as PAYMENT41_64_, clsclass0_.POINTER as POINTER42_64_, clsclass0_.PRICE as PRICE43_64_, clsclass0_.PRODUCT_ID as PRODUCT44_64_, clsclass0_.PROGRESS as PROGRES45_64_, clsclass0_.PROVINCE as PROVINC46_64_, clsclass0_.RECOMMEND as RECOMME47_64_, clsclass0_.REGION as REGION48_64_, clsclass0_.SCORE as SCORE49_64_, clsclass0_.SHOU_ANALYSIS_AFTER_EXER as SHOU_AN50_64_, clsclass0_.START_TIME as START_T51_64_, clsclass0_.STU_ALL_COUNT as STU_ALL52_64_, clsclass0_.STUDENT_COUNT as STUDENT53_64_, clsclass0_.STUDY_TIME as STUDY_T54_64_, clsclass0_.TEACHER_ID as TEACHER55_64_, clsclass0_.TOP_FLAG as TOP_FLA56_64_, clsclass0_.UPDATE_ID as UPDATE_57_64_, clsclass0_.UPDATE_TIME as UPDATE_58_64_, clsclass0_.UPDATOR as UPDATOR59_64_ from cls_class clsclass0_ where clsclass0_.DELETE_FLAG=0 and clsclass0_.ORG_ID=? and (clsclass0_.NAME like ?) and clsclass0_.END_TIME>=sysdate() order by clsclass0_.CREATE_TIME desc limit ? 2020-05-05 11:48:54.127 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [1] as [VARCHAR] - [1] 2020-05-05 11:48:54.127 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [2] as [VARCHAR] - [%] 2020-05-05 11:48:54.130 DEBUG org.hibernate.SQL - select count(1) as col_0_0_ from cls_class clsclass0_ where clsclass0_.DELETE_FLAG=0 and clsclass0_.ORG_ID=? and (clsclass0_.NAME like ?) and clsclass0_.END_TIME>=sysdate() 2020-05-05 11:48:54.130 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [1] as [VARCHAR] - [1] 2020-05-05 11:48:54.130 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [2] as [VARCHAR] - [%] 2020-05-05 11:48:54.131 DEBUG org.hibernate.SQL - select count(1) as col_0_0_ from cls_class clsclass0_ where clsclass0_.DELETE_FLAG=0 and clsclass0_.ORG_ID=? and (clsclass0_.NAME like ?) and clsclass0_.END_TIME>=sysdate() 2020-05-05 11:48:54.131 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [1] as [VARCHAR] - [1] 2020-05-05 11:48:54.131 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [2] as [VARCHAR] - [%] 2020-05-05 11:48:56.602 DEBUG org.hibernate.SQL - select count(1) as col_0_0_ from class_room classroom0_ where (classroom0_.name like ?) and classroom0_.CREATE_ID=? and classroom0_.DELETE_FLAG=0 2020-05-05 11:48:56.602 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [1] as [VARCHAR] - [%%] 2020-05-05 11:48:56.602 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [2] as [VARCHAR] - [40288a1261d106ba0161d1072e260000] 2020-05-05 11:48:56.603 DEBUG org.hibernate.SQL - select count(1) as col_0_0_ from class_room classroom0_ where (classroom0_.name like ?) and classroom0_.CREATE_ID=? and classroom0_.DELETE_FLAG=0 2020-05-05 11:48:56.603 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [1] as [VARCHAR] - [%%] 2020-05-05 11:48:56.603 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [2] as [VARCHAR] - [40288a1261d106ba0161d1072e260000] 2020-05-05 11:48:56.605 DEBUG org.hibernate.SQL - select classroom0_.ROOM_ID as ROOM_ID1_63_, classroom0_.address as address2_63_, classroom0_.CREATE_ID as CREATE_I3_63_, classroom0_.CREATE_TIME as CREATE_T4_63_, classroom0_.CREATOR as CREATOR5_63_, classroom0_.DELETE_FLAG as DELETE_F6_63_, classroom0_.name as name7_63_, classroom0_.ORG_ID as ORG_ID8_63_, classroom0_.status as status9_63_, classroom0_.UPDATE_ID as UPDATE_10_63_, classroom0_.UPDATE_TIME as UPDATE_11_63_, classroom0_.UPDATOR as UPDATOR12_63_ from class_room classroom0_ where (classroom0_.name like ?) and classroom0_.CREATE_ID=? and classroom0_.DELETE_FLAG=0 order by classroom0_.CREATE_TIME desc limit ? 2020-05-05 11:48:56.605 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [1] as [VARCHAR] - [%%] 2020-05-05 11:48:56.606 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [2] as [VARCHAR] - [40288a1261d106ba0161d1072e260000] 2020-05-05 11:50:00.014 DEBUG org.hibernate.SQL - select mediavideo0_.VIDEO_LIVE_ID as VIDEO_LI1_11_, mediavideo0_.ANCHOR as ANCHOR2_11_, mediavideo0_.ANCHOR_ID as ANCHOR_I3_11_, mediavideo0_.ATTRIBUTE as ATTRIBUT4_11_, mediavideo0_.COMPLETE_FLAG as COMPLETE5_11_, mediavideo0_.CONSULT_IMG_URL as CONSULT_6_11_, mediavideo0_.CREATE_ID as CREATE_I7_11_, mediavideo0_.CREATE_TIME as CREATE_T8_11_, mediavideo0_.CREATOR as CREATOR9_11_, mediavideo0_.DEFINITION as DEFINIT10_11_, mediavideo0_.DELETE_FLAG as DELETE_11_11_, mediavideo0_.EDIT_REPLAY_FLAG as EDIT_RE12_11_, mediavideo0_.END_TIME as END_TIM13_11_, mediavideo0_.EXPECTED_TIMES as EXPECTE14_11_, mediavideo0_.WY_HLS_PULL_URL as WY_HLS_15_11_, mediavideo0_.WY_HTTP_PULL_URL as WY_HTTP16_11_, mediavideo0_.LAST_RECORD_TIME as LAST_RE17_11_, mediavideo0_.TQ_MEETING_ID as TQ_MEET18_11_, mediavideo0_.TQ_MEETING_PWD as TQ_MEET19_11_, mediavideo0_.NAME as NAME20_11_, mediavideo0_.ON_TIME_FLAG as ON_TIME21_11_, mediavideo0_.ORDER_TIMES as ORDER_T22_11_, mediavideo0_.PERMISSION as PERMISS23_11_, mediavideo0_.PLAY_TIMES as PLAY_TI24_11_, mediavideo0_.PRAISE_TIMES as PRAISE_25_11_, mediavideo0_.PREVIEW_IMG_URL as PREVIEW26_11_, mediavideo0_.PREVIEW_VIDEO_URL as PREVIEW27_11_, mediavideo0_.WY_PUSH_URL as WY_PUSH28_11_, mediavideo0_.REMARK as REMARK29_11_, mediavideo0_.REVIEW_TIMES as REVIEW_30_11_, mediavideo0_.WY_RTMP_PULL_URL as WY_RTMP31_11_, mediavideo0_.SHARE_TIMES as SHARE_T32_11_, mediavideo0_.START_TIME as START_T33_11_, mediavideo0_.STATUS as STATUS34_11_, mediavideo0_.SUBJECT_ID as SUBJECT35_11_, mediavideo0_.SUBJECT_NAME as SUBJECT36_11_, mediavideo0_.TECENT_LIVE_NUMBER as TECENT_37_11_, mediavideo0_.UPDATE_ID as UPDATE_38_11_, mediavideo0_.UPDATE_TIME as UPDATE_39_11_, mediavideo0_.UPDATOR as UPDATOR40_11_, mediavideo0_.WATCH_MAX_TIMES as WATCH_M41_11_, mediavideo0_.WATCH_TIMES as WATCH_T42_11_, mediavideo0_.WATCHER_LIMIT as WATCHER43_11_, mediavideo0_.WY_LIVE_NUMBER as WY_LIVE44_11_ from MEDIA_VIDEO_LIVE mediavideo0_ where mediavideo0_.START_TIME>=? and mediavideo0_.START_TIME=? and exambatchi0_.START_TIME=? and exambatchi0_.START_TIME=? and mediavideo0_.START_TIME=? and exambatchi0_.START_TIME=? and mediavideo0_.START_TIME=? and coursesche0_.END_TIME<=? and coursesche1_.status=? and coursesche1_.DELETE_FLAG=0 and coursesche0_.DELETE_FLAG=0 2020-05-05 12:04:08.431 DEBUG org.hibernate.SQL - select day(coursesche0_.BEGIN_TIME) as col_0_0_ from course_schedule_detail coursesche0_ left outer join course_schedule coursesche1_ on coursesche0_.SCHEDULE_ID=coursesche1_.SCHEDULE_ID where coursesche0_.DELETE_FLAG=0 and coursesche0_.BEGIN_TIME>=? and coursesche0_.END_TIME<=? and coursesche1_.status=? and coursesche1_.DELETE_FLAG=0 group by day(coursesche0_.BEGIN_TIME) limit ? 2020-05-05 12:04:08.464 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [1] as [TIMESTAMP] - [Tue May 05 00:00:00 CST 2020] 2020-05-05 12:04:08.465 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [2] as [TIMESTAMP] - [Tue May 05 23:59:59 CST 2020] 2020-05-05 12:04:08.465 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [3] as [SMALLINT] - [1] 2020-05-05 12:04:08.474 DEBUG org.hibernate.SQL - select count(1) as col_0_0_ from course_schedule_detail coursesche0_ left outer join course_schedule coursesche1_ on coursesche0_.SCHEDULE_ID=coursesche1_.SCHEDULE_ID where coursesche0_.DELETE_FLAG=0 and coursesche0_.BEGIN_TIME>=? and coursesche0_.END_TIME<=? and coursesche1_.status=? and coursesche1_.DELETE_FLAG=0 and coursesche0_.DELETE_FLAG=0 2020-05-05 12:04:08.474 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [1] as [TIMESTAMP] - [Tue May 05 00:00:00 CST 2020] 2020-05-05 12:04:08.475 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [2] as [TIMESTAMP] - [Tue May 05 23:59:59 CST 2020] 2020-05-05 12:04:08.475 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [3] as [SMALLINT] - [1] 2020-05-05 12:04:08.478 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [1] as [TIMESTAMP] - [Fri May 01 00:00:00 CST 2020] 2020-05-05 12:04:08.478 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [2] as [TIMESTAMP] - [Sun May 31 23:59:59 CST 2020] 2020-05-05 12:04:08.478 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [3] as [SMALLINT] - [1] 2020-05-05 12:04:08.496 DEBUG org.hibernate.SQL - select coursesche0_.DETAIL_ID as DETAIL_I1_69_0_, coursesche1_.SCHEDULE_ID as SCHEDULE1_68_1_, subject2_.SUBJECT_ID as SUBJECT_1_54_2_, classroom3_.ROOM_ID as ROOM_ID1_63_3_, clsclass5_.CLASS_ID as CLASS_ID1_64_4_, coursesche0_.BEGIN_TIME as BEGIN_TI2_69_0_, coursesche0_.SCHEDULE_ID as SCHEDULE8_69_0_, coursesche0_.CREATE_ID as CREATE_I3_69_0_, coursesche0_.CREATE_TIME as CREATE_T4_69_0_, coursesche0_.CREATOR as CREATOR5_69_0_, coursesche0_.DELETE_FLAG as DELETE_F6_69_0_, coursesche0_.END_TIME as END_TIME7_69_0_, coursesche0_.UPDATE_ID as UPDATE_I9_69_0_, coursesche0_.UPDATE_TIME as UPDATE_10_69_0_, coursesche0_.UPDATOR as UPDATOR11_69_0_, coursesche1_.BEGIN_TIME as BEGIN_TI2_68_1_, coursesche1_.ROOM_ID as ROOM_ID13_68_1_, coursesche1_.CREATE_ID as CREATE_I3_68_1_, coursesche1_.CREATE_TIME as CREATE_T4_68_1_, coursesche1_.CREATOR as CREATOR5_68_1_, coursesche1_.DELETE_FLAG as DELETE_F6_68_1_, coursesche1_.END_TIME as END_TIME7_68_1_, coursesche1_.FRI_TIME as FRI_TIME8_68_1_, coursesche1_.mark as mark9_68_1_, coursesche1_.MON_TIME as MON_TIM10_68_1_, coursesche1_.OPEN_FLAG as OPEN_FL11_68_1_, coursesche1_.ORG_ID as ORG_ID12_68_1_, coursesche1_.SAT_TIME as SAT_TIM14_68_1_, coursesche1_.status as status15_68_1_, coursesche1_.SUBJECT_ID as SUBJECT16_68_1_, coursesche1_.SUM_TIME as SUM_TIM17_68_1_, coursesche1_.TEACHER_ID as TEACHER18_68_1_, coursesche1_.TEACHER_NAME as TEACHER19_68_1_, coursesche1_.THU_TIME as THU_TIM20_68_1_, coursesche1_.TUE_TIME as TUE_TIM21_68_1_, coursesche1_.type as type22_68_1_, coursesche1_.UPDATE_ID as UPDATE_23_68_1_, coursesche1_.UPDATE_TIME as UPDATE_24_68_1_, coursesche1_.UPDATOR as UPDATOR25_68_1_, coursesche1_.WED_TIME as WED_TIM26_68_1_, subject2_.CODE as CODE2_54_2_, subject2_.CONTENT_FILE_ID as CONTENT_3_54_2_, subject2_.COURSE_ID as COURSE_I4_54_2_, subject2_.COVER_PAGE_FILE_ID as COVER_PA5_54_2_, subject2_.COVER_PAGE_URL as COVER_PA6_54_2_, subject2_.CREATE_ID as CREATE_I7_54_2_, subject2_.CREATE_TIME as CREATE_T8_54_2_, subject2_.CREATOR as CREATOR9_54_2_, subject2_.DELETE_FLAG as DELETE_10_54_2_, subject2_.FULL_NAME as FULL_NA11_54_2_, subject2_.LECTURE_COUNT as LECTURE12_54_2_, subject2_.NAME as NAME13_54_2_, subject2_.ORDER_NUM as ORDER_N14_54_2_, subject2_.ORG_ID as ORG_ID15_54_2_, subject2_.ORIG_COPY_SUBJECT_ID as ORIG_CO16_54_2_, subject2_.ORIG_SUBJECT_ID as ORIG_SU17_54_2_, subject2_.SCHOOL_YEAR as SCHOOL_18_54_2_, subject2_.STATUS as STATUS19_54_2_, subject2_.TEACHER_ID as TEACHER20_54_2_, subject2_.TEACHER_NAME as TEACHER21_54_2_, subject2_.TERM as TERM22_54_2_, subject2_.TYPE as TYPE23_54_2_, subject2_.UPDATE_ID as UPDATE_24_54_2_, subject2_.UPDATE_TIME as UPDATE_25_54_2_, subject2_.UPDATOR as UPDATOR26_54_2_, classroom3_.address as address2_63_3_, classroom3_.CREATE_ID as CREATE_I3_63_3_, classroom3_.CREATE_TIME as CREATE_T4_63_3_, classroom3_.CREATOR as CREATOR5_63_3_, classroom3_.DELETE_FLAG as DELETE_F6_63_3_, classroom3_.name as name7_63_3_, classroom3_.ORG_ID as ORG_ID8_63_3_, classroom3_.status as status9_63_3_, classroom3_.UPDATE_ID as UPDATE_10_63_3_, classroom3_.UPDATE_TIME as UPDATE_11_63_3_, classroom3_.UPDATOR as UPDATOR12_63_3_, clsclass5_.ADDRESS as ADDRESS2_64_4_, clsclass5_.ADDRESS_ID as ADDRESS_3_64_4_, clsclass5_.ADVANTAGE as ADVANTAG4_64_4_, clsclass5_.ARRANGEMENT as ARRANGEM5_64_4_, clsclass5_.CAN_MULTI_EXER as CAN_MULT6_64_4_, clsclass5_.CITY as CITY7_64_4_, clsclass5_.CLASS_CHARGER as CLASS_CH8_64_4_, clsclass5_.CLASS_CHARGER_ID as CLASS_CH9_64_4_, clsclass5_.CLASS_NUMBER as CLASS_N10_64_4_, clsclass5_.CLASS_TYPES as CLASS_T11_64_4_, clsclass5_.CLICK_NUM as CLICK_N12_64_4_, clsclass5_.CODE as CODE13_64_4_, clsclass5_.COLLEGE_COURSE_ID as COLLEGE14_64_4_, clsclass5_.COLLEGE_COURSE_NAME as COLLEGE15_64_4_, clsclass5_.COMMENT_COUNT as COMMENT16_64_4_, clsclass5_.COURSE_ID as COURSE_17_64_4_, clsclass5_.CREATE_ID as CREATE_18_64_4_, clsclass5_.CREATE_TIME as CREATE_19_64_4_, clsclass5_.CREATOR as CREATOR20_64_4_, clsclass5_.DELETE_FLAG as DELETE_21_64_4_, clsclass5_.DISCOUNT as DISCOUN22_64_4_, clsclass5_.DISPRICE as DISPRIC23_64_4_, clsclass5_.END_TIME as END_TIM24_64_4_, clsclass5_.EXTENDED as EXTENDE25_64_4_, clsclass5_.FULL_TEXT as FULL_TE26_64_4_, clsclass5_.GOOD_ID as GOOD_ID27_64_4_, clsclass5_.HAVA_AWARD as HAVA_AW28_64_4_, clsclass5_.HAVE_HANDOUT as HAVE_HA29_64_4_, clsclass5_.HAVE_LIVE as HAVE_LI30_64_4_, clsclass5_.HAVE_VIDEO as HAVE_VI31_64_4_, clsclass5_.IMG_PATH as IMG_PAT32_64_4_, clsclass5_.LATITUDE_Y as LATITUD33_64_4_, clsclass5_.LONGITUDE_X as LONGITU34_64_4_, clsclass5_.MODE as MODE35_64_4_, clsclass5_.NAME as NAME36_64_4_, clsclass5_.NEED_FORUM as NEED_FO37_64_4_, clsclass5_.NEED_JOIN_AUDIT as NEED_JO38_64_4_, clsclass5_.NEED_QUIT_AUDIT as NEED_QU39_64_4_, clsclass5_.ORG_ID as ORG_ID40_64_4_, clsclass5_.PAYMENT_NUM as PAYMENT41_64_4_, clsclass5_.POINTER as POINTER42_64_4_, clsclass5_.PRICE as PRICE43_64_4_, clsclass5_.PRODUCT_ID as PRODUCT44_64_4_, clsclass5_.PROGRESS as PROGRES45_64_4_, clsclass5_.PROVINCE as PROVINC46_64_4_, clsclass5_.RECOMMEND as RECOMME47_64_4_, clsclass5_.REGION as REGION48_64_4_, clsclass5_.SCORE as SCORE49_64_4_, clsclass5_.SHOU_ANALYSIS_AFTER_EXER as SHOU_AN50_64_4_, clsclass5_.START_TIME as START_T51_64_4_, clsclass5_.STU_ALL_COUNT as STU_ALL52_64_4_, clsclass5_.STUDENT_COUNT as STUDENT53_64_4_, clsclass5_.STUDY_TIME as STUDY_T54_64_4_, clsclass5_.TEACHER_ID as TEACHER55_64_4_, clsclass5_.TOP_FLAG as TOP_FLA56_64_4_, clsclass5_.UPDATE_ID as UPDATE_57_64_4_, clsclass5_.UPDATE_TIME as UPDATE_58_64_4_, clsclass5_.UPDATOR as UPDATOR59_64_4_, classes4_.SCHEDULE_ID as SCHEDULE1_68_0__, classes4_.CLASS_ID as CLASS_ID2_1_0__, classes4_.RE_ID as RE_ID3_0__ from course_schedule_detail coursesche0_ left outer join course_schedule coursesche1_ on coursesche0_.SCHEDULE_ID=coursesche1_.SCHEDULE_ID left outer join SUBJECT subject2_ on coursesche1_.SUBJECT_ID=subject2_.SUBJECT_ID left outer join class_room classroom3_ on coursesche1_.ROOM_ID=classroom3_.ROOM_ID left outer join COURSE_SCHEDULE_RE_CLS classes4_ on coursesche1_.SCHEDULE_ID=classes4_.SCHEDULE_ID left outer join cls_class clsclass5_ on classes4_.CLASS_ID=clsclass5_.CLASS_ID and ( clsclass5_.DELETE_FLAG=0) where coursesche0_.DELETE_FLAG=0 and coursesche0_.BEGIN_TIME>=? and coursesche0_.END_TIME<=? and coursesche1_.status=? and coursesche1_.DELETE_FLAG=0 and coursesche0_.DELETE_FLAG=0 order by coursesche0_.BEGIN_TIME asc 2020-05-05 12:04:08.499 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [1] as [TIMESTAMP] - [Tue May 05 00:00:00 CST 2020] 2020-05-05 12:04:08.499 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [2] as [TIMESTAMP] - [Tue May 05 23:59:59 CST 2020] 2020-05-05 12:04:08.499 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [3] as [SMALLINT] - [1] 2020-05-05 12:04:09.452 DEBUG org.hibernate.SQL - select count(1) as col_0_0_ from class_room classroom0_ where (classroom0_.name like ?) and classroom0_.CREATE_ID=? and classroom0_.DELETE_FLAG=0 2020-05-05 12:04:09.452 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [1] as [VARCHAR] - [%%] 2020-05-05 12:04:09.452 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [2] as [VARCHAR] - [40288a1261d106ba0161d1072e260000] 2020-05-05 12:04:09.453 DEBUG org.hibernate.SQL - select count(1) as col_0_0_ from class_room classroom0_ where (classroom0_.name like ?) and classroom0_.CREATE_ID=? and classroom0_.DELETE_FLAG=0 2020-05-05 12:04:09.453 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [1] as [VARCHAR] - [%%] 2020-05-05 12:04:09.453 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [2] as [VARCHAR] - [40288a1261d106ba0161d1072e260000] 2020-05-05 12:04:09.456 DEBUG org.hibernate.SQL - select classroom0_.ROOM_ID as ROOM_ID1_63_, classroom0_.address as address2_63_, classroom0_.CREATE_ID as CREATE_I3_63_, classroom0_.CREATE_TIME as CREATE_T4_63_, classroom0_.CREATOR as CREATOR5_63_, classroom0_.DELETE_FLAG as DELETE_F6_63_, classroom0_.name as name7_63_, classroom0_.ORG_ID as ORG_ID8_63_, classroom0_.status as status9_63_, classroom0_.UPDATE_ID as UPDATE_10_63_, classroom0_.UPDATE_TIME as UPDATE_11_63_, classroom0_.UPDATOR as UPDATOR12_63_ from class_room classroom0_ where (classroom0_.name like ?) and classroom0_.CREATE_ID=? and classroom0_.DELETE_FLAG=0 order by classroom0_.CREATE_TIME desc limit ? 2020-05-05 12:04:09.456 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [1] as [VARCHAR] - [%%] 2020-05-05 12:04:09.456 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [2] as [VARCHAR] - [40288a1261d106ba0161d1072e260000] 2020-05-05 12:04:13.617 DEBUG org.hibernate.SQL - select count(1) as col_0_0_ from class_room classroom0_ where (classroom0_.name like ?) and classroom0_.CREATE_ID=? and classroom0_.DELETE_FLAG=0 2020-05-05 12:04:13.617 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [1] as [VARCHAR] - [%%] 2020-05-05 12:04:13.618 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [2] as [VARCHAR] - [40288a1261d106ba0161d1072e260000] 2020-05-05 12:04:13.619 DEBUG org.hibernate.SQL - select count(1) as col_0_0_ from class_room classroom0_ where (classroom0_.name like ?) and classroom0_.CREATE_ID=? and classroom0_.DELETE_FLAG=0 2020-05-05 12:04:13.619 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [1] as [VARCHAR] - [%%] 2020-05-05 12:04:13.619 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [2] as [VARCHAR] - [40288a1261d106ba0161d1072e260000] 2020-05-05 12:04:13.622 DEBUG org.hibernate.SQL - select classroom0_.ROOM_ID as ROOM_ID1_63_, classroom0_.address as address2_63_, classroom0_.CREATE_ID as CREATE_I3_63_, classroom0_.CREATE_TIME as CREATE_T4_63_, classroom0_.CREATOR as CREATOR5_63_, classroom0_.DELETE_FLAG as DELETE_F6_63_, classroom0_.name as name7_63_, classroom0_.ORG_ID as ORG_ID8_63_, classroom0_.status as status9_63_, classroom0_.UPDATE_ID as UPDATE_10_63_, classroom0_.UPDATE_TIME as UPDATE_11_63_, classroom0_.UPDATOR as UPDATOR12_63_ from class_room classroom0_ where (classroom0_.name like ?) and classroom0_.CREATE_ID=? and classroom0_.DELETE_FLAG=0 order by classroom0_.CREATE_TIME desc limit ? 2020-05-05 12:04:13.622 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [1] as [VARCHAR] - [%%] 2020-05-05 12:04:13.622 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [2] as [VARCHAR] - [40288a1261d106ba0161d1072e260000] 2020-05-05 12:04:15.137 DEBUG org.hibernate.SQL - select count(1) as col_0_0_ from exam_room examroom0_ where examroom0_.CREATE_ID=? and examroom0_.room_id=? and examroom0_.DELETE_FLAG=0 2020-05-05 12:04:15.138 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [1] as [VARCHAR] - [40288a1261d106ba0161d1072e260000] 2020-05-05 12:04:15.138 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [2] as [VARCHAR] - [402881f271e2b26f0171e2d47e2e0001] 2020-05-05 12:04:15.139 DEBUG org.hibernate.SQL - select count(1) as col_0_0_ from exam_room examroom0_ where examroom0_.CREATE_ID=? and examroom0_.room_id=? and examroom0_.DELETE_FLAG=0 2020-05-05 12:04:15.140 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [1] as [VARCHAR] - [40288a1261d106ba0161d1072e260000] 2020-05-05 12:04:15.140 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [2] as [VARCHAR] - [402881f271e2b26f0171e2d47e2e0001] 2020-05-05 12:04:15.142 DEBUG org.hibernate.SQL - select examroom0_.examroom_id as examroom1_81_, examroom0_.CREATE_ID as CREATE_I2_81_, examroom0_.CREATE_TIME as CREATE_T3_81_, examroom0_.CREATOR as CREATOR4_81_, examroom0_.DELETE_FLAG as DELETE_F5_81_, examroom0_.examroom_name as examroom6_81_, examroom0_.room_id as room_id7_81_, examroom0_.room_name as room_nam8_81_, examroom0_.seats_num as seats_nu9_81_, examroom0_.status as status10_81_, examroom0_.UPDATE_ID as UPDATE_11_81_, examroom0_.UPDATE_TIME as UPDATE_12_81_, examroom0_.UPDATOR as UPDATOR13_81_ from exam_room examroom0_ where examroom0_.CREATE_ID=? and examroom0_.room_id=? and examroom0_.DELETE_FLAG=0 order by examroom0_.CREATE_TIME desc limit ? 2020-05-05 12:04:15.142 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [1] as [VARCHAR] - [40288a1261d106ba0161d1072e260000] 2020-05-05 12:04:15.142 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [2] as [VARCHAR] - [402881f271e2b26f0171e2d47e2e0001] 2020-05-05 12:04:25.198 DEBUG org.hibernate.SQL - select count(1) as col_0_0_ from exam_room examroom0_ where examroom0_.examroom_name=? and examroom0_.DELETE_FLAG=0 2020-05-05 12:04:25.198 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [1] as [VARCHAR] - [µÚ¶þ¿¼³¡] 2020-05-05 12:04:25.199 DEBUG org.hibernate.SQL - select count(1) as col_0_0_ from exam_room examroom0_ where examroom0_.examroom_name=? and examroom0_.DELETE_FLAG=0 2020-05-05 12:04:25.199 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [1] as [VARCHAR] - [µÚ¶þ¿¼³¡] 2020-05-05 12:04:25.203 DEBUG org.hibernate.SQL - insert into exam_room (CREATE_ID, CREATE_TIME, CREATOR, DELETE_FLAG, examroom_name, room_id, room_name, seats_num, status, UPDATE_ID, UPDATE_TIME, UPDATOR, examroom_id) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) 2020-05-05 12:04:25.203 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [1] as [VARCHAR] - [40288a1261d106ba0161d1072e260000] 2020-05-05 12:04:25.203 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [2] as [TIMESTAMP] - [Tue May 05 12:04:25 CST 2020] 2020-05-05 12:04:25.203 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [3] as [VARCHAR] - [¹ÜÀíÔ±] 2020-05-05 12:04:25.203 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [4] as [BOOLEAN] - [false] 2020-05-05 12:04:25.203 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [5] as [VARCHAR] - [µÚ¶þ¿¼³¡] 2020-05-05 12:04:25.204 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [6] as [VARCHAR] - [402881f271e2b26f0171e2d47e2e0001] 2020-05-05 12:04:25.204 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [7] as [VARCHAR] - [null] 2020-05-05 12:04:25.204 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [8] as [INTEGER] - [55] 2020-05-05 12:04:25.204 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [9] as [SMALLINT] - [1] 2020-05-05 12:04:25.204 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [10] as [VARCHAR] - [40288a1261d106ba0161d1072e260000] 2020-05-05 12:04:25.204 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [11] as [TIMESTAMP] - [Tue May 05 12:04:25 CST 2020] 2020-05-05 12:04:25.204 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [12] as [VARCHAR] - [¹ÜÀíÔ±] 2020-05-05 12:04:25.204 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [13] as [VARCHAR] - [ff80808171e2f6280171e30199f10001] 2020-05-05 12:04:25.234 DEBUG org.hibernate.SQL - select count(1) as col_0_0_ from exam_room examroom0_ where examroom0_.CREATE_ID=? and examroom0_.room_id=? and examroom0_.DELETE_FLAG=0 2020-05-05 12:04:25.234 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [1] as [VARCHAR] - [40288a1261d106ba0161d1072e260000] 2020-05-05 12:04:25.234 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [2] as [VARCHAR] - [402881f271e2b26f0171e2d47e2e0001] 2020-05-05 12:04:25.235 DEBUG org.hibernate.SQL - select count(1) as col_0_0_ from exam_room examroom0_ where examroom0_.CREATE_ID=? and examroom0_.room_id=? and examroom0_.DELETE_FLAG=0 2020-05-05 12:04:25.235 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [1] as [VARCHAR] - [40288a1261d106ba0161d1072e260000] 2020-05-05 12:04:25.235 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [2] as [VARCHAR] - [402881f271e2b26f0171e2d47e2e0001] 2020-05-05 12:04:25.237 DEBUG org.hibernate.SQL - select examroom0_.examroom_id as examroom1_81_, examroom0_.CREATE_ID as CREATE_I2_81_, examroom0_.CREATE_TIME as CREATE_T3_81_, examroom0_.CREATOR as CREATOR4_81_, examroom0_.DELETE_FLAG as DELETE_F5_81_, examroom0_.examroom_name as examroom6_81_, examroom0_.room_id as room_id7_81_, examroom0_.room_name as room_nam8_81_, examroom0_.seats_num as seats_nu9_81_, examroom0_.status as status10_81_, examroom0_.UPDATE_ID as UPDATE_11_81_, examroom0_.UPDATE_TIME as UPDATE_12_81_, examroom0_.UPDATOR as UPDATOR13_81_ from exam_room examroom0_ where examroom0_.CREATE_ID=? and examroom0_.room_id=? and examroom0_.DELETE_FLAG=0 order by examroom0_.CREATE_TIME desc limit ? 2020-05-05 12:04:25.238 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [1] as [VARCHAR] - [40288a1261d106ba0161d1072e260000] 2020-05-05 12:04:25.239 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [2] as [VARCHAR] - [402881f271e2b26f0171e2d47e2e0001] 2020-05-05 12:05:00.010 DEBUG org.hibernate.SQL - select exambatchi0_.EXAM_BATCH_ID as col_0_0_ from exam_batch_info exambatchi0_ cross join exam_info examinfo1_ where exambatchi0_.EXAM_ID=examinfo1_.EXAM_ID and exambatchi0_.START_TIME>=? and exambatchi0_.START_TIME=? and mediavideo0_.START_TIME=? and coursesche0_.END_TIME<=? and coursesche1_.status=? and coursesche1_.DELETE_FLAG=0 and coursesche0_.DELETE_FLAG=0 2020-05-05 12:06:45.495 DEBUG org.hibernate.SQL - select day(coursesche0_.BEGIN_TIME) as col_0_0_ from course_schedule_detail coursesche0_ left outer join course_schedule coursesche1_ on coursesche0_.SCHEDULE_ID=coursesche1_.SCHEDULE_ID where coursesche0_.DELETE_FLAG=0 and coursesche0_.BEGIN_TIME>=? and coursesche0_.END_TIME<=? and coursesche1_.status=? and coursesche1_.DELETE_FLAG=0 group by day(coursesche0_.BEGIN_TIME) limit ? 2020-05-05 12:06:45.512 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [1] as [TIMESTAMP] - [Tue May 05 00:00:00 CST 2020] 2020-05-05 12:06:45.512 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [1] as [TIMESTAMP] - [Fri May 01 00:00:00 CST 2020] 2020-05-05 12:06:45.513 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [2] as [TIMESTAMP] - [Tue May 05 23:59:59 CST 2020] 2020-05-05 12:06:45.513 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [2] as [TIMESTAMP] - [Sun May 31 23:59:59 CST 2020] 2020-05-05 12:06:45.513 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [3] as [SMALLINT] - [1] 2020-05-05 12:06:45.513 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [3] as [SMALLINT] - [1] 2020-05-05 12:06:45.532 DEBUG org.hibernate.SQL - select count(1) as col_0_0_ from course_schedule_detail coursesche0_ left outer join course_schedule coursesche1_ on coursesche0_.SCHEDULE_ID=coursesche1_.SCHEDULE_ID where coursesche0_.DELETE_FLAG=0 and coursesche0_.BEGIN_TIME>=? and coursesche0_.END_TIME<=? and coursesche1_.status=? and coursesche1_.DELETE_FLAG=0 and coursesche0_.DELETE_FLAG=0 2020-05-05 12:06:45.532 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [1] as [TIMESTAMP] - [Tue May 05 00:00:00 CST 2020] 2020-05-05 12:06:45.532 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [2] as [TIMESTAMP] - [Tue May 05 23:59:59 CST 2020] 2020-05-05 12:06:45.532 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [3] as [SMALLINT] - [1] 2020-05-05 12:06:45.545 DEBUG org.hibernate.SQL - select coursesche0_.DETAIL_ID as DETAIL_I1_69_0_, coursesche1_.SCHEDULE_ID as SCHEDULE1_68_1_, subject2_.SUBJECT_ID as SUBJECT_1_54_2_, classroom3_.ROOM_ID as ROOM_ID1_63_3_, clsclass5_.CLASS_ID as CLASS_ID1_64_4_, coursesche0_.BEGIN_TIME as BEGIN_TI2_69_0_, coursesche0_.SCHEDULE_ID as SCHEDULE8_69_0_, coursesche0_.CREATE_ID as CREATE_I3_69_0_, coursesche0_.CREATE_TIME as CREATE_T4_69_0_, coursesche0_.CREATOR as CREATOR5_69_0_, coursesche0_.DELETE_FLAG as DELETE_F6_69_0_, coursesche0_.END_TIME as END_TIME7_69_0_, coursesche0_.UPDATE_ID as UPDATE_I9_69_0_, coursesche0_.UPDATE_TIME as UPDATE_10_69_0_, coursesche0_.UPDATOR as UPDATOR11_69_0_, coursesche1_.BEGIN_TIME as BEGIN_TI2_68_1_, coursesche1_.ROOM_ID as ROOM_ID13_68_1_, coursesche1_.CREATE_ID as CREATE_I3_68_1_, coursesche1_.CREATE_TIME as CREATE_T4_68_1_, coursesche1_.CREATOR as CREATOR5_68_1_, coursesche1_.DELETE_FLAG as DELETE_F6_68_1_, coursesche1_.END_TIME as END_TIME7_68_1_, coursesche1_.FRI_TIME as FRI_TIME8_68_1_, coursesche1_.mark as mark9_68_1_, coursesche1_.MON_TIME as MON_TIM10_68_1_, coursesche1_.OPEN_FLAG as OPEN_FL11_68_1_, coursesche1_.ORG_ID as ORG_ID12_68_1_, coursesche1_.SAT_TIME as SAT_TIM14_68_1_, coursesche1_.status as status15_68_1_, coursesche1_.SUBJECT_ID as SUBJECT16_68_1_, coursesche1_.SUM_TIME as SUM_TIM17_68_1_, coursesche1_.TEACHER_ID as TEACHER18_68_1_, coursesche1_.TEACHER_NAME as TEACHER19_68_1_, coursesche1_.THU_TIME as THU_TIM20_68_1_, coursesche1_.TUE_TIME as TUE_TIM21_68_1_, coursesche1_.type as type22_68_1_, coursesche1_.UPDATE_ID as UPDATE_23_68_1_, coursesche1_.UPDATE_TIME as UPDATE_24_68_1_, coursesche1_.UPDATOR as UPDATOR25_68_1_, coursesche1_.WED_TIME as WED_TIM26_68_1_, subject2_.CODE as CODE2_54_2_, subject2_.CONTENT_FILE_ID as CONTENT_3_54_2_, subject2_.COURSE_ID as COURSE_I4_54_2_, subject2_.COVER_PAGE_FILE_ID as COVER_PA5_54_2_, subject2_.COVER_PAGE_URL as COVER_PA6_54_2_, subject2_.CREATE_ID as CREATE_I7_54_2_, subject2_.CREATE_TIME as CREATE_T8_54_2_, subject2_.CREATOR as CREATOR9_54_2_, subject2_.DELETE_FLAG as DELETE_10_54_2_, subject2_.FULL_NAME as FULL_NA11_54_2_, subject2_.LECTURE_COUNT as LECTURE12_54_2_, subject2_.NAME as NAME13_54_2_, subject2_.ORDER_NUM as ORDER_N14_54_2_, subject2_.ORG_ID as ORG_ID15_54_2_, subject2_.ORIG_COPY_SUBJECT_ID as ORIG_CO16_54_2_, subject2_.ORIG_SUBJECT_ID as ORIG_SU17_54_2_, subject2_.SCHOOL_YEAR as SCHOOL_18_54_2_, subject2_.STATUS as STATUS19_54_2_, subject2_.TEACHER_ID as TEACHER20_54_2_, subject2_.TEACHER_NAME as TEACHER21_54_2_, subject2_.TERM as TERM22_54_2_, subject2_.TYPE as TYPE23_54_2_, subject2_.UPDATE_ID as UPDATE_24_54_2_, subject2_.UPDATE_TIME as UPDATE_25_54_2_, subject2_.UPDATOR as UPDATOR26_54_2_, classroom3_.address as address2_63_3_, classroom3_.CREATE_ID as CREATE_I3_63_3_, classroom3_.CREATE_TIME as CREATE_T4_63_3_, classroom3_.CREATOR as CREATOR5_63_3_, classroom3_.DELETE_FLAG as DELETE_F6_63_3_, classroom3_.name as name7_63_3_, classroom3_.ORG_ID as ORG_ID8_63_3_, classroom3_.status as status9_63_3_, classroom3_.UPDATE_ID as UPDATE_10_63_3_, classroom3_.UPDATE_TIME as UPDATE_11_63_3_, classroom3_.UPDATOR as UPDATOR12_63_3_, clsclass5_.ADDRESS as ADDRESS2_64_4_, clsclass5_.ADDRESS_ID as ADDRESS_3_64_4_, clsclass5_.ADVANTAGE as ADVANTAG4_64_4_, clsclass5_.ARRANGEMENT as ARRANGEM5_64_4_, clsclass5_.CAN_MULTI_EXER as CAN_MULT6_64_4_, clsclass5_.CITY as CITY7_64_4_, clsclass5_.CLASS_CHARGER as CLASS_CH8_64_4_, clsclass5_.CLASS_CHARGER_ID as CLASS_CH9_64_4_, clsclass5_.CLASS_NUMBER as CLASS_N10_64_4_, clsclass5_.CLASS_TYPES as CLASS_T11_64_4_, clsclass5_.CLICK_NUM as CLICK_N12_64_4_, clsclass5_.CODE as CODE13_64_4_, clsclass5_.COLLEGE_COURSE_ID as COLLEGE14_64_4_, clsclass5_.COLLEGE_COURSE_NAME as COLLEGE15_64_4_, clsclass5_.COMMENT_COUNT as COMMENT16_64_4_, clsclass5_.COURSE_ID as COURSE_17_64_4_, clsclass5_.CREATE_ID as CREATE_18_64_4_, clsclass5_.CREATE_TIME as CREATE_19_64_4_, clsclass5_.CREATOR as CREATOR20_64_4_, clsclass5_.DELETE_FLAG as DELETE_21_64_4_, clsclass5_.DISCOUNT as DISCOUN22_64_4_, clsclass5_.DISPRICE as DISPRIC23_64_4_, clsclass5_.END_TIME as END_TIM24_64_4_, clsclass5_.EXTENDED as EXTENDE25_64_4_, clsclass5_.FULL_TEXT as FULL_TE26_64_4_, clsclass5_.GOOD_ID as GOOD_ID27_64_4_, clsclass5_.HAVA_AWARD as HAVA_AW28_64_4_, clsclass5_.HAVE_HANDOUT as HAVE_HA29_64_4_, clsclass5_.HAVE_LIVE as HAVE_LI30_64_4_, clsclass5_.HAVE_VIDEO as HAVE_VI31_64_4_, clsclass5_.IMG_PATH as IMG_PAT32_64_4_, clsclass5_.LATITUDE_Y as LATITUD33_64_4_, clsclass5_.LONGITUDE_X as LONGITU34_64_4_, clsclass5_.MODE as MODE35_64_4_, clsclass5_.NAME as NAME36_64_4_, clsclass5_.NEED_FORUM as NEED_FO37_64_4_, clsclass5_.NEED_JOIN_AUDIT as NEED_JO38_64_4_, clsclass5_.NEED_QUIT_AUDIT as NEED_QU39_64_4_, clsclass5_.ORG_ID as ORG_ID40_64_4_, clsclass5_.PAYMENT_NUM as PAYMENT41_64_4_, clsclass5_.POINTER as POINTER42_64_4_, clsclass5_.PRICE as PRICE43_64_4_, clsclass5_.PRODUCT_ID as PRODUCT44_64_4_, clsclass5_.PROGRESS as PROGRES45_64_4_, clsclass5_.PROVINCE as PROVINC46_64_4_, clsclass5_.RECOMMEND as RECOMME47_64_4_, clsclass5_.REGION as REGION48_64_4_, clsclass5_.SCORE as SCORE49_64_4_, clsclass5_.SHOU_ANALYSIS_AFTER_EXER as SHOU_AN50_64_4_, clsclass5_.START_TIME as START_T51_64_4_, clsclass5_.STU_ALL_COUNT as STU_ALL52_64_4_, clsclass5_.STUDENT_COUNT as STUDENT53_64_4_, clsclass5_.STUDY_TIME as STUDY_T54_64_4_, clsclass5_.TEACHER_ID as TEACHER55_64_4_, clsclass5_.TOP_FLAG as TOP_FLA56_64_4_, clsclass5_.UPDATE_ID as UPDATE_57_64_4_, clsclass5_.UPDATE_TIME as UPDATE_58_64_4_, clsclass5_.UPDATOR as UPDATOR59_64_4_, classes4_.SCHEDULE_ID as SCHEDULE1_68_0__, classes4_.CLASS_ID as CLASS_ID2_1_0__, classes4_.RE_ID as RE_ID3_0__ from course_schedule_detail coursesche0_ left outer join course_schedule coursesche1_ on coursesche0_.SCHEDULE_ID=coursesche1_.SCHEDULE_ID left outer join SUBJECT subject2_ on coursesche1_.SUBJECT_ID=subject2_.SUBJECT_ID left outer join class_room classroom3_ on coursesche1_.ROOM_ID=classroom3_.ROOM_ID left outer join COURSE_SCHEDULE_RE_CLS classes4_ on coursesche1_.SCHEDULE_ID=classes4_.SCHEDULE_ID left outer join cls_class clsclass5_ on classes4_.CLASS_ID=clsclass5_.CLASS_ID and ( clsclass5_.DELETE_FLAG=0) where coursesche0_.DELETE_FLAG=0 and coursesche0_.BEGIN_TIME>=? and coursesche0_.END_TIME<=? and coursesche1_.status=? and coursesche1_.DELETE_FLAG=0 and coursesche0_.DELETE_FLAG=0 order by coursesche0_.BEGIN_TIME asc 2020-05-05 12:06:45.546 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [1] as [TIMESTAMP] - [Tue May 05 00:00:00 CST 2020] 2020-05-05 12:06:45.546 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [2] as [TIMESTAMP] - [Tue May 05 23:59:59 CST 2020] 2020-05-05 12:06:45.546 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [3] as [SMALLINT] - [1] 2020-05-05 12:06:48.138 DEBUG org.hibernate.SQL - select count(1) as col_0_0_ from course_schedule_detail coursesche0_ left outer join course_schedule coursesche1_ on coursesche0_.SCHEDULE_ID=coursesche1_.SCHEDULE_ID where coursesche0_.DELETE_FLAG=0 and coursesche0_.BEGIN_TIME>=? and coursesche0_.END_TIME<=? and coursesche1_.status=? and coursesche1_.DELETE_FLAG=0 and coursesche0_.DELETE_FLAG=0 2020-05-05 12:06:48.138 DEBUG org.hibernate.SQL - select day(coursesche0_.BEGIN_TIME) as col_0_0_ from course_schedule_detail coursesche0_ left outer join course_schedule coursesche1_ on coursesche0_.SCHEDULE_ID=coursesche1_.SCHEDULE_ID where coursesche0_.DELETE_FLAG=0 and coursesche0_.BEGIN_TIME>=? and coursesche0_.END_TIME<=? and coursesche1_.status=? and coursesche1_.DELETE_FLAG=0 group by day(coursesche0_.BEGIN_TIME) limit ? 2020-05-05 12:06:48.138 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [1] as [TIMESTAMP] - [Fri May 01 00:00:00 CST 2020] 2020-05-05 12:06:48.138 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [1] as [TIMESTAMP] - [Tue May 05 00:00:00 CST 2020] 2020-05-05 12:06:48.139 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [2] as [TIMESTAMP] - [Sun May 31 23:59:59 CST 2020] 2020-05-05 12:06:48.139 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [2] as [TIMESTAMP] - [Tue May 05 23:59:59 CST 2020] 2020-05-05 12:06:48.139 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [3] as [SMALLINT] - [1] 2020-05-05 12:06:48.139 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [3] as [SMALLINT] - [1] 2020-05-05 12:06:48.142 DEBUG org.hibernate.SQL - select count(1) as col_0_0_ from course_schedule_detail coursesche0_ left outer join course_schedule coursesche1_ on coursesche0_.SCHEDULE_ID=coursesche1_.SCHEDULE_ID where coursesche0_.DELETE_FLAG=0 and coursesche0_.BEGIN_TIME>=? and coursesche0_.END_TIME<=? and coursesche1_.status=? and coursesche1_.DELETE_FLAG=0 and coursesche0_.DELETE_FLAG=0 2020-05-05 12:06:48.142 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [1] as [TIMESTAMP] - [Tue May 05 00:00:00 CST 2020] 2020-05-05 12:06:48.142 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [2] as [TIMESTAMP] - [Tue May 05 23:59:59 CST 2020] 2020-05-05 12:06:48.142 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [3] as [SMALLINT] - [1] 2020-05-05 12:06:48.146 DEBUG org.hibernate.SQL - select coursesche0_.DETAIL_ID as DETAIL_I1_69_0_, coursesche1_.SCHEDULE_ID as SCHEDULE1_68_1_, subject2_.SUBJECT_ID as SUBJECT_1_54_2_, classroom3_.ROOM_ID as ROOM_ID1_63_3_, clsclass5_.CLASS_ID as CLASS_ID1_64_4_, coursesche0_.BEGIN_TIME as BEGIN_TI2_69_0_, coursesche0_.SCHEDULE_ID as SCHEDULE8_69_0_, coursesche0_.CREATE_ID as CREATE_I3_69_0_, coursesche0_.CREATE_TIME as CREATE_T4_69_0_, coursesche0_.CREATOR as CREATOR5_69_0_, coursesche0_.DELETE_FLAG as DELETE_F6_69_0_, coursesche0_.END_TIME as END_TIME7_69_0_, coursesche0_.UPDATE_ID as UPDATE_I9_69_0_, coursesche0_.UPDATE_TIME as UPDATE_10_69_0_, coursesche0_.UPDATOR as UPDATOR11_69_0_, coursesche1_.BEGIN_TIME as BEGIN_TI2_68_1_, coursesche1_.ROOM_ID as ROOM_ID13_68_1_, coursesche1_.CREATE_ID as CREATE_I3_68_1_, coursesche1_.CREATE_TIME as CREATE_T4_68_1_, coursesche1_.CREATOR as CREATOR5_68_1_, coursesche1_.DELETE_FLAG as DELETE_F6_68_1_, coursesche1_.END_TIME as END_TIME7_68_1_, coursesche1_.FRI_TIME as FRI_TIME8_68_1_, coursesche1_.mark as mark9_68_1_, coursesche1_.MON_TIME as MON_TIM10_68_1_, coursesche1_.OPEN_FLAG as OPEN_FL11_68_1_, coursesche1_.ORG_ID as ORG_ID12_68_1_, coursesche1_.SAT_TIME as SAT_TIM14_68_1_, coursesche1_.status as status15_68_1_, coursesche1_.SUBJECT_ID as SUBJECT16_68_1_, coursesche1_.SUM_TIME as SUM_TIM17_68_1_, coursesche1_.TEACHER_ID as TEACHER18_68_1_, coursesche1_.TEACHER_NAME as TEACHER19_68_1_, coursesche1_.THU_TIME as THU_TIM20_68_1_, coursesche1_.TUE_TIME as TUE_TIM21_68_1_, coursesche1_.type as type22_68_1_, coursesche1_.UPDATE_ID as UPDATE_23_68_1_, coursesche1_.UPDATE_TIME as UPDATE_24_68_1_, coursesche1_.UPDATOR as UPDATOR25_68_1_, coursesche1_.WED_TIME as WED_TIM26_68_1_, subject2_.CODE as CODE2_54_2_, subject2_.CONTENT_FILE_ID as CONTENT_3_54_2_, subject2_.COURSE_ID as COURSE_I4_54_2_, subject2_.COVER_PAGE_FILE_ID as COVER_PA5_54_2_, subject2_.COVER_PAGE_URL as COVER_PA6_54_2_, subject2_.CREATE_ID as CREATE_I7_54_2_, subject2_.CREATE_TIME as CREATE_T8_54_2_, subject2_.CREATOR as CREATOR9_54_2_, subject2_.DELETE_FLAG as DELETE_10_54_2_, subject2_.FULL_NAME as FULL_NA11_54_2_, subject2_.LECTURE_COUNT as LECTURE12_54_2_, subject2_.NAME as NAME13_54_2_, subject2_.ORDER_NUM as ORDER_N14_54_2_, subject2_.ORG_ID as ORG_ID15_54_2_, subject2_.ORIG_COPY_SUBJECT_ID as ORIG_CO16_54_2_, subject2_.ORIG_SUBJECT_ID as ORIG_SU17_54_2_, subject2_.SCHOOL_YEAR as SCHOOL_18_54_2_, subject2_.STATUS as STATUS19_54_2_, subject2_.TEACHER_ID as TEACHER20_54_2_, subject2_.TEACHER_NAME as TEACHER21_54_2_, subject2_.TERM as TERM22_54_2_, subject2_.TYPE as TYPE23_54_2_, subject2_.UPDATE_ID as UPDATE_24_54_2_, subject2_.UPDATE_TIME as UPDATE_25_54_2_, subject2_.UPDATOR as UPDATOR26_54_2_, classroom3_.address as address2_63_3_, classroom3_.CREATE_ID as CREATE_I3_63_3_, classroom3_.CREATE_TIME as CREATE_T4_63_3_, classroom3_.CREATOR as CREATOR5_63_3_, classroom3_.DELETE_FLAG as DELETE_F6_63_3_, classroom3_.name as name7_63_3_, classroom3_.ORG_ID as ORG_ID8_63_3_, classroom3_.status as status9_63_3_, classroom3_.UPDATE_ID as UPDATE_10_63_3_, classroom3_.UPDATE_TIME as UPDATE_11_63_3_, classroom3_.UPDATOR as UPDATOR12_63_3_, clsclass5_.ADDRESS as ADDRESS2_64_4_, clsclass5_.ADDRESS_ID as ADDRESS_3_64_4_, clsclass5_.ADVANTAGE as ADVANTAG4_64_4_, clsclass5_.ARRANGEMENT as ARRANGEM5_64_4_, clsclass5_.CAN_MULTI_EXER as CAN_MULT6_64_4_, clsclass5_.CITY as CITY7_64_4_, clsclass5_.CLASS_CHARGER as CLASS_CH8_64_4_, clsclass5_.CLASS_CHARGER_ID as CLASS_CH9_64_4_, clsclass5_.CLASS_NUMBER as CLASS_N10_64_4_, clsclass5_.CLASS_TYPES as CLASS_T11_64_4_, clsclass5_.CLICK_NUM as CLICK_N12_64_4_, clsclass5_.CODE as CODE13_64_4_, clsclass5_.COLLEGE_COURSE_ID as COLLEGE14_64_4_, clsclass5_.COLLEGE_COURSE_NAME as COLLEGE15_64_4_, clsclass5_.COMMENT_COUNT as COMMENT16_64_4_, clsclass5_.COURSE_ID as COURSE_17_64_4_, clsclass5_.CREATE_ID as CREATE_18_64_4_, clsclass5_.CREATE_TIME as CREATE_19_64_4_, clsclass5_.CREATOR as CREATOR20_64_4_, clsclass5_.DELETE_FLAG as DELETE_21_64_4_, clsclass5_.DISCOUNT as DISCOUN22_64_4_, clsclass5_.DISPRICE as DISPRIC23_64_4_, clsclass5_.END_TIME as END_TIM24_64_4_, clsclass5_.EXTENDED as EXTENDE25_64_4_, clsclass5_.FULL_TEXT as FULL_TE26_64_4_, clsclass5_.GOOD_ID as GOOD_ID27_64_4_, clsclass5_.HAVA_AWARD as HAVA_AW28_64_4_, clsclass5_.HAVE_HANDOUT as HAVE_HA29_64_4_, clsclass5_.HAVE_LIVE as HAVE_LI30_64_4_, clsclass5_.HAVE_VIDEO as HAVE_VI31_64_4_, clsclass5_.IMG_PATH as IMG_PAT32_64_4_, clsclass5_.LATITUDE_Y as LATITUD33_64_4_, clsclass5_.LONGITUDE_X as LONGITU34_64_4_, clsclass5_.MODE as MODE35_64_4_, clsclass5_.NAME as NAME36_64_4_, clsclass5_.NEED_FORUM as NEED_FO37_64_4_, clsclass5_.NEED_JOIN_AUDIT as NEED_JO38_64_4_, clsclass5_.NEED_QUIT_AUDIT as NEED_QU39_64_4_, clsclass5_.ORG_ID as ORG_ID40_64_4_, clsclass5_.PAYMENT_NUM as PAYMENT41_64_4_, clsclass5_.POINTER as POINTER42_64_4_, clsclass5_.PRICE as PRICE43_64_4_, clsclass5_.PRODUCT_ID as PRODUCT44_64_4_, clsclass5_.PROGRESS as PROGRES45_64_4_, clsclass5_.PROVINCE as PROVINC46_64_4_, clsclass5_.RECOMMEND as RECOMME47_64_4_, clsclass5_.REGION as REGION48_64_4_, clsclass5_.SCORE as SCORE49_64_4_, clsclass5_.SHOU_ANALYSIS_AFTER_EXER as SHOU_AN50_64_4_, clsclass5_.START_TIME as START_T51_64_4_, clsclass5_.STU_ALL_COUNT as STU_ALL52_64_4_, clsclass5_.STUDENT_COUNT as STUDENT53_64_4_, clsclass5_.STUDY_TIME as STUDY_T54_64_4_, clsclass5_.TEACHER_ID as TEACHER55_64_4_, clsclass5_.TOP_FLAG as TOP_FLA56_64_4_, clsclass5_.UPDATE_ID as UPDATE_57_64_4_, clsclass5_.UPDATE_TIME as UPDATE_58_64_4_, clsclass5_.UPDATOR as UPDATOR59_64_4_, classes4_.SCHEDULE_ID as SCHEDULE1_68_0__, classes4_.CLASS_ID as CLASS_ID2_1_0__, classes4_.RE_ID as RE_ID3_0__ from course_schedule_detail coursesche0_ left outer join course_schedule coursesche1_ on coursesche0_.SCHEDULE_ID=coursesche1_.SCHEDULE_ID left outer join SUBJECT subject2_ on coursesche1_.SUBJECT_ID=subject2_.SUBJECT_ID left outer join class_room classroom3_ on coursesche1_.ROOM_ID=classroom3_.ROOM_ID left outer join COURSE_SCHEDULE_RE_CLS classes4_ on coursesche1_.SCHEDULE_ID=classes4_.SCHEDULE_ID left outer join cls_class clsclass5_ on classes4_.CLASS_ID=clsclass5_.CLASS_ID and ( clsclass5_.DELETE_FLAG=0) where coursesche0_.DELETE_FLAG=0 and coursesche0_.BEGIN_TIME>=? and coursesche0_.END_TIME<=? and coursesche1_.status=? and coursesche1_.DELETE_FLAG=0 and coursesche0_.DELETE_FLAG=0 order by coursesche0_.BEGIN_TIME asc 2020-05-05 12:06:48.148 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [1] as [TIMESTAMP] - [Tue May 05 00:00:00 CST 2020] 2020-05-05 12:06:48.148 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [2] as [TIMESTAMP] - [Tue May 05 23:59:59 CST 2020] 2020-05-05 12:06:48.148 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [3] as [SMALLINT] - [1] 2020-05-05 12:06:49.452 DEBUG org.hibernate.SQL - select count(1) as col_0_0_ from class_room classroom0_ where (classroom0_.name like ?) and classroom0_.CREATE_ID=? and classroom0_.DELETE_FLAG=0 2020-05-05 12:06:49.453 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [1] as [VARCHAR] - [%%] 2020-05-05 12:06:49.453 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [2] as [VARCHAR] - [40288a1261d106ba0161d1072e260000] 2020-05-05 12:06:49.455 DEBUG org.hibernate.SQL - select count(1) as col_0_0_ from class_room classroom0_ where (classroom0_.name like ?) and classroom0_.CREATE_ID=? and classroom0_.DELETE_FLAG=0 2020-05-05 12:06:49.455 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [1] as [VARCHAR] - [%%] 2020-05-05 12:06:49.455 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [2] as [VARCHAR] - [40288a1261d106ba0161d1072e260000] 2020-05-05 12:06:49.458 DEBUG org.hibernate.SQL - select classroom0_.ROOM_ID as ROOM_ID1_63_, classroom0_.address as address2_63_, classroom0_.CREATE_ID as CREATE_I3_63_, classroom0_.CREATE_TIME as CREATE_T4_63_, classroom0_.CREATOR as CREATOR5_63_, classroom0_.DELETE_FLAG as DELETE_F6_63_, classroom0_.name as name7_63_, classroom0_.ORG_ID as ORG_ID8_63_, classroom0_.status as status9_63_, classroom0_.UPDATE_ID as UPDATE_10_63_, classroom0_.UPDATE_TIME as UPDATE_11_63_, classroom0_.UPDATOR as UPDATOR12_63_ from class_room classroom0_ where (classroom0_.name like ?) and classroom0_.CREATE_ID=? and classroom0_.DELETE_FLAG=0 order by classroom0_.CREATE_TIME desc limit ? 2020-05-05 12:06:49.459 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [1] as [VARCHAR] - [%%] 2020-05-05 12:06:49.459 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [2] as [VARCHAR] - [40288a1261d106ba0161d1072e260000] 2020-05-05 12:06:51.228 DEBUG org.hibernate.SQL - select count(1) as col_0_0_ from exam_room examroom0_ where examroom0_.CREATE_ID=? and examroom0_.room_id=? and examroom0_.DELETE_FLAG=0 2020-05-05 12:06:51.229 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [1] as [VARCHAR] - [40288a1261d106ba0161d1072e260000] 2020-05-05 12:06:51.229 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [2] as [VARCHAR] - [402881f271e2b26f0171e2d47e2e0001] 2020-05-05 12:06:51.234 DEBUG org.hibernate.SQL - select count(1) as col_0_0_ from exam_room examroom0_ where examroom0_.CREATE_ID=? and examroom0_.room_id=? and examroom0_.DELETE_FLAG=0 2020-05-05 12:06:51.234 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [1] as [VARCHAR] - [40288a1261d106ba0161d1072e260000] 2020-05-05 12:06:51.234 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [2] as [VARCHAR] - [402881f271e2b26f0171e2d47e2e0001] 2020-05-05 12:06:51.238 DEBUG org.hibernate.SQL - select examroom0_.examroom_id as examroom1_81_, examroom0_.CREATE_ID as CREATE_I2_81_, examroom0_.CREATE_TIME as CREATE_T3_81_, examroom0_.CREATOR as CREATOR4_81_, examroom0_.DELETE_FLAG as DELETE_F5_81_, examroom0_.examroom_name as examroom6_81_, examroom0_.room_id as room_id7_81_, examroom0_.room_name as room_nam8_81_, examroom0_.seats_num as seats_nu9_81_, examroom0_.status as status10_81_, examroom0_.UPDATE_ID as UPDATE_11_81_, examroom0_.UPDATE_TIME as UPDATE_12_81_, examroom0_.UPDATOR as UPDATOR13_81_ from exam_room examroom0_ where examroom0_.CREATE_ID=? and examroom0_.room_id=? and examroom0_.DELETE_FLAG=0 order by examroom0_.CREATE_TIME desc limit ? 2020-05-05 12:06:51.239 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [1] as [VARCHAR] - [40288a1261d106ba0161d1072e260000] 2020-05-05 12:06:51.239 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [2] as [VARCHAR] - [402881f271e2b26f0171e2d47e2e0001] 2020-05-05 12:07:29.247 DEBUG org.hibernate.SQL - select count(1) as col_0_0_ from exam_room examroom0_ where examroom0_.CREATE_ID=? and examroom0_.room_id=? and examroom0_.DELETE_FLAG=0 2020-05-05 12:07:29.249 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [1] as [VARCHAR] - [40288a1261d106ba0161d1072e260000] 2020-05-05 12:07:29.249 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [2] as [VARCHAR] - [402881f271e2b26f0171e2d47e2e0001] 2020-05-05 12:07:29.250 DEBUG org.hibernate.SQL - select count(1) as col_0_0_ from exam_room examroom0_ where examroom0_.CREATE_ID=? and examroom0_.room_id=? and examroom0_.DELETE_FLAG=0 2020-05-05 12:07:29.250 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [1] as [VARCHAR] - [40288a1261d106ba0161d1072e260000] 2020-05-05 12:07:29.251 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [2] as [VARCHAR] - [402881f271e2b26f0171e2d47e2e0001] 2020-05-05 12:07:29.253 DEBUG org.hibernate.SQL - select examroom0_.examroom_id as examroom1_81_, examroom0_.CREATE_ID as CREATE_I2_81_, examroom0_.CREATE_TIME as CREATE_T3_81_, examroom0_.CREATOR as CREATOR4_81_, examroom0_.DELETE_FLAG as DELETE_F5_81_, examroom0_.examroom_name as examroom6_81_, examroom0_.room_id as room_id7_81_, examroom0_.room_name as room_nam8_81_, examroom0_.seats_num as seats_nu9_81_, examroom0_.status as status10_81_, examroom0_.UPDATE_ID as UPDATE_11_81_, examroom0_.UPDATE_TIME as UPDATE_12_81_, examroom0_.UPDATOR as UPDATOR13_81_ from exam_room examroom0_ where examroom0_.CREATE_ID=? and examroom0_.room_id=? and examroom0_.DELETE_FLAG=0 order by examroom0_.CREATE_TIME desc limit ? 2020-05-05 12:07:29.253 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [1] as [VARCHAR] - [40288a1261d106ba0161d1072e260000] 2020-05-05 12:07:29.254 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [2] as [VARCHAR] - [402881f271e2b26f0171e2d47e2e0001]