74 750 $
Є-ОСЕЛЯ 2% | Дуплекс 65 м2
65 м² 3289000.0
Боярка
Найдено 10 595 объявлений
{
"query": {
"bool": {
"filter": [
{
"term": {
"city_id": 2445
}
}
]
}
},
"sort": [
{
"data_post": {
"order": "desc"
}
},
{
"id": "desc"
}
],
"from": 1300,
"size": 50,
"_source": [
"id",
"m2",
"km",
"price2",
"attribute"
],
"track_total_hits": true
}SELECT c.* FROM `category` c ORDER BY c.id · 41.54 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 ["boyarka","\/boyarka","boyarka\/","\/boyarka\/"] · 0.36 msSELECT c.id FROM `city` c WHERE c.parent_id = 0 LIMIT 2 · 2.58 msSHOW TABLES · 41.46 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) [216864352,216862432,216861595,216860998,216860566,216860548,216858652,216858004,216855655,216849433,216848248,216847573,216846211,216845401,216844852,216844336,216844276,216844273,216842434,216835015,216832318,216832147,216831607,216827797,216827387,216826225,216825739,216825427,216821915,216820297,216820119,216820005,216815237,216813207,216811779,216808547,216807779,216807709,216807619,216802849,216801125,216799279,216797967,216795441,216794773,216792945,216792647,216791165,216790133,216787303] · 1192.35 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 [216787303,216790133,216791165,216792647,216792945,216794773,216795441,216797967,216799279,216801125,216802849,216807619,216807709,216807779,216808547,216811779,216813207,216815237,216820005,216820119,216820297,216821915,216825427,216825739,216826225,216827387,216827797,216831607,216832147,216832318,216835015,216842434,216844273,216844276,216844336,216844852,216845401,216846211,216847573,216848248,216849433,216855655,216858004,216858652,216860548,216860566,216860998,216861595,216862432,216864352] · 125.71 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 [5] · 4.06 ms