<#list cols as col> ${tableName} <#list cols as col> ${col.name}<#if col_has_next>, <#list cols as col> <#if (col.name != "id")> ${col.name} = <#noparse>#{entity.${col.fieldName}<#noparse>}<#if col_has_next>, <#list cols as col> <#if (col.name != "create_time" && col.name != "update_time" && col.name != "delete_status" )> and ${col.name} = <#noparse>#{terms.${col.fieldName}<#noparse>} <#if (col.name == "create_time")> and DATE_FORMAT(${col.name},'%Y-%m-%d') = <#noparse>#{terms.${col.fieldName}<#noparse>} and (DATE_FORMAT(${col.name},'%Y-%m-%d') = ]]> <#noparse>#{terms.createStart<#noparse>} and DATE_FORMAT(${col.name},'%Y-%m-%d') <#noparse>#{terms.createEnd<#noparse>}) <#if (col.name == "update_time")> and DATE_FORMAT(${col.name},'%Y-%m-%d') = <#noparse>#{terms.${col.fieldName}<#noparse>} and (DATE_FORMAT(${col.name},'%Y-%m-%d') = ]]> <#noparse>#{terms.updateStart<#noparse>} and DATE_FORMAT(${col.name},'%Y-%m-%d') <#noparse>#{terms.updateEnd<#noparse>}) <#if (col.name == "delete_status")> and delete_status = 0 and ${col.name} = <#noparse>#{terms.${col.fieldName}<#noparse>} update id = <#noparse>#{entity.id<#noparse>} update delete from where id = <#noparse>#{id<#noparse>} select from select COUNT(1) from SELECT FROM isnull<#noparse>(${s.property<#noparse>}), ${s.property<#noparse>} <#noparse>${s.direction<#noparse>} order by isnull(create_time), create_time desc limit <#noparse>#{page.offset<#noparse>}, <#noparse>#{page.size<#noparse>}