31 500 $
Продається 2-кімнатна квартира у Стебнику (район лікарні)
44 м² 1386000.0
Стебник
Найдено 1 502 объявления
{
"query": {
"bool": {
"filter": [
{
"term": {
"city_id": 6219
}
}
]
}
},
"sort": [
{
"data_post": {
"order": "desc"
}
},
{
"id": "desc"
}
],
"from": 350,
"size": 50,
"_source": [
"id",
"m2",
"km",
"price2",
"attribute"
],
"track_total_hits": true
}SELECT c.* FROM `category` c ORDER BY c.id · 47.96 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 ["stebnik","\/stebnik","stebnik\/","\/stebnik\/"] · 2.3 msSELECT c.id FROM `city` c WHERE c.parent_id = 0 LIMIT 2 · 0.48 msSHOW TABLES · 0.67 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) [213508452,213500775,213484692,213483462,213483312,213465738,213456108,213400956,213365373,213365061,213356685,213356622,213313632,213292536,213285456,213227829,213221190,213207282,213144276,213113487,213113313,213091803,213091137,213090771,213081054,213069744,213053385,213049893,212902350,212832954,212870493,212852133,212851947,212827146,212821746,212793351,212793222,212793033,212785989,212782050,212726418,212717976,212683806,212649045,212616678,212615103,212582145,212572029,212535837,212534976] · 49.75 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 [212534976,212535837,212572029,212582145,212615103,212616678,212649045,212683806,212717976,212726418,212782050,212785989,212793033,212793222,212793351,212821746,212827146,212851947,212852133,212870493,212902350,213049893,213053385,213069744,213081054,213090771,213091137,213091803,213113313,213113487,213144276,213207282,213221190,213227829,213285456,213292536,213313632,213356622,213356685,213365061,213365373,213400956,213456108,213465738,213483312,213483462,213484692,213500775,213508452] · 28.83 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] · 3.21 ms