Requests

~~stoggle_buttons~~ ~~stoggle_openDIV~~ ~~stoggle_closeDIV~~

PUT /_snapshot/backup
{
"type": "fs",
"settings": {
"location": "/var/backups/elasticsearch/snapshot",
"compress": true
}
}
GET /_snapshot/_all?pretty"
PUT /_snapshot/backup/es_index_products/?wait_for_completion=true
PUT /_snapshot/backup/es_index_lot/?wait_for_completion=true

GET /es_index_products/products/_search
{
"query": {
"bool": {
"must": [
{
"term": {
"brand.id": 129
}
}
]
}
},
"aggs": {
"brands_terms_agg": {
"terms": {
"size": 10000,
"field": "brand.id"
}
},
"lots_terms_agg": {
"terms": {
"size": 10000,
"field": "lots"
}
},
"users_terms_agg": {
"terms": {
"size": 10000,
"field": "attributes.user_id"
}
}
}
}

GET /es_index_lots/lots/_search
{
"query": {
"bool": {
"must": [
{
"term": {
"brand.id": 129
}
}
]
}
},
"aggs": {
"1_brand.id_terms_agg": {
"terms": {
"size": 10000,
"field": "brand.id"
}
}
}
}

GET /es_index_products/products/_search
{
"query": {
"bool": {
"must": [
{
"match_all": {}
},
{
"terms": {
"categories.id": "1"
}
},
{
"bool": {
"should": [
{
"bool": {
"must_not": {
"exists": {
"field": "categories"
}
}
}
},
{
"bool": {
"must": [
{
"exists": {
"field": "categories"
}
},
{
"term": {
"categories.enabled": 1
}
}
]
}
}
]
}
},
{
"bool": {
"should": [
{
"bool": {
"must_not": {
"exists": {
"field": "brand"
}
}
}
},
{
"bool": {
"must": [
{
"exists": {
"field": "brand"
}
},
{
"term": {
"brand.enabled": 1
}
}
]
}
}
]
}
},
{
"bool": {
"should": [
{
"bool": {
"must_not": {
"exists": {
"field": "model"
}
}
}
},
{
"bool": {
"must": [
{
"exists": {
"field": "model"
}
},
{
"term": {
"model.enabled": 1
}
}
]
}
}
]
}
},
{
"terms": {
"product_collections": [
"1"
]
}
},
{
"bool": {
"should": [
{
"nested": {
"path": "string_facet",
"query": {
"bool": {
"filter": [
{
"term": {
"string_facet.facet_name": {
"value": "diameter",
"boost": 1
}
}
},
{
"term": {
"string_facet.facet_value": {
"value": "66",
"boost": 1
}
}
}
]
}
}
}
},
{
"nested": {
"path": "string_facet",
"query": {
"bool": {
"filter": [
{
"term": {
"string_facet.facet_name": {
"value": "diameter",
"boost": 1
}
}
},
{
"term": {
"string_facet.facet_value": {
"value": "71",
"boost": 1
}
}
}
]
}
}
}
},
{
"nested": {
"path": "string_facet",
"query": {
"bool": {
"filter": [
{
"term": {
"string_facet.facet_name": {
"value": "diameter",
"boost": 1
}
}
},
{
"term": {
"string_facet.facet_value": {
"value": "73",
"boost": 1
}
}
}
]
}
}
}
}
]
}
},
{
"term": {
"attributes.product_status_id": 1
}
}
]
}
},
"aggs": {
"0_categories.id_filter_agg": {
"filter": {
"terms": {
"categories.id": "1"
}
},
"aggs": {
"categories.id_terms_agg": {
"terms": {
"size": 10000,
"field": "categories.id"
}
}
}
},
"1_brand.id_terms_agg": {
"terms": {
"size": 10000,
"field": "brand.id"
}
},
"2_model.id_terms_agg": {
"terms": {
"size": 10000,
"field": "model.id"
}
},
"3_product_collections_filter_agg": {
"filter": {
"terms": {
"product_collections": [
"1"
]
}
},
"aggs": {
"product_collections_terms_agg": {
"terms": {
"size": 10000,
"field": "product_collections"
}
}
}
},
"4_in_stock_terms_agg": {
"terms": {
"script": {
"source": "doc['lots'].values.size() > 0",
"lang": "painless"
},
"size": 10000
}
},
"5_string_facet_nested_agg": {
"nested": {
"path": "string_facet"
},
"aggs": {
"string_facet.facet_name_terms_agg": {
"terms": {
"size": 10000,
"field": "string_facet.facet_name"
},
"aggs": {
"string_facet.facet_value_terms_agg": {
"terms": {
"size": 10000,
"field": "string_facet.facet_value"
}
}
}
}
}
}
},
"min_score": 0.5,
"_source": false
}

