65 000 $
Будинок в с.Модричі/ поблизу Дрогобич і Трускавець
322 м² 2860000.0
Синці
Знайдено 97 оголошень
{
"query": {
"bool": {
"filter": [
{
"term": {
"city_id": 6902
}
}
]
}
},
"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.02 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 ["modrichi","\/modrichi","modrichi\/","\/modrichi\/"] · 1.68 msSELECT c.id FROM `city` c WHERE c.parent_id = 0 LIMIT 2 · 0.46 msSHOW TABLES · 4.29 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) [207671116,207574993,207435427,207003939,206068556,205669835,204593831,203860614,203581451,203272790,203148490,202842331,201762947,200891242,200821873,200746264,200298784,200186266,199786891,198584812,198438227,197565341,197259667,197059099,196655488,196500661,196372160,196171253,195038477,191786071,189582963,186037455,185824959,185136858,184374612,184108182,183686109,182735190,182184130,180508708,174828355,174442939,174091009,173138860,172664053,171154561,167515873] · 116.41 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 [167515873,171154561,172664053,173138860,174091009,174442939,174828355,180508708,182184130,182735190,183686109,184108182,184374612,185136858,185824959,186037455,189582963,191786071,195038477,196171253,196372160,196500661,196655488,197059099,197259667,197565341,198438227,198584812,199786891,200186266,200298784,200746264,200821873,200891242,201762947,202842331,203148490,203272790,203581451,203860614,204593831,205669835,206068556,207003939,207435427,207574993,207671116] · 59.68 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.37 ms