185 000 ₴
1014223 продаж 5-к будинок Бориспільський, Бориспіль, 185000 $
185000.0
Борисполь
Найдено 33 052 объявления
{
"query": {
"bool": {
"filter": [
{
"term": {
"city_id": 2166
}
}
]
}
},
"sort": [
{
"data_post": {
"order": "desc"
}
},
{
"id": "desc"
}
],
"from": 8100,
"size": 50,
"_source": [
"id",
"m2",
"km",
"price2",
"attribute"
],
"track_total_hits": true
}SELECT c.* FROM `category` c ORDER BY c.id · 1.4 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 ["borispol","\/borispol","borispol\/","\/borispol\/"] · 0.46 msSELECT c.id FROM `city` c WHERE c.parent_id = 0 LIMIT 2 · 0.66 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, ''), 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) [211703865,211703862,211702884,211700640,211700214,211700208,211699959,211699725,211699023,211698687,211698567,211698414,211696155,211693527,211693209,211692771,211692654,211691067,211690599,211688961,211687971,211687863,211687470,211687179,211687080,211681389,211677894,211671666,211670136,211669629,211668528,211667634,211666902,211665999,211660914,211658646,211658559,211658217,211657863,211657020,211656636,211653753,211652034,211650789,211650450,211648863,211647519,211646139,211641804,211640601] · 37.37 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 [211640601,211641804,211646139,211647519,211648863,211650450,211650789,211652034,211653753,211656636,211657020,211657863,211658217,211658559,211658646,211660914,211665999,211666902,211667634,211668528,211669629,211670136,211671666,211677894,211681389,211687080,211687179,211687470,211687863,211687971,211688961,211690599,211691067,211692654,211692771,211693209,211693527,211696155,211698414,211698567,211698687,211699023,211699725,211699959,211700208,211700214,211700640,211702884,211703862,211703865] · 76.85 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] · 0.53 ms