id_, paper_base_id_, user_id_, user_name_, start_time_, end_time_, answer_time_, total_score_, status_, memo_, create_by_, create_org_id_, create_time_, update_by_, update_time_ SELECT d.*,q.* FROM exam_imitate_record_detail d LEFT JOIN exam_questions_info q on q.id_ = d.question_id_ WHERE d.record_id_ = #{vo.recordId} order by d.create_time_ asc SELECT b.total_score_ as score,COALESCE ( s.total_score_, 0 ) as total_score_,s.* ,b.name_ as paperName,b.total_number_,sp.time_length_ FROM exam_imitate_record s LEFT JOIN exam_paper_setting sp ON sp.paper_id_ = s.paper_base_id_ LEFT JOIN exam_paper_base b ON b.id_ = s.paper_base_id_ ${ew.customSqlSegment} SELECT q.*,q.id_ as questionId,d.* FROM exam_imitate_record_detail d LEFT JOIN exam_imitate_record r ON r.id_ = d.record_id_ LEFT JOIN exam_questions_info q ON q.id_ = d.question_id_ WHERE r.id_ = #{id} AND d.is_right_ = '0' and q.is_dele_ ='0'