110 000 $
Дом с газом в с. Подгорцы, до трассы 10 мин.
170 м² 4840000.0
Подгорцы
Найдено 1 565 объявлений
{
"query": {
"bool": {
"filter": [
{
"term": {
"city_id": 6268
}
}
]
}
},
"sort": [
{
"data_post": {
"order": "desc"
}
},
{
"id": "desc"
}
],
"from": 750,
"size": 50,
"_source": [
"id",
"m2",
"km",
"price2",
"attribute"
],
"track_total_hits": true
}SELECT c.* FROM `category` c ORDER BY c.id · 2.51 msSELECT c.id, c.parent_id, c.url AS slug, COALESCE(NULLIF(c.name, ''), NULLIF(c.name_ua, '')) AS name, NULL AS name_loc FROM `city` c WHERE c.url IN (?, ?, ?, ?) LIMIT 1 ["podgorcy","\/podgorcy","podgorcy\/","\/podgorcy\/"] · 1.45 msSELECT c.id FROM `city` c WHERE c.parent_id = 0 LIMIT 2 · 0.95 msSHOW TABLES · 14.11 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, ''), NULLIF(c.name_ua, '')) 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) [207056243,207056003,207051795,207041713,207037809,206958449,206958063,206956313,206950713,206949807,206896315,206886479,206866251,206862449,206862399,206857835,206857719,206855027,206842607,206840278,206840271,206840235,206837358,206826067,206822683,206822555,206822399,206822101,206817925,206817751,206804567,206790212,206786721,206784555,206050472,206043386,206021282,205914626,205892216,205855757,205850732,205824764,205812488,205798022,205697822,205688036,205659194,205625579,205579433,205516244] · 66.24 msSELECT v.post_id, v.attribute_id, v.value, COALESCE(NULLIF(a.name, ''), NULLIF(a.name_ua, '')) 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 [205516244,205579433,205625579,205659194,205688036,205697822,205798022,205812488,205824764,205850732,205855757,205892216,205914626,206021282,206043386,206050472,206784555,206786721,206790212,206804567,206817751,206817925,206822101,206822399,206822555,206822683,206826067,206837358,206840235,206840271,206840278,206842607,206855027,206857719,206857835,206862399,206862449,206866251,206886479,206896315,206949807,206950713,206956313,206958063,206958449,207037809,207041713,207051795,207056003,207056243] · 46.94 msSELECT c.id, c.parent_id, c.url AS slug, COALESCE(NULLIF(c.name, ''), NULLIF(c.name_ua, '')) AS name, NULL AS name_loc FROM `city` c WHERE c.parent_id = ? LIMIT 3000 [5] · 5.87 ms