select
    plugin_id,
    points,
    classification,
    icon,
    parent_zh_cn_name,
    parent_zh_tw_name,
    parent_en_name,
    zh_cn_title,
    zh_tw_title,
    en_title,
    zh_cn_desc,
    zh_tw_desc,
    en_desc
from
    biz_agent_application_plugin
where is_deleted = 'N' and classification != 'system'
<< and plugin_id in (:pluginIds) >>
<< and classification = :classification >>
<< and (LOCATE(:queryZHCN,zh_cn_title)) >>
<< and (LOCATE(:queryZHTW,zh_tw_title)) >>
<< and (LOCATE(:queryEN,en_title)) >>
order by id