16 500 $
продажа Комсомольская Ивановка
726000.0
Іванівка
Знайдено 1 416 оголошень
{
"query": {
"bool": {
"filter": [
{
"term": {
"city_id": 6193
}
}
]
}
},
"sort": [
{
"data_post": {
"order": "desc"
}
},
{
"id": "desc"
}
],
"from": 1050,
"size": 50,
"_source": [
"id",
"m2",
"km",
"price2",
"attribute"
],
"track_total_hits": true
}SELECT c.* FROM `category` c ORDER BY c.id · 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.url IN (?, ?, ?, ?) LIMIT 1 ["ivanovka","\/ivanovka","ivanovka\/","\/ivanovka\/"] · 1.53 msSELECT c.id FROM `city` c WHERE c.parent_id = 0 LIMIT 2 · 3.56 msSHOW TABLES · 1.41 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) [195086321,195041108,195036299,195035921,195021071,195002639,194997188,194996147,194973344,194930438,194928416,194894057,194880185,194874815,194718923,194685020,194643116,194642945,194636342,194491346,194438822,194437016,194215175,194214626,194202146,194144786,194012135,193972168,193970814,193963254,193886249,193871168,193765301,193633592,193578017,193576136,193576118,193574600,193574486,193563389,193563107,193381995,193198075,193152209,192839089,192814081,192684307,192675931,192656524,192562330] · 58.21 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 [192562330,192656524,192675931,192684307,192814081,192839089,193152209,193198075,193381995,193563107,193563389,193574486,193574600,193576118,193576136,193578017,193633592,193765301,193871168,193886249,193963254,193970814,193972168,194012135,194144786,194202146,194214626,194215175,194437016,194438822,194491346,194636342,194642945,194643116,194685020,194718923,194874815,194880185,194894057,194928416,194930438,194973344,194996147,194997188,195002639,195021071,195035921,195036299,195041108,195086321] · 1.19 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.65 ms