282 492 ₴
долгосрочная аренда Чуднов
282492.0
Чуднов
Знайдено 85 оголошень
{
"query": {
"bool": {
"filter": [
{
"term": {
"city_id": 3572
}
}
]
}
},
"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 · 1.8 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 ["chudnov","\/chudnov","chudnov\/","\/chudnov\/"] · 1.01 msSELECT c.id FROM `city` c WHERE c.parent_id = 0 LIMIT 2 · 0.23 msSHOW TABLES · 1.13 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) [204436004,203647790,203465492,203381498,203319557,203226497,203131540,202964566,202858213,202080613,201433723,201356751,201027280,200720788,199961143,199949221,198509812,196754653,196171223,195934082,193554571,192442174,191921788,191000076,190901073,190303425,189692136,184095648,182081080,181470364,180990328,180235978,180136237,176066265,172540945] · 34.32 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 [172540945,176066265,180136237,180235978,180990328,181470364,182081080,184095648,189692136,190303425,190901073,191000076,191921788,192442174,193554571,195934082,196171223,196754653,198509812,199949221,199961143,200720788,201027280,201356751,201433723,202080613,202858213,202964566,203131540,203226497,203319557,203381498,203465492,203647790,204436004] · 1.91 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.01 ms