下面是一些最近在做搜索引擎时，写的dsl语句，备忘！

    1. GET tjecommodity-20220118/_search
    2. {
    3.   "from": 0,
    4.   "size": 16,
    5.   "query": {
    6.     "match": {
    7.       "names": "水"
    8.     }
    9.   },
    10.   "_source": {
    11.     "includes": [],
    12.     "excludes": [
    13.       "introduces",
    14.       "imagelist",
    15.       "tFilteritems",
    16.       "creationtime",
    17.       "tFilteritems"
    18.     ]
    19.   }
    21. }
    24. #根据条件批量删除
    25. POST /tjecommodity-20220118/_delete_by_query
    26. {
    27.   "query": {
    28.     "term": {
    29.       "supplierid": {
    30.         "value": "23"
    31.       }
    32.     }
    33.   }
    34. }
    36. #根据供应商id查询
    37. GET tjecommodity-20220118/_search
    38. {
    39.   "query": {
    40.     "term": {
    41.       "supplierid": {
    42.         "value": "23"
    43.       }
    44.     }
    45.   }
    46. }
    48. #根据绝对条件批量删除
    49. POST /recommended-20220117/_delete_by_query
    50. {
    51.   "query": {
    52.     "term": {
    53.       "recommended": {
    54.         "value": "污水泵"
    55.       }
    56.     }
    57.   },"size": 20
    58. }
    60. #推荐词聚合查询
    61. GET /recommended-20220117/_search
    62. {
    63.   "query": {
    64.     "term": {
    65.       "recommended": "净水器"
    66.     }
    67.   },
    68.   "size": 50
    69. }
    71. #删除指定索引下的指定id文档
    72. DELETE recommended-20220117/_doc/jCYRUn4B7e8zdJt45-34
    74. #更新搜索范文大小
    75. PUT recommended-20220117/_settings
    76. {
    77.   "index.max_result_window":10000000
    78. }
    80. #更新分词
    81. POST tjecommodity-*/_update_by_query
    82. {
    83.   "conflicts":"proceed"
    84. }
    86. #添加搜索关键词
    87. POST /recommended-20220117/_doc
    88. {
    89.   "recommended": "鸡蛋面"
    90. }
    92. #最大细度分词
    93. GET _analyze
    94. {
    95.   "analyzer": "ik_max_word",
    96.   "text": "鸡蛋面"
    97. }
    100. #推荐词聚合查询
    101. GET /recommended-20220117/_search
    102. {
    103.   "query": {
    104.     "match": {
    105.       "recommended": "面"
    106.     }
    107.   },
    108.   "size": 200, 
    109.   "aggs": {
    110.     "NAME": {
    111.       "terms": {
    112.         "field": "recommended.keyword",
    113.         "size": 50
    115.       }
    116.     }
    117.   }
    118. }
    120. #搜索关键字
    121. GET /recommended-20220112/_search
    122. {
    123.   "query": {
    124.     "match": {
    125.       "recommended": "方便面"
    126.     }
    127.   }
    128. }
    130. #根据商品id搜索
    131. GET /tjecommodity-20220118/_search
    132. {
    133.   "_source": {
    134.     "excludes":  ["imagelist","introduces"]
    135.   },
    136.  "query": {
    137.    "term": {
    138.      "id": {
    139.        "value": 4704546776
    140.      }
    141.    }
    142.  }
    143. }
    146. #获取指定索引的指定文档
    147. GET recommended-20220112/_doc/ZRxQTH4B7e8zdJt4OqC3
    149. #获取指定所以的mapping
    150. GET /recommended-20220112/_mapping
    152. #多条件并列搜索
    153. GET tjecommodity/_search
    154. {
    155.   "from": 0,
    156.   "size": 20,
    157.   "query": {
    158.     "bool": {
    159.       "should": [
    160.         {
    161.           "match": {
    162.             "brandname": {
    163.               "query": "口罩",
    164.               "operator": "AND",
    165.               "prefix_length": 0,
    166.               "max_expansions": 50,
    167.               "fuzzy_transpositions": true,
    168.               "lenient": false,
    169.               "zero_terms_query": "NONE",
    170.               "auto_generate_synonyms_phrase_query": true,
    171.               "boost": 1
    172.             }
    173.           }
    174.         },
    175.         {
    176.           "match": {
    177.             "names": {
    178.               "query": "口罩",
    179.               "operator": "AND",
    180.               "prefix_length": 0,
    181.               "max_expansions": 50,
    182.               "fuzzy_transpositions": true,
    183.               "lenient": false,
    184.               "zero_terms_query": "NONE",
    185.               "auto_generate_synonyms_phrase_query": true,
    186.               "boost": 3
    187.             }
    188.           }
    189.         }
    190.       ],
    191.       "adjust_pure_negative": true,
    192.       "boost": 1
    193.     }
    194.   },
    195.   "_source": {
    196.     "includes": [],
    197.     "excludes": [
    198.       "introduces",
    199.       "imagelist",
    200.       "tFilteritems",
    201.       "creationtime",
    202.       "tFilteritems"
    203.     ]
    204.   }
    205. }
    207. #分词测试
    208. GET _analyze
    209. {
    210.   "analyzer": "ik_max_word",
    211.   "text": "方便面"
    212. }
    215. #删除指定索引
    216. DELETE recommended-20220117
    218. #设置搜索推荐关键词的mapping
    219. PUT /recommended-20220117/?pretty
    220. {
    221.   "settings": {
    222.     "number_of_shards": 5,
    223.     "number_of_replicas": 2
    224.   },"mappings": {
    225.     "properties" : {
    226.         "recommended" : {
    227.           "type" : "text",
    228.           "fields" : {
    229.             "keyword" : {
    230.               "type" : "keyword",
    231.               "ignore_above" : 256
    232.             }
    233.           },"analyzer": "ik_max_word"
    234.         }
    235.       }
    236.   }
    237. }
    241. GET tjecommodity/_search
    242. {
    243.   "from": 0,
    244.   "size": 20,
    245.   "query": {
    246.     "bool": {
    247.       "must": [
    248.         {
    249.           "match": {
    250.             "extension_field": {
    251.               "query": "防疫物资",
    252.               "operator": "OR",
    253.               "prefix_length": 0,
    254.               "max_expansions": 50,
    255.               "fuzzy_transpositions": true,
    256.               "lenient": false,
    257.               "zero_terms_query": "NONE",
    258.               "auto_generate_synonyms_phrase_query": true,
    259.               "boost": 1
    260.             }
    261.           }
    262.         }
    263.       ],
    264.       "adjust_pure_negative": true,
    265.       "boost": 1
    266.     }
    267.   },
    268.   "_source": {
    269.     "includes": [],
    270.     "excludes": [
    271.       "introduces",
    272.       "imagelist",
    273.       "tFilteritems",
    274.       "creationtime"
    275.     ]
    276.   }
    277. }
    281. #通过供应商id进行搜索后进入店铺页面
    282. GET commodity/_search
    283. {
    284.   "from": 0,
    285.   "size": 16,
    286.   "query": {
    287.     "bool": {
    288.       "must": [
    289.         {
    290.           "term": {
    291.             "supplierid": {
    292.               "value": 34,
    293.               "boost": 1
    294.             }
    295.           }
    296.         }
    297.       ],
    298.       "adjust_pure_negative": true,
    299.       "boost": 1
    300.     }
    301.   },
    302.   "_source": {
    303.     "includes": [],
    304.     "excludes": [
    305.       "introduces",
    306.       "imagelist",
    307.       "tFilteritems",
    308.       "creationtime",
    309.       "tFilteritems"
    310.     ]
    311.   }
    312. }
    316. POST _analyze
    317. {
    318.   "text": "齐心  11孔文件保护套  A4 透明色 100个装 EH303A-1 13W8740『固安捷』",
    319.   "analyzer": "ngram_analyzer"
    320. }
    322. POST _analyze
    323. {
    324.   "tokenizer": "ngram",
    325.   "text": "齐心  11孔文件保护套  A4 透明色 100个装 EH303A-1 13W8740『固安捷』"
    326. }
    329. GET /tjecommodity-20220110/_search
    330. {
    331.   "_source": {
    332.     "includes": ["names"]
    333.   },
    334.   "suggest": {
    335.     "YOUR_SUGGESTION": {
    336.       "text": "齐心",
    337.       "phrase": {
    338.         "field": "names",
    339.         "size": 10
    340.       }
    341.     }
    343.   }
    344. }
    346. GET /tjecommodity/_search
    347. {
    348.   "query": {
    349.     "term": {
    350.       "status": {
    351.         "value": 1
    352.       }
    353.     }
    354.   }
    355. }
    358. #更新分词
    359. POST commodity/_update_by_query
    360. {
    361.   "conflicts":"proceed"
    362. }
    364. GET /tjecommodity/_search
    365. {"from":0,"size":10,"query":{"bool":{"must":[{"term":{"top":{"value":0,"boost":1.0}}},{"match":{"extension_field":{"query":"年货","operator":"OR","prefix_length":0,"max_expansions":50,"fuzzy_transpositions":true,"lenient":false,"zero_terms_query":"NONE","auto_generate_synonyms_phrase_query":true,"boost":1.0}}}],"adjust_pure_negative":true,"boost":1.0}},"_source":{"includes":[],"excludes":["introduces","imagelist","tFilteritems","creationtime","tFilteritems"]}}
    368. #过滤并不展示指定字段后进行搜索查询
    369. GET tjecommodity/_search
    370. {
    371.   "_source": {
    372.     "includes": [],
    373.     "excludes": [
    374.       "introduces",
    375.       "imagelist",
    376.       "tFilteritems",
    377.       "creationtime",
    378.       "tFilteritems"
    379.     ]
    380.   },
    381.   "query": {
    382.     "bool": {
    383.       "must": [
    384.         {
    385.           "term": {
    386.             "oneid": {
    387.               "value": 14468
    388.             }
    389.           }
    390.         }
    391.       ]
    392.     }
    393.   },
    394.   "size": 20
    395. }
    397. #多条件 多字段排序搜索
    398. GET tjecommodity/_search
    399. {
    400.   "from": 0,
    401.   "size": 16,
    402.   "query": {
    403.     "bool": {
    404.       "should": [
    405.         {
    406.           "match": {
    407.             "names": {
    408.               "query": "TM2490",
    409.               "operator": "AND",
    410.               "prefix_length": 0,
    411.               "max_expansions": 50,
    412.               "fuzzy_transpositions": true,
    413.               "lenient": false,
    414.               "zero_terms_query": "NONE",
    415.               "auto_generate_synonyms_phrase_query": true,
    416.               "boost": 3
    417.             }
    418.           }
    419.         },
    420.         {
    421.           "match": {
    422.             "brandname": {
    423.               "query": "TM2490",
    424.               "operator": "AND",
    425.               "prefix_length": 0,
    426.               "max_expansions": 50,
    427.               "fuzzy_transpositions": true,
    428.               "lenient": false,
    429.               "zero_terms_query": "NONE",
    430.               "auto_generate_synonyms_phrase_query": true,
    431.               "boost": 2
    432.             }
    433.           }
    434.         },
    435.         {
    436.           "match": {
    437.             "number": {
    438.               "query": "TM2490",
    439.               "operator": "AND",
    440.               "prefix_length": 0,
    441.               "max_expansions": 50,
    442.               "fuzzy_transpositions": true,
    443.               "lenient": false,
    444.               "zero_terms_query": "NONE",
    445.               "auto_generate_synonyms_phrase_query": true,
    446.               "boost": 2
    447.             }
    448.           }
    449.         }
    450.       ],
    451.       "adjust_pure_negative": true,
    452.       "boost": 1
    453.     }
    454.   },
    455.   "_source": {
    456.     "includes": [],
    457.     "excludes": [
    458.       "introduces",
    459.       "imagelist",
    460.       "tFilteritems",
    461.       "creationtime"
    462.     ]
    463.   },
    464.   "sort": [
    465.     {
    466.       "tSpecifications.discount": {
    467.         "order": "desc"
    468.       }
    469.     },
    470.     {
    471.       "personSort": {
    472.         "order": "asc"
    473.       }
    474.     }
    475.   ],
    476.   "track_total_hits": 2147483647,
    477.   "highlight": {
    478.     "pre_tags": [
    479.       "<font color='red'>"
    480.     ],
    481.     "post_tags": [
    482.       "</font>"
    483.     ]
    484.   }
    485. }
    489. GET commodity/_search
    490. {
    491.   "query": {
    492.     "multi_match": {
    493.       "query": "齐心",
    494.       "type": "best_fields", 
    495.       "fields": ["brandname","names"]
    496.     }
    497.   }
    498. }
    500. GET /house-*/_search
    501. { 
    502.   "query": {
    503.     "multi_match": {
    504.       "query": "天齐",
    505.       "fields": ["brandname","names","supplieridname"]   
    506.     }
    507.   }
    508. }
    510. GET /test20220104/_search
    511. { "_source" : {
    512.      "excludes": [ "introduces","imagelist","tFilteritems","creationtime","tSpecifications.creationtime" ]
    513.   },
    514.   "query": { 
    515.     "term": {
    516.       "brandname.keyword": "悦才智连"
    517.     } 
    518.   } 
    519. }
    521. POST /tjecommodity/_doc
    522. {
    523.   "properties":{
    524.     "extension_field":{
    525.       "type":"text",
    526.       "fielddata":true
    527.     }
    528.   }
    529. }
    531. GET /commodity/_doc/10-AA5666360
    533. GET /commodity/_search/
    534. {
    535.   "_source": {
    536.     "includes": [],
    537.     "excludes": [
    538.       "introduces",
    539.       "imagelist",
    540.       "tFilteritems",
    541.       "creationtime",
    542.       "tSpecifications",
    543.       "filteritem",
    544.       "tFilteritems"
    545.     ]
    546.   },
    547.   "aggregations": {
    548.     "hot": {
    549.       "sum": {
    550.         "field": "extension_field.keyword"
    551.       }
    552.     }
    553.   }
    554. }
    557. GET /commodity/_search/
    558. {"_source" : {
    559.      "excludes": [ "introduces","imagelist","tFilteritems","creationtime","tSpecifications.creationtime" ]
    560.   },
    562.  "aggs": {
    563.    "NsssAME": {
    564.      "terms": {
    565.        "field": "properties.extension_field.fielddata"
    566.      }
    567.    }
    568.  }
    569. }
    571. GET /commodity/_search/
    572. {
    573.   "_source" : {
    574.      "excludes": [ "introduces","imagelist","tFilteritems","creationtime","tSpecifications.creationtime" ]
    575.   },
    576.  "aggs": {
    577.    "street_values": {
    578.      "terms": {
    579.        "field": "extension_field.keyword",
    580.        "size": 10
    581.      }
    582.    }
    583.  } 
    584. }
    586. GET /tjecommodity/_search/
    587. {"_source" : {
    588.      "excludes": [ "introduces","imagelist","tFilteritems","creationtime","tSpecifications.creationtime" ]
    589.   },
    590.   "query": {
    591.     "match": {
    592.       "extension_field": "年货"
    593.     }
    594.   }
    595. }
    605. GET /commodity/_search
    606. {
    607.     "from": 10,
    608.     "size": 0,
    609.     "query": {
    610.         "bool": {
    611.             "should": [{
    612.                 "bool": {
    613.                     "must": [{
    614.                         "match": {
    615.                             "names": "齐心"
    616.                             }
    618.                     }, {
    619.                         "match": {
    620.                             "brandname.": 
    621.                                 "齐心"
    623.                         }
    624.                     }],
    625.                     "adjust_pure_negative": true,
    626.                     "boost": 1.0
    627.                 }
    628.             }],
    629.             "adjust_pure_negative": true,
    630.             "boost": 1.0
    631.         }
    632.     }
    633. }
    635. GET /tjecommodity/_search
    636. DELETE tjecommodity
    638. GET /tjecommodity/_search
    639. {
    640.   "_source": {
    641.     "excludes": [
    642.       "introduces",
    643.       "imagelist",
    644.       "tFilteritems",
    645.       "creationtime",
    646.       "tSpecifications.creationtime"
    647.     ]
    648.   },
    649.   "query": {
    650.     "term": {
    651.       "brandname": "齐心"
    652.     }
    653.   }
    654. }
    655. GET /test20220104/_search
    656. {
    657.   "query": {
    658.     "term": {
    659.       "brandname": {
    660.         "value": "悦才智连"
    661.       }
    662.     }
    663.   }
    664. }
    666. GET /commodity/_search/
    667. {"from":0,"size":10,"query":{"bool":{"must":[{"term":{"top":{"value":0,"boost":1.0}}}],"adjust_pure_negative":true,"boost":1.0}}}
    669. GET /_cluster/health
    671. GET /_cat/health
    673. GET /test20220104/_search/
    674. GET /test20220104/_search?q=悦才智连
    676. ##获取索引
    677. GET /_cat/indices
    678. ##获取索引mapping
    679. GET /commodity/_mapping
    683. GET tjecommodity/_search
    684. {
    685.   "from": 0,
    686.   "size": 16,
    687.   "query": {
    688.     "bool": {
    689.       "should": [
    690.         {
    691.           "match": {
    692.             "names": {
    693.               "query": "桶装水",
    694.               "operator": "AND",
    695.               "prefix_length": 0,
    696.               "max_expansions": 50,
    697.               "fuzzy_transpositions": true,
    698.               "lenient": false,
    699.               "zero_terms_query": "NONE",
    700.               "auto_generate_synonyms_phrase_query": true,
    701.               "boost": 10
    702.             }
    703.           }
    704.         },
    705.         {
    706.           "match": {
    707.             "extension_field": {
    708.               "query": "桶装水",
    709.               "operator": "AND",
    710.               "prefix_length": 0,
    711.               "max_expansions": 50,
    712.               "fuzzy_transpositions": true,
    713.               "lenient": false,
    714.               "zero_terms_query": "NONE",
    715.               "auto_generate_synonyms_phrase_query": true,
    716.               "boost": 20
    717.             }
    718.           }
    719.         },
    720.         {
    721.           "match": {
    722.             "brandname": {
    723.               "query": "桶装水",
    724.               "operator": "AND",
    725.               "prefix_length": 0,
    726.               "max_expansions": 50,
    727.               "fuzzy_transpositions": true,
    728.               "lenient": false,
    729.               "zero_terms_query": "NONE",
    730.               "auto_generate_synonyms_phrase_query": true,
    731.               "boost": 5
    732.             }
    733.           }
    734.         },
    735.         {
    736.           "match": {
    737.             "oneName": {
    738.               "query": "桶装水",
    739.               "operator": "AND",
    740.               "prefix_length": 0,
    741.               "max_expansions": 50,
    742.               "fuzzy_transpositions": true,
    743.               "lenient": false,
    744.               "zero_terms_query": "NONE",
    745.               "auto_generate_synonyms_phrase_query": true,
    746.               "boost": 2
    747.             }
    748.           }
    749.         },
    750.         {
    751.           "match": {
    752.             "twoName": {
    753.               "query": "桶装水",
    754.               "operator": "AND",
    755.               "prefix_length": 0,
    756.               "max_expansions": 50,
    757.               "fuzzy_transpositions": true,
    758.               "lenient": false,
    759.               "zero_terms_query": "NONE",
    760.               "auto_generate_synonyms_phrase_query": true,
    761.               "boost": 2
    762.             }
    763.           }
    764.         },
    765.         {
    766.           "match": {
    767.             "threeName": {
    768.               "query": "桶装水",
    769.               "operator": "AND",
    770.               "prefix_length": 0,
    771.               "max_expansions": 50,
    772.               "fuzzy_transpositions": true,
    773.               "lenient": false,
    774.               "zero_terms_query": "NONE",
    775.               "auto_generate_synonyms_phrase_query": true,
    776.               "boost": 2
    777.             }
    778.           }
    779.         }
    780.       ],
    781.       "adjust_pure_negative": true,
    782.       "boost": 1
    783.     }
    784.   },
    785.   "_source": {
    786.     "includes": [],
    787.     "excludes": [
    788.       "introduces",
    789.       "imagelist",
    790.       "tFilteritems",
    791.       "creationtime"
    792.     ]
    793.   },
    794.   "sort": [
    796.     {
    797.       "personSort": {
    798.         "order": "asc"
    799.       }
    800.     }
    801.   ],
    802.   "track_total_hits": 2147483647,
    803.   "highlight": {
    804.     "pre_tags": [
    805.       "<font color='red'>"
    806.     ],
    807.     "post_tags": [
    808.       "</font>"
    809.     ]
    810.   }
    811. }
    823. ##获取索引mapping
    824. GET /test20220104/_mapping
    827. DELETE /slorsearch/
    831. #最大细度分词
    832. GET _analyze
    833. {
    834.   "analyzer": "ik_max_word",
    835.   "text": "[186400,186393,335723]"
    836. }
    838. #最大细度分词
    839. GET _analyze
    840. {
    841.   "analyzer": "ik_smart",
    842.   "text": "祺宝 QIBAO 优质压花水牛皮安全凉鞋（防砸，防刺穿）-42 78029防砸，防刺穿-42 4F1280"
    843. }
    846. #最小细度分词
    847. GET _analyze
    848. {
    849.   "analyzer": "ik_smart",
    850.   "text": "惠普（HP）M104w黑白激光打印机 无线 手机打印 家用 小型办公 P11081106升级wifi版"
    851. }
    853. #最小细度分词
    854. GET _analyze
    855. {
    856.   "analyzer": "ik_max_word",
    857.   "text": "矿泉水都元人合 至尊"
    858. }
    859. GET _analyze
    860. {
    861.   "analyzer": "ik_smart",
    862.   "text": "huawei华为"
    863. }
    866. DELETE tjecommodity-20220119
    868. #设置索引mapping
    869. PUT /tjecommodity-20220119/?pretty
    870. {
    871.   "settings": {
    872.     "number_of_shards": 5,
    873.     "number_of_replicas": 2
    874.   },
    875.    "mappings" : {
    876.       "properties" : {
    877.         "balancetime" : {
    878.           "type" : "long"
    879.         },
    880.         "brandid" : {
    881.           "type" : "long"
    882.         },
    883.         "brandname" : {
    884.           "type" : "text",
    885.           "fields" : {
    886.             "keyword" : {
    887.               "type" : "keyword",
    888.               "ignore_above" : 256
    889.             }
    890.           },
    891.           "analyzer" : "ik_smart"
    892.         },
    893.         "commentNum" : {
    894.           "type" : "keyword"
    895.         },
    896.         "companytext" : {
    897.           "type" : "text",
    898.           "fields" : {
    899.             "keyword" : {
    900.               "type" : "keyword",
    901.               "ignore_above" : 256
    902.             }
    903.           }
    904.         },
    905.         "creationtime" : {
    906.           "type" : "date",
    907.           "format" : "yyyy-MM-dd HH:mm:ss"
    908.         },
    909.         "deposit" : {
    910.           "type" : "long"
    911.         },
    912.         "discount" : {
    913.           "type" : "long"
    914.         },
    915.         "enterpriseSort" : {
    916.           "type" : "long"
    917.         },
    918.         "extension_field" : {
    919.           "type" : "text",
    920.           "fields" : {
    921.             "keyword" : {
    922.               "type" : "keyword",
    923.               "ignore_above" : 256
    924.             }
    925.           }
    926.         },
    927.         "filteritem" : {
    928.           "type" : "text",
    929.           "fields" : {
    930.             "keyword" : {
    931.               "type" : "keyword",
    932.               "ignore_above" : 256
    933.             }
    934.           },
    935.           "analyzer" : "ik_max_word"
    936.         },
    937.         "futuresnum" : {
    938.           "type" : "text",
    939.           "fields" : {
    940.             "keyword" : {
    941.               "type" : "keyword",
    942.               "ignore_above" : 256
    943.             }
    944.           }
    945.         },
    946.         "hot" : {
    947.           "type" : "long"
    948.         },
    949.         "id" : {
    950.           "type" : "long"
    951.         },
    952.         "image" : {
    953.           "type" : "text",
    954.           "index": false, 
    955.           "fields" : {
    956.             "keyword" : {
    957.               "type" : "keyword",
    958.               "ignore_above" : 256
    959.             }
    960.           }
    961.         },
    962.         "imagelist" : {
    963.           "type" : "text",
    964.           "index": false, 
    965.           "fields" : {
    966.             "keyword" : {
    967.               "type" : "keyword",
    968.               "ignore_above" : 256
    969.             }
    970.           }
    971.         },
    972.         "introduces" : {
    973.           "type" : "text",
    974.           "index": false, 
    975.           "fields" : {
    976.             "keyword" : {
    977.               "type" : "keyword",
    978.               "ignore_above" : 256
    979.             }
    980.           }
    981.         },
    982.         "minimum" : {
    983.           "type" : "long"
    984.         },
    985.         "names" : {
    986.           "type" : "text",
    987.           "fields" : {
    988.             "keyword" : {
    989.               "type" : "keyword",
    990.               "ignore_above" : 256
    991.             }
    992.           },
    993.           "analyzer" : "ik_smart"
    994.         },
    995.         "num" : {
    996.           "type" : "long"
    997.         },
    998.         "number" : {
    999.           "type" : "text",
    1000.           "fields" : {
    1001.             "keyword" : {
    1002.               "type" : "keyword",
    1003.               "ignore_above" : 256
    1004.             }
    1005.           }
    1006.         },
    1007.         "nums" : {
    1008.           "type" : "long"
    1009.         },
    1010.         "oneName" : {
    1011.           "type" : "text",
    1012.           "analyzer": "ik_max_word", 
    1013.           "fields" : {
    1014.             "keyword" : {
    1015.               "type" : "keyword",
    1016.               "ignore_above" : 256
    1017.             }
    1018.           }
    1019.         },
    1020.         "oneid" : {
    1021.           "type" : "long"
    1022.         },
    1023.         "personSort" : {
    1024.           "type" : "long"
    1025.         },
    1026.         "prices" : {
    1027.           "type" : "long"
    1028.         },
    1029.         "recommend" : {
    1030.           "type" : "long"
    1031.         },
    1032.         "specifications" : {
    1033.           "type" : "text",
    1034.           "fields" : {
    1035.             "keyword" : {
    1036.               "type" : "keyword",
    1037.               "ignore_above" : 256
    1038.             }
    1039.           }
    1040.         },
    1041.         "status" : {
    1042.           "type" : "long"
    1043.         },
    1044.         "supplierid" : {
    1045.           "type" : "long"
    1046.         },
    1047.         "supplieridname" : {
    1048.           "type" : "text",
    1049.           "fields" : {
    1050.             "keyword" : {
    1051.               "type" : "keyword",
    1052.               "ignore_above" : 256
    1053.             }
    1054.           },
    1055.           "analyzer" : "ik_smart"
    1056.         },
    1057.         "tFilteritems" : {
    1058.           "properties" : {
    1059.             "id" : {
    1060.               "type" : "long"
    1061.             },
    1062.             "names" : {
    1063.               "type" : "text",
    1064.               "fields" : {
    1065.                 "keyword" : {
    1066.                   "type" : "keyword",
    1067.                   "ignore_above" : 256
    1068.                 }
    1069.               },
    1070.               "analyzer" : "ik_smart"
    1071.             },
    1072.             "nums" : {
    1073.               "type" : "long"
    1074.             },
    1075.             "params" : {
    1076.               "type" : "object"
    1077.             },
    1078.             "pid" : {
    1079.               "type" : "long"
    1080.             },
    1081.             "status" : {
    1082.               "type" : "integer"
    1083.             },
    1084.             "tKeywordList" : {
    1085.               "properties" : {
    1086.                 "id" : {
    1087.                   "type" : "long"
    1088.                 },
    1089.                 "names" : {
    1090.                   "type" : "text",
    1091.                   "fields" : {
    1092.                     "keyword" : {
    1093.                       "type" : "keyword",
    1094.                       "ignore_above" : 256
    1095.                     }
    1096.                   },
    1097.                   "analyzer" : "ik_smart"
    1098.                 },
    1099.                 "number" : {
    1100.                   "type" : "long"
    1101.                 },
    1102.                 "params" : {
    1103.                   "type" : "object"
    1104.                 },
    1105.                 "pid" : {
    1106.                   "type" : "long"
    1107.                 }
    1108.               }
    1109.             }
    1110.           }
    1111.         },
    1112.         "tSpecifications" : {
    1113.           "properties" : {
    1114.             "creationtime" : {
    1115.               "type" : "date",
    1116.               "format" : "yyyy-MM-dd HH:mm:ss"
    1117.             },
    1118.             "discount" : {
    1119.               "type" : "float"
    1120.             },
    1121.             "id" : {
    1122.               "type" : "long"
    1123.             },
    1124.             "names" : {
    1125.               "type" : "text",
    1126.               "fields" : {
    1127.                 "keyword" : {
    1128.                   "type" : "keyword",
    1129.                   "ignore_above" : 256
    1130.                 }
    1131.               },
    1132.               "analyzer" : "ik_smart"
    1133.             },
    1134.             "number" : {
    1135.               "type" : "long"
    1136.             },
    1137.             "prices" : {
    1138.               "type" : "double"
    1139.             },
    1140.             "scribingprice" : {
    1141.               "type" : "double"
    1142.             },
    1143.             "stocknum" : {
    1144.               "type" : "long"
    1145.             },
    1146.             "tCommodityPriceSets" : {
    1147.               "properties" : {
    1148.                 "commodityId" : {
    1149.                   "type" : "long"
    1150.                 },
    1151.                 "id" : {
    1152.                   "type" : "long"
    1153.                 },
    1154.                 "salePrice" : {
    1155.                   "type" : "float"
    1156.                 },
    1157.                 "scribePrice" : {
    1158.                   "type" : "float"
    1159.                 },
    1160.                 "sourceId" : {
    1161.                   "type" : "long"
    1162.                 },
    1163.                 "spec" : {
    1164.                   "type" : "long"
    1165.                 },
    1166.                 "type" : {
    1167.                   "type" : "long"
    1168.                 }
    1169.               }
    1170.             }
    1171.           }
    1172.         },
    1173.         "threeName" : {
    1174.           "type" : "text",
    1175.           "analyzer": "ik_max_word", 
    1176.           "fields" : {
    1177.             "keyword" : {
    1178.               "type" : "keyword",
    1179.               "ignore_above" : 256
    1180.             }
    1181.           }
    1182.         },
    1183.         "threeid" : {
    1184.           "type" : "long"
    1185.         },
    1186.         "top" : {
    1187.           "type" : "long"
    1188.         },
    1189.         "transactionnum" : {
    1190.           "type" : "long"
    1191.         },
    1192.         "twoName" : {
    1193.           "type" : "text",
    1194.           "analyzer": "ik_max_word", 
    1195.           "fields" : {
    1196.             "keyword" : {
    1197.               "type" : "keyword",
    1198.               "ignore_above" : 256
    1199.             }
    1200.           }
    1201.         },
    1202.         "twoid" : {
    1203.           "type" : "long"
    1204.         },
    1205.         "types" : {
    1206.           "type" : "integer"
    1207.         }
    1208.       }
    1209.     }
    1210. }
    1212. GET tjecommodity-20220118/_search
    1213. {
    1214.   "from": 0,
    1215.   "size": 16,
    1216.   "query": {
    1217.     "bool": {
    1218.       "should": [
    1219.         {
    1220.           "match": {
    1221.             "extension_field": {
    1222.               "query": "水",
    1223.               "operator": "AND",
    1224.               "prefix_length": 0,
    1225.               "max_expansions": 50,
    1226.               "fuzzy_transpositions": true,
    1227.               "lenient": false,
    1228.               "zero_terms_query": "NONE",
    1229.               "auto_generate_synonyms_phrase_query": true,
    1230.               "boost": 20
    1231.             }
    1232.           }
    1233.         },
    1234.         {
    1235.           "match": {
    1236.             "names": {
    1237.               "query": "水",
    1238.               "operator": "AND",
    1239.               "prefix_length": 0,
    1240.               "max_expansions": 50,
    1241.               "fuzzy_transpositions": true,
    1242.               "lenient": false,
    1243.               "zero_terms_query": "NONE",
    1244.               "auto_generate_synonyms_phrase_query": true,
    1245.               "boost": 15
    1246.             }
    1247.           }
    1248.         },
    1249.         {
    1250.           "match": {
    1251.             "brandname": {
    1252.               "query": "水",
    1253.               "operator": "AND",
    1254.               "prefix_length": 0,
    1255.               "max_expansions": 50,
    1256.               "fuzzy_transpositions": true,
    1257.               "lenient": false,
    1258.               "zero_terms_query": "NONE",
    1259.               "auto_generate_synonyms_phrase_query": true,
    1260.               "boost": 8
    1261.             }
    1262.           }
    1263.         },
    1264.         {
    1265.           "match": {
    1266.             "oneName": {
    1267.               "query": "水",
    1268.               "operator": "AND",
    1269.               "prefix_length": 0,
    1270.               "max_expansions": 50,
    1271.               "fuzzy_transpositions": true,
    1272.               "lenient": false,
    1273.               "zero_terms_query": "NONE",
    1274.               "auto_generate_synonyms_phrase_query": true,
    1275.               "boost": 2
    1276.             }
    1277.           }
    1278.         },
    1279.         {
    1280.           "match": {
    1281.             "twoName": {
    1282.               "query": "水",
    1283.               "operator": "AND",
    1284.               "prefix_length": 0,
    1285.               "max_expansions": 50,
    1286.               "fuzzy_transpositions": true,
    1287.               "lenient": false,
    1288.               "zero_terms_query": "NONE",
    1289.               "auto_generate_synonyms_phrase_query": true,
    1290.               "boost": 2
    1291.             }
    1292.           }
    1293.         },
    1294.         {
    1295.           "match": {
    1296.             "threeName": {
    1297.               "query": "水",
    1298.               "operator": "AND",
    1299.               "prefix_length": 0,
    1300.               "max_expansions": 50,
    1301.               "fuzzy_transpositions": true,
    1302.               "lenient": false,
    1303.               "zero_terms_query": "NONE",
    1304.               "auto_generate_synonyms_phrase_query": true,
    1305.               "boost": 2
    1306.             }
    1307.           }
    1308.         }
    1309.       ],
    1310.       "adjust_pure_negative": true,
    1311.       "boost": 1
    1312.     }
    1313.   },
    1314.   "_source": {
    1315.     "includes": [],
    1316.     "excludes": [
    1317.       "introduces",
    1318.       "imagelist",
    1319.       "tFilteritems",
    1320.       "creationtime"
    1321.     ]
    1322.   },
    1323.   "sort": [
    1324.     {
    1325.       "personSort": {
    1326.         "order": "asc"
    1327.       }
    1328.     },
    1329.     {
    1330.       "_score": {
    1331.         "order": "desc"
    1332.       }
    1333.     }
    1334.   ],
    1335.   "track_total_hits": 2147483647,
    1336.   "highlight": {
    1337.     "pre_tags": [
    1338.       "<font color='red'>"
    1339.     ],
    1340.     "post_tags": [
    1341.       "</font>"
    1342.     ]
    1343.   }
    1344. }
    1346. #es 数据索引对拷
    1347. POST _reindex
    1348. {
    1349.   "source": {
    1350.     "index": "tjecommodity20220117"
    1351.   },
    1352.   "dest": {
    1353.     "index":"tjecommodity-20220118",
    1354.     "version_type": "internal"
    1355.   }
    1356. }
    1361. #设置索引mapping 旧
    1362. PUT /tjecommodity20220118/?pretty
    1363. {
    1364.   "settings": {
    1365.     "number_of_shards": 5,
    1366.         "number_of_replicas": 2
    1367.   },
    1368.   "mappings": {
    1369.       "properties": {
    1370.         "brandName" : {
    1371.           "type" : "text",
    1372.           "analyzer": "ik_smart",
    1373.           "fields" : {
    1374.             "keyword" : {
    1375.               "type" : "keyword",
    1376.               "ignore_above" : 256
    1377.             }
    1378.           }
    1379.         },
    1380.         "brandid" : {
    1381.           "type" : "long"
    1382.         },
    1383.         "commentNum" : {
    1384.           "type" : "long"
    1385.         },
    1386.         "companytext" : {
    1387.           "type" : "text",
    1388.           "index": false, 
    1389.           "fields" : {
    1390.             "keyword" : {
    1391.               "type" : "keyword",
    1392.               "ignore_above" : 256
    1393.             }
    1394.           }
    1395.         },
    1396.         "creationtime" : {
    1397.           "type" : "date"
    1398.           , "format": "YYYY-MM-dd HH:mm:ss"
    1399.         },
    1400.         "discount" : {
    1401.           "type" : "long"
    1402.         },
    1403.         "filteritem" : {
    1404.           "type" : "text",
    1405.           "fields" : {
    1406.             "keyword" : {
    1407.               "type" : "keyword",
    1408.               "ignore_above" : 256
    1409.             }
    1410.           }
    1411.         },
    1412.         "futuresnum" : {
    1413.           "type" : "text",
    1414.           "fields" : {
    1415.             "keyword" : {
    1416.               "type" : "keyword",
    1417.               "ignore_above" : 256
    1418.             }
    1419.           }
    1420.         },
    1421.         "id" : {
    1422.           "type" : "long"
    1423.         },
    1424.         "image" : {
    1425.           "type" : "keyword"
    1426.         },
    1427.         "imagelist" : {
    1428.           "type" : "keyword"
    1429.         },
    1430.         "introduces" : {
    1431.           "type" : "text",
    1432.           "index": false
    1433.         },
    1434.         "isSelf" : {
    1435.           "type" : "integer"
    1436.         },
    1437.         "minimum" : {
    1438.           "type" : "long"
    1439.         },
    1440.         "names" : {
    1441.           "type" : "text",
    1442.           "analyzer": "ik_smart",
    1443.           "fields" : {
    1444.             "keyword" : {
    1445.               "type" : "keyword",
    1446.               "ignore_above" : 256
    1447.             }
    1448.           }
    1449.         },
    1450.         "number" : {
    1451.           "type" : "keyword",
    1452.           "fields" : {
    1453.             "keyword" : {
    1454.               "type" : "keyword",
    1455.               "ignore_above" : 256
    1456.             }
    1457.           }
    1458.         },
    1459.         "nums" : {
    1460.           "type" : "long"
    1461.         },
    1462.         "oneid" : {
    1463.           "type" : "long"
    1464.         },
    1465.         "prices" : {
    1466.           "type" : "double"
    1467.         },
    1468.         "recommend" : {
    1469.           "type" : "long"
    1470.         },
    1471.         "shopName" : {
    1472.           "type" : "text",
    1473.           "analyzer": "ik_max_word",
    1474.           "fields" : {
    1475.             "keyword" : {
    1476.               "type" : "keyword",
    1477.               "ignore_above" : 256
    1478.             }
    1479.           }
    1480.         },
    1481.         "showPrice" : {
    1482.           "type" : "float"
    1483.         },
    1484.         "showScribingPrice" : {
    1485.           "type" : "float"
    1486.         },
    1487.         "specifications" : {
    1488.           "type" : "text",
    1489.           "fields" : {
    1490.             "keyword" : {
    1491.               "type" : "keyword",
    1492.               "ignore_above" : 256
    1493.             }
    1494.           }
    1495.         },
    1496.         "status" : {
    1497.           "type" : "integer"
    1498.         },
    1499.         "supplierid" : {
    1500.           "type" : "long"
    1501.         },
    1502.         "threeid" : {
    1503.           "type" : "long"
    1504.         },
    1505.         "transactionnum" : {
    1506.           "type" : "long"
    1507.         },
    1508.         "twoid" : {
    1509.           "type" : "long"
    1510.         },
    1511.         "types" : {
    1512.           "type" : "long"
    1513.         },
    1514.         "yesCollection" : {
    1515.           "type" : "boolean"
    1516.         }
    1518.       }
    1519.   }
    1520. }
    1525. GET /commodity/_search/
    1527. POST /commodity/_doc
    1528. {
    1529. "brandid": 12596,
    1530. "brandname": "COMIX/齐心",
    1531. "commentNum": 0,
    1532. "deposit": 0,
    1533. "discount": 1,
    1534. "enterpriseSort": 3,
    1535. "hot": 0,
    1536. "id": 187,
    1537. "image": "http://res.officebox.cn/Content/Upload/Image/Product_Cover/55224cea58834a6a87c931e32250720a/42dcf49fe6d45a66.jpg",
    1538. "minimum": 0,
    1539. "names": "齐心(Comix)小美工刀片(B2851) ",
    1540. "num": 0,
    1541. "number": "2038363",
    1542. "nums": 100,
    1543. "oneid": 14533,
    1544. "personSort": 6,
    1545. "prices": 2.42,
    1546. "recommend": 1,
    1547. "specifications": "218",
    1548. "status": 1,
    1549. "supplierid": 26,
    1550. "supplieridname": "广东今日合作办公用品有限公司",
    1551. "tFilteritems": [
    1552. {
    1553. "id": 36973,
    1554. "names": "分类：",
    1555. "nums": 0,
    1556. "params": { },
    1557. "pid": 14845,
    1558. "status": 1,
    1559. "tKeywordList": [
    1560. {
    1561. "id": 273370,
    1562. "names": "手动工具",
    1563. "number": 0,
    1564. "params": { },
    1565. "pid": 36973
    1566. }
    1567. ,
    1568. {
    1569. "id": 273371,
    1570. "names": "办公文具",
    1571. "number": 0,
    1572. "params": { },
    1573. "pid": 36973
    1574. }
    1575. ,
    1576. {
    1577. "id": 273396,
    1578. "names": "园艺工具",
    1579. "number": 0,
    1580. "params": { },
    1581. "pid": 36973
    1582. }
    1583. ]
    1584. }
    1585. ,
    1586. {
    1587. "id": 36974,
    1588. "names": "材质:",
    1589. "nums": 0,
    1590. "params": { },
    1591. "pid": 14845,
    1592. "status": 1,
    1593. "tKeywordList": [
    1594. {
    1595. "id": 273374,
    1596. "names": "钛钢",
    1597. "number": 0,
    1598. "params": { },
    1599. "pid": 36974
    1600. }
    1601. ,
    1602. {
    1603. "id": 273375,
    1604. "names": "铬钒合金钢",
    1605. "number": 0,
    1606. "params": { },
    1607. "pid": 36974
    1608. }
    1609. ,
    1610. {
    1611. "id": 273376,
    1612. "names": "合金",
    1613. "number": 0,
    1614. "params": { },
    1615. "pid": 36974
    1616. }
    1617. ,
    1618. {
    1619. "id": 273379,
    1620. "names": "铸钢",
    1621. "number": 0,
    1622. "params": { },
    1623. "pid": 36974
    1624. }
    1625. ,
    1626. {
    1627. "id": 273380,
    1628. "names": "其他",
    1629. "number": 0,
    1630. "params": { },
    1631. "pid": 36974
    1632. }
    1633. ,
    1634. {
    1635. "id": 273381,
    1636. "names": "高碳钢",
    1637. "number": 0,
    1638. "params": { },
    1639. "pid": 36974
    1640. }
    1641. ,
    1642. {
    1643. "id": 273382,
    1644. "names": "陶瓷",
    1645. "number": 0,
    1646. "params": { },
    1647. "pid": 36974
    1648. }
    1649. ,
    1650. {
    1651. "id": 273384,
    1652. "names": "玻璃",
    1653. "number": 0,
    1654. "params": { },
    1655. "pid": 36974
    1656. }
    1657. ,
    1658. {
    1659. "id": 273385,
    1660. "names": "镍铬合金钢",
    1661. "number": 0,
    1662. "params": { },
    1663. "pid": 36974
    1664. }
    1665. ,
    1666. {
    1667. "id": 273387,
    1668. "names": "铝合金",
    1669. "number": 0,
    1670. "params": { },
    1671. "pid": 36974
    1672. }
    1673. ,
    1674. {
    1675. "id": 273388,
    1676. "names": "碳钢",
    1677. "number": 0,
    1678. "params": { },
    1679. "pid": 36974
    1680. }
    1681. ,
    1682. {
    1683. "id": 273391,
    1684. "names": "铬钼合金钢",
    1685. "number": 0,
    1686. "params": { },
    1687. "pid": 36974
    1688. }
    1689. ,
    1690. {
    1691. "id": 273392,
    1692. "names": "不锈钢",
    1693. "number": 0,
    1694. "params": { },
    1695. "pid": 36974
    1696. }
    1697. ,
    1698. {
    1699. "id": 273397,
    1700. "names": "塑料",
    1701. "number": 0,
    1702. "params": { },
    1703. "pid": 36974
    1704. }
    1705. ,
    1706. {
    1707. "id": 273400,
    1708. "names": "铁镍合金钢",
    1709. "number": 0,
    1710. "params": { },
    1711. "pid": 36974
    1712. }
    1713. ,
    1714. {
    1715. "id": 273401,
    1716. "names": "棉",
    1717. "number": 0,
    1718. "params": { },
    1719. "pid": 36974
    1720. }
    1721. ,
    1722. {
    1723. "id": 273407,
    1724. "names": "铜合金",
    1725. "number": 0,
    1726. "params": { },
    1727. "pid": 36974
    1728. }
    1729. ,
    1730. {
    1731. "id": 273409,
    1732. "names": "木",
    1733. "number": 0,
    1734. "params": { },
    1735. "pid": 36974
    1736. }
    1737. ]
    1738. }
    1739. ,
    1740. {
    1741. "id": 36975,
    1742. "names": "类型:",
    1743. "nums": 0,
    1744. "params": { },
    1745. "pid": 14845,
    1746. "status": 1,
    1747. "tKeywordList": [
    1748. {
    1749. "id": 273377,
    1750. "names": "办公摆件",
    1751. "number": 0,
    1752. "params": { },
    1753. "pid": 36975
    1754. }
    1755. ,
    1756. {
    1757. "id": 273378,
    1758. "names": "切纸刀",
    1759. "number": 0,
    1760. "params": { },
    1761. "pid": 36975
    1762. }
    1763. ,
    1764. {
    1765. "id": 273383,
    1766. "names": "绘图测量",
    1767. "number": 0,
    1768. "params": { },
    1769. "pid": 36975
    1770. }
    1771. ,
    1772. {
    1773. "id": 273386,
    1774. "names": "剪刀/美工刀",
    1775. "number": 0,
    1776. "params": { },
    1777. "pid": 36975
    1778. }
    1779. ,
    1780. {
    1781. "id": 273389,
    1782. "names": "其他",
    1783. "number": 0,
    1784. "params": { },
    1785. "pid": 36975
    1786. }
    1787. ,
    1788. {
    1789. "id": 273390,
    1790. "names": "笔筒/收纳",
    1791. "number": 0,
    1792. "params": { },
    1793. "pid": 36975
    1794. }
    1795. ,
    1796. {
    1797. "id": 273393,
    1798. "names": "胶带/封装器",
    1799. "number": 0,
    1800. "params": { },
    1801. "pid": 36975
    1802. }
    1803. ,
    1804. {
    1805. "id": 273395,
    1806. "names": "办公套装",
    1807. "number": 0,
    1808. "params": { },
    1809. "pid": 36975
    1810. }
    1811. ,
    1812. {
    1813. "id": 273398,
    1814. "names": "切割雕刻垫板",
    1815. "number": 0,
    1816. "params": { },
    1817. "pid": 36975
    1818. }
    1819. ,
    1820. {
    1821. "id": 273402,
    1822. "names": "办公生活",
    1823. "number": 0,
    1824. "params": { },
    1825. "pid": 36975
    1826. }
    1827. ,
    1828. {
    1829. "id": 273404,
    1830. "names": "雕刻刀",
    1831. "number": 0,
    1832. "params": { },
    1833. "pid": 36975
    1834. }
    1835. ,
    1836. {
    1837. "id": 273405,
    1838. "names": "刀片",
    1839. "number": 0,
    1840. "params": { },
    1841. "pid": 36975
    1842. }
    1843. ,
    1844. {
    1845. "id": 273408,
    1846. "names": "胶棒/胶水",
    1847. "number": 0,
    1848. "params": { },
    1849. "pid": 36975
    1850. }
    1851. ]
    1852. }
    1853. ,
    1854. {
    1855. "id": 36976,
    1856. "names": "剪切类:",
    1857. "nums": 0,
    1858. "params": { },
    1859. "pid": 14845,
    1860. "status": 1,
    1861. "tKeywordList": [
    1862. {
    1863. "id": 273372,
    1864. "names": "锉刀",
    1865. "number": 0,
    1866. "params": { },
    1867. "pid": 36976
    1868. }
    1869. ,
    1870. {
    1871. "id": 273373,
    1872. "names": "美工刀",
    1873. "number": 0,
    1874. "params": { },
    1875. "pid": 36976
    1876. }
    1877. ,
    1878. {
    1879. "id": 273394,
    1880. "names": "割刀",
    1881. "number": 0,
    1882. "params": { },
    1883. "pid": 36976
    1884. }
    1885. ,
    1886. {
    1887. "id": 273399,
    1888. "names": "雕刻刀",
    1889. "number": 0,
    1890. "params": { },
    1891. "pid": 36976
    1892. }
    1893. ,
    1894. {
    1895. "id": 273403,
    1896. "names": "壁纸刀",
    1897. "number": 0,
    1898. "params": { },
    1899. "pid": 36976
    1900. }
    1901. ,
    1902. {
    1903. "id": 273406,
    1904. "names": "园林剪",
    1905. "number": 0,
    1906. "params": { },
    1907. "pid": 36976
    1908. }
    1909. ]
    1910. }
    1911. ],
    1912. "tSpecifications": [
    1913. {
    1914. "discount": 0.6,
    1915. "id": 218,
    1916. "names": "2038363",
    1917. "number": 187,
    1918. "prices": 2.42,
    1919. "scribingprice": 4,
    1920. "stocknum": 100,
    1921. "tCommodityPriceSets": [ ]
    1922. }
    1923. ],
    1924. "threeid": 14845,
    1925. "top": 0,
    1926. "transactionnum": 0,
    1927. "twoid": 14822,
    1928. "types": 1
    1929. }