GET /es_index_products/products/_search
{
"query": {
"bool": {
"must": [
{
"bool": {
"should": [
{
"nested": {
"path": "string_facet",
"query": {
"bool": {
"filter": [
{
"term": {
"string_facet.facet_name": {
"value": "diameter",
"boost": 1
}
}
},
{
"term": {
"string_facet.facet_value": {
"value": "53",
"boost": 1
}
}
}
]
}
}
}
}
]
}
}
]
}
},
"_source": false
}

GET /es_index_products/products/_search
{
"query": {
"bool": {
"must": [
{
"script": {
"script": {
"source": "doc['attributes.id'].value == params.id",
"params": {
"id": 1
},
"lang": "painless"
}
}
},
{
"script": {
"script": {
"source": "doc['attributes.cat_id'].value == params.cat_id",
"params": {
"cat_id": 1
},
"lang": "painless"
}
}
}
]
}
}
}

GET /es_index_products/products/_search
{
"body": {
"bool": {
"must": [
{
"script": {
"script": {
"source": "doc['attributes.id'].value == params.id",
"lang": "painless",
"params": {
"id": 1
}
}
}
},
{
"script": {
"script": {
"source": "doc['attributes.updated_at'].value == params.updated_at",
"lang": "painless",
"params": {
"updated_at": "2016-06-15 08:47:53"
}
}
}
}
]
}
}
}

GET /es_index_products/products/_search
{
"query": {
"script": {
"script": {
"source": "(doc['attributes.id'].value == params.id) && (doc['attributes.cat_id'].value == params.cat_id)",
"lang": "painless",
"params": {
"id": 7609,
"cat_id": 1
}
}
}
}
}

GET /es_index_lots/lots/_search
{
"query": {
"bool": {
"must": [
{
"term": {
"product_id": "102"
}
}
]
}
}
}

GET /es_index_products/products/_search
{
"query": {
"bool": {
"filter": [
{
"bool": {
"should": [
{
"bool": {
"must_not": {
"exists": {
"field": "categories"
}
}
}
},
{
"bool": {
"must": [
{
"exists": {
"field": "categories"
}
},
{
"term": {
"categories.enabled": 1
}
}
]
}
}
]
}
},
{
"bool": {
"should": [
{
"bool": {
"must_not": {
"exists": {
"field": "brand"
}
}
}
},
{
"bool": {
"must": [
{
"exists": {
"field": "brand"
}
},
{
"term": {
"brand.enabled": 1
}
}
]
}
}
]
}
},
{
"bool": {
"should": [
{
"bool": {
"must_not": {
"exists": {
"field": "model"
}
}
}
},
{
"bool": {
"must": [
{
"exists": {
"field": "model"
}
},
{
"term": {
"model.enabled": 1
}
}
]
}
}
]
}
},
{
"term": {
"product_status_id": 1
}
}
],
"must": [
{
"match_all": {}
}
]
}
},
"aggs": {
"0_categories.id_terms_agg": {
"terms": {
"size": 10000,
"field": "categories.id"
}
},
"1_brand.id_terms_agg": {
"terms": {
"size": 10000,
"field": "brand.id"
}
},
"2_model.id_terms_agg": {
"terms": {
"size": 10000,
"field": "model.id"
}
},
"3_product_collections_terms_agg": {
"terms": {
"size": 10000,
"field": "product_collections"
}
},
"4_in_stock_terms_agg": {
"terms": {
"script": {
"source": "doc.lots.values.size() > 0",
"lang": "painless"
},
"size": 10000
}
},
"5_string_facet_nested_agg": {
"nested": {
"path": "string_facet"
},
"aggs": {
"string_facet.facet_name_terms_agg": {
"terms": {
"size": 10000,
"field": "string_facet.facet_name"
},
"aggs": {
"string_facet.facet_value_terms_agg": {
"terms": {
"size": 10000,
"field": "string_facet.facet_value"
}
}
}
}
}
}
},
"_source": true
}

