queryByPage === SELECT @pageTag(){ * @} FROM event_log WHERE 1=1 queryById === SELECT el.*, a.apply_name apply_name, e.event_name event_name FROM event_log el LEFT JOIN `event` e on el.event_id = e.id LEFT JOIN `apply` a on el.apply_id = a.uuid WHERE 1=1 @if(!isEmpty(id)){ and el.id=#id# @} ORDER BY el.id queryByPage2 === SELECT @pageTag(){ el.*, a.apply_name apply_name, e.event_name event_name @} FROM event_log el LEFT JOIN `event` e on el.event_id = e.id LEFT JOIN `apply` a on el.apply_id = a.uuid WHERE 1=1 @if(!isEmpty(applyId)){ and a.uuid=#applyId# @} @if(!isEmpty(eventId)){ and e.id=#eventId# @} @if(!isEmpty(applyName)){ and a.apply_name like #applyName# @} @if(!isEmpty(eventName)){ and e.event_name like #eventName# @} ORDER BY el.id