13 217 ₴
долгосрочная аренда Белз
13217.0
Белз
Знайдено 252 оголошення
{
"query": {
"bool": {
"filter": [
{
"term": {
"city_id": 3632
}
}
]
}
},
"sort": [
{
"data_post": {
"order": "desc"
}
},
{
"id": "desc"
}
],
"from": 200,
"size": 50,
"_source": [
"id",
"m2",
"km",
"price2",
"attribute"
],
"track_total_hits": true
}SELECT c.* FROM `category` c ORDER BY c.id · 122.72 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 ["belz","\/belz","belz\/","\/belz\/"] · 7.99 msSELECT c.id FROM `city` c WHERE c.parent_id = 0 LIMIT 2 · 3.93 msSHOW TABLES · 85.22 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) [190521786,190521630,190521618,190517826,190517808,189922617,189920220,189359970,187650288,187467063,187237737,186869763,186073074,186036297,185898597,185854527,185505459,185350611,185155983,184629385,183650586,183566241,182109418,181733569,179726269,179456205,179227147,177172017,176995467,175769092,173273206,173104753,172907353,172631707,172109029,172100494,171079675,171074848,170882188,170557837,170465641,170368129,170361058,170196820,169772353,169362718,169258681,168562504,168235981,168194320] · 300.86 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 [168194320,168235981,168562504,169258681,169362718,169772353,170196820,170361058,170368129,170465641,170557837,170882188,171074848,171079675,172100494,172109029,172631707,172907353,173104753,173273206,175769092,176995467,177172017,179227147,179456205,179726269,181733569,182109418,183566241,183650586,184629385,185155983,185350611,185505459,185854527,185898597,186036297,186073074,186869763,187237737,187467063,187650288,189359970,189920220,189922617,190517808,190517826,190521618,190521630,190521786] · 1.37 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.13 ms