9 500 $
DAF CF 85 DAF CF 85 410
940 000 км 418000.0
Одеса
Знайдено 57 оголошень
{
"query": {
"bool": {
"must": [
{
"multi_match": {
"query": "daf 85 cf",
"fields": [
"name^3",
"description",
"city^2"
],
"type": "best_fields",
"operator": "and",
"fuzziness": "AUTO",
"prefix_length": 2
}
}
],
"filter": [
{
"term": {
"city_id": 127
}
}
]
}
},
"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 · 9.14 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 ["odessa","\/odessa","odessa\/","\/odessa\/"] · 5.04 msSELECT c.id FROM `city` c WHERE c.parent_id = 0 LIMIT 2 · 0.42 msSHOW TABLES · 2.39 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) [208809529,191714923,213971634,211146153,210528143,210527762,209900873,206852405,204168876,204151110,203905860,203671940,190685289,187449762,186848166,186848169,186434805,185368437,184075710,180048850,177733300,176423075,175752088,175741438,174467299,170358760,170204077,170060380,213887938,200491204,188785851,188296671,186513744,183262447,167117632,207977092,190081458,173499364,219053243,169508134,219084302,210849902,211533141,200347216,192741946,196358609,208706353,191816113,210034295,183263439] · 97.81 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 [167117632,169508134,170060380,170204077,170358760,173499364,174467299,175741438,175752088,176423075,177733300,180048850,183262447,183263439,184075710,185368437,186434805,186513744,186848166,186848169,187449762,188296671,188785851,190081458,190685289,191714923,191816113,192741946,196358609,200347216,200491204,203671940,203905860,204151110,204168876,206852405,207977092,208706353,208809529,209900873,210034295,210527762,210528143,210849902,211146153,211533141,213887938,213971634,219053243,219084302] · 9.22 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] · 4.78 ms