select distinct
    id,
    member_id,
    agent_id,
    agent_avatar,
    agent_title,
    agent_desc,
    agent_system,
    agent_publish_status,
    publish_time,
    preamble,
    featured_questions,
    communication_turn,
    continuous_question_status,
    continuous_question_system,
    continuous_question_turn,
    knowledge_ids,
    knowledge_database_ids,
    knowledge_search_type,
    knowledge_similarity,
    knowledge_n_result,
    knowledge_response_type,
    knowledge_custom_response,
    large_model,
    top_p,
    temperature,
    unit_ids,
    variable_structure,
    is_long_memory,
    is_document_parsing,
    voice_config,
    digitalhuman_config,
    is_deleted,
    CREATOR,
    CREATED_TIME,
    MODIFIER,
    MODIFIED_TIME,
    SYS_VERSION
from
    biz_agent_application_info
where is_deleted = 'N'
<< and member_id = :memberId >>
<< and agent_publish_status = :agentPublishStatus >>
<< and (LOCATE(:query,agent_title) or LOCATE(:query,agent_desc))>>
order by MODIFIED_TIME desc