8 048 ₴
долгосрочная аренда Золотое
8048.0
Золотое
Найдено 784 объявления
{
"query": {
"bool": {
"filter": [
{
"terms": {
"city_id": [
2173,
123,
2174,
2175,
2176,
2178,
2179,
2513,
2958,
3374,
3375,
3376,
3377,
3378,
3379,
3380,
3381,
3382,
3383,
3384,
3385,
3386,
3387,
3388,
3389,
3390,
3391,
3392,
3393,
3627,
3628,
3629,
3655,
6106,
6494,
6636,
6644,
6856,
7014,
7029,
7130,
7218,
7268,
7285,
7327,
7337,
7370,
7398,
7439,
7573,
7595,
7827,
7973,
8099,
8171,
8206,
8224,
8325,
8343,
8566,
8615,
8705,
8748,
8831,
8858,
8907,
8977,
9151,
9160,
9314,
9324,
9378,
9419,
9551,
9577,
9655,
9665,
9700,
9758,
9819,
10067,
10087,
10374,
10421,
10699,
10705,
10716,
10744,
10762,
10867,
10901,
10917,
10972,
11122,
11158,
11313,
11326,
11492,
11514,
11660,
11717,
11779,
11852,
11905,
11930,
11953,
12027,
12064,
12066,
12089,
12103,
12227,
12253,
12330,
12345,
12372,
12401,
12482,
12502,
12600,
12708
]
}
}
]
}
},
"sort": [
{
"data_post": {
"order": "desc"
}
},
{
"id": "desc"
}
],
"from": 0,
"size": 50,
"_source": [
"id",
"m2",
"km",
"price2",
"attribute"
],
"track_total_hits": true,
"aggs": {
"cities": {
"terms": {
"field": "city_id",
"size": 30
}
}
}
}SELECT c.* FROM `category` c ORDER BY c.id · 1.87 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 ["luganskaya-oblast","\/luganskaya-oblast","luganskaya-oblast\/","\/luganskaya-oblast\/"] · 0.87 msSELECT c.id FROM `city` c WHERE c.parent_id = 0 LIMIT 2 · 0.44 msSELECT c.id FROM `city` c WHERE c.parent_id IN (?) [2173] · 0.93 msSELECT c.id FROM `city` c WHERE c.parent_id IN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) [123,2174,2175,2176,2178,2179,2513,2958,3374,3375,3376,3377,3378,3379,3380,3381,3382,3383,3384,3385,3386,3387,3388,3389,3390,3391,3392,3393,3627,3628,3629,3655,6106,6494,6636,6644,6856,7014,7029,7130,7218,7268,7285,7327,7337,7370,7398,7439,7573,7595,7827,7973,8099,8171,8206,8224,8325,8343,8566,8615,8705,8748,8831,8858,8907,8977,9151,9160,9314,9324,9378,9419,9551,9577,9655,9665,9700,9758,9819,10067,10087,10374,10421,10699,10705,10716,10744,10762,10867,10901,10917,10972,11122,11158,11313,11326,11492,11514,11660,11717,11779,11852,11905,11930,11953,12027,12064,12066,12089,12103,12227,12253,12330,12345,12372,12401,12482,12502,12600,12708] · 1.27 msSHOW TABLES · 0.97 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) [219857630,219826914,219771414,219771398,219749742,219629634,219628890,219561883,219504148,219503080,219482056,219355681,219335920,219288181,219286993,219206812,219143324,219140015,219109853,219091529,219030773,218986706,218977910,218976947,218967734,218963693,218925989,218904182,218895827,218889419,218876678,218816444,218797124,218778149,218777486,218709923,218688422,218685086,218607515,218586056,218521709,218487947,218460254,218457887,218457806,218421881,218427611,218319686,218278600,218275552] · 28.71 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 [218275552,218278600,218319686,218427611,218457806,218457887,218460254,218487947,218521709,218586056,218607515,218685086,218688422,218709923,218777486,218778149,218797124,218816444,218876678,218889419,218895827,218904182,218925989,218963693,218967734,218976947,218977910,218986706,219030773,219091529,219109853,219140015,219143324,219206812,219286993,219288181,219335920,219355681,219482056,219503080,219504148,219561883,219628890,219629634,219749742,219771398,219771414,219826914,219857630] · 20.5 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 [2173] · 2.88 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.id IN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) [3382,3393,123,7370,8224,9314,9324,9577,6644,11905,3380,7029,7439,3387,3388,2176,8615,2178,2174,10699,3377,7130,8977,12253] · 1.19 ms