1 450 $
Ford C-Max 2015
63800.0
Рівне
Знайдено 179 оголошень
{
"query": {
"bool": {
"must": [
{
"multi_match": {
"query": "ford c max 2012",
"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 · 10.64 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\/"] · 3.08 msSELECT c.id FROM `city` c WHERE c.parent_id = 0 LIMIT 2 · 0.37 msSHOW TABLES · 0.79 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) [205947287,199649824,199363339,218818430,200443645,216813773,216812957,210086792,210086789,180558841,215384462,211011592,198554566,188268813,210081371,198046359,218818472,215433144,210081509,198525190,198046441,219488434,217040914,214693527,213448275,199364350,195214982,179690913,216813827,201366905,218705579,215045388,213978732,198551188,201172360,218818397,217731949,217079071,215384344,214661613,210607979,207169243,198555288,196705181,195851186,191249766,177586693,212131218,218818568,218818523] · 178.12 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 [177586693,179690913,180558841,188268813,191249766,195214982,195851186,196705181,198046359,198046441,198525190,198551188,198554566,198555288,199363339,199364350,199649824,200443645,201172360,201366905,205947287,207169243,210081371,210086789,210086792,212131218,213448275,214661613,214693527,215384462,215433144,216812957,216813773,216813827,217040914,217079071,217731949,218705579,218818397,218818430,218818472,218818523,218818568,219488434] · 4.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] · 0.64 ms