4 000 ₴
Візочок Anex e/type 2 в 1
4000.0
Краматорськ
Знайдено 118 оголошень
{
"query": {
"bool": {
"must": [
{
"multi_match": {
"query": "type 2 type",
"fields": [
"name^3",
"description",
"city^2"
],
"type": "best_fields",
"operator": "and",
"fuzziness": "AUTO",
"prefix_length": 2
}
}
],
"filter": [
{
"term": {
"city_id": 2139
}
}
]
}
},
"sort": [
"_score",
{
"data_post": {
"order": "desc"
}
}
],
"from": 0,
"size": 50,
"_source": [
"id",
"m2",
"km",
"price2",
"attribute"
],
"track_total_hits": true,
"aggs": {
"cats": {
"terms": {
"field": "category_id",
"size": 2000
}
}
}
}SELECT c.* FROM `category` c ORDER BY c.id · 41.08 msSELECT c.id, c.parent_id, c.url AS slug, COALESCE(NULLIF(c.name_ua, ''), NULLIF(c.name, '')) AS name, NULL AS name_loc FROM `city` c WHERE c.url IN (?, ?, ?, ?) LIMIT 1 ["kramatorsk","\/kramatorsk","kramatorsk\/","\/kramatorsk\/"] · 0.49 msSELECT c.id FROM `city` c WHERE c.parent_id = 0 LIMIT 2 · 0.26 msSHOW TABLES · 1.11 msSELECT p.id, p.category_id, p.city_id, p.region AS region_id, p.vendor AS vendor_id, p.name, p.description, p.name AS name_orig, p.price, p.currency, p.bargain, p.conditions, p.url, p.img, p.view AS views, p.data_post, p.data_edit, COALESCE(NULLIF(c.name_ua, ''), NULLIF(c.name, '')) AS city_name, c.url AS city_slug FROM `post` p LEFT JOIN `city` c ON c.id = p.city_id WHERE p.id IN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) AND (1=1) [196841968,187087647,200066005,195654773,202371130,208632577,192862849,217043323,192514243,204815225,196618366,211634922,201540177,193803266,201583907,197803141,198060375,190950336,217451236,171311767,205175447,199802818,197803105,217096954,201449143,192941920,202969966,206907231,216170257,209215810,205309808,198183859,204815216,194172311,205105388,217686472,197120542,202640659,216266242,212943081,200764684,200764507,194874029,184091511,196714478,179644907,206899799,197672087,197071963,197672060] · 145.6 msSELECT v.post_id, v.attribute_id, v.value, COALESCE(NULLIF(a.name_ua, ''), NULLIF(a.name, '')) AS name FROM `attribute_value` v JOIN `attribute` a ON a.id = v.attribute_id WHERE v.post_id IN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) AND v.value IS NOT NULL AND v.value <> '' ORDER BY a.id [171311767,179644907,184091511,187087647,190950336,192514243,192862849,192941920,193803266,194172311,194874029,195654773,196618366,196714478,196841968,197071963,197120542,197672060,197672087,197803105,197803141,198060375,198183859,199802818,200066005,200764507,200764684,201449143,201540177,201583907,202371130,202640659,202969966,204815216,204815225,205105388,205175447,205309808,206899799,206907231,208632577,209215810,211634922,212943081,216170257,216266242,217043323,217096954,217451236,217686472] · 7.15 msSELECT c.id, c.parent_id, c.url AS slug, COALESCE(NULLIF(c.name_ua, ''), NULLIF(c.name, '')) AS name, NULL AS name_loc FROM `city` c WHERE c.parent_id = ? LIMIT 3000 [5] · 71.76 ms