22 223 ₴
долгосрочная аренда Солнечное
22223.0
Сонячне
Знайдено 2 499 оголошень
{
"query": {
"bool": {
"filter": [
{
"term": {
"city_id": 6258
}
}
]
}
},
"sort": [
{
"data_post": {
"order": "desc"
}
},
{
"id": "desc"
}
],
"from": 2050,
"size": 50,
"_source": [
"id",
"m2",
"km",
"price2",
"attribute"
],
"track_total_hits": true
}SELECT c.* FROM `category` c ORDER BY c.id · 18.47 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 ["solnechnoe","\/solnechnoe","solnechnoe\/","\/solnechnoe\/"] · 5.29 msSELECT c.id FROM `city` c WHERE c.parent_id = 0 LIMIT 2 · 3.72 msSHOW TABLES · 1.03 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) [190527594,190453362,190451982,190172292,190138716,190138692,190041579,190026006,189863187,189857235,189842850,189842184,189828948,189746040,189723576,189706779,189706317,189705474,189703410,189699954,189682107,189673098,189668835,189621450,189619545,189583020,189523014,189339714,189309963,189295032,189262782,189237186,189182475,189180234,189129244,189126345,189105036,189091506,189053970,189037596,189016614,188994741,188905053,188752956,188724015,188702175,188354901,188342322,188330526,188266932] · 48.59 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 [188266932,188330526,188342322,188354901,188702175,188724015,188752956,188905053,188994741,189016614,189037596,189053970,189091506,189105036,189126345,189129244,189180234,189182475,189237186,189262782,189295032,189309963,189339714,189523014,189583020,189619545,189621450,189668835,189673098,189682107,189699954,189703410,189705474,189706317,189706779,189723576,189746040,189828948,189842184,189842850,189857235,189863187,190026006,190041579,190138692,190138716,190172292,190451982,190453362,190527594] · 2.12 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.18 ms