5 200 $
Ford Escape Titanium 2020
228800.0
Рівне
Знайдено 106 оголошень
{
"query": {
"bool": {
"must": [
{
"multi_match": {
"query": "ford escape titanium",
"fields": [
"name^3",
"description",
"city^2"
],
"type": "best_fields",
"operator": "and",
"fuzziness": "AUTO",
"prefix_length": 2
}
}
],
"filter": [
{
"term": {
"city_id": 129
}
}
]
}
},
"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 · 6.88 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 ["rovno","\/rovno","rovno\/","\/rovno\/"] · 0.83 msSELECT c.id FROM `city` c WHERE c.parent_id = 0 LIMIT 2 · 0.33 msSHOW TABLES · 2.2 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) [206032202,202509435,197007523,196693576,204250191,213983274,192145561,217441072,204586205,203121043,201222451,197881129,196748313,195897029,193577951,193374935,192400348,192299137,192233941,192230602,192220822,192220804,192148084,219047903,215721329,215596380,193553047,193458205,216340129,216192343,214389741,217088626,214272777,215507595,171742765,219520495,219665930,205229018,194316101,175626532,172220068,176525314,198353554,174424339,188609367,191218494,209487304,202181488,178124169,180265093] · 206.22 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 [171742765,172220068,174424339,175626532,176525314,178124169,180265093,188609367,191218494,192145561,192148084,192220804,192220822,192230602,192233941,192299137,192400348,193374935,193458205,193553047,193577951,194316101,195897029,196693576,196748313,197007523,197881129,198353554,201222451,202181488,202509435,203121043,204250191,204586205,205229018,206032202,209487304,213983274,214272777,214389741,215507595,215596380,215721329,216192343,216340129,217088626,217441072,219047903,219520495,219665930] · 11.58 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] · 1.37 ms