40 000 $
Двокімнатна квартира в ЖК “7 Небо” — заїжджайте хоч сьогодні!
1760000.0
Авангард
Знайдено 7 357 оголошень
{
"query": {
"bool": {
"filter": [
{
"term": {
"city_id": 6208
}
}
]
}
},
"sort": [
{
"data_post": {
"order": "desc"
}
},
{
"id": "desc"
}
],
"from": 4600,
"size": 50,
"_source": [
"id",
"m2",
"km",
"price2",
"attribute"
],
"track_total_hits": true
}SELECT c.* FROM `category` c ORDER BY c.id · 21.28 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 ["avangard","\/avangard","avangard\/","\/avangard\/"] · 4 msSELECT c.id FROM `city` c WHERE c.parent_id = 0 LIMIT 2 · 0.95 msSHOW TABLES · 45.04 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) [197619395,197619077,197614571,197610218,197605013,197602511,197590583,197587301,197587016,197582057,197578613,197577392,197566658,197561861,197557997,197557913,197553719,197544191,197542232,197541521,197539877,197528369,197527220,197525339,197523374,197521847,197518849,197513771,197511020,197509379,197507981,197503496,197503454,197500625,197499890,197498489,197494574,197489453,197487884,197479196,197478758,197478743,197475452,197466365,197465099,197464679,197442895,197442281,197441957,197438817] · 2638.49 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 [197438817,197441957,197442281,197442895,197464679,197465099,197466365,197475452,197478743,197478758,197479196,197487884,197489453,197494574,197498489,197499890,197500625,197503454,197503496,197507981,197509379,197511020,197513771,197518849,197521847,197523374,197525339,197527220,197528369,197539877,197541521,197542232,197544191,197553719,197557913,197557997,197561861,197566658,197577392,197578613,197582057,197587016,197587301,197590583,197602511,197605013,197610218,197614571,197619077,197619395] · 7.33 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] · 2.37 ms