2 350 $
..…AUDI A6 C4…..
399 000 км 103400.0
Хмельницький
Знайдено 10 665 оголошень
{
"query": {
"bool": {
"must": [
{
"multi_match": {
"query": "audi a6 c4",
"fields": [
"name^3",
"description",
"city^2"
],
"type": "best_fields",
"operator": "and",
"fuzziness": "AUTO",
"prefix_length": 2
}
}
]
}
},
"sort": [
"_score",
{
"data_post": {
"order": "desc"
}
}
],
"from": 0,
"size": 50,
"_source": [
"id",
"m2",
"km",
"price2",
"attribute"
],
"track_total_hits": true,
"aggs": {
"cities": {
"terms": {
"field": "city_id",
"size": 30
}
},
"cats": {
"terms": {
"field": "category_id",
"size": 2000
}
}
}
}SHOW TABLES · 2.48 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) [214171892,210511898,203880291,215516169,187099923,219480985,219473101,219469381,219009419,218959616,218465261,218080945,217284112,216668281,216446446,216069412,215391682,214284588,214291632,212468136,209443027,207606760,207505753,207054801,205186313,203763732,202228978,201272356,196940043,196806952,188475972,184796716,181018411,174860908,173123194,191574925,189186840,212053311,178987579,217014262,216866383,190873302,213921150,201843307,198580660,219628646,219165968,218995790,218765876,218709770] · 20.47 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 [173123194,174860908,178987579,181018411,184796716,187099923,188475972,189186840,190873302,191574925,196806952,196940043,198580660,201272356,201843307,202228978,203763732,203880291,205186313,207054801,207505753,207606760,209443027,210511898,212053311,212468136,213921150,214171892,214291632,215391682,215516169,216069412,216446446,216668281,216866383,217014262,217284112,218080945,218465261,218709770,218765876,218959616,218995790,219009419,219165968,219480985,219628646] · 4.66 msSELECT c.* FROM `category` c ORDER BY c.id · 0.57 msSELECT c.id FROM `city` c WHERE c.parent_id = 0 LIMIT 2 · 1.26 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] · 0.4 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.id IN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) [115,2124,116,121,125,124,117,135,140,127,139,3337,120,6574,129,137,3085,119,128,138,133,2172,126,6586,6369,2107,132,2165,2101,134] · 0.49 ms