115 000 $
Продаж будинку Новостав 123кв/м
123 м² 5060000.0
Новостав
Знайдено 155 оголошень
{
"query": {
"bool": {
"filter": [
{
"term": {
"city_id": 7354
}
}
]
}
},
"sort": [
{
"data_post": {
"order": "desc"
}
},
{
"id": "desc"
}
],
"from": 50,
"size": 50,
"_source": [
"id",
"m2",
"km",
"price2",
"attribute"
],
"track_total_hits": true
}SELECT c.* FROM `category` c ORDER BY c.id · 2.39 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 ["novostav","\/novostav","novostav\/","\/novostav\/"] · 2.02 msSELECT c.id FROM `city` c WHERE c.parent_id = 0 LIMIT 2 · 0.51 msSHOW TABLES · 1.23 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) [211612467,211486557,211450476,211180515,211094944,211043594,210891866,210887920,210436100,210045581,209964113,209771612,209739722,209677271,209507419,209410723,209311057,209308261,209256808,209214796,209130937,208610797,208283521,208104730,207938713,207136810,207088411,207018617,207011279,206833951,205874825,205578416,205504292,204716810,204714593,204235641,204033618,203892924,203626884,203375888,202168840,201987787,201747363,201242821,200922973,200791525,200576611,200536576,200525530,200306014] · 51.34 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 [200306014,200525530,200536576,200576611,200791525,200922973,201242821,201747363,201987787,202168840,203375888,203626884,203892924,204033618,204235641,204714593,204716810,205504292,205578416,205874825,206833951,207011279,207018617,207088411,207136810,207938713,208104730,208283521,208610797,209130937,209214796,209256808,209308261,209311057,209410723,209507419,209677271,209739722,209771612,209964113,210045581,210436100,210887920,210891866,211043594,211094944,211180515,211450476,211486557,211612467] · 46.35 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.39 ms