310 000 $
Будинок з ремонтом і меблями + гостьовий будинок | Дмитрівка | 180 м2
13640000.0
Дмитровка
Знайдено 1 427 оголошень
{
"query": {
"bool": {
"filter": [
{
"term": {
"city_id": 6272
}
}
]
}
},
"sort": [
{
"data_post": {
"order": "desc"
}
},
{
"id": "desc"
}
],
"from": 750,
"size": 50,
"_source": [
"id",
"m2",
"km",
"price2",
"attribute"
],
"track_total_hits": true
}SELECT c.* FROM `category` c ORDER BY c.id · 2.93 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 ["dmitrovka","\/dmitrovka","dmitrovka\/","\/dmitrovka\/"] · 1.33 msSELECT c.id FROM `city` c WHERE c.parent_id = 0 LIMIT 2 · 0.86 msSHOW TABLES · 0.54 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) [206050262,206034602,206034581,205914143,205874831,205855649,205844696,205782236,205727696,205717367,205653023,205637957,205636718,205636487,205625738,205625681,205616213,205605644,205582106,205579619,205559225,205549547,205492178,205486244,205479833,205470500,205462553,205459748,205459718,205435838,205435799,205435634,205435589,205421870,205404179,205399844,205374533,205359158,205351076,205314170,205310585,205304786,205298612,205298570,205277240,205246352,205238522,205231547,205230944,205229909] · 36.46 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 [205229909,205230944,205231547,205238522,205246352,205277240,205298570,205298612,205304786,205310585,205314170,205351076,205359158,205374533,205399844,205404179,205421870,205435589,205435634,205435799,205435838,205459718,205459748,205462553,205470500,205479833,205486244,205492178,205549547,205559225,205579619,205582106,205605644,205616213,205625681,205625738,205636487,205636718,205637957,205653023,205717367,205727696,205782236,205844696,205855649,205874831,205914143,206034581,206034602,206050262] · 0.87 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] · 0.73 ms