17 083 ₴
долгосрочная аренда Григоровка
17083.0
Григорівка
Знайдено 317 оголошень
{
"query": {
"bool": {
"filter": [
{
"term": {
"city_id": 6423
}
}
]
}
},
"sort": [
{
"data_post": {
"order": "desc"
}
},
{
"id": "desc"
}
],
"from": 250,
"size": 50,
"_source": [
"id",
"m2",
"km",
"price2",
"attribute"
],
"track_total_hits": true
}SELECT c.* FROM `category` c ORDER BY c.id · 4.61 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 ["grigorovka","\/grigorovka","grigorovka\/","\/grigorovka\/"] · 0.93 msSELECT c.id FROM `city` c WHERE c.parent_id = 0 LIMIT 2 · 0.35 msSHOW TABLES · 0.71 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) [191793820,191723029,191439952,191260996,191003850,189768045,189173850,189110217,189110199,189110196,189110178,189110169,189110166,189110163,188369232,188285673,188199357,188000412,187983129,187821084,186996039,185969538,185931978,185650581,185473347,185302422,185175423,184568230,184526023,184419141,184362291,183975957,183521463,183369543,183161790,182197537,182140822,182037049,182000305,181770385,179996728,179689523,179685271,178767232,178499338,177975810,177742228,177695620,176972089,176439263] · 118.46 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 [176439263,176972089,177695620,177742228,177975810,178499338,178767232,179685271,179689523,179996728,181770385,182000305,182037049,182140822,182197537,183161790,183369543,183521463,183975957,184362291,184419141,184526023,184568230,185175423,185302422,185473347,185650581,185931978,185969538,186996039,187821084,187983129,188000412,188199357,188285673,188369232,189110163,189110166,189110169,189110178,189110196,189110199,189110217,189173850,189768045,191003850,191260996,191439952,191723029,191793820] · 2.52 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.86 ms