2 050 000 ₴
дом, 171 м.кв.
2050000.0
Позика
Знайдено 101 оголошення
{
"query": {
"bool": {
"filter": [
{
"term": {
"city_id": 7085
}
}
]
}
},
"sort": [
{
"data_post": {
"order": "desc"
}
},
{
"id": "desc"
}
],
"from": 50,
"size": 50,
"_source": [
"id",
"m2",
"km",
"price2",
"attribute"
],
"track_total_hits": true
}SELECT c.* FROM `category` c ORDER BY c.id · 2.46 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 ["zaymishche","\/zaymishche","zaymishche\/","\/zaymishche\/"] · 5.06 msSELECT c.id FROM `city` c WHERE c.parent_id = 0 LIMIT 2 · 2.61 msSHOW TABLES · 0.56 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) [205283138,205259180,205191419,204604556,204348191,204291738,203689976,203526815,203399285,203059957,203056279,201889727,201479717,201038986,201026275,199475218,199435063,198492612,197065666,196868165,195915005,195074339,193743896,192902296,191469262,190936737,189877944,189616854,189374787,188823291,188023563,185120169,185058795,184168902,183897290,183648474,181026211,180490918,180485777,179976562,178520755,178292490,178208475,177759748,175245509,175137289,173899972,171800242,171116053,170223535] · 59.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 [170223535,171116053,171800242,173899972,175137289,175245509,177759748,178208475,178292490,178520755,179976562,180485777,180490918,181026211,183648474,183897290,184168902,185058795,185120169,188023563,188823291,189374787,189616854,189877944,190936737,191469262,192902296,193743896,195074339,195915005,196868165,197065666,198492612,199435063,199475218,201026275,201038986,201479717,201889727,203056279,203059957,203399285,203526815,203689976,204291738,204348191,204604556,205191419,205259180,205283138] · 38.6 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] · 1.47 ms