12 300 $
Toyota RAV4
263 000 км 541200.0
Коломия
Знайдено 37 977 оголошень
{
"query": {
"bool": {
"filter": [
{
"term": {
"city_id": 2163
}
}
]
}
},
"sort": [
{
"data_post": {
"order": "desc"
}
},
{
"id": "desc"
}
],
"from": 9100,
"size": 50,
"_source": [
"id",
"m2",
"km",
"price2",
"attribute"
],
"track_total_hits": true
}SELECT c.* FROM `category` c ORDER BY c.id · 1.29 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 ["kolomyya","\/kolomyya","kolomyya\/","\/kolomyya\/"] · 0.53 msSELECT c.id FROM `city` c WHERE c.parent_id = 0 LIMIT 2 · 0.47 msSHOW TABLES · 0.82 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) [210108296,210108029,210106859,210105770,210104654,210104213,210103544,210103385,210103334,210102638,210102143,210100901,210100388,210099878,210099683,210098978,210098969,210098948,210098903,210098804,210098540,210097805,210094403,210093641,210093506,210093413,210092570,210091430,210091382,210091307,210090482,210090374,210090317,210090251,210082985,210081935,210081851,210077498,210077168,210074618,210073913,210071474,210070268,210068168,210067523,210066110,210065510,210065471,210064763,210064721] · 30.49 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 [210064721,210064763,210065471,210065510,210066110,210067523,210068168,210070268,210071474,210073913,210074618,210077168,210077498,210081851,210081935,210082985,210090251,210090317,210090374,210090482,210091307,210091382,210091430,210092570,210093413,210093506,210093641,210094403,210097805,210098540,210098804,210098903,210098948,210098969,210098978,210099683,210099878,210100388,210100901,210102143,210102638,210103334,210103385,210103544,210104213,210104654,210105770,210106859,210108029,210108296] · 10.52 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.61 ms