35 000 $
продажа провулок 8 березня Люботин Люботин
1540000.0
Люботин
Знайдено 5 394 оголошення
{
"query": {
"bool": {
"filter": [
{
"term": {
"city_id": 3623
}
}
]
}
},
"sort": [
{
"data_post": {
"order": "desc"
}
},
{
"id": "desc"
}
],
"from": 4650,
"size": 50,
"_source": [
"id",
"m2",
"km",
"price2",
"attribute"
],
"track_total_hits": true
}SELECT c.* FROM `category` c ORDER BY c.id · 3.89 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 ["lyubotin","\/lyubotin","lyubotin\/","\/lyubotin\/"] · 2.78 msSELECT c.id FROM `city` c WHERE c.parent_id = 0 LIMIT 2 · 2.57 msSHOW TABLES · 2.84 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) [184483029,184394901,184375779,184370052,184363713,184233504,184212780,184212651,184210308,184198191,184176126,184134975,184130886,184122084,184101549,184095189,184048572,184032702,183965757,183954549,183943022,183943004,183942986,183917240,183822128,183819068,183818774,183815837,183815525,183788567,183788561,183767552,183739766,183735989,183725564,183725195,183724586,183709596,183707598,183658587,183624300,183589560,183588075,183563727,183562461,183545433,183530490,183507831,183496950,183495519] · 206.94 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 [183495519,183496950,183507831,183530490,183545433,183562461,183563727,183588075,183589560,183624300,183658587,183707598,183709596,183724586,183725195,183725564,183735989,183739766,183767552,183788561,183788567,183815525,183815837,183818774,183819068,183822128,183917240,183942986,183943004,183943022,183954549,183965757,184032702,184048572,184095189,184101549,184122084,184130886,184134975,184176126,184198191,184210308,184212651,184212780,184233504,184363713,184370052,184375779,184394901,184483029] · 0.96 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.4 ms