8 000 $
Ford Transit Custom
245 000 км 352000.0
Львів
Знайдено 448 оголошень
{
"query": {
"bool": {
"must": [
{
"multi_match": {
"query": "ford transit custom",
"fields": [
"name^3",
"description",
"city^2"
],
"type": "best_fields",
"operator": "and",
"fuzziness": "AUTO",
"prefix_length": 2
}
}
],
"filter": [
{
"term": {
"city_id": 125
}
}
]
}
},
"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 · 1.79 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 ["lvov","\/lvov","lvov\/","\/lvov\/"] · 0.63 msSELECT c.id FROM `city` c WHERE c.parent_id = 0 LIMIT 2 · 0.41 msSHOW TABLES · 1.19 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) [212437224,210867060,210434438,210133337,209224750,207863617,207518944,205655915,205553513,205427249,204900749,204750137,203695025,203379296,201643003,201534329,199340320,198418874,198359874,198096454,193586108,193266604,193087142,191445520,189134532,188482221,188191575,186473691,186342528,185059236,183695613,183316282,182982552,182700432,182486764,181508518,180838885,180444322,179456813,175545756,173108950,172860859,172799071,172350034,171791176,171202474,169577002,169571524,168920902,215337084] · 30.79 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 [168920902,169571524,169577002,171202474,171791176,172350034,172799071,172860859,173108950,175545756,179456813,180444322,180838885,181508518,182486764,182700432,182982552,183316282,183695613,185059236,186342528,186473691,188191575,188482221,189134532,191445520,193087142,193266604,193586108,198096454,198359874,198418874,199340320,201534329,201643003,203379296,203695025,204750137,204900749,205427249,205553513,205655915,207518944,207863617,209224750,210133337,210434438,210867060,212437224,215337084] · 9.28 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.92 ms