GET /es_index_products/products/_search
{
"query": {
"bool": {
"filter": [
{
"bool": {
"should": [
{
"bool": {
"must_not": {
"exists": {
"field": "categories"
}
}
}
},
{
"bool": {
"must": [
{
"exists": {
"field": "categories"
}
},
{
"term": {
"categories.enabled": 1
}
}
]
}
}
]
}
},
{
"bool": {
"should": [
{
"bool": {
"must_not": {
"exists": {
"field": "brand"
}
}
}
},
{
"bool": {
"must": [
{
"exists": {
"field": "brand"
}
},
{
"term": {
"brand.enabled": 1
}
}
]
}
}
]
}
},
{
"bool": {
"should": [
{
"bool": {
"must_not": {
"exists": {
"field": "model"
}
}
}
},
{
"bool": {
"must": [
{
"exists": {
"field": "model"
}
},
{
"term": {
"model.enabled": 1
}
}
]
}
}
]
}
},
{
"bool": {
"should": [
{
"nested": {
"path": "string_facet",
"query": {
"bool": {
"filter": [
{
"term": {
"string_facet.facet_name": {
"value": "diameter",
"boost": 1
}
}
},
{
"term": {
"string_facet.facet_value": {
"value": "53",
"boost": 1
}
}
}
]
}
}
}
}
]
}
},
{
"term": {
"product_status_id": 1
}
}
],
"must": [
{
"match_all": {}
},
{
"terms": {
"categories.id": [
"1"
]
}
}
]
}
},
"aggs": {
"0_categories.id_filter_agg": {
"filter": {
"terms": {
"categories.id": [
"1"
]
}
},
"aggs": {
"categories.id_terms_agg": {
"terms": {
"size": 10000,
"field": "categories.id"
}
}
}
},
"1_brand.id_terms_agg": {
"terms": {
"size": 10000,
"field": "brand.id"
}
},
"2_model.id_terms_agg": {
"terms": {
"size": 10000,
"field": "model.id"
}
},
"3_product_collections_terms_agg": {
"terms": {
"size": 10000,
"field": "product_collections"
}
},
"4_in_stock_terms_agg": {
"terms": {
"script": {
"source": "doc.lots.values.size() > 0",
"lang": "painless"
},
"size": 10000
}
},
"5_string_facet_nested_agg": {
"nested": {
"path": "string_facet"
},
"aggs": {
"string_facet.facet_name_terms_agg": {
"terms": {
"size": 10000,
"field": "string_facet.facet_name"
},
"aggs": {
"string_facet.facet_value_terms_agg": {
"terms": {
"size": 10000,
"field": "string_facet.facet_value"
}
}
}
}
}
}
},
"_source": false
}

