2 000 ₴
долгосрочная аренда Гагаріна Рокитное
39 м² 2000.0
Рокитне
Знайдено 5 987 оголошень
{
"query": {
"bool": {
"filter": [
{
"term": {
"city_id": 3505
}
}
]
}
},
"sort": [
{
"data_post": {
"order": "desc"
}
},
{
"id": "desc"
}
],
"from": 1150,
"size": 50,
"_source": [
"id",
"m2",
"km",
"price2",
"attribute"
],
"track_total_hits": true
}SELECT c.* FROM `category` c ORDER BY c.id · 1.94 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 ["rokitnoe","\/rokitnoe","rokitnoe\/","\/rokitnoe\/"] · 1.06 msSELECT c.id FROM `city` c WHERE c.parent_id = 0 LIMIT 2 · 0.35 msSHOW TABLES · 3.45 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) [213365697,213350967,213341424,213327744,213319674,213300009,213291060,213265977,213249783,213248178,213240741,213240483,213232920,213232326,213231249,213219336,213206865,213192180,213187242,213184083,213184032,213181824,213181476,213176712,213169479,213168942,213165669,213157125,213155112,213152190,213150864,213148425,213145389,213138012,213120771,213118974,213117936,213108051,213094017,213093855,213093240,213075687,213074187,213056520,213050742,213049779,213030543,213020829,213017112,212992470] · 77.17 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 [212992470,213017112,213020829,213030543,213049779,213050742,213056520,213074187,213075687,213093240,213093855,213094017,213108051,213117936,213118974,213120771,213138012,213145389,213148425,213150864,213152190,213155112,213157125,213165669,213168942,213169479,213176712,213181476,213181824,213184032,213184083,213187242,213192180,213206865,213219336,213231249,213232326,213232920,213240483,213240741,213248178,213249783,213265977,213291060,213300009,213319674,213327744,213341424,213350967,213365697] · 36.99 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] · 3.19 ms