250 000 $
Будинок 370 м2 - 35 соток, ВИХІД НА ДНІПРО, с. Вишеньки, Бориспільський район
370 м² 11000000.0
Вишеньки
Знайдено 2 603 оголошення
{
"query": {
"bool": {
"filter": [
{
"term": {
"city_id": 6164
}
}
]
}
},
"sort": [
{
"data_post": {
"order": "desc"
}
},
{
"id": "desc"
}
],
"from": 350,
"size": 50,
"_source": [
"id",
"m2",
"km",
"price2",
"attribute"
],
"track_total_hits": true
}SELECT c.* FROM `category` c ORDER BY c.id · 2.55 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 ["vishenki","\/vishenki","vishenki\/","\/vishenki\/"] · 1.44 msSELECT c.id FROM `city` c WHERE c.parent_id = 0 LIMIT 2 · 0.61 msSHOW TABLES · 0.37 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) [216383395,216383386,216377689,216375706,216367684,216346084,216345301,216334609,216317134,216312151,216311587,216294112,216291652,216288490,216271972,216271834,216253600,216242329,216239146,216239011,216235510,216227134,216224410,216209692,216191311,216174523,216147790,216141268,216117067,216114871,216092137,216088855,216083284,216070714,216064792,216064732,216064723,216064591,216055318,216023422,216020596,216007960,215998318,215992405,215975626,215974795,215914603,215911819,215866885,215861152] · 67.76 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 [215861152,215866885,215911819,215914603,215974795,215975626,215992405,215998318,216007960,216020596,216023422,216055318,216064591,216064723,216064732,216064792,216070714,216083284,216088855,216092137,216114871,216117067,216141268,216147790,216174523,216191311,216209692,216224410,216227134,216235510,216239011,216239146,216242329,216253600,216271834,216271972,216288490,216291652,216294112,216311587,216312151,216317134,216334609,216345301,216346084,216367684,216375706,216377689,216383386,216383395] · 58.01 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] · 3.9 ms