DELETE FROM t_mal_extsysapi_inputs WHERE FID = 985451257537809408;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FREQUIRED,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (985451257537809408,'0',1890545663859535872,'string',1,'1','keyword',' ','搜索关键字'); 

INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FREQUIRED,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (985451257537809408,'0',1890545663859535873,'string',2,'1','catId',' ','分类Id,只支持三级类目Id'); 

INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FREQUIRED,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (985451257537809408,'0',1890545663859535874,'int',3,'1','pageIndex',' ','当前第几页'); 

INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FREQUIRED,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (985451257537809408,'0',1890545663859535875,'int',4,'1','pageSize',' ','当前页显示'); 

INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FREQUIRED,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (985451257537809408,'0',1890545663859535876,'string',5,'1','startPrice',' ','价格区间搜索，低价'); 

INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FREQUIRED,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (985451257537809408,'0',1890545663859535877,'string',6,'1','endPrice',' ','价格区间搜索，高价'); 

INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FREQUIRED,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (985451257537809408,'0',1890545663859535878,'string',7,'1','brands',' ','品牌搜索 多个品牌以逗号分隔'); 

INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FREQUIRED,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (985451257537809408,'0',1890545663859535879,'string',8,'1','cid1',' ','一级分类'); 

INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FREQUIRED,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (985451257537809408,'0',1890545663859535880,'string',9,'1','cid2',' ','二级分类'); 

INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FREQUIRED,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (985451257537809408,'0',1890545663859535881,'string',10,'1','areaIds',' ','一级地址,二级地址,三级地址英文逗号分隔 传入后且仅redisStore= true搜索地址有货的商品'); 

INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FREQUIRED,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (985451257537809408,'0',1890545663859535883,'string',12,'1','sortType',' ','销量降序="sale_desc"; 价格升序="price_asc"; 价格降序="price_desc"; 上架时间降序="winsdate_desc"; 按销量排序_15天销售额="sort_totalsales15_desc"; 按15日销量排序="sort_days_15_qtty_desc"; 按30日销量排序'); 

INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FREQUIRED,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (985451257537809408,'0',1890545663859535885,'string',14,'1','extAttrCol',' ','扩展属性汇总 extAttrCol=”yes”'); 

INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FREQUIRED,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (985451257537809408,'0',1890545663859535887,'string',16,'1','sortExpandAttrs',' ','扩展属性筛选JSON,当需要扩展属性筛选时传入此值.且入参extAttrCol需要为”yes”; 入参来源是上次搜索接口返回结果里的字段: expandAttrAggregate , 入参具体格式:[{"expandSortId": "12","expandAttrs": [{"valueId" : "1a23"},{"valueId" : "12a4"}]}], expandSortId取值对应上次搜索结果里的expandAttrAggregate.expandSortId, 而expandA'); 

INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FREQUIRED,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (985451257537809408,'0',1890545663859535882,'string',11,'1','redisStore','false','true仅搜索有货，false全部'); 

INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FREQUIRED,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (985451257537809408,'0',1890545663859535884,'string',13,'1','priceCol','true','价格汇总  priceCol=”yes”'); 

INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FREQUIRED,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (985451257537809408,'0',1890545663859535886,'string',15,'1','mergeSku','false','true:合并同一产品不同规格sku; false:不合并同一产品不同规格sku'); 


DELETE FROM t_mal_extsysapi_outputs WHERE FID = 985451257537809408;
INSERT INTO t_mal_extsysapi_outputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FINPUT_FIELD,FINPUT_DESCRIPTION) VALUES (985451257537809408,'0',1890545663859536896,'int',1,'resultCount','搜索结果总记录数量'); 

INSERT INTO t_mal_extsysapi_outputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FINPUT_FIELD,FINPUT_DESCRIPTION) VALUES (985451257537809408,'0',1890545663859536897,'int',2,'pageCount','总页数'); 

INSERT INTO t_mal_extsysapi_outputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FINPUT_FIELD,FINPUT_DESCRIPTION) VALUES (985451257537809408,'0',1890545663859536898,'int',3,'pageSize','每页大小'); 

INSERT INTO t_mal_extsysapi_outputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FINPUT_FIELD,FINPUT_DESCRIPTION) VALUES (985451257537809408,'0',1890545663859536899,'int',4,'pageIndex','当前页'); 

INSERT INTO t_mal_extsysapi_outputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FINPUT_FIELD,FINPUT_DESCRIPTION) VALUES (985451257537809408,'0',1890545663859536900,'string',5,'brandAggregate','品牌汇总信息'); 

INSERT INTO t_mal_extsysapi_outputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FINPUT_FIELD,FINPUT_DESCRIPTION) VALUES (985451257537809408,'0',1890545663859536901,'string',6,'categoryAggregate','相关分类汇总信息'); 

INSERT INTO t_mal_extsysapi_outputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FINPUT_FIELD,FINPUT_DESCRIPTION) VALUES (985451257537809408,'0',1890545663859536902,'string',7,'hitResult','搜索命中数据json字符串'); 


DELETE FROM t_mal_extsys_api WHERE FID = 985451257537809408;
INSERT INTO t_mal_extsys_api(FID,FCONTYPE,FPLATFORMAPITYPE,FRECORD_LOG,FDESCRIPTION,FMASTERID,FSTATUS,FCONCONFIG,FFULL_NAME,FNUMBER,FGROUPID,FCREATETIME,FMODIFIERID,FENABLE,FISPRESET,FMODIFYTIME,FISDEBUG,FCREATORID) VALUES (985451257537809408,'isc_metadata_schema',0,'0','京东搜索商品',985451257537809408,'C',5658847775129599419,'/api/search/search','SRM_JD_GOODS_search',980468997621341184,{ts'2020-09-21  00:00:00'},13466739,'1','1',{ts'2024-02-22  00:00:00'},'0',72202045); 
DELETE FROM t_mal_extsys_api_l WHERE FID = 985451257537809408 AND FLOCALEID = 'zh_CN';
INSERT INTO t_mal_extsys_api_l(FID,FPKID,FLOCALEID,FNAME) VALUES (985451257537809408,'1206AF=2AJ+9','zh_CN','京东搜索商品'); 