5 000 ₴
долгосрочная аренда 30 лет Победы улица Низы
53 м² 5000.0
Низи
Знайдено 103 оголошення
{
"query": {
"bool": {
"filter": [
{
"term": {
"city_id": 7467
}
}
]
}
},
"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 · 14.62 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 ["nizy","\/nizy","nizy\/","\/nizy\/"] · 1.53 msSELECT c.id FROM `city` c WHERE c.parent_id = 0 LIMIT 2 · 0.53 msSHOW TABLES · 0.67 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) [213493002,213489702,213464946,213208932,212491386,211865994,211483059,211374582,211091236,211033804,210106646,209991392,209944145,209243029,209162089,208965868,208081495,207711874,207423448,207420937,207253807,206954493,206886693,204936617,204932132,204930539,204374549,204234588,203029459,200855869,198228651,196624147,196490840,196192850,194872376,194175119,192255592,192113227,192069703,191560972,190640511,190007997,190007391,189836859,189767952,187848156,187646313,185718828,181984429,175455681] · 60.01 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 [175455681,181984429,185718828,187646313,187848156,189767952,189836859,190007391,190007997,190640511,191560972,192069703,192113227,192255592,194175119,194872376,196192850,196490840,196624147,198228651,200855869,203029459,204234588,204374549,204930539,204932132,204936617,206886693,206954493,207253807,207420937,207423448,207711874,208081495,208965868,209162089,209243029,209944145,209991392,210106646,211033804,211091236,211374582,211483059,211865994,212491386,213208932,213464946,213489702,213493002] · 7.76 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] · 0.94 ms