GET /es_index_products/products/_search
{
"query": {
"bool": {
"filter": [
{
"bool": {
"should": [
{
"bool": {
"must_not": {
"exists": {
"field": "categories"
}
}
}
},
{
"bool": {
"must": [
{
"exists": {
"field": "categories"
}
},
{
"term": {
"categories.enabled": 1
}
}
]
}
}
]
}
},
{
"bool": {
"should": [
{
"bool": {
"must_not": {
"exists": {
"field": "brand"
}
}
}
},
{
"bool": {
"must": [
{
"exists": {
"field": "brand"
}
},
{
"term": {
"brand.enabled": 1
}
}
]
}
}
]
}
},
{
"bool": {
"should": [
{
"bool": {
"must_not": {
"exists": {
"field": "model"
}
}
}
},
{
"bool": {
"must": [
{
"exists": {
"field": "model"
}
},
{
"term": {
"model.enabled": 1
}
}
]
}
}
]
}
},
{
"bool": {
"should": [
{
"nested": {
"path": "string_facet",
"query": {
"bool": {
"filter": [
{
"term": {
"string_facet.facet_name": {
"value": "diameter",
"boost": 1
}
}
},
{
"term": {
"string_facet.facet_value": {
"value": "53",
"boost": 1
}
}
}
]
}
}
}
}
]
}
},
{
"term": {
"product_status_id": 1
}
}
],
"must": [
{
"match_all": {}
}
]
}
},
"_source": false
}

GET _search
{
"query": {
"match_all": {}
}
}

GET /es_index_products/products/_search
{
"query": {
"match_all": {}
}
}

GET /es_index_lots/lots/_search
{
"query": {
"match_all": {}
}
}

GET /es_index_products/products/_search
{
"query": {
"bool": {
"filter": [
{
"bool": {
"should": [
{
"bool": {
"must_not": {
"exists": {
"field": "categories"
}
}
}
},
{
"bool": {
"must": [
{
"exists": {
"field": "categories"
}
},
{
"term": {
"categories.enabled": 1
}
}
]
}
}
]
}
},
{
"bool": {
"should": [
{
"bool": {
"must_not": {
"exists": {
"field": "brand"
}
}
}
},
{
"bool": {
"must": [
{
"exists": {
"field": "brand"
}
},
{
"term": {
"brand.enabled": 1
}
}
]
}
}
]
}
},
{
"bool": {
"should": [
{
"bool": {
"must_not": {
"exists": {
"field": "model"
}
}
}
},
{
"bool": {
"must": [
{
"exists": {
"field": "model"
}
},
{
"term": {
"model.enabled": 1
}
}
]
}
}
]
}
},
{
"term": {
"product_status_id": 1
}
},
{
"script": {
"script": {
"source": "doc.product_collections.values.size() > 0",
"lang": "painless"
}
}
}
],
"must": [
{
"bool": {
"should": [
{
"multi_match": {
"query": "rolex",
"type": "cross_fields",
"fields": [
"product_model_ref^100",
"model.name^30",
"brand.name^15",
"brand.aliases^15",
"categories.name^20"
],
"operator": "and",
"boost": 1
}
},
{
"multi_match": {
"query": "rolex",
"type": "cross_fields",
"fields": [
"product_model_ref^100",
"model.name^30",
"brand.name^15",
"brand.aliases^15",
"categories.name^20"
],
"operator": "and",
"boost": 1
}
},
{
"multi_match": {
"query": "rolex",
"type": "cross_fields",
"fields": [
"product_model_ref^100",
"model.name^30",
"brand.name^15",
"brand.aliases^15",
"categories.name^20"
],
"operator": "and",
"boost": 1
}
}
]
}
}
]
}
},
"size": 1,
"_source": "*",
"sort": [
{
"_uid": {
"order": "asc"
}
}
]
}

POST /yii-log/_search
{
"query": {
"match": {
"category": {
"query": "Error",
"type": "phrase"
}
}
},
"size": 10,
"_source": "message",
"sort": [
{
"_uid": {
"order": "asc"
}
}
]
}

POST /yii-log/_search
{
"query": {
"match": {
"category": {
"query": "yii\\debug\\Module::checkAccess",
"type": "phrase"
}
}
},
"size": 1,
"_source": "*",
"sort": [
{
"_uid": {
"order": "asc"
}
}
]
}

POST /yii-log/_search
{
"query": {
"match": {
"category": {
"query": "yii\\web\\HttpException:404",
"type": "phrase"
}
}
},
"size": 1,
"_source": "*",
"sort": [
{
"_uid": {
"order": "asc"
}
}
